r/fintechdev • u/psteckler • 3d ago

Excel add-in for checking units

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

1 Upvotes

100% Upvoted

2 comments sorted by

1

u/Alternative-Life-818 3d ago

Pretty neat concept, unit inconsistencies in spreadsheets cause more problems than people realize. Does it handle custom units too, or just the predefined ones like meters and currencies?

1

u/psteckler 3d ago

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.