TEDxBeaconStreet
Dan Bricklin: Meet the inventor of the electronic spreadsheet
Filmed:
Readability: 4.1
1,147,045 views
Dan Bricklin changed the world forever when he codeveloped VisiCalc, the first electronic spreadsheet and grandfather of programs you probably use every day like Microsoft Excel and Google Sheets. Join the software engineer and computing legend as he explores the tangled web of first jobs, daydreams and homework problems that led to his transformational invention.
Dan Bricklin - Software pioneer
Dan Bricklin helped fuel the rapid growth of the personal computer industry. Full bio
Dan Bricklin helped fuel the rapid growth of the personal computer industry. Full bio
Double-click the English transcript below to play the video.
00:12
How many of you have used
an electronic spreadsheet,
an electronic spreadsheet,
0
760
2975
00:15
like Microsoft Excel?
1
3760
1480
00:18
Very good.
2
6240
1256
00:19
Now, how many of you have run a business
with a spreadsheet by hand,
with a spreadsheet by hand,
3
7520
4576
00:24
like my dad did for his small
printing business in Philadelphia?
printing business in Philadelphia?
4
12120
3080
00:28
A lot less.
5
16160
1160
00:29
Well, that's the way it was done
for hundreds of years.
for hundreds of years.
6
17920
2600
00:33
In early 1978,
I started working on an idea
I started working on an idea
7
21480
3016
00:36
that eventually became VisiCalc.
8
24520
2400
00:39
And the next year it shipped
9
27480
1656
00:41
running on something new
called an Apple II personal computer.
called an Apple II personal computer.
10
29160
3279
00:45
You could tell that things
had really changed when, six years later,
had really changed when, six years later,
11
33240
4056
00:49
the Wall Street Journal ran an editorial
12
37320
2176
00:51
that assumed you knew what VisiCalc was
and maybe even were using it.
and maybe even were using it.
13
39520
3280
00:55
Steve Jobs back in 1990
14
43760
2960
00:59
said that "spreadsheets
propelled the industry forward."
propelled the industry forward."
15
47160
3240
01:02
"VisiCalc propelled the success of Apple
more than any other single event."
more than any other single event."
16
50880
3920
01:07
On a more personal note,
17
55440
1160
01:09
Steve said, "If VisiCalc had been written
for some other computer,
for some other computer,
18
57600
3136
01:12
you'd be interviewing
somebody else right now."
somebody else right now."
19
60760
2200
01:15
So, VisiCalc was instrumental in getting
personal computers on business desks.
personal computers on business desks.
20
63360
6376
01:21
How did it come about?
21
69760
1160
01:23
What was it? What did I go through
to make it be what it was?
to make it be what it was?
22
71680
2920
01:27
Well, I first learned to program
back in 1966, when I was 15 --
back in 1966, when I was 15 --
23
75920
5336
01:33
just a couple months
after this photo was taken.
after this photo was taken.
24
81280
2240
01:36
Few high schoolers had access
to computers in those days.
to computers in those days.
25
84200
2960
01:39
But through luck
and an awful lot of perseverance,
and an awful lot of perseverance,
26
87560
3496
01:43
I was able to get
computer time around the city.
computer time around the city.
27
91080
2240
01:46
After sleeping in the mud at Woodstock,
I went off to MIT to go to college,
I went off to MIT to go to college,
28
94200
4880
01:51
where to make money,
I worked on the Multics Project.
I worked on the Multics Project.
29
99520
3080
01:55
Multics was a trailblazing
interactive time-sharing system.
interactive time-sharing system.
30
103320
5016
02:00
Have you heard of the Linux
and Unix operating systems?
and Unix operating systems?
31
108360
3176
02:03
They came from Multics.
32
111560
1240
02:05
I worked on the Multics versions
33
113320
2296
02:07
of what are known
as interpreted computer languages,
as interpreted computer languages,
34
115640
3816
02:11
that are used by people
in noncomputer fields
in noncomputer fields
35
119480
2456
02:13
to do their calculations
while seated at a computer terminal.
while seated at a computer terminal.
36
121960
3000
02:17
After I graduated from MIT,
37
125560
2256
02:19
I went to work for
Digital Equipment Corporation.
Digital Equipment Corporation.
38
127840
2840
02:23
At DEC, I worked on software
39
131320
3176
02:26
for the new area
of computerized typesetting.
of computerized typesetting.
40
134520
2840
02:29
I helped newspapers
replace their reporters' typewriters
replace their reporters' typewriters
41
137800
4336
02:34
with computer terminals.
42
142160
1200
02:35
I'd write software
43
143880
1216
02:37
and then I'd go out in the field
to places like the Kansas City Star,
to places like the Kansas City Star,
44
145120
3696
02:40
where I would train users
and get feedback.
and get feedback.
45
148840
2416
02:43
This was real-world experience
46
151280
1856
02:45
that is quite different
than what I saw in the lab at MIT.
than what I saw in the lab at MIT.
47
153160
3240
02:49
After that, I was project leader
48
157880
2616
02:52
of the software for DEC's first
word processor, again a new field.
word processor, again a new field.
49
160520
4800
02:57
Like with typesetting, the important thing
was crafting a user interface
was crafting a user interface
50
165720
5496
03:03
that was both natural and efficient
for noncomputer people to use.
for noncomputer people to use.
51
171240
4080
03:08
After I was at DEC, I went
to work for a small company
to work for a small company
52
176360
3976
03:12
that made microprocessor-based electronic
cash registers for the fast-food industry.
cash registers for the fast-food industry.
53
180360
6120
03:19
But I had always wanted to start
a company with my friend Bob Frankston
a company with my friend Bob Frankston
54
187360
3696
03:23
that I met on the Multics project at MIT.
55
191080
2376
03:25
So I decided to go back to school to learn
as much as I could about business.
as much as I could about business.
56
193480
3696
03:29
And in the fall of 1977,
57
197200
2776
03:32
I entered the MBA program
at Harvard Business School.
at Harvard Business School.
58
200000
3000
03:35
I was one of the few
percentage of students
percentage of students
59
203840
2496
03:38
who had a background
in computer programming.
in computer programming.
60
206360
2840
03:42
There's a picture of me from the yearbook
sitting in the front row.
sitting in the front row.
61
210080
3176
03:45
(Laughter)
62
213280
1016
03:46
Now, at Harvard,
we learned by the case method.
we learned by the case method.
63
214320
2616
03:48
We'd do about three cases a day.
64
216960
1936
03:50
Cases consist of up to a few dozen pages
describing particular business situations.
describing particular business situations.
65
218920
5720
03:57
They often have exhibits,
and exhibits often have words and numbers
and exhibits often have words and numbers
66
225600
4576
04:02
laid out in ways that make sense
for the particular situation.
for the particular situation.
67
230200
3160
04:05
They're usually all somewhat different.
68
233840
1936
04:07
Here's my homework.
69
235800
1216
04:09
Again, numbers, words,
laid out in ways that made sense.
laid out in ways that made sense.
70
237040
3176
04:12
Lots of calculations --
we got really close to our calculators.
we got really close to our calculators.
71
240240
4080
04:16
In fact, here's my calculator.
72
244720
1880
04:20
For Halloween, I went
dressed up as a calculator.
dressed up as a calculator.
73
248200
2776
04:23
(Laughter)
74
251000
1440
04:25
At the beginning of each class,
the professor would call on somebody
the professor would call on somebody
75
253785
3191
04:29
to present the case.
76
257000
1279
04:31
What they would do is
they would explain what was going on
they would explain what was going on
77
259079
2777
04:33
and then dictate information
that the professor would transcribe
that the professor would transcribe
78
261880
3736
04:37
onto the many motorized blackboards
in the front of the class,
in the front of the class,
79
265640
2905
04:40
and then we'd have a discussion.
80
268569
1527
04:42
One of the really frustrating things
is when you've done all your homework,
is when you've done all your homework,
81
270120
4456
04:46
you come in the next day
only to find out that you made an error
only to find out that you made an error
82
274600
3016
04:49
and all of the other numbers
you did were wrong.
you did were wrong.
83
277640
2536
04:52
And you couldn't participate as well.
84
280200
1776
04:54
And we were marked by class participation.
85
282000
2240
04:57
So, sitting there with 87 other people
in the class, I got to daydream a lot.
in the class, I got to daydream a lot.
86
285320
4920
05:03
Most programmers in those days
worked on mainframes,
worked on mainframes,
87
291280
3856
05:07
building things like inventory systems,
payroll systems and bill-paying systems.
payroll systems and bill-paying systems.
88
295160
6336
05:13
But I had worked
on interactive word processing
on interactive word processing
89
301520
2496
05:16
and on-demand personal computation.
90
304040
2096
05:18
Instead of thinking
about paper printouts and punch cards,
about paper printouts and punch cards,
91
306160
4280
05:22
I imagined a magic blackboard
92
310880
2776
05:25
that if you erased one number
and wrote a new thing in,
and wrote a new thing in,
93
313680
3376
05:29
all of the other numbers
would automatically change,
would automatically change,
94
317080
2856
05:31
like word processing with numbers.
95
319960
1760
05:34
I imagined that my calculator
had mouse hardware on the bottom of it
had mouse hardware on the bottom of it
96
322600
4240
05:39
and a head-up display,
like in a fighter plane.
like in a fighter plane.
97
327240
2960
05:42
And I could type some numbers in,
and circle it, and press the sum button.
and circle it, and press the sum button.
98
330720
4136
05:46
And right in the middle of a negotiation
I'd be able to get the answer.
I'd be able to get the answer.
99
334880
3736
05:50
Now I just had to take my fantasy
and turn it into reality.
and turn it into reality.
100
338640
3000
05:54
My father taught me about prototyping.
101
342640
2440
05:57
He showed me mock-ups
102
345560
1616
05:59
that he'd make to figure out
the placement on the page
the placement on the page
103
347200
3336
06:02
for the things for brochures
that he was printing.
that he was printing.
104
350560
2536
06:05
And he'd use it
to get feedback from customers
to get feedback from customers
105
353120
2936
06:08
and OKs before he sent the job
off to the presses.
off to the presses.
106
356080
3600
06:12
The act of making a simple, working
version of what you're trying to build
version of what you're trying to build
107
360440
5096
06:17
forces you to uncover key problems.
108
365560
2320
06:20
And it lets you find solutions
to those problems much less expensively.
to those problems much less expensively.
109
368720
4400
06:25
So I decided to build a prototype.
110
373720
2240
06:28
I went to a video terminal connected to
Harvard's time-sharing system
Harvard's time-sharing system
111
376760
4576
06:33
and got to work.
112
381360
1496
06:34
One of the first problems
that I ran into was:
that I ran into was:
113
382880
3256
06:38
How do you represent values in formulas?
114
386160
2680
06:41
Let me show you what I mean.
115
389280
1360
06:44
I thought that you would point somewhere,
116
392000
2176
06:46
type in some words,
then type in some somewhere else,
then type in some somewhere else,
117
394200
3096
06:49
put in some numbers and some more numbers,
point where you want the answer.
point where you want the answer.
118
397320
3524
06:53
And then point to the first, press minus,
point to the second,
point to the second,
119
401240
3216
06:56
and get the result.
120
404480
1200
06:58
The problem was:
What should I put in the formula?
What should I put in the formula?
121
406360
3416
07:01
It had to be something
the computer knew what to put in.
the computer knew what to put in.
122
409800
2620
07:04
And if you looked at the formula,
123
412444
1692
07:06
you needed to know
where on the screen it referred to.
where on the screen it referred to.
124
414160
3000
07:09
The first thing I thought was
the programmer way of doing it.
the programmer way of doing it.
125
417840
2896
07:12
The first time you pointed to somewhere,
126
420760
1905
07:14
the computer would ask you
to type in a unique name.
to type in a unique name.
127
422689
2680
07:18
It became pretty clear pretty fast that
that was going to be too tedious.
that was going to be too tedious.
128
426760
3776
07:22
The computer had to automatically
make up the name and put it inside.
make up the name and put it inside.
129
430560
3240
07:26
So I thought, why not make it be
the order in which you create them?
the order in which you create them?
130
434600
4360
07:31
I tried that. Value 1, value 2.
131
439480
2496
07:34
Pretty quickly I saw
that if you had more than a few values
that if you had more than a few values
132
442000
2762
07:36
you'd never remember
on the screen where things were.
on the screen where things were.
133
444786
2510
07:39
Then I said, why not instead of
allowing you to put values anywhere,
allowing you to put values anywhere,
134
447320
5296
07:44
I'll restrict you to a grid?
135
452640
1600
07:46
Then when you pointed to a cell,
136
454720
2216
07:48
the computer could put
the row and column in as a name.
the row and column in as a name.
137
456960
2720
07:52
And, if I did it like a map and put ABC
across the top and numbers along the side,
across the top and numbers along the side,
138
460640
6176
07:58
if you saw B7 in a formula,
139
466840
2896
08:01
you'd know exactly
where it was on the screen.
where it was on the screen.
140
469760
2200
08:04
And if you had to type the formula
in yourself, you'd know what to do.
in yourself, you'd know what to do.
141
472640
4240
08:09
Restricting you to a grid
helped solve my problem.
helped solve my problem.
142
477440
3080
08:13
It also opened up new capabilities,
like the ability to have ranges of cells.
like the ability to have ranges of cells.
143
481200
5600
08:19
But it wasn't too restrictive --
144
487360
1576
08:20
you could still put any value,
any formula, in any cell.
any formula, in any cell.
145
488960
4320
08:26
And that's the way we do it to this day,
almost 40 years later.
almost 40 years later.
146
494120
3840
08:31
My friend Bob and I decided that we were
going to build this product together.
going to build this product together.
147
499109
3667
08:34
I did more work figuring out exactly
how the program was supposed to behave.
how the program was supposed to behave.
148
502800
4416
08:39
I wrote a reference card
to act as documentation.
to act as documentation.
149
507240
3256
08:42
It also helped me ensure
that the user interface I was defining
that the user interface I was defining
150
510520
4776
08:47
could be explained concisely
and clearly to regular people.
and clearly to regular people.
151
515320
3479
08:51
Bob worked in the attic of the apartment
he rented in Arlington, Massachusetts.
he rented in Arlington, Massachusetts.
152
519520
5416
08:56
This is the inside of the attic.
153
524960
1720
09:00
Bob bought time on the MIT Multics System
154
528240
2776
09:03
to write computer code
on a terminal like this.
on a terminal like this.
155
531040
2720
09:06
And then he would download test versions
to a borrowed Apple II
to a borrowed Apple II
156
534400
3496
09:09
over a phone line
using an acoustic coupler,
using an acoustic coupler,
157
537920
3256
09:13
and then we would test.
158
541200
1160
09:14
For one of these tests I prepared
for this case about the Pepsi Challenge.
for this case about the Pepsi Challenge.
159
542920
4720
09:20
Print wasn't working yet,
so I had to copy everything down.
so I had to copy everything down.
160
548720
2920
09:24
Save wasn't working,
so every time it crashed,
so every time it crashed,
161
552480
2416
09:26
I had to type in all of the formulas
again, over and over again.
again, over and over again.
162
554920
3000
09:30
The next day in class, I raised my hand;
I got called on, and I presented the case.
I got called on, and I presented the case.
163
558240
3976
09:34
I did five-year projections.
I did all sorts of different scenarios.
I did all sorts of different scenarios.
164
562240
3576
09:37
I aced the case.
VisiCalc was already useful.
VisiCalc was already useful.
165
565840
3680
09:42
The professor said, "How did you do it?"
166
570160
2600
09:45
Well, I didn't want to tell him
about our secret program.
about our secret program.
167
573469
2667
09:48
(Laughter)
168
576160
1520
09:50
So I said, "I took this and added this
169
578200
1856
09:52
and multiplied by this
and subtracted that."
and subtracted that."
170
580080
2096
09:54
He said, "Well,
why didn't you use a ratio?"
why didn't you use a ratio?"
171
582200
2096
09:56
I said, "Hah! A ratio --
that wouldn't have been as exact!"
that wouldn't have been as exact!"
172
584320
3016
09:59
What I didn't say was,
"Divide isn't working yet."
"Divide isn't working yet."
173
587360
2576
10:01
(Laughter)
174
589960
3096
10:05
Eventually, though,
we did finish enough of VisiCalc
we did finish enough of VisiCalc
175
593080
3856
10:08
to be able to show it to the public.
176
596960
1840
10:11
My dad printed up a sample reference card
177
599440
1976
10:13
that we could use as marketing material.
178
601440
2000
10:16
In June of 1979, our publisher
announced VisiCalc to the world,
announced VisiCalc to the world,
179
604280
5776
10:22
in a small booth at the giant National
Computer Conference in New York City.
Computer Conference in New York City.
180
610080
4120
10:26
The New York Times had
a humorous article about the conference.
a humorous article about the conference.
181
614800
4160
10:31
"The machines perform
what seem religious rites ...
what seem religious rites ...
182
619480
2456
10:33
Even as the believers gather,
183
621960
1381
10:35
the painters in the Coliseum sign room
are adding to the pantheon,
are adding to the pantheon,
184
623365
3096
10:38
carefully lettering 'VISICALC'
in giant black on yellow.
in giant black on yellow.
185
626485
3171
10:41
All hail VISICALC!"
186
629680
1816
10:43
(Gasp) New York Times:
"All hail VISICALC."
"All hail VISICALC."
187
631520
3576
10:47
(Laughter)
188
635120
1496
10:48
That was the last mention
of the electronic spreadsheet
of the electronic spreadsheet
189
636640
4256
10:52
in the popular business press
for about two years.
for about two years.
190
640920
3896
10:56
Most people didn't get it yet.
191
644840
2136
10:59
But some did.
192
647000
1200
11:00
In October of 1979, we shipped VisiCalc.
193
648920
4200
11:05
It came in packaging
that looked like this.
that looked like this.
194
653880
2816
11:08
And it looked like this
running on the Apple II.
running on the Apple II.
195
656720
2480
11:12
And the rest, as they say, is history.
196
660000
1960
11:14
Now, there's an awful lot
more to this story,
more to this story,
197
662360
2096
11:16
but that'll have to wait for another day.
198
664480
2056
11:18
One thing, though, Harvard remembers.
199
666560
2240
11:21
Here's that classroom.
200
669400
1200
11:23
They put up a plaque
to commemorate what happened there.
to commemorate what happened there.
201
671240
3440
11:27
(Applause)
202
675640
2400
11:36
But it also serves as a reminder
203
684400
2936
11:39
that you, too, should take
your unique backgrounds, skills and needs
your unique backgrounds, skills and needs
204
687360
5496
11:44
and build prototypes to discover
and work out the key problems,
and work out the key problems,
205
692880
5256
11:50
and through that, change the world.
206
698160
2120
11:53
Thank you.
207
701040
1216
11:54
(Applause)
208
702280
4600
ABOUT THE SPEAKER
Dan Bricklin - Software pioneerDan Bricklin helped fuel the rapid growth of the personal computer industry.
Why you should listen
Dan Bricklin is best known for codeveloping VisiCalc, the pioneering electronic spreadsheet, while he was a student at the Harvard Business School. VisiCalc, codeveloped with his friend Bob Frankston whom he met at MIT, is widely credited for fueling the rapid growth of the personal computer industry.
Bricklin helps create products that make it easier for business people to build mobile applications in his current role as CTO of Alpha Software Corporation. He is also president of Software Garden, Inc., a small consulting firm and developer of software applications that he founded in 1985. Its most popular products are Note Taker HD for the Apple iPad and before that Dan Bricklin's Demo Program for IBM PCs. In the past, Bricklin was cofounder of pen computer application developer Slate Corporation and founder of website builder developer Trellix Corporation.
Dan Bricklin | Speaker | TED.com