Excel calculation sheets for oil and gas processing

All aspects from Choke to storage tanks

Moderator: Production

Post Reply
yasserkassem
Junior member
Posts: 66
Joined: Mon Oct 28, 2019 11:10 pm
LinkedIn Profile: https://www.linkedin.com/in/yasser-gabr-22770899/

Excel calculation sheets for oil and gas processing

Post by yasserkassem »

Liquid hydrostatic head calculation, Tank hydrostatic head calculations

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

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

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

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

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

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


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

Hydrate prediction and inhibition


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

Calculation of Viscosity of crude oil and emulsion and different temperature


http://oilprocessing.net/data/documents ... e-oil.xlsx

Three phase separator calculation (sizing) -Different method


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

Three phase separator calculation (sizing)

Engineering data book method (GPSA)


http://oilprocessing.net/data/documents ... -GPSA.xlsx

Heat required for heating crude oil and emulsion


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



https://oilprocessing.net
https://oilprocessing.net/oil/index.php
http://www.oilprocessing.net/oil
Last edited by yasserkassem on Sat Feb 13, 2021 2:48 pm, edited 2 times in total.
Fundamentals of Oil and Gas Processing
Basics of Gas Field Processing
Basics of Corrosion in Oil and Gas Industry
https://oilprocessing.net
https://oilprocessing.net/oil/index.php
https://www.hurras.org/vb/
yasserkassem
Junior member
Posts: 66
Joined: Mon Oct 28, 2019 11:10 pm
LinkedIn Profile: https://www.linkedin.com/in/yasser-gabr-22770899/

Re: Excel calculation sheets for oil and gas processing

Post by yasserkassem »

Time required to drain a tank

http://oilprocessing.net/data/documents ... ation.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 ... thods.xlsx

Salt content in crude oil
ptb

Calculation of salt content in crude oil


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

Flow calculations using orifice
Orifice calculations
Orifice sizing

Gas metering
Liquid metering



http://oilprocessing.net/data/documents ... -yass.xlsx

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 ... ation.xlsx

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

http://oilprocessing.net/data/documents ... nd-MW.xlsx

Mass flow to volumetic flow and vice versa

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

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

Flare Heat radiation

http://oilprocessing.net/data/documents ... -gpsa.xlsx

Gas to equivalent bbls of oil

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


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

Gas
http://oilprocessing.net/data/documents ... g_Gas.xlsx

Liquid

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

Different methods for hydrate prediction

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

Horizontal tank volume calculation


http://oilprocessing.net/data/documents ... uging.xlsx
Fundamentals of Oil and Gas Processing
Basics of Gas Field Processing
Basics of Corrosion in Oil and Gas Industry
https://oilprocessing.net
https://oilprocessing.net/oil/index.php
https://www.hurras.org/vb/
yasserkassem
Junior member
Posts: 66
Joined: Mon Oct 28, 2019 11:10 pm
LinkedIn Profile: https://www.linkedin.com/in/yasser-gabr-22770899/

Re: Excel calculation sheets for oil and gas processing

Post by yasserkassem »

you are welcome for more oil and gas excel spread sheets

http://oilprocessing.net/oil/
Fundamentals of Oil and Gas Processing
Basics of Gas Field Processing
Basics of Corrosion in Oil and Gas Industry
https://oilprocessing.net
https://oilprocessing.net/oil/index.php
https://www.hurras.org/vb/
Post Reply