{[ promptMessage ]}

Bookmark it

{[ promptMessage ]}

# Lecture_9 - NR Econ Lecture 9 Excel's Solver Solver...

This preview shows pages 1–6. Sign up to view the full content.

NR Econ Lecture 9 Excel’s Solver Solver: mathematical software for solving constrained optimization problems Motivation: how do we solve problems like that of the Colorado River water market, in which water must be allocated to 15 distinct sectors? Answer: not by hand, with pencil and paper. Instead, with computer software, like Solver.

This preview has intentionally blurred sections. Sign up to view the full version.

View Full Document
Excel and Solver tutorial Organization of the tutorial: Activating Solver within Excel Tackling a constrained optimization problem in Solver Setting up the various components in Excel Solving the optimization problem using Solver
Before we begin… Reference material distributed yesterday: solver_documentation.pdf -- study the document first -- handy resource for troubleshooting while using Excel and Solver The document is also posted on CTools

This preview has intentionally blurred sections. Sign up to view the full version.

View Full Document
Steps for activating “Solver” as an Add-In in Excel. Begin by opening the software “Excel” from the Microsoft Office suite of programs.
You have opened Excel …what next?

This preview has intentionally blurred sections. Sign up to view the full version.

View Full Document
This is the end of the preview. Sign up to access the rest of the document.

{[ snackBarMessage ]}