question

Rober G avatar image
0 Likes"
Rober G asked Jason Lightfoot answered

Arrival Scheduling Excel

Hi, I hope you are well!


What arrival approach should I use in my source for the following snapshot of an excel sheet:

1690735421390.png

I wish to replicate the times statistically in flexsim. The factory imports 5 different raw materials and I have the sheets of delivery times of the 5 materials for each day of the month.

I have tried arrival sequence, times of day etc... but can't seem to replicate it correctly to be similar for a month of arrivals.


Any help is appreciated, thank you!

FlexSim 22.2.4
arrival times
1690735421390.png (21.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

Jason Lightfoot avatar image
2 Likes"
Jason Lightfoot answered

Not sure what you mean by "replicate the times statistically" - you can fit them to an interarrival time distribution or Poisson arrvivals by hour.

If you're just trying to import the data into FlexSim then you can transform the data to FlexSim time units (usually seconds).

1690801950071.png

In the example the start is just A5+B5 and then the time for row 5 is (B5+A5-$B$2)*86400


1690801950071.png (9.2 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.