Attachment 5 - 7.8 Fire-Hydrant-Flow-Test-Record-BLANK.xlsx

XLSX spreadsheet 421 KB Posted Jul 6, 2021

Attached to: Semi-Annual Maintenance, Test, Inspections, Repairs and Certifications of all Suppression, Sprinkler Systems and Hydrants in Camp Darby, Depot & ASA Areas.
Solicitation number: W58D2M21Q0010
Issued by: Department of the Army Materiel Command Army Contracting Command

View the file

Other files

File	Type	Posted
Attachment 2 - 7.5 Hydrants map CAMPDARBY.pdf	PDF	Jul 6, 2021
W58D2M21Q0010.pdf	PDF	Jul 6, 2021
Attachment 6 -7.9 Flow test procedure.pdf	PDF	Jul 6, 2021
Attachment 12 - Price Book for Contractors Bid - Option Year One.xlsx	XLSX spreadsheet	Jul 6, 2021
Attachment 4 - 7.7 Hydrants map ASA-LTA.pdf	PDF	Jul 6, 2021
Attachment 9 - DMC Piano di Primo Intervento Aggiornamento-Ott20-Signed.pdf	PDF	Jul 6, 2021
Attachment 3 - 7.6 Hydrants map DEPOT.pdf	PDF	Jul 6, 2021
Attachment 15 - Past Performance Questionnaire.pdf	PDF	Jul 6, 2021
Attachment 10 - DUVRI Suppression Sys -Jan21-Signed.pdf	PDF	Jul 6, 2021
Attachment 8 - DMC First Aid Plan Review-Oct20-Signed.pdf	PDF	Jul 6, 2021
Attachment 13 - Price Book for Contractors Bid - Option Year Two.xlsx	XLSX spreadsheet	Jul 6, 2021
Attachment 7 - 7.10 O&M manual_Pressure Reducer Valve.pdf	PDF	Jul 6, 2021
Attachment 1 -7.4 UFC for O&M Insp and test of Fire Protection SYS ufc_3_601_02_2010.pdf	PDF	Jul 6, 2021
Attachment 16 - Antimafia Document.pdf	PDF	Jul 6, 2021
Attachment 11 - Price Book for Contractors Bid - Base Year.xlsx	XLSX spreadsheet	Jul 6, 2021
Attachment 14 - Past Experience Questionnaire.pdf	PDF	Jul 6, 2021

Show all 16

On GovTribe

Work with this file

Download the original file
Contacts named in this file
Similar government files
Ask GovTribe AI about this file

Try for free Login

Text version

The file's text, extracted by GovTribe without its formatting.

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 Jul 6, 2021.