A N A L Y T I C A L C H E L P S Y S T E M To get HELP use the command Hn where n is 0 thru 8 for HELP 0 through HELP 8. HELP 0 - This screen HELP 1 - Summary of many AnalytiCalc commands (terse) HELP 2 - Data Entry / Editing HELP 3 - Calculation Control HELP 4 - Cursor Motion and Positioning HELP 5 - Cell Copy HELP 6 - Add/Subtract Absolute Rows/Cols HELP 7 - Add/Subtract Relocting, Rows or Cols. HELP 8 - Change Display Size, Col Size, Load Data HELP 9 - Keypad Diagram for Amiga EN expression - Insert expression at current pos. M1,M2,M3, or M4 - Motion up, down, left, right (auto) DL var1:var2 Rn:m (or Cn:m) - Display Loc phys to row/col n-m DF var1:var2 [format] - set display format. A or L shows text, else # DT var1:var2 F or I - Set display number type to flt or int DW n,m - set width of column n of display to m chars DB c,r - Set display bounds at c cols, r rows (chars) L var - Move cursor to var named (phys.) OA var or OR var=move displ. origin V - redraw screen. VF - Disply. formulas. VM=no auto. redraw. K - interactive calc. *E returns. ZA - zero all. ZE var1:var2 - zero var1 thru var2 X - exit program. W write screen to file or printer CV v1:v2 v3:v4 copy value from v1:v2 to v3:v4 range; CR=copy and relocate vars. CD v1:v2 v3:v4 copy display format. CF=copy formula. CA=copy all P Put screen to file. G=get screen from file at curr.loc 1,2,3,4 - move cursor Up,Down,Left,Right. A[A/R]n[R/C] Add abs/reloc n Row/Col Variable ranges are var1[:var2]. Var names P#+n#+m or D#+n#+m are current Phys or Display locs + or - offsets Expressions may use multiple stmts, use \ separators. Use std FORTRAN function names + MIN, MAX, AVG, STD, AND, IOR, XOR, MOD, or SUM. IF stmt format is IF [v1.REL.v2]yes-expr|else expr. Rels are .LT.,.GT.,.EQ.,.NE.,.GE.,.LE. R Recompute sheet. RM Recompute Manually only (R resets) HELP 2 - Data Entry / Editing E expression Enter expression into cell. Formulas available (+ SQRT,SIN,COS,LOG,EXP,ATAN) SUM[variables] Sum of all arguments MAX[variables] Max of arguments MIN[variables] Min of arguments AVG[variables] Average of arguments STD[variables] Standard deviation squared IF [V1.rel.V2] statement | else-statement In the first 5 cases, arguments are variable names separated by commas, or variable ranges, or mixtures separaged by columns. ".REL." is any of the 6 forms: .EQ. Equal .NE. Not Equal .GT. Greater than .LT. Less than (V1 less than V2) .GE. Greater or Equal .LE. Less than or Equal to (V1 =< V2) *XV filename V1 Extract value at cell V1 in saved sheet stored in filename. ED `string1`string2` Replace string1 with string2 in current cell formula. Either string may be null if desired. HELP 3 - Calculation Control R Recalculate all of the sheet. RM Recalculate manually only until R command given RF Recalculate sheet, force constant recalculation K Drop into interactive calculator. *E returns to sheet X Exit to operating system. V Redraw screen with normal formats (View) VF Redraw screen showing all formulas (View Formulas) VM Dont redraw screen until a V or VF is given (View Manual) VH+ or VH- Turn display of current row calculation on/off ZA Zero whole sheet ZE V1:V2 Zero variables in a row or column in range from cell V1 to cell V2 (V1,V2 = names of cells) @filespec Read filespec and execute commands as though typed. PPX Save current sheet (formulas and numbers) from cursor dn,rt PDF Put out current Display sheet (Formulas) PPF Put out current Physical sheet (Formulas) PDN Put out current Display sheet (Numbers) PPN Put out current Physical sheet (Numbers) W Write screen to hardcopy file. HELP 4 - Cursor Motion and Positioning L variable-name Position cursor at variable-name M1, M2, M3, M4 Move Up, Down, Left, or Right after an Enter (but not immediately) 1 or Uparrow (Move up) 2 or Downarrow (Move down) 3 or Left arrow (Move left) 4 or Right arrow (Move right) OA variable Reset origin of display to variable OR variable Reset display down and right to start with variable, changing only region down and right of cursor DL V1:V2 Rn:m point at display coordinates (n,m) (col,row) and, going left to right along a Row, copy in variables V1 through V2 (actually, point those display sheet cells at variables V1 thru V2). DL V1:V2 Cn:m point at display coordinates (n,m) (col,row) and, going top to bottom along a Column, copy in variables V1 through V2 (actually, point those display sheet cells at variables V1 thru V2). DF V1:V2 [format] Set display format of range V1:V2 to format (format A means display formula.) HELP 5 - Cell Copy CA V1:V2 V3:V4 Copy all cell attributes from V1:V2 to V3:V4. CV V1:V2 V3:V4 Copy numeric values only CD V1:V2 V3:V4 Copy Display Formats only CF V1:V2 V3:V4 Copy Formulas only (no relocation) CR V1:V2 V3:V4 Copy all cell attributes as in CA but relocate cell names to new location from old one. Only relocate names right of or below the cursor or on same row/col with cursor (cells above or left of cursor are NOT relocated). Label cells are not altered. If V2 is missing, V1 is replicated to V3:V4 range. HELP 6 - Add/Subtract Absolute Rows/Cols AA number R Add "number" rows ahead of the current physical position, moving all cells below the current cell down by "number" rows and losing the physical sheet`s bottom "number" rows` contents, NOT adjusting variable references where the variables are in the moved range and are not the position independent (P## or D## forms) type. AA number C Add "number" columns ahead of the current physical position, moving all cells right of the current cell right by "number" columns and losing the physical sheet`s bottom "number" columns` contents, NOT adjusting variable references where the variables are in the moved range and are not the position independent (P## or D## forms) type. HELP 7 - Add/Subtract Relocting, Rows or Cols. AR number R Add "number" rows ahead of the current physical position, moving all cells below the current cell down by "number" rows and losing the physical sheet`s bottom "number" rows` contents, adjusting variable references where the variables are in the moved range and are not the position independent (P## or D## forms) type. AR number C Add "number" columns ahead of the current physical position, moving all cells right of the current cell right by "number" columns and losing the physical sheet`s bottom "number" columns` contents, adjusting variable references where the variables are in the moved range and are not the position independent (P## or D## forms) type. HELP 8 - Change Display Size, Col Size, Load Data DW N,M Set column N on display to be M characters wide DB n,m Set number of columns displayed on screen to n, number of rows displayed to m. GD Reload sheet down/right onto display coords. GP Reload sheet down/right onto physical coords. < Rewind the current Analyticalc input file * any text Comment. (For command files.) Hn Display a screen of help. n may be 0 to 9, default 0. F filename/nnnn Read filename, skipping nnnn lines if the "/nnnn" is there, and load contents onto the currently displayed screen, broken into columns as the current screen is set up. AnalytiCalc Keypad Standard Keys +--------------+--------------+--------------+--------------+--------------+ | F1 | F2 / Gold F2 | F3 / Gold F3 | F4 | F5 / Gold F5 | | |Search Formula| Copy range | | LOAD SHEET | | GOLD |_ = wild char | | SAVE | | |(Selects alt. | | | SHEET | | | Function key |Incremental |Cell to region| |LOAD SHEET & | | meanings) |insert values |(cell at u.l.)| | RELOCATE | +--------------+--------------+--------------+--------------+--------------+ +--------------+--------------+--------------+--------------+--------------+ | F6 / Gold F6 | F7 / Gold F7 | F8 / Gold F8 | F9 | F0 / Gold F0 | |Set Motion Dir| Set Window |Insert/Delete | START | Recalculate | | |(D,R from cur)|Rows or Cols | NEW CLI | | |Row -> area | | | | | | | Set Origin | | START | Recalculate | |Col -> area | of Display | | NEW SHELL | & force all | +--------------+--------------+--------------+--------------+--------------+ Cursor arrows move on screen. HELP key starts HELP command X - Exit from spreadsheet.
