Gender-Pay-Gap-Calculator-v1.0
 Share
The version of the browser you are using is no longer supported. Please upgrade to a supported browser.Dismiss

 
$
%
123
 
 
 
 
 
 
 
 
 
ABCDEFGHIJKLMNOPQRSTUVWXYZ
1
How to use this spreadsheet to calculate your gender pay gaps
2
Version
1.0Date
10th June 2018
3
4
Prepared by Nigel Marriott, Independent Statistician
5
Website
www.marriott-stats.com
6
Email
nigel@marriott-stats.com
7
8
ENTERING YOUR DATA
9
Enter your data in the YELLOW columns A to E of RAWDATA
10
11
Employee#
An identity number for your employee. For security reasons, try to avoid putting employee names in this column.
12
Gender
The gender of your employee. Use MALE or FEMALE. Alternatively M & F is acceptable.
13
#HrsWeek
How many hours per week does your employee work?
14
Salary
Their annual salary EXCLUDING BONUSES
15
Bonus
Any bonuses paid
16
17
Columns F to N in RAWDATA are highlighted in blue and should be copied and pasted down so that they appear for all employees.
18
In cell P1 of RAWDATA, enter your company name so that it will appear on the report sheets
19
20
HOW THE SPREADSHEET DOES THE CALCULATIONS
21
All of my calculations are on the CALCULATIONS sheet.
22
This sheet is currently protected but there is no password to unprotect it if you wish to look at the formulas.
23
At the moment, you do not need to do anything on this sheet.
24
It is rather untidy in its format so I will tidy this up in a later version
25
But what you should be able to see is that the Excel formulas are quite simple and take advtange of the blue columns in RAWDATA,
26
27
DATA TO REPORT
28
The data that you currently need to report to the government is shown on the DATATOREPORT sheet
29
I have made a number of suggestions for improving the gender pay gap data to the government.
30
If these are adopted, then the data you will need to report will be in DATATOREPORTALT
31
32
My blogs about the gender pay gap
33
1. What gender pay gap data tells us, what it doesn't tell us and how it can be misused
34
2. Three distinct errors that have been made by at least 10% of all organisations when submitting their gender pay gap data
35
3. How to distinguish between a true pay gap and a pay gap that arises naturally due to the laws of chance
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
Loading...