{"text_format":"1","workbook":"xlsx","n_sheets":8,"sheets":["intro","Welkom","Input","Processen & Producten","Defaults","Kengetallen","Resultaat","Invoerscherm groentool"],"not_rendered":{"charts":7,"images":4,"macros":1,"external_links":0,"defined_names":15,"comments":2,"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":"intro","index":0,"n_rows":0,"n_cols":0,"rows_kept":0,"cut":false,"hidden":false,"merged":[]}

{"sheet":"Welkom","index":1,"n_rows":16,"n_cols":4,"rows_kept":16,"cut":false,"hidden":false,"merged":[[13,4,13,6],[14,4,14,6],[15,4,15,6]]}
[]
[null,null,null,"CO2-tool gft-verwerking 2.0"]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[null,null,"Bedrijfsgegevens"]
[null,null,null,"Naam bedrijf"]
[null,null,null,"Locatie"]
[null,null,null,"Jaar invoer"]

{"sheet":"Input","index":2,"n_rows":77,"n_cols":22,"rows_kept":77,"cut":false,"hidden":false,"merged":[]}
[]
[null,null,null,null,"CO2-tool gft-verwerking 2.0"]
[]
[null,null,null,null,null,null,null,null,"Aanvoer van afval",null,null,"Transportafstand",null,null,null,null,null,null,null,"Bedrijf:",{"$f":"CONCATENATE(Naam_bedrijf, \", \",Locatie)","v":", "}]
[null,null,null,null,null,null,null,null,null,null,"Ton/ jaar","  (km)",null,null,null,null,null,null,null,"Jaar:",{"$f":"jaartal","v":0}]
[null,null,null,null,null,null,null,null,null,"Truck",0,0]
[null,null,null,null,null,null,null,null,null,"Schip",0,0]
[null,null,null,null,null,null,null,null,null,"Trein",0,0]
[]
[]
[null,null,null,null,null,null,null,"Input afval",null,null,null,null,null,"Biogaspotentieel"]
[null,null,null,null,null,null,null,null,null,"Totale hoeveelheid (ton per jaar)",{"$f":"SUM(K14:K16)","v":0},null,null,"per deelstroom"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,"(Nm3/ton vers)","indicatie"]
[null,null,null,null,null,null,null,null,null,"Gft (ton per jaar)",0,{"$f":"CONCATENATE(\" (=\",ROUND((K14/K12)*100,0),\"%)\")","v":{"$error":"#DIV/0!"}},"gft",75,{"$f":"CONCATENATE(\" (\",Defaults!U7,\" )\")","v":" (75 )"}]
[null,null,null,null,null,null,null,null,null,"Analoog (ton per jaar)",0,{"$f":"CONCATENATE(\" (=\",ROUND((K15/K12)*100,0),\"%)\")","v":{"$error":"#DIV/0!"}},"analoog",175,{"$f":"CONCATENATE(\" (\",Defaults!U8,\" )\")","v":" (40-200 )"}]
[null,null,null,null,null,null,null,null,null,"Groenafval (ton per jaar)",0,{"$f":"CONCATENATE(\" (=\",ROUND((K16/K12)*100,0),\"%)\")","v":{"$error":"#DIV/0!"}},"groenafval",125,{"$f":"CONCATENATE(\" (\",Defaults!U9,\" )\")","v":" (40-200 )"}]
[]
[null,null,null,null,null,null,null,"Energieverbruik van installatie (totaal per jaar)"]
[null,null,null,null,null,null,null,null,null,null,"Elektriciteit, grijs",0,2]
[null,null,null,null,null,null,null,null,null,null,"Elektriciteit, groene stroom mix",0,1]
[null,null,null,null,null,null,null,null,null,null,"Elektriciteit, groene stroom met eigen CO2-factor",0,1,"CO2-factor",50]
[null,null,null,null,null,null,null,null,null,null,null,null,null,"(g CO2-eq/kWh)"]
[null,null,null,null,null,null,null,null,null,null,"Elektriciteit, windenergie",0,2]
[null,null,null,null,null,null,null,null,null,null,"Elektriciteit, zonne-energie (PV)",0,1]
[null,null,null,null,null,null,null,null,null,null,"Hout",0,2]
[null,null,null,null,null,null,null,null,null,null,"Diesel",0,"L"]
[null,null,null,null,null,null,null,null,null,null,"Gas",0,"Nm3"]
[null,null,null,null,null,null,null,null,null,null,"Groen gas",0,"Nm3"]
[null,null,null,null,null,null,null,null,null,null,"Stortgas",0,"Nm3"]
[null,null,null,null,null,null,null,null,null,null,"Warmte uit AEC",0,"GJ"]
[]
[]
[]
[]
[]
[]
[]
[null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"CONCATENATE(\"Resultaat voor de totale hoeveelheid verwerkt gft-afval: \",ROUND(CO2resultgealloceerd,0),\"\")","v":{"$error":"#DIV/0!"}},"kg CO2-eq. ",null,null,null,null,null,{"$f":"IF(K12=0,\"Per ton verwerkt gft-afval: 0\",CONCATENATE(\"Per ton verwerkt gft-afval: \",ROUND(CO2resultpertongealloceerd,0)))","v":"Per ton verwerkt gft-afval: 0"},"kg CO2-equivalenten"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"CONCATENATE(\"Resultaat voor de totale hoeveelheid verwerkt afval: \",ROUND(CO2resultaat,0),\"\")","v":"Resultaat voor de totale hoeveelheid verwerkt afval: 0"},"kg CO2-eq. ",null,null,null,null,null,{"$f":"IF(K12=0,\"Per ton verwerkt afval: 0\",CONCATENATE(\"Per ton verwerkt afval: \",ROUND(CO2resultaat_per_ton,0)))","v":"Per ton verwerkt afval: 0"},"kg CO2-equivalenten"]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[null,null,"Teksten:"]
[null,null,"kWh","(waarde 1)"]
[null,null,"MWh","(waarde 2)"]
[]
[null,null,"kg","(waarde 1)"]
[null,null,"ton","(waarde 2)"]

{"sheet":"Processen & Producten","index":3,"n_rows":82,"n_cols":23,"rows_kept":82,"cut":false,"hidden":false,"merged":[]}
[]
[null,null,null,null,"CO2-tool gft-verwerking 2.0"]
[]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Bedrijf:",{"$f":"CONCATENATE(Naam_bedrijf, \", \",Locatie)","v":", "}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Jaar:",{"$f":"jaartal","v":0}]
[]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Toepassing biogas"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"WKK"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Totale hvh biogas naar WKK (m3)",0]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Opbrengst warmte uit WKK (MJ)",0]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Opbrengst elektriciteit uit WKK (kWh)",0]
[]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Groengas"]
[null,null,null,null,null,null,null,null,null,"Naar compostering (incl. bypass):",null,null,null,null,null,null,null,null,null,"Totale hvh biogas opgewerkt naar groengas (indicatief) (m3)",0]
[null,null,null,null,"Naar vergister:",null,null,null,null,0,"Gft (ton/jaar)",null,null,null,null,null,null,null,null,"Hoeveelheid groengas (m3)",0]
[null,null,null,null,"Gft (ton/jaar)",0,null,null,null,0,"Analoog (ton/jaar)",null,null,null,null,null,null,null,null,"Biogas opwerkmethode"]
[null,null,null,null,"Analoog (ton/jaar)",0,null,null,null,0,"Groenafval (ton/jaar)",null,null,null,null,null,null,null,null,"CO2-winning uit biogas (kg)",0]
[null,null,null,null,"Groenafval (ton/jaar)",0,null,null,null,null,null,null,null,null,null,null,null,null,null,"Levering groengas aan aardgasnet (%)",{"$f":"1-SUM(U19:U20)","v":0.85}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Groengas als vervanging van diesel (%)",0.1]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Overige toepassing groengas (%)",0.05,"kg CO2 eq /  m3 groengas",0]
[null,null,"Vergisting",null,null,null,null,null,null,"Compostering"]
[null,null,null,"Totale hoeveelheid (ton/jaar)",{"$f":"SUM(F16:F18)","v":0},null,null,"Digestaat (ton/jaar)",null,null,"Totale hoeveelheid (ton/jaar)",{"$f":"SUM(H24,J15:J17)","v":0},null,null,null,"Terugwinning warmte uit proceslucht"]
[null,null,null,"CH4 emissie (g/ton afval)",500,{"$f":"CONCATENATE(\" (\",Defaults!M25,\")\")","v":" (500)"},null,null,null,null,"CH4 emissie (g/ton afval)",161,{"$f":"CONCATENATE(\" (\",Defaults!S25,\")\")","v":" (161)"},null,null,null,null,null,null,"Geleverde warmte (MJ)",0]
[null,null,null,"N2O emissie (g/ton afval)",20,{"$f":"CONCATENATE(\" (\",Defaults!M26,\")\")","v":" (20)"},null,0,null,null,"N2O emissie (g/ton afval)",72,{"$f":"CONCATENATE(\" (\",Defaults!S26,\")\")","v":" (72)"}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Product naar bio-energiecentrale"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null," Hoeveelheid (ton / jaar)",0]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"droge stof in product (%)",0,null,"calorische waarde product"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"organisch stof in product (% van droge stof)",0,null,"(MJ/kg)",{"$f":"((1-(0.01*T27))*-2.26)+(T27*0.01*T28*0.01)*18.8","v":-2.2599999999999998}]
[null,null,null,null,null,"Compost",null,null,null,null,null,null,null,null,null,null,null,null,"Rendement thermisch (%)",0.35,{"$f":"CONCATENATE(\" (\",Defaults!H32*100,\"%)\")","v":" (35%)"}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Rendement elektrisch (%)",0.25,{"$f":"CONCATENATE(\" (\",Defaults!H33*100,\"%)\")","v":" (25%)"}]
[null,null,null,null,null,null,null,null,"Totale opbrengst compost per jaar (ton):",0]
[null,null,null,null,null,null,null,null,"Opbrengst (kg/ton afval)",{"$f":"1000*J31/Input!$K$12","v":{"$error":"#DIV/0!"}},null,null,null,null,null,"Alternatieve opwerking "]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Netto kg "]
[null,null,null,null,null,"Transport van compost",null,"Ton per","Afstand ",null,null,null,null,null,null,null,"Deelstroom",null,"ton (totaal)","Opwerkingsproces",null,"CO2 eq"]
[null,null,null,null,null,null,null," jaar","(km)"]
[null,null,null,null,null,null,"Vrachtwagen met oplegger",{"$f":"J31-H37-H38","v":0},0]
[null,null,null,null,null,null,"Enkele vrachtwagen",0,0]
[null,null,null,null,null,null,"Schip",0,0]
[]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Surplus water naar RWZI"]
[null,null,null,null,null,null,null,"Compost",null,null,null,null,null,null,null,null,null,null,null,"Water (m3)",0]
[null,null,null,null,"Kenmerken compost",null,null,null,null,null,null,"Marktverdeling compost",null,null,null,null,"Residu naar AEC / stort"]
[null,null,null,null,"droge stof (d.s., %)",67,{"$f":"CONCATENATE(\" (\",Defaults!K50,\")\")","v":" (67)"},null,null,null,null,"Landbouw (akkerbouw, vollegronds tuinbouw, boomteelt)",0.69,{"$f":"CONCATENATE(\" (\",Defaults!Q48*100,\"%)\")","v":" (69%)"},null,null,null,null,null,"Afvalenergiecentrale",0,1]
[null,null,null,null,"Organische stof (O.S.) (g/kg ds)",331,{"$f":"CONCATENATE(\" (\",Defaults!K51,\")\")","v":" (331)"},null,null,null,null,"Glastuinbouw",0.03,{"$f":"CONCATENATE(\" (\",Defaults!Q49*100,\"%)\")","v":" (3%)"},null,null,null,null,null,"Stort",0,1]
[null,null,null,null,"Stikstof [N] (g/kg ds)",11.9,{"$f":"CONCATENATE(\" (\",Defaults!K52,\")\")","v":" (11,9)"},null,null,null,null,"Hoveniers",null,{"$f":"CONCATENATE(\" (\",Defaults!Q50*100,\"%)\")","v":" (0%)"}]
[null,null,null,null,"Fosfaat [P2O5] (g/kg ds)",6.4,{"$f":"CONCATENATE(\" (\",Defaults!K53,\")\")","v":" (6,4)"},null,null,null,null,"Particulieren",0.01,{"$f":"CONCATENATE(\" (\",Defaults!Q51*100,\"%)\")","v":" (1%)"},null,null,"Recycling"]
[null,null,null,null,"Kalium [K2O] (g/kg ds)",10.5,{"$f":"CONCATENATE(\" (\",Defaults!K54,\")\")","v":" (10,5)"},null,null,null,null,"Gemeenten (groenvoorziening)",0.03,{"$f":"CONCATENATE(\" (\",Defaults!Q52*100,\"%)\")","v":" (3%)"},null,null,null,null,null,"Inert materiaal als wegophoging/fundering",0,1]
[null,null,null,null,null,null,null,null,null,null,null,"Potgrondsubstraten en aanvulgrond",0.12,{"$f":"CONCATENATE(\" (\",Defaults!Q53*100,\"%)\")","v":" (12%)"},null,null,null,null,null,"Ferrometalen naar recycling",0,1]
[null,null,null,null,null,null,null,null,null,null,null,"Specifiek samengestelde grondproducten",null,{"$f":"CONCATENATE(\" (\",Defaults!Q54*100,\"%)\")","v":" (0%)"}]
[null,null,null,null,null,null,null,null,null,null,null,"Boxcompost",null,{"$f":"CONCATENATE(\" (\",Defaults!Q55*100,\"%)\")","v":" (0%)"}]
[null,null,null,null,null,null,null,null,null,null,null,"Aannemerij/wegenbouw",0.05,{"$f":"CONCATENATE(\" (\",Defaults!Q56*100,\"%)\")","v":" (5%)"}]
[null,null,null,null,null,null,null,null,null,null,null,"Anders (w.o. tussenhandel)",{"$f":"1-SUM(M43:M51)","v":6.9999999999999951E-2},{"$f":"CONCATENATE(\" (\",Defaults!Q57*100,\"%)\")","v":" (7%)"}]
[]
[null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"CONCATENATE(\"Resultaat voor de totale hoeveelheid verwerkt gft-afval: \",ROUND(CO2resultgealloceerd,0),\"\")","v":{"$error":"#DIV/0!"}},"kg CO2-eq. ",null,null,null,null,null,{"$f":"IF(Input!K12=0,\"Per ton verwerkt gft-afval: 0\",CONCATENATE(\"Per ton verwerkt gft-afval: \",ROUND(CO2resultpertongealloceerd,0)))","v":"Per ton verwerkt gft-afval: 0"},"kg CO2-equivalenten"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"CONCATENATE(\"Resultaat voor de totale hoeveelheid verwerkt afval: \",ROUND(CO2resultaat,0),\"\")","v":"Resultaat voor de totale hoeveelheid verwerkt afval: 0"},"kg CO2-eq. ",null,null,null,null,null,{"$f":"IF(Input!K12=0,\"Per ton verwerkt afval: 0\",CONCATENATE(\"Per ton verwerkt afval: \",ROUND(CO2resultaat_per_ton,0)))","v":"Per ton verwerkt afval: 0"},"kg CO2-equivalenten"]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[null,null,"Totale hoeveelheid gft",null,{"$f":"Input!K14","v":0}]
[null,null,"Totale hoeveelheid analoog",null,{"$f":"Input!K15","v":0}]
[null,null,"Totale hoeveelheid groenafval",null,{"$f":"Input!K16","v":0}]
[]
[null,null,"waterwassen"]
[null,null,"aminewassen"]
[null,null,"membraanfiltratie met CO2-terugwinning"]
[null,null,"cryogene opwerking"]
[null,null,"anders (aanname: PSA)"]
[]
[null,null,2]
[]
[null,null,"kg","(waarde 1)"]
[null,null,"ton","(waarde 2)"]

{"sheet":"Defaults","index":4,"n_rows":57,"n_cols":27,"rows_kept":57,"cut":false,"hidden":true,"merged":[[47,12,47,15],[41,3,41,4],[41,6,41,7],[41,13,41,14],[39,3,39,4],[39,6,39,7],[39,13,39,14],[40,3,40,4],[40,6,40,7],[40,13,40,14],[13,13,13,14],[14,13,14,14],[15,13,15,14],[16,13,16,14],[38,3,38,4],[38,6,38,7],[38,13,38,14]]}
[]
[null,null,null,null,"CO2-tool gft-verwerking 2.0 DEFAULTWAARDEN"]
[]
[null,null,null,null,null,null,null,null,null,null,null,"Gescheiden ingezameld gft-afval",null,null,null,null,null,null,null,"biogaspotentieel"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Totale hoeveelheid (ton per jaar)",null,null,null,null,"per deelstroom"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"(Nm3/ton vers)"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Gft(%)",null,null,null,null,"Gft",75]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Analoog (%)",null,null,null,null,"Analoog ","40-200"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Groenafval (%)",null,null,null,null,"Groenafval ","40-200"]
[]
[]
[]
[null,null,null,null,null,null,null,null,null,null,null,null,"Transport van gft-afval"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,"Ton per jaar",null,"Afstand (km)"]
[null,null,"WKK",null,null,null,"Totale hvh biogas naar WKK (m3)",{"$f":"(75*'Processen & Producten'!E22)*0.5","v":0},null,null,null,null,"Truck",null,null,35]
[null,null,null,null,null,null,"Opbrengst warmte uit WKK (MJ/m3 biogas)",{"$f":"0.4*21.5","v":8.6},null,null,null,null,"Schip",null,null,35]
[null,null,null,null,null,null,"Opbrengst elektriciteit uit WKK (kWh/m3 biogas)",{"$f":"0.36*21.5/3.6","v":2.15},null,null,null,null,"Trein",null,null,35,null,null,null,null,null,"Energieverbruik (totaal)"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Elektriciteit, grijs (kWh)",{"$f":"32*Input!K12","v":0}]
[null,null,"Groen gas",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Elektriciteit, groene stroom mix (kWh)"]
[null,null,null,null,null,null,"Totale hvh biogas opgewerkt naar groen gas (m3)",{"$f":"(75*'Processen & Producten'!E22)*0.5","v":0},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Elektriciteit, windenergie (kWh)"]
[null,null,null,null,null,null,"Hoeveelheid groen gas (m3/ton gft)",{"$f":"0.666*'Processen & Producten'!U14","v":0},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Elektriciteit, zonne-energie (PV) (kWh)"]
[null,null,null,null,null,null,"Percentage levering aan aardgasnet",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Diesel (liter)"]
[null,null,null,null,null,null,"Percentage vervanging diesel",null,null,null,"Vergisting",null,null,null,null,"Compostering",null,null,null,null,null,null,null,null,null,"Gas (m3)",{"$f":"(342/31.8)*Input!K12","v":0}]
[null,null,null,null,null,null,null,null,null,null,null,"Hoeveelheid (ton per jaar)",null,null,null,null,null,"Hoeveelheid (ton per jaar)"]
[null,null,"Terugwinning warmte uit compostvloeren",null,null,null,null,null,null,null,null,"CH4 emissie (g/ton gft)",500,null,null,null,null,"CH4 emissie (g/ton gft)",161]
[null,null,null,null,null,null,"Geleverde warmte (MJ/ton gft)",null,null,null,null,"N2O emissie (g/ton gft)",20,null,null,null,null,"N2O emissie (g/ton gft)",72]
[]
[]
[null,null,"Residu naar bio-energiecentrale",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Surplus water naar RWZI"]
[null,null,null,null,null,null," Hoeveelheid (kg/ton gft)",null,null,null,"(na)compostering",null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Water (m3)"]
[null,null,null,null,null,null,"Calorische waarde (MJ/kg)",9.3000000000000007,null,null,null,"Hoeveelheid (ton per jaar)",null,null,null,null,null,null,null,null,null,null,"Residu naar AEC / stort"]
[null,null,null,null,null,null,"Rendement thermisch (%)",0.35,null,null,null,"CH4 emissie (g/ton gft)",null,null,null,null,null,null,null,null,null,null,null,null,null,"AEC (kg)",{"$f":"15*Input!K12","v":0}]
[null,null,null,null,null,null,"Rendement elektrisch (%)",0.25,null,null,null,"N2O emissie (g/ton gft)",null,null,null,null,null,null,null,null,null,null,null,null,null,"Stort (kg)",0]
[]
[]
[null,null,"Alternatieve opwerking "]
[null,null,null,null,null,"kg (per",null,null,"Netto kg "]
[null,null,null,"Deelstroom",null,"ton gft)","Opwerkingsproces",null,"CO2 eq",null,null,null,"Transport van compost"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,"Ton per jaar",null,"Afstand (km)"]
[null,null,null,null,null,null,null,null,null,null,null,null,"Enkele vrachtwagen",null,null,30]
[null,null,null,null,null,null,null,null,null,null,null,null,"Vrachtwagen met oplegger",null,null,30]
[null,null,null,null,null,null,null,null,null,null,null,null,"Schip",null,null,30]
[]
[]
[]
[null,null,null,null,null,null,null,null,null,null,null,"Compost"]
[null,null,null,null,null,null,null,null,null,"Kenmerken Compost",null,null,null,null,null,"Marktverdeling"]
[null,null,null,null,null,null,null,null,null,"Totale opbrengst compost per jaar (ton):",null,null,"Landbouw (akkerbouw, vollegronds tuinbouw, boomteelt)",null,null,null,0.69]
[null,null,null,null,null,null,null,null,null,"Opbrengst (kg/ton afval)",400,null,null,null,null,"Glastuinbouw",0.03]
[null,null,null,null,null,null,null,null,null,"ds (%)",67,null,null,null,null,"Hoveniers"]
[null,null,null,null,null,null,null,null,null,"Organische stof (O.S.) (g/kg ds)",331,null,null,null,null,"Particulieren",0.01]
[null,null,null,null,null,null,null,null,null,"Stikstof [N] (g/kg ds)",11.9,null,null,null,null,"Gemeenten (groenvoorziening)",0.03]
[null,null,null,null,null,null,null,null,null,"Fosfaat [P2O5] (g/kg ds)",6.4,null,null,null,null,"Potgrondsubstraten en aanvulgrond",0.12]
[null,null,null,null,null,null,null,null,null,"Kalium [K2O] (g/kg ds)",10.5,null,null,null,null,"Specifiek samengestelde grondproducten"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Boxcompost"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Aannemerij/wegenbouw",0.05]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Anders (w.o. tussenhandel)",7.0000000000000007E-2]

{"sheet":"Kengetallen","index":5,"n_rows":273,"n_cols":19,"rows_kept":273,"cut":false,"hidden":true,"merged":[]}
["Startpunt: totale hoeveelheid afvalstromen"]
[null,null,null,{"$f":"Input!K12","v":0},"ton ",null,null,null,null,"Kleurcode"]
[null,null,"Gft(%)",{"$f":"Input!K14/Input!K12","v":{"$error":"#DIV/0!"}},null,null,null,null,null,null,"invoer"]
[null,null,"Aanaloog (%)",{"$f":"Input!K15/Input!K12","v":{"$error":"#DIV/0!"}},null,null,null,null,null,null,"berekening"]
[null,null,"Groenafval (%)",{"$f":"Input!K16/Input!K12","v":{"$error":"#DIV/0!"}},null,null,null,null,null,null,"geupdate kengetallen"]
[]
[]
[]
[]
["Compost eigenschappen en toepassing"]
["compost","kg compost / jaar",{"$f":"'Processen & Producten'!J31*1000","v":0},"N-gehalte",{"$f":"'Processen & Producten'!F45","v":11.9},"[N] in g/kg dw"]
[null,null,null,"C-gehalte",{"$f":"0.56*'Processen & Producten'!F44/1000","v":0.18536000000000002},"[C] in kg/kg dw"]
[null,null,null,"P-gehalte",{"$f":"'Processen & Producten'!F46","v":6.4},"[P2O5] in g/kg dw"]
[null,null,null,"K-gehalte",{"$f":"'Processen & Producten'!F47","v":10.5},"[K2O] in g/kg dw"]
[null,"%dw",{"$f":"'Processen & Producten'!F43","v":67},"% bijdrage aan veenvervanging","% bijdrage aan kunstmest-vervanging","% bijdrage aan koolstofvastlegging",null,null,null,"% N beschikbaar voor vervanging","% P beschikbaar voor vervanging","% K beschikbaar voor vervanging"]
["Landbouw (akkerbouw, vollegronds tuinbouw, boomteelt)","%",{"$f":"'Processen & Producten'!M43","v":0.69},0,0.5,1,"kunstmestvervanging totaal",{"$f":"(C16*E16)+(C17*E17)+(C18*E18)+(C19*E19)+(C20*E20)+(C21*E21)+(C22*E22)+(C23*E23)+(C24*E24)+(C25*E25)","v":0.54},"%",0.749,0.9,1]
["Tuinbouw","%",{"$f":"'Processen & Producten'!M44","v":0.03},1,1,1,"koolstofvastlegging totaal",{"$f":"(C16*F16)+(C17*F17)+(C18*F18)+(C19*F19)+(C20*F20)+(C21*F21)+(C22*F22)+(C23*F23)+(C24*F24)+(C25*F25)","v":1},"%",0.749,0.9,1]
["Hoveniers","%",{"$f":"'Processen & Producten'!M45","v":0},1,1,1,"veenvervanging totaal",{"$f":"(C16*D16)+(C17*D17)+(C18*D18)+(C19*D19)+(C20*D20)+(C21*D21)+(C22*D22)+(C23*D23)+(C24*D24)+(C25*D25)","v":0.16499999999999998},"%",0.749,0.9,1]
["Particulieren","%",{"$f":"'Processen & Producten'!M46","v":0.01},0,1,1,null,null,null,0.749,0.9,1]
["Gemeenten","%",{"$f":"'Processen & Producten'!M47","v":0.03},0.5,0,1,"vervangingswaarde compost",0.83,"kg veen / kg compost",0.749,0.9,1]
["Potgrondproducenten","%",{"$f":"'Processen & Producten'!M48","v":0.12},1,1,1,"veenvervanging",{"$f":"H18*hoeveelheid_compost*H20","v":0},"kg",0.15,0.9,1]
["Specifieke grondproducten","%",{"$f":"'Processen & Producten'!M49","v":0},0,0,1,null,null,null,0.749,0.9,1]
["Boxcompost","%",{"$f":"'Processen & Producten'!M50","v":0},0,0.5,1,null," ",null,0.749,0.9,1]
["Aannemerij/wegenbouw","%",{"$f":"'Processen & Producten'!M51","v":0.05},0,0,1,null,null,null,0.749,0.9,1]
["Anders (w.o. tussenhandel)","%",{"$f":"'Processen & Producten'!M52","v":6.9999999999999951E-2},0,0.5,1,null,null,null,0.749,0.9,1]
[null,null,null,null,null,null,null,null,"% totaal beschikbaar:",{"$f":"(C16*J16)+(C17*J17)+(C18*J18)+(C19*J19)+(C20*J20)+(C21*J21)+(C22*J22)+(C23*J23)+(C24*J24)+(C25*J25)","v":0.67711999999999994},{"$f":"(C16*K16)+(C17*K17)+(C18*K18)+(C19*K19)+(C20*K20)+(C21*K21)+(C22*K22)+(C24*K24)+(C25*K25)","v":0.9},{"$f":"(C16*L16)+(C17*L17)+(C18*L18)+(C19*L19)+(C20*L20)+(C21*L21)+(C22*L22)+(C24*L24)+(C25*L25)","v":1}]
["Berekening over totale verwerkte hoeveelheid"]
["parameter","eenheid","hoeveelheid","kg CO2-eq. per eenheid","kg CO2-eq. totaal","Opmerkingen (referenties)"]
["transport truck","tkm",{"$f":"Input!K6*Input!L6","v":0},0.13,{"$f":"C29*D29","v":0},"vrachtauto >20 ton, CO2-prestatieladder v2.1, SKAO"]
["transport schip","tkm",{"$f":"Input!K7*Input!L7","v":0},0.06,0,"Binnenvaart, 200 TEU, CO2-prestatieladder v2.1, SKAO"]
["Transport trein","tkm",{"$f":"Input!K8*Input!L8","v":0},2.1999999999999999E-2,0,"Trein, combinatie electrische en diesel locs, of onbekend type locs, CO2-prestatieladder v2.1, SKAO"]
["electriciteitsgebruik (grijs)","kWh",{"$f":"IF(Input!M19=1,Input!L19,Input!L19*1000)","v":0},0.45500000000000002,{"$f":"C32*D32","v":0},"grijze stroom, 2010 en later, CO2-prestatieladder v2.1, SKAO"]
["electriciteitsgebruik (groen mix)","kWh",{"$f":"IF(Input!M20=1,Input!L20,Input!L20*1000)","v":0},9.9076542000000004E-2,{"$f":"C33*D33","v":0},"1 kWh Electricity, low voltage, at grid/NL - Groene stroom; samenstelling obv SBK database"]
["electriciteitsgebruik (groene stroom met eigen CO2-factor)","kWh",{"$f":"IF(Input!M21=1,Input!L21,Input!L21*1000)","v":0},{"$f":"Input!O21/1000","v":0.05},{"$f":"C34*D34","v":0},"groene stroom - windkracht, CO2-prestatieladder v2.1, SKAO"]
["electriciteitsgebruik (wind)","kWh",{"$f":"IF(Input!M23=1,Input!L23,Input!L23*1000)","v":0},1.4999999999999999E-2,{"$f":"C35*D35","v":0},"eigen data gebruiker"]
["electriciteitsgebruik (PV)","kWh",{"$f":"IF(Input!M24=1,Input!L24,Input!L24*1000)","v":0},0.08,0,"groene stroom - zonne-energie, CO2-prestatieladder v2.1, SKAO"]
["houtgebruik","kg",{"$f":"IF(Input!M25=1,Input!L25,Input!L25*1000)","v":0},3.5875563999999999E-2,0,"Ecoinvent \"Wood chips, from industry, mixed, burned in furnace\""]
["dieselverbruik","liter",{"$f":"Input!L26","v":0},3.1349999999999998,0,"Diesel, CO2-prestatieladder v2.1, SKAO"]
["aardgasverbruik","m3",{"$f":"Input!L27","v":0},1.825,0,"Aardgas, CO2-prestatieladder v2.1, SKAO"]
["groen gas verbruik","m3",{"$f":"Input!L28","v":0},{"$f":"D56","v":0.71435499999999996},0,"Ecoinvent \"Methane from biogas\""]
["stortgasverbruik","m3",{"$f":"Input!L29","v":0},0.4,0,"\"Biogas (stortgas)\", CO2-prestatieladder v2.1, SKAO"]
["verbruik warmte uit AEC","GJ",{"$f":"Input!L30","v":0},20,0,"\"Warmtelevering AVI\", CO2-prestatieladder v2.1, SKAO"]
["emissie methaan vergisting","g",{"$f":"'Processen & Producten'!E23*'Processen & Producten'!E22","v":0},{"$f":"22.3/1000","v":2.23E-2},0,"ref. Tauw 2007"]
["emissie N2O vergisting","g",{"$f":"'Processen & Producten'!E24*'Processen & Producten'!E22","v":0},{"$f":"298/1000","v":0.29799999999999999},0,"ref. Tauw 2007"]
["emissie methaan compostering","g",{"$f":"'Processen & Producten'!L23*('Processen & Producten'!L22-'Processen & Producten'!H24)","v":0},{"$f":"22.3/1000","v":2.23E-2},0,"ref. Tauw 2007"]
["emissie N2O compostering","g",{"$f":"'Processen & Producten'!L24*('Processen & Producten'!L22-'Processen & Producten'!H24)","v":0},{"$f":"298/1000","v":0.29799999999999999},0,"ref. Tauw 2007"]
["emissie CO2 compostering/vergisting","g",0,0,null,"CO2 uit gft-afval is biogeen, dus score 0."]
["Product naar Bio-energiecentrale","kg",{"$f":"'Processen & Producten'!T26*1000","v":0},{"$f":"0.01636-('Processen & Producten'!T29*'Processen & Producten'!W28*0.0777)-('Processen & Producten'!T30*'Processen & Producten'!W28*0.186)","v":0.18291069999999998},0,"afhankelijk van calorische waarde en rendement, uitsparing gebaseerd op Electricity mix/NL en Heat - natural gas - at industrial furnace; emissie gebaseerd op Ecoinvent 'Disposal, wood untreated, incineration'"]
["Emissie WKK (kg CO2eq/m3 biogas)","m3 biogas",{"$f":"'Processen & Producten'!U9","v":0},0.13619205000000001,0,"Meerdere Ecoinvent processen \"Electricity, at cogen with biogas engine\""]
["Opbrengst warmte uit WKK ","MJ",{"$f":"'Processen & Producten'!U10","v":0},{"$f":"-D39/31.8","v":-5.7389937106918233E-2},0,"Aardgas, CO2-prestatieladder v2.1, SKAO"]
["Opbrengst elektriciteit uit WKK ","kWh",{"$f":"'Processen & Producten'!U11","v":0},{"$f":"-D32","v":-0.45500000000000002},0,"grijze stroom, 2010 en later, CO2-prestatieladder v2.1, SKAO"]
["Productie groen gas uit biogas, waterwassen","m3 groen gas",{"$f":"IF('Processen & Producten'!C79=1,'Processen & Producten'!U15,0)","v":0},0.31095460000000003,0,"Ecoinvent \"Methane from biogas\"; CH4 emissie aangepast aan garantiewaarden leveranciers; inclusief verbranden gas"]
["Productie groen gas uit biogas, aminewassen","m3 groen gas",{"$f":"IF('Processen & Producten'!C79=2,'Processen & Producten'!U15,0)","v":0},0.23698932,0,"Ecoinvent \"Methane from biogas\"; CH4 emissie aangepast aan garantiewaarden leveranciers; inclusief verbranden gas"]
["Productie groen gas uit biogas, membraanfiltratie","m3 groen gas",{"$f":"IF('Processen & Producten'!C79=3,'Processen & Producten'!U15,0)","v":0},0.23698932,0,"Ecoinvent \"Methane from biogas\"; CH4 emissie aangepast aan garantiewaarden leveranciers; inclusief verbranden gas"]
["Productie groen gas uit biogas, cryogeen","m3 groen gas",{"$f":"IF('Processen & Producten'!C79=4,'Processen & Producten'!U15,0)","v":0},0.31095460000000003,0,"Ecoinvent \"Methane from biogas\"; CH4 emissie aangepast aan garantiewaarden leveranciers; inclusief verbranden gas"]
["Productie groen gas uit biogas, anders (PSA) ","m3 groen gas",{"$f":"IF('Processen & Producten'!C79=5,'Processen & Producten'!U15,0)","v":0},0.71435499999999996,0,"Ecoinvent \"Methane from biogas\""]
["CO2-winning uit biogas","kg",{"$f":"'Processen & Producten'!U17","v":0},-1,{"$f":"C57*D57","v":0},"eigen data gebruiker"]
["Percentage levering aan aardgasnet","m3 groen gas",{"$f":"'Processen & Producten'!U15*'Processen & Producten'!U18","v":0},{"$f":"-D39","v":-1.825},0,"Aardgas, CO2-prestatieladder v2.1, SKAO"]
["Percentage vervanging diesel","m3 groen gas",{"$f":"'Processen & Producten'!U15*'Processen & Producten'!U19","v":0},{"$f":"-D38*(31.8/35.9)","v":-2.7769637883008356},0,"Omrekenen op basis van calorische waarde"]
["Percentage overige toepassing","m3 groen gas",{"$f":"'Processen & Producten'!U15*'Processen & Producten'!U20","v":0},{"$f":"'Processen & Producten'!W20","v":0},0,"eigen data gebruiker"]
["Alternatieve opwerking deelstromen","kg CO2 eq",{"$f":"SUM('Processen & Producten'!V35:V38)","v":0},1,0,"eigen data gebruiker"]
["Warmteterugwinning (MJ)","MJ",{"$f":"'Processen & Producten'!U23","v":0},{"$f":"D50","v":-5.7389937106918233E-2},0,"Aardgas, CO2-prestatieladder v2.1, SKAO"]
["Water naar RWZI","m3",{"$f":"'Processen & Producten'!U41","v":0},{"$f":"0.23*D32","v":0.10465000000000001},{"$f":"C63*D63","v":0},"Stowa"]
["residue naar AEC","kg",{"$f":"IF('Processen & Producten'!V43=1,'Processen & Producten'!U43,'Processen & Producten'!U43*1000)","v":0},8.4634496000000004E-2,0,"Verbranding 'municipal waste' in gemiddelde NL AEC, aanname dat CO2-emissie 50% fossiel is en 50% biogeen. Opwekking warmte en elektriciteit in AEC wordt meegeteld."]
["residue naar stort","kg",{"$f":"IF('Processen & Producten'!V44=1,'Processen & Producten'!U44,'Processen & Producten'!U44*1000)","v":0},7.1031035999999997E-3,0,"Disposal, inert waste, 5% water, to inert material landfill"]
["residue ingezet als wegfundering","kg",{"$f":"IF('Processen & Producten'!V47=1,'Processen & Producten'!U47,'Processen & Producten'!U47*1000)","v":0},-2.3939005000000002E-3,{"$f":"C66*D66","v":0},"Ecoinvent \"Sand, at mine/CH U\""]
["ferrometalen naar recycling","kg",{"$f":"IF('Processen & Producten'!V48=1,'Processen & Producten'!U48,'Processen & Producten'!U48*1000)","v":0},-1.4142067,{"$f":"C67*D67","v":0},"Slim Slopen Tool 2.1; Recycling RVS en ijzer. Obv Ecoinvent “Pig iron, at plant/GLO U” voor productie mix vermeden en “Iron scrap, at plant/RER U”  voor opwerking. 5% uitval."]
["transport vrachtwagen met oplegger","tkm",{"$f":"'Processen & Producten'!H36*'Processen & Producten'!I36","v":0},9.5000000000000001E-2,{"$f":"C68*D68","v":0},"trekker met oplegger, CO2-prestatieladder v2.1, SKAO"]
["transport naar compost toepassing; enkele vrachtwagen","tkm",{"$f":"'Processen & Producten'!H37*'Processen & Producten'!I37","v":0},0.13,{"$f":"C69*D69","v":0},"vrachtauto >20 ton, CO2-prestatieladder v2.1, SKAO"]
["Transport schip","tkm",{"$f":"'Processen & Producten'!H38*'Processen & Producten'!I38","v":0},0.06,0,"Binnenvaart, 200 TEU, CO2-prestatieladder v2.1, SKAO"]
[]
["veenvervanging","kg",{"$f":"H21","v":0},-0.85,{"$f":"C72*D72","v":0},"hele keten van veentoepassing: veenproductie (Ecoinvent), 90% emissie koolstof als fossiel CO2, na toepassing op het land."]
["vervanging veentransport","km",1000,null,null,"veentransport"]
[null,"tkm",{"$f":"C72*C73/1000","v":0},-9.5000000000000001E-2,{"$f":"C74*D74","v":0},"trekker met oplegger, CO2-prestatieladder v2.1, SKAO"]
["substitutie N-fertilizer","kg",{"$f":"H16*(E11/1000)*(C15/100)*hoeveelheid_compost*J26","v":0},-8.6539883,0,"Calcium ammonium nitrate, as N, at regional storehouse/RER"]
["substitutie P-fertilizer","kg",{"$f":"H16*(E13/1000)*(C15/100)*hoeveelheid_compost*K26","v":0},-2.0213709999999998,0,"Triple superphosphate, as P2O5, at regional storehouse/RER"]
["substitutie K-fertilizer","kg",{"$f":"H16*(E14/1000)*(C15/100)*hoeveelheid_compost*L26","v":0},-0.49735504000000003,0,"Potassium chloride, as K2O, at regional storehouse/RER"]
["vermeden emissie N2O door vermeden toepassing kunstmest","g",{"$f":"E11*C15/100*hoeveelheid_compost*0.0125*(44/28)","v":0},{"$f":"-D44","v":-0.29799999999999999},0,"1.25% van aanwezige N wordt N2O; molmassa N=14, N2O=44, verhouding = 44/(2*14)"]
["emissie N2O bij toepassing compost","g",{"$f":"E11*C15/100*hoeveelheid_compost*0.0125*(44/28)*0.5","v":0},{"$f":"D44","v":0.29799999999999999},0,"50% van de emissie van kunstmest"]
["koolstofvastlegging in grond","kg",{"$f":"H17*E12*hoeveelheid_compost*(C15/100)*0.1*(44/12)","v":0},-1,0,"10% van koolstof in compost blijvend vastgelegd in grond."]
[]
[]
[]
[]
["Resultaten (kg CO2 eq) voor de totale verwerkte hoeveelheid",null,null,null,null,null,null,"CO2-score","CO2-score",null,"Resultaten (kg CO2 eq) per hoofdcategorie"]
[null,null,null,"allocatie op basis van",null,"massa-fractie gft t.o.v. totaal afval",null,"gealloceerd naar gft-fractie","per ton gft",null,null,"totaal verwerkte hoeveelheid","gft-fractie","Per ton gft"]
["Transport (aanvoer afval)",{"$f":"SUM(E29:E31)","v":0},null,"massa",null,{"$f":"Input!K14/Input!K12","v":{"$error":"#DIV/0!"}},null,{"$f":"B87*$F$87","v":{"$error":"#DIV/0!"}},{"$f":"H87/Input!$K$14","v":{"$error":"#DIV/0!"}},null,"Transport",{"$f":"SUM(B87,B101)","v":0},{"$f":"SUM(H87,H101)","v":{"$error":"#DIV/0!"}},{"$f":"SUM(I87,I101)","v":{"$error":"#DIV/0!"}}]
["Elektriciteitverbruik",{"$f":"SUM(E32:E36)","v":0},null,"massa",null,"massa-fractie gft vergister t.o.v. totaal afval vergister",null,{"$f":"B88*$F$87","v":{"$error":"#DIV/0!"}},{"$f":"H88/Input!$K$14","v":{"$error":"#DIV/0!"}},null,"Verwerkingsproces",{"$f":"SUM(B88:B93,B99,B100)","v":0},{"$f":"SUM(H88:H93,H99,H100)","v":{"$error":"#DIV/0!"}},{"$f":"SUM(I88:I93,I99,I100)","v":{"$error":"#DIV/0!"}}]
["Houtgebruik",{"$f":"E37","v":0},null,"massa",null,{"$f":"'Processen & Producten'!F16/'Processen & Producten'!E22","v":{"$error":"#DIV/0!"}},null,{"$error":"#DIV/0!"},{"$f":"H89/Input!$K$14","v":{"$error":"#DIV/0!"}},null,"Product",{"$f":"SUM(B94:B98,B102:B104)","v":0},{"$f":"SUM(H94:H98,H102:H104)","v":{"$error":"#DIV/0!"}},{"$f":"SUM(I94:I98,I102:I104)","v":{"$error":"#DIV/0!"}}]
["Dieselgebruik",{"$f":"E38","v":0},null,"massa",null,"massa-fractie gft composteren t.o.v. totaal afval composteren",null,{"$error":"#DIV/0!"},{"$f":"H90/Input!$K$14","v":{"$error":"#DIV/0!"}}]
["Gasgebruik",{"$f":"E39+E40+E41+E42","v":0},null,"massa",null,{"$f":"'Processen & Producten'!J15/('Processen & Producten'!J15+'Processen & Producten'!J16+'Processen & Producten'!J17)","v":{"$error":"#DIV/0!"}},null,{"$error":"#DIV/0!"},{"$f":"H91/Input!$K$14","v":{"$error":"#DIV/0!"}}]
["Methaan+lachgas emissie vergisten",{"$f":"E43+E44","v":0},null,"massa-% naar vergister + biogaspotentieel",null,"'energetische fractie' gft t.o.v. totaal afval",null,{"$f":"IF('Processen & Producten'!E22=0,0,B92*$F$95)","v":0},{"$f":"H92/Input!$K$14","v":{"$error":"#DIV/0!"}}]
["Methaan+lachgas emissie composteren",{"$f":"E45+E46","v":0},null,"massa-% naar composteren",null,{"$f":"(Input!K14*Input!N14)/((Input!K14*Input!N14)+(Input!K15*Input!N15)+(Input!K16*Input!N16))","v":{"$error":"#DIV/0!"}},null,{"$f":"B93*$F$91","v":{"$error":"#DIV/0!"}},{"$f":"H93/Input!$K$14","v":{"$error":"#DIV/0!"}}]
["Product naar Bio-energiecentrale",{"$f":"E48","v":0},null,"massa",null,"'energetische fractie' gft t.o.v. totaal naar vergister",null,{"$error":"#DIV/0!"},{"$f":"H94/Input!$K$14","v":{"$error":"#DIV/0!"}}]
["Opbrengst WKK",{"$f":"(E49+E50+E51)","v":0},null,"massa-% naar vergister + biogaspotentieel",null,{"$f":"('Processen & Producten'!F16*Input!N14)/(('Processen & Producten'!F16*Input!N14)+('Processen & Producten'!F17*Input!N15)+('Processen & Producten'!F18*Input!N16))","v":{"$error":"#DIV/0!"}},null,{"$f":"IF('Processen & Producten'!E22=0,0,B95*$F$95)","v":0},{"$f":"H95/Input!$K$14","v":{"$error":"#DIV/0!"}}]
["Opbrengst Groen gas",{"$f":"SUM(E52:E60)","v":0},null,"massa-% naar vergister + biogaspotentieel",null,null,null,{"$f":"IF('Processen & Producten'!E22=0,0,B96*$F$95)","v":0},{"$f":"H96/Input!$K$14","v":{"$error":"#DIV/0!"}}]
["Alternatieve opwerking",{"$f":"E61","v":0},null,"massa-% naar vergister + biogaspotentieel",null,null,null,{"$f":"IF('Processen & Producten'!E22=0,0,B97*$F$95)","v":0},{"$f":"H97/Input!$K$14","v":{"$error":"#DIV/0!"}}]
["Warmteterugwinning",{"$f":"E62","v":0},null,"massa",null,null,null,{"$f":"B98*$F$87","v":{"$error":"#DIV/0!"}},{"$f":"H98/Input!$K$14","v":{"$error":"#DIV/0!"}}]
["Water naar RWZI",{"$f":"E63","v":0},null,"massa",null,null,null,{"$f":"B99*$F$87","v":{"$error":"#DIV/0!"}},{"$f":"H99/Input!$K$14","v":{"$error":"#DIV/0!"}}]
["Residu naar AEC/stort/bouw/ferro recycling",{"$f":"(E64+E65+E66+E67)","v":0},null,"massa",null,null,null,{"$error":"#DIV/0!"},{"$f":"H100/Input!$K$14","v":{"$error":"#DIV/0!"}}]
["Transport (afvoer compost)",{"$f":"(E69+E68+E70)","v":0},null,"massa",null,null,null,{"$error":"#DIV/0!"},{"$f":"H101/Input!$K$14","v":{"$error":"#DIV/0!"}}]
["Veenvervanging",{"$f":"(E72+E74)","v":0},null,"massa",null,null,null,{"$error":"#DIV/0!"},{"$f":"H102/Input!$K$14","v":{"$error":"#DIV/0!"}}]
["Kunstmestvervanging",{"$f":"SUM(E75:E79)","v":0},null,"massa",null,null,null,{"$error":"#DIV/0!"},{"$f":"H103/Input!$K$14","v":{"$error":"#DIV/0!"}}]
["Koolstofvastlegging",{"$f":"E80","v":0},null,"massa",null,null,null,{"$error":"#DIV/0!"},{"$f":"H104/Input!$K$14","v":{"$error":"#DIV/0!"}}]
["Totaal",{"$f":"SUM(B87:B104)","v":0},null,null,null,null,"Totaal",{"$f":"SUM(H87:H104)","v":{"$error":"#DIV/0!"}},null,null,"Totaal",{"$f":"SUM(L87:L89)","v":0},{"$f":"SUM(M87:M89)","v":{"$error":"#DIV/0!"}},{"$f":"SUM(N87:N89)","v":{"$error":"#DIV/0!"}}]
["totaal per ton verwerkt afval (niet gealloceerd)",{"$f":"CO2resultaat/$D$2","v":{"$error":"#DIV/0!"}},null,null,null,null,"totaal per ton gft",{"$f":"H105/Input!K14","v":{"$error":"#DIV/0!"}}]
["(Biogene CO2 emissies compostering/vergisting worden niet meegerekend.)"]
[]
[]
["Resultaten totaal (kg CO2 eq gealloceerd naar gft-fractie) tbv grafiek"]
[null,"Transport (aanvoer afval)","Elektriciteitverbruik","Houtgebruik","Dieselgebruik","Gasgebruik","Methaan+lachgas vergisten","Methaan+lachgas composteren","Product naar Bio-energiecentrale","Opbrengst WKK","Opbrengst Groen gas","Alternatieve opwerking","Warmteterugwinning","Water naar RWZI","Residu naar AEC/stort/bouw/ferro recycling","Transport (afvoer compost)","Veenvervanging","Kunstmestvervanging","Koolstofvastlegging"]
["Transport (aanvoer afval)",{"$f":"H87","v":{"$error":"#DIV/0!"}}]
["Elektriciteitverbruik",null,{"$f":"H88","v":{"$error":"#DIV/0!"}}]
["Houtgebruik",null,null,{"$f":"H89","v":{"$error":"#DIV/0!"}}]
["Dieselgebruik",null,null,null,{"$f":"H90","v":{"$error":"#DIV/0!"}}]
["Gasgebruik",null,null,null,null,{"$f":"H91","v":{"$error":"#DIV/0!"}}]
["Methaan+lachgas vergisten",null,null,null,null,null,{"$f":"H92","v":0}]
["Methaan+lachgas composteren",null,null,null,null,null,null,{"$f":"H93","v":{"$error":"#DIV/0!"}}]
["Product naar Bio-energiecentrale",null,null,null,null,null,null,null,{"$f":"H94","v":{"$error":"#DIV/0!"}}]
["Opbrengst WKK",null,null,null,null,null,null,null,null,{"$f":"H95","v":0}]
["Opbrengst Groen gas",null,null,null,null,null,null,null,null,null,{"$f":"H96","v":0}]
["Alternatieve opwerking",null,null,null,null,null,null,null,null,null,null,{"$f":"H97","v":0}]
["Warmteterugwinning",null,null,null,null,null,null,null,null,null,null,null,{"$f":"H98","v":{"$error":"#DIV/0!"}}]
["Water naar RWZI",null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"H99","v":{"$error":"#DIV/0!"}}]
["Residu naar AEC/stort/bouw/ferro recycling",null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"H100","v":{"$error":"#DIV/0!"}}]
["Transport (afvoer compost)",null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"H101","v":{"$error":"#DIV/0!"}}]
["Compost",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"H102","v":{"$error":"#DIV/0!"}},{"$f":"H103","v":{"$error":"#DIV/0!"}},{"$f":"H104","v":{"$error":"#DIV/0!"}}]
[]
[]
["Totaal",34.469989032531259]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
["Resultaten per hoofdcategorie (kg CO2 eq) tbv grafiek"]
[]
[null,"Transport","Verwerkingsproces","Product"]
["Transport",{"$f":"M87","v":{"$error":"#DIV/0!"}}]
["Verwerkingsproces",null,{"$f":"M88","v":{"$error":"#DIV/0!"}}]
["Product",null,null,{"$f":"M89","v":{"$error":"#DIV/0!"}}]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
["Resultaten per ton gft afval (kg CO2 eq gealloceerd naar gft-fractie) tbv grafiek"]
[null,"Transport (aanvoer afval)","Elektriciteitverbruik","Houtgebruik","Dieselgebruik","Gasgebruik","Methaan+lachgas emissie vergisten","Methaan+lachgas emissie composteren","Product naar Bio-energiecentrale","Opbrengst WKK","Opbrengst Groen gas","Alternatieve opwerking","Warmteterugwinning","Water naar RWZI","Residu naar AEC/stort/bouw/ferro recycling","Transport (afvoer compost)","Veenvervanging","Kunstmestvervanging","Koolstofvastlegging"]
["Transport (aanvoer afval)",{"$f":"I87","v":{"$error":"#DIV/0!"}}]
["Elektriciteitverbruik",null,{"$f":"I88","v":{"$error":"#DIV/0!"}}]
["Houtgebruik",null,null,{"$f":"I89","v":{"$error":"#DIV/0!"}}]
["Dieselgebruik",null,null,null,{"$f":"I90","v":{"$error":"#DIV/0!"}}]
["Gasgebruik",null,null,null,null,{"$f":"I91","v":{"$error":"#DIV/0!"}}]
["Methaan+lachgas emissie vergisten",null,null,null,null,null,{"$f":"I92","v":{"$error":"#DIV/0!"}}]
["Methaan+lachgas emissie composteren",null,null,null,null,null,null,{"$f":"I93","v":{"$error":"#DIV/0!"}}]
["Product naar Bio-energiecentrale",null,null,null,null,null,null,null,{"$f":"I94","v":{"$error":"#DIV/0!"}}]
["Opbrengst WKK",null,null,null,null,null,null,null,null,{"$f":"I95","v":{"$error":"#DIV/0!"}}]
["Opbrengst Groen gas",null,null,null,null,null,null,null,null,null,{"$f":"I96","v":{"$error":"#DIV/0!"}}]
["Alternatieve opwerking",null,null,null,null,null,null,null,null,null,null,{"$f":"I97","v":{"$error":"#DIV/0!"}}]
["Warmteterugwinning",null,null,null,null,null,null,null,null,null,null,null,{"$f":"I98","v":{"$error":"#DIV/0!"}}]
["Water naar RWZI",null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"I99","v":{"$error":"#DIV/0!"}}]
["Residu naar AEC/stort/bouw/ferro recycling",null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"I100","v":{"$error":"#DIV/0!"}}]
["Transport (afvoer compost)",null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"I101","v":{"$error":"#DIV/0!"}}]
["Compost",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"I102","v":{"$error":"#DIV/0!"}},{"$f":"I103","v":{"$error":"#DIV/0!"}},{"$f":"I104","v":{"$error":"#DIV/0!"}}]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
["Resultaten per hoofdcategorie per ton gft-afval (kg CO2 eq) tbv grafiek"]
[]
[null,"Transport","Verwerkingsproces","Product","Totaal"]
["Transport",{"$f":"N87","v":{"$error":"#DIV/0!"}}]
["Verwerkingsproces",null,{"$f":"N88","v":{"$error":"#DIV/0!"}}]
["Product",null,null,{"$f":"N89","v":{"$error":"#DIV/0!"}}]
["Totaal",null,null,null,{"$f":"SUM(B270,C271,D272)","v":{"$error":"#DIV/0!"}}]

{"sheet":"Resultaat","index":6,"n_rows":41,"n_cols":30,"rows_kept":41,"cut":false,"hidden":false,"merged":[[6,1,6,5]]}
[]
[null,null,null,"CO2-tool gft-verwerking 2.0"]
[]
[null,"Bedrijf:",null,{"$f":"Naam_bedrijf","v":0}]
[null,"Locatie:",null,{"$f":"Locatie","v":0}]
[null,"Jaar:",null,{"$f":"jaartal","v":0}]
[]
[]
[null,"Massabalans"]
[null,"Aanvoer",null,null,null,"ton","%"]
[null,"aanvoer  totaal",null,null,null,{"$f":"Input!K12","v":0}]
[null,"waarvan input vergister",null,null,null,{"$f":"'Processen & Producten'!E22","v":0},{"$f":"F12/F11","v":{"$error":"#DIV/0!"}}]
[]
[null,"Afvoer",null,null,null,"ton","%"]
[null,"GFT-compost",null,null,null,{"$f":"'Processen & Producten'!J31","v":0},{"$f":"F15/$F$11","v":{"$error":"#DIV/0!"}}]
[null,"biogas",null,null,null,{"$f":"('Processen & Producten'!U9+'Processen & Producten'!U14)*1.15*0.001","v":0},{"$error":"#DIV/0!"}]
[null,"biomassa naar BEC",null,null,null,{"$f":"Kengetallen!C48/1000","v":0},{"$error":"#DIV/0!"}]
[null,"residu AEC",null,null,null,{"$f":"Kengetallen!C64/1000","v":0},{"$error":"#DIV/0!"}]
[null,"proceswater (extern)",null,null,null,{"$f":"'Processen & Producten'!U41","v":0},{"$error":"#DIV/0!"}]
[null,"bouwstof/inert/stort",null,null,null,{"$f":"SUM(Kengetallen!C65,Kengetallen!C66)/1000","v":0},{"$error":"#DIV/0!"}]
[null,"schroot/Ferro",null,null,null,{"$f":"Kengetallen!C67/1000","v":0},{"$error":"#DIV/0!"}]
[null,"afvoer totaal",null,null,null,{"$f":"SUM(F15:F21)","v":0},{"$error":"#DIV/0!"}]
[null,"afbraak materiaal (omzetting H2O, CO2, CH4, sporen)",null,null,null,null,{"$f":"1-G22","v":{"$error":"#DIV/0!"}}]
[]
[null,"Energiebalans"]
[null,"Verbruik",null,null,"totaal","per ton gft","MJ per ton gft"]
[null,"Elektriciteit (kWh)",null,null,{"$f":"SUM(Kengetallen!C32:C36)","v":0},{"$f":"E27/Input!$K$12","v":{"$error":"#DIV/0!"}},{"$f":"F27*3.6","v":{"$error":"#DIV/0!"}}]
[null,"Gas (m3)",null,null,{"$f":"Kengetallen!C39+Kengetallen!C40","v":0},{"$f":"E28/Input!$K$12","v":{"$error":"#DIV/0!"}},{"$f":"F28*31.65","v":{"$error":"#DIV/0!"}}]
[null,"Diesel (liter)",null,null,{"$f":"Kengetallen!C38","v":0},{"$f":"E29/Input!$K$12","v":{"$error":"#DIV/0!"}},{"$f":"F29*36","v":{"$error":"#DIV/0!"}}]
[null,"Totaal (MJ/ton gft)",null,null,null,null,{"$f":"SUM(G27:G29)","v":{"$error":"#DIV/0!"}}]
[]
[null,"Opbrengst",null,null,"totaal","per ton gft","MJ per ton gft"]
[null,"Biogas (ruw, m3)",null,null,{"$f":"'Processen & Producten'!U9+'Processen & Producten'!U14","v":0},{"$f":"E33/Input!$K$12","v":{"$error":"#DIV/0!"}}]
[null,"Warmte uit wkk (MJ)",null,null,{"$f":"Kengetallen!C50","v":0},{"$f":"E34/Input!$K$12","v":{"$error":"#DIV/0!"}},{"$f":"F34","v":{"$error":"#DIV/0!"}}]
[null,"Elektriciteit  uit wkk (kWh)",null,null,{"$f":"Kengetallen!C51","v":0},{"$f":"E35/Input!$K$12","v":{"$error":"#DIV/0!"}},{"$f":"F35*3.6","v":{"$error":"#DIV/0!"}}]
[null,"Groengas (m3)",null,null,{"$f":"SUM(Kengetallen!C52:C56)","v":0},{"$f":"E36/Input!$K$12","v":{"$error":"#DIV/0!"}},{"$f":"F36*31.65","v":{"$error":"#DIV/0!"}}]
[null,"Warmteterugwinning (MJ)",null,null,{"$f":"Kengetallen!C62","v":0},{"$f":"E37/Input!$K$12","v":{"$error":"#DIV/0!"}},{"$f":"F37","v":{"$error":"#DIV/0!"}}]
[null,"Totaal (MJ/ton gft)",null,null,null,null,{"$f":"SUM(G34:G37)","v":{"$error":"#DIV/0!"}}]
[]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"CONCATENATE(\"Resultaat voor de totale hoeveelheid verwerkt gft-afval: \",ROUND(CO2resultgealloceerd,0),\"\")","v":{"$error":"#DIV/0!"}},"kg CO2-eq. ",null,null,null,null,null,null,null,null,null,{"$f":"IF(Input!K12=0,\"Per ton verwerkt gft-afval: 0\",CONCATENATE(\"Per ton verwerkt gft-afval: \",ROUND(CO2resultpertongealloceerd,0)))","v":"Per ton verwerkt gft-afval: 0"},"kg CO2-equivalenten"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"CONCATENATE(\"Resultaat voor de totale hoeveelheid verwerkt afval: \",ROUND(CO2resultaat,0),\"\")","v":"Resultaat voor de totale hoeveelheid verwerkt afval: 0"},"kg CO2-eq. ",null,null,null,null,null,null,null,null,null,{"$f":"IF(Input!K12=0,\"Per ton verwerkt afval: 0\",CONCATENATE(\"Per ton verwerkt afval: \",ROUND(CO2resultaat_per_ton,0)))","v":"Per ton verwerkt afval: 0"},"kg CO2-equivalenten"]

{"sheet":"Invoerscherm groentool","index":7,"n_rows":84,"n_cols":23,"rows_kept":84,"cut":false,"hidden":true,"merged":[[28,16,28,17],[28,19,28,21],[49,8,49,10],[25,16,25,17],[25,19,25,21],[26,16,26,17],[26,19,26,21],[27,16,27,17],[27,19,27,21]]}
[]
[null,null,null,"CO2-tool opwerking groene reststromen 1.1"]
[]
[null,null,null,null,null,null,null,null,"Transport van groenafval",null,null,null,null,null,null,null,"Bedrijf:",{"$f":"CONCATENATE(Naam_bedrijf, \", \",Locatie)","v":", "}]
[null,null,null,null,null,null,null,null,null,null,null,"Ton per jaar","Afstand (km)",null,null,null,"Jaar:",{"$f":"jaartal","v":0}]
[null,null,null,null,null,null,null,null,null,null,"Zwaar transport (truck)",null,35,{"$f":"CONCATENATE(\" (\",Defaults!M6,\" km)\")","v":" ( km)"},null,null,{"$f":"IF(T7=1,\"Werkt volgens best practice\",\"Werkt niet volgens best practice\")","v":{"$error":"#REF!"}}]
[null,null,null,null,null,null,null,null,null,null,"Licht transport (bestelbus met aanhanger)",null,20,{"$f":"CONCATENATE(\" (\",Defaults!M7,\" km)\")","v":" ( km)"},null,null,null,null,null,{"$f":"IF(AND(Welkom!#REF!=TRUE,Welkom!#REF!=TRUE,Welkom!#REF!=TRUE,Welkom!#REF!=TRUE,Welkom!#REF!=TRUE,Welkom!#REF!=TRUE),1,0)","v":{"$error":"#REF!"}}]
[null,null,null,null,null,null,null,null,null,null,"Tractor met aanhanger",null,10,{"$f":"CONCATENATE(\" (\",Defaults!M8,\" km)\")","v":" ( km)"}]
[]
[]
[null,null,null,null,null,null,null,null,null,"Aangeleverd groenafval of deelstromen daaruit"]
[null,null,null,null,null,null,null,null,null,null,null,"Totale hoeveelheid (ton per jaar)",40]
[null,null,"Energieverbruik"]
[null,null,null,null,null,"Elektriciteit, grijs (kWh/ton groenafval)",null,null,null,null,null,"Hout (%)"]
[null,null,null,null,null,"Elektriciteit, groene stroom mix (kWh/ton groenafval)",null,null,null,null,null,"Gras (%)"]
[null,null,null,null,null,"Elektriciteit, windenergie (kWh/ton groenafval)",null,null,null,null,null,"Blad (%)"]
[null,null,null,null,null,"Elektriciteit, zonne-energie (PV) (kWh/ton groenafval)",null,null,null,null,null,"Tuinbouwafval (%)",null,null,null,null,"Samenstelling tijdens composteren:"]
[null,null,null,null,null,"Diesel (liter/ton groenafval)",null,null,null,null,null,"Overig (%)",{"$f":"1-SUM(M14:M17)","v":1},null,null,null,null,"Hout-achtig (kg/ton)",{"$f":"M14*1000-C82","v":0},{"$f":"S18/SUM(S$18:S$19)","v":0}]
[null,null,null,null,null,"Gas (m3/ton groenafval)",null,null,null,null,null,null,null,null,null,null,null,"Niet-hout (kg/ton)",{"$f":"SUM(M15:M18)*1000-C84","v":1000},{"$f":"S19/SUM(S$18:S$19)","v":1}]
[]
[null,null,"Hout naar bio-energiecentrale"]
[null,null,null,null,null," Hout, afgescheiden vóór compostering (kg/ton groenafval)",null,null,null,null,null,null,null,null,null,"Alternatieve opwerking overige deelstromen"]
[null,null,null,null,null," Hout, afgescheiden na compostering (kg/ton groenafval)",null,null,null,null,null,null,null,null,null,null,null,null,"kg"]
[null,null,null,null,null,"Calorische waarde hout (MJ/kg)",9.3000000000000007,{"$f":"CONCATENATE(\" (\",Defaults!G24,\")\")","v":" ()"},null,null,null,null,null,null,null,null,null,null,"(per ton",null,null,null,"Netto kg "]
[null,null,null,null,null,"Rendement thermisch (%)",0.6,{"$f":"CONCATENATE(\" (\",Defaults!G25*100,\"%)\")","v":" (0%)"},null,null,null,null,null,null,null,null,"Deelstroom",null,"groenafval)","Opwerkingsproces",null,null,"CO2 eq"]
[null,null,null,null,null,"Rendement elektrisch (%)",0,{"$f":"CONCATENATE(\" (\",Defaults!G26*100,\"%)\")","v":{"$error":"#VALUE!"}}]
[]
[null,null,"Gras naar co-vergister",null,null,null,"Opbrengst "]
[null,null,null,null,null,"kg gras","(m3 "]
[null,null,null,null,null,"/ton groenafval","biogas /ton gras)"]
[null,null,null,null,"Gras naar vergisting met opwekking elektriciteit",null,77,{"$f":"CONCATENATE(\" (\",Defaults!G31,\" m3/ton)\")","v":" (Calorische waarde (MJ/kg) m3/ton)"},null,null,null,null,null,null,null,"Surplus water naar RWZI"]
[null,null,null,null,"Gras naar vergisting met productie groen gas",null,77,{"$f":"CONCATENATE(\" (\",Defaults!G32,\" m3/ton)\")","v":" (Rendement thermisch (%) m3/ton)"},null,null,null,null,null,null,null,null,null,null,"Water (m3/ton groenafval)"]
[]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Residu naar AVI / stort"]
[null,null,"Zeefgrond",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"AVI (kg/ton groenafval)",15,{"$f":"CONCATENATE(\" (\",Defaults!T35,\")\")","v":" ()"}]
[null,null,null,null,null,"Zeefgrond (kg/ton groenafval)",null,null,null,null,null,null,null,null,null,null,null,null,"Stort (kg/ton groenafval)",0,{"$f":"CONCATENATE(\" (\",Defaults!T36,\")\")","v":" ()"}]
[]
[null,null,"Terugwinning warmte uit compostvloeren"]
[null,null,null,null,null,"Geleverde warmte (MJ/ton groenafval)"]
[]
[null,null,null,null,null,null,null,null,"Transport van compost"]
[null,null,null,null,null,null,null,null,null,null,"Ton per jaar","Afstand (km)"]
[null,null,null,null,null,null,null,null,null,"Enkele vrachtwagen",null,30,{"$f":"CONCATENATE(\" (\",Defaults!L43,\" km)\")","v":" ( km)"}]
[null,null,null,null,null,null,null,null,null,"Dubbele vrachtwagen",null,30,{"$f":"CONCATENATE(\" (\",Defaults!L44,\" km)\")","v":" ( km)"}]
[null,null,null,null,null,null,null,null,null,"Tractor met aanhanger",null,10,{"$f":"CONCATENATE(\" (\",Defaults!M46,\" km)\")","v":" ( km)"}]
[]
[]
[null,null,null,null,null,null,null,"Compost"]
[null,null,null,null,null,"Kenmerken Compost",null,null,null,null,"Marktverdeling"]
[null,null,null,null,null,"Opbrengst (kg/ton groenafval)",1,null,"Landbouw (akkerbouw, vollegronds tuinbouw, boomteelt)",null,null,1,{"$f":"CONCATENATE(\" (\",Defaults!L50*100,\"%)\")","v":" (0%)"}]
[null,null,null,null,null,"Totale opbrengst compost per jaar (kg):",{"$f":"G50*M12","v":40},null,null,null,"Glastuinbouw",0,{"$f":"CONCATENATE(\" (\",Defaults!L51,\")\")","v":" ()"}]
[null,null,null,null,null,"ds (%)",null,null,null,null,"Hoveniers, particulieren",0,{"$f":"CONCATENATE(\" (\",Defaults!L52,\")\")","v":" ()"}]
[null,null,null,null,null,"Stikstof [N] (g/kg ds)",null,null,null,null,"Gemeenten (groenvoorziening)",0,{"$f":"CONCATENATE(\" (\",Defaults!L53,\")\")","v":" ()"}]
[null,null,null,null,null,"Fosfaat [P2O5] (g/kg ds)",null,null,null,null,"Potgrondsubstraten en aanvulgrond",0,{"$f":"CONCATENATE(\" (\",Defaults!L54,\")\")","v":" ()"}]
[null,null,null,null,null,"Kalium [K2O] (g/kg ds)",null,null,null,null,"Specifiek samengestelde grondproducten",0,{"$f":"CONCATENATE(\" (\",Defaults!L55,\")\")","v":" ()"}]
[null,null,null,null,null,"Organische stof (O.S.) (g/kg ds)",null,null,null,null,"Aannemerij/wegenbouw",0,{"$f":"CONCATENATE(\" (\",Defaults!L59,\")\")","v":" ()"}]
[null,null,null,null,null,null,null,null,null,null,"Anders (w.o. tussenhandel)",{"$f":"1-SUM(L50:L56)","v":0},{"$f":"CONCATENATE(\" (\",Defaults!L57,\")\")","v":" ()"}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(T7=1,\"\",\"Resultaat niet betrouwbaar. Werkt niet volgens best practice.\")","v":{"$error":"#REF!"}}]
[null,null,null,null,null,null,null,null,null,null,null,{"$f":"CONCATENATE(\"Resultaat: \",ROUND(CO2resultaat,0),\"\")","v":"Resultaat: 0"},"kg CO2-equivalenten",null,null,null,null,{"$f":"IF(M12=0,\"(0\",CONCATENATE(\"(\",ROUND(CO2resultaat_per_ton,0)))","v":{"$error":"#DIV/0!"}},"kg CO2-equivalenten per ton groenafval)"]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[null,null,"Lijst:"]
[null,null,"Hout"]
[null,null,"Gras"]
[null,null,"Blad"]
[null,null,"Tuinbouwafval"]
[null,null,"Overig"]
[]
[null,null,"Hout afgescheiden in voorbewerking:"]
[null,null,{"$f":"SUMIF(Q26:R29,\"Hout\",S26:S29)+IF(C91=C87,G22,0)+M14*G36","v":0}]
[null,null,"Overige stromen afgescheiden in voorbewerking (zeefgrond wordt deels aan de houtfractie, deels aan de overige fractie toegerekend)."]
[null,null,{"$f":"SUM(S26:S29)-SUMIF(Q26:R29,\"Hout\",S26:S29)+F32+SUM(M15:M18)*G36","v":0}]