|
DataMuseum.dkPresents historical artifacts from the history of: Regnecentalen RC-900 |
This is an automatic "excavation" of a thematic subset of
See our Wiki for more about Regnecentalen RC-900 Excavated with: AutoArchaeologist - Free & Open Source Software. |
top - metrics - downloadIndex: T U i
Length: 101869 (0x18ded)
Types: TextFile
Notes: UNIX file
Names: »issi.help«
└─⟦bee8f15db⟧ Bits:30004169/disk2.imd Uniplex II+ V.6 release 1.0 (dansk)
└─⟦bee8f15db⟧ UNIX Filesystem
└─⟦this⟧ »up/new/usr/UAP/uc/issi.help«
*#SSBASIC,STANDARD 3454
*#SSMENU 6635
*#SSQUICK 7925
*#SSFUNCT 9459
*#SSPOINT,cursor 11645
*#SSADDRESS1 13086
*#SSADDRESS2 13752
*#SSADDRESS3 14342
*#SSADDRESS4 14829
*#SSENUMS,number,data,init,input 18776
*#SSEDATES 19852
*#SSCOMS 20728
*#SSFORM1,equal,define 23661
*#SSFORM2 26513
*#SSFORM3 27091
*#SSTEXT1,quote 27474
*#SSTEXT2 28151
*#SSTEXT3 29029
*#SSTEXT4,title 29781
*#SSTEXT5 30651
*#SSCALCULATE1,calculate 31057
*#SSCALCULATE2 31575
*#SSCALCULATE3 31954
*#SSCALCULATE4 32249
*#SSCALCULATE5 32886
*#SSCOPY1,copy 33449
*#SSCOPY2,move 34337
*#SSCOPY3,cut&paste 35437
*#SSEDIT1,edit 38291
*#SSEDIT2,insert 38861
*#SSEDIT3,delete 39516
*#SSEDIT4,kill 40222
*#SSEDIT5 40840
*#SSFORMAT1 41407
*#SSFORMAT2,format 42160
*#SSFORMAT3 42643
*#SSFORMAT4 43505
*#SSFORMAT5,cwidth 44320
*#SSNAME1,labels 44853
*#SSNAME2 45220
*#SSNAME3 45565
*#SSNAME4,macros 46903
*#SSPROTECT,lock,unlock 47958
*#SSWINDOW1,split,window 49571
*#SSWINDOW2 50793
*#SSWINDOW3 51016
*#SSWINDOW4,unsplit 52111
*#SSSAVE1,save 52480
*#SSSAVE2,list 53015
*#SSSAVE3 53766
*#SSSAVE4 54203
*#SSSAVE5,get 54622
*#SSSAVE6,use 56162
*#SSPRINT1,print 56452
*#SSPRINT2 56983
*#SSPRINT3 57771
*#SSPRINT4 58212
*#SSPRINT5 58786
*#SSPRINT6 59306
*#SSPRINT7 59753
*#SSPRINT8 60404
*#SSQUIT1 61003
*#SSQUIT2 61514
*#SSQUIT3,zero 62192
*#SSGRAPH1,graph 62827
*#SSGRAPH2 63502
*#SSGRAPH3 63983
*#SSEMULATE 65807
*#SSSTAT1,sum 67260
*#SSSTAT2,max 67716
*#SSSTAT3,min 67949
*#SSSTAT4,count 68144
*#SSSTAT8,eval 68520
*#SSSTAT5,avg 69176
*#SSSTAT6,stdev 69563
*#SSSTAT7,abs 69768
*#SSSTAT9,where 69954
*#SSMATH1,exp 70504
*#SSMATH2,log 70842
*#SSMATH3,log10 71010
*#SSMATH4,int 71320
*#SSMATH5,mod 71497
*#SSMATH6,div 72241
*#SSMATH7,root 72652
*#SSFINANCE1,fv 72837
*#SSFINANCE2,sink 73533
*#SSFINANCE3,spv 74269
*#SSFINANCE4,irr 75095
*#SSFINANCE5,npv 76867
*#SSFINANCE6,period 77981
*#SSFINANCE7,pmt 78834
*#SSFINANCE8,pv 79530
*#SSFINANCE9,sfv 80562
*#SSFINANCE10,rate 81154
*#SSSTRING1,cmp 81802
*#SSSTRING2,len 82326
*#SSSTRING3,str 82661
*#SSSTRING4,mid 83536
*#SSSTRING5,val 84017
*#SSSTRING6,lit 84475
*#SSDATE1,today 84852
*#SSDATE2,day 85228
*#SSDATE3,month 85531
*#SSDATE4,year 85820
*#SSDATE5,date 86097
*#SSDATE6,day_mon 86570
*#SSLOGIC1,if 87121
*#SSLOGIC2,true,false 88180
*#SSLOGIC3,not 88562
*#SSLOGIC3,or 88842
*#SSLOGIC4,and 89391
*#SSLOGIC5,empty,datacell,textcell,defcell 89972
*#SSTRIG,pi,cos,sin,tan,acos,asin,atan,deg,rad 90467
*#SSEXT1,link 91215
*#SSEXT2,graph 92984
*#SSEXT3,sh 93625
*#SSEXT4,rsh 93964
*#SSEXT5,pipe,db 94239
*#SSSPECIAL1,row,col 95007
*#SSSPECIAL2,lookup 95198
*#SSSPECIAL3,rnd 95772
*#SSSPECIAL4,rand 96246
*#SSSPECIAL5,rpt 97139
*#SSSPECIAL6,self 97666
*#SSSPECIAL7,index 98025
*#SSSPECIAL7,na,isna 98487
*#SSSPECIAL9,err,iserr 99394
*#SSSPECIAL10,choose 100358
*#SPREADSHEET_MENU 100654
*#GEN_RECORD 100993
******
* File: uc/issi.help
* Release: 6.00
* Date: 9 Dec 1987
*
*MODS:
* 9/Dec/87 - Added #GEN_RECORD
******
.PL18
#SSBASIC,STANDARD
BASIC SKILLS AND CONCEPTS
Summary of Commands
VALUE: Enter the number or expression and press a cursor key.
TEXT: enter the text and press a cursor key.
FORMULA: Press =,+ or @ to start and then enter the formula.
COMMAND: Press / to start and then follow the menus and prompts.
.PA
Ranges
Often when entering commands Uniplex prompts you to enter a
range. You can use the following commands:
. (dot char): Extends the range. For example, A1 --> A1..A1
Arrow keys: Moves the screen cursor and displays new position.
Delete key: Takes you back one step. For example, A1..D4 --> A1, or
A1 --> back to menu.
SPACEBAR: Re-selects the last range entered
~ (tilde): Displays range names.
When entering formulae, for example @sum(A1..A4), enter the range
using the range entry commands above.
Entering Values
Any entry that starts with 0-9 or . is taken as a numeric value. The
value is entered into the current cell and removes any previous contents
of that cell. You can enter values in any of the following formats:
101 (a whole number)
4.5 (a decimal value)
-8 (a negative value)
3.4e6 (scientific notation)
.PA
TEXT
Any entry that starts with a normal alphabetic or quote character is text.
The text is entered into the current cell and removes any previous
contents of that cell. Text may overlap cells to the right, for example
if you are entering characters. Uniplex treats all of the following
entries as text:
January normal text is left aligned
'January ' forces left alignment
"January " forces right alignment
^January ^ forces center alignment
\= \ repeats text, fill cell with =
.PA
Formulae
You must preface formula with one of the following characters:
@ = +
To enter a formula, follow these steps:
..H..L....T......T......T.......T.......T.......T...........................R..
1 Move the cell pointer to the position where you want to enter the
formula.
2 Begin the formula you want to enter. For example: =sum(
3 Move the cell pointer to the first point in the range. Uniplex displays
the current cell address as the first point in the range. For example:
=sum(C5
4 Enter a period (.). Uniplex extends the range. For example:
=sum(C5..C5
5 Move the cell pointer to the end point of the range and press ).
..L.............................T.......T.......T...........................R..
As you move the cell pointer, Uniplex highlights the range on the screen.
When you press ) Uniplex enters the cell address of the current cell in the
command line. For example: =sum(C5..G10)
6 Complete the formula by pressing RETURN.
.PA
COMMANDS
To start a command press /.
Uniplex displays the command menu towards the top of the screen.
Pick and point the menu option you require, by moving the SPACEBAR and
pressing RETURN, or pressing the initial letter of the option you require.
For more details about the structure of the command menu, see Menu
Structure.
))
.PA
#SSMENU
EXPLANATION OF COMMAND MENU
You use the Uniplex command menu to perform tasks with the data in the
spreadsheet. For example, you can delete information or move it to another
part of the spreadsheet. You can also insert or delete rows or columns, or
change the column widths.
When you type slash (/), Uniplex displays the command menu on the command
lines of the screen. For example:
Worksheet Range Copy Move File Print Graph Data Integrate Quit
Global, Insert, Delete, Column, Erase, Titles, Window, Modes
The Worksheet option is highlighted on the screen.
.PA
The top line of the menu shows the main menu options.
The second line of the menu shows the sub-menu attached to the highlighted
option. When you first access the menu, the Worksheet sub-menu is
displayed on the second line.
You can move the highlight along the menu using the left and right arrow
keys or SPACEBAR. As each option is highlighted, a sub-menu or prompt for
that option is displayed below.
To select an option from the menu, either use the arrow keys to move the
cursor to the option of your choice, then press RETURN, or Enter the
initial letter of the menu option you require. For example, if you want to
use the Worksheet options, enter W.
))
.PA
#SSQUICK
SUMMARY OF COMMANDS
MOVE THE CELL POINTER
Move: Screen left edge ESC left arrow
Move: Screen right edge ESC right arrow
Move: Screen top ESC up arrow
Move: Screen bottom ESC down arrow
Scroll: Screen left ESC ESC left arrow
Scroll: Screen right ESC ESC right arrow
Scroll: Screen up CTRL u
Scroll: Screen down CTRL d
CREATE FORMULAE
Preface all formulae with =, +.
Preface functions with =, +, @.
..L..................................R..L.................................R....
SPREADSHEET COMMANDS
Create titles and headings /wt Format (range) /rf
Calculate /wgr Names /rn
Copy /c Locking (global) /wgp
Move /m Locking (range) /rp
Cut (top left) ESC ( Windows /ww
Cut (bottom right) ESC ) Integrate database,desk /i1
Paste ESC * Save and retrieve /f
Insert /wi Print /p
Delete (global) /wd Clear spreadsheet /wge
Delete (range) /re Quit ESC q
Sort /ds Set values to zero /dz
Format (global) /wgf
..L.....................T.......T.......T.......T...........................R..
#SSFUNCT
SUMMARY OF FUNCTIONS
In the following sections, UPPER case letters are used to indicate
variables, and lower case letters to indicate the entry you should make.
..L.....................................R....L..T...........................R..
FINANCIAL FUNCTIONS LOGICAL FUNCTIONS
fv(AMOUNTS,RATE,PERIODS) TRUE()
sink(AMOUNT,RATE,PERIOD) FALSE()
spv(AMOUNT,RATE,PERIOD) NOT()
irr(GUESS_RATE,LIST_OF_AMOUNTS) empty(CELL)
npv(DISCOUNT_RATE,RANGE) textcell(CELL)
period(START_AMOUNT,FINAL_AMOUNT,RATE) defcell(CELL)
pmt(PRINCIPAL,INTEREST,PERIOD)
pv(AMOUNT,RATE,PERIODS)
sfv(AMOUNT,RATE,PERIODS)
rate(START_AMOUNT,FINAL_AMOUNT,PERIOD)
MATHEMATICAL FUNCTIONS TRIGONOMETRIC FUNCTIONS
exp(EXPR) PI@@
I
index(POINT,EXPR1,EXPR2) tan(EXPR)
int(EXPR) cos(EXPR)
mod(NUMBER,DIVISOR) sin(EXPR)
div(EXPR,EXPR) tangent atan (EXPR)
root(EXPR) acos(EXPR)
log(EXPR) asin(EXPR)
log10(EXPR) atan2(EXPR)
deg(EXPR)
EXTERNAL FUNCTIONS rad(EXPR)
Link("DATA_SOURCE_
COMMAND")
.PA
STATISTICAL FUNCTIONS MISCELLANEOUS FUNCTIONS
sum(EXPR) ROW()
max(EXPR) COL()
min(EXPR) lookup(EXPR,AREA,AREA)
count(EXPR) rnd(VALUE,PLACES)
int(af(RANGE)) rand(INTEGER)
stdev(EXPR) srand()
rpt("CHAR",EXPR)
STRING MANIPULATION
cmp(EXPR1,EXPR2)
len(EXPR)
str(EXPR)
fix(EXPR,DECIMAL PLACES)
mid(STRING,START POSITION,LENGTH)
))
..L.....................T.......T.......T.......T...........................R..
#SSPOINT,cursor
MOVING THE CELL POINTER
You can move the cell pointer around the spreadsheet. The movement
commands only move the cell pointer, they do not affect any values in the
spreadsheet. The following table shows the keys to press to move the cell
pointer:
..H...............L.............T.......T.......T...........................R..
Arrow keys One cell in the specified direction
TAB One screen to the right
BACKTAB/CTRL g One screen to the left
ESC arrow key If current cell is empty, moves in the specified direction
until it finds a cell with data. If current cell has data,
moves in the specified direction until it finds an empty
cell.
.PA
..L.............................T.......T.......T...........................R..
SCROLL THE SPREADSHEET SCREEN
Since you can only display a small portion of the spreadsheet on the screen
at one time, Uniplex can scroll the spreadsheet:
..H.......................L.....T.......T.......T...........................R..
ESC ESC left arrow Scroll the spreadsheet one screenful to the left.
or TAB
ESC ESC right arrow Scroll the spreadsheet one screenful to the right
or BACKTAB
ESC ESC up arrow Scroll the spreadsheet up one screenful
or CTRL u
ESC ESC down arrow Scroll the spreadsheet down one screenful
or CTRL d screenful.
))
#SSADDRESS1
RELATIVE ADDRESSING
The most common way to address any cell, or group of related cells, is by
using a letter to indicate the column and a number to indicate the row you
are referring to.
Uniplex uses cell references to calculate formulae. If the value in a cell
changes, the formula is still correctly calculated. Use a relative address
to refer to the position of a cell in relation to the cell that contains
the formula.
Relative addresses are automatically adjusted when a cell is copied. For
example, if cell A6 contains the formula A5+1, if you copy the contents of
A6 to B6, then the formula is adjusted to B5+1.
))
.PA
#SSADDRESS2
ABSOLUTE ADDRESSING
You need Uniplex to recognize formulae that contain references to specific
cells even if they, or the cell containing the formula, are moved or copied
in the spreadsheet. You do this using an absolute reference. You define
an absolute reference by prefixing both the column name and the row name
with a $ sign.
For example: $A$2
If the cell A6 contains the formula, $A$5+1, and you copy the contents of
A6 to B6, the formula remains $A$5+1.
Pressing F3(ABS) automatically converts relative addresses to absolute
addresses.
))
.PA
#SSADDRESS3
MIXED ADDRESSING
You can include mixed absolute and relative references. For example, B$4
is a mixed address referencing absolute row 4, relative column B. Use a
mixed address to make a cell reference part relative part absolute. Either
the column name or the row name remains constant.
For example, if cell A6 contains the formula $A5+1 and you copy A6 to B6,
the formula remains $A5+1. However, if you copy A6 to A7, the formula
becomes $A6+1.
))
.PA
#SSADDRESS4
RANGES
A range is a group of adjacent cells in the spreadsheet. You can enter
ranges in three different ways:
..H..L..........................T.......T.......T...........................R..
o Enter the full cell address
.....L..........................T.......T.......T...........................R..
You enter the address of the first cell in the range and the last cell,
separating them with one or two periods. For example: B4..B8
Alternatively, you can specify the start cell of the range and only the
end column or row. For example: B4..8 and B4..F
.PA
..H..L..........................T.......T.......T...........................R..
o Highlight the range using the cell pointer
.....L..........................T.......T.......T...........................R..
You can only use this method when you are entering a range as part of a
formula or when you are prompted to enter a range during a command:
.....H..L...............T.......T.......T.......T...........................R..
a) Begin the formula you want to enter. For example: =sum(
b) Move the cell pointer to the first point in the range. Uniplex
displays the current cell address as the first point in the range.
c) Enter a period (.). Uniplex extends the range. For example:
=sum(C5..C5
d) Move the cell pointer to the end point of the range and press ).
..L.............................T.......T.......T...........................R..
.PA
..H..L..........................T.......T.......T...........................R..
o Refer to a range using a name
.....L..........................T.......T.......T...........................R..
You can name a range, and use the name to refer to the range. You can
give a range a name that reflects the contents of the range. For
example, if a row of entries contains the sales figures for each month,
you can name the range, sales.
..L.......T......T......T.......T.......T.......T...........................R..
Define Ranges within Commands:
When you use commands which require you to define a range, Uniplex
automatically enters a default range. For example, Uniplex displays:
Enter range to copy FROM: A1..A1
Uniplex automatically enters the current cell as both the start and end
point of the range.
.PA
To change the beginning point of the range:
..H..L....T......T......T.......T.......T.......T...........................R..
o Press the DELETE key
To extend the range:
o Press period (.)
..L.......T......T......T.......T.......T.......T...........................R..
You can change the end point of the range in one of two ways. Either:
..H..L....T......T......T.......T.......T.......T...........................R..
o Move the cell pointer to the cell you require to define the end of the
range and press RETURN.
o Type in the cell address of the end point of the range.
..L.......T......T......T.......T.......T.......T...........................R..
To re-select the last range entered:
..H..L....T......T......T.......T.......T.......T...........................R..
o Press the SPACEBAR
..L.......T......T......T.......T.......T.......T...........................R..
Use Absolute and Mixed Addresssing in Ranges
When Uniplex enters a range in a command, it uses relative addressing by
default. You can change the address to an absolute or a mixed address.
You do this in one of two ways. Either:
..H..L....T......T......T.......T.......T.......T...........................R..
o Type in the absolute or mixed address of the cells at both ends of the
range, prefacing the column, the row, or both with a dollar ($) sign.
o Select the range you want either by entering the addresses of the cells,
or highlighting the range. Press F3 (ABS)
))
.PA
..L.....................T.......T.......T.......T...........................R..
#SSENUMS,number,data,init,input
ENTERING NUMBERS
To enter a number into the current cell:
..H..L...........T......T.......T.......T.......T...........................R..
1 Position the cell pointer at the cell where you want the number entered.
2 Enter the number.
3 Press RETURN to place the number in the current cell.
Or: Press the up, down or right arrow key to place the text in the current
cell and move the cell pointer one cell in the specified direction.
.PA
Uniplex recognizes any entry that starts with 0 to 9, a minus (-) or a
period (.) as a numeric value. Numeric data must contain only the numbers
0 to 9, the decimal point and the minus sign.
You can preface numbers with currency symbols (for example, dollar ($) and
pound (#) signs), or enter a percentage symbol (%) after the number. In
addition, you can include commas, or enter numbers in scientific format.
For example, Uniplex recognizes numbers in all of the following formats:
10.2 1,234.5 $200 #400
3.5e6 15%
))
.PA
#SSEDATES
ENTERING DATES
You can enter dates into the spreadsheet using the standard Uniplex date
format:
..H..L...........T......T.......T.......T.......T...........................R..
1 Move the cell pointer to the cell where you want the date.
2 Enter the date using the format MM/DD/YY For example: 8/5/87
3 Press RETURN to place the date in the current cell.
Or: Press an arrow key to place the date in the current cell and move the
cell pointer one cell in the specified direction.
..L..............T......T.......T.......T.......T...........................R..
Uniplex enters the date into the spreadsheet. Uniplex stores dates as the
number of days since January 1st 1900. You can perform advanced
calculations on dates using Uniplex functions.
))
.PA
..L.....................T.......T.......T.......T...........................R..
#SSCOMS
USING SPREADSHEET COMMANDS
You invoke all Uniplex spreadsheet commands using the command menu. You
can access the command menu at any time while the spreadsheet is waiting
for input and UNIPLEX is displayed on the status line.
To access the command menu:
o Press /
Uniplex displays the command menu towards the top of the screen. The
Worksheet option is highlighted on the screen. The top line of the menu
shows the main menu options. The second line of the menu shows the
sub-menu attached to the highlighted option. When you first access the
menu, the Worksheet sub-menu is displayed on the second line.
You can move the highlight along the menu using the left and right arrow
keys. As each option is highlighted, a sub-menu or prompt for that option
is displayed below.
The menu groups related commands together to enable you to find the
commands you want to use quickly and easily. For example, all the commands
to save and retrieve spreadsheets are found in the File sub-menu.
If you want to perform a task on the entire spreadsheet, for example, you
want to re-format the spreadsheet in a particular way, the commands are
generally found in the Global sub-menu.
If you want to perform a task on only a portion of the spreadsheet, for
example, you want to re-format one column of the spreadsheet, the commands
are generally found in the Range sub-menu.
.PA
You pick and point options from the menu. Either:
..H..L....T......T......T.......T.......T.......T...........................R..
o Use the arrow keys
.....L....T......T......T.......T.......T.......T...........................R..
Use the left and right arrow keys to move the highlight over the option
of your choice. When the option of your choice is highlighted, press
RETURN.
..H..L....T......T......T.......T.......T.......T...........................R..
o Enter the initial letter of the option
.....L....T......T......T.......T.......T.......T...........................R..
You can enter the initial letter of the option you require. For
example, if you require the Worksheet option, press W. You can enter
lower or upper case letters.
..L.......T......T......T.......T.......T.......T...........................R..
Uniplex spreadsheet uses a hierarchical menu structure. Each main menu
option has a sub-menu attached to it. Often sub-menus have additional
sub-menus below them, or display a prompt on the screen. Sub-menus and
screen prompts are always displayed on the line below the current menu.
You can move between different levels and sub-menus and view the various
options available:
..H..L....T......T......T.......T.......T.......T...........................R..
o Press the Delete key to go back to the previous level of menu.
))
.PA
..L.....................T.......T.......T.......T...........................R..
#SSFORM1,equal,define
ENTER A FORMULA
To enter a formula in the current cell:
..H..L....T......T......T.......T.......T.......T...........................R..
1 Position the cell pointer at the cell you want to contain the formula.
2 Enter =, +, or @
.....L....T......T......T.......T.......T.......T...........................R..
If you enter a @ symbol, you must follow it immediately with a Uniplex
function.
..H..L....T......T......T.......T.......T.......T...........................R..
3 Enter the formula and press RETURN.
.PA
..L.......T......T......T.......T.......T.......T...........................R..
You calculate the data in your spreadsheet using formulae. Formulae can
contain the standard mathematical functions, operators and the set of
functions provided with the spreadsheet. These functions include logical,
trigonometric and financial functions.
You enter formulae into cells and reference the data you want by using cell
addressing, absolute values or named ranges.
By using formulae, you can perform complex calculations quickly and easily,
enabling you to perform 'what if' projections simply and efficiently.
By building spreadsheets with formulae, you can reuse the spreadsheets.
That is, they are not just applicable to one set of data. So, for example,
if you have a weekly calculating task, you can create a formula to carry it
out.
You can enter a formula directly on the command line and place the result
into a cell. However, the more common way to use formulae is to create a
formula in a cell that expresses relationships with other cells.
You create formulae using standard mathematical rules, and by using the
functions provided by the spreadsheet. There are certain syntactical rules
to follow when you use each function. Where valid, you can use functions
together.
A formula, also known as an expression (expr), is constructed of the
following:
..H................L....T.......T.......T.......T...........................R..
Cell Addresses: These can be single cell addresses, ranges of addresses,
or names referring to addresses.
Operators: You can use mathematical and logical operators within
formulae.
Functions: Uniplex provides a wide range of spreadsheet functions.
.PA
Cell addresses in formulae can be relative, absolute or mixed. Use a
relative address to refer to the position of a cell in relation to the cell
that contains the formula. Use an absolute address to refer to the same
cell, no matter where you copy the formula to. Use a mixed address to make
a cell reference that is part relative, part absolute; either the column
or row remains constant.
))
.PA
..L.....................T.......T.......T.......T...........................R..
#SSFORM2
MATHEMATICAL OPERATORS
You can use the following standard mathematical operators within formulae:
( start nesting
) end nesting
% Convert to percent
^ Exponentiation
+,- Positive, Negative
*,/ Multiplication, Division
+,- Addition, Subtraction
& Concatenate string
This list is arranged in order of precedence; operators with the highest
order at the top, operators with the same order on the same line. Use
parentheses to override the order of precedence.
))
.PA
#SSFORM3
LOGICAL OPERATORS
You can use the following logical operators within formulae:
== equal to
< less than
> greater than
!= not equal
>= greater than or equal to
<= Less than or equal to
Logical operators have lower precedence than any mathematical operator, but
all have equal precedence within their group.
))
.PA
#SSTEXT1,quote
ENTER TEXT INTO CURRENT CELL
You can enter text into any cell. You can enter text that is longer than
the width of an individual cell. To enter text into the current cell:
..H..L....T......T......T.......T.......T.......T...........................R..
1 Position the cell pointer at the cell where you want the text.
2 Type in the text you require.
3 Press RETURN to place the text in the current cell.
Or: Press the up, down or right arrow key to place the text in the current
cell and move the cell pointer one cell in the specified direction.
))
.PA
..L.....................T.......T.......T.......T...........................R..
#SSTEXT2
REPEATING TEXT
You can repeat text across the spreadsheet using a single command. This is
particularly useful for repeating the -, _ or = characters used to separate
data from totals in the spreadsheet:
..H..L....T......T......T.......T.......T.......T...........................R..
1 Move the cell pointer to the point where the repeated text is required.
2 Enter :<char>{c}{*,<n>}
.....H.....L............................T.......T...........................R..
: repeats a character across a cell
char is the character you want to repeat
c repeats the character across a specified number of columns
* is the option to repeat the character across the entire row
n is the number of times you want the character repeated.
))
.PA
..L.....................T.......T.......T.......T...........................R..
#SSTEXT3
ALIGN TEXT
By default, Uniplex aligns text to the left. You can format the text
within a cell so that it is right-justified, or centered. You can format
text in one of two ways:
Format text using commands:
..H....L................................T.......T...........................R..
1 Press /rf
2 Enter the range you want to align.
3 Pick and point the Line-up option.
4 Pick and point the option you require.
..L.....................................T.......T...........................R..
Format text using prefix characters:
' Forces left aligned text
" Forces right aligned text
^ Forces centered text
))
..L.....................T.......T.......T.......T...........................R..
#SSTEXT4,title
ROW AND COLUMN TITLES
You can create a title for a column by entering text into a cell above the
column. Or a title for a row by entering text into a cell to the left of
the row. If you enter titles this way, the text scrolls off the screen,
just like numeric data. If you want to make sure that titles are always
displayed, wherever you are in the worksheet, you can create titles for
rows and columns that are positioned outside the grid, thereby not using
cells:
..H..L..................................T.......T...........................R..
1 Press /wtds
2 Pick and point either the the Column or Row option.
3 Enter the letter of the column, or number of the row you want to title.
4 Enter the title you require and press RETURN
))
.PA
..L.....................T.......T.......T.......T...........................R..
#SSTEXT5
WORKSHEET HEADINGS
You can have a 1 or 2-line title for your spreadsheet. Uniplex displays it
on the two lines immediately above the grid:
..H..L..................................T.......T...........................R..
1 Press /wt
2 Pick and point the Header option.
3 Pick and point the Main Header or Sub-Header option.
4 Enter the text you require and press RETURN.
))
.PA
#SSCALCULATE1,calculate
AUTO/MANUAL CALCULATION
Uniplex, by default, automatically calculates the result of formulae and
functions as you enter them. However, you can change the calculation mode
to manual, so that Uniplex only calculates the result of formulae when you
request.
To set manual calculation for the entire spreadsheet: Press /wmrm
To set manual calculation for a particular area:
1 Press /wmrs
2 Enter the range you want to calculate manually.
3 Pick and point Manual.
))
.PA
#SSCALCULATE2
ORDERING
Uniplex, by default, calculates the spreadsheet in natural order. This
means Uniplex calculates formulae in their order of dependency. That is,
any formula that relies on the result of another formula is calculated
after that formula.
To set the order of calculation:
1 Press /wmr
2 Pick and point the option you require.
))
.PA
#SSCALCULATE3
SPECIFY THE AREA OF SPREADSHEET TO CALCULATE
Uniplex, by default, calculates the entire spreadsheet. However, you can
calculate specific areas of the spreadsheet, as follows:
1 Press /wmrs
2 Enter the range you want to set auto or manual calculation for.
))
.PA
#SSCALCULATE4
ONESHOT
You can calculate only the external functions. For example, functions that
execute operating system commands like sh or functions that access data
from the database using pipe.
When you calculate external functions in this way, and if you subsequently
recalculate the spreadsheet, Uniplex does not recalculate external
functions unless they have no current value, that is they are newly entered
formulae.
It is useful to calculate external functions in this way, since they can
take longer to calculate than standard calculations.
To calculate external functions only: Press /wmro
))
.PA
#SSCALCULATE5
PRECISION
You can set the rounding precision for calculations. For example, you can
set the number of decimal places to 2. This is particularly useful for
financial calculations, since it avoids rounding errors.
To set the rounding precision:
1 Press /wmrp
2 Pick and point Limit if you want to set a new level of precision
or Money if you want to set the level of precision to 2 decimal
places.
3 If you are setting a new level of precision. Enter the number of
decimal places you require.
))
.PA
#SSCOPY1,copy
COPY CELL CONTENTS
You can copy the contents of a cell to another cell. You can use this
command to copy a formula across a range of cells. If you do this, all
relative addresses are adjusted accordingly:
..H..L..................................T.......T...........................R..
1 Move the cell pointer to the cell you want to copy.
2 Press /c
.....L..................................T.......T...........................R..
To copy the contents of a single cell to another single cell: Press
RETURN. Move the cell pointer to the cell where you want the copied
contents to be placed. Press RETURN.
To copy the contents of a single cell to a range of cells:
Move to the first cell of the target range and enter a period (.)
Move the cell pointer to the end point of the range you want to copy to.
Press RETURN.
))
#SSCOPY2,move
MOVE CELL CONTENTS
You can move values from one location to another in the spreadsheet. You
can move data and formulae to a target destination in the spreadsheet. You
can move the contents of a single cell or a range of cells. Uniplex moves
the range with the same structure. Uniplex adjusts all references in the
spreadsheet that refer to the area being moved. Unlike using the Copy
command, when you use the Move command, Uniplex removes the original area
containing the data.
To move data around the spreadsheet:
..H..L..................................T.......T...........................R..
1 Move the cell pointer to the beginning point of the range you want to
move.
2 Press /m
3 Move the cell pointer to the end point of the range you want to move
from, then press RETURN.
4 If you want to move the contents of a single cell, press RETURN without
moving the cell pointer.
5 Move the cell pointer to the cell where you want the beginning point of
the range, or the single cell, to be placed. Press RETURN.
))
.PA
#SSCOPY3,cut&paste
CUT AND PASTE
You can use the Uniplex cut and paste facility to copy and move the
contents of cells. Using cut and paste you can copy data from the
spreadsheet and use it with other Uniplex applications, for example in Word
Processor documents or in the database.
If you are copying or moving data within the same spreadsheet, use the Move
or Copy commands. Use Cut and Paste to transfer information from other
spreadsheets or other applications.
.PA
To copy or move the contents of cells using Cut and Paste:
..H..L..................................T.......T...........................R..
1 Move the cell pointer to the top left cell of the area containing the
data you want to copy or move. Press ESC (
2 Move the cell pointer to the bottom right cell of the area containing
the data you want to copy or move. Press ESC )
Enter one of the following:
.....H.......L..........................T.......T...........................R..
l To place the area you have selected in the clipboard, and leave
the area in the spreadsheet. Use this command if you want to
paste, move, or copy the area.
b or r To place the area you have selected in the clipboard, and delete
the area from the spreadsheet. Do not use the blank option if
you want to use paste, move or copy.
a To place the area you have selected in a document, appending it
to the end of the document.
w To place the area you have selected in the clipboard, and in
addition, write the area to a document. (Uniplex prompts you
for a document name.)
..L.....................................T.......T...........................R..
To paste in the area you selected in another part of the spreadsheet:
..H..L..................................T.......T...........................R..
1 Move the cell pointer to the top left cell of the area you want to copy
or move the data to. Press ESC *
2 Enter one of the following:
.....H......L...........................T.......T...........................R..
o or i Places the contents of the previously marked area into the
spreadsheet, starting at this cell. Formulae and formats are not
copied.
c copies the contents of the previously marked area into the
spreadsheet, starting at this cell. If the data contains
formulae, Uniplex adjusts relative addresses.
m To copy the contents of the previously marked area into the
spreadsheet, starting at this cell. If the data contains
formulae, Uniplex adjusts relative addresses. In addition,
Uniplex removes the contents of the area where you copied the
data from.
))
#SSEDIT1,edit
EDIT A CELL
To edit the contents of a cell:
..H..L...........T......T.......T.......T.......T...........................R..
1 Position the cell pointer at the cell and press F1
2 Edit the cell contents using the editing commands described below.
3 Press RETURN when you have finished editing.
Insert a character: CTRL e
Delete character to left: DEL or RUBOUT
Delete current character: CTRL c
Delete line/Clear field: CTRL x
Delete word: CTRL w
Undo last delete or insert: ESC u
))
.PA
#SSEDIT2,insert
INSERT
..L..............T......T.......T.......T.......T...........................R..
You can insert empty rows and columns into the spreadsheet. Uniplex moves
the rows below down or elbows adjacent columns to the right:
..H..L...........T......T.......T.......T.......T...........................R..
1 Position the cell pointer on the row immediately below where you want
the row(s) inserted or to the left of the column where you want the
column(s) inserted.
To insert a row: Press CTRL o
2 Press /wi
3 Pick and point either Row or Column.
4 Enter the end point of the range and press RETURN.
))
#SSEDIT3,delete
DELETE
You can delete rows and columns in the spreadsheet. Uniplex moves rows up
to fill the gap, or pulls adjacent columns across from the right. You
cannot restore rows or columns that you delete by mistake.
..H..L...........T......T.......T.......T.......T...........................R..
1 Position the cell pointer on the row or column you want to delete. If
you want to delete a range, position the cell pointer on the first row
of the range.
2 Press /wd
3 Pick and point either Row or Column.
.PA
4 If you want to delete the current row or column, press RETURN. If you
want to delete a range of rows, enter the end point of the range.
))
.PA
#SSEDIT4,kill
ERASE CELLS
To delete the contents of a single cell:
..H....L.........T......T.......T.......T.......T...........................R..
1 Move the cell pointer to the cell you want to delete.
2 Press SPACEBAR, followed by an arrow key, or RETURN.
Or: Press CTRL w
To delete the contents of a range of cells:
..H....L.........T......T.......T.......T.......T...........................R..
1 Position the cell pointer on the starting point of the range.
2 Press /re
3 Enter the cell addresses of the range you want to delete.
To delete a row: Press CTRL x
))
.PA
#SSEDIT5
SORT VALUES
You can sort any range of values in the spreadsheet. You can sort values
and ask Uniplex to display the values in numeric or alphabetic order:
..H..L...........T......T.......T.......T.......T...........................R..
1 Select the range you want to sort: Press /dsd. Enter the range.
2 Select the type of sort order you require: Press o. Pick and point
the order you require.
3 Select the area where you want the sorted range to be displayed:
Press k. Enter the Key Cell
4 Sort the range: Press g.
))
.PA
#SSFORMAT1
CHANGE THE FORMAT OF THE ENTIRE SPREADSHEET
You can set the display format for any area of the spreadsheet, or for the
entire spreadsheet. The format affects how the contents of the cells are
displayed and does not affect the value, text or formulae they contain.
To change the format of the entire spreadsheet:
..H..L...........T......T.......T.......T.......T...........................R..
1 Press /wgf
2 Uniplex displays the format menu:
Fixed Money Percent , Date Line-up Zero Hide Effect Opt Sci Reset
3 Pick and point the option you require. Details of the format options
are given in the section Format Options. The format option that you
specify takes effect over the entire spreadsheet.
))
#SSFORMAT2,format
SPECIFY AREA OF SPREADSHEET TO FORMAT
..L..............T......T.......T.......T.......T...........................R..
To format a portion of the spreadsheet:
..H..L...........T......T.......T.......T.......T...........................R..
1 Press /rf
2 Enter the range you want to format.
3 Pick and point the format option you require.
The format option you specify takes effect over the range of the
spreadsheet that you selected.
))
.PA
#SSFORMAT3
FORMAT OPTIONS
..H..............L......T.......T.......T.......T...........................R..
Fixed Sets the number of decimal places.
Money Sets the currency symbol.
Percent Places a percent (%) symbol after all values and multiplies
the value by 100 for display.
,(comma) Includes commas in the values to indicate thousands.
Sci Uniplex displays values in scientific format. For example:
3.5e+06
Date Sets the date format.
Line-up Sets the justification.
Zero Uniplex displays any cells containing formulae with a result
of zero as empty cells.
Hide Uniplex does not display the contents of these cells.
Effect Sets the effects.
Option Sets the display of decimal numbers.
))
#SSFORMAT4
RESET FORMATS TO DEFAULTS
You can reset formats to the default setting by following these steps:
..H..L..................T.......T.......T.......T...........................R..
1 Press /
2 Pick and point either the Global Format option, or the Range Format
option.
3 Pick and point the Reset option.
..L.....................T.......T.......T.......T...........................R..
Uniplex resets the format to the default format, except for the number of
decimal places, see below.
.PA
To reset a fixed number of decimal places to a floating amount, follow
these steps:
..H..L...........T......T.......T.......T.......T.............R................
1 Pick and point the Fixed option from the Format menu.
2 Press RETURN without entering any decimal places.
))
.PA
#SSFORMAT5,cwidth
CHANGE THE COLUMN WIDTH
You can change the width of the columns. You can change the column width
throughout the spreadsheet, or in a specified area.
To change the column width throughout the spreadsheet:
1 Press /wgc
2 Enter the column-width you require. Press RETURN.
To change the column width in a specified area of the spreadsheet:
1 Press /wcs
2 Enter the range for the area where you want to change the column width.
3 Enter the column width you require. Press RETURN.
))
.PA
#SSNAME1,labels
CREATE A NAME
You can assign a name to a cell or a set of cells on the spreadsheet. You
can subsequently use the name in any command in place of the usual column
or row addressing.
..H..L...........T......T.......T.......T.......T...........................R..
1 Press /rg
2 Enter the range you want to name
3 Enter a name.
))
.PA
#SSNAME2
REMOVE A NAME
You can remove any names you have entered as follows:
..H..L...........T......T.......T.......T.......T...........................R..
1 Press /rr
2 Enter the name, or the range from where you want to remove the name.
Press F2 (the Name softkey) to see a pick and point list of current
names.
))
.PA
#SSNAME3
VIEW AND USE NAMES
..L..............T......T.......T.......T.......T...........................R..
You can display all names associated with the current spreadsheet, together
with the location they refer to. When they are displayed, you can pick and
point a name and place it in the command line. This is useful if you want
to enter a name as part of a formula.
Display and use names as follows:
..H..L...........T......T.......T.......T.......T...........................R..
1 Press F2 (the Name softkey)
.....L...........T......T.......T.......T.......T...........................R..
Uniplex displays the names in a popup menu, together with the cell
addresses they refer to.
..H..L...........T......T.......T.......T.......T...........................R..
2 Pick and point the name you require. Uniplex loads the name into the
command line. To exit the list without selecting a name, press ESC q.
.PA
If you want to use a name as part of a formula:
..H..L...........T......T.......T.......T.......T...........................R..
1 Enter the first part of the formula.
2 Press F2
Uniplex displays a pick and point list of all the available names.
3 Pick and point the name you require.
Uniplex loads in the name to the command line.
4 Complete the formula.
))
.PA
#SSNAME4,macros
NAME A MACRO
A macro that resides in the current spreadsheet may be given a special
single character name. The name may then be used in conjunction with
F7=MACRO to run the macro.
It is a good idea to load frequently used macros into named cells outside
the normal printing area of your worksheet.
To name a macro:
..H..L...........T......T.......T.......T.......T...........................R..
1 Move to the cell you want to name, this is the cell containing the first
command of the macro.
2 Press /r
3 Enter the range you want to name.
4 Pick and point the Name option.
5 Enter \ or : followed by a single character as the macro name. For
example if your macro moves cells you can call it m for move. Enter:
\m
This creates a named cell, the \ signifies that the name is a name
for a macro. Macro names are case dependent so you may create upto 52
named macros. You can press F2=NAMES to view the names of your macros,
all macro names start with a :.
))
.PA
#SSPROTECT,lock,unlock
PROTECTING CELLS
You can protect the contents of cells. If you protect a cell, you cannot
overwrite it with move, copy, data entry or editing commands. When you
move the cell pointer over a protected cell, Uniplex displays LOCK in the
top right corner of the status line.
To protect an area of the spreadsheet:
..H..L...........T......T.......T.......T.......T...........................R..
1 Press /rp
2 Enter the range you want to lock.
To lock the entire spreadsheet:
..H..L...........T......T.......T.......T.......T...........................R..
o Press /wgpp
..L..............T......T.......T.......T.......T...........................R..
.PA
To switch off the protection of the contents of a range of cells:
..H..L...........T......T.......T.......T.......T...........................R..
1 Press /ru
3 Enter the range for which you want to switch off protection.
To switch off protection for the entire spreadsheet:
..H..L...........T......T.......T.......T.......T...........................R..
o Press /wgpu
..L..............T......T.......T.......T.......T...........................R..
If you have protected cells in the spreadsheet, you can over-ride the
protection temporarily so you can add new information:
..H..L...........T......T.......T.......T.......T...........................R..
o Press /wgpd
To re-protect the spreadsheet:
..H..L...........T......T.......T.......T.......T...........................R..
o Press /wgpe
))
.PA
..L..............T......T.......T.......T.......T...........................R..
#SSWINDOW1,split,window
OPEN A WINDOW
To split the screen horizontally:
..H..L...........T......T.......T.......T.......T...........................R..
1 Move to the row you want to split the screen below.
2 Make sure there is at least one row above and below the row you want to
split displayed on the screen.
3 Press /wwh
Or: Press ESC y. Press CTRL o
To split the screen vertically:
1 Move to the column where you want to split the screen.
2 Make sure there is at least one column either side of the column
displayed on the screen.
3 Press /wwv
Your spreadsheet has 1024 rows and 256 columns. You cannot display all
these rows and columns on a standard screen. However, you can create
multiple windows to view and use a spreadsheet. It is useful to create
multiple windows if you are working on a large spreadsheet. You can
simultaneously display different parts of the spreadsheet in different
windows on the screen.
You can use up to 9 windows on your screen. You can move between the
windows. In addition, you can link windows so that they scroll in
synchronization.
You can split your screen into windows either horizontally or vertically.
))
.PA
#SSWINDOW2
CHANGE WINDOWS
You can move the cell pointer between windows.
To move the cell pointer to the next window: Press /wwn or press F6
To move the cell pointer to another specific window: Press /wws
))
.PA
#SSWINDOW3
SYNCHRONIZE WINDOWS
To link windows:
..H..L...........T......T.......T.......T.......T...........................R..
1 Press /wwl
2 Pick and point Both if you want to link rows and columns, Row for Rows,
Columns for Columns and All to link all the windows together. Pick and
point Number if you are using more than two windows and you want to link
two specific windows.
Or: Press ESC y. Enter l to link all windows.
To unlink windows:
o Press /wwu
You can link windowed portions of the screen so that they move in
synchronization with the current window. This is useful for viewing the
totals of a large table at the same time as modifying the data. Once
linked, any movement of the current window will cause the same relative
movement of any linked windows. Linking can act on rows only, columns only
or, on rows and columns.
If you link on rows, Uniplex synchronizes row movement, this links movement
of the cell pointer up or down. If you link on columns, this links
movement of the cell pointer left or right.
))
.PA
#SSWINDOW4,unsplit
JOIN AND CLOSE WINDOWS
You can join two windows into one, as long as the result is a a singular
rectangular window:
..H..L...........T......T.......T.......T.......T...........................R..
1 Press /wwj
2 Enter the number of the first window you want to join.
3 Enter the number of the second window you want to join.
))
.PA
#SSSAVE1,save
SAVE A SPREADSHEET USING FAST FORMAT
You can save the current session in a special packed format in a file. The
file cannot be edited using Uniplex word processing, but, because it is
packed, is fast to retrieve into the spreadsheet. This is the default way
of saving a spreadsheet.
You can save the spreadsheet in the default way using one of three methods:
To save the spreadsheet using commands: Press /fs
To save the spreadsheet using keystrokes: Press ESC e
Or: Press ESC s. Press e.
))
.PA
#SSSAVE2,list
LIST COMMANDS
You can list all the commands you have entered to create a spreadsheet in a
document, one per line. You can edit this document using the word
processor. You can transfer spreadsheets saved this way to other computers.
..H..L...........T......T.......T.......T.......T...........................R..
o Press /fl
Uniplex displays the following options:
.....H..................L.......T.......T.......T...........................R..
All Stores all the data, text and formulae.
Data Stores only data values.
Formulae Stores formulae only.
Graphs Stores graphs only.
Specify-range Uniplex prompts for a range to store.
))
.PA
#SSSAVE3
SPECIFY RANGE
You can choose to store a range of cells. You can choose to save all the
formulae and values, or only the values:
..H..L..........................T.......T.......T...........................R..
1 Press /fx
2 Pick and point Formulas if you want to save formulas and values. Pick
and point Values if you want to save values only.
3 Enter the range of the spreadsheet you want to save.
.PA
#SSSAVE4
SAVE THE SPREADSHEET TO A WORD PROCESSING DOCUMENT
You can place a copy of the spreadsheet in a word processing document. You
can subsequently print the spreadsheet, edit it using the word processor,
or incorporate it into other word processing documents.
..H..L..........................T.......T.......T...........................R..
1 Press /fp
2 Enter the range you want to print.
))
.PA
#SSSAVE5,get
RETRIEVE FAST FORMAT
You can retrieve a spreadsheet you have saved using the save command in one
of three ways:
Use the Retrieve Command: Press /fr
Retrieve a specified area or type of data:
..H..L..........................T.......T.......T...........................R..
1 Postion the cell pointer
2 Press /fc
3 Pick and point one of the following:
..H..........L..................T.......T.......T...........................R..
Copy Copies a specified spreadsheet into the existing spreadsheet
Data and formulae are included. You can specify to copy an
entire spreadsheet, or a range of a spreadsheet.
Data-copy Copies text and data (not formulae) from a specified
spreadsheet into the existing spreadsheet. You can specify to
copy an entire spreadsheet or a range of a spreadsheet.
Add Adds the values from a specified spreadsheet into
the existing spreadsheet. You can use this option to
consolidate spreadsheets.
Subtract Performs the reverse of the Add option.
..H..L..........................T.......T.......T...........................R..
4 Pick and point Entire_File if you want to copy or add the whole of a
specified spreadsheet. Pick and point Specific_Range if you want to
copy or add a section of the spreadsheet.
5 Enter the name of the spreadsheet you want to add or copy.
))
..L.............................T.......T.......T...........................R..
.PA
#SSSAVE6,use
USE A COMMAND LIST
The Use command rebuilds a spreadsheet using the commands saved with the
list command:
..H..L..........................T.......T.......T...........................R..
1 Press /fu
2 Enter the name of a file stored with the List command.
))
.PA
#SSPRINT1,print
SPECIFY THE RANGE TO PRINT
You can choose to print the entire spreadsheet, or you can specify a
portion of the spreadsheet to print:
..H...L.........................T.......T.......T...........................R..
1 Press /ps
2 If you want to print only a portion of the spreadsheet:
Pick and point the Specific-range option from the Setup menu.
Enter the range you want to print.
Or: If you want to print the entire spreadsheet:
Pick and point the Entire-file option.
))
.PA
#SSPRINT2
SET THE PAGE SIZE
When you produce a printed copy of a large spreadsheet, Uniplex divides it
into pages. The places where Uniplex divides the spreadsheet by default
are shown by a series of dashes (------) in the row border, or an
exclamation mark (!) in the column border. Uniplex starts a new page
immediately below the row page marker, or immediately to the right of the
column page marker.
You can set the page length and width of the printed copy you produce:
..H..L..........................T.......T.......T...........................R..
1 Press /psp
2 Pick and point Length if you want to alter the page length. Pick and
point Width if you want to alter the page width.
3 Enter the width in characters, or the length in lines.
))
.PA
#SSPRINT3
PAGE BREAKS
In addition to specifying the length of a page, you can force page breaks
so that information is split across pages in a meaningful way:
..H..L..........................T.......T.......T...........................R..
1 Move the cell pointer to the row where you want to start a new page.
2 Press CTRL o
3 Move the cell pointer to the new blank row.
4 Enter .PA in column A of the new row.
))
.PA
#SSPRINT4
SPECIFY THE NUMBER OF COLUMNS ON A PAGE
Instead of specifying the width of a page in characters, you can specify
the number of columns that you want to include on a page. This is
particularly useful, if you have, for example, a a spreadsheet which has a
series of annual figures. You can specify that you want to include 12
columns on each printed page.
..H..L..........................T.......T.......T...........................R..
1 Press /pspc
2 Enter the number of columns you want to include on each page and press
RETURN.
))
.PA
#SSPRINT5
HEADERS AND TITLES
You can choose to include the spreadsheet title and the column and row
titles in your printed copy. To print out the spreadsheet with its headers
and titles, you must have the headers and titles switched on when you print
the spreadsheet.
Include a Separator between Titles:
....L...........................T.......T.......T...........................R..
You can include a line to separate the spreadsheet titles from the data
of the spreadsheet: Press /pspb
))
.PA
#SSPRINT6
COMPRESSED TEXT
By default, Uniplex prints out the spreadsheet using a normal font. You
can change the font to a small font, which allows you to include a large
amount of data on a printed page:
..H..L..........................T.......T.......T...........................R..
1 Press /ps
2 Pick and point Compressed if you want to work with a small font, or
Normal if you want to return to the default font.
))
.PA
#SSPRINT7
RAW FORMAT
You can choose to print out a spreadsheet without entering any formatting
controls. In this case, you need to make sure that you have entered any
appropriate Uniplex dot commands to ensure correct pagination and so on.
To print out a spreadsheet without formatting controls:
..H..L..........................T.......T.......T...........................R..
o Press /psr
..L.............................T.......T.......T...........................R..
To reset the format controls after using the Raw command:
..H..L..........................T.......T.......T...........................R..
o Press /psf
))
.PA
#SSPRINT8
PRINTER SELECTION
When you have specified how you want to printed copy to look using the
print options, you are ready to produce a printed copy of the spreadsheet.
You can choose to print out the spreadsheet directly, or to write the
spreadsheet to a file. If you choose to write the spreadsheet to a file,
you can then transfer it to other Uniplex applications to work on. For
example, you can transfer it to the Word Processor, and add some
explanatory text.
To print out the spreadsheet directly: Press /pp
To write the spreadsheet to a file: Press /pf
))
.PA
#SSQUIT1
ERASE THE WORKSHEET
You can to clear the spreadsheet of all data, text, formulae and formats.
All values will be lost unless you have previously saved the spreadsheet.
..H..L..........................T.......T.......T...........................R..
o Press /we
..L.............................T.......T.......T...........................R..
The advantage of this command is that you can start again with a new
worksheet, without having to exit and then re-enter the spreadsheet.
))
.PA
#SSQUIT2
QUIT THE WORKSHEET
You can quit the spreadsheet as follows:
..H..L..........................T.......T.......T...........................R..
1 Press /q
2 Pick and point Yes to confirm you want to quit, or No to remain in the
spreadsheet.
..L.............................T.......T.......T...........................R..
Alternatively:
..H..L..........................T.......T.......T...........................R..
o Press ESC q. Press * to confirm.
..L.............................T.......T.......T...........................R..
All values will be lost unless you have previously saved the spreadsheet
with the save or list command.
))
.PA
#SSQUIT3,zero
SET ALL NUMERIC VALUES TO ZERO
You can reset all numeric values in the current spreadsheet to zero, as
follows:
..H..L..........................T.......T.......T...........................R..
o Press /dz
..L.............................T.......T.......T...........................R..
All numeric values will be lost unless you have previously saved the
spreadsheet using save or list.
Text, formats and formulae are not affected by this command, but all
numeric data is reset to zero. This is particularly useful when resetting
an existing spreadsheet template, prior to entering new data.
))
.PA
#SSGRAPH1,graph
DRAWING A GRAPH
To draw a graph:
1 Press /g
2 Select the range of data you want to graph:
Move the cursor to the top left of the area you want to graph.
Pick and point Range from the Graph menu.
Enter the range you want to graph.
Pick and point Row labels, Col labels, Both, or press RETURN for none.
3 Mark the graph position on your spreadsheet:
Pick and point the Place option.
Use the cursor keys to move the cursor to where you want the graph.
4 Plot the Graph:
Pick and point the Draw option from the graph menu.
))
.PA
..L.............................T.......T.......T...........................R..
#SSGRAPH2
LINKING GRAPHS
Uniplex always draws a graph representing the last data range you selected.
You can link a data range dynamically to a graph, so that when you update
the data range, the graph is updated in conjunction:
..H..L..........................T.......T.......T...........................R..
1 Pick and point the Link option.
2 Position the cursor on the cell in the top left corner of the graph you
have just drawn.
3 Press RETURN
))
.PA
#SSGRAPH3
CHANGING GRAPHS
..L.............................T.......T.......T...........................R..
By default, Uniplex always draws graphs using a standard graph template.
This template defines parameters such as the type of graph, size and
scaling. To modify a graph:
..H..L..........................T.......T.......T...........................R..
o Press /go
Complete the Graph popup form as follows:
..H................L............T.......T.......T...........................R..
Graph Type Press the SPACEBAR to scroll the entry in this field to
the type of graph you want. The following types are
available: Vertical bar chart, Horizontal bar chart,
Stacked vertical bar chart, Stacked horizontal bar chart,
Line graph, Scatter graph, Max-min bar graph, Pie chart.
Graph Width If you do not want the default width of 60 characters,
enter the width you require.
Length If you do not want the default length of 16 lines, enter
the length you require.
Group By If you do not want the data plotted by row, press the
space bar to scroll the entry to COLUMN.
Display row labels If you want the first row of the data range used as row
labels, press the SPACEBAR to scroll the entry to YES.
Display columns labels If you want the first column of the data range used
as column labels, press the SPACEBAR to scroll the entry
to YES.
Set scale to range If you want to set the graph scale, scroll the entry to
YES and enter:
from the lowest point in the graph scale.
to the highest point in the graph scale.
))
.PA
#SSEMULATE
EMULATING OTHER SPREADSHEETS
You can use special commands to invoke the spreadsheet with a different
personality, so that it takes on the appearance of other spreadsheets.
This is particularly useful if you have been using a different applications
packages and want the spreadsheet to maintain the same appearance while you
gradually become familiar with the Uniplex spreadsheet.
To invoke a different personality:
..H..L...........T......T.......T.......T.......T...........................R..
1 Press /wmi
Uniplex displays the Interface options
2 Pick and point the option of your choice. The options are described
below:
.....H.......................L..T.......T.......T...........................R..
Uniplex Uses the original Uniplex interface, with cell
addresses in the format r1c1, and commands
entered on the command line.
issi Uses the Industry Standard interface, with cell
addresses in the format A1, and commands entered
through command menus.
R1C1 Cell addresses are in the format R1C1. Commands
are entered through command menus.
A1 Cell addresses are in the format A1. Commands
are entered through command menus.
))
.PA
#SSSTAT1,sum
FIND THE SUM OF A RANGE OF NUMBERS (SUM)
Calculate the sum of an expression as follows:
@sum(<expr>)
For example: @sum(12,12)
Uniplex enters the result 24 in the cell.
You can use the where function to apply a condition to statistical
functions. The condition is a logical test. Uniplex only includes those
elements in the expression that meet the test in the sum.
For example: @sum(where(salaries,X>20000))
))
.PA
#SSSTAT2,max
FIND THE MAXIMUM VALUE IN A RANGE (MAX)
Find the maximum value in a range as follows:
@max(<expr>)
For example: You have named the area salaries and entered the max function
in A7:
@max(salaries)
))
.PA
#SSSTAT3,min
FIND THE MINIMUM VALUE IN A RANGE (MIN)
Find the minimum value in a range as follows:
@min(<expr>)
For example, you have named the area salaries:
@min(salaries)
))
.PA
#SSSTAT4,count
COUNT THE NUMBER OF VALUES IN A RANGE (COUNT)
Count the number of non-empty cells in a range as follows:
@count(<expr>)
For example, you have named the area salaries:
@count(salaries)
You can use the where function to apply a condition to this function, (in
the same way as with SUM). For example:
@count(where(salaries,X<=20000))
))
.PA
#SSSTAT8,eval
EVALUATE THE ELEMENTS IN A LIST (EVAL)
You use the eval function in conjunction with the statistical functions to
perform a calculation on each element in a specified value list.
For example:
The range A1..6 contains data, accurate to 6 decimal places, but displayed
to 2 decimal places. This often means that the data has been rounded for
display purposes. Normally, sum will find the true sum of the range, and
may therefore give the wrong figure on display. The formula:
@sum(eval(A1..6,rnd(X,2)))
will round each element in the value list before it is summed. This will
give the correct sum for display.
))
#SSSTAT5,avg
FIND THE AVERAGE VALUE FROM A RANGE (AVG)
You can find the average of any range of numbers. The calculation is
essentially the same as the sum of the range divided by the count of the
number of elements in the range.
Calculate the average value from a range as follows:
@avg(<expr>)
For example, you have named the area salaries:
@avg(salaries)
))
.PA
#SSSTAT6,stdev
FIND THE STANDARD DEVIATION OF THE VALUES IN A LIST (STDEV)
Find the standard deviation of the values in a list as follows:
@stdev(<expr>)
For example:
@stdev(salaries)
))
.PA
#SSSTAT7,abs
FIND THE SUM OF THE ABSOLUTE VALUES IN A LIST (ABS)
You can find the sum of the absolute values in a list:
@abs(<expr>)
For example: @abs(10,-5,-2,3) = 20
))
.PA
#SSSTAT9,where
CREATE A CONDITIONAL STATISTICAL FUNCTION (WHERE)
You use the where function to apply conditions to statistical functions
which work on lists of values. You use the where function in conjunction
with the avg, sum, count, max, and min functions. Use the following
syntax:
<function>(where(<expr>,X,<expr>)
X is substituted for each value in the list and tested by the logical
expression.
For example you can to count the number of values in a range that are
greater than 3:
@count(where(A1..A6,X>3))
))
.PA
#SSMATH1,exp
CALCULATE THE EXPONENTIAL (EXP)
The exponential is the base of the natural logarithm, approximately
2.718281.
To find the exponential of a number to the power e, enter:
@exp(<expr>)
For example, if you enter the following formulae in a cell:
@exp(5)
Uniplex calculates the result as:
148.413159
))
.PA
#SSMATH2,log
FIND THE NATURAL LOG OF A VALUE (LOG)
Find the natural log of a value as follows:
@log(<expr>)
For example:
@log(66)
@log(A1..G12)
))
.PA
#SSMATH3,log10
FIND THE BASE 10 LOG OF A VALUE (LOG10)
Find the base 10 log of a value as follows:
@log10(<expr>)
For example, to find the base 10 log of 66:
@log10(66)
Uniplex calculates the result as 1.819544
To find the sum of the log of each value in a range:
@log10(A1..G12)
))
.PA
#SSMATH4,int
FIND THE INTEGER PORTION OF A SUM OF NUMBERS (INT)
Find the integer portion of a sum of numbers as follows:
@int(<expr>)
For example:
@int(E1)
))
.PA
#SSMATH5,mod
CALCULATE THE REMAINDER (MODULUS) ON DIVISION (MOD)
You can find the integer remainder (modulus) of a division. Uniplex
performs the division, but does not return the result of the division,
rather the remainder after the division. Find the modulus on division:
@mod(<number>,<divisor>)
where number is the number to divide and divisor is the number to divide
by. These can be numbers, cell addresses or named areas.
For example, You have an amount of money available for advertising defined
by cell budget, and each TV advert costs an amount defined by cell cost,
you want to find how much money will be left after buying the maximum
amount of advertisements within the budget:
@mod(budget,cost)
))
#SSMATH6,div
CALCULATE THE INTEGER PART ON DIVISION (DIV)
You can find the integer part on division. This function produces the same
results as using the / (division) operator.
To find the integer part on division:
@div(<expr>,<expr>)
For example, if you want to find the number of manuals that can be bought
at $25 and the name budget defines the available budget:
@div(budget,25)
))
.PA
#SSMATH7,root
FIND SUM OF SQUARE ROOTS (ROOT)
Find the square root of an expression as follows:
@root(<expr>)
For example:
@root(9)
Uniplex calculates 9^0.5 = 3
))
.PA
#SSFINANCE1,fv
You can use the fv function to find the equal payment series compound
amount. That is, it lets you calculate how much a regularly paid
investment, at a fixed interest rate, is worth at the end of a fixed
period. To use this function:
@fv(<amount>,<rate>,<periods>)
where amount is the amount to be regularly invested, rate is the interest
rate and period is the period over which you will invest it.
For example, the pmt function shows that a $30,000 mortgage is paid at
$4093 for 25 years. To find what these mortgage payments would yield if
paid into an investment scheme for 25 years:
@fv(4093,13%,25)
Uniplex returns the value $636950.84
))
.PA
#SSFINANCE2,sink
FIND THE EQUAL PAYMENT SERIES SINKING FUND (SINK)
You use the sink function to return the equal payment series sinking fund.
Sink is the inverse function of the fv function. That is, it lets you
calculate how much you need to invest regularly over a given period, at a
given interest rate to accumulate a given amount.
@sink(<final-amount>,<rate>,<periods>)
Where final-amount is the amount you want to accumulate, rate is the
interest rate and periods is the period over which the amount will be
regularly invested.
For example, if you need $100,000 in 4 years time and your best investments
opportunity yields 14.5% per annum, enter: @sink(100000,14.5%,4)
Uniplex returns $20173.
))
.PA
#SSFINANCE3,spv
FIND THE SINGLE PAYMENT PRESENT VALUE (SPV)
You use the spv function to find the single payment present value. That
is, it lets you calculate the value today of an amount invested at a given
interest rate over a given period. Alternatively, it lets you calculate
the value today of an amount that will depreciate at a given rate over a
given period. To use this function:
@spv(<amount>,<rate>,<periods>)
Where amount is the amount invested, rate is the interest or depreciation
rate and period is the period over which the amount will be invested.
For example, you expect to sell a piece of equipment for $1000 dollars in 2
years time, it will depreciate at 10% per year, to calculate what you
should pay for it today, enter: @spv(1000,-10%,2)
Uniplex returns $1234.56.
))
.PA
#SSFINANCE4,irr
FIND THE RATE OF RETURN FOR A SERIES OF CASH FLOWS (IRR)
You use the irr function to find the discount rate that equates the present
value of expected cash outflows with the present value of expected inflows.
That is, irr finds the internal rate of return or profit that a future
series of even or uneven cash flows to the initial investment. Irr
determines the attractiveness of an investment opportunity.
The internal rate of return is built on an iterative process in which you
provide an initial guess of the discount rate (anything between 1 and 0
will do) and Uniplex calculates the actual discount rate, equating the
present value of the series of cash outflows with the present value of a
series of inflows. To use this function:
@irr(<guess>, <range>)
where guess is the initial guess at the discount rate, and range is the
list of amounts. Uniplex considers the negative numbers as cash outflows
and positive numbers as cash inflows. The first cash inflow in a range
must be a negative number.
A good starting point for your initial guess is .1 or 10%. The spreadsheet
guesses 30 times and only returns an answer if it is within 0.0001% of the
correct answer, otherwise it returns E-VAL.
For example, you have the opportunity to buy the entire stock of a bankrupt
company, for a one-off payment of $1000 and expect to make $20,000 the
following year and progressively $5,000 less per year for the next 3 years:
@irr(10%,A1..5)
Uniplex calculates the rate of return as .122 or 12.2%. If you were loaned
the initial amount at 10%, you stand to profit by approximately 2%. Since
the loan repayment is constant, you make a profit in the first year and a
loss in the fourth year.
))
#SSFINANCE5,npv
RETURN THE NET PRESENT VALUE OF A SERIES OF CASH FLOWS (NPV)
You use the npv function to compute the net present value of a stream of
cash flows. To use this function:
@npv(<discount-rate>, <range>)
The discount-rate is the rate that the spreadsheet uses to calculate the
net present value. The range is a stream of cash flows to be discounted.
The interval between the cash flows must be constant and must agree with
the period of the discount rate.
For example, an annual discount rate should be used for cash flows
occurring a year apart. If the cash flows occur every month, a monthly
discount rate should be used.
For example, you have the opportunity to buy a company for $200,000 and
expect to earn the following amounts over the next 5 years:
Year 1 50000
Year 2 60000
Year 3 70000
Year 4 80000
Year 5 30000
15% is the rate at which you must earn to make the investment worthwhile.
@npv(15%,A1..5)
Uniplex returns the result $195,529, less than your investment of $200,000.
So it looks like this is a bad investment.
))
.PA
#SSFINANCE6,period
CALCULATE THE DEPRECIATION PERIOD (PERIOD)
You use the period function to calculate the depreciation period. That is,
it calculates how long it will take for an amount to depreciate to a given
amount, at a given depreciation rate. You specify the timescale, the
depreciation rate, and the amount it will depreciate to:
@period(<start-amount>, <final-amount>, <rate>)
where start-amount is the original amount, final-amount is the amount you
expect it to depreciate to, and rate is the depreciation rate you expect.
For example, if you bought a car for $1,000, and you must sell it for $810
and you expect it to depreciate at 10% per year, you can calculate the
number of years before you must sell it as follows:
@period(1000,810,-10%)
Uniplex calculates that you must sell the car in two years.
))
.PA
#SSFINANCE7,pmt
CALCULATE MORTGAGE PAYMENTS (PMT)
You use the pmt function to calculate the mortgage payments for a given
principal, interest rate and number of periods. This is sometimes known as
the equal payment series capital recovery. To use this function:
@pmt(<principal>, <interest>, <period>)
where principal is the amount of the mortgage, interest is the interest
rate and period is the period over which you will make the payments.
For example, if your principal is a mortgage of $30,000 at an interest rate
of 13% over 25 years, calculate the amount per annum as follows:
@pmt(30000,13%,25)
Uniplex calculates the amount as $4093 ($341 per month).
))
.PA
#SSFINANCE8,pv
CALCULATE THE PRESENT VALUE OF A SERIES OF REGULAR PAYMENTS (PV)
You use the pv function to calculate the present value of an ordinary
annuity, given a payment per period, an interest rate and the number of
periods. An ordinary annuity is a series of payments made at regular
intervals. Present value is the value today of payments you make or
receive later, discounted at a given interest or discount rate. By
calculating the present value of an ordinary annuity, you can compare
different investment opportunities or potential obligations while taking
into account the time value of the money. To use this function:
@pv(<amount>,<rate>,<periods>)
where amount is the total amount of the ordinary annuity, rate is the
interest or discount rate and periods is the number of regular payments.
.PA
For example, to find the present value of $4093 paid annually with 13%
interest over 25 years, enter:
@pv(4093,13%,25)
Uniplex calculates that this is worth $30,0001 today.
))
.PA
#SSFINANCE9,sfv
CALCULATE THE FUTURE VALUE OF A SINGLE PAYMENT INVESTMENT (SFV)
You use the sfv function to calculate the future value of a single payment
investment at a given interest rate and a given period. To use this
function:
@sfv(<amount>,<rate>,<period>)
where amount is the amount invested, rate is the interest rate and period
is the period over which the money will be invested.
For example, to calculate how much $1000 invested at an annual rate of 10%
is worth after 2 years, enter:
@sfv(1000,10%,2)
Uniplex calculates it will be worth $1210.
))
.PA
#SSFINANCE10,rate
CALCULATE THE DEPRECIATION RATE (RATE)
You use the rate function to calculate the depreciation rate, with a given
initial value, final value and period. To use this function:
@rate(<start-amount>, <final-amount>, <period>)
where start-amount is the initial value, final-amount is the value at the
end of the period and period is the period over which the depreciation has
taken place.
For example, to calculate the depreciation on a piece of equipment costing
$1000 2 years ago, that was sold today for $810, enter:
@rate(1000,810,2)
Uniplex calculates that the depreciation rate is 10% (-0.1).
))
.PA
#SSSTRING1,cmp
COMPARE TWO TEXT STRINGS (CMP)
Compare two text strings as follows:
@cmp(<str-expr1>,<str_expr2>)
Where str_expr1 returns the first text string and str_expr2 returns the
second text string.
Uniplex returns TRUE (1) if the comparison matches up to the end of the
first text string. Otherwise, Uniplex returns FALSE (0).
For example, if you enter the following formula into a cell:
@cmp("Mar","March") Uniplex returns: 1
@cmp("Mon","March") Uniplex returns: 0
.PA
#SSSTRING2,len
FIND THE LENGTH OF A TEXT STRING (LEN)
Find the length of a text string as follows:
@len(<str-expr>)
str_expr must return a string.
For example, if you enter the following formulae in a cell, to find the
number of characters in the surname Cartwright:
@len("Cartwright")
Uniplex returns: 10
))
.PA
#SSSTRING3,str
CONVERT A NUMBER TO A TEXT STRING (STR)
You can convert a number to a text string. Uniplex automatically rounds
the number to two decimal places. You can use the resulting text string
with other text string functions. Convert a number to a text string as
follows:
@str(<str-expr>)
For example, if you enter the following formula in a cell:
@str(12) Uniplex returns: 12.00
The result is always left justified in the cell and rounded up to two
decimal places.
.PA
You can to convert a number to a text string and round it to the required
number of decimal places as follows:
@fix(<str-expr>,<d-places>)
Where str-expr returns a text string, and d_places is the number of decimal
places you require.
For example, if you enter the following formula in a cell:
@fix(12,3)
Uniplex returns: 12.000
))
.PA
#SSSTRING4,mid
EXTRACT ONE TEXT STRING FROM ANOTHER (MID)
Extract one text string from another as follows:
@mid(<str-expr>,<start_position>,<length>)
Where str_expr returns a text string, start_position is the position to
begin the extraction and length is the length of the string. For example:
The cell B1, contains an exam mark out of 100, (say 85). To extract the
grade achieved:
@mid("FFEDDCCBBA",B1/10+1,1)
In this case the grade would be B.
))
.PA
#SSSTRING5,val
CONVERT A TEXT STRING TO A NUMBER (VAL)
You can convert a text string to a number. This is particularly useful if,
for example, you have serial or part numbers and wish to perform
mathematical operations on them. Convert a text string to a number as
follows:
@val(<str_expr>)
For example, the cell A1 contains the text Jan 1986
To convert this to a number and increment it by 1:
@val(A1)+1
Uniplex returns: 1987
))
#SSSTRING6,lit
RETURN A CELL ADDRESS AS A STRING
You can convert a cell address into a string as follows:
@lit(<cell>)
For example:
@lit(r1c1)
This is particularly useful when you use the link() function, since it
allows a cell address in a string to by adjusted by the Move or Copy
command.
For example: link("get", lit(A2), "from sales-figs")
))
.PA
#SSDATE1,today
CONVERT TODAY'S DATE TO A NUMBER (TODAY)
You can convert today's date to an integer number. This function returns
the number of days from December 31 1899 to the current date:
@TODAY
For example, if the date is 11/18/88, the TODAY function returns 32464
You can format dates converted in this way into any of the Uniplex date
formats.
))
.PA
#SSDATE2,day
FIND THE DAY IN THE MONTH FROM A NUMBER (DAY)
Calculate the day in the month from an integer number as follows:
@day(<expr>)
For example, if A1 contains 32464, and you enter the following formula in a
cell:
@day(A1)
Uniplex returns: 18 (the 18th day of the month)
))
.PA
#SSDATE3,month
FIND THE MONTH OF THE YEAR (MONTH)
Calculate the month number from an integer as follows:
@month(<expr>)
For example, if A1 contains 32464, and you enter the following formula in a
cell:
@month(A1)
Uniplex returns: 11 (the 11th month of the year)
))
.PA
#SSDATE4,year
FIND THE CURRENT YEAR FROM A NUMBER (YEAR)
Calculate the year number from an integer as follows:
@year(<expr>)
For example: if A1 contains 32464, and you enter the following formula in
a cell:
@year(A1)
Uniplex returns: 1988 (the year)
))
.PA
#SSDATE5,date
CONVERT THE YEAR, MONTH AND DAY TO A NUMBER (DATE)
You can convert the year, month and day to an integer number which is the
total number of days from December 1899 to the current day, as follows:
@date(<yr_expr>,<month_expr>,<day_expr>)
yr_expr should return the year, month_expr should return the month and
day_expr the day.
For example, if you enter the following formula in a cell:
@date(1988,11,26)
Uniplex returns: 32472
))
.PA
#SSDATE6,day_mon
FIND THE NUMBER OF DAYS IN A MONTH
Find the number of days in a month as follows:
@day_mon(<expr>)
For example, if A1 contains 32464 and you enter the following formula in a
cell:
@day_mon(A1) Uniplex returns: 30 (30 days in the month)
It is useful to use the function to find the same day of the month for a
series of months. For example, if A1 contains TODAY, you can copy the
following formula to a series of cells to find the same day of the month
for a series of months:
A1 + day_mon(A1)
))
#SSLOGIC1,if
IF()
You use the IF function to create conditional formulas. You can use the
following logical operators with the IF function:
..H................L....T.......T.......T.......T...........................R..
== equal to
< less than
> greater than
<> not equal
>= greater than or equal to
<= less than or equal to
To create a conditional formula, enter:
@if(expr,value1,value2)
Or:
@if(expr,value1,value2,value3)
.L..............T......T.......T.......T.......T...........................R..
where expr must be a logical statement. It can incorporate logical
operators. Value1, value2 and value3 can be any expression.
The first form of the function returns value1 if the expr is greater than
0, value2 if the expr is less than or equal to 0.
The second form of the function will return value1 if the expr is greater
than 0, value2 if the expr is equal to 0 and value3 if the expr is less
than 0.
))
.PA
#SSLOGIC2,true,false
SET UP TRUE AND FALSE CONDITIONS (TRUE AND FALSE)
The TRUE and FALSE functions let you explicitly define whether Uniplex
returns the truth value 1 or the false value 0. They are useful for
testing logical values when creating complicated conditional functions.
To return the truth value 1:
@TRUE
To return the false value 0:
@FALSE
))
.PA
#SSLOGIC3,not
USE LOGICAL NOT
The NOT function returns the truth value 1 if the expression is false, and
the false value 0 if the expression is true.
To use this function:
@NOT(<expr>)
where expr can be any expression. For example:
@NOT(sum(r1c1:5)>10)
))
.PA
#SSLOGIC3,or
USE LOGICAL OR (OR)
You can make a series of tests using the OR logical function. If you use
the OR function by itself, Uniplex returns true (1) if any of the tests are
true, and false (0) if all of the tests are false. You can use the logical
OR function in conjunction with other logical functions to create more
complex formulae. To use this function:
@OR(<expr>)
For example:
@OR(5>4,3>2) Uniplex returns 1
@OR(5<4,3>2) Uniplex returns 1
@OR(5>4,3>2) Uniplex returns 0
))
.PA
#SSLOGIC4,and
USE LOGICAL AND (AND)
You can make a series of tests using the AND logical function. If you use
the AND function by itself, Uniplex returns true (1) if all of the tests
are true, and false (0) if any of the tests are false. You can use the
logical AND function in conjunction with other logical functions to create
more complex formulae. To use this function:
@AND(<expr>)
For example:
@AND(5>4,3>2) Uniplex returns 1
@AND(5<4,3>2) Uniplex returns 0
@AND(5>4,3>2) Uniplex returns 0
))
.PA
#SSLOGIC5,empty,datacell,textcell,defcell
ANALYZE THE CONTENTS OF A CELL
There are several spreadsheet functions to analyze the contents of a cell.
Depending on whether the test is true or false, Uniplex returns 1 or 0.
To test whether a cell is empty: @empty(<cell>)
To test whether a cell contains numeric data: @datacell(<cell>)
To test whether a cell contains text: @textcell(<cell>)
To test whether a cell contains a formula: @defcell(<cell>)
.PA
#SSTRIG,pi,cos,sin,tan,acos,asin,atan,deg,rad
TRIGONOMETRIC FUNCTIONS
Uniplex has a complete set of trigonometric functions for solving
engineering problems:
Find the PI constant 3.141593: @PI
Find the cosine of an expression: @cos(<expr>)
Find the sine of an expression: @sin(<expr>)
Find the tangent of an expression: @tan(<expr>)
Find the arc cosine of an expression: @acos(<expr>)
Find the arc sine of an expression: @asin(<expr>)
Find the arc tangent of an expression:@atan(<expr>)
Find the four quadrant arc tangent of
two expressions: @atan2(<expr1>,<expr2>)
Convert radians to degrees: @deg(<expr>)
Convert degrees to radians: @rad(<expr>)
))
.PA
#SSEXT1,link
LINK SPREADSHEETS (LINK)
You can link information from saved spreadsheets into the current
spreadsheet. This is the similar to getting data from other spreadsheets
using spreadsheet commands However, when you embed the function within a
spreadsheet to get data, Uniplex gets the data each time you calculate the
function. To link spreadsheets:
@link("<data source command>")
Where data source command can be one of the following:
get [<area>] from <name>
input [<area>] from <name>
paste [<area>] from <name>
Where area can be one of the following:
..H..............L......T.......T.......T.......T...........................R..
all the entire spreadsheet
column the specified column(s). For example: A or A..E
row the specified row(s). For example: 40 or 40..65
range the specified range. For example: A1..T20
Where name is the name of the file containing the spreadsheet.
..L.....................T.......T.......T.......T...........................R..
If you use LINK in conjunction with the GET command, Uniplex places the
results of the get at the current cell location.
For example, a saved spreadsheet (jan.sales) contains January sales figures
in the range A1..J1 To place those figures in the current spreadsheet
starting at the cell containing the formula:
@link("get A1..J1 from jan.sales")
You can link a single cell in a similar way. The current spreadsheet is a
summary of the year's sales figures. Cell A20 will contain the result of
January sales. At present this figure is stored in a spreadsheet call
jan.sales in cell I30.
To place the figure in the current spreadsheet, enter:
@link("get I30 from jan.sales")
))
.PA
#SSEXT2,graph
LINK GRAPHS AND THEIR ASSOCIATED DATA AREAS
You can link a graph and its associated data table. Using this function
ensures that if values in the data table are changed, when the spreadsheet
is re-calculated, the graph is always automatically updated to reflect the
changes in the data table.
To link a graph and its data table:
..H..L..................T.......T.......T.......T...........................R..
1 Move the cell pointer to the cell where you originally gave the graph
command.
2 Enter:
.....L..................T.......T.......T.......T...........................R..
@graph
))
.PA
#SSEXT3,sh
RUN OPERATING SYSTEM COMMANDS FROM THE SPREADSHEET
You can run an operating system command from within the spreadsheet and
return the result into a spreadsheet cell as follows:
@sh("operating system command")
For example: sh("who am i")
Uniplex returns your username when you calculate the spreadsheet.
))
.PA
#SSEXT4,rsh
RUN OPERATING SYSTEM COMMANDS FROM THE SPREADSHEET
You can run operating system commands and redraw the screen as follows:
@rsh("operating system command")
For example: rsh("date")
Uniplex returns the date when you calculate the spreadsheet.
))
.PA
#SSEXT5,pipe,db
EMBED DATABASE QUERIES IN A SPREADSHEET
You can embed Database Query commands in a spreadsheet. When the
spreadsheet is calculated, the database is queried and the results are
returned into the spreadsheet.
To embed Database Query commands:
..H..L..................T.......T.......T.......T...........................R..
1 Select the database you want to use with the current spreadsheet by
entering:
db database_name
where database_name is the name of the database you want to use.
.PA
2 Move the cursor to the cell where you want the result of the formula
placed.
3 Enter:
@pipe("database query command")
For example:
@pipe("select Yr_1985 from year_end where Surname = 'Hill'")
))
.PA
#SSSPECIAL1,row,col
FIND THE ROW NUMBER AND FIND THE COLUMN NUMBER (ROW,COL)
Find the current row number as follows:
@ROW
Find the current column number as follows:
@COL
))
.PA
#SSSPECIAL2,lookup
FIND RELATED DATA FROM TWO AREAS (LOOKUP)
You can find a value from one area and return the value from the
corresponding position in the second area. If the lookup is numeric,
Uniplex finds the greatest value less than or equal to the lookup value.
If the lookup is for a string, Uniplex matches the first three characters
of the strings.
To find related data from two areas:
@lookup(<expr>,<area1>,<area2>)@@
A
Where expr can be any expression, area1 and area2 are the two areas to
search.
))
.PA
#SSSPECIAL3,rnd
ROUND VALUES TO A SPECIFIED NUMBER OF DECIMAL PLACES (RND)
You can round a value to a set number of decimal places as follows:
@rnd(<expr>, <places>)
where expr is any expression and places number of decimal places.
For example:
@rnd(1.2363,2) returns the result 1.24
This function is also useful for rounding to the nearest hundred or
thousand. For example:
@rnd(13874,-2) returns the result 13900
))
#SSSPECIAL4,rand
PRODUCE RANDOM INTEGERS
You can return a random integer. To use this function:
@rand(<integer>)
where integer is the value + 1 of the maximum value you want. That is,
Uniplex will return an integer between 0 and the value - 1.
For example: @rand(10)
Returns a value in the range 0-9 inclusive.
If you use the rand function repeatedly within the same spreadsheet, and
want to ensure that the integers are truly random, use the srand function
before each rand call.
srand bases the value it returns on the system clock. Since, the times you
make the srand change, so the value it returns change. rand uses the value
returned by srand as the basis the values it returns.
To use the srand function:
@srand
Make sure you enter the srand function in a cell that will be calculated
before the cell containing the rand function.
))
.PA
#SSSPECIAL5,rpt
PRODUCE A LINE REPRESENTATION OF AN EXPRESSION (RPT)
The rpt function lets you represent data as a horizontal line of
characters. To use this function:
@rpt("<character>",<expr>)
Where character is the character you want to use and where expr is the
expression you wanted represented. If you omit the character, the default
character hash (#) is used.
For example: @rpt(sum(A1..6)
represents the sum of the contents of the cells in column A, rows 1 to 6,
as a line of hashes.
))
.PA
#SSSPECIAL6,self
ALLOW A CELL TO REFERENCE ITSELF (SELF)
Normally the spreadsheet does not allow you to enter formulae which
reference themselves. The self function can be used to allow a cell to
reference itself as follows:
@self(<expr>)
For example:
@def A1 = self(A1 +1)
This will increment A1 by 1 each time it is calculated.
))
.PA
#SSSPECIAL7,index
PROVIDE INDEXED REFERENCE TO A CELL (INDEX)
You use the index function to provide an indexed reference to any cell.
This is useful for expressing the relationship between data in two tables,
where there is no true mathematical relationship.
To index reference a cell:
@index(<cell>,<expr1>,<expr2>)
where cell is a spreadsheet cell, expr1 is the row offset to this cell and
expr2 is the column offset from this cell.
))
.PA
#SSSPECIAL7,na,isna
CALCULATE AN INCOMPLETE SPREADSHEET (NA AND ISNA)
You can use special functions which let you perform an initial calculation
on a spreadsheet that you know is incomplete. For example, you want to
calculate the total sales for the year, but the December totals from one of
your branches are not yet available.
The NA function lets you enter a special numeric value in a cell where the
real value is not yet available. If the cell is referenced in a formula,
the value NA is returned whatever the the other values.
You can test to see if a cell contains the value NA using the isna
function. This enables you to calculate a formula which includes an NA
value. For example:
@if(@isna(D4),100,sum(D1..D4))
This enables you to substitute an estimated figure, or a null value for the
unavailable figure, and complete the calculation of the formula.
))
.PA
#SSSPECIAL9,err,iserr
ERR AND ISERR
You can force an error value in a cell, and also trap error values when you
are making calculations which include a cell which has an error value.
Use the ERR function to force a cell to have the value ERR. If this cell
is referenced in a formula, the value ERR is returned.
This function is particularly useful when you are entering conditional
statements. For example: if(C12 > 45000, @ERR, C12)
If the result of the formula in C12 is greater than 45000, Uniplex gives
the cell the value of ERR. Otherwise, the value of C12 is returned.
Normally, if a cell referenced in a formula has a value of ERR, the formula
cannot be calculated. You can use the iserr function to trap cells with a
value of ERR, giving them a substitute, or a null value. For example:
@if(@iserr(A1..A10),0,sum(A1..10)) returns zero if there is an error in the
range being summed, otherwise returns the sum.
))
.PA
#SSSPECIAL10,choose
CHOOSE
The CHOOSE function lets you select values from an expression. Enter:
@choose(value,expr)
where value is the positional value you require from the expression. The
first value in the expression is numbered zero. For example:
@choose(A1, B1..B10)
))
.PA
#SPREADSHEET_MENU
SPREADSHEET MENU
The Spreadsheet menu lets you create or edit spreadsheets:
Create a Spreadsheet Invokes the Spreadsheet on a new empty spreadsheet.
Edit an existing
Spreadsheet Prompts for a spreadsheet name. Invokes the
spreadsheet on the spreadsheet you specify.
))
.PA
#GEN_RECORD
KEYRECORDER
Keyrecorder lets you store a sequence of keystrokes or commands. The
keystrokes or commands are stored on keytapes. By pressing only one or two@@
IIIIIIII
keys you can playback the keytape and automatically repeat the same series
of keystrokes and commands.
To record a keytape: Press ESC kb. Enter the exact sequence of keystrokes
which performs the task you want to record. Press ESC ke to end the keytape.
To playback a keytape: Press ESC kp or CTRL t
To save a keytape: Press ESC ks. Enter a name for the keytape.
To recall a keytape: Press ESC kr. Pick and point the keytape. Press ESC kp
To continue recording a keytape: Press ESC kc. Enter the keystrokes. Press
ESC ke to end the recording.
))
***************
* End of File *
***************