The rule in plain words

Total EU area cannot be less than these four added up:

Loans collateralised by commercial immovable property
Loans collateralised by residential immovable property
Collateral obtained by taking possession: residential and commercial immovable properties
Level of energy efficiency (EP score in kWh/m² of collateral) estimated

All the values are in the > 200; <= 300 column (0040) of D 02.00.a.

EBA writes it out seven times. These words are for the first; the others are the same rule on other cells.

The template it checks

Rows

0010Total EU area
0020Of which Loans collateralised by commercial immovable property
0030Of which Loans collateralised by residential immovable property
0040Of which Collateral obtained by taking possession: residential and commercial immovable properties
0050Of which Level of energy efficiency (EP score in kWh/m² of collateral) estimated

Column

Show the rule as writtenShow

EBA's formula, as written out for the first of its checks. Cells are written as {template, row, column, sheet}.

{D_02.00.a,r0010,c0040,} >= {D_02.00.a,r0020,c0040,} + {D_02.00.a,r0030,c0040,} + {D_02.00.a,r0040,c0040,} + {D_02.00.a,r0050,c0040,}

And 6 more, the same formula for the other cells it covers.

Checks like this one, run at the point of submission, are the first step to real-time supervision.