Filling Tables from Experimental Data

On this page…
How to Fill Tables from Experimental Data Creating Rules

How to Fill Tables from Experimental Data

Any table in the project whose axes (normalizers) exist as factors in the data set can be filled from imported experimental data (or any data set, such as optimization output).

CAGE extrapolates the values of the experimental data over the range of your table. Then it fills the table by selecting the values of the extrapolation at your breakpoints.

To fill the table with values based on the experimental data,

1. To view the Table Filler display, click (Fill Table From Data Set) in the toolbar; or select View > Table Filler.

   You can use this display to specify the table you want to fill and the factor you want to use to fill it.

2. In the lower pane, select the table from the Table to fill list. This is the table that you want to fill.

3. Select the experimental data from the Factor to fill table list. This is the data that you want to use to fill the table.

   For example, see the following display.

   

   The upper pane displays the breakpoints of your table as crosses and the operating points where there is data as blue dots. Data sets display the points in the experimental data, not the values at the breakpoints. You can inspect the spread of the data compared to the breakpoints of your table before you fill the table.

4. To view the table after it is filled, make sure the Show table history after fill box at the bottom left is selected. This is selected by default.

5. To fill the table, click Fill Table.

   If the Show table history after fill box is selected, the History dialog box opens, similar to the one shown.

   

6. Click Close to close the History dialog box and return you to the Table Filler display.

7. To view the graph of your table, select Data > Plot > Surface.

   

This display shows the table filled with the experimental points overlaid as purple dots.

Back to Top

Creating Rules

You can ignore points in the data set when you fill your lookup table.

By defining a region to include or exclude such points, you create a rule for the table filling.

For example, you might want to fill a lookup table that has a range of operating points that is smaller than the range of the experimental data.

To ignore points in the data set,

1. Select Data > Plot > Data Set. This displays the view of where the breakpoints lie in relation to the experimental data.

2. To define the region that you want to include, left-click and drag the plot. For example, see the following display.

   This region defines a rule in the Table filling rules pane.

   

3. To fill the table based on an extrapolation over these data points only, click Fill Table.

The display of the surface now shows the table filled only by reference to the data points that are included in the range of the table.

You can now review your data set using the options in the View and Plot panes of Data Sets.

You can add any number of rules to follow when filling tables. For example, you might be aware that a particular test run included in the chosen area is not good data. You can click and drag to enclose any chosen point, then right-click that rule (in the Table filling rules pane) and select Exclude Points. You can set any number of rules to make sure you fill the table by using just the points you are interested in.

Right-Click Options

Select Data -> Table Fill to reach the following options:

• Enable Rule: Apply the rule to the data.

• Disable Rule: Do not apply the rule, but also do not delete it.

• Exclude Points: Do not include these points in table filling.

• Include Points: Include points in table filling.

• Promote Rule: Change order of rules.

• Demote Rule: Change order of rules.

• Clear Rule: Delete this rule.

You can use these options to enable an iterative process. You can fine-tune the selection of data points: try different selections of data to fill your tables, check the results, then reuse the same rules for the same or different tables.

Back to Top

Manipulating Models in Data Set View

Exporting Data Sets

© 1984-2012- The MathWorks, Inc.    -   Site Help   -   Patents   -   Trademarks   -   Privacy Policy   -   Preventing Piracy   -   RSS