Category Archives: Research

Excel & Genes: mutation and curation

On 23 Aug a paper by three Australian authors gained much publicity about how Excel interprets data entry and how the users don’t check their data. http://genomebiology.biomedcentral.com/articles/10.1186/s13059-016-1044-7 Gene name errors are widespread in the scientific literature. By Mark Ziemann, Yotam … Continue reading

Posted in Excel/VBA, Research, Risk, Software Testing | 1 Comment

Eusprig 2016 July 7, London

The European Spreadsheet Risks Interest Group 17th Annual Conference (EuSpRIG 2016) will be held at the Institute of Chartered Accountants in England and Wales (ICAEW), Moorgate, London, on the 7th July 2016. http://www.eusprig.org/annual-conference.htm The programme is now available. Register now to … Continue reading

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

A first look at the FUSE spreadsheet corpus

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

VBA in the spreadsheets from the Enron email corpus

The European Spreadsheet Risk 2015 Conference papers are now available at http://www.eusprig.org/papers-presentations.htm My presentation was on investigating the use of VBA in spreadsheets in the Enron email corpus. http://www.eusprig.org/presentations/VBA%20in%20spreadsheets%20from%20Enron%2CPO%27Beirne%202015.pdf Most of the slides deal with the mechanics of how I … Continue reading

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

EuSpRIG 2013 Conference report

4-5 July 2013, University of Greenwich, London. http://www.eusprig.org We had a slightly smaller number of attendees this year than we expected, considering the publicity that attended recent spreadsheet errors, such as the London Whale or the Reinhart & Rogoff debacle. … Continue reading

Posted in Research, Risk | Tagged , , | Leave a comment

Reinhart & Rogoff: The Austerity spreadsheet error

We’ve discussed this on the yahoogroup of the European Spreadsheet Risk Interest Group, of which I’m the current chair. Here’s my summary of The Spreadsheet Error Heard Round the World, with my commentary followed by the background. 1) The authors … Continue reading

Posted in Excel/VBA, Research, Risk, Software Testing, Uncategorized | Tagged , , , | Leave a comment

EuSpRIG 2013: The World’s Leading Spreadsheet Risk Management Conference

I’ll be there: The European Spreadsheet Risks Interest Group 14th Annual Conference (EuSpRIG 2013) will be held at the University of Greenwich, London, on the 4th & 5th July 2013. EuSpRIG is the world’s only independent, authoritative & comprehensive conference … Continue reading

Posted in Research, Risk | Tagged , , | Leave a comment