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=›