Page 1 of 1
Arrival pattern
Posted: Wednesday 19 June, 2013 - 16:30
by Belpheghor
Hello,
I quite new to simulation and I need I have data on an arrival pattern that looks like this:
Time range Amount of arrivals
8:00-8:59 90
9:00-9:59 106
ect...
I need to spread randomly the arrivals during each time range.
How do I do this?
Thanks in advance for your help!
Re: Arrival pattern
Posted: Thursday 20 June, 2013 - 08:57
by marlies
Hi,
You can model such an arrival pattern using the atom Arrivallist (you'll find it in the category Time).
Afterwards you could use a multiservice atom with a high capacity and a cycletime of uniform(0, hr(1)) to spread the arrivals of the products random over the hour.
Regards, Marlies
Re: Arrival pattern
Posted: Thursday 20 June, 2013 - 15:00
by Belpheghor
Thanks a lot!
Works like a charm!
Is it possible to link the data in Arrival List to an input Excel?
Many thanks !
Re: Arrival pattern
Posted: Thursday 20 June, 2013 - 16:35
by marlies
Hi,
It's not possible to link the arrivallist directly to Excel, but it could be done like this:
- Use the ExcelActiveX atom to link to Excel and add a table for the arrivalpattern.
- Assume you have an arrival pattern per hour: give the arrivallist atom a repeat time (first tab) of 1 hour.
- Then give the arrivallist just 1 arrival. The quantity of this arrival reads the number from the table in your excel active x atom.
- The code in the quantity field could look like this:
Code: Select all
Do(label([row], c) := label([row], c) + 1, cell(label([row], c), 2, refPassengers))
Where refPassengers could be the name of your table.
Regards, Marlies