Spreadsheet Analytics

 

 Masagung Graduate School of Management                                                                        Updated: November 15, 2004

Home
Algorithms
Model Implementations
Sensitivity Analysis
Software We'd Like to See
Spreadsheet Engineering
Spreadsheet Research
Conferences & Training
Books & Readings
Textbooks
Sources for Books
Other Resources

Books

Risk Assessment and Decision Making in Business and Industry - A Practical Guide

Author:  Glenn Koller

Publisher:  CRC Press

ISBN: 0-8493-0268-4

 

Editorial Comments: This book is an easy-to-understand resource for risk/uncertainty assessment and decision making of all types. The volume begins with a simple explanation of the process of risk assessment and expands to such topics as communication, building consensus, risk assessment technologies, and Monte Carlo analysis. The author, who has responsibilities for risk management, analysis and training at BP Amoco, emphasizes that the technical aspects of risk assessment and decision-making effort are secondary to the cultural, organizational, and interpersonal facets of establishing a framework.

 

Areas examined include brokerage-house portfolio management, legal decision-making, construction, oil/gas exploration, environmental assessments, engineering, marketing, government, manufacturing, and others. The entire volume is presented as a narrative, keeping statistical jargon to a minimum and explaining all concepts, techniques, and processes in a straightforward manner. The book enables readers who are not risk experts to effect an easy execution of the risk/uncertainty model building effort.

Risk Modeling for Determining Value and Decision Making

Author:  Glenn Koller

Published: Chapman & Hall / CRC

ISBN: 1-58488-167-4

 

Editorial Comments: Also by Glenn Koller, this text presents comprehensive examples of risk/uncertainty analyses from a broad range of applications, including decision/option selection, environmental assessments, identification of business drivers, insurance, investing, production sharing, manufacturing, pricing, schedule and optimization, security, law, and other applications.

 

Emphasizing value as the focus of risk assessment, this book offers discussions on how to make decisions using risk models and the insights that such models can provide. The presentation of each model also includes computer code that encapsulates its logic and offers direction on how to apply the model to other types of problems.

The last few chapters discuss the fundamentals of risk assessment similar to the previously described book.

Simulation Modeling Using @ Risk

Author: Wayne L. Winston
Publisher: Duxbury, 1996
ISBN: 0-534-26492-1
Software used: @RISK, Microsoft Excel

Quantitative Risk Analysis: A Guide to Monte Carlo Simulation and Modeling

Author: David Vose
Publisher: John Wiley and Sons, 1997

Publisher Comments:  The first five chapters cover the basics of risk analysis and probability distribution functions and have little to no spreadsheet content. Chapter

6 uses spreadsheets quite a bit, and from then on he uses Excel models to demonstrate techniques and examples in most of the remaining 6 chapters.

Decisions Involving Uncertainty: An @RISK Tutorial for the Petroleum Industry

Author: James Murtha
Publisher: Copyright 1993, 1995 James A. Murtha Houston, TX. (no publisher)
Software used: @RISK

Selected Readings

"Design and use of the Microsoft Excel Solver"

Author(s): Fylstra, D., L. Lasdon, J. Watson, A. Waren

Publisher: Interfaces, vol. 28 no. 5 (Sep-Oct 1998), pp 29-55.

 

Editorial Comments:  Description of the Excel Solver including: user interface, model processing, and solution algorithms for linear, nonlinear, and integer programs. Describes some of the common pitfalls users encounter and remedies available in the latest version of Microsoft Excel. Discusses the differences between management science using spreadsheets vis a vis traditional software.

"Spreadsheet Add-Ins for OR/MS"

Author: Thomas A. Grossman

Publisher:  OR/MS Today, 29(4): 46-51, August 2002.

 

Author Comments:  A summary of available OR/MS add-ins. Tables listing the add-ins available at: http://www.lionhrtpub.com/orms/surveys/SSA/SSA.html.

Sources for Books

 

 

DISCLAIMER

The products and services on this page are provided for informational purposes only.   No endorsement is implied.  Your mileage may vary. No warranty express or implied is provided.  There is no guarantee that the information provided here is current or accurate. Use these links and the associated products or services at your own risk.

 

 

Home Algorithms Model Implementations Sensitivity Analysis Software We'd Like to See Spreadsheet Engineering Spreadsheet Research Conferences & Training Books & Readings Textbooks Sources for Books Other Resources