Download Crane Fluid Flow Examples in MS Excel 1.11

8 Votes
fluid flow crane tp410 examples calculations excel

Includes various examples from Crane's Technical Paper Number 410, "Flow of Fluids" worked out in detail in MS Excel. Also includes pipe charts, water densities, steam tables, and friction factor charts and discussions.Example problems range from relatively simply to fairly complex. Extremely helpful for gaining an understanding of basic fluid flow problems and variable sensitivity.

Additional Contributions from: clarenceyue

What's New in Version 1.11 (See full changelog)

Minor tweak to VBA code to try to eliminate errors that some are seeing with Office 2003 and prior.

Disclaimer: All software provided "As-Is" with no warranty, expressed or implied, available. See our Terms of Use for more information.

hetzelef

Feb 23 2012 09:36 AM

I'm getting a compile error, "Can't find project or library" with the A1 highlighted in Module1:

' The darcy friction factor, fd, is calculated using Chen's method (1991)
A1

Chris Haslego

Feb 23 2012 02:40 PM

'hetzelef', on 23 Feb 2012 - 2:46 PM, said:

I'm getting a compile error, "Can't find project or library" with the A1 highlighted in Module1:' The darcy friction factor, fd, is calculated using Chen's method (1991)A1

Check a couple of things:

1. Be sure that macros are enabled
2. If you're using a newer version of Excel, click on the Open Start button -> Excel Options->Trust Center->Trusted Locations. Make sure that the spreadsheet is saved to a trusted location on your computer before opening.

nactav

Mar 09 2012 01:36 PM

I'i've done what you've said, but I'm still getting the compile error

Chris Haslego

Mar 09 2012 09:53 PM

'nactav', on 09 Mar 2012 - 6:46 PM, said:

I'i've done what you've said, but I'm still getting the compile error

Do you have Solver installed in your version of Excel?

guillermolineroa

Mar 12 2012 12:08 AM

Hi all,

I'm Venezuelan, but I will write in English because I see that basically all written in English except for some post.

When I try to open the document, I get the same error as described hetzelf, I use Office 2003. I have enable macros. and the document is saved in "My Documents" on the computer I'm using, also I have installed the Solver.

Grateful beforehand.

Guillermo Linero

Chris Haslego

Mar 20 2012 12:22 PM

If anyone else is having this issue, try to access the VBA code and find "Module1". Try commenting out this code or deleting it altogether. Save the VBA project. Save the spreadsheet, and then try to reopen. Obviously the calculation tied to this code won't work any longer, but it may stop the error from occurring.