The Sensitivity Toolkit

TUCK TORNADO

• Tuck Tornado Website (Windows & Macintosh versions)

SOLVER SENSITIVITY

• Download Solver Sensitivity (Updated: 11/17/2023)

Installation Instructions: Windows

1. Download SolverSensitivity.zip. Create a directory in your My Documents folder and give it a meaningful name (e.g. Sensitivity) and save the file in that folder. Right click on the file and extract SolverSensitivity.xlam to the directory.
2. Right-click on SolverSensitivity.xlam and click the Properties option. If there is a button on that menu marked Unblock then click that button and then click Apply.
3. Check the security setting for your copy of Excel. Click File | Options | Trust Center | Trust Center Settings and then make sure the checkbox for Trust access to the VBA object model is checked. Click OK.
4. Install Solver Sensitivity. Click File | Options | Add-Ins. At the bottom of the right pane is a dropdown box and Excel Add-ins is usually selected as the default, else select it. Click the Go... button. Click the Browse... button and navigate to where you stored SolverSensitivity.xlam. You will be asked if you would like to copy the file to your Addins folder, click No. Click OK.
5. Restart Excel. Solver Sensitivity should now be available under the Sensitivity Toolkit submenu of your Add-Ins menu.

Installation Instructions: Macintosh

1. Download SolverSensitivity.zip. Create a directory in your My Documents folder and give it a meaningful name (e.g. Sensitivity) and save the file in that folder. Right click on the file and extract SolverSensitivity.xlam to the directory.
2. Check the security setting for your copy of Excel. Click Excel | Preferences | Security and then make sure the checkbox for Trust access to the VBA project object model is checked.
3. Install Solver Sensitivity. Click Tools | Excel Add-ins.... Click the Browse... button and navigate to where you stored SolverSensitivity.xlam. You may be asked if you would like to copy the file to your Addins folder, if so, click No. Click OK.
4. Restart Excel. Solver Sensitivity should now be available under the Sensitivity Toolkit submenu of your Add-ins menu. The Add-ins menu will be on the Workbook's menu line.

Support

The Sensitivity Toolkit is free software, but we cannot offer any promise of support. We will try and answer questions about the Toolkit and give advice, but be advised that there may be a considerable delay before we can respond. Please direct all inquires to: sensitivity.toolkit@dartmouth.edu.

Toolkit Authors

• Bob Burnham (developer)
• Ken Baker
• Steve Powell