{"text_format":"1","workbook":"xlsx","n_sheets":14,"sheets":["START","Intro","Table 1","Table 2","Table 3","Table 4","Labels","Balans - omzetting","Biodiesel","E95 - E5","E95 - E10","E98 - E5","E98 - E10","Bio-ethanol"],"not_rendered":{"charts":0,"images":4,"macros":1,"external_links":0,"defined_names":9,"comments":0,"pivot_tables":0},"unopened":[],"bounds":{"document_bytes":16777216,"sheet_cells":100000,"rows_first":2000,"rows_last":500,"rows_between":2000,"halvings":0,"cell_chars":16384,"cell_head_chars":4096},"cells_cut":0,"cells_raw":0,"read":"whole","date_system":"1900"}

{"sheet":"START","index":0,"n_rows":30,"n_cols":11,"rows_kept":30,"cut":false,"hidden":false,"merged":[[11,2,11,10],[13,2,13,12]]}
[]
[]
[]
[]
[]
[]
[]
[]
[null,"Algemene Directie Energie",null,null,null,null,null,null,null,null,"Direction Générale Energie"]
[null,"Dienst Energiemonitoring & Elektriciteitssysteem",null,null,null,null,null,null,null,null,"Service Monitoring de l'Energie & Système Electrique"]
[null,"Dienst Kwaliteit van Aardolieproducten",null,null,null,null,null,null,null,null,"Service Qualité des produits pétroliers"]
[]
[]
[null,null,"MAANDELIJKSE PETROLEUMBALANS\nBALANCE PETROLIERE"]
[]
[]
[]
[null,null,"Gelieve te klikken op \"Inhoud inschakelen\" als er een beveiligingswaarschuwing verschijnt"]
[]
[null,null,"Cliquez sur \"Activer les macros\" si un message de sécurité apparaît."]
[]
[]
[null,null,"De macros in dit bestand zijn vrij van virussen"]
[]
[null,null,"Les macros de ce fichier sont sans virus."]
[]
[]
[null,null,"Indien u technische problemen heeft met dit bestand, kunt u ons contacteren op oil&biofuels@economie.fgov.be"]
[]
[null,null,"Si ce fichier vous pose de problèmes techniques, veuillez nous contacter à l'adresse suivante: oil&biofuels@economie.fgov.be"]

{"sheet":"Intro","index":1,"n_rows":110,"n_cols":6,"rows_kept":110,"cut":false,"hidden":true,"merged":[[11,4,11,5],[14,1,35,9]]}
[]
[]
[]
[]
[]
[null,"Algemene Directie Energie"]
[null,"Dienst Energiemonitoring & Elektriciteitssysteem"]
[null,"Dienst Kwaliteit van Aardolieproducten"]
[]
[]
[]
[null,"Aangever",null,null,"Naam/Nom"]
[null,"Maand van aangifte",null,null,"01",2018]
[]
[null,"Deze vragenlijst is opgesteld conform het Koninklijk Besluit van 15 november 2017 betreffende de rapportageverplichting van biobrandstoffen, minerale oliën en hun substitutieproducten van biologische oorsprong.\n\nDe gegevens gevraagd in tabbladen 'Table 1', 'Table 2', Table 3' en 'Table 4' moeten bezorgd worden aan de Algemene Directie Energie, uiterlijk tegen de 20ste dag van de maand volgend op de maand van rapportering, zoals vastgelegd in artikel 6 van bovenvernoemd Koninklijk Besluit.\n\nWat betreft deze tabbladen, kan het niet naleven van artikel 4, 6, 7 en 9 van bovenvernoemd Koninklijk Besluit resulteren in een geldboete van 1,24 euro tot 495,79 euro.\n\nDe gegevens gevraagd vanaf het tabblad 'Biodiesel' moeten bezorgd worden aan de Algemene Directie Energie, uiterlijk tegen de laatste werkdag van de maand volgend op het kwartaal waarop de gegevens betrekking hebben, zoals vastgelegd in de wet van 17 juli 2013\n\nWat betreft deze tabbladen, kan het niet naleven van artikel 5, 6, 7 en 9 van bovenvernoemd Koninklijk Besluit resulteren in een administratieve geldboete van 100 euro tot 10.000 euro. In geval van herhaling kan de geldboete worden verdubbeld.\n\nAan de aangevers wordt de verzekering gegeven, dat de verstrekte gegevens niet voor fiscale doeleinden zullen worden gebruikt\n\nE-mail : oil&biofuels@economie.fgov.be"]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[null,"01"]
[null,"02"]
[null,"03"]
[null,"04"]
[null,"05"]
[null,"06"]
[null,"07"]
[null,"08"]
[null,"09"]
[null,"10"]
[null,"11"]
[null,"12"]

{"sheet":"Table 1","index":2,"n_rows":26,"n_cols":7,"rows_kept":26,"cut":false,"hidden":true,"merged":[[2,2,2,3],[9,2,10,2],[9,3,10,3],[9,4,10,4],[9,5,10,5]]}
[]
[]
[null,{"$f":"Intro!B12","v":"Aangever"},{"$f":"Intro!E12","v":"Naam/Nom"},null,null,null,"ALLE GEGEVENS MOETEN WORDEN "]
[null,{"$f":"Intro!B13","v":"Maand van aangifte"},{"$f":"Intro!E13","v":"01"},{"$f":"Intro!F13","v":2018},null,null,"INGEGEVEN IN  TON"]
[]
[]
["Table 1: BALANS RUWE OLIE, CONDENSATEN VAN AARDGAS EN INTERMEDIAIRE PRODUCTEN"]
[]
[]
[null,null,"Ruwe olie","Condensaten van aardgas","Intermediaire producten","Totaal"]
[]
["+","Beginvoorraad",null,null,null,{"$f":"SUM(C12:E12)","v":0}]
["+","Import",null,null,null,{"$f":"SUM(C13:E13)","v":0}]
["-","Export",null,null,null,{"$f":"SUM(C14:E14)","v":0}]
["+","Productie",null,null,null,{"$f":"E15","v":0}]
["+","Ontvangsten vrij verkeer",null,null,null,{"$f":"SUM(C16:E16)","v":0}]
["-","Leveringen vrij verkeer",null,null,null,0]
["+","Productoverdracht",null,null,null,{"$f":"SUM(C18:E18)","v":0}]
["-","Eindvoorraad",null,null,null,0]
["=","Refinery intake (Calculated)",{"$f":"C12+C13-C14+C16-C17+C18-C19","v":0},{"$f":"D12+D13-D14+D16-D17+D18-D19","v":0},{"$f":"E12+E13-E14+E16-E17+E18-E19+E15","v":0},0]
["-","Statistical difference",{"$f":"C20-C22","v":0},{"$f":"D20-D22","v":0},{"$f":"E20-E22","v":0},0]
["=","Refinery intake (Observed)",null,null,null,0]
[null,"Refinery losses",{"$f":"F22-'Table 2'!AK13+'Table 2'!AK11+'Table 2'!C13-'Table 2'!C11-E15","v":0}]
[null,null,{"$f":"IF(Labels!$B$2=\"NL\",IF(MIN(C12:C17,C19,C22)<0,\"Negatief cijfer\",\"\"),IF(MIN(C12:C17,C19,C22)<0,\"Chiffre négative\",\"\"))","v":""},{"$f":"IF(Labels!$B$2=\"NL\",IF(MIN(D12:D17,D19,D22)<0,\"Negatief cijfer\",\"\"),IF(MIN(D12:D17,D19,D22)<0,\"Chiffre négative\",\"\"))","v":""},{"$f":"IF(Labels!$B$2=\"NL\",IF(MIN(E12:E17,E19,E22)<0,\"Negatief cijfer\",\"\"),IF(MIN(E12:E17,E19,E22)<0,\"Chiffre négative\",\"\"))","v":""},{"$f":"IF(Labels!$B$2=\"NL\",IF(MIN(F12:F17,F19,F22)<0,\"Negatief cijfer\",\"\"),IF(MIN(F12:F17,F19,F22)<0,\"Chiffre négative\",\"\"))","v":""}]
[1,"Totaal Import (F13) komt overeen met Totaal Import van deze producten in Table 3 (E111)",null,null,null,{"$f":"ABS(F13-'Table 3'!E111)","v":0},{"$f":"IF(Labels!$B$2=\"NL\",IF(OR(F13<>0, 'Table 3'!E111<>0),IF(F25<=(0.001*(F13+'Table 3'!E111)/2),\"OK\",\"Totaal Import in Table 1 ≠ Totaal Import in Table 3\"),\"OK\"),IF(OR(F13<>0, 'Table 3'!E111<>0),IF(F25<=(0.001*(F13+'Table 3'!E111)/2),\"OK\",\"Total Importations en Table 1 ≠ Total Importations en Table 3\"),\"OK\"))","v":"OK"}]
[2,"Totaal Export (F14) komt overeen met Totaal Export van deze producten in Table 4 (E102)",null,null,null,{"$f":"ABS(F14-'Table 4'!E102)","v":0},{"$f":"IF(Labels!$B$2=\"NL\",IF(OR(F14<>0, 'Table 4'!E102<>0),IF(F26<=(0.001*(F14+'Table 4'!E102)/2),\"OK\",\"Totaal Export in Table 1 ≠  Totaal Export in Table 4\"),\"OK\"),IF(OR(F14<>0, 'Table 4'!E102<>0),IF(F26<=(0.001*(F14+'Table 4'!E102)/2),\"OK\",\"Total Exportations en Table 1 ≠ Total Exportations en Table 4\"),\"OK\"))","v":"OK"}]

{"sheet":"Table 2","index":3,"n_rows":28,"n_cols":37,"rows_kept":28,"cut":false,"hidden":true,"merged":[[23,12,23,13],[23,20,23,21],[23,25,23,26],[4,32,5,32],[4,33,5,33],[4,34,5,34],[4,35,5,35],[4,36,5,36],[22,12,22,13],[22,16,22,17],[22,18,22,19],[22,20,22,21],[4,18,5,18],[4,20,5,20],[4,21,5,21],[4,27,5,27],[4,30,5,30],[4,31,5,31],[4,17,5,17],[4,2,5,2],[4,6,5,6],[4,7,5,7],[4,12,5,12],[4,13,5,13]]}
[]
[null,{"$f":"IF('Table 1'!C3=0,\"\",'Table 1'!C3)","v":"Naam/Nom"}]
[null,{"$f":"IF('Table 1'!C4=0,\"\",'Table 1'!C4 & \" \" &'Table 1'!D4)","v":"01 2018"}]
["Table 2: BALANS AFGEWERKTE OLIEPRODUCTEN "]
[null,null,"Additieven /  Mengcomponent",null,null,null,"Oncondenseerbaar raffinagegas","Totaal LPG",null,null,null,null,"Nafta","Totaal motor benzine",null,null,null,"Vliegtuig- benzine","Totaal\nkerosine\ntype\njet fuel",null,"Lamp-petroleum","Totaal\ngas/diesel\nolie",null,null,null,null,null,"Zware residuele stookolie",null,null,"White spirit en Speciale benzine","Smeer-middelen","Bitumen","Paraffine","Petroleum coke","Andere olieproducten","Totaal olieproducten"]
[null,null,null,"Additief","Bio-ethanol","Biodiesel",null,null,"Butaan","Propaan","Gemengd (LPG)","Andere LPG",null,null,"Benzine 98 RON 10S","Benzine 95 RON 10S","Andere benzine",null,null,"waarvan via CEPS pijplijn",null,null,"Gasolie Diesel 10S","Gasolie verwarming","Gasolie verwarming Extra","Gasolie Rijn en binnenvaart","Andere Gasolie",null,"Laag zwavel\n(<1%)","Hoog zwavel\n (>=1%)"]
["+","Beginvoorraad ",null,null,null,null,null,{"$f":"I7+J7+K7+L7","v":0},null,null,null,null,null,{"$f":"O7+P7+Q7","v":0},null,null,null,null,null,null,null,{"$f":"W7+X7+Y7+Z7+AA7","v":0},null,null,null,null,null,{"$f":"AC7+AD7","v":0},null,null,null,null,null,null,null,null,{"$f":"H7+M7+N7+R7+S7+U7+V7+AB7+AE7+AF7+AG7+AH7+AI7+AJ7+C7","v":0}]
["+","Import",null,null,null,null,null,0,null,null,null,null,null,{"$f":"O8+P8+Q8","v":0},null,null,null,null,null,null,null,{"$f":"W8+X8+Y8+Z8+AA8","v":0},null,null,null,null,null,{"$f":"AC8+AD8","v":0},null,null,null,null,null,null,null,null,{"$f":"H8+M8+N8+R8+S8+U8+V8+AB8+AE8+AF8+AG8+AH8+AI8+AJ8+C8","v":0}]
["-","Export",null,null,null,null,null,0,null,null,null,null,null,0,null,null,null,null,null,null,null,0,null,null,null,null,null,0,null,null,null,null,null,null,null,null,{"$f":"H9+M9+N9+R9+S9+U9+V9+AB9+AE9+AF9+AG9+AH9+AI9+AJ9+C9","v":0}]
["-","Internationale bunkers",null,null,null,null,null,0,null,null,null,null,null,0,null,null,null,null,null,null,null,0,null,null,null,null,null,0,null,null,null,null,null,null,null,null,{"$f":"H10+M10+N10+R10+S10+U10+V10+AB10+AE10+AF10+AG10+AH10+AI10+AJ10+C10","v":0}]
["-","Refinery intake",null,null,null,null,null,0,null,null,null,null,null,0,null,null,null,null,null,null,null,0,null,null,null,null,null,0,null,null,null,null,null,null,null,null,{"$f":"H11+M11+N11+R11+S11+U11+V11+AB11+AE11+AF11+AG11+AH11+AI11+AJ11+C11+G11","v":0}]
["-","Refinery Fuel",null,null,null,null,null,0,null,null,null,null,null,0,null,null,null,null,null,null,null,0,null,null,null,null,null,0,null,null,null,null,null,null,null,null,{"$f":"H12+M12+N12+R12+S12+U12+V12+AB12+AE12+AF12+AG12+AH12+AI12+AJ12+C12+G12","v":0}]
["+","Productie",null,null,null,null,null,0,null,null,null,null,null,0,null,null,null,null,null,null,null,0,null,null,null,null,null,0,null,null,null,null,null,null,null,null,{"$f":"H13+M13+N13+R13+S13+U13+V13+AB13+AE13+AF13+AG13+AH13+AI13+AJ13+C13+G13","v":0}]
["+","Ontvangsten vrij verkeer",null,null,null,null,null,0,null,null,null,null,null,0,null,null,null,null,null,null,null,0,null,null,null,null,null,0,null,null,null,null,null,null,null,null,{"$f":"H14+M14+N14+R14+S14+U14+V14+AB14+AE14+AF14+AG14+AH14+AI14+AJ14+C14","v":0}]
["-","Leveringen vrij verkeer",null,null,null,null,null,0,null,null,null,null,null,0,null,null,null,null,null,null,null,0,null,null,null,null,null,0,null,null,null,null,null,null,null,null,{"$f":"H15+M15+N15+R15+S15+U15+V15+AB15+AE15+AF15+AG15+AH15+AI15+AJ15+C15","v":0}]
["+","Productoverdracht",null,null,null,null,null,0,null,null,null,null,null,0,null,null,null,null,null,null,null,0,null,null,null,null,null,0,null,null,null,null,null,null,null,null,{"$f":"H16+M16+N16+R16+S16+U16+V16+AB16+AE16+AF16+AG16+AH16+AI16+AJ16+C16","v":0}]
["+","Overdracht additieven",{"$f":"F17+E17+D17","v":0},null,null,null,null,0,null,null,null,null,null,0,null,null,null,null,null,null,null,0,null,null,null,null,null,0,null,null,null,null,null,null,null,null,{"$f":"H17+M17+N17+R17+S17+U17+V17+AB17+AE17+AF17+AG17+AH17+AI17+AJ17+C17","v":0}]
["-","Eindvoorraad",null,null,null,null,null,0,null,null,null,null,null,0,null,null,null,null,null,null,null,0,null,null,null,null,null,0,null,null,null,null,null,null,null,null,{"$f":"H18+M18+N18+R18+S18+U18+V18+AB18+AE18+AF18+AG18+AH18+AI18+AJ18+C18","v":0}]
["=","Berekende inverbruikstelling",null,null,null,null,{"$f":"G7+G8-G9-G10-G11-G12+G13+G14-G15+G16+G17-G18","v":0},0,{"$f":"I7+I8-I9-I10-I11-I12+I13+I14-I15+I16+I17-I18","v":0},{"$f":"J7+J8-J9-J10-J11-J12+J13+J14-J15+J16+J17-J18","v":0},0,0,0,0,0,{"$f":"P7+P8-P9-P10-P11-P12+P13+P14-P15+P16+P17-P18","v":0},0,0,{"$f":"S7+S8-S9-S10-S11-S12+S13+S14-S15+S16+S17-S18","v":0},null,0,0,0,0,{"$f":"Y7+Y8-Y9-Y10-Y11-Y12+Y13+Y14-Y15+Y16+Y17-Y18","v":0},0,0,0,0,0,0,0,0,0,0,0,{"$f":"AK7+AK8-AK9-AK10-AK11-AK12+AK13+AK14-AK15+AK16+AK17-AK18-C17","v":0}]
["-","Statistical difference",null,null,null,null,{"$f":"G19-G21","v":0},0,0,0,0,0,0,0,0,0,0,0,0,null,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0]
["=","Geobserveerde inverbruikstelling",null,null,null,null,null,{"$f":"I21+J21+K21+L21","v":0},null,null,null,null,null,{"$f":"O21+P21+Q21","v":0},null,null,null,null,null,null,null,{"$f":"W21+X21+Y21+Z21+AA21","v":0},null,null,null,null,null,{"$f":"AC21+AD21","v":0},null,null,null,null,null,null,null,null,{"$f":"H21+M21+N21+R21+S21+U21+V21+AB21+AE21+AF21+AG21+AH21+AI21+AJ21+C21","v":0}]
[null,null,{"$f":"IF(Labels!$B$2=\"NL\",IF(MIN(C7:C15,C18,C21)<0,\"Negatief cijfer\",\"\"),IF(MIN(C7:C15,C18,C21)<0,\"Chiffre négative\",\"\"))","v":""},{"$f":"IF(Labels!$B$2=\"NL\",IF(MIN(D7:D15,D18,D21)<0,\"Negatief cijfer\",\"\"),IF(MIN(D7:D15,D18,D21)<0,\"Chiffre négative\",\"\"))","v":""},{"$f":"IF(Labels!$B$2=\"NL\",IF(MIN(E7:E15,E18,E21)<0,\"Negatief cijfer\",\"\"),IF(MIN(E7:E15,E18,E21)<0,\"Chiffre négative\",\"\"))","v":""},{"$f":"IF(Labels!$B$2=\"NL\",IF(MIN(F7:F15,F18,F21)<0,\"Negatief cijfer\",\"\"),IF(MIN(F7:F15,F18,F21)<0,\"Chiffre négative\",\"\"))","v":""},{"$f":"IF(Labels!$B$2=\"NL\",IF(MIN(G7:G15,G18,G21)<0,\"Negatief cijfer\",\"\"),IF(MIN(G7:G15,G18,G21)<0,\"Chiffre négative\",\"\"))","v":""},{"$f":"IF(Labels!$B$2=\"NL\",IF(MIN(H7:H15,H18,H21)<0,\"Negatief cijfer\",\"\"),IF(MIN(H7:H15,H18,H21)<0,\"Chiffre négative\",\"\"))","v":""},{"$f":"IF(Labels!$B$2=\"NL\",IF(MIN(I7:I15,I18,I21)<0,\"Negatief cijfer\",\"\"),IF(MIN(I7:I15,I18,I21)<0,\"Chiffre négative\",\"\"))","v":""},{"$f":"IF(Labels!$B$2=\"NL\",IF(MIN(J7:J15,J18,J21)<0,\"Negatief cijfer\",\"\"),IF(MIN(J7:J15,J18,J21)<0,\"Chiffre négative\",\"\"))","v":""},{"$f":"IF(Labels!$B$2=\"NL\",IF(MIN(K7:K15,K18,K21)<0,\"Negatief cijfer\",\"\"),IF(MIN(K7:K15,K18,K21)<0,\"Chiffre négative\",\"\"))","v":""},{"$f":"IF(Labels!$B$2=\"NL\",IF(MIN(L7:L15,L18,L21)<0,\"Negatief cijfer\",\"\"),IF(MIN(L7:L15,L18,L21)<0,\"Chiffre négative\",\"\"))","v":""},{"$f":"IF(Labels!$B$2=\"NL\",IF(MIN(M7:M15,M18,M21)<0,\"Negatief cijfer\",\"\"),IF(MIN(M7:M15,M18,M21)<0,\"Chiffre négative\",\"\"))","v":""},{"$f":"IF(Labels!$B$2=\"NL\",IF(MIN(N7:N15,N18,N21)<0,\"Negatief cijfer\",\"\"),IF(MIN(N7:N15,N18,N21)<0,\"Chiffre négative\",\"\"))","v":""},{"$f":"IF(Labels!$B$2=\"NL\",IF(MIN(O7:O15,O18,O21)<0,\"Negatief cijfer\",\"\"),IF(MIN(O7:O15,O18,O21)<0,\"Chiffre négative\",\"\"))","v":""},{"$f":"IF(Labels!$B$2=\"NL\",IF(MIN(P7:P15,P18,P21)<0,\"Negatief cijfer\",\"\"),IF(MIN(P7:P15,P18,P21)<0,\"Chiffre négative\",\"\"))","v":""},{"$f":"IF(Labels!$B$2=\"NL\",IF(MIN(Q7:Q15,Q18,Q21)<0,\"Negatief cijfer\",\"\"),IF(MIN(Q7:Q15,Q18,Q21)<0,\"Chiffre négative\",\"\"))","v":""},{"$f":"IF(Labels!$B$2=\"NL\",IF(MIN(R7:R15,R18,R21)<0,\"Negatief cijfer\",\"\"),IF(MIN(R7:R15,R18,R21)<0,\"Chiffre négative\",\"\"))","v":""},{"$f":"IF(Labels!$B$2=\"NL\",IF(MIN(S7:S15,S18,S21)<0,\"Negatief cijfer\",\"\"),IF(MIN(S7:S15,S18,S21)<0,\"Chiffre négative\",\"\"))","v":""},{"$f":"IF(Labels!$B$2=\"NL\",IF(MIN(T7:T15,T18,T21)<0,\"Negatief cijfer\",\"\"),IF(MIN(T7:T15,T18,T21)<0,\"Chiffre négative\",\"\"))","v":""},{"$f":"IF(Labels!$B$2=\"NL\",IF(MIN(U7:U15,U18,U21)<0,\"Negatief cijfer\",\"\"),IF(MIN(U7:U15,U18,U21)<0,\"Chiffre négative\",\"\"))","v":""},{"$f":"IF(Labels!$B$2=\"NL\",IF(MIN(V7:V15,V18,V21)<0,\"Negatief cijfer\",\"\"),IF(MIN(V7:V15,V18,V21)<0,\"Chiffre négative\",\"\"))","v":""},{"$f":"IF(Labels!$B$2=\"NL\",IF(MIN(W7:W15,W18,W21)<0,\"Negatief cijfer\",\"\"),IF(MIN(W7:W15,W18,W21)<0,\"Chiffre négative\",\"\"))","v":""},{"$f":"IF(Labels!$B$2=\"NL\",IF(MIN(X7:X15,X18,X21)<0,\"Negatief cijfer\",\"\"),IF(MIN(X7:X15,X18,X21)<0,\"Chiffre négative\",\"\"))","v":""},{"$f":"IF(Labels!$B$2=\"NL\",IF(MIN(Y7:Y15,Y18,Y21)<0,\"Negatief cijfer\",\"\"),IF(MIN(Y7:Y15,Y18,Y21)<0,\"Chiffre négative\",\"\"))","v":""},{"$f":"IF(Labels!$B$2=\"NL\",IF(MIN(Z7:Z15,Z18,Z21)<0,\"Negatief cijfer\",\"\"),IF(MIN(Z7:Z15,Z18,Z21)<0,\"Chiffre négative\",\"\"))","v":""},{"$f":"IF(Labels!$B$2=\"NL\",IF(MIN(AA7:AA15,AA18,AA21)<0,\"Negatief cijfer\",\"\"),IF(MIN(AA7:AA15,AA18,AA21)<0,\"Chiffre négative\",\"\"))","v":""},{"$f":"IF(Labels!$B$2=\"NL\",IF(MIN(AB7:AB15,AB18,AB21)<0,\"Negatief cijfer\",\"\"),IF(MIN(AB7:AB15,AB18,AB21)<0,\"Chiffre négative\",\"\"))","v":""},{"$f":"IF(Labels!$B$2=\"NL\",IF(MIN(AC7:AC15,AC18,AC21)<0,\"Negatief cijfer\",\"\"),IF(MIN(AC7:AC15,AC18,AC21)<0,\"Chiffre négative\",\"\"))","v":""},{"$f":"IF(Labels!$B$2=\"NL\",IF(MIN(AD7:AD15,AD18,AD21)<0,\"Negatief cijfer\",\"\"),IF(MIN(AD7:AD15,AD18,AD21)<0,\"Chiffre négative\",\"\"))","v":""},{"$f":"IF(Labels!$B$2=\"NL\",IF(MIN(AE7:AE15,AE18,AE21)<0,\"Negatief cijfer\",\"\"),IF(MIN(AE7:AE15,AE18,AE21)<0,\"Chiffre négative\",\"\"))","v":""},{"$f":"IF(Labels!$B$2=\"NL\",IF(MIN(AF7:AF15,AF18,AF21)<0,\"Negatief cijfer\",\"\"),IF(MIN(AF7:AF15,AF18,AF21)<0,\"Chiffre négative\",\"\"))","v":""},{"$f":"IF(Labels!$B$2=\"NL\",IF(MIN(AG7:AG15,AG18,AG21)<0,\"Negatief cijfer\",\"\"),IF(MIN(AG7:AG15,AG18,AG21)<0,\"Chiffre négative\",\"\"))","v":""},{"$f":"IF(Labels!$B$2=\"NL\",IF(MIN(AH7:AH15,AH18,AH21)<0,\"Negatief cijfer\",\"\"),IF(MIN(AH7:AH15,AH18,AH21)<0,\"Chiffre négative\",\"\"))","v":""},{"$f":"IF(Labels!$B$2=\"NL\",IF(MIN(AI7:AI15,AI18,AI21)<0,\"Negatief cijfer\",\"\"),IF(MIN(AI7:AI15,AI18,AI21)<0,\"Chiffre négative\",\"\"))","v":""},{"$f":"IF(Labels!$B$2=\"NL\",IF(MIN(AJ7:AJ15,AJ18,AJ21)<0,\"Negatief cijfer\",\"\"),IF(MIN(AJ7:AJ15,AJ18,AJ21)<0,\"Chiffre négative\",\"\"))","v":""},{"$f":"IF(Labels!$B$2=\"NL\",IF(MIN(AK7:AK15,AK18,AK21)<0,\"Negatief cijfer\",\"\"),IF(MIN(AK7:AK15,AK18,AK21)<0,\"Chiffre négative\",\"\"))","v":""}]
[null,null,null,null,null,null,null,null,null,null,null,null,"Inverbruikstelling :",null,{"$f":"O21","v":0},{"$f":"P21","v":0},null,null,{"$f":"IF(Labels!$B$2=\"NL\",IF(OR(T8>S8,T9>S9,T14>S14,T15>S15),\"Transport via CEPS moet kleiner zijn dan totaal transport\",\"\"),IF(OR(T8>S8,T9>S9,T14>S14,T15>S15),\"Transport par CEPS doit être plus petit que transport total\",\"\"))","v":""},null,"Inverbruikstelling :",null,{"$f":"W21","v":0}]
[null,null,null,null,null,null,null,null,null,null,null,null,"waarvan bio-ethanol :",null,null,null,null,null,null,null,"waarvan biodiesel :"]
[1,"Totaal Import (AK8) komt overeen met Totaal Import van deze producten in Table 3 (AM111)",null,null,{"$f":"ABS(AK8-'Table 3'!AM111)","v":0},{"$f":"IF(Labels!$B$2=\"NL\",IF(OR(AK8<>0, 'Table 3'!AM111<>0),IF(E25<=(0.001*(AK8+'Table 3'!AM111)/2),\"OK\",\"Totaal Import in Table 2 ≠  Totaal Import in Table 3\"),\"OK\"),IF(OR(AK8<>0, 'Table 3'!AM111<>0),IF(E25<=(0.001*(AK8+'Table 3'!AM111)/2),\"OK\",\"Total Importations en Table 2 ≠ Total Importations en Table 3\"),\"OK\"))","v":"OK"}]
[2,"Totaal Export (AK9) komt overeen met Totaal Export van deze producten in Table 4 (AM102)",null,null,{"$f":"ABS(AK9-'Table 4'!AM102)","v":0},{"$f":"IF(Labels!$B$2=\"NL\",IF(OR(AK9<>0, 'Table 4'!AM102<>0),IF(E26<=(0.001*(AK9+'Table 4'!AM102)/2),\"OK\",\"Totaal Export in Table 2 ≠ Totaal Export in Table 4\"),\"OK\"),IF(OR(AK9<>0, 'Table 4'!AM102<>0),IF(E26<=(0.001*(AK9+'Table 4'!AM102)/2),\"OK\",\"Total Exportations en Table 2 ≠ Total Exportations en Table 4\"),\"OK\"))","v":"OK"}]
[3,"Totaal van Productoverdracht is gelijk aan 0",null,null,{"$f":"'Table 1'!F18+'Table 2'!AK16","v":0},{"$f":"IF(Labels!$B$2=\"NL\",IF(ABS(E27)<=0.001*(MAX(C16:AK16)-MIN(C16:AK16))/2,\"OK\",\"Productoverdracht ≠ 0\"),IF(ABS(E27)<=0.001*(MAX(C16:AK16)-MIN(C16:AK16))/2,\"OK\",\"Transfert de produits ≠ 0\"))","v":"OK"}]
[4,"Totaal van Overdracht Additieven is gelijk aan 0",null,null,{"$f":"AK17","v":0},{"$f":"IF(Labels!$B$2=\"NL\",IF(ABS(E28)<=0.001*ABS(C17),\"OK\",\"Overdracht van additieven ≠  0\"),IF(ABS(E28)<=0.001*ABS(C17),\"OK\",\"Transfert d'additifs ≠ 0\"))","v":"OK"}]

{"sheet":"Table 3","index":4,"n_rows":115,"n_cols":40,"rows_kept":115,"cut":false,"hidden":true,"merged":[[4,37,5,37],[4,38,5,38],[4,39,5,39],[4,29,5,29],[4,32,5,32],[4,33,5,33],[4,34,5,34],[4,35,5,35],[4,36,5,36],[4,23,5,23],[4,1,5,1],[4,2,5,2],[4,3,5,3],[4,4,5,4],[4,5,5,5],[4,9,5,9],[4,14,5,14],[4,15,5,15],[4,19,5,19],[4,20,5,20],[4,22,5,22]]}
[]
[{"$f":"IF('Table 1'!C3=0,\"\",'Table 1'!C3)","v":"Naam/Nom"}]
[{"$f":"IF('Table 1'!C4=0,\"\",'Table 1'!C4 & \" \" &'Table 1'!D4)","v":"01 2018"}]
["Table 3: IMPORT PER LAND"]
[null,"Ruwe olie","Condensaten van aardgas","Intermediaire producten","Totaal Ruwe Producten","Additieven /  Mengcomponent",null,null,null,"Totaal LPG",null,null,null,null,"Nafta","Totaal motor benzine",null,null,null,"Vliegtuig- benzine","Totaal\nkerosine\ntype\njet fuel",null,"Lamp-petroleum","Totaal\ngas/diesel\nolie",null,null,null,null,null,"Zware residuele stookolie",null,null,"White spirit en Speciale benzine","Smeer-middelen","Bitumen","Paraffine","Petroleum coke","Andere olieproducten","Totaal Producten","Totaal\nOlie"]
[null,null,null,null,null,null,"Klassiek","Bio-ethanol","Biodiesel",null,"Butaan","Propaan","Gemengd (LPG)","Andere LPG",null,null,"Benzine 98 RON 10S","Benzine 95 RON 10S","Andere benzine",null,null,"waarvan via CEPS pijplijn",null,null,"Gasolie Diesel 10S","Gasolie verwarming","Gasolie verwarming Extra","Gasolie Rijn en binnenvaart","Andere Gasolie",null,"Laag zwavel\n(<1%)","Hoog zwavel\n (>=1%)"]
["Algeria",null,null,null,{"$f":"SUM(B7:D7)","v":0},null,null,null,null,{"$f":"K7+L7+M7+N7","v":0},null,null,null,null,null,{"$f":"Q7+S7+R7","v":0},null,null,null,null,null,null,null,{"$f":"Y7+Z7+AA7+AB7+AC7","v":0},null,null,null,null,null,{"$f":"AE7+AF7","v":0},null,null,null,null,null,null,null,null,{"$f":"AL7+AK7+AJ7+AI7+AH7+AG7+AD7+X7+W7+U7+T7+P7+O7+J7+F7","v":0},{"$f":"AM7+E7","v":0}]
["Angola",null,null,null,{"$f":"SUM(B8:D8)","v":0},null,null,null,null,{"$f":"K8+L8+M8+N8","v":0},null,null,null,null,null,{"$f":"Q8+S8+R8","v":0},null,null,null,null,null,null,null,{"$f":"Y8+Z8+AA8+AB8+AC8","v":0},null,null,null,null,null,{"$f":"AE8+AF8","v":0},null,null,null,null,null,null,null,null,0,0]
["Argentina",null,null,null,0,null,null,null,null,0,null,null,null,null,null,0,null,null,null,null,null,null,null,0,null,null,null,null,null,0,null,null,null,null,null,null,null,null,0,0]
["Armenia",null,null,null,0,null,null,null,null,0,null,null,null,null,null,0,null,null,null,null,null,null,null,0,null,null,null,null,null,0,null,null,null,null,null,null,null,null,0,0]
["Australia",null,null,null,0,null,null,null,null,0,null,null,null,null,null,0,null,null,null,null,null,null,null,0,null,null,null,null,null,0,null,null,null,null,null,null,null,null,0,0]
["Austria",null,null,null,0,null,null,null,null,0,null,null,null,null,null,0,null,null,null,null,null,null,null,0,null,null,null,null,null,0,null,null,null,null,null,null,null,null,0,0]
["Azerbaijan",null,null,null,0,null,null,null,null,0,null,null,null,null,null,0,null,null,null,null,null,null,null,0,null,null,null,null,null,0,null,null,null,null,null,null,null,null,0,0]
["Bahamas",null,null,null,0,null,null,null,null,0,null,null,null,null,null,0,null,null,null,null,null,null,null,0,null,null,null,null,null,0,null,null,null,null,null,null,null,null,0,0]
["Bahrain",null,null,null,0,null,null,null,null,0,null,null,null,null,null,0,null,null,null,null,null,null,null,0,null,null,null,null,null,0,null,null,null,null,null,null,null,null,0,0]
["Belarus",null,null,null,0,null,null,null,null,0,null,null,null,null,null,0,null,null,null,null,null,null,null,0,null,null,null,null,null,0,null,null,null,null,null,null,null,null,0,0]
["Belgium",null,null,null,0,null,null,null,null,0,null,null,null,null,null,0,null,null,null,null,null,null,null,0,null,null,null,null,null,0,null,null,null,null,null,null,null,null,0,0]
["Bosnia and Herzegovina",null,null,null,0,null,null,null,null,0,null,null,null,null,null,0,null,null,null,null,null,null,null,0,null,null,null,null,null,0,null,null,null,null,null,null,null,null,0,0]
["Brazil",null,null,null,0,null,null,null,null,0,null,null,null,null,null,0,null,null,null,null,null,null,null,0,null,null,null,null,null,0,null,null,null,null,null,null,null,null,0,0]
["Brunei Darussalam",null,null,null,0,null,null,null,null,0,null,null,null,null,null,0,null,null,null,null,null,null,null,0,null,null,null,null,null,0,null,null,null,null,null,null,null,null,0,0]
["Bulgaria",null,null,null,0,null,null,null,null,0,null,null,null,null,null,0,null,null,null,null,null,null,null,0,null,null,null,null,null,0,null,null,null,null,null,null,null,null,0,0]
["Cameroon",null,null,null,0,null,null,null,null,0,null,null,null,null,null,0,null,null,null,null,null,null,null,0,null,null,null,null,null,0,null,null,null,null,null,null,null,null,0,0]
["Canada",null,null,null,0,null,null,null,null,0,null,null,null,null,null,0,null,null,null,null,null,null,null,0,null,null,null,null,null,0,null,null,null,null,null,null,null,null,0,0]
["Chile",null,null,null,0,null,null,null,null,0,null,null,null,null,null,0,null,null,null,null,null,null,null,0,null,null,null,null,null,0,null,null,null,null,null,null,null,null,0,0]
["China, People's Republic",null,null,null,0,null,null,null,null,0,null,null,null,null,null,0,null,null,null,null,null,null,null,0,null,null,null,null,null,0,null,null,null,null,null,null,null,null,0,0]
["Colombia",null,null,null,0,null,null,null,null,0,null,null,null,null,null,0,null,null,null,null,null,null,null,0,null,null,null,null,null,0,null,null,null,null,null,null,null,null,0,0]
["Congo",null,null,null,0,null,null,null,null,0,null,null,null,null,null,0,null,null,null,null,null,null,null,0,null,null,null,null,null,0,null,null,null,null,null,null,null,null,0,0]
["Congo, Democratic Republic",null,null,null,0,null,null,null,null,0,null,null,null,null,null,0,null,null,null,null,null,null,null,0,null,null,null,null,null,0,null,null,null,null,null,null,null,null,0,0]
["Croatia",null,null,null,0,null,null,null,null,0,null,null,null,null,null,0,null,null,null,null,null,null,null,0,null,null,null,null,null,0,null,null,null,null,null,null,null,null,0,0]
["Cyprus",null,null,null,0,null,null,null,null,0,null,null,null,null,null,0,null,null,null,null,null,null,null,0,null,null,null,null,null,0,null,null,null,null,null,null,null,null,0,0]
["Czech Republic",null,null,null,0,null,null,null,null,0,null,null,null,null,null,0,null,null,null,null,null,null,null,0,null,null,null,null,null,0,null,null,null,null,null,null,null,null,0,0]
["Denmark",null,null,null,0,null,null,null,null,0,null,null,null,null,null,0,null,null,null,null,null,null,null,0,null,null,null,null,null,0,null,null,null,null,null,null,null,null,0,0]
["Ecuador",null,null,null,0,null,null,null,null,0,null,null,null,null,null,0,null,null,null,null,null,null,null,0,null,null,null,null,null,0,null,null,null,null,null,null,null,null,0,0]
["Egypt",null,null,null,0,null,null,null,null,0,null,null,null,null,null,0,null,null,null,null,null,null,null,0,null,null,null,null,null,0,null,null,null,null,null,null,null,null,0,0]
["Equatorial Guinea",null,null,null,0,null,null,null,null,0,null,null,null,null,null,0,null,null,null,null,null,null,null,0,null,null,null,null,null,0,null,null,null,null,null,null,null,null,0,0]
["Estonia",null,null,null,0,null,null,null,null,0,null,null,null,null,null,0,null,null,null,null,null,null,null,0,null,null,null,null,null,0,null,null,null,null,null,null,null,null,0,0]
["Finland",null,null,null,0,null,null,null,null,0,null,null,null,null,null,0,null,null,null,null,null,null,null,0,null,null,null,null,null,0,null,null,null,null,null,null,null,null,0,0]
["France",null,null,null,0,null,null,null,null,0,null,null,null,null,null,0,null,null,null,null,null,null,null,0,null,null,null,null,null,0,null,null,null,null,null,null,null,null,0,0]
["Gabon",null,null,null,0,null,null,null,null,0,null,null,null,null,null,0,null,null,null,null,null,null,null,0,null,null,null,null,null,0,null,null,null,null,null,null,null,null,0,0]
["Georgia",null,null,null,0,null,null,null,null,0,null,null,null,null,null,0,null,null,null,null,null,null,null,0,null,null,null,null,null,0,null,null,null,null,null,null,null,null,0,0]
["Germany",null,null,null,0,null,null,null,null,0,null,null,null,null,null,0,null,null,null,null,null,null,null,0,null,null,null,null,null,0,null,null,null,null,null,null,null,null,0,0]
["Greece",null,null,null,0,null,null,null,null,0,null,null,null,null,null,0,null,null,null,null,null,null,null,0,null,null,null,null,null,0,null,null,null,null,null,null,null,null,0,0]
["Hong Kong (China)",null,null,null,0,null,null,null,null,0,null,null,null,null,null,0,null,null,null,null,null,null,null,0,null,null,null,null,null,0,null,null,null,null,null,null,null,null,0,0]
["Hungary",null,null,null,0,null,null,null,null,0,null,null,null,null,null,0,null,null,null,null,null,null,null,0,null,null,null,null,null,0,null,null,null,null,null,null,null,null,0,0]
["Iceland",null,null,null,0,null,null,null,null,0,null,null,null,null,null,0,null,null,null,null,null,null,null,0,null,null,null,null,null,0,null,null,null,null,null,null,null,null,0,0]
["India",null,null,null,0,null,null,null,null,0,null,null,null,null,null,0,null,null,null,null,null,null,null,0,null,null,null,null,null,0,null,null,null,null,null,null,null,null,0,0]
["Indonesia",null,null,null,0,null,null,null,null,0,null,null,null,null,null,0,null,null,null,null,null,null,null,0,null,null,null,null,null,0,null,null,null,null,null,null,null,null,0,0]
["Iran, Islamic Republic",null,null,null,0,null,null,null,null,0,null,null,null,null,null,0,null,null,null,null,null,null,null,0,null,null,null,null,null,0,null,null,null,null,null,null,null,null,0,0]
["Iraq",null,null,null,0,null,null,null,null,0,null,null,null,null,null,0,null,null,null,null,null,null,null,0,null,null,null,null,null,0,null,null,null,null,null,null,null,null,0,0]
["Ireland",null,null,null,0,null,null,null,null,0,null,null,null,null,null,0,null,null,null,null,null,null,null,0,null,null,null,null,null,0,null,null,null,null,null,null,null,null,0,0]
["Israel",null,null,null,0,null,null,null,null,0,null,null,null,null,null,0,null,null,null,null,null,null,null,0,null,null,null,null,null,0,null,null,null,null,null,null,null,null,0,0]
["Italy",null,null,null,0,null,null,null,null,0,null,null,null,null,null,0,null,null,null,null,null,null,null,0,null,null,null,null,null,0,null,null,null,null,null,null,null,null,0,0]
["Japan",null,null,null,0,null,null,null,null,0,null,null,null,null,null,0,null,null,null,null,null,null,null,0,null,null,null,null,null,0,null,null,null,null,null,null,null,null,0,0]
["Kazakhstan",null,null,null,0,null,null,null,null,0,null,null,null,null,null,0,null,null,null,null,null,null,null,0,null,null,null,null,null,0,null,null,null,null,null,null,null,null,0,0]
["Korea",null,null,null,0,null,null,null,null,0,null,null,null,null,null,0,null,null,null,null,null,null,null,0,null,null,null,null,null,0,null,null,null,null,null,null,null,null,0,0]
["Kuwait",null,null,null,0,null,null,null,null,0,null,null,null,null,null,0,null,null,null,null,null,null,null,0,null,null,null,null,null,0,null,null,null,null,null,null,null,null,0,0]
["Kyrgyzstan",null,null,null,0,null,null,null,null,0,null,null,null,null,null,0,null,null,null,null,null,null,null,0,null,null,null,null,null,0,null,null,null,null,null,null,null,null,0,0]
["Latvia",null,null,null,0,null,null,null,null,0,null,null,null,null,null,0,null,null,null,null,null,null,null,0,null,null,null,null,null,0,null,null,null,null,null,null,null,null,0,0]
["Libya",null,null,null,0,null,null,null,null,0,null,null,null,null,null,0,null,null,null,null,null,null,null,0,null,null,null,null,null,0,null,null,null,null,null,null,null,null,0,0]
["Lithuania",null,null,null,0,null,null,null,null,0,null,null,null,null,null,0,null,null,null,null,null,null,null,0,null,null,null,null,null,0,null,null,null,null,null,null,null,null,0,0]
["Luxembourg",null,null,null,0,null,null,null,null,0,null,null,null,null,null,0,null,null,null,null,null,null,null,0,null,null,null,null,null,0,null,null,null,null,null,null,null,null,0,0]
["Macedonia, Former Yugoslav Republic",null,null,null,0,null,null,null,null,0,null,null,null,null,null,0,null,null,null,null,null,null,null,0,null,null,null,null,null,0,null,null,null,null,null,null,null,null,0,0]
["Malaysia",null,null,null,0,null,null,null,null,0,null,null,null,null,null,0,null,null,null,null,null,null,null,0,null,null,null,null,null,0,null,null,null,null,null,null,null,null,0,0]
["Malta",null,null,null,0,null,null,null,null,0,null,null,null,null,null,0,null,null,null,null,null,null,null,0,null,null,null,null,null,0,null,null,null,null,null,null,null,null,0,0]
["Mexico",null,null,null,0,null,null,null,null,0,null,null,null,null,null,0,null,null,null,null,null,null,null,0,null,null,null,null,null,0,null,null,null,null,null,null,null,null,0,0]
["Moldova, Republic",null,null,null,0,null,null,null,null,0,null,null,null,null,null,0,null,null,null,null,null,null,null,0,null,null,null,null,null,0,null,null,null,null,null,null,null,null,0,0]
["Montenegro",null,null,null,0,null,null,null,null,0,null,null,null,null,null,0,null,null,null,null,null,null,null,0,null,null,null,null,null,0,null,null,null,null,null,null,null,null,0,0]
["Netherlands",null,null,null,0,null,null,null,null,0,null,null,null,null,null,0,null,null,null,null,null,null,null,0,null,null,null,null,null,0,null,null,null,null,null,null,null,null,0,0]
["Netherlands Antilles",null,null,null,0,null,null,null,null,0,null,null,null,null,null,0,null,null,null,null,null,null,null,0,null,null,null,null,null,0,null,null,null,null,null,null,null,null,0,0]
["New Zealand",null,null,null,0,null,null,null,null,0,null,null,null,null,null,0,null,null,null,null,null,null,null,0,null,null,null,null,null,0,null,null,null,null,null,null,null,null,0,0]
["Nigeria",null,null,null,0,null,null,null,null,0,null,null,null,null,null,0,null,null,null,null,null,null,null,0,null,null,null,null,null,0,null,null,null,null,null,null,null,null,{"$f":"AL71+AK71+AJ71+AI71+AH71+AG71+AD71+X71+W71+U71+T71+P71+O71+J71+F71","v":0},{"$f":"AM71+E71","v":0}]
["Norway",null,null,null,{"$f":"SUM(B72:D72)","v":0},null,null,null,null,{"$f":"K72+L72+M72+N72","v":0},null,null,null,null,null,{"$f":"Q72+S72+R72","v":0},null,null,null,null,null,null,null,{"$f":"Y72+Z72+AA72+AB72+AC72","v":0},null,null,null,null,null,{"$f":"AE72+AF72","v":0},null,null,null,null,null,null,null,null,0,0]
["Oman",null,null,null,0,null,null,null,null,0,null,null,null,null,null,0,null,null,null,null,null,null,null,0,null,null,null,null,null,0,null,null,null,null,null,null,null,null,0,0]
["Other Africa",null,null,null,0,null,null,null,null,0,null,null,null,null,null,0,null,null,null,null,null,null,null,0,null,null,null,null,null,0,null,null,null,null,null,null,null,null,0,0]
["Other Asia and Pacific",null,null,null,0,null,null,null,null,0,null,null,null,null,null,0,null,null,null,null,null,null,null,0,null,null,null,null,null,0,null,null,null,null,null,null,null,null,0,0]
["Other Europe",null,null,null,0,null,null,null,null,0,null,null,null,null,null,0,null,null,null,null,null,null,null,0,null,null,null,null,null,0,null,null,null,null,null,null,null,null,0,0]
["Other Former Soviet Union",null,null,null,0,null,null,null,null,0,null,null,null,null,null,0,null,null,null,null,null,null,null,0,null,null,null,null,null,0,null,null,null,null,null,null,null,null,0,0]
["Other Near and Middle East",null,null,null,0,null,null,null,null,0,null,null,null,null,null,0,null,null,null,null,null,null,null,0,null,null,null,null,null,0,null,null,null,null,null,null,null,null,0,0]
["Other non-OECD Americas",null,null,null,0,null,null,null,null,0,null,null,null,null,null,0,null,null,null,null,null,null,null,0,null,null,null,null,null,0,null,null,null,null,null,null,null,null,0,0]
["Papua New Guinea",null,null,null,0,null,null,null,null,0,null,null,null,null,null,0,null,null,null,null,null,null,null,0,null,null,null,null,null,0,null,null,null,null,null,null,null,null,0,0]
["Peru",null,null,null,0,null,null,null,null,0,null,null,null,null,null,0,null,null,null,null,null,null,null,0,null,null,null,null,null,0,null,null,null,null,null,null,null,null,0,0]
["Poland",null,null,null,0,null,null,null,null,0,null,null,null,null,null,0,null,null,null,null,null,null,null,0,null,null,null,null,null,0,null,null,null,null,null,null,null,null,0,0]
["Portugal",null,null,null,0,null,null,null,null,0,null,null,null,null,null,0,null,null,null,null,null,null,null,0,null,null,null,null,null,0,null,null,null,null,null,null,null,null,0,0]
["Qatar",null,null,null,0,null,null,null,null,0,null,null,null,null,null,0,null,null,null,null,null,null,null,0,null,null,null,null,null,0,null,null,null,null,null,null,null,null,0,0]
["Romania",null,null,null,0,null,null,null,null,0,null,null,null,null,null,0,null,null,null,null,null,null,null,0,null,null,null,null,null,0,null,null,null,null,null,null,null,null,0,0]
["Russian Federation",null,null,null,0,null,null,null,null,0,null,null,null,null,null,0,null,null,null,null,null,null,null,0,null,null,null,null,null,0,null,null,null,null,null,null,null,null,0,0]
["Saudi Arabia",null,null,null,0,null,null,null,null,0,null,null,null,null,null,0,null,null,null,null,null,null,null,0,null,null,null,null,null,0,null,null,null,null,null,null,null,null,0,0]
["Serbia",null,null,null,0,null,null,null,null,0,null,null,null,null,null,0,null,null,null,null,null,null,null,0,null,null,null,null,null,0,null,null,null,null,null,null,null,null,0,0]
["Singapore",null,null,null,0,null,null,null,null,0,null,null,null,null,null,0,null,null,null,null,null,null,null,0,null,null,null,null,null,0,null,null,null,null,null,null,null,null,0,0]
["Slovak Republic",null,null,null,0,null,null,null,null,0,null,null,null,null,null,0,null,null,null,null,null,null,null,0,null,null,null,null,null,0,null,null,null,null,null,null,null,null,0,0]
["Slovenia",null,null,null,0,null,null,null,null,0,null,null,null,null,null,0,null,null,null,null,null,null,null,0,null,null,null,null,null,0,null,null,null,null,null,null,null,null,0,0]
["Spain",null,null,null,0,null,null,null,null,0,null,null,null,null,null,0,null,null,null,null,null,null,null,0,null,null,null,null,null,0,null,null,null,null,null,null,null,null,0,0]
["Sweden",null,null,null,0,null,null,null,null,0,null,null,null,null,null,0,null,null,null,null,null,null,null,0,null,null,null,null,null,0,null,null,null,null,null,null,null,null,0,0]
["Switzerland",null,null,null,0,null,null,null,null,0,null,null,null,null,null,0,null,null,null,null,null,null,null,0,null,null,null,null,null,0,null,null,null,null,null,null,null,null,0,0]
["Syrian Arab Republic",null,null,null,0,null,null,null,null,0,null,null,null,null,null,0,null,null,null,null,null,null,null,0,null,null,null,null,null,0,null,null,null,null,null,null,null,null,0,0]
["Tajikistan",null,null,null,0,null,null,null,null,0,null,null,null,null,null,0,null,null,null,null,null,null,null,0,null,null,null,null,null,0,null,null,null,null,null,null,null,null,0,0]
["Thailand",null,null,null,0,null,null,null,null,0,null,null,null,null,null,0,null,null,null,null,null,null,null,0,null,null,null,null,null,0,null,null,null,null,null,null,null,null,0,0]
["Trinidad and Tobago",null,null,null,0,null,null,null,null,0,null,null,null,null,null,0,null,null,null,null,null,null,null,0,null,null,null,null,null,0,null,null,null,null,null,null,null,null,0,0]
["Tunisia",null,null,null,0,null,null,null,null,0,null,null,null,null,null,0,null,null,null,null,null,null,null,0,null,null,null,null,null,0,null,null,null,null,null,null,null,null,0,0]
["Turkey",null,null,null,0,null,null,null,null,0,null,null,null,null,null,0,null,null,null,null,null,null,null,0,null,null,null,null,null,0,null,null,null,null,null,null,null,null,0,0]
["Turkmenistan",null,null,null,0,null,null,null,null,0,null,null,null,null,null,0,null,null,null,null,null,null,null,0,null,null,null,null,null,0,null,null,null,null,null,null,null,null,0,0]
["Ukraine",null,null,null,0,null,null,null,null,0,null,null,null,null,null,0,null,null,null,null,null,null,null,0,null,null,null,null,null,0,null,null,null,null,null,null,null,null,0,0]
["United Arab Emirates",null,null,null,0,null,null,null,null,0,null,null,null,null,null,0,null,null,null,null,null,null,null,0,null,null,null,null,null,0,null,null,null,null,null,null,null,null,0,0]
["United Kingdom",null,null,null,0,null,null,null,null,0,null,null,null,null,null,0,null,null,null,null,null,null,null,0,null,null,null,null,null,0,null,null,null,null,null,null,null,null,0,0]
["United States",null,null,null,0,null,null,null,null,0,null,null,null,null,null,0,null,null,null,null,null,null,null,0,null,null,null,null,null,0,null,null,null,null,null,null,null,null,0,0]
["Uzbekistan",null,null,null,0,null,null,null,null,0,null,null,null,null,null,0,null,null,null,null,null,null,null,0,null,null,null,null,null,0,null,null,null,null,null,null,null,null,0,0]
["Venezuela",null,null,null,0,null,null,null,null,0,null,null,null,null,null,0,null,null,null,null,null,null,null,0,null,null,null,null,null,0,null,null,null,null,null,null,null,null,0,0]
["Vietnam",null,null,null,0,null,null,null,null,0,null,null,null,null,null,0,null,null,null,null,null,null,null,0,null,null,null,null,null,0,null,null,null,null,null,null,null,null,0,0]
["Yemen",null,null,null,0,null,null,null,null,0,null,null,null,null,null,0,null,null,null,null,null,null,null,0,null,null,null,null,null,0,null,null,null,null,null,null,null,null,0,0]
["Non-specified/Other",null,null,null,0,null,null,null,null,0,null,null,null,null,null,0,null,null,null,null,null,null,null,0,null,null,null,null,null,0,null,null,null,null,null,null,null,null,0,0]
["Totaal Import",{"$f":"SUM(B7:B110)","v":0},0,0,{"$f":"SUM(E7:E110)","v":0},0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,{"$f":"SUM(AH7:AH110)","v":0},{"$f":"SUM(AI7:AI110)","v":0},{"$f":"SUM(AJ7:AJ110)","v":0},{"$f":"SUM(AK7:AK110)","v":0},0,{"$f":"SUM(AM7:AM110)","v":0},0]
[null,{"$f":"IF(MIN(B7:B111)<0,\"Negatief cijfer\",\"\")","v":""},{"$f":"IF(MIN(C7:C111)<0,\"Negatief cijfer\",\"\")","v":""},"","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","",""]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(V111>U111,\"Transport via CEPS (V111) moet kleiner zijn dan totaal transport (U111)\",\"\")","v":""}]
["1. Totaal Import van Totaal Ruwe Producten (E111) moet gelijk zijn aan Totaal Import in Table 1 (F13)",null,null,null,null,null,null,{"$f":"'Table 1'!G25","v":"OK"}]
["    en Totaal Import van Totaal Producten (AM111) moet gelijk zijn aan Totaal Import in Table 2 (AK8)",null,null,null,null,null,null,{"$f":"'Table 2'!F25","v":"OK"}]

{"sheet":"Table 4","index":5,"n_rows":106,"n_cols":40,"rows_kept":106,"cut":false,"hidden":true,"merged":[[4,37,5,37],[4,38,5,38],[4,39,5,39],[4,29,5,29],[4,32,5,32],[4,33,5,33],[4,34,5,34],[4,35,5,35],[4,36,5,36],[4,23,5,23],[4,1,5,1],[4,2,5,2],[4,3,5,3],[4,4,5,4],[4,5,5,5],[4,9,5,9],[4,14,5,14],[4,15,5,15],[4,19,5,19],[4,20,5,20],[4,22,5,22]]}
[]
[{"$f":"IF('Table 1'!C3=0,\"\",'Table 1'!C3)","v":"Naam/Nom"}]
[{"$f":"IF('Table 1'!C4=0,\"\",'Table 1'!C4 & \" \" &'Table 1'!D4)","v":"01 2018"}]
["Table 4: EXPORT PER LAND"]
[null,"Ruwe olie","Condensaten van aardgas","Intermediaire producten","Totaal Ruwe Producten","Additieven /  Mengcomponent",null,null,null,"Totaal LPG",null,null,null,null,"Nafta","Totaal motor benzine",null,null,null,"Vliegtuig- benzine","Totaal\nkerosine\ntype\njet fuel",null,"Lamp-petroleum","Totaal\ngas/diesel\nolie",null,null,null,null,null,"Zware residuele stookolie",null,null,"White spirit en Speciale benzine","Smeer-middelen","Bitumen","Paraffine","Petroleum coke","Andere olieproducten","Totaal Producten","Totaal\nOlie"]
[null,null,null,null,null,null,"Klassiek","Bio-ethanol","Biodiesel",null,"Butaan","Propaan","Gemengd (LPG)","Andere LPG",null,null,"Benzine 98 RON 10S","Benzine 95 RON 10S","Andere benzine",null,null,"waarvan via CEPS pijplijn",null,null,"Gasolie Diesel 10S","Gasolie verwarming","Gasolie verwarming Extra","Gasolie Rijn en binnenvaart","Andere Gasolie",null,"Laag zwavel\n(<1%)","Hoog zwavel\n (>=1%)"]
["Algeria",null,null,null,{"$f":"SUM(B7:D7)","v":0},null,null,null,null,{"$f":"K7+L7+M7+N7","v":0},null,null,null,null,null,{"$f":"Q7+S7+R7","v":0},null,null,null,null,null,null,null,{"$f":"Y7+Z7+AA7+AB7+AC7","v":0},null,null,null,null,null,{"$f":"AE7+AF7","v":0},null,null,null,null,null,null,null,null,{"$f":"AL7+AK7+AJ7+AI7+AH7+AG7+AD7+X7+W7+U7+T7+P7+O7+J7+F7","v":0},{"$f":"AM7+E7","v":0}]
["Argentina",null,null,null,{"$f":"SUM(B8:D8)","v":0},null,null,null,null,{"$f":"K8+L8+M8+N8","v":0},null,null,null,null,null,{"$f":"Q8+S8+R8","v":0},null,null,null,null,null,null,null,{"$f":"Y8+Z8+AA8+AB8+AC8","v":0},null,null,null,null,null,{"$f":"AE8+AF8","v":0},null,null,null,null,null,null,null,null,0,0]
["Armenia",null,null,null,0,null,null,null,null,0,null,null,null,null,null,0,null,null,null,null,null,null,null,0,null,null,null,null,null,0,null,null,null,null,null,null,null,null,0,0]
["Australia",null,null,null,0,null,null,null,null,0,null,null,null,null,null,0,null,null,null,null,null,null,null,0,null,null,null,null,null,0,null,null,null,null,null,null,null,null,0,0]
["Austria",null,null,null,0,null,null,null,null,0,null,null,null,null,null,0,null,null,null,null,null,null,null,0,null,null,null,null,null,0,null,null,null,null,null,null,null,null,0,0]
["Azerbaijan",null,null,null,0,null,null,null,null,0,null,null,null,null,null,0,null,null,null,null,null,null,null,0,null,null,null,null,null,0,null,null,null,null,null,null,null,null,0,0]
["Belarus",null,null,null,0,null,null,null,null,0,null,null,null,null,null,0,null,null,null,null,null,null,null,0,null,null,null,null,null,0,null,null,null,null,null,null,null,null,0,0]
["Belgium",null,null,null,0,null,null,null,null,0,null,null,null,null,null,0,null,null,null,null,null,null,null,0,null,null,null,null,null,0,null,null,null,null,null,null,null,null,0,0]
["Bosnia and Herzegovina",null,null,null,0,null,null,null,null,0,null,null,null,null,null,0,null,null,null,null,null,null,null,0,null,null,null,null,null,0,null,null,null,null,null,null,null,null,0,0]
["Brazil",null,null,null,0,null,null,null,null,0,null,null,null,null,null,0,null,null,null,null,null,null,null,0,null,null,null,null,null,0,null,null,null,null,null,null,null,null,0,0]
["Bulgaria",null,null,null,0,null,null,null,null,0,null,null,null,null,null,0,null,null,null,null,null,null,null,0,null,null,null,null,null,0,null,null,null,null,null,null,null,null,0,0]
["Canada",null,null,null,0,null,null,null,null,0,null,null,null,null,null,0,null,null,null,null,null,null,null,0,null,null,null,null,null,0,null,null,null,null,null,null,null,null,0,0]
["Chile",null,null,null,0,null,null,null,null,0,null,null,null,null,null,0,null,null,null,null,null,null,null,0,null,null,null,null,null,0,null,null,null,null,null,null,null,null,0,0]
["China, People's Republic",null,null,null,0,null,null,null,null,0,null,null,null,null,null,0,null,null,null,null,null,null,null,0,null,null,null,null,null,0,null,null,null,null,null,null,null,null,0,0]
["Chinese Taipei",null,null,null,0,null,null,null,null,0,null,null,null,null,null,0,null,null,null,null,null,null,null,0,null,null,null,null,null,0,null,null,null,null,null,null,null,null,0,0]
["Colombia",null,null,null,0,null,null,null,null,0,null,null,null,null,null,0,null,null,null,null,null,null,null,0,null,null,null,null,null,0,null,null,null,null,null,null,null,null,0,0]
["Croatia",null,null,null,0,null,null,null,null,0,null,null,null,null,null,0,null,null,null,null,null,null,null,0,null,null,null,null,null,0,null,null,null,null,null,null,null,null,0,0]
["Cyprus",null,null,null,0,null,null,null,null,0,null,null,null,null,null,0,null,null,null,null,null,null,null,0,null,null,null,null,null,0,null,null,null,null,null,null,null,null,0,0]
["Czech Republic",null,null,null,0,null,null,null,null,0,null,null,null,null,null,0,null,null,null,null,null,null,null,0,null,null,null,null,null,0,null,null,null,null,null,null,null,null,0,0]
["Denmark",null,null,null,0,null,null,null,null,0,null,null,null,null,null,0,null,null,null,null,null,null,null,0,null,null,null,null,null,0,null,null,null,null,null,null,null,null,0,0]
["Egypt",null,null,null,0,null,null,null,null,0,null,null,null,null,null,0,null,null,null,null,null,null,null,0,null,null,null,null,null,0,null,null,null,null,null,null,null,null,0,0]
["Estonia",null,null,null,0,null,null,null,null,0,null,null,null,null,null,0,null,null,null,null,null,null,null,0,null,null,null,null,null,0,null,null,null,null,null,null,null,null,0,0]
["Finland",null,null,null,0,null,null,null,null,0,null,null,null,null,null,0,null,null,null,null,null,null,null,0,null,null,null,null,null,0,null,null,null,null,null,null,null,null,0,0]
["France",null,null,null,0,null,null,null,null,0,null,null,null,null,null,0,null,null,null,null,null,null,null,0,null,null,null,null,null,0,null,null,null,null,null,null,null,null,0,0]
["Georgia",null,null,null,0,null,null,null,null,0,null,null,null,null,null,0,null,null,null,null,null,null,null,0,null,null,null,null,null,0,null,null,null,null,null,null,null,null,0,0]
["Germany",null,null,null,0,null,null,null,null,0,null,null,null,null,null,0,null,null,null,null,null,null,null,0,null,null,null,null,null,0,null,null,null,null,null,null,null,null,0,0]
["Greece",null,null,null,0,null,null,null,null,0,null,null,null,null,null,0,null,null,null,null,null,null,null,0,null,null,null,null,null,0,null,null,null,null,null,null,null,null,0,0]
["Hong Kong (China)",null,null,null,0,null,null,null,null,0,null,null,null,null,null,0,null,null,null,null,null,null,null,0,null,null,null,null,null,0,null,null,null,null,null,null,null,null,0,0]
["Hungary",null,null,null,0,null,null,null,null,0,null,null,null,null,null,0,null,null,null,null,null,null,null,0,null,null,null,null,null,0,null,null,null,null,null,null,null,null,0,0]
["Iceland",null,null,null,0,null,null,null,null,0,null,null,null,null,null,0,null,null,null,null,null,null,null,0,null,null,null,null,null,0,null,null,null,null,null,null,null,null,0,0]
["India",null,null,null,0,null,null,null,null,0,null,null,null,null,null,0,null,null,null,null,null,null,null,0,null,null,null,null,null,0,null,null,null,null,null,null,null,null,0,0]
["Indonesia",null,null,null,0,null,null,null,null,0,null,null,null,null,null,0,null,null,null,null,null,null,null,0,null,null,null,null,null,0,null,null,null,null,null,null,null,null,0,0]
["Iran, Islamic Republic",null,null,null,0,null,null,null,null,0,null,null,null,null,null,0,null,null,null,null,null,null,null,0,null,null,null,null,null,0,null,null,null,null,null,null,null,null,0,0]
["Iraq",null,null,null,0,null,null,null,null,0,null,null,null,null,null,0,null,null,null,null,null,null,null,0,null,null,null,null,null,0,null,null,null,null,null,null,null,null,0,0]
["Ireland",null,null,null,0,null,null,null,null,0,null,null,null,null,null,0,null,null,null,null,null,null,null,0,null,null,null,null,null,0,null,null,null,null,null,null,null,null,0,0]
["Israel",null,null,null,0,null,null,null,null,0,null,null,null,null,null,0,null,null,null,null,null,null,null,0,null,null,null,null,null,0,null,null,null,null,null,null,null,null,0,0]
["Italy",null,null,null,0,null,null,null,null,0,null,null,null,null,null,0,null,null,null,null,null,null,null,0,null,null,null,null,null,0,null,null,null,null,null,null,null,null,0,0]
["Japan",null,null,null,0,null,null,null,null,0,null,null,null,null,null,0,null,null,null,null,null,null,null,0,null,null,null,null,null,0,null,null,null,null,null,null,null,null,0,0]
["Kazakhstan",null,null,null,0,null,null,null,null,0,null,null,null,null,null,0,null,null,null,null,null,null,null,0,null,null,null,null,null,0,null,null,null,null,null,null,null,null,0,0]
["Korea",null,null,null,0,null,null,null,null,0,null,null,null,null,null,0,null,null,null,null,null,null,null,0,null,null,null,null,null,0,null,null,null,null,null,null,null,null,0,0]
["Kuwait",null,null,null,0,null,null,null,null,0,null,null,null,null,null,0,null,null,null,null,null,null,null,0,null,null,null,null,null,0,null,null,null,null,null,null,null,null,0,0]
["Kyrgyzstan",null,null,null,0,null,null,null,null,0,null,null,null,null,null,0,null,null,null,null,null,null,null,0,null,null,null,null,null,0,null,null,null,null,null,null,null,null,0,0]
["Latvia",null,null,null,0,null,null,null,null,0,null,null,null,null,null,0,null,null,null,null,null,null,null,0,null,null,null,null,null,0,null,null,null,null,null,null,null,null,0,0]
["Lebanon",null,null,null,0,null,null,null,null,0,null,null,null,null,null,0,null,null,null,null,null,null,null,0,null,null,null,null,null,0,null,null,null,null,null,null,null,null,0,0]
["Libya",null,null,null,0,null,null,null,null,0,null,null,null,null,null,0,null,null,null,null,null,null,null,0,null,null,null,null,null,0,null,null,null,null,null,null,null,null,0,0]
["Lithuania",null,null,null,0,null,null,null,null,0,null,null,null,null,null,0,null,null,null,null,null,null,null,0,null,null,null,null,null,0,null,null,null,null,null,null,null,null,0,0]
["Luxembourg",null,null,null,0,null,null,null,null,0,null,null,null,null,null,0,null,null,null,null,null,null,null,0,null,null,null,null,null,0,null,null,null,null,null,null,null,null,0,0]
["Macedonia, Former Yugoslav Republic",null,null,null,0,null,null,null,null,0,null,null,null,null,null,0,null,null,null,null,null,null,null,0,null,null,null,null,null,0,null,null,null,null,null,null,null,null,0,0]
["Malaysia",null,null,null,0,null,null,null,null,0,null,null,null,null,null,0,null,null,null,null,null,null,null,0,null,null,null,null,null,0,null,null,null,null,null,null,null,null,0,0]
["Malta",null,null,null,0,null,null,null,null,0,null,null,null,null,null,0,null,null,null,null,null,null,null,0,null,null,null,null,null,0,null,null,null,null,null,null,null,null,0,0]
["Mexico",null,null,null,0,null,null,null,null,0,null,null,null,null,null,0,null,null,null,null,null,null,null,0,null,null,null,null,null,0,null,null,null,null,null,null,null,null,0,0]
["Moldova, Republic",null,null,null,0,null,null,null,null,0,null,null,null,null,null,0,null,null,null,null,null,null,null,0,null,null,null,null,null,0,null,null,null,null,null,null,null,null,0,0]
["Montenegro",null,null,null,0,null,null,null,null,0,null,null,null,null,null,0,null,null,null,null,null,null,null,0,null,null,null,null,null,0,null,null,null,null,null,null,null,null,0,0]
["Morocco",null,null,null,0,null,null,null,null,0,null,null,null,null,null,0,null,null,null,null,null,null,null,0,null,null,null,null,null,0,null,null,null,null,null,null,null,null,0,0]
["Netherlands",null,null,null,0,null,null,null,null,0,null,null,null,null,null,0,null,null,null,null,null,null,null,0,null,null,null,null,null,0,null,null,null,null,null,null,null,null,0,0]
["Netherlands Antilles",null,null,null,0,null,null,null,null,0,null,null,null,null,null,0,null,null,null,null,null,null,null,0,null,null,null,null,null,0,null,null,null,null,null,null,null,null,0,0]
["New Zealand",null,null,null,0,null,null,null,null,0,null,null,null,null,null,0,null,null,null,null,null,null,null,0,null,null,null,null,null,0,null,null,null,null,null,null,null,null,0,0]
["Nigeria",null,null,null,0,null,null,null,null,0,null,null,null,null,null,0,null,null,null,null,null,null,null,0,null,null,null,null,null,0,null,null,null,null,null,null,null,null,0,0]
["Norway",null,null,null,0,null,null,null,null,0,null,null,null,null,null,0,null,null,null,null,null,null,null,0,null,null,null,null,null,0,null,null,null,null,null,null,null,null,0,0]
["Other Africa",null,null,null,0,null,null,null,null,0,null,null,null,null,null,0,null,null,null,null,null,null,null,0,null,null,null,null,null,0,null,null,null,null,null,null,null,null,0,0]
["Other Asia and Pacific",null,null,null,0,null,null,null,null,0,null,null,null,null,null,0,null,null,null,null,null,null,null,0,null,null,null,null,null,0,null,null,null,null,null,null,null,null,0,0]
["Other Europe",null,null,null,0,null,null,null,null,0,null,null,null,null,null,0,null,null,null,null,null,null,null,0,null,null,null,null,null,0,null,null,null,null,null,null,null,null,0,0]
["Other Former Soviet Union",null,null,null,0,null,null,null,null,0,null,null,null,null,null,0,null,null,null,null,null,null,null,0,null,null,null,null,null,0,null,null,null,null,null,null,null,null,0,0]
["Other Near and Middle East",null,null,null,0,null,null,null,null,0,null,null,null,null,null,0,null,null,null,null,null,null,null,0,null,null,null,null,null,0,null,null,null,null,null,null,null,null,0,0]
["Other non-OECD Americas",null,null,null,0,null,null,null,null,0,null,null,null,null,null,0,null,null,null,null,null,null,null,0,null,null,null,null,null,0,null,null,null,null,null,null,null,null,{"$f":"AL71+AK71+AJ71+AI71+AH71+AG71+AD71+X71+W71+U71+T71+P71+O71+J71+F71","v":0},{"$f":"AM71+E71","v":0}]
["Pakistan",null,null,null,{"$f":"SUM(B72:D72)","v":0},null,null,null,null,{"$f":"K72+L72+M72+N72","v":0},null,null,null,null,null,{"$f":"Q72+S72+R72","v":0},null,null,null,null,null,null,null,{"$f":"Y72+Z72+AA72+AB72+AC72","v":0},null,null,null,null,null,{"$f":"AE72+AF72","v":0},null,null,null,null,null,null,null,null,0,0]
["Philippines",null,null,null,0,null,null,null,null,0,null,null,null,null,null,0,null,null,null,null,null,null,null,0,null,null,null,null,null,0,null,null,null,null,null,null,null,null,0,0]
["Poland",null,null,null,0,null,null,null,null,0,null,null,null,null,null,0,null,null,null,null,null,null,null,0,null,null,null,null,null,0,null,null,null,null,null,null,null,null,0,0]
["Portugal",null,null,null,0,null,null,null,null,0,null,null,null,null,null,0,null,null,null,null,null,null,null,0,null,null,null,null,null,0,null,null,null,null,null,null,null,null,0,0]
["Qatar",null,null,null,0,null,null,null,null,0,null,null,null,null,null,0,null,null,null,null,null,null,null,0,null,null,null,null,null,0,null,null,null,null,null,null,null,null,0,0]
["Romania",null,null,null,0,null,null,null,null,0,null,null,null,null,null,0,null,null,null,null,null,null,null,0,null,null,null,null,null,0,null,null,null,null,null,null,null,null,0,0]
["Russian Federation",null,null,null,0,null,null,null,null,0,null,null,null,null,null,0,null,null,null,null,null,null,null,0,null,null,null,null,null,0,null,null,null,null,null,null,null,null,0,0]
["Saudi Arabia",null,null,null,0,null,null,null,null,0,null,null,null,null,null,0,null,null,null,null,null,null,null,0,null,null,null,null,null,0,null,null,null,null,null,null,null,null,0,0]
["Serbia",null,null,null,0,null,null,null,null,0,null,null,null,null,null,0,null,null,null,null,null,null,null,0,null,null,null,null,null,0,null,null,null,null,null,null,null,null,0,0]
["Singapore",null,null,null,0,null,null,null,null,0,null,null,null,null,null,0,null,null,null,null,null,null,null,0,null,null,null,null,null,0,null,null,null,null,null,null,null,null,0,0]
["Slovak Republic",null,null,null,0,null,null,null,null,0,null,null,null,null,null,0,null,null,null,null,null,null,null,0,null,null,null,null,null,0,null,null,null,null,null,null,null,null,0,0]
["Slovenia",null,null,null,0,null,null,null,null,0,null,null,null,null,null,0,null,null,null,null,null,null,null,0,null,null,null,null,null,0,null,null,null,null,null,null,null,null,0,0]
["South Africa",null,null,null,0,null,null,null,null,0,null,null,null,null,null,0,null,null,null,null,null,null,null,0,null,null,null,null,null,0,null,null,null,null,null,null,null,null,0,0]
["Spain",null,null,null,0,null,null,null,null,0,null,null,null,null,null,0,null,null,null,null,null,null,null,0,null,null,null,null,null,0,null,null,null,null,null,null,null,null,0,0]
["Sweden",null,null,null,0,null,null,null,null,0,null,null,null,null,null,0,null,null,null,null,null,null,null,0,null,null,null,null,null,0,null,null,null,null,null,null,null,null,0,0]
["Switzerland",null,null,null,0,null,null,null,null,0,null,null,null,null,null,0,null,null,null,null,null,null,null,0,null,null,null,null,null,0,null,null,null,null,null,null,null,null,0,0]
["Syrian Arab Republic",null,null,null,0,null,null,null,null,0,null,null,null,null,null,0,null,null,null,null,null,null,null,0,null,null,null,null,null,0,null,null,null,null,null,null,null,null,0,0]
["Tajikistan",null,null,null,0,null,null,null,null,0,null,null,null,null,null,0,null,null,null,null,null,null,null,0,null,null,null,null,null,0,null,null,null,null,null,null,null,null,0,0]
["Thailand",null,null,null,0,null,null,null,null,0,null,null,null,null,null,0,null,null,null,null,null,null,null,0,null,null,null,null,null,0,null,null,null,null,null,null,null,null,0,0]
["Trinidad and Tobago",null,null,null,0,null,null,null,null,0,null,null,null,null,null,0,null,null,null,null,null,null,null,0,null,null,null,null,null,0,null,null,null,null,null,null,null,null,0,0]
["Tunisia",null,null,null,0,null,null,null,null,0,null,null,null,null,null,0,null,null,null,null,null,null,null,0,null,null,null,null,null,0,null,null,null,null,null,null,null,null,0,0]
["Turkey",null,null,null,0,null,null,null,null,0,null,null,null,null,null,0,null,null,null,null,null,null,null,0,null,null,null,null,null,0,null,null,null,null,null,null,null,null,0,0]
["Turkmenistan",null,null,null,0,null,null,null,null,0,null,null,null,null,null,0,null,null,null,null,null,null,null,0,null,null,null,null,null,0,null,null,null,null,null,null,null,null,0,0]
["Ukraine",null,null,null,0,null,null,null,null,0,null,null,null,null,null,0,null,null,null,null,null,null,null,0,null,null,null,null,null,0,null,null,null,null,null,null,null,null,0,0]
["United Kingdom",null,null,null,0,null,null,null,null,0,null,null,null,null,null,0,null,null,null,null,null,null,null,0,null,null,null,null,null,0,null,null,null,null,null,null,null,null,0,0]
["United States",null,null,null,0,null,null,null,null,0,null,null,null,null,null,0,null,null,null,null,null,null,null,0,null,null,null,null,null,0,null,null,null,null,null,null,null,null,0,0]
["Uzbekistan",null,null,null,0,null,null,null,null,0,null,null,null,null,null,0,null,null,null,null,null,null,null,0,null,null,null,null,null,0,null,null,null,null,null,null,null,null,0,0]
["Venezuela",null,null,null,0,null,null,null,null,0,null,null,null,null,null,0,null,null,null,null,null,null,null,0,null,null,null,null,null,0,null,null,null,null,null,null,null,null,0,0]
["Vietnam",null,null,null,0,null,null,null,null,0,null,null,null,null,null,0,null,null,null,null,null,null,null,0,null,null,null,null,null,0,null,null,null,null,null,null,null,null,0,0]
["Non-specified/Other",null,null,null,0,null,null,null,null,0,null,null,null,null,null,0,null,null,null,null,null,null,null,0,null,null,null,null,null,0,null,null,null,null,null,null,null,null,0,0]
["Totaal Export",{"$f":"SUM(B7:B101)","v":0},0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0]
[null,{"$f":"IF(MIN(B7:B102)<0,\"Negatief cijfer\",\"\")","v":""},{"$f":"IF(MIN(C7:C102)<0,\"Negatief cijfer\",\"\")","v":""},"","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","",""]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(V102>U102, \"Transport via CEPS (V102) moet kleiner zijn dan totaal transport (U102)\",\"\")","v":""}]
["1. Totaal Export van Totaal Ruwe Producten (E102) moet gelijk zijn aan Totaal Export in Table 1 (F14)",null,null,null,null,null,null,{"$f":"'Table 1'!G26","v":"OK"}]
["    en Totaal Export van Totaal Producten (AM102) moet gelijk zijn aan Totaal Export in Table 2 (AK9)",null,null,null,null,null,null,{"$f":"'Table 2'!F26","v":"OK"}]

{"sheet":"Labels","index":6,"n_rows":602,"n_cols":5,"rows_kept":602,"cut":false,"hidden":true,"merged":[]}
["Active language is :"]
[null,"NL"]
[]
["Traductions / vertalingen :"]
[]
[]
[]
[]
["Sheet","Column","Row","FR label","NL label"]
["Intro","B",6,"Direction Générale Energie","Algemene Directie Energie"]
["Intro","B",7,"Service Monitoring de l'Energie & Système Electrique","Dienst Energiemonitoring & Elektriciteitssysteem"]
["Intro","B",8,"Service Qualité des produits pétroliers","Dienst Kwaliteit van Aardolieproducten"]
["Intro","B",15,"Ce questionnaire a été établi conformément à l’Arrêté royal du 15 novembre 2017 relatif à l'exigence de déclaration de biocarburants, d'huiles minérales et de leurs produits de substitution d'origine biologique.\n\nLes données demandées dans les onglets « Table 1 », « Table 2 », « Table 3 » et « Table 4 » doivent être fournies à la Direction générale de l’Énergie au plus tard le 20ème jour du mois suivant celui du rapport, tel que stipulé à l’article 6 dudit Arrêté royal. \n\nEn ce qui concerne ces onglets, le non-respect des articles 4, 6, 7 et 9 dudit Arrêté royal peut résulter en une amende allant de 1,24 euros à 495,79 euros.\n\nLes données demandées à partir de l’onglet « Biodiesel » doivent être fournies à la Direction générale de l’Énergie au plus tard le dernier jour ouvrable du mois suivant le trimestre concerné par les données, tel que stipulé dans la loi du 17 juillet 2013.\n\nEn ce qui concerne ces onglets, le non-respect des articles 5, 6, 7 et 9 dudit Arrêté royal peut résulter en une amende administrative allant de 100 euros à 10.000 euros. En cas de répétition, l’amende peut être doublée.\n\nL’assurance est donnée aux déclarants que les informations transmises ne seront pas utilisées dans un but fiscal.\n\nAdresse e-mail : oil&biofuels@economie.fgov.be\n","Deze vragenlijst is opgesteld conform het Koninklijk Besluit van 15 november 2017 betreffende de rapportageverplichting van biobrandstoffen, minerale oliën en hun substitutieproducten van biologische oorsprong.\n\nDe gegevens gevraagd in tabbladen 'Table 1', 'Table 2', Table 3' en 'Table 4' moeten bezorgd worden aan de Algemene Directie Energie, uiterlijk tegen de 20ste dag van de maand volgend op de maand van rapportering, zoals vastgelegd in artikel 6 van bovenvernoemd Koninklijk Besluit.\n\nWat betreft deze tabbladen, kan het niet naleven van artikel 4, 6, 7 en 9 van bovenvernoemd Koninklijk Besluit resulteren in een geldboete van 1,24 euro tot 495,79 euro.\n\nDe gegevens gevraagd vanaf het tabblad 'Biodiesel' moeten bezorgd worden aan de Algemene Directie Energie, uiterlijk tegen de laatste werkdag van de maand volgend op het kwartaal waarop de gegevens betrekking hebben, zoals vastgelegd in de wet van 17 juli 2013\n\nWat betreft deze tabbladen, kan het niet naleven van artikel 5, 6, 7 en 9 van bovenvernoemd Koninklijk Besluit resulteren in een administratieve geldboete van 100 euro tot 10.000 euro. In geval van herhaling kan de geldboete worden verdubbeld.\n\nAan de aangevers wordt de verzekering gegeven, dat de verstrekte gegevens niet voor fiscale doeleinden zullen worden gebruikt\n\nE-mail : oil&biofuels@economie.fgov.be"]
["Intro","B",12,"Déclarant","Aangever"]
["Intro","B",13,"Mois de la déclaration","Maand van aangifte"]
["Table 1","G",3,"TOUS LES DONNÉES DOIVENT ÊTRE ","ALLE GEGEVENS MOETEN WORDEN "]
["Table 1","G",4,"COMPLETÉES EN TONNE","INGEGEVEN IN  TON"]
["Table 1","A",7,"Table 1: BALANCE PETROLE BRUT, CONDENSAT DE GAZ NATUREL ET PRODUITS INTERMEDIAIRES ","Table 1: BALANS RUWE OLIE, CONDENSATEN VAN AARDGAS EN INTERMEDIAIRE PRODUCTEN"]
["Table 1","C",10,"Pétrole brut","Ruwe olie"]
["Table 1","D",10,"Condensat de gaz naturel","Condensaten van aardgas"]
["Table 1","E",10,"Produits intermédiaires","Intermediaire producten"]
["Table 1","F",10,"Total","Totaal"]
["Table 1","B",12,"Stock début","Beginvoorraad"]
["Table 1","B",13,"Importation","Import"]
["Table 1","B",14,"Exportation","Export"]
["Table 1","B",15,"Production","Productie"]
["Table 1","B",16,"Réceptions en libre pratique","Ontvangsten vrij verkeer"]
["Table 1","B",17,"Livraisons en libre pratique","Leveringen vrij verkeer"]
["Table 1","B",18,"Transfert de produits","Productoverdracht"]
["Table 1","B",19,"Stock fin","Eindvoorraad"]
["Table 1","B",20,"Refinery intake (Calculated)","Refinery intake (Calculated)"]
["Table 1","B",21,"Statistical difference","Statistical difference"]
["Table 1","B",22,"Refinery intake (Observed)","Refinery intake (Observed)"]
["Table 1","B",23,"Refinery losses","Refinery losses"]
["Table 1","B",25,"Total Importations (F13) = Total Importations de ces produits en Table 3 (E111)","Totaal Import (F13) komt overeen met Totaal Import van deze producten in Table 3 (E111)"]
["Table 1","B",26,"Total Exportations (F14) = Total Exportations de ces produits enTable 4 (E102)","Totaal Export (F14) komt overeen met Totaal Export van deze producten in Table 4 (E102)"]
["Table 2","A",4,"Table 2: BALANCE PRODUITS PETROLIERS","Table 2: BALANS AFGEWERKTE OLIEPRODUCTEN "]
["Table 2","B",7,"Stock début","Beginvoorraad "]
["Table 2","B",8,"Importation","Import"]
["Table 2","B",9,"Exportation","Export"]
["Table 2","B",10,"Soutage international","Internationale bunkers"]
["Table 2","B",11,"Refinery intake","Refinery intake"]
["Table 2","B",12,"Refinery Fuel","Refinery Fuel"]
["Table 2","B",13,"Production","Productie"]
["Table 2","B",14,"Réceptions en libre pratique","Ontvangsten vrij verkeer"]
["Table 2","B",15,"Livraisons en libre pratique","Leveringen vrij verkeer"]
["Table 2","B",16,"Transfert de produits","Productoverdracht"]
["Table 2","B",17,"Transfert d'additifs","Overdracht additieven"]
["Table 2","B",18,"Stock fin","Eindvoorraad"]
["Table 2","B",19,"Mise à la consommation calculée","Berekende inverbruikstelling"]
["Table 2","B",20,"Statistical difference","Statistical difference"]
["Table 2","B",21,"Mise à la consommation observée","Geobserveerde inverbruikstelling"]
["Table 2","B",25,"Total Importations (AK8) = Total Importations de ces produits en Table 3 (AM111)","Totaal Import (AK8) komt overeen met Totaal Import van deze producten in Table 3 (AM111)"]
["Table 2","B",26,"Total Exportations (AK9) = Total Exportations de ces produits en Table 4 (AM102)","Totaal Export (AK9) komt overeen met Totaal Export van deze producten in Table 4 (AM102)"]
["Table 2","B",27,"Total de transfert de produits = 0","Totaal van Productoverdracht is gelijk aan 0"]
["Table 2","B",28,"Total de transfert d'additifs = 0","Totaal van Overdracht Additieven is gelijk aan 0"]
["Table 2","C",5,"Additifs /  Composants de mélange","Additieven /  Mengcomponent"]
["Table 2","D",6,"Additif","Additief"]
["Table 2","E",6,"Bioéthanol","Bio-ethanol"]
["Table 2","F",6,"Biodiesel","Biodiesel"]
["Table 2","G",5,"Gaz de raffinerie (incondensable)","Oncondenseerbaar raffinagegas"]
["Table 2","H",5,"Total LPG","Totaal LPG"]
["Table 2","I",6,"Butane","Butaan"]
["Table 2","J",6,"Propane","Propaan"]
["Table 2","K",6,"Mélangé (LPG)","Gemengd (LPG)"]
["Table 2","L",6,"Autres LPG","Andere LPG"]
["Table 2","M",5,"Naphta","Nafta"]
["Table 2","N",5,"Total essence","Totaal motor benzine"]
["Table 2","O",6,"Essence 98 RON 10S","Benzine 98 RON 10S"]
["Table 2","P",6,"Essence 95 RON 10S","Benzine 95 RON 10S"]
["Table 2","Q",6,"Autres essence","Andere benzine"]
["Table 2","R",5,"Essence avion","Vliegtuig- benzine"]
["Table 2","S",5,"Total\nkerosène\ntype\ncarburéacteur","Totaal\nkerosine\ntype\njet fuel"]
["Table 2","T",6,"dont \npar pipeline CEPS","waarvan via CEPS pijplijn"]
["Table 2","U",5,"Pétrole lampant","Lamp-petroleum"]
["Table 2","V",5,"Total diesel / gasoil","Totaal\ngas/diesel\nolie"]
["Table 2","W",6,"Gasoil Diesel 10S","Gasolie Diesel 10S"]
["Table 2","X",6,"Gasoil de chauffage","Gasolie verwarming"]
["Table 2","Y",6,"Gasoil de chauffage Extra","Gasolie verwarming Extra"]
["Table 2","Z",6,"Gasoil navigation rhénane et intérieure","Gasolie Rijn en binnenvaart"]
["Table 2","AA",6,"Autres gasoil","Andere Gasolie"]
["Table 2","AB",5,"Fuel oil résiduel","Zware residuele stookolie"]
["Table 2","AC",6,"Souffre <1%","Laag zwavel\n(<1%)"]
["Table 2","AD",6,"Souffre \n>= 1%","Hoog zwavel\n (>=1%)"]
["Table 2","AE",5,"White spirit et Essences speciales","White spirit en Speciale benzine"]
["Table 2","AF",5,"Lubrifiants","Smeer-middelen"]
["Table 2","AG",5,"Bitume","Bitumen"]
["Table 2","AH",5,"Paraffines","Paraffine"]
["Table 2","AI",5,"Coke de pétrole","Petroleum coke"]
["Table 2","AJ",5,"Autres produits pétroliers","Andere olieproducten"]
["Table 2","AK",5,"Total produits pétroliers","Totaal olieproducten"]
["Table 3","A",4,"Table 3: IMPORTATION PAR PAYS","Table 3: IMPORT PER LAND"]
["Table 3","A",111,"Total Importations","Totaal Import"]
["Table 3","A",114,"1. Total Importations de Total Produits Bruts (E111) = Total Importations en Table 1 (F13)","1. Totaal Import van Totaal Ruwe Producten (E111) moet gelijk zijn aan Totaal Import in Table 1 (F13)"]
["Table 3","A",115,"    et Total Importations de Total Produits Pétroliers (AM111) = Total Importations en Table 2 (AK8)","    en Totaal Import van Totaal Producten (AM111) moet gelijk zijn aan Totaal Import in Table 2 (AK8)"]
["Table 3","B",5,"Pétrole brut","Ruwe olie"]
["Table 3","C",5,"Condensat de gaz naturel","Condensaten van aardgas"]
["Table 3","D",5,"Produits intermédiaires","Intermediaire producten"]
["Table 3","E",5,"Total Produits Bruts","Totaal Ruwe Producten"]
["Table 3","F",5,"Additifs /  Composants de mélange","Additieven /  Mengcomponent"]
["Table 3","G",6,"Classique","Klassiek"]
["Table 3","H",6,"Bioéthanol","Bio-ethanol"]
["Table 3","I",6,"Biodiesel","Biodiesel"]
["Table 3","J",5,"Total LPG","Totaal LPG"]
["Table 3","K",6,"Butane","Butaan"]
["Table 3","L",6,"Propane","Propaan"]
["Table 3","M",6,"Mélangé (LPG)","Gemengd (LPG)"]
["Table 3","N",6,"Autres LPG","Andere LPG"]
["Table 3","O",5,"Naphta","Nafta"]
["Table 3","P",5,"Total essence","Totaal motor benzine"]
["Table 3","Q",6,"Essence 98 RON 10S","Benzine 98 RON 10S"]
["Table 3","R",6,"Essence 95 RON 10S","Benzine 95 RON 10S"]
["Table 3","S",6,"Autres essence","Andere benzine"]
["Table 3","T",5,"Essence avion","Vliegtuig- benzine"]
["Table 3","U",5,"Total\nkerosène\ntype\ncarburéacteur","Totaal\nkerosine\ntype\njet fuel"]
["Table 3","V",6,"dont \npar pipeline CEPS","waarvan via CEPS pijplijn"]
["Table 3","W",5,"Pétrole lampant","Lamp-petroleum"]
["Table 3","X",5,"Total diesel / gasoil","Totaal\ngas/diesel\nolie"]
["Table 3","Y",6,"Gasoil Diesel 10S","Gasolie Diesel 10S"]
["Table 3","Z",6,"Gasoil de chauffage","Gasolie verwarming"]
["Table 3","AA",6,"Gasoil de chauffage Extra","Gasolie verwarming Extra"]
["Table 3","AB",6,"Gasoil navigation rhénane et intérieure","Gasolie Rijn en binnenvaart"]
["Table 3","AC",6,"Autres gasoil","Andere Gasolie"]
["Table 3","AD",5,"Fuel oil résiduel","Zware residuele stookolie"]
["Table 3","AE",6,"Souffre <1%","Laag zwavel\n(<1%)"]
["Table 3","AF",6,"Souffre \n>= 1%","Hoog zwavel\n (>=1%)"]
["Table 3","AG",5,"White spirit et Essences speciales","White spirit en Speciale benzine"]
["Table 3","AH",5,"Lubrifiants","Smeer-middelen"]
["Table 3","AI",5,"Bitume","Bitumen"]
["Table 3","AJ",5,"Paraffines","Paraffine"]
["Table 3","AK",5,"Coke de pétrole","Petroleum coke"]
["Table 3","AL",5,"Autres produits pétroliers","Andere olieproducten"]
["Table 3","AM",5,"Total Produits Pétroliers","Totaal Producten"]
["Table 3","AN",5,"Total\nOil","Totaal\nOlie"]
["Table 4","A",4,"Table 4: EXPORTATION PAR PAYS","Table 4: EXPORT PER LAND"]
["Table 4","A",102,"Total Exportations","Totaal Export"]
["Table 4","A",105,"1. Total Exportations de Total Produits Bruts (E102) = Total Exportations en Table 1 (F14)","1. Totaal Export van Totaal Ruwe Producten (E102) moet gelijk zijn aan Totaal Export in Table 1 (F14)"]
["Table 4","A",106,"    et Total Exportations de Total Produits Pétroliers (AM102) = Total Exportations en Table 2 (AK9)","    en Totaal Export van Totaal Producten (AM102) moet gelijk zijn aan Totaal Export in Table 2 (AK9)"]
["Table 4","B",5,"Pétrole brut","Ruwe olie"]
["Table 4","C",5,"Condensat de gaz naturel","Condensaten van aardgas"]
["Table 4","D",5,"Produits intermédiaires","Intermediaire producten"]
["Table 4","E",5,"Total Produits Bruts","Totaal Ruwe Producten"]
["Table 4","F",5,"Additifs /  Composants de mélange","Additieven /  Mengcomponent"]
["Table 4","G",6,"Classique","Klassiek"]
["Table 4","H",6,"Bioéthanol","Bio-ethanol"]
["Table 4","I",6,"Biodiesel","Biodiesel"]
["Table 4","J",5,"Total LPG","Totaal LPG"]
["Table 4","K",6,"Butane","Butaan"]
["Table 4","L",6,"Propane","Propaan"]
["Table 4","M",6,"Mélangé (LPG)","Gemengd (LPG)"]
["Table 4","N",6,"Autres LPG","Andere LPG"]
["Table 4","O",5,"Naphta","Nafta"]
["Table 4","P",5,"Total essence","Totaal motor benzine"]
["Table 4","Q",6,"Essence 98 RON 10S","Benzine 98 RON 10S"]
["Table 4","R",6,"Essence 95 RON 10S","Benzine 95 RON 10S"]
["Table 4","S",6,"Autres essence","Andere benzine"]
["Table 4","T",5,"Essence avion","Vliegtuig- benzine"]
["Table 4","U",5,"Total\nkerosène\ntype\ncarburéacteur","Totaal\nkerosine\ntype\njet fuel"]
["Table 4","V",6,"dont \npar pipeline CEPS","waarvan via CEPS pijplijn"]
["Table 4","W",5,"Pétrole lampant","Lamp-petroleum"]
["Table 4","X",5,"Total diesel / gasoil","Totaal\ngas/diesel\nolie"]
["Table 4","Y",6,"Gasoil Diesel 10S","Gasolie Diesel 10S"]
["Table 4","Z",6,"Gasoil de chauffage","Gasolie verwarming"]
["Table 4","AA",6,"Gasoil de chauffage Extra","Gasolie verwarming Extra"]
["Table 4","AB",6,"Gasoil navigation rhénane et intérieure","Gasolie Rijn en binnenvaart"]
["Table 4","AC",6,"Autres gasoil","Andere Gasolie"]
["Table 4","AD",5,"Fuel oil résiduel","Zware residuele stookolie"]
["Table 4","AE",6,"Souffre <1%","Laag zwavel\n(<1%)"]
["Table 4","AF",6,"Souffre \n>= 1%","Hoog zwavel\n (>=1%)"]
["Table 4","AG",5,"White spirit et Essences speciales","White spirit en Speciale benzine"]
["Table 4","AH",5,"Lubrifiants","Smeer-middelen"]
["Table 4","AI",5,"Bitume","Bitumen"]
["Table 4","AJ",5,"Paraffines","Paraffine"]
["Table 4","AK",5,"Coke de pétrole","Petroleum coke"]
["Table 4","AL",5,"Autres produits pétroliers","Andere olieproducten"]
["Table 4","AM",5,"Total Produits Pétroliers","Totaal Producten"]
["Table 4","AN",5,"Total\nOil","Totaal\nOlie"]
["Table 2","M",23,"Mise à la consommation :","Inverbruikstelling :"]
["Table 2","U",23,"Mise à la consommation :","Inverbruikstelling :"]
["Table 2","M",24,"dont bioéthanol :","waarvan bio-ethanol :"]
["Table 2","U",24,"dont biodiesel :","waarvan biodiesel :"]
["Balans - omzetting","A",2,"Biocarburants: conversion de la masse en volume des quantités mises à la consommation","Biobrandstoffen: omzetting van massa naar volume van de inverbruikgestelde hoeveelheden"]
["Balans - omzetting","A",10,"Janvier","Januari"]
["Balans - omzetting","A",11,"Février","Februari"]
["Balans - omzetting","A",12,"Mars","Maart"]
["Balans - omzetting","A",14,"Avril","April"]
["Balans - omzetting","A",15,"Mai","Mei "]
["Balans - omzetting","A",16,"Juin","Juni"]
["Balans - omzetting","A",18,"Juillet","Juli"]
["Balans - omzetting","A",19,"Août","Augustus"]
["Balans - omzetting","A",20,"Septembre","September"]
["Balans - omzetting","A",22,"Octobre","Oktober"]
["Balans - omzetting","A",23,"Novembre","November"]
["Balans - omzetting","A",24,"Décembre","December"]
["Balans - omzetting","A",26,"Total","Totaal"]
["Balans - omzetting","B",4,"Le bilan bio doit être rempli chaque trimestre","De biobalans dient per kwartaal ingevuld te worden"]
["Balans - omzetting","B",5,"(au plus tard le dernier jour ouvrable du mois qui suit le trimestre)","(op de laatste werkdag van de maand volgend op het kwartaal)"]
["Balans - omzetting","B",7,"Diesel (en mélange)","Diesel (gemengd)"]
["Balans - omzetting","B",9,"Balance pétrolière\n(tonne)","Petroleumbalans\n(ton)"]
["Balans - omzetting","B",29,"À remplir","in te vullen"]
["Balans - omzetting","D",9,"Densité calculée (kg/m³)","Berekende massadichtheid (kg/m³)"]
["Balans - omzetting","E",9,"Balance pétrolière\n(tonne)","Petroleumbalans\n(ton)"]
["Balans - omzetting","G",9,"Densité calculée (kg/m³)","Berekende massadichtheid (kg/m³)"]
["Balans - omzetting","F",4,"TRIMESTRIELLEMENT","DRIEMAANDELIJKS"]
["Balans - omzetting","D",29,"Toutes les données sont exprimées en 15°C","De gegevens worden uitgedrukt bij 15°C"]
["Balans - omzetting","E",7,"Essence (en mélange)","Benzine (gemengd)"]
["Balans - omzetting","C",9,"Bilan bio\n(m³)","Biobalans\n(m³)"]
["Balans - omzetting","F",9,"Bilan bio\n(m³)","Biobalans\n(m³)"]
["Biodiesel","B",2,"Annexe I - Bilan trimestriel relatif à l'obligation d'incorporation de biocarburants dans les quantités de diesel mises à la consommation","Bijlage I - Trimestriële balans met betrekking tot de verplichte bijmenging van biobrandstoffen in de hoeveelheden diesel die tot verbruik worden uitgeslagen"]
["Biodiesel","B",5,"TRIMESTRE DE MISES À LA CONSOMMATION (exemple 2017 / Q1)","TRIMESTER VAN DE IN VERBRUIKSTELLING  (voorbeeld 2017 / Q1) :"]
["Biodiesel","E",20,"Si vous remplissez les données dans \"dont part biocarburant\", des lignes seront ajoutées (jusqu'à 80).","Bij het invullen van de gegevens bij \"waarvan biobrandstof\" worden automatisch rijen ingevoegd (tot 80)."]
["Biodiesel","B",8,"IDENTIFICATION DE LA SOCIÉTÉ (siège social) :","IDENTIFICATIE VAN DE MAATSCHAPPIJ (maatschappelijke zetel) :"]
["Biodiesel","B",11,"NOM :","NAAM :"]
["Biodiesel","B",12,"RUE ET N° :","STRAAT EN NR. :"]
["Biodiesel","B",13,"CODE POSTAL","POSTCODE :"]
["Biodiesel","B",14,"LOCALITÉ :","PLAATS :"]
["Biodiesel","B",15,"PERSONNE DE CONTACT :","CONTACTPERSOON :"]
["Biodiesel","B",16,"N° TÉL :","TELNR. :"]
["Biodiesel","B",17,"ADRESSE MAIL :","MAILADRES :"]
["Biodiesel","E",11,"     N° D'ACCISES :","     ACCIJNSNUMMER :"]
["Biodiesel","E",12,"     NOMBRE DE DÉPÔTS :","     AANTAL ENTREPOTNUMMERS :"]
["Biodiesel","E",13,"     N° DE DÉPÔT ET ADRESSE DÉPÔT 1 :","     ENTREPOT EN ADRES NR 1 :"]
["Biodiesel","E",14,"     N° DE DÉPÔT ET ADRESSE DÉPÔT 2 :","     ENTREPOT EN ADRES NR 2 :"]
["Biodiesel","E",15,"     N° DE DÉPÔT ET ADRESSE DÉPÔT 3 :","     ENTREPOT EN ADRES NR 3 :"]
["Biodiesel","B",20,"DONNÉES DES MISES À LA CONSOMMATION (1°) :","GEGEVENS VAN DE IN VERBUIK STELLING (1°) :"]
["Biodiesel","B",22,"N° de ligne","Nr. lijn"]
["Biodiesel","C",22,"Date","Datum"]
["Biodiesel","D",22,"Diesel EN590 en mélange (3°)","Gemengde diesel EN590 (3°)"]
["Biodiesel","E",22,"dont part fossile (3°)(4°)","waarvan fossiel (3°)(4°)"]
["Biodiesel","F",22,"dont part biocarburant (2°)(3°)","waarvan biobrandstof (2°)(3°)"]
["Biodiesel","G",22,"Type Bio (voir \"Liste biocarburants durables\") (5°)","Type Bio (zie \"Lijst duurzame biobrandstoffen\") (5°)"]
["Biodiesel","H",22,"Catégorie (A/B/C)","Categorie (A/B/C)"]
["Biodiesel","I",22,"N° de dossier technique (cat. B/C)","N° van technisch dossier (cat. B / C)"]
["Biodiesel","J",22,"N° d'enregistrement BDD A.R. 26/11/2011","Inschrijvings N° BDD K.B. 26/11/2011"]
["Biodiesel","B",106,"Notes :","Opmerkingen :"]
["Biodiesel","B",107,"1° Exclusivement les mises à la consommation réellement effectuées au cours du trimestre","1° Enkel de reëel tot verbruik uitgeslagen producten tijdens het trimester "]
["Biodiesel","B",108,"2° Si des volumes sont transférés à un tiers, sous régime de suspension d'accises ou mis","2° Indien volumes naar een derde worden overgebracht, onder schorsing van accijnzen "]
["Biodiesel","B",109,"à la consommation pour le compte d'un tiers, les déclarations décrites dans l'arrêté","of de in verbruikstelling voor rekening van een derde gebeurt, moeten de geschreven "]
["Biodiesel","B",110,"relatif \"aux modalités et aux conditions et obligations concernant la déclaration trimestrielle …\"","verklaringen in het besluit betreffende \"de regels en voorwaarden in verband "]
["Biodiesel","B",111,"doivent impérativement être fournies","met de trimestriële aangifte \" steeds voorzien worden"]
["Biodiesel","B",112,"3° Les volumes à remplir doivent être exprimées en m³ à 15°C","3° De in te vullen gegevens moeten uitgedrukt zijn in m³ bij 15°C"]
["Biodiesel","B",113,"4° Dans le cas où plusieurs types de biocarburants sont en mélange dans un volume de fossile,","4° Als meerdere types biobrandstoffen in een volume fossiel gemengd zijn dient dit volume"]
["Biodiesel","B",114,"ce volume de fossile ne doit être introduit qu'une seule fois dans la colonne E","fossiel slechts één keer in kolom E berekend te worden"]
["Biodiesel","B",115,"5° Le biocarburant réellement mélangé doit être indiqué","5° De werkelijk bijgemengde biobrandstof dient aangegeven te worden"]
["Biodiesel","G",106,"∆ stocks (*) :","∆ stocks (*) :"]
["Biodiesel","F",110,"Catégorie A","Categorie A"]
["Biodiesel","F",111,"Catégorie B","Categorie B"]
["Biodiesel","F",112,"Catégorie C","Categorie C"]
["Biodiesel","G",108,"Stock en début de trim.","Voorraad begin trimester"]
["Biodiesel","G",113,"(*) Volumes réels de biocarburants uniquement","(*) Enkel reële volumes biobrandstoffen"]
["Biodiesel","H",108,"Achats","Aankopen"]
["Biodiesel","H",109,"En mélange","Gemengd"]
["Biodiesel","I",109,"Pur","Puur"]
["Biodiesel","J",108,"Volumes cédés","Verkopen"]
["Biodiesel","J",109,"En mélange","Gemengd"]
["Biodiesel","K",109,"Pur","Puur"]
["Biodiesel","L",109,"Export","Uitgevoerd"]
["Biodiesel","M",108,"Mises à la consommation","Inverbruikstellingen"]
["Biodiesel","N",108,"Stock en fin de trimestre","Voorraad eind trimester"]
["Biodiesel","B",116,"Synthèse :","Synthese :"]
["Biodiesel","C",118,"Valeur atteinte (m³)","Bereikte waarde (m³)"]
["Biodiesel","D",118,"% atteint","% bereikt"]
["Biodiesel","B",123,"VN totale (A+B+C)","VN totaal (A+B+C)"]
["Biodiesel","E",122,"Obligation: maximum 1,5 %","Verplichting: maximum 1,5 %"]
["Biodiesel","E",123,"Obligation: minimum 6 %","Verplichting: minimum 6 %"]
["Biodiesel","G",116,"Légende :","Legende :"]
["Biodiesel","G",118,"VR = volume réel","VR = reëel volume "]
["Biodiesel","G",119,"FE = Facteur Énergétique correctif - équivalent EMAG","FE = corrigerende Energie Factor - tegenwaarde FAME"]
["Biodiesel","G",120,"VE = Volume Équivalent EMAG = VR x FE","VE = Gelijkwaardig Volume FAME = VR x FE"]
["Biodiesel","G",121,"FC = Facteur Correctif de catégorie","FC = Corrigerende Factor van de categorie"]
["Biodiesel","G",122,"VN = Volume Nominal = VR x FE x FC = VE x FC","VN = Nominaal volume= VR x FE x FC = VE x FC"]
["Biodiesel","J",118,": catégorie A",": categorie A"]
["Biodiesel","J",119,": catégorie B",": categorie B"]
["Biodiesel","J",120,": catégorie C",": categorie C"]
["Biodiesel","E",8,"à remplir","in te vullen"]
["Biodiesel","F",8,"rempli automatiquement","automatisch ingevuld"]
["Biodiesel","B",126,"Vu pour être annexé à notre arrêté du 15 novembre 2017 relatif à l'exigence de déclaration de biocarburants, d'huiles minérales et de leurs produits de substitution d'origine biologique","Gezien om gevoegd te worden bij ons besluit van 15 november 2017 betreffende de rapportageverplichting van biobrandstoffen, minerale oliën en hun substitutieproducten van biologische oorsprong"]
["Biodiesel","E",137,"Par le Roi :","Van Koningswege :"]
["Biodiesel","E",157,"La Ministre de L'Energie,","De Minister van Energie,"]
["Biodiesel","E",158,"de l'Environnement et du Développement durable","Leefmilieu en Duurzame Ontwikkeling"]
["Biodiesel","B",171,"N° réf.","Ref. N°"]
["Biodiesel","C",171,"Carburant","Brandstof"]
["Biodiesel","D",171,"Contenu énergétique volumique (pouvoir calorifique inférieur, MJ/l)","Energie-inhoud in volume (calorische onderwaarde, MJ/l)"]
["Biodiesel","E",171,"Catégorie","Categorie"]
["Biodiesel","C",172,"Biogazole (ester méthylique de qualité gazole produit à partir d'une huile végétale ou animale, utilisé comme biocarburant) ","Biodiesel (methylester op basis van plantaardig of dierlijke olie, van diesel kwaliteit, voor toepassing  als biobrandstof)"]
["Biodiesel","C",173,"Gazole filière Fisher-Tropsch (hydrocarbure synthétique ou mélange d'hydrocarbures synthétiques produits à partir de biomasse)","Fisher-Tropsch diesel (een synthetische KWS of mengsel van synthetische KWS uit biomassa)"]
["Biodiesel","C",174,"Huile végétale hydrotraitée (huile végétale ayant subi un traitement thermochimique à l'hydrogène)","Waterstofbehandelende plantaardige olie (plantaardige olie die thermochemisch is behandeld met waterstof)"]
["Biodiesel","C",175,"Huile végétale pure (huile provenant de plantes oléagineuses obtenue par pression, extraction ou procédés comparables, brute ou raffinée, mais sans modification chimique, dans les cas où son utilisation est compatible avec le type de moteur et les exigences correspondantes en matière d'émissions)","Zuivere plantaardige olie (olie die uit oliehoudende planten is verkregen door persing, extractie of vergelijkbare procedures, ruw of geraffineerd maar niet chemisch gemodificeerd, voor zover verenigbaar met het betreffende motortype en de overeenkomstige emissie-eisen)"]
["Biodiesel","B",177,"(*) En cas d'acceptation du double comptage","(*) Bij aanvaarding van dubbele telling"]
["E95 - E5","B",2,"Annexe I - Bilan trimestriel relatif à l'obligation d'incorporation de biocarburants dans les quantités d'essence E95 - E5 mises à la consommation","Bijlage I - Trimestriële balans met betrekking tot de verplichte bijmenging van biobrandstoffen in de hoeveelheden benzine E95 - E5 die tot verbruik worden uitgeslagen"]
["E95 - E5","B",5,"TRIMESTRE DE MISES À LA CONSOMMATION (exemple 2017 / Q1)","TRIMESTER VAN DE IN VERBRUIKSTELLING  (voorbeeld 2017 / Q1) :"]
["E95 - E5","E",20,"Si vous remplissez les données dans \"dont part biocarburant\", des lignes seront ajoutées (jusqu'à 40).","Bij het invullen van de gegevens bij \"waarvan biobrandstof\" worden automatisch rijen ingevoegd (tot 40)."]
["E95 - E5","E",8,"à remplir","in te vullen"]
["E95 - E5","F",8,"rempli automatiquement","automatisch ingevuld"]
["E95 - E5","B",8,"IDENTIFICATION DE LA SOCIÉTÉ (siège social) :","IDENTIFICATIE VAN DE MAATSCHAPPIJ (maatschappelijke zetel) :"]
["E95 - E5","B",11,"NOM :","NAAM :"]
["E95 - E5","B",12,"RUE ET N° :","STRAAT EN NR. :"]
["E95 - E5","B",13,"CODE POSTAL","POSTCODE :"]
["E95 - E5","B",14,"LOCALITÉ :","PLAATS :"]
["E95 - E5","B",15,"PERSONNE DE CONTACT :","CONTACTPERSOON :"]
["E95 - E5","B",16,"N° TÉL :","TELNR. :"]
["E95 - E5","B",17,"ADRESSE MAIL :","MAILADRES :"]
["E95 - E5","E",11,"     N° D'ACCISES :","     ACCIJNSNUMMER :"]
["E95 - E5","E",12,"     NOMBRE DE DÉPÔTS :","     AANTAL ENTREPOTNUMMERS :"]
["E95 - E5","E",13,"     N° DE DÉPÔT ET ADRESSE DÉPÔT 1 :","     ENTREPOT EN ADRES NR 1 :"]
["E95 - E5","E",14,"     N° DE DÉPÔT ET ADRESSE DÉPÔT 2 :","     ENTREPOT EN ADRES NR 2 :"]
["E95 - E5","E",15,"     N° DE DÉPÔT ET ADRESSE DÉPÔT 3 :","     ENTREPOT EN ADRES NR 3 :"]
["E95 - E5","B",20,"DONNÉES DES MISES À LA CONSOMMATION (1°) :","GEGEVENS VAN DE IN VERBUIK STELLING (1°) :"]
["E95 - E5","B",22,"N° de ligne","Nr. lijn"]
["E95 - E5","C",22,"Date","Datum"]
["E95 - E5","D",22,"Essence EN228 en mélange (3°): E95 - E5","Gemengde benzine EN228 (3°): E95 - E5"]
["E95 - E5","E",22,"dont part fossile (3°)(4°)","waarvan fossiel (3°)(4°)"]
["E95 - E5","F",22,"dont part biocarburant (2°)(3°)","waarvan biobrandstof (2°)(3°)"]
["E95 - E5","G",22,"Type Bio (voir \"Liste biocarburants durables\") (5°)","Type Bio (zie \"Lijst duurzame biobrandstoffen\") (5°)"]
["E95 - E5","H",22,"Catégorie (A/B/C)","Categorie (A/B/C)"]
["E95 - E5","I",22,"N° de dossier technique (cat. B/C)","N° van technisch dossier (cat. B / C)"]
["E95 - E5","J",22,"N° d'enregistrement BDD A.R. 26/11/2011","Inschrijvings N° BDD K.B. 26/11/2011"]
["E95 - E5","B",66,"Notes :","Opmerkingen :"]
["E95 - E5","B",67,"1° Exclusivement les mises à la consommation réellement effectuées au cours du trimestre","1° Enkel de reëel tot verbruik uitgeslagen producten tijdens het trimester "]
["E95 - E5","B",68,"2° Si des volumes sont transférés à un tiers, sous régime de suspension d'accises ou mis","2° Indien volumes naar een derde worden overgebracht, onder schorsing van accijnzen "]
["E95 - E5","B",69,"à la consommation pour le compte d'un tiers, les déclarations décrites dans l'arrêté","of de in verbruikstelling voor rekening van een derde gebeurt, moeten de geschreven "]
["E95 - E5","B",70,"relatif \"aux modalités et aux conditions et obligations concernant la déclaration trimestrielle …\"","verklaringen in het besluit betreffende \"de regels en voorwaarden in verband "]
["E95 - E5","B",71,"doivent impérativement être fournies","met de trimestriële aangifte \" steeds voorzien worden"]
["E95 - E5","B",72,"3° Les volumes à remplir doivent être exprimées en m³ à 15°C","3° De in te vullen gegevens moeten uitgedrukt zijn in m³ bij 15°C"]
["E95 - E5","B",73,"4° Dans le cas où plusieurs types de biocarburants sont en mélange dans un volume de fossile,","4° Als meerdere types biobrandstoffen in een volume fossiel gemengd zijn dient dit volume"]
["E95 - E5","B",74,"ce volume de fossile ne doit être introduit qu'une seule fois dans la colonne E","fossiel slechts één keer in kolom E berekend te worden"]
["E95 - E5","B",75,"5° Le biocarburant réellement mélangé doit être indiqué","5° De werkelijk bijgemengde biobrandstof dient aangegeven te worden"]
["E95 - E5","I",68,": catégorie A",": categorie A"]
["E95 - E5","I",69,": catégorie B",": categorie B"]
["E95 - E5","I",70,": catégorie C",": categorie C"]
["E95 - E5","F",66,"Légende :","Legende :"]
["E95 - E5","F",68,"VR = volume réel","VR = reëel volume "]
["E95 - E5","F",69,"FE = Facteur Énergétique correctif - équivalent bioéthanol","FE = corrigerende Energie Factor - tegenwaarde bio-ethanol"]
["E95 - E5","F",70,"VE = Volume Équivalent bioéthanol = VR x FE","VE = Gelijkwaardig Volume bio-ethanol = VR x FE"]
["E95 - E5","F",71,"FC = Facteur Correctif de catégorie","FC = Corrigerende Factor van de categorie"]
["E95 - E5","F",72,"VN = Volume Nominal = VR x FE x FC = VE x FC","VN = Nominaal volume= VR x FE x FC = VE x FC"]
["E95 - E5","B",77,"Vu pour être annexé à notre arrêté du 15 novembre 2017 relatif à l'exigence de déclaration de biocarburants, d'huiles minérales et de leurs produits de substitution d'origine biologique","Gezien om gevoegd te worden bij ons besluit van 15 november 2017 betreffende de rapportageverplichting van biobrandstoffen, minerale oliën en hun substitutieproducten van biologische oorsprong"]
["E95 - E5","E",109,"de l'Environnement et du Développement durable","Leefmilieu en Duurzame Ontwikkeling"]
["E95 - E5","E",108,"La Ministre de L'Energie,","De Minister van Energie,"]
["E95 - E5","E",88,"Par le Roi :","Van Koningswege :"]
["E95 - E5","B",122,"N° réf.","Ref. N°"]
["E95 - E5","C",122,"Carburant","Brandstof"]
["E95 - E5","D",122,"Contenu énergétique volumique (pouvoir calorifique inférieur, MJ/l)","Energie-inhoud in volume (calorische onderwaarde, MJ/l)"]
["E95 - E5","E",122,"Catégorie","Categorie"]
["E95 - E5","C",123,"Bioéthanol (éthanol produit à partir de biomasse)","Bio-ethanol (ethanol geproduceerd uit biomassa)"]
["E95 - E5","C",124,"Bio-ETBE (éthyl-tertio-butyl-éther produit à partir de bioéthanol)","Bio-ETBE (op basis van bio-ethanol geproduceerde ethyl- tertiair- butylether)"]
["E95 - E5","C",125,"Biométhanol (méthanol produit à partir de biomasse, utilisé comme biocarburant)","Biomethanol (methanol geproduceerd uit biomassa, voor toepassing  als biobrandstof)"]
["E95 - E5","C",126,"Bio-MTBE (méthyl-tertio-butyl-éther produit à partir de biométhanol)","Bio-MTBE(op basis van biomethanol geproduceerde methyl tertiair butyl ether)"]
["E95 - E5","B",131,"(*) En cas d'acceptation du double comptage","(*) Bij aanvaarding van dubbele telling"]
["E95 - E5","C",127,"Bio-DME (diméthyléther produit à partir de biomasse, utilisé comme biocarburant)","Bio-DME(op basis van biomassa geproduceerde dimethylether  voor toepassing  als biobrandstof)"]
["E95 - E5","C",128,"Bio-TAEE (tertioamyléther produit à partir de bioéthanol)","Bio-TAEE (op basis van bio-ethanol geproduceerde ethyl-tertiair amylether)"]
["E95 - E5","C",129,"Biobutanol (butanol produit de biomasse, utilisé comme biocarburant)","Biobutanol (butanol uit biomassa, voor toepassing  als biobrandstof)"]
["E95 - E5","D",124,"27 (dont 37 % issus de sources renouvelables)","27 (waarvan  37 % uit hernieuwbare bronnen)"]
["E95 - E5","D",126,"26 (dont 22 % issus de sources renouvelables)","26 (waarvan  22 % uit hernieuwbare bronnen)"]
["E95 - E5","D",128,"29 (dont 29 % issus de sources renouvelables)","29 (waarvan  29 % uit hernieuwbare bronnen)"]
["E95 - E10","B",2,"Annexe I - Bilan trimestriel relatif à l'obligation d'incorporation de biocarburants dans les quantités d'essence E95 - E10 mises à la consommation","Bijlage I - Trimestriële balans met betrekking tot de verplichte bijmenging van biobrandstoffen in de hoeveelheden benzine E95 - E10 die tot verbruik worden uitgeslagen"]
["E95 - E10","B",5,"TRIMESTRE DE MISES À LA CONSOMMATION (exemple 2017 / Q1)","TRIMESTER VAN DE IN VERBRUIKSTELLING  (voorbeeld 2017 / Q1) :"]
["E95 - E10","E",20,"Si vous remplissez les données dans \"dont part biocarburant\", des lignes seront ajoutées (jusqu'à 40).","Bij het invullen van de gegevens bij \"waarvan biobrandstof\" worden automatisch rijen ingevoegd (tot 40)."]
["E95 - E10","E",8,"à remplir","in te vullen"]
["E95 - E10","F",8,"rempli automatiquement","automatisch ingevuld"]
["E95 - E10","B",8,"IDENTIFICATION DE LA SOCIÉTÉ (siège social) :","IDENTIFICATIE VAN DE MAATSCHAPPIJ (maatschappelijke zetel) :"]
["E95 - E10","B",11,"NOM :","NAAM :"]
["E95 - E10","B",12,"RUE ET N° :","STRAAT EN NR. :"]
["E95 - E10","B",13,"CODE POSTAL","POSTCODE :"]
["E95 - E10","B",14,"LOCALITÉ :","PLAATS :"]
["E95 - E10","B",15,"PERSONNE DE CONTACT :","CONTACTPERSOON :"]
["E95 - E10","B",16,"N° TÉL :","TELNR. :"]
["E95 - E10","B",17,"ADRESSE MAIL :","MAILADRES :"]
["E95 - E10","E",11,"     N° D'ACCISES :","     ACCIJNSNUMMER :"]
["E95 - E10","E",12,"     NOMBRE DE DÉPÔTS :","     AANTAL ENTREPOTNUMMERS :"]
["E95 - E10","E",13,"     N° DE DÉPÔT ET ADRESSE DÉPÔT 1 :","     ENTREPOT EN ADRES NR 1 :"]
["E95 - E10","E",14,"     N° DE DÉPÔT ET ADRESSE DÉPÔT 2 :","     ENTREPOT EN ADRES NR 2 :"]
["E95 - E10","E",15,"     N° DE DÉPÔT ET ADRESSE DÉPÔT 3 :","     ENTREPOT EN ADRES NR 3 :"]
["E95 - E10","B",20,"DONNÉES DES MISES À LA CONSOMMATION (1°) :","GEGEVENS VAN DE IN VERBUIK STELLING (1°) :"]
["E95 - E10","B",22,"N° de ligne","Nr. lijn"]
["E95 - E10","C",22,"Date","Datum"]
["E95 - E10","D",22,"Essence EN228 en mélange (3°): E95 - E10","Gemengde benzine EN228 (3°): E95 - E10"]
["E95 - E10","E",22,"dont part fossile (3°)(4°)","waarvan fossiel (3°)(4°)"]
["E95 - E10","F",22,"dont part biocarburant (2°)(3°)","waarvan biobrandstof (2°)(3°)"]
["E95 - E10","G",22,"Type Bio (voir \"Liste biocarburants durables\") (5°)","Type Bio (zie \"Lijst duurzame biobrandstoffen\") (5°)"]
["E95 - E10","H",22,"Catégorie (A/B/C)","Categorie (A/B/C)"]
["E95 - E10","I",22,"N° de dossier technique (cat. B/C)","N° van technisch dossier (cat. B / C)"]
["E95 - E10","J",22,"N° d'enregistrement BDD A.R. 26/11/2011","Inschrijvings N° BDD K.B. 26/11/2011"]
["E95 - E10","B",66,"Notes :","Opmerkingen :"]
["E95 - E10","B",67,"1° Exclusivement les mises à la consommation réellement effectuées au cours du trimestre","1° Enkel de reëel tot verbruik uitgeslagen producten tijdens het trimester "]
["E95 - E10","B",68,"2° Si des volumes sont transférés à un tiers, sous régime de suspension d'accises ou mis","2° Indien volumes naar een derde worden overgebracht, onder schorsing van accijnzen "]
["E95 - E10","B",69,"à la consommation pour le compte d'un tiers, les déclarations décrites dans l'arrêté","of de in verbruikstelling voor rekening van een derde gebeurt, moeten de geschreven "]
["E95 - E10","B",70,"relatif \"aux modalités et aux conditions et obligations concernant la déclaration trimestrielle …\"","verklaringen in het besluit betreffende \"de regels en voorwaarden in verband "]
["E95 - E10","B",71,"doivent impérativement être fournies","met de trimestriële aangifte \" steeds voorzien worden"]
["E95 - E10","B",72,"3° Les volumes à remplir doivent être exprimées en m³ à 15°C","3° De in te vullen gegevens moeten uitgedrukt zijn in m³ bij 15°C"]
["E95 - E10","B",73,"4° Dans le cas où plusieurs types de biocarburants sont en mélange dans un volume de fossile,","4° Als meerdere types biobrandstoffen in een volume fossiel gemengd zijn dient dit volume"]
["E95 - E10","B",74,"ce volume de fossile ne doit être introduit qu'une seule fois dans la colonne E","fossiel slechts één keer in kolom E berekend te worden"]
["E95 - E10","B",75,"5° Le biocarburant réellement mélangé doit être indiqué","5° De werkelijk bijgemengde biobrandstof dient aangegeven te worden"]
["E95 - E10","I",68,": catégorie A",": categorie A"]
["E95 - E10","I",69,": catégorie B",": categorie B"]
["E95 - E10","I",70,": catégorie C",": categorie C"]
["E95 - E10","F",66,"Légende :","Legende :"]
["E95 - E10","F",68,"VR = volume réel","VR = reëel volume "]
["E95 - E10","F",69,"FE = Facteur Énergétique correctif - équivalent bioéthanol","FE = corrigerende Energie Factor - tegenwaarde bio-ethanol"]
["E95 - E10","F",70,"VE = Volume Équivalent bioéthanol = VR x FE","VE = Gelijkwaardig Volume bio-ethanol = VR x FE"]
["E95 - E10","F",71,"FC = Facteur Correctif de catégorie","FC = Corrigerende Factor van de categorie"]
["E95 - E10","F",72,"VN = Volume Nominal = VR x FE x FC = VE x FC","VN = Nominaal volume= VR x FE x FC = VE x FC"]
["E95 - E10","B",77,"Vu pour être annexé à notre arrêté du 15 novembre 2017 relatif à l'exigence de déclaration de biocarburants, d'huiles minérales et de leurs produits de substitution d'origine biologique","Gezien om gevoegd te worden bij ons besluit van 15 november 2017 betreffende de rapportageverplichting van biobrandstoffen, minerale oliën en hun substitutieproducten van biologische oorsprong"]
["E95 - E10","E",109,"de l'Environnement et du Développement durable","Leefmilieu en Duurzame Ontwikkeling"]
["E95 - E10","E",108,"La Ministre de L'Energie,","De Minister van Energie,"]
["E95 - E10","E",88,"Par le Roi :","Van Koningswege :"]
["E95 - E10","B",122,"N° réf.","Ref. N°"]
["E95 - E10","C",122,"Carburant","Brandstof"]
["E95 - E10","D",122,"Contenu énergétique volumique (pouvoir calorifique inférieur, MJ/l)","Energie-inhoud in volume (calorische onderwaarde, MJ/l)"]
["E95 - E10","E",122,"Catégorie","Categorie"]
["E95 - E10","C",123,"Bioéthanol (éthanol produit à partir de biomasse)","Bio-ethanol (ethanol geproduceerd uit biomassa)"]
["E95 - E10","C",124,"Bio-ETBE (éthyl-tertio-butyl-éther produit à partir de bioéthanol)","Bio-ETBE (op basis van bio-ethanol geproduceerde ethyl- tertiair- butylether)"]
["E95 - E10","C",125,"Biométhanol (méthanol produit à partir de biomasse, utilisé comme biocarburant)","Biomethanol (methanol geproduceerd uit biomassa, voor toepassing  als biobrandstof)"]
["E95 - E10","C",126,"Bio-MTBE (méthyl-tertio-butyl-éther produit à partir de biométhanol)","Bio-MTBE(op basis van biomethanol geproduceerde methyl tertiair butyl ether)"]
["E95 - E10","B",131,"(*) En cas d'acceptation du double comptage","(*) Bij aanvaarding van dubbele telling"]
["E95 - E10","C",127,"Bio-DME (diméthyléther produit à partir de biomasse, utilisé comme biocarburant)","Bio-DME(op basis van biomassa geproduceerde dimethylether  voor toepassing  als biobrandstof)"]
["E95 - E10","C",128,"Bio-TAEE (tertioamyléther produit à partir de bioéthanol)","Bio-TAEE (op basis van bio-ethanol geproduceerde ethyl-tertiair amylether)"]
["E95 - E10","C",129,"Biobutanol (butanol produit de biomasse, utilisé comme biocarburant)","Biobutanol (butanol uit biomassa, voor toepassing  als biobrandstof)"]
["E95 - E10","D",124,"27 (dont 37 % issus de sources renouvelables)","27 (waarvan  37 % uit hernieuwbare bronnen)"]
["E95 - E10","D",126,"26 (dont 22 % issus de sources renouvelables)","26 (waarvan  22 % uit hernieuwbare bronnen)"]
["E95 - E10","D",128,"29 (dont 29 % issus de sources renouvelables)","29 (waarvan  29 % uit hernieuwbare bronnen)"]
["E98 - E5","B",2,"Annexe I - Bilan trimestriel relatif à l'obligation d'incorporation de biocarburants dans les quantités d'essence E98 - E5 mises à la consommation","Bijlage I - Trimestriële balans met betrekking tot de verplichte bijmenging van biobrandstoffen in de hoeveelheden benzine E98 - E5 die tot verbruik worden uitgeslagen"]
["E98 - E5","B",5,"TRIMESTRE DE MISES À LA CONSOMMATION (exemple 2017 / Q1)","TRIMESTER VAN DE IN VERBRUIKSTELLING  (voorbeeld 2017 / Q1) :"]
["E98 - E5","E",20,"Si vous remplissez les données dans \"dont part biocarburant\", des lignes seront ajoutées (jusqu'à 40).","Bij het invullen van de gegevens bij \"waarvan biobrandstof\" worden automatisch rijen ingevoegd (tot 40)."]
["E98 - E5","E",8,"à remplir","in te vullen"]
["E98 - E5","F",8,"rempli automatiquement","automatisch ingevuld"]
["E98 - E5","B",8,"IDENTIFICATION DE LA SOCIÉTÉ (siège social) :","IDENTIFICATIE VAN DE MAATSCHAPPIJ (maatschappelijke zetel) :"]
["E98 - E5","B",11,"NOM :","NAAM :"]
["E98 - E5","B",12,"RUE ET N° :","STRAAT EN NR. :"]
["E98 - E5","B",13,"CODE POSTAL","POSTCODE :"]
["E98 - E5","B",14,"LOCALITÉ :","PLAATS :"]
["E98 - E5","B",15,"PERSONNE DE CONTACT :","CONTACTPERSOON :"]
["E98 - E5","B",16,"N° TÉL :","TELNR. :"]
["E98 - E5","B",17,"ADRESSE MAIL :","MAILADRES :"]
["E98 - E5","E",11,"     N° D'ACCISES :","     ACCIJNSNUMMER :"]
["E98 - E5","E",12,"     NOMBRE DE DÉPÔTS :","     AANTAL ENTREPOTNUMMERS :"]
["E98 - E5","E",13,"     N° DE DÉPÔT ET ADRESSE DÉPÔT 1 :","     ENTREPOT EN ADRES NR 1 :"]
["E98 - E5","E",14,"     N° DE DÉPÔT ET ADRESSE DÉPÔT 2 :","     ENTREPOT EN ADRES NR 2 :"]
["E98 - E5","E",15,"     N° DE DÉPÔT ET ADRESSE DÉPÔT 3 :","     ENTREPOT EN ADRES NR 3 :"]
["E98 - E5","B",20,"DONNÉES DES MISES À LA CONSOMMATION (1°) :","GEGEVENS VAN DE IN VERBUIK STELLING (1°) :"]
["E98 - E5","B",22,"N° de ligne","Nr. lijn"]
["E98 - E5","C",22,"Date","Datum"]
["E98 - E5","D",22,"Essence EN228 en mélange (3°): E98 - E5","Gemengde benzine EN228 (3°): E98 - E5"]
["E98 - E5","E",22,"dont part fossile (3°)(4°)","waarvan fossiel (3°)(4°)"]
["E98 - E5","F",22,"dont part biocarburant (2°)(3°)","waarvan biobrandstof (2°)(3°)"]
["E98 - E5","G",22,"Type Bio (voir \"Liste biocarburants durables\") (5°)","Type Bio (zie \"Lijst duurzame biobrandstoffen\") (5°)"]
["E98 - E5","H",22,"Catégorie (A/B/C)","Categorie (A/B/C)"]
["E98 - E5","I",22,"N° de dossier technique (cat. B/C)","N° van technisch dossier (cat. B / C)"]
["E98 - E5","J",22,"N° d'enregistrement BDD A.R. 26/11/2011","Inschrijvings N° BDD K.B. 26/11/2011"]
["E98 - E5","B",66,"Notes :","Opmerkingen :"]
["E98 - E5","B",67,"1° Exclusivement les mises à la consommation réellement effectuées au cours du trimestre","1° Enkel de reëel tot verbruik uitgeslagen producten tijdens het trimester "]
["E98 - E5","B",68,"2° Si des volumes sont transférés à un tiers, sous régime de suspension d'accises ou mis","2° Indien volumes naar een derde worden overgebracht, onder schorsing van accijnzen "]
["E98 - E5","B",69,"à la consommation pour le compte d'un tiers, les déclarations décrites dans l'arrêté","of de in verbruikstelling voor rekening van een derde gebeurt, moeten de geschreven "]
["E98 - E5","B",70,"relatif \"aux modalités et aux conditions et obligations concernant la déclaration trimestrielle …\"","verklaringen in het besluit betreffende \"de regels en voorwaarden in verband "]
["E98 - E5","B",71,"doivent impérativement être fournies","met de trimestriële aangifte \" steeds voorzien worden"]
["E98 - E5","B",72,"3° Les volumes à remplir doivent être exprimées en m³ à 15°C","3° De in te vullen gegevens moeten uitgedrukt zijn in m³ bij 15°C"]
["E98 - E5","B",73,"4° Dans le cas où plusieurs types de biocarburants sont en mélange dans un volume de fossile,","4° Als meerdere types biobrandstoffen in een volume fossiel gemengd zijn dient dit volume"]
["E98 - E5","B",74,"ce volume de fossile ne doit être introduit qu'une seule fois dans la colonne E","fossiel slechts één keer in kolom E berekend te worden"]
["E98 - E5","B",75,"5° Le biocarburant réellement mélangé doit être indiqué","5° De werkelijk bijgemengde biobrandstof dient aangegeven te worden"]
["E98 - E5","I",68,": catégorie A",": categorie A"]
["E98 - E5","I",69,": catégorie B",": categorie B"]
["E98 - E5","I",70,": catégorie C",": categorie C"]
["E98 - E5","F",66,"Légende :","Legende :"]
["E98 - E5","F",68,"VR = volume réel","VR = reëel volume "]
["E98 - E5","F",69,"FE = Facteur Énergétique correctif - équivalent bioéthanol","FE = corrigerende Energie Factor - tegenwaarde bio-ethanol"]
["E98 - E5","F",70,"VE = Volume Équivalent bioéthanol = VR x FE","VE = Gelijkwaardig Volume bio-ethanol = VR x FE"]
["E98 - E5","F",71,"FC = Facteur Correctif de catégorie","FC = Corrigerende Factor van de categorie"]
["E98 - E5","F",72,"VN = Volume Nominal = VR x FE x FC = VE x FC","VN = Nominaal volume= VR x FE x FC = VE x FC"]
["E98 - E5","B",77,"Vu pour être annexé à notre arrêté du 15 novembre 2017 relatif à l'exigence de déclaration de biocarburants, d'huiles minérales et de leurs produits de substitution d'origine biologique","Gezien om gevoegd te worden bij ons besluit van 15 november 2017 betreffende de rapportageverplichting van biobrandstoffen, minerale oliën en hun substitutieproducten van biologische oorsprong"]
["E98 - E5","E",109,"de l'Environnement et du Développement durable","Leefmilieu en Duurzame Ontwikkeling"]
["E98 - E5","E",108,"La Ministre de L'Energie,","De Minister van Energie,"]
["E98 - E5","E",88,"Par le Roi :","Van Koningswege :"]
["E98 - E5","B",122,"N° réf.","Ref. N°"]
["E98 - E5","C",122,"Carburant","Brandstof"]
["E98 - E5","D",122,"Contenu énergétique volumique (pouvoir calorifique inférieur, MJ/l)","Energie-inhoud in volume (calorische onderwaarde, MJ/l)"]
["E98 - E5","E",122,"Catégorie","Categorie"]
["E98 - E5","C",123,"Bioéthanol (éthanol produit à partir de biomasse)","Bio-ethanol (ethanol geproduceerd uit biomassa)"]
["E98 - E5","C",124,"Bio-ETBE (éthyl-tertio-butyl-éther produit à partir de bioéthanol)","Bio-ETBE (op basis van bio-ethanol geproduceerde ethyl- tertiair- butylether)"]
["E98 - E5","C",125,"Biométhanol (méthanol produit à partir de biomasse, utilisé comme biocarburant)","Biomethanol (methanol geproduceerd uit biomassa, voor toepassing  als biobrandstof)"]
["E98 - E5","C",126,"Bio-MTBE (méthyl-tertio-butyl-éther produit à partir de biométhanol)","Bio-MTBE(op basis van biomethanol geproduceerde methyl tertiair butyl ether)"]
["E98 - E5","B",131,"(*) En cas d'acceptation du double comptage","(*) Bij aanvaarding van dubbele telling"]
["E98 - E5","C",127,"Bio-DME (diméthyléther produit à partir de biomasse, utilisé comme biocarburant)","Bio-DME(op basis van biomassa geproduceerde dimethylether  voor toepassing  als biobrandstof)"]
["E98 - E5","C",128,"Bio-TAEE (tertioamyléther produit à partir de bioéthanol)","Bio-TAEE (op basis van bio-ethanol geproduceerde ethyl-tertiair amylether)"]
["E98 - E5","C",129,"Biobutanol (butanol produit de biomasse, utilisé comme biocarburant)","Biobutanol (butanol uit biomassa, voor toepassing  als biobrandstof)"]
["E98 - E5","D",124,"27 (dont 37 % issus de sources renouvelables)","27 (waarvan  37 % uit hernieuwbare bronnen)"]
["E98 - E5","D",128,"29 (dont 29 % issus de sources renouvelables)","29 (waarvan  29 % uit hernieuwbare bronnen)"]
["E98 - E5","D",126,"26 (dont 22 % issus de sources renouvelables)","26 (waarvan  22 % uit hernieuwbare bronnen)"]
["E98 - E10","B",2,"Annexe I - Bilan trimestriel relatif à l'obligation d'incorporation de biocarburants dans les quantités d'essence E98 - E10 mises à la consommation","Bijlage I - Trimestriële balans met betrekking tot de verplichte bijmenging van biobrandstoffen in de hoeveelheden benzine E98 - E10 die tot verbruik worden uitgeslagen"]
["E98 - E10","B",5,"TRIMESTRE DE MISES À LA CONSOMMATION (exemple 2017 / Q1)","TRIMESTER VAN DE IN VERBRUIKSTELLING  (voorbeeld 2017 / Q1) :"]
["E98 - E10","E",20,"Si vous remplissez les données dans \"dont part biocarburant\", des lignes seront ajoutées (jusqu'à 40).","Bij het invullen van de gegevens bij \"waarvan biobrandstof\" worden automatisch rijen ingevoegd (tot 40)."]
["E98 - E10","E",8,"à remplir","in te vullen"]
["E98 - E10","F",8,"rempli automatiquement","automatisch ingevuld"]
["E98 - E10","B",8,"IDENTIFICATION DE LA SOCIÉTÉ (siège social) :","IDENTIFICATIE VAN DE MAATSCHAPPIJ (maatschappelijke zetel) :"]
["E98 - E10","B",11,"NOM :","NAAM :"]
["E98 - E10","B",12,"RUE ET N° :","STRAAT EN NR. :"]
["E98 - E10","B",13,"CODE POSTAL","POSTCODE :"]
["E98 - E10","B",14,"LOCALITÉ :","PLAATS :"]
["E98 - E10","B",15,"PERSONNE DE CONTACT :","CONTACTPERSOON :"]
["E98 - E10","B",16,"N° TÉL :","TELNR. :"]
["E98 - E10","B",17,"ADRESSE MAIL :","MAILADRES :"]
["E98 - E10","E",11,"     N° D'ACCISES :","     ACCIJNSNUMMER :"]
["E98 - E10","E",12,"     NOMBRE DE DÉPÔTS :","     AANTAL ENTREPOTNUMMERS :"]
["E98 - E10","E",13,"     N° DE DÉPÔT ET ADRESSE DÉPÔT 1 :","     ENTREPOT EN ADRES NR 1 :"]
["E98 - E10","E",14,"     N° DE DÉPÔT ET ADRESSE DÉPÔT 2 :","     ENTREPOT EN ADRES NR 2 :"]
["E98 - E10","E",15,"     N° DE DÉPÔT ET ADRESSE DÉPÔT 3 :","     ENTREPOT EN ADRES NR 3 :"]
["E98 - E10","B",20,"DONNÉES DES MISES À LA CONSOMMATION (1°) :","GEGEVENS VAN DE IN VERBUIK STELLING (1°) :"]
["E98 - E10","B",22,"N° de ligne","Nr. lijn"]
["E98 - E10","C",22,"Date","Datum"]
["E98 - E10","D",22,"Essence EN228 en mélange (3°): E98 - E10","Gemengde benzine EN228 (3°): E98 - E10"]
["E98 - E10","E",22,"dont part fossile (3°)(4°)","waarvan fossiel (3°)(4°)"]
["E98 - E10","F",22,"dont part biocarburant (2°)(3°)","waarvan biobrandstof (2°)(3°)"]
["E98 - E10","G",22,"Type Bio (voir \"Liste biocarburants durables\") (5°)","Type Bio (zie \"Lijst duurzame biobrandstoffen\") (5°)"]
["E98 - E10","H",22,"Catégorie (A/B/C)","Categorie (A/B/C)"]
["E98 - E10","I",22,"N° de dossier technique (cat. B/C)","N° van technisch dossier (cat. B / C)"]
["E98 - E10","J",22,"N° d'enregistrement BDD A.R. 26/11/2011","Inschrijvings N° BDD K.B. 26/11/2011"]
["E98 - E10","B",66,"Notes :","Opmerkingen :"]
["E98 - E10","B",67,"1° Exclusivement les mises à la consommation réellement effectuées au cours du trimestre","1° Enkel de reëel tot verbruik uitgeslagen producten tijdens het trimester "]
["E98 - E10","B",68,"2° Si des volumes sont transférés à un tiers, sous régime de suspension d'accises ou mis","2° Indien volumes naar een derde worden overgebracht, onder schorsing van accijnzen "]
["E98 - E10","B",69,"à la consommation pour le compte d'un tiers, les déclarations décrites dans l'arrêté","of de in verbruikstelling voor rekening van een derde gebeurt, moeten de geschreven "]
["E98 - E10","B",70,"relatif \"aux modalités et aux conditions et obligations concernant la déclaration trimestrielle …\"","verklaringen in het besluit betreffende \"de regels en voorwaarden in verband "]
["E98 - E10","B",71,"doivent impérativement être fournies","met de trimestriële aangifte \" steeds voorzien worden"]
["E98 - E10","B",72,"3° Les volumes à remplir doivent être exprimées en m³ à 15°C","3° De in te vullen gegevens moeten uitgedrukt zijn in m³ bij 15°C"]
["E98 - E10","B",73,"4° Dans le cas où plusieurs types de biocarburants sont en mélange dans un volume de fossile,","4° Als meerdere types biobrandstoffen in een volume fossiel gemengd zijn dient dit volume"]
["E98 - E10","B",74,"ce volume de fossile ne doit être introduit qu'une seule fois dans la colonne E","fossiel slechts één keer in kolom E berekend te worden"]
["E98 - E10","B",75,"5° Le biocarburant réellement mélangé doit être indiqué","5° De werkelijk bijgemengde biobrandstof dient aangegeven te worden"]
["E98 - E10","I",68,": catégorie A",": categorie A"]
["E98 - E10","I",69,": catégorie B",": categorie B"]
["E98 - E10","I",70,": catégorie C",": categorie C"]
["E98 - E10","F",66,"Légende :","Legende :"]
["E98 - E10","F",68,"VR = volume réel","VR = reëel volume "]
["E98 - E10","F",69,"FE = Facteur Énergétique correctif - équivalent bioéthanol","FE = corrigerende Energie Factor - tegenwaarde bio-ethanol"]
["E98 - E10","F",70,"VE = Volume Équivalent bioéthanol = VR x FE","VE = Gelijkwaardig Volume bio-ethanol = VR x FE"]
["E98 - E10","F",71,"FC = Facteur Correctif de catégorie","FC = Corrigerende Factor van de categorie"]
["E98 - E10","F",72,"VN = Volume Nominal = VR x FE x FC = VE x FC","VN = Nominaal volume= VR x FE x FC = VE x FC"]
["E98 - E10","B",77,"Vu pour être annexé à notre arrêté du 15 novembre 2017 relatif à l'exigence de déclaration de biocarburants, d'huiles minérales et de leurs produits de substitution d'origine biologique","Gezien om gevoegd te worden bij ons besluit van 15 november 2017 betreffende de rapportageverplichting van biobrandstoffen, minerale oliën en hun substitutieproducten van biologische oorsprong"]
["E98 - E10","E",109,"de l'Environnement et du Développement durable","Leefmilieu en Duurzame Ontwikkeling"]
["E98 - E10","E",108,"La Ministre de L'Energie,","De Minister van Energie,"]
["E98 - E10","E",88,"Par le Roi :","Van Koningswege :"]
["E98 - E10","B",122,"N° réf.","Ref. N°"]
["E98 - E10","C",122,"Carburant","Brandstof"]
["E98 - E10","D",122,"Contenu énergétique volumique (pouvoir calorifique inférieur, MJ/l)","Energie-inhoud in volume (calorische onderwaarde, MJ/l)"]
["E98 - E10","E",122,"Catégorie","Categorie"]
["E98 - E10","C",123,"Bioéthanol (éthanol produit à partir de biomasse)","Bio-ethanol (ethanol geproduceerd uit biomassa)"]
["E98 - E10","C",124,"Bio-ETBE (éthyl-tertio-butyl-éther produit à partir de bioéthanol)","Bio-ETBE (op basis van bio-ethanol geproduceerde ethyl- tertiair- butylether)"]
["E98 - E10","C",125,"Biométhanol (méthanol produit à partir de biomasse, utilisé comme biocarburant)","Biomethanol (methanol geproduceerd uit biomassa, voor toepassing  als biobrandstof)"]
["E98 - E10","C",126,"Bio-MTBE (méthyl-tertio-butyl-éther produit à partir de biométhanol)","Bio-MTBE(op basis van biomethanol geproduceerde methyl tertiair butyl ether)"]
["E98 - E10","B",131,"(*) En cas d'acceptation du double comptage","(*) Bij aanvaarding van dubbele telling"]
["E98 - E10","C",127,"Bio-DME (diméthyléther produit à partir de biomasse, utilisé comme biocarburant)","Bio-DME(op basis van biomassa geproduceerde dimethylether  voor toepassing  als biobrandstof)"]
["E98 - E10","C",128,"Bio-TAEE (tertioamyléther produit à partir de bioéthanol)","Bio-TAEE (op basis van bio-ethanol geproduceerde ethyl-tertiair amylether)"]
["E98 - E10","C",129,"Biobutanol (butanol produit de biomasse, utilisé comme biocarburant)","Biobutanol (butanol uit biomassa, voor toepassing  als biobrandstof)"]
["E98 - E10","D",124,"27 (dont 37 % issus de sources renouvelables)","27 (waarvan  37 % uit hernieuwbare bronnen)"]
["E98 - E10","D",126,"26 (dont 22 % issus de sources renouvelables)","26 (waarvan  22 % uit hernieuwbare bronnen)"]
["E98 - E10","D",128,"29 (dont 29 % issus de sources renouvelables)","29 (waarvan  29 % uit hernieuwbare bronnen)"]
["Bio-ethanol","B",2,"Annexe I - Bilan trimestriel relatif à l'obligation d'incorporation de biocarburants dans les quantités d'essence mises à la consommation","Bijlage I - Trimestriële balans met betrekking tot de verplichte bijmenging van biobrandstoffen in de hoeveelheden benzine die tot verbruik worden uitgeslagen"]
["Bio-ethanol","B",5,"TRIMESTRE DE MISES À LA CONSOMMATION (exemple 2017 / Q1)","TRIMESTER VAN DE IN VERBRUIKSTELLING  (voorbeeld 2017 / Q1) :"]
["Bio-ethanol","B",8,"IDENTIFICATION DE LA SOCIÉTÉ (siège social) :","IDENTIFICATIE VAN DE MAATSCHAPPIJ (maatschappelijke zetel) :"]
["Bio-ethanol","E",8,"à remplir","in te vullen"]
["Bio-ethanol","F",8,"rempli automatiquement","automatisch ingevuld"]
["Bio-ethanol","B",11,"NOM :","NAAM :"]
["Bio-ethanol","B",12,"RUE ET N° :","STRAAT EN NR. :"]
["Bio-ethanol","B",13,"CODE POSTAL","POSTCODE :"]
["Bio-ethanol","B",14,"LOCALITÉ :","PLAATS :"]
["Bio-ethanol","B",15,"PERSONNE DE CONTACT :","CONTACTPERSOON :"]
["Bio-ethanol","B",16,"N° TÉL :","TELNR. :"]
["Bio-ethanol","B",17,"ADRESSE MAIL :","MAILADRES :"]
["Bio-ethanol","D",11,"     N° D'ACCISES :","     ACCIJNSNUMMER :"]
["Bio-ethanol","D",12,"     NOMBRE DE DÉPÔTS :","     AANTAL ENTREPOTNUMMERS :"]
["Bio-ethanol","D",13,"     N° DE DÉPÔT ET ADRESSE DÉPÔT 1 :","     ENTREPOT EN ADRES NR 1 :"]
["Bio-ethanol","D",14,"     N° DE DÉPÔT ET ADRESSE DÉPÔT 2 :","     ENTREPOT EN ADRES NR 2 :"]
["Bio-ethanol","D",15,"     N° DE DÉPÔT ET ADRESSE DÉPÔT 3 :","     ENTREPOT EN ADRES NR 3 :"]
["Bio-ethanol","B",20,"Synthèse :","Synthese :"]
["Bio-ethanol","C",22,"Valeur atteinte (m³)","Bereikte waarde (m³)"]
["Bio-ethanol","D",22,"% atteint","% bereikt"]
["Bio-ethanol","B",30,"VN totale (A+B+C)","VN totaal (A+B+C)"]
["Bio-ethanol","E",29,"Obligation: maximum 1,5 %","Verplichting: maximum 1,5 %"]
["Bio-ethanol","E",30,"Obligation: minimum 8,5 %","Verplichting: minimum 8,5 %"]
["Bio-ethanol","B",26,"VR totale (A+B+C)","VR totaal (A+B+C)"]
["Bio-ethanol","B",32,"Légende :","Legende :"]
["Bio-ethanol","B",34,"VR = volume réel","VR = reëel volume "]
["Bio-ethanol","B",35,"FE = Facteur Énergétique correctif - équivalent bioéthanol","FE = corrigerende Energie Factor - tegenwaarde bio-ethanol"]
["Bio-ethanol","B",36,"VE = Volume Équivalent bioéthanol = VR x FE","VE = Gelijkwaardig Volume bio-ethanol = VR x FE"]
["Bio-ethanol","B",37,"FC = Facteur Correctif de catégorie","FC = Corrigerende Factor van de categorie"]
["Bio-ethanol","B",38,"VN = Volume Nominal = VR x FE x FC = VE x FC","VN = Nominaal volume= VR x FE x FC = VE x FC"]
["Bio-ethanol","E",32,"∆ stocks (*) :","∆ stocks (*) :"]
["Bio-ethanol","D",36,"Catégorie A","Categorie A"]
["Bio-ethanol","D",37,"Catégorie B","Categorie B"]
["Bio-ethanol","D",38,"Catégorie C","Categorie C"]
["Bio-ethanol","E",34,"Stock en début de trim.","Voorraad begin trimester"]
["Bio-ethanol","E",39,"(*) Volumes réels de biocarburants uniquement","(*) Enkel reële volumes biobrandstoffen"]
["Bio-ethanol","F",34,"Achats","Aankopen"]
["Bio-ethanol","F",35,"En mélange","Gemengd"]
["Bio-ethanol","G",35,"Pur","Puur"]
["Bio-ethanol","H",34,"Volumes cédés","Verkopen"]
["Bio-ethanol","H",35,"En mélange","Gemengd"]
["Bio-ethanol","I",35,"Pur","Puur"]
["Bio-ethanol","J",35,"Export","Uitgevoerd"]
["Bio-ethanol","K",34,"Mises à la consommation","Inverbruikstellingen"]
["Bio-ethanol","L",34,"Stock en fin de trimestre","Voorraad eind trimester"]
["Bio-ethanol","B",42,"Vu pour être annexé à notre arrêté du 15 novembre 2017 relatif à l'exigence de déclaration de biocarburants, d'huiles minérales et de leurs produits de substitution d'origine biologique","Gezien om gevoegd te worden bij ons besluit van 15 november 2017 betreffende de rapportageverplichting van biobrandstoffen, minerale oliën en hun substitutieproducten van biologische oorsprong"]
["Bio-ethanol","E",74,"de l'Environnement et du Développement durable","Leefmilieu en Duurzame Ontwikkeling"]
["Bio-ethanol","E",73,"La Ministre de L'Energie,","De Minister van Energie,"]
["Bio-ethanol","E",53,"Par le Roi :","Van Koningswege :"]

{"sheet":"Balans - omzetting","index":7,"n_rows":29,"n_cols":7,"rows_kept":29,"cut":false,"hidden":true,"merged":[[3,5,4,6],[6,0,8,0],[6,1,7,3],[6,4,7,6],[28,1,28,2],[28,3,28,5]]}
[]
["Biobrandstoffen: omzetting van massa naar volume van de inverbruikgestelde hoeveelheden"]
[]
[null,"De biobalans dient per kwartaal ingevuld te worden",null,null,null,"DRIEMAANDELIJKS"]
[null,"(op de laatste werkdag van de maand volgend op het kwartaal)"]
[]
[null,"Diesel (gemengd)",null,null,"Benzine (gemengd)"]
[]
[null,"Petroleumbalans\n(ton)","Biobalans\n(m³)","Berekende massadichtheid (kg/m³)","Petroleumbalans\n(ton)","Biobalans\n(m³)","Berekende massadichtheid (kg/m³)"]
["Januari"]
["Februari"]
["Maart"]
["Q1",{"$f":"B10+B11+B12","v":0},null,{"$f":"IFERROR(B13/C13*1000,0)","v":0},{"$f":"E10+E11+E12","v":0},null,{"$f":"IFERROR(E13/F13*1000,0)","v":0}]
["April"]
["Mei "]
["Juni"]
["Q2",{"$f":"B14+B15+B16","v":0},null,{"$f":"IFERROR(B17/C17*1000,0)","v":0},{"$f":"E14+E15+E16","v":0},null,{"$f":"IFERROR(E17/F17*1000,0)","v":0}]
["Juli"]
["Augustus"]
["September"]
["Q3",{"$f":"B18+B19+B20","v":0},null,{"$f":"IFERROR(B21/C21*1000,0)","v":0},{"$f":"E18+E19+E20","v":0},null,{"$f":"IFERROR(E21/F21*1000,0)","v":0}]
["Oktober"]
["November"]
["December"]
["Q4",{"$f":"B22+B23+B24","v":0},null,{"$f":"IFERROR(B25/C25*1000,0)","v":0},{"$f":"E22+E23+E24","v":0},null,{"$f":"IFERROR(E25/F25*1000,0)","v":0}]
["Totaal",{"$f":"B13+B17+B21+B25","v":0},{"$f":"C13+C17+C21+C25","v":0},{"$f":"IFERROR(B26/C26*1000,0)","v":0},{"$f":"E13+E17+E21+E25","v":0},{"$f":"F13+F17+F21+F25","v":0},{"$f":"IFERROR(E26/F26*1000,0)","v":0}]
[]
[]
[null,"in te vullen",null,"De gegevens worden uitgedrukt bij 15°C"]

{"sheet":"Biodiesel","index":8,"n_rows":177,"n_cols":14,"rows_kept":177,"cut":false,"hidden":true,"merged":[[21,13,22,13],[106,7,106,8],[106,9,106,11],[107,6,108,6],[107,7,107,8],[107,9,107,11],[107,12,108,12],[107,13,108,13],[21,7,22,7],[21,8,22,8],[21,9,22,9],[21,10,22,10],[21,11,22,11],[21,12,22,12],[1,1,1,6],[20,3,20,5],[21,1,22,1],[21,2,22,2],[21,3,22,3],[21,4,22,4],[21,5,22,5],[21,6,22,6],[19,4,19,7]]}
[]
[null,"Bijlage I - Trimestriële balans met betrekking tot de verplichte bijmenging van biobrandstoffen in de hoeveelheden diesel die tot verbruik worden uitgeslagen"]
[]
[]
[null,"TRIMESTER VAN DE IN VERBRUIKSTELLING  (voorbeeld 2017 / Q1) :",null,null,"2017 / Q1"]
[]
[]
[null,"IDENTIFICATIE VAN DE MAATSCHAPPIJ (maatschappelijke zetel) :",null,null,"in te vullen","automatisch ingevuld"]
[]
[]
[null,"NAAM :",null,"Petrol Company","     ACCIJNSNUMMER :",null,"BE0400700968"]
[null,"STRAAT EN NR. :",null,"Stadstraat, 4","     AANTAL ENTREPOTNUMMERS :",null,3]
[null,"POSTCODE :",null,1000,"     ENTREPOT EN ADRES NR 1 :",null,"BE1B000013290 - Stadstraat, 4 - 1000 Brussel"]
[null,"PLAATS :",null,"Brussel","     ENTREPOT EN ADRES NR 2 :",null,"BE1H000013298 - Hasseltweg, 45 - 2018 Antwerpen"]
[null,"CONTACTPERSOON :",null,"Louis Deprez","     ENTREPOT EN ADRES NR 3 :",null,"BE1L000013294 - Bergenlaan, 241 - 3000 Leuven"]
[null,"TELNR. :",null,"02 / 220 45 89"]
[null,"MAILADRES :",null,"louis.deprez@petrolcompany.be"]
[]
[]
[null,"GEGEVENS VAN DE IN VERBUIK STELLING (1°) :",null,null,"Bij het invullen van de gegevens bij \"waarvan biobrandstof\" worden automatisch rijen ingevoegd (tot 80)."]
[]
[null,"Nr. lijn","Datum","Gemengde diesel EN590 (3°)","waarvan fossiel (3°)(4°)","waarvan biobrandstof (2°)(3°)","Type Bio (zie \"Lijst duurzame biobrandstoffen\") (5°)","Categorie (A/B/C)","N° van technisch dossier (cat. B / C)","Inschrijvings N° BDD K.B. 26/11/2011","FE","VE","FC","VN"]
[]
[null,1,"2016-12-11",1000,935,60,"Bio 2","A",null,null,{"$f":"IFERROR(VLOOKUP(G24,$B$171:$G$175,6,),0)","v":1},{"$f":"F24*K24","v":60},{"$f":"IF(OR(H24=\"A\",H24=\"B\"),1,IF(H24=\"C\",2,0))","v":1},{"$f":"L24*M24","v":60}]
[null,2,null,null,null,5,"Bio 10","C",null,null,1.0303030303030303,{"$f":"F25*K25","v":5.1515151515151514},2,{"$f":"L25*M25","v":10.303030303030303}]
[null,3,null,null,null,null,null,null,null,null,0,0,0,0]
[null,4,null,null,null,null,null,null,null,null,0,0,0,0]
[null,5,null,null,null,null,null,null,null,null,0,0,0,0]
[null,6,null,null,null,null,null,null,null,null,0,0,0,0]
[null,7,null,null,null,null,null,null,null,null,0,0,0,0]
[null,8,null,null,null,null,null,null,null,null,0,0,0,0]
[null,9,null,null,null,null,null,null,null,null,0,0,0,0]
[null,10,null,null,null,null,null,null,null,null,0,0,0,0]
[null,11,null,null,null,null,null,null,null,null,0,0,0,0]
[null,12,null,null,null,null,null,null,null,null,0,0,0,0]
[null,13,null,null,null,null,null,null,null,null,0,0,0,0]
[null,14,null,null,null,null,null,null,null,null,0,0,0,0]
[null,15,null,null,null,null,null,null,null,null,0,0,0,0]
[null,16,null,null,null,null,null,null,null,null,0,0,0,0]
[null,17,null,null,null,null,null,null,null,null,0,0,0,0]
[null,18,null,null,null,null,null,null,null,null,0,0,0,0]
[null,19,null,null,null,null,null,null,null,null,0,0,0,0]
[null,20,null,null,null,null,null,null,null,null,0,0,0,0]
[null,21,null,null,null,null,null,null,null,null,0,0,0,0]
[null,22,null,null,null,null,null,null,null,null,0,0,0,0]
[null,23,null,null,null,null,null,null,null,null,0,0,0,0]
[null,24,null,null,null,null,null,null,null,null,0,0,0,0]
[null,25,null,null,null,null,null,null,null,null,0,0,0,0]
[null,26,null,null,null,null,null,null,null,null,0,0,0,0]
[null,27,null,null,null,null,null,null,null,null,0,0,0,0]
[null,28,null,null,null,null,null,null,null,null,0,0,0,0]
[null,29,null,null,null,null,null,null,null,null,0,0,0,0]
[null,30,null,null,null,null,null,null,null,null,0,0,0,0]
[null,31,null,null,null,null,null,null,null,null,0,0,0,0]
[null,32,null,null,null,null,null,null,null,null,0,0,0,0]
[null,33,null,null,null,null,null,null,null,null,{"$f":"IFERROR(VLOOKUP(G56,$B$171:$G$175,6,),0)","v":0},0,{"$f":"IF(OR(H56=\"A\",H56=\"B\"),1,IF(H56=\"C\",2,0))","v":0},0]
[null,34,null,null,null,null,null,null,null,null,0,0,0,0]
[null,35,null,null,null,null,null,null,null,null,0,0,0,0]
[null,36,null,null,null,null,null,null,null,null,0,0,0,0]
[null,37,null,null,null,null,null,null,null,null,0,0,0,0]
[null,38,null,null,null,null,null,null,null,null,0,0,0,0]
[null,39,null,null,null,null,null,null,null,null,0,0,0,0]
[null,40,null,null,null,null,null,null,null,null,0,0,0,0]
[null,41,null,null,null,null,null,null,null,null,0,0,0,0]
[null,42,null,null,null,null,null,null,null,null,0,0,0,0]
[null,43,null,null,null,null,null,null,null,null,0,0,0,0]
[null,44,null,null,null,null,null,null,null,null,0,0,0,0]
[null,45,null,null,null,null,null,null,null,null,0,0,0,0]
[null,46,null,null,null,null,null,null,null,null,0,0,0,0]
[null,47,null,null,null,null,null,null,null,null,0,0,0,0]
[null,48,null,null,null,null,null,null,null,null,0,0,0,0]
[null,49,null,null,null,null,null,null,null,null,0,0,0,0]
[null,50,null,null,null,null,null,null,null,null,0,0,0,0]
[null,51,null,null,null,null,null,null,null,null,0,0,0,0]
[null,52,null,null,null,null,null,null,null,null,0,0,0,0]
[null,53,null,null,null,null,null,null,null,null,0,0,0,0]
[null,54,null,null,null,null,null,null,null,null,0,0,0,0]
[null,55,null,null,null,null,null,null,null,null,0,0,0,0]
[null,56,null,null,null,null,null,null,null,null,0,0,0,0]
[null,57,null,null,null,null,null,null,null,null,0,0,0,0]
[null,58,null,null,null,null,null,null,null,null,0,0,0,0]
[null,59,null,null,null,null,null,null,null,null,0,0,0,0]
[null,60,null,null,null,null,null,null,null,null,0,0,0,0]
[null,61,null,null,null,null,null,null,null,null,0,0,0,0]
[null,62,null,null,null,null,null,null,null,null,0,0,0,0]
[null,63,null,null,null,null,null,null,null,null,0,0,0,0]
[null,64,null,null,null,null,null,null,null,null,0,0,0,0]
[null,65,null,null,null,null,null,null,null,null,{"$f":"IFERROR(VLOOKUP(G88,$B$171:$G$175,6,),0)","v":0},0,{"$f":"IF(OR(H88=\"A\",H88=\"B\"),1,IF(H88=\"C\",2,0))","v":0},0]
[null,66,null,null,null,null,null,null,null,null,0,0,0,0]
[null,67,null,null,null,null,null,null,null,null,0,0,0,0]
[null,68,null,null,null,null,null,null,null,null,0,0,0,0]
[null,69,null,null,null,null,null,null,null,null,0,0,0,0]
[null,70,null,null,null,null,null,null,null,null,0,0,0,0]
[null,71,null,null,null,null,null,null,null,null,0,0,0,0]
[null,72,null,null,null,null,null,null,null,null,0,0,0,0]
[null,73,null,null,null,null,null,null,null,null,0,0,0,0]
[null,74,null,null,null,null,null,null,null,null,0,0,0,0]
[null,75,null,null,null,null,null,null,null,null,0,0,0,0]
[null,76,null,null,null,null,null,null,null,null,0,0,0,0]
[null,77,null,null,null,null,null,null,null,null,0,0,0,0]
[null,78,null,null,null,null,null,null,null,null,0,0,0,0]
[null,79,null,null,null,null,null,null,null,null,0,0,0,0]
[null,80,null,null,null,null,null,null,null,null,0,0,0,0]
[null,"∑",null,{"$f":"SUM(D24:D103)","v":1000},{"$f":"SUM(E24:E103)","v":935},{"$f":"SUM(F24:F103)","v":65},null,null,null,null,null,{"$f":"SUM(L24:L103)","v":65.151515151515156},null,{"$f":"SUM(N24:N103)","v":70.303030303030297}]
[]
[null,"Opmerkingen :",null,null,null,null,"∆ stocks (*) :"]
[null,"1° Enkel de reëel tot verbruik uitgeslagen producten tijdens het trimester ",null,null,null,null,null,"I",null,"II",null,null,"III"]
[null,"2° Indien volumes naar een derde worden overgebracht, onder schorsing van accijnzen ",null,null,null,null,"Voorraad begin trimester","Aankopen",null,"Verkopen",null,null,"Inverbruikstellingen","Voorraad eind trimester"]
[null,"of de in verbruikstelling voor rekening van een derde gebeurt, moeten de geschreven ",null,null,null,null,null,"Gemengd","Puur","Gemengd","Puur","Uitgevoerd"]
[null,"verklaringen in het besluit betreffende \"de regels en voorwaarden in verband ",null,null,null,"Categorie A",200,50,30,10,15,5,{"$f":"SUMIF(H24:H103,\"A\",F24:F103)","v":60},{"$f":"G110+H110+I110-SUM(J110:M110)","v":190}]
[null,"met de trimestriële aangifte \" steeds voorzien worden",null,null,null,"Categorie B",150,30,15,5,10,20,{"$f":"SUMIF(H24:H103,\"b\",F24:F103)","v":0},{"$f":"G111+H111+I111-SUM(J111:M111)","v":160}]
[null,"3° De in te vullen gegevens moeten uitgedrukt zijn in m³ bij 15°C",null,null,null,"Categorie C",100,20,15,5,10,20,{"$f":"SUMIF(H24:H103,\"C\",F24:F103)","v":5},{"$f":"G112+H112+I112-SUM(J112:M112)","v":95}]
[null,"4° Als meerdere types biobrandstoffen in een volume fossiel gemengd zijn dient dit volume",null,null,null,null,"(*) Enkel reële volumes biobrandstoffen"]
[null,"fossiel slechts één keer in kolom E berekend te worden"]
[null,"5° De werkelijk bijgemengde biobrandstof dient aangegeven te worden"]
[null,"Synthese :",null,null,null,null,"Legende :"]
[]
[null,null,"Bereikte waarde (m³)","% bereikt",null,null,"VR = reëel volume ",null,"A",": categorie A"]
[null,"VR",{"$f":"F104","v":65},{"$f":"F104/(D104)","v":6.5000000000000002E-2},null,null,"FE = corrigerende Energie Factor - tegenwaarde FAME",null,"B",": categorie B"]
[null,"VN cat. A",{"$f":"SUMIF(H24:H103,\"A\",N24:N103)","v":60},{"$f":"C120/(E104+L104)","v":5.9990910468110892E-2},null,null,"VE = Gelijkwaardig Volume FAME = VR x FE",null,"C",": categorie C"]
[null,"VN cat. B",{"$f":"SUMIF(H24:H103,\"B\",N24:N103)","v":0},{"$f":"C121/(E104+L104)","v":0},null,null,"FC = Corrigerende Factor van de categorie"]
[null,"VN cat. C",{"$f":"SUMIF(H24:H103,\"C\",N24:N103)","v":10.303030303030303},{"$f":"C122/(E104+L104)","v":1.0301469474322072E-2},"Verplichting: maximum 1,5 %",null,"VN = Nominaal volume= VR x FE x FC = VE x FC"]
[null,"VN totaal (A+B+C)",{"$f":"SUM(C120:C122)","v":70.303030303030297},{"$f":"C123/(E104+L104)","v":7.0292379942432967E-2},"Verplichting: minimum 6 %"]
[]
[]
[null,"Gezien om gevoegd te worden bij ons besluit van 15 november 2017 betreffende de rapportageverplichting van biobrandstoffen, minerale oliën en hun substitutieproducten van biologische oorsprong"]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[null,null,null,null,"Van Koningswege :"]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[null,null,null,null,"De Minister van Energie,"]
[null,null,null,null,"Leefmilieu en Duurzame Ontwikkeling"]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[null,null,null,null,"M.C. MARGHEM"]
[]
[]
[null,"Ref. N°","Brandstof","Energie-inhoud in volume (calorische onderwaarde, MJ/l)","Categorie","FC","FE"]
[null,"Bio 2","Biodiesel (methylester op basis van plantaardig of dierlijke olie, van diesel kwaliteit, voor toepassing  als biobrandstof)",33,"A / C (*)","1 / 2 (*)",{"$f":"D172/33","v":1}]
[null,"Bio 9","Fisher-Tropsch diesel (een synthetische KWS of mengsel van synthetische KWS uit biomassa)",34,"B","1 / 2 (*)",{"$f":"D173/33","v":1.0303030303030303}]
[null,"Bio 10","Waterstofbehandelende plantaardige olie (plantaardige olie die thermochemisch is behandeld met waterstof)",34,"B","1 / 2 (*)",{"$f":"D174/33","v":1.0303030303030303}]
[null,"Bio 11","Zuivere plantaardige olie (olie die uit oliehoudende planten is verkregen door persing, extractie of vergelijkbare procedures, ruw of geraffineerd maar niet chemisch gemodificeerd, voor zover verenigbaar met het betreffende motortype en de overeenkomstige emissie-eisen)",34,"B","1 / 2 (*)",{"$f":"D175/33","v":1.0303030303030303}]
[]
[null,"(*) Bij aanvaarding van dubbele telling"]

{"sheet":"E95 - E5","index":9,"n_rows":131,"n_cols":14,"rows_kept":131,"cut":false,"hidden":true,"merged":[[66,8,66,9],[66,10,66,12],[67,8,67,9],[67,10,67,12],[67,13,68,13],[21,8,22,8],[21,9,22,9],[21,10,22,10],[21,11,22,11],[21,13,22,13],[21,12,22,12],[1,1,1,6],[20,3,20,5],[21,1,22,1],[21,2,22,2],[21,3,22,3],[21,4,22,4],[21,5,22,5],[21,6,22,6],[19,4,19,7],[21,7,22,7]]}
[]
[null,"Bijlage I - Trimestriële balans met betrekking tot de verplichte bijmenging van biobrandstoffen in de hoeveelheden benzine E95 - E5 die tot verbruik worden uitgeslagen"]
[]
[]
[null,"TRIMESTER VAN DE IN VERBRUIKSTELLING  (voorbeeld 2017 / Q1) :",null,null,{"$f":"Biodiesel!E5","v":"2017 / Q1"}]
[]
[]
[null,"IDENTIFICATIE VAN DE MAATSCHAPPIJ (maatschappelijke zetel) :",null,null,"in te vullen","automatisch ingevuld"]
[]
[]
[null,"NAAM :",null,{"$f":"Biodiesel!D11","v":"Petrol Company"},"     ACCIJNSNUMMER :",null,{"$f":"Biodiesel!G11","v":"BE0400700968"}]
[null,"STRAAT EN NR. :",null,{"$f":"Biodiesel!D12","v":"Stadstraat, 4"},"     AANTAL ENTREPOTNUMMERS :",null,{"$f":"Biodiesel!G12","v":3}]
[null,"POSTCODE :",null,{"$f":"Biodiesel!D13","v":1000},"     ENTREPOT EN ADRES NR 1 :",null,{"$f":"Biodiesel!G13","v":"BE1B000013290 - Stadstraat, 4 - 1000 Brussel"}]
[null,"PLAATS :",null,{"$f":"Biodiesel!D14","v":"Brussel"},"     ENTREPOT EN ADRES NR 2 :",null,{"$f":"Biodiesel!G14","v":"BE1H000013298 - Hasseltweg, 45 - 2018 Antwerpen"}]
[null,"CONTACTPERSOON :",null,{"$f":"Biodiesel!D15","v":"Louis Deprez"},"     ENTREPOT EN ADRES NR 3 :",null,{"$f":"Biodiesel!G15","v":"BE1L000013294 - Bergenlaan, 241 - 3000 Leuven"}]
[null,"TELNR. :",null,{"$f":"Biodiesel!D16","v":"02 / 220 45 89"}]
[null,"MAILADRES :",null,{"$f":"Biodiesel!D17","v":"louis.deprez@petrolcompany.be"}]
[]
[]
[null,"GEGEVENS VAN DE IN VERBUIK STELLING (1°) :",null,null,"Bij het invullen van de gegevens bij \"waarvan biobrandstof\" worden automatisch rijen ingevoegd (tot 40)."]
[]
[null,"Nr. lijn","Datum","Gemengde benzine EN228 (3°): E95 - E5","waarvan fossiel (3°)(4°)","waarvan biobrandstof (2°)(3°)","Type Bio (zie \"Lijst duurzame biobrandstoffen\") (5°)","Categorie (A/B/C)","N° van technisch dossier (cat. B / C)","Inschrijvings N° BDD K.B. 26/11/2011","FE","VE","FC","VN"]
[]
[null,1,"2016-12-11",500,450,20,"Bio 1","A",null,null,{"$f":"IFERROR(VLOOKUP(G24,$B$122:$G$129,6,),0)","v":1},{"$f":"IF(G24=\"Bio 3\",F24*K24*0.37,IF(G24=\"Bio 5\",0.22*F24*K24,IF(G24=\"Bio 7\",0.29*F24*K24,F24*K24)))","v":20},{"$f":"IF(OR(H24=\"A\",H24=\"B\"),1,IF(H24=\"C\",2,0))","v":1},{"$f":"L24*M24","v":20}]
[null,2,null,null,null,30,"Bio 3","B",null,null,1.2857142857142858,14.271428571428574,1,14.271428571428574]
[null,3,null,null,null,null,null,null,null,null,0,0,0,0]
[null,4,null,null,null,null,null,null,null,null,0,0,0,0]
[null,5,null,null,null,null,null,null,null,null,0,0,0,0]
[null,6,null,null,null,null,null,null,null,null,0,0,0,0]
[null,7,null,null,null,null,null,null,null,null,0,0,0,0]
[null,8,null,null,null,null,null,null,null,null,0,0,0,0]
[null,9,null,null,null,null,null,null,null,null,0,0,0,0]
[null,10,null,null,null,null,null,null,null,null,0,0,0,0]
[null,11,null,null,null,null,null,null,null,null,0,0,0,0]
[null,12,null,null,null,null,null,null,null,null,0,0,0,0]
[null,13,null,null,null,null,null,null,null,null,0,0,0,0]
[null,14,null,null,null,null,null,null,null,null,0,0,0,0]
[null,15,null,null,null,null,null,null,null,null,0,0,0,0]
[null,16,null,null,null,null,null,null,null,null,0,0,0,0]
[null,17,null,null,null,null,null,null,null,null,0,0,0,0]
[null,18,null,null,null,null,null,null,null,null,0,0,0,0]
[null,19,null,null,null,null,null,null,null,null,0,0,0,0]
[null,20,null,null,null,null,null,null,null,null,0,0,0,0]
[null,21,null,null,null,null,null,null,null,null,0,0,0,0]
[null,22,null,null,null,null,null,null,null,null,0,0,0,0]
[null,23,null,null,null,null,null,null,null,null,0,0,0,0]
[null,24,null,null,null,null,null,null,null,null,0,0,0,0]
[null,25,null,null,null,null,null,null,null,null,0,0,0,0]
[null,26,null,null,null,null,null,null,null,null,0,0,0,0]
[null,27,null,null,null,null,null,null,null,null,0,0,0,0]
[null,28,null,null,null,null,null,null,null,null,0,0,0,0]
[null,29,null,null,null,null,null,null,null,null,0,0,0,0]
[null,30,null,null,null,null,null,null,null,null,0,0,0,0]
[null,31,null,null,null,null,null,null,null,null,0,0,0,0]
[null,32,null,null,null,null,null,null,null,null,0,0,0,0]
[null,33,null,null,null,null,null,null,null,null,0,0,0,0]
[null,34,null,null,null,null,null,null,null,null,0,0,0,0]
[null,35,null,null,null,null,null,null,null,null,0,0,0,0]
[null,36,null,null,null,null,null,null,null,null,0,0,0,0]
[null,37,null,null,null,null,null,null,null,null,0,0,0,0]
[null,38,null,null,null,null,null,null,null,null,0,0,0,0]
[null,39,null,null,null,null,null,null,null,null,0,0,0,0]
[null,40,null,null,null,null,null,null,null,null,0,0,0,0]
[null,"∑",null,{"$f":"SUM(D24:D63)","v":500},{"$f":"SUM(E24:E63)","v":450},{"$f":"SUM(F24:F63)","v":50},null,null,null,null,null,{"$f":"SUM(L24:L63)","v":34.271428571428572},null,{"$f":"SUM(N24:N63)","v":34.271428571428572}]
[]
[null,"Opmerkingen :",null,null,null,"Legende :"]
[null,"1° Enkel de reëel tot verbruik uitgeslagen producten tijdens het trimester "]
[null,"2° Indien volumes naar een derde worden overgebracht, onder schorsing van accijnzen ",null,null,null,"VR = reëel volume ",null,"A",": categorie A"]
[null,"of de in verbruikstelling voor rekening van een derde gebeurt, moeten de geschreven ",null,null,null,"FE = corrigerende Energie Factor - tegenwaarde bio-ethanol",null,"B",": categorie B"]
[null,"verklaringen in het besluit betreffende \"de regels en voorwaarden in verband ",null,null,null,"VE = Gelijkwaardig Volume bio-ethanol = VR x FE",null,"C",": categorie C"]
[null,"met de trimestriële aangifte \" steeds voorzien worden",null,null,null,"FC = Corrigerende Factor van de categorie"]
[null,"3° De in te vullen gegevens moeten uitgedrukt zijn in m³ bij 15°C",null,null,null,"VN = Nominaal volume= VR x FE x FC = VE x FC"]
[null,"4° Als meerdere types biobrandstoffen in een volume fossiel gemengd zijn dient dit volume"]
[null,"fossiel slechts één keer in kolom E berekend te worden"]
[null,"5° De werkelijk bijgemengde biobrandstof dient aangegeven te worden"]
[]
[null,"Gezien om gevoegd te worden bij ons besluit van 15 november 2017 betreffende de rapportageverplichting van biobrandstoffen, minerale oliën en hun substitutieproducten van biologische oorsprong"]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[null,null,null,null,"Van Koningswege :"]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[null,null,null,null,"De Minister van Energie,"]
[null,null,null,null,"Leefmilieu en Duurzame Ontwikkeling"]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[null,null,null,null,"M.C. MARGHEM"]
[]
[]
[null,"Ref. N°","Brandstof","Energie-inhoud in volume (calorische onderwaarde, MJ/l)","Categorie","FC","FE"]
[null,"Bio 1","Bio-ethanol (ethanol geproduceerd uit biomassa)",21,"A / C (*)","1 / 2 (*)",{"$f":"D123/21","v":1}]
[null,"Bio 3","Bio-ETBE (op basis van bio-ethanol geproduceerde ethyl- tertiair- butylether)","27 (waarvan  37 % uit hernieuwbare bronnen)","B / C (*)","1 / 2 (*)",{"$f":"27/21","v":1.2857142857142858}]
[null,"Bio 4","Biomethanol (methanol geproduceerd uit biomassa, voor toepassing  als biobrandstof)",16,"B / C (*)","1 / 2 (*)",{"$f":"D125/21","v":0.76190476190476186}]
[null,"Bio 5","Bio-MTBE(op basis van biomethanol geproduceerde methyl tertiair butyl ether)","26 (waarvan  22 % uit hernieuwbare bronnen)","B / C (*)","1 / 2 (*)",{"$f":"26/21","v":1.2380952380952381}]
[null,"Bio 6","Bio-DME(op basis van biomassa geproduceerde dimethylether  voor toepassing  als biobrandstof)",19,"B","1 / 2 (*)",{"$f":"D127/21","v":0.90476190476190477}]
[null,"Bio 7","Bio-TAEE (op basis van bio-ethanol geproduceerde ethyl-tertiair amylether)","29 (waarvan  29 % uit hernieuwbare bronnen)","B / C (*)","1 / 2 (*)",{"$f":"29/21","v":1.3809523809523809}]
[null,"Bio 8","Biobutanol (butanol uit biomassa, voor toepassing  als biobrandstof)",27,"B","1 / 2 (*)",{"$f":"D129/21","v":1.2857142857142858}]
[]
[null,"(*) Bij aanvaarding van dubbele telling"]

{"sheet":"E95 - E10","index":10,"n_rows":131,"n_cols":14,"rows_kept":131,"cut":false,"hidden":true,"merged":[[66,8,66,9],[66,10,66,12],[67,8,67,9],[67,10,67,12],[67,13,68,13],[21,8,22,8],[21,9,22,9],[21,10,22,10],[21,11,22,11],[21,13,22,13],[21,12,22,12],[1,1,1,6],[20,3,20,5],[21,1,22,1],[21,2,22,2],[21,3,22,3],[21,4,22,4],[21,5,22,5],[21,6,22,6],[19,4,19,7],[21,7,22,7]]}
[]
[null,"Bijlage I - Trimestriële balans met betrekking tot de verplichte bijmenging van biobrandstoffen in de hoeveelheden benzine E95 - E10 die tot verbruik worden uitgeslagen"]
[]
[]
[null,"TRIMESTER VAN DE IN VERBRUIKSTELLING  (voorbeeld 2017 / Q1) :",null,null,{"$f":"Biodiesel!E5","v":"2017 / Q1"}]
[]
[]
[null,"IDENTIFICATIE VAN DE MAATSCHAPPIJ (maatschappelijke zetel) :",null,null,"in te vullen","automatisch ingevuld"]
[]
[]
[null,"NAAM :",null,{"$f":"Biodiesel!D11","v":"Petrol Company"},"     ACCIJNSNUMMER :",null,{"$f":"Biodiesel!G11","v":"BE0400700968"}]
[null,"STRAAT EN NR. :",null,{"$f":"Biodiesel!D12","v":"Stadstraat, 4"},"     AANTAL ENTREPOTNUMMERS :",null,{"$f":"Biodiesel!G12","v":3}]
[null,"POSTCODE :",null,{"$f":"Biodiesel!D13","v":1000},"     ENTREPOT EN ADRES NR 1 :",null,{"$f":"Biodiesel!G13","v":"BE1B000013290 - Stadstraat, 4 - 1000 Brussel"}]
[null,"PLAATS :",null,{"$f":"Biodiesel!D14","v":"Brussel"},"     ENTREPOT EN ADRES NR 2 :",null,{"$f":"Biodiesel!G14","v":"BE1H000013298 - Hasseltweg, 45 - 2018 Antwerpen"}]
[null,"CONTACTPERSOON :",null,{"$f":"Biodiesel!D15","v":"Louis Deprez"},"     ENTREPOT EN ADRES NR 3 :",null,{"$f":"Biodiesel!G15","v":"BE1L000013294 - Bergenlaan, 241 - 3000 Leuven"}]
[null,"TELNR. :",null,{"$f":"Biodiesel!D16","v":"02 / 220 45 89"}]
[null,"MAILADRES :",null,{"$f":"Biodiesel!D17","v":"louis.deprez@petrolcompany.be"}]
[]
[]
[null,"GEGEVENS VAN DE IN VERBUIK STELLING (1°) :",null,null,"Bij het invullen van de gegevens bij \"waarvan biobrandstof\" worden automatisch rijen ingevoegd (tot 40)."]
[]
[null,"Nr. lijn","Datum","Gemengde benzine EN228 (3°): E95 - E10","waarvan fossiel (3°)(4°)","waarvan biobrandstof (2°)(3°)","Type Bio (zie \"Lijst duurzame biobrandstoffen\") (5°)","Categorie (A/B/C)","N° van technisch dossier (cat. B / C)","Inschrijvings N° BDD K.B. 26/11/2011","FE","VE","FC","VN"]
[]
[null,1,"2016-12-11",1000,850,120,"Bio 1","A",null,null,{"$f":"IFERROR(VLOOKUP(G24,$B$122:$G$129,6,),0)","v":1},{"$f":"IF(G24=\"Bio 3\",F24*K24*0.37,IF(G24=\"Bio 5\",0.22*F24*K24,IF(G24=\"Bio 7\",0.29*F24*K24,F24*K24)))","v":120},{"$f":"IF(OR(H24=\"A\",H24=\"B\"),1,IF(H24=\"C\",2,0))","v":1},{"$f":"L24*M24","v":120}]
[null,2,null,null,null,30,"Bio 7","B",null,null,1.3809523809523809,12.014285714285712,1,12.014285714285712]
[null,3,null,null,null,null,null,null,null,null,0,0,0,0]
[null,4,null,null,null,null,null,null,null,null,0,0,0,0]
[null,5,null,null,null,null,null,null,null,null,0,0,0,0]
[null,6,null,null,null,null,null,null,null,null,0,0,0,0]
[null,7,null,null,null,null,null,null,null,null,0,0,0,0]
[null,8,null,null,null,null,null,null,null,null,0,0,0,0]
[null,9,null,null,null,null,null,null,null,null,0,0,0,0]
[null,10,null,null,null,null,null,null,null,null,0,0,0,0]
[null,11,null,null,null,null,null,null,null,null,0,0,0,0]
[null,12,null,null,null,null,null,null,null,null,0,0,0,0]
[null,13,null,null,null,null,null,null,null,null,0,0,0,0]
[null,14,null,null,null,null,null,null,null,null,0,0,0,0]
[null,15,null,null,null,null,null,null,null,null,0,0,0,0]
[null,16,null,null,null,null,null,null,null,null,0,0,0,0]
[null,17,null,null,null,null,null,null,null,null,0,0,0,0]
[null,18,null,null,null,null,null,null,null,null,0,0,0,0]
[null,19,null,null,null,null,null,null,null,null,0,0,0,0]
[null,20,null,null,null,null,null,null,null,null,0,0,0,0]
[null,21,null,null,null,null,null,null,null,null,0,0,0,0]
[null,22,null,null,null,null,null,null,null,null,0,0,0,0]
[null,23,null,null,null,null,null,null,null,null,0,0,0,0]
[null,24,null,null,null,null,null,null,null,null,0,0,0,0]
[null,25,null,null,null,null,null,null,null,null,0,0,0,0]
[null,26,null,null,null,null,null,null,null,null,0,0,0,0]
[null,27,null,null,null,null,null,null,null,null,0,0,0,0]
[null,28,null,null,null,null,null,null,null,null,0,0,0,0]
[null,29,null,null,null,null,null,null,null,null,0,0,0,0]
[null,30,null,null,null,null,null,null,null,null,0,0,0,0]
[null,31,null,null,null,null,null,null,null,null,0,0,0,0]
[null,32,null,null,null,null,null,null,null,null,0,0,0,0]
[null,33,null,null,null,null,null,null,null,null,0,0,0,0]
[null,34,null,null,null,null,null,null,null,null,0,0,0,0]
[null,35,null,null,null,null,null,null,null,null,0,0,0,0]
[null,36,null,null,null,null,null,null,null,null,0,0,0,0]
[null,37,null,null,null,null,null,null,null,null,0,0,0,0]
[null,38,null,null,null,null,null,null,null,null,0,0,0,0]
[null,39,null,null,null,null,null,null,null,null,0,0,0,0]
[null,40,null,null,null,null,null,null,null,null,0,0,0,0]
[null,"∑",null,{"$f":"SUM(D24:D63)","v":1000},{"$f":"SUM(E24:E63)","v":850},{"$f":"SUM(F24:F63)","v":150},null,null,null,null,null,{"$f":"SUM(L24:L63)","v":132.01428571428571},null,{"$f":"SUM(N24:N63)","v":132.01428571428571}]
[]
[null,"Opmerkingen :",null,null,null,"Legende :"]
[null,"1° Enkel de reëel tot verbruik uitgeslagen producten tijdens het trimester "]
[null,"2° Indien volumes naar een derde worden overgebracht, onder schorsing van accijnzen ",null,null,null,"VR = reëel volume ",null,"A",": categorie A"]
[null,"of de in verbruikstelling voor rekening van een derde gebeurt, moeten de geschreven ",null,null,null,"FE = corrigerende Energie Factor - tegenwaarde bio-ethanol",null,"B",": categorie B"]
[null,"verklaringen in het besluit betreffende \"de regels en voorwaarden in verband ",null,null,null,"VE = Gelijkwaardig Volume bio-ethanol = VR x FE",null,"C",": categorie C"]
[null,"met de trimestriële aangifte \" steeds voorzien worden",null,null,null,"FC = Corrigerende Factor van de categorie"]
[null,"3° De in te vullen gegevens moeten uitgedrukt zijn in m³ bij 15°C",null,null,null,"VN = Nominaal volume= VR x FE x FC = VE x FC"]
[null,"4° Als meerdere types biobrandstoffen in een volume fossiel gemengd zijn dient dit volume"]
[null,"fossiel slechts één keer in kolom E berekend te worden"]
[null,"5° De werkelijk bijgemengde biobrandstof dient aangegeven te worden"]
[]
[null,"Gezien om gevoegd te worden bij ons besluit van 15 november 2017 betreffende de rapportageverplichting van biobrandstoffen, minerale oliën en hun substitutieproducten van biologische oorsprong"]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[null,null,null,null,"Van Koningswege :"]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[null,null,null,null,"De Minister van Energie,"]
[null,null,null,null,"Leefmilieu en Duurzame Ontwikkeling"]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[null,null,null,null,"M.C. MARGHEM"]
[]
[]
[null,"Ref. N°","Brandstof","Energie-inhoud in volume (calorische onderwaarde, MJ/l)","Categorie","FC","FE"]
[null,"Bio 1","Bio-ethanol (ethanol geproduceerd uit biomassa)",21,"A / C (*)","1 / 2 (*)",{"$f":"D123/21","v":1}]
[null,"Bio 3","Bio-ETBE (op basis van bio-ethanol geproduceerde ethyl- tertiair- butylether)","27 (waarvan  37 % uit hernieuwbare bronnen)","B / C (*)","1 / 2 (*)",{"$f":"27/21","v":1.2857142857142858}]
[null,"Bio 4","Biomethanol (methanol geproduceerd uit biomassa, voor toepassing  als biobrandstof)",16,"B / C (*)","1 / 2 (*)",{"$f":"D125/21","v":0.76190476190476186}]
[null,"Bio 5","Bio-MTBE(op basis van biomethanol geproduceerde methyl tertiair butyl ether)","26 (waarvan  22 % uit hernieuwbare bronnen)","B / C (*)","1 / 2 (*)",{"$f":"26/21","v":1.2380952380952381}]
[null,"Bio 6","Bio-DME(op basis van biomassa geproduceerde dimethylether  voor toepassing  als biobrandstof)",19,"B","1 / 2 (*)",{"$f":"D127/21","v":0.90476190476190477}]
[null,"Bio 7","Bio-TAEE (op basis van bio-ethanol geproduceerde ethyl-tertiair amylether)","29 (waarvan  29 % uit hernieuwbare bronnen)","B / C (*)","1 / 2 (*)",{"$f":"29/21","v":1.3809523809523809}]
[null,"Bio 8","Biobutanol (butanol uit biomassa, voor toepassing  als biobrandstof)",27,"B","1 / 2 (*)",{"$f":"D129/21","v":1.2857142857142858}]
[]
[null,"(*) Bij aanvaarding van dubbele telling"]

{"sheet":"E98 - E5","index":11,"n_rows":131,"n_cols":14,"rows_kept":131,"cut":false,"hidden":true,"merged":[[66,8,66,9],[66,10,66,12],[67,8,67,9],[67,10,67,12],[67,13,68,13],[21,8,22,8],[21,9,22,9],[21,10,22,10],[21,11,22,11],[21,13,22,13],[21,12,22,12],[1,1,1,6],[20,3,20,5],[21,1,22,1],[21,2,22,2],[21,3,22,3],[21,4,22,4],[21,5,22,5],[21,6,22,6],[19,4,19,7],[21,7,22,7]]}
[]
[null,"Bijlage I - Trimestriële balans met betrekking tot de verplichte bijmenging van biobrandstoffen in de hoeveelheden benzine E98 - E5 die tot verbruik worden uitgeslagen"]
[]
[]
[null,"TRIMESTER VAN DE IN VERBRUIKSTELLING  (voorbeeld 2017 / Q1) :",null,null,{"$f":"Biodiesel!E5","v":"2017 / Q1"}]
[]
[]
[null,"IDENTIFICATIE VAN DE MAATSCHAPPIJ (maatschappelijke zetel) :",null,null,"in te vullen","automatisch ingevuld"]
[]
[]
[null,"NAAM :",null,{"$f":"Biodiesel!D11","v":"Petrol Company"},"     ACCIJNSNUMMER :",null,{"$f":"Biodiesel!G11","v":"BE0400700968"}]
[null,"STRAAT EN NR. :",null,{"$f":"Biodiesel!D12","v":"Stadstraat, 4"},"     AANTAL ENTREPOTNUMMERS :",null,{"$f":"Biodiesel!G12","v":3}]
[null,"POSTCODE :",null,{"$f":"Biodiesel!D13","v":1000},"     ENTREPOT EN ADRES NR 1 :",null,{"$f":"Biodiesel!G13","v":"BE1B000013290 - Stadstraat, 4 - 1000 Brussel"}]
[null,"PLAATS :",null,{"$f":"Biodiesel!D14","v":"Brussel"},"     ENTREPOT EN ADRES NR 2 :",null,{"$f":"Biodiesel!G14","v":"BE1H000013298 - Hasseltweg, 45 - 2018 Antwerpen"}]
[null,"CONTACTPERSOON :",null,{"$f":"Biodiesel!D15","v":"Louis Deprez"},"     ENTREPOT EN ADRES NR 3 :",null,{"$f":"Biodiesel!G15","v":"BE1L000013294 - Bergenlaan, 241 - 3000 Leuven"}]
[null,"TELNR. :",null,{"$f":"Biodiesel!D16","v":"02 / 220 45 89"}]
[null,"MAILADRES :",null,{"$f":"Biodiesel!D17","v":"louis.deprez@petrolcompany.be"}]
[]
[]
[null,"GEGEVENS VAN DE IN VERBUIK STELLING (1°) :",null,null,"Bij het invullen van de gegevens bij \"waarvan biobrandstof\" worden automatisch rijen ingevoegd (tot 40)."]
[]
[null,"Nr. lijn","Datum","Gemengde benzine EN228 (3°): E98 - E5","waarvan fossiel (3°)(4°)","waarvan biobrandstof (2°)(3°)","Type Bio (zie \"Lijst duurzame biobrandstoffen\") (5°)","Categorie (A/B/C)","N° van technisch dossier (cat. B / C)","Inschrijvings N° BDD K.B. 26/11/2011","FE","VE","FC","VN"]
[]
[null,1,"2016-12-11",500,450,20,"Bio 1","A",null,null,{"$f":"IFERROR(VLOOKUP(G24,$B$122:$G$129,6,),0)","v":1},{"$f":"IF(G24=\"Bio 3\",F24*K24*0.37,IF(G24=\"Bio 5\",0.22*F24*K24,IF(G24=\"Bio 7\",0.29*F24*K24,F24*K24)))","v":20},{"$f":"IF(OR(H24=\"A\",H24=\"B\"),1,IF(H24=\"C\",2,0))","v":1},{"$f":"L24*M24","v":20}]
[null,2,null,null,null,30,"Bio 7","C",null,null,1.3809523809523809,12.014285714285712,2,24.028571428571425]
[null,3,null,null,null,null,null,null,null,null,0,0,0,0]
[null,4,null,null,null,null,null,null,null,null,0,0,0,0]
[null,5,null,null,null,null,null,null,null,null,0,0,0,0]
[null,6,null,null,null,null,null,null,null,null,0,0,0,0]
[null,7,null,null,null,null,null,null,null,null,0,0,0,0]
[null,8,null,null,null,null,null,null,null,null,0,0,0,0]
[null,9,null,null,null,null,null,null,null,null,0,0,0,0]
[null,10,null,null,null,null,null,null,null,null,0,0,0,0]
[null,11,null,null,null,null,null,null,null,null,0,0,0,0]
[null,12,null,null,null,null,null,null,null,null,0,0,0,0]
[null,13,null,null,null,null,null,null,null,null,0,0,0,0]
[null,14,null,null,null,null,null,null,null,null,0,0,0,0]
[null,15,null,null,null,null,null,null,null,null,0,0,0,0]
[null,16,null,null,null,null,null,null,null,null,0,0,0,0]
[null,17,null,null,null,null,null,null,null,null,0,0,0,0]
[null,18,null,null,null,null,null,null,null,null,0,0,0,0]
[null,19,null,null,null,null,null,null,null,null,0,0,0,0]
[null,20,null,null,null,null,null,null,null,null,0,0,0,0]
[null,21,null,null,null,null,null,null,null,null,0,0,0,0]
[null,22,null,null,null,null,null,null,null,null,0,0,0,0]
[null,23,null,null,null,null,null,null,null,null,0,0,0,0]
[null,24,null,null,null,null,null,null,null,null,0,0,0,0]
[null,25,null,null,null,null,null,null,null,null,0,0,0,0]
[null,26,null,null,null,null,null,null,null,null,0,0,0,0]
[null,27,null,null,null,null,null,null,null,null,0,0,0,0]
[null,28,null,null,null,null,null,null,null,null,0,0,0,0]
[null,29,null,null,null,null,null,null,null,null,0,0,0,0]
[null,30,null,null,null,null,null,null,null,null,0,0,0,0]
[null,31,null,null,null,null,null,null,null,null,0,0,0,0]
[null,32,null,null,null,null,null,null,null,null,0,0,0,0]
[null,33,null,null,null,null,null,null,null,null,0,0,0,0]
[null,34,null,null,null,null,null,null,null,null,0,0,0,0]
[null,35,null,null,null,null,null,null,null,null,0,0,0,0]
[null,36,null,null,null,null,null,null,null,null,0,0,0,0]
[null,37,null,null,null,null,null,null,null,null,0,0,0,0]
[null,38,null,null,null,null,null,null,null,null,0,0,0,0]
[null,39,null,null,null,null,null,null,null,null,0,0,0,0]
[null,40,null,null,null,null,null,null,null,null,0,0,0,0]
[null,"∑",null,{"$f":"SUM(D24:D63)","v":500},{"$f":"SUM(E24:E63)","v":450},{"$f":"SUM(F24:F63)","v":50},null,null,null,null,null,{"$f":"SUM(L24:L63)","v":32.014285714285712},null,{"$f":"SUM(N24:N63)","v":44.028571428571425}]
[]
[null,"Opmerkingen :",null,null,null,"Legende :"]
[null,"1° Enkel de reëel tot verbruik uitgeslagen producten tijdens het trimester "]
[null,"2° Indien volumes naar een derde worden overgebracht, onder schorsing van accijnzen ",null,null,null,"VR = reëel volume ",null,"A",": categorie A"]
[null,"of de in verbruikstelling voor rekening van een derde gebeurt, moeten de geschreven ",null,null,null,"FE = corrigerende Energie Factor - tegenwaarde bio-ethanol",null,"B",": categorie B"]
[null,"verklaringen in het besluit betreffende \"de regels en voorwaarden in verband ",null,null,null,"VE = Gelijkwaardig Volume bio-ethanol = VR x FE",null,"C",": categorie C"]
[null,"met de trimestriële aangifte \" steeds voorzien worden",null,null,null,"FC = Corrigerende Factor van de categorie"]
[null,"3° De in te vullen gegevens moeten uitgedrukt zijn in m³ bij 15°C",null,null,null,"VN = Nominaal volume= VR x FE x FC = VE x FC"]
[null,"4° Als meerdere types biobrandstoffen in een volume fossiel gemengd zijn dient dit volume"]
[null,"fossiel slechts één keer in kolom E berekend te worden"]
[null,"5° De werkelijk bijgemengde biobrandstof dient aangegeven te worden"]
[]
[null,"Gezien om gevoegd te worden bij ons besluit van 15 november 2017 betreffende de rapportageverplichting van biobrandstoffen, minerale oliën en hun substitutieproducten van biologische oorsprong"]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[null,null,null,null,"Van Koningswege :"]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[null,null,null,null,"De Minister van Energie,"]
[null,null,null,null,"Leefmilieu en Duurzame Ontwikkeling"]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[null,null,null,null,"M.C. MARGHEM"]
[]
[]
[null,"Ref. N°","Brandstof","Energie-inhoud in volume (calorische onderwaarde, MJ/l)","Categorie","FC","FE"]
[null,"Bio 1","Bio-ethanol (ethanol geproduceerd uit biomassa)",21,"A / C (*)","1 / 2 (*)",{"$f":"D123/21","v":1}]
[null,"Bio 3","Bio-ETBE (op basis van bio-ethanol geproduceerde ethyl- tertiair- butylether)","27 (waarvan  37 % uit hernieuwbare bronnen)","B / C (*)","1 / 2 (*)",{"$f":"27/21","v":1.2857142857142858}]
[null,"Bio 4","Biomethanol (methanol geproduceerd uit biomassa, voor toepassing  als biobrandstof)",16,"B / C (*)","1 / 2 (*)",{"$f":"D125/21","v":0.76190476190476186}]
[null,"Bio 5","Bio-MTBE(op basis van biomethanol geproduceerde methyl tertiair butyl ether)","26 (waarvan  22 % uit hernieuwbare bronnen)","B / C (*)","1 / 2 (*)",{"$f":"26/21","v":1.2380952380952381}]
[null,"Bio 6","Bio-DME(op basis van biomassa geproduceerde dimethylether  voor toepassing  als biobrandstof)",19,"B","1 / 2 (*)",{"$f":"D127/21","v":0.90476190476190477}]
[null,"Bio 7","Bio-TAEE (op basis van bio-ethanol geproduceerde ethyl-tertiair amylether)","29 (waarvan  29 % uit hernieuwbare bronnen)","B / C (*)","1 / 2 (*)",{"$f":"29/21","v":1.3809523809523809}]
[null,"Bio 8","Biobutanol (butanol uit biomassa, voor toepassing  als biobrandstof)",27,"B","1 / 2 (*)",{"$f":"D129/21","v":1.2857142857142858}]
[]
[null,"(*) Bij aanvaarding van dubbele telling"]

{"sheet":"E98 - E10","index":12,"n_rows":131,"n_cols":14,"rows_kept":131,"cut":false,"hidden":true,"merged":[[21,8,22,8],[21,9,22,9],[21,10,22,10],[21,11,22,11],[67,14,68,14],[21,13,22,13],[66,8,66,9],[66,10,66,12],[67,8,67,9],[67,10,67,12],[67,13,68,13],[21,12,22,12],[1,1,1,6],[20,3,20,5],[21,1,22,1],[21,2,22,2],[21,3,22,3],[21,4,22,4],[21,5,22,5],[21,6,22,6],[19,4,19,7],[21,7,22,7]]}
[]
[null,"Bijlage I - Trimestriële balans met betrekking tot de verplichte bijmenging van biobrandstoffen in de hoeveelheden benzine E98 - E10 die tot verbruik worden uitgeslagen"]
[]
[]
[null,"TRIMESTER VAN DE IN VERBRUIKSTELLING  (voorbeeld 2017 / Q1) :",null,null,{"$f":"Biodiesel!E5","v":"2017 / Q1"}]
[]
[]
[null,"IDENTIFICATIE VAN DE MAATSCHAPPIJ (maatschappelijke zetel) :",null,null,"in te vullen","automatisch ingevuld"]
[]
[]
[null,"NAAM :",null,{"$f":"Biodiesel!D11","v":"Petrol Company"},"     ACCIJNSNUMMER :",null,{"$f":"Biodiesel!G11","v":"BE0400700968"}]
[null,"STRAAT EN NR. :",null,{"$f":"Biodiesel!D12","v":"Stadstraat, 4"},"     AANTAL ENTREPOTNUMMERS :",null,{"$f":"Biodiesel!G12","v":3}]
[null,"POSTCODE :",null,{"$f":"Biodiesel!D13","v":1000},"     ENTREPOT EN ADRES NR 1 :",null,{"$f":"Biodiesel!G13","v":"BE1B000013290 - Stadstraat, 4 - 1000 Brussel"}]
[null,"PLAATS :",null,{"$f":"Biodiesel!D14","v":"Brussel"},"     ENTREPOT EN ADRES NR 2 :",null,{"$f":"Biodiesel!G14","v":"BE1H000013298 - Hasseltweg, 45 - 2018 Antwerpen"}]
[null,"CONTACTPERSOON :",null,{"$f":"Biodiesel!D15","v":"Louis Deprez"},"     ENTREPOT EN ADRES NR 3 :",null,{"$f":"Biodiesel!G15","v":"BE1L000013294 - Bergenlaan, 241 - 3000 Leuven"}]
[null,"TELNR. :",null,{"$f":"Biodiesel!D16","v":"02 / 220 45 89"}]
[null,"MAILADRES :",null,{"$f":"Biodiesel!D17","v":"louis.deprez@petrolcompany.be"}]
[]
[]
[null,"GEGEVENS VAN DE IN VERBUIK STELLING (1°) :",null,null,"Bij het invullen van de gegevens bij \"waarvan biobrandstof\" worden automatisch rijen ingevoegd (tot 40)."]
[]
[null,"Nr. lijn","Datum","Gemengde benzine EN228 (3°): E98 - E10","waarvan fossiel (3°)(4°)","waarvan biobrandstof (2°)(3°)","Type Bio (zie \"Lijst duurzame biobrandstoffen\") (5°)","Categorie (A/B/C)","N° van technisch dossier (cat. B / C)","Inschrijvings N° BDD K.B. 26/11/2011","FE","VE","FC","VN"]
[]
[null,1,"2016-12-11",1000,950,40,"Bio 1","A",null,null,{"$f":"IFERROR(VLOOKUP(G24,$B$122:$G$129,6,),0)","v":1},{"$f":"IF(G24=\"Bio 3\",F24*K24*0.37,IF(G24=\"Bio 5\",0.22*F24*K24,IF(G24=\"Bio 7\",0.29*F24*K24,F24*K24)))","v":40},{"$f":"IF(OR(H24=\"A\",H24=\"B\"),1,IF(H24=\"C\",2,0))","v":1},{"$f":"L24*M24","v":40}]
[null,2,null,null,null,10,"Bio 7","C",null,null,1.3809523809523809,4.0047619047619047,2,{"$f":"L25*M25","v":8.0095238095238095}]
[null,3,null,null,null,null,null,null,null,null,0,0,0,0]
[null,4,null,null,null,null,null,null,null,null,0,0,0,0]
[null,5,null,null,null,null,null,null,null,null,0,0,0,0]
[null,6,null,null,null,null,null,null,null,null,0,0,0,0]
[null,7,null,null,null,null,null,null,null,null,0,0,0,0]
[null,8,null,null,null,null,null,null,null,null,0,0,0,0]
[null,9,null,null,null,null,null,null,null,null,0,0,0,0]
[null,10,null,null,null,null,null,null,null,null,0,0,0,0]
[null,11,null,null,null,null,null,null,null,null,0,0,0,0]
[null,12,null,null,null,null,null,null,null,null,0,0,0,0]
[null,13,null,null,null,null,null,null,null,null,0,0,0,0]
[null,14,null,null,null,null,null,null,null,null,0,0,0,0]
[null,15,null,null,null,null,null,null,null,null,0,0,0,0]
[null,16,null,null,null,null,null,null,null,null,0,0,0,0]
[null,17,null,null,null,null,null,null,null,null,0,0,0,0]
[null,18,null,null,null,null,null,null,null,null,0,0,0,0]
[null,19,null,null,null,null,null,null,null,null,0,0,0,0]
[null,20,null,null,null,null,null,null,null,null,0,0,0,0]
[null,21,null,null,null,null,null,null,null,null,0,0,0,0]
[null,22,null,null,null,null,null,null,null,null,0,0,0,0]
[null,23,null,null,null,null,null,null,null,null,0,0,0,0]
[null,24,null,null,null,null,null,null,null,null,0,0,0,0]
[null,25,null,null,null,null,null,null,null,null,0,0,0,0]
[null,26,null,null,null,null,null,null,null,null,0,0,0,0]
[null,27,null,null,null,null,null,null,null,null,0,0,0,0]
[null,28,null,null,null,null,null,null,null,null,0,0,0,0]
[null,29,null,null,null,null,null,null,null,null,0,0,0,0]
[null,30,null,null,null,null,null,null,null,null,0,0,0,0]
[null,31,null,null,null,null,null,null,null,null,0,0,0,0]
[null,32,null,null,null,null,null,null,null,null,0,0,0,0]
[null,33,null,null,null,null,null,null,null,null,0,0,0,0]
[null,34,null,null,null,null,null,null,null,null,0,0,0,0]
[null,35,null,null,null,null,null,null,null,null,0,0,0,0]
[null,36,null,null,null,null,null,null,null,null,0,0,0,0]
[null,37,null,null,null,null,null,null,null,null,0,0,0,0]
[null,38,null,null,null,null,null,null,null,null,0,0,0,0]
[null,39,null,null,null,null,null,null,null,null,0,0,0,0]
[null,40,null,null,null,null,null,null,null,null,0,0,0,0]
[null,"∑",null,{"$f":"SUM(D24:D63)","v":1000},{"$f":"SUM(E24:E63)","v":950},{"$f":"SUM(F24:F63)","v":50},null,null,null,null,null,{"$f":"SUM(L24:L63)","v":44.004761904761907},null,{"$f":"SUM(N24:N63)","v":48.009523809523813}]
[]
[null,"Opmerkingen :",null,null,null,"Legende :"]
[null,"1° Enkel de reëel tot verbruik uitgeslagen producten tijdens het trimester "]
[null,"2° Indien volumes naar een derde worden overgebracht, onder schorsing van accijnzen ",null,null,null,"VR = reëel volume ",null,"A",": categorie A"]
[null,"of de in verbruikstelling voor rekening van een derde gebeurt, moeten de geschreven ",null,null,null,"FE = corrigerende Energie Factor - tegenwaarde bio-ethanol",null,"B",": categorie B"]
[null,"verklaringen in het besluit betreffende \"de regels en voorwaarden in verband ",null,null,null,"VE = Gelijkwaardig Volume bio-ethanol = VR x FE",null,"C",": categorie C"]
[null,"met de trimestriële aangifte \" steeds voorzien worden",null,null,null,"FC = Corrigerende Factor van de categorie"]
[null,"3° De in te vullen gegevens moeten uitgedrukt zijn in m³ bij 15°C",null,null,null,"VN = Nominaal volume= VR x FE x FC = VE x FC"]
[null,"4° Als meerdere types biobrandstoffen in een volume fossiel gemengd zijn dient dit volume"]
[null,"fossiel slechts één keer in kolom E berekend te worden"]
[null,"5° De werkelijk bijgemengde biobrandstof dient aangegeven te worden"]
[]
[null,"Gezien om gevoegd te worden bij ons besluit van 15 november 2017 betreffende de rapportageverplichting van biobrandstoffen, minerale oliën en hun substitutieproducten van biologische oorsprong"]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[null,null,null,null,"Van Koningswege :"]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[null,null,null,null,"De Minister van Energie,"]
[null,null,null,null,"Leefmilieu en Duurzame Ontwikkeling"]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[null,null,null,null,"M.C. MARGHEM"]
[]
[]
[null,"Ref. N°","Brandstof","Energie-inhoud in volume (calorische onderwaarde, MJ/l)","Categorie","FC","FE"]
[null,"Bio 1","Bio-ethanol (ethanol geproduceerd uit biomassa)",21,"A / C (*)","1 / 2 (*)",{"$f":"D123/21","v":1}]
[null,"Bio 3","Bio-ETBE (op basis van bio-ethanol geproduceerde ethyl- tertiair- butylether)","27 (waarvan  37 % uit hernieuwbare bronnen)","B / C (*)","1 / 2 (*)",{"$f":"27/21","v":1.2857142857142858}]
[null,"Bio 4","Biomethanol (methanol geproduceerd uit biomassa, voor toepassing  als biobrandstof)",16,"B / C (*)","1 / 2 (*)",{"$f":"D125/21","v":0.76190476190476186}]
[null,"Bio 5","Bio-MTBE(op basis van biomethanol geproduceerde methyl tertiair butyl ether)","26 (waarvan  22 % uit hernieuwbare bronnen)","B / C (*)","1 / 2 (*)",{"$f":"26/21","v":1.2380952380952381}]
[null,"Bio 6","Bio-DME(op basis van biomassa geproduceerde dimethylether  voor toepassing  als biobrandstof)",19,"B","1 / 2 (*)",{"$f":"D127/21","v":0.90476190476190477}]
[null,"Bio 7","Bio-TAEE (op basis van bio-ethanol geproduceerde ethyl-tertiair amylether)","29 (waarvan  29 % uit hernieuwbare bronnen)","B / C (*)","1 / 2 (*)",{"$f":"29/21","v":1.3809523809523809}]
[null,"Bio 8","Biobutanol (butanol uit biomassa, voor toepassing  als biobrandstof)",27,"B","1 / 2 (*)",{"$f":"D129/21","v":1.2857142857142858}]
[]
[null,"(*) Bij aanvaarding van dubbele telling"]

{"sheet":"Bio-ethanol","index":13,"n_rows":84,"n_cols":12,"rows_kept":84,"cut":false,"hidden":true,"merged":[[33,10,34,10],[33,11,34,11],[1,1,1,6],[32,5,32,6],[32,7,32,9],[33,4,34,4],[33,5,33,6],[33,7,33,9]]}
[]
[null,"Bijlage I - Trimestriële balans met betrekking tot de verplichte bijmenging van biobrandstoffen in de hoeveelheden benzine die tot verbruik worden uitgeslagen"]
[]
[]
[null,"TRIMESTER VAN DE IN VERBRUIKSTELLING  (voorbeeld 2017 / Q1) :",null,null,{"$f":"Biodiesel!E5","v":"2017 / Q1"}]
[]
[]
[null,"IDENTIFICATIE VAN DE MAATSCHAPPIJ (maatschappelijke zetel) :",null,null,"in te vullen","automatisch ingevuld"]
[]
[]
[null,"NAAM :",{"$f":"Biodiesel!D11","v":"Petrol Company"},"     ACCIJNSNUMMER :",{"$f":"Biodiesel!G11","v":"BE0400700968"}]
[null,"STRAAT EN NR. :",{"$f":"Biodiesel!D12","v":"Stadstraat, 4"},"     AANTAL ENTREPOTNUMMERS :",{"$f":"Biodiesel!G12","v":3}]
[null,"POSTCODE :",{"$f":"Biodiesel!D13","v":1000},"     ENTREPOT EN ADRES NR 1 :",{"$f":"Biodiesel!G13","v":"BE1B000013290 - Stadstraat, 4 - 1000 Brussel"}]
[null,"PLAATS :",{"$f":"Biodiesel!D14","v":"Brussel"},"     ENTREPOT EN ADRES NR 2 :",{"$f":"Biodiesel!G14","v":"BE1H000013298 - Hasseltweg, 45 - 2018 Antwerpen"}]
[null,"CONTACTPERSOON :",{"$f":"Biodiesel!D15","v":"Louis Deprez"},"     ENTREPOT EN ADRES NR 3 :",{"$f":"Biodiesel!G15","v":"BE1L000013294 - Bergenlaan, 241 - 3000 Leuven"}]
[null,"TELNR. :",{"$f":"Biodiesel!D16","v":"02 / 220 45 89"}]
[null,"MAILADRES :",{"$f":"Biodiesel!D17","v":"louis.deprez@petrolcompany.be"}]
[]
[]
[null,"Synthese :"]
[]
[null,null,"Bereikte waarde (m³)","% bereikt"]
[null,"VR cat. A",{"$f":"SUMIF('E95 - E5'!H24:H63,\"A\",'E95 - E5'!F24:F63)+SUMIF('E95 - E10'!H24:H63,\"A\",'E95 - E10'!F24:F63)+SUMIF('E98 - E5'!H24:H63,\"A\",'E98 - E5'!F24:F63)+SUMIF('E98 - E10'!H24:H63,\"A\",'E98 - E10'!F24:F63)","v":200},{"$f":"C23/('E95 - E5'!D$64+'E95 - E10'!D$64+'E98 - E5'!D$64+'E98 - E10'!D$64)","v":6.6666666666666666E-2}]
[null,"VR cat. B",{"$f":"SUMIF('E95 - E5'!H24:H63,\"B\",'E95 - E5'!F24:F63)+SUMIF('E95 - E10'!H24:H63,\"B\",'E95 - E10'!F24:F63)+SUMIF('E98 - E5'!H24:H63,\"B\",'E98 - E5'!F24:F63)+SUMIF('E98 - E10'!H24:H63,\"B\",'E98 - E10'!F24:F63)","v":60},{"$f":"C24/('E95 - E5'!D$64+'E95 - E10'!D$64+'E98 - E5'!D$64+'E98 - E10'!D$64)","v":0.02}]
[null,"VR cat. C",{"$f":"SUMIF('E95 - E5'!H24:H63,\"C\",'E95 - E5'!F24:F63)+SUMIF('E95 - E10'!H24:H63,\"C\",'E95 - E10'!F24:F63)+SUMIF('E98 - E5'!H24:H63,\"C\",'E98 - E5'!F24:F63)+SUMIF('E98 - E10'!H24:H63,\"C\",'E98 - E10'!F24:F63)","v":40},{"$f":"C25/('E95 - E5'!D$64+'E95 - E10'!D$64+'E98 - E5'!D$64+'E98 - E10'!D$64)","v":1.3333333333333334E-2}]
[null,"VR totaal (A+B+C)",{"$f":"C23+C24+C25","v":300},{"$f":"C26/('E95 - E5'!D$64+'E95 - E10'!D$64+'E98 - E5'!D$64+'E98 - E10'!D$64)","v":0.1}]
[null,"VN cat. A",{"$f":"SUMIF('E95 - E5'!H24:H63,\"A\",'E95 - E5'!N24:N63)+SUMIF('E95 - E10'!H24:H63,\"A\",'E95 - E10'!N24:N63)+SUMIF('E98 - E5'!H24:H63,\"A\",'E98 - E5'!N24:N63)+SUMIF('E98 - E10'!H24:H63,\"A\",'E98 - E10'!N24:N63)","v":200},{"$f":"C27/('E95 - E5'!E$64+'E95 - E10'!E$64+'E98 - E5'!E$64+'E98 - E10'!E$64+'E95 - E5'!L64+'E95 - E10'!L64+'E98 - E5'!L64+'E98 - E10'!L64)","v":6.7973923908047476E-2}]
[null,"VN cat. B",{"$f":"SUMIF('E95 - E5'!H24:H63,\"B\",'E95 - E5'!N24:N63)+SUMIF('E95 - E10'!H24:H63,\"B\",'E95 - E10'!N24:N63)+SUMIF('E98 - E5'!H24:H63,\"B\",'E98 - E5'!N24:N63)+SUMIF('E98 - E10'!H24:H63,\"B\",'E98 - E10'!N24:N63)","v":26.285714285714285},{"$f":"C28/('E95 - E5'!E$64+'E95 - E10'!E$64+'E98 - E5'!E$64+'E98 - E10'!E$64+'E95 - E5'!L64+'E95 - E10'!L64+'E98 - E5'!L64+'E98 - E10'!L64)","v":8.9337157136290968E-3}]
[null,"VN cat. C",{"$f":"SUMIF('E95 - E5'!H24:H63,\"C\",'E95 - E5'!N24:N63)+SUMIF('E95 - E10'!H24:H63,\"C\",'E95 - E10'!N24:N63)+SUMIF('E98 - E5'!H24:H63,\"C\",'E98 - E5'!N24:N63)+SUMIF('E98 - E10'!H24:H63,\"C\",'E98 - E10'!N24:N63)","v":32.038095238095238},{"$f":"C29/('E95 - E5'!E$64+'E95 - E10'!E$64+'E98 - E5'!E$64+'E98 - E10'!E$64+'E95 - E5'!L64+'E95 - E10'!L64+'E98 - E5'!L64+'E98 - E10'!L64)","v":1.0888775239365319E-2},"Verplichting: maximum 1,5 %"]
[null,"VN totaal (A+B+C)",{"$f":"C29+C28+C27","v":258.32380952380953},{"$f":"C30/('E95 - E5'!E$64+'E95 - E10'!E$64+'E98 - E5'!E$64+'E98 - E10'!E$64+'E95 - E5'!L64+'E95 - E10'!L64+'E98 - E5'!L64+'E98 - E10'!L64)","v":8.7796414861041894E-2},"Verplichting: minimum 8,5 %"]
[]
[null,"Legende :",null,null,"∆ stocks (*) :"]
[null,null,null,null,null,"I",null,"II",null,null,"III"]
[null,"VR = reëel volume ",null,null,"Voorraad begin trimester","Aankopen",null,"Verkopen",null,null,"Inverbruikstellingen","Voorraad eind trimester"]
[null,"FE = corrigerende Energie Factor - tegenwaarde bio-ethanol",null,null,null,"Gemengd","Puur","Gemengd","Puur","Uitgevoerd"]
[null,"VE = Gelijkwaardig Volume bio-ethanol = VR x FE",null,"Categorie A",200,50,30,10,15,5,{"$f":"C23","v":200},{"$f":"E36+F36+G36-H36-I36-J36-K36","v":50}]
[null,"FC = Corrigerende Factor van de categorie",null,"Categorie B",150,30,15,5,10,20,{"$f":"C24","v":60},{"$f":"E37+F37+G37-H37-I37-J37-K37","v":100}]
[null,"VN = Nominaal volume= VR x FE x FC = VE x FC",null,"Categorie C",150,30,15,5,10,20,{"$f":"C25","v":40},{"$f":"E38+F38+G38-H38-I38-J38-K38","v":120}]
[null,null,null,null,"(*) Enkel reële volumes biobrandstoffen"]
[]
[]
[null,"Gezien om gevoegd te worden bij ons besluit van 15 november 2017 betreffende de rapportageverplichting van biobrandstoffen, minerale oliën en hun substitutieproducten van biologische oorsprong"]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[null,null,null,null,"Van Koningswege :"]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[null,null,null,null,"De Minister van Energie,"]
[null,null,null,null,"Leefmilieu en Duurzame Ontwikkeling"]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[null,null,null,null,"M.C. MARGHEM"]