.RE A standard document should be printed using the 'Documentation'
.RE print style on a postscript printer (i.e the Apple Laserwriter)
.RE
.RE IF YOU CHANGE THIS TITLE PAGE, MAKE SURE YOU UPDATE THE
.RE 'DOCUMENT LIBRARY' PROCEDURES MANUAL (CURRENTLY PROCS.3) TO
.RE REFLECT THE CHANGES
.RE ***********************************************************
.FN NORMAL, Helvetica, 12
L................................C.................................M
.PL60
UNIPLEX@@
SSSSSSS
UTECH@@
BBBBB
Utech.008@@
IIIIIIIII
..........L.....................A..L...............................R
Version : 1.2~
Date : 91/07/25~
Document : UTECH.008~
Author :
Authority :
Approval :
Circulation :
.PA
L....................................................................R
.......L...........................................................R.......
Copyright ) 1986-1988 Uniplex Limited. Use, copy and
disclosure restricted by license agreement. All rights
reserved.
UNIPLEXTM and Uniplex II PlusTM are trademarks of Uniplex@@
SSSSSSSJJ JJ
Limited.~
.......L............................C..............................R.......
RESTRICTED RIGHTS LEGEND@@
AAAAAAAAAAAAAAAAAAAAAAAA
.......L.....T.......T.......T.......T.......T.......T.......T.....R.......
Use, duplication, or disclosure by the U.S. Government is
subject to restrictions as set forth in subdivision (b) (3)
(ii) of the Rights in Technical Data and Computer Software
Clause at FAR 52.227-7013. Uniplex Limited, Chaucer House,
4-6 Upper Marlborough Road, St. Albans, Hertfordshire, AL1
3UR England.
.PA
.PL64
L...........R......L............................................A
.HE4
91/07/25 UTECH
~@@
CCCCCCCCCCCCCCCCCCCCCCCCCCCCCCCCCCCCCCCCCCCCCCCCCCCCCCCCCCCCCCCCC[
.HM2
L.............................................R..........................L....A
.FO4
=AAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAA>@@
[[[[[[[[[[[[[[[[[[[[[[[[[[[[[[[[[[[[[[[[[[[[[[[[[[[[[[[[[[[[[[[[[[[[[[[[[[[[[[[
Utech.008 Page #
L.............................................................................M
Confidential and Proprietary
.FM2
.PN1
.RE................(End of Standard Title Pages).................
L.......T.......T.......T.......T.......T.......T.......T.......T....R
.PL62
.UP 1 001 American
.......L......T.......T.......T.......T.......T.......T.......T.......T...M.
L.......T.......T.......T.......T.......T.......T.......T.......T.......M
TABLE OF CONTENTS~@@
HHHHHHHHHHHHHHHHH
.ME /work/ubbs/utis/UTECH.008.toc
.PA
.PN1
.HE4
L....................................................................A
Confidential & Proprietary UNIPLEX Ltd.
@@
CCCCCCCCCCCCCCCCCCCCCCCCCCCCCCCCCCCCCCCCCCCCCCCCCCCCCCCCCCCCCCCCCCCCCC
.FO4
L.................................c..................................A
@@
CCCCCCCCCCCCCCCCCCCCCCCCCCCCCCCCCCCCCCCCCCCCCCCCCCCCCCCCCCCCCCCCCCCCCC
UTECH.008 Spreadsheet - Ucalc@@
IIIIIIIII
09 May 1988 -#- Command/List File Format
L.......T.......T.......T.......T.......T.......T.......T.......T....J
.IC Overview
Overview@@
HHHHHHHH
The Uniplex V6 spreadsheet can read and write 2 formats of file. The
quick format, default save format, is machine specific and cannot
usually be transferred between machines. A second portable file format
is provided, this is usually referred to as a list or command format.
This format is used to move worksheets between machines with different
hardware architectures or for conversion to other spreadsheet file
formats.~
This document describes Uniplex V6 list file format. For more details
refer to the Uniplex II Plus manual set.~
A list file is an ASCII text file which is human readable. The file
is divided into records by the new-line character (\n). Essentially,@@
AA
the List File is in two parts, a header and a body.~
The header part may contain some default format commands for the
spreadsheet and a list of labels (where a label is a name to be
associated with a cell or a range of cells).~
The body of the file contains commands that assign data, text,
formulas and formats to individual cells.~
.PA
.IC Cell Addressing
Cell Addressing@@
HHHHHHHHHHHHHHH
L.......T.......T.......T.......T.......T.......T.......T.......T....R
A spreadsheet cell reference has 2 components, a row value and a
column value.~
Address component Notation~@@
AAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAA
=AAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAA>@@
[[[[[[[[[[[[[[[[[[[[[[[[[[[[[[[[[[[[[[[[[[[[[[[[[[[[[[[[[[[[[[
Relative row address rY - where Y is row 1 to 1024~
r1, r20, r1000~@@
QQQQQQQQQQQQQQ
Relative col address cX - where X is col 1 to 256~
c1, c20, c200~@@
QQQQQQQQQQQQQ
Absolute row address RY~
R1, R20, R1000~@@
QQQQQQQQQQQQQQ
Absolute col address CX~
C1, C20, C200~@@
QQQQQQQQQQQQQ
Cell address rYcX~
r1c1, r10c3, R2C4, r4C7, R8c1~@@
QQQQQQQQQQQQQQQQQQQQQQQQQQQQQ
.IC Range Addressing
Range Addressing@@
HHHHHHHHHHHHHHHH
L.......T.......T.......T.......T.......T.......T.......T.......T....R
A range or area of cells is specified by giving the top left and bottom
right coordinates. An abbreviated notation is used for the common case
where the range varies in one address component only. Relative and
absolute address components may be freely mixed.~
Address type Notation~@@
AAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAA
=AAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAA>@@
[[[[[[[[[[[[[[[[[[[[[[[[[[[[[[[[[[[[[[[[[[[[[[[[[[[[[[[[[[[[[[
Full range rYcX:rYcX~
r1c1:r4c3, r4c1:r5c10~@@
QQQQQQQQQQQQQQQQQQQQQ
Row range rYcX:X~
r10c1:10, r50c30:36~@@
QQQQQQQQQQQQQQQQQQQ
Col range cXrY:Y~
c10r1:10, c30r1:20~@@
QQQQQQQQQQQQQQQQQQQ
Unbounded row rY~
r1, r12, r100~@@
QQQQQQQQQQQQQQ
Unbounded col cX~
c1, c12, c220~@@
QQQQQQQQQQQQQQ
Unbounded row range rY:Y~
r1:3, r5:20~@@
QQQQQQQQQQQQ
Unbounded col range cX:X~
c1:4, c10:20~@@
QQQQQQQQQQQQQ
Note: in practice unbounded ranges are rarely used. The spreadsheet
calculates the current upper bound for an unbounded range before
processing it. So a command to format an entire row will only effect
cells up to the last used column in that row.~
Named Cells or Ranges~
Any range or cell may be named, there is no limit to the number of
names in a single worksheet. A name can be used in any command in
place of a cell or range address. A name is created by the label@@
AAAAA
command and removed by the unlabel command.~@@
AAAAAAA
.PA
.IC Introduction to commands
Introduction to Commands~@@
HHHHHHHHHHHHHHHHHHHHHHHHH
L.......T.......T.......T.......T.......T.......T.......T.......T....R
The list file consists of one command per line. Each command starts
with a unique keyword, the keyword may be abbreviated to the shortest
unique sequence.~
For example the data command may be introduced by either:~
Full keyword data~@@
QQQQQ
or abbreviation d~@@
QQ
Note: for more details on command keywords see the Uniplex V6 @@
IIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIII
configuration manual, this describes the lexical definition@@
IIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIII
file ucdefs.~@@
IIIIIIIIIIII
The command keyword must be separated from the body of the command by
one or more spaces.~
The command body often has 2 components. The first part gives the cell
or range and the second part is the value or formula for that cell.~
Some example commands:~
Command Type Command~@@
AAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAA
=AAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAA>@@
[[[[[[[[[[[[[[[[[[[[[[[[[[[[[[[[[[[[[[[[[[[[[[[[[[[[[[[[[[[[[[
DATA d r2c3=10 ~@@
QQQQQQQQQQ
TITLE t r1c3,March~@@
QQQQQQQQQQQQQ
FORMAT f r1c3 center~@@
QQQQQQQQQQQQQQ
DEFINITION def r10c3=sum(c3r2:9)~@@
QQQQQQQQQQQQQQQQQQQQQQ
LOCK lock r1c3~@@
AAAAAAAAAA
.PA
.IC Spreadsheet Commands
Spreadsheet Commands~@@
HHHHHHHHHHHHHHHHHHHHH
This section describes each command.~
....L...T.......T.......T.......T.......T.......T.......T.......T....R
.IC Spreadsheet Commands > COMMENT (#)
COMMENT (#)~@@
AAAAAAAAAAAA
........L.......T.......T.......T.......T.......T.......T.......T....R
A comment line starts with the character # (hash). All@@
A
following text, up to end of line, is ignored.~
Command Description~@@
AAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAA
=AAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAA>@@
[[[[[[[[[[[[[[[[[[[[[[[[[[[[[[[[[[[[[[[[[[[[[[[[[[[[[[[[[[[[[[
#This is a comment This command line is ignored.~
....L...T.......T.......T.......T.......T.......T.......T.......T....R
.IC Spreadsheet Commands > CURSOR (cu)
CURSOR (cu)~@@
AAAAAAAAAAAA
........L.......T.......T.......T.......T.......T.......T.......T....R
This command moves the cursor to the specified position. This
command is usually put at the end of a List File.~
Command Description~@@
AAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAA
=AAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAA>@@
[[[[[[[[[[[[[[[[[[[[[[[[[[[[[[[[[[[[[[[[[[[[[[[[[[[[[[[[[[[[[[
cu r1c1 moves the cell cursor to r1c1~
....L...T.......T.......T.......T.......T.......T.......T.......T....R
.IC Spreadsheet Commands > COLUMN WIDTH (cw)
COLUMN WIDTH (cw)~@@
AAAAAAAAAAAA AA
........L.......T.......T.......T.......T.......T.......T.......T....R
This command will adjust the display width of column
and default column width in the spreadsheet. The default
column width is used by any column that is not explicitly
assigned a width.~
Command Description~@@
AAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAA
=AAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAA>@@
[[[[[[[[[[[[[[[[[[[[[[[[[[[[[[[[[[[[[[[[[[[[[[[[[[[[[[[[[[[[[[
cw 8 sets the default col width to 8~
cw all 10 set all col widths to 10~
cw c1 10 set col 1 to width 10~
cw c1:10 12 set cols 1 to 10 width 12
Note: The default width is 6. There is always a 2 character@@
IIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIII
gap between columns. So the gap between the lhs of successive@@
IIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIII
columns is width+2.~@@
IIIIIIIIIIIIIIIIIII
....L...T.......T.......T.......T.......T.......T.......T.......T....R
.IC Spreadsheet Commands > DATA (d)
DATA (d)~@@
AAAA A
........L.......T.......T.......T.......T.......T.......T.......T....R
This command will enter a number or expression at a specified
location. See the section Supported functions and operators@@
AAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAA
for a list of operators that may be used with this command.
.PA
Command Description~@@
AAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAA
=AAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAA>@@
[[[[[[[[[[[[[[[[[[[[[[[[[[[[[[[[[[[[[[[[[[[[[[[[[[[[[[[[[[[[[[
d r1c1=1000 assign the value 1000 to r1c1~
d r2c1=87.9 assign the value 87.9 to r2c1~
....L...T.......T.......T.......T.......T.......T.......T.......T....R
.IC Spreadsheet Commands > DEFINE (def)
DEFINE (def)~@@
AAAAAA AAA
........L.......T.......T.......T.......T.......T.......T.......T....R
This command is used to build formulae within the spreadsheet.
The results are determined at calculation time. See the
section Supported functions and operators for a list of@@
AAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAA
operators that may be used with this command.
Command Description~@@
AAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAA
=AAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAA>@@
[[[[[[[[[[[[[[[[[[[[[[[[[[[[[[[[[[[[[[[[[[[[[[[[[[[[[[[[[[[[[[
def r1c7=sum(r1c1:6) formula to sum r1c1:6 into r1c7~
def r1c3=r1c1+r1c2 formula to add r1c1 and r1c2 into r1c3~
....L...T.......T.......T.......T.......T.......T.......T.......T....R
.IC Spreadsheet Commands > FORMAT (f)
FORMAT (f)~@@
AAAAAA A
........L.......T.......T.......T.......T.......T.......T.......T....R
This command is used to set the display format for the
complete spreadsheet or for any part of it. This command does
not effect the contents of a cell, just the way they are
displayed.~
There are 3 types of format command. The first changes the
default format, the second is a global format change and the
third effects a specific range.~
Command Type Description~@@
AAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAA
=AAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAA>@@
[[[[[[[[[[[[[[[[[[[[[[[[[[[[[[[[[[[[[[[[[[[[[[[[[[[[[[[[[[[[[[
f spec set the default format to spec, any@@
IIII IIII
new cells will inherit this format.~
f all spec set all existing cells to spec format.~@@
IIII IIII
f range spec set all cells in range to spec.~@@
IIIIIIIIII IIIII IIII
The format specifier spec is additive. A cell that already@@
IIII
has attributes of 2 decimal places and leading $ may also be
given a bold display effect. An empty spec clears any format@@
IIII
assigned to the cell.~
The default format is as follows:~
Cell Type Default Format~@@
AAAAAAAAAAAAAAAAAAAAAAAAAAAAAA
=AAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAA>@@
[[[[[[[[[[[[[[[[[[[[[[[[[[[[[[[[[[[[[[[[[[[[[[[[[[[[[[[[[[[[[[
Data floating 6 decimal places (trailing zeroes
are not displayed). Right justified.~
Text Left justified.~
The format specifies a string containing any of the
following:~
.PA
Format Specifier Description~@@
AAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAA
=AAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAA>@@
[[[[[[[[[[[[[[[[[[[[[[[[[[[[[[[[[[[[[[[[[[[[[[[[[[[[[[[[[[[[[[
frac N N fixed decimal places~
frac clear fixed decimal, use default~
int display integer part only~
# sterling~
$ dollars~
comma comma sep thousands - 1,234.00~
% Trailing percent~
center center justify~
left left justify~
right right justify~
sci expontial numeric format~
bold bold effect~
double double strike effect~
underscore continuous underline~
ustext underscore text only~
italic italic effect~
large large font~
Configurable Formats (see ucdefs for details)~@@
AAAAAAAAAAAAAAAAAAAA
1 decimal align, floating places~
2 bracket negative values~
3 highlight negative values~
4 hide zero values~
5 invisible format~
datefmt M/D/Y - Uniplex default date format~
datefmt 1 M/D/Y - 5/7/88~
datefmt 2 M/D/Y - 05/07/88~
datefmt 3 day mon D year - Wed Jan 20 1988~
datefmt 9 D-mon-Y - 05-Jan-88~
datefmt 10 D-mon - 05-Jan~
datefmt 11 mon-Y - Jan-88~
datefmt 12 M/D/Y - 01/05/88~
datefmt 13 M/D - 01/05~
....L...T.......T.......T.......T.......T.......T.......T.......T....R
.IC Spreadsheet Commands > NAMING RANGES (label)
NAMING RANGES (label)~@@
AAAAAAAAAAAAA AAAAA
........L.......T.......T.......T.......T.......T.......T.......T....R
This command allows a label to be associated with any cell or
range of cells. This provides a shorthand for referencing the
position in future commands.~
Command Description~@@
AAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAA
=AAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAA>@@
[[[[[[[[[[[[[[[[[[[[[[[[[[[[[[[[[[[[[[[[[[[[[[[[[[[[[[[[[[[[[[
label r1c1:10=Sales names r1c1:10 as "Sales"~
label R1C12=Rate name R1C12 as "Rate"~
....L...T.......T.......T.......T.......T.......T.......T.......T....R
.PA
.IC Spreadsheet Commands > PROTECTING CELL CONTENTS (lock)
PROTECTING CELL CONTENTS (lock)~@@
AAAAAAAAAAAAAAAAAAAAAAAA AAAA
........L.......T.......T.......T.......T.......T.......T.......T....R
This command will lock a cell or range so that it's contents
cannot be changed. Use UNLOCK command to unlock a cell.~
Command Description~@@
AAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAA
=AAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAA>@@
[[[[[[[[[[[[[[[[[[[[[[[[[[[[[[[[[[[[[[[[[[[[[[[[[[[[[[[[[[[[[[
lock all lock all cells in the worksheet~
lock on enable locking~
lock off disable locking~
lock r1c1 set a lock on cell r1c1~
lock r1c1:r4c5 lock all cells in range r1c1:r4c5~
....L...T.......T.......T.......T.......T.......T.......T.......T....R
.IC Spreadsheet Commands > TITLE (t)
TITLE (t)~@@
AAAAA A
........L.......T.......T.......T.......T.......T.......T.......T....R
Text may be placed into worksheet cells, into special row
and column title areas or into 2 worksheet headers.~
Command Description~@@
AAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAA
=AAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAA>@@
[[[[[[[[[[[[[[[[[[[[[[[[[[[[[[[[[[[[[[[[[[[[[[[[[[[[[[[[[[[[[[
t hdr1,Main Heading places text into the main header~
t hdr2,Sub Heading places text into the sub header~
t r1,Row heading places text into the row title area~
t c4,Col heading places text into the col title area~
t r1c1,Cell value places text into cell r1c1~
Note: heading, row and column text is rarely used. The feature@@
IIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIII
is supported for compatibility with older versions of the @@
IIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIII
Uniplex spreadsheet.~@@
IIIIIIIIIIIIIIIIIIII
....L...T.......T.......T.......T.......T.......T.......T.......T....R
.IC Spreadsheet Commands > PRINTING SETUP (set)
PRINTING SETUP (set)~@@
AAAAAAAAAAAAAAA AAA
........L.......T.......T.......T.......T.......T.......T.......T....R
Print setup parameters are saved in the header section of the
list file. The following list contains the most useful
settings, others may be ignored.~
Command Description~@@
AAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAA
=AAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAA>@@
[[[[[[[[[[[[[[[[[[[[[[[[[[[[[[[[[[[[[[[[[[[[[[[[[[[[[[[[[[[[[[
set width N Set page width to N chars~
set length N Set page length to N chars~
set c N Set page width to N worksheet columns.~
set 5 on/off compressed text~
set 6 on/off underlined headers~
set 7 on/off bold row/col titles~
set 9 on/off raw printout (no format information)~
set opt 1 N set left margin indent to N chars~
set opt 2 N set header margin to N chars~
.PA
L.......T.......T.......T.......T.......T.......T.......T.......T....R
.IC Supported Functions and Operators
Supported Functions and Operators~@@
HHHHHHHHHHHHHHHHHHHHHHHHHHHHHHHHH
This section lists ucalc functions and operators, for more details
refer to the Uniplex II Plus User Guide.~
....L...T.......T.......T.......T.......T.......T.......T.......T....R
.IC Supported Functions and Operators > Mathematical Operators
Mathematical operators~@@
AAAAAAAAAAAAAAAAAAAAAA
Operator Description~@@
AAAAAAAAAAAAAAAAAAAAAAAAAAAAAAA
=AAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAA>@@
[[[[[[[[[[[[[[[[[[[[[[[[[[[[[[[[[[[[[[[[[[[[[[[[[[[[[[[[[[[[[
( start nesting~
) end nesting~
% convert to percent~
^ exponentiation~
+,- positive, negative~
*,/ multiplication, division~
+,- addition, subtraction~
& concatenate string~
This list is arranged in order of precedence. Use parentheses to
override the order of precedence.~
.IC Supported Functions and Operators > Logical Operators
Logical Operators~@@
AAAAAAAAAAAAAAAAA
Operator Description~@@
AAAAAAAAAAAAAAAAAAAAAAAAAAAAAAA
=AAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAA>@@
[[[[[[[[[[[[[[[[[[[[[[[[[[[[[[[[[[[[[[[[[[[[[[[[[[[[[[[[[[[[[
== equal to~
< less than~
> greater than~
= not equal~
>= greater than or equal to~
<= less than or equal to
These operators have lower precedence than any mathematical
operator, but all have equal precedence within their group
.IC Supported Functions and Operators > Statistical Functions
Statistical Functions~@@
AAAAAAAAAAAAAAAAAAAAAA
Function Description~@@
AAAAAAAAAAAAAAAAAAAAAAAAAAAAAAA
=AAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAA>@@
[[[[[[[[[[[[[[[[[[[[[[[[[[[[[[[[[[[[[[[[[[[[[[[[[[[[[[[[[[[[[
sum find the sum of a range of nos.~
max find the maximum value in a range~
min find the minimum value in a range~
count count the number of values in a range~
eval evaluate the elements in a list~
avg find the average value in a range~
stdev find the standard deviation of elements~
abs find the sum of absolute values~
.PA
.IC Supported Functions and Operators > Mathematical Functions
Mathematical Functions~@@
AAAAAAAAAAAAAAAAAAAAAAA
Function Decription~@@
AAAAAAAAAAAAAAAAAAAAAAAAAAAAAA
=AAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAA>@@
[[[[[[[[[[[[[[[[[[[[[[[[[[[[[[[[[[[[[[[[[[[[[[[[[[[[[[[[[[[[[
exp calculate the exponential~
log find the natural log of a value~
log10 find the base 10 log of a value~
int find the integer portion of a sum of nos~
mod find the remainder on division~
div find the integer part on division~
root find the sum of square roots~
.IC Supported Functions and Operators > Financial Functions
Financial Functions~@@
AAAAAAAAAAAAAAAAAAAA
Function Description~@@
AAAAAAAAAAAAAAAAAAAAAAAAAAAAAAA
=AAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAA>@@
[[[[[[[[[[[[[[[[[[[[[[[[[[[[[[[[[[[[[[[[[[[[[[[[[[[[[[[[[[[[[
....L...T.......T.....R.L.......T.......T.......T.......T.......T....R
fv~ calculate the equal payment series compound interest~
sink~ calculate the equal payment series sinking fund~
spv~ calculate the single payment present value~
irr~ calculate the rate of return for a
series of cash flows~
npv~ calculate the net present value of~
a series of cash flows~
period~ calculate the depreciation period~
pmt~ calculate the mortgage repayments~
pv~ calculate the present value of a~
series of regular payments~
sfv~ calculate the future value of a~
single payment investment~
rate~ calculate the depreciation rate~
....L...T.......T.......T.......T.......T.......T.......T.......T....R
.IC Supported Functions and Operators > String Manipulation Functions
String Manipulation Functions~@@
AAAAAAAAAAAAAAAAAAAAAAAAAAAAAA
Function Description~@@
AAAAAAAAAAAAAAAAAAAAAAAAAAAAAAA
=AAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAA>@@
[[[[[[[[[[[[[[[[[[[[[[[[[[[[[[[[[[[[[[[[[[[[[[[[[[[[[[[[[[[[[
cmp compare the contents of cells~
len find the length of a text string~
str convert a number to a text string~
fix convert number to a string with a~
specific number of decimal places~
mid extract one text string from another~
val convert a text string to a number~
.PA
.IC Supported Functions and Operators > Date Functions
Date Functions~@@
AAAAAAAAAAAAAAA
Function Description~@@
AAAAAAAAAAAAAAAAAAAAAAAAAAAAAAA
=AAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAA>@@
[[[[[[[[[[[[[[[[[[[[[[[[[[[[[[[[[[[[[[[[[[[[[[[[[[[[[[[[[[[[[
....L...T.......T.....R.L.......T.......T.......T.......T.......T....R
TODAY~ convert today's date to an integer (start 31
Dec 1899)~
day~ calculate the day in the month from an integer
number~
month~ calculate the month number from an integer~
year~ calculate the year number from an integer~
date~ convert the year, month and day to an integer
(start 31 Dec 1899)~
day_mon~ find the number of days in a month
....L...T.......T.......T.......T.......T.......T.......T.......T....R
.IC Supported Functions and Operators > Logical Functions
Logical Functions~@@
AAAAAAAAAAAAAAAAAA
Function Description~@@
AAAAAAAAAAAAAAAAAAAAAAAAAAAAAAA
=AAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAA>@@
[[[[[[[[[[[[[[[[[[[[[[[[[[[[[[[[[[[[[[[[[[[[[[[[[[[[[[[[[[[[[
TRUE truth value 1~
FALSE false value 0~
NOT logical NOT function~
AND logical AND function~
OR logical OR function~
empty test whether cell is empty~
datacell test whether cell contains numeric data~
textcell test whether cell contains text~
defcell test whether cell contains formulae
.IC Supported Functions and Operators > Trigonometric Functions
Trigonometric Functions~@@
AAAAAAAAAAAAAAAAAAAAAAAA
Function Description~@@
AAAAAAAAAAAAAAAAAAAAAAAAAAAAAAA
=AAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAA>@@
[[[[[[[[[[[[[[[[[[[[[[[[[[[[[[[[[[[[[[[[[[[[[[[[[[[[[[[[[[[[[
PI find the PI constant 3.141593~
cos find the cosine of an expression~
sin find the sine of an expression~
tan find the tangent of an expression~
acos find the arc cosine of an expression~
asin find the arc sine of an expression~
atan find the arc tangent of an expression~
atan2 find the 4 quadrant arc tangent of 2 expressions~
deg convert radians to degrees~
rad convert degrees to radians~
.PA
.IC Supported Functions and Operators > External Functions
External Functions~@@
AAAAAAAAAAAAAAAAAAA
Function Description~@@
AAAAAAAAAAAAAAAAAAAAAAAAAAAAAAA
=AAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAA>@@
[[[[[[[[[[[[[[[[[[[[[[[[[[[[[[[[[[[[[[[[[[[[[[[[[[[[[[[[[[[[[
link link spreadsheets~
graph link graphs and their associated data~
sh run a UNIX shell command~
rsh run a shell command and redraw the display~
pipe pipe a sql command to the database~
.IC Supported Functions and Operators > Special Functions
Special Functions~@@
AAAAAAAAAAAAAAAAAA
Function Description~@@
AAAAAAAAAAAAAAAAAAAAAAAAAAAAAAA
=AAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAA>@@
[[[[[[[[[[[[[[[[[[[[[[[[[[[[[[[[[[[[[[[[[[[[[[[[[[[[[[[[[[[[[
ROW find the current row no.~
COL find the current column no.~
lookup find related data from 2 areas~
rnd round a value to specified decimal places~
rand return a random integer~
srand return a random seeded no.~
rpt produce line representation of an expression~
self allow a cell to reference itself~
choose select values from an expression~
index provide indexed reference to cell~
NA value not yet available~
isna trap non-available values in formulae~
ERR force a cell to have an error value~
iserr trap error values in formulae~
.PA
.HE 3
Appendix 1 - example list file~
~@@
CCCCCCCCCCCCCCCCCCCCCCCCCCCCCCCCCCCCCCCCCCCCCCCCCCCCCCCCCCCCCCCCCCCCC
L.......T.......T.......T.......T.......T.......T.......T.......T....R
.IC Appendix 1
Appendix 1~@@
HHHHHHHHHHH
Example List File~
.JN
.FN FX-NORMAL
st on
c off
pre all
v on
lo on
label r17c14=Bottom_Line
label r17c2:13=Gross_Profits
label r9c2:13=Labor
label r8c2:13=Material
label r10c2:13=Overhead
label r5c2:13=Sales
label r12c2:13=Total_Costs
cw all 12
cw title 0
set all
set width 112
set length 42
set c 0
set spacing 1
set opt 1 0
set opt 2 0
set off 1
set off 2
set off 3
set off 4
set off 5
set on 6
set on 7
set on 8
set off 9
t hdr1,Uniplex Ltd. 0000001 UNIPLEX SPREADSHEET vs AP.10 (5.10)
t hdr2,Uniplex Ltd.
cw c1 15
cw c14 15
t r1c1,Date:
f r1c1 $ frac 6 center
t r3c2,January
f r3c2 $ frac 6 center
t r3c3,Feburary
f r3c3 $ frac 6 center
t r3c4,March
f r3c4 $ frac 6 center
t r3c5,April
f r3c5 $ frac 6 center
t r3c6,May
f r3c6 $ frac 6 center
t r3c7,June
f r3c7 $ frac 6 center
t r3c8,July
f r3c8 $ frac 6 center
t r3c9,August
f r3c9 $ frac 6 center
t r3c10,September
f r3c10 $ frac 6 center
t r3c11,October
f r3c11 $ frac 6 center
t r3c12,November
f r3c12 $ frac 6 center
t r3c13,December
f r3c13 $ frac 6 center
t r3c14,Sum
f r3c14 $ frac 6 center
t r5c1,Sales
f r5c1 $ frac 6 center
d r5c2=20000
f r5c2 $ frac 2 center
t r7c1,Costs
f r7c1 $ frac 6 center
t r8c1,Material
f r8c1 $ frac 6 right
d r8c2=4100
f r8c2 $ frac 2 center
t r9c1,Labor
f r9c1 $ frac 6 right
d r9c2=7000
f r9c2 $ frac 2 center
d r9c3=7000
f r9c3 $ frac 2 center
d r9c4=7000
f r9c4 $ frac 2 center
d r9c5=7000
f r9c5 $ frac 2 center
d r9c6=7000
f r9c6 $ frac 2 center
d r9c7=7000
f r9c7 $ frac 2 center
d r9c8=7000
f r9c8 $ frac 2 center
d r9c9=7000
f r9c9 $ frac 2 center
d r9c10=7000
f r9c10 $ frac 2 center
d r9c11=7000
f r9c11 $ frac 2 center
d r9c12=7000
f r9c12 $ frac 2 center
d r9c13=7000
f r9c13 $ frac 2 center
t r10c1,Overhead
f r10c1 $ frac 6 right
d r10c2=4000
f r10c2 $ frac 2 center
d r10c3=4000
f r10c3 $ frac 2 center
d r10c4=5000
f r10c4 $ frac 2 center
d r10c5=4000
f r10c5 $ frac 2 center
d r10c6=4000
f r10c6 $ frac 2 center
d r10c7=4000
f r10c7 $ frac 2 center
d r10c8=4000
f r10c8 $ frac 2 center
d r10c9=4000
f r10c9 $ frac 2 center
d r10c10=4000
f r10c10 $ frac 2 center
d r10c11=4000
f r10c11 $ frac 2 center
d r10c12=4000
f r10c12 $ frac 2 center
d r10c13=4000
f r10c13 $ frac 2 center
f r11c1 right
t r11c2,------------
f r11c2 $ frac 6 center
t r11c3,------------
f r11c3 $ frac 6 center
t r11c4,------------
f r11c4 $ frac 6 center
t r11c5,------------
f r11c5 $ frac 6 center
t r11c6,------------
f r11c6 $ frac 6 center
t r11c7,------------
f r11c7 $ frac 6 center
t r11c8,------------
f r11c8 $ frac 6 center
t r11c9,------------
f r11c9 $ frac 6 center
t r11c10,------------
f r11c10 $ frac 6 center
t r11c11,------------
f r11c11 $ frac 6 center
t r11c12,------------
f r11c12 $ frac 6 center
t r11c13,------------
f r11c13 $ frac 6 center
t r12c1,Total Costs
f r12c1 $ frac 6 right
t r17c1,Gross Profits
f r17c1 $ frac 6 center
t r20c1,Company Tax to Pay:
f r20c1 $ frac 6 center
t r21c1,Profit to Shareholders:
f r21c1 $ frac 6 center
t r21c4,per share!
f r21c4 $ frac 6 center
t r52c1,Creative Accounting Services
f r52c1 $ frac 6 center
t r54c1,Page &P
f r54c1 $ frac 6 center
def r1c2=TODAY
f r1c2 $ datefmt 3 center
def r5c3=r5c2*101.5%
f r5c3 $ frac 2 center
def r5c4=r5c3*101.5%
f r5c4 $ frac 2 center
def r5c5=r5c4*101.5%
f r5c5 $ frac 2 center
def r5c6=r5c5*101.5%
f r5c6 $ frac 2 center
def r5c7=r5c6*101.5%
f r5c7 $ frac 2 center
def r5c8=r5c7*101.5%
f r5c8 $ frac 2 center
def r5c9=r5c8*101.5%
f r5c9 $ frac 2 center
def r5c10=r5c9*101.5%
f r5c10 $ frac 2 center
def r5c11=r5c10*101.5%
f r5c11 $ frac 2 center
def r5c12=r5c11*101.5%
f r5c12 $ frac 2 center
def r5c13=r5c12*101.5%
f r5c13 $ frac 2 center
def r5c14=sum(Sales)
f r5c14 $ frac 2 center
def r8c3=r8c2*100.5%
f r8c3 $ frac 2 center
def r8c4=r8c3*100.5%
f r8c4 $ frac 2 center
def r8c5=r8c4*100.5%
f r8c5 $ frac 2 center
def r8c6=r8c5*100.5%
f r8c6 $ frac 2 center
def r8c7=r8c6*100.5%
f r8c7 $ frac 2 center
def r8c8=r8c7*100.5%
f r8c8 $ frac 2 center
def r8c9=r8c8*100.5%
f r8c9 $ frac 2 center
def r8c10=r8c9*100.5%
f r8c10 $ frac 2 center
def r8c11=r8c10*100.5%
f r8c11 $ frac 2 center
def r8c12=r8c11*100.5%
f r8c12 $ frac 2 center
def r8c13=r8c12*100.5%
f r8c13 $ frac 2 center
def r8c14=sum(Material)
f r8c14 $ frac 2 center
def r9c14=sum(Labor)
f r9c14 $ frac 2 center
def r10c14=sum(Overhead)
f r10c14 $ frac 2 center
def r12c2=r8c2+r9c2+r10c2
f r12c2 $ frac 2 center
def r12c3=r8c3+r9c3+r10c3
f r12c3 $ frac 2 center
def r12c4=r8c4+r9c4+r10c4
f r12c4 $ frac 2 center
def r12c5=r8c5+r9c5+r10c5
f r12c5 $ frac 2 center
def r12c6=r8c6+r9c6+r10c6
f r12c6 $ frac 2 center
def r12c7=r8c7+r9c7+r10c7
f r12c7 $ frac 2 center
def r12c8=r8c8+r9c8+r10c8
f r12c8 $ frac 2 center
def r12c9=r8c9+r9c9+r10c9
f r12c9 $ frac 2 center
def r12c10=r8c10+r9c10+r10c10
f r12c10 $ frac 2 center
def r12c11=r8c11+r9c11+r10c11
f r12c11 $ frac 2 center
def r12c12=r8c12+r9c12+r10c12
f r12c12 $ frac 2 center
def r12c13=r8c13+r9c13+r10c13
f r12c13 $ frac 2 center
def r12c14=r8c14+r9c14+r10c14
f r12c14 $ frac 2 center
def r17c2=r5c2-r12c2
f r17c2 $ frac 2 center
def r17c3=r5c3-r12c3
f r17c3 $ frac 2 center
def r17c4=r5c4-r12c4
f r17c4 $ frac 2 center
def r17c5=r5c5-r12c5
f r17c5 $ frac 2 center
def r17c6=r5c6-r12c6
f r17c6 $ frac 2 center
def r17c7=r5c7-r12c7
f r17c7 $ frac 2 center
def r17c8=r5c8-r12c8
f r17c8 $ frac 2 center
def r17c9=r5c9-r12c9
f r17c9 $ frac 2 center
def r17c10=r5c10-r12c10
f r17c10 $ frac 2 center
def r17c11=r5c11-r12c11
f r17c11 $ frac 2 center
def r17c12=r5c12-r12c12
f r17c12 $ frac 2 center
def r17c13=r5c13-r12c13
f r17c13 $ frac 2 center
def Bottom_Line=sum(Gross_Profits)
f Bottom_Line $ frac 2 center
def r20c3=Bottom_Line*PI*123%/15-444.9+root(PI)
f r20c3 $ frac 2 center
def r21c3=sin(cos(tan(r20c3)))
f r21c3 $ frac 2 center
cu r1c1
.FN NORMAL
.JY