What's
new in Version 1.4
The big change for version 1.4
is that formulas now allow numeric values mixed in with the cell
references. This change has greatly increased the
flexibility of the functions but comes with some obvious
limitations. The cell units are only applied to numeric
values in a formula that are simple addends. Any numeric
values in brackets or if they are used to create a product or
quotient will have not units applied to them. For example,
a formula like =1.3+C7 (meters) will take the value in C7 and
convert it to meters and add 1.3 meters. This is the only
type of numeric value that can accept cell units. Any
other numeric value in a cell formula will not have units
applied.
This version also has some more
subtle changes. Superscripts and subscripts are now
available in text cells. Text cells can also accommodate
extended ASCII characters. Both of these features can be
accessed from the formula bar popup menu (right click on the
formula bar to access).
In addition, TechSheet can now
delete columns or rows from the main menu under the edit
selection. And finally there is an undo function that
keeps track of up to ten most recent edit changes. This is
also accessed from the edit selection of the main menu, or by
pressing ctrl-z.
Due to some changes in the file
format, there have been some problems importing files from
version 1.0. Most of these problems can be overcome if the
cell formatting is removed (set to the default) and saving in
version 1., then the file can be opened in version 1.4 (or
version 1.4) with little or no problems.
What's
New in Version 1.3
Version 1.3 is the
most extensive upgrade to TechSheet Yet, making it both more
powerful and easier to use. TechSheet now has a maximum of
six sheets per workbook (up from four) and allows cell
references from other sheets. The file formatting has been
changed and the files are now saved in more compact format.
The most visual change from earlier versions is the addition of
speed buttons. The buttons allow you to quickly format
cells, do basic file manipulations and add lines around the
cells to change the spreadsheet appearance.
There are two new cell
format types, comma delimited and chemical. The comma
delimited is simply a numeric format that inserts commas to make
large values more readable. The chemical
format allows you to enter a chemical formula and it will be
displayed with the appropriate numbers subscripted.
The most significant
change to the functionality is the addition of eleven new
functions. Many of the functions strip away the units
before they are executed. This is a logical requirement to
maintain unit consistency (i.e. the natural log of a velocity
does not result in any local unit of measure. Other
functions like sum and square toot do use units but require that
they be used in a logical manner.
Due to some changes in
the file format, there have been some problems importing files
from version 1.0. Most of these problems can be overcome
if the cell formatting is removed (set to the default) and saved
in version 1.0, then the file can be opened in version 1.3 with
little or no problems.
