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 about the FSA experience of reviewing how insurance firms are meeting the Solvency II Internal Model data requirements.

There will be talks by experienced practitioners about their Excel development approaches. Of the academic papers, I’ll highlight three:

Miguel Ferreira of will talk about peer-review, tool-assisted evaluation and other pre-existing approaches in a single organization-wide approach that reduces spreadsheet risk without overly restricting spreadsheet use.

Daniel Kulesz of the Institute of Software Technology, Stuttgart, conducted a controlled experiment with 42 subjects to investigate the question whether observance of three commonly suggested Best Practices is correlated with correctness and maintainability.

 Felienne Hermans of TU Delft conducted experiments to indicate that the number of ranges, the nesting depth and the presence of conditional operations in formulas significantly increase the difficulty of understanding a spreadsheet.

If there are enough people arriving early on Wednesday, I’ll run the usual one-hour spreadsheet challenge at a 4pm meetup in the offices of BDO, followed by a retirement to a suitable watering hole.

On the second day, Friday, we’ll have time for a round table session where attendees can give direction to future research, the remaining unsolved problems in the adoption of spreadsheet controls, focusing on People, Process, and Technology.

About Patrick O'Beirne, Excel/VBA developer

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

1 Response to EuSpRIG 5-6 July Manchester

  1. felienne says:

    I am in Manchester Wednesday afternoon, so if you run the Challenge, I am in 🙂

Leave a Reply

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

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

Google photo

You are commenting using your Google 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 )

Connecting to %s