Optimization problems are often described in algebraic terms. In this topic, we'll show how you can translate from the algebraic statement of a problem to a spreadsheet model which the Solver can optimize.
A spreadsheet, however, can do much more than accept and compute values for algebraic expressions. It can help you organize and display the structure of the model you are trying to optimize, through tools such as defined names, formatting and outlining. As models become larger, the problems of managing data for constraints, coefficients, and so on become more significant, and a properly organized spreadsheet model can help manage this complexity.
Related Topics: