Metamodel of Optimal Prognosis Solver in Excel

This tutorial allows you to calculate a set of designs using the Metamodel of Optimal Prognosis (MOP) Solver in Excel.

This designs use 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%

 

Preparation

Before you start the tutorial, download the excel_tools zip file from here , and extract it to your working directory. Also ensure that the optiSLang Exel Add-in has been installed.

 

Tutorial Steps

To set up and run the tutorial, perform the following steps:

 

Starting the MOP Solver

  1. Start Excel.

  2. On the Excel Ribbon, switch to the Add-ins tab.

  3. Click MOP solver.

    The MOP solver dialog box opens.

 

Preparing the Excel Sheet

  1. To the right of the Metamodel file field, click the orange folder.

  2. Browse to the excel_tools folder and select MOP_coupled_function.omdb.

  3. Click Open.

  4. Select a cell for table generation. For example, A1.

  5. Click Generate table template.

    The design table is generated and displayed.

    NumberDescription
    1Optional design ID
    2Lower and upper parameter bounds
    3Parameter names and values
    4Response names and values
    5CoP matrix
 

Running the MOP Solver

  1. Highlight row 12.

  2. Click Run MOP solver.

    The response value is generated.

 

Using the MOPSolver Function

The table template contains the MOPSolver field function for all responses and criteria of the reference design. You can use it like all other Excel functions.

  1. Prepare an Excel worksheet with the following data:

    Note:  The A2 cell must contain the full path to the working directory where you have place the excel_tools folder.

  2. Click cell B14.

  3. On the Excel Ribbon, switch to the Formulas tab.

  4. Click Insert Function.

  5. In the category list, select optiSLang Excel Add-in MOP Solve

  6. Select the MOPSolver function.

  7. Click OK.

  8. For the MetaModelDatabaseFile argument, select cell A2.

  9. For the ParameterNames argument, select cells A6, A7, A8, A9, and A10.

  10. For the ResponseName argument, select cell A14.

  11. For the ParameterValues argument, select cells B6, B7, B8, B9, and B10.

  12. For the Extrapolate argument, enter 0.

  13. Click OK.

    The approximation value is displayed.