tag:blogger.com,1999:blog-52486131239243361742026-06-01T06:33:10.640-07:00Free Chemical and Petroleum Engineering SpreadsheetsUnknownnoreply@blogger.comBlogger49125tag:blogger.com,1999:blog-5248613123924336174.post-41764708905064930342013-08-05T16:42:00.001-07:002013-08-05T17:24:28.822-07:00

This Excel spreadsheet calculates and plots the velocity profile of a power-law fluid in a circular pipe. The spreadsheet is valid for Newtonian, pseudoplastic and dilatant fluids. The velocity profile of a Power-law fluid is given by this equation. where r is the radial position i.e. distance from the center line (m) R is the pipe radius (m) u(r) is the axial velocity (m s-1) dp/dz is

Unknownnoreply@blogger.com0tag:blogger.com,1999:blog-5248613123924336174.post-14541947337143935642013-02-20T18:00:00.002-08:002013-02-20T18:08:48.169-08:00

This Excel spreadsheet calculates the viscosity of gasses with Sutherland's Law. The spreadsheet contains constants suitable for air, but can be used for other gases. William Sutherland was an Australian scientist who studied the temperature-dependence of ideal gases. In 1893, he developed an empirical-theoretical relationship between the temperature and viscosity of an ideal gas.

Unknownnoreply@blogger.com0tag:blogger.com,1999:blog-5248613123924336174.post-14359970074634180582013-02-18T15:27:00.000-08:002013-02-18T15:27:31.710-08:00

These two Excel spreadsheets automatically download historical crude oil prices straight into Excel. Both tools are fully automated; the most you do is supply dates and click a button. Some VBA then downloads the data from a 3rd party website, straight into Excel. After the data is in Excel, you can do whatever you want - visualize price historical, perform economic analysis, correlate oil

Unknownnoreply@blogger.com0tag:blogger.com,1999:blog-5248613123924336174.post-9721904742414866362012-12-16T15:42:00.000-08:002012-12-16T15:42:04.516-08:00

This Excel spreadsheet models heat loss from an insulated pipe. This is a very common system in the process industries - insulated pipes are everywhere, and engineers need a sound grasp of heat transfer principles to model their effects. Although the model in the spreadsheet is simplified to aid understanding, complexity can be easily added. Liquid flows through the pipe, with heat

Unknownnoreply@blogger.com2tag:blogger.com,1999:blog-5248613123924336174.post-57350833801001284462012-12-08T09:32:00.000-08:002012-12-08T09:32:06.193-08:00

This Excel spreadsheet calculates the d-exponent, a parameter used by drilling engineers to investigate ppore pressure trends when drilling into over-pressurized zones. Normally, formation density increases with the drilling depth. But if the formation contains sand below the surface, then the drilling rate may increases with drilling depth. The d-exponent is used in several calculations to

Unknownnoreply@blogger.com0tag:blogger.com,1999:blog-5248613123924336174.post-35824301975807213612012-11-21T18:45:00.001-08:002012-11-21T18:45:05.292-08:00

This spreadsheet demonstrates how you can model reaction kinetics in Excel with the solution of differential equations. Consider this reaction scheme where A and B are reactants, X and Y are catalysts, and k1 and k2 are rate constants. The following coupled differential equations can be derived from the stoichiometry of the chemical reaction scheme. where a(t), b(t), x(t) and y(t) are

Unknownnoreply@blogger.com2tag:blogger.com,1999:blog-5248613123924336174.post-60324269796867536912012-10-14T10:36:00.003-07:002012-10-14T10:52:21.425-07:00

This Excel spreadsheet calculates the maximum allowable vapor velocity in a vapor-liquid separator with the Souders-Brown equation. The Souders-Brown equation is commonly used to size separators, scrubbers and knock-out drums. The operating vapor velocity is specified to minimize the entrainment of liquid drops in the exiting vapor. A wire mesh or de-entrainment pad is commonly used to

Unknownnoreply@blogger.com0tag:blogger.com,1999:blog-5248613123924336174.post-1744794374720161852012-09-30T11:10:00.000-07:002012-09-30T11:10:27.559-07:00

This Excel spreadsheet calculates the Inflow Performance Relationship, or IPR, for vertical and slanted solution-gas drive wells. The IPR of a well determines the relationship between its flowing bottom pressure, and the well production rate (or deliverability). IPR also helps engineers investigate the economics of a well, and is critical in optimizing the well, artificial lift design

Unknownnoreply@blogger.com0tag:blogger.com,1999:blog-5248613123924336174.post-80867333503862128342012-09-30T08:11:00.002-07:002013-12-28T18:42:35.401-08:00

This Excel spreadsheet helps you calculate the pressure drop through packed and fluidizeds bed with the Ergun equation. Fluidized beds are a commonly unit operation in the process industries. Their nature makes them particularly suitable venues for gas-solid catalyzed reaction, often in the petroleum industry to produce gasoline and other chenicals. They have also found use in the polymer

Unknownnoreply@blogger.com0tag:blogger.com,1999:blog-5248613123924336174.post-78049964035760992232012-09-09T04:43:00.000-07:002013-06-05T18:32:01.406-07:00

This Excel spreadsheet helps you calculate the liquid volume in partially filled horizontal tanks. Tanks are often used in storing chemicals. Often, only the liquid height from a level indicator is known. This means you need a method of calculating the liquid volume based on the liquid height and the tank dimensions. The tank ends can be flat (so the tank is just a horizontal cylinder)#

Unknownnoreply@blogger.com1tag:blogger.com,1999:blog-5248613123924336174.post-67884967677352728262012-07-07T06:21:00.005-07:002012-10-16T02:18:57.589-07:00

This Excel spreadsheet plots Fetkovich decline curves for gas wells. Decline curve analysis is an empirical procedure that predicts the decline in production rates of gas and oil wells.  Fetkovich (1968) improved on earlier work by Arps in predicting the declining production rate of oil and gas wells. He suggested that experimental production rate data could be overlaid on a graph and

Unknownnoreply@blogger.com1tag:blogger.com,1999:blog-5248613123924336174.post-26586987933290780962012-05-30T11:54:00.000-07:002012-05-30T11:54:00.417-07:00

Consider an oil reservoir with an underlying water zone. An oil well that is producing from this reservoir will experience the phenomenon of water breakthrough if the well produces above its critical rate. Since economic considerations often demand high flowrates, this can be a real risk. This Excel spreadsheet uses the Sobocinski-Cornelius method to calculate the water breakthrough time. &

Unknownnoreply@blogger.com0tag:blogger.com,1999:blog-5248613123924336174.post-75085174083898556082012-05-13T04:49:00.002-07:002012-10-16T02:14:11.554-07:00

This Excel spreadsheet uses the McCabe-Thiele method to calculate the number of theoretical stages needed for binary distillation. Binary distillation is a common unit operation that separates two liquids (with one being more volatile, or "lighter"). The concepts are encountered in many branches of chemical and petroleum engineering. Simply enter your parameters at the top of the spreadsheet

Unknownnoreply@blogger.com0tag:blogger.com,1999:blog-5248613123924336174.post-72001345401112543352012-02-05T04:41:00.000-08:002012-02-05T04:43:25.705-08:00

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 pumping requirements in the oil & gas industry, and chemical production. Additionally, some flow regimes are undesirable (such as slug flow, which can damage pipes through excessive vibration)

Unknownnoreply@blogger.com1tag:blogger.com,1999:blog-5248613123924336174.post-1783494568250411032012-01-21T05:09:00.000-08:002012-01-21T06:34:40.230-08:00

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 correlation was published in 1954. It is valid between temperatures of 32 F to 400 F, reduced pressures below 20, and CO2, N2 and H2S concentrations below 15%. The correlation was originally

Unknownnoreply@blogger.com0tag:blogger.com,1999:blog-5248613123924336174.post-83294462580340954812011-12-30T04:00:00.000-08:002011-12-30T04:01:02.652-08:00

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, with a shockwave propagating through the pipeline.  This  is also known as Water Hammer and can cause considerable damage.  Engineers need to know the maximum pressure surge to

Unknownnoreply@blogger.com0tag:blogger.com,1999:blog-5248613123924336174.post-34428999264382834572011-12-03T07:42:00.003-08:002012-10-16T15:24:18.663-07:00

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 equilibrium.  Flow is opposed by pipe friction, and eventually the liquid level in each tank stabilises. The dynamics are defined by the following differential equations, which are derived

Unknownnoreply@blogger.com0tag:blogger.com,1999:blog-5248613123924336174.post-49303009812943158722011-12-02T14:08:00.001-08:002012-10-16T15:32:21.319-07:00

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 in a pipe. This is the equation employed in the spreadsheet. ΔP is the pressure loss in the pipe (Pa) ρ is the liquid density (kg m-3) μ is the liquid viscosity (Pa s) g is the gravitational

Unknownnoreply@blogger.com0tag:blogger.com,1999:blog-5248613123924336174.post-18156470172563000672011-11-30T14:44:00.001-08:002011-12-01T03:12:58.353-08:00

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 drop. TEMA Type E heat exchangers are the basis of many other designs. They offer a single pass, with liquid entry and exist on opposing sides of the shell The spreadsheet allows you to pick from a

Unknownnoreply@blogger.com0tag:blogger.com,1999:blog-5248613123924336174.post-42374494213964030422011-11-19T09:21:00.001-08:002011-11-19T10:58:39.698-08:00

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 tank is perfectly mixed The temperature dynamics are modeled by these three differential equations. M is the mass of liquid in each tank (kg) T0 is the temperature of the feed stream (K) T1(

Unknownnoreply@blogger.com0tag:blogger.com,1999:blog-5248613123924336174.post-14311158916244787092011-11-16T00:31:00.000-08:002012-10-16T15:26:28.752-07:00

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 oil & gas industries. They have a particular advantage when close temperature approaches are needed or in high pressure applications. The spreadsheet will give you important design parameters,

Unknownnoreply@blogger.com6tag:blogger.com,1999:blog-5248613123924336174.post-90489359882594720622011-11-12T14:49:00.000-08:002011-11-12T15:29:46.479-08:00

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 industry-standard designs, such as ISO 5167 and ASME MFC-14M-2001 First, decide what type of orifice you're designing and download the appropriate Excel Spreadsheet (read the articles for

Unknownnoreply@blogger.com0tag:blogger.com,1999:blog-5248613123924336174.post-68468054002223689112011-11-07T05:06:00.000-08:002012-10-16T15:25:39.527-07:00

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 restrictions are given below). The equations are as follows C is the discharge coefficient. D1 has to be supplied in m D1 and D2 are the diameter of the pipe and

Unknownnoreply@blogger.com0tag:blogger.com,1999:blog-5248613123924336174.post-83089697386743205382011-11-03T03:54:00.000-07:002011-11-07T02:52:24.242-08:00

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 conveniently set up to use Excel's Goal Seek functionality by simply clicking a button. The equations implemented in the spreadsheet are sourced from ASME MFC-14M-2001 and are given below.

Unknownnoreply@blogger.com0tag:blogger.com,1999:blog-5248613123924336174.post-84521103103764832082011-10-29T13:17:00.000-07:002012-10-16T02:24:39.467-07:00

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 to flow in the direction in which its face the least resistance, against the flow of gravity.  Above the critical oil flowrate, the cone will breakthrough and gas will force the oil flow

Unknownnoreply@blogger.com0