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

Spreadsheet Decision Support

VBA for Modelers: Developing Decision Support Systems Using Management Science 1st Edition

Author: S. Christian Albright
Publisher:  Duxbury, 2001
ISBN: 0-534-38012-3
Software used: Microsoft Excel, VBA


Author/Publisher Comments: Available from Palisade

Operations Research and Management Science

Contemporary Management Science: with Spreadsheets

Author: David R. Anderson, Dennis J. Sweeney, and Thomas A. Williams
Publisher: South-Western College Publishing, 1999
ISBN:
Software used: Microsoft Excel

 

Author/Publisher Comments:  This book emphasizes modeling and the use of spreadsheets. The textbook does an excellent job of making a seamless transition between the mathematical model of a problem and the spreadsheet model and solution process.

Introduction to Simulation and Risk Analysis

Author: James R. Evans and David L. Olson
Publisher: Prentice Hall, 1998
ISBN: 0-13-621608-0
Software used: Crystal Ball, Microsoft Excel

 

Author/Publisher Comments: (not available)


Editorial Comments: Includes CD-ROM with student version of Crystal Ball and Example Files. Seems to be first textbook to fully support Crystal Ball.

Spreadsheet Modeling and Decision Analysis: A Practical Introduction to Management Science, 2nd Edition

Author: Cliff T. Ragsdale
Publisher: South-Western College Publishing, 1998
ISBN: 0-538-86756-6
Software used: Microsoft Excel, http://www.ucalgary.ca/~grossman/resources.htm - atrisk, TreePlan

 

Author/Publisher Comments:  An update to the popular first edition with some new examples, problems and cases; and a new emphasis on creating spreadsheet models that communicate effectively.

The Art of Modeling with Spreadsheets: Management Science, Spreadsheet Engineering, and Modeling Craft

Authors:  Stephen G. Powell, Kenneth R. Baker

Publisher:  Wiley, 2003

ISBN: 0-471-20937-6

 

Author/Publisher Comments:  Steve Powell and Ken Baker's The Art of Modeling with Spreadsheets covers spreadsheet engineering, management science techniques, and those essential craft skills needed to develop real expertise in business modeling.

Practical Management Science: 2nd Edition

Author: Wayne L. Winston and S. Christian Albright
Publisher: Duxbury, 1997
ISBN: 0-534-42435-X
Software used: Microsoft Excel, Palisade Decision Tools Suite, Albright's StatPro statistical add-in

 

Editorial Comments: A truly innovative book. Virtually no use of algebraic representation of models. Heavy focus on realistic applications, with many applications outside of operations management.

Spreadsheet Modeling and Applications: Essentials of Practical Management Science

Author: S. Christian Albright and Wayne L. Winston
Publisher: Duxbury, 2005
ISBN: 0-534-38032-8
Software used: Microsoft Excel, Palisade Decision Tools Suite, Palisade StatTools statistical add-in

 

Author/Publisher Comments: : Based upon the best practices from undergraduate and MBA courses at Indiana University, as well as courses taught to professionals at companies such as Microsoft, Eli Lilly, and GM, this is the most practical introduction to management science available. Derived from the authors’ earlier text, Practical Management Science, this simplified and streamlined version covers all of the fundamental concepts needed to solve problems and make informed decisions

Applied Management Science: A Computer-Integrated Approach for Decision Making

Author: John A. Lawrence, Jr. and Barry A. Pasternack
Publisher: Wiley, 1998
ISBN: 0-471-13776-6
Software used: Microsoft Excel, WinQSB


Editorial Comments: (WinQSB included on CD-ROM)

Managerial Spreadsheet Modeling and Analysis

Author: Rick Hesse
Publisher: Irwin, 1997
ISBN: 0-256-21530-8
Software used: generic spreadsheet (cell formulas in text are for Lotus 1-2-3, Microsoft Excel files included on diskette)

 
Author/Publisher Comments (Not Available)

Management Science: A Spreadsheet Approach for Windows

Author: Donald R. Plane
Publisher: Boyd & Fraser, 1996
ISBN: 0-87709-899-9
Software used: What's Best! 2.0, Lotus 1-2-3, MS Excel


Editorial Comments: The book that started it all. Very strong on formulation for beginners and documentation of spreadsheets. What's Best! included on diskette.

INSIGHT: Business Analysis Software for Microsoft Excel

Author: Sam L. Savage
Publisher: BrooksCole, 1998
ISBN: 0-534-52038-3
Software used: Excel, INSIGHT


Editorial Comments: INSIGHT included with book

Applied Management Science and Spreadsheet Modeling

Author: Francis J. Clauss
Publisher: Duxbury, 1996
ISBN: 0-534-25842-5
Software used:


Author/Publisher Comments: (Not Available)

Management Science: Modeling, Analysis and Interpretation

Author: Jeffrey D. Camm and James R. Evans
Publisher: South-Western College Publishing, 1997
ISBN: 0-538-82738-6
Software used: Microsoft Excel, Lotus 1-2-3, LINDO


Author/Publisher Comments: (Not Available)

Introductory Management Science: Decision Modelling with Spreadsheets, 5th Edition

Author :Gary Eppen, F.J. Gould, Charles Schmidt, Jeff Moore, and Larry Weatherford
Publisher: Prentice Hall 1998
ISBN:013-889395-0
Software used: Microsoft Excel, Crystal Ball, @RISK,TreePlan, Graphical LP Optimizer


Author/Publisher Comments: (Not Available)

Sources for Books

 

 

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