{"text_format":"1","workbook":"xlsx","n_sheets":3,"sheets":["Disclaimer & uitleg model","CO2-berekening ","Parameters & aannames"],"not_rendered":{"charts":1,"images":9,"macros":1,"external_links":0,"defined_names":40,"comments":0,"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":"Disclaimer & uitleg model","index":0,"n_rows":21,"n_cols":12,"rows_kept":21,"cut":false,"hidden":false,"merged":[]}
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[null,null,null,null,null,null,null,null,null,null,null,"voorbeeld:"]

{"sheet":"CO2-berekening ","index":1,"n_rows":79,"n_cols":44,"rows_kept":79,"cut":false,"hidden":false,"merged":[]}
[]
[null,"Berekening CO2-emissie geothermie in warmtenetwerk "]
[]
[]
[null,null,null,"Warmtenet",null,null,null,"Warmteverlies",null,null,null,null,null,"Geothermiebron (basislast)",null,null,{"$f":"aandeel_geowater+aandeel_formatiegas+aandeel_WP","v":0.82016},"totaal",null,null,null,null,null,null,null,null,"Evt. andere bronnen (basis/schouder last)",null,null,null,null,null,null,"Bijstook / pieklast"]
[]
[null,null,"Totale warmtevraag (%)",{"$f":"SUM(aandeel_geowater,aandeel_formatiegas,aandeel_bron1,aandeel_bron2,aandeel_bron3,aandeel_WP,aandeel_piek1,aandeel_piek2)","v":1.0001599999999999},null,null,null,0.2,null,null,null,null,null,"Geowater (bronpompen)",null,null,"Bijvangst (formatiegas)",null,null,null,"Geowater (warmtepomp)",null,null,null,"Bron 1",null,"Bron 2",null,"Bron 3",null,null,null,"Bijstook 1",null,"Bijstook 2"]
[null,null,"Benodigde warmtelevering",{"$f":"D15*1000","v":375000},"GJth",null,null,null,null,null,null,null,"Aandeel in warmtevraag (%)",{"$f":"GT_prod_water/D8","v":0.66880000000000006},null,null,{"$f":"IF(bijvangst=\"vul waarde in\",\"vul waarde in\",GT_prod_gas/D8)","v":8.448E-2},null,null,null,{"$f":"U13/D8","v":6.6879999999999995E-2},null,null,null,0,null,0,null,0,null,null,null,0.18,null,0]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Formatie"]
[]
[null,null,null,"Berekening warmtevraag en -levering:",null,null,null,null,null,null,null,null,"Bijvangst (ja/nee)","ja",null,null,"Jura/Krijt ouderdom",null,null,"Uitkoeling",5,"°C ",null,null,"Biomassa, uit NL 2020",null,"AVI  ",null,"- bron - ",null,null,null,"Aardgasketel (NL)",null,"- bron - "]
[null,null,"Woningequivalenten",10000,"weq",null,null,null,null,null,null,null,"Elektricteitsverbruik (1 of 2 invullen):",null,null,null,"Gemiddelde bijvangst:",null,null,"Vermogen",{"$f":"debiet*(U11)*Cpwater*Rhowater*10^-6/3600","v":1.1611111111111112},"MWth"]
[null,null,"Energieverbruik/weq",30,"GJ/weq","warmtemonitor",null,null,null,null,null,null,"1) Totaal geconsumeerde elektriciteit",0,"GJe/jaar",null,{"$f":"IF(N11=\"ja\",IF(Q11='Parameters & aannames'!C26,'Parameters & aannames'!E26,IF(Q11='Parameters & aannames'!C27,'Parameters & aannames'!E27,IF(Q11='Parameters & aannames'!C28,'Parameters & aannames'!E28))),IF(N11=\"nee\",0))","v":1},"Nm3/m3",null,"Warmte",{"$f":"debiet*(U11)*Cpwater*Rhowater*10^-6/3600*draaiuren*3.6","v":25080},"GJth_prod"]
[null,null,"Warmtevraag",{"$f":"D12*D13/1000","v":300},"TJ","excl. warmteverliezen",null,null,null,null,null,null,"2) COP bronpomp",20,null,null,"Emissiefactor bijvangst:",null,null,"COP",5]
[null,null,"Benodigde warmtelevering",{"$f":"D14/(1-aandeel_verlies)","v":375},"TJ","incl. warmteverliezen",null,null,null,null,null,null,"Productietemperatuur",80,"°C",null,{"$f":"IF(Q11='Parameters & aannames'!C26,'Parameters & aannames'!F26,IF(Q11='Parameters & aannames'!C27,'Parameters & aannames'!F27,IF(Q11='Parameters & aannames'!C28,'Parameters & aannames'!F28)))","v":64},"kgCO2/GJp"]
[null,null,null,null,null,null,null,null,null,null,null,null,"Retourtemperatuur (zonder WP)",30,"°C",null,"Warmte uit bijvangst"]
[null,null,null,null,null,null,null,null,null,null,null,null,"Vollasturen",6000,"uur/jaar",null,{"$f":"IF(Q11='Parameters & aannames'!C26,'Parameters & aannames'!G26,IF(Q11='Parameters & aannames'!C27,'Parameters & aannames'!G27,IF(Q11='Parameters & aannames'!C28,'Parameters & aannames'!G28)))","v":3.3000000000000002E-2},"GJ/m3"]
[null,null,null,null,null,null,null,null,null,null,null,null,"Max. debiet",200,"m3/h",null,"Energie in en uit ketel:"]
[null,null,{"$f":"IF(D7>1.005,\"Let op! Aandeel in warmtevraag > 100% (cel D7)\",IF(D7<0.995,\"Let op! Aandeel in warmtevraag < 100% (cel D7)\",\"\"))","v":""},null,null,null,null,null,null,null,null,null,"Vermogen",{"$f":"debiet*(N15-N16)*Cpwater*Rhowater*10^-6/3600","v":11.611111111111111},"MWth",null,{"$f":"IF(bijvangst=\"vul waarde in\",\"vul waarde in\",((debiet*bijvangst)*$Q$17)*draaiuren)","v":39600},"GJp"]
[null,null,{"$f":"IF(AND(GT_elec=\"\",COP_GT=\"\"),\"Vul elec verbruik of COP in (cel N13 of N14)\",IF(AND(GT_elec>=0.1,COP_GT>=0.1),\"Vul óf elek verbruik in óf COP in (cel N13 of N14)\",IF(COP_GT=\"0\",\"Verwijder 0 in cel N14\",IF(GT_elec=\"0\",\"Verwijder 0 in cel N13\",\"\"))))","v":""},null,null,null,null,null,null,null,null,null,"Jaarlijkse energieproductie",{"$f":"N19*draaiuren*3.6","v":250800.00000000003},"GJth_prod",null,{"$f":"IF(bijvangst=\"vul waarde in\",\"vul waarde in\",((debiet*bijvangst)*$Q$17)*draaiuren*rendement_gasketel)","v":31680},"GJth_prod"]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[null,null,null,"Totaal geleverd (incl. verliezen)",null,null,null,"Warmteverlies",null,"Totaal aanvoer",null,null,"Bron (2020):","Geowater (bronpompen)",null,null,"Bijvangst",null,null,"Geowater (WP)",null,null,null,null,"Bron 1",null,"Bron 2",null,"Bron 3",null,null,null,"Bijstook 1",null,"Bijstook 2"]
[null,null,"Geleverd bij eindgebruiker",{"$f":"J37*(1-aandeel_verlies)","v":300.048},"TJgeleverd",null,null,null,null,{"$f":"SUM(N37,Q37,Y37,AA37,AC37,T37,AG37,AI37)","v":375.06},"TJprod",null,"Aanvoer warmte in net:",{"$f":"GT_prod_water/1000","v":250.80000000000004},"TJprod",null,{"$f":"GT_prod_gas/1000","v":31.68},"TJprod",null,{"$f":"U13/1000","v":25.08},"TJprod",null,null,null,{"$f":"aandeel_bron1*$D$8/1000","v":0},"TJprod",{"$f":"aandeel_bron2*$D$8/1000","v":0},"TJprod",{"$f":"aandeel_bron3*$D$8/1000","v":0},"TJprod",null,null,{"$f":"aandeel_piek1*$D$8/1000","v":67.5},"TJprod",{"$f":"aandeel_piek2*$D$8/1000","v":0},"TJprod"]
[null,null,null,{"$f":"J38","v":8286.4625000000015},"ton",null,null,null,null,{"$f":"SUM(N38,Q38,Y38,AA38,AC38,T38,AG38,AI38)","v":8286.4625000000015},"ton",null,"CO2-emissie:",{"$f":"IF(AND(GT_elec=\"\",COP_GT=\"\"),\"vul elec verbruik of COP in\",IF(AND(COP_GT>0.1,GT_elec<0.1),((GT_prod_water/COP_GT)*emissiefactor_elektriciteit_2020),IF(AND(GT_elec>0.1,COP_GT<0.1),GT_elec*emissiefactor_elektriciteit_2020)))/1000","v":1045.0000000000002},"ton",null,{"$f":"$Q$19*$Q$15/1000","v":2534.4},"ton",null,{"$f":"(1/COP_WP)*U13*emissiefactor_elektriciteit_2020/1000","v":418},"ton",null,null,null,{"$f":"VLOOKUP($Y$11,'Parameters & aannames'!$C$32:$I$47,MATCH(AO53,'Parameters & aannames'!$C$32:$I$32,0),FALSE)*Y37","v":0},"ton",{"$f":"VLOOKUP($AA$11,'Parameters & aannames'!$C$32:$I$47,MATCH(AO53,'Parameters & aannames'!$C$32:$I$32,0),FALSE)*AA37","v":0},"ton",{"$f":"VLOOKUP($AC$11,'Parameters & aannames'!$C$32:$I$47,MATCH(AO53,'Parameters & aannames'!$C$32:$I$32,0),FALSE)*AC37","v":0},"ton",null,null,{"$f":"VLOOKUP($AG$11,'Parameters & aannames'!$C$32:$I$47,MATCH(AO53,'Parameters & aannames'!$C$32:$I$32,0),FALSE)*AG37","v":4289.0625},"ton",{"$f":"VLOOKUP($AG$11,'Parameters & aannames'!$C$32:$I$47,MATCH(AO53,'Parameters & aannames'!$C$32:$I$32,0),FALSE)*AI37","v":0},"ton"]
[null,null,null,{"$f":"J39/(1-aandeel_verlies)","v":27.621541666666669},"kg/GJ",null,null,null,null,{"$f":"SUM(N39,Q39,Y39,AA39,AC39,T39,AG39,AI39)","v":22.097233333333335},"kg/GJ",null,"CO2-factor:",{"$f":"IF(N37=0,0,N38/N37)*aandeel_geowater","v":2.7866666666666671},"kg/GJ",null,{"$f":"IF(Q37=0,0,Q38/Q37)*aandeel_formatiegas","v":6.7584},"kg/GJ",null,{"$f":"IF(T37=0,0,T38/T37)*aandeel_WP","v":1.1146666666666667},"kg/GJ",null,null,null,{"$f":"IF(Y37=0,0,Y38/Y37)*aandeel_bron1","v":0},"kg/GJ",{"$f":"IF(AA37=0,0,AA38/AA37)*aandeel_bron2","v":0},"kg/GJ",{"$f":"IF(AC37=0,0,AC38/AC37)*aandeel_bron3","v":0},"kg/GJ",null,null,{"$f":"IF(AG37=0,0,AG38/AG37)*aandeel_piek1","v":11.4375},"kg/GJ",{"$f":"IF(AI37=0,0,AI38/AI37)*aandeel_piek2","v":0},"kg/GJ"]
[null,null,null,{"$f":"D39/$D$39","v":1},null,null,null,{"$f":"D40-J40","v":0.19999999999999996},null,{"$f":"J39/$D$39","v":0.8},null,null,"% CO2 emissie in warmtenet:",{"$f":"N39/$D$39","v":0.10088744141423436},null,null,{"$f":"Q39/$D$39","v":0.24467859475620626},null,null,{"$f":"T39/$D$39","v":4.0354976565693743E-2},null,null,null,null,{"$f":"Y39/$D$39","v":0},null,{"$f":"AA39/$D$39","v":0},null,{"$f":"AC39/$D$39","v":0},null,null,null,{"$f":"AG39/$D$39","v":0.41407898726386555},null,{"$f":"AI39/$D$39","v":0}]
[]
[]
[]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Emissie geothermie bron",null,null,null,null,null,null,2020,2025,2030,"20XX"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Emissie pompen",null,null,null,null,null,"kg",{"$f":"IF(AND(GT_elec=\"\",COP_GT=\"\"),\"vul elec verbruik of COP in\",IF(AND(COP_GT>0.1,GT_elec<0.1),((GT_prod_water/COP_GT)*emissiefactor_elektriciteit_2020),IF(AND(GT_elec>0.1,COP_GT<0.1),GT_elec*emissiefactor_elektriciteit_2020)))","v":1045000.0000000001},{"$f":"IF(AND(GT_elec=\"\",COP_GT=\"\"),\"vul elec verbruik of COP in\",IF(AND(COP_GT>0.1,GT_elec<0.1),((GT_prod_water/COP_GT)*emissiefactor_elektriciteit_2025),IF(AND(GT_elec>0.1,COP_GT<0.1),GT_elec*emissiefactor_elektriciteit_2025)))","v":731500.00000000012},{"$f":"IF(AND(GT_elec=\"\",COP_GT=\"\"),\"vul elec verbruik of COP in\",IF(AND(COP_GT>0.1,GT_elec<0.1),((GT_prod_water/COP_GT)*emissiefactor_elektriciteit_2030),IF(AND(GT_elec>0.1,COP_GT<0.1),GT_elec*emissiefactor_elektriciteit_2030)))","v":313500.00000000006},{"$f":"IF(AND(GT_elec=\"\",COP_GT=\"\"),\"vul elec verbruik of COP in\",IF(AND(COP_GT>0.1,GT_elec<0.1),((GT_prod_water/COP_GT)*emissiefactor_elektriciteit_20XX),IF(AND(GT_elec>0.1,COP_GT<0.1),GT_elec*emissiefactor_elektriciteit_20XX)))","v":0}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Emissie bijvangst",null,null,null,null,null,"kg",{"$f":"$Q$19*$Q$15","v":2534400},{"$f":"$Q$19*$Q$15","v":2534400},{"$f":"$Q$19*$Q$15","v":2534400},{"$f":"$Q$19*$Q$15","v":2534400}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Emissie warmtepomp",null,null,null,null,null,"kg",{"$f":"(1/COP_WP)*GT_prod_wp*emissiefactor_elektriciteit_2020","v":418000},{"$f":"(1/COP_WP)*GT_prod_wp*emissiefactor_elektriciteit_2025","v":292600},{"$f":"(1/COP_WP)*GT_prod_wp*emissiefactor_elektriciteit_2030","v":125400},{"$f":"(1/COP_WP)*GT_prod_wp*emissiefactor_elektriciteit_20XX","v":0}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"CO2 factor pompen",null,null,null,null,null,"kg/GJ",{"$f":"AO45/(GT_prod_water+GT_prod_gas+GT_prod_wp)","v":3.3977110157367671},{"$f":"AP45/(GT_prod_water+GT_prod_gas+GT_prod_wp)","v":2.378397711015737},1.0193133047210303,0]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"CO2 factor bijvangst",null,null,null,null,null,"kg/GJ",8.2403433476394845,8.2403433476394845,8.2403433476394845,8.2403433476394845]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"CO2 factor warmtepomp",null,null,null,null,null,"kg/GJ",1.3590844062947067,0.95135908440629469,0.40772532188841204,0]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"CO2 emissie totaal bron",null,null,null,null,null,"kg/GJ",{"$f":"AO48+AO49+AO50","v":12.997138769670959},{"$f":"AP48+AP49+AP50","v":11.570100143061516},{"$f":"AQ48+AQ49+AQ50","v":9.6673819742489275},{"$f":"AR48+AR49+AR50","v":8.2403433476394845}]
[]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Emissie warmtenet",null,null,null,null,null,null,2020,2025,2030,"20XX"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Emissie geothermiebron",null,null,null,null,null,"kg/GJ",{"$f":"AO55+AO56+AO57","v":10.659733333333334},{"$f":"AP55+AP56","v":8.7090666666666667},{"$f":"AQ55+AQ56","v":7.5944000000000003},{"$f":"AR55+AR56","v":6.7584}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Emissie geothermiebron - pompen",null,null,null,null,null,"kg/GJ",{"$f":"AO45/GT_prod_water*aandeel_geowater","v":2.7866666666666671},{"$f":"AP45/GT_prod_water*aandeel_geowater","v":1.950666666666667},{"$f":"AQ45/GT_prod_water*aandeel_geowater","v":0.83600000000000008},{"$f":"AR45/GT_prod_water*aandeel_geowater","v":0}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Emissie geothermiebron - bijvangst",null,null,null,null,null,"kg/GJ",{"$f":"AO46/GT_prod_gas*aandeel_formatiegas","v":6.7584},{"$f":"AP46/GT_prod_gas*aandeel_formatiegas","v":6.7584},{"$f":"AQ46/GT_prod_gas*aandeel_formatiegas","v":6.7584},{"$f":"AR46/GT_prod_gas*aandeel_formatiegas","v":6.7584}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Emissie warmtepomp",null,null,null,null,null,"kg/GJ",{"$f":"IF($U$11=0,0,AO47/GT_prod_wp*aandeel_WP)","v":1.1146666666666667},{"$f":"IF($U$11=0,0,AP47/GT_prod_wp*aandeel_WP)","v":0.78026666666666655},{"$f":"IF($U$11=0,0,AQ47/GT_prod_wp*aandeel_WP)","v":0.33439999999999998},{"$f":"IF($U$11=0,0,AR47/GT_prod_wp*aandeel_WP)","v":0}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"\"Emissie \"&Y11","v":"Emissie Biomassa, uit NL 2020"},null,null,null,null,null,"kg/GJ",{"$f":"VLOOKUP($Y$11,'Parameters & aannames'!$C$32:$I$47,MATCH(AO53,'Parameters & aannames'!$C$32:$I$32,0),FALSE)*aandeel_bron1","v":0},{"$f":"VLOOKUP($Y$11,'Parameters & aannames'!$C$32:$I$47,MATCH(AP53,'Parameters & aannames'!$C$32:$I$32,0),FALSE)*aandeel_bron1","v":0},{"$f":"VLOOKUP($Y$11,'Parameters & aannames'!$C$32:$I$47,MATCH(AQ53,'Parameters & aannames'!$C$32:$I$32,0),FALSE)*aandeel_bron1","v":0},{"$f":"VLOOKUP($Y$11,'Parameters & aannames'!$C$32:$I$47,MATCH(AR53,'Parameters & aannames'!$C$32:$I$32,0),FALSE)*aandeel_bron1","v":0}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"\"Emissie \"&AA11","v":"Emissie AVI  "},null,null,null,null,null,"kg/GJ",{"$f":"VLOOKUP($AA$11,'Parameters & aannames'!$C$32:$I$47,MATCH(AO53,'Parameters & aannames'!$C$32:$I$32,0),FALSE)*aandeel_bron2","v":0},{"$f":"VLOOKUP($AA$11,'Parameters & aannames'!$C$32:$I$47,MATCH(AP53,'Parameters & aannames'!$C$32:$I$32,0),FALSE)*aandeel_bron2","v":0},{"$f":"VLOOKUP($AA$11,'Parameters & aannames'!$C$32:$I$47,MATCH(AQ53,'Parameters & aannames'!$C$32:$I$32,0),FALSE)*aandeel_bron2","v":0},{"$f":"VLOOKUP($AA$11,'Parameters & aannames'!$C$32:$I$47,MATCH(AR53,'Parameters & aannames'!$C$32:$I$32,0),FALSE)*aandeel_bron2","v":0}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"\"Emissie \"&AC11","v":"Emissie - bron - "},null,null,null,null,null,"kg/GJ",{"$f":"VLOOKUP($AC$11,'Parameters & aannames'!$C$32:$I$47,MATCH(AO53,'Parameters & aannames'!$C$32:$I$32,0),FALSE)*aandeel_bron3","v":0},{"$f":"VLOOKUP($AC$11,'Parameters & aannames'!$C$32:$I$47,MATCH(AP53,'Parameters & aannames'!$C$32:$I$32,0),FALSE)*aandeel_bron3","v":0},{"$f":"VLOOKUP($AC$11,'Parameters & aannames'!$C$32:$I$47,MATCH(AQ53,'Parameters & aannames'!$C$32:$I$32,0),FALSE)*aandeel_bron3","v":0},{"$f":"VLOOKUP($AC$11,'Parameters & aannames'!$C$32:$I$47,MATCH(AR53,'Parameters & aannames'!$C$32:$I$32,0),FALSE)*aandeel_bron3","v":0}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"\"Emissie bijstook \"&AG11","v":"Emissie bijstook Aardgasketel (NL)"},null,null,null,null,null,"kg/GJ",{"$f":"VLOOKUP($AG$11,'Parameters & aannames'!$C$32:$I$47,MATCH(AO53,'Parameters & aannames'!$C$32:$I$32,0),FALSE)*aandeel_piek1","v":11.4375},{"$f":"VLOOKUP($AG$11,'Parameters & aannames'!$C$32:$I$47,MATCH(AP53,'Parameters & aannames'!$C$32:$I$32,0),FALSE)*aandeel_piek1","v":11.4375},{"$f":"VLOOKUP($AG$11,'Parameters & aannames'!$C$32:$I$47,MATCH(AQ53,'Parameters & aannames'!$C$32:$I$32,0),FALSE)*aandeel_piek1","v":11.4375},{"$f":"VLOOKUP($AG$11,'Parameters & aannames'!$C$32:$I$47,MATCH(AR53,'Parameters & aannames'!$C$32:$I$32,0),FALSE)*aandeel_piek1","v":11.4375}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"\"Emissie bijstook \"&AI11","v":"Emissie bijstook - bron - "},null,null,null,null,null,"kg/GJ",{"$f":"VLOOKUP($AI$11,'Parameters & aannames'!$C$32:$I$47,MATCH(AO53,'Parameters & aannames'!$C$32:$I$32,0),FALSE)*aandeel_piek2","v":0},{"$f":"VLOOKUP($AI$11,'Parameters & aannames'!$C$32:$I$47,MATCH(AP53,'Parameters & aannames'!$C$32:$I$32,0),FALSE)*aandeel_piek2","v":0},{"$f":"VLOOKUP($AI$11,'Parameters & aannames'!$C$32:$I$47,MATCH(AQ53,'Parameters & aannames'!$C$32:$I$32,0),FALSE)*aandeel_piek2","v":0},{"$f":"VLOOKUP($AI$11,'Parameters & aannames'!$C$32:$I$47,MATCH(AR53,'Parameters & aannames'!$C$32:$I$32,0),FALSE)*aandeel_piek2","v":0}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Emissie netverlies",null,null,null,null,null,"kg/GJ",{"$f":"aandeel_verlies*AO64","v":5.5243083333333338},{"$f":"aandeel_verlies*AP64","v":5.2317083333333336},{"$f":"aandeel_verlies*AQ64","v":4.8415749999999997},{"$f":"aandeel_verlies*AR64","v":4.5489750000000004}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Totaal",null,null,null,null,null,"kg/GJ",{"$f":"(AO55+AO56+AO58+AO59+AO60+AO57+AO61+AO62)/(1-aandeel_verlies)","v":27.621541666666669},{"$f":"(AP55+AP56+AP58+AP59+AP60+AP57+AP61+AP62)/(1-aandeel_verlies)","v":26.158541666666668},{"$f":"(AQ55+AQ56+AQ58+AQ59+AQ60+AQ57+AQ61+AQ62)/(1-aandeel_verlies)","v":24.207874999999998},{"$f":"(AR55+AR56+AR58+AR59+AR60+AR57+AR61+AR62)/(1-aandeel_verlies)","v":22.744875}]
[]
[]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Doelstelling Klimaatakkoord 2030",null,null,null,null,null,null,null,{"$f":"'Parameters & aannames'!G50","v":18.899999999999999},{"$f":"'Parameters & aannames'!H50","v":18.899999999999999},{"$f":"'Parameters & aannames'!I50","v":18.899999999999999}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Doelstellingen Warmtewet",null,null,null,null,null,null,{"$f":"'Parameters & aannames'!F49","v":40},{"$f":"'Parameters & aannames'!G49","v":34.5},{"$f":"'Parameters & aannames'!H49","v":25},{"$f":"'Parameters & aannames'!I49","v":0}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Emissie geothermiebron - pompen",null,null,null,null,null,null,{"$f":"AO55/AO$64","v":0.10088744141423436},{"$f":"AP55/AP$64","v":7.4570925685523384E-2},3.4534216654704311E-2,0]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Emissie geothermiebron - bijvangst",null,null,null,null,null,null,0.24467859475620626,0.25836302673600875,0.27918187779803061,0.29713946548398262]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"\"Emissie \"&Y11","v":"Emissie Biomassa, uit NL 2020"},null,null,null,null,null,null,{"$f":"AO58/AO$64","v":0},{"$f":"AP58/AP$64","v":0},0,0]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"\"Emissie \"&AA11","v":"Emissie AVI  "},null,null,null,null,null,null,0,0,0,0]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"\"Emissie \"&AC11","v":"Emissie - bron - "},null,null,null,null,null,null,0,0,0,0]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Emissie WP",null,null,null,null,null,null,{"$f":"AO57/AO$64","v":4.0354976565693743E-2},{"$f":"AP57/AP$64","v":2.9828370274209343E-2},{"$f":"AQ57/AQ$64","v":1.3813686661881723E-2},{"$f":"AR57/AR$64","v":0}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"\"Emissie bijstook \"&AG11","v":"Emissie bijstook Aardgasketel (NL)"},null,null,null,null,null,null,{"$f":"AO61/AO$64","v":0.41407898726386555},{"$f":"AP61/AP$64","v":0.43723767730425844},0.47247021888538343,0.50286053451601731]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"\"Emissie bijstook \"&AI11","v":"Emissie bijstook - bron - "},null,null,null,null,null,null,0,0,0,0]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Emissie netverlies",null,null,null,null,null,null,0.2,0.2,0.2,0.2]
[]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"SUM(AO69:AO77)","v":1},{"$f":"SUM(AP69:AP77)","v":1},{"$f":"SUM(AQ69:AQ77)","v":1},{"$f":"SUM(AR69:AR77)","v":1}]

{"sheet":"Parameters & aannames","index":2,"n_rows":106,"n_cols":13,"rows_kept":106,"cut":false,"hidden":false,"merged":[]}
[]
[null,null,"Parameters & aannames"]
[]
[null,null,"Conversie",null,null,null,null,null,null,null,"Referentie","Opmerkingen"]
[null,null,"Verbrandingswaarde"]
[null,null,"aardgas - onderwaarde",null,31.65,"MJ/m3 =",{"$f":"E6/1000","v":3.1649999999999998E-2},"GJ/m3",null,null,"Zijlema (2020)","Calorische onderwaarde aardgas"]
[null,null,"aardgas - bovenwaarde",null,{"$f":"E6*E10","v":35.131500000000003},"MJ/m3 =",{"$f":"E7/1000","v":3.5131500000000003E-2},"GJ/m3",null,null,"Zijlema (2020)","Calorische bovenwaarde aardgas"]
[]
[]
[null,null,"omrekenfactor bovenwaarde/onderwaarde",null,1.1100000000000001,null,null,null,null,null,"RVO (2019, update 2020)","Bijlage 1"]
[]
[null,null,null,null,1,"kg/kWh =",277.77777777777777,"kg/GJ"]
[null,null,"Cpwater",null,4180,"J/kg K"]
[null,null,"𝜌water",null,1000,"kg/m3"]
[]
[null,null,"Emissiefactoren "]
[]
[null,null,null,null,2015,2020,2025,2030,"20XX"]
[null,null,"Emissiefactor elektriciteit","kg/GJe",{"$f":"0.53/0.0036","v":147.22222222222223},{"$f":"0.3/0.0036","v":83.333333333333329},{"$f":"0.21/0.0036","v":58.333333333333336},{"$f":"0.09/0.0036","v":25},0,null,"PBL, TNO, CBS en RIVM (2021)","Integrale methode, 2015 & 2020 uit KEV 2019, 2025&2030 uit KEV 2021"]
[null,null,"Emissiefactor aardgas (bovenwaarde)","kg/GJp",50.8,null,null,null,null,null,"Zijlema (2020)","Aardgas uit Nederland betekend het gemiddelde van 111 gas velden in NL en het geimporteerde gas uit Belgie. 2021: 56.4 kg/GJ op onderwaarde en 50.8 kg/GJ op bovenwaarde"]
[null,null,"Rendement gasketel (bovenwaarde)","%",0.8,null,null,null,null,null,"NEN (2015)","NEN7125"]
[null,null,"hulpenergie"]
[]
[null,null,"Formatiegas",null,"Gas/water  ratio","Emissiefactor ","Verbrandingswaarde","Gem. COP bronpompen"]
[null,null,null,null,"-","kg/GJp","GJ/m3","-"]
[null,null,"Perm ouderdom",null,0.3,73,2.7E-2,16,null,null,"Dinkelman et al. (2021)","Calorische bovenwaarde (HHV) van formatiegas (methaan + andere koolwaterstoffen)"]
[null,null,"Jura/Krijt ouderdom",null,1,64,3.3000000000000002E-2,24,null,null,"Dinkelman et al. (2021)","Calorische bovenwaarde (HHV) van formatiegas (methaan + andere koolwaterstoffen)"]
[null,null,"Anders (zelf in te vullen)",null,"vul waarde in","vul waarde in","vul waarde in","vul waarde in",null,null,null,"Vul hier zelf een emissiefactor in"]
[]
[null,null,"CO2-emissiefactoren brandstof"]
[]
[null,null,null,null,2015,2020,2025,2030,"20XX",null,"Bron:"]
[null,null,"- bron - "]
[null,null,"Aardgasketel (NL)","kg/GJth",null,{"$f":"M69/0.8","v":63.541666666666664},{"$f":"F34","v":63.541666666666664},{"$f":"F34","v":63.541666666666664},{"$f":"H34","v":63.541666666666664},null,"Dinkelman et al. (2021)"]
[null,null,"Aquathermie + WKO + WP 70°C","kg/GJth",null,29.2,20.399999999999999,8.8000000000000007,0,null,"Dinkelman et al. (2021)"]
[null,null,"AVI  ","kg/GJth",null,9.9,6.9,4.2,2,null,"Dinkelman et al. (2021)"]
[null,null,"Biomassa, geen emissie","kg/GJth",null,0,0,0,0,null,"Dinkelman et al. (2021)"]
[null,null,"Biomassa, uit NL 2020","kg/GJth",null,{"$f":"H103/I103","v":4.4444444444444438},{"$f":"F38","v":4.4444444444444438},{"$f":"G38","v":4.4444444444444438},{"$f":"H38","v":4.4444444444444438},null,"RHDHV (2020)","In kg CO2-eq/GJ, enkel waarden van 2020 beschikbaar"]
[null,null,"Biomassa, uit VS, pulphout 2020","kg/GJth",null,{"$f":"H104/I104","v":15.346534653465346},{"$f":"F39","v":15.346534653465346},15.346534653465346,15.346534653465346,null,"RHDHV (2020)","In kg CO2-eq/GJ, enkel waarden van 2020 beschikbaar"]
[null,null,"Biomassa, uit VS, resthout 2020","kg/GJth",null,{"$f":"H105/I105","v":11.386138613861386},11.386138613861386,11.386138613861386,11.386138613861386,null,"RHDHV (2020)","In kg CO2-eq/GJ, enkel waarden van 2020 beschikbaar"]
[null,null,"Restwarmte zonder e-productie","kg/GJth",null,8.3000000000000007,5.8,2.5,0,null,"Dinkelman et al. (2021)"]
[null,null,"Russisch aardgas 2020","kg/GJth",null,{"$f":"H106/I106","v":71.573033707865164},{"$f":"F42","v":71.573033707865164},{"$f":"G42","v":71.573033707865164},71.573033707865164,null,"RHDHV (2020)","In kg CO2-eq/GJ, enkel waarden van 2020 beschikbaar"]
[null,null,"WKK (gas) zonder e-derving","kg/GJth",null,50.3,68.7,93.2,111.7,null,"Dinkelman et al. (2021)","De rekenmethodiek uit de huidige warmtewet leidt ertoe dat vanwege de beoogde verduurzaming van de Nederlandse elektriciteitsmix in de toekomst een groter deel van de CO2-emissie wordt toegewezen aan warmte. Zo stijgt de relatieve CO2-uitstoot van een WKK zonder derving. "]
[null,null,"WKK (biogeen) zonder e-derving","kg/GJth",null,0,0,0,0,null,"Dinkelman et al. (2021)"]
[null,null,"WKK (gas) met e-derving (aftapwarmte)","kg/GJth",null,13,9,5.5,2.6,null,"Dinkelman et al. (2021)"]
[null,null,"WKO + WP 70°C","kg/GJth",null,29.6,20.7,8.9,0,null,"Dinkelman et al. (2021)"]
[null,null,"Bron - eigen invulling","kg/GJth",null,null,null,null,null,null,null,"Vul hier zelf een emissiefactor in"]
[]
[null,null,"Doelstelling Warmtewet",25,"kg/GJth",40,34.5,25,0,null,"https://www.internetconsultatie.nl/warmtewet2"]
[null,null,"Doelstelling Klimaatakkoord",18.899999999999999,"kg/GJth",null,18.899999999999999,18.899999999999999,18.899999999999999,null,"https://www.klimaatakkoord.nl/documenten/publicaties/2019/06/28/klimaatakkoord"]
[]
[]
[]
[null,null,"Referenties",null,null,null,null,null,null,null,"ja"]
[null,null,"Zijlema (2020). Berekening van de standaard CO2-emissiefactor aardgas t.b.v. nationale monitoring 2021 en emissiehandel 2021 Van: https://www.rvo.nl/sites/default/files/2021/05/Berekening%20van%20de%20standaard%20CO2-emissiefactor%20aardgas%202021_0.pdf ",null,null,null,null,null,null,null,"nee"]
[null,null,"RVO (2019, update 2020). Duurzaamheid van warmte- & koudelevering. Voorstel voor inhoud van de rapportageverplichting onder de Warmtewet. Eindrapport versie 3."]
[null,null,"NEN (2015). NEN 7125. Energieprestatienorm voor maatregelen op gebiedsniveau (EMG) – Bepalingsmethode."]
[null,null,"NEN (2020). NTA 8800 (nl). Energieprestatie van gebouwen – Bepalingsmethode. "]
[null,null,"PBL, TNO, CBS en RIVM (2021), Klimaat- en Energieverkenning 2021. Den Haag: Planbureau voor de Leefomgeving"]
[null,null,"Schoots, K. & P. Hammingh (2019), Klimaat- en Energieverkenning 2019, Den Haag: Planbureau voor de Leefomgeving."]
[null,null,"HaskoningDHV Nederland B.V. (2020). Warmte uit aardgas of biomassa? Referentie: BH1516I&BRP001F01. https://www.nvde.nl/wp-content/uploads/2020/03/BH1576-6-mei_def.pdf"]
[null,null,"ECN (2018). Primaire fossiele energiefactor elektriciteit op bovenwaarde (HHV) voor toepassing in de energieprestatienorm NTA8800"]
[null,null,"Dinkelman et al. (2021). Factsheet duurzaamheid geothermie."]
[]
[]
[null,null,"NTA8800, gebruikte tabellen:"]
[]
[null,null,null,null,null,null,null,null,null,null,null,"kg/kWh","kg/GJ"]
[null,null,null,null,null,null,null,null,null,null,"aardgas",0.183,{"$f":"L69/0.0036","v":50.833333333333336}]
[null,null,null,null,null,null,null,null,null,null,"AVI",0.113,{"$f":"L70/0.0036","v":31.388888888888889}]
[null,null,null,null,null,null,null,null,null,null,"Restwarmte",3.4000000000000002E-2,9.4444444444444446]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[null,null,"HaskoningDHV (2020):"]
[]
[]
[]
[]
[]
[]
[]
[]
[null,null,null,null,null,null,null,"CO2 emissiefactor [kg/GJp]","Rendement/COP [-]"]
[null,null,null,null,null,null,"Biomassa, uit NL",4.8,1.08]
[null,null,null,null,null,null,"Biomassa, uit VS, pulphout",15.5,1.01]
[null,null,null,null,null,null,"Biomassa, uit VS, resthout ",11.5,1.01]
[null,null,null,null,null,null,"Russisch aardgas ",63.7,0.89]