OPR 320 Linear Models for Decision Making Homework
Loading the Solver Add-in:
INSTRUCTIONS FOR WINDOWS, EXCEL VERSIONS 2010, 2013, 2016:
Before you add the Solver add-in in Excel, you must first make sure that all Office Updates have been installed:
1. Be sure to save and close all Office applications currently running, including Word, Excel, PowerPoint, Outlook, etc.
2. Start Excel.
3. Go to the File Menu and select Accounts.
4. Click on the Office Updates button.
5. Follow the prompts to install all updates.
Steps to add the Solver add-in:
1. In Excel, go to the File Menu and select Options.
2. Click Add-Ins, and then in the Manage box, select Excel Add-ins.
3. Click Go.
4. In the Add-Ins available box, select the Solver Add-in check box, and then click OK. Tip: If Solver Add-in is not listed in the Add-Ins available box, click Browse to locate the add-in. If you get prompted that the Solver Add-in is not currently installed on your computer, click Yes to install it.
5. After you load the Solver Add-in, the Solver command is available in the Analysis group on the Data tab.
INSTRUCTIONS FOR MAC, EXCEL VERSIONS 2010, 2013, 2016:
Before you add the Solver add-in in Excel, you must first make sure that all Office Updates have been installed:
1. Be sure to save and close all Office applications currently running, including Word, Excel, PowerPoint, Outlook, etc.
2. Start Excel.
3. Go to the Help Menu and select Check for Updates.
4. Follow the prompts to install all updates.
Steps to add the Solver add-in in Excel 2011, 2016 (Mac):
1. On the Tools menu, select Add-Ins.
2. In the Add-Ins available box, select the Solver Add-In check box, and then click OK.
· If Solver Add-in is not listed in the Add-Ins available box, click Browse to locate the add-in.
· If you get prompted that the Solver add-in is not currently installed on your computer, click Yes to install it.
3. After you load the Solver add-in, the Solver button is available in the on the Data tab.