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

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

C_76.00.A: L1 excl. EHQCB collateral 30 day outflows = C_74.00.A: Level 1 collateral excluding extremely high quality covered bonds, of which collateral received meets operational requirements, Subject to the 90% cap on inflows (row 0271) + C_74.00.A: Level 1 collateral excluding extremely high quality covered bonds, of which collateral received meets operational requirements, Subject to the 75% cap on inflows (row 0271) + C_74.00.A: Level 1 collateral excluding extremely high quality covered bonds, of which collateral received meets operational requirements, Exempted from the cap on inflows (row 0271) + C_74.00.A: Level 1 collateral excluding extremely high quality covered bonds, of which collateral received meets operational requirements, Subject to the 75% cap on inflows (row 0311) + C_74.00.A: Level 1 collateral excluding extremely high quality covered bonds, of which collateral received meets operational requirements, Exempted from the cap on inflows (row 0311) + C_74.00.A: Level 1 collateral excluding extremely high quality covered bonds, of which collateral received meets operational requirements, Subject to the 90% cap on inflows (row 0311) - C_74.00.A: of which: secured by L1 excl. EHQCB, Subject to the 75% cap on inflows - C_74.00.A: of which: secured by L1 excl. EHQCB, Subject to the 90% cap on inflows - C_74.00.A: of which: secured by L1 excl. EHQCB, Exempted from the cap on inflows + C_75.01.A: Level 1 assets (excl. EHQ covered bonds), of which collateral swapped meets operational requirements, Liquidity value of collateral borrowed (row 2420) + C_75.01.A: Level 1 assets (excl. EHQ covered bonds), of which collateral swapped meets operational requirements, Liquidity value of collateral borrowed (row 0380) + C_75.01.A: Level 1 assets (excl. EHQ covered bonds), of which collateral swapped meets operational requirements, Liquidity value of collateral borrowed (row 1060) + C_75.01.A: Level 1 assets (excl. EHQ covered bonds), of which collateral swapped meets operational requirements, Liquidity value of collateral borrowed (row 1400) + C_75.01.A: Level 1 assets (excl. EHQ covered bonds), of which collateral swapped meets operational requirements, Liquidity value of collateral borrowed (row 1740) + C_75.01.A: Level 1 assets (excl. EHQ covered bonds), of which collateral swapped meets operational requirements, Liquidity value of collateral borrowed (row 0550) + C_75.01.A: Level 1 assets (excl. EHQ covered bonds), of which collateral swapped meets operational requirements, Liquidity value of collateral borrowed (row 1230) + C_75.01.A: Level 1 assets (excl. EHQ covered bonds), of which collateral swapped meets operational requirements, Liquidity value of collateral borrowed (row 0210) + C_75.01.A: Level 1 assets (excl. EHQ covered bonds), of which collateral swapped meets operational requirements, Liquidity value of collateral borrowed (row 2080) + C_75.01.A: Level 1 assets (excl. EHQ covered bonds), of which collateral swapped meets operational requirements, Liquidity value of collateral borrowed (row 2590) + C_75.01.A: Level 1 assets (excl. EHQ covered bonds), of which collateral swapped meets operational requirements, Liquidity value of collateral borrowed (row 0720) + C_75.01.A: Level 1 assets (excl. EHQ covered bonds), of which collateral swapped meets operational requirements, Liquidity value of collateral borrowed (row 1910) + C_75.01.A: Level 1 assets (excl. EHQ covered bonds), of which collateral swapped meets operational requirements, Liquidity value of collateral borrowed (row 1570) + C_75.01.A: Level 1 assets (excl. EHQ covered bonds), of which collateral swapped meets operational requirements, Liquidity value of collateral borrowed (row 0040) + C_75.01.A: Level 1 assets (excl. EHQ covered bonds), of which collateral swapped meets operational requirements, Liquidity value of collateral borrowed (row 2250) + C_75.01.A: Level 1 assets (excl. EHQ covered bonds), of which collateral swapped meets operational requirements, Liquidity value of collateral borrowed (row 0890) - C_75.01.A: of which: collateral borrowed is L1 excl. EHQCB, Liquidity value of collateral borrowed + C_72.00.A: Central institutions: Level 1 assets excl. EHQ CB 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}.