Spreadsheets: error-ridden models take a toll | 电子表格:错误百出的模型造成了损失 - FT中文网
登录×
电子邮件/用户名
密码
记住我
请输入邮箱和密码进行绑定操作:
请输入手机号码,通过短信验证(目前仅支持中国大陆地区的手机号):
请您阅读我们的用户注册协议隐私权保护政策,点击下方按钮即视为您接受。
FT商学院

Spreadsheets: error-ridden models take a toll
电子表格:错误百出的模型造成了损失

Sometimes, tools meant to help with accuracy add to the problem
有时,旨在帮助提高准确性的工具会使问题更加严重。
Spreadsheets are staples of business life. But — as with sausages and laws — it is harder to respect them if you know how they are made. Users are overwhelmingly self-taught. The migraine-inducing slog of plugging numbers and formulas to a tight deadline invites shortcuts. Unsurprisingly, errors are rife. Research suggests nine out of 10 spreadsheets contain a mistake.
电子表格是商业生活的必需品。但是,就像香肠和法律一样,如果你知道它们是如何制作的,你就很难尊重它们。绝大多数用户都是自学成才的。在紧迫的截止日期前填入数字和公式,这种让人头疼的苦差事容易让人走捷径。不出所料,错误频发。研究表明,90%的电子表格都存在错误。
Iceland mispriced its sale of a slug of Islandsbanki shares earlier this year, after an Excel spreadsheet omitted investors’ offers that had included “foreign commas or amounts defined as text”. The impact is disputed but might have cost as much as $16mn.
今年早些时候,冰岛在出售Islandsbanki的部分股票时定价有误,原因是一份Excel电子表格漏掉了包含“定义为文本的外国逗号或金额”投资者报价。其影响是有争议的,但可能花费高达1600万美元。
Such failures of data error cleaning and testing are all too common, according to the European Spreadsheet Risks Interest Group (Eusprig). This group of researchers has been sounding the alarm for 20 years. High on its list of spreadsheet horror stories was JPMorgan Chase’s $6.2bn “London Whale” trading losses in 2012. That featured an error-ridden model that required data to be manually copied and pasted from one spreadsheet.
据欧洲电子表格风险利益组织(Eusprig)称,这种数据错误清理和测试的失败太常见了。这群研究人员20年来一直在敲警钟。摩根大通(JPMorgan Chase) 2012年62亿美元的“伦敦鲸”(London Whale)交易亏损,是该公司电子表格恐怖事件中最吓人的一件。那是一个错误百出的模型,需要从一个电子表格中手动复制和粘贴数据。
A spectacular blunder in an influential Harvard University paper on public debt and growth cast doubt on a cornerstone of the austerity policies introduced after the financial crisis. The mistake was a simple one: the accidental omission of five rows of data  when calculating an average.
哈佛大学(Harvard University)一篇有关公共债务与增长的颇具影响力的论文中出现了一个惊人的错误,让人们对金融危机后推出的紧缩政策的基石产生了怀疑。这个错误很简单:在计算平均值时意外遗漏了5行数据。
Another nightmarish slip-up arose when Public Health England misplaced nearly 16,000 Covid-19 test results. That was because someone had used the wrong Excel file format, XLS, which only has about 64,000 rows, so some cases vanished off the bottom.
还有一个噩梦般的失误是英国公共卫生署(Public Health England)丢失了近1.6万份疫情检测结果。这是因为有人使用了错误的Excel文件格式XLS,这种格式只有大约6.4万行,所以一些检测结果从底部消失了。
Sometimes, tools meant to help with accuracy add to the problem. Autocorrect errors are the bane of geneticists. Nearly a third of publications featuring gene names contain errors where the abbreviated form of a gene’s name is incorrectly recognised as a date. For example, SEPT4 (septin 4) is changed to 4-Sep.
有时,旨在帮助提高准确性的工具会使问题更加严重。自动校正错误让遗传学家感到头疼。近三分之一的以基因名命名的出版物含有错误,基因名的缩写形式被错误地识别为日期。例如,SEPT4 (septin 4)被改为4-Sep(9月4日)。
People do not take spreadsheets seriously enough, says Eusprig’s programme chair, Simon Thorne. Unlike software engineers who typically spend 40 per cent of their time testing their coding, many spreadsheet users hardly bother.
欧洲电子表格风险利益组织主席西蒙•索恩(Simon Thorne)表示,人们对电子表格的重视程度还不够。软件工程师通常会花40%的时间来测试他们的代码,与之不同的是,许多电子表格用户几乎不会为此费心。
Moreover, people are bad at picking up their own errors. Self-review catches, at most, about two-thirds of errors, according to research by Ray Panko of the University of Hawaii. Overconfidence is at the heart of the problem. People tend to be proudly aware of errors they fix. But they have no idea of how many remain.
此外,人们不善于发现自己的错误。根据夏威夷大学(University of Hawaii)的雷•潘科(Ray Panko)的研究,自我检查最多能发现三分之二的错误。过度自信是问题的核心。人们往往会自豪地意识到他们所修正的错误。但他们不知道还有多少错误没有被发现。
版权声明:本文版权归FT中文网所有,未经允许任何单位或个人不得转载,复制或以任何其他方式使用本文全部或部分,侵权必究。

令人大开眼界的时间测量新科学

在科罗拉多州没有窗户的实验室里,摆放着20台原子钟,全世界都在用它们来计时。它们几乎跟不上。

特朗普政府财政部长之争的内幕

贝森特在当选总统的宫廷内部经过激烈的影响力争夺战后获胜。

比特币和香蕉成为新的炫耀性消费品

两者都加入了无用物品的精英世界,价格越高越受欢迎。

Bluesky趁X用户流失迅速崛起,Threads未能抓住机会

在X遭遇大量用户流失之际,Meta旗下的Threads却将机会让给了只有20个员工的Bluesky。

拜登希望通过卸任前的政策突击保护自己的政治遗产不被特朗普破坏

即将离任的总统为乌克兰进行最后的推动,并寻求新的司法任命和制造业补贴。

高盛因投资北伏而损失9亿美元

这家美国银行是本周申请破产保护的瑞典电池制造商的第二大股东。
设置字号×
最小
较小
默认
较大
最大
分享×