{"text_format":"1","workbook":"xlsx","n_sheets":3,"sheets":["Pressure System Calc. Worksheet","Pressure System Worksheet Cont.","Misc. Data"],"not_rendered":{"charts":0,"images":0,"macros":1,"external_links":0,"defined_names":2,"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 Calc. Worksheet","index":0,"n_rows":70,"n_cols":17,"rows_kept":70,"cut":false,"hidden":false,"merged":[[32,7,35,13],[35,0,35,6],[34,0,34,4],[60,0,60,13],[36,12,36,13],[58,0,58,13],[39,0,39,13],[57,0,57,7],[36,0,36,11],[54,2,54,7],[52,2,52,7],[50,2,50,7],[48,2,48,7],[24,0,24,4],[24,6,24,13],[31,0,31,5],[31,11,31,13],[57,8,57,12],[46,2,46,7],[44,2,44,7],[42,2,42,7],[40,2,40,7],[25,0,25,13],[26,0,26,8],[30,0,30,13],[27,0,27,5],[29,0,29,10],[27,7,27,8],[28,0,28,8],[26,9,28,13],[33,0,33,3],[31,6,31,10],[29,12,29,13],[38,2,38,7],[56,2,56,7],[32,0,32,6],[33,4,33,6],[23,0,23,13],[14,0,14,13],[21,0,21,6],[21,7,21,8],[22,7,22,8],[11,0,11,13],[12,4,12,5],[18,11,18,13],[12,0,12,2],[12,6,12,8],[13,0,13,13],[12,9,12,11],[15,0,15,2],[20,0,20,13],[19,0,19,13],[16,0,16,13],[17,11,17,13],[18,5,18,6],[21,9,21,13],[22,11,22,13],[15,11,15,13],[17,0,17,2],[15,9,15,10],[17,9,17,10],[8,0,8,13],[5,8,5,10],[3,12,3,13],[3,2,3,5],[7,2,7,4],[9,8,9,13],[9,0,9,7],[10,0,10,2],[10,9,10,11],[10,6,10,8],[10,4,10,5],[59,7,59,12],[37,0,37,13],[18,0,18,4],[68,0,68,13],[18,9,18,10],[0,0,1,13],[59,0,59,1],[59,3,59,5],[3,0,3,1],[3,6,3,7],[6,0,6,13],[7,11,7,13],[7,0,7,1],[22,0,22,1],[22,3,22,6],[7,6,7,7],[7,8,7,10],[2,0,2,13],[4,0,4,13],[5,2,5,5],[5,11,5,13],[3,8,3,10],[5,0,5,1],[5,6,5,7],[69,0,70,13],[71,0,71,13],[61,0,61,11],[67,0,67,10],[63,3,63,6],[63,7,63,8],[62,0,62,13],[64,0,64,13],[66,0,66,13],[65,0,65,5],[65,7,65,8],[65,9,65,11],[67,11,67,13],[63,0,63,1]]}
["Livestock Watering Systems-Pressure System Calculation Worksheet"]
[]
[]
["Cooperator:",null,null,null,null,null,"Service Center:",null,null,null,null,"Date:",{"$f":"TODAY()","v":"2022-08-26"}]
[]
["Conservation District:",null,null,null,null,null,"Assisted By:",null,null,null,null,null,null,null,null,1]
[]
["Tract Number:",null,null,null,null,null,"Field Number(s):"]
[]
["1. Determine the number of animals using the system:"]
["# of animals to use system:",null,null,null,"Animal Type:",null,null,null,null,"Consumption per animal per day:",null,null,null,"gallons"," ",1,1]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,2]
["# of animals to use system:",null,null,null,"Animal Type:",null,null,null,null,"Consumption per animal per day:",null,null,null,"gallons"," ",1,1]
[]
["2. Determine the water demand the animals will have per typical day:"]
["# of animals to use system:",null,null,{"$f":"IF(D11=\" \",\"\",D11)","v":0},"X",{"$f":"IF(Q11=1,\"\",VLOOKUP(Q11,'Misc. Data'!D1:'Misc. Data'!E16,2,TRUE))","v":""},"gallons/day/animal","=",{"$f":"IF(D11=\" \",0,IF(F16=\"\",0,D16*F16))","v":0},"gallons/day"]
[]
["# of animals to use system:",null,null,{"$f":"IF(D13=\" \",\"\",D13)","v":0},"X",{"$f":"IF(Q13=1,\"\",VLOOKUP(Q13,'Misc. Data'!D1:'Misc. Data'!E16,2,TRUE))","v":""},"gallons/day/animal","=",{"$f":"IF(D13=\" \",0,IF(F18=\"\",0,D18*F18))","v":0},"gallons/day"]
[null,null,null,null,null,"Total Demand",null,"=",{"$f":"I16+I18","v":0},"gallons/day"]
[]
["3. Determine Target Supply Rate (TSR): This is based on the number of planned drinking events per day, assuming each event is two hours long."]
["Enter the number of drinking events per day you are planning for (typically 2 or 3):   "]
["Total Demand of",null,{"$f":"IF(I19=0,\"\",I19)","v":""},"gallons per day divided by",null,null,null,{"$f":"IF(H22=\"\",\"\",H22*120)","v":""},null,"minutes =",{"$f":"IF(I19=0,\"\",IF(H23=\"\",\"\",C23/H23))","v":""},"gallons per minute (TSR)"]
[]
["4. Source flow rate in gallons per minute:",null,null,null,null,null,"gpm.  Value may be from a spring, well, or known pump flow rate for a planned or existing pump."]
["Select whether the Target Supply Rate or the supply rate from the source will be used in the following friction loss calculations: *See note at bottom of next page.",null,null,null,null,null,null,null,null,null,null,null,null,null,null,1]
[null,null,null,null,null,null,null,null,null,{"$f":"IF(L30=\" \",\" \",IF(L30<124.9,\" \",\"The elevation conditions entered here may result in the calculated pressure tank settings being out of a typical operating range.  System installation may be beyond a typical pressure tank setup.  This and other options must be carefully evaluated.\"))","v":" "}]
["5. Measure distance to farthest watering point:",null,null,null,null,null,null,"feet"]
[]
["6. Determine vertical elevation difference from the pressure tank to the highest watering point:",null,null,null,null,null,null,null,null,null,null,null,"feet"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,1,1]
["Select type of pipe to be used:",null,null,null,null,null,"Select Diameter of pipe to be used:",null,null,null,null,null,null,null,null,1,1]
[null,null,null,null,null,null,null,{"$f":"IF(P32=1,\"\",IF(Q32=1,\"\",IF((CHOOSE(P26,K23,F25)*0.0022282164)/(0.001736111*PI()*POWER(IF(P32=4,HLOOKUP(Q32,'Misc. Data'!A60:G61,2),HLOOKUP(Q32,'Misc. Data'!A55:G56,2)),2))<4.001,\"\",\"This pipe size passing the selected flow rate will result in a velocity higher than 4 feet/second.  It is recommended that you choose a larger pipe size.\")))","v":""}]
["7. Friction loss in the pipeline:"]
["a: Measured length of pipeline from Step 5 =",null,null,null,null,{"$f":"IF(G28=\"\",\"\",G28)","v":""},"feet"]
[]
["b: Add additional pipe lengths due to fittings.  Multiply number of fittings by their Equivalent Lengths (E.L.) and total:"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,1]
["# of fittings:",null,"Fitting type:",null,null,null,null,null,"# :",{"$f":"IF(B39=\"\",\"\",B39)","v":""},"X E.L.",{"$f":"IF(P32=1,\"\",IF(Q32=1,\"\",IF(P39=1,\"\",IF(P32=2,HLOOKUP(Q32,'Misc. Data'!A20:G27,P39),IF(P32=3,HLOOKUP(Q32,'Misc. Data'!A32:G39,P39),HLOOKUP(Q32,'Misc. Data'!A44:G51,P39))))))","v":""},"Length added (ft):",{"$f":"IF(B39=\"\",0,IF(L39=\"\",0,J39*L39))","v":0},null,1]
[]
["# of fittings:",null,"Fitting type:",null,null,null,null,null,"# :",{"$f":"IF(B41=\"\",\"\",B41)","v":""},"X E.L.",{"$f":"IF(P32=1,\"\",IF(Q32=1,\"\",IF(P41=1,\"\",IF(P32=2,HLOOKUP(Q32,'Misc. Data'!A20:G27,P41),IF(P32=3,HLOOKUP(Q32,'Misc. Data'!A32:G39,P41),HLOOKUP(Q32,'Misc. Data'!A44:G51,P41))))))","v":""},"Length added (ft):",{"$f":"IF(B41=\"\",0,IF(L41=\"\",0,J41*L41))","v":0},null,1]
[]
["# of fittings:",null,"Fitting type:",null,null,null,null,null,"# :",{"$f":"IF(B43=\"\",\"\",B43)","v":""},"X E.L.",{"$f":"IF(P32=1,\"\",IF(Q32=1,\"\",IF(P43=1,\"\",IF(P32=2,HLOOKUP(Q32,'Misc. Data'!A20:G27,P43),IF(P32=3,HLOOKUP(Q32,'Misc. Data'!A32:G39,P43),HLOOKUP(Q32,'Misc. Data'!A44:G51,P43))))))","v":""},"Length added (ft):",{"$f":"IF(B43=\"\",0,IF(L43=\"\",0,J43*L43))","v":0},null,1]
[]
["# of fittings:",null,"Fitting type:",null,null,null,null,null,"# :",{"$f":"IF(B45=\"\",\"\",B45)","v":""},"X E.L.",{"$f":"IF(P32=1,\"\",IF(Q32=1,\"\",IF(P45=1,\"\",IF(P32=2,HLOOKUP(Q32,'Misc. Data'!A20:G27,P45),IF(P32=3,HLOOKUP(Q32,'Misc. Data'!A32:G39,P45),HLOOKUP(Q32,'Misc. Data'!A44:G51,P45))))))","v":""},"Length added (ft):",{"$f":"IF(B45=\"\",0,IF(L45=\"\",0,J45*L45))","v":0},null,1]
[]
["# of fittings:",null,"Fitting type:",null,null,null,null,null,"# :",{"$f":"IF(B47=\"\",\"\",B47)","v":""},"X E.L.",{"$f":"IF(P32=1,\"\",IF(Q32=1,\"\",IF(P47=1,\"\",IF(P32=2,HLOOKUP(Q32,'Misc. Data'!A20:G27,P47),IF(P32=3,HLOOKUP(Q32,'Misc. Data'!A32:G39,P47),HLOOKUP(Q32,'Misc. Data'!A44:G51,P47))))))","v":""},"Length added (ft):",{"$f":"IF(B47=\"\",0,IF(L47=\"\",0,J47*L47))","v":0},null,1]
[]
["# of fittings:",null,"Fitting type:",null,null,null,null,null,"# :",{"$f":"IF(B49=\"\",\"\",B49)","v":""},"X E.L.",{"$f":"IF(P32=1,\"\",IF(Q32=1,\"\",IF(P49=1,\"\",IF(P32=2,HLOOKUP(Q32,'Misc. Data'!A20:G27,P49),IF(P32=3,HLOOKUP(Q32,'Misc. Data'!A32:G39,P49),HLOOKUP(Q32,'Misc. Data'!A44:G51,P49))))))","v":""},"Length added (ft):",{"$f":"IF(B49=\"\",0,IF(L49=\"\",0,J49*L49))","v":0},null,1]
[]
["# of fittings:",null,"Fitting type:",null,null,null,null,null,"# :",{"$f":"IF(B51=\"\",\"\",B51)","v":""},"X E.L.",{"$f":"IF(P32=1,\"\",IF(Q32=1,\"\",IF(P51=1,\"\",IF(P32=2,HLOOKUP(Q32,'Misc. Data'!A20:G27,P51),IF(P32=3,HLOOKUP(Q32,'Misc. Data'!A32:G39,P51),HLOOKUP(Q32,'Misc. Data'!A44:G51,P51))))))","v":""},"Length added (ft):",{"$f":"IF(B51=\"\",0,IF(L51=\"\",0,J51*L51))","v":0},null,1]
[]
["# of fittings:",null,"Fitting type:",null,null,null,null,null,"# :",{"$f":"IF(B53=\"\",\"\",B53)","v":""},"X E.L.",{"$f":"IF(P32=1,\"\",IF(Q32=1,\"\",IF(P53=1,\"\",IF(P32=2,HLOOKUP(Q32,'Misc. Data'!A20:G27,P53),IF(P32=3,HLOOKUP(Q32,'Misc. Data'!A32:G39,P53),HLOOKUP(Q32,'Misc. Data'!A44:G51,P53))))))","v":""},"Length added (ft):",{"$f":"IF(B53=\"\",0,IF(L53=\"\",0,J53*L53))","v":0},null,1]
[]
["# of fittings:",null,"Fitting type:",null,null,null,null,null,"# :",{"$f":"IF(B55=\"\",\"\",B55)","v":""},"X E.L.",{"$f":"IF(P32=1,\"\",IF(Q32=1,\"\",IF(P55=1,\"\",IF(P32=2,HLOOKUP(Q32,'Misc. Data'!A20:G27,P55),IF(P32=3,HLOOKUP(Q32,'Misc. Data'!A32:G39,P55),HLOOKUP(Q32,'Misc. Data'!A44:G51,P55))))))","v":""},"Length added (ft):",{"$f":"IF(B55=\"\",0,IF(L55=\"\",0,J55*L55))","v":0},null,1]
[]
["# of fittings:",null,"Fitting type:",null,null,null,null,null,"# :",{"$f":"IF(B57=\"\",\"\",B57)","v":""},"X E.L.",{"$f":"IF(P32=1,\"\",IF(Q32=1,\"\",IF(P57=1,\"\",IF(P32=2,HLOOKUP(Q32,'Misc. Data'!A20:G27,P57),IF(P32=3,HLOOKUP(Q32,'Misc. Data'!A32:G39,P57),HLOOKUP(Q32,'Misc. Data'!A44:G51,P57))))))","v":""},"Length added (ft):",{"$f":"IF(B57=\"\",0,IF(L57=\"\",0,J57*L57))","v":0},null,1]
[null,null,null,null,null,null,null,null,"Total length added by fittings:",null,null,null,null,{"$f":"SUM(N39:N57)","v":0}]
[]
["c: Add length due to fittings:",null,{"$f":"IF(N58=0,\"\",N58)","v":""},"feet to measured length of",null,null,{"$f":"IF(G28=\" \",\"\",G28)","v":0},"feet (from Step 5) to determine total overall length in feet =",null,null,null,null,null,{"$f":"IF(G60=\"\",\"\",IF(C60=\"\",G60,C60+G60))","v":0}]
[]
["d: Using selected pipe diameter, selected flow rate (steps 3 & 4), and friction loss equations we determine friction loss per 100 feet is:",null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(K23=\"\",\"\",IF(P32=1,\"\",IF(Q32=1,\"\",1043.8*POWER(CHOOSE(P26,K23,F25)/CHOOSE(P32,0,140,100,130),1.85)/POWER(IF(P32=4,HLOOKUP(Q32,'Misc. Data'!A60:G61,2),HLOOKUP(Q32,'Misc. Data'!A55:G56,2)),4.87))))","v":""},"feet"]
[]
["Total calculated length =",null,{"$f":"IF(N60=0,\"\",N60)","v":""},"so the calculated friction loss will be =",null,null,null,{"$f":"IF(C64=\"\",\"\",C64)","v":""},null,"/100 feet X ",{"$f":"IF(M62=\"\",0,M62)","v":0},"=",{"$f":"IF(H64=\"\",\"\",(H64/100)*K64)","v":""},"feet"]
[]
["The total friction loss for the scenario detailed above is:",null,null,null,null,null,{"$f":"IF(M64=\"\",\"\",M64)","v":""},"feet.",null,"This is equivalent to a loss of:",null,null,{"$f":"IF(G66=\"\",\"\",ROUND(G66/2.31,1))","v":""},"psi"]
[]
[]
[{"$f":"IF(M66=\"\",\" \",IF(M66=0,\" \",IF(M66<10,\"THE SELECTED FLOW RATE FLOWING THROUGH THE CHOSEN PIPE DIAMETER RESULTS IN MINIMAL FRICTION LOSS (<10psi)\",\"\")))","v":" "}]
[{"$f":"IF(M66=\"\",\" \",IF(M66>10,\"FRICTION LOSS IN THIS DIAMETER PIPE IS GREATER THAN 10 psi.  CONFIRM THAT YOU WANT TO CONTINUE WITH THIS PIPE SIZE.  IF NOT, YOU CAN RE-CALCULATE THE FRICTION LOSS USING A LARGER PIPE SIZE.\",\"\"))","v":" "}]

{"sheet":"Pressure System Worksheet Cont.","index":1,"n_rows":53,"n_cols":15,"rows_kept":53,"cut":false,"hidden":false,"merged":[[33,0,33,2],[33,4,33,7],[33,8,35,14],[31,4,31,6],[54,0,54,14],[43,0,45,14],[39,0,41,14],[42,0,42,14],[46,0,51,14],[37,0,37,5],[37,7,37,9],[37,12,37,14],[52,0,53,14],[38,0,38,14],[15,0,15,12],[18,0,18,14],[28,0,28,8],[36,0,36,14],[35,0,35,2],[35,6,35,7],[19,9,20,14],[19,6,19,8],[30,0,30,14],[29,0,29,14],[31,0,31,2],[27,0,27,6],[27,9,28,14],[31,7,32,14],[32,0,32,6],[26,0,26,14],[0,0,1,14],[5,0,5,11],[9,0,9,9],[11,0,11,12],[2,0,2,14],[3,0,3,14],[4,0,4,14],[5,13,5,14],[6,0,6,14],[7,0,7,14],[8,0,8,14],[10,0,10,14],[17,6,17,14],[23,0,23,14],[25,0,25,2],[25,7,25,14],[9,11,9,12],[19,0,19,4],[21,6,21,14],[17,0,17,4],[21,0,21,2],[20,0,20,8],[22,0,22,14],[24,0,24,14],[12,0,12,14],[14,0,14,14],[16,0,16,14],[13,0,13,12]]}
["Livestock Watering Systems-Pressure System Worksheet Continued"]
[]
[]
["8. Expected or needed pressure at most remote watering point (may vary depending on type of float)."]
[]
["Use manufacturer's recommended minimum pressure or 10 psi, whichever is greater.  Use Pressure at Outlet =",null,null,null,null,null,null,null,null,null,null,null,null,"psi"]
[]
["9. Operating pressure at the pressure tank"]
[]
["Pressure losses due to elevation differences equals the elevation difference determined in Step 6:",null,null,null,null,null,null,null,null,null,{"$f":"IF('Pressure System Calc. Worksheet'!L30=\"\",\"\",'Pressure System Calc. Worksheet'!L30)","v":""},"divided by 2.31=",null,{"$f":"IF(K10=\"\",0,K10/2.31)","v":0},"psi"]
[]
["Friction Loss determined in Step 7:",null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF('Pressure System Calc. Worksheet'!M66=\"\",0,'Pressure System Calc. Worksheet'!M66)","v":0},"psi"]
[]
["Pressure needed at Outlet:",null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(M6=\" \",0,M6)","v":0},"psi"]
[]
["Total =",null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"N10+N12+N14","v":0},"psi"]
[]
["Round to the nearest multiple of 10=",null,null,null,null,{"$f":"IF(N16=0,\"\",IF(N16>79.99,\"Note@Right\",IF(N16<20,20,IF(N16>59.99,60,IF((FLOOR(N16,10)+6.999)<N16,CEILING(N16,10),FLOOR(N16,10))))))","v":""},"psi. This is the lower setting of the pressure switch.  A minimum setting of 20 psi will be used."]
[]
["Add 20 to the lower setting =",null,null,null,null,{"$f":"IF(F18=\"\",\"\",IF(N16>79.99,\"Note@Right\",F18+20))","v":""},"psi. This is the higher setting.",null,null,{"$f":"IF(N16<79.999,\"\",\"Total pressure calculated above exceeds 80 psi.  Design will need to be modified.\")","v":""}]
["  A maximum of 80 psi will be used only when the pressure tank is rated for such a pressure."]
["Use a pressure switch setting of:",null,null,{"$f":"IF(F18=\"\",\"\",IF(N16>79.99,\"\",F18))","v":""},"/",{"$f":"IF(F20=\"\",\"\",IF(N16>79.99,\"\",F20))","v":""},"psi.  Make sure a minimum setting of 20/40 psi has been calculated."]
[]
["10. Convert needed data to dynamic head added to the pump by livestock watering system:"]
[]
["Multiply higher switch setting:",null,null,{"$f":"IF(F22=\"\",\"\",F22)","v":""},"X","2.31=",{"$f":"IF(D26=\"\",\"\",IF(N16>79.99,\"\",D26*2.31))","v":""},"feet.  This is the dynamic head added to the pump by the watering system."]
[]
["Dynamic Head added to pump by watering system:",null,null,null,null,null,null,{"$f":"IF(G26=\"\",\"\",G26)","v":""},"feet.","This is not Total Dynamic Head but rather the amount of head added to that total by the planned livestock watering system."]
[]
["11. Compile the system requirements into a list that the pump supplier can use to size the pump."]
[]
["Pump to provide a minimum of:",null,null,{"$f":"IF('Pressure System Calc. Worksheet'!K23=\"\",\"\",CHOOSE('Pressure System Calc. Worksheet'!P26,'Pressure System Calc. Worksheet'!K23,'Pressure System Calc. Worksheet'!F25))","v":""},"gallons per minute.",null,null,"  (This value is dependent on whether you selected the Target Supply Rate or the source rate as the basis for the design calculations.)"]
[]
["The system is adding",null,null,{"$f":"IF(H28=\"\",\"\",H28)","v":""},"feet to the pump's dynamic head.",null,null,null,"Total Dynamic Head will equal this number plus the 'Lift' Head required to get the water from the water source to the pressure tank.  The flow rate and the Total Dynamic Head will be used to size the pump for the project."]
[]
["The pressure switch setting is:",null,null,{"$f":"IF(D22=\"\",\"\",D22)","v":""},"/",{"$f":"IF(F22=\"\",\"\",F22)","v":""},"psi."]
[]
["Pressure tank will have minimum effective drawdown of:",null,null,null,null,null,{"$f":"IF(D32=\"\",\"\",D32)","v":""},"(supply rate) X 1 (minimum) =",null,null,{"$f":"IF(G38=\"\",\"\",G38)","v":""},"gallons."]
[]
["The effective drawdown is sized so that the pump will come on and operate for a minimum of one minute before shutting off.  One minute operating time reduces wear on the pump caused by excessive starting and stopping.  The pressure tank may be sized to have an effective drawdown of two, three, or more times greater than the pumping rate.  But a minimum effective drawdown of one times the pumping rate should be provided."]
[]
[]
[]
["* The user should choose a value based on whether you are designing a system to match the Target Supply Rate or whether you are using a known value for the pumping rate in gallons per minute.  If you select TSR from the dropdown menu, then the design will be based on pumping that amount.  Otherwise, if you want to pump 8 gallons a minute, for example, then you should enter 8 gpm in step 4 and select 'Rate from Source' from the dropdown menu.  The remaining calculations will be based on this value."]
[]
[]
["The Target Supply Rate is a design number based on trying to deliver water to the livestock over a selected number of 2-hour drinking events.  When designing a watering system with no existing components it can be used as the basis for the sizing of the pump.  Where a source already exists (a well with a given yield, a spring to be collected in the reservoir, etc.) you should attempt to match the pump rate to the source yield.  Where the pumping rate is planned to be higher than the source yield, the designer will need to ensure there is adequate storage (water column in a well, storage in a reservoir, etc.) so the pump does not draw the water level below the pump intake."]
[]
[]
[]
[]
[]
["You can also overcome low source yield or pumping rates by providing storage in reservoirs that will supply the troughs by gravity or by providing additional storage at the watering location through the use of larger concrete troughs."]

{"sheet":"Misc. Data","index":2,"n_rows":67,"n_cols":14,"rows_kept":67,"cut":false,"hidden":true,"merged":[]}
[1,null,null,1,null,null,1,null,null,null,1,null,1]
[2,"Beef Cattle",null,2,2,null,2,"Plastic","1/2\"",null,2,"Insert Coupling",2,"Adams CD"]
[3,"Beef Calves",null,3,3,null,3,"Steel","3/4\"",null,3,"Threaded adapter-Plastic or Copper to thread",3,"Allegheny CD"]
[4,"Milking Cows",null,4,4,null,4,"Copper","1\"",null,4,"90 degree standard elbow",4,"Armstrong CD"]
[5,"Dry Cows",null,5,5,null,5,null,"1-1/4\"",null,5,"Standard tee, straight flow thru run",5,"Beaver CD"]
[6,"Sheep",null,6,6,null,6,null,"1-1/2\"",null,6,"Standard tee, turn flow thru",6,"Bedford CD"]
[7,"Swine",null,7,8,null,7,null,"2\"",null,7,"Gate or ball valve",7,"Berks CD"]
[8,"Horse",null,8,10,null," ",null,null,null,8,"Swing check valve",8,"Blair CD"]
[9,null,null,9,12,null,null,null,null,null,null," ",9,"Bradford CD"]
[null,null,null,10,15,null,null,null,null,null,null,null,10,"Bucks CD"]
["Target Supply Rate",null,null,11,20,null,null,null,null,null,null,null,11,"Butler Cd"]
["Rate from Source",null,null,12,25,null,null,null,null,null,null,null,12,"Cambria CD"]
[null,null,null,13,30,null,null,null,null,null,null,null,13,"Cameron CD"]
[null,null,null,14,35,null,null,null,null,null,null,null,14,"Carbon CD"]
[null,null,null,15,40,null,null,null,null,null,null,null,15,"Centre CD"]
[null,null,null,16,null,null,null,null,null,null,null,null,16,"Chester CD"]
[null,null,null,null,null,null,null,null,null,null,null,null,17,"Clarion CD"]
["Equivalent Length Values for Plastic Pipe",null,null,null,null,null,null,null,null,null,null,null,18,"Clearfield CD"]
[null,"1/2\"","3/4\"","1\"","1-1/4\"","1-1/2\"","2\"",null,null,null,null,null,19,"Clinton CD"]
[1,2,3,4,5,6,7,null,null,null,null,null,20,"Columbia CD"]
["P31=2",3,3,3,3,3,3,null,null,null,null,null,21,"Crawford CD"]
["P31=3",3,3,3,3,3,3,null,null,null,null,null,22,"Cumberland CD"]
["P31=4",4,5,6,7,8,9," ",null,null,null,null,23,"Dauphin CD"]
["P31=5",4,4,4,5,6,7,null,null,null,null,null,24,"Delaware CD"]
["P31=6",7,8,9,12,13,17,null,null,null,null,null,25,"Elk CD"]
["P31=7",4,6,8,10,12,14,null,null,null,null,null,26,"Erie CD"]
["P31=8",8,10,14,18,22,26,null,null,null,null,null,27,"Fayette CD"]
[" "," "," "," "," "," "," ",null,null,null,null,null,28,"Forest CD"]
[null,null,null,null,null,null,null,null,null,null,null,null,29,"Franklin CD"]
["Equivalent Length Values for Steel Pipe",null,null,null,null,null,null,null,null,null,null,null,30,"Fulton CD"]
[null,"1/2\"","3/4\"","1\"","1-1/4\"","1-1/2\"","2\"",null,null,null,null,null,31,"Greene CD"]
[1,2,3,4,5,6,7,null,null,null,null,null,32,"Huntingdon CD"]
["P31=2",0,0,0,0,0,0,null,null,null,null,null,33,"Indiana CD"]
["P31=3",0,0,0,0,0,0,null,null,null,null,null,34,"Jefferson CD"]
["P31=4",2,3,3,4,4,5,null,null,null,null,null,35,"Juniata CD"]
["P31=5",1,2,2,3,3,4,null,null,null,null,null,36,"Lackawanna CD"]
["P31=6",4,5,6,8,9,11,null,null,null,null,null,37,"Lancaster CD"]
["P31=7",2,3,4,5,6,7,null,null,null,null,null,38,"Lawrence CD"]
["P31=8",4,5,7,9,11,13,null,null,null,null,null,39,"Lebanon CD"]
[null,null,null,null,null,null,null,null,null,null,null,null,40,"Lehigh CD"]
[null,null,null,null,null,null,null,null,null,null,null,null,41,"Luzerne CD"]
["Equivalent Length Values for Copper Pipe",null,null,null,null,null,null,null,null,null,null,null,42,"Lycoming CD"]
[null,"1/2\"","3/4\"","1\"","1-1/4\"","1-1/2\"","2\"",null,null,null,null,null,43,"McKean CD"]
[1,2,3,4,5,6,7,null,null,null,null,null,44,"Mercer CD"]
["P31=2",0,0,0,0,0,0,null,null,null,null,null,45,"Mifflin CD"]
["P31=3",1,1,1,1,1,1,null,null,null,null,null,46,"Monroe CD"]
["P31=4",2,3,3,4,4,5,null,null,null,null,null,47,"Montgomery CD"]
["P31=5",1,2,2,3,3,4,null,null,null,null,null,48,"Montour CD"]
["P31=6",4,5,6,8,9,11,null,null,null,null,null,49,"Northampton CD"]
["P31=7",2,3,4,5,6,7,null,null,null,null,null,50,"Northumberland CD"]
["P31=8",4,5,7,9,11,13,null,null,null,null,null,51,"Perry CD"]
[null,null,null,null,null,null,null,null,null,null,null,null,52,"Pike CD"]
["Actual Diameters for Steel and Plastic Pipe",null,null,null,null,null,null,null,null,null,null,null,53,"Potter CD"]
[null,"1/2\"","3/4\"","1\"","1-1/4\"","1-1/2\"","2\"",null,null,null,null,null,54,"Schuylkill CD"]
[1,2,3,4,5,6,7,null,null,null,null,null,55,"Snyder CD"]
[null,0.622,0.82399999999999995,1.0489999999999999,1.38,1.61,2.0670000000000002,null,null,null,null,null,56,"Somerset CD"]
[null,null,null,null,null,null,null,null,null,null,null,null,57,"Sullivan CD"]
["Actual Diameters for Copper Pipe",null,null,null,null,null,null,null,null,null,null,null,58,"Susquehanna CD"]
[null,"1/2\"","3/4\"","1\"","1-1/4\"","1-1/2\"","2\"",null,null,null,null,null,59,"Tioga CD"]
[1,2,3,4,5,6,7,null,null,null,null,null,60,"Union CD"]
[null,0.54500000000000004,0.78500000000000003,1.0249999999999999,1.2649999999999999,1.5049999999999999,1.9850000000000001,null,null,null,null,null,61,"Venango CD"]
[null,null,null,null,null,null,null,null,null,null,null,null,62,"Warren CD"]
[null,null,null,null,null,null,null,null,null,null,null,null,63,"Washington CD"]
[null,null,null,null,null,null,null,null,null,null,null,null,64,"Wayne CD"]
[null,null,null,null,null,null,null,null,null,null,null,null,65,"Westmoreland CD"]
[null,null,null,null,null,null,null,null,null,null,null,null,66,"Wyoming CD"]
[null,null,null,null,null,null,null,null,null,null,null,null,67,"York CD"]