This site is hosted by the good folks at SourceForge. Visit their site at
Development Status: 5 - Production/Stable
Environment: Console (Text Based), Other Environment
Intended Audience: Developers, End Users/Desktop, Other Audience
License: GNU General Public License (GPL)
Natural Language: English
Operating System: MS-DOS, Windows 95/98/2000, Windows NT/2000
Programming Language: C, C++
Topic: Office/Business, Other/Nonlisted Topic, Software Development
The TCalc parser.
The state and goto information for the parser was created using the 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 ')'
;
%%
TCalc Information.
Formulas are entered as text. TCalc 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 TurboCalc 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))
Function List :- [with examples]
Func name
ln example: { This is Natural Log i.e. base 'e'.} log (2) = 0.69
log example: { This is Log base 10.} log10 (2) = .30
sin example: sin (1.5708) = 1.00 { ie. sin 90° = 1 }
cos example: cos (0) = 1
asin example: asin (1) = 1.57
acos example: acos(1) = 0.00
atan example: atan (1) = 0.79
cosh example: cosh (0) =1
sinh example: sinh (1) = 1.18
tanh example: tanh (1) = 0.76
exponent example: exp( 2) = 7.39
absolute example: round (99.99) = 100.00 , round (99.01) = 99.00
power 10 example: pow10 (2) = 100
sq-root example: sqrt (9) = 3
squares example: sqr (2) = 4
truncate example: trunc (10.455588) = 10.00
NOTE: All values for the trignometric functions are in radians ie. radians = (angle in degrees * PI) / 180 and values of the functions to be entered inside the paranthesis ' ( ) '
BACK