AirFlow
 

This Excel calculation can be downloaded by ExcelCalcs subscribers.Please login or Subscribe.

Description:
Calculation Preview




 Calculates the Moody friction factor and then the head loss and pressure drop per classic equations.  

 Enter temperature, pressure, pipe diameter, and PPS, lbs per second flow rates, has mass to volume relationships.  

Uses VBA for an iterative solution to the friction factor, twice, once in a subroutine with button click and then ported to function for excel auto updating.

In English units with Metric conversion for verification, and various references on separate sheets.  Note the interpolation routine in the viscosity pages, this isn't mine but is very nice, note also this workbook uses named cells, useful and clear.  

Calculation Reference
Air Flow Calculations
| Find on Amazon.com | Find on Amazon.co.uk | Find on Amazon.fr | Find on Amazon.de | Find on Amazon.ca |
Moody Friction Factor
| Find on Amazon.com | Find on Amazon.co.uk | Find on Amazon.fr | Find on Amazon.de | Find on Amazon.ca |
Air Flow in Pipes
| Find on Amazon.com | Find on Amazon.co.uk | Find on Amazon.fr | Find on Amazon.de | Find on Amazon.ca |

Version History
Subscribe to this topic and get notified by mail about new posts Favorite to this topic Discuss this item in the forum. Check the version history to see how this calculation has changed over time. Use the Subscribe button to receive an automatic email should this calculation be updated to a higher version. Use the Favourite button so you can easily find this calculation in the future.

Submitted On:
17 Jun 2013
Submitted By:
remcodejong
File Date:
17 Jun 2013
File Author:
Remco deJong
File Version:
1.0
File Size:
286.31 Kb
File Type:
xlsm
Downloads:
63
Rating:
stars/0.gifTotal Votes:0
HTML Link:
Copy code below to your web page to create link to this page:
HTML Window:
Copy code below to your web page to create a dynamic window to this download:
Like This?:
View the profile of the person who submitted this calculation and see all their other calculations hosted at ExcelCalcs.
Need Help?:
Use the comment feature below to raise any questions relating to this download. The question will be automatically emailed the author and all users subscribing to this comment thread.

Comments  

 
#1 JohnDoyle 2013-06-17 06:58
I have extended your XLC Pro subscription by 3 months by way of thanks.
 

Please sign in or register to add a comment.

We have 12 guests and 42 members online
Contact Us
post/emailEmail (preferred method of contact)
telephone US +1 617 5008224
telephone EU +44 113 8152220
Our Feeds
Repository RSS. Forum RSS. User Comment RSS. News RSS.

 

 

Google Analytics Alternative