PerfectXL Compare

User Cases & Application

On this page you will find a summation which aims to show the relevance and application of a spreadsheet compare tool based on the user tests we did while developing our spreadsheet comparison tool.

Overview of Changes

Overview of changes in a spreadsheet // PerfectXL Compare User Cases & Application

Our first use case involves a financial worker who wants an overview of the changes made between two versions of a spreadsheet. This could be for a variety of reasons, but is often done to check what has been changed by other people working in the spreadsheet. In many cases other users of the spreadsheet should only adjust data in the spreadsheet, and not formulas or structure. PerfectXL Compare groups differences into categories: data, formulas, and structure. These difference groups allow the financial worker to quickly see what has actually been changed in the spreadsheet.

Our findings show that PerfectXL Compare:

  • Gives a quick overview of all difference types
  • Reports only relevant information
  • Quickly finds well categorized differences
  • Is accurate
  • Is fast (94% of analysis under 1 second)

Overview of changes in a spreadsheet - Example // PerfectXL Compare User Cases

Damage Control

Damage control in spreadsheets // PerfectXL Compare User Cases & Application

Our next use case involves a new secretary who has to use a large, complex spreadsheet models for agendas, hour plannings, and a variety of other in-house functions with the secretary is responsible for. She has been working with a particularly complex model for sometime when it suddenly stops working. The spreadsheet is so complex that it would be impossible to manually find the issue. The application of PerfectXL Compare in this scenario is to detect a change between the current model, and a previous working model, so that the secretary can easily find and repair the issue.

Our findings show that PerfectXL Compare:

  • Has a clear summary with which outliers are quickly spotted
  • Is easy to use so even someone with limited Excel knowledge can use it
  • Is detailed so that every specific change and result can be tracked
  • Is able to handle complex spreadsheets
  • Is efficient in handling very large spreadsheets
  • Can be easily focused on specific changes

 

Damage control in spreadsheets - Example // PerfectXL Compare User Cases

Progress Reporting

Spreadsheet Progress Reporting // PerfectXL Compare User Cases & Application

Our last use case relates to a consultant and Excel guru who spends a lot of time building and developing spreadsheet models for 3rd party clients. The Excel guru wants an application which helps him to track the changes he is making in a spreadsheet as he develops it, something he can use to report on those steps in a logical way to keep his clients happy, and a tool which helps to keep him honest, and check that he hasn’t changed parts of the model unintentionally. With PerfectXL Compare he can report on and trace changes made as he is building new versions of the model.

Our findings show that PerfectXL Compare:

  • Is accurate keeping the consultant honest
  • It’s fast so that he doesn’t waste time
  • Generates an overview that is clear and can be used as a report
  • Has a good summary so he can quickly check his own work
  • Is user friendly so his client can double check
  • Is standalone so the privacy of the client is protected

 

Spreadsheet Progress Reporting - Example // PerfectXL Compare User Cases

  • Incredibly fast comparison
  • Correct, reliable results
  • No learning curve

Read more about Excel file comparison

On this page you will find a step-by-step walkthrough of the PerfectXL Compare tool.

Our software came to existence though a combination of passions for Excel, computer science, and board games.

This is the technical page for PerfectXL Compare. Here you will find information like system requirements, release notes, and answers to most questions about our software.

We realize there are alternative solutions available in the realm of spreadsheet comparison, but PerfectXL Compare is in a different league. Below you will find a feature comparison with some of the market leaders in spreadsheet comparison.

Many nightmares have arisen because of confusion about the correct file versions of Excel documents. Learn more about version management.

What separates the great spreadsheets from the rest, is documentation! This will help future users of the spreadsheets to really understand your work.