24 Jun 26 - I deleted SS1.bas, Version 1 and added SS1.bas, Version 2 to Github. Version 2 corrects some small bugs in version 1 and added several more features to the spreadsheet app. I’ll add the SS1.bas user’s manual below to explane the new features. I have also added 8 spreadsheet examples (*.ss1) to help explain how to use the app. - Jim
PicoCalc SS1.bas Spreadsheet Manuel
SS1.bas features a 10 column by 40 row total size and a 4 column by 15 row screen view. Columns and rows can be scrolled for viewing. The 60 cells shown on the screen are full size because no column/row headers are used. Navigation is done by a small window in the lower left-hand corner of the screen. To the right of this window is the “command” bar where all typing (cell labels, formulas, condition statements, etc.) takes place.
The “feel” and running of SS1.bas is very similar to Excel except for one large difference. Formulas in Excel are written algebraically, but are written in RPN on this spreadsheet.
All other SS1.bas functions are very much like Excell. For instance, to enter something into a cell, first move the cursor with the arrow keys to the desired cell. If the desired cell is off screen, just keep tapping on the arrow key in the direction of the cell. The columns and rows will “scroll” to the required cell. (Keep your eye on the “Cell ID” window in the lower left-hand corner.) When the cursor is over the desired cell, tap the “Enter” key. This will activate the “Command” bar. Type in “whatever” and then tap the “Enter” key again to move the “whatever” from the “command” bar to the desired cell.
The above “whatever” can be several different types of things: numbers, text, cell ID, formulas, condition statements, catenate, INDIRECT, etc. Each “thing” is entered the same way as described above (it takes 2 taps on the “Enter” key).
Numbers are straight forward: “Enter”, 23.74, “Enter”.
Text: Only 1 “word” can be entered. Thus, to enter “Ground Speed” into a cell, “Ground_Speed” is typed. Disregard the " ". The _ can be anything like . , _ | @ # etc. Just no spaces between words.
Cell ID: A1 The columns go from A to J; the rows from 1 to 40.
Formulas: Use RPN (Operands then Operator) One space between each “Token”.
Condition statements: Condition TrueValue FalseValue - For example:
B9 0 < B9 360 + B9 IF which is read as: IF value of cell B9 is less than 0 THEN change B9’s value to B9+360 ELSE retain B9’s present value.
Catenate: ~ is used to tie two “texts” together. (Excel uses +)
INDIRECT: The INDIRECT command is used to call one cell from the value of another cell. Very much like the VLOOKUP command in Excel> - For example: Suppose a spreadsheet has 20 different airports listed in column B and the airports are numbered 4-24 in column A. In order to choose the correct LAT/LONG data, which are stored in columns G & H, and rows 4-24, and the only input from the user is the airport’s number, the following is the syntax for the INDIRECT command: Note: Remember airport numbers are in column A. LAT numbers are in column G. The letter “G” is stored in cell C30 and the letter “H” is stored in cell D30. To copy the LAT value for airport number 13 into cell D23 (for mid calculations) – move cursor to cell D23, and type in:
C30 A16 STR$ ~ INDIRECT
How it works: C30 calls the letter “G”, A16 calls the number “13”, STR$ turns the number 13 into text, ~ ties the two texts together, INDIRECT calls the value from cell G13 and places it in cell D23, ready to use in the calculations.
Files: Tap F1 key. “1New, 2Open, 3Save, 4Save As, Esc” appears in Command bar. Tap the number for the desired function. NOTE: Only the file name needs to be typed in. The “B:” and file extension (.ss1) will be provided by the program.
Cell Protection: Color is used to mark the “Label”, “Input”, “Output”, and “Formula” cells. Tap the “Tab” key and a green 1, yellow 2, red 3, and a blue 4 plus “Esc” will appear in the “Command” bar. Move the cursor over a cell and then tap the colored number to change the color of the “text” in the chosen cell. Tap “Esc” when finished coloring cells. The following coloring scheme works well: green for labels and misc. cells, yellow for input cells, red for output cells, and blue for formula cells. Normally, the miscellaneous calculation cells are placed out-of-screen-view; like cell J40.