Hall-Yarborogh-z.
xls
Instruction: This spreadsheet computes gas compressibility factor with Hall-Yarborough method.
Instruction: 1) Select a unit system; 2) Update data in the Input Data section; 3) Click Solution button; 4) View result.
Input Data:                                                                                       1
   Temperature:                                                                      300 oF                 100
   Pressure:                                                                        2000 psia                  1
   Gas specific gravity:                                                              0.7 air = 1            0.7
   Nitrogen mole fracytion:                                                          0.05                   0.05
   Carbon dioxide fraction:                                                          0.05                   0.05
   Hydrogen sulfite fraction:                                                        0.02                   0.02
 T pc  326  315.7( g  0.5)  240 y N 2  83.3 y CO2  133
                                                           = .375.641                      R          383.99944
                                                                                           o
                                                              3 yHsS
  p pc  678  50( g  0.5)  206.7 y N 2  440 y CO2  606
                                                           = .7691.799
                                                               yHsS                        psia       4.7061156
          T
 T pr                                                                      = 1.763518
         T pc
         1
  tr                                                                       = 0.5670484
        T pr
            p
  p pr                                                                     = 2.8910131
          p pc
                                     2                                      = 0.0277356
 A  0.06125 t r e 1.2 (1tr )
       
 B  t r 14.76  9.76t r  4.58t r
                                            2
                                                                           = 6.0664415
 C  t 90.7  242.2t                               
                                                2
        r                       r    42.4t r                               =   -18.7158
                                                                            = 3.7790764
 D  2.18  2.82t r
Y = ASSUMED                                                                 = 0.0906024
          Y Y 2 Y 3 Y 4                                                  = 0.000158
 f (Y )                    Ap pr  BY 2  CY D  0
              (1  Y ) 3
        Ap pr                                                               = 0.8850097
  z 
            Y
            2 .7         p                                                 = 5.6199209 lbm/ft3       89.835902
  g 
                      g
                 zT
       2 .7        p
g 
                g
          zT
utton; 4) View result.
              C           760 oF
              MPa        2000 psia
              air = 1      0.7 air=1
                          0.05
                          0.05
                          0.02
              o
               K
              MPa
              kg/m3
     Yn            f(Y)        f'(Y)        Yn+1
          0.9 1765.3373844 55737.305125 0.8683275433
0.8683275433 732.77462121 18035.672728 0.8276983618
0.8276983618 301.44398619 5907.3934785 0.7766701058
0.7766701058 122.33296316 1969.2601267 0.7145488241
0.7145488241 48.717522651 671.71668112 0.6420219329
0.6420219329 18.957950015 235.13011098 0.5613944457
0.5613944457 7.2043459986 84.296155642 0.4759297416
0.4759297416 2.6870418852 30.71098286 0.3884352482
0.3884352482 0.9939904299 11.236209447 0.2999721029
0.2999721029 0.3680573498 4.113425086 0.2104950024
0.2104950024 0.131917348 1.6214916939 0.1291394527
0.1291394527 0.034084736 0.9319559355 0.0925661184
0.0925661184 0.0018233359 0.8488773784 0.0904181804
0.0904181804 2.138897E-06 0.8469349893 0.090415655
 0.090415655 2.665111E-12 0.8469328788 0.090415655
 0.090415655 -4.29344E-17 0.8469328788 0.090415655
 0.090415655 2.602085E-17 0.8469328788 0.090415655
 0.090415655 -2.55872E-17 0.8469328788 0.090415655
 0.090415655 2.602085E-17 0.8469328788 0.090415655
 0.090415655 -2.55872E-17 0.8469328788 0.090415655
 0.090415655 2.602085E-17 0.8469328788 0.090415655
 0.090415655 -2.55872E-17 0.8469328788 0.090415655
 0.090415655 2.602085E-17 0.8469328788 0.090415655
 0.090415655 -2.55872E-17 0.8469328788 0.090415655
 0.090415655 2.602085E-17 0.8469328788 0.090415655
 0.090415655 -2.55872E-17 0.8469328788 0.090415655
 0.090415655 2.602085E-17 0.8469328788 0.090415655
 0.090415655 -2.55872E-17 0.8469328788 0.090415655
 0.090415655 2.602085E-17 0.8469328788 0.090415655
 0.090415655 -2.55872E-17 0.8469328788 0.090415655
 0.090415655 2.602085E-17 0.8469328788 0.090415655
 0.090415655 -2.55872E-17 0.8469328788 0.090415655
 0.090415655 2.602085E-17 0.8469328788 0.090415655
 0.090415655 -2.55872E-17 0.8469328788 0.090415655
 0.090415655 2.602085E-17 0.8469328788 0.090415655
 0.090415655 -2.55872E-17 0.8469328788 0.090415655
 0.090415655 2.602085E-17 0.8469328788 0.090415655
 0.090415655 -2.55872E-17 0.8469328788 0.090415655
 0.090415655 2.602085E-17 0.8469328788 0.090415655
 0.090415655 -2.55872E-17 0.8469328788 0.090415655
 0.090415655 2.602085E-17 0.8469328788 0.090415655
 0.090415655 -2.55872E-17 0.8469328788 0.090415655
 0.090415655 2.602085E-17 0.8469328788 0.090415655
 0.090415655 -2.55872E-17 0.8469328788 0.090415655
 0.090415655 2.602085E-17 0.8469328788 0.090415655
 0.090415655 -2.55872E-17 0.8469328788 0.090415655
 0.090415655 2.602085E-17 0.8469328788 0.090415655
 0.090415655 -2.55872E-17 0.8469328788 0.090415655
0.090415655   2.602085E-17 0.8469328788   0.090415655
0.090415655   -2.55872E-17 0.8469328788   0.090415655
0.090415655   2.602085E-17 0.8469328788   0.090415655
0.090415655   -2.55872E-17 0.8469328788   0.090415655