Create Weekly Pattern Arrivals

When you need to convert historical arrival data into a statistical representation of the arrivals. This especially useful for an inbound call center or a service center when the volume is greater than 100 per day, general patterns repeat weekly and more than 26 weeks of data has been collected.

Create weekly pattern arrivals

Where to Find the Model Object

The following model object will be used to create weekly pattern arrivals and import them into ProcessModel:

  • Arrivals \ Create Weekly Pattern Arrivals

Difficulty Level

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

How to Use the Model Object

  1. Open Your Model: The model should have at-least one entity.
  2. Insert the Model Object into Your Model: Locate the appropriate location in your model where you would like to place the model object, move the view to the location and then insert the model object.
  3. Create Connections:
    1. Connect the arrival route that ends on the black box to an entity in your model.

      connect arrival route to entity

    2. Create a route from the black box to the rest of your model.

      route form black box to rest of the model

  4. Open the Excel File: Right click on the Weekly Pattern Arrivals Sheet Excel icon and click on the third option from the bottom to open the Weekly Pattern Arrivals vx-x Excel file, where x-x represents the version number of the Excel file.Open Weekly Pattern Arrivals sheet
    Before using this Excel file for the first time, or after changing your model name, make sure that a manual export of data is done via ProcessModel. From your model, click Tools \ Export Data, click ‘Yes’ to all prompts until the data export file opens, close the data file and then use this Excel file.

    Click Enable Content if prompted

    Enable Macro

  5.  Enter Raw Data: Once the Weekly Pattern Arrivals vx-x Excel file opens you should land on the Input worksheet.

    Copy your date and time data and paste into cell A3. You need at least 6 months of data. Use the Excel date and time forma