For some years now I have been monitoring the postings of the EUSPRIG. It strikes me that many of the risks of using spreadsheets would be greatly reduced or even completely removed if spreadsheets would use built-in quality measures similar to those found in Smia.
Obviously, many spreadsheet models fail due to human mistakes. The pity is that spreadsheets allow users to make mistakes that modelling software could have - and should have - prevented automatically.
In this blog I will from time to time post examples of real-world spreadsheet mistakes, and explain how they could have been detected more easily, or even prevented, if Smia had been used as the modelling tool rather than a spreadsheet.
Smia unique features:
- reduce the risk of making errors when building models,
- increase the chance of spotting errors when inspecting models, and
- reduce the risk of introducing errors when modifying models.