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