B08-RFQ-Atch 4_7.9 Fire-Hydrant-Flow-Test-Record-BLANK.xlsx
XLSX spreadsheet 430 KB Posted
- Solicitation number
- W912PF24Q0122
About this file
This document appears to be a blank template for a "Water Flow Test Record" that is used as an attachment to a federal contract opportunity. It contains blank fields for entering information such as test hydrant number, static and residual pressures, outlet size, coefficient, pitot pressure, test flow, and available flow at different pressures. The template also includes a chart for plotting the test results. While this document does not contain details about the specific contract opportunity, it provides a standard format for documenting water flow tests that are likely required as part of the contract requirements.
The related federal contract opportunity is for "Maintenance and Repair Service for Fire Suppression Systems at USAG Italy DMC". This is a Request for Quotation (RFQ) issued by the Department of the Army Materiel Command Army Contracting Command. The solicitation number is W912PF24Q0122, and the offer due date is currently listed as 26 Aug 2024, 03:00 PM local time in Rome, Italy, though this may be subject to change in the final version of the solicitation.
View the file
Other files
Show all 17
On GovTribe
Work with this file
- Download the original file
- Contacts named in this file
- Similar government files
- Ask GovTribe AI about this file
Text version
Export Summary
| This document was exported from Numbers. Each table was converted to an Excel worksheet. All other objects on each Numbers sheet were placed on separate worksheets. Please be aware that formula calculations may differ in Excel. | ||
| Numbers Sheet Name | Numbers Table Name | Excel Worksheet Name |
| Instructions | ||
| Table 1 | Instructions | |
| Rename Hydrant # | ||
| Table 1 | Rename Hydrant # | |
| Copy Tab for Add'l Hydrants | ||
| Table 1 | Copy Tab for Add'l Hydrants |
Instructions
&"Helvetica Neue,Regular"&12&K000000&P
Rename Hydrant # Input information in non-shaded areas only. Test Data Information
| Test Hydrant Number | C-140 | Date | 12"-"Nov"-"10 | 12"-"Nov"-"11 | 12"-"Nov"-"12 | 12"-"Nov"-"13 | 12"-"Nov"-"14 | |
| Static Pressure (psig) | 78 | 75 | 82 | 62 | 71 | |||
| Location | Residual Pressure (psig) | 30 | 35 | 32 | 28 | 27 | ||
| Corner of 5th Street and Levitow Ave | Outlet Size (inches) | 2.5 | 2.5 | 2.5 | 2.5 | 2.5 | ||
| Coefficient | 0.9 | 0.9 | 0.8 | 0.8 | 0.7 | |||
| Pitot Pressure | 41 | 39 | 38 | 35 | 41 | |||
| Flow Hydrant #1 | C-139 | Flow Hydrant #4 | Test Flow (gpm) | 1074 | 1048 | 919 | 882 | 836 |
| Flow Hydrant #2 | C-142 | Flow Hydrant #5 | Flow (gpm) available @ 20 psi | 1190 | 1244 | 1033 | 989 | 905 |
| Flow Hydrant #3 | Flow Hydrant #6 | Flow (gpm) available @ 10 psi | 1297 | 1362 | 1120 | 1110 | 997 | |
| 1396 | 1471 | 1201 | 1221 | 1082 | ||||
| Column heading color correlates to line color on the chart |
| GPM | PSI | GPM | PSI | GPM | PSI | GPM | PSI | GPM | PSI |
| 0 | 78 | 0 | 75 | 0 | 82 | 0 | 62 | 0 | 71 |
| 1074 | 30 | 1048 | 35 | 919 | 32 | 882 | 28 | 836 | 27 |
| 1190 | 20 | 1244 | 20 | 1033 | 20 | 989 | 20 | 905 | 20 |
| 1297 | 10 | 1362 | 10 | 1120 | 10 | 1110 | 10 | 997 | 10 |
| 1396 | 0 | 1471 | 0 | 1201 | 0 | 1221 | 0 | 1082 | 0 |
(For multiple test information printed on one chart, color printer required)
&"Calibri,Regular"&28&K000000Water Flow Test Record
&"Calibri,Regular"&11&K000000AF Form 1027, Water Flow Test Record, Computer-Generated (Nov 2010)
Water Flow Test Chart 12-Nov-10 0 1074.4042275147478 1190.0043716735747 1296.7380461501671 1396.4600817663147 78 30 20 10 0 12-Nov-11 0 1047.8716328937612 1244.4903709404284 1361.9742632028479 1471.3932878885569 75 35 20 10 0 12-Nov-12 0 919.42234854282276 1032.6728663082806 1119.5172808726384 1200.966059421487 82 32 20 10 0 12-Nov-13 0 882.38329964930779 989.03869109255629 1109.942472566539 1220.5348293001707 62 28 20 10 0 12-Nov-14 0 835.64773251147051 904.99606085465518 996.86627743465192 1082.0275086507033 71 27 20 10 0 Water Flow (gpm)
Pressure (psig)
Copy Tab for Add'l Hydrants Input information in non-shaded areas only. Test Data Information
| Test Hydrant Number | Date | ||||||
| Static Pressure (psig) | |||||||
| Location | Residual Pressure (psig) | ||||||
| Outlet Size (inches) | 2.5 | 2.5 | 2.5 | 2.5 | |||
| Coefficient | |||||||
| Pitot Pressure | |||||||
| Flow Hydrant #1 | Flow Hydrant #4 | Test Flow (gpm) | ERROR:#VALUE! | 0 | 0 | 0 | 0 |
| Flow Hydrant #2 | Flow Hydrant #5 | Flow (gpm) available @ 20 psi | 0 | 0 | 0 | 0 | 0 |
| Flow Hydrant #3 | Flow Hydrant #6 | Flow (gpm) available @ 10 psi | 0 | 0 | 0 | 0 | 0 |
| 0 | 0 | 0 | 0 | 0 | |||
| Column heading color correlates to line color on the chart |
| GPM | PSI | GPM | PSI | GPM | PSI | GPM | PSI | GPM | PSI |
| 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 |
| ERROR:#VALUE! | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 |
| 0 | 20 | 0 | 20 | 0 | 20 | 0 | 20 | 0 | 20 |
| 0 | 10 | 0 | 10 | 0 | 10 | 0 | 10 | 0 | 10 |
| 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 |
(For multiple test information printed on one chart, color printer required)
&"Calibri,Regular"&28&K000000Water Flow Test Record
&"Calibri,Regular"&11&K000000AF Form 1027, Water Flow Test Record, Computer-Generated (Nov 2010)
Water Flow Test Chart Series1 1 2 3 4 5 0 0 20 10 0 Series2 1 2 3 4 5 0 0 20 10 0 Series3 1 2 3 4 5 0 0 20 10 0 Series4 1 2 3 4 5 0 0 20 10 0 Series5 1 2 3 4 5 0 0 20 10 0 Water Flow (gpm)
Pressure (psig) image1.png
File details come from the government source that posted it. Updated .