O'Reilly logo

Optimization Modeling with Spreadsheets, 3rd Edition by Kenneth R. Baker

Stay ahead with the world's most comprehensive technology and business learning platform.

With Safari, you learn the way you learn best. Get unlimited access to videos, live online training, learning paths, books, tutorials, and more.

Start Free Trial

No credit card required

1INTRODUCTION TO SPREADSHEET MODELS FOR OPTIMIZATION

This is a book about optimization with an emphasis on building models and using spreadsheets. Each facet of this theme—models, spreadsheets, and optimization—has a role in defining the emphasis of our coverage.

A model is a simplified representation of a situation or problem. Models attempt to capture the essential features of a complicated situation so that it can be studied and understood more completely. In the worlds of business, engineering, and science, models aim to improve our understanding of practical situations. Models can be built with tangible materials, or words, or mathematical symbols and expressions. A mathematical model is a model that is constructed—and also analyzed—using mathematics. In this book, we focus on mathematical models. Moreover, we work with decision models, or models that contain representations of decisions. The term also refers to models that support decision-making activities.

A spreadsheet is a row-and-column layout of text, numerical data, and logical information. The spreadsheet version of a model contains the model’s elements, linked together by specific logical information. Electronic spreadsheets, like those built using Microsoft® Office Excel®, have become familiar tools in the business, engineering, and scientific worlds. Spreadsheets are relatively easy to understand, and people often rely on spreadsheets to communicate their analyses. In this book, we focus on the use of spreadsheets ...

With Safari, you learn the way you learn best. Get unlimited access to videos, live online training, learning paths, books, interactive tutorials, and more.

Start Free Trial

No credit card required