{"text_format":"1","workbook":"xlsx","n_sheets":21,"sheets":["Algemene informatie","Invullen","Feed","Netto inzamel-efficientie","Hoeveelheid gerecycled product","Netto ketenrendement","Indicatieve lijst van producten","data","Netto","PB","Glass","Metal","Plastics","BC","PMD","D","R pack","R pack + non pack","Graphical results","Nationale referentiedata","Hulp voor invulblad"],"not_rendered":{"charts":12,"images":6,"macros":1,"external_links":0,"defined_names":8,"comments":1,"pivot_tables":0},"unopened":[{"sheet":"Netto inzamel-efficientie","index":3,"reason":"not_a_worksheet"},{"sheet":"Hoeveelheid gerecycled product","index":4,"reason":"not_a_worksheet"},{"sheet":"Netto ketenrendement","index":5,"reason":"not_a_worksheet"}],"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":"Algemene informatie","index":0,"n_rows":5,"n_cols":3,"rows_kept":5,"cut":false,"hidden":false,"merged":[[1,1,2,2]]}
[]
[null,"Rekenmodel Grondstof uit Afval: gemeentelijk hergebruik van huishoudelijke verpakkingsmaterialen\n\nDoel van het rekenmodel\nHet model geeft inzicht in de hoeveelheden secundaire grondstoffen (metaalschroot, glasscherven, papiervezels en plastic maalgoed) er uit de huishoudelijke verpakkingsmaterialen worden gemaakt die uit deze gemeente afkomstig zijn. Dit betreft dus zowel de gescheiden ingezamelde verpakkingsmaterialen als de verpakkingsmaterialen die namens de gemeenten zijn nagescheiden. De resultaten laten zien hoe goed de gemeente voor de vijf huishoudelijke verpakkingsmaterialen presteert ten opzichte van het nationale gemiddelde voor 2017 en dus waar verbeteringen mogelijk zijn.\nDit rekenmodel is bedoeld voor de gemeenteambtenaren, medewerkers van inzamel-, afval- en recyclingbedrijven.\n\nHoe werkt het model?\nDe uitkomsten van elk model zijn uiteraard afhankelijk van de kwaliteit van de invoer. Dit model werkt met enkele verplichte invoervelden en enkele optionele invoervelden. Hoe meer er ingevuld kan worden, hoe betrouwbaarder de resultaten worden. Verplichte invoervelden zijn de naam van de gemeente en het aantal inwoners, de hoeveelheden ingezameld huishoudelijk restafval, alle hoeveelheden gescheiden ingezameld huishoudelijke verpakkingen en of er kunststoffen en drankenkartons worden nagescheiden. Optionele invoervelden zijn de samenstelling van het huishoudelijke restafval en de samenstelling van de gescheiden ingezamelde verpakkingen. Wanneer invoervelden zijn ingevuld berekend het model zelf de resultaten en zet deze in perspectief van het nationaal gemiddelde. Deze resultaten zijn te vinden in de afzonderlijke tabbladen.\n\nWat berekent het model?\n1. Netto-keten-recycling-rendementen\nHet model berekent de netto recyclingketenrendementen voor de vijf verschillende huishoudelijke verpakkingsmaterialen van de gemeente (papier en karton, plastic, glas, metaal en drankenkartons). Dit is een zuivere maat voor het niveau van circulariteit van de gemeente ten aanzien van het hergebruik van huishoudelijke verpakkingen. Omdat deze berekening ook op nationaal niveau is uitgevoerd, wordt gelijk duidelijk hoe de gemeente presteert ten opzichte van het nationale gemiddelde van 2017. Hieruit valt dus op te maken voor welke verpakkingsmaterialen de gemeente bovengemiddeld goed en minder dan gemiddeld goed presteert. Bovendien wordt uitgerekend welke verbeterruimte er nog bestaat. Dit geeft richting aan de gemeente voor het gericht verbeteren van inzameling of nascheiding van huishoudelijke verpakkingsmaterialen.\n\n2. Indicatieve lijst van gemaakte producten\nHet model berekent ook hoeveel secundaire grondstoffen er worden geproduceerd uit de verpakkingen die in de gemeenten zijn ingezameld of namens de gemeenten uit het huisvuil zijn nagescheiden. Dit wordt vertaald in een indicatieve lijst van producten die mogelijk geproduceerd zijn namens de gemeente. Deze lijst is bewust indicatief, omdat naast enkele hergebruiksketens (glas, metaal) met stabiele handelsrelaties er ook ketens zijn met meer dynamische handelsrelaties (plastics). \n\nNetto en brutogewichten\nHet brutogewicht is de som van het nettogewicht aan gewenste materialen, eventueel aanwezige andere materialen en het aanhangend vocht- en vuil. Omdat het bij de recycling van verpakkingsmaterialen ook van belang kan zijn hoeveel niet-verpakkingen er aanwezig zijn, wordt er ook over het netto-verpakkingsgewicht gesproken. Dit betekent dat van het brutogewicht zowel de niet-verpakkingen als de andere materialen als het aanhangend vocht en vuil zijn afgetrokken.\n"]
[]
[]
[null,"Model ontwikkeld door:","Dit model is onderdeel van het project \"Sustainable Packaging\": "]

{"sheet":"Invullen","index":1,"n_rows":117,"n_cols":7,"rows_kept":117,"cut":false,"hidden":false,"merged":[[94,1,94,4],[104,1,104,4],[111,1,111,4],[11,1,11,4]]}
[]
[null,"Invulblad rekenmodel gemeentelijk hergebruik van huishoudelijke verpakkingsmaterialen"]
[]
[null,"Algemeen",null,null,null,null,"Legenda"]
[null,null,null,null,null,null,"Verplicht invulveld"]
[null,"Naam gemeente",null,null,null,null,"Optioneel invulveld"]
[null,"Aantal inwoners",null,"[#]"]
[null,"Aantal aansluitingen",null,"[#]"]
[]
[]
[null,"Ingezamelde hoeveelheden restafval en gescheiden ingezamelde verpakkingen*"]
[null,"* Let op: hier kunt u de hoeveelheden ingezameld restafval en gescheiden ingezamelde verpakkingen invullen. Wanneer uw gemeente bepaalde inzamelsystemen hanteert kunt u dat hier invullen. De andere velden kunt u leeg laten. [Voorbeeld: Een gemeente zamelt PMD alleen gezamelijk in, in dat geval laat u de velden voor Drankenkartons, Kunststof-verpakkingen, Kunststof & Drankenkartons en Metaal-verpakkingen leeg. In het geval dat u 1 van deze stromen ook apart inzamelt, dan kunt u hier de hoeveelheid invullen.]"]
[null,"Restafval",null,"[ton/jaar]"]
[null,"Oud-papier en karton",null,"[ton/jaar]"]
[null,"Glas-verpakkingen (totaal)",null,"[ton/jaar]"]
[null,"Kunststof-verpakkingen",null,"[ton/jaar]"]
[null,"Drankenkartons",null,"[ton/jaar]"]
[null,"Metaal-verpakkingen",null,"[ton/jaar]"]
[null,"Plastic, metaal (blik) en drankenkartons [PMD]",null,"[ton/jaar]"]
[null,"Plastic en drankenkartons [PD]",null,"[ton/jaar]"]
[]
[]
[null,"Samenstelling huisvuil"]
[]
[null,"Is de samenstelling van het huishoudelijk restafval bekend?",null,"[Ja/Nee]"]
[]
[null,"Zo ja, vul dan de onderstaande tabel in, [0] is niks, [niet invullen] is niet bekend"]
[null,"Samenstelling huishoudelijk restafval,[%]"]
[null,null,"Totaal [%]","Verpakkingen [%]","Niet-Verpakkingen [%]"]
[null,"Oud-papier en karton"]
[null,"Kunststof"]
[null,"Glas"]
[null,"Metalen totaal**",null,null,null,null,"** Let op: Voor metalen alleen totaal invullen, of alleen ferro en non-ferro."]
[null,"-Ferro metalen"]
[null,"-Non-Ferrometalen"]
[null,"Drankenkartons"]
[null,"Rest"]
[]
[null,"Wordt het huishoudelijk restafval nagescheiden?",null,"[Ja/Nee]"]
[]
[null,"Zo ja, waar?",null,"Omrin, HVC, Attero-Noord,  Attero-Wijster"]
[]
[]
[null,"Inzameling van verpakkingsglas"]
[]
[null,"Hoe wordt het verpakkingsglas ingezameld?"]
[null,"Kleurgescheiden: wit, groen en bruin apart",null,"[Ja/Nee]"]
[null,"Kleurgescheiden: wit en bont apart",null,"[Ja/Nee]"]
[null,"Gecombineerd: alle verpakkingsglas tezamen",null,"[Ja/Nee]"]
[]
[null,"Zo ja, zijn de aparte gewichten dan bekend, [0] is niks, [niet invullen] is niet bekend"]
[null,"Wit, Groen en Bruin apart"]
[null,"Ingezamelde gewichten glas"]
[null,"wit",null,"[ton/jaar]"]
[null,"groen",null,"[ton/jaar]"]
[null,"bruin",null,"[ton/jaar]"]
[null,"Totaal",{"$f":"SUM(C54:C56)","v":0}]
[]
[null,"Zo ja, zijn de aparte gewichten dan bekend, [0] is niks, [niet invullen] is niet bekend"]
[null,"Wit en Bont apart"]
[null,"Ingezamelde gewichten glas"]
[null,"wit",null,"[ton/jaar]"]
[null,"bont",null,"[ton/jaar]"]
[null,"Totaal",{"$f":"SUM(C62:C63)","v":0}]
[]
[]
[null,"PMD inzameling"]
[]
[null,"Is de samenstelling van het PMD materiaal bekend?",null,"[Ja/Nee]"]
[]
[null,"Zo ja, vul dan de onderstaande tabel in,"]
[null,null,"Totaal [%]","Verpakkingen [%]","Niet-Verpakkingen [%]"]
[null,"Kunststof"]
[null,"Metaal"]
[null,"Drankenkartons"]
[null,"Rest"]
[]
[]
[null,"PD inzameling"]
[]
[null,"Is de samenstelling van het PD materiaal bekend?",null,"[Ja/Nee]"]
[]
[null,"Zo ja, vul dan de onderstaande tabel in,"]
[null,null,"Totaal [%]","Verpakkingen [%]","Niet-Verpakkingen [%]"]
[null,"Kunststof"]
[null,"Drankenkartons"]
[null,"Rest"]
[]
[]
[null,"Samenstelling gescheiden ingezamelde materialen"]
[]
[null,"Is de samenstelling van de gescheiden ingezamelde materialen bekend?"]
[null,null,null,"[Ja/Nee]"]
[]
[null,"Extra uitleg: het gehalte andere materialen en het aandeel verpakkingen tellen niet op tot 100%.\nHet gehalte andere materialen is het bruto gehalte ongewenste materialen in het ingezamelde materiaal."]
[null,null,"Gehalte andere materialen [%] "]
[null,"Oud papier en karton"]
[null,"Glasverpakkingen"]
[null,"Kunststofverpakkingen"]
[null,"Drankenkartons"]
[null,"Metaalverpakkingen"]
[null,"PMD"]
[null,"PD"]
[]
[null,"Extra uitleg: het aandeel verpakkingen is het percentage verpakkingen, \ngedeeld door het percentage verpakkingen en niet-verpakkingen."]
[null,null,"Aandeel verpakkingen [%]"]
[null,"Oud papier en karton"]
[null,"Glasverpakkingen"]
[null,"Kunststofverpakkingen"]
[null,"Drankenkartons"]
[]
[null,"Extra uitleg aanhangend vocht en vuil. Dit is het bruto-gewicht min het netto-gewicht gedeeld door het bruto-gewicht. \nDeze parameter staat dus los van de andere gehaltes"]
[null,null,"Aanhangend vocht en vuil [%]"]
[null,"Oud papier en karton"]
[null,"Glasverpakkingen"]
[null,"Kunststofverpakkingen"]
[null,"Drankenkartons"]

{"sheet":"Feed","index":2,"n_rows":91,"n_cols":15,"rows_kept":91,"cut":false,"hidden":true,"merged":[]}
["Verwerking ingevulde gegevens tot bruikbare modelgegevens"]
["Aantal inwoners",{"$f":"Invullen!C7","v":0},"[#]"]
["Bevolkingsaandeel",{"$f":"B2/data!B8","v":0},"[-]"]
[]
[null,null,null,null,null,null,null,null,"Hulp-veld voor metaalinvulwijze",null,"NIKS","ATM","AFNF","ALLES"]
["Hoeveelheden ingezameld afval","Logische parameter","Ingevuld, [ton/jaar]","Verwacht op basis van nationaal gemiddelde",null,null,null,null,null,null,{"$f":"IF(SUM(J7:J9)=0,1,0)","v":1},{"$f":"IF(AND(J7=1,J8+J9=0),1,0)","v":0},{"$f":"IF(AND(J7=0,J8+J9>0),1,0)","v":0},{"$f":"IF(AND(J7=1,J8+J9>0),1,0)","v":0}]
["Restafval",{"$f":"IF(Invullen!C13=\"\",0,Invullen!C13)","v":0},{"$f":"B7","v":0},{"$f":"IF(B7>0,data!E2*1000*Feed!B3,0)","v":0},{"$f":"IF(B7>0,C7/D7,0)","v":0},null,null,null,"Totaal metaal",{"$f":"IF(Invullen!C33=0,0,1)","v":0},{"$f":"IF(K$6=1,I52,0)","v":4.3646463644479702E-2},{"$f":"IF(L$6=1,Invullen!C33,0)","v":0},{"$f":"IF(M6=1,Invullen!C34+Invullen!C35,0)","v":0},{"$f":"IF(N6=1,Invullen!C33,0)","v":0}]
["Huishoudelijk OPK",{"$f":"IF(Invullen!C14=\"\",0,Invullen!C14)","v":0},{"$f":"B8","v":0},{"$f":"IF(B8>0,data!E3*1000*Feed!B3,0)","v":0},0,null,null,null,"Totaal ferro",{"$f":"IF(Invullen!C34=0,0,1)","v":0},{"$f":"IF(K$6=1,I53,0)","v":3.273484773335978E-2},{"$f":"IF(L6=1,Invullen!C33*Feed!I53/Feed!I52,0)","v":0},{"$f":"IF(M6=1,Invullen!C34,0)","v":0},{"$f":"IF(N6=1,IF(N11=1,Invullen!C34,Invullen!C34*Invullen!C33/(Invullen!C34+Invullen!C35)),0)","v":0}]
["Huishoudelijk glas",{"$f":"IF(Invullen!C15=\"\",0,Invullen!C15)","v":0},0,{"$f":"IF(B9>0,data!E4*1000*B3,0)","v":0},0,null,null,null,"Totaal Nonferro",{"$f":"IF(Invullen!C35=0,0,1)","v":0},1.0911615911119926E-2,{"$f":"IF(L6=1,Invullen!C33*Feed!I54/Feed!I52,0)","v":0},{"$f":"IF(M6=1,Invullen!C35,0)","v":0},{"$f":"IF(N6=1,IF(N11=1,Invullen!C35,Invullen!C35*Invullen!C33/(Invullen!C34+Invullen!C35)),0)","v":0}]
["Huishoudelijk kunststof",{"$f":"IF(Invullen!C16=\"\",0,Invullen!C16)","v":0},0,{"$f":"IF(B10>0,data!E5*1000*Feed!B3,0)","v":0},0,null,null,null,"Invulsom",null,{"$f":"IF(K6=1,SUM(Invullen!C30:C37),0)","v":0},{"$f":"IF(L6=1,SUM(Invullen!C30:C33,Invullen!C36:C37),0)","v":0},{"$f":"IF(M6=1,SUM(Invullen!C30:C37),0)","v":0},{"$f":"IF(N6=1,SUM(Invullen!C30:C33,Invullen!C36:C37),0)","v":0}]
["Huishoudelijk drankenkartons",{"$f":"IF(Invullen!C17=\"\",0,Invullen!C17)","v":0},0,{"$f":"IF(B11>0,data!E7*1000*Feed!B3,0)","v":0},0,null,null,null,"Controle op som metalen",null,null,null,null,{"$f":"IF(Invullen!C33=Invullen!C34+Invullen!C35,1,0)","v":1}]
["Huishoudelijk metaalverpakkingen",{"$f":"IF(Invullen!C18=\"\",0,Invullen!C18)","v":0},0,{"$f":"IF(B12>0,data!E6*1000*Feed!B3,0)","v":0},0]
["PMD",{"$f":"IF(Invullen!C19=\"\",0,Invullen!C19)","v":0},0]
["PD",{"$f":"IF(Invullen!C20=\"\",0,Invullen!C20)","v":0},0]
[]
[]
["Totaal invulwaarden",{"$f":"SUM(K10:N10)","v":0}]
["Logische test of de kwaliteit van de invoer voldoende goed is",{"$f":"IF(AND(B17>0.95,B17<1.05),1,0)","v":0}]
[]
["Samenstelling huishoudelijk restafval,[%] met ruwe waarden",null,null,null,null,null,null,null,"Verpakkingsglas inzamelwijze",null,null,null,"Wit, Groen, Bruin apart"]
[null,"Totaal","Verpakkingen","Niet-Verpakkingen","invulratio","Log test",null,null,null,null,null,null,null,"Default","[ton/jr]"]
["Oud-papier en karton",{"$f":"IF($B$18=1,Invullen!C30*(I47-I49)/I47,I47)","v":0.12399563535363553},{"$f":"IF(B18=0,J47,IF(F22=0, B22*J47/I47,B22*E22*Invullen!D30/Invullen!C30))","v":4.4638428727308797E-2},{"$f":"IF(B18=0,K47,IF(F22=0, B22*K47/I47,B22*E22*Invullen!E30/Invullen!C30))","v":7.9357206626326754E-2},{"$f":"IF((Invullen!D30+Invullen!E30)=0,0,(Invullen!C30)/(Invullen!D30+Invullen!E30))","v":0},{"$f":"IF(AND(E22>0.95,E22<1.05),1,0)","v":0},null,null,"Wit, Groen, Bruin apart",null,{"$f":"IF(Invullen!C47=\"Ja\",B9,0)","v":0},null,"wit",0.6,{"$f":"IF(AND(K22>0,Invullen!C57<>Invullen!C15),Feed!N22*Feed!K22,Invullen!C54)","v":0}]
["Oud-papier en karton niet-recycleerbaar",{"$f":"IF($B$18=1,Invullen!C30*I49/I47,I49)","v":4.463842872730879E-2},{"$f":"IF(B18=0,J49,IF(F22=0, B23*J49/I49,B23*E22*Invullen!D30/Invullen!C30))","v":6.9437555798035899E-3},{"$f":"IF(B18=0,K49,IF(F22=0, B23*K49/I49,B23*E22*Invullen!E30/Invullen!C30))","v":3.76946731475052E-2},null,null,null,null,"Wit en Bont apart",null,{"$f":"IF(Invullen!C48=\"Ja\",B9,0)","v":0},null,"groen",0.3,{"$f":"IF(AND(K22>0,Invullen!C57<>Invullen!C15),Feed!N23*Feed!K22,Invullen!C55)","v":0}]
["Kunststof",{"$f":"IF($B$18=1,Invullen!C31,I50)","v":0.1388751115960718},{"$f":"IF(B18=0,J50,IF(F24=0, B24*J50/I50,B24*E24*Invullen!D31/Invullen!C31))","v":8.7292927288959404E-2},{"$f":"IF(B18=0,K50,IF(F24=0, B24*K50/I50,B24*E24*Invullen!E31/Invullen!C31))","v":5.1582184307112394E-2},{"$f":"IF((Invullen!D31+Invullen!E31)=0,0,(Invullen!C31)/(Invullen!D31+Invullen!E31))","v":0},{"$f":"IF(AND(E24>0.95,E24<1.05),1,0)","v":0},null,null,"Gemengd",null,{"$f":"IF(Invullen!C49=\"Ja\",B9,0)","v":0},null,"bruin",0.1,{"$f":"IF(AND(K22>0,Invullen!C57<>Invullen!C15),Feed!N24*Feed!K22,Invullen!C56)","v":0}]
["Glas",{"$f":"IF($B$18=1,Invullen!C32,I51)","v":5.1582184307112373E-2},{"$f":"IF(B18=0,J51,IF(F25=0, B25*J51/I51,B25*E25*Invullen!D32/Invullen!C32))","v":4.8606289058625129E-2},{"$f":"IF(B18=0,K51,IF(F25=0, B25*K51/I51,B25*E25*Invullen!E32/Invullen!C32))","v":2.9758952484872482E-3},{"$f":"IF((Invullen!D32+Invullen!E32)=0,0,(Invullen!C32)/(Invullen!D32+Invullen!E32))","v":0},{"$f":"IF(AND(E25>0.95,E25<1.05),1,0)","v":0}]
["Metalen totaal",{"$f":"IF($B$18=1,SUM(K7:N7),I52)","v":4.3646463644479702E-2},{"$f":"IF(B18=0,J52,IF(F26=0, B26*J52/I52,B26*E26*Invullen!D33/Invullen!C33))","v":3.0552524551135794E-2},{"$f":"IF(B18=0,K52,IF(F26=0, B26*K52/I52,B26*E26*Invullen!E33/Invullen!C33))","v":1.3093939093343908E-2},{"$f":"IF((Invullen!D33+Invullen!E33)=0,0,(Invullen!C33)/(Invullen!D33+Invullen!E33))","v":0},{"$f":"IF(AND(E26>0.95,E26<1.05),1,0)","v":0},null,null,null,null,null,null,"Wit, Bont apart"]
["-Ferro metalen",{"$f":"IF($B$18=1,SUM(K8:N8),I53)","v":3.273484773335978E-2},{"$f":"IF(B18=0,J53,IF(F27=0, B27*J53/I53,B27*E27*Invullen!D34/Invullen!C34))","v":2.2815196905068936E-2},{"$f":"IF(B18=0,K53,IF(F27=0, B27*K53/I53,B27*E27*Invullen!E34/Invullen!C34))","v":9.9196508282908442E-3},{"$f":"IF((Invullen!D34+Invullen!E34)=0,0,(Invullen!C34)/(Invullen!D34+Invullen!E34))","v":0},0,null,null,null,null,null,null,null,"Default","[ton/jr]"]
["-Non-Ferrometalen",{"$f":"IF($B$18=1,SUM(K9:N9),B54)","v":1.0999999999999999E-2},{"$f":"IF(B18=0,J54,IF(F28=0, B28*J54/I54,B28*E28*Invullen!D35/Invullen!C35))","v":7.7373276460668567E-3},{"$f":"IF(B18=0,K54,IF(F28=0, B28*K54/I54,B28*E28*Invullen!E35/Invullen!C35))","v":3.1742882650530693E-3},{"$f":"IF((Invullen!D35+Invullen!E35)=0,0,(Invullen!C35)/(Invullen!D35+Invullen!E35))","v":0},0,null,null,null,null,null,null,"wit ",0.6,{"$f":"IF(AND(K23>0,Invullen!C64<>Invullen!C15),Feed!N28*Feed!K23,Invullen!C62)","v":0}]
["Drankenkartons",{"$f":"IF($B$18=1,Invullen!C36,I48)","v":2.9758952484872526E-2},null,null,null,null,null,null,null,null,null,null,"bont",0.4,{"$f":"IF(AND(K23>0,Invullen!C64<>Invullen!C15),Feed!N29*Feed!K23,Invullen!C63)","v":0}]
["Rest",{"$f":"IF($B$18=1,Invullen!C37,SUM(I55:I59))","v":0.56750322388651908}]
[]
["Samenstelling huishoudelijk restafval,[%] met tot 100% geïndexeerde waarden"]
[null,"Totaal","Verpakkingen","Niet-Verpakkingen"]
["Oud-papier en karton recycleerbaar",{"$f":"IF($B$18=0,B22,B22*100%/$B$17)","v":0.12399563535363553},{"$f":"IF($B$18=0,C22,C22*100%/$B$17)","v":4.4638428727308797E-2},{"$f":"IF($B$18=0,D22,D22*100%/$B$17)","v":7.9357206626326754E-2}]
["Oud-papier en karton niet-recycleerbaar",{"$f":"IF(B18=0,B23,B23*100%/$B$17)","v":4.463842872730879E-2},{"$f":"IF($B$18=0,C23,C23*100%/$B$17)","v":6.9437555798035899E-3},3.76946731475052E-2]
["Kunststof",{"$f":"IF(B18=0,B24,B24*100%/$B$17)","v":0.1388751115960718},8.7292927288959404E-2,5.1582184307112394E-2]
["Glas",{"$f":"IF(B18=0,B25,B25*100%/$B$17)","v":5.1582184307112373E-2},4.8606289058625129E-2,2.9758952484872482E-3]
["Metalen totaal",{"$f":"IF(B18=0,B26,B26*100%/$B$17)","v":4.3646463644479702E-2},3.0552524551135794E-2,1.3093939093343908E-2]
["-Ferro metalen",{"$f":"IF(B18=0,B27,B27*100%/$B$17)","v":3.273484773335978E-2},{"$f":"IF($B$18=0,C27,IF(F39=1,C27*100%/$B$17,B38*(C38/B38)*(B39/B38)))","v":2.2815196905068936E-2},{"$f":"IF($B$18=0,D27,IF(G39=1,D27*100%/$B$17,B38*(D38/B38)*(B39/B38)))","v":9.9196508282908442E-3},null,{"$f":"IF(C26=C27+C28,1,0)","v":1},{"$f":"IF(D26=D27+D28,1,0)","v":1}]
["-Non-Ferrometalen",{"$f":"IF(B18=0,B28,B28*100%/$B$17)","v":1.0999999999999999E-2},{"$f":"IF($B$18=0,C28,IF(F39=1,C28*100%/$B$17,B38*(C38/B38)*(B40/B38)))","v":7.7373276460668567E-3},{"$f":"IF($B$18=0,D28,IF(G39=1,D28*100%/$B$17,B38*(D38/B38)*(B40/B38)))","v":3.1742882650530693E-3}]
["Drankenkartons",{"$f":"IF(B18=0,B29,B29*100%/$B$17)","v":2.9758952484872526E-2}]
["Rest",{"$f":"IF(B18=0,B30,B30*100%/$B$17)","v":0.56750322388651908}]
[]
[]
["Samenstelling huishoudelijk restafval,[%] DEFAULTWAARDEN Bron: RWS 2015",null,null,null,null,null,"Samenstelling huishoudelijk restafval,[%] DEFAULTWAARDEN Bron: RWS 2015"]
[null,"Totaal","Verpakkingen","Niet-Verpakkingen",null,null,"Geïndexeerd naar 100%",null,"Totaal","Verpakkingen","Niet-Verpakkingen"]
["Oud-papier en karton",0.2,8.2000000000000003E-2,{"$f":"B47-C47","v":0.11800000000000001},null,null,"Oud-papier en karton",null,{"$f":"(B47-B48-B49)/$B$60","v":0.12399563535363553},{"$f":"(C47-C48-C49)/B60","v":4.4638428727308797E-2},{"$f":"(D47-D48-D49)/B60","v":7.9357206626326754E-2}]
["-Drankenkartons",0.03,{"$f":"B48","v":0.03},{"$f":"0%","v":0},null,null,"Drankenkartons",null,{"$f":"B48/$B$60","v":2.9758952484872526E-2},{"$f":"C48/$B$60","v":2.9758952484872526E-2},{"$f":"D48/B60","v":0}]
["-Niet recycleerbaar",4.4999999999999998E-2,7.0000000000000001E-3,3.7999999999999999E-2,null,null,"-Niet recycleerbaar",null,{"$f":"B49/$B$60","v":4.463842872730879E-2},{"$f":"C49/$B$60","v":6.9437555798035899E-3},{"$f":"D49/$B$60","v":3.76946731475052E-2}]
["Kunststof",0.14000000000000001,8.7999999999999995E-2,{"$f":"B50-C50","v":5.2000000000000018E-2},null,null,"Kunststof",null,{"$f":"B50/$B$60","v":0.1388751115960718},{"$f":"C50/$B$60","v":8.7292927288959404E-2},5.1582184307112394E-2]
["Glas",5.1999999999999998E-2,4.9000000000000002E-2,{"$f":"B51-C51","v":2.9999999999999957E-3},null,null,"Glas",null,5.1582184307112373E-2,{"$f":"C51/$B$60","v":4.8606289058625129E-2},2.9758952484872482E-3]
["Metalen totaal",{"$f":"B53+B54","v":4.3999999999999997E-2},{"$f":"C53+C54","v":3.0800000000000001E-2},{"$f":"B52-C52","v":1.3199999999999996E-2},null,null,"Metalen totaal",null,4.3646463644479702E-2,{"$f":"C52/$B$60","v":3.0552524551135794E-2},1.3093939093343908E-2]
["-Ferro metalen",3.3000000000000002E-2,2.3E-2,{"$f":"B53-C53","v":1.0000000000000002E-2},null,null,"-Ferro metalen",null,3.273484773335978E-2,{"$f":"C53/$B$60","v":2.2815196905068936E-2},9.9196508282908442E-3]
["-Non-Ferrometalen",1.0999999999999999E-2,7.7999999999999996E-3,{"$f":"B54-C54","v":3.1999999999999997E-3},null,null,"-Non-Ferrometalen",null,1.0911615911119926E-2,{"$f":"C54/$B$60","v":7.7373276460668567E-3},3.1742882650530693E-3]
["Organisch materiaal",0.38,null,null,null,null,"Organisch materiaal",null,0.37694673147505198]
["Textiel",4.1000000000000002E-2,null,null,null,null,"Textiel",null,4.0670568395992451E-2]
["KCA",1.1000000000000001E-3,null,null,null,null,"KCA",null,1.0911615911119927E-3]
["Luiers",0.05,null,null,null,null,"Luiers",null,4.9598254141454211E-2]
["Ondefinieerbaar en rest",0.1,null,null,null,null,"Ondefinieerbaar en rest",null,9.9196508282908422E-2]
[null,{"$f":"SUM(B47,B50:B52,B55:B59)","v":1.0081000000000002},null,null,null,null,null,null,{"$f":"SUM(I47:I52,I55:I59)","v":0.99999999999999978}]
[]
["PMD",{"$f":"SUM(Invullen!C73:C76)","v":0}]
["logische test",{"$f":"IF(OR(B62<95%,B62>105%),0,1)","v":0}]
[null,"Totaal","Verpakkingen","Niet-Verpakkingen",null,null,"PMD DEFAULTWAARDEN"]
["Kunststof",{"$f":"IF($B$63=0,G65,Invullen!C73*(100%/$B$62))","v":0.65543036600314741},{"$f":"IF(AND($B$63=0,Invullen!D73=\"\"),Feed!B65*G87,IF(Invullen!D73=\"\",Feed!B65*G87,Invullen!D73*100%/$B$62))","v":0.58333302574280121},{"$f":"IF(AND($B$63=0,Invullen!E73=\"\"),Feed!B65*(100%-G87),IF(Invullen!E73=\"\",Feed!B65*(100%-G87),Invullen!E73*100%/$B$62))","v":7.2097340260346213E-2},null,null,0.65543036600314741]
["Metaal",{"$f":"IF($B$63=0,G66,Invullen!C74*(100%/$B$62))","v":8.4434906434492321E-2},{"$f":"IF(AND($B$63=0,Invullen!D74=\"\"),Feed!B66*G89,IF(Invullen!D74=\"\",Feed!B66*G89, Invullen!D74*100%/$B$62))","v":6.7547925147593862E-2},{"$f":"IF(AND($B$63=0,Invullen!E74=\"\"),Feed!B66*(100%-G89),IF(Invullen!E74=\"\", Feed!B66*(100%-G89), Invullen!E74*100%/$B$62))","v":1.6886981286898462E-2},null,null,8.4434906434492321E-2]
["Drankenkartons",{"$f":"IF($B$63=0,G67,Invullen!C75*(100%/$B$62))","v":0.12986757172851776},{"$f":"100%*B67","v":0.12986757172851776},0,null,null,0.12986757172851776]
["Rest / Restafval",{"$f":"IF($B$63=0,G68,Invullen!C76*(100%/$B$62))","v":0.13026715583384246},null,null,null,null,0.13026715583384246]
[null,null,null,null,null,null,"Bron: gemiddelde uit PMD-model"]
["PD",{"$f":"SUM(Invullen!C85:C87)","v":0}]
["logische test",{"$f":"IF(OR(B70<95%,B70>105%),0,1)","v":0}]
[null,"Totaal","Verpakkingen","Niet-Verpakkingen",null,null,"PD DEFAULTWAARDEN"]
["Kunststof",{"$f":"IF($B$71=0,G73,Invullen!C85*(100%/$B$70))","v":0.71444281752163319},{"$f":"IF(AND($B$71=0,Invullen!D85=\"\"),Feed!B73*G87,IF(Invullen!D85=\"\",Feed!B73*G87,Invullen!D85*100%/$B$70))","v":0.63585410759425354},{"$f":"IF(AND($B$71=0,Invullen!E85=\"\"),Feed!B73*(100%-G87),IF(Invullen!E85=\"\",Feed!B73*(100%-G87),Invullen!E85*100%/$B$70))","v":7.8588709927379638E-2},null,"KST",0.71444281752163319]
["Drankenkartons",{"$f":"IF($B$71=0,G74,Invullen!C86*(100%/$B$70))","v":0.15555347544164677},{"$f":"100%*B74","v":0.15555347544164677},0,null,"DK",0.15555347544164677]
["Rest / Restafval",{"$f":"IF($B$71=0,G75,Invullen!C87*(100%/$B$70))","v":0.13000370703672004},null,null,null,"RST",0.13000370703672004]
[null,null,null,null,null,null,"Bron: gemiddelde uit PMD-model"]
["Nascheiden",{"$f":"IF(Invullen!C39=\"Ja\",1,0)","v":0}]
["Omrin",{"$f":"IF(AND(B77=1,Invullen!C41=\"Omrin\"),1,0)","v":0}]
["Attero-Noord",{"$f":"IF(AND(B77=1,Invullen!C41=\"Attero-Noord\"),1,0)","v":0}]
["Attero-Wijster",{"$f":"IF(AND(B77=1,Invullen!C41=\"Attero-Wijster\"),1,0)","v":0}]
["HVC",{"$f":"IF(AND(B77=1,Invullen!C41=\"HVC\"),1,0)","v":0}]
[]
["Samenstelling gescheiden ingezamelde verpakkingsmaterialen",null,null,null,null,"Andere materialen","Pack Ratio","LAMD"]
[null,"Logische test 1 Ingezameld?","Logische test 2 Legitieme invoer and materialen?","L3 PR","L4 LAMD","[%]","[%]","[%]"]
["Oud papier en karton",{"$f":"IF(B8>0,1,0)","v":0},{"$f":"IF(AND(Invullen!C97>0,Invullen!C97<100%),1,0)","v":0},{"$f":"IF(AND(Invullen!C107>0,Invullen!C107<100%),1,0)","v":0},{"$f":"IF(AND(Invullen!C114>0,Invullen!C114<100%),1,0)","v":0},{"$f":"IF(C85=1,Invullen!C97,data!E27)","v":4.2000000000000003E-2},{"$f":"IF(D85=1,Invullen!C107,data!B27)","v":0.35},{"$f":"IF(E85=1,Invullen!C114,data!H27)","v":0.1}]
["Glasverpakkingen",0,{"$f":"IF(AND(Invullen!C98>0,Invullen!C98<100%),1,0)","v":0},{"$f":"IF(AND(Invullen!C108>0,Invullen!C108<100%),1,0)","v":0},{"$f":"IF(AND(Invullen!C115>0,Invullen!C115<100%),1,0)","v":0},{"$f":"IF(C86=1,Invullen!C98,data!E29)","v":5.4000000000000003E-3},{"$f":"IF(D86=1,Invullen!C108,data!B29)","v":0.99898580121703862},{"$f":"IF(E86=1,Invullen!C115,data!H29)","v":0.02}]
["Kunststofverpakkingen",0,{"$f":"IF(AND(Invullen!C99>0,Invullen!C99<100%),1,0)","v":0},{"$f":"IF(AND(Invullen!C109>0,Invullen!C109<100%),1,0)","v":0},{"$f":"IF(AND(Invullen!C116>0,Invullen!C116<100%),1,0)","v":0},{"$f":"IF(C87=1,Invullen!C99,data!E28)","v":0.1},{"$f":"IF(D87=1,Invullen!C109,data!B28)","v":0.89},{"$f":"IF(E87=1,Invullen!C116,data!H28)","v":0.15}]
["Drankenkartons",0,{"$f":"IF(AND(Invullen!C100>0,Invullen!C100<100%),1,0)","v":0},{"$f":"IF(AND(Invullen!C110>0,Invullen!C110<100%),1,0)","v":0},{"$f":"IF(AND(Invullen!C117>0,Invullen!C117<100%),1,0)","v":0},{"$f":"IF(C88=1,Invullen!C100,data!E31)","v":0.15},{"$f":"IF(D88=1,Invullen!C110,data!B31)","v":1},{"$f":"IF(E88=1,Invullen!C117,data!H31)","v":0.28999999999999998}]
["Metaalverpakkingen",0,{"$f":"IF(AND(Invullen!C101>0,Invullen!C101<100%),1,0)","v":0},{"$f":"IF(AND(Invullen!D101>0,Invullen!D101<100%),1,0)","v":0},{"$f":"IF(AND(Invullen!E101>0,Invullen!E101<100%),1,0)","v":0},{"$f":"IF(C89=1,Invullen!C101,data!E30)","v":0.05},{"$f":"IF(D89=1,Invullen!D101,data!B30)","v":0.8},{"$f":"IF(E89=1,Invullen!E101,data!H30)","v":0.05}]
["PMD",0,null,null,null,{"$f":"B68","v":0.13026715583384246}]
["PD",0,null,null,null,{"$f":"B75","v":0.13000370703672004}]

{"sheet":"Indicatieve lijst van producten","index":6,"n_rows":55,"n_cols":9,"rows_kept":55,"cut":false,"hidden":false,"merged":[[30,1,50,1],[51,1,53,1],[3,3,3,4],[3,6,3,7],[1,1,1,8],[5,1,12,1],[13,1,16,1],[17,1,23,1],[24,1,29,1]]}
[]
[null,"Hoeveelheid producten van gerecycled materiaal die namens de gemeente zijn geproduceerd"]
[]
[null,"Categorie","Producten","Hoeveelheid product gemaakt van verpakkingsmaterialen",null,"Nederlands gemiddelde","Hoeveelheid product gemaakt van ingezamelde materiaalstromen (inclusief niet-verpakkingen)",null,"Nederlands gemiddelde"]
[null,null,null,"[kg netto/jr]","[kg netto/inw.jr]","[kg netto/inw.jr]","[kg netto/jr]","[kg netto/inw.jr]","[kg netto/inw.jr]"]
[null,"OPK",{"$f":"PB!Q7","v":"Krantenpapier"},{"$f":"'R pack'!H4","v":0},{"$f":"'R pack'!L4","v":0},1.7123447128505058,{"$f":"'R pack + non pack'!H4","v":0},{"$f":"'R pack + non pack'!L4","v":0},4.858717204751505]
[null,null,{"$f":"PB!Q8","v":"Ongestreken schrijfpapier"},{"$f":"'R pack'!H5","v":0},{"$f":"'R pack'!L5","v":0},0.31404266670459868,{"$f":"'R pack + non pack'!H5","v":0},{"$f":"'R pack + non pack'!L5","v":0},0.89108489446826011]
[null,null,{"$f":"PB!Q9","v":"Gestreken schrijfpapier"},{"$f":"'R pack'!H6","v":0},{"$f":"'R pack'!L6","v":0},0.54957466673304767,{"$f":"'R pack + non pack'!H6","v":0},{"$f":"'R pack + non pack'!L6","v":0},1.5593985653194555]
[null,null,{"$f":"PB!Q10","v":"Golfkarton papier"},{"$f":"'R pack'!H7","v":0},{"$f":"'R pack'!L7","v":0},6.3214622996141205,{"$f":"'R pack + non pack'!H7","v":0},{"$f":"'R pack + non pack'!L7","v":0},17.936924384339548]
[null,null,{"$f":"PB!Q11","v":"Pakpapier"},{"$f":"'R pack'!H8","v":0},{"$f":"'R pack'!L8","v":0},0.53468471270826079,{"$f":"'R pack + non pack'!H8","v":0},{"$f":"'R pack + non pack'!L8","v":0},1.5171488504955293]
[null,null,{"$f":"PB!Q12","v":"Massief karton"},{"$f":"'R pack'!H9","v":0},{"$f":"'R pack'!L9","v":0},4.2504050579846551,{"$f":"'R pack + non pack'!H9","v":0},{"$f":"'R pack + non pack'!L9","v":0},12.060373140648005]
[null,null,{"$f":"PB!Q13","v":"Vouwkarton"},{"$f":"'R pack'!H10","v":0},{"$f":"'R pack'!L10","v":0},0.71911709778800903,{"$f":"'R pack + non pack'!H10","v":0},{"$f":"'R pack + non pack'!L10","v":0},2.0404691818373419]
[null,null,{"$f":"PB!Q14","v":"Sanitair papier"},{"$f":"'R pack'!H11","v":0},{"$f":"'R pack'!L11","v":0},0.70659600008534695,{"$f":"'R pack + non pack'!H11","v":0},{"$f":"'R pack + non pack'!L11","v":0},2.0049410125535854]
[null,"Glas","Verpakkingsglas wit",{"$f":"'R pack'!H12","v":0},{"$f":"'R pack'!L12","v":0},10.533053373676879,{"$f":"'R pack + non pack'!H12","v":0},{"$f":"'R pack + non pack'!L12","v":0},10.745377160804004]
[null,null,"Verpakkingsglas groen",{"$f":"'R pack'!H13","v":0},{"$f":"'R pack'!L13","v":0},5.2665266868384393,{"$f":"'R pack + non pack'!H13","v":0},{"$f":"'R pack + non pack'!L13","v":0},5.3726885804020021]
[null,null,"Verpakkingsglas bruin",{"$f":"'R pack'!H14","v":0},{"$f":"'R pack'!L14","v":0},2.2968198934725583,{"$f":"'R pack + non pack'!H14","v":0},{"$f":"'R pack + non pack'!L14","v":0},2.3431188611916194]
[null,null,"Glas bijproducten",{"$f":"'R pack'!H15","v":0},{"$f":"'R pack'!L15","v":0},0.7454520698970637,{"$f":"'R pack + non pack'!H15","v":0},{"$f":"'R pack + non pack'!L15","v":0},0.76047878636636856]
[null,"Metaal-Fe","Constructiestaal",{"$f":"'R pack'!H19","v":0},{"$f":"'R pack'!L19","v":0},1.7162961185346126,{"$f":"'R pack + non pack'!H19","v":0},{"$f":"'R pack + non pack'!L19","v":0},2.4440486340971814]
[null,null,"Automotive-staal",{"$f":"'R pack'!H20","v":0},{"$f":"'R pack'!L20","v":0},0.34325922370692252,{"$f":"'R pack + non pack'!H20","v":0},{"$f":"'R pack + non pack'!L20","v":0},0.4888097268194363]
[null,null,"Verpakkingsstaal",{"$f":"'R pack'!H21","v":0},{"$f":"'R pack'!L21","v":0},0.51488883556038378,{"$f":"'R pack + non pack'!H21","v":0},{"$f":"'R pack + non pack'!L21","v":0},0.73321459022915447]
[null,null,"Rails",{"$f":"'R pack'!H22","v":0},{"$f":"'R pack'!L22","v":0},0,{"$f":"'R pack + non pack'!H22","v":0},{"$f":"'R pack + non pack'!L22","v":0},0]
[null,null,"Duurzame consumentenartikelen",{"$f":"'R pack'!H23","v":0},{"$f":"'R pack'!L23","v":0},0.34325922370692252,{"$f":"'R pack + non pack'!H23","v":0},{"$f":"'R pack + non pack'!L23","v":0},0.4888097268194363]
[null,null,"Mijnbouwapparatuur",{"$f":"'R pack'!H24","v":0},{"$f":"'R pack'!L24","v":0},0.34325922370692252,{"$f":"'R pack + non pack'!H24","v":0},{"$f":"'R pack + non pack'!L24","v":0},0.4888097268194363]
[null,null,"Scheepsstaal",{"$f":"'R pack'!H25","v":0},{"$f":"'R pack'!L25","v":0},0.17162961185346126,{"$f":"'R pack + non pack'!H25","v":0},{"$f":"'R pack + non pack'!L25","v":0},0.24440486340971815]
[null,"Metaal-Aluminium","Constructiealuminium",{"$f":"'R pack'!H26","v":0},{"$f":"'R pack'!L26","v":0},0,{"$f":"'R pack + non pack'!H26","v":0},{"$f":"'R pack + non pack'!L26","v":0},0]
[null,null,"Transport-aluminium",{"$f":"'R pack'!H27","v":0},{"$f":"'R pack'!L27","v":0},0.46236057026904109,{"$f":"'R pack + non pack'!H27","v":0},{"$f":"'R pack + non pack'!L27","v":0},0.65841302559798009]
[null,null,"Verpakkingsaluminium",{"$f":"'R pack'!H28","v":0},{"$f":"'R pack'!L28","v":0},0,{"$f":"'R pack + non pack'!H28","v":0},{"$f":"'R pack + non pack'!L28","v":0},0]
[null,null,"Machines",{"$f":"'R pack'!H29","v":0},{"$f":"'R pack'!L29","v":0},6.1648076035872149E-2,{"$f":"'R pack + non pack'!H29","v":0},{"$f":"'R pack + non pack'!L29","v":0},8.7788403413064015E-2]
[null,null,"Diverse toepassingen aluminium",{"$f":"'R pack'!H30","v":0},{"$f":"'R pack'!L30","v":0},3.0824038017936074E-2,{"$f":"'R pack + non pack'!H30","v":0},{"$f":"'R pack + non pack'!L30","v":0},4.3894201706532007E-2]
[null,null,"Desox",{"$f":"'R pack'!H31","v":0},{"$f":"'R pack'!L31","v":0},6.1648076035872149E-2,{"$f":"'R pack + non pack'!H31","v":0},{"$f":"'R pack + non pack'!L31","v":0},8.7788403413064015E-2]
[null,"Kunststof","Flessen",{"$f":"'R pack'!H32","v":0},{"$f":"'R pack'!L32","v":0},0,{"$f":"'R pack + non pack'!H32","v":0},{"$f":"'R pack + non pack'!L32","v":0},0]
[null,null,"Trays",{"$f":"'R pack'!H33","v":0},{"$f":"'R pack'!L33","v":0},0.27422260807884036,{"$f":"'R pack + non pack'!H33","v":0},{"$f":"'R pack + non pack'!L33","v":0},0.374579805343352]
[null,null,"Fleece",{"$f":"'R pack'!H34","v":0},{"$f":"'R pack'!L34","v":0},4.0671915111116633E-2,{"$f":"'R pack + non pack'!H34","v":0},{"$f":"'R pack + non pack'!L34","v":0},5.5193711790458969E-2]
[null,null,"Strapping",{"$f":"'R pack'!H35","v":0},{"$f":"'R pack'!L35","v":0},9.1824627921209323E-2,{"$f":"'R pack + non pack'!H35","v":0},{"$f":"'R pack + non pack'!L35","v":0},0.12216360077077867]
[null,null,"Kabelomhulling",{"$f":"'R pack'!H36","v":0},{"$f":"'R pack'!L36","v":0},0.12866780248354223,{"$f":"'R pack + non pack'!H36","v":0},{"$f":"'R pack + non pack'!L36","v":0},0.16914952478302689]
[null,null,"Afvoerpijpen",{"$f":"'R pack'!H37","v":0},{"$f":"'R pack'!L37","v":0},0.80164496642462812,{"$f":"'R pack + non pack'!H37","v":0},{"$f":"'R pack + non pack'!L37","v":0},1.0611416183918994]
[null,null,"Rolkernen",{"$f":"'R pack'!H38","v":0},{"$f":"'R pack'!L38","v":0},0.11182984915303243,{"$f":"'R pack + non pack'!H38","v":0},{"$f":"'R pack + non pack'!L38","v":0},0.15023047609706081]
[null,null,"Rijplaten",{"$f":"'R pack'!H39","v":0},{"$f":"'R pack'!L39","v":0},0.56742298442627459,{"$f":"'R pack + non pack'!H39","v":0},{"$f":"'R pack + non pack'!L39","v":0},0.78568137200422605]
[null,null,"Afvalcontainers",{"$f":"'R pack'!H40","v":0},{"$f":"'R pack'!L40","v":0},6.8845180782425394E-2,{"$f":"'R pack + non pack'!H40","v":0},{"$f":"'R pack + non pack'!L40","v":0},8.8414667798240074E-2]
[null,null,"Non-food flacons",{"$f":"'R pack'!H41","v":0},{"$f":"'R pack'!L41","v":0},3.9076971246006387E-3,{"$f":"'R pack + non pack'!H41","v":0},{"$f":"'R pack + non pack'!L41","v":0},5.6196189362564325E-3]
[null,null,"Bloempotten",{"$f":"'R pack'!H42","v":0},{"$f":"'R pack'!L42","v":0},0.3535157386803689,{"$f":"'R pack + non pack'!H42","v":0},{"$f":"'R pack + non pack'!L42","v":0},0.47074946700585518]
[null,null,"Kratten",{"$f":"'R pack'!H43","v":0},{"$f":"'R pack'!L43","v":0},0.13342779681251912,{"$f":"'R pack + non pack'!H43","v":0},{"$f":"'R pack + non pack'!L43","v":0},0.17933518156680453]
[null,null,"Boombekisting",{"$f":"'R pack'!H44","v":0},{"$f":"'R pack'!L44","v":0},0.11004397093392486,{"$f":"'R pack + non pack'!H44","v":0},{"$f":"'R pack + non pack'!L44","v":0},0.14570714271952534]
[null,null,"Apparaatbehuizing",{"$f":"'R pack'!H45","v":0},{"$f":"'R pack'!L45","v":0},2.3383825878594253E-2,{"$f":"'R pack + non pack'!H45","v":0},{"$f":"'R pack + non pack'!L45","v":0},3.3628038847279183E-2]
[null,null,"Pallets",{"$f":"'R pack'!H46","v":0},{"$f":"'R pack'!L46","v":0},0.37144743011962011,{"$f":"'R pack + non pack'!H46","v":0},{"$f":"'R pack + non pack'!L46","v":0},0.51364604701029237]
[null,null,"Tuinmeubelen",{"$f":"'R pack'!H47","v":0},{"$f":"'R pack'!L47","v":0},0.14642245227703504,{"$f":"'R pack + non pack'!H47","v":0},{"$f":"'R pack + non pack'!L47","v":0},0.19540673348097615]
[null,null,"Speeltoestellen",{"$f":"'R pack'!H48","v":0},{"$f":"'R pack'!L48","v":0},0.35697272504519006,{"$f":"'R pack + non pack'!H48","v":0},{"$f":"'R pack + non pack'!L48","v":0},0.47277068846124676]
[null,null,"Verkeersafscheiders",{"$f":"'R pack'!H49","v":0},{"$f":"'R pack'!L49","v":0},0.16233988918121584,{"$f":"'R pack + non pack'!H49","v":0},{"$f":"'R pack + non pack'!L49","v":0},0.223194984657867]
[null,null,"Oeverbeschoeiing",{"$f":"'R pack'!H50","v":0},{"$f":"'R pack'!L50","v":0},0.16233988918121584,{"$f":"'R pack + non pack'!H50","v":0},{"$f":"'R pack + non pack'!L50","v":0},0.223194984657867]
[null,null,"Steigers plastic lumber",{"$f":"'R pack'!H51","v":0},{"$f":"'R pack'!L51","v":0},0.6047843352251856,{"$f":"'R pack + non pack'!H51","v":0},{"$f":"'R pack + non pack'!L51","v":0},0.81448844848599811]
[null,null,"Bouwemmers, speciekuipen",{"$f":"'R pack'!H52","v":0},{"$f":"'R pack'!L52","v":0},0.25940457507987225,{"$f":"'R pack + non pack'!H52","v":0},{"$f":"'R pack + non pack'!L52","v":0},0.37304704427915042]
[null,"Drankenkartons","Vezels /Solid board",{"$f":"'R pack'!H55","v":0},{"$f":"'R pack'!L55","v":0},9.6264334908485141E-2,{"$f":"'R pack + non pack'!H55","v":0},{"$f":"'R pack + non pack'!L55","v":0},9.6264334908485141E-2]
[null,null,"Vezels / Container board",{"$f":"'R pack'!H56","v":0},{"$f":"'R pack'!L56","v":0},8.1057862974795877E-2,{"$f":"'R pack + non pack'!H56","v":0},{"$f":"'R pack + non pack'!L56","v":0},8.1057862974795877E-2]
[null,null,"Vezels / Sanitary paper",{"$f":"'R pack'!H57","v":0},{"$f":"'R pack'!L57","v":0},0,{"$f":"'R pack + non pack'!H57","v":0},{"$f":"'R pack + non pack'!L57","v":0},0]
[null,"Totaal",null,{"$f":"SUM(D6:D54)","v":0},0,42.949594693585126,0,0,74.49136728047371]

{"sheet":"data","index":7,"n_rows":63,"n_cols":12,"rows_kept":63,"cut":false,"hidden":true,"merged":[]}
["Nationale data 2013 CBS","Gevonden waarden","Eenheid","Bron","Nationale data 2014 CBS",null,null,null,null,null,2013,2014]
["Hoeveelheid restafval 2013",3526,"[kton]","CBS Statline",3451,"[kton]","CBS statline",null,null,null,{"$f":"B2*1000000/$B$8","v":209.16427837167211},{"$f":"E2*1000000/$E$8","v":204.1770204709502}]
["Hoeveelheid gescheiden ingezameld huishoudelijk OPK 2013",924,"[kton]","CBS Statline",929,"[kton]","CBS statline",null,null,null,54.812193197794961,54.963909596497459]
["Hoeveelheid gescheiden ingezameld huishoudelijk Glas 2013",344,"[kton]","CBS Statline",340,"[kton]","CBS statline",null,null,null,20.406271060650937,20.115962607975387]
["Hoeveelheid gescheiden ingezameld huishoudelijk Kunststof 2013",116,"[kton]","CBS Statline/ Nedvang",129,"[kton]","CBS statline",null,null,null,6.8811844274288045,7.6322328718494852]
["Hoeveelheid gescheiden ingezameld huishoudelijk Metaalverpakkingen 2013",2,"[kton]","CBS Statline",2,"[kton]","CBS statline",null,null,null,0.11864111081773801,0.11832919181161992]
["Hoeveelheid gescheiden ingezamelde huishoudelijk drankenkartons 2013",4,"[kton]","CBS Statline",4,"[kton]","CBS statline",null,null,null,0.23728222163547602,0.23665838362323985]
["Hoeveelheid inwoners NL",16857563,"[#]","Gemeentelijst",16902000]
["Hoeveelheid huishoudens NL",7639826,"[#]","Gemeentelijst"]
[]
["Hoeveelheden op de markt gebrachte verpakkingsmaterialen 2013"]
[">Kunststofverpakkingen",463,"[kton]","Nedvang monitoringsverslag 2013",474,"[kton]","Nedvang monitoringsverslag 2014"]
[">OPK-verpakkingen",{"$f":"1191-B16","v":1121},"[kton]","Nedvang monitoringsverslag 2013",{"$f":"1167-70","v":1097},"[kton]","Nedvang monitoringsverslag 2014"]
[">Glazen verpakkingen",546,"[kton]","Nedvang monitoringsverslag 2013",526,"[kton]","Nedvang monitoringsverslag 2014"]
[">Metalen verpakkingen",205,"[kton]","Nedvang monitoringsverslag 2013",221,"[kton]","Nedvang monitoringsverslag 2014"]
[">Drankenkartons",70,"[kton]",null,70,"[kton]"]
[]
[]
["Verpakkingen in het restafval","Percentage van dit materiaal in restafval dat voor verpakkingen wordt gebruikt",null,null,null,null,"Gehalte vocht en vuil","[%]","Bron"]
["Oud-papier en karton",{"$f":"Feed!C47/Feed!B47","v":0.41},null,"Samenstellingsanalyse restafval 2013",null,null,0.4,null,"Friese meting"]
["Kunststof",{"$f":"Feed!C50/Feed!B50","v":0.62857142857142845},null,"Samenstellingsanalyse restafval 2013",null,null,0.4,null,"Friese meting"]
["Glas",{"$f":"Feed!C51/Feed!B51","v":0.9423076923076924},null,"Samenstellingsanalyse restafval 2013",null,null,0.08,null,"Friese meting"]
["Metaal",{"$f":"Feed!C52/Feed!B52","v":0.70000000000000007},null,"Samenstellingsanalyse restafval 2013",null,null,0.25,null,"Friese meting"]
["Drankenkartons",1,null,null,null,null,0.41,null,"Pilot drankenkartons, Attero Noord"]
[]
["Gescheiden inzamelstromen","Gehalte Verpakkingen",null,null,"Percentage restafval, [%]",null,null,"Percentage vocht en vuil, [%]"]
["Oud papier en karton",0.35,"[%]","PRN factsheet/Nedvang middeling",4.2000000000000003E-2,"[%]","Factsheet vervuiling PRN",0.1,"[%]"]
["Kunststof",0.89,null,"Eigen sorteeranalyses, FBR 1487",0.1,"FBR 1487","Eigen sorteeranalyses, FBR 1487",0.15]
["Glas",{"$f":"98.5/98.6","v":0.99898580121703862},null,"Vervuilingsonderzoek 2014 Nedvang",5.4000000000000003E-3,null,"Vervuilingsrapport Nedvang",0.02]
["Metaal",0.8,null,"Schatting",0.05,null,null,0.05,"Meting PMD Deventer"]
["Drankenkartons",1,null,"Geen niet-verpakkingen in pilot",0.15,"Pilot",null,0.28999999999999998,"Pilot"]
[]
["Gescheiden inzamelstromen, hoeveelheden, [kton]","Huishoudelijk, bron","HH, na","Bedrijfsmatig","Totaal"]
["Oud papier en karton",898,null,1387,{"$f":"B34+C34+D34","v":2285},"[kton]","Nedvang monitoringsverslag 2014"]
["Kunststof",131,31,121,{"$f":"B35+C35+D35","v":283},"[kton]","Nedvang monitoringsverslag 2014"]
["Glas",338,null,76,{"$f":"B36+C36+D36","v":414},"[kton]","Nedvang monitoringsverslag 2014"]
["Metaal",{"$f":"5+6","v":11},87,110,{"$f":"B37+C37+D37","v":208},"[kton]","Nedvang monitoringsverslag 2014"]
["Drankenkartons"]
[]
[]
[]
["Technische kengetallen van Nascheidingsinstallaties","Omrin Oude Haske",null,"Attero Noord","Attero Wijster","HVC"]
["Hoeveelheid restafval per jaar",165845,"[ton/jaar]",104332.303,472949.75599999994,null,"Bronnen: gegevens van nascheiders"]
["Hoeveelheid aangesloten inwoners",785887,"[#]",479688,2682847]
["Hoeveelheid aangesloten aansluitingen",342986,"[#]",242764,1415663]
["Gehalte kunststof in het ingaande restafval",0.2,"[%]",0.18840030106162015,0.13574330943197463,null,{"$f":"E46/B46","v":0.67871654715987306}]
["Gehalte kunststofverpakkingen in  het ingaande restafval",{"$f":"B46*B21","v":0.1257142857142857},"[%]",0.12057619267943689,8.6875718036463767E-2]
["Verwachte productie DKR stromen uit het nagescheiden kunststof",12800,"[ton/jaar]",7011.0499999999993,11127.317137947735]
["Nascheidingsefficiëntie 2017",0.32400000000000001,null,0.32200000000000001,0.17799999999999999,0.32,"Verhouding brutogewicht sorteerproducten versus brutogewicht in huisvuil"]
[]
["OPK cijfers van PRN factsheet"]
["Consumptie PK in 2012 in NL",2841,"[kton]"]
["Consumptie PK niet-verpakkingen in 2012 in NL",1712,"[kton]"]
["Consumptie PK verpakkingen in 2012 in NL",{"$f":"1129","v":1129},"[kton]"]
["waarvan drankenkartons",70,"[kton]"]
[]
["Gescheiden ingezameld bij huishoudens in 2012 in NL"]
["PK-niet verpakkingen",766,"[kton]"]
["PK-verpakkingen",229,"[kton]"]
[]
["Gescheiden ingezameld bij bedrijven in 2012 in NL"]
["PK-niet verpakkingen",609,"[kton]"]
["PK-verpakkingen",776,"[kton]"]

{"sheet":"Netto","index":8,"n_rows":67,"n_cols":11,"rows_kept":67,"cut":false,"hidden":true,"merged":[]}
["Berekening netto hoeveelheden in huisvuil",null,null,null,null,null,null,"Berekening voor totaalmateriaal (verpakking+niet-verpakking)"]
[null,null,"Aftrek niet-verpakkingen","Aftrek vocht en vuil","alleen verpakkingen",null,null,"ook niet-verpakkingen"]
["Verpakkingsmaterialen in het huisvuil","Bruto hoeveelheid, [kg bruto/jaar]","Bruto hoeveelheid, [kg bruto/jaar]","Netto hoeveelheid, [kg netto/jaar]","Netto hoeveelheid, [kg netto/inw.jr]",null,null,"Netto totale materiaalhoeveelheid, [kg netto/jaar]","Netto totale materiaalhoeveelheid, [kg netto/inw.jaar]"]
["Papier & karton",{"$f":"Feed!B34*Feed!C7*1000","v":0},{"$f":"Feed!C7*Feed!C34*1000","v":0},{"$f":"C4*(100%-data!G20)","v":0},{"$f":"IF(Feed!$B$2=0,0,D4/Feed!$B$2)","v":0},null,null,{"$f":"B4*(100%-data!G20)","v":0},{"$f":"IF(Feed!$B$2=0,0,H4/Feed!$B$2)","v":0}]
["Kunststof",{"$f":"Feed!B36*Feed!C7*1000","v":0},{"$f":"Feed!C7*Feed!C36*1000","v":0},{"$f":"C5*(100%-data!G21)","v":0},{"$f":"IF(Feed!$B$2=0,0,D5/Feed!$B$2)","v":0},null,null,{"$f":"B5*(100%-data!G21)","v":0},{"$f":"IF(Feed!$B$2=0,0,H5/Feed!$B$2)","v":0}]
["Glas",{"$f":"Feed!B37*Feed!C7*1000","v":0},{"$f":"Feed!C37*Feed!C7*1000","v":0},{"$f":"C6*(100%-data!G22)","v":0},{"$f":"IF(Feed!$B$2=0,0,D6/Feed!$B$2)","v":0},null,null,{"$f":"B6*(100%-data!G22)","v":0},{"$f":"IF(Feed!$B$2=0,0,H6/Feed!$B$2)","v":0}]
["Metaal",{"$f":"Feed!B38*Feed!C7*1000","v":0},{"$f":"Feed!C38*Feed!C7*1000","v":0},{"$f":"C7*(100%-data!G23)","v":0},{"$f":"IF(Feed!$B$2=0,0,D7/Feed!$B$2)","v":0},null,null,{"$f":"B7*(100%-data!G23)","v":0},{"$f":"IF(Feed!$B$2=0,0,H7/Feed!$B$2)","v":0}]
["Drankenkarton",{"$f":"Feed!B41*Feed!C7*1000","v":0},{"$f":"B8","v":0},{"$f":"C8*(100%-data!G24)","v":0},{"$f":"IF(Feed!$B$2=0,0,D8/Feed!$B$2)","v":0},null,null,{"$f":"D8","v":0},{"$f":"IF(Feed!$B$2=0,0,H8/Feed!$B$2)","v":0}]
["Totaal",{"$f":"SUM(B4:B8)","v":0},{"$f":"SUM(C4:C8)","v":0},{"$f":"SUM(D4:D8)","v":0},{"$f":"SUM(E4:E8)","v":0},null,null,{"$f":"SUM(H4:H8)","v":0},{"$f":"SUM(I4:I8)","v":0}]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
["Berekening netto hoeveelheden in gescheiden inzamelstromen",null,null,null,null,null,null,"Berekening voor totaalmateriaal (verpakking+niet-verpakking)"]
[null,null,"Aftrek restafval","Aftrek niet-verpakkingen","Aftrek vocht en vuil",null,null,"ook niet-verpakkingen"]
["Verpakkingsmaterialen in gescheiden inzamelstromen","Bruto totale hoeveelheid, [kg bruto/jaar]","Bruto hoeveelheid verpakkingen, [kg bruto/jaar]","Bruto hoeveelheid verpakkingen, [kg bruto/jaar]","Netto hoeveelheid verpakkingen, [kg netto/jaar]","Netto hoeveelheid, [kg netto/inw.jr]",null,"Netto totale materiaalhoeveelheid, [kg netto/jaar]","Netto totale materiaalhoeveelheid, [kg netto/inw.jaar]"]
["Papier & karton verpakkingen in OPK",{"$f":"Feed!C8*1000","v":0},{"$f":"B23*(100%-Feed!F85)","v":0},{"$f":"C23*Feed!G85","v":0},{"$f":"D23*(100%-Feed!H85)","v":0},{"$f":"IF(Feed!$B$2=0,0,E23/Feed!$B$2)","v":0},null,{"$f":"C23*(100%-Feed!H85)","v":0},{"$f":"IF(Feed!$B$2=0,0,H23/Feed!$B$2)","v":0}]
["Kunststof in mono-inzameling",{"$f":"Feed!C10*1000","v":0},{"$f":"B24*(100%-Feed!F87)","v":0},{"$f":"C24*Feed!G87","v":0},{"$f":"D24*(100%-Feed!H87)","v":0},{"$f":"IF(Feed!$B$2=0,0,E24/Feed!$B$2)","v":0},null,{"$f":"C24*(100%-Feed!H87)","v":0},{"$f":"IF(Feed!$B$2=0,0,H24/Feed!$B$2)","v":0}]
["Kunststof in PMD-inzameling",{"$f":"Feed!C13*Feed!B65*1000","v":0},{"$f":"B25","v":0},{"$f":"Feed!C13*Feed!C65*1000","v":0},{"$f":"D25*(100%-Feed!H87)","v":0},{"$f":"IF(Feed!$B$2=0,0,E25/Feed!$B$2)","v":0},null,{"$f":"C25*(100%-Feed!H87)","v":0},{"$f":"IF(Feed!$B$2=0,0,H25/Feed!$B$2)","v":0}]
["Kunststof in PD-inzameling",{"$f":"Feed!C14*Feed!B73*1000","v":0},{"$f":"B26","v":0},{"$f":"Feed!B14*Feed!C73*1000","v":0},{"$f":"D26*(100%-Feed!H87)","v":0},{"$f":"IF(Feed!$B$2=0,0,E26/Feed!$B$2)","v":0},null,{"$f":"C26*(100%-Feed!H87)","v":0},{"$f":"IF(Feed!$B$2=0,0,H26/Feed!$B$2)","v":0}]
["Glas (wit, groen, bruin) glasbak",{"$f":"Feed!K22*1000","v":0},{"$f":"B27*(100%-Feed!$F$86)","v":0},{"$f":"C27*Feed!$G$86","v":0},{"$f":"D27*(100%-Feed!$H$86)","v":0},{"$f":"IF(Feed!$B$2=0,0,E27/Feed!$B$2)","v":0},null,{"$f":"C27*(100%-Feed!H86)","v":0},{"$f":"IF(Feed!$B$2=0,0,H27/Feed!$B$2)","v":0}]
["Glas (wit, bont) glasbak",{"$f":"Feed!K23*1000","v":0},{"$f":"B28*(100%-Feed!$F$86)","v":0},{"$f":"C28*Feed!$G$86","v":0},{"$f":"D28*(100%-Feed!$H$86)","v":0},{"$f":"IF(Feed!$B$2=0,0,E28/Feed!$B$2)","v":0},null,{"$f":"C28*(100%-Feed!H86)","v":0},{"$f":"IF(Feed!$B$2=0,0,H28/Feed!$B$2)","v":0}]
["Glas in Bonte glasbak",{"$f":"Feed!K24*1000","v":0},{"$f":"B29*(100%-Feed!$F$86)","v":0},{"$f":"C29*Feed!$G$86","v":0},{"$f":"D29*(100%-Feed!$H$86)","v":0},{"$f":"IF(Feed!$B$2=0,0,E29/Feed!$B$2)","v":0},null,{"$f":"C29*(100%-Feed!H86)","v":0},{"$f":"IF(Feed!$B$2=0,0,H29/Feed!$B$2)","v":0}]
["Metaal in mono-inzameling",{"$f":"Feed!C12*1000","v":0},{"$f":"B30*(100%-Feed!F89)","v":0},{"$f":"C30*Feed!G89","v":0},{"$f":"D30*(100%-Feed!H89)","v":0},{"$f":"IF(Feed!$B$2=0,0,E30/Feed!$B$2)","v":0},null,{"$f":"C30*(100%-Feed!H89)","v":0},{"$f":"IF(Feed!$B$2=0,0,H30/Feed!$B$2)","v":0}]
["Metaal in PMD-inzameling",{"$f":"Feed!C13*Feed!B66*1000","v":0},{"$f":"B31","v":0},{"$f":"Feed!C13*Feed!C66*1000","v":0},{"$f":"D31*(100%-Feed!H89)","v":0},{"$f":"IF(Feed!$B$2=0,0,E31/Feed!$B$2)","v":0},null,{"$f":"C31*(100%-Feed!H89)","v":0},{"$f":"IF(Feed!$B$2=0,0,H31/Feed!$B$2)","v":0}]
["Drankenkarton in mono-inzameling",{"$f":"Feed!C11*1000","v":0},{"$f":"B32*(100%-Feed!F88)","v":0},{"$f":"C32*Feed!G88","v":0},{"$f":"D32*(100%-Feed!H88)","v":0},{"$f":"IF(Feed!$B$2=0,0,E32/Feed!$B$2)","v":0},null,{"$f":"C32*(100%-Feed!H88)","v":0},{"$f":"IF(Feed!$B$2=0,0,H32/Feed!$B$2)","v":0}]
["Drankenkarton in PMD-inzameling",{"$f":"Feed!C13*Feed!B67*1000","v":0},{"$f":"B33","v":0},{"$f":"Feed!C13*Feed!C67*1000","v":0},{"$f":"D33*(100%-Feed!H88)","v":0},{"$f":"IF(Feed!$B$2=0,0,E33/Feed!$B$2)","v":0},null,{"$f":"C33*(100%-Feed!H88)","v":0},{"$f":"IF(Feed!$B$2=0,0,H33/Feed!$B$2)","v":0}]
["Drankenkarton in PD-inzameling",{"$f":"Feed!B14*Feed!B74*1000","v":0},{"$f":"B34","v":0},{"$f":"Feed!C14*Feed!C74*1000","v":0},{"$f":"D34*(100%-Feed!H88)","v":0},{"$f":"IF(Feed!$B$2=0,0,E34/Feed!$B$2)","v":0},null,{"$f":"C34*(100%-Feed!H88)","v":0},{"$f":"IF(Feed!$B$2=0,0,H34/Feed!$B$2)","v":0}]
["Totaal",{"$f":"SUM(B23:B34)","v":0},{"$f":"SUM(C23:C34)","v":0},{"$f":"SUM(D23:D34)","v":0},{"$f":"SUM(E23:E34)","v":0},{"$f":"SUM(F23:F34)","v":0},null,{"$f":"SUM(H23:H34)","v":0},{"$f":"SUM(I23:I34)","v":0}]
[]
[]
[]
[]
[]
["Berekening potentiaal verpakkingen",null,null,null,null,null,null,"Berekening voor totaalmateriaal (verpakking+niet-verpakking)"]
[null,null,null,null,null,null,null,"ook niet-verpakkingen"]
["De hoeveelheid verpakkingen die in de gemeente aanwezig zijn",null,"Bruto hoeveelheid verpakkingen, [kg bruto/jaar]","Netto hoeveelheid verpakkingen, [kg netto/jaar]","Netto hoeveelheid, [kg netto/inw.jr]",null,null,"Netto totale materiaalhoeveelheid, [kg netto/jaar]","Netto totale materiaalhoeveelheid, [kg netto/inw.jaar]",null,"vermenigvuldigingsfactoren"]
["Papier & karton",null,{"$f":"C4+D23","v":0},{"$f":"D4+E23","v":0},{"$f":"E4+F23","v":0},null,null,{"$f":"H4+H23","v":0},{"$f":"I4+I23","v":0},null,{"$f":"IF(D44=0,0,H44/D44)","v":0}]
["Kunststof",null,{"$f":"C5+D24+D25+D26","v":0},{"$f":"D5+E24+E25+E26","v":0},{"$f":"E5+F24+F25+F26","v":0},null,null,{"$f":"H5+H24+H25+H26","v":0},{"$f":"I5+I24+I25+I26","v":0},null,{"$f":" IF(D45=0,0, H45/D45)","v":0}]
["Glas",null,{"$f":"C6+D27+D28+D29","v":0},{"$f":"D6+E27+E28+E29","v":0},{"$f":"E6+F27+F28+F29","v":0},null,null,{"$f":"H6+H27+H28+H29","v":0},{"$f":"I6+I27+I28+I29","v":0},null,{"$f":" IF(D46=0,0, H46/D46)","v":0}]
["Metaal",null,{"$f":"C7+D30+D31","v":0},{"$f":"D7+E30+E31","v":0},{"$f":"E7+F30+F31","v":0},null,null,{"$f":"H7+H30+H31","v":0},{"$f":"I7+I30+I31","v":0},null,{"$f":"IF(D47=0,0, H47/D47)","v":0}]
["Drankenkarton",null,{"$f":"C8+D32+D33+D34","v":0},{"$f":"D8+E32+E33+E34","v":0},{"$f":"E8+F32+F33+F34","v":0},null,null,{"$f":"H8+H32+H33+H34","v":0},{"$f":"I8+I32+I33+I34","v":0},null,{"$f":"IF(D48=0,0, H48/D48)","v":0}]
["Totaal",null,{"$f":"B9+D35","v":0},{"$f":"D9+E35","v":0},{"$f":"SUM(E44:E48)","v":0},null,null,{"$f":"H9+H35","v":0},{"$f":"SUM(I44:I48)","v":0}]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
["Berekening netto massarendement van inzameling",null,null,null,null,null,null,"Berekening voor totaalmateriaal (verpakking+niet-verpakking)"]
[null,null,"Bruto inzamelmassarendement, [%]","Netto inzamelmassarendement, [%]",null,null,null,"Bruto inzamelmassarendement, [%]","Netto inzamelmassarendement, [%]"]
["Papier & karton",null,{"$f":"D23/C44","v":{"$error":"#DIV/0!"}},{"$f":"E23/D44","v":{"$error":"#DIV/0!"}},null,null,null,null,{"$f":"I23/I44","v":{"$error":"#DIV/0!"}}]
["Kunststof",null,{"$f":"(D24+D25)/C45","v":{"$error":"#DIV/0!"}},{"$f":"(E24+E25)/D45","v":{"$error":"#DIV/0!"}},null,null,null,null,{"$f":"(I24+I25)/I45","v":{"$error":"#DIV/0!"}}]
["Glas",null,{"$f":"D27/C46","v":{"$error":"#DIV/0!"}},{"$f":"E27/D46","v":{"$error":"#DIV/0!"}},null,null,null,null,{"$f":"I27/I46","v":{"$error":"#DIV/0!"}}]
["Metaal",null,{"$f":"(D30+D31)/C47","v":{"$error":"#DIV/0!"}},{"$f":"(E30+E31)/D47","v":{"$error":"#DIV/0!"}},null,null,null,null,{"$f":"(I30+I31)/I47","v":{"$error":"#DIV/0!"}}]
["Drankenkarton",null,{"$f":"(D32+D33)/C48","v":{"$error":"#DIV/0!"}},{"$f":"(E32+E33)/D48","v":{"$error":"#DIV/0!"}},null,null,null,null,{"$f":"(I32+I33)/I48","v":{"$error":"#DIV/0!"}}]

{"sheet":"PB","index":9,"n_rows":33,"n_cols":25,"rows_kept":33,"cut":false,"hidden":true,"merged":[]}
[null,null,null,null,null,null,null,null,null,null,"Hoeveelheid door de gemeente ingezamelde OPK verpakkingen",null,null,null,null,null,null,{"$f":"Netto!D23","v":0},"[kg bruto verpakkingen/jaar]"]
["Afzetverdeling PRN 2014","[ton in 2014]","Recycled content","Inzet OPK","Inzet nieuw","Verdeling recycled content over het geheel","Geindexeerd",null,"Productieverdeling ",null,null,null,null,null,null,null,null,{"$f":"Netto!E23","v":0},"[kg netto verpakkingen ds/jaar]"]
["Krantenpapier",253000,1,{"$f":"C3*B3","v":253000},{"$f":"B3-D3","v":0},{"$f":"C3*B3/SUM($B$3:$B$10)","v":9.123692751532636E-2},{"$f":"F3/$F$11","v":0.11333855974913204},null,"OPK verpakkingen"]
["Ongestreken schrijfpapier",232000,0.2,{"$f":"C4*B4","v":46400},{"$f":"B4-D4","v":185600},{"$f":"C4*B4/SUM($B$3:$B$10)","v":1.6732780382257482E-2},{"$f":"F4/$F$11","v":2.0786202262291407E-2},null,null,null,null,null,null,null,null,null,"Inzet voor hergebruik",{"$f":"R1*D33","v":0},"[kg bruto verpakkingen/jaar]",null,null,null,"Sorteerverlies",{"$f":"R1-R4","v":0},"[kg bruto verp/jaar]"]
["Gestreken schrijfpapier",406000,0.2,81200,324800,2.9282365668950594E-2,3.6375853959009968E-2,null,null,null,null,null,null,null,null,null,"Productie hergebruik",{"$f":"C27*R4","v":0},"[kg hergebruikt OPK/jaar]",null,null,null,"Hergebruiksverlies",{"$f":"R4-R5","v":0},"[kg bruto verp/jaar]"]
["Golfkarton papier",934000,1,934000,0,0.33681932924630364,0.41841191622802104,null,{"$f":"B6/SUM($B$6:$B$9)","v":0.52887882219705551},{"$f":"I6*C6","v":0.52887882219705551},{"$f":"J6*100%/$J$11","v":0.53455429961367862},null,null,null,null,null,"Inzet bij productie van"]
["Pakpapier",79000,1,79000,0,2.8489001081860799E-2,3.5390301265539256E-2,null,{"$f":"B7/SUM($B$6:$B$9)","v":4.4733861834654588E-2},{"$f":"I7*C7","v":4.4733861834654588E-2},{"$f":"J7*100%/$J$11","v":4.5213907569037058E-2},null,null,null,null,null,"Krantenpapier",{"$f":"$R$5*G3","v":0}]
["Massief karton",628000,1,628000,0,0.22646952758745043,0.28133049613618549,null,{"$f":"B8/SUM($B$6:$B$9)","v":0.35560588901472251},{"$f":"I8*C8","v":0.35560588901472251},{"$f":"J8*100%/$J$11","v":0.35942194877664896},null,null,null,null,null,"Ongestreken schrijfpapier",0]
["Vouwkarton",125000,0.85,106250,18750,3.8315903353768485E-2,4.759771530966514E-2,null,{"$f":"B9/SUM($B$6:$B$9)","v":7.0781426953567386E-2},{"$f":"I9*C9","v":6.0164212910532276E-2},{"$f":"J9*100%/$J$11","v":6.0809844040635282E-2},null,null,null,null,null,"Gestreken schrijfpapier",0]
["Sanitair papier",116000,0.9,104400,11600,3.7648755860079333E-2,4.6768955090155669E-2,null,null,null,null,null,null,null,null,null,"Golfkarton papier",0]
[null,{"$f":"SUM(B3:B10)","v":2773000},null,{"$f":"SUM(D3:D10)","v":2232250},{"$f":"SUM(E3:E10)","v":540750},{"$f":"SUM(F3:F10)","v":0.8049945906959971},null,null,{"$f":"SUM(I6:I9)","v":1},{"$f":"SUM(J6:J10)","v":0.98938278595696494},{"$f":"SUM(K6:K10)","v":1},null,null,null,null,null,"Pakpapier",0]
["Overall grondstofinzet 2014 PRN, [kton]",null,null,{"$f":"D11/(D11+E11)","v":0.8049945906959971},{"$f":"E11/(E11+D11)","v":0.1950054093040029},null,null,null,null,null,null,null,null,null,null,null,"Massief karton",0]
["Oudpapier",2209,{"$f":"B13/$B$16","v":0.70823982045527412},null,null,null,null,null,null,null,null,null,null,null,null,null,"Vouwkarton",0]
["Nieuw vezel",544,{"$f":"B14/$B$16","v":0.17441487656300098},null,null,null,null,null,null,null,null,null,null,null,null,null,"Sanitair papier",0]
["Vulmiddelen",366,{"$f":"B15/$B$16","v":0.11734530298172491}]
[null,{"$f":"SUM(B13:B15)","v":3119}]
[]
["Afval NL papierindustrie volgens CBS, 2012, [ton]"]
["Papierafval",202000]
["IJzerafval",20000,null,null,null,null,null,null,"inzetmassa",{"$f":"B13","v":2209},"[kton/a]",null,"outputvezel",null,{"$f":"J20-262","v":1947},"[kton/a]"]
["Gemengd metaalafval",3000,null,null,null,null,null,null,"cvezel",0.95799999999999996,null,null,"cvezel",null,1]
["Textielafval",1000,null,null,null,null,null,null,"massa vezel",{"$f":"J20*J21","v":2116.2219999999998},"[kton/a]"]
["Plasticafval",22000,null,null,null,null,null,null,"massa veront",{"$f":"J20-J22","v":92.778000000000247},"[kton/a]"]
["Houtafval",14000,null,null,null,null,null,null,null,null,null,null,"vezelopbrengst",null,{"$f":"O20/J22","v":0.92003579964672899}]
["Totaal",{"$f":"SUM(B19:B24)","v":262000}]
["Productieverlies bij hergebruik",{"$f":"B25/(B16*1000)","v":8.4001282462327673E-2},{"$f":"100%-B26","v":0.91599871753767237},null,"Hergebruiksrendement"]
["Alleen betrokken op recycled input",{"$f":"B25/(B13*1000)","v":0.11860570393843368},{"$f":"100%-B27","v":0.88139429606156627},null,"Hergebruiksrendement tov oudpapier"]
[]
["Om hieruit de productie per gemeente te berekenen, moet hieruit het aandeel van het totaal in relatie tot verpakkingen worden berekend."]
[]
["Consumptie papier en karton 2014",2986000]
["Ingezameld",2375000]
["Ingezet voor recycling",2209000,{"$f":"B32-B33","v":166000},{"$f":"100%-C33/B32","v":0.93010526315789477},"Dit verschil zijn sorteer en vochtverliezen"]

{"sheet":"Glass","index":10,"n_rows":33,"n_cols":13,"rows_kept":33,"cut":false,"hidden":true,"merged":[]}
["Namens de gemeente ingezameld glas"]
[]
["Kleurgescheiden Wit, Groen en Bruin apart ingezameld",null,null,null,null,null,null,null,null,"Verliesverdeling"]
[null,{"$f":"Netto!D27","v":0},"[kg bruto/jr]",{"$f":"Netto!E27","v":0},"[kg netto/jr]",null,null,null,null,"Glas bijproduct","Steen, mineralen, opvul","Metaal","plasticafval"]
[null,null,null,null,null,null,null,null,null,0.5,0.2,0.1,0.2]
[null,null,null,"Feedstock",null,"Sorteerverlies",null,null,"Verpakkingsglas","Glas bijproduct","Steen, mineralen, opvul","Metaal","plasticafval"]
["Gemiddelde kleurensamenstelling",null,null,"[kg netto/jr]",null,"[%]",null,null,"[kg netto/jr]","[kg netto/jr]","[kg netto/jr]","[kg netto/jr]","[kg netto/jr]"]
["Transparant",0.6,null,{"$f":"Feed!G86*(100%-Feed!$F$86)*(100%-Feed!$H$86)*IF(Feed!O22<>0,Feed!O22*1000,Netto!B27*Glass!B8)","v":0},null,0.06,null,null,{"$f":"D8*(100%-F8)","v":0},{"$f":"$D8*$F8*J$5","v":0},0,0,0]
["Groen",0.3,null,{"$f":"Feed!G86*(100%-Feed!$F$86)*(100%-Feed!$H$86)*IF(Feed!O23<>0,Feed!O23*1000,Netto!B27*Glass!B9)","v":0},null,0.06,null,null,{"$f":"D9*(100%-F9)","v":0},0,0,0,0]
["Bruin",0.1,null,{"$f":"Feed!G86*(100%-Feed!$F$86)*(100%-Feed!$H$86)*IF(Feed!O24<>0,Feed!O24*1000,Netto!B27*Glass!B10)","v":0},null,0.1,null,null,{"$f":"D10*(100%-F10)","v":0},0,0,0,0]
[null,null,null,null,null,null,null,null,{"$f":"SUM(I8:I10)","v":0},{"$f":"SUM(J8:J10)","v":0},{"$f":"SUM(K8:K10)","v":0},{"$f":"SUM(L8:L10)","v":0},{"$f":"SUM(M8:M10)","v":0}]
[]
["Kleurgescheiden Wit en Bont apart ingezameld"]
[]
[null,null,null,null,null,null,null,null,null,0.5,0.2,0.1,0.2]
[null,null,null,"Feedstock","Feedstock","Alg. Sorteerverlies","Kleur sorteerverlies","Verpakkingsglas pot","Verpakkingsglas echt","Glas bijproduct","Steen, mineralen, opvul","Metaal","plasticafval"]
["Gemiddelde kleurensamenstelling",null,null,"[kg bruto/jr]","[kg netto/jr]","[%]","[%]","[kg netto/jr]","[kg netto/jr]","[kg netto/jr]","[kg netto/jr]","[kg netto/jr]","[kg netto/jr]"]
["Transparant",0.6,"wit",{"$f":"Feed!G86*(100%-Feed!$F$86)*IF(Feed!O28<>0,Feed!O28*1000,Netto!B28*Glass!B18)","v":0},{"$f":"D18*(100%-Feed!$H$86)","v":0},0.06,0,{"$f":"E18*(100%-F18)","v":0},{"$f":"H18*(100%-G18)","v":0},{"$f":"($E$18-$I$18)*J15","v":0},{"$f":"($E$18-$I$18)*K15","v":0},{"$f":"($E$18-$I$18)*L15","v":0},{"$f":"($E$18-$I$18)*M15","v":0}]
["Groen",0.3,"bont",{"$f":"Feed!G86*(100%-Feed!$F$86)*IF(Feed!O29<>0,Feed!O29*1000,Netto!B28*Glass!B19)","v":0},{"$f":"D19*(100%-Feed!$H$86)","v":0},0.1,0.1,{"$f":"E19*(100%-F19)*(B19/(B19+B20))","v":0},{"$f":"H19*(100%-G19)","v":0},{"$f":"($E$19-$I$19-$I$20)*J15*($B$19/($B$19+$B$20))","v":0},{"$f":"($E$19-$I$19-$I$20)*K15*($B$19/($B$19+$B$20))","v":0},{"$f":"($E$19-$I$19-$I$20)*L15*($B$19/($B$19+$B$20))","v":0},{"$f":"($E$19-$I$19-$I$20)*M15*($B$19/($B$19+$B$20))","v":0}]
["Bruin",0.1,null,null,null,null,null,{"$f":"E19*(100%-F19)*(B20/(B19+B20))","v":0},{"$f":"H20*(100%-G20)","v":0},{"$f":"($E$19-$I$20-$I$19)*J15*($B$20/($B$19+$B$20))","v":0},{"$f":"($E$19-$I$20-$I$19)*K15*($B$20/($B$19+$B$20))","v":0},{"$f":"($E$19-$I$20-$I$19)*L15*($B$20/($B$19+$B$20))","v":0},{"$f":"($E$19-$I$20-$I$19)*M15*($B$20/($B$19+$B$20))","v":0}]
[null,null,null,{"$f":"SUM(D18:D20)","v":0},{"$f":"SUM(E18:E20)","v":0},null,null,null,{"$f":"SUM(I18:I20)","v":0},{"$f":"SUM(J18:J20)","v":0},{"$f":"SUM(K18:K20)","v":0},{"$f":"SUM(L18:L20)","v":0},{"$f":"SUM(M18:M20)","v":0}]
[]
[]
[]
["Bonte monoinzameling"]
[null,{"$f":"Netto!D29","v":0},"[kg bruto/jr]",{"$f":"Netto!E29","v":0},"[kg netto/jr]"]
[null,null,null,null,null,null,null,null,null,0.5,0.2,0.1,0.2]
[null,null,null,"Feedstock",null,"Alg Sorteerverlies","Kleur sorteerverlies","Verpakkingsglas pot","Verpakkingsglas echt","Glas bijproduct","Steen, mineralen, opvul","Metaal","plasticafval"]
["Gemiddelde kleurensamenstelling",null,null,"[kg netto/jr]",null,"[%]","[%]","[kg netto/jr]","[kg netto/jr]","[kg netto/jr]","[kg netto/jr]","[kg netto/jr]","[kg netto/jr]"]
["Transparant",0.6,null,{"$f":"D26","v":0},null,0.12,0.1,{"$f":"D30*B30*(100%-F30)","v":0},{"$f":"H30*(100%-G30)","v":0},{"$f":"$D30*$F30*J$27*$B30","v":0},{"$f":"$D30*$F30*K$27*$B30","v":0},{"$f":"$D30*$F30*L$27*$B30","v":0},{"$f":"$D30*$F30*M$27*$B30","v":0}]
["Groen",0.3,null,null,null,0.12,0.1,{"$f":"D30*B31*(100%-F31)","v":0},{"$f":"H31*(100%-G31)","v":0},{"$f":"$D30*$F31*J$27*$B31","v":0},{"$f":"$D30*$F31*K$27*$B31","v":0},{"$f":"$D30*$F31*L$27*$B31","v":0},{"$f":"$D30*$F31*M$27*$B31","v":0}]
["Bruin",0.1,null,null,null,0.12,null,{"$f":"D30*B32*(100%-F32)","v":0},{"$f":"H30*G30+G31*H31+H32","v":0},{"$f":"$D30*$F32*J$27*$B32","v":0},{"$f":"$D30*$F32*K$27*$B32","v":0},{"$f":"$D30*$F32*L$27*$B32","v":0},{"$f":"$D30*$F32*M$27*$B32","v":0}]
[null,null,null,null,null,null,null,null,{"$f":"SUM(I30:I32)","v":0},{"$f":"SUM(J30:J32)","v":0},{"$f":"SUM(K30:K32)","v":0},{"$f":"SUM(L30:L32)","v":0},{"$f":"SUM(M30:M32)","v":0}]

{"sheet":"Metal","index":11,"n_rows":37,"n_cols":25,"rows_kept":37,"cut":false,"hidden":true,"merged":[]}
[null,null,"[kg netto/jaar]"]
["Ferro-metalen verpakkingen in het huisvuil",{"$f":"Feed!B39/(Feed!B39+Feed!B40)","v":0.74848431925351155},{"$f":"Netto!D7*B2","v":0}]
["Non-Ferro metalen verpakkingen in het huisvuil",{"$f":"100%-B2","v":0.25151568074648845},{"$f":"Netto!D7*B3","v":0},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Uit Rm geschat met 5% verlies"]
[]
["Nascheidingsrendementen uit bodemas, TNO rapport Gijlswijk en Ansems 2014",null,"[kg netto/jaar]","Verlies","vervolg",null,null,null,null,null,null,null,null,null,null,"Sorteerproducten NF",null,null,"verdeling",null,"Recovered masses",null,"C(Al) product","C(Al) input","Al-yield"]
["Fe",0.96099999999999997,{"$f":"C2*B6","v":0},{"$f":"C2-C6","v":0},"directe afzet naar een hoogoven, bv Tata",null,null,null,null,null,null,null,null,null,null,"0-15 mm",null,null,0.25,null,0.67500000000000004,null,0.95,{"$f":"U6+5%","v":0.72500000000000009},{"$f":"U6*W6/X6","v":0.88448275862068948}]
["Non-Fe",0.64100000000000001,{"$f":"C3*B7","v":0},{"$f":"C3-C7","v":0},"naar een NF sorteerbedrijf, opwerkbedrijf en dan naar een Aluminiumsmelter",null,null,null,null,null,null,null,null,null,null,">15mm",0.75,"15-25mm",0.6,null,0.9,null,0.95,{"$f":"U7+5%","v":0.95000000000000007},{"$f":"U7*W7/X7","v":0.89999999999999991}]
[null,null,null,null,null,null,null,null,null,null,null,"[kg netto/jr]","verlies",null,null,null,null,">25 mm",0.15,null,0.8,null,0.95,{"$f":"U8+5%","v":0.85000000000000009},{"$f":"U8*W8/X8","v":0.89411764705882346}]
[null,null,null,null,null,null,null,null,null,"Terugwinning Dolphin",null,{"$f":"C7*95%","v":0},{"$f":"C7-L9","v":0},null,null,null,null,null,"gewogen gemiddelde",null,{"$f":"S6*U6+S7*U7+S8*U8","v":0.82874999999999999},null,null,null,{"$f":"S6*Y6+S7*Y7+S8*Y8","v":0.89523833671399577}]
[null,null,null,null,null,null,null,null,null,"Terugwinning Smelterij",null,{"$f":"L9*U9","v":0},{"$f":"L9-L10","v":0}]
[]
["Gescheiden ingezameld",{"$f":"Feed!B12*1000","v":0},"[bruto kg/jr]"]
["Schone metaalverpakkingen",{"$f":"Netto!E30","v":0},"[netto kg/jr]"]
["> Fe metaalverpakkingen",{"$f":"B13*B2","v":0},"[netto kg/jr]"]
["> Al metaalverpakkingen",{"$f":"B13*B3","v":0},"[netto kg/jr]"]
[]
[]
[null,null,null,null,null,null,null,null,null,null,null,"nascheidingsconcentraat Aluminium",null,null,null,"Mbegin",1000,"kg","Rm tot",{"$f":"Q24/Q18","v":0.45}]
[null,null,null,null,null,"Uit bodemas","uit mono-inzameling","uit PMD",null,null,null,"cAl",0.45,null,null,"Mb Al",{"$f":"Q18*M19","v":450},"kg","Rm fijn",{"$f":"T18*25%","v":0.1125}]
["Marktverdeling Ferrometaal via Tata steel hoogoven, geschat",null,null,null,null,"[kg netto/jr]",null,null,null,null,null,null,null,null,null,"Mb rest",{"$f":"Q18-Q19","v":550},"kg","Rm middel",{"$f":"T18*60%","v":0.27}]
["Construction",0.5,0.5,null,null,{"$f":"C21*$C$6","v":0},{"$f":"$B$14*C21","v":0},{"$f":"PMD!$N$17*C21","v":0},null,null,null,null,null,null,null,null,null,null,"Rm grof",{"$f":"T18*15%","v":6.7500000000000004E-2}]
["Automotive",0.05,0.1,null,null,0,0,{"$f":"PMD!$N$17*C22","v":0},null,null,null,"daaruit maak je een Aluminium sorteerproduct"]
["Packaging",0.1,0.15,null,null,0,0,{"$f":"PMD!$N$17*C23","v":0},null,null,null,"cAl",0.95,null,null,"M Al product",{"$f":"Q19-Q27","v":427.5},"kg","Yield Al",{"$f":"(M23*Q24)/(Q18*M19)","v":0.95}]
["Rail",0.2,0,null,null,0,0,{"$f":"PMD!$N$17*C24","v":0},null,null,null,null,null,null,null,"M product totaal",{"$f":"Q23/M23","v":450},"kg"]
["Household appliances -durable goods",0.05,0.1,null,null,0,0,{"$f":"PMD!$N$17*C25","v":0},null,null,null,null,null,null,null,"M veront in product",{"$f":"Q24-Q23","v":22.5},"kg"]
["Excavating equipment",0.05,0.1,null,null,0,0,{"$f":"PMD!$N$17*C26","v":0}]
["Shipbuilding",0.05,0.05,null,null,0,0,{"$f":"PMD!$N$17*C27","v":0},null,null,null,"Met sorteerverlies",null,0.05,null,"M al verlies",{"$f":"Q19*N27","v":22.5},"kg"]
[null,{"$f":"SUM(B21:B27)","v":1.0000000000000002},{"$f":"SUM(C21:C27)","v":1}]
["Op basis van de producten die Tata maakt en de verwachte geschiktheid van schroot daarin"]
[null,null,null,null,null,"Uit bodemas","uit mono-inzameling","uit PMD"]
["Marktverdeling aluminium","EAA 2010","Forest interview","Combinatie",null,"[kg netto/jr]"]
["Construction",0.25,0,0,null,{"$f":"$L$10*D32","v":0},{"$f":"$B$15*D32","v":0},{"$f":"PMD!$N$18*D32","v":0}]
["Transport",0.37,0.9,0.75,null,0,0,{"$f":"PMD!$N$18*D33","v":0}]
["Packaging",0.17,0,0,null,0,0,{"$f":"PMD!$N$18*D34","v":0}]
["Machines",0.14000000000000001,0,0.1,null,0,0,{"$f":"PMD!$N$18*D35","v":0}]
["Misc.",7.0000000000000007E-2,0,0.05,null,0,0,{"$f":"PMD!$N$18*D36","v":0}]
["Desox",null,0.1,0.1,null,0,0,{"$f":"PMD!$N$18*D37","v":0}]

{"sheet":"Plastics","index":12,"n_rows":71,"n_cols":36,"rows_kept":71,"cut":false,"hidden":true,"merged":[]}
["Gescheiden ingezamelde netto-hoeveelheden KST VERP",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Nascheiden KST",null,"aandeel gemeente"]
["mono-inzameling",{"$f":"Netto!B24","v":0},"[kg bruto/jaar]",{"$f":"Netto!E24","v":0},"[kg netto/jr]","PMD bruto",{"$f":"Feed!C13*1000","v":0},"[kg br/jr]",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Logische operator","potentie","Productie namens gemeente, [ton/jaar]"]
["PMD-inzameling",{"$f":"Netto!B25","v":0},"[kg bruto/jaar]",{"$f":"Netto!E25","v":0},"[kg netto/jr]","netto/bruto",{"$f":"IF(B3=0, 0,D3/B3)","v":0},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Nascheiden",{"$f":"Feed!B77","v":0},"[kg bruto]",null,null,"PET fles","PET trays","PE","PP","Film","MP"]
["PD-inzameling",{"$f":"Netto!B26","v":0},"[kg bruto/jaar]",{"$f":"Netto!E26","v":0},"[kg netto/jr]","Bron PMD model",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Omrin",{"$f":"Feed!B78","v":0},{"$f":"Netto!B5*data!B49","v":0},{"$f":"AA4*AB4/1000","v":0},null,{"$f":"AC4*AD11","v":0},{"$f":"AC4*AD12","v":0},{"$f":"AC4*AD13","v":0},{"$f":"AC4*AD14","v":0},{"$f":"AC4*AD15","v":0},{"$f":"AC4*AD16","v":0}]
["Sorteerdata 2014","Sorteren gescheiden ingezamelde kunststofverpakkingen",null,null,null,"Sorteerdata 2017","tov totaal ingezameld gewicht",null,null,null,null,"Data mech recyclen","Mechanisch recyclen van gescheiden ingezamelde kunststofverpakkingen",null,null,null,null,null,null,null,null,null,null,null,null,"Attero-Noord",{"$f":"Feed!B79","v":0},{"$f":"Netto!B5*data!D49","v":0},{"$f":"AA5*AB5/1000","v":0},null,{"$f":"AC5*AE11","v":0},{"$f":"AC5*AE12","v":0},{"$f":"AC5*AE13","v":0},{"$f":"AC5*AE14","v":0},{"$f":"AC5*AE15","v":0},{"$f":"AC5*AE16","v":0}]
[null,"Rm,[%]","cinput,[%]",null,null,2017,"Rm, [%]","Rm-norm PMD","Rm-norm PD",null,null,null,"Rm float,[%]","Rm sink,[%]","Rm sludge, [%]","Rm dis matter, [%]","c intended plastic sorting product,[%]","Recycling opbrengst, [%]",null,null,null,null,null,null,null,"Attero-Wijster",{"$f":"Feed!B80","v":0},{"$f":"Netto!B5*data!E49","v":0},{"$f":"AA6*AB6/1000","v":0},null,{"$f":"AC6*AE11","v":0},{"$f":"AC6*AE12","v":0},{"$f":"AC6*AE13","v":0},{"$f":"AC6*AE14","v":0},{"$f":"AC6*AE15","v":0},{"$f":"AC6*AE16","v":0}]
["PET fles",7.0000000000000007E-2,0.09,null,null,"PET fles",5.5141357767691274E-2,{"$f":"IF(Feed!$B$63=0,Plastics!G7,(Feed!$B$65/Feed!$G$65)*Plastics!G7)","v":5.5141357767691274E-2},null,null,null,"PET",0.11,0.83,0.03,0.03,0.94,0.88,null,null,null,null,null,null,null,"HVC",{"$f":"Feed!B81","v":0},{"$f":"Netto!B5*data!F49","v":0},{"$f":"AA7*AB7/1000","v":0},null,{"$f":"AC7*AF11","v":0},{"$f":"AC7*AF12","v":0},{"$f":"AC7*AF13","v":0},{"$f":"AC7*AF14","v":0},{"$f":"AC7*AF15","v":0},{"$f":"AC7*AF16","v":0}]
["PET schaal",0.08,0.11,null,null,"PET tray",7.0851248073638989E-2,{"$f":"IF(Feed!$B$63=0,Plastics!G8,(Feed!$B$65/Feed!$G$65)*Plastics!G8)","v":7.0851248073638989E-2},null,null,null,"PET trays",0.09,0.85,0.02,0.04,null,null,null,null,null,null,null,null,null,null,null,null,null,"Totaal",{"$f":"SUM(AE4:AE7)","v":0},{"$f":"SUM(AF4:AF7)","v":0},0,0,0,0]
["PE ",0.08,0.11,null,null,"PE",5.0860913758087281E-2,{"$f":"IF(Feed!$B$63=0,Plastics!G9,(Feed!$B$65/Feed!$G$65)*Plastics!G9)","v":5.0860913758087281E-2},null,null,null,"PE ",0.94,0.03,8.0000000000000002E-3,2.1999999999999999E-2,null,null,null,null,null,null,null,null,null,"Sorteerverdeling zonder rest",null,"Attero",null,"Bron: PMD model"]
["PP",0.1,0.13,null,null,"PP",6.5461925757951567E-2,{"$f":"IF(Feed!$B$63=0,Plastics!G10,(Feed!$B$65/Feed!$G$65)*Plastics!G10)","v":6.5461925757951567E-2},null,null,null,"PP",0.9,7.0000000000000007E-2,7.0000000000000001E-3,2.3E-2,null,null,null,null,null,null,null,null,null,null,"Omrin 2015","Nanabron Wijster 2013",null,"Omrin 2017","Attero 2017","HVC"]
["Film",0.21,0.31,null,null,"Film",0.10415175025495345,{"$f":"IF(Feed!$B$63=0,Plastics!G11,(Feed!$B$65/Feed!$G$65)*Plastics!G11)","v":0.10415175025495345},null,null,null,"Film",0.9,0.04,8.0000000000000002E-3,5.1999999999999998E-2,null,null,null,null,null,null,null,null,null,"PET, DKR 328-1",6.2E-2,8.6884065677865649E-2,null,7.5703439035283607E-2,8.842222373907356E-2,4.6931407942238268E-2]
["MP",0.31,0.13,null,null,"MP",0.26145577722591468,{"$f":"IF(Feed!$B$63=0,Plastics!G12,(Feed!$B$65/Feed!$G$65)*Plastics!G12)","v":0.26145577722591468},null,null,null,"MP",0.64,0.32,7.0000000000000001E-3,3.3000000000000002E-2,null,null,null,null,null,null,null,null,null,"PET trays",null,null,null,0.14828048235819563,6.6668241858446262E-2,0.11010830324909747]
["Rest",0.15,0.12,null,null,"DK",7.8387397003955445E-2,{"$f":"IF(Feed!$B$63=0,Plastics!G13,(Feed!$B$67/Feed!$G$67)*Plastics!G13)","v":7.8387397003955445E-2},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"PE, DKR 329",0.11799999999999999,0.10629316911705232,null,6.2527914247431884E-2,8.3264054065249116E-2,3.8507821901323708E-2]
[null,null,null,null,null,"Metalen",7.2099999999999997E-2,{"$f":"IF(Feed!$B$63=0,Plastics!G14,(Feed!$B$66/Feed!$G$66)*Plastics!G14)","v":7.2099999999999997E-2},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"PP, DKR 324",0.11,0.17398744325899893,null,0.13078755396754504,0.13453187925629947,9.1456077015643802E-2]
[null,null,null,null,null,"Rest",{"$f":"100%-SUM(G7:G14)","v":0.24158963015780732},{"$f":"100%-SUM(H7:H14)","v":0.24158963015780732},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Film, DKR 310",0.46500000000000002,0.28000815956828856,null,0.10354324847402115,0.36423976285779464,0.4446450060168472]
[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,"Mix, DKR 350",0.245,0.35282716237779449,null,0.47915736191752273,0.26287383822313704,0.26835138387484958]
["Berekening sorteren","Hoeveelheid gewenste kunststof in de input",null,null,"Hoeveelheid uitgesorteerd product",null,null,null,null,null,null,"Berekening mech recyclen","M drijvend maalgoed",null,null,"M zinkend maalgoed",null,null,"Afval",null,null,"Opgeloste stof"]
[null,"MONO","PMD","PD","Mono","Mono","PMD","PMD","PD","PD",null,null,"Mono","PMD","PD","Mono","PMD","PD","Mono","PMD","PD","Mono","PMD","PD",null,"Data mech recyclen","Mechanisch recyclen van nagescheiden kunststofverpakkingen"]
[null,"[kg bruto/jaar]","[kg bruto/jaar]","[kg bruto/jaar]","[kg bruto/jaar]","[kg netto/jaar]","[kg bruto/jaar]","[kg netto/jaar]","[kg bruto/jaar]","[kg netto/jaar]",null,null,"[kg netto/jaar]",null,null,"[kg maalgoed/jaar]",null,null,"[kg netto/jr]",null,null,"[kg netto/jr]",null,null,null,null,"Rm float,[%]","Rm sink,[%]","Rm sludge, [%]","Rm dis matter, [%]","c intended plastic sorting product,[%]","Recycling opbrengst, [%]"]
["PET",{"$f":"B2*C7","v":0},{"$f":"B7*B3","v":0},{"$f":"B4*B7","v":0},{"$f":"$B$2*B7","v":0},{"$f":"$D$2*B7","v":0},{"$f":"$G$2*H7","v":0},{"$f":"G20*$G$3","v":0},{"$f":"$B$4*B7","v":0},{"$f":"$D$4*B7","v":0},null,"PET",{"$f":"F20*M7","v":0},{"$f":"H20*M7","v":0},{"$f":"J20*M7","v":0},{"$f":"F20*N7","v":0},{"$f":"H20*N7","v":0},{"$f":"J20*N7","v":0},{"$f":"F20*O7","v":0},{"$f":"H20*O7","v":0},{"$f":"J20*O7","v":0},{"$f":"F20*P7","v":0},{"$f":"H20*P7","v":0},{"$f":"J20*P7","v":0},null,"PET",0.1,0.84,0.03,0.03]
["PET trays",{"$f":"B1*C8","v":0},null,null,null,null,0,0,0,0,null,"PET trays",0,0,0,0,0,0,0,0,0,0,0,0,null,"PET trays",0.14000000000000001,0.68,0.06,0.12]
["PE ",{"$f":"B2*C9","v":0},{"$f":"B9*B3","v":0},{"$f":"B4*B9","v":0},{"$f":"$B$2*B9","v":0},{"$f":"$D$2*B9","v":0},0,0,0,0,null,"PE ",0,0,0,0,0,0,0,0,0,0,0,0,null,"PE ",0.93,0.02,0.02,0.03]
["PP",{"$f":"B2*C10","v":0},{"$f":"B3*B10","v":0},{"$f":"B4*B10","v":0},{"$f":"$B$2*B10","v":0},{"$f":"$D$2*B10","v":0},0,0,0,0,null,"PP",0,0,0,0,0,0,0,0,0,0,0,0,null,"PP",0.83,0.03,0.06,0.08]
["Film",{"$f":"B2*C11","v":0},{"$f":"B3*B11","v":0},{"$f":"B4*B11","v":0},{"$f":"$B$2*B11","v":0},{"$f":"$D$2*B11","v":0},0,0,0,0,null,"Film",0,0,0,0,0,0,0,0,0,0,0,0,null,"Film",0.83,0.04,0.03,0.1]
["MP",{"$f":"B2*C12","v":0},{"$f":"B3*B12","v":0},{"$f":"B4*B12","v":0},{"$f":"$B$2*B12","v":0},{"$f":"$D$2*B12","v":0},0,0,0,0,null,"MP",0,0,0,0,0,0,0,0,0,0,0,0,null,"MP",0.65,0.28000000000000003,0.04,0.03]
["TOTAAL",{"$f":"SUM(B20:B25)","v":0},0,0,0,0,0,0,0,0,null,"TOTAAL",{"$f":"SUM(M20:M25)","v":0},0,0,0,0,0,0,0,0,0,0,0]
[]
[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,"Berekening mech recyclen","Hoeveelheid drijvend maalgoed",null,null,null,"Hoeveelheid zinkend maalgoed",null,null,"Afval","Opgeloste stof"]
[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,"[kg netto/jaar]",null,null,null,"[kg maalgoed/jaar]",null,null,"[kg netto/jr]","[kg netto/jr]"]
["Geschatte marktverdelingen voor kunststofhergebruik",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"PET fles",{"$f":"AA20*$AE$8*1000","v":0},null,null,null,{"$f":"AB20*$AE$8*1000","v":0},null,null,{"$f":"AC20*$AE$8*1000","v":0},{"$f":"AD20*$AE$8*1000","v":0}]
[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,"PET schaal",{"$f":"AF8*AA21*1000","v":0},null,null,null,{"$f":"AF8*AB21*1000","v":0},null,null,{"$f":"AF8*AC21*1000","v":0},{"$f":"AD21*AF8*1000","v":0}]
["PET fles","GI, [%]","NA, [%]",null,"PE","GI, [%]","NA, [%]",null,"PP","GI, [%]","NA, [%]",null,"Folie","GI, [%]","NA, [%]",null,"MP","GI, [%]","NA, [%]",null,"PET trays","GI, [%]","NA, [%]",null,null,"PE ",{"$f":"AA22*AG8*1000","v":0},null,null,null,{"$f":"AB22*AG8*1000","v":0},null,null,{"$f":"AC22*AG8*1000","v":0},{"$f":"AD22*AG8*1000","v":0}]
["Flessen",0.1,0,null,"Kabelomhulling",0.2,0.3,null,"Bloempotten",0.5,0.6,null,"Tuinmeubelen",0.1,0.1,null,"Speeltoestellen",0.1,0.1,null,"Trays",0.9,0.9,null,null,"PP",{"$f":"AA23*AH8*1000","v":0},null,null,null,{"$f":"AB23*AH8*1000","v":0},null,null,{"$f":"AC23*AH8*1000","v":0},{"$f":"AD23*AH8*1000","v":0}]
["Trays",0.6,0.6,null,"Afvoerpijpen",0.3,0.3,null,"Kratten",0.2,0.2,null,"Afvoerpijpen",0.4,0.5,null,"Verkeersafscheiders",0.1,0.1,null,"Strapping",0.1,0.1,null,null,"Film",{"$f":"AA24*AI8*1000","v":0},null,null,null,{"$f":"AB24*AI8*1000","v":0},null,null,{"$f":"AC24*AI8*1000","v":0},{"$f":"AD24*AI8*1000","v":0}]
["Fleece",0.1,0.1,null,"Rolkernen",0.2,0.2,null,"Boombekisting",0.15,0.2,null,"Rijplaten",0.4,0.2,null,"Oeverbeschoeiing",0.1,0.1,null,null,null,null,null,null,"MP",{"$f":"AA25*AJ8*1000","v":0},null,null,null,{"$f":"AB25*AJ8*1000","v":0},null,null,{"$f":"AC25*AJ8*1000","v":0},{"$f":"AD25*AJ8*1000","v":0}]
["Strapping",0.2,0.3,null,"Rijplaten",0.2,null,null,"Apparaatbehuizing",0.05,0,null,"Speeltoestellen",0.1,0.2,null,"Steigers plastic lumber",0.3,0.5,null,null,null,null,null,null,"TOTAAL",{"$f":"SUM(AA30:AA35)","v":0},null,null,null,{"$f":"SUM(AE30:AE35)","v":0},null,null,{"$f":"SUM(AH30:AH35)","v":0},{"$f":"SUM(AI30:AI35)","v":0}]
[null,null,null,null,"Afvalcontainers",0.09,0.2,null,"Pallets",0.1,null,null,null,null,null,null,"Pallets",0.2,0.2,null,null,null,null,null,null,"De nascheidingsberekening is gedaan op basis van het percentage kunststof (verpakkingen + niet-verpakkingen)"]
[null,null,null,null,"Non-food flacons",0.01,0,null,null,null,null,null,null,null,null,null,"Bouwemmers, speciekuipen",0.2,null,null,null,null,null,null,null,"Dus om terug te rekenen naar alleen verpakkingen moet er worden gecorrigeerd, hiervoor nemen we het gehalte in gescheiden ingezamelde verpakkingen want dit scheelt niet veel."]
["PO-mix uit PET als drijvend bijproduct",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Correctiefactor verpakkingen",null,{"$f":"data!B28","v":0.89}]
[null,"GI, [%]","NA, [%]",null,"PE-zink",null,null,null,"PP-zink",null,null,null,"Folie-zink",null,null,null,"Zinkend bijproduct uit MP"]
["Plastic lumber",1,1,null,"Brandstof",1,null,null,"Brandstof",1,null,null,"Brandstof",1,null,null,null,"GI, [%]","NA, [%]"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Asfalttoeslagstof",1,1]
["Namens deze gemeente hergebruikte artikelen uit mono-inzameling",null,null,null,null,null,null,null,"Namens deze gemeente hergebruikte artikelen uit PMD-inzameling",null,null,null,null,null,null,null,"Namens deze gemeente hergebruikte artikelen uit PD-inzameling",null,null,null,null,null,null,null,null,"Namens deze gemeente hergebruikte artikelen","Alleen verpakkingen","Verpakkingen en niet-verpakkingen"]
[null,"Materiaalhergebruik","Nuttige toepassing",null,"Materiaalhergebruik",null,null,null,null,"Materiaalhergebruik","Nuttige toepassing",null,"Materiaalhergebruik",null,null,null,null,"Materiaalhergebruik","Nuttige toepassing",null,"Materiaalhergebruik",null,null,null,null,null,"Materiaalhergebruik","Materiaalhergebruik","Nuttige toepassing",null,"Materiaalhergebruik"]
["Toepassingen","[kg netto/jr]","[kg netto/jr]",null,"[kg net/cap.a]",null,null,null,"Toepassingen","[kg netto/jr]","[kg netto/jr]",null,"[kg net/cap.a]",null,null,null,"Toepassingen","[kg netto/jr]","[kg netto/jr]",null,"[kg net/cap.a]",null,null,null,null,"Toepassingen","[kg netto/jr]","[kg netto/jr]","[kg netto/jr]",null,"[kg net/cap.a]"]
["Flessen",{"$f":"B33*$P$20","v":0},null,null,{"$f":"B46/Feed!$B$2","v":{"$error":"#DIV/0!"}},null,"PET bottles",null,null,{"$f":"B33*$Q$20","v":0},null,null,{"$f":"J46/Feed!$B$2","v":{"$error":"#DIV/0!"}},null,null,null,null,{"$f":"B33*$R$20","v":0},null,null,{"$f":"R46/Feed!$B$2","v":{"$error":"#DIV/0!"}},null,null,null,null,{"$f":"A46","v":"Flessen"},{"$f":"$AB$39*AB46","v":0},{"$f":"$AE$30*C33","v":0}]
["Trays",{"$f":"B34*$P$20+P21*V33","v":0},null,null,{"$f":"B47/Feed!$B$2","v":{"$error":"#DIV/0!"}},null,"PET trays",null,null,{"$f":"B34*$Q$20+V33*Q21","v":0},null,null,{"$f":"J47/Feed!$B$2","v":{"$error":"#DIV/0!"}},null,null,null,null,{"$f":"B34*$R$20+R21*V33","v":0},null,null,{"$f":"R47/Feed!$B$2","v":{"$error":"#DIV/0!"}},null,null,null,null,"Trays",0,{"$f":"$AE$30*C34+AE31*W33","v":0}]
["Fleece",{"$f":"B35*$P$20","v":0},null,null,{"$f":"B48/Feed!$B$2","v":{"$error":"#DIV/0!"}},null,"PET fibres",null,null,{"$f":"B35*$Q$20","v":0},null,null,{"$f":"J48/Feed!$B$2","v":{"$error":"#DIV/0!"}},null,null,null,null,{"$f":"B35*$R$20","v":0},null,null,{"$f":"R48/Feed!$B$2","v":{"$error":"#DIV/0!"}},null,null,null,null,"Fleece",0,{"$f":"$AE$30*C35","v":0}]
["Strapping",{"$f":"B36*$P$20+P21*V34","v":0},null,null,{"$f":"B49/Feed!$B$2","v":{"$error":"#DIV/0!"}},null,"PET strapping",null,null,{"$f":"B36*$Q$20+Q21*V34","v":0},null,null,{"$f":"J49/Feed!$B$2","v":{"$error":"#DIV/0!"}},null,null,null,null,{"$f":"B36*$R$20+R21*V34","v":0},null,null,{"$f":"R49/Feed!$B$2","v":{"$error":"#DIV/0!"}},null,null,null,null,"Strapping",0,{"$f":"$AE$30*C36+W34*AE31","v":0}]
[{"$f":"E33","v":"Kabelomhulling"},{"$f":"F33*$M$22","v":0},null,null,{"$f":"B50/Feed!$B$2","v":{"$error":"#DIV/0!"}},null,"Cable liner",null,null,{"$f":"F33*$N$22","v":0},null,null,{"$f":"J50/Feed!$B$2","v":{"$error":"#DIV/0!"}},null,null,null,null,{"$f":"F33*$O$22","v":0},null,null,{"$f":"R50/Feed!$B$2","v":{"$error":"#DIV/0!"}},null,null,null,null,"Kabelomhulling",0,{"$f":"$AA$32*G33","v":0}]
["Afvoerpijpen",{"$f":"F34*$M$22+$M$24*N34","v":0},null,null,{"$f":"B51/Feed!$B$2","v":{"$error":"#DIV/0!"}},null,"Drainage pipes",null,null,{"$f":"F34*$N$22+$N$24*N34","v":0},null,null,{"$f":"J51/Feed!$B$2","v":{"$error":"#DIV/0!"}},null,null,null,null,{"$f":"F34*$O$22+$O$24*N34","v":0},null,null,{"$f":"R51/Feed!$B$2","v":{"$error":"#DIV/0!"}},null,null,null,null,"Afvoerpijpen",0,{"$f":"$AA$32*G34+AA34*O34","v":0}]
["Rolkernen",{"$f":"F35*$M$22","v":0},null,null,{"$f":"B52/Feed!$B$2","v":{"$error":"#DIV/0!"}},null,"Roll tubes",null,null,{"$f":"F35*$N$22","v":0},null,null,{"$f":"J52/Feed!$B$2","v":{"$error":"#DIV/0!"}},null,null,null,null,{"$f":"F35*$O$22","v":0},null,null,{"$f":"R52/Feed!$B$2","v":{"$error":"#DIV/0!"}},null,null,null,null,"Rolkernen",0,{"$f":"$AA$32*G35","v":0}]
["Rijplaten",{"$f":"$M$24*N35+F36*$M$22","v":0},null,null,{"$f":"B53/Feed!$B$2","v":{"$error":"#DIV/0!"}},null,"Road plates",null,null,{"$f":"$N$24*N35+F36*$N$22","v":0},null,null,{"$f":"J53/Feed!$B$2","v":{"$error":"#DIV/0!"}},null,null,null,null,{"$f":"$O$24*N35+F36*$O$22","v":0},null,null,{"$f":"R53/Feed!$B$2","v":{"$error":"#DIV/0!"}},null,null,null,null,"Rijplaten",0,{"$f":"$AA$32*G36+AA34*O35","v":0}]
["Afvalcontainers",{"$f":"F37*$M$22","v":0},null,null,{"$f":"B54/Feed!$B$2","v":{"$error":"#DIV/0!"}},null,"Waste containers",null,null,{"$f":"F37*$N$22","v":0},null,null,{"$f":"J54/Feed!$B$2","v":{"$error":"#DIV/0!"}},null,null,null,null,{"$f":"F37*$O$22","v":0},null,null,{"$f":"R54/Feed!$B$2","v":{"$error":"#DIV/0!"}},null,null,null,null,"Afvalcontainers",0,{"$f":"$AA$32*G37","v":0}]
["Non-food flacons",{"$f":"F38*$M$22","v":0},null,null,{"$f":"B55/Feed!$B$2","v":{"$error":"#DIV/0!"}},null,"Non-food bottles",null,null,{"$f":"F38*$N$22","v":0},null,null,{"$f":"J55/Feed!$B$2","v":{"$error":"#DIV/0!"}},null,null,null,null,{"$f":"F38*$O$22","v":0},null,null,{"$f":"R55/Feed!$B$2","v":{"$error":"#DIV/0!"}},null,null,null,null,"Non-food flacons",0,{"$f":"$AA$32*G38","v":0}]
[{"$f":"I33","v":"Bloempotten"},{"$f":"$M$23*J33","v":0},null,null,{"$f":"B56/Feed!$B$2","v":{"$error":"#DIV/0!"}},null,"Flower trays",null,null,{"$f":"$N$23*J33","v":0},null,null,{"$f":"J56/Feed!$B$2","v":{"$error":"#DIV/0!"}},null,null,null,null,{"$f":"$O$23*J33","v":0},null,null,{"$f":"R56/Feed!$B$2","v":{"$error":"#DIV/0!"}},null,null,null,null,"Bloempotten",0,{"$f":"$AA$33*K33","v":0}]
[{"$f":"I34","v":"Kratten"},{"$f":"$M$23*J34","v":0},null,null,{"$f":"B57/Feed!$B$2","v":{"$error":"#DIV/0!"}},null,"Crates",null,null,{"$f":"$N$23*J34","v":0},null,null,{"$f":"J57/Feed!$B$2","v":{"$error":"#DIV/0!"}},null,null,null,null,{"$f":"$O$23*J34","v":0},null,null,{"$f":"R57/Feed!$B$2","v":{"$error":"#DIV/0!"}},null,null,null,null,"Kratten",0,{"$f":"$AA$33*K34","v":0}]
[{"$f":"I35","v":"Boombekisting"},{"$f":"$M$23*J35","v":0},null,null,{"$f":"B58/Feed!$B$2","v":{"$error":"#DIV/0!"}},null,"Tree crates",null,null,{"$f":"$N$23*J35","v":0},null,null,{"$f":"J58/Feed!$B$2","v":{"$error":"#DIV/0!"}},null,null,null,null,{"$f":"$O$23*J35","v":0},null,null,{"$f":"R58/Feed!$B$2","v":{"$error":"#DIV/0!"}},null,null,null,null,"Boombekisting",0,{"$f":"$AA$33*K35","v":0}]
[{"$f":"I36","v":"Apparaatbehuizing"},{"$f":"$M$23*J36","v":0},null,null,{"$f":"B59/Feed!$B$2","v":{"$error":"#DIV/0!"}},null,"Appliances",null,null,{"$f":"$N$23*J36","v":0},null,null,{"$f":"J59/Feed!$B$2","v":{"$error":"#DIV/0!"}},null,null,null,null,{"$f":"$O$23*J36","v":0},null,null,{"$f":"R59/Feed!$B$2","v":{"$error":"#DIV/0!"}},null,null,null,null,"Apparaatbehuizing",0,{"$f":"$AA$33*K36","v":0}]
[{"$f":"I37","v":"Pallets"},{"$f":"$M$23*J37+R37*$M$25","v":0},null,null,{"$f":"B60/Feed!$B$2","v":{"$error":"#DIV/0!"}},null,"Pallets",null,null,{"$f":"$N$23*J37+R37*$N$25","v":0},null,null,{"$f":"J60/Feed!$B$2","v":{"$error":"#DIV/0!"}},null,null,null,null,{"$f":"$O$23*J37+R37*$O$25","v":0},null,null,{"$f":"R60/Feed!$B$2","v":{"$error":"#DIV/0!"}},null,null,null,null,"Pallets",0,{"$f":"$AA$33*K37+S37*AA35","v":0}]
[{"$f":"M33","v":"Tuinmeubelen"},{"$f":"$M$24*N33","v":0},null,null,{"$f":"B61/Feed!$B$2","v":{"$error":"#DIV/0!"}},null,"Garden furniture",null,null,{"$f":"$N$24*N33","v":0},null,null,{"$f":"J61/Feed!$B$2","v":{"$error":"#DIV/0!"}},null,null,null,null,{"$f":"$O$24*N33","v":0},null,null,{"$f":"R61/Feed!$B$2","v":{"$error":"#DIV/0!"}},null,null,null,null,"Tuinmeubelen",0,{"$f":"AA34*O33","v":0}]
[{"$f":"M36","v":"Speeltoestellen"},{"$f":"$M$24*N36+R33*M25","v":0},null,null,{"$f":"B62/Feed!$B$2","v":{"$error":"#DIV/0!"}},null,"Play sets",null,null,{"$f":"$N$24*N36+R33*N25","v":0},null,null,{"$f":"J62/Feed!$B$2","v":{"$error":"#DIV/0!"}},null,null,null,null,{"$f":"$O$24*N36+R33*O25","v":0},null,null,{"$f":"R62/Feed!$B$2","v":{"$error":"#DIV/0!"}},null,null,null,null,"Speeltoestellen",0,{"$f":"O36*AA34+S33*AA35","v":0}]
[{"$f":"Q34","v":"Verkeersafscheiders"},{"$f":"R34*$M$25","v":0},null,null,{"$f":"B63/Feed!$B$2","v":{"$error":"#DIV/0!"}},null,"Traffic dividers",null,null,{"$f":"R34*$N$25","v":0},null,null,{"$f":"J63/Feed!$B$2","v":{"$error":"#DIV/0!"}},null,null,null,null,{"$f":"R34*$O$25","v":0},null,null,{"$f":"R63/Feed!$B$2","v":{"$error":"#DIV/0!"}},null,null,null,null,"Verkeersafscheiders",0,{"$f":"$AA$35*S34","v":0}]
[{"$f":"Q35","v":"Oeverbeschoeiing"},{"$f":"R35*$M$25","v":0},null,null,{"$f":"B64/Feed!$B$2","v":{"$error":"#DIV/0!"}},null,"Embankment",null,null,{"$f":"R35*$N$25","v":0},null,null,{"$f":"J64/Feed!$B$2","v":{"$error":"#DIV/0!"}},null,null,null,null,{"$f":"R35*$O$25","v":0},null,null,{"$f":"R64/Feed!$B$2","v":{"$error":"#DIV/0!"}},null,null,null,null,"Oeverbeschoeiing",0,{"$f":"$AA$35*S35","v":0}]
[{"$f":"Q36","v":"Steigers plastic lumber"},{"$f":"R36*$M$25+M20*B41","v":0},null,null,{"$f":"B65/Feed!$B$2","v":{"$error":"#DIV/0!"}},null,"Plastic lumber",null,null,{"$f":"R36*$N$25+N20*B41","v":0},null,null,{"$f":"J65/Feed!$B$2","v":{"$error":"#DIV/0!"}},null,null,null,null,{"$f":"R36*$O$25+O20*B41","v":0},null,null,{"$f":"R65/Feed!$B$2","v":{"$error":"#DIV/0!"}},null,null,null,null,"Steigers plastic lumber",0,{"$f":"$AA$35*S36+AA30*C41","v":0}]
[{"$f":"Q38","v":"Bouwemmers, speciekuipen"},{"$f":"R38*$M$25","v":0},null,null,{"$f":"B66/Feed!$B$2","v":{"$error":"#DIV/0!"}},null,"Mortar tubs",null,null,{"$f":"R38*$N$25","v":0},null,null,{"$f":"J66/Feed!$B$2","v":{"$error":"#DIV/0!"}},null,null,null,null,{"$f":"R38*$O$25","v":0},null,null,{"$f":"R66/Feed!$B$2","v":{"$error":"#DIV/0!"}},null,null,null,null,"Bouwemmers, speciekuipen",0,{"$f":"AA35*S38","v":0}]
["Asfalttoeslagstof",null,{"$f":"R42*P25","v":0},null,{"$f":"B67/Feed!$B$2","v":{"$error":"#DIV/0!"}},null,null,null,"Asfalttoeslagstof",null,{"$f":"R42*Q25","v":0},null,null,null,null,null,"Asfalttoeslagstof",null,{"$f":"R42*R25","v":0},null,null,null,null,null,null,"Asfalttoeslagstof",null,null,{"$f":"AE35*S42","v":0}]
["Brandstof",null,{"$f":"F41*P22+J41*P23+N41*P24","v":0},null,{"$f":"B68/Feed!$B$2","v":{"$error":"#DIV/0!"}},null,null,null,"Brandstof",null,{"$f":"F41*Q22+J41*Q23+N41*Q24","v":0},null,null,null,null,null,"Brandstof",null,{"$f":"F41*R22+J41*R23+N41*R24","v":0},null,null,null,null,null,null,"Brandstof",null,null,{"$f":"AE32*F41+AE33*J41+AE34*N41","v":0}]
[]
[]
["Totaal",{"$f":"SUM(B46:B68)","v":0},{"$f":"SUM(C46:C68)","v":0},null,{"$f":"SUM(E46:E68)","v":{"$error":"#DIV/0!"}},null,null,null,"Totaal",{"$f":"SUM(J46:J68)","v":0},{"$f":"SUM(K46:K68)","v":0},null,{"$f":"SUM(M46:M68)","v":{"$error":"#DIV/0!"}},null,null,null,"Totaal",{"$f":"SUM(R46:R68)","v":0},{"$f":"SUM(S46:S68)","v":0},null,{"$f":"SUM(U46:U68)","v":{"$error":"#DIV/0!"}},null,null,null,null,{"$f":"A71","v":"Totaal"},{"$f":"SUM(AA46:AA70)","v":0},{"$f":"SUM(AB46:AB70)","v":0},{"$f":"SUM(AC46:AC70)","v":0}]

{"sheet":"BC","index":13,"n_rows":67,"n_cols":17,"rows_kept":67,"cut":false,"hidden":true,"merged":[[5,1,6,1],[5,2,6,2],[5,5,6,5],[5,8,6,8]]}
["Logische functie gescheiden inzameling",null,{"$f":"Feed!B11","v":0}]
["Logische functie PMD",null,{"$f":"IF(Invullen!C19=\"\",0,Invullen!C19)","v":0},null,null,null,null,null,null,null,"Bij berekening eerst een check of men zelf weet wat de samenstelling van het gescheiden ingezamelde DK-materiaal is in materiaalsoorten."]
[null,null,null,null,null,null,null,null,null,null,"Zo nee, dan  de default kiezen"]
[null,null,null,null,null,null,null,null,null,null,null,"Zelf invoeren","Default","Default","Default","Default"]
[null,"Tabel met opbrengsten uit het concise report",null,null,null,null,null,null,null,null,"Invulscherm","bruto-%","mono","PD","PMD","Na K+DK"]
[null,null,"Separate collection","Co-coll. w/plastic","Co-coll. w/plastic","Co-coll. w/P&B","Recovery","Recovery",null,null,"Drankenkartons",null,{"$f":"SUM(C18:C24)","v":0.87020317353853271},{"$f":"SUM(D18:D24)","v":0.17387387151170239},0.19,{"$f":"SUM(E18:E24)","v":0.23284051338654427}]
[null,null,null,"KH","MZ",null,"Attero","Omrin",null,null,"Kunststofverpakkingen",null,{"$f":"C26*(100%-C33)","v":2.0475242630896954E-2},{"$f":"D26*(100%-D33)","v":0.59641055314855018},0.51,{"$f":"E26*(100%-E33)","v":0.43767029060491841}]
[null,"Collecting*",0.2,0.31,0.99,0.28000000000000003,"100% α","100%α","ηc.",null,"Metaalverpakkingen",null,{"$f":"C29*(100%-C34)","v":2.6008110083922103E-3},{"$f":"D29*(100%-D34)","v":9.3874824050616205E-3},0.14000000000000001,{"$f":"E29*(100%-E34)","v":9.2242532627761654E-3}]
[null,"Recovering","na","na","na","na",0.87,0.79,"ηr.",null,"Oud-papier en karton",null,{"$f":"C25","v":8.1845499625035678E-2},{"$f":"D25","v":8.2997317882446478E-2},5.5E-2,{"$f":"E25","v":0.10252887960765338}]
[null,"Sorting","na",0.39,0.55000000000000004,"~50%",0.51,"80%β","ηs.",null,"Glas",null,{"$f":"C30","v":5.7723974000594824E-3},{"$f":"D30","v":1.128313875930053E-3},5.0000000000000001E-3,{"$f":"E30","v":2.3039110353313856E-4}]
[null,"Recycling fibres",0.8,0.9,0.85,"~85%",0.86,0.99,"ηf",null,"Textiel",null,{"$f":"C28","v":7.256158247017163E-4},{"$f":"D28","v":1.2143613523450645E-2},0.01,{"$f":"E28","v":5.6191295973273096E-2}]
[null,"Recycling by-products",0.95,0.89,0.95,0.95,0.9,0.93,"ηb",null,"Metaal niet-verpakkingen",null,{"$f":"C29*C34","v":9.1379846240807392E-4},{"$f":"D29*D34","v":3.2983046288054345E-3},0.01,{"$f":"E29*E34","v":3.2409538490835174E-3}]
[null,"TOTAL fibres","16±23%","11±55%","46±20%","11±29%","38±27%","63±26%","ηc*ηr*ηs*ηf",null,"Kunststof niet-verpakkingen",null,{"$f":"C26*C33","v":2.2750269589885508E-3},{"$f":"D26*D33","v":8.8331758158625692E-2},0.05,{"$f":"E26*E33","v":4.594329017399696E-2}]
[null,"TOTAL by-products",0.19,0.11,0.52,0.13,0.4,0.59,"ηc*ηr*ηs*ηb",null,"Organisch en ondefinieerbaar",null,{"$f":"C27","v":1.5188434550984602E-2},{"$f":"D27","v":3.2428784865427621E-2},0.03,{"$f":"BC!E27","v":0.11213013203822089}]
[null,null,null,null,null,null,null,null,null,null,"Totaal",null,{"$f":"SUM(M6:M14)","v":1},{"$f":"SUM(N6:N14)","v":1},{"$f":"SUM(O6:O14)","v":1},{"$f":"SUM(P6:P14)","v":0.99999999999999989}]
[]
[null,"Gemiddelde materiaalsamenstelling drankenkartonstromen bij pilot drankenkartons","Gescheiden inzameling","Kunststof+DK inzameling","nascheiding HK+DK"]
[null,"Karton",0.42661068431971921,9.0985151895555547E-2,0.10660164579615061,null,null,null,null,null,"Dan kiezen uit inzamelsysteem"]
[null,"Alu.",1.1340821238157477E-2,2.8397984427805676E-3,3.3444583885977141E-3,null,null,null,null,null,"Vermenigvuldig samenstelling drankenkartons netto met vezelrendement en je hebt de vezelopbrengst"]
[null,"PE-folie",8.9296704166849622E-2,1.9581779984399895E-2,2.2814708080490624E-2,null,null,null,null,null,"Vermenigvuldig samenstelling drankenkartons netto met bijproductrendement en je hebt de hoeveelheid bijproducten"]
[null,"PE VV ",3.678846677766634E-2,7.6503126116934626E-3,9.0429644819932393E-3]
[null,"PP VV",6.7007527318468599E-3,1.5308240149101572E-3,1.7329416809717185E-3]
[null,"PP folie",8.5314152481599765E-5,3.7978391670520338E-5,7.2290851576628753E-5]
[null,"vocht en vuil",0.29938043015181165,5.1248026170692233E-2,8.923150410676374E-2,null,null,null,null,null,"FKN uit co-inzameling Sita","Netto DK",0.78800000000000003,null,"Net fibre content",null,{"$f":"M26+M24*D18/SUM(D18:D23)","v":0.58667527375095818}]
[null,"OPK",8.1845499625035678E-2,8.2997317882446478E-2,0.10252887960765338,null,null,null,null,null,null,"LAMD",0.2,null,"Net byproduct content",null,{"$f":"M27+M24*(SUM(D19:D23)/SUM(D18:D23))","v":0.21332472624904184}]
[null,"Kunststof",2.2750269589885505E-2,0.68474231130717589,0.48361358077891536,null,null,null,null,null,null,"OPK",2E-3]
[null,"organisch",1.5188434550984602E-2,3.2428784865427621E-2,0.11213013203822089,null,null,null,null,null,null,"Restafval",0.01]
[null,"textiel",7.256158247017163E-4,1.2143613523450645E-2,5.6191295973273096E-2]
[null,"metaal",3.5146094708002843E-3,1.2685787033867055E-2,1.2465207111859682E-2]
[null,"glas",5.7723974000594824E-3,1.128313875930053E-3,2.3039110353313856E-4]
[]
[null,"Verdeelfactoren NVP/(VP+NVP)"]
[null,"Kunststof",0.1,0.129,9.5000000000000001E-2]
[null,"Metaal",0.26,0.26,0.26]
[]
[]
[]
["Nascheiden van drankenkartons"]
["Hoeveelheid drankenkartons in het restafval",null,null,{"$f":"Netto!C8","v":0},"[kg bruto/jaar]"]
["Nascheidingsrendement",null,null,0.6]
["Nascheidingspotentie",null,null,{"$f":"D39*D40","v":0},"[kg bruto/jaar]"]
["Sorteerrendement",null,null,0.75]
["Potentie aan DKR 510 FKN",null,null,{"$f":"D41*D42","v":0},"[kg bruto/jaar]",null,"Net fibre content",null,0.46600000000000003,"Uit pilot drankenkartons",null,"Getallen zijn op bruto gebaseerd"]
["Netto-potentie aan DKR 510 FKN",null,null,{"$f":"D43*(100%-data!G24)","v":0},"[kg netto/jaar]",null,"Net byproduct content",null,0.182]
["Vezelopbrengst",null,null,0.98,null,{"$f":"D43*D45*I43","v":0},"[kg netto/jaar]"]
["Bijproductenopbrengst",null,null,{"$f":"92%","v":0.92},null,{"$f":"D43*D46*I44","v":0},"[kg netto/jaar]"]
[]
[]
[]
["Mono-inzameling van drankenkartons"]
["Hoeveelheid mono-inzameling",null,null,{"$f":"Feed!B11","v":0},"[ton bruto/jaar]"]
["Netto-inhoud aan vezels",null,null,{"$f":"(C18+C25)*D51","v":0},"[ton netto/jaar]"]
["Netto-inhoud aan bijproducten",null,null,{"$f":"(C19+C20+C21+C22+C23+C26+C29+C30)*D51","v":0},{"$f":"(C19+C20+C21+C22+C23+C26+C29+C30)","v":0.17624933552774713}]
["Vezelopbrengst",null,null,0.8,null,{"$f":"D54*D52*1000","v":0},"[kg netto/jaar]"]
["Bijproductenopbrengst",null,null,0.95,null,{"$f":"D55*D53*1000","v":0},"[kg netto/jaar]"]
[]
[]
[]
[null,"Uit de studie Evaluatie Drankenkartons 2016"]
[]
[null,"Netto-materiaalrendementen"]
[]
[null,"Inzameling","nascheiden","Sorteren","Recyclen"]
["Mono BC",0.28000000000000003,null,null,0.85]
["PD",0.31,null,0.73,0.81]
["PMD",0.4,null,0.73,0.81]
["Na",1,0.56999999999999995,0.75,0.89]

{"sheet":"PMD","index":14,"n_rows":39,"n_cols":15,"rows_kept":39,"cut":false,"hidden":true,"merged":[]}
["Brutohoeveelheden ingezameld PMD"]
[]
["KST",{"$f":"Netto!B25","v":0},"[kg bruto/jr]"]
["MET",{"$f":"Netto!B31","v":0}]
["DK",{"$f":"Netto!B33","v":0}]
["REST",{"$f":"B7-SUM(B3:B5)","v":0}]
["Totaal",{"$f":"Feed!B13*1000","v":0}]
[]
[]
[null,"Bruto BC,[kg/jaar]",null,null,null,null,"Bruto BC"]
["DK",{"$f":"B5","v":0},"[kg bruto/jaar]",0.80500000000000005,"Sorteerefficientie uit aanvullende rapportage DKS 2014",null,{"$f":"B11*D11","v":0},"[kg bruto/jaar]","Vezelinhoud",{"$f":"BC!Q24","v":0.58667527375095818},{"$f":"J11*G11","v":0},"Vezelopbrengst",0.87,{"$f":"K11*M11","v":0},"[kg vezels ds]"]
[null,null,null,null,null,null,null,null,"Bijproductinhoud",{"$f":"BC!Q25","v":0.21332472624904184},{"$f":"G11*J12","v":0},"Bijproductopbrengst",0.92,{"$f":"K12*M12","v":0},"[kg bijproducten ds]"]
[]
[]
[]
[null,null,null,null,null,null,"Bruto totaal metaal"]
["MET",{"$f":"B4","v":0},"[kg bruto/jaar]",0.77,"Sorteerefficiëntie",null,{"$f":"B17*D17","v":0},"[kg bruto/jaar]","FE",{"$f":"Metal!B2","v":0.74848431925351155},{"$f":"G17*J17","v":0},"[kg bruto/jaar]",null,{"$f":"K17*(100%-data!$H$30)","v":0},"[kg netto/jaar]"]
[null,null,null,null,null,null,null,null,"NFE",{"$f":"Metal!B3","v":0.25151568074648845},{"$f":"G17*J18","v":0},"[kg bruto/jaar]",null,{"$f":"K18*(100%-data!$H$30)","v":0},"[kg netto/jaar]"]
[null,null,null,"10% verlies vanwege PMD vervuiling"]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
["Brutohoeveelheden ingezameld PD"]
[null,"[kg bruto/jr]"]
["KST",{"$f":"Netto!B26","v":0}]
["DK",{"$f":"Netto!B34","v":0}]
["REST",{"$f":"B35-B32-B33","v":0}]
["Totaal",{"$f":"Feed!B14*1000","v":0}]
[]
[null,"Bruto BC,[kg/jaar]",null,null,null,null,"Bruto BC"]
["DK",{"$f":"B33","v":0},"[kg bruto/jaar]",0.80500000000000005,"Sorteerefficientie uit aanvullende rapportage DKS 2014",null,{"$f":"B38*D38","v":0},"[kg bruto/jaar]","Vezelinhoud",{"$f":"BC!Q24","v":0.58667527375095818},{"$f":"J38*G38","v":0},"Vezelopbrengst",0.87,{"$f":"K38*M38","v":0},"[kg vezels ds]"]
[null,null,null,null,null,null,null,null,"Bijproductinhoud",{"$f":"BC!Q25","v":0.21332472624904184},{"$f":"G38*J39","v":0},"Bijproductopbrengst",0.92,{"$f":"K39*M39","v":0},"[kg bijproducten ds]"]

{"sheet":"D","index":15,"n_rows":47,"n_cols":7,"rows_kept":47,"cut":false,"hidden":true,"merged":[]}
["RVO, Mei 2013, Samenstelling van het huishoudelijk restafval, sorteeranalyses 2012, Utrecht"]
[null,null,"Betrouwbaarheidsinterval",null,null,"Betrouwbaarheidsinterval"]
["Component","Gem, [%]","min","max","verpakkingen, [%]","min","max"]
["GFT-afval",41,40,43]
["Papier/Karton",17,16,18,7.5,6.9,8.1]
["Luiers",4.4000000000000004,4,4.9000000000000004]
["Kunststoffen",13,12,14,8.3000000000000007,7.7,9]
["Glas",5.0999999999999996,4.5999999999999996,5.6,4.7,4.2,5.2]
["Ferrometalen",3.3,2.9,3.8,2.5,2.1,2.9]
["Nonferrometalen",1.1000000000000001,0.84,1.3,0.77,0.56999999999999995,0.98]
["Textiel",3.4,3,3.8]
["KCA",0.06,0.01,0.12]
["Overig EEA, steen, hout, etc",11,10,12]
["Totaal",{"$f":"SUM(B4:B13)","v":99.36},null,null,{"$f":"SUM(E4:E13)","v":23.77}]
[]
[]
[]
[]
[]
[]
[]
[]
[null,null,"Betrouwbaarheidsinterval"]
["Component","Gem, [%]","min","max"]
["Papier en Karton totaal",17,16,18]
["Herbruikbaar",11,10,11]
["- Papier verpakking, herbruikbaar",4.2,3.7,4.5999999999999996]
["- Papier niet-verpakking, herbruikbaar",6.5,6,7.1]
["Niet herbruikbaar",6.3,5.7,6.9]
["- Papier verpakking, niet herbruikbaar",3.3,2.8,3.9]
["Drankkarton",3.1,2.7,3.5]
["Overig papier / karton",0.25,0.14000000000000001,0.36]
["Papier niet verpakking, niet herbruikbaar",3,2.6,3.4]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[null,null,"Betrouwbaarheidsinterval"]
["Component","Gem, [%]","min","max"]
["Glas totaal",5.0999999999999996,4.5999999999999996,5.6]
["-verpakking",4.7,4.2,5.2]
["- Niet verpakking",0.36,0.23,0.49]

{"sheet":"R pack","index":16,"n_rows":59,"n_cols":16,"rows_kept":59,"cut":false,"hidden":true,"merged":[]}
["Hoeveelheid producten die namens de gemeente zijn geproduceerd uit de gescheiden ingezamelde verpakkingsmateriaalstromen"]
[null,null,"Uit mono-inzameling","Uit PMD-inzameling","Uit PD-inzameling","Uit nascheiding",null,"Totaal",null,null,null,"Totaal"]
["Categorie","Producten","[kg netto/jr]","[kg netto/jr]","[kg netto/jr]","[kg netto/jr]",null,"[kg netto/jr]",null,null,null,"[kg netto/inw.jr]"]
["OPK",{"$f":"PB!Q7","v":"Krantenpapier"},{"$f":"PB!R7","v":0},null,null,null,null,{"$f":"SUM(C4:F4)","v":0},null,null,null,{"$f":"IF(Feed!$B$2=0,0,H4/Feed!$B$2)","v":0},null,"som opk",{"$f":"SUM(H4:H11)","v":0},{"$f":"IF(Feed!$B$2=0,0,O4/Feed!$B$2)","v":0}]
[null,{"$f":"PB!Q8","v":"Ongestreken schrijfpapier"},{"$f":"PB!R8","v":0},null,null,null,null,{"$f":"SUM(C5:F5)","v":0},null,null,null,{"$f":"IF(Feed!$B$2=0,0,H5/Feed!$B$2)","v":0}]
[null,{"$f":"PB!Q9","v":"Gestreken schrijfpapier"},{"$f":"PB!R9","v":0},null,null,null,null,0,null,null,null,{"$f":"IF(Feed!$B$2=0,0,H6/Feed!$B$2)","v":0}]
[null,{"$f":"PB!Q10","v":"Golfkarton papier"},{"$f":"PB!R10","v":0},null,null,null,null,0,null,null,null,{"$f":"IF(Feed!$B$2=0,0,H7/Feed!$B$2)","v":0}]
[null,{"$f":"PB!Q11","v":"Pakpapier"},{"$f":"PB!R11","v":0},null,null,null,null,0,null,null,null,{"$f":"IF(Feed!$B$2=0,0,H8/Feed!$B$2)","v":0}]
[null,{"$f":"PB!Q12","v":"Massief karton"},{"$f":"PB!R12","v":0},null,null,null,null,0,null,null,null,{"$f":"IF(Feed!$B$2=0,0,H9/Feed!$B$2)","v":0}]
[null,{"$f":"PB!Q13","v":"Vouwkarton"},{"$f":"PB!R13","v":0},null,null,null,null,0,null,null,null,{"$f":"IF(Feed!$B$2=0,0,H10/Feed!$B$2)","v":0}]
[null,{"$f":"PB!Q14","v":"Sanitair papier"},{"$f":"PB!R14","v":0},null,null,null,null,0,null,null,null,{"$f":"IF(Feed!$B$2=0,0,H11/Feed!$B$2)","v":0}]
["Glas","Verpakkingsglas wit",{"$f":"Glass!I8+Glass!I18+Glass!I30","v":0},null,null,null,null,0,null,null,null,{"$f":"IF(Feed!$B$2=0,0,H12/Feed!$B$2)","v":0},null,"som glas",{"$f":"H12+H13+H14+H15","v":0},{"$f":"IF(Feed!$B$2=0,0,O12/Feed!$B$2)","v":0}]
[null,"Verpakkingsglas groen",{"$f":"Glass!I9+Glass!I19+Glass!I31","v":0},null,null,null,null,0,null,null,null,{"$f":"IF(Feed!$B$2=0,0,H13/Feed!$B$2)","v":0}]
[null,"Verpakkingsglas bruin",{"$f":"Glass!I10+Glass!I20+Glass!I32","v":0},null,null,null,null,0,null,null,null,{"$f":"IF(Feed!$B$2=0,0,H14/Feed!$B$2)","v":0}]
[null,"Glas bijproducten",{"$f":"Glass!J11+Glass!J21+Glass!J33","v":0},null,null,null,null,0,null,null,null,{"$f":"IF(Feed!$B$2=0,0,H15/Feed!$B$2)","v":0}]
[null,"Steen en puin uit glas",null,null,null,null,null,0]
[null,"Metaal uit glas",null,null,null,null,null,0]
[null,"Plastic afval uit glas",null,null,null,null,null,0]
["Metaal-Fe","Constructiestaal",{"$f":"Metal!G21","v":0},{"$f":"Metal!H21","v":0},null,{"$f":"Metal!F21","v":0},null,0,null,null,null,{"$f":"IF(Feed!$B$2=0,0,H19/Feed!$B$2)","v":0},null,"som MET",{"$f":"SUM(H19:H31)","v":0},{"$f":"IF(Feed!$B$2=0,0,O19/Feed!$B$2)","v":0}]
[null,"Automotive-staal",{"$f":"Metal!G22","v":0},{"$f":"Metal!H22","v":0},null,{"$f":"Metal!F22","v":0},null,0,null,null,null,{"$f":"IF(Feed!$B$2=0,0,H20/Feed!$B$2)","v":0},null,"som Fe MET",{"$f":"SUM(H19:H25)","v":0},{"$f":"IF(Feed!$B$2=0,0,O20/Feed!$B$2)","v":0}]
[null,"Verpakkingsstaal",{"$f":"Metal!G23","v":0},{"$f":"Metal!H23","v":0},null,{"$f":"Metal!F23","v":0},null,0,null,null,null,{"$f":"IF(Feed!$B$2=0,0,H21/Feed!$B$2)","v":0}]
[null,"Rails",{"$f":"Metal!G24","v":0},{"$f":"Metal!H24","v":0},null,{"$f":"Metal!F24","v":0},null,0,null,null,null,{"$f":"IF(Feed!$B$2=0,0,H22/Feed!$B$2)","v":0}]
[null,"Duurzame consumentenartikelen",{"$f":"Metal!G25","v":0},{"$f":"Metal!H25","v":0},null,{"$f":"Metal!F25","v":0},null,0,null,null,null,{"$f":"IF(Feed!$B$2=0,0,H23/Feed!$B$2)","v":0}]
[null,"Mijnbouwapparatuur",{"$f":"Metal!G26","v":0},{"$f":"Metal!H26","v":0},null,{"$f":"Metal!F26","v":0},null,0,null,null,null,{"$f":"IF(Feed!$B$2=0,0,H24/Feed!$B$2)","v":0}]
[null,"Scheepsstaal",{"$f":"Metal!G27","v":0},{"$f":"Metal!H27","v":0},null,{"$f":"Metal!F27","v":0},null,0,null,null,null,{"$f":"IF(Feed!$B$2=0,0,H25/Feed!$B$2)","v":0}]
["Metaal-Aluminium","Constructiealuminium",{"$f":"Metal!G32","v":0},{"$f":"Metal!H32","v":0},null,{"$f":"Metal!F32","v":0},null,0,null,null,null,{"$f":"IF(Feed!$B$2=0,0,H26/Feed!$B$2)","v":0},null,"som NF met",{"$f":"SUM(H26:H31)","v":0},{"$f":"IF(Feed!$B$2=0,0,O26/Feed!$B$2)","v":0}]
[null,"Transport-aluminium",{"$f":"Metal!G33","v":0},{"$f":"Metal!H33","v":0},null,{"$f":"Metal!F33","v":0},null,0,null,null,null,{"$f":"IF(Feed!$B$2=0,0,H27/Feed!$B$2)","v":0}]
[null,"Verpakkingsaluminium",{"$f":"Metal!G34","v":0},{"$f":"Metal!H34","v":0},null,{"$f":"Metal!F34","v":0},null,0,null,null,null,{"$f":"IF(Feed!$B$2=0,0,H28/Feed!$B$2)","v":0}]
[null,"Machines",{"$f":"Metal!G35","v":0},{"$f":"Metal!H35","v":0},null,{"$f":"Metal!F35","v":0},null,0,null,null,null,{"$f":"IF(Feed!$B$2=0,0,H29/Feed!$B$2)","v":0}]
[null,"Diverse toepassingen aluminium",{"$f":"Metal!G36","v":0},{"$f":"Metal!H36","v":0},null,{"$f":"Metal!F36","v":0},null,0,null,null,null,{"$f":"IF(Feed!$B$2=0,0,H30/Feed!$B$2)","v":0}]
[null,"Desox",{"$f":"Metal!G37","v":0},{"$f":"Metal!H37","v":0},null,{"$f":"Metal!F37","v":0},null,0,null,null,null,{"$f":"IF(Feed!$B$2=0,0,H31/Feed!$B$2)","v":0}]
["Kunststof","Flessen",{"$f":"Plastics!B46","v":0},{"$f":"Plastics!J46","v":0},{"$f":"Plastics!R46","v":0},{"$f":"Plastics!AA46","v":0},null,0,null,null,null,{"$f":"IF(Feed!$B$2=0,0,H32/Feed!$B$2)","v":0},null,"som KST",{"$f":"SUM(H32:H54)","v":0},{"$f":"IF(Feed!$B$2=0,0,O32/Feed!$B$2)","v":0}]
[null,"Trays",{"$f":"Plastics!B47","v":0},{"$f":"Plastics!J47","v":0},{"$f":"Plastics!R47","v":0},{"$f":"Plastics!AA47","v":0},null,0,null,null,null,{"$f":"IF(Feed!$B$2=0,0,H33/Feed!$B$2)","v":0}]
[null,"Fleece",{"$f":"Plastics!B48","v":0},{"$f":"Plastics!J48","v":0},{"$f":"Plastics!R48","v":0},{"$f":"Plastics!AA48","v":0},null,0,null,null,null,{"$f":"IF(Feed!$B$2=0,0,H34/Feed!$B$2)","v":0}]
[null,"Strapping",{"$f":"Plastics!B49","v":0},{"$f":"Plastics!J49","v":0},{"$f":"Plastics!R49","v":0},{"$f":"Plastics!AA49","v":0},null,0,null,null,null,{"$f":"IF(Feed!$B$2=0,0,H35/Feed!$B$2)","v":0}]
[null,"Kabelomhulling",{"$f":"Plastics!B50","v":0},{"$f":"Plastics!J50","v":0},{"$f":"Plastics!R50","v":0},{"$f":"Plastics!AA50","v":0},null,{"$f":"SUM(C36:F36)","v":0},null,null,null,{"$f":"IF(Feed!$B$2=0,0,H36/Feed!$B$2)","v":0}]
[null,"Afvoerpijpen",{"$f":"Plastics!B51","v":0},{"$f":"Plastics!J51","v":0},{"$f":"Plastics!R51","v":0},{"$f":"Plastics!AA51","v":0},null,0,null,null,null,{"$f":"IF(Feed!$B$2=0,0,H37/Feed!$B$2)","v":0}]
[null,"Rolkernen",{"$f":"Plastics!B52","v":0},{"$f":"Plastics!J52","v":0},{"$f":"Plastics!R52","v":0},{"$f":"Plastics!AA52","v":0},null,0,null,null,null,{"$f":"IF(Feed!$B$2=0,0,H38/Feed!$B$2)","v":0}]
[null,"Rijplaten",{"$f":"Plastics!B53","v":0},{"$f":"Plastics!J53","v":0},{"$f":"Plastics!R53","v":0},{"$f":"Plastics!AA53","v":0},null,0,null,null,null,{"$f":"IF(Feed!$B$2=0,0,H39/Feed!$B$2)","v":0}]
[null,"Afvalcontainers",{"$f":"Plastics!B54","v":0},{"$f":"Plastics!J54","v":0},{"$f":"Plastics!R54","v":0},{"$f":"Plastics!AA54","v":0},null,0,null,null,null,{"$f":"IF(Feed!$B$2=0,0,H40/Feed!$B$2)","v":0}]
[null,"Non-food flacons",{"$f":"Plastics!B55","v":0},{"$f":"Plastics!J55","v":0},{"$f":"Plastics!R55","v":0},{"$f":"Plastics!AA55","v":0},null,0,null,null,null,{"$f":"IF(Feed!$B$2=0,0,H41/Feed!$B$2)","v":0}]
[null,"Bloempotten",{"$f":"Plastics!B56","v":0},{"$f":"Plastics!J56","v":0},{"$f":"Plastics!R56","v":0},{"$f":"Plastics!AA56","v":0},null,0,null,null,null,{"$f":"IF(Feed!$B$2=0,0,H42/Feed!$B$2)","v":0}]
[null,"Kratten",{"$f":"Plastics!B57","v":0},{"$f":"Plastics!J57","v":0},{"$f":"Plastics!R57","v":0},{"$f":"Plastics!AA57","v":0},null,0,null,null,null,{"$f":"IF(Feed!$B$2=0,0,H43/Feed!$B$2)","v":0}]
[null,"Boombekisting",{"$f":"Plastics!B58","v":0},{"$f":"Plastics!J58","v":0},{"$f":"Plastics!R58","v":0},{"$f":"Plastics!AA58","v":0},null,0,null,null,null,{"$f":"IF(Feed!$B$2=0,0,H44/Feed!$B$2)","v":0}]
[null,"Apparaatbehuizing",{"$f":"Plastics!B59","v":0},{"$f":"Plastics!J59","v":0},{"$f":"Plastics!R59","v":0},{"$f":"Plastics!AA59","v":0},null,0,null,null,null,{"$f":"IF(Feed!$B$2=0,0,H45/Feed!$B$2)","v":0}]
[null,"Pallets",{"$f":"Plastics!B60","v":0},{"$f":"Plastics!J60","v":0},{"$f":"Plastics!R60","v":0},{"$f":"Plastics!AA60","v":0},null,0,null,null,null,{"$f":"IF(Feed!$B$2=0,0,H46/Feed!$B$2)","v":0}]
[null,"Tuinmeubelen",{"$f":"Plastics!B61","v":0},{"$f":"Plastics!J61","v":0},{"$f":"Plastics!R61","v":0},{"$f":"Plastics!AA61","v":0},null,0,null,null,null,{"$f":"IF(Feed!$B$2=0,0,H47/Feed!$B$2)","v":0}]
[null,"Speeltoestellen",{"$f":"Plastics!B62","v":0},{"$f":"Plastics!J62","v":0},{"$f":"Plastics!R62","v":0},{"$f":"Plastics!AA62","v":0},null,0,null,null,null,{"$f":"IF(Feed!$B$2=0,0,H48/Feed!$B$2)","v":0}]
[null,"Verkeersafscheiders",{"$f":"Plastics!B63","v":0},{"$f":"Plastics!J63","v":0},{"$f":"Plastics!R63","v":0},{"$f":"Plastics!AA63","v":0},null,0,null,null,null,{"$f":"IF(Feed!$B$2=0,0,H49/Feed!$B$2)","v":0}]
[null,"Oeverbeschoeiing",{"$f":"Plastics!B64","v":0},{"$f":"Plastics!J64","v":0},{"$f":"Plastics!R64","v":0},{"$f":"Plastics!AA64","v":0},null,0,null,null,null,{"$f":"IF(Feed!$B$2=0,0,H50/Feed!$B$2)","v":0}]
[null,"Steigers plastic lumber",{"$f":"Plastics!B65","v":0},{"$f":"Plastics!J65","v":0},{"$f":"Plastics!R65","v":0},{"$f":"Plastics!AA65","v":0},null,0,null,null,null,{"$f":"IF(Feed!$B$2=0,0,H51/Feed!$B$2)","v":0}]
[null,"Bouwemmers, speciekuipen",{"$f":"Plastics!B66","v":0},{"$f":"Plastics!J66","v":0},{"$f":"Plastics!R66","v":0},{"$f":"Plastics!AA66","v":0},null,0,null,null,null,{"$f":"IF(Feed!$B$2=0,0,H52/Feed!$B$2)","v":0}]
[null,{"$f":"Plastics!A67","v":"Asfalttoeslagstof"},null,null,null,null,null,0,null,null,null,{"$f":"IF(Feed!$B$2=0,0,H53/Feed!$B$2)","v":0}]
[null,{"$f":"Plastics!A68","v":"Brandstof"},null,null,null,null,null,0,null,null,null,{"$f":"IF(Feed!$B$2=0,0,H54/Feed!$B$2)","v":0}]
["Drankenkartons","Vezels /Solid board",{"$f":"BC!F54","v":0},null,{"$f":"PMD!N38","v":0},null,null,0,null,null,null,{"$f":"IF(Feed!$B$2=0,0,H55/Feed!$B$2)","v":0},null,"som DK",{"$f":"SUM(H55:H57)","v":0},{"$f":"IF(Feed!$B$2=0,0,O55/Feed!$B$2)","v":0}]
[null,"Vezels / Container board",null,null,null,{"$f":"IF(Invullen!C39=\"Ja\",BC!F45,0)","v":0},null,0,null,null,null,{"$f":"IF(Feed!$B$2=0,0,H56/Feed!$B$2)","v":0}]
[null,"Vezels / Sanitary paper",null,{"$f":"PMD!N11","v":0},null,null,null,0,null,null,null,{"$f":"IF(Feed!$B$2=0,0,H57/Feed!$B$2)","v":0}]
[null,"bijproducten",{"$f":"BC!F55","v":0},{"$f":"PMD!N12","v":0},{"$f":"PMD!N39","v":0},{"$f":"IF(Invullen!C39=\"Ja\",BC!F46,0)","v":0},null,0,null,null,null,{"$f":"IF(Feed!$B$2=0,0,H58/Feed!$B$2)","v":0}]
[null,null,null,null,null,null,null,{"$f":"SUM(H4:H58)","v":0},null,null,null,{"$f":"SUM(L4:L58)","v":0}]

{"sheet":"R pack + non pack","index":17,"n_rows":59,"n_cols":16,"rows_kept":59,"cut":false,"hidden":true,"merged":[]}
["Hoeveelheid producten die namens de gemeente zijn geproduceerd uit de gescheiden ingezamelde materiaalstromen"]
[null,null,"Uit mono-inzameling","Uit PMD-inzameling","Uit PD-inzameling","Uit nascheiding",null,"Totaal",null,null,null,"Totaal"]
["Categorie","Producten","[kg netto/jr]","[kg netto/jr]","[kg netto/jr]","[kg netto/jr]",null,"[kg netto/jr]",null,null,null,"[kg netto/inw.jr]"]
["OPK",{"$f":"PB!Q7","v":"Krantenpapier"},null,null,null,null,null,{"$f":"'R pack'!H4*Netto!$K$44","v":0},null,null,null,{"$f":"IF(Feed!$B$2=0,0,H4/Feed!$B$2)","v":0},null,"som opk",{"$f":"SUM(H4:H11)","v":0},{"$f":"IF(Feed!$B$2=0,0,O4/Feed!$B$2)","v":0}]
[null,{"$f":"PB!Q8","v":"Ongestreken schrijfpapier"},null,null,null,null,null,{"$f":"'R pack'!H5*Netto!$K$44","v":0},null,null,null,{"$f":"IF(Feed!$B$2=0,0,H5/Feed!$B$2)","v":0}]
[null,{"$f":"PB!Q9","v":"Gestreken schrijfpapier"},null,null,null,null,null,{"$f":"'R pack'!H6*Netto!$K$44","v":0},null,null,null,{"$f":"IF(Feed!$B$2=0,0,H6/Feed!$B$2)","v":0}]
[null,{"$f":"PB!Q10","v":"Golfkarton papier"},null,null,null,null,null,{"$f":"'R pack'!H7*Netto!$K$44","v":0},null,null,null,{"$f":"IF(Feed!$B$2=0,0,H7/Feed!$B$2)","v":0}]
[null,{"$f":"PB!Q11","v":"Pakpapier"},null,null,null,null,null,{"$f":"'R pack'!H8*Netto!$K$44","v":0},null,null,null,{"$f":"IF(Feed!$B$2=0,0,H8/Feed!$B$2)","v":0}]
[null,{"$f":"PB!Q12","v":"Massief karton"},null,null,null,null,null,{"$f":"'R pack'!H9*Netto!$K$44","v":0},null,null,null,{"$f":"IF(Feed!$B$2=0,0,H9/Feed!$B$2)","v":0}]
[null,{"$f":"PB!Q13","v":"Vouwkarton"},null,null,null,null,null,{"$f":"'R pack'!H10*Netto!$K$44","v":0},null,null,null,{"$f":"IF(Feed!$B$2=0,0,H10/Feed!$B$2)","v":0}]
[null,{"$f":"PB!Q14","v":"Sanitair papier"},null,null,null,null,null,{"$f":"'R pack'!H11*Netto!$K$44","v":0},null,null,null,{"$f":"IF(Feed!$B$2=0,0,H11/Feed!$B$2)","v":0}]
["Glas","Verpakkingsglas wit",null,null,null,null,null,{"$f":"'R pack'!H12*Netto!$K$46","v":0},null,null,null,{"$f":"IF(Feed!$B$2=0,0,H12/Feed!$B$2)","v":0},null,"som glas",{"$f":"H12+H13+H14+H15","v":0},{"$f":"IF(Feed!$B$2=0,0,O12/Feed!$B$2)","v":0}]
[null,"Verpakkingsglas groen",null,null,null,null,null,{"$f":"'R pack'!H13*Netto!$K$46","v":0},null,null,null,{"$f":"IF(Feed!$B$2=0,0,H13/Feed!$B$2)","v":0}]
[null,"Verpakkingsglas bruin",null,null,null,null,null,{"$f":"'R pack'!H14*Netto!$K$46","v":0},null,null,null,{"$f":"IF(Feed!$B$2=0,0,H14/Feed!$B$2)","v":0}]
[null,"Glas bijproducten",null,null,null,null,null,{"$f":"'R pack'!H15*Netto!$K$46","v":0},null,null,null,{"$f":"IF(Feed!$B$2=0,0,H15/Feed!$B$2)","v":0}]
[null,"Steen en puin uit glas",null,null,null,null,null,null,null,null,null,{"$f":"IF(Feed!$B$2=0,0,H16/Feed!$B$2)","v":0}]
[null,"Metaal uit glas",null,null,null,null,null,null,null,null,null,{"$f":"IF(Feed!$B$2=0,0,H17/Feed!$B$2)","v":0}]
[null,"Plastic afval uit glas",null,null,null,null,null,null,null,null,null,{"$f":"IF(Feed!$B$2=0,0,H18/Feed!$B$2)","v":0}]
["Metaal-Fe","Constructiestaal",null,null,null,null,null,{"$f":"'R pack'!H19*Netto!$K$47","v":0},null,null,null,{"$f":"IF(Feed!$B$2=0,0,H19/Feed!$B$2)","v":0},null,"som MET",{"$f":"SUM(H19:H31)","v":0},{"$f":"IF(Feed!$B$2=0,0,O19/Feed!$B$2)","v":0}]
[null,"Automotive-staal",null,null,null,null,null,{"$f":"'R pack'!H20*Netto!$K$47","v":0},null,null,null,{"$f":"IF(Feed!$B$2=0,0,H20/Feed!$B$2)","v":0},null,"som Fe MET",{"$f":"SUM(H19:H25)","v":0},{"$f":"IF(Feed!$B$2=0,0,O20/Feed!$B$2)","v":0}]
[null,"Verpakkingsstaal",null,null,null,null,null,{"$f":"'R pack'!H21*Netto!$K$47","v":0},null,null,null,{"$f":"IF(Feed!$B$2=0,0,H21/Feed!$B$2)","v":0}]
[null,"Rails",null,null,null,null,null,{"$f":"'R pack'!H22*Netto!$K$47","v":0},null,null,null,{"$f":"IF(Feed!$B$2=0,0,H22/Feed!$B$2)","v":0}]
[null,"Duurzame consumentenartikelen",null,null,null,null,null,{"$f":"'R pack'!H23*Netto!$K$47","v":0},null,null,null,{"$f":"IF(Feed!$B$2=0,0,H23/Feed!$B$2)","v":0}]
[null,"Mijnbouwapparatuur",null,null,null,null,null,{"$f":"'R pack'!H24*Netto!$K$47","v":0},null,null,null,{"$f":"IF(Feed!$B$2=0,0,H24/Feed!$B$2)","v":0}]
[null,"Scheepsstaal",null,null,null,null,null,{"$f":"'R pack'!H25*Netto!$K$47","v":0},null,null,null,{"$f":"IF(Feed!$B$2=0,0,H25/Feed!$B$2)","v":0}]
["Metaal-Aluminium","Constructiealuminium",null,null,null,null,null,{"$f":"'R pack'!H26*Netto!$K$47","v":0},null,null,null,{"$f":"IF(Feed!$B$2=0,0,H26/Feed!$B$2)","v":0},null,"som NF met",{"$f":"SUM(H26:H31)","v":0},{"$f":"IF(Feed!$B$2=0,0,O26/Feed!$B$2)","v":0}]
[null,"Transport-aluminium",null,null,null,null,null,{"$f":"'R pack'!H27*Netto!$K$47","v":0},null,null,null,{"$f":"IF(Feed!$B$2=0,0,H27/Feed!$B$2)","v":0}]
[null,"Verpakkingsaluminium",null,null,null,null,null,{"$f":"'R pack'!H28*Netto!$K$47","v":0},null,null,null,{"$f":"IF(Feed!$B$2=0,0,H28/Feed!$B$2)","v":0}]
[null,"Machines",null,null,null,null,null,{"$f":"'R pack'!H29*Netto!$K$47","v":0},null,null,null,{"$f":"IF(Feed!$B$2=0,0,H29/Feed!$B$2)","v":0}]
[null,"Diverse",null,null,null,null,null,{"$f":"'R pack'!H30*Netto!$K$47","v":0},null,null,null,{"$f":"IF(Feed!$B$2=0,0,H30/Feed!$B$2)","v":0}]
[null,"Desox",null,null,null,null,null,{"$f":"'R pack'!H31*Netto!$K$47","v":0},null,null,null,{"$f":"IF(Feed!$B$2=0,0,H31/Feed!$B$2)","v":0}]
["Kunststof","Flessen",{"$f":"'R pack'!C32*Netto!$K$45","v":0},{"$f":"'R pack'!D32*Netto!$K$45","v":0},{"$f":"'R pack'!E32*Netto!$K$45","v":0},{"$f":"Plastics!AB46","v":0},null,{"$f":"SUM(C32:F32)","v":0},null,null,null,{"$f":"IF(Feed!$B$2=0,0,H32/Feed!$B$2)","v":0},null,"som KST",{"$f":"SUM(H32:H54)","v":0},{"$f":"IF(Feed!$B$2=0,0,O32/Feed!$B$2)","v":0}]
[null,"Trays",{"$f":"'R pack'!C33*Netto!$K$45","v":0},{"$f":"'R pack'!D33*Netto!$K$45","v":0},{"$f":"'R pack'!E33*Netto!$K$45","v":0},{"$f":"Plastics!AB47","v":0},null,0,null,null,null,{"$f":"IF(Feed!$B$2=0,0,H33/Feed!$B$2)","v":0}]
[null,"Fleece",{"$f":"'R pack'!C34*Netto!$K$45","v":0},{"$f":"'R pack'!D34*Netto!$K$45","v":0},{"$f":"'R pack'!E34*Netto!$K$45","v":0},{"$f":"Plastics!AB48","v":0},null,0,null,null,null,{"$f":"IF(Feed!$B$2=0,0,H34/Feed!$B$2)","v":0}]
[null,"Strapping",{"$f":"'R pack'!C35*Netto!$K$45","v":0},{"$f":"'R pack'!D35*Netto!$K$45","v":0},{"$f":"'R pack'!E35*Netto!$K$45","v":0},{"$f":"Plastics!AB49","v":0},null,0,null,null,null,{"$f":"IF(Feed!$B$2=0,0,H35/Feed!$B$2)","v":0}]
[null,"Kabelomhulling",{"$f":"'R pack'!C36*Netto!$K$45","v":0},{"$f":"'R pack'!D36*Netto!$K$45","v":0},{"$f":"'R pack'!E36*Netto!$K$45","v":0},{"$f":"Plastics!AB50","v":0},null,0,null,null,null,{"$f":"IF(Feed!$B$2=0,0,H36/Feed!$B$2)","v":0}]
[null,"Afvoerpijpen",{"$f":"'R pack'!C37*Netto!$K$45","v":0},{"$f":"'R pack'!D37*Netto!$K$45","v":0},{"$f":"'R pack'!E37*Netto!$K$45","v":0},{"$f":"Plastics!AB51","v":0},null,0,null,null,null,{"$f":"IF(Feed!$B$2=0,0,H37/Feed!$B$2)","v":0}]
[null,"Rolkernen",{"$f":"'R pack'!C38*Netto!$K$45","v":0},{"$f":"'R pack'!D38*Netto!$K$45","v":0},{"$f":"'R pack'!E38*Netto!$K$45","v":0},{"$f":"Plastics!AB52","v":0},null,0,null,null,null,{"$f":"IF(Feed!$B$2=0,0,H38/Feed!$B$2)","v":0}]
[null,"Rijplaten",{"$f":"'R pack'!C39*Netto!$K$45","v":0},{"$f":"'R pack'!D39*Netto!$K$45","v":0},{"$f":"'R pack'!E39*Netto!$K$45","v":0},{"$f":"Plastics!AB53","v":0},null,0,null,null,null,{"$f":"IF(Feed!$B$2=0,0,H39/Feed!$B$2)","v":0}]
[null,"Afvalcontainers",{"$f":"'R pack'!C40*Netto!$K$45","v":0},{"$f":"'R pack'!D40*Netto!$K$45","v":0},{"$f":"'R pack'!E40*Netto!$K$45","v":0},{"$f":"Plastics!AB54","v":0},null,0,null,null,null,{"$f":"IF(Feed!$B$2=0,0,H40/Feed!$B$2)","v":0}]
[null,"Non-food flacons",{"$f":"'R pack'!C41*Netto!$K$45","v":0},{"$f":"'R pack'!D41*Netto!$K$45","v":0},{"$f":"'R pack'!E41*Netto!$K$45","v":0},{"$f":"Plastics!AB55","v":0},null,0,null,null,null,{"$f":"IF(Feed!$B$2=0,0,H41/Feed!$B$2)","v":0}]
[null,"Bloempotten",{"$f":"'R pack'!C42*Netto!$K$45","v":0},{"$f":"'R pack'!D42*Netto!$K$45","v":0},{"$f":"'R pack'!E42*Netto!$K$45","v":0},{"$f":"Plastics!AB56","v":0},null,0,null,null,null,{"$f":"IF(Feed!$B$2=0,0,H42/Feed!$B$2)","v":0}]
[null,"Kratten",{"$f":"'R pack'!C43*Netto!$K$45","v":0},{"$f":"'R pack'!D43*Netto!$K$45","v":0},{"$f":"'R pack'!E43*Netto!$K$45","v":0},{"$f":"Plastics!AB57","v":0},null,0,null,null,null,{"$f":"IF(Feed!$B$2=0,0,H43/Feed!$B$2)","v":0}]
[null,"Boombekisting",{"$f":"'R pack'!C44*Netto!$K$45","v":0},{"$f":"'R pack'!D44*Netto!$K$45","v":0},{"$f":"'R pack'!E44*Netto!$K$45","v":0},{"$f":"Plastics!AB58","v":0},null,0,null,null,null,{"$f":"IF(Feed!$B$2=0,0,H44/Feed!$B$2)","v":0}]
[null,"Apparaatbehuizing",{"$f":"'R pack'!C45*Netto!$K$45","v":0},{"$f":"'R pack'!D45*Netto!$K$45","v":0},{"$f":"'R pack'!E45*Netto!$K$45","v":0},{"$f":"Plastics!AB59","v":0},null,0,null,null,null,{"$f":"IF(Feed!$B$2=0,0,H45/Feed!$B$2)","v":0}]
[null,"Pallets",{"$f":"'R pack'!C46*Netto!$K$45","v":0},{"$f":"'R pack'!D46*Netto!$K$45","v":0},{"$f":"'R pack'!E46*Netto!$K$45","v":0},{"$f":"Plastics!AB60","v":0},null,0,null,null,null,{"$f":"IF(Feed!$B$2=0,0,H46/Feed!$B$2)","v":0}]
[null,"Tuinmeubelen",{"$f":"'R pack'!C47*Netto!$K$45","v":0},{"$f":"'R pack'!D47*Netto!$K$45","v":0},{"$f":"'R pack'!E47*Netto!$K$45","v":0},{"$f":"Plastics!AB61","v":0},null,0,null,null,null,{"$f":"IF(Feed!$B$2=0,0,H47/Feed!$B$2)","v":0}]
[null,"Speeltoestellen",{"$f":"'R pack'!C48*Netto!$K$45","v":0},{"$f":"'R pack'!D48*Netto!$K$45","v":0},{"$f":"'R pack'!E48*Netto!$K$45","v":0},{"$f":"Plastics!AB62","v":0},null,0,null,null,null,{"$f":"IF(Feed!$B$2=0,0,H48/Feed!$B$2)","v":0}]
[null,"Verkeersafscheiders",{"$f":"'R pack'!C49*Netto!$K$45","v":0},{"$f":"'R pack'!D49*Netto!$K$45","v":0},{"$f":"'R pack'!E49*Netto!$K$45","v":0},{"$f":"Plastics!AB63","v":0},null,0,null,null,null,{"$f":"IF(Feed!$B$2=0,0,H49/Feed!$B$2)","v":0}]
[null,"Oeverbeschoeiing",{"$f":"'R pack'!C50*Netto!$K$45","v":0},{"$f":"'R pack'!D50*Netto!$K$45","v":0},{"$f":"'R pack'!E50*Netto!$K$45","v":0},{"$f":"Plastics!AB64","v":0},null,0,null,null,null,{"$f":"IF(Feed!$B$2=0,0,H50/Feed!$B$2)","v":0}]
[null,"Steigers plastic lumber",{"$f":"'R pack'!C51*Netto!$K$45","v":0},{"$f":"'R pack'!D51*Netto!$K$45","v":0},{"$f":"'R pack'!E51*Netto!$K$45","v":0},{"$f":"Plastics!AB65","v":0},null,0,null,null,null,{"$f":"IF(Feed!$B$2=0,0,H51/Feed!$B$2)","v":0}]
[null,"Bouwemmers, speciekuipen",{"$f":"'R pack'!C52*Netto!$K$45","v":0},{"$f":"'R pack'!D52*Netto!$K$45","v":0},{"$f":"'R pack'!E52*Netto!$K$45","v":0},{"$f":"Plastics!AB66","v":0},null,0,null,null,null,{"$f":"IF(Feed!$B$2=0,0,H52/Feed!$B$2)","v":0}]
[null,{"$f":"Plastics!A67","v":"Asfalttoeslagstof"},null,null,null,null,null,null,null,null,null,{"$f":"IF(Feed!$B$2=0,0,H53/Feed!$B$2)","v":0}]
[null,{"$f":"Plastics!A68","v":"Brandstof"},null,null,null,null,null,null,null,null,null,{"$f":"IF(Feed!$B$2=0,0,H54/Feed!$B$2)","v":0}]
["Drankenkartons","Vezels /Solid board",null,null,null,null,null,{"$f":"'R pack'!H55","v":0},null,null,null,{"$f":"IF(Feed!$B$2=0,0,H55/Feed!$B$2)","v":0},null,"som DK",{"$f":"SUM(H55:H57)","v":0},{"$f":"IF(Feed!$B$2=0,0,O55/Feed!$B$2)","v":0}]
[null,"Vezels / Container board",null,null,null,null,null,{"$f":"'R pack'!H56","v":0},null,null,null,{"$f":"IF(Feed!$B$2=0,0,H56/Feed!$B$2)","v":0}]
[null,"Vezels / Sanitary paper",null,null,null,null,null,{"$f":"'R pack'!H57","v":0},null,null,null,{"$f":"IF(Feed!$B$2=0,0,H57/Feed!$B$2)","v":0}]
[null,"bijproducten",null,null,null,null,null,{"$f":"'R pack'!H58","v":0},null,null,null,{"$f":"IF(Feed!$B$2=0,0,H58/Feed!$B$2)","v":0}]
["Totaal",null,null,null,null,null,null,{"$f":"SUM(H4:H58)","v":0},null,null,null,{"$f":"SUM(L4:L58)","v":0}]

{"sheet":"Graphical results","index":18,"n_rows":62,"n_cols":13,"rows_kept":62,"cut":false,"hidden":true,"merged":[]}
["Bruto vergelijking","Huisvuil","Gescheiden inzameling",null,"Inzamelefficientie"]
["Papier en karton verpakkingen",{"$f":"Netto!B4","v":0},{"$f":"Netto!D23","v":0},null,{"$f":"C2/(B2+C2)","v":{"$error":"#DIV/0!"}}]
["Kunststofverpakkingen",{"$f":"Netto!B5","v":0},{"$f":"Netto!D24+Netto!D25+Netto!D26","v":0},null,{"$f":"C3/(B3+C3)","v":{"$error":"#DIV/0!"}}]
["Glasverpakkingen",{"$f":"Netto!B6","v":0},{"$f":"Netto!D27+Netto!D28+Netto!D29","v":0},null,{"$f":"C4/(B4+C4)","v":{"$error":"#DIV/0!"}}]
["Metaal verpakkingen",{"$f":"Netto!B7","v":0},{"$f":"Netto!D30+Netto!D31","v":0},null,{"$f":"C5/(B5+C5)","v":{"$error":"#DIV/0!"}}]
["Drankenkartons",{"$f":"Netto!B8","v":0},{"$f":"Netto!D32+Netto!D33","v":0},null,{"$f":"C6/(B6+C6)","v":{"$error":"#DIV/0!"}}]
[]
[]
[]
["Netto vergelijking","Huisvuil","Gescheiden inzameling",null,"Inzamel-efficiëntie gemeente","Inzamel-efficiëntie nationaal gemiddelde 2017","Inzamel-efficiëntie nationaal gemiddelde 2014"]
["Papier en karton verpakkingen",{"$f":"Netto!D4/(Netto!E23+Netto!D4)","v":{"$error":"#DIV/0!"}},{"$f":"Netto!E23/(Netto!E23+Netto!D4)","v":{"$error":"#DIV/0!"}},null,{"$f":"C11/(B11+C11)","v":{"$error":"#DIV/0!"}},{"$f":"'Nationale referentiedata'!F16","v":0.76707697666738717},0.75205174544413544]
["Kunststof verpakkingen",{"$f":"Netto!D5/(Netto!E24+Netto!E25+Netto!E26+Netto!D5)","v":{"$error":"#DIV/0!"}},{"$f":"(Netto!E24+Netto!E25+Netto!E26)/(Netto!E24+Netto!E25+Netto!E26+Netto!D5)","v":{"$error":"#DIV/0!"}},null,{"$f":"C12/(B12+C12)","v":{"$error":"#DIV/0!"}},{"$f":"'Nationale referentiedata'!G17","v":0.45552093613420197},0.32701682199793575]
["Glas verpakkingen",{"$f":"Netto!D6/(Netto!E27+Netto!E28+Netto!E29+Netto!D6)","v":{"$error":"#DIV/0!"}},{"$f":"(Netto!E27+Netto!E28+Netto!E29)/(Netto!E27+Netto!E28+Netto!E29+Netto!D6)","v":{"$error":"#DIV/0!"}},null,{"$f":"C13/(B13+C13)","v":{"$error":"#DIV/0!"}},{"$f":"'Nationale referentiedata'!F20","v":0.70882109566206708},0.68206504339269991]
["Metaal verpakkingen",{"$f":"Netto!D7/(Netto!E30+Netto!E31+Netto!D7)","v":{"$error":"#DIV/0!"}},{"$f":"(Netto!E30+Netto!E31)/(Netto!E30+Netto!E31+Netto!D7)","v":{"$error":"#DIV/0!"}},null,{"$f":"C14/(B14+C14)","v":{"$error":"#DIV/0!"}},{"$f":"'Nationale referentiedata'!G21","v":0.16158362103869126},1.8859128985093641E-2]
["Drankenkartons",{"$f":"Netto!D8/(Netto!E32+Netto!E33+Netto!E34+Netto!D8)","v":{"$error":"#DIV/0!"}},{"$f":"(Netto!E32+Netto!E33+Netto!E34)/(Netto!E32+Netto!E33+Netto!E34+Netto!D8)","v":{"$error":"#DIV/0!"}},null,{"$f":"C15/(B15+C15)","v":{"$error":"#DIV/0!"}},{"$f":"'Nationale referentiedata'!G23","v":0.30117862594881289},4.4772421302922867E-2]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
["Overall",null,null,null,null,null,"Further detailled"]
[null,null,null,null,null,null,null,null,"Recycling"]
[null,"Potentiaal","Recycling producten","Netto ketenrendement",null,null,null,{"$f":"B29","v":"Potentiaal"},"recycling via gescheiden ingezameling","recycling via PMD-inzameling","Recycling via PD","recycling via nascheiding"]
["Papier en karton verpakkingen",{"$f":"Netto!D44","v":0},{"$f":"'R pack'!O4","v":0},{"$f":"C30/B30","v":{"$error":"#DIV/0!"}},null,null,{"$f":"A30","v":"Papier en karton verpakkingen"},0,{"$f":"SUM('R pack'!C4:C11)","v":0}]
["Kunststofverpakkingen",{"$f":"Netto!D45","v":0},{"$f":"'R pack'!O32","v":0},{"$f":"C31/B31","v":{"$error":"#DIV/0!"}},null,null,{"$f":"A31","v":"Kunststofverpakkingen"},0,{"$f":"SUM('R pack'!C32:C52)","v":0},{"$f":"SUM('R pack'!D32:D52)","v":0},{"$f":"SUM('R pack'!E32:E52)","v":0},{"$f":"SUM('R pack'!F32:F52)","v":0}]
["Glasverpakkingen",{"$f":"Netto!D46","v":0},{"$f":"'R pack'!O12","v":0},{"$f":"C32/B32","v":{"$error":"#DIV/0!"}},null,null,{"$f":"A32","v":"Glasverpakkingen"},0,{"$f":"SUM('R pack'!C12:C15)","v":0}]
["Metaal verpakkingen",{"$f":"Netto!D47","v":0},{"$f":"'R pack'!O19","v":0},{"$f":"C33/B33","v":{"$error":"#DIV/0!"}},null,null,{"$f":"A33","v":"Metaal verpakkingen"},0,{"$f":"SUM('R pack'!C19:C30)","v":0},{"$f":"SUM('R pack'!D19:D30)","v":0},null,{"$f":"SUM('R pack'!F19:F30)","v":0}]
["Drankenkartons",{"$f":"Netto!D48","v":0},{"$f":"'R pack'!O55","v":0},{"$f":"C34/B34","v":{"$error":"#DIV/0!"}},null,null,{"$f":"A34","v":"Drankenkartons"},0,{"$f":"SUM('R pack'!C55:C58)","v":0},{"$f":"SUM('R pack'!D56:D58)","v":0},{"$f":"SUM('R pack'!E56:E58)","v":0},{"$f":"SUM('R pack'!F56:F58)","v":0}]
[]
[]
["Netto recyclingketen rendementen",null,null,"Net chain recycling yields",null,null,null,{"$f":"A37","v":"Netto recyclingketen rendementen"},"Gescheiden inzameling","PMD inzameling","PD inzameling","Nascheiden"]
["Papier en karton verpakkingen",null,null,{"$f":"D30","v":{"$error":"#DIV/0!"}},null,null,null,"Papier en karton verpakkingen (OPK)",{"$f":"I30/$H30","v":{"$error":"#DIV/0!"}},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$f":"L30/$H30","v":{"$error":"#DIV/0!"}}]
[null,null,null,null,null,null,null,"OPK Nationaal gemiddelde 2017",{"$f":"I50","v":0.69871292330825863},null,null,{"$f":"L50","v":0}]
["Kunststofverpakkingen",null,null,{"$f":"D31","v":{"$error":"#DIV/0!"}},null,null,null,"Kunststofverpakkingen (KST)",{"$f":"I31/$H31","v":{"$error":"#DIV/0!"}},{"$f":"J31/$H31","v":{"$error":"#DIV/0!"}},{"$f":"K31/$H31","v":{"$error":"#DIV/0!"}},{"$f":"L31/$H31","v":{"$error":"#DIV/0!"}}]
[null,null,null,null,null,null,null,"KST Nationaal gemiddelde 2017",3.1203158638219469E-2,0.24456770767047092,4.8738621796220134E-2,{"$f":"L51","v":5.4457943134547451E-2}]
["Glasverpakkingen",null,null,{"$f":"D32","v":{"$error":"#DIV/0!"}},null,null,null,"Glasverpakkingen (GL)",{"$f":"I32/$H32","v":{"$error":"#DIV/0!"}},null,null,{"$f":"L32/$H32","v":{"$error":"#DIV/0!"}}]
[null,null,null,null,null,null,null,"GL Nationaal gemiddelde 2017",{"$f":"I52","v":0.67231680923547077},null,null,{"$f":"L52","v":0}]
["Metaal verpakkingen",null,null,{"$f":"D33","v":{"$error":"#DIV/0!"}},null,null,null,"Metaal verpakkingen (MET)",{"$f":"I33/$H33","v":{"$error":"#DIV/0!"}},{"$f":"J33/$H33","v":{"$error":"#DIV/0!"}},null,{"$f":"L33/$H33","v":{"$error":"#DIV/0!"}}]
[null,null,null,null,null,null,null,"MET Nationaal gemiddelde 2017",{"$f":"0.917957230952512%","v":9.1795723095251195E-3},0.14277721851168085,null,{"$f":"L53","v":0.69884688051024046}]
["Drankenkartons",null,null,{"$f":"D34","v":{"$error":"#DIV/0!"}},null,null,null,"Drankenkartons (DK)",{"$f":"I34/$H34","v":{"$error":"#DIV/0!"}},{"$f":"J34/$H34","v":{"$error":"#DIV/0!"}},{"$f":"K34/$H34","v":{"$error":"#DIV/0!"}},{"$f":"L34/$H34","v":{"$error":"#DIV/0!"}}]
[null,null,null,null,null,null,null,"DK Nationaal gemiddelde 2017",{"$f":"0.740568385090546%","v":7.4056838509054604E-3},0.19056430018731224,1.2361461964919381E-2,{"$f":"L54","v":2.4993686078710532E-2}]
[]
[null,null,null,null,null,null,"Nationale referentie",{"$f":"H37","v":"Netto recyclingketen rendementen"},"Ref 2017",null,null,{"$f":"L37","v":"Nascheiden"},"Nationaal Gemiddelde 2014 (Alle inzamelmethoden)"]
[null,null,null,null,null,null,null,"Paper & board packaging",0.69871292330825863,null,null,0,{"$f":"SUM(I50:L50)","v":0.69871292330825863}]
[null,null,null,null,null,null,null,"Plastic packaging",0.32450948810491054,null,null,5.4457943134547451E-2,{"$f":"SUM(I51:L51)","v":0.37896743123945797}]
[null,null,null,null,null,null,null,"Glass packaging",0.67231680923547077,null,null,0,0.67231680923547077]
[null,null,null,null,null,null,null,"Metal packaging",0.15195679082120594,null,null,0.69884688051024046,0.85080367133144641]
[null,null,null,null,null,null,null,"Beverage cartons",0.21033144600313705,null,null,2.4993686078710532E-2,0.23532513208184758]
["Total amounts of recycled products made on behalf of the municipality, [ton net/a]"]
[null,"Alleen verpakkingen","Verpakkingen en niet-verpakkingen"]
["Papier en karton verpakkingen",{"$f":"'R pack'!O4/1000","v":0},{"$f":"'R pack + non pack'!O4/1000","v":0}]
["Kunststofverpakkingen",{"$f":"'R pack'!O32/1000","v":0},{"$f":"'R pack + non pack'!O32/1000","v":0}]
["Glasverpakkingen",{"$f":"'R pack'!O12/1000","v":0},{"$f":"'R pack + non pack'!O12/1000","v":0}]
["Metaal verpakkingen",{"$f":"'R pack'!O19/1000","v":0},{"$f":"'R pack + non pack'!O19/1000","v":0}]
["Drankenkartons",{"$f":"'R pack'!O55/1000","v":0},{"$f":"'R pack + non pack'!O55/1000","v":0}]
["Totaal  ",{"$f":"SUM(B57:B61)","v":0},{"$f":"SUM(C57:C61)","v":0}]

{"sheet":"Nationale referentiedata","index":19,"n_rows":28,"n_cols":7,"rows_kept":28,"cut":false,"hidden":true,"merged":[]}
[]
[]
[null,2014]
[null,"Netto inzamelefficientie"]
[null,"Net comparison","MSW","Separate collection",null,"collection efficiency"]
[null,"Paper & board packaging",92428330.522765592,280344330,null,0.75205174544413544]
[null,"Plastic packaging",180748735.24451932,87829650,null,0.32701682199793575]
[null,"Glass packaging",154321079.25801009,331064613.79310346,null,0.68206504339269991]
[null,"Metal packaging",79077571.669477224,1520000,null,1.8859128985093641E-2]
[null,"Beverage cartons",60591905.564924113,2840000,null,4.4772421302922867E-2]
[]
[]
[null,2017,"MSW","Separate collection",null,"collection efficiency"]
[null,"Netto inzamelefficientie"]
[null,"Net comparison"]
[null,"Paper & board packaging",82652514.63148497,272196540,null,{"$f":"D16/(C16+D16)","v":0.76707697666738717}]
[null,"Plastic packaging",161631584.16823721,14978700,null,{"$f":"D17/($C$17+D17+D18+D19)","v":5.0457889130367833E-2},{"$f":"F17+F18+F19","v":0.45552093613420197}]
[null,"P in PMD",null,99166614.376276195,null,{"$f":"D18/($C$17+D18+D17+D19)","v":0.33405689636831531}]
[null,"P in PD",null,21078563.666749503,null,{"$f":"D19/($C$17+D19+D17+D18)","v":7.1006150635518822E-2}]
[null,"Glass packaging",137999087.39212379,335933211.05476677,null,{"$f":"D20/(C20+D20)","v":0.70882109566206708}]
[null,"Metal packaging",70713818.073603794,794200,null,{"$f":"D21/($C$21+D21+D22)","v":9.4164097811546242E-3},{"$f":"F21+F22","v":0.16158362103869126}]
[null,"M in PMD",null,12834105.778042832,null,{"$f":"D22/($C$21+D22+D21)","v":0.15216721125753663}]
[null,"Beverage cartons",54183315.147306807,603500,null,{"$f":"D23/($C$23+D23+D24+D25)","v":7.7835528906513218E-3},{"$f":"F23+F24+F25","v":0.30117862594881289}]
[null,"BC in PMD",null,18441195.185449522,null,{"$f":"D24/($C$23+D24+D23+D25)","v":0.23784261490102879}]
[null,"PC in PD",null,4307275.7349791983,null,{"$f":"D25/($C$23+D25+D23+D24)","v":5.5552458157132785E-2}]
[]
[]
[null,"Nascheiden in 2017"]

{"sheet":"Hulp voor invulblad","index":20,"n_rows":10,"n_cols":1,"rows_kept":10,"cut":false,"hidden":true,"merged":[]}
["Ja"]
["Nee"]
[]
["Omrin"]
["HVC"]
["Attero-Noord"]
["Attero-Wijster"]
[]
[0]
[1]