ASP, The Art and Science of Practice: Increasing Productivity and Minimizing Errors in Operations Research Spreadsheet Models

Larry J. LeBlanc (), Michael R. Bartolacci () and Thomas A. Grossman ()
Additional contact information
Larry J. LeBlanc: Owen Graduate School of Management, Vanderbilt University, Nashville, Tennessee 37203
Michael R. Bartolacci: Information Sciences and Technology, Penn State University – Berks, Reading, Pennsylvania 19610
Thomas A. Grossman: School of Management, University of San Francisco, San Francisco, California 94117

Interfaces, 2017, vol. 47, issue 3, 260-269

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.

Keywords: spreadsheets; implementation; best practices of OR; model reuse (search for similar items in EconPapers)
Date: 2017
References: View references in EconPapers View complete reference list from CitEc
Citations: View citations in EconPapers (1)

Downloads: (external link)
https://doi.org/10.1287/inte.2016.0856 (application/pdf)

Related works:
This item may be available elsewhere in EconPapers: Search for items with the same title.

Export reference: BibTeX RIS (EndNote, ProCite, RefMan) HTML/Text

Persistent link: https://EconPapers.repec.org/RePEc:inm:orinte:v:47:y:2017:i:3:p:260-269

Access Statistics for this article

More articles in Interfaces from INFORMS Contact information at EDIRC.
Bibliographic data for series maintained by Chris Asher ().