Group of Excel sheets for Oil and Gas Calculations
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
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
Thanks for taking the time to share these resources Yasser. I hope that people benefit from them.