Register for free to
view the full innovation profile.
EQUS is an Excel add-in that visualises the working of spreadsheet formulae and helps understand what is being computed and trace the origins of spreadsheet errors.
About
The EQUS add-in works in Excel and visualises any formula selected. This allows the user to see what's actually being computed. This is invaluable if you are working with someone else's sheet trying to understand it. Also, if you've a error in a sheet you can visually trace cause of the problem. It is estimated that 80% spreadsheets have errors, EQUS will help to avoid so errors and understand how your spreadsheet models work.
Key Benefits
The benefits are that a simple visualisation of your spreadsheet formula is far easier way of seeing how your formula is structured and how it operates. Without the EQUS visualisation you are left having to work out for yourself whether the value you're getting is that the one you intended. For the users this means a quicker understanding, less spreadsheet errors and less mistakes. Overall greater confidence in the spreadsheet do what you want.
Applications
EQUS was developed for the education and training market as a tool to help learners and tutors. Feedback has been very positive. Many companies model and plan using various spreadsheets. However, their correctness and accuracy is rarely checked. When a mistake is spotted, it is often very difficult to unpick the cause of it. EQUS automatically shows what formula are doing and thus helps users confirm that they are making the right computations and spot errors when something goes wrong. This is particular value when a spreadsheet has been developed by someone and users are guessing as to what's going on.