home
***
CD-ROM
|
disk
|
FTP
|
other
***
search
/
Amiga Elysian Archive
/
AmigaElysianArchive.iso
/
bus_pers
/
analycal.lha
/
README
< prev
next >
Wrap
Text File
|
1990-02-17
|
8KB
|
164 lines
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.
Using non-interlaced screen, AnalytiCalc will fit in 512KB
systems, but with reduced display size.
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.
Note on Version 23-1A:
In response to complaints about slow spreadsheet load/save, I have added
some speedups to normal text load/save. Also there is now a new pair of
commands: PB and GB. These put or get a sheet in binary format, faster
than the normal PP or GP methods. Sheets saved in this form are Amiga
specific. Also, internal commands (e.g. *X cell) will not work on
binary saved sheets. The PP/GP commands are still present, and work on
ALL AnalytiCalc versions (VAX, PDP11, Amiga, MSDOS). Spreadsheets to be
transmitted to other systems should be saved in ASCII form using the PP/GP
commands.
Glenn Everhart
Note on version 23-2C:
Two address modes are added:
P#_AB (where A and B are accumulator names in the range A to Z)
addresses the cell whose column number is in the first accumulator
(A in the example) and whose row is in the second accumulator (B
in the example). Thus if accumulator D contains 2 and accumulator
G contains 5, then P#_DG addresses cell B2 (col 2 row 5).
P#$V1:V2:
works like the P#_AB form but uses any cell address for V1 and V2.
Thus if cell D4 contains 2. and cell G12 contains 5., the cell
P#$D4:G12: refers to cell B2. The variable names may be any legal
addressing forms EXCEPT the P#$v1:v2: form within this construct.