{"text_format":"1","workbook":"xlsx","n_sheets":4,"sheets":["Pressure System","Public Water Connection","Gravity System","January 2022 Update Notes"],"not_rendered":{"charts":0,"images":0,"macros":0,"external_links":0,"defined_names":3,"comments":0,"pivot_tables":0},"unopened":[],"bounds":{"document_bytes":16777216,"sheet_cells":100000,"rows_first":2000,"rows_last":500,"rows_between":2000,"halvings":0,"cell_chars":16384,"cell_head_chars":4096},"cells_cut":0,"cells_raw":0,"read":"whole","date_system":"1900"}

{"sheet":"Pressure System","index":0,"n_rows":57,"n_cols":76,"rows_kept":57,"cut":false,"hidden":false,"merged":[[30,1,31,4],[44,13,47,15],[46,1,48,6],[26,1,27,4],[26,6,26,10],[50,13,53,15],[41,9,42,14],[50,1,50,5],[37,1,37,5],[53,1,56,3],[22,1,24,4],[0,1,1,15],[11,3,11,4],[13,11,14,15],[15,1,16,4],[15,6,16,9],[15,11,16,15],[7,3,7,4],[2,1,2,14],[4,3,4,4],[5,3,5,4],[6,3,6,4],[3,7,7,15],[20,3,20,4],[20,13,20,14],[23,13,23,14]]}
[null,"Virginia Livestock Watering Systems - Pressure System  Worksheet (revised 01/2022)"]
[]
[]
[null,"1) Assistance Information",null,null,null,null,"Project Notes:   "]
[null,"Customer:",null,null,null,null,"  "]
[null,"County:"]
[null,"Date:"]
[null,"Assisted By:"]
[]
[null,"2) Water Budget"]
[null,"a) Total Daily Water Demand",null,null,null,null,"b) Daily Peak Water Demand",null,null,null,null,"c) Evaluate Source",null,null,null," "]
[null,"Type of livestock:",null,null,null,null,"Number of times herd drinks/day",null,null,null,"events","Source flow rate:",null,null,null,"gpm"]
[null,"Number of Animals:",null,null,null,null,"Time desired to water herd:",null,null,null,"minutes/event","Source daily yield:",null,null,{"$f":"IF(O12=\"\",\"\",O12*60*24)","v":""},"gpd"]
[null,"Water demand/animal/day:",null,null,null,"gpd","Average peak demand:",null,null,{"$f":"IF(J13=\"\",\"\",E15/J12/J13)","v":""},"gpm","If source flow rate is close to or less than Peak Demand, consider storage alternatives."]
[null,"Total Daily Demand:",null,null,{"$f":"IF(E14=\"\",\"\",E13*E14)","v":""},"gpd","Alternate peak demand:",null,null,null,"gpm",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,1,2,3,4,5,6,null,null,null,null,null,null,null,null,null,null,null,null,"ASTM D2737:  SDR 9  - Bue pipe"]
[null,"See Design Note for watering recommendations for various types of livestock.",null,null,null,null,"See Design Note for considerations for estimating peak demand.",null,null,null,null,"If source daily yield is less than Total Daily Demand, consider an alternate or supplemental water source.",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Choices for Nominal Diameter",null,null,null,null,"Actual average inner dia. "]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Choices for Design Peak Flow",null,null,null,"Choices for Pipe Material",null,null,"Hazen-Williams",null,null,null,null,"PE","PVC","PE-SDR 9","Copper","Steel"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,1,null,null,null,null,null,null,null,"C Value",null,null,"Pipe dia. (in.)",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Nominal","Outer","Min thickness","Tolerance","Avg. inner dia"]
[null,"3) Design Parameters",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,2,"Avg. Peak Demand",null,null,null,1,null,null,null,null,1,null,null," "]
[null,"a) Trough Information",null,null,null,null,"b) Pipe Information",null,null,null,null,"c) Vertical Pumping Distance",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,3,"Alternate Peak Demand",null,null,null,2,"Plastic:  PE SIDR-PR",null,150,null,2,"1\"",null,1.0489999999999999,1.0289999999999999,0.86299999999999999,1.0249999999999999,1.0489999999999999,null,null,null,null,null,null,null,null,null,null,"1\"",1.125,0.125,1.2E-2,{"$f":"BU20-2*BV20-BW20","v":0.86299999999999999}]
[null,"Trough type(s):",null,null,null,null,"Pipe material:",null,null,null,null,"High point to pump \"to\":",null,null,null," (Text Description)",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,4,"Source Flow Rate",null,null,null,3,"Plastic:  SCH 40 PVC",null,150,null,3,"1 1/4\"",null,1.38,1.36,1.054,1.2649999999999999,1.38,null,null,null,null,null,null,null,null,null,null,"1 1/4\"",1.375,0.153,1.4999999999999999E-2,{"$f":"BU21-2*BV21-BW21","v":1.054}]
[null,"Design flow rate:",null,null,{"$f":"CHOOSE(AR23,\"\",J14,J15,O12)","v":""},"gpm","Pipe nominal diameter:",null,null,null,null,"Ground elev. of high point:",null,null,null,"feet",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,4,"Plastic:  PE SDR 9",null,150,null,4,"1 1/2\"",null,1.61,1.59,1.2449999999999999,1.5049999999999999,1.61,null,null,null,null,null,null,null,null,null,null,"1 1/2\"",1.625,0.18099999999999999,1.7999999999999999E-2,1.2449999999999999]
[null,"Select flow rate to troughs as guided by Step 2 and Design Note.  Typical design flow rates are:  8 gpm for frost-free troughs; 5 gpm for storage troughs.",null,null,null,null,"Pipe avg. inner diameter:",null,null,{"$f":"IF(BB25=1,\"\",INDEX(BD19:BI23,BB25,AW25))","v":""},"in.",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,1,"= choice",null,null,null,5,"Copper",null,130,null,5,"2\"",null,2.0670000000000002,2.0470000000000002,1.629,1.9850000000000001,2.0670000000000002,null,null,null,null,null,null,null,null,null,null,"2\"",2.125,0.23599999999999999,2.4E-2,1.629]
[null,null,null,null,null,null,"Pipe cross-sectional area:",null,null,{"$f":"IF(BB25=1,\"\",(J23/2)^2*PI()/144)","v":""},"sq. ft.","Low point to pump \"from\":",null,null,null," (Text Description)",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,6,"Steel",null,80]
[null,null,null,null,null,null,"Friction loss/100 ft",null,null,{"$f":"IF(OR(BB25= 1,E22=\"\"),\"\",1043.8*POWER(E22/AZ25,1.85)/POWER(J23,4.87))","v":""},"ft./100 ft.","Ground elev. of low point:",null,null,null,"feet",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,1,"= choice",null,{"$f":"CHOOSE(AW25,\"\",150,150,150,130,80)","v":""},null,1,"= choice"]
[null,"Maximum float valve pressure:",null,null,null,"psi","Velocity check (<5 fps):",null,null,{"$f":"IF(BB25=1,\"\",IF(E22=\"\",\"\",E22*0.002228/J24))","v":""},"fps"]
[null,"Typical values range from 50-140 psi.  Check manufacturer's recommendations.",null,null,null,null,"If velocity is greater than 5 fps, consider a larger diameter pipe.             ",null,null,null,null,"Elevation difference:",null,null,{"$f":"IF(O25=\"\",\"\",O22-O25)","v":""},"feet",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"C values from EFH-3, Fig 3-14 except"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,"OR",{"$f":"IF(O27=\"\",\"\",O27/2.31)","v":""},"psi",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"for copper.  Copper value from MWPS-1, 1987, p. 801.17."]
[null,null,null,null,null,null,"Pipe length to farthest watering point:",null,null,null,"feet"]
[null,"Minimum float valve pressure:",null,null,null,"psi","Add 10% for slope and fittings:",null,null,{"$f":"IF(J29=\"\",\"\",J29*1.1)","v":""},"feet"]
[null,"Varies depending on type of float.  Use manufacturer's recommended minimum.  Typical value is 10 psi. ",null,null,null,null,"Total friction loss:",null,null,{"$f":"IF(J29=\"\",\"\",J25*J30/100)","v":""},"ft.  OR "]
[null,null,null,null,null,null,"Total friction loss:",null,null,{"$f":"IF(J31=\"\",\"\",J31/2.31)","v":""},"psi    If friction loss is greater than 10 psi, consider using a larger diameter pipe."]
[]
[null,null,null,null,null,null,"Pipe pressure rating:",null,null,null,"psi"]
[null,null,null,null,null,null,"72% of rating (See VA CPS 516):",null,null,{"$f":"IF(J34=\"\",\"\",0.72*J34)","v":""},"psi    Compare with result in Step 5b."]
[]
[]
[null,"4) Pump and Pressure Tank Design"]
[null,"a) Summary of energy requirements for the watering system:",null,null,null,null,null,null,"b) Pressure Switch Settings Based on System Load:"]
[null,null,"Elevation head:",null,{"$f":"O28","v":""},"psi      OR",{"$f":"IF(E40=\"\",\"\",E40*2.31)","v":""},"feet",null,"Low pressure switch setting:",null,{"$f":"IF(E44=\"\",\"\",IF(E44<20,20,IF((FLOOR(E44,10)+4.999)<E44,CEILING(E44,10),FLOOR(E44,10))))","v":""},"psi (Minimum is 20 psi.)"]
[null,null,"Friction loss:",null,{"$f":"J32","v":""},"psi      OR",{"$f":"IF(E41=\"\",\"\",E41*2.31)","v":""},"feet",null,"High pressure switch setting:",null,{"$f":"IF(L40=\"\",\"\",L40+20)","v":""},"psi (Max. is usually 80 psi.)"]
[null,null,"Minimum float valve pressure:",null,{"$f":"IF(E30=\"\",\"\",E30)","v":""},"psi      OR",{"$f":"IF(E42=\"\",\"\",E42*2.31)","v":""},"feet",null,"If a high pressure switch setting of 80 psi or more is required, consider alternate design or high pressure-rated tank.  Note:  For VFD systems, Step 4b is not needed.  "]
[null,null,"Other: ",null,null,"psi      OR",{"$f":"IF(E43=\"\",\"\",E43*2.31)","v":""},"feet"]
[null,null,"TOTAL REQUIREMENTS:",null,{"$f":"IF(E40=\"\",\"\",SUM(E40:E43))","v":""},"psi      OR",{"$f":"IF(E44=\"\",\"\",E44*2.31)","v":""},"feet",null,"The pumping system should be designed based on the TOTAL REQUIREMENTS value computed in 4a."]
[null,"c)  Dynamic Head added to pump by the watering system:",null,null,null,null,null,null,"d)  Minimum Effective Drawdown for Pressure Tank:",null,null,null,null,"This is the minimum drawdown volume required to allow      the pump to run for at least one minute before shutting off.    A larger volume can be used."]
[null,"Dynamic head = higher switch setting of",null,null,{"$f":"L41","v":""},"psi  x  2.31  =",{"$f":"IF(L41=\"\",\"\",L41*2.31)","v":""},"feet ",null,"Design pumping rate of",null,{"$f":"E22","v":""}," gpm   x"]
[null,"Total Dynamic Head will equal this number plus the 'Lift' Head required to get the water from the source up to the distribution system.  The flow rate and the Total Dynamic Head will be used to size the pump for the project.",null,null,null,null,null,null,null,"Minimum pumping time of",null,1,"minute  ="]
[null,null,null,null,null,null,null,null,null,"Minimum pressure tank volume of ",null,{"$f":"IF(L46=\"\",\"\",L46*L47)","v":""},"gallons"]
[]
[]
[null,"5) Static Pressure Checks",null,null,null,null,null,null,null,null,null,null,null,"Orange cell:  pressure exceeds max float valve pressure; red cell: pipe pressure limit exceeded.   Check troughs at higher elevations if pressure is excessive at lowest trough."]
[null,"a)  Static pressure at pressure switch:",null,null,"Elevation of highest point:",null,null,"ft","b)  Check static pressure at lowest trough:"]
[null,null,null,null,"Elevation of pressure switch:",null,null,"ft",null,"Elevation of pressure switch:",null,{"$f":"IF(G53=\"\",\"\",G53)","v":""},"feet"]
[null,"If static pressure on the switch  exceeds low pressure switch setting (red cell), the pump will not turn back on after trough is initially filled and then emptied.",null,null,"Low pressure switch setting =",null,{"$f":"IF(G52=\"\",\"\",L40)","v":""},"psi",null,"Elevation of lowest trough:",null,null,"feet"]
[null,null,null,null,null,null,null,null,null,"Difference:",null,{"$f":"IF(L53=\"\",\"\",L53-L54)","v":""},"feet    OR",{"$f":"IF(L55=\"\",\"\",L55/2.31)","v":""},"psi"]
[null,null,null,null,"Static pressure on switch =",null,{"$f":"IF(G53=\"\",\"\",(G52-G53)/2.31)","v":""},"psi",null,"Add high pressure switch setting:",null,null,null,{"$f":"IF(L54=\"\",\"\",L41)","v":""},"psi"]
[null,null,null,null,null,null,null,null,null,"Total pressure at lowest trough:",null,null,null,{"$f":"IF(L54=\"\",\"\",N55+N56)","v":""},"psi"]

{"sheet":"Public Water Connection","index":1,"n_rows":47,"n_cols":61,"rows_kept":47,"cut":false,"hidden":false,"merged":[[30,1,31,4],[26,1,27,4],[22,1,24,4],[44,13,48,15],[45,2,45,3],[46,2,46,3],[26,6,27,10],[37,1,37,5],[37,8,37,12],[20,3,20,4],[0,1,1,15],[2,1,2,14],[3,7,7,15],[4,3,4,4],[5,3,5,4],[6,3,6,4],[7,3,7,4],[11,3,11,4],[13,11,14,15],[15,1,16,4],[15,6,16,9],[15,11,16,15]]}
[null,"Virginia Livestock Watering Systems - Public Water Connection Worksheet (revised 01/2022)"]
[]
[]
[null,"1) Assistance Information",null,null,null,null,"Project Notes:   "]
[null,"Customer:",null,null,null,null,"  "]
[null,"County:"]
[null,"Date:"]
[null,"Assisted By:"]
[]
[null,"2) Water Budget"]
[null,"a) Total Daily Water Demand",null,null,null,null,"b) Daily Peak Water Demand",null,null,null,null,null,null,null,null," "]
[null,"Type of livestock:",null,null,null,null,"Number of times herd drinks/day",null,null,null,"events"]
[null,"Number of Animals:",null,null,null,null,"Time desired to water herd:",null,null,null,"minutes/event"]
[null,"Water demand/animal/day:",null,null,null,"gpd","Average peak demand:",null,null,{"$f":"IF(J13=\"\",\"\",E15/J12/J13)","v":""},"gpm"]
[null,"Total Daily Demand:",null,null,{"$f":"IF(E14=\"\",\"\",E13*E14)","v":""},"gpd","Alternate peak demand:",null,null,null,"gpm",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,1,2,3,4,5,6]
[null,"See Design Note for watering recommendations for various types of livestock.",null,null,null,null,"See Design Note for considerations for estimating peak demand.",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Choices for Nominal Diameter",null,null,null,null,"Actual average inner dia. "]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Choices for Design Peak Flow",null,null,null,"Choices for Pipe Material",null,null,"Hazen-Williams",null,null,null,null,"PE","PVC","PE-SDR 9","Copper","Steel"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,1,null,null,null,null,null,null,null,"C Value",null,null,"Pipe dia. (in.)"]
[null,"3) Design Parameters",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,2,"Avg. Peak Demand",null,null,null,1,null,null,null,null,1,null,null," "]
[null,"a) Trough Information",null,null,null,null,"b) Pipe Information",null,null,null,null,"c) Vertical Lift",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,3,"Alternate Peak Demand",null,null,null,2,"Plastic:  PE SIDR-PR",null,150,null,2,"1\"",null,1.0489999999999999,1.0289999999999999,0.86299999999999999,1.0249999999999999,1.0489999999999999]
[null,"Trough type(s):",null,null,null,null,"Pipe material:",null,null,null,null,"Elevation of highest point in system:",null,null,null,"feet",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,4,"Source Flow Rate",null,null,null,3,"Plastic:  SCH 40 PVC",null,150,null,3,"1 1/4\"",null,1.38,1.36,1.054,1.2649999999999999,1.38]
[null,"Design flow rate:",null,null,{"$f":"CHOOSE(AR23,\"\",J14,J15,O12)","v":""},"gpm","Plastic pipe nominal diameter:",null,null,null,null,"Elevation of public water connection:",null,null,null,"feet",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,4,"Plastic:  PE SDR 9",null,150,null,4,"1 1/2\"",null,1.61,1.59,1.2449999999999999,1.5049999999999999,1.61]
[null,"Select flow rate to troughs as guided by Step 2 and Design Note.  Typical design flow rates are:  8 gpm for frost-free troughs; 5 gpm for storage troughs.",null,null,null,null,"Plastic pipe actual diameter:",null,null,{"$f":"IF(BB25=1,\"\",INDEX(BD19:BI23,BB25,AW25))","v":""},"in.",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,1,"= choice",null,null,null,5,"Copper",null,130,null,5,"2\"",null,2.0670000000000002,2.0470000000000002,1.629,1.9850000000000001,2.0670000000000002]
[null,null,null,null,null,null,"Pipe cross-sectional area:",null,null,{"$f":"IF(BB25=1,\"\",(J23/2)^2*PI()/144)","v":""},"sq. ft.","Elevation difference:",null,null,{"$f":"IF(O21=\"\",\"\",O21-O22)","v":""},"feet",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,6,"Steel",null,80]
[null,null,null,null,null,null,"Friction loss/100 ft",null,null,{"$f":"IF(OR(BB25= 1,E22=\"\"),\"\",1043.8*POWER(E22/AZ25,1.85)/POWER(J23,4.87))","v":""},"ft./100 ft.",null,null,"OR",{"$f":"IF(O24=\"\",\"\",O24/2.31)","v":""},"psi",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,1,"= choice",null,{"$f":"CHOOSE(AW25,\"\",150,150,150,130,80)","v":""},null,1,"= choice"]
[null,"Maximum float valve pressure:",null,null,null,"psi","Velocity check (<5 fps):",null,null,{"$f":"IF(BB25=1,\"\",IF(E22=\"\",\"\",E22*0.002228/J24))","v":""},"fps"]
[null,"Typical values range from 75-140 psi.  Check manufacturer's recommendations.",null,null,null,null,"If velocity is greater than 5 fps, consider a larger diameter pipe.             ",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"C values from EFH-3, Fig 3-14 except"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"for copper.  Copper value from MWPS-1, 1987, p. 801.17."]
[null,null,null,null,null,null,"Pipe length to farthest watering point:",null,null,null,"feet"]
[null,"Minimum float valve pressure:",null,null,null,"psi","Add 10% for slope and fittings:",null,null,{"$f":"IF(J29=\"\",\"\",J29*1.1)","v":""},"feet"]
[null,"Varies depending on type of float.  Use manufacturer's recommended minimum.  Typical value is 10 psi. ",null,null,null,null,"Total friction loss:",null,null,{"$f":"IF(J29=\"\",\"\",J25*J30/100)","v":""},"ft.  OR "]
[null,null,null,null,null,null,"Total friction loss:",null,null,{"$f":"IF(J31=\"\",\"\",J31/2.31)","v":""},"psi  If friction loss is greater than 10 psi, consider using a larger diameter pipe."]
[]
[null,null,null,null,null,null,"Pipe pressure rating:",null,null,null,"psi"]
[null,null,null,null,null,null,"72% of rating (See VA CPS 516):",null,null,{"$f":"IF(J34=\"\",\"\",0.72*J34)","v":""},"psi  Compare with result in Step 5."]
[]
[]
[null,"4) Pressure Requirements",null,null,null,null,null,null,"5) Static Pressure Checks"]
[null," Summary of energy requirements for the watering system:",null,null,null,null,null,null,"Check static pressure at lowest trough:"]
[null,null,"Elevation head:",null,{"$f":"IF(O25=\"\",\"\",O25)","v":""},"psi",null,null,"Elevation of public water connection:",null,null,{"$f":"IF(O22=\"\",\"\",O22)","v":""},"feet"]
[null,null,"Friction loss:",null,{"$f":"IF(J31=\"\",\"\",J31/2.31)","v":""},"psi",null,null,"Elevation of lowest trough:",null,null,null,"feet"]
[null,null,"Minimum float valve pressure:",null,{"$f":"IF(E30=\"\",\"\",E30)","v":""},"psi",null,null,null,null,"Difference:",{"$f":"IF(L40=\"\",\"\",L40-L41)","v":""},"feet    OR",{"$f":"IF(L42=\"\",\"\",L42/2.31)","v":""},"psi"]
[null,null,null,null,null,null,null,null,null,null,"Add pressure at meter:",null,null,{"$f":"IF(E46=\"\",\"\",E46)","v":""},"psi"]
[null,null,"TOTAL REQUIREMENTS:",null,{"$f":"IF(E40=\"\",\"\",SUM(E40:E42))","v":""},"psi",null,null,null,null,"Total pressure at lowest trough:",null,null,{"$f":"IF(N42=\"\",\"\",N42+N43)","v":""},"psi"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,"Orange cell:  pressure exceeds max float valve pressure; red cell: pipe pressure limit exceeded.   Check troughs at higher elevations if pressure is excessive at lowest trough."]
[null,null,"Pressure at water meter:",null,null,"psi"]
[null,null,"Available pressure is:",null,{"$f":"IF(E44=\"\",\"\",IF(E46>E44,\"Adequate\",\"Inadequate\"))","v":""}]

{"sheet":"Gravity System","index":2,"n_rows":59,"n_cols":67,"rows_kept":59,"cut":false,"hidden":false,"merged":[[51,1,52,3],[51,5,58,8],[32,13,34,13],[38,10,39,13],[38,1,39,3],[51,10,57,13],[0,0,1,15],[38,5,39,8],[5,3,5,4],[4,3,4,4],[15,1,16,4],[15,6,16,9],[30,1,31,4],[20,3,20,4],[32,11,34,12],[26,1,27,4],[3,7,7,14],[6,3,6,4],[22,1,24,4],[7,3,7,4],[11,3,11,4],[26,6,27,10],[30,11,31,14],[13,11,14,13],[15,11,16,13],[18,13,19,15],[40,14,46,15]]}
[" Virginia Livestock Watering Systems - Pressure-Energy/Gravity Flow Worksheet (revised 01/2022)"]
[]
[]
[null,"1) Assistance Information",null,null,null,null,"Project Notes:   ","Seek advice from Area Engineer before using this tab."]
[null,"Customer:",null,null,null,null,"  "]
[null,"County:"]
[null,"Date:"]
[null,"Assisted By:"]
[]
[null,"2) Water Budget"]
[null,"a) Total Daily Water Demand",null,null,null,null,"b) Daily Peak Water Demand",null,null,null,null,"c) Evaluate Source"]
[null,"Type of livestock:",null,null,null,null,"No. of times herd drinks/day:",null,null,"events",null,"Source flow rate:",null,null,"gpm"]
[null,"Number of Animals:",null,null,null,null,"Time desired to water herd:",null,null,"minutes/event",null,"Source daily yield:",null,{"$f":"IF(N12=\"\",\"\",N12*60*24)","v":""},"gpd"]
[null,"Water demand/animal/day:",null,null,null,"gpd","Average peak demand:",null,{"$f":"IF(I13=\"\",\"\",E15/I12/I13)","v":""},"gpm",null,"If source flow rate is close to or less than Peak Demand, consider storage alternatives."]
[null,"Total Daily Demand:",null,null,{"$f":"IF(E14=\"\",\"\",E13*E14)","v":""},"gpd","Alternate peak demand:",null,null,"gpm",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,1,2,3,4,5,6,null,null,"Kp Values:  See EFH-3, p. 3-21."]
[null,"See Design Note for watering recommendations for various types of livestock.",null,null,null,null,"See Design Note for considerations for estimating peak demand.",null,null,null,null,"If source daily yield is less than Total Daily Demand, consider an alternate or supplemental water source.",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Choices for Nominal Diameter",null,null,null,null,"Actual average inner dia. "]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Choices for Design Peak Flow",null,null,null,"Choices for Pipe Material",null,null,"Hazen-Williams",null,null,null,null,"PE","PVC","PE-SDR 9","Copper","Steel",null,"PE","PVC","PE-SDR 9","Copper","Steel"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,1,null,null,null,null,null,null,null,"C Value",null,null,"Pipe dia. (in.)",null,null,null,null,null,null,null,"n=0.012","n=0.011","n=0.012","n=0.011","n=0.012"]
[null,"3) Design Parameters",null,null,null,null,"See Design Note or EFH Ch. 12 for guidance on pipe size selection.",null,null,null,null,null,null,"Pumping rate should not exceed source rate.",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Trough Types",null,null,null,null,2,"Avg. Peak Demand",null,null,null,1,null,null,null,null,1,null,null," "]
[null,"a) Trough Information",null,null,null,null,"b) Pipe Information",null,null,null,null,"d) If Pumping to a Reservoir:",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,3,"Alternate Peak Demand",null,null,null,2,"Plastic:  PE SIDR-PR",null,150,null,2,"1\"",null,1.0489999999999999,1.0289999999999999,0.86299999999999999,1.0249999999999999,1.0489999999999999,null,{"$f":"5087*(0.012)^2/(BE20^(4/3))","v":0.68726397364287473},{"$f":"5087*(0.011)^2/(BF20^(4/3))","v":0.59250671264365273},{"$f":"5087*(0.012)^2/(BG20^(4/3))","v":0.89154479482074711},{"$f":"5087*(0.011)^2/(BH20^(4/3))","v":0.59559167784278988},{"$f":"5087*(0.012)^2/(BI20^(4/3))","v":0.68726397364287473}]
[null,"Trough type(s):",null,null,null,null,"Pipe material:",null,null,null,null,"Desired pumping rate to reservoir:",null,null,null,"gpm",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"T1: Freeze-Proof",1,null,null,null,4,"Source Flow Rate",null,null,null,3,"Plastic:  SCH 40 PVC",null,150,null,3,"1 1/4\"",null,1.38,1.36,1.054,1.2649999999999999,1.38,null,{"$f":"5087*(0.012)^2/(BE21^(4/3))","v":0.47678082544762423},{"$f":"5087*(0.011)^2/(BF21^(4/3))","v":0.4085029810287461},{"$f":"5087*(0.012)^2/(BG21^(4/3))","v":0.68292039349044631},{"$f":"5087*(0.011)^2/(BH21^(4/3))","v":0.4499107884393333},{"$f":"5087*(0.012)^2/(BI21^(4/3))","v":0.47678082544762423}]
[null,"Design flow rate:",null,null,{"$f":"CHOOSE(AR23,\"\",I14,I15,N12)","v":""},"gpm","Pipe nominal diameter:",null,null,null,null,"Pumping duration required to meet daily demand:",null,null,{"$f":"IF(O21=\"\",\"\",E15/O21)","v":""},"min/day",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"T1: Storage",null,null,null,null,null,null,null,null,null,4,"Plastic:  PE SDR 9",null,150,null,4,"1 1/2\"",null,1.61,1.59,1.2449999999999999,1.5049999999999999,1.61,null,0.38820077226768945,0.33167872008485449,0.5469300193490626,0.35688785966058251,0.38820077226768945]
[null,"Select flow rate to troughs as guided by Step 2 and Design Note.  Typical design flow rates are:  8 gpm for frost-free troughs; 5 gpm for storage troughs.",null,null,null,null,"Pipe avg. inner diameter:",null,null,{"$f":"IF(BB25=1,\"\",INDEX(BD19:BI23,BB25,AW25))","v":""},"in.","Ground elevation of water source:",null,null,null,"ft.",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,1,"= choice",null,null,null,5,"Copper",null,130,null,5,"2\"",null,2.0670000000000002,2.0470000000000002,1.629,1.9850000000000001,2.0670000000000002,null,0.27820841428469884,0.23682269430755137,0.38217544856020225,0.24673632572542187,0.27820841428469884]
[null,null,null,null,null,null,"Pipe cross-sectional area:",null,null,{"$f":"IF(BB25=1,\"\",(J23/2)^2*PI()/144)","v":""},"sq. ft.","Elevation head:",null,null,{"$f":"IF(O23=\"\",\"\",J35-O23)","v":""},"ft.",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,1,null,null,null,null,null,null,null,null,6,"Steel",null,80]
[null,null,null,null,null,null,"Kp (head loss coefficient):",null,null,{"$f":"IF(J23=\"\",\"\",INDEX(BJ19:BO23,BB25,AW25))","v":""},null,"Static pressure in pipe (check against max. allowed):",null,null,{"$f":"IF(O23=\"\", \"\", (J33-O23)/2.31)","v":""},"psi",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"T2: Freeze-Proof",null,null,null,null,null,null,null,null,null,1,"= choice",null,{"$f":"CHOOSE(AW25,\"\",150,150,150,130,80)","v":""},null,1,"= choice"]
[null,"Maximum float valve pressure, if applicable:",null,null,null,"psi","Velocity check (<5 fps):",null,null,{"$f":"IF(BB25=1,\"\",IF(E22=\"\",\"\",E22*0.002228/J24))","v":""},"fps","Dynamic Head Calculations:",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"T2: Storage"]
[null,"Typical values range from 75-140 psi.  Check manufacturer's recommendations.",null,null,null,null,"If velocity is greater than 5 fps, consider a larger diameter pipe.                  Note:  For flows greater than design flow, velocities will be greater.",null,null,null,null,null,"Pipe length to reservoir:",null,null,"ft",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Q = A * SQRT(2*32.2*h / (Kp*L) ) * 7.5 * 60 * efficiency   (gpm)"]
[null,null,null,null,null,null,null,null,null,null,null,null,"Add 10% for slope, fittings:",null,{"$f":"IF(O27=\"\",\"\",ROUND(O27*1.1,0))","v":""},"ft",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,1,null,null,null,null,null,null,null,null,null,"C values from EFH-3, Fig 3-14 except",null,null,null,null,null,null,null,null,null,null,null,null,"Kp values computed based on EFH Chapter 3, eq. 3-9."]
[null,null,null,null,null,null,"Pipe pressure rating:",null,null,null,"psi",null,"Friction loss/100':",null,{"$f":"IF(O27=\"\",\"\",1043.8*POWER(O21/AZ25,1.85)/POWER(J23,4.87))","v":""},"ft/100 ft",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"T3: Freeze-Proof",null,null,null,null,null,null,null,null,null,null,"for copper.  Copper value from MWPS-1, 1987, p. 801.17."]
[null,"Minimum float valve pressure, if applicable:",null,null,null,"psi","72% of rating (See VA CPS 516):",null,null,{"$f":"IF(J29=\"\",\"\",0.72*J29)","v":""},"psi",null,"Total friction loss:",null,{"$f":"IF(O27=\"\",\"\",O28/100*O29)","v":""},"ft",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"T3: Storage",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Manning's n values for plastic pipe from EFH-3, Fig. 3-13."]
[null,"Varies depending on type of float.  Use manufacturer's recommended minimum.  Typical value is 10 psi. ",null,null,null,null,null,null,null,null,null,"Note:  If total friction loss exceeds 23.1 ft (10 psi), consider choosing a larger pipe diameter."]
[null,null,null,null,null,null,"c)  Gravity System Parameters",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,1]
[null,null,null,null,null,null,"Reservoir gnd elev or spring box outlet elev:",null,null,null,"ft","Dynamic Head added to pump by pressure component of system:",null,"Friction + elev. head:",{"$f":"IF(O27=\"\",\"\",O30+O24)","v":""},"ft.",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"T4: Freeze-Proof"]
[null,null,null,null,null,null,"Reservoir depth below ground (typically 6'):",null,null,null,"ft",null,null,null,"OR",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"T4: Storage"]
[null,null,null,null,null,null,"Reservoir bottom (elev for computing head):",null,null,{"$f":"IF(J33=\"\",\"\",J33-J34)","v":""},"ft",null,null,null,{"$f":"IF(O27=\"\",\"\",O33/2.31)","v":""},"psi"]
[]
[null,"4) Flow and Static Pressure Checks",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,1]
[null,"TROUGH ELEVATIONS:",null,null,null,"CALCULATIONS FOR FLOAT-VALVE SYSTEMS:",null,null,null,null,"CALCULATIONS FOR CASCADING SYSTEMS: Consult Area Engineer!",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"T5: Freeze-Proof"]
[null,"Enter trough elevations from survey data.  For cascade-type systems, enter trough elevations in order from highest to lowest.",null,null,null,"Troughs are tee-ed off from the main line, with flow to each trough controlled by a float valve.  Pipe length is measured from the reservoir or spring box.",null,null,null,null,"Troughs are connected in series by way of their overflow pipes.  Pipe length for Trough 1 is measured from the spring box.  Subsequent lengths are measured from the previous trough.",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"T5: Storage"]
[]
[null,"Trough ID and Type","Trough Ground Elev. (ft)","Estimated Water Surface Elev. (ft)",null,"Pipe Length from Reservoir or Spring Box to Trough (ft)","Head from Reservoir or Spring Box (ft)","Maximum Flow Rate (gpm)","Static Pressure (psi)",null,"Sub-System","Pipe Length from Trough above (ft)","Head from Upper Trough (ft)","Max. Flow Rate (gpm)","Air lock can be a problem in spring-fed systems due to dissolved oxygen.  Use a minimum diameter of  1-1/2\" for pipe grades bewteen 0.5-1.0%.  Use a minimum pipe diameter of 2\" for pipe grades less than 0.5%.  See EFH Ch. 12.",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,1]
[null,"T1",null,{"$f":"IF(C42=\"\",\"\",C42+2)","v":""},null,null,{"$f":"IF(F42=\"\",\"\",$J$35-D42)","v":""},{"$f":"IF(F42=\"\",\"\",IF($BB$25=1,\"\",$J$24*360*SQRT(64.4*G42/$J$25/F42)))","v":""},{"$f":"IF(F42=\"\",\"\",($J$33-C42)/2.31)","v":""},null,"Spring box - T1",null,{"$f":"IF(L42=\"\",\"\",$J$35-D42)","v":""},{"$f":"IF(L42=\"\",\"\",$J$24*450*SQRT(64.4*M42/$J$25/L42))","v":""},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"T6: Freeze-Proof"]
[null,"T2",null,{"$f":"IF(C43=\"\",\"\",C43+2)","v":""},null,null,"",{"$f":"IF(F43=\"\",\"\",IF($BB$25=1,\"\",$J$24*360*SQRT(64.4*G43/$J$25/F43)))","v":""},"",null,"T1-T2",null,{"$f":"IF(L43=\"\",\"\",D42-D43)","v":""},{"$f":"IF(L43=\"\",\"\",$J$24*450*SQRT(64.4*M43/$J$25/L43))","v":""},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"T6: Storage"]
[null,"T3",null,"",null,null,"","","",null,"T2-T3",null,"",""]
[null,"T4",null,"",null,null,"","","",null,"T3-T4",null,"","",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,1]
[null,"T5",null,"",null,null,"","","",null,"T4-T5",null,"","",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"T7: Freeze-Proof"]
[null,"T6",null,"",null,null,"","","",null,"T5-T6",null,"","",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"T7: Storage"]
[null,"T7",null,"",null,null,"","","",null,"T6-T7",null,"",""]
[null,"T8",null,"",null,null,"","","",null,"T7-T8",null,"","",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,1]
[null,"T9",null,"",null,null,"","","",null,"T8-T9",null,"","",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"T8: Freeze-Proof"]
[null,"T10",null,"",null,null,"","","",null,"T9-T10",null,"","",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"T8: Storage"]
[null,"Trough water surface elevation is assumed to be 2 ft above ground elevation.",null,null,null,"Flow calculations assume a float valve efficiency of 80%.  For flows less than the design rate (yellow cells), consider modifying the system or using storage troughs (such as HETT or concrete).  If static pressures exceed the recommended maximum for the float valve (orange cell), consider using a pressure reducer, adjusting the orifice, or relocating the trough.  If static pressures are less than the recommended minimum (red cells), consider moving the trough to a lower elevation.  Cells are coded orange for static pressures exceeding  maximum recommended pipe pressures.",null,null,null,null,"For flow rates less than the design rate (yellow cells), consider modifying the system or using larger volume troughs.  If trough in-flow rate exceeds trough outflow rate (red cells), a flow restrictor, larger pipe diameter, or change in trough location may be necessary.   This may not be an issue if source flow rate is always less than the maximum flow possible."]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,1]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"T9: Freeze-Proof"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"T9: Storage"]
[]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,1]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"T10:Freeze-Proof"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"T10: Storage"]

{"sheet":"January 2022 Update Notes","index":3,"n_rows":21,"n_cols":3,"rows_kept":21,"cut":false,"hidden":false,"merged":[]}
["Changes made to September 2010 Version"]
[]
[]
[]
["1) Added PE SDR 9 plastic pipe (ASTM D-2737) as a choice to the list of pipe materials in Step 3b.  Note that the inner diameter of this type of pipe is significantly smaller that other types of plastic pipe of the same nominal size."]
[]
[]
["2) Hazen-Williams C values adjusted according to EFH-3, Fig. 3-14: "]
["           Plastic Pipe:  increased from 140 to 150"]
["           Steel:  decreased from 100 to 80"]
["           Copper:  remained the same at 130.  EFH-3 Fig. 3-14 does not list copper.  Value of 130 obtained from Midwest Plan Service, Structures and Environment Handbook, Revised 1987, p. 801.17."]
[]
[]
["3) Manning's n values for plastic pipe changed from 0.009 to:"]
[null,"PVC:",1.0999999999999999E-2]
[null,"PE:",1.2E-2]
[]
[null,"These values are from EFH-3, Fig. 3-13."]
[]
[]
["4) A note was added under 4b on the Pressure System tab regarding VFD systems."]