AnalytiCalc Reference Manual Page 95 Appendix E NEW FEATURES The following features were added to AnalytiCalc after the last edit to the manual: 1. Extended cell addressing. This feature allows you to treat the spreadsheet as though it contained 18000 rows and 18000 columns. You can use any storage in any part of this range. Thus, columns from A through ZPH are legal, and rows from 1 to 18000 are legal. The actual storage in virtual memory is still treated as a prime area of 60 by 300 cells, but extended areas move down the sheet as you go further to the right of the 60 columns, and right on the sheet as you go further down. The increments on overflow start at 50 rows and 10 columns, but can be reset by questions in the "modify widths and mapping" section of the S (setup) command. The mappings chosen are saved and restored in PP and GP commands. This allows you to use the storage as a giant area, though it can run out. (No possible one-CPU machine could really compute a 325 million cell sheet, if all cells were full, quickly enough to be use- ful.) Because it can be confusing to figure out what is going on, the Add (AR and AA) commands that insert or delete whole rows or columns do not work in extended addresses (i.e., beyond 60 columns and 300 rows). When using extended addressing, and after you have cells set up in the extended area, you should NOT alter the mappings via the S command, nor should you use the AA or AR commands. All other com- mands work normally. 3. The sheet save and restore now saves values in a PPX command as well as formulas. It also saves column widths and the number of rows and columns being displayed. If you specify a 4th character M in the command (e.g., PPXM instead of just PPX), AnalytiCalc will save the display-to-physical mapping in its saved sheet as well as the other sheet information. This considerably extends the saved size, so it is optional. Setting up your mapping while journaling is turned on, and then playing back a journal file, will still use sub- stantially less disk space, though having all the information in a saved sheet makes reload simpler. The PP commands have now the following effects: PPN Save numerical values (and labels) only. Formulas are NOT stored; only numeric values are. PPX Save both numeric values and formulas. The output files contain two records per cell used, one containing the value and the other containing the formula. On reload, AnalytiCalc Reference Manual Page 96 the value record sets the cell value, and the formula record sets the formula (which may cause the value to change once a recalculation is done). The value record is first and it's first character is "p" (lower case) while the formula record's first character is "P" (upper case). See the BASIC graphics programs for how to read the format, or type a saved sheet out to see how it looks. Use this form of save for most purposes. PPF Saves formulas only, not values (though a single recal- culation generally produces values). Use this for tem- plates where the data values are not meaningful or to save room. This sort of save cannot however be used for graphics, and the *XV command will not find useful values everywhere in such a saved sheet. PDN Saves Display sheet numerically only. Like PPN except that the offsets used are in Display coordinates, not relative to the physical sheet. PDF Saves Display sheet, Formulas only. No display sheet save of "both" numbers and formulas is implemented since the display sheet is smaller than the physical one and two saves can be easily done when both are needed. PxxM Where "xx" can be PN, PF, DN, DF, or PX - Saves Mapping as well as the sheet. This saves extra records (with row and column numbers offset by 64000 to keep them from confusing graphics programs) that allow Get (GP or GD or GPR) commands to set up the display to physical sheet mappings automatically. Thus, you can save all your windows and have them back automatically on reload. The mapping is saved from the current cursor location down and right only. The G (Get) class commands are unchanged except that they now reset all the new saved quantities when they are seen. Old saved sheets receive default values for the column widths, numbers of rows/columns, mapping, etc. so their behavior is not altered. V18-04 has the following new features: 1. If you have an ACINIT.PRM file, it will be kept open as an initializer file until EOF and may contain any AnalytiCalc commands. HOWEVER, if you use the file, it MUST contain at least the replies to all questions until you arrive at the spreadsheet's "calculation screen". It can be used to preset cell contents or perform other setups. Note that the ZA command allows you to reset storage parame- ters and the like, so having them preset by a startup file in this way does not reduce the generality of the program. It is often a good policy to do this to get the program started, as the setup com- mand can contain typed strings to initialize ANSI.SYS or to set up internal function key meanings without having to rely on an operator AnalytiCalc Reference Manual Page 97 or an external batch file to do so. The command %escape sequence to type%*%*% will just type the escape sequence; it may be used in ACINIT.PRM (after the part that answers initial ques- tions) to type any desired escape sequences for setting up the screen or whatever if that screen control method is chosen. L AO0 ET 1 L AW0 ET 2 L AR0 ET 3 L AT0 ET 4 L A1 Note that AB0 corresponds to code 59, and so on. AO0 corresponds to 72, AW0 to 80, AR0 to 75, and AT0 to 77 here. The 1,2,3,or 4 that are entered are the cursor move commands in command mode, entered as text so they cause no calculation overhead. Note that IF YOU HAVE AN ACINIT.PRM, IT will be read, NOT your console, for initial questions. (You can get the initial queries back with the ZA command however.) New Features of V18-07B AnalytiCalc V18-07B supports use for project management. To make this run efficiently, the selection functions were modified to record which cell was selected. Thus, the MAX, MIN, LKP, LKN, and LKE functions now return the column and row (respectively) of the cell they find in accumulators P and Q respectively. The function "*P@ P0,Q0" may be used to directly access this cell in subsequent calculations, or the P and Q accumulators can be used in other forms of addressing to access the selected cells. The functions otherwise behave as they did in earlier releases. The project management software (AnalytiProject) will be distributed only to registered (i.e., paying) users of AnalytiCalc. New Features - V18-07C AnalytiCalc V18-07C adds two functions to support computations in "workdays". *U WKDYS V1,V2 takes Julian dates in variables V1 and V2 and computes the number of workdays between the two, not counting the initial date if it is a workday (to be similar to differences between Julian dates). AnalytiCalc Reference Manual Page 98 *U WKDIN V1,V2 takes a Julian date in V1 and a number of days in V2 and returns the Julian date that is V2 workdays after the date in V1. It is thus a sort of inverse for the *U WKDYS function. The resulting date is guaranteed to be in the Monday to Friday range. A workday is Monday to Friday. The functions know nothing of holidays. New Features - V18-08A In V18-08A, AnalytiCalc can compute line fits and Fast Fourier transforms on data. *U LINEF Y1:Y2,X1:X2 computes a line whose equation is Y=mX+B, where m is returned in the U accumulator and B is returned in the T accumulator. The % accumu- lator returns the fitting error in Y. The line is fit over the range Y1:Y2 in Y, with the X coordinates optional and if they are present, they must be in the cells in the X1:X2 range given. If the X range is omitted, 1. to the max. number of points will be used. *U FFTFW V1:V2 computes the forward (t to freq) Fourier transform of the range and *U FFTRV V1:V2 computes the reverse (freq. to t) transform. The range must be a power of two long (if less, the largest power of 2 available is used and extra points are ignored). Data is assumed to be the real coef- ficients in the first half and the imaginary ones in the second half. FFT data is returned in this layout also. Thus, the real data (which is frequently the part of interest) is returned first. The reverse FFT of the forward FFT returns the original data. The FFT is of in- terest for finding the frequency distribution of partially sinusoidal distributions. New Features - V19.01A A modified command structure is supported now. If you type the command /; then the commands to AnalytiCalc are modified as follows: 1. Any command beginning with a digit (except single digits standing alone) is treated as an EV followed by the text. 2. Any command beginning with / has the / stripped off and the rest is treated as a command. AnalytiCalc Reference Manual Page 99 3. Any command beginning with " is treated as an E" command (enter text) with the " stripped out. 4. Anything not starting with a digit, a " character, or a / is treated as an Enter command and is prefixed with "EN " and used. The old (default) command mode is restored with the command "//" so that /; and // switch between the two. These commands may be given in ACINIT.PRM, other command files, or from the console. They introduce incompatibilities in that in the new version commands like "DF range [format]" must be entered as "/DF range [format]" (for ex- ample) to work. To facilitate writing command files that work in both modes the command / switches the mode with a save cell. A sequence of commands: /# (save current command mode in save cell) // (enter old command mode) ... (do all of command file) /# (restore saved user command mode) will allow a command file to operate and be written to run predict- ably in either user environment choice. Please NOTE that special characters in the first character are interpreted as commands in /; mode. The * character is handled as a comment. To enter formulas with functions starting with *, use the COMMAND form, e.g. /EV *U IDATE. This always works and disambigu- ates syntax. When the system is in /; mode, the cell prompt at the 23rd line of the screen ends with : so that it appears like AB 21: When the system is in // mode (initial default) the prompt ends with the > character so it appears like AB 21> This should aid in distinguishing modes during use. New Features of V19.2 In V19.2, AnalytiCalc adds the OAD and ORD commands. These are like the OA and OR commands except they leave the relative mappings of the screen alone. Thus, if you already split your screen into 3 AnalytiCalc Reference Manual Page 100 parts and use the command "OAD cell" to reset the mapping, the resul- tant screen still has 3 regions at the same relative positions as be- fore. If you use the ORD command, then only the part of the screen right and down from the cursor is affected, but any screen partition- ing is maintained. If these commands leave some areas pointing to nonexistent areas, use a command OR or OA to reset the areas desired to something real again. V19.2 added the change from > to : at the end of the prompt depending on // or /; modes also. New Features - V19-03A The recalculation has added 2 new modes in V19-03, Recalculate Incremental (the initial default), and Recalculate Entry. The R command re-establishes the old default mode which recalcu- lates ALL formulas on the whole sheet for every entry of new material. The RI command sets Recalc Incremental mode which recomputes all cells on the display screen, but skips non-displayed cells. The RE command sets Recalc Entry mode which ONLY recomputes the newly entered formula, leaving the rest alone. (It is reliable in the "prime" region of the sheet but may fail in extended address areas.) The RR command is equivalent to RF (Recalculate, FORCE recompu- tation of constants), EXCEPT that it leaves the mode alone so if AnalytiCalc is in RI or RE mode, it stays that way. Note a full recalculation is done after Get commands (loading saved sheets) regardless of mode. The command .. (two periods at the start of a line) in a com- mand file closes the command file and returns to the console. This has not previously been documented though the function has been present for some time. It is recommended that RE or RI mode be used instead of RM mode (which completely disables recalculation) during data entry if other modes are too slow. AnalytiCalc may be obtained from Glenn Everhart, 25 Sleigh Ride Rd., Glen Mills, PA 19342, for $25.00 (I'll supply the disk for that; I ask only $10. to register it however.)