Preliminary programme as of 1 June 2003
European Spreadsheet Risks Interest Group 4th annual conference
Thursday 24 - Friday 25 July 2003, Trinity College, Dublin.
Theme: 'Building Better Business Spreadsheets - from the adhoc to the
Sponsored by ECDL, ICS, KPMG, ISACA UK
Introductory address from Dean Buckner, Financial Services Authority, London.
Standards, policies, and training to reduce spreadsheet errors.
1) Accuracy in Spreadsheet Modeling Systems
Thomas A. Grossman OPMA, Haskayne School of Business, Calgary, Alberta, Canada.
Because industry has tolerance for system inaccuracy, errors in spreadsheet
implementations may not be a serious concern. Spreadsheet productivity may
be of more interest.
2) The Wall and The Ball:
A Study of Domain Referent Spreadsheet Errors
Richard J. Irons Faculty of Business and Law Central Queensland University
Spreadsheet error making is influenced by domain knowledge and domain
perception. Qualitative findings also suggest that spreadsheet error making
is a part of overall human behaviour.
3) Research Strategy and Scoping Survey on Spreadsheet Practices
Thomas A. Grossman OPMA, Haskayne School of Business, Calgary, Alberta, Canada
Özgür Özlük ISBA Department, College of Business, SFSU San Francisco, CA, USA
We propose a research strategy for creating and deploying prescriptive
recommendations for spreadsheet practice ... existing practices and ideal
practices can be combined into proposed best practices for deployment.
4) Audit and change analysis of spreadsheets
John C. Nash, Neil Smith, Andy Adler
School of Management, University of Ottawa, Canada
We present some tools we have developed to enable 1) the audit of selected,
filtered, or all changes in a spreadsheet, that is, when a cell was
changed, its original and new contents and who made the change, and 2)
control of access to the spreadsheet file(s) so that auditing is trustworthy.
5) Reducing Overconfidence in Spreadsheet Development
Dr. Raymond R. Panko University of Hawai`i, USA
This paper describes two experiments in overconfidence in spreadsheet
development. The first is a pilot study to determine the existence of
overconfidence. The second tests a manipulation to reduce overconfidence
6) Correctness is not enough
Louise Pryor, Edinburgh, UK
It is often difficult to tell whether the spreadsheets in question are
correct, and even if they are, they may still give the wrong results. These
problems are explained in this paper, which presents the key criteria for
judging a spreadsheet.
a) CodeTracer - a Spreadsheet Visualisation and Analysis Concept
b) Atebion - a mathematically- based tool to spreadsheet integrity
Patrick O'Beirne, local organiser for Eusprig 2003 www.eusprig.org
'Building Better Business Spreadsheets: from the ad hoc to the quality
July 24/25 2003, Trinity College, Dublin, Ireland
Systems Modelling Ltd. Suite #2, Villa Alba,
Tara Hill, Gorey, Co. Wexford, IRELAND
Tel: +353 (0)55 22294 Fax: +353 (0)55 22165