The rule in plain words
Total must equal these six added up:
- Male (excluding employee representatives)
- Non-binary employee representatives
- Male employee representatives
- Non-binary (excluding employee representatives)
- Female (excluding employee representatives)
- Female employee representatives
All the values are in the number of non-executive directors ([reference period]) column (0010) of R 18.00.
How the Line4 Check report words itShowHide
Word for word as the report shows it when the rule fails.
Male (excluding employee representatives) + Non-binary employee representatives + Male employee representatives + Non-binary (excluding employee representatives) + Female (excluding employee representatives) + Female employee representatives = Total
What to do if your filing fails it
- 01Open the template below and find the cells the rule reads.
- 02Add up the parts in your file and compare the result with the total.
- 03If they differ, a part is missing, a value sits in the wrong row, or the total is out of date.
- 04EBA compares the values exactly here: there is no rounding tolerance.
- 05It runs only when your filing indicators mark R 18.00 as reported.
- 06This is a warning. It does not stop the filing on its own, but your authority may ask you to explain it.
The cells it reads
Newly appointed non-executive directors (including chairperson) (R 18.00)
Rows
- 0010Male (excluding employee representatives)
- 0020Female (excluding employee representatives)
- 0030Non-binary (excluding employee representatives)
- 0040Male employee representatives
- 0050Female employee representatives
- 0060Non-binary employee representatives
- 0070Total
Column
- 0010Number of non-executive directors ([REFERENCE PERIOD])
A worked example
The first of its checks, with simple numbers.
Total must then be 3,000.
A file that reports 3,000 passes. One that reports 3,100 fails, by 100.
The numbers are illustrative.
Show the rule as writtenShowHide
EBA's formula. Cells are written as {template, row, column, sheet}.
sum({R_18.00,r0010,c0010,},{R_18.00,r0060,c0010,},{R_18.00,r0040,c0010,},{R_18.00,r0030,c0010,},{R_18.00,r0020,c0010,},{R_18.00,r0050,c0010,}) = {R_18.00,r0070,c0010,}Other rules on R 18.00
Every REM diversity rule, by template
Checks like this one, run at the point of submission, are the first step to real-time supervision.
