question

Tamilselvan avatar image
0 Likes"
Tamilselvan asked Felix Möhlmann answered

Acquire a Specific resource

I have 14 processors and 7 model variants. Each machine is capable of handling specific model variants. How can I query or identify the appropriate machine based on the model? i have the machines in the group



 Model_1 Model_2 Model_3 Model_4 Model_5 Model_6 Model_7
Machine_1 0 0 0 0 0 Machine_1 0
Machine_2 0 0 0 0 0 0 Machine_2
Machine_3 Machine_3 0 0 0 0 0 0
Machine_4 0 Machine_4 0 0 0 0 0
Machine_5 0 0 Machine_5 0 0 0 0
Machine_6 0 0 0 Machine_6 0 0 0
Machine_7 0 0 0 0 Machine_7 0 0
Machine_8 0 0 0 0 0 Machine_8 0
Machine_9 0 0 0 0 0 0 Machine_9
Machine_10 0 0 0 0 Machine_10 Machine_10 0
Machine_11 0 0 0 Machine_11 0 0 0
Machine_12 0 0 Machine_12 0 0 0 0
Machine_13 0 Machine_13 0 0 0 0 0
Machine_14 Machine_14 0 0 0 0 0 0

based on the matrix it need to acquire the machine automatically.


FlexSim 24.0.0
acquire resource
5 |100000
Toggle Comment visibility. Current Visibility: Viewable by all users

Up to 12 attachments (including images) can be used with a maximum of 23.8 MiB each and 47.7 MiB total.

1 Answer

Felix Möhlmann avatar image
0 Likes"
Felix Möhlmann answered Tamilselvan commented

Add a field to the resource list that reads the cell corresponding to the queried machine and the item's model. If the table cell's value is not 0, the machine can be pulled. In the query field use a WHERE statement to filter for objects where this is true.

capture1.png

This example picture assumes:

- The name of the table is "ModelMachineMatrix" and it is formatted exactly as in your post.
- The row headers match the name of the machines
- The token (puller in the list expression) has a label that references the item which in turn has a label "Type" that either matches a column name or number.


capture1.png (40.0 KiB)
5 |100000
Toggle Comment visibility. Current Visibility: Viewable by all users

Up to 12 attachments (including images) can be used with a maximum of 23.8 MiB each and 47.7 MiB total.