StrongTyping for Excel spreadsheets
Strong Typinghas been developed to help highlight errors before they are incorporated into spreadsheet models and help create a reliable baseline for auditing spreadsheets.
An add-in which allows formulas to be augmented with type meta-data to help ensure formulas work as intended or to highlight logical issues with formulas in a spreadsheet.
Benefits at a glance:
- Use techniques from programming to improve error detection rates in models
- Identify changes made by others that introduce errors
- Create templates from models to re-use proven formulas
- Document your models more thoroughly
Huge numbers of people use Excel and it’s a testament to Excel’s ease of use that so many people feel able to use it. The problem is, because it is easy to use it only sees a list of numbers. Moreover, it makes assumptions on the user’s behalf which makes it really easy to do stupid things like add apples and oranges.
StrongTyping helps highlight logical inconsistences within and between formulas so you know which need to be fixed. Once the spreadsheet has been Strongly Typed and validated, spreadsheet models can be saved as a template which can be reused and shared with others.