怎么画压焓图excel方法

1、Steven教你学制冷一教你用excel绘制压给图小伙伴们，大家好；今天我要教大家如何用excel绘制压给图；学制冷的小伙伴们对压给图肯定不陌生，这个是制冷的入门知识，不知道的小伙伴们可要好好问问你们大大学老师了好了，方法很简单的;先看效果图:压给图基本步骤如下:Refprop嵌入exce调用函数生成数据列一excel散点图一曲线；1、Refprop嵌入excel这个教程LZ以前写过，现在以附件的形式附在后面，小伙伴可以自己下载；2、调用函数生成数据列:Refprop嵌入之后，我们就可以调用制冷剂的物性；这里有很多问题了，很多小伙伴调用Refprop之后，不知道怎么调用函数；我在这里简单的说下

2、函数的意思：看图:函数调用的格式(来自Refprop的说明书)：Temperaturcrargon",PressuretM34丁口丁14003Enthalpy("ethyleneu,TSl,.l,SI".3g3一一ViscosityC'oxygen'TP'Sr'JOO.I)ThermalConductfvhy("nitrogen".Hliqp/ST,100)Densityf"airlrTP,h,r'C10J47)EnthalpyCJRS.r/PS'molarsi"JO,110)

3、_Temperaturefethane,0.5,butane0.6mass",<hDH*/EH.3O,203>SpeedCrfSound,ammonia0.4:wat&r：0.G"TP',"E1h.30010000)Denskyr218;；d23:9*"PHT七gS7,180)小伙伴看到这里，头肯定很晕，不知道什么意思，看了半天还是不知道怎么调用函数。其实，在excel里面调用的话，还是建议采用以下的方法，如图:Tllq(TvapFHq:PvapR22.|：SIYi.ttlC.i饱和压力饱和液体饱和蒸汽等慵线过热段等温线压力(

4、bar)U<P>络值(kj/ks)埼值(kj/ks>2.IS44.9:0.。式i-i甘、L-1.4理3rifElCITTC=ErLergy($A$3J,犯牛&46)CEFTJnFT1-rTLaCC.CI-IIIInr-bCCL443.49913011|d-ta1FTrildr-hnriAPS123456解释一下函数的意思，比如:Pressure("r134a","TD","SI",400,50)Pressure：函数名，压力；第一个变量：“R134A',制冷剂类型;第二个变量：“TD”，制冷剂状态；第

5、三个变量：“sr,单位制；后面的变量：已知参数，比如温度、压力、始值等；接下来就是重点了，制冷剂的状态详解：“Tliq"，饱和状态，已知饱和液体的温度，求其他物性参数；“Tvap',饱和状态，已知饱和蒸汽的温度，求其他物性参数；“Pliq"，饱和状态，已知饱和液体的压力，求其他物性参数；“Pvap"，饱和状态，已知饱和液体的压力，求其他物性参数；“TP,非饱和状态，已知制冷温度、压力，求其他物性参数；“P6，非饱和状态，已知制冷剂压力、嫡值，求其他物性参数；喜欢就立即关注我们吧：“制冷百家”公众号，物性查询、论文下载、技术分享；制冷、暖通人最好的微信公众号

6、。知道上面这些。基本上就可以了。接下来就是利用函数生成数据列了，小伙伴们看以下图片，这是最后的效果：2riiQIVkpPlidPvap3R22SIwithC4饱和压力饱和液体饱和蓄汽等牖线讨热设等温线5压力(bar)L(?)蛤值(kj/kg)烯值(kj/kg)2.1844.960.035-1.45593211131.9564372(3T800940746010659443.499130170.045-1.346787136.710T707380.165437468.49049443.379169180.055-1.259637140.6885929381.951944475.39013443.

7、2589861g0.065-1.187087144.1323565383.48376s481.27447443.1385194100.075-1.124939147.1840505384.828349486.41752443.0177874n0085-1.070581149.9344434386.0289074go.99394442.8967882120.095-1.022276152.4453058387.114896495.12227442.7755204130.105-0.9788111S4.760&981388.107355498.88678442.653982140.115-

8、0.939302156.9132227389.021865502.34964442.5321715150.125-0.90309158.9277253389.870314505.55809442.4100869160.135-0.869666160.8235034390.661985508.54889442.28T726T170.145-0.838632162.6163109391.40428511.35123442.1650889180.155-0.809668164.3183723392.1031995139887442021717190.165-0.782516165.940089439

9、2.763679516.48066441.9189734200.175-0.756962167.4900447393.389833518.84318441.795492210.185-0.732828168.9754692393.9S5128521.08975441.6717256220.195-0.709965170.4025161394552512523.23183441.54767242302-0.69897171.0958281394.826544524.28681441.4855376240.25-0.60206177.4120838397.272165533.52406440860

10、16532503-0.522879182.8650414399.305707541.26915440.2272975260.35-0.455932187.6984124401.04380954794572439.58&8678270.4-0.39794192.06Z801402.558414553.82474438.93T9932280.45-0.3467871960583034403897234559.08437438.2809725290.5-0.30103199.7551003405.093633563.8482743T.6152845300.55-0.259637203.204

11、4575406.171912568.20593436.94U5862310.6-0.221849206.4450608407.150355572.22427436,25&5109320.65-0.187067209.5068841408.043078575.95469435.5626659330.7-0.154902212.4136656408.86122579.43758434.S3品292.TnTW;二讦豆7玄2压蛤囱制溶剂物性蓼就0.T5-o.IEW9235.1345555499.6137335az.7O5£443411394T60.6-0.01217,6无工钟6qiQ

12、.3(n定l5C5.T539T433Tl日13用0.85-0.070S61220.37E7646410.5496275CB迪543432一6806554o.g-0.04575722282B127941154450559L457T943L.930S459095-002227622S.ISSEE412.096227M4.08611431.1BS3S3719.643E-17227.4661772412.E时的SMB.5359430.39229441,050.02113S3229.6TTT667413.啊86499S.9913242g.601M22110.Q41392T231.0214477413.5

13、STKZ6C12BB9T428.T966221150.060&970233.9044469413.9392656U3一句19T42T,97514361.20.07910122359314526414.321867605.01069427.1360521.250.09691237.9063112414.677243M)7.66065426.2S055211.30.1134434次.白33CME415097003609.63264425.40505491.3E0.1303336241.7153144415,312573&11.537TB424.5000282140.14&1

14、26243,5561745415,5班226613抻口694£359097931啦0.245.3574149415.85609561&.1655142264022761.50.176091324T121OT8241S.096198SIB.89598421把1能9g155o.iraan24fi65217C9416.316448619.5754342O.06673T21万0.20412£50,549963416.51766f620.20697419.661341】，脂0.217463925E,E1T3423Wess621.7934413.6028033L.TQ.门口4用

15、行工的河DEm6.e&a尔.33TZ641T.50T76T51.TEn.243038255.4674S1F417.0H12SS24.8408925k21836221.00.2555725257.053367417,145MS626.30643258.19666111850.26717172586150127417.251B69B27.7358S2E6.17919061.90.27S7E3E260.1537103417.3&IS75S29.131062S&.15964921,95.29m348251.670&66941T,446Q14&30.493542S

16、S.14003142033103瓯3&7013741751714&31S2SZ125812213HZ05.3UT53926464361341T.5TZB63633.im256103564T10.3组1932061020653417.51430634.40099256.0B520992150.3324385267.542715417.64123535.64782£56.0670712.20.M24227206,S66055641T,655715636.86307255.M914572.2503521S25270.374T34E417.6S594563S065252560

17、3143172J303617278271.7677536417.842774&3Q2379825&01392672.350.3710679273.14E405341761633B640.3880225509662872.40.3802112274Elimi41T,5T6745B4151B3255.0T95353ATnjij&ni巨亡i力TUQ白rijjrLGv>jind巴aw-白1c1今？亡u-h陵.rrnineenenerfe1口工萋发立跆计算实脸计重垣班恰.囱制冷剂量性参切LZ这里截取了压力范围：0.0354.95Mpa范围的物性;F面就是利用excel散点图的功能了:这里就不详细讲怎么运用散点图了；还可以做压给图的等温线、等嫡线等，如图:TvapFliQFyapTP|SIwithC饱和流体悒和蒸汽等崎线过热段等温线Lg(P)烙值(kj/kg)始值(kj/kg)1.6944.9-1.15593131.95644373.00941385.4603443.4991301'1.34679136.71077380.16544339.6793443.3791891-1.25964140.68859881.95194343.125844S.2689861-1.18705144.13236383.48377346.0488443.1385194-