Apple Lisa

Lisa_001

Each month one of Microcomputer Printout’s team of experts gives a vast amount of free publicity to a product they happen to like. Julian Allason opted for Apple’s new LISA – because, quite simply, it works the way you do.

Soft Soap

Julian Allason is critical of LISA’s Software.

“A soft answer turneth away wrath” says the Bible’s book of Proverbs. And answers to the microcomputer problem come no softer than LISA. Indeed, so friendly is she that the doyen of micro dealers, Mike Sterland, professed himself worried that existing Apple clients might be jealous at the thought of mere newcomers enjoying her sundry charms.

There can be little double that what I suppose we must call the LISA operating system – although it is so transparent as to be invisible – is superbly executed. After a few minutes one is merrily scuttling the mouse across the table top; selecting here; opening there; consigning files to the waste basket, and drawing the prettiest of pictures. To the experienced hacker, the sheer joy of being able to see what files are open; what jobs remain to be done; whose birthday is impending; is little short of a revelation. Beginners soon take it for granted – which is perhaps the highest accolade of all.

Lisa_002

The movable mouse with its single ‘select’ button is used to point to a function on the screen

Lisa_003

But is the applications software (although again this is a term Apple wouldn’t dream of using) as good? I fear not.

Like the curate’s egg, it is good in parts. The authoritative Rosen Electronics Letter, describes them, with the exception of LISADrawer and LISAProject as ‘pedestrian versions of standard functions that have been better done elsewhere’. Quite so. The point, however, is the degree of integration between them. Unhappily, even this is not as comprehensive as it might have been. The LISAWrite word processor for example does not allow you to insert information from the other applications, except by adding an extra page to the document you are working from.

If you are the sort of writer who needs fancy functions like footnote management and indexing, you would be frankly better off with Wordstar (and it is just a matter of time before that appears on LISA). On the other hand LISAWrite gives you lots of type faces and sizes to play with. And you can print them all out exactly as they appear on the screen, using both Apple’s new dot matrix printer, and, amazingly, the daisywheel printer. Most of the usual functions for manipulating text are there, and in my humble judgement, the program is more than adequate.

Much the same judgement must apply to LISACalc, which would be a fairly run-of-the-mill first generation spreadsheet if it didn’t offer variable column widths and one or two other goodies. One criticism levelled at it is the absence of multi-sheet consolidation, a feature which might have been expected to appeal to the corporate users who supposedly constitute LISA’s target market.

LISAGraph offers the usual types of business graphs in four different sizes. Thanks to the 720×364 dot resolution of the 12” screen, they look a lot better than on most other micros. Up to seven different sets of data can be held, and converted into graphic form.

This data can either be keyed in directly as a set of values, or moused over from the Calc program. The point that caught the eye of almost all lucky enough to have had a sneak preview of the system, was the way in which the graphs change automatically following any amendment to the data. Clever stuff!

LISA Terminal is optional, and it sounds like, and emulates DEC VT100 and VT52 modem and terminals. IBM 3270 emulation is likely to be included by the time LISA goes on sale here sometime this summer (is September still the summer? “It’s real hot out here in September,” says my chum in Cupertino with a wink).

And now the exciting bits. LISADraw is astonishing. If you’re drunk it will even straighten out your lines. Combine it with LISAGraph or LISAProject and the results get to look very professional indeed. The first time I saw LISA the demonstrator, Apple’s Brian Reynolds, created first one, then a whole series of drawings of LISA just by selecting from lines, shapes and shading with the mouse. And, Apple II users please note, text can go anywhere on the screen.

LISAProject is for critical path analysts. I’m no expert on project management, but even I could understand the schedules when they were displayed in graphical form, showing the critical paths amongst tasks, represented by boxes containing the details of the resources required, and milestones. In true calc fashion the critical path can be changed to take into account changes in resources – more Irishmen hired, a compressor stolen, for example – or unexpected delays. Once the output has been tarted up using LISADraw, the results are well up to management consultancy standards.

The last application is LISAList which is really a sort of database for dumbos. I’m not sure why it’s been billed as a list management package as several of the more standard mailing list functions seem to be missing; ditto a proper report generator.

Apple would probably argue that LISAList is intended for general use rather than high powered mailing or database management. Packages dedicated to precisely these applications may be expected sometime in the future. Quite when, however, remains a bit of a mystery. As I write, more than a month after the launch, the LISA development toolkit has yet to appear, and latest word is that it is unlikely to be before June. Without it third party software houses are going to have difficulty writing any applications programs that exploit LISA’s true capabilities. Without those programs LISA could turn into a seven month wonder.

The computer supports Pascal, BASIC, and COBOL languages so the problems are hardly insoluble. The onus must also be on Apple to get out and sell LISA in quantity. These self-same software houses subscribe to a strictly commercial code. Commandment 1 of this states that Thou Shalt Only Convert Software for Machines with a Large User Base’.

So different and so special is LISA it can truly be said to have a user base of zero.

But perhaps not for long. I, for one, have placed my order.

Lisa – An Expensive Lady?

In counterpoint to the otherwise noisy proceedings at LISA’s launch was the silence that greeted the announcement of the price – the sterling equivalent of $10,000 plus travelling expenses.

With the pound sick, and the gnomes tremulous, that translates to something like £7,500 – a lot of anyone’s money for what is still essentially a personal computer. Have Apple blown LISA’s chances then?

Some of the more cynical dealers thought not. “No one knows better what the market will bear than Keith Hall,” remarked one computer retailer, who had known the rugger-playing Sales Director in his incarnation as Commodore’s marketing mafioso. The existence of a market at that sort of price level is certainly not in doubt. Xerox have demonstrated that by selling every 8010 work station – the only piece of hardware remotely comparable to LISA – at over £11,000 each.

The other conclusion reached by the trade, after the customary head scratching, was that when LISA does arrive it could be in short supply. Indeed Apple have already indicated their intention of restricting LISA dealerships to a select few. The official explanation is that only the most experienced business systems houses would be able to do justice to the new baby. Quite how this squares with Apple’s claim (probably justifiable) that LISA is so easy to use that it can be learned in twenty minutes, is anyone’s guess.

Rumour, that oft ill-informed lady, has it that the original UK target price was £6,500; that was before the gnomes weighed in and sterling tumbled. There seems also to have been genuine disagreement on price within Apple. Sources close to the company’s Cupertino headquarters talk of two distinct schools of thought, one favouring a ’low’ price around the $8,000 mark with a view to maximising the company’s advantage in being first. A second group is said to have canvassed a $12,000 price tag on the basis that this would generate the optimum revenue, given the inevitable supply problems during the first year.

In the event, Apple’s chief executive, Mike Markkula, seemed to have split the difference, conscious perhaps that LISA’s market lead had been whittled down by successive software delays.

The unknown factor in the LISA price equation is Macintosh, LISA’s little brother. The conundrum now entertaining Cupertino’s corporate types is this: how cheaply can we make Little Mac?

Like LISA Macintosh is based on the Motorola 68000 16-bit microprocessor. Like LISA it should run much the same software. But will it? Like Topsy, LISA’s software just grew and grew and now occupies more than two megabytes of memory in all. Any possibility of marketing a floppy only version of LISA went out of the window more than a year ago; hence the presence of the separately boxed Profile five megabyte hard disk. Exactly the same problem now arises with Little Mac.

One theory now current amongst Apple watchers proposes $10,000 as an artificially high price for LISA, simply in order to maintain market separation from Macintosh. All this speculation – for speculation it largely is – is based on the assumption that LISA is overpriced. But is it? Try as one may, it is hard to put together a 68000-based system with Hi Res graphics, a megabyte of RAM, five megabytes of Winchester storage and half a dozen or so applications packages and still find oneself with much change from £8,000. And what price user friendliness?

LISA may not be within reach of everyone’s pocket, but it certainly looks like good value to me.

Which side of the Blanket?

Julian Allason examines Lisa’s parentage…

Lisa_004

The Xerox Star was the first workstation to employ the multiple-window technique. More recently Visicorp announced Vision for the IBM PC.

Frowns outweighed smiles as microcomputer folk reacted to the launch of Apple’s LISA computer last month.

The most maniacal grin adorned the visage of Apple’s rugger playing Marketing Director, Keith Hall, as he exhorted his dealers into orgasms of excitement at the prospect of selling the wonder micro.

The details of LISA, which will not have come as a very great surprise to readers of this organ, brought a furrow to the brows of competitors. “Now everyone will want integrated software,” moaned one small British microcomputer manufacturer. “Look how long that took Apple to develop – and we don’t have a fraction of their resources.”

Ecstasy was also less than unanimous amongst dealers. “Apple have wrecked the market. I’ve already had two of my best customers call to put a freeze on further orders. The worst part is that Apple won’t even be able to deliver LISAs for six months and then not in any quantity,” complained one member of the Computer Retailers’ Association.

Wry smiles were the order of the day in Uxbridge, headquarters of Xerox, makers of LISAs only competitor, the 8010 workstation, otherwise known as the Star. As noted elsewhere on these pages, LISA owes much of its heritage to work done at Xerox’s Palo Alto Research Center. Work that culminated in the Alto prototype user friendly computer. From the Alto – so far the only personal computer to have achieved true cult status – sprang from the aforementioned Star.

When industry pundits take a step back from the trees to inspect the wood, they will notice something very odd. Working from the same starting point, Apple reached a very different – one is tempted to say the opposite – conclusion from Xerox. For the Star is viewed by Xerox as a workstation for their Ethernet local area network. Apple, on the other hand, are adamant that LISA is a one-man machine, a personal computer that will adorn the desk of professional managers.

It is a curious conflict and one is tempted to wonder whether both companies can be right.

In truth not even Apple are convinced that they enjoy a monopoly of wisdom. As one senior manager remarked, after looking round to ensure that we were not being overhead, “In scientific circles the very best rows start with opposing conclusions being drawn from the same data…”

But it may not even be a two sided argument, because VisiCorp, whose VisiON operating environment has received the rough edge of Apple’s corporate tongue, think they are dealing with a very different sort of animal. If one could reconstruct the chain of evolution of the concepts first developed at Xerox PARC and Stanford University, it might go something like this: Alto user friendly personal computer becomes the Star workstation, a single component in a network of stations sharing printing and file storage resources, but its principal function is to exchange information.

As a personal computer company, Apple find other aspects of the Alto more sympathetic. The use of multiple screen windows, the mouse as a pointer to them, and of icons (small graphic symbols) to indicate the status of the work in hand all appeal. The network emphasis less so. Apple see the integration of the most popular office applications as a means of closing the gap between computers and office functions as they are normally (i.e. manually) carried out.

At the bottom of the chain, or at least as far down as we can see for the nonce, is VisiCorp. In their world view the PARC concept is primarily a means of making applications programs more user friendly. Not surprisingly, the first programs to receive the VisiON treatment will be VisiCalc, VisiWord, VisiPlot, VisiTrend, Visi etc. And least anyone deprecate that, your correspondent would like to add that he was enormously impressed the first time he sat down with VisiON. Moreover, the system has received the imprimatur of mega-mini-computer-maker Digital Equipment Corporation. In the computer world this is the equivalent of not just a feather in the cap for VisiCorp, but a whole bird in their bonnet.

Whether future micro biological expeditions down this particular evolutionary train will be warranted in the future remains to be seen. Certainly there are some interesting growths under culture in the labs of Microsoft and Digital Research. Our microscopes will be trained in their direction over the coming months…

First published in Microcomputer Printout magazine, April 1983

Filing the Fillings

Fillings

Michael H Rich describes how micros can improve dental health

Using any kind of computer in a dental practice neatly divides itself into two compartments: use in the office, which is comparable to using a micro in any small business, and use for clinical records. This latter use involves a far wider concept than ‘ordinary’ business use as the software is highly specialised and, as will be described below, needs the use of combined graphics and text on the screen to be fully effective.

Before the advent of the microcomputer there was very little hard/software available for the dentist to be able to introduce computerisation into a dental practice.

What there was was in the nature of a large ‘mini’, complete with the necessity for an air-conditioned ‘cubicle’ for the CPU which used fixed/removable hard disk cartridges. This, of course, allowed a multiuser facility but in the context of a small dental practice was far too expensive to be cost-effective.

Minicomputers are still available for dental practices; they are smaller in size as well as being slightly cheaper in price, and the suites of software with these systems do a reasonable job of helping the dentist to run his practice. The argument about being cost-effective still applies and thus they are for the larger practice only.

The micros of the Apple/PET/Tandy variety (and this list is by no means exhaustive) have, of course, opened up the world of computerisation for the small business, and it should be realised that a dental practice is precisely that. Many of the available software packages for running such a business can be applied to a dental practice. The management of accounts can be dealt with in a standard manner, as can stock control; although a practice employing half a dozen people hardly needs payroll software!

What distinguishes the dental practice from a small business is the clinical aspect of treating patients and the paperwork that this generates. When examining patients a dentist records the clinical information derived from the teeth in a form consisting of various shapes to designate types of cavity, fillings present, teeth to be extracted, dentures present and a variety of other conditions. This pictorial representation of a mouth is easy to scan and assess and is an internationally standard method. To record this information in written form, although suitable for a standard database software package using routine file handling procedures, would be very long-winded and would mean abandoning the standard procedures used.

There is software available for use on micros which does do this graphic charting of the clinical conditions in a mouth and this is allied with space to write clinical notes of treatment to be done, or which has been done. This is often conjoined with a suite of programs which will price the work done, whether under the NHS or privately, and will produce bills for patients and carry out the usual reconciliation with payments, aged debt analysis and so on. The software will often include a facility for routine recall of patients at a standard time interval and this raises the other major aspect of the application of computerisation of a dental practice – the appointment book.

It is necessary to realise that anything other than the appointment book in a dental practice is capable of being replaced or renewed in the event of a complete disaster, eg, a fire. To take an extreme example, if the premises are totally destroyed one can set up a tent with a telephone line outside the front door and with a list of patients due one can reconstruct records and re-schedule appointments until the premises are fully functional again. Without this book a dentist might as well go home. Consequently a dentist has to consider very carefully whether to commit this vital aspect of his/her practice to an electronic form which may be subject to the vagaries of an irregular power supply, corruption of storage media and the sundry other faults which can occur. To back up one’s records every time a fresh appointment is made or one deleted from the ‘book’ would be counterproductive in terms of time even though it is essential if the possibility of either missing a vacant time slot or double-booking is to be avoided. An actual appointment book can be kept in a fire-proof safe for peace of mind.

In addition to this, the software available at present for this function will only display, at best, one day per VDU screen (some only half a day) per dentist. A good receptionist can keep a visual image in mind of the black spaces in an actual book and can turn a page to ‘bring up’ a whole week at a time much quicker than any software can on a screen.

To go back to the function of computerisation of clinical records, one has to realise that for this to be fully effective there has to be a terminal and screen in each surgery with central mass storage as well as a terminal, etc, at the front desk. This again raises the question of cost: even using micros for only two surgeries and reception on this basis with, say, 10Mb storage will put the cost towards the five-figure mark, which becomes very expensive in the context of a small dental practice. The actual storage figures for dental records with chartings for each patient may be in the range of 500-700 bytes per patient per course of treatment and this multiplied by approximately 3000 patients per dentist gives some idea of the basic storage needed to keep clinical records. Details of treatment have to be kept for at least two years after completing a course of treatment and this, allied with all the other office functions needed, suggests that the 10Mb mentioned above could be a conservative estimate for a practice containing three or more dentists.

The other main problem concerning dentists at the present time is the possible computerisation of the NHS claim form FP17. This is a complex form which has to be filled in accurately so the dentist can be paid by the NHS. It contains details of the patient; name, address, clinical charting grid, a minimum of seven different dates to be filled in and various other details. Software has been written to cope with this so it can be printed out after the data has been put in from the handwritten clinical notes. The problem with this is that the slightest change in the format of the grids, etc, on the FP17 would mean rewriting this software. A suggestion has been made that the central collating body for these forms could use ‘light pens’ to read any printed codes produced by any printer, enabling a dentist to use whatever internal record system is desired. This problem still has to be resolved and will depend on whatever change in method of remuneration of dentists may be applied in the future.

The only other main office function for which a computer is often used and not yet mentioned in connection with a dental practice is the use of word processing. This is not generally a great necessity in a dental practice. Recalling patients every six months is often a feature of a dental software package and would incorporate a print-out (hard copy) format.

In summation, one can state that the small system with a couple of disk drives, screen and printer (not necessarily of letter quality) with a good database software package at about £3000 is a viable proposition for even the single-handed practitioner. The limitation of use to office procedures only is still worthwhile, even solely on the basis of eliminating lots of pieces of paper. Clinical records require considerable mass storage, sophisticated software and even provision in the actual surgeries to accommodate the extra terminals needed.

First published in Personal Computer World, April 1983

Multiplan

Mike Liardet looks at Multiplan – Microsoft’s entry to the spreadsheet fray.

After releasing the Apple version of Visicalc about three years ago, Visicorp enjoyed at least 18 months completely unchallenged in the market for what has now become known as spreadsheet software. But in the last year and a half there has been a steady stream of Visicalc rivals arriving on the scene and, naturally, some of the established companies have been getting involved in this growth area.

Probably the best known of all the micro software companies, Microsoft’s pedigree goes right back to those prehistoric days of ‘core-store’, paper-tape and teletypes – 1975 in fact, when the first of a million microcomputer systems was equipped with a Microsoft Basic interpreter. Now Microsoft has augmented its own spreadsheet system: Multiplan. Will Multiplan further enhance Microsoft’s reputation for excellence? Will it be another Ford Edsel? (You should get this point if you have heard of a Ford Edsel and you definitely will if you haven’t!)

The first thing that strikes you when confronted with a copy of Multiplan is the packaging: Microsoft has obviously invested a lot of effort (and money as well, I am sure) in presenting its ‘new baby’ to maximum advantage. A heavy-duty transparent plastic case holds a substantial ring-bound manual, system disks, various leaflets and a few pieces of carefully positioned cardboard mouldings – simply there to mask out awkward gaps and present an uncluttered appearance through the transparent box. Readers who are concerned by such a flagrant wastage of the world’s resources on a mere piece of marketing-hype will doubtless be relieved to learn that you need not throw the box away after purchase – it readily converts into a sweet little bookstand to support your manual!

Anyway, underneath the packaging we eventually find the disks – my review copy was for the Apple II (DOS 3.3), but Multiplan is also available for The Apple III, CP/M systems and, of course, Microsoft’s MS-DOS. All versions are evidently functionally identical, with just a few pages at the start of the manual outlining any minor differences, so non-Apple owners should still bear with me! (I also had the opportunity to take a quick look at the MSDOS version on a Sirius, so have made occasional references to this, too. In particular, I have included benchmark results for the Sirius version, specifically to check out Multiplan’s performance with a new generation (8088) processor and all that extra memory capacity.)

Getting started

Getting started proved fairly easy – the ‘First Time’ instructions were not on page 1, where I like to see them, but a little bit of page-thumbing soon tracked them down. A bit of disk copying, data disk initialisation, and two or three minutes later I was faced with a reassuringly familiar display of a spreadsheet. The only hold-up in all this was to have a good chuckle at the latest piece of computer jargon, encountered in the instructions for seeking the system for optional (on the Apple) 80-column display mode: ‘Recable’ – to exchange 40-column video cable connection with 80-column!

The initial display is of the top left hand corner of the spreadsheet, showing seven spreadsheet columns and 20 rows, all completely blank. The remainder of the display is devoted to helpful prompts: the names of twenty different ‘commands’, a ‘what to do now’ message and status information, such as percentage of storage space remaining, current cursor position, etc. Both rows and columns are identified by numbers, unlike many systems which use the alphabet for column headings. The repercussions of this are fairly great, since whereas ‘Q99’ is unambiguously a reference to a specified cell, ‘1799’ clearly is not. Multiplan provides several alternatives for identifying cells, but the simplest is that they be written as ‘RyCx’ – eg, ‘R17C99’ – a little bit longer than ‘Q99’!

Moving around

Moving the cursor around the spreadsheet is very simple – single control-key hits (ie. simultaneously pressing ‘Control’ and one other key) move the cursor left, right, up and down, with the VDU screen window being ‘pulled along’ by the cursor if an attempt is made to move to a cell off the edge of the screen. Sensibly, the keys that achieve this movement are arranged in a diamond (on the Sirius the arrow keys are used) – easy to remember and easy to touch-type when you are looking at the screen. Further investigation reveals that there are also control-key hits to ‘home’ the cursor to the top left hand cell and to the bottom-right, and a ‘Go-to’ command where destination coordinates can be typed in, as well as a rapid scrolling facility where the cursor is moved several cells at one go.

Also of particular interest is a very powerful split-screen facility. The screen can be subdivided into display areas (called ‘windows’ in the manual), each displaying different parts of the spreadsheet, and the cursor can be quickly ‘jumped’ from one to the next. There are many possible uses for this: locking row and column headings for continual display, quick movement between different parts of the spreadsheet, and keeping totals or whatever continually in view when other parts of the spreadsheet are being modified. Moreover each window can be displayed with a nice surrounding border, and can also be ‘linked’ to another window so that columns or rows in both always line up correctly. If all this sounds a little confusing to the newcomer, then take heart. You can completely ignore the facility at first, but once you are ready for it, the chances are that however you want to lay-out your display then Multiplan will accommodate you.

Entering data

As with most spreadsheet systems, the ‘bread and butter’ activity centres on entering or changing numbers, titles and formulae. To achieve this, simply move the cursor to the cell to be changed and start typing whatever is required there. The only thing to watch out for is that text entry must be preceded by selecting ‘Alpha’ mode (simply press ‘A’ before typing the text) otherwise the chances are Multiplan will assume you are entering a command – occasionally disastrous. For example, a sensible abbreviation for Total-Costs-Yacht could be ‘TCY’. Enter this without pressing ‘A’ and Multiplan does a ‘Transfer-Clear-Yes’ wiping out the entire spreadsheet! Don’t believe it could happen? A PCW editor (I’ll spare his blushes) did it! Well, it probably wasn’t a yacht, but a yo-yo or a yard-of-ale or something…

The formulae themselves can be built up using a wide range of maths and other functions, including trig, standard deviation, string concatenation, logical and table look-up, etc. The notation used is the classic keyboard version of school maths notation, easily learned by anyone not already familiar with it. As we have already mentioned, formula references to cells require an RyCx’ notation – eg, the formula to add the first 2 cells on the first row could be written as ‘R1C1 + R1C2’. However, there is a little trap lurking for experienced spreadsheet users – the replication facility does no formula adjustment whatsoever. Thus, if the above formula was located at R1C3, and then copied to 99 cells below, each and every copy would be ‘R1C1 + R1C2’ and the expected Column 3 = Column 1 + Column 2 would not be achieved. It turns out that the original formula, quite correct if no replication is envisaged, should be ‘RC[-2| + RC[-1)’, meaning ‘add cell in current row two columns back, to one in current row one column back’. Now, wherever this formula is located, it will add together the two previous values on the row, and in particular, if replicated right down column 3 it will do the column sum correctly.

If typing ‘RC[-2] + RC[-1]’ seems like a bit of a fingerful (tactile equivalent of mouthful) then Multiplan to the rescue! Instead of working out ‘RC[-2]’, etc, simply use cursor moves in mid-formula entry and Multiplan will type in the formula for you. In the above example only the ‘+’ need be entered from the keyboard, the rest of the formula being built up by using the cursor to point to the cells to be referenced.

It is also possible to refer to cells by their row or column name and thus build up formulae like ‘profit = sales – costs’. Since (a) this is immediately comprehensible and (b) always replicates correctly, the extra typing involved is well worth it!

In conclusion, I must say that I did not greatly like Multiplan’s methodology for referencing cells. It should be noted that cell references occur not only in formulae, but are also required by the majority of commands (see below), so a major part of one’s time at the keyboard is spent using them. In fairness I must point out that (a) my previous spreadsheet has been with the Visicalc style of cell-reference and (b) that Multiplan has some compensations for this minor irritation with some excellent other features and facilities.

Commands

Thus far, we have looked at Multiplan’s basic essential facilities, but of course there are many other, typically more peripheral (in both senses!), functions needed to provide a comprehensive spreadsheet system. These extra functions are provided for by Multiplan commands, and invoked by selection from a command-menu.

Actually, in passing, we have already touched upon four commands provided by Multiplan – ‘Go-to’ cell, ‘Alpha’ for entering text, ‘Copy’ for replicating cells, and ‘Window’ for the split-screen facility. There are in fact 20 in all, each starting with a different letter of the alphabet, and all permanently displayed at the bottom of the screen. Bearing in mind that there were only six letters of the alphabet to spare, the implementers have done a pretty good job of choosing 20 sensible names – probably the worst one is ‘Alpha’ (it couldn’t be ‘Text’ because that clashes with ‘Transfer’ and ‘Transfer’ couldn’t be ‘File’, ‘Storage’ or ‘Disk’ because F, S and D are in use, etc).

Anyway, in the unlikely event that a command’s meaning is unknown, or in the more probable event that the precise method of usage is unclear, there is an excellent ‘Help’ facility available. Basically the list of command names has its own cursor, which can be shifted along by pushing the space bar. Commands can be selected by moving the command-cursor then pushing ‘Return’ (or by just typing the command’s first letter – much quicker). However, if ‘?’ is hit instead of ‘Return’ the spreadsheet screen is replaced with a ‘help’ screen for the currently indicated command. Moreover the information is not just a few cryptic instructions, but a fairly comprehensive run-down which in some instances extends to several pages. By the way, all the help-screen information is read from disk when needed, and does not affect the precious memory allocation for the spreadsheet itself.

To get some idea of the command facilities available, here is a quick rundown of all 20:

  • Enables text to be entered at the current cursor position.
  • Blanks out one or more cells. Contents are blanked out, but display format assigned to cell is unchanged. Not the same as Delete since, in particular, the following rows or columns are not shifted.
  • Copies cells from one place to another (ie, replication). Relative-copy is not possible (see text above) – must do absolute copy of relative formula!
  • Deletes a row or column of cells, moving all subsequent rows/columns back by one.
  • Instead of correcting a long formula by retyping from scratch, this command can be used to apply the changes quickly.
  • Numerous different display formats are possible: different column widths, centre, left, right justify, scientific, integer, financial, primitive bar graph, and more besides! As an extra convenience, a default format can be specified, assigning the format you most expect to use to all cells not explicitly reformatted to something else.
  • Go to cell specified by its name or coordinates.
  • Gives general help information, not covered by the help-screens, for each specific command.
  • Inserts a blank row or column, moving all subsequent rows/columns along by one.
  • Locks or unlocks specified cells. Can permanently lock all formulae – useful for turnkey systems.
  • Moves a row or column to between two other row/columns.
  • Enables a cell or group of cells to be given a user-supplied name. This name can be used in formulae, and also by the ‘Goto’ command. It saves confusion if the name here is the same as the visible title.
  • Used to set basic operational features, eg, switch off auto-recalculation or audible error beeps. The former is very useful when the spreadsheet is getting fairly full and every change takes several seconds – not to be registered on the screen, but for its effects to permeate through the system. The latter is absolutely priceless if you work at home and your family ‘can’t stand that incessant cheeping’ (to quote my good lady).
  • Can print to printer or disk file. Option to print the formulae as well as the calculated values. This is useful for documenting or debugging the model. It’s also possible to print selected areas.
  • Finish – back to resident operating system (eg, CP/M, MS-DOS, etc).
  • Sorts calculated or entered numbers or text by suitably shuffling rows.
  • Load, save, delete and other disk file operations. Of particular note: Multiplan can read Visicalc data files, or read/write files in a well-documented external interchange format, as well as using its own internal disk format. As it can also print to disk, it is extremely versatile in its file-handling.
  • Can optionally be used for entering formulae or numbers.
  • Split screen facility.
  • Used to read in answers calculated by one spreadsheet as raw input data for another. Can be used for ‘consolidation’.

Documentation

The documentation is comprehensive, clear and well-written. The bulk of it is in a stout ring-bound manual (minor niggle – the rings are not circular and tend to snag the pages when you are turning them quickly). It has obviously been put together with the sort of thoroughness we would expect from Microsoft, right from the Contents page at the front to the Index at the back. The basic material provided is:

  • System-specific instructions. How to create your working disks under your particular operating system.
  • Organised as seven lessons. Gives you key by key instructions, starting with simple cursor moves in lesson one through to multiple work-sheets at the end. Well illustrated.
  • In alphabetical order, everything you need to know about the command, key-strokes and formula-functions. Also includes a list of all system messages, together with advice on what to do when you encounter them.
  • Extra helpful information, including a glossary and notes for Visicalc experts – a nice touch!
  • Quick Reference Guide. A separate pocket book (16 pages), being a condensation of the reference section in the main manual.
  • Help Screens. Comprehensive instructions on-screen for every command and a few of the other facilities.
  • With this breadth of documentation, there should be something to please all levels of user. Complete beginners can try the tutorial. Experts will probably just use the quick reference guide or help-screens and everyone can make good use of the comprehensive index.

Sirius slip-up

Having given the Apple version a thorough work-over, I arranged a joyride on somebody else’s Sirius. The article was nearly complete – I just needed to pencil in the Sirius Benchmark times and then off to Mustique for yet another three weeks.

First problem: Sirius version of Multiplan manual temporarily mislaid. Well, I should know the system well enough by now. So, in preparation for Benchmark 1, I quickly set up the first 12 columns by 200 rows of the spreadsheet. (Readers familiar with the benchtests will know that this results in a display of 1.. 12 in the first row, 13. . 24 in the second, etc.)

Next I needed to set up column 13, each cell in it being the sum of the previous 12 in the row. Easy! Just use the row-sum function in column 13 of row 1, and then copy it down to all cells below it. Unfortunately I couldn’t remember the correct syntax for using it. Anyway, after experimentation I found that ‘SUM(C1:C12)’ at least did not give a formula error message, but it did seem to be displaying the wrong answer. Okay – time to copy it. Well, much disk-whirring and clanking, then watch the calculation count-down on the VDU display. 45 minutes later; I’m still waiting and the disk is still whirring and clanking and countdown’s still not finished – I’m frightened to switch off in case I corrupt the disk (it’s not mine, anyway) – can’t stop it at the keyboard, etc. Anyway it took about 50 frustrating minutes.

So, what went wrong? Well, basically a minor slip-up in my use of the SUM formula. I eventually got it right (by using a help-screen, what else?): ‘SUM(RC[-12]:RC[-1])’ and the whole test was over in under a minute. The formula I had originally used did not add the row up, but calculated the whole 12 x 200 array of numbers, and of course this formula was then copied 200 times down the column – a bit of a hefty number-crunch!

Anyway, the moral of this story is: make a good effort to learn Multiplan’s cell referencing – it could save you a long wait!

Conclusion

We have taken a fairly fast swoop right through the major facilities and features of Multiplan; so fast that some very valuable features, not generally available in mere state-of-the-art spreadsheet systems, may have gone unnoticed. Just for the record.

Multiplan gives you:

  • If you need to sort columns of figures or text then it is impossible to do this without a ‘Sort’ command.
  • Multiple worksheets. Results from one worksheet can be communicated to another, useful for consolidation.
  • Multiple split-screens. Very flexible facility to design VDU screen display of spreadsheet.
  • Flexible file handling. In particular data interchange with other software is feasible, and Visicalc data files can be read (but not written! – no doubt Microsoft doesn’t want to encourage users to migrate that way!).
  • Available on 16-bit microprocessor (8088/6). The new 16-bit processors can handle a lot more memory, and spreadsheet systems which have been properly installed on them can use this extra memory for setting up bigger spreadsheets (see Benchmarks).
  • Comprehensive help-screens. In addition to these. Multiplan also provides more mundane, but by no means universally available, facilities – such as cell references by names, formula protection, formula printout, print to disk and formula editing.

Certainly Multiplan has a lot of facilities to offer, but what is it like to use? Well some minor complaints here: the row/column numbering scheme increases the amount of typing for formulae. You have to consider replication consequences when you enter a formula, rather than when you do the replication, you have to choose the ‘Alpha’ command before you enter text (okay, it’s only one extra character, but most other spreadsheet systems don’t do it this way). To balance these minor grumbles are comprehensive error messages, and understandable prompts for all input.

So finally, my advice to spreadsheetless owners of Apples, CP/M or MS-DOS systems, or to anyone looking for an upgrade: put it near the top of your list!

Benchmarks and other measurements

These tests were run on an Apple II system with 64k of RAM (which is in fact mandatory) and an 80-column display card (which is optional). Available space for the spreadsheet itself amounted to 21k. Figures are also included for the Sirius (with 128k of RAM, and theoretically extendable to 800k+), running MS-DOS and allowing greater storage space for the spreadsheet. Where the Sirius figures are different they are appended in parentheses after the Apple figures.

Incidentally, a Sirius retails for around £2500, and the nearest equivalent Apple system (but with lower disk capacity, half the RAM, 8-bit processor) would be around £1750.

  • Spreadsheet size: 63 columns wide by 255 rows.
  • Numeric precision: 14 digits.
  • Max column width: 32 characters.

The benchmark tests are described in ‘Which Spreadsheet’, PCW Feb 1983.

Benchmark 1: (a) max rows accommodated: 95 (235); (b) recalculation time: 60 (55) seconds – ie, 1.5 (4) rows per second: (c) recalculation time: 60 (55) seconds; (d) vertical scrolling: 6 (6) rows per second; horizontal scrolling: 4 (4) columns per second.

Benchmarks 2: max rows of text accommodated: 190 (Sirius not tested).

Benchmark 3: max rows of numbers accommodated: 190 (Sirius not tested).

Price: Around £150.

Checklist

Documentation: 400+ pages, contents, tutorial, reference, index, quick reference and help-screens. Well-illustrated. Excellent.

User-friendliness: Consistent and easy to use — cell-referencing can be a little tricky!

Error-handling: 20+ error messages. Erroneous calculations (eg, zero-divides) displayed as special error values.

Facilities: Arithmetic and other functions: +, -, *, /, %, string operations, logic, descriptive statistics, trig, logs, look-up and more besides!

Configuration: version tested easily configured for different types of Apple screen.

Graphics: a let-down compared with the other facilities!

Interface to other software: specifically can read Visicalc files, and print to disk. Can also be interfaced to other software using data interchange format (requires programming skills to do this).

Spreadsheet overlays: yes – can do consolidation or merge information into existing spreadsheet.

Turnkey: Apple version is turnkey with all disk formatting, copying, etc, achievable without recourse to Apple DOS.

Insertion, deletion and replication: yes.

Display flexibility: just about everything you could possibly want. Excellent.

Protected cells: yes.

Formula printout: yes.

Formula editing: yes.

Automatic/manual recalculation: yes.

Out of memory: memory left permanently displayed. Recovers correctly when it runs out of memory.

Long jumps: can jump directly to any specified cell.

Sorts, searching and logic: yes.

First published in Personal Computer World magazine, April 1983

Data Management to the Rescue?

Kathy Lang checks out a flexible new CP/M package.

Regular readers will know that many of the packages I’ve reviewed in this series have particular areas of strength that make them well suited to certain areas of data management. This month’s offering, a British package called Rescue, which comes from Microcomputer Business Systems and runs under CP/M, is a general-purpose, menu driven data management package which has much in common with others in this field. But it has unusually flexible provision for different types of information, and its data validation is among the best I’ve seen.

Rescue comes in three parts: the first deals with configuring the system for your computer, and is not needed again unless you make major changes. The second part covers the creation and amendment of the data files, and of the screen and report formats, while the third permits record amendment and display. This separation makes it easy to set up a system in which most users have access to the information in the files, but cannot change the format of those files or interfere with any provision for protecting parts of the data for security reasons.

Data is stored in fixed-length records in Rescue, but some ingenious methods are used to keep data storage to a minimum – I’ll say more about that later. Once you’ve set up a record format, you can still add fields to the end of the records, but you can’t change the sizes of existing fields unless you’ve made provision for that in advance. (MBS is apparently about to release an option to permit more radical changes to existing files, but it isn’t available yet). You can access the records in two ways. Individual fields may be used as keys, and any one of them used to access a particular record for display and/or editing. You can also select subsets of the data by setting up a set of selection rules, which are used to extract a set of records for browsing on the screen or for printing. You can set up as many screen and report definitions as you please for any set of data; these definitions need describe only a few fields in a record if necessary, and any or all of these descriptions may be password protected.

Rescue is used through menus, but users can set up their own menus through quite simple procedures. Thus you can set up a series of operations to be activated by one menu option. You can’t at present access one file from another, so that the current version of Rescue does not have true database capabilities.

Constraints

Figure 1 shows the major constraints imposed by Rescue. The maximum record size of 1024 is the same as several others I’ve reviewed, but Rescue’s dictionary capability makes it more economical of data storage than many.

Some people will find the limitation of 60 characters in a field more serious. I haven’t included in the figure a full list of the field types allowed, as it is very lengthy. Virtually any kind of data format can be expressed with one of the field types provided. I’ll say more about them in the next section.

File creation

The process of file creation is shown in Figure 2, which is a ‘road map’ of all the menus associated with the data definition part of Rescue.

The first stage in file creation involves setting up a data description file, specifying the basic format of each record and the keys it will have. At this stage you must assign a data type to each field. There are four main groups of data alphanumeric, numeric, date, and dictionary. There are several forms of data type in each group; for instance, character data may be just that and contain any valid ASCII character, or they may be alphanumeric, in which case they may only contain letters or digits and any attempt to enter invalid data will be rejected by the system. There is quite a variety of numeric fields, too, including money (sterling). You can specify that a field is to conform to a mask, to ensure that such items as account references, which often have prescribed formats, are entered in a valid form.

Probably the most unusual type of data is the dictionary field, which permits the person entering data to include only certain values. There are two kinds of dictionary field; a short form, which permits up to 29 characters in total to be used for each field, and a long form, which allows up to 255 entries, each of up to 60 characters. The latter are shared among all the fields in the file, so supposing one has a series of questions each with the same range of answers – for example, answers ranging from Poor to Excellent in a market research survey – you only need one dictionary entry for all the fields to refer to. Each response takes up only one character in the record in the data file for either type of dictionary, so the method is really a way of combining coding with captions for codes.

Every field within the record must also fall into one of four entry categories: mandatory (ie, the field must always have a value), optional (the field may be empty), calculated or display-only. Calculated fields are derived from calculations on constants or on other fields in the same record. Display-only fields are provided so that for certain modes of access fields can be shown but not altered – account numbers might for instance be protected in this way. Any field in a record may also be linked to others in a number of ways.

Direct linkage provides for situations where some fields only have values if another field – said to be the controlling field – has a certain value. For instance, details about a property might say if the property were freehold or leasehold but only if it were leasehold would it be sensible to ask for the life of the lease and the annual charge. This approach can also be used to deal with records with lists of information; you might want to store the names of all a person’s children where some people might have as many as six, without asking six questions about childless people. Most packages expect you at least to hit one key for each question when entering data from the keyboard but with the Rescue approach entry can be more finely tuned to stop
prompting for answers if they are not needed.

During file definition you must also specify the fields which are to be used as keys. Rescue treats the key field which is physically nearest to the beginning of the record as the main key, in that you have to ask specifically for other keys when you come to access the file; so it can save a little time to think about what order to store fields in the record. Up to 10 fields may be defined as key fields. Keys may be either unique or duplicate, and Rescue checks when supposedly unique key values are entered. All the key fields are referenced from a single index, which is automatically kept up to date when data is added or amended.

The next step is to define screen and print formats for the records; you can have as many of these as you wish, and each may describe only parts of the record – for instance, to prevent confidential information being seen by everyone. Next, you tell Rescue to set up an empty data file and structure the index file, and finally you construct any custom-defined menus you will need If you do specify more than one screen or report definition, then you will have to do some customisation of the menus in order to use the alternative formats, but this is quite a straightforward process.

Input and editing

The provisions for data validation given by the dictionary facilities, by the variety of data types and by the range checking which can also be set up at file definition time, are extremely powerful – it’s always possible to get the data wrong in a logical sense, but Rescue makes it quite hard to get it wrong in any other sense. That said I did find the mechanics of correcting data a bit clumsy; if you’ve made a mistake and go back to edit a record you can say where in the record you want the editing to begin but from there you must work sequentially through – you can’t work back up the screen either when entering or editing data. Since the program requires you to have a terminal which can move the cursor left and right, it seems a bit strange not to utilise cursor movement up as well, since no terminal is likely to have horizontal movement but not vertical…

When you retrieve records for amendment, you do so by specifying a particular key value; you can specify the use of any key, but you have to get the value of the first four or five characters exactly right (except that Rescue is ‘case-blind’ in this situation, so it will for instance match Smith and smith). Even when matching exactly on a key value you may retrieve more than one record, as duplicate keys are allowed. But searching for field values within ranges is only possible when you want to look at records, not when you want to change them.

Screen display

I said that you can have several definitions for a single file, so that records can be displayed on the screen in different ways for different users or applications. These screen definitions can be created by copying existing definitions and amending them, but I couldn’t find a way to see what definitions I already had except by going out to CP/M and using the Directory command. Screen layout is specified by giving row and column coordinates for each field you want to display, which I found much more difficult to use than the ‘paint-a-screen’ approach which has become fairly common. The coordinate approach also makes it more difficult to amend the layout, though Rescue does have one provision to make this a little easier by letting you specify a re-ordering of the display without changing the absolute coordinates.

The screen layouts are set up in the ‘definition’ part of Rescue. However, they are invoked from the main part of Rescue, through executing one of the options in the menus shown in Figure 3. Display can be of records specified either by matching one key, or by selection using the selection and extraction procedure which is described later.

Reporting

Rescue uses the same mechanism for printed reports as for screen display, so both are strictly record based. The only provision for aggregated information is totalling of numeric fields. It is possible to force page-breaks when values of particular fields change, but subtotalling is not provided. There is, however, a very flexible facility to interface with Wordstar and Mail/Merge, so it is easy to use them in combination with Rescue to write circular letters and concoct sets of standard paragraphs.

Selection

Rescue provides the ability to select parts of the data file for browsing, printing or further selection. The main method of doing this is to set up a set of selection rules in a file, and then to apply these to the data file to produce another file containing the selected records. The selection rules are very flexible: you have all the usual comparison operators (less than/greater than/equal to/not equal to) and data values can be compared with constants or with the values of other fields in the same record. Rules can be combined to provide ANDing and ORing within and between fields, and these combination facilities together with the NOT operator make it possible to select virtually any combination of values you could need. However, personally I don’t like the need to set up rules in a file, as it is rather cumbersome in practice; if you are using the standard facilities menus you must go to the ‘Maintain Rules’ menu (at the third level of menus), create the rules, then go back to the first level of menus and down to the third level ‘Extract and Sort’ menu to actually extract the records you need. Finally (from the same Extract menu) you can display or print the records that have been found. This provides a sharp contrast to the command language approach, in which one command will extract your records and a second at the same level will display them. However, you could tune the menus in Rescue to avoid some of this ponderousness, so it’s better in that sense than menu systems which you can’t adapt.

While actually comparing fields, upper and lower case letters are regarded as equivalent. You can use wild codes: ? will match any one character, * will match one or more characters. For dictionary fields, the order for comparison purposes is the order in the dictionary, so if you have a set of answers with Poor as the first and Excellent as the last Poor will be regarded as ‘less than’ Excellent even though P comes after E in the alphabet. This is usually what you want and with much coded data would be a very valuable feature.

Sorting

Rescue can sort a data file on up to five fields in one operation; the process is similar to selection and you can also combine selection and sorting to give a sorted extract file. Sorting is either in ascending or descending order, as with selection dictionary fields sort in their dictionary order (Poor before Excellent) rather than in alphabetical or numeric order. In addition ordinary character fields can be given a sort value which is different from their simple alphabetical order. This could be particularly useful where you had fields such as book titles which often have prefix words such as A or The, which you want to ignore for sorting purposes but wish to include as part of the field for printing (In most packages these prefix words must occupy a separate field, which will be empty for titles without a prefix word.)

Calculations

The calculation facilities in Rescue are quite powerful in the input phase, and practically non-existent after that. When you set up a data definition file, you can specify that a field is to be calculated from constants, or from combinations of other fields (including dictionary fields) in the same record. All the usual arithmetic operators are available. After input the only calculation you can request is totalling on printed reports; this is activated by requesting totalling of a field when a description file is set up. Up to 10 fields in any one description file may be set to be totalled.

Security

Protection in Rescue is of two kinds. It is possible to take the programs used in the Define stage off the run-time disk, so that the ordinary user can use file definitions and screen and report formats, but not amend them. At a more detailed level, password protection can be provided for particular data files, for individual description files (so that a user can be given access only to part of the data in a file) or for particular menu items in custom built menus (so that some users may have access to some functions but not others, while other users have greater facilities, but all within one menu). This is a flexible and powerful scheme, and should provide for most needs.

Stability and reliability

I didn’t have any problems over reliability with my use of Rescue. As to stability, new versions of Rescue, which are ‘cost options’, are intended to be compatible with existing versions. New features in the pipeline include a version for MS-DOS and a multi-user version.

Tailoring

As usual, the first task is to tailor Rescue for your particular terminal. This appeared quite straightforward (although, as is the common bad practice, you can’t be sure the tailoring has worked until you actually run the main Rescue suite). However, I had one misunderstanding which I never managed to sort out; this resulted in repeated prompts being printed on the same line as the error messages, which were thereby overlaid so that I couldn’t read the error message. I wasn’t able to discover whether this was an error in the software, the documentation or my interpretation of them and my Sirius manual, but it hasn’t happened to me before. While tailoring for the terminal, you can tell Rescue about cursor movement left and right but not about which keys move the cursor up and down, so much potential editing flexibility is lost.

Once into Rescue, the main tailoring facility is the ability to set up sequences of activities on custom-defined menus. This gets round some of the inflexibilities associated with menu-driven systems, and I found the approach quite easy to use.

Relations with outside

Rescue can write files in standard ASCII characters, using the ‘comma delimited’ format required by many other packages including specifically Wordstar’s Mail-Merge option. Thus you can set up files of information which you want included in circular letters or standard paragraphs, and then fire them off to Wordstar or another similar package.

Within Rescue you can include on a menu the ability to run another program, so it would be possible to tailor a menu to carry out a selection/printing sequence of this kind, called by Rescue ‘record processing’, without the user having to go back to CP/M. You can’t at the moment read external files of ASCII records into Rescue, though there is a menu option to do this already shown, which I’m told will be implemented in the very near future.

User image: software

Once again, your overall reaction to Rescue will be governed by whether you like menu-driven packages or not. I found the ability to tailor menus to provide facilities oriented to particular requirements a big help in mitigating the inflexibilities of menus. However, most users are likely to follow the well-established principle of ‘satisficing (a word coined by Herbert Simon the psycho-economist to describe the tendency to accept adequate or satisfactory results rather than go for the best possible) and only set up extra menus when they absolutely have to, for instance to access alternative screen layouts. So I suspect that mostly people will use the rather cumbersome standard menu facilities. I also had a rather mixed reaction to the complete separation of description of and access to the data files. Within an organisation which has a database administrator (who might simply be the boss in a small business) this could be a useful separation for security reasons, but it would be less helpful where the same person organises the data files and puts information into them, perhaps in a small office, one person business, etc.

Within the package itself, I as usual found some goodies and some nasties. The progress through the menus was orderly and logical and was made straightforward by the provision of the two ‘road maps’ which I show as Figures 2 and 3. The process of prompting was easy to understand. It would have been even easier if, when a question has a default response, this was displayed before the question is posed – in many cases the default is not shown even after you’ve accepted it unless you go back and edit the record concerned. Allowing the use of identifiable abbreviations, both for field names and for data values, is sensible.

I didn’t like the use of row and column coordinates when formatting screen displays and printed reports, especially as there is no default format so you always have to supply one. The ‘paint-a-screen’ approach is much easier in general than coordinate specification and if this is not supplied then there should at least be a default format with records displayed one field per line starting at the left of the screen or paper. I also found the inability to move back within a record when editing a real nuisance.

Documentation

The manual is basically a reference document but written in so much detail that it could be used to teach yourself about the package if you were reasonably familiar with data management terminology. However, the amount of detail makes it rather difficult to find your way around. Two goodies help a little in this: the use of emphasis within the text to call the readers attention to the most important parts of each section, and the printing of chapter headings right-aligned on each page (a real help to browsing at a general level). But the chapter names didn’t always make it easy to guess where a particular feature would be described, and since there was neither a detailed table of contents relating to each chapter nor an index, it was very hard to get from ‘now I’ve seen something about that feature somewhere’ to the exact part of the manual in question. Part of the remedy is close at hand, since if the ‘road maps’ (which perform most of the functions of a reference card) were annotated with the numbers of the sections documenting each menu item, readers would find it very much easier to locate the particular piece of information they need fast (As this article went to press, MBS issued an index for the manual, which should help.)

The other problem I had was that while each feature is documented in detail with examples of the particular feature, there are no examples of the display or use of groups of features. For instance, all the features of data entry are described in turn, but there is no figure showing how data definitions are displayed on the screen. Nothing bolsters a user’s confidence like some complete examples shown in real screen pictures!

I can’t resist ending this section by awarding MBS second prize so far in this year’s contest for manual typo errors, with ‘Data Validification’.

Costs and overheads

Rescue costs £295, and is available from MBS. To be realistic, you would need a disk system with the regular double-sided, double-density capacity of 370 Kbytes per drive on a two-drive floppy disk system, to enable you to have all the Rescue software on one disk drive and use the other for data I found the system very slow in loading individual program modules, which seemed to happen whenever I changed from one sub-menu to another. I was told that this was specific to the Sirius-Z80 card method of disk access, but I haven’t noticed the problem with other packages I’ve used. The times for actually running the Benchtests are shown in Figure 4. (Details of the tests were given in PCW December 1982.)

Conclusions

Rescue provides data management facilities through individual files. Data description facilities are very powerful. Rescue provides a variety of data types and validation features more extensive than any I have found before. These features also help to make Rescue much more economical on data storage than is usual in programs which use fixed length records. You can select and sort the data to provide pretty well any required subset but the process is rather cumbersome. Screen and report formats can be varied according to the needs of particular users, which makes it straightforward to protect particular data items; you can also permit users access only to certain Rescue features. Screen and report formats are described in a rather rigid way, and there are no default formats for easy initial use.

On the other hand, the ability to send data to and run Wordstars Mail-Merge option from within Rescue could be very valuable in some environments. Apart from the calculation features on data entry, the only calculating power within the package is the ability to total particular fields. The system is menu-driven, which can be ponderous in use, but you can if you wish design your own menus to mitigate this disadvantage to some extent. Rescue is in the main a single-file system – you cannot reference one file through data values in another. Provided this limitation is not a problem, you would find Rescue worth investigating, particularly if the variety of data types and the extensive data validation would be beneficial in your application.

Fig.1. Constraints  
Max no. files in one menu structure 20
Max file size CP/M limit or disk size, whichever is smaller
Max no. records 32760
Max size record 1024 characters (but good data compression methods)
Max no. fields 100
Max field size 60 characters, 14 digits
Max no. keyfields 10
Field types See text – several varieties of character, numeric, date (day/month/year), monetary (sterling), dictionary

Figure_002

Fig.2. ‘Roadmap’ of menus

Figure_003

Fig.3. Menu options

Fig.4. Benchmark times
BM1 Time to add 1 new field to each of 1000 records Setup time
BM2 Time to add 50 records interactively Scrolling time
BM3 Time to add 50 records “in a batch” NA
BM4 Time to access 50 records from 1000 sequentially on 25-character field 1 min 20 secs
BM5 Time to access 50 records from 1000 by index on 25-character field NA* (1-3 secs)
BM6 Time to index 1000 records on 25-character field 12 mins
BM7 Time to sort 1000 records on 5-character field 4 mins 10 secs
BM8 Time to calculate on 1 field per record and store result in record NA
BM9 Time to total 3 fields over 1000 records NA yet
BM10 Time to import a file of 1000 records NA yet
Note: NA=Not available. NA*=Not available as tested – key must match exactly.

 First published in Personal Computer magazine, April 1983

Crash Course in Spreadsheets

TheSpreadsheet001

Pete Galliard tallies the Spectrum-based Spreadsheet package against VisiCalc and Supercalc

Microl’s spreadsheet package for the Sinclair Spectrum is cheap, especially compared to VisiCalc and Supercalc – its big brothers on the bigger micros. And since the Spectrum is so portable, it’s practical to carry it around in your briefcase to the office, home or a hotel, and just plug into a TV set.

Features

The Microl Spreadsheet lets you SAVE models you have created along with the program itself. There is a CALCULATE command, which allows recalculation of the whole model. The REPLICATE command allows calculation rules to be reproduced over different parts of the spreadsheet. There’s also the option to modify those calculation rules, if you need to do so.

You can make changes to format, such as the number of decimal places, and it is possible to alter the widths of columns. Although you can display only four columns at one time, there is a jump facility to let you move the window to any part of the spreadsheet you wish. You can enter text and numbers into the cells, and all the standard arithmetic rules can be used.

There are also quite a few features not there. You cannot:-

  • split the screen to give two independent windows on the spreadsheet;
  • overlay data from one spreadsheet to another;
  • move, insert or delete specific columns or rows;
  • search for a particular number;
  • protect particular cells from accidental changes or sabotage.

Presentation

The package comes on cassette, along with a simple 15-page manual. Microl says the manual is being updated to include extra information on how to design effective models.

Getting started

It takes about three minutes to LOAD the package from cassette. SAVEing and re-LOADing each model takes about the same time.

If you’re new to spreadsheets, expect to spend an hour or two learning how to use them. The knack is fairly easy to pick up, especially if you are used to playing with numbers. The layout itself is identical to that used in larger spreadsheets.

The commands are easy to use – they are simple, reasonably memorable, and consist of single-letter or single key commands. Most are the initial letter of the action you wish to perform, and all are set out in a single long list in the manual.

One of the most annoying problems with this package is the extremely slow response when moving beyond the limit of the window. Program crashes are also frequent and easy to cause.

There are no DELETE, INSERT and MOVE commands, and this reduces the package’s scope. Aligning numbers with decimal positions is also a problem.

I used the package to build a budget model for testing, and I found that when I entered a whole number of pounds, with zero pence, the layout ended up looking confusing. The program right-justified it so that the pounds ended up in the pence column. You would have to define a different local format to cope with those cells affected.

If you want good-looking reports on your screen, you will need to spend a good deal of time formatting it. But if you can tolerate truncated titles and headings, and just focus on the numbers, the model can be built up quickly.

When the window passes beyond the nearby range of five columns or 20 rows, there is a delay of about ten seconds. I carried out a benchmark test by building a model of 26 columns and 31 rows and filling the whole matrix to capacity with numbers seven digits long. When the matrix was recalculated I found it took six minutes to complete. I tried recalculations with decimal numbers and text information, and got similar results.

The size of the model you can create is limited. The package comes set up with a default model size of 26 columns and 31 rows. The maximum number of columns remains 26, but you can extend the number of rows to 99, if memory space allows.

This package’s reaction to virtually every misdemeanour is to crash. It crashes if you use invalid expressions or command keys, long calculation rules, and if you reach the limit of memory size. Recovery is pretty straightforward and the data is not lost as all that happens is it dives into Spectrum Basic. But program crashes resulting from typing errors are irritating.

Verdict

Overall, I found this product fair value for money. I had to fault it on reliability, and the performance really was too slow on larger models and when the window was moved, not surprisingly since the package is written in Basic. If you have a Spectrum and are prepared to live with those weaknesses, you will probably find plenty of uses for Spreadsheet.

Rating

  • Features – 3
  • Documentation – 3
  • Performance – 2
  • Usability -3
  • Reliability – 2
  • Overall value – 3

Details

  • Name – The Spreadsheet
  • Application – Spreadsheet
  • System – ZX Spectrum, 48K
  • Price – £9.95
  • Publisher – Microl
  • Format – Cassette
  • Language – Basic

Image by Kieren Phelps

First published in Personal Computer News magazine, 25th March 1983

Smartmodem 1200 and Smartcom II

Hayes001

Although modem users in the UK will be familiar with Hayes protocols, Hayes’ products are still relatively unknown here. Peter Tootill looks at the Smartmodem 1200 and Smartcom II, a terminal program package for Hayes’ or Hayes-compatible modems.

Hayes is a new name in the UK, but will be familiar to anyone who has come into contact with the US telecomputing scene. Hayes was one of the pioneers of the ‘intelligent’ modem – that is, one that has a built-in microprocessor and can respond to commands from a computer. The command system that Hayes devised to control its modem has been followed by other manufacturers, and now Hayes protocols are the standard for intelligent modems and software designed to be used with them.

The demand for Hayes-compatible modems has come with software such as Symphony with its built-in communications features which allow the user to dial numbers stored in its database files. Hayes is making a concerted effort to push into the UK modem market and is not only working through a distributor, but has set up a separate company run, initially, by US staff. The company’s three introductory products are: a modem (Smartmodem 1200); a terminal program (Smartcom II); and a database package called ‘Please’. In this review I’ll look at the first two.

Smartmodem 1200

The Smartmodem 1200 is a single-standard V22 (1200 bits/sec full duplex) type. It is a very smart-looking modem, measuring only 5.5in x 9.5in x 1.5in, and has an external power supply. The UK version of the very popular US Smartmodem 1200 has lost its 300 bits/sec capability and gained BABT approval. The front panel carries eight LED indicators for transmit and receive data, autoanswer on, terminal ready, modem ready, carrier, off hook and high speed. The last one seems to be a hangover from the US version; it indicates that the modem is working at its highest speed – which in this case is its only speed, so it is rather superfluous. The front panel is removable, giving access to a row of 10 switches which allow you to configure various modem parameters such as auto-answer, how the DTR and CD lines operate, and so on. The rear panel has a standard 25-way, RS232 connector, an on/off switch, a socket for the external power supply, and the telephone cord with a normal BT plug on the end. There is no socket to plug a telephone into, so you will need a double adaptor if you require a handset on the same line. The modem’s case is made from sturdy aluminium and plastic.

Removing a couple of screws allows the modem’s PCB to slide out. Inside, the modem is of the same high quality as the exterior.

The modem supports the basic Hayes command set – it is, of course, Hayes-compatible (not all Hayes-compatible modems are fully Hayes-compatible – just as not all IBM-compatibles are completely compatible) and should work with any Hayes software that doesn’t expect the extended command set of the Smartmodem 2400 (a V22/22bis modem soon to be launched in the UK). It doesn’t have a number store, but as most smart terminal programs have telephone directories built-in, this is not-a significant omission.

The Smartmodem 1200 supports tone and pulse dialling, detects dial tones and engaged tones, and also has a built-in speaker so that you can monitor call progress. The volume of the speaker can be changed under software control by the computer.

In use, I found that the modem worked reliably, although I experienced a small problem when calling a US system: it couldn’t pick up the carrier from the other end – I must admit it is rather faint, but my old British Telecom 4124 modem doesn’t have any difficulty.

The current recommended list price of £575 (excluding VAT) is rather on the high side. It compares reasonably well with single-sided V22 modems from other manufacturers, but when you consider that you could get more features for a similar price with a WS3000 or, for a little more, a Steebek Quattro, it does look a bit steep.

A spokesman for the company stated that the price included a two year warranty and excellent support. He also said that Hayes products in the US have a high second-hand value. However, I wouldn’t be surprised to see the price reduced before too long, as the modem market is in a state of flux at present with new manufacturers coming into it and prices dropping significantly. (The US Smartmodem 1200 is available in the States, from mail order companies, for around $400, and the Smartmodem 2400 for about $600.)

The documentation is clearly presented and is of a high standard. There is also a comprehensive index.

Smartcom II

Smartcom II is a ‘smart’ terminal package designed to be used with Hayes’ intelligent modems. The UK version of the US product, Smartcom II, has all the usual smart terminal features such as up and downloading of files, including XModem protocols. Details of up to 25 systems can be stored and these can be dialled and logged-onto automatically. DEC VT52/100 terminal emulation is also provided, but unfortunately Viewdata is not.

The program is menu-driven, which makes it very straightforward to use. However, as with any system, the menus can be a bit of a burden when you get used to the way the program works, especially as frequent disk accesses are involved.

When you run the program, the main menu is displayed at the top of the screen. One of the entries is highlighted, and underneath is a brief description of what it does. There is a comprehensive built-in ‘Help’ function available by pressing the F2 help key.

The program must be configured to suit your particular system before you are ready to go. Options include the serial port the modem is attached to, a parallel or serial printer, the number of disk drives, and various modem parameters such as tone or pulse dialling, loudspeaker volume and time to wait for a carrier to be detected. You must also edit the parameter sets to suit the systems you want to call – there are 26 in all, one of which cannot be altered; many of the other 25 are already defined when you buy the program. These definitions include a number of systems such as Telecom Gold, Telecom Gold via PSS, Dialog and Nexis. If any of these suit you, all you have to do is edit the phone number and enter your account and password (which can be hidden from prying eyes) in the auto-log-on section.

Going online is simply a matter of selecting T for ‘Begin communication’, followed by ‘O’ for Originate and the letter for the system you wish to call. The software then tells the modem to dial the number. When it is connected it will automatically log you on – marvellous if, like me, you are a bit ham-fisted, or can never remember the PSS code for the system you want to call. I have to admit that, before I started using them, I used to think that auto-dial modems were gilding the lily, but now I am converted. The cursor keys can also be used to step through the menus; the current option is highlighted, and can be selected by pressing ‘Return’.

The auto-log-on feature is just one of 26 macros that can be stored for each of the 25 definable systems. The macro features are very powerful. Up to 48 characters can be transmitted and you can choose the prompt character, the time to wait before assuming the prompt has got lost on the way, and whether or not a carriage return is required after the data. A number of lines of data can be used for each macro.

Once connected to a remote system, all the usual features are available. Prepared messages can be uploaded continuously or line by line. XModem (or Hayes’ own) error checking protocols are available for file transfer. The printer can be toggled on and off by pressing a function key, so can spooling of data to disk. The status line at the bottom tells you how much disk space is left, the state of the printer buffer, the name of the system that you are connected to, and whether the Caps & Num Lock keys are active – a nice touch if, unlike the Philips PC I was using, you don’t have LEDs on the keys.

Another very useful feature is the ability to scroll back through information which has disappeared off the top of the screen. The manual says that the amount of incoming data that can be viewed in this way depends on the amount of memory in your computer. I had 256k and on one test counted over 60 screens full, without filling the data buffer. This is a feature that should be much more widely available on all computer systems, not just on a terminal program like this. Why should data be lost just because it has scrolled off the top of the screen?

As well as macros, you can set up ‘Batch’ files. Each can store up to 500 keystrokes, and if this isn’t enough, they can be chained together. A batch can be set to run at a predetermined time, which is potentially a very powerful feature. You could set up a batch to call a system, log-on, read all your mail into a disk file and log-off again, completely unattended. Unfortunately, batches seem to be a late addition to Smartcom II, and they haven’t received the same care and attention to detail as the rest of the program. The way they are created is by actually going online and recording your keystrokes as you read your mail, for example, so any typing mistakes you make are recorded in the batch. Unlike the parameter sets for systems, batches can’t be edited or copied. Also, there is little provision for dealing with errors induced by line noise. This means that, unless you are sure of a good line, it isn’t advisable to rely on them working unattended. However, they are a very efficient way of reducing connect time when calling systems normally.

Smartcom II also supports remote access using the auto-answer facility of the modem. You can use it from a remote system (also running Smartcom) as if you were sitting at the keyboard of the host machine. A password can be set to prevent unauthorised access, which enables file transfer, viewing of disk directories, and viewing and erasing files. Smartcom II is designed to work with Hayes’, or Hayes-compatible modems. The problem here is that Hayes currently only sells a V22 (1200 bits/sec full duplex) modem in the UK. The software – in its autodial mode – only supports 600, 1200 and 2400 bits/sec. It can be used with 1200/75 systems, with a V23 modem that buffers the 75 bits/sec line to 1200 bits/sec. It needs to be Hayes-compatible, of course, and I had mixed results here. Smartcom recognised a Miracle Technology WS3000, but for some reason the modem wouldn’t respond to the auto-dial commands. A Steebeck Quattro wasn’t even recognised; I just got ‘Smartmodem not responding on COM1’. On paper, the Quattro seems to be virtually 100 per cent compatible with the Hayes Smartmodem 2400 (not yet available over here). I didn’t have time to pursue these problems in detail, and it may be that they could be overcome. However, it is obvious that you should try before you buy, if you want to make full use of a ‘compatible’ modem.

In fact, Smartcom II can be also used with non-Hayes’ and ‘dumb’ modems by choosing the ‘direct connect’ port option. This still enables you to use all the features of the program, apart from auto-dial. It is also possible to use a non-Hayes’, auto-dial modem by setting up one of the macros to issue the dial command. You could even set up a batch file to take you through the log-on process, which would avoid the need for Hayes compatibility.

Nothing is perfect, but Smartcom II has very few things missing. The most obvious omissions are Viewdata and full 300 bits/sec support. Viewdata is one area where Hayes does seem to have misjudged the UK market and it is likely to be added in a future release. 300 bits/sec support for Hayes-compatibles is another matter: I doubt that it will appear unless Hayes introduces a 300-baud modem of its own. There is also no provision for translation tables (to filter or amend the data streams) but control codes can be filtered out. The only thing that ‘niggled’ me was the fact that, although the modem detects the absence of the dial tone when trying to dial, the software doesn’t recognise this feature.

Smartcom II is a very nice package, carefully designed and implemented. The documentation is, for the most part, excellent, with a comprehensive index. Hayes maintains a help line which puts you straight through to people who know enough about the company’s products to be able to answer most questions easily; Hayes in the US has a good reputation for support. Smartcom II runs on the IBM PC and compatibles. Apparently they do have to be pretty compatible – it worked fine on the Philips P3100.

The recommended retail price is £140 (excl VAT) which is reasonably competitive (but I’ve seen it advertised in the US for $70! I don’t know how different the British version is to that one). It comes with vouchers for Telecom Gold, Nexis, Dialog and Knowledge Index.

First published in Personal Computer World magazine, May 1986

Art For Art’s Sake

There are literally hundreds of Art applications available for home micros, ranging from simple doodlers to complex suites offering solid 3D animation; the choice is bewildering. So what features should you look out for when buying one for your machine? Andy Storer paints a picture of the perfect pixel package…

Image001

King Tut gets another airing – the original pic was picked up as brush, rotated in 3D, pasted down 4 times, swapped to tint mode and overlaid with two circles. Simple eh? On Deluxe Paint III maybe…

How many colours in the spectrum?

Whether you’re paying £3 or £300, most art programs provide a system of pull-down menus and icons for moving between the screen painting area and palette and painting tool control. This is absolutely essential, since you’ll want to be able to move quickly through the range of colours on hand and the painting ‘surface’ before you.

A good program will allow you to flick back to a full screen painting area after changing tools, operations or colours from an overlaid control panel. The more advanced packages will offer you the choice to scroll through a much larger area of work than can be displayed on screen at any one time or, alternatively, have a number of screens in memory that you can flick between.

Although you can buy packages for mono systems, most on offer are designed for colour. Obvious really. Painting’s all about colour isn’t it? Well, up to a point. The point being that you don’t need thousands of colours to produce effective artwork. The number of colours available to you will initially depend on the resolution your machine’s able to support and the degree to which the software allows mixing of the standard colours and combining them to form composite hues and shades.

But more sophisticated software can actually address the hardware to change the screen-scanning to display a new palette of colours on every line. Thus, for instance, Quantum Paint on the ST can offer 4,096 on-screen colours despite the ST offering only a choice of 16 from a palette of 512.

For general purposes, however, 256 colours is the most you’ll ever need – beyond that it becomes difficult to distinguish them. The best packages will offer you a full screen palette which displays all available colours, rather than a simple palette bordering it, thus allowing you to select the one you wish to use simply by clicking on it.

Image002

A 512 colour extravaganza on the ST’s Spectrum 512. But shouldn’t you only be able to see 16 colours at once?

Pixel Picassos

The beauty of electronic painting is the ability to continually modify your work without having to start all over again. Whilst a package will offer you the obvious option of a variable sized eraser, alterations are often likely to involve finer tuning than rubbing out whole areas.

So, for instance, once you’ve chosen a colour and done some drawing you will be able to change it simply by selecting a shade from the palette you wish to replace it with. Ideally, you should be able to click on any individual pixel of colour you’ve painted and be given its exact RGB code so that subtle alterations can be made.

In addition, it’s useful to have a ‘cycle draw’ option where you may select a range of adjacent colours to be painted in sequence as a brush line is drawn. In this way you can subtly blend colour to produce graded hues. In this respect it’s also useful if you can individually alter the hue and luminance of any particular pixel or area by simply clicking on a relevant icon.

The ‘front end’ control panel will allow you to choose between the range of painting tools on hand. A good package should offer you not only different pens, brushes, sprays and fills but a range of shapes, transformations, preset effects and texts. For freehand drawing, mouse control is infinitely preferable to the joystick or keyboard, assuming you don’t have a graphics tablet, and the range of pens and brushes should allow you a choice of line thickness, tip size and style.

Ideally, rather than preset sizes and shapes, you should be able to step up or down through a range. Likewise, sprays should also offer variable density and offer a choice of pattern, flow and nozzle type. The option to fill enclosed areas of artwork with a range of preset patterns is also essential, as is the ability to design your own fills.

Such design may require a fair degree of detail, so a facility allowing a graded zoom magnification of any area is also essential.

Ideally you should be able to grab any part of a screen and use it as fill for another and also merge, or ‘dither’, two adjacent fills so that a perfect gradation is apparent.

Getting into shape

Image005a

Any art package worth its salt should allow you to zoom into an area of the screen for detailed work. Even an average package will offer a zoom of 16x magnification.

Another feature worth looking out for in art packages is the ease with which it is possible to call up perfect circles and ellipses of varying size and thickness for exact positioning in the work area. Advanced packages will also allow you to smooth the curvature of a circle or ellipse to remove its jagged edges.

Of course, you’ll want to be able to construct other shapes, not all of them regular, and in this case you should look for a package that allows you to form multi-sided polygons. Creating the exact shape you desire is likely to be a process of hit and miss, so it also essential to have an ‘Undo’ function.

The most sophisticated features available to the pixel painter are block manipulations. Standard packages offer the facility to define sub-screen areas and move or copy them to other parts of the display. Middle range products will allow you stretch, skew, rotate and distort such defined blocks, whilst the more advanced will not only provide the tools to mirror, flip and invert the image-block but also make it opaque or transparent. It should also be possible to smear a specified area so that it appears to have been dragged. In addition, a more comprehensive package will allow you to outline and frame specified areas with a range of borders and define shadow depth and direction effects.

What can I get out of it though?

Unless you wish to incorporate your artwork into a program or game, then you’ll be wanting to produce hard copies of your masterpieces. The simplest way of achieving this is by photographing the screen. For this you’ll need a 35mm camera with a variable shutter speed which will allow you to shoot slow enough to avoid screen refresh lines in mid-scan. It’s best to shoot in a darkened room with the aperture wide open at a speed of 1/8 or l/4sec.

Colour printers aren’t much cop unless you’re prepared to fork out the readies, so the only other recommended way of displaying your work is by transferring it to videotape. A composite video lead between your micro and the video’s input should do the trick quite easily.

There’s always more…

This overview has concentrated on the options offered by paint packages and takes no account of related features, often incorporated, such as sprite construction, animation and 3D modelling. Express will be covering these areas in the near future.

Write then, let’s go

The inclusion of a text facility is also essential so that you may annotate diagrams or drawings. Here, you should look out for those programs which offer a range of text and font sizes and also include options to vary density and add outline, underlining and skew.

Finally, you should be able to save whole or part-screen files in a compressed form to save on disk space, and also be able to save and load palette and paint tool selections as new default values.

Graphically Superior

Rik Haynes checks out the best buys in graphics software for your machine…

Amiga

With its huge potential as a graphics workstation, and thanks to its superlative custom-designed  chips, the Amiga has perhaps the largest and most impressive selection of excellent graphics software and hardware. This includes a wide variety of paint and animation software, video digitisers, genlocks, etc. But this power unfortunately comes at a price – namely extra RAM and disk drives are not only recommended but absolutely essential in some cases.

DeluxePaint III

  • Paint and Animation Software
  • £79.99
  • Published by Electronic Arts

DeluxePaint III is the latest version of the most popular Amiga paint package around. Requiring 1Mb of RAM, DeluxePaint III includes an impressive paint-animation capability, extra-halfbrite 64-colour and overscan mode support, new wrap and tint brushes, font handling enhancements and substantial speed increases in all modes of operation. Electronic Arts is offering a upgrade service for owners of DeluxePaint (£50 + £5 carriage) and DeluxePaint II (£30 + £5 carriage).

Photon Paint 2.0

  • Paint Software
  • £85.99
  • Published by Microillusions, USA
  • Distributed in UK by Activision

Photon Paint 2.0 is a 4,096 colour HAM-compatible paint package with sophisticated brush operations, surface and contour mapping, shadowing with adjustable size and offset, and luminance with definable source location and intensity. Although Activision has yet to confirm plans to run an upgrade offer for owners of Photon Paint 1.0 in the UK, there is a service available in the US.

Sculpt 3-D

  • Animation Software
  • £85 inc VAT
  • Published by Byte by Byte, USA
  • Distributed in UK by Amiga Centre Scotland

Sculpt 3-D allows you to design and animate 3-dimensional scenes and incorporates an interactive object editor and power tools for constructing arbitrary solid shapes with symmetry, reflection, surfaces of revolution, extrusion, and cross section reconstruction. Sculpt 3-D also includes anti-aliasing, variable object colours and texture, unlimited (number, colour and placement) of light sources, arbitrary observer (placement, angle and direction) of view, phong shading, flat polygonal shading, full ray traced imaging with shadows and highlights, supports all the  Amiga’s graphics modes including overscan and 4,096 colour HAM, and is IFF-compatible.

Sculpt 4-D

  • Animation Software
  • £320 ex VAT
  • Published by Byte by Byte, USA
  • Distributed in UK by Amiga Centre Scotland

Sculpt 4-D is a state-of-the-art professional animation program which requires 1Mb of RAM and two disk drives. It includes substantial enhancements and additions to Sculpt-3D, though at this price, Sculpt 4-D is strictly for Amiga owning animation enthusiasts with loadsadosh.

Zoetrope

  • Paint and Animation Software
  • £99.95 inc VAT
  • Published by Antic, USA
  • Distributed in UK by ISM on 0983 864674

Zoetrope is the Amiga version of the popular ST Cyber paint and animation series, and is split into five modes: painting, cell animation, image processing, video titling and “flip book” pencil testing. Zoetrope requires 1Mb of RAM.

Atari ST

Despite being overshadowed by the Amiga in the visual department, the ST has still managed to attract a wide variety of good quality graphics software which can produce some very impressive results.

Flare Paint

  • Paint Software
  • £34.99
  • Published by AMS/Logitech
  • Distributed in UK by Database Software

Flair Paint is the current flavour-of the-month paint package for ST artists, allowing you to draw images in low-res and high-res – but not medium-res – screen resolution modes.

Degas Elite

  • Paint Software
  • £24.99
  • Published by Electronic Arts

Degas Elite was one of the first paint packages released for the ST, and it still remains one of easiest and most versatile paint programs around for that machine, allowing you to draw images in low-res, medium-res and hi-res screen resolution modes.

Spectrum 512

Image003

Another shot from Spectrum 512 on the ST, showing off smooth toned gradation across a range of colour.

  • Paint Software
  • £59.95 Published by Antic, USA
  • Distributed in UK by Electric Distribution.

Using scan-line palette changing software techniques, Spectrum 512 allows you to draw images on a low-res screen with 512 on-screen colours.

Cyber Studio

  • CAD-3D 2.0 and Cybermate Software
  • £79.95
  • Published by Antic, USA
  • Distributed in UK by Electric Distribution

Cyber Studio requires 1Mb of RAM and combines a 3-D design program Stereo CAD-3D 2.0 and powerful animation control language Cybermate. CAD-3D allows you to create 3D objects and includes camera view with variable zoom and perspective control, three independent user positioned light sources plus ambient lighting (all with variable intensity) and wireframe, hidden line, solid, or solid outline modes. Cybermate uses Forth-type commands to create animation sequences, incorporates delta compression techniques, special effects and lap dissolves and allows you to splice in animations from multiple sources.

Cyber Paint 2.0

  • 2D Paint and Animation Software
  • £69.95
  • Published by Antic, USA
  • Distributed in UK by Electric Distribution

Cyber Paint 2.0 allows to paint and animate 2-D images and can be used to add the final touches to a Cyber Studio 3-D animated sequence. It includes automatic image registration to create cel animation arrangements, real-time zoom mode, multiple static or animated overlaid images and special animation effects with automatic intermediate view generation (tweening) on any area of the screen. Cyber Paint 2.0 requires
1Mb of RAM.

Cyber Sculpt

  • 3D Sculpting Software
  • £79.95
  • Published by Antic, USA
  • Distributed in UK by Electric Distribution

Cyber Sculpt is a professional 3D off-station solid-modeler used to port 3D object files to high-end rendering systems – and includes variable magnification, spline path extrude and spin, face bevelling, and cross-sectional model creation. Cyber Sculpt requires 1Mb of RAM and Cyber Studio (CAD-3D 2.0).

PC

DeluxePaint II

  • Paint Software
  • £99.99
  • Published by Electronic Arts

DeluxePaint II is the PC version of the popular Amiga paint program, and allows you to draw images in CGA, EGA, VGA, MCGA, Hercules and Tandy graphics modes.

Spectrum

Art Studio

  • Paint Software
  • £12.95 (Spectrum 48K compatible)
  • Published by Rainbird
  • Distributed in UK by EEC

Advanced Art Studio

  • Paint Software
  • £22.95 (Spectrum 128K Only) Published by Rainbird
  • Distributed in UK by EEC

C64

Art Studio

  • Paint Software
  • £12.95cs, £15.95dk
  • Published by Rainbird
  • Distributed in UK by EEC

Advanced Art Studio

  • Paint Software
  • £22.95 (Disk Only)
  • Published by Rainbird
  • Distributed in UK by EEC

CPC

Image004

Even on the Amstrad CPC, a machine supporting only 4 colours, the range of fills is impressive – here it’s Advanced Art Studio from Rainbird.

Art Studio

  • Paint Software
  • £17.95dk
  • Published by Rainbird
  • Distributed in UK by EEC

Advanced Art Studio

  • Paint Software
  • £22.95dk
  • Published by Rainbird
  • Distributed in UK by EEC

First published in New Computer Express magazine, 25th March 1989