Overview
Part 1 covered punched cards, mainframes, microprocessors, and the Apple I.
But the ability for individuals to own computers did not automatically change business work.
The real question was what those computers could do.
This is where the Apple II and VisiCalc mattered.
The Apple II was a more practical personal computer. VisiCalc was the spreadsheet application that gave it a reason to exist in business.
Together, they moved the personal computer closer to the office.
The Apple II Was a More Practical Personal Computer
The Apple I and Apple II are both early Apple products, but they had very different roles.
The Apple I suggested that an individual could own a computer, but it was still close to a board-level product that required users to supply other parts.
The Apple II was closer to a complete personal computer.
It included a keyboard, supported color display, allowed expansion, and was much more approachable for ordinary users.
Computers were moving beyond a small circle of technical enthusiasts and toward homes and small businesses.
Still, the Apple II alone was not enough. Business users needed a clear reason to buy and use it.
VisiCalc Made the Apple II a Business Tool
VisiCalc gave the Apple II a strong business reason.
VisiCalc was an early spreadsheet program created by Dan Bricklin and Bob Frankston. It was developed by Software Arts and sold by Personal Software, later known as VisiCorp.
VisiCalc appeared for the Apple II in 1979.
It changed what a personal computer meant.
With the Apple II as the hardware and VisiCalc as the application, the personal computer moved from an interesting machine to a business machine.
The hardware alone did not change the world. A practical application gave people a reason to buy it.
Spreadsheet Work Used to Mean Paper and Calculators
Before VisiCalc, spreadsheet work was done with paper forms and calculators.
- Calculate sales
- Calculate costs
- Estimate profit
- Build budgets
- Test multiple assumptions
Numbers were written into tables, calculated by hand or calculator, and recorded.
The problem came when one assumption changed.
Sales forecasts, unit prices, cost rates, and labor costs could all affect other calculations.
Spreadsheet work was not just slow calculation. It made experimentation slow.
Dan Bricklin's Idea
Dan Bricklin, one of the creators of VisiCalc, was studying at Harvard Business School when he imagined a better way to work with tables.
While looking at numbers on a board, he thought about a system where changing one number would automatically change related results.
That idea now feels obvious because spreadsheets made it normal.
At the time, it was a major shift.
On paper, changing a number did not change the results. Someone had to recalculate.
Bricklin's idea was to move the table onto a screen and make numbers changeable.
Numbers Changed From Records Into Simulations
VisiCalc changed more than calculation speed.
It changed how people used numbers.
On paper, numbers were close to records. They could be analyzed, but testing many scenarios took work.
In a spreadsheet, changing a number can update the result immediately.
- What happens if sales increase by 10%?
- What happens if costs rise?
- What happens if headcount changes?
- What happens if pricing changes?
These questions became easier to test on screen.
Numbers moved from records of the past toward tools for thinking about the future.
Summary
The Apple II made personal computers more practical.
But without a strong use case, it would have been harder for the Apple II to enter business workflows.
VisiCalc provided that reason.
It changed spreadsheet work from paper-and-calculator calculation into on-screen scenario testing.
The Apple II was the stage. VisiCalc was the decisive application on that stage.
Part 3 looks at Lotus 1-2-3, Excel, Google Sheets, and the AI era of spreadsheets.