Excel 2013 Inquire first looks

The Inquire Addin is better than nothing, but it seems to be only useful for small spreadsheets.

For example, the Workbook Analysis Report lists all formulas individually, with no concept of how the same formula in relative terms has been copied over areas. I find it hard to believe that such a list would have been accepted as useful in a commercial product.

The worksheet relationship diagram provides little useful information

Worksheet Relationship Diagram

The Cell relationship diagram tries to draw an arrow for every precedent cell including those in a LOOKUP block: again, not very useful:

Cell Relationship Diagram 7350 nodes

I can’t see this replacing XLTest or any other decent commercial spreadsheet auditing package. However, if it gets users aware of the bad smells which the Workbook Analysis Report lists, they may become aware of the need to look further, which is good.

 

Advertisements

About Patrick O'Beirne, spreadsheet auditor

Patrick provides consultancy and training in spreadsheet development, auditing / testing and model review; and the Excel addin XLtest
This entry was posted in Risk, Software Quality, Software Testing and tagged , , . Bookmark the permalink.

One Response to Excel 2013 Inquire first looks

Leave a Reply

Fill in your details below or click an icon to log in:

WordPress.com Logo

You are commenting using your WordPress.com account. Log Out / Change )

Twitter picture

You are commenting using your Twitter account. Log Out / Change )

Facebook photo

You are commenting using your Facebook account. Log Out / Change )

Google+ photo

You are commenting using your Google+ account. Log Out / Change )

Connecting to %s