Analysis ToolPak
First things first, let MOB == "Microsoft Office Button" which is the big round button at the top left of the window.
To load Analysis ToolPak in Excel 2007:
1. Click MOB. Hit "i" to enter "Excel Options". (Alternatively: Alt-F-i will get you there).
2. Click add-ins. Add the AnalysisTP and TP-VBA add-ins.
Once Analysis ToolPak (ATP) is loaded it appears as "Data Analysis" icon in Data menu.
Solver
Step 1: Make sure this add-in is installed.
How does Solver work?
Specify: Set target cell [cell which contains formula], By Changing Cells [cells containing inputs], Subject to constraints e.g. $B$5$ <= 5.
No comments:
Post a Comment