Tuesday, January 14, 2014

Calculation of required pipe diameter for pipe flow

This Excel templates the required pipe diameter for a pipe flow using Darcy Weisbach friction factor equation. Parameters required for this template are allowable head loss, pipe roughness, pipe length, pipe flow rate, fluid density, fluid viscosity, and assumed pipe diameter. Parameters calculated are pipe diameter, friction factor, cross-sectional area, average velocity, Reynolds number, and transition region friction factor.

http://spreadsheetzone.com/1119/Calculation-of-required-pipe-diameter-for-pipe-flow.html
 

Calculation of frictional head loss or pressure drop for pipe flow

This Excel template calculates friction head loss or pressure drop for a pipe flow using Darcy Weisbach friction factor equation. Parameters required for this template are allowable pipe diameter, pipe roughness, pipe length, pipe flow rate, fluid density, and fluid viscosity. Parameters calculated are pipe diameter, friction factor, cross-sectional area, average velocity, Reynolds number, transition region friction factor, frictional head loss, frictional pressure drop, and frictional pressure drop.

http://spreadsheetzone.com/1118/Calculation-of-frictional-head-loss-or-pressure-drop-for-pipe-flow.html
 

Friday, September 27, 2013

Planetary Motion

This template is prepared for calculating the planetary motion variables using Kepler's Third Law. SpreadsheetWEB version provides all features of the template online.

Temperature Conversion

This template is prepared for carrying out Celcius-to-Fahrenheit and Fahrenheit-to-Celcius conversions. The conversion is displayed on a chart and a table. SpreadsheetWEB version of the calculator provides all features of the template and it may be placed and used online.

Universal Gravitation and Escape Velocity

Universal Gravitation and Escape Velocity This template is prepared for calculating the force of gravity, acceralation due to gravity and escape velocity for a spesific central object using Newton's universal gravitation law. There are two charts showing the behaviours of force of gravity and escape velocity with respect to position. SpreadsheetWEB version provides all features of the template online.

Projectile Motion

This template is prepared for simulating and comparing projectile motion with and without air resistance.

Euler Method in Falling Velocity

This template is prepared for simulating the success of Euler approximation for the velocity in free fall. Parameters like the mass of the object play a very important role in the success of the method. Error of the method with different parameters can be observed.