Sensitivity Analysis of a Coupled Function in Microsoft Excel

This tutorial allows you to complete a sensitivity analysis of the following analytical nonlinear function:

The function has additive linear and nonlinear terms and one coupling term.

Contribution to the output variance (reference values):

  • X1: 18.0%

  • X2: 30.6%

  • X3: 64.3%

  • X4: 0.7%

  • X5: 0.2%

Task Description

This tutorial demonstrates how to do the following:

  • Generate a solver chain using Excel

  • Define the parameters and responses

  • Specify parameter properties

Preparation

Before you start the tutorial, download the coupled_function_excel zip file from here , and extract it to your working directory.

Tutorial Steps

Creating a New Project

  1. Start optiSLang.

  2. From the Start screen, click Guided.

  3. From the solver list, click Excel.

Selecting the Input File

  1. In the Select input file dialog box, browse to the coupled_function_excel folder and select coupled_function.xls.

  2. Click Open.

Selecting the Parameters and Response

  1. In the Name Manager table, select rows 1-5 (WB_X1 to WB_X5) and drag them to the Parameter pane.

  2. Right-click WB_X1 and select Rename from the context menu.

  3. Change the name to X1 and press Enter.

  4. Repeat steps 2 and 3 for the remaining parameters.

  5. In the Name Manager table, select row 6 (WB_Y1) and drag it to the Responses pane.

  6. Right-click WB_Y1 and select Rename from the context menu.

  7. Change the name to Y and press Enter.

  8. Click Next.

Editing the Parameter Properties

  1. To highlight all of the parameters in the table, do one of the following:

    • Click the name of the first parameter, press Shift, and then click the name of the parameter the last row.

    • Click the name of the first parameter, then with the mouse key pressed, pull down to the last parameter and release the mouse key.

  2. While pressing the Shift key, double-click the range numbers in row 5.

  3. Change the lower bound to -3.14 and the upper bound to 3.14.

  4. Press Enter.

    The range of all of the parameters changes to -3.14 and 3.14.

  5. Click Next.

Defining the Optimization Criteria

  1. Do not adjust or add to the currently displayed values for parameters, responses, and criteria.

  2. Click Next.

Creating the Solver Chain Template

  1. Select the Create a template from solver chain check box.

  2. Click Finish.

    The template is displayed in the Scenery pane.

Saving and Running the Project

  1. To save the project, click  .

  2. Browse to the location to save the project and type a project name in the File name field.

  3. Click Save.

  4. To run the project, click  .

  5. To review the result, double-click the coupled function template and switch to the Result designs tab.