{"text_format":"1","workbook":"xlsx","n_sheets":7,"sheets":["Info","Calcul - Berekening","Directives","Richtlijnen","GA_cookies","Coef d'expansion","Langage"],"not_rendered":{"charts":0,"images":3,"macros":1,"external_links":0,"defined_names":5,"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":"Info","index":0,"n_rows":31,"n_cols":5,"rows_kept":31,"cut":false,"hidden":false,"merged":[[4,1,4,7],[25,1,25,7],[9,1,9,7],[27,1,27,7],[28,1,28,7],[11,1,11,7],[12,1,12,7],[13,1,13,7]]}
[]
[]
[]
[]
[null,"Dimensionering van gesloten expansievaten"]
[null,null,null,null,"met constante druk"]
[null,null,null,null,"NBN EN 12828:2013 - Bijlage D"]
[null,null,null,null,"Ontwikkeld in het kader van het Belgische project \"KMO - normenantenne\""]
[]
[null,"Bezoek onze website : www.buildwise.be"]
[]
[null,"Buildwise kan niet verantwoordelijk gesteld worden voor de ingevoerde  "]
[null,"gegevens, noch voor het verkeerde gebruik van de software"]
[null,"of de verkeerde resultaten die eruit zouden voortkomen."]
[]
[]
[]
[]
[]
[]
[null,null,null,null,"Dimensionnement des vases d'expansion fermés"]
[null,null,null,null,"à pression constante"]
[null,null,null,null,"NBN EN 12828:2013 - Annexe D"]
[null,null,null,null,"Développé dans le cadre du projet belge \"PME - antenne normes\""]
[]
[null,"Visitez notre site web : http://www.buildwise.be"]
[]
[null,"Buildwise ne peut être tenu responsable des données introduites, de la"]
[null,"mauvaise utilisation du programme ou des erreurs qui en résulteraient."]
[]
[null,null,null,null,"Versie - Version 1.3 (2022)"]

{"sheet":"Calcul - Berekening","index":1,"n_rows":80,"n_cols":12,"rows_kept":80,"cut":false,"hidden":false,"merged":[[37,1,37,3],[38,1,38,5],[26,1,26,4],[27,1,27,4],[45,1,45,5],[34,1,34,10],[40,1,40,10],[42,1,42,3],[43,1,43,3],[44,1,44,3],[36,1,36,3],[32,1,32,3],[31,1,31,3],[15,1,15,6],[20,1,20,6],[19,1,19,6],[18,1,18,6],[3,1,3,10],[13,1,13,10],[17,1,17,6],[16,1,16,6],[22,1,22,10],[29,1,29,10],[5,1,5,10],[7,1,7,2],[8,1,8,2],[9,1,9,2],[10,1,10,2],[11,1,11,2],[7,8,7,9],[7,3,7,6],[25,1,25,3],[24,1,24,3],[8,3,8,9],[9,3,9,9],[10,3,10,9],[11,3,11,9]]}
[]
[null,"   Langue / Taal :",null,"Nederlands"]
[]
[null,{"$f":"Langage!A5","v":"Rekenblad gesloten expansievat met constante druk"}]
[]
[null,{"$f":"Langage!A6","v":"Referentie"}]
[]
[null,{"$f":"Langage!A44","v":"Dossier"},null,null,null,null,null,{"$f":"Langage!A49","v":"    Datum"}]
[null,{"$f":"Langage!A45","v":"Naam"}]
[null,{"$f":"Langage!A46","v":"Adres"}]
[null,{"$f":"Langage!A47","v":"Gemeente"}]
[null,{"$f":"Langage!A48","v":"Commentaar"}]
[]
[null,{"$f":"Langage!A7","v":"Invoergegevens voor de installatie"}]
[]
[null,{"$f":"Langage!A13","v":"1 Maximale bedrijfstemperatuur"},null,null,null,null,null,"qmax",null,"°C"]
[null,{"$f":"Langage!A14","v":"2 Antivriesproduct concentratie (ethyleenglycol)"},null,null,null,null,null,null,0,"%"]
[null,{"$f":"Langage!A15","v":"3 Expansiecoëfficiënt (vulling op 10°C)"},null,null,null,null,null,"e",{"$f":"IF(I16=\"\",\"\",VLOOKUP(I16, 'Coef d''expansion'!A4:G17, MATCH(I17, 'Coef d''expansion'!A4:G4, 0), FALSE))","v":""},"%"]
[null,{"$f":"Langage!A16","v":"4 Relatieve dampdruk"},null,null,null,null,null,"pv",{"$f":"IF(I16=\"\",\"\",VLOOKUP(I16, 'Coef d''expansion'!A4:I17, 9, FALSE))","v":""},"bar"]
[null,{"$f":"Langage!A17","v":"5 Waterinhoud van de installatie"},null,null,null,null,null,"Vsystem",null,"l"]
[null,{"$f":"Langage!A18","v":"6 Statische hoogte"},null,null,null,null,null,"hst",null,"m"]
[]
[null,{"$f":"Langage!A8","v":"Theoretische berekening van het expansievat"}]
[]
[null,{"$f":"Langage!A19","v":"7 Expansievolume van het water"},null,null,null,"Vex = Vsystem  x e / 100",null,null,{"$f":"IF(OR(I18=\"\",I20=\"\"),\"\",I18*I20/100)","v":""},"l"]
[null,{"$f":"Langage!A20","v":"8 Minimaal reservewatervolume"},null,null,null,"Vwr,min = max [Vsystem x 0,005; 3]",null,null,{"$f":"IF(I20=\"\",\"\",MAX(I20*0.005,3))","v":""},"l"]
[null,{"$f":"Langage!A21","v":"9 Gebruiksrendement van het expansievat"},null,null,null,"h      [0,1 ; 1]",null,null,null,"-"]
[null,{"$f":"Langage!A22","v":"10 Minimaal werkelijk volume van het vat"},null,null,null,"VN,min = (Vex + Vwr,min) / h",null,null,{"$f":"IF(OR(I26=\"\",I27=\"\"),\"\",(I25+I26)/I27)","v":""},"l"]
[]
[null,{"$f":"Langage!A9","v":"Keuze van het expansievat"}]
[]
[null,{"$f":"Langage!A23","v":"11 Werkelijk volume van het vat"},null,null,null,null,"VN ≥ VN,min",null,null,"l"]
[null,{"$f":"Langage!A24","v":"12 Maximaal reservewatervolume"},null,null,null,null,"Vwr,max = h x VN - Vex",null,{"$f":"IF(OR(I32=\"\",I25=\"\",I27=\"\"),\"\",I27*I32-I25)","v":""},"l"]
[]
[null,{"$f":"Langage!A10","v":"Berekening van de geregelde druk in het expansievat"}]
[]
[null,{"$f":"Langage!A25","v":"13 Statische druk"},null,null,null,null,"pst = hst x 0,0981",null,{"$f":"IF(I21=\"\",\"\",I21*0.0981)","v":""},"bar"]
[null,{"$f":"Langage!A26","v":"14 Geregelde druk"},null,null,null,null,"preg = pst + pv + 0,5",null,{"$f":"IF(OR(I19=\"\",I37=\"\"),\"\",I37+I19+0.5)","v":""},"bar","\u0081"]
[null,{"$f":"Langage!A27","v":"15 Insteldruk van het veiligheidsventiel"},null,null,null,null,"psv ≥ preg + 0,5 + 0,5",null,{"$f":"IF(I38=\"\",\"\",I38+0.5+0.5)","v":""},"bar"]
[]
[null,{"$f":"Langage!A11","v":"Bepaling van de capaciteit van de compressor of van de pomp"}]
[]
[null,{"$f":"Langage!A28","v":"16 Geïnstalleerd vermogen"},null,null,null,null,"FSU",null,null,"kW"]
[null,{"$f":"Langage!A29","v":"17 Gemiddelde watertemperatuur"},null,null,null,null,"qmean",null,null,"°C"]
[null,{"$f":"Langage!A30","v":"18 Contractiedebiet"},null,null,null,null,"qc",null,{"$f":"IF(I44=\"\",\"\",0.006*I44+0.09)","v":""},"l/(h.kW)"]
[null,{"$f":"Langage!A31","v":"19 Capaciteit van de compressor of van de pomp"},null,null,null,null,"qcom = qc x FSU / 2",null,{"$f":"IF(OR(I43=\"\",I45=\"\"),\"\",I43/2*I45)","v":""},"l/h"]
[]
[]
[null,{"$f":"Langage!A41","v":"(1) De geregelde druk dient eventueel verhoogd te worden om rekening te houden met de minimale"}]
[null,{"$f":"Langage!A42","v":" werkingsdruk van de ketel en/of de minimale waarde aan de zuigzijde van de pomp"}]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[null,null,null,null,null,null,null,null,50,{"$f":"IF(I$16<I70,\"\",I70)","v":""},null,50]
[null,null,null,null,null,null,null,null,55,{"$f":"IF(I$16<I71,\"\",I71)","v":""},null,60]
[null,null,null,null,null,null,null,null,60,"",null,70]
[null,null,null,null,null,null,null,null,65,"",null,80]
[null,null,null,null,null,null,null,null,70,"",null,90]
[null,null,null,null,null,null,null,null,75,"",null,100]
[null,null,null,null,null,null,null,null,80,"",null,110]
[null,null,null,null,null,null,null,null,85,"",null,120]
[null,null,null,null,null,null,null,null,90,"",null,130]
[null,null,null,null,null,null,null,null,95,""]
[null,null,null,null,null,null,null,null,100,""]

{"sheet":"Directives","index":2,"n_rows":0,"n_cols":0,"rows_kept":0,"cut":false,"hidden":false,"merged":[]}

{"sheet":"Richtlijnen","index":3,"n_rows":0,"n_cols":0,"rows_kept":0,"cut":false,"hidden":false,"merged":[]}

{"sheet":"GA_cookies","index":4,"n_rows":3,"n_cols":1,"rows_kept":3,"cut":false,"hidden":true,"merged":[]}
["Google Analytics ID"]
["Sum of openings"]
["Cookies accepted"]

{"sheet":"Coef d'expansion","index":5,"n_rows":20,"n_cols":10,"rows_kept":20,"cut":false,"hidden":true,"merged":[[2,1,2,6],[18,0,18,6]]}
[]
[]
["Température maximale de service","Coefficient d'expansion e (en %) pour différentes\nconcentrations de produit antigel (ethylène glycol) (en %)\n",null,null,null,null,null,"Volume massique\neau pure\n","Pression de vapeur saturante\neau pure","Débit de contraction"]
["°C",0,10,20,30,40,50,"dm³/kg","bar","l.h/kW"]
[10,0,0,0,0,0,0,1.0003,0]
[20,0.14000000000000001,0.28999999999999998,0.31,0.34,0.36,0.38,1.0017,0]
[30,0.4,0.63,0.67,0.72,0.77,0.81,1.0043,0]
[40,0.75,1.02,1.0900000000000001,1.1599999999999999,1.22,1.3,1.0078,0]
[50,1.18,1.46,1.55,1.64,1.74,1.83,1.0121,0,0.39]
[60,1.68,1.96,2.0699999999999998,2.1800000000000002,2.2999999999999998,2.42,1.0170999999999999,0,0.45]
[70,2.25,2.5099999999999998,2.64,2.78,2.91,3.06,1.0227999999999999,0,0.51]
[80,2.89,3.12,3.27,3.43,3.59,3.76,1.0291999999999999,0,0.56999999999999995]
[90,3.57,3.79,3.96,4.1399999999999997,4.32,4.51,1.0361,0,0.63]
[100,4.34,4.5199999999999996,4.71,4.91,5.1100000000000003,5.33,1.0437000000000001,0.01,0.69]
[110,5.15,5.31,5.52,5.74,5.97,6.21,1.0519000000000001,0.43]
[120,6.02,6.17,6.4,6.64,6.89,7.16,1.0606,0.99]
[130,6.97,7.04,7.28,7.55,7.83,8.1199999999999992,1.07,1.7]
[]
["Références:\nRecknagel - Genie Climatique 2007 - Tableau 1.3.1-6\nAshrae Handbook - Fundamentals (SI) 2009 - Tableau 6 page 31.7"]
["* Valeurs extrapolées"]

{"sheet":"Langage","index":6,"n_rows":49,"n_cols":3,"rows_kept":49,"cut":false,"hidden":true,"merged":[]}
["Choix"]
[]
[{"$f":"'Calcul - Berekening'!D2","v":"Nederlands"},"Français","Nederlands"]
[{"$f":"IF(A$3=B$3,B4,C4)","v":"nl_be"},"fr_be","nl_be"]
[{"$f":"IF(A$3=B$3,B5,C5)","v":"Rekenblad gesloten expansievat met constante druk"},"Tableau de calcul du vase d'expansion fermé à pression constante","Rekenblad gesloten expansievat met constante druk"]
[{"$f":"IF(A$3=B$3,B6,C6)","v":"Referentie"},"Références","Referentie"]
[{"$f":"IF(A$3=B$3,B7,C7)","v":"Invoergegevens voor de installatie"},"Données relatives à l'installation","Invoergegevens voor de installatie"]
["Theoretische berekening van het expansievat","Calcul théorique du vase d'expansion","Theoretische berekening van het expansievat"]
["Keuze van het expansievat","Choix du vase d'expansion","Keuze van het expansievat"]
["Berekening van de geregelde druk in het expansievat","Calcul de la pression réglée dans le vase d'expansion","Berekening van de geregelde druk in het expansievat"]
["Bepaling van de capaciteit van de compressor of van de pomp","Détermination de la capacité du compresseur ou de la pompe","Bepaling van de capaciteit van de compressor of van de pomp"]
[0]
["1 Maximale bedrijfstemperatuur","1 Température maximale de service","1 Maximale bedrijfstemperatuur"]
["2 Antivriesproduct concentratie (ethyleenglycol)","2 Concentration en antigel (éthylène glycol)","2 Antivriesproduct concentratie (ethyleenglycol)"]
["3 Expansiecoëfficiënt (vulling op 10°C)","3 Coefficient d'expansion (remplissage à 10°C)","3 Expansiecoëfficiënt (vulling op 10°C)"]
["4 Relatieve dampdruk","4 Pression de vapeur saturante","4 Relatieve dampdruk"]
["5 Waterinhoud van de installatie","4 Contenance en eau de l'installation","5 Waterinhoud van de installatie"]
["6 Statische hoogte","6 Hauteur statique","6 Statische hoogte"]
["7 Expansievolume van het water","7 Volume d'expansion de l'eau","7 Expansievolume van het water"]
["8 Minimaal reservewatervolume","8 Volume de réserve d'eau minimal","8 Minimaal reservewatervolume"]
["9 Gebruiksrendement van het expansievat","9 Rendement d'utilisation du vase","9 Gebruiksrendement van het expansievat"]
["10 Minimaal werkelijk volume van het vat","10 Volume nominal minimal du vase","10 Minimaal werkelijk volume van het vat"]
["11 Werkelijk volume van het vat","11 Volume nominal du vase","11 Werkelijk volume van het vat"]
["12 Maximaal reservewatervolume","12 Volume de réserve d'eau maximal","12 Maximaal reservewatervolume"]
["13 Statische druk","13 Pression statique","13 Statische druk"]
["14 Geregelde druk","14 Pression réglée","14 Geregelde druk"]
["15 Insteldruk van het veiligheidsventiel","15 Pression de tarage de la soupape de sécurité","15 Insteldruk van het veiligheidsventiel"]
["16 Geïnstalleerd vermogen","16 Puissance totale installée","16 Geïnstalleerd vermogen"]
["17 Gemiddelde watertemperatuur","17 Température d'eau moyenne","17 Gemiddelde watertemperatuur"]
["18 Contractiedebiet","18 Débit de contraction","18 Contractiedebiet"]
["19 Capaciteit van de compressor of van de pomp","19 Capacité du compresseur ou de la pompe","19 Capaciteit van de compressor of van de pomp"]
[0]
[0]
[0]
[0]
[0]
[0]
[]
[]
[0]
["(1) De geregelde druk dient eventueel verhoogd te worden om rekening te houden met de minimale","(1) La pression à régler doit éventuellement être accrue pour tenir compte de la pression de fonctionnement","(1) De geregelde druk dient eventueel verhoogd te worden om rekening te houden met de minimale"]
[" werkingsdruk van de ketel en/of de minimale waarde aan de zuigzijde van de pomp","  minimale requise de la chaudière et/ou de la pression minimale requise à l'aspiration de la pompe"," werkingsdruk van de ketel en/of de minimale waarde aan de zuigzijde van de pomp"]
[]
["Dossier","Dossier","Dossier"]
["Naam","Nom","Naam"]
["Adres","Adresse","Adres"]
[{"$f":"IF(A$3=B$3,B47,C47)","v":"Gemeente"},"Commune","Gemeente"]
["Commentaar","Commentaire","Commentaar"]
["    Datum","    Date","    Datum"]