I am trying to model the arrival of patients, but I am struggling with choosing the right arrival pattern for model. I have experimented with the inter-arrival, appointments, and custom arrivals patterns, but have faced limitations with each.

Please see attached sample arrival data.

I would like to model the arrival of patients that arrive according to appointment times with the following characteristics:

- There are different types of patients based on the service they receive. (Column A)
- The number of patients that arrive per service is a variable number with the average a and it is between b and c. (Columns B-D)
- There are empty appointment slots per day for each patient type. (See Column E)
- The operating hours are different per patient type. (Column F-G)
- Schedule frequencies are different per patient type. (Column J)

Please see attached sample arrival data.

I would like to create a model with the requirements below:

- Create a random number of time slots to be filled per day between start time and end time for a patient type with a set frequency
- Assign the generated number of time slots per day into appointment slots randomly. For example, if there are 10 appointments to be filled in a day where 15 slots are available, would not want the 10 appointments to be the first 10. I would like to randomly assign them.
- Would like to add a distribution for the variability of the arrivals. For example, would like to see patients coming in between 5 minutes late or 10 minutes early to an appointment.

Thank you