Sheet 1: 1 - Template

	
	

		
Rota design template
		


		


		


		


		


		


		


		


		


		


		


		


		


		


		


	
	

		


		


		


		


		


		


		


		


		


		


		


		


		


		


		


		


	
	

		
Use this template as you design your rota.
		


		


		


		


		


		


		


		


		


		


		


		


		


		


		


	
	

		
If your employer requires doctors to cover annual leave, you should use the Riddell Formula Calculator on Sheet 2 to calculate total hours.
		


		


		


		


		


		


		


		


		


		


		


		


		


		


		


	
	

		


		


		


		


		


		


		


		


		


		


		


		


		


		


		


		


	
	

		
Resident On-Call: Remember that under Working Time Regulations, all time spent on duty at work counts as work.
		


		


		


		


		


		


		


		


		


		


		


		


		


		


		


	
	

		
Non-resident on call: Only time spent acutally working counts as work for the purpose of WTR
		


		


		


		


		


		


		


		


		


		


		


		


		


		


		


	
	

		


		


		


		


		


		


		


		


		


		


		


		


		


		


		


		


	
	

		
Doctor
		
Monday
		
Tuesday
		
Wednesday
		
Thursday
		
Friday
		
Saturday
		
Sunday
		
Totals
	
	

		


		
AM
		
PM
		
AM
		
PM
		
AM
		
PM
		
AM
		
PM
		
AM
		
PM
		
AM
		
PM
		
AM
		
PM
		


	
	

		
1
		


		


		


		


		


		


		


		


		


		


		


		


		


		


		
 -   
	
	

		
2
		


		


		


		


		


		


		


		


		


		


		


		


		


		


		
 -   
	
	

		
3
		


		


		


		


		


		


		


		


		


		


		


		


		


		


		
 -   
	
	

		
4
		


		


		


		


		


		


		


		


		


		


		


		


		


		


		
 -   
	
	

		
5
		


		


		


		


		


		


		


		


		


		


		


		


		


		


		
 -   
	
	

		
6
		


		


		


		


		


		


		


		


		


		


		


		


		


		


		
 -   
	
	

		
7
		


		


		


		


		


		


		


		


		


		


		


		


		


		


		
 -   
	
	

		
8
		


		


		


		


		


		


		


		


		


		


		


		


		


		


		
 -   
	
	

		
9
		


		


		


		


		


		


		


		


		


		


		


		


		


		


		
 -   
	
	

		
10
		


		


		


		


		


		


		


		


		


		


		


		


		


		


		
 -   
	
	

		
11
		


		


		


		


		


		


		


		


		


		


		


		


		


		


		
 -   
	
	

		
12
		


		


		


		


		


		


		


		


		


		


		


		


		


		


		
 -   
	
	

		
13
		


		


		


		


		


		


		


		


		


		


		


		


		


		


		
 -   
	
	

		
14
		


		


		


		


		


		


		


		


		


		


		


		


		


		


		
 -   
	
	

		
15
		


		


		


		


		


		


		


		


		


		


		


		


		


		


		
 -   
	
	

		
16
		


		


		


		


		


		


		


		


		


		


		


		


		


		


		
 -   
	
	

		
17
		


		


		


		


		


		


		


		


		


		


		


		


		


		


		
 -   
	
	

		
18
		


		


		


		


		


		


		


		


		


		


		


		


		


		


		
 -   
	
	

		
19
		


		


		


		


		


		


		


		


		


		


		


		


		


		


		
 -   
	
	

		
20
		


		


		


		


		


		


		


		


		


		


		


		


		


		


		
 -   
	
	

		
21
		


		


		


		


		


		


		


		


		


		


		


		


		


		


		
 -   
	
	

		
22
		


		


		


		


		


		


		


		


		


		


		


		


		


		


		
 -   
	
	

		
23
		


		


		


		


		


		


		


		


		


		


		


		


		


		


		
 -   
	
	

		
24
		


		


		


		


		


		


		


		


		


		


		


		


		


		


		
 -   
	
	

		
25
		


		


		


		


		


		


		


		


		


		


		


		


		


		


		
 -   
	
	

		
26
		


		


		


		


		


		


		


		


		


		


		


		


		


		


		
 -   
	
	

		
27
		


		


		


		


		


		


		


		


		


		


		


		


		


		


		
 -   
	
	

		
28
		


		


		


		


		


		


		


		


		


		


		


		


		


		


		
 -   
	
	

		
29
		


		


		


		


		


		


		


		


		


		


		


		


		


		


		
 -   
	
	

		
30
		


		


		


		


		


		


		


		


		


		


		


		


		


		


		
 -   
	
	

		
Total
		


		


		


		


		


		


		


		


		


		


		


		


		


		


		
 -   
	



Sheet 2: 2 - Riddell Formula Calculator

	
	
	
	
	

		
Riddell Formula© Calculator
		


		


		


		


		


		


		


		


		


		


		


		


		


	
	

		


		


		


		


		


		


		


		


		


		


		


		


		


		


	
	

		
The Riddell Formula© is used to determine hours of work
		


		


		


		


		


		


		


		


		


		


		


		


		


	
	

		


		


		


		


		


		


		


		


		


		


		


		


		


		


	
	

		
If your employer does not use locums to cover annual leave on your rota then you are working with 'prospective cover' and must calculate the additional hours worked by colleagues covering each other's leave. This is done with the Riddell Formula.
		


		


		


	
	

		


		


		


	
	

		


		


		


	
	

		


		


		


		


		


		


		


		


		


		


		


		


		


		


	
	

		


		


		


		


	
	

		


		


		


	
	

		


		


		


		


		


		


		


		


		


		


		


		


		


		


	
	

		


		


		


		


		


		


		


		


		


		


		


		


		


		


	
	

		


		
The Riddell Formula ©
		


		


		


		


		
Junior Doctors' Leave Entitlements 
		


		


		


	
	

		


		


		


		


		


		


		


		


		


		


		


		


		


		


	
	

		
Average hours per week   = 
		


		


		
     D - ( E X C )
		


		


		


		


		


		


		


		


		


		


	
	

		


		


		


		
B - E
		


		


		


		


		


		


		


		


		


		


	
	

		
A = total leave entitlement for the year (in weeks)
		


		
Foundation Year Doctors
5 weeks
		


		


		


	
	

		
B = number of weeks in the rota cycle (often equal to the number of doctors)
		


		
StRs and SpRs on pay points 0, 1 or 2
5 weeks
		


		


		


	
	

		
C = number of hours in a leave week where cover is not provided by colleagues
		


		
StRs and SpRs on pay points 3 or higher
6 weeks
		


		


		


	
	

		
D = total hours worked in the rota cycle if no leave is taken
		


		
All junior doctors are also entitled to eight public holidays and two statutory holidays a year, or days in lieu.
		


		


		


	
	

		
E = ( A/52 X B ) 
		


		


		


		


	
	

		
©Copyright 2003 Gareth Riddell, Graeeme Eunson and Chis McCullough
		


		


		


		


		


		


		


		


		


	
	

		


		


		


		


		


		


		


		


		


	
	

		


		


		


		


		


		


		


		


		


		


		


		


		


		


	
	

		


		


		


		


		


		


		


		


		


		


		


		


		


		


	
	

		
CALCULATOR 1
		


		


		


		


		


		


		


		


		
CALCULATOR 2
		


		


		


		


	
	

		


		


		


		


		


		


		


		


		


		


		


		


		


		


	
	

		
To calculate using the template on Sheet 1
		


		


		


		


		
To fill in all figures yourself
		
	

		


		


		


		


		


		


		


		


		


		


		


		


		


		


	
	

		
A
		


		
Enter total leave
		


		


		


		


		


		


		
A
		


		


		


		


	
	

		
B
		
 -   
		


		


		


		


		


		


		


		
B
		


		


		


		


	
	

		
C
		


		
Enter hours in a leave week
		


		


		


		


		


		


		
C
		


		


		


		


	
	

		
D
		
 -   
		


		


		


		


		


		


		


		
D
		


		


		


		


	
	

		
E
		
 -   
		


		


		


		


		


		


		


		
E
		
 -   
		


		


		


	
	

		


		


		


		


		


		


		


		


		


		


		


		


		


		


	
	

		


		
#DIV/0!
		
Average hours per week
		


		


		


		


		


		


		


		
#DIV/0!
		
Average hours per week
		


		


	
	

		


		


		


		


		


		


		


		


		


		


		


		


		


		


	
	

		
In the highlighted boxes of calculator 1, manually enter the values for A and C
		


		


		


		


		


		


		


		


		


		


		


		


		


	
	

		
Next fill in the blank rota template in the highlighted areas on sheet 1 (Monday-Sunday), the values for B, D and E will be automatically calculated and entered. 
		


		


		


		


		


		


		


		


		


		


		


		


		


	
	

		


		


		


		


		


		


		


		


		


		


		


		


		


		


	
	

		
If you don't want to use the spreadsheet you can enter all the values A-D manually in the grey boxes of calculator 2 and the value of E and the totals will be calculated for you.