按年被提到
20192019 · 1 次2026
系统、数据库与网络›表格、数据草图与数据集·arXiv:1901.11100 · cs.PL

ExceLint: Automatically Finding Spreadsheet Formula Errors

Daniel W. Barowy, Emery D. Berger, Benjamin Zorn · 2019
开始阅读 ↗PDFalphaXiv 讨论
被提及 · 2 人首次 2019-02-02 · 最近 2020-10-17
2不同的人
2活跃月份
2讨论串
48被引(OpenAlex)
arXiv 摘要(候选层不写导读)

Spreadsheets are one of the most widely used programming environments, and are widely deployed in domains like finance where errors can have catastrophic consequences. We present a static analysis specifically designed to find spreadsheet formula errors. Our analysis directly leverages the rectangular character of spreadsheets. It uses an information-theoretic approach to identify formulas that are especially surprising disruptions to nearby rectangular regions. We present ExceLint, an implementation of our static analysis for Microsoft Excel. We demonstrate that ExceLint is fast and effective: across a corpus of 70 spreadsheets, ExceLint takes a median of 5 seconds per spreadsheet, and it significantly outperforms the state of the art analysis.

候选层:至少 2 个不同的人、在 2 个不同月份提到过,还没到主书架的 3 人 3 个月。没有做立场标注,所以只写“被提及”。

HN 书评

推荐在前,同类按时间 · 每篇最多保留 20 条,统计用全部提及
评论milesvp · 2020-10

“Obligatory link to excelint/checkcell threads. https://news.ycombinator.com/item?id=20491091 https://news.ycombinator.com/item?id=22431500 https://arxiv.org/abs/1901.11100 One of the interesting takeaways from Emery Berger's talk, is that he was able to replicate to 2 decimal places a published spreadsheet transcription error rate of 5.26% of cells ha…”

Excel warriors who save governments and companies from spreadsheet errors原评论 ↗
被提交为 story · 1 次