Export (0) Print
Expand All
0 out of 1 rated this helpful - Rate this topic

Walkthrough: Binding Data to Parameters

Solver Foundation 3.0

When you create a model, you can bind data to parameters so that the model can be performed over a range. In this supply chain example, you can add the capacity of different aircraft over different routes to a model.

To add data to an Excel spreadsheet

  1. In the Solver Foundation ribbon, click Model to display the Modeling Pane.

  2. In the Excel worksheet, enter the following data. The following table lists the carrying capacity per month for each type of plane for each route (in thousands).

    Capacity

    NY-LA

    NY-SF

    NY-Dallas

    NY-Houston

    NY-Boston

    Boeing 777

    16

    15

    28

    23

    81

    Boeing 737

    0

    10

    14

    15

    57

    Airbus A320

    0

    5

    0

    7

    29

    Airbus A330

    9

    11

    22

    17

    55

    Unallocated

    1

    1

    1

    1

    1

To bind data to a parameter

  1. Select all the data, not the column and row names.

  2. In the Sets tab, click New, and then click Set.

  3. For the Name, type Aircraft.

  4. In the Domain drop-down menu, select Nonnegative Real.

  5. In the Sets tab, click New, and then click Set.

  6. For the Name, type Routes.

  7. In the Domain drop-down menu, select Nonnegative Real.

  8. In the Parameters tab, click New, and then click Parameter.

  9. For the Name, type Capacity.

  10. In the Domain drop-down menu, select Nonnegative Real.

  11. Next to Binding, click the […] ellipsis button.

    The Binding Editor appears.

  12. Verify that the range in the Table/Range text box is correct.

  13. Clear the Range Includes Column Headers checkbox.

    When you clear the checkbox, the Columns and Value Field options are disabled. The selected data in the Table/Range text box must be a matrix of values, as in this example, with no column headings.

  14. In the Set column, select Aircraft.

  15. In the Set column, select Routes, and then click OK.

    The members of the Aircraft and Routes sets, a matrix of values, are inferred based on the selected range. The first set, Aircraft, represents the row data, and the second set, Routes, represents the column data.

    For an example that shows how to use data binding in an OML model, see Walkthrough: Creating and Solving a Nonlinear Model.

Did you find this helpful?
(1500 characters remaining)
Thank you for your feedback
Show:
© 2014 Microsoft. All rights reserved.