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

0

Group Of Excel Sheets For Oil And Gas Calculations


4 replies to this topic
Share this topic:
| More

#1 Yasserkassem

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 
ptb
 
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
 
Gas
 
Liquid
 
 
Different methods for hydrate prediction 
 
 
Horizontal tank volume calculation 
 
 
 
------------
 

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


#2 Yasserkassem

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

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

ashetty

    Gold Member

  • Members
  • 98 posts

Posted 01 September 2020 - 02:52 AM

Thanks for the upload Yasserkassem.

 

Best Regards.



#5 Yasserkassem

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:


https://oilprocessing.net/
https://www.oilprocessing.net/oil

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





Similar Topics