The Microsoft researcher was, by his own admission, already going through something of a midlife crisis. But it was the woman sitting next to him on a flight who, with her spreadsheet, changed the course of his career. His new path would put him at the centre of an effort to bring the power of computer code to those who are unable to write it themselves, which is to say the vast majority of us.
這位微軟(Microsoft)研究員自己承認(rèn)，當(dāng)時(shí)他已經(jīng)在經(jīng)歷某種中年危機(jī)。但正是飛機(jī)上坐在他旁邊的那位女士用她的電子表格改變了他的職業(yè)生涯。新的職業(yè)道路將讓他處于一項(xiàng)努力的核心，目的是幫助那些無(wú)法自己編程的人——也就是我們絕大多數(shù)人——獲得計(jì)算機(jī)代碼的力量。
I met Sumit Gulwani in Vienna this month at the annual workshop for Software Engineering Methods in Spreadsheets, where he was the keynote speaker. He holds a PhD in computer science from the University of California, Berkeley. It was this, along with his role at Microsoft, that so impressed his fellow passenger when he was returning from a seminar five years ago. With such credentials, surely he could help her with the text manipulations she was struggling with in an Excel spreadsheet?
我在本月召開(kāi)的“電子表格軟件工程方法”維也納年度研討會(huì)上遇到了素密•古爾瓦尼(Sumit Gulwani)，他是基調(diào)演講人。他擁有美國(guó)加州大學(xué)伯克利分校(University of California, Berkeley)計(jì)算機(jī)科學(xué)的博士學(xué)位。正是這一學(xué)位，加上他在微軟的職位，在5年前出席一個(gè)研討會(huì)后的返程中打動(dòng)了與鄰座的乘客。憑借這樣的資歷，他當(dāng)然能幫助她解決她搞不定的Excel電子表格中的文本操作，不是嗎？
“At that time, I had to excuse myself out of the situation,” he tells me when we sit down in a courtyard to talk after his speech. “I’d never used Excel before in my life.”
古爾瓦尼演講完之后，我們?cè)谝粋€(gè)院子里坐下來(lái)交談。他告訴我：“當(dāng)時(shí)我不得不抱歉地說(shuō)自己處理不了。我此前從未用過(guò)Excel?！?BR> Although Gulwani couldn’t help, he was intrigued enough to change jobs. He went from helping programmers at Microsoft to helping non-programmers, enabling users to perform simple, repetitive tasks more easily. Flash Fill, one of the tools that Gulwani’s team developed, was released in Excel 2013. To get an idea of what it does, imagine organising an event. You have a list of the guests’ email addresses but, in order to make a check-in sheet for the event, what you want is a list of their names in the format “l(fā)ast name, first name”. Although Excel functions can do this, some users will not know how.
盡管沒(méi)有幫上忙，但古爾瓦尼覺(jué)得好奇，于是改了行。他從幫助微軟的程序員改行為幫助非程序員，讓用戶(hù)更容易執(zhí)行重復(fù)性的簡(jiǎn)單任務(wù)。Flash Fill是古爾瓦尼團(tuán)隊(duì)開(kāi)發(fā)的工具之一，它包括在Excel 2013版本中。要了解它的用途，想象一下組織一場(chǎng)活動(dòng)。你有客人的電子郵件地址名單，但為了制作一份簽到表格，你想要一份“姓在前名在后”格式的名單。盡管Excel的功能能做到這一點(diǎn)，但一些用戶(hù)不知道怎么做。
With Flash Fill, you type in an example or two of what you want as “output” from the email inputs, and the tool will fill in the rest. For instance, once you have written “Clinton, Hillary” in the column after hillary.clinton@secretserver.com, Flash Fill will automatically produce “Trump, Donald” from donald.trump@usausa.com — all without having to enter a single formula. This is called “programming by example”.
有了Flash Fill，你可以自己打出一兩個(gè)樣例，說(shuō)明你從電郵地址“輸入”希望得到什么“輸出”，這個(gè)工具就會(huì)填充整個(gè)名單。例如，一旦你在hillary.clinton@secretserver.com后的那一欄寫(xiě)入“克林頓，希拉里”，F(xiàn)lash Fill就會(huì)自動(dòng)從donald.trump@usausa.com后的那一欄生成“特朗普，唐納德”——這些都不用輸入任何公式就能完成。這被稱(chēng)為“樣例編程”(programming by example)。
Developments such as these will, according to Gulwani, “keep control of the digital divide”, preventing the existing split between those who can programme and those who cannot from growing even wider.
古爾瓦尼表示，這些工具的開(kāi)發(fā)將會(huì)“控制數(shù)字鴻溝”，阻止那些可以編程和那些無(wú)法編程者之間的現(xiàn)有差距越來(lái)越大。
But I fear that, while a tool such as Flash Fill is empowering, it is also in its present form something of a “black box” — meaning it is unclear how it calculates outputs from given inputs. As such, it does not (yet) encourage a user to go a step further and learn how to adapt the code Flash Fill uses in order to perform different tasks.
但我擔(dān)心，盡管Flash Fill等工具功能強(qiáng)大，但就目前形式而言也是某種“黑匣子”，也就是說(shuō)不清楚它如何從給定輸入計(jì)算出結(jié)果。這樣的話(huà)，它（仍）沒(méi)有鼓勵(lì)用戶(hù)更進(jìn)一步，學(xué)會(huì)如何改寫(xiě)Flash Fill的代碼來(lái)執(zhí)行不同的任務(wù)。
Another speaker at the Sems conference had a radical idea about a different way in which spreadsheets could narrow the digital divide: take the elements that are most attractive about the application and use those to encourage non-programmers to code.
維也納研討會(huì)的另一位演講者對(duì)電子表格縮小數(shù)字鴻溝的不同方式有著激進(jìn)的看法：提煉出這款應(yīng)用中最吸引人的元素，用它們鼓勵(lì)非程序員編碼。
Professor Felienne Hermans, head of the Spreadsheet Lab at Delft University of Technology, notes that the “l(fā)iveness” and “directness” of spreadsheets makes them attractive to use. With spreadsheets, the results are instantly visible, or “l(fā)ive”, as you change numbers or formulas. You also see “directly” the entirety of the field of play — formulas, data, output — as you work. By contrast, when developing a website, there is distance between what is visible on the site and where you can edit the code that produces it.
荷蘭代爾夫特理工大學(xué)(Delft University of Technology)的電子表格實(shí)驗(yàn)室主管、教授費(fèi)列利安娜•埃爾曼(Felienne Hermans)指出，電子表格的“活躍感”和“直接性”使它們對(duì)用戶(hù)具有吸引力。用電子表格，只要你改變公式或數(shù)據(jù)，結(jié)果立即可見(jiàn)，也就是“活躍”的。你也能在工作時(shí)“直接”看到整個(gè)場(chǎng)景——公式、數(shù)據(jù)和輸出。相比之下，在開(kāi)發(fā)網(wǎng)站時(shí)，網(wǎng)站顯示內(nèi)容和你編寫(xiě)代碼的地方不在一個(gè)界面。
Hermans has co-authored a paper that proposes the development of an interface where a user can directly write code while a spreadsheet, in the same field of view, updates live. Encouragingly, Microsoft has hired Hermans for the summer, though the company won’t say anything about her work for them.
埃爾曼與他人合著了一篇論文，提議開(kāi)發(fā)用戶(hù)可以直接編碼的界面，同一場(chǎng)景中的電子表格即時(shí)更新。令人鼓舞的是，微軟今年夏季雇傭了埃爾曼，盡管該公司不會(huì)透露她的具體工作。
Another thing the company keeps quiet about are estimates of the number of spreadsheet users around the world. But there is a mention of “more than 750m Excel users” in an article by the company’s UK enterprise team.
該公司保持沉默的另一件事是對(duì)全世界電子表格用戶(hù)數(shù)量的估計(jì)。但該公司的英國(guó)企業(yè)團(tuán)隊(duì)在一篇文章中提到“逾7.5億Excel用戶(hù)”。
That is a lot of people to empower. And, while a helpful black box may grab and intrigue them, it is the development of a better, friendlier way to code in spreadsheets that I look forward to the most.
這意味著有很多人有待獲得編碼的力量。盡管一個(gè)有用的黑匣子可能引起他們的注意，并激發(fā)他們的興趣，但我最期望的是在電子表格中發(fā)展出更容易、更友好的編碼方式。
這位微軟(Microsoft)研究員自己承認(rèn)，當(dāng)時(shí)他已經(jīng)在經(jīng)歷某種中年危機(jī)。但正是飛機(jī)上坐在他旁邊的那位女士用她的電子表格改變了他的職業(yè)生涯。新的職業(yè)道路將讓他處于一項(xiàng)努力的核心，目的是幫助那些無(wú)法自己編程的人——也就是我們絕大多數(shù)人——獲得計(jì)算機(jī)代碼的力量。
I met Sumit Gulwani in Vienna this month at the annual workshop for Software Engineering Methods in Spreadsheets, where he was the keynote speaker. He holds a PhD in computer science from the University of California, Berkeley. It was this, along with his role at Microsoft, that so impressed his fellow passenger when he was returning from a seminar five years ago. With such credentials, surely he could help her with the text manipulations she was struggling with in an Excel spreadsheet?
我在本月召開(kāi)的“電子表格軟件工程方法”維也納年度研討會(huì)上遇到了素密•古爾瓦尼(Sumit Gulwani)，他是基調(diào)演講人。他擁有美國(guó)加州大學(xué)伯克利分校(University of California, Berkeley)計(jì)算機(jī)科學(xué)的博士學(xué)位。正是這一學(xué)位，加上他在微軟的職位，在5年前出席一個(gè)研討會(huì)后的返程中打動(dòng)了與鄰座的乘客。憑借這樣的資歷，他當(dāng)然能幫助她解決她搞不定的Excel電子表格中的文本操作，不是嗎？
“At that time, I had to excuse myself out of the situation,” he tells me when we sit down in a courtyard to talk after his speech. “I’d never used Excel before in my life.”
古爾瓦尼演講完之后，我們?cè)谝粋€(gè)院子里坐下來(lái)交談。他告訴我：“當(dāng)時(shí)我不得不抱歉地說(shuō)自己處理不了。我此前從未用過(guò)Excel?！?BR> Although Gulwani couldn’t help, he was intrigued enough to change jobs. He went from helping programmers at Microsoft to helping non-programmers, enabling users to perform simple, repetitive tasks more easily. Flash Fill, one of the tools that Gulwani’s team developed, was released in Excel 2013. To get an idea of what it does, imagine organising an event. You have a list of the guests’ email addresses but, in order to make a check-in sheet for the event, what you want is a list of their names in the format “l(fā)ast name, first name”. Although Excel functions can do this, some users will not know how.
盡管沒(méi)有幫上忙，但古爾瓦尼覺(jué)得好奇，于是改了行。他從幫助微軟的程序員改行為幫助非程序員，讓用戶(hù)更容易執(zhí)行重復(fù)性的簡(jiǎn)單任務(wù)。Flash Fill是古爾瓦尼團(tuán)隊(duì)開(kāi)發(fā)的工具之一，它包括在Excel 2013版本中。要了解它的用途，想象一下組織一場(chǎng)活動(dòng)。你有客人的電子郵件地址名單，但為了制作一份簽到表格，你想要一份“姓在前名在后”格式的名單。盡管Excel的功能能做到這一點(diǎn)，但一些用戶(hù)不知道怎么做。
With Flash Fill, you type in an example or two of what you want as “output” from the email inputs, and the tool will fill in the rest. For instance, once you have written “Clinton, Hillary” in the column after hillary.clinton@secretserver.com, Flash Fill will automatically produce “Trump, Donald” from donald.trump@usausa.com — all without having to enter a single formula. This is called “programming by example”.
有了Flash Fill，你可以自己打出一兩個(gè)樣例，說(shuō)明你從電郵地址“輸入”希望得到什么“輸出”，這個(gè)工具就會(huì)填充整個(gè)名單。例如，一旦你在hillary.clinton@secretserver.com后的那一欄寫(xiě)入“克林頓，希拉里”，F(xiàn)lash Fill就會(huì)自動(dòng)從donald.trump@usausa.com后的那一欄生成“特朗普，唐納德”——這些都不用輸入任何公式就能完成。這被稱(chēng)為“樣例編程”(programming by example)。
Developments such as these will, according to Gulwani, “keep control of the digital divide”, preventing the existing split between those who can programme and those who cannot from growing even wider.
古爾瓦尼表示，這些工具的開(kāi)發(fā)將會(huì)“控制數(shù)字鴻溝”，阻止那些可以編程和那些無(wú)法編程者之間的現(xiàn)有差距越來(lái)越大。
But I fear that, while a tool such as Flash Fill is empowering, it is also in its present form something of a “black box” — meaning it is unclear how it calculates outputs from given inputs. As such, it does not (yet) encourage a user to go a step further and learn how to adapt the code Flash Fill uses in order to perform different tasks.
但我擔(dān)心，盡管Flash Fill等工具功能強(qiáng)大，但就目前形式而言也是某種“黑匣子”，也就是說(shuō)不清楚它如何從給定輸入計(jì)算出結(jié)果。這樣的話(huà)，它（仍）沒(méi)有鼓勵(lì)用戶(hù)更進(jìn)一步，學(xué)會(huì)如何改寫(xiě)Flash Fill的代碼來(lái)執(zhí)行不同的任務(wù)。
Another speaker at the Sems conference had a radical idea about a different way in which spreadsheets could narrow the digital divide: take the elements that are most attractive about the application and use those to encourage non-programmers to code.
維也納研討會(huì)的另一位演講者對(duì)電子表格縮小數(shù)字鴻溝的不同方式有著激進(jìn)的看法：提煉出這款應(yīng)用中最吸引人的元素，用它們鼓勵(lì)非程序員編碼。
Professor Felienne Hermans, head of the Spreadsheet Lab at Delft University of Technology, notes that the “l(fā)iveness” and “directness” of spreadsheets makes them attractive to use. With spreadsheets, the results are instantly visible, or “l(fā)ive”, as you change numbers or formulas. You also see “directly” the entirety of the field of play — formulas, data, output — as you work. By contrast, when developing a website, there is distance between what is visible on the site and where you can edit the code that produces it.
荷蘭代爾夫特理工大學(xué)(Delft University of Technology)的電子表格實(shí)驗(yàn)室主管、教授費(fèi)列利安娜•埃爾曼(Felienne Hermans)指出，電子表格的“活躍感”和“直接性”使它們對(duì)用戶(hù)具有吸引力。用電子表格，只要你改變公式或數(shù)據(jù)，結(jié)果立即可見(jiàn)，也就是“活躍”的。你也能在工作時(shí)“直接”看到整個(gè)場(chǎng)景——公式、數(shù)據(jù)和輸出。相比之下，在開(kāi)發(fā)網(wǎng)站時(shí)，網(wǎng)站顯示內(nèi)容和你編寫(xiě)代碼的地方不在一個(gè)界面。
Hermans has co-authored a paper that proposes the development of an interface where a user can directly write code while a spreadsheet, in the same field of view, updates live. Encouragingly, Microsoft has hired Hermans for the summer, though the company won’t say anything about her work for them.
埃爾曼與他人合著了一篇論文，提議開(kāi)發(fā)用戶(hù)可以直接編碼的界面，同一場(chǎng)景中的電子表格即時(shí)更新。令人鼓舞的是，微軟今年夏季雇傭了埃爾曼，盡管該公司不會(huì)透露她的具體工作。
Another thing the company keeps quiet about are estimates of the number of spreadsheet users around the world. But there is a mention of “more than 750m Excel users” in an article by the company’s UK enterprise team.
該公司保持沉默的另一件事是對(duì)全世界電子表格用戶(hù)數(shù)量的估計(jì)。但該公司的英國(guó)企業(yè)團(tuán)隊(duì)在一篇文章中提到“逾7.5億Excel用戶(hù)”。
That is a lot of people to empower. And, while a helpful black box may grab and intrigue them, it is the development of a better, friendlier way to code in spreadsheets that I look forward to the most.
這意味著有很多人有待獲得編碼的力量。盡管一個(gè)有用的黑匣子可能引起他們的注意，并激發(fā)他們的興趣，但我最期望的是在電子表格中發(fā)展出更容易、更友好的編碼方式。