Managers & Directors

No More Black Boxes

Do you have spreadsheets that have become crucial to your operations but nobody fully understands how they work? Many organizations have employees working on spreadsheets where they enter values in some cells and get results in other cells, but they don’t know what goes on in-between, this is called a black box. They trust that the long-gone employee who developed the spreadsheet made no errors, but research shows that about 90% of spreadsheets contain errors. Re-engineering those spreadsheets with the SSMI methodology will give you a clear picture. It can even be part of satisfying requirements for regulators, governments and organizations, like SOX and Basel III.

Manage Spreadsheets as Assets

Following the methodology automatically creates documentation for the spreadsheet: The Formula Diagram and the Formula List. Therefore, handing off the responsibility for the spreadsheet from one employee to another is a lot easier, because the new employee can fully understand how the spreadsheet works. Furthermore, you can keep track of the spreadsheet’s functional changes by keeping previous versions of its Formula Diagram. Your employees can easily re-use a previous Formula Diagram, and its corresponding spreadsheet, when they start a new project. They avoid having to spend time to develop another model from scratch. Their spreadsheets will also be easier to maintain: they start by modifying the Formula Diagram and then they know exactly what needs to be done in the spreadsheet.  They get a better understanding of the impact of their changes.

Making Sure the Spreadsheets are Correct

Have you ever stood next to employees who were trying to explain their spreadsheets, going from cell to cell, repeatedly describing what the coordinates in a formula meant? You may have nodded your head a few times and had the impression that the spreadsheet was right. Understanding how a spreadsheet works by looking at its Formula Diagram and its Formula List is much easier.

Increased Productivity and Reliability

Following the SSMI methodology does not require extra work. After all, they need to create variables and their formulas one way or another, and they have to enter them in the spreadsheet. Instead of doing both at the same time, they now do them separately. They will even save time by avoiding those “What was I doing?” moments when they switch from entering a formula in their spreadsheet to the creative task of figuring out which new variable to create.

Get in Touch

Do you have employees that develop spreadsheets and you want to help them work better? If you are interested, we offer in-house workshops. Email us at or fill out the contact form.