{"text_format":"1","workbook":"xlsx","n_sheets":2,"sheets":["RiserFlotation","Info"],"not_rendered":{"charts":0,"images":1,"macros":1,"external_links":0,"defined_names":8,"comments":0,"pivot_tables":0},"unopened":[],"bounds":{"document_bytes":16777216,"sheet_cells":100000,"rows_first":2000,"rows_last":500,"rows_between":2000,"halvings":0,"cell_chars":16384,"cell_head_chars":4096},"cells_cut":0,"cells_raw":0,"read":"whole","date_system":"1900"}

{"sheet":"RiserFlotation","index":0,"n_rows":40,"n_cols":20,"rows_kept":40,"cut":false,"hidden":false,"merged":[[22,3,24,6],[3,1,3,2],[4,1,4,2],[5,1,5,2],[6,1,6,2]]}
["RISER FLOTATION CHECK",null,null,null,null,null,"IaRiserFlotation.xlsm Version 1.1",null,null,null,"Pipe gauges available:"]
[null,null,null,null,null,null,"2018-09-01",null,null,null,8,10,12,14,16]
[]
["Landowner"]
["County",null,null,null,null,null,null,null,null,null,"Table of approximate pipe weights per foot"]
["Computed by",null,null,null,"Checked"]
["Date",null,null,null,"Date",null,null,null,null,null,"Std.","3x1","Std.","3x1","Std.","3x1","Std.","3x1","Std.","3x1"]
[null,null,null,null,null,null,null,null,null,null,16,16,14,14,12,12,10,10,8,8]
["Riser Diameter",54,"inches",null,null,null,null,null,null,12,9.3000000000000007]
["Riser Gauge",16,"gauge",null,"=","User input cells",null,null,null,15,11.6,null,14.6]
["Corrugation","3x1","inches",null,"=","Program output",null,null,null,18,13.8,null,17.399999999999999]
["Riser Height",9,"ft",null,null,null,null,null,null,21,16,null,20.2]
[null,null,null,null,null,null,null,null,null,24,18.3,null,23.1]
["Unit wt. of saturated soil",115,"pcf",null,null,null,null,null,null,30,22.7,null,28.7]
["Concrete thickness",1.5,"ft",null,null,null,null,null,null,36,27.2,31.6,34.299999999999997,41,46.9]
["Unit wt. of concrete",150,"pcf",null,null,null,null,null,null,42,31.7,36.700000000000003,39.9,48,54.5]
[null,null,null,null,null,null,null,null,null,48,36.1,41.8,45.6,55,62.2,null,79.099999999999994,null,96.5]
["Factor of Safety",1.5,null,null,null,null,null,null,null,54,40.6,46.9,51.2,61,69.900000000000006,80.7,88.9,132.6,108.4,125.4]
[null,null,null,null,null,null,null,null,null,60,null,52,null,67,77.599999999999994,89.5,98.7,133.80000000000001,120.3,139]
[null,null,null,null,null,null,null,null,null,66,null,57.1,null,74,85.2,98.3,108.4,135,132.19999999999999,152.6]
["Riser area",{"$f":"(Dia+1)^2/576*PI()","v":16.498815585258896},"sq ft","Nominal Dia. +1\"",null,null,null,null,null,72,null,62.2,null,81,92.9,107.1,118.2,136.19999999999999,144.4,166.2]
["Flotation",{"$f":"B21*Hei*62.4","v":9265.7348326813972},"lb","Riser Volume x 62.4",null,null,null,null,null,78,null,67.400000000000006,null,87,null,115.9,127.9,147.4,156,179.8]
[null,null,null,{"$f":"IF(B24=0,\"Please adjust Input to meet manufactured combinations.\",\"\")","v":""},null,null,null,null,null,84,null,72.5,null,94,null,124.7,137.69999999999999,158.6,167.9,193.4]
["Riser unit weight",{"$f":"MAX(K34:T34)","v":46.9},"lb/ft",null,null,null,null,null,null,90,null,77.599999999999994,null,100,null,133.5,147.5,169.8,179.8,207]
[null,null,null,null,null,null,null,null,null,96,null,82.7,null,107,null,142.30000000000001,157.19999999999999,181,191.7,220.7]
["Riser base size checks:",null,null,null,null,null,null,null,null,102,null,87.8,null,114,null,151.1,null,192.1,null,234.3]
["Min. W for flotation",5.9341709739585191,"ft","Round up to next 0.5 Ft",null,null,null,null,null,108,null,92.9,null,120,null,159.9,null,203.3,null,247.9]
["Min. W, riser dia. + 2 ft",{"$f":"Dia/12+2","v":6.5},"ft","Min size from Std Drwg 1131",null,null,null,null,null,114,null,98,null,127,null,168.7,null,214.5,null,261.5]
["Submerged Concrete",{"$f":"(B16-62.4)*(B27^2)*B15","v":4627.1702084697745},"lb","Concrete Volume x (Unit Wt -62.4)",null,null,null,null,null,120,null,103.1,null,134,null,177.5,null,225.7,null,275.2]
["Submerged Soil",{"$f":"(B27^2-B21)*Hei*(B14-62.4)","v":8859.9506310829674},"lb","Soil Volume x (Unit Wt -62.4)",null,null,null,null,null,126,null,null,null,null,null,186.3,null,236.8,null,288.8]
["Riser Weight",{"$f":"Hei*B24","v":422.09999999999997},"lb",null,null,null,null,null,null,132,null,null,null,null,null,195.1,null,248,null,302.39999999999998]
["Total weight resisting float",{"$f":"SUM(B29:B31)","v":13909.220839552743},"lb",null,null,null,null,null,null,138,null,null,null,null,null,203.9,null,259.2,null,316.10000000000002]
[null,null,null,null,null,null,null,null,null,144,null,null,null,null,null,null,null,270.39999999999998,null,329.7]
["GoalSeek computation",{"$f":"B18*Float/Resist","v":0.99923657905405805},null,{"$f":"IF(L37,\"Calculated\",\"Please Solve\")","v":"Calculated"},null,null,null,null,null,null,{"$f":"IF(Gage=K8,IF(Corr=K7,VLOOKUP(Dia,$J9:$T33,K35),0),0)","v":0},46.9,0,0,0,0,0,0,0,0]
[null,null,null,null,null,null,null,null,null,null,2,3,4,5,6,7,8,9,10,11]
["Results:",null,null,"Base size W is max of computed"]
["Build base to W =",{"$f":"MAX(IF(B27-INT(B27)<0.5,INT(B27)+0.5,INT(B27)+1),B28)","v":6.5},"ft","Max of computed size and Dia + 2'",null,null,null,null,null,null,null,{"$f":"AND(test<=1.001,test>=0.999)","v":true}]
["Concrete Volume =",{"$f":"B37^2*1.5/27","v":2.3472222222222223},"cu yd"]
["Steel bar Length =",{"$f":"B37-0.5","v":6},"ft"]
["Number of bars =",{"$f":"2*(ROUNDUP(B37-1,0)+1)","v":14}]

{"sheet":"Info","index":1,"n_rows":49,"n_cols":3,"rows_kept":49,"cut":false,"hidden":false,"merged":[[34,2,35,2],[38,2,39,2],[0,0,0,2],[1,0,1,2]]}
[{"$f":"RiserFlotation!G1","v":"IaRiserFlotation.xlsm Version 1.1"}]
[{"$f":"RiserFlotation!G2","v":"2018-09-01"}]
[]
["Information"]
["This spreadsheet computes the required concrete base size for a CMP riser in order to meet a"]
["specified factor of safety against flotation. The user inputs the following data:"]
[null,"Riser diameter"]
[null,"Riser height"]
[null,"CMP corrugation type (standard 2-2/3\" x 1/2\", or 3\" x 1\")"]
[null,"CMP gauge"]
[null,"Unit weight of saturated soil; default value is 110 pcf"]
[null,"Unit weight of concrete, default value is 150 pcf"]
[null,"Thickness of concrete base; default value is 1.5 ft"]
[null,"Desired factor of safety against flotation; default value is 1.5."]
[]
["The program uses a Lookup table to find the weight per foot for the selected riser size and gauge."]
["Pipe sizes and gauges included in the table are those available based on current local fabricating capabilities."]
["Always check the appropriate Conservation Practice Standard for limitations on pipe sizes and gauges."]
[]
["The Solve button uses the GoalSeek function to determine the minimum concrete base size."]
["GoalSeek varies the value of W in cell B27 to determine the required riser weight."]
["The Goal value is for cell B34 = 1 = F.S x flotation force / total riser weight."]
[]
["The design concrete base size is then selected as the larger of: "]
[null,"1) the minimum dimension rounded up to the next 0.5-ft increment; or "]
[null,"2) the riser diameter plus 2 ft."]
[]
["The spreadsheet also computes the concrete volume for the base, reinforcing steel bar length, and"]
["number of bars required."]
[]
["Original spreadsheet developed by Neal Struthers, Civil Engineer, NRCS, Jan. 2004."]
[]
["Updates"]
["Date","Version","Modifications"]
["2018-09-01",1.1000000000000001,"Formulas checked. Steel rebar length formula revised. Info tab added. Other minor formatting changes."]
[]
[]
["References",1,"NRCS Standard Drawing 1131, Details of Corrugated Metal Pipe Vertical Inlet"]
[null,2,"Handbook of Steel Drainage & Highway Construction Products, American Iron and Steel Institute, 4th Ed. 1993"]
[]
[null,3,"Corrugated Metal Pipe Design Guide, Contech Engineered Solutions, 2017"]
[null,4,"Contech Engineered Solutions, Ankeny, IA office"]
[]
["Program Support:"]
["USDA Natural Resources Conservation Service"]
["Federal Building"]
["210 Walnut St, Room 693"]
["Des Moines, Iowa 50309"]
["515.284.4135"]