{"text_format":"1","workbook":"xlsx","n_sheets":7,"sheets":["Overzicht","Invoergegevens warmtevraag","Invoergegevens waterzuivering","Data invoer","Data BENG","Data rwzi","Temperatuurverloop"],"not_rendered":{"charts":17,"images":8,"macros":1,"external_links":0,"defined_names":6,"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":"Overzicht","index":0,"n_rows":43,"n_cols":22,"rows_kept":43,"cut":false,"hidden":false,"merged":[]}
[]
[]
[]
[null,null,null,null,null,null,"Contactinformatie","Barry Meddeler "]
[null,null,null,null,null,null,null,"Syntraal"]
[null,null,null,null,null,null,"Email:","barry.meddeler@syntraal.com"]
[null,null,null,null,null,null,"Telefoonnummer","06-29192363"]
[]
[]
[]
[]
[]
[]
[null,null,null,null,"Objecten",{"$f":"'Invoergegevens warmtevraag'!D9","v":150}]
[null,null,null,null,"Maximale warmtevraag",{"$f":"'Invoergegevens warmtevraag'!D15","v":1002},"kW"]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[null,null,null,null,null,null,"Afstand tot rwzi",{"$f":"'Invoergegevens waterzuivering'!D9","v":4},"km"]
[]
[]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"'Invoergegevens waterzuivering'!C28","v":"Stikstofvracht toename per jaar"},{"$f":"'Invoergegevens waterzuivering'!D28","v":1.8315342140375118E-3},{"$f":"'Invoergegevens waterzuivering'!E28","v":"mg/l"}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"'Invoergegevens waterzuivering'!C29","v":"N totaal jaargemiddeld"},{"$f":"'Invoergegevens waterzuivering'!D29","v":4.2974765071385548},{"$f":"'Invoergegevens waterzuivering'!E29","v":"mg/l"}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"'Invoergegevens waterzuivering'!C30","v":"Toename in procent"},{"$f":"'Invoergegevens waterzuivering'!D30","v":4.2637001558128889E-4}]
[]
[]
[]
[]
[]
[]
[]
[]
[null,null,"Debiet (DWA)0",{"$f":"'Invoergegevens warmtevraag'!$D$20","v":3195},"m3/dag",null,null,null,null,null,null,"Debiet1",{"$f":"'Invoergegevens waterzuivering'!D16","v":22861},"m3/dag"]
[null,null,"T0 ",{"$f":"MIN(Temperatuurverloop!C24:C35)","v":9},"°C",null,"T1",{"$f":"MIN(Temperatuurverloop!D24:D35)","v":7.6586986031018647},"°C",null,null,"T2 influent",{"$f":"MIN(Temperatuurverloop!K24:K35)","v":8.9800845521193899}]
[]
[null,null,{"$f":"'Invoergegevens warmtevraag'!C30","v":""}]

{"sheet":"Invoergegevens warmtevraag","index":1,"n_rows":30,"n_cols":13,"rows_kept":30,"cut":false,"hidden":false,"merged":[[3,2,3,5],[18,2,18,5]]}
[]
[]
[]
[null,null,"Warmtevraag object",null,null,null,null,null,null,null,null,null,{"$f":"\"Warmtevraag per maand \" &D9& \" objecten (kWh)\"","v":"Warmtevraag per maand 150 objecten (kWh)"}]
[]
[]
[null,null,"Object warmtevraag"]
[]
[null,null,"Aantal objecten",150,"objecten"]
[]
[null,null,"kW warmtevraag object",8,"kW"]
[null,null,"Maximaal thermische vermogen uit het riool per object ",5.3,"kW"]
[null,null,"Vollasturen warmtevraag per jaar",1500,"vollasturen per jaar"]
[null,null,"Inclusief tapwater"]
[null,null,"Totaal maximale thermisch vermogen uit het riool (kW)",{"$f":"'Data invoer'!Q3*'Invoergegevens warmtevraag'!D9","v":1002},"kW"]
[null,null,"Warmtevraag  per jaar (kWh)",{"$f":"'Data invoer'!Q18*D9","v":1482299.9999999998},"kWh"]
[]
[]
[null,null,"Gegevens rioolwater voor de wisselaar"]
[null,null,"Droog weer afvoer riool (m3/dag)",3195,"m3/dag"]
[null,null,"Uren DWA per dag",16,"uur"]
[null,null,"DWA (m3/uur)",{"$f":"D20/D21","v":199.6875},"m3/uur"]
[null,null,"DWA (l/s)",{"$f":"D22*1000/3600","v":55.46875},"l/s"]
[null,null,"Minimale temperatuur rioolwater in de winter (default 8 graden)",9,"°C"]
[null,null,"Temperatuurverloop rioolwater voor de warmtewisselaar"]
[]
[]
[null,null,"Maximale delta temperatuur",{"$f":"-MAX(Temperatuurverloop!E24:E35)","v":-1.3413013968981353}]
[]
[null,null,{"$f":"IF(D28<-5,\"Waarschuwing: Warmtevraag is groter dan het warmteaanbod in het riool! Geen haalbare case.\", \"\")","v":""}]

{"sheet":"Invoergegevens waterzuivering","index":2,"n_rows":35,"n_cols":6,"rows_kept":35,"cut":false,"hidden":false,"merged":[[2,2,2,4],[26,2,26,4],[13,2,13,4]]}
[]
[2]
[null,null,"Rioolgegevens tot de rwzi"]
[null,null,"Doorsnee rioolbuis",1500,"mm"]
[null,null,"Vorm"]
[null,null,"Materiaal"]
[null,null,"Rioolbuis (gedeeltelijk) in het grondwater"]
[null,null,"Riool type"]
[null,null,"Afstand van de warmtewisselaar tot awzi/rwzi",4,"km"]
[]
[]
[]
[]
[null,null,"Gegevens waterzuivering"]
[null,null,"Afvalwaterzuivering Nederland per waterschap"]
[null,null,"Gemiddeld influent aanvoer per dag",22861,"m3/dag"]
[null,null,"Type rwzi"]
[null,null,"Ontwerpcapaciteit (i.e.)",110341]
[null,null,"Belasting t.o.v. ontwerpcapaciteit",0.48514151584633092]
[null,null,"N totaal jaargemiddeld",4.2956449729245172,"mg/liter"]
[]
[]
[]
[]
[]
[]
[null,null,"Resultaat"]
[null,null,"Stikstofvracht toename per jaar",1.8315342140375118E-3,"mg/l"]
[null,null,"N totaal jaargemiddeld",{"$f":"D28+D20","v":4.2974765071385548},"mg/l"]
[null,null,"Toename in procent",{"$f":"D28/D20","v":4.2637001558128889E-4}]
[]
[]
[null,null,"Effect jaarlijkse stikstofvracht",0,0.05," >10%"]
[]
[null,null,null,"Geen effect",null,"Effect"]

{"sheet":"Data invoer","index":3,"n_rows":96,"n_cols":21,"rows_kept":96,"cut":false,"hidden":true,"merged":[]}
[]
[null,2,null,null,null,null,null,null,null,null,null,null,null,true,"ruimte (kW)","Tap(kW)","Maximale warmtevraag bron"]
[null,"Objecten","Gevraagd vermogen per object","kW bron","Vollast uren","COP",null,"Tapwater",null,"Vollasturen","COP",null,null,"Bronvermogen",{"$f":"'Invoergegevens warmtevraag'!D12","v":5.3},{"$f":"IF(N2,I4,0)","v":1.38},{"$f":"P3+O3","v":6.68}]
[null,"Woningen nieuwbouw (BENG)",6,{"$f":"C4/F4*(F4-1)","v":4.2857142857142856},960,3.5,null,2.2999999999999998,{"$f":"H4/K4*(K4-1)","v":1.38},1400,2.5]
[null,"Woningen bestaande bouw (>2000)",8,{"$f":"C5/F5*(F5-1)","v":5.333333333333333},1500,3,null,2.2999999999999998,{"$f":"H5/K5*(K5-1)","v":1.38},1400,2.5,null,null,null,"Ruimte vollasturen","Tapwater (vollasturen)","kWh","GJ","Uur per maand","GJ","GJ*aantal"]
[null,"Woningen bestaande bouw (1990-2000)",12,8,2000,3,null,2.2999999999999998,1.38,1400,2.5,null,null,"Januari",{"$f":"C17","v":237},{"$f":"$J$4/12","v":116.66666666666667},{"$f":"P6*$P$3+O6*$O$3","v":1417.1},{"$f":"Q6*0.0036","v":5.1015599999999992},744,{"$f":"R6/S6","v":6.8569354838709665E-3},{"$f":"T6*'Invoergegevens warmtevraag'!$D$9","v":1.0285403225806449}]
[null,"Woningen (<1990)",15,10,2500,3,null,2.2999999999999998,1.38,1400,2.5,null,null,"Februari",{"$f":"C18","v":232.5},116.66666666666667,{"$f":"P7*$P$3+O7*$O$3","v":1393.25},{"$f":"Q7*0.0036","v":5.0156999999999998},672,{"$f":"R7/S7","v":7.4638392857142855E-3},{"$f":"T7*'Invoergegevens warmtevraag'!$D$9","v":1.1195758928571429}]
[null,"Zwembad (binnenzwembad)",250,187.5,2800,4,null,null,null,null,null,null,null,"Maart",187.5,116.66666666666667,1154.75,4.1570999999999998,744,5.5874999999999996E-3,{"$f":"T8*'Invoergegevens warmtevraag'!$D$9","v":0.8381249999999999}]
[null,"Zwembad (buitenzwembad)",250,187.5,1500,4,null,null,null,null,null,null,null,"April",139.5,116.66666666666667,900.35,3.24126,720,4.5017499999999997E-3,{"$f":"T9*'Invoergegevens warmtevraag'!$D$9","v":0.67526249999999999}]
[null,"Overige",0,null,0,null,null,null,null,null,null,null,null,"Mei",78,116.66666666666667,574.4,2.0678399999999999,744,2.7793548387096772E-3,{"$f":"T10*'Invoergegevens warmtevraag'!$D$9","v":0.41690322580645156}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,"Juni",37.5,116.66666666666667,359.75,1.2950999999999999,720,1.7987499999999998E-3,{"$f":"T11*'Invoergegevens warmtevraag'!$D$9","v":0.26981249999999996}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,"Juli",1.5,116.66666666666667,168.95,0.60821999999999998,744,8.1749999999999998E-4,{"$f":"T12*'Invoergegevens warmtevraag'!$D$9","v":0.122625}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,"Augustus",7.5,116.66666666666667,200.75,0.72270000000000001,744,9.7137096774193546E-4,{"$f":"T13*'Invoergegevens warmtevraag'!$D$9","v":0.14570564516129031}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,"September",55.5,116.66666666666667,455.15,1.6385399999999999,720,2.27575E-3,{"$f":"T14*'Invoergegevens warmtevraag'!$D$9","v":0.34136250000000001}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,"Oktober",115.5,116.66666666666667,773.15,2.7833399999999999,744,3.7410483870967742E-3,{"$f":"T15*'Invoergegevens warmtevraag'!$D$9","v":0.56115725806451611}]
[null,null,"Vollasturen per maand","Woningen","Buitenzwembad","Binnenzwembad",null,"kWh","Uur per maand",null,null,null,null,"November",180,116.66666666666667,1115,4.0140000000000002,720,5.5750000000000001E-3,{"$f":"T16*'Invoergegevens warmtevraag'!$D$9","v":0.83625000000000005}]
[null,"Januari",237,0.158,0,0.11700000000000001,null,{"$f":"Q6*'Invoergegevens warmtevraag'!D$9","v":212565},{"$f":"J17*'Invoergegevens warmtevraag'!$D$21","v":496},31,null,null,null,"December",228,116.66666666666667,1369.3999999999999,4.9298399999999996,744,6.626129032258064E-3,{"$f":"T17*'Invoergegevens warmtevraag'!$D$9","v":0.99391935483870963}]
[null,"Februari",232.5,0.155,0,0.10100000000000001,null,{"$f":"Q7*'Invoergegevens warmtevraag'!D$9","v":208987.5},{"$f":"J18*'Invoergegevens warmtevraag'!$D$21","v":448},28,null,null,null,null,{"$f":"SUM(O6:O17)","v":1500},null,{"$f":"SUM(Q6:Q17)","v":9881.9999999999982},35.575199999999995]
[null,"Maart",187.5,0.125,0,8.6999999999999994E-2,null,{"$f":"Q8*'Invoergegevens warmtevraag'!D$9","v":173212.5},{"$f":"J19*'Invoergegevens warmtevraag'!$D$21","v":496},31]
[null,"April",139.5,9.2999999999999999E-2,0.25,8.1000000000000003E-2,null,{"$f":"Q9*'Invoergegevens warmtevraag'!D$9","v":135052.5},{"$f":"J20*'Invoergegevens warmtevraag'!$D$21","v":480},30]
[null,"Mei",78,5.1999999999999998E-2,0.35,7.1999999999999995E-2,null,{"$f":"Q10*'Invoergegevens warmtevraag'!D$9","v":86160},{"$f":"J21*'Invoergegevens warmtevraag'!$D$21","v":496},31]
[null,"Juni",37.5,2.5000000000000001E-2,0.15,6.2E-2,null,{"$f":"Q11*'Invoergegevens warmtevraag'!D$9","v":53962.5},{"$f":"J22*'Invoergegevens warmtevraag'!$D$21","v":480},30,null,null,null,null,null,null,null,null,"kW","Aantal * kW"]
[null,"Juli",1.5,1E-3,0.15,6.2E-2,null,{"$f":"Q12*'Invoergegevens warmtevraag'!D$9","v":25342.5},{"$f":"J23*'Invoergegevens warmtevraag'!$D$21","v":496},31,null,null,null,null,null,null,null,null,{"$f":"Q6/S6","v":1.9047043010752687},{"$f":"S23*'Invoergegevens warmtevraag'!$D$9","v":285.70564516129031}]
[null,"Augustus",7.5,5.0000000000000001E-3,0.1,6.2E-2,null,{"$f":"Q13*'Invoergegevens warmtevraag'!D$9","v":30112.5},{"$f":"J24*'Invoergegevens warmtevraag'!$D$21","v":496},31,null,null,null,null,null,null,null,null,2.0732886904761907,{"$f":"S24*'Invoergegevens warmtevraag'!$D$9","v":310.99330357142861}]
[null,"September",55.5,3.6999999999999998E-2,0,7.1999999999999995E-2,null,{"$f":"Q14*'Invoergegevens warmtevraag'!D$9","v":68272.5},{"$f":"J25*'Invoergegevens warmtevraag'!$D$21","v":480},30,null,null,null,null,null,null,null,null,1.5520833333333333,{"$f":"S25*'Invoergegevens warmtevraag'!$D$9","v":232.8125}]
[null,"Oktober",115.5,7.6999999999999999E-2,0,8.2000000000000003E-2,null,{"$f":"Q15*'Invoergegevens warmtevraag'!D$9","v":115972.5},{"$f":"J26*'Invoergegevens warmtevraag'!$D$21","v":496},31,null,null,null,null,null,null,null,null,1.2504861111111112,{"$f":"S26*'Invoergegevens warmtevraag'!$D$9","v":187.57291666666669}]
[null,"November",180,0.12,0,9.0999999999999998E-2,null,{"$f":"Q16*'Invoergegevens warmtevraag'!D$9","v":167250},{"$f":"J27*'Invoergegevens warmtevraag'!$D$21","v":480},30,null,null,null,null,null,null,null,null,0.77204301075268811,{"$f":"S27*'Invoergegevens warmtevraag'!$D$9","v":115.80645161290322}]
[null,"December",228,0.152,0,0.111,null,{"$f":"Q17*'Invoergegevens warmtevraag'!D$9","v":205409.99999999997},{"$f":"J28*'Invoergegevens warmtevraag'!$D$21","v":496},31,null,null,null,null,null,null,null,null,0.49965277777777778,{"$f":"S28*'Invoergegevens warmtevraag'!$D$9","v":74.947916666666671}]
[null,null,null,null,{"$f":"SUM(E17:E28)","v":1},{"$f":"SUM(F17:F28)","v":1},null,null,null,null,null,null,null,null,null,null,null,null,0.22708333333333333,{"$f":"S29*'Invoergegevens warmtevraag'!$D$9","v":34.0625}]
[null,null,null,"link","Factor",null,null,null,null,null,null,null,null,null,null,null,null,null,0.26982526881720431,{"$f":"S30*'Invoergegevens warmtevraag'!$D$9","v":40.473790322580648}]
["Riool","Vorm","Rond",1,1,null,{"$f":"IF(D31=1,E31,IF(D31=2,E32,E33))","v":1},null,null,null,null,null,null,null,null,null,null,null,0.63215277777777779,{"$f":"S31*'Invoergegevens warmtevraag'!$D$9","v":94.822916666666671}]
[null,null,"Ovaal",null,0.99,null,null,null,null,null,null,null,null,null,null,null,null,null,1.0391801075268816,{"$f":"S32*'Invoergegevens warmtevraag'!$D$9","v":155.87701612903226}]
[null,null,"Vierkant",null,1.02,null,null,null,null,null,null,null,null,null,null,null,null,null,1.5486111111111112,{"$f":"S33*'Invoergegevens warmtevraag'!$D$9","v":232.29166666666669}]
[null,null,null,"link",null,null,null,null,null,null,null,null,null,null,null,null,null,null,1.8405913978494621,{"$f":"S34*'Invoergegevens warmtevraag'!$D$9","v":276.08870967741933}]
[null,"Materiaal","Beton",1,1,null,{"$f":"IF(D35=1,E35,IF(D35=2,E36,E37))","v":1}]
[null,null,"PE",null,0.95]
[null,null,"PVC",null,0.95]
[null,"Grondwater","Ja",1,1.2,null,{"$f":"IF(D38=1,E38,IF(D38=2,E39,E40))","v":1.2}]
[null,null,"Nee",null,0.95]
[null,null,"Onbekend",null,1]
[]
[null,"Type riool","Vrijverval",2,{"$f":"H85","v":0.77679999999999993},null,{"$f":"IF(D42=1,E42,IF(D42=2,E43,E44))","v":0.74480000000000002}]
[null,null,"Persleiding",null,{"$f":"H66","v":0.74480000000000002}]
[]
[null,null,null,null,null,"Factor",{"$f":"G38*G35*G31*G42","v":0.89376}]
[]
[]
[]
[]
[]
[]
[]
[]
["Rwzi","Type rwzi","Gecompartimenteerd",2]
[null,null,"Omloopcircuit"]
[]
[null,"Temperatuurverloop rioolwater","Default",2]
[null,null,"Eigen reeks"]
[]
[]
[null,"Ontwerpcapaciteit"]
[]
[]
[null,null,null,null,null,null,"dT",5]
[null,null,null,null,null,null,"Afstand",{"$f":"'Invoergegevens waterzuivering'!D9","v":4},"km"]
[null,"Afstand","Persleiding",null,null,null,"Percentage",{"$f":"((-0.0055*H65^3)+(0.047*H65^2)+(0.0837*H65)+0.01)","v":0.74480000000000002},{"$f":"H64-H66*H64","v":1.2759999999999998}]
[null,0,0,5,0,{"$f":"((-0.0055*B67^3)+(0.047*B67^2)+(0.0837*B67)+0.01)","v":0.01}]
[null,0.2,0.05,{"$f":"$D$67-C68","v":4.95},{"$f":"1-D68/$D$67","v":1.0000000000000009E-2},{"$f":"((-0.0055*B68^3)+(0.047*B68^2)+(0.0837*B68)+0.01)","v":2.8576000000000004E-2}]
[null,0.5,0.2,{"$f":"$D$67-C69","v":4.8},{"$f":"1-D69/$D$67","v":4.0000000000000036E-2},6.2912499999999996E-2]
[null,1,0.5,{"$f":"$D$67-C70","v":4.5},{"$f":"1-D70/$D$67","v":9.9999999999999978E-2},0.13520000000000001]
[null,1.5,1,{"$f":"$D$67-C71","v":4},{"$f":"1-D71/$D$67","v":0.19999999999999996},0.2227375]
[null,2,1.5,3.5,0.30000000000000004,0.32140000000000002]
[null,3,2.6,2.4,0.52,0.53559999999999997]
[null,4,3.7,1.2999999999999998,0.74,0.74480000000000002]
[null,5,4.5,0.5,0.9,0.91600000000000004]
[null,6,4.8,0.20000000000000018,0.96,1.0162]
[null,7,5,0,1,1.0124000000000002]
[]
[]
[]
[]
[]
[null,null,null,null,null,null,"dT",5]
[null,null,null,null,null,null,"Afstand",{"$f":"H65","v":4},"km"]
[null,"Afstand","Vrijverval",null,null,null,"Percentage",{"$f":"((-0.007*H84^3)+(0.0715*H84^2)+(0.0186*H84)+0.0064)","v":0.77679999999999993},{"$f":"H83-H85*H83","v":1.1160000000000005}]
[null,0,0,5,0,{"$f":"((-0.007*B86^3)+(0.0715*B86^2)+(0.0186*B86)+0.0064)","v":6.4000000000000003E-3}]
[null,0.2,0.03,{"$f":"$D$67-C87","v":4.97},{"$f":"1-D87/$D$67","v":6.0000000000000053E-3},{"$f":"((-0.007*B87^3)+(0.0715*B87^2)+(0.0186*B87)+0.0064)","v":1.2924000000000001E-2}]
[null,0.5,0.09,{"$f":"$D$67-C88","v":4.91},{"$f":"1-D88/$D$67","v":1.8000000000000016E-2},3.27E-2]
[null,1,0.3,{"$f":"$D$67-C89","v":4.7},{"$f":"1-D89/$D$67","v":5.9999999999999942E-2},8.9499999999999982E-2]
[null,1.5,0.6,{"$f":"$D$67-C90","v":4.4000000000000004},{"$f":"1-D90/$D$67","v":0.11999999999999988},0.17154999999999998]
[null,2,1,4,0.19999999999999996,0.27360000000000001]
[null,2.5,1.4,3.6,0.28000000000000003,0.39039999999999997]
[null,4,3.2,1.7999999999999998,0.64,0.77679999999999993]
[null,5,4.2,0.79999999999999982,0.84000000000000008,1.0118999999999998]
[null,6,4.8,0.20000000000000018,0.96,1.1799999999999997]
[null,7,5,0,1,1.2390999999999994]

{"sheet":"Data BENG","index":4,"n_rows":34,"n_cols":8,"rows_kept":34,"cut":false,"hidden":true,"merged":[]}
["Warmte inhoud gas MJ/m3",31.65]
["Soortelijke warmte water kW/kg/°C",4.18]
["Tapwatervraag per persoon kWh/jaar",1098]
["Oplaadtijd boiler in uren",3]
["Vollasturen ruimteverwarming",1000]
["Vollasturen koeling",600]
["Ruimteverwarming W/m2 BVO appartement",40]
["Maximaal koelvermogen W/m2 BVO",30]
[]
["Type woning","Gebruikersoppervlak in m2","Aantal personen per huishouden","Tapwatervraag (kWh/jaar)","Minimale boilerinhoud (L)",null,null,"Vollasturen per dag"]
["Appartement",105,2,2196,100,null,{"$f":"D11/B28","v":1155.7894736842106},{"$f":"G11/365","v":3.1665465032444127}]
["Tussenwoning",146,3,3294,120,"CW4",{"$f":"D12/C28","v":1432.1739130434785},{"$f":"G12/365","v":3.9237641453245984}]
["Twee-onder-één kap woning",180,3.5,3843,150,null,{"$f":"D13/E28","v":1325.1724137931035},{"$f":"G13/365","v":3.6306093528578178}]
["Vrijstaande woning",264,4.5,4941,200,null,{"$f":"D14/F28","v":1266.9230769230769},{"$f":"G14/365","v":3.4710221285563749}]
[]
["Energiegebruik referentiewoningen BENG norm 2020"]
[null,"Appartement","Tussenwoning","Hoekwoning","2-onder-éénkap","Vrijstaand "]
["Max. Energiebehoefte in kWh/m2/jr",65,55,66.400000000000006,66.400000000000006,74.5]
["Daadwerkelijke energiebehoefte in kWh/m2/jr",58,55,60,64.2,71]
["Energiebehoefte in kWh/woning/jr",6090,8001,8760,11556,18744]
["Koeling in kWh/woning/jr",1890,2453,2628,3456,5544]
["Tapwater in kWh/woning/jr",2196,3294,3294,3843,4941]
["Ruimteverwarming in kWh/jr",4200,5548,6132,8100,13200]
[]
["Gevraagd vermogen BENG situatie"]
[null,"Appartement","Tussenwoning","Hoekwoning","2-onder-éénkap","Vrijstaand "]
["Koeling in kW",3.2,4.0999999999999996,4.4000000000000004,5.8,9.1999999999999993]
["Tapwater in kW met buffer",1.9,2.2999999999999998,2.2999999999999998,2.9,3.9]
["Ruimteverwarming in kW",4.2,5.5,7.6,8.1,13.2]
["Totale warmtevraag in kW",6.1,7.9,9.9,11,17.100000000000001]
[]
[null,"CW 3","CW 4","CW 5"]
["Vermogen tapwater bij doorstroom (douchen op 40 graden)",21.6,27,32.4]
["Dit werkt vooral bij een relatief groot collectief systeem met een gelijktijdigheid van 10% tapwater"]

{"sheet":"Data rwzi","index":5,"n_rows":342,"n_cols":25,"rows_kept":342,"cut":false,"hidden":true,"merged":[]}
[]
[114,"[gbel] Gemiddelde belasting [i_e__150] [2018]","[capon] Actuele ontwerpcapaciteit [i_e__150] [2018]","[effn] Stikstofjaarvracht (N-totaal) in het effluent [kg] [2018]","[pcc4] Biologische verwijdering P en N in hoofdstroom-2: (m)UCT-Systeem [ja/nee] [2018]","[pcb2] Biologische verwijdering P en N in hoofdstroom-1: Omloopcircuit [ja/nee] [2018]","[pcc3] Biologische verwijdering P en N in hoofdstroom-2: PhoRedoxSysteem [ja/nee] [2018]","Totale aangevoerde hoeveelheid afvalwater [m3/dag] [2015]","N totaal (mg/l)","Huidige belasting groter dan ontwerpcapaciteit (1) of kleiner (0)","Huidige belasting groter dan 90% van ontwerpcapaciteit (1) of kleiner (0)","m-UCT","Omloop","Phoredox",null,"Totale aangevoerde hoeveelheid afvalwater [m3/dag] [2015]",null,"[capon] Actuele ontwerpcapaciteit [i_e__150] [2018]","[gbel] Gemiddelde belasting [i_e__150] [2018]",null,"Percentiel","Gemiddelde belasting","Ontwerp belasting"]
["Aa en Maas: ’s-Hertogenbosch",308652,310080,198245,"Ja","Nee","Nee",53828,{"$f":"+D3/(H3*365)*1000","v":10.090231595106076},{"$f":"+IFERROR(IF(B3>C3,1,0),\"\")","v":0},{"$f":"+IFERROR(IF(B3/C3>0.9,1,0),\"\")","v":1},{"$f":"+IF(E3=\"Ja\",1,0)","v":1},{"$f":"+IF(F3=\"Ja\",1,0)","v":0},{"$f":"+IF(G3=\"Ja\",1,0)","v":0},null,"-",null,"-","-",null,null,"i.e. á 150 g TZV","i.e. á 150 g TZV"]
["Aa en Maas: Aarle-Rixtel",381974,299200,145857,"Ja","Ja","Nee",65594,{"$f":"+D4/(H4*365)*1000","v":6.0921459154508373},{"$f":"+IFERROR(IF(B4>C4,1,0),\"\")","v":1},{"$f":"+IFERROR(IF(B4/C4>0.9,1,0),\"\")","v":1},{"$f":"+IF(E4=\"Ja\",1,0)","v":1},1,0,null,197139,null,"-","-",null,0.1,{"$f":"+PERCENTILE($S$4:$S$339,U4)","v":8307},{"$f":"+PERCENTILE($R$4:$R$109,U4)","v":90395}]
["Aa en Maas: Asten",59239,72533,16493,"Nee","Ja","Ja",14591,3.0968611726312805,0,0,0,1,1,null,171093,null,"-",1060482,null,0.25,{"$f":"+PERCENTILE($S$4:$S$109,U5)","v":94919},{"$f":"+PERCENTILE($R$4:$R$109,U5)","v":111130.75}]
["Aa en Maas: Dinther",267954,271093,91920,"Nee","Ja","Ja",47872,5.2606036187825067,0,1,0,1,1,null,153476,null,"-",989355,null,0.5,{"$f":"+PERCENTILE($S$4:$S$109,U6)","v":129619},150250]
["Aa en Maas: Land van Cuijk",167494,165220,81442,"Ja","Nee","Nee",32914,6.7791446534388919,1,1,1,0,0,null,119407,null,"-",731498,null,0.75,{"$f":"+PERCENTILE($S$4:$S$109,U7)","v":255100},280184]
["Aa en Maas: Oijen",257558,360000,75325,"Nee","Ja","Nee",54793,3.7663545163378283,0,0,0,1,0,null,105468,null,1185693,475209,null,0.9,{"$f":"+PERCENTILE($S$4:$S$109,U8)","v":353771.60000000015},362403]
["Aa en Maas: Vinkel",56437,56213,20036,"Nee","Ja","Ja",12804,4.2871876511192992,1,1,0,1,1,null,87946,null,919500,432486]
["Amstel, Gooi en Vecht: Amstelveen",119597,113500,132775,"Ja","Ja","Nee",28074,12.957438316152711,1,1,1,1,0,null,82229,null,680000,406130,null,null,"Aantal systemen","aantal >100% van ontwerp capaciteit","aantal <100% van ontwerp capaciteit"]
["Amstel, Gooi en Vecht: Amsterdam West",989355,919500,461439,"Ja","Ja","Nee",171093,7.3890599753126338,1,1,1,1,0,null,75680,null,564000,382411,"(m)UCT",{"$f":"+T11&\" (\"&V11&\" st)\"","v":"(m)UCT (61 st)"},{"$f":"+COUNTIF(E3:E339,\"Ja\")","v":61},{"$f":"+SUMPRODUCT($K$3:$K$339,L3:L339)","v":28},{"$f":"+V11-W11","v":33}]
["Amstel, Gooi en Vecht: Blaricum",39276,30000,11644,"Nee","Ja","Nee",8122,3.927772699213703,1,1,0,1,0,null,74783,null,485970,381974,"Phoredox",{"$f":"+T12&\" (\"&V12&\" st)\"","v":"Phoredox (43 st)"},{"$f":"+COUNTIF(G3:G339,\"Ja\")","v":43},{"$f":"+SUMPRODUCT($K$3:$K$339,N3:N339)","v":16},{"$f":"+V12-W12","v":27}]
["Amstel, Gooi en Vecht: Hilversum",66470,82500,25297,"Ja","Ja","Nee",11554,5.998515606289466,0,0,1,1,0,null,71586,null,480000,373567,"Omloopcircuit",{"$f":"+T13&\" (\"&Y13&\" st)\"","v":"Omloopcircuit (250 st)"},null,{"$f":"+SUMPRODUCT($J$3:$J$339,M3:M339)","v":53},{"$f":"+Y13-W13","v":197},{"$f":"+COUNTIF(F3:F339,\"Ja\")","v":250}]
["Amstel, Gooi en Vecht: Horstermeer",126214,150000,30206,"Ja","Nee","Nee",25691,3.2212122682480886,0,0,1,0,0,null,69658,null,454000,367015,null,{"$f":"+W10","v":"aantal >100% van ontwerp capaciteit"},{"$f":"+W13","v":53}]
["Amstel, Gooi en Vecht: Huizen",56706,58500,20599,"Nee","Nee","Ja",8946,6.3084748980948095,0,1,0,0,1,null,68349,null,400000,359624,null,{"$f":"+X10","v":"aantal <100% van ontwerp capaciteit"},{"$f":"+Y13-V14","v":197}]
["Amstel, Gooi en Vecht: Loenen",10687,12000,5928,"Nee","Ja","Nee",2313,7.0216584048469342,0,0,0,1,0,null,65594,null,395000,344993]
["Amstel, Gooi en Vecht: Maarssen",19889,22500,9356,"Nee","Nee","Ja",3276,7.8244434408817964,0,0,0,0,1,null,64528,null,389197,329588]
["Amstel, Gooi en Vecht: Ronde Venen",48889,63500,19021,"Ja","Ja","Nee",11203,4.6516405219247776,0,0,1,1,0,null,64365,null,362670,325184]
["Amstel, Gooi en Vecht: Uithoorn",44494,63500,30812,"Nee","Nee","Nee",10065,8.387127506822095,0,0,0,0,0,null,64310,null,360000,319586]
["Amstel, Gooi en Vecht: Weesp",37651,54000,96170,"Nee","Nee","Nee",9150,28.795568530578638,0,0,0,0,0,null,64046,null,360000,311102]
["Amstel, Gooi en Vecht: Westpoort",367015,454000,168473,"Ja","Ja","Nee",64046,7.2068491867360747,0,0,1,1,0,null,62363,null,340146,308652]
["Brabantse Delta: Baarle-Nassau",21318,16770,7550,"Nee","Ja","Nee",2582,8.0112050762390847,1,1,0,1,0,null,57530,null,340000,289384,null,null,"https://waves.databank.nl/jive "]
["Brabantse Delta: Bath",432486,485970,323388,"Nee","Nee","Nee",105468,8.4006003768720863,0,0,0,0,0,null,54793,null,337000,284748]
["Brabantse Delta: Chaam",7972,7660,2498,"Nee","Ja","Nee",1405,4.8710573782479409,1,1,0,1,0,null,54503,null,330000,280736]
["Brabantse Delta: Dinteloord",7752,7660,4643,"Nee","Ja","Nee",2514,5.059883828641798,1,1,0,1,0,null,53828,null,318288,277359]
["Brabantse Delta: Dongemond",157822,145670,136993,"Nee","Nee","Nee",29258,12.828056862096961,1,1,0,0,0,null,51924,null,317000,273294]
["Brabantse Delta: Halsteren",17792,12690,7809,"Nee","Ja","Nee",2971,7.2011176532969392,1,1,0,1,0,null,50774,null,310080,268532]
["Brabantse Delta: Kaatsheuvel",62598,57300,13934,"Nee","Ja","Nee",11442,3.3364221697040226,1,1,0,1,0,null,49790,null,307813,267954]
["Brabantse Delta: Lage Zwaluwe",10464,7200,4168,"Nee","Ja","Nee",2080,5.4899894625922023,1,1,0,1,0,null,49650,null,303700,267726]
["Brabantse Delta: Nieuwveer",359624,362670,279239,"Nee","Nee","Nee",75680,10.108857771728113,0,1,0,0,0,null,49322,null,299200,257558]
["Brabantse Delta: Nieuw-Vossemeer",2463,2880,1348,"Nee","Ja","Nee",710,5.2016206830021225,0,0,0,1,0,null,47872,null,292400,255100]
["Brabantse Delta: Ossendrecht",10173,8130,3168,"Nee","Nee","Ja",1490,5.8251356072446443,1,1,0,0,1,null,45700,null,289136,249240]
["Brabantse Delta: Putte",6180,5070,2525,"Nee","Nee","Ja",957,7.2286397274588117,1,1,0,0,1,null,43773,null,281112,244168]
["Brabantse Delta: Riel",10943,14050,3109,"Nee","Ja","Ja",1741,4.8924803096944762,0,0,0,1,1,null,42334,null,277400,241949]
["Brabantse Delta: Rijen",86450,74350,29606,"Nee","Ja","Nee",13879,5.8442487763616455,1,1,0,1,0,null,41999,null,272000,241704]
["Brabantse Delta: Waalwijk",64560,77970,38510,"Nee","Nee","Nee",13502,7.8141645174839658,0,0,0,0,0,null,41725,null,271093,237412]
["Brabantse Delta: Waspik",13592,17340,3157,"Nee","Ja","Nee",2354,3.6743054666495967,0,0,0,1,0,null,41663,null,257956,234699]
["Brabantse Delta: Willemstad",6000,5520,2972,"Nee","Ja","Nee",1231,6.6145132034318905,1,1,0,1,0,null,41582,null,238453,213365]
["De Dommel: Biest-Houtakker",59677,66650,37169,"Ja","Ja","Nee",12485,8.1564178383923718,0,0,1,1,0,null,39913,null,235200,210149]
["De Dommel: Boxtel",77142,108800,50266,"Ja","Ja","Nee",15513,8.8773975693386635,0,0,1,1,0,null,35656,null,228000,209391]
["De Dommel: Eindhoven",731498,680000,411296,"Ja","Ja","Nee",153476,7.342114442416948,1,1,1,1,0,null,35204,null,227999,191920]
["De Dommel: Haaren",44007,60000,24117,"Nee","Ja","Ja",10767,6.1367114890628525,0,0,0,1,1,null,34462,null,227000,187892]
["De Dommel: Hapert",51103,64373,21584,"Nee","Ja","Ja",12085,4.8931937588202281,0,0,0,1,1,null,34150,null,226667,182484]
["De Dommel: Mierlo","-","-","-","Nee","Nee","Nee",null,{"$error":"#VALUE!"},0,"",0,0,0,null,32914,null,210933,180027]
["De Dommel: Sint-Oedenrode",94919,89760,30457,"Nee","Ja","Ja",15146,5.5092985353517996,1,1,0,1,1,null,32503,null,209000,178340]
["De Dommel: Soerendonk",32132,38170,10574,"Nee","Ja","Ja",7786,3.7207632948495544,0,0,0,1,1,null,31789,null,206811,171261]
["De Dommel: Tilburg",382411,340000,184568,"Nee","Nee","Ja",64528,7.8363772846618138,1,1,0,0,1,null,30649,null,206720,167494]
["De Stichtse Rijnlanden: Breukelen",25444,31200,11791,"Ja","Ja","Nee",5205,6.2063611122077038,0,0,1,1,0,null,30406,null,206000,166124]
["De Stichtse Rijnlanden: Bunnik",33892,38400,10798,"Nee","Ja","Nee",5760,5.1360350076103503,0,0,0,1,0,null,30307,null,203100,159484]
["De Stichtse Rijnlanden: De Bilt",67425,73920,28424,"Ja","Ja","Nee",13186,5.9058071138131139,0,1,1,1,0,null,29296,null,203000,157822]
["De Stichtse Rijnlanden: De Meern",40144,48000,23847,"Nee","Ja","Nee",8888,7.3508378235083782,0,0,0,1,0,null,29258,null,181000,153093]
["De Stichtse Rijnlanden: Driebergen",59646,44400,13392,"Nee","Ja","Ja",8197,4.4760779503359895,1,1,0,1,1,null,28861,null,178700,146193]
["De Stichtse Rijnlanden: Houten",59056,72000,14410,"Nee","Ja","Ja",12134,3.2536222230752037,0,0,0,1,1,null,28388,null,172267,142238]
["De Stichtse Rijnlanden: Leidsche Rijn",81914,81600,28550,"Ja","Ja","Nee",10388,7.5297630036765284,1,1,1,1,0,null,28074,null,168821,138923]
["De Stichtse Rijnlanden: Lopik",25058,33333,8471,"Ja","Ja","Nee",4622,5.021250363064083,0,0,1,1,0,null,26508,null,165220,132199]
["De Stichtse Rijnlanden: Maarssenbroek",55348,54000,10334,"Nee","Ja","Nee",6279,4.509050607918982,1,1,0,1,0,null,26158,null,165013,131021]
["De Stichtse Rijnlanden: Montfoort",21111,18529,9656,"Nee","Ja","Nee",3785,6.989377680461808,1,1,0,1,0,null,25899,null,160500,129619]
["De Stichtse Rijnlanden: Nieuwegein",131021,144000,90602,"Ja","Ja","Nee",26508,9.3641412982588879,0,1,1,1,0,null,25709,null,150500,127395]
["De Stichtse Rijnlanden: Oudewater",22677,24400,5873,"Ja","Ja","Nee",3014,5.3385570533855704,0,1,1,1,0,null,25691,null,150000,126639]
["De Stichtse Rijnlanden: Rhenen",48930,46800,16770,"Ja","Ja","Nee",8053,5.7053527231406997,1,1,1,1,0,null,25585,null,147787,126214]
["De Stichtse Rijnlanden: Utrecht",406130,480000,181478,"Nee","Ja","Nee",64365,7.7246950982676923,0,0,0,1,0,null,24427,null,145670,125337]
["De Stichtse Rijnlanden: Wijk bij Duurstede",31652,31800,14174,"Ja","Ja","Nee",6237,6.2262107924208383,0,1,1,1,0,null,24332,null,145100,124288]
["De Stichtse Rijnlanden: Woerden",67303,75960,45300,"Ja","Ja","Nee",15971,7.7709341331848902,0,0,1,1,0,null,24047,null,145000,122028]
["De Stichtse Rijnlanden: Zeist",82566,90000,43663,"Ja","Nee","Nee",13177,9.0782922921944742,0,1,1,0,0,null,23728,null,144900,121447]
["Delfland: de Groote Lucht",237412,257956,248488,"Ja","Nee","Nee",74783,9.1035267520143659,0,1,1,0,0,null,23566,null,144000,119816]
["Delfland: Harnaschpolder",1060482,1185693,552560,"Nee","Ja","Nee",197139,7.6791655314201153,0,0,0,1,0,null,23285,null,140000,119597]
["Delfland: Houtrust",344993,389197,278813,"Nee","Nee","Ja",64310,11.877954173172327,0,0,0,0,1,null,22861,null,137510,119209]
["Delfland: Nieuwe Waterweg",101710,99562,72099,"Nee","Ja","Nee",24427,{"$f":"+D68/(H68*365)*1000","v":8.086605266685023},{"$f":"+IFERROR(IF(B68>C68,1,0),\"\")","v":1},{"$f":"+IFERROR(IF(B68/C68>0.9,1,0),\"\")","v":1},{"$f":"+IF(E68=\"Ja\",1,0)","v":0},1,0,null,22457,null,137451,118258]
["Drents Overijsselse Delta: Dalfsen",32514,31733,10747,"Nee","Ja","Nee",7432,3.961764749251663,1,1,0,1,0,null,22102,null,136000,115662]
["Drents Overijsselse Delta: Deventer",121447,165013,68899,"Nee","Ja","Nee",22457,8.4055921789038539,0,0,0,1,0,null,21647,null,131500,114334]
["Drents Overijsselse Delta: Genemuiden",31236,40709,13825,"Nee","Ja","Nee",7387,5.1274823783358769,0,0,0,1,0,null,21505,null,129700,113894]
["Drents Overijsselse Delta: Heino",7974,10203,2460,"Nee","Ja","Ja",1762,3.8250431483525884,0,0,0,1,1,null,21211,null,129000,110463]
["Drents Overijsselse Delta: Hessenpoort",14639,25613,5734,"Nee","Ja","Nee",3599,4.3649872300905503,0,0,0,1,0,null,21168,null,127000,108947]
["Drents Overijsselse Delta: Kampen",70119,81500,31634,"Nee","Ja","Nee",15171,5.7127739206832064,0,0,0,1,0,null,20911,null,122000,107069]
["Drents Overijsselse Delta: Olst-Wijhe",27339,31000,7841,"Nee","Ja","Nee",5640,3.8088992519187799,0,0,0,1,0,null,20664,null,121408,102464]
["Drents Overijsselse Delta: Raalte",56993,73685,11813,"Nee","Ja","Nee",10376,3.1191580148076175,0,0,0,1,0,null,20567,null,121000,102243]
["Drents Overijsselse Delta: Zwolle",171261,172267,114554,"Ja","Ja","Nee",30406,10.321863294825553,0,1,1,1,0,null,19945,null,120496,101710]
["Drents Overijsselse Delta: Beilen",60662,74528,20730,"Nee","Ja","Nee",10832,5.2432164464498898,0,0,0,1,0,null,19739,null,120496,101412]
["Drents Overijsselse Delta: Dieverbrug",25921,38987,12277,"Nee","Ja","Nee",5616,5.989247941302736,0,0,0,1,0,null,19563,null,120000,99207]
["Drents Overijsselse Delta: Echten",138923,168821,68019,"Nee","Ja","Nee",31789,5.8621983911898532,0,0,0,1,0,null,19299,null,120000,99019]
["Drents Overijsselse Delta: Meppel",98998,129000,24790,"Nee","Ja","Nee",17581,3.8631368078708879,0,0,0,1,0,null,19197,null,116960,98998]
["Drents Overijsselse Delta: Smilde",11658,12294,3817,"Nee","Ja","Nee",2949,3.5461289408529475,0,1,0,1,0,null,19084,null,116400,97208]
["Drents Overijsselse Delta: Steenwijk",59477,67093,15096,"Nee","Ja","Nee",9613,4.3023930208664352,0,0,0,1,0,null,18697,null,113500,94919]
["Drents Overijsselse Delta: Vollenhove",7224,14507,2474,"Nee","Ja","Nee",1340,5.0582702923737477,0,0,0,1,0,null,18060,null,110341,90730]
["Fryslân: Akkrum",7534,16320,2851,"Nee","Nee","Nee",1929,4.0492270109432811,0,0,0,0,0,null,17581,null,108800,88290]
["Fryslân: Ameland",12737,25387,3819,"Nee","Ja","Nee",1957,5.3464556456975663,0,0,0,1,0,null,17528,null,108000,87767]
["Fryslân: Birdaard",24720,29920,14025,"Nee","Ja","Nee",7189,5.3449238467445506,0,0,0,1,0,null,16811,null,108000,87571]
["Fryslân: Bolsward",49561,40800,23693,"Nee","Ja","Nee",9000,7.2124809741248095,1,1,0,1,0,null,16605,null,102000,87237]
["Fryslân: Burgum",32884,66187,11479,"Nee","Ja","Nee",11712,2.6852215734710683,0,0,0,1,0,null,16212,null,102000,86597]
["Fryslân: Damwoude",21666,41707,11589,"Nee","Ja","Nee",5954,5.3326645837263769,0,0,0,1,0,null,16177,null,102000,86450]
["Fryslân: Dokkum",30703,45333,17384,"Nee","Nee","Nee",12423,3.8338080383380801,0,0,0,0,0,null,16172,null,101248,82566]
["Fryslân: Drachten",97208,90667,49397,"Nee","Nee","Nee",25899,5.2254622408333313,1,1,0,0,0,null,16125,null,100000,81914]
["Fryslân: Franeker",52338,54400,40337,"Nee","Ja","Nee",11968,9.2339846897663183,0,1,0,1,0,null,16120,null,99562,79967]
["Fryslân: Gorredijk",25679,37173,10457,"Nee","Ja","Nee",7997,3.582507823995642,0,0,0,1,0,null,15971,null,98000,79377]
["Fryslân: Grou",28138,22667,5280,"Nee","Nee","Nee",5495,2.63253019557007,1,1,0,0,0,null,15924,null,95200,79332]
["Fryslân: Harlingen",36458,116960,9248,"Nee","Ja","Nee",10475,2.418805374832445,0,0,0,1,0,null,15887,null,95000,79261]
["Fryslân: Heerenveen",126639,136000,48925,"Nee","Ja","Nee",21505,6.2330200367547528,0,1,0,1,0,null,15733,null,90667,77142]
["Fryslân: Joure",38351,62560,8077,"Nee","Nee","Nee",7317,3.0242950831334801,0,0,0,0,0,null,15513,null,90395,74443]
["Fryslân: Kootstertille",32879,44427,11234,"Nee","Ja","Nee",12835,2.3979806927760672,0,0,0,1,0,null,15336,null,90395,73274]
["Fryslân: Leeuwarden",182484,226667,65977,"Nee","Ja","Nee",41725,4.3321486904634874,0,0,0,1,0,null,15171,null,90000,70573]
["Fryslân: Lemmer",19922,38080,4844,"Nee","Ja","Nee",3551,3.7373226912735364,0,0,0,1,0,null,15146,null,90000,70119]
["Fryslân: Oosterwolde",43795,40800,12967,"Nee","Nee","Nee",10115,3.5122122982956276,1,1,0,0,0,null,15056,null,90000,69925]
["Fryslân: Schiermonnikoog",4414,9067,1146,"Nee","Ja","Nee",695,4.5175914063269937,0,0,0,1,0,null,14875,null,89760,67425]
["Fryslân: Sloten",16237,19947,7940,"Nee","Ja","Nee",3047,7.1392926345698218,0,0,0,1,0,null,14763,null,87310,67303]
["Fryslân: Sneek",52877,66187,23417,"Nee","Nee","Nee",11689,5.4885930690017659,0,0,0,0,0,null,14704,null,87267,67134]
["Fryslân: St.Annaparochie",12941,16320,8251,"Nee","Ja","Nee",4028,5.6120852661506442,0,0,0,1,0,null,14591,null,86400,66470]
["Fryslân: Terschelling",14007,27200,6143,"Nee","Nee","Nee",1933,8.7067444316096072,0,0,0,0,0,null,14425,null,84859,66266]
["Fryslân: Vlieland",3368,9973,734,"Nee","Ja","Nee",580,3.4671705243268778,0,0,0,1,0,null,14316,null,83413,66257]
["Fryslân: Warns",8581,14507,2852,"Nee","Ja","Nee",1689,4.6262277265464693,0,0,0,1,0,null,13879,null,82500,65800]
["Fryslân: Wijnjewoude",null,null,null,null,null,null,3303,0,0,"",0,0,0,null,13584,null,81600,64560]
["Fryslân: Wolvega",36087,62560,15248,"Nee","Ja","Nee",6047,6.9084409567973255,0,0,0,1,0,null,13502,null,81500,64410]
["Fryslân: Workum",15604,18133,5451,"Nee","Ja","Nee",4796,3.113896283432541,0,0,0,1,0,null,13242,null,78900,64391]
["Hollands Noorderkwartier: Alkmaar",70573,67400,54734,"Nee","Nee","Nee",15887,9.4389226652962588,1,1,0,0,0,null,13186,null,77970,63948]
["Hollands Noorderkwartier: Beemster",122028,144900,61771,"Ja","Ja","Nee",24047,7.0377018521377375,0,0,1,1,0,null,13177,null,76000,63533]
["Hollands Noorderkwartier: Beverwijk",209391,318288,161516,"Ja","Ja","Nee",49790,8.8875193621429176,0,0,1,1,0,null,13041,null,75960,62598]
["Hollands Noorderkwartier: Den Helder",53531,110341,35844,"Ja","Ja","Nee",22861,4.2956449729245172,0,0,1,1,0,null,12960,null,75844,61516]
["Hollands Noorderkwartier: Everstekoog",33296,44900,10364,"Ja","Nee","Nee",5624,5.0488123307157196,0,0,1,0,0,null,12944,null,74709,60662]
["Hollands Noorderkwartier: Geestmerambacht",234699,238453,124242,"Nee","Ja","Nee",45700,7.4483378795599648,0,1,0,1,0,null,12927,null,74528,60515]
["Hollands Noorderkwartier: Heiloo",45441,95200,27111,"Ja","Ja","Nee",10698,6.9430465814887938,0,0,1,1,0,null,12835,null,74350,60449]
["Hollands Noorderkwartier: Katwoude",79377,87310,47207,"Nee","Ja","Nee",12927,10.004969952451649,0,1,0,1,0,null,12804,null,73920,60126]
["Hollands Noorderkwartier: Oosthuizen",8777,9230,3540,"Nee","Ja","Nee",1235,7.8531418113249405,0,1,0,1,0,null,12485,null,73685,59677]
["Hollands Noorderkwartier: Stolpen",47083,57000,40624,"Nee","Ja","Nee",10341,10.762849834347385,0,0,0,1,0,null,12423,null,73500,59646]
["Hollands Noorderkwartier: Ursem",44044,56304,24948,"Ja","Nee","Nee",9660,7.0756402620607499,0,0,1,0,0,null,12357,null,73405,59477]
["Hollands Noorderkwartier: Wervershoof",280736,277400,85093,"Ja","Ja","Nee",49650,4.6954986273779467,1,1,1,1,0,null,12153,null,72533,59239]
["Hollands Noorderkwartier: Wieringen",9342,15286,8575,"Nee","Ja","Nee",2498,9.4047841012536058,0,0,0,1,0,null,12134,null,72000,59056]
["Hollands Noorderkwartier: Wieringermeer",11618,16400,10860,"Nee","Ja","Nee",2859,10.406934122957065,0,0,0,1,0,null,12085,null,71200,58592]
["Hollands Noorderkwartier: Zaandam Oost",127395,137451,82920,"Ja","Ja","Nee",19197,11.834040849704683,0,1,1,1,0,null,11968,null,70000,58229]
["Hollandse Delta: Barendrecht",45318,51000,21170,"Nee","Ja","Nee",10571,5.4867089206319175,0,0,0,1,0,null,11889,null,69904,57699]
["Hollandse Delta: Den Bommel",2863,3673,2190,"Nee","Ja","Nee",1040,5.7692307692307692,0,0,0,1,0,null,11756,null,69800,56993]
["Hollandse Delta: Dokhaven",475209,564000,768325,"Nee","Nee","Nee",119407,17.628782232197441,0,0,0,0,0,null,11712,null,68100,56706]
["Hollandse Delta: Dordrecht",267726,281112,133225,"Nee","Ja","Nee",51924,7.029504660657885,0,1,0,1,0,null,11689,null,67400,56437]
["Hollandse Delta: Goedereede",29807,42000,4380,"Nee","Ja","Nee",6066,{"$f":"+D132/(H132*365)*1000","v":1.9782393669634024},{"$f":"+IFERROR(IF(B132>C132,1,0),\"\")","v":0},{"$f":"+IFERROR(IF(B132/C132>0.9,1,0),\"\")","v":0},{"$f":"+IF(E132=\"Ja\",1,0)","v":0},1,0,null,11648,null,67093,55348]
["Hollandse Delta: Heenvliet",7438,8051,4015,"Nee","Ja","Nee",2508,4.3859649122807012,0,1,0,1,0,null,11554,null,66650,54632]
["Hollandse Delta: Hellevoetsluis",79967,108000,37595,"Nee","Ja","Nee",23728,4.3408631153068109,0,0,0,1,0,null,11442,null,66187,54418]
["Hollandse Delta: Hoogvliet",90730,90000,99645,"Nee","Ja","Nee",23285,11.724286021043591,1,1,0,1,0,null,11420,null,66187,53980]
["Hollandse Delta: Middelharnis",34135,48000,6570,"Nee","Ja","Nee",8636,2.0842982862436314,0,0,0,1,0,null,11203,null,66000,53531]
["Hollandse Delta: Numansdorp",17369,26000,7300,"Nee","Ja","Nee",5833,3.4287673581347509,0,0,0,1,0,null,11074,null,66000,52877]
["Hollandse Delta: Ooltgensplaat",2660,3083,1825,"Nee","Ja","Nee",1123,4.4523597506678536,0,0,0,1,0,null,10971,null,65460,52338]
["Hollandse Delta: Oostvoorne",31300,45000,10950,"Nee","Ja","Nee",6826,4.3949604453559914,0,0,0,1,0,null,10832,null,65280,51103]
["Hollandse Delta: Oud Beijerland",45245,60000,9490,"Nee","Ja","Nee",13242,1.9634496299652622,0,0,0,1,0,null,10767,null,65000,50783]
["Hollandse Delta: Oude Tonge",11879,15600,8395,"Nee","Ja","Nee",3356,6.8533969010727054,0,0,0,1,0,null,10698,null,64942,50574]
["Hollandse Delta: Piershil",5939,6600,4015,"Nee","Ja","Nee",1740,6.3218390804597702,0,0,0,1,0,null,10571,null,64373,50515]
["Hollandse Delta: Ridderkerk",73274,87267,31025,"Nee","Ja","Nee",20567,4.1328341517965681,0,0,0,1,0,null,10475,null,64000,50149]
["Hollandse Delta: Rozenburg",15503,21600,11680,"Nee","Ja","Nee",5254,6.0905976398934145,0,0,0,1,0,null,10388,null,64000,49561]
["Hollandse Delta: Spijkenisse",125337,102000,23360,"Nee","Ja","Nee",23566,2.7157769668166005,1,1,0,1,0,null,10376,null,63500,48930]
["Hollandse Delta: Strijen",11394,17000,1460,"Nee","Ja","Nee",3363,1.1894142134998513,0,0,0,1,0,null,10341,null,63500,48889]
["Hollandse Delta: Zwijndrecht",153093,227999,45990,"Nee","Ja","Nee",41582,3.0301572795921312,0,0,0,1,0,null,10115,null,62560,48396]
["Hunze en Aa's: Assen",99207,121408,55048,"Nee","Ja","Nee",21168,7.1247372617235625,0,0,0,1,0,null,10065,null,62560,48158]
["Hunze en Aa's: Bellingwolde",5348,10514,2052,"Ja","Ja","Nee",1503,3.7404642769256009,0,0,1,1,0,null,10056,null,61538,47917]
["Hunze en Aa's: Foxhol",40372,64942,15410,"Ja","Ja","Nee",9731,4.338626871050435,0,0,1,1,0,null,9959,null,61200,47767]
["Hunze en Aa's: Gieten",45538,50338,23864,"Nee","Ja","Nee",9157,7.1399827364648054,0,1,0,1,0,null,9731,null,60000,47231]
["Hunze en Aa's: Hoogezand",33823,59509,7518,"Ja","Nee","Nee",8599,2.3953087886931739,0,0,1,0,0,null,9693,null,60000,47083]
["Hunze en Aa's: Oude Pekela",13257,24734,4203,"Ja","Ja","Nee",3763,3.0600766657323106,0,0,1,1,0,null,9692,null,60000,47079]
["Hunze en Aa's: Scheemda",58592,75844,29763,"Ja","Ja","Nee",16811,4.8505422493263133,0,0,1,1,0,null,9660,null,59509,46881]
["Hunze en Aa's: Scheve Klap",5575,10842,2563,"Nee","Ja","Nee",1871,3.7530292935431202,0,0,0,1,0,null,9613,null,58500,46617]
["Hunze en Aa's: Stadskanaal",42380,56257,19285,"Ja","Ja","Nee",9693,5.450904409197995,0,0,1,1,0,null,9571,null,57845,46112]
["Hunze en Aa's: Ter Apel",17870,29172,6363,"Ja","Ja","Nee",3786,4.604563315459262,0,0,1,1,0,null,9532,null,57346,45996]
["Hunze en Aa's: Tweede Exloermond",8990,13421,3887,"Ja","Ja","Nee",2192,4.8582641735826417,0,0,1,1,0,null,9474,null,57300,45538]
["Hunze en Aa's: Veendam",63948,84859,29501,"Nee","Ja","Nee",16212,4.9854834403063517,0,0,0,1,0,null,9335,null,57000,45441]
["Hunze en Aa's: Vriescheloo",8079,17392,2876,"Ja","Ja","Nee",1832,4.3010109469402407,0,0,1,1,0,null,9323,null,56304,45318]
["Noorderzijlvest: Delfzijl",42694,73405,15823,"Nee","Ja","Nee",14316,3.0281283131815346,0,0,0,1,0,null,9157,null,56257,45245]
["Noorderzijlvest: Eelde",69925,101248,32184,"Nee","Ja","Nee",19945,4.4209246661194994,0,0,0,1,0,null,9150,null,56213,44494]
["Noorderzijlvest: Feerwerd",3174,4819,2105,"Nee","Ja","Nee",1290,4.4706382074970801,0,0,0,1,0,null,9112,null,55000,44044]
["Noorderzijlvest: Gaarkeuken",15901,16266,9619,"Nee","Ja","Nee",4987,5.2844244350379475,0,1,0,1,0,null,9092,null,54400,44023]
["Noorderzijlvest: Garmerwolde",329588,340146,244482,"Nee","Nee","Nee",82229,8.1457113503768372,0,1,0,0,0,null,9000,null,54400,44007]
["Noorderzijlvest: Hoogkerk",null,null,null,null,null,null,2995,0,0,"",0,0,0,null,8946,null,54000,43795]
["Noorderzijlvest: Leek",34271,39668,10159,"Nee","Nee","Ja",6569,4.2370036097318868,0,0,0,0,1,null,8888,null,54000,42694]
["Noorderzijlvest: Marum",11035,8433,6397,"Nee","Ja","Nee",2487,7.0470556482751405,1,1,0,1,0,null,8749,null,54000,42380]
["Noorderzijlvest: Onderdendam",13932,20720,9467,"Nee","Ja","Nee",4818,5.3833512456143344,0,0,0,1,0,null,8636,null,53500,42343]
["Noorderzijlvest: Uithuizen",null,null,null,null,null,null,0,{"$error":"#DIV/0!"},0,"",0,0,0,null,8606,null,51000,42197]
["Noorderzijlvest: Uithuizermeeden",13751,14171,6046,"Nee","Ja","Ja",4059,4.0809025773943919,0,1,0,1,1,null,8599,null,50338,40372]
["Noorderzijlvest: Ulrum",8938,18444,3596,"Nee","Ja","Nee",2109,4.6714342316361064,0,0,0,1,0,null,8596,null,50200,40144]
["Noorderzijlvest: Wehe den Hoorn",5484,8435,4108,"Nee","Ja","Nee",1736,6.4831765671359127,0,0,0,1,0,null,8400,null,50000,39276]
["Noorderzijlvest: Winsum",17265,21078,12957,"Nee","Ja","Nee",4781,7.4249383260795447,0,0,0,1,0,null,8352,null,48000,39148]
["Noorderzijlvest: Zuidhorn 1",9255,9646,4748,"Nee","Ja","Nee",2059,6.3177363662371011,0,1,0,1,0,null,8276,null,48000,38497]
["Noorderzijlvest: Zuidhorn 2",6565,7838,3511,"Nee","Ja","Nee",1879,5.1193071219754023,0,0,0,1,0,null,8274,null,48000,38351]
["Rijn en IJssel: Aalten",26576,29920,8545,"Nee","Ja","Nee",4680,5.0023416461772623,0,0,0,1,0,null,8197,null,48000,37878]
["Rijn en IJssel: Dinxperlo",12997,16773,5192,"Nee","Nee","Nee",2736,5.1990707362012341,0,0,0,0,0,null,8122,null,48000,37651]
["Rijn en IJssel: Etten",178340,206720,69001,"Nee","Ja","Nee",28861,6.5501484916128465,0,0,0,1,0,null,8053,null,47500,37605]
["Rijn en IJssel: Haarlo",79332,29467,15215,"Nee","Ja","Nee","-",{"$error":"#VALUE!"},1,1,0,1,0,null,7997,null,46800,37530]
["Rijn en IJssel: Holten",35379,37173,14850,"Nee","Ja","Nee",4945,8.2274886768148257,0,1,0,1,0,null,7896,null,45333,36727]
["Rijn en IJssel: Lichtenvoorde",33778,65280,9236,"Nee","Ja","Nee",5090,4.9713378367467769,0,0,0,1,0,null,7792,null,45000,36458]
["Rijn en IJssel: Nieuwgraaf",255100,395000,133149,"Nee","Ja","Nee",57530,6.3408965899864036,0,0,0,1,0,null,7786,null,44900,36093]
["Rijn en IJssel: Olburgen",113894,137510,65925,"Nee","Ja","Nee",21647,8.3437168363359522,0,0,0,1,0,null,7737,null,44427,36087]
["Rijn en IJssel: Ruurlo",12274,12875,3836,"Nee","Ja","Nee",2130,4.9340793620168499,0,1,0,1,0,null,7508,null,44426,35939]
["Rijn en IJssel: Varsseveld",20076,28560,10221,"Nee","Ja","Nee",4698,5.9605661400654313,0,0,0,1,0,null,7432,null,44400,35507]
["Rijn en IJssel: Wehl",9479,10880,3747,"Nee","Ja","Nee",1602,6.4080857831819813,0,0,0,1,0,null,7387,null,44400,35379]
["Rijn en IJssel: Winterswijk",87237,83413,31269,"Nee","Ja","Nee",13584,6.3065734062636141,1,1,0,1,0,null,7317,null,44000,35094]
["Rijn en IJssel: Zutphen",249240,181000,21954,"Nee","Ja","Nee",34462,1.7453411063048996,1,1,0,1,0,null,7189,null,43200,34512]
["Rijnland: Aalsmeer",38497,"-",12403,"Nee","Ja","Ja",7737,4.3919893909536274,0,"",0,1,1,null,7082,null,42000,34271]
["Rijnland: Alphen Kerk en Zanen",64391,95000,14791,"Nee","Ja","Nee",12357,3.2793791107253281,0,0,0,1,0,null,7061,null,42000,34135]
["Rijnland: Alphen Noord",61516,69800,10702,"Nee","Ja","Nee",8749,3.3513027711973344,0,0,0,1,0,null,6826,null,41707,34030]
["Rijnland: Bodegraven",60449,76000,10936,"Nee","Ja","Ja",12153,2.4653701831330896,0,0,0,1,1,null,6597,null,41000,33892]
["Rijnland: Gouda",102464,127000,39782,"Nee","Ja","Nee",20911,5.2121744929423661,0,0,0,1,0,null,6569,null,41000,33823]
["Rijnland: Haarlem Schalkwijk",66266,102000,21906,"Nee","Ja","Nee",15733,3.8146849524035078,0,0,0,1,0,null,6388,null,40800,33778]
["Rijnland: Haarlem Waarderpolder",241704,227000,102562,"Nee","Ja","Nee",50774,{"$f":"+D196/(H196*365)*1000","v":5.5341667156796355},{"$f":"+IFERROR(IF(B196>C196,1,0),\"\")","v":1},{"$f":"+IFERROR(IF(B196/C196>0.9,1,0),\"\")","v":1},{"$f":"+IF(E196=\"Ja\",1,0)","v":0},1,0,null,6385,null,40800,33296]
["Rijnland: Heemstede",32847,44400,33273,"Nee","Nee","Nee",6149,14.824996602632792,0,0,0,0,0,null,6279,null,40709,32884]
["Rijnland: Hoogmade","-","-","-","Nee","Ja","Nee",635,{"$error":"#VALUE!"},0,"",0,1,0,null,6269,null,39668,32879]
["Rijnland: Katwijk",191920,203100,109268,"Ja","Ja","Nee",35204,8.5037036575856106,0,1,1,1,0,null,6237,null,38987,32847]
["Rijnland: Langeraar",null,null,null,null,null,null,694,0,0,"",0,0,0,null,6210,null,38400,32514]
["Rijnland: Leiden Noord",108947,140000,42489,"Nee","Ja","Nee",28388,4.1006136106130118,0,0,0,1,0,null,6149,null,38170,32305]
["Rijnland: Leiden Zuid-West",110463,122000,62433,"Nee","Ja","Nee",35656,4.7972098684230753,0,1,0,1,0,null,6138,null,38080,32243]
["Rijnland: Leimuiden",7618,9500,1950,"Nee","Ja","Ja",1896,2.8177561990636377,0,0,0,1,1,null,6066,null,37200,32132]
["Rijnland: Lisse",36093,44426,11858,"Nee","Ja","Nee",6597,4.9246128896281203,0,0,0,1,0,null,6047,null,37173,31652]
["Rijnland: Nieuwe Wetering",27131,31700,7487,"Nee","Ja","Nee",4395,4.6671965340439794,0,0,0,1,0,null,5987,null,37173,31300]
["Rijnland: Nieuwveen",36727,41000,7726,"Ja","Ja","Nee",7508,2.8192758774202491,0,0,1,1,0,null,5954,null,36913,31236]
["Rijnland: Noordwijk",79261,100000,25645,"Nee","Ja","Nee",14425,4.8707295648251465,0,0,0,1,0,null,5867,null,36800,31174]
["Rijnland: Rijnsaterwoude",3804,"-",355,"Nee","Ja","Nee",515,1.8885490091767523,0,"",0,1,0,null,5833,null,36176,30889]
["Rijnland: Rijsenhout",15263,"-",3376,"Nee","Ja","Nee",2733,3.3843084773118002,0,"",0,1,0,null,5760,null,36000,30703]
["Rijnland: Velsen",102243,121000,85858,"Ja","Ja","Nee",17528,13.420093408276697,0,0,1,1,0,null,5719,null,36000,30239]
["Rijnland: Waddinxveen-Randenburg",57699,65460,14514,"Nee","Ja","Ja",11420,3.4819950579372887,0,0,0,1,1,null,5640,null,35000,29807]
["Rijnland: Woubrugge",null,null,null,null,null,null,1290,0,0,"",0,0,0,null,5624,null,35000,28138]
["Rijnland: Zwaanshoek",187892,203000,68454,"Nee","Ja","Ja",25709,7.2949241697246903,0,1,0,1,1,null,5616,null,34000,27939]
["Rijnland: Zwanenburg",142238,228000,46778,"Nee","Ja","Nee",26158,4.8994152500034041,0,0,0,1,0,null,5576,null,33400,27596]
["Rivierenland: Aalst",11614,10500,9088,"Nee","Ja","Nee",3526,7.0614379288106353,1,1,0,1,0,null,5495,null,33333,27339]
["Rivierenland: Alblasserdam",45996,50000,26355,"Nee","Nee","Nee",7896,9.1445642669775573,0,1,0,0,0,null,5254,null,32400,27131]
["Rivierenland: Arnhem",180027,206000,89792,"Nee","Ja","Nee",29296,8.3972378294666434,0,0,0,1,0,null,5205,null,32000,26576]
["Rivierenland: Asperen",7905,8500,2560,"Nee","Ja","Nee",1690,4.150117532625436,0,1,0,1,0,null,5170,null,31800,25921]
["Rivierenland: Beesd",9502,9000,2671,"Nee","Ja","Nee",2340,3.127268469734223,1,1,0,1,0,null,5090,null,31733,25679]
["Rivierenland: Bergharen",9079,12000,2746,"Nee","Ja","Nee",1452,5.1813275972678214,0,0,0,1,0,null,5045,null,31700,25444]
["Rivierenland: Groesbeek",32243,25000,11910,"Nee","Ja","Nee",5018,6.5026179725590616,1,1,0,1,0,null,5018,null,31500,25058]
["Rivierenland: Culemborg",50515,47500,28598,"Nee","Ja","Nee",11756,6.6647401268719673,1,1,0,1,0,null,5001,null,31200,24720]
["Rivierenland: Dodewaard",34030,27000,28031,"Nee","Ja","Nee",5719,13.428442083226544,1,1,0,1,0,null,4987,null,31000,24612]
["Rivierenland: Dreumel",10029,9000,3758,"Nee","Ja","Nee",2203,4.6735771270807556,1,1,0,1,0,null,4945,null,30192,24464]
["Rivierenland: Druten",39148,44000,24467,"Nee","Ja","Nee",8596,7.7981475933374558,0,0,0,1,0,null,4818,null,30000,23978]
["Rivierenland: Dussen",9622,9500,3735,"Nee","Ja","Nee",2508,4.0800943829062071,1,1,0,1,0,null,4796,null,30000,23311]
["Rivierenland: Eck en Wiel",11633,13000,5821,"Nee","Ja","Nee",2590,6.1575078013434172,0,0,0,1,0,null,4781,null,29920,22677]
["Rivierenland: Eethen",5048,8000,2718,"Ja","Nee","Nee",954,7.8056345308865343,0,0,1,0,0,null,4698,null,29920,22157]
["Rivierenland: Geldermalsen",42197,36000,19893,"Nee","Ja","Nee",9092,5.9944313531691265,1,1,0,1,0,null,4680,null,29467,21666]
["Rivierenland: Gendt",35939,42000,23630,"Nee","Ja","Nee",6388,10.134584537789177,0,0,0,1,0,null,4648,null,29172,21318]
["Rivierenland: Gorinchem",23978,29000,7060,"Nee","Ja","Nee",5001,3.8677196067635791,0,0,0,1,0,null,4622,null,29000,21111]
["Rivierenland: Groot-Ammers",37530,35000,26666,"Nee","Ja","Nee",8606,8.4891394662532349,1,1,0,1,0,null,4559,null,28800,20438]
["Rivierenland: Haaften",17327,15000,6927,"Nee","Nee","Nee",3421,5.547524756439878,1,1,0,0,0,null,4512,null,28560,20076]
["Rivierenland: Hardinxveld De Peulen",17075,19000,10261,"Nee","Ja","Nee",4292,6.5499368050147453,0,0,0,1,0,null,4395,null,27200,19922]
["Rivierenland: Leerdam",47079,35000,16743,"Nee","Ja","Nee",7082,6.4771579888043389,1,1,0,1,0,null,4292,null,27000,19889]
["Rivierenland: Lienden",9125,8000,3815,"Nee","Ja","Nee",1786,5.8522143306386045,1,1,0,1,0,null,4203,null,26512,19720]
["Rivierenland: Maasbommel",4408,7000,1387,"Nee","Ja","Nee",765,4.9673202614379086,0,0,0,1,0,null,4059,null,26000,18009]
["Rivierenland: Millingen",6495,13000,4737,"Nee","Nee","Ja",2245,5.7808829362052663,0,0,0,0,1,null,4028,null,25613,17870]
["Rivierenland: Nieuw-Lekkerland",null,null,null,null,null,null,1978,0,0,"",0,0,0,null,3979,null,25387,17792]
["Rivierenland: Nijmegen",373567,400000,249068,"Nee","Ja","Nee",69658,9.7961193573140317,0,1,0,1,0,null,3934,null,25000,17674]
["Rivierenland: Overasselt",8459,12000,2197,"Nee","Ja","Nee",1285,4.6841852779702577,0,0,0,1,0,null,3868,null,24734,17369]
["Rivierenland: Papendrecht",37878,48000,18146,"Nee","Ja","Nee",11648,4.268120578052085,0,0,0,1,0,null,3786,null,24500,17327]
["Rivierenland: Schelluinen",64410,98000,14569,"Ja","Nee","Nee",16177,2.4673962102460707,0,0,1,0,0,null,3785,null,24400,17265]
["Rivierenland: Sleeuwijk",47767,64000,37369,"Nee","Nee","Nee",13041,7.8506879777477359,0,0,0,0,0,null,3763,null,24000,17075]
["Rivierenland: Sliedrecht",46881,48000,27227,"Nee","Ja","Nee",11074,6.7360051063703459,0,1,0,1,0,null,3666,null,22667,16237]
["Rivierenland: Tiel",115662,120000,48029,"Nee","Ja","Nee",20664,6.3679007631563591,0,1,0,1,0,null,3599,null,22600,15901]
["Rivierenland: Valburg",11324,9500,6777,"Nee","Ja","Nee",2264,8.2010261871339374,1,1,0,1,0,null,3568,null,22500,15796]
["Rivierenland: Vianen",34512,48000,11048,"Nee","Ja","Nee",8274,3.6582660322316811,0,0,0,1,0,null,3551,null,21600,15604]
["Rivierenland: Wijk en Aalburg",13100,13000,6533,"Nee","Ja","Nee",2499,7.1623169815871552,1,1,0,1,0,null,3546,null,21300,15503]
["Rivierenland: Zaltbommel",86597,66000,40337,"Nee","Ja","Nee",16125,6.8534777529998934,1,1,0,1,0,null,3528,null,21078,15421]
["Rivierenland: Zetten",9543,8000,7415,"Nee","Nee","Nee",1734,11.715725774596704,1,1,0,0,0,null,3526,null,20926,15263]
["Scheldestromen: Breskens",12196,21300,9224,"Nee","Ja","Nee",3092,8.1731024827659535,0,0,0,1,0,null,3513,null,20720,14679]
["Scheldestromen: Camperlandpolder",12322,34000,5827,"Nee","Ja","Ja",3868,4.1272966808799989,0,0,0,1,1,null,3499,null,19947,14639]
["Scheldestromen: De Verseput",24464,31500,8288,"Nee","Ja","Ja",6138,3.6993889402196962,0,0,0,1,1,null,3421,null,19900,14306]
["Scheldestromen: Groede",4115,9800,3358,"Nee","Ja","Nee",770,11.948051948051949,0,0,0,1,0,null,3388,null,19000,14007]
["Scheldestromen: Hulst",17674,36800,9947,"Nee","Ja","Nee",6385,4.2681370077557634,0,0,0,1,0,null,3363,null,18529,13932]
["Scheldestromen: Kloosterzande",6853,9000,5110,"Nee","Ja","Ja",2232,6.2724014336917566,0,0,0,1,1,null,3356,null,18444,13751]
["Scheldestromen: Mastgat",13120,24500,11933,"Nee","Ja","Nee",3979,8.2164238966905021,0,0,0,1,0,null,3303,null,18200,13592]
["Scheldestromen: Oostburg",12025,14000,15877,"Nee","Ja","Ja",3499,12.431731962556817,0,0,0,1,1,null,3276,null,18133,13362]
["Scheldestromen: Retranchement",15421,50200,5491,"Nee","Ja","Nee",3388,{"$f":"+D260/(H260*365)*1000","v":4.4403292846630338},{"$f":"+IFERROR(IF(B260>C260,1,0),\"\")","v":0},{"$f":"+IFERROR(IF(B260/C260>0.9,1,0),\"\")","v":0},{"$f":"+IF(E260=\"Ja\",1,0)","v":0},1,0,null,3242,null,17392,13257]
["Scheldestromen: Sint Maartensdijk",15796,37200,9183,"Nee","Ja","Nee",5170,4.8663257465355976,0,0,0,1,0,null,3217,null,17340,13120]
["Scheldestromen: Terneuzen",66257,86400,62016,"Nee","Ja","Nee",19563,8.6851121665934929,0,0,0,1,0,null,3092,null,17000,13100]
["Scheldestromen: Tholen",14306,18200,6900,"Nee","Ja","Nee",3217,5.8763163161458181,0,0,0,1,0,null,3047,null,16773,12997]
["Scheldestromen: Waarde",35507,78900,18569,"Nee","Ja","Nee",8400,6.0564253098499679,0,0,0,1,0,null,3014,null,16770,12941]
["Scheldestromen: Walcheren",159484,178700,145380,"Nee","Ja","Ja",41663,9.5600741632386939,0,0,0,1,1,null,2995,null,16400,12737]
["Scheldestromen: Westerschouwen",20438,73500,13315,"Nee","Nee","Ja",6269,5.8190225003660112,0,0,0,0,1,null,2971,null,16320,12322]
["Scheldestromen: Willem Annapolder",99019,90000,114238,"Nee","Ja","Ja",25585,12.232981118538527,1,1,0,1,1,null,2949,null,16320,12274]
["Schieland en de Krimpenerwaard: Ammerstol",2285,3700,1101,"Nee","Ja","Nee",784,3.8474979032708974,0,0,0,1,0,null,2859,null,16266,12196]
["Schieland en de Krimpenerwaard: Bergambacht",8532,8800,2983,"Nee","Ja","Nee",2458,3.3248994059096941,0,1,0,1,0,null,2736,null,16200,12025]
["Schieland en de Krimpenerwaard: Berkenwoude",3386,3800,611,"Nee","Ja","Nee",477,3.5093765256598028,0,0,0,1,0,null,2733,null,15600,11879]
["Schieland en de Krimpenerwaard: De Groote Zaag",54418,68100,29260,"Nee","Ja","Nee",18060,4.4387809281087396,0,0,0,1,0,null,2590,null,15286,11658]
["Schieland en de Krimpenerwaard: Groenedijk",53980,70000,14219,"Nee","Ja","Nee",15924,2.4463805817358479,0,0,0,1,0,null,2582,null,15000,11633]
["Schieland en de Krimpenerwaard: Haastrecht",6024,9600,1555,"Nee","Ja","Nee",1172,3.6350460517088226,0,0,0,1,0,null,2514,null,14507,11618]
["Schieland en de Krimpenerwaard: Kortenoord",119209,120000,42591,"Nee","Ja","Nee",22102,5.2795073401898787,0,1,0,1,0,null,2508,null,14507,11614]
["Schieland en de Krimpenerwaard: Kralingseveer",311102,360000,222775,"Nee","Ja","Nee",87946,6.9399684551136449,0,0,0,1,0,null,2508,null,14416,11394]
["Schieland en de Krimpenerwaard: Stolwijk",7533,10800,2118,"Nee","Ja","Nee",1469,3.950129153184069,0,0,0,1,0,null,2499,null,14171,11324]
["Vallei en Veluwe: Amersfoort",289384,303700,132689,"Nee","Ja","Nee",42334,8.5872231976499993,0,1,0,1,0,null,2498,null,14050,11035]
["Vallei en Veluwe: Apeldoorn",319586,317000,256570,"Ja","Ja","Nee",62363,11.271611481957493,1,1,1,1,0,null,2487,null,14000,10943]
["Vallei en Veluwe: Bennekom",19720,19900,5741,"Nee","Ja","Nee",3546,4.4356365265898674,0,1,0,1,0,null,2458,null,13421,10687]
["Vallei en Veluwe: Brummen",30889,41000,11166,"Nee","Ja","Nee",5987,5.1097011561579766,0,0,0,1,0,null,2354,null,13200,10675]
["Vallei en Veluwe: Ede",277359,272000,97479,"Nee","Ja","Nee",41999,6.358859816296996,1,1,0,1,0,null,2340,null,13000,10464]
["Vallei en Veluwe: Elburg",124288,145000,35963,"Nee","Ja","Nee",19084,5.1628991366216557,0,0,0,1,0,null,2313,null,13000,10173]
["Vallei en Veluwe: Epe",35094,55000,7384,"Nee","Nee","Nee",5576,3.6280733476150235,0,0,0,0,0,null,2264,null,13000,10029]
["Vallei en Veluwe: Harderwijk",244168,209000,101685,"Nee","Ja","Nee",34150,8.1578050101285626,1,1,0,1,0,null,2245,null,12875,9774]
["Vallei en Veluwe: Hattem",54632,64000,14482,"Nee","Ja","Nee",11889,3.3372623709956368,0,0,0,1,0,null,2232,null,12690,9622]
["Vallei en Veluwe: Heerde",24612,32000,8692,"Nee","Ja","Nee",4512,5.2778587389488001,0,0,0,1,0,null,2203,null,12294,9543]
["Vallei en Veluwe: Nijkerk",101412,53500,37309,"Nee","Ja","Nee",16172,6.3205811498988611,1,1,0,1,0,null,2192,null,12000,9502]
["Vallei en Veluwe: Renkum",87767,145100,62188,"Nee","Nee","Nee",16605,10.260649334042807,0,0,0,0,0,null,2130,null,12000,9479]
["Vallei en Veluwe: Soest",107069,129700,42018,"Nee","Ja","Nee",18697,6.1570202823542859,0,0,0,1,0,null,2109,null,12000,9342]
["Vallei en Veluwe: Terwolde",47917,36000,65640,"Ja","Ja","Nee",9112,19.736129986650148,1,1,1,1,0,null,2080,null,11880,9255]
["Vallei en Veluwe: Veenendaal",118258,150500,28093,"Nee","Ja","Nee",24332,3.1632057902215696,0,0,0,1,0,null,2059,null,10880,9125]
["Vallei en Veluwe: Woudenberg",42343,54400,14857,"Nee","Ja","Nee",9335,4.3603759602614991,0,0,0,1,0,null,1978,null,10842,9079]
["Vechtstromen: Almelo-Sumpel",114334,102000,29804,"Nee","Nee","Ja",19299,4.2310375936860947,1,1,0,0,1,null,1957,null,10800,8990]
["Vechtstromen: Almelo-Vissedijk",63533,108000,30203,"Nee","Nee","Ja",12960,6.3848723152376117,0,0,0,0,1,null,1933,null,10514,8938]
["Vechtstromen: Coevorden",67134,61538,19300,"Ja","Nee","Nee",9474,5.5812447043241633,1,1,1,0,0,null,1929,null,10500,8777]
["Vechtstromen: Dedemsvaart",60126,36913,21161,"Nee","Nee","Ja",9323,6.2185286351768125,1,1,0,0,1,null,1896,null,10203,8581]
["Vechtstromen: Den Ham",7000,13200,2324,"Nee","Nee","Ja",1572,4.0503328801979848,0,0,0,0,1,null,1879,null,9973,8532]
["Vechtstromen: Denekamp",30239,32400,4519,"Nee","Nee","Ja",3934,3.1471331768704167,0,1,0,0,1,null,1871,null,9800,8459]
["Vechtstromen: Emmen",241949,210933,35974,"Nee","Nee","Ja",30649,3.215729847942479,1,1,0,0,1,null,1832,null,9646,8079]
["Vechtstromen: Enschede-West",273294,330000,110163,"Ja","Nee","Nee",49322,6.1193065641329305,0,0,1,0,0,null,1786,null,9600,7974]
["Vechtstromen: Glanerbrug",13362,16200,3770,"Nee","Nee","Ja",4203,2.4574749282150066,0,0,0,0,1,null,1762,null,9500,7972]
["Vechtstromen: Goor",48158,54000,19065,"Ja","Nee","Nee",6210,8.411091258023955,0,0,1,0,0,null,1741,null,9500,7905]
["Vechtstromen: Haaksbergen",50149,43200,11616,"Ja","Nee","Nee",9959,3.195567580504727,1,1,1,0,0,null,1740,null,9500,7752]
["Vechtstromen: Hardenberg",50574,57346,17294,"Nee","Nee","Ja",9571,4.9504567879853951,0,0,0,0,1,null,1736,null,9230,7618]
["Vechtstromen: Hengelo",166124,235200,149987,"Ja","Nee","Nee",43773,9.3875970957264254,0,0,1,0,0,null,1734,null,9067,7534]
["Vechtstromen: Losser",27939,30000,6650,"Ja","Nee","Nee",7061,2.5802546497934826,0,1,1,0,0,null,1690,null,9000,7533]
["Vechtstromen: Nijverdal",74443,116400,26522,"Ja","Nee","Nee",10971,6.6231896544189359,0,0,1,0,0,null,1689,null,9000,7438]
["Vechtstromen: Oldenzaal",88290,66000,30320,"Ja","Nee","Nee",15056,5.5173016173409231,1,1,1,0,0,null,1602,null,9000,7224]
["Vechtstromen: Ommen",27596,26512,6453,"Ja","Nee","Nee",3568,4.9550033785859089,1,1,1,0,0,null,1572,null,8800,7000]
["Vechtstromen: Ootmarsum",14679,20926,5886,"Nee","Nee","Ja",3528,4.5708694436678785,0,0,0,0,1,null,1503,null,8500,6853]
["Vechtstromen: Rijssen",44023,61200,12360,"Nee","Nee","Ja",9692,3.4939139185544921,0,0,0,0,1,null,1490,null,8435,6565]
["Vechtstromen: Schoonoord",null,null,null,null,null,null,744,0,0,"",0,0,0,null,1469,null,8433,6495]
["Vechtstromen: Sleen",31174,33400,15481,"Nee","Nee","Nee",4648,9.1251503076886795,0,1,0,0,0,null,1452,null,8130,6180]
["Vechtstromen: Tubbergen",18009,28800,12473,"Nee","Nee","Nee",3242,10.540593072093161,0,0,0,0,0,null,1405,null,8051,6024]
["Vechtstromen: Vriezenveen",22157,24000,12991,"Nee","Nee","Nee",3513,10.131449138035244,0,1,0,0,0,null,1402,null,8000,6000]
["Vechtstromen: Vroomshoop",23311,22600,8353,"Nee","Nee","Nee",5045,4.5361608536866829,1,1,0,0,0,null,1340,null,8000,5939]
["Waterschapsbedrijf Limburg: Bosscherveld",87571,120496,18137,"Nee","Ja","Nee",14704,3.3793805059102362,0,0,0,1,0,null,1290,null,8000,5575]
["Waterschapsbedrijf Limburg: Gennep",48396,69904,31619,"Nee","Ja","Nee",10056,8.614498534235679,0,0,0,1,0,null,1290,null,7838,5484]
["Waterschapsbedrijf Limburg: Heerlen",null,null,null,null,null,null,5867,0,0,"",0,0,0,null,1285,null,7660,5348]
["Waterschapsbedrijf Limburg: Heugem",37605,74709,26760,"Nee","Ja","Nee",14763,4.9661361845932861,0,0,0,1,0,null,1235,null,7660,5048]
["Waterschapsbedrijf Limburg: Hoensbroek",213365,289136,114177,"Nee","Ja","Nee",71586,4.3697608279571005,0,0,0,1,0,null,1231,null,7200,4414]
["Waterschapsbedrijf Limburg: Kaffeberg",58229,90395,11517,"Nee","Ja","Nee",14875,2.1212386324392773,0,0,0,1,0,null,1172,null,7000,4408]
["Waterschapsbedrijf Limburg: Limmel",129619,147787,93015,"Nee","Nee","Nee",30307,8.4084738323937085,0,0,0,0,0,null,1123,null,6600,4115]
["Waterschapsbedrijf Limburg: Meijel",9774,14416,3718,"Nee","Ja","Nee",1402,{"$f":"+D324/(H324*365)*1000","v":7.2655501924843175},{"$f":"+IFERROR(IF(B324>C324,1,0),\"\")","v":0},{"$f":"+IFERROR(IF(B324/C324>0.9,1,0),\"\")","v":0},{"$f":"+IF(E324=\"Ja\",1,0)","v":0},1,0,null,1040,null,5520,3804]
["Waterschapsbedrijf Limburg: Panheel",46617,30192,67613,"Nee","Nee","Nee",7792,23.773241259036315,1,1,0,0,0,null,957,null,5070,3386]
["Waterschapsbedrijf Limburg: Rimburg",47231,90395,12633,"Nee","Ja","Nee",9532,3.6310280008507752,0,0,0,1,0,null,954,null,4819,3368]
["Waterschapsbedrijf Limburg: Roermond",210149,206811,178636,"Nee","Nee","Nee",39913,12.262012342598577,1,1,0,0,0,null,784,null,3800,3174]
["Waterschapsbedrijf Limburg: Simpelveld",10675,11880,7929,"Nee","Nee","Nee",3666,5.9256103849516846,0,0,0,0,0,null,770,null,3700,2863]
["Waterschapsbedrijf Limburg: Stein",32305,36176,64149,"Nee","Nee","Nee",8352,21.042945992757048,0,0,0,0,0,null,765,null,3673,2660]
["Waterschapsbedrijf Limburg: Susteren",268532,292400,122122,"Nee","Nee","Ja",54503,6.1387597364880504,0,1,0,0,1,null,744,null,3083,2463]
["Waterschapsbedrijf Limburg: Venlo",325184,307813,240032,"Nee","Ja","Nee",68349,9.6215294709245072,1,1,0,1,0,null,710,null,2880,2285]
["Waterschapsbedrijf Limburg: Venray",65800,71200,24916,"Ja","Nee","Nee",15336,4.4511615609435404,0,1,1,0,0,null,695]
["Waterschapsbedrijf Limburg: Weert",132199,120496,118507,"Nee","Nee","Nee",21211,15.306996951052149,1,1,0,0,0,null,694]
["Waterschapsbedrijf Limburg: Wijlre",50783,57845,36559,"Nee","Nee","Nee",16120,6.213501478636255,0,0,0,0,0,null,635]
["Zuiderzeeland: Almere",284748,337000,68011,"Ja","Ja","Nee",32503,5.7327479570905782,0,0,1,1,0,null,580]
["Zuiderzeeland: Dronten",60515,65000,25147,"Ja","Nee","Nee",8276,8.3247813449684518,0,1,1,0,0,null,515]
["Zuiderzeeland: Lelystad",119816,160500,24875,"Nee","Ja","Nee",12944,5.2650405540410112,0,0,0,1,0,null,477]
["Zuiderzeeland: Tollebeek",146193,131500,50748,"Ja","Ja","Nee",19739,7.043701121554089,1,1,1,1,0,null,0]
["Zuiderzeeland: Zeewolde",46112,60000,9274,"Nee","Nee","Nee",4559,5.5732000829309483,0,0,0,0,0]
[]
["Speciale waarden","- Niet van toepassing"]
["Bron","Unie van Waterschappen, WAVES, ABF Research"]

{"sheet":"Temperatuurverloop","index":6,"n_rows":52,"n_cols":11,"rows_kept":52,"cut":false,"hidden":true,"merged":[]}
[]
[]
[null,null,"Temperatuurverloop rioolwater"]
[null,null,null,"Default","Eigen reeks"]
[null,null,"januari",{"$f":"'Invoergegevens warmtevraag'!D24","v":9},{"$f":"'Invoergegevens warmtevraag'!D24","v":9}]
[null,null,"februari",10,{"$f":"'Invoergegevens warmtevraag'!D24","v":9}]
[null,null,"maart",11,9]
[null,null,"april",13,11]
[null,null,"mei",16,14]
[null,null,"juni",18,19]
[null,null,"juli",21,20]
[null,null,"augustus",23,22]
[null,null,"september",21,22]
[null,null,"oktober",18,14]
[null,null,"november",15,10]
[null,null,"december",11,9]
[]
[]
[]
[]
[null,null,"Debiet",{"$f":"'Invoergegevens warmtevraag'!D20/'Invoergegevens warmtevraag'!D21","v":199.6875},"m3/uur",null,null,"Invloed factor",null,{"$f":"IF('Invoergegevens waterzuivering'!D9<6,IF('Data invoer'!G45>1,0,1-'Data invoer'!G45),0)","v":0.10624}]
[]
[null,null,"Temperatuur rioolwater (graden Celcius)","Temperatuurverloop na rioolwisselaar (graden Celcius)","Delta T","Gemiddeld vermogensvraag bron (kW)","Warmtevraag per uur gemiddeld (GJ)","Delta T bij aankomst rwzi","Delta T influent","Temperatuur deelstroom bij de rwzi","Temperatuur influent"]
[null,"januari",{"$f":"IF('Data invoer'!$D$57=1,Temperatuurverloop!D5,Temperatuurverloop!E5)","v":9},{"$f":"C24-E24","v":7.7677632394148812},{"$f":"(G24*1000)/($D$21*4.18)","v":1.2322367605851188},{"$f":"'Data invoer'!H17/'Data invoer'!I17","v":428.55846774193549},{"$f":"'Data invoer'!U6","v":1.0285403225806449},{"$f":"E24*$J$21","v":0.13091283344456303},{"$f":"'Invoergegevens warmtevraag'!$D$20/'Invoergegevens waterzuivering'!$D$16*H24","v":1.8296072037766453E-2},{"$f":"C24-H24","v":8.8690871665554365},{"$f":"C24-I24","v":8.9817039279622328}]
[null,"februari",{"$f":"IF('Data invoer'!$D$57=1,Temperatuurverloop!D6,Temperatuurverloop!E6)","v":9},7.6586986031018647,{"$f":"(G25*1000)/($D$21*4.18)","v":1.3413013968981353},{"$f":"'Data invoer'!H18/'Data invoer'!I18","v":466.48995535714283},{"$f":"'Data invoer'!U7","v":1.1195758928571429},{"$f":"E25*$J$21","v":0.1424998604064579},{"$f":"'Invoergegevens warmtevraag'!$D$20/'Invoergegevens waterzuivering'!$D$16*H25","v":1.9915447880610341E-2},{"$f":"C25-H25","v":8.857500139593542},{"$f":"C25-I25","v":8.9800845521193899}]
[null,"maart",{"$f":"IF('Data invoer'!$D$57=1,Temperatuurverloop!D7,Temperatuurverloop!E7)","v":9},7.9958892108632655,1.0041107891367342,{"$f":"'Data invoer'!H19/'Data invoer'!I19","v":349.21875},{"$f":"'Data invoer'!U8","v":0.8381249999999999},0.10667673023788665,{"$f":"'Invoergegevens warmtevraag'!$D$20/'Invoergegevens waterzuivering'!$D$16*H26","v":1.4908890823238173E-2},8.8933232697621136,8.9850911091767625]
[null,"april",{"$f":"IF('Data invoer'!$D$57=1,Temperatuurverloop!D8,Temperatuurverloop!E8)","v":11},10.191005683222141,0.80899431677786016,{"$f":"'Data invoer'!H20/'Data invoer'!I20","v":281.359375},{"$f":"'Data invoer'!U9","v":0.67526249999999999},8.5947556214479859E-2,{"$f":"'Invoergegevens warmtevraag'!$D$20/'Invoergegevens waterzuivering'!$D$16*H27","v":1.2011829845818781E-2},10.91405244378552,10.987988170154182]
[null,"mei",{"$f":"IF('Data invoer'!$D$57=1,Temperatuurverloop!D9,Temperatuurverloop!E9)","v":14},13.500531511339995,0.49946848866000448,{"$f":"'Data invoer'!H21/'Data invoer'!I21","v":173.70967741935485},{"$f":"'Data invoer'!U10","v":0.41690322580645156},5.3063532235238874E-2,{"$f":"'Invoergegevens warmtevraag'!$D$20/'Invoergegevens waterzuivering'!$D$16*H28","v":7.4160354092816681E-3},13.946936467764761,13.992583964590718]
[null,"juni",{"$f":"IF('Data invoer'!$D$57=1,Temperatuurverloop!D10,Temperatuurverloop!E10)","v":19},18.676752701215268,0.32324729878473391,{"$f":"'Data invoer'!H22/'Data invoer'!I22","v":112.421875},{"$f":"'Data invoer'!U11","v":0.26981249999999996},3.434179302289013E-2,{"$f":"'Invoergegevens warmtevraag'!$D$20/'Invoergegevens waterzuivering'!$D$16*H29","v":4.7995288354898726E-3},18.96565820697711,18.995200471164509]
[null,"juli",{"$f":"IF('Data invoer'!$D$57=1,Temperatuurverloop!D11,Temperatuurverloop!E11)","v":20},19.853089830851136,0.14691016914886448,{"$f":"'Data invoer'!H23/'Data invoer'!I23","v":51.09375},{"$f":"'Data invoer'!U12","v":0.122625},1.5607736370375363E-2,{"$f":"'Invoergegevens warmtevraag'!$D$20/'Invoergegevens waterzuivering'!$D$16*H30","v":2.1813008050106859E-3},19.984392263629626,19.99781869919499]
[null,"augustus",{"$f":"IF('Data invoer'!$D$57=1,Temperatuurverloop!D12,Temperatuurverloop!E12)","v":22},21.825438197948301,0.17456180205169899,{"$f":"'Data invoer'!H24/'Data invoer'!I24","v":60.710685483870968},{"$f":"'Data invoer'!U13","v":0.14570564516129031},1.8545445849972503E-2,{"$f":"'Invoergegevens warmtevraag'!$D$20/'Invoergegevens waterzuivering'!$D$16*H31","v":2.5918682249535083E-3},21.981454554150027,21.997408131775046]
[null,"september",{"$f":"IF('Data invoer'!$D$57=1,Temperatuurverloop!D13,Temperatuurverloop!E13)","v":22},21.591032639216479,0.40896736078352097,{"$f":"'Data invoer'!H25/'Data invoer'!I25","v":142.234375},{"$f":"'Data invoer'!U14","v":0.34136250000000001},4.3448692409641269E-2,{"$f":"'Invoergegevens warmtevraag'!$D$20/'Invoergegevens waterzuivering'!$D$16*H32","v":6.0722878373126229E-3},21.95655130759036,21.993927712162687]
[null,"oktober",{"$f":"IF('Data invoer'!$D$57=1,Temperatuurverloop!D14,Temperatuurverloop!E14)","v":14},13.327708805697279,0.67229119430272022,{"$f":"'Data invoer'!H26/'Data invoer'!I26","v":233.81552419354838},{"$f":"'Data invoer'!U15","v":0.56115725806451611},7.1424216482721001E-2,{"$f":"'Invoergegevens warmtevraag'!$D$20/'Invoergegevens waterzuivering'!$D$16*H33","v":9.9820817839243077E-3},13.92857578351728,13.990017918216076]
[null,"november",{"$f":"IF('Data invoer'!$D$57=1,Temperatuurverloop!D15,Temperatuurverloop!E15)","v":10},8.9981355437248691,1.0018644562751309,{"$f":"'Data invoer'!H27/'Data invoer'!I27","v":348.4375},{"$f":"'Data invoer'!U16","v":0.83625000000000005},0.10643807983466991,{"$f":"'Invoergegevens warmtevraag'!$D$20/'Invoergegevens waterzuivering'!$D$16*H34","v":1.4875537599919967E-2},9.8935619201653306,9.9851244624000799]
[null,"december",{"$f":"IF('Data invoer'!$D$57=1,Temperatuurverloop!D16,Temperatuurverloop!E16)","v":9},7.8092406887691332,1.1907593112308672,{"$f":"'Data invoer'!H28/'Data invoer'!I28","v":414.13306451612897},{"$f":"'Data invoer'!U17","v":0.99391935483870963},0.12650626922516733,{"$f":"'Invoergegevens warmtevraag'!$D$20/'Invoergegevens waterzuivering'!$D$16*H35","v":1.7680220907852224E-2},8.8734937307748325,8.9823197790921476]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[null,null,null,"Stijging Ntot (mg/l) bij 1 C",null,"Wekelijke daling bij temperatuurreeks"]
[null,"Omloopcircuit","<85%",0.10010532371412229,null,{"$f":"D46*$I$24","v":1.8315342140375118E-3}]
[null,null,"85%-100%",0.9433785378924826,null,{"$f":"D47*$I$24","v":1.7260121688163651E-2}]
[null,null,">100%",1.0731142540115437,null,1.963377569614921E-2]
[]
[null,"Gecompartimenteerd","<85%",0.1,null,{"$f":"D50*$I$24","v":1.8296072037766453E-3}]
[null,null,"85%-100%",1.0091549033201845,null,{"$f":"D51*$I$24","v":1.8463570808411336E-2}]
[null,null,">100%",1.8191239854313341,null,3.3282823483080502E-2]