Enhance your own research productivity using spreadsheets (From sin to salvation)

Spreadsheets are the modeling tool of choice for a large number of OR/MS researchers. Surveys of users show that most do not use basic good practices and most large spreadsheets have flaws leading to results ranging from wasted time to downright scandal. Fortunately, many of the solutions to these problems are already known and easily learned. This workshop, taught by OR/MS modelers who have first hand experience with both ”sin” and ”salvation” in the spreadsheet kingdom, presents the authors’ ”top ten” Excel methods and four major spreadsheet applications from their own research and professional lives. Tutorial participants, bring your laptops!

[1]  Greg Harvey.  Excel 2003 For Dummies , 2001 .

[2]  Larry E. Rittenberg,et al.  Auditing in a changing environment : SAS 99 & Sarbanes-Oxley : to accompany auditing, concepts for a changing environment , 2004 .

[3]  Cliff T. Ragsdale,et al.  Spreadsheet modeling and decision analysis , 1996 .

[4]  Ian Sommerville,et al.  Software Engineering (7th Edition) , 2004 .

[5]  Mary Shaw,et al.  Estimating the numbers of end users and end user programmers , 2005, 2005 IEEE Symposium on Visual Languages and Human-Centric Computing (VL/HCC'05).

[6]  Patrick O'Beirne.  Spreadsheet Check and Control , 2005 .

[7]  Sandra D. Eksioglu,et al.  Developing Spreadsheet-Based Decision Support Systems , 2007 .

[8]  John Walkenbach,et al.  Excel 2003 Bible , 2001 .

[9]  Grenville J. Croll.  The Importance and Criticality of Spreadsheets in the City of London , 2007, ArXiv.

[10]  David Chadwick.  Stop that Subversive Spreadsheet! , 2002, IICIS.

[11]  John Tennent,et al.  Guide to Business Modelling , 2001 .

[12]  Stephen G. Powell,et al.  The Art of Modeling with Spreadsheets , 2003 .

[13]  Randal J. Elder Mark S. Beasley Alvin A. Arens.  Auditing and Assurance Services: An Integrated Approach , 2002 .

[14]  S. Christian Albright,et al.  Spreadsheet Modeling and Applications: Essentials of Practical Management Science , 2004 .

[15]  Rommert J. Casimir,et al.  Real programmers don't use spreadsheets , 1992, SIGP.

[16]  Roger S. Pressman,et al.  Software Engineering: A Practitioner's Approach , 1982 .

[17]  Richard B. Chase,et al.  Operations Management , 2019, CCSP (ISC)2 Certified Cloud Security Professional Official Study Guide, 2nd Edition.

[18]  Barry W. Boehm,et al.  Software Defect Reduction Top 10 List , 2001, Computer.

[19]  Andrew M. Kuhn,et al.  Code Complete , 2005, Technometrics.