Patient Arrivals

Learn everything you need to know about modeling patient arrivals in a simulation model. In this first episode in the FlexSim Healthcare Instructional Video Series, we’ll demonstrate in great detail the process of data mining in Excel to extract patient categories, volumes and arrival patterns, then import the data into a simulation model that effectively uses the data to simulate realistic patient arrivals in a healthcare setting.

00:15 Patient Arrival Basics
01:43 The Date/Time Source
17:34 Simple Model Using Date/Time Source
24:22 Assigning Patient Labels With Arrivals
26:26 Redefining Model Start Time
30:23 Data Mining Actual Patient Data in Excel
34:52 Creating Excel Pivot Tables
55:38 Importing Excel Tables into Model
1:01:57 Assigning Patient Labels
1:06:21 Bonus Material (Excel Functions)

Excel Workbook Download Link:
cloud.flexsim.com/index.php/s/wyZCnr9xOUIKcMG