Disaster Arrivals Weekly

To create arrivals according to a pattern when given only weekly summary information.

Disaster Arrivals Weekly

What you have, and what you need

When you are given actual quantities per week:



Disaster Arrivals Weekly

AND you need the arrivals spread across the days of the week and the hours of the day 


Disaster Arrivals Weekly 2

This model object takes actual weekly arrivals summaries for past events and creates patterns of arrivals by day of week and hour of day. The object allows Arrivals to be processed for several divisions, center or departments in the same stream of arrivals separated by an attribute. Entity names and graphics are changed by using an attribute.

The user has control of how arrivals are distributed across the week by a simple spreadsheet interface. The user can define what pattern is used to spread entities across the hours of the day. These are predefined patterns AND can be changed by the user. A simple multiplying factor allows the user to copy data from past disasters and modify the amplitude to prepare for larger or smaller events.

This model object can be used multiple times in the same model by saving the Excel file as a new name, and then linking a separate object to that new file. This means different disasters can have completely different patterns of arrivals.

Where to Find the Model Object

The Model Object is available at the following location within Model Objects:

  • Arrivals \ Disaster Arrivals Weekly.

Difficulty Level

  • Ease of Use: Moderate
  • Ease of Modification: Moderate

How to Use the Model Object

  1. Open Your Model
  2. Insert the Model Object in Your Model: Locate the appropriate location where you would like to place the model object, move the view to the location and then insert the model object.
  3. Use the Black Box as the Arrival: This means, when entities leave the black box, it is as if they are entering the model for the first time. Connect from the Black Box to the remainder of your model. The entity can be changed to any entity you choose. When changing the entity, don’t delete the arrival.black box connection
  4. Right click the Excel icon and click the third option from the bottom to open the Excel file

    Disaster Arrivals Weekly Open ExcelClick Enable Content if prompted

    Enable Macro

  5. Enter the Day of Week Percents: Enter the Day of Week percents. Arrivals may occur on one to seven days per week. The sum of all daily percentages must equal 100.Disaster-Arrivals-Weekly-Add-Day-Percent
  6. Enter the Start Time: This will be the time each day when arrivals begin entering the model.enter start time in disaster arrivals weekly
  7. Enter the Entity Name: Add the name of the entity connected to the target scheduled arrival. Make sure that the entity has a Scheduled arrival type and you have added at least one scheduled arrival.
  8. Select the Hour of Day: The logic created from this section distributes the entities over the hours of the day. The hour of day provides you with 4 options;
    1. More in The Morning: This option will make sure that most of the entities arrive in the morning time with some during the later parts of the day.
    2. More in The Afternoon:This option will make sure that most of the entities arrive during the afternoon time with some during the morning.
    3. Specific Mail Drops: If you would like to provide certain times with percentages of entities to drop at those times select this option. Selecting this option will enable the Time/Percent column, enter the times and percentages as required. Make sure that the percentage equals 100.