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

References

• Baxter R (2005) Regulation and the integrity of spreadsheets in the information supply chain. Proc. Eur. Spreadsheet Risks Interest Group, EuSpRIG, London.Google Scholar
• Conway DG, Ragsdale CT (1997) Modelling optimization problems in the unstructured world of spreadsheets. Omega 25(3):313–322.Crossref, Google Scholar
• Croll G (2005) The importance and criticality of spreadsheets in the city of London. Proc. Eur. Spreadsheet Risks Interest Group, EuSpRIG, London.Google Scholar
• Croll GJ, Butler RJ (2006) Spreadsheets in clinical medicine—A public health warning. Proc. Eur. Spreadsheet Risks Interest Group, EuSpRIG, Cambridge, UK.Google Scholar
• EuSpRIG (2013) Spreadsheet mistakes—News stories. Accessed September 17, 2015, http://www.eusprig.org/horror-stories.htm.Google Scholar
• Grossman TA, Mehrotra V, Özlük Ö (2007) Lessons from mission-critical spreadsheets. Comm. Assoc. Inform. Systems 20(60):1009–1042.Google Scholar
• Grossman TA, Özlük Ö, Gustavson J (2009) The lookup technique to replace nested-if formulas in spreadsheet programming. Proc. Eur. Spreadsheet Risks Interest Group (European Spreadsheet Risks Interest Group, Paris).Google Scholar
• Isken MW (2003) Data cleansing and analysis as a prelude to model based decision support. INFORMS Trans. Educ. 3(3):23–75.Link, Google Scholar
• Kernighan BW, Pike R (1999) The Practice of Programming, Addison-Wesley Professional Computing Series (Addison-Wesley, Boston).Google Scholar
• LeBlanc LJ, Grossman TA (2008) Introduction: The use of spreadsheet software in the application of management science and operations research. Interfaces 38(4):225–227.Link, Google Scholar
• Liberatore M, Luo W (2013) ASP, The art and science of practice: A comparison of technical and soft skill requirements for analytics and OR professionals. Interfaces 42(2):194–197.Link, Google Scholar
• McConnell S (1996) Rapid Development (Microsoft Press, Redmond, WA).Google Scholar
• Panko RR (1998) What we know about spreadsheet errors. J. End User Comput. 10(2):15–21.Crossref, Google Scholar
• Panko RR (2008) What we know about spreadsheet errors. Accessed January 28, 2015, http://panko.shidler.hawaii.edu/My%20Publications/Whatknow.htm.Google Scholar
• Powell SG, Baker KR (2013) Management Science: The Art of Modeling with Spreadsheets, 4th ed. (Wiley, Hoboken, NJ).Google Scholar
• Powell SG, Baker KR, Lawson B (2008a) A critical review of the literature on spreadsheet errors. Decision Support Systems 46(1):128–138.Crossref, Google Scholar
• Powell SG, Baker KR, Lawson B (2008b) An auditing protocol for spreadsheet models. Inform. Management 45(5):312–320.Crossref, Google Scholar
• Powell SG, Baker KR, Lawson B (2009a) Errors in operational spreadsheets. J. Organ. End User Comput. 21(3):24–36.Crossref, Google Scholar
• Powell SG, Baker KR, Lawson B (2009b) Impacts of errors in operational spreadsheets. Decision Support Systems 47(2):126–132.Crossref, Google Scholar
• Shapiro JA, Powell WB, Bernstein D (2001) A flexible Java representation for uncertainty in online operations-research models. INFORMS J. Comput. 13(1):29–55.Link, Google Scholar
• Thiriez H (2004) Spreadsheet-based professional modelling. INFORMS Trans. Educ. 4(2):14–27.Link, Google Scholar