Experiences in using a contingency factor-based validation methodology for spreadsheet DSS

Leonidas Anastasakis, C.W. Olphert, J.M. Wilson

Research output: Contribution to journalArticle

Abstract

The use of spreadsheets has become routine in all aspects of business with usage growing across a range of functional areas and a continuing trend towards end user spreadsheet development. However, several studies have raised concerns about the accuracy of spreadsheet models in general, and of end user developed applications in particular, raising the risk element for users. High error rates have been discovered, even though the users/developers were confident that their spreadsheets were correct. The lack of an easy to use, context-sensitive validation methodology has been highlighted as a significant contributor to the problems of accuracy. This paper describes experiences in using a practical, contingency factor-based methodology for validation of spreadsheet-based DSS. Because the end user is often both the system developer and a stakeholder, the contingency factor-based validation methodology may need to be used in more than one way. The methodology can also be extended to encompass other DSS.

LanguageEnglish
Pages756-761
Number of pages6
JournalJournal of the Operational Research Society
Volume59
Issue number6
Early online date14 Mar 2007
DOIs
Publication statusPublished - Jun 2008

Fingerprint

Spreadsheets
Methodology
Spreadsheet
Contingency factors
End users
Industry
Developer

Keywords

  • decision support systems
  • models
  • spreadsheets
  • validation

Cite this

@article{a465f72f02914ca18329718ca23ddd0a,
title = "Experiences in using a contingency factor-based validation methodology for spreadsheet DSS",
abstract = "The use of spreadsheets has become routine in all aspects of business with usage growing across a range of functional areas and a continuing trend towards end user spreadsheet development. However, several studies have raised concerns about the accuracy of spreadsheet models in general, and of end user developed applications in particular, raising the risk element for users. High error rates have been discovered, even though the users/developers were confident that their spreadsheets were correct. The lack of an easy to use, context-sensitive validation methodology has been highlighted as a significant contributor to the problems of accuracy. This paper describes experiences in using a practical, contingency factor-based methodology for validation of spreadsheet-based DSS. Because the end user is often both the system developer and a stakeholder, the contingency factor-based validation methodology may need to be used in more than one way. The methodology can also be extended to encompass other DSS.",
keywords = "decision support systems, models, spreadsheets, validation",
author = "Leonidas Anastasakis and C.W. Olphert and J.M. Wilson",
year = "2008",
month = "6",
doi = "10.1057/palgrave.jors.2602391",
language = "English",
volume = "59",
pages = "756--761",
journal = "Journal of the Operational Research Society",
issn = "0160-5682",
publisher = "Palgrave Macmillan Ltd.",
number = "6",

}

Experiences in using a contingency factor-based validation methodology for spreadsheet DSS. / Anastasakis, Leonidas; Olphert, C.W.; Wilson, J.M.

In: Journal of the Operational Research Society, Vol. 59, No. 6, 06.2008, p. 756-761.

Research output: Contribution to journalArticle

TY - JOUR

T1 - Experiences in using a contingency factor-based validation methodology for spreadsheet DSS

AU - Anastasakis, Leonidas

AU - Olphert, C.W.

AU - Wilson, J.M.

PY - 2008/6

Y1 - 2008/6

N2 - The use of spreadsheets has become routine in all aspects of business with usage growing across a range of functional areas and a continuing trend towards end user spreadsheet development. However, several studies have raised concerns about the accuracy of spreadsheet models in general, and of end user developed applications in particular, raising the risk element for users. High error rates have been discovered, even though the users/developers were confident that their spreadsheets were correct. The lack of an easy to use, context-sensitive validation methodology has been highlighted as a significant contributor to the problems of accuracy. This paper describes experiences in using a practical, contingency factor-based methodology for validation of spreadsheet-based DSS. Because the end user is often both the system developer and a stakeholder, the contingency factor-based validation methodology may need to be used in more than one way. The methodology can also be extended to encompass other DSS.

AB - The use of spreadsheets has become routine in all aspects of business with usage growing across a range of functional areas and a continuing trend towards end user spreadsheet development. However, several studies have raised concerns about the accuracy of spreadsheet models in general, and of end user developed applications in particular, raising the risk element for users. High error rates have been discovered, even though the users/developers were confident that their spreadsheets were correct. The lack of an easy to use, context-sensitive validation methodology has been highlighted as a significant contributor to the problems of accuracy. This paper describes experiences in using a practical, contingency factor-based methodology for validation of spreadsheet-based DSS. Because the end user is often both the system developer and a stakeholder, the contingency factor-based validation methodology may need to be used in more than one way. The methodology can also be extended to encompass other DSS.

KW - decision support systems

KW - models

KW - spreadsheets

KW - validation

UR - http://www.scopus.com/inward/record.url?scp=43149098053&partnerID=8YFLogxK

UR - http://www.palgrave-journals.com/jors/journal/v59/n6/abs/2602391a.html

U2 - 10.1057/palgrave.jors.2602391

DO - 10.1057/palgrave.jors.2602391

M3 - Article

VL - 59

SP - 756

EP - 761

JO - Journal of the Operational Research Society

T2 - Journal of the Operational Research Society

JF - Journal of the Operational Research Society

SN - 0160-5682

IS - 6

ER -