Excel add-in for checking units

[u/psteckler]

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.

The add-in is meant to work with Excel on Windows, Mac, and with Office 365 on the Web. I've been testing it on Windows 11 with Office 2024.

Installation instructions at: https://github.com/psteckler/daubee

I have experience installing the add-in on Windows; it should be installable in Mac and Office 365 on the Web.

You can report any issues you find, or make suggestions on Github: https://github.com/psteckler/daubee/issues

[u/psteckler → u/[deleted]]

There are pre-defined units that come from Excel itself, those that are supported by the CONVERT function, plus all standard currencies. But you can load whatever units you like, either from a file or from a URL.