An External Arrivals file is a spreadsheet (.xsl or .xlsx format only) file containing arrival information normally specified in a Periodic arrival connection. One or more arrival files may be referenced in the External Files table. External Arrival files are automatically read in at the start of the simulation following the scheduling of all other arrivals defined in arrival connections in the model. The column entries must be as follows:
Columns | Data |
A | Entity Name |
B | Activity Name |
C | Quantity per Arrival |
D | Start time of first Arrival |
E | Number of Occurrences |
F | Interval between Arrivals |
G through... | Attribute assignments |
The first row in the spreadsheet must be used as a header row. Columns A through F may have any heading desired as long as the data in the respective columns is of the proper type. Attributes can also be initialized with specific values for each arrival defined on a separate row. This is accomplished by assigning columns G and higher headings that match the names of the attributes being assigned. The values of the attributes you want assigned should be entered in the row and column of the respective arrival and attribute.
The arrival of the Work entity at activity Op_10 will occur for the first time eight hours after the start of the simulation. Each arrival brings 1 new entity. The arrival will be repeated 30 times (unless the simulation run length is too short) with an interval of 7 days. The attribute Att1 is initialized with a value of 20, whereas Att2 will be assigned an initial value from the distribution N(5, 2).
Please note: If no time unit (sec, min, hr, day, wk) is specified with a time value for Start Time or Interval in the External Arrival, the time value will be evaluated as minutes.
When defining an External Arrivals file, you do not need to define an arrival connection in the model. If several entities are scheduled to arrive at the same time, entities arrive in the system according to the order in which they appear listed in the spreadsheet. However, when there is more than one occurrence defined for a given arrival, the next entity will not arrive until the interval has elapsed. Meanwhile, other entities listed below the row may be allowed to arrive.
Please note: If the .xls or .xlsx file contain more than one sheet of data, only the first sheet will be read in.
© 2014 ProModel Corporation • 556 East Technology Avenue • Orem, UT 84097 • Support: 888-776-6633 • www.promodel.com