1. #1
    Forum Member
    MichaelXYZ's Avatar
    Join Date
    Jan 2012
    Location
    San Diego
    Posts
    354

    Default Pump Pressure/FLR calculator spreadsheet

    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:
    Name:  screenshot.jpg
Views: 1067
Size:  54.8 KB
    Last edited by MichaelXYZ; 01-14-2013 at 01:54 AM.

  2. #2
    Forum Member
    MichaelXYZ's Avatar
    Join Date
    Jan 2012
    Location
    San Diego
    Posts
    354

    Default

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

  3. #3
    MembersZone Subscriber

    Join Date
    Sep 2006
    Location
    Northeast Coast
    Posts
    3,862

    Default

    Quote Originally Posted by MichaelXYZ View Post
    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.

  4. #4
    Forum Member
    MichaelXYZ's Avatar
    Join Date
    Jan 2012
    Location
    San Diego
    Posts
    354

    Default

    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.
    Last edited by MichaelXYZ; 02-01-2013 at 10:28 PM.

  5. #5
    MembersZone Subscriber

    Join Date
    Sep 2006
    Location
    Northeast Coast
    Posts
    3,862

    Default

    Quote Originally Posted by MichaelXYZ View Post
    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.

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Similar Threads

  1. Pump Pressure
    By Crompton in forum Emergency Vehicle Operations
    Replies: 4
    Last Post: 04-11-2011, 09:54 PM
  2. Pump Can vs. Pressure Water Can
    By Holdasquad in forum Firefighters Forum
    Replies: 20
    Last Post: 01-07-2010, 03:03 PM
  3. Pump discharge pressure
    By smokeatr2000 in forum The Engineer
    Replies: 16
    Last Post: 07-21-2006, 01:17 AM
  4. Pump Test spreadsheet
    By chiefwaterloofd in forum The Engineer
    Replies: 2
    Last Post: 03-17-2004, 06:42 AM
  5. Pump Pressure?
    By jerseyfire in forum Fireground Tactics
    Replies: 3
    Last Post: 05-19-2000, 03:59 PM

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts

Log in

Click here to log in or register