{"text_format":"1","workbook":"xlsx","n_sheets":6,"sheets":["intro","Welkom","Hoofdscherm","Defaults","Kengetallen","Resultaat"],"not_rendered":{"charts":6,"images":6,"macros":1,"external_links":0,"defined_names":12,"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":32,"n_cols":10,"rows_kept":32,"cut":false,"hidden":false,"merged":[[28,3,28,8],[13,4,13,6],[14,4,14,6],[15,4,15,6],[18,2,20,9],[24,3,24,8]]}
[]
[null,null,null,"CO2-tool opwerking groene reststromen 1.0"]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[null,null,"Bedrijfsgegevens"]
[null,null,null,"Naam bedrijf"]
[null,null,null,"Locatie"]
[null,null,null,"Jaar invoer"]
[]
[null,null,"Bevestiging best practice"]
[null,null,"De groenafvaltool is alleen betrouwbaar te gebruiken wanneer sprake is van een vergunde inrichting met adequate systemen voor het wegen en administreren van materiaalstromen en andere operationele data. Daarnaast is specifiek van belang dat het composteerproces verloopt conform ‘goede praktijk’, omdat anders de emissies daarvan niet zijn in te schatten."]
[]
[]
[null,null,"Geef hieronder aan of u aan de criteria hiervoor voldoet."]
[]
[null,null,null,"Er is sprake van een vergunde inrichting;",null,null,null,null,null,false]
[null,null,null,"Er is een operationele weegbrug aanwezig, of een ander betrouwbaar systeem waarmee aan- en afgevoerde hoeveelheden worden gemonitord;",null,null,null,null,null,false]
[null,null,null,"Aangevoerd groenafval wordt gemeld bij het LMA.",null,null,null,null,null,false]
[]
[null,null,"Indien op de inrichting compostering plaatsvindt:"]
[null,null,null,"De composterende hopen hebben een zodanige hoogte en structuur dat voldoende zuurstoftoevoer plaatsvindt (indicatief: maximaal 3 meter hoogte en voldoende houtachtig materiaal aanwezig);",null,null,null,null,null,false]
[null,null,null,"Er is sprake van actieve procescontrole (temperatuur);",null,null,null,null,null,false]
[null,null,null,"De verantwoordelijke bedrijfsvoerder is ter zake kundig en geschoold ",null,null,null,null,null,false]
[null,null,null,"(bijvoorbeeld middeld de BVOR cursus compostering)."]

{"sheet":"Hoofdscherm","index":2,"n_rows":84,"n_cols":23,"rows_kept":84,"cut":false,"hidden":false,"merged":[[25,16,25,17],[26,16,26,17],[26,19,26,21],[25,19,25,21],[49,8,49,10],[27,16,27,17],[27,19,27,21],[28,16,28,17],[28,19,28,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":" (35 km)"},null,null,{"$f":"IF(T7=1,\"Werkt volgens best practice\",\"Werkt niet volgens best practice\")","v":"Werkt niet volgens best practice"}]
[null,null,null,null,null,null,null,null,null,null,"Licht transport (bestelbus met aanhanger)",null,20,{"$f":"CONCATENATE(\" (\",Defaults!M7,\" km)\")","v":" (20 km)"},null,null,null,null,null,{"$f":"IF(AND(Welkom!J24=TRUE,Welkom!J25=TRUE,Welkom!J26=TRUE,Welkom!J29=TRUE,Welkom!J30=TRUE,Welkom!J31=TRUE),1,0)","v":0}]
[null,null,null,null,null,null,null,null,null,null,"Tractor met aanhanger",null,10,{"$f":"CONCATENATE(\" (\",Defaults!M8,\" km)\")","v":" (10 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)",10]
[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":" (9,3)"},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":" (60%)"},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":" (0%)"}]
[]
[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":" (77 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":" (77 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":" (15)"}]
[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":" (0)"}]
[]
[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":" (30 km)"}]
[null,null,null,null,null,null,null,null,null,"Dubbele vrachtwagen",null,30,{"$f":"CONCATENATE(\" (\",Defaults!L44,\" km)\")","v":" (30 km)"}]
[null,null,null,null,null,null,null,null,null,"Tractor met aanhanger",null,10,{"$f":"CONCATENATE(\" (\",Defaults!L45,\" km)\")","v":" (10 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)",null,null,"Landbouw (akkerbouw, vollegronds tuinbouw, boomteelt)",null,null,1,{"$f":"CONCATENATE(\" (\",Defaults!L50*100,\"%)\")","v":" (100%)"}]
[null,null,null,null,null,"Totale opbrengst compost per jaar (ton):",{"$f":"G50*M12/1000","v":0},null,null,null,"Glastuinbouw",0,{"$f":"CONCATENATE(\" (\",Defaults!L51,\")\")","v":" (0)"}]
[null,null,null,null,null,"ds (%)",null,null,null,null,"Hoveniers, particulieren",0,{"$f":"CONCATENATE(\" (\",Defaults!L52,\")\")","v":" (0)"}]
[null,null,null,null,null,"Stikstof [N] (g/kg ds)",null,null,null,null,"Gemeenten (groenvoorziening)",0,{"$f":"CONCATENATE(\" (\",Defaults!L53,\")\")","v":" (0)"}]
[null,null,null,null,null,"Fosfaat [P2O5] (g/kg ds)",null,null,null,null,"Potgrondsubstraten en aanvulgrond",0,{"$f":"CONCATENATE(\" (\",Defaults!L54,\")\")","v":" (0)"}]
[null,null,null,null,null,"Kalium [K2O] (g/kg ds)",null,null,null,null,"Specifiek samengestelde grondproducten",0,{"$f":"CONCATENATE(\" (\",Defaults!L55,\")\")","v":" (0)"}]
[null,null,null,null,null,"Organische stof (O.S.) (g/kg ds)",null,null,null,null,"Aannemerij/wegenbouw",0,{"$f":"CONCATENATE(\" (\",Defaults!L56,\")\")","v":" (0)"}]
[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":" (0)"}]
[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":"Resultaat niet betrouwbaar. Werkt niet volgens best practice."}]
[null,null,null,null,null,null,null,null,null,null,null,{"$f":"CONCATENATE(\"Resultaat: \",ROUND(CO2resultaat,0),\"\")","v":"Resultaat: 398"},"kg CO2-equivalenten",null,null,null,null,{"$f":"IF(M12=0,\"(0\",CONCATENATE(\"(\",ROUND(CO2resultaat_per_ton,0)))","v":"(40"},"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}]

{"sheet":"Defaults","index":3,"n_rows":143,"n_cols":31,"rows_kept":143,"cut":false,"hidden":true,"merged":[[110,19,110,21],[111,19,111,21],[105,22,106,22],[106,19,106,21],[107,19,107,21],[108,19,108,21],[109,19,109,21],[25,19,25,21],[26,19,26,21],[27,19,27,21],[28,19,28,21],[49,8,49,10]]}
[]
[null,null,null,"CO2-tool groenafvalverwerking 1.0 DEFAULTS",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,"Kleurcode"]
[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,null,null,null,null,null,"defaultwaarde waarvoor data aanwezig zijn"]
[null,null,null,null,null,null,null,null,null,"Transport",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Nog geen goede waarde"]
[null,null,null,null,null,null,null,null,null,null,null,"Percen-tage","Afstand (km)",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Geen default nodig"]
[null,null,null,null,null,null,null,null,null,null,"Zwaar transport (trucks)",null,35,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Geen invoercel"]
[null,null,null,null,null,null,null,null,null,null,"Licht transport (bestelbus)",null,20]
[null,null,null,null,null,null,null,null,null,null,"Trekker",null,10]
[]
[]
[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)"]
[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,null,"Diesel (liter/ton groenafval)",null,null,null,null,null,"Overig (%)"]
[null,null,null,null,null,"Gas (m3/ton groenafval)"]
[]
[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,null,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,null,null,null,null,null,null,null,null,null,"Deelstroom",null,"groenafval)","Opwerkingsproces",null,null,"CO2 eq"]
[null,null,null,null,null,"Rendement elektrisch (%)",0]
[]
[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 wkk",null,77,null,null,null,null,null,null,null,null,"Water naar RWZI"]
[null,null,null,null,"Gras naar vergisting met productie groen gas",null,77,null,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]
[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]
[]
[null,null,"Terugwinning warmte uit compostvloeren"]
[null,null,null,null,null," Benutte warmte (MJ/ton groenafval)"]
[]
[null,null,null,null,null,null,null,null,"Transport"]
[null,null,null,null,null,null,null,null,null,null,"Percen-tage","Afstand (km)"]
[null,null,null,null,null,null,null,null,null,"Enkele vrachtwagen",null,30]
[null,null,null,null,null,null,null,null,null,"Dubbele vrachtwagen",null,30]
[null,null,null,null,null,null,null,null,null,"Tractor met aanhanger",null,10]
[]
[]
[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)",null,null,"Landbouw (akkerbouw, vollegronds tuinbouw, boomteelt)",null,null,1]
[null,null,null,null,null,null,null,null,null,null,"Glastuinbouw",0]
[null,null,null,null,null,"ds (%)",null,null,null,null,"Hoveniers, particulieren",0]
[null,null,null,null,null,"Stikstof [N] (g/kg ds)",null,null,null,null,"Gemeenten (groenvoorziening)",0]
[null,null,null,null,null,"Fosfaat [P2O5] (g/kg ds)",null,null,null,null,"Potgrondsubstraten en aanvulgrond",0]
[null,null,null,null,null,"Kalium [K2O] (g/kg ds)",null,null,null,null,"Specifiek samengestelde grondproducten",0]
[null,null,null,null,null,"Organische stof (O.S.) (g/kg ds)",null,null,null,null,"Aannemerij/wegenbouw",0]
[null,null,null,null,null,null,null,null,null,null,"Anders (w.o. tussenhandel)",0]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[null,null,null,"CO2-tool groenafvalverwerking 1.0 DEFAULTS"]
[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,null,null,null,null,"Kleurcode"]
[null,null,null,null,null,null,null,null,null,"Transport",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"defaultwaarde waarvoor data aanwezig zijn"]
[null,null,null,null,null,null,null,null,null,null,null,"Percen-tage","Afstand (km)",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Nog geen goede waarde"]
[null,null,null,null,null,null,null,null,null,null,"Truck ",0.5,30]
[null,null,null,null,null,null,null,null,null,null,"Truck + aanhanger",0.5,30]
[null,null,null,null,null,null,null,null,null,null,"Bestelbus",0.25,30,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"truck"]
[null,null,null,null,null,null,null,null,null,null,"Personenauto + aanhanger",0.25,30,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"schip"]
[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,null,null,null,null,null,"trein"]
[]
[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)",12]
[]
[null,null,"Energieverbruik",null,null,null,null,null,null,null,null,"Hout (%)",0.4,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"schip"]
[null,null,null,null,null,"Elektriciteit grijs (kWh/ton groenafval)",5,null,null,null,null,"Gras (%)",0.3]
[null,null,null,null,null,"Elektriciteit groen (kWh/ton groenafval)",0,null,null,null,null,"Blad (%)",0.2]
[null,null,null,null,null,"Diesel (liter/ton groenafval)",3,null,null,null,null,"Tuinbouwafval (%)",0]
[null,null,null,null,null,"Gas (m3/ton groenafval)",0,null,null,null,null,"Overig (%)",{"$f":"1-SUM(M97:M100)","v":0.10000000000000009}]
[]
[]
[]
[]
[null,null,"Hout naar bio-energiecentrale",null,null,null,null,null,null,null,null,null,null,null,null,"Alternatieve opwerken overige deelstromen",null,null,null,null,null,null,"Netto kg CO2 eq"]
[null,null,null,null,null," Hout (kg/ton groenafval)",80,null,null,null,null,null,null,null,null,null,null,null,"kg","Opwerkingsproces"]
[null,null,"Gras naar co-vergister",null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Hout (per ton groenafval)",0,null,null,null,0]
[null,null,null,null,null,"Gras (kg/ton groenafval)",150,null,null,null,null,null,null,null,null,null,null,"Gras (per ton groenafval)",0,null,null,null,0]
[null,null,"Zeefgrond",null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Blad (per ton groenafval)",0,null,null,null,0]
[null,null,null,null,null,"Zeefgrond (kg/ton groenafval)",80,null,null,null,null,null,null,null,null,null,null,"Tuinbouwafval (per ton groenafval)",0,null,null,null,0]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Overig (per ton groenafval)",0,null,null,null,0]
[]
[null,null,null,null,null,null,null,null,null,null,"Samenstelling na afscheiding deelstromen:"]
[null,null,null,null,null,null,null,null,null,null,null,"Hout-achtig (kg/ton)",{"$f":"M97*1000-G107-S108-M97*G111","v":288},{"$f":"M115/SUM(M$34:M$35)","v":{"$error":"#DIV/0!"}}]
[null,null,null,null,null,null,null,null,null,null,null,"Niet-hout (kg/ton)",{"$f":"SUM(M98:M101)*1000-G109-(1-M97)*G111-SUM(S109:S112)","v":402.00000000000011},{"$f":"M116/SUM(M$34:M$35)","v":{"$error":"#DIV/0!"}}]
[]
[]
[null,null,"Terugwinning warmte uit compostvloeren",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,null,null,"truck"]
[null,null,null,null,null," Benutte warmte (MJ/ton groenafval)",15]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Water naar percolaatbassin (?)",null,null,null,null,null,"Water naar RWZI"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Water (liter/ton groenafval)",50,null,null,null,null,"Water (m3/ton groenafval)",5]
[null,null,"Residu naar AVI / stort"]
[null,null,null,null,null,"AVI (kg/ton groenafval)",15]
[null,null,null,null,null,"Stort (kg/ton groenafval)",0]
[]
[]
[null,null,null,null,null,null,null,null,null,"Transport"]
[null,null,null,null,null,null,null,null,null,null,null,"Transportmiddel"]
[null,null,null,null,null,null,null,null,null,null,null,"Afstand (km)",35]
[]
[]
[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)",350,null,null,null,"akkerbouw (%)",{"$f":"1-SUM(L137:L140)","v":0.69}]
[null,null,null,null,null,"ds (%)",69,null,null,null,"glastuinbouw (%)",0.05]
[null,null,null,null,null,"Stikstof [N] (g/kg ds)",8.23,null,null,null,"potgrond (%)",0.16]
[null,null,null,null,null,"Fosfaat [P2O5] (g/kg ds)",4.12,null,null,null,"tuincentra (%)",0.01]
[null,null,null,null,null,"Kalium [K2O] (g/kg ds)",8.25,null,null,null,"overigen (%)",0.09]
[null,null,null,null,null,"Organische stof (O.S.) (g/kg ds)",244]
[]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"CONCATENATE(\"Resultaat: \",ROUND([0]!CO2resultaat,0),\"\")","v":"Resultaat: 398"},"kg CO2-equivalenten"]

{"sheet":"Kengetallen","index":4,"n_rows":152,"n_cols":18,"rows_kept":152,"cut":false,"hidden":true,"merged":[]}
["Startpunt: totale hoeveelheid groene reststromen"]
[null,null,null,{"$f":"Hoofdscherm!M12","v":10},"ton ",null,null,null,null,"Kleurcode"]
[null,null,"Fractie hout",{"$f":"Hoofdscherm!M14","v":0},"%",null,null,null,null,null,"invoer"]
[null,null,"Fractie gras",{"$f":"Hoofdscherm!M15","v":0},"%",null,null,null,null,null,"berekening"]
[null,null,"Fractie blad",{"$f":"Hoofdscherm!M16","v":0},"%",null,null,null,null,null,"kengetallen & berekening uit oude gft-tool"]
[null,null,"Fractie tuinafval",{"$f":"Hoofdscherm!M17","v":0},"%",null,null,null,null,null,"geupdate kengetallen"]
[null,null,"Fractie overig",{"$f":"Hoofdscherm!M18","v":1},"%"]
[]
[null,null,null,null,null,null,{"$f":"hoeveelheid_compost*H18","v":0}]
["Compost eigenschappen en toepassing"]
["compost","kg compost / ton groenafval",{"$f":"Hoofdscherm!G50","v":0},"N-gehalte",{"$f":"Hoofdscherm!G53","v":0},"[N] in g/kg dw"]
[null,null,null,"C-gehalte",{"$f":"0.5*Hoofdscherm!G56/1000","v":0},"[C] in kg/kg dw"]
[null,null,null,"P-gehalte",{"$f":"Hoofdscherm!G54","v":0},"[P2O5] in g/kg dw"]
[null,null,null,"K-gehalte",{"$f":"Hoofdscherm!G55","v":0},"[K2O] in g/kg dw"]
[null,"%dw",{"$f":"Hoofdscherm!G52","v":0},"% 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":"Hoofdscherm!L50","v":1},0,0.5,1,"kunstmestvervanging totaal",{"$f":"(C16*E16)+(C17*E17)+(C18*E18)+(C19*E19)+(C20*E20)+(C21*E21)+(C22*E22)+(C23*E23)","v":0.5},"%",0.6,0.9,1]
["Tuinbouw","%",{"$f":"Hoofdscherm!L51","v":0},1,1,1,"koolstofvastlegging totaal",{"$f":"(C16*F16)+(C17*F17)+(C18*F18)+(C19*F19)+(C20*F20)+(C21*F21)+(C22*F22)+(C23*F23)","v":1},"%",0.6,0.9,1]
["Hoveniers, particulieren","%",{"$f":"Hoofdscherm!L52","v":0},1,1,1,"veenvervanging totaal",{"$f":"(C16*D16)+(C17*D17)+(C18*D18)+(C19*D19)+(C20*D20)+(C21*D21)+(C22*D22)+(C23*D23)","v":0},"%",0.6,0.9,1]
["Gemeenten","%",{"$f":"Hoofdscherm!L53","v":0},0.5,0,1,"vervangingswaarde compost",0.83,"kg veen / kg compost",0.6,0.9,1]
["Potgrondproducenten","%",{"$f":"Hoofdscherm!L54","v":0},1,1,1,"veenvervanging",{"$f":"H18*hoeveelheid_compost*H19","v":0},"kg",0.15,0.9,1]
["Grondproducten","%",{"$f":"Hoofdscherm!L55","v":0},1,1,1,null,null,null,0.6,0.9,1]
["Aannemerij/wegenbouw","%",{"$f":"Hoofdscherm!L56","v":0},0,0,1,null,null,null,0.6,0.9,1]
["Anders (w.o. tussenhandel)","%",{"$f":"Hoofdscherm!L57","v":0},0,0,1,null,null,null,0.6,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)","v":0.6},{"$f":"(C16*K16)+(C17*K17)+(C18*K18)+(C19*K19)+(C20*K20)+(C21*K21)+(C22*K22)+(C23*K23)","v":0.9},{"$f":"(C16*L16)+(C17*L17)+(C18*L18)+(C19*L19)+(C20*L20)+(C21*L21)+(C22*L22)+(C23*L23)","v":1}]
["Berekening per ton groenafval"]
["parameter","unit","amount","kg CO2-eq. Per unit","kg CO2-eq. Total","Remarks (references)"]
["transport zwaar (truck)","tkm",{"$f":"Hoofdscherm!L6*Hoofdscherm!M6/Hoofdscherm!$M$12","v":0},0.13,{"$f":"C27*D27","v":0},"vrachtauto >20 ton, CO2-prestatieladder v2.1, SKAO"]
["transport licht (bestelbus, personenauto)","tkm",{"$f":"Hoofdscherm!L7*Hoofdscherm!M7/Hoofdscherm!$M$12","v":0},0.63,0,"bestelauto, CO2-prestatieladder v2.1, SKAO"]
["Transport trekker","tkm",{"$f":"Hoofdscherm!L8*Hoofdscherm!M8/Hoofdscherm!$M$12","v":0},0.309,0,"EI - Transport, tractor and trailer (geen vergelijkbaar transportmiddel in CO2-prestatieladder)"]
["electriciteitsgebruik (grijs)","kWh",{"$f":"Hoofdscherm!G14","v":0},0.45500000000000002,{"$f":"C30*D30","v":0},"grijze stroom, 2010 en later, CO2-prestatieladder v2.1, SKAO"]
["electriciteitsgebruik (groen mix)","kWh",{"$f":"Hoofdscherm!G15","v":0},9.9076542000000004E-2,{"$f":"C31*D31","v":0},"1 kWh Electricity, low voltage, at grid/NL - Groene stroom; samenstelling obv SBK database"]
["electriciteitsgebruik (wind)","kWh",{"$f":"Hoofdscherm!G16","v":0},1.4999999999999999E-2,0,"groene stroom - windkracht, CO2-prestatieladder v2.1, SKAO"]
["electriciteitsgebruik (PV)","kWh",{"$f":"Hoofdscherm!G17","v":0},0.08,0,"groene stroom - zonne-energie, CO2-prestatieladder v2.1, SKAO"]
["dieselgebruik","liter",{"$f":"Hoofdscherm!G18","v":0},3.1349999999999998,0,"Diesel, CO2-prestatieladder v2.1, SKAO"]
["gasgebruik","m3",{"$f":"Hoofdscherm!G19","v":0},1.825,0,"Aardgas, CO2-prestatieladder v2.1, SKAO"]
["emissie methaan compostering","g",850,{"$f":"22.3/1000","v":2.23E-2},18.955000000000002,"ref. Cuhls et al. 2008"]
["emissie N2O compostering","g",72,{"$f":"298/1000","v":0.29799999999999999},21.456,"ref. Cuhls et al. 2008"]
["emissie CO2 compostering","g",0,0,null,"CO2 uit groenafval is biogeen, dus score 0."]
["Hout naar Bio-energiecentrale","kg",{"$f":"(Hoofdscherm!G22+Hoofdscherm!G23)","v":0},{"$f":"0.01636-(Hoofdscherm!G25*Hoofdscherm!G24*0.0777)-(Hoofdscherm!G26*Hoofdscherm!G24*0.186)","v":-0.41720600000000002},0,"afhankelijk van calorische waarde en rendement, uitsparing gebaseerd op Electricity mix/NL en Heat, natural gas, at industrial furnace"]
["Gras naar co-vergister met wkk","kg",{"$f":"Hoofdscherm!F31","v":0},{"$f":"(Hoofdscherm!G31/1000)*-1.31147","v":-0.10098318999999999},0,"meerdere Ecoinvent processen: Biogas, from biowaste, at agricultural co-fermentation, covered; Electricity, at cogen, biogas agricultural mix; Electricity mix/NL (avoided)"]
["Gras naar co-vergister voor groengas","kg",{"$f":"Hoofdscherm!F32","v":0},{"$f":"(Hoofdscherm!G32/1000)*-0.79826","v":-6.1466019999999996E-2},0,"meerdere Ecoinvent processen: Biogas, from biowaste, at agricultural co-fermentation, covered; Methane, 96 vol-%, from biogas, at purification"]
["Zeefgrond","kg",{"$f":"Hoofdscherm!G36","v":0},-2.3939005999999998E-3,0,"1 kg Sand, at mine/CH"]
["Alternatieve opwerking deelstromen","kg CO2 eq",{"$f":"SUM(Hoofdscherm!W26:W29)","v":0},1,0,"eigen data gebruiker"]
["Warmte (MJ/ton groenafval)",null,{"$f":"Hoofdscherm!G39","v":0},-7.7700000000000005E-2,0,"1 MJ heat from natural gas"]
["Water naar RWZI","m3",{"$f":"Hoofdscherm!T32","v":0},{"$f":"0.23*D30","v":0.10465000000000001},0,"Stowa"]
["residue to incineration","kg",{"$f":"Hoofdscherm!T35","v":15},-3.9865509E-2,-0.59798263500000004,"Verbranding 'municipal waste' in gemiddelde NL AVI, met opwekking warmte en elektriciteit"]
["residue to landfill","kg",{"$f":"Hoofdscherm!T36","v":0},7.1031035999999997E-3,0,"Disposal, inert waste, 5% water, to inert material landfill"]
["transport to compost application; enkele vrachtwagen","tkm",{"$f":"Hoofdscherm!K43*Hoofdscherm!L43/Hoofdscherm!$M$12","v":0},0.13,0,"vrachtauto >20 ton, CO2-prestatieladder v2.1, SKAO"]
["transport dubbele vrachtwagen","tkm",{"$f":"Hoofdscherm!K44*Hoofdscherm!L44/Hoofdscherm!$M$12","v":0},9.5000000000000001E-2,0,"trekker met oplegger, CO2-prestatieladder v2.1, SKAO"]
["trasport trekker","tkm",{"$f":"Hoofdscherm!K45*Hoofdscherm!L45/Hoofdscherm!$M$12","v":0},0.309,0,"EI - Transport, tractor and trailer (geen vergelijkbaar transportmiddel in CO2-prestatieladder)"]
[]
["veenvervanging","kg",{"$f":"H20","v":0},-0.85,{"$f":"C52*D52","v":0},"hele keten van veentoepassing: veenproductie (Ecoinvent), 90% emissie koolstof als fossiel CO2, na toepassing op het land."]
["substitution peat transport","km",1000,null,null,"veentransport"]
[null,"tkm",{"$f":"C52*C53/1000","v":0},-9.5000000000000001E-2,{"$f":"C54*D54","v":0},"trekker met oplegger, CO2-prestatieladder v2.1, SKAO"]
["substitution N-fertilizer","kg",{"$f":"H16*(E11/1000)*(C15/100)*hoeveelheid_compost*J24","v":0},-8.6539883,0,"Calcium ammonium nitrate, as N, at regional storehouse/RER"]
["substitution P-fertilizer","kg",{"$f":"H16*(E13/1000)*(C15/100)*hoeveelheid_compost*K24","v":0},-2.0213709999999998,0,"Triple superphosphate, as P2O5, at regional storehouse/RER"]
["substitution K-fertilizer","kg",{"$f":"H16*(E14/1000)*(C15/100)*hoeveelheid_compost*L24","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":"-D37","v":-0.29799999999999999},0,"1.25% van aanwezige N wordt N2O; molmassa N=14, N2O=44"]
["emissie N2O bij toepassing compost","g",{"$f":"E11*C15/100*hoeveelheid_compost*0.0125*(44/28)*0.5","v":0},{"$f":"$D$37","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 hoeveelheid groenafval",null,null,null,null,null,"Resultaten (kg CO2 eq) per hoofdcategorie"]
[null,null,null,null,"kg CO2/ton groenafval"]
["Transport (aanvoer groenafval)",{"$f":"SUM(E27:E29)*$D$2","v":0},null,null,{"$f":"B67/$D$2","v":0},null,"Transport",{"$f":"SUM(B67,B80)","v":0}]
["Elektriciteitverbruik",{"$f":"(E30+E31+E32+E33)*$D$2","v":0},null,null,{"$f":"B68/$D$2","v":0},null,"Composteringsproces",{"$f":"SUM(B68:B72,B78,B79)","v":398.13017365000002}]
["Dieselgebruik",{"$f":"E34*$D$2","v":0},null,null,0,null,"Product",{"$f":"SUM(B73:B77,B81:B83)","v":0}]
["Gasgebruik",{"$f":"E35*$D$2","v":0},null,null,0]
["Methaanemissie compostering",{"$f":"E36*$D$2","v":189.55},null,null,18.955000000000002]
["Lachgasemissie compostering",{"$f":"E37*$D$2","v":214.56},null,null,21.456]
["Hout naar Bio-energiecentrale",{"$f":"E39*$D$2","v":0},null,null,0]
["Gras naar co-vergister",{"$f":"(E40+E41)*$D$2","v":0},null,null,0]
["Zeefgrond",{"$f":"E42*$D$2","v":0},null,null,0]
["Alternatieve opwerking",0,null,null,0]
["Warmteterugwinning",0,null,null,0]
["Water naar RWZI",0,null,null,0]
["Residu naar AVI/stort",{"$f":"(E46+E47)*$D$2","v":-5.9798263500000006},null,null,-0.59798263500000004]
["Transport (afvoer compost)",{"$f":"(E48+E49+E50)*$D$2","v":0},null,null,0]
["Veenvervanging",{"$f":"(E52+E54)*$D$2","v":0},null,null,0]
["Kunstmestvervanging",{"$f":"SUM(E55:E59)*$D$2","v":0},null,null,0]
["Koolstofvastlegging",{"$f":"E60*$D$2","v":0},null,null,0]
["Totaal",{"$f":"SUM(B67:B83)","v":398.13017365000002},null,null,39.813017365,null,"Totaal",{"$f":"SUM(H67:H69)","v":398.13017365000002}]
["totaal per ton groenafval",{"$f":"CO2resultaat/$D$2","v":39.813017365}]
["(CO2 emissies compostering worden niet meegerekend omdat het biogeen is.)"]
[]
["Resultaten (kg CO2 eq) tbv grafiek"]
[]
[null,"Transport (aanvoer groenafval)","Elektriciteitverbruik","Dieselgebruik","Gasgebruik","Methaanemissie compostering","Lachgasemissie compostering","Hout naar Bio-energiecentrale","Gras naar co-vergister","Zeefgrond","Alternatieve opwerking","Warmteterugwinning","Water naar RWZI","Residu naar AVI/stort","Transport (afvoer compost)","Compost (veenvervanging)","Compost (kunstmestvervanging)","Compost (koolstofvastlegging)"]
["Transport (aanvoer groenafval)",{"$f":"B67","v":0}]
["Elektriciteitverbruik",null,{"$f":"B68","v":0}]
["Dieselgebruik",null,null,{"$f":"B69","v":0}]
["Gasgebruik",null,null,null,{"$f":"B70","v":0}]
["Methaanemissie compostering",null,null,null,null,{"$f":"B71","v":189.55}]
["Lachgasemissie compostering",null,null,null,null,null,{"$f":"B72","v":214.56}]
["Hout naar Bio-energiecentrale",null,null,null,null,null,null,{"$f":"B73","v":0}]
["Gras naar co-vergister",null,null,null,null,null,null,null,{"$f":"B74","v":0}]
["Zeefgrond",null,null,null,null,null,null,null,null,{"$f":"B75","v":0}]
["Alternatieve opwerking",null,null,null,null,null,null,null,null,null,{"$f":"B76","v":0}]
["Warmteterugwinning",null,null,null,null,null,null,null,null,null,null,{"$f":"B77","v":0}]
["Water naar RWZI",null,null,null,null,null,null,null,null,null,null,null,{"$f":"B78","v":0}]
["Residu naar AVI/stort",null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"B79","v":-5.9798263500000006}]
["Transport (afvoer compost)",null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"B80","v":0}]
["Compost",null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"B81","v":0},{"$f":"B82","v":0},{"$f":"B83","v":0}]
[]
[]
["Totaal",34.469989032531259]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
["Resultaten per hoofdcategorie (kg CO2 eq) tbv grafiek"]
[]
[null,"Transport","Composteringsproces","Product"]
["Transport",{"$f":"H67","v":0}]
["Composteringsproces",null,{"$f":"H68","v":398.13017365000002}]
["Product",null,null,{"$f":"H69","v":0}]

{"sheet":"Resultaat","index":5,"n_rows":36,"n_cols":17,"rows_kept":36,"cut":false,"hidden":false,"merged":[[6,1,6,6]]}
[]
[null,null,null,"CO2-tool opwerking groene reststromen 1.1"]
[]
[null,"Bedrijf:",null,{"$f":"Naam_bedrijf","v":0}]
[null,"Locatie:",null,{"$f":"Locatie","v":0}]
[null,"Jaar:",null,{"$f":"jaartal","v":0}]
[null,{"$f":"IF(H7=1,\"Werkt volgens best practice\",\"Resultaat niet betrouwbaar. Werkt niet volgens best practice\")","v":"Resultaat niet betrouwbaar. Werkt niet volgens best practice"},null,null,null,null,null,{"$f":"IF(AND(Welkom!J24=TRUE,Welkom!J25=TRUE,Welkom!J26=TRUE,Welkom!J29=TRUE,Welkom!J30=TRUE,Welkom!J31=TRUE),1,0)","v":0}]
[]
[]
[null,"Totale hoeveelheid",null,null,null,null,{"$f":"Hoofdscherm!M12","v":10},"ton/jr"]
[]
[null,"Samenstelling"]
[null,"Hout ",null,null,null,null,{"$f":"Hoofdscherm!M14","v":0}]
[null,"Gras ",null,null,null,null,{"$f":"Hoofdscherm!M15","v":0}]
[null,"Blad",null,null,null,null,{"$f":"Hoofdscherm!M16","v":0}]
[null,"Tuinbouwafval ",null,null,null,null,{"$f":"Hoofdscherm!M17","v":0}]
[null,"Overig ",null,null,null,null,{"$f":"Hoofdscherm!M18","v":1}]
[]
[null,"Opwerken deelstromen"]
[null,"Hout naar bio-energiecentrale",null,null,null,null,{"$f":"(Hoofdscherm!G22+Hoofdscherm!G23)","v":0},"kg/ton"]
[null,"Gras naar co-vergister",null,null,null,null,{"$f":"(Hoofdscherm!F32+Hoofdscherm!F31)","v":0},"kg/ton"]
[null,"Zeefgrond afgevoerd",null,null,null,null,{"$f":"Hoofdscherm!G36","v":0},"kg/ton"]
[null,"Alternatieve opwerking",null,null,null,null,{"$f":"SUM(Hoofdscherm!S26:S29)","v":0},"kg/ton"]
[null,"Warmteterugwinning",null,null,null,null,{"$f":"Hoofdscherm!G39","v":0},"MJ/ton"]
[]
[null,"Compost"]
[null,"Hoeveelheid",null,null,null,null,{"$f":"Hoofdscherm!G50","v":0},"kg/ton"]
[]
[]
[]
[]
[]
[]
[]
[]
[null,null,null,null,null,null,null,{"$f":"CONCATENATE(\"Resultaat: \",ROUND(CO2resultaat,0),\"\")","v":"Resultaat: 398"},"kg CO2-equivalenten",null,null,null,null,null,null,{"$f":"IF(G10=0,0,CONCATENATE(\"(\",ROUND(CO2resultaat_per_ton,0)))","v":"(40"},"kg CO2-equivalenten per ton groenafval)"]