Open on EUR-Lex ↗
◷
New version applies from 21/02/2015 — introduced by Commission Implementing Regulation (EU) 2015/79, Commission Implementing Regulation (EU) 2015/227. 49 provisions change. Later versions: 01/06/2015, 25/03/2016, 20/04/2016, 10/09/2016, 01/12/2016, 01/01/2018, 01/03/2018, 01/12/2018, 01/06/2020, 28/06/2021. Annex XV changes in this version: compare with the current text.
View as of 21/02/2015 What changes

Annex XV

Annex XV

ANNEX XV

VALIDATION FORMULAE

ID

Tables used in formula

Formula applies to

Formula

T1

T2

T3

T4

T5

T6

Rows

Columns

Sheets

v0002_h

C 18.00

(060)

(All)

{r011} = +{r210} + {r020}

v0003_h

C 23.00

(010;020;030;040;050;060)

{r010} = +{r080} + {r070} + {r090}

v0004_h

C 21.00

(060)

(All)

{r090} = +{r100} + {r110} + {r120} + {r130}

v0005_h

C 23.00

(060)

{r100} = +{r110} + {r120} + {r130} + {r140}

v0006_h

C 18.00

(060)

(All)

{r350} = +{r360} + {r370} + {r380} + {r390}

v0007_h

C 22.00

(090)

{r050} = +{r060} + {r070} + {r080} + {r090}

v0008_h

C 07.00.a

(010;020;030;040;050;060;070;080;090;110;130)

(All)

{c130} >= +{c140}

v0009_h

C 12.00

(010;020;030;040;050;060;070;080;090;100;110;120;130;140;150;160;170;180;190;200;210;220;230;240)

{c070} = +{c050} +{c060}

v0010_h

C 07.00.a

(010;020;030;040;050;060;070;080;090;110;130;140;150;160;170;180;190;200;220;230;240;250;260;270;280)

(All)

{c040} = +{c010} +{c030}

v0011_h

C 07.00.c

(290;310)

(All)

{c040} = +{c010} +{c030}

v0012_h

C 07.00.d

(300;320)

(All)

{c040} = +{c010} +{c030}

v0022_h

C 05.02

(010)

{r040} = +{r060} + {r050} + {r070}

v0023_h

C 05.02

(010)

{r110} = +{r130} + {r120} + {r140}

v0050_h

F 01.01

(010)

{r300} = +{r310} + {r320}

v0057_h

F 01.03

(010)

{r210} = +{r230} + {r220} + {r215}

v0058_h

F 01.03

(010)

{r200} = +{r203} + {r202} + {r204} + {r201}

v0059_h

F 01.03

(010)

{r205} = +{r207} + {r206} + {r208} + {r209}

v0067_h

F 01.01

(010)

{r180} = +{r190} + {r200}

v0069_h

F 01.01

(010)

{r210} = +{r220} + {r230}

v0071_h

F 01.01

(010)

{r231} = +{r232} + {r233}

v0101_h

C 40.00

(010;020;050;070)

{r010} = +{r050} + {r020} + {r060}

v0102_h

C 40.00

(050;070)

{r020} = +{r040} + {r030}

v0108_h

C 04.00

(010)

{r070} = +{r090} + {r080}

v0128_h

C 04.00

(010)

{r010} = +{r020} + {r040} + {r030}

v0129_h

F 01.03

(010)

{r010} = +{r020} + {r030}

v0130_h

F 01.03

(010)

{r050} = +{r060} + {r070}

v0132_h

C 40.00

(070)

{r110} >= +{r120}

v0133_h

C 40.00

(070)

{r170} >= +{r180}

v0136_h

F 02.00

(010)

{r670} = +{r630} + {r640} + {r632}

v0138_h

F 02.00

(010)

{r630} = +{r610} - {r620}

v0141_h

F 02.00

(010)

{r360} = +{r380} + {r370}

v0143_h

F 02.00

(010)

{r640} = +{r650} - {r660}

v0144_h

F 02.00

(010)

{r632} = +{r633} - {r634}

v0145_h

F 01.03

(010)

{r270} = +{r280} + {r290}

v0147_h

C 06.00

(All)

{c150} = +{c210} +{c180}

v0148_h

C 01.00

(010)

{r010} = +{r530} + {r020} + {r750}

v0149_h

C 06.00

(All)

{c120} = +{c210} +{c180} +{c230}

v0150_h

C 02.00

(010)

{r490} = +{r500} + {r510}

v0172_m

C 01.00

(010)

{r020} = {r030} + {r130} + {r180} + {r200} + {r210} + {r220} + {r230} + {r240} + {r250} + {r300} + {r340} + {r370} + {r380} + {r390} + {r430} + {r440} + {r450} + {r460} + {r470} + {r471} + {r472} + {r480} + {r490} + {r500} + {r510} + {r520} + {r524} + {r529}

v0173_m

C 01.00

{r030,c010} = {r040,c010} + {r060,c010} + {r070,c010} + {r092,c010}

v0174_m

C 01.00

{r070,c010} = {r080,c010} + {r090,c010} + {r091,c010}

v0175_m

C 01.00

{r130,c010} = {r140,c010} + {r150,c010}

v0176_m

C 01.00

{r150,c010} = {r160,c010} + {r170,c010}

v0177_m

C 01.00

{r250,c010} = {r260,c010} + {r270,c010} + {r280,c010} + {r285,c010} + {r290,c010}

v0178_m

C 01.00

{r300,c010} = {r310,c010} + {r320,c010} + {r330,c010}

v0179_m

C 01.00

{r340,c010} = {r350,c010} + {r360,c010}

v0180_m

C 01.00

{r390,c010} = {r400,c010} + {r410,c010} + {r420,c010}

v0181_m

C 01.00

{r440,c010} = -{r740,c010}

v0182_m

C 01.00

(c010)

{r530} = {r540} + {r660} + {r670} + {r680} + {r690} + {r700} + {r710} + {r720} + {r730} + {r740} + {r744} + {r748}

v0183_m

C 01.00

{r540,c010} = {r550,c010} + {r570,c010} + {r580,c010} + {r622,c010}

v0184_m

C 01.00

{r580,c010} = {r590,c010} + {r620,c010} + {r621,c010}

v0185_m

C 01.00

{r720,c010} = -{r970,c010}

v0186_m

C 01.00

(010)

{r750} = {r760} + {r880} + {r890} + {r900} + {r910} + {r920} + {r930} + {r940} + {r950} + {r960} + {r970} + {r974} + {r978}

v0187_m

C 01.00

{r760,c010} = {r770,c010} + {r790,c010} + {r800,c010} + {r842,c010}

v0188_m

C 01.00

{r800,c010} = {r810,c010} + {r840,c010} + {r841,c010}

v0189_m

C 01.00

C 05.01

{C 01.00, r070,c010} = {C 05.01, r210,c060}

v0190_m

C 01.00

C 05.01

{C 01.00, r230,c010} = {C 05.01, r090,c060}

v0191_m

C 01.00

C 05.01

{C 01.00, r370,c010} = {C 05.01, r170,c060}

v0192_m

C 01.00

C 05.01

{C 01.00, r380,c010} = {C 05.01, r180,c060}

v0193_m

C 01.00

C 05.01

{C 01.00, r390,c010} = {C 05.01, r190,c060}

v0194_m

C 01.00

C 05.01

{C 01.00, r480,c010} = {C 05.01, r350,c060}

v0195_m

C 01.00

C 05.01

{C 01.00, r500,c010} = {C 05.01, r400,c060}

v0196_m

C 01.00

C 05.01

{C 01.00, r580,c010} = {C 05.01, r220,c060}

v0197_m

C 01.00

C 05.01

{C 01.00, r670,c010} = {C 05.01, r091,c060}

v0198_m

C 01.00

C 05.01

{C 01.00, r700,c010} = {C 05.01, r360,c060}

v0199_m

C 01.00

C 05.01

{C 01.00, r710,c010} = {C 05.01, r410,c060}

v0200_m

C 01.00

C 05.01

{C 01.00, r800,c010} = {C 05.01, r230,c060}

v0201_m

C 01.00

C 05.01

{C 01.00, r890,c010} = {C 05.01, r092,c060}

v0202_m

C 01.00

C 05.01

{C 01.00, r940,c010} = {C 05.01, r370,c060}

v0203_m

C 01.00

C 05.01

{C 01.00, r950,c010} = {C 05.01, r420,c060}

v0204_m

C 02.00

{r010,c010} = {r040,c010} + {r490,c010} + {r520,c010} + {r590,c010} + {r630,c010} + {r640,c010} + {r680,c010} + {r690,c010}

v0205_m

C 02.00

{r040,c010} = {r050,c010} + {r240,c010} + {r460,c010}

v0206_m

C 02.00

{r050,c010} = {r060,c010} + {r220,c010}

v0207_m

C 02.00

{r060,c010} = {r070,c010} + {r080,c010} + {r090,c010} + {r100,c010} + {r110,c010} + {r120,c010} + {r130,c010} + {r140,c010} + {r150,c010} + {r160,c010} + {r170,c010} + {r180,c010} + {r190,c010} + {r200,c010} + {r210,c010} + {r211,c010}

v0208_m

C 02.00

{r220,c010} >= {r230,c010}

v0209_m

C 02.00

{r240,c010} = {r250,c010} + {r310,c010} + {r420,c010} + {r430,c010} + {r450,c010}

v0210_m

C 02.00

{r250,c010} = {r260,c010} + {r270,c010} + {r280,c010} + {r290,c010} + {r300,c010}

v0211_m

C 02.00

{r310,c010} = {r320,c010} + {r330,c010} + {r340,c010} + {r350,c010} + {r360,c010} + {r370,c010} + {r380,c010} + {r390,c010} + {r400,c010} + {r410,c010}

v0212_m

C 02.00

{r430,c010} >= {r440,c010}

v0213_m

C 02.00

{r530,c010} = {r540,c010} + {r550,c010} + {r560,c010} + {r570,c010}

v0214_m

C 02.00

{r590,c010} = {r600,c010} + {r610,c010} + {r620,c010}

v0215_m

C 02.00

{r640,c010} = {r650,c010} + {r660,c010} + {r670,c010}

v0216_m

C 02.00

{r690,c010} >= {r710,c010} + {r750,c010} + {r760,c010}

v0217_m

C 02.00

{r710,c010} >= {r720,c010} + {r730,c010} + {r740,c010}

v0218_m

C 01.00

C 03.00

C 02.00

{C 01.00, r020,c010} = {C 02.00, r010,c010} * {C 03.00, r010,c010}

v0219_m

C 01.00

C 03.00

C 02.00

{C 03.00, r020,c010} = {C 01.00, r020,c010} - ({C 02.00, r010,c010} * 4.5%)

v0220_m

C 01.00

C 03.00

C 02.00

{C 01.00, r015,c010} = {C 02.00, r010,c010} * {C 03.00, r030,c010}

v0221_m

C 01.00

C 03.00

C 02.00

{C 03.00, r040,c010} = {C 01.00, r015,c010} - ({C 02.00, r010,c010} * 6%)

v0222_m

C 01.00

C 03.00

C 02.00

{C 01.00, r010,c010} = {C 02.00, r010,c010} * {C 03.00, r050,c010}

v0223_m

C 01.00

C 03.00

C 02.00

{C 03.00, r060,c010} = {C 01.00, r010,c010} - ({C 02.00, r010,c010} * 8%)

v0224_m

C 04.00

{r050,c010} = {r060,c010} + {r070,c010}

v0225_m

C 04.00

{r100,c010} = {r110,c010} - {r140,c010}

v0226_m

C 04.00

{r110,c010} = {r120,c010} + {r130,c010} + {r131,c010}

v0227_m

C 04.00

{r230,c010} = {r240,c010} + {r270,c010} + {r291,c010}

v0228_m

C 04.00

{r240,c010} = {r250,c010} + {r260,c010}

v0229_m

C 04.00

{r270,c010} = {r280,c010} + {r290,c010}

v0230_m

C 04.00

{r291,c010} = {r292,c010} + {r293,c010}

v0231_m

C 04.00

{r300,c010} = {r310,c010} + {r340,c010} + {r361,c010}

Official text · the act as published Open full page ↗
10 queries · page built in 40 msInventory f82bbfa3