Programs: Video-Plan,
Computacalc
Price: V-P £9.95 deluxe,
£7.95 standard
CC $39.95 US
ROM/RAM: 8K/16K, ZX81 only
From: V-P--Video Software Ltd.
Stone Lane, Kinver, Stourbridge,
West Midlands, UK DY7 6EQ
CC--Mindware Co., 70 Boston Post
Rd., Wayland, MA 01778 (written by
Silicon Tricks, London)
Electronic spread sheets (like Visi-Calc) let you analyze or model business and financial problems quickly and easily. You can try changes, make corrections, and play with alternatives. Any task using rows/columns of numbers you can carry out with these two programs.
Computacalc and Video-Plan run on ZX81s with 16K RAM. Neither runs on upgraded ZX80s. Both are written in BASIC, run slowly, can be LISTed, work with ZX printers, have mostly OK input error trapping and recovery, left-justify entries (decimal points do not line up), and let you force recomputation.
Neither program lets you move rows or columns automatically, nor can you insert rows or columns. As a user, I miss these functions. As a rotten typist, I also miss the ability to edit complex formulas.
Each program emphasizes a different approach to analysis–CC is cell-oriented, V-P is column-oriented.
Documentation for each program is poor. The notion persists among software suppliers that one manual can serve to sell, instruct, exemplify, explain, and catalog. Once you learn to use the program, you will find looking through the examples just to find a command annoying. Of the two, V-P did the better job.
CC’s manual fits in the cassette case–4 1/2 columns of type set 13 lines to the inch. You get an example that demonstrates most commands, a list of options to respond to the major prompt, and two hints to modify the program.
V-P uses larger type and provides a 19-page booklet that covers similar topics. Three pages describe suggested applications, and three are devoted to titles and contents. Each menu option is fully described by telling the consequences of each permissible response. Chapter 5 on functions lacks clarity and does not explain which columns may have subtotals.
In most cases the effect of erroneous entries is explained. Both programs can behave badly without warning the user, though CC exhibited fewer of these problems. Any long tape can load with a few errors which may cause the program to crash after a while. That’s a needless annoyance–run the Syntactic Sum of these programs when you first get them and at every load thereafter.
V-P exhibited defects so serious that I must rate it unacceptable until they are cleared up. You can print a table with data and titles misaligned; subtotals can be arithmetically incorrect; and you can confuse the program so that the spread sheet calculates subtotals at intervals other than those you asked it to. All of these occur without warning.
CC can give the usual least-signicant-digit error between row and column totals, resulting from round-off error.
Both programs provide huge grids, much to their detriment. Neither gives you any direct control over grid size, and both calculate the whole grid every time. V-P took about 10 minutes to retotal the sheet after changes–most annoying. CC is much faster when you use small portions of the sheet since it only calculates formulas you put in, whereas V-P always does all row functions and column totals–nice, but slow.
V-P only allows functions between columns, but displays the function below the column at all times. In CC, you define cell relationships freely, but you’ll never see them again unless you write them down. The function labels just serially number the formulas you put in.
V-P handles titles separately from data, so they don’t scroll off the screen, but V-P doesn’t move the row titles and data together as it does the column labels. CC treats the labels as data, and scrolls them off screen on large grids. Neither program provides a title lock, nor does either let you adjust the row title size independent of the data block.
Despite the shortcomings, I am delighted to see programs of this type becoming available for the ZX81. Computacalc is a usable program and both are recommended for programmers who want to see how to do these functions in BASIC.