Prodiance Spreadsheet Compare:
Accelerating Spreadsheet Review and Approval
When mission critical spreadsheets are managed in uncontrolled environments, maintaining spreadsheets integrity and auditability can be impossible. Unauthorized changes can be made quickly to critical spreadsheets, and spreadsheet owners and approvers may have no idea what was changed, or what impact it may have on the spreadsheet results. Enter Prodiance Spreadsheet Compare, a powerful application that provides immediate visibility into changes between spreadsheet versions.
With Prodiance Spreadsheet Compare, users can compare two different spreadsheets or two versions of the same spreadsheet and graphically see the differences. For approvers, this makes it very easy to review spreadsheet changes from month to month and helps accelerate the close process. For spreadsheet owners, it provides visibility into important structural changes (to formulas, macros, pivot tables, queries, etc.) and helps improve spreadsheet integrity and auditability.
Prodiance Spreadsheet Compare is provided as part of Prodiance Enterprise Spreadsheet Manager.
Business Benefits
- Enables faster review and approval of critical spreadsheets, and faster closes
- Provides immediate visibility into key changes to critical spreadsheets across accounting periods
Key Features
- Enables users to graphically compare changes between two spreadsheets or spreadsheet versions
- Provides graphical, side-by-side and color-coded comparison of changes
- Synchronizes comparison views even when rows/columns have been added/deleted
- Incorporates a bird's eye view of changes with graphical statistics
Graphical Comparison of Changes Prodiance Spreadsheet Compare incorporates a preview of each spreadsheet and detailed list of changes, including macros, cell formatting, entered and calculated values, formulas, formula errors, structural changes, names, and data connections. Each change category is color coded for easy identification and preview grids are synchronized when the user clicks on each change. A bird's eye view of all changes discovered is provided via a statistics bar chart, and all comparison results can be exported to Excel for reporting and further analysis.
Detailed Macro Comparison Prodiance Spreadsheet Compare enables detailed comparison of macros and VB code. Macro changes can be selected from the comparison results and displayed side-by-side, showing each code change. This feature is extremely helpful for lengthy and complex macros.
Ready to Take the Next Step? Sign up for an online seminar or contact a Prodiance representative to schedule your personalized product demonstration today!