|
DataMuseum.dkPresents historical artifacts from the history of: CP/M |
This is an automatic "excavation" of a thematic subset of
See our Wiki for more about CP/M Excavated with: AutoArchaeologist - Free & Open Source Software. |
top - metrics - download
Length: 68352 (0x10b00)
Types: TextFile
Names: »QT20.HLP«
└─⟦9dda24c64⟧ Bits:30002729 SW1657 QUINTET Spreadsheet Release 1.0
└─⟦this⟧ »QT20.HLP«
<1,1,38,42,15,14,48,11,1>
WELCOME TO THE QUINTET SPREADSHEET
When you select the spreadsheet option
the screen displays a blank worksheet.
A blank worksheet consists of rows and
columns and is made up of a number of
cells which have an address or
position on the screen. The cell in
the top left corner of the worksheet
is A1.
- More on next page -
<1,1,38,42,18,14,48,11,1>
You can move around the worksheet by
using one of the following keys.
Left Arrow moves the cursor one cell
position to the left.
Right Arrow moves the cursor one cell
position to the right.
Up Arrow moves the cursor one cell
position up.
Down Arrow moves the cursor one cell
position down.
- More on next page -
<1,1,38,42,18,14,48,11,1>
Pg Up moves up one page (20
rows).
Pg Dn moves down one page (20
rows).
Tab moves across to the right
one page (72 characters).
Back Tab moves across to the left
one page (72 characters).
Home returns the cursor to
cell A1.
- More on next page -
<1,1,38,42,15,14,48,11,1>
End moves the cursor to the
worksheet perimeter.
This can be in any one of
four directions. Press
the End key followed by
one of the Arrow keys.
GoTo key prompts you to enter a
cell address and the
cursor will then move to
that position.
- More on next page -
<1,1,38,42,17,14,48,11,1>
The spreadsheet program has many
options to change the worksheet or
carry out special tasks. These
options are selected by using the Cmd
key.
Select the first level of menus by
pressing the Cmd key or the / key.
MENU COMMAND BOXES
Menu command boxes allow you to select
options to change the worksheet or to
carry out special tasks.
- More on next page -
<1,1,38,42,17,14,48,11,1>
You can move the command boxes around
the worksheet by pressing the Scroll
Lock key and then using the Arrow keys
to move in the direction required.
After positioning press the Scroll
Lock key again to restore the Arrow
keys to their normal use.
After moving the command box, the
program will remember the new position
for this session only. When the
spreadsheet is used the system uses
the default command box co-ordinates.
- More on next page -
<1,1,38,42,22,14,48,11,0>
Some of the commands have many levels
of options. For each level a new
command box is displayed.
You can recall the previous command
box by using the Esc key.
When you press the Cmd key the first
level is displayed with the available
options.
Select an option by using the Arrow
keys and pressing Return, or by typing
the first letter of the option.
The next level of options are
displayed at the bottom of the screen
when you use the Arrow keys to select
options.
<2,1,38,42,17,14,48,11,1>
ENTERING THE VALUES FOR A RANGE
The program will ask you to enter the
values of a range. You can do this in
two ways:
Type the values with one or two
fullstops between the values. For
example, A11..A15 and press Return.
As soon as you key in the first
character A, the system recognises
that you are going to tell it what
range to use by typing.
- More on next page -
<2,1,38,42,19,14,48,11,0>
Use the Arrow keys to change the cell
addresses. For example, if you use
the Right Arrow key twice, the range
will be A1..C1
If you want to change the first range
value (the A1) then press the Esc key
first and then use the Arrow keys to
change its value, then press one
fullstop character to display the
second range.
The above method is called pointing
and once the basics have been mastered
it is a fast way of changing the cell
addresses when asked for a range.
<3,1,38,42,13,14,48,11,1>
SPREADSHEET FORMULAE
You can enter formulae to perform
mathematical and statistical
functions.
The system recognises that you are
entering a formula if the first
character is either a + or -
- More on next page -
<3,1,38,42,17,14,48,11,1>
Basic functions:
+ The plus is used for addition.
- The minus is used for
subtraction.
* The asterisk is used for
multiplication.
/ The forward slash is used for
division.
Examples of the above formulae:
+A2+G3 +B1-A5 +B6*C2 +F17/A3
- More on next page -
<3,1,38,42,17,14,48,11,1>
Statistical functions:
SUM The total value of a range of
cells.
COUNT To count a range of values.
AVG The average value of a range
of cells.
MAX Returns a minimum value
providing the value is outside
the range.
MIN Returns a maximum value
providing the value is outside
the range.
- More on next page -
<3,1,38,42,15,14,48,11,1>
STD Contains the standard
deviation of the values in a
range.
VAR Contains the variance of the
values in a range.
Examples of the above formulae:
+SUM(A1..A5) +COUNT(B4..G6)
+MAX(A1*3,25) +STD(F5..G19)
+MIN(F3+10,30)
- More on next page -
<3,1,38,42,19,14,48,11,1>
Statistical database functions:
DSUM Totals the values of the
cells in the offset field of
the selected records.
DCOUNT Counts the number of
non-blank cells in the offset
field of the selected
records.
DAVG Finds the average of the
cells in the offset field of
the selected records.
DMIN Contains the smalles value of
the cells in the offset
field.
- More on next page -
<3,1,38,42,20,14,48,11,1>
DMAX Finds the larges value of the
cells in the offset field.
DSTD Calculates the standard
deviation of the cells in the
offset field.
DVAR Calculates the variance of
the cells in the offset
field.
Example of the above formulae:
+DSUM(B5..E12,3,C15..D16)
B5..E12 is the input range
3 is the offset
C15..D15 is the criterion range
- More on next page -
<3,1,38,42,16,14,48,11,1>
Mathematical functions:
ABS(a) Returns the absolute
value of a cell or
value.
ACOS(a) Returns the arc cosine
of a cell or value.
ASIN(a) Returns the arc sine of
a cell or value.
ATAN(a) Returns the 2 quadrant
arc tangent of a cell
or value.
- More on next page -
<3,1,38,42,17,14,48,11,1>
ATAN2(a,b) Returns the 4 quadrant
arc tangent of a cell
or value.
COS(a) Returns the cosine of a
cell or value.
EXP(a) Returns the exponential
of a cell or value.
INT(a) Returns the integer of
a cell or value.
LN(a) Returns the log base 2
of a cell or value.
LOG(a) Returns the log base 10
of a cell or value.
- More on next page -
<3,1,38,42,15,14,48,11,1>
MOD(x,y) Returns x modulus y.
PI Returns a value of
3.141592
RAND Returns a random number
between 0 and 1
ROUND(x,y) Round value x to y
decimal places.
SIN(a) Returns the sine of a
cell or value.
SQRT(a) Returns the square root
of a cell or value.
- More on next page -
<3,1,38,42,17,14,48,11,1>
TAN(a) Returns the tangent of
a cell or value.
Examples of the above formulae:
+COS(A12)
Returns the cosine of the value in
cell A12.
+SQRT(137)
Returns the square root of 137.
- More on next page -
<3,1,38,42,16,14,48,11,1>
Logical functions:
FALSE Returns a value of 0
(FALSE).
TRUE Returns a value of 1
(TRUE).
ISNA(b) Returns a value of 1
(TRUE) if expression b
has the value NA.
ISERR(b) Returns value of 1
(TRUE) if expression b
has the value ERR.
- More on next page -
<3,1,38,42,19,14,48,11,1>
IF (cond x,y) Returns the value of x
if the condition is
TRUE and the value of y
if the condition is
FALSE.
Example of the above formulae:
+ISNA (A12)
Returns the value of 1 if cell A12
is NA.
Returns the value of 0 if cell A12
is not NA.
- More on next page -
<3,1,38,42,17,14,48,11,1>
Special functions:
NA Returns the value NA
(not available).
ERR Returns the value ERR
(error).
CHOOSE(x,r1,r2..rn)
Returns the value
argument from list
r1..rn.
HLOOKUP(a,range)
Horizontal table
lookup.
- More on next page -
<3,1,38,42,12,14,48,11,1>
VLOOKUP(a,range)Vertical table lookup.
Example of the above formula:
+ERR
Returns the value of ERR for that
cell address.
- More on next page -
<3,1,38,42,17,14,48,11,1>
Financial functions:
IRR(a,range) Calculates the
internal rate of
return.
NPV(a,range) Calculates the net
present value.
FV(payment,interest,term)
Calculates the future
value.
PV(payment,interest,term)
Calculates the
present value.
- More on next page -
<3,1,38,42,11,14,48,11,1>
PMT(principal,interest,term)
Calculates the payment
value.
Example of the above formula:
+IRR(B1,A1..A7)
- More on next page -
<3,1,38,42,20,14,48,11,1>
Date functions:
DATE(year,month,day)
Calculates the number
of days from the year
month and day.
DAY(date) Returns the day number.
MONTH(date) Returns the month
number.
YEAR(date) Returns the year
number.
TODAY Returns todays date
providing the system
date has been set.
The system calculates the date from
1st January 1950.
<4,1,38,42,15,14,48,11,1>
TYPING A LABEL OR TEXT
If you want to type text into the
worksheet it is referred to as a label
because it is normally labelling a
cell address.
The default global setting is left
justified and when you enter text it
will start at the left edge of the
cell.
- More on next page -
<4,1,38,42,12,14,48,11,0>
However, if you want your labels to
appear centered or right justified
then precede the centered label with ^
and the right justified label with ".
You can change the global setting by
selecting the Worksheet Global Label
prefix option. You can also change
existing labels by using the Range
Label prefix option.
<5,1,38,42,11,14,48,11,0>
EDITING DATA
If you make a mistake when typing
data, the Edit status message will
appear for you to make corrections to
the input line. Use the Backspace key
and re-type, or use the Arrow keys and
Del key and then re-type.
<21,1,38,42,18,14,48,11,1>
FIRST COMMAND BOX OPTIONS
Select an option by using the Arrow
keys and then press Return, or type
the first letter of the option.
As the command menus are in levels,
some tasks take three or four levels
of menu selections before the task is
done. When complete the command box
will be removed from the screen.
The following options are available to
you at the first level:
- More on next page -
<21,1,38,42,15,14,48,11,1>
WORKSHEET
The worksheet commands will control
the overall use of the spreadsheet.
The commands control the overall
appearance of the spreadsheet such as
column widths, display formats, and
determine the way in which the
spreadsheet calculates the formulae
you enter.
- More on next page -
<21,1,38,42,19,14,48,11,1>
RANGE
The spreadsheet has a group of range
commands that carry out various
commands on specified cell ranges.
COPY
The copy command allows you to copy
cells to other parts of the worksheet.
The copied cells will remain in their
original position.
You will be asked to specify the range
you are copying FROM and the range you
are copying TO.
- More on next page -
<21,1,38,42,18,14,48,11,1>
Copying will overwrite the previous
contents of cells and there is no way
to recover those cells.
MOVE
The move command allows you to move
cells to other parts of the worksheet.
The original cells will be removed
from the FROM range and placed in the
TO range.
You will be asked to specify the range
you are copying FROM and the range you
are copying TO.
- More on next page -
<21,1,38,42,15,14,48,11,1>
FILE
There are a set of file commands which
allow you to store and retrieve
spreadsheets.
You must save the spreadsheet
otherwise when you exit from the
spreadsheet or if there is a power
failure, the information in your
spreadsheet will be lost.
- More on next page -
<21,1,38,42,16,14,48,11,1>
File names can be up to 8 characters
long and a 3 character extension with
only alpha or numeric characters. For
example PLAN86.WKS An error message
will be displayed if you enter any
illegal characters. The extension
of .WKS is the default worksheet file
name, this can be changed in the setup
file.
The system will save the worksheet
along with all the settings.
- More on next page -
<21,1,38,42,14,14,48,11,1>
PRINT
The print commands allow you to print
the worksheet data. You can print an
entire worksheet or you can select a
range for printing.
You will be given a choice of sending
the output directly to the printer or
storing the output in a file.
- More on next page -
<21,1,38,42,20,14,48,11,1>
GRAPH
The graph commands allow you to
produce graphs and charts of the
spreadsheet data. Output can be in
colour or black and white on display
screens, printers or plotters. Before
using this option make sure that you
have the graphics device driver loaded
for your system.
There are five graph types which are:
Line graphs Bar graphs
XY graphs Stacked bar graphs
Pie charts
- More on next page -
<21,1,38,42,19,14,48,11,0>
DATA
The data commands create and process
information in tabular form by using
simple database management techniques.
QUIT
When all work is complete and you have
saved the current worksheet (if you
want a permanent copy) then use the
quit command.
The system will return to the QT
desktop or to the operating system if
you only use the spreadsheet.
<22,1,38,42,18,14,48,11,1>
GLOBAL
The global command establishes overall
settings for the following:
Numeric display format
Label alignment
Column width
Recalculation
Protection
The settings can be displayed on the
screen by using the Worksheet Global
Status option.
- More on next page -
<22,1,38,42,20,14,48,11,1>
INSERT
You can insert blank columns or rows
into the worksheet.
DELETE
You can remove complete columns or
rows from the worksheet. All entries
following the deleted entries are
moved towards the beginning to fill in
the space.
COLUMN WIDTH
You can change the width of a single
column. Position the cursor in the
column and select this option.
- More on next page -
<22,1,38,42,16,14,48,11,1>
ERASE
The worksheet erase command clears ALL
entries in the worksheet. Any
information in the worksheet is lost
and it enables you to start again.
TITLES
You can fix rows or columns along the
top or left edge of the screen so they
never scroll off the screen and are
always in view.
- More on next page -
<22,1,38,42,12,14,48,11,1>
For example, you may want to enter
values in column P and refer to the
labels in column A. By positioning
the cursor in column P, the labels in
column A will scroll off the screen.
However, if you fix the first column
by using the titles option they will
not scroll off the screen.
- More on next page -
<22,1,38,42,14,14,48,11,0>
WINDOW
You may wish to view two parts of the
worksheet that are far apart.
You can choose a horizontal or
vertical division for the two windows.
STATUS
The Global Status shows the current
global settings.
<23,1,38,42,13,14,48,11,1>
FORMAT
Use the format command to determine
the way the spreadsheet displays
numbers on the screen. It does not
change the value stored in the cells.
If you select this option you will be
given a choice of the different
formats.
- More on next page -
<23,1,38,42,19,14,48,11,1>
LABEL PREFIX
The initial global setting for labels
is left justified but can be changed
to centered or right justified. The
default setting can be overridden by
preceding the label with ' for left
justified, " for right justified or ^
for centered.
COLUMN WIDTH
Worksheet Global Column width
You can set the standard column width
to a value from 1 through 72. The
initial global setting is 9.
- More on next page -
<23,1,38,42,16,14,48,11,1>
You can use the Left and Right Arrow
keys to increase and decrease the
width and then press Return. You can
also type in a number between 1 and 72
and press Return.
RECALCULATION
The spreadsheet is designed to
recalculate all formulae automatically
whenever you enter a new value or edit
an existing value. However you may
want to change the recalculation mode.
- More on next page -
<23,1,38,42,13,14,48,11,1>
If you have a large complex
spreadsheet it is advisable to set the
calculation mode to manual.
PROTECTION
You can create worksheets for others
to use and wish to prevent accidental
modification of certain cells. This
option allows you to protect certain
cells.
<24,1,38,42,12,14,48,11,1>
FIXED
Fixed number of decimal places, from 0
to 15.
For example:
12.321 -4.27
- More on next page -
<24,1,38,42,14,14,48,11,1>
SCIENTIFIC
Exponent scientific notation. A
specified number (0 to 15) of decimal
places in the multiplier. Exponent of
10 from -99 to +99.
For example:
2.9E -02 6.3E+01 1.332E-11
- More on next page -
<24,1,38,42,20,14,48,11,1>
CURRENCY
The currency sign appears before each
entry and there will be commas between
thousands.
For example:
$12.02 $6.25 $8,781.98
COMMA
Commas are placed between thousands.
For example:
12.02 1,000,000 8,781.98
- More on next page -
<24,1,38,42,15,14,48,11,1>
GENERAL
This is the initial global display
format. Zeros after the decimal point
are suppressed. Very large and very
small numbers are displayed in
scientific exponent format.
For example:
10 6 3.4 1.3E-9
- More on next page -
<24,1,38,42,15,14,48,11,1>
+/-
Horizontal pictograph. The amount of
symbols represent the integer part of
the value. The + is for positive, the
- for negative and a fullstop
represents a zero.
For example:
+++ ----- .
- More on next page -
<24,1,38,42,14,14,48,11,1>
PERCENT
Percentage, with specified number of
decimal places, 0 through 15. The
number displayed is the value times
100, followed by the percent sign.
For example:
66.5% -14.25%
- More on next page -
<24,1,38,42,19,14,48,11,1>
DATE
The date can be entered by typing
+DATE(yy,mm,dd) It will be displayed
as an integer number but to display it
in a more familiar format use one of
the following options:
1 dd/mmm/yy
2 dd/mmm
3 mmm-yy
To return the date to an integer
number, select the General option in
formats.
- More on next page -
<24,1,38,42,7,14,48,11,0>
TEXT
Formulae are shown as they are entered
and numbers appear in general format.
<25,1,38,42,17,14,48,11,1>
LABEL PREFIX
When you select the label prefix
option you will be given the following
options:
LEFT
Choose Left and any labels you now
type will be left justified (this is
the default setting). If you want to
center a label precede the label with
^ and to right justify a label precede
it with "
- More on next page -
<25,1,38,42,17,14,48,11,0>
RIGHT
Choose Right and any labels you now
type will be right justified. If you
want to center a label precede the
label with ^ and to left justify a
label precede it with '
CENTER
Choose Center and any labels you now
type will be centered. If you want to
right justify a label precede the
label with " and to left justify a
label precede it with '
<26,1,38,42,20,14,48,11,1>
RECALCULATION
When recalculation is selected you
will have the following options:
AUTOMATIC RECALCULATION
The spreadsheet recalculates all the
formulae in the worksheet every time
you change the contents of any cell.
MANUAL RECALCULATION
You must press the Calc key to make
the spreadsheet recalculate the
results. The CALC indicator will
appear in the right hand corner of the
screen if recalculation is required.
- More on next page -
<26,1,38,42,16,14,48,11,1>
RECALCULATION ITERATION COUNT
Set the iteration count to tell the
system the number of times to pass
through the formulae when
recalculating.
If the interrelationships among the
cells include circular references,
more than one recalculation pass is
required to allow calculated values to
give the correct results.
- More on next page -
<26,1,38,42,18,14,48,11,1>
NATURAL RECALCULATION
The natural recalculation in the
spreadsheet takes care of the
interrelationships between all cells.
It does not recalculate a formula
until it has already processed any
other formulae it depends on.
COLUMNWISE RECALCULATION
You can change the order in which the
spreadsheet processes formulae so it
recalculates by column starting in
column A.
- More on next page -
<26,1,38,42,8,14,48,11,0>
ROWWISE RECALCULATION
You can change the order in which the
spreadsheet processes formulae so it
recalculates by row starting in row 1.
<27,1,38,42,8,14,48,11,0>
ENABLE AND DISABLE PROTECTION
Enable turns the protection on and
protection disable turns the
protection off.
<28,1,38,42,16,14,48,11,0>
COLUMN
To insert a blank column position the
cursor to the right of where you want
the blank column and press Return.
You can also specify a range of
columns.
ROW
To insert a blank row position the
cursor below where you want the blank
row and press Return. You can also
specify a range of rows.
<29,1,38,42,15,14,48,11,0>
COLUMN
To delete a column position the cursor
on the column to delete and press
Return. You can also specify a range
of columns to delete.
ROW
To delete a row position the cursor on
the row to delete and press Return.
You can also specify a range of rows
to delete.
<30,1,38,42,13,14,48,11,0>
SET
To set a new column width type in the
number or use the Left and Right Arrow
keys and press Return.
RESET
To return the column width to the
global setting, select the Reset
option and press Return.
<31,1,38,42,9,14,48,11,0>
ERASE - NO OR YES
You will be asked to confirm no or yes
to erase. If you select yes the
worksheet is erased. If you select no
the worksheet will be unchanged.
<32,1,38,42,18,14,48,11,1>
TITLES
When you select the titles option you
will be given a choice of the
following:
BOTH
You can fix the rows above the cell
pointer and the columns to the left of
the cell pointer. Position the cursor
beneath the row you want as fixed
titles and to the right of the column
you want as fixed titles and select
this option.
- More on next page -
<32,1,38,42,19,14,48,11,0>
HORIZONTAL
You can fix the rows above the cell
pointer. Position the cursor
underneath the rows you want fixed and
select this option.
VERTICAL
You can fix the columns to the left of
the cell pointer. Position the cursor
to the right of the columns you want
fixed and select this option.
CLEAR
Use the clear option to free any title
settings.
<33,1,38,42,15,14,48,11,1>
WINDOW
When the window option is selected you
will be given the following options:
HORIZONTAL
Position the cursor at the horizontal
division and select this option. You
can move the current cell position (or
cursor) from one window to another by
pressing the Window key.
- More on next page -
<33,1,38,42,20,14,48,11,1>
VERTICAL
Position the cursor at the position of
the vertical division and select this
option. You can move the current cell
position (or cursor) from one window
to another by pressing the Window key.
SYNCHRONISE
The initial setting for windows is
synchronised and if you scroll
horizontally in one horizontal window,
the other also scrolls. However,
vertically scrolling in a horizontal
window has no effect on the other
window.
- More on next page -
<33,1,38,42,16,14,48,11,1>
If you scroll vertically in one
vertical window, the other scrolls
with it. Horizontal scrolling in a
vertical window has no effect on the
other.
UNSYNCHRONISE
You can set the windows so they scroll
independantly of each other. For
example, if you scroll vertically in a
vertical window, the other will not
scroll with it.
- More on next page -
<33,1,38,42,8,14,48,11,0>
CLEAR
The clear window option returns the
worksheet to its initial, single
window display.
<41,1,38,42,12,14,48,11,1>
FORMAT
Use the format command to set the way
the spreadsheet displays numbers. It
does not change the values stored in
the cells. If you select this option
you will be given a choice of
different formats.
- More on next page -
<41,1,38,42,14,14,48,11,1>
LABEL PREFIX
The initial global setting for labels
is left justified but can be changed
to centered or right justified. The
range of cells can be overridden by
using the range label prefix command
or by preceding the label with ' for
left justified, " for right justified,
or ^ for centered.
- More on next page -
<41,1,38,42,17,14,48,11,1>
ERASE
You can use this command to erase cell
contents in a range and to remove
parts of the worksheet you no longer
require.
Specify the range by pointing or by
typing the range and pressing Return.
This will erase all the contents of
the cells in the range, so make sure
they are no longer needed or have been
saved.
- More on next page -
<41,1,38,42,14,14,48,11,1>
NAME
You can name a range of cells using up
to 15 characters. To create a range
name select this option and choose the
Create option.
You can use range names within
formulae instead of the cell address
which makes them more readable.
- More on next page -
<41,1,38,42,20,14,48,11,1>
JUSTIFY
This option will rearrange words
within a specified range. You can
type in labels and end them with a
Return, and use the Range Justify
option to extend or shortern the
length of the labels.
PROTECT
You can set the protection mode for a
range of cells so that those cells
cannot be changed by mistake or by an
another user. You have to make sure
that the Worksheet Global Protection
has been disabled.
- More on next page -
<41,1,38,42,20,14,48,11,0>
You can Range Protect the cells by
pointing to the range or by typing the
range and pressing Return.
UNPROTECT
You can unprotect a range of cells by
selecting this option and pointing to
the range or typing and pressing
Return.
INPUT
Use this option to restrict the cursor
movement to unprotected cells only.
This option can be used to prevent
users from overtyping a range of cell
contents.
<42,1,38,42,12,14,48,11,1>
FIXED
Fixed number of decimal places, from 0
to 15.
For example:
12.321 -4.27
- More on next page -
<42,1,38,42,14,14,48,11,1>
SCIENTIFIC
Exponent scientific notation. A
specified number (0 to 15) of decimal
places in the multiplier. Exponent of
10 from -99 to +99.
For example:
2.9E -02 6.3E+01 1.332E-11
- More on next page -
<42,1,38,42,20,14,48,11,1>
CURRENCY
The currency sign appears before each
entry and there will be commas between
thousands.
For example:
$12.02 $6.25 $8,781.98
COMMA
Commas are placed between thousands.
For example:
12.02 1,000,000 8,781.98
- More on next page -
<42,1,38,42,15,14,48,11,1>
GENERAL
This is the initial global display
format. Zeros after the decimal point
are suppressed. Very large and very
small numbers are displayed in
scientific exponent format.
For example:
10 6 3.4 1.3E-9
- More on next page -
<42,1,38,42,15,14,48,11,1>
+/-
Horizontal pictograph. The amount of
symbols represent the integer part of
the value. The + is for positive, the
- for negative and a fullstop
represents a zero.
For example:
+++ ----- .
- More on next page -
<42,1,38,42,14,14,48,11,1>
PERCENT
Percentage, with specified number of
decimal places, 0 through 15. The
number displayed is the value times
100, followed by the percent sign.
For example:
66.5% -14.25%
- More on next page -
<42,1,38,42,19,14,48,11,1>
DATE
The date can be entered by typing
+DATE(yy,mm,dd) It will be displayed
as an integer number but to display it
in a more familiar format use the
following options:
1 dd/mmm/yy
2 dd/mmm
3 mmm-yy
To return the date to an integer
number, select the General option in
formats.
- More on next page -
<42,1,38,42,11,14,48,11,0>
TEXT
Formulae are shown as they are entered
and numbers appear in general format.
RESET
Formulae are reset to the global
setting.
<43,1,38,42,19,14,48,11,1>
LEFT
Choose Left and any labels that are in
the range will appear left justified.
If you want to center a label in the
range precede the label with ^ and to
right justify a label precede it with
"
RIGHT
Choose Right and any labels that are
in the range will appear right
justified. If you want to center a
label in the range precede the label
with ^ and to left justify a label
precede it with '
- More on next page -
<43,1,38,42,11,14,48,11,0>
CENTER
Choose Center and any labels that are
in the range will appear centered. If
you want to right justify a label in
the range precede the label with " and
to left justify a label precede it
with '
<44,1,38,42,15,14,48,11,1>
CREATE
Enter the range name and press Return.
Then enter the range that you are
naming and press Return. To view a
named range, press Return after
selecting this option and choose a
range name by using the Arrow keys and
pressing Return, or by typing in the
name. The range will be highlighted
on the screen.
- More on next page -
<44,1,38,42,14,14,48,11,1>
DELETE
You can remove a range name from the
list of named ranges. The contents of
the cells in that range are not
affected.
Use the Arrow keys and press Return,
or type the name to be deleted and
press Return.
- More on next page -
<44,1,38,42,17,14,48,11,1>
LABELS
You can create one cell named ranges,
using labels in adjacent cells for the
range names.
To select one of the range names, use
the Arrow keys or type the range name
and press Return.
Position the cursor on one end point
of the range of labels to be used as
range names and select this option.
- More on next page -
<44,1,38,42,8,14,48,11,0>
You can select the Left, Right, Up or
Down options and the spreadsheet
creates a range name for the cell to
the left, right, up or down of the
label cell.
<51,1,38,42,18,14,48,11,1>
RETRIEVE
You can restore a worksheet into the
computers memory and display it
exactly as you saved it.
The spreadsheet browser appears when
this option is selected. Type in the
spreadsheet name or use the Arrow keys
to select the spreadsheet.
If you are currently working on a
spreadsheet, remember to save it first
before retrieving another.
- More on next page -
<51,1,38,42,20,14,48,11,1>
SAVE
This option creates a new file that
stores all the data currently in the
worksheet.
You should save the worksheet before
you exit from the spreadsheet if you
want to use the data at a later stage.
Type the worksheet file name using up
to 8 alpha numeric characters and an
extension of .WKS Alternatively,
select the file name if it is to
replace an existing file using the
Arrow keys and then press Return.
- More on next page -
<51,1,38,42,16,14,48,11,1>
If the file already exists then you
will be asked if you wish to replace
the existing file. If you do not,
then select the cancel option.
COMBINE
You can combine the data from two or
more worksheets.
This option combines part, or all of a
stored worksheeet with the one you are
currently working on.
- More on next page -
<51,1,38,42,13,14,48,11,1>
Cells brought into the current
worksheet may replace, be added to, or
be subtracted from the worksheet cells
they overlap.
Place the cell pointer at the upper
left corner of the area into which you
want to combine data from the
worksheet and select this option.
- More on next page -
<51,1,38,42,15,14,48,11,1>
XTRACT
This option creates a file that stores
all data currently in a range of
cells.
You will be given the choice of saving
formulae or values.
Give the file a name of up to 8
characters or use the Arrow keys if it
is replacing a previous file.
- More on next page -
<51,1,38,42,18,14,48,11,1>
ERASE
This option will erase a worksheet
file or print file.
You can select the file to be erased
by using the Arrow keys and pressing
Return or by typing the file name.
LIST
This option displays a list of
worksheet files and print files.
Press any key to return to the
worksheet.
- More on next page -
<51,1,38,42,17,14,48,11,0>
IMPORT
This option reads in external files
which have been prepared by other
systems or programs. The imported
file must have an extension of .PRN
DIRECTORY
You can override the global setting
which controls the disk drive to be
used for saving or retrieving files.
Press Return to keep it as the global
setting or enter another letter
followed by a colon to change it.
<52,1,38,42,17,14,48,11,1>
COPY
Entries from the worksheet file
replace entries in the current
worksheet.
ADD
The spreadsheet adds numeric values
from the worksheet file to the cells
they overlay. Blank cells and number
cells are affected and label and
formula cell remain unaffected in the
current worksheet.
- More on next page -
<52,1,38,42,14,14,48,11,0>
SUBTRACT
The spreadsheet subtracts numeric
values from the worksheet file to the
cells they overlay.
The global settings, named cells or
ranges, etc in the worksheet file are
not brought into the current
worksheet, only the cell contents are
combined.
<53,1,38,42,16,14,48,11,0>
FORMULAE
You can save the formulae. Type in
the file name to be used. If the file
name already exists you will be given
the option to replace the contents.
VALUES
You can save the current value of the
formulae. Type in the file name. If
the file name already exists you will
be given the option to replace the
contents.
<54,1,38,42,16,14,48,11,1>
WORKSHEET
If you select the worksheet option the
system will display all the saved
worksheets, type in the name of the
file to be erased or use the Arrow
keys and press Return.
PRINT
The system will display all the saved
print files. Select the required file
in the normal way.
- More on next page -
<54,1,38,42,16,14,48,11,0>
GRAPH
The system will display all the saved
graph files. Select the required file
in the normal way.
<55,1,38,42,19,14,48,11,1>
WORKSHEET
Use this option to display a list of
file names for worksheet files. The
worksheet will disappear and the file
names will be listed with the amount
of disk space available.
Press any key to return to the
worksheet.
PRINT
The system will display a list of file
names for print files. Press any key
to return to the worksheet.
- More on next page -
<55,1,38,42,8,14,48,11,0>
GRAPH
The system will display a list of file
names for graph files. Press any key
to return to the worksheet.
<56,1,38,42,13,14,48,11,0>
TEXT
You can import numbers and text into
the worksheet. They will be entered
into the worksheet, starting at the
cell pointer location.
NUMBERS
The system will search the .PRN file
for numbers and any series of
characters enclosed in quotes ie. "
and ". The characters enclosed in
quotes will create a left justified
label and will place the numbers and
labels from the same line of the print
file in successive columns of the next
row.
<61,1,38,42,19,14,48,11,1>
PRINTER
You can use the printer option to
produce output on the printer.
You will be given the same options for
the printer as you are given in the
print file option.
FILE
You can store the output in a print
file. You will be asked for a file
name, do not give the file name an
extension as it will automatically be
given an extension of .PRN
- More on next page -
<61,1,38,42,6,14,48,11,0>
You will be given the same options for
the print file as you are given in the
print printer option.
<62,1,38,42,18,14,48,11,1>
RANGE
You must specify the part of the
worksheet to be printed. You cannot
select the Go option before specifying
the range.
You can point to the range, or type
the range required.
LINE
You can use this option to advance the
printer one line and can be used to
separate printed ranges.
- More on next page -
<62,1,38,42,18,14,48,11,1>
PAGE
The page option will advance the
printer to the top of the next page.
OPTIONS
There are many options to control the
appearance of the printed spreadsheet.
CLEAR
The spreadsheet remembers the current
print settings. To cancel some or all
of these settings, use the Clear
option.
- More on next page -
<62,1,38,42,18,14,48,11,1>
ALIGN
You can use the align option to reset
the printer to start a new page from
the current position. Position the
paper using the spreadsheet line
command or manually.
GO
Use this option to send the contents
of the print range to the printer.
You must specify the range before
selecting this option.
- More on next page -
<62,1,38,42,8,14,48,11,0>
QUIT PRINTING
When you have finished printing select
this option to return to the Ready
mode.
<63,1,38,42,15,14,48,11,1>
HEADER
You will be asked for a header which
can be up to 240 characters and will
be printed at the top of each page.
If you enter an @ sign within the
header, today's date will be printed
in dd/mmm/yy format. If you enter #
the page number will be printed in the
header.
- More on next page -
<63,1,38,42,17,14,48,11,1>
The default for a header is left
justified. If a horizontal bar ø is
placed within the header then any text
after the bar is centered. If a
second horizontal bar ø is entered in
the header then any text after the
bars is right justified.
The header is only effective if the
print starts at the top of the page.
Use the align option to reset the
printer if more than one range is
being printed.
- More on next page -
<63,1,38,42,15,14,48,11,1>
FOOTER
You will be asked for a footer which
can be up to 240 characters and will
be printed at the bottom of each page.
If you enter an @ sign within the
footer, today's date will be printed
in dd/mmm/yy format. If you enter #
the page number will be printed within
the footer.
- More on next page -
<63,1,38,42,18,14,48,11,1>
The default for a footer is left
justified. If a horizontal bar ø is
placed within the header then any text
after the bar is centered. If a
second horizontal bar ø is entered in
the header then any text after the
bars is right justified.
MARGINS
You can set the left, right, top and
bottom margins of the printed page.
This will temporarily override the
global default printer margin
settings.
- More on next page -
<63,1,38,42,15,14,48,11,1>
BORDERS
This option prints sections of
specified rows above the corresponding
columns in the printed range. It will
print sections of specified columns
along the left edge of each page
alongside the corresponding rows.
You will be asked to specify a border
of a row or column.
- More on next page -
<63,1,38,42,15,14,48,11,1>
SETUP
You can send a setup string directly
to the printer. You can send a set of
control characters in order to invoke
such functions as changing the
typeface, changing the type size etc.
These instructions are sent to the
printer when the Go option is
selected.
- More on next page -
<63,1,38,42,18,14,48,11,1>
PAGE LENGTH
This option tells the spreadsheet the
total number of print lines per page
to insure proper alignment of the page
breaks, headers and footers. Use this
option to override the worksheet
global default page length setting for
the current worksheet.
OTHER
This option allows you to choose one
of four different types of output to
for the worksheet.
- More on next page -
<63,1,38,42,14,14,48,11,0>
You can have normal printing of cell
contents as they appear on the display
screen. Or you can have a special one
cell per line listing of cell entries
showing the formulae as text as they
are stored in the worksheet.
QUIT
When you have finished printing select
this option to return to the Ready
mode.
<64,1,38,42,18,14,48,11,1>
MARGINS
You can change the Left, Right, Top or
Bottom margin for printing.
LEFT
The left margin can be changed from 1
which is the default setting, to a
value between 0 and 240.
RIGHT
The right margin can be changed from
the default of 80, to a value between
0 and 240.
- More on next page -
<64,1,38,42,13,14,48,11,0>
TOP
The top margin can be changed from the
default setting of 2, to a value
between 0 and 10.
BOTTOM
The bottom margin can be changed from
the default setting of 2, to a value
between 0 and 10.
<65,1,38,42,17,14,48,11,1>
COLUMNS
You can print sections of specified
columns along the left edge of each
page alongside the corresponding rows.
For example, this could be used to
print column headings on the top of
every page on a report.
Specify the border range by using the
Arrow keys to point or by typing the
cell addresses.
- More on next page -
<65,1,38,42,18,14,48,11,0>
The previous borders are highlighted
when this option is selected.
ROWS
You can print sections of specified
rows along the top edge of each page
alongside the corresponding columns.
For example, this could be used to
print row labels on the left hand side
of every page on a report.
Specify the border range by using the
Arrow keys to point or by typing the
cell addresses.
<66,1,38,42,14,14,48,11,1>
OUTPUT FORMAT
You can choose one of four different
types of output format for the
worksheet.
AS DISPLAYED
This is the worksheet default setting
and shows the printed range as it
appears on the screen.
- More on next page -
<66,1,38,42,15,14,48,11,1>
CELL FORMULAE
The contents of the cells in the print
range will be printed one cell per
line. Each line contains exactly what
appears on the first line of the
worksheet when the pointer is on the
cell, the cell address, format,
protection status, if unprotected and
the actual cell contents. Blank cells
are ignored.
- More on next page -
<66,1,38,42,11,14,48,11,0>
FORMATTED
The worksheet will be printed with
page breaks, headers or footers.
UNFORMATTED
The range will be printed without page
breaks, headers or footers.
<67,1,38,42,21,14,48,11,0>
CLEAR
The spreadsheet has a print clear
command that restores all settings to
their default values. You can choose
to cancel all print settings at once,
or just some of them.
ALL
This option clears all settings.
Printing is restored to formatted, and
as displayed on the screen.
RANGE
This resets the current range that
would be printed when you select go.
The default range is A1..A1
- More on next page -
<67,1,38,42,12,14,48,11,0>
BORDERS
The border settings are cleared and
the default setting is A1..A1
FORMAT
This option will reset all margins,
page length and setup string to the
default settings.
<81,1,38,42,19,14,48,11,1>
FILL
You can number cells in columns or
rows in ascending numerical order.
You will be asked for the starting
value, the step value and the stop
value.
For example:
Numbering records in a database.
Numbering records to be sorted so
they can be restored to their
original order.
- More on next page -
<81,1,38,42,19,14,48,11,1>
TABLE
You can enter different values and see
what happens to them if you enter a
WHAT IF command.
SORT
You can sort the database in different
ways. For example, alphabetically,
chronologically, ascending or
descending, or by certain criterion.
You will be asked for the range to
sort and the primary key and, if
required, the secondary key.
- More on next page -
<81,1,38,42,14,14,48,11,1>
DATA QUERY
The query option enables you to enter
information into the worksheet and
select records in different ways.
DISTRIBUTION
You can summarise a range of numbers
by producing their frequency
distribution.
- More on next page -
<81,1,38,42,17,14,48,11,0>
Enter a series of values in ascending
order in a column. These values are
called the bin range and can be
located anywhere in the worksheet as
long as the column to the right of the
values in the bin range is available
and also one row below is available.
The columns to the right of the bin
range are where the results are
placed.
You will be asked for the range of
numbers for their frequency
distribution.
<82,1,38,42,18,14,48,11,1>
TABLE 1
This is the first type of data table
and has a single list of entries. You
will be asked for the data table range
and the input cell.
The input cell can be a blank cell or
the worksheet may already include a
formula which depends on the input
cell.
To run the data table, press the Table
key.
- More on next page -
<82,1,38,42,14,14,48,11,1>
You can reset the data table range and
the input cell be selecting the reset
option.
TABLE 2
This is the second type of data table
which is similar to Data Table 1, but
uses two input cells. You will be
asked for the data table range and the
input cells.
- More on next page -
<82,1,38,42,16,14,48,11,1>
The cell in the top left hand corner
contains the formula which relates to
the two input cells. The top row and
the first column of the data table are
entries, these can be labels, formulae
or numbers.
Press the Table key and the table will
produce a record of the effects of all
possible pairs of input entries based
on the formula in the top left hand
corner.
- More on next page -
<82,1,38,42,13,14,48,11,0>
For example, you could determine the
profit margin if you give a certain
percentage or a mark-up value by using
those values as the entries and
setting up a data table 2.
RESET
The reset option will reset the table
ranges and input cell ranges on the
worksheet.
<83,1,38,42,17,14,48,11,1>
RANGE
This is the range of the data to be
sorted, do not include the field names
otherwise they will be sorted too!
PRIMARY KEY
You can sort on one or two fields. In
either case you must specify the
primary key for sorting. This is the
first field or the only field to be
sorted. Specify whether the sort is
to be ascending or descending.
- More on next page -
<83,1,38,42,17,14,48,11,1>
SECONDARY KEY
Use this option if you are sorting on
two fields. You will have already
specified the first field to sort
(primary key), use the secondary key
in the same way by specifying whether
it is ascending or descending.
RESET
The system remembers the current sort
settings. Use the Reset option to
clear these settings.
- More on next page -
<83,1,38,42,13,14,48,11,0>
GO
Select the Go option to perform the
sort. The data records will then
appear rearranged according to your
sort settings.
QUIT
This option will take you back to the
Ready status on the worksheet.
<84,1,38,42,15,14,48,11,1>
INPUT
You must specify the input range of
the database before any queries can be
carried out.
CRITERION
Data records are selected by using a
criterion. The criterion range must
be specified before any queries can be
carried out.
- More on next page -
<84,1,38,42,19,14,48,11,1>
OUTPUT
An output range is only necessary if
you use the extract or unique commands
to copy selected records. It is not
necessary if you are deleting or
finding selected records.
FIND
The find operation will highlight the
selected records. The first record
which satisfies the criteria will be
highlighted. To find the next record
which satisfies the criteria, press
the Down Arrow key, and so on.
- More on next page -
<84,1,38,42,16,14,48,11,1>
EXTRACT
Providing you have specified an output
range when the extract query is used,
the selected records are copied and
placed in the output range.
UNIQUE
The unique option will copy the
selected records but will take out
duplicate copies so that no identical
records appear in the output range.
- More on next page -
<84,1,38,42,18,14,48,11,1>
DELETE
The delete option will remove the
selected records from the input range
and the remaining records will move up
to fill the empty rows.
You will be asked to confirm this, as
the process cannot be reversed.
RESET
Use this option to reset the data
query ranges and also the last query
command.
- More on next page -
<84,1,38,42,9,14,48,11,0>
REPEATING THE QUERY COMMAND
You can use the Query key to repeat
the query command after changing
criteria or data. The last query
operation will be repeated.
<91,1,38,42,16,14,48,11,1>
COPY RANGE
When the copy command is selected the
system will display the range to copy
FROM as the current cell address, if
this is correct press Return.
To change the range to copy FROM, you
can type in the new values, for
example A11..A16 and press Return. Or
you can use the Arrow keys to change
the cell adresses.
- More on next page -
<91,1,38,42,14,14,48,11,1>
If you want to change the first range
value (the A11) then press the Esc key
first and then use the Arrow keys to
change its value, then press one
fullstop character to display the
second range.
If you have used the pointing method
to specify the range, those cells will
be highlighted.
- More on next page -
<91,1,38,42,12,14,48,11,0>
Press Return after you have pointed or
typed the range and you are prompted
for a range to copy TO. Use one of
the above methods to change the range.
After pressing Return the range of
cells will be copied to the TO range
and the cursor will return to the
first cell in the FROM range.
<92,1,38,42,16,14,48,11,1>
MOVE RANGE
When the move command is selected the
system will display the range to move
FROM as the current cell address, if
this is correct press Return.
To change the range to move FROM, you
can type in the new values, for
example A11..A16 and press Return. Or
you can use the Arrow keys to change
the cell adresses.
- More on next page -
<92,1,38,42,14,14,48,11,1>
If you want to change the first range
value (the A11) then press the Esc key
first and then use the Arrow keys to
change its value, then press one
fullstop character to display the
second range.
If you have used the pointing method
to specify the range, those cells will
be highlighted.
- More on next page -
<92,1,38,42,12,14,48,11,0>
You will then be prompted for a range
to copy TO. Use one of the above
methods to change the range.
After pressing Return the range of
cells will be moved to the TO range
and the cursor will return to the
position of the first cell that was in
the FROM range.
<101,1,38,42,17,14,48,11,0>
QUIT
When the quit option is selected you
are asked to confirm yes or no.
If you select the yes option the
system will return to the desktop and
the current worksheet will be lost.
You will normally have saved your work
before using this option.
If you select the no option the
worksheet will return to the Ready
status in the worksheet.
<110,1,38,42,12,14,48,11,1>
TYPE
There are five types of graphs that
you can produce. These are:
Line graph Bar graph
XY graph Stacked bar graph
Pie chart
- More on next page -
<110,1,38,42,23,14,48,11,1>
DATA RANGES
There are six data ranges that you can
use to store values for plotting which
are ranges A through F. The X data
range is used to store the X values
for XY graphs and Y labels for other
types of graph.
For pie charts the segment values are
stored in the A data range and the B
data range is used to indicate the
colour to be used and whether the pie
segment is to be exploded.
Choose one of the data ranges for
input and you can then type in the
starting and end cell positions or use
pointing in the normal way.
- More on next page -
<110,1,38,42,19,14,48,11,1>
RESET
The reset option allows you to reset
all the graph settings or individual
data ranges.
VIEW
The view option allows you to view the
graph on screen or to produce hardcopy
output. This will depend on the
graphics device driver you have
loaded. Use the view option when the
data ranges have been defined and all
settings made. Press ESC when you have
finished viewing your graph.
- More on next page -
<110,1,38,42,16,14,48,11,1>
SAVE
The save command is for future use.
OPTIONS
Options allows you to set the
following parameters.
Legend Format (Line and XY)
Titles Grid
Scale Colour or B&W
Data labels
- More on next page -
<110,1,38,42,18,14,48,11,0>
NAME
The name option allows you to create
graph names. The system can store as
many graph types as you wish. You can
give the current settings a name which
can be recalled later for use. The
graph names can be deleted or the
entire set of names cleared using the
name reset option.
QUIT
When you have finished with
spreadsheet graphics use the quit
option to return to the command menu.
<120,1,38,42,20,14,48,11,1>
LINE GRAPH
Line graphs take data from data ranges
A through F and plots them as a series
of lines and/or symbols.
BAR GRAPH
Bar graphs can consist of a series of
vertical bars with up to six bars for
each data set.
XY GRAPH
XY graphs take the X values from the X
data range and plots them against Y
values stored in data ranges A through
F.
- More on next page -
<120,1,38,42,15,14,48,11,0>
STACKED BAR
Stacked bar graphs plot the bars one
on top of each other for each data
set. The values for the bars are taken
from data ranges A through F.
PIE CHART
The pie segment values are stored in
the A data range, segment labels in
the X data range, and colour values in
the B data range.
<130,1,38,42,14,14,48,11,0>
RESET DATA RANGES
You can reset the graph settings by
using the first option or individual
data ranges by selecting the data
range to clear. Any values stored in
the ranges will be cleared down to
zero.
Use the quit option to return to the
graph command menu.
<140,1,38,42,18,14,48,11,1>
LEGEND
This option allows you to enter the
graph legend for any of the data
ranges being used - A through F. If
data values have not been set for a
range then no legend will appear on
the graph.
FORMAT
The format option is used on Line and
XY graphs. You can set the format to
be lines, symbols, both or none for
all ranges or individual data ranges.
- More on next page -
<140,1,38,42,23,14,48,11,1>
TITLES
The titles option allows you to enter
graph titles and X and Y axis titles.
GRID
The grid option allows you to select a
horizontal, vertical or both
horizontal and vertical grid for the
graph.
SCALE
The scale option allows you to specify
the scale type for the X and Y axis.
The system will do automatic scaling
for you but there will be times when
you want to override this and you can
enter in upper and lower values to be
used for graph scaling.
- More on next page -
<140,1,38,42,13,14,48,11,1>
COLOUR
If you have a colour graphics device
then use this option to obtain output
in colour.
BLACK AND WHITE
If you are using Black and White
graphic devices then use this option
to obtain monochrome or single colour
output.
- More on next page -
<140,1,38,42,15,14,48,11,0>
DATA LABELS
You can use this option to set data
labels for any of the data ranges A
through F. Having defined the data
labels use the quit option to recall
the options menu.
QUIT
When you have finished with the
options menu use the quit option to
recall the graph command menu.
<150,1,38,42,17,14,48,11,1>
USE
This option will recall a previously
created named graph and make it the
current graph settings. When selected
type in the graph name and press
RETURN. The system will then display
the graph.
CREATE
You can create graph names to store
the current settings. Graph names can
be up to 16 characters long.
- More on next page -
<150,1,38,42,18,14,48,11,0>
DELETE
When a graph name is no longer
required use this option to delete it
from the spreadsheet. Once deleted the
settings cannot be recalled.
RESET
This option will delete all graph
names from the spreadsheet. Care
should be exercised before this option
is run because the graphs cannot be
reinstated afterwards.
<141,1,38,42,9,14,48,11,0>
DATA RANGE LEGEND
First select the data range you want
to enter legend for. Then type in the
legend which can be up to 20
characters.
<142,1,38,42,10,14,48,11,0>
RANGE FORMAT
Select the format for all graph ranges
or an individual data range A through
F. When complete press the quit option
to return to the previous command
menu.
<143,1,38,42,21,14,48,11,0>
FIRST TITLE
The first tile will appear at the top
of the graph and can be up to 40
characters long.
SECOND TITLE
The second title line will appear
below the first line and can also be
up to 40 characters.
X AXIS TITLE
This will appear on the X axis and can
be up to 40 characters.
Y AXIS TITLE
This will appear on the Y axis and can
be up to 40 characters.
<144,1,38,42,14,14,48,11,1>
HORIZONTAL GRID
If this option is selected a series of
horizontal lines will be plotted on
the graph.
VERTICAL GRID
If this option is selected a series of
vertical lines will be plotted on the
graph.
- More on next page -
<144,1,38,42,12,14,48,11,0>
BOTH
This option will produce a grid
consisting of both horizontal and
vertical lines.
CLEAR
Use this option to clear the grid if
one has been previously selected.
<145,1,38,42,12,14,48,11,1>
Y SCALE
Use this option to set the scale on
the Y axis.
X SCALE
Use this option to set the scale on
the X axis.
- More on next page -
<145,1,38,42,16,14,48,11,0>
SKIP
You can tell the system to skip
certain values when plotting data from
the range. For example if the data
range consists of 12 values and the
skip factor is set to 3 then only 4
values will be plotted which are 1,4,8
and 12.
When you select the skip option type
in the skip factor which can be in the
range of 1 through 8192.
<146,1,38,42,9,14,48,11,0>
DATA LABEL RANGES
First choose the data label range A
through F then type in the cell range
or use pointing. When complete use the
quit option to recall the last menu.
<147,1,38,42,14,14,48,11,1>
AUTOMATIC SCALE
Use this option to make the
spreadsheet perform automatic scaling.
This is the default setting.
MANUAL SCALE
You can perform manual scaling by
choosing this option and then typing
in lower and upper values.
- More on next page -
<147,1,38,42,17,14,48,11,0>
LOWER SCALE VALUE
If you are using manual scaling type
in the lower value here.
UPPER SCALE VALUE
If you are using manual scaling type
in the upper value here.
SCALE FORMAT
Use this option to determine the
format to be used for the numerical
values that appear alongside the
tickmarks on the graphs axes.
<148,1,38,42,23,14,48,11,0>
CENTRE
Use this option to centre the data
label above the point.
LEFT
Use this option to position the data
label to the left of the point.
ABOVE
Use this option to position the data
label above the point.
RIGHT
Use this option to position the data
label to the right of the point.
BELOW
Use this option to position the data
label below the data point.
<149,1,38,42,23,14,48,11,0>
LINES
The lines option will produce a line
between the data points. This option
is only used on Line and XY graphs.
SYMBOLS
The symbols option will produce a
graph symbol at each data point. The
symbols will be different for each
data set. This option is only used on
Line and XY graphs.
BOTH
This option will use both lines and
symbols on your graph.
NEITHER
This option will not use lines or
symbols at the data points.
«eof»