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!
Arrival pattern
Re: Arrival pattern
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
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
-
- Posts: 2
- Joined: Wednesday 19 June, 2013 - 16:23
Re: Arrival pattern
Thanks a lot!
Works like a charm!
Is it possible to link the data in Arrival List to an input Excel?
Many thanks !
Works like a charm!
Is it possible to link the data in Arrival List to an input Excel?
Many thanks !
Re: Arrival pattern
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:
Where refPassengers could be the name of your table.
Regards, Marlies
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))
Regards, Marlies