{"text_format":"1","workbook":"xlsx","n_sheets":4,"sheets":["Final","MOT Phase 2","MOT Phase 3 & 3A","Tables"],"not_rendered":{"charts":0,"images":5,"macros":0,"external_links":0,"defined_names":21,"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":"Final","index":0,"n_rows":77,"n_cols":33,"rows_kept":77,"cut":false,"hidden":false,"merged":[[49,30,50,30],[49,31,50,31],[50,10,50,11],[62,2,62,3],[48,20,48,29],[48,30,48,32],[48,4,48,19],[49,32,50,32],[49,21,49,26],[49,27,49,29],[49,4,49,11],[49,12,49,14],[49,15,49,17],[49,18,49,19],[49,20,50,20],[4,13,4,15],[6,13,6,15],[58,2,58,3],[59,2,59,3],[54,2,54,3],[55,2,55,3],[51,10,51,11],[48,2,50,3],[5,13,5,15],[7,13,7,15],[61,1,67,1],[69,1,75,1],[70,2,70,3],[71,2,71,3],[74,2,74,3],[75,2,75,3],[68,1,68,29],[63,2,63,3],[66,2,66,3],[67,2,67,3]]}
[]
[]
[]
[]
[null,"Calculated:","CJM",null,null,"Date:","2018-11-07",null,null,null,null,null,"Stage Review Submission:","Stage 2"]
[null,"Checked:","JDC",null,null,"Date:","2018-11-07",null,null,null,null,null,"PID/Job No.:",102858]
[null,"Concurred:",null,null,null,"Date:",null,null,null,null,null,null,"Bridge No.:","POR-76-1658"]
[null,"Back Checked:",null,null,null,"Date:",null,null,null,null,null,null,"SFN:",6702880]
[null,"Released:",null,null,null,"Date:"]
[null,"Project:","POR-76-1658/2118"]
[null,"Subject:","Spread check and Discharge Calculations, Final Condition"]
[null,null,null,null,null,null,null,null,null,null,null,null,"(Input values are shown underlined and in italics.)"]
[null,null,null,null,null,null,null,null,null,null,null,null,"References"]
["Drainage and Gutter Spread Calculations"]
[]
[null,"General Data"]
[]
[null,null,"Zone",null,"A",null,null,null,"(Fig. 1101-3)",null,"a",{"$f":"IF($E$18=\"A\",VLOOKUP($E$19,Tables!ZoneA,2),IF($E$18=\"B\",VLOOKUP($E$19,Tables!ZoneB,2),IF($E$18=\"C\",VLOOKUP($E$19,Tables!ZoneC,2),IF($E$18=\"D\",VLOOKUP($E$19,Tables!ZoneD,2)))))","v":46.183999999999997}]
[null,null,"Return",null,2,"yrs",{"$f":"IF(E19=10,\"Freeways\",IF(E19=5,\"High volume highways.\",IF(E19=2,\"All other highways.\",\"Check frequency.\")))","v":"All other highways."},null,"(1103.2)",null,"b",{"$f":"IF($E$18=\"A\",VLOOKUP($E$19,Tables!ZoneA,3),IF($E$18=\"B\",VLOOKUP($E$19,Tables!ZoneB,3),IF($E$18=\"C\",VLOOKUP($E$19,Tables!ZoneC,3),IF($E$18=\"D\",VLOOKUP($E$19,Tables!ZoneD,3)))))","v":9}]
[null,null,"Pvmt. Spread",null,6,"Max. Allow.",null,null,"(1103.2)",null,"c",{"$f":"IF($E$18=\"A\",VLOOKUP($E$19,Tables!ZoneA,4),IF($E$18=\"B\",VLOOKUP($E$19,Tables!ZoneB,4),IF($E$18=\"C\",VLOOKUP($E$19,Tables!ZoneC,4),IF($E$18=\"D\",VLOOKUP($E$19,Tables!ZoneD,4)))))","v":0.85899999999999999}]
[]
[null,null,"Vertical Curve 1"]
[null,null,null,"PVI-1",null,"L","G1","G2","e"]
[null,null,null,"Station","Elev.",null,"Back","Ahead"]
[null,null,null,5008.45,1126.33,635.5,3.0800000000000001E-2,-4.5100000000000001E-2,{"$f":"(H25-G25)*F25/8","v":-6.0293062499999994}]
[]
[null,null,null,"PVC-1",null,"PVT-1",null,{"$f":"IF(H25-G25<0,\"High Point\",IF(H25-G25>0,\"Low Point\",\"\"))","v":"High Point"}]
[null,null,null,"Station","Elev.","Station","Elev.","Station","Elev."]
[null,null,null,4690.7,1116.54,5326.2,1112,{"$f":"IF(AND(G25>0,H25>0),F29,IF(AND(G25<0,H25<0),D29,D29+F25*G25/-(H25-G25)))","v":4948.5840579710148},{"$f":"IF(H29<$D$29,$E$29+$G$25*(H29-$D$29),IF(AND(H29>=$D$29,H29<=$F$29),$E$29+$G$25*(H29-$D$29)+$I$25*((H29-$D$29)/$F$25*2)^2,IF(AND(H29>$F$29,H29<$K$29),$E$25+$H$25*(H29-$D$25),IF(AND(H29>=$K$29,H29<=$M$29),$L$29+$N$25*(H29-$K$29)+$P$25*((H29-$K$29)/$M$25*2)^2,$L$25+$O$25*(H29-$K$25)))))","v":1120.5114144927536}]
[]
[null,"General Formulae"]
[]
[null,null,"Hydrology"]
[null,null,"to       =","1.8 ( 1.1 - C ) L1/2 / s1/3  ≥ 10 min  where \"s\" is in percent"]
[null,null,"i        =","a / ( t + b )c"]
[null,null,"Q      =","C i A"]
[null,null,"Z       =","1 / Cross Slope"]
[null,null,"Q      =","0.56 ( Z / n ) s1/2 d8/3  for triangular channel flow."]
[null,null,"d       =","{ Q / [ 0.56 ( Z / n ) s1/2 ] }3/8  where \"s\" is in ft/ft"]
[null,null,"SG     =","Z d"]
[]
[null,null,"Neenah Inlet Capacity"]
[null,null,"Qi     =","K d5/3","Inlet capacity.",null,null,null,null,null,"(Neenah Foundry Co., Inlet Grate Capacities, p. ii)"]
[null,null,"K      =",35,"Inlet capacity factor.",null,null,null,null,null,"(Neenah, Inlet Capacities, No. R-3924, p. 37)"]
[]
[]
[null,"Tabulated Data"]
[]
[null,null,"Region",null,"Input Data",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Flow and Gutter Spread",null,null,null,null,null,null,null,null,null,"Neenah Inlets"]
[null,null,null,null,"Drainage Area",null,null,null,null,null,null,null,"Grade",null,null,"Roadway Data",null,null,"Parameters",null,"Critical Point","Hydrological Data",null,null,null,null,null,"Spread Data",null,null,"Inlet \nCapacity \nFactor","Inlet \nCapacity","Inlets \nRequired"]
[null,null,null,null,"Begin Station","End Station","Length","Begin\nWidth","End\nWidth","Average\nWidth","Drainage\nArea",null,"Begin\nElevation","End\nElevation","Average\nLongitudinal\nGrade","Cross Slope","Curb Height","Distance from\nCurb to\nEdge of Lane","Roughness\nCoefficient","Runoff\nCoefficient",null,"Concentration\nTime","Rainfall\nIntensity","Drainage\nArea","Discharge","Previous\nDischarge","Total\nDischarge","Average\nLongitudinal\nGrade","Depth at Curb","Spread"]
[null,null,"Variable",null,null,null,"L","W1","W2","W","L W",null,null,null,null,"Sx",null,null,"n","C",null,"to","i","A","Q","Qp","Qt","s","d","SG","K","Qi"]
[null,null,"Units",null,null,null,"ft","ft","ft","ft","ft2","acres",null,null,"ft/ft","ft/ft","in","ft",null,null,null,"min","in/hr","acres","cfs","cfs","cfs","ft/ft","ft","ft",null,"cfs","ea"]
[null,null,"Median Side of the Bridge Forward - Final Condition"]
[null,null,"From High Point",null,{"$f":"H29","v":4948.5840579710148},{"$f":"60112.41+25","v":60137.41},{"$f":"ABS(E55-F55)","v":55188.825942028991},13.75,13.75,13.75,{"$f":"G55*J55","v":758846.35670289863},{"$f":"ROUND(K55*2.2957*10^-5,4)","v":17.4208},{"$f":"ROUND(IF(E55<$D$29,$E$29+$G$25*(E55-$D$29),IF(AND(E55>=$D$29,E55<=$F$29),$E$29+$G$25*(E55-$D$29)+$I$25*((E55-$D$29)/$F$25*2)^2,IF(AND(E55>$F$29,E55<$K$29),$E$25+$H$25*(E55-$D$25),IF(AND(E55>=$K$29,E55<=$M$29),$L$29+$N$25*(E55-$K$29)+$P$25*((E55-$K$29)/$M$25*2)^2,$L$25+$O$25*(E55-$K$25))))),3)","v":1120.511},0,{"$f":"ROUND((M55-N55)/G55,4)","v":2.0299999999999999E-2},0.04,6,12,1.4999999999999999E-2,0.9,{"$f":"IF(M55=MIN(M55:N55),E55,F55)","v":60137.41},{"$f":"MAX(ROUND(1.8*(1.1-T55)*G55^(1/2)/(ABS(O55)*100)^(1/3),3),10)","v":66.793000000000006},{"$f":"ROUND($L$18/(V55+$L$19)^$L$20,3)","v":1.1220000000000001},{"$f":"L55","v":17.4208},{"$f":"ROUND(T55*W55*X55,3)","v":17.591999999999999},0,{"$f":"SUM(Y55:Z55)","v":17.591999999999999},{"$f":"ABS(O55)","v":2.0299999999999999E-2},{"$f":"ROUND((AA55/(0.56*(1/P55)/S55*AB55^(1/2)))^(3/8),3)","v":0.46800000000000003},{"$f":"(1/P55)*AC55","v":11.700000000000001},{"$f":"$D$44","v":35},{"$f":"AE55*AC55^(5/3)","v":9.8736516173139943},{"$f":"CEILING(AA55/AF55,1)","v":2}]
[null,null,"to End/A.S."]
[]
[null,null,"Median Side of the Bridge Back - Final Condition"]
[null,null,"HP Bk",null,{"$f":"H29","v":4948.5840579710148},{"$f":"59798.5-25","v":59773.5},{"$f":"ABS(F59-E59)","v":54824.915942028987},13.75,13.75,13.75,{"$f":"G59*J59","v":753842.59420289856},{"$f":"ROUND(K59*2.2957*10^-5,4)","v":17.306000000000001},{"$f":"ROUND(IF(E59<$D$29,$E$29+$G$25*(E59-$D$29),IF(AND(E59>=$D$29,E59<=$F$29),$E$29+$G$25*(E59-$D$29)+$I$25*((E59-$D$29)/$F$25*2)^2,IF(AND(E59>$F$29,E59<$K$29),$E$25+$H$25*(E59-$D$25),IF(AND(E59>=$K$29,E59<=$M$29),$L$29+$N$25*(E59-$K$29)+$P$25*((E59-$K$29)/$M$25*2)^2,$L$25+$O$25*(E59-$K$25))))),3)","v":1120.511},0,{"$f":"ROUND((M59-N59)/G59,4)","v":2.0400000000000001E-2},0.04,6,12,1.4999999999999999E-2,0.9,{"$f":"F59","v":59773.5},{"$f":"MAX(ROUND(1.8*(1.1-T59)*G59^(1/2)/(ABS(O59)*100)^(1/3),3),10)","v":66.462999999999994},{"$f":"ROUND($L$18/(V59+$L$19)^$L$20,3)","v":1.1259999999999999},{"$f":"L59","v":17.306000000000001},{"$f":"ROUND(T59*W59*X59,3)","v":17.538},0,{"$f":"SUM(Y59:Z59)","v":17.538},{"$f":"ABS(O59)","v":2.0400000000000001E-2},{"$f":"ROUND((AA59/(0.56*(1/P59)/S59*AB59^(1/2)))^(3/8),3)","v":0.46700000000000003},{"$f":"(1/P59)*AC59","v":11.675000000000001},{"$f":"$D$44","v":35},{"$f":"AE59*AC59^(5/3)","v":9.8385140908500013},{"$f":"CEILING(AA59/AF59,1)","v":2}]
[null,null,"to End/A.S."]
[]
[null,"LEFT","Outside Side of the Bridge Forward Abutment - Final Condition"]
[null,null,"From High Point",null,{"$f":"H29","v":4948.5840579710148},5137.43,{"$f":"ABS(E63-F63)","v":188.84594202898552},14.5,14.5,{"$f":"AVERAGE(H63:I63)","v":14.5},{"$f":"G63*J63","v":2738.26615942029},{"$f":"ROUND(K63*2.2957*10^-5,4)","v":6.2899999999999998E-2},{"$f":"ROUND(IF(E63<$D$29,$E$29+$G$25*(E63-$D$29),IF(AND(E63>=$D$29,E63<=$F$29),$E$29+$G$25*(E63-$D$29)+$I$25*((E63-$D$29)/$F$25*2)^2,IF(AND(E63>$F$29,E63<$K$29),$E$25+$H$25*(E63-$D$25),IF(AND(E63>=$K$29,E63<=$M$29),$L$29+$N$25*(E63-$K$29)+$P$25*((E63-$K$29)/$M$25*2)^2,$L$25+$O$25*(E63-$K$25))))),3)","v":1120.511},1118.3820000000001,{"$f":"ROUND((M63-N63)/G63,4)","v":1.1299999999999999E-2},1.6E-2,4,4,1.4999999999999999E-2,0.9,{"$f":"IF(M63=MIN(M63:N63),E63,F63)","v":5137.43},{"$f":"MAX(ROUND(1.8*(1.1-T63)*G63^(1/2)/(ABS(O63)*100)^(1/3),3),10)","v":10},{"$f":"ROUND($L$18/(V63+$L$19)^$L$20,3)","v":3.6819999999999999},{"$f":"L63","v":6.2899999999999998E-2},{"$f":"ROUND(T63*W63*X63,3)","v":0.20799999999999999},0,{"$f":"SUM(Y63:Z63)","v":0.20799999999999999},{"$f":"ABS(O63)","v":1.1299999999999999E-2},{"$f":"ROUND((AA63/(0.56*(1/P63)/S63*AB63^(1/2)))^(3/8),3)","v":7.0000000000000007E-2},{"$f":"(1/P63)*AC63","v":4.375},{"$f":"$D$44","v":35},{"$f":"AE63*AC63^(5/3)","v":0.41613231679924367},{"$f":"CEILING(AA63/AF63,1)","v":1}]
[null,null,"to End/A.S."]
[]
[null,null,"Outside Side of the Bridge Rear Abutment - Final Condition"]
[null,null,"HP Bk",null,{"$f":"H29","v":4948.5840579710148},4863.2700000000004,{"$f":"ABS(F67-E67)","v":85.314057971014336},14.5,14.5,{"$f":"AVERAGE(H67:I67)","v":14.5},{"$f":"G67*J67","v":1237.0538405797079},{"$f":"ROUND(K67*2.2957*10^-5,4)","v":2.8400000000000002E-2},{"$f":"ROUND(IF(E67<$D$29,$E$29+$G$25*(E67-$D$29),IF(AND(E67>=$D$29,E67<=$F$29),$E$29+$G$25*(E67-$D$29)+$I$25*((E67-$D$29)/$F$25*2)^2,IF(AND(E67>$F$29,E67<$K$29),$E$25+$H$25*(E67-$D$25),IF(AND(E67>=$K$29,E67<=$M$29),$L$29+$N$25*(E67-$K$29)+$P$25*((E67-$K$29)/$M$25*2)^2,$L$25+$O$25*(E67-$K$25))))),3)","v":1120.511},1120.077,{"$f":"ROUND((M67-N67)/G67,4)","v":5.1000000000000004E-3},1.6E-2,4,4,1.4999999999999999E-2,0.9,{"$f":"F67","v":4863.2700000000004},{"$f":"MAX(ROUND(1.8*(1.1-T67)*G67^(1/2)/(ABS(O67)*100)^(1/3),3),10)","v":10},{"$f":"ROUND($L$18/(V67+$L$19)^$L$20,3)","v":3.6819999999999999},{"$f":"L67","v":2.8400000000000002E-2},{"$f":"ROUND(T67*W67*X67,3)","v":9.4E-2},0,{"$f":"SUM(Y67:Z67)","v":9.4E-2},{"$f":"ABS(O67)","v":5.1000000000000004E-3},{"$f":"ROUND((AA67/(0.56*(1/P67)/S67*AB67^(1/2)))^(3/8),3)","v":6.0999999999999999E-2},{"$f":"(1/P67)*AC67","v":3.8125},{"$f":"$D$44","v":35},{"$f":"AE67*AC67^(5/3)","v":0.33083981504939819},{"$f":"CEILING(AA67/AF67,1)","v":1}]
[null,null,"to End/A.S."]
[]
[null,"RIGHT","Outside Side of the Bridge Forward Abutment - Final Condition"]
[null,null,"From High Point",null,{"$f":"H29","v":4948.5840579710148},5137.43,{"$f":"ABS(E71-F71)","v":188.84594202898552},14.5,14.5,{"$f":"AVERAGE(H71:I71)","v":14.5},{"$f":"G71*J71","v":2738.26615942029},{"$f":"ROUND(K71*2.2957*10^-5,4)","v":6.2899999999999998E-2},{"$f":"ROUND(IF(E71<$D$29,$E$29+$G$25*(E71-$D$29),IF(AND(E71>=$D$29,E71<=$F$29),$E$29+$G$25*(E71-$D$29)+$I$25*((E71-$D$29)/$F$25*2)^2,IF(AND(E71>$F$29,E71<$K$29),$E$25+$H$25*(E71-$D$25),IF(AND(E71>=$K$29,E71<=$M$29),$L$29+$N$25*(E71-$K$29)+$P$25*((E71-$K$29)/$M$25*2)^2,$L$25+$O$25*(E71-$K$25))))),3)","v":1120.511},{"$f":"ROUND(IF(F71<$D$29,$E$29+$G$25*(F71-$D$29),IF(AND(F71>=$D$29,F71<=$F$29),$E$29+$G$25*(F71-$D$29)+$I$25*((F71-$D$29)/$F$25*2)^2,IF(AND(F71>$F$29,F71<$K$29),$E$25+$H$25*(F71-$D$25),IF(AND(F71>=$K$29,F71<=$M$29),$L$29+$N$25*(F71-$K$29)+$P$25*((F71-$K$29)/$M$25*2)^2,$L$25+$O$25*(F71-$K$25))))),3)","v":1118.3820000000001},{"$f":"ROUND((M71-N71)/G71,4)","v":1.1299999999999999E-2},1.6E-2,4,4,1.4999999999999999E-2,0.9,{"$f":"IF(M71=MIN(M71:N71),E71,F71)","v":5137.43},{"$f":"MAX(ROUND(1.8*(1.1-T71)*G71^(1/2)/(ABS(O71)*100)^(1/3),3),10)","v":10},{"$f":"ROUND($L$18/(V71+$L$19)^$L$20,3)","v":3.6819999999999999},{"$f":"L71","v":6.2899999999999998E-2},{"$f":"ROUND(T71*W71*X71,3)","v":0.20799999999999999},0,{"$f":"SUM(Y71:Z71)","v":0.20799999999999999},{"$f":"ABS(O71)","v":1.1299999999999999E-2},{"$f":"ROUND((AA71/(0.56*(1/P71)/S71*AB71^(1/2)))^(3/8),3)","v":7.0000000000000007E-2},{"$f":"(1/P71)*AC71","v":4.375},{"$f":"$D$44","v":35},{"$f":"AE71*AC71^(5/3)","v":0.41613231679924367},{"$f":"CEILING(AA71/AF71,1)","v":1}]
[null,null,"to End/A.S."]
[]
[null,null,"Outside Side of the Bridge Rear Abutment - Final Condition"]
[null,null,"HP Bk",null,{"$f":"H29","v":4948.5840579710148},4863.33,{"$f":"ABS(F75-E75)","v":85.254057971014845},14.5,14.5,{"$f":"AVERAGE(H75:I75)","v":14.5},{"$f":"G75*J75","v":1236.1838405797153},{"$f":"ROUND(K75*2.2957*10^-5,4)","v":2.8400000000000002E-2},{"$f":"ROUND(IF(E75<$D$29,$E$29+$G$25*(E75-$D$29),IF(AND(E75>=$D$29,E75<=$F$29),$E$29+$G$25*(E75-$D$29)+$I$25*((E75-$D$29)/$F$25*2)^2,IF(AND(E75>$F$29,E75<$K$29),$E$25+$H$25*(E75-$D$25),IF(AND(E75>=$K$29,E75<=$M$29),$L$29+$N$25*(E75-$K$29)+$P$25*((E75-$K$29)/$M$25*2)^2,$L$25+$O$25*(E75-$K$25))))),3)","v":1120.511},{"$f":"ROUND(IF(F75<$D$29,$E$29+$G$25*(F75-$D$29),IF(AND(F75>=$D$29,F75<=$F$29),$E$29+$G$25*(F75-$D$29)+$I$25*((F75-$D$29)/$F$25*2)^2,IF(AND(F75>$F$29,F75<$K$29),$E$25+$H$25*(F75-$D$25),IF(AND(F75>=$K$29,F75<=$M$29),$L$29+$N$25*(F75-$K$29)+$P$25*((F75-$K$29)/$M$25*2)^2,$L$25+$O$25*(F75-$K$25))))),3)","v":1120.077},{"$f":"ROUND((M75-N75)/G75,4)","v":5.1000000000000004E-3},1.6E-2,4,4,1.4999999999999999E-2,0.9,{"$f":"F75","v":4863.33},{"$f":"MAX(ROUND(1.8*(1.1-T75)*G75^(1/2)/(ABS(O75)*100)^(1/3),3),10)","v":10},{"$f":"ROUND($L$18/(V75+$L$19)^$L$20,3)","v":3.6819999999999999},{"$f":"L75","v":2.8400000000000002E-2},{"$f":"ROUND(T75*W75*X75,3)","v":9.4E-2},0,{"$f":"SUM(Y75:Z75)","v":9.4E-2},{"$f":"ABS(O75)","v":5.1000000000000004E-3},{"$f":"ROUND((AA75/(0.56*(1/P75)/S75*AB75^(1/2)))^(3/8),3)","v":6.0999999999999999E-2},{"$f":"(1/P75)*AC75","v":3.8125},{"$f":"$D$44","v":35},{"$f":"AE75*AC75^(5/3)","v":0.33083981504939819},{"$f":"CEILING(AA75/AF75,1)","v":1}]
[null,null,"to End/A.S."]
[null,"4. No scuppers required for FINAL condition."]

{"sheet":"MOT Phase 2","index":1,"n_rows":96,"n_cols":39,"rows_kept":96,"cut":false,"hidden":false,"merged":[[88,2,88,3],[86,2,86,3],[87,2,87,3],[55,8,55,12],[84,2,84,3],[85,2,85,3],[75,36,76,36],[75,35,76,35],[75,34,76,34],[74,30,74,31],[75,31,76,31],[75,30,76,30],[75,20,76,20],[76,10,76,11],[79,2,79,3],[74,32,74,38],[75,21,75,26],[75,27,75,29],[74,20,74,29],[74,4,74,19],[75,18,75,19],[75,4,75,11],[75,12,75,14],[75,15,75,17],[75,33,76,33],[75,32,76,32],[75,38,76,38],[75,37,76,37],[3,13,3,15],[5,13,5,15],[81,2,81,3],[61,8,61,12],[56,8,56,12],[57,8,57,12],[58,8,58,12],[59,8,59,12],[60,8,60,12],[4,13,4,15],[6,13,6,15],[77,10,77,11],[74,2,76,3],[54,8,54,12]]}
[null,"JMT"]
[]
[]
[null,"Calculated:","CM",null,null,"Date:","2016-03-03",null,null,null,null,null,"Stage Review Submission:","Stage 1"]
[null,"Checked:",null,null,null,"Date:",null,null,null,null,null,null,"PID/Job No.:",99626]
[null,"Concurred:",null,null,null,"Date:",null,null,null,null,null,null,"Bridge No.:","MAH-76K-1482"]
[null,"Back Checked:",null,null,null,"Date:",null,null,null,null,null,null,"SFN:",5029784]
[null,"Released:",null,null,null,"Date:"]
[null,"Project:","MAH-164/626-4.85/1.05"]
[null,"Subject:","Spread check for MOT condition, Phase 2 on new structure"]
[null,null,null,null,null,null,null,null,null,null,null,null,"(Input values are shown underlined and in italics.)"]
[null,null,null,null,null,null,null,null,null,null,null,null,"References"]
["Drainage and Gutter Spread Calculations"]
[]
[null,"General Data"]
[]
[null,null,"Zone",null,"a",null,null,null,"(Fig. 1101-3)",null,"a",{"$f":"IF($E$17=\"A\",VLOOKUP($E$18,Tables!ZoneA,2),IF($E$17=\"B\",VLOOKUP($E$18,Tables!ZoneB,2),IF($E$17=\"C\",VLOOKUP($E$18,Tables!ZoneC,2),IF($E$17=\"D\",VLOOKUP($E$18,Tables!ZoneD,2)))))","v":46.183999999999997}]
[null,"MOT Condition","Return",null,2,"yrs",{"$f":"IF(E18=10,\"Freeways\",IF(E18=5,\"High volume highways.\",IF(E18=2,\"All other highways.\",\"Check frequency.\")))","v":"All other highways."},null,"(1103.2)",null,"b",{"$f":"IF($E$17=\"A\",VLOOKUP($E$18,Tables!ZoneA,3),IF($E$17=\"B\",VLOOKUP($E$18,Tables!ZoneB,3),IF($E$17=\"C\",VLOOKUP($E$18,Tables!ZoneC,3),IF($E$17=\"D\",VLOOKUP($E$18,Tables!ZoneD,3)))))","v":9}]
[null,null,"Pvmt. Spread",null,1,"Max. Allow.",null,null,"(1103.2)",null,"c",{"$f":"IF($E$17=\"A\",VLOOKUP($E$18,Tables!ZoneA,4),IF($E$17=\"B\",VLOOKUP($E$18,Tables!ZoneB,4),IF($E$17=\"C\",VLOOKUP($E$18,Tables!ZoneC,4),IF($E$17=\"D\",VLOOKUP($E$18,Tables!ZoneD,4)))))","v":0.85899999999999999}]
[]
[null,null,"Constant -2.12% grade, no vertical curve on bridge."]
[]
[null,null,"Elevation at Station 204+00 = 1126.26 from P & P sheet"]
[]
[]
[]
[]
[null,"General Formulae"]
[]
[null,null,"Hydrology"]
[null,null,"to       =","1.8 ( 1.1 - C ) L1/2 / s1/3  ≥ 10 min  where \"s\" is in percent"]
[null,null,"i        =","a / ( t + b )c"]
[null,null,"Q      =","C i A"]
[null,null,"Z       =","1 / Cross Slope"]
[null,null,"Q      =","0.56 ( Z / n ) s1/2 d8/3  for triangular channel flow."]
[null,null,"d       =","{ Q / [ 0.56 ( Z / n ) s1/2 ] }3/8  where \"s\" is in ft/ft"]
[null,null,"SG     =","Z d"]
[]
[null,null,"Neenah Inlet Capacity"]
[null,null,"Qi     =","K d5/3","Inlet capacity.",null,null,null,null,null,"(Neenah Foundry Co., Inlet Grate Capacities, p. ii)"]
[null,null,"K      =",35,"Inlet capacity factor.",null,null,null,null,null,"(Neenah, Inlet Capacities, No. R-3924, p. 37)"]
[]
[null,null,"Flow By-Pass",null,null,null,null,null,null,null,null,null,null,null,null,"(FHWA, HEC 12, Drainage of Highway Pavements, Chap 7,"]
[null,null,"W",18,"in",null,null,null,null,null,null,null,null,null,null,"and TxDOT, Hydaulic Design Manual, pp. 10-36 - 10-41.)"]
[null,null,null,{"$f":"D44/12","v":1.5},"ft",null,"Grate width. (Transverse to the flow.)"]
[null,null,"L",6,"in"]
[null,null,null,{"$f":"D46/12","v":0.5},"ft",null,"Grate length. (Along the flow.)"]
[null,null,"T       =","SG",null,null,"Flow width in the gutter."]
[null,null,"EO     =","1 - ( 1 - W/T )8/3 ≤ 1.0",null,null,"Ratio of frontal flow to total flow.",null,null,null,null,null,null,null,null,"(FHWA, HEC 12, Drainage of Highway Pavements, eq. (7).)"]
[null,null,"V       =","Q/A",null,null,"Flow in the gutter."]
[null,null,"=","Q / (  d SG / 2 )"]
[]
[null,null,"VO",null,null,"Velocity where splash-over occurs.",null,null,null,null,null,null,null,null,null,"(TxDOT, Hydraulic Design Manual, p. 10-40.)"]
[]
[null,"Grate Type","Grate Configuration",null,null,null,"Typical Bar Spacing (in.)",null,"Splash-over Velocity Equation"]
[null,1,"Parallel Bars",null,null,null,2,null,"Vo = 2.218 + 4.031L - 0.649L² + 0.056L³",null,null,null,null,null,null,null,1,"Parallel Bars",2.218,4.0309999999999997,-0.64900000000000002,5.6000000000000001E-2]
[null,2,"Parallel Bars",null,null,null,1.2,null,"Vo = 1.762 + 3.117L - 0.451L² + 0.033L³",null,null,null,null,null,null,null,2,"Parallel Bars",1.762,3.117,-0.45100000000000001,3.3000000000000002E-2]
[null,3,"Transverse Curved Vane",null,null,null,4.5,null,"Vo = 1.381 + 2.780L - 0.300L² + 0.020L³",null,null,null,null,null,null,null,3,"Transverse Curved Vane",1.381,2.78,-0.3,0.02]
[null,4,"Transverse 45° Tilted Vane",null,null,null,4,null,"Vo = 0.988 + 2.625L - 0.359L² + 0.029L³",null,null,null,null,null,null,null,4,"Transverse 45° Tilted Vane",0.98799999999999999,2.625,-0.35899999999999999,2.9000000000000001E-2]
[null,5,"Parallel bars w/ transverse rods",null,null,null,"2 parallel/4 trans",null,"Vo = 0.735 + 2.437L - 0.265L² + 0.018L³",null,null,null,null,null,null,null,5,"Parallel bars w/ transverse rods",0.73499999999999999,2.4369999999999998,-0.26500000000000001,1.7999999999999999E-2]
[null,6,"Transverse 30° Tilted Vane",null,null,null,4,null,"Vo = 0.505 + 2.344L - 0.200L² + 0.014L³",null,null,null,null,null,null,null,6,"Transverse 30° Tilted Vane",0.505,2.3439999999999999,-0.2,1.4E-2]
[null,7,"Reticuline",null,null,null,"n/a",null,"Vo = 0.030 + 2.278L - 0.179L² + 0.010L³",null,null,null,null,null,null,null,7,"Reticuline",0.03,2.278,-0.17899999999999999,0.01]
[]
[null,null,"Grate Type:",null,1,{"$f":"VLOOKUP(E64,Q56:V62,3)","v":2.218}]
[null,null,"VO     =",{"$f":"VLOOKUP(E64,Q56:V62,3)","v":2.218},{"$f":"VLOOKUP(E64,Q56:V62,4)","v":4.0309999999999997},{"$f":"VLOOKUP(E64,Q56:V62,5)","v":-0.64900000000000002},{"$f":"VLOOKUP(E64,Q56:V62,6)","v":5.6000000000000001E-2}]
[null,null,null,{"$f":"$D$65+$E$65*$D$47+$F$65*$D$47^2+$G$65*$D$47^3","v":4.0782499999999988},"ft/s"]
[]
[null,null,"Rf     =","1 - 0.09 ( V - VO ) ≤ 1.0",null,null,null,"Ratio of frontal flow intercepted to total flow.",null,null,null,null,null,null,null,"(HEC 12, eq. (9).)"]
[null,null,"RS     =","1 / [ 1 + ( 0.15 V1.8 ) / ( Sx L2.3 ) ] ≤ 1.0",null,null,null,"Ratio of side flow intercepted to total flow.",null,null,null,null,null,null,null,"(HEC 12, eq. (10).)"]
[null,null,"E      =","Rf EO + RS ( 1 - EO )",null,null,null,"Efficiency of the grate.",null,null,null,null,null,null,null,"(HEC 12, eq. (11).)"]
[null,null,"Qi     =","Q [ Rf EO + RS ( 1 - EO ) ]",null,null,null,"Interception capacity of the inlet grate.",null,null,null,null,null,null,null,"(HEC 12, eq. (12).)"]
[]
[null,"Tabulated Data"]
[]
[null,null,"Region",null,"Input Data",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Flow and Gutter Spread",null,null,null,null,null,null,null,null,null,"Neenah Inlets",null,"Inlets on Grade"]
[null,null,null,null,"Drainage Area",null,null,null,null,null,null,null,"Grade",null,null,"Roadway Data",null,null,"Parameters",null,"Critical Point","Hydrological Data",null,null,null,null,null,"Spread Data",null,null,"Inlet \nCapacity \nFactor","Inlet \nCapacity","Ratio of Frontal Flow to Total Flow","Flow in the Gutter","Ratio of Frontal Flow Intercepted","Ratio of Side Flow Intercepted","Grate Efficiency","Inlet \nCapacity","By-Pass Flow"]
[null,null,null,null,"Begin Station","End Station","Length","Begin\nWidth","End\nWidth","Average\nWidth","Drainage\nArea",null,"Begin\nElevation","End\nElevation","Average\nLongitudinal\nGrade","Cross Slope","Curb Height","Distance from\nCurb to\nEdge of Lane","Roughness\nCoefficient","Runoff\nCoefficient",null,"Concentration\nTime","Rainfall\nIntensity","Drainage\nArea","Discharge","Previous\nDischarge","Total\nDischarge","Average\nLongitudinal\nGrade","Depth at Curb","Spread"]
[null,null,"Variable",null,null,null,"L","W1","W2","W","L W",null,null,null,null,"Sx",null,null,"n","C",null,"to","i","A","Q","Qp","Qt","s","d","SG","K","Qi","EO","V","Rf","RS","E","Qi","Q'"]
[null,null,"Units",null,null,null,"ft","ft","ft","ft","ft2","acres",null,null,"ft/ft","ft/ft","in","ft",null,null,null,"min","in/hr","acres","cfs","cfs","cfs","ft/ft","ft","ft",null,"cfs",null,"ft/s",null,null,null,"cfs","cfs"]
[]
[null,null,"Right shoulder of the Bridge - MOT Condition - Phase  2, No scuppers"]
[null,null,"From Begin of Rear AS to End of Fwd AS",null,20447.740000000002,{"$f":"20727.48+25","v":20752.48},{"$f":"ABS(E82-F82)","v":304.73999999999796},28,28,{"$f":"AVERAGE(H82:I82)","v":28},{"$f":"G82*J82","v":8532.719999999943},{"$f":"ROUND(K82*2.2957*10^-5,4)","v":0.19589999999999999},{"$f":"1126.26-(E82-20400)*0.0212","v":1125.247912},{"$f":"1126.26-(F82-20400)*0.0212","v":1118.7874240000001},{"$f":"ROUND((M82-N82)/G82,4)","v":2.12E-2},1.6E-2,6,{"$f":"2+5/8/12","v":2.0520833333333335},1.4999999999999999E-2,0.9,{"$f":"IF(M82=MIN(M82:N82),E82,F82)","v":20752.48},{"$f":"MAX(ROUND(1.8*(1.1-T82)*G82^(1/2)/(ABS(O82)*100)^(1/3),3),10)","v":10},{"$f":"ROUND($L$17/(V82+$L$18)^$L$19,3)","v":3.6819999999999999},{"$f":"L82","v":0.19589999999999999},{"$f":"ROUND(T82*W82*X82,3)","v":0.64900000000000002},0,{"$f":"SUM(Y82:Z82)","v":0.64900000000000002},{"$f":"ABS(O82)","v":2.12E-2},{"$f":"ROUND((AA82/(0.56*(1/P82)/S82*AB82^(1/2)))^(3/8),3)","v":9.6000000000000002E-2},{"$f":"(1/P82)*AC82","v":6},{"$f":"$D$41","v":35},{"$f":"AE82*AC82^(5/3)","v":0.70445528676335134},0,0,0,0,{"$f":"AI82*AG82+AJ82*(1-AG82)","v":0},{"$f":"AA82*(AI82*AG82+AJ82*(1-AG82))","v":0},{"$f":"AA82-AL82","v":0.64900000000000002}]
[]
[null,null,"Right shoulder of the Bridge - MOT Condition - Phase  2, with 18 inch (standard width) scuppers"]
[null,null,"From Begin of Rear AS to Scupper 1",null,20447.740000000002,{"$f":"E85+50","v":20497.740000000002},50,28,28,{"$f":"AVERAGE(H85:I85)","v":28},{"$f":"G85*J85","v":1400},{"$f":"ROUND(K85*2.2957*10^-5,4)","v":3.2099999999999997E-2},{"$f":"1126.26-(E85-20400)*0.0212","v":1125.247912},1124.1879119999999,{"$f":"ROUND((M85-N85)/G85,4)","v":2.12E-2},1.6E-2,6,{"$f":"2+5/8/12","v":2.0520833333333335},1.4999999999999999E-2,0.9,20497.740000000002,{"$f":"MAX(ROUND(1.8*(1.1-T85)*G85^(1/2)/(ABS(O85)*100)^(1/3),3),10)","v":10},{"$f":"ROUND($L$17/(V85+$L$18)^$L$19,3)","v":3.6819999999999999},{"$f":"L85","v":3.2099999999999997E-2},{"$f":"ROUND(T85*W85*X85,3)","v":0.106},0,{"$f":"SUM(Y85:Z85)","v":0.106},{"$f":"ABS(O85)","v":2.12E-2},{"$f":"ROUND((AA85/(0.56*(1/P85)/S85*AB85^(1/2)))^(3/8),3)","v":4.8000000000000001E-2},{"$f":"(1/P85)*AC85","v":3},{"$f":"$D$41","v":35},0.22188951112571878,{"$f":"MIN(1-(1-$D$45/AD85)^(8/3),1)","v":0.84250986876314082},{"$f":"AA85/(AC85*AD85/2)","v":1.4722222222222221},{"$f":"MIN(1-0.09*(AH85-$D$66),1)","v":1},{"$f":"MIN(1/(1+(0.15*AH85^1.8)/(P85*$D$47^2.3)),1)","v":1.0681781168717949E-2},{"$f":"AI85*AG85+AJ85*(1-AG85)","v":0.84419214388124564},8.9484367251412039E-2,1.6515632748587958E-2]
[null,null,"Scupper 1 to Scupper 2",null,{"$f":"F85","v":20497.740000000002},{"$f":"20548.74-10","v":20538.740000000002},41,28,28,{"$f":"AVERAGE(H86:I86)","v":28},{"$f":"G86*J86","v":1148},{"$f":"ROUND(K86*2.2957*10^-5,4)","v":2.64E-2},1124.1879119999999,1123.318712,{"$f":"ROUND((M86-N86)/G86,4)","v":2.12E-2},1.6E-2,6,{"$f":"2+5/8/12","v":2.0520833333333335},1.4999999999999999E-2,0.9,20538.740000000002,{"$f":"MAX(ROUND(1.8*(1.1-T86)*G86^(1/2)/(ABS(O86)*100)^(1/3),3),10)","v":10},{"$f":"ROUND($L$17/(V86+$L$18)^$L$19,3)","v":3.6819999999999999},{"$f":"L86","v":2.64E-2},{"$f":"ROUND(T86*W86*X86,3)","v":8.6999999999999994E-2},{"$f":"AM85","v":1.6515632748587958E-2},{"$f":"SUM(Y86:Z86)","v":0.10351563274858795},{"$f":"ABS(O86)","v":2.12E-2},{"$f":"ROUND((AA86/(0.56*(1/P86)/S86*AB86^(1/2)))^(3/8),3)","v":4.8000000000000001E-2},{"$f":"(1/P86)*AC86","v":3},{"$f":"$D$41","v":35},0.22188951112571878,{"$f":"MIN(1-(1-$D$45/AD86)^(8/3),1)","v":0.84250986876314082},1.4377171215081659,{"$f":"MIN(1-0.09*(AH86-$D$66),1)","v":1},{"$f":"MIN(1/(1+(0.15*AH86^1.8)/(P86*$D$47^2.3)),1)","v":1.1142464535584354E-2},{"$f":"AI86*AG86+AJ86*(1-AG86)","v":0.84426469696515205},8.7394594313642576E-2,1.6121038434945376E-2]
[null,null,"Scupper 2 to Scupper 3",null,{"$f":"F86","v":20538.740000000002},{"$f":"20614.54-10","v":20604.54},65.799999999999272,28,28,{"$f":"AVERAGE(H87:I87)","v":28},{"$f":"G87*J87","v":1842.3999999999796},{"$f":"ROUND(K87*2.2957*10^-5,4)","v":4.2299999999999997E-2},1123.318712,1121.9237519999999,2.12E-2,1.6E-2,6,2.0520833333333335,1.4999999999999999E-2,0.9,{"$f":"IF(M87=MIN(M87:N87),E87,F87)","v":20604.54},{"$f":"MAX(ROUND(1.8*(1.1-T87)*G87^(1/2)/(ABS(O87)*100)^(1/3),3),10)","v":10},{"$f":"ROUND($L$17/(V87+$L$18)^$L$19,3)","v":3.6819999999999999},{"$f":"L87","v":4.2299999999999997E-2},{"$f":"ROUND(T87*W87*X87,3)","v":0.14000000000000001},{"$f":"AM86","v":1.6121038434945376E-2},{"$f":"SUM(Y87:Z87)","v":0.1561210384349454},{"$f":"ABS(O87)","v":2.12E-2},{"$f":"ROUND((AA87/(0.56*(1/P87)/S87*AB87^(1/2)))^(3/8),3)","v":5.6000000000000001E-2},{"$f":"(1/P87)*AC87","v":3.5},{"$f":"$D$41","v":35},{"$f":"AE87*AC87^(5/3)","v":0.28688956766580104},{"$f":"MIN(1-(1-$D$45/AD87)^(8/3),1)","v":0.77514707739473077},{"$f":"AA87/(AC87*AD87/2)","v":1.593071820764749},{"$f":"MIN(1-0.09*(AH87-$D$66),1)","v":1},{"$f":"MIN(1/(1+(0.15*AH87^1.8)/(P87*$D$47^2.3)),1)","v":9.2808266614140371E-3},{"$f":"AI87*AG87+AJ87*(1-AG87)","v":0.77723389839374257},{"$f":"AA87*(AI87*AG87+AJ87*(1-AG87))","v":0.12134256332407194},{"$f":"AA87-AL87","v":3.4778475110873466E-2}]
[null,null,"Scupper 3 to Scupper 4",null,{"$f":"F87","v":20604.54},{"$f":"20680.35+10","v":20690.349999999999},{"$f":"ABS(E88-F88)","v":85.809999999997672},28,28,{"$f":"AVERAGE(H88:I88)","v":28},{"$f":"G88*J88","v":2402.6799999999348},{"$f":"ROUND(K88*2.2957*10^-5,4)","v":5.5199999999999999E-2},1121.9237519999999,1120.1045799999999,{"$f":"ROUND((M88-N88)/G88,4)","v":2.12E-2},1.6E-2,6,2.0520833333333335,1.4999999999999999E-2,0.9,{"$f":"IF(M88=MIN(M88:N88),E88,F88)","v":20690.349999999999},{"$f":"MAX(ROUND(1.8*(1.1-T88)*G88^(1/2)/(ABS(O88)*100)^(1/3),3),10)","v":10},{"$f":"ROUND($L$17/(V88+$L$18)^$L$19,3)","v":3.6819999999999999},{"$f":"L88","v":5.5199999999999999E-2},{"$f":"ROUND(T88*W88*X88,3)","v":0.183},{"$f":"AM87","v":3.4778475110873466E-2},{"$f":"SUM(Y88:Z88)","v":0.21777847511087345},{"$f":"ABS(O88)","v":2.12E-2},{"$f":"ROUND((AA88/(0.56*(1/P88)/S88*AB88^(1/2)))^(3/8),3)","v":6.3E-2},{"$f":"(1/P88)*AC88","v":3.9375},{"$f":"$D$41","v":35},{"$f":"AE88*AC88^(5/3)","v":0.34911536261485465},{"$f":"MIN(1-(1-$D$45/AD88)^(8/3),1)","v":0.72164598700257665},{"$f":"AA88/(AC88*AD88/2)","v":1.755835526215155},{"$f":"MIN(1-0.09*(AH88-$D$66),1)","v":1},{"$f":"MIN(1/(1+(0.15*AH88^1.8)/(P88*$D$47^2.3)),1)","v":7.8016655703922241E-3},{"$f":"AI88*AG88+AJ88*(1-AG88)","v":0.72381761192215921},{"$f":"AA88*(AI88*AG88+AJ88*(1-AG88))","v":0.15763189578280182},{"$f":"AA88-AL88","v":6.0146579328071631E-2}]
[null,null,"Scupper 4 to End of Fwd AS",null,{"$f":"F88","v":20690.349999999999},{"$f":"20727.48+25","v":20752.48},62.130000000001019,28,28,{"$f":"AVERAGE(H89:I89)","v":28},1739.6400000000285,{"$f":"ROUND(K89*2.2957*10^-5,4)","v":3.9899999999999998E-2},1120.1045799999999,1118.7874240000001,{"$f":"ROUND((M89-N89)/G89,4)","v":2.12E-2},1.6E-2,6,2.0520833333333335,1.4999999999999999E-2,0.9,20752.48,{"$f":"MAX(ROUND(1.8*(1.1-T89)*G89^(1/2)/(ABS(O89)*100)^(1/3),3),10)","v":10},{"$f":"ROUND($L$17/(V89+$L$18)^$L$19,3)","v":3.6819999999999999},{"$f":"L89","v":3.9899999999999998E-2},{"$f":"ROUND(T89*W89*X89,3)","v":0.13200000000000001},{"$f":"AM86","v":1.6121038434945376E-2},{"$f":"SUM(Y89:Z89)","v":0.1481210384349454},{"$f":"ABS(O89)","v":2.12E-2},{"$f":"ROUND((AA89/(0.56*(1/P89)/S89*AB89^(1/2)))^(3/8),3)","v":5.5E-2},{"$f":"(1/P89)*AC89","v":3.4375},{"$f":"$D$41","v":35},0.27840211281211402,{"$f":"MIN(1-(1-$D$45/AD89)^(8/3),1)","v":0.78323091475682516},1.5669002412952902,{"$f":"MIN(1-0.09*(AH89-$D$66),1)","v":1},{"$f":"MIN(1/(1+(0.15*AH89^1.8)/(P89*$D$47^2.3)),1)","v":9.5590317529563006E-3},{"$f":"AI89*AG89+AJ89*(1-AG89)","v":0.78530301732572394},0.11631989841238215,3.1801140022563248E-2]
[]
["NOTES"]
[null,"1.  Allowable Pavement spread was determined by adding 1 foot from the outside 11' lane + 2.05 foot shoulder = 3.05' total.  See L&D Volume 2, Section 1010.1 - must provide 10 foot minimum dry lanes during MOT."]
[]
[null,"Pier 1 Location  = 205+48.74"]
[null,"Pier 2 Location  = 206+14.54"]
[null,"Pier 3 Location  = 206+80.35"]

{"sheet":"MOT Phase 3 & 3A","index":2,"n_rows":59,"n_cols":30,"rows_kept":59,"cut":false,"hidden":false,"merged":[[45,10,45,11],[48,2,48,3],[51,2,51,3],[43,31,44,31],[43,21,43,26],[43,27,43,29],[43,30,44,30],[42,2,44,3],[42,4,42,19],[42,20,42,29],[42,30,42,36],[43,4,43,11],[43,12,43,14],[43,15,43,17],[43,18,43,19],[43,32,44,32],[43,33,44,33],[43,34,44,34],[43,35,44,35],[43,36,44,36],[43,20,44,20],[44,10,44,11],[3,13,3,15],[4,13,4,15],[5,13,5,15],[6,13,6,15]]}
[null,"BARR & PREVOST"]
[]
[]
[null,"Calculated:","NCM",null,null,"Date:","2016-03-01",null,null,null,null,null,"Stage Review Submission:","Stage 1"]
[null,"Checked:",null,null,null,"Date:",null,null,null,null,null,null,"PID/Job No.:",99626]
[null,"Concurred:",null,null,null,"Date:",null,null,null,null,null,null,"Bridge No.:","MAH-76K-1482"]
[null,"Back Checked:",null,null,null,"Date:",null,null,null,null,null,null,"SFN:",5029784]
[null,"Released:",null,null,null,"Date:"]
[null,"Project:","MAH-164/626-4.85/1.05"]
[null,"Subject:","Spread check for MOT condition, Phase 2 on proposed structure"]
[null,null,null,null,null,null,null,null,null,null,null,null,"(Input values are shown underlined and in italics.)"]
[null,null,null,null,null,null,null,null,null,null,null,null,"References"]
["Drainage and Gutter Spread Calculations"]
[]
[null,"General Data"]
[]
[null,null,"Zone",null,"c",null,null,null,"(Fig. 1101-3)",null,"a",{"$f":"IF($E$17=\"A\",VLOOKUP($E$18,Tables!ZoneA,2),IF($E$17=\"B\",VLOOKUP($E$18,Tables!ZoneB,2),IF($E$17=\"C\",VLOOKUP($E$18,Tables!ZoneC,2),IF($E$17=\"D\",VLOOKUP($E$18,Tables!ZoneD,2)))))","v":56.298999999999999}]
["MOT",null,"Return",null,2,"yrs",{"$f":"IF(E18=10,\"Freeways\",IF(E18=5,\"High volume highways.\",IF(E18=2,\"All other highways.\",\"Check frequency.\")))","v":"All other highways."},null,"(1103.2)",null,"b",{"$f":"IF($E$17=\"A\",VLOOKUP($E$18,Tables!ZoneA,3),IF($E$17=\"B\",VLOOKUP($E$18,Tables!ZoneB,3),IF($E$17=\"C\",VLOOKUP($E$18,Tables!ZoneC,3),IF($E$17=\"D\",VLOOKUP($E$18,Tables!ZoneD,3)))))","v":10}]
[null,null,"Pvmt. Spread",null,1,"Max. Allow.",null,null,"(1103.2)",null,"c",{"$f":"IF($E$17=\"A\",VLOOKUP($E$18,Tables!ZoneA,4),IF($E$17=\"B\",VLOOKUP($E$18,Tables!ZoneB,4),IF($E$17=\"C\",VLOOKUP($E$18,Tables!ZoneC,4),IF($E$17=\"D\",VLOOKUP($E$18,Tables!ZoneD,4)))))","v":0.876}]
[]
[null,null,"Vertical Curve 1"]
[null,null,null,"PVI-1",null,"L","G1","G2","e"]
[null,null,null,"Station","Elev.",null,"Back","Ahead"]
[null,null,null,59953.84,728.75,900,1.5100000000000001E-2,-1.52E-2,{"$f":"(H24-G24)*F24/8","v":-3.4087499999999999}]
[]
[null,null,null,"PVC-1",null,"PVT-1",null,{"$f":"IF(H24-G24<0,\"High Point\",IF(H24-G24>0,\"Low Point\",\"\"))","v":"High Point"}]
[null,null,null,"Station","Elev.","Station","Elev.","Station","Elev."]
[null,null,null,{"$f":"(D24-F24/2)","v":59503.839999999997},{"$f":"(E24-G24*F24/2)","v":721.95500000000004},{"$f":"(D24+F24/2)","v":60403.839999999997},{"$f":"(E24+H24*F24/2)","v":721.91},{"$f":"IF(AND(G24>0,H24>0),F28,IF(AND(G24<0,H24<0),D28,D28+F24*G24/-(H24-G24)))","v":59952.354851485143},{"$f":"IF(H28<$D$28,$E$28+$G$24*(H28-$D$28),IF(AND(H28>=$D$28,H28<=$F$28),$E$28+$G$24*(H28-$D$28)+$I$24*((H28-$D$28)/$F$24*2)^2,IF(AND(H28>$F$28,H28<$K$28),$E$24+$H$24*(H28-$D$24),IF(AND(H28>=$K$28,H28<=$M$28),$L$28+$N$24*(H28-$K$28)+$P$24*((H28-$K$28)/$M$24*2)^2,$L$24+$O$24*(H28-$K$24)))))","v":725.34128712871291}]
[]
[null,"General Formulae"]
[]
[null,null,"Hydrology"]
[null,null,"to       =","1.8 ( 1.1 - C ) L1/2 / s1/3  ≥ 10 min  where \"s\" is in percent"]
[null,null,"i        =","a / ( t + b )c"]
[null,null,"Q      =","C i A"]
[null,null,"Z       =","1 / Cross Slope"]
[null,null,"Q      =","0.56 ( Z / n ) s1/2 d8/3  for triangular channel flow."]
[null,null,"d       =","{ Q / [ 0.56 ( Z / n ) s1/2 ] }3/8  where \"s\" is in ft/ft"]
[null,null,"SG     =","Z d"]
[]
[null,"Tabulated Data"]
[]
[null,null,"Region",null,"Input Data",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Flow and Gutter Spread"]
[null,null,null,null,"Drainage Area",null,null,null,null,null,null,null,"Grade",null,null,"Roadway Data",null,null,"Parameters",null,"Critical Point","Hydrological Data",null,null,null,null,null,"Spread Data"]
[null,null,null,null,"Begin Station","End Station","Length","Begin\nWidth","End\nWidth","Average\nWidth","Drainage\nArea",null,"Begin\nElevation","End\nElevation","Average\nLongitudinal\nGrade","Cross Slope","Curb Height","Distance from\nCurb to\nEdge of Lane","Roughness\nCoefficient","Runoff\nCoefficient",null,"Concentration\nTime","Rainfall\nIntensity","Drainage\nArea","Discharge","Previous\nDischarge","Total\nDischarge","Average\nLongitudinal\nGrade","Depth at Curb","Spread"]
[null,null,"Variable",null,null,null,"L","W1","W2","W","L W",null,null,null,null,"Sx",null,null,"n","C",null,"to","i","A","Q","Qp","Qt","s","d","SG"]
[null,null,"Units",null,null,null,"ft","ft","ft","ft","ft2","acres",null,null,"ft/ft","ft/ft","in","ft",null,null,null,"min","in/hr","acres","cfs","cfs","cfs","ft/ft","ft","ft"]
[null,null,"Median Side of the Bridge Forward - MOT Condition, Phase 3 and 3A"]
[null,null,"From High Point to End FWD AS",null,{"$f":"H28","v":59952.354851485143},{"$f":"60114.46","v":60114.46},{"$f":"ABS(E49-F49)","v":162.10514851485641},13.75,13.75,13.75,{"$f":"G49*J49","v":2228.9457920792756},{"$f":"ROUND(K49*2.2957*10^-5,4)","v":5.1200000000000002E-2},{"$f":"ROUND(IF(E49<$D$28,$E$28+$G$24*(E49-$D$28),IF(AND(E49>=$D$28,E49<=$F$28),$E$28+$G$24*(E49-$D$28)+$I$24*((E49-$D$28)/$F$24*2)^2,IF(AND(E49>$F$28,E49<$K$28),$E$24+$H$24*(E49-$D$24),IF(AND(E49>=$K$28,E49<=$M$28),$L$28+$N$24*(E49-$K$28)+$P$24*((E49-$K$28)/$M$24*2)^2,$L$24+$O$24*(E49-$K$24))))),3)","v":725.34100000000001},724.899,{"$f":"ROUND((M49-N49)/G49,4)","v":2.7000000000000001E-3},0.04,6,1.5,1.4999999999999999E-2,0.9,{"$f":"IF(M49=MIN(M49:N49),E49,F49)","v":60114.46},{"$f":"MAX(ROUND(1.8*(1.1-T49)*G49^(1/2)/(ABS(O49)*100)^(1/3),3),10)","v":10},{"$f":"ROUND($L$17/(V49+$L$18)^$L$19,3)","v":4.0810000000000004},{"$f":"L49","v":5.1200000000000002E-2},{"$f":"ROUND(T49*W49*X49,3)","v":0.188},0,{"$f":"SUM(Y49:Z49)","v":0.188},{"$f":"ABS(O49)","v":2.7000000000000001E-3},{"$f":"ROUND((AA49/(0.56*(1/P49)/S49*AB49^(1/2)))^(3/8),3)","v":0.125},{"$f":"(1/P49)*AC49","v":3.125}]
[]
[null,null,"Median Side of the Bridge Back - MOTCondition, Phase 3 & 3A"]
[null,null,"HP Bk to Begin of Rear A.S.",null,{"$f":"H28","v":59952.354851485143},59750.55,{"$f":"ABS(F52-E52)","v":201.80485148513981},13.75,13.75,13.75,{"$f":"G52*J52","v":2774.8167079206723},{"$f":"ROUND(K52*2.2957*10^-5,4)","v":6.3700000000000007E-2},{"$f":"ROUND(IF(E52<$D$28,$E$28+$G$24*(E52-$D$28),IF(AND(E52>=$D$28,E52<=$F$28),$E$28+$G$24*(E52-$D$28)+$I$24*((E52-$D$28)/$F$24*2)^2,IF(AND(E52>$F$28,E52<$K$28),$E$24+$H$24*(E52-$D$24),IF(AND(E52>=$K$28,E52<=$M$28),$L$28+$N$24*(E52-$K$28)+$P$24*((E52-$K$28)/$M$24*2)^2,$L$24+$O$24*(E52-$K$24))))),3)","v":725.34100000000001},724.65599999999995,{"$f":"ROUND((M52-N52)/G52,4)","v":3.3999999999999998E-3},0.04,6,1.5,1.4999999999999999E-2,0.9,{"$f":"F52","v":59750.55},{"$f":"MAX(ROUND(1.8*(1.1-T52)*G52^(1/2)/(ABS(O52)*100)^(1/3),3),10)","v":10},{"$f":"ROUND($L$17/(V52+$L$18)^$L$19,3)","v":4.0810000000000004},{"$f":"L52","v":6.3700000000000007E-2},{"$f":"ROUND(T52*W52*X52,3)","v":0.23400000000000001},0,{"$f":"SUM(Y52:Z52)","v":0.23400000000000001},{"$f":"ABS(O52)","v":3.3999999999999998E-3},{"$f":"ROUND((AA52/(0.56*(1/P52)/S52*AB52^(1/2)))^(3/8),3)","v":0.13},{"$f":"(1/P52)*AC52","v":3.25}]
[]
[]
[]
["NOTES"]
[null,"1. Bridge dimensions and  vertical curve data used from proposed plans.  "]
[null,"2. No scuppers required for FINAL condition."]
[null,"3.  Allowable Pavement spread was determined by adding 1 foot from the outside 11' lane + 1.5 foot shoulder = 2.5' total.  See L&D Volume 2, Section 1010.1 - must provide 10 foot minimum dry lanes."]

{"sheet":"Tables","index":3,"n_rows":26,"n_cols":14,"rows_kept":26,"cut":false,"hidden":false,"merged":[[20,9,25,9],[14,9,19,9],[8,9,13,9],[2,9,7,9]]}
[null,null,null,null,null,null,null,null,null,"(L&D, Vol. 2, General Notes - Figs. 1101-2 through 1101-3)"]
[null,null,null,null,null,null,null,null,null,"Zone","Freq.","a","b","c"]
[null,null,null,null,null,null,null,null,null,"A",2,46.183999999999997,9,0.85899999999999999]
[null,null,null,null,null,null,null,null,null,null,5,56.984999999999999,10.25,0.85099999999999998]
[null,null,null,null,null,null,null,null,null,null,10,64.167000000000002,11,0.84199999999999997]
[null,null,null,null,null,null,null,null,null,null,25,66.528000000000006,11,0.81100000000000005]
[null,null,null,null,null,null,null,null,null,null,50,65.701999999999998,10.75,0.78200000000000003]
[null,null,null,null,null,null,null,null,null,null,100,64.489000000000004,10.5,0.754]
[null,null,null,null,null,null,null,null,null,"B",2,47.987000000000002,9,0.85899999999999999]
[null,null,null,null,null,null,null,null,null,null,5,60.683999999999997,10.5,0.85799999999999998]
[null,null,null,null,null,null,null,null,null,null,10,73.126000000000005,12,0.86299999999999999]
[null,null,null,null,null,null,null,null,null,null,25,75.840999999999994,12,0.83299999999999996]
[null,null,null,null,null,null,null,null,null,null,50,65.620999999999995,10,0.78100000000000003]
[null,null,null,null,null,null,null,null,null,null,100,85.046999999999997,13.25,0.80600000000000005]
[null,null,null,null,null,null,null,null,null,"C",2,56.298999999999999,10,0.876]
[null,null,null,null,null,null,null,null,null,null,5,67.933000000000007,11,0.86899999999999999]
[null,null,null,null,null,null,null,null,null,null,10,84.55,13,0.88200000000000001]
[null,null,null,null,null,null,null,null,null,null,25,95.736000000000004,14,0.871]
[null,null,null,null,null,null,null,null,null,null,50,96.783000000000001,14,0.85]
[null,null,null,null,null,null,null,null,null,null,100,80.436000000000007,11.5,0.79400000000000004]
[null,null,null,null,null,null,null,null,null,"D",2,57.448,10,0.876]
[null,null,null,null,null,null,null,null,null,null,5,67.933000000000007,11,0.86899999999999999]
[null,null,null,null,null,null,null,null,null,null,10,79.191999999999993,12,0.86399999999999999]
[null,null,null,null,null,null,null,null,null,null,25,87.885999999999996,12.75,0.84899999999999998]
[null,null,null,null,null,null,null,null,null,null,50,95.168999999999997,13.5,0.83899999999999997]
[null,null,null,null,null,null,null,null,null,null,100,91.981999999999999,13,0.81]