topic Re: Excel problem in FlexSim Forum

Excel problem

maria_a31 — Thu, 09 Jun 2022 17:38:41 GMT

[ FlexSim 21.1.5 ]

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

Re: Excel problem

moehlmann_fe — Fri, 10 Jun 2022 06:06:37 GMT

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.

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.

reachtrucks(2).fsm

Re: Excel problem

maria_a31 — Fri, 10 Jun 2022 06:40:53 GMT

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

Re: Excel problem

moehlmann_fe — Fri, 10 Jun 2022 07:50:29 GMT

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.

Re: Excel problem

maria_a31 — Fri, 10 Jun 2022 07:55:58 GMT

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

Re: Excel problem

moehlmann_fe — Fri, 10 Jun 2022 08:20:09 GMT

Seems like I misunderstood the problem. The issue is that some numbers (45, 78) are not present in the updated table. When no entries are found for those numbers, the tokens exit the loop, because the assumption was, that no entries for an order number would mean all orders are done.

To fix this, you can add another decide activity, that checks if the end of the picking table was actually reached or not (by comparing the current order no. on the token to the one in the last table row).

This has to be done for the 'Operator Picking' and the 'All Orders Processing' sections in the process flow.

reachtrucks-updated-excel_1.fsm

Re: Excel problem

maria_a31 — Fri, 10 Jun 2022 08:23:21 GMT

Okay i get the logic now, thank you again for your assistance!