Incisive

Figure 1 – Xcellerator screenshot

Incisive primarily differentiates itself in its focus and in the way that it works. For example, Figure 1 shows a screenshot from Xcellerator. What has happened here is that you have run a series of tests (shown in the box on the right) and the results in the spreadsheet have been colour coded to indicate the severity of the risk associated with the error that has been discovered. The user has then clicked on the red error to the left of the spreadsheet and a drill-down has appeared showing details about the problem. Overall, this provides significant ease of use benefits. It is further worth commenting that the navigation underlying this has been patented and the coloured overlays are patent pending. Moreover, the colour coding does not impact on the spreadsheet at all, they are merely overlays.

In practice there are some 40 out of the box tests delivered with Xcellerator, including both structural and link testing, and there is also the ability to customise these or build your own. More generally, Xcellerator works with Locator for risk scanning and reporting (which is done via Excel) and there is a Concourse Gateway for collaboration and check-in/out (version control) and workflow processes that support approval processes prior to the publication of a spreadsheet for wider use. Version control means that you will always be working with the latest version of a spreadsheet. There are also notification capabilities, via either email or RSS feed, to alert users when a new version is introduced.

Figure 2 – The Concourse Gateway

The Concourse Gateway works in conjunction with the Concourse server/repository and the Concourse Control Center, as illustrated in Figure 2. Typically, this involves loading the spreadsheets that you want to put under management control, into a SQL Server or Express database. However, unlike other vendors that either decompose spreadsheets into rows and columns or treat them as pure XML, Incisive works on the basis of the entire spreadsheet, its argument being that some things in a spreadsheet don’t get rendered until they are actually opened in Excel.

However, it is pertinent to point out that users have a choice: you can store spreadsheets in a central repository for tighter management, collaboration and so forth and/or you can monitor spreadsheets where they are currently stored. In either case, all revisions are controlled, all can be alerted, and all are configurable without requiring customised development.

Finally, Locator will discover your spreadsheets for you and allow you to assess the risks (high, medium or low) associated with these risks. This risk assessment may be based on financial or other business criteria – defined by you – or based on the complexity of the spreadsheet and its links (and, therefore, its propensity to have errors). In any case, you can configure the risk assessment to suit your company needs. A useful further feature is to monitor and report on trends in risk measures, so you can see whether a particular spreadsheet is becoming more or less risky over time.

As illustrated, most finance departments don’t know where all their spreadsheets are, that the use of spreadsheets is widespread, that errors within them cost an average of $7Bn annually. Moreover, the advent of new compliance regimes such as GDPR (general data protection regulation) mean that you need to able to discover spreadsheets that contain sensitive personal information. For all these reasons, spreadsheets should be treated as corporate assets in much the same way as any other form of data. And they need to be managed accordingly.

The Bottom Line

Incisive, unlike some other vendors, is focused on mitigating risk and exposure through a focus on the accuracy of data, which will lead to better business decisions. Further, its emphasis is on providing a product suite that you configure rather than customise. A subtle distinction perhaps but one that end users should appreciate, because it all about supporting self-service and ease of use.