SynCalc

Medium
Disk
Year
1983
Publisher
Synapse Software (also released under the Atari label, DX5064)
Type
Application
Category
Spreadsheet
Developer
Mike Silva
Requirements
48K Atari 400/800/XL/XE, disk drive set as drive 1, no cartridges; optional printer, second drive, Axlon RAMpower 128K or Mosaic 64K Select
SynCalc box front showing a household-budget spreadsheet, with a sticker reading 'C-64 / Atari: single disk works on both computers'

Overview

SynCalc is the spreadsheet most Atari 8-bit owners actually used for serious work. Synapse Software is better remembered for games like Blue Max and Shamus, but in the mid-1980s it built a whole line of 48K productivity software for the Atari: SynCalc (spreadsheet), SynFile+ (database), SynTrend (graphs and statistics), SynStock (portfolio manager), SynChron (desk calendar) and SynComm (terminal). Antic's February 1985 survey of the line said SynCalc "may well be the best spreadsheet available for the Atari". Two years later its Shopper's Guide described SynCalc and SynFile+ as the most widely used integrated productivity applications on 8-bit Ataris.

The program was written by Mike Silva. Copyright dates on the manual are 1983 and 1985, and it was later converted to the Apple IIe/IIc (by Joe Vierra) and the Commodore 64. The series was first meant to be marketed by Atari itself. Antic notes that this is why Synapse dropped its own word processor and made everything compatible with AtariWriter instead. It appeared both under the Atari label (DX 5064) and as Synapse's own release (ATDSK-6112), and a separate SynCalc Templates Disk was sold.

Features

  • A bigger sheet than VisiCalc's. Columns run from A to OX, 128 in all, and the manual's row border goes to 255. Antic's review rounded this to "128 columns across and 256 rows down".
  • Pop-up menus. Press OPTION and a menu bar appears along the bottom of the screen with four headings: LOAD/SAVE, TEXT, NUMERIC and COMMAND. ESC takes you back to the sheet.
  • Expert mode. Whenever you use a menu, SynCalc shows the equivalent slash command on the message line, so beginners learn the shortcuts as they go. You can then type them directly: /GD7 jumps to cell D7, /FGW 7 sets every column to seven characters, /FGP 2 sets two decimal places, and /RR switches recalculation to row order.
  • Variable column widths, which VisiCalc lacked: 1 to 36 characters, set per range or globally. There are also text-overflow modes so long labels spill into empty neighbouring cells.
  • Cell protection (/FO and related format options), so formulas can't be typed over by accident.
  • Sorting, in ascending or descending order on a chosen column, plus insert/delete row or column, move, copy, split windows (synchronised or independent), and fixed titles.
  • Named references. /U (Use Labels) declares a label row and column, so formulas can refer to cells by name, joined with an underscore.
  • Functions: mathematical (@ABS, @INT, @SQRT, logs, trig, @PI), logical (@IF ... THEN ... ELSE ... with AND/OR), @LOOKUP, financial (@FV, @NPV, @PMT) and statistical (@SUM, @AVG, @CNT, @MAX, @MIN, @MEAN, @SD, @VAR).
  • Three ways to save. WRKSHEET saves the whole sheet as a .SC file. DATA saves a range as a DIF file without formulas. TEXT saves a range as a .TXT file that keeps its formatting and can be merged into AtariWriter documents.
  • VisiCalc conversion. A built-in utility converts VisiCalc sheets to .SC files. Anything it can't translate becomes a text entry for you to fix by hand.
  • Memory meter. The top line shows memory used and available in K. SynCalc can use the Axlon RAMpower 128K or Mosaic 64K Select boards for bigger sheets.

Getting started

  1. Remove all cartridges, put the program disk in drive 1 and switch on. Loading takes about a minute.
  2. Once the worksheet appears you can take the program disk out. Format a data disk from LOAD/SAVE → Format. SynCalc formats disks in Atari DOS-compatible form. Antic's 1987 template article warns you to use the Format on the LOAD/SAVE menu, not the one under COMMAND, which formats cells.
  3. Move around with CTRL plus the arrow keys. Choose TEXT or NUMERIC from the menu, or just start typing. Write a formula that begins with a cell reference with a leading + (e.g. +E17) so it is taken as a number, not a label.
  4. Press START to recalculate the sheet. Save it with LOAD/SAVE → Save → WRKSHEET.

Reception and links to other programs

Antic praised the colourful menus and called the manuals "just about the best documentation ever written for Atari software". It still made one criticism of the whole Synapse range: it was "not truly integrated". Data moved between programs through DIF files one column at a time, which the reviewer called tedious. Other developers built on SynCalc's formats anyway. Electronic Arts' B/Graph read and wrote SynCalc DIF files. Antic's V-Graph type-in could graph SynCalc columns saved as text (/LST). Antic also published ready-made SynCalc templates, such as a 1987 personal net-worth sheet and income-tax sheets. Reeve Software's Super ReeveKey driver even had a special mode just for using the CX85 numeric keypad with SynCalc.

Later Antic letters call it "Broderbund's SynCalc", which reflects Broderbund's takeover of Synapse.

Using it today

SynCalc boots from its own disk, so in an emulator you just attach the image as D1:, turn BASIC off and use at least 48K. (The manual only mentions the Axlon and Mosaic boards as RAM expansions, so don't count on 130XE-style banked memory being used.) Attach a second, blank disk image as D2: for your data and format it from the LOAD/SAVE menu. If the program refuses to load, the manual's checklist still applies: no cartridges, at least 48K, and a drive set as drive 1. Because worksheets can be exported as DIF or plain text, getting data out to a modern spreadsheet is straightforward once the files are copied off the disk image.

Credits