{"text_format":"1","workbook":"xlsx","n_sheets":5,"sheets":["Hoofdmenu","Verantwoordelijkheden","Projectinformatie","Aanvrager_en_machtiging","Ontwerp_uitgangspunten"],"not_rendered":{"charts":0,"images":1,"macros":1,"external_links":0,"defined_names":63,"comments":1,"pivot_tables":0},"unopened":[],"bounds":{"document_bytes":16777216,"sheet_cells":100000,"rows_first":2000,"rows_last":500,"rows_between":2000,"halvings":0,"cell_chars":16384,"cell_head_chars":4096},"cells_cut":0,"cells_raw":0,"read":"whole","date_system":"1900"}

{"sheet":"Hoofdmenu","index":0,"n_rows":32,"n_cols":2,"rows_kept":32,"cut":false,"hidden":false,"merged":[[0,6,1,7],[29,1,29,12],[30,1,30,12],[31,1,31,12],[32,1,32,12]]}
[]
[]
[null,"Bodemenergie ontwerp en vergunningaanvraag"]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[null,"KWA Bedrijfsadviseurs B.V. kan niet aansprakelijk worden gesteld voor fouten in de software of schade als "]
[null,"gevolg van het gebruik van deze software. Er kunnen geen rechten worden ontleend aan de software of documenten. "]
[null,"Het intellectuele eigendom en copyright zijn van KWA Bedrijfsadviseurs B.V. te Amersfoort"]

{"sheet":"Verantwoordelijkheden","index":1,"n_rows":21,"n_cols":6,"rows_kept":21,"cut":false,"hidden":false,"merged":[]}
["Verantwoordelijkheden bij ontwerp"]
[]
[]
["Onderwerp",null,null,"Bovengronds ontwerper","Ondergronds ontwerper","Overdracht van informatie"]
["Bovengronds systeemconcept",null,null,"x",null,"Spreadsheet uitgangspunten"]
["Uitgangspunten bovengronds (vraagspecificatie aan ondergronds systeem)",null,null,"x",null,"Spreadsheet uitgangspunten"]
["Uitgangspunten energiebalans (koudeoverschot, sturingsmogelijkheden)",null,null,"x",null,"Spreadsheet uitgangspunten"]
["Uitgangspunten TSA (temperatuurverlies)",null,null,"x","x?","Spreadsheet uitgangspunten"]
["Afwijkende condities startsituatie",null,null,"x","x?","Spreadsheet uitgangspunten"]
["Haalbaarheid geohydrologisch en wet- en regelgeving",null,null,null,"x","Rapportage (H2 geohydrologische situatie)"]
["Ontwerp bronnensysteem",null,null,null,"x","Rapportage (H3 ontwerp)"]
["Toetsing bronlocaties op inpasbaarheid, bereikbaarheid en eigendomsrechten",null,null,"x?","x?","Rapportage (H3 ontwerp)"]
["Lozingsroute ontwikkel- en spuiwater",null,null,"x?","x?","Rapportage (H3 ontwerp)"]
["Toetsing onttrekkingstemperaturen en energiebalans",null,null,null,"x","Rapportage (H4 effectberekeningen)"]
["SPF ondergronds systeem",null,null,"x?","x?","Spreadsheet uitgangspunten"]
["SPF totaal systeem",null,null,"x",null,"Spreadsheet uitgangspunten"]
["Vergunningaanvraag bodemenergiesysteem",null,null,null,"x","Ingediende aanvraag"]
["Vergunningaanvraag/melding lozing",null,null,null,"x?","Ingediende aanvraag/melding"]
["…"]
["…"]
["…"]

{"sheet":"Projectinformatie","index":2,"n_rows":63,"n_cols":4,"rows_kept":63,"cut":false,"hidden":false,"merged":[]}
[]
[null,"Algemene projectinformatie"]
[null,"Aspect","Beschrijving","Contactpersoon / overig"]
[null,"Project:","<<Projectnaam>>"]
[null,null,"<<adres>>\n"]
[null,null,"<<postcode>>"]
[null,"Plaats","<<plaats>>"]
[null,"Type project","Vergunningsaanvraag"]
[null,"Projectbeschrijving ","Type gebouw"]
[null,"doel bodemenergiesysteem","Doel bodemenergie"]
[null,"Type systeem","type systeem"]
[null,"bijzonderheden"]
[null,"Eigenaar/vergunninghouder","<eigenaar>","<Contactpersoon eigenaar>"]
[null,"Opdrachtgever","<Klant>","<Contactpersoon opdrachtgever>"]
[null,"Straat opdrachtgever","<straat + nummer>\n"]
[null,"Postcode opdrachtgever","<Postcode>"]
[null,"Plaats opdrachtgever","<Plaats opdrachtgever>"]
[null,"Ontwerper bovengronds","<Bedrijf ontwerp bovengronds> ","<Contactpersoon bov. Ontwerp>"]
[null,"Ontwerper ondergronds","KWA Bedrijfsadviseurs B.V.","<Contactpersoon KWA>"]
[null,"Installateur","<Bedrijf installateur>","<Contactpersoon Installateur>"]
[null,"Boorbedrijf","<Boorbedrijf>","<Contactpersoon boorder>"]
[null,"Begindatum aanleg bodemenergiesysteem","<geschatte aanvang, bijv. Q2 - 2025> "]
[null,"Begindatum in bedrijf stellen ","<geschatte aanvang, bijv. Q4 - 2025> "]
[null,"Opdrachtgever KWA","<Opdrachtgever KWA>","<Contactpersoon Opdr. KWA>"]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[null,"Type gebouw","type systeem","Doel bodemenergie"]
[null,"Nieuwbouw","Doublet opslag","Klimaat beheersing"]
[null,"Renovatie","Monobron opslag","Proceskoeling"]
[null,"Utiliteitsbouw","Doublet recirculatie","Tijdelijk opslag rest energie"]
[null,"Hotel","Monobron recirculatie"]
[null,"Kantoorgebouw"]
[null,"Ziekenhuis"]
[null,"Multifunctionele accommodatie"]
[]
[null,"Type project"]
[null,"Haalbaarheidsstudie"]
[null,"Vergunningsaanvraag"]

{"sheet":"Aanvrager_en_machtiging","index":3,"n_rows":53,"n_cols":5,"rows_kept":53,"cut":false,"hidden":false,"merged":[]}
[]
[null,"Machting"]
[]
[null,"Hierbij machtig ik KWA Bedrijfsadviseurs B.V.  voor het indienen van benodigde aanvragen"]
[null,"voor het open bodemenergiesysteem."]
[]
[null,"Projectnaam:"]
[null,"Voorbeeld Project"]
[]
[null,"Gegevens van de aanvrager  (op wiens naam komt de vergunning van het systeem):"]
[]
[1,"Bedrijf"]
[null,"KVK-nummer"]
[null,"Vestigingsnummer",null,null,"indien bekend"]
[null,"Statutaire naam"]
[null,"Handelsnaam",null,null,"optioneel"]
[]
[2,"Contactpersoon"]
[null,"Geslacht","m/v"]
[null,"Voorletters"]
[null,"Voorvoegsels",null,null,"optioneel"]
[null,"Achternaam"]
[null,"Functie",null,null,"optioneel"]
[]
[3,"Vestigingsadres bedrijf"]
[null,"Postcode"]
[null,"Huisnummer"]
[null,"Huisletter",null,null,"optioneel"]
[null,"Huisnummertoevoeging",null,null,"optioneel"]
[null,"Straatnaam "]
[null,"Woonplaats"]
[]
[4,"Correspondentieadres"]
[null,"Postbus",null,null,"of gelijk aan"]
[null,"Postcode",null,null,"vestigingsadres"]
[null,"Plaats"]
[]
[5,"Contactgegevens"]
[null,"Telefoonnummer"]
[null,"Faxnummer",null,null,"optioneel"]
[null,"E-mailadres"]
[]
[6,"Eigendomssituatie van het perceel waar het bodemenergiesysteem wordt gerealiseerd"]
[null,"Eigendomssituatie","eigenaar / erfpachter / huurder / anders"]
[]
[]
[7,"Gegevens boorbebrijf"]
[null,"Naam "]
[null,"Certificeringsnummer Mechanisch boren",null,null,"nr indien bekend"]
[]
[8,"Ondertekening machtiging"]
[null,"Datum"]
[null,"Handtekening"]

{"sheet":"Ontwerp_uitgangspunten","index":4,"n_rows":130,"n_cols":52,"rows_kept":130,"cut":false,"hidden":false,"merged":[[119,41,119,42],[39,5,39,8],[50,41,50,42],[54,40,54,41],[55,32,55,33],[55,40,55,41],[70,19,70,20],[82,19,82,20],[88,5,88,8],[103,5,103,8],[118,41,118,42],[56,32,56,33],[68,19,68,20],[69,19,69,20],[18,50,18,51],[25,32,25,33],[26,19,26,20],[26,32,26,33],[27,19,27,20],[64,44,64,45],[65,44,65,45],[8,19,12,19],[8,20,12,20],[8,41,8,42],[12,40,12,41],[28,19,28,20]]}
[]
[null,null,"UITGANGSPUNTEN ONTWERP BODEMENERGIESYSTEEM",null,null,null,null,null,null,null,{"$f":"Projectinformatie!$C$4","v":"<<Projectnaam>>"}]
[]
[null,null,"Type Bronnensysteem",null,{"$f":"Projectinformatie!$C$9","v":"Type gebouw"}]
[]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Tabel 5.1: uitgangspunten ondergronds deel bodemenergiesysteem"]
[null,null,"WINTERSEIZOEN",null,"GEBOUW AFGIFTE",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"BRON",null,null,null,null,null,null,null,"BRON SEIZOENSGEMIDDELD",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Eenheid","Zomersituatie","Wintersituatie"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"BRON VERGUNNING AANVRAAG",null,null,{"$f":"+AH13","v":200},"m3/h",null,null,null,null,"Maximaal infiltratie-/onttrekkingsdebiet","m3/uur",{"$f":"+AQ50","v":20},{"$f":"+AQ8","v":200}]
[null,null,"VERWARMING GEBOUW TOTAAL",null,"Totaal warmte behoefte",null,null,{"$f":"+H18+H25+H32","v":409.2},"MWh",null,"SPF VERWARMEN",{"$f":"+L10/L11","v":3.5714285714285716},null,null,null,null,null,null,null,"bovengronds","ondergronds",null,"Totaal bron warmte leveren",null,null,{"$f":"+Z25+Z40","v":306.89999999999998},"MWh",null,null,null,"Totaal bron warmte leveren",null,null,{"$f":"+Z9","v":306.89999999999998},"MWh",null,null,null,null,"WINTERSEIZOEN",null,{"$f":"AH15","v":86000},null,"m3/seioen",null,null,null,null,"Gemiddelde infiltratie-/onttrekkingshoeveelheid","m3/seizoen",{"$f":"+AG56","v":29000},{"$f":"+AG14","v":0}]
[null,null,null,null,"Vermogen verwarming",null,null,{"$f":"+H19+H26","v":186},"kW",null,"Warmte duurzaam (MWh)",{"$f":"+H25+H32","v":409.2},null,null,null,null,null,null,null,null,null,null,"Vermogen maximaal",null,null,{"$f":"IF(inzet_extra_koudeladen=gelijktijdig_met_WP,Z26+Z41,MAX(Z26,Z41))","v":139.5},"kW",null,null,null,"Bandbreedte warmte leveren",null,"+/-",30,"%",null,null,null,null,null,null,null,null,null,null,null,null,null,"Maximale infiltratie-/onttrekkingshoeveelheid","m3/seizoen",{"$f":"+AP51","v":37000},{"$f":"+AP9","v":86000}]
[null,null,null,null,null,null,null,null,null,null,"Elektriciteit (Mwhe)",{"$f":"Elek_WP+Elek_WP_gelijktijdig+Elek_balans_koudeladen+AA16","v":114.57599999999999},null,null,null,null,null,null,null,null,null,null,"Equivalente vollast uren",null,null,{"$f":"IF(Z10<>0,Z9/Z10*1000,0)","v":2199.9999999999995},"h",null,null,null,"Bandbreedte warmte",{"$f":"ROUND(AH9*(1-$AH$10/100),0)","v":215},"à",{"$f":"ROUND(AH9*(1+$AH$10/100),0)","v":399},"MWh",null,null,null,null,null,null,null,null,null,null,null,null,null,"Gemiddelde onttrekkingstemperatuur","°C",{"$f":"+AR55","v":10},{"$f":"+AO13","v":13}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Ontwerp temperatuur",{"$f":"+X28","v":13},"ª",{"$f":"+X12-Z10/(Z13*Cw)","v":7},"°C",null,null,null,"Gemiddelde temperatuur",13,"ª",9,"°C",{"$f":"+IF((AF12-AH12)<4,\"let op dT moet minimaal 4°C zijn\", \"\")","v":""},null,null,null,null,null,null,null,null,null,null,null,null,"Gemiddelde infiltratietemperatuur","°C",{"$f":"+AO55","v":14},{"$f":"+AR13","v":9}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Volumestroom maximaal",null,null,{"$f":"IF(inzet_extra_koudeladen=gelijktijdig_met_WP,Z29+Z44,MAX(Z29,Z44))","v":19.976133651551311},"m3/h",null,null,null,"Bron capaciteit",null,null,200,"m3/h",null,null,null,null,"Gemiddelde temperatuur",{"$f":"+AF12","v":13},null,"°C",{"$f":"+AH12","v":9},"°C",null,null,null,"Vermogen bij ontwerp temperaturen","kW",{"$f":"+Z52","v":186},{"$f":"+Z10","v":139.5}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Seizoensdebiet gemiddeld",null,null,{"$f":"ROUND(AH9/(Cw*(AF12-AH12)),0)*1000","v":66000},"m3/seiz.",null,null,null,null,"Minimale temperatuur",null,null,null,5,"°C",null,null,null,"Ontladen koude / warmte","MWh",{"$f":"+AH51","v":134},{"$f":"+AH9","v":306.89999999999998}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"SPF bronnen",null,null,25,null,null,null,"Seizoensdebiet maximaal",null,null,{"$f":"ROUND(AH11/(Cw*(AF12-AH12)),0)*1000","v":86000},"m3/seiz.",null,null,null,null,null,null,null,null,null,null,null,null,null,"Ontladen koude balansvoorziening","   MWh",{"$f":"Q104","v":0},{"$f":"Q40","v":0}]
[null,null,null,null,"OPWEKKING",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Elektriciteit (Mwhe)",null,null,{"$f":"+Z9/AA15","v":12.276},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Koude overschot in de bodem","MWh",{"$f":"+AQ116","v":172.89999999999998},{"$f":"(+AQ117/100)","v":2.2902985074626865}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Koudeoverschot in de bodem","%",{"$f":"IF(AQ117=100,0,AQ117)","v":229.02985074626864}]
[null,null,"VERWARMING PIEKVOORZIENING",null,"Ketel",null,null,0,"MWh",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"SPF BES","-",{"$f":"L51","v":25},{"$f":"L9","v":3.5714285714285716}]
[null,null,null,null,"Vermogen",null,null,0,"kW",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"SPF BES totaal ","-",{"$f":"AO122","v":4.5290821771611531}]
[null,null,null,null,"Equivalente vollast uren",null,null,{"$f":"IF(H19<>0,H18/H19*1000,0)","v":0},"h",null,"valt buiten SPF-BES"]
[null,null,null,null,"Ontwerp temperatuur",30,"ª",40,"°C"]
[null,null,null,null,"Volumestroom",null,null,{"$f":"H19/(Cw*(H21-F21))","v":0},"m3/h"]
[]
[]
[null,null,"VERWARMING WP",null,"Warmtepomp condensor",null,null,409.2,"MWh",null,null,null,null,"Warmtepomp verdamper",null,null,{"$f":"+H25-L29","v":306.89999999999998},"MWh",null,null,null,null,"Bron warmte leveren",null,null,{"$f":"+Q25","v":306.89999999999998},"MWh"]
[null,null,null,null,"Vermogen",null,null,186,"kW",null,null,null,null,"Vermogen",null,null,{"$f":"+H26-H26/L28","v":139.5},"kW",null,null,null,null,"Vermogen",null,null,{"$f":"+Q26","v":139.5},"kW"]
[null,null,null,null,"Equivalente vollast uren",null,null,{"$f":"IF(H26<>0,H25/H26*1000,0)","v":2199.9999999999995},"h",null,"SPF WP seizoensgem.",4,null,"Equivalente vollast uren",null,null,{"$f":"IF(Q26<>0,Q25/Q26*1000,0)","v":2199.9999999999995},"h",null,"TSA",null,null,"Equivalente vollast uren",null,null,{"$f":"IF(Z26<>0,Z25/Z26*1000,0)","v":2199.9999999999995},"h"]
[null,null,null,null,"Ontwerp temperatuur",30,"ª",40,"°C",null,"COP WP bij piek",4,null,"Ontwerp temperatuur",12,"ª",6,"°C",null,1,null,null,"Ontwerp temperatuur",{"$f":"+O28+dT_TSA_verwarming","v":13},"ª",{"$f":"+Q28+dT_TSA_verwarming","v":7},"°C"]
[null,null,null,null,"Volumestroom",null,null,{"$f":"H26/(Cw*(H28-F28))","v":15.980906921241049},"m3/h",null,"Elektriciteit WP (Mwhe)",{"$f":"+H25/L27","v":102.3},null,"Volumestroom",null,null,{"$f":"Q26/(Cw*(-Q28+O28))","v":19.976133651551311},"m3/h",null,"dT (K)",null,null,"Volumestroom",null,null,{"$f":"Z26/(Cw*(-Z28+X28))","v":19.976133651551311},"m3/h"]
[]
[]
[null,null,"GELIJKTIJDIG VERWARMEN EN KOELEN",null,"Warmtepomp condensor",null,null,0,"MWh",null,null,null,null,"Warmtepomp verdamper ª koelen",null,null,{"$f":"+H32-L36","v":0},"MWh"]
[null,null,null,null,"Vermogen",null,null,{"$f":"+H26","v":186},"kW",null,null,null,null,"Vermogen",null,null,{"$f":"+H33-H33/L35","v":139.5},"kW"]
[null,null,null,null,"Equivalente vollast uren",null,null,{"$f":"IF(H33<>0,H32/H33*1000,0)","v":0},"h",null,"SPF WP seizoensgem.",{"$f":"+SPF_WP","v":4},null,"Equivalente vollast uren",null,null,{"$f":"IF(Q33<>0,Q32/Q33*1000,0)","v":0},"h"]
[null,null,null,null,"Ontwerp temperatuur",{"$f":"+F28","v":30},"ª",{"$f":"+H28","v":40},"°C",null,"COP WP bij piek",{"$f":"+COP_WP","v":4},null,"Ontwerp temperatuur",{"$f":"+O28","v":12},"ª",{"$f":"+Q28","v":6},"°C"]
[null,null,null,null,"Volumestroom",null,null,{"$f":"H33/(Cw*(H35-F35))","v":15.980906921241049},"m3/h",null,"Elektriciteit WP (Mwhe)",{"$f":"+H32/L34","v":0},null,"Volumestroom",null,null,{"$f":"Q33/(Cw*(-Q35+O35))","v":19.976133651551311},"m3/h"]
[]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"TSA",2]
[]
[null,null,"BALANSVOORZIENING KOUDE LADEN",null,"Inzet balansvoorziening:","niet gelijktijdig met WP",null,null,null,null,null,null,null,"Balansvoorziening",null,null,0,"MWh",null,null,null,null,"Bron balans koude laden",null,null,{"$f":"+Q40","v":0},"MWh"]
[null,null,"(dry-cooler, oppervlaktewater, LBK, …)",null,"mogelijke keuzes:",null,null,null,null,null,null,null,null,"Vermogen",null,null,0,"kW",null,null,null,null,"Vermogen",null,null,{"$f":"+Q41","v":0},"kW"]
[null,null,null,null,"gelijktijdig met WP","(brondebiet wordt groter)",null,null,null,null,"SPF balansvoorziening",20,null,"Equivalente vollast uren",null,null,{"$f":"IF(Q41<>0,Q40/Q41*1000,0)","v":0},"h",null,null,null,null,"Equivalente vollast uren",null,null,{"$f":"IF(Z41<>0,Z40/Z41*1000,0)","v":0},"h"]
[null,null,null,null,"niet gelijktijdig met WP","(max vermogen maatgevend)",null,null,null,null,"Elektriciteit (Mwhe)",{"$f":"+Q40/L42","v":0},null,"Ontwerp temperatuur",{"$f":"+X43-dT_TSA_verwarming-dT_TSA2_BALANS_KOUDE_LADEN","v":10},"ª",{"$f":"+Z43-dT_TSA_verwarming-S38","v":4},"°C",null,null,null,null,"Ontwerp temperatuur",{"$f":"+X28","v":13},"ª",{"$f":"+Z28","v":7},"°C"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,"Volumestroom",null,null,{"$f":"Q41/(Cw*(-Q43+O43))","v":0},"m3/h",null,null,null,null,"Volumestroom",null,null,{"$f":"Z41/(Cw*(-Z43+X43))","v":0},"m3/h"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"warmtecapaciteit water",null,null,{"$f":"4.19/3.6","v":1.163888888888889},"kWh/(m3K)"]
[]
[]
[]
[null,null,"ZOMERSEIZOEN",null,"GEBOUW AFGIFTE",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"BRON",null,null,null,null,null,null,null,"BRON SEIZOENSGEMIDDELD"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"BRON VERGUNNING AANVRAAG",null,null,{"$f":"+AH55","v":20},"m3/h"]
[null,null,"KOELING GEBOUW TOTAAL",null,"Totaal koude behoefte",null,null,{"$f":"+H60+H67+H81+H96","v":134},"MWh",null,"SPF KOELING",{"$f":"+L52/L53","v":25},null,null,null,null,null,null,null,null,null,null,"Totaal bron koude leveren",null,null,{"$f":"+Z67+Z81+Z104","v":134},"MWh",null,null,null,"Totaal bron koude leveren",null,null,{"$f":"+Z51","v":134},"MWh",null,null,null,null,"ZOMERSEIZOEN",null,{"$f":"+AG57","v":37000},null,"m3/seizoen"]
[null,null,null,null,"Vermogen",null,null,{"$f":"+H61+H68+H82+H97","v":186},"kW",null,"Koude duurzaam (MWh)",{"$f":"+H67+H74+H81+H96","v":134},null,null,null,null,null,null,null,null,null,null,"Vermogen maximaal",null,null,{"$f":"IF(inzet_extra_warmteladen=gelijktijdig_bronkoeling,Z68+Z82+Z105,MAX(Z68+Z82,Z105))","v":186},"kW",null,null,null,"Bandbreedte warmte leveren",null,null,30,"%"]
[null,null,null,null,null,null,null,null,null,null,"Elektriciteit (Mwhe)",{"$f":"Elek_WP_KM+L99+L107+AA58","v":5.36},null,null,null,null,null,null,null,null,null,null,"Equivalente vollast uren",null,null,{"$f":"IF(Z52<>0,Z51/Z52*1000,0)","v":720.43010752688178},"h",null,null,null,"Bandbreedte warmte",{"$f":"ROUND(AH51*(1-$AH$10/100),0)","v":94},"à",{"$f":"ROUND(AH51*(1+$AH$10/100),0)","v":174},"MWh"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Ontwerp temperatuur",{"$f":"+Z52/(Z55*Cw)+Z54","v":18},"©",{"$f":"+Z70","v":10},"°C",null,null,null,"Gemiddelde temperatuur",14,"©",10,"°C",{"$f":"+IF((AF54-AH54)<4,\"let op dT moet minimaal 4°C zijn\", \"\")","v":""}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Volumestroom maximaal",null,null,{"$f":"IF(inzet_extra_warmteladen=gelijktijdig_bronkoeling,Z71+Z108,MAX(Z71,Z108))","v":19.976133651551311},"m3/h",null,null,null,"Bron capaciteit",null,null,20,"m3/h",null,null,null,null,"Gemiddelde temperatuur",{"$f":"+AF54","v":14},null,"°C",{"$f":"+AH54","v":10},"°C"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Seizoensdebiet gemiddeld",null,{"$f":"ROUND(AH51/(Cw*(AF54-AH54)),0)*1000","v":29000},null,"m3/seiz.",null,null,null,null,"Maximale temperatuur",25,null,"°C"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"SPF bronnen",null,null,25,null,null,null,"Seizoensdebiet maximaal",null,{"$f":"ROUND(AH53/(Cw*(AF54-AH54)),0)*1000","v":37000},null,"m3/seiz."]
[null,null,null,null,"OPWEKKING",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Elektriciteit (Mwhe)",null,null,{"$f":"+Z51/AA57","v":5.36}]
[]
[null,null,"KOELING PIEKVOORZIENING",null,"Koelmachine (mechanische koeling)",null,null,0,"MWh"]
[null,null,null,null,"Vermogen",null,null,0,"kW"]
[null,null,null,null,"Equivalente vollast uren",null,null,{"$f":"IF(H61<>0,H60/H61*1000,0)","v":0},"h",null,"valt buiten SPF-BES"]
[null,null,null,null,"Ontwerp temperatuur",12,"ª",5,"°C"]
[null,null,null,null,"Volumestroom",null,null,{"$f":"H61/(Cw*(-H63+F63))","v":0},"m3/h"]
[]
[]
[null,null,"KOELING UIT BRON",null,"Bron koude leveren",null,null,134,"MWh",null,null,null,null,null,null,null,null,null,null,null,null,null,"Bron koude leveren",null,null,{"$f":"+H67","v":134},"MWh"]
[null,null,null,null,"Vermogen",null,null,186,"kW",null,null,null,null,null,null,null,null,null,null,null,null,null,"Vermogen",null,null,{"$f":"+H68","v":186},"kW"]
[null,null,null,null,"Equivalente vollast uren",null,null,{"$f":"IF(H68<>0,H67/H68*1000,0)","v":720.43010752688178},"h",null,null,null,null,null,null,null,null,null,null,"TSA",null,null,"Equivalente vollast uren",null,null,{"$f":"IF(Z68<>0,Z67/Z68*1000,0)","v":720.43010752688178},"h"]
[null,null,null,null,"Ontwerp temperatuur",19,"ª",11,"°C",null,null,null,null,null,null,null,null,null,null,1,null,null,"Ontwerp temperatuur",{"$f":"+F70-dT_TSA_koeling","v":18},"©",{"$f":"+H70-dT_TSA_koeling","v":10},"°C"]
[null,null,null,null,"Volumestroom",null,null,{"$f":"H68/(Cw*(-H70+F70))","v":19.976133651551311},"m3/h",null,null,null,null,null,null,null,null,null,null,"dT (K)",null,null,"Volumestroom",null,null,{"$f":"Z68/(Cw*(-Z70+X70))","v":19.976133651551311},"m3/h"]
[]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(afvoer_condensorwarmte=naar_bron, \"  I\", \"\")","v":"  I"}]
[null,null,"GELIJKTIJDIG VERWARMEN EN KOELEN",null,"Warmtepomp verdamper",null,null,{"$f":"+Q32","v":0},"MWh",null,null,null,null,"Warmtepomp condensorªverwarmen",null,null,{"$f":"+H32","v":0},"MWh",null,null,null,null,null,{"$f":"IF(afvoer_condensorwarmte=naar_bron, \"  I\", \"\")","v":"  I"}]
[null,null,null,null,"Vermogen",null,null,{"$f":"+Q33","v":139.5},"kW",null,null,null,null,"Vermogen",null,null,{"$f":"+H33","v":186},"kW",null,null,null,null,null,{"$f":"IF(afvoer_condensorwarmte=naar_bron, \"  I\", \"\")","v":"  I"}]
[null,null,null,null,"Equivalente vollast uren",null,null,{"$f":"+Q34","v":0},"h",null,"SPF gerekend bij verwarmen",null,null,"Equivalente vollast uren",null,null,{"$f":"+H34","v":0},"h",null,null,null,null,null,{"$f":"IF(afvoer_condensorwarmte=naar_bron, \"  I___\", \"\")","v":"  I___"},{"$f":"IF(afvoer_condensorwarmte=naar_bron, \"_\", \"\")","v":"_"},{"$f":"IF(afvoer_condensorwarmte=naar_bron, \"_    in serie\", \"\")","v":"_    in serie"}]
[null,null,null,null,"Ontwerp temperatuur",{"$f":"+O35","v":12},"ª",{"$f":"+Q35","v":6},"°C",null,null,null,null,"Ontwerp temperatuur",{"$f":"+F35","v":30},"ª",{"$f":"+H35","v":40},"°C",null,null,null,null,null,null,null,{"$f":"IF(afvoer_condensorwarmte=naar_bron, \"  I\", \"\")","v":"  I"}]
[null,null,null,null,"Volumestroom",null,null,{"$f":"+Q36","v":19.976133651551311},"m3/h",null,null,null,null,"Volumestroom",null,null,{"$f":"+H36","v":15.980906921241049},"m3/h",null,null,null,null,null,null,null,{"$f":"IF(afvoer_condensorwarmte=naar_bron, \"  I\", \"\")","v":"  I"}]
[null,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":"IF(afvoer_condensorwarmte=naar_bron, \"  ↓\", \"\")","v":"  ↓"}]
[]
[null,null,"KOELING WP IN KOELMODUS",null,"Warmtepomp verdamper",null,null,0,"MWh",null,null,null,null,"Warmtepomp condensor",null,null,{"$f":"+H81+L85","v":0},"MWh",null,null,null,null,"Bron afvoer condensorwarmte",null,null,{"$f":"+IF(F89=E91,Q81,0)","v":0},"MWh"]
[null,null,null,null,"Vermogen",null,null,0,"kW",null,null,null,null,"Vermogen",null,null,{"$f":"+H82+H82/L84","v":0},"kW",null,null,null,null,"Vermogen",null,null,{"$f":"IF(F89=E91,Q82,0)","v":0},"kW"]
[null,null,null,null,"Equivalente vollast uren",null,null,{"$f":"IF(H82<>0,H81/H82*1000,0)","v":0},"h",null,"SPF WP-KM seizoen",5,null,"Equivalente vollast uren",null,null,{"$f":"+Q81/Q82*1000","v":{"$error":"#DIV/0!"}},"h",null,"TSA2",null,null,"Equivalente vollast uren",null,null,{"$f":"IF(Z82<>0,Z81/Z82*1000,0)","v":0},"h"]
[null,null,null,null,"Ontwerp temperatuur",19,"ª",11,"°C",null,"COP WP-KM bij piek",5.5,null,"Ontwerp temperatuur",34,"ª",40,"°C",null,null,null,null,"Ontwerp temperatuur",{"$f":"IF(F89=E91,+Z82/(Z85*Cw)+Z84,0)","v":18},"©",{"$f":"IF(afvoer_condensorwarmte=naar_bron,+X70,0)","v":18},"°C"]
[null,null,null,null,"Volumestroom",null,null,{"$f":"H82/(Cw*(-H84+F84))","v":0},"m3/h",null,"Elektriciteit WP (Mwhe)",{"$f":"+H81/L83","v":0},null,"Volumestroom",null,null,{"$f":"Q82/(Cw*(Q84-O84))","v":0},"m3/h",null,null,null,null,"Volumestroom",null,null,{"$f":"IF(F89=E91,+Z71,0)","v":19.976133651551311},"m3/h"]
[null,null,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":"IF(X84>25,\"let op: maximale temperatuur mag max 25°C zijn\",\"\")","v":""}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,"TSA"]
[]
[null,null,null,null,"Condensorwarmte:","afvoeren naar bron",null,null,null,null,null,null,null,"Afvoer condensorwarmte ",null,null,{"$f":"+IF(F89=E92,Q81,0)","v":0},"MWh"]
[null,null,null,null,"mogelijke keuzes:",null,null,null,null,null,null,null,null,"Vermogen",null,null,{"$f":"IF(F89=E92,Q82,0)","v":0},"kW"]
[null,null,null,null,"afvoeren naar bron","(via tweede TSA in serie)",null,null,null,null,"SPF afvoer condensor",20,null,"Equivalente vollast uren",null,null,{"$f":"IF(Q90<>0,Q89/Q90*1000,0)","v":0},"h"]
[null,null,null,null,"afvoeren andere wijze","(dry-cooler, oppervlaktewater)",null,null,null,null,"Elektriciteit (Mwhe)",{"$f":"+Q89/L91","v":0},null,"Ontwerp temperatuur",30,"ª",35,"°C"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,"Volumestroom",null,null,{"$f":"Q90/(Cw*(Q92-O92))","v":0},"m3/h"]
[]
[]
[null,null,"KOELING OVERIG",null,"Koeling overig",null,null,0,"MWh"]
[null,null,"(dry-cooler, oppervlaktewater, LBK, …)",null,"Vermogen",null,null,0,"kW"]
[null,null,null,null,"Equivalente vollast uren",null,null,{"$f":"IF(H97<>0,H96/H97*1000,0)","v":0},"h",null,"SPF koeling overig",20]
[null,null,null,null,"Ontwerp temperatuur",19,"ª",11,"°C",null,"Elektriciteit (Mwhe)",{"$f":"+H96/L98","v":0}]
[null,null,null,null,"Volumestroom",null,null,{"$f":"H97/(Cw*(-H99+F99))","v":0},"m3/h"]
[]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"TSA",2]
[]
[null,null,"BALANSVOORZIENING WARMTE LADEN",null,"Inzet balansvoorziening:","niet gelijktijdig met bron",null,null,null,null,null,null,null,"Balansvoorziening warmte laden",null,null,0,"MWh",null,null,null,null,"Bron balans warmte laden",null,null,{"$f":"+Q104","v":0},"MWh"]
[null,null,"(dry-cooler, oppervlaktewater, LBK, …)",null,"mogelijke keuzes:",null,null,null,null,null,null,null,null,"Vermogen",null,null,0,"kW",null,null,null,null,"Vermogen",null,null,{"$f":"+Q105","v":0},"kW"]
[null,null,null,null,"gelijktijdig met bron","(brondebiet wordt groter)",null,null,null,null,"SPF balansvoorziening",20,null,"Equivalente vollast uren",null,null,{"$f":"IF(Q105<>0,Q104/Q105*1000,0)","v":0},"h",null,null,null,null,"Equivalente vollast uren",null,null,{"$f":"IF(Z105<>0,Z104/Z105*1000,0)","v":0},"h"]
[null,null,null,null,"niet gelijktijdig met bron","(max vermogen maatgevend)",null,null,null,null,"Elektriciteit (Mwhe)",{"$f":"+Q104/L106","v":0},null,"Ontwerp temperatuur",{"$f":"+X107+dT_TSA_koeling+dT_TSA2_balans_warmte_laden","v":21},"ª",{"$f":"+H70","v":11},"°C",null,null,null,null,"Ontwerp temperatuur",{"$f":"+X70","v":18},"©",{"$f":"+Z70","v":10},"°C"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,"Volumestroom",null,null,{"$f":"Q105/(Cw*(-Q107+O107))","v":0},"m3/h",null,null,null,null,"Volumestroom",null,null,{"$f":"Z105/(Cw*(-Z107+X107))","v":0},"m3/h"]
[]
[]
[]
[]
[]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Akkordering:",null,null,null,null,null,null,null,null,"BRON JAAR TOTAAL"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Deze uitgangspunten zijn akkoord voor het ontwerp van het",null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(AQ116<-1,\"let op, warmte overschot is niet toegestaan\", \"\")","v":""}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"bodemenergiesysteem.",null,null,null,null,null,null,null,null,"Koude overschot in de bodem",null,null,{"$f":"+AH9-AH51","v":172.89999999999998},"MWh"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Koude overschot percentage ",null,null,{"$f":"IF(AH51=0,0,AH9/AH51*100)","v":229.02985074626864},"%"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Bedrijfsnaam bovengronds ontwerper:"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Jaardebiet gemiddeld",null,{"$f":"+AH14+AG56","v":95000},null,"m3/jaar"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Jaardebiet maximaal",null,{"$f":"+AH15+AG57","v":123000},null,"m3/jaar"]
[]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Naam projectleider:",null,null,null,null,null,null,null,null,"SPF BES (totaal)",{"$f":"+(L10+L52)/(L11+L53)","v":4.5290821771611531}]
[]
[]
[]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Datum:"]
[]
[]
[]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Handtekening:"]