DG-CALC MANUAL

Typed by SIDEWINDER of LSD.


Welcome to DGCALC.
DGCALC is the culmination of careful examination and research into the world
of spreadsheet applications.  From industrialists and business users to
hobbyists, educationalists and home users.

DGCALC performs all of the essential functions required in the majority of
spreadsheet applications.  DGCALC is therefore simple to use, fast and
efficient since it is not complicated by gimmicks or unnecessary features.

Also, DGCALC works with other computer programs.

This manual will cater for experienced computer users as well as those who are
embarking on a computerised spreadsheet for the first time.

However, from whatever points you wish to start, we do suggest that you read
the first sections very carefully.  You'll probably save a lot of time by
working through the tutorial section.  This doesn't take long and it will
enable you to become familiar with most of the features of the program.

If you are reasonably experienced, and patience is not one of your virtues,
then it is possible to get going quickly by reading the Reference Section.
This will quickly point you in the right direction, and avoid unnecessary
detail.

FUNCTION/STATISTICAL TERMINOLOGY

+,-,/,*,^ - Add, subtract, divide, multiply, to the power (executed in
            conventional priority).

ABS       - Absolute value of a number: all negative numbers become
            positive.

AVERAGE   - A single number which is representative of the size of numbers
            in a group.  Its main use is to describe a characteristic of
            the group.  It is calculated by adding up all the numbers and
            dividing the total by however many numbers there are.

COS     -   Cosine: a trigonometric function (calculated in radians).

COUNT   -   This gives the number of figures in a group and is particularly
            useful for statistical calculations.

EXP     -   Exponential: use to calculate the natural logarithm base E to a
            power.

LOGTEN  -   Logarithm: to the base 10

LOG     -   Logarithm: to the base E (natural logarithm).

MAX     -   Maximum: used to determine the highest number in a group.

MIN     -   Minimum - used to determine the lowest number in a group.

ROUND   -   Rounding a number simply means reducing it's accuracy.  For
            example, £12.83 rounded to the nearest pound is £13, while
            £12.33 rounded to the nearest pound is £12.

SIN     -   Sine: a trigonometric function (calculated in radians).

SQRT    -   Square root: a number, which when multiplied by itself, gives a
            given number.  For example, the square root of 9 is 3, since
            3 x 3 = 9.

SUM     -   To total a range of figures by means of addition.

TAN     -   Tangent: a trigonometric function (calculated in radians).

TRUNC   -   Truncate: remove all digits after the decimal point. (Similar
            to ROUND, but always rounds down.)

OPERATING NOTES
The program works in two different modes:

Menu    -   (Press /)           for selecting Main Menu Options

Browse  -   (press ESCAPE)      for scrolling/editing the spreadsheet

DGCALC is completely menu driven.  This means that every option is selectable
from menus.  When you first load the program, the Main Menu appears at the top
of the screen.

Before selecting a Main Menu option make sure that you are in Menu mode.  You
may do this by pressing /, a highlighted bar will then appear over the first
Main Menu option.  To return to Browse mode, press ESCAPE.

SELECTING FROM THE MAIN MENU:
You may do this in three ways:

1. Using the left and right cursor keys to position the highlighted bar over
the option required and then press RETURN.  The advantage of using this
option is that a description of the option is displayed directly underneath
the Main Menu.

2. Press a letter on the keyboard corresponding to the first letter of the
option that you have selected (e.g., press A if you require the 'Attr'
option).

3. Using the mouse to position the highlighted bar over the option required
and then 'click'.

SELECTING FROM SUB MENUS:
Follow the same procedure as previously.  However, many options will have
defaults already inserted, to accept these simply press RETURN (or 'click' the
mouse).
IMPORTANT NOTE:
If you wish to leave any menu option and return to Browse Mode, press ESCAPE.
However, if you wish leave DGCALC, always use the QUIT option from the Main
Menu.

BROWSE MODE:
When in Browse mode, the current cell contents (i.e., where the highlighted
bar is positioned on the spreadsheet) are displayed in the top left-hand corner
of the screen.  There are various commands available when you are in Browse
mode:

Key                             Action
LEFT ARROW:             move 1 cell left
RIGHT ARROW:            move 1 cell right
UP ARROW:               move 1 cell up
DOWN ARROW:             move 1 cell down
CTRL L:                 move 1 page left
CTRL R:                 move 1 page right
CTRL U:                 move 1 page up
CTRL D:                 move 1 page down
CTRL C:                 centre highlighted bar (within spreadsheet)
CTRL E:                 edit current cell contents

IMPORTANT NOTE:
CTRL E allows you to edit the current cell content (mouse users may 'click' on
the top line of the screen).  If, however, you simply start typing, the
current cell contents will be replaced.

THE LINE EDITOR
At all times when entering information into the DGCALC, the built-in line
editor may be used to correct/edit what is being typed in.  Very often a
'default' value will appear, in which case just pressing RETURN will enter
that value.

Key                             Action
LEFT ARROW:             move 1 character left
RIGHT ARROW:            move 1 character right
DELETE:                 delete 1 character left
CTRL X:                 delete 1 character right
CTRL I:                 insert 1 character
CTRL W:                 delete (wipe) line from cursor position
RETURN:                 complete entry/accept default
ESCAPE:                 may be used at any time to exit and return to Browse
                        mode.

IMPORTANT NOTE:
Whilst editing a cell, if you wish to restore the previous contents, press
ESCAPE (or CTRL A).  Having completed an edit (i.e., you have pressed RETURN),
the previous contents may be restored by using the Main Menu option UNDO.
To clear the contents of the current cell, press SPACE BAR.

CAPACITY
DGCALC is a memory based program.  This means that whilst you are using the
program, both DGCALC and your spreadsheet will be in the computer's memory.

As a result, DGCALC is very fast.  However, the total number of cells you may
enter in one file will be limited to the memory of your computer.

If your computer's memory becomes full, DGCALC will display the message 'no
more room'.  AT THIS POINT WE STRONGLY RECOMMEND THAT USERS REDUCE THE SIZE OF
THEIR SPREADSHEET.

DATA FILES AND THEIR SECURITY
These data disks will contain all the information that you will be typing into
the system in the future.  It is therefore very important to keep back up
copies of these disks, on a regular basis, in case a fault develops.

Although time consuming, imagine how much time it will take you to re-type,
say 100 rows of information.  Faults can develop on disks and it can be very
difficult or impossible to recover your lost data.

The standard method of securely backing up your data disks is as follows:

1. For each current data disk you use when running the program keep 3 copies.

2. Label the 3 copies:
   Grandfather, Father and Son

For example:-
   Customer Data Grandfather
   Customer Data Father
   Customer Data Son

3. After each day of processing, copy the contents of the data disks you        have
been using onto the next logical relative.

For example, if you have been using Grandfather copy the contents onto Father.
If you use Father copy it onto Son.  If you use Son copy it onto Grandfather.
Be sure to check you are copying the disks the right way and not copying over
today's data with yesterday's!  This is illustrated below:

                                   FATHER
                                 /        \
                                /          \
                            SON    <----     GRANDFATHER

4. At the next session use the next version of your data disk (i.e., Father,
if you had been using Grandfather previously).

By rotating the use of each disk day by day you will extend their life and
reliability.  Also you will be automatically maintaining the previous day's
data (since you only copy the current data onto one generation).  Thus
providing an extra security of maintaining the previous day's information as
well as the current day.

You may find it helpful to keep a simple log, showing the date each disk was
used.  By using this method you will know exactly which version to use each
day.

TUTORIAL SECTION
You should have backed up DGCALC and have some idea of the facilities
available.  The purpose of this section is to work through step by step the
setting up of a simple spreadsheet.  This will help demonstrate the concept
behind DGCALC.

RECENT AMENDMENTS
Any amendments to DGCALC not covered in this manual will be included on the
program disk in a file called 'READ.ME.'.  By cataloguing the disk, check to
see if this file exists and if so, see Appendix 2.  Be sure to print and read
the file BEFORE continuing.

FIRST CONCEPTS
A spreadsheet is a computer program designed primarily to handle 'number
crunching'.  This is a term applied to handling large amounts of numeric
calculations.

As we discovered earlier in the Operating Notes section, DGCALC works in two
different modes:

Menu mode - for selecting functions, options, etc.
Browse mode - for entering/editing text, numbers, formulae, etc.

Firstly, we must set up a spreadsheet.  A typical application might be a price
list.

IMPORTANT NOTE
When using DGCALC, you may use either upper or lower case letters.

Consider a number of consumer products, each having a unique price, and we
wish to generate a price list.  We will require the price of each product with
various discount percentages.

Initially we would make a sketch of the layout.  It should look something like
this:

Product         PRICE   20%     30%     40%     50%     60%

Gloves          15.00
Hat             25.00
Coat            64.00
socks           5.99
Tie             12.95

We already know the price of the products, but we want the program to
calculate the discounts.

Now that we have a rough idea of what the spreadsheet is going to look like,
we can configure DGCALC.  When you first load the program, the spreadsheet is
blank.

CELL REFERENCES
Each column is lettered from A to AZ (A-Z and AA-AZ), and each row is numbered
from 1 to 511.  therefore the reference of the cell at the intersection of
column C with row 8 is C8.

When entering a range of cell references, two formats may be used:

A1, C1, AF23    -       to select just a single cell.
A1:F1, A1:F6    -       to select a column, row or range of cells.

All of the cell attributes (e.g., justification, number of decimal places,
etc.) are already setup.  If you wish to change these, you may do so at any
stage.  The only important option is to check now is the column width.  The
program is currently setup for 9 characters width for each column.

Clearly, for our example, it is unnecessary to assign 9 characters per column,
we will therefore set the first column (Product Descriptions) to 11
characters, the second (Price) to 8 and the rest to 6.

IMPORTANT NOTE:
Notice that the above column width allows an extra character for spacing
between each column.

From the Main Menu, positioning the highlighted bar over the WIDTH option (by
pressing / and then using the right arrow key).  Notice that directly under
the Main Menu, the program offers a description of each option when
highlighted.  Move the highlighted bar, using the right and left cursor keys
to examine the description of each Main Menu option.

Now reposition the highlighted bar over the WIDTH option and press RETURN.
DGCALC will prompt you to enter the range.  Notice the default of the current
column (which is indicated by the highlighted bar within the spreadsheet), in
this case A.  Since we only wish to set column A to a width of 11 characters,
press RETURN to accept the default.  Now enter the new column width.  Notice
that the current size (i.e., 9) is the default.

After pressing RETURN, you will see column A increase in width from 9 to 11
characters.  Now select WIDTH again.  Since we have already set the required
width for column A, we now want to over-type the default to the next column in
our spreadsheet, in this case B.  Set the width to 8 and press RETURN.

In our example we require 7 columns.  We must therefore now set the column
width for the next 5 columns, since we have already setup column 1 (or A) and
column 2 (B).  We therefore want to set the column width for columns C to G.
When entering a range, as opposed to one column/row/cell reference, it is
necessary to separate the references with a colon.  Therefore enter C:G to
indicate that you wish to set the column widths for columns C to G.

Now enter the column width, again DGCALC will offer a default (11, since this
is the size you set column A), so over-type this with 6 and press RETURN.

Now that the column widths have been setup, we can proceed with entering the
information.

Firstly, we will enter the column titles.  Select TITLE from the Main Menu.
Type:

PRODUCT

and press RETURN.

(Be sure the highlighted bar is positioned over cell A1).  Now move the
highlighted bar to the next column by using the right cursor key.  Set the
title to column B as PRICE, column C as 20%, column D as 30%, column E as 40%,
column F as 50% and column G as 60%.

Using the left arrow key, move the highlighted bar back to column A.  We can
now enter information into the cells.

There are two methods of entering information into a cell:

1. Number/formulae.
Simply type the numbers/formulae and press RETURN.
2 Text, comments, etc.
As above, except precede the entry with ' (single quote) or '' (double quote).

IMPORTANT NOTE:
DGCALC will not calculate cells preceded with ' or '', since these should only
contain supporting text.  If however, you enter text not preceded by ' or ''
the program will prompt:

Bad cell content

IMPORTANT NOTE:
If at any stage you wish to return to the Main Menu and leave the current
option, press ESCAPE.

IMPORTANT NOTE:
From now onwards we will only refer to the '' symbol to precede any text
entry.  You may, of course, use either the '' or '.

IMPORTANT NOTE:
Refer to the Editor facilities in the Operating section or Quick Reference
Card.

Since we wish to enter the product name, type ''.  Notice the flashing cursor
at the very top of the screen, the current cell position is also indicated
(i.e., A1) to the left of the cursor.  Therefore, any information entered at
this point, will be put into cell A1.  Type:

Gloves

and press RETURN.

The word 'Gloves' has now been entered into cell A1 and the highlighted bar
has moved rightwards to the next cell automatically.  (As we will discover
later, it is possible to set the direction of the highlighted bar.)

We now wish to enter a figure (15.00) rather than text and so it is not
necessary to precede the entry with ''.  Simply type:

15

and press RETURN.

IMPORTANT NOTE:

The reason the figure is displayed as 15.00, although you entered 15, is
because each cell has been set to display figures to 2 decimal places.  (You
may define the number of decimal places (0-7) as we will see later.)

Now move the highlighted bar to the beginning of the next row and fill in the
other products and prices.

The highlighted bar should now be on cell C5.

IMPORTANT NOTE:
You can immediately tell which cell you are on by looking at the top left
corner.  Notice also, in the top right corner, the last cell of the
spreadsheet is indicated (when in Menu Mode).

Now that all the necessary information has been entered, we can start
calculating the figures for the empty cells.

Move the highlighted bar to cell C1.  This cell should represent the total
price less 20% discount.  We can calculate this by using the formula 15*0.8
(where * represents multiply).  Rather than type the number 15, we can enter
the cell reference B1 (since it contains the price of 15).  Therefore type:

B1*0.8

into cell C1 and press RETURN.

IMPORTANT NOTE:
All decimal points (e.g., 0.5, 0.2) must be preceded by 0.

Notice that DGCALC immediately calculates the value (12.00).

Now that the formula B1*0.8 may be copied throughout the C column because when
the contents of C1 (the formula B1*0.8) are copied, DGCALC will automatically
replace B1 with B2, B3, B4 and B5 as appropriate.  Therefore every price will
automatically be substituted into the formula.  This is one of the major
advantages of computerised spreadsheets in that the program is intelligent
enough to substitute values where appropriate.  This is called RELATIVE
COPYING.

If, at this stage we had entered 15*0.8 for the formula, the program will copy
that formula into each column and that clearly would be incorrect (the same
result would be achieved by performing RELATIVE COPYING on the formula
B1*0.8).

To copy a formula into a cell or range of cells proceed as follows:

Select copy from the Main Menu and enter the source range/cell, in this case
C1 and press RETURN.  Now enter the destination range/cell, in this case C2:C5
and press RETURN (since you wish to copy the formula calculating 20% discount
for each product).  Now select to copy RELATIVE.

DGCALC will now calculate 20% discount for each product.  Move the highlighted
bar up and down column C and notice how DGCALC has copied the same formula
throughout the column substituting the appropriate price (cell reference).

We have just copied a basic formula from one cell to a range of cells within
one column.  It is also possible to copy a range of cells to another range of
cells.

To demonstrate this, let us enter all of the formulae for row 1 and copy those
formulae to the rest of the spreadsheet.
Move the highlighted bar to cell D1, type:

B1*0.7
and press RETURN.

The highlighted bar will move to cell E1, type:

B1*0.6
and press RETURN.

The highlighted bar will move to cell F1, type:

B1*0.5
and press RETURN.

The highlighted bar will move to cell G1, type:

B1*0.4
and press RETURN.

You should now have all of the different discounts for 'Gloves' displayed.
Now let us copy those formulae to the other rows.
Select COPY from the Main Menu.  Enter the source range/cell as:

D1:G1

(i.e., D1, E1, F1, G1) and press RETURN.

We now wish to copy the formulae into an area starting from D2 to the bottom
at G5.  By specifying the top left-hand corner and bottom right-hand corner,
this will include D2, E2, F2, G2, D3, E3, F3, G3, D4, E4, F4, G4, D5, E5, F5,
G5.  In other words, the contents of the box specified by the corner cell
references.  Therefore enter the destination range/cell as:

D2:G5

Select to copy RELATIVE as previously.

Your spreadsheet is now complete.  By using formulae, values have been
calculated for the percentage discounts based on the price.  By copying cells,
large spreadsheets can be developed and the program will automatically
substitute the correct cell reference or range as appropriate.

Computerised spreadsheets are particularly useful for performing quick
calculations or 'what-if' calculations.

For example, we could experiment by increasing one of the prices of our
products and instantly see how this will affect the price after discount.

Experiment by moving the highlighted bar over B1, the price of the gloves, and
change the contents which are displayed at the top of the screen (either press
CTRL E to edit contents or simply over-type).  Change 15 to 20.  Notice how
the figures on the spreadsheet have been instantly recalculated.

Statistics may also be applied to a cell or range (see Function/Statistic
terminology).  For example, if we want to total the contents of column B
(prices) we would enter the following formula into cell B7:

SUM(B1:B5)

Naturally, the above formula could be entered into any cell, but the
spreadsheet looks more conventional to place the total under the column.

But leaving a gap between the last entry and the total, there is room to place
a few dots to create a clear separation.  Move to cell B6 and type:

''_ _ _ _ _ _ _

Using the sample spreadsheet we have just created, work through the Reference
Section and experiment with each option.

Now that we have completed our first spreadsheet, let us briefly run through
each Main Menu option.  Notice that each option has an accompanying
description.  Use the left and right cursor keys to move the highlighted bar
over each option displayed.

Select ATTR from the Main Menu, this is used to set the attributes of each
cell.  Select B1 for the range (so that we will only set the attributes for
cell B1).  Each subsequent option will default as SAME, in other words, the
particular attribute will remain unchanged.  The first is Lock/Unlock.
Sometimes you might want to 'lock' a cell, thereby preventing accidentally
editing.

The second is justification and the third zero suppression.  The fourth is the
number of decimal places (currently set to 2).

We have already experimented with COPY, and so move onto DEL.  You first
select to delete a row or column, and then the quantity.

FILE is for saving, loading and printing your spreadsheet.  Select SAVE, and
type your filename for your spreadsheet and press RETURN.  Your spreadsheet
should now be stored on disk.  An identical spreadsheet to the one you have
just setup is supplied on your program disk.  If you wish to load the file,
select LOAD and type DEMO for the filename.

GOTO - jump to a cell in your spreadsheet.  Simply enter the cell reference.

HOLD - hold row/column(s) on the screen allowing the scrolling of the
spreadsheet underneath.

INS - insert a row or column.  This works in the same way as DEL.

MISC - miscellaneous functions. including:

DIRECTION:      For setting the direction of the highlighted bar (it
                currently moves rightwards after data entry).

FUNCTION KEYS:  The function keys of your computer may be programmed with
                formulae or text, saving repetitive entry of common
                information.

PASSWORD:       Any spreadsheet created with DGCALC may be given a
                password, restricting access to any confidential
                information.

OS - enter operating system command, such as DIR for directory listing.

TITLE - set the title of each column as we used previously.

UNDO - 'undoing' the previous edit.  If, for example, you deleted a formula by
mistake, this feature will retrieve old contents.

WIDTH - set the column width as we used previously.

QUIT - leave DGCALC.

REFERENCE SECTION
IMPORTANT NOTE:
Floppy disk users, format a blank disk before adding/creating any
spreadsheets.  You will need it later to store your spreadsheet files.

IMPORTANT NOTE:
Many of the following options require the RANGE to be specified.  Usually the
current cell is given as a default.  You may, of course enter any cell
reference or any range of cells (e.g., A4, A1:AE1, A1:H7).  Use the range
A1:AZ511 to affect the whole spreadsheet.

IMPORTANT NOTE:
When referring to the CURRENT Position of the spreadsheet, we are referring to
the position of the highlighted bar.

IMPORTANT NOTE:
All decimal points must be preceded by 0 (e.g., 0.5).

GENERAL NOTES:

CELL CONTENTS
Any cell may contain up to 70 characters.  However, the top line of the screen
normally only shows the first 36 characters, except when editing.

OVERFLOW
Numbers (including decimal places) exceed the width of a column will be
represented by asterisks.  If this occurs, increase the width of the column.

TEXT OVERFLOW
Text entered into a cell, where the column width is less than the length of
the text, will overflow into the following columns providing they are blank.
This applies to TEXT entries only (i.e., any entries preceded by '' or ').
Text overflow is particularly useful for titles and commentary, etc.

IMPORTANT NOTE:
If the first cell containing text overflow is not on the screen, the entire
text will not be displayed.

ENTERING FORMULAE
When using mathematical functions (see Function/Statistical Terminology), the
range/cell reference must be enclosed in brackets.  For example.  SUM(A1:A6),
SQRT(B3), SQRT(ABS(A1)).  You may use up to any level of parenthesis.

USER DEFINABLE FORMULAE
User Definable Formulae (UDF) are a way of storing commonly used or complex
formulae normally entered into numeric cells.  Row 0 is designated for UDF.
It is not possible to browse this row, since it is not part of the spreadsheet
and is unaffected by copying/inserting/deleting rows or columns.

To edit UDF, use the GOTO option (e.g., GOTO A0).
Having entered your formulae into Row 0, access them by referring to the cell
reference, so formulae 1 would be reference as A0.

There are 52 in total (A0 to Z0).

ZAP COMMAND
The Zap facility is designed to completely remove the contents of the current
spreadsheet (see Copy).

ATTR - CHANGE CELL/RANGE ATTRIBUTES
Each cell has the following default cell attributes (characteristics):

Option:                         Default:
LOCK/UNLOCK                     UNLOCK
JUSTIFICATION                   Text: LEFT, numeric: RIGHT
ZERO SUPPRESSION                NO
NO. OF DECIMAL PLACES   2

LOCKING - Use the facility to 'lock' a cell if you do not wish the contents be
edited or altered (this can easily be done by accident and is particularly
undesirable if cells are linked by formulae).  A cell once LOCKED can be
UNLOCKED, if necessary.

JUSTIFICATION - The contents of a cell may be justified left, right or centre.

ZERO SUPPRESSION - If a cell's formula, after calculation, results in zero,
you may wish to suppress the display of '0' and simply leave a blank space.

NUMBER OF DECIMAL PLACES - Figures may be displaced to 7 decimal places.
Although you may wish to display only a few decimal places, DGCALC will still
maintain the figure to an accuracy of 7 decimal places.

IMPORTANT NOTE:
All attributes will be saved with your spreadsheet file.

COPY - COPY CELL/RANGE
If you wish to copy a cell or range of cells (including formulae) to another
location, simply enter the source (FROM) and then the destination (TO).

If copying from a range, then having entered the source range, DGCALC will ask
for the destination.  However, usually it is not necessary to specify the
destination range as a range, you can simply type just the co-ordinate of the
top left corner of the destination range and DGCALC will then fill from this
corner.

You can use this option to delete sections, or the entire spreadsheet by
specifying a blank cell as the source.

Normally, copying is done RELATIVELY and this is the default.

To completely remove the contents of the current spreadsheet, copy cell
reference AZ511 to the range A0:AZ511 (this facility has already been
configured for function key 4, see Function Keys).  This over-rides all locked
cells and resets the attributes.  To remove the current spreadsheet and
maintain function keys, UDFs, column widths and titles, use the same procedure
but set the destination to A1:AZ511.

IMPORTANT NOTE:
The attribute of the blank cell will be copied into the new location:

Previously used blank cell:
Attributes will be set at the time of use.

Previously Unused blank cell:
Default attributes (i.e., text - left justified, numeric - right justified, 2
decimal places).

DEL - DELETE ROW/COLUMN
Use this option to delete complete rows or columns at the position of the
highlighted bar (the default is 1, although you may delete any number).

DGCALC scans the spreadsheet to check whether a cell reference has been moved
and if so, the cell is adjusted.

FILE - LOAD/SAVE/EXPORT/PRINT FILE
These options control the manipulation of the spreadsheet.  Either load, save,
export (to a file in ASCII format or to a printer) or print (to a printer).

When saving spreadsheets, DGCALC will append the following suffixes (file
extensions):

.SPR - spreadsheet file (from SAVE Option)
.TXT - ASCII (text) file (from EXPORT option)

LOAD - SPECIFY FILENAME AND LOAD IN A NEW SPREADSHEET
If a spreadsheet already exists which has been edited or altered in some way,
DGCALC will query:

UNSAVED CHANGES - Discard changes NO YES

If you select YES, the program will proceed with loading the new file in place
of the existing spreadsheet in memory.  If you select NO, DGCALC will return
to Main Menu.

If a spreadsheet already exists which has not been edited, DGCALC will proceed
with loading the new file in place of the existing spreadsheet in memory.

SAVE - SPECIFY FILENAME AND SAVE THE CURRENT SPREADSHEET
If a file of the same name already exists, DGCALC will query:

FILE EXISTS - Replace YES NO

If you select YES, the program will proceed with saving the spreadsheet in
memory in place of the existing file.  If you select NO, DGCALC will return to
the Main Menu.

EXPORT - SPECIFY FILENAME AND SAVE (PRINT) THE CURRENT SPREADSHEET IN ASCII
FORMAT.
Select to save the spreadsheet itself or just the formulae,  with/without row
numbers/column letters, the range, page lengths, page width.  The range
default is the entire spreadsheet.  Remember to specify row 0 if you wish to
include the UDF's.

If the spreadsheet's width exceeds the page width you specified previously,
DGCALC will print as many columns as possible to fit on the page and print the
remaining columns after the last row.  Column titles will automatically be
printed at the top of each new page.  2 blank lines are inserted at top and
bottom of each page.  Setting the page length/width to a large number will
prevent page breaks.

PRINT - PRINT CURRENT SPREADSHEET TO THE PRINTER
Use this option to print the actual spreadsheet or just the formulae direct to
the printer.

The options are the same as EXPORT.  In addition, you may specify printer
initialisation codes to configure your printer.  This takes the form of
numbers, separated by commas.

For example, (for an Epson compatible printer) 27,69 will give bold print.
Refer to your printer manual for the appropriate codes.

GOTO - GOTO A CELL
Enter cell reference and the program will jump to the specified cell.  Mouse
users may 'click' on the appropriate cell.

HOLD - HOLD/RELEASE CURRENT ROW/COLUMN
Use this option to switch between holding and releasing the current row or
column on the screen.  If, for example you hold row 1, and scrolled downwards,
although row 2, 3, etc., would scroll off the top of the screen, row 1 will
remain.  The same principle applies for columns.  You may hold up to 3 rows
and 3 columns simultaneously.  However, the total width of the columns may
exceed 36 characters.

To release a row or column, move the highlighted bar to the row/column and
select the HOLD option again.

IMPORTANT NOTE:
When you select to HOLD a row/column, DGCALC will place a copy of the
row/column in the top/left side of the spreadsheet.  The complete spreadsheet
will them scroll underneath.

INS - INSERT ROW/COLUMN
Use this option to insert a row or column (the default is 1, although you may
insert any number).  You may specify whether you wish to insert the
row/column(s) before or after the current position.

DGCALC scans the spreadsheet to check whether a cell reference has been moved
and if so, the cell is adjusted.

In most cases, you will be inserting before the current cursor position, and
this is the default.

However, in some cases it is beneficial to insert after the current cursor
position so that DGCALC changes any totals correctly.  For example, suppose we
consider the following spreadsheet:

A1:  10.00
A2:  15.00
A3:  12.00
A4:  SUM (A1:A3)

If we wanted to insert a row between A3 and A4 AND update the formula to
include the new row (i.e., SUM (A1:A4), you should insert the row AFTER A3.
The result of inserting a row AFTER A3 would be:

A1:     10.00
A2:     15.00
A3:     12.00
A4:
A5:     SUM (A1:A4)

If you inserted a row BEFORE A4, the blank row would be inserted, but the
formula would still remain SUM (A1:A3).

MISC - (DIRECTION/FUNCTION KEYS/PASSWORD)
This is divided into 3 separate options:

DIRECTION - CURSOR DIRECTION
This option determines the direction in which the highlighted bar moves on the
spreadsheet after completing a cell entry.  For example, if you were entering
a list of vertical titles in a column, you would require the DOWN cursor
direction, so that after each entry the highlighted bar moved downwards to the
next row.  The program is setup to move to the right.

FUNCTION KEYS - EDIT FUNCTION KEYS
You may program up to 9 function keys with text, numbers, formula or menu
options.  This saves repetitive entry of data.  The ability to program menu
options is particularly useful.  For example, you could program F1 with the
GOTO option and cell reference.  Whenever you pressed F1, the highlighted bar
would jump straight to the specified position on the spreadsheet.

The function key menu shows each function numbered 1 to 9.  Use the cursor
keys to move from left to right.  As each number is highlighted, the content
of the function key will be displayed underneath.

Position the cursor over a function key and press RETURN.  You may now enter
your information (up to 36 characters).  Press RETURN when your entry is
complete.  The value in each function key may be edited at any time and is
automatically saved with your spreadsheet.

THE FOLLOWING FUNCTION KEYS HAVE ALREADY BEEN CONFIGURED:

Key
No.     Contents                Action
F1      /GA1                    Go to cell A1
F2      /ODIR                   List files in current directory
F3      /FP6                    Print current spreadsheet with all defaults
F4      /CAZ511A0:AZ511         Zap entire spreadsheet

How to program the function keys with text/numbers/formulae:

Simply type your information, but remember to precede any text with ''.(If you
wish to instruct the computer to issue RETURN after the information see the
next section.)

How to program the function keys with menu option/commands:

Simply enter / and then the first letter of a Main Menu option.  For example,
if wanted to use GOTO, simply enter /G.

If you wish to enter a command, precede all references by @:

Command Action
e               RETURN (or ENTER)
u               cursor up 1 character
d               cursor down 1 character
l               cursor left 1 character
r               cursor right 1 character
U               page up
D               page down
L               page left
R               page right
?               delete 1 character left
w               delete (wipe) from cursor position to end of line

PASSWORD - CREATE/CHANGE PASSWORD
Each of your spreadsheet files may be given a unique (or identical) password
to prevent unauthorized access through DGCALC.  You may change the password at
any time.

IMPORTANT NOTE:
Digita International cannot be help responsible to retrieve any information
protected by a password.  DO NOT FORGET YOUR PASSWORD.

If you are creating a password for the first time, you will be asked to enter
the new password (up to 8 characters).  Now save your spreadsheet file.  In
future, DGCALC will prompt for a password before loading the file.

IMPORTANT NOTE:
The password routine is the only part of DGCALC, which discriminates between
upper and lower case letters.  If, for example, you entered 'Paul' as your
password, DGCALC will not accept 'paul' or 'PAUL'.

To change this password, select the same option as previously.  However, this
time DGCALC will ask for the existing password before prompting you to enter
the new version.  If you wish to remove the password altogether simply press
RETURN when prompted for the new password.

OS - ENTER THE OPERATING SYSTEM COMMAND
Select this option to make direct operating system commands.  This is
particularly useful for screening a directory listing, printer commands, etc.

TITLE - CHANGE COLUMN TITLES
This option may be used to change the current column titles at the top of the
screen.  Position the highlighted bar in the appropriate column before
selecting this option.  The titles appear on the screen with the column letter
followed by the title (e.g., B:PRICE).

When printing your spreadsheet, the titles will be printed at the top of each
new page.

UNDO - UNDO LAST EDIT OF CELL
If you have accidentally edited a cell, use the undo option to reverse the
process.

WIDTH - CHANGE COLUMN WIDTH
The display width of each column is individually adjustable.  You will be
prompted for the range, which may be a single column (the default is the
current column) or a range of columns.  Enter the required width (the default
is the current width) and press RETURN.

QUIT - QUIT DGCALC
Use this option to leave DGCALC.  If you have not saved any new or amended
data, DGCALC will query whether you still wish to leave the program:

UNSAVED CHANGES - Sure you want to quit: NO YES

If you select NO, the program will return to the Main Menu.

If, however, you have saved your data or, if you have loaded a spreadsheet and
not performed any editing, etc., DGCALC will simply query:

Sure you want to quit: YES NO

If you select NO, the program will return to the Main Menu.

TROUBLE SHOOTING

ERROR MESSAGE           REASON
Bad cell                Reference incorrect cell reference, or cell does not
                        exist.

Bad cell range          Incorrect range, or range not valid (e.g., A10:A9)

Cell is locked          Attempt edit on locked cell

Bad cell content        Information entered in wrong format (e.g., entering
                        text not preceded with ''or', mismatched bracket)

Max rows/cols already   Attempt to exceed maximum hold of 3 rows and 3
held                    columns, or total column width exceeds 36 characters.

Bad Number              Number unrecognised, or number too big or too small.
                        Also, attempt to delete/insert too many rows/columns.

Locked cell exists      Attempt to delete or copy over locked cell(s)

Password incorrect      Incorrect password entered, check for upper and lower
                        case letters.

Out of room             Your spreadsheet has filled your computer's memory.

CALCULATION ERRORS:
Recursion too deep      Exceeded the maximum of 9 references between
                        formulae, or incorrect reference (e.g., referring to
                        cell A1 from cell A1)

DIV0 (in actual cell)   Number divided by zero

Mathematical function   Error in maths function (e.g., square root of -1)
error

Number too big          Number, possibly as a result of a calculation,
                        exceeds system maximum (999,999,999).

For other 'system' errors, please refer to your computer manual.

APPENDICES
APPENDIX 1 - COPYING/FORMATTING
Follow the instructions detailed in the Amiga manual for copying/formatting
disks.

APPENDIX 2 - LOADING
Load the Workbench and insert your DGCALC program disk into the drive.  Double
click on the floppy drive icon and then double click on the DGCALC icon.  The
program will then load.

APPENDIX 3 - READ.ME FILE
If this file exists (i.e., there are manual amendments), double click on the
READ.ME icon

APPENDIX 4 - MACHINE VARIATIONS

COLOUR MONITOR/TV USERS
DGCALC will work with all Amiga compatible monitors/TVs.

SINGLE DISK DRIVE USERS
Having loaded DGCALC, replace the program disk with a formatted blank disc.
This is for your data.  It is important to specify the drive name (i.e., DF0:)
within the filename when loading and saving (e.g., df0:myfile).

DOUBLE DISK DRIVE USERS
Follow the single drive procedure.  Alternatively, put the blank disk in the
second drive and, when loading/saving files, be sure to enter the following
before the filename:

df1:

this will instruct the computer to load/save all data to the second drive.

KEYBOARD VARIATIONS

Backspace           deletes left
CTRL X or Del       deletes right
CTRL I, or Tab      inserts a space

Please note: The editor cursor is presented by a steady block.

OPERATING SYSTEM COMMANDS (OS OPTION)
To invoke a new CLI, type:

newcli

To terminate this, type:

endcli

You will find that, when issuing an OS command, your current directory is
df0:.  If, for example, you required a directory of df1:, enter df1: as your
OS command.

DGCALC is a memory based program.  Therefore, more memory will be available
for storing labels if the Workbench Accessories are not present.

End.