A N A L Y T I C A L C A Full-Featured System for Numerical Analysis and Reporting Overview: The AnalytiCalc system from General Cybernetic Engineering includes a full featured spreadsheet, graphics programs, documents, and facilities for performing many commonly needed functions. Database data extraction and word processing integration are built in. A scheduling program is also furnished for calendar, meeting scheduling, and similar functions. Features include: * 18000 by 18000 cell spreadsheet size using virtual memory so that the ENTIRE sheet can be used. Total storage can be as much as 6 times greater than possible using popular programs such as 1-2-3 on a memory-loaded PC. Over 2 megabytes of virtual storage is available and no penalty for using cells other than in the upper left corner of the address space exists. Legal cells range from A1 to ZPH18000. * Full random access to other saved spreadsheet formulas or values from any cells. As many other sheets can be linked as needed. * Easy save or merge of partial sheets with the most flexible cell addressing in the industry. * As many windows on screen as you like. Up to 400 can be handled on screen, and more on printouts. You're not limited to 2, 4, or 8 regions as you are in some programs. * Ability to drive any cell from external macros, or to drive the entire sheet from other external macros. Internal macros (for speed) are also available. Easy console readin during macros is provided. * Functions provided for extracting data by keys from data files on the system, or for reading in normal ASCII files and automatically breaking them up for easy calculation. * Automatic "audit" display available to allow you to see exactly how the formulas on your spreadsheet are related. Can be printed out in this format also. * Built in matrix algebra, random number generation, date arithmetic and conversions between all necessary date formats. DIF access provided also. * Ability built in to vary up to 8 parameters automatically to solve systems of equations. Used with cell programs and/or matrix algebra routines, this gives mathematical power unparalleled in machines of the PC class. * Full selection of scientific, engineering, logical, business, and arithmetic functions. Up to 109 characters of formula per cell, which may contain MULTIPLE EQUATIONS. (One AnalytiCalc cell can frequently do the work of several cells in other programs.) * Table addressing functions and lookup functions useful for multi dimensional access around the sheet. * Conditionals, display sorting, access to formulas (rather than values) for sorts, dynamic modifications of formulas where desired. * Recursive macro substitution capability for simple re-use of complex parts of formulas. * 60 scratch accumulators global to the sheet. * Graph outputs and Word Processing documents may be overlayed onto sheet, included within it, or even nested as frames under control of the AnalytiCalc program. One and two dimensional plots and piechart programs are provided. * Mechanism for executing any DOS commands from within AnalytiCalc without losing context. May be driven by macros (command files) anywhere they are legal. * Large help system permitting online discovery of most command formats. Full manual available online with search utility to facilitate locating critical information quickly. F1 used as help key (as is common in many DOS programs). User may expand command set using supplied files. * Built in interactive scientific calculator. * Fast formula and subformula search commands simplify moving around large sheets. Requirements: Current version runs on interlaced screen and may need more than 512K bytes. Requirements definitely are below 1 meg however. Sources may of course be recompiled (using Absoft Fortran 2.2d or later) to relax restrictions. Subroutines in AnalyO.Ftn can be overlayed against each other. When using virtual memory files, FACC is a MAJOR speedup. Note on V22-03A: (10/31/1987 version): AnalytiCalc will read raw: keystrokes and parse them so that the arrow keys and the HELP key have the expected behavior. The function keys are however supported in the following manner if the optional custom keymap is not used: F1 becomes @DK:AKA.CMD F2 becomes @DK:AKB.CMD ... F10 becomes @DK:AKJ.CMD To use these, you must assign some area (suggest ram:) as DK: and have the AKc.CMD files copied into it. These files can contain any AnalytiCalc commands desired. The supplied files in the .EXE archive use the F1.CMD, F2.CMD ... naming convention; just rename those that are supplied. If you have either the full or the demo versions of SETKEY you can examine the custom keymap and find out what commands to use for the other keys. A separate support files archive will be distributed fairly soon with a complete set of these files. Since the RAW: device does not return different sequences for control, Alt, or Amiga-key'ed function keys, only the basic 10 keys are supported. The parsing algorithm allows them to be reused. If you map F1 with an AKA.CMD file that contains a command ^ on a line of its' contents, a "Gold Level" internal flag is incremented. If a function key is now pressed, AnalytiCalc will look for AKcA.CMD (e.g., AKAA.CMD, AKBA.CMD, and so on). If AKAA.CMD contains two of these ^ commands (each on a line of its own), two presses of F1 result in the remaining keys acting like @DK:AKcB.CMD, and so on. It's a good idea to use the %%% commands (see the manual) to put up a label indicating gold level. Executing any @file.cmd command will zero the "gold flag" again; it's a "one time" flag. AnalytiCalc will work with the supplied keymap, but you may prefer to use it without that. The keymap does terrible, awful things to the keys' meanings, and will not coexist well with other tasks at all. This executable is useful even without a keymap, and will shortly have the command files supplied to you in a more easily used form. Watch the place you got AnalytiCalc for updates. Glenn Everhart