{"text_format":"3","workbook":"xlsx","n_sheets":15,"sheets":["Tool","Translations","Messages","Comments","Financiële balans","Hyp","General Data","Tech Data","Energy Data","Eco Data","Calculs","A-7sur7","B-5sur7","C-5sur7HVS","D-7sur7HVS"],"not_rendered":{"charts":1,"images":2,"macros":1,"defined_names":143,"comments":10},"read":"whole","date_system":"1900"}

{"sheet":"Tool","index":0,"n_rows":69,"n_cols":9,"rows_kept":69,"merged":[[3,0,3,8],[4,0,4,3],[4,5,4,8],[5,0,5,3],[6,7,6,8],[10,13,11,13],[28,0,28,4],[28,5,28,8],[31,2,31,3],[44,2,44,3],[52,2,52,3]]}
[]
["Kies uw taal / Choisissez votre langue :","Ú","FR",{"$f":"MATCH(C2,Translations!$C$1:$AA$1,0)+1","v":3}]
[]
[{"$f":"VLOOKUP(\"title_tool\",Translations,LANG,FALSE)","v":"Outil de pré-dimensionnement d'un grand système solaire thermique de production d'eau chaude"}]
[{"$f":"VLOOKUP(\"ALGEMENE INFORMATIE\",Translations,LANG,FALSE)","v":"INFORMATION GENERALES"},{"$nulls":4},{"$f":"VLOOKUP(\"BEREKENINGSHYPOTHESEN\",Translations,LANG,FALSE)","v":"HYPOTHESES DE CALCUL"}]
[]
[{"$f":"VLOOKUP(\"[Vestigingsnaam] :\",Translations,LANG,FALSE)","v":"[Nom Etablissement] :"},{"$nulls":5},{"$f":"VLOOKUP(\"Gebruikte energiedrager voor de warmwaterproductie\",Translations,LANG,FALSE)","v":"Vecteur énergétique utilisé pour la production d'eau chaude"},{"$f":"IF(ISBLANK(C43),'Eco Data'!A5,Tool!C43)","v":"3-Gaz naturel (RBC)"}]
[{"$f":"VLOOKUP(\"[Sector] :\",Translations,LANG,FALSE)","v":"[Secteur] :"},{"$nulls":5},{"$f":"VLOOKUP(\"Warmwaterketelrendement\",Translations,LANG,FALSE)","v":"Rendement utile de production d'eau chaude par l'appoint"},{"$f":"IF(Calculs!B25,Calculs!B26,Calculs!C26)","v":{"v":0.7507013000401674,"d":"75%"}}]
[{"$f":"VLOOKUP(\"[Adres] : \",Translations,LANG,FALSE)","v":"[Adresse] : "},{"$nulls":5},""]
[{"$f":"VLOOKUP(\"[Gemeente] :\",Translations,LANG,FALSE)","v":"[Localité] :"},{"$nulls":5},{"$f":"VLOOKUP(\"Referentiewarmwaterverbruik\",Translations,LANG,FALSE)","v":"Consommation d'eau chaude de référence"},{"$f":"IF(OR(ISBLANK(C32),ISBLANK(C33)),\"\",Calculs!C6)","v":0.18},{"$f":"VLOOKUP(\"m³/dag op 60°C\",Translations,LANG,FALSE)","v":"m³/jour à 60°C"}]
[{"$f":"VLOOKUP(\"[Postcode] : \",Translations,LANG,FALSE)","v":"[Code Postal] : "},{"$nulls":6},{"$f":"IF(OR(ISBLANK(C49),C49=0),\"\",Calculs!B16)","v":{"v":1.36986301369863,"d":"1.37"}},{"$f":"IF(OR(ISBLANK(C49),C49=0),\"\",VLOOKUP(\"m³/dag warm waterverbruik op 60°C\",Translations,LANG,FALSE) )","v":"m³/jour de puisage à 60°C"}]
[{"$f":"VLOOKUP(\"[Contactpersoon] :\",Translations,LANG,FALSE)","v":"[Personne de contact] :"},{"$nulls":5},{"$f":"VLOOKUP(\"Gelijkwaardige warmwaterverbruik per dag\",Translations,LANG,FALSE)","v":"Consommation d'eau chaude en équivalent journalier  "},{"$f":"IF(OR(ISBLANK(C49),C49=0,Calculs!B14=FALSE),Calculs!C6,Calculs!B15)","v":{"v":1.36986301369863,"d":"1.37"}},{"$f":"VLOOKUP(\"m³/dag op 60°C\",Translations,LANG,FALSE)","v":"m³/jour à 60°C"}]
[{"$f":"VLOOKUP(\"[Functie] :\",Translations,LANG,FALSE)","v":"[Fonction] :"},{"$nulls":5},{"$f":"VLOOKUP(\"Profiel van het warmwaterverbruik\",Translations,LANG,FALSE)","v":"Profil de puisage de l'eau chaude"},{"$f":"IF(ISBLANK(C53),'Tech Data'!B47,Tool!C53)","v":"A-7 jours sur 7 toute l'année"}]
[{"$f":"VLOOKUP(\"[Tel.]\",Translations,LANG,FALSE)","v":"[Tel.]"},{"$nulls":5},{"$f":"VLOOKUP(\"Actualisatievoet\",Translations,LANG,FALSE)","v":"Taux d'actualisation"},{"$f":"'Financiële balans'!C4","v":{"v":0.055,"d":"5.5%"}}]
[{"$f":"VLOOKUP(\"[E-mail] :\",Translations,LANG,FALSE)","v":"[E-mail] :"},{"$nulls":5},{"$f":"VLOOKUP(\"BTW-percentage voor de economische balans\",Translations,LANG,FALSE)","v":"Taux de TVA pour le bilan économique"},{"$f":"IF(ISBLANK(C57)*OR(C57=0),'Eco Data'!B16,Tool!C57)","v":{"v":0.21,"d":"21%"}}]
[{"$nulls":6},{"$f":"VLOOKUP(\"Eenheidsprijs van de brandstof\",Translations,LANG,FALSE)","v":"Prix unitaire du combustible"},{"$f":"IF(ISBLANK(C43),'Eco Data'!R5,IF(ISNUMBER(C62),C62,IF(H15=0,LOOKUP(Calculs!B17,SourceEnergie,PrixDéfaut),LOOKUP(Calculs!B17,SourceEnergie,PrixDéfautTVAc))))","v":{"v":0.06715499999999999,"d":"0.067"}},{"$f":"IF(ISBLANK(C43),'Eco Data'!S5,IF(H15=0,LOOKUP(Calculs!B17,SourceEnergie,UnitéPrixDéfaut),LOOKUP(Calculs!B17,SourceEnergie,UnitéPrixDéfautTVAc)))","v":"EUR/kWh TVAc"}]
[{"$f":"VLOOKUP(\"De Quickscan Zonthermische Energie is een tool die ontwikkeld is voor het Brussels Hoofdstedelijk Gewest en het Waals Gewest\",Translations,LANG,FALSE)","v":"Le Quick Scan Solaire thermique est un outil développé pour la Région wallonne et la Région de Bruxelles-Capitale"},{"$nulls":5},{"$f":"VLOOKUP(\"Brandstofprijs per kWh\",Translations,LANG,FALSE)","v":"Prix par kWh de combustible"},{"$f":"IF(ISBLANK(C43),'Eco Data'!W5,H16*Calculs!C22)","v":{"v":0.06715499999999998,"d":"0.067"}},{"$f":"IF(ISBLANK(C43),'Eco Data'!X5,IF(H15=0,LOOKUP(Calculs!B17,SourceEnergie,UnitéPrix_kWh),LOOKUP(Calculs!B17,SourceEnergie,UnitéPrix_kWhTVAc)))","v":"EUR/kWh TVAc"}]
[null,null,{"$f":"VLOOKUP(\"Concept en ontwikkeling : 3E nv\",Translations,LANG,FALSE)","v":"Conception & Développement : 3E s.a."},{"$nulls":3},{"$f":"VLOOKUP(\"Subsidiepercentage gebruikt voor de berekening\",Translations,LANG,FALSE)","v":"Taux de subside utilisé pour le calcul"},{"$f":"Calculs!B28/100","v":{"v":0,"d":"0%"}}]
[{"$f":"VLOOKUP(\"version\",Translations,LANG,FALSE) &\" 2015\"","v":"Version 2015"},null,{"$f":"VLOOKUP(\"Aanpassingen:\",Translations,LANG,FALSE)","v":"Modifications:"},"CVBA CENERGIE",null,null,{"$f":"VLOOKUP(\"Indicatief subsidiepercentage (Energiepremie) voor het beschouwde systeem\",Translations,LANG,FALSE)","v":"Taux de subside (Prime Energie) indicatif en RBC pour le système considéré"},{"$f":"IFERROR(Calculs!C29/H54,\"\")","v":{"v":0.5,"d":"50%"}}]
[null,null,{"$f":"VLOOKUP(\"Veld\",Translations,LANG,FALSE)","v":"Champ"},{"$nulls":3},{"$f":"VLOOKUP(\"Korting op de persoonsbelasting voor een energiebesparende investering\",Translations,LANG,FALSE)","v":"Réduction d'IPP pour investissement économiseur d'énergie"},{"$f":"IF(AND(ISTEXT(Tool!D34),(C34>3)),C68/100,\"\")","v":""}]
[null,null,{"$f":"VLOOKUP(\"Verplicht\",Translations,LANG,FALSE)","v":"Obligatoire"},{"$nulls":3},{"$f":"VLOOKUP(\"Jaarlijkse prijsstijging van de energiedrager\",Translations,LANG,FALSE)","v":"Augmentation annuelle du prix du vecteur énergétique"},{"$f":"'Financiële balans'!C5","v":{"v":0.0587,"d":"5.87%"}}]
[null,null,{"$f":"VLOOKUP(\"Facultatief\",Translations,LANG,FALSE)","v":"Facultatif"},{"$f":"VLOOKUP(\" (indien blanco, worden standaardwaarden gebruikt)\",Translations,LANG,FALSE)","v":"(si pas rempli, les valeurs par défaut sont utilisés)"},null,null,{"$f":"VLOOKUP(\"Onderhoudskost van de installatie als percentage van de investering\",Translations,LANG,FALSE)","v":"Pourcentage de l'investissement affecté à la maintenance de l'installation"},{"$f":"Hyp!B19","v":{"v":0.0025,"d":"0.25%"}}]
[null,"Ú",{"$f":"VLOOKUP(\"Uitklaplijstje\",Translations,LANG,FALSE)","v":"Menu Déroulant"},{"$nulls":3},{"$f":"VLOOKUP(\"Zonnepanelen\",Translations,LANG,FALSE)","v":"Capteurs solaires"},{"$f":"VLOOKUP(\"Vlakkeplaatcollectoren\",Translations,LANG,FALSE)","v":"Atmosphériques plans vitrés"}]
[{"$nulls":6},{"$f":"VLOOKUP(\"Oriëntatie van de panelen gebruikt in de berekening\",Translations,LANG,FALSE)","v":"Orientation des capteurs utilisée pour le calcul"},{"$f":"IF(ISBLANK(C37),'Tech Data'!E9,LOOKUP(Tool!C37,Toit,OrientOpt))","v":"1-Est"}]
[{"$nulls":6},{"$f":"VLOOKUP(\"Hellingsgraad van de panelen gebruikt in de berekening\",Translations,LANG,FALSE)","v":"Inclinaison des capteurs utilisée pour le calcul"},{"$f":"IF(ISBLANK(C40),'Tech Data'!C9,LOOKUP(Calculs!B33,Toit,InclinOpt))","v":{"v":45,"d":"45°"}}]
[{"$nulls":6},{"$f":"VLOOKUP(\"Correctiefactor\",Translations,LANG,FALSE)","v":"Facteur Correctif"},{"$f":"IF(ISBLANK(C37),'Tech Data'!D9,LOOKUP(Tool!C37,Toit,FactCorr))","v":{"v":1.2833865758009408,"d":"1.28"}},{"$f":"Tool!C37","v":"Toiture inclinée"}]
[{"$nulls":6},{"$f":"VLOOKUP(\"Economische levensduur van de installatie\",Translations,LANG,FALSE)","v":"Durée de vie économique de l'installation"},{"$f":"Hyp!B9","v":25},{"$f":"VLOOKUP(\"jaren\",Translations,LANG,FALSE)","v":"ans"}]
[]
[{"$f":"VLOOKUP(\"BASISGEGEVENS\",Translations,LANG,FALSE)","v":"DONNEES DE BASE"},{"$nulls":4},{"$f":"VLOOKUP(\"RESULTATEN\",Translations,LANG,FALSE)","v":"RESULTATS"}]
[]
[{"$f":"VLOOKUP(\"Beschrijving van de vestiging\",Translations,LANG,FALSE)","v":"Descriptif de l'établissement"},{"$nulls":5},{"$f":"VLOOKUP(\"Zonnefractie\",Translations,LANG,FALSE)","v":"Fraction solaire"}]
[{"$f":"VLOOKUP(\"Vestigingstype\",Translations,LANG,FALSE)","v":"Type d'établissement"},"Ú",{"$f":"VLOOKUP(\"T-Kantoren\",Translations,LANG,FALSE)","v":"T-Bureau d'entreprise"},{"$nulls":3},{"$f":"VLOOKUP(\"Optimale nuttige zonnefractie\",Translations,LANG,FALSE)","v":"Fraction solaire utile à l'optimum"},{"$f":"IFERROR(LOOKUP(H13,ProfilHebdo,Fsol)*100,\"\")","v":{"v":34.0619851370694,"d":"34"}},"%"]
[{"$f":"VLOOKUP(\"Bezetting\",Translations,LANG,FALSE)","v":"Fréquentation"},null,90,{"$f":"LOOKUP(C32,TypeEtablissement,UnitéConsomECS)","v":"Employés"},null,null,{"$f":"VLOOKUP(\"Zonnefractie wanneer het dak beperkt is in oppervlakte\",Translations,LANG,FALSE)","v":"Fraction solaire si la toiture est limitée en surface  "},{"$f":"IF(Calculs!B36,\"\",(LOOKUP(Tool!H13,ProfilHebdo,Fsolmax)*100))","v":""},"%"]
[{"$f":"IF(ISTEXT(D34),VLOOKUP(\"Aantal wooneenheden\",Translations,LANG,FALSE),\"\")","v":""},null,30,{"$f":"LOOKUP(C32,TypeEtablissement,UnitéHabitation)","v":0}]
[{"$f":"VLOOKUP(\"Jaarlijkse gemiddelde bezettingsgraad\",Translations,LANG,FALSE)","v":"Taux d'occupation annuel moyen"},null,100,"%",null,null,{"$f":"IF(OR(H12>0.6,0),\"\",VLOOKUP(\"Het warmwaterverbruik is onvoldoende om de installatie te dimensioneren!\",Translations,LANG,FALSE))","v":""}]
[{"$f":"VLOOKUP(\"Gebouwoppervlakte\",Translations,LANG,FALSE)","v":"Surface du bâtiment"},null,{"v":1100,"d":"1,100 m²"},{"$nulls":3},{"$f":"VLOOKUP(\"Nuttige oppervlakte van de zonnepanelen\",Translations,LANG,FALSE)","v":"Surface optique de capteurs solaires "}]
[{"$f":"VLOOKUP(\"Daktype\",Translations,LANG,FALSE)","v":"Toiture"},"Ú",{"$f":"VLOOKUP(\"Hellend dak\",Translations,LANG,FALSE)","v":"Toiture inclinée"},{"$nulls":3},{"$f":"VLOOKUP(\"Optimale oppervlakte van de zonnepanelen\",Translations,LANG,FALSE)","v":"Surface de capteurs à l'optimum"},{"$f":"LOOKUP(H13,ProfilHebdo,Scoll)","v":{"v":23.011200416981982,"d":"23"}},"m²"]
[{"$f":"VLOOKUP(\"Maximale nuttige dakoppervlakte\",Translations,LANG,FALSE)","v":"Surface maximale utile de toiture "},{"$nulls":5},{"$f":"VLOOKUP(\"Corresponderende oppervlakte plat dak\",Translations,LANG,FALSE)","v":"Surface de toiture plate correspondante"},{"$f":"H37*'Tech Data'!C24","v":{"v":77.08752139688964,"d":"77"}},{"$f":"VLOOKUP(\"m² (zonder schaduw of obstakels)\",Translations,LANG,FALSE)","v":"m² (non ombragée, sans obstacles)"}]
[{"$f":"VLOOKUP(\"Dakoriëntatie\",Translations,LANG,FALSE)","v":"Orientation de la toiture"},"Ú",{"$f":"VLOOKUP(\"1-Oost\",Translations,LANG,FALSE)","v":"1-Est"},{"$nulls":3},{"$f":"VLOOKUP(\"Corresponderende oppervlakte hellend dak\",Translations,LANG,FALSE)","v":"Surface de toiture inclinée correspondante"},{"$f":"H37*'Tech Data'!C23","v":{"v":27.613440500378378,"d":"28"}},{"$f":"VLOOKUP(\"m² (zonder schaduw of obstakels)\",Translations,LANG,FALSE)","v":"m² (non ombragée, sans obstacles)"}]
[{"$f":"VLOOKUP(\"Hellingsgraad van het dak\",Translations,LANG,FALSE)","v":"Inclinaison de la toiture"},"Ú",{"v":45,"d":"45°"},{"$nulls":3},{"$f":"VLOOKUP(\"Max installeerbare oppervlakte panelen bij beperkte dakoppervlakte\",Translations,LANG,FALSE)","v":"Surface de capteurs maximale installable (si contrainte en toiture)"},{"$f":"IF(Calculs!B36,H37,LOOKUP(H13,ProfilHebdo,Scollmax))","v":{"v":23.011200416981982,"d":"23"}},"m²"]
["",{"$nulls":5},""]
[{"$f":"VLOOKUP(\"Warmwaterproductie\",Translations,LANG,FALSE)","v":"Production d'eau chaude"},{"$nulls":5},{"$f":"VLOOKUP(\"Zonneopslag\",Translations,LANG,FALSE)","v":"Stockage solaire"}]
[{"$f":"VLOOKUP(\"Gebruikte energiedrager voor de warmwaterproductie\",Translations,LANG,FALSE)","v":"Vecteur énergétique utilisé pour la production d'eau chaude"},"Ú",{"$f":"VLOOKUP(\"3-Aardgas (BHG)\",Translations,LANG,FALSE)","v":"3-Gaz naturel (RBC)"},{"$nulls":3},{"$f":"VLOOKUP(\"Totaal volume zonneopslag\",Translations,LANG,FALSE)","v":"Volume total de stockage solaire "},{"$f":"IFERROR(IF(Calculs!B36,LOOKUP(H13,ProfilHebdo,Vstock),LOOKUP(H13,ProfilHebdo,Vstockmax)),\"\")","v":{"v":1.3226917808219179,"d":"1.32"}},"m³"]
[{"$f":"VLOOKUP(\"Warmwaterproductie onafhankelijk van de ruimteverwarming\",Translations,LANG,FALSE)","v":"Production d'eau chaude indépendante du chauffage des locaux "},"Ú",{"$f":"VLOOKUP(\"Ja\",Translations,LANG,FALSE)","v":"Oui"},{"$nulls":3},{"$f":"VLOOKUP(\"Indicatief aantal opslagvaten (deelvolumes)\",Translations,LANG,FALSE)","v":"Nombre indicatif de réservoirs (volumes partiels)"},{"$f":"IF(Calculs!B36,LOOKUP(H13,ProfilHebdo,Nstock),\"\")","v":1}]
[{"$f":"VLOOKUP(\"Type warmwaterketel\",Translations,LANG,FALSE)","v":"Type d'appoint pour l'eau chaude"},"Ú",{"$f":"VLOOKUP(\"C-Ketel HR PLUS\",Translations,LANG,FALSE)","v":"C-Chaudière HR PLUS"},{"$nulls":3},{"$f":"VLOOKUP(\"Indicatieve benodigde oppervlakte \",Translations,LANG,FALSE)","v":"Surface d'encombrement des réservoirs "},{"$f":"IFERROR(IF(Calculs!B36,LOOKUP(H13,ProfilHebdo,SurfStock),LOOKUP(H13,ProfilHebdo,SurfStockmax)),\"\")","v":{"v":1.6,"d":"1.60"}},"m²"]
[{"$f":"VLOOKUP(\"Ogenblikkelijk warmwaterketelrendement volgens onderhoudsfiche\",Translations,LANG,FALSE)","v":"Rendement instantané de l'appoint selon fiche d'entretien"},null,{"v":90,"d":"90.0"},"%",null,null,{"$f":"VLOOKUP(\"Gemiddeld gewicht van de volle opslagvaten\",Translations,LANG,FALSE)","v":"Poids moyen de tous les réservoirs pleins"},{"$f":"IFERROR(IF(Calculs!B36,LOOKUP(H13,ProfilHebdo,Mstock),LOOKUP(H13,ProfilHebdo,Mstockmax)),\"\")","v":{"v":1700,"d":"1,700"}},"kg"]
["",{"$nulls":5},""]
[{"$f":"VLOOKUP(\"Warmwaterverbruik\",Translations,LANG,FALSE)","v":"Consommation d'eau chaude "},{"$nulls":5},{"$f":"VLOOKUP(\"Energiebalans\",Translations,LANG,FALSE)","v":"Bilan Energétique"}]
[{"$f":"VLOOKUP(\"Gemiddeld verbruik van warm water\",Translations,LANG,FALSE)","v":"Consommation moyenne d'eau chaude "},null,{"v":500,"d":"500.0"},{"$f":"\"m³/\" & VLOOKUP(\"jaar\",Translations,LANG,FALSE)","v":"m³/an"},null,null,{"$f":"VLOOKUP(\"Jaarlijkse netto zonneopbrengst\",Translations,LANG,FALSE)","v":"Production solaire annuelle nette"},{"$f":"IF(Calculs!B36,LOOKUP(H13,ProfilHebdo,Qsol),LOOKUP(H13,ProfilHebdo,Qsolmax))","v":{"v":9903.522178602929,"d":"9,904"}},{"$f":"VLOOKUP(\"kWh zonne-energie /jaar\",Translations,LANG,FALSE)","v":"kWh solaires /an"}]
[{"$f":"VLOOKUP(\"Warmwateropslag- of warmwaterproductietemperatuur\",Translations,LANG,FALSE)","v":"Température de stockage ou de production de l'eau chaude"},"Ú",60,"°C",null,null,{"$f":"VLOOKUP(\"Brandstofbesparinig\",Translations,LANG,FALSE)","v":"Combustible économisé "},{"$f":"IF(Calculs!B36,LOOKUP(H13,ProfilHebdo,CombEco),LOOKUP(H13,ProfilHebdo,CombEcomax))","v":{"v":13192.360500871684,"d":"13 192"}},{"$f":"'Tech Data'!J51","v":"kWh/an"}]
[{"$f":"VLOOKUP(\"Jaarlijks brandstofverbruik voor warm water\",Translations,LANG,FALSE)","v":"Consommation annuelle de combustible pour l'eau chaude "},null,{"v":25000,"d":"25,000"},{"$f":"IF(ISBLANK(C43),'Eco Data'!B5,LOOKUP(Calculs!B$17,SourceEnergie,UnitéConsoAn))","v":"kWh/an"},null,null,{"$f":"VLOOKUP(\"Primaire-energiebesparing\",Translations,LANG,FALSE)","v":"Energie primaire économisée"},{"$f":"IF(Calculs!B36,LOOKUP(H13,ProfilHebdo,EprimEco),LOOKUP(H13,ProfilHebdo,EprimEcomax))","v":{"v":12748.547093846051,"d":"12,749"}},{"$f":"VLOOKUP(\"kWh thermisch /jaar\",Translations,LANG,FALSE)","v":"kWh thermiques /an"}]
[{"$f":"VLOOKUP(\"Totaal jaarlijks brandstofverbruik voor verwarming\",Translations,LANG,FALSE)","v":"Consommation annuelle totale de combustible de chauffage"},null,{"v":50000,"d":"50,000"},{"$f":"\"kWh/\" & VLOOKUP(\"jaar\",Translations,LANG,FALSE)","v":"kWh/an"},"Ú",null,""]
[{"$f":"VLOOKUP(\"Aftapprofiel van warm water (A, B, C of D)\",Translations,LANG,FALSE)","v":"Profil de puisage de l'eau chaude (A;B;C ou D)"},"Ú",{"$f":"VLOOKUP(\"A-7 dagen op 7 gedurende het hele jaar\",Translations,LANG,FALSE)","v":"A-7 jours sur 7 toute l'année"},{"$nulls":3},{"$f":"VLOOKUP(\"Economische balans\",Translations,LANG,FALSE)","v":"Bilan Economique"}]
["",{"$nulls":5},{"$f":"VLOOKUP(\"Kost van het zonnethermisch systeem\",Translations,LANG,FALSE)","v":"Coût du système solaire"},{"$f":"IFERROR(IF(Calculs!B36,IF(H15=0,LOOKUP(H13,ProfilHebdo,InvBrutHTVA),LOOKUP(H13,ProfilHebdo,InvBrutTVAc)),IF(H15=0,LOOKUP(H13,ProfilHebdo,InvBrutHTVAmax),LOOKUP(H13,ProfilHebdo,InvBrutTVAcmax))),\"\")","v":{"v":37220.31391397327,"d":"37,220"}},{"$f":"LOOKUP($H$15,TVA,EURTVA)","v":"EUR TVAc"}]
[{"$f":"VLOOKUP(\"Projectfinanciering\",Translations,LANG,FALSE)","v":"Financement du projet"},{"$nulls":5},{"$f":"VLOOKUP(\"Operationele kosten per jaar\",Translations,LANG,FALSE)","v":"Coûts opérationnels par an"},{"$f":"IFERROR(IF(Calculs!B36,IF(H15=0,LOOKUP(H13,ProfilHebdo,CoutOp),LOOKUP(H13,ProfilHebdo,CoutOp)*1.21),IF(H15=0,LOOKUP(H13,ProfilHebdo,CoutOpmax),(LOOKUP(H13,ProfilHebdo,CoutOpmax)*1.21))),\"\")","v":{"v":104.09256240519998,"d":"104"}},"EUR TVAc"]
[{"$f":"VLOOKUP(\"Actualisatievoet\",Translations,LANG,FALSE)","v":"Taux d'actualisation"},null,5.5,{"$f":"VLOOKUP(\"% per jaar (exclusief inflatie)\",Translations,LANG,FALSE)","v":"% par an (hors inflation)"},null,null,{"$f":"VLOOKUP(\"Subsidies\",Translations,LANG,FALSE)","v":"Subsides"},{"$f":"IFERROR(H18*H54,\"\")","v":0},"EUR TVAc"]
[{"$f":"VLOOKUP(\"BTW percentage\",Translations,LANG,FALSE)","v":"Taux de TVA"},"Ú",{"v":0.21,"d":"21%"},{"$nulls":3},{"$f":"VLOOKUP(\"Netto investering na aftrek van subsidies\",Translations,LANG,FALSE)","v":"Investissement net après subsides"},{"$f":"IFERROR(H54-H56,\"\")","v":{"v":37220.31391397327,"d":"37,220"}},"EUR TVAc"]
["",{"$nulls":5},{"$f":"VLOOKUP(\"Netto investering na subsidies en belastingsvermindering\",Translations,LANG,FALSE)","v":"Investissement net après subsides & remise d'impôt"},{"$f":"IFERROR(IF(H57-Calculs!B31>0,H57-Calculs!B31,0),\"\")","v":{"v":37220.31391397327,"d":"37,220"}},"EUR TVAc"]
[{"$f":"VLOOKUP(\"Energiekosten\",Translations,LANG,FALSE)","v":"Coûts énergétiques"},{"$nulls":5},{"$f":"VLOOKUP(\"Besparing op de brandstoffactuur in jaar 1\",Translations,LANG,FALSE)","v":"Economie sur la facture de combustible à l'année 1 "},{"$f":"IF(Calculs!B36,H16*LOOKUP(H13,ProfilHebdo,CombEco),H16*LOOKUP(H13,ProfilHebdo,CombEcomax))","v":{"v":885.9329694360379,"d":"886"}},"EUR TVAc"]
[{"$f":"VLOOKUP(\"Factuurbedrag voor het jaarlijks globaal brandstofverbruik\",Translations,LANG,FALSE)","v":"Montant de la facture annuelle globale de combustible"},null,null,{"$f":"LOOKUP($H$15,TVA,EurAnTVA)","v":"EUR/an TVAc"},null,null,{"$f":"VLOOKUP(\"Kost per kWh voor de bespaarde brandstof zonder subsidies\",Translations,LANG,FALSE)","v":"Coût par kWh de combustible économisé hors subsides "},{"$f":"IFERROR(IF(Calculs!B36,IF(H15=0,LOOKUP(H13,ProfilHebdo,CoutCombEco),LOOKUP(H13,ProfilHebdo,CoutCombEcoTVAc)),IF(H15=0,LOOKUP(H13,ProfilHebdo,CoutCombEcoMax),LOOKUP(H13,ProfilHebdo,CoutCombEcoTVAcmax))),\"\")","v":{"v":0.08793464611433617,"d":"0.088"}},{"$f":"IF(H$15=0,'Tech Data'!O$51,'Tech Data'!P$51)","v":"EUR/kWh TVAc"}]
[{"$f":"VLOOKUP(\"Factuurbedrag voor het jaarlijks brandstofverbruik voor warm water\",Translations,LANG,FALSE)","v":"Montant de la facture annuelle de combustible pour l'eau chaude"},null,null,{"$f":"LOOKUP($H$15,TVA,EurAnTVA)","v":"EUR/an TVAc"},null,null,{"$f":"VLOOKUP(\"Kost per kWh voor de bespaarde brandstof na subsidies\",Translations,LANG,FALSE)","v":"Coût par kWh de combustible économisé après subsides"},{"$f":"IFERROR(IF(Calculs!B36,IF(H15=0,LOOKUP(H13,ProfilHebdo,CoutNetCombEco),LOOKUP(H13,ProfilHebdo,CoutNetCombEcoTVAc)),IF(H15=0,LOOKUP(H13,ProfilHebdo,CoutNetCombEcomax),LOOKUP(H13,ProfilHebdo,CoutNetCombEcoTVAcmax))),\"\")","v":{"v":0.08793464611433617,"d":"0.088"}},{"$f":"IF(H$15=0,'Tech Data'!O$51,'Tech Data'!P$51)","v":"EUR/kWh TVAc"}]
[{"$f":"VLOOKUP(\"Eenheidsprijs van de brandstof voor warmwaterproductie\",Translations,LANG,FALSE)","v":"Prix unitaire du combustible utilisé pour produire l'eau chaude"},null,null,{"$f":"IF(ISBLANK(C43),'Eco Data'!S5,IF(H15=0,LOOKUP(Calculs!B$17,SourceEnergie,UnitéPrixDéfaut),LOOKUP(Calculs!B$17,SourceEnergie,UnitéPrixDéfautTVAc)))","v":"EUR/kWh TVAc"},null,null,{"$f":"VLOOKUP(\"Eenvoudige terugverdientijd (na subsidies)\",Translations,LANG,FALSE)","v":"Temps de retour simple (après subsides)"},{"$f":"IFERROR(ROUNDDOWN(H$58/H$59,1),\"\")","v":{"v":42,"d":"42.0"}},{"$f":"VLOOKUP(\"Jaar\",Translations,LANG, FALSE)","v":"an"}]
["",{"$nulls":5},{"$f":"VLOOKUP(\"Netto Actuele Waarde (NAW)\",Translations,LANG,FALSE)","v":"Valeur Actualisée Nette"},{"$f":"'Financiële balans'!C15","v":{"v":-15429.572698053758,"d":"-15,430"}},"EUR"]
[{"$f":"VLOOKUP(\"Prijsstijging van de betreffende energiedrager\",Translations,LANG,FALSE)","v":"Augmentation du prix du vecteur énergétique considéré"},null,5.87,{"$f":"VLOOKUP(\"% per jaar (exclusief inflatie)\",Translations,LANG,FALSE)","v":"% par an (hors inflation)"},null,null,{"$f":"VLOOKUP(\"Interne Rentevoet (IRV)\",Translations,LANG,FALSE)","v":"Taux de rentabilité Interne (TRI)"},{"$f":"IFERROR('Financiële balans'!C16*100,\"\")","v":{"v":1.6288835482979769,"d":"1.6"}},"%"]
["",{"$nulls":5},""]
[{"$f":"VLOOKUP(\"Subsidies\",Translations,LANG,FALSE)","v":"Subsides"},{"$nulls":5},{"$f":"VLOOKUP(\"Ecologische balans\",Translations,LANG,FALSE)","v":"Bilan Environnemental"}]
[{"$f":"VLOOKUP(\"Totaal percentage aan subsidies voor de zonthermische investering\",Translations,LANG,FALSE)","v":"Pourcentage d'aide global à l'investissement solaire "},null,null,"% ",null,null,{"$f":"VLOOKUP(\"Jaarlijkse CO2-emissiebesparing\",Translations,LANG,FALSE)","v":"Émissions de CO2 évitées annuellement "},{"$f":"IF(Calculs!B36,LOOKUP(H13,ProfilHebdo,CO2Eco),LOOKUP(H13,ProfilHebdo,CO2Ecomax))","v":{"v":2.766434719364593,"d":"3"}},{"$f":"VLOOKUP(\"ton/jaar\",Translations,LANG, FALSE)","v":"tonnes/an"}]
[{"$f":"VLOOKUP(\"IPP vermindering voor energiebesparende investerigen\",Translations,LANG,FALSE)","v":"Réduction d'IPP pour investissement économiseur d'énergie"},null,null,"%",null,null,{"$f":"VLOOKUP(\"CO2-emissiebesparing op 25 jaar\",Translations,LANG,FALSE)","v":"Émissions de CO2 évitées sur 25 ans"},{"$f":"IF(Calculs!B36,LOOKUP(H13,ProfilHebdo,CO2EcoLT),LOOKUP(H13,ProfilHebdo,CO2EcoLTmax))","v":{"v":69.16086798411483,"d":"69"}},{"$f":"VLOOKUP(\"ton\",Translations,LANG, FALSE)","v":"tonne"}]
[{"$nulls":6},{"$f":"VLOOKUP(\"Kostprijs van een ton vermeden CO2-emissie (zonder subsidies)\",Translations,LANG,FALSE)","v":"Coût d'une tonne de CO2 évité (hors subsides)"},{"$f":"IFERROR(IF(Calculs!B36,LOOKUP(H13,ProfilHebdo,CoutCO2),LOOKUP(H13,ProfilHebdo,CoutCO2max)),\"\")","v":{"v":346.55864260706426,"d":"347"}},{"$f":"\"EUR/\" & VLOOKUP(\"ton\",Translations,LANG, FALSE)","v":"EUR/tonne"}]

{"sheet":"Translations","index":1,"n_rows":266,"n_cols":6,"rows_kept":266,"hidden":true}
["Paste this entry \"as value\" and recplace # with =","Key","NL","FR","EN","DE"]
[{"$f":"\"#VLOOKUP(\" & \"\"\"\" & B2 & \"\"\"\" & \";Translations;LANG;FALSE)\"","v":"#VLOOKUP(\"version\";Translations;LANG;FALSE)"},"version","Versie","Version"]
[{"$f":"\"#VLOOKUP(\" & \"\"\"\" & B3 & \"\"\"\" & \";Translations;LANG;FALSE)\"","v":"#VLOOKUP(\"title_tool\";Translations;LANG;FALSE)"},"title_tool","Quickscan voor de predimensionering van een groot zonthermisch systeem voor de productie van warm water","Outil de pré-dimensionnement d'un grand système solaire thermique de production d'eau chaude"]
[{"$f":"\"#VLOOKUP(\" & \"\"\"\" & B4 & \"\"\"\" & \";Translations;LANG;FALSE)\"","v":"#VLOOKUP(\"ALGEMENE INFORMATIE\";Translations;LANG;FALSE)"},{"$f":"C4","v":"ALGEMENE INFORMATIE"},"ALGEMENE INFORMATIE","INFORMATION GENERALES"]
[{"$f":"\"#VLOOKUP(\" & \"\"\"\" & B5 & \"\"\"\" & \";Translations;LANG;FALSE)\"","v":"#VLOOKUP(\"[Vestigingsnaam] :\";Translations;LANG;FALSE)"},{"$f":"C5","v":"[Vestigingsnaam] :"},"[Vestigingsnaam] :","[Nom Etablissement] :"]
["#VLOOKUP(\"[Sector] :\";Translations;LANG;FALSE)","[Sector] :","[Sector] :","[Secteur] :"]
["#VLOOKUP(\"[Adres] : \";Translations;LANG;FALSE)","[Adres] : ","[Adres] : ","[Adresse] : "]
["#VLOOKUP(\"[Gemeente] :\";Translations;LANG;FALSE)","[Gemeente] :","[Gemeente] :","[Localité] :"]
["#VLOOKUP(\"[Postcode] : \";Translations;LANG;FALSE)","[Postcode] : ","[Postcode] : ","[Code Postal] : "]
["#VLOOKUP(\"[Contactpersoon] :\";Translations;LANG;FALSE)","[Contactpersoon] :","[Contactpersoon] :","[Personne de contact] :"]
["#VLOOKUP(\"[Functie] :\";Translations;LANG;FALSE)","[Functie] :","[Functie] :","[Fonction] :"]
["#VLOOKUP(\"[Tel.]\";Translations;LANG;FALSE)","[Tel.]","[Tel.]","[Tel.]"]
["#VLOOKUP(\"[E-mail] :\";Translations;LANG;FALSE)","[E-mail] :","[E-mail] :","[E-mail] :"]
["#VLOOKUP(\"De Quickscan Zonthermische Energie is een tool die ontwikkeld is voor het Brussels Hoofdstedelijk Gewest en het Waals Gewest\";Translations;LANG;FALSE)","De Quickscan Zonthermische Energie is een tool die ontwikkeld is voor het Brussels Hoofdstedelijk Gewest en het Waals Gewest","De Quickscan Zonthermische Energie is een tool die ontwikkeld is voor het Brussels Hoofdstedelijk Gewest en het Waals Gewest","Le Quick Scan Solaire thermique est un outil développé pour la Région wallonne et la Région de Bruxelles-Capitale"]
["#VLOOKUP(\"Concept en ontwikkeling : 3E nv\";Translations;LANG;FALSE)","Concept en ontwikkeling : 3E nv","Concept en ontwikkeling : 3E nv","Conception & Développement : 3E s.a."]
["#VLOOKUP(\"Aanpassingen:\";Translations;LANG;FALSE)","Aanpassingen:","Aanpassingen:","Modifications:"]
["#VLOOKUP(\"Veld\";Translations;LANG;FALSE)","Veld","Veld","Champ"]
["#VLOOKUP(\"Verplicht\";Translations;LANG;FALSE)","Verplicht","Verplicht","Obligatoire"]
["#VLOOKUP(\"Facultatief\";Translations;LANG;FALSE)","Facultatief","Facultatief","Facultatif"]
["#VLOOKUP(\"Uitklaplijstje\";Translations;LANG;FALSE)","Uitklaplijstje","Uitklaplijstje","Menu Déroulant"]
["#VLOOKUP(\" (indien blanco, worden standaardwaarden gebruikt)\";Translations;LANG;FALSE)"," (indien blanco, worden standaardwaarden gebruikt)"," (indien blanco, worden standaardwaarden gebruikt)","(si pas rempli, les valeurs par défaut sont utilisés)"]
["#VLOOKUP(\"BASISGEGEVENS\";Translations;LANG;FALSE)","BASISGEGEVENS","BASISGEGEVENS","DONNEES DE BASE"]
[{"$f":"IF(B23 <> 0, \"#VLOOKUP(\" & \"\"\"\" & B23 & \"\"\"\" & \";Translations;LANG;FALSE)\",\"\")","v":"#VLOOKUP(\"Beschrijving van de vestiging\";Translations;LANG;FALSE)"},"Beschrijving van de vestiging","Beschrijving van de vestiging","Descriptif de l'établissement"]
[{"$f":"IF(B24 <> 0, \"#VLOOKUP(\" & \"\"\"\" & B24 & \"\"\"\" & \";Translations;LANG;FALSE)\",\"\")","v":"#VLOOKUP(\"Vestigingstype\";Translations;LANG;FALSE)"},"Vestigingstype","Vestigingstype","Type d'établissement"]
["#VLOOKUP(\"Bezetting\";Translations;LANG;FALSE)","Bezetting","Bezetting","Fréquentation"]
[{"$f":"IF(OR(B26<>0,LEN(B26)>0),\"#VLOOKUP(\"&\"\"\"\"&B26&\"\"\"\"&\";Translations;LANG;FALSE)\",\"\")","v":"#VLOOKUP(\"Aantal wooneenheden\";Translations;LANG;FALSE)"},"Aantal wooneenheden","Aantal wooneenheden","Nombre de logements"]
["#VLOOKUP(\"Jaarlijkse gemiddelde bezettingsgraad\";Translations;LANG;FALSE)","Jaarlijkse gemiddelde bezettingsgraad","Jaarlijkse gemiddelde bezettingsgraad","Taux d'occupation annuel moyen"]
["#VLOOKUP(\"Gebouwoppervlakte\";Translations;LANG;FALSE)","Gebouwoppervlakte","Gebouwoppervlakte","Surface du bâtiment"]
["#VLOOKUP(\"Daktype\";Translations;LANG;FALSE)","Daktype","Daktype","Toiture"]
["#VLOOKUP(\"Maximale nuttige dakoppervlakte\";Translations;LANG;FALSE)","Maximale nuttige dakoppervlakte","Maximale nuttige dakoppervlakte","Surface maximale utile de toiture "]
["#VLOOKUP(\"Dakoriëntatie\";Translations;LANG;FALSE)","Dakoriëntatie","Dakoriëntatie","Orientation de la toiture"]
["#VLOOKUP(\"Hellingsgraad van het dak\";Translations;LANG;FALSE)","Hellingsgraad van het dak","Hellingsgraad van het dak","Inclinaison de la toiture"]
["",0]
["#VLOOKUP(\"Warmwaterproductie\";Translations;LANG;FALSE)","Warmwaterproductie","Warmwaterproductie","Production d'eau chaude"]
["#VLOOKUP(\"Gebruikte energiedrager voor de warmwaterproductie\";Translations;LANG;FALSE)","Gebruikte energiedrager voor de warmwaterproductie","Gebruikte energiedrager voor de warmwaterproductie","Vecteur énergétique utilisé pour la production d'eau chaude"]
["#VLOOKUP(\"Warmwaterproductie onafhankelijk van de ruimteverwarming\";Translations;LANG;FALSE)","Warmwaterproductie onafhankelijk van de ruimteverwarming","Warmwaterproductie onafhankelijk van de ruimteverwarming","Production d'eau chaude indépendante du chauffage des locaux "]
["#VLOOKUP(\"Type warmwaterketel\";Translations;LANG;FALSE)","Type warmwaterketel","Type warmwaterketel","Type d'appoint pour l'eau chaude"]
["#VLOOKUP(\"Ogenblikkelijk warmwaterketelrendement volgens onderhoudsfiche\";Translations;LANG;FALSE)","Ogenblikkelijk warmwaterketelrendement volgens onderhoudsfiche","Ogenblikkelijk warmwaterketelrendement volgens onderhoudsfiche","Rendement instantané de l'appoint selon fiche d'entretien"]
["",0]
["#VLOOKUP(\"Warmwaterverbruik\";Translations;LANG;FALSE)","Warmwaterverbruik","Warmwaterverbruik","Consommation d'eau chaude "]
["#VLOOKUP(\"Gemiddeld verbruik van warm water\";Translations;LANG;FALSE)","Gemiddeld verbruik van warm water","Gemiddeld verbruik van warm water","Consommation moyenne d'eau chaude "]
["#VLOOKUP(\"Warmwateropslag- of warmwaterproductietemperatuur\";Translations;LANG;FALSE)","Warmwateropslag- of warmwaterproductietemperatuur","Warmwateropslag- of warmwaterproductietemperatuur","Température de stockage ou de production de l'eau chaude"]
["#VLOOKUP(\"Jaarlijks brandstofverbruik voor warm water\";Translations;LANG;FALSE)","Jaarlijks brandstofverbruik voor warm water","Jaarlijks brandstofverbruik voor warm water","Consommation annuelle de combustible pour l'eau chaude "]
["#VLOOKUP(\"Totaal jaarlijks brandstofverbruik voor verwarming\";Translations;LANG;FALSE)","Totaal jaarlijks brandstofverbruik voor verwarming","Totaal jaarlijks brandstofverbruik voor verwarming","Consommation annuelle totale de combustible de chauffage"]
["#VLOOKUP(\"Aftapprofiel van warm water (A, B, C of D)\";Translations;LANG;FALSE)","Aftapprofiel van warm water (A, B, C of D)","Aftapprofiel van warm water (A, B, C of D)","Profil de puisage de l'eau chaude (A;B;C ou D)"]
["",0]
["#VLOOKUP(\"Projectfinanciering\";Translations;LANG;FALSE)","Projectfinanciering","Projectfinanciering","Financement du projet"]
["#VLOOKUP(\"Actualisatievoet\";Translations;LANG;FALSE)","Actualisatievoet","Actualisatievoet","Taux d'actualisation"]
["#VLOOKUP(\"BTW percentage\";Translations;LANG;FALSE)","BTW percentage","BTW percentage","Taux de TVA"]
["",0]
["#VLOOKUP(\"Energiekosten\";Translations;LANG;FALSE)","Energiekosten","Energiekosten","Coûts énergétiques"]
["#VLOOKUP(\"Factuurbedrag voor het jaarlijks globaal brandstofverbruik\";Translations;LANG;FALSE)","Factuurbedrag voor het jaarlijks globaal brandstofverbruik","Factuurbedrag voor het jaarlijks globaal brandstofverbruik","Montant de la facture annuelle globale de combustible"]
["#VLOOKUP(\"Factuurbedrag voor het jaarlijks brandstofverbruik voor warm water\";Translations;LANG;FALSE)","Factuurbedrag voor het jaarlijks brandstofverbruik voor warm water","Factuurbedrag voor het jaarlijks brandstofverbruik voor warm water","Montant de la facture annuelle de combustible pour l'eau chaude"]
["#VLOOKUP(\"Eenheidsprijs van de brandstof voor warmwaterproductie\";Translations;LANG;FALSE)","Eenheidsprijs van de brandstof voor warmwaterproductie","Eenheidsprijs van de brandstof voor warmwaterproductie","Prix unitaire du combustible utilisé pour produire l'eau chaude"]
["",0]
["#VLOOKUP(\"Prijsstijging van de betreffende energiedrager\";Translations;LANG;FALSE)","Prijsstijging van de betreffende energiedrager","Prijsstijging van de betreffende energiedrager","Augmentation du prix du vecteur énergétique considéré"]
["",0]
["#VLOOKUP(\"Subsidies\";Translations;LANG;FALSE)","Subsidies","Subsidies","Subsides"]
["#VLOOKUP(\"Totaal percentage aan subsidies voor de zonthermische investering\";Translations;LANG;FALSE)","Totaal percentage aan subsidies voor de zonthermische investering","Totaal percentage aan subsidies voor de zonthermische investering","Pourcentage d'aide global à l'investissement solaire "]
["#VLOOKUP(\"IPP vermindering voor energiebesparende investerigen\";Translations;LANG;FALSE)","IPP vermindering voor energiebesparende investerigen","IPP vermindering voor energiebesparende investerigen","Réduction d'IPP pour investissement économiseur d'énergie"]
["#VLOOKUP(\"jaar\";Translations;LANG;FALSE)","jaar","jaar","an"]
["#VLOOKUP(\"jaren\";Translations;LANG;FALSE)","jaren","jaren","ans"]
["#VLOOKUP(\"EUR BTW excl\";Translations;LANG;FALSE)","EUR BTW excl","EUR BTW excl","EUR HTVA"]
["#VLOOKUP(\"EUR BTW incl\";Translations;LANG;FALSE)","EUR BTW incl","EUR BTW incl","EUR TVAc"]
["#VLOOKUP(\"EUR/jaar BTW excl\";Translations;LANG;FALSE)","EUR/jaar BTW excl","EUR/jaar BTW excl","EUR/an HTVA"]
["#VLOOKUP(\"EUR/jaar BTW incl\";Translations;LANG;FALSE)","EUR/jaar BTW incl","EUR/jaar BTW incl","EUR/an TVAc"]
["#VLOOKUP(\"litre\";Translations;LANG;FALSE)",{"$f":"C67","v":"litre"},"litre","litre"]
["#VLOOKUP(\"EUR/liter\";Translations;LANG;FALSE)","EUR/liter","EUR/liter","EUR/litre"]
["#VLOOKUP(\"EUR/kWh BTW excl\";Translations;LANG;FALSE)","EUR/kWh BTW excl","EUR/kWh BTW excl","EUR/kWh HTVA"]
["#VLOOKUP(\"EUR/ton BTW excl\";Translations;LANG;FALSE)","EUR/ton BTW excl","EUR/ton BTW excl","EUR/tonne HTVA"]
["#VLOOKUP(\"EUR/liter BTW excl\";Translations;LANG;FALSE)","EUR/liter BTW excl","EUR/liter BTW excl","EUR/litre HTVA"]
["#VLOOKUP(\"EUR/kWh BTW incl\";Translations;LANG;FALSE)","EUR/kWh BTW incl","EUR/kWh BTW incl","EUR/kWh TVAc"]
["#VLOOKUP(\"EUR/ton BTW incl\";Translations;LANG;FALSE)","EUR/ton BTW incl","EUR/ton BTW incl","EUR/tonne TVAc"]
["#VLOOKUP(\"EUR/liter BTW incl\";Translations;LANG;FALSE)","EUR/liter BTW incl","EUR/liter BTW incl","EUR/litre TVAc"]
["#VLOOKUP(\"kWh/jaar\";Translations;LANG;FALSE)","kWh/jaar","kWh/jaar","kWh/an"]
["#VLOOKUP(\"ton/jaar\";Translations;LANG;FALSE)","ton/jaar","ton/jaar","tonnes/an"]
[{"$f":"IF(B77 <> 0, \"#VLOOKUP(\" & \"\"\"\" & B77 & \"\"\"\" & \";Translations;LANG;FALSE)\",\"\")","v":"#VLOOKUP(\"l stookolie/jaar\";Translations;LANG;FALSE)"},"l stookolie/jaar","l stookolie/jaar","l mazout/an"]
["#VLOOKUP(\"1-Elektriciteit (BHG)\";Translations;LANG;FALSE)","1-Elektriciteit (BHG)","1-Elektriciteit (BHG)","1-Electricité (RBC)"]
["#VLOOKUP(\"2-Electriciteit (WG)\";Translations;LANG;FALSE)","2-Electriciteit (WG)","2-Electriciteit (WG)","2-Electricité (RW)"]
["#VLOOKUP(\"3-Aardgas (BHG)\";Translations;LANG;FALSE)","3-Aardgas (BHG)","3-Aardgas (BHG)","3-Gaz naturel (RBC)"]
["#VLOOKUP(\"4-Aardgas (WG)\";Translations;LANG;FALSE)","4-Aardgas (WG)","4-Aardgas (WG)","4-Gaz naturel (RW)"]
["#VLOOKUP(\"5-Houtpellets\";Translations;LANG;FALSE)","5-Houtpellets","5-Houtpellets","5-Granulés de bois "]
["#VLOOKUP(\"6-Stookolie\";Translations;LANG;FALSE)","6-Stookolie","6-Stookolie","6-Mazout"]
["#VLOOKUP(\"A-Centra voor gehandicapten, IMS, IMP\";Translations;LANG;FALSE)","A-Centra voor gehandicapten, IMS, IMP","A-Centra voor gehandicapten, IMS, IMP","A-Centre pour handicapés, IMS, IMP, "]
["#VLOOKUP(\"B-Hospitalen, klinieken\";Translations;LANG;FALSE)","B-Hospitalen, klinieken","B-Hospitalen, klinieken","B-Hôpital, clinique"]
["#VLOOKUP(\"C-Rust- en verzorgingstehuizen\";Translations;LANG;FALSE)","C-Rust- en verzorgingstehuizen","C-Rust- en verzorgingstehuizen","C-Maison de repos et de soins"]
["#VLOOKUP(\"D-Strafinrichtingen\";Translations;LANG;FALSE)","D-Strafinrichtingen","D-Strafinrichtingen","D-Etablissement pénitentiaire"]
["#VLOOKUP(\"E-Serviceflats\";Translations;LANG;FALSE)","E-Serviceflats","E-Serviceflats","E-Appart hotel, Flat hotel"]
["#VLOOKUP(\"F-Hotels, motels, jeugdherbergen, pensions\";Translations;LANG;FALSE)","F-Hotels, motels, jeugdherbergen, pensions","F-Hotels, motels, jeugdherbergen, pensions","F-Hôtel, motel, auberge, pension"]
["#VLOOKUP(\"G-Gebouw van 4 tot 15 appartementen\";Translations;LANG;FALSE)","G-Gebouw van 4 tot 15 appartementen","G-Gebouw van 4 tot 15 appartementen","G-Logement de 4 à 15 appartements"]
["#VLOOKUP(\"H-Rusthuizen\";Translations;LANG;FALSE)","H-Rusthuizen","H-Rusthuizen","H-Maison de repos"]
["#VLOOKUP(\"I-Gebouw van meer dan 15 appartementen\";Translations;LANG;FALSE)","I-Gebouw van meer dan 15 appartementen","I-Gebouw van meer dan 15 appartementen","I-Logement de plus de 15 appartements"]
["#VLOOKUP(\"J-Internaten\";Translations;LANG;FALSE)","J-Internaten","J-Internaten","J-Internat"]
["#VLOOKUP(\"K-Sociale huisvesting\";Translations;LANG;FALSE)","K-Sociale huisvesting","K-Sociale huisvesting","K-Logement social"]
["#VLOOKUP(\"L-Onthaalcentra\";Translations;LANG;FALSE)","L-Onthaalcentra","L-Onthaalcentra","L-Centres d'accueil"]
["#VLOOKUP(\"M-Kapsalons\";Translations;LANG;FALSE)","M-Kapsalons","M-Kapsalons","M-Salons de coiffure"]
["#VLOOKUP(\"N-Poliklinieken en daghospitalen\";Translations;LANG;FALSE)","N-Poliklinieken en daghospitalen","N-Poliklinieken en daghospitalen","N-Polyclinique, hôpital de jour"]
["#VLOOKUP(\"O-Sportcentra, sporthallen, fitness\";Translations;LANG;FALSE)","O-Sportcentra, sporthallen, fitness","O-Sportcentra, sporthallen, fitness","O-Centre sportif, hall des sports, fitness"]
["#VLOOKUP(\"P-Restaurants\";Translations;LANG;FALSE)","P-Restaurants","P-Restaurants","P-Restaurants"]
["#VLOOKUP(\"Q-Crêches\";Translations;LANG;FALSE)","Q-Crêches","Q-Crêches","Q-Crêche"]
["#VLOOKUP(\"R-Zorgcentra, medisch-sociale hulpcentra of mentale zorgcentra\";Translations;LANG;FALSE)","R-Zorgcentra, medisch-sociale hulpcentra of mentale zorgcentra","R-Zorgcentra, medisch-sociale hulpcentra of mentale zorgcentra","R-Centre de soins, aide médico-sociale, santé mentale"]
["#VLOOKUP(\"S-Administraties\";Translations;LANG;FALSE)","S-Administraties","S-Administraties","S-Administration"]
["#VLOOKUP(\"T-Kantoren\";Translations;LANG;FALSE)","T-Kantoren","T-Kantoren","T-Bureau d'entreprise"]
["#VLOOKUP(\"U-CLB-centra\";Translations;LANG;FALSE)","U-CLB-centra","U-CLB-centra","U-Centre PMS"]
["#VLOOKUP(\"V-Scholen en universiteiten\";Translations;LANG;FALSE)","V-Scholen en universiteiten","V-Scholen en universiteiten","V-Ecole, Université"]
["#VLOOKUP(\"X-Andere soorten vestigingen\";Translations;LANG;FALSE)","X-Andere soorten vestigingen","X-Andere soorten vestigingen","X-Autre type d'établissement"]
["#VLOOKUP(\"Bedden\";Translations;LANG;FALSE)","Bedden","Bedden","Lits"]
["#VLOOKUP(\"Bedden\";Translations;LANG;FALSE)","Bedden","Bedden","Lits"]
["#VLOOKUP(\"Bedden\";Translations;LANG;FALSE)","Bedden","Bedden","Lits"]
["#VLOOKUP(\"Gedetineerden\";Translations;LANG;FALSE)","Gedetineerden","Gedetineerden","Pensionnaires"]
["#VLOOKUP(\"Bewoners\";Translations;LANG;FALSE)","Bewoners","Bewoners","Occupants"]
["#VLOOKUP(\"Bewoners\";Translations;LANG;FALSE)","Bewoners","Bewoners","Occupants"]
["#VLOOKUP(\"Bewoners\";Translations;LANG;FALSE)","Bewoners","Bewoners","Occupants"]
["#VLOOKUP(\"Bedden\";Translations;LANG;FALSE)","Bedden","Bedden","Lits"]
["#VLOOKUP(\"Bewoners\";Translations;LANG;FALSE)","Bewoners","Bewoners","Occupants"]
["#VLOOKUP(\"Bedden\";Translations;LANG;FALSE)","Bedden","Bedden","Lits"]
["#VLOOKUP(\"Bewoners\";Translations;LANG;FALSE)","Bewoners","Bewoners","Occupants"]
["#VLOOKUP(\"Bewoners + personeelsleden\";Translations;LANG;FALSE)","Bewoners + personeelsleden","Bewoners + personeelsleden","Occupants + membres du personnel"]
["#VLOOKUP(\"Klanten per dag\";Translations;LANG;FALSE)","Klanten per dag","Klanten per dag","Clients par jour"]
["#VLOOKUP(\"Bewoners + personeelsleden\";Translations;LANG;FALSE)","Bewoners + personeelsleden","Bewoners + personeelsleden","Occupants + membres du personnel"]
["#VLOOKUP(\"Sporters per dag\";Translations;LANG;FALSE)","Sporters per dag","Sporters per dag","Sportifs par jour"]
["#VLOOKUP(\"Klanten per dag\";Translations;LANG;FALSE)",{"$f":"C122","v":"Klanten per dag"},"Klanten per dag","Clients par jour"]
["#VLOOKUP(\"Kinderen\";Translations;LANG;FALSE)","Kinderen","Kinderen","Enfants"]
["#VLOOKUP(\"Bewoners + personeelsleden\";Translations;LANG;FALSE)","Bewoners + personeelsleden","Bewoners + personeelsleden","Occupants + membres du personnel"]
["#VLOOKUP(\"Bedienden\";Translations;LANG;FALSE)","Bedienden","Bedienden","Employés"]
["#VLOOKUP(\"Bedienden\";Translations;LANG;FALSE)","Bedienden","Bedienden","Employés"]
["#VLOOKUP(\"Bewoners + personeelsleden\";Translations;LANG;FALSE)","Bewoners + personeelsleden","Bewoners + personeelsleden","Occupants + membres du personnel"]
["#VLOOKUP(\"Studenten\";Translations;LANG;FALSE)","Studenten","Studenten","Etudiants"]
["#VLOOKUP(\"Bewoners\";Translations;LANG;FALSE)","Bewoners","Bewoners","Occupants"]
["#VLOOKUP(\"Wooneenheden\";Translations;LANG;FALSE)","Wooneenheden","Wooneenheden","Logements"]
["#VLOOKUP(\"woontypes_verplicht\";Translations;LANG;FALSE)","woontypes_verplicht","Verplicht veld. Als de vestiging niet overeenkomt met één van de voorgestelde types, gebruik 'ander vestigingstype'.","Champ obligatoire. \nSi l'établissement ne correspond à aucun des types proposés, utiliser 'autre établissement'"]
["#VLOOKUP(\"Enkel voor appartementsgebouwen\";Translations;LANG;FALSE)","Enkel voor appartementsgebouwen","Enkel voor appartementsgebouwen","Uniquement pour les immeubles à appartements"]
["#VLOOKUP(\"De standaard gebruikte bezettingsgraad is 100%\";Translations;LANG;FALSE)","De standaard gebruikte bezettingsgraad is 100%","De standaard gebruikte bezettingsgraad is 100%","Le taux d'occupation utilisé par défaut est de 100%"]
["#VLOOKUP(\"Vloeroppervlakte inclusief buitenmuren\";Translations;LANG;FALSE)","Vloeroppervlakte inclusief buitenmuren","Vloeroppervlakte inclusief buitenmuren","Surface de plancher, murs extérieurs inclus"]
["#VLOOKUP(\"De daken met een helling tussen 0 en 10° dienen als platte daken beschouwd te worden\";Translations;LANG;FALSE)","De daken met een helling tussen 0 en 10° dienen als platte daken beschouwd te worden","De daken met een helling tussen 0 en 10° dienen als platte daken beschouwd te worden","Les toitures présentant une inclinaison comprise entre 0 et 10° sont assimilées à des toitures plates."]
["#VLOOKUP(\"Vul dit veld in als de nuttige dakoppervlakte (zonder schaduw of obstakels) kleiner is dan 90% van de nodige optimale dakoppervlakte.\";Translations;LANG;FALSE)","Vul dit veld in als de nuttige dakoppervlakte (zonder schaduw of obstakels) kleiner is dan 90% van de nodige optimale dakoppervlakte.","Vul dit veld in als de nuttige dakoppervlakte (zonder schaduw of obstakels) kleiner is dan 90% van de nodige optimale dakoppervlakte.","A remplir si la surface de toiture utile (sans obstacles ni ombrage) est inférieure à 90% de la surface de toiture nécessaire à l'optimum "]
["#VLOOKUP(\"Indien hellend dak : oriëntatie van de helling die het best is blootgesteld aan het zuiden.\nIndien plat dak : oriëntatie van de gevel die het best naar het zuiden gericht is.\nDe standaard oriëntatie is pal in het zuiden.\";Translations;LANG;FALSE)","Indien hellend dak : oriëntatie van de helling die het best is blootgesteld aan het zuiden.\nIndien plat dak : oriëntatie van de gevel die het best naar het zuiden gericht is.\nDe standaard oriëntatie is pal in het zuiden.","Indien hellend dak : oriëntatie van de helling die het best is blootgesteld aan het zuiden.\nIndien plat dak : oriëntatie van de gevel die het best naar het zuiden gericht is.\nDe standaard oriëntatie is pal in het zuiden.","Si \"Toiture inclinée\" : orientation du pan le mieux exposé.\nSi \"Toiture plate\" : orientation de la façade la plus proche du Sud.\nL'orientation utilisée par défaut est plein Sud."]
["#VLOOKUP(\"hell_plat\";Translations;LANG;FALSE)","hell_plat","Hellende daken met een helling van 0 tot 10° worden als platte daken beschouwd.\nIndien \"Plat dak\" wordt dit gegeven niet verder gebruikt.","Les toitures présentant une inclinaison comprise entre 0 et 10° sont assimilées à des toitures plates.\nSi \"Toiture plate\" cette donnée n'est pas prise en considération."]
["#VLOOKUP(\"Kies de energiedrager in de correcte regio:\nBHG: Brussels Hoofdstedelijk Gewest\nWG: Waals Gewest\";Translations;LANG;FALSE)","Kies de energiedrager in de correcte regio:\nBHG: Brussels Hoofdstedelijk Gewest\nWG: Waals Gewest","Kies de energiedrager in de correcte regio:\nBHG: Brussels Hoofdstedelijk Gewest\nWG: Waals Gewest","Sélectionner le vecteur énergétique et la Région.\nRBC : Région de Bruxelles-Capitale\nRW : Région wallonne"]
["#VLOOKUP(\"Het warmwaterverbruik moet begrepen zijn tussen 300 en 20.000 m³/jaar (equivalent aan 1 à 50 m³/dag) \";Translations;LANG;FALSE)","Het warmwaterverbruik moet begrepen zijn tussen 300 en 20.000 m³/jaar (equivalent aan 1 à 50 m³/dag) ","Het warmwaterverbruik moet begrepen zijn tussen 300 en 20.000 m³/jaar (equivalent aan 1 à 50 m³/dag) ","La consommation d'eau chaude doit être comprise entre 300 et 20.000 m³/an (l'équivalent de 1 à 50 m³/j) "]
[{"$f":"IF(B141 <> 0, \"#VLOOKUP(\" & \"\"\"\" & B141 & \"\"\"\" & \";Translations;LANG;FALSE)\",\"\")","v":"#VLOOKUP(\"Duid de temperatuur van warmwateropslag of -productie aan. De standaard beschouwde waarde is 60°C.\";Translations;LANG;FALSE)"},"Duid de temperatuur van warmwateropslag of -productie aan. De standaard beschouwde waarde is 60°C.","Duid de temperatuur van warmwateropslag of -productie aan. De standaard beschouwde waarde is 60°C.","Indiquez la température de stockage ou de production de l'eau chaude.  température considérée par défaut : 60°C"]
["#VLOOKUP(\"Scenario voor BHG volgens EPB\";Translations;LANG;FALSE)","Scenario voor BHG volgens EPB","Scenario voor BHG volgens EPB","Scénario pour PEB RBC"]
["#VLOOKUP(\"De gekozen actualisatievoet reflecteert de interestvoet op kapitaal in de huidige markt. De standaard gekozen actualisatievoet bedraagt 5,5%.\";Translations;LANG;FALSE)","De gekozen actualisatievoet reflecteert de interestvoet op kapitaal in de huidige markt. De standaard gekozen actualisatievoet bedraagt 5,5%.","De gekozen actualisatievoet reflecteert de interestvoet op kapitaal in de huidige markt. De standaard gekozen actualisatievoet bedraagt 5,5%.","Le taux généralement choisi reflète le coût du capital et prend en compte le taux d'intérêt du marché pour une durée comparable.  Taux d'actualisation par défaut : 5,5%"]
["#VLOOKUP(\"Hellend dak\";Translations;LANG;FALSE)","Hellend dak","Hellend dak","Toiture inclinée"]
["#VLOOKUP(\"Plat dak\";Translations;LANG;FALSE)","Plat dak","Plat dak","Toiture plate"]
["#VLOOKUP(\"1-Oost\";Translations;LANG;FALSE)","1-Oost","1-Oost","1-Est"]
["#VLOOKUP(\"3-Oost zuidoost\";Translations;LANG;FALSE)","3-Oost zuidoost","3-Oost zuidoost","2-Est Sud Est"]
["#VLOOKUP(\"4-West\";Translations;LANG;FALSE)","4-West","4-West","3-Ouest "]
["#VLOOKUP(\"5-West zuidwest\";Translations;LANG;FALSE)","5-West zuidwest","5-West zuidwest","4-Ouest Sud Ouest"]
["#VLOOKUP(\"6-Zuid\";Translations;LANG;FALSE)","6-Zuid","6-Zuid","5-Sud"]
["#VLOOKUP(\"7-Zuidoost\";Translations;LANG;FALSE)","7-Zuidoost","7-Zuidoost","6-Sud Est"]
["#VLOOKUP(\"8-Zuidwest\";Translations;LANG;FALSE)","8-Zuidwest","8-Zuidwest","7-Sud Ouest"]
["#VLOOKUP(\"9-Zuid zuidoost\";Translations;LANG;FALSE)","9-Zuid zuidoost","9-Zuid zuidoost","8-Sud Sud Est"]
["#VLOOKUP(\"10-Zuid zuidwest\";Translations;LANG;FALSE)","10-Zuid zuidwest","10-Zuid zuidwest","9-Sud Sud Ouest "]
["#VLOOKUP(\"A-Atmosferische ketel op aardgas\";Translations;LANG;FALSE)","A-Atmosferische ketel op aardgas","A-Atmosferische ketel op aardgas","A-Chaudière atmosphérique au gaz"]
["#VLOOKUP(\"B-Atmosferische ketel op stookolie\";Translations;LANG;FALSE)","B-Atmosferische ketel op stookolie","B-Atmosferische ketel op stookolie","B-Chaudière atmosphérique au mazout"]
["#VLOOKUP(\"C-Ketel HR PLUS\";Translations;LANG;FALSE)","C-Ketel HR PLUS","C-Ketel HR PLUS","C-Chaudière HR PLUS"]
["#VLOOKUP(\"D-Ketel HR TOP (condensatie)\";Translations;LANG;FALSE)","D-Ketel HR TOP (condensatie)","D-Ketel HR TOP (condensatie)","D-Chaudière HR TOP (condensation)"]
["#VLOOKUP(\"E-OPTIMAZ-ketel van na 1999\";Translations;LANG;FALSE)","E-OPTIMAZ-ketel van na 1999","E-OPTIMAZ-ketel van na 1999","E-Chaudière OPTIMAZ d'après 1999"]
["#VLOOKUP(\"F-OPTIMAZ-ketel van vóór 1999\";Translations;LANG;FALSE)","F-OPTIMAZ-ketel van vóór 1999","F-OPTIMAZ-ketel van vóór 1999","F-Chaudière OPTIMAZ d'avant 1999"]
["#VLOOKUP(\"G-OPTIMAZ-ketel elite (condensatie)\";Translations;LANG;FALSE)","G-OPTIMAZ-ketel elite (condensatie)","G-OPTIMAZ-ketel elite (condensatie)","G-Chaudière OPTIMAZ élite (condensation)"]
["#VLOOKUP(\"H-Pelletketel van minder dan 10 jaar oud\";Translations;LANG;FALSE)","H-Pelletketel van minder dan 10 jaar oud","H-Pelletketel van minder dan 10 jaar oud","H-Chaudière pellets de moins de 10 ans"]
["#VLOOKUP(\"I-Pelletketel van meer dan 10 jaar oud\";Translations;LANG;FALSE)","I-Pelletketel van meer dan 10 jaar oud","I-Pelletketel van meer dan 10 jaar oud","I-Chaudière pellets de plus de 10 ans"]
["#VLOOKUP(\"J-Elektrische weerstand\";Translations;LANG;FALSE)","J-Elektrische weerstand","J-Elektrische weerstand","J-Résistance électrique"]
["#VLOOKUP(\"A-7 dagen op 7 gedurende het hele jaar\";Translations;LANG;FALSE)","A-7 dagen op 7 gedurende het hele jaar","A-7 dagen op 7 gedurende het hele jaar","A-7 jours sur 7 toute l'année"]
["#VLOOKUP(\"B-5 dagen op 7 gedurende het hele jaar\";Translations;LANG;FALSE)","B-5 dagen op 7 gedurende het hele jaar","B-5 dagen op 7 gedurende het hele jaar","B-5 jours sur 7 toute l'année"]
["#VLOOKUP(\"C-5 dagen op 7 uitgezonderd schoolvakanties\";Translations;LANG;FALSE)","C-5 dagen op 7 uitgezonderd schoolvakanties","C-5 dagen op 7 uitgezonderd schoolvakanties","C-5 jours sur 7 hors vacances scolaires"]
["#VLOOKUP(\"D-7 dagen op 7 uitgezonderd schoolvakanties\";Translations;LANG;FALSE)","D-7 dagen op 7 uitgezonderd schoolvakanties","D-7 dagen op 7 uitgezonderd schoolvakanties","D-7 jours sur 7 hors vacances scolaires"]
["#VLOOKUP(\"Privaat\";Translations;LANG;FALSE)","Privaat","Privaat","Privé"]
["#VLOOKUP(\"Publiek\";Translations;LANG;FALSE)","Publiek","Publiek","Public"]
["#VLOOKUP(\"Nee\";Translations;LANG;FALSE)","Nee","Nee","Non"]
["#VLOOKUP(\"Ja\";Translations;LANG;FALSE)","Ja","Ja","Oui"]
["#VLOOKUP(\"Als u BTW recupereert, kies dan voor 0%. Alle berekeningen zullen dan uitgevoerd worden zonder BTW.\";Translations;LANG;FALSE)","Als u BTW recupereert, kies dan voor 0%. Alle berekeningen zullen dan uitgevoerd worden zonder BTW.","Als u BTW recupereert, kies dan voor 0%. Alle berekeningen zullen dan uitgevoerd worden zonder BTW.","Si vous récupérez la TVA cliquez sur 0%. Tous les calculs seront hors TVA."]
["#VLOOKUP(\"% per jaar (exclusief inflatie)\";Translations;LANG;FALSE)","% per jaar (exclusief inflatie)","% per jaar (exclusief inflatie)","% par an (hors inflation)"]
["#VLOOKUP(\"Het standaard gebruikte subsidie-percentage is 0%. In het BHG\nkunnen bepaalde bedrijven naast de energiepremie ook aanspraak maken op \n- een fiscale korting \n- een subsidie van het BHG  (25%, 35%, 45%) NIET CUMULEERBAAR met energiepremies\";Translations;LANG;FALSE)","Het standaard gebruikte subsidie-percentage is 0%. In het BHG\nkunnen bepaalde bedrijven naast de energiepremie ook aanspraak maken op \n- een fiscale korting \n- een subsidie van het BHG  (25%, 35%, 45%) NIET CUMULEERBAAR met energiepremies","Het standaard gebruikte subsidie-percentage is 0%. In het BHG\nkunnen bepaalde bedrijven naast de energiepremie ook aanspraak maken op \n- een fiscale korting \n- een subsidie van het BHG  (25%, 35%, 45%) NIET CUMULEERBAAR met energiepremies","Le niveau d'aide par défaut est de 0%. Outre les primes Energie, en RBC certaines catégories d'entreprises ont droit:\n- aux aides régionales (T)PE - 45% ; ME -35% ; GE -25% ) NON CUMULABLES avec la prime Energie\n- à une déduction fiscale pour inv. EE"]
["#VLOOKUP(\"De belastingvermindering (voor appartementsgebouwen) werd afgeschaft op 31/12/2011\nDe standaardwaarde die gehanteerd wordt, is 0%.\";Translations;LANG;FALSE)","De belastingvermindering (voor appartementsgebouwen) werd afgeschaft op 31/12/2011\nDe standaardwaarde die gehanteerd wordt, is 0%.","De belastingvermindering (voor appartementsgebouwen) werd afgeschaft op 31/12/2011\nDe standaardwaarde die gehanteerd wordt, is 0%.","la Réduction d'Impôts Pour Personne physique (limitée aux immeubles à appartements) est supprimée depuis le 31/12/2011. \nLa valeur utilisée par défaut est de 0%"]
["#VLOOKUP(\"BEREKENINGSHYPOTHESEN\";Translations;LANG;FALSE)","BEREKENINGSHYPOTHESEN","BEREKENINGSHYPOTHESEN","HYPOTHESES DE CALCUL"]
["#VLOOKUP(\"Gebruikte energiedrager voor de warmwaterproductie\";Translations;LANG;FALSE)","Gebruikte energiedrager voor de warmwaterproductie","Gebruikte energiedrager voor de warmwaterproductie","Vecteur énergétique utilisé pour la production d'eau chaude"]
["#VLOOKUP(\"Warmwaterketelrendement\";Translations;LANG;FALSE)","Warmwaterketelrendement","Warmwaterketelrendement","Rendement utile de production d'eau chaude par l'appoint"]
["",0]
["#VLOOKUP(\"Referentiewarmwaterverbruik\";Translations;LANG;FALSE)","Referentiewarmwaterverbruik","Referentiewarmwaterverbruik","Consommation d'eau chaude de référence"]
[{"$error":"#REF!"},{"$error":"#REF!"},{"$f":"IF(OR(ISBLANK(#REF!),#REF!=0),\"\",\"Warmwaterverbruik ingevuld door de gebruiker\")","v":{"$error":"#REF!"}},""]
["#VLOOKUP(\"Gelijkwaardige warmwaterverbruik per dag\";Translations;LANG;FALSE)","Gelijkwaardige warmwaterverbruik per dag","Gelijkwaardige warmwaterverbruik per dag","Consommation d'eau chaude en équivalent journalier  "]
["#VLOOKUP(\"Profiel van het warmwaterverbruik\";Translations;LANG;FALSE)","Profiel van het warmwaterverbruik","Profiel van het warmwaterverbruik","Profil de puisage de l'eau chaude"]
["#VLOOKUP(\"Actualisatievoet\";Translations;LANG;FALSE)","Actualisatievoet","Actualisatievoet","Taux d'actualisation "]
["#VLOOKUP(\"BTW-percentage voor de economische balans\";Translations;LANG;FALSE)",{"$f":"C186","v":"BTW-percentage voor de economische balans"},"BTW-percentage voor de economische balans","Taux de TVA pour le bilan économique"]
["#VLOOKUP(\"Eenheidsprijs van de brandstof\";Translations;LANG;FALSE)","Eenheidsprijs van de brandstof","Eenheidsprijs van de brandstof","Prix unitaire du combustible"]
["#VLOOKUP(\"Brandstofprijs per kWh\";Translations;LANG;FALSE)","Brandstofprijs per kWh","Brandstofprijs per kWh","Prix par kWh de combustible"]
["#VLOOKUP(\"Subsidiepercentage gebruikt voor de berekening\";Translations;LANG;FALSE)","Subsidiepercentage gebruikt voor de berekening","Subsidiepercentage gebruikt voor de berekening","Taux de subside utilisé pour le calcul"]
["#VLOOKUP(\"Indicatief subsidiepercentage (Energiepremie) voor het beschouwde systeem\";Translations;LANG;FALSE)","Indicatief subsidiepercentage (Energiepremie) voor het beschouwde systeem","Indicatief subsidiepercentage (Energiepremie) voor het beschouwde systeem","Taux de subside (Prime Energie) indicatif en RBC pour le système considéré"]
["#VLOOKUP(\"Korting op de persoonsbelasting voor een energiebesparende investering\";Translations;LANG;FALSE)","Korting op de persoonsbelasting voor een energiebesparende investering","Korting op de persoonsbelasting voor een energiebesparende investering","Réduction d'IPP pour investissement économiseur d'énergie"]
["#VLOOKUP(\"Jaarlijkse prijsstijging van de energiedrager\";Translations;LANG;FALSE)","Jaarlijkse prijsstijging van de energiedrager","Jaarlijkse prijsstijging van de energiedrager","Augmentation annuelle du prix du vecteur énergétique"]
["#VLOOKUP(\"Onderhoudskost van de installatie als percentage van de investering\";Translations;LANG;FALSE)","Onderhoudskost van de installatie als percentage van de investering","Onderhoudskost van de installatie als percentage van de investering","Pourcentage de l'investissement affecté à la maintenance de l'installation"]
["#VLOOKUP(\"Zonnepanelen\";Translations;LANG;FALSE)","Zonnepanelen","Zonnepanelen","Capteurs solaires"]
["#VLOOKUP(\"Oriëntatie van de panelen gebruikt in de berekening\";Translations;LANG;FALSE)","Oriëntatie van de panelen gebruikt in de berekening","Oriëntatie van de panelen gebruikt in de berekening","Orientation des capteurs utilisée pour le calcul"]
["#VLOOKUP(\"Hellingsgraad van de panelen gebruikt in de berekening\";Translations;LANG;FALSE)","Hellingsgraad van de panelen gebruikt in de berekening","Hellingsgraad van de panelen gebruikt in de berekening","Inclinaison des capteurs utilisée pour le calcul"]
["#VLOOKUP(\"Correctiefactor\";Translations;LANG;FALSE)","Correctiefactor","Correctiefactor","Facteur Correctif"]
["#VLOOKUP(\"Economische levensduur van de installatie\";Translations;LANG;FALSE)","Economische levensduur van de installatie","Economische levensduur van de installatie","Durée de vie économique de l'installation"]
["#VLOOKUP(\"Vlakkeplaatcollectoren\";Translations;LANG;FALSE)","Vlakkeplaatcollectoren","Vlakkeplaatcollectoren","Atmosphériques plans vitrés"]
["#VLOOKUP(\"m³/dag op 60°C\";Translations;LANG;FALSE)","m³/dag op 60°C","m³/dag op 60°C","m³/jour à 60°C"]
["#VLOOKUP(\"RESULTATEN\";Translations;LANG;FALSE)","RESULTATEN","RESULTATEN","RESULTATS"]
["#VLOOKUP(\"Zonnefractie\";Translations;LANG;FALSE)","Zonnefractie","Zonnefractie","Fraction solaire"]
["#VLOOKUP(\"Optimale nuttige zonnefractie\";Translations;LANG;FALSE)","Optimale nuttige zonnefractie","Optimale nuttige zonnefractie","Fraction solaire utile à l'optimum"]
["#VLOOKUP(\"Zonnefractie wanneer het dak beperkt is in oppervlakte\";Translations;LANG;FALSE)","Zonnefractie wanneer het dak beperkt is in oppervlakte","Zonnefractie wanneer het dak beperkt is in oppervlakte","Fraction solaire si la toiture est limitée en surface  "]
[{"$f":"IF(B205 <> 0, \"#VLOOKUP(\" & \"\"\"\" & B205 & \"\"\"\" & \";Translations;LANG;FALSE)\",\"\")","v":""},0]
["#VLOOKUP(\"Het warmwaterverbruik is onvoldoende om de installatie te dimensioneren!\";Translations;LANG;FALSE)","Het warmwaterverbruik is onvoldoende om de installatie te dimensioneren!","Het warmwaterverbruik is onvoldoende om de installatie te dimensioneren!","La consommation d'eau chaude est trop faible pour dimensionner l'installation!"]
["#VLOOKUP(\"Nuttige oppervlakte van de zonnepanelen\";Translations;LANG;FALSE)","Nuttige oppervlakte van de zonnepanelen","Nuttige oppervlakte van de zonnepanelen","Surface optique de capteurs solaires "]
["#VLOOKUP(\"Optimale oppervlakte van de zonnepanelen\";Translations;LANG;FALSE)","Optimale oppervlakte van de zonnepanelen","Optimale oppervlakte van de zonnepanelen","Surface de capteurs à l'optimum"]
["#VLOOKUP(\"Corresponderende oppervlakte plat dak\";Translations;LANG;FALSE)","Corresponderende oppervlakte plat dak","Corresponderende oppervlakte plat dak","Surface de toiture plate correspondante"]
["#VLOOKUP(\"Corresponderende oppervlakte hellend dak\";Translations;LANG;FALSE)","Corresponderende oppervlakte hellend dak","Corresponderende oppervlakte hellend dak","Surface de toiture inclinée correspondante"]
["#VLOOKUP(\"Max installeerbare oppervlakte panelen bij beperkte dakoppervlakte\";Translations;LANG;FALSE)","Max installeerbare oppervlakte panelen bij beperkte dakoppervlakte","Max installeerbare oppervlakte panelen bij beperkte dakoppervlakte","Surface de capteurs maximale installable (si contrainte en toiture)"]
["",0]
["#VLOOKUP(\"Zonneopslag\";Translations;LANG;FALSE)","Zonneopslag","Zonneopslag","Stockage solaire"]
["#VLOOKUP(\"Totaal volume zonneopslag\";Translations;LANG;FALSE)","Totaal volume zonneopslag","Totaal volume zonneopslag","Volume total de stockage solaire "]
["#VLOOKUP(\"Indicatief aantal opslagvaten (deelvolumes)\";Translations;LANG;FALSE)","Indicatief aantal opslagvaten (deelvolumes)","Indicatief aantal opslagvaten (deelvolumes)","Nombre indicatif de réservoirs (volumes partiels)"]
["#VLOOKUP(\"Indicatieve benodigde oppervlakte \";Translations;LANG;FALSE)","Indicatieve benodigde oppervlakte ","Indicatieve benodigde oppervlakte ","Surface d'encombrement des réservoirs "]
["#VLOOKUP(\"Gemiddeld gewicht van de volle opslagvaten\";Translations;LANG;FALSE)","Gemiddeld gewicht van de volle opslagvaten","Gemiddeld gewicht van de volle opslagvaten","Poids moyen de tous les réservoirs pleins"]
["",0]
["#VLOOKUP(\"Energiebalans\";Translations;LANG;FALSE)","Energiebalans","Energiebalans","Bilan Energétique"]
["#VLOOKUP(\"Jaarlijkse netto zonneopbrengst\";Translations;LANG;FALSE)","Jaarlijkse netto zonneopbrengst","Jaarlijkse netto zonneopbrengst","Production solaire annuelle nette"]
["#VLOOKUP(\"Brandstofbesparinig\";Translations;LANG;FALSE)","Brandstofbesparinig","Brandstofbesparinig","Combustible économisé "]
["#VLOOKUP(\"Primaire-energiebesparing\";Translations;LANG;FALSE)","Primaire-energiebesparing","Primaire-energiebesparing","Energie primaire économisée"]
["",0]
["#VLOOKUP(\"Economische balans\";Translations;LANG;FALSE)","Economische balans","Economische balans","Bilan Economique"]
["#VLOOKUP(\"Kost van het zonnethermisch systeem\";Translations;LANG;FALSE)","Kost van het zonnethermisch systeem","Kost van het zonnethermisch systeem","Coût du système solaire"]
["#VLOOKUP(\"Operationele kosten per jaar\";Translations;LANG;FALSE)","Operationele kosten per jaar","Operationele kosten per jaar","Coûts opérationnels par an"]
["#VLOOKUP(\"Subsidies\";Translations;LANG;FALSE)","Subsidies","Subsidies","Subsides"]
["#VLOOKUP(\"Netto investering na aftrek van subsidies\";Translations;LANG;FALSE)","Netto investering na aftrek van subsidies","Netto investering na aftrek van subsidies","Investissement net après subsides"]
["#VLOOKUP(\"Netto investering na subsidies en belastingsvermindering\";Translations;LANG;FALSE)","Netto investering na subsidies en belastingsvermindering","Netto investering na subsidies en belastingsvermindering","Investissement net après subsides & remise d'impôt"]
["#VLOOKUP(\"Besparing op de brandstoffactuur in jaar 1\";Translations;LANG;FALSE)","Besparing op de brandstoffactuur in jaar 1","Besparing op de brandstoffactuur in jaar 1","Economie sur la facture de combustible à l'année 1 "]
["#VLOOKUP(\"Kost per kWh voor de bespaarde brandstof zonder subsidies\";Translations;LANG;FALSE)","Kost per kWh voor de bespaarde brandstof zonder subsidies","Kost per kWh voor de bespaarde brandstof zonder subsidies","Coût par kWh de combustible économisé hors subsides "]
["#VLOOKUP(\"Kost per kWh voor de bespaarde brandstof na subsidies\";Translations;LANG;FALSE)","Kost per kWh voor de bespaarde brandstof na subsidies","Kost per kWh voor de bespaarde brandstof na subsidies","Coût par kWh de combustible économisé après subsides"]
["#VLOOKUP(\"Eenvoudige terugverdientijd (na subsidies)\";Translations;LANG;FALSE)","Eenvoudige terugverdientijd (na subsidies)","Eenvoudige terugverdientijd (na subsidies)","Temps de retour simple (après subsides)"]
["#VLOOKUP(\"Netto Actuele Waarde (NAW)\";Translations;LANG;FALSE)","Netto Actuele Waarde (NAW)","Netto Actuele Waarde (NAW)","Valeur Actualisée Nette"]
["#VLOOKUP(\"Interne Rentevoet (IRV)\";Translations;LANG;FALSE)","Interne Rentevoet (IRV)","Interne Rentevoet (IRV)","Taux de rentabilité Interne (TRI)"]
["",0]
["#VLOOKUP(\"Ecologische balans\";Translations;LANG;FALSE)","Ecologische balans","Ecologische balans","Bilan Environnemental"]
["#VLOOKUP(\"Jaarlijkse CO2-emissiebesparing\";Translations;LANG;FALSE)","Jaarlijkse CO2-emissiebesparing","Jaarlijkse CO2-emissiebesparing","Émissions de CO2 évitées annuellement "]
["#VLOOKUP(\"CO2-emissiebesparing op 25 jaar\";Translations;LANG;FALSE)","CO2-emissiebesparing op 25 jaar","CO2-emissiebesparing op 25 jaar","Émissions de CO2 évitées sur 25 ans"]
["#VLOOKUP(\"Kostprijs van een ton vermeden CO2-emissie (zonder subsidies)\";Translations;LANG;FALSE)","Kostprijs van een ton vermeden CO2-emissie (zonder subsidies)","Kostprijs van een ton vermeden CO2-emissie (zonder subsidies)","Coût d'une tonne de CO2 évité (hors subsides)"]
["#VLOOKUP(\"m³/dag warm waterverbruik op 60°C\";Translations;LANG;FALSE)","m³/dag warm waterverbruik op 60°C","m³/dag warm waterverbruik op 60°C","m³/jour de puisage à 60°C"]
["#VLOOKUP(\"m² (zonder schaduw of obstakels)\";Translations;LANG;FALSE)","m² (zonder schaduw of obstakels)","m² (zonder schaduw of obstakels)","m² (non ombragée, sans obstacles)"]
["#VLOOKUP(\"kWh zonne-energie /jaar\";Translations;LANG;FALSE)","kWh zonne-energie /jaar","kWh zonne-energie /jaar","kWh solaires /an"]
["#VLOOKUP(\"kWh thermisch /jaar\";Translations;LANG;FALSE)","kWh thermisch /jaar","kWh thermisch /jaar","kWh thermiques /an"]
["#VLOOKUP(\"ton\";Translations;LANG;FALSE)","ton","ton","tonne"]
["#VLOOKUP(\"5,5 % standaardwaarde\";Translations;LANG;FALSE)","5,5 % standaardwaarde","5,5 % standaardwaarde","5,5 % par défaut"]
["#VLOOKUP(\"Standaardwaarde: 0° = zuid\";Translations;LANG;FALSE)","Standaardwaarde: 0° = zuid","Standaardwaarde: 0° = zuid","Par défaut : 0° = sud"]
["#VLOOKUP(\"OptimaleHellingsgraad\";Translations;LANG;FALSE)","OptimaleHellingsgraad","Op een plat dak (0 tot 10° hellingsgraad) wordt de optimale hellingsgraad van de zonnepanelen berekend in functie van de gegeven \"Dakoriëntatie\".","Sur une toiture plate (0 à 10° d'inclinaison), l'inclinaison des capteurs est optimalisée en fonction de la donnée \"Orientation de la toiture\"."]
["#VLOOKUP(\"Opslagverliezen afgetrokken\";Translations;LANG;FALSE)","Opslagverliezen afgetrokken","Opslagverliezen afgetrokken","Pertes de stockage déduites"]
["#VLOOKUP(\"Rekening houdend met het rendement van het productiepark voor elektriciteit en het elektrisch verbruik van de randapparatuur\";Translations;LANG;FALSE)",{"$f":"C250","v":"Rekening houdend met het rendement van het productiepark voor elektriciteit en het elektrisch verbruik van de randapparatuur"},"Rekening houdend met het rendement van het productiepark voor elektriciteit en het elektrisch verbruik van de randapparatuur","Compte tenu du rendement du parc de production d'électricité et de la consommation électrique des auxilliaires."]
["#VLOOKUP(\"Kost van het elektriciteitsverbruik van de randapparatuur + onderhoudskosten\";Translations;LANG;FALSE)","Kost van het elektriciteitsverbruik van de randapparatuur + onderhoudskosten","Kost van het elektriciteitsverbruik van de randapparatuur + onderhoudskosten","Coût de la consommation des auxiliaires + coût de  maintenance."]
["#VLOOKUP(\"Houdt geen rekening met de stijging van de energieprijs\";Translations;LANG;FALSE)","Houdt geen rekening met de stijging van de energieprijs","Houdt geen rekening met de stijging van de energieprijs","Ne tient pas compte de l'augmentation du prix de l'énergie"]
["",0]
["",0]
["",0]
["",0]
["",0]
["",0]
["",0]
["",0]
["",0]
["",0]
["",0]
["",0]
["",0]
["",0]

{"sheet":"Messages","index":2,"n_rows":18,"n_cols":12,"rows_kept":18,"hidden":true}
[{"$nulls":8},"Macro work, do not touch:","Selected key:","Title","Tekst"]
["Each cell with input validation messagage should have a named range with as name a value in this column. ",{"$nulls":8},"LANG",{"$f":"IFERROR(  IF(LEN(VLOOKUP(SelCell,A4:K356,2,FALSE))>0,VLOOKUP(SelCell,A4:K356,2,FALSE), \"\"),\"\")","v":""},{"$f":"IFERROR(VLOOKUP(SelCell,A4:K356,3,FALSE),\"\")","v":""}]
["Named Range","Title input message","Tekst input messge"]
["_MsgTypeReq",null,{"$f":"VLOOKUP(\"woontypes_verplicht\",Translations,LANG,FALSE)","v":"Champ obligatoire. \nSi l'établissement ne correspond à aucun des types proposés, utiliser 'autre établissement'"}]
["_MsgAppar",null,{"$f":"VLOOKUP(\"Enkel voor appartementsgebouwen\",Translations,LANG,FALSE)","v":"Uniquement pour les immeubles à appartements"}]
["_MsgTauxOcc",null,{"$f":"VLOOKUP(\"De standaard gebruikte bezettingsgraad is 100%\",Translations,LANG,FALSE)","v":"Le taux d'occupation utilisé par défaut est de 100%"}]
["_MsgSurface",null,{"$f":"VLOOKUP(\"Vloeroppervlakte inclusief buitenmuren\",Translations,LANG,FALSE)","v":"Surface de plancher, murs extérieurs inclus"}]
["_MsgPlat",null,{"$f":"VLOOKUP(\"De daken met een helling tussen 0 en 10° dienen als platte daken beschouwd te worden\",Translations,LANG,FALSE)","v":"Les toitures présentant une inclinaison comprise entre 0 et 10° sont assimilées à des toitures plates."}]
["_MsgToitObst",null,{"$f":"VLOOKUP(\"Vul dit veld in als de nuttige dakoppervlakte (zonder schaduw of obstakels) kleiner is dan 90% van de nodige optimale dakoppervlakte.\",Translations,LANG,FALSE)","v":"A remplir si la surface de toiture utile (sans obstacles ni ombrage) est inférieure à 90% de la surface de toiture nécessaire à l'optimum "}]
["_MsgTotOrien",null,{"$f":"VLOOKUP(\"Indien hellend dak : oriëntatie van de helling die het best is blootgesteld aan het zuiden.\nIndien plat dak : oriëntatie van de gevel die het best naar het zuiden gericht is.\nDe standaard oriëntatie is pal in het zuiden.\",Translations,LANG,FALSE)","v":"Si \"Toiture inclinée\" : orientation du pan le mieux exposé.\nSi \"Toiture plate\" : orientation de la façade la plus proche du Sud.\nL'orientation utilisée par défaut est plein Sud."}]
["_MsgTotInc",null,{"$f":"VLOOKUP(\"hell_plat\",Translations,LANG,FALSE)","v":"Les toitures présentant une inclinaison comprise entre 0 et 10° sont assimilées à des toitures plates.\nSi \"Toiture plate\" cette donnée n'est pas prise en considération."}]
["_MsgVecteurEnerg",null,{"$f":"VLOOKUP(\"Kies de energiedrager in de correcte regio:\nBHG: Brussels Hoofdstedelijk Gewest\nWG: Waals Gewest\",Translations,LANG,FALSE)","v":"Sélectionner le vecteur énergétique et la Région.\nRBC : Région de Bruxelles-Capitale\nRW : Région wallonne"}]
["_MsgConsEeau",null,{"$f":"VLOOKUP(\"Het warmwaterverbruik moet begrepen zijn tussen 300 en 20.000 m³/jaar (equivalent aan 1 à 50 m³/dag) \",Translations,LANG,FALSE)","v":"La consommation d'eau chaude doit être comprise entre 300 et 20.000 m³/an (l'équivalent de 1 à 50 m³/j) "}]
["_MsgTempES",null,{"$f":"VLOOKUP(\"Duid de temperatuur van warmwateropslag of -productie aan. De standaard beschouwde waarde is 60°C.\",Translations,LANG,FALSE)","v":"Indiquez la température de stockage ou de production de l'eau chaude.  température considérée par défaut : 60°C"}]
["_MsgScenEPB",{"$f":"VLOOKUP(\"Scenario voor BHG volgens EPB\",Translations,LANG,FALSE)","v":"Scénario pour PEB RBC"},{"$f":"VLOOKUP(\"De gekozen actualisatievoet reflecteert de interestvoet op kapitaal in de huidige markt. De standaard gekozen actualisatievoet bedraagt 5,5%.\",Translations,LANG,FALSE)","v":"Le taux généralement choisi reflète le coût du capital et prend en compte le taux d'intérêt du marché pour une durée comparable.  Taux d'actualisation par défaut : 5,5%"}]
["_MsgTVA",null,{"$f":"VLOOKUP(\"Als u BTW recupereert, kies dan voor 0%. Alle berekeningen zullen dan uitgevoerd worden zonder BTW.\",Translations,LANG,FALSE)","v":"Si vous récupérez la TVA cliquez sur 0%. Tous les calculs seront hors TVA."}]
["_MsgPrimes",null,{"$f":"VLOOKUP(\"Het standaard gebruikte subsidie-percentage is 0%. In het BHG\nkunnen bepaalde bedrijven naast de energiepremie ook aanspraak maken op \n- een fiscale korting \n- een subsidie van het BHG  (25%, 35%, 45%) NIET CUMULEERBAAR met energiepremies\",Translations,LANG,FALSE)","v":"Le niveau d'aide par défaut est de 0%. Outre les primes Energie, en RBC certaines catégories d'entreprises ont droit:\n- aux aides régionales (T)PE - 45% ; ME -35% ; GE -25% ) NON CUMULABLES avec la prime Energie\n- à une déduction fiscale pour inv. EE"}]
["_MsgPIB",null,{"$f":"VLOOKUP(\"De belastingvermindering (voor appartementsgebouwen) werd afgeschaft op 31/12/2011\nDe standaardwaarde die gehanteerd wordt, is 0%.\",Translations,LANG,FALSE)","v":"la Réduction d'Impôts Pour Personne physique (limitée aux immeubles à appartements) est supprimée depuis le 31/12/2011. \nLa valeur utilisée par défaut est de 0%"}]

{"sheet":"Comments","index":3,"n_rows":10,"n_cols":3,"rows_kept":10,"hidden":true}
[]
["Each cell with a comment should have a named range with as name a value in this column. "]
["Named Range","(Title)","Tekst"]
["_Cmt_Actualisation",null,{"$f":"VLOOKUP(\"5,5 % standaardwaarde\",Translations,LANG,FALSE)","v":"5,5 % par défaut"}]
["_Cmt_Orient",null,{"$f":"VLOOKUP(\"Standaardwaarde: 0° = zuid\",Translations,LANG,FALSE)","v":"Par défaut : 0° = sud"}]
["_Cmt_InclOptim",null,{"$f":"VLOOKUP(\"OptimaleHellingsgraad\",Translations,LANG,FALSE)","v":"Sur une toiture plate (0 à 10° d'inclinaison), l'inclinaison des capteurs est optimalisée en fonction de la donnée \"Orientation de la toiture\"."}]
["_Cmt_LossesStock",null,{"$f":"VLOOKUP(\"Opslagverliezen afgetrokken\",Translations,LANG,FALSE)","v":"Pertes de stockage déduites"}]
["_Cmt_RendProd",null,{"$f":"VLOOKUP(\"Rekening houdend met het rendement van het productiepark voor elektriciteit en het elektrisch verbruik van de randapparatuur\",Translations,LANG,FALSE)","v":"Compte tenu du rendement du parc de production d'électricité et de la consommation électrique des auxilliaires."}]
["_Cmt_ElecAux",null,{"$f":"VLOOKUP(\"Kost van het elektriciteitsverbruik van de randapparatuur + onderhoudskosten\",Translations,LANG,FALSE)","v":"Coût de la consommation des auxiliaires + coût de  maintenance."}]
["_Cmt_PrixEn",null,{"$f":"VLOOKUP(\"Houdt geen rekening met de stijging van de energieprijs\",Translations,LANG,FALSE)","v":"Ne tient pas compte de l'augmentation du prix de l'énergie"}]

{"sheet":"Financiële balans","index":4,"n_rows":48,"n_cols":14,"rows_kept":48,"hidden":true}
[]
["GEGEVENS"]
[]
["Actualisatievoet","[%]",{"$f":"IF(ISBLANK(Tool!C56)*OR(Tool!C56=0),Hyp!B8,Tool!C56/100)","v":{"v":0.055,"d":"5.50%"}}]
["Energieprijsstijging","[%]",{"$f":"IF(ISBLANK(Tool!C64),LOOKUP(Tool!H7,SourceEnergie,EvoluPxE),Tool!C64/100)","v":{"v":0.0587,"d":"5.87%"}}]
["Inflatiepercentage (indicatief, niet gebruikt in de financiele berekening)","[%]",{"$f":"Hyp!B7","v":{"v":0.022,"d":"2.20%"}}]
[]
["Netto inv na subsidies en belastingaftrek",{"$f":"Tool!I58","v":"EUR TVAc"},{"$f":"IFERROR(Tool!H58,\"\")","v":{"v":37220.31391397327,"d":"37,220"}}]
["Besparing in jaar 1",{"$f":"Tool!I59","v":"EUR TVAc"},{"$f":"Tool!H59","v":{"v":885.9329694360379,"d":"886"}}]
["Operationele kosten",{"$f":"Tool!I55","v":"EUR TVAc"},{"$f":"IFERROR(Tool!H55,\"\")","v":{"v":104.09256240519998,"d":"104"}}]
[]
["Financiële balans"]
[]
["Eenvoudige terugverdientijd [TVT]","[jaar]",{"$f":"IFERROR(C8/C9,\"\")","v":{"v":42.01256212156407,"d":"42.0"}}]
["Netto Actuele Waarde [NAW]","EUR inv.-jaar",{"$f":"IFERROR(N45,\"\")","v":{"v":-15429.572698053758,"d":"-15,430"}}]
["IRR","[%]",{"$f":"IFERROR(IRR(L20:L45),\"\")","v":{"v":0.01628883548297977,"d":"1.63%"}}]
[]
["ACTUELE KOSTEN - OPBRENGSTEN"]
[{"$nulls":7},"Jaar","Netto Inv.","Baten","Kosten","EBIT","Geactualiseerde EBIT","Geactualiseerde kosten / baten"]
[{"$nulls":7},0,{"$f":"-C8","v":{"v":-37220.31391397327,"d":"-37,220"}},null,null,{"$f":"I20","v":{"v":-37220.31391397327,"d":"-37,220"}}]
[{"$nulls":7},1,null,{"$f":"C9*(1+$C$5)","v":{"v":937.9372347419333,"d":"938"}},{"$f":"C$10","v":{"v":104.09256240519998,"d":"104"}},{"$f":"J21-K21","v":{"v":833.8446723367333,"d":"834"}},{"$f":"L21/(1+$C$4)^H21","v":{"v":790.374097001643,"d":"790"}},{"$f":"M21+I20","v":{"v":-36429.93981697162,"d":"-36,430"}}]
[{"$nulls":7},2,null,{"$f":"J21*(1+$C$5)","v":{"v":992.9941504212848,"d":"993"}},{"$f":"C$10","v":{"v":104.09256240519998,"d":"104"}},{"$f":"J22-K22","v":{"v":888.9015880160848,"d":"889"}},{"$f":"L22/(1+$C$4)^H22","v":{"v":798.6357790850025,"d":"799"}},{"$f":"N21+M22","v":{"v":-35631.30403788662,"d":"-35,631"}}]
[{"$nulls":7},3,null,{"$f":"J22*(1+$C$5)","v":{"v":1051.282907051014,"d":"1,051"}},{"v":104.09256240519998,"d":"104"},{"v":947.1903446458141,"d":"947"},{"$f":"L23/(1+$C$4)^H23","v":{"v":806.6402400833596,"d":"807"}},{"v":-34824.66379780326,"d":"-34,825"}]
[{"$nulls":7},4,null,{"v":1112.9932136949085,"d":"1,113"},{"v":104.09256240519998,"d":"104"},{"v":1008.9006512897085,"d":"1,009"},{"v":814.4014980495486,"d":"814"},{"v":-34010.26229975371,"d":"-34,010"}]
[{"$nulls":7},5,null,{"v":1178.3259153387996,"d":"1,178"},{"v":104.09256240519998,"d":"104"},{"v":1074.2333529335997,"d":"1,074"},{"v":821.9328423712464,"d":"822"},{"v":-33188.32945738247,"d":"-33,188"}]
[{"$nulls":7},6,null,{"v":1247.4936465691871,"d":"1,247"},{"v":104.09256240519998,"d":"104"},{"v":1143.4010841639872,"d":"1,143"},{"v":829.2468717657378,"d":"829"},{"v":-32359.08258561673,"d":"-32,359"}]
[{"$nulls":7},7,null,{"v":1320.7215236227985,"d":"1,321"},{"v":104.09256240519998,"d":"104"},{"v":1216.6289612175985,"d":"1,217"},{"v":836.3555302939402,"d":"836"},{"v":-31522.72705532279,"d":"-31,523"}]
[{"$nulls":7},8,null,{"v":1398.2478770594566,"d":"1,398"},{"v":104.09256240519998,"d":"104"},{"v":1294.1553146542567,"d":"1,294"},{"v":843.2701414969433,"d":"843"},{"v":-30679.456913825845,"d":"-30,679"}]
[{"$nulls":7},9,null,{"v":1480.3250274428467,"d":"1,480"},{"v":104.09256240519998,"d":"104"},{"v":1376.2324650376468,"d":"1,376"},{"$f":"L29/(1+$C$4)^H29","v":{"v":850.0014407529476,"d":"850"}},{"v":-29829.455473072896,"d":"-29,829"}]
[{"$nulls":7},10,null,{"v":1567.2201065537417,"d":"1,567"},{"v":104.09256240519998,"d":"104"},{"v":1463.1275441485418,"d":"1,463"},{"v":856.5596059473726,"d":"857"},{"v":-28972.895867125524,"d":"-28,973"}]
[{"$nulls":7},11,null,{"v":1659.2159268084463,"d":"1,659"},{"v":104.09256240519998,"d":"104"},{"v":1555.1233644032463,"d":"1,555"},{"v":862.9542865440781,"d":"863"},{"v":-28109.941580581446,"d":"-28,110"}]
[{"$nulls":7},12,null,{"v":1756.611901712102,"d":"1,757"},{"v":104.09256240519998,"d":"104"},{"v":1652.519339306902,"d":"1,653"},{"v":869.1946311410492,"d":"869"},{"v":-27240.746949440396,"d":"-27,241"}]
[{"$nulls":7},13,null,{"v":1859.7250203426024,"d":"1,860"},{"v":104.09256240519998,"d":"104"},{"v":1755.6324579374025,"d":"1,756"},{"v":875.2893135895572,"d":"875"},{"v":-26365.45763585084,"d":"-26,365"}]
[{"$nulls":7},14,null,{"v":1968.8908790367132,"d":"1,969"},{"v":104.09256240519998,"d":"104"},{"v":1864.7983166315132,"d":"1,865"},{"v":881.2465577516836,"d":"881"},{"v":-25484.211078099153,"d":"-25,484"}]
[{"$nulls":7},15,null,{"v":2084.464773636168,"d":"2,084"},{"v":104.09256240519998,"d":"104"},{"v":1980.372211230968,"d":"1,980"},{"v":887.074160967196,"d":"887"},{"v":-24597.136917131957,"d":"-24,597"}]
[{"$nulls":7},16,null,{"v":2206.822855848611,"d":"2,207"},{"v":104.09256240519998,"d":"104"},{"v":2102.730293443411,"d":"2,103"},{"v":892.7795162970582,"d":"893"},{"v":-23704.3574008349,"d":"-23,704"}]
[{"$nulls":7},17,null,{"v":2336.3633574869245,"d":"2,336"},{"v":104.09256240519998,"d":"104"},{"v":2232.2707950817244,"d":"2,232"},{"v":898.3696336073536,"d":"898"},{"v":-22805.987767227543,"d":"-22,806"}]
[{"$nulls":7},18,null,{"v":2473.5078865714067,"d":"2,474"},{"v":104.09256240519998,"d":"104"},{"v":2369.4153241662066,"d":"2,369"},{"v":903.8511595540742,"d":"904"},{"v":-21902.13660767347,"d":"-21,902"}]
[{"$nulls":7},19,null,{"v":2618.7027995131484,"d":"2,619"},{"v":104.09256240519998,"d":"104"},{"v":2514.6102371079483,"d":"2,515"},{"v":909.2303965260763,"d":"909"},{"v":-20992.906211147394,"d":"-20,993"}]
[{"$nulls":7},20,null,{"v":2772.42065384457,"d":"2,772"},{"v":104.09256240519998,"d":"104"},{"v":2668.32809143937,"d":"2,668"},{"v":914.5133206005144,"d":"915"},{"v":-20078.39289054688,"d":"-20,078"}]
[{"$nulls":7},21,null,{"v":2935.161746225246,"d":"2,935"},{"v":104.09256240519998,"d":"104"},{"v":2831.069183820046,"d":"2,831"},{"v":919.7055985622402,"d":"920"},{"v":-19158.68729198464,"d":"-19,159"}]
[{"$nulls":7},22,null,{"v":3107.455740728668,"d":"3,107"},{"v":104.09256240519998,"d":"104"},{"v":3003.3631783234678,"d":"3,003"},{"v":924.8126040359597,"d":"925"},{"v":-18233.87468794868,"d":"-18,234"}]
[{"$nulls":7},23,null,{"v":3289.8633927094406,"d":"3,290"},{"v":104.09256240519998,"d":"104"},{"v":3185.7708303042405,"d":"3,186"},{"v":929.8394327774058,"d":"930"},{"v":-17304.03525517127,"d":"-17,304"}]
[{"$nulls":7},24,null,{"v":3482.9783738614847,"d":"3,483"},{"v":104.09256240519998,"d":"104"},{"v":3378.8858114562845,"d":"3,379"},{"v":934.7909171673693,"d":"935"},{"v":-16369.244338003902,"d":"-16,369"}]
[{"$nulls":7},25,null,{"v":3687.4292044071535,"d":"3,687"},{"v":104.09256240519998,"d":"104"},{"v":3583.3366420019534,"d":"3,583"},{"v":939.6716399501441,"d":"940"},{"v":-15429.572698053758,"d":"-15,430"}]
[]
[]
[{"$nulls":11},"EBIT : Earnings before interest and tax"]

{"sheet":"Hyp","index":5,"n_rows":30,"n_cols":8,"rows_kept":30,"hidden":true}
["Evolution prix énergies","low BFP","medium BFP","High BFP","Energy Trend 2030","Hyp ARGRBC études de faisabilité PEB (2008)"]
["augmentation annuelle du prix de l'électricité (%)",{"v":0,"d":"0.00%"},{"v":0.0347,"d":"3.47%"},{"v":0.0587,"d":"5.87%"},{"$f":"E3","v":{"v":0.02860932833558384,"d":"2.86%"}},{"$f":"D2","v":{"v":0.0587,"d":"5.87%"}},null,"Source: http://www.bruxellesenvironnement.be/uploadedFiles/Contenu_du_site/Professionnels/Themes/Énergie/01_PEB_et_climat_intérieur/01Travaux_PEB/01_Qu_est_ce_que_les_travaux_PEB/AMB20080724_hypotheses_energetiques_PEB.pdf?langtype=2060 "]
["augmentation annuelle du prix du gaz (%)",{"v":0,"d":"0.00%"},{"v":0.0347,"d":"3.47%"},{"v":0.0587,"d":"5.87%"},{"v":0.02860932833558384,"d":"2.86%"},{"$f":"D3","v":{"v":0.0587,"d":"5.87%"}},null,"Source: http://www.bruxellesenvironnement.be/uploadedFiles/Contenu_du_site/Professionnels/Themes/Énergie/01_PEB_et_climat_intérieur/01Travaux_PEB/01_Qu_est_ce_que_les_travaux_PEB/AMB20080724_hypotheses_energetiques_PEB.pdf?langtype=2061"]
["augmentation annuelle du prix du mazout (%)",{"v":0,"d":"0.00%"},{"v":0.0148,"d":"1.48%"},{"v":0.0326,"d":"3.26%"},{"v":0.020246275462935667,"d":"2.02%"},{"$f":"D4","v":{"v":0.0326,"d":"3.26%"}},null,"Source: http://www.bruxellesenvironnement.be/uploadedFiles/Contenu_du_site/Professionnels/Themes/Énergie/01_PEB_et_climat_intérieur/01Travaux_PEB/01_Qu_est_ce_que_les_travaux_PEB/AMB20080724_hypotheses_energetiques_PEB.pdf?langtype=2062"]
["augmentation annuelle du prix des pellets",{"v":0,"d":"0.00%"},null,{"$f":"D4","v":{"v":0.0326,"d":"3.26%"}},{"$f":"E4","v":{"v":0.020246275462935667,"d":"2.02%"}},{"$f":"D5","v":{"v":0.0326,"d":"3.26%"}}]
[]
["Inflation",{"v":0.022,"d":"2.20%"}]
["Taux d'actualisation",{"$f":"0.055","v":{"v":0.055,"d":"5.5%"}}]
["Durée de vie économique de l'installation",25,"ans"]
[]
["Rendement appoint","Rdt combustion",null,"Rdt global annuel"]
[null,"%","%","%","%"]
["Chaudière à condensation",102,108,70,100]
["Chaudière air pulsé",88,95,70,90]
["Chaudière atmosphérique",80,90,60,80]
["Chauffe-eau sans veilleuse",88,95,60,80]
["Chauffe-eau à veilleuse",80,90,40,70]
[]
["% InvBrut Maintenance",{"v":0.0025,"d":"0.25%"}]
["Cout électricité auxilliaire",{"$f":"'Eco Data'!W3","v":0.1456},"EUR/kWh HTVA"]
[]
[]
[]
["Définitions"]
[]
["Fraction solaire = Qsol net/(Qsol net+Qaux,net)"]
["Qsol net + Qaux net = Qd"]
[]
["Le rendement utile d'une chaudière est son rendement instantané lorsque le brûleur fonctionne. "]
["C'est le rapport entre la puissance contenue dans le combustible et la puissance thermique transmise à l'eau de chauffage"]

{"sheet":"General Data","index":6,"n_rows":55,"n_cols":6,"rows_kept":55,"hidden":true}
["Secteur"]
[null,{"$f":"VLOOKUP(\"Privaat\",Translations,LANG,FALSE)","v":"Privé"}]
[null,{"$f":"VLOOKUP(\"Publiek\",Translations,LANG,FALSE)","v":"Public"}]
[]
["O_N"]
[null,{"$f":"VLOOKUP(\"Nee\",Translations,LANG,FALSE)","v":"Non"}]
[null,{"$f":"VLOOKUP(\"Ja\",Translations,LANG,FALSE)","v":"Oui"}]
[]
["CategoriePEB"]
["1.16","Autre affectation"]
["1.9","Bureaux et services"]
["1.10","Enseignement"]
["1.7","Immeuble à appartements"]
["1.8","Résidentiel commun"]
["1.11","Soins de santé"]
["1.15","Sport"]
[]
[null,"TypeEtablissement","ConsoEtablissement [l/j@60°]","UnitéConsomECS","UnitéHabitation","Profil"]
["1.7",{"$f":"VLOOKUP(\"A-Centra voor gehandicapten, IMS, IMP\",Translations,LANG,FALSE)","v":"A-Centre pour handicapés, IMS, IMP, "},80,{"$f":"VLOOKUP(\"Bedden\",Translations,LANG,FALSE)","v":"Lits"},null,"A"]
["1.11",{"$f":"VLOOKUP(\"B-Hospitalen, klinieken\",Translations,LANG,FALSE)","v":"B-Hôpital, clinique"},65,{"$f":"VLOOKUP(\"Bedden\",Translations,LANG,FALSE)","v":"Lits"},null,"A"]
["1.8",{"$f":"VLOOKUP(\"C-Rust- en verzorgingstehuizen\",Translations,LANG,FALSE)","v":"C-Maison de repos et de soins"},65,{"$f":"VLOOKUP(\"Bedden\",Translations,LANG,FALSE)","v":"Lits"},null,"A"]
["1.8",{"$f":"VLOOKUP(\"D-Strafinrichtingen\",Translations,LANG,FALSE)","v":"D-Etablissement pénitentiaire"},{"$f":"AVERAGE(C24,87)","v":{"v":63.5,"d":"64"}},{"$f":"VLOOKUP(\"Gedetineerden\",Translations,LANG,FALSE)","v":"Pensionnaires"},null,"A"]
["1.7",{"$f":"VLOOKUP(\"E-Serviceflats\",Translations,LANG,FALSE)","v":"E-Appart hotel, Flat hotel"},40,{"$f":"VLOOKUP(\"Bewoners\",Translations,LANG,FALSE)","v":"Occupants"},null,"A"]
["1.8",{"$f":"VLOOKUP(\"F-Hotels, motels, jeugdherbergen, pensions\",Translations,LANG,FALSE)","v":"F-Hôtel, motel, auberge, pension"},40,{"$f":"VLOOKUP(\"Bewoners\",Translations,LANG,FALSE)","v":"Occupants"},null,"A"]
["1.7",{"$f":"VLOOKUP(\"G-Gebouw van 4 tot 15 appartementen\",Translations,LANG,FALSE)","v":"G-Logement de 4 à 15 appartements"},40,{"$f":"VLOOKUP(\"Bewoners\",Translations,LANG,FALSE)","v":"Occupants"},{"$f":"VLOOKUP(\"Wooneenheden\",Translations,LANG,FALSE)","v":"Logements"},"A"]
["1.8",{"$f":"VLOOKUP(\"H-Rusthuizen\",Translations,LANG,FALSE)","v":"H-Maison de repos"},{"$f":"AVERAGE(50,28)","v":39},{"$f":"VLOOKUP(\"Bedden\",Translations,LANG,FALSE)","v":"Lits"},null,"A"]
["1.7",{"$f":"VLOOKUP(\"I-Gebouw van meer dan 15 appartementen\",Translations,LANG,FALSE)","v":"I-Logement de plus de 15 appartements"},35,{"$f":"VLOOKUP(\"Bewoners\",Translations,LANG,FALSE)","v":"Occupants"},{"$f":"VLOOKUP(\"Wooneenheden\",Translations,LANG,FALSE)","v":"Logements"},"A"]
["1.8",{"$f":"VLOOKUP(\"J-Internaten\",Translations,LANG,FALSE)","v":"J-Internat"},{"$f":"35*5/7","v":25},{"$f":"VLOOKUP(\"Bedden\",Translations,LANG,FALSE)","v":"Lits"},null,"C"]
["1.7",{"$f":"VLOOKUP(\"K-Sociale huisvesting\",Translations,LANG,FALSE)","v":"K-Logement social"},25,{"$f":"VLOOKUP(\"Bewoners\",Translations,LANG,FALSE)","v":"Occupants"},{"$f":"VLOOKUP(\"Wooneenheden\",Translations,LANG,FALSE)","v":"Logements"},"A"]
["1.8",{"$f":"VLOOKUP(\"L-Onthaalcentra\",Translations,LANG,FALSE)","v":"L-Centres d'accueil"},{"$f":"AVERAGE(25,43)*5/7","v":{"v":24.285714285714285,"d":"24"}},{"$f":"VLOOKUP(\"Bewoners + personeelsleden\",Translations,LANG,FALSE)","v":"Occupants + membres du personnel"},null,"B"]
["1.9",{"$f":"VLOOKUP(\"M-Kapsalons\",Translations,LANG,FALSE)","v":"M-Salons de coiffure"},{"$f":"15*5/7","v":{"v":10.714285714285714,"d":"11"}},{"$f":"VLOOKUP(\"Klanten per dag\",Translations,LANG,FALSE)","v":"Clients par jour"},null,"B"]
["1.11",{"$f":"VLOOKUP(\"N-Poliklinieken en daghospitalen\",Translations,LANG,FALSE)","v":"N-Polyclinique, hôpital de jour"},10,{"$f":"VLOOKUP(\"Bewoners + personeelsleden\",Translations,LANG,FALSE)","v":"Occupants + membres du personnel"},null,"A"]
["1.15",{"$f":"VLOOKUP(\"O-Sportcentra, sporthallen, fitness\",Translations,LANG,FALSE)","v":"O-Centre sportif, hall des sports, fitness"},{"$f":"10*336/365","v":{"v":9.205479452054794,"d":"9"}},{"$f":"VLOOKUP(\"Sporters per dag\",Translations,LANG,FALSE)","v":"Sportifs par jour"},null,"D"]
["1.13",{"$f":"VLOOKUP(\"P-Restaurants\",Translations,LANG,FALSE)","v":"P-Restaurants"},{"$f":"7*5/7","v":5},{"$f":"VLOOKUP(\"Klanten per dag\",Translations,LANG,FALSE)","v":"Clients par jour"},null,"B"]
["1.10",{"$f":"VLOOKUP(\"Q-Crêches\",Translations,LANG,FALSE)","v":"Q-Crêche"},{"$f":"6*5/7","v":{"v":4.285714285714286,"d":"4"}},{"$f":"VLOOKUP(\"Kinderen\",Translations,LANG,FALSE)","v":"Enfants"},null,"B"]
["1.11",{"$f":"VLOOKUP(\"R-Zorgcentra, medisch-sociale hulpcentra of mentale zorgcentra\",Translations,LANG,FALSE)","v":"R-Centre de soins, aide médico-sociale, santé mentale"},{"$f":"5*5/7","v":{"v":3.5714285714285716,"d":"4"}},{"$f":"VLOOKUP(\"Bewoners + personeelsleden\",Translations,LANG,FALSE)","v":"Occupants + membres du personnel"},null,"B"]
["1.9",{"$f":"VLOOKUP(\"S-Administraties\",Translations,LANG,FALSE)","v":"S-Administration"},{"$f":"2","v":2},{"$f":"VLOOKUP(\"Bedienden\",Translations,LANG,FALSE)","v":"Employés"},null,"B"]
["1.9",{"$f":"VLOOKUP(\"T-Kantoren\",Translations,LANG,FALSE)","v":"T-Bureau d'entreprise"},{"$f":"2","v":2},{"$f":"VLOOKUP(\"Bedienden\",Translations,LANG,FALSE)","v":"Employés"},null,"B"]
["1.10",{"$f":"VLOOKUP(\"U-CLB-centra\",Translations,LANG,FALSE)","v":"U-Centre PMS"},2,{"$f":"VLOOKUP(\"Bewoners + personeelsleden\",Translations,LANG,FALSE)","v":"Occupants + membres du personnel"},null,"C"]
["1.10",{"$f":"VLOOKUP(\"V-Scholen en universiteiten\",Translations,LANG,FALSE)","v":"V-Ecole, Université"},2,{"$f":"VLOOKUP(\"Studenten\",Translations,LANG,FALSE)","v":"Etudiants"},null,"C"]
["1.16",{"$f":"VLOOKUP(\"X-Andere soorten vestigingen\",Translations,LANG,FALSE)","v":"X-Autre type d'établissement"},0,{"$f":"VLOOKUP(\"Bewoners\",Translations,LANG,FALSE)","v":"Occupants"}]
[]
["UniteFrequentation"]
["1.8","Kamers"]
["1.9","Klanten per dag"]
["1.10","Scholieren"]
["1.9","Bedienden"]
["1.8 - 1.10","Kinderen"]
["1.8 - 1.10","Studenten"]
["1.8","Bedden"]
["1.7","Residentiebedden"]
["1.7","Bewoners"]
["1.8 - 1.10 - 1.11","Bewoners + personeelsleden"]
["1.8","Gedetineerden"]
["1.15","Bezoekers per jaar"]

{"sheet":"Tech Data","index":7,"n_rows":66,"n_cols":41,"rows_kept":66,"hidden":true}
[]
[]
[]
[]
[]
[]
["Toit",null,"InclinOpt","FactCorr","OrientOpt","ST_Scoll"]
[null,{"$f":"VLOOKUP(\"Hellend dak\",Translations,LANG,FALSE)","v":"Toiture inclinée"},{"$f":"X13","v":{"v":45,"d":"45°"}},{"$f":"Y17","v":{"v":1.2833865758009408,"d":"1.28"}},{"$f":"X14","v":"1-Est"},{"$f":"C23","v":1.2}]
[null,{"$f":"VLOOKUP(\"Plat dak\",Translations,LANG,FALSE)","v":"Toiture plate"},{"$f":"Z20","v":{"v":10,"d":"10°"}},{"$f":"Z19","v":{"v":1.1442581292524734,"d":"1.14"}},{"$f":"X14","v":"1-Est"},{"$f":"C24","v":3.35},{"$nulls":17},"SDR geen vertaling"]
[]
["OrientationT",null,"InclinaisonT",{"v":0,"d":"0°"},{"v":5,"d":"5°"},{"v":10,"d":"10°"},{"v":15,"d":"15°"},{"v":20,"d":"20°"},{"v":25,"d":"25°"},{"v":30,"d":"30°"},{"v":35,"d":"35°"},{"v":40,"d":"40°"},{"v":45,"d":"45°"},{"v":50,"d":"50°"},{"v":55,"d":"55°"},{"v":60,"d":"60°"},{"v":65,"d":"65°"},{"v":70,"d":"70°"},{"v":75,"d":"75°"},{"v":80,"d":"80°"},{"v":85,"d":"85°"},{"v":90,"d":"90°"},null,"Interface Utilisateur"]
[null,{"$f":"VLOOKUP(\"1-Oost\",Translations,LANG,FALSE)","v":"1-Est"},{"v":-90,"d":"-90°"},{"v":1.132524507108219,"d":"1.13"},{"v":1.1360851848832036,"d":"1.14"},{"v":1.1442581292524734,"d":"1.14"},{"v":1.1556208762857842,"d":"1.16"},{"v":1.169982181904656,"d":"1.17"},{"v":1.1866682472181436,"d":"1.19"},{"v":1.2061012657367933,"d":"1.21"},{"v":1.2284795746354584,"d":"1.23"},{"v":1.2542357665474078,"d":"1.25"},{"v":1.2833865758009408,"d":"1.28"},{"v":1.3177565482146532,"d":"1.32"},{"v":1.355939434285465,"d":"1.36"},{"v":1.4004463014114432,"d":"1.40"},{"v":1.4503469202157042,"d":"1.45"},{"v":1.5073148902489093,"d":"1.51"},{"v":1.5744660720675896,"d":"1.57"},{"v":1.6475681776175075,"d":"1.65"},{"v":1.7305791809192896,"d":"1.73"},{"v":1.8294964008317962,"d":"1.83"},null,"TI"]
[null,{"$f":"VLOOKUP(\"3-Oost zuidoost\",Translations,LANG,FALSE)","v":"2-Est Sud Est"},{"v":-67.5,"d":"-68°"},{"v":1.132524507108219,"d":"1.13"},{"v":1.1194681113312686,"d":"1.12"},{"v":1.111433907639475,"d":"1.11"},{"v":1.1073294602219914,"d":"1.11"},{"v":1.106856168581224,"d":"1.11"},{"v":1.1095955513271707,"d":"1.11"},{"v":1.1165225819921674,"d":"1.12"},{"v":1.1266950202963104,"d":"1.13"},{"v":1.1414618524268714,"d":"1.14"},{"v":1.1603846116220968,"d":"1.16"},{"v":1.1841850696762188,"d":"1.18"},{"v":1.2142228492275318,"d":"1.21"},{"v":1.2490766747978486,"d":"1.25"},{"v":1.2902946041857548,"d":"1.29"},{"v":1.3404761821006885,"d":"1.34"},{"v":1.3997968735118884,"d":"1.40"},{"v":1.4650248284545047,"d":"1.47"},{"v":1.5426354606750685,"d":"1.54"},{"v":1.6354456582812924,"d":"1.64"},null,{"$f":"IF(ISBLANK(Tool!C40),$L$11,Tool!C40)","v":{"v":45,"d":"45°"}},{"$f":"MATCH(X13,D11:V11)","v":10},"Position tableau"]
[null,{"$f":"VLOOKUP(\"4-West\",Translations,LANG,FALSE)","v":"3-Ouest "},{"v":90,"d":"90°"},{"v":1.132524507108219,"d":"1.13"},{"v":1.1355201339595595,"d":"1.14"},{"v":1.143099933074192,"d":"1.14"},{"v":1.1542938491717039,"d":"1.15"},{"v":1.168306930307862,"d":"1.17"},{"v":1.1854844083168292,"d":"1.19"},{"v":1.2047224982076326,"d":"1.20"},{"v":1.2272705864744082,"d":"1.23"},{"v":1.2529741423784246,"d":"1.25"},{"v":1.2826686607212516,"d":"1.28"},{"v":1.315263446658765,"d":"1.32"},{"v":1.3539349382578771,"d":"1.35"},{"v":1.3968724924788816,"d":"1.40"},{"v":1.4467257569567116,"d":"1.45"},{"v":1.5039658180579427,"d":"1.50"},{"v":1.566800277172987,"d":"1.57"},{"v":1.6404042260313263,"d":"1.64"},{"v":1.7275420939945243,"d":"1.73"},{"v":1.8209638763408065,"d":"1.82"},null,{"$f":"IF(OR(ISBLANK(Tool!C39),Tool!C39=0),$B$16,Tool!C39)","v":"1-Est"},{"$f":"MATCH(X14,OrientationT)","v":1},"Position tableau"]
[null,{"$f":"VLOOKUP(\"5-West zuidwest\",Translations,LANG,FALSE)","v":"4-Ouest Sud Ouest"},{"v":67.5,"d":"68°"},{"v":1.132524507108219,"d":"1.13"},{"v":1.1189510500793525,"d":"1.12"},{"v":1.110206514885549,"d":"1.11"},{"v":1.105711630652445,"d":"1.11"},{"v":1.1044314312396606,"d":"1.10"},{"v":1.1070644445968685,"d":"1.11"},{"v":1.1126948652060322,"d":"1.11"},{"v":1.1228852500947206,"d":"1.12"},{"v":1.1365181499442942,"d":"1.14"},{"v":1.1547854205329116,"d":"1.15"},{"v":1.1781235020727756,"d":"1.18"},{"v":1.2051878019233437,"d":"1.21"},{"v":1.2389543772420057,"d":"1.24"},{"v":1.2806567332430636,"d":"1.28"},{"v":1.326749994877548,"d":"1.33"},{"v":1.380298465342611,"d":"1.38"},{"v":1.4453580874022887,"d":"1.45"},{"v":1.521894171986702,"d":"1.52"},{"v":1.6071871012181251,"d":"1.61"}]
[null,{"$f":"VLOOKUP(\"6-Zuid\",Translations,LANG,FALSE)","v":"5-Sud"},{"v":0,"d":"0°"},{"v":1.132524507108219,"d":"1.13"},{"v":1.0934498566670614,"d":"1.09"},{"v":1.0623871648166676,"d":"1.06"},{"v":1.0382744304001281,"d":"1.04"},{"v":1.0202422204238508,"d":"1.02"},{"v":1.0080476515800354,"d":"1.01"},{"v":1.0013014600889847,"d":"1.00"},{"v":1,"d":"1.00"},{"v":1.004028115746658,"d":"1.00"},{"v":1.0133337891988776,"d":"1.01"},{"v":1.0281212793509709,"d":"1.03"},{"v":1.0491045035979574,"d":"1.05"},{"v":1.0766198672210936,"d":"1.08"},{"v":1.1111264974747355,"d":"1.11"},{"v":1.1539240694164814,"d":"1.15"},{"v":1.2064879720797579,"d":"1.21"},{"v":1.2699298087543058,"d":"1.27"},{"v":1.3466628276766783,"d":"1.35"},{"v":1.4396113849601737,"d":"1.44"},null,"Facteur correctif",{"$f":"HLOOKUP(X13,D11:V20,MATCH(X14,OrientationT)+1)","v":{"v":1.2833865758009408,"d":"1.28"}},"lookup "]
[null,{"$f":"VLOOKUP(\"7-Zuidoost\",Translations,LANG,FALSE)","v":"6-Sud Est"},{"v":-45,"d":"-45°"},{"v":1.132524507108219,"d":"1.13"},{"v":1.1057187181829036,"d":"1.11"},{"v":1.085241123281848,"d":"1.09"},{"v":1.0698219507242057,"d":"1.07"},{"v":1.0595997058541422,"d":"1.06"},{"v":1.0537154274650238,"d":"1.05"},{"v":1.0523960600689375,"d":"1.05"},{"v":1.056007315969589,"d":"1.06"},{"v":1.0638181166991978,"d":"1.06"},{"v":1.076771764984803,"d":"1.08"},{"v":1.0958123326807963,"d":"1.10"},{"v":1.1204449970249701,"d":"1.12"},{"v":1.149472295249673,"d":"1.15"},{"v":1.186138241373344,"d":"1.19"},{"v":1.2316700809515608,"d":"1.23"},{"v":1.2863201484150733,"d":"1.29"},{"v":1.349604218949672,"d":"1.35"},{"v":1.4248699947975902,"d":"1.42"},{"v":1.5152601047135479,"d":"1.52"},null,"Facteur correctif",{"$f":"OFFSET(C11,MATCH(X14,OrientationT),MATCH(X13,D11:V11))","v":{"v":1.2833865758009408,"d":"1.28"}},"offset"]
[null,{"$f":"VLOOKUP(\"8-Zuidwest\",Translations,LANG,FALSE)","v":"7-Sud Ouest"},{"v":45,"d":"45°"},{"v":1.132524507108219,"d":"1.13"},{"v":1.1053283909559524,"d":"1.11"},{"v":1.0842052825519943,"d":"1.08"},{"v":1.0684517372095736,"d":"1.07"},{"v":1.0572854684289505,"d":"1.06"},{"v":1.0509991858443004,"d":"1.05"},{"v":1.0493785084028957,"d":"1.05"},{"v":1.0517291186836752,"d":"1.05"},{"v":1.0594439929682735,"d":"1.06"},{"v":1.0721266040265613,"d":"1.07"},{"v":1.0887678412694843,"d":"1.09"},{"v":1.1112474583910767,"d":"1.11"},{"v":1.1407668449972304,"d":"1.14"},{"v":1.177559105503412,"d":"1.18"},{"v":1.2194026770910864,"d":"1.22"},{"v":1.2699944739040023,"d":"1.27"},{"v":1.3315731968503732,"d":"1.33"},{"v":1.4040418867708269,"d":"1.40"},{"v":1.4884262713964214,"d":"1.49"},null,"TP","optimum théorique","valeur sélectionnée"]
[null,{"$f":"VLOOKUP(\"9-Zuid zuidoost\",Translations,LANG,FALSE)","v":"8-Sud Sud Est"},{"v":-22.5,"d":"-23°"},{"v":1.132524507108219,"d":"1.13"},{"v":1.0966659901433495,"d":"1.10"},{"v":1.0683543569294054,"d":"1.07"},{"v":1.046485945984738,"d":"1.05"},{"v":1.0302858877317507,"d":"1.03"},{"v":1.0198495817955404,"d":"1.02"},{"v":1.014676706278091,"d":"1.01"},{"v":1.014226069702567,"d":"1.01"},{"v":1.0189681745364614,"d":"1.02"},{"v":1.029350121593724,"d":"1.03"},{"v":1.0456050994143729,"d":"1.05"},{"v":1.0675639690328678,"d":"1.07"},{"v":1.09485631726654,"d":"1.09"},{"v":1.129465390287763,"d":"1.13"},{"v":1.1725803247740914,"d":"1.17"},{"v":1.2255860414101472,"d":"1.23"},{"v":1.2887836624959648,"d":"1.29"},{"v":1.3645532007674595,"d":"1.36"},{"v":1.4563024496060537,"d":"1.46"},null,"Facteur correctif",{"$f":"MIN(OFFSET(D11,MATCH(X14,OrientationT,0),0):OFFSET(V11,MATCH(X14,OrientationT,0),0))","v":{"v":1.132524507108219,"d":"1.13"}},{"$f":"MIN(OFFSET(F11,MATCH(X14,OrientationT),0):OFFSET(V11,MATCH(X14,OrientationT),0))","v":{"v":1.1442581292524734,"d":"1.14"}}]
[null,{"$f":"VLOOKUP(\"10-Zuid zuidwest\",Translations,LANG,FALSE)","v":"9-Sud Sud Ouest "},{"v":22.5,"d":"23°"},{"v":1.132524507108219,"d":"1.13"},{"v":1.0964605526865234,"d":"1.10"},{"v":1.067783791942846,"d":"1.07"},{"v":1.0454614672739897,"d":"1.05"},{"v":1.0291592015844624,"d":"1.03"},{"v":1.0181334039858208,"d":"1.02"},{"v":1.0122233373958398,"d":"1.01"},{"v":1.011826360809105,"d":"1.01"},{"v":1.0167379397111762,"d":"1.02"},{"v":1.0263144707395315,"d":"1.03"},{"v":1.04085695729851,"d":"1.04"},{"v":1.0616119674085596,"d":"1.06"},{"v":1.0891416987445341,"d":"1.09"},{"v":1.1242279708404916,"d":"1.12"},{"v":1.1664513315237488,"d":"1.17"},{"v":1.2172705504420867,"d":"1.22"},{"v":1.278880412337717,"d":"1.28"},{"v":1.3537276126102349,"d":"1.35"},{"v":1.4422604607294383,"d":"1.44"},null,"Inclinaison optimale",{"$f":"OFFSET(C11,0,MATCH(MIN(OFFSET(D11,MATCH(X14,OrientationT,0),0):OFFSET(V11,MATCH(X14,OrientationT,0),0)),OFFSET(D11,MATCH(X14,OrientationT,0),0):OFFSET(V11,MATCH(X14,OrientationT,0),0),0))","v":0},{"$f":"OFFSET(E11,0,MATCH(MIN(OFFSET(F11,MATCH(X14,OrientationT,0),0):OFFSET(V11,MATCH(X14,OrientationT,0),0)),OFFSET(F11,MATCH(X14,OrientationT,0),0):OFFSET(V11,MATCH(X14,OrientationT,0),0),0))","v":10}]
[]
["SurfUtile"]
[null,"S utile TI / S coll",1.2]
[null,"S utile TP/ S coll",3.35]
[]
["VecteurE",null,"TypeAppoint","Rdt combustion",null,"RdtUtil","Prod mixte","RdtUtil","ProdSep","Hypothèses pertes max. selon CD-Rom Energie +"]
[null,"Gaz naturel",{"$f":"VLOOKUP(\"A-Atmosferische ketel op aardgas\",Translations,LANG,FALSE)","v":"A-Chaudière atmosphérique au gaz"},{"v":0.78,"d":"78.0%"},0.78,{"v":0.6061626536453948,"d":"0.61"},{"$f":"($D27-$L$28)/(1+$L$29*($L$32*5800/1750-1))","v":{"v":0.6061626536453948,"d":"61%"}},{"$f":"($D27-$L$28)/(1+$L$29*($P$32*5800/1750-1))","v":{"v":0.6866297921037574,"d":"69%"}},{"v":0.6866297921037574,"d":"0.69"},null,null,"Anc. chaudières",null,"Nouv. chaudières",null,"Prod. Séparée"]
[null,"Mazout",{"$f":"VLOOKUP(\"B-Atmosferische ketel op stookolie\",Translations,LANG,FALSE)","v":"B-Chaudière atmosphérique au mazout"},{"v":0.78,"d":"78.0%"},0.78,{"v":0.6061626536453948,"d":"0.61"},{"$f":"($D28-$L$28)/(1+$L$29*($L$32*5800/1750-1))","v":{"v":0.6061626536453948,"d":"61%"}},{"$f":"($D28-$L$28)/(1+$L$29*($P$32*5800/1750-1))","v":{"v":0.6866297921037574,"d":"69%"}},{"v":0.6866297921037574,"d":"0.69"},"Pertes vers chaufferie :",null,{"v":0.06,"d":"6.0%"},null,{"v":0.03,"d":"3.0%"}]
[null,"Gaz naturel",{"$f":"VLOOKUP(\"C-Ketel HR PLUS\",Translations,LANG,FALSE)","v":"C-Chaudière HR PLUS"},{"v":0.886,"d":"88.6%"},0.89,{"v":0.6987708368412191,"d":"0.70"},{"$f":"($D29-$L$28)/(1+$L$29*($L$32*5800/1750-1))","v":{"v":0.6954032665431892,"d":"70%"}},{"$f":"($D29-$L$28)/(1+$L$29*($P$32*5800/1750-1))","v":{"v":0.7877169559412551,"d":"79%"}},{"v":0.791531565897387,"d":"0.79"},"Pertes à l'arrêt :",null,{"$f":"0.006+0.015","v":{"v":0.020999999999999998,"d":"2.1%"}},null,{"v":0.01,"d":"1.0%"}]
[null,"Gaz naturel",{"$f":"VLOOKUP(\"D-Ketel HR TOP (condensatie)\",Translations,LANG,FALSE)","v":"D-Chaudière HR TOP (condensation)"},{"$f":"0.963","v":{"v":0.963,"d":"96.3%"}},1.01,{"v":0.8995541568318909,"d":"0.90"},{"$f":"($D30-$N$28)/(1+$N$29*($N$32*5800/1750-1))","v":{"v":0.8832837435758722,"d":"88%"}},{"$f":"($D30-$N$28)/(1+$N$29*($P$32*5800/1750-1))","v":{"v":0.9118961184026808,"d":"91%"}},{"v":0.9578330075397934,"d":"0.96"}]
[null,"Mazout",{"$f":"VLOOKUP(\"E-OPTIMAZ-ketel van na 1999\",Translations,LANG,FALSE)","v":"E-Chaudière OPTIMAZ d'après 1999"},{"$f":" 0.842","v":{"v":0.842,"d":"84.2%"}},0.92,{"v":0.8169420403881459,"d":"0.82"},{"$f":"($D31-$N$28)/(1+$N$29*($N$32*5800/1750-1))","v":{"v":0.7687314038409521,"d":"77%"}},{"$f":"($D31-$N$28)/(1+$N$29*($P$32*5800/1750-1))","v":{"v":0.7936330633901144,"d":"79%"}},{"v":0.8698687517453225,"d":"0.87"}]
[null,"Mazout",{"$f":"VLOOKUP(\"F-OPTIMAZ-ketel van vóór 1999\",Translations,LANG,FALSE)","v":"F-Chaudière OPTIMAZ d'avant 1999"},{"$f":"0.8","v":{"v":0.8,"d":"80.0%"}},{"v":0.895,"d":"0.90"},{"v":0.7029802997137565,"d":"0.70"},{"$f":"($D32-$L$28)/(1+$L$29*($L$32*5800/1750-1))","v":{"v":0.6230005051355447,"d":"62%"}},{"$f":"($D32-$L$28)/(1+$L$29*($P$32*5800/1750-1))","v":{"v":0.7057028418844173,"d":"71%"}},{"v":0.796299828342552,"d":"0.80"},"Facteur surdimensionnement :",null,3,null,2,null,1]
[null,"Mazout",{"$f":"VLOOKUP(\"G-OPTIMAZ-ketel elite (condensatie)\",Translations,LANG,FALSE)","v":"G-Chaudière OPTIMAZ élite (condensation)"},{"$f":"0.925","v":{"v":0.925,"d":"92.5%"}},{"v":0.975,"d":"0.98"},{"v":0.8674272226593234,"d":"0.87"},{"$f":"($D33-$N$28)/(1+$N$29*($N$32*5800/1750-1))","v":{"v":0.8473086286177982,"d":"85%"}},{"$f":"($D33-$N$28)/(1+$N$29*($P$32*5800/1750-1))","v":{"v":0.8747556548450154,"d":"87%"}},{"v":0.9236246858419436,"d":"0.92"}]
[null,"Granulés de bois ",{"$f":"VLOOKUP(\"H-Pelletketel van minder dan 10 jaar oud\",Translations,LANG,FALSE)","v":"H-Chaudière pellets de moins de 10 ans"},{"v":0.94,"d":"94.0%"},{"v":0.931,"d":"0.93"},{"v":0.8270390768423813,"d":"0.83"},{"$f":"($D34-$N$28)/(1+$N$29*($N$32*5800/1750-1))","v":{"v":0.8615093318907221,"d":"86%"}},{"$f":"($D34-$N$28)/(1+$N$29*($P$32*5800/1750-1))","v":{"v":0.8894163641440938,"d":"89%"}},{"v":0.8806199385646468,"d":"0.88"}]
[null,"Granulés de bois ",{"$f":"VLOOKUP(\"I-Pelletketel van meer dan 10 jaar oud\",Translations,LANG,FALSE)","v":"I-Chaudière pellets de plus de 10 ans"},{"v":0.9,"d":"90.0%"},{"v":0.931,"d":"0.93"},{"v":0.7332884323960263,"d":"0.73"},{"$f":"($D35-$L$28)/(1+$L$29*($L$32*5800/1750-1))","v":{"v":0.7071897625862941,"d":"71%"}},{"$f":"($D35-$L$28)/(1+$L$29*($P$32*5800/1750-1))","v":{"v":0.801068090787717,"d":"80%"}},{"v":0.8306313179477398,"d":"0.83"}]
[null,"Electricité",{"$f":"VLOOKUP(\"J-Elektrische weerstand\",Translations,LANG,FALSE)","v":"J-Résistance électrique"},{"v":0.995,"d":"99.5%"},0.99,0.95,{"v":0.95,"d":"95%"},{"$f":"G36","v":{"v":0.95,"d":"95%"}},0.95]
[]
[]
["RdtInst",{"$nulls":3},1.09,{"$f":"E39-(E30-F30)","v":{"v":0.979554156831891,"d":"0.98"}}]
[{"$nulls":4},{"$f":"Tool!C46/100","v":0.9},{"$f":"(E40-E28)/(E39-E28)*(F39-F28)+F28","v":{"v":0.7507013000401674,"d":"0.75"}}]
[]
["UnitéConsoECS","liters/dag"]
[null,"m³/dag"]
[null,"m³/jaar",{"$nulls":19},"CONTRAINTE DE SURFACE EN TOITURE"]
[]
["ProfilHebdo",null,"Fsol","Scoll","Vstock","Nstock","Mstock","SurfStock","Qsol","CombEco","EprimEco","InvBrutHTVA","InvBrutTVAc","CoutOp","CoutCombEco","CoutCombEcoTVAc","CoutNetCombEco","CoutNetCombEcoTVAc","CO2Eco","CO2EcoLT","CoutCO2","Fsol","Scoll","Vstock","Nstock","Mstock","SurfStock","Qsol","CombEco","EprimEco","InvBrutHTVA","InvBrutTVAc","CoutOp","CoutCombEco","CoutCombEcoTVAc","CoutNetCombEco","CoutNetCombEcoTVAc","CO2Eco","CO2EcoLT","CoutCO2","JourPuis"]
[null,{"$f":"VLOOKUP(\"A-7 dagen op 7 gedurende het hele jaar\",Translations,LANG,FALSE)","v":"A-7 jours sur 7 toute l'année"},{"$f":"'A-7sur7'!B35","v":{"v":0.340619851370694,"d":"0.34"}},{"$f":"'A-7sur7'!D5*Tool!$H$26","v":{"v":23.011200416981982,"d":"23.0"}},{"$f":"'A-7sur7'!B14","v":{"v":1.3226917808219179,"d":"1.3"}},{"$f":"'A-7sur7'!B12","v":1},{"$f":"ROUNDUP('A-7sur7'!B15,-2)","v":1700},{"$f":"ROUNDUP('A-7sur7'!B16,1)","v":1.6},{"$f":"'A-7sur7'!B10","v":{"v":9903.522178602929,"d":"9,904"}},{"$f":"'A-7sur7'!D33","v":{"v":13192.360500871684,"d":"13,192"}},{"$f":"'A-7sur7'!B34","v":{"v":12748.547093846051,"d":"12,749"}},{"$f":"'A-7sur7'!B23*Tool!$H$26","v":{"v":30760.590011548156,"d":"30,761"}},{"$f":"L47+(L47*Tool!$H$15)","v":{"v":37220.31391397327,"d":"37,220"}},{"$f":"'A-7sur7'!B26","v":86.02691107867767},{"$f":"'A-7sur7'!B36","v":{"v":0.07267326125151749,"d":"0.073"}},{"$f":"'A-7sur7'!B37","v":{"v":0.08793464611433617,"d":"0.088"}},{"$f":"'A-7sur7'!B38","v":0.07267326125151749},{"$f":"'A-7sur7'!B39","v":0.08793464611433617},{"$f":"'A-7sur7'!B40/1000","v":{"v":2.766434719364593,"d":"2.8"}},{"$f":"'A-7sur7'!B41","v":{"v":69.16086798411483,"d":"69"}},{"$f":"'A-7sur7'!B42","v":{"v":346.55864260706426,"d":"347"}},{"$f":"'A-7sur7'!H35","v":{"$error":"#VALUE!"}},{"$f":"'A-7sur7'!H5","v":""},{"$f":"'A-7sur7'!H14","v":{"$error":"#VALUE!"}},null,{"$f":"ROUNDUP('A-7sur7'!H15,-2)","v":{"$error":"#VALUE!"}},{"$f":"ROUNDUP('A-7sur7'!H16,1)","v":{"$error":"#VALUE!"}},{"$f":"'A-7sur7'!H10","v":{"$error":"#VALUE!"}},{"$f":"'A-7sur7'!J33","v":{"$error":"#VALUE!"}},{"$f":"'A-7sur7'!H34","v":{"$error":"#VALUE!"}},{"$f":"'A-7sur7'!H23","v":{"$error":"#VALUE!"}},{"$f":"AE47+(AE47*Tool!$H$15)","v":{"$error":"#VALUE!"}},{"$f":"'A-7sur7'!H26","v":{"$error":"#VALUE!"}},{"$f":"'A-7sur7'!H36","v":{"$error":"#VALUE!"}},{"$f":"'A-7sur7'!H37","v":{"$error":"#VALUE!"}},{"$f":"'A-7sur7'!H38","v":{"$error":"#VALUE!"}},{"$f":"'A-7sur7'!H39","v":{"$error":"#VALUE!"}},{"$f":"'A-7sur7'!H40/1000","v":{"$error":"#VALUE!"}},{"$f":"'A-7sur7'!H41","v":{"$error":"#VALUE!"}},{"$f":"'A-7sur7'!H42","v":{"$error":"#VALUE!"}},{"$f":"'A-7sur7'!B2","v":365}]
[null,{"$f":"VLOOKUP(\"B-5 dagen op 7 gedurende het hele jaar\",Translations,LANG,FALSE)","v":"B-5 jours sur 7 toute l'année"},{"$f":"'B-5sur7'!B35","v":{"v":0.4637016279004979,"d":"0.46"}},{"$f":"'B-5sur7'!D5*Tool!$H$26","v":{"v":33.505990414829824,"d":"33.5"}},{"$f":"'B-5sur7'!B14","v":{"v":1.8392,"d":"1.8"}},{"$f":"'B-5sur7'!B12","v":1},{"$f":"ROUNDUP('B-5sur7'!B15,-2)","v":2300},{"$f":"ROUNDUP('B-5sur7'!B16,1)","v":2},{"$f":"'B-5sur7'!B10","v":{"v":13482.124831206978,"d":"13,482"}},{"$f":"'B-5sur7'!D33","v":{"v":17959.373229386434,"d":"17,959"}},{"$f":"'B-5sur7'!B34","v":{"v":17313.14845656669,"d":"17,313"}},{"$f":"'B-5sur7'!B23*Tool!$H$26","v":{"v":42045.29633899309,"d":"42,045"}},{"$f":"L48+(L48*Tool!$H$15)","v":{"v":50874.80857018164,"d":"50,875"}},{"$f":"'B-5sur7'!B26","v":119.91551555339413},{"$f":"'B-5sur7'!B36","v":{"v":0.07296737803091355,"d":"0.073"}},{"$f":"'B-5sur7'!B37","v":{"v":0.08829052741740538,"d":"0.088"}},{"$f":"'B-5sur7'!B38","v":0.07296737803091355},{"$f":"'B-5sur7'!B39","v":0.08829052741740538},{"$f":"'B-5sur7'!B40/1000","v":{"v":3.756953215074972,"d":"3.8"}},{"$f":"'B-5sur7'!B41","v":{"v":93.92383037687429,"d":"94"}},{"$f":"'B-5sur7'!B42","v":{"v":348.80614705785155,"d":"349"}},{"$f":"'B-5sur7'!H35","v":{"$error":"#VALUE!"}},{"$f":"'B-5sur7'!H5","v":""},{"$f":"'B-5sur7'!H14","v":{"$error":"#VALUE!"}},null,{"$f":"ROUNDUP('B-5sur7'!H15,-2)","v":{"$error":"#VALUE!"}},{"$f":"ROUNDUP('B-5sur7'!H16,1)","v":{"$error":"#VALUE!"}},{"$f":"'B-5sur7'!H10","v":{"$error":"#VALUE!"}},{"$f":"'B-5sur7'!J33","v":{"$error":"#VALUE!"}},{"$f":"'B-5sur7'!H34","v":{"$error":"#VALUE!"}},{"$f":"'B-5sur7'!H23","v":{"$error":"#VALUE!"}},{"$f":"AE48+(AE48*Tool!$H$15)","v":{"$error":"#VALUE!"}},{"$f":"'B-5sur7'!H26","v":{"$error":"#VALUE!"}},{"$f":"'B-5sur7'!H36","v":{"$error":"#VALUE!"}},{"$f":"'B-5sur7'!H37","v":{"$error":"#VALUE!"}},{"$f":"'B-5sur7'!H38","v":{"$error":"#VALUE!"}},{"$f":"'B-5sur7'!H39","v":{"$error":"#VALUE!"}},{"$f":"'B-5sur7'!H40/1000","v":{"$error":"#VALUE!"}},{"$f":"'B-5sur7'!H41","v":{"$error":"#VALUE!"}},{"$f":"'B-5sur7'!H42","v":{"$error":"#VALUE!"}},{"$f":"'B-5sur7'!B2","v":261}]
[null,{"$f":"VLOOKUP(\"C-5 dagen op 7 uitgezonderd schoolvakanties\",Translations,LANG,FALSE)","v":"C-5 jours sur 7 hors vacances scolaires"},{"$f":"'C-5sur7HVS'!B35","v":{"v":0.4109567341323122,"d":"0.41"}},{"$f":"'C-5sur7HVS'!D5*Tool!$H$26","v":{"v":39.23203410654963,"d":"39.2"}},{"$f":"'C-5sur7HVS'!B14","v":{"v":1.9848342465753424,"d":"2.0"}},{"$f":"'C-5sur7HVS'!B12","v":1},{"$f":"ROUNDUP('C-5sur7HVS'!B15,-2)","v":2500},{"$f":"ROUNDUP('C-5sur7HVS'!B16,1)","v":2.1},{"$f":"'C-5sur7HVS'!B10","v":{"v":11948.567044896978,"d":"11,949"}},{"$f":"'C-5sur7HVS'!D33","v":{"v":15916.539699954761,"d":"15,917"}},{"$f":"'C-5sur7HVS'!B34","v":{"v":15159.877622103142,"d":"15,160"}},{"$f":"'C-5sur7HVS'!B23*Tool!$H$26","v":{"v":47619.689032792216,"d":"47,620"}},{"$f":"L49+(L49*Tool!$H$15)","v":{"v":57619.82372967858,"d":"57,620"}},{"$f":"'C-5sur7HVS'!B26","v":137.27045892713292},{"$f":"'C-5sur7HVS'!B36","v":{"v":0.0932481871236647,"d":"0.093"}},{"$f":"'C-5sur7HVS'!B37","v":{"v":0.11283030641963429,"d":"0.113"}},{"$f":"'C-5sur7HVS'!B38","v":0.0932481871236647},{"$f":"'C-5sur7HVS'!B39","v":0.11283030641963429},{"$f":"'C-5sur7HVS'!B40/1000","v":{"v":3.289693443996382,"d":"3.3"}},{"$f":"'C-5sur7HVS'!B41","v":{"v":82.24233609990955,"d":"82"}},{"$f":"'C-5sur7HVS'!B42","v":{"v":451.1631547344422,"d":"451"}},{"$f":"'C-5sur7HVS'!H35","v":{"$error":"#VALUE!"}},{"$f":"'C-5sur7HVS'!H5","v":""},{"$f":"'C-5sur7HVS'!H14","v":{"$error":"#VALUE!"}},null,{"$f":"ROUNDUP('C-5sur7HVS'!H15,-2)","v":{"$error":"#VALUE!"}},{"$f":"ROUNDUP('C-5sur7HVS'!H16,1)","v":{"$error":"#VALUE!"}},{"$f":"'C-5sur7HVS'!H10","v":{"$error":"#VALUE!"}},{"$f":"'C-5sur7HVS'!J33","v":{"$error":"#VALUE!"}},{"$f":"'C-5sur7HVS'!H34","v":{"$error":"#VALUE!"}},{"$f":"'C-5sur7HVS'!H23","v":{"$error":"#VALUE!"}},{"$f":"AE49+(AE49*Tool!$H$15)","v":{"$error":"#VALUE!"}},{"$f":"'C-5sur7HVS'!H26","v":{"$error":"#VALUE!"}},{"$f":"'C-5sur7HVS'!H36","v":{"$error":"#VALUE!"}},{"$f":"'C-5sur7HVS'!H37","v":{"$error":"#VALUE!"}},{"$f":"'C-5sur7HVS'!H38","v":{"$error":"#VALUE!"}},{"$f":"'C-5sur7HVS'!H39","v":{"$error":"#VALUE!"}},{"$f":"'C-5sur7HVS'!H40/1000","v":{"$error":"#VALUE!"}},{"$f":"'C-5sur7HVS'!H41","v":{"$error":"#VALUE!"}},{"$f":"'C-5sur7HVS'!H42","v":{"$error":"#VALUE!"}},{"$f":"'C-5sur7HVS'!B2","v":200}]
[null,{"$f":"VLOOKUP(\"D-7 dagen op 7 uitgezonderd schoolvakanties\",Translations,LANG,FALSE)","v":"D-7 jours sur 7 hors vacances scolaires"},{"$f":"'D-7sur7HVS'!B35","v":{"v":0.30327443034975804,"d":"0.30"}},{"$f":"'D-7sur7HVS'!D5*Tool!$H$26","v":{"v":23.903099587185757,"d":"23.9"}},{"$f":"'D-7sur7HVS'!B14","v":{"v":1.292517808219178,"d":"1.3"}},{"$f":"'D-7sur7HVS'!B12","v":1},{"$f":"ROUNDUP('D-7sur7HVS'!B15,-2)","v":1600},{"$f":"ROUNDUP('D-7sur7HVS'!B16,1)","v":1.6},{"$f":"'D-7sur7HVS'!B10","v":{"v":8817.704062419216,"d":"8,818"}},{"$f":"'D-7sur7HVS'!D33","v":{"v":11745.955497809062,"d":"11,746"}},{"$f":"'D-7sur7HVS'!B34","v":{"v":11284.94017161891,"d":"11,285"}},{"$f":"'D-7sur7HVS'!B23*Tool!$H$26","v":{"v":31539.214218015804,"d":"31,539"}},{"$f":"L50+(L50*Tool!$H$15)","v":{"v":38162.44920379912,"d":"38,162"}},{"$f":"'D-7sur7HVS'!B26","v":88.5555067248964},{"$f":"'D-7sur7HVS'!B36","v":{"v":0.08368835221699038,"d":"0.084"}},{"$f":"'D-7sur7HVS'!B37","v":{"v":0.10126290618255836,"d":"0.101"}},{"$f":"'D-7sur7HVS'!B38","v":0.08368835221699038},{"$f":"'D-7sur7HVS'!B39","v":0.10126290618255836},{"$f":"'D-7sur7HVS'!B40/1000","v":{"v":2.4488320172413034,"d":"2.4"}},{"$f":"'D-7sur7HVS'!B41","v":{"v":61.22080043103258,"d":"61"}},{"$f":"'D-7sur7HVS'!B42","v":{"v":401.4157173316951,"d":"401"}},{"$f":"'D-7sur7HVS'!H35","v":{"$error":"#VALUE!"}},{"$f":"'D-7sur7HVS'!H5","v":""},{"$f":"'D-7sur7HVS'!H14","v":{"$error":"#VALUE!"}},null,{"$f":"ROUNDUP('D-7sur7HVS'!H15,-2)","v":{"$error":"#VALUE!"}},{"$f":"ROUNDUP('D-7sur7HVS'!H16,1)","v":{"$error":"#VALUE!"}},{"$f":"'D-7sur7HVS'!H10","v":{"$error":"#VALUE!"}},{"$f":"'D-7sur7HVS'!J33","v":{"$error":"#VALUE!"}},{"$f":"'D-7sur7HVS'!H34","v":{"$error":"#VALUE!"}},{"$f":"'D-7sur7HVS'!H23","v":{"$error":"#VALUE!"}},{"$f":"AE50+(AE50*Tool!$H$15)","v":{"$error":"#VALUE!"}},{"$f":"'D-7sur7HVS'!H26","v":{"$error":"#VALUE!"}},{"$f":"'D-7sur7HVS'!H36","v":{"$error":"#VALUE!"}},{"$f":"'D-7sur7HVS'!H37","v":{"$error":"#VALUE!"}},{"$f":"'D-7sur7HVS'!H38","v":{"$error":"#VALUE!"}},{"$f":"'D-7sur7HVS'!H39","v":{"$error":"#VALUE!"}},{"$f":"'D-7sur7HVS'!H40/1000","v":{"$error":"#VALUE!"}},{"$f":"'D-7sur7HVS'!H41","v":{"$error":"#VALUE!"}},{"$f":"'D-7sur7HVS'!H42","v":{"$error":"#VALUE!"}},{"$f":"'D-7sur7HVS'!B2","v":304}]
[null,null,"%","m²","m³",null,"kg","m²",{"$f":"VLOOKUP(\"kWh/jaar\",Translations,LANG, FALSE)","v":"kWh/an"},{"$f":"LOOKUP(Calculs!B17,SourceEnergie,UnitéConsoAn)","v":"kWh/an"},{"$f":"VLOOKUP(\"kWh/jaar\",Translations,LANG, FALSE)","v":"kWh/an"},{"$f":"VLOOKUP(\"EUR BTW excl\",Translations,LANG, FALSE)","v":"EUR HTVA"},{"$f":"VLOOKUP(\"EUR BTW incl\",Translations,LANG, FALSE)","v":"EUR TVAc"},{"$f":"VLOOKUP(\"EUR BTW excl\",Translations,LANG, FALSE)","v":"EUR HTVA"},{"$f":"VLOOKUP(\"EUR/kWh BTW excl\",Translations,LANG, FALSE)","v":"EUR/kWh HTVA"},{"$f":"VLOOKUP(\"EUR/kWh BTW incl\",Translations,LANG, FALSE)","v":"EUR/kWh TVAc"},{"$f":"VLOOKUP(\"EUR/kWh BTW excl\",Translations,LANG, FALSE)","v":"EUR/kWh HTVA"},{"$f":"VLOOKUP(\"EUR/kWh BTW incl\",Translations,LANG, FALSE)","v":"EUR/kWh TVAc"},{"$f":"VLOOKUP(\"ton/jaar\",Translations,LANG, FALSE)","v":"tonnes/an"},{"$f":"VLOOKUP(\"ton\",Translations,LANG, FALSE)","v":"tonne"},{"$f":"\"EUR/\" & VLOOKUP(\"ton\",Translations,LANG, FALSE)","v":"EUR/tonne"},"%","m²","m³",null,"kg","m²","kWh/jaar",{"$f":"LOOKUP(Calculs!B17,SourceEnergie,UnitéConsoAn)","v":"kWh/an"},"kWh/jaar","EUR BTW excl","EUR BTW incl","EUR BTW excl","EUR/kWh BTW excl","EUR/kWh BTW incl","EUR/kWh BTW excl","EUR/kWh BTW incl","ton/jaar","ton","EUR/ton","jours"]
[]
["Temp_ECS","°C"]
[null,35]
[null,40]
[null,45]
[null,50]
[null,55]
[null,60]
[null,65]
[null,70]
[]
["Temp_EFR",10]
[]
["M Stock/ Vol Stock","kg/l"]
[null,1.2]

{"sheet":"Energy Data","index":8,"n_rows":38,"n_cols":9,"rows_kept":38,"hidden":true}
[]
["UnitéComb","kWh/an"]
[null,"l/an"]
[null,"m³/an"]
[null,"t/an"]
["Conversion Unités"]
[null,1,"GJ ",{"v":277.77777778,"d":"277.78"},"kWh"]
[null,1,"MJ ",{"v":0.27777777778,"d":"0.28"},"kWh"]
[null,1,"kWh ",{"v":3.6,"d":"3.60"},"MJ"]
[null,1,"kcal",1.163,"Wh"]
[]
["Pouvoir calorifique combustible "]
["Vecteur","PCI","unité","CO2 sur PCI","unité"]
["Butane",12.72,"kWh/kg"]
["Butane",45.73,"MJ/kg",65.9,"kg/GJ"]
["Butane",26.52,"MJ/l"]
["Électricité (RBC)",{"v":3.6,"d":"3.60"},"MJ/kWh",0.395,"kg/kWh"]
["Électricité (RW)",{"v":3.6,"d":"3.60"},"MJ/kWh",0.456,"kg/kWh"]
["Fuel domestique   ",9.94,"kWh/l",0.306,"kg/kWh",0.264]
[null,35.87,"MJ/l"]
[null,10.75,"kWh/m³",0.251,"kg/kWh",0.198]
["Gaz naturel H (RW)",{"$f":"B21*D9","v":{"v":38.7,"d":"38.70"}},"MJ/m³"]
["Gaz naturel H (RW)",{"$f":"B22/B21","v":{"v":3.6,"d":"3.60"}},"MJ/kWh"]
["Gaz naturel L (RBC)",9.25,"kWh/m³",0.217,"kg/kWh",{"$nulls":3}," "]
["Gaz naturel L (RBC)",{"$f":"B24*D9","v":{"v":33.300000000000004,"d":"33.30"}},"MJ/m³"]
["Gaz naturel L (RBC)",{"$f":"B25/B24","v":{"v":3.6000000000000005,"d":"3.60"}},"MJ/kWh",{"$nulls":5}," "]
["Houille (charbon)  ",8.14,"kWh/kg",0.385,"kg/kWh"]
["Pellets",{"$f":"AVERAGE(4.9,5.4)","v":5.15},"kWh/kg",{"v":0.03,"d":"0.030"},"kg/kWh"]
["Propane   ",12.87,"kWh/kg",{"v":0.24,"d":"0.240"},"kg/kWh"]
["Propane   ",6.59,"kWh/l"]
["Propane   ",46.35,"MJ/kg",64.9,"kg/GJ"]
["Propane   ",23.72,"MJ/l"]
[]
["Masse volumique"]
["butane",580,"kg/m³"]
["propane",510,"kg/m³"]
[]
["Rendement du parc de production d'électricité",{"$f":"0.404","v":0.404}]

{"sheet":"Eco Data","index":9,"n_rows":48,"n_cols":28,"rows_kept":48,"hidden":true,"merged":[[22,15,22,19]]}
[]
["SourceEnergie","UnitéConsoAn ","RdtUtilAtm","RdtUtilOld","RdtUtilNew","RdtUtilCond","PCI","Unité PCI","FactConv MJ","(MJ/unité)","FactConvEprim","FactEmis","unité","Emission CO2","unité","Prix HTVA (2012-S1)","UnitéPrix","PrixDéfaut","UnitéPrixDéfaut HTVA","PrixDéfautTVAc","UnitéPrixDéfaut TVAc","Facteur conversion defaut/kWh","Prix_kWh","UnitéPrix_kWh","Prix_kWh_TVAc","UnitéPrix_kWh_TVAc","Prix moyen hyp High BFP [EUR/kWh]","EvoluPxE"]
[{"$f":"VLOOKUP(\"1-Elektriciteit (BHG)\",Translations,LANG,FALSE)","v":"1-Electricité (RBC)"},{"$f":"VLOOKUP(\"kWh/jaar\",Translations,LANG,FALSE)","v":"kWh/an"},{"$f":"'Tech Data'!G27","v":{"v":0.6061626536453948,"d":"0.61"}},{"$f":"'Tech Data'!G27","v":{"v":0.6061626536453948,"d":"0.61"}},{"$f":"'Tech Data'!G27","v":{"v":0.6061626536453948,"d":"0.61"}},{"$f":"'Tech Data'!G27","v":{"v":0.6061626536453948,"d":"0.61"}},{"$f":"'Energy Data'!B17","v":{"v":3.6,"d":"3.60"}},"MJ/kWh",{"$f":"'Energy Data'!B17/'Energy Data'!B38","v":{"v":8.91089108910891,"d":"8.9"}},"MJ/kWh",{"$f":"'Energy Data'!B38","v":{"v":0.404,"d":"0.40"}},{"$f":"'Energy Data'!D17","v":0.395},"kg/kWh",{"$f":"L3","v":0.395},"kg/kwh",0.1456,"EUR/kWh",{"$f":"P3","v":0.1456},{"$f":"VLOOKUP(\"EUR/kWh BTW excl\",Translations,LANG,FALSE)","v":"EUR/kWh HTVA"},{"$f":"R3*1.21","v":{"v":0.176176,"d":"0.1762"}},{"$f":"VLOOKUP(\"EUR/kWh BTW incl\",Translations,LANG,FALSE)","v":"EUR/kWh TVAc"},{"v":1,"d":"1.000"},{"$f":"V3*R3","v":0.1456},{"$f":"VLOOKUP(\"EUR/kWh BTW excl\",Translations,LANG,FALSE)","v":"EUR/kWh HTVA"},{"$f":"W3*1.21","v":{"v":0.176176,"d":"0.1762"}},{"$f":"VLOOKUP(\"EUR/kWh BTW incl\",Translations,LANG,FALSE)","v":"EUR/kWh TVAc"},{"$f":"W3*((1+Hyp!D2)^25)/2","v":{"v":0.30300807774624966,"d":"0.30"}},{"$f":"Hyp!D2","v":0.0587}]
[{"$f":"VLOOKUP(\"2-Electriciteit (WG)\",Translations,LANG,FALSE)","v":"2-Electricité (RW)"},{"$f":"VLOOKUP(\"kWh/jaar\",Translations,LANG,FALSE)","v":"kWh/an"},{"$f":"'Tech Data'!G27","v":{"v":0.6061626536453948,"d":"0.61"}},{"$f":"'Tech Data'!G27","v":{"v":0.6061626536453948,"d":"0.61"}},{"$f":"'Tech Data'!G27","v":{"v":0.6061626536453948,"d":"0.61"}},{"$f":"'Tech Data'!G27","v":{"v":0.6061626536453948,"d":"0.61"}},{"$f":"'Energy Data'!B18","v":{"v":3.6,"d":"3.60"}},"MJ/kWh",{"$f":"I3","v":{"v":8.91089108910891,"d":"8.9"}},"MJ/kWh",{"$f":"K3","v":{"v":0.404,"d":"0.40"}},{"$f":"'Energy Data'!D18","v":0.456},"kg/kWh",{"$f":"L4","v":0.456},"kg/kwh",0.1456,"EUR/kWh",{"$f":"P4","v":0.1456},{"$f":"VLOOKUP(\"EUR/kWh BTW excl\",Translations,LANG,FALSE)","v":"EUR/kWh HTVA"},{"$f":"R4*1.21","v":{"v":0.176176,"d":"0.1762"}},{"$f":"VLOOKUP(\"EUR/kWh BTW incl\",Translations,LANG,FALSE)","v":"EUR/kWh TVAc"},{"v":1,"d":"1.000"},0.1456,"EUR/kWh HTVA",{"v":0.176176,"d":"0.1762"},"EUR/kWh TVAc",{"$f":"W4*((1+Hyp!D2)^25)/2","v":{"v":0.30300807774624966,"d":"0.30"}},{"$f":"Hyp!D2","v":0.0587}]
[{"$f":"VLOOKUP(\"3-Aardgas (BHG)\",Translations,LANG,FALSE)","v":"3-Gaz naturel (RBC)"},{"$f":"VLOOKUP(\"kWh/jaar\",Translations,LANG,FALSE)","v":"kWh/an"},{"$f":"'Tech Data'!G28","v":{"v":0.6061626536453948,"d":"0.61"}},{"$f":"'Tech Data'!G28","v":{"v":0.6061626536453948,"d":"0.61"}},{"$f":"'Tech Data'!G29","v":{"v":0.6954032665431892,"d":"0.70"}},{"$f":"'Tech Data'!G30","v":{"v":0.8832837435758722,"d":"0.88"}},{"$f":"'Energy Data'!B24","v":9.25},"kWh/m³",{"$f":"'Energy Data'!B26","v":{"v":3.6000000000000005,"d":"3.6"}},"MJ/kWh",{"v":1,"d":"1.00"},{"$f":"'Energy Data'!D24","v":0.217},"kg/kWh",{"$f":"L5*'Energy Data'!B24","v":{"v":2.00725,"d":"2.007"}},"kg/m³",0.0555,"EUR/kWh",{"$f":"P5","v":0.0555},{"$f":"VLOOKUP(\"EUR/kWh BTW excl\",Translations,LANG,FALSE)","v":"EUR/kWh HTVA"},{"$f":"R5*1.21","v":{"v":0.06715499999999999,"d":"0.0672"}},{"$f":"VLOOKUP(\"EUR/kWh BTW incl\",Translations,LANG,FALSE)","v":"EUR/kWh TVAc"},{"$f":"3.6/I5","v":{"v":0.9999999999999999,"d":"1.000"}},{"v":0.055499999999999994,"d":"0.0555"},"EUR/kWh HTVA",{"v":0.06715499999999999,"d":"0.0672"},"EUR/kWh TVAc",{"$f":"W5*((1+Hyp!D3)^25)/2","v":{"v":0.11550101864640695,"d":"0.12"}},{"$f":"Hyp!D3","v":0.0587}]
[{"$f":"VLOOKUP(\"4-Aardgas (WG)\",Translations,LANG,FALSE)","v":"4-Gaz naturel (RW)"},{"$f":"VLOOKUP(\"kWh/jaar\",Translations,LANG,FALSE)","v":"kWh/an"},{"$f":"'Tech Data'!G28","v":{"v":0.6061626536453948,"d":"0.61"}},{"$f":"'Tech Data'!G28","v":{"v":0.6061626536453948,"d":"0.61"}},{"$f":"'Tech Data'!G29","v":{"v":0.6954032665431892,"d":"0.70"}},{"$f":"'Tech Data'!G30","v":{"v":0.8832837435758722,"d":"0.88"}},{"$f":"'Energy Data'!B21","v":10.75},"kWh/m³",{"$f":"'Energy Data'!B23","v":3.6},{"$f":"J3","v":"MJ/kWh"},{"v":1,"d":"1.00"},{"$f":"'Energy Data'!D21","v":0.251},{"$f":"M3","v":"kg/kWh"},{"$f":"L6*'Energy Data'!B21","v":{"v":2.69825,"d":"2.698"}},"kg/m³",0.0555,{"$f":"Q3","v":"EUR/kWh"},{"$f":"P6","v":0.0555},{"$f":"VLOOKUP(\"EUR/kWh BTW excl\",Translations,LANG,FALSE)","v":"EUR/kWh HTVA"},{"$f":"R6*1.21","v":{"v":0.06715499999999999,"d":"0.0672"}},{"$f":"VLOOKUP(\"EUR/kWh BTW incl\",Translations,LANG,FALSE)","v":"EUR/kWh TVAc"},{"$f":"V3","v":{"v":1,"d":"1.000"}},0.0555,"EUR/kWh HTVA",{"v":0.06715499999999999,"d":"0.0672"},"EUR/kWh TVAc",{"$f":"W6*((1+Hyp!D3)^25)/2","v":{"v":0.11550101864640697,"d":"0.12"}},{"$f":"Hyp!D3","v":0.0587}]
[{"$f":"VLOOKUP(\"5-Houtpellets\",Translations,LANG,FALSE)","v":"5-Granulés de bois "},{"$f":"VLOOKUP(\"ton/jaar\",Translations,LANG,FALSE)","v":"tonnes/an"},{"$f":"'Tech Data'!G31","v":{"v":0.7687314038409521,"d":"0.77"}},{"$f":"'Tech Data'!G31","v":{"v":0.7687314038409521,"d":"0.77"}},{"$f":"'Tech Data'!G32","v":{"v":0.6230005051355447,"d":"0.62"}},{"$f":"'Tech Data'!G32","v":{"v":0.6230005051355447,"d":"0.62"}},{"$f":"'Energy Data'!B28","v":5.15},"kWh/kg",{"$f":"'Energy Data'!B28*'Energy Data'!D9","v":{"v":18.540000000000003,"d":"18.5"}},"MJ/kg",{"v":1,"d":"1.00"},{"$f":"'Energy Data'!D28","v":{"v":0.03,"d":"0.030"}},"kg/kWh",{"$f":"L7","v":{"v":0.03,"d":"0.030"}},"kg/kWh",{"$f":"R7/('Energy Data'!B28*1000)","v":{"v":0.04219331989985956,"d":"0.0422"}},"EUR/kWh",{"$f":"T7/1.06","v":{"v":217.29559748427673,"d":"217.2956"}},{"$f":"VLOOKUP(\"EUR/ton BTW excl\",Translations,LANG,FALSE)","v":"EUR/tonne HTVA"},{"$f":"AVERAGE(200,241,250)","v":{"v":230.33333333333334,"d":"230.3333"}},{"$f":"VLOOKUP(\"EUR/ton BTW incl\",Translations,LANG,FALSE)","v":"EUR/tonne TVAc"},{"$f":"1/('Energy Data'!B28*1000)","v":{"v":1.9417475728155341E-4,"d":"0.000"}},{"v":0.04219331989985956,"d":"0.0422"},"EUR/kWh HTVA",{"v":0.05105391707883007,"d":"0.0511"},"EUR/kWh TVAc",{"$f":"W7*((1+Hyp!D5)^25)/2","v":{"v":0.047045351797547465,"d":"0.05"}},{"$f":"Hyp!D5","v":0.0326}]
[{"$f":"VLOOKUP(\"6-Stookolie\",Translations,LANG,FALSE)","v":"6-Mazout"},{"$f":"VLOOKUP(\"l stookolie/jaar\",Translations,LANG,FALSE)","v":"l mazout/an"},{"$f":"'Tech Data'!G33","v":{"v":0.8473086286177982,"d":"0.85"}},{"$f":"'Tech Data'!G34","v":{"v":0.8615093318907221,"d":"0.86"}},{"$f":"'Tech Data'!G35","v":{"v":0.7071897625862941,"d":"0.71"}},{"$f":"'Tech Data'!G36","v":0.95},{"$f":"'Energy Data'!B19","v":9.94},"kWh/l",{"$f":"'Energy Data'!B20","v":{"v":35.87,"d":"35.9"}},"MJ/l",{"v":1,"d":"1.00"},{"$f":"'Energy Data'!D19","v":0.306},"kg/kWh",{"$f":"L8*'Energy Data'!B19","v":{"v":3.0416399999999997,"d":"3.042"}},"kg/l",{"$f":"T8/1.21","v":{"v":0.7382920110192837,"d":"0.7383"}},{"$f":"VLOOKUP(\"EUR/liter\",Translations,LANG,FALSE)","v":"EUR/litre"},{"$f":"P8","v":{"v":0.7382920110192837,"d":"0.7383"}},{"$f":"VLOOKUP(\"EUR/liter BTW excl\",Translations,LANG,FALSE)","v":"EUR/litre HTVA"},{"$f":"T40","v":{"v":0.8933333333333332,"d":"0.8933"}},{"$f":"VLOOKUP(\"EUR/liter BTW incl\",Translations,LANG,FALSE)","v":"EUR/litre TVAc"},{"$f":"1/'Energy Data'!B19","v":{"v":0.1006036217303823,"d":"0.101"}},{"v":0.07427485020314725,"d":"0.0743"},"EUR/kWh HTVA",{"v":0.08987256874580818,"d":"0.0899"},"EUR/kWh TVAc",{"$f":"W8*((1+Hyp!D4)^25)/2","v":{"v":0.08281610609950683,"d":"0.08"}},{"$f":"Hyp!D4","v":0.0326}]
[]
[null,null,"Default Price [EUR/kWh]","Prix moyen hyp High BFP [EUR/kWh]","Prix moyen hyp IBGE [EUR/kWh]"]
["EvoluPxE","Electricité ",{"$f":"W3","v":0.1456},{"$f":"$C11*((1+Hyp!D2)^25)/2","v":{"v":0.30300807774624966,"d":"0.3030"}},{"$f":"$C11*((1+Hyp!F2)^25)/2","v":{"v":0.30300807774624966,"d":"0.3030"}}]
[null,"Gaz",{"$f":"W5","v":{"v":0.055499999999999994,"d":"0.0555"}},{"$f":"C12*((1+Hyp!D3)^25)/2","v":{"v":0.11550101864640695,"d":"0.1155"}},{"$f":"$C12*((1+Hyp!F3)^25)/2","v":{"v":0.11550101864640695,"d":"0.1155"}}]
[null,"Granulés de bois",{"$f":"W7","v":{"v":0.04219331989985956,"d":"0.0422"}},{"$f":"C13*((1+Hyp!D5)^25)/2","v":{"v":0.047045351797547465,"d":"0.0470"}},{"$f":"$C13*((1+Hyp!F5)^25)/2","v":{"v":0.047045351797547465,"d":"0.0470"}}]
[null,"Mazout",{"$f":"W8","v":{"v":0.07427485020314725,"d":"0.0743"}},{"$f":"C14*((1+Hyp!D4)^25)/2","v":{"v":0.08281610609950683,"d":"0.0828"}},{"$f":"$C14*((1+Hyp!F4)^25)/2","v":{"v":0.08281610609950683,"d":"0.0828"}}]
[]
["TVA",{"v":0,"d":"0%"},{"v":0,"d":"0.00"},{"$f":"VLOOKUP(\"EUR BTW excl\",Translations,LANG,FALSE)","v":"EUR HTVA"},{"$f":"VLOOKUP(\"EUR/jaar BTW excl\",Translations,LANG,FALSE)","v":"EUR/an HTVA"}]
[null,{"v":0.06,"d":"6%"},0.06,{"$f":"VLOOKUP(\"EUR BTW incl\",Translations,LANG,FALSE)","v":"EUR TVAc"},{"$f":"VLOOKUP(\"EUR/jaar BTW incl\",Translations,LANG,FALSE)","v":"EUR/an TVAc"}]
[null,{"v":0.21,"d":"21%"},0.21,{"$f":"VLOOKUP(\"EUR BTW incl\",Translations,LANG,FALSE)","v":"EUR TVAc"},{"$f":"VLOOKUP(\"EUR/jaar BTW incl\",Translations,LANG,FALSE)","v":"EUR/an TVAc"}]
[]
["Inv Eco E",{"v":0.4,"d":"40%"},3600,"EUR"]
[]
[]
[{"$nulls":15},"Tarif officiel moyen des produits pétroliers en EURO, derniers 24 mois"]
["PxMoyenE","Année","Mazout (FPB)","Mazout (FPB)","Mazout (Informazout)","GN RBC",null,"Contenu énergétique équivalent",{"$nulls":7},"SPF Economie Statistics Belgium","Gasoil Extra",null,"Gasoil de chauffage"]
[null,null,"EUR/l HTVA","EUR/l TVAC","EUR/l TVAC","EUR/kWh TVAC",null,2000,"l","mazout",{"$nulls":6},"Gasoil chauffage","Gasoil chauffage","Gasoil chauffage","Gasoil chauffage"]
[null,1988,0.149,0.1745,{"$nulls":3},{"$f":"H25*11.864","v":23728},"kWh","GN",{"$nulls":6},"Extra (plus de 2000 l) (€/L)","Extra (moins de 2000 l) (€/L)","moins de 2000 l (€/L)","plus de 2000 l (€/L)"]
[null,1989,0.175,0.2048,{"$nulls":4},"pcs/pci",0.902,{"$nulls":5},"Mois de 2012","Prix moyen TVA incl.","Prix moyen TVA incl.","Prix moyen TVA incl.","Prix moyen TVA incl."]
[null,1990,0.1882,0.2201,{"$nulls":11},1,0.9004,0.9263,0.9121,0.8862]
[null,1991,0.1916,0.2241,{"$nulls":11},2,0.9137,0.9396,0.9288,0.9028]
[null,1992,0.1671,0.1988,{"$nulls":11},3,0.9413,0.9672,0.9505,0.9246]
[null,1993,0.178,0.2127,{"$nulls":11},4,0.9294,0.9556,0.9407,0.9145]
[null,1994,0.1663,0.2005,{"$nulls":11},5,0.8949,0.9211,0.9142,0.888]
[null,1995,0.1559,0.1879,{"$nulls":11},6,0.8478,0.8739,0.8592,0.833]
[null,1996,0.1879,0.2273,{"$nulls":11},7,0.8863,0.9125,0.8886,0.8624]
[null,1997,0.1943,0.235,{"$nulls":11},8,0.9458,0.9719,0.9458,0.9197]
[null,1998,0.1567,0.1896,{"$nulls":11},9,0.9526,0.9788,0.9483,0.9221]
[null,1999,0.1817,0.2199,{"$nulls":11},10,0.9479,0.9745,0.9443,0.9177]
[null,2000,0.3032,0.3669,{"$f":"734/2000","v":{"v":0.367,"d":"0.3670"}},{"$f":"831/H26","v":{"v":0.03502191503708699,"d":"0.0350"}},{"$nulls":9},11,0.9212,0.9478,0.9124,0.8858]
[null,2001,0.2751,0.3329,{"$f":"673/2000","v":0.3365},{"$f":"910/H26","v":{"v":0.03835131490222522,"d":"0.0384"}},{"$nulls":9},12,0.8815,0.9082,0.8898,0.8632]
[null,2002,0.2527,0.3057,{"$f":"611/2000","v":0.3055},{"$f":"849/H26","v":{"v":0.03578051247471342,"d":"0.0358"}},{"$nulls":9},"Prix Moyen",{"$f":"AVERAGE(Q28:Q39)","v":{"v":0.9135666666666667,"d":"0.9136"}},{"$f":"AVERAGE(R28:R39)","v":{"v":0.9397833333333333,"d":"0.9398"}},{"$f":"AVERAGE(S28:S39)","v":{"v":0.9195583333333333,"d":"0.9196"}},{"$f":"AVERAGE(T28:T39)","v":{"v":0.8933333333333332,"d":"0.8933"}}]
[null,2003,0.2614,0.3163,{"$f":"633/2000","v":0.3165},{"$f":"871/H26","v":{"v":0.03670768712070128,"d":"0.0367"}}]
[null,2004,0.3114,0.3767,{"$f":"753/2000","v":0.3765},{"$f":"862/H26","v":{"v":0.03632838840188807,"d":"0.0363"}}]
[null,2005,{"v":0.426,"d":"0.4260"},0.5155,{"$f":"958/2000","v":{"v":0.479,"d":"0.4790"}},{"$f":"992/H26","v":{"v":0.041807147673634526,"d":"0.0418"}}]
[null,2006,0.4767,0.5768,{"$f":"1151/2000","v":0.5755},{"$f":"1168/H26","v":{"v":0.049224544841537425,"d":"0.0492"}}]
[null,2007,{"v":0.481,"d":"0.4810"},{"v":0.582,"d":"0.5820"},{"$f":"1165/2000","v":0.5825},{"$f":"1078/H26","v":{"v":0.04543155765340526,"d":"0.0454"}}]
[null,2008,0.6283,0.7602,{"$f":"1520/2000","v":{"v":0.76,"d":"0.7600"}},{"$f":"1516/H26","v":{"v":0.06389076196898179,"d":"0.0639"}}]
[null,2009,0.4105,0.4968,{"$f":"993/2000","v":0.4965},{"$f":"1257/H26","v":{"v":0.05297538772757923,"d":"0.0530"}}]
[null,"Moyenne",{"$f":"AVERAGE(C38:C47)","v":{"v":0.3826299999999999,"d":"0.3826"}},{"$f":"AVERAGE(D38:D47)","v":{"v":0.46298000000000006,"d":"0.4630"}},{"$f":"AVERAGE(E38:E47)","v":{"v":0.45955,"d":"0.4596"}},{"$f":"AVERAGE(F38:F47)","v":{"v":0.04355192178017533,"d":"0.0436"}}]

{"sheet":"Calculs","index":10,"n_rows":37,"n_cols":8,"rows_kept":37,"hidden":true}
[]
["Descriptif Etablissement","Données Utilisateur","Estimations QuickScan","Unité"]
["TypeEtablissement",{"$f":"Tool!C32","v":"T-Bureau d'entreprise"},{"$f":"B3","v":"T-Bureau d'entreprise"}]
["N UniteFrequentation",{"$f":"Tool!C33","v":90},{"$f":"B4","v":90},{"$f":"Tool!D33","v":"Employés"}]
["Taux d'occupation",{"$f":"Tool!C35","v":100},{"$f":"IF(B5=0,1,B5/100)","v":{"v":1,"d":"100%"}}]
["Consommation ECS (Rratio)",null,{"$f":"C4*C5*LOOKUP(B3,TypeEtablissement,ConsoEtablissement)/1000","v":{"v":0.18,"d":"0.2"}},"m³/jour @60°C"]
[{"$nulls":5},"Description","Valeur","Unité"]
[{"$nulls":5},"Taux d'occupation par défaut",{"v":1,"d":"100%"}]
["Profil Consommation",{"$f":"Tool!H13","v":"A-7 jours sur 7 toute l'année"},{"$nulls":3},"Taux d'occupation minimum",{"v":0.2,"d":"20%"}]
["Consommation ECS introduite par Utilisateur",{"$f":"Tool!C49","v":500},null,{"$f":"Tool!D49","v":"m³/an"},null,"ConsoECS/Ratio = min",{"v":0.1,"d":"10%"}]
["Consommation ECS équ en m³/j",{"$f":"IF(OR(ISBLANK(D10),D10=0),0,B10/365)","v":{"v":1.36986301369863,"d":"1.37"}},null,"m³/jour",null,"ConsoECS/Ratio = max",{"v":15,"d":"1500%"}]
["Température ECS stockée/produite",{"$f":"IF(ISBLANK(Tool!C50),60,LEFT(Tool!C50,2))","v":"60"},null,"°C"]
["Consommation ECS à 60°C",{"$f":"IF(OR(ISBLANK(B12),B12=0),0,B11*(B12-'Tech Data'!B63)/(60-'Tech Data'!B63))","v":{"v":1.36986301369863,"d":"1.37"}},null,"m³/jour @60°C"]
["Consommation ECS acceptable",{"$f":"IF(ISNUMBER(B13),IF(OR(AND(B13>=C6*G10,B13<=C6*G11),C6=0),TRUE,FALSE),FALSE)","v":true}]
["Consommation ECS (Utilisateur)",{"$f":"IF(B14,B13,\"\")","v":{"v":1.36986301369863,"d":"1.4"}},null,"m³/jour @60°C"]
["Consommation ECS (Utilisateur)",{"$f":"B13*365/LOOKUP(B9,ProfilHebdo,JourPuis)","v":{"v":1.36986301369863,"d":"1.37"}},null,"m³/jour de puisage @60°C"]
["Source d'énergie",{"$f":"IF(ISBLANK(Tool!C43),'Eco Data'!A5,Tool!C43)","v":"3-Gaz naturel (RBC)"},{"$f":"B17","v":"3-Gaz naturel (RBC)"}]
["Consommation de la source d'énergie pour ECS",{"$f":"Tool!C51","v":{"v":25000,"d":"25,000"}},{"$f":"B18","v":25000},{"$f":"LOOKUP(B17,SourceEnergie,UnitéConsoAn)","v":"kWh/an"}]
["Consommation de la source d'énergie pour ECS + chauffage",{"$f":"Tool!C52","v":{"v":50000,"d":"50,000"}},{"$f":"B19","v":50000},{"$f":"LOOKUP(B17,SourceEnergie,UnitéConsoAn)","v":"kWh/an"}]
[]
["NPV calculée par Excel",{"$f":"NPV('Financiële balans'!C4,'Financiële balans'!L21:L45)+'Financiële balans'!I20","v":{"v":-15429.572698053762,"d":"-15,430"}},null,"EUR"]
["FactConvPrixDefaut Combustible",{"$f":"Tool!H16","v":{"v":0.06715499999999999,"d":"0.067"}},{"$f":"IF(ISBLANK(Tool!C43),'Eco Data'!W5,LOOKUP(Tool!C43,SourceEnergie,FactConvDefaut))","v":{"v":0.9999999999999999,"d":"1.000"}}]
["Type d'appoint",{"$f":"IF(ISBLANK(Tool!C45),'Tech Data'!C27,Tool!C45)","v":"C-Chaudière HR PLUS"}]
["Rdt Instantané Utilisateur",{"$f":"Tool!C46/100","v":{"v":0.9,"d":"0.90"}}]
["Rdt Instantané Utilisateur acceptable",{"$f":"ISNUMBER(Tool!C46)","v":true}]
["Rdt Utile Prod ECS mixte ou séparée",{"$f":"IF(B24<'Tech Data'!E28,B24*0.83,'Tech Data'!F40)","v":{"v":0.7507013000401674,"d":"0.75"}},{"$f":"IF(Tool!C44=\"Oui\",LOOKUP(B23,TypeAppoint,RdtUtilProdSep),LOOKUP(B23,TypeAppoint,RdtUtil))","v":{"v":0.791531565897387,"d":"0.79"}},"%"]
["Investissement Brut",{"$f":"IF(B36,LOOKUP(B9,ProfilHebdo,InvBrutHTVA),LOOKUP(B9,ProfilHebdo,InvBrutHTVAmax))","v":{"v":30760.590011548156,"d":"30,761"}},null,"EUR HTVA"]
["Taux de subsides",{"$f":"IF(ISBLANK(Tool!C67),0,Tool!C67)","v":0},null,"%"]
["Taux de subsides indicatif RBC 2013",null,{"$f":"IF(ISBLANK(Tool!C34),IF(Tool!H54*0.5<2500+(Tool!H40-4)*200,Tool!H54*0.5,2500+(Tool!H40-4)*200),IF(Tool!H54*0.5<Tool!C34*2500+(Tool!H40-Tool!C34*4)*200,Tool!H54*0.5,Tool!C34*2500+(Tool!H40-Tool!C34*4)*200))","v":{"v":18610.156956986633,"d":"18610"}},"EUR"]
["Remise IPP acceptée",{"$f":"IF(ISTEXT(Tool!D34),TRUE,FALSE)","v":false}]
["Remise IPP",{"$f":"IF(B30,MIN(B27*Tool!H20,Tool!C34*'Eco Data'!C20),0)","v":0},null,"EUR"]
[]
["Type toiture",{"$f":"IF(ISBLANK(Tool!C37),'Tech Data'!B9,Tool!C37)","v":"Toiture inclinée"}]
["Marge de sécurité ",1.1]
["Surface max toiture utile",{"$f":"IF(ISBLANK(Tool!C38),FALSE,Tool!C38)","v":false},null,"m²"]
["Surface max toiture utile suffisante",{"$f":"IF(Tool!H37>B37*B34,FALSE,TRUE)","v":true}]
["Surface max capteurs correspondante",{"$f":"IF(B35,B35/(LOOKUP(B33,Toit,ST_Scoll)),10000)","v":10000},null,"m²"]

{"sheet":"A-7sur7","index":11,"n_rows":42,"n_cols":11,"rows_kept":42,"hidden":true}
["DHWMDayVol",{"$f":"Tool!H12","v":{"v":1.36986301369863,"d":"1.4"}},null,null,"m³/j@60°C"]
["Days of SHW consumption ",{"$f":"52*7+1","v":365}]
["Resulting equations (A.HWMDayVol+B)"]
[null,"A","B","Result",null,null,"Contrainte en toiture"]
["Scoll",{"v":15.829,"d":"15.8290"},-3.7535,{"$f":"IF(B1=0,FALSE,B5*$B$1+C5)","v":{"v":17.930061643835618,"d":"17.9"}},"m²",null,"Scoll max",{"$f":"IF(Calculs!B36,\"\",Calculs!B37)","v":""},"m²"]
["Storage",1.0747,-0.1495,{"$f":"IF(B1=0,FALSE,B6*$B$1+C6)","v":{"v":1.3226917808219179,"d":"1.3"}},"m³"]
["Specific production",{"$f":"-0.6192","v":-0.6192},{"v":553.19,"d":"553.1900"},{"$f":"IF(B1=0,FALSE,B7*$B$1+C7)","v":{"v":552.3417808219178,"d":"552.3"}},"kWh/m².an"]
[]
["Simulation Results"]
["Qsol,net",{"$f":"D7*D5","v":{"v":9903.522178602929,"d":"9,904 "}},"kWh/an",{"$nulls":4},{"$f":"D7*H5","v":{"$error":"#VALUE!"}},"kWh/an"]
["Qpar",{"$f":"10*D5","v":{"v":179.30061643835617,"d":"179 "}},"kWhel/an",{"$nulls":4},{"$f":"10*H5","v":{"$error":"#VALUE!"}},"kWhel/an"]
["Number of tanks",{"$f":"IF(B1=0,0,(IF(D6<2,1,IF(D6<4,2,IF(D6<10,3,4)))))","v":{"v":1,"d":"1 "}},{"$nulls":5},"-"]
["Vol per tank",{"$f":"D6/B12","v":{"v":1.3226917808219179,"d":"1.3 "}},"m³",{"$nulls":4},"-"]
["Vstock",{"$f":"B12*B13","v":{"v":1.3226917808219179,"d":"1.3 "}},"m³",{"$nulls":4},{"$f":"B17*H5/1000","v":{"$error":"#VALUE!"}},"m³"]
["Total storage weight",{"$f":"B12*(1.1*(-0.005*B13^3 - 5.2178*B13^2 + 199.65*B13 + 26.215)+B13*1000)","v":{"v":1631.9570359331838,"d":"1,632 "}},"kg",{"$nulls":4},{"$f":"H14/B14*B15","v":{"$error":"#VALUE!"}},"kg"]
["Total storage floor surface",{"$f":"B12*((448.1*LN(B13) + 1115.7)/1000)^2+0.5*(B12-1)*(448.1*LN(B13) + 1115.7)/1000","v":{"v":1.540129718951474,"d":"1.5 "}},"m²",{"$nulls":4},{"$f":"H14/B14*B16","v":{"$error":"#VALUE!"}},"m²"]
["Specific storage volume",{"$f":"D6*1000/D5","v":{"v":73.76950548726424,"d":"73.8 "}},"l/m²"]
[]
["Costs"]
["Total cost excl. Storage",{"$f":"IF(B1=0,0,1.15*1672*D5^(1-0.1514)-(20.203*(33*D5)^(1-0.3386)+1000+33*D5))","v":{"v":19301.65326574108,"d":"19,302 €"}},"€ excl. VAT"]
["Storage material cost",{"$f":"(20.203*(B13*1000)^(1-0.3386))*B12","v":{"v":2343.9514835382065,"d":"2,344 €"}},"€ excl. VAT"]
["Storage installation",{"$f":"1000+(B12*B13*1000)","v":{"v":2322.6917808219177,"d":"2,323 €"}},"€ excl. VAT"]
["Total cost",{"$f":"SUM(B20:B22)","v":{"v":23968.296530101205,"d":"23,968 €"}},"€ excl. VAT",{"$nulls":4},{"$f":"B27*H5","v":{"$error":"#VALUE!"}},"€ excl. VAT"]
["Maintenance Cost",{"$f":"B23*Hyp!B19","v":{"v":59.92074132525301,"d":"60 €"}},"€ excl. VAT",{"$nulls":4},{"$f":"H23*Hyp!B19","v":{"$error":"#VALUE!"}},"€ excl. VAT"]
["Auxiliary Power Cost",{"$f":"B11*Hyp!B20","v":{"v":26.10616975342466,"d":"26 €"}},"€ excl. VAT",{"$nulls":4},{"$f":"H11*Hyp!B20","v":{"$error":"#VALUE!"}},"€ excl. VAT"]
["Operational Costs",{"$f":"SUM(B24:B25)","v":{"v":86.02691107867767,"d":"86 €"}},"€ excl. VAT",{"$nulls":4},{"$f":"SUM(H24:H25)","v":{"$error":"#VALUE!"}},"€ excl. VAT"]
["Specific Cost",{"$f":"B23/D5","v":{"v":1336.7659858738712,"d":"1,337 "}},"€/m² HTVA"]
[]
["Calculated Results"]
["Qd",{"$f":"B1*'Energy Data'!D10*(60-'Tech Data'!B63)*365","v":{"v":29075.000000000004,"d":"29,075 "}},"kWh/an"]
["Qaux,net",{"$f":"B30-B10","v":{"v":19171.477821397075,"d":"19,171 "}},"kWh/an",{"$nulls":4},{"$f":"B30-H10","v":{"$error":"#VALUE!"}},"kWh/an"]
["Qpar,prim",{"$f":"B11/'Energy Data'!B38","v":{"v":443.81340702563404,"d":"444 "}},"kWh/an",{"$nulls":4},{"$f":"H11/'Energy Data'!B38","v":{"$error":"#VALUE!"}},"kWh/an"]
["CombEco",{"$f":"B10/Tool!H8","v":{"v":13192.360500871686,"d":"13,192 "}},"kWh/an",{"$f":"B33*(LOOKUP(Calculs!B17,SourceEnergie,FactConvDefaut))","v":{"v":13192.360500871684,"d":"13,192 "}},{"$f":"LOOKUP(Calculs!B17,SourceEnergie,UnitéConsoAn)","v":"kWh/an"},null,null,{"$f":"H10/Tool!H8","v":{"$error":"#VALUE!"}},"kWh/an",{"$f":"H33*(LOOKUP(Calculs!B17,SourceEnergie,FactConvDefaut))","v":{"$error":"#VALUE!"}},{"$f":"LOOKUP(Calculs!B17,SourceEnergie,UnitéConsoAn)","v":"kWh/an"}]
["EprimEco",{"$f":"(B33-B32)/(LOOKUP(Calculs!B17,SourceEnergie,FactConvEprim))","v":{"v":12748.547093846051,"d":"12,749 "}},"kWh/an",{"$nulls":4},{"$f":"(H33-H32)/(LOOKUP(Calculs!B17,SourceEnergie,FactConvEprim))","v":{"$error":"#VALUE!"}},"kWh/an"]
["Fsol",{"$f":"B10/(B10+B31)","v":{"v":0.340619851370694,"d":"0.34 "}},{"$nulls":5},{"$f":"H10/(H10+H31)","v":{"$error":"#VALUE!"}}]
["Cout kWh Eco HTVA",{"$f":"B23/(B33*Hyp!B9)","v":{"v":0.07267326125151749,"d":"0.073 "}},"€/kWh excl. VAT",{"$nulls":4},{"$f":"H23/(H33*Hyp!B9)","v":{"$error":"#VALUE!"}},"€/kWh incl. VAT"]
["Cout kWh Eco TVAc",{"$f":"(B23+(B23*Tool!H15))/(B33*Hyp!B9)","v":{"v":0.08793464611433617,"d":"0.088 "}},"€/kWh incl. VAT",{"$nulls":4},{"$f":"(H23+(H23*Tool!H15))/(H33*Hyp!B9)","v":{"$error":"#VALUE!"}},"€/kWh excl. VAT"]
["Cout Net kWh Eco HTVA",{"$f":"(B23*(1-Calculs!$B$28/100)-Calculs!$B$31)/(B33*Hyp!$B$9)","v":{"v":0.07267326125151749,"d":"0.073 "}},"€ excl. VAT",{"$nulls":4},{"$f":"(H23*(1-Calculs!$B$28/100)-Calculs!$B$31)/(H33*Hyp!$B$9)","v":{"$error":"#VALUE!"}},"€ excl. VAT"]
["Cout Net kWh Eco TVAc",{"$f":"((B23*(1-Calculs!$B$28/100)-Calculs!$B$31)+(B23*Tool!$H$15))/(B33*Hyp!$B$9)","v":{"v":0.08793464611433617,"d":"0.088 "}},"€ incl. VAT",{"$nulls":4},{"$f":"((H23*(1-Calculs!$B$28/100)-Calculs!$B$31)+(H23*Tool!$H$15))/(H33*Hyp!$B$9)","v":{"$error":"#VALUE!"}},"€ incl. VAT"]
["CO2 Eco",{"$f":"B34*LOOKUP(Tool!H7,SourceEnergie,FactEmis)","v":{"v":2766.434719364593,"d":"2,766 "}},"kg/an",{"$nulls":4},{"$f":"H34*LOOKUP(Tool!H7,SourceEnergie,FactEmis)","v":{"$error":"#VALUE!"}},"kg/an"]
["CO2 Eco durée de vie",{"$f":"B40*Hyp!B9/1000","v":{"v":69.16086798411483,"d":"69 "}},"tonnes",{"$nulls":4},{"$f":"H40*Hyp!B9/1000","v":{"$error":"#VALUE!"}},"tonnes"]
["Cout CO2 évité",{"$f":"B23/B41","v":{"v":346.55864260706426,"d":"347 "}},"EUR/tonne",{"$nulls":4},{"$f":"H23/H41","v":{"$error":"#VALUE!"}},"EUR/tonne"]

{"sheet":"B-5sur7","index":12,"n_rows":42,"n_cols":11,"rows_kept":42,"hidden":true}
["DHWMDayVol",{"$f":"Tool!H12","v":{"v":1.36986301369863,"d":"1.4"}},null,null,"m³/j@60°C"]
["Days of SHW consumption ",{"$f":"52*(7-2)+1","v":261}]
["Resulting equations (A.HWMDayVol+B)"]
[null,"A","B","Result",null,null,"Contrainte en toiture"]
["Scoll",{"v":15.689,"d":"15.6890"},4.6157,{"$f":"IF(B1=0,FALSE,B5*$B$1+C5)","v":{"v":26.107480821917807,"d":"26.1"}},"m²",null,"Scoll max",{"$f":"IF(Calculs!B36,\"\",Calculs!B37)","v":""},"m²"]
["Storage",1.2775,0.0892,{"$f":"IF(B1=0,FALSE,B6*$B$1+C6)","v":{"v":1.8392,"d":"1.8"}},"m³"]
["Specific production",-0.1033,516.55,{"$f":"IF(B1=0,FALSE,B7*$B$1+C7)","v":{"v":516.4084931506849,"d":"516.4"}},"kWh/m².an"]
[]
["Simulation Results"]
["Qsol,net",{"$f":"D7*D5","v":{"v":13482.124831206978,"d":"13,482 "}},"kWh/an",{"$nulls":4},{"$f":"D7*H5","v":{"$error":"#VALUE!"}},"kWh/an"]
["Qpar",{"$f":"10*D5","v":{"v":261.07480821917807,"d":"261 "}},"kWhel/an",{"$nulls":4},{"$f":"10*H5","v":{"$error":"#VALUE!"}},"kWhel/an"]
["Number of tanks",{"$f":"IF(B1=0,0,(IF(D6<2,1,IF(D6<4,2,IF(D6<10,3,4)))))","v":{"v":1,"d":"1 "}},{"$nulls":5},"-"]
["Vol per tank",{"$f":"D6/B12","v":{"v":1.8392,"d":"1.8 "}},"m³",{"$nulls":4},"-"]
["Vstock",{"$f":"B12*B13","v":{"v":1.8392,"d":"1.8 "}},"m³",{"$nulls":4},{"$f":"B17*H5/1000","v":{"$error":"#VALUE!"}},"m³"]
["Total storage weight",{"$f":"B12*(1.1*(-0.005*B13^3 - 5.2178*B13^2 + 199.65*B13 + 26.215)+B13*1000)","v":{"v":2252.503162000681,"d":"2,253 "}},"kg",{"$nulls":4},{"$f":"H14/B14*B15","v":{"$error":"#VALUE!"}},"kg"]
["Total storage floor surface",{"$f":"B12*((448.1*LN(B13) + 1115.7)/1000)^2+0.5*(B12-1)*(448.1*LN(B13) + 1115.7)/1000","v":{"v":1.9286017989188518,"d":"1.9 "}},"m²",{"$nulls":4},{"$f":"H14/B14*B16","v":{"$error":"#VALUE!"}},"m²"]
["Specific storage volume",{"$f":"D6*1000/D5","v":{"v":70.44724125416003,"d":"70.4 "}},"l/m²"]
[]
["Costs"]
["Total cost excl. Storage",{"$f":"IF(B1=0,0,1.15*1672*D5^(1-0.1514)-(20.203*(33*D5)^(1-0.3386)+1000+33*D5))","v":{"v":27006.98994089425,"d":"27,007 €"}},"€ excl. VAT"]
["Storage material cost",{"$f":"(20.203*(B13*1000)^(1-0.3386))*B12","v":{"v":2915.019449778468,"d":"2,915 €"}},"€ excl. VAT"]
["Storage installation",{"$f":"1000+(B12*B13*1000)","v":{"v":2839.2,"d":"2,839 €"}},"€ excl. VAT"]
["Total cost",{"$f":"SUM(B20:B22)","v":{"v":32761.20939067272,"d":"32,761 €"}},"€ excl. VAT",{"$nulls":4},{"$f":"B27*H5","v":{"$error":"#VALUE!"}},"€ excl. VAT"]
["Maintenance Cost",{"$f":"B23*Hyp!B19","v":{"v":81.90302347668181,"d":"82 €"}},"€ excl. VAT",{"$nulls":4},{"$f":"H23*Hyp!B19","v":{"$error":"#VALUE!"}},"€ excl. VAT"]
["Auxiliary Power Cost",{"$f":"B11*Hyp!B20","v":{"v":38.01249207671233,"d":"38 €"}},"€ excl. VAT",{"$nulls":4},{"$f":"H11*Hyp!B20","v":{"$error":"#VALUE!"}},"€ excl. VAT"]
["Operational Costs",{"$f":"SUM(B24:B25)","v":{"v":119.91551555339413,"d":"120 €"}},"€ excl. VAT",{"$nulls":4},{"$f":"SUM(H24:H25)","v":{"$error":"#VALUE!"}},"€ excl. VAT"]
["Specific Cost",{"$f":"B23/D5","v":{"v":1254.8590809714954,"d":"1,255 "}},"€/m² HTVA"]
[]
["Calculated Results"]
["Qd",{"$f":"B1*'Energy Data'!D10*(60-'Tech Data'!B63)*365","v":{"v":29075.000000000004,"d":"29,075 "}},"kWh/an"]
["Qaux,net",{"$f":"B30-B10","v":{"v":15592.875168793025,"d":"15,593 "}},"kWh/an",{"$nulls":4},{"$f":"B30-H10","v":{"$error":"#VALUE!"}},"kWh/an"]
["Qpar,prim",{"$f":"B11/'Energy Data'!B38","v":{"v":646.2247728197476,"d":"646 "}},"kWh/an",{"$nulls":4},{"$f":"H11/'Energy Data'!B38","v":{"$error":"#VALUE!"}},"kWh/an"]
["CombEco",{"$f":"B10/Tool!H8","v":{"v":17959.373229386438,"d":"17,959 "}},"kWh/an",{"$f":"B33*(LOOKUP(Calculs!B17,SourceEnergie,FactConvDefaut))","v":{"v":17959.373229386434,"d":"17,959 "}},{"$f":"LOOKUP(Calculs!B17,SourceEnergie,UnitéConsoAn)","v":"kWh/an"},null,null,{"$f":"H10/Tool!H8","v":{"$error":"#VALUE!"}},"kWh/an",{"$f":"H33*(LOOKUP(Calculs!B17,SourceEnergie,FactConvDefaut))","v":{"$error":"#VALUE!"}},{"$f":"LOOKUP(Calculs!B17,SourceEnergie,UnitéConsoAn)","v":"kWh/an"}]
["EprimEco",{"$f":"(B33-B32)/(LOOKUP(Calculs!B17,SourceEnergie,FactConvEprim))","v":{"v":17313.14845656669,"d":"17,313 "}},"kWh/an",{"$nulls":4},{"$f":"(H33-H32)/(LOOKUP(Calculs!B17,SourceEnergie,FactConvEprim))","v":{"$error":"#VALUE!"}},"kWh/an"]
["Fsol",{"$f":"B10/(B10+B31)","v":{"v":0.4637016279004979,"d":"0.46 "}},{"$nulls":5},{"$f":"H10/(H10+H31)","v":{"$error":"#VALUE!"}}]
["Cout kWh Eco HTVA",{"$f":"B23/(B33*Hyp!B9)","v":{"v":0.07296737803091355,"d":"0.073 "}},"€/kWh excl. VAT",{"$nulls":4},{"$f":"H23/(H33*Hyp!B9)","v":{"$error":"#VALUE!"}},"€/kWh incl. VAT"]
["Cout kWh Eco TVAc",{"$f":"(B23+(B23*Tool!H15))/(B33*Hyp!B9)","v":{"v":0.08829052741740538,"d":"0.088 "}},"€/kWh incl. VAT",{"$nulls":4},{"$f":"(H23+(H23*Tool!H15))/(H33*Hyp!B9)","v":{"$error":"#VALUE!"}},"€/kWh excl. VAT"]
["Cout Net kWh Eco HTVA",{"$f":"(B23*(1-Calculs!$B$28/100)-Calculs!$B$31)/(B33*Hyp!$B$9)","v":{"v":0.07296737803091355,"d":"0.073 "}},"€ excl. VAT",{"$nulls":4},{"$f":"(H23*(1-Calculs!$B$28/100)-Calculs!$B$31)/(H33*Hyp!$B$9)","v":{"$error":"#VALUE!"}},"€ excl. VAT"]
["Cout Net kWh Eco TVAc",{"$f":"((B23*(1-Calculs!$B$28/100)-Calculs!$B$31)+(B23*Tool!$H$15))/(B33*Hyp!$B$9)","v":{"v":0.08829052741740538,"d":"0.088 "}},"€ incl. VAT",{"$nulls":4},{"$f":"((H23*(1-Calculs!$B$28/100)-Calculs!$B$31)+(H23*Tool!$H$15))/(H33*Hyp!$B$9)","v":{"$error":"#VALUE!"}},"€ incl. VAT"]
["CO2 Eco",{"$f":"B34*LOOKUP(Tool!H7,SourceEnergie,FactEmis)","v":{"v":3756.953215074972,"d":"3,757 "}},"kg/an",{"$nulls":4},{"$f":"H34*LOOKUP(Tool!H7,SourceEnergie,FactEmis)","v":{"$error":"#VALUE!"}},"kg/an"]
["CO2 Eco durée de vie",{"$f":"B40*Hyp!B9/1000","v":{"v":93.92383037687429,"d":"94 "}},"tonnes",{"$nulls":4},{"$f":"H40*Hyp!B9/1000","v":{"$error":"#VALUE!"}},"tonnes"]
["Cout CO2 évité",{"$f":"B23/B41","v":{"v":348.80614705785155,"d":"349 "}},"EUR/tonne",{"$nulls":4},{"$f":"H23/H41","v":{"$error":"#VALUE!"}},"EUR/tonne"]

{"sheet":"C-5sur7HVS","index":13,"n_rows":42,"n_cols":11,"rows_kept":42,"hidden":true}
["DHWMDayVol",{"$f":"Tool!H12","v":{"v":1.36986301369863,"d":"1.4"}},null,null,"m³/j@60°C"]
["Days of SHW consumption ",{"$f":"52*(7-2)+1-61","v":200}]
["Resulting equations (A.HWMDayVol+B)"]
[null,"A","B","Result",null,null,"Contrainte en toiture"]
["Scoll",{"v":15.564,"d":"15.5640"},9.2486,{"$f":"IF(B1=0,FALSE,B5*$B$1+C5)","v":{"v":30.56914794520548,"d":"30.6"}},"m²",null,"Scoll max",{"$f":"IF(Calculs!B36,\"\",Calculs!B37)","v":""},"m²"]
["Storage",1.2684,0.2473,{"$f":"IF(B1=0,FALSE,B6*$B$1+C6)","v":{"v":1.9848342465753424,"d":"2.0"}},"m³"]
["Specific production",0.4308,390.28,{"$f":"IF(B1=0,FALSE,B7*$B$1+C7)","v":{"v":390.87013698630136,"d":"390.9"}},"kWh/m².an"]
[]
["Simulation Results"]
["Qsol,net",{"$f":"D7*D5","v":{"v":11948.567044896978,"d":"11,949 "}},"kWh/an",{"$nulls":4},{"$f":"D7*H5","v":{"$error":"#VALUE!"}},"kWh/an"]
["Qpar",{"$f":"10*D5","v":{"v":305.6914794520548,"d":"306 "}},"kWhel/an",{"$nulls":4},{"$f":"10*H5","v":{"$error":"#VALUE!"}},"kWhel/an"]
["Number of tanks",{"$f":"IF(B1=0,0,(IF(D6<2,1,IF(D6<4,2,IF(D6<10,3,4)))))","v":{"v":1,"d":"1 "}},{"$nulls":5},"-"]
["Vol per tank",{"$f":"D6/B12","v":{"v":1.9848342465753424,"d":"2.0 "}},"m³",{"$nulls":4},"-"]
["Vstock",{"$f":"B12*B13","v":{"v":1.9848342465753424,"d":"2.0 "}},"m³",{"$nulls":4},{"$f":"B17*H5/1000","v":{"$error":"#VALUE!"}},"m³"]
["Total storage weight",{"$f":"B12*(1.1*(-0.005*B13^3 - 5.2178*B13^2 + 199.65*B13 + 26.215)+B13*1000)","v":{"v":2426.915653122217,"d":"2,427 "}},"kg",{"$nulls":4},{"$f":"H14/B14*B15","v":{"$error":"#VALUE!"}},"kg"]
["Total storage floor surface",{"$f":"B12*((448.1*LN(B13) + 1115.7)/1000)^2+0.5*(B12-1)*(448.1*LN(B13) + 1115.7)/1000","v":{"v":2.0246114448877695,"d":"2.0 "}},"m²",{"$nulls":4},{"$f":"H14/B14*B16","v":{"$error":"#VALUE!"}},"m²"]
["Specific storage volume",{"$f":"D6*1000/D5","v":{"v":64.9293284239755,"d":"64.9 "}},"l/m²"]
[]
["Costs"]
["Total cost excl. Storage",{"$f":"IF(B1=0,0,1.15*1672*D5^(1-0.1514)-(20.203*(33*D5)^(1-0.3386)+1000+33*D5))","v":{"v":31054.17032257129,"d":"31,054 €"}},"€ excl. VAT"]
["Storage material cost",{"$f":"(20.203*(B13*1000)^(1-0.3386))*B12","v":{"v":3065.7072384188587,"d":"3,066 €"}},"€ excl. VAT"]
["Storage installation",{"$f":"1000+(B12*B13*1000)","v":{"v":2984.834246575342,"d":"2,985 €"}},"€ excl. VAT"]
["Total cost",{"$f":"SUM(B20:B22)","v":{"v":37104.711807565494,"d":"37,105 €"}},"€ excl. VAT",{"$nulls":4},{"$f":"B27*H5","v":{"$error":"#VALUE!"}},"€ excl. VAT"]
["Maintenance Cost",{"$f":"B23*Hyp!B19","v":{"v":92.76177951891374,"d":"93 €"}},"€ excl. VAT",{"$nulls":4},{"$f":"H23*Hyp!B19","v":{"$error":"#VALUE!"}},"€ excl. VAT"]
["Auxiliary Power Cost",{"$f":"B11*Hyp!B20","v":{"v":44.50867940821918,"d":"45 €"}},"€ excl. VAT",{"$nulls":4},{"$f":"H11*Hyp!B20","v":{"$error":"#VALUE!"}},"€ excl. VAT"]
["Operational Costs",{"$f":"SUM(B24:B25)","v":{"v":137.27045892713292,"d":"137 €"}},"€ excl. VAT",{"$nulls":4},{"$f":"SUM(H24:H25)","v":{"$error":"#VALUE!"}},"€ excl. VAT"]
["Specific Cost",{"$f":"B23/D5","v":{"v":1213.7960755096892,"d":"1,214 "}},"€/m² HTVA"]
[]
["Calculated Results"]
["Qd",{"$f":"B1*'Energy Data'!D10*(60-'Tech Data'!B63)*365","v":{"v":29075.000000000004,"d":"29,075 "}},"kWh/an"]
["Qaux,net",{"$f":"B30-B10","v":{"v":17126.432955103024,"d":"17,126 "}},"kWh/an",{"$nulls":4},{"$f":"B30-H10","v":{"$error":"#VALUE!"}},"kWh/an"]
["Qpar,prim",{"$f":"B11/'Energy Data'!B38","v":{"v":756.6620778516208,"d":"757 "}},"kWh/an",{"$nulls":4},{"$f":"H11/'Energy Data'!B38","v":{"$error":"#VALUE!"}},"kWh/an"]
["CombEco",{"$f":"B10/Tool!H8","v":{"v":15916.539699954763,"d":"15,917 "}},"kWh/an",{"$f":"B33*(LOOKUP(Calculs!B17,SourceEnergie,FactConvDefaut))","v":{"v":15916.539699954761,"d":"15,917 "}},{"$f":"LOOKUP(Calculs!B17,SourceEnergie,UnitéConsoAn)","v":"kWh/an"},null,null,{"$f":"H10/Tool!H8","v":{"$error":"#VALUE!"}},"kWh/an",{"$f":"H33*(LOOKUP(Calculs!B17,SourceEnergie,FactConvDefaut))","v":{"$error":"#VALUE!"}},{"$f":"LOOKUP(Calculs!B17,SourceEnergie,UnitéConsoAn)","v":"kWh/an"}]
["EprimEco",{"$f":"(B33-B32)/(LOOKUP(Calculs!B17,SourceEnergie,FactConvEprim))","v":{"v":15159.877622103142,"d":"15,160 "}},"kWh/an",{"$nulls":4},{"$f":"(H33-H32)/(LOOKUP(Calculs!B17,SourceEnergie,FactConvEprim))","v":{"$error":"#VALUE!"}},"kWh/an"]
["Fsol",{"$f":"B10/(B10+B31)","v":{"v":0.4109567341323122,"d":"0.41 "}},{"$nulls":5},{"$f":"H10/(H10+H31)","v":{"$error":"#VALUE!"}}]
["Cout kWh Eco HTVA",{"$f":"B23/(B33*Hyp!B9)","v":{"v":0.0932481871236647,"d":"0.093 "}},"€/kWh excl. VAT",{"$nulls":4},{"$f":"H23/(H33*Hyp!B9)","v":{"$error":"#VALUE!"}},"€/kWh incl. VAT"]
["Cout kWh Eco TVAc",{"$f":"(B23+(B23*Tool!H15))/(B33*Hyp!B9)","v":{"v":0.11283030641963429,"d":"0.113 "}},"€/kWh incl. VAT",{"$nulls":4},{"$f":"(H23+(H23*Tool!H15))/(H33*Hyp!B9)","v":{"$error":"#VALUE!"}},"€/kWh excl. VAT"]
["Cout Net kWh Eco HTVA",{"$f":"(B23*(1-Calculs!$B$28/100)-Calculs!$B$31)/(B33*Hyp!$B$9)","v":{"v":0.0932481871236647,"d":"0.093 "}},"€ excl. VAT",{"$nulls":4},{"$f":"(H23*(1-Calculs!$B$28/100)-Calculs!$B$31)/(H33*Hyp!$B$9)","v":{"$error":"#VALUE!"}},"€ excl. VAT"]
["Cout Net kWh Eco TVAc",{"$f":"((B23*(1-Calculs!$B$28/100)-Calculs!$B$31)+(B23*Tool!$H$15))/(B33*Hyp!$B$9)","v":{"v":0.11283030641963429,"d":"0.113 "}},"€ incl. VAT",{"$nulls":4},{"$f":"((H23*(1-Calculs!$B$28/100)-Calculs!$B$31)+(H23*Tool!$H$15))/(H33*Hyp!$B$9)","v":{"$error":"#VALUE!"}},"€ incl. VAT"]
["CO2 Eco",{"$f":"B34*LOOKUP(Tool!H7,SourceEnergie,FactEmis)","v":{"v":3289.693443996382,"d":"3,290 "}},"kg/an",{"$nulls":4},{"$f":"H34*LOOKUP(Tool!H7,SourceEnergie,FactEmis)","v":{"$error":"#VALUE!"}},"kg/an"]
["CO2 Eco durée de vie",{"$f":"B40*Hyp!B9/1000","v":{"v":82.24233609990955,"d":"82 "}},"tonnes",{"$nulls":4},{"$f":"H40*Hyp!B9/1000","v":{"$error":"#VALUE!"}},"tonnes"]
["Cout CO2 évité",{"$f":"B23/B41","v":{"v":451.1631547344422,"d":"451 "}},"EUR/tonne",{"$nulls":4},{"$f":"H23/H41","v":{"$error":"#VALUE!"}},"EUR/tonne"]

{"sheet":"D-7sur7HVS","index":14,"n_rows":42,"n_cols":11,"rows_kept":42,"hidden":true}
["DHWMDayVol",{"$f":"Tool!H12","v":{"v":1.36986301369863,"d":"1.4"}},null,null,"m³/j@60°C"]
["Days of SHW consumption ",{"$f":"52*7+1-61","v":304}]
["Resulting equations (A.HWMDayVol+B)"]
[null,"A","B","Result",null,null,"Contrainte en toiture"]
["Scoll",{"v":10.956,"d":"10.9560"},3.6168,{"$f":"IF(B1=0,FALSE,B5*$B$1+C5)","v":{"v":18.62501917808219,"d":"18.6"}},"m²",null,"Scoll max",{"$f":"IF(Calculs!B36,\"\",Calculs!B37)","v":""},"m²"]
["Storage",{"v":0.746,"d":"0.7460"},0.2706,{"$f":"IF(B1=0,FALSE,B6*$B$1+C6)","v":{"v":1.292517808219178,"d":"1.3"}},"m³"]
["Specific production",0.3382,472.97,{"$f":"IF(B1=0,FALSE,B7*$B$1+C7)","v":{"v":473.4332876712329,"d":"473.4"}},"kWh/m².an"]
[]
["Simulation Results"]
["Qsol,net",{"$f":"D7*D5","v":{"v":8817.704062419216,"d":"8,818 "}},"kWh/an",{"$nulls":4},{"$f":"D7*H5","v":{"$error":"#VALUE!"}},"kWh/an"]
["Qpar",{"$f":"10*D5","v":{"v":186.25019178082192,"d":"186 "}},"kWhel/an",{"$nulls":4},{"$f":"10*H5","v":{"$error":"#VALUE!"}},"kWhel/an"]
["Number of tanks",{"$f":"IF(B1=0,0,(IF(D6<2,1,IF(D6<4,2,IF(D6<10,3,4)))))","v":{"v":1,"d":"1 "}},{"$nulls":5},"-"]
["Vol per tank",{"$f":"D6/B12","v":{"v":1.292517808219178,"d":"1.3 "}},"m³",{"$nulls":4},"-"]
["Vstock",{"$f":"B12*B13","v":{"v":1.292517808219178,"d":"1.3 "}},"m³",{"$nulls":4},{"$f":"B17*H5/1000","v":{"$error":"#VALUE!"}},"m³"]
["Total storage weight",{"$f":"B12*(1.1*(-0.005*B13^3 - 5.2178*B13^2 + 199.65*B13 + 26.215)+B13*1000)","v":{"v":1595.6101751531787,"d":"1,596 "}},"kg",{"$nulls":4},{"$f":"H14/B14*B15","v":{"$error":"#VALUE!"}},"kg"]
["Total storage floor surface",{"$f":"B12*((448.1*LN(B13) + 1115.7)/1000)^2+0.5*(B12-1)*(448.1*LN(B13) + 1115.7)/1000","v":{"v":1.514570610140197,"d":"1.5 "}},"m²",{"$nulls":4},{"$f":"H14/B14*B16","v":{"$error":"#VALUE!"}},"m²"]
["Specific storage volume",{"$f":"D6*1000/D5","v":{"v":69.39685784271326,"d":"69.4 "}},"l/m²"]
[]
["Costs"]
["Total cost excl. Storage",{"$f":"IF(B1=0,0,1.15*1672*D5^(1-0.1514)-(20.203*(33*D5)^(1-0.3386)+1000+33*D5))","v":{"v":19974.02628484028,"d":"19,974 €"}},"€ excl. VAT"]
["Storage material cost",{"$f":"(20.203*(B13*1000)^(1-0.3386))*B12","v":{"v":2308.4474275840275,"d":"2,308 €"}},"€ excl. VAT"]
["Storage installation",{"$f":"1000+(B12*B13*1000)","v":{"v":2292.517808219178,"d":"2,293 €"}},"€ excl. VAT"]
["Total cost",{"$f":"SUM(B20:B22)","v":{"v":24574.99152064349,"d":"24,575 €"}},"€ excl. VAT",{"$nulls":4},{"$f":"B27*H5","v":{"$error":"#VALUE!"}},"€ excl. VAT"]
["Maintenance Cost",{"$f":"B23*Hyp!B19","v":{"v":61.43747880160873,"d":"61 €"}},"€ excl. VAT",{"$nulls":4},{"$f":"H23*Hyp!B19","v":{"$error":"#VALUE!"}},"€ excl. VAT"]
["Auxiliary Power Cost",{"$f":"B11*Hyp!B20","v":{"v":27.118027923287674,"d":"27 €"}},"€ excl. VAT",{"$nulls":4},{"$f":"H11*Hyp!B20","v":{"$error":"#VALUE!"}},"€ excl. VAT"]
["Operational Costs",{"$f":"SUM(B24:B25)","v":{"v":88.5555067248964,"d":"89 €"}},"€ excl. VAT",{"$nulls":4},{"$f":"SUM(H24:H25)","v":{"$error":"#VALUE!"}},"€ excl. VAT"]
["Specific Cost",{"$f":"B23/D5","v":{"v":1319.4612733372746,"d":"1,319 "}},"€/m² HTVA"]
[]
["Calculated Results"]
["Qd",{"$f":"B1*'Energy Data'!D10*(60-'Tech Data'!B63)*365","v":{"v":29075.000000000004,"d":"29,075 "}},"kWh/an"]
["Qaux,net",{"$f":"B30-B10","v":{"v":20257.295937580788,"d":"20,257 "}},"kWh/an",{"$nulls":4},{"$f":"B30-H10","v":{"$error":"#VALUE!"}},"kWh/an"]
["Qpar,prim",{"$f":"B11/'Energy Data'!B38","v":{"v":461.01532619015325,"d":"461 "}},"kWh/an",{"$nulls":4},{"$f":"H11/'Energy Data'!B38","v":{"$error":"#VALUE!"}},"kWh/an"]
["CombEco",{"$f":"B10/Tool!H8","v":{"v":11745.955497809064,"d":"11,746 "}},"kWh/an",{"$f":"B33*(LOOKUP(Calculs!B17,SourceEnergie,FactConvDefaut))","v":{"v":11745.955497809062,"d":"11,746 "}},{"$f":"LOOKUP(Calculs!B17,SourceEnergie,UnitéConsoAn)","v":"kWh/an"},null,null,{"$f":"H10/Tool!H8","v":{"$error":"#VALUE!"}},"kWh/an",{"$f":"H33*(LOOKUP(Calculs!B17,SourceEnergie,FactConvDefaut))","v":{"$error":"#VALUE!"}},{"$f":"LOOKUP(Calculs!B17,SourceEnergie,UnitéConsoAn)","v":"kWh/an"}]
["EprimEco",{"$f":"(B33-B32)/(LOOKUP(Calculs!B17,SourceEnergie,FactConvEprim))","v":{"v":11284.94017161891,"d":"11,285 "}},"kWh/an",{"$nulls":4},{"$f":"(H33-H32)/(LOOKUP(Calculs!B17,SourceEnergie,FactConvEprim))","v":{"$error":"#VALUE!"}},"kWh/an"]
["Fsol",{"$f":"B10/(B10+B31)","v":{"v":0.30327443034975804,"d":"0.30 "}},{"$nulls":5},{"$f":"H10/(H10+H31)","v":{"$error":"#VALUE!"}}]
["Cout kWh Eco HTVA",{"$f":"B23/(B33*Hyp!B9)","v":{"v":0.08368835221699038,"d":"0.084 "}},"€/kWh excl. VAT",{"$nulls":4},{"$f":"H23/(H33*Hyp!B9)","v":{"$error":"#VALUE!"}},"€/kWh incl. VAT"]
["Cout kWh Eco TVAc",{"$f":"(B23+(B23*Tool!H15))/(B33*Hyp!B9)","v":{"v":0.10126290618255836,"d":"0.101 "}},"€/kWh incl. VAT",{"$nulls":4},{"$f":"(H23+(H23*Tool!H15))/(H33*Hyp!B9)","v":{"$error":"#VALUE!"}},"€/kWh excl. VAT"]
["Cout Net kWh Eco HTVA",{"$f":"(B23*(1-Calculs!$B$28/100)-Calculs!$B$31)/(B33*Hyp!$B$9)","v":{"v":0.08368835221699038,"d":"0.084 "}},"€ excl. VAT",{"$nulls":4},{"$f":"(H23*(1-Calculs!$B$28/100)-Calculs!$B$31)/(H33*Hyp!$B$9)","v":{"$error":"#VALUE!"}},"€ excl. VAT"]
["Cout Net kWh Eco TVAc",{"$f":"((B23*(1-Calculs!$B$28/100)-Calculs!$B$31)+(B23*Tool!$H$15))/(B33*Hyp!$B$9)","v":{"v":0.10126290618255836,"d":"0.101 "}},"€ incl. VAT",{"$nulls":4},{"$f":"((H23*(1-Calculs!$B$28/100)-Calculs!$B$31)+(H23*Tool!$H$15))/(H33*Hyp!$B$9)","v":{"$error":"#VALUE!"}},"€ incl. VAT"]
["CO2 Eco",{"$f":"B34*LOOKUP(Tool!H7,SourceEnergie,FactEmis)","v":{"v":2448.832017241303,"d":"2,449 "}},"kg/an",{"$nulls":4},{"$f":"H34*LOOKUP(Tool!H7,SourceEnergie,FactEmis)","v":{"$error":"#VALUE!"}},"kg/an"]
["CO2 Eco durée de vie",{"$f":"B40*Hyp!B9/1000","v":{"v":61.22080043103258,"d":"61 "}},"tonnes",{"$nulls":4},{"$f":"H40*Hyp!B9/1000","v":{"$error":"#VALUE!"}},"tonnes"]
["Cout CO2 évité",{"$f":"B23/B41","v":{"v":401.4157173316951,"d":"401 "}},"EUR/tonne",{"$nulls":4},{"$f":"H23/H41","v":{"$error":"#VALUE!"}},"EUR/tonne"]