Overview of Changes
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 be changed in the spreadsheet.
Our next use case involves a new secretary which 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. PerfectXL Compare can be used in this scenario to detect a change between the current model, and a previous working model, so that secretary can easily find and repair the issue.
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 a tool 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.