# Bob Frankston

> 1949– · Programmer, Co-creator of VisiCalc
>
> **Recorded contribution:** Co-created VisiCalc

## How to use this dossier

Read for a causal chain, not a hero story: inherited problem → contribution → mechanism → downstream capability → limit. Then close the page and complete the reconstruction exercise from memory.

## 1. Historical orientation

Bob Frankston (born 1949) co-created VisiCalc with Dan Bricklin. Bricklin conceived the electronic spreadsheet while studying at Harvard Business School; Frankston designed and implemented the highly optimized software for the Apple II and co-founded Software Arts. VisiCalc represented a sheet of formulas and values whose dependencies were recalculated when an input changed, letting business users explore scenarios without writing conventional programs. It became an early 'killer app' that motivated computer purchases. The product is a shared milestone: concept, implementation, hardware, distribution, and user adoption are distinct contributions.

## 2. The problem inherited

Financial models on paper required laborious repeated arithmetic after any assumption changed, while programming a custom model placed exploration behind a technical intermediary.

## 3. The central contribution

Frankston engineered VisiCalc's compact interactive recalculation system under severe Apple II memory and performance constraints.

## 4. Reconstruct the mechanism

1. Address cells by row and column and store either literal values or formulas referencing other cells.
2. Parse formulas and build or infer dependency relationships among cells.
3. When an input changes, recalculate affected formulas in an order that makes referenced values available.
4. Render the grid and results interactively so users can revise assumptions and immediately compare scenarios.

## 5. What changed downstream

- VisiCalc made the personal computer a practical business analysis tool.
- The spreadsheet became a widely accessible end-user programming environment.
- Its market success influenced Lotus 1-2-3, Excel, and application-driven computer purchasing.

## 6. Attribution, limits, and uncertainty

- Bricklin is the concept co-creator; Frankston's central contribution was implementation and engineering.
- Spreadsheets hide types, dependencies, tests, and provenance, making silent errors common.
- Recalculation semantics, circular references, floating-point behavior, and large models require controls beyond the original interaction.

## 7. Reconstruction lab

Build a 10×10 spreadsheet with formula parsing, dependencies, and selective recalculation. Introduce one hidden hard-coded constant and one circular reference, then design auditing views that expose both. Add unit labels, a scenario table, and an independent recomputation of one total; have a peer locate the seeded defects without being told which cells contain them.

## 8. Evidence trail

- [Bob Frankston and VisiCalc](https://computerhistory.org/profile/bob-frankston/) — Computer History Museum
- [VisiCalc](https://www.bricklin.com/visicalc.htm) — Dan Bricklin

---

*Research checked 2026-08-09. Dates, roles, and claims about living people are historical snapshots. Linked sources remain the authority; this dossier is original instructional synthesis.*