102 lines
2.1 KiB
Plaintext
102 lines
2.1 KiB
Plaintext
How to compile MicroCalc
|
||
ÄÄÄÄÄÄÄÄÄÄÄÄÄÄÄÄÄÄÄÄÄÄÄÄ
|
||
|
||
With TC.EXE:
|
||
|
||
1. Run TC.EXE
|
||
2. In the Project pulldown menu specify the project name "MCALC.PRJ"
|
||
3. From the main menu select the Run option from the Run menu
|
||
|
||
With TCC.EXE:
|
||
|
||
Compile from DOS with the following command line:
|
||
TCC mcalc mcparser mcdisply mcinput mcommand mcutil
|
||
|
||
In both cases, compiling under a large data model (COMPACT, LARGE, or HUGE)
|
||
will give you much more memory for your spreadsheets.
|
||
|
||
The compiler may run out of file handles when compiling MicroCalc.
|
||
To allow the compiler to open as many files as possible, put the
|
||
statement "FILES = 20" in the file CONFIG.SYS in the root directory
|
||
of the disk that you start your computer with.
|
||
|
||
The MicroCalc parser
|
||
ÄÄÄÄÄÄÄÄÄÄÄÄÄÄÄÄÄÄÄÄ
|
||
|
||
The state and goto information for the parser was created using the UNIX YACC
|
||
utility. The input to YACC was as follows:
|
||
|
||
%token CONST CELL FUNC
|
||
%%
|
||
e : e '+' t
|
||
| e '-' t
|
||
| t
|
||
;
|
||
t : t '*' f
|
||
| t '/' f
|
||
| f
|
||
;
|
||
f : x '^' f
|
||
| x
|
||
;
|
||
x : '-' u
|
||
| u
|
||
;
|
||
u : CELL ':' CELL
|
||
| o
|
||
;
|
||
o : CELL
|
||
| '(' e ')'
|
||
| CONST
|
||
| FUNC '(' e ')'
|
||
;
|
||
%%
|
||
|
||
Additional MicroCalc information
|
||
ÄÄÄÄÄÄÄÄÄÄÄÄÄÄÄÄÄÄÄÄÄÄÄÄÄÄÄÄÄÄÄÄ
|
||
|
||
Formulas are entered as text. MicroCalc will determine if what you entered
|
||
is a legal formula or text.
|
||
|
||
Cell names in formulas are typed in with the column followed by the row.
|
||
|
||
Examples:
|
||
|
||
A1+A2
|
||
B6^5
|
||
|
||
To sum a group of cells, put a colon between the first cell and the last
|
||
cell in the group.
|
||
|
||
Example:
|
||
|
||
A1:A10 sums all of the cells from A1 to A10 and puts the result in the
|
||
current cell.
|
||
|
||
The available MicroCalc functions are:
|
||
|
||
ABS - absolute value
|
||
ACOS - arc cosine
|
||
ASIN - arc sine
|
||
ATAN - arc tangent
|
||
COS - cosine
|
||
COSH - hyperbolic cosine
|
||
EXP - exponential function
|
||
LOG - logarithm
|
||
LOG10 - base 10 logarithm
|
||
POW10 - raise argument to the 10th power
|
||
ROUND - round to the nearest whole number
|
||
SIN - sine
|
||
SINH - hyperbolic sine
|
||
SQR - square
|
||
SQRT - square root
|
||
TAN - tangent
|
||
TANH - hyperbolic tangent
|
||
TRUNC - return the whole part of a number
|
||
|
||
Examples:
|
||
|
||
TRUNC(A1)
|
||
SQRT(SQR(34.5))
|
||
ABS(TRUNC(B16))
|
||
|