Prodiance Spreadsheet IQ:
Automating Diagnostics, Error Checking and Optimization
As part of any spreadsheet risk management or control initiative, organizations need to ensure mission critical spreadsheet models are working properly and producing accurate results. This requires periodic testing, validation, and remediation. Whether these activities are performed by an internal audit function or a consultancy with domain expertise in spreadsheet development best practices, 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 all 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!
- Graphical relationship diagrams to identify and report on spreadsheet links, data feeds and other dependencies.
- Ad-hoc and interactive cell analysis quickly locates errors in the context of a workbook.
- Color coding schemes help visually identify structural errors, external links, missing input data, plugged cells and other and inconsistencies.
- Supports Microsoft Office Excel 2007, 2010 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!