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

{"sheet":"Remplissage","index":0,"n_rows":365,"n_cols":5,"rows_kept":365,"cut":false,"hidden":false,"merged":[]}
["Température extérieure","Température de recirculation","Débit total","% volumique air neuf","Puissance batterie froide"]
[36,42,75000,1]
[36,42,75000,0.75]
[36,42,75000,0.5]
[36,42,75000,0.25]
[36,41,75000,1]
[36,41,75000,0.75]
[36,41,75000,0.5]
[36,41,75000,0.25]
[36,40,75000,1]
[36,40,75000,0.75]
[36,40,75000,0.5]
[36,40,75000,0.25]
[36,39,75000,1]
[36,39,75000,0.75]
[36,39,75000,0.5]
[36,39,75000,0.25]
[36,38,75000,1]
[36,38,75000,0.75]
[36,38,75000,0.5]
[36,38,75000,0.25]
[36,37,75000,1]
[36,37,75000,0.75]
[36,37,75000,0.5]
[36,37,75000,0.25]
[36,36,75000,1]
[36,36,75000,0.75]
[36,36,75000,0.5]
[36,36,75000,0.25]
[36,35,75000,1]
[36,35,75000,0.75]
[36,35,75000,0.5]
[36,35,75000,0.25]
[36,34,75000,1]
[36,34,75000,0.75]
[36,34,75000,0.5]
[36,34,75000,0.25]
[36,33,75000,1]
[36,33,75000,0.75]
[36,33,75000,0.5]
[36,33,75000,0.25]
[36,32,75000,1]
[36,32,75000,0.75]
[36,32,75000,0.5]
[36,32,75000,0.25]
[36,31,75000,1]
[36,31,75000,0.75]
[36,31,75000,0.5]
[36,31,75000,0.25]
[36,30,75000,1]
[36,30,75000,0.75]
[36,30,75000,0.5]
[36,30,75000,0.25]
[35,42,75000,1]
[35,42,75000,0.75]
[35,42,75000,0.5]
[35,42,75000,0.25]
[35,41,75000,1]
[35,41,75000,0.75]
[35,41,75000,0.5]
[35,41,75000,0.25]
[35,40,75000,1]
[35,40,75000,0.75]
[35,40,75000,0.5]
[35,40,75000,0.25]
[35,39,75000,1]
[35,39,75000,0.75]
[35,39,75000,0.5]
[35,39,75000,0.25]
[35,38,75000,1]
[35,38,75000,0.75]
[35,38,75000,0.5]
[35,38,75000,0.25]
[35,37,75000,1]
[35,37,75000,0.75]
[35,37,75000,0.5]
[35,37,75000,0.25]
[35,36,75000,1]
[35,36,75000,0.75]
[35,36,75000,0.5]
[35,36,75000,0.25]
[35,35,75000,1]
[35,35,75000,0.75]
[35,35,75000,0.5]
[35,35,75000,0.25]
[35,34,75000,1]
[35,34,75000,0.75]
[35,34,75000,0.5]
[35,34,75000,0.25]
[35,33,75000,1]
[35,33,75000,0.75]
[35,33,75000,0.5]
[35,33,75000,0.25]
[35,32,75000,1]
[35,32,75000,0.75]
[35,32,75000,0.5]
[35,32,75000,0.25]
[35,31,75000,1]
[35,31,75000,0.75]
[35,31,75000,0.5]
[35,31,75000,0.25]
[35,30,75000,1]
[35,30,75000,0.75]
[35,30,75000,0.5]
[35,30,75000,0.25]
[34,42,75000,1]
[34,42,75000,0.75]
[34,42,75000,0.5]
[34,42,75000,0.25]
[34,41,75000,1]
[34,41,75000,0.75]
[34,41,75000,0.5]
[34,41,75000,0.25]
[34,40,75000,1]
[34,40,75000,0.75]
[34,40,75000,0.5]
[34,40,75000,0.25]
[34,39,75000,1]
[34,39,75000,0.75]
[34,39,75000,0.5]
[34,39,75000,0.25]
[34,38,75000,1]
[34,38,75000,0.75]
[34,38,75000,0.5]
[34,38,75000,0.25]
[34,37,75000,1]
[34,37,75000,0.75]
[34,37,75000,0.5]
[34,37,75000,0.25]
[34,36,75000,1]
[34,36,75000,0.75]
[34,36,75000,0.5]
[34,36,75000,0.25]
[34,35,75000,1]
[34,35,75000,0.75]
[34,35,75000,0.5]
[34,35,75000,0.25]
[34,34,75000,1]
[34,34,75000,0.75]
[34,34,75000,0.5]
[34,34,75000,0.25]
[34,33,75000,1]
[34,33,75000,0.75]
[34,33,75000,0.5]
[34,33,75000,0.25]
[34,32,75000,1]
[34,32,75000,0.75]
[34,32,75000,0.5]
[34,32,75000,0.25]
[34,31,75000,1]
[34,31,75000,0.75]
[34,31,75000,0.5]
[34,31,75000,0.25]
[34,30,75000,1]
[34,30,75000,0.75]
[34,30,75000,0.5]
[34,30,75000,0.25]
[33,42,75000,1]
[33,42,75000,0.75]
[33,42,75000,0.5]
[33,42,75000,0.25]
[33,41,75000,1]
[33,41,75000,0.75]
[33,41,75000,0.5]
[33,41,75000,0.25]
[33,40,75000,1]
[33,40,75000,0.75]
[33,40,75000,0.5]
[33,40,75000,0.25]
[33,39,75000,1]
[33,39,75000,0.75]
[33,39,75000,0.5]
[33,39,75000,0.25]
[33,38,75000,1]
[33,38,75000,0.75]
[33,38,75000,0.5]
[33,38,75000,0.25]
[33,37,75000,1]
[33,37,75000,0.75]
[33,37,75000,0.5]
[33,37,75000,0.25]
[33,36,75000,1]
[33,36,75000,0.75]
[33,36,75000,0.5]
[33,36,75000,0.25]
[33,35,75000,1]
[33,35,75000,0.75]
[33,35,75000,0.5]
[33,35,75000,0.25]
[33,34,75000,1]
[33,34,75000,0.75]
[33,34,75000,0.5]
[33,34,75000,0.25]
[33,33,75000,1]
[33,33,75000,0.75]
[33,33,75000,0.5]
[33,33,75000,0.25]
[33,32,75000,1]
[33,32,75000,0.75]
[33,32,75000,0.5]
[33,32,75000,0.25]
[33,31,75000,1]
[33,31,75000,0.75]
[33,31,75000,0.5]
[33,31,75000,0.25]
[33,30,75000,1]
[33,30,75000,0.75]
[33,30,75000,0.5]
[33,30,75000,0.25]
[32,42,75000,1]
[32,42,75000,0.75]
[32,42,75000,0.5]
[32,42,75000,0.25]
[32,41,75000,1]
[32,41,75000,0.75]
[32,41,75000,0.5]
[32,41,75000,0.25]
[32,40,75000,1]
[32,40,75000,0.75]
[32,40,75000,0.5]
[32,40,75000,0.25]
[32,39,75000,1]
[32,39,75000,0.75]
[32,39,75000,0.5]
[32,39,75000,0.25]
[32,38,75000,1]
[32,38,75000,0.75]
[32,38,75000,0.5]
[32,38,75000,0.25]
[32,37,75000,1]
[32,37,75000,0.75]
[32,37,75000,0.5]
[32,37,75000,0.25]
[32,36,75000,1]
[32,36,75000,0.75]
[32,36,75000,0.5]
[32,36,75000,0.25]
[32,35,75000,1]
[32,35,75000,0.75]
[32,35,75000,0.5]
[32,35,75000,0.25]
[32,34,75000,1]
[32,34,75000,0.75]
[32,34,75000,0.5]
[32,34,75000,0.25]
[32,33,75000,1]
[32,33,75000,0.75]
[32,33,75000,0.5]
[32,33,75000,0.25]
[32,32,75000,1]
[32,32,75000,0.75]
[32,32,75000,0.5]
[32,32,75000,0.25]
[32,31,75000,1]
[32,31,75000,0.75]
[32,31,75000,0.5]
[32,31,75000,0.25]
[32,30,75000,1]
[32,30,75000,0.75]
[32,30,75000,0.5]
[32,30,75000,0.25]
[31,42,75000,1]
[31,42,75000,0.75]
[31,42,75000,0.5]
[31,42,75000,0.25]
[31,41,75000,1]
[31,41,75000,0.75]
[31,41,75000,0.5]
[31,41,75000,0.25]
[31,40,75000,1]
[31,40,75000,0.75]
[31,40,75000,0.5]
[31,40,75000,0.25]
[31,39,75000,1]
[31,39,75000,0.75]
[31,39,75000,0.5]
[31,39,75000,0.25]
[31,38,75000,1]
[31,38,75000,0.75]
[31,38,75000,0.5]
[31,38,75000,0.25]
[31,37,75000,1]
[31,37,75000,0.75]
[31,37,75000,0.5]
[31,37,75000,0.25]
[31,36,75000,1]
[31,36,75000,0.75]
[31,36,75000,0.5]
[31,36,75000,0.25]
[31,35,75000,1]
[31,35,75000,0.75]
[31,35,75000,0.5]
[31,35,75000,0.25]
[31,34,75000,1]
[31,34,75000,0.75]
[31,34,75000,0.5]
[31,34,75000,0.25]
[31,33,75000,1]
[31,33,75000,0.75]
[31,33,75000,0.5]
[31,33,75000,0.25]
[31,32,75000,1]
[31,32,75000,0.75]
[31,32,75000,0.5]
[31,32,75000,0.25]
[31,31,75000,1]
[31,31,75000,0.75]
[31,31,75000,0.5]
[31,31,75000,0.25]
[31,30,75000,1]
[31,30,75000,0.75]
[31,30,75000,0.5]
[31,30,75000,0.25]
[30,42,75000,1]
[30,42,75000,0.75]
[30,42,75000,0.5]
[30,42,75000,0.25]
[30,41,75000,1]
[30,41,75000,0.75]
[30,41,75000,0.5]
[30,41,75000,0.25]
[30,40,75000,1]
[30,40,75000,0.75]
[30,40,75000,0.5]
[30,40,75000,0.25]
[30,39,75000,1]
[30,39,75000,0.75]
[30,39,75000,0.5]
[30,39,75000,0.25]
[30,38,75000,1]
[30,38,75000,0.75]
[30,38,75000,0.5]
[30,38,75000,0.25]
[30,37,75000,1]
[30,37,75000,0.75]
[30,37,75000,0.5]
[30,37,75000,0.25]
[30,36,75000,1]
[30,36,75000,0.75]
[30,36,75000,0.5]
[30,36,75000,0.25]
[30,35,75000,1]
[30,35,75000,0.75]
[30,35,75000,0.5]
[30,35,75000,0.25]
[30,34,75000,1]
[30,34,75000,0.75]
[30,34,75000,0.5]
[30,34,75000,0.25]
[30,33,75000,1]
[30,33,75000,0.75]
[30,33,75000,0.5]
[30,33,75000,0.25]
[30,32,75000,1]
[30,32,75000,0.75]
[30,32,75000,0.5]
[30,32,75000,0.25]
[30,31,75000,1]
[30,31,75000,0.75]
[30,31,75000,0.5]
[30,31,75000,0.25]
[30,30,75000,1]
[30,30,75000,0.75]
[30,30,75000,0.5]
[30,30,75000,0.25]

{"sheet":"Calcul","index":1,"n_rows":42,"n_cols":10,"rows_kept":42,"cut":false,"hidden":false,"merged":[[1,8,1,9],[1,4,2,4],[29,0,35,0],[1,5,2,5],[1,6,2,6],[1,2,2,2],[1,3,2,3],[1,1,2,1]]}
[]
[null,null,"Débit massique","Humidité abs","Température","Masse volumique","Débit volumique",null,"Coef ASHRAE"]
[null,null,null,null,null,null,null,null,"T<0°C","T>=0°C"]
[null,"Air neuf",{"$f":"G4*F4","v":21624.309179773023},15,36,{"$f":"E22/(287*(273.15+E4))","v":1.1419983195465144},18935.5,null,-10214.165000000001,-10440.397000000001]
[null,"Air recirculé",{"$f":"G5*F5","v":65752.929957888569},{"$f":"E31","v":8.3845351965693986},31.862500000000004,{"$f":"E22/(287*(273.15+E5))","v":1.1574895471097246},56806.5,"Vérif. Débit total volumique (m3/h)",-4.8932428000000003,-11.294650000000001]
[null,"TOTAL",{"$f":"C4+C5","v":87377.239137661585},{"$f":"(D4*C4+D5*C5)/C6","v":10.021744814189713},{"$f":"(E4*C4+E5*C5)/C6","v":32.886457498706861},{"$f":"E22/(287*(273.15+E6))","v":1.1536167402189221},{"$f":"G5+G4","v":75742},{"$f":"C6/F6","v":75741.999999999985},-5.3765794000000004E-3,-2.7022355000000001E-2]
[null,null,null,null,null,null,null,null,1.9202377000000001E-7,1.289036E-5]
[null,null,null,null,null,null,null,null,3.5575831999999998E-10,-2.4780681000000001E-9]
[null,null,null,null,null,null,null,null,-9.0344687999999998E-14,6.5459673]
[null,null,null,null,null,null,null,null,4.1635019]
[]
[null,"Température entrée air BF",null,null,{"$f":"E6","v":32.886457498706861},"[°C]"]
[null,"Température sortie air BF",null,null,11.940000000000001,"[°C]",null,null,"Humidité",0.4]
[null,"Température entrée eau BF",null,null,5,"[°C]"]
[null,"Température sortie eau BF",null,null,10,"[°C]"]
[]
[null,"Température moyenne eau BF",null,null,{"$f":"(E14+E15)/2","v":7.5},"[°C]"]
[null,"Ratio débit recirculé/débit total",null,null,{"$f":"C5/C6","v":0.75251782508595599},"[-]"]
[null,"Rendement d'ailette",null,null,0.85,"[-]"]
[null,"Apport humidificateur",null,null,6.6,"[g/s]"]
[null,"Humidité apportée par EU",null,null,{"$f":"G20*3600/C6","v":0},"[g/kg]"]
[null,"Pression atmosphérique",null,null,101325,"[Pa]"]
[]
[null,"Température de contact",null,null,{"$f":"E17+(1-E19)*(E12-E17)","v":11.30796862480603},"[°C]"]
[null,"Température de contact",null,null,{"$f":"1.8*E24+32+459.67","v":512.02434352465093},"[°R]"]
[null,"Pression de vapeur à sat à Temp contact",null,null,{"$f":"6894.76*EXP($J$4/E25+$J$5+$J$6*E25+$J$7*E25^2+$J$8*E25^3+$J$9*LOG(E25,EXP(1)))","v":1339.8547301538511},"[Pa]"]
[null,"Humidité à sat à Temp contact",null,null,{"$f":"1000*0.622*E26/(E22-E26)","v":8.3351345833072639},"[g/kg]"]
[null,"Phi_x",null,null,{"$f":"(E12-E13)/(E12-E24)","v":0.97071011881844915},"[-]"]
[]
["RESULTATS","Humidité en sortie de BF",null,null,{"$f":"(E18*(E21-D4)+D4-E28*(E18*(E21-D4)+D4-E27))/(1-E18+E18*E28)","v":8.3845351965693986},"[g/kg]"]
[null,"Humidité de l'air recirculé",null,null,{"$f":"E30+E21","v":8.3845351965693986},"[g/kg]"]
[]
[null,"Enthalpie en sortie de BF",null,null,{"$f":"1.006*E13+0.001*E30*(2500+1.826*E13)","v":33.15578131697459},"[kJ/kg]"]
[null,"Enthalpie en entrée de BF",null,null,{"$f":"1.006*E12+0.001*D6*(2500+1.826*E12)","v":58.739950783791173},"[kJ/kg]"]
[]
[null,"Puissance totale BF (sensible+latente)",null,null,{"$f":"-C6/3600*(E34-E33)","v":-620.96502601124791},"[kW]"]
[]
[null,"Débit de condensation BF",null,null,{"$f":"C6*(D6-E30)/3600/1000","v":3.9737460077024916E-2},"[kg/s]"]
[null,"Chaleur latente de condensation de l'eau",null,null,{"$f":"2500.8-2.36*E13+0.0016*E13*E13-0.00006*E13*E13*E13","v":2472.7475691969603},"[kJ/kg]","Corrélation [-25°C ; +40°C] prise à la température d'air en sortie de BF pour maximiser la part de la puissance latennte et minimiser la puissance sensible"]
[null,"Puissance latente BF",null,null,{"$f":"-E39*E38","v":-98.260707811524611},"[kW]"]
[]
[null,"Puissance sensible BF",null,null,{"$f":"E36-E40","v":-522.70431819972328},"[kW]"]