Category Archives: Risk

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

Posted in eusprig, Excel/VBA, Research, Risk, Uncategorized | Tagged | 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 , , | Leave a comment

Irish Computer Society evening talk on Spreadsheet Controls

My talk on “Spreadsheet Management and Controls” is next month at the ICS. Monday 18:00 – 19:30 9th Jun This session outlines current concerns about risks from the uncontrolled use of spreadsheet-based information systems. The session will cover how to … Continue reading

Posted in Excel/VBA, Risk, Software Quality, Software Testing | 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

Excel 2013 Inquire Addin improved IQ

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

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 … Continue reading

Posted in Risk, Software Quality, Software Testing | Tagged , , | 1 Comment

EuSpRIG 5-6 July Manchester

I’ll be at the annual conference of the European Spreadsheet Risk Interest Group in the Museum of Science and Industry in Manchester, UK, on 5 & 6 July. The programme has been announced. Jothi Philip, Financial Services Authority, UK, will talk … Continue reading

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