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[…]

Investigating Effects of Common Spreadsheet Design Practices on Correctness and Maintainability

The main reserach question is “Can best practices serve as a quality indicator?”, where the authors define quality as both correctness and maintainability. Correctness The authors define correctness as degree to which the output of the spreadsheet conform to  given test scenarios. Maintainability Here they use the sum of factors that contribute to the chance Read more about Investigating Effects of Common Spreadsheet Design Practices on Correctness and Maintainability[…]