L2B collateral 30 day inflows, value / percentage must equal a calculation over 74 cells (C 76.00.a, EBA rule v10186_m)

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

C_76.00.A: L2B collateral 30 day inflows = C_73.00.A: level 2B asset-backed securities (residential or automobile, CQS1) collateral, of which collateral extended meets operational requirements, Value of collateral extended according to Article 9 (row 1065) + C_73.00.A: level 2B asset-backed securities (residential or automobile, CQS1) collateral, of which collateral extended meets operational requirements, Value of collateral extended according to Article 9 (row 0975) + C_73.00.A: level 2B covered bonds, of which collateral extended meets operational requirements, Value of collateral extended according to Article 9 (row 0985) + C_73.00.A: level 2B asset-backed securities (commercial or individuals, Member State, CQS1) collateral, of which collateral extended meets operational requirements, Value of collateral extended according to Article 9 (row 0995) + C_73.00.A: level 2B covered bonds, of which collateral extended meets operational requirements, Value of collateral extended according to Article 9 (row 1075) + C_73.00.A: level 2B asset-backed securities (commercial or individuals, Member State, CQS1) collateral, of which collateral extended meets operational requirements, Value of collateral extended according to Article 9 (row 1085) + C_73.00.A: other Level 2B assets collateral, of which collateral extended meets operational requirements, Value of collateral extended according to Article 9 (row 1095) + C_73.00.A: other Level 2B assets collateral, of which collateral extended meets operational requirements, Value of collateral extended according to Article 9 (row 1005) - C_73.00.A: of which: secured by L2B, Value of collateral extended according to Article 9 + C_75.01.A: Level 1: extremely high quality covered bonds, of which collateral swapped meets operational requirements, Liquidity value of collateral lent (row 2270) + C_75.01.A: Level 2B: asset-backed securities (commercial or individuals, Member State, CQS1), of which collateral swapped meets operational requirements, Liquidity value of collateral lent (row 2010) + C_75.01.A: Level 2B: asset-backed securities (residential or automobile, CQS1), of which collateral swapped meets operational requirements, Liquidity value of collateral lent (row 1120) + C_75.01.A: Level 2A assets, of which collateral swapped meets operational requirements, Liquidity value of collateral lent (row 2290) + C_75.01.A: Level 1: extremely high quality covered bonds, of which collateral swapped meets operational requirements, Liquidity value of collateral lent (row 1080) + C_75.01.A: Level 1: extremely high quality covered bonds, of which collateral swapped meets operational requirements, Liquidity value of collateral lent (row 2100) + C_75.01.A: Level 2B: high quality covered bonds, of which collateral swapped meets operational requirements, Liquidity value of collateral lent (row 2330) + C_75.01.A: Level 1: extremely high quality covered bonds, of which collateral swapped meets operational requirements, Liquidity value of collateral lent (row 0740) + C_75.01.A: Level 1: extremely high quality covered bonds, of which collateral swapped meets operational requirements, Liquidity value of collateral lent (row 0910) + C_75.01.A: Level 1: extremely high quality covered bonds, of which collateral swapped meets operational requirements, Liquidity value of collateral lent (row 1930) + C_75.01.A: Other Level 2B, of which collateral swapped meets operational requirements, Liquidity value of collateral lent (row 1010) + C_75.01.A: Non-liquid assets, of which collateral swapped meets operational requirements, Liquidity value of collateral lent (row 0690) + C_75.01.A: Level 2A assets, of which collateral swapped meets operational requirements, Liquidity value of collateral lent (row 2120) + C_75.01.A: Non-liquid assets, of which collateral swapped meets operational requirements, Liquidity value of collateral lent (row 2220) + C_75.01.A: Level 2B: asset-backed securities (residential or automobile, CQS1), of which collateral swapped meets operational requirements, Liquidity value of collateral lent (row 0610) + C_75.01.A: Level 2A assets, of which collateral swapped meets operational requirements, Liquidity value of collateral lent (row 2460) + C_75.01.A: Level 1 assets (excl. EHQ covered bonds), of which collateral swapped meets operational requirements, Liquidity value of collateral lent (row 1060) + C_75.01.A: Level 2A assets, of which collateral swapped meets operational requirements, Liquidity value of collateral lent (row 1950) + C_75.01.A: Level 2B: asset-backed securities (residential or automobile, CQS1), of which collateral swapped meets operational requirements, Liquidity value of collateral lent (row 0780) + C_75.01.A: Level 2A assets, of which collateral swapped meets operational requirements, Liquidity value of collateral lent (row 0930) + C_75.01.A: Level 2B: high quality covered bonds, of which collateral swapped meets operational requirements, Liquidity value of collateral lent (row 0800) + C_75.01.A: Level 2B: asset-backed securities (commercial or individuals, Member State, CQS1), of which collateral swapped meets operational requirements, Liquidity value of collateral lent (row 2180) + C_75.01.A: Level 2B: high quality covered bonds, of which collateral swapped meets operational requirements, Liquidity value of collateral lent (row 2500) + C_75.01.A: Level 2B: high quality covered bonds, of which collateral swapped meets operational requirements, Liquidity value of collateral lent (row 0970) + C_75.01.A: Other Level 2B, of which collateral swapped meets operational requirements, Liquidity value of collateral lent (row 1180) + C_75.01.A: Other Level 2B, of which collateral swapped meets operational requirements, Liquidity value of collateral lent (row 2200) + C_75.01.A: Level 2B: high quality covered bonds, of which collateral swapped meets operational requirements, Liquidity value of collateral lent (row 1140) + C_75.01.A: Level 2B: asset-backed securities (residential or automobile, CQS1), of which collateral swapped meets operational requirements, Liquidity value of collateral lent (row 2140) + C_75.01.A: Level 1: extremely high quality covered bonds, of which collateral swapped meets operational requirements, Liquidity value of collateral lent (row 2440) + C_75.01.A: Non-liquid assets, of which collateral swapped meets operational requirements, Liquidity value of collateral lent (row 2560) + C_75.01.A: Level 2A assets, of which collateral swapped meets operational requirements, Liquidity value of collateral lent (row 1100) + C_75.01.A: Level 1 assets (excl. EHQ covered bonds), of which collateral swapped meets operational requirements, Liquidity value of collateral lent (row 0550) + C_75.01.A: Level 2B: asset-backed securities (residential or automobile, CQS1), of which collateral swapped meets operational requirements, Liquidity value of collateral lent (row 2480) + C_75.01.A: Level 2B: asset-backed securities (commercial or individuals, Member State, CQS1), of which collateral swapped meets operational requirements, Liquidity value of collateral lent (row 0990) + C_75.01.A: Level 2B: asset-backed securities (commercial or individuals, Member State, CQS1), of which collateral swapped meets operational requirements, Liquidity value of collateral lent (row 1160) + C_75.01.A: Non-liquid assets, of which collateral swapped meets operational requirements, Liquidity value of collateral lent (row 2050) + C_75.01.A: Level 2B: high quality covered bonds, of which collateral swapped meets operational requirements, Liquidity value of collateral lent (row 1990) + C_75.01.A: Level 2B: asset-backed securities (commercial or individuals, Member State, CQS1), of which collateral swapped meets operational requirements, Liquidity value of collateral lent (row 2520) + C_75.01.A: Non-liquid assets, of which collateral swapped meets operational requirements, Liquidity value of collateral lent (row 1200) + C_75.01.A: Level 2B: high quality covered bonds, of which collateral swapped meets operational requirements, Liquidity value of collateral lent (row 2160) + C_75.01.A: Other Level 2B, of which collateral swapped meets operational requirements, Liquidity value of collateral lent (row 0840) + C_75.01.A: Level 1 assets (excl. EHQ covered bonds), of which collateral swapped meets operational requirements, Liquidity value of collateral lent (row 1910) + C_75.01.A: Other Level 2B, of which collateral swapped meets operational requirements, Liquidity value of collateral lent (row 2540) + C_75.01.A: Level 2B: asset-backed securities (commercial or individuals, Member State, CQS1), of which collateral swapped meets operational requirements, Liquidity value of collateral lent (row 0650) + C_75.01.A: Level 1 assets (excl. EHQ covered bonds), of which collateral swapped meets operational requirements, Liquidity value of collateral lent (row 0890) + C_75.01.A: Level 1 assets (excl. EHQ covered bonds), of which collateral swapped meets operational requirements, Liquidity value of collateral lent (row 2420) + C_75.01.A: Level 1 assets (excl. EHQ covered bonds), of which collateral swapped meets operational requirements, Liquidity value of collateral lent (row 2250) + C_75.01.A: Level 1: extremely high quality covered bonds, of which collateral swapped meets operational requirements, Liquidity value of collateral lent (row 0570) + C_75.01.A: Level 1 assets (excl. EHQ covered bonds), of which collateral swapped meets operational requirements, Liquidity value of collateral lent (row 0720) + C_75.01.A: Non-liquid assets, of which collateral swapped meets operational requirements, Liquidity value of collateral lent (row 1030) + C_75.01.A: Level 2B: asset-backed securities (commercial or individuals, Member State, CQS1), of which collateral swapped meets operational requirements, Liquidity value of collateral lent (row 0820) + C_75.01.A: Other Level 2B, of which collateral swapped meets operational requirements, Liquidity value of collateral lent (row 0670) + C_75.01.A: Level 2A assets, of which collateral swapped meets operational requirements, Liquidity value of collateral lent (row 0760) + C_75.01.A: Level 2B: asset-backed securities (commercial or individuals, Member State, CQS1), of which collateral swapped meets operational requirements, Liquidity value of collateral lent (row 2350) + C_75.01.A: Level 2A assets, of which collateral swapped meets operational requirements, Liquidity value of collateral lent (row 0590) + C_75.01.A: Level 2B: asset-backed securities (residential or automobile, CQS1), of which collateral swapped meets operational requirements, Liquidity value of collateral lent (row 1970) + C_75.01.A: Non-liquid assets, of which collateral swapped meets operational requirements, Liquidity value of collateral lent (row 0860) + C_75.01.A: Level 2B: high quality covered bonds, of which collateral swapped meets operational requirements, Liquidity value of collateral lent (row 0630) + C_75.01.A: Other Level 2B, of which collateral swapped meets operational requirements, Liquidity value of collateral lent (row 2030) + C_75.01.A: Non-liquid assets, of which collateral swapped meets operational requirements, Liquidity value of collateral lent (row 2390) + C_75.01.A: Level 2B: asset-backed securities (residential or automobile, CQS1), of which collateral swapped meets operational requirements, Liquidity value of collateral lent (row 0950) + C_75.01.A: Level 1 assets (excl. EHQ covered bonds), of which collateral swapped meets operational requirements, Liquidity value of collateral lent (row 2080) + C_75.01.A: Other Level 2B, of which collateral swapped meets operational requirements, Liquidity value of collateral lent (row 2370) + C_75.01.A: Level 2B: asset-backed securities (residential or automobile, CQS1), of which collateral swapped meets operational requirements, Liquidity value of collateral lent (row 2310) - C_75.01.A: of which: collateral lent is L2B, Liquidity value of collateral lent

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