{"text_format":"3","workbook":"xls","n_sheets":1,"sheets":["Meter Calculation"],"not_rendered":{"images":1,"external_links":1},"read":"whole","date_system":"1900","formulas":"cached_only"}

{"sheet":"Meter Calculation","index":0,"n_rows":99,"n_cols":45,"rows_kept":99,"merged":[[1,1,1,9],[2,17,2,32],[4,6,4,8],[4,17,4,32],[8,6,8,8],[10,6,10,8],[11,6,11,8],[12,6,12,8],[15,20,15,21],[15,22,15,24],[15,25,15,27],[15,28,15,30],[32,29,32,33],[32,34,32,38],[32,39,32,43]],"flags":["formulas_cached_only"]}
[]
[null,"City Water Meter Calculations"]
[{"$nulls":14},"Lists:",null,null,"size"]
[null,"Pressure Losses",{"$nulls":14},"Select Mainline Size","0.5\"","0.75\"","1\"","1.25\"","1.5\"","2\"","2.5\"","3\"","4\"","5\"","6\"","8\"","10\"","12\"","14\"","16\""]
[null,"- 8.3","5/8\"",null,"Water Meter Size",null,"",{"$nulls":7},"Select Type of Pipe","C value",null,"ID"]
[null,null,85,null,"Static Water Pressure",{"$nulls":9},"Class 160",150,0,"","","","","","","","","","","","","","","",""]
[null,"- 2.16",5,null,"Elevation, ft (from site of pressure reading to highest, farthest sprinkler)",{"$nulls":9},"Class 200",150,1.189,"","",1.189,"","","","","","","","","","","","",""]
[null,null,"1\"",null,"Main Line Size, in",{"$nulls":4},"Velocity in Pipe",{"$nulls":4},"Sch 40",150,1.049,"","",1.049,"","","","","","","","","","","","",""]
[null,"- 6.91","Class 200",null,"Type of Pipe Used",null,"",null,null,"4.329 ft/sec",{"$nulls":4},"Sch 80 ",150,0.957,"","",0.957,"","","","","","","","","","","","",""]
[null,null,250,null,"Main Line Length, ft",{"$nulls":4},"PSI Loss in Run of Pipe",{"$nulls":4},"Type K Copper",140,0.995,"","",0.995,"","","","","","","","","","","","",""]
[null,"- 3.8","1\" Rainbird DV",null,"Type of Valve",null,"",null,null,"6.907 psi"]
[null,null,15,null,"Desired Flow, GPM",null,"",null,null,"PSI Loss in Backflow",{"$nulls":6},"ID of selection",null,"psi loss in run of pipe",null,"velocity in pipe"]
[null,null,"Double Check Backflow Preventer",null,"Type of Backflow",null,"",null,null,"6.5 psi",{"$nulls":6},1.189,null,6.9068857213645485,null,4.329001266869487]
[null,"- 6.5","3/4\"",null,"Size of Backflow"]
[null,null,{"v":57.32861211413329,"d":"57.3"},null,"Residual Pressure at End of Line, PSI"]
[{"$nulls":19},"GPM","DV valve",null,"PGA valve (globe)",null,null,"PGA valve (angle)",null,null,"PEB valve"]
[{"$nulls":14},"Select Valve Type","max flow","min flow","psi loss","size",null,"3/4\"","1\"","1\"","1.5\"","2\"","1\"","1.5\"","2\"","1\"","1.5\"","2\""]
[{"$nulls":3},"* This is meant to be a guide. Your situation may require additional consideration.",{"$nulls":10}," 3/4\" Rainbird DV",22,0.2,5,null,1,3.2,3.3,5.1,null,null,4.3,null,null,1.3,null,null,1]
[{"$nulls":3},"Ask a W.P. Law Inc. professional about your specific requirements.",{"$nulls":10},"1\" Rainbird DV",30,0.2,3.8,null,3,3.9,3.6,5.3,{"$nulls":8},3]
[{"$nulls":14},"1\" Rainbird PEB",50,5,1.8,null,5,4.2,3.8,5.5,null,null,5,null,null,1.7,null,null,5]
[{"$nulls":14},"1\" Rainbird PGA \"angle\"",40,5,5.5,null,10,5,3.8,5.9,null,null,5.5,null,null,1.8,null,null,10]
[{"$nulls":14},"1\" Rainbird PGA \"globe\"",40,5,5.9,null,20,7.7,5.1,6,null,null,5.6,null,null,2.9,3.9,null,20]
[{"$nulls":14},"1.5\" Rainbird PEB",150,10,"",null,30,null,6.4,6.4,1.9,null,5.5,1.3,null,5.6,3.6,null,30]
[{"$nulls":14},"1.5\" Rainbird PGA \"angle\"",100,30,"",null,40,null,8.6,7,3.2,1.2,7.5,2,1,10,3.5,null,40]
[{"$nulls":14},"1.5\" Rainbird PGA \"globe\"",100,30,"",null,50,{"$nulls":3},4.8,1.5,null,3,0.9,15.6,3.6,4.8,50]
[{"$nulls":14},"2\" Rainbird PEB",200,50,"",null,75,{"$nulls":3},11.1,3,null,6.5,1.7,null,5.4,4.5,75]
[{"$nulls":14},"2\" Rainbird PGA \"angle\"",150,40,"",null,100,{"$nulls":3},19.2,5.5,null,11.7,3,null,9.6,5.2,100]
[{"$nulls":14},"2\" Rainbird PGA \"globe\"",150,40,"",null,125,{"$nulls":4},8.6,null,null,4.8,null,14.6,8.2,125]
[{"$nulls":19},150,{"$nulls":4},12,null,null,6.5,null,21.2,11.8,150]
[{"$nulls":19},175,{"$nulls":10},15.5,175]
[{"$nulls":19},200,{"$nulls":10},19.5,200]
[]
[{"$nulls":29},"DCA",{"$nulls":4},"PVB",{"$nulls":4},"RPV "]
[{"$nulls":14},"water meter size","max flow","max safe flow","psi loss",null,"flow/gpm","5/8\"","3/4\"","1\"","1 1/2\"","2\"","3\"","4\"",null,"flow/gpm","3/4\"","1\"","1 1/4\"","1 1/2\"","2\"","3/4\"","1\"","1 1/4\"","1 1/2\"","2\"","3/4\"","1\"","1 1/4\"","1 1/2\"","2\"","flow/gpm"]
[{"$nulls":13},"5/8\"","1 1/2\"",100,75,0,null,1,0.2,0.1,0,0,0,0,0,null,0,3,3,5,5,5,2,2,2,2,2,8,10,11.5,11.5,11.5,0]
[{"$nulls":13},"3/4\"","1\"",50,37.5,1.2,null,2,0.3,0.2,0,0,0,0,0,null,5,5.5,5,5.5,5.5,5.5,3.25,3.25,3,2.1,2.1,10.5,11,14,14,14,5]
[{"$nulls":13},"1\"","2\"",160,120,0,null,3,0.4,0.3,0,0,0,0,0,null,10,5.75,5.4,6,6,6,4,3.9,3.5,2.4,2.4,11,11.25,13.8,13.8,13.8,10]
[{"$nulls":13},"1 1/2\"","3\"",300,225,0,null,4,0.6,0.5,0.1,0,0,0,0,null,15,6.5,5.5,6.2,6.2,6.2,4.5,4,3.75,2.75,2.75,11.75,11.75,13.8,13.7,13.7,15]
[{"$nulls":13},"2\"","3/4\"",30,22.5,3.6,null,5,0.9,0.6,0.2,0,0,0,0,null,20,7.9,5.51,6.4,6.4,6.4,5.5,4.2,4,3,3,12.75,12,13.8,13.6,13.6,20]
[{"$nulls":13},"3\"","4\"",500,375,0,null,6,1.3,0.7,0.3,0,0,0,0,null,25,9,5.8,6.5,6.5,6.5,6.5,4.5,4.25,3.1,3.2,13.75,12,13.9,13.5,13.5,25]
[{"$nulls":13},"4\"","5/8\"",20,15,8.3,null,7,1.8,0.8,0.4,0,0,0,0,null,30,9.8,6,6.8,6.51,6.4,7.5,5,4.5,3.2,3.5,14,12,13.9,13.5,13.5,30]
[{"$nulls":19},8,2.3,1,0.5,0,0,0,0,null,35,null,6.5,6.9,6.52,6.2,null,5.5,4.75,3.4,3.75,null,12.2,13.9,13.5,13.5,35]
[{"$nulls":14},"backflow size","max flow","psi loss",null,null,9,3,1.3,0.6,0,0,0,0,null,40,null,7,7,6.6,6.1,null,6,5,3.5,4,null,12.75,14,13.5,13.5,40]
[{"$nulls":13},"3/4\"","1 1/2\"",100,6.2,null,null,10,3.7,1.6,0.7,0,0,0,0,null,45,null,8,7.25,6.65,6.05,null,6.5,5.3,3.6,4.1,null,13,14.5,13.5,13.5,45]
[{"$nulls":13},"1\"","1 1/4\"",75,6.2,null,null,11,4.4,1.9,0.8,0,0,0,0,null,50,null,8.85,7.5,6.75,6,null,7.3,5.7,3.8,4.2,null,13.75,14.75,13.5,13.3,50]
[{"$nulls":13},"1 1/4\"","1\"",50,5.5,null,null,12,5.1,2.2,0.9,0,0,0,0,null,55,null,null,7.85,6.76,6,null,null,5.8,3.9,4.3,null,null,15,13.6,13.3,55]
[{"$nulls":13},"1 1/2\"","2\"",155,6.2,null,null,13,6.1,2.6,1,0,0,0,0,null,60,null,null,8,6.8,6,null,null,6,4,4.5,null,null,15.25,13.7,13.3,60]
[{"$nulls":13},"2\" ","3/4\"",30,6.5,null,null,14,7.2,3.1,1.1,0,0,0,0,null,65,null,null,8.1,6.85,6.01,null,null,6.3,4.1,4.6,null,null,15.5,13.8,13.2,65]
[{"$nulls":19},15,8.3,3.6,1.2,0,0,0,0,null,70,null,null,8.5,6.9,6.05,null,null,6.6,4.2,4.8,null,null,15.75,13.9,13.2,70]
[{"$nulls":14},"Double Check Backflow Preventer",{"$nulls":4},16,9.4,4.1,1.4,0.4,0,0,0,null,75,null,null,9,7,6.1,null,null,7,4.3,4.9,null,null,16,14,13.2,75]
[{"$nulls":14},"Pressure Vacuum Breaker",{"$nulls":4},17,10.7,4.6,1.6,0.5,0,0,0,null,80,{"$nulls":3},7.2,6.15,{"$nulls":3},4.5,5,{"$nulls":3},14.33,13.3,80]
[{"$nulls":14},"Reduced Pressure Backflow Preventer",{"$nulls":4},18,12,5.2,1.8,0.6,0,0,0,null,90,{"$nulls":3},7.5,6.4,{"$nulls":3},4.9,5.2,{"$nulls":3},14.66,13.4,90]
[{"$nulls":19},19,13.4,5.8,2,0.7,0,0,0,null,100,{"$nulls":3},8,6.5,{"$nulls":3},5,5.4,{"$nulls":3},15,13.5,100]
[{"$nulls":19},20,15,6.5,2.2,0.8,0,0,0,null,110,{"$nulls":4},6.85,{"$nulls":4},5.6,{"$nulls":4},13.75,110]
[{"$nulls":19},22,null,7.9,2.8,1,0,0,0,null,120,{"$nulls":4},7,{"$nulls":4},5.75,{"$nulls":4},14,120]
[{"$nulls":19},24,null,9.5,3.4,1.2,0,0,0,null,130,{"$nulls":4},7.3,{"$nulls":4},6,{"$nulls":4},14.25,130]
[{"$nulls":19},26,null,11.2,4,1.4,0,0,0,null,140,{"$nulls":4},7.8,{"$nulls":4},6.1,{"$nulls":4},14.5,140]
[{"$nulls":19},28,null,13,4.6,1.6,0,0,0,null,150,{"$nulls":4},8.1,{"$nulls":4},6.2,{"$nulls":4},14.75,150]
[{"$nulls":19},30,null,15,5.3,1.8,0,0,0,null,160,{"$nulls":4},8.5,{"$nulls":4},6.5,{"$nulls":4},15,160]
[{"$nulls":19},32,null,null,6,2.1,0.8,0,0]
[{"$nulls":19},34,null,null,6.9,2.4,0.9,0,0]
[{"$nulls":19},36,null,null,7.8,2.7,1,0,0]
[{"$nulls":19},38,null,null,8.7,3,1.2,0,0]
[{"$nulls":19},40,null,null,9.6,3.3,1.3,0,0]
[{"$nulls":19},42,null,null,10.6,3.6,1.4,0,0]
[{"$nulls":19},44,null,null,11.7,3.9,1.5,0,0]
[{"$nulls":19},46,null,null,12.8,4.2,1.6,0,0]
[{"$nulls":19},48,null,null,13.9,4.5,1.7,0,0]
[{"$nulls":19},50,null,null,15,4.9,1.9,0.7,0]
[{"$nulls":19},52,{"$nulls":3},5.3,2.1,0.75,0]
[{"$nulls":19},54,{"$nulls":3},5.7,2.2,0.8,0]
[{"$nulls":19},56,{"$nulls":3},6.2,2.3,0.85,0]
[{"$nulls":19},58,{"$nulls":3},6.7,2.5,0.9,0]
[{"$nulls":19},60,{"$nulls":3},7.2,2.7,1,0]
[{"$nulls":19},65,{"$nulls":3},8.3,3.2,1.1,0]
[{"$nulls":19},70,{"$nulls":3},9.8,3.7,1.3,0]
[{"$nulls":19},75,{"$nulls":3},11.2,4.3,1.5,0]
[{"$nulls":19},80,{"$nulls":3},12.8,4.9,1.6,0.7]
[{"$nulls":19},90,{"$nulls":3},16.1,6.2,2,0.8]
[{"$nulls":19},100,{"$nulls":3},20,7.8,2.5,0.9]
[{"$nulls":19},110,{"$nulls":4},9.5,2.9,1]
[{"$nulls":19},120,{"$nulls":4},11.3,3.4,1.2]
[{"$nulls":19},130,{"$nulls":4},13,3.9,1.4]
[{"$nulls":19},140,{"$nulls":4},15.1,4.5,1.6]
[{"$nulls":19},150,{"$nulls":4},17.3,5.1,1.8]
[{"$nulls":19},160,{"$nulls":4},20,5.8,2.1]
[{"$nulls":19},170,{"$nulls":5},6.5,2.4]
[{"$nulls":19},180,{"$nulls":5},7.2,2.7]
[{"$nulls":19},190,{"$nulls":5},8,3]
[{"$nulls":19},200,{"$nulls":5},9,3.2]
[{"$nulls":19},220,{"$nulls":5},11,3.9]
[{"$nulls":19},240,{"$nulls":5},13,4.7]
[{"$nulls":19},260,{"$nulls":5},15,5.5]
[{"$nulls":19},280,{"$nulls":5},17.3,6.3]
[{"$nulls":19},300,{"$nulls":5},20,7.2]
[{"$nulls":19},350,{"$nulls":6},10]
[{"$nulls":19},400,{"$nulls":6},13]
[{"$nulls":19},450,{"$nulls":6},16.2]
[{"$nulls":19},500,{"$nulls":6},20]