Scribd Logo
Upload

Welcome to Scribd!

  • 332 views

    Gaswellloading - XLS: This Spreadsheet Calculates The Minimum Unloading Gas Production Rate. Instructions

    Uploaded by

    math62210
    This spreadsheet calculates the minimum unloading gas production rate for a gas well. It requires input data on well parameters and fluid properties. The spreadsheet then uses a macro to run calculations and provide the minimum unloading rate. It displays the input data, calculated parameters, and solution including the calculated minimum gas production rate and objective function value. A graph compares the calculated minimum rate to actual test rates to determine if the well is unloaded, nearly loaded, or loaded.

    Copyright:

    Attribution Non-Commercial (BY-NC)
    Download as XLS, PDF, TXT or read online from Scribd

    Gaswellloading - XLS: This Spreadsheet Calculates The Minimum Unloading Gas Production Rate. Instructions

    Uploaded by

    math62210
    332 views9 pages
    This spreadsheet calculates the minimum unloading gas production rate for a gas well. It requires input data on well parameters and fluid properties. The spreadsheet then uses a macro to run calculations and provide the minimum unloading rate. It displays the input data, calculated parameters, and solution including the calculated minimum gas production rate and objective function value. A graph compares the calculated minimum rate to actual test rates to determine if the well is unloaded, nearly loaded, or loaded.

    Original Title

    Gas Well Loading

    Copyright

    © Attribution Non-Commercial (BY-NC)

    Available Formats

    XLS, PDF, TXT or read online from Scribd

    Did you find this document useful?

    Is this content inappropriate?

    This spreadsheet calculates the minimum unloading gas production rate for a gas well. It requires input data on well parameters and fluid properties. The spreadsheet then uses a macro to run calculations and provide the minimum unloading rate. It displays the input data, calculated parameters, and solution including the calculated minimum gas production rate and objective function value. A graph compares the calculated minimum rate to actual test rates to determine if the well is unloaded, nearly loaded, or loaded.

    Copyright:

    Attribution Non-Commercial (BY-NC)
    Download as XLS, PDF, TXT or read online from Scribd
    Download as xls, pdf, or txt
    332 views9 pages

    Gaswellloading - XLS: This Spreadsheet Calculates The Minimum Unloading Gas Production Rate. Instructions

    Uploaded by

    math62210
    This spreadsheet calculates the minimum unloading gas production rate for a gas well. It requires input data on well parameters and fluid properties. The spreadsheet then uses a macro to run calculations and provide the minimum unloading rate. It displays the input data, calculated parameters, and solution including the calculated minimum gas production rate and objective function value. A graph compares the calculated minimum rate to actual test rates to determine if the well is unloaded, nearly loaded, or loaded.

    Copyright:

    Attribution Non-Commercial (BY-NC)
    Download as XLS, PDF, TXT or read online from Scribd
    Download as xls, pdf, or txt
    of 9
    At a glance
    Powered by AI
    The spreadsheet is calculating the minimum unloading gas production rate from a gas well based on various input parameters like gas specific gravity, producing depth, wellhead pressure, etc.

    The spreadsheet is calculating the minimum unloading gas production rate, which is the minimum rate at which gas needs to be produced to prevent the well from loading up with liquids and solids. This ensures smooth production.

    It determines the minimum unloading gas production rate by inputting various parameters into equations that model the flow behavior in the conduit. Parameters like conduit diameter, temperature, pressure, liquid and solid makes are used to calculate the minimum flow rate needed for unloading.

    GasWellLoading.

    xls
    This spreadsheet calculates the minimum unloading gas production rate.
    Instructions:
    1) Update input data in blue;
    2) Run Macro "Solution";
    3) Veiw result.

    Input Data:
    Gas specific gravity
    Hole inclination
    Producing depth
    Wellhead pressure
    Wellhead temperature
    Producing zone temperature
    Condensate gravity
    Condensate make
    Water specific gravity
    Water make
    Solid specific gravity
    Solid make
    Conduit OD
    Conduit ID
    Conduit wall roughness
    Major liquid (1=water; -1=condensate)
    Heavy liquid-gas interfacial tension
    Heavy liquid density

    0.6
    0
    6700
    500
    60
    127
    70.8
    0
    1.08
    10.5
    2.65
    0
    1.995
    0
    0.000015
    1
    60
    67.39

    air =1
    Deg
    ft
    psi
    o
    F
    o
    F
    API
    bbl/MMscf
    water = 1
    bbl/MMscf
    water = 1
    ft3/MMscf
    inch
    inch
    inch
    dyne/cm
    lb/ft3

    0
    72000
    520
    587
    0.53764259
    0
    8.67449828
    0
    0.16625
    0
    0.00000125

    60 for water and 20 for condensat


    Should be determined based on F

    Calculated Parameters:
    Hydraulic diameter
    Conduit cross-sectional area
    Average temperature
    Minimum kinetic energy

    0.1663 ft
    2
    0.0217 ft
    o
    553.5 R
    3
    3.6627 lbf-ft/ft

    a=
    b=
    c=
    d=
    e=
    f =
    m=
    n=

    2.21319E-05
    2.61599E-08
    993081.767
    0.025982888
    0.000721177
    0.007714093
    18.60862817
    711232734

    Solution:

    1.1259E+11
    826 Mscf/day
    590 psia
    -0.000191102

    Gas production rate


    Pressure (P) =
    Objective function f(Qg) =

    b
    n bm 2
    c
    n

    tan

    826142.693
    84922.6064

    Pm

    tan
    n

    Phf m

    bP Phf

    1 2bm P m n
    ln
    2
    Phf m2 n

    P-Phf =
    P+m =
    Phf+m =
    sqrt (n) =
    (1-2bm)/2 =
    m+bn/c-bm2 =
    RHS =

    b
    n bm 2
    c
    n

    12922.60644
    84941.21507
    72018.60863
    26668.947
    0.499999513
    18.60863785
    0.148284131

    tan

    Pm

    tan
    n

    Phf m

    Rad
    lbf/ft2
    R
    o
    R
    water = 1
    bbl/day
    o

    bbl/day
    ft3/day
    ft
    ft
    ft

    60 for water and 20 for condensate.


    Should be determined based on F14 or H12 !

    m
    tan
    n

    Ekm 0.0576 L
    a

    15.33SsQs 86.07SwQw 86.07SoQo 0.01879S g Qg

    TQg
    0.2456 Qs 1.379 Qw 1.379 Qo
    b
    TQ g

    4.712 10 5 TQ g

    A
    cde
    m
    1 d 2e

    scf/day
    lbf/ft2

    Phf m

    Q 5.615Qw Qo
    d s
    86400A

    c 2e

    1 d e
    2

    3
    573.7102 ft /min

    P 6.46 10

    cos( )

    13

    2
    S g TQgm

    A 2 Ekm

    1
    f

    2
    1.74 2 log

    DH

    f
    2 gDH cos( )

    m
    tan
    n

    P 6.46 10
    1

    13

    Phf m

    a 1 d 2 e L
    n

    2
    S g TQgm

    A 2 Ekm

    Test Flow Rate (Mcf/D)

    12000
    10000
    8000
    6000
    4000

    Unloaded
    ?

    Nearly loaded up

    2000

    Loaded up
    Questionable

    0
    0

    2000

    4000

    6000

    8000

    10000

    Calculated Minimum Flow Rate (Mcf/D)

    12000

    Test Flow Rate (Mcf/D)

    12000
    10000
    8000
    6000
    4000

    Unloaded
    ?

    Nearly loaded up

    2000

    Loaded up
    Questionable

    0
    0

    2000

    4000

    6000

    8000

    10000

    Calculated Minimum Flow Rate (Mcf/D)

    12000

    Turner's
    Drop Model
    (Mcf/D)

    Test
    No.

    779
    583
    306
    661
    419
    958
    1158
    2401
    2395
    1600
    1610
    1901
    1654
    1941
    936
    3757
    3233
    5902
    6015
    3412
    5671
    5559
    5485
    5212
    3199
    1239
    1407
    1467
    1502
    1770
    1732
    1705
    1659
    851
    814
    750
    686
    875
    859
    832
    803
    1216
    1176
    1070
    918
    834
    817
    770

    1
    2
    3
    4
    5
    97
    8
    11
    12
    14
    18
    20
    23
    28
    30
    33
    36
    42
    45
    55
    51
    48
    52
    53
    56
    57
    58
    59
    60
    61
    62
    63
    64
    65
    66
    67
    68
    69
    70
    71
    72
    73
    74
    75
    76
    77
    78
    79

    Turner's
    Test Gas
    Drop Model
    Flow Rate Status During Test
    (Adjusted)
    (Mcf/D)
    (Mcf/D)
    775
    Nearly loaded up
    934.8
    417
    Nearly loaded up
    699.6
    568
    Nearly loaded up
    367.2
    712
    Nearly loaded up
    793.2
    442
    Nearly loaded up
    502.8
    1607
    Nearly loaded up
    1149.6
    2494
    Questionable
    1389.6
    3264
    Questionable
    2881.2
    4095
    Questionable
    2874
    2915
    Questionable
    1920
    2503
    Questionable
    1932
    2069
    Questionable
    2281.2
    3182
    Questionable
    1984.8
    4896
    Questionable
    2329.2
    1116
    Questionable
    1123.2
    6405
    Questionable
    4508.4
    3551
    Questionable
    3879.6
    9039
    Questionable
    7082.4
    8210
    Questionable
    7218
    4998
    Questionable
    4094.4
    8057
    Questionable
    6805.2
    8406
    Questionable
    6670.8
    9860
    Unloaded
    6582
    11767
    Unloaded
    6254.4
    6423
    Unloaded
    3838.8
    8672
    Unloaded
    1486.8
    6654
    Unloaded
    1688.4
    5136
    Unloaded
    1760.4
    3917
    Unloaded
    1802.4
    3376
    Unloaded
    2124
    4830
    Unloaded
    2078.4
    6221
    Unloaded
    2046
    7792
    Unloaded
    1990.8
    1139
    Unloaded
    1021.2
    1712
    Unloaded
    976.8
    2473
    Unloaded
    900
    2965
    Unloaded
    823.2
    1797
    Unloaded
    1050
    2502
    Unloaded
    1030.8
    3460
    Unloaded
    998.4
    4439
    Unloaded
    963.6
    1596
    Unloaded
    1459.2
    2423
    Unloaded
    1411.2
    3598
    Unloaded
    1284
    4410
    Unloaded
    1101.6
    2939
    Unloaded
    1000.8
    4140
    Unloaded
    980.4
    5820
    Unloaded
    924

    This
    Work
    (Mcf/D)
    961
    744
    591
    861
    514
    1327
    1543
    3366
    3359
    2241
    2226
    1548
    2239
    3222
    1153
    4896
    3664
    7947
    8001
    4611
    7341
    7314
    7157
    6795
    4327
    1404
    1612
    1704
    1758
    2345
    2316
    2282
    2231
    892
    967
    893
    820
    1011
    1003
    982
    953
    1499
    1436
    1297
    1123
    1006
    982
    935

    746
    899
    833
    755
    683
    1082
    1058
    1026
    996
    941
    856
    5098
    1150
    1142
    1085
    1574
    1082
    1648
    1569
    1930
    910
    3747
    3195
    4649
    5857
    5957
    5535
    5580
    5931
    3281
    3767
    1604
    1956
    1660
    1623
    1108
    1635
    5045
    1148
    1099
    1197
    1419
    1156
    5093
    5923
    6186
    6359
    2184
    1726
    6367
    2083
    3248

    80
    81
    82
    83
    84
    85
    86
    87
    88
    89
    90
    91
    7
    9
    16
    19
    21
    24
    26
    29
    31
    34
    37
    40
    43
    46
    49
    47
    41
    35
    32
    25
    27
    22
    17
    15
    13
    92
    93
    94
    95
    96
    6
    98
    99
    100
    101
    102
    103
    104
    105
    106

    6871
    1943
    2910
    3742
    4485
    3436
    4471
    1550
    1804
    2385
    2949
    3024
    2926
    3726
    2572
    3351
    2769
    3890
    3517
    6946
    1959
    7504
    4150
    5513
    9897
    9289
    9747
    7109
    8185
    3009
    5501
    2547
    3472
    2542
    2261
    1792
    1814
    3863
    1247
    1313
    1356
    1365
    1525
    5740
    3890
    2780
    1638
    400
    800
    4300
    500
    470

    Unloaded
    Unloaded
    Unloaded
    Unloaded
    Unloaded
    Unloaded
    Unloaded
    Unloaded
    Unloaded
    Unloaded
    Unloaded
    Unloaded
    Unloaded
    Unloaded
    Unloaded
    Unloaded
    Unloaded
    Unloaded
    Unloaded
    Unloaded
    Unloaded
    Unloaded
    Unloaded
    Unloaded
    Unloaded
    Unloaded
    Unloaded
    Loaded up
    Loaded up
    Loaded up
    Loaded up
    Loaded up
    Loaded up
    Loaded up
    Loaded up
    Loaded up
    Loaded up
    Loaded up
    Loaded up
    Loaded up
    Loaded up
    Loaded up
    Loaded up
    Loaded up
    Loaded up
    Loaded up
    Loaded up
    Loaded up
    Loaded up
    Loaded up
    Loaded up
    Loaded up

    895.2
    1078.8
    999.6
    906
    819.6
    1298.4
    1269.6
    1231.2
    1195.2
    1129.2
    1027.2
    6117.6
    1380
    1370.4
    1302
    1888.8
    1298.4
    1977.6
    1882.8
    2316
    1092
    4496.4
    3834
    5578.8
    7028.4
    7148.4
    6642
    6696
    7117.2
    3937.2
    4520.4
    1924.8
    2347.2
    1992
    1947.6
    1329.6
    1962
    6054
    1377.6
    1318.8
    1436.4
    1702.8
    1387.2
    6111.6
    7107.6
    7423.2
    7630.8
    2620.8
    2071.2
    7640.4
    2499.6
    3897.6

    895
    1433
    1333
    1213
    1099
    1267
    1247
    1243
    1208
    1140
    1034
    6476
    1458
    1520
    1532
    2175
    1527
    2231
    2038
    3109
    1126
    4890
    3627
    5931
    7896
    7921
    7290
    7335
    7988
    3711
    4904
    2100
    3274
    2243
    2256
    1540
    2307
    6332
    1588
    1577
    1619
    1868
    1494
    5938
    6871
    7166
    7357
    2338
    2242
    7975
    2906
    4406

    2412
    4920
    4793
    6082
    5641
    3613

    10
    38
    39
    44
    50
    54

    2611
    4441
    4843
    6702
    6361
    4124

    Loaded up
    Loaded up
    Loaded up
    Loaded up
    Loaded up
    Loaded up

    2894.4
    5904
    5751.6
    7298.4
    6769.2
    4335.6

    3388
    6262
    6106
    8093
    7303
    4885

    You might also like