VisiCalc
- Medium
- Disk
- Year
- 1980
- Publisher
- Personal Software, Inc. (later VisiCorp); also distributed by Atari
- Type
- Application
- Category
- Spreadsheet
- Developer
- Software Arts, Inc.
- Requirements
- Atari 800 (any later 8-bit works), 32K RAM minimum (48K recommended), disk drive set as drive 1, no cartridges inserted; optional 820/825 printer or 850 interface
- Related
- SynCalc, Altirra, Defender, Galaxian, Windows (BASIC Demo)
Overview
VisiCalc is the program that invented the personal-computer spreadsheet, and the Atari 800 got it early. The original Apple II version had shipped in October 1979; Personal Software (the company that soon renamed itself VisiCorp) showed the Atari 800 version of Software Arts' program at the National Computer Conference's Personal Computing Festival in mid-1980 and shipped it that October. For many buyers it was the first proof that the Atari 800 was more than a games machine.
The idea is simple and was revolutionary at the time: the screen is a window onto a much larger "electronic sheet" of rows and columns. Each cell can hold a label, a number or a formula, and when you change any number every formula that depends on it recalculates in front of you. The manual sells it as a replacement for "a calculator, a pencil, and a sheet of paper" and leans heavily on "what if" planning — change one sales figure and watch the whole projection update.
Features
- The sheet. Columns run A to BK (63 columns) and rows 1 to 254, so the bottom-right cell is BK254. Memory is only allocated for the rectangle you actually use, and the manual has a short section on "shrinking the sheet" to win back space.
- Slash commands. Everything is driven from the
/key. Pressing it shows the promptCOMMAND: BCDFGIMPRSTVW-, one letter per command: Blank, Clear, Delete, Format, Global, Insert, Move, Print, Replicate, Storage, Titles, Version, Window and the "-" repeating label. - Replicate (
/R). Copies a formula or range of formulas, asking for each cell reference whether it should stay fixed ("no change") or move relative to the new position. This is the feature the tutorials spend the most time on. - Windows and titles.
/Wsplits the screen horizontally or vertically, with optional synchronised scrolling and separate column widths per window;/Tfreezes title rows or columns so labels stay visible while you scroll. - Built-in functions include
@SUM,@AVERAGE,@COUNT,@MIN,@MAX,@NPV,@LOOKUP,@ABS,@INT,@SQRT, logs and exponentials, trig functions,@PI, and the special@NAand@ERRORvalues for marking missing or invalid data. - Manual or automatic recalculation, with forward and circular references explained in the manual.
- Printing to the Atari 820 or 825 printers (or another printer through the 850 interface).
- Data Interchange Format.
/S#Ssaves the sheet as a DIF file and/S#Lloads one, so BASIC programs and later applications can use the numbers.
A quick walkthrough
The /S key opens the Storage menu, whose prompt reads STORAGE: L S D I Q #:
- Before your first session, put a blank disk in drive 1 and type
/SI, then RETURN, to initialise a storage disk (this erases it). - Move the cursor with CTRL plus the arrow keys, or jump straight to a cell with the
>GO TO command, e.g.>A1. - Type a label, a number, or a formula such as
+A1*2. BREAK backs out of anything you are halfway through typing. - Save with
/SSfollowed by a name, e.g./SSMYBUDGET— sheet files get a.VCsuffix. Load one again with/SL. /SQthenYquits VisiCalc, with the same effect as switching the computer on again.
Behind the scenes
The Atari manual was written by Dan Fylstra (co-founder of Personal Software) and Bill Kling, and it is a model of its kind: four keystroke-by-keystroke lessons that build a household budget and a savings-interest sheet, followed by a full command reference. The program on the surviving disks is version 1.74A, and copies exist under both the Personal Software and VisiCorp names.
VisiCalc became part of Atari's own push into home productivity. At the January 1983 Winter CES Atari introduced VisiCalc for the 400, 800 and 1200XL alongside games like Galaxian and Defender, and on 7 February 1983 it announced it was shipping it. Atari's CX85 numeric keypad was also promoted explicitly for use with VisiCalc.
By the mid-1980s it had competition. Antic's 1984 round-up of Synapse's productivity line called SynCalc "easier and more versatile than VisiCalc", pointing out that SynCalc could widen individual columns and could read VisiCalc files. VisiCalc stayed useful as a data source, though: Antic's 1986 type-in V-Graph could graph columns that had been "printed" to a disk file with VisiCalc's /PF option.
Technical notes and gotchas
- VisiCalc boots from its own disk and loads only from the drive set to drive code 1.
- Remove every cartridge first, because VisiCalc will not run with one inserted (on XL/XE machines, keep BASIC disabled as well by holding OPTION while booting).
- 32K is the minimum, but the manual "highly recommends" 48K, because memory limits how big a sheet can get.
- The original disk is write-protected, and the manual tells you never to leave it in the drive while you work. You save to separate storage disks.
Using it today
Disk images of VisiCalc are easy to find, and it runs in any Atari 8-bit emulator such as Altirra. Configure at least 48K, no cartridge, BASIC off, and boot the program disk as D1:. Then mount a second, blank image, initialise it with /SI and use it for your sheets. If you only want to see how the first spreadsheet felt, the four tutorial lessons in the manual still work keystroke for keystroke. For real work on an Atari, the later SynCalc is friendlier, and it can import VisiCalc files.
Credits
- Picture: VisiCalc box (VisiCorp release). — Box scan from AtariMania (VisiCalc, VisiCorp release) (Fair use (packaging scan))
- AtariMania — VisiCalc (Personal Software release) — AtariMania
- AtariMania — VisiCalc (VisiCorp release) — AtariMania
- comp.sys.atari.8bit FAQ (Michael Current) — timeline entries for 1980 and 1983 — Michael Current (comp.sys.atari.8bit FAQ), 1980
- Antic v3n10 — Syntegrated (SynCalc compared with VisiCalc) — AtariMagazines.com (Kevin Savetz)
- Antic v5n7 — V-Graph (graphing VisiCalc data) — AtariMagazines.com (Kevin Savetz)
