320K Version of AnalytiCalc (Document Supplement) The 320K version of AnalytiCalc differs from the normal 256K version in two ways: it is not overlaid, and it supports logical names. The 256K version uses overlays from disk to save memory, and consequently a spreadsheet that uses many special functions that are in different overlays (e.g., large amounts of matrix math plus large amounts of date conversions) will be slowed. The 320K version is non overlain and there is no penalty for any function mix. The 320K version also has a symbol table and allows you to define symbolic names of up to 16 characters length, containing letters or numbers, and use them inside equations. To define a symbolic name, use the command TE {SYMBOLICNAME=Vn where Vn is a cell name (like A5, R17, AB122, or the like), and "SYMBOLICNAME" is the name you wish to define. The name is now associated with the CONTENTS OF the cell named (as Vn). When you use the construct {SYMBOLICNAME in an equation, the contents of the cell associated with that name replace the name prior to evaluation. Any contents may be used, though the total resulting string must not grow to over 109 characters. Recursive substitutions are permitted to a depth of 20, so name definitions may use other name definitions. To remove a name definition, use the command TE {SYMBOLICNAME=0 You should remove definitions explicitly since they are not automatically removed by adding new definitions. Up to 301 names may be defined in the sheet. Note that scratch cells A0 through approximately BK0 may be used to hold definitions if desired. To store cell definitions for later use, the special command must be used as follows to save them: TE {*= This will cause AnalytiCalc to ask for an Output file. You reply with a filename to store (or show) the definitions. The program will then dump all known symbol definitions in the same format needed to do the definitions of the names. If a disk file is specified, it can be read in via the @file command so the symbols may be redefined to a later AnalytiCalc run. Storing definitions on CON: can give a quick look at them interactively, but usually it is better to print the definitions (which can be done by giving LPT1: (or your printer's real name if that's not it) as the output file name. This facility can save considerable formula typing time. Where you have a very large formula to be duplicated many times, if it can be specified relocatably, a reference to a short name (or a cell, since {name and {cell function the same) can save storage and allow you to get by with smaller disk work files. The 256K AnalytiCalc has the {cell logic to do substitutions, but the names must be cell names. Only the larger one has room for the name dictionary. EXAMPLE RUN: L D0 ; go to phantom cell D0 ET SUM[A1:A4] ; fill in a macro definition as text TE {SALES=D0 ; define "sales" as this sum M2 ; set automatic motion down L A1 ; go to A1 E 2.3 ; enter some junk data just to show this E 4.86 E 1.2647 E 8.3454 EV {SALES ; Enter sales value as a numeric. ; the cell will display the sum of A1 thru A4. An example position independent formula might be: SUM[ P#0#-5:P#0#-1] which means the sum of the cells from 5 above the current physical cell to 1 above the physical cell. This form if used in a name will work wherever it is used, regardless of location.