Spreadsheets on the Commodore VIC-20

  /     /   Commodore     Retro     VIC-20    

The VIC-20 had a number a spreadsheet programs released for it which despite the limited resources of the Vic could actually be quite usable. The two best known are SimpliCalc and PractiCalc, but there were others such as TechniCalc and BusiCalc as well as one written in Basic to use a 40 column extension such as FAT-40.

SimpliCalc

SimpliCalc was originally written for the Commodore PET and was later released in about 1983 by Commodore Business Machines for the Vic. It was available on cassette tape and disk. The spreadsheet works quite well and supports mixed case text which can make the sheets easier to follow and is something that PractiCalc can't do.

Overall it's a good early spreadsheet but a little simplistic compared to PractiCalc. A disk image can be found on cbm8bit by searching for simplicalc.d64 and clicking on simplicalc.d64 from the menu. The manual is available on archive.org.

PractiCalc

PractiCalc was released in about 1982 on tape and disk by Computer Software Associates and is a really impressive piece of software for the Vic. It is quicker than SimpliCalc and supports many of the features of modern spreadsheets such as formatting, complex formulas, column resizing, moving and inserting rows and columns, etc.

One thing that is particularly interesting is that you can automate part of the data entry by using a formula in a cell such as ?sales smith, which when the spreadsheet calculates the formulas it will prompt the user to give 'sales smith'. Therefore if you had a spreadsheet where you regularly change the entries such as for sales reps each month you could put a similar formula in for each rep and then the program would just go through and prompt you for each entry before calculating the final figures.

PractiCalc was also capable of displaying histograms inline by representing a number in a cell using either stars or in hi-res mode by having a smooth graphical representation.

The manual for PractiCalc Plus is available from BombJack and this manual, as far as I can tell, seems to be compatible with the version of PractiCalc available on Zimmers. I have also come across a version mentioned in a thread on the denial forums about PractiCalc which says that it is PractiCalc Plus.

Video of SimpliCalc and PractiCalc

You can see SimpliCalc and PractiCalc being used on a Commodore VIC-20 in the video below:

Creative Commons License
Spreadsheets on the Commodore VIC-20 by Lawrence Woodman is licensed under a Creative Commons Attribution 4.0 International License.

Related Articles

Moving the Picture Origin on the Commodore VIC-20

The VIC-20's VIC chip provides a simple yet flexible video display and one of the features that can be quite useful is the ability to alter the picture origin on the screen. This feature allows us to ...   Read More

40 Columns in Basic on the Commodore VIC-20

There are a number of programs that allow you to use 40 columns of text from Basic on a Commodore VIC-20. This can be useful as by default the Vic's screen is 22 columns by 23 rows. They are supplied...   Read More

Adding a Basic Stub to a VIC-20 Assembly Language Program

To make machine language programs more friendly it is nice to add a basic stub which contains a line with a SYS statement to start the code. This is easy to do on the Vic-20 and the process gives you ...   Read More

Creating a TTY Simulator in Assembly Language on the VIC-20

The Vicmon machine language cartridge is an excellent tool for exploring the Vic-20. This article and its associated video will show you how to use it to create a simple program that will change the n...   Read More

Beginning Assembly Programming on the Commodore VIC-20

The Commodore Vic-20 is a great machine to learn an assembly language on. It was released in 1981 and was the first computer to sell one million units, which contributes to its popularity today. The ...   Read More

Sign up to get new articles straight to your inbox.

Delivered by FeedBurner

Comments

blog comments powered by Disqus