Spreadsheets

Generating spreadsheet is one of my favorite hobbies. Being dedicated to update, renew and complete my spreadsheet library, presently I have one of the most comprehensive collections of process engineering tools. This enable me to perform my job easier, faster and more effectively. Moreover, I can check the effect of input parameters on the final results and gain knowledge.

A list of spreadsheets along with their descriptions, main inputs and outputs is available here.

All spreadsheets have been designed so that inputs are entered in a correct sequence. All inputs and results are easily recognized by color coding (green: input, blue: text/not accessible, white: output). Iteration and data manipulation have been minimized by using macros which automatically run behind spreadsheet interface. All graphs and tables that are usually utilized to prepare input data or calculate the final results have been fed into the spreadsheets for the user convenience.

There are some samples made available in the following section for reference. The current view may not show the latest version of spreadsheet.

- Air Cooler Sizing (View)
- Salt Balance for Single Stage Desalter (View)
- Salt Balance for Two Stages Desalter (View)
- Salt Balance for Single Stage Desalter Using Upstream Vessel for Salt Removal (View)
- Flare Stack Sizing (View)
- Insulation Thickness for Stagnant Fluid (View)
- Reducer Resistance Coefficient Calculation (Concentric, Eccentric, Conical) (Download)
- Reduced Bore Valve Resistance Coefficient Calculation (Download)
- Pump Hydraulic Calculations (View)
- Three Phase Separator Sizing - Boot Design (View)
- Three Phase Separator Sizing - Boot & Weir Design (View)
- Three Phase Separator Sizing - Bucket & Pipe Design (View)
- Three Phase Separator Sizing - Bucket & Weir Design (View)
- Three Phase Separator Sizing - Double Weir Design Type 1 (View)
- Three Phase Separator Sizing - Double Weir Design Type 2 (View)
- Three Phase Separator Sizing - No Internal Design (View)
- Three Phase Separator Sizing - Overflow Weir Design (View)
- Three Phase Separator Sizing - Submerged Weir Design (View)
- Two Phase Flow Regime Calculator (View)
- Strainer Pressure Drop Calculation (Y, T & Basket Types) (View)
- Nitrogen Purging Requirement (Pressure, Vacuum & Continuous Purging) (View)
- Steam Management (View)
- PSV Sizing (Gas) (View)
- PSV Sizing (Liquid) (View)
- PSV Sizing (Steam) (View)
- PSV Sizing (Two Phase - HEM Method Numerical Solution) (View)
- PSV Sizing (Two Phase - Omega One Point Method) (View)
- PSV Sizing (Two Phase - Omega Two Points Method) (View)
- PSV Sizing (Supercritical Fluid - Fire Case) (View)
- PSV Sizing (Supercritical Fluid - Non fire Case) (View)
- PSV sizing (Non ideal Gases Z<0.8 or Z>1.1) (View)
- Filter Separator Sizing (View)
- Buffer Vessel Sizing (View)
- Two Phase Flow Regime Calculation (Download)
- Tube Rupture Relief Rate Calculation (Single Phase) (View)
- Tube Rupture Relief Rate Calculation (Two Phase - API Ap. D Method) (View)
- Tube Rupture Relief Rate Calculation (Two Phase - Omega Method) (View)
- Tank Normal Venting Requirement (API - 2000) (View)
- Tank Emergency Venting Requirement (API - 2000) (View)
- Tank Normal Venting Requirement (ISO - 28300) (View)
- Steam Tarp Load Calculation for Main Steam Header & Traced Process Line (View)
- Fire Relief Rate Calculation (Wetted and Unwetted Vessels) (View)
- Liquid Thermal Expansion Relief Rate Calculation (View)
- Heat Transfer Coefficient Calculation (Free and Forced Convection) (View)
- Blowdown Facilitator (View)
- Evaporation Pond Sizing (View)
- Plate Pack Sizing (View)
- Steam Condensate Pot Sizing (View)
- Vessel Draining Time (Gravity Flow) (View)
- Expansion Vessel Sizing (View)
- Pressure/ Vacuum Relief Valve Sizing for Atmospheric Tank (View)
- Fire Relief Rate Calculation for Wetted Vessels Using Sequential Flashing Method (Download)
- Storage Tank Sizing (View)
- Flare KOD Sizing (View)
- Control Valve Failure Relief Rate - Liquid Service (View)
- Control Valve Failure Relief Rate - Gas Service (View)
- Equivalent Length Calculation (View)
- Three Phase Separator Separator - Degassing Check (View)
- Liquid Thermal Expansion Calculation (View)
- Line Hydraulic Calculation (View)
   
All right reserved to Saeid Rahimi