Text Box: S /

IDAS Formula Map

Note: The IDAS Formula Map Tool is used by ExcelForManagers’ consultants whilst undertaking EUC investigations and risk assessments. Whilst it is not on general sale we do make our tools available to our clients and occasionally to selected analysts, auditors & corporations with full support.  Contact us for more details.

Text Box: Comment
When used in a Risk Assessment project, our Formula Mapping Tool usually identifies numerous inconsistencies and potential errors. This is especially true of older workbooks containing unknown quantities of legacy data.  The objective nature of the testing and non-threatening manor in which the potential errors are reported usually leads to a positive remediation approach from the spreadsheet owner.

The Integrated Data And Structure Formula Map shows the formula structure of Excel spreadsheets. It can be invaluable in identifying the location and frequency of similar formulae, and which cells are used as a data source for other formulae. It assists in spotting potential inconsistencies with a quick double-click returning the                     user to the same cell in the origin  workbook to review                                                any observations in greater detail.

                                                           Each color represents a formula  that has been copied through the range, grey cells show static figures. In this example a formula that has been accidentally overwritten with a number has been highlighted