I am working with a table containing data for each:
Date of appointment
Time of appointment
Clinic name
Doctor name
Appointment Status (such as arrived, canceled, noshow)
Appointment Type (such as return, urgent care, emergency)
Duration (based on appointment type - could be 20 minutes, 30, 40, 60, 120)
1st objective:
In each record, determine the day of week based on the date. First cell would contain 07/15/2004 so the second cell would show Thursday.
2nd objective:
In each record, determine the session of each appointment. A session is defined as AM or PM. AM sessions are scheduled 11:59am or earlier. PM sessions are scheduled at noon or after. First cell would contain 11:59 a.m. so the second cell would show AM.
3rd objective:
Now for the hard part. Each provider has defined the lentgh of each available session that he/she will see patients. This session is defined in minutes (10, 30, 45, 60, 120, 240, etc.). There can be a total of 10 sessions (Monday AM, Monday PM, Tuesday AM, Tuesday PM, Wednesday AM, etc.......) I names each session as SA, SB, SC, SD, SE, SF, SG, SH, SI, SJ.
Lets say that Doctor Smith states he will see patients for a total of 210 minutes each Wednesday PM. So, under field SF, I put 210.
Jumping over to my report, I want to put the following in the provider footer:
(detail is hidden)
1.) Provider name
2.) Total arrived patients (based on ARR in the appointment status field). Calculated with the following formula: =Sum(IIf([AS]="ARR",1,0))
3.) Session efficiency for each session - If Smith saw 3 patients on Wednesday afternoon and the total arrived duration was 180 minutes... I would take the total arrived duration =Sum(IIf([AS]="ARR",[DUR],0)) and divide it by the planned session length of 210 minutes to show that Smith only scheduled 85% of his available session time. I will show the efficiency for each 10 sessions next to the providers name.
Clear as mud?
Date of appointment
Time of appointment
Clinic name
Doctor name
Appointment Status (such as arrived, canceled, noshow)
Appointment Type (such as return, urgent care, emergency)
Duration (based on appointment type - could be 20 minutes, 30, 40, 60, 120)
1st objective:
In each record, determine the day of week based on the date. First cell would contain 07/15/2004 so the second cell would show Thursday.
2nd objective:
In each record, determine the session of each appointment. A session is defined as AM or PM. AM sessions are scheduled 11:59am or earlier. PM sessions are scheduled at noon or after. First cell would contain 11:59 a.m. so the second cell would show AM.
3rd objective:
Now for the hard part. Each provider has defined the lentgh of each available session that he/she will see patients. This session is defined in minutes (10, 30, 45, 60, 120, 240, etc.). There can be a total of 10 sessions (Monday AM, Monday PM, Tuesday AM, Tuesday PM, Wednesday AM, etc.......) I names each session as SA, SB, SC, SD, SE, SF, SG, SH, SI, SJ.
Lets say that Doctor Smith states he will see patients for a total of 210 minutes each Wednesday PM. So, under field SF, I put 210.
Jumping over to my report, I want to put the following in the provider footer:
(detail is hidden)
1.) Provider name
2.) Total arrived patients (based on ARR in the appointment status field). Calculated with the following formula: =Sum(IIf([AS]="ARR",1,0))
3.) Session efficiency for each session - If Smith saw 3 patients on Wednesday afternoon and the total arrived duration was 180 minutes... I would take the total arrived duration =Sum(IIf([AS]="ARR",[DUR],0)) and divide it by the planned session length of 210 minutes to show that Smith only scheduled 85% of his available session time. I will show the efficiency for each 10 sessions next to the providers name.
Clear as mud?
Last edited:
