Pump Pressure/FLR calculator spreadsheet

[MichaelXYZ]

Greetings, after seeing all the request for pump charts, I thought I would give excel a try. So I have attached a excel spreadsheet Pump pressure friction loss calculator for you to test drive, and hopefully help me work the kinks out I saved the file in excel 2003 .xls format to be compatible with older versions.
I added instructions in the spreadsheet, you should only have to enter in the blue or one orange cells.
I used the 2Q square method. You may edit the correction factors in the green cells to match your departments numbers.
Let me know if you like it or find it helpful, and any suggestions. Negative comments do not help in the exchange of stuff like this.

Avoid editing cells shaded in Red or Yellow or you may cause the formulas to not work, unless you understand nested IF functions.

I uploaded the file so no need to message me for it...

PPFLRcalc.zip

Screenshot:

[MichaelXYZ]

Well I hope some found this useful, stay safe...

[RFDACM02]

Well I hope some found this useful, stay safe...

Just saw this and downloaded it. i'll check it out myself, but I know I like the idea. We've used excel sheets for pump charts and formula's int eh past, but nothing that fancy looking. I like being able to put in our numbers as we use the coefficient formulas for charts.

[MichaelXYZ]

Let me know if you have any questions or need me to tweak the coefficient values for you.
The bottom row gives friction loss for hose 100 to 500 feet incrementally based on the values you input above. This can be used to make charts.

[RFDACM02]

Let me know if you have any questions or need me to tweak the coefficient values for you.
The bottom row gives friction loss for hose 100 to 500 feet incrementally based on the values you input above. This can be used to make charts.

Thanks, I used some of your Excel formulas to make a seperate tab and sheet using the cQ*Q formula so that we might in the furutre determine our own coeffieceint for the hose we use. Your sheet works well as far as I can tell.