Cell Annotation

The 320K version of AnalytiCalc has a simple "cell annotation" feature
to aid in documenting complex spreadsheets. Annotations are separate
files which can be created and maintained with the aid of the spreadsheet
and viewed on command.
	To create an annotation file, you place the cursor on the cell
you want to annotate and type AN (followed by return) as a command
(you'd type /AN in Enter-mostly mode). AnalytiCalc will then fire up
a new copy of COMMAND.COM with the command "EDIT filename.ANN" where
filename is made up of the first 3 characters of the sheet's title if
these are alphas, followed by a 5 digit hashcoded cell identifier.
It is assumed you have an editor named EDIT that can create a file when
it is invoked this way if the file does not exist. Once in the editor,
you can create any comments you like. When you exit, the sheet will be
redrawn, but the annotation file will be left on disk. Several public
domain editors, notably micro-Emacs, will respond as this scenario
requires; you need to find one and name it EDIT to have this work.
	To view an annotation, move the cursor to the cell whose annotated
text you want to see and type either ? or QUEry (QUE is sufficient, but you
may spell out ANNOTATE or QUERY in full if you like). The sheet will look
for the annotate file and either display up to 20 lines of it on screen
or flash a message that no annotation file could be found for this cell
and go on.
	The scheme used has virtues of simplicity but some limitations.
Annotation filenames will not be changed for cells moved around, nor will
they be altered if rows or columns are added or deleted. Thus these
actions will cause annotations to be attached to the wrong cells. The
hashcode is a television sort of raster scan down the sheet (i.e., across
columns and down, as in A1, B1, C1,...A2, B2, C2, ... A300, B300, C300,...)
so that the name order corresponds to the order on the sheet. However, no
bulk display of annotations is provided. Also, no check on uniqueness of
filenames is made. If the 3 characters of the sheet title do not disambiguate
annotation filenames, conflicts may occur. As a result, try to make the first
3 title characters useful as descriptors. You should set up the layout of
a sheet first (including any copying, adding, or deleting rows, columns,
or regions) and THEN fill it in and annotate it for this system to be
helpful. It is not recommended to do much annotation on floppy based systems
since you may run out of directory slots or disk space. The scheme used is
not space efficient, but is designed for utility on AT class boxes (where
the 1.2MB floppy has more space and fileslots) and does not impose long seek
times in any single "annotation file" scheme that would use one file for all
comments and have to find the desired record in such a file.
	The S command has a question which allows you to replace the EDIT
command with any desired editor type command (up to 15 characters) for
annotating cells.
        It is suggested that a comment like \*C*** be added after a cell
formula that is annotated. In that way the built-in formula search functions
(> and >> commands) can be used to locate annotated cells.