Pay Caculator.xlsx

	C	H	J	N	P	Q	R
1
2
3	From your pay slip enter the following information into the pale yellow boxes				Grade	Scale	Percentage
4					2	3	9.00
5	Annual Salary	£ -	Percentage Increase	0.00%	2	4	8.50
6					2	5	8.00
7	Monthly Gross Pay	£ -	Incease Per Hour	£ -	3	6	7.50
8					3	7	7.20
9	Monthly Deductions	£ -	New Hourly Rate	£ -	3	8	6.80
10					3	9	6.20
11	Monthly Take Home	£ -	New Weekly Pay	£ -	3	10	5.80
12					4	11	5.50
13	Current Weekly Rate	£ -	New Take Home	£ -	4	12	5.00
14					4	13	4.80
15	Number of Hours / Week	35			4	14	4.50
16					4	15	4.00
17	Current Hourly Rate	£ -			5	16	3.80
18					5	17	3.40
19					5	18	3.20
20		Link to Full Grade and Pay Scales HERE			5	19	3.10
21		Link to Full Grade and Pay Scales HERE			5	20	3.00
22					6+	21+	3.00
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