The rule in plain words
All female staff in percent of all staff plus all male identified staff in percent based on all identified staff must equal 1.
All the values are in the total staff or identified staff row (0070) of R 06.00.b.
EBA writes it out five times. These words are for the first; the others are the same rule on other cells.
The template it checks
Information on the gender pay gap (II) (R 06.00.b)
Row
- 0070Total staff/identified staff
Columns
- 0030All female staff in percent of all staff
- 0040All male identified staff in percent based on all identified staff
Show the rule as writtenShowHide
EBA's formula, as written out for the first of its checks. Cells are written as {template, row, column, sheet}.
{R_06.00.b,r0070,c0030,} + {R_06.00.b,r0070,c0040,} = 1And 4 more, the same formula for the other cells it covers.
Other rules on R 06.00.b
- The sum of two columns must equal 1 (row 0050, v12533_m)Warning
- The cell cannot be more than 1 (v12532_m)Warning
- The sum of two columns must equal 1 (row 0050, v12669_m)Warning
- The sum of two columns must equal 1 (row 0040, v12670_m)Warning
- None of the 20 values it checks in information on the gender pay gap (II) can be negative (v12124_s)Warning
Every REM gender pay gap rule, by template
Checks like this one, run at the point of submission, are the first step to real-time supervision.
