0% found this document useful (0 votes)
64 views5 pages

Newton-Raphson (Z)

This spreadsheet calculates gas compressibility factor using the Hall-Yarborough method. The user selects a unit system, inputs temperature, pressure, gas composition data, and clicks a button to calculate the compressibility factor and gas density. The spreadsheet uses an iterative method to solve the Hall-Yarborough equation to determine the compressibility factor.
Copyright
© © All Rights Reserved
We take content rights seriously. If you suspect this is your content, claim it here.
Available Formats
Download as XLSX, PDF, TXT or read online on Scribd
0% found this document useful (0 votes)
64 views5 pages

Newton-Raphson (Z)

This spreadsheet calculates gas compressibility factor using the Hall-Yarborough method. The user selects a unit system, inputs temperature, pressure, gas composition data, and clicks a button to calculate the compressibility factor and gas density. The spreadsheet uses an iterative method to solve the Hall-Yarborough equation to determine the compressibility factor.
Copyright
© © All Rights Reserved
We take content rights seriously. If you suspect this is your content, claim it here.
Available Formats
Download as XLSX, PDF, TXT or read online on Scribd
You are on page 1/ 5

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 (1tr )

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

You might also like