ExceLint - Automatically Finding Spreadsheet Formula Errors
summary
ExceLint is a Microsoft Excel plugin that implements a static analysis for spreadsheet formula errors, partitioning sheets into rectangular regions and computing fingerprint vectors to detect surprising deviations via Shannon entropy. It provides a global view visualization plus a proposed fix tool that simulates reference repairs (omit/wrong/add). On a 70-spreadsheet corpus it runs in a median 8 seconds per file, finds 295 more errors than Custodes, and reports median precision 100% (mean 61% vs Custodes’ 20%).
AI-written summary · about
chapters (10)
- 0:00Start
- 3:12Global View
- 6:17The Proposed Fix Tool
- 7:02Built-In Error Finder
- 7:20How Does Excels Error Finder Work
- 8:16How Does It Find Formula Errors
- 10:25Reference Errors
- 13:05Measure the Entropy of a Spreadsheet
- 15:03Proposed Fixes
- 15:36Fixing a Formula
related talks
44mSpreadsheets are Code
48mSpreadsheets for Developers
16mEXCELsioR!
39mSpreadsheets for developers
48mSmart Spreadsheets
40mSource Control and Continuous Deployment... for a Spreadsheet?!
17mFive signs your spreadsheet might smell (and what you can do about it)
54mLook smarter: deliver your work in Excel