3.1 3.2 3.3EPR 3.4 3.5 3.6 3.7 3.8 P2 P2 P3 P3 P4 P6 P8 P10 P11 P12 P13 P14 P14 P15 P15 A1 P16 A2 P18 A3 Function P27 1
Excel Excel HC Miyamoto and Watanabe,, ASHRAE Handbook,SI Baehr and Tillner-Roth Span and Wanger ASHRAE Handbook Microsoft Excel Excel Excel Excel97 No R 290( ).xls HC CH3CH2CH3 R 600( ).xls HC CH3CH2CH2CH3 R 600a( ).xls HC (CH3)2CHCH3 R 717( ).xls NH3 R 744( ).xls CO2 Excel CD Excel Excel (H) [ ][ ][ ] (M) (L) 2
Excel 3.1) 3.2) EPR 3.3) 3.4) p-h EPR 3.5) T- EPR 3.6) 3.7) 3.8) 3.1) R 290 CD 3
3.2) R 290 E T F log(p) 1 p-h h T T-s 1 s 4
n E8 pv = E8 E E4 E5 EPR VALUE Excel Excel 5
3.3) EPR EPR 8 EPR R 290 2 COND 3 COMP EPR 6 5 7 EVAP 3 1 EVAP 8 4 9 EPR EPR EVAP EPR EPR EVAP EVAP EPR EPR 6
1011 log(p) T 3 2 h 10 p-h 4 4 5 5 7 7 11 T-s s EPR EVAP EPR EPR EVAP EVAP EVAP E E4E5 F VALUE EPR Excel 3.2) 7
3.4 12 R 290 COND EVAP CF` 13 14 15 13 8
log(p) 4 5 6 3 8 11 14 p-h h T 8 5 5 7 6 6 8 15 T-s 4 4 3 3 1 s 2 1 C5 C6C7 EPR VALUE Excel 3.2)3.3) 9
3.5 16 R 290 EPR 3.2)3.4) Ctrl g Excel 10
3.6 R290 17 Ts R 290 T EPR 3.2)3.4) Ctrl g Excel 11
3.7 R 290 0.00 v" 150 18 R 290 12
3.8 HC R 290R 600R 600a R 717 0.00 0.03 19 R 717 13
Excel #VALUE Excel 20 Excel 20 20 Excel Excel Excel Function P27 14
5 R 290R 600R 600aR 717R 744 PsT(T) MPa T= K TsP(P) K P= MPa PVT(V,T) MPa V= m 3 /kgt= K VPT(P,T) m 3 /kg P= MPaT= K HVT(V,T) ( ) SVT(V,T) kj/kg kj/(kg K)) V= m 3 /kgt= K TPS(P,S) K P= MPaS= (J/(kg K)) HfT(T) J/kg) SfT(T) kj/(kg K)) ( ) VfT(T) m 3 /kg HfPT(P,T) J/kg SfPT(P,T) kj/(kg K)) ( ) VfPT(P,T) m 3 /kg T= K P= MPaT= K H.Miyamoto, K.Watanabe: Thermodynamic Property Model or Fluid-Phase Propane, International Journal of Thermophysics, Vol.21, No.5,pp.1045-1072, 2000 H.Miyamoto, K.Watanabe: Thermodynamic Property Model or Fluid-Phase n-butane, International Journal of Thermophysics, Vol.22, No.2, pp.459-475, 2001 H.Miyamoto, K.Watanabe: Thermodynamic Property Model or Fluid-Phase Isobutane, International Journal of Thermophysics, Vol.23, No.2, pp.477-499, 2002 H.D.Baehr, R.Tillner-Roth: Thermodynamic Properties of Environmentally Acceptable Refrigerants,ISBN 3-540-58693-8,Springer-Verg,1995 R.Span, W.Wanger: A New Equation of State for Carbon Dioxide, J.Phys.Che.Ref.Data, 1996 ASHRAE Handbook, Fundamentals, pp.20.44-20.49, 2005,,,,Vol.71,No.826, pp.826-,1996-8 ASHRAE Handbook, Fundamentals, pp.20.38-, 2005 15
Excel Excel A A. Sheet1 A 0.1 1.5MPa 0.1MPa 16
A. B7 =TsP(A7)-273.15 Enter 42.4 R 290 273.15 () B7 =TsP(A7)-273.15 C7 =VfT(B7+273.15) D7 =VPT(A7,B7+273.15) E7 =HfT(B7+273.15) F7 =HVT(D7,B7+273.15) G7 =SfT(B7+273.15) H7 =SVT(D7,B7+273.15) B7 H7 B7H7 17
A PkPmPo VALUE (. ) P k P m P o CF (CF =100%) CF h7 h7=h2r(h3h6) R Ref. p.51 (H12-7-31) CF CF1(t 7t m)(t 5t m) t m P m CF0 CF 100( ) CF t m CF R R max(h2h9)(h3h5) t 7t m CF100 R min(h2h5)(h3h5) t 7t 5 CF0 CF R max R min CF 100% CF 5090 18
A. A. A B C D E F G H 8 9 MPa 3 /kg J/kg KJ/(kg K) 10 =C4 =TsP(C10) =D10+G6 =VPT(C10, =HVT(F10, =SVT(F10, 273.15 E10+273.15) E10+273.15) E10+273.15) 11 =C5 =TsP(C11) =TPS(C11, =VPT(C11, =HVT(F11, =H10 273.15 H11)273.15 E11+273.15) E11+273.15) 12 =C5 =TsP(C12) =D12+G5 =VPT(C12, =HVT(F12, =SVT(F12, 273.15 E12+273.15) E12+273.15) E12+273.15) 13 =C6 =TsP(C13) =TPS(C13, =VPT(C13, =HVT(F13, =H13 273.15 H13)273.15 E13+273.15) E13+273.15) 14 =C6 =TsP(C14) 273.15 =D14G5 =VfT(E14 +273.15) =HfPT(E14 +273.15 15 =C6 =TsP(C15) 273.15 =TfH(H15) 273.15 =VfPT(C15, E15+273.15) =G11F18* (G12G14) 19
E11 E13 E15 TfH(H) A3 G15 D E F 17 Rmin Rmax R 18 =(G11G14)/(G12G14) =(G11-HfPT(C12,D12 +273.15)) /(G12G14) =D18+G3*(E18D18) D E F G H 19 kj/kg COP 20 = G13G12 =G11G10 =F18*D20+F20 = G10G17 = G20/F20 A. R 290 ( ) Excel 20
A. A B P k B P m P o A Excel LNVBA LOG Sheet2 A 21
A. A Excel OK 3.2 (T) (P) (C) (S) 2.5.1 A X X Y (A) (N) A A X (X) 22
A2.5.2 X Sheet2 B24 H24 X X A2.5.3 Y A2.5.2 Y (Y) A X 23
A2.5.4 Y LOG Sheet2 B25 H25 Y Sheet2 OK 24
A2.5.5 A A (O) (E) (C) (W) (M) OK A 25
A. B B A A2. ( ) (A) B Sheet2 B27 D27 Sheet2 B28 D28 OK. 26
A3 Function CO 2 NH 3 27