{"text_format":"1","workbook":"xlsx","n_sheets":7,"sheets":["ENTREE","Calcul (EF)","POST-TRAITEMENT & SORTIE","BASES","echangeurs","LISTES","ConditionsTests"],"not_rendered":{"charts":2,"images":3,"macros":1,"external_links":0,"defined_names":139,"comments":3,"pivot_tables":0},"unopened":[],"bounds":{"document_bytes":16777216,"sheet_cells":100000,"rows_first":2000,"rows_last":500,"rows_between":2000,"halvings":0,"cell_chars":16384,"cell_head_chars":4096},"cells_cut":0,"cells_raw":0,"read":"whole","date_system":"1900"}

{"sheet":"ENTREE","index":0,"n_rows":77,"n_cols":13,"rows_kept":77,"cut":false,"hidden":false,"merged":[[11,0,11,7],[5,0,5,7],[27,0,27,7],[0,0,0,7],[17,6,17,7],[18,6,18,7],[19,3,19,4],[23,3,23,4],[23,0,23,1],[19,0,19,1]]}
["Titre V : AmièsPAC"]
[]
["Légende :","A saisir"]
[null,"Calculé automatiquement"]
[]
["BATIMENT",null,null,null,null,null,null,null,null,"Données de calcul, pour information"]
[]
["Type de logement","Logements collectifs",null,"SHON",14592,null,"Zone géographique","H1a",null,"Qpr Ballon cogé - Par défaut (kWh/24h)",{"$f":"4.2*IF(BallonVH=\"NON\",70,60)*POWER(IF(AND(Nbr_ballons_Cogé>1,B21>0),B21,V_Cogé),0.55)/1000","v":19.227101901725938},"valeur ballon de stockage Cogé(à 80°C dans une ambiance de 10°C si non habitable / 20°C sinon)"]
["Unités",170,{"$f":"VLOOKUP(Type_Usage,BASES!A3:C14,3,FALSE)","v":"Nb logements"},"Surface habitable SHAB",12688,null,"Altitude (en m)",50,null,"Qpr Ballon PAC - Par défaut (kWh/24h)",{"$f":"4.2*IF(BallonVH=\"NON\",30,20)*POWER(IF(AND(Nbr_ballons_PAC>1,E21>0),E21,V_PAC),0.55)/1000","v":8.2401865293111172},"valeur ballon de stockage PAC (à 40°C dans une ambiance de 10°C si non habitable / 20°C sinon)"]
["Nb niveaux bat",10]
[]
["ECS",null,null,null,null,null,null,null,null,"Cnn utilisés :","RT2012"]
[null,null,null,null,null,null,null,null,null,null,null,"cnn / 35","cnn Tmax/35"]
["Heures creuses (PAC 2 services)  ?","NON",null,"Ballon en Volume Habitable ?","NON",null,"Nombre d'unité thermodynamiques Nbunités thermo",4,null,{"$f":"INT((TMAX-35)/10)","v":1},{"$f":"35+J14*10","v":45},{"$f":"POWER(Cnn55_45AirEau,J14)","v":0.8},{"$f":"L14+(TMAX-K14)*(L15-L14)/(K15-K14)","v":0.72000000000000008}]
["Réseau distrib collectif","RESEAU BOUCLE",null,null,null,null,null,null,null,{"$f":"J14+1","v":2},{"$f":"35+J15*10","v":55},{"$f":"POWER(Cnn55_45AirEau,J15)","v":0.64000000000000012}]
[]
["Saisie du ou des ballons Cogénération",null,null,"Saisie du ou des ballons PAC"]
["Nombre de ballons",1,null,"Nombre de ballons",1,null,"Si les Qpr ne sont pas renseignés, des valeurs par défaut sont utilisées."]
[null,null,null,null,null,null,"Pour saisir un ballon équivalent, cliquez sur les boutons ci-dessous :"]
["Si ballons identiques",null,null,"Si ballons identiques"]
["V unitaire ballon Cogé (L)",2000,null,"V unitaire ballon PAC (L)",2000]
["Qpr unitaire ballon Cogé à 80°C (en kWh/24h)",null,null,"Qpr unitaire ballon PAC à 40°C (en kWh/24h)"]
[]
["Si ballons différents",null,null,"Si ballons différents",null,null,"Vérification : "]
["V équivalent ballon Cogé (L)",null,null,"V équivalent ballon PAC (L)",null,null,{"$f":"_xlfn.CONCAT(\"Saisie ballon Cogé : \",IF(AND(B21=0,B25=0),\"SAISIR UN BALLON COGE\",\"OK\"))","v":"Saisie ballon Cogé : OK"}]
["Qpr équivalent ballon Cogé à 80°C (en kWh/24h)",null,null,"Qpr équivalent ballon PAC à 40°C (en kWh/24h)",null,null,{"$f":"_xlfn.CONCAT(\"Saisie ballon PAC : \",IF(AND(E21=0,E25=0),\"SAISIR UN BALLON PAC\",\"OK\"))","v":"Saisie ballon PAC : OK"}]
[]
["SYSTÈME DE PRODUCTION ECS : POMPE A CHALEUR AIR/EAU"]
[]
["Type","AIR EXTERIEUR/EAU",null,"Débit condenseur PAC (m3/h)",14,null,"Mode de régulation du compresseur","ON/OFF"]
["Temp. stockage ECS PAC",40,null,"Débit pour 5 K de delta T",{"$f":"B37/(1.163*5)","v":14.376612209802234}]
["Efficacité circulateurs","Haute efficacité",null,"TMAX PAC à -7°C",50]
[]
[null,"Valeurs selon EN14-511",null,null,null,null,"Valeurs retenues"]
["T° Air","PUISS. DEPART 35°C","Certifié ?","COP DEPART 35","COP / défaut",null,"PUISS. DEPART 35°C","COP 35°C"]
["20°C (facultatif)",null,"NON",null,{"$f":"E37*Cnn20_7AirEau","v":5},null,{"$f":"IF(AND(C36=\"OUI\",NOT(ISBLANK(B36))),B36,G37*Cnn20_7AirEau)","v":104.5},{"$f":"IF(AND(C36=\"OUI\",NOT(ISBLANK(D36))),D36,E36)","v":5}]
["7°C (obligatoire)",{"$f":"20.9*Nb_unité_thermo","v":83.6},"OUI",4,{"$f":"IF(C37=\"OUI\",D37,IF(C37=\"PV ESSAI\",D37*CoeffPenaliteCertif,ValeurDefautPAC))","v":4},null,{"$f":"B37","v":83.6},{"$f":"E37","v":4}]
["2°C (facultatif)",null,"NON",null,{"$f":"E37*Cnn2_7AirEau","v":3.4},null,{"$f":"IF(AND(C38=\"OUI\",NOT(ISBLANK(B38))),B38,G$37*Cnn2_7AirEau)","v":71.059999999999988},{"$f":"IF(AND(C38=\"OUI\",NOT(ISBLANK(D38))),D38,E38)","v":3.4}]
["-7°C (facultatif)",null,"NON",null,{"$f":"E37*Cnn_7_7AirEau","v":2},null,{"$f":"IF(AND(C39=\"OUI\",NOT(ISBLANK(B39))),B39,G$37*Cnn_7_7AirEau)","v":41.8},{"$f":"IF(AND(C39=\"OUI\",NOT(ISBLANK(D39))),D39,E39)","v":2}]
[]
["T° Air",{"$f":"CONCATENATE(\"PUISS. DEPART \",TMAX,\"°C\")","v":"PUISS. DEPART 50°C"},"Certifié ?",{"$f":"CONCATENATE(\"COP DEPART \",TMAX,\"°C\")","v":"COP DEPART 50°C"},"COP / défaut",null,{"$f":"CONCATENATE(\"PUISS. DEPART \",TMAX,\"°C\")","v":"PUISS. DEPART 50°C"},"COP 40°C"]
["20°C (facultatif)",null,"NON",null,{"$f":"E36*cnnAirEau_Tmax_35","v":3.6000000000000005},null,{"$f":"IF(AND(C42=\"OUI\",NOT(ISBLANK(B42))),B42,G36*cnnAirEau_Tmax_35)","v":75.240000000000009},{"$f":"IF(AND(C42=\"OUI\",NOT(ISBLANK(D42))),D42,E42)","v":3.6000000000000005}]
["7°C (facultatif)",null,"NON",null,{"$f":"E37*cnnAirEau_Tmax_35","v":2.8800000000000003},null,{"$f":"IF(AND(C43=\"OUI\",NOT(ISBLANK(B43))),B43,G37*cnnAirEau_Tmax_35)","v":60.192},{"$f":"IF(AND(C43=\"OUI\",NOT(ISBLANK(D43))),D43,E43)","v":2.8800000000000003}]
["2°C (facultatif)",null,"NON",null,{"$f":"E38*cnnAirEau_Tmax_35","v":2.4480000000000004},null,{"$f":"IF(AND(C44=\"OUI\",NOT(ISBLANK(B44))),B44,G38*cnnAirEau_Tmax_35)","v":51.163199999999996},{"$f":"IF(AND(C44=\"OUI\",NOT(ISBLANK(D44))),D44,E44)","v":2.4480000000000004}]
["-7°C (facultatif)",null,"NON",null,{"$f":"E39*cnnAirEau_Tmax_35","v":1.4400000000000002},null,{"$f":"IF(AND(C45=\"OUI\",NOT(ISBLANK(B45))),B45,G39*cnnAirEau_Tmax_35)","v":30.096},{"$f":"IF(AND(C45=\"OUI\",NOT(ISBLANK(D45))),D45,E45)","v":1.4400000000000002}]
[]
["ECHANGEUR",null,null,"Données supplémentaires si échangeur à plaques"]
["Type d'échangeur","Ballon à serpentin",null,"Pcircul ECS (W)",200,null,"Puissance nominale maxi",{"$f":"IF(SousTypeSelect=\"AIR EXTERIEUR/EAU\",P20_TMAX,IF(LEFT(Captage_PACEG,9)=\"Nappe eau\",P10_TMAX_PACEG,P5_TMAX_PACEG))","v":75.240000000000009}]
["Surface d'échange (m2)",70,null,"Pincement (échangeur à plaques) °C",null,null,"Ratio m2/kW",{"$f":"IF(TypeRegulation=\"INVERTER\",B49/(0.7*H48),B49/H48)","v":0.93035619351408816}]
[null,null,null,"Débit ECS (m3/h)",11,null,"Pincement °C",{"$f":"IF(B48=\"Ballon à serpentin\",MAX(-100*H49+31.5,1),IF(B48=\"Echangeur à plaques\",IF(ISBLANK(E49),MAX(-200*H49+31.5,1),E49),3))","v":1}]
[]
["RECUPERATION DE CHALEUR"]
[]
["SOURCE  DE RECUPERATION DE CHALEUR","Aucune"]
[]
["Si VMC",null,null,"Si récupération de chaleur sur les fumées de chaudières"]
["VAmièsPAC total ",{"$f":"4500*Nb_unité_thermo","v":18000},null,"Déperditions par l'enveloppe HT",22117.61,null,"Déperditions par ventilation avec perméabilité Hv",7664.8469999999998]
["Qvarep",15300,null,"Consommation pour le chauffage Cchauffage",{"$f":"85.423","v":85.423000000000002},null,"Rendement chaudière Rpn",0.9]
["Rapport de dilution",{"$f":"IF(V_AmièsPAC_total>Qvarep,Qvarep/V_AmièsPAC_total,1)","v":0.85}]
[]
["Caractéristiques de la cogénération"]
[]
["Puissance nominale Pn_cogé [kW]",50,"Rconv-ECS-cogé",{"$f":"1/(1/Rpn_cogé+(dur_ECS-dur_ECS_vac)*Qp0_cogé/Requis_ECS)","v":0.7648284111850594}]
["Rpn-cogé",0.77,"Qp0_cogé [kW]",{"$f":"Qp0_30_cogé/Rpn_cogé*POWER(5/3,1.25)","v":1.4028423361359128}]
["R élec",0.32,"Qp0_30-cogé [kW]",{"$f":"P_nom*(2.5-0.8*LOG10(P_nom))/100","v":0.57041199826559241}]
[null,null,"Nbmois_cogé",12]
[null,null,"Requis ECS",{"$f":"'POST-TRAITEMENT & SORTIE'!C17*SHON","v":290744.16123864689}]
[null,null,"dur_ECS",{"$f":"VLOOKUP(Type_Usage,BASES!A3:F14,5,FALSE)","v":1820}]
[null,null,"dur_vac-ECS",{"$f":"VLOOKUP(Type_Usage,BASES!A3:F14,6,FALSE)","v":0}]
[]
[]
["DONNEES DE SORTIE",null,null,null,null,null,"Version 19/06/2020"]
[]
["Consommation totale pour l'ECS C ECS",{"$f":"'POST-TRAITEMENT & SORTIE'!B21","v":12.035860198141798},"kWh ep /m².an"]
["Gain / cas mini-cogé seule",{"$f":"'POST-TRAITEMENT & SORTIE'!B23","v":0.59175850759185078}]
[]
[null,{"$f":"IF(OR(G25=\"Saisie ballon Cogé : SAISIR UN BALLON COGE\",G26=\"Saisie ballon PAC : SAISIR UN BALLON PAC\"),\"Attention, problème de ballon non saisi!\",\"\")","v":""}]

{"sheet":"Calcul (EF)","index":1,"n_rows":83,"n_cols":16,"rows_kept":83,"cut":false,"hidden":true,"merged":[[0,6,0,7]]}
["CALCUL DU BESOIN ECS","ah moyen",{"$f":"VLOOKUP(Type_Usage,BASES!A3:D14,4,FALSE)","v":0.14299999999999999},"a",{"$f":"VLOOKUP(Type_Usage,TableUsages,2,FALSE)","v":12.806403614581576},null,"Référence pour besoin ECS",null,{"$f":"IF(ENTREE!B8=\"Logements collectifs\",SHAB,Nbr_lgt)","v":12688}]
[]
[null,"Volume PAC",{"$f":"IF(ENTREE!E21=0,ENTREE!E25,ENTREE!E21*Nbr_ballons_PAC)","v":2000}]
[null,"Qpr PAC",{"$f":"IF(ENTREE!E21=\"\",ENTREE!E26,IF(ENTREE!E22=\"\",Qpr_PAC_défaut*Nbr_ballons_PAC,ENTREE!E22*Nbr_ballons_PAC))","v":8.2401865293111172}]
[null,"Volume Cogé",{"$f":"IF(ENTREE!B21=0,ENTREE!B25,ENTREE!B21*Nbr_ballons_Cogé)","v":2000}]
[null,"Qpr Cogé",{"$f":"IF(ENTREE!B21=0,ENTREE!B26,IF(ENTREE!B22=0,Qpr_Cogé_défaut,ENTREE!B22)*Nbr_ballons_Cogé)","v":19.227101901725938}]
[]
[]
["CALCUL AU PAS MENSUEL","Mois",1,2,3,4,5,6,7,8,9,10,11,12]
[null,"Nb de jours",31,28,31,30,31,30,31,31,30,31,30,31,{"$f":"SUM(C10:N10)","v":365}]
[]
["DONNEES CLIMATIQUES","Température eau froide",{"$f":"VLOOKUP(ZoneSelect,TableTEauFroide,2,0)","v":5.8309677419354804},{"$f":"VLOOKUP(ZoneSelect,TableTEauFroide,3,0)","v":5.8651428571428577},{"$f":"VLOOKUP(ZoneSelect,TableTEauFroide,4,0)","v":7.1909032258064522},{"$f":"VLOOKUP(ZoneSelect,TableTEauFroide,5,0)","v":9.3479333333333354},{"$f":"VLOOKUP(ZoneSelect,TableTEauFroide,6,0)","v":11.866387096774199},{"$f":"VLOOKUP(ZoneSelect,TableTEauFroide,7,0)","v":13.9596},{"$f":"VLOOKUP(ZoneSelect,TableTEauFroide,8,0)","v":15.165290322580651},{"$f":"VLOOKUP(ZoneSelect,TableTEauFroide,9,0)","v":15.101935483870971},{"$f":"VLOOKUP(ZoneSelect,TableTEauFroide,10,0)","v":13.817933333333333},{"$f":"VLOOKUP(ZoneSelect,TableTEauFroide,11,0)","v":11.632193548387098},{"$f":"VLOOKUP(ZoneSelect,TableTEauFroide,12,0)","v":9.1525999999999996},{"$f":"VLOOKUP(ZoneSelect,TableTEauFroide,13,0)","v":7.0303870967741959}]
[null,"Température extérieure",{"$f":"VLOOKUP(ZoneSelect,TableTEXT,2,0)","v":3.9094892473118246},{"$f":"VLOOKUP(ZoneSelect,TableTEXT,3,0)","v":4.44114583333333},{"$f":"VLOOKUP(ZoneSelect,TableTEXT,4,0)","v":7.5451209677419326},{"$f":"VLOOKUP(ZoneSelect,TableTEXT,5,0)","v":9.6573611111110917},{"$f":"VLOOKUP(ZoneSelect,TableTEXT,6,0)","v":13.708239247311861},{"$f":"VLOOKUP(ZoneSelect,TableTEXT,7,0)","v":16.474444444444451},{"$f":"VLOOKUP(ZoneSelect,TableTEXT,8,0)","v":18.980887096774254},{"$f":"VLOOKUP(ZoneSelect,TableTEXT,9,0)","v":19.108642473118319},{"$f":"VLOOKUP(ZoneSelect,TableTEXT,10,0)","v":15.407083333333357},{"$f":"VLOOKUP(ZoneSelect,TableTEXT,11,0)","v":11.976303763440834},{"$f":"VLOOKUP(ZoneSelect,TableTEXT,12,0)","v":6.9559722222222291},{"$f":"VLOOKUP(ZoneSelect,TableTEXT,13,0)","v":4.7526612903225711}]
[null,"qexterieur",{"$f":"IF(Altitude<400,C13,IF(Altitude<800,C13-2,C13-4))","v":3.9094892473118246},4.44114583333333,7.5451209677419326,9.6573611111110917,13.708239247311861,16.474444444444451,18.980887096774254,19.108642473118319,15.407083333333357,11.976303763440834,6.9559722222222291,4.7526612903225711]
["Récup VMC","Tsource_amont",{"$f":"IF(V_AmièsPAC_total>Qvarep,BASES!$B$232*ENTREE!$B$59+(1-ENTREE!$B$59)*C14,BASES!$B$232)","v":17.586423387096772},{"$f":"IF(V_AmièsPAC_total>Qvarep,BASES!$B$232*ENTREE!$B$59+(1-ENTREE!$B$59)*D14,BASES!$B$232)","v":17.666171875},{"$f":"IF(V_AmièsPAC_total>Qvarep,BASES!$B$232*ENTREE!$B$59+(1-ENTREE!$B$59)*E14,BASES!$B$232)","v":18.131768145161288},{"$f":"IF(V_AmièsPAC_total>Qvarep,BASES!$B$232*ENTREE!$B$59+(1-ENTREE!$B$59)*F14,BASES!$B$232)","v":18.448604166666662},{"$f":"IF(V_AmièsPAC_total>Qvarep,BASES!$B$232*ENTREE!$B$59+(1-ENTREE!$B$59)*G14,BASES!$B$232)","v":19.056235887096779},{"$f":"IF(V_AmièsPAC_total>Qvarep,BASES!$B$232*ENTREE!$B$59+(1-ENTREE!$B$59)*H14,BASES!$B$232)","v":19.471166666666669},{"$f":"I14","v":18.980887096774254},19.108642473118319,{"$f":"IF(V_AmièsPAC_total>Qvarep,BASES!$B$232*ENTREE!$B$59+(1-ENTREE!$B$59)*K14,BASES!$B$232)","v":19.311062500000006},{"$f":"IF(V_AmièsPAC_total>Qvarep,BASES!$B$232*ENTREE!$B$59+(1-ENTREE!$B$59)*L14,BASES!$B$232)","v":18.796445564516127},{"$f":"IF(V_AmièsPAC_total>Qvarep,BASES!$B$232*ENTREE!$B$59+(1-ENTREE!$B$59)*M14,BASES!$B$232)","v":18.043395833333335},{"$f":"IF(V_AmièsPAC_total>Qvarep,BASES!$B$232*ENTREE!$B$59+(1-ENTREE!$B$59)*N14,BASES!$B$232)","v":17.712899193548385}]
["Récup Fumées","Besoin mensuel (kWh)",{"$f":"(Ht+Hv)*(20-C14)*C10*24/1000","v":356535.91878238012},311391.96828635014,275977.05301851005,221781.02254190046,139413.76598898927,75599.788848799857,22581.654546538673,19750.832008689122,98487.607053299493,177790.2487809106,279707.90140689985,337852.78785714024]
[null,null,{"$f":"C16/SUM($C$16:$N$16)","v":0.1538868535049305},{"$f":"D16/SUM($C$16:$N$16)","v":0.13440197097095866},0.11911630242927633,9.5724391086976723E-2,6.0173308362833314E-2,3.2630130706914576E-2,9.7466190137863867E-3,8.5247887570531113E-3,4.2508895065669496E-2,7.673723887957748E-2,0.12072659886547826,0.14582290235654508]
[null,"P_enfournée (kW)",{"$f":"C17*C_chauffage*SHON/(24*C10)*PCS_gaz/PCI_gaz","v":290.68049650590183},281.07594120180465,225.00158488834026,186.84325523359843,113.66277724789988,63.690348622203707,18.410617864056306,16.102673958622027,82.972586613128243,144.95077513098212,235.64475541882737,275.44830954370025]
[null,"Volume_gaz_nat (Nm3 PCS)",{"$f":"C18/PCS_gaz","v":25.27656491355668},{"$f":"D18/PCS_gaz","v":24.441386191461273},19.565355207681762,16.247239585530298,9.8837197606869456,5.5382911845394531,1.6009232925266352,1.4002325181410458,7.2150075315763686,12.604415228781054,20.490848297289336,23.952026916843501]
[null,"Chaleur_récupérable (kWh)",{"$f":"C19*(PCS_gaz-PCI_gaz)*Rpn","v":29.573580948861334},28.596421844009704,22.891465592987675,19.009270315070459,11.563952120003734,6.4798006859111634,1.8730802522561643,1.6382720462250244,8.4415588119443559,14.747165817673842,23.974292507828537,28.023871492706913]
[null,null,{"$f":"C20*1000/(V_AmièsPAC_total*0.34)","v":4.8322844687681918},{"$f":"D20*1000/(V_AmièsPAC_total*0.34)","v":4.6726179483675985},3.7404355544097507,3.1060899207631469,1.8895346601313292,1.0587909617501901,0.30605886474773925,0.26769151082108245,1.3793396751543066,2.4096676172669675,3.9173680568347282,4.5790639693965547]
[null,"Température source amont",{"$f":"C21+C14","v":8.7417737160800169},9.1137637817009285,11.285556522151683,12.763451031874238,15.597773907443189,{"$f":"H13","v":16.474444444444451},{"$f":"I13","v":18.980887096774254},19.108642473118319,16.786423008487663,14.385971380707801,10.873340279056958,9.3317252597191249]
[null,"θamont",{"$f":"IF(Source_récup=\"Aucune\",'Calcul (EF)'!C14,IF(Source_récup=\"VMC\",'Calcul (EF)'!C15,'Calcul (EF)'!C22))","v":3.9094892473118246},{"$f":"IF(Source_récup=\"Aucune\",'Calcul (EF)'!D14,IF(Source_récup=\"VMC\",'Calcul (EF)'!D15,'Calcul (EF)'!D22))","v":4.44114583333333},{"$f":"IF(Source_récup=\"Aucune\",'Calcul (EF)'!E14,IF(Source_récup=\"VMC\",'Calcul (EF)'!E15,'Calcul (EF)'!E22))","v":7.5451209677419326},{"$f":"IF(Source_récup=\"Aucune\",'Calcul (EF)'!F14,IF(Source_récup=\"VMC\",'Calcul (EF)'!F15,'Calcul (EF)'!F22))","v":9.6573611111110917},{"$f":"IF(Source_récup=\"Aucune\",'Calcul (EF)'!G14,IF(Source_récup=\"VMC\",'Calcul (EF)'!G15,'Calcul (EF)'!G22))","v":13.708239247311861},{"$f":"IF(Source_récup=\"Aucune\",'Calcul (EF)'!H14,IF(Source_récup=\"VMC\",'Calcul (EF)'!H15,'Calcul (EF)'!H22))","v":16.474444444444451},{"$f":"IF(Source_récup=\"Aucune\",'Calcul (EF)'!I14,IF(Source_récup=\"VMC\",'Calcul (EF)'!I15,'Calcul (EF)'!I22))","v":18.980887096774254},{"$f":"IF(Source_récup=\"Aucune\",'Calcul (EF)'!J14,IF(Source_récup=\"VMC\",'Calcul (EF)'!J15,'Calcul (EF)'!J22))","v":19.108642473118319},{"$f":"IF(Source_récup=\"Aucune\",'Calcul (EF)'!K14,IF(Source_récup=\"VMC\",'Calcul (EF)'!K15,'Calcul (EF)'!K22))","v":15.407083333333357},{"$f":"IF(Source_récup=\"Aucune\",'Calcul (EF)'!L14,IF(Source_récup=\"VMC\",'Calcul (EF)'!L15,'Calcul (EF)'!L22))","v":11.976303763440834},{"$f":"IF(Source_récup=\"Aucune\",'Calcul (EF)'!M14,IF(Source_récup=\"VMC\",'Calcul (EF)'!M15,'Calcul (EF)'!M22))","v":6.9559722222222291},{"$f":"IF(Source_récup=\"Aucune\",'Calcul (EF)'!N14,IF(Source_récup=\"VMC\",'Calcul (EF)'!N15,'Calcul (EF)'!N22))","v":4.7526612903225711}]
[]
[]
["BESOIN ECS MENSUEL","Vuw mensuel (L)",{"$f":"ah*a*Ref_Besoin*C10","v":720307.74829100829},650600.54684349126,720307.74829100829,697072.01447516924,720307.74829100829,697072.01447516924,720307.74829100829,720307.74829100829,697072.01447516924,720307.74829100829,697072.01447516924,720307.74829100829]
[null,"BESOIN MENSUEL en kWh/m2",{"$f":"MasseVolumiqueEau*CpEau*(TEauMitigee-'Calcul (EF)'!C12)*'Calcul (EF)'!C26/SHON","v":1.9616235151510988},{"$f":"MasseVolumiqueEau*CpEau*(TEauMitigee-'Calcul (EF)'!D12)*'Calcul (EF)'!D26/SHON","v":1.7700168770222575},{"$f":"MasseVolumiqueEau*CpEau*(TEauMitigee-'Calcul (EF)'!E12)*'Calcul (EF)'!E26/SHON","v":1.8835504399729139},{"$f":"MasseVolumiqueEau*CpEau*(TEauMitigee-'Calcul (EF)'!F12)*'Calcul (EF)'!F26/SHON","v":1.702951590611546},{"$f":"MasseVolumiqueEau*CpEau*(TEauMitigee-'Calcul (EF)'!G12)*'Calcul (EF)'!G26/SHON","v":1.6151337333851716},{"$f":"MasseVolumiqueEau*CpEau*(TEauMitigee-'Calcul (EF)'!H12)*'Calcul (EF)'!H26/SHON","v":1.4467390105341751},{"$f":"MasseVolumiqueEau*CpEau*(TEauMitigee-'Calcul (EF)'!I12)*'Calcul (EF)'!I26/SHON","v":1.4257456906371233},{"$f":"MasseVolumiqueEau*CpEau*(TEauMitigee-'Calcul (EF)'!J12)*'Calcul (EF)'!J26/SHON","v":1.4293828536820963},{"$f":"MasseVolumiqueEau*CpEau*(TEauMitigee-'Calcul (EF)'!K12)*'Calcul (EF)'!K26/SHON","v":1.454609653579559},{"$f":"MasseVolumiqueEau*CpEau*(TEauMitigee-'Calcul (EF)'!L12)*'Calcul (EF)'!L26/SHON","v":1.6285786436226974},{"$f":"MasseVolumiqueEau*CpEau*(TEauMitigee-'Calcul (EF)'!M12)*'Calcul (EF)'!M26/SHON","v":1.7138038184341222},{"$f":"MasseVolumiqueEau*CpEau*(TEauMitigee-'Calcul (EF)'!N12)*'Calcul (EF)'!N26/SHON","v":1.8927655740420504}]
[null,"Besoin à la PAC pour préchauffage à 40°C",{"$f":"MasseVolumiqueEau*CpEau*(T_ECS-'Calcul (EF)'!C12)*'Calcul (EF)'!C26/SHON","v":1.9616235151510988},{"$f":"MasseVolumiqueEau*CpEau*(T_ECS-'Calcul (EF)'!D12)*'Calcul (EF)'!D26/SHON","v":1.7700168770222575},{"$f":"MasseVolumiqueEau*CpEau*(T_ECS-'Calcul (EF)'!E12)*'Calcul (EF)'!E26/SHON","v":1.8835504399729139},{"$f":"MasseVolumiqueEau*CpEau*(T_ECS-'Calcul (EF)'!F12)*'Calcul (EF)'!F26/SHON","v":1.702951590611546},{"$f":"MasseVolumiqueEau*CpEau*(T_ECS-'Calcul (EF)'!G12)*'Calcul (EF)'!G26/SHON","v":1.6151337333851716},{"$f":"MasseVolumiqueEau*CpEau*(T_ECS-'Calcul (EF)'!H12)*'Calcul (EF)'!H26/SHON","v":1.4467390105341751},{"$f":"MasseVolumiqueEau*CpEau*(T_ECS-'Calcul (EF)'!I12)*'Calcul (EF)'!I26/SHON","v":1.4257456906371233},{"$f":"MasseVolumiqueEau*CpEau*(T_ECS-'Calcul (EF)'!J12)*'Calcul (EF)'!J26/SHON","v":1.4293828536820963},{"$f":"MasseVolumiqueEau*CpEau*(T_ECS-'Calcul (EF)'!K12)*'Calcul (EF)'!K26/SHON","v":1.454609653579559},{"$f":"MasseVolumiqueEau*CpEau*(T_ECS-'Calcul (EF)'!L12)*'Calcul (EF)'!L26/SHON","v":1.6285786436226974},{"$f":"MasseVolumiqueEau*CpEau*(T_ECS-'Calcul (EF)'!M12)*'Calcul (EF)'!M26/SHON","v":1.7138038184341222},{"$f":"MasseVolumiqueEau*CpEau*(T_ECS-'Calcul (EF)'!N12)*'Calcul (EF)'!N26/SHON","v":1.8927655740420504}]
[]
["BESOIN ECS QUOTIDIEN","Vuw quotidien (L à 40°C)",{"$f":"C26/C10","v":23235.733815838976},23235.733815838972,23235.733815838976,23235.733815838976,23235.733815838976,23235.733815838976,23235.733815838976,23235.733815838976,23235.733815838976,23235.733815838976,23235.733815838976,23235.733815838976]
[null,"Besoin quotidien (kWh)",{"$f":"C27*SHON/C10","v":923.35517203499455},922.43165248245646,886.60542000273426,828.31565367345604,760.2590786308524,703.69385472382271,671.11229412183559,672.82434196545648,707.52213550109752,766.58772799169037,833.59417728635708,890.94307278779354]
[null,"Volume prélevé L",{"$f":"C30*(40-C12)/(T_ECS-C12)","v":23235.733815838976},23235.733815838972,23235.733815838976,23235.733815838976,23235.733815838976,23235.733815838976,23235.733815838976,23235.733815838972,23235.733815838976,23235.733815838976,23235.733815838976,23235.733815838976]
[null,"Volume prélevé L / clé",{"$f":"C32/5","v":4647.1467631677951},{"$f":"D32/5","v":4647.1467631677942},4647.1467631677951,4647.1467631677951,4647.1467631677951,4647.1467631677951,4647.1467631677951,4647.1467631677942,4647.1467631677951,4647.1467631677951,4647.1467631677951,4647.1467631677951]
[null,"T° d'eau froide moyenne dans l'échangeur / puisage",{"$f":"IF(TypeEchangeur=\"Ballon à serpentin\",('Calcul (EF)'!C33*'Calcul (EF)'!C$12+(SurfaceEchangeur*VEchangem2-'Calcul (EF)'!C33)*T_ECS)/(SurfaceEchangeur*VEchangem2),(C33*C$12+(V_PAC*Nbr_ballons_PAC-C33)*T_ECS)/(V_PAC*Nbr_ballons_PAC))","v":2.1932124622284497},{"$f":"IF(TypeEchangeur=\"Ballon à serpentin\",('Calcul (EF)'!D33*'Calcul (EF)'!D$12+(SurfaceEchangeur*VEchangem2-'Calcul (EF)'!D33)*T_ECS)/(SurfaceEchangeur*VEchangem2),(D33*D$12+(V_PAC*Nbr_ballons_PAC-D33)*T_ECS)/(V_PAC*Nbr_ballons_PAC))","v":2.2310259803277073},{"$f":"IF(TypeEchangeur=\"Ballon à serpentin\",('Calcul (EF)'!E33*'Calcul (EF)'!E$12+(SurfaceEchangeur*VEchangem2-'Calcul (EF)'!E33)*T_ECS)/(SurfaceEchangeur*VEchangem2),(E33*E$12+(V_PAC*Nbr_ballons_PAC-E33)*T_ECS)/(V_PAC*Nbr_ballons_PAC))","v":3.6979314579398816},{"$f":"IF(TypeEchangeur=\"Ballon à serpentin\",('Calcul (EF)'!F33*'Calcul (EF)'!F$12+(SurfaceEchangeur*VEchangem2-'Calcul (EF)'!F33)*T_ECS)/(SurfaceEchangeur*VEchangem2),(F33*F$12+(V_PAC*Nbr_ballons_PAC-F33)*T_ECS)/(V_PAC*Nbr_ballons_PAC))","v":6.0846065727610821},{"$f":"IF(TypeEchangeur=\"Ballon à serpentin\",('Calcul (EF)'!G33*'Calcul (EF)'!G$12+(SurfaceEchangeur*VEchangem2-'Calcul (EF)'!G33)*T_ECS)/(SurfaceEchangeur*VEchangem2),(G33*G$12+(V_PAC*Nbr_ballons_PAC-G33)*T_ECS)/(V_PAC*Nbr_ballons_PAC))","v":8.871183776323452},{"$f":"IF(TypeEchangeur=\"Ballon à serpentin\",('Calcul (EF)'!H33*'Calcul (EF)'!H$12+(SurfaceEchangeur*VEchangem2-'Calcul (EF)'!H33)*T_ECS)/(SurfaceEchangeur*VEchangem2),(H33*H$12+(V_PAC*Nbr_ballons_PAC-H33)*T_ECS)/(V_PAC*Nbr_ballons_PAC))","v":11.187247482953655},{"$f":"IF(TypeEchangeur=\"Ballon à serpentin\",('Calcul (EF)'!I33*'Calcul (EF)'!I$12+(SurfaceEchangeur*VEchangem2-'Calcul (EF)'!I33)*T_ECS)/(SurfaceEchangeur*VEchangem2),(I33*I$12+(V_PAC*Nbr_ballons_PAC-I33)*T_ECS)/(V_PAC*Nbr_ballons_PAC))","v":12.521299835325893},{"$f":"IF(TypeEchangeur=\"Ballon à serpentin\",('Calcul (EF)'!J33*'Calcul (EF)'!J$12+(SurfaceEchangeur*VEchangem2-'Calcul (EF)'!J33)*T_ECS)/(SurfaceEchangeur*VEchangem2),(J33*J$12+(V_PAC*Nbr_ballons_PAC-J33)*T_ECS)/(V_PAC*Nbr_ballons_PAC))","v":12.451200017792399},{"$f":"IF(TypeEchangeur=\"Ballon à serpentin\",('Calcul (EF)'!K33*'Calcul (EF)'!K$12+(SurfaceEchangeur*VEchangem2-'Calcul (EF)'!K33)*T_ECS)/(SurfaceEchangeur*VEchangem2),(K33*K$12+(V_PAC*Nbr_ballons_PAC-K33)*T_ECS)/(V_PAC*Nbr_ballons_PAC))","v":11.030498484989661},{"$f":"IF(TypeEchangeur=\"Ballon à serpentin\",('Calcul (EF)'!L33*'Calcul (EF)'!L$12+(SurfaceEchangeur*VEchangem2-'Calcul (EF)'!L33)*T_ECS)/(SurfaceEchangeur*VEchangem2),(L33*L$12+(V_PAC*Nbr_ballons_PAC-L33)*T_ECS)/(V_PAC*Nbr_ballons_PAC))","v":8.6120571595753823},{"$f":"IF(TypeEchangeur=\"Ballon à serpentin\",('Calcul (EF)'!M33*'Calcul (EF)'!M$12+(SurfaceEchangeur*VEchangem2-'Calcul (EF)'!M33)*T_ECS)/(SurfaceEchangeur*VEchangem2),(M33*M$12+(V_PAC*Nbr_ballons_PAC-M33)*T_ECS)/(V_PAC*Nbr_ballons_PAC))","v":5.8684773661566076},{"$f":"IF(TypeEchangeur=\"Ballon à serpentin\",('Calcul (EF)'!N33*'Calcul (EF)'!N$12+(SurfaceEchangeur*VEchangem2-'Calcul (EF)'!N33)*T_ECS)/(SurfaceEchangeur*VEchangem2),(N33*N$12+(V_PAC*Nbr_ballons_PAC-N33)*T_ECS)/(V_PAC*Nbr_ballons_PAC))","v":3.5203262175902457}]
[null,"T° d'eau froide moyenne dans l'échangeur / V quotidien",{"$f":"IF(TypeEchangeur=\"Ballon à serpentin\",('Calcul (EF)'!C32*'Calcul (EF)'!C$12+(SurfaceEchangeur*VEchangem2-'Calcul (EF)'!C32)*T_ECS)/(SurfaceEchangeur*VEchangem2),(C32*C$12+(V_PAC*Nbr_ballons_PAC-C32)*T_ECS)/(V_PAC*Nbr_ballons_PAC))","v":-149.03393768885775},{"$f":"IF(TypeEchangeur=\"Ballon à serpentin\",('Calcul (EF)'!D32*'Calcul (EF)'!D$12+(SurfaceEchangeur*VEchangem2-'Calcul (EF)'!D32)*T_ECS)/(SurfaceEchangeur*VEchangem2),(D32*D$12+(V_PAC*Nbr_ballons_PAC-D32)*T_ECS)/(V_PAC*Nbr_ballons_PAC))","v":-148.84487009836147},{"$f":"IF(TypeEchangeur=\"Ballon à serpentin\",('Calcul (EF)'!E32*'Calcul (EF)'!E$12+(SurfaceEchangeur*VEchangem2-'Calcul (EF)'!E32)*T_ECS)/(SurfaceEchangeur*VEchangem2),(E32*E$12+(V_PAC*Nbr_ballons_PAC-E32)*T_ECS)/(V_PAC*Nbr_ballons_PAC))","v":-141.51034271030059},{"$f":"IF(TypeEchangeur=\"Ballon à serpentin\",('Calcul (EF)'!F32*'Calcul (EF)'!F$12+(SurfaceEchangeur*VEchangem2-'Calcul (EF)'!F32)*T_ECS)/(SurfaceEchangeur*VEchangem2),(F32*F$12+(V_PAC*Nbr_ballons_PAC-F32)*T_ECS)/(V_PAC*Nbr_ballons_PAC))","v":-129.57696713619461},{"$f":"IF(TypeEchangeur=\"Ballon à serpentin\",('Calcul (EF)'!G32*'Calcul (EF)'!G$12+(SurfaceEchangeur*VEchangem2-'Calcul (EF)'!G32)*T_ECS)/(SurfaceEchangeur*VEchangem2),(G32*G$12+(V_PAC*Nbr_ballons_PAC-G32)*T_ECS)/(V_PAC*Nbr_ballons_PAC))","v":-115.64408111838273},{"$f":"IF(TypeEchangeur=\"Ballon à serpentin\",('Calcul (EF)'!H32*'Calcul (EF)'!H$12+(SurfaceEchangeur*VEchangem2-'Calcul (EF)'!H32)*T_ECS)/(SurfaceEchangeur*VEchangem2),(H32*H$12+(V_PAC*Nbr_ballons_PAC-H32)*T_ECS)/(V_PAC*Nbr_ballons_PAC))","v":-104.06376258523173},{"$f":"IF(TypeEchangeur=\"Ballon à serpentin\",('Calcul (EF)'!I32*'Calcul (EF)'!I$12+(SurfaceEchangeur*VEchangem2-'Calcul (EF)'!I32)*T_ECS)/(SurfaceEchangeur*VEchangem2),(I32*I$12+(V_PAC*Nbr_ballons_PAC-I32)*T_ECS)/(V_PAC*Nbr_ballons_PAC))","v":-97.39350082337053},{"$f":"IF(TypeEchangeur=\"Ballon à serpentin\",('Calcul (EF)'!J32*'Calcul (EF)'!J$12+(SurfaceEchangeur*VEchangem2-'Calcul (EF)'!J32)*T_ECS)/(SurfaceEchangeur*VEchangem2),(J32*J$12+(V_PAC*Nbr_ballons_PAC-J32)*T_ECS)/(V_PAC*Nbr_ballons_PAC))","v":-97.743999911038031},{"$f":"IF(TypeEchangeur=\"Ballon à serpentin\",('Calcul (EF)'!K32*'Calcul (EF)'!K$12+(SurfaceEchangeur*VEchangem2-'Calcul (EF)'!K32)*T_ECS)/(SurfaceEchangeur*VEchangem2),(K32*K$12+(V_PAC*Nbr_ballons_PAC-K32)*T_ECS)/(V_PAC*Nbr_ballons_PAC))","v":-104.84750757505169},{"$f":"IF(TypeEchangeur=\"Ballon à serpentin\",('Calcul (EF)'!L32*'Calcul (EF)'!L$12+(SurfaceEchangeur*VEchangem2-'Calcul (EF)'!L32)*T_ECS)/(SurfaceEchangeur*VEchangem2),(L32*L$12+(V_PAC*Nbr_ballons_PAC-L32)*T_ECS)/(V_PAC*Nbr_ballons_PAC))","v":-116.93971420212308},{"$f":"IF(TypeEchangeur=\"Ballon à serpentin\",('Calcul (EF)'!M32*'Calcul (EF)'!M$12+(SurfaceEchangeur*VEchangem2-'Calcul (EF)'!M32)*T_ECS)/(SurfaceEchangeur*VEchangem2),(M32*M$12+(V_PAC*Nbr_ballons_PAC-M32)*T_ECS)/(V_PAC*Nbr_ballons_PAC))","v":-130.65761316921694},{"$f":"IF(TypeEchangeur=\"Ballon à serpentin\",('Calcul (EF)'!N32*'Calcul (EF)'!N$12+(SurfaceEchangeur*VEchangem2-'Calcul (EF)'!N32)*T_ECS)/(SurfaceEchangeur*VEchangem2),(N32*N$12+(V_PAC*Nbr_ballons_PAC-N32)*T_ECS)/(V_PAC*Nbr_ballons_PAC))","v":-142.3983689120488}]
[]
["PERTES DE DISTRIBUTION","Mensuel, en kWh/m2",null,null,null,null,null,null,null,null,null,null,null,null,"Total"]
["Collectif, volume chauffé","Qd,w_col,vc",{"$f":"0.8*0.14*C27","v":0.21970183369692309},{"$f":"0.8*0.14*D27","v":0.19824189022649288},0.21095764927696639,0.19073057814849317,0.18089497813913924,0.16203476917982762,0.15968351735135783,0.16009087961239479,0.16291628120091062,0.18240080808574213,0.19194602766462171,0.21198974429270967,{"$f":"SUM(C38:N38)","v":2.2315889568755791}]
["Collectif, hors volume chauffé","Qd,w_col,hvc",{"$f":"0.2*0.14*C27","v":5.4925458424230772E-2},{"$f":"0.2*0.14*D27","v":4.9560472556623221E-2},5.2739412319241598E-2,4.7682644537123293E-2,4.522374453478481E-2,4.0508692294956905E-2,3.9920879337839457E-2,4.0022719903098698E-2,4.0729070300227654E-2,4.5600202021435533E-2,4.7986506916155428E-2,5.2997436073177417E-2,{"$f":"SUM(C39:N39)","v":0.55789723921889478}]
[null,"PERTES DE DISTRIBUTION réseau bouclé en kWh/m2",{"$f":"C38+C39","v":0.27462729212115389},0.2478023627831161,0.26369706159620798,0.23841322268561646,0.22611872267392405,0.20254346147478453,0.19960439668919727,0.20011359951549348,0.20364535150113827,0.22800101010717766,0.23993253458077712,0.26498718036588709,2.7894861960944741]
[]
["PERTES DE STOCKAGE","PERTES DE STOCKAGE BALLON préchauffage en kWh/m2 (T ECS)",{"$f":"Qpr_ballon_PAC*(T_ballon_PAC-T_int)/45*C10/SHON","v":7.7803905460722663E-3},7.027449525484627E-3,7.7803905460722663E-3,7.5294102058763865E-3,7.7803905460722663E-3,7.5294102058763865E-3,7.7803905460722663E-3,7.7803905460722663E-3,7.5294102058763865E-3,7.7803905460722663E-3,7.5294102058763865E-3,7.7803905460722663E-3,9.1607824171496044E-2]
[null,"PERTES DE STOCKAGE BALLON cogé en kWh/m2 (T ECS)",{"$f":"Qpr_ballonCogé*(T_ballon_cogé-T_int)/45*C10/SHON","v":5.4462733822505861E-2},4.919214667839239E-2,5.4462733822505861E-2,5.27058714411347E-2,5.4462733822505861E-2,5.27058714411347E-2,5.4462733822505861E-2,5.4462733822505861E-2,5.27058714411347E-2,5.4462733822505861E-2,5.27058714411347E-2,5.4462733822505861E-2,0.64125476920047231]
[]
["BESOIN TOTAL","Besoin total kWh/m2",{"$f":"C$42+C$28+C43+C40","v":2.2984939316408308},2.074038836009251,2.2094906259377001,2.0016000949441737,1.9034955804276739,1.7095177536559709,1.6875932116948986,1.6917395775661679,1.7184902867277083,1.9188227780984533,2.0139716346619103,2.2199958787765155,{"$f":"SUM(C45:N45)","v":23.447250190141251}]
[]
[]
["PAC AIR/EAU","Besoin total PAC kWh/m2",{"$f":"C$42+C$28","v":1.9694039056971711},1.7770443265477422,1.8913308305189862,1.7104810008174225,1.6229141239312439,1.4542684207400516,1.4335260811831956,1.4371632442281685,1.4621390637854355,1.6363590341687697,1.7213332286399987,1.9005459645881226,{"$f":"SUM(C48:N48)","v":20.016509224846306}]
[null,"Puissance départ à 35°C pour θ source amont",{"$f":"IF(C$23>20,P20_35,IF(C$23>7,P7_35+(P20_35-P7_35)/13*(C$23-7),IF(C$23>2,P2_35+(P7_35-P2_35)/5*(C$23-2),P_7_35+(P2_35-P_7_35)/9*(C$23+7))))","v":75.84899903225805},77.182393749999989,84.476386786600486,87.872219017093983,94.384784636062918,98.83199145299146,102.86158002481399,103.06697136062868,97.116003205128237,91.6003652812241,83.489578333333341,77.963674516129004]
[null,"COP départ à 35°C pour θ source amont",{"$f":"IF(C$23>20,COP20_35,IF(C$23>7,COP7_35+(COP20_35-COP7_35)/13*(C$23-7),IF(C$23>2,COP2_35+(COP7_35-COP2_35)/5*(C$23-2),COP_7_35+(COP2_35-COP_7_35)/9*(C$23+7))))","v":3.6291387096774188},3.6929374999999998,4.0419323821339948,4.204412393162392,4.5160184036393742,4.7288034188034196,4.9216066997518659,4.9314340363937168,4.6466987179487198,4.3827925971877564,3.9947166666666676,3.7303193548387084]
[null,"Puissance départ à Tmax pour θ source amont",{"$f":"IF(C$23>20,P20_TMAX,IF(C$23>7,P7_TMAX+(P20_TMAX-P7_TMAX)/13*(C$23-7),IF(C$23>2,P2_TMAX+(P7_TMAX-P2_TMAX)/5*(C$23-2),P_7_TMAX+(P2_TMAX-P_7_TMAX)/9*(C$23+7))))","v":54.6112793032258},55.571323499999991,60.822998486352354,63.267997692307674,67.957044937965307,71.159033846153861,74.060337617866082,74.208219379652661,69.923522307692338,65.952263002481359,60.112496400000012,56.133845651612887]
[null,"COP départ à Tmax pour θ source amont",{"$f":"IF(C$23>20,COP20_TMAX,IF(C$23>7,COP7_TMAX+(COP20_TMAX-COP7_TMAX)/13*(C$23-7),IF(C$23>2,COP2_TMAX+(COP7_TMAX-COP2_TMAX)/5*(C$23-2),COP_7_TMAX+(COP2_TMAX-COP_7_TMAX)/9*(C$23+7))))","v":2.6129798709677421},2.6589149999999999,2.9101913151364767,3.0271769230769223,3.2515332506203496,3.4047384615384626,3.5435568238213437,3.5506325062034767,3.3456230769230788,3.1556106699751849,2.8761960000000011,2.6858299354838704]
[]
[null,"Puissance nécessaire pour besoins sur Tps max (W):",{"$f":"(C$42+C$27)*SHON/C$10*1000/TpsFonctMax","v":77251.456429927741},77174.496467216231,74188.97709390604,69331.496566466187,63660.115312915885,58946.346653996756,56231.216603831163,56373.887257466231,59265.37005210299,64187.502759652394,69771.373534207945,74550.448159327658]
[null,"Puissance moyenne pour θ source amont",{"$f":"(C49+C51)/2*1000","v":65230.139167741923},{"$f":"(D49+D51)/2*1000","v":66376.858624999979},{"$f":"(E49+E51)/2*1000","v":72649.692636476422},75570.108354700831,81170.914787014117,84995.512649572658,88460.958821340027,88637.595370140669,83519.762756410288,78776.314141852738,71801.037366666671,67048.760083870948]
[null,"Part assurée par la PAC :",{"$f":"IF(C55>C54,1,C55/C54)","v":0.84438717640113414},{"$f":"IF(D55>D54,1,D55/D54)","v":0.86008800398454044},{"$f":"IF(E55>E54,1,E55/E54)","v":0.97925184417246725},1,1,1,1,1,1,1,1,0.89937433964951818]
[null,"Appoint si puissance insuffisante kWh/m2",{"$f":"IF(C56<1,(C$28+C$42)*(1-C56),0)","v":0.30646450257217134},0.24862981873524273,3.924162679302487E-2,0,0,0,0,0,0,0,0,0.19124369271312328]
[]
[null,"Pincement échangeur",{"$f":"Pincement","v":1},1,1,1,1,1,1,1,1,1,1,1]
[null,"Delta T PAC",{"$f":"MAX(3,C51/(1.163*DEBITPAC))","v":3.3540891354394913},{"$f":"MAX(3,D51/(1.163*DEBITPAC))","v":3.413052665520206},3.735597499468883,3.8857632779945752,4.1737529135220059,4.3704111194051016,4.5486019910248174,4.5576845215362152,4.2945290693828975,4.0506241863703085,3.6919602260164606,3.4476013789222999]
[null,"T max thermo (milieu échangeur)",{"$f":"TMAX-C60/2-C59","v":47.322955432280253},{"$f":"TMAX-D60/2-D59","v":47.293473667239894},47.13220125026556,47.057118361002715,46.913123543238996,46.814794440297447,46.725699004487595,46.721157739231892,46.852735465308548,46.974687906814843,47.154019886991769,47.27619931053885]
[null,"Température d'ECS Début de charge",{"$f":"IF(HeuresCreuses=\"OUI\",IF(C$32/(V_PAC*Nbr_ballons_PAC)<0.85,C$35,C$34),IF((V_PAC*Nbr_ballons_PAC)>400,25,C$34))","v":25},25,25,25,25,25,25,25,25,25,25,25]
[null,"T depart PAC Debut de charge",{"$f":"C62+C$59+C$60/2","v":27.677044567719747},27.706526332760102,27.86779874973444,27.942881638997289,28.086876456761004,28.185205559702553,28.274300995512409,28.278842260768108,28.147264534691448,28.025312093185153,27.845980113008231,27.72380068946115]
[null,"T depart PAC pour TECS fin de charge ",{"$f":"T_ECS+C$59+C$60/2","v":42.677044567719747},{"$f":"T_ECS+D59+D60/2","v":42.706526332760106},42.86779874973444,42.942881638997285,43.086876456761004,43.185205559702553,43.274300995512405,43.278842260768108,43.147264534691452,43.025312093185157,42.845980113008231,42.72380068946115]
[null,"T depart PAC Fin de charge",{"$f":"MIN(C64,TMAX)","v":42.677044567719747},{"$f":"MIN(D64,TMAX)","v":42.706526332760106},42.86779874973444,42.942881638997285,43.086876456761004,43.185205559702553,43.274300995512405,43.278842260768108,43.147264534691452,43.025312093185157,42.845980113008231,42.72380068946115]
[null,"COP debut charge",{"$f":"IF(C63<25,1.2*C$50,IF(C63<35,1.2*C$50-0.2*C$50*(C63-25)/10,IF(C63<=TMAX,C$50+(C$52-C$50)/(TMAX-35)*(C63-35),1)))","v":4.1606591302480354},{"$f":"IF(D63<25,1.2*D50,IF(D63<35,1.2*D50-0.2*D50*(D63-25)/10,IF(D63<=TMAX,D50+(D52-D50)/(TMAX-35)*(D63-35),1)))","v":4.2316243482202545},4.6184898859208934,4.7978331111026655,5.1404142665973724,5.3733198837578415,5.5836316053718775,5.5943329571781009,5.2835506599705395,4.9941648077014174,4.566282316191284,4.2731702971940511]
[null,"COP fin charge",{"$f":"IF(C65<25,1.2*C$50,IF(C65<35,1.2*C$50-0.2*C$50*(C65-25)/10,IF(C65<=TMAX,C$50+(C$52-C$50)/(TMAX-35)*(C65-35),1)))","v":3.1090655968336502},{"$f":"IF(D65<25,1.2*D50,IF(D65<35,1.2*D50-0.2*D50*(D65-25)/10,IF(D65<=TMAX,D50+(D52-D50)/(TMAX-35)*(D65-35),1)))","v":3.1616893916722373},3.4483116520042483,3.5810362598211776,3.8343027227144817,4.0062871621625895,4.1614467357333549,4.1693381656022348,3.9400182228101097,3.7262247331212688,3.4096572728896426,3.1924908150155233]
[null,"COP moyen thermo",{"$f":"(C66+C67)/2","v":3.6348623635408428},{"$f":"(D66+D67)/2","v":3.6966568699462456},4.0334007689625704,4.1894346854619213,4.4873584946559273,4.6898035229602151,4.8725391705526162,4.8818355613901678,4.6117844413903244,4.3601947704113435,3.9879697945404633,3.732830556104787]
[null,"Appoint si TECS>TMAXTHERMO (kWh/m2)",{"$f":"IF(T_ECS>C61,(T_ECS-C61)/(T_ECS-C$12)*C48,0)","v":0},0,0,0,0,0,0,0,0,0,0,0,{"$f":"SUM(C69:N69)","v":0},{"$f":"(#REF!-#REF!)/#REF!","v":{"$error":"#REF!"}}]
[null,"Consommation PAC pour les besoins ECS",{"$f":"(C48-C69)/C68","v":0.54180976024046967},{"$f":"(D48-D69)/D68","v":0.48071660126074478},0.46891715920544508,0.4082844415150077,0.36166357688248008,0.3100915451191682,0.29420514253569624,0.29438993308060485,0.31704410350641654,0.37529493986673318,0.43163146094950533,0.50914337954073774]
[]
[null,"Besoin couvert par la PAC (kWh/m2)",{"$f":"C48-C57-C69","v":1.6629394031249998},{"$f":"D48-D57-D69","v":1.5284145078124995},1.8520892037259613,1.7104810008174225,1.6229141239312439,1.4542684207400516,1.4335260811831956,1.4371632442281685,1.4621390637854355,1.6363590341687697,1.7213332286399987,1.7093022718749993]
[null,"Nb heures fonct PAC en ECS / jour",{"$f":"(C72*SHON/C$10)/(C49+C51)*2","v":12},12,12,11.009352466355715,9.4112698589076924,8.3222765272834369,7.6279367557928115,7.6320509854160896,8.5151635631370528,9.7776856090123392,11.660785318948443,11.999999999999998]
[null,"Conso circulateurs PAC kWh/m2 par mois",{"$f":"C72/(C68*(1-CircECS))-C72/C68","v":2.7615525971591559E-3},2.4957258474482269E-3,2.771758508547606E-3,2.4644936107545701E-3,2.1830799409404689E-3,1.8717799504175403E-3,1.7758861722476649E-3,1.7770016081324336E-3,1.9137471036604903E-3,2.265361810060762E-3,2.6054212934577548E-3,2.7640472279358841E-3]
[null,"Conso circulateur ECS kWh/m2 par mois",{"$f":"IF(TypeEchangeur=\"Echangeur à plaques\",1.1*Pcircul_ECS__W*'Calcul (EF)'!C73*'Calcul (EF)'!C$10/1000/SHON,0)","v":0},{"$f":"IF(TypeEchangeur=\"Echangeur à plaques\",1.1*Pcircul_ECS__W*'Calcul (EF)'!D73*'Calcul (EF)'!D$10/1000/SHON,0)","v":0},{"$f":"IF(TypeEchangeur=\"Echangeur à plaques\",1.1*Pcircul_ECS__W*'Calcul (EF)'!E73*'Calcul (EF)'!E$10/1000/SHON,0)","v":0},{"$f":"IF(TypeEchangeur=\"Echangeur à plaques\",1.1*Pcircul_ECS__W*'Calcul (EF)'!F73*'Calcul (EF)'!F$10/1000/SHON,0)","v":0},{"$f":"IF(TypeEchangeur=\"Echangeur à plaques\",1.1*Pcircul_ECS__W*'Calcul (EF)'!G73*'Calcul (EF)'!G$10/1000/SHON,0)","v":0},{"$f":"IF(TypeEchangeur=\"Echangeur à plaques\",1.1*Pcircul_ECS__W*'Calcul (EF)'!H73*'Calcul (EF)'!H$10/1000/SHON,0)","v":0},{"$f":"IF(TypeEchangeur=\"Echangeur à plaques\",1.1*Pcircul_ECS__W*'Calcul (EF)'!I73*'Calcul (EF)'!I$10/1000/SHON,0)","v":0},{"$f":"IF(TypeEchangeur=\"Echangeur à plaques\",1.1*Pcircul_ECS__W*'Calcul (EF)'!J73*'Calcul (EF)'!J$10/1000/SHON,0)","v":0},{"$f":"IF(TypeEchangeur=\"Echangeur à plaques\",1.1*Pcircul_ECS__W*'Calcul (EF)'!K73*'Calcul (EF)'!K$10/1000/SHON,0)","v":0},{"$f":"IF(TypeEchangeur=\"Echangeur à plaques\",1.1*Pcircul_ECS__W*'Calcul (EF)'!L73*'Calcul (EF)'!L$10/1000/SHON,0)","v":0},{"$f":"IF(TypeEchangeur=\"Echangeur à plaques\",1.1*Pcircul_ECS__W*'Calcul (EF)'!M73*'Calcul (EF)'!M$10/1000/SHON,0)","v":0},{"$f":"IF(TypeEchangeur=\"Echangeur à plaques\",1.1*Pcircul_ECS__W*'Calcul (EF)'!N73*'Calcul (EF)'!N$10/1000/SHON,0)","v":0}]
[null,"Conso totale auxiliaires kWh/m2 par mois",{"$f":"SUM(C74:C75)","v":2.7615525971591559E-3},{"$f":"SUM(D74:D75)","v":2.4957258474482269E-3},2.771758508547606E-3,2.4644936107545701E-3,2.1830799409404689E-3,1.8717799504175403E-3,1.7758861722476649E-3,1.7770016081324336E-3,1.9137471036604903E-3,2.265361810060762E-3,2.6054212934577548E-3,2.7640472279358841E-3,{"$f":"SUM(C76:N76)","v":2.7649855670762558E-2}]
[null,"Conso auxiliaires hors cycle antilégionnelle",{"$f":"(C76/C72)","v":1.6606453560301954E-3},{"$f":"(1/D72)*D76","v":1.632885473601114E-3},1.4965577807869563E-3,1.440819050066509E-3,1.3451604793803351E-3,1.2870938567620307E-3,1.238823761603203E-3,1.2364646920028741E-3,1.30886804891585E-3,1.3843916663506001E-3,1.5136065754776961E-3,1.6170616943625158E-3,{"$f":"SUM(C77:N77)","v":1.7162378435339881E-2}]
[null,"COP corrigé sans anti Légionnelle",{"$f":"C48/(C57+C69+C70+C77)","v":2.3171232135182982},{"$f":"D48/(D57+D69+D70+D77)","v":2.4310460135477445},3.7109997052010972,4.1747023321393604,4.4707301970901696,4.6704180656800531,4.8521081650409013,4.8614171638813435,4.5928236719200957,4.3441699535485343,3.9740340077651126,2.7073144910116698]
[null,"Besoins ECS / Cop :",{"$f":"C$27/C78","v":0.84657712792604933},{"$f":"D$27/D78","v":0.72808859526240932},0.50755876841839986,0.40792168042765686,0.36126844210737691,0.30976648989206013,0.29384045906262374,0.29402596105142326,0.31671358569083463,0.37488833563990592,0.43125041584581664,0.69913029325778897,5.5710301545823455]
[null,"Pertes de stockage:",{"$f":"C$42/C78","v":3.3577802426218821E-3},2.8907102071791418E-3,2.0965753608570147E-3,1.8035801374173374E-3,1.740295254483536E-3,1.6121490838700838E-3,1.6035072346757301E-3,1.6004367211844913E-3,1.6393858644977348E-3,1.790995893177903E-3,1.8946516791663592E-3,2.873840690434486E-3,2.49039083695657E-2]
[null,"Consommation ECS :",{"$f":"SUM(C79:C80)","v":0.84993490816867123},0.73097930546958845,0.50965534377925692,0.40972526056507419,0.36300873736186046,0.31137863897593021,0.29544396629729947,0.29562639777260774,0.31835297155533238,0.37667933153308381,0.433145067524983,0.70200413394822347,5.5959340629519119]
[null,"Dont besoin fourni par l'appoint  :",{"$f":"C69+C57","v":0.30646450257217134},{"$f":"D69+D57","v":0.24862981873524273},3.924162679302487E-2,0,0,0,0,0,0,0,0,0.19124369271312328,0.78557964081356224]
[null,"Dont consommation électrique PAC + auxiliaires",{"$f":"C70+C76","v":0.54457131283762883},{"$f":"D70+D76","v":0.48321232710819301},0.47168891771399268,0.41074893512576227,0.36384665682342054,0.31196332506958574,0.29598102870794391,0.29616693468873728,0.31895785061007703,0.37756030167679394,0.43423688224296308,0.51190742676867362,4.8208418993737725]

{"sheet":"POST-TRAITEMENT & SORTIE","index":2,"n_rows":23,"n_cols":12,"rows_kept":23,"cut":false,"hidden":false,"merged":[]}
["POST-TRAITEMENT"]
[]
["Mois","Répartition conso [%]","Requis ECS [kWh/m².an]","Besoins ECS / COP [kWh/m².an]","Pertes de stockage ballon PAC à 40°C [kWh/m².an]","Pertes de stockage ballon cogé à 80°C [kWh/m².an]","Pertes de bouclage [kWh/m².an]","Conso EF ECS PAC  [kWhef/m².an]","Conso EF ECS cogé  [kWhef/m².an]","Production élec [kWhef/m².an]","Part cogé","Conso ECS totale [kWhep/m².an]"]
["Janvier",{"$f":"D4/$D$17","v":0.15196060772166406},{"$f":"'Calcul (EF)'!$C27","v":1.9616235151510988},{"$f":"'Calcul (EF)'!$C79","v":0.84657712792604933},{"$f":"'Calcul (EF)'!C$42","v":7.7803905460722663E-3},{"$f":"'Calcul (EF)'!$C43","v":5.4462733822505861E-2},{"$f":"'Calcul (EF)'!C$40","v":0.27462729212115389},{"$f":"D4+E4","v":0.8543575184721216},{"$f":"$I$17*B4+G4","v":4.330869372057359},{"$f":"(C4/ENTREE!$D$63+F4)*ENTREE!$B$65","v":0.83816056287988239},{"$f":"H4/(H4+J4)","v":0.50478486929347921},{"$f":"I4*K4","v":2.1861573299011066}]
["Février",{"$f":"D5/$D$17","v":0.13069191425279467},{"$f":"'Calcul (EF)'!$D27","v":1.7700168770222575},{"$f":"'Calcul (EF)'!$D79","v":0.72808859526240932},{"$f":"'Calcul (EF)'!D$42","v":7.027449525484627E-3},{"$f":"'Calcul (EF)'!$D43","v":4.919214667839239E-2},{"$f":"'Calcul (EF)'!D$40","v":0.2478023627831161},{"$f":"D5+E5","v":0.73511604478789394},{"$f":"$I$17*B5+G5","v":3.7363251454149231},{"$f":"(C5/ENTREE!$D$63+F5)*ENTREE!$B$65","v":0.75630681160841728},{"$f":"H5/(H5+J5)","v":0.49289578849833171},{"$f":"I5*K5","v":1.8416189286354323}]
["Mars",{"$f":"D6/$D$17","v":9.1106806880396615E-2},{"$f":"'Calcul (EF)'!$E$27","v":1.8835504399729139},{"$f":"'Calcul (EF)'!$E$79","v":0.50755876841839986},{"$f":"'Calcul (EF)'!E$42","v":7.7803905460722663E-3},{"$f":"'Calcul (EF)'!$E$43","v":5.4462733822505861E-2},{"$f":"'Calcul (EF)'!E$40","v":0.26369706159620798},{"$f":"D6+E6","v":0.51533915896447213},{"$f":"$I$17*B6+G6","v":2.6955856238857727},{"$f":"(C6/ENTREE!$D$63+F6)*ENTREE!$B$65","v":0.80549521769702126},{"$f":"H6/(H6+J6)","v":0.39016183108970104},{"$f":"I6*K6","v":1.0517146228743472}]
["Avril",7.322194802556016E-2,{"$f":"'Calcul (EF)'!$F$27","v":1.702951590611546},{"$f":"'Calcul (EF)'!$F$79","v":0.40792168042765686},{"$f":"'Calcul (EF)'!F$42","v":7.5294102058763865E-3},{"$f":"'Calcul (EF)'!$F$43","v":5.27058714411347E-2},{"$f":"'Calcul (EF)'!F$40","v":0.23841322268561646},0.41545109063353325,{"$f":"$I$17*B7+G7","v":2.1929062403773099},{"$f":"(C7/ENTREE!$D$63+F7)*ENTREE!$B$65","v":0.72937145661726832},{"$f":"H7/(H7+J7)","v":0.36289562223525851},0.79579607460530521]
["Mai",6.4847691016395301E-2,{"$f":"'Calcul (EF)'!$G$27","v":1.6151337333851716},{"$f":"'Calcul (EF)'!$G$79","v":0.36126844210737691},{"$f":"'Calcul (EF)'!G$42","v":7.7803905460722663E-3},{"$f":"'Calcul (EF)'!$G$43","v":5.4462733822505861E-2},{"$f":"'Calcul (EF)'!G$40","v":0.22611872267392405},0.36904883265344918,1.9570800358136582,{"$f":"(C8/ENTREE!$D$63+F8)*ENTREE!$B$65","v":0.69319114419249417},0.34742510232880486,0.67993873170822128]
["Juin",{"$f":"D9/$D$17","v":5.560308978713166E-2},{"$f":"'Calcul (EF)'!$H$27","v":1.4467390105341751},{"$f":"'Calcul (EF)'!$H$79","v":0.30976648989206013},{"$f":"'Calcul (EF)'!H$42","v":7.5294102058763865E-3},{"$f":"'Calcul (EF)'!$H$43","v":5.27058714411347E-2},{"$f":"'Calcul (EF)'!H$40","v":0.20254346147478453},0.31729590009793651,1.686741214764506,{"$f":"(C9/ENTREE!$D$63+F9)*ENTREE!$B$65","v":0.62217352251107738},0.33773946491709073,0.56967907532816786]
["Juillet",5.2744367003817204E-2,{"$f":"'Calcul (EF)'!$I$27","v":1.4257456906371233},{"$f":"'Calcul (EF)'!$I$79","v":0.29384045906262374},{"$f":"'Calcul (EF)'!I$42","v":7.7803905460722663E-3},{"$f":"'Calcul (EF)'!$I$43","v":5.4462733822505861E-2},{"$f":"'Calcul (EF)'!I$40","v":0.19960439668919727},0.30162084960869601,1.6074950607772784,{"$f":"(C10/ENTREE!$D$63+F10)*ENTREE!$B$65","v":0.61395222891021195},{"$f":"H10/(H10+J10)","v":0.32943394327039188},{"$f":"I10*K10","v":0.52956343665953709}]
["Août",5.2777664613712021E-2,{"$f":"'Calcul (EF)'!$J$27","v":1.4293828536820963},{"$f":"'Calcul (EF)'!$J$79","v":0.29402596105142326},{"$f":"'Calcul (EF)'!J$42","v":7.7803905460722663E-3},{"$f":"'Calcul (EF)'!$J$43","v":5.4462733822505861E-2},{"$f":"'Calcul (EF)'!J$40","v":0.20011359951549348},0.30180635159749553,1.608893067408993,{"$f":"(C11/ENTREE!$D$63+F11)*ENTREE!$B$65","v":0.61547399792058122},0.32902302088566421,0.52936285732090949]
["Septembre",5.6850093591815844E-2,{"$f":"'Calcul (EF)'!$K$27","v":1.454609653579559},{"$f":"'Calcul (EF)'!$K$79","v":0.31671358569083463},{"$f":"'Calcul (EF)'!K$42","v":7.5294102058763865E-3},{"$f":"'Calcul (EF)'!$K$43","v":5.27058714411347E-2},{"$f":"'Calcul (EF)'!K$40","v":0.20364535150113827},0.32424299589671102,1.7211290292303381,{"$f":"(C12/ENTREE!$D$63+F12)*ENTREE!$B$65","v":0.62546655626569481},0.34141279842709593,0.58761547832364069]
["Octobre",6.7292462118796581E-2,{"$f":"'Calcul (EF)'!$L$27","v":1.6285786436226974},{"$f":"'Calcul (EF)'!$L$79","v":0.37488833563990592},{"$f":"'Calcul (EF)'!L$42","v":7.7803905460722663E-3},{"$f":"'Calcul (EF)'!$L$43","v":5.4462733822505861E-2},{"$f":"'Calcul (EF)'!L$40","v":0.22800101010717766},0.38266872618597819,2.0242199157904714,{"$f":"(C13/ENTREE!$D$63+F13)*ENTREE!$B$65","v":0.69881642067685223},0.35383632155838918,0.71624252902853269]
["Novembre",7.7409456398490284E-2,{"$f":"'Calcul (EF)'!$M$27","v":1.7138038184341222},{"$f":"'Calcul (EF)'!$M$79","v":0.43125041584581664},{"$f":"'Calcul (EF)'!M$42","v":7.5294102058763865E-3},{"$f":"'Calcul (EF)'!$M$43","v":5.27058714411347E-2},{"$f":"'Calcul (EF)'!M$40","v":0.23993253458077712},0.43877982605169302,2.3062015442682093,{"$f":"(C14/ENTREE!$D$63+F14)*ENTREE!$B$65","v":0.73391196904128198},0.37416465936551135,0.86289911523933083]
["Décembre",0.12549389858942561,{"$f":"'Calcul (EF)'!$N$27","v":1.8927655740420504},{"$f":"'Calcul (EF)'!$N$79","v":0.69913029325778897},{"$f":"'Calcul (EF)'!N$42","v":7.7803905460722663E-3},{"$f":"'Calcul (EF)'!$N$43","v":5.4462733822505861E-2},{"$f":"'Calcul (EF)'!N$40","v":0.26498718036588709},0.70691068380386124,{"$f":"$I$17*B15+G15","v":3.6147607819958392},{"$f":"(C15/ENTREE!$D$63+F15)*ENTREE!$B$65","v":0.80935077910007447},0.46621951497071601,{"$f":"I15*K15","v":1.6852720185172663}]
[]
["TOTAL",{"$f":"SUM(B4:B15)","v":1},{"$f":"SUM(C4:C15)","v":19.924901400674813},5.5710301545823455,{"$f":"SUM(E4:E15)","v":9.1607824171496044E-2},0.64125476920047231,2.7894861960944741,{"$f":"SUM(H4:H15)","v":5.6626379787538417},{"$f":"ENTREE!D67*ENTREE!D66/(12*ENTREE!D63*SHON)+F17","v":26.692720835690185},{"$f":"SUM(J4:J15)","v":8.541670667420858},null,{"$f":"SUM(L4:L15)","v":12.035860198141798}]
[]
[]
["Résultat"]
["Conso ECS [kWhep/m².an]",{"$f":"L17","v":12.035860198141798}]
["Prod élec alimentant la PAC [kWhep/m²]",{"$f":"J17*2.58","v":22.037510321945813}]
["Gain / Mini-cogé seul",{"$f":"(SUM(I4:I15)-L17)/(SUM(I4:I15))","v":0.59175850759185078}]

{"sheet":"BASES","index":3,"n_rows":240,"n_cols":26,"rows_kept":240,"cut":false,"hidden":true,"merged":[]}
["Besoins d'eau chaude sanitaire selon le type d'usage"]
[null,"a","Unités","Somme ah journalier sur 7 jours","Durée annuel de fonctionnement de l'ECS dur_ecs","Dur vacances",null,null,null,null,"Coefficients Cnn utilisés"]
["Logements collectifs",{"$f":"IF(SHAB/Nbr_lgt>27,(470.9*LN(SHAB/Nbr_lgt)-1075)/(SHAB/Nbr_lgt),17.7)","v":12.806403614581576},"Nb logements",0.14299999999999999,1820,0,null,null,null,null,"PAC ou CE Thermo Air/Eau",null,null,null,null,null,"PAC ou CE Thermo Air/Eau",null,null,null,null,"Impact sur le COP de la consommation des circulateurs"]
["Hébergements",330,"Nb lits",0.14299999999999999,1820,0,null,null,null,null,"T air extérieur",null,null,"Teau",null,null,"T air extérieur","RT2012","AFPAC",null,null,null,"Sélectionné",null,"Standard","Haute efficacité"]
["Etablissement sanitaires avec hébergement - sans blanchisserie",665,"Nb lits",0.14299999999999999,1820,0,null,null,null,null,"Cnn(2/7)",{"$f":"IF(BaseCnn=\"AFPAC\",BASES!S5,BASES!R5)","v":0.85},null,"Cnn(45/35)",0.8,null,"Cnn(2/7)",0.85,0.8,null,null,"Circuit ECS",{"$f":"IF(EfficaciteCirculateurs=\"Standard\",Y5,Z5)","v":6.0000000000000001E-3},"Circuit ECS",2.4E-2,6.0000000000000001E-3]
["Etablissement sanitaires avec hébergement - avec blanchisserie",1050,"Nb lits",0.14299999999999999,1820,0,null,null,null,null,"Cnn(-7/7)",{"$f":"IF(BaseCnn=\"AFPAC\",BASES!S6,BASES!R6)","v":0.5},null,"Cnn(55/45)",0.8,null,"Cnn(-7/7)",0.5,0.6]
["Hotel 1* sans blanchisserie",665,"Nb chambres",0.14299999999999999,1040,0,null,null,null,null,"Cnn(-15/-7)",{"$f":"IF(BaseCnn=\"AFPAC\",BASES!S7,BASES!R7)","v":0.8},null,"Cnn(65/55)",0.8,null,"Cnn(-15/-7)",0.8,0.8]
["Hotel 1* avec blanchisserie",830,"Nb chambres",0.14299999999999999,1040,0,null,null,null,null,"Cnn(20/7)",{"$f":"IF(BaseCnn=\"AFPAC\",BASES!S8,BASES!R8)","v":1.25},null,"Cnn(25/35)",1.2,null,"Cnn(20/7)",1.25,1.2]
["Hotel 2* sans blanchisserie",910,"Nb chambres",0.14299999999999999,1040,0]
["Hotel 2* avec blanchisserie",1075,"Nb chambres",0.14299999999999999,1040,0]
["Hotel 3* sans blanchisserie",1160,"Nb chambres",0.14299999999999999,1040,0]
["Hotel 3* avec blanchisserie",1325,"Nb chambres",0.14299999999999999,1040,0]
["Hotel 4* sans blanchisserie",1405,"Nb chambres",0.14299999999999999,1040,0]
["Hotel 4* avec blanchisserie",1570,"Nb chambres",0.14299999999999999,1040,0]
[]
[]
[]
["Constantes de calcul"]
["Masse volumique de l'eau :",1]
["Capacité calorifique de l'eau :",{"$f":"1.163/1000","v":1.163E-3}]
["Température de l'eau mitigée :",40]
[]
["Pénalités"]
["Coefficient de pénalité PV essai",0.9]
["COP hors pertes par défaut CE Thermo",2]
["COP par défaut PAC 2 SERVICES",{"$f":"0.85*3.4","v":2.8899999999999997}]
["Temps de fonctionnement maxi / besoin",12]
["Données climatiques"]
["Température de l'arrivée d'eau froide",1,2,3,4,5,6,7,8,9,10,11,12]
["H1a",5.8309677419354804,5.8651428571428577,7.1909032258064522,9.3479333333333354,11.866387096774199,13.9596,15.165290322580651,15.101935483870971,13.817933333333333,11.632193548387098,9.1525999999999996,7.0303870967741959]
["H1b",5.8309677419354804,5.8651428571428577,7.1909032258064522,9.3479333333333354,11.866387096774199,13.9596,15.165290322580651,15.101935483870971,13.817933333333333,11.632193548387098,9.1525999999999996,7.0303870967741959]
["H1c",5.8309677419354804,5.8651428571428577,7.1909032258064522,9.3479333333333354,11.866387096774199,13.9596,15.165290322580651,15.101935483870971,13.817933333333333,11.632193548387098,9.1525999999999996,7.0303870967741959]
["H2a",7.3309677419354786,7.3651428571428568,8.6909032258064531,10.847933333333334,13.366387096774197,15.4596,16.665290322580649,16.601935483870971,15.317933333333336,13.132193548387098,10.6526,8.5303870967741915]
["H2b",7.3309677419354786,7.3651428571428568,8.6909032258064531,10.847933333333334,13.366387096774197,15.4596,16.665290322580649,16.601935483870971,15.317933333333336,13.132193548387098,10.6526,8.5303870967741915]
["H2c",7.3309677419354786,7.3651428571428568,8.6909032258064531,10.847933333333334,13.366387096774197,15.4596,16.665290322580649,16.601935483870971,15.317933333333336,13.132193548387098,10.6526,8.5303870967741915]
["H2d",7.3309677419354786,7.3651428571428568,8.6909032258064531,10.847933333333334,13.366387096774197,15.4596,16.665290322580649,16.601935483870971,15.317933333333336,13.132193548387098,10.6526,8.5303870967741915]
["H3",9.8309677419354777,9.8651428571428585,11.190903225806453,13.347933333333335,15.866387096774197,17.959600000000002,19.165290322580642,19.101935483870971,17.817933333333333,15.632193548387098,13.152600000000001,11.030387096774193]
[]
["Température extérieure",1,2,3,4,5,6,7,8,9,10,11,12]
["H1a",3.9094892473118246,4.44114583333333,7.5451209677419326,9.6573611111110917,13.708239247311861,16.474444444444451,18.980887096774254,19.108642473118319,15.407083333333357,11.976303763440834,6.9559722222222291,4.7526612903225711]
["H1b",2.1203494623655845,2.9238541666666737,6.4374462365591167,9.0949999999999775,13.630107526881718,16.639305555555516,19.172258064516189,19.068857526881782,14.937430555555569,10.959354838709659,5.3954861111111008,3.2515188172042908]
["H1c",2.76055107526882,4.2265327380952398,7.8877553763441099,10.352847222222206,14.918413978494616,18.079791666666722,20.869973118279635,20.59293010752679,16.446874999999999,12.31690860215058,6.4056249999999997,3.8293010752688148]
["H2a",5.8560215053763391,6.2210416666666521,8.6402016129032067,10.28479166666669,14.134959677419385,16.750208333333379,19.117029569892438,19.194314516129001,16.437708333333362,13.092459677419368,8.6204861111110915,6.6307795698924723]
["H2b",6.5749462365591267,7.2810714285714129,9.7012500000000195,11.481041666666659,15.423776881720409,18.098333333333265,20.511680107526871,20.624193548387137,17.932500000000054,14.750497311827914,9.8844444444444211,7.4227553763441012]
["H2c",5.4916935483871123,7.0926190476190607,9.6960618279569619,11.678263888888912,15.85790322580648,18.739861111111157,21.282997311827934,21.437473118279641,18.185277777777834,14.59286290322577,9.2634722222222212,6.3738037634408382]
["H2d",6.1261693548387184,7.2665624999999823,9.78958333333334,13.862777777777792,17.0644086021505,20.650833333333335,24.036639784946324,22.609341397849459,18.248263888888946,14.472607526881694,8.0631250000000207,6.1198521505376471]
["H3",9.2556586021504987,9.8048363095238162,11.669462365591411,13.308333333333328,17.238198924731144,20.478819444444468,23.562473118279602,24.019973118279658,20.790277777777764,17.383494623655885,12.79020833333332,10.098588709677417]
[]
["Températures de retour d'eau glycolée pour des capteurs horizontaux, donnée par la norme EN 15316-4-2 : θ retour capteur = MAX(0 ; MIN(0.15 θ ext ; 4.5))"]
["Temp. Retour Eau glycolée",1,2,3,4,5,6,7,8,9,10,11,12]
["H1a",{"$f":"MAX(0,MIN(0.15*B40,4.5))","v":0.58642338709677366},{"$f":"MAX(0,MIN(0.15*C40,4.5))","v":0.66617187499999952},1.1317681451612898,1.4486041666666638,2.0562358870967792,2.4711666666666674,2.8471330645161381,2.8662963709677478,2.3110625000000034,1.796445564516125,1.0433958333333344,0.7128991935483856]
["H1b",{"$f":"MAX(0,MIN(0.15*B41,4.5))","v":0.31805241935483769},0.43857812500000104,0.96561693548386751,1.3642499999999966,2.0445161290322575,2.4958958333333272,2.8758387096774283,2.8603286290322671,2.2406145833333353,1.6439032258064488,0.80932291666666512,0.48772782258064362]
["H1c",{"$f":"MAX(0,MIN(0.15*B42,4.5))","v":0.41408266129032301},0.63397991071428594,1.1831633064516165,1.5529270833333308,2.2377620967741922,2.711968750000008,3.1304959677419451,3.0889395161290185,2.4670312499999998,1.8475362903225869,0.96084374999999989,0.5743951612903222]
["H2a",{"$f":"MAX(0,MIN(0.15*B43,4.5))","v":0.8784032258064508},0.9331562499999978,1.296030241935481,1.5427187500000035,2.1202439516129075,2.512531250000007,2.8675544354838656,2.87914717741935,2.4656562500000043,1.9638689516129051,1.2930729166666637,0.99461693548387076]
["H2b",{"$f":"MAX(0,MIN(0.15*B44,4.5))","v":0.98624193548386896},1.0921607142857119,1.455187500000003,1.7221562499999987,2.3135665322580614,2.7147499999999898,3.0767520161290305,3.0936290322580704,2.6898750000000082,2.212574596774187,1.482666666666663,1.1134133064516152]
["H2c",{"$f":"MAX(0,MIN(0.15*B45,4.5))","v":0.82375403225806687},1.063892857142859,1.4544092741935442,1.7517395833333367,2.3786854838709717,2.8109791666666735,3.1924495967741899,3.2156209677419461,2.7277916666666751,2.1889294354838653,1.3895208333333331,0.95607056451612571]
["H2d",{"$f":"MAX(0,MIN(0.15*B46,4.5))","v":0.91892540322580774},1.0899843749999973,1.468437500000001,2.0794166666666687,2.5596612903225751,3.0976250000000003,3.6054959677419482,3.3914012096774186,2.7372395833333418,2.1708911290322539,1.209468750000003,0.91797782258064697]
["H3",{"$f":"MAX(0,MIN(0.15*B47,4.5))","v":1.3883487903225749},1.4707254464285724,1.7504193548387115,1.9962499999999992,2.5857298387096717,3.0718229166666702,3.5343709677419404,3.6029959677419487,3.1185416666666645,2.6075241935483828,1.9185312499999978,1.5147883064516126]
[]
["Nombre d’heures par mois concernant des températures inférieures à 7°C, "]
["H1a",657,550,360,143,31,6,0,0,0,64,367,545]
["H1b",705,596,438,258,50,10,0,0,11,116,484,515]
["H1c",676,570,325,175,7,0,0,0,0,57,435,568]
["H2a",458,335,288,110,25,15,0,0,2,48,223,368]
["H2b",408,282,105,44,0,0,0,0,0,16,142,313]
["H2c",459,331,177,82,10,0,0,0,0,37,228,405]
["H2d",440,319,219,61,6,0,0,0,0,49,282,434]
["H3",136,77,14,3,0,0,0,0,0,0,26,88]
[]
["Nombre d’heures par mois concernant des températures inférieures à   6° C"]
["H1a",599,483,285,97,13,3,0,0,0,30,294,456]
["H1b",685,559,337,197,33,5,0,0,5,76,408,495]
["H1c",642,457,239,132,0,0,0,0,0,27,330,524]
["H2a",366,281,229,67,10,8,0,0,0,21,149,287]
["H2b",332,219,54,22,0,0,0,0,0,7,107,241]
["H2c",367,268,119,50,3,0,0,0,0,15,180,324]
["H2d",374,259,170,31,1,0,0,0,0,30,229,359]
["H3",72,39,5,0,0,0,0,0,0,0,15,46]
[]
["Nombre d’heures par mois concernant des températures inférieures à   5° C"]
["H1a",514,396,201,45,5,0,0,0,0,7,227,363]
["H1b",643,512,245,129,14,0,0,0,0,52,316,462]
["H1c",591,376,136,72,0,0,0,0,0,13,229,468]
["H2a",281,242,166,32,3,4,0,0,0,9,87,245]
["H2b",273,139,33,11,0,0,0,0,0,1,92,188]
["H2c",294,191,66,29,0,0,0,0,0,5,141,263]
["H2d",299,192,112,17,0,0,0,0,0,18,181,281]
["H3",21,16,0,0,0,0,0,0,0,0,5,28]
[]
["Nombre d’heures par mois concernant des températures inférieures à   4° C"]
["H1a",396,312,140,16,2,0,0,0,0,2,151,274]
["H1b",571,439,162,83,7,0,0,0,0,34,229,418]
["H1c",510,294,77,25,0,0,0,0,0,9,162,375]
["H2a",169,190,106,8,2,0,0,0,0,7,58,202]
["H2b",205,83,15,4,0,0,0,0,0,0,74,124]
["H2c",249,137,33,15,0,0,0,0,0,1,92,203]
["H2d",219,124,63,8,0,0,0,0,0,12,123,226]
["H3",0,8,0,0,0,0,0,0,0,0,0,11]
[]
["Nombre d’heures par mois concernant des températures inférieures à   3° C"]
["H1a",285,212,88,3,0,0,0,0,0,0,86,219]
["H1b",471,367,93,56,2,0,0,0,0,10,173,380]
["H1c",419,246,37,10,0,0,0,0,0,7,113,298]
["H2a",113,140,66,2,0,0,0,0,0,6,35,150]
["H2b",132,41,6,0,0,0,0,0,0,0,45,98]
["H2c",208,97,25,10,0,0,0,0,0,0,60,159]
["H2d",148,88,40,5,0,0,0,0,0,6,83,176]
["H3",0,2,0,0,0,0,0,0,0,0,0,0]
[]
["Nombre d’heures par mois concernant des températures inférieures à   2° C"]
["H1a",141,133,55,0,0,0,0,0,0,0,56,157]
["H1b",368,271,61,30,0,0,0,0,0,4,134,324]
["H1c",309,181,20,0,0,0,0,0,0,3,54,230]
["H2a",76,114,40,0,0,0,0,0,0,2,20,87]
["H2b",50,22,1,0,0,0,0,0,0,0,26,62]
["H2c",168,50,20,6,0,0,0,0,0,0,31,108]
["H2d",105,57,27,0,0,0,0,0,0,2,66,129]
["H3",0,0,0,0,0,0,0,0,0,0,0,0]
[]
["Nombre d’heures par mois concernant des températures inférieures à   1° C"]
["H1a",63,67,19,0,0,0,0,0,0,0,30,103]
["H1b",254,187,41,6,0,0,0,0,0,0,96,283]
["H1c",188,109,6,0,0,0,0,0,0,2,22,165]
["H2a",57,97,21,0,0,0,0,0,0,1,15,55]
["H2b",15,9,0,0,0,0,0,0,0,0,16,41]
["H2c",109,18,10,1,0,0,0,0,0,0,21,88]
["H2d",80,30,8,0,0,0,0,0,0,0,47,91]
["H3",0,0,0,0,0,0,0,0,0,0,0,0]
[]
["Nombre d’heures par mois concernant des températures inférieures à   0° C"]
["H1a",41,29,7,0,0,0,0,0,0,0,19,70]
["H1b",158,118,24,0,0,0,0,0,0,0,66,230]
["H1c",97,60,0,0,0,0,0,0,0,0,14,117]
["H2a",33,69,7,0,0,0,0,0,0,0,12,44]
["H2b",1,2,0,0,0,0,0,0,0,0,12,25]
["H2c",59,0,6,0,0,0,0,0,0,0,10,53]
["H2d",49,18,2,0,0,0,0,0,0,0,33,70]
["H3",0,0,0,0,0,0,0,0,0,0,0,0]
[]
["Nombre d’heures par mois concernant des températures inférieures à     -1° C"]
["H1a",32,14,2,0,0,0,0,0,0,0,11,56]
["H1b",102,89,4,0,0,0,0,0,0,0,42,182]
["H1c",50,33,0,0,0,0,0,0,0,0,7,80]
["H2a",17,32,4,0,0,0,0,0,0,0,10,37]
["H2b",0,0,0,0,0,0,0,0,0,0,7,11]
["H2c",19,0,0,0,0,0,0,0,0,0,7,19]
["H2d",28,14,0,0,0,0,0,0,0,0,26,47]
["H3",0,0,0,0,0,0,0,0,0,0,0,0]
[]
["Nombre d’heures par mois concernant des températures inférieures à   -2° C"]
["H1a",15,0,0,0,0,0,0,0,0,0,5,46]
["H1b",47,58,0,0,0,0,0,0,0,0,20,142]
["H1c",25,18,0,0,0,0,0,0,0,0,6,42]
["H2a",9,17,0,0,0,0,0,0,0,0,5,20]
["H2b",0,0,0,0,0,0,0,0,0,0,4,7]
["H2c",9,0,0,0,0,0,0,0,0,0,5,15]
["H2d",11,9,0,0,0,0,0,0,0,0,20,41]
["H3",0,0,0,0,0,0,0,0,0,0,0,0]
[]
["Nombre d’heures par mois concernant des températures inférieures à   -3° C"]
["H1a",3,0,0,0,0,0,0,0,0,0,2,31]
["H1b",22,22,0,0,0,0,0,0,0,0,15,109]
["H1c",14,7,0,0,0,0,0,0,0,0,3,25]
["H2a",4,8,0,0,0,0,0,0,0,0,3,4]
["H2b",0,0,0,0,0,0,0,0,0,0,0,4]
["H2c",2,0,0,0,0,0,0,0,0,0,2,11]
["H2d",2,4,0,0,0,0,0,0,0,0,14,24]
["H3",0,0,0,0,0,0,0,0,0,0,0,0]
[]
["Nombre d’heures par mois concernant des températures inférieures à   -4° C"]
["H1a",0,0,0,0,0,0,0,0,0,0,0,11]
["H1b",7,0,0,0,0,0,0,0,0,0,8,74]
["H1c",11,4,0,0,0,0,0,0,0,0,0,10]
["H2a",0,0,0,0,0,0,0,0,0,0,0,2]
["H2b",0,0,0,0,0,0,0,0,0,0,0,0]
["H2c",0,0,0,0,0,0,0,0,0,0,0,7]
["H2d",0,0,0,0,0,0,0,0,0,0,8,20]
["H3",0,0,0,0,0,0,0,0,0,0,0,0]
[]
["Nombre d’heures par mois concernant des températures inférieures à   -5° C"]
["H1a",0,0,0,0,0,0,0,0,0,0,0,6]
["H1b",0,0,0,0,0,0,0,0,0,0,3,46]
["H1c",9,0,0,0,0,0,0,0,0,0,0,0]
["H2a",0,0,0,0,0,0,0,0,0,0,0,0]
["H2b",0,0,0,0,0,0,0,0,0,0,0,0]
["H2c",0,0,0,0,0,0,0,0,0,0,0,3]
["H2d",0,0,0,0,0,0,0,0,0,0,4,11]
["H3",0,0,0,0,0,0,0,0,0,0,0,0]
[]
["Nombre d’heures par mois concernant des températures inférieures à   -6° C"]
["H1a",0,0,0,0,0,0,0,0,0,0,0,0]
["H1b",0,0,0,0,0,0,0,0,0,0,0,35]
["H1c",6,0,0,0,0,0,0,0,0,0,0,0]
["H2a",0,0,0,0,0,0,0,0,0,0,0,0]
["H2b",0,0,0,0,0,0,0,0,0,0,0,0]
["H2c",0,0,0,0,0,0,0,0,0,0,0,2]
["H2d",0,0,0,0,0,0,0,0,0,0,2,9]
["H3",0,0,0,0,0,0,0,0,0,0,0,0]
[]
["Nombre d’heures par mois concernant des températures inférieures à   -7° C"]
["H1a",0,0,0,0,0,0,0,0,0,0,0,0]
["H1b",0,0,0,0,0,0,0,0,0,0,0,27]
["H1c",0,0,0,0,0,0,0,0,0,0,0,0]
["H2a",0,0,0,0,0,0,0,0,0,0,0,0]
["H2b",0,0,0,0,0,0,0,0,0,0,0,0]
["H2c",0,0,0,0,0,0,0,0,0,0,0,0]
["H2d",0,0,0,0,0,0,0,0,0,0,0,6]
["H3",0,0,0,0,0,0,0,0,0,0,0,0]
[]
[]
["Zone sélectionnée :",{"$f":"ZoneSelect","v":"H1a"}]
[]
["Nb d'heures par mois inférieures à la température minimum pour la zone climatique concernée :"]
[7,{"$f":"VLOOKUP(ZoneSelect,TableHeures7,2,0)","v":657},{"$f":"VLOOKUP(ZoneSelect,TableHeures7,3,0)","v":550},{"$f":"VLOOKUP(ZoneSelect,TableHeures7,4,0)","v":360},{"$f":"VLOOKUP(ZoneSelect,TableHeures7,5,0)","v":143},{"$f":"VLOOKUP(ZoneSelect,TableHeures7,6,0)","v":31},{"$f":"VLOOKUP(ZoneSelect,TableHeures7,7,0)","v":6},{"$f":"VLOOKUP(ZoneSelect,TableHeures7,8,0)","v":0},{"$f":"VLOOKUP(ZoneSelect,TableHeures7,9,0)","v":0},{"$f":"VLOOKUP(ZoneSelect,TableHeures7,10,0)","v":0},{"$f":"VLOOKUP(ZoneSelect,TableHeures7,11,0)","v":64},{"$f":"VLOOKUP(ZoneSelect,TableHeures7,12,0)","v":367},{"$f":"VLOOKUP(ZoneSelect,TableHeures7,13,0)","v":545}]
[6,{"$f":"VLOOKUP(ZoneSelect,TableHeures6,2,0)","v":599},{"$f":"VLOOKUP(ZoneSelect,TableHeures6,3,0)","v":483},{"$f":"VLOOKUP(ZoneSelect,TableHeures6,4,0)","v":285},{"$f":"VLOOKUP(ZoneSelect,TableHeures6,5,0)","v":97},{"$f":"VLOOKUP(ZoneSelect,TableHeures6,6,0)","v":13},{"$f":"VLOOKUP(ZoneSelect,TableHeures6,7,0)","v":3},{"$f":"VLOOKUP(ZoneSelect,TableHeures6,8,0)","v":0},{"$f":"VLOOKUP(ZoneSelect,TableHeures6,9,0)","v":0},{"$f":"VLOOKUP(ZoneSelect,TableHeures6,10,0)","v":0},{"$f":"VLOOKUP(ZoneSelect,TableHeures6,11,0)","v":30},{"$f":"VLOOKUP(ZoneSelect,TableHeures6,12,0)","v":294},{"$f":"VLOOKUP(ZoneSelect,TableHeures6,13,0)","v":456}]
[5,{"$f":"VLOOKUP(ZoneSelect,TableHeures5,2,0)","v":514},{"$f":"VLOOKUP(ZoneSelect,TableHeures5,3,0)","v":396},{"$f":"VLOOKUP(ZoneSelect,TableHeures5,4,0)","v":201},{"$f":"VLOOKUP(ZoneSelect,TableHeures5,5,0)","v":45},{"$f":"VLOOKUP(ZoneSelect,TableHeures5,6,0)","v":5},{"$f":"VLOOKUP(ZoneSelect,TableHeures5,7,0)","v":0},{"$f":"VLOOKUP(ZoneSelect,TableHeures5,8,0)","v":0},{"$f":"VLOOKUP(ZoneSelect,TableHeures5,9,0)","v":0},{"$f":"VLOOKUP(ZoneSelect,TableHeures5,10,0)","v":0},{"$f":"VLOOKUP(ZoneSelect,TableHeures5,11,0)","v":7},{"$f":"VLOOKUP(ZoneSelect,TableHeures5,12,0)","v":227},{"$f":"VLOOKUP(ZoneSelect,TableHeures5,13,0)","v":363}]
[4,{"$f":"VLOOKUP(ZoneSelect,TableHeures4,2,0)","v":396},{"$f":"VLOOKUP(ZoneSelect,TableHeures4,3,0)","v":312},{"$f":"VLOOKUP(ZoneSelect,TableHeures4,4,0)","v":140},{"$f":"VLOOKUP(ZoneSelect,TableHeures4,5,0)","v":16},{"$f":"VLOOKUP(ZoneSelect,TableHeures4,6,0)","v":2},{"$f":"VLOOKUP(ZoneSelect,TableHeures4,7,0)","v":0},{"$f":"VLOOKUP(ZoneSelect,TableHeures4,8,0)","v":0},{"$f":"VLOOKUP(ZoneSelect,TableHeures4,9,0)","v":0},{"$f":"VLOOKUP(ZoneSelect,TableHeures4,10,0)","v":0},{"$f":"VLOOKUP(ZoneSelect,TableHeures4,11,0)","v":2},{"$f":"VLOOKUP(ZoneSelect,TableHeures4,12,0)","v":151},{"$f":"VLOOKUP(ZoneSelect,TableHeures4,13,0)","v":274}]
[3,{"$f":"VLOOKUP(ZoneSelect,TableHeures3,2,0)","v":285},{"$f":"VLOOKUP(ZoneSelect,TableHeures3,3,0)","v":212},{"$f":"VLOOKUP(ZoneSelect,TableHeures3,4,0)","v":88},{"$f":"VLOOKUP(ZoneSelect,TableHeures3,5,0)","v":3},{"$f":"VLOOKUP(ZoneSelect,TableHeures3,6,0)","v":0},{"$f":"VLOOKUP(ZoneSelect,TableHeures3,7,0)","v":0},{"$f":"VLOOKUP(ZoneSelect,TableHeures3,8,0)","v":0},{"$f":"VLOOKUP(ZoneSelect,TableHeures3,9,0)","v":0},{"$f":"VLOOKUP(ZoneSelect,TableHeures3,10,0)","v":0},{"$f":"VLOOKUP(ZoneSelect,TableHeures3,11,0)","v":0},{"$f":"VLOOKUP(ZoneSelect,TableHeures3,12,0)","v":86},{"$f":"VLOOKUP(ZoneSelect,TableHeures3,13,0)","v":219}]
[2,{"$f":"VLOOKUP(ZoneSelect,TableHeures2,2,0)","v":141},{"$f":"VLOOKUP(ZoneSelect,TableHeures2,3,0)","v":133},{"$f":"VLOOKUP(ZoneSelect,TableHeures2,4,0)","v":55},{"$f":"VLOOKUP(ZoneSelect,TableHeures2,5,0)","v":0},{"$f":"VLOOKUP(ZoneSelect,TableHeures2,6,0)","v":0},{"$f":"VLOOKUP(ZoneSelect,TableHeures2,7,0)","v":0},{"$f":"VLOOKUP(ZoneSelect,TableHeures2,8,0)","v":0},{"$f":"VLOOKUP(ZoneSelect,TableHeures2,9,0)","v":0},{"$f":"VLOOKUP(ZoneSelect,TableHeures2,10,0)","v":0},{"$f":"VLOOKUP(ZoneSelect,TableHeures2,11,0)","v":0},{"$f":"VLOOKUP(ZoneSelect,TableHeures2,12,0)","v":56},{"$f":"VLOOKUP(ZoneSelect,TableHeures2,13,0)","v":157}]
[1,{"$f":"VLOOKUP(ZoneSelect,TableHeures1,2,0)","v":63},{"$f":"VLOOKUP(ZoneSelect,TableHeures1,3,0)","v":67},{"$f":"VLOOKUP(ZoneSelect,TableHeures1,4,0)","v":19},{"$f":"VLOOKUP(ZoneSelect,TableHeures1,5,0)","v":0},{"$f":"VLOOKUP(ZoneSelect,TableHeures1,6,0)","v":0},{"$f":"VLOOKUP(ZoneSelect,TableHeures1,7,0)","v":0},{"$f":"VLOOKUP(ZoneSelect,TableHeures1,8,0)","v":0},{"$f":"VLOOKUP(ZoneSelect,TableHeures1,9,0)","v":0},{"$f":"VLOOKUP(ZoneSelect,TableHeures1,10,0)","v":0},{"$f":"VLOOKUP(ZoneSelect,TableHeures1,11,0)","v":0},{"$f":"VLOOKUP(ZoneSelect,TableHeures1,12,0)","v":30},{"$f":"VLOOKUP(ZoneSelect,TableHeures1,13,0)","v":103}]
[0,{"$f":"VLOOKUP(ZoneSelect,TableHeures0,2,0)","v":41},{"$f":"VLOOKUP(ZoneSelect,TableHeures0,3,0)","v":29},{"$f":"VLOOKUP(ZoneSelect,TableHeures0,4,0)","v":7},{"$f":"VLOOKUP(ZoneSelect,TableHeures0,5,0)","v":0},{"$f":"VLOOKUP(ZoneSelect,TableHeures0,6,0)","v":0},{"$f":"VLOOKUP(ZoneSelect,TableHeures0,7,0)","v":0},{"$f":"VLOOKUP(ZoneSelect,TableHeures0,8,0)","v":0},{"$f":"VLOOKUP(ZoneSelect,TableHeures0,9,0)","v":0},{"$f":"VLOOKUP(ZoneSelect,TableHeures0,10,0)","v":0},{"$f":"VLOOKUP(ZoneSelect,TableHeures0,11,0)","v":0},{"$f":"VLOOKUP(ZoneSelect,TableHeures0,12,0)","v":19},{"$f":"VLOOKUP(ZoneSelect,TableHeures0,13,0)","v":70}]
[-1,{"$f":"VLOOKUP(ZoneSelect,TableHeures_1,2,0)","v":32},{"$f":"VLOOKUP(ZoneSelect,TableHeures_1,3,0)","v":14},{"$f":"VLOOKUP(ZoneSelect,TableHeures_1,4,0)","v":2},{"$f":"VLOOKUP(ZoneSelect,TableHeures_1,5,0)","v":0},{"$f":"VLOOKUP(ZoneSelect,TableHeures_1,6,0)","v":0},{"$f":"VLOOKUP(ZoneSelect,TableHeures_1,7,0)","v":0},{"$f":"VLOOKUP(ZoneSelect,TableHeures_1,8,0)","v":0},{"$f":"VLOOKUP(ZoneSelect,TableHeures_1,9,0)","v":0},{"$f":"VLOOKUP(ZoneSelect,TableHeures_1,10,0)","v":0},{"$f":"VLOOKUP(ZoneSelect,TableHeures_1,11,0)","v":0},{"$f":"VLOOKUP(ZoneSelect,TableHeures_1,12,0)","v":11},{"$f":"VLOOKUP(ZoneSelect,TableHeures_1,13,0)","v":56}]
[-2,{"$f":"VLOOKUP(ZoneSelect,TableHeures_2,2,0)","v":15},{"$f":"VLOOKUP(ZoneSelect,TableHeures_2,3,0)","v":0},{"$f":"VLOOKUP(ZoneSelect,TableHeures_2,4,0)","v":0},{"$f":"VLOOKUP(ZoneSelect,TableHeures_2,5,0)","v":0},{"$f":"VLOOKUP(ZoneSelect,TableHeures_2,6,0)","v":0},{"$f":"VLOOKUP(ZoneSelect,TableHeures_2,7,0)","v":0},{"$f":"VLOOKUP(ZoneSelect,TableHeures_2,8,0)","v":0},{"$f":"VLOOKUP(ZoneSelect,TableHeures_2,9,0)","v":0},{"$f":"VLOOKUP(ZoneSelect,TableHeures_2,10,0)","v":0},{"$f":"VLOOKUP(ZoneSelect,TableHeures_2,11,0)","v":0},{"$f":"VLOOKUP(ZoneSelect,TableHeures_2,12,0)","v":5},{"$f":"VLOOKUP(ZoneSelect,TableHeures_2,13,0)","v":46}]
[-3,{"$f":"VLOOKUP(ZoneSelect,TableHeures_3,2,0)","v":3},{"$f":"VLOOKUP(ZoneSelect,TableHeures_3,3,0)","v":0},{"$f":"VLOOKUP(ZoneSelect,TableHeures_3,4,0)","v":0},{"$f":"VLOOKUP(ZoneSelect,TableHeures_3,5,0)","v":0},{"$f":"VLOOKUP(ZoneSelect,TableHeures_3,6,0)","v":0},{"$f":"VLOOKUP(ZoneSelect,TableHeures_3,7,0)","v":0},{"$f":"VLOOKUP(ZoneSelect,TableHeures_3,8,0)","v":0},{"$f":"VLOOKUP(ZoneSelect,TableHeures_3,9,0)","v":0},{"$f":"VLOOKUP(ZoneSelect,TableHeures_3,10,0)","v":0},{"$f":"VLOOKUP(ZoneSelect,TableHeures_3,11,0)","v":0},{"$f":"VLOOKUP(ZoneSelect,TableHeures_3,12,0)","v":2},{"$f":"VLOOKUP(ZoneSelect,TableHeures_3,13,0)","v":31}]
[-4,{"$f":"VLOOKUP(ZoneSelect,TableHeures_4,2,0)","v":0},{"$f":"VLOOKUP(ZoneSelect,TableHeures_4,3,0)","v":0},{"$f":"VLOOKUP(ZoneSelect,TableHeures_4,4,0)","v":0},{"$f":"VLOOKUP(ZoneSelect,TableHeures_4,5,0)","v":0},{"$f":"VLOOKUP(ZoneSelect,TableHeures_4,6,0)","v":0},{"$f":"VLOOKUP(ZoneSelect,TableHeures_4,7,0)","v":0},{"$f":"VLOOKUP(ZoneSelect,TableHeures_4,8,0)","v":0},{"$f":"VLOOKUP(ZoneSelect,TableHeures_4,9,0)","v":0},{"$f":"VLOOKUP(ZoneSelect,TableHeures_4,10,0)","v":0},{"$f":"VLOOKUP(ZoneSelect,TableHeures_4,11,0)","v":0},{"$f":"VLOOKUP(ZoneSelect,TableHeures_4,12,0)","v":0},{"$f":"VLOOKUP(ZoneSelect,TableHeures_4,13,0)","v":11}]
[-5,{"$f":"VLOOKUP(ZoneSelect,TableHeures_5,2,0)","v":0},{"$f":"VLOOKUP(ZoneSelect,TableHeures_5,3,0)","v":0},{"$f":"VLOOKUP(ZoneSelect,TableHeures_5,4,0)","v":0},{"$f":"VLOOKUP(ZoneSelect,TableHeures_5,5,0)","v":0},{"$f":"VLOOKUP(ZoneSelect,TableHeures_5,6,0)","v":0},{"$f":"VLOOKUP(ZoneSelect,TableHeures_5,7,0)","v":0},{"$f":"VLOOKUP(ZoneSelect,TableHeures_5,8,0)","v":0},{"$f":"VLOOKUP(ZoneSelect,TableHeures_5,9,0)","v":0},{"$f":"VLOOKUP(ZoneSelect,TableHeures_5,10,0)","v":0},{"$f":"VLOOKUP(ZoneSelect,TableHeures_5,11,0)","v":0},{"$f":"VLOOKUP(ZoneSelect,TableHeures_5,12,0)","v":0},{"$f":"VLOOKUP(ZoneSelect,TableHeures_5,13,0)","v":6}]
[-6,{"$f":"VLOOKUP(ZoneSelect,TableHeures_6,2,0)","v":0},{"$f":"VLOOKUP(ZoneSelect,TableHeures_6,3,0)","v":0},{"$f":"VLOOKUP(ZoneSelect,TableHeures_6,4,0)","v":0},{"$f":"VLOOKUP(ZoneSelect,TableHeures_6,5,0)","v":0},{"$f":"VLOOKUP(ZoneSelect,TableHeures_6,6,0)","v":0},{"$f":"VLOOKUP(ZoneSelect,TableHeures_6,7,0)","v":0},{"$f":"VLOOKUP(ZoneSelect,TableHeures_6,8,0)","v":0},{"$f":"VLOOKUP(ZoneSelect,TableHeures_6,9,0)","v":0},{"$f":"VLOOKUP(ZoneSelect,TableHeures_6,10,0)","v":0},{"$f":"VLOOKUP(ZoneSelect,TableHeures_6,11,0)","v":0},{"$f":"VLOOKUP(ZoneSelect,TableHeures_6,12,0)","v":0},{"$f":"VLOOKUP(ZoneSelect,TableHeures_6,13,0)","v":0}]
[-7,{"$f":"VLOOKUP(ZoneSelect,TableHeures_7,2,0)","v":0},{"$f":"VLOOKUP(ZoneSelect,TableHeures_7,3,0)","v":0},{"$f":"VLOOKUP(ZoneSelect,TableHeures_7,4,0)","v":0},{"$f":"VLOOKUP(ZoneSelect,TableHeures_7,5,0)","v":0},{"$f":"VLOOKUP(ZoneSelect,TableHeures_7,6,0)","v":0},{"$f":"VLOOKUP(ZoneSelect,TableHeures_7,7,0)","v":0},{"$f":"VLOOKUP(ZoneSelect,TableHeures_7,8,0)","v":0},{"$f":"VLOOKUP(ZoneSelect,TableHeures_7,9,0)","v":0},{"$f":"VLOOKUP(ZoneSelect,TableHeures_7,10,0)","v":0},{"$f":"VLOOKUP(ZoneSelect,TableHeures_7,11,0)","v":0},{"$f":"VLOOKUP(ZoneSelect,TableHeures_7,12,0)","v":0},{"$f":"VLOOKUP(ZoneSelect,TableHeures_7,13,0)","v":0}]
[]
[]
["Températures"]
["Tint",20]
["T ballon cogé",80]
["T ballon PAC",40]
[]
["RECUPERATION DE CHALEUR"]
["Si récup de chaleur sur les fumées de chaudières"]
["Rendement de condenseur",0.9]
["PCS du gaz",{"$f":"11.5","v":11.5}]
["PCI du gaz",{"$f":"10.2","v":10.199999999999999}]

{"sheet":"echangeurs","index":4,"n_rows":30,"n_cols":3,"rows_kept":30,"cut":false,"hidden":true,"merged":[]}
["Pincement Ballon à serpentin"]
[]
["m2/kW","ΔT","equiv echangeur à plaques"]
[0.22,9.5,{"$f":"A4/2","v":0.11}]
[0.23,8.5,{"$f":"A5/2","v":0.115}]
[0.24,7.5,0.12]
[0.25,6.5,0.125]
[0.26,5.5,0.13]
[0.27,4.5,0.13500000000000001]
[0.28000000000000003,3.5,0.14000000000000001]
[0.28999999999999998,2.5,0.14499999999999999]
[0.3,1.5,0.15]
[0.31,0.5,0.155]
[]
[]
["Volume d'échange par m2"]
[60,"l/m2"]
[]
[]
["m2/kW","ΔT"]
[0.11,9.5]
[0.115,8.5]
[0.12,7.5]
[0.125,6.5]
[0.13,5.5]
[0.13500000000000001,4.5]
[0.14000000000000001,3.5]
[0.14499999999999999,2.5]
[0.15,1.5]
[0.155,0.5]

{"sheet":"LISTES","index":5,"n_rows":13,"n_cols":1,"rows_kept":13,"cut":false,"hidden":true,"merged":[]}
["Récupération de chaleur"]
["Aucune"]
["VMC"]
["Fumées de chaudières"]
[]
["Liste_Echangeurs"]
["Ballon à serpentin"]
["Echangeur à plaques"]
["Ballon en bain-marie"]
[]
["Liste"]
["Oui"]
["Non"]

{"sheet":"ConditionsTests","index":6,"n_rows":4,"n_cols":15,"rows_kept":4,"cut":false,"hidden":true,"merged":[]}
["Conditions de tests communes à la EN 255-3 et la pr EN 16147",null,null,null,null,"Conditions de tests communes à la EN 255-3 et la pr EN 16147",null,null,"Calcul des coeff à appliquer au COP nominal HP pour obtenir le COP du maintien en température du ballon avec 5K d'hystérisis"]
[null,null,null,null,null,null,null,null,"COP théo Carnot consigne 50°C",null,null,null,"COP théo Carnot consigne 55°C"]
["Technologie","T source froide","T ambiance ballon",null,null,"Technologie","T source froide",null,"PrEN16147","Hystérisis 5K","Coeff COP",null,"PrEN16147","Hystérisis 5K","Coeff COP"]
["AIR EXTERIEUR/EAU",7,10,null,null,"AIR EXTERIEUR/EAU",7,null,{"$f":"((50+10)/2+273)/((50+10)/2-$B4)","v":13.173913043478262},{"$f":"((50+45)/2+273)/((50+45)/2-$B4)","v":7.9135802469135799},{"$f":"J4/I4","v":0.60070081082182281},null,{"$f":"((55+10)/2+273)/((55+10)/2-$B4)","v":11.980392156862745},{"$f":"((55+50)/2+273)/((55+50)/2-$B4)","v":7.1538461538461542},{"$f":"N4/M4","v":0.59712954802971174}]