DataMuseum.dk

top - download

    Length: 4608 (0x1200)
    Types: TextFile
    Names: »CALC.HLP«

└─⟦98ebcd56b⟧ Bits:30004773 Turbo Pascal v.2.00B for CP/M-86
    └─ ⟦this⟧ »CALC.HLP« 

TextFile

                    ▶02◀INTRODUCTION▶02◀

MicroCalc is a tiny spread sheet program a la  VisiCalc. It  is
provided with the TURBO-Pascal system as an example program.

Since MicroCalc is only a demonstation program it has its limita-
tions (which you may have fun eliminating):

  * You cannot copy formulas from one cell to others.
  * You cannot insert and delete lines or columns.

▶02◀In spite of its limitations MicroCalc does provide some interest-
ing features among which are:▶02◀

  *  11 digits floating point reals (Thanks to TURBO Pascal!)
  *  Full set of mathematical functions (SIN,COS,LN,EXP etc.)
  *  Built in line editor for text and formula editing.
  *  Text  can  be  entered across cells.
  *  Once entered a formula is protected from accidental erasure.
.PA


In addition to this MicroCalc offers all the usual features of  a
spread sheet program:


  *  Load a spread sheet from the disk.
  *  Save a spread sheet on the disk.
  *  Automatic recalculation after each entry. (May be disabled).
  *  Print the spread sheet on the printer.
  *  Clear the current spread sheet.

The spread sheet is an electronic piece of paper on which you can
enter  text,  numbers and formulas and have MicroCalc do calcula-
tions automatically.

The next page shows the electronic spread sheet.
.PA
----------------------------------------------------------------
       A          B         C         D  ....
 1   22.00
 2    1.00
 3    2.00
 4    3.00
 5   28.00
 .
 .
A 5  Formula:
(A1+A2+A3+A4+A5)
-----------------------------------------------------------------

In  the example the next last line shows that the active cell  is
cell  A5  and that A5 contains  a  formula:  (A1+A2+A3+A4)  which
means  that  the numbers in A1,A2,A3 and A4 should be  added  and
placed in A5.

The formula can be abbreviated to: (A1>A4) meaning: add all cells
from A1 to A4.
.PA

You move the cursor around just like you do in the TURBO editor:

                             (Up)
                            Ctrl-E
                (Left) Ctrl-S     Ctrl-G (Right)
                            Ctrl-X
                            (Down)

A cell may contain a number, a formula or some text. The type of of the cell
and its coordinates are shown in the bottom left corner of the screen:

▶02◀A 5   Formula:▶02◀         (Means that the current cell is A5 and that it
                       contains a formula)

▶02◀A 1   Text▶02◀             (Cell A1 contains text)

▶02◀A 2   Numeric▶02◀          (Cell A2 contains a number and no cell references)

.PA
                     ▶02◀Summary of MicroCalc▶02◀
     Cells are denoted A1 through G21 giving a total of 147 cells.

▶02◀Summary of standard functions and operators:▶02◀
SIN, COS, ARCT, ABS, FACT, EXP, LN, +,-,/,*
Futhermore the operator '>' can be used to denote a range of cells to add.

▶02◀Entering data▶02◀
To enter data in any field move the cursor to the cell and enter the
data. MicroCalc automatically determines if the field is numeric or a
a text field.


▶02◀When moving between fields:▶02◀
^S,^D,^E,^X move left right up and down.

▶02◀When editing a field▶02◀
▶02◀^S,^D▶02◀ moves left and right. ▶02◀^A,^F▶02◀ moves to beginning/end of line.
▶02◀DEL,^G▶02◀  deletes left or right character.
▶02◀ESC▶02◀ makes it possible to regret changes and to edit an existing cell.
.PA


                     ▶02◀Summary of commands▶02◀


    ▶02◀/▶02◀   will restore the screen
    ▶02◀Q▶02◀   will ▶02◀Q▶02◀uit MicroCalc
    ▶02◀L▶02◀   will ▶02◀L▶02◀oad a spread sheet from the disk.
    ▶02◀S▶02◀   will ▶02◀S▶02◀ave a spread sheet on the disk.
    ▶02◀R▶02◀   will ▶02◀R▶02◀ecalculate
    ▶02◀P▶02◀   will ▶02◀P▶02◀rint the spread sheet.
    ▶02◀F▶02◀   makes it possible to change the output format for numbers.
    ▶02◀A▶02◀   switches ▶02◀A▶02◀utocalc ON and OFF

Note: to use scientific notation use the the F command and enter minus one
      ▶02◀-1▶02◀ for the number of decimals.

.PA

                              ▶02◀EXAMPLES▶02◀

The following are examples of valid cell formulas:

A1+(B2-C7)  subtract cell C7 from B2 and add the result to cell A1
(A1>A23)    the sum of cells:  A1,A2,A3..A23
(A1>B5)     the sum of cells:  A1..A5 and B1..B5

▶02◀The formulas may be as complicated as you want: ▶02◀

SIN(A1)*COS(A2)/((1.2*A8)+LN(FACT(A8)+8.9E-3))+(C1>C5)

To edit an existing formula or text simply move to the cell and
press ▶02◀ESC▶02◀, make your changes and press <RETURN>. If you make
a mistake you may press ▶02◀ESC▶02◀ again, the old value of the cell will
then be restored.

To try MicroCalc now you may use the ▶02◀/L▶02◀ command and load the file:
▶02◀CALCDEMO▶02◀.


«eof»