Exporting Approximation Data to Excel

Once you have initialized your RBF or RSM approximation, you can export the approximation data to Microsoft Excel. You can run the mathematics of your approximation in Excel after exporting the data. You can edit input values in Excel using the automatically generated Approximation worksheet, create two-dimensional or three-dimensional graphs selecting different input/output parameters, and share the approximation information on the Excel worksheet with non-Isight users.

There are two Excel macros available after exporting approximation data:

  • The Create Graph Data macro creates a two-dimensional or three-dimensional graphs data sheet and graph by looping over values in the Approximation worksheet.

  • The Refresh Graph Data macro updates previously created data sheets and graphs based on current input values on the Approximations tab.

Note: You can export data to Excel only on Windows operating systems.

  1. After initializing your approximation, click Export on the Coefficients Data tab.

    The Export Data dialog box appears.

  2. Click Export to Excel to send the data to Excel.

    Excel is started automatically, and an Approximation worksheet is populated.

    The two macro buttons, Create Graph Data and Refresh Graph Data, appear on the worksheet. The macros are also available from the Isight menu.

    You can edit input values on the Approximation worksheet in Excel. New output values are updated automatically using your approximation formulas.

    Important: Do not edit the output values because that decreases the integrity of your original approximation formula.

  3. Verify that you are viewing the Approximations tab, and click Create Graph Data.

    The Isight Approximation dialog box appears.

  4. Click 3D or 2D.

    If you select 3D, you need to select two input parameters and one output parameter. If you select 2D, you need to select one input parameter and one output parameter.

  5. In the Input 1 list, select the input parameter of your choice.

    The Number, Minimum, and Maximum text boxes are populated automatically.

  6. If you selected 3D, in the Input 2 list, select the input parameter of your choice.

    The Number, Minimum, and Maximum text boxes are populated automatically.

  7. In the Output list, select the output parameter of your choice.

  8. If desired, click Generate Graphs if you want to create graphs based on your selections.

  9. Click OK.

    Depending on the type of graph created, a new tab titled 3Dgraph1 or 2Dgraph1 is created.

  10. Repeat Step 3 through Step 9 to generate additional graphs.

    New tabs are created for each graph (e.g., 3Dgraph2, 2Dgraph2, etc.).

  11. From the Approximations tab, click Refresh Graphs.

    All previously created data sets and graphs are updated based on the current input parameters on the Approximations tab.

  12. Close Excel and save your changes, if needed.