TEDxBeaconStreet
Dan Bricklin: Meet the inventor of the electronic spreadsheet
丹·布里克林: 与电子表格的发明人见个面
Filmed:
Readability: 4.1
1,147,045 views
当丹·布里克林共同开发了VisCalc，世界上第一版电子表格的时候，也就是你们现在可能每天正在使用的微软Excel表或是谷歌表的爷爷辈，他改变了世界。加入这个软件工程师和他的计算传奇故事当中，看看他是如何探索错综复杂的第一份工作，那些关于那些白日梦和家庭作业的问题，以及这些最终如何引领他创造了这个革命性的发明。
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.
你们中有多少人用过
比如Microsoft Excel
比如Microsoft Excel
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
早在1978年，
我就开始设想一个点子，
我就开始设想一个点子，
00:36
that eventually became VisiCalc.
8
24520
2400
它最终变成了VisiCalc
（第一款电子表格办公软件）。
（第一款电子表格办公软件）。
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
叫做 Apple II 的个人
笔记本电脑新产品上运行了。
笔记本电脑新产品上运行了。
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
华尔街日报刊登了一篇报道，
说你一定知道VisiCalc是什么，
你也许正在使用它。
你也许正在使用它。
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
1990年，史蒂夫・乔布斯
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
“VisiCalc推动了苹果的成功，
它的作用胜过了任何其它单一事件。”
它的作用胜过了任何其它单一事件。”
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
史蒂夫说：“如果VisiCalc
是写给其他电脑公司的，
是写给其他电脑公司的，
你们现在就该在采访其他人了吧。”
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
所以，把私人电脑搬上商业舞台，
VisiCalc发挥了大作用。
VisiCalc发挥了大作用。
这一切是怎么发生的？
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
我第一次学会编程
是在1966年，那是我只有15岁——
是在1966年，那是我只有15岁——
大概是在拍了这张照片几个月之后。
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
在伍德斯托克的乡野中过了一阵子之后，
我去了麻省理工（MIT）上大学。
我去了麻省理工（MIT）上大学。
01:51
where to make money,
I worked on the Multics Project.
I worked on the Multics Project.
29
99520
3080
为了赚钱，我参与了Multics项目。
01:55
Multics was a trailblazing
interactive time-sharing system.
interactive time-sharing system.
30
103320
5016
Multics是一个开创性的
交互式分时系统。
交互式分时系统。
你们听说过Linux
和Unix操作系统吗？
和Unix操作系统吗？
02:00
Have you heard of the Linux
and Unix operating systems?
and Unix operating systems?
31
108360
3176
他们的前身就是Multics。
02:03
They came from Multics.
32
111560
1240
02:05
I worked on the Multics versions
33
113320
2296
我在Multics主要致力于研究
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
从MIT毕业之后，
02:19
I went to work for
Digital Equipment Corporation.
Digital Equipment Corporation.
38
127840
2840
我去了数字设备公司（DEC）工作。
02:23
At DEC, I worked on software
39
131320
3176
在DEC，我主攻一个用于
计算机新领域，
文稿排版的软件。
文稿排版的软件。
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
这些实战经历
与我在MIT实验室里
所体验到的大相径庭。
所体验到的大相径庭。
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
DEC第一个文字处理器软件的
项目主管，又是一个新领域。
项目主管，又是一个新领域。
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
在DEC之后，
我又去了一家小公司工作，
我又去了一家小公司工作，
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
但是我一直以来都想和我在MIT，
Multics项目中认识的好友
Multics项目中认识的好友
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
所以，我决定回到学校，
尽我所能的学习一下商业经营。
尽我所能的学习一下商业经营。
之后，在1977年的秋天，
03:29
And in the fall of 1977,
57
197200
2776
我加入了哈佛商学院的MBA项目。
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
所以，跟着其它87个人同坐在
一个教室里，我经常开小差。
一个教室里，我经常开小差。
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
我尝试了。数值1，数值2。
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
然后，如果我把它做的和地图一样，
在顶上横向生成ABC，侧面纵向生成数字，
在顶上横向生成ABC，侧面纵向生成数字，
07:58
if you saw B7 in a formula,
139
466840
2896
那么当你在公式中看到B7时，
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
这就是我们一直到今天
都在做的，将近40年之后。
都在做的，将近40年之后。
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
鲍勃购买了MIT，Multics的分时系统，
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
将测试版本下载到借来的Apple II电脑上，
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
我成功的做出了这个案例，
VisCalc已经很有用了。
VisCalc已经很有用了。
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
最后，总而言之，我们确实
把VisCalc做的足够完整了，
把VisCalc做的足够完整了，
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
在1979年的六月，我们的出版商
在纽约大型计算机会议上的
在纽约大型计算机会议上的
一个小摊位上，
把VisCalc介绍给了全世界。
把VisCalc介绍给了全世界。
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
仔细地在巨大的黄板上写下
巨大黑色的‘VISCALC’字样。
巨大黑色的‘VISCALC’字样。
10:41
All hail VISICALC!"
186
629680
1816
所有人都在为VISCALC喝彩！”
10:43
(Gasp) New York Times:
"All hail VISICALC."
"All hail VISICALC."
187
631520
3576
那可是纽约时报啊：
“所有人都在喝彩，VISCALC！”
“所有人都在喝彩，VISCALC！”
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
在1979年10月，我们发售了VisCalc。
11:05
It came in packaging
that looked like this.
that looked like this.
194
653880
2816
它的包装刚到的时候是这样的。
当它在Apple II上运行的时候是这样的。
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