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 SIG.eu 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.