Bldg_651.xlsx

Instructions

Rename Tab Test Hydrant Input information in non-shaded areas only.

Conversions

3349.7564842212 0 0 0 0

(For multiple test information printed on one chart, color printer required)

&28Water Flow Test Record

AF Form 1027, Water Flow Test Record, Computer-Generated (Nov 2010)

Water Flow Test Chart 21 May, 2015 0 1272.9506326922756 2691.0635669995172 3035.675625937854 3349.7564842211918 60 50 20 10 0 0 0 0 0 0 0 0 20 10 0 0 0 0 0 0 0 0 20 10 0 0 0 0 0 0 0 0 20 10 0 0 0 0 0 0 0 0 20 10 0 Water Flow (gpm)

Pressure (psig)

Sheet1

Microsoft_Word_Document1.docx Guide to Automated Water Flow Test Record

Purpose: This program is designed to replace the out-dated AF Form 1027, Water Test Flow Record. It is built to provide the available gallons per minute from the water distribution system and provide a 5-test history of the flow data for identifying potential issues within the water distribution system. Used correctly, this program should contain one tab per hydrant for all hydrants within the organization jurisdiction of responsibility. This program eliminates the need for page 3 of the paper-based version of the form. IAW UFC 3-601-02, Operations and Maintenance: Inspection, Testing, and Maintenance of Fire Protection Systems, Table 2-2. Wet Pipe Sprinkler Systems ITM Tasks, static and residual pressures for Main Drain Test are to be recorded on the installed system for comparison during subsequent system test to verify water supply system valve positions.

General Worksheet Information:

1. The Workbook is protected to prevent modification of the background formulas used to calculate the information. However, there are some areas which need input by the users. These areas are non-shaded and include:

a. Test Hydrant Number – Input Hydrant number based on local numbering system.

b. Location – Physical address of the hydrant being tested.

c. Test Hydrant Data Points – Input under each color the results information recorded which includes:

i. Date of Test - Date the hydrant was tested.

ii. Static Pressure – Test Hydrant Pressure reading with no water flowing.

iii. Residual Pressure (R) – Test Hydrant Pressure reading with water flowing from one or more of the additional flow hydrants

d. Flow Hydrant Data Points –You may have up to six (8) additional flow hydrants to achieve desired pressure drop.

i. Hydrant Number – Identification number of flow hydrant used during the test

ii. Outlet Size (d) – Flow hydrant’s outlet size used to during the test.

iii. Coefficient (c) – Number based on the flow hydrant’s outlet design.

iv. Pitot Pressure (p) – Pitot Gauge reading from each Flow Hydrant used during the test.

2. The Quantity (Q) or Total Flow (gpm) will automatically calculate based on the information input for each test using the “Q” formula presented in paragraph 6.

3. The Flow (gpm) available @ 20 psi and Flow (gpm) available @ 10 psi will automatically calculate for each test using the Hazen-Williams formula presented in paragraph 6.

4. Once information is input in the Data Point Tables, the embedded chart will automatically generate a graphical representation of the information. The line color corresponds to the test color identification of the recorded test information.

5. Follow the guidance in Chapter 4 of NFPA 291, Recommended Practice for Fire Flow Testing and Marking of Hydrants, to conduct water flow tests.

6. Formulas used to perform calculations:

“Q” Formula Hazen-Williams Formula

hf = pressure drop measured during test image1.gif image2.gif image1.emf