VU-CALC

Author(s): John Slattery
Publication: Syntax
Pub Details: Syntax/Syntax ZX80 v5 n6 (Volume 5, Issue 6)
Date: June 1984
Pages: 5
Program:   VU-CALC
Machines:  TS2068
Form:      Cassette
RAM Req:   48K
Listing:   No
Listable:  Only BASIC part
Language:  MC and BASIC
Display:   Excellent
Author:    Psion
From:      Timex Computer Corp.
           and other suppliers
Price:     $24.95

Only the name of this program resembles the ZX/TS VU-CALC. This version occupies 37K when resident without any data. Due to its design, large tables use very little additional memory.

Timex’s manual for this spreadsheet program leaves much to be desired, but Psion wrote such a good program that you get comfortable very quickly. Formulae can include simple arithmetic and sums, as well as constants and cell references.

You can enter text by typing a quote first, then the text and ENTER. Constants and formulae can be typed directly (followed by ENTER). Commands (accessed via the # key) include calculate, edit formula, format, load, save, print, repeat, blank, transfer, and quit.

Repeat allows replication of lines, titles, data, or formulae. Transfer moves sections around without changing them. Format allows you to specify integer, money, or general display format, right or left justified. Text mode allows 28 characters, some of which will spill over to adjacent cells.

If the program dumps you out to BASIC, you type GOTO 9000 and it shows the cell which generated the error. Hit ENTER and you can continue to work on the worksheet. Do not ignore this part of the directions: you may lose your data.

VU-CALC fixes column width at 7 characters, which can be a serious limitation if you deal with sums of money over $9999.99. The ZX/TS version handled 8 characters, a slightly more realistic size.

VU-CALC contains a bug which makes formulae impossible to enter after exiting to the main menu and selecting option 2, clear entire worksheet. To correct this bug, follow these instructions.

LOAD the VU-CALC tape. Edit line 3200, inserting one CLEAR statement at the beginning of the line. SAVE “Vcalc” LINE 10 on a fresh tape. Now rewind the original tape, and LOAD “”CODE. This will load in the title screen. Save this on the new tape after the VU-CALC BASIC section with SAVE “S”SCREEN$. Finally, SAVE “V”CODE 29327,36000 to put the VU-CALC machine code on the tape. This tape will take longer to load than the original.