Match time from excel with pallet arrival on station

_3gsimulator
Not applicable
1 View
1 Reply
Message 1 of 2

Match time from excel with pallet arrival on station

_3gsimulator
Not applicable

[ FlexSim 22.1.4 ]

Hello, I have model of assembly line with 4 stations. There are 6 arriving stations. At the begging, operator put chassis on pallet.


From excel I imported data with arrival time. This is historical time from our real assembly line (GlobalTable1). every workstation has a time, when operator pressed the button to send the pallet to the next position.

test.fsm

1686709601192.png

I already put the arrival time from workstation 1 to the source of chassis. But I would like to send the pallet from each workstation at the time of departure from the GlobalTable1. I guess it should be something with pull from list?

Do you have idea, how can I do it? Thank you

0 Likes
Accepted solutions (1)
2 Views
1 Reply
Reply (1)
Message 2 of 2

moehlmann_fe
New Member
New Member
Accepted solution

The stations could look at the next departure on the table whenever the processing time is determined and set it so that the item will leave at the specified time.

For this to be possible you of course first have to set the model start time to be ahead of the first times in the table.

I would add another column to the table that contains the times converted to a model. That saves having to do this every time the model starts. The stations can then get an array of their times via SQL in their reset trigger.

test_fm.fsm

Be aware that your test model does not currently allow for this to work, because there are too few carriers and too little space between the stations. As you can see in the table below, by the time the first carrier leaves the second station, the first should already have released four more. But there isn't enough space on the conveyor for them.

1686725914174.png

0 Likes