ABCDEFGHIJKLMNOPQRSTUVWXYZ
1
Fill in the yellow boxes!
2
3
contracted hours per week40
4
weeks worked per year46.4
(if not Termtime Only, then 46.4 regardless of annual leave)
5
max weeks per year46.4(52 minus stat leave)
6
average hours per week40.00
7
8
usual duration (wks)208
9
minimum duration (wks)208.00
10
minimum duration (days)1456
11
(leave entitlement)9.00
12
OTJ Hours1194
(now tops out at 6 hours per week if average hours are over 30)
13
14
Start date11/9/2023
15
Planned End date11/4/2027
16
17
18
As more people are using this, please be aware that no liability can be accepted from use of this calculator, it's *my* intepretation of the rules NOT ESFA-Approved.
19
Also, it sometimes goes a bit weird because sheets and excel don't always play well together, so just make sure you take a second look at what it's telling you!
20
21
22
23
24
25
26
27
28
29
30
31
32
33
34
35
36
37
38
39
40
41
42
43
44
45
46
47
48
49
50
51
52
53
54
55
56
57
58
59
60
61
62
63
64
65
66
67
68
69
70
71
72
73
74
75
76
77
78
79
80
81
82
83
84
85
86
87
88
89
90
91
92
93
94
95
96
97
98
99
100