# Excel Calculations Blog Posts

- Velocity Profile in a Circular PipeThis 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... [[ This is a content summary only. Visit my webs...
- Velocity Profile in a Circular PipeThis 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... [[ This is a content summary only. Visit my website for f...
- Liquid Volume in Partially Filled Horizontal TanksThis 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... [[ This is a content summary only. Visit my websit...
- Calculate Gas Viscosity with Sutherland's LawThis 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... [[ This is a content summary only. Visit my website...
- Calculate Gas Viscosity with Sutherland's LawThis 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... [[ This is a content summary only. Visit my websi...
- Historical Crude Oil PricesThese 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... [[ This is a content summary only. Visit my website...
- Historical Crude Oil PricesThese 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... [[ This is a content summary only. Visit my we...
- Heat Loss From An Insulated PipeThis 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... [[ This is a content summary only. Visit my website...
- Heat Loss From An Insulated PipeThis 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... [[ This is a content summary only. Visit my website for f...
- Calculate d-Exponent to Predict Pore Pressure TrendsThis 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... [[ This is a content summary only. Visit my webs...
- Calculate d-Exponent to Predict Pore Pressure TrendsThis 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... [[ This is a content summary only. Visit my website for...
- Modelling Reaction Kinetics in ExcelThis 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... [[ This is a content summary only. Visit my websit...
- Modelling Reaction Kinetics in ExcelThis 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... [[ This is a content summary only. Visit my website fo...
- Binary Distillation with McCabe-Thiele MethodThis 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... [[ This is a content summary only. Visit my website...
- Critical Oil Flowrate for Gas Coningon Oct 16, 2012 in gas coning excelThis 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... [[ This is a content summary only. Visit my websit...
- Fetkovich Decline Curve AnalysisThis 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... [[ This is a content summary only. Visit my website for full links...
- Small-Bore Gas Orifice Meter Flow CalculatorThis 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...
- Dynamic Liquid Flow Between Coupled Tankson Oct 16, 2012 in momentum balance mass balance liquid flow fluid dynamics friction excel euler Haaland finite differenceThis 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 web...
- Double Pipe Heat Exchangeron Oct 16, 2012 in double pipe heat exchanger heat transfer Goal Seek excel concentric tube heat exchangerThis 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... [[ This is a content summary only. Visit my website...
- Darcy-Weisbach Equation for Liquid Velocity in a PipeThis 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... [[ This is a content summary only. Visit my website for...