# 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.