question

Maria A31 avatar image
0 Likes"
Maria A31 asked Maria A31 commented

Excel problem

Hello! I have a problem with the attached model. Once i upload another excel from these it already has, it stops the model at some point and doesn't run even though it can process many more orders.

I have unclick the options that loads a new excel when it is updated because that was the main problem at the beggining.ReachTrucks.fsm

FlexSim 21.1.5
excel
reachtrucks.fsm (686.8 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

·
Felix Möhlmann avatar image
0 Likes"
Felix Möhlmann answered Maria A31 commented

The 'order tokens' enter a dead end when there are no more entries left in the global table. You need some way for them to re-enter the loop after you update the table with new orders.

1654841048876.png

For example, you could send a message to the buffer (or some other object) in the 'Post Import Code' which a 'Wait for Event' activity reacts to and releases the tokens back into the loop.

1654841133627.png

1654841178419.png

reachtrucks(2).fsm


1654841048876.png (5.8 KiB)
1654841133627.png (17.7 KiB)
1654841178419.png (12.2 KiB)
reachtrucks2.fsm (715.6 KiB)
· 5
5 |100000

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

Maria A31 avatar image Maria A31 commented ·

Thank you so much for your help!

But i have noticed since i updated my excel my model stops again while it has more orders to process

0 Likes 0 ·
Felix Möhlmann avatar image Felix Möhlmann Maria A31 commented ·

Did you actually import the changed table into FlexSim? It won't detect any changes to the Excel-File automatically.

Edit:
The order number should also continue on from the last table, or you would have to reset the global variable that counts those and reassign new numbers to the order tokens.

0 Likes 0 ·
Maria A31 avatar image Maria A31 Felix Möhlmann commented ·

Yes i did update the excel, i will attach the file so you can see it too.

(The updated excel is in global table "Picking")

Reachtrucks-updated excel.fsm

0 Likes 0 ·
Show more comments

Write an Answer

Hint: Notify or tag a user in this post by typing @username.

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