Edited by Yasserkassem, 30 October 2019 - 07:54 AM.
| 
 | 
  
Group Of Excel Sheets For Oil And Gas Calculations
		 Started by Yasserkassem, Oct 30 2019 07:51 AM
	
	
	
		4 replies to this topic
	
		
Share this topic:
 
			
				
					
						
					
					#1
					
					
				
				
				
					
				
			
				
			
			
			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 
------------
			
				
					
						
					
					#2
					
					
				
				
				
					
				
			
				
			
			
			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
			
				
					
						
					
					#4
					
					
				
				
				
					
				
			
				
			
			
			Posted 01 September 2020 - 02:52 AM
Thanks for the upload Yasserkassem.
Best Regards.
			
				
					
						
					
					#5
					
					
				
				
				
					
				
			
				
			
			
			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
					
					https://oilprocessing.net/
https://www.oilprocessing.net/oil
Edited by Yasserkassem, 13 February 2021 - 08:16 AM.
Similar Topics
		
		
		
		
		
		
		 Real Or Ideal Cp/cv For Control Valve CalculationsStarted by Guest_sumwunrandom_* , 14 Oct 2025  | 
	
	
		
  | 
	
		
	 | 
	
||
		
		
		
		
		
		
		 Gas Hydrate Inhibition: Calculations For Meg/methanol InjectionStarted by Guest_PYG_* , 30 Sep 2019  | 
	
	
		
  | 
	
		
	 
	 | 
	
||
		
		
		
		
		
		
		 Wind Enhancement Factor In Kumana Kothari CalculationsStarted by Guest_rlepra_* , 01 Dec 2017  | 
	
	
		
  | 
	
		
	 
	 | 
	
||
		
			Carbon Bed Filter CalculationsStarted by Guest_kyayura_* , 25 Jul 2023  | 
	
	
		
  | 
	
		
	 | 
	
||
		
		
		
		
		
		
		 Iso 28300 Venting CalculationsStarted by Guest_Mikemak_* , 22 Feb 2024  | 
	
	
		
  | 
	
		
	 
	 | 
	

   FB





	