I wonder if "spreadsheet unit tests" are/should be a thing.
They are a thing [1]. We use MintData spreadsheets for a large part of our regression test suite that tests MintData itself.
A bit meta, but yes, spreadsheets can definitely be used for the equivalent of what "unit tests" are in code.
Interestingly, we also have "integration tests" in our spreadsheets, but this has more to do with the fact that MintData spreadsheets have native API calling ability, so we can test with external services end-to-end.
[1] MintData, https://mintdata.com
Is there an intro plan that isn't $95 / month? I want to pay money for this, but there are alternatives at that pricing level.
Actually even paying $1140 ($95 * 12 months) for the on-premise version is better.
https://medium.com/guesstimate-blog/introducing-guesstimate-...