PLEASE WAIT WHILE VIDEO TUTORIAL LOADS....

Go Back to the Spreadsheet Professional Page

Transcripts

In order to avoid the old adage of Garbage In Garbage Out, it is important to understand the inputs for any spreadsheet. Spreadsheet Professional can help do this by:

The Map reports help identify where the inputs are. The maps give you an overview of the entire spreadsheet and point out where the labels and text are, where the numbers (numeric) are, the input cells,  and where the formulas are. So in this spreadsheet you would wonder why there's a number sitting in the middle of a calculation section. It is also important to realise that it is now possible to  identify where all the inputs are, and check that they are the input numbers you expect to see.

The Calculations Tests Report in Spreadsheet Professional performs a number of tests to identify risky cells. One of the tests is to look for unused input values. So what it will do is go to every input value in your spreadsheet and check that it is being used in your spreadsheet. The risk exists that there is an input value that you believe is being used but is not being used.

The input report shows your spreadsheet with the calculations greyed out and the input cells identified and enumerated here so that you can see what the inputs are. In a similar report the exact same thing is done with the greying out of the formulas but now the input cells are blank. So you can now hand this out and request what inputs should be in your spreadsheet.

The formula tracer allows me to expand on and drill down into a calculation to understand what it is doing. If I click on that cell and activate the formula tracer I can see in a bubble diagram, what the calculation is doing and drill down into it, right down to the inputs. So I can understand what inputs affect my spreadsheet.

The Spreadsheet Painter allows me to color my cells  depending on what the contents is. In this spreadsheet it is not clear what cells are calculations and what cells are inputs short of going through every single cell. However, I can go to the Spreadsheet Painter, paint it and now I can see that the cells in yellow are the input cells and the cells in light blue are calculations and the cells in dark blue are the outputs. This makes it easier to see where the inputs are on a spreadsheet which inevitable are the drivers of a spreadsheet.