Excel Tools: Solver and Goal Seek. A Brown Bag discussion for N-81 26 Sept 2012. THIS PRESENTATION IS UNCLASSIFIED. Purpose. This Talk promises to: (re)introduce some powerful tools in Excel Optimization – centric functions Goal seek Solver
Download Policy: Content on the Website is provided to you AS IS for your information and personal use and may not be sold / licensed / shared on other websites without getting consent from its author.While downloading, if for some reason you are not able to download a presentation, the publisher may have deleted the file from their server.
A Brown Bag discussion for N-81
26 Sept 2012
THIS PRESENTATION IS UNCLASSIFIED
Set Cell: The ‘target’
The desired value of the Set Cell. Must be a ‘literal’.
TOO EASY! Just solve:
I cannot overstress how useful this is for reviewing someone else’s spreadsheet!
Use at least 1 LHA, 2 LCS, and no more than 4 of any type of ship.
… and a whole universe of complexity
WARNING! It is NOT GENERALLY true that the solution to a problem with Integer constraints is ‘close’ to the associated Linear Program!