ASP, the art and science of practice: Increasing productivity and minimizing errors in operations research spreadsheet models

Larry J. LeBlanc, Michael R. Bartolacci, Thomas A. Grossman

Research output: Contribution to journalArticle

1 Scopus citations

Abstract

Operations research practitioners often write spreadsheet software that is used, modified, and transferred to other people over time. They need techniques that enable them to quickly write error-free code whose accuracy can be easily verified and tested. Practitioner spreadsheet models often must be suitable for transfer to others and be robust in the sense that inadvertently introducing errors during reuse and updating is difficult. We examine some problem areas for spreadsheet design and programming and suggest techniques intended to increase productivity and reduce the risk of errors, especially in situations in which someone other than the original author is using or maintaining the spreadsheets.

Original languageEnglish (US)
Pages (from-to)260-269
Number of pages10
JournalInterfaces
Volume47
Issue number3
DOIs
StatePublished - May 1 2017

All Science Journal Classification (ASJC) codes

  • Strategy and Management
  • Management Science and Operations Research
  • Management of Technology and Innovation

Fingerprint Dive into the research topics of 'ASP, the art and science of practice: Increasing productivity and minimizing errors in operations research spreadsheet models'. Together they form a unique fingerprint.

  • Cite this