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 PortaCalc 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 IBM PC and compatibles 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) VC,VB,VI View Color, Black&White, IBM BIOS - screen controls 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 in. 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 Portacalc 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 -------------+------------ ALT F1 = | HELP | Search | _ is wildcard char Keypad Picture | F1 | F2 | -------------+------------ (Alt F3=Cell |Copy Range | Save Sheet| ALT F4 = Save Numeric to Region) | F3 | F4 | -------------+------------ ALT F5= Get |GET Sheet | Motion Dir| ALT F6 is copy ROW to area Relocating | F5 | F6 | CTRL F6 is copy COL to area -------------+------------ (Also Disables |Set Window | Ins/Del | Insert or Delete Rows or Columns Scrolling) | F7 | F8 | -------------+------------ Alternate |Exit ENTER | Recalc. | ALT F10 = Recalc with Force Enter Mode | F9 mode | F10 | -------------+------------ Cursor arrows move on screen. ALT arrows scroll screen in arrow direction. X - Exit from spreadsheet. INS - go into ENTER mode (/ exits) HOME key - goes to upper left of sheet. END - go to last active cell X - Exit from spreadsheet. INS - go into ENTER mode (/ exits)
