Scribd
Upload
108 views3 pages

Data

This spreadsheet uses the black oil and Hall-Yarborough gas compressibility models to calculate gas volume and compressibility factor based on input composition and PVT data. The user inputs gas composition, temperature, and pressure data. The spreadsheet then uses the black oil model to calculate gas volume and the Hall-Yarborough method to calculate the compressibility factor. Key results like gas volume, compressibility factor, and density are displayed.

Uploaded by

Eduardo Paulini Villanueva
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
108 views3 pages

Data

This spreadsheet uses the black oil and Hall-Yarborough gas compressibility models to calculate gas volume and compressibility factor based on input composition and PVT data. The user inputs gas composition, temperature, and pressure data. The spreadsheet then uses the black oil model to calculate gas volume and the Hall-Yarborough method to calculate the compressibility factor. Key results like gas volume, compressibility factor, and density are displayed.

Uploaded by

Eduardo Paulini Villanueva
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/ 3

Gas-release.

xlsm
Instruction: This spreadsheet computes gas volume release based on black oil model calculation
Instruction: 1) SUpdate data in the Input Data section; 2) Click Solution button; 3) View result.
Input Data: 1

Input data Results


Components Lobitos Mwa MWg 20.1345
N2 0.4679 28.01 SG 0.6967
CO2 0.215 44.01 Tpc 388 °R
H2S 0 98.08 Ppc 669 psia
C1 85.7368 16.04 Top 110.0 °F 570.0 °R
C2 6.1766 30.07 Pop 900.0 psia
C3 3.5415 44.10 Ppr 1.34
iC4 1.327 58.12 Tpr 1.47
nC4 1.3965 58.12 Zf 0.876053577
iC5 0.5909 72.15 Zi
nC5 0.3454 72.15 Slope -0.092
nc6 0.2358 86.18 Cpr 0.848817363
nc7 0.1756 100.20 Cg* 0.001268314
nc8 0.0853 114.23 Cg 0.0011111111
C6+ 47/35/17 0.4966 - L 23 ft
D 1.94 in
Temperature i 110 °F V 0.4636 ft3
Temperature f 60 °F V 22.6831 scf
Pressure i 900 psia ΔV/ΔP 0.02520 ft3/psi
Pressure f 14.7 psia ΔP 885.3 *900 a 14.7 psig
ΔV 22.3127
Total 44.9958 scf
Hall-Yarborogh-z.xlsm
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: 110 oF 100


Pressure: 900 psia 1
Gas specific gravity: 0.70 air = 1 0.7
Nitrogen mole fracytion: 0 0.05
Carbon dioxide fraction: 0 0.05
Hydrogen sulfite fraction: 0 0.02

T pc  326  315.7( g  0.5)   83.3 y CO2 


240Ry N 2 370.86959091
= 388.09652536 o

p pc  678  50( g  0.5)  206 y N2 


.7 psia
= 668.16526364 440 y CO2 
4.5453419295

T
T pr  = 1.5415347909
T pc
1
tr  = 0.6487041395
T pr
p
p pr  = 1.3469721474
p pc
)2
A  0.06125 tr e 1.2 (1 t r
= 0.034263984


B  t r 14.76  9.76t=r6.7179734101
 4.58t r
2

C  tr  90.7  242.2t  42.4t r
= -31.50983001
r
2

D  2.18  2.82
= 4.0093456733
tr
Y = ASSUMED = 0.052682431

Y Y 2 Y 3 Y 4 = 0.0003632015
f (Y )   Ap pr  BY 2
 CY
(1  Y ) 3
= 0.876053577
Ap pr
z 
Y

2 .7  p
= 3.3903401617 lbm/ft3 54.195472553
 g 
g

zT
C 570 oF
MPa 900 psia
air = 1 0.6966947271 air=1
0
0
0

 83.K3 y CO2  133.3 y H s S


o

 440
MPay
CO2  606.7 y H s S

58t r
2

.4t r
2

BY 2
 CY D
 0

kg/m3

You might also like