excel焓湿图升级版

移动参考线大气压力B=1013hPa机器露点相对湿度φ=93%93自由移动相对湿度线φm=30%30自由移动等温线tm=34.00℃650自由移动等湿线dm=25.00g/kg1000自由移动等焓线im=18.2kJ/kg1264热湿比ε=42001750应用：求两种空气状态混合的最终状态及其它参数，已知条件如下：●室外干球温度t1=20.00℃3000室外相对湿度φ1=67.0%670▲室内干球温度t2=40.00℃5000室内相对湿度φ2=45.0%450状态点1比例=45%45解：参量饱和蒸汽分压力Pb1=23.31hPaPb2=73.58hPa状态点蒸汽分压力Ps1=15.62hPaPs2=33.11hPa含湿量d1=9.74g/kgd2=21.02g/kg焓值i1=44.9kJ/kgi2=94.5kJ/kg◆混合点温度t3=31.00℃混合点相对湿度φ3=56.5%混合点含湿量d3=15.94g/kg混合点焓值i3=72.1kJ/kg混合点饱和蒸汽压力Pb3=44.82hPa混合点水蒸汽分压力Ps3=25.32hPa■混合点露点温度td=22.52℃◆混合点湿球温度tw=24.88℃混合点湿球温度含湿量dw=18.44g/kg室外状态点参数室内状态点参数混合点参数t2imt3t115.94g/kg,31.00℃tmtOε=4200,16.57-10℃-5℃0℃5℃10℃15℃20℃25℃30℃35℃40℃0.00g/kg5.00g/kg干球温度℃参考“洁净空调系统热湿处理能耗分析”and湿平衡方程φ1=67.0%φ2=45.0%φ3=56.5%φm=30.0%i2d2i1d3机器露点φ=93%9.74g/kg,20.00℃21.02g/kg,40.00℃i3d1◆混合点湿球温度tw=24.88℃,18.44g/kg,24.88℃15.94g/kg,31.00℃■混合点露点温度td=22.52℃,15.94g/kgdm16.57g/kg,23.1℃dOiOε=4200,16.57g/kg,33.0℃10.00g/kg15.00g/kg20.00g/kg25.00g/kg30.00g/kg35.00g/kg40.00g/kg45.00g/kg50.00g/kg含湿量g/kg焓湿图应用CopyrightbyTongFangTechnovator参考“洁净空调系统热湿处理能耗分析”and湿平衡方程等焓线取值变量X轴Y轴ε热湿比线相关取值11.0816.75h2=94.5kJ/kg1.8140.00d2=21.02g/kg25.1729.99t2=40.0℃21.0840.00h3=123.9kJ/kg18.4824.88d3=28.02g/kg12.3740.00t3=50.7℃5.125.28h4=60.9kJ/kg0.0017.97d4=13.02g/kg19.5525.80t4=27.4℃13.8040.00ho=75.8kJ/kgdo=16.57g/kg等湿线取值变量X轴Y轴to=33.0℃9.74g/kg14.8℃9.74g/kg40.0℃21.02g/kg27.0℃21.02g/kg40.0℃15.94g/kg22.5℃15.94g/kg40.0℃25.00g/kg29.8℃25.00g/kg40.0℃16.57g/kg23.1℃16.57g/kg40.0℃等温线取值变量X轴Y轴13.60g/kg20.0℃0.00g/kg20.0℃45.06g/kg40.0℃0.00g/kg40.0℃26.69g/kg31.0℃0.00g/kg31.0℃31.86g/kg34.0℃0.00g/kg34.0℃30.04g/kg33.0℃0.00g/kg33.0℃tmtO室内点N参考点1参考点2送风点Od3dmdOt1t2t3一次回风自由移动送风点i1i2i3imiOd1d2室内一次回风自由移动送风点室外室内调整送风温差室外室内一次回风自由移动送风点室外机器露点φ=93%50.00g/kgh_3=ℇ/〖10〖)+h〗_2t_3=((h_32.5×d_3))/((1.01+0.00184×送风温差7.0℃调整送风温差h_3=ℇ/〖10〗^3×(d_(3-)d_2)+h〗_2=((h_3-×d_3))/((1.01+0.00184×d_3))湿空气的密度、水蒸汽压力、含湿量和焓大气压力B=1013hPa大气压力B=φ1=67.0%φ2=空气温度饱和空气密度饱和空气的水蒸汽分压空气的水蒸汽分压力空气含湿量饱和空气焓空气的水蒸汽分压力tρbPbPsdhPs℃kg/m2hPahPag/kg干空气kJ/kg干空气hPa-20℃1.3951.02hPa0.68hPa0.42g/kg-19.170.46-19℃1.3931.13hPa0.76hPa0.47g/kg-18.030.51-18℃1.3841.25hPa0.84hPa0.51g/kg-16.920.56-17℃1.3871.37hPa0.92hPa0.56g/kg-15.790.62-16℃1.3731.50hPa1.01hPa0.62g/kg-14.630.68-15℃1.3671.65hPa1.11hPa0.68g/kg-13.470.74-14℃1.3621.81hPa1.21hPa0.75g/kg-12.280.81-13℃1.3571.98hPa1.33hPa0.82g/kg-11.100.89-12℃1.3522.17hPa1.45hPa0.89g/kg-9.910.98-11℃1.3472.37hPa1.59hPa0.98g/kg-8.681.07-10℃1.3412.59hPa1.74hPa1.07g/kg-7.441.17-9℃1.3362.83hPa1.90hPa1.17g/kg-6.181.27-8℃1.3313.09hPa2.07hPa1.27g/kg-4.921.39-7℃1.3253.36hPa2.25hPa1.39g/kg-3.611.51-6℃1.3203.67hPa2.46hPa1.51g/kg-2.301.65-5℃1.3154.00hPa2.68hPa1.65g/kg-0.941.80-4℃1.3104.36hPa2.92hPa1.80g/kg0.451.96-3℃1.3064.75hPa3.18hPa1.96g/kg1.862.14-2℃1.3015.16hPa3.46hPa2.13g/kg3.302.32-1℃1.2955.61hPa3.76hPa2.32g/kg4.792.520℃1.2906.09hPa4.08hPa2.52g/kg6.302.741℃1.2856.65hPa4.46hPa2.75g/kg7.892.992℃1.2817.04hPa4.72hPa2.91g/kg9.313.173℃1.2757.57hPa5.07hPa3.13g/kg10.873.414℃1.2718.11hPa5.43hPa3.35g/kg12.443.655℃1.2668.70hPa5.83hPa3.60g/kg14.083.926℃1.2619.32hPa6.24hPa3.86g/kg15.754.197℃1.2569.99hPa6.69hPa4.14g/kg17.474.508℃1.25110.70hPa7.17hPa4.43g/kg19.224.829℃1.24711.46hPa7.68hPa4.75g/kg21.045.1610℃1.24212.25hPa8.21hPa5.08g/kg22.895.5111℃1.23713.09hPa8.77hPa5.43g/kg24.795.8912℃1.23213.99hPa9.37hPa5.81g/kg26.776.3013℃1.22814.94hPa10.01hPa6.21g/kg28.806.7214℃1.22315.95hPa10.69hPa6.63g/kg30.897.1815℃1.21817.01hPa11.40hPa7.08g/kg33.057.6516℃1.21418.13hPa12.15hPa7.55g/kg35.268.1617℃1.20819.32hPa12.94hPa8.05g/kg37.558.6918℃1.20420.59hPa13.80hPa8.59g/kg39.949.2719℃1.20021.92hPa14.69hPa9.15g/kg42.389.8620℃1.19523.31hPa15.62hPa9.74g/kg44.9110.4921℃1.19024.80hPa16.62hPa10.37g/kg47.5411.1622℃1.18526.37hPa17.67hPa11.04g/kg50.2711.8723℃1.18128.02hPa18.77hPa11.74g/kg53.0812.6124℃1.17629.77hPa19.95hPa12.49g/kg56.0213.4025℃1.17131.60hPa21.17hPa13.28g/kg59.0614.2226℃1.16633.53hPa22.47hPa14.11g/kg62.2115.0927℃1.16135.56hPa23.83hPa14.98g/kg65.4616.0028℃1.15637.71hPa25.27hPa15.91g/kg68.8716.9729℃1.15139.95hPa26.77hPa16.88g/kg72.3917.9830℃1.14642.32hPa28.35hPa17.91g/kg76.0619.0431℃1.14144.82hPa30.03hPa19.00g/kg79.8920.1732℃1.13647.43hPa31.78hPa20.14g/kg83.8621.3433℃1.13150.18hPa33.62hPa21.35g/kg88.0022.5834℃1.12653.07hPa35.56hPa22.63g/kg92.3323.8835℃1.12156.10hPa37.59hPa23.97g/kg96.8225.2536℃1.11659.26hPa39.70hPa25.37g/kg101.4726.6737℃1.11162.60hPa41.94hPa26.87g/kg106.3728.1738℃1.10766.09hPa44.28hPa28.43g/kg111.4429.7439℃1.10269.75hPa46.73hPa30.08g/kg116.7531.3940℃1.09773.58hPa49.30hPa31.82g/kg122.2933.1141℃1.09177.59hPa51.99hPa33.65g/kg128.0734.9242℃1.08681.80hPa54.81hPa35.58g/kg134.1236.8143℃1.08186.18hPa57.74hPa37.60g/kg140.4038.7844℃1.07690.79hPa60.83hPa39.74g/kg147.0140.8645℃1.07095.60hPa64.05hPa41.98g/kg153.8843.0246℃1.065100.61hPa67.41hPa44.34g/kg161.0645.2747℃1.059105.87hPa70.93hPa46.83g/kg168.5947.6448℃1.054111.33hPa74.59hPa49.44g/kg176.4550.1049℃1.048117.07hPa78.44hPa52.20g/kg184.7052.6850℃1.043123.04hPa82.44hPa55.10g/kg193.3255.3755℃1.013156.94hPa105.15hPa72.04g/kg242.9470.6260℃0.981198.70hPa133.13hPa94.11g/kg306.2689.4265℃0.946249.38hPa167.08hPa122.86g/kg387