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

Walkthrough: Binding Data to Decisions

Solver Foundation 3.0

When you create a model, you can bind data to decisions so that the model can be performed over a range. In this supply chain example, you can add the number of aircraft on 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.

    Aircraft

    Route

    AC

    Rte

    Allocation

    Boeing 777

    NY-LA

    0

    0

    10

    Boeing 777

    NY-SF

    0

    1

    0

    Boeing 777

    NY-Dallas

    0

    2

    0

    Boeing 777

    NY-Houston

    0

    3

    0

    Boeing 777

    NY-Boston

    0

    4

    0

    Boeing 737

    NY-LA

    1

    0

    0

    Boeing 737

    NY-SF

    1

    1

    10

    Boeing 737

    NY-Dallas

    1

    2

    3

    Boeing 737

    NY-Houston

    1

    3

    6

    Boeing 737

    NY-Boston

    1

    4

    0

    Airbus A320

    NY-LA

    2

    0

    0

    Airbus A320

    NY-SF

    2

    1

    5

    Airbus A320

    NY-Dallas

    2

    2

    0

    Airbus A320

    NY-Houston

    2

    3

    0

    Airbus A320

    NY-Boston

    2

    4

    20

    Airbus A330

    NY-LA

    3

    0

    9

    Airbus A330

    NY-SF

    3

    1

    0

    Airbus A330

    NY-Dallas

    3

    2

    6

    Airbus A330

    NY-Houston

    3

    3

    0

    Airbus A330

    NY-Boston

    3

    4

    0

    Unallocated

    NY-LA

    4

    0

    0

    Unallocated

    NY-SF

    4

    1

    0

    Unallocated

    NY-Dallas

    4

    2

    0

    Unallocated

    NY-Houston

    4

    3

    0

    Unallocated

    NY-Boston

    4

    4

    0

To bind data to a decision

  1. Select all the data in the three rightmost columns, including the column 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 Any.

  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 Any.

  8. In the Decisions tab, click New, and then click Decision.

  9. For the Name, type Allocation.

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

  11. Next to Binding, click the (…) ellipsis button.

  12. The Binding Editor appears.

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

  14. In the Set column, select Aircraft.

  15. In the Columns column, select AC.

  16. In the Set column, select Routes.

  17. In the Columns column, select Rte.

  18. In the Value Field drop-down, ensure that Allocation is selected.

  19. Click OK.

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