Diary Cards - Average Duty/Work Calculation

The basic calculation is very simple. Add up all the recorded duty and work hours and divide by the length of the study in weeks times the number of doctors involved.

 

Riddell Formula

If the Riddell formula is specified for use with this work group, addition hours will be added to these calculated averages. The figures to use are derived from the theoretical pattern and represent a correction for leave taken in the monitoring period.

Any days in the monitoring period recorded as leave days will each contribute to the total work and duty hours one fifth of the hours defined as the "leave week" on the Prospective Cover input screen.

 

Duty Hours for EWTD

This will often be the same as the duty hours used for New Deal analysis, but there could be differences:

·      No Riddell formula adjustments are added

·      Non resident rest is excluded

 

Leave and Average Hours Calculations

The calculation of average hours can be made complicated by missing diary cards or doctors not at work due to illness or leave.

Average hours of duty and work will only be calculated if DRS has an entry for every possible diary card in the study. This is because large errors can occur if the system attempts to guess the duty for just a single missing diary card. The user should ensure that a reasonable estimate is entered for every doctor and every day in the study period even if no card was completed by the doctor.

There are options to fill in any missing cards as rest days or to use the theoretical pattern to fill in the hours that should have been worked. These are convenient but should be used with care.

Where leave/sick days are recorded, the average hours figures could be inaccurate. These days may mask time worked by a locum which should be included in the averages. The best approach is to never enter days as leave/sick, but substitute the normal hours that would have been worked or a rest day as appropriate.

 

If leave/sick days are recorded, DRS will take the following actions (NB different action is taken if the Riddell formula is in use – see not above):

 

·      If a full week of leave is recorded (5 weekdays), that week will be completely ignored in the calculations (so a two week study for a doctor with 5 leave days will be reduced to a one week study)

·      For isolated days of leave (less than whole weeks), each leave day will be replaced by a normal 8 hour working day with no rest.

 

The following example illustrates this. All three doctors recorded exactly the same amount of work, but the recording of days with no duties varied.

 

·      Dr. Leave has a full week of leave (which is ignored) and one isolated day of leave. He does 114 hours of work in the second week, to which 8 hours is added in place of the isolated leave day on the Friday. This results in a weekly average of 122 hours of duty.

·      Dr. Restdays has no leave days, so the average hours is simply a matter of adding up the duties (114 hours) and dividing by 2. This results in a weekly average of 57 hours of duty.

·      Dr. Mixed has a full week of leave (which is ignored) and a rest day in the second week. He does 114 hours of work in the second week. This results in a weekly average of 114 hours of duty

 

The average duty hours for the group is based on these individual figures. With no leave, we would be averaging over 6 weeks (3 doctors and 2 weeks each), but 2 weeks have been ignored as leave weeks, so we are averaging over 4 weeks. The total hours will include normal days substituted for isolated leave days.

 

In this case it is (122+114+114)/4 = 87:30

 

 

Doctor

%Cards

Duty Hrs

Work Hrs

Dr. Leave  

100 

122:00 

70:30 

Dr. Restdays  

100

57:00

31:15

Dr. Mixed  

100

114:00

62:30

 

 

Diary Cards for Dr. Leave

 

Date

Day

Type

Start

End

Cont Duty

Rest

Nat Brks

Long Rest

OOH Rest

Work 7pm-7am

Gap After

Cont Days

EWTD Rest 24hrs

13/01/2003

Mon

Leave

 

 

 

 

 

 

 

 

 

 

 

14/01/2003

Tue

Leave

 

 

 

 

 

 

 

 

 

 

 

15/01/2003

Wed

Leave

 

 

 

 

 

 

 

 

 

 

 

16/01/2003

Thu

Leave

 

 

 

 

 

 

 

 

 

 

 

17/01/2003

Fri

Leave

 

 

 

 

 

 

 

 

 

 

 

18/01/2003

Sat

No Work

 

 

 

 

 

 

 

 

 

 

 

19/01/2003

Sun

No Work

 

 

 

 

 

 

 

 

 

 

 

20/01/2003

Mon

On Call

08:00

08:00

24:00

11:30

OK

09:00

10:00

02:00

 

1

00:00

21/01/2003

Tue

After OC

08:00

17:00

33:00

00:30

OK

 

 

 

15:00

2

15:00

22/01/2003

Wed

On Call

08:00

08:00

24:00

11:00

OK

09:00

10:00

02:00

 

3

00:00

23/01/2003

Thu

After OC

08:00

17:00

33:00

01:30

OK

 

 

 

 

4

15:00

24/01/2003

Fri

Leave

 

 

 

 

 

 

 

 

 

 

 

25/01/2003

Sat

On Call

08:00

08:00

24:00

13:00

OK

09:00

13:00

02:00

 

1

00:00

26/01/2003

Sun

On Call

08:00

08:00

48:00

14:00

OK

08:00

14:00

02:00

 

2

00:00

 

.

.

 

 

Diary Cards for Dr. Restdays

 

Date

Day

Type

Start

End

Cont Duty

Rest

Nat Brks

Long Rest

OOH Rest

Work 7pm-7am

Gap After

Cont Days

EWTD Rest 24hrs

13/01/2003

Mon

No Work

 

 

 

 

 

 

 

 

 

 

 

14/01/2003

Tue

No Work

 

 

 

 

 

 

 

 

 

 

 

15/01/2003

Wed

No Work

 

 

 

 

 

 

 

 

 

 

 

16/01/2003

Thu

No Work

 

 

 

 

 

 

 

 

 

 

 

17/01/2003

Fri

No Work

 

 

 

 

 

 

 

 

 

 

 

18/01/2003

Sat

No Work

 

 

 

 

 

 

 

 

 

 

 

19/01/2003

Sun

No Work

 

 

 

 

 

 

 

 

 

 

 

20/01/2003

Mon

On Call

08:00

08:00

24:00

11:30

OK

09:00

10:00

02:00

 

1

00:00

21/01/2003

Tue

After OC

08:00

17:00

33:00

00:30

OK

 

 

 

15:00

2

15:00

22/01/2003

Wed

On Call

08:00

08:00

24:00

11:00

OK

09:00

10:00

02:00

 

3

00:00

23/01/2003

Thu

After OC

08:00

17:00

33:00

01:30

OK

 

 

 

 

4

15:00

24/01/2003

Fri

No Work

 

 

 

 

 

 

 

 

 

 

 

25/01/2003

Sat

On Call

08:00

08:00

24:00

13:00

OK

09:00

13:00

02:00

 

1

00:00

26/01/2003

Sun

On Call

08:00

08:00

48:00

14:00

OK

08:00

14:00

02:00

 

2

00:00

 

.

.

 

 

Diary Cards for Dr. Mixed

 

Date

Day

Type

Start

End

Cont Duty

Rest

Nat Brks

Long Rest

OOH Rest

Work 7pm-7am

Gap After

Cont Days

EWTD Rest 24hrs

13/01/2003

Mon

Leave

 

 

 

 

 

 

 

 

 

 

 

14/01/2003

Tue

Leave

 

 

 

 

 

 

 

 

 

 

 

15/01/2003

Wed

Leave

 

 

 

 

 

 

 

 

 

 

 

16/01/2003

Thu

Leave

 

 

 

 

 

 

 

 

 

 

 

17/01/2003

Fri

Leave

 

 

 

 

 

 

 

 

 

 

 

18/01/2003

Sat

No Work

 

 

 

 

 

 

 

 

 

 

 

19/01/2003

Sun

No Work

 

 

 

 

 

 

 

 

 

 

 

20/01/2003

Mon

On Call

08:00

08:00

24:00

11:30

OK

09:00

10:00

02:00

 

1

00:00

21/01/2003

Tue

After OC

08:00

17:00

33:00

00:30

OK

 

 

 

15:00

2

15:00

22/01/2003

Wed

On Call

08:00

08:00

24:00

11:00

OK

09:00

10:00

02:00

 

3

00:00

23/01/2003

Thu

After OC

08:00

17:00

33:00

01:30

OK

 

 

 

 

4

15:00

24/01/2003

Fri

No Work

 

 

 

 

 

 

 

 

 

 

 

25/01/2003

Sat

On Call

08:00

08:00

24:00

13:00

OK

09:00

13:00

02:00

 

1

00:00

26/01/2003

Sun

On Call

08:00

08:00

48:00

14:00

OK

08:00

14:00

02:00

 

2

00:00

More:

Diary Cards - Group Analysis