Meet the inventor of the electronic spreadsheet | Dan Bricklin

The Evolution of Spreadsheets and VisiCalc

Introduction to Spreadsheets

• The speaker, Crawford Hunt, engages the audience by asking about their experience with electronic spreadsheets like Microsoft Excel.

• He contrasts modern spreadsheet use with traditional methods, referencing his father's manual business operations in Philadelphia.

The Birth of VisiCalc

• In 1978, Hunt began developing VisiCalc, which launched on the Apple II in 1979. This marked a significant shift in how businesses utilized technology.

• Steve Jobs acknowledged VisiCalc's pivotal role in Apple's success, stating it propelled the personal computer industry forward.

Early Programming Experience

• Hunt recounts learning programming at age 15 and gaining access to computers through perseverance.

• His work on the Multics Project at MIT introduced him to interactive time-sharing systems that influenced future operating systems like Linux and Unix.

Career Development

• After graduating from MIT, he worked at Digital Equipment Corporation (DEC), focusing on computerized typesetting and user interface design for non-computer users.

• Hunt transitioned to a small company creating electronic cash registers but aspired to start a venture with Bob Frankston from MIT.

Business Education and Case Method Learning

• To prepare for entrepreneurship, he enrolled in Harvard Business School's MBA program in 1977, where he was one of few students with programming experience.

• At Harvard, students learned through case studies that involved analyzing complex business situations filled with numbers and words.

Conceptualizing Interactive Calculations

• Frustrated by errors affecting class participation due to incorrect calculations, Hunt envisioned an interactive tool akin to a "magic blackboard."

• He imagined integrating mouse hardware into calculators for real-time computations during negotiations.

Prototyping Process

• Inspired by his father's prototyping techniques for printing projects, Hunt decided to create a working prototype of his vision using Harvard's time-sharing system.

The Development of VisiCalc

Initial Challenges in Formula Creation

• The challenge was determining what to include in the formula, requiring a unique identifier for each cell that the computer could recognize.

• The initial idea involved manually naming cells, but this proved too tedious as the number of values increased.

• A grid system was proposed to simplify identification; using row and column labels (e.g., B7) would make it easier for users to locate data on the screen.

Benefits of Grid Restriction

• Restricting input to a grid not only solved identification issues but also allowed for new functionalities like cell ranges while maintaining flexibility in data entry.

• Documentation was created to clarify user interface design, ensuring it could be easily understood by non-programmers.

Development Process and Testing

• Bob worked from an attic using MIT's Multics System, coding and testing versions on an Apple II via acoustic coupler connections.

• Early challenges included lack of print and save functions, leading to repetitive manual input during tests. Despite these setbacks, VisiCalc proved useful in practical applications.

Public Introduction of VisiCalc

• After significant development efforts, VisiCalc was publicly announced at the National Computer Conference in June 1979 with marketing materials prepared by family members.

• The New York Times humorously covered the event, highlighting early skepticism about electronic spreadsheets despite some recognition of their potential.

Launch and Legacy

• By October 1979, VisiCalc was shipped with distinctive packaging and became a pivotal product in computing history.