--- title: "Just Another Spreadsheet" type: "article" slug: "just-another-spreadsheet" url: "http://localhost/article/just-another-spreadsheet/" markdown_url: "http://localhost/article/just-another-spreadsheet.md" published_at: "2026-01-25T21:13:10+00:00" modified_at: "2026-06-21T23:24:22+00:00" featured_image: url: "http://localhost/wp-content/uploads/2022/04/20230809-041332.jpg" excerpt: "This little goodie will let you create formulas with all mathematical functions found on the TS2068 + 2 special functions, SUM and AVERAGE. You can enter up to 100 formulas and up to 200 texts in a 26x99 grid (that's 2574 cells in all!). Once the program has loaded the main menu will appear, choose…" category: - name: "Byte Power" slug: "byte-power" taxonomy: "category" url: "http://localhost/category/periodicals/byte-power/" post_tag: - name: "Downloadable" slug: "downloadable" taxonomy: "post_tag" url: "http://localhost/tag/downloadable/" - name: "Full Text" slug: "fulltext" taxonomy: "post_tag" url: "http://localhost/tag/fulltext/" - name: "TS 2068" slug: "ts2068" taxonomy: "post_tag" url: "http://localhost/tag/ts2068/" model: - name: "Timex/Sinclair 2068" slug: "ts-2068" taxonomy: "model" url: "http://localhost/model/ts-2068/" indiv: - name: "Kristian Boisvert" slug: "boisvert-kristian" taxonomy: "indiv" url: "http://localhost/indiv/boisvert-kristian/" publication_r: id: 38570 title: "Byte Power 1st Class Magazine" type: "periodical" url: "http://localhost/periodical/byte-power-1st-class/" authors_r: - name: "Kristian Boisvert" slug: "boisvert-kristian" taxonomy: "indiv" url: "http://localhost/indiv/boisvert-kristian/" issues_articles: - id: 38576 title: "Byte Power Feb 1987" type: "issue" url: "http://localhost/issue/byte-power-6/" pubdate: "February 1987" archive_link: true article_media: - id: 63194 title: "Just Another Spreadsheet!" type: "computer_media" url: "http://localhost/computer_media/just-another-spreadsheet/" --- # Just Another Spreadsheet This little goodie will let you create formulas with all mathematical functions found on the TS2068 + 2 special functions, SUM and AVERAGE. You can enter up to 100 formulas and up to 200 texts in a 26×99 grid (that’s 2574 cells in all!). Once the program has loaded the main menu will appear, choose your printer (TS2040 or FULL-SIZE printer) by pressing the appropriate number then when you have selected your printer press enter to go back to the main menu. You are now set to do your calculations! To get the “sheet menu” press spacebar when working with the spreadsheet. Pressing “m” will return to main menu, “c” will calculate the formulas, “p” will print on the printer, “e” will erase either a formula or text, “t” will enter either text or data (number), “f” will enter a formula. When in Edit formula mode, if there is a formula in the cell you’re at the computer will automatically edit it. To enter a formula you should type in the word in CAPITALS + the value in parenthesis. IE: SIN(102+A01) You can put numbers or cell numbers (A01) in a function and you can use as many parenthesis as you wish. You have a maximum of 32 characters per formula and 100 formulas. All functions must be typed in except for AVERAGE and SUM. Here is how they work; Average you would type in like this: AVE[A01..Z99] use the brackets instead of parenthesis. The computer will calculate even backwards (Z99..A01) it doesn’t matter, it is the same for SUM: SUM[B35..Q86]. The AVE[A01..Z99] would take all the values from all the cells indicated in the brackets (A01 to Z99), add them together and divide the total by the number of cells contained in the brackets (A01..Z99=2574, A01..b01=2, etc…) SUM only adds all the cells contained in the brackets. Here is an example of a formula: SIN(AVE[Z99..A01]+MIN[A01..A10]) (no more than 32 characters!)MIN[A01..A10] & MAX[Q25..Z50] will take the lowest and highest value of the cells within a given range. When in text edit, you will be asked if you want to either enter text or data. The text is only 7 characters long! Also you cannot enter text if there is a formula in that cell. The data can be anywhere within the computer’s limitations. If you chose Erase then you will have a choice between erasing a formula or the text (to erase data just go in Edit text and choose data and input 0!). Just choose the one you want. The print option will either print on the TS2040 or a full-size printer depending on which one you chose. The print driver for full-size printers should be at 64000 or so. The calculate mode is a little slow so don’t panic if you don’t get an answer instantly! ## Source Code: Just Another Spreadsheet! ``` 0 REM SPREADSHEET WRITTEN BY KRISTIAN BOISVERT ©1987 BYTE POWER 2 REM PRINT DRIVER SHOULD BE AT 29000 AND SHOULDN'T BE MORE THAN 900 BYTES LONG!!! 6 INK VAL "0": PAPER VAL "7": BORDER VAL "7": CLEAR VAL "28999": DIM a$(VAL "255"): LET E=VAL "0" 7 PRINT AT VAL "0",VAL "0";: LET l=VAL "USR 29976" 8 GO TO PEEK VAL "65535" 9 REM CALCULATE---DON'T MESS WITH THIS PART!!! 10 ON ERR GO TO VAL "7010": LET e=VAL a$ 20 ON ERR RESET : LET A=VAL "PEEK 23627+256*PEEK 23628+262": FOR F=VAL "0" TO VAL "4": POKE F+VAL "45902",PEEK (A+F): NEXT F: PRINT AT VAL "0",VAL "0";: LET A$="": LET L=USR VAL "44952": GO TO PEEK VAL "65535" 100 REM QUIT PROGRAM 110 PRINT USR 0 200 REM SAVE FILE 210 GO SUB VAL "8000": IF B$="" THEN GO TO VAL "210" 220 SAVE B$CODE VAL "45840",VAL "18654" 230 PRINT AT VAL "20",VAL "0";"REWIND TO VERIFY ";B$: VERIFY B$CODE 240 GO TO VAL "270" 250 REM LOAD FILE 255 GO SUB VAL "8000" 260 LOAD B$CODE VAL "45840" 270 PRINT AT VAL "0",VAL "0";: LET L=VAL "USR 38619": GO TO PEEK VAL "65535" 7000 REM ON ERROR IN FORMULA 7010 PRINT #VAL "0";AT VAL "0",VAL "0";TAB VAL "7";"ERROR IN CELL "; FLASH VAL "1";CHR$ VAL "((PEEK 65533)+1+64)";("0" AND VAL "PEEK 65534<10");PEEK VAL "65534" 7020 ON ERR RESET : BEEP VAL ".5",VAL "20": PAUSE VAL "0": PRINT AT VAL "0",VAL "0";: GO TO VAL "270" 8000 REM GET STRING 8010 INPUT "FILE NAME:"; LINE B$: IF LEN B$>VAL "10" THEN GO TO VAL "8010" 8020 RETURN 9000 CLS : PRINT AT VAL "8",VAL "3";"JUST ANOTHER SPREADSHEET!";AT VAL "10",VAL "8";"©1987 BYTE POWER";AT VAL "12",VAL "2";"WRITTEN BY KRISTIAN BOISVERT" 9005 PRINT AT VAL "20",VAL "0";"STILL LOADING..." 9006 INK VAL "7": PRINT AT VAL "15",VAL "0";: LOAD ""CODE : PRINT AT VAL "15",VAL "0";: LOAD ""CODE 9010 INK VAL "0": PRINT AT VAL "20",VAL "0";TAB VAL "31";" ": IF VAL "PEEK 23681=0" THEN PRINT AT VAL "15",VAL "0";: LIST VAL "9999": STOP 9020 RUN 9999 SAVE "SHEET" LINE VAL "9000": SAVE "SHEET"CODE VAL "29976",VAL "15864": SAVE "SHEET"CODE VAL "64494",VAL "920": VERIFY "SHEET": VERIFY "SHEET"CODE : VERIFY "SHEET"CODE ```