Excel add-in

Bring clarity to your spreadsheets with an AI-powered add-in that flags unit errors

Spreadsheets shouldn't leave you guessing whether your units are consistent.

4 min readMicrosoft Excel | Help & Support with your Formula, Macro, and VBA problems | A Reddit Community

Spreadsheets are the quiet backbone of modern decision-making, yet they remain surprisingly fragile. A misplaced decimal or a mismatched unit, dollars next to euros, meters next to kilograms, can cascade into flawed reports, costly errors, and lost trust. That's why the Excel add-in created by Paul Steckler deserves attention. It is not a flashy product launch or a Master the Code by Slowing Down in the Age of AI meditation on craft. It is a practical tool built on research from the 2004 International Conference on Software Engineering, where Steckler was an author, and it directly addresses a problem that has quietly plagued analysts for decades: unit inconsistency.

The add-in scans spreadsheets for mismatched currencies and engineering units, flagging errors before they propagate. For anyone who has ever caught a $1,000 line item that was actually £1,000, or worse, failed to catch it, this is a concrete win. The tool is available now for Excel on Windows, Mac, and Office 365 on the Web, with a manifest on GitHub and a user guide to follow. It is open-source, transparent, and built by someone who has spent years thinking about how software can prevent human oversight. That matters because, as How engineering leaders are shaping production systems for an agentic future reminds us, the most resilient systems are those that anticipate failure modes before they happen. Steckler's add-in does exactly that for the spreadsheet layer of your workflow.

Our take is straightforward: this is the kind of innovation that should be standard, not optional. Spreadsheet tools have grown more powerful over decades, yet basic hygiene checks, unit consistency, cross-reference validation, formula auditing, remain manual chores. A Typo in ICLR's Template Has Persisted Since 2019 shows how even prestigious organizations can let small errors fester for years. The difference here is that Steckler is not waiting for Microsoft or Google to add a feature. He is shipping a fix, inviting users to test it, and asking for feedback on GitHub. That is action-oriented, human-centered design in practice.

What makes this add-in particularly compelling is its specificity. It does not promise to transform your entire data workflow. It solves one thing, unit errors, and solves it well. The underlying technology draws on academic research, but the implementation is practical and immediately useful. For teams working with financial models, engineering calculations, or any spreadsheet that crosses borders or disciplines, this tool could prevent the kind of mistake that gets buried in a footnote and discovered during a quarterly review.

The open question is adoption. Will users take the time to install a manifest and learn a new add-in when they have been living with the risk for years? That depends on how painful the current experience is. For anyone who has already felt the sting of a unit error, the answer is clear. The concrete point to watch: whether Microsoft or Google eventually bake this logic into their core products. If they do, Steckler's work will have been the proof of concept. If they don't, his add-in remains the best option, and a reminder that sometimes the most important innovations come from individual expertise, not corporate roadmaps.

From Microsoft Excel | Help & Support with your Formula, Macro, and VBA problems | A Reddit Community

I've created an Excel add-in to check the consistency of units used in Excel spreadsheets. Units include currencies (like dollars, pounds, euros) and engineering units (like meters, pounds, kilograms). The add-in will flag errors when units are used inconsistently.

The technology is roughly based on a paper at Intl Conf on Software Engineering 2004, on which I was an author. I've taken some of the ideas there and introduced others.

Read the original at Microsoft Excel | Help & Support with your Formula, Macro, and VBA problems | A Reddit Community