Recent Comments
Patrick O'Beirne, Ex… on Excel formula to test if a wor… Peter Bartholomew on Excel formula to test if a wor… Rick Rothstein on Excel formula to test if a wor… Patrick O'Beirne, Ex… on Excel formula to test if a wor… Peter Bartholomew on Excel formula to test if a wor…
Category Archives: Research
A look back to Eusprig 2019
The 20th conference of the European Spreadsheet Risk Interest Group was held in Browns of Covent Garden, London on 11-12 July 2019, Thursday 11 July 2019 Developing Excel Thought Leadership David Lyford-Smith, ICAEW, Chartered Accountants’ Hall This described the development … Continue reading
A look ahead to Eusprig 2019
The 20th annual conference of the European Spreadsheet Risk Special Interest Group (http://www.eusprig.org) will be held on July 11 & 12 at The Barrister’s Court, Browns, 82-84 St Martin’s Ln, Covent Garden, London WC2N 4AG, UK. David Lyford-Smith of the … Continue reading
Posted in eusprig, Excel/VBA, Research, Software Quality, Software Testing
Tagged Excel tutorials, Spreadsheet management, spreadsheet risk
Leave a comment
Extend Excel: London 18 Oct
Charles Williams is organising a conference in London on October 18th, 2018. I’ll be there! This is a rare chance to meet leading developers from all over the world and hear directly from MS on Excel Extensibility. Expect to be … Continue reading
Posted in Excel/VBA, ExcelDna, Open Source, Productivity, Research, Software Quality, Software Testing, Uncategorized
Tagged Conference, Excel Developers
Leave a comment
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
4 Comments
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 Audit, Conference, eusprig
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
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. Click to access VBA%20in%20spreadsheets%20from%20Enron%2CPO%27Beirne%202015.pdf Most of the slides deal with the mechanics … Continue reading
Posted in Excel/VBA, Research
Tagged code quality, enron email corpus, gephi, network graph, VBA
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
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 economists, error, eusprig, spreadsheet
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
Patrick O'Beirne @ sysmod 