LP Flash
LP Flash
LP Flash
xsl
This spreadsheet performs flash calculations at low pressures and temperatures.
(pressure < 1,000 psia, temperature < 200 oF)
Instructions:
1) Update input data in blue;
2) Run Macro Solution;
3) Enter a value for z-factor in the "Flash Calculation" section;
4) View results.
Input Data:
Pressure:
Temperature:
Specific gravity of stock tank oil:
Specific gravity of solution gas:
Gas solubility (Rs):
600
200
0.90
0.70
500
psia
F
water = 1
air = 1
scf/STB
Composition
Compound Mole Fraction (zi)
C1
0.6599
C2
0.0869
C3
0.0591
i-C 4
0.0239
n-C 4
0.0278
i-C 5
0.0157
n-C 5
0.0112
C6
0.0181
C 7+
0.0601
N2
0.0194
CO 2
H2S
0.0121
0.0058
1.0000
Property Table:
a=
c=
n=
1.47054
0.7754
9.76
Compound
C1
b (oR)
TB (oR)
ki
300
94
2.736943907
6.525519
C2
1145
303
2.044029403
1.893778
C3
1799
416
1.598761655
0.855202
i-C 4
2037
471
1.238477128
0.449473
n-C 4
2153
491
1.122807505
0.365606
i-C 5
2368
542
0.781124902
0.198643
n-C 5
2480
557
0.694847941
0.170284
C6
2738
610
0.340039742
0.090377
C 7+
3770
793
-0.955824154
0.008938
N2
470
109
3.599805393
30.45635
CO 2
652
194
2.372945954
3.406991
H2S
1136
331
1.710812048
1.044606
Flash Calculation:
nv =
0.8791
Compound
C1
zi
ki
zi(ki-1)/[nv(ki-1)+1]
0.6599
6.5255
0.6225
C2
0.0869
1.8938
0.0435
C3
0.0591
0.8552
-0.0098
i-C 4
0.0239
0.4495
-0.0255
n-C 4
0.0278
0.3656
-0.0399
i-C 5
0.0157
0.1986
-0.0426
n-C 5
0.0112
0.1703
-0.0343
C6
0.0181
0.0904
-0.0822
C 7+
0.0601
0.0089
-0.4626
N2
0.0194
30.4563
0.0212
CO 2
0.0121
3.4070
0.0093
H2S
0.0058
1.0446
0.0002
0.0000
nL =
0.1209
Compound
C1
xi
yi
xiMW i
yiMW i
0.1127
0.7352
1.8071
11.7920
C2
0.0487
0.0922
1.4633
2.7712
C3
0.0677
0.0579
2.9865
2.5540
i-C 4
0.0463
0.0208
2.6918
1.2099
n-C 4
0.0629
0.0230
3.6530
1.3356
i-C 5
0.0531
0.0106
3.8330
0.7614
n-C 5
0.0414
0.0070
2.9863
0.5085
C6
0.0903
0.0082
7.7857
0.7036
C 7+
0.4668
0.0042
53.3193
0.4766
N2
0.0007
0.0220
0.0202
0.6156
CO 2
0.0039
0.0132
0.1709
0.5823
H2S
0.0056
0.0058
0.1902
0.1987
80.91
23.51
0.76
0.81
0.958
47.19
2.08
0.04
319.66
8659
56
MW i
ziMW i
pci (psia)
zipci (psia)
Tci, (oR)
ziTci (oR)
16.04
10.58
673
444.11
344
227.01
30.07
2.61
709
61.61
550
47.80
44.10
2.61
618
36.52
666
39.36
58.12
1.39
530
12.67
733
17.52
58.12
1.62
551
15.32
766
21.29
72.15
1.13
482
7.57
830
13.03
72.15
0.81
485
5.43
847
9.49
86.18
1.56
434
7.86
915
16.56
114.23
6.87
361
21.70
1024
61.54
28.02
0.54
227
4.40
492
9.54
44.01
0.53
1073
12.98
548
6.63
34.08
0.20
672
3.90
1306
7.57
MW a =
30.45
ppc =
634
Tpc =
477
water =1
air = 1
lbm/ft3
lbm/ft3
bbl
scf
scf/bbl