Free Educational Spreadsheets from SpreadsheetZONE
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.
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.
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.
Subscribe to:
Posts (Atom)