To analyze your raw data and prepare it to represent the arrivals of an Emergency Department with patient acuity levels. This can be used with the Triage model object or to feed into a model created from scratch.
Where to Find the Model Object
The following model object can be found in the model objects directory:
- ED \ ED1B Arrivals with Acuity Advanced.
This model object is a part of a 8 model object Emergency Department series that can be accessed under the category ED.
- ED1B Arrivals with Acuity Advanced
- ED2 Triage
- ED3_a Treatment with Fast Track
- ED3_b Treatment with Fast Track Using Common Lab
- ED4_a Patient Discharge
- ED5_a Room Cleaning
- ED6_a Patient Admit
- ED7_a Resource Optimizer
- Ease of Use: Easy
- Ease of Modification: Easy
How to Use the Model Object
- Open Your Model: Open your model or create a new blank model.
- Insert the Model Object into Your Model
- Locate the model object ED1 Arrivals with Acuity and select the insert button.
- Move the cursor to the point of insertion and left mouse-click. The upper left corner of the model object will be inserted at the location of the mouse-click.
- Connect to Your Model: Create a percentage route from the black box to the rest of your model. If you are combining the ED models, connect the black box to ED Critical? from ED2 Triage model object.This Model Object is best when used with other ED model objects Scenario Parameters
- Open the Excel File: Right click on the Healthcare Arrivals Sheet Excel icon and click on the third option from the bottom to open the Healthcare Arrivals vx-x Excel file, where x-x represents the version number of the Excel file.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
- 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 format, sample data is included.Sample data must be removed prior to entry of your data.You must provide at-least 24 weeks worth of data
- Copy your acuity data and paste into cell B3.If some data points (date and time) have acuity levels missing, you can leave the corresponding cells as blank.
- Enter the highest level of acuity in your model to cell C3. Example; If you have acuity levels from 1 to 5 and the highest acuity is 1, enter 1. If the highest acuity level is 5 then enter 5.Enter the number that is considered the highest acuity level in your system. You must provide a value between 1 to 9, based on what the highest acuity is in your data.In ProcessModel, priorities with the highest number receive the highest priority. The Excel spreadsheet will transform your acuity numbers so that they will work with the simulation.
- In cell D3 and D4, enter the time at which you need to change the acuity, the time has to be in 24 hours format with lowest time in the first cell and the highest time in the second cell.
- Prepare Arrival Data for ProcessModel: Click the button titled Prepare Arrival Data for ProcessModel and allow 1 minute for the analysis (depends on the speed of your processor and the size of the file). Once completed you will land on the Same Pattern for All Days worksheet.Follow instructions to install Histogram add-on before using the sheet
- Choose Same or Unique Pattern for Days: After preparing your data for ProcessModel, choose one of the following two paths and then goto the relevant worksheet.
- Same Pattern for All Days: When there is nominal difference in the daily pattern between day to day arrivals in the data. Daily volumes will be different.
- Unique Pattern by Day of Week: When there is major difference of patterns between days of the week (i.e. Sundays have a daily pattern different from Mondays).
- Copy Data to ProcessModel: The rest of the instructions will be the same for Same Pattern for All Days or Unique Pattern by Day of Week.
- Copy the data in column B from B5 onwards by pressing the Copy Arrivals button.
- Goto ProcessModel and open Stat::Fit via Tools \ Stat::Fit.
- Paste the data into Stat::Fit.
- Fit the data into a distribution by clicking Auto-fit in the toolbar and then OK.
- Review the acceptable distributions and then click Export from the toolbar.
- Select the acceptable distribution from the Fitted Distribution and then click OK.