question

Christian avatar image
0 Likes"
Christian asked Jeff Nordgren converted comment to answer

What's the best way to route this?

Looking for help on how to route items through different resources based on an excel spreadsheet that contains the route.

Should I use a list? Can I just use the table that already imports from excel?

test.fsm

data.xlsx

FlexSim 19.0.2
labelslistsexcel importrouting
data.xlsx (8.9 KiB)
test.fsm (20.1 KiB)
5 |100000

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

1 Answer

Jeff Nordgren avatar image
0 Likes"
Jeff Nordgren answered

@CK,

Attached is your model and Excel file with the changes that I've made. I only added one column to the Excel Arrival tab to add a "Type" field at the end to specify an itemtype. It's a lot less complicated and faster to use a numeric value to look item ups in a global table. So I added this column to the Source to make lookups into the Routes table easier and faster.

You can use the current Routes table, as is, to route flowitems. I put the code for this in the Flow tab in the Properties window, in the Send To Port cpde of all the Objects (except the Combiners, of course). This code will properly route flowitems based on the global table.

But, your routing makes no sense to me when it comes to sending flowitems to the Combiners. A combiner uses input port 1 for the "container" flowitem. This has to be the first item to enter the Combiner (through input port 1). You don't have to run the mode far to find out that there is a fatal blockage at the combiners. You have Product A1 (Type 1) that is being routed from Pressing2 to Combiner1 to its input port 2. You have input port1 of Combiner1 connected to Pressing1. That should be the first item to enter Combiner1 but that will never happen because item C3 can never get there because of the Blockage at the Forming object.

In short, I have no idea what you are trying to do when it comes to the routing for the Combiners inputs. You have all three Pressing processors connected to both Combiners. That makes no sense to me. So I'm not sure how to fix your model because I don't understand what you are trying to do with the Combiners. Other than that, the model should work using the existing Routes table.

In you can explain in more detail how you want the Combiners to work, then I would be able to help with that. Take a look at the model and see if, other than the Combiners, it is working as you want. Let us know if you have any problems or questions.

Thanks.

ck-test-jn1.zip


ck-test-jn1.zip (27.7 KiB)
· 3
5 |100000

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