TinyCalc/CALC.HLP at main · hindermath/TinyCalc · GitHub

1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
32
33
34
35
36
37
38
39
40
41
42
43
44
45
46
47
48
49
50
51
52
53
54
55
56
57
58
59
60
61
62
63
64
65
66
67
68
69
70
71
72
73
74
75
76
77
78
79
80
81
82
83
84
85
86
87
88
89
90
91
92
93
94
95
96
97
98
99
100
101
102
103
104
105
106
107
108
109
110
111
112
113
114
115
116
117
118
119
120
121
122
123
124
125
126
127
128
129
130
131
132
133
134
135
136
137
138
139
140
141
142
143
144
145
146
147
148
149
150
                    INTRODUCTION                       Page 1

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 can not copy formulas from one cell to others.
  * You can not insert and delete lines or columns.

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

  *  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
                                                         Page 2

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
                                                         Page 3
----------------------------------------------------------------
       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)
-----------------------------------------------------------------

In  this example the next to 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 cells A1,A2,A3 and A4 should be
added  and the result placed in cell A5.

The formula can be abbreviated to: (A1>A4) meaning: add all cells
from A1 to A4.
.PA
                                                         Page 4
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)

        ---> On the IBM-PC you may also use the arrows. <---

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

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

A 1   Text             (Cell A1 contains text)

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

.PA
                                                         Page 5
                     Summary of MicroCalc
     Cells are denoted A1 through G21 giving a total of 147 cells.

Summary of standard functions and operators:
ABS, SQRT, SQR, SIN, COS, ARCTAN, LN, LOG, EXP, FACT
+,-,*,/, ^ to raise to any power e.g. 2^3 = 8
Futhermore the operator '>' can be used to denote a range of cells to add.

Entering data
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.

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

When editing a field
ESC selects and deselects a cell for editing and can also be used to
      disregard changes.
^S,^D moves left and right. ^A,^F moves to beginning/end of line.
DEL,^G  deletes left or right character.
^V (or Ins on the PC) changes between insert-/overwrite mode.
.PA
                                                         Page 6

                     Summary of commands


    /   will restore the screen
    Q   will Quit MicroCalc
    L   will Load a spread sheet from the disk.
    S   will Save a spread sheet on the disk.
    R   will Recalculate
    P   will Print the spread sheet.
    F   makes it possible to change the output format for numbers.
    A   switches Autocalc ON and OFF

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

.PA
                                                         Page 7
                              EXAMPLES

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

The formulas may be as complicated as you want:

(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 ESC, make your changes and press <RETURN>. If you make
a mistake you may press ESC again, the old value of the cell will
then be restored.

   --> To try MicroCalc now, use the /L command to <--
   --> load the file: CALCDEMO.  Notice that       <--
   --> CALCDEMO was created using TURBO.COM, so      <--
   --> the format of the real numbers are not the    <--
   --> same as if you are using TURBO-87.COM.        <--