L1 EHQCB collateral 30 day outflows, value / percentage must equal a calculation over 27 cells (C 76.00.a, EBA rule v10181_m)

Word for word as the report shows it when the rule fails.

C_76.00.A: L1 EHQCB collateral 30 day outflows = C_74.00.A: Level 1 collateral which is extremely high quality covered bonds, of which collateral received meets operational requirements, Exempted from the cap on inflows (row 0275) + C_74.00.A: Level 1 collateral which is extremely high quality covered bonds, of which collateral received meets operational requirements, Subject to the 75% cap on inflows (row 0275) + C_74.00.A: Level 1 collateral which is extremely high quality covered bonds, of which collateral received meets operational requirements, Subject to the 90% cap on inflows (row 0275) + C_74.00.A: Level 1 collateral which is extremely high quality covered bonds, of which collateral received meets operational requirements, Exempted from the cap on inflows (row 0315) + C_74.00.A: Level 1 collateral which is extremely high quality covered bonds, of which collateral received meets operational requirements, Subject to the 75% cap on inflows (row 0315) + C_74.00.A: Level 1 collateral which is extremely high quality covered bonds, of which collateral received meets operational requirements, Subject to the 90% cap on inflows (row 0315) - C_74.00.A: of which: secured by L1 EHQCB, Subject to the 75% cap on inflows - C_74.00.A: of which: secured by L1 EHQCB, Subject to the 90% cap on inflows - C_74.00.A: of which: secured by L1 EHQCB, Exempted from the cap on inflows + C_75.01.A: Level 1: extremely high quality covered bonds, of which collateral swapped meets operational requirements, Liquidity value of collateral borrowed (row 0060) + C_75.01.A: Level 1: extremely high quality covered bonds, of which collateral swapped meets operational requirements, Liquidity value of collateral borrowed (row 2100) + C_75.01.A: Level 1: extremely high quality covered bonds, of which collateral swapped meets operational requirements, Liquidity value of collateral borrowed (row 1590) + C_75.01.A: Level 1: extremely high quality covered bonds, of which collateral swapped meets operational requirements, Liquidity value of collateral borrowed (row 2610) + C_75.01.A: Level 1: extremely high quality covered bonds, of which collateral swapped meets operational requirements, Liquidity value of collateral borrowed (row 0570) + C_75.01.A: Level 1: extremely high quality covered bonds, of which collateral swapped meets operational requirements, Liquidity value of collateral borrowed (row 1420) + C_75.01.A: Level 1: extremely high quality covered bonds, of which collateral swapped meets operational requirements, Liquidity value of collateral borrowed (row 2270) + C_75.01.A: Level 1: extremely high quality covered bonds, of which collateral swapped meets operational requirements, Liquidity value of collateral borrowed (row 1930) + C_75.01.A: Level 1: extremely high quality covered bonds, of which collateral swapped meets operational requirements, Liquidity value of collateral borrowed (row 1080) + C_75.01.A: Level 1: extremely high quality covered bonds, of which collateral swapped meets operational requirements, Liquidity value of collateral borrowed (row 0400) + C_75.01.A: Level 1: extremely high quality covered bonds, of which collateral swapped meets operational requirements, Liquidity value of collateral borrowed (row 1250) + C_75.01.A: Level 1: extremely high quality covered bonds, of which collateral swapped meets operational requirements, Liquidity value of collateral borrowed (row 0230) + C_75.01.A: Level 1: extremely high quality covered bonds, of which collateral swapped meets operational requirements, Liquidity value of collateral borrowed (row 1760) + C_75.01.A: Level 1: extremely high quality covered bonds, of which collateral swapped meets operational requirements, Liquidity value of collateral borrowed (row 2440) + C_75.01.A: Level 1: extremely high quality covered bonds, of which collateral swapped meets operational requirements, Liquidity value of collateral borrowed (row 0740) + C_75.01.A: Level 1: extremely high quality covered bonds, of which collateral swapped meets operational requirements, Liquidity value of collateral borrowed (row 0910) - C_75.01.A: of which: collateral borrowed is L1 EHQCB, Liquidity value of collateral borrowed + C_72.00.A: Central institutions: Level 1 EHQ covered bonds which are considered liquid assets for the depositing credit institution, Value according to Article 9

EBA's formula. Cells are written as {template, row, column, sheet}.