The sample calculations, equations and spreadsheets presented herein were developed using examples published in the Engineering Data Book as published by GPSA as a service to the gas processing industry. All information and calculation formulae has been compiled and edited in cooperation with the GPA Midstream Association.
While every effort has been made to present accurate and reliable technical information and calculation spreadsheets based on the GPSA Engineering Data Book sample calculations, the use of such information is voluntary and GPA Midstream and GPSA do not guarantee the accuracy, completeness, efficacy or timeliness of such information. Reference herein to any specific commercial product, calculation method, process, or service by trade-name, trademark, and service mark manufacturer or otherwise does not constitute or imply endorsement, recommendation or favoring by GPA Midstream and/or GPSA.
The Calculation Spreadsheets are provided without warranty of any kind including warranties of accuracy or reasonableness of factual or scientific assumptions, studies or conclusions, or merchantability, fitness for a particular purpose or non-infringement of intellectual property. In no event will the GPA Midstream or GPSA and their members be liable for any damages whatsoever (including without limitation, those resulting from lost profits, lost data or business interruption) arising from the use, inability to, reference to or reliance on the information in thes Publication, whether based on warranty, contract, tort or any other legal theory and whether or not advised of the possibility of such damages.
These calculation spreadsheets are provided to provide an “Operational level” of accuracy calculation based on rather broad assumptions (including but not limited to; temperatures, pressures, compositions, imperial curves, site conditions etc) and do not replace detailed and accurate Design Engineering taking into account actual process conditions, fluid properties, equipment condition or fowling and actual control set-point dead-band limitations.
For questions about using the spreadsheets, contact Jerry Gump or Dr. Juan Manzano-Ruiz:
Jerry Gump, PE
Director of Pipeline Engineering
Audubon Field Solutions
Office: (918) 514-5820
Juan J. Manzano-Ruiz, Ph.D., P.E.
Flow Assurance Manager
Office: (713) 235-2320
|Spreadsheets for the 13th edition of the GPSA Engineering Data Book|
|Section 3 - Measurements (.xlsx)|
|Section 5 - Relief Systems (.xlsx)|
|Section 6 - Storage (.xlsx)|
|Section 7 - Separation Equipment (.xlsx)|
|Section 8 - Fired Equipment (.xlsx)|
|Section 9 - Heat Exchangers (.xlsx)|
|Section 10 - Air Cooled Heat Exchangers (.xlsx)|
|Section 11 - Cooling Towers (.xlsx)|
|Section 12 - Pumps (.xlsx)|
|Section 13 - Compressors and Expanders (.xlsx)|
|Section 14 - Refrigeration (.xlsx)|
|Section 15 - Prime Movers (.xlsx)|
|Section 16 - Hydrocarbon Recovery (.xlsx)|
|Section 17 - Fluid Flow and Piping (.xlsx)|
|Section 18 - Utilities (.xlsx)|
|Section 19 - Fractionation and Absorption (.xlsx)|
|Section 20 - Dehydration (.xlsx)|
|Section 21 - Hydrocarbon Treating (.xlsx)|
|Section 22 - Sulfur Recovery (.xlsx)|
|Section 23 - Physical Properties (.xlsx)|
|Section 25 - Equilibrium Ration (K) Data (.xlsx)|