水和水蒸气焓值计算XLS

,,,水和水蒸气焓值计算,,,,,,,,,,,,,,,,,,

,,,,,,,,,,,,,,,,,,,,,,

,,,,,,,,,,,,,,,,,,,,,,

,,过热蒸汽,压力,Mpa,3.92,,,,,,,,,,,,,,,,

,,,温度,℃,450,723.16,,,,,,,,,,,,,,,

,,,焓h,kJ/kg,3332.12,,,,,,,,,,,,,,,,

,,水,压力,Mpa,3,,,,,,,,,,,,,,,,

,,,温度,℃,120,393.16,,,,,,,,,,,,,,,

,,,焓h,kJ/kg,505.80,,,,,,,,,,,,,,,,

,,饱和蒸汽,压力,Mpa,3,,,,,,,,,,,,,,,,

,,,温度,℃,233.858445,507.008445,,,,,,,,,,,,,,,

,,,焓h,kJ/kg,2803.26,,,,,,,,,,,,,,,,

,,饱和水,压力,Mpa,3,,,,,,,,,,,,,,,,

,,,温度,℃,233.858445,507.008445,,,,,,,,,,,,,,,

,,,焓h,kJ/kg,1300.37,,,,,,,,,,,,,,,,

,,,,,,,,,,,,,,,,,,,,,,

,,绿色区域输入数据，红色区域显示结果,,,,,,,,,,,,,,,,,,,

,,本计算方法基于工业上广泛使用的IAPWS-IF97公式,,,,,,,,,,,,,,,,,,,

,,适用范围为：,T（0-1073.15K),,P(0-22.064MPa）,,,,,,,,,,,,,,,,

,,超出此范围的计算结果无效,,,,,,,,,,,,,,,,,,,

,,,,,,,,,,,,,,,,,,,,,,

,,,,,,,,,,,,,,,,,,,,,,

,,,,,,,,,,,,,,,,,,,,,,

,,,,,,,,,,,,,,,,,,,,,,

,,,,,,,,,,,,,,,,,,,,,,

,,,,,,,,,,,,,,,,,,,,,,

,,,,,,,,,,,,,,,,,,,,,,

,过热蒸汽,,,,水,,,,表3.10,,,,表3.11,,,,,表3.1,,,

,无量纲化,π,3.92,,无量纲化,π,0.181488203,,i,Jio,nio,,i,Ii,Ji,ni,,i,Ii,Ji,ni

,,τ,0.746722717,,,τ,3.525282328,,1,0,-9.69276865,,1,1,0,-0.001773174,,1,0,-2,0.146329712

,,0,0,,,-0.023950853,,,2,1,10.08665597,,2,1,1,-0.017834862,,2,0,-1,-0.845481872

,,10.08665597,-0.06991266,,,0.159371239,,,3,-5,-0.005608791,,3,1,2,-0.045996014,,3,0,0,-3.756360367

,,0.161764451,-0.08897037,,,0,,,4,-4,0.071452738,,4,1,3,-0.057581259,,4,0,1,3.385516917

,,-1.231068016,-0.041219883,,,3.385516917,,,5,-3,-0.407104982,,5,1,6,-0.050325279,,5,0,2,-0.957919634

,,3.928169481,-0.001082104,,,-4.412718728,,,6,-2,1.424081917,,6,2,1,-3.30326E-05,,6,0,3,0.157720385

,,-6.840484707,-0.000507593,,,2.510171732,,,7,-1,-4.383951132,,7,2,2,-0.00018949,,7,0,4,-0.016616417

,,7.862252313,-0.001436803,,,-0.812154968,,,8,2,-0.284086325,,8,2,4,-0.003939278,,8,0,5,0.000812146

,,-0.424267424,-0.003636438,,,0.114285985,,,9,3,0.021268464,,9,2,7,-0.043797296,,9,1,-9,0.000283191

,,0.035577555,-0.001062606,,,-4.19626E-06,,,,,,,10,2,36,-2.66745E-05,,10,1,-7,-0.000607063

,,13.57859962,-7.87574E-24,,,3.71165E-05,,,常数R,0.461526,,,11,3,0,2.04817E-08,,11,1,-1,-0.018990068

,,,0,,,0.024765372,,,,,,,12,3,1,4.38707E-07,,12,1,0,-0.032529749

,,,2.64261E-05,,,0,,,,,,,13,3,3,-3.22777E-05,,13,1,1,-0.021841717

,,,-0.000355059,,,-0.151112178,,,,,,,14,3,6,-0.001503392,,14,1,3,-5.28384E-05

,,,-0.000496738,,,-0.005818052,,,,,,,15,3,35,-0.040668254,,15,2,-3,-0.000471843

,,,-1.85478E-19,,,0.002407441,,,,,,,16,4,1,-7.88473E-10,,16,2,0,-0.000300018

,,,-1.86179E-07,,,0,,,,,,,17,4,2,1.27907E-08,,17,2,1,4.76614E-05

,,,1.49032E-06,,,0.002281351,,,,,,,18,4,3,4.82254E-07,,18,2,3,-4.41418E-06

,,,0.000020795,,,-0.003362726,,,,,,,19,5,7,2.29221E-06,,19,2,17,-7.2695E-16

,,,3.34994E-06,,,-3.71136E-07,,,,,,,20,6,3,-1.67148E-11,,20,3,-4,-3.16796E-05

,,,-1.10753E-08,,,0.000647355,,,,,,,21,6,16,-0.002117147,,21,3,0,-2.82708E-06

,,,-9.39127E-08,,,0,,,,,,,22,6,35,-23.89574193,,22,3,6,-8.52051E-10

,,,-6.56471E-15,,,-0.000109747,,,,,,,23,7,0,-5.90596E-18,,23,4,-5,-2.24253E-06

,,,0,,,0.000172058,,,,,,,24,7,11,-1.26218E-06,,24,4,-2,-6.51712E-07

,,,-1.65047E-07,,,0.000244397,,,,,,,25,7,25,-0.038946842,,25,4,10,-1.43417E-13

,,,-3.58455E-11,,,-5.99483E-06,,,,,,,26,8,8,1.12562E-11,,26,5,-8,-4.0517E-07

,,,2.79405E-10,,,2.81622E-05,,,,,,,27,8,36,-8.23113409,,27,8,-11,-1.27343E-09

,,,-8.81801E-15,,,3.2984E-06,,,,,,,28,9,13,1.98097E-08,,28,8,-6,-1.74249E-10

,,,2.86356E-09,,,1.59585E-05,,,,,,,29,10,4,1.0407E-19,,29,21,-29,-6.87621E-19

,,,5.35639E-15,,,1.17381E-10,,,,,,,30,10,10,-1.02347E-13,,30,23,-31,1.44783E-20

,,,-2.97043E-12,,,-2.38376E-11,,,,,,,31,10,14,-1.00182E-09,,31,29,-38,2.63358E-23

,,,-1.50833E-10,,,-1.69495E-11,,,,,,,32,16,29,-8.08829E-11,,32,30,-39,-1.19476E-23

,,,-6.99339E-17,,,2.3705E-11,,,,,,,33,16,50,0.106930319,,33,31,-40,1.82289E-24

,,,2.74723E-20,,,-1.11424E-11,,,,,,,34,18,57,-0.336622506,,34,32,-41,-9.35371E-26

,,,-8.431E-23,,,1.76032E-12,,,,,,,35,20,20,8.91858E-25,,,,,

,,,3.70699E-23,,,,,,,,,,36,20,35,3.06293E-13,,,,,

,,,1.70231E-20,,,0.790710568,,,,,,,37,20,48,-4.20025E-06,,,,,

,,,-4.01853E-21,,,,,,,,,,38,21,21,-5.9056E-26,,,,,

,,,-2.49272E-24,,,,,,,,,,39,22,53,3.78269E-06,,,,,

,,,5.61366E-23,,,,,,,,,,40,23,39,-1.27686E-15,,,,,

,,,-1.76496E-23,,,,,,,,,,41,24,26,7.30876E-29,,,,,

,,,2.10335E-28,,,,,,,,,,42,24,40,5.54147E-17,,,,,

,,,7.59814E-25,,,,,,,,,,43,24,58,-9.43697E-07,,,,,

,,,-2.15302E-25,,,,,,,,,,,,,,,,,,

,,,-0.208628646,,,,,,,,,,,,,,,,,,

,饱和蒸汽,,,,饱和水,,,,,,,,,,,,,,,,

,无量纲化,π,3,,无量纲化,π,0.181488203,,,,,,,,,,,,,,

,,τ,1.065071017,,,τ,2.733682276,,,,,,,,,,,,,,

,,0,0,,,-0.084719025,,,,,,,,,,,,,,,

,,10.08665597,-0.053504587,,,0.369984268,,,,,,,,,,,,,,,

,,0.019211792,-0.155946085,,,0,,,,,,,,,,,,,,,

,,-0.208538399,-0.165473987,,,3.385516917,,,,,,,,,,,,,,,

,,0.94910313,-0.052188385,,,-2.896140265,,,,,,,,,,,,,,,

,,-2.357378226,-0.000297294,,,1.081259973,,,,,,,,,,,,,,,

,,3.864635788,-0.001927354,,,-0.229603732,,,,,,,,,,,,,,,

,,-0.605144221,-0.02558752,,,0.021205395,,,,,,,,,,,,,,,

,,0.072379322,-0.089826823,,,-0.000282963,,,,,,,,,,,,,,,

,,11.82092515,-1.82074E-11,,,0.001078103,,,,,,,,,,,,,,,

,,,0,,,0.057493423,,,,,,,,,,,,,,,

,,,1.18451E-05,,,0,,,,,,,,,,,,,,,

,,,-0.000834821,,,-0.151112178,,,,,,,,,,,,,,,

,,,-0.01403145,,,-0.002506134,,,,,,,,,,,,,,,

,,,-1.43282E-07,,,0.012974847,,,,,,,,,,,,,,,

,,,-6.38663E-08,,,0,,,,,,,,,,,,,,,

,,,1.17088E-06,,,0.002281351,,,,,,,,,,,,,,,

,,,3.74186E-05,,,-0.001448499,,,,,,,,,,,,,,,

,,,0.000126934,,,-4.39893E-10,,,,,,,,,,,,,,,

,,,-1.16723E-08,,,0.005315887,,,,,,,,,,,,,,,

,,,-0.004722197,,,0,,,,,,,,,,,,,,,

,,,-0.002273103,,,-1.33647E-05,,,,,,,,,,,,,,,

,,,0,,,0.00215276,,,,,,,,,,,,,,,

,,,-0.000100784,,,0.00086448,,,,,,,,,,,,,,,

,,,-0.002391849,,,-1.35456E-07,,,,,,,,,,,,,,,

,,,1.08686E-08,,,0.001246367,,,,,,,,,,,,,,,

,,,-0.004095796,,,0.000516349,,,,,,,,,,,,,,,

,,,5.37216E-06,,,0.00030422