When Will You Need This?

When you need to analyze your raw data and prepare it to represent the arrivals of an laboratory with priority levels. This can be used with other lab objects or to feed into a model created from scratch.

Lab Arrivals with Priority model image

Model Object

The following model object can be found in the model objects directory: Lab \ Lab Arrivals with Priority.

Ease of Use: Easy

Ease of Modification: Easy

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

1. Locate the model object Lab Arrivals with Priority and select the insert button.

2. 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.

3. Connect to Your Model

1. Connect the percentage route leaving the black box to the rest of your model.

connect to your model in Lab Arrivals with Priority

4. Open the Excel File

1. Right click on the Sample Arrivals Sheet Excel icon and click on the third option from the bottom to open the Sample Arrivals vx-x Excel file, where x-x represents the version number of the Excel file.

open excel file in Lab Arrivals with Priority

Click Enable Content if prompted

Enable Macro

5. Enter Raw Data

1. Paste your raw arrivals in column A, from row 3 onwards.

enter raw data in a in Lab Arrivals with Priority

Sample data must be removed prior to entry of your data.

You must provide at-least 24 weeks worth of data

2. Paste your raw acuity in column B, from row 3 onwards.

enter raw data in c in Lab Arrivals with Priority

3. Enter the highest priority in your data in cell C3

enter priority in c3 in Lab Arrivals with Priority

In ProcessModel, priorities with the highest number receive the highest priority. The attached Excel spreadsheet will transform you priority numbers so that they will work with the simulation. See the priority section of the attached spreadsheet for further details.

Have UK dates and time? Use the UK Dates Converter

6. Prepare Arrival Data for ProcessModel

 Follow instructions to install Histogram add-on before using the sheet

1. 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 Small Lab worksheet.

prepare arrivals in Lab Arrivals with Priority

7. Choose Small or Large Lab

After preparing your data for ProcessModel, choose one of the following two paths and then goto the relevant worksheet.

1. Small Lab: When there is nominal difference in the daily pattern between day to day arrivals in the data. Daily volumes will be different.

2. Large Lab: When there is major difference of patterns between days of the week (i.e. Sundays have a daily pattern different from Mondays).

select small or large lab in Lab Arrivals with Priority

8. Copy Data to ProcessModel

The rest of the instructions will be the same for Small or Large Lab.

1. Copy the data in column B from B5 onwards by pressing the Copy Arrivals button.

Copy Arrivals Data

2.  Goto ProcessModel and open Stat::Fit via Tools \ Stat::Fit.

3. Paste the data into Stat::Fit.

Paste in Stat-Fit

4. Fit the data into a distribution by clicking Auto-fit in the toolbar and then OK.

auto-fit data in stat-fit

5. Review the acceptable distributions and then click Export from the toolbar.

export distribution from stat-fit

6. Select the acceptable distribution from the Fitted Distribution and then click OK.

choose distribution for export

7. Return to ProcessModel, click on the arrival route and then paste (CTRL + V) the distribution in the Quantity per arrival field in the Properties Dialog.

Make sure you remove the old distribution before pasting the new one in.

add arrivals to Lab Arrivals with Priority

8. Return to the Excel file and click Copy Action Logic.

copy action logic from excel

9. Return to ProcessModel, click on the black box and then open the Action Logic window via the Properties Dialog. Remove the old action logic and paste (CTRL + V) in the new action logic.

add action logic to Lab Arrivals with Priority

9. Completion

The model object is now integrated into your model, you should now be able to save and then simulate the model.

Attributes, Variables, Scenario Parameters and Scenarios Usage

Attributes:

1. a_Priority: Do not change. The priority level assigned to samples from historical information, This can range from 1 to 9. You indicate what number represents the most urgent priority in your system.

Advance Topics

How do I choose between Small or Large Lab?

You can choose between Small or Large Lab by looking at the data and charts after you have prepared the data (step 6) for ProcessModel.

If there is nominal difference in the daily pattern between day to day arrivals, then use can use Small Lab.

nominal-diffrence-is-values-for-weekly-pattern-newThe difference between values is 1% or less

If there is a major difference in the daily pattern between day to day arrivals, then use can use Large Lab.

major-diffrence-is-values-for-weekly-patternThe difference between values is over 7% on some days