Excel Calculations

Flow Regime Map for Two-Phase Flow

noreply@blogger.com (Sam) — Sun, 05 Feb 2012 04:43:25 PST

This Excel spreadsheet plots a flow regime map for the two-phase flow of liquid and gas in horizontal and vertical pipes. Determining flow regime is important when calculating pressure drops and...

[[ This is a content summary only. Visit my website for full links, other content, and more! ]]

Natural Gas Viscosity with Carr, Kobayashi, and Burrows Correlation

noreply@blogger.com (Sam) — Sat, 21 Jan 2012 06:34:40 PST

This Excel spreadsheet uses the Carr, Kobayashi, and Burrows correlation to calculate the viscosity of natural gas. The correlation is valid for sweet and sour gas. The Carr, Kobayashi, and Burrows...

[[ This is a content summary only. Visit my website for full links, other content, and more! ]]

Water Hammer in Excel

noreply@blogger.com (Sam) — Fri, 30 Dec 2011 04:01:02 PST

This Excel spreadsheet will calculate the maximum pressure surge when the valve at the end of a pipeline is closed. When flow is suddenly stopped, flow inertia causes a pressure surge at the valve,...

[[ This is a content summary only. Visit my website for full links, other content, and more! ]]

Dynamic Liquid Flow Between Coupled Tanks

noreply@blogger.com (Sam) — Sat, 03 Dec 2011 09:17:06 PST

This Excel spreadsheet models the transient flow of liquid between two tanks connected by a pipe. Because of the momentum of the liquid, the height of liquid in each tank oscillates to an...

[[ This is a content summary only. Visit my website for full links, other content, and more! ]]

Darcy-Weisbach Equation for Liquid Velocity in a Pipe

noreply@blogger.com (Sam) — Fri, 02 Dec 2011 15:07:38 PST

This Excel spreadsheet uses the Darcy-Weisbach equation to calculate liquid velocity in a pipe. The Darcy-Weisbach equation describes the relationship between the pressure loss and liquid velocity...

[[ This is a content summary only. Visit my website for full links, other content, and more! ]]

TEMA Type E Heat Exchanger Design

noreply@blogger.com (Sam) — Thu, 01 Dec 2011 03:12:58 PST

This Excel spreadsheet helps you design a TEMA Type E heat exchanger. The spreadsheet uses the Bell-Delaware method to calculate the overall heat transfer coefficient and the shell-side pressure...

[[ This is a content summary only. Visit my website for full links, other content, and more! ]]

Temperature Dynamics of Heated Tanks Connected in Series

noreply@blogger.com (Sam) — Sat, 19 Nov 2011 10:58:39 PST

This Excel spreadsheet models the temperature dynamics of a feed stream heated in three tanks connected in series. Each tank has a heating coil at a fixed temperature, and it is assumed that each...

[[ This is a content summary only. Visit my website for full links, other content, and more! ]]

Double Pipe Heat Exchanger

noreply@blogger.com (Sam) — Wed, 16 Nov 2011 00:44:11 PST

This Excel spreadsheet helps you design a double pipe heat exchanger (also known as a concentric tube heat exchanger). Double pipe heat exchangers are often used in the chemical, food processing and...

[[ This is a content summary only. Visit my website for full links, other content, and more! ]]

Find Orifice Diameter for Specific Operating Parameters

noreply@blogger.com (Sam) — Sat, 12 Nov 2011 15:29:46 PST

These Excel spreadsheets will help you find the orifice size for an orifice flow meter, given various design parameters like the desired pressure drop, fluid properties etc. All the spreadsheets use...

[[ This is a content summary only. Visit my website for full links, other content, and more! ]]

Small-Bore Gas Orifice Meter Flow Calculator

noreply@blogger.com (Sam) — Mon, 07 Nov 2011 05:06:00 PST

This Excel spreadsheet calculates the flowrate from a small-bore gas orifice meter using the ASME MFC-14M-2001 standard. This calculator is valid for pipe diameters of less than 40 mm (other...

[[ This is a content summary only. Visit my website for full links, other content, and more! ]]

Small-Bore Liquid Orifice Flow Meter Calculator for Excel

noreply@blogger.com (Sam) — Mon, 07 Nov 2011 02:52:24 PST

This Excel spreadsheet calculates the liquid flowrate from a small-bore orifice meter using the equations defined in ASME MFC-14M-2001. The calculation is iterative, but the spreadsheet is...

[[ This is a content summary only. Visit my website for full links, other content, and more! ]]

Critical Oil Flowrate for Gas Coning

noreply@blogger.com (Sam) — Sat, 29 Oct 2011 13:27:09 PDT

This Excel spreadsheet uses the Mayer and Garder correlation to calculate the oil flowrate necessary to form a stable gas cone in an oil and gas reservoir. Gas coning references the tendency of gas...

[[ This is a content summary only. Visit my website for full links, other content, and more! ]]

Calculate Original Gas in Place with Excel

noreply@blogger.com (Sam) — Wed, 26 Oct 2011 11:34:51 PDT

This Excel spreadsheet calculates the Original Gas in Place with a p/z plot. Specifically, this spreadsheet fits the observed p/z data and cumulative gas product to the following...

[[ This is a content summary only. Visit my website for full links, other content, and more! ]]

Model a Gas Orifice Meter with Excel

noreply@blogger.com (Sam) — Tue, 25 Oct 2011 09:51:47 PDT

This Excel spreadsheet calculates the flowrate from the pressure drop across a gas orifice meter with the equations defined in ISO 5167. Orifice meters use the pressure loss across a constriction...

[[ This is a content summary only. Visit my website for full links, other content, and more! ]]

Size a Liquid Orifice Meter with ISO 5167 and Excel

noreply@blogger.com (Sam) — Thu, 20 Oct 2011 12:14:15 PDT

This Excel spreadsheet sizes a liquid orifice meter using the equations in ISO 5167. Orifice meters determine liquid flowrate by measuring the pressure difference across a constriction in a pipe. ...

[[ This is a content summary only. Visit my website for full links, other content, and more! ]]

Compressibility Factor Calculator for Excel

noreply@blogger.com (Sam) — Tue, 18 Oct 2011 13:08:38 PDT

This Excel spreadsheet calculates the compressibility factor for natural gas using the Dranchuk-Abou-Kassem correlation. Engineers need the compressibility factor to calculate natural gas flowrates...

[[ This is a content summary only. Visit my website for full links, other content, and more! ]]

Calculate Erosional Velocity with Excel

noreply@blogger.com (Sam) — Sat, 15 Oct 2011 04:01:17 PDT

This Excel spreadsheet helps you calculate erosional velocity in Excel. The offshore oil industry often requires the transport of liquid, gas and solids in long distance pipelines. This causes the...

[[ This is a content summary only. Visit my website for full links, other content, and more! ]]

Calculate Viscosity of Natural Gas with Excel

noreply@blogger.com (Sam) — Tue, 11 Oct 2011 11:59:27 PDT

This Excel spreadsheet will calculate the viscosity of natural gas. The spreadsheet uses the Lee, Gonzalez and Eakin correlation for the viscosity, and the CNGA (California Natural Gas Association)...

[[ This is a content summary only. Visit my website for full links, other content, and more! ]]

Calculate Bottom Hole Pressure with the Cullender and Smith Method

noreply@blogger.com (Sam) — Mon, 17 Oct 2011 06:57:58 PDT

This Excel spreadsheet employs the Cullender and Smith method to calculate Bottom Hole Pressure on a shallow, dry gas well. The bottom hole pressure is simply the pressure at the bottom of an...

[[ This is a content summary only. Visit my website for full links, other content, and more! ]]

Calculate Least Cost Pipe Diameter and Flow Velocity with Excel

noreply@blogger.com (Sam) — Sat, 01 Oct 2011 11:51:04 PDT

Generally, engineers choose pipe diameters and flow velocities which minimize the total cost of the pipeline over the whole pipeline lifecyle. The total cost is the sum of the capital costs and...

[[ This is a content summary only. Visit my website for full links, other content, and more! ]]

Calculate Water Content of Natural Gas with Excel

noreply@blogger.com (Sam) — Sat, 15 Oct 2011 04:15:03 PDT

This Excel spreadsheet calculates the equilibrium water content of natural gas. It uses a correlation derived from the McKetta-Wehe chart. Originally published in 1958, the McKetta-Wehe chart is...

[[ This is a content summary only. Visit my website for full links, other content, and more! ]]

Compressibility Factor for Natural Gas

noreply@blogger.com (Sam) — Thu, 29 Sep 2011 11:40:32 PDT

This Excel spreadsheet calculates the compressibility factor of natural gas using the Brill and Beggs correlation. Just enter the pressure, temperature, specific gravity and the mole fractions of N2,...

[[ This is a content summary only. Visit my website for full links, other content, and more! ]]

The Spitzglass Equation for Sizing Gas Pipelines

noreply@blogger.com (Sam) — Sat, 23 Jul 2011 06:23:52 PDT

Originally published in 1912, the Spitzglass Equation is used for sizing fuel gas pipes (although now it is superseded by better correlations). Two versions of the equation exist; one for low...

[[ This is a content summary only. Visit my website for full links, other content, and more! ]]

Multicomponent Equilibrium Flash Calculation

noreply@blogger.com (Sam) — Mon, 18 Jul 2011 13:58:18 PDT

When a multicomponent liquid stream undergoes a sudden decrease in pressure (by, for example, flowing through a valve), part of the feed vaporizes. The vapor product is richer in the more volatile...

[[ This is a content summary only. Visit my website for full links, other content, and more! ]]

Corrected Log Mean Temperature Difference for Shell-and-Tube Heat Exchangers

noreply@blogger.com (Sam) — Mon, 27 Jun 2011 19:04:00 PDT

This Excel spreadsheet calculates the corrected LMTD for shell-and-tube heat exchangers with multiple shell-side passes. True log mean temperature differences are only valid in double-pipe (or...

[[ This is a content summary only. Visit my website for full links, other content, and more! ]]