Excel Excel HC Miyamoto and Watanabe,, ASHRAE Handbook,SI Baehr and Tillner-Roth Span and Wanger ASHRAE Handbook Microsoft Excel Excel Excel Excel97 N

Size: px

Start display at page:

Download "Excel Excel HC Miyamoto and Watanabe,, ASHRAE Handbook,SI Baehr and Tillner-Roth Span and Wanger ASHRAE Handbook Microsoft Excel Excel Excel Excel97 N"

せぴあちづ
7 years ago
Views:

1 EPR P2 P2 P3 P3 P4 P6 P8 P10 P11 P12 P13 P14 P14 P15 P15 A1 P16 A2 P18 A3 Function P27 1

2 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

3 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

4 3.2) R 290 E T F log(p) 1 p-h h T T-s 1 s 4

5 n E8 pv = E8 E E4 E5 EPR VALUE Excel Excel 5

6 3.3) EPR EPR 8 EPR R COND 3 COMP EPR EVAP 3 1 EVAP EPR EPR EVAP EPR EPR EVAP EVAP EPR EPR 6

7 1011 log(p) T 3 2 h 10 p-h T-s s EPR EVAP EPR EPR EVAP EVAP EVAP E E4E5 F VALUE EPR Excel 3.2) 7

8 R 290 COND EVAP CF`

9 log(p) p-h h T T-s s 2 1 C5 C6C7 EPR VALUE Excel 3.2)3.3) 9

10 R 290 EPR 3.2)3.4) Ctrl g Excel 10

11 3.6 R Ts R 290 T EPR 3.2)3.4) Ctrl g Excel 11

12 3.7 R v" R

13 3.8 HC R 290R 600R 600a R R

14 Excel #VALUE Excel 20 Excel Excel Excel Excel Function P27 14

15 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 , 2000 H.Miyamoto, K.Watanabe: Thermodynamic Property Model or Fluid-Phase n-butane, International Journal of Thermophysics, Vol.22, No.2, pp , 2001 H.Miyamoto, K.Watanabe: Thermodynamic Property Model or Fluid-Phase Isobutane, International Journal of Thermophysics, Vol.23, No.2, pp , 2002 H.D.Baehr, R.Tillner-Roth: Thermodynamic Properties of Environmentally Acceptable Refrigerants,ISBN ,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 , 2005,,,,Vol.71,No.826, pp.826-, ASHRAE Handbook, Fundamentals, pp ,

16 Excel Excel A A. Sheet1 A MPa 0.1MPa 16

17 A. B7 =TsP(A7) Enter 42.4 R () B7 =TsP(A7) C7 =VfT(B ) D7 =VPT(A7,B ) E7 =HfT(B ) F7 =HVT(D7,B ) G7 =SfT(B ) H7 =SVT(D7,B ) B7 H7 B7H7 17

18 A PkPmPo VALUE (. ) P k P m P o CF (CF =100%) CF h7 h7=h2r(h3h6) R Ref. p.51 (H ) 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

19 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, E ) E ) E ) 11 =C5 =TsP(C11) =TPS(C11, =VPT(C11, =HVT(F11, =H H11) E ) E ) 12 =C5 =TsP(C12) =D12+G5 =VPT(C12, =HVT(F12, =SVT(F12, E ) E ) E ) 13 =C6 =TsP(C13) =TPS(C13, =VPT(C13, =HVT(F13, =H H13) E ) E ) 14 =C6 =TsP(C14) =D14G5 =VfT(E ) =HfPT(E =C6 =TsP(C15) =TfH(H15) =VfPT(C15, E ) =G11F18* (G12G14) 19

20 E11 E13 E15 TfH(H) A3 G15 D E F 17 Rmin Rmax R 18 =(G11G14)/(G12G14) =(G11-HfPT(C12,D )) /(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

21 A. A B P k B P m P o A Excel LNVBA LOG Sheet2 A 21

22 A. A Excel OK 3.2 (T) (P) (C) (S) A X X Y (A) (N) A A X (X) 22

23 A2.5.2 X Sheet2 B24 H24 X X A2.5.3 Y A2.5.2 Y (Y) A X 23

24 A2.5.4 Y LOG Sheet2 B25 H25 Y Sheet2 OK 24

25 A2.5.5 A A (O) (E) (C) (W) (M) OK A 25

26 A. B B A A2. ( ) (A) B Sheet2 B27 D27 Sheet2 B28 D28 OK. 26

27 A3 Function CO 2 NH 3 27

2004 R404A 12 Microsoft Excel Excel Excel Excel97 No R 22-Ver2.xls HCFC CHClF2 () R 123-Ver2.xls HCFC CHCl2CF3 () 3 R 125-Ver2.xls HFC CHF2CF3 () 4 R

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 P15 P15 P16 P16 A1 A2 A3 Function P17 P17 P19 P29 1 2004 R404A 12 Microsoft Excel Excel Excel Excel97 No R 22-Ver2.xls HCFC CHClF2