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

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)的研究,自我检查最多能发现三分之二的错误。过度自信是问题的核心。人们往往会自豪地意识到他们所修正的错误。但他们不知道还有多少错误没有被发现。
版权声明:本文版权归manbetx20客户端下载 所有,未经允许任何单位或个人不得转载,复制或以任何其他方式使用本文全部或部分,侵权必究。

特朗普任命鲍威尔批评人士担任最高manbetx20客户端下载 职务

特朗普任命manbetx20客户端下载 学家斯蒂芬•米兰担任manbetx20客户端下载 顾问委员会主席,并任命亿万富翁投资者斯蒂芬•费恩伯格担任国防部副部长。

会计师事务所对美国资格考核改革提出担忧

代表“四大”的机构CAQ批评称,改革美国会计师资格规则的计划可能会使公司面临歧视诉讼,并增加入行障碍。

特朗普和海湖庄园的力量

这位前房地产开发商非常了解如何将建筑和空间有效地用作宣传。

为2024年的世界感到高兴的十个理由

从巴黎圣母院的修复到《抑制热情》的大结局,这一年其实并不算太糟。

2025年德国大选:主要的竞选承诺是什么?

各大政党提出了截然不同的计划,以重振欧洲最大manbetx20客户端下载 体的命运。

“市场恐慌”:巴西财政赤字导致货币跌至新低

总统在面临其第三个任期内的最大挑战。
设置字号×
最小
较小
默认
较大
最大
分享×