{"text_format":"1","workbook":"xlsx","n_sheets":9,"sheets":["Kosten-batentabel","Kladblok","RECUPA Kostprijsberekening","Grafieken","Opbouw kosten","Samenvatting kosten","Stroom","Gegevens","Factsheet"],"not_rendered":{"charts":3,"images":5,"macros":1,"external_links":0,"defined_names":1,"comments":2,"pivot_tables":0},"unopened":[],"bounds":{"document_bytes":16777216,"sheet_cells":100000,"rows_first":2000,"rows_last":500,"rows_between":2000,"halvings":0,"cell_chars":16384,"cell_head_chars":4096},"cells_cut":0,"cells_raw":0,"read":"whole","date_system":"1900"}

{"sheet":"Kosten-batentabel","index":0,"n_rows":83,"n_cols":12,"rows_kept":83,"cut":false,"hidden":true,"merged":[]}
["Rekenmodel kosten-batentabel Recupa",null,null,null,null,null,null,null,null,null,null,"https://edepot.wur.nl/248976"]
["Versie","Concept"]
["Datum","2021-09-23"]
["Locatie opstelling","PCH"]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
["Uitgangspunten:"]
["- Verhoudingen pomp/drain/putten/overloop (hoe kunnen we dit goed verwerken?)"]
["- Actuele offertes?"]
["- Economische en technische levensduur?"]
["- Berekeningen op basis van 1ha trayveld"]
["- Grond in eigendom"]
["- 3 technieken zijn: ozon, trage zandfilter en ultrafiltratie (back-up techniek: waterstofperoxide)"]
[]
["Kosten-batentabel"]
["Techniek:","Trage zandfilter"]
["Oppervlak trayveld:",10000,"m²"]
["Capaciteit"]
["Vuile drain opslag:",160,"m³","Hoe kunnen we de capaciteitsnormen opnemen?"]
["Propere drain opslag:",600,"m³","Kunnen we prijzen koppelen aan de capaciteit van deze onderdelen?"]
["Ontsmettingstechniek:",6,"m³"]
["Voorput pomp: ",60,"m³"]
["Filtratie:",null,"Micromol"]
[]
["Kosten aankoop techniek (en installatie?)"]
[null,"Aanleg trayveld",10,"€/m²",{"$f":"$B$33*C42","v":100000},"€","Wat valt hieronder? Moeten we dit meenemen of maken ondernemers deze kosten sowieso los van de techniek voor recirculatie","Deze regel niet opnemen"]
[null,"Voorput",null,null,1845,"€"]
[null,"Pomp in voorput",null,null,7315,"€"]
["Nee","Regeling overloop voorput",null,null,0,"€","Optioneel?"]
[null,"Zeefbocht",null,null,6525,"€"]
[null,"Vuile drain bassin",null,null,4934,"€"]
[null,"Trage zandfilter",null,null,40170,"€","(min. 3m³/u UF-unit)"]
["Nee","Verwijdering GBM",null,null,0,"€","(prijs Hortimax-unit op basis van UV en H202) / Optioneel?"]
[null,"Propere drain",null,null,0,"€"]
[null,"Bassin",null,null,11920,"€"]
["Ja","Beregeningspomp",null,null,7000,"€","Optioneel?"]
["Nee","Installatie bijmenging gift",null,null,0,"€","Optioneel?"]
[null,"Totaal aankoop techniek (en installatie?)",null,null,{"$f":"SUM(E42:E53)","v":179709},"€"]
[]
["Kosten onderhoud"]
[null,"Onderhoudskosten",null,null,null,null,"Wat valt hier allemaal onder?"]
[null,"Vervanging onderdelen (<technische levensduur)"]
[null,"Kosten arbeid"]
[null,"Totaal kosten onderhoud (jaarlijks)"]
[]
["Kosten verbruik"]
[null,"Verbruik …(doeken?)",null,null,null,null,"Wat valt hier allemaal onder?"]
[null,"Monsterafname"]
[null,"Totaal kosten verbruik (jaarlijks)"]
[]
["Kosten arbeid"]
[null,"Kwaliteitscontrole",null,null,null,null,"Wat valt hier allemaal onder?"]
[null,"Bediening installatie"]
[null,"Totaal kosten arbeid (jaarlijks)"]
[]
["Besparingen"]
[null,"Besparing oppompen grondwater (België)",null,null,null,null,"Wat valt hier allemaal onder? Is besparing concreet te maken?"]
[null,"Besparing gebruik nutriënten"]
[null,"Duurzaamheid (waarde aan te hechten)"]
[null,"Totaal besparingen (jaarlijks)"]
[]
[null,"Eenmalige kosten aankoop",null,null,{"$f":"E54","v":179709},"€"]
[null,"Jaarlijkse kosten",null,null,{"$f":"E60+E65+E70-E76","v":0}]
[]
[null,"Plantdichtheid",null,null,38.5,"pl/m²"]
[null,"Afschrijvingstermijn",null,null,5,"jaar"]
[null,"Extra plantkosten",null,null,{"$f":"((E78/E82)+E79)/B33/E81","v":9.3355324675324675E-2},"€"]

{"sheet":"Kladblok","index":1,"n_rows":15,"n_cols":21,"rows_kept":15,"cut":false,"hidden":true,"merged":[]}
[]
[]
[]
[]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0.5,1,2.5,5]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Vuile drain opslagm3",50,100,250,500]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Propere drain opslag m3",200,400,1000,2000]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Ontsmettingstechniek m3/uur",1.5,3,8.5,15]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Voorput pomp m3/uur",15,30,75,150]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Voorput opslag m3",5,10,25,50]
[]
[]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0.63,1.5,null,4.5999999999999996]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,1.2]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"4,4m","6,2m",null,"13m"]

{"sheet":"RECUPA Kostprijsberekening","index":2,"n_rows":49,"n_cols":7,"rows_kept":49,"cut":false,"hidden":false,"merged":[[1,1,2,5]]}
[null,"RECUPA:"]
[null,"Kostprijsberekening* Voorfiltratie en Ontsmettingstechnieken op Aardbeitrayvelden"]
[]
[]
["Stap","1. Input"]
[null,"Systeeminput en uitgangspunten"]
[null,"Oppervlakte","ha",2.5]
[null,"Plantdichtheid","pl/m2",50]
[null,"Voorput opslag**","m³",25,{"$f":"IF($D$7<1,\"Advies: Minimale opslag van 5m3 bij deze oppervlakte\",IF($D$7<2.5,\"Advies: Minimale opslag van 10m3 bij deze oppervlakte\",IF($D$7<5,\"Advies: Minimale opslag van 25m3 bij deze oppervlakte\",IF($D$7=5,\"Advies: Minimale opslag van 50m3 bij deze oppervlakte\"))))","v":"Advies: Minimale opslag van 25m3 bij deze oppervlakte"}]
[null,"Vuile drain opslag**","m³",250,{"$f":"IF($D$7<1,\"Advies: Minimale opslag van 50m3 bij deze oppervlakte\",IF($D$7<2.5,\"Advies: Minimale opslag van 100m3 bij deze oppervlakte\",IF($D$7<5,\"Advies: Minimale opslag van 250m3 bij deze oppervlakte\",IF($D$7=5,\"Advies: Minimale opslag van 500m3 bij deze oppervlakte\"))))","v":"Advies: Minimale opslag van 250m3 bij deze oppervlakte"}]
[null,"Propere drain opslag**","m³",1000,{"$f":"IF($D$7<1,\"Advies: Minimale opslag van 200m3 bij deze oppervlakte\",IF($D$7<2.5,\"Advies: Minimale opslag van 400m3 bij deze oppervlakte\",IF($D$7<5,\"Advies: Minimale opslag van 1000m3 bij deze oppervlakte\",IF($D$7=5,\"Advies: Minimale opslag van 2000m3 bij deze oppervlakte\"))))","v":"Advies: Minimale opslag van 1000m3 bij deze oppervlakte"}]
[null,"Ontsmettingstechniek","m³/u",8.5,{"$f":"IF($D$7<1,\"Advies: Minimale capaciteit van 1,5m3/uur bij deze oppervlakte\",IF($D$7<2.5,\"Advies: Minimale capaciteit van 3m3/uur bij deze oppervlakte\",IF($D$7<5,\"Advies: Minimale capaciteit van 8,5m3/uur bij deze oppervlakte\",IF($D$7=5,\"Advies: Minimale capaciteit van 15m3/uur bij deze oppervlakte\"))))","v":"Advies: Minimale capaciteit van 8,5m3/uur bij deze oppervlakte"}]
[null,"Voorput pomp**","m³/u",75,{"$f":"IF($D$7<1,\"Advies: Minimale capaciteit van 15m3/uur bij deze oppervlakte\",IF($D$7<2.5,\"Advies: Minimale capaciteit van 30m3/uur bij deze oppervlakte\",IF($D$7<5,\"Advies: Minimale capaciteit van 75m3/uur bij deze oppervlakte\",IF($D$7=5,\"Advies: Minimale capaciteit van 150m3/uur bij deze oppervlakte\"))))","v":"Advies: Minimale capaciteit van 75m3/uur bij deze oppervlakte"}]
[]
[null,"Finaciële input"]
[null,"Afschijvingtermijn","Jaren",10]
[null,"Leenrente","%",3]
[]
["Eenmalige kosten",null,"€",{"$f":"SUM(D20:D23)","v":36700}]
[null,"Voorput incl. coating","€",{"$f":"'Samenvatting kosten'!H61","v":4500}]
[null,"Vuile drain opslag","€",{"$f":"'Samenvatting kosten'!H62","v":7700}]
[null,"Propere drain opslag","€",{"$f":"'Samenvatting kosten'!H63","v":18200}]
[null,"Voorput pomp","€",{"$f":"'Samenvatting kosten'!H64","v":6300}]
["Totaal kosten per jaar",null,"€",{"$f":"(D19/$D$16)","v":3670}]
["Extra plantkosten/jaar","Extra plantkosten/jaar","€",{"$f":"D24/($D$8*10000*D7)","v":2.9359999999999998E-3}]
[]
["Stap","2. Voorfiltratie",null,"Trommelfilter","Trilzeef","Zeefbocht","Doekenfilter"]
["Eenmalige kosten","Investering techniek incl. bijkomende investeringen","€",{"$f":"SUM(D29:D29)","v":39158},{"$f":"SUM(E29:E29)","v":7550},{"$f":"SUM(F29:F29)","v":8500},{"$f":"SUM(G29:G29)","v":5400}]
[null,"Voorfiltratie","€",{"$f":"'Samenvatting kosten'!H7","v":39158},{"$f":"'Samenvatting kosten'!H8","v":7550},{"$f":"'Samenvatting kosten'!H9","v":8500},{"$f":"'Samenvatting kosten'!H10","v":5400}]
["Jaarlijkse kosten","Saldo kosten per jaar","€/jaar",{"$f":"SUM(D31:D34)","v":5090.54},{"$f":"SUM(E31:E34)","v":981.5},{"$f":"SUM(F31:F34)","v":1105},{"$f":"SUM(G31:G34)","v":3202}]
[null,"Gebruikskosten (doeken, etc.)","€/jaar",{"$f":"'Samenvatting kosten'!H14","v":0},{"$f":"'Samenvatting kosten'!H15","v":0},{"$f":"'Samenvatting kosten'!H16","v":0},{"$f":"'Samenvatting kosten'!H17","v":2500}]
[null,"Overige kosten (onderhoud, elektra, etc.)","€/jaar",{"$f":"'Samenvatting kosten'!H21","v":0},{"$f":"'Samenvatting kosten'!H22","v":0},{"$f":"'Samenvatting kosten'!H23","v":0},{"$f":"'Samenvatting kosten'!H24","v":0}]
[null,"Rente","€/jaar",{"$f":"D28*$D$17/100","v":1174.74},{"$f":"E28*$D$17/100","v":226.5},{"$f":"F28*$D$17/100","v":255},{"$f":"G28*$D$17/100","v":162}]
[null,"Afschrijving","€/jaar",{"$f":"D28/$D$16","v":3915.8},{"$f":"E28/$D$16","v":755},{"$f":"F28/$D$16","v":850},{"$f":"G28/$D$16","v":540}]
["Totaal kosten per jaar",null,"€",{"$f":"(D28/$D$16)+D30","v":9006.34},{"$f":"(E28/$D$16)+E30","v":1736.5},{"$f":"(F28/$D$16)+F30","v":1955},{"$f":"(G28/$D$16)+G30","v":3742}]
["Extra plantkosten/jaar","Extra plantkosten/jaar","€",{"$f":"D35/($D$8*10000*$D$7)","v":7.2050719999999999E-3},{"$f":"E35/($D$8*10000*$D$7)","v":1.3891999999999999E-3},{"$f":"F35/($D$8*10000*$D$7)","v":1.5640000000000001E-3},{"$f":"G35/($D$8*10000*$D$7)","v":2.9935999999999999E-3}]
[]
["Stap","3. Ontsmetting",null,"Ozon","Waterstofperoxide","Trage zandfilter","Ultrafiltratie"]
["Eenmalige kosten","Investering techniek incl. bijkomende investeringen","€",{"$f":"SUM(D40:D40)","v":90000},{"$f":"SUM(E40:E40)","v":10625},{"$f":"SUM(F40:F40)","v":50000},{"$f":"SUM(G40:G40)","v":47000}]
[null,"Ontsmettingstechniek","€",{"$f":"'Samenvatting kosten'!H30","v":90000},{"$f":"'Samenvatting kosten'!H31","v":10625},{"$f":"'Samenvatting kosten'!H32","v":50000},{"$f":"'Samenvatting kosten'!H33","v":47000}]
["Saldo kosten per jaar",null,"€/jaar",{"$f":"SUM(D42:D45)","v":11700},{"$f":"SUM(E42:E45)","v":14115},{"$f":"SUM(F42:F45)","v":7288.4},{"$f":"SUM(G42:G45)","v":6843.6397058823532}]
[null,"Gebruikskosten (H2O2, zuur, etc.)","€/jaar",{"$f":"'Samenvatting kosten'!H36","v":0},{"$f":"'Samenvatting kosten'!H37","v":11733.75},{"$f":"'Samenvatting kosten'!H38","v":0},{"$f":"'Samenvatting kosten'!H39","v":520}]
[null,"Overige kosten (onderhoud, elektra, etc.)","€/jaar",{"$f":"'Samenvatting kosten'!H42","v":0},{"$f":"'Samenvatting kosten'!H43","v":1000},{"$f":"'Samenvatting kosten'!H44","v":788.39999999999986},{"$f":"'Samenvatting kosten'!H45","v":213.63970588235293}]
[null,"Rente","€/jaar",{"$f":"D39*$D$17/100","v":2700},{"$f":"E39*$D$17/100","v":318.75},{"$f":"F39*$D$17/100","v":1500},{"$f":"G39*$D$17/100","v":1410}]
[null,"Afschrijving","€/jaar",{"$f":"D39/$D$16","v":9000},{"$f":"E39/$D$16","v":1062.5},{"$f":"F39/$D$16","v":5000},{"$f":"G39/$D$16","v":4700}]
["Totaal kosten per jaar",null,"€",{"$f":"(D39/$D$16)+D41","v":20700},{"$f":"(E39/$D$16)+E41","v":15177.5},{"$f":"(F39/$D$16)+F41","v":12288.4},{"$f":"(G39/$D$16)+G41","v":11543.639705882353}]
["Extra plantkosten/jaar","Extra plantkosten/jaar","€",{"$f":"D46/($D$8*10000*$D$7)","v":1.6559999999999998E-2},{"$f":"E46/($D$8*10000*$D$7)","v":1.2142E-2},{"$f":"F46/($D$8*10000*$D$7)","v":9.8307199999999994E-3},{"$f":"G46/($D$8*10000*$D$7)","v":9.2349117647058821E-3}]
["*) Aan deze berekening kunnen geen rechten worden ontleend en is enkel indicatief. Voor een juiste berekening voor een specifiek bedrijf is altijd maatwerk vereist."]
["**) Minimale vereiste capaciteiten zijn afhankelijk van de in jouw regio geldende regelgeving. Weten hoe het in jouw regio is? Neem dan contact op met het Waterschap of PCH."]

{"sheet":"Grafieken","index":3,"n_rows":41,"n_cols":9,"rows_kept":41,"cut":false,"hidden":true,"merged":[]}
[]
[]
[]
[]
[null,null,null,null,"Extra plantkosten/jaar"]
[null,null,null,null,null,"0,5 ha","1 ha","2,5 ha","5 ha"]
[null,null,null,null,"Voorput/opslag/pomp",5.7800000000000004E-3,4.2399999999999998E-3,2.9359999999999998E-3,2.6800000000000001E-3]
[null,null,null,null,"Trommelfilter",2.1758E-2,1.362152E-2,7.2050719999999999E-3,7.1382800000000003E-3]
[null,null,null,null,"Trilzeef",6.9459999999999999E-3,3.473E-3,1.3891999999999999E-3,6.9459999999999997E-4]
[null,null,null,null,"Zeefbocht",5.0600000000000003E-3,3.2200000000000002E-3,1.5640000000000001E-3,9.2000000000000003E-4]
[null,null,null,null,"Doekenfilter",6.8300000000000001E-3,4.4149999999999997E-3,2.9935999999999999E-3,2.5106E-3]
[null,null,null,null,"Ozon",5.3359999999999998E-2,3.082E-2,1.6559999999999998E-2,1.38E-2]
[null,null,null,null,"Waterstofperoxide",2.5139999999999999E-2,1.8783599999999998E-2,1.2142E-2,1.3805100000000001E-2]
[null,null,null,null,"Trage zandfilter",2.2917400000000001E-2,1.6379000000000001E-2,9.8307199999999994E-3,7.7279200000000001E-3]
[null,null,null,null,"Ultrafiltratie",2.0695599999999998E-2,1.210375E-2,9.2349117647058821E-3,7.06545E-3]
[]
[]
[]
[]
[]
[]
[null,null,null,null,null,"0,5 ha","1 ha","2,5 ha","5 ha"]
[null,null,null,null,"Trommelfilter",2.1758E-2,1.362152E-2,7.2050719999999999E-3,7.1382800000000003E-3]
[null,null,null,null,"Trilzeef",6.9459999999999999E-3,3.473E-3,1.3891999999999999E-3,6.9459999999999997E-4]
[null,null,null,null,"Zeefbocht",5.0600000000000003E-3,3.2200000000000002E-3,1.5640000000000001E-3,9.2000000000000003E-4]
[null,null,null,null,"Doekenfilter",6.8300000000000001E-3,3.4150000000000001E-3,2.9935999999999999E-3,7.1060000000000003E-4]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[null,null,null,null,null,"0,5 ha","1 ha","2,5 ha","5 ha"]
[null,null,null,null,"Ozon",5.3359999999999998E-2,3.082E-2,1.6559999999999998E-2,1.38E-2]
[null,null,null,null,"Waterstofperoxide",2.5139999999999999E-2,1.8783599999999998E-2,1.2142E-2,1.3805100000000001E-2]
[null,null,null,null,"Trage zandfilter",2.2917400000000001E-2,1.6379000000000001E-2,9.8307199999999994E-3,7.7279200000000001E-3]
[null,null,null,null,"Ultrafiltratie",2.0695599999999998E-2,1.210375E-2,9.2349117647058821E-3,7.06545E-3]

{"sheet":"Opbouw kosten","index":4,"n_rows":73,"n_cols":24,"rows_kept":73,"cut":false,"hidden":true,"merged":[]}
[]
[]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,1.5,3,null,15]
[]
[null,null,"2. Voorfiltratie",null,"Trommelfilter","Trommelfilter","Trommelfilter","Trommelfilter",null,"Trilzeef","Trilzeef","Trilzeef","Trilzeef",null,"Zeefbocht","Zeefbocht","Zeefbocht","Zeefbocht",null,"Doekenfilter","Doekenfilter","Doekenfilter","Doekenfilter"]
[null,null,"Hectare","Kostenpost",0.5,1,2.5,5,"Kostenpost",0.5,1,2.5,5,"Kostenpost",0.5,1,2.5,5,"Kostenpost",0.5,1,2.5,5]
[null,null,"Investering (eenmalig)","Trommelfilter",22000,27500,35000,70000,"Trilzeef 7-28m3/uur",7550,7550,7550,7550,"Zeefbocht (500 micron)",5500,7000,8500,10000,"Doekfilter",5250,5250,5400,5550,"analoog aan onderstaande. Lijkt me raar dat een zeefbocht 10000 euro kost voor 5ha terwijl een doekenfilter maar de helft kost. Terwijl dit een duurder toestel lijkt -> meer electronica etc. ook voor trilzeef nog eens bekijken?"]
[null,null,null,"Pomp",{"$f":"2500*66%","v":1650},{"$f":"3200*66%","v":2112},{"$f":"6300*66%","v":4158},{"$f":"11500*66%","v":7590}]
[]
[]
[]
[]
[]
[]
[]
[null,null,"Totaal",null,{"$f":"SUM(E7:E15)","v":23650},{"$f":"SUM(F7:F15)","v":29612},{"$f":"SUM(G7:G15)","v":39158},{"$f":"SUM(H7:H15)","v":77590},null,{"$f":"SUM(J7:J15)","v":7550},7550,7550,7550,null,{"$f":"SUM(O7:O15)","v":5500},7000,8500,10000,null,{"$f":"SUM(T7:T15)","v":5250},5250,5400,5550]
[]
[null,null,"Gebruikskosten per jaar",null,null,null,null,null,null,null,null,null,null,null,0,0,null,0,"Doek",500,1000,2500,5000,"ik zou hier precies meer doek voorzien moet volgens mij evenredig met volume water omhoog gaan - hoeveel te meer water er door moet hoeveel te meer doek je verbruikt"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"500€ nemen als start voor 0.5 ha?en dan verder opbouwen?"]
[]
[]
[]
[]
[]
[null,null,"Totaal",null,{"$f":"SUM(E18:E24)","v":0},{"$f":"SUM(F18:F24)","v":0},{"$f":"SUM(G18:G24)","v":0},{"$f":"SUM(H18:H24)","v":0},null,{"$f":"SUM(J18:J24)","v":0},{"$f":"SUM(K18:K24)","v":0},{"$f":"SUM(L18:L24)","v":0},{"$f":"SUM(M18:M24)","v":0},null,{"$f":"SUM(O18:O24)","v":0},{"$f":"SUM(P18:P24)","v":0},{"$f":"SUM(Q18:Q24)","v":0},{"$f":"SUM(R18:R24)","v":0},null,{"$f":"SUM(T18:T24)","v":500},{"$f":"SUM(U18:U24)","v":1000},{"$f":"SUM(V18:V24)","v":2500},{"$f":"SUM(W18:W24)","v":5000}]
[]
[null,null,"Overige kosten per jaar",null,null,null,null,null,null,null,null,null,null,null,0,0,null,0]
[]
[]
[]
[]
[]
[]
[null,null,"Totaal",null,{"$f":"SUM(E27:E33)","v":0},{"$f":"SUM(F27:F33)","v":0},{"$f":"SUM(G27:G33)","v":0},{"$f":"SUM(H27:H33)","v":0},null,{"$f":"SUM(J27:J33)","v":0},{"$f":"SUM(K27:K33)","v":0},{"$f":"SUM(L27:L33)","v":0},{"$f":"SUM(M27:M33)","v":0},null,{"$f":"SUM(O27:O33)","v":0},{"$f":"SUM(P27:P33)","v":0},{"$f":"SUM(Q27:Q33)","v":0},{"$f":"SUM(R27:R33)","v":0},null,{"$f":"SUM(T27:T33)","v":0},{"$f":"SUM(U27:U33)","v":0},{"$f":"SUM(V27:V33)","v":0},{"$f":"SUM(W27:W33)","v":0}]
[]
[]
[]
[null,null,"3. Ontsmetting",null,"Ozon","Ozon","Ozon","Ozon",null,"Waterstofperoxide","Waterstofperoxide","Waterstofperoxide","Waterstofperoxide",null,"Trage zandfilter","Trage zandfilter","Trage zandfilter","Trage zandfilter",null,"Ultrafiltratie","Ultrafiltratie","Ultrafiltratie","Ultrafiltratie"]
[null,null,"Hectare","Kostenpost",0.5,1,2.5,5,"Kostenpost",0.5,1,2.5,5,"Kostenpost",0.5,1,2.5,5,"Kostenpost",0.5,1,2.5,5]
[null,null,"Investering (eenmalig)","Ozon (Compleet)",58000,67000,90000,150000,"Aanschaf apparatuur ",8500,8500,{"$f":"8500*1.25","v":10625},{"$f":"8500*1.75","v":14875},null,null,null,null,null,"NUF 2MCM (2 m3/h) unit: 450100002 Incl. pomp + frequentieregelaar en (semi-automatisch) voorfilter",17500]
[null,null,null,null,null,null,null,null,"(Bron OPEX)",null,null,null,null,null,null,null,null,null,"NUF 2MCM (3 m3/h) unit Incl. pomp + frequentieregelaar en (semi-automatisch) voorfilter:",null,20500]
[null,null,null,null,null,null,null,null,"(doseerpomp, doseervat, meet en regelpaneel)",null,null,null,null,null,null,null,null,null,"NUF 10MCM (10 m3/h) unit: 450100010",null,null,47000]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"NUF 15MCM (15 m3/h) unit: Incl. pomp + frequentieregelaar en (automatisch) voorfilter",null,null,null,61500]
[]
[null,null,null,null,null,null,null,null,null,null,null,null,null,"TZF",22625,32750,50000,80000]
[]
[]
[]
[]
[]
[null,null,"Totaal",null,{"$f":"SUM(E40:E50)","v":58000},{"$f":"SUM(F40:F50)","v":67000},{"$f":"SUM(G40:G50)","v":90000},{"$f":"SUM(H40:H50)","v":150000},null,{"$f":"SUM(J40:J50)","v":8500},{"$f":"SUM(K40:K50)","v":8500},{"$f":"SUM(L40:L50)","v":10625},{"$f":"SUM(M40:M50)","v":14875},null,{"$f":"SUM(O40:O50)","v":22625},{"$f":"SUM(P40:P50)","v":32750},{"$f":"SUM(Q40:Q50)","v":50000},{"$f":"SUM(R40:R50)","v":80000},null,{"$f":"SUM(T40:T50)","v":17500},{"$f":"SUM(U40:U50)","v":20500},{"$f":"SUM(V40:V50)","v":47000},{"$f":"SUM(W40:W50)","v":61500}]
[]
[null,null,"Gebruikskosten per jaar",null,null,null,null,null,null,null,null,null,null,"Gebruikerskosten",0,0,null,0,"Natriumhypochloriet",{"$f":"(52/2.5)*15","v":312},{"$f":"(52/2.5)*15","v":312},{"$f":"(52/1.5)*15","v":520},{"$f":"52*15","v":780}]
[]
[]
[null,null,null,null,null,null,null,null,"Roam Technology",3330,6436.8,{"$f":"18625*0.63","v":11733.75},30091.5]
[]
[]
[]
[]
[]
[null,null,"Totaal",null,{"$f":"SUM(E53:E61)","v":0},{"$f":"SUM(F53:F61)","v":0},{"$f":"SUM(G53:G61)","v":0},{"$f":"SUM(H53:H61)","v":0},null,{"$f":"SUM(J53:J61)","v":3330},6436.8,11733.75,{"$f":"SUM(M53:M61)","v":30091.5},null,{"$f":"SUM(O53:O61)","v":0},0,0,{"$f":"SUM(R53:R61)","v":0},null,{"$f":"SUM(T53:T61)","v":312},{"$f":"SUM(U53:U61)","v":312},{"$f":"SUM(V53:V61)","v":520},{"$f":"SUM(W53:W61)","v":780}]
[]
[null,null,"Overige kosten per jaar","Compressor",null,null,null,0,"Onderhoud",1000,1000,1000,1000,"Energiekosten",null,null,null,null,"Stroom  draaiuren*kwh prijs"]
[null,null,null,"Onderhoudskosten",null,null,null,0,"(Bron OPEX)",null,null,null,null,"TZF 2.60 meter 0.40 kW/uur ",{"$f":"0.4*24*365*Stroom!$D$24","v":525.6},null,null,null,"NUF 2 MCM (2 m3/h) 0,37 kw",{"$f":"0.37*Stroom!D7*Stroom!D24","v":136.89999999999998}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,"TZF 4.00 meter 0.50 kW/uur ",null,{"$f":"0.5*24*365*Stroom!$D$24","v":657},null,null,"NUF 2 MCM (3 m3/h) 0,55 kw",null,{"$f":"0.55*Stroom!E7*Stroom!D24","v":204.87500000000003}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,"TZF 7.04 meter 0.70 kW/uur ",null,null,null,{"$f":"0.7*24*365*Stroom!$D$24","v":919.79999999999984},"NUF 15 MCM (15 m3/h) 0,75 kw",null,null,null,{"$f":"0.75*Stroom!G7*Stroom!D24","v":278.625}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"0.6*24*365*Stroom!$D$24","v":788.39999999999986},null,"NUF 10MCM (10 m3/h) 0,65 kw",null,null,{"$f":"0.65*Stroom!F7*Stroom!D24","v":213.63970588235293}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Onderhoudskosten (4%)",{"$f":"T40*0.04","v":700},{"$f":"U41*0.04","v":820},null,{"$f":"W43*0.04","v":2460}]
[]
[]
[]
[null,null,"Totaal",null,{"$f":"SUM(E64:E72)","v":0},{"$f":"SUM(F64:F72)","v":0},{"$f":"SUM(G64:G72)","v":0},{"$f":"SUM(H64:H72)","v":0},null,{"$f":"SUM(J64:J72)","v":1000},{"$f":"SUM(K64:K72)","v":1000},{"$f":"SUM(L64:L72)","v":1000},{"$f":"SUM(M64:M72)","v":1000},null,{"$f":"SUM(O64:O72)","v":525.6},{"$f":"SUM(P64:P72)","v":657},{"$f":"SUM(Q64:Q72)","v":788.39999999999986},{"$f":"SUM(R64:R72)","v":919.79999999999984},null,{"$f":"SUM(T64:T72)","v":836.9},{"$f":"SUM(U64:U72)","v":1024.875},{"$f":"SUM(V64:V72)","v":213.63970588235293},{"$f":"SUM(W64:W72)","v":2738.625}]

{"sheet":"Samenvatting kosten","index":5,"n_rows":64,"n_cols":9,"rows_kept":64,"cut":false,"hidden":true,"merged":[]}
["opp",0.5,1,2.5,5,"te zoeken waarde"]
["index",1,2,3,4,{"$f":"HLOOKUP(H6,B1:E2,2,TRUE)","v":3}]
["opp",{"$f":"B1","v":0.5},{"$f":"C1","v":1},{"$f":"D1","v":2.5},5]
[]
["Voorfiltratie",null,null,null,null,"min","max","interpolatie"]
["Investering techniek incl. bijkomende investeringen",0.5,1,2.5,5,{"$f":"HLOOKUP(F2,B2:E3,2,FALSE)","v":2.5},{"$f":"IF(H6=B6,B6,IF(H6=C6,C6,IF(H6=D6,D6,IF(H6=E6,E6,HLOOKUP(F2+1,B2:E3,2,TRUE)))))","v":2.5},{"$f":"'RECUPA Kostprijsberekening'!D7","v":2.5}]
["Trommelfilter",{"$f":"'Opbouw kosten'!E16","v":23650},{"$f":"'Opbouw kosten'!F16","v":29612},{"$f":"'Opbouw kosten'!G16","v":39158},{"$f":"'Opbouw kosten'!H16","v":77590},{"$f":"HLOOKUP(F$6,$B$6:$E$10,2,FALSE)","v":39158},{"$f":"HLOOKUP(G$6,$B$6:$E$10,2,FALSE)","v":39158},{"$f":"IF(AND($F$6=$H$6,$G$6=$H$6),$F7,_xlfn.FORECAST.LINEAR($H$6,$F7:$G7,$F$6:$G$6))","v":39158},29612]
["Trilzeef",{"$f":"'Opbouw kosten'!J16","v":7550},{"$f":"'Opbouw kosten'!K16","v":7550},{"$f":"'Opbouw kosten'!L16","v":7550},{"$f":"'Opbouw kosten'!M16","v":7550},{"$f":"HLOOKUP(F$6,$B$6:$E$10,3,FALSE)","v":7550},{"$f":"HLOOKUP(G$6,$B$6:$E$10,3,FALSE)","v":7550},{"$f":"IF(AND($F$6=$H$6,$G$6=$H$6),$F8,_xlfn.FORECAST.LINEAR($H$6,$F8:$G8,$F$6:$G$6))","v":7550}]
["Zeefbocht",{"$f":"'Opbouw kosten'!O16","v":5500},{"$f":"'Opbouw kosten'!P16","v":7000},{"$f":"'Opbouw kosten'!Q16","v":8500},{"$f":"'Opbouw kosten'!R16","v":10000},{"$f":"HLOOKUP(F$6,$B$6:$E$10,4,FALSE)","v":8500},{"$f":"HLOOKUP(G$6,$B$6:$E$10,4,FALSE)","v":8500},{"$f":"IF(AND($F$6=$H$6,$G$6=$H$6),$F9,_xlfn.FORECAST.LINEAR($H$6,$F9:$G9,$F$6:$G$6))","v":8500}]
["Doekenfilter",{"$f":"'Opbouw kosten'!T16","v":5250},{"$f":"'Opbouw kosten'!U16","v":5250},{"$f":"'Opbouw kosten'!V16","v":5400},{"$f":"'Opbouw kosten'!W16","v":5550},{"$f":"HLOOKUP(F$6,$B$6:$E$10,5,FALSE)","v":5400},{"$f":"HLOOKUP(G$6,$B$6:$E$10,5,FALSE)","v":5400},{"$f":"IF(AND($F$6=$H$6,$G$6=$H$6),$F10,_xlfn.FORECAST.LINEAR($H$6,$F10:$G10,$F$6:$G$6))","v":5400}]
[]
[]
["Gebruikskosten (doeken, etc.)",0.5,1,2.5,5]
["Trommelfilter",{"$f":"'Opbouw kosten'!E25","v":0},{"$f":"'Opbouw kosten'!F25","v":0},{"$f":"'Opbouw kosten'!G25","v":0},{"$f":"'Opbouw kosten'!H25","v":0},{"$f":"HLOOKUP(F$6,$B$13:$E$17,2,FALSE)","v":0},{"$f":"HLOOKUP(G$6,$B$13:$E$17,2,FALSE)","v":0},{"$f":"IF(AND($F$6=$H$6,$G$6=$H$6),$F14,_xlfn.FORECAST.LINEAR($H$6,$F14:$G14,$F$6:$G$6))","v":0}]
["Trilzeef",{"$f":"'Opbouw kosten'!J25","v":0},{"$f":"'Opbouw kosten'!K25","v":0},{"$f":"'Opbouw kosten'!L25","v":0},{"$f":"'Opbouw kosten'!M25","v":0},{"$f":"HLOOKUP(F$6,$B$13:$E$17,3,FALSE)","v":0},{"$f":"HLOOKUP(G$6,$B$13:$E$17,3,FALSE)","v":0},{"$f":"IF(AND($F$6=$H$6,$G$6=$H$6),$F15,_xlfn.FORECAST.LINEAR($H$6,$F15:$G15,$F$6:$G$6))","v":0}]
["Zeefbocht",{"$f":"'Opbouw kosten'!O25","v":0},{"$f":"'Opbouw kosten'!P25","v":0},{"$f":"'Opbouw kosten'!Q25","v":0},{"$f":"'Opbouw kosten'!R25","v":0},{"$f":"HLOOKUP(F$6,$B$13:$E$17,4,FALSE)","v":0},{"$f":"HLOOKUP(G$6,$B$13:$E$17,4,FALSE)","v":0},{"$f":"IF(AND($F$6=$H$6,$G$6=$H$6),$F16,_xlfn.FORECAST.LINEAR($H$6,$F16:$G16,$F$6:$G$6))","v":0}]
["Doekenfilter",{"$f":"'Opbouw kosten'!T25","v":500},{"$f":"'Opbouw kosten'!U25","v":1000},{"$f":"'Opbouw kosten'!V25","v":2500},{"$f":"'Opbouw kosten'!W25","v":5000},{"$f":"HLOOKUP(F$6,$B$13:$E$17,5,FALSE)","v":2500},{"$f":"HLOOKUP(G$6,$B$13:$E$17,5,FALSE)","v":2500},{"$f":"IF(AND($F$6=$H$6,$G$6=$H$6),$F17,_xlfn.FORECAST.LINEAR($H$6,$F17:$G17,$F$6:$G$6))","v":2500}]
[]
[]
["Overige kosten (onderhoud, elektra, etc.)",0.5,1,2.5,5]
["Trommelfilter",{"$f":"'Opbouw kosten'!E34","v":0},{"$f":"'Opbouw kosten'!F34","v":0},{"$f":"'Opbouw kosten'!G34","v":0},{"$f":"'Opbouw kosten'!H34","v":0},{"$f":"HLOOKUP(F$6,$B$20:$E$24,2,FALSE)","v":0},{"$f":"HLOOKUP(G$6,$B$20:$E$24,2,FALSE)","v":0},{"$f":"IF(AND($F$6=$H$6,$G$6=$H$6),$F21,_xlfn.FORECAST.LINEAR($H$6,$F21:$G21,$F$6:$G$6))","v":0}]
["Trilzeef",{"$f":"'Opbouw kosten'!J34","v":0},{"$f":"'Opbouw kosten'!K34","v":0},{"$f":"'Opbouw kosten'!L34","v":0},{"$f":"'Opbouw kosten'!M34","v":0},{"$f":"HLOOKUP(F$6,$B$20:$E$24,3,FALSE)","v":0},{"$f":"HLOOKUP(G$6,$B$20:$E$24,3,FALSE)","v":0},{"$f":"IF(AND($F$6=$H$6,$G$6=$H$6),$F22,_xlfn.FORECAST.LINEAR($H$6,$F22:$G22,$F$6:$G$6))","v":0}]
["Zeefbocht",{"$f":"'Opbouw kosten'!O34","v":0},{"$f":"'Opbouw kosten'!P34","v":0},{"$f":"'Opbouw kosten'!Q34","v":0},{"$f":"'Opbouw kosten'!R34","v":0},{"$f":"HLOOKUP(F$6,$B$20:$E$24,4,FALSE)","v":0},{"$f":"HLOOKUP(G$6,$B$20:$E$24,4,FALSE)","v":0},{"$f":"IF(AND($F$6=$H$6,$G$6=$H$6),$F23,_xlfn.FORECAST.LINEAR($H$6,$F23:$G23,$F$6:$G$6))","v":0}]
["Doekenfilter",{"$f":"'Opbouw kosten'!T34","v":0},{"$f":"'Opbouw kosten'!U34","v":0},{"$f":"'Opbouw kosten'!V34","v":0},{"$f":"'Opbouw kosten'!W34","v":0},{"$f":"HLOOKUP(F$6,$B$20:$E$24,5,FALSE)","v":0},{"$f":"HLOOKUP(G$6,$B$20:$E$24,5,FALSE)","v":0},{"$f":"IF(AND($F$6=$H$6,$G$6=$H$6),$F24,_xlfn.FORECAST.LINEAR($H$6,$F24:$G24,$F$6:$G$6))","v":0}]
[]
[]
[]
["Ontsmetting"]
["Investering techniek incl. bijkomende investeringen",0.5,1,2.5,5]
["Ozon",{"$f":"'Opbouw kosten'!E51","v":58000},{"$f":"'Opbouw kosten'!F51","v":67000},{"$f":"'Opbouw kosten'!G51","v":90000},{"$f":"'Opbouw kosten'!H51","v":150000},{"$f":"HLOOKUP(F$6,$B$29:$E$33,2,FALSE)","v":90000},{"$f":"HLOOKUP(G$6,$B$29:$E$33,2,FALSE)","v":90000},{"$f":"IF(AND($F$6=$H$6,$G$6=$H$6),$F30,_xlfn.FORECAST.LINEAR($H$6,$F30:$G30,$F$6:$G$6))","v":90000}]
["Waterstofperoxide",{"$f":"'Opbouw kosten'!J51","v":8500},{"$f":"'Opbouw kosten'!K51","v":8500},{"$f":"'Opbouw kosten'!L51","v":10625},{"$f":"'Opbouw kosten'!M51","v":14875},{"$f":"HLOOKUP(F$6,$B$29:$E$33,3,FALSE)","v":10625},{"$f":"HLOOKUP(G$6,$B$29:$E$33,3,FALSE)","v":10625},{"$f":"IF(AND($F$6=$H$6,$G$6=$H$6),$F31,_xlfn.FORECAST.LINEAR($H$6,$F31:$G31,$F$6:$G$6))","v":10625}]
["Trage zandfilter",{"$f":"'Opbouw kosten'!O51","v":22625},{"$f":"'Opbouw kosten'!P51","v":32750},{"$f":"'Opbouw kosten'!Q51","v":50000},{"$f":"'Opbouw kosten'!R51","v":80000},{"$f":"HLOOKUP(F$6,$B$29:$E$33,4,FALSE)","v":50000},{"$f":"HLOOKUP(G$6,$B$29:$E$33,4,FALSE)","v":50000},{"$f":"IF(AND($F$6=$H$6,$G$6=$H$6),$F32,_xlfn.FORECAST.LINEAR($H$6,$F32:$G32,$F$6:$G$6))","v":50000}]
["Ultrafiltratie",{"$f":"'Opbouw kosten'!T51","v":17500},{"$f":"'Opbouw kosten'!U51","v":20500},{"$f":"'Opbouw kosten'!V51","v":47000},{"$f":"'Opbouw kosten'!W51","v":61500},{"$f":"HLOOKUP(F$6,$B$29:$E$33,5,FALSE)","v":47000},{"$f":"HLOOKUP(G$6,$B$29:$E$33,5,FALSE)","v":47000},{"$f":"IF(AND($F$6=$H$6,$G$6=$H$6),$F33,_xlfn.FORECAST.LINEAR($H$6,$F33:$G33,$F$6:$G$6))","v":47000}]
[]
["Gebruikskosten (H2O2, zuur, etc.)",0.5,1,2.5,5]
["Ozon",{"$f":"'Opbouw kosten'!E62","v":0},{"$f":"'Opbouw kosten'!F62","v":0},{"$f":"'Opbouw kosten'!G62","v":0},{"$f":"'Opbouw kosten'!H62","v":0},{"$f":"HLOOKUP(F$6,$B$35:$E$39,2,FALSE)","v":0},{"$f":"HLOOKUP(G$6,$B$35:$E$39,2,FALSE)","v":0},{"$f":"IF(AND($F$6=$H$6,$G$6=$H$6),$F36,_xlfn.FORECAST.LINEAR($H$6,$F36:$G36,$F$6:$G$6))","v":0}]
["Waterstofperoxide",{"$f":"'Opbouw kosten'!J62","v":3330},{"$f":"'Opbouw kosten'!K62","v":6436.8},{"$f":"'Opbouw kosten'!L62","v":11733.75},{"$f":"'Opbouw kosten'!M62","v":30091.5},{"$f":"HLOOKUP(F$6,$B$35:$E$39,3,FALSE)","v":11733.75},{"$f":"HLOOKUP(G$6,$B$35:$E$39,3,FALSE)","v":11733.75},{"$f":"IF(AND($F$6=$H$6,$G$6=$H$6),$F37,_xlfn.FORECAST.LINEAR($H$6,$F37:$G37,$F$6:$G$6))","v":11733.75}]
["Trage zandfilter",{"$f":"'Opbouw kosten'!O62","v":0},{"$f":"'Opbouw kosten'!P62","v":0},{"$f":"'Opbouw kosten'!Q62","v":0},{"$f":"'Opbouw kosten'!R62","v":0},{"$f":"HLOOKUP(F$6,$B$35:$E$39,4,FALSE)","v":0},{"$f":"HLOOKUP(G$6,$B$35:$E$39,4,FALSE)","v":0},{"$f":"IF(AND($F$6=$H$6,$G$6=$H$6),$F38,_xlfn.FORECAST.LINEAR($H$6,$F38:$G38,$F$6:$G$6))","v":0}]
["Ultrafiltratie",{"$f":"'Opbouw kosten'!T62","v":312},{"$f":"'Opbouw kosten'!U62","v":312},{"$f":"'Opbouw kosten'!V62","v":520},{"$f":"'Opbouw kosten'!W62","v":780},{"$f":"HLOOKUP(F$6,$B$35:$E$39,5,FALSE)","v":520},{"$f":"HLOOKUP(G$6,$B$35:$E$39,5,FALSE)","v":520},{"$f":"IF(AND($F$6=$H$6,$G$6=$H$6),$F39,_xlfn.FORECAST.LINEAR($H$6,$F39:$G39,$F$6:$G$6))","v":520}]
[]
["Overige kosten (onderhoud, elektra, etc.)",0.5,1,2.5,5]
["Ozon",{"$f":"'Opbouw kosten'!E73","v":0},{"$f":"'Opbouw kosten'!F73","v":0},{"$f":"'Opbouw kosten'!G73","v":0},{"$f":"'Opbouw kosten'!H73","v":0},{"$f":"HLOOKUP(F$6,$B$41:$E$45,2,FALSE)","v":0},{"$f":"HLOOKUP(G$6,$B$41:$E$45,2,FALSE)","v":0},{"$f":"IF(AND($F$6=$H$6,$G$6=$H$6),$F42,_xlfn.FORECAST.LINEAR($H$6,$F42:$G42,$F$6:$G$6))","v":0}]
["Waterstofperoxide",{"$f":"'Opbouw kosten'!J73","v":1000},{"$f":"'Opbouw kosten'!K73","v":1000},{"$f":"'Opbouw kosten'!L73","v":1000},{"$f":"'Opbouw kosten'!M73","v":1000},{"$f":"HLOOKUP(F$6,$B$41:$E$45,3,FALSE)","v":1000},{"$f":"HLOOKUP(G$6,$B$41:$E$45,3,FALSE)","v":1000},{"$f":"IF(AND($F$6=$H$6,$G$6=$H$6),$F43,_xlfn.FORECAST.LINEAR($H$6,$F43:$G43,$F$6:$G$6))","v":1000}]
["Trage zandfilter",{"$f":"'Opbouw kosten'!O73","v":525.6},{"$f":"'Opbouw kosten'!P73","v":657},{"$f":"'Opbouw kosten'!Q73","v":788.39999999999986},{"$f":"'Opbouw kosten'!R73","v":919.79999999999984},{"$f":"HLOOKUP(F$6,$B$41:$E$45,4,FALSE)","v":788.39999999999986},{"$f":"HLOOKUP(G$6,$B$41:$E$45,4,FALSE)","v":788.39999999999986},{"$f":"IF(AND($F$6=$H$6,$G$6=$H$6),$F44,_xlfn.FORECAST.LINEAR($H$6,$F44:$G44,$F$6:$G$6))","v":788.39999999999986}]
["Ultrafiltratie",{"$f":"'Opbouw kosten'!T73","v":836.9},{"$f":"'Opbouw kosten'!U73","v":1024.875},{"$f":"'Opbouw kosten'!V73","v":213.63970588235293},{"$f":"'Opbouw kosten'!W73","v":2738.625},{"$f":"HLOOKUP(F$6,$B$41:$E$45,5,FALSE)","v":213.63970588235293},{"$f":"HLOOKUP(G$6,$B$41:$E$45,5,FALSE)","v":213.63970588235293},{"$f":"IF(AND($F$6=$H$6,$G$6=$H$6),$F45,_xlfn.FORECAST.LINEAR($H$6,$F45:$G45,$F$6:$G$6))","v":213.63970588235293}]
[]
[]
[null,1,2,3,4,"min","max","interpolatie","te zoeken waarde"]
["Keuze Voorput",5,10,25,50,{"$f":"HLOOKUP($I49,$B$48:$E$52,2,FALSE)","v":25},{"$f":"IF(H49=B49,B49,IF(H49=C49,C49,IF(H49=D49,D49,IF(H49=E49,E49,HLOOKUP(I49+1,$B$48:$E$52,2,TRUE)))))","v":25},{"$f":"'RECUPA Kostprijsberekening'!D9","v":25},{"$f":"HLOOKUP(H49,B49:E53,5,TRUE)","v":3}]
["Keuze Vuile drain",50,100,250,500,{"$f":"HLOOKUP($I50,$B$48:$E$52,3,FALSE)","v":250},{"$f":"IF(H50=B50,B50,IF(H50=C50,C50,IF(H50=D50,D50,IF(H50=E50,E50,HLOOKUP(I50+1,$B$48:$E$52,3,TRUE)))))","v":250},{"$f":"'RECUPA Kostprijsberekening'!D10","v":250},{"$f":"HLOOKUP(H50,B50:E53,4,TRUE)","v":3}]
["Keuze Propere Drain",200,400,1000,2000,{"$f":"HLOOKUP($I51,$B$48:$E$52,4,FALSE)","v":1000},{"$f":"IF(H51=B51,B51,IF(H51=C51,C51,IF(H51=D51,D51,IF(H51=E51,E51,HLOOKUP(I51+1,$B$48:$E$52,4,TRUE)))))","v":1000},{"$f":"'RECUPA Kostprijsberekening'!D11","v":1000},{"$f":"HLOOKUP(H51,B51:E53,3,TRUE)","v":3}]
["Keuze Voorput Pomp",15,30,75,150,{"$f":"HLOOKUP($I52,$B$48:$E$52,5,FALSE)","v":75},{"$f":"IF(H52=B52,B52,IF(H52=C52,C52,IF(H52=D52,D52,IF(H52=E52,E52,HLOOKUP(I52+1,$B$48:$E$52,5,TRUE)))))","v":75},{"$f":"'RECUPA Kostprijsberekening'!D13","v":75},{"$f":"HLOOKUP(H52,B52:E53,2,TRUE)","v":3}]
[null,1,2,3,4]
[]
["Bassins",0.5,1,2.5,5]
["Voorput opslag m3",5,10,25,50,{"$f":"F49","v":25},{"$f":"G49","v":25},{"$f":"IF(AND($F$49=$H$49,$G$49=$H$49),$F56,_xlfn.FORECAST.LINEAR($H$49,$F56:$G56,$F$49:$G$49))","v":25}]
["Vuile drain opslag m3",50,100,250,500,{"$f":"F50","v":250},250,{"$f":"IF(AND($F$6=$H$6,$G$6=$H$6),$F57,_xlfn.FORECAST.LINEAR($H$6,$F57:$G57,$F$6:$G$6))","v":250}]
["Propere drain opslag m3",200,400,1000,2000,{"$f":"F51","v":1000},1000,{"$f":"IF(AND($F$6=$H$6,$G$6=$H$6),$F58,_xlfn.FORECAST.LINEAR($H$6,$F58:$G58,$F$6:$G$6))","v":1000}]
["Voorput pomp m3/uur",15,30,75,150,{"$f":"F52","v":75},75,{"$f":"IF(AND($F$6=$H$6,$G$6=$H$6),$F59,_xlfn.FORECAST.LINEAR($H$6,$F59:$G59,$F$6:$G$6))","v":75}]
["Kosten",0.5,1,2.5,5]
["Voorput incl. coating",{"$f":"750+700","v":1450},{"$f":"1200+1100","v":2300},{"$f":"2300+2200","v":4500},{"$f":"5100+3700","v":8800},{"$f":"HLOOKUP(F56,$B56:$E64,6,FALSE)","v":4500},{"$f":"HLOOKUP(G56,$B56:$E64,6,FALSE)","v":4500},{"$f":"IF(AND($F49=$H49,$G49=$H49),$F61,_xlfn.FORECAST.LINEAR($H49,$F61:$G61,$F49:$G49))","v":4500}]
["Vuile drain opslag",3800,5200,7700,12200,{"$f":"HLOOKUP(F57,$B57:$E65,6,FALSE)","v":7700},7700,{"$f":"IF(AND($F50=$H50,$G50=$H50),$F62,_xlfn.FORECAST.LINEAR($H50,$F62:$G62,$F50:$G50))","v":7700}]
["Propere drain opslag",6700,10500,18200,34500,18200,18200,{"$f":"IF(AND($F51=$H51,$G51=$H51),$F63,_xlfn.FORECAST.LINEAR($H51,$F63:$G63,$F51:$G51))","v":18200}]
["Voorput pomp",2500,3200,6300,11500,6300,6300,6300]

{"sheet":"Stroom","index":6,"n_rows":24,"n_cols":7,"rows_kept":24,"cut":false,"hidden":true,"merged":[]}
[]
[]
[]
[null,null,"Ha",0.5,1,2.5,5]
[null,null,"Hoeveel m3 te ontsmetten?",3700,7450,{"$f":"E5*2.5","v":18625},37150]
[null,null,"Capaciteit/uur",1.5,3,8.5,15]
[null,null,"Uur nodig",{"$f":"D5/D6","v":2466.6666666666665},{"$f":"E5/E6","v":2483.3333333333335},{"$f":"F5/F6","v":2191.1764705882351},{"$f":"G5/G6","v":2476.6666666666665}]
[]
[null,null,"Dompelpomp"]
[null,null,"Capaciteit/uur",15,30,null,150]
[null,null,"Hoeveel m3 te ontsmetten?"]
[null,null,"Uur nodig"]
[null,null,"kw",1.1000000000000001,2.2000000000000002,null,{"$f":"2*5.5","v":11}]
[]
[null,null,"Doekenfilter"]
[null,null,"Capaciteit/uur",7,7,null,14]
[null,null,"Uur nodig",{"$f":"D5/D16","v":528.57142857142856},{"$f":"E5/E16","v":1064.2857142857142},null,{"$f":"G5/G16","v":2653.5714285714284}]
[null,null,"kw/h",{"$f":"20/1000","v":0.02},{"$f":"20/1000","v":0.02},null,{"$f":"20/1000","v":0.02}]
[null,null,"Kosten",{"$f":"D17*D18*$D$24","v":1.5857142857142856},{"$f":"E17*E18*$D$24","v":3.1928571428571426},null,{"$f":"G17*G18*$D$24","v":7.9607142857142854}]
[]
[]
[]
[]
[null,null,"Prijs per Kwh (KWIN)",0.15]

{"sheet":"Gegevens","index":7,"n_rows":5,"n_cols":7,"rows_kept":5,"cut":false,"hidden":true,"merged":[]}
[null,null,"Ha","Vuile drain opslag","Schone drain opslag","Ontsmettingstechnieck","Voorput pomp"]
[null,null,0.5,100,200,4,30]
[null,null,1,200,400,5,40]
[null,null,2.5]
[null,null,5,300,600,6,50]

{"sheet":"Factsheet","index":8,"n_rows":17,"n_cols":6,"rows_kept":17,"cut":false,"hidden":true,"merged":[]}
["Factsheet recirculatietechnieken RECUPA"]
["Versie","Concept"]
["Datum","2021-09-23"]
[]
[null,"Techniek"]
["Onderdeel","Ozon","Trage zandfilter","Ultrafiltratie","…","…"]
["Filtratie (micromol)","++","+","++"]
["Investeringskosten","+","-","+"]
["Onderhoudskosten","-","+","-"]
["Gebruik/capaciteit (m³/uur)","+","+","+"]
["Praktische toepasbaarheid","--","-","--"]
["Levensduur","+","-","+"]
["Gebruiksvriendelijk","+","++","+"]
[]
[]
["Is dit iets als opzet? Wat moet er in het factsheet aan de orde komen?"]
["Let op: tekens zijn lukraak ingevuld, niet gebaseerd op de technieken."]