Spreadsheet: 121128d1315857563-excel-2007-xy-scatter-chart-with-lines-sample
Sheet: Sheet1

Annual Fire Pump Test |  |  |  |  |  | Wolverine Fire Protection Co.
 |  |  |  |  |  | PO Box 219 / 8067 [NAME].
Project: |  |  |  |  |  | Mt. Morris, MI. 48458-0219
 |  |  |  |  |  | Phone:(810) 686-4630
 |  |  |  |  |  | Fax:(810) 686-0440
 |  |  |  |  |  | P.O. No: | -
Test Date: |  |  | Time: |  |  | WFPC Job No:
Owner Rep: |  |  |  |  |  | WFPC Rep:
Fire Pump Assembly Data:
Fire Pump |  |  |  |  | Fire Pump Controller
Pump Type |  |  |  |  | Controller Type
Rotation |  |  |  |  | Manufacturer
Manufacturer |  |  |  |  | Model No.
Model No. |  |  |  |  | Serial No.
Serial No. |  |  |  |  | Interupting Capacity
Rated Gpm |  | 1000 |  |  | Volt/Phase/Cycle
Rated Pressure \ 2.31 |  | 90 |  |  | Rated Hp.
Rated Churn Pressure |  | 110 |  |  | Start Method
Rated 150% Pressure |  | 65 |  |  | Start Pressure (psi)
Rated Rpm |  |  |  |  | Stop Pressure (psi)
Fire Pump Driver |  |  |  |  | Jockey Pump & Controller
Type |  |  |  |  | [NAME]
Manufacturer |  |  |  |  | Model No.
Model No. |  |  |  |  | Rated Hp.
Serial No. |  |  |  |  | [NAME]
Rated  Hp. |  |  |  |  | Model No.
Rated RPM |  |  |  |  | Serial No.
Service Factor |  |  |  |  | Volt/Phase/Cycle
Rated Amps |  |  |  |  | Start Pressure (psi)
Volt/Phase/Cycle |  |  |  |  | Stop Pressure (psi)
Fire Pump Test Data:
Test | Discharge Pressure (PSI) | Suction Pressure (PSI) | Net Pump Pressure (PSI) | [NAME] | Total Flow (GPM) | Speed (RPM) | Volts | Amps
 |  |  |  | Pitot Pressure (psi)
 |  |  |  | GPM/nozzle
 |  |  |  | 0 |  |  | 494 | 35
Churn | 150 | 50 | 100 | 0 | 0 | 3581 | 496 | 36
 |  |  |  | 0 |  |  | 495 | 36
 |  |  |  | 2 |  |  | 492 | 58
1 | 140 | 40 | 100 | 18 | 1000 | 3552 | 492 | 59
 |  |  |  | 376 |  |  | 493 | 57
 |  |  |  | 3 |  |  | 495 | 66
1.5 | 102 | 34 | 68 | 18 | 1500 | 3541 | 494 | 66
 |  |  |  | 376 |  |  | 494 | 64
Test Nozzles = 1-3/4" Underwriters Playpipe with 0.97 Coefficient
Remarks:
See [NAME] below.
Pump | Net | Total |  |  |  | Pump | Pressure | Flow
Test | Pump | Flow |  |  |  | Rated | [NAME] | Gpm
Points | Pressure | Gpm | Pump Test Curve Results |  |  | Points
Churn | 100 | 0 |  |  |  | Churn | 110 | 0
1 | 100 | 1000 | Pass |  |  | 1 | 90 | 1000
1.5 | 68 | 1500 | Pass |  |  | 1.5 | 65 | 1500
Fire Pump Performance Curve
 |  |  |  |  |  |  |  |  |  | My delimna is I need the point "+" to be lower than the SYSTEM PERFORMANCE line other wise it fails. Hopefully this is possible…
+ | System Demand |  | 1300 | GPM        @ | 124 | PSI | Pass | Pass
 |  |  | This (above) controls the "+" point's position
 | [NAME] to add/remove Churn Pressure Line and Churn Pass/Fail Cell
 | Check Box to remove System Demand Information | Check Box to add/remove System Demand information
 | Keep away from the goods!!!
 |  | Flow | 0 |  | Rated Curve | Test Curve
 |  | 0 |  | #N/A | 110 | 100
 |  | 1000 |  | 90 | 90 | 100
 |  | 1500 |  |  | 65 | 68 | 124 | 1300
 |  |  |  | 90
 |  |  |  |  | a | a | 1 | Pass
 | Stop It! |  |  | Pass | Pass | 1 | a | a
 |  |  | 1 | Difference | Run | D. (Y) | D. (X)
 |  |  |  | 10 | 1000 | 124 | 1300
 |  |  |  | 13 | 1.3
 |  |  |  | [NAME]
 |  |  |  | 137
 | Suction Supply
0 | 50 |  | 2 | Differnce | Run | D. (Y) | D. (X)
1000 | 40 |  |  | 38 | 500 | 124 | 1300
1500 | 34 |  |  | 14.61538461538462 | 0.3846153846153846
 |  |  |  | [NAME]
 |  |  |  | 125.3846153846154
 | System Performance
0 | 150
1000 | 140 |  |  |  |  |  | GPM | PSI
1500 | 102 |  |  |  |  |  | 1300 | 124