Enhance Your Own Research Productivity Using Spreadsheets

@inproceedings{Wagner2006EnhanceYO,
  title={Enhance Your Own Research Productivity Using Spreadsheets},
  author={Janet M. Wagner and Jeffrey M. Keisler},
  year={2006}
}
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… 
A Spreadsheet Scenario Analysis Technique That Integrates with Optimization and Simulation
TLDR
A tutorial for a better scenario analysis technique that can be programmed into an existing spreadsheet in a matter of minutes and integrated with the Excel Solver to allow for rapid optimization of multiple scenarios and with the Crystal Ball add-in for Monte Carlo simulation.
Data Organization in Spreadsheets
TLDR
Practical recommendations for organizing spreadsheet data to reduce errors and ease later analyses are offered.
Data Visualization in Evaluating Service Delivery
The delivery of human services has become highly complex and is increasingly reliant on the capacity of experienced local service providers to evaluate complex datasets so as to provide adequate
Untidy Data: The Unreasonable Effectiveness of Tables
TLDR
It is argued that interactive tables are an important visualization idiom in their own right; that the direct data interaction they afford offers a fertile design space for visual analytics; and that sense making can be enriched by more flexible human-data interaction than is currently supported in visual analytics tools.

References

SHOWING 1-10 OF 16 REFERENCES
Spreadsheet modeling and decision analysis
TLDR
This new edition of Spreadsheet Modeling and Decision Analysis provides instruction in the most commonly used management science techniques and shows how these tools can be implemented using the most current version of Microsoft Excel for Windows.
Real programmers don't use spreadsheets
Spreadsheets were invented more than ten years ago and they are used as the only or primary computer language by millions of computer users [14]. However, the only reference that has been seen by the
Excel 2003 Bible
TLDR
This is the comprehensive resource for Excel 2003, written by the leading Excel guru known as "Mr. Spreadsheet," John Walkenbach, and fully updated to include all-new "X" features.
Excel 2003 For Dummies
TLDR
This guide is fully updated for the newest release of Excel, which is the most widely used spreadsheet application in the world, especially in business settings.
The Importance and Criticality of Spreadsheets in the City of London
TLDR
The author suggests that the City of London is presently exposed to significant reputational risk through the continued uncontrolled use of critical spreadsheets in the financial markets and elsewhere.
Estimating the numbers of end users and end user programmers
TLDR
With improvements to Boehm's method, it is estimated that in 2012 there will be 90 million end users in American workplaces, while over 13 million will describe themselves as programmers, compared to BLS projections of fewer than 3 million professional programmers.
Guide to Business Modelling
This is the new, fully updated and expanded edition of the definitive guide to creating business models that can be used to evaluate anything from a modest business proposal to a major acquisition.
Spreadsheet Modeling and Applications: Essentials of Practical Management Science
TLDR
This book discusses Spreadsheet Modeling, the Seven-Step Modeling Process, and Real Applications of Simulation with Built-In Excel Tools.
Top 10 list [software development]
TLDR
The article presents 10 techniques that can help reduce the flaws in your code and improve the ability of software developers to predict and control efficient software projects.
Software Engineering: A Practitioner's Approach
...
...