The role of OR specialists in 'do it yourself' spreadsheet development

J.S. Edwards; P.N. Finlay; J.M. Wilson

doi:10.1016/S0377-2217(99)00331-8

The role of OR specialists in 'do it yourself' spreadsheet development

J.S. Edwards, P.N. Finlay, J.M. Wilson

Operations & Information Management

Research output: Contribution to journal › Article › peer-review

Abstract

The implementation of 'do it yourself' spreadsheets (DIY-SS) has become widespread in recent years. Although the interest of the non-specialist in creating SS is to be welcomed, this has led to concerns that many of these systems may not be 'fit-for-purpose'. The principal reasons for this are the inappropriate scope and focus of the SS and the lack of detailed verification that is carried out. With an appropriate framework to guide them, the OR professional therefore has an important new role to play in supporting DIY-SS by guiding the DIY developer. A set of 20 guidelines is presented to help the OR specialist guide the DIYer to 'scope' any proposed SS. Then a set of 21 'points of best practice'
is presented to support verification as the resultant SS is developed. The paper concludes by briefly reflecting on the new role for the OR specialist.

Original language	English
Pages (from-to)	14-27
Number of pages	14
Journal	European Journal of Operational Research
Volume	127
Issue number	1
DOIs	https://doi.org/10.1016/S0377-2217(99)00331-8
Publication status	Published - 16 Nov 2000

Keywords

decision support systems
modelling
spreadsheets
user-analyst
validation

Access to Document

10.1016/S0377-2217(99)00331-8

Cite this

@article{0316c98c25814af4ab81ffe0567ea134,

title = "The role of OR specialists in 'do it yourself' spreadsheet development",

abstract = "The implementation of 'do it yourself' spreadsheets (DIY-SS) has become widespread in recent years. Although the interest of the non-specialist in creating SS is to be welcomed, this has led to concerns that many of these systems may not be 'fit-for-purpose'. The principal reasons for this are the inappropriate scope and focus of the SS and the lack of detailed verification that is carried out. With an appropriate framework to guide them, the OR professional therefore has an important new role to play in supporting DIY-SS by guiding the DIY developer. A set of 20 guidelines is presented to help the OR specialist guide the DIYer to 'scope' any proposed SS. Then a set of 21 'points of best practice'is presented to support verification as the resultant SS is developed. The paper concludes by briefly reflecting on the new role for the OR specialist.",

keywords = "decision support systems, modelling, spreadsheets, user-analyst, validation",

author = "J.S. Edwards and P.N. Finlay and J.M. Wilson",

year = "2000",

month = nov,

day = "16",

doi = "10.1016/S0377-2217(99)00331-8",

language = "English",

volume = "127",

pages = "14--27",

journal = "European Journal of Operational Research",

issn = "0377-2217",

publisher = "Elsevier",

number = "1",

}

TY - JOUR

T1 - The role of OR specialists in 'do it yourself' spreadsheet development

AU - Edwards, J.S.

AU - Finlay, P.N.

AU - Wilson, J.M.

PY - 2000/11/16

Y1 - 2000/11/16

N2 - The implementation of 'do it yourself' spreadsheets (DIY-SS) has become widespread in recent years. Although the interest of the non-specialist in creating SS is to be welcomed, this has led to concerns that many of these systems may not be 'fit-for-purpose'. The principal reasons for this are the inappropriate scope and focus of the SS and the lack of detailed verification that is carried out. With an appropriate framework to guide them, the OR professional therefore has an important new role to play in supporting DIY-SS by guiding the DIY developer. A set of 20 guidelines is presented to help the OR specialist guide the DIYer to 'scope' any proposed SS. Then a set of 21 'points of best practice'is presented to support verification as the resultant SS is developed. The paper concludes by briefly reflecting on the new role for the OR specialist.

AB - The implementation of 'do it yourself' spreadsheets (DIY-SS) has become widespread in recent years. Although the interest of the non-specialist in creating SS is to be welcomed, this has led to concerns that many of these systems may not be 'fit-for-purpose'. The principal reasons for this are the inappropriate scope and focus of the SS and the lack of detailed verification that is carried out. With an appropriate framework to guide them, the OR professional therefore has an important new role to play in supporting DIY-SS by guiding the DIY developer. A set of 20 guidelines is presented to help the OR specialist guide the DIYer to 'scope' any proposed SS. Then a set of 21 'points of best practice'is presented to support verification as the resultant SS is developed. The paper concludes by briefly reflecting on the new role for the OR specialist.

KW - decision support systems

KW - modelling

KW - spreadsheets

KW - user-analyst

KW - validation

UR - http://www.scopus.com/inward/record.url?eid=2-s2.0-0346479430&partnerID=MN8TOARS

UR - https://www.sciencedirect.com/science/article/pii/S0377221799003318?via%3Dihub

U2 - 10.1016/S0377-2217(99)00331-8

DO - 10.1016/S0377-2217(99)00331-8

M3 - Article

SN - 0377-2217

VL - 127

SP - 14

EP - 27

JO - European Journal of Operational Research

JF - European Journal of Operational Research

IS - 1

ER -

The role of OR specialists in 'do it yourself' spreadsheet development

Abstract

Keywords

Access to Document

Other files and links

Fingerprint

Cite this