Risk Metrics: correlating spreadsheet characteristics with audit time

This talk presents a great idea: relating spreadsheet characteristics to audit time. Operis audits many models every year, and David Colver has analyzed 75 of them to try to find out what predicts audit time the best. File size is not a very good predictor, that makes sense, since some constructions like graphs add a Read more about Risk Metrics: correlating spreadsheet characteristics with audit time[…]

Spreadsheets and Long Term Corporate Survival

This talk by Grenville Croll focuses on the question whether the use of spreadsheets has an advantage to an individual or a company. A very interesting line of thought. He gathered this idea from a PhD thesis by F. MacMillan that did a comparable analysis for decision making software. Since he ran a company that Read more about Spreadsheets and Long Term Corporate Survival[…]

Spreadsheet use in Solvency II Internal Models

The keynote presentation of today is done by Jothi Philip of the FSA, talking about spreadsheet auditing and Solvency II. Jothi showed a data flow diagram of operation within a insurance company, where some of the steps are done with spreadsheets. He also shared some great anecdotes on spreadsheets in insurance companies. For instance: in a certain company, the Read more about Spreadsheet use in Solvency II Internal Models[…]