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.

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.

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

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