Group of Excel sheets for Oil and Gas Calculations

edited October 29 in Oil & Gas (Upstream)

Liquid hydrostatic head calculation, Tank hydrostatic head calculations

http://oilprocessing.net/data/documents/Hydrostatic-head-calc.xlsx

Liquid and gas retention time in separators
Liquid retention time
Gas retention time

http://oilprocessing.net/data/documents/Liquid-and-gas-retention-time.-Gas-velocity.xlsx

Liquid and-gas velocity in pipes
Gas compressibility factor
Reynolds number

http://oilprocessing.net/data/documents/Liquid-and-gas-velocity-gas-compressibility-and-renolds-number..xlsx

Liquid pressure drop in pipes
Pressure drop using Hazen–Williams equation
Darcy-Weisbach eqn. ( most accurate)

http://oilprocessing.net/data/documents/Liquid-pressure-drop.xlsx

Hydrate prediction and inhibition

http://oilprocessing.net/data/documents/Methanol_glycol_yass.xlsx

Calculation of Viscosity of crude oil and emulsion and different temperature

http://oilprocessing.net/data/documents/Viscosity-of-crude-oil.xlsx

Three phase separator calculation (sizing) -Different method

http://oilprocessing.net/data/documents/Three-phase-separator.xlsx

Three phase separator calculation (sizing)

Engineering data book method (GPSA)

http://oilprocessing.net/data/documents/Three-phase-separator-GPSA.xlsx

Heat required for heating crude oil and emulsion

http://oilprocessing.net/data/documents/heat-required.xlsx

Time required to drain a tank

http://oilprocessing.net/data/documents/Drain-a-Tank-Calculation.xlsx

Two phase separator sizing
Two phase separator calculation

Two phase separator design

GPSA -Gas Processing Suppliers Association
API - American Petroleum Institute

Surface production facilities

http://oilprocessing.net/data/documents/2-phase-sep-different-methods.xlsx

Salt content in crude oil
ptb

Calculation of salt content in crude oil

http://oilprocessing.net/data/documents/salt-contentBtb.xlsx

Flow calculations using orifice
Orifice calculations
Orifice sizing

Gas metering
Liquid metering

[url]http://oilprocessing.net/data/documents/orifice-yass.xlsx[/url]

Different methods to calculate gas pressure drops in pipes
or gas rate in case of know pressure drop and piping data

http://oilprocessing.net/data/documents/Gas-pressure-drop-and-gas-rate-calculation.xlsx

Gas Molecular weight
Gas properties at different temperature and pressure
Gas volume
Gas heating value
Compressibility factor

http://oilprocessing.net/data/documents/Gas-volume-heating-valuecompres.-and-MW.xlsx

Mass flow to volumetic flow and vice versa

http://oilprocessing.net/data/documents/MAss-flow-to-volumetric-flow-and-vice-versa.xlsx

Pipe capacity - pipe weight - pipe contradiction
http://oilprocessing.net/data/documents/Pipe-capacity-pipe-weight-contradiction.xlsx

Flare Heat radiation

http://oilprocessing.net/data/documents/Flare-heat-radiation-gpsa.xlsx

Gas to equivalent bbls of oil

http://oilprocessing.net/data/documents/Equivalent-oil-calculation.xlsx

Liquid and gas - simple - rule of thumps
http://oilprocessing.net/data/documents/Control-valve-simple-liquid-and-gas.xlsx

Gas
http://oilprocessing.net/data/documents/Control-valve-sizing_Gas.xlsx

Liquid

http://oilprocessing.net/data/documents/Control-valve-sizing_Liquid_simple.xlsx

Different methods for hydrate prediction

http://oilprocessing.net/data/documents/Hydrate_pred_yass.xlsx

Horizontal tank volume calculation

http://oilprocessing.net/data/documents/Horizontal-tank-gauging.xlsx


For more
http://www.oilprocessing.net/oil/index.php

My books
Fundamentals of Oil and Gas Processing Book
Basics of Gas Field Processing Book
Prediction and Inhibition of Gas Hydrates Book
Basics of Corrosion in Oil and Gas Industry Book
https://www.amazon.com/Yasser-Kassem/e/B07KXLM5RZ?ref=dbs_a_mng_rwt_scns_share

Comments

Sign In or Register to comment.