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

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

View Full Document Right Arrow Icon
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.
Background image of page 1

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

View Full DocumentRight Arrow Icon
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
Background image of page 2
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
Background image of page 3

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

View Full DocumentRight Arrow Icon
Steps for activating “Solver” as an Add-In in Excel. Begin by opening the software “Excel” from the Microsoft Office suite of programs.
Background image of page 4
Click on the multicolored “Office Button”
Background image of page 5

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

View Full DocumentRight Arrow Icon
Image of page 6
This is the end of the preview. Sign up to access the rest of the document.

Page1 / 16

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

This preview shows document pages 1 - 6. Sign up to view the full document.

View Full Document Right Arrow Icon
Ask a homework question - tutors are online