Import and Overall Flow

When you need a complete model of the major entry points and boarding areas of a hospital. It would allow for policy experimentation or addition of types of patients show the effect to major boarding areas. It shows how to import the flow from historical patient information. It shows how to pull information from attributes to feed the flow and timing of the model. It shows how to check if the next destination has capacity to receive the patient and if not hold the patient in the current location. It shows how to do implement discharge windows for boarding locations (See Ward activity).

Import and Overall Flow


Where to Find the Model Object

The following model object will be used to create an import and overall flow to import data into ProcessModel:

  • Arrivals \ Import and Overall Flow.

Difficulty Level

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

How to Use the Model Object

  1. Open Your Model: Open your model or create a new blank model.
  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. Add or Change Locations:
    1. Add and/or change locations. Locations must start with an alpha character. Keep the names short. You should have short names in your database.

      If you do not wish to add or remove any default locations, skip to step 4.0.

    2. Create routes from the Director activity to any new activity. Duplicate the methods used in the existing red routes.creating new activities
    3. Create a route from each activity to the black box activity. Duplicate the methods used in the existing blue routes.creating route to the black box
    4. Review and update the action logic at the Director activity. The Director is setup to handle upto 15 locations, if your scenario has more than 15 locations, simply copy / paste the logic to add more locations.

      Actionlogic update on director
      Make sure that the appropriate attributes, a_Loc# and a_Time# are defined through the Define Attributes, Variables & Scenarios window.define avs for Import and Overall Flow

    5. Review the instructions in the action logic at activity ED and enhance the action logic on all activities to account for the new activities added.

      updating action logic on activities

    6. To remove a location activity, follow the instructions from step 3.1 onwards and delete routes, reduce / update action logic appropriately.
  4. Open the Excel File: Right click on the Scheduled ArrivalsInput Sheet Excel icon and click on the third option from the bottom to open the Scheduled ArrivalsInput vx-x Excel file, where x-x represents the version number of the Excel file.opening Scheduled ArrivalsInput in Import and Overall Flow
    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