{"text_format":"1","workbook":"xlsx","n_sheets":10,"sheets":["Intro.","Macros","Worksht1 - Field Flow","Worksht2 - Pump Sizing","Parts List ","T1-Dripline","T2-Filter & Headworks","T3-Valves","T4-PVC PLUS","T5-Flow meter"],"not_rendered":{"charts":0,"images":13,"macros":1,"external_links":2,"defined_names":7,"comments":4,"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":"Intro.","index":0,"n_rows":29,"n_cols":16,"rows_kept":29,"cut":false,"hidden":false,"merged":[]}
[]
[]
[]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Updated Jan. 2015"]
[null,"Basic Design Spreadsheet for Small Residential Systems"]
[]
[null,null,"This spreadsheet serves as a guide for small systems, and is not a complete hydraulic design.  Please check parameters for large systems."]
[]
[null,null,"The green tabs below are the worksheets, and the purple tabs are the tables including parts data."]
[null,null,"Shaded cells on the worksheets ","require inputs from you. ",null,null,null,null,"shaded"," unshaded"]
[null,null,"Scroll mouse over small red flags to see associated Notes"]
[]
[null,null,"\"Worksheet 1 - Field Calculation\" is your starting point.  It will help you determine how much flow is required"]
[null,null,"to disperse a given amount of effluent in a given soil.  These calculations are based on using secondary treated wastewater."]
[null,null,"You can play with the dripline and spacing to increase or decrease the flow per minute."]
[null,null,"Note at the bottom of this worksheet is a small spreadsheet used to determine if there is enough time in the day to disperse the effluent with"]
[null,null,"the chosen zone, dripline and spacing configurations."]
[null,null,"This program makes the assumption that all zones are equal in size.  If not, run the program zone by zone "]
[]
[null,null,"\"Worksheet 2 - Pump Sizing\" adds the pressure required to the flow rates as figured in Worksheet 1 so pumps can be selected."]
[]
[]
[null,null,"       Note:  These spreadsheets do allow for increased flow for flushing as required by some regulatotory authorities."]
[null,null,"                 For more comprehensive flushing velocity head losses please see Geoflow's Flow and Flush Spreadsheet."]
[]
[null,null,"Should you have any questions, please call 800-828-3388 9am - 5pm Pacific time, or call your local representative."]
[null,null,"www.geoflow.com"]
[]
[null,null,"Updates to this spreadsheet are regularly available at www.geoflow.com"]

{"sheet":"Macros","index":1,"n_rows":285,"n_cols":26,"rows_kept":285,"cut":false,"hidden":true,"merged":[[133,4,134,4],[266,7,266,13],[267,7,267,13],[268,7,268,13],[262,7,262,13],[263,7,263,13],[264,7,264,13],[265,7,265,13],[258,7,258,13],[259,7,259,13],[260,7,260,13],[261,7,261,13],[268,0,268,6],[263,0,263,6],[264,0,264,6],[265,0,265,6],[266,0,266,6],[258,0,258,6],[259,0,259,6],[267,0,267,6],[262,0,262,6],[261,0,261,6],[260,0,260,6]]}
["MACROS - DO NOT CHANGE THE DATA ON THIS FORM. THIS DATA IS USED IN YOUR WORKSHEET!"]
[]
["Dripline Box",null,null,null,null,"E24 Dripline Multizone Column",null,null,null,"D21 Dripline Spacing Box"]
["Wasteflow Classic",null,null,null,null,{"$f":"IF('Worksht1 - Field Flow'!$E$25=2,\"Wasteflow PC 1/2 gph\",F5)","v":"Consult factory"},null,null,null,1,"0.5 ft.",2]
["Wasteflow PC - 1/2gph",null,null,null,null,{"$f":"IF('Worksht1 - Field Flow'!$E$25=3,\"Wasteflow PC 1 gph\",F6)","v":"Consult factory"},null,null,null,2,"1 ft.",{"$f":"IF(L4=2,1,L6)","v":1}]
["Wasteflow PC - 1 gph",null,null,null,null,"Consult factory",null,null,null,3,"1.5 ft.",{"$f":"IF(L4=3,1.5,L7)","v":"Consult factory"}]
[null,null,null,null,null,null,null,null,null,4,"2 ft.",{"$f":"IF(L4=4,2,L8)","v":"Consult factory"}]
["D26 Pressure",null,null,null,null,null,null,null,null,null,null,"Consult factory"]
[1,10,3]
[2,15,{"$f":"IF(Macros!$C$9=2,15,C11)","v":20}]
[3,20,{"$f":"IF(Macros!$C$9=3,20,C12)","v":20}]
[4,25,{"$f":"IF(Macros!$C$9=4,25,C13)","v":"Consult factory"}]
[5,30,{"$f":"IF(Macros!$C$9=5,30,C14)","v":"Consult factory"}]
[6,35,{"$f":"IF(Macros!$C$9=6,35,C15)","v":"Consult factory"}]
[7,40,{"$f":"IF(Macros!$C$9=7,40,C16)","v":"Consult factory"}]
[8,45,{"$f":"IF(Macros!$C$9=8,45,C17)","v":"Consult factory"}]
[null,null,"Consult factory"]
[]
[]
["A28 Emitter Flow Rate"]
[{"$f":"IF('Worksht1 - Field Flow'!$E$25=A4,B21,A22)","v":"Check dripline tables"},{"$f":"IF('Worksht1 - Field Flow'!E30=10,0.81,C21)","v":1.1599999999999999},{"$f":"IF('Worksht1 - Field Flow'!E30=15,1,D21)","v":1.1599999999999999},{"$f":"IF('Worksht1 - Field Flow'!E30=20,1.16,E21)","v":1.1599999999999999},{"$f":"IF('Worksht1 - Field Flow'!E30=25,1.31,F21)","v":"Call Geoflow"},{"$f":"IF('Worksht1 - Field Flow'!E30=30,1.44,G21)","v":"Call Geoflow"},{"$f":"IF('Worksht1 - Field Flow'!E30=35,1.57,H21)","v":"Call Geoflow"},{"$f":"IF('Worksht1 - Field Flow'!E30=40,1.68,I21)","v":"Call Geoflow"},{"$f":"IF('Worksht1 - Field Flow'!E30=45,1.8,J21)","v":"Call Geoflow"},{"$f":"IF('Worksht1 - Field Flow'!E30=50,1.92,K21)","v":"Call Geoflow"},"Call Geoflow"]
[{"$f":"IF('Worksht1 - Field Flow'!E25=A6,1.02,A23)","v":"Check dripline tables"}]
["Check dripline tables"]
[]
["E31 Multizone Pipe size"]
[{"$f":"IF('Worksht2 - Pump Sizing'!D18<=3.999,\".5\",A27)","v":".5"},{"$f":"IF('Worksht2 - Pump Sizing'!D17<=3.999,\".5\",B27)","v":".5"},null,null,"PMR 15",15]
[{"$f":"IF('Worksht2 - Pump Sizing'!D18<=5,\".75\",A28)","v":".75"},{"$f":"IF('Worksht2 - Pump Sizing'!D17<=5,\".75\",B28)","v":".75"},null,null,"PMR 20",20]
[{"$f":"IF('Worksht2 - Pump Sizing'!D18<=10,\"1\",A29)","v":"1"},{"$f":"IF('Worksht2 - Pump Sizing'!D17<=10,\"1\",B29)","v":"1"},null,null,"PMR 25",25]
[{"$f":"IF('Worksht2 - Pump Sizing'!D18<=20,\"1.25\",A30)","v":"1.25"},{"$f":"IF('Worksht2 - Pump Sizing'!D17<=20,\"1.25\",B30)","v":"1.25"},null,null,"PMR 30",30]
[{"$f":"IF('Worksht2 - Pump Sizing'!D18<=30,\"1.5\",A31)","v":"1.5"},{"$f":"IF('Worksht2 - Pump Sizing'!D17<=30,\"1.5\",B31)","v":"1.5"},null,null,"PMR 35",35]
[{"$f":"IF('Worksht2 - Pump Sizing'!D18<=50,\"2\",A32)","v":"2"},{"$f":"IF('Worksht2 - Pump Sizing'!D17<=50,\"2\",B32)","v":"2"},null,null,"PMR 40",40]
[{"$f":"IF('Worksht2 - Pump Sizing'!D18<=70,\"2.5\",A33)","v":"2.5"},{"$f":"IF('Worksht2 - Pump Sizing'!D17<=70,\"2.5\",B33)","v":"2.5"},null,null,"PMR 45",45]
[{"$f":"IF('Worksht2 - Pump Sizing'!D18<=100,\"3\",A34)","v":"3"},{"$f":"IF('Worksht2 - Pump Sizing'!D17<=100,\"3\",B34)","v":"3"},null,null,"PMR 50",50]
[{"$f":"IF('Worksht2 - Pump Sizing'!D18<=175,\"4\",A35)","v":"4"},{"$f":"IF('Worksht2 - Pump Sizing'!D17<=175,\"4\",B35)","v":"4"}]
[{"$f":"IF('Worksht2 - Pump Sizing'!D18<=200,\"6\",\"Flow exceeds capacity of spreadsheet\")","v":"6"},{"$f":"IF('Worksht2 - Pump Sizing'!D17<=200,\"6\",\"Flow exceeds capacity of spreadsheet\")","v":"6"}]
[]
["Select Filter"]
["Vortex Screen Filter"]
["BioDisc Filter"]
["BioDisc Self Flushing Battery"]
[null,null,null,null,null,55,84,110]
["E30 Filter selection"]
[{"$f":"IF('Worksht1 - Field Flow'!$E$45=Macros!A38,Macros!B44,Macros!A49)","v":"ConsultFActory"}]
["Vortex Filters",{"$f":"IF('Worksht1 - Field Flow'!$E$14<=350,C44,D44)","v":"AP4E-1.5F"},{"$f":"IF('Worksht1 - Field Flow'!$E$43<=20,A45,D44)","v":"AP4E-1F"},{"$f":"IF('Worksht1 - Field Flow'!$E$43<=45,A46,E44)","v":"AP4E-1.5F"},{"$f":" IF('Worksht1 - Field Flow'!$E$43<=70,A47,#REF!)","v":"AP4E-2F"},"Consult Factory"]
["AP4E-1F","1in Screen Filter 0-20gpm"]
["AP4E-1.5F","1.5in  Screen Filter 0-45gpm",{"$f":"IF('Worksht1 - Field Flow'!$E$46=Macros!A46,Macros!B45,Macros!C47)","v":"Select"}]
["AP4E-2F","2in Screen Filter 30-70gpm",{"$f":"IF('Worksht1 - Field Flow'!$E$46=Macros!A47,Macros!B46,Macros!C48)","v":"Select"}]
["AP4E-2F",null,{"$f":"IF('Worksht1 - Field Flow'!$E$46=Macros!A48,Macros!B47,Macros!C51)","v":"Select"}]
[{"$f":"IF('Worksht1 - Field Flow'!E45=Macros!A39,B50,A56)","v":"ConsultFActory"}]
["BioDisc Filter",{"$f":"IF('Worksht1 - Field Flow'!$E$14>2500,\"Call Geoflow\",C50)","v":"BioDisc Filter-150"},{"$f":"IF('Worksht1 - Field Flow'!$E$33<=30,A51,D50)","v":"BioDisc Filter-150"},{"$f":"IF('Worksht1 - Field Flow'!$E$33<=60,A52,E50)","v":"BioDisc Filter-200"},"Flow Rate Too High"]
["BioDisc Filter-150","1.5in  < 30 gpm",{"$f":"IF('Worksht1 - Field Flow'!$E$46=Macros!A51,Macros!B51,Macros!C52)","v":"Select"}]
["BioDisc Filter-200","2in   30-60 gpm",{"$f":"IF('Worksht1 - Field Flow'!$E$46=Macros!A52,Macros!B52,Macros!C53)","v":"Select"}]
[null,null,{"$f":"IF('Worksht1 - Field Flow'!$E$46=Macros!A53,Macros!B53,Macros!C54)","v":"Select"}]
[null,null,{"$f":"IF('Worksht1 - Field Flow'!$E$46=Macros!A54,Macros!B54,Macros!C55)","v":"Select"}]
[null,null,{"$f":"IF('Worksht1 - Field Flow'!$E$46=Macros!A55,Macros!B55,Macros!C59)","v":"Select"}]
[{"$f":"IF('Worksht1 - Field Flow'!E45=Macros!A40,B57,\"ConsultFActory\")","v":"ConsultFActory"}]
["BioDisc Battery",{"$f":"IF('Worksht1 - Field Flow'!$E$43<=35,A59,C57)","v":"BioDisc Battery 2"},{"$f":"IF('Worksht1 - Field Flow'!$E$43<=70,A59,D57)","v":"BioDisc Battery 2"},{"$f":"IF('Worksht1 - Field Flow'!$E$43<=140,A60,E57)","v":"BioDisc Battery  4"},{"$f":"IF('Worksht1 - Field Flow'!$E$43<=210,A61,F57)","v":"BioDisc Battery  6"},{"$f":"IF('Worksht1 - Field Flow'!$E$43<=280,A62,G57)","v":"BioDisc Battery 8"},"Consult factory"]
["Biodisc Battery requires 40gpm/40psi to flush"]
["BioDisc Battery 2","40-70 gpm / 40 psi",{"$f":"IF('Worksht1 - Field Flow'!$E$46=Macros!A59,Macros!B59,Macros!C60)","v":"Select"}]
["BioDisc Battery  4","40-140 gpm  40 psi",{"$f":"IF('Worksht1 - Field Flow'!$E$46=Macros!A60,Macros!B60,Macros!C61)","v":"Select"}]
["BioDisc Battery  6","40-210 gpm  40psi","Select"]
["BioDisc Battery 8","40-280 gpm  40psi"]
[]
["E35 Multizone Valve selection"]
["Hydraulic"]
["Electric Solenoid"]
["None"]
[{"$f":"IF('Worksht1 - Field Flow'!E47=\"Select\",\"Select valve above\",Macros!A69)","v":"SVLVB-100"}]
[{"$f":"IF('Worksht1 - Field Flow'!E47=Macros!A67,0,Macros!A70)","v":"SVLVB-100"},null,null,null,null,{"$f":"IF('Worksht1 - Field Flow'!E47=Macros!A65,Macros!F70,\"call Geoflow\")","v":"call Geoflow"}]
[{"$f":"IF('Worksht1 - Field Flow'!E47=Macros!A66,Macros!A71,F69)","v":"SVLVB-100"},null,null,null,null,{"$f":"IF('Worksht1 - Field Flow'!$E$19=1,\"No valve required\",Macros!F71)","v":"No valve required"},null,"No zone valve required"]
[{"$f":"IF('Worksht1 - Field Flow'!$E$43<=25,B72,A72)","v":"SVLVB-100"},null,null,null,null,{"$f":"IF('Worksht1 - Field Flow'!$E$19=2,H71,Macros!F72)","v":"Check zone quantity"},null,"HT-4402","HT-4402-RCW     ","2 zone Index valve 1.25x1.25\", 25-75psi, >9gpm",{"$f":"IF('Worksht1 - Field Flow'!$E$48=Macros!H71,Macros!J71,Macros!K72)","v":0}]
[{"$f":"IF('Worksht1 - Field Flow'!$E$43<=90,B73,A73)","v":"SVLVB-150"},{"$f":"'T3-Valves'!B4","v":"SVLVB-100"},"1-in. Solenoid valve",null,null,{"$f":"IF('Worksht1 - Field Flow'!$E$19=3,H72,Macros!F73)","v":"Check zone quantity"},null,"HT-4403","HT-4403-RCW","3 zone Index valve 1.25x1.25\", 25-75psi, >9gpm",{"$f":"IF('Worksht1 - Field Flow'!$E$48=Macros!H72,Macros!J72,Macros!K73)","v":0}]
[{"$f":"IF('Worksht1 - Field Flow'!$E$43<=200,B74,A74)","v":"SVLVB-200"},{"$f":"'T3-Valves'!B5","v":"SVLVB-150"},"1.5-in. Solenoid valve",{"$f":"IF('Worksht1 - Field Flow'!$E$48=Macros!B73,Macros!C73,Macros!D74)","v":0},null,{"$f":"IF('Worksht1 - Field Flow'!$E$19=4,H73,Macros!F74)","v":"Check zone quantity"},null,"HT-4404","HT-4404-RCW","4 zone Index valve 1.25x1.25\", 25-75psi, >9gpm",{"$f":"IF('Worksht1 - Field Flow'!$E$48=Macros!H73,Macros!J73,Macros!K74)","v":0}]
[{"$f":"IF('Worksht1 - Field Flow'!$E$43<=400,B75,A75)","v":"SVLVB-300"},{"$f":"'T3-Valves'!B6","v":"SVLVB-200"},"2-in. Solenoid valve",{"$f":"IF('Worksht1 - Field Flow'!$E$48=Macros!B74,Macros!C74,Macros!D75)","v":0},null,{"$f":"IF('Worksht1 - Field Flow'!$E$19=5,H74,Macros!F75)","v":"Check zone quantity"},null,"HT-4605",null,"5 zone Index valve 1.25x1\", 25-75psi, >9gpm",{"$f":"IF('Worksht1 - Field Flow'!$E$48=Macros!H74,Macros!J74,Macros!K75)","v":0}]
["Flow too high for this spreadsheet",{"$f":"'T3-Valves'!B7","v":"SVLVB-300"},"3-in. Solenoid valve",{"$f":"IF('Worksht1 - Field Flow'!$E$48=Macros!B75,Macros!C75,Macros!K71)","v":0},null,{"$f":"IF('Worksht1 - Field Flow'!$E$19=6,H75,Macros!F76)","v":"Check zone quantity"},null,"HT-4606",null,"6 zone Index valve 1.25x1\", 25-75psi, >9gpm",{"$f":"IF('Worksht1 - Field Flow'!$E$48=Macros!H75,Macros!J75,Macros!K76)","v":0}]
[null,null,null,null,null,{"$f":"IF('Worksht1 - Field Flow'!$E$19>6,\"Max of 6 zones\",\"Check zone quantity\")","v":"Check zone quantity"}]
[null,null,null,null,null,null,null,null,"Single Hydrotek has 6 zones max"]
[null,null,null,null,null,null,null,null,"Hydrotech valve min flow rate = 10gpm"]
[null,null,null,null,null,null,null,null,"HT-4602-RCW","2 zone Hydratek valve 1.25\" x 1\", 25-75psi, min10gpm"]
[null,null,null,null,null,null,null,null,"HT-4603-RCW","3 zone Hydratek valve 1.25\" x 1\", 25-75psi, min10gpm"]
[null,null,null,null,null,null,null,null,"HT-4604-RCW","4 zone Hydratek valve 1.25\" x 1\", 25-75psi, min10gpm"]
[]
[]
[]
[]
[]
[]
["D33 Max length of run"]
["Classic","PC 1/2 gph",null,null,null,"PC 1 gph"]
[null,"6\"","12\"","18\"","24\"","6\"","12\"","18\"","24\""]
[{"$f":"IF('Worksht1 - Field Flow'!$E$25=A4,A92,B91)","v":424},{"$f":"IF('Worksht1 - Field Flow'!$E$25=A5,B92,F91)","v":424},null,null,null,{"$f":"IF('Worksht1 - Field Flow'!$E$25=A6,F92,\"Check Dripline\")","v":"Check Dripline"}]
[{"$f":"IF('Worksht1 - Field Flow'!$E$22=1,120,A93)","v":210},{"$f":"IF('Worksht1 - Field Flow'!$E$22=0.5,B93,C92)","v":424},{"$f":"IF('Worksht1 - Field Flow'!$E$22=1,C93,D92)","v":424},{"$f":"IF('Worksht1 - Field Flow'!$E$22=1.5,D93,E92)","v":424},{"$f":"IF('Worksht1 - Field Flow'!$E$22=2,E93,\"Phone Geoflow\")","v":424},{"$f":"IF('Worksht1 - Field Flow'!$E$22=0.5,F93,G92)","v":265},{"$f":"IF('Worksht1 - Field Flow'!$E$22=1,G93,H92)","v":265},{"$f":"IF('Worksht1 - Field Flow'!$E$22=1.5,H93,I92)","v":265},{"$f":"IF('Worksht1 - Field Flow'!$E$22=2,I93,\"Check dripline spacing\")","v":265}]
[{"$f":"IF('Worksht1 - Field Flow'!$E$22=1.5,208,A94)","v":210},{"$f":"IF('Worksht1 - Field Flow'!E30=10,50,B94)","v":100},{"$f":"IF('Worksht1 - Field Flow'!E30=10,150,C94)","v":229},{"$f":"IF('Worksht1 - Field Flow'!E30=10,200,D94)","v":330},{"$f":"IF('Worksht1 - Field Flow'!E30=10,280,E94)","v":424},{"$f":"IF('Worksht1 - Field Flow'!E30=10,50,F94)","v":75},{"$f":"IF('Worksht1 - Field Flow'!E30=10,95,G94)","v":146},{"$f":"IF('Worksht1 - Field Flow'!E30=10,120,H94)","v":210},{"$f":"IF('Worksht1 - Field Flow'!E30=10,175,I94)","v":265},"10 PSI"]
[{"$f":"IF('Worksht1 - Field Flow'!$E$22=2,210,A95)","v":210},{"$f":"IF('Worksht1 - Field Flow'!E30=15,100,B95)","v":100},{"$f":"IF('Worksht1 - Field Flow'!E30=15,174,C95)","v":229},{"$f":"IF('Worksht1 - Field Flow'!E30=15,260,D95)","v":330},{"$f":"IF('Worksht1 - Field Flow'!E30=15,321,E95)","v":424},{"$f":"IF('Worksht1 - Field Flow'!E30=15,60,F95)","v":75},{"$f":"IF('Worksht1 - Field Flow'!E30=15,115,G95)","v":146},{"$f":"IF('Worksht1 - Field Flow'!E30=15,172,H95)","v":210},{"$f":"IF('Worksht1 - Field Flow'!E30=15,211,I95)","v":265},"15 PSI"]
[{"$f":"IF('Worksht1 - Field Flow'!$E$22=0.5,\"6-in Classic not avail.\",\"Phone Geoflow\")","v":"Phone Geoflow"},{"$f":"IF('Worksht1 - Field Flow'!E30=20,100,B96)","v":100},{"$f":"IF('Worksht1 - Field Flow'!E30=20,229,C96)","v":229},{"$f":"IF('Worksht1 - Field Flow'!E30=20,330,D96)","v":330},{"$f":"IF('Worksht1 - Field Flow'!E30=20,424,E96)","v":424},{"$f":"IF('Worksht1 - Field Flow'!E30=20,75,F96)","v":75},{"$f":"IF('Worksht1 - Field Flow'!E30=20,146,G96)","v":146},{"$f":"IF('Worksht1 - Field Flow'!E30=20,210,H96)","v":210},{"$f":"IF('Worksht1 - Field Flow'!E30=20,265,I96)","v":265},"20 PSI"]
[null,{"$f":"IF('Worksht1 - Field Flow'!E30=25,140,B97)","v":"Check Pressure"},{"$f":"IF('Worksht1 - Field Flow'!E30=25,260,C97)","v":"Check Pressure"},{"$f":"IF('Worksht1 - Field Flow'!E30=25,377,D97)","v":"Check pressure"},{"$f":"IF('Worksht1 - Field Flow'!E30=25,478,E97)","v":"Check Pressure"},{"$f":"IF('Worksht1 - Field Flow'!E30=25,85,F97)","v":"Check pressure"},{"$f":"IF('Worksht1 - Field Flow'!E30=25,171,G97)","v":"Check Pressure"},{"$f":"IF('Worksht1 - Field Flow'!E30=25,242,H97)","v":"Check Pressure"},{"$f":"IF('Worksht1 - Field Flow'!E30=25,315,I97)","v":"Phone Geoflow"},"25 PSI"]
[null,{"$f":"IF('Worksht1 - Field Flow'!E30=30,150,B98)","v":"Check Pressure"},{"$f":"IF('Worksht1 - Field Flow'!E30=30,288,C98)","v":"Check Pressure"},{"$f":"IF('Worksht1 - Field Flow'!E30=30,415,D98)","v":"Check pressure"},{"$f":"IF('Worksht1 - Field Flow'!E30=30,535,E98)","v":"Check Pressure"},{"$f":"IF('Worksht1 - Field Flow'!E30=30,95,F98)","v":"Check pressure"},{"$f":"IF('Worksht1 - Field Flow'!E30=30,180,G98)","v":"Check Pressure"},{"$f":"IF('Worksht1 - Field Flow'!E30=30,266,H98)","v":"Check Pressure"},{"$f":"IF('Worksht1 - Field Flow'!E30=30,335,I98)","v":"Phone Geoflow"},"30 PSI"]
[null,{"$f":"IF('Worksht1 - Field Flow'!E30=35,160,B99)","v":"Check Pressure"},{"$f":"IF('Worksht1 - Field Flow'!E30=35,313,C99)","v":"Check Pressure"},{"$f":"IF('Worksht1 - Field Flow'!E30=35,448,D99)","v":"Check pressure"},{"$f":"IF('Worksht1 - Field Flow'!E30=35,576,E99)","v":"Check Pressure"},{"$f":"IF('Worksht1 - Field Flow'!E30=35,100,F99)","v":"Check pressure"},{"$f":"IF('Worksht1 - Field Flow'!E30=35,199,G99)","v":"Check Pressure"},{"$f":"IF('Worksht1 - Field Flow'!E30=35,287,H99)","v":"Check Pressure"},{"$f":"IF('Worksht1 - Field Flow'!E30=35,379,I99)","v":"Phone Geoflow"},"35 PSI"]
[null,{"$f":"IF('Worksht1 - Field Flow'!E30=40,170,B100)","v":"Check Pressure"},{"$f":"IF('Worksht1 - Field Flow'!E30=40,330,C100)","v":"Check Pressure"},{"$f":"IF('Worksht1 - Field Flow'!E30=40,475,D100)","v":"Check pressure"},{"$f":"IF('Worksht1 - Field Flow'!E30=40,612,E100)","v":"Check Pressure"},{"$f":"IF('Worksht1 - Field Flow'!E30=40,108,F100)","v":"Check pressure"},{"$f":"IF('Worksht1 - Field Flow'!E30=40,211,G100)","v":"Check Pressure"},{"$f":"IF('Worksht1 - Field Flow'!E30=40,305,H100)","v":"Check Pressure"},{"$f":"IF('Worksht1 - Field Flow'!E30=40,385,I100)","v":"Phone Geoflow"},"40 PSI"]
[null,{"$f":"IF('Worksht1 - Field Flow'!E30=45,180,B101)","v":"Check Pressure"},{"$f":"IF('Worksht1 - Field Flow'!E30=45,354,C101)","v":"Check Pressure"},{"$f":"IF('Worksht1 - Field Flow'!E30=45,500,D101)","v":"Check pressure"},{"$f":"IF('Worksht1 - Field Flow'!E30=45,651,E101)","v":"Check Pressure"},{"$f":"IF('Worksht1 - Field Flow'!E30=45,115,F101)","v":"Check pressure"},{"$f":"IF('Worksht1 - Field Flow'!E30=45,222,G101)","v":"Check Pressure"},{"$f":"IF('Worksht1 - Field Flow'!E30=45,321,H101)","v":"Check Pressure"},{"$f":"IF('Worksht1 - Field Flow'!E30=45,429,I101)","v":"Phone Geoflow"},"45 PSI"]
[null,"Check Pressure","Check Pressure","Check pressure","Check Pressure","Check pressure","Check Pressure","Check Pressure","Phone Geoflow"]
[]
["D45 Hours to dose per day"]
[null,{"$f":"TEXT('Worksht1 - Field Flow'!G61/24,\"h:mm\")","v":"7:02"},{"$f":"IF('Worksht1 - Field Flow'!G61<=E104,B104,\"! ! !\")","v":"! ! !"},null,21]
[]
[null,"! ! !"]
[]
[null,"Not enough time in the day to perform parameters as entered. Try to increase flows per zone or decrease flush and drain times. Alternatively, reduce zones or add pumps."]
[]
["Price list. Valves"]
[{"$f":"IF(Macros!$A$71='Parts List '!#REF!,'Worksht1 - Field Flow'!$E$19,)","v":{"$error":"#REF!"}}]
[null,null,null,null,null,null,null,null,"Dripline Parts List",null,null,"List Price"]
[]
["Price list. Dripline",null,null,null,null,null,null,null,"Classic","PC 1/2","PC 1","Classic","PC 1/2","PC 1"]
[{"$f":"+IF('Worksht1 - Field Flow'!E22=1,I115,A116)","v":"WF16-4-24"},{"$f":"+IF('Worksht1 - Field Flow'!E25=A5,B116,C115)","v":"WFPC16-2-24"},{"$f":"+IF('Worksht1 - Field Flow'!E25=A6,C116,D116)","v":"Wasteflow PC . 1/2gph, 24in. emitter spacing"},{"$f":"+IF('Parts List '!$C$16=I115,\"Wasteflow Classic. 1gph, 12in. emitter spacing\",D116)","v":"Wasteflow PC . 1/2gph, 24in. emitter spacing"},null,{"$f":"IF('Parts List '!$C$16=I115,L115,F116)","v":0.58799999999999997},null,null,"WF16-4-12","WFPC16-2-12","WFPC16-4-12",0.86599999999999999,0.92,0.92]
[{"$f":"+IF('Worksht1 - Field Flow'!E22=2,I116,A117)","v":"WF16-4-24"},{"$f":"+IF('Worksht1 - Field Flow'!E22=1,J115,B117)","v":"WFPC16-2-24"},{"$f":"+IF('Worksht1 - Field Flow'!E22=1,K115,C117)","v":"WFPC16-4-24"},{"$f":"+IF('Parts List '!$C$16=I117,\"Wasteflow Classic. 1gph, 18in. emitter spacing\",D117)","v":"Wasteflow PC . 1/2gph, 24in. emitter spacing"},null,{"$f":"IF('Parts List '!$C$16=I117,L117,F117)","v":0.58799999999999997},null,null,"WF16-4-24","WFPC16-2-24","WFPC16-4-24",0.55000000000000004,0.58799999999999997,0.58799999999999997]
[{"$f":"+IF('Worksht1 - Field Flow'!E22=1.5,I117,A118)","v":"WFPC16-2-24"},{"$f":"+IF('Worksht1 - Field Flow'!E22=2,J116,B118)","v":"WFPC16-2-24"},{"$f":"+IF('Worksht1 - Field Flow'!E22=2,K116,C118)","v":"WFPC16-4-24"},{"$f":"+IF('Parts List '!$C$16=I116,\"Wasteflow Classic. 1gph, 24in. emitter spacing\",D118)","v":"Wasteflow PC . 1/2gph, 24in. emitter spacing"},null,{"$f":"IF('Parts List '!$C$16=I116,L116,F118)","v":0.58799999999999997},null,null,"WF16-4-18","WFPC16-2-18","WFPC16-4-18",0.70799999999999996,0.754,0.754]
[{"$f":"+IF('Worksht1 - Field Flow'!E22=0.5,I118,B115)","v":"WFPC16-2-24"},{"$f":"+IF('Worksht1 - Field Flow'!E22=1.5,J117,B119)","v":"Check dripline"},{"$f":"+IF('Worksht1 - Field Flow'!E22=1.5,K117,C119)","v":"Check dripline"},{"$f":"+IF('Parts List '!$C$16=I118,\"Wasteflow PC. 1/2gph, 6 in. emitter spacing\",D119)","v":"Wasteflow PC . 1/2gph, 24in. emitter spacing"},null,{"$f":"IF('Parts List '!$C$16=J118,M118,F119)","v":0.58799999999999997},null,null,"WF16-4-06","WFPC16-2-06","WFPC16-4-06",null,1.24,1.24]
[null,{"$f":"+IF('Worksht1 - Field Flow'!E22=0.5,J118,B120)","v":"Check dripline"},{"$f":"+IF('Worksht1 - Field Flow'!E22=0.5,K118,C120)","v":"Check dripline"},{"$f":"+IF('Parts List '!$C$16=J115,\"Wasteflow PC . 1/2gph, 12in. emitter spacing\",D120)","v":"Wasteflow PC . 1/2gph, 24in. emitter spacing"},null,{"$f":"IF('Parts List '!$C$16=J115,M115,F120)","v":0.58799999999999997}]
[null,"Check dripline","Check dripline",{"$f":"+IF('Parts List '!$C$16=J117,\"Wasteflow PC. 1/2gph, 18in. emitter spacing\",D121)","v":"Wasteflow PC . 1/2gph, 24in. emitter spacing"},null,{"$f":"IF('Parts List '!$C$16=J117,M117,F121)","v":0.58799999999999997}]
[null,null,"Check dripline",{"$f":"+IF('Parts List '!$C$16=J116,\"Wasteflow PC . 1/2gph, 24in. emitter spacing\",D122)","v":"Wasteflow PC . 1/2gph, 24in. emitter spacing"},null,{"$f":"IF('Parts List '!$C$16=J116,M116,F122)","v":0.58799999999999997}]
[null,null,null,{"$f":"+IF('Parts List '!$C$16=J118,\"Wasteflow PC . 1 gph, 6 in. emitter spacing\",D123)","v":"Phone Geoflow"},null,{"$f":"IF('Parts List '!$C$16=K118,M118,F123)","v":"Phone Geoflow"}]
[null,null,null,{"$f":"+IF('Parts List '!$C$16=K115,\"Wasteflow PC . 1 gph, 12 in. emitter spacing\",D124)","v":"Phone Geoflow"},null,{"$f":"IF('Parts List '!$C$16=K115,M115,F124)","v":"Phone Geoflow"}]
[null,null,null,{"$f":"+IF('Parts List '!$C$16=K117,\"Wasteflow PC . 1 gph, 18 in. emitter spacing\",D125)","v":"Phone Geoflow"},null,{"$f":"IF('Parts List '!$C$16=K116,M116,F125)","v":"Phone Geoflow"}]
[null,null,null,{"$f":"+IF('Parts List '!$C$16=K116,\"Wasteflow PC . 1 gph, 24 in. emitter spacing\",D126)","v":"Phone Geoflow"},null,{"$f":"IF('Parts List '!$C$16=K117,M117,F126)","v":"Phone Geoflow"}]
[null,null,null,{"$f":"+IF('Parts List '!$C$16=K118,\"Wasteflow PC . 1 gph, 6 in. emitter spacing\",D127)","v":"Phone Geoflow"},null,"Phone Geoflow"]
[null,null,null,"Phone Geoflow"]
[]
["Price list. Filters"]
[null,{"$f":"A45","v":"AP4E-1F"},"1\" MPT Spinclean filter 0-20 gpm",null,null,null,null,null,41.2]
[{"$f":"IF('Parts List '!$C$32=Macros!B131,C130,A132)","v":0},{"$f":"A46","v":"AP4E-1.5F"},"1.5\" Spinclean filter 0-45 gpm",null,null,null,null,{"$f":"IF('Parts List '!$C$32=Macros!B131,I131,H132)","v":0},52.97]
[{"$f":"IF('Parts List '!$C$32=Macros!B132,C131,A133)","v":0},{"$f":"A47","v":"AP4E-2F"},"2\" Spinclean filter 0-70 gpm",null,null,null,null,{"$f":"IF('Parts List '!$C$32=Macros!B132,I132,H133)","v":0},270.70999999999998]
[{"$f":"IF('Parts List '!$C$32=Macros!B133,C133,A134)","v":0},{"$f":"A48","v":"AP4E-2F"},"2\" Spinclean filter 0-70 gpm",null,null,null,null,{"$f":"IF('Parts List '!$C$32=Macros!B133,I133,H134)","v":0},411.95]
[{"$f":"IF('Parts List '!$C$32=Macros!B134,C134,A135)","v":0},{"$f":"+A51","v":"BioDisc Filter-150"},{"$f":"+B51","v":"1.5in  < 30 gpm"},null,null,75,125,{"$f":"IF('Parts List '!$C$32=Macros!B134,I134,H135)","v":0},{"$f":"+'Parts List '!F126","v":3160}]
[{"$f":"IF('Parts List '!$C$32=Macros!B135,C135,A136)","v":0},{"$f":"+A52","v":"BioDisc Filter-200"},{"$f":"+B52","v":"2in   30-60 gpm"},null,null,150,250,{"$f":"IF('Parts List '!$C$32=Macros!B135,I135,H136)","v":0},{"$f":"+'Parts List '!F127","v":8400}]
[{"$f":"IF('Parts List '!$C$32=Macros!B136,C136,A137)","v":0},{"$f":"+A59","v":"BioDisc Battery 2"},{"$f":"+B59","v":"40-70 gpm / 40 psi"},null,null,300,500,{"$f":"IF('Parts List '!$C$32=Macros!B136,I136,H137)","v":0},{"$f":"+'Parts List '!F128","v":11000}]
[{"$f":"IF('Parts List '!$C$32=Macros!B137,C137,A138)","v":0},{"$f":"+A60","v":"BioDisc Battery  4"},"40-140 gpm  40 psi",null,null,600,1000,{"$f":"IF('Parts List '!$C$32=Macros!B137,I137,H138)","v":0},{"$f":"+'Parts List '!F129","v":17500}]
[{"$f":"IF('Parts List '!$C$32=Macros!B138,C138,A139)","v":0},"BioDisc Battery  6","40-210 gpm  40psi",null,null,900,1500,{"$f":"IF('Parts List '!$C$32=Macros!B138,I138,H139)","v":0},{"$f":"+'Parts List '!F130","v":21000}]
[{"$f":"IF('Parts List '!$C$32=Macros!B139,C139,A140)","v":0},"BioDisc Battery 8","40-280 gpm  40psi",null,null,30,50,{"$f":"IF('Parts List '!$C$32=Macros!B139,I139,H140)","v":0},140]
[{"$f":"IF('Parts List '!$C$32=Macros!B140,C140,A141)","v":0},null,null,null,null,60,90,{"$f":"IF('Parts List '!$C$32=Macros!B140,I140,H141)","v":0},270]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[null,"Choose from Geo 1 controllers if single zone system"]
[{"$f":"IF('Worksht1 - Field Flow'!E19<=4,Macros!B156,Macros!A157)","v":"Choose from Geo 4 controllers if using solenoid zone valves"},"Choose from Geo 4 controllers if using solenoid zone valves"]
[{"$f":"IF('Worksht1 - Field Flow'!E19<=8,Macros!B157,Macros!A158)","v":"Choose from Geo 8 controllers if using solenoid zone valves"},"Choose from Geo 8 controllers if using solenoid zone valves"]
["Call Geoflow for special order"]
[]
[]
[]
["F32 Pump Sizing - Pressure loss in filters",null,"Worksheet 2. Cell F32",null,null,null,"F33 Pump Sizing - Pressure loss through valves"]
["Points on filter curve",null,null,null,null,null,null,{"$f":"+IF('Worksht2 - Pump Sizing'!E21=Macros!A67,0,Macros!H164)","v":"Check T3--Valves tab"}]
["Flow in gpm","Pressure loss(psi)",null,null,null,null,null,{"$f":"IF('Worksht2 - Pump Sizing'!$E$21=H165,I166,J164)","v":"Check T3--Valves tab"},null,{"$f":"IF('Worksht2 - Pump Sizing'!$E$21=J165,K170,L164)","v":"Check T3--Valves tab"},null,{"$f":"IF('Worksht2 - Pump Sizing'!$E$21=L165,M176,N164)","v":"Check T3--Valves tab"},null,{"$f":"IF('Worksht2 - Pump Sizing'!$E$21=N165,O183,P164)","v":"Check T3--Valves tab"},null,{"$f":"IF('Worksht2 - Pump Sizing'!$E$21=Macros!P165,Macros!Q166,Macros!R164)","v":"Check T3--Valves tab"},null,{"$f":"IF('Worksht2 - Pump Sizing'!$E$21=Macros!R165,Macros!S166,Macros!T164)","v":"Check T3--Valves tab"},null,{"$f":"IF('Worksht2 - Pump Sizing'!$E$21=Macros!T165,Macros!U166,Macros!V164)","v":"Check T3--Valves tab"},null,{"$f":"IF('Worksht2 - Pump Sizing'!$E$21=Macros!V165,Macros!W166,Macros!X164)","v":"Check T3--Valves tab"},null,{"$f":"IF('Worksht2 - Pump Sizing'!$E$21=Macros!X165,Macros!Y166,Macros!Z164)","v":"Check T3--Valves tab"},null,"Check T3--Valves tab"]
[null,{"$f":"+B130","v":"AP4E-1F"},null,null,null,null,"gpm",{"$f":"+B72","v":"SVLVB-100"},null,{"$f":"+B73","v":"SVLVB-150"},null,{"$f":"+B74","v":"SVLVB-200"},null,{"$f":"+B75","v":"SVLVB-300"},null,{"$f":"H71","v":"HT-4402"},null,{"$f":"H72","v":"HT-4403"},null,{"$f":"H73","v":"HT-4404"},null,{"$f":"H74","v":"HT-4605"},null,{"$f":"H75","v":"HT-4606"}]
[0,0,{"$f":"IF('Worksht1 - Field Flow'!$E$43<=A166,B166,C167)","v":0.75},null,null,null,"1-4",0.2,{"$f":"IF('Worksht1 - Field Flow'!$E$43<=4,H166,I167)","v":0.2},null,null,null,null,null,null,null,"See T3-Valves",null,"See T3-Valves",null,"See T3-valves",null,"See T3-valves",null,"See T3-valves"]
[1,0.25,{"$f":"IF('Worksht1 - Field Flow'!$E$43<=A167,B167,C168)","v":0.75},null,null,null,10,0.3,{"$f":"IF('Worksht1 - Field Flow'!$E$43<=G167,H167,I168)","v":0.3}]
[2,0.5,{"$f":"IF('Worksht1 - Field Flow'!$E$43<=A168,B168,C169)","v":0.75},null,null,null,12,0.4,{"$f":"IF('Worksht1 - Field Flow'!$E$43<=G168,H168,I169)","v":0.4}]
[3,0.75,{"$f":"IF('Worksht1 - Field Flow'!$E$43<=A169,B169,C170)","v":0.75},null,null,null,15,1,{"$f":"IF('Worksht1 - Field Flow'!$E$43<=G169,H169,I170)","v":1}]
[4,1,{"$f":"IF('Worksht1 - Field Flow'!$E$43<=A170,B170,C171)","v":1},null,null,null,20,2,{"$f":"IF('Worksht1 - Field Flow'!$E$43<=G170,H170,I171)","v":2},0.3,{"$f":"IF('Worksht1 - Field Flow'!$E$43<=G170,J170,K171)","v":0.3}]
[5,2.5,{"$f":"IF('Worksht1 - Field Flow'!$E$43<=A171,B171,C172)","v":2.5},null,null,null,25,3,{"$f":"IF('Worksht1 - Field Flow'!$E$43<=G171,H171,I172)","v":3},0.4,{"$f":"IF('Worksht1 - Field Flow'!$E$43<=G171,J171,K172)","v":0.4}]
[6,3,{"$f":"IF('Worksht1 - Field Flow'!$E$43<=A172,B172,C173)","v":3},null,null,null,28,4,{"$f":"IF('Worksht1 - Field Flow'!$E$43<=G172,H172,I173)","v":4},0.5,{"$f":"IF('Worksht1 - Field Flow'!$E$43<=G172,J172,K173)","v":0.5}]
[7,4.0999999999999996,{"$f":"IF('Worksht1 - Field Flow'!$E$43<=A173,B173,C174)","v":4.0999999999999996},null,null,null,30,4.3,{"$f":"IF('Worksht1 - Field Flow'!$E$43<=G173,H173,I174)","v":4.3},0.6,{"$f":"IF('Worksht1 - Field Flow'!$E$43<=G173,J173,K174)","v":0.6}]
[8,5.2,{"$f":"IF('Worksht1 - Field Flow'!$E$43<=A174,B174,C175)","v":5.2},null,null,null,32,5,{"$f":"IF('Worksht1 - Field Flow'!$E$43<=G174,H174,I175)","v":5},0.7,{"$f":"IF('Worksht1 - Field Flow'!$E$43<=G174,J174,K175)","v":0.7}]
[9,6.8,{"$f":"IF('Worksht1 - Field Flow'!$E$43<=A175,B175,C176)","v":6.8},null,null,null,35,6,{"$f":"IF('Worksht1 - Field Flow'!$E$43<=G175,H175,I176)","v":6},0.8,{"$f":"IF('Worksht1 - Field Flow'!$E$43<=G175,J175,K176)","v":0.8}]
[10,8.5,{"$f":"IF('Worksht1 - Field Flow'!$E$43<=A176,B176,C177)","v":8.5},null,null,null,40,7.8,{"$f":"IF('Worksht1 - Field Flow'!$E$43<=G176,H176,I177)","v":7.8},0.9,{"$f":"IF('Worksht1 - Field Flow'!$E$43<=G176,J176,K177)","v":0.9},0.1,{"$f":"IF('Worksht1 - Field Flow'!$E$43<=G176,L176,M177)","v":0.1}]
[11,11,{"$f":"IF('Worksht1 - Field Flow'!$E$43<=A177,B177,C178)","v":11},null,null,null,45,10,{"$f":"IF('Worksht1 - Field Flow'!$E$43<=G177,H177,I178)","v":10},0.95,{"$f":"IF('Worksht1 - Field Flow'!$E$43<=G177,J177,K178)","v":0.95},0.15,{"$f":"IF('Worksht1 - Field Flow'!$E$43<=G177,L177,M178)","v":0.15}]
["Flow in gpm","Pressure loss(psi)","uhoh",null,null,null,50,12,{"$f":"IF('Worksht1 - Field Flow'!$E$43<=G178,H178,I179)","v":12},1,{"$f":"IF('Worksht1 - Field Flow'!$E$43<=G178,J178,K179)","v":1},0.2,{"$f":"IF('Worksht1 - Field Flow'!$E$43<=G178,L178,M179)","v":0.2}]
[{"$f":"IF('Worksht2 - Pump Sizing'!$E$19=B179,C180,A192)","v":"Check filter"},{"$f":"+B131","v":"AP4E-1.5F"},null,null,null,null,55,14,{"$f":"IF('Worksht1 - Field Flow'!$E$43<=G179,H179,I180)","v":14},1.2,{"$f":"IF('Worksht1 - Field Flow'!$E$43<=G179,J179,K180)","v":1.2},0.3,{"$f":"IF('Worksht1 - Field Flow'!$E$43<=G179,L179,M180)","v":0.3}]
[6,1,{"$f":"IF('Worksht1 - Field Flow'!$E$43<=A180,B180,C181)","v":1},null,null,null,60,{"$f":"+'T3-Valves'!#REF!","v":{"$error":"#REF!"}},{"$f":"IF('Worksht1 - Field Flow'!$E$43<=G180,H180,I181)","v":{"$error":"#REF!"}},1.3,{"$f":"IF('Worksht1 - Field Flow'!$E$43<=G180,J180,K181)","v":1.3},0.4,{"$f":"IF('Worksht1 - Field Flow'!$E$43<=G180,L180,M181)","v":0.4}]
[8,1.75,{"$f":"IF('Worksht1 - Field Flow'!$E$43<=A181,B181,C182)","v":1.75},null,null,null,70,"Check tables",null,1.8,{"$f":"IF('Worksht1 - Field Flow'!$E$43<=G181,J181,K182)","v":1.8},0.5,{"$f":"IF('Worksht1 - Field Flow'!$E$43<=G181,L181,M182)","v":0.5}]
[10,2.7,{"$f":"IF('Worksht1 - Field Flow'!$E$43<=A182,B182,C183)","v":2.7},null,null,null,80,null,null,2.2999999999999998,{"$f":"IF('Worksht1 - Field Flow'!$E$43<=G182,J182,K183)","v":2.2999999999999998},0.6,{"$f":"IF('Worksht1 - Field Flow'!$E$43<=G182,L182,M183)","v":0.6}]
[12,3.9,{"$f":"IF('Worksht1 - Field Flow'!$E$43<=A183,B183,C184)","v":3.9},null,null,null,90,null,null,3,{"$f":"IF('Worksht1 - Field Flow'!$E$43<=G183,J183,K184)","v":3},0.7,{"$f":"IF('Worksht1 - Field Flow'!$E$43<=G183,L183,M184)","v":0.7},0.1,{"$f":"IF('Worksht1 - Field Flow'!$E$43<=G183,N183,O184)","v":0.1}]
[14,5,{"$f":"IF('Worksht1 - Field Flow'!$E$43<=A184,B184,C185)","v":5},null,null,null,100,null,null,4.0999999999999996,{"$f":"IF('Worksht1 - Field Flow'!$E$43<=G184,J184,K185)","v":4.0999999999999996},0.8,{"$f":"IF('Worksht1 - Field Flow'!$E$43<=G184,L184,M185)","v":0.8},0.2,{"$f":"IF('Worksht1 - Field Flow'!$E$43<=G184,N184,O185)","v":0.2}]
[16,6.5,{"$f":"IF('Worksht1 - Field Flow'!$E$43<=A185,B185,C186)","v":6.5},null,null,null,125,null,null,6,{"$f":"IF('Worksht1 - Field Flow'!$E$43<=G185,J185,K186)","v":6},1,{"$f":"IF('Worksht1 - Field Flow'!$E$43<=G185,L185,M186)","v":1},0.35,{"$f":"IF('Worksht1 - Field Flow'!$E$43<=G185,N185,O186)","v":0.35}]
[18,8.25,{"$f":"IF('Worksht1 - Field Flow'!$E$43<=A186,B186,C187)","v":8.25},null,null,null,150,null,null,7,{"$f":"IF('Worksht1 - Field Flow'!$E$43<=G186,J186,K187)","v":7},1.5,{"$f":"IF('Worksht1 - Field Flow'!$E$43<=G186,L186,M187)","v":1.5},0.5,{"$f":"IF('Worksht1 - Field Flow'!$E$43<=G186,N186,O187)","v":0.5}]
[20,10.25,{"$f":"IF('Worksht1 - Field Flow'!$E$43<=A187,B187,C188)","v":10.25},null,null,null,175,null,null,11.5,{"$f":"IF('Worksht1 - Field Flow'!$E$43<=G187,J187,K188)","v":11.5},2,{"$f":"IF('Worksht1 - Field Flow'!$E$43<=G187,L187,M188)","v":2},0.75,{"$f":"IF('Worksht1 - Field Flow'!$E$43<=G187,N187,O188)","v":0.75}]
[22,12.3,{"$f":"IF('Worksht1 - Field Flow'!$E$43<=A188,B188,C189)","v":12.3},null,null,null,200,null,null,15,{"$f":"IF('Worksht1 - Field Flow'!$E$43<=G188,J188,K189)","v":15},3,{"$f":"IF('Worksht1 - Field Flow'!$E$43<=G188,L188,M189)","v":3},1,{"$f":"IF('Worksht1 - Field Flow'!$E$43<=G188,N188,O189)","v":1}]
[24,15,{"$f":"IF('Worksht1 - Field Flow'!$E$43<=A189,B189,C190)","v":15},null,null,null,250,null,null,null,"Check tables",4.5,{"$f":"IF('Worksht1 - Field Flow'!$E$43<=G189,L189,M190)","v":4.5},1.4,{"$f":"IF('Worksht1 - Field Flow'!$E$43<=G189,N189,O190)","v":1.4}]
[26,17,{"$f":"IF('Worksht1 - Field Flow'!$E$43<=A190,B190,#REF!)","v":17},null,null,null,300,null,null,null,null,6.8,{"$f":"IF('Worksht1 - Field Flow'!$E$43<=G190,L190,M191)","v":6.8},1.9,{"$f":"IF('Worksht1 - Field Flow'!$E$43<=G190,N190,O191)","v":1.9}]
["Flow in gpm","Pressure loss(psi)",{"$f":"+C178","v":"uhoh"},null,null,null,400,null,null,null,null,12,{"$f":"IF('Worksht1 - Field Flow'!$E$43<=G191,L191,M192)","v":12},3,{"$f":"IF('Worksht1 - Field Flow'!$E$43<=G191,N191,O192)","v":3}]
[{"$f":"IF('Worksht2 - Pump Sizing'!$E$19=Macros!B192,C193,A204)","v":"Check filter"},{"$f":"+B132","v":"AP4E-2F"},null,null,null,null,450,null,null,null,null,null,"Check tables",3.9,{"$f":"IF('Worksht1 - Field Flow'!$E$43<=G192,N192,O193)","v":3.9}]
[10,0.75,{"$f":"IF('Worksht1 - Field Flow'!$E$43<=A193,B193,C194)","v":0.75},null,null,null,500,null,null,null,null,null,null,4.7,{"$f":"IF('Worksht1 - Field Flow'!$E$43<=G193,N193,O194)","v":4.7}]
[15,1,{"$f":"IF('Worksht1 - Field Flow'!$E$43<=A194,B194,C195)","v":1},null,null,null,550,null,null,null,null,null,null,5.6,{"$f":"IF('Worksht1 - Field Flow'!$E$43<=G194,N194,O195)","v":5.6}]
[20,1.5,{"$f":"IF('Worksht1 - Field Flow'!$E$43<=A195,B195,C196)","v":1.5},null,null,null,600,null,null,null,null,null,null,6.6,{"$f":"IF('Worksht1 - Field Flow'!$E$43<=G195,N195,O196)","v":6.6}]
[25,2.5,{"$f":"IF('Worksht1 - Field Flow'!$E$43<=A196,B196,C197)","v":2.5},null,null,null,650,null,null,null,null,null,null,7.9,{"$f":"IF('Worksht1 - Field Flow'!$E$43<=G196,N196,O197)","v":7.9}]
[30,3,{"$f":"IF('Worksht1 - Field Flow'!$E$43<=A197,B197,C198)","v":3},null,null,null,700,null,null,null,null,null,null,9,{"$f":"IF('Worksht1 - Field Flow'!$E$43<=G197,N197,O198)","v":9}]
[35,4,{"$f":"IF('Worksht1 - Field Flow'!$E$43<=A198,B198,C199)","v":4},null,null,null,750,null,null,null,null,null,null,10.8,{"$f":"IF('Worksht1 - Field Flow'!$E$43<=G198,N198,P164)","v":10.8}]
[40,5,{"$f":"IF('Worksht1 - Field Flow'!$E$43<=A199,B199,C200)","v":5},null,null,null,800]
[45,6.8,{"$f":"IF('Worksht1 - Field Flow'!$E$43<=A200,B200,C201)","v":6.8}]
[50,8,{"$f":"IF('Worksht1 - Field Flow'!$E$43<=A201,B201,C202)","v":8}]
[null,null,{"$f":"+C178","v":"uhoh"}]
["Flow in gpm","Pressure loss(psi)",null,null,null,null,"F29 Pump Sizing - Pressure loss through dripline"]
[{"$f":"IF('Worksht2 - Pump Sizing'!$E$19=Macros!B204,C205,A218)","v":"Check filter"},{"$f":"+B133","v":"AP4E-2F"},null,null,null,null,{"$f":"+'Worksht1 - Field Flow'!E25","v":"Wasteflow PC - 1/2gph"},"Dripline chosen on Worksheet 1"]
[20,0.75,{"$f":"IF('Worksht1 - Field Flow'!$E$43<=A205,B205,C206)","v":0.75},null,null,null,{"$f":"+'Worksht1 - Field Flow'!E22","v":2},"Spacing between drippers from worksheet 1"]
[30,1,{"$f":"IF('Worksht1 - Field Flow'!$E$43<=A206,B206,C207)","v":1},null,null,null,{"$f":"+'Worksht1 - Field Flow'!E40","v":653.13575471698118},"Longest length of run from worksheet 1"]
[40,1.5,{"$f":"IF('Worksht1 - Field Flow'!$E$43<=A207,B207,C208)","v":1.5},null,null,null,{"$f":"IF($G$204=A4,I207,G216)","v":44.79},null,{"$f":"IF($G$205=1,I210,K207)","v":"oops"},null,{"$f":"IF($G$205=2,K210,G216)","v":"oops"}]
[50,2,{"$f":"IF('Worksht1 - Field Flow'!$E$43<=A208,B208,C209)","v":2},null,null,null,"CLASSIC","12\"/1.02gph",null,"24\"/1.02gph"]
[55,2.5,{"$f":"IF('Worksht1 - Field Flow'!$E$43<=A209,B209,C210)","v":2.5},null,null,null,0,0,null,0]
[60,2.7,{"$f":"IF('Worksht1 - Field Flow'!$E$43<=A210,B210,C211)","v":2.7},null,null,null,50,0.21790000000000001,{"$f":"IF($G$206<=G210,H210,I211)","v":"oops"},6.5000000000000002E-2,{"$f":"IF($G$206<=G210,J210,K211)","v":"oops"}]
[65,3.4,{"$f":"IF('Worksht1 - Field Flow'!$E$43<=A211,B211,C212)","v":3.4},null,null,null,100,1.62236,{"$f":"IF($G$206<=G211,H211,I212)","v":"oops"},0.31994,{"$f":"IF($G$206<=G211,J211,K212)","v":"oops"}]
[70,3.7,{"$f":"IF('Worksht1 - Field Flow'!$E$43<=A212,B212,C213)","v":3.7},null,null,null,150,5.4982600000000001,{"$f":"IF($G$206<=G212,H212,I213)","v":"oops"},1.0197000000000001,{"$f":"IF($G$206<=G212,J212,K213)","v":"oops"}]
[75,4.5,{"$f":"IF('Worksht1 - Field Flow'!$E$43<=A213,B213,C214)","v":4.5},null,null,null,200,13.773999999999999,{"$f":"IF($G$206<=G213,H213,I214)","v":"oops"},2.5390000000000001,{"$f":"IF($G$206<=G213,J213,K214)","v":"oops"}]
[80,5,{"$f":"IF('Worksht1 - Field Flow'!$E$43<=A214,B214,C215)","v":5},null,null,null,250,null,"oops",4.5936000000000003,{"$f":"IF($G$206<=G214,J214,K215)","v":"oops"}]
[85,5.5,{"$f":"IF('Worksht1 - Field Flow'!$E$43<=A215,B215,C216)","v":5.5},null,null,null,300,null,null,8.0532900000000005,"oops"]
[null,null,{"$f":"+C178","v":"uhoh"},null,null,null,{"$f":"IF(G204=A5,I217,G235)","v":44.79}]
["Flow in gpm","Pressure loss(psi)",null,null,null,null,"PC 0.53",null,{"$f":"IF($G$205=1,I219,K217)","v":44.79},null,{"$f":"IF($G$205=1.5,K219,M217)","v":44.79},null,{"$f":"IF($G$205=2,M219,G235)","v":44.79}]
[{"$f":"IF('Worksht2 - Pump Sizing'!$E$19=Macros!B218,C219,A221)","v":"Check filter"},{"$f":"+B134","v":"BioDisc Filter-150"},null,null,null,null,null,{"$f":"+Macros!R219","v":0},null,{"$f":"+Macros!S219","v":0},null,{"$f":"+Macros!T219","v":0}]
[30,5,{"$f":"IF('Worksht1 - Field Flow'!$E$43<=A219,B219,C220)","v":5},null,20,0.75,50,0.14000000000000001,{"$f":"IF($G$206<=G219,H219,I220)","v":"Dripline too long"},0.1,{"$f":"IF($G$206<=G219,J219,K220)","v":"Dripline too long"},0.05,{"$f":"IF($G$206<=G219,L219,M220)","v":44.79}]
[60,6.5,{"$f":"IF('Worksht1 - Field Flow'!$E$43<=A220,B220,C221)","v":6.5},null,30,0.8,100,0.9,"Dripline too long",0.3,"Dripline too long",0.153,44.79]
[{"$f":"IF('Worksht2 - Pump Sizing'!$E$19=Macros!B221,C222,A224)","v":"Check filter"},{"$f":"+B135","v":"BioDisc Filter-200"},"flow too high",null,40,0.9,150,2.9,"Dripline too long",1,"Dripline too long",0.49,44.79]
[45,5,{"$f":"IF('Worksht1 - Field Flow'!$E$43<=A222,B222,C223)","v":5},null,50,1,200,6.77,"Dripline too long",2.2999999999999998,"Dripline too long",1.1200000000000001,44.79]
[90,6.5,{"$f":"IF('Worksht1 - Field Flow'!$E$43<=A223,B223,C224)","v":6.5},null,60,1.3,250,13,"Dripline too long",4.49,"Dripline too long",2.15,44.79]
[{"$f":"IF('Worksht2 - Pump Sizing'!$E$19=Macros!B224,C225,A227)","v":"Check filter"},{"$f":"+B136","v":"BioDisc Battery 2"},"flow too high",null,null,null,300,22.66,"Dripline too long",7.64,"Dripline too long",3.66,44.79]
[70,4.8,{"$f":"IF('Worksht1 - Field Flow'!$E$43<=A225,B225,C226)","v":4.8},null,null,null,350,36,"Dripline too long",12,"Dripline too long",5.74,44.79]
[100,5.8,{"$f":"IF('Worksht1 - Field Flow'!$E$43<=A226,B226,C227)","v":5.8},null,null,null,400,53.96,"Dripline too long",17.899999999999999,"Dripline too long",8.5,44.79]
[{"$f":"IF('Worksht2 - Pump Sizing'!$E$19=Macros!B227,C228,A230)","v":"Check filter"},{"$f":"+B137","v":"BioDisc Battery  4"},"flow too high",null,null,null,450,70,"Dripline too long",25.44,"Dripline too long",12.03,44.79]
[100,4.8,{"$f":"IF('Worksht1 - Field Flow'!$E$43<=A228,B228,C230)","v":4.8},null,null,null,500,null,"Dripline too long",35,"Dripline too long",16.420000000000002,44.79]
[200,5,{"$f":"IF('Worksht1 - Field Flow'!$E$43<=A229,B229,C231)","v":5},null,null,null,550,null,null,46.6,"Dripline too long",21.79,44.79]
[{"$f":"IF('Worksht2 - Pump Sizing'!$E$19=Macros!B230,C231,A233)","v":"Check filter"},{"$f":"+B138","v":"BioDisc Battery  6"},"flow too high",null,null,null,600,null,null,60,"Dripline too long",28.24,44.79]
[200,4.8,{"$f":"IF('Worksht1 - Field Flow'!$E$43<=A231,B231,C233)","v":4.8},null,null,null,650,null,null,null,{"$f":"+I228","v":"Dripline too long"},35.869999999999997,44.79]
[300,5,{"$f":"IF('Worksht1 - Field Flow'!$E$43<=A232,B232,C234)","v":5},null,null,null,700,null,null,null,null,44.79,44.79]
[{"$f":"IF('Worksht2 - Pump Sizing'!$E$19=Macros!B233,C234,A237)","v":"Check filter"},{"$f":"+B139","v":"BioDisc Battery 8"},"flow too high",null,null,null,750,null,null,null,null,55.12,55.12]
[320,4.9000000000000004,{"$f":"IF('Worksht1 - Field Flow'!$E$43<=A234,B234,C235)","v":4.9000000000000004},null,null,null,800,null,null,null,null,null,{"$f":"+I228","v":"Dripline too long"}]
[400,5,{"$f":"IF('Worksht1 - Field Flow'!$E$43<=A235,B235,C236)","v":5},null,null,null,{"$f":"IF($G$204=A6,I235,G247)","v":"Oops"},null,{"$f":"IF($G$205=1,I237,K235)","v":"Dripline too long"},null,{"$f":"IF($G$205=1.5,K237,M235)","v":"Dripline too long"},null,{"$f":"IF($G$205=2,M237,\"oops\")","v":"Dripline too long"}]
[null,null,"flow too high",null,null,null,"PC 1.0 gph"]
[{"$f":"IF('Worksht2 - Pump Sizing'!$E$19=Macros!B237,C238,A245)","v":"Check filter"},{"$f":"+B140","v":0},null,null,null,null,{"$f":"+G219","v":50},0.49,{"$f":"IF($G$206<=G237,H237,I238)","v":"Dripline too long"},0.65,{"$f":"IF($G$206<=G237,J237,K238)","v":"Dripline too long"},0.1,{"$f":"IF($G$206<=G237,L237,M238)","v":"Dripline too long"}]
[30,0.5,{"$f":"IF('Worksht1 - Field Flow'!$E$43<=A238,B238,C239)","v":0.5},null,null,null,{"$f":"+G220","v":100},3.3,"Dripline too long",1.1499999999999999,"Dripline too long",0.55900000000000005,"Dripline too long"]
[40,0.8,{"$f":"IF('Worksht1 - Field Flow'!$E$43<=A239,B239,C240)","v":0.8},null,null,null,150,10.79,"Dripline too long",3.69,"Dripline too long",1.79,"Dripline too long"]
[50,1,{"$f":"IF('Worksht1 - Field Flow'!$E$43<=A240,B240,C241)","v":1},null,null,null,200,25,"Dripline too long",8.6,"Dripline too long",4.1100000000000003,"Dripline too long"]
[60,1.2,{"$f":"IF('Worksht1 - Field Flow'!$E$43<=A241,B241,C242)","v":1.2},null,null,null,250,49.5,"Dripline too long",16.579999999999998,"Dripline too long",7.87,"Dripline too long"]
[70,1.8,{"$f":"IF('Worksht1 - Field Flow'!$E$43<=A242,B242,C243)","v":1.8},null,null,null,300,75,"Dripline too long",28.22,"Dripline too long",13.41,"Dripline too long"]
[80,2.2999999999999998,{"$f":"IF('Worksht1 - Field Flow'!$E$43<=A243,B243,C244)","v":2.2999999999999998},null,null,null,350,null,{"$f":"+I228","v":"Dripline too long"},44.34,"Dripline too long",21,"Dripline too long"]
[90,3,{"$f":"IF('Worksht1 - Field Flow'!$E$43<=A244,B244,C245)","v":3},null,null,null,400,null,null,65,"Dripline too long",31.2,"Dripline too long"]
["Check filter",null,"uh oh",null,null,null,450,null,null,null,{"$f":"+I228","v":"Dripline too long"},44.16,"Dripline too long"]
[null,null,null,null,null,null,500,null,null,null,null,60,"Dripline too long"]
[null,null,null,null,null,null,"Oops",null,null,null,null,null,{"$f":"+I228","v":"Dripline too long"}]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
["Worksheet 2.  Pump Sizing. D16",null,null,null,null,null,null,"Worksheet 2.  Pump Sizing. D16"]
[{"$f":"IF('Worksht2 - Pump Sizing'!D18<=1,0.43,A260)","v":3.27},null,null,null,null,null,null,{"$f":"IF('Worksht2 - Pump Sizing'!D17<=1,0.43,H260)","v":1.55}]
[{"$f":"IF('Worksht2 - Pump Sizing'!D18<=2,1.55,A261)","v":3.27},null,null,null,null,null,null,{"$f":"IF('Worksht2 - Pump Sizing'!D17<=2,1.55,H261)","v":1.55}]
[{"$f":"IF('Worksht2 - Pump Sizing'!D18<=3,3.27,A262)","v":3.27},null,null,null,null,null,null,{"$f":"IF('Worksht2 - Pump Sizing'!D17<=3,3.27,H262)","v":3.27}]
[{"$f":"IF('Worksht2 - Pump Sizing'!D18<=3.999,5.57,A263)","v":5.57},null,null,null,null,null,null,{"$f":"IF('Worksht2 - Pump Sizing'!D17<=3.999,5.57,H263)","v":5.57}]
[{"$f":"IF('Worksht2 - Pump Sizing'!D18<=4,1.42,A264)","v":1.42},null,null,null,null,null,null,{"$f":"IF('Worksht2 - Pump Sizing'!D17<=4,1.42,H264)","v":1.42}]
[{"$f":"IF('Worksht2 - Pump Sizing'!D18<=5,2.15,A265)","v":2.15},null,null,null,null,null,null,{"$f":"IF('Worksht2 - Pump Sizing'!D17<=5,2.15,H265)","v":2.15}]
[{"$f":"IF('Worksht2 - Pump Sizing'!D18<=5.5,0.66,A266)","v":0.66},null,null,null,null,null,null,{"$f":"IF('Worksht2 - Pump Sizing'!D17<=5.5,0.66,H266)","v":0.66}]
[{"$f":"IF('Worksht2 - Pump Sizing'!D18<=7,0.93,A267)","v":0.93},null,null,null,null,null,null,{"$f":"IF('Worksht2 - Pump Sizing'!D17<=7,0.93,H267)","v":0.93}]
[{"$f":"IF('Worksht2 - Pump Sizing'!D18<=8.5,1.58,A268)","v":1.58},null,null,null,null,null,null,{"$f":"IF('Worksht2 - Pump Sizing'!D17<=8.5,1.58,H268)","v":1.58}]
[{"$f":"IF('Worksht2 - Pump Sizing'!D18<=10,2.39,A269)","v":2.39},null,null,null,null,null,null,{"$f":"IF('Worksht2 - Pump Sizing'!D17<=10,2.39,H269)","v":2.39}]
[{"$f":"IF('Worksht2 - Pump Sizing'!D18<=15,1.33,A270)","v":1.33},null,null,null,null,null,null,{"$f":"IF('Worksht2 - Pump Sizing'!D17<=15,1.33,H270)","v":1.33}]
[{"$f":"IF('Worksht2 - Pump Sizing'!D18<=20,2.27,A271)","v":2.27},null,null,null,null,null,null,{"$f":"IF('Worksht2 - Pump Sizing'!D17<=20,2.27,H271)","v":2.27}]
[{"$f":"IF('Worksht2 - Pump Sizing'!D18<=25,1.63,A272)","v":1.63},null,null,null,null,null,null,{"$f":"IF('Worksht2 - Pump Sizing'!D17<=25,1.63,H272)","v":1.63}]
[{"$f":"IF('Worksht2 - Pump Sizing'!D18<=30,2.27,A273)","v":2.27},null,null,null,null,null,null,{"$f":"IF('Worksht2 - Pump Sizing'!D17<=30,2.27,H273)","v":2.27}]
[{"$f":"IF('Worksht2 - Pump Sizing'!D18<=35,0.89,A274)","v":0.89},null,null,null,null,null,null,{"$f":"IF('Worksht2 - Pump Sizing'!D17<=35,0.89,H274)","v":0.89}]
[{"$f":"IF('Worksht2 - Pump Sizing'!D18<=40,1.14,A275)","v":1.1399999999999999},null,null,null,null,null,null,{"$f":"IF('Worksht2 - Pump Sizing'!D17<=40,1.14,H275)","v":1.1399999999999999}]
[{"$f":"IF('Worksht2 - Pump Sizing'!D18<=45,1.42,A276)","v":1.42},null,null,null,null,null,null,{"$f":"IF('Worksht2 - Pump Sizing'!D17<=45,1.42,H276)","v":1.42}]
[{"$f":"IF('Worksht2 - Pump Sizing'!D18<=50,1.73,A277)","v":1.73},null,null,null,null,null,null,{"$f":"IF('Worksht2 - Pump Sizing'!D17<=50,1.73,H277)","v":1.73}]
[{"$f":"IF('Worksht2 - Pump Sizing'!D18<=60,1.02,A278)","v":1.02},null,null,null,null,null,null,{"$f":"IF('Worksht2 - Pump Sizing'!D17<=60,1.02,H278)","v":1.02}]
[{"$f":"IF('Worksht2 - Pump Sizing'!D18<=70,1.36,A279)","v":1.36},null,null,null,null,null,null,{"$f":"IF('Worksht2 - Pump Sizing'!D17<=70,1.36,H279)","v":1.36}]
[{"$f":"IF('Worksht2 - Pump Sizing'!D18<=80,0.6,A280)","v":0.6},null,null,null,null,null,null,{"$f":"IF('Worksht2 - Pump Sizing'!D17<=80,0.6,H280)","v":0.6}]
[{"$f":"IF('Worksht2 - Pump Sizing'!D18<=90,0.75,A281)","v":0.75},null,null,null,null,null,null,{"$f":"IF('Worksht2 - Pump Sizing'!D17<=90,0.75,H281)","v":0.75}]
[{"$f":"IF('Worksht2 - Pump Sizing'!D18<=100,0.91,A282)","v":0.91},null,null,null,null,null,null,{"$f":"IF('Worksht2 - Pump Sizing'!D17<=100,0.91,H282)","v":0.91}]
[{"$f":"IF('Worksht2 - Pump Sizing'!D18<=125,0.37,A283)","v":0.37},null,null,null,null,null,null,{"$f":"IF('Worksht2 - Pump Sizing'!D17<=125,0.37,H283)","v":0.37}]
[{"$f":"IF('Worksht2 - Pump Sizing'!D18<=150,0.51,A284)","v":0.51},null,null,null,null,null,null,{"$f":"IF('Worksht2 - Pump Sizing'!D17<=150,0.51,H284)","v":0.51}]
[{"$f":"IF('Worksht2 - Pump Sizing'!D18<=175,0.68,A285)","v":0.68},null,null,null,null,null,null,{"$f":"IF('Worksht2 - Pump Sizing'!D17<=175,0.68,H285)","v":0.68}]
[{"$f":"IF('Worksht2 - Pump Sizing'!D18<=200,0.12,\"See note right\")","v":0.12},null,null,null,null,null,null,{"$f":"IF('Worksht2 - Pump Sizing'!D17<=200,0.12,\"Consult factory for flows over 200gpm\")","v":0.12}]

{"sheet":"Worksht1 - Field Flow","index":2,"n_rows":161,"n_cols":24,"rows_kept":161,"cut":false,"hidden":false,"merged":[[24,6,25,6],[6,1,6,5],[18,1,18,3],[1,1,1,5],[23,2,23,3],[24,2,24,3],[13,2,13,3],[14,2,14,3],[21,2,21,3],[20,2,20,3],[12,1,12,5],[24,5,25,5],[24,4,25,4],[22,2,22,3],[24,1,25,1],[16,2,16,3],[32,2,32,3],[2,3,2,5],[3,3,3,5],[4,3,4,5],[5,3,5,5],[31,2,31,3],[29,2,29,3],[30,2,30,3],[7,1,7,5],[11,1,11,5]]}
[null,null,null,null,null,{"$f":"+Intro.!P4","v":"Updated Jan. 2015"}]
[null,"FIELD FLOW"]
[null,"Job Description:",null,"Fill in Job Site"]
[null,"Contact:",null,"Fill in Customer name"]
[null,"Prepared by:",null,"Fill in Designer name, email, phone"]
[null,"Date:",null,"Fill in date 7/31/2014"]
[]
[null,"Please fill in the shaded areas and drop down menus:"]
[null,"This spreadsheet is a guide for small systems with residential waste & is not a complete hydraulic design."]
[]
[null,"Worksheet 1- Field Flow"]
[]
[null,"Total field"]
[null,null,"Total Quantity of effluent to be disposed per day",null,2500,"gallons / day","note"]
[null,null,"Hydraulic loading rate",null,0.1,"gallons / sq.ft. / day","note"]
[null,null,"Minimum Dispersal Field Area",null,{"$f":"SUM(E14/E15)","v":25000},"square ft.","note",null,null,null,null,null,null,"Optional section for uneven zone sizes"]
[null,null,"Total Dispersal Field Area",null,636,"square ft.","note",null,null,null,null,null,null,{"$f":"+E25","v":"Wasteflow PC - 1/2gph"},"Zone #1","Zone #2","Zone 3","Zone 4","Zone 5","Zone 6","Zone 7","Zone 8","Zone 9","Zone 10"]
[null,"Flow per zone",null,null,null,null,null,null,null,null,null,null,null,"Dispersal Area per zone (sq ft.)","Fill in","Fill in","Fill in","Fill in","Fill in","Fill in","Fill in","Fill in","Fill in","Fill in"]
[null,"    Number of Zones",null,null,1,"zone(s)","note",null,null,null,null,null,null,"Line spacing",{"$f":"$E$21","v":2},{"$f":"$E$21","v":2},2,2,2,2,2,2,2,2]
[null,null,"Dispersal area per zone",null,{"$f":"SUM(E17/E19)","v":636},"square ft.","note",null,null,null,null,null,null,"Emitter spacing",{"$f":"$E$22","v":2},{"$f":"$E$22","v":2},2,2,2,2,2,2,2,2]
[null,null,"Choose line spacing between WASTEFLOW lines",null,2,"ft.","note",null,null,null,null,null,null,"Linear ft",{"$f":"+O18/O19","v":{"$error":"#VALUE!"}},{"$f":"+P18/P19","v":{"$error":"#VALUE!"}},{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$f":"+X18/X19","v":{"$error":"#VALUE!"}}]
[null,null,"Choose emitter spacing between WASTEFLOW emitters",null,2,"ft.","note",null,null,null,null,null,null,"No. of emitters per zone",{"$f":"+O21/O20","v":{"$error":"#VALUE!"}},{"$f":"+P21/P20","v":{"$error":"#VALUE!"}},{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"}]
[null,null,"Total linear ft.per zone (minimum required)",null,{"$f":"SUM(E20/E21)","v":318},"ft. per zone","note",null,null,null,null,null,null,"Select dripline",{"$f":"+$N$17","v":"Wasteflow PC - 1/2gph"},"Wasteflow PC - 1/2gph","Wasteflow PC - 1/2gph","Wasteflow PC - 1/2gph","Wasteflow PC - 1/2gph","Wasteflow PC - 1/2gph","Wasteflow PC - 1/2gph","Wasteflow PC - 1/2gph","Wasteflow PC - 1/2gph","Wasteflow PC - 1/2gph"]
[null,null,"Total number of emitters per zone",null,{"$f":"E23/E22","v":159},"emitters per zone","note"]
[null,null,"Select Wasteflow dripline (16mm)",null,"Wasteflow PC - 1/2gph","dripline","note"]
[null,null,null,null,null,null,null,null,null,null,null,"BioDisc-150",{"$f":"+'Worksht1 - Field Flow'!I48","v":"-"}]
[null,null,null,null,{"$f":"Macros!A4","v":"Wasteflow Classic"},null,null,null,null,null,null,"BioDisc-200",{"$f":"+'Worksht1 - Field Flow'!#REF!","v":{"$error":"#REF!"}}]
[null,null,null,null,{"$f":"Macros!A5","v":"Wasteflow PC - 1/2gph"},null,null,null,null,null,null,null,null,"Pressure at the beginning of zone",{"$f":"$E$30","v":20},{"$f":"$E$30","v":20},20,20,20,20,20,20,20,20]
[null,null,null,null,{"$f":"Macros!A6","v":"Wasteflow PC - 1 gph"},null,null,null,null,null,null,null,null,"Ft of head at beginning of zone",{"$f":"$E$31","v":46.2},{"$f":"$E$31","v":46.2},46.2,46.2,46.2,46.2,46.2,46.2,46.2,46.2]
[null,null,"Pressure at the beginning of the dripfield",null,20,"psi","note",null,null,null,null,null,null,"Flow rate per emitter in gph",{"$f":"IF(O23=Macros!$A$5,0.53,Macros!$A$21)","v":0.53},{"$f":"IF(P23=Macros!$A$5,0.53,Macros!$A$21)","v":0.53},{"$f":"IF(Q23=Macros!$A$5,0.53,Macros!$A$21)","v":0.53},{"$f":"IF(R23=Macros!$A$5,0.53,Macros!$A$21)","v":0.53},{"$f":"IF(S23=Macros!$A$5,0.53,Macros!$A$21)","v":0.53},{"$f":"IF(T23=Macros!$A$5,0.53,Macros!$A$21)","v":0.53},{"$f":"IF(U23=Macros!$A$5,0.53,Macros!$A$21)","v":0.53},{"$f":"IF(V23=Macros!$A$5,0.53,Macros!$A$21)","v":0.53},{"$f":"IF(W23=Macros!$A$5,0.53,Macros!$A$21)","v":0.53},{"$f":"IF(X23=Macros!$A$5,0.53,Macros!$A$21)","v":0.53}]
[null,null,"Feet of Head at the beginning of the dripfield",null,{"$f":"E30*2.31","v":46.2},"ft.","note",null,null,null,null,null,null,"Dose flow ",{"$f":"(O30*O22)/60","v":{"$error":"#VALUE!"}},{"$f":"(P30*P22)/60","v":{"$error":"#VALUE!"}},{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"}]
[null,null,"What is the flow rate per emitter in gph?",null,{"$f":"IF(E25=Macros!A5,0.53,Macros!A21)","v":0.53},"gph","note"]
[null,null,"Dose flow per zone",null,{"$f":"(E32*E24)/60","v":1.4045000000000001},"gpm","note",null,null,null,null,null,null,"Fush velocity",{"$f":"$E$37","v":2},{"$f":"$E$37","v":2},2,2,2,2,2,2,2,2]
[null,null,"Note:  A few States or Counties require additional flow for flushing.  Please check your local regulations. ",null,null,null,null,null,null,null,null,null,null,"Number of driplines","Fill in","Fill in","Fill in","Fill in","Fill in","Fill in","Fill in","Fill in","Fill in","Fill in"]
[null,null,"Flush velocity calculation below is for PC dripline.  Classic dripline requires less flow to flush than PC.  ",null,null,null,null,null,null,null,null,null,null,"Length of longest line",{"$f":"+O21/O34","v":{"$error":"#VALUE!"}},{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"}]
[null,null,"Please refer to Geoflow's spreadsheet \"Design Flow and Flush Curves\" at www.geoflow.com or call 800-828-3388."]
[null,null,"If required, choose flush velocity",null,2,"ft/sec","note",null,null,null,null,null,null,"Flush flow per line gpm",{"$f":"$E$75*7.48*60","v":1.4801829166666671},{"$f":"$E$75*7.48*60","v":1.4801829166666671},1.4801829166666671,1.4801829166666671,1.4801829166666671,1.4801829166666671,1.4801829166666671,1.4801829166666671,1.4801829166666671,1.4801829166666671]
[null,null,"How many lines of WASTEFLOW per zone?",null,1,"lines","note",null,null,null,null,null,null,"Total flow to flush lines in gpm",{"$f":"O37*O34","v":{"$error":"#VALUE!"}},{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"}]
[null,null,"Fill in the actual length of longest dripline lateral",null,{"$f":"+E23/E38","v":318},"ft.","note",null,null,null,null,null,null,"Total flow (flush and dose) in gpm",{"$f":"O38+O31","v":{"$error":"#VALUE!"}},{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"}]
[null,null,null,"Equivalent length including flush requirement",{"$f":"E39+(E41*60/E32)*E22","v":653.13575471698118},null,null,null,null,null,null,"TODD- This line is usually hidden."]
[null,null,"Flush flow required at the end of each dripline",null,{"$f":"E75*7.48*60","v":1.4801829166666671},"gpm","note"]
[null,null,"Total Flow required to achieve flushing velocity",null,{"$f":"E41*E38","v":1.4801829166666671},"gpm","note"]
[null,null,"Total Flow per zone- worst case scenario",null,{"$f":"E42+E33","v":2.8846829166666672},{"$f":"F42","v":"gpm"},"note"]
[null,"Select Filters and zone valves"]
[null,null,"Select Filter Type",null,"Select Filter",null,"note"]
[null,null,"Recommended Filter (item no.)",null,{"$f":"IF(E45=Macros!A37,\"Select filter above\",Macros!A43)","v":"Select filter above"},{"$f":"IF(E46=Macros!A45,Macros!B45,Macros!C46)","v":"Select"},"note",{"$f":"IF(E45=Macros!A40,\"BioDisc Battery is for large systems.  Not suitable for this spreadhseet\",\" \")","v":" "}]
[null,null,"Select Zone Valve Type",null,"Electric Solenoid",{"$f":"IF(E47=Macros!A65,'Worksht1 - Field Flow'!I48,\"-\")","v":"-"},"note"]
[null,null,"Recommended Zone Valve (item no.)",null,{"$f":"IF(E19=1,0,Macros!A68)","v":0},{"$f":"IF(E48=Macros!B72,Macros!C72,Macros!D73)","v":0},"note",null,{"$f":"IF('Worksht1 - Field Flow'!E43>50,\"!!!! 50 gpm max flow\",\"-\")","v":"-"}]
[null,null,{"$f":"IF(E47=\"Hydraulic\",\"Note minimum pressure of 25 psi required for Hydraulic valves.Check pressure in Cell D28 above.\",\"-\")","v":"-"}]
[null,"Dosing"]
[null,null,"Number of doses per day / zone:",null,12,"doses","note"]
[null,null,"Timer ON. Pump run time per dose/zone:",null,{"$f":"SUM(I52+((J52*60/100)))","v":148.19964400142399},"mins:secs",{"$f":"+(E14/E33)/(E51*E19)","v":148.3327400023733},null,{"$f":"ROUNDDOWN(G52,0)","v":148},{"$f":"G52-I52","v":0.33274000237329915}]
[null,null,"Timer OFF.  Pump off time between doses",null,{"$f":"TEXT(G53/24,\"h:mm\")","v":{"$error":"#VALUE!"}},"hrs:mins",{"$f":"((24/E51))-(G52/60)-E56-E59","v":-0.47325400003955492}]
[null,null,"Per Zone - Pump run time per day/zone:",null,{"$f":"TEXT(G54/24,\"h:mm\")","v":"5:40"},"hrs:mins",{"$f":"SUM((E14/E19)/(E33*60))","v":29.666548000474663}]
[null,null,"All Zones - Number of doses per day / all zones",null,{"$f":"+E51*E19","v":12},"doses / day"]
[null,null,"Allow time for field to pressurize",null,"00:00:30","hrs:mins:secs",{"$f":"(E56-INT(E56))*24*60","v":0.5}]
[null,null,"Filter flush timer",null,"00:00:20","hrs:mins:secs",{"$f":"(E57-INT(E57))*24*60","v":0.33333333333333331},"note"]
[null,null,"Drain timer",null,"00:05:00","hrs:mins:secs",{"$f":"(E58-INT(E58))*24*60","v":5},"note"]
[null,null,"Field flush timer",null,"00:01:00","hrs:mins:secs",{"$f":"(E59-INT(E59))*24*60","v":1},"note"]
[null,null,"Field flush counter",null,3,"cycles","note"]
[null,null,"Time required to complete all functions per day",null,{"$f":"Macros!C104","v":"! ! !"},"hrs:mins",{"$f":"+((G59+G58+G57+G56+G52)*E51*E19)/60","v":31.03321466714133},{"$f":"IF(E61=\"! ! !\",Macros!B108,0)","v":"Not enough time in the day to perform parameters as entered. Try to increase flows per zone or decrease flush and drain times. Alternatively, reduce zones or add pumps."}]
[null,"Dose volume per zone",null,null,{"$f":"+G52*E33","v":208.33333333333331},"gallons per dose","note"]
[null,null,{"$f":"IF(I60>(G53*60),Macros!B108,0)","v":"Not enough time in the day to perform parameters as entered. Try to increase flows per zone or decrease flush and drain times. Alternatively, reduce zones or add pumps."}]
[null,null,"Allow time in the day for controller to have pressurization and drainage time."]
[]
[]
[]
[]
[]
[]
[null,"Flush Cycle Flow formula"]
[null,null,"Drip tube diameter",null,0.55000000000000004,"in"]
[null,null,"Drip Tube Diameter",null,{"$f":"E72/12","v":4.5833333333333337E-2},"ft"]
[null,null,"Drip Tube Cross Sectional Area",null,{"$f":"(E73^2)*3.14/4","v":1.6490451388888893E-3},"ft2"]
[null,null,"Flow required per dripline for flush velocity",null,{"$f":"E37*E74","v":3.2980902777777787E-3},"ft3/sec"]
[]
[null,"Volume in Dripfield",null,null,null,"V = π d * d /4 * h "]
[null,"Dripline Volume Formula"]
[null,null,"Tubing Inside diameter",null,0.55000000000000004,"inches","(linear inches * pie * (ID/2)squared) = cubic inches"]
[null,null,"Total length of WASTEFLOW dripline / zone",null,{"$f":"+E23","v":318},"ft","1728 cubic inches in a cubic ft."]
[null,null,"Total Volume in dripline / zone",null,{"$f":"+((((E79/2)*(E79/2))*(E80*12))*3.1416)/1728*7.481","v":3.925008111062501},"gallons","7.481 gallons in a cubic ft."]
[null,"Supply line Volume"]
[null,null,"Inside diameter",1.25,{"$f":"IF(D83=1.25,1.38,C92)","v":1.38},"inches"]
[null,null,"Length",null,87,"ft"]
[null,null,"Total Volume in supply line",null,{"$f":"+((((E83/2)*(E83/2))*(E84*12))*3.1416)/1728*7.481","v":6.7602924670049989},"gallons"]
[null,"Return line Volume"]
[null,null,"Inside diameter",2,{"$f":"IF(D87=1.25,1.38,C93)","v":2.0670000000000002},"inches"]
[null,null,"Length",null,87,"ft"]
[null,null,"Total Volume in supply line",null,{"$f":"+((((E87/2)*(E87/2))*(E88*12))*3.1416)/1728*7.481","v":15.166601135298116},"gallons"]
[]
[null,"Total recharge volume",null,null,{"$f":"+E89+E85+E81","v":25.851901713365613}]
[null,null,{"$f":"IF(D83=2,2.067,D92)","v":"Fill in actual ID"},"Fill in actual ID"]
[null,null,{"$f":"IF(D87=2,2.067,D93)","v":2.0670000000000002},"Fill in actual ID"]
[]
[]
[]
[]
[]
[]
[]
[null,null,"TOTAL RECHARGE VOLUME FOR DRIP SYSTEM"]
[]
[null,null,"2 INCH FORCE MAIN (25 feet)"]
[]
[null,null,null,null,null,{"$f":"(3.1416*((E72*E72)/12)/4*1)*E80*12","v":75.551552999999998}]
[]
[null,null,"V =  π(2.067*2.067/12)/4 * 1"]
[null,null,"V =  0.0932/4 * 1"]
[null,null,"V = 0.0233 cubic feet * 7.48 gallons per cubic feet"]
[null,null,"V = 0.1743 gallons per linear feet * 25 linear feet "]
[null,null,"V = 4.36 Gallons"]
[]
[null,null,"1.25 INCH SUPPLY MANIFOLD (TOTAL OF 87 FEET PER ZONE)"]
[]
[null,null,"V =  π(1.380*1.380/12)/4 * 1"]
[null,null,"V = 0.010387 cubic feet * 7.48 gallons per cubic feet"]
[null,null,"V = 0.07769 gallons per linear feet * 87 linear feet "]
[null,null,"V = 6.76 Gallons"]
[]
[null,null,"0.5 INCH PC GEOFLOW WASTEFLOW DRIPLINES (850 FEET)"]
[]
[null,null,"V =  π(0.55*0.55/12)/4 * 1"]
[null,null,"V =  0.0066/4 * 1"]
[null,null,"V = 0.00165 cubic feet * 7.48 gallons per cubic feet"]
[null,null,"V = 0.0123 gallons per linear feet * 850 linear feet "]
[null,null,"V =10.49 Gallons"]
[]
[null,null,"TOTAL RECHARGE VOLUME REQUIRED = 21.61 GALLONS"]
[]
[]
[]
[null,null,"FILTERS","Column1","Column2","Column3"]
[null,null,"Vortex Filters","Select filter from drop-down menu (left)",{"$f":"IF($N$47=C133,D133,E134)","v":0}]
[null,null,"AP4E-.75F    /  Max flow 10 gpm",{"$f":"+Macros!A45","v":"AP4E-1F"},0]
[null,null,"AP4E-1F      /  Max flow 20 gpm",{"$f":"+Macros!A46","v":"AP4E-1.5F"},0]
[null,null,"AP4E-1.5F     / Max flow 45 gpm",{"$f":"+Macros!A47","v":"AP4E-2F"},0]
[null,null,"AP4E-2F     /  Max flow 70 gpm",{"$f":"+Macros!A48","v":"AP4E-2F"},0]
[null,null,"Disc Filter","Select filter from drop-down menu (left)",0]
[null,null,"BioDisc-150   / Max flow 30 gpm",{"$f":"+Macros!A59","v":"BioDisc Battery 2"},0]
[null,null,"BioDisc-200   / Max flow 60 gpm",{"$f":"+Macros!A60","v":"BioDisc Battery  4"},0]
[null,null,"Geovac Filters","Select filter from drop-down menu (left)",0]
[null,null,"GeoVac75-02   / Max flow 75 gpm",{"$f":"+Macros!A51","v":"BioDisc Filter-150"},0]
[null,null,"GeoVac150-03  / Max flow 150 gpm",{"$f":"+Macros!A52","v":"BioDisc Filter-200"},0]
[null,null,"GeoVac250-04  / Max flow 250 gpm",{"$f":"+Macros!A53","v":0},0]
[null,null,"GeoVac500-06  / Max flow 500 gpm",{"$f":"+Macros!A54","v":0},0]
[null,null,"GeoVac700-08  / Max flow 700 gpm",{"$f":"+Macros!A55","v":0},{"$f":"IF($N$47=C146,D146,E148)","v":0}]
[null,null,"Column1",null,{"$f":"IF($N$47=C147,D147,E149)","v":0}]
[null,null,"ZONE VALVES"]
[null,null,"Electric solenoid","Select valve from drop-down menu (left)",{"$f":"IF($N$48=C149,D149,E150)","v":0}]
[null,null,{"$f":"+Macros!C72","v":"1-in. Solenoid valve"},{"$f":"+Macros!B72","v":"SVLVB-100"},0]
[null,null,{"$f":"+Macros!C73","v":"1.5-in. Solenoid valve"},{"$f":"+Macros!B73","v":"SVLVB-150"},0]
[null,null,{"$f":"+Macros!C74","v":"2-in. Solenoid valve"},{"$f":"+Macros!B74","v":"SVLVB-200"},0]
[null,null,{"$f":"+Macros!C75","v":"3-in. Solenoid valve"},{"$f":"+Macros!B75","v":"SVLVB-300"},0]
[null,null,"Index/Hydraulic valves","Select valve from drop-down menu (left)",0]
[null,null,{"$f":"+Macros!J71","v":"2 zone Index valve 1.25x1.25\", 25-75psi, >9gpm"},{"$f":"+Macros!H71","v":"HT-4402"},0]
[null,null,{"$f":"+Macros!J72","v":"3 zone Index valve 1.25x1.25\", 25-75psi, >9gpm"},{"$f":"+Macros!H72","v":"HT-4403"},0]
[null,null,{"$f":"+Macros!J73","v":"4 zone Index valve 1.25x1.25\", 25-75psi, >9gpm"},{"$f":"+Macros!H73","v":"HT-4404"},0]
[null,null,{"$f":"+Macros!J74","v":"5 zone Index valve 1.25x1\", 25-75psi, >9gpm"},{"$f":"+Macros!H74","v":"HT-4605"},0]
[null,null,{"$f":"+Macros!J75","v":"6 zone Index valve 1.25x1\", 25-75psi, >9gpm"},{"$f":"+Macros!H75","v":"HT-4606"},0]
[null,null,{"$f":"+Macros!H76","v":0}]
[null,null,{"$f":"+Macros!H77","v":0}]

{"sheet":"Worksht2 - Pump Sizing","index":3,"n_rows":169,"n_cols":9,"rows_kept":169,"cut":false,"hidden":false,"merged":[[26,3,26,4],[51,3,51,4],[25,3,25,4],[1,0,1,6],[12,0,12,6],[5,0,5,2],[6,0,6,2],[11,0,11,2],[16,1,16,2],[17,1,17,2],[7,1,7,5],[52,1,52,2],[57,1,57,2],[65,1,65,2],[59,1,59,2],[60,1,60,2]]}
[null,null,null,null,null,null,null,null,{"$f":"Intro.!P4","v":"Updated Jan. 2015"}]
["PUMP SIZING"]
["Job Description:",null,null,{"$f":"+'Worksht1 - Field Flow'!D3","v":"Fill in Job Site"}]
["Contact:",null,null,{"$f":"+'Worksht1 - Field Flow'!D4","v":"Fill in Customer name"}]
["Prepared by:",null,null,{"$f":"+'Worksht1 - Field Flow'!D5","v":"Fill in Designer name, email, phone"}]
["Date:",null,null,{"$f":"'Worksht1 - Field Flow'!D6","v":"Fill in date 7/31/2014"}]
[]
[null,{"$f":"+'Worksht1 - Field Flow'!B8:F8","v":"Please fill in the shaded areas and drop down menus:"}]
[null,{"$f":"+'Worksht1 - Field Flow'!B9","v":"This spreadsheet is a guide for small systems with residential waste & is not a complete hydraulic design."}]
[null,"Pressure losses may be grossly overstated, particularly if designing with WASTEFLOW Classic"]
[null,"The letters on the diagram(right) match the letters in section 2 below.  "]
[]
["Worksheet - Pump Sizing"]
[]
["Section 1 - Summary from Worksheet 1"]
[null,"Flow required to dose field",null,{"$f":"+'Worksht1 - Field Flow'!E33","v":1.4045000000000001},"gpm"]
[null,"Flow required to flush field",null,{"$f":"+'Worksht1 - Field Flow'!E42","v":1.4801829166666671},"gpm"]
[null,"Flow required to dose & flush field",null,{"$f":"+'Worksht1 - Field Flow'!E43","v":2.8846829166666672},"gpm"]
[null,"Filter",null,null,{"$f":"'Worksht1 - Field Flow'!E46","v":"Select filter above"}]
[null,"No. of Zones",null,{"$f":"'Worksht1 - Field Flow'!E19","v":1},"zones"]
[null,"Zone valve",null,null,{"$f":"'Worksht1 - Field Flow'!E48","v":0}]
[null,"Dripline",null,null,{"$f":"+Macros!G204","v":"Wasteflow PC - 1/2gph"}]
[null,"Dripline longest lateral",null,{"$f":"+'Worksht1 - Field Flow'!E39","v":318},"ft.",null,null,{"$f":"+'Worksht1 - Field Flow'!L39","v":0}]
[]
["Section 2",null,null,null,"Ft of head       ",null,"Pressure   "]
["A.  Flush line - Losses through return line"]
[null,null,"Select  Pipe from dropdown menu","PVC schedule 40"]
[null,null,"Select Flush Line Diameter","1/2\"","inch"]
[null,null,"Length of return line",172,"ft."]
[null,null,"Equivalent length of fittings",5,"ft."]
[null,null,"Elevation change. (if downhill enter 0)",8,"ft."]
[null,null,"Pressure loss in 100 ft of pipe",{"$f":"0.2083*((100/140)^1.852)*($D$17^1.852)/(D76^4.8655)","v":2.327003995096919},"ft.",{"$f":"+D32/2.31","v":1.0073610368384931},"psi"]
[null,null,"Total pressure loss from end of dripline to return tank",{"$f":"+D31+(((D29+D30)/100)*D32)","v":12.118797071321547},"ft.",{"$f":"+D33/2.31","v":5.2462324984075961},"psi"]
["B.  Dripline - Losses through Wasteflow dripline"]
[null,null,"Length of longest dripline lateral",{"$f":"+'Worksht1 - Field Flow'!E39","v":318},"ft."]
[null,null,"Minimum dosing pressure required at end of dripline",{"$f":"+F36*2.31","v":23.1},"ft.",{"$f":"IF(F33<10,10,F33)","v":10},"psi"]
[null,null,"Loss through dripline during flushing",{"$f":"+F37*2.31","v":13.259400000000001},"ft.",{"$f":"+'T1-Dripline'!A136","v":5.74},"psi",{"$f":"IF(F37=\"Dripline too long\", \"NOTE: Dripline lateral too long\",\"-\")","v":"-"}]
[null,null,"Total minimum required dripline pressure",{"$f":"D36+D37","v":36.359400000000001},"ft.",{"$f":"+D38/2.31","v":15.74},"psi","If back pressure when flushing is positive then add this pressure to this number.  If flushing downhill then use this number."]
[null,null,null,{"$f":"+D38","v":36.359400000000001},{"$f":"+D38+D33","v":48.478197071321546}]
["A+B.  Minimum Pressure required at beginning of dripfield"]
[null,"     CALCULATED pressure required at beginning of dripfield",null,{"$f":"IF(D33<=0,D39,E39)","v":48.478197071321546},{"$f":"E42","v":"ft."},{"$f":"+D41/2.31","v":20.986232498407595},"psi"]
[null,"     SPECIFIED pressure at beginning of dripfield (from worksht 1)",null,{"$f":"'Worksht1 - Field Flow'!E31","v":46.2},"ft.",{"$f":"+D42/2.31","v":20},"psi"]
[null,{"$f":"IF(D41<D42,\"    Great! SPECIFIED Pressure is greater than CALCULATED Pressure requirement. Go to next step\",\"     !!!  Urgent revision required SPECIFIED pressure must be greater than CALCULATED pressure and lower than 50 psi\")","v":"     !!!  Urgent revision required SPECIFIED pressure must be greater than CALCULATED pressure and lower than 50 psi"}]
["C.  Drip components - Losses through headworks"]
[null,null,"Filter",{"$f":"+F45*2.31","v":{"$error":"#VALUE!"}},"ft.",{"$f":"IF(E19=Macros!B165,Macros!C166,Macros!A179)","v":"Check filter"},"psi"]
[null,null,"Zone valve pressure loss (not in diagram)",{"$f":"+F46*2.31","v":0},"ft.",{"$f":"IF(D20=1,0,Macros!H163)","v":0},"psi"]
[null,null,"Flow meter pressure loss (not in diagram)",null,"ft.",{"$f":"+D47/2.31","v":0},"psi"]
[null,null,"Other pressure losses",null,"ft.",{"$f":"+D48/2.31","v":0},"psi"]
[null,null,"Total loss through drip components",{"$f":"SUM(D45:D48)","v":{"$error":"#VALUE!"}},"ft.",{"$f":"SUM(F45:F48)","v":0},"psi"]
[]
["D.  Supply line - Minimum Pressure head required to get from pump tank to top of dripfield"]
[null,null,"Select  Pipe from dropdown menu","PVC schedule 40"]
[null,"    Select Supply line diameter",null,"1-1/2\"","inch"]
[null,null,"Length of supply line",200,"ft."]
[null,null,"Equivalent length of fittings",5,"ft."]
[null,null,"Height from pump to tank outlet",5,"ft."]
[null,null,{"$f":"+C31","v":"Elevation change. (if downhill enter 0)"},{"$f":"+D31*-1","v":-8},"ft."]
[null,"      Pressure loss/gain in 100 ft. of pipe",null,{"$f":"0.2083*((100/140)^1.852)*($D$18^1.852)/($D$82^4.8655)","v":7.8315999879886231E-2},"ft.",{"$f":"+D58/2.31","v":3.3903030251033001E-2},"psi","START HERE"]
[null,null,"Total gain or loss from pump to field",{"$f":"++D56+D57+(((D55+D54)/100)*D58)","v":-2.8394522002462335},"ft.",{"$f":"+D59/2.31","v":-1.229200086686681},"psi"]
[null,"Total dynamic head",null,{"$f":"+D59+D49+D42","v":{"$error":"#VALUE!"}},"ft.",{"$f":"+D60/2.31","v":{"$error":"#VALUE!"}},"psi"]
[null,"Pump capacity *      - Field Flush Flow ",null,{"$f":"+D18","v":2.8846829166666672},"gpm",{"$f":"+F60","v":{"$error":"#VALUE!"}},{"$f":"+G60","v":"psi"}]
[null,"                                - Field Dose Flow",null,{"$f":"+D16","v":1.4045000000000001},"gpm"]
[null,"                                - Filter Flush Flow",null,{"$f":"IF('Worksht1 - Field Flow'!E45=Macros!A40,40,\"-\")","v":"-"},"gpm",{"$f":"+D63","v":"-"},"psi"]
[null,"Pump Model Number"]
[null,"Voltz / Hp / phase"]
[]
[null,"*","Note:  Pump capacity flow assumes flow in dripline does not change during a dose cycle.  With Wasteflow Classic this can be grossly over stated."]
[null,null,"For more accurate flows please see Geoflow's  Flushing worksheet."]
[null,null,"If you need assistance designing for this additional flow, please "]
[null,null,"a.  See Geoflow flushing worksheet or"]
[null,null,"b.  Contact Geoflow at 800-828-3388."]
[null,null,"For pressure loss through the dripline please refer to \"Table1-Dripline\" Worksheet in this file or Geoflow Design Guidelines or Geoflow's Flushing worksheet.  "]
[null,null,"These are all available online at www.geoflow.com or by phoning 800-828-3388."]
[]
[null,null,"Flushline"]
[null,null,"Inside Diameter",{"$f":"VLOOKUP(D$79,$C$109:$H$168,5,FALSE)","v":0.622}]
[null,null,"Pipe Code selected",{"$f":"IF(D27=C89,D89,E77)","v":"A"},{"$f":"IF(D27=C90,D90,F77)","v":"False"},{"$f":"IF(D27=C92,D92,G77)","v":"False"},{"$f":"IF(D27=C92,D92,\"False\")","v":"False"}]
[null,null,"Diameter Code selected",{"$f":"+D28","v":"1/2\""}]
[null,null,"Pip + ID Code",{"$f":"CONCATENATE(D77,D78)","v":"A1/2\""}]
[]
[null,null,"Supply Line"]
[null,null,"Inside Diameter",{"$f":"VLOOKUP(D$85,$C$109:$H$168,5,FALSE)","v":1.61}]
[null,null,"Pipe Code selected",{"$f":"IF(D52=C89,D89,E83)","v":"A"},{"$f":"IF(J56=C90,D90,F83)","v":"False"},{"$f":"IF(J56=C91,D91,G83)","v":"False"},{"$f":"IF(J56=C91,D91,\"False\")","v":"False"}]
[null,null,"Diameter Code selected",{"$f":"+D53","v":"1-1/2\""}]
[null,null,"Pip + ID Code",{"$f":"CONCATENATE(D83,D84)","v":"A1-1/2\""}]
[]
[null,null,"Drop Down Lists",null,"Drop Down Lists"]
[null,null,"Types of pipe","Code","Diameters","Code"]
[null,null,"PVC schedule 40","A","Column1","Column2"]
[null,null,"PVC schedule 80","B","1/2\"",1]
[null,null,"PVC Series 200","C","5/8\"",2]
[null,null,"PVC Series 160","D","3/4\"",3]
[null,null,"HDPE IPS SDR9",null,"1\"",4]
[null,null,"HDPE IPS SDR11",null,"1-1/4\"",5]
[null,null,"HDPE IPS SDR13",null,"1-1/2\"",6]
[null,null,"HDPE IPS SDR17",null,"2\"",7]
[null,null,"HDPE SIDR 9 (160 Pump Drop)",null,"2-1/2\"",8]
[null,null,"HDPE CTS 3408",null,"3\"",9]
[null,null,"PEX CTS SDR9",null,"4\"",10]
[null,null,null,null,"5\"",11]
[null,null,null,null,"6\"",12]
[null,null,null,null,"8\"",13]
[null,null,null,null,"10\"",14]
[null,null,null,null,"12\""]
[]
[null,null,"Number","Nominal size","OD","Wall thickness","ID","HW"]
[null,null,null,"Inches","Inches",null,"Inches","Coefficient"]
[null,null,{"$f":"C89","v":"PVC schedule 40"},null,null,"Inches"]
[null,null,{"$f":"CONCATENATE($D$89,E90,)","v":"A1/2\""},0.5,0.84,0.109,0.622,150]
[null,null,{"$f":"CONCATENATE($D$89,E91,)","v":"A5/8\""},null,"NA","NA","NA"]
[null,null,"A3/4\"",0.75,1.05,0.113,0.82399999999999995,150]
[null,null,"A1\"",1,1.3149999999999999,0.13300000000000001,1.0489999999999999,150]
[null,null,"A1-1/4\"",1.25,1.66,0.14000000000000001,1.38,150]
[null,null,"A1-1/2\"",1.5,1.9,0.14499999999999999,1.61,150]
[null,null,"A2\"",2,2.375,0.154,2.069,150]
[null,null,"A2-1/2\"",2.5,2.875,0.20300000000000001,2.4689999999999999,150]
[null,null,"A3\"",3,3.5,0.216,3.0680000000000001,150]
[null,null,"A4\"",4,4.5,0.23699999999999999,4.0259999999999998,150]
[null,null,"A5\"",5,5.5629999999999997,0.25800000000000001,5.0469999999999997,150]
[null,null,"A6\"",6,6.625,0.28000000000000003,6.0650000000000004,150]
[null,null,"A8\"",8,8.625,0.32200000000000001,7.9809999999999999,150]
[null,null,"A10\"",10,10.75,0.36499999999999999,10.02,150]
[null,null,{"$f":"CONCATENATE('[1]T4-PVC'!$Y$14,'[1]T4-PVC'!AC73,)","v":{"$error":"#REF!"}}]
[null,null,{"$f":"C90","v":"PVC schedule 80"}]
[null,null,{"$f":"CONCATENATE($D$90,E90,)","v":"B1/2\""},0.5,0.84,0.14699999999999999,0.54600000000000004,150]
[null,null,{"$f":"CONCATENATE($D$90,E91,)","v":"B5/8\""},null,"NA","NA","NA"]
[null,null,"B3/4\"",0.75,1.05,0.154,0.74199999999999999,150]
[null,null,"B1\"",1,1.3149999999999999,0.17899999999999999,0.95699999999999996,150]
[null,null,"B1-1/4\"",1.25,1.66,0.191,1.278,150]
[null,null,"B1-1/2\"",1.5,1.9,0.2,1.5,150]
[null,null,"B2\"",2,2.375,0.218,1.9390000000000001,150]
[null,null,"B2-1/2\"",2.5,2.875,0.27600000000000002,2.323,150]
[null,null,"B3\"",3,3.5,0.3,2.9,150]
[null,null,"B4\"",4,4.5,0.33700000000000002,3.8260000000000001,150]
[null,null,"B5\"",5,5.5629999999999997,0.375,4.8129999999999997,150]
[null,null,"B6\"",6,6.625,0.432,5.7610000000000001,150]
[null,null,"B8\"",8,8.625,0.5,7.625,150]
[null,null,"B10\"",10,10.75,0.59299999999999997,9.5640000000000001,150]
[null,null,{"$f":"C91","v":"PVC Series 200"},null,null,null,null,150]
[null,null,{"$f":"CONCATENATE($D$91,E90,)","v":"C1/2\""},0.5,"NA","NA","NA",150]
[null,null,{"$f":"CONCATENATE($D$91,E91,)","v":"C5/8\""},null,"NA","NA","NA",150]
[null,null,"C3/4\"",0.75,1.05,0.06,0.93,150]
[null,null,"C1\"",1,1.3149999999999999,6.3E-2,1.1890000000000001,150]
[null,null,"C1-1/4\"",1.25,1.66,7.9000000000000001E-2,1.502,150]
[null,null,"C1-1/2\"",1.5,1.9,0.09,1.72,150]
[null,null,"C2\"",2,2.375,0.113,2.149,150]
[null,null,"C2-1/2\"",2.5,2.875,0.13700000000000001,2.601,150]
[null,null,"C3\"",3,3.5,0.16700000000000001,3.1659999999999999,150]
[null,null,"C4\"",4,4.5,0.214,4.0720000000000001,150]
[null,null,"C5\"",5,"NA","NA","NA",150]
[null,null,"C6\"",6,6.625,0.316,5.9930000000000003,150]
[null,null,"C8\"",8,8.625,0.41,7.8049999999999997,150]
[null,null,"C10\"",10,"NA","NA","NA",150]
[null,null,{"$f":"C92","v":"PVC Series 160"},null,"NA","NA","NA",150]
[null,null,{"$f":"CONCATENATE($D$92,E90,)","v":"D1/2\""},0.5,"NA","NA","NA",150]
[null,null,{"$f":"CONCATENATE($D$92,E91,)","v":"D5/8\""},null,"NA","NA","NA",150]
[null,null,"D3/4\"",0.75,"NA","NA","NA",150]
[null,null,"D1\"",1,"NA","NA","NA",150]
[null,null,"D1-1/4\"",1.25,1.66,6.4000000000000001E-2,1.532,150]
[null,null,"D1-1/2\"",1.5,1.9,0.08,1.74,150]
[null,null,"D2\"",2,2.375,9.0999999999999998E-2,2.1930000000000001,150]
[null,null,"D2-1/2\"",2.5,2.875,0.11,2.6549999999999998,150]
[null,null,"D3\"",3,3.5,0.13500000000000001,3.23,150]
[null,null,"D4\"",4,4.5,0.17299999999999999,4.1539999999999999,150]
[null,null,"D5\"",5,5.5629999999999997,0.214,5.1349999999999998,150]
[null,null,"D6\"",6,6.625,0.255,6.1150000000000002,150]
[null,null,"D8\"",8,8.625,0.33200000000000002,7.9610000000000003,150]
[null,null,"D10\"",10,10.75,0.41299999999999998,9.9239999999999995,150]
[null,null,{"$f":"CONCATENATE(#REF!,'[1]T4-PVC'!AC118,)","v":{"$error":"#REF!"}},null,12.75,0.49,11.77,150]

{"sheet":"Parts List ","index":4,"n_rows":228,"n_cols":23,"rows_kept":228,"cut":false,"hidden":false,"merged":[[1,0,1,6],[2,2,2,6],[3,2,3,6],[4,2,4,6],[2,0,2,1],[3,0,3,1],[4,0,4,1],[11,0,11,6],[5,0,5,1],[21,0,21,5],[38,0,38,5],[30,0,30,5],[23,0,23,5],[19,0,19,5],[5,2,5,6],[13,4,13,5],[32,0,32,5],[12,4,12,5],[36,0,36,5],[28,0,28,5],[17,4,17,5],[15,4,15,5],[18,4,18,5],[57,4,57,5],[56,4,56,5],[55,4,55,5],[49,4,49,5],[52,0,52,5],[53,6,54,6],[53,7,54,7],[14,0,14,5],[16,0,16,5],[40,4,40,5]]}
[]
["GEOFLOW PARTS LIST",null,null,null,null,null,null,null,{"$f":"Intro.!P4","v":"Updated Jan. 2015"}]
["Job Description:",null,{"$f":"+'Worksht1 - Field Flow'!D3:F3","v":{"$error":"#VALUE!"}}]
["Contact:",null,{"$f":"+'Worksht1 - Field Flow'!D4:F4","v":{"$error":"#VALUE!"}}]
["Prepared by:",null,{"$f":"+'Worksht1 - Field Flow'!D5:F5","v":{"$error":"#VALUE!"}}]
["Date:",null,{"$f":"+'Worksht1 - Field Flow'!D6:F6","v":{"$error":"#VALUE!"}}]
[]
["Some of the following parts list will \"self fill\" as a guide and should not be construed as a complete parts list. Check item numbers and quantities against design layout."]
["Most \"Item Number\" cells have a drop down menu to select from.  Just click mouse on the desired cell to find dropdown arrow"]
["Recommended list prices are subject to change. For actual prices contact your local Geoflow dealer"]
["Prices for large systems may be overstated in this scenario"]
["Worksheet 3 - Parts List"]
[]
["Qty","Units","Item Number",null,"Description"]
["Dripline"]
[{"$f":"+'Worksht1 - Field Flow'!E23*'Worksht1 - Field Flow'!E19","v":318},"ft.",{"$f":"IF('Worksht1 - Field Flow'!E25= Macros!A4,Macros!A115,Macros!B115)","v":"WFPC16-2-24"},null,{"$f":"+IF(C16=\"WF 16 4 06\",\"Wasteflow Classic - 1 gph, 6in. Emitter spacing\",Macros!D115)","v":"Wasteflow PC . 1/2gph, 24in. emitter spacing"}]
["Airvent and box"]
[{"$f":"+'Worksht1 - Field Flow'!E19*2","v":2},"ea.","APVBK-1",null,{"$f":"IF(C18=B146,C146,D147)","v":"1\" airvent for use on zones less than 50gpm"}]
[{"$f":"+A18","v":2},"ea.","AV BOX 6 inch",null,{"$f":"IF(C19=B148,C148,C149)","v":"6\" round box"}]
["Pressure Regulators - Use to keep pressure from being too high"]
[{"$f":"+'Worksht1 - Field Flow'!E19","v":1},"ea.","Select",null,{"$f":"IF(C21=B151,C151,F152)","v":"Restricts pressure from exceeding required pressure. Required with Classic dripline."}]
["Controllers"]
[1,"ea.",null,null,{"$f":"E71","v":"Select Controller from list left"}]
["Pre-assembled Headworks"]
["Select from cell with",null,{"$f":"+'Worksht1 - Field Flow'!E45","v":"Select Filter"},null,null,null,null,null,null,{"$f":"IF('Worksht2 - Pump Sizing'!$E$19=\"Select filter\",\"-\",'Worksht2 - Pump Sizing'!$E$19)","v":"Select filter above"}]
[{"$f":"IF(C25=\"Vortex Screen Filter\",1,0)","v":0},{"$f":"IF(A26=1,\"ea.\",\"-\")","v":"-"},"   WHWS-V-1F-A",null,{"$f":"IF(AND($J$25=B133,B134,B135,B136),\"Select Vortex Headworks here\",E93)","v":"Sporty Headworks box & guts with 1\" Vortex Filter. Automatic flush"}]
[{"$f":"IF(C25=\"BioDisc filter\",1,0)","v":0},{"$f":"IF(A27=1,\"ea.\",\"-\")","v":"-"},"BIODISC Filter Headworks",null,{"$f":"IF(AND($J$25=B137,B138),E112,E113)","v":"-"}]
[{"$f":"IF(C25=\"GeoVac Screen Filter\",1,0)","v":0},{"$f":"IF(A28=1,\"ea.\",\"-\")","v":"-"},"GEOVAC filter Headworks",null,{"$f":"IF(AND($J$25=B139,B140,B141,B142,B143),\"Select GeoVac Headworks here\",E126)","v":"-"}]
["*    Solenoid Flush valves - Select only if Headworks is not selected above"]
[null,"ea.","SVLV-B-100",null,{"$f":"IF($C$30=B169,C169,G170)","v":"Flush valves"}]
["*    Filters - Select only if Headworks is not selected above"]
[null,"ea.",{"$f":"+Macros!A43","v":"ConsultFActory"},null,{"$f":"IF(C32=B133,C133,E134)","v":0}]
["*    Pressure Gauges - Select only if Headworks is not selected above"]
[null,"ea.","PG-25-Lead",null,{"$f":"IF(C34=B195,C195,C196)","v":"Presssure gauge with lead"}]
["Flow Meters"]
[1,"ea.","Flow Meter - Digital Display ",null,{"$f":"IF(C36=B207,\"Select Flow Meter\",D208)","v":"Select Flow Meter"}]
["Zone valves -"]
[{"$f":"IF(AND('Worksht1 - Field Flow'!E47=\"Electric Solenoid\",'Worksht1 - Field Flow'!E19>1),'Worksht1 - Field Flow'!E19,0)","v":0},"ea.",{"$f":"'Worksht1 - Field Flow'!E48","v":0},null,{"$f":"IF(C38=B169,C169,F170)","v":0}]
["Dripline fittings - Quantities below are estimates only."]
[{"$f":"+'Worksht1 - Field Flow'!E38*'Worksht1 - Field Flow'!E19*2","v":2},"ea.","LTSLIP-600",null,"Lockslip Adapter. 3/4\" PVC slip to Wasteflow dripline"]
[{"$f":"+A16/500*2","v":1.272},"ea.","LTC-600",null,"This adds 2 couplings for each coil ordered."]
[null,"ea.","LTTEE-600",null,"Lockslip Tee.  Fits 16mm Wasteflow dripline"]
[null,"ea.","LTELL-600",null,"Lockslip Elbow.  Fits 16mm Wasteflow dripline"]
[null,"ea.","LTFlex-R-18",null,"18\" flex PVC riser with 1 lockslip adapter.  Used for risers"]
[null,"ea.","LTFlex-L-36",null,"36\" flex PVC with 2 lockslip adapters.  Used for risers or loops"]
["Check Valves - Check design for quantities"]
[null,"ea.","CV-B-10",null,{"$f":"IF(C47=B179,C179,E180)","v":"  1\" True Union ball check PVC/Viton"}]
[null,"ea.","Spring check",null,{"$f":"IF(C48=B185,C185,E186)","v":"Select size from drop down menu left"}]
["Unions"]
[null,"ea.","Unions",null,{"$f":"+D221","v":0}]
[null,null,null,null,null,null,"Subtotal"]
[]
["Non-Geoflow items"]
[null,"ea.","Pump Capacity    (gpm)",null,{"$f":"+'Worksht2 - Pump Sizing'!D60","v":{"$error":"#VALUE!"}},"gpm"]
[null,null,"                               TDH (ft)",null,{"$f":"+'Worksht2 - Pump Sizing'!D61","v":2.8846829166666672},"ft of head"]
[null,"ea.","Pump tank",null,"                Fill in description"]
[null,"ea.","Floats",null,"                Fill in description"]
[null,"ft.","PVC mainline",null,"                Fill in description"]
[null,"ft.","PVC Supply manifold (inches)",null,{"$f":"+'Worksht2 - Pump Sizing'!D53","v":"1-1/2\""},"\" PVC pipe"]
[null,"ft.","PVC Return manifold (inches)",null,{"$f":"+'Worksht2 - Pump Sizing'!D28","v":"1/2\""},{"$f":"+F59","v":"\" PVC pipe"}]
[{"$f":"+A40/2","v":1},"ea.","PVC Supply manifold tees",null,{"$f":"+E59","v":"1-1/2\""},"\" x 3/4 \" tees"]
[{"$f":"+A40/2","v":1},"ea.","PVC Return manifold tees",null,{"$f":"+E60","v":"1/2\""},"\" x 3/4 \" tees"]
[null,null,"PVC parts - Misc"]
[]
[]
[null,null,null,null,null,null,"Total",{"$f":"SUM(H54:H65)+H51","v":0}]
[]
[]
["   -  PLEASE DO NOT WORK BELOW THIS LINE. TABLES ARE STORED HERE THAT WILL AFFECT AUTOMATIC CELL FILLS",null,null,null,null,null,null,"   -    PLEASE DO NOT WORK BELOW THIS LINE. TABLES ARE STORED HERE THAT WILL AFFECT AUTOMATIC CELL FILLS",null,null,null,null,null,null,null,null,null,null,null,null,null,null,"   -    PLEASE DO NOT WORK BELOW THIS LINE. TABLES ARE STORED HERE THAT WILL AFFECT AUTOMATIC CELL FILLS"]
["Controllers","Select Controller"]
[null,"Logo controllers:","Logo PLC controllers",null,{"$f":"IF($C$23=B71,C71,E72)","v":"Select Controller from list left"},null,{"$f":"IF($C$23=B71,F71,G72)","v":0}]
[null,"  GEO1-SIM-MAN","  1 zone,115/230VAC, Simplex pump, 1 phase, 3/4 hp max, Manual flush",null,"Select Controller from list left",875,0]
[null,"  GEO1-SIM-AUT","  1 zone,115/230VAC, Simplex pump, 1 phase, 3/4 hp max, Automaticl flush",null,"Select Controller from list left",1043,0]
[null,"  GEO1-DUP-MAN","  1 zone,115/230VAC, Duplex pump, 1 phase, 3/4 hp max, Manual flush",null,"Select Controller from list left",1160,0]
[null,"  GEO1-DUP-AUT","  1 zone,115/230VAC, Duplex pump, 1 phase, 3/4 hp max, Automatic flush",null,"Select Controller from list left",1485,0]
[null,"  GEO4-SIM-AUT","  2-4 zone,115/230VAC, Simplex pump, 1 phase, 2 hp max, Automatic flush",null,"Select Controller from list left",1671,0]
[null,"  GEO4--DUP-AUT","  2-4 zone,115/230VAC, Duplex pump, 1 phase, 2 hp max, Automatic flush",null,"Select Controller from list left",1971,0]
[null,"  GEO8-SIM-AUT","  5-8 zone,115/230VAC, Simplex pump, 1 phase, 2 hp max, Automatic flush",null,"Select Controller from list left",2054,0]
[null,"  GEO8-DUP-AUT","  5-8 zone,115/230VAC, Duplex pump, 1 phase, 2 hp max, Automatic flush",null,"Select Controller from list left",2860,0]
[null,"Touchscreen controllers:","PLC controller with touchscreen interface",null,"Select Controller from list left",null,0]
[null,"  GEOTS-08-SIM","  1 -8 zone Touchscreen, simplex pump, Auto flush",null,"Select Controller from list left",3400,0]
[null,"  GEOTS-08-DUP","  1 -8 zone Touchscreen, duplex pump, Auto flush",null,"Select Controller from list left",{"$f":"+F81","v":3400},0]
[null,"  GEOTS-16-SIM","  9-16 zone Touchscreen, simplex pump, Auto flush",null,"Select Controller from list left",4000,0]
[null,"  GEOTS-16-DUP","  9-16 zone Touchscreen, duplex pump, Auto flush",null,{"$f":"IF($C$23=B84,C84,E85)","v":"Select Controller from list left"},{"$f":"+F83","v":4000},0]
[null,"  GEOTS-24-SIM","  17-24 zone Touchscreen, simplex pump, Auto flush",null,{"$f":"IF($C$23=B85,C85,E86)","v":"Select Controller from list left"},4500,0]
[null,"  GEOTS-24-DUP","  17-24 zone Touchscreen, duplex pump, Auto flush",null,{"$f":"IF($C$23=B86,C86,\"Select Controller from list left\")","v":"Select Controller from list left"},{"$f":"+F85","v":4500},0]
[null,"Controller Lightening Box"]
[null,"GEOLITE 4","4 float lightening relay"]
[]
["VORTEX filter headworks",null,null,null,null,"List price"]
[null,"VORTEX filter headworks",null,null,null,null,{"$f":"IF($C$26=B92,F92,G93)","v":710}]
[null," SPORTY Headworks",null,null,null,null,{"$f":"IF($C$26=B93,F93,G94)","v":710}]
[null,"   WHWS-V-75F-A","Sporty Headworks box & guts with 3/4\" Vortex Filter. Automatic flush",null,{"$f":"IF($C$26=B93,C93,E94)","v":"Sporty Headworks box & guts with 1\" Vortex Filter. Automatic flush"},710,{"$f":"IF($C$26=B93,F93,G94)","v":710}]
[null,"   WHWS-V-75F-M","Sporty Headworks box & guts with 3/4\" Vortex Filter. Manual flush",null,"Sporty Headworks box & guts with 1\" Vortex Filter. Automatic flush",610,{"$f":"IF($C$26=B94,F94,G95)","v":710}]
[null,"   WHWS-V-1F-A","Sporty Headworks box & guts with 1\" Vortex Filter. Automatic flush",null,"Sporty Headworks box & guts with 1\" Vortex Filter. Automatic flush",710,710]
[null,"   WHWS-V-1F-M","Sporty Headworks box & guts with 1\" Vortex Filter. Manual flush",null,"-",610,0]
[null,"   WHWS-V-1.5F-A","Sporty Headworks box & guts with 1.5\" Vortex Filter. Automatic flush",null,"-",1170,0]
[null,"   WHWS-V-1.5F-M","Sporty Headworks box & guts with 1.5\" Vortex Filter. Manual flush",null,"-",972,0]
[null,"   WHWS-V-2F-A","Sporty Headworks box & guts with 2\" Vortex Filter. Automatic flush",null,"-",1251,0]
[null,"   WHWS-V-2F-M","Sporty Headworks box & guts with 2\" Vortex Filter. Manual flush",null,"-",1018,0]
[null," ULTRA Vortex Headworks - DDS","Flow meter has digital diplay in headworks, not logged on controller",null,"-",null,0]
[null,"   WHWU-75F-V-A-DDS","Ultra. Vortex Filter Max 10 gpm, Auto flush in WHWU-Box-S, 1\" Flow meter w/ local display",null,{"$f":"IF($C$26=B102,C102,E103)","v":"-"},1837.42,0]
[null,"   WHWU-1F-V-A-DDS","Ultra. 1\" Vortex Filter max 20gpm, Auto flush, 1\"Flow meter w/ local display",null,"-",1888,0]
[null,"   WHWU-1.5F-V-A-DDS","Ultra. 1.5\" Vortex Filter max 45 gpm, Auto flush, 1.5\" Flow meter w/ local display",null,"-",2341,0]
[null,"   WHWU-2F-V-A-DDS","Ultra. 2\" Vortex Filter max 70gpm, Auto flush,1.5\" Flow meter w/ local display",null,"-",2476,0]
[null," ULTRA Vortex Headworks -PLS","Used with GeoTS controllers where flow rates are logged",null,"-",null,0]
[null,"   WHWU-75F-V-A-PLS","Ultra. 3/4\" Vortex Filter Max 10 gpm, Auto flush, 1\" flow meter for GeoTS",null,"-",2138,0]
[null,"   WHWU-1F-V-A-PLS","Ultra. 1\" Vortex Filter max 20gpm, Auto flush, 1\" flow meter for GeoTS",null,"-",2142,0]
[null,"   WHWU-1.5F-V-A-PLS","Ultra. 1.5\" Vortex Filter max 45 gpm, Auto flush, 1.5\"  flow meter for GeoTS",null,"-",2961,0]
[null,"   WHWU-2F-V-A-PLS","Ultra. 2\" Vortex Filter max 70gpm, Auto flush, 1.5\"  flow meter for GeoTS",null,"-",3095,0]
[null,null,null,null,"-"]
["Headworks","BIODISC Filter Headworks","Select BioDisc Filter Headworks here",null,{"$f":"IF($C$27=B112,C112,E113)","v":"Select BioDisc Filter Headworks here"}]
[null," SPORTY BioDisc Headworks","Select BioDisc Sporty Headworks model from the list left",null,{"$f":"IF($C$27=B113,C113,E114)","v":"-"},null,{"$f":"IF($C$27=B113,F113,G114)","v":0}]
[null,"   WHWS-D-1.5F-M","Sporty Headworks with single 1.5\" BioDisc Filter. Manual flush",null,{"$f":"IF($C$27=B114,C114,E115)","v":"-"},815,{"$f":"IF($C$27=B114,F114,G115)","v":0}]
[null,"   WHWS-D-1.5F-A","Sporty Headworks with single 1.5\" BioDisc Filter. Automatic field flush",null,{"$f":"IF($C$27=B115,C115,E116)","v":"-"},770,0]
[null,"   WHWS-D-2F-M","Sporty Headworks with single 2\" BioDisc Filter. Manual flush",null,"-",945,0]
[null,"   WHWS-D-2F-A","Sporty Headworks box with single 2\" BioDisc Filter. Automaticf ield flush",null,"-",900,0]
[null," ULTRA BioDisc Headworks-PLS","Used with GeoTS controllers where flow rates are logged",null,"-",null,0]
[null,"   WHWU-1.5F-D-A-PLS","Ultra. 1.5\" BioDisc (x2). Max 30 gpm, Auto flush, 1.5\"  flow meter for GeoTS",null,"-",3250,0]
[null,"   WHWU-2F-D-A-PLS","Ultra.  2\" BioDisc Filter (x2). Max 60gpm, Auto flush, 1.5\"  flow meter for GeoTS",null,"-",3395,0]
[null," ULTRA BioDisc Headworks-DDS","Flow meter has digital diplay in headworks, not logged on controller",null,"-",null,0]
[null,"   WHWU-1.5F-D-A-DDS","Ultra. 1.5\" BioDisc (x2). Max 30 gpm, Auto flush, 1.5\" Flow meter w/ local display",null,"-",2600,0]
[null,"   WHWU-2F-D-A-DDS","Ultra.  2\" BioDisc Filter (x2). Max 60gpm, Auto flush, 1.5\"  Flow meter w/ local display",null,"-",2756,0]
[null,null,null,null,"-"]
[null,"GEOVAC filter Headworks"]
[null,{"$f":"Macros!A51","v":"BioDisc Filter-150"},"2\" Filter. Vacuum screen cleaning. Stainless 30-75 gpm. Victaulic connections, 1.5\" flush valve,35psi min",null,{"$f":"IF($C$28=B126,C126,E127)","v":"-"},3160,{"$f":"IF($C$28=B126,F126,G127)","v":0}]
[null,{"$f":"Macros!A52","v":"BioDisc Filter-200"},"3\" filter . Vacuum screen cleaning. Stainless 40-150gpm, victaulic connections,1.5\" flush valve,35psi min",null,{"$f":"IF($C$28=B127,C127,E128)","v":"-"},8400,{"$f":"IF($C$28=B127,F127,G128)","v":0}]
[null,{"$f":"Macros!A53","v":0},"4\" Filter. Vacuum screen cleaning. Stainless 40-250 gpm. Victaulic connections, 1.5\" flush valve,35psi min",null,{"$f":"IF($C$28=B128,C128,E129)","v":"-"},11000,{"$f":"IF($C$28=B128,F128,G129)","v":0}]
[null,{"$f":"Macros!A54","v":0},"6\" Filter. Vacuum screen cleaning. Stainless 40-500 gpm. Victaulic connections, 2\" flush valve,35psi min",null,{"$f":"IF($C$28=B129,C129,E130)","v":"-"},17500,{"$f":"IF($C$28=B129,F129,G130)","v":0}]
[null,{"$f":"Macros!A55","v":0},"8\" Filter. Vacuum screen cleaning. Stainless 50-700 gpm. Victaulic connections, 2\" flush valve,35psi min",null,{"$f":"IF($C$28=B130,C130,E131)","v":"-"},21000,{"$f":"IF($C$28=B130,F130,G131)","v":0}]
[null,null,null,null,"-"]
["Filters"]
[null,"AP4E-.75F","  3/4\" screen filter. Plastic body.  MIPT. Up to 10 gpm",null,null,41.2]
[null,"AP4E-1F","  1\" screen filter. Plastic body.  MIPT. Up to 20 gpm",null,{"$f":"IF($C$32=B134,C134,E135)","v":0},52.97]
[null,"AP4E-1.5F","  1.5\" screen filter. Plastic body.  MIPT. Up to 45 gpm",null,0,270.70999999999998]
[null,"AP4E-2F","  2\" screen filter. Plastic body.  MIPT. Up to 70 gpm",null,0,411.95]
[null,"BioDisc-150","  1.5\" Disc filter with Geoshield protection - Max 30gpm",null,0,140]
[null,"BioDisc-200","  2\" Disc filter with Geoshield protection - Max 60gpm",null,0,270]
[null,"GeoVac75-02","  2\" Filter with vacuum screen cleaning. Stainless 20-75 gpm. Victaulic connections",null,0,{"$f":"IF($C$32=B139,C139,F140)","v":0}]
[null,"GeoVac150-03","  3\" filter with vacuum screen cleaning. Stainless 20-150 gpm. Victaulic connections",null,0,{"$f":"IF($C$32=B140,C140,F141)","v":0}]
[null,"GeoVac250-04","  4\" filter with vacuum screen cleaning. Stainless 20-300 gpm. Victaulic connections",null,0,{"$f":"IF($C$32=B141,C141,F142)","v":0}]
[null,"GeoVac500-06","  6\" filter with vacuum screen cleaning. Stainless 20-600 gpm. Victaulic connections.",null,0,{"$f":"IF($C$32=B142,C142,F143)","v":0}]
[null,"GeoVac700-08","  8\" filter with vacuum screen cleaning. Stainless 20-900 gpm. Victaulic connections",null,0,{"$f":"IF($C$32=B143,C143,F144)","v":0}]
["Air vents"]
[null,"ARV-05","1/2\" air vent",null,7.4]
[null,"APVBK-1","1\" airvent for use on zones less than 50gpm",null,21.19]
[null,"APVBK-2","2\" airvent",{"$f":"IF(C18=B147,C147,\"Select airvent\")","v":"Select airvent"},185.5]
[null,"AV BOX 6 inch","6\" round box",null,10.59]
[null,"AV BOX 10 inch","10\" round box",null,32.979999999999997]
[null,null,null,null,null,null,"List Price"]
["Pressure Regulators","Select","Restricts pressure from exceeding required pressure. Required with Classic dripline.",null,null,null,0]
[null,"PMR20-LF: 1/8-8gpm","  20 psi regulator.  1/8-8 gpm   3/4\" FIPT    ",null,null,{"$f":"IF($C$21=B152,C152,F153)","v":"Select Pressure Regulator"},23.54,{"$f":"IF($C$21=B152,G152,H153)","v":"List Price"}]
[null,"PMR-20MF :  2-20 gpm","  20 psi regulator.  2-20 gpm      1\" FIPT",null,null,"Select Pressure Regulator",23.54,{"$f":"IF($C$21=B153,G153,H154)","v":"List Price"}]
[null,"PMR20-HF :  10-32 gpm","  20 psi regulator.  10-32 gpm    1.25\" FIPT",null,null,"Select Pressure Regulator",43.55,"List Price"]
[null,"PMR20-XF : 20-90 psi","  20 psi regulator.  20-90 gpm    3\" ID Socket",null,null,"Select Pressure Regulator",170,"List Price"]
[null,"PMR30-LF: 1/8-8gpm","  30 psi regulator.  1/8-8 gpm     3/4\" FIPT",null,null,"Select Pressure Regulator",{"$f":"+G152","v":23.54},"List Price"]
[null,"PMR-30MF :  2-20 gpm","  30 psi regulator.  2-20 gpm      1\" FIPT",null,null,"Select Pressure Regulator",{"$f":"+G153","v":23.54},"List Price"]
[null,"PMR30-HF :  10-32 gpm","  30 psi regulator.  10-32 gpm    1.25\" FIPT",null,null,"Select Pressure Regulator",{"$f":"+G154","v":43.55},"List Price"]
[null,"PMR30-XF : 20-90 psi","  30 psi regulator.  20-90 gpm    3\" ID Socket",null,null,"Select Pressure Regulator",{"$f":"+G155","v":170},"List Price"]
[null,"PMR40-LF: 1/8-8gpm","  40 psi regulator.  1/8-8 gpm     3/4\" FIPT",null,null,"Select Pressure Regulator",{"$f":"+G152","v":23.54},"List Price"]
[null,"PMR40-MF :  2-20 gpm","  40 psi regulator.  2-20 gpm      1\" FIPT",null,null,"Select Pressure Regulator",{"$f":"+G153","v":23.54},"List Price"]
[null,"PMR40-HF :  10-32 gpm","  40 psi regulator.  10-32 gpm    1.25\" FIPT",null,null,"Select Pressure Regulator",{"$f":"+G154","v":43.55},"List Price"]
[null,"PMR40-XF : 20-90 psi","  40 psi regulator.  20-90 gpm    3\" ID Socket",null,null,"Select Pressure Regulator",{"$f":"+G155","v":170},"List Price"]
[null,null,null,null,null,"Select Pressure Regulator",{"$f":"+G152","v":23.54},"List Price"]
[null,"PMR50-MF :  2-20 gpm","  50 psi regulator.  2-20 gpm      1\" FIPT",null,null,"Select Pressure Regulator",{"$f":"+G153","v":23.54},"List Price"]
[null,"PMR50-HF :  10-32 gpm","  50 psi regulator.  10-32 gpm    1.25\" FIPT",null,null,"Select Pressure Regulator",{"$f":"+G154","v":43.55},"List Price"]
[null,"PMR50-XF : 20-90 psi","  50 psi regulator.  20-90 gpm    3\" ID Socket",null,null,{"$f":"IF($C$21=B167,C167,\"Select Pressure Regulator\")","v":"Select Pressure Regulator"},{"$f":"+G155","v":170},{"$f":"IF($C$21=B167,G167,E168)","v":"List Price"}]
["Solenoids - Bermad",null,null,null,"List Price"]
[null,"SVLVB-100","  1\" Solenoid valve. 24V,FPT,Normally closed.  ",null,88.2,"Zone valves","Flush valves"]
[null,"SVLVB-150","  1.5\" Solenoid valve. 24V,FPT,Normally closed.  ",{"$f":"IF($C$38=B170,E170,D171)","v":0},151.30000000000001,{"$f":"IF($C$38=B170,C170,F171)","v":0},{"$f":"IF($C$30=B170,C170,G171)","v":"Flush valves"},{"$f":"IF($C$30=B170,E170,H171)","v":0}]
[null,"SVLVB-200","  2\" Solenoid valve. 24V,FPT,Normally closed.  ",{"$f":"IF($C$38=B171,E171,D172)","v":0},309,0,{"$f":"IF($C$30=B171,C171,G172)","v":"Flush valves"},{"$f":"IF($C$30=B171,E171,H172)","v":0}]
[null,"SVLVB-300","  3\" Solenoid valve. 24V,FPT,Normally closed.  ",0,484.5,0,{"$f":"IF($C$30=B172,C172,G173)","v":"Flush valves"},{"$f":"IF($C$30=B172,E172,H173)","v":0}]
["Hydrotek",{"$f":"+Macros!H71","v":"HT-4402"},"Hydraulic valve for 2 zones",0,125,0,"Flush valves"]
[null,{"$f":"+Macros!H72","v":"HT-4403"},"Hydraulic valve for 3 zones",0,{"$f":"+E173","v":125},0]
[null,{"$f":"+Macros!H73","v":"HT-4404"},"Hydraulic valve for 4 zones",0,{"$f":"+E174","v":125},0]
[null,{"$f":"+Macros!H74","v":"HT-4605"},"Hydraulic valve for 5 zones",0,{"$f":"+E175","v":125},0]
[null,{"$f":"+Macros!H75","v":"HT-4606"},"Hydraulic valve for 6 zones",0,{"$f":"+E176","v":125},0]
["Check valve"]
[null,"Ball check with true unions","Select size from drop down menu left"]
[null,"CV-B-05","  1/2\" True Union ball check PVC/Viton",null,{"$f":"IF($C$47=B180,C180,E181)","v":"  1\" True Union ball check PVC/Viton"},42.4,{"$f":"IF($C$47=B180,F180,G181)","v":59.47}]
[null,"CV-B-10","  1\" True Union ball check PVC/Viton",null,{"$f":"IF($C$47=B181,C181,E182)","v":"  1\" True Union ball check PVC/Viton"},59.47,{"$f":"IF($C$47=B181,F181,G182)","v":59.47}]
[null,"CV-B-15","  1.5\" True Union ball check PVC/Viton",null,{"$f":"IF($C$47=B182,C182,E183)","v":"Select size from drop down menu left"},99.3,{"$f":"IF($C$47=B182,F182,G183)","v":0}]
[null,"CV-B-20","  2\" True Union ball check PVC/Viton",null,{"$f":"IF($C$47=B183,C183,E184)","v":"Select size from drop down menu left"},135.84,{"$f":"IF($C$47=B183,F183,G184)","v":0}]
[null,"CV-B-30","  3\" Ball Check SxS PVC/Viton",null,{"$f":"IF($C$47=B184,C184,E185)","v":"Select size from drop down menu left"},347.51,{"$f":"IF($C$47=B184,F184,G185)","v":0}]
[null,"Spring check","Select size from drop down menu left",null,{"$f":"IF($C$48=B185,C185,E186)","v":"Select size from drop down menu left"},0]
[null,"CV-S-05","  1/2\" Spring check valve. Requires 2psi to open",null,{"$f":"IF($C$48=B186,C186,E187)","v":0},7.8869052000000011,{"$f":"IF($C$48=B186,F186,G187)","v":0}]
[null,"CV-S-10","  1\" Spring check valve. Requires 2psi to open",null,{"$f":"IF($C$48=B187,C187,E188)","v":0},12.5262612,{"$f":"IF($C$48=B187,F187,G188)","v":0}]
[null,"CV-S-15","  1.5\" Spring check valve. Requires 2psi to open",null,{"$f":"IF($C$48=B188,C188,E189)","v":0},17.284298400000001,{"$f":"IF($C$48=B188,F188,G189)","v":0}]
[null,"CV-S-20","  2\" Spring check valve. Requires 2psi to open",null,{"$f":"IF($C$48=B189,C189,E190)","v":0},20.823156000000004,{"$f":"IF($C$48=B189,F189,G190)","v":0}]
[]
["Plow"]
[null,"Plow","Plow for 3 point hitch",null,null,3800]
[]
["Pressure gauge"]
[null,"PG-25-LM","Pressure gauge 1/4\" NPT. Lower mount",null,35.299999999999997]
[null,"PG-25-Lead","Presssure gauge with lead",null,54.8]
["Misc Fittings"]
[null,"LTFlexR-18","18\" flex PVC riser with 2 x lockslip adapters"]
[null,"LTFlexL-36","36\" flex PVC  with 1 lockslip adapter.  Used for loops or risers"]
[]
[null,"LTSLIP-600","Lockslip Adapter. 1/2\" socket (3/4\" spigot) x 16mm Wasteflow dripline"]
[null,"LTMPT-600","Lockslip Adapter. 3/4\" MPT x 16mm Wasteflow dripline"]
[null,"LTTEE-600","Lockslip Tee. Fits 16mm Wasteflow dripline"]
[null,"LTELL-600","Lockslip Elbow. Fits 16mm Wasteflow dripline"]
[null,"LTC-600","Lockslip Coupling. Fits 16mm Wasteflow dripline"]
[]
["Flow Meter - Digital Display ","Flow Meter - Digital Display "]
[null,"FM-DDS-075 (2-20gpm)","3/4\" FPT Digital Flow Meter with Local Display - 2-20gpm",{"$f":"IF($C$36=B208,C208,D209)","v":0},356.89,{"$f":"IF($C$36=B208,E208,F209)","v":0}]
[null,"FM-DDS-100 (5-50gpm)","1\" FPT Digital Flow Meter with Local Display - 5-50gpm",0,403.33,{"$f":"IF($C$36=B209,E209,F210)","v":0}]
[null,"FM-DDS-150 (10-100gpm)","1.5\" FPT Digital Flow Meter with Local Display - 10-100gpm",0,449.17,0]
[null,"FM-DDS-200 (20-200gpm)","2\" FPT  Digital Flow Meter with Local Display - 20-200gpm",0,492.56,0]
["Flow Meter - Pulse for GeoTS controller","Flow Meter - Pulse for GeoTS controller","Use Pulse flow meters to input flow data to GEOTS Controller",0,null,0]
[null,"FM-PLS-100 (5-50gpm)","1\" FPT PVC turbine with pulse output 5-50 gpm",0,652.66999999999996,0]
[null,"FM-PLS-150 (10-100gpm)","1.5\" FPT stainless turbine with pulse output 10-100 gpm",0,1058.44,0]
[null,"FM-PLS-200 (20-200 gpm)","2\" FPT stainless turbine with pulse output 20-200gpm",0,1394.56,0]
[null,"Flow Meter -4-20 ma"]
[null,"FM-420ma-100"]
[null,"FM-420ma-150"]
[null,"FM-4-20ma-200"]
[]
["Unions","Unions",null,{"$f":"IF($C$50=B221,C221,D222)","v":0},null,{"$f":"IF($C$50=B221,E221,F222)","v":0}]
[null,"Union-100-S","1\" Union Slip",{"$f":"IF($C$50=B222,C222,D223)","v":0},12,{"$f":"IF($C$50=B222,E222,F223)","v":0}]
[null,"Union-100-ST","1\" Union - FPT x slip",0,18,0]
[null,"Union-150-S","1.5\" Union Slip",0,27,0]
[null,"Union 150-ST","1.5\" Union - FPT x slip",0,44,0]
[null,"Union-200-S","2\" Union Slip",0,37,0]
[null,"Union-200-ST","2\" Union - FPT x slip",0,65,0]
[null,"Union-300-ST","3\" Union - FPT x slip",0,180,0]

{"sheet":"T1-Dripline","index":5,"n_rows":176,"n_cols":15,"rows_kept":176,"cut":false,"hidden":false,"merged":[[103,2,103,6],[104,2,104,6],[45,2,45,6],[46,2,46,6],[18,2,18,5],[19,2,19,5],[74,2,74,6],[75,2,75,6]]}
[null,"Dripline Tables"]
[null,"Refer to Geoflow's Flow and flushing worksheet for further hydraulic details"]
[]
[null,"Wasteflow Classic"]
[]
[null,null,"Flow Rate vs. Pressure"]
[]
[null,null,"                 Pressure",null,"                  Dripline"]
[null,null,"psi","ft.","WF16-4-24","WF16-4-12"]
[null,null,"10 psi","23.10 ft","0.90 gph","0.90 gph"]
[null,null,"15 psi","34.65 ft.","1.13 gph","1.13 gph"]
[null,null,"20 psi","46.20 ft.","1.30gph","1.30gph"]
[null,null,"25 psi","57.75 ft.","1.47 gph","1.47 gph"]
[null,null,"30 psi","69.30 ft.","1.62 gph","1.62 gph"]
[null,null,"35 psi","80.85 ft.","1.76 gph","1.76 gph"]
[null,null,"40 psi","92.40 ft"]
[null,null,"45 psi","103.95 ft","1.89 gph","1.89 gph"]
[]
[null,null,"Maximum Length of Run vs. Pressure"]
[null,null,"Flow variation +/- 5%.  "]
[null,null,"                 Pressure",null,"                        Emitter Spacing"]
[null,null,"psi","ft.","24\"","18\"","12\""]
[null,null,"10 psi","23.10 ft",170,165,100]
[null,null,"15 psi","34.65 ft.",170,165,100]
[null,null,"20 psi","46.20 ft.",170,165,100]
[null,null,"25 psi","57.75 ft.",170,165,100]
[null,null,"30 psi","69.30 ft.",170,165,100]
[null,null,"35 psi","80.85 ft.",170,165,100]
[null,null,"40 psi","92.40 ft",170,165,100]
[null,null,"45 psi","103.95 ft",170,165,100]
[null,null,"kd = .9,  cv = <.05",null,null,null,null,null,null,"Note, when using this length to look up pressure lossses in the  dripline,"]
[null,null,null,null,null,null,null,null,null,"only the flow going out of the emitters is used, and does not reflect true "]
[null,null,null,null,null,null,null,null,null,"pressure loss during flushing.  Pressure loss during flushing is self calculated "]
[null,null,null,null,null,null,null,null,null,"in the cell below, or can be obtained from Geoflows Flushing spreadsheet."]
[]
[]
[null,"Wasteflow PC 1/2 gph"]
[]
[null,null,"Flow Rate vs. Pressure"]
[]
[null,null,null,null,"                  Dripline"]
[null,null,"Pressure","Head","WFPC16-2-24","WFPC16-2-12"]
[null,null,"7–60 psi","16 –139 ft.","0.53 gph","0.53 gph"]
[]
[]
[null,null,"Maximum Length of Run vs. Pressure"]
[null,null,"Allows a minimum of 10 psi"]
[null,null,"                 Pressure",null,"                                      Emitter Spacing"]
[null,null,"psi","ft.","6\"","12\"","18\"","24\""]
[null,null,"10 psi","23.10 ft"]
[null,null,"15 psi","34.65 ft.",null,174,260,321]
[null,null,"20 psi","46.20 ft.",120,229,330,424]
[null,null,"25 psi","57.75 ft.",null,260,377,478]
[null,null,"30 psi","69.30 ft.",150,288,415,535,null,null,null,null,null,null,{"$f":"0.2642*60","v":15.852}]
[null,null,"35 psi","80.85 ft.",null,313,448,576,null,null,null,null,null,null,{"$f":"+O54/3.2808","v":4.831748354059985}]
[null,null,"40 psi","92.40 ft",172,330,475,612,null,null,null,null,null,null,{"$f":"+O55*1000","v":4831.7483540599851}]
[null,null,"45 psi","103.95 ft",null,354,501,651,null,null,null,null,null,null,{"$f":"10000/4.8","v":2083.3333333333335}]
[null,null,"50 psi","115.5 ft.",null,363,523,675]
[null,null,"55 psi","127.05 ft.",null,377,544,700]
[null,null,"60 psi","138.6 ft.",null,403,563,727]
[null,null,"kd = 2.070",null,null,null,null,null,null,"Note, when using this length to look up pressure lossses in the  dripline,"]
[null,null,"Not recommended",null,null,null,null,null,null,"only the flow going out of the emitters is used, and does not reflect true "]
[null,null,"with pressures",null,null,null,null,null,null,"pressure loss during flushing.  Pressure loss during flushing is self calculated "]
[null,null,"greater than 45 psi",null,null,null,null,null,null,"in the cell below, or can be obtained from Geoflows Flushing spreadsheet."]
[]
[]
[null,"Wasteflow PC 1 gph"]
[]
[null,null,"Flow Rate vs. Pressure"]
[]
[null,null,null,null,"                  Dripline"]
[null,null,"Pressure","Head","WFPC16-4-24","WFPC16-4-12"]
[null,null,"7–60 psi","16 –139 ft.","1.02 gph","1.02 gph"]
[]
[null,null,"Maximum Length of Run vs. Pressure"]
[null,null,"Allows a minimum of 10 psi"]
[null,null,"                 Pressure",null,"                                      Emitter Spacing"]
[null,null,"psi","ft.","6\"","12\"","18\"","24\""]
[null,null,"10 psi","23.10 ft",50,95,140,175]
[null,null,"15 psi","34.65 ft.",63,115,172,211]
[null,null,"20 psi","46.20 ft.",74,146,210,265]
[null,null,"25 psi","57.75 ft.",88,171,242,315]
[null,null,"30 psi","69.30 ft.",94,180,266,335]
[null,null,"35 psi","80.85 ft.",103,199,287,379]
[null,null,"40 psi","92.40 ft",110,211,305,385]
[null,null,"45 psi","103.95 ft",116,222,321,429]
[null,null,"50 psi","115.5 ft.",null,232,334,431]
[null,null,"55 psi","127.05 ft.",null,240,347,449]
[null,null,"60 psi","138.6 ft.",null,249,360,465]
[null,null,"kd = 2.070",null,null,null,null,null,null,"Note, when using this length to look up pressure lossses in the  dripline,"]
[null,null,"Not recommended",null,null,null,null,null,null,"only the flow going out of the emitters is used, and does not reflect true "]
[null,null,"with pressures",null,null,null,null,null,null,"pressure loss during flushing.  Pressure loss during flushing is self calculated "]
[null,null,"greater than 45 psi",null,null,null,null,null,null,"in the cell below, or can be obtained from Geoflows Flushing spreadsheet."]
[]
[]
[null,"Wasteflow PC 0.75 gph"]
[]
[null,null,"Flow Rate vs. Pressure"]
[]
[null,null,null,null,"                  Dripline"]
[null,null,"Pressure","Head","WFPC16-4-24","WFPC16-4-12"]
[null,null,"7–60 psi","16 –139 ft.","0.75 gph","0.75 gph"]
[]
[null,null,"Maximum Length of Run vs. Pressure"]
[null,null,"Allows a minimum of 10 psi"]
[null,null,"                 Pressure",null,"                                      Emitter Spacing"]
[null,null,"psi","ft.",null,"12\"","18\"","24\""]
[null,null,"10 psi","23.10 ft"]
[null,null,"15 psi","34.65 ft.",null,140,200,257]
[null,null,"20 psi","46.20 ft."]
[null,null,"25 psi","57.75 ft.",null,208,299,383]
[null,null,"30 psi","69.30 ft."]
[null,null,"35 psi","80.85 ft.",null,251,350,462]
[null,null,"40 psi","92.40 ft"]
[null,null,"45 psi","103.95 ft",null,284,407,522]
[null,null,"50 psi","115.5 ft."]
[null,null,"55 psi","127.05 ft."]
[null,null,"60 psi","138.6 ft."]
[null,null,"kd = 2.070",null,null,null,null,null,null,"Note, when using this length to look up pressure lossses in the  dripline,"]
[null,null,"Not recommended",null,null,null,null,null,null,"only the flow going out of the emitters is used, and does not reflect true "]
[null,null,"with pressures",null,null,null,null,null,null,"pressure loss during flushing.  Pressure loss during flushing is self calculated "]
[null,null,"greater than 45 psi",null,null,null,null,null,null,"in the cell below, or can be obtained from Geoflows Flushing spreadsheet."]
[]
[]
[]
[]
[]
[]
[]
[]
[]
["F29 Pump Sizing - Pressure loss through dripline"]
[{"$f":"+'Worksht1 - Field Flow'!E25","v":"Wasteflow PC - 1/2gph"},"Dripline chosen on Worksheet 1",null,null,null,"Wasteflow Classic"]
[{"$f":"+'Worksht1 - Field Flow'!E22","v":2},"Spacing between drippers from worksheet 1",null,null,null,"Wasteflow PC - 1/2gph"]
[{"$f":"+'Worksht1 - Field Flow'!E39","v":318},"Longest length of run from worksheet 1",null,null,null,"Wasteflow PC - 1 gph"]
[{"$f":"IF($G$204=F133,C136,A145)","v":5.74},null,{"$f":"IF($A$134=1,C139,E136)","v":"Dripline too long"},null,{"$f":"IF($A$134=2,E139,G136)","v":"Dripline too long"}]
["CLASSIC","12\"/1.02gph",null,"24\"/1.02gph"]
[0,0,null,0]
[50,0.21790000000000001,{"$f":"IF($A$135<=A139,B139,C140)","v":"Dripline too long"},6.5000000000000002E-2,{"$f":"IF($A$135<=A139,D139,E140)","v":"Dripline too long"}]
[100,1.62236,{"$f":"IF($A$135<=A140,B140,C141)","v":"Dripline too long"},0.31994,{"$f":"IF($A$135<=A140,D140,E141)","v":"Dripline too long"}]
[150,5.4982600000000001,"Dripline too long",1.0197000000000001,"Dripline too long"]
[200,13.773999999999999,"Dripline too long",2.5390000000000001,"Dripline too long"]
[250,null,"Dripline too long",4.5936000000000003,"Dripline too long"]
[300,null,null,8.0532900000000005,"Dripline too long"]
[{"$f":"IF(A133=F134,C146,A164)","v":5.74}]
["PC 0.53",null,{"$f":"IF($A$134=1,C148,E146)","v":5.74},null,{"$f":"IF($A$134=1.5,E148,G146)","v":5.74},null,{"$f":"IF($A$134=2,G148,I146)","v":5.74}]
[null,{"$f":"+[2]Macros!L148","v":{"$error":"#REF!"}},null,{"$f":"+[2]Macros!M148","v":{"$error":"#REF!"}},null,{"$f":"+[2]Macros!N148","v":{"$error":"#REF!"}}]
[50,0.14000000000000001,{"$f":"IF($A$135<=A148,B148,C149)","v":36},0.1,{"$f":"IF($A$135<=A148,D148,E149)","v":12},0.05,{"$f":"IF($A$135<=A148,F148,G149)","v":5.74}]
[100,0.9,36,0.3,12,0.153,5.74]
[150,2.9,36,1,12,0.49,5.74]
[200,6.77,36,2.2999999999999998,12,1.1200000000000001,5.74]
[250,13,36,4.49,12,2.15,5.74]
[300,22.66,36,7.64,12,3.66,5.74]
[350,36,36,12,12,5.74,5.74]
[400,53.96,53.96,17.899999999999999,17.899999999999999,8.5,8.5]
[450,70,70,25.44,25.44,12.03,12.03]
[500,null,"Dripline too long",35,35,16.420000000000002,16.420000000000002]
[550,null,null,46.6,46.6,21.79,21.79]
[600,null,null,60,60,28.24,28.24]
[650,null,null,null,{"$f":"+C157","v":"Dripline too long"},35.869999999999997,35.869999999999997]
[700,null,null,null,null,44.79,44.79]
[750,null,null,null,null,55.12,55.12]
[800,null,null,null,null,null,{"$f":"+C157","v":"Dripline too long"}]
[{"$f":"IF($A$133=F135,C164,A176)","v":"Oops"},null,{"$f":"IF($A$134=1,C166,E164)","v":21},null,{"$f":"IF($A$134=1.5,E166,G164)","v":21},null,{"$f":"IF($A$134=2,G166,I164)","v":21}]
["PC 1.0 gph"]
[{"$f":"+A148","v":50},0.49,{"$f":"IF($A$135<=A166,B166,C167)","v":"Dripline too long"},0.65,{"$f":"IF($A$135<=A166,D166,E167)","v":44.34},0.1,{"$f":"IF($A$135<=A166,F166,G167)","v":21}]
[{"$f":"+A149","v":100},3.3,{"$f":"IF($A$135<=A167,B167,C168)","v":"Dripline too long"},1.1499999999999999,{"$f":"IF($A$135<=A167,D167,E168)","v":44.34},0.55900000000000005,{"$f":"IF($A$135<=A167,F167,G168)","v":21}]
[150,10.79,"Dripline too long",3.69,44.34,1.79,21]
[200,25,"Dripline too long",8.6,44.34,4.1100000000000003,21]
[250,49.5,"Dripline too long",16.579999999999998,44.34,7.87,21]
[300,75,"Dripline too long",28.22,44.34,13.41,21]
[350,null,{"$f":"+C157","v":"Dripline too long"},44.34,44.34,21,21]
[400,null,null,65,65,31.2,31.2]
[450,null,null,null,{"$f":"+C157","v":"Dripline too long"},44.16,44.16]
[500,null,null,null,null,60,60]
["Oops",null,null,null,null,null,{"$f":"+C157","v":"Dripline too long"}]

{"sheet":"T2-Filter & Headworks","index":6,"n_rows":135,"n_cols":8,"rows_kept":135,"cut":false,"hidden":false,"merged":[]}
[]
[null,"Vortex Filters and Headworks",null,null,null,null,null,"BioDisc Filters and Headworks"]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[null,"Points on filter curve"]
[]
[null,0]
[null,1,{"$f":"0.6/2","v":0.3}]
[null,2,0.6]
[null,3,1.1000000000000001]
[null,4,1.5]
[null,5,2.5]
[null,6,4]
[null,7,5.75]
[null,8,7.5]
[null,9,9.5]
[null,10,11.5]
[null,11,14.1]
[]
[null,null,"AP4E-100"]
[null,0,0]
[null,5,0.8]
[null,10,2.2000000000000002]
[null,15,5.5]
[null,20,10.5]
[null,25,16.667000000000002]
[null,30,24]
[]
[null,null,"AP4E150-3",null,"AP4E150-4"]
[null,0,0,null,0]
[null,10,0.7,null,0.2]
[null,20,2,null,0.75]
[null,30,4,null,2]
[null,40,6.5,null,4]
[null,50,9,null,6.1]
[null,60,null,null,8.4]
[]
[]
[null,null,"AP4E200-3",null,"AP4E200-4"]
[null,0,0,null,0]
[null,null,0.5,null,0.25]
[null,20,1,null,0.5]
[null,null,1.5,null,0.75]
[null,40,2,null,1]
[null,null,3.5,null,2]
[null,60,5,null,3]
[null,null,7,null,4]
[null,80,9,null,5]
[null,null,12,null,7]
[null,100,15,null,9]
[null,120,null,null,12]

{"sheet":"T3-Valves","index":7,"n_rows":52,"n_cols":12,"rows_kept":52,"cut":false,"hidden":false,"merged":[[44,4,44,11],[45,4,45,5],[45,6,45,7],[45,8,45,9],[45,10,45,11]]}
[]
[null,"Solenoid valves"]
[null,"Part Numbers","Size"]
[null,"SVLVB-100","1\""]
[null,"SVLVB-150","1.5\""]
[null,"SVLVB-200","2\""]
[null,"SVLVB-300","3\""]
[]
[null,"Flow vs Pressure"]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[null,"Hydraulic Valves"]
[]
[null,"    Flow vs. Pressure"]
[null,null,null,null,"Flow"]
[null,null,"Part No.","No. of Zones","10 gpm",null,"20 gpm",null,"30 gpm",null,"40 gpm"]
[null,null,null,null,"psi","ft","psi","ft","psi","ft","psi","ft"]
[null,null,4402,"2 zone",2,4.62,3,6.93,4.5,10.4,6.4,14.8]
[null,null,4403,"3 zone",2,4.62,3,6.93,4.5,10.4,6.4,14.8]
[null,null,4404,"4 zone",2,4.62,3,6.93,4.5,10.4,6.4,14.8]
[null,null,4405,"5 zone ",2.5,5.8,4.5,10.4,7.5,17.3,"na","na"]
[null,null,4406,"6 zone",2.5,5.8,4.5,10.4,7.5,17.3,"na","na"]

{"sheet":"T4-PVC PLUS","index":8,"n_rows":156,"n_cols":23,"rows_kept":156,"cut":false,"hidden":false,"merged":[[116,2,116,5],[118,2,118,5],[111,2,111,5],[112,2,112,5],[113,2,113,5],[114,2,114,5],[115,2,115,5],[104,2,104,5],[107,2,107,5],[108,2,108,5],[109,2,109,5],[110,2,110,5],[98,2,98,5],[99,2,99,5],[100,2,100,5],[101,2,101,5],[102,2,102,5],[93,2,93,5],[94,2,94,5],[95,2,95,5],[96,2,96,5],[97,2,97,5],[79,3,79,16],[45,2,45,15],[46,2,47,2],[46,3,46,15],[76,2,76,16],[77,2,77,16],[78,2,78,16],[4,21,4,22],[4,11,4,12],[4,13,4,14],[4,15,4,16],[4,17,4,18],[4,3,4,4],[4,5,4,6],[4,7,4,8],[4,9,4,10],[4,19,4,20]]}
[]
[null,null,"Schedule 40 PVC Plastic Pipe"]
[null,null,"(Pounds per square inch (PSI) per 100 ft. of pipe"]
[null,null,"The pipe is Schedule 40 ASTM D1785, D2672, D1784"]
[null,null,null,"         ½”",null,"¾”",null,"1”",null,"1 ¼”",null,"1 ½”",null,"2”",null,"2 ½”",null,"3”",null,"4”",null,"6”"]
[null,null,null,"Velocity","Pressure ","Velocity","Pressure ","Velocity","Pressure ","Velocity","Pressure ","Velocity","Pressure ","Velocity","Pressure ","Velocity","Pressure ","Velocity","Pressure ","Velocity","Pressure ","Velocity","Pressure "]
[null,null,null,"FPS","Drop PSI","FPS","Drop PSI","FPS","Drop PSI","FPS","Drop PSI","FPS","Drop PSI","FPS","Drop PSI","FPS","Drop PSI","FPS","Drop PSI","FPS","Drop PSI","FPS","Drop PSI"]
[null,null,"Flow"]
[null,null,"GPM"]
[null,null,1,1.05,0.43,0.6,0.11,0.37,0.03]
[null,null,2,2.11,1.55,1.2,0.39,0.74,0.12,0.43,0.03]
[null,null,3,3.17,3.27,1.8,0.83,1.1100000000000001,0.26,0.64,7.0000000000000007E-2,0.47,0.03]
[null,null,4,4.22,5.57,2.41,1.42,1.48,0.44,0.86,0.11,0.63,0.05]
[null,null,5,5.28,8.42,3.01,2.15,1.86,0.66,1.07,0.17,0.79,0.08]
[null,null,6,6.33,11.81,3.61,3.01,2.23,0.93,1.29,0.24,0.95,0.11,0.56999999999999995,0.03]
[null,null,8,8.44,20.100000000000001,4.8099999999999996,5.12,2.97,1.58,1.72,0.42,1.26,0.2,0.76,0.06,0.54,0.02]
[null,null,10,10.55,30.37,6.02,7.73,3.71,2.39,2.15,0.63,1.58,0.3,0.96,0.09,0.67,0.04]
[null,null,15,null,null,9.02,16.37,5.57,5.0599999999999996,3.22,1.33,2.36,0.63,1.43,0.19,1.01,0.08,0.65,0.03]
[null,null,20,null,null,null,null,7.42,8.61,4.29,2.27,3.15,1.07,1.91,0.32,1.34,0.13,0.87,0.05]
[null,null,25,null,null,null,null,9.2799999999999994,13.01,5.36,3.42,3.94,1.63,2.39,0.48,1.67,0.2,1.08,7.0000000000000007E-2]
[null,null,30,null,null,null,null,11.14,18.22,6.43,4.8,4.7300000000000004,2.27,2.87,0.67,2.0099999999999998,0.28000000000000003,1.3,0.1]
[null,null,35,null,null,null,null,null,null,7.51,6.38,5.52,3.01,3.35,0.89,2.35,0.38,1.52,0.13,0.88,0.03]
[null,null,40,null,null,null,null,null,null,8.58,8.17,6.3,3.88,3.82,1.1399999999999999,2.64,0.48,1.73,0.17,1.01,0.04]
[null,null,45,null,null,null,null,null,null,9.65,10.16,7.09,4.8,4.3,1.42,3.01,0.6,1.95,0.21,1.1299999999999999,0.05]
[null,null,50,null,null,null,null,null,null,10.72,12.35,7.88,5.83,4.78,1.73,3.35,0.73,2.17,0.25,1.26,7.0000000000000007E-2]
[null,null,60,null,null,null,null,null,null,null,null,9.4600000000000009,8.17,5.74,2.42,4.0199999999999996,1.02,2.6,0.35,1.51,0.09]
[null,null,70,null,null,null,null,null,null,null,null,11.03,10.87,6.69,3.22,4.6900000000000004,1.36,3.04,0.47,1.76,0.12]
[null,null,80,null,null,null,null,null,null,null,null,null,null,7.65,4.13,5.36,1.74,3.47,0.6,2.02,0.16]
[null,null,90,null,null,null,null,null,null,null,null,null,null,8.6,5.13,6.03,2.16,3.91,0.75,2.27,0.2]
[null,null,100,null,null,null,null,null,null,null,null,null,null,9.56,6.23,6.7,2.63,4.34,0.91,2.52,0.24,1.1100000000000001,0.03]
[null,null,125,null,null,null,null,null,null,null,null,null,null,11.95,9.42,8.3800000000000008,3.97,5.42,1.38,3.15,0.37,1.39,0.05]
[null,null,150,null,null,null,null,null,null,null,null,null,null,null,null,10.050000000000001,5.56,6.51,1.93,3.78,0.51,1.67,7.0000000000000007E-2]
[null,null,175,null,null,null,null,null,null,null,null,null,null,null,null,null,null,7.59,2.57,4.41,0.68,1.94,0.09]
[null,null,200,null,null,null,null,null,null,null,null,null,null,null,null,null,null,8.68,3.4,5.04,0.9,2.2200000000000002,0.12]
[]
[null,null,"Note:  Values in shaded areas are at velocities over 5 feet per second and should be selected with caution.",null,null,null,null,null,null,null,null,null,"Note:  Values in shaded areas are at velocities over 5 feet per second and should be selected with caution."]
[null,null,"PVC Schedule 40",null,0.5]
[]
[]
[]
[null,null,"Equivalent Lengths - fittings"]
[]
[]
[null,null,"Approximate friction loss for PVC and CPVC fittings in Equivalent Length in feet of Straight Pipe for water can be found in the table below:"]
[]
[null,null,"Friction Loss Equivalent Length - feet of Straight Pipe (ft)"]
[null,null,"Fitting","Nominal Pipe Size (inches)"]
[null,null,null,0.5,0.75,1,1.25,1.5,2,2.5,3,4,6,8,10,12]
[null,null,"90o Elbow, long sweep radius",1.5,2,2.5,3.8,4,5.7,6.9,7.9,12,18,22,26,32]
[null,null,"90o Elbow, standard sharp inside radius",3.6,4.5,5.3,6.7,7.5,8.6,null,11.1,13.1]
[null,null,"45o Elbow",0.8,1.1000000000000001,1.4,1.8,2.1,2.6,3.1,4,5.0999999999999996,8,10.6,13.5,15.5]
[null,null,"Gatevalve",0.3,0.4,0.6,0.8,1,1.5,2,3]
[null,null,"Tee Flow - Run",1,1.4,1.7,2.2999999999999998,2.7,4.3,5.0999999999999996,6.2,8.3000000000000007,12.5,16.5,17.5,20]
[null,null,"Tee Flow - Branch",4,5,6,7,8,12,15,16,22,32.700000000000003,49,57,67]
[null,null,"Male/Female Adapter",1,1.5,2,2.8,3.5,4.5,5.5,6.5,9,14]
[null,null,"The table can also used for other thermoplastic pipes materials with similar design."]
[null,null,"The values can be used to calculate pressure loss with the Equivalent Pipe Length Method."]
[]
[null,null,"Screwed Fittings - equivalent length in feet"]
[null,null,"Equivalent length (in feet) of straight pipe for fittings like bends, returns, tees and valves. (Pipe size in inches)"]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[null,null,"Equivalent Length of PVC Straight Pipe for Various Fittings"]
[null,null,"in feet, turbulent flow only"]
[]
[null,null,null,"Pipe Size, Inches"]
[null,null,"FITTINGS",1,2,3,4,5,6,8,10,12,14,16,18,20,24]
[null,null,"90° Elbow",2.62,5.17,7.67,10.1,12.6,15.2,20,25.1,29.8,32.799999999999997,37.5,42.2,47,56.6]
[null,null,"45° Elbow",1.4,2.76,4.09,5.37,6.73,8.09,10.6,13.4,15.9,17.5,20,22.5,25.1,30.2]
[null,null,"Tee-branch flow",5.25,10.3,15.3,20.100000000000001,25.2,30.3,39.9,50.1,59.7,65.599999999999994,75,84.4,94.1,113]
[null,null,"Tee-through flow",1.75,3.45,5.1100000000000003,6.71,8.41,10.1,13.3,16.7,19.899999999999999,21.8,25,28.1,31.4,37.700000000000003]
[null,null,"Globe Valve, full open",29.7,58.6,86.9,114,143,172,226,284,338,372,425,478,533,641]
[null,null,"Swing Check Valve, full open",8.74,17.2,25.5,33.6,42.1,50.5,33.299999999999997,41.8,49.7,54.7,62.5,70.3,78.400000000000006,94.3]
[null,null,"Gate Valve, full open",0.7,1.38,2.04,2.68,3.36,4.04,5.32,6.68,7.96,8.75,10,16.899999999999999,12.5,15.1]
[]
[null,null,"Handbook of PVC Pipe, 4th Edition, 2001"]
[null,null,"Table 9.1"]
[]
[null,null,"Supply Line:",null,null,null,null,null,null,null,"Fittings"," Length"]
[null,null,"90o Elbow, long sweep radius",null,null,null,null,null,null,null,1]
[null,null,"90o Elbow, standard sharp inside radius",null,null,null,null,null,null,null,6,60.599999999999994]
[null,null,"45o Elbow",null,null,null,null,null,null,null,4,21.48]
[null,null,"Gatevalve"]
[null,null,"Tee Flow - Run",null,null,null,null,null,null,null,0,0]
[null,null,"Tee Flow - Branch",null,null,null,null,null,null,null,0,0]
[null,null,"Male/Female Adapter",null,null,null,null,null,null,null,0,0]
[null,null,"Globe Valve, full open",null,null,null,null,null,null,null,1,114]
[null,null,"Swing Check Valve, full open",null,null,null,null,null,null,null,1,33.6]
[null,null,"Gate Valve, full open",null,null,null,null,null,null,null,1,2.68]
[]
[null,null,"Total Equivalent Length of Pipe",null,null,null,null,null,null,null,null,232.35999999999999]
[]
[null,null,"Return Line:",null,null,null,null,null,null,null,"Fittings"," Length"]
[null,null,"90o Elbow, long sweep radius"]
[null,null,"90o Elbow, standard sharp inside radius",null,null,null,null,null,null,null,6,60.599999999999994]
[null,null,"45o Elbow",null,null,null,null,null,null,null,4,21.48]
[null,null,"Gatevalve"]
[null,null,"Tee Flow - Run",null,null,null,null,null,null,null,0,0]
[null,null,"Tee Flow - Branch",null,null,null,null,null,null,null,0,0]
[null,null,"Male/Female Adapter",null,null,null,null,null,null,null,0,0]
[null,null,"Globe Valve, full open",null,null,null,null,null,null,null,1,114]
[null,null,"Swing Check Valve, full open",null,null,null,null,null,null,null,1,33.6]
[null,null,"Gate Valve, full open",null,null,null,null,null,null,null,1,2.68]
[]
[null,null,"Total Equivalent Length of Pipe",null,null,null,null,null,null,null,null,232.35999999999999]
[]
[]
[]
[null,null,"Tank Volume"]
[null,null,null,"The formula below determines total volume in a tank and ot actual useable volume  Remember the top of the tank is not"]
[null,null,null,"is reserved for overflow, and the bottom of the tank is below the pump uptake."]
[null,null,null,"Rectangular Tank"]
[null,null,null,1,"length in ft x width in ft = ",null,null,"area of tank"]
[null,null,null,2,"area of tank x 7.48 (number of gallons in a cubic ft.) =",null,null,null,null,"Number of gallons per ft."]
[null,null,null,3,"Number of gallons per ft / 12 = ",null,null,"number of gallons per inch"]
[]
[null,null,null,null,"Example:","7ft long x 4 ft wide"]
[null,null,null,null,null,"7 x 4 =",28,"sqiuare ft. or 28 cubic ft at one ft of depth"]
[null,null,null,null,null,"28 x 7.5 =","210 gallons per ft"]
[null,null,null,null,null,"210 / 12 = ","17.5 gallons per inch"]
[]
[null,null,null,"Circular Tank"]
[null,null,null,1,"Volume in gallons for cylindar in a tank = (diameter x diameter x .785) x (height - freeboard area) x 7.48",null,null,null,null,null,null,null,null,null,"Note:  The 7.48 converts it from area to gallons"]
[null,null,null,null,"Alternatively one can use ",null,"Pi(radius)",null,"(3.14 x (radius) ) x (height - freeboard area) x 7.48"]
[null,null,null,2,"If there is a cone in the tank then add to the volume above:"]
[null,null,null,null,"((diameter x diameter x .785) x (height of cone) x 7.48) / 3"]
[null,null,null,null,"Alternatively one can use ",null,"Pi(radius)",null,"(3.14(r)  ) x (height of cone) x 7.48) / 3"]
[]
[]
[]
[null,null,"Dripline Length of run vs. Pump run time"]
[]
[null,null,null,"Wasteflow PC 1/2 gph 24in spacing (WFPC16-2-24)"]
[null,null,null,"Later length  (ft.)",null,null,651,300,200,"ft"]
[null,null,null,"Fill rate/pump dependent (ft/sec.)",null,null,1,1,1,"ft./sec"]
[null,null,null,"Time to fill (mins)",null,null,{"$f":"+G148/G149/60","v":10.85},{"$f":"+H148/H149/60","v":5},{"$f":"+I148/I149/60","v":3.3333333333333335},"mins."]
[]
[null,null,null,"Pump run time (mins)",null,null,15,15,15,"mins."]
[null,null,null,"Fill time as a percent of run time",null,null,{"$f":"+G150/G152","v":0.72333333333333327},{"$f":"+H150/H152","v":0.33333333333333331},{"$f":"+I150/I152","v":0.22222222222222224}]
[]
[null,null,null,"Pump run time (mins)",null,null,40,40,40,"mins."]
[null,null,null,"Fill time as a percent of run time",null,null,{"$f":"+G150/G155","v":0.27124999999999999},{"$f":"+H150/H155","v":0.125},{"$f":"+I150/I155","v":8.3333333333333343E-2}]

{"sheet":"T5-Flow meter","index":9,"n_rows":2,"n_cols":3,"rows_kept":2,"cut":false,"hidden":false,"merged":[]}
[]
[null,null,"FLOW METER"]