Prodiance Spreadsheet Compare:
Accelerating Spreadsheet Review and Approval
In today's business environment, efficient review and approval of changes to complex, mission critical spreadsheets can be an impossible task. Spreadsheets are often managed in uncontrolled, file share environments where unauthorized changes can be made quickly, and spreadsheet owners and approvers may have no idea what was changed, or what impact the changes may have on the spreadsheet results. Enter Prodiance Spreadsheet Compare, a powerful and graphical 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 accuracy.
Key Features & Benefits
- Enables users to compare changes between two spreadsheets or spreadsheet versions
- Provides a graphical, side-by-side and color-coded comparison of changes
- "Smart Compare" feature compensates for rows/columns that have been added/deleted
- Comparison of entered values, calculated values, formulas, external links, data connections, macros
- Drill down into VB and macro changes
- Cells can be resized to fit data for easier viewing of changes
- Incorporates a bird's eye view of changes with graphical statistics
- Results can be filtered and exported to Excel for further review
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.
System Requirements
- Minimum 1 GB RAM
- Microsoft Windows XP, Vista, or Windows 7
- Microsoft .NET Framework v3.5
- Microsoft Office 2007 Compatibility Pack
Ready to Take the Next Step? Try Prodiance Spreadsheet Compare for 14 days, or purchase a copy online. You may also wish to contact a Prodiance representative to schedule your personalized product demonstration today!