{"text_format":"1","workbook":"xlsx","n_sheets":7,"sheets":["1. Introductie","2. Transport en voorbewerking","3. Bewerking","4. Resultaten","5. Uitgebreide resultaten","Kengetallen","Achtergrond"],"not_rendered":{"charts":7,"images":4,"macros":1,"external_links":0,"defined_names":29,"comments":1,"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":"1. Introductie","index":0,"n_rows":60,"n_cols":3,"rows_kept":60,"cut":false,"hidden":false,"merged":[[59,2,60,6],[62,1,62,6],[47,2,48,6],[53,2,54,6],[56,2,57,6],[0,0,2,7],[33,1,37,6],[44,1,44,6],[39,1,42,6],[49,2,51,6],[5,1,10,6],[13,2,14,6],[15,2,17,6],[18,2,20,6],[21,2,22,6],[23,2,24,6],[46,2,46,6]]}
["CO2-tool groenafval - Introductie"]
[]
[]
[]
[null,"CO2-tool voor groenafvalverwerking "]
[null,"Deze tool kan gebruikt worden om de klimaatimpact te berekenen van de opwerking van groenafval en van de benutting van de producten die daarbij ontstaan. Bedrijven kunnen de tool gebruiken om hun CO2-footprint te berekenen. Deze tool is ook bruikbaar om (bijvoorbeeld bij aanbestedingen) de CO2-performance van verschillende bedrijven te vergelijken. Meer informatie over de gebruikte kengetallen is te vinden in het achtergronddocument bij deze tool. "]
[]
[]
[]
[]
[]
[]
[null,"Gebruiksaanwijzing tool"]
[null,"1. Vul hieronder de bedrijfsgegevens in en geef aan of de inrichting aan de criteria van best practice voldoet door de vakjes aan te vinken. ","Vul hieronder de bedrijfsgegevens in en geef aan of de inrichting aan de criteria van good practice voldoet door de vakjes aan te vinken. "]
[]
[null,"2.","Ga door naar tabblad \"2. Aanvoer en voorbewerking\". Vul hier de gegevens in over de aanvoer van het groenafval en de gegevens over de verwerkingsinrichting. Selecteer de verwerkingsopties die gebruikt worden. "]
[]
[]
[null,"3. ","Ga door naar tabblad \"3. Bewerking\". Vul hier voor de gebruikte verwerkingsroutes de gegevens in of kies ervoor de standaardwaarden in te gebruiken indien de gegevens niet bekend zijn."]
[]
[]
[null,"4. ","Ga door naar tabblad \"4. Resultaten\". Hier vindt u een samenvatting van de ingevoerde gegevens en de klimaatimpact van het verwerken van het groenafval.  "]
[]
[null,"5. ","Op tabblad \"5. Uitgebreide resultaten\" vindt u een grafiek en een tabel waarin de resultaten in meer detail zijn weergegeven. "]
[]
[]
[null,"Bedrijfsgegevens"]
[null,"Naam bedrijf"]
[null,"Locatie"]
[null,"Jaar van berekening*"]
[null,null,"*jaar waarvoor de berekening is uitgevoerd"]
[]
[null,"Bevestiging good practice"]
[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,"Voor bokashi en het rechtstreeks toepassen van groenafval als bodemverbeteraar (‘kleine kringloop’) zijn nog weinig betrouwbare kentallen over broeikasgasemissies betrouwbaar. Wanneer deze technieken worden toegepast bestaat dus onzekerheid over de kwantitatieve resultaten van de tool. "]
[]
[]
[]
[]
[null,"Geef hieronder aan of u aan de criteria hiervoor voldoet."]
[]
[null,null,"er is sprake van een vergunde inrichting;"]
[null,null,"er is een operationele weegbrug aanwezig;"]
[]
[null,null,"er is sprake van een Keurcompost of RHP gecertificeerde inrichting, of de inrichting voldoet aantoonbaar minimaal aan de eisen die Keurcompost stelt aan de bedrijfsvoering, de procesconditie en de compostkwaliteit; "]
[]
[]
[]
[null,null,"(een deel van) het groenafval wordt verwerkt tot bokashi en/of een deel van het groenafval wordt rechtstreeks toegepast als bodemverbeteraar."]
[]
[]
[null,null,{"$f":"IF(Achtergrond!E244,\"Inrichting werkt conform good practice.\", \"Inrichting werkt niet conform good practice. De rekenresultaten van de tool zijn mogelijk niet betrouwbaar. Verificatie van de resultaten is niet mogelijk.\")","v":"Inrichting werkt niet conform good practice. De rekenresultaten van de tool zijn mogelijk niet betrouwbaar. Verificatie van de resultaten is niet mogelijk."}]
[]
[]
[null,null,{"$f":"IF(Achtergrond!E245,\"De resultaten voor bokashi en kleine kringloop zijn conservatief ingeschat en onzeker.\", \"\")","v":""}]

{"sheet":"2. Transport en voorbewerking","index":1,"n_rows":43,"n_cols":9,"rows_kept":43,"cut":false,"hidden":false,"merged":[[27,1,27,6],[45,1,45,6],[0,0,2,10],[48,0,50,10]]}
["CO2-tool groenafval - Transport en voorbewerking"]
[]
[]
[]
[]
[null,"Aangeleverd groenafval"]
[null,"Totale hoeveelheid ",null,"ton/jaar",null,null,null,null,"Bron"]
[]
[null,"Transport naar de verwerkingsinrichting"]
[null,null,{"$f":"Achtergrond!L220","v":"Gewicht (ton)"},"Afstand (km)"]
[null,"Busje met aanhanger",null,null,null,null,null,null,"Bron"]
[null,"Vrachtauto 10-20 ton",null,null,null,null,null,null,"Bron"]
[null,"Vrachtauto >20 ton",null,null,null,null,null,null,"Bron"]
[null,"Gewicht: het totale tonnage dat met het vervoermiddel is aangevoerd"]
[null,"Afstand: gemiddelde afstand tot de inrichting bij gebruik van het vervoermiddel"]
[]
[null,"Energieverbruik verwerkingsinrichting "]
[null,"Elektriciteit (grijs)",null,"kWh/jaar",null,null,null,null,"Bron"]
[null,"Elektriciteit (onbekende bron)",null,"kWh/jaar",null,null,null,null,"Bron"]
[null,"Elektriciteit (groen uit Nederland)",null,"kWh/jaar",null,null,null,null,"Bron"]
[null,"Elektriciteit (groen uit buitenland)",null,"kWh/jaar",null,null,null,null,"Bron"]
[null,"Elektriciteit (eigen opwek PV/wind)",null,"kWh/jaar",null,null,null,null,"Bron"]
[]
[null,"Diesel",null,"liter/jaar",null,null,null,null,"Bron"]
[null,"Aardgas",null,"m3/jaar",null,null,null,null,"Bron"]
[]
[null,"Selectie bewerkingsopties en transportafstanden"]
[null,"> Geef aan welke bewerkingsmethoden voor het groenafval van toepassing zijn.\n> Geef voor de geselecteerde methoden aan hoeveel groenafval er naar de \n   bewerkingsmethode gaat.\n> Geef voor de geselecteerde methoden aan wat de transportafstand van de \n   verwerkingsinrichting naar de afzetlocatie is. "]
[]
[]
[null,null,null,"Hoeveelheid",null,null,"Transportafstand"]
[null,"Hout naar bio-energiecentrale",null,null,{"$f":"IF(Achtergrond!$E$261, \"ton/jaar\",\" \")","v":" "},null,null,{"$f":"IF(Achtergrond!E261, \"km\",\" \")","v":" "},{"$f":"IF(Achtergrond!$E$261, \"Bron\",\" \")","v":" "}]
[null,"Maaisels naar co-vergister",null,null,{"$f":"IF(Achtergrond!E262, \"ton/jaar\",\" \")","v":" "},null,null,{"$f":"IF(Achtergrond!E262, \"km\",\" \")","v":" "},{"$f":"IF(Achtergrond!$E$262, \"Bron\",\" \")","v":" "}]
[null,"Maaisels naar gft-vergister",null,null,{"$f":"IF(Achtergrond!E263, \"ton/jaar\",\" \")","v":" "},null,null,{"$f":"IF(Achtergrond!E263, \"km\",\" \")","v":" "},{"$f":"IF(Achtergrond!$E$263, \"Bron\",\" \")","v":" "}]
[null,"Bokashi",null,null,{"$f":"IF(Achtergrond!E264, \"ton/jaar\",\" \")","v":" "},null,null,{"$f":"IF(Achtergrond!E264, \"km\",\" \")","v":" "},{"$f":"IF(Achtergrond!$E$264, \"Bron\",\" \")","v":" "}]
[null,"Kleine kringloop",null,null,{"$f":"IF(Achtergrond!E265, \"ton/jaar\",\" \")","v":" "},null,null,{"$f":"IF(Achtergrond!E265, \"km\",\" \")","v":" "},{"$f":"IF(Achtergrond!$E$265, \"Bron\",\" \")","v":" "}]
[null,"Compostafzet",null,null,{"$f":"IF(Achtergrond!E266, \"ton/jaar\",\" \")","v":" "},null,null,null,{"$f":"IF(Achtergrond!$E$266, \"Bron\",\" \")","v":" "}]
[null,"Transportafstand compost",null,null,null,null,null,{"$f":"IF(Achtergrond!E266, \"km\",\" \")","v":" "},{"$f":"IF(Achtergrond!$E$266, \"Bron\",\" \")","v":" "}]
[null,"Afgescheiden zeefgrond",null,null,{"$f":"IF(Achtergrond!E267, \"ton/jaar\",\" \")","v":" "},null,null,{"$f":"IF(Achtergrond!E267, \"km\",\" \")","v":" "},{"$f":"IF(Achtergrond!$E$267, \"Bron\",\" \")","v":" "}]
[null,"Surplus water naar RWZI",null,null,{"$f":"IF(Achtergrond!E268, \"m3/jaar\",\" \")","v":" "},null,{"$f":"IF(Achtergrond!E268, \"nvt\",\" \")","v":" "},null,{"$f":"IF(Achtergrond!$E$268, \"Bron\",\" \")","v":" "}]
[null,"Residu naar AEC/stort",null,null,{"$f":"IF(Achtergrond!E269, \"ton/jaar\",\" \")","v":" "},null,null,{"$f":"IF(Achtergrond!E269, \"km\",\" \")","v":" "},{"$f":"IF(Achtergrond!$E$269, \"Bron\",\" \")","v":" "}]
[null,"Residu naar hergebruik",null,null,{"$f":"IF(Achtergrond!E271, \"ton/jaar\",\" \")","v":" "},null,null,{"$f":"IF(Achtergrond!E271, \"km\",\" \")","v":" "},{"$f":"IF(Achtergrond!$E$271, \"Bron\",\" \")","v":" "}]
[null,"Alternatieve opwerking",null,null,{"$f":"IF(Achtergrond!E270, \"ton/jaar\",\" \")","v":" "},null,null,{"$f":"IF(Achtergrond!E270, \"km\",\" \")","v":" "},{"$f":"IF(Achtergrond!$E$270, \"Bron\",\" \")","v":" "}]

{"sheet":"3. Bewerking","index":2,"n_rows":135,"n_cols":6,"rows_kept":135,"cut":false,"hidden":false,"merged":[[85,0,87,7],[77,5,77,6],[78,5,78,6],[79,5,79,6],[76,5,76,6],[83,1,83,5],[76,3,76,4],[79,3,79,4],[78,3,78,4],[77,3,77,4],[0,0,2,7]]}
["CO2-tool groenafval - Bewerking"]
[]
[]
[]
[]
[]
[null,"Hout naar bio-energiecentrale"]
[null,"Hout naar bio-energiecentrale",{"$f":"IF(cb_hout_bio=FALSE,0,cell_hout_bio)","v":0},"ton/jaar",null,"Bron"]
[null,"Vochtpercentage hout",null,"%",null,"Bron"]
[null,"Calorische waarde hout",null,"MJ/kg",null,"Bron"]
[null,"Thermisch rendement centrale*",null,"%",null,"Bron"]
[null,"Elektrisch rendement centrale*",null,"%",null,"Bron"]
[null,"*Standaardwaarde mag worden aangepast indien bekend is in welke bio-energiecentrale de biomassa verwerkt is "]
[]
[null,"Maaisels naar co-vergister"]
[null,"Biogas opbrengst co-vergister",null,"m3 biogas/kg maaisels",null,"Bron"]
[null,"Het gaat om de biogasproductie uit gras, m.a.w. niet het mengsel van substraten dat wordt vergist"]
[null,"Maaisels voor opwekking elektriciteit/warmte ",null,"ton/jaar",null,"Bron"]
[null,"Stookwaarde biogas",null,"MJ/m3",null,"Bron"]
[null,"Elektrisch rendement WKK",null,"%",null,"Bron"]
[null,"Maaisels voor productie groen gas",null,"ton/jaar",null,"Bron"]
[null,"Conversiefactor biogas naar groen gas",null,null,null,"Bron"]
[]
[null,"Maaisels naar GFT-vergisting \nen nacompostering",{"$f":"Achtergrond!P154","v":""}]
[null,"Biogas opbrengst GFT-vergister",null,"m3 biogas/kg maaisels",null,"Bron"]
[null,"Het gaat om de biogasproductie uit gras, m.a.w. niet het mengsel van substraten dat wordt vergist"]
[null,"Maaisels voor opwekking elektriciteit/warmte",null,"ton/jaar",null,"Bron"]
[null,"Stookwaarde biogas",null,"MJ/m3",null,"Bron"]
[null,"Elektrisch rendement WKK",null,"%",null,"Bron"]
[null,"Maaisels voor productie groen gas",null,"ton/jaar",null,"Bron"]
[null,"Conversiefactor biogas naar groen gas",null,null,null,"Bron"]
[]
[null,"Zeefgrond"]
[null,"Hoeveelheid zeefgrond",{"$f":"IF(cb_zeefgrond=FALSE,0,cell_zeefgrond)","v":0},"ton/jaar",null,"Bron"]
[]
[null,"Bokashi"]
[null,"Groenafval naar bokashi",{"$f":"IF(cb_bokashi=FALSE,0,cell_bokashi)","v":0},"ton/jaar",null,"Bron"]
[]
[null,"Kleine kringloop"]
[null,"Groenafval naar kleine kringloop",{"$f":"IF(cb_klein_kring=FALSE,0,cell_klein_kring)","v":0},"ton/jaar",null,"Bron"]
[]
[null,"Surplus water naar RWZI"]
[null,"Lozing op riool",null,"m3/jaar",null,"Bron"]
[null,"Afvoer afvalwater per as",null,"m3/jaar",null,"Bron"]
[null,"Transportafstand afvoer",null,"km",null,"Bron"]
[]
[null,"Residu naar AEC/stort/hergebruik"]
[null,"Naar AEC",null,"ton/jaar",null,"Bron"]
[null,"Naar stort",null,"ton/jaar",null,"Bron"]
[]
[null,"Residu naar hergebruik"]
[null,"Naar hergebruik",{"$f":"IF(cb_hergebruik=FALSE,0,cell_hergebruik)","v":0},"ton/jaar",null,"Bron"]
[]
[null,"Compostafzet"]
[null,"Opbrengst compost",null,"%",null,"Bron"]
[null,"Deze factor is nodig om te bepalen hoeveel ton groenafval het composteerproces is ingegaan (bepaling broeikasgasemissies composteerproces)"]
[null,"Droge stof gehalte*",null,"%",null,"Bron"]
[null,"Stikstof gehalte*",null,"g N/kg ds",null,"Bron"]
[null,"Fosfaat gehalte*",null,"g P2O5/kg ds",null,"Bron"]
[null,"Kalium gehalte*",null,{"$f":"Achtergrond!$M$186","v":"g K2O/kg ds"},null,"Bron"]
[null,"Organische stof gehalte*",null,"g O.S./kg ds",null,"Bron"]
[null,"*Gemiddelde waarde van de analyses gedurende het jaar"]
[]
[null,"Marktverdeling compost "]
[null,"Landbouw",null,null,null,"Bron"]
[null,"akkerbouw, vollegrondstuinbouw en boomteelt"]
[null,"Groenvoorziening",null,null,null,"Bron"]
[null,"anders dan gemeenten (incl. hoveniers en particulieren)"]
[null,"Gemeenten",null,null,null,"Bron"]
[null,"Teeltsubstraten",null,null,null,"Bron"]
[null,"professioneel, consumententoepassingen, samengestelde producten"]
[null,"Anders ",{"$f":"1-SUM('3. Bewerking'!C65,'3. Bewerking'!C67,C69:C70)","v":1},null,null,"Bron"]
[null,"tussenhandel, ophooggrond, GWW-sector"]
[]
[]
[]
[null,"Deelstroom","kg verwerkt groenafval","Opwerkingsproces",null,"Netto kg CO2-eq. \n(per kg verwerkt groenafval)"]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[null,null,{"$f":"Achtergrond!P151","v":""}]
[null,null,{"$f":"Achtergrond!P152","v":""}]
[null,null,{"$f":"Achtergrond!P154","v":""}]
[null,null,{"$f":"Achtergrond!P155","v":""}]
[null,null,{"$f":"Achtergrond!P156","v":""}]
[null,null,{"$f":"Achtergrond!P157","v":""}]
[null,null,{"$f":"Achtergrond!P158","v":""}]
[null,null,{"$f":"Achtergrond!P159","v":""}]
[null,null,{"$f":"Achtergrond!P160","v":""}]
[null,null,{"$f":"Achtergrond!P161","v":""}]
[null,null,{"$f":"Achtergrond!P162","v":""}]
[null,null,{"$f":"Achtergrond!P163","v":""}]
[null,null,{"$f":"Achtergrond!P164","v":""}]
[null,null,{"$f":"Achtergrond!P165","v":""}]
[null,null,{"$f":"Achtergrond!P166","v":""}]
[null,null,{"$f":"Achtergrond!P167","v":""}]
[null,null,{"$f":"Achtergrond!P168","v":""}]
[null,null,{"$f":"Achtergrond!P169","v":""}]
[null,null,{"$f":"Achtergrond!P170","v":""}]
[null,null,{"$f":"Achtergrond!P171","v":""}]
[null,null,{"$f":"Achtergrond!P174","v":""}]
[null,null,{"$f":"Achtergrond!P175","v":""}]
[null,null,{"$f":"Achtergrond!P176","v":""}]
[null,null,{"$f":"Achtergrond!P177","v":""}]
[null,null,{"$f":"Achtergrond!P178","v":""}]
[null,null,{"$f":"Achtergrond!P179","v":""}]
[null,null,{"$f":"Achtergrond!P180","v":""}]
[null,null,{"$f":"Achtergrond!P181","v":""}]
[null,null,{"$f":"Achtergrond!P182","v":""}]
[null,null,{"$f":"Achtergrond!P183","v":""}]
[null,null,{"$f":"Achtergrond!P184","v":""}]
[null,null,{"$f":"Achtergrond!P185","v":""}]
[null,null,{"$f":"Achtergrond!P186","v":""}]
[null,null,{"$f":"Achtergrond!P187","v":""}]
[null,null,{"$f":"Achtergrond!P188","v":""}]
[null,null,{"$f":"Achtergrond!P189","v":"Gewicht (kg)"}]
[null,null,{"$f":"Achtergrond!P190","v":""}]
[null,null,{"$f":"Achtergrond!P191","v":""}]
[null,null,{"$f":"Achtergrond!P192","v":""}]
[null,null,{"$f":"Achtergrond!P193","v":""}]
[null,null,{"$f":"Achtergrond!P195","v":0}]
[null,null,{"$f":"Achtergrond!P196","v":""}]
[null,null,{"$f":"Achtergrond!P197","v":""}]
[null,null,{"$f":"Achtergrond!P198","v":""}]
[null,null,{"$f":"Achtergrond!P199","v":0}]
[null,null,{"$f":"Achtergrond!#REF!","v":{"$error":"#REF!"}}]
[null,null,{"$f":"Achtergrond!P201","v":""}]

{"sheet":"4. Resultaten","index":3,"n_rows":50,"n_cols":9,"rows_kept":50,"cut":false,"hidden":false,"merged":[[0,0,2,8],[54,1,54,8],[49,1,52,8],[8,1,8,8],[10,1,10,8],[45,1,47,8],[14,7,14,8],[14,5,14,6],[12,4,12,5]]}
["CO2-tool groenafval - Resultaten"]
[]
[]
[]
[null,"Bedrijf:",{"$f":"IF('1. Introductie'!D28<>\"\", '1. Introductie'!D28,\"\")","v":""}]
[null,"Locatie:",{"$f":"IF('1. Introductie'!D29<>\"\", '1. Introductie'!D29,\"\")","v":""}]
[null,"Jaar:",{"$f":"IF('1. Introductie'!D30<>\"\", '1. Introductie'!D30,\"\")","v":""}]
[]
[null,{"$f":"IF(Achtergrond!E244,\"Inrichting werkt conform good practice.\", \"Inrichting werkt niet conform good practice. De rekenresultaten van de tool zijn mogelijk niet betrouwbaar. Verificatie van de resultaten is niet mogelijk.\")","v":"Inrichting werkt niet conform good practice. De rekenresultaten van de tool zijn mogelijk niet betrouwbaar. Verificatie van de resultaten is niet mogelijk."}]
[]
[null,{"$f":"IF(Achtergrond!E245,\"De resultaten voor bokashi en kleine kringloop zijn conservatief ingeschat en onzeker.\", \"\")","v":""}]
[]
[null,"Totale hoeveelheid groenafval",null,null,{"$f":"'2. Transport en voorbewerking'!C7","v":0},null,"ton per jaar"]
[]
[null,"Klimaatimpact verwerking",null,null,null,"Hoeveelheid",null,"Klimaatimpact"]
[null,"Compostering",null,null,null,{"$f":"'2. Transport en voorbewerking'!D37","v":0},"ton",{"$f":"SUM(Kengetallen!D106:D107)/1000","v":0},"ton CO2-eq"]
[null,"Hout naar bio-energiecentrale",null,null,null,{"$f":"'2. Transport en voorbewerking'!D32","v":0},"ton",{"$f":"Kengetallen!D100/1000","v":0},"ton CO2-eq"]
[null,"Co-vergisting",null,null,null,{"$f":"'2. Transport en voorbewerking'!D33","v":0},"ton",{"$f":"Kengetallen!D101/1000","v":0},"ton CO2-eq"]
[null,"Gft-vergisting",null,null,null,{"$f":"'2. Transport en voorbewerking'!D34","v":0},"ton",{"$f":"Kengetallen!D102/1000","v":0},"ton CO2-eq"]
[null,"Bokashi",null,null,null,{"$f":"'2. Transport en voorbewerking'!D35","v":0},"ton",{"$f":"Kengetallen!D104/1000","v":0},"ton CO2-eq"]
[null,"Kleine kringloop",null,null,null,{"$f":"'2. Transport en voorbewerking'!D36","v":0},"ton",{"$f":"Kengetallen!D105/1000","v":0},"ton CO2-eq"]
[null,"Overig",null,null,null,{"$f":"SUM('2. Transport en voorbewerking'!D39:D43)","v":0},"ton",{"$f":"SUM(Kengetallen!D103,Kengetallen!D108:D110)/1000","v":0},"ton CO2-eq"]
[]
[null,"Transport (aanvoer)",null,null,null,null,null,{"$f":"Kengetallen!D97/1000","v":0},"ton CO2-eq"]
[null,"Transport (producten)",null,null,null,null,null,{"$f":"Kengetallen!D98/1000","v":0},"ton CO2-eq"]
[null,"Energiegebruik inrichting",null,null,null,null,null,{"$f":"Kengetallen!D99/1000","v":0},"ton CO2-eq"]
[]
[null,"Totaal",null,null,null,null,null,{"$f":"SUM(H16:H26)","v":0},"ton CO2-eq"]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[null,"Bij een postitieve klimaatimpact wordt er meer CO₂ uitgestoten dan dat er uitstoot wordt voorkomen of CO₂ wordt vastgelegd. Bij een negatieve klimaatimpact wordt er juist meer CO₂ vastgelegd en CO₂-uitstoot voorkomen dan er wordt uitgestoten. "]
[]
[]
[]
[null,"Deze berekening gaat uit van CO₂-opslag met tijdelijke waardering: Dit houdt in dat tijdelijk opgeslagen (en daarmee uit de lucht gehouden) CO₂ naar rato wordt gewaardeerd en opgeteld bij de CO₂ die na 100 jaar nog ligt opgeslagen. Deze methode houdt rekening met de mate waarin de verschillende producten ook op korte termijn al kunnen bijdragen aan CO₂-opslag."]

{"sheet":"5. Uitgebreide resultaten","index":4,"n_rows":55,"n_cols":6,"rows_kept":55,"cut":false,"hidden":false,"merged":[[56,0,58,6],[0,0,2,6],[38,1,38,5],[4,1,5,5],[7,1,7,5],[8,1,8,5],[10,1,11,5]]}
["CO2-tool groenafval - Uitgebreide resultaten"]
[]
[]
[]
[null,"Bij de berekening van de klimaatimpact is rekening gehouden met de koolstofopslag in de bodem. De koolstofopslag kan op twee manieren berekend worden:"]
[]
[]
[null,{"$f":"\"- Methode A: CO2-vastlegging met waardering tijdelijke opslag\"","v":"- Methode A: CO2-vastlegging met waardering tijdelijke opslag"}]
[null,{"$f":"\"- Methode B: CO2-vastlegging zonder waardering tijdelijke opslag\"","v":"- Methode B: CO2-vastlegging zonder waardering tijdelijke opslag"}]
[]
[null,"Dit levert verschillende resultaten op, die hieronder worden weergegeven. Voor meer uitleg hierover, zie het achtergronddocument bij deze tool. "]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[null,"Klimaatimpact (in kg CO2-eq) "]
[null,null,"Methode A (totaal)","Methode B (totaal)","Methode A          (per ton groenafval)","Methode B          (per ton groenafval)"]
[null,{"$f":"Kengetallen!B97","v":"Transport (aanvoer)"},{"$f":"Kengetallen!D97","v":0},{"$f":"Kengetallen!C97","v":0},{"$f":"Kengetallen!F97","v":{"$error":"#DIV/0!"}},{"$f":"Kengetallen!E97","v":{"$error":"#DIV/0!"}}]
[null,"Transport (producten)",{"$f":"Kengetallen!D98","v":0},{"$f":"Kengetallen!C98","v":0},{"$f":"Kengetallen!F98","v":{"$error":"#DIV/0!"}},{"$f":"Kengetallen!E98","v":{"$error":"#DIV/0!"}}]
[null,{"$f":"Kengetallen!B99","v":"Energiegebruik inrichting"},{"$f":"Kengetallen!D99","v":0},{"$f":"Kengetallen!C99","v":0},{"$f":"Kengetallen!F99","v":{"$error":"#DIV/0!"}},{"$f":"Kengetallen!E99","v":{"$error":"#DIV/0!"}}]
[null,{"$f":"Kengetallen!B100","v":"Hout naar bio-energiecentrale"},{"$f":"Kengetallen!D100","v":0},{"$f":"Kengetallen!C100","v":0},{"$f":"Kengetallen!F100","v":{"$error":"#DIV/0!"}},{"$f":"Kengetallen!E100","v":{"$error":"#DIV/0!"}}]
[null,{"$f":"Kengetallen!B101","v":"Maaisels naar co-vergister"},{"$f":"Kengetallen!D101","v":0},{"$f":"Kengetallen!C101","v":0},{"$f":"Kengetallen!F101","v":{"$error":"#DIV/0!"}},{"$f":"Kengetallen!E101","v":{"$error":"#DIV/0!"}}]
[null,{"$f":"Kengetallen!B102","v":"Maaisels naar gft-vergister"},{"$f":"Kengetallen!D102","v":0},{"$f":"Kengetallen!C102","v":0},{"$f":"Kengetallen!F102","v":{"$error":"#DIV/0!"}},{"$f":"Kengetallen!E102","v":{"$error":"#DIV/0!"}}]
[null,{"$f":"Kengetallen!B103","v":"Afgescheiden zeefgrond"},{"$f":"Kengetallen!D103","v":0},{"$f":"Kengetallen!C103","v":0},{"$f":"Kengetallen!F103","v":{"$error":"#DIV/0!"}},{"$f":"Kengetallen!E103","v":{"$error":"#DIV/0!"}}]
[null,{"$f":"Kengetallen!B104","v":"Bokashi"},{"$f":"Kengetallen!D104","v":0},{"$f":"Kengetallen!C104","v":0},{"$f":"Kengetallen!F104","v":{"$error":"#DIV/0!"}},{"$f":"Kengetallen!E104","v":{"$error":"#DIV/0!"}}]
[null,{"$f":"Kengetallen!B105","v":"Kleine kringloop"},{"$f":"Kengetallen!D105","v":0},{"$f":"Kengetallen!C105","v":0},{"$f":"Kengetallen!F105","v":{"$error":"#DIV/0!"}},{"$f":"Kengetallen!E105","v":{"$error":"#DIV/0!"}}]
[null,{"$f":"Kengetallen!B106","v":"Compostering "},{"$f":"Kengetallen!D106","v":0},{"$f":"Kengetallen!C106","v":0},{"$f":"Kengetallen!F106","v":{"$error":"#DIV/0!"}},{"$f":"Kengetallen!E106","v":{"$error":"#DIV/0!"}}]
[null,{"$f":"Kengetallen!B107","v":"Toepassing compost"},{"$f":"Kengetallen!D107","v":0},{"$f":"Kengetallen!C107","v":0},{"$f":"Kengetallen!F107","v":{"$error":"#DIV/0!"}},{"$f":"Kengetallen!E107","v":{"$error":"#DIV/0!"}}]
[null,{"$f":"Kengetallen!B108","v":"Surplus water naar RWZI"},{"$f":"Kengetallen!D108","v":0},{"$f":"Kengetallen!C108","v":0},{"$f":"Kengetallen!F108","v":{"$error":"#DIV/0!"}},{"$f":"Kengetallen!E108","v":{"$error":"#DIV/0!"}}]
[null,{"$f":"Kengetallen!B109","v":"Residu naar AEC/stort/hergebruik"},{"$f":"Kengetallen!D109","v":0},{"$f":"Kengetallen!C109","v":0},{"$f":"Kengetallen!F109","v":{"$error":"#DIV/0!"}},{"$f":"Kengetallen!E109","v":{"$error":"#DIV/0!"}}]
[null,{"$f":"Kengetallen!B110","v":"Alternatieve opwerking"},{"$f":"Kengetallen!D110","v":0},{"$f":"Kengetallen!C110","v":0},{"$f":"Kengetallen!F110","v":{"$error":"#DIV/0!"}},{"$f":"Kengetallen!E110","v":{"$error":"#DIV/0!"}}]
[null,{"$f":"Kengetallen!B111","v":"Totaal"},{"$f":"Kengetallen!D111","v":0},{"$f":"Kengetallen!C111","v":0},{"$f":"Kengetallen!F111","v":{"$error":"#DIV/0!"}},{"$f":"Kengetallen!E111","v":{"$error":"#DIV/0!"}}]

{"sheet":"Kengetallen","index":5,"n_rows":124,"n_cols":10,"rows_kept":124,"cut":false,"hidden":true,"merged":[]}
[]
[null,"Totaal aangevoerd","ton",{"$f":"'2. Transport en voorbewerking'!C7","v":0}]
[]
[]
[null,null,"Eenheid","Kengetal (kg CO-eq/eenheid)","Totale hoeveelheid","Totale impact (kg CO2-eq)",null,null,"Geupdate kengetallen"]
[null,"Transport groenafval"]
[null,"Busje met aanhanger","tkm",0.86,{"$f":"Achtergrond!V221*Achtergrond!W221*2","v":0},{"$f":"D7*E7","v":0}]
[null,"Vrachtauto 10-20 ton","tkm",0.26,{"$f":"Achtergrond!V222*Achtergrond!W222*2","v":0},{"$f":"D8*E8","v":0}]
[null,"Vrachtauto >20 ton","tkm",0.2,{"$f":"Achtergrond!V223*Achtergrond!W223*2","v":0},{"$f":"E9*D9","v":0},null,"Koolstofvastlegging"]
[null,null,null,null,null,null,null,"Methode A","Met waardering tijdelijke opslag"]
[null,"Energiegebruik",null,null,null,null,null,"Methode B","Zonder waardering tijdelijke opslag"]
[null,"Elektriciteit (grijs)","kWh",0.55600000000000005,{"$f":"Achtergrond!V228","v":0},{"$f":"D12*E12","v":0}]
[null,"Elektriciteit (onbekende bron)","kWh",0.55600000000000005,{"$f":"Achtergrond!V229","v":0},{"$f":"E13*D13","v":0}]
[null,"Elektriciteit (groen uit Nederland)","kWh",0.38,{"$f":"Achtergrond!V230","v":0},{"$f":"D14*E14","v":0}]
[null,"Elektriciteit (groen uit buitenland)","kWh",0.47499999999999998,{"$f":"Achtergrond!V231","v":0},0]
[null,"Elektriciteit (eigen opwek PV/wind)","kWh",0,{"$f":"Achtergrond!V232","v":0},0]
[null,"Diesel","liter",3.23,{"$f":"Achtergrond!V234","v":0},0]
[null,"Aardgas","m3",1.8839999999999999,{"$f":"Achtergrond!V235","v":0},0]
[]
[null,"Bewerkingsopties"]
[null,"Transport producten","tkm",0.2,{"$f":"cell_hout_bio*'2. Transport en voorbewerking'!G32*2+cell_maai_cogist*cell_maai_cogist_afstand*2+cell_maai_gftgist*'2. Transport en voorbewerking'!G34*2+cell_bokashi*'2. Transport en voorbewerking'!G35*2+cell_klein_kring*'2. Transport en voorbewerking'!G36*2+cell_compostering*'2. Transport en voorbewerking'!G38*2+cell_zeefgrond*'2. Transport en voorbewerking'!G39*2+cell_residu*'2. Transport en voorbewerking'!G41*2+cell_hergebruik*'2. Transport en voorbewerking'!G42*2+cell_alternatief*'2. Transport en voorbewerking'!G43*2","v":0},{"$f":"E21*D21","v":0}]
[null,"Bio-energiecentrale","kg",{"$f":"0.0089-(Achtergrond!V138*Achtergrond!V139*0.0256)-(Achtergrond!V138*Achtergrond!V140*0.154)","v":8.8999999999999999E-3},{"$f":"(Achtergrond!V136)*1000","v":0},{"$f":"E22*D22","v":0}]
[null,"Co-vergisting"]
[null,"Opwekken elektriciteit","kg",{"$f":"-Achtergrond!V143*Achtergrond!V146*Achtergrond!V147/100/3.6*0.556","v":0},{"$f":"Achtergrond!V145*1000","v":0},{"$f":"E24*D24","v":0}]
[null,"Opwekken groengas","kg",{"$f":"-Achtergrond!V143*Achtergrond!V149*1.884","v":0},{"$f":"Achtergrond!V148*1000","v":0},{"$f":"E25*D25","v":0}]
[null,"Emissie CH4 co-vergisting","g",3.4000000000000002E-2,{"$f":"460*((Achtergrond!V145+Achtergrond!V148)*1000)/1000","v":0},{"$f":"D26*E26","v":0}]
[null,"Emissie N2O co-vergisting","g",0.29799999999999999,{"$f":"10*((Achtergrond!V145+Achtergrond!V148)*1000)/1000","v":0},{"$f":"E27*D27","v":0}]
[null,"Koolstofvastlegging digestaat B","kg",-1,{"$f":"2.7*((Achtergrond!V145+Achtergrond!V148)*1000)/1000","v":0},{"$f":"D28*E28","v":0}]
[null,"Koolstofvastlegging digestaat A","kg",-1,{"$f":"8.8*((Achtergrond!V145+Achtergrond!V148)*1000)/1000","v":0},{"$f":"E29*D29","v":0}]
[null,"GFT-vergisting","kg"]
[null,"Opwekken elektriciteit","kg",{"$f":"-Achtergrond!V152*Achtergrond!V155*Achtergrond!V156/100/3.6*0.556","v":0},{"$f":"Achtergrond!V154*1000","v":0},{"$f":"E31*D31","v":0}]
[null,"Opwekken groengas","kg",{"$f":"-Achtergrond!V152*Achtergrond!V158*1.884","v":0},{"$f":"Achtergrond!V157*1000","v":0},{"$f":"E32*D32","v":0}]
[null,"Emissie CH4 gft-vergisting","g",3.4000000000000002E-2,{"$f":"500*((Achtergrond!V154+Achtergrond!V157)*1000)/1000","v":0},{"$f":"D33*E33","v":0}]
[null,"Emissie N2O gft-vergisting","g",0.29799999999999999,{"$f":"20*((Achtergrond!V154+Achtergrond!V157)*1000)/1000","v":0},0]
[null,"Koolstofvastlegging digestaat B","kg",-1,{"$f":"25.1*((Achtergrond!V154+Achtergrond!V157)*1000)/1000","v":0},{"$f":"E35*D35","v":0}]
[null,"Koolstofvastlegging digestaat A","kg",-1,{"$f":"81.2*((Achtergrond!V154+Achtergrond!V157)*1000)/1000","v":0},{"$f":"E36*D36","v":0}]
[null,"Zeefgrond","kg",{"$f":"-11.4/1000","v":-1.14E-2},{"$f":"Achtergrond!V161*1000","v":0},{"$f":"E37*D37","v":0}]
[null,"Bokashi"]
[null,"Hulpstoffen","kg",{"$f":"4.4/1000","v":4.4000000000000003E-3},{"$f":"Achtergrond!V164*1000","v":0},{"$f":"E39*D39","v":0}]
[null,"Emissie CH4","g",3.4000000000000002E-2,{"$f":"12000*Achtergrond!V164*1000/1000","v":0},{"$f":"E40*D40","v":0}]
[null,"Emissie N2O","g",0.29799999999999999,{"$f":"(13+60)*Achtergrond!V164*1000/1000","v":0},{"$f":"E41*D41","v":0}]
[null,"Koolstofvastlegging B","kg",-1,{"$f":"10.4*Achtergrond!V164*1000/1000","v":0},{"$f":"E42*D42","v":0}]
[null,"Koolstofvastlegging A","kg",-1,{"$f":"33.5*Achtergrond!V164*1000/1000","v":0},{"$f":"E43*D43","v":0}]
[null,"Kleine kringloop","kg"]
[null,"Emissie CH4","g",3.4000000000000002E-2,{"$f":"12000*Achtergrond!V167*1000/1000","v":0},{"$f":"E45*D45","v":0}]
[null,"Emissie N2O","g",0.29799999999999999,{"$f":"60*Achtergrond!V167*1000/1000","v":0},{"$f":"E46*D46","v":0}]
[null,"Koolstofvastlegging B","kg",-1,{"$f":"10.4*Achtergrond!V167*1000/1000","v":0},{"$f":"E47*D47","v":0}]
[null,"Koolstofvastlegging A","kg",-1,{"$f":"33.5*Achtergrond!V167*1000/1000","v":0},{"$f":"E48*D48","v":0}]
[null,"Alternatieve opwerking","kg CO2-eq",1,{"$f":"'3. Bewerking'!F78*'3. Bewerking'!C78+'3. Bewerking'!F79*'3. Bewerking'!C79+'3. Bewerking'!F80*'3. Bewerking'!C80","v":0},{"$f":"D49*E49","v":0}]
[null,"Water naar RWZI"]
[null,"Water naar RWZI (lozing op riool)","m3",0.105,{"$f":"Achtergrond!V170","v":0},{"$f":"E51*D51","v":0}]
[null,"Water naar RWZI (afvoer per as)","m3",0.105,{"$f":"Achtergrond!V171","v":0},{"$f":"E52*D52","v":0}]
[null,"Transport water naar RWZI","tkm",{"$f":"D9","v":0.2},{"$f":"Achtergrond!V172*Achtergrond!V171*2","v":0},0]
[null,"Residu naar AVI","kg",-0.25,{"$f":"Achtergrond!V175*1000","v":0},{"$f":"E54*D54","v":0}]
[null,"Residu naar stort","kg",0.09,{"$f":"Achtergrond!V176*1000","v":0},{"$f":"E55*D55","v":0}]
[null,"Residu naar hergebruik","kg",0,{"$f":"Achtergrond!V177*1000","v":0},{"$f":"E56*D56","v":0}]
[]
[null,"Compostering"]
[null,"Emissie CH4 compostering","g",{"$f":"34/1000","v":3.4000000000000002E-2},{"$f":"1400*Achtergrond!V179","v":0},{"$f":"E59*D59","v":0}]
[null,"Emissie N2O compostering","g",{"$f":"298/1000","v":0.29799999999999999},{"$f":"49*Achtergrond!V179","v":0},{"$f":"E60*D60","v":0}]
[]
[null,"Veenvervanging","kg",{"$f":"-0.858","v":-0.85799999999999998},{"$f":"IFERROR(C75*1000/C77*D92*C84*400,0)","v":0},{"$f":"E62*D62","v":0}]
[null,"Substitutie N-fertilizer","kg",-6.67,{"$f":"E92*(C78/1000)*(C76/100)*C75*1000*H92","v":0},{"$f":"E63*D63","v":0}]
[null,"Substitutie P-fertilizer","kg",-1.52,{"$f":"E92*(C80/1000)*(C76/100)*C75*1000*I92","v":0},{"$f":"E64*D64","v":0}]
[null,"Substitutie K-fertilizer","kg",-0.56000000000000005,{"$f":"E92*(C81/1000)*(C76/100)*C75*1000*J92","v":0},0]
[null,"Vermeden emissie N2O door vermeden toepassing kunstmest","g",{"$f":"-D60","v":-0.29799999999999999},{"$f":"C78*C76/100*C75*1000*0.0125*(44/14)*H92*E92","v":0},0]
[null,"Emissie N2O door toepassing compost","g",{"$f":"D60","v":0.29799999999999999},{"$f":"C78*C76/100*C75*1000*0.0125*(44/14)*0","v":0},0]
[null,"Koolstofvastlegging in grond B","kg",-1,{"$f":"46.4*C75","v":0},{"$f":"E68*D68","v":0}]
[null,"Koolstofvastlegging in grond A","kg",-1,{"$f":"150.1*C75","v":0},{"$f":"E69*D69","v":0}]
[]
[]
[]
[null,"Compost eigenschappen en toepassing "]
[]
[null,"Opbrengst",{"$f":"cell_compostering","v":0},"ton compost"]
[null,"ds gehalte",{"$f":"Achtergrond!V182","v":0},"%"]
[null,"Dichtheid",600,"kg/m3"]
[null,"N-gehalte",{"$f":"Achtergrond!V184","v":0},"g/kg ds"]
[null,"C-gehalte",{"$f":"0.5*C82/1000","v":0},"kg/kg ds"]
[null,"P-gehalte",{"$f":"Achtergrond!V185","v":0},"g/kg ds"]
[null,"K-gehalte",{"$f":"Achtergrond!V186","v":0},"g/kg ds"]
[null,"Organische stof gehalte",{"$f":"Achtergrond!V187","v":0},"g/kg ds"]
[]
[null,"vervangingswaarde compost",1,"m3 veen/m3 compost"]
[]
[null,"Marktverdeling","% ds","% bijdrage aan veenvervanging","% bijdrage aan kunstmestvervanging","% bijdrage aan koolstofvastlegging",null,"% N beschikbaar voor vervanging","% P beschikbaar voor vervanging","% K beschikbaar voor vervanging"]
[null,"Landbouw",{"$f":"Achtergrond!V193","v":0},0,0.5,null,null,0.37,1,1]
[null,"Hoveniers, particulieren",{"$f":"Achtergrond!V196","v":0},1,1,null,null,0.37,1,1]
[null,"Gemeenten",{"$f":"Achtergrond!V197","v":0},0.5,0,null,null,0.37,1,1]
[null,"Teeltsubstraten",{"$f":"Achtergrond!V198","v":0},1,1,null,null,0.37,1,1]
[null,"Anders (w.o. tussenhandel)",{"$f":"Achtergrond!V201","v":1},0,0,null,null,0.37,1,1]
[null,"Totaal",null,{"$f":"(D87*C87)+(D88*C88)+(D89*C89)+(D90*C90)+(D91*C91)","v":0},{"$f":"(E87*C87)+(E88*C88)+(E89*C89)+(E90*C90)+(E91*C91)","v":0},{"$f":"(F87*C87)+(F88*C88)+(F89*C89)+(F90*C90)+(F91*C91)","v":0},null,{"$f":"(H87*C87)+(H88*C88)+(H89*C89)+(H90*C90)+(H91*C91)","v":0.37},{"$f":"(I87*C87)+(I88*C88)+(I89*C89)+(I90*C90)+(I91*C91)","v":1},{"$f":"(J87*C87)+(J88*C88)+(J89*C89)+(J90*C90)+(J91*C91)","v":1}]
[]
[]
[null,"Resultaten (uitgebreid) "]
[null,null,"kg CO2-eq/totaal B","kg CO2-eq/totaal A","kg CO2-eq/ton groenafval B","kg CO2-eq/ton groenafval A"]
[null,"Transport (aanvoer)",{"$f":"SUM(F7:F8)","v":0},{"$f":"SUM(F7:F8)","v":0},{"$f":"C97/D$2","v":{"$error":"#DIV/0!"}},{"$f":"D97/D$2","v":{"$error":"#DIV/0!"}}]
[null,"Transport (producten)",{"$f":"F21","v":0},{"$f":"F21","v":0},{"$f":"C98/D$2","v":{"$error":"#DIV/0!"}},{"$f":"D98/D$2","v":{"$error":"#DIV/0!"}}]
[null,"Energiegebruik inrichting",{"$f":"SUM(F12:F18)","v":0},{"$f":"SUM(F12:F18)","v":0},{"$f":"C99/D$2","v":{"$error":"#DIV/0!"}},{"$f":"D99/D$2","v":{"$error":"#DIV/0!"}}]
[null,"Hout naar bio-energiecentrale",{"$f":"F22","v":0},{"$f":"F22","v":0},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"}]
[null,"Maaisels naar co-vergister",{"$f":"SUM(F24:F28)","v":0},{"$f":"SUM(F24:F27,F29)","v":0},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"}]
[null,"Maaisels naar gft-vergister",{"$f":"SUM(F31:F35)","v":0},{"$f":"SUM(F31:F34,F36)","v":0},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"}]
[null,"Afgescheiden zeefgrond",{"$f":"F37","v":0},{"$f":"F37","v":0},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"}]
[null,"Bokashi",{"$f":"SUM(F39:F42)","v":0},{"$f":"SUM(F39:F41,F43)","v":0},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"}]
[null,"Kleine kringloop",{"$f":"SUM(F45:F47)","v":0},{"$f":"SUM(F45:F46,F48)","v":0},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"}]
[null,"Compostering ",{"$f":"SUM(F59:F60)","v":0},{"$f":"SUM(F59:F60)","v":0},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"}]
[null,"Toepassing compost",{"$f":"SUM(F62:F68)","v":0},{"$f":"SUM(F62:F67,F69)","v":0},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"}]
[null,"Surplus water naar RWZI",{"$f":"SUM(F51:F53)","v":0},{"$f":"SUM(F51:F53)","v":0},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"}]
[null,"Residu naar AEC/stort/hergebruik",{"$f":"SUM(F54:F56)","v":0},{"$f":"SUM(F54:F56)","v":0},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"}]
[null,"Alternatieve opwerking",{"$f":"F49","v":0},{"$f":"F49","v":0},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"}]
[null,"Totaal",{"$f":"SUM(C97:C110)","v":0},{"$f":"SUM(D97:D110)","v":0},{"$f":"SUM(E97:E110)","v":{"$error":"#DIV/0!"}},{"$f":"D111/D$2","v":{"$error":"#DIV/0!"}}]
[]
[null,"Resultaten (ingekort)","Methode B","Methode A","Methode B","Methode A"]
[null,"Transport (aanvoer)",{"$f":"C97/1000","v":0},0,{"$f":"C114/D$2*1000","v":{"$error":"#DIV/0!"}},{"$f":"D114/D$2*1000","v":{"$error":"#DIV/0!"}}]
[null,"Transport (producten)",0,0,{"$f":"C115/D$2*1000","v":{"$error":"#DIV/0!"}},{"$f":"D115/D$2*1000","v":{"$error":"#DIV/0!"}}]
[null,"Energiegebruik inrichting",0,0,{"$f":"C116/D$2*1000","v":{"$error":"#DIV/0!"}},{"$f":"D116/D$2*1000","v":{"$error":"#DIV/0!"}}]
[null,"Overig",{"$f":"SUM(C108:C110,C103)/1000","v":0},{"$f":"SUM(D108:D110,D103)/1000","v":0},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"}]
[null,"Kleine kringloop",{"$f":"C105/1000","v":0},{"$f":"D105/1000","v":0},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"}]
[null,"Bokashi",{"$f":"C104/1000","v":0},{"$f":"D104/1000","v":0},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"}]
[null,"Gft-vergisting",{"$f":"C102/1000","v":0},{"$f":"D102/1000","v":0}]
[null,"Co-vergisting",{"$f":"C101/1000","v":0},{"$f":"D101/1000","v":0}]
[null,"Bio-energiecentrale",{"$f":"C100/1000","v":0},{"$f":"D100/1000","v":0}]
[null,"Compostering",{"$f":"SUM(C106:C107)/1000","v":0},{"$f":"SUM(D106:D107)/1000","v":0}]
[null,"Totaal",{"$f":"SUM(C114:C123)","v":0},{"$f":"SUM(D114:D123)","v":0},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"}]

{"sheet":"Achtergrond","index":6,"n_rows":271,"n_cols":23,"rows_kept":271,"cut":false,"hidden":true,"merged":[[244,10,245,14],[247,10,247,14],[248,10,248,14],[250,10,251,14],[21,1,22,5]]}
[]
[null,"Standaardwaarden Transport en voorbewerking"]
[]
[null,"Transport",{"$f":"Achtergrond!L189","v":"Gewicht (kg)"},"Afstand (km)"]
[null,"Busje met aanhanger",null,10]
[null,"Vrachtauto 10-20 ton",null,25]
[null,"Vrachtauto >20 ton",null,50]
[null,"Gewicht: het totale tonnage dat met het vervoermiddel is aangevoerd"]
[null,"Afstand: gemiddelde afstand tot de inrichting bij gebruik van het vervoermiddel"]
[]
[null,"Energieverbruik verwerkingsinrichting ",{"$f":"Achtergrond!P198","v":""}]
[null,"Elektriciteit (grijs)",{"$f":"5*'2. Transport en voorbewerking'!C7","v":0},"kWh/jaar"]
[null,"Elektriciteit (onbekend)",0,"kWh/jaar"]
[null,"Elektriciteit (groen uit Nederland)",0,"kWh/jaar"]
[null,"Elektriciteit (groen uit buitenland)",0,"kWh/jaar"]
[null,"Elektriciteit (eigen opwek PV/wind)",0,"kWh/jaar"]
[]
[null,"Diesel",{"$f":"3*'2. Transport en voorbewerking'!C7","v":0},"liter/jaar"]
[null,"Aardgas",0,"m3/jaar"]
[]
[null,"Selectie bewerkingsopties en transportafstanden"]
[null,"Geef aan welke bewerkingsmethoden voor het groenafval van toepassing zijn. Geef voor de geselecteerde methoden aan hoeveel groenafval er naar de bewerkingsmethode gaat."]
[]
[]
[null,null,null,"Hoeveelheid",null,"Transportafstand"]
[null,"Hout naar bio-energiecentrale",null,null,{"$f":"IF(Achtergrond!$E$261, \"ton/jaar\",\" \")","v":" "},150,"km"]
[null,"Maaisels naar co-vergister",null,null,{"$f":"IF(Achtergrond!$E$261, \"ton/jaar\",\" \")","v":" "},100,"km"]
[null,"Maaisels naar gft-vergister",null,null,{"$f":"IF(Achtergrond!$E$261, \"ton/jaar\",\" \")","v":" "},100,"km"]
[null,"Bokashi",null,null,{"$f":"IF(Achtergrond!$E$261, \"ton/jaar\",\" \")","v":" "},25,"km"]
[null,"Kleine kringloop",null,null,{"$f":"IF(Achtergrond!$E$261, \"ton/jaar\",\" \")","v":" "},25,"km"]
[null,"Compostering",null,null,{"$f":"IF(Achtergrond!$E$261, \"ton/jaar\",\" \")","v":" "},40,"km"]
[null,"Afgescheiden zeefgrond",null,null,{"$f":"IF(Achtergrond!$E$261, \"ton/jaar\",\" \")","v":" "},25,"km"]
[null,"Surplus water naar RWZI",null,null,{"$f":"IF(Achtergrond!$E$261, \"ton/jaar\",\" \")","v":" "},null,"km"]
[null,"Residu naar AEC/stort",null,null,{"$f":"IF(Achtergrond!$E$261, \"ton/jaar\",\" \")","v":" "},50,"km"]
[null,"Residu naar hergebruik",null,null,{"$f":"IF(Achtergrond!$E$261, \"ton/jaar\",\" \")","v":" "},100,"km"]
[null,"Alternatieve opwerking",null,null,{"$f":"IF(Achtergrond!$E$261, \"ton/jaar\",\" \")","v":" "},150,"km"]
[]
[null,"Standaardwaarden Bewerking"]
[]
[null,"Hout naar bio-energiecentrale"]
[null,"Hout naar bio-energiecentrale",null,"ton/jaar"]
[null,"Vochtpercentage hout",45,"%"]
[null,"Calorische waarde hout",9,"MJ/kg"]
[null,"Thermisch rendement centrale*",0,"%",null,{"$f":"IF(cb_hout_bio=TRUE,C44,\"\")","v":""}]
[null,"Elektrisch rendement centrale*",31,"%"]
[null,"*Standaardwaarde mag worden aangepast indien bekend is in welke bio-energiecentrale de biomassa verwerkt is "]
[]
[null,"Maaisels naar co-vergister"]
[null,"Biogas opbrengst co-vergister",7.6999999999999999E-2,"m3 biogas/kg maaisels"]
[null,"Het gaat om de biogasproductie uit gras, m.a.w. niet het mengsel van substraten dat wordt vergist"]
[null,"Maaisels voor opwekking elektriciteit/warmte ",{"$f":"\"\"","v":""},"ton/jaar",null,null,null,"Oud: ","0,5*'2. Transport en voorbewerking'!D33"]
[null,"Stookwaarde biogas",21.5,"MJ/m3"]
[null,"Elektrisch rendement WKK",38,"%"]
[null,"Maaisels voor productie groen gas",{"$f":"\"\"","v":""},"ton/jaar",null,null,null,"Oud: ","0,5*'2. Transport en voorbewerking'!D33"]
[null,"Conversiefactor biogas naar groen gas",0.6]
[]
[null,"Maaisels naar GFT-vergisting en nacompostering"]
[null,"Biogas opbrengst GFT-vergister",4.2999999999999997E-2,"m3 biogas/kg maaisels"]
[null,"Het gaat om de biogasproductie uit gras, m.a.w. niet het mengsel van substraten dat wordt vergist"]
[null,"Maaisels voor opwekking elektriciteit/warmte",{"$f":"\"\"","v":""},"ton/jaar",null,null,null,"Oud: ","0,5*'2. Transport en voorbewerking'!D34"]
[null,"Stookwaarde biogas",21.5,"MJ/m3"]
[null,"Elektrisch rendement WKK",38,"%"]
[null,"Maaisels voor productie groen gas",{"$f":"\"\"","v":""},"ton/jaar",null,null,null,"Oud: ","0,5*'2. Transport en voorbewerking'!D34"]
[null,"Conversiefactor biogas naar groen gas",0.6]
[]
[null,"Zeefgrond"]
[null,"Hoeveelheid zeefgrond",null,"ton/jaar"]
[]
[null,"Bokashi"]
[null,"Groenafval naar bokashi",null,"ton/jaar"]
[]
[null,"Kleine kringloop"]
[null,"Groenafval naar kleine kringloop",null,"ton/jaar"]
[]
[null,"Surplus water naar RWZI"]
[null,"Lozing op riool",null,"m3/jaar"]
[null,"Afvoer afvalwater per as",null,"m3/jaar"]
[null,"Transportafstand afvoer",50,"km"]
[]
[null,"Residu naar AEC/stort"]
[null,"Naar AEC",{"$f":"cell_residu","v":0},"ton/jaar"]
[null,"Naar stort",0,"ton/jaar"]
[]
[null,"Compostering"]
[null,"Groenafval naar compostering",null,"ton"]
[null,"Opbrengst compostering",{"$f":"50","v":50},"%"]
[null,null,{"$f":"\"\"","v":""}]
[null,"Droge stof gehalte*",60,"%"]
[null,"Dichtheid ",600,"kg/m3"]
[null,"Stikstof gehalte*",5,"g N/kg ds"]
[null,"Fosfaat gehalte*",3,"g P2O5/kg ds"]
[null,"Kalium gehalte*",5,"g K2O/kg ds"]
[null,"Organische stof gehalte*",100,"g O.S./kg ds"]
[null,"*Gemiddelde waarde van de analyses gedurende het jaar",{"$f":"\"\"","v":""}]
[]
[null,"Transport van compost","Gewicht (kg)","Afstand (km) "]
[null,"Vrachtwagen",{"$f":"C86","v":50},100]
[null,null,{"$f":"\"\"","v":""}]
[null,"Marktverdeling compost "]
[null,"Landbouw",0,"%"]
[null,"akkerbouw, vollegrondstuinbouw en boomteelt"]
[null,"Hoveniers, particulieren",{"$f":"Achtergrond!P214","v":0},"%"]
[null,"Gemeenten",{"$f":"Achtergrond!P215","v":0},"%"]
[null,"Teeltsubstraten",{"$f":"Achtergrond!P216","v":0},"%"]
[null,"professioneel, consumententoepassingen, samengestelde producten"]
[null,"Anders ",{"$f":"1-SUM('3. Bewerking'!C65,'3. Bewerking'!C67:C71)","v":1},"%"]
[null,"tussenhandel, ophooggrond, GWW-sector"]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[null,null,null,null,null,null,null,null,null,null,"Standaardwaarden invullen",null,null,null,null,"Standaardwaarden verwijderen",null,null,null,null,null,"Alle lege velden omzetten naar 0"]
[]
[null,null,null,null,null,null,null,null,null,null,"Hout naar bio-energiecentrale",{"$f":"IF(Achtergrond!E261,'2. Transport en voorbewerking'!D32,\"\")","v":""},"ton",null,null,{"$f":"IF(Achtergrond!E261,'2. Transport en voorbewerking'!D32,\"\")","v":""},"ton",null,null,null,null,{"$f":"IF('3. Bewerking'!C8=\"\",0,'3. Bewerking'!C8)","v":0},"ton"]
[null,null,null,null,null,null,null,null,null,null,"Vochtpercentage hout",{"$f":"IF(Achtergrond!E261,45,\"\")","v":""},"%",null,null,{"$f":"\"\"","v":""},"%",null,null,null,null,{"$f":"IF('3. Bewerking'!C9=\"\",0,'3. Bewerking'!C9)","v":0},"%"]
[null,null,null,null,null,null,null,null,null,null,"Calorische waarde hout",{"$f":"IF(Achtergrond!E261,9,\"\")","v":""},"MJ/kg",null,null,{"$f":"IF(Achtergrond!E261,(IF('3. Bewerking'!C9=\"\",\"\",18.29-(0.207*'3. Bewerking'!C9/100))),\"\")","v":""},"MJ/kg",null,null,null,null,{"$f":"IF('3. Bewerking'!C10=\"\",0,'3. Bewerking'!C10)","v":0},"MJ/kg"]
[null,null,null,null,null,null,null,null,null,null,"Thermisch rendement centrale",{"$f":"IF(Achtergrond!E261,0,\"\")","v":""},"%",null,null,{"$f":"\"\"","v":""},"%",null,null,null,null,{"$f":"IF('3. Bewerking'!C11=\"\",0,'3. Bewerking'!C11/100)","v":0},"%"]
[null,null,null,null,null,null,null,null,null,null,"Elektrisch rendement centrale",{"$f":"IF(Achtergrond!E261,0.31,\"\")","v":""},"%",null,null,{"$f":"\"\"","v":""},"%",null,null,null,null,{"$f":"IF('3. Bewerking'!C12=\"\",0,'3. Bewerking'!C12/100)","v":0},"%"]
[null,null,null,null,null,null,null,null,null,null,null,{"$f":"\"\"","v":""},null,null,null,"",null,null,null,null,null,""]
[null,null,null,null,null,null,null,null,null,null,"Maaisels naar co-vergister",{"$f":"\"\"","v":""},null,null,null,"",null,null,null,null,null,""]
[null,null,null,null,null,null,null,null,null,null,"Biogas opbrengst co-vergister",{"$f":"IF(Achtergrond!E262,0.077,\"\")","v":""},"m3 biogas/kg maaisels",null,null,{"$f":"\"\"","v":""},"m3 biogas/kg maaisels",null,null,null,null,{"$f":"IF('3. Bewerking'!C16=\"\",0,'3. Bewerking'!C16)","v":0},"m3 biogas/kg maaisels"]
[]
[null,null,null,null,null,null,null,null,null,null,"Maaisels voor opwekking elektriciteit",{"$f":"IF(Achtergrond!E262,0.5*'2. Transport en voorbewerking'!D33,\"\")","v":""},"ton",null,null,{"$f":"\"\"","v":""},"ton",null,null,null,null,{"$f":"IF('3. Bewerking'!C18=\"\",0,'3. Bewerking'!C18)","v":0},"ton"]
[null,null,null,null,null,null,null,null,null,null,"Stookwaarde biogas",{"$f":"IF(Achtergrond!E262,21.5,\"\")","v":""},"MJ/m3",null,null,{"$f":"\"\"","v":""},null,null,null,null,null,{"$f":"IF('3. Bewerking'!C19=\"\",0,'3. Bewerking'!C19)","v":0}]
[null,null,null,null,null,null,null,null,null,null,"Elektrisch rendement WKK",{"$f":"IF(Achtergrond!E262,38,\"\")","v":""},"%",null,null,{"$f":"\"\"","v":""},null,null,null,null,null,{"$f":"IF('3. Bewerking'!C20=\"\",0,'3. Bewerking'!C20)","v":0},"%"]
[null,null,null,null,null,null,null,null,null,null,"Maaisels voor productie groen gas",{"$f":"IF(Achtergrond!E262,0.5*'2. Transport en voorbewerking'!D33,\"\")","v":""},"ton",null,null,{"$f":"\"\"","v":""},"ton",null,null,null,null,{"$f":"IF('3. Bewerking'!C21=\"\",0,'3. Bewerking'!C21)","v":0},"ton"]
[null,null,null,null,null,null,null,null,null,null,"Conversiefactor biogas naar groen gas",{"$f":"IF(Achtergrond!E262,0.6,\"\")","v":""},null,null,null,{"$f":"\"\"","v":""},null,null,null,null,null,{"$f":"IF('3. Bewerking'!C22=\"\",0,'3. Bewerking'!C22)","v":0}]
[null,null,null,null,null,null,null,null,null,null,null,{"$f":"\"\"","v":""},null,null,null,"",null,null,null,null,null,""]
[null,null,null,null,null,null,null,null,null,null,"Maaisels naar GFT-vergisting en nacompostering",{"$f":"\"\"","v":""},null,null,null,"",null,null,null,null,null,""]
[null,null,null,null,null,null,null,null,null,null,"Biogas opbrengst GFT-vergister",{"$f":"IF(Achtergrond!E263,0.043,\"\")","v":""},"m3 biogas/kg maaisels",null,null,{"$f":"\"\"","v":""},"m3 biogas/kg maaisels",null,null,null,null,{"$f":"IF('3. Bewerking'!C25=\"\",0,'3. Bewerking'!C25)","v":0},"m3 biogas/kg maaisels"]
[]
[null,null,null,null,null,null,null,null,null,null,"Maaisels voor opwekking elektriciteit",{"$f":"IF(Achtergrond!E263,0.5*'2. Transport en voorbewerking'!D34,\"\")","v":""},"ton",null,null,{"$f":"\"\"","v":""},"ton",null,null,null,null,{"$f":"IF('3. Bewerking'!C27=\"\",0,'3. Bewerking'!C27)","v":0},"ton"]
[null,null,null,null,null,null,null,null,null,null,"Stookwaarde biogas",{"$f":"IF(Achtergrond!E263,21.5,\"\")","v":""},"MJ/m3",null,null,{"$f":"\"\"","v":""},null,null,null,null,null,{"$f":"IF('3. Bewerking'!C28=\"\",0,'3. Bewerking'!C28)","v":0}]
[null,null,null,null,null,null,null,null,null,null,"Elektrisch rendement WKK",{"$f":"IF(Achtergrond!E263,38,\"\")","v":""},"%",null,null,{"$f":"\"\"","v":""},null,null,null,null,null,{"$f":"IF('3. Bewerking'!C29=\"\",0,'3. Bewerking'!C29)","v":0},"%"]
[null,null,null,null,null,null,null,null,null,null,"Maaisels voor productie groen gas",{"$f":"IF(Achtergrond!E263,0.5*'2. Transport en voorbewerking'!D34,\"\")","v":""},"ton",null,null,{"$f":"\"\"","v":""},"ton",null,null,null,null,{"$f":"IF('3. Bewerking'!C30=\"\",0,'3. Bewerking'!C30)","v":0},"ton"]
[null,null,null,null,null,null,null,null,null,null,"Conversiefactor biogas naar groen gas",{"$f":"IF(Achtergrond!E263,0.6,\"\")","v":""},null,null,null,{"$f":"\"\"","v":""},null,null,null,null,null,{"$f":"IF('3. Bewerking'!C31=\"\",0,'3. Bewerking'!C31)","v":0}]
[null,null,null,null,null,null,null,null,null,null,null,{"$f":"\"\"","v":""},null,null,null,"",null,null,null,null,null,""]
[null,null,null,null,null,null,null,null,null,null,"Zeefgrond",{"$f":"\"\"","v":""},null,null,null,"",null,null,null,null,null,""]
[null,null,null,null,null,null,null,null,null,null,"Hoeveelheid zeefgrond",{"$f":"IF(Achtergrond!E267,'2. Transport en voorbewerking'!D39,\"\")","v":""},"ton",null,null,{"$f":"IF(Achtergrond!E267,'2. Transport en voorbewerking'!D39,\"\")","v":""},"ton",null,null,null,null,{"$f":"IF('3. Bewerking'!C34=\"\",0,'3. Bewerking'!C34)","v":0},"ton"]
[null,null,null,null,null,null,null,null,null,null,null,{"$f":"\"\"","v":""},null,null,null,"",null,null,null,null,null,""]
[null,null,null,null,null,null,null,null,null,null,"Bokashi",{"$f":"\"\"","v":""},null,null,null,"",null,null,null,null,null,""]
[null,null,null,null,null,null,null,null,null,null,"Groenafval naar bokashi",{"$f":"IF(Achtergrond!E264,'2. Transport en voorbewerking'!D35,\"\")","v":""},"ton",null,null,{"$f":"IF(Achtergrond!E264,'2. Transport en voorbewerking'!D35,\"\")","v":""},"ton",null,null,null,null,{"$f":"IF('3. Bewerking'!C37=\"\",0,'3. Bewerking'!C37)","v":0},"ton"]
[null,null,null,null,null,null,null,null,null,null,null,{"$f":"\"\"","v":""},null,null,null,"",null,null,null,null,null,""]
[null,null,null,null,null,null,null,null,null,null,"Kleine kringloop",{"$f":"\"\"","v":""},null,null,null,"",null,null,null,null,null,""]
[null,null,null,null,null,null,null,null,null,null,"Groenafval naar kleine kringloop",{"$f":"IF(Achtergrond!E265,'2. Transport en voorbewerking'!D36,\"\")","v":""},"ton",null,null,{"$f":"IF(Achtergrond!E265,'2. Transport en voorbewerking'!D36,\"\")","v":""},"ton",null,null,null,null,{"$f":"IF('3. Bewerking'!C40=\"\",0,'3. Bewerking'!C40)","v":0},"ton"]
[null,null,null,null,null,null,null,null,null,null,null,{"$f":"\"\"","v":""},null,null,null,"",null,null,null,null,null,""]
[null,null,null,null,null,null,null,null,null,null,"Surplus water naar RWZI",{"$f":"\"\"","v":""},null,null,null,"",null,null,null,null,null,""]
[null,null,null,null,null,null,null,null,null,null,"Lozing op riool",{"$f":"IF(Achtergrond!E268,'2. Transport en voorbewerking'!D40,\"\")","v":""},"m3/ton groenafval",null,null,{"$f":"IF(Achtergrond!E268,'2. Transport en voorbewerking'!D40,\"\")","v":""},"m3/ton groenafval",null,null,null,null,{"$f":"IF('3. Bewerking'!C43=\"\",0,'3. Bewerking'!C43)","v":0},"m3"]
[null,null,null,null,null,null,null,null,null,null,"Afvoer afvalwater per as",{"$f":"\"\"","v":""},null,null,null,"",null,null,null,null,null,{"$f":"IF('3. Bewerking'!C44=\"\",0,'3. Bewerking'!C44)","v":0},"m3"]
[null,null,null,null,null,null,null,null,null,null,"Transportafstand afvoer",null,null,null,null,null,null,null,null,null,null,{"$f":"IF('3. Bewerking'!C45=\"\",0,'3. Bewerking'!C45)","v":0},"km"]
[]
[null,null,null,null,null,null,null,null,null,null,"Residu naar AVI/stort",{"$f":"\"\"","v":""},null,null,null,"",null,null,null,null,null,""]
[null,null,null,null,null,null,null,null,null,null,"Naar AVI",{"$f":"IF(Achtergrond!E269,cell_residu,\"\")","v":""},"ton",null,null,{"$f":"\"\"","v":""},"ton",null,null,null,null,{"$f":"IF('3. Bewerking'!C48=\"\",0,'3. Bewerking'!C48)","v":0},"ton"]
[null,null,null,null,null,null,null,null,null,null,"Naar stort",{"$f":"IF(Achtergrond!E269,0,\"\")","v":""},"ton",null,null,{"$f":"\"\"","v":""},"ton",null,null,null,null,{"$f":"IF('3. Bewerking'!C49=\"\",0,'3. Bewerking'!C49)","v":0},"ton"]
[null,null,null,null,null,null,null,null,null,null,"Naar hergebruik",{"$f":"\"\"","v":""},null,null,null,"",null,null,null,null,null,{"$f":"IF('3. Bewerking'!C52=\"\",0,'3. Bewerking'!C52)","v":0},"ton"]
[null,null,null,null,null,null,null,null,null,null,"Compostering",{"$f":"\"\"","v":""},null,null,null,"",null,null,null,null,null,""]
[null,null,null,null,null,null,null,null,null,null,"Groenafval naar compostering",{"$f":"IF(Achtergrond!E266,'2. Transport en voorbewerking'!D37,\"\")","v":""},"ton",null,null,{"$f":"IF(Achtergrond!E266,'2. Transport en voorbewerking'!D37,\"\")","v":""},"ton",null,null,null,null,{"$f":"IF(cell_compostering=\"\",0,cell_compostering/('3. Bewerking'!C55/100))","v":0},"ton"]
[null,null,null,null,null,null,null,null,null,null,"Opbrengst compostering",{"$f":"IF(Achtergrond!E266,500,\"\")","v":""},"%",null,null,{"$f":"\"\"","v":""},"%",null,null,null,null,{"$f":"IF('3. Bewerking'!C55=\"\",0,'3. Bewerking'!C55)","v":0},"%"]
[null,{"$f":"0.5*'2. Transport en voorbewerking'!#REF!/100*1000","v":{"$error":"#REF!"}},null,"100% van hout in ingangsmateriaal",null,null,null,null,null,null,null,{"$f":"\"\"","v":""},null,null,null,"",null,null,null,null,null,""]
[null,0,null,"vergisting en bokashi samen max 50% van aangevoerde maaisels",null,null,null,null,null,null,"Droge stof gehalte",{"$f":"IF(Achtergrond!E266,69,\"\")","v":""},"%",null,null,{"$f":"\"\"","v":""},"%",null,null,null,null,{"$f":"IF('3. Bewerking'!C57=\"\",0,'3. Bewerking'!C57)","v":0},"%"]
[null,0,null,"vergisting en bokashi samen max 50% van aangevoerde maaisels",null,null,null,null,null,null,"Dichtheid ",{"$f":"IF(Achtergrond!E266,600,\"\")","v":""},"kg/m3",null,null,{"$f":"\"\"","v":""},"kg/m3",null,null,null,null,null,"kg/m3"]
[null,"75-125% gewichtspercentage aan hout",null,null,null,null,null,null,null,null,"Stikstof gehalte",{"$f":"IF(Achtergrond!E266,8.23,\"\")","v":""},"g N/kg ds",null,null,{"$f":"\"\"","v":""},"g N/kg ds",null,null,null,null,{"$f":"IF('3. Bewerking'!C58=\"\",0,'3. Bewerking'!C58)","v":0},"g N/kg ds"]
[null,0,null,"vergisting en bokashi samen max 50% van aangevoerde maaisels",null,null,null,null,null,null,"Fosfaat gehalte",{"$f":"IF(Achtergrond!E266,4.12,\"\")","v":""},"g P2O5/kg ds",null,null,{"$f":"\"\"","v":""},"g P2O5/kg ds",null,null,null,null,{"$f":"IF('3. Bewerking'!C59=\"\",0,'3. Bewerking'!C59)","v":0},"g P2O5/kg ds"]
[null,null,null,null,null,null,null,null,null,null,"Kalium gehalte",{"$f":"IF(Achtergrond!E266,8.25,\"\")","v":""},"g K2O/kg ds",null,null,{"$f":"\"\"","v":""},"g K2O/kg ds",null,null,null,null,{"$f":"IF('3. Bewerking'!C60=\"\",0,'3. Bewerking'!C60)","v":0},"g K2O/kg ds"]
[null,null,null,"maaisels in compost max 30%; hout in compost min 50%",null,null,null,null,null,null,"Organische stof gehalte",{"$f":"IF(Achtergrond!E266,179,\"\")","v":""},"g O.S./kg ds",null,null,{"$f":"\"\"","v":""},"g O.S./kg ds",null,null,null,null,{"$f":"IF('3. Bewerking'!C61=\"\",0,'3. Bewerking'!C61)","v":0},"g O.S./kg ds"]
[null,null,null,null,null,null,null,null,null,null,null,{"$f":"\"\"","v":""},null,null,null,"",null,null,null,null,null,""]
[null,"Aangevoerde maaisels (kg/ton groenafval)",null,null,null,null,null,null,null,null,"Transport van compost","Gewicht (kg)","Afstand (km) ",null,null,"Gewicht (kg)","Afstand (km)",null,null,null,null,"Gewicht (kg)","Afstand (km)"]
[null,"Maaisels naar vergisting en bokashi:",null,null,null,null,null,null,null,null,"Vrachtwagen",{"$f":"IF(Achtergrond!E266,L180*L179,\"\")","v":""},{"$f":"IF(Achtergrond!E266,100,\"\")","v":""},null,null,{"$f":"\"\"","v":""},{"$f":"\"\"","v":""},null,null,null,null,{"$f":"IF('3. Bewerking'!#REF!=\"\",0,'3. Bewerking'!#REF!)","v":{"$error":"#REF!"}},{"$f":"IF('3. Bewerking'!#REF!=\"\",0,'3. Bewerking'!#REF!)","v":{"$error":"#REF!"}}]
[null,null,null,null,null,null,null,null,null,null,null,{"$f":"\"\"","v":""},null,null,null,"",null,null,null,null,null,""]
[null,null,null,null,null,null,null,null,null,null,"Marktverdeling compost",{"$f":"\"\"","v":""},null,null,null,"",null,null,null,null,null,""]
[null,null,null,null,null,null,null,null,null,null,"Landbouw",{"$f":"IF(Achtergrond!E266,1,\"\")","v":""},"% ",null,null,{"$f":"\"\"","v":""},"% ",null,null,null,null,{"$f":"IF('3. Bewerking'!C65=\"\",0,'3. Bewerking'!C65)","v":0},"% "]
[null,"Lijst",null,null,null,null,null,null,null,null,null,{"$f":"\"\"","v":""},null,null,null,{"$f":"\"\"","v":""}]
[null,"-"]
[null,"Sterk houtig",null,null,null,null,null,null,null,null,"Hoveniers, particulieren",{"$f":"IF(Achtergrond!E266,0,\"\")","v":""},"%",null,null,{"$f":"\"\"","v":""},"%",null,null,null,null,{"$f":"IF('3. Bewerking'!C67=\"\",0,'3. Bewerking'!C67)","v":0},"%"]
[null,"Integraal groen",null,null,null,null,null,null,null,null,"Gemeenten",{"$f":"IF(Achtergrond!E266,0,\"\")","v":""},"%",null,null,{"$f":"\"\"","v":""},"%",null,null,null,null,{"$f":"IF('3. Bewerking'!C69=\"\",0,'3. Bewerking'!C69)","v":0},"%"]
[null,"Maaisels/slootafval",null,null,null,null,null,null,null,null,"Teeltsubstraten",{"$f":"IF(Achtergrond!E266,0,\"\")","v":""},"%",null,null,{"$f":"\"\"","v":""},"%",null,null,null,null,{"$f":"IF('3. Bewerking'!C70=\"\",0,'3. Bewerking'!C70)","v":0},"%"]
[null,"Bladafval"]
[null,"Tuinbouwafval"]
[null,null,null,null,null,null,null,null,null,null,"Anders ",{"$f":"IF(Achtergrond!E266,1-SUM('3. Bewerking'!C65,'3. Bewerking'!C67:C71),\"\")","v":""},"%",null,null,{"$f":"IF(Achtergrond!E266,1-SUM('3. Bewerking'!C65,'3. Bewerking'!C67:C71),\"\")","v":""},"%",null,null,null,null,{"$f":"IF('3. Bewerking'!C72=\"\",0,'3. Bewerking'!C72)","v":1},"%"]
[]
[]
[]
[null,null,null,null,null,null,null,null,null,null,null,{"$f":"\"\"","v":""},null,null,null,{"$f":"\"\"","v":""}]
[null,null,null,null,null,null,null,null,null,null,"Aangeleverd groenafval",{"$f":"\"\"","v":""},null,null,null,{"$f":"\"\"","v":""}]
[null,null,null,null,null,null,null,null,null,null,"Totale hoeveelheid ",{"$f":"\"\"","v":""},"ton",null,null,{"$f":"\"\"","v":""},"ton",null,null,null,null,{"$f":"'2. Transport en voorbewerking'!C7","v":0},"ton"]
[]
[null,null,null,null,null,null,null,null,null,null,"Aandeel sterk houtig",null,"%",null,null,null,"%",null,null,null,null,{"$f":"IF('2. Transport en voorbewerking'!#REF!=\"\",0,'2. Transport en voorbewerking'!#REF!)","v":{"$error":"#REF!"}},"%"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"\"\"","v":""}]
[null,null,null,null,null,null,null,null,null,null,"Aandeel integraal groen",null,"%",null,null,null,"%",null,null,null,null,{"$f":"IF('2. Transport en voorbewerking'!#REF!=\"\",0,'2. Transport en voorbewerking'!#REF!)","v":{"$error":"#REF!"}},"%"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"\"\"","v":""}]
[null,null,null,null,null,null,null,null,null,null,"Aandeel maaisels/slootafval/tuinbouwafval",null,"%",null,null,null,"%",null,null,null,null,{"$f":"IF('2. Transport en voorbewerking'!#REF!=\"\",0,'2. Transport en voorbewerking'!#REF!)","v":{"$error":"#REF!"}},"%"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"\"\"","v":""}]
[null,null,null,null,null,null,null,null,null,null,"Aandeel bladafval",null,"%",null,null,null,"%",null,null,null,null,{"$f":"IF('2. Transport en voorbewerking'!#REF!=\"\",0,'2. Transport en voorbewerking'!#REF!)","v":{"$error":"#REF!"}},"%"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"\"\"","v":""}]
[null,null,null,null,null,null,null,null,null,null,"Aandeel tuinbouwafval",null,null,null,null,null,null,null,null,null,null,{"$f":"IF('2. Transport en voorbewerking'!#REF!=\"\",0,'2. Transport en voorbewerking'!#REF!)","v":{"$error":"#REF!"}}]
[null,null,null,null,null,null,null,null,null,null,null,{"$f":"\"\"","v":""},null,null,null,null,null,null,null,null,null,{"$f":"\"\"","v":""}]
[null,null,null,null,null,null,null,null,null,null,null,{"$f":"\"\"","v":""},null,null,null,{"$f":"\"\"","v":""}]
[null,null,null,null,null,null,null,null,null,null,"Transport","Gewicht (ton)","Afstand (km)",null,null,"Gewicht (ton)","Afstand (km)",null,null,null,null,"Gewicht (ton)","Afstand (km)"]
[null,null,null,null,null,null,null,null,null,null,"Busje met aanhanger",{"$f":"\"\"","v":""},20,null,null,{"$f":"\"\"","v":""},{"$f":"\"\"","v":""},null,null,null,null,{"$f":"IF('2. Transport en voorbewerking'!C11=\"\",0,'2. Transport en voorbewerking'!C11)","v":0},{"$f":"IF('2. Transport en voorbewerking'!D11=\"\",0,'2. Transport en voorbewerking'!D11)","v":0}]
[null,null,null,null,null,null,null,null,null,null,"Vrachtauto 10-20 ton",{"$f":"\"\"","v":""},50,null,null,{"$f":"\"\"","v":""},{"$f":"\"\"","v":""},null,null,null,null,{"$f":"IF('2. Transport en voorbewerking'!C12=\"\",0,'2. Transport en voorbewerking'!C12)","v":0},{"$f":"IF('2. Transport en voorbewerking'!D12=\"\",0,'2. Transport en voorbewerking'!D12)","v":0}]
[null,null,null,null,null,null,null,null,null,null,"Vrachtauto >20 ton",{"$f":"\"\"","v":""},100,null,null,{"$f":"\"\"","v":""},{"$f":"\"\"","v":""},null,null,null,null,{"$f":"IF('2. Transport en voorbewerking'!C13=\"\",0,'2. Transport en voorbewerking'!C13)","v":0},{"$f":"IF('2. Transport en voorbewerking'!D13=\"\",0,'2. Transport en voorbewerking'!D13)","v":0}]
[]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"\"\"","v":""}]
[null,null,null,null,null,null,null,null,null,null,null,{"$f":"\"\"","v":""},null,null,null,{"$f":"\"\"","v":""}]
[null,null,null,null,null,null,null,null,null,null,"Energieverbruik verwerkingsinrichting",{"$f":"\"\"","v":""},null,null,null,{"$f":"\"\"","v":""}]
[null,null,null,null,null,null,null,null,null,null,"Elektriciteit (grijs)",{"$f":"IF('2. Transport en voorbewerking'!C7<>\"\",5*'2. Transport en voorbewerking'!C7,\"\")","v":""},"kWh",null,null,{"$f":"\"\"","v":""},"kWh",null,null,null,null,{"$f":"IF('2. Transport en voorbewerking'!C18=\"\",0,'2. Transport en voorbewerking'!C18)","v":0},"kWh"]
[null,null,null,null,null,null,null,null,null,null,"Elektriciteit (onbekend)",{"$f":"IF('2. Transport en voorbewerking'!C7<>\"\",0*'2. Transport en voorbewerking'!C7,\"\")","v":""},"kWh",null,null,{"$f":"\"\"","v":""},"kWh",null,null,null,null,{"$f":"IF('2. Transport en voorbewerking'!C19=\"\",0,'2. Transport en voorbewerking'!C19)","v":0},"kWh"]
[null,null,null,null,null,null,null,null,null,null,"Elektriciteit (groen uit Nederland)",{"$f":"IF('2. Transport en voorbewerking'!C7<>\"\",0*'2. Transport en voorbewerking'!C7,\"\")","v":""},"kWh",null,null,{"$f":"\"\"","v":""},"kWh",null,null,null,null,{"$f":"IF('2. Transport en voorbewerking'!C20=\"\",0,'2. Transport en voorbewerking'!C20)","v":0},"kWh"]
[null,null,null,null,null,null,null,null,null,null,"Elektriciteit (groen uit buitenland)",{"$f":"IF('2. Transport en voorbewerking'!C7<>\"\",0*'2. Transport en voorbewerking'!C7,\"\")","v":""},"kWh",null,null,{"$f":"\"\"","v":""},"kWh",null,null,null,null,{"$f":"IF('2. Transport en voorbewerking'!C21=\"\",0,'2. Transport en voorbewerking'!C21)","v":0},"kWh"]
[null,null,null,null,null,null,null,null,null,null,"Elektriciteit (eigen opwek PV/wind)",{"$f":"IF('2. Transport en voorbewerking'!C7<>\"\",0*'2. Transport en voorbewerking'!C7,\"\")","v":""},"kWh",null,null,{"$f":"\"\"","v":""},"kWh",null,null,null,null,{"$f":"IF('2. Transport en voorbewerking'!C22=\"\",0,'2. Transport en voorbewerking'!C22)","v":0},"kWh"]
[null,null,null,null,null,null,null,null,null,null,null,{"$f":"\"\"","v":""},null,null,null,{"$f":"\"\"","v":""}]
[null,null,null,null,null,null,null,null,null,null,"Diesel",{"$f":"IF('2. Transport en voorbewerking'!C7<>\"\",3*'2. Transport en voorbewerking'!C7,\"\")","v":""},"liter",null,null,{"$f":"\"\"","v":""},"liter",null,null,null,null,{"$f":"IF('2. Transport en voorbewerking'!C24=\"\",0,'2. Transport en voorbewerking'!C24)","v":0},"liter"]
[null,null,null,null,null,null,null,null,null,null,"Aardgas",{"$f":"IF('2. Transport en voorbewerking'!C7<>\"\",0*'2. Transport en voorbewerking'!C7,\"\")","v":""},"m3",null,null,{"$f":"\"\"","v":""},"m3",null,null,null,null,{"$f":"IF('2. Transport en voorbewerking'!C25=\"\",0,'2. Transport en voorbewerking'!C25)","v":0},"m3"]
[]
[]
[null,"Best practice"]
[null,"Criterium 1",false]
[null,"Criterium 2",false]
[null,"Criterium 3",false]
[null,"Criterium 4",false]
[]
[null,"Voldoet aan best practice",null,null,{"$f":"AND(C239=TRUE,C240=TRUE,C241=TRUE,criterium4=FALSE)","v":false}]
[null,"Bokashi/kleine kringloop",null,null,{"$f":"IF(C242,TRUE,FALSE)","v":false}]
[null,{"$f":"IF(E244,\"Inrichting werkt conform best practice\", \"Inrichting werkt niet conform best practice. De rekenresultaten van de tool zijn mogelijk niet betrouwbaar.\")","v":"Inrichting werkt niet conform best practice. De rekenresultaten van de tool zijn mogelijk niet betrouwbaar."}]
[null,{"$f":"IF(E245,\"\", \"De resultaten voor bokashi en kleine kringloop zijn conservatief ingeschat en onzeker.\")","v":"De resultaten voor bokashi en kleine kringloop zijn conservatief ingeschat en onzeker."}]
[]
[null,"Samenstelling composthoop",null,null,"ton","Voorwaarde"]
[null,"Hout (maximaal)",null,null,{"$f":"'2. Transport en voorbewerking'!#REF!+'2. Transport en voorbewerking'!#REF!-Achtergrond!V136","v":{"$error":"#REF!"}},"Minimaal",0.3,{"$f":"IF(#REF!>G250,TRUE,FALSE)","v":{"$error":"#REF!"}}]
[null,"Gras",null,null,{"$f":"'2. Transport en voorbewerking'!#REF!-Achtergrond!V145-Achtergrond!V148-Achtergrond!V154-Achtergrond!V157-Achtergrond!V164-Achtergrond!V167","v":{"$error":"#REF!"}},"Maximaal ",0.3,{"$f":"IF(#REF!<G251,TRUE,FALSE)","v":{"$error":"#REF!"}}]
[null,"Overig",null,null,{"$f":"'2. Transport en voorbewerking'!#REF!+'2. Transport en voorbewerking'!#REF!","v":{"$error":"#REF!"}}]
[null,"Totaal",null,null,{"$f":"E250+E251+E252","v":{"$error":"#REF!"}}]
[]
[null,{"$f":"IF(H250,\"de composthoop bevat voldoende hout\",\"de composthoop bevat onvoldoende hout\")","v":{"$error":"#REF!"}}]
[null,{"$f":"IF(H251,\"het gehalte maaisels in de composthoop is laag genoeg\",\"het gehalte maaisels in de composthoop is te hoog\")","v":{"$error":"#REF!"}}]
[]
[]
[]
[null,"Selectie bewerkingsopties"]
[null,"Hout naar bio-energiecentrale",null,null,false]
[null,"Maaisels naar co-vergister",null,null,false]
[null,"Maaisels naar gft-vergister",null,null,false]
[null,"Bokashi",null,null,false]
[null,"Kleine kringloop",null,null,false]
[null,"Compostering",null,null,false]
[null,"Afgescheiden zeefgrond",null,null,false]
[null,"Surplus water naar RWZI",null,null,false]
[null,"Residu naar AVI/stort",null,null,false]
[null,"Alternatieve opwerking",null,null,false]
[null,"Residu naar hergebruik",null,null,false]