o=o=o=o=o=¢ ¢ BCALC¢ Analog Computing #63¢ ____________________¢ ¢ BCALC is a spreadsheet using 8K of¢ memory and approximately 24K for¢ data. It comprises a 64 x 64 grid,¢ columns AA to CL and rows 01 to 64¢ ¢ Three types of data can be entered¢ in a cell:¢ ¢ TEXT: anything not beginning with a¢ number (0-9) or (=) or (-). <Ctrl-T>¢ permits numbers to be entered as¢ "forced text".¢ ¢ NUMBERS: a number that begins with¢ 0-9 or (-) or (.) Do not type¢ commas, they can be displayed using¢ formatting commands.¢ ¢ FUNCTIONS: (formulas) arithmetic or¢ algebraic expressions starting with¢ (=). Five functions are: (^) (*) (/)¢ (+) (-).¢ ¢ CONSOLE KEYS:¢ ¢ START: used to abort any input in¢ any mode.¢ ¢ OPTION: displays status screen:¢ Filename, free bytes, recalculation¢ status and mode.¢ ¢ SELECT: enters command mode (text¢ window changes to gray).¢ ¢ DIR n - disk directory for Dn:.¢ ¢ WID ccnn - Width of column "cc" to¢ "nn". Width must be greater than 01¢ but less than 32. i.e. WID AC04 sets¢ column AC to 4 characters wide.¢ ¢ SAV Dn:filespec - SAVes the sheet to¢ disk.¢ ¢ LOA Dn:filespec - LOAds previously¢ saved sheet.¢ ¢ LIS Dn:filespec - LISts spreadsheet¢ to disk in Ascii format for use with¢ word processor. Use cursor to define¢ block to be listed to disk. Do not¢ attempt to LOAd a listed format¢ file.¢ ¢ GOT ccrr - GOTo cell "cc" column and¢ "rr" row. Range must be from AA-CB¢ and 01-47. (puts cursor on top/left¢ of screen, thus row 47 would put row¢ 64 on bottom of screen).¢ ¢ SET ccrr - sets "cc" column and "rr"¢ row references to be displayed on¢ bottom of text window. You can have¢ a "heading" row displayed on bottom,¢ corresponding to the column your¢ cursor is located in.¢ ¢ CONTROL KEYS:¢ ¢ Control Arrows for cursor movement¢ and used in lieu of [RETURN]. i.e.¢ You enter data in AA01 and want to¢ move to AA02, hit Ctrl-* (right¢ arrow) and the data is entered in¢ AA01 and cursor moves right to¢ AA02.¢ ¢ Ctrl-H home to cell AA01.¢ ¢ Ctrl-D deletes block of cells¢ (prompted).¢ ¢ Ctrl-C copies block of cells.¢ (Formula cells unchanged)¢ ¢ Ctrl-M moves block of cells.¢ (Formula cells adjusted)¢ ¢ Ctrl-T text is forced when entering¢ numeric or "=" data in cells.¢ ¢ Ctrl-G global format of column¢ cursor is positioned in:¢ ¢ L,C,R justification Left, Center,¢ Right.¢ D dollar ($) sign toggled.¢ J commas on/off.¢ 0,9 number of decimal places¢ displayed to right of decimal¢ point.¢ ESC makes choice final and exits.¢ ¢ Ctrl-F format individual cell.¢ Escape reformats cell and exits.¢ ¢ Ctrl-E edit current cell.¢ ¢ Ctrl-P prints spreadsheet. (prompts¢ for upper-left/lower-right cells)¢ ¢ Ctrl-O recalculation mode on/off.¢ Use it in off mode when entering¢ data or it will recalculate after¢ every entry and slow things down.¢ ¢ Ctrl-R recalculation order changed¢ from rows to columns and¢ vice-versa.¢ ¢ Ctrl-A All cells recalculated now.¢ ¢ Ctrl-K Kill (erase) current cell.¢ ¢ [Caps] toggles upper/lower case.¢ Both recognized in formulas.¢ ¢ FUNCTIONS must be typed in format¢ using (@) symbol, followed by¢ function, followed by parenthesis.¢ (=) is used to make function entries¢ in a cell. e.g.¢ ¢ =@ABS(AF12)+@SUM(AC03,AC08)¢ ¢ SQU - squaring¢ SQR - square root¢ ABS - absolute value (- becomes +)¢ RND - round value (closest integer)¢ EXP - exponentation base 10¢ LOG - logarithm base 10¢ INT - greatest integer¢ ¢ Following require 2 cell entries¢ separated by comma:¢ ¢ @CNT(AA01,AA22) - counts number of¢ cells in a block that have entries¢ (number, text or formula).¢ ¢ @SUM(AC03,AC12) - adds the entries¢ in a block.¢ ¢ @AVE(AE12,AG12) - find the average¢ of all entries in a block.¢ ¢ <SYSTEM RESET> exits BCALC to DOS.¢ ¢ o=o=o=o=o=¢