Prodiance Spreadsheet IQ:
Automating Validation, Error Checking and Optimization
As part of any spreadsheet controls initiative, organizations need to ensure that proper documentation exists, identify and remediate any structural errors, and optimize existing spreadsheet models. Whether these activities are performed by an internal audit function or a consultancy with domain expertise in managing spreadsheet risk, Prodiance Spreadsheet IQ is the most comprehensive solution available, and an industry standard.
Prodiance Spreadsheet IQ is a powerful and easy-to-use application to help organizations automate diagnostics, error checking and optimization for mission critical spreadsheets. Prodiance Spreadsheet IQ is integrated with Microsoft Office Excel, so end users can quickly analyze even the most complex spreadsheets with little or no training – all within the native Excel environment.
Key Features & Capabilities
- Powerful and comprehensive diagnostics and error checking for mission critical spreadsheets.
- Automated documentation to satisfy compliance and corporate governance mandates.
- Comprehensive reporting on logic and structural errors.
- Graphical relationship diagrams to identify and report on spreadsheet links, data feeds and other dependencies.
- Ad-hoc, interactive cell analysis.
- Color coding schemes to help visually identify errors, external links, missing input data, plugged cells and other inconsistencies.
- Supports Microsoft Office Excel 2007 and all prior versions.
Comprehensive Spreadsheet Analysis Prodiance Spreadsheet IQ delivers in-depth diagnostic reports on all critical spreadsheets to help organizations evaluate their complexity and find common errors for remediation efforts. Reports include workbook inventory, workbook and cell analysis, cell summary, color schemes, ad-hoc analysis, and interactive workbook and cell dependency (link) diagrams. All reports can be exported to .xls and PDF formats, printed and archived into a secure repository as part of spreadsheet documentation efforts. The workbook analysis report includes over 40 different diagnostic checks for common logic and structural errors, including: formula errors, inconsistent formulas, invisible cells, hidden rows and columns, very hidden worksheets, formulas referencing hidden or blank cells, formulas returning text, duplicate formulas, cells with conditional formatting or validation logic, warnings, and much more.
Color Coding Schemes To support best practices and help users visually identify common errors and structural issues, Prodiance Spreadsheet IQ incorporates an easy-to-use color scheme tool. Color schemes can be defined according to corporate policies and automatically reapplied after spreadsheets have been updated. By applying a color scheme to each cell, users can easily see formula errors, inconsistent formulas, external links, missing input data, formulas, and other elements. This makes spreadsheets easier to use and navigate, and proactively highlights problems. Spreadsheets can be further optimized by removing excess cell formatting.
Dependency Diagrams Prodiance Spreadsheet IQ provides extensive link analysis capabilities through interactive cell, worksheet and workbook dependency diagrams. These diagrams help identify external links and data feeds, broken links, and allow users to interactively trace formula errors to identify the root cause.
Automates Spreadsheet Documentation Auditors recommend properly documenting mission critical spreadsheets as part of any internal controls initiative, and Prodiance Spreadsheet helps organizations generate an extensive set of documentation through standard reports. Spreadsheet documentation can be linked to the original spreadsheet through metadata as part of a Microsoft SharePoint installation.
Used by Leading Audit Professionals For automated spreadsheet diagnostics, Prodiance Spreadsheet IQ is the leading tool of choice for audit professionals. Prodiance Spreadsheet IQ was developed in collaboration with leading audit firms and domain experts with backgrounds in spreadsheet remediation and control.
Ready to Take the Next Step? If you’re ready to automate validation, error checking and optimization for your organization’s critical spreadsheets, click on one of the resource links to the right, or contact a Prodiance representative today!