Tag Archives: auditing

A first look at the FUSE spreadsheet corpus

Posted on Sep 25, 2015 by Patrick O'Beirne, Excel/VBA developer

Following on the first paper by Titus Barik et al static.barik.net/barik/publications/msr2015/PID3640389.pdf and some work by Mark Townsend analysing the last row and column used in each file http://markstownsend.com/what-are-all-the-rows-for/index.html I downloaded the 7GB of 249,376 files and did some summary analysis … Continue reading →

Posted in Excel/VBA, Research | Tagged , , | 1 Comment

Excel 2013 Inquire Addin improved IQ

Posted on Mar 6, 2013 by Patrick O'Beirne, Excel/VBA developer

In my previous blog post I complained that the Excel 2013 INQUIRE addin showed every single formula in A1 style, which is useless for recognising blocks of identical formulas. So I’ve now done something about that – I am making available … Continue reading →

Posted in Excel/VBA, Productivity, Risk | Tagged , , , | 6 Comments

Free Excel formula highlighting tool

Posted on Nov 4, 2011 by Patrick O'Beirne, Excel/VBA developer

My main product is the XLTest addin that does a comprehensive shakedown of Excel workbooks. I’ve picked out the most popular feature, colour coding cells by formula region, and give it away as a free taster, the XLTest Colorizer. It … Continue reading →

Posted in Excel/VBA, Risk | Tagged , , , , , , , , , , , , , | Leave a comment