ZackSoft Audit Map - Ensure Spreadsheet Accuracy

Feedback

About Us

Home

Excel Add-Ins

C++ XLL

Freeware

Download

Purchase

Updates

Tutorial

Audit Map

This auditing tool will generate an audit map of an existing worksheet and allow the user to trace formula and cell dependency in order to ensure accuracy and robustness.

If you work with Excel and produce or maintain spreadsheets, you would likely have experienced that spreadsheet can quickly become large and complex. And more than occasionally, simple errors would likely have crept in from the obvious to the harder to find ones.

Auditing spreasheets by checking the formulas one by one is not particularly effective nor productive as there may be thousands of formulas with the vast majority being a copy of an existing formula. There will likely also be formatting errors.

Other than adopting best practices in terms of spreadsheet modelling, all you need is a simple utility to provide a visual map of the formulas used and the unique formulas therein for verification.

Excel 2007

Excel 2003 and earlier versions

Key Features

Generate a visual map of the formulas and number formats used. Easily identify formulas and formats that are copied and those that are out of context with those surrounding indicating a likely error.
Provides a list of the unique formulas (shaded in red) and formula errors for verification.
Understand the different types of formula used and the flow of these formulas. This will help in understanding and reducing spreadsheet complexity.
New Compare worksheets and find differences in formulas or calculated values.
Trace and understand formulas and how their values are arrived at. Display the relevant label of the formula for easy reference and checking.
Navigate thru a cell's where-used and any further dependencies.

Key Benefits

Audit spreadsheets for accuracy, standardisation and robustness.
Helps to understand formulas and their complexity, thereby enabling simplification.

Interactively inspect the source cell by double clicking on any cell in the map to goto the corresponding cell in the source worksheet, and pressing ALT-TAB to return to the map worksheet.

A sample output of the audit formula map.

Audit Map sample output

A sample output of the number format map.

Format Map sample output

Double click on any cell reference to further trace precedent formula.

Trace Formula