Scribd Logo
Upload

Welcome to Scribd!

  • 65 views

    Calculate Gas Compressibility Factor

    Uploaded by

    matteo2009
    The document describes how to calculate gas compressibility in Excel and provides an example macro function. It includes input parameters for a gas sample and shows the reduced temperature, reduced pressure, and calculated Z factor values over a range of pressures.

    Copyright:

    © All Rights Reserved
    Download as XLS, PDF, TXT or read online from Scribd

    Calculate Gas Compressibility Factor

    Uploaded by

    matteo2009
    65 views2 pages
    The document describes how to calculate gas compressibility in Excel and provides an example macro function. It includes input parameters for a gas sample and shows the reduced temperature, reduced pressure, and calculated Z factor values over a range of pressures.

    Original Description:

    compress

    Copyright

    © © All Rights Reserved

    Available Formats

    XLS, PDF, TXT or read online from Scribd

    Did you find this document useful?

    Is this content inappropriate?

    The document describes how to calculate gas compressibility in Excel and provides an example macro function. It includes input parameters for a gas sample and shows the reduced temperature, reduced pressure, and calculated Z factor values over a range of pressures.

    Copyright:

    © All Rights Reserved
    Download as XLS, PDF, TXT or read online from Scribd
    Download as xls, pdf, or txt
    65 views2 pages

    Calculate Gas Compressibility Factor

    Uploaded by

    matteo2009
    The document describes how to calculate gas compressibility in Excel and provides an example macro function. It includes input parameters for a gas sample and shows the reduced temperature, reduced pressure, and calculated Z factor values over a range of pressures.

    Copyright:

    © All Rights Reserved
    Download as XLS, PDF, TXT or read online from Scribd
    Download as xls, pdf, or txt
    of 2

    Brought to you by Petroleum Goodies

    For more helpful tools and tips, please visit PetroGoodies.com


    Press Alt+F11 to see macro function

    Excel Function To Calculate Gas Compressibility

    Intermediate Calculation:
    Bottomhole Temperature, Rankine
    Pseudocritical Temperature, Tpc
    Pseudocritical Pressure, Ppc
    Reduced Temperature, Tr
    Reduced Pressure, Pr

    Results:
    P (psia)
    14.7
    434.8
    869.6
    1304.3
    1739.1
    2173.9
    2608.7
    3043.5
    3478.3
    3913.0
    4347.8
    4782.6
    5217.4
    5652.2
    6087.0
    6521.7
    6956.5
    7391.3
    7826.1
    8260.9
    8695.7
    9130.4
    9565.2
    10000.0

    Pr
    #VALUE!
    #VALUE!
    #VALUE!
    #VALUE!
    #VALUE!
    #VALUE!
    #VALUE!
    #VALUE!
    #VALUE!
    #VALUE!
    #VALUE!
    #VALUE!
    #VALUE!
    #VALUE!
    #VALUE!
    #VALUE!
    #VALUE!
    #VALUE!
    #VALUE!
    #VALUE!
    #VALUE!
    #VALUE!
    #VALUE!
    #VALUE!

    Z Factor
    #VALUE!
    #VALUE!
    #VALUE!
    #VALUE!
    #VALUE!
    #VALUE!
    #VALUE!
    #VALUE!
    #VALUE!
    #VALUE!
    #VALUE!
    #VALUE!
    #VALUE!
    #VALUE!
    #VALUE!
    #VALUE!
    #VALUE!
    #VALUE!
    #VALUE!
    #VALUE!
    #VALUE!
    #VALUE!
    #VALUE!
    #VALUE!

    0.7
    0
    0
    300

    759
    #VALUE!
    #VALUE!
    #VALUE!
    see table below

    Validation:
    Z Factor
    0.99920
    0.97802
    0.96040
    0.94788
    0.94093
    0.93972
    0.94405
    0.95341
    0.96718
    0.98467
    1.00522
    1.02829
    1.05340
    1.08016
    1.10826
    1.13745
    1.16753
    1.19832
    1.22970
    1.26156
    1.29379
    1.32634
    1.35913
    1.39211

    1.60000
    1.40000

    ZF
    Val

    1.20000
    1.00000
    Z Factor

    Input Gas Parameter:


    Gas Gravity (Air=1.0)
    Mole Percent CO2
    Mole Percent H2S
    Bottomhole Temperature, Deg F

    0.80000
    0.60000
    0.40000
    0.20000
    0.00000
    0.0

    200

    1.60000
    1.40000

    Z Factor
    Validation:

    1.20000

    Z Factor

    1.00000
    0.80000
    0.60000
    0.40000
    0.20000
    0.00000
    0.0

    2000.0

    4000.0

    6000.0

    Pressure (psia)

    8000.0

    10000.0 12000.0

    You might also like