Jump to content

Featured Articles

Check out the latest featured articles.

File Library

Check out the latest downloads available in the File Library.

New Article

Product Viscosity vs. Shear

Featured File

Vertical Tank Selection

New Blog Entry

Low Flow in Pipes- posted in Ankur's blog


Group Of Excel Sheets For Oil And Gas Calculations

4 replies to this topic
Share this topic:
| More

#1 Yasserkassem


    Junior Member

  • Members
  • 22 posts

Posted 30 October 2019 - 07:51 AM

Liquid hydrostatic head calculation, Tank hydrostatic head calculations
Liquid and gas retention time in separators
Liquid retention time
Gas retention time
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)
Hydrate prediction and inhibition
Calculation of Viscosity of crude oil and emulsion and different temperature 
Three phase separator calculation (sizing) -Different method
Three phase separator calculation (sizing)
Engineering data book method (GPSA)
Heat required for heating crude oil and emulsion 
Time required to drain a tank
Two phase separator sizing
Two phase separator calculation
Two phase separator design
GPSA -Gas Processing Suppliers Association
API - American Petroleum Institute
Surface production facilities
Salt content in crude oil 
Calculation of salt content in crude oil 
Flow calculations using orifice
Orifice calculations
Orifice sizing
Gas metering
Liquid metering
Different methods to calculate gas pressure drops in pipes
or gas rate in case of know pressure drop and piping data 
Gas Molecular weight 
Gas properties at different temperature and pressure 
Gas volume
Gas heating value 
Compressibility factor
Mass flow to volumetic flow and vice versa
Pipe capacity - pipe weight - pipe contradiction
Flare Heat radiation
Gas to equivalent bbls of oil 
Liquid and gas   - simple - rule of thumps
Different methods for hydrate prediction 
Horizontal tank volume calculation 

Edited by Yasserkassem, 30 October 2019 - 07:54 AM.

#2 Yasserkassem


    Junior Member

  • Members
  • 22 posts

Posted 27 December 2019 - 02:29 AM

Thank you for viewing the post, and downloading the excel sheets.
Other excel sheets will be added soon.

Best regards

#3 Yasserkassem


    Junior Member

  • Members
  • 22 posts

Posted 07 January 2020 - 09:25 AM

Water and steam pressure drop calculation


Two phase flow pressure drop - API equation

Gas pressure drop calculation

Liquid pressure drop- oil pressure drop calculation

Two phase flow - AGA equation

#4 ashetty


    Gold Member

  • Members
  • 98 posts

Posted 01 September 2020 - 02:52 AM

Thanks for the upload Yasserkassem.


Best Regards.

#5 Yasserkassem


    Junior Member

  • Members
  • 22 posts

Posted 20 December 2020 - 01:55 AM

You are welcome

Other books and excel calculation spread sheets are available here:


Edited by Yasserkassem, 13 February 2021 - 08:16 AM.

Similar Topics