{"text_format":"1","workbook":"xlsx","n_sheets":3,"sheets":["Bridge Approach Calc Info","Rt. Skewed Bridge","Lt. Skewed Bridge"],"not_rendered":{"charts":0,"images":7,"macros":1,"external_links":0,"defined_names":0,"comments":2,"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":"Bridge Approach Calc Info","index":0,"n_rows":76,"n_cols":36,"rows_kept":76,"cut":false,"hidden":false,"merged":[[42,34,43,34],[18,3,18,19],[20,3,20,4],[20,5,20,8],[18,24,18,35],[20,13,20,16],[37,8,37,14],[34,7,35,10],[22,30,23,32],[23,8,23,9],[34,14,34,15],[35,14,35,15],[27,34,28,34],[24,30,25,30],[39,30,40,30],[27,33,28,33],[27,32,28,32],[42,33,43,33],[37,30,38,32],[32,13,32,14],[39,8,39,10],[40,8,40,10],[38,8,38,10],[41,8,41,10],[58,6,59,7],[44,8,44,10],[43,8,43,10],[47,8,47,10],[48,8,48,10],[42,31,43,31],[42,32,43,32],[42,8,42,10],[57,10,59,12],[57,13,57,18],[58,14,59,14],[45,8,45,10],[46,8,46,10],[58,8,59,9],[57,4,57,9],[58,4,59,4],[58,5,59,5],[58,17,59,18],[58,13,59,13],[64,4,64,5],[64,13,64,14],[64,15,64,16],[64,17,64,18],[64,6,64,7],[64,8,64,9],[61,15,61,16],[58,15,59,16],[27,31,28,31],[62,15,62,16],[62,17,62,18],[63,15,63,16],[63,17,63,18],[56,3,56,19],[63,6,63,7],[60,8,60,9],[61,8,61,9],[62,8,62,9],[63,8,63,9],[60,6,60,7],[61,6,61,7],[62,6,62,7],[60,15,60,16],[60,17,60,18],[67,34,67,35],[68,34,68,35],[69,34,69,35],[69,32,69,33],[61,17,61,18],[67,32,67,33],[68,32,68,33],[68,25,68,26],[68,29,68,31],[69,25,69,26],[69,29,69,31],[67,29,67,31],[68,27,68,28],[69,27,69,28],[75,25,75,26],[75,27,75,28],[71,25,71,28],[74,25,74,26],[74,27,74,28],[73,25,73,26],[73,27,73,28],[72,25,72,26],[72,27,72,28],[65,4,65,5],[65,6,65,7],[65,8,65,9],[66,4,66,5],[66,6,66,7],[66,13,66,14],[65,13,65,14],[65,17,65,18],[66,17,66,18],[65,15,65,16],[66,15,66,16],[70,8,70,9],[71,8,71,9],[68,14,68,15],[69,14,69,15],[70,14,70,15],[71,14,71,15],[67,10,68,10],[67,11,67,12],[66,8,66,9]]}
[null,"RK-20","Joint Locations (Section Thru Centerline), Subdrain Location (Detail C), Bridge End Post Details (Detail D & E), Modified Subbase and Polymer Grid Dimensions (Section Thru Centerline & Section A-A)"]
[null,"RK-21","Plan View of Bridge Approach for Abutting PCC or Composite Pavement"]
[null,"RK-22","Plan View of Bridge Approach for Abutting HMA Pavement"]
[null,"RK-23","Plan View of Bridge Approach for Multi-Lane, Curbed Roadway, Modified Subbase and Polymer Grid Dimensions"]
[null,"RF-38","Intake for Bridge End Drains, Panel Locations Shown"]
[null,"RF-39","Scour Protection for Bridge End Drain, Panel Locations Shown"]
[null,"RF-40","Rock Flume for Bridge End Drain, Panel Locations Shown"]
[]
[null,"Tab 112-6","Bridge Approach Section"]
[null,"Tab 104-8","Bridge End Drains"]
[null,"Tab 104-8A","Scour Protection or Rock Flume for Bridge End Drain"]
[]
[null,"Program Last Revised: 07-03-2012"]
[]
[]
[]
[]
[]
[null,null,null,"Bridge Approach Calculations (ENGLISH)",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Modified Subbase"]
[null,null,null,{"$f":"CELL(\"filename\")","v":"c:\\pw_work\\pwmain\\kbell\\d0797717\\[06030230C01.xlsm]PrintSheets"}]
[null,null,null,"Bridge Station:",null,null,null,null,null,"EBL\\NBL",null,"Lt","Rt","Is Abutment Moveable?",null,null,null,"Y","Y/N"]
[null,null,null,null,null,null,"Skew Angle",null,null,20]
[null,null,null,null,null,null,null,null,null,null,"Skew L:",{"$f":"DEGREES(ATAN((I24-I33)/(D27+D28+D29+D30)))","v":20},{"$f":"ABS(DEGREES(ATAN((O24-N33)/(T27+T28+T29+T30))))","v":20},"deg.",null,null,null,null,null,null,null,null,null,null,null,{"$f":"I33+(L25*(D30+D29))","v":23.007345153856452},{"$f":"H24","v":20},{"$f":"G24","v":20},{"$f":"F24","v":10},null,"Length of bridge end post (m)",null,null,"Upper Lt.","Lower Lt."]
[null,null,null,null,null,10,20,20,{"$f":"(TAN(J22*PI()/180)*(D27+D28+D29+D30))+I33","v":31.014690307712904},{"$f":"TAN(#REF!*PI()/180)*(D20+D21)","v":{"$error":"#REF!"}},null,null,null,{"$f":"TAN(J22*PI()/180)*(T27+T28)","v":7.2794046853240468},{"$f":"IF(N24<5,20-N24,15)","v":15},20,20,10,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"L36","v":7},{"$f":"N36","v":7}]
[null,null,null,null,null,null,null,null,null,null,"Slope:",{"$f":"(I24-I33)/(D27+D28+D29+D30)","v":0.36397023426620234},{"$f":"(N33-O24)/(T27+T28+T29+T30)","v":0.36397023426620234},"Ft/Ft",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"End Depth (ft)","1st","2nd","3rd","4th","5th"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,2,{"$f":"(2-Z23/AB35)","v":1.6348466183160828},{"$f":"(2-(Z23+AA23)/AB35)","v":1.3174233091580414},1,1]
[null,null,null,8,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,8]
[null,null,null,14,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,12,null,null,null,null,null,null,null,null,null,null,null,"Avg. Depth (ft)","Area (ft2)","Volume (ft3)","Qty. (Tons)"]
[null,null,null,14,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,14]
[null,null,null,8,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,8,null,null,null,null,null,null,null,null,null,null,"A1",{"$f":"(AF26+AG26)/2","v":1.8174233091580414},{"$f":"(((($I$24+$I$33)/2)+2)*(SUM($D$27:$D$30)+6))-(($N$36+$L$36)*((6/12)+2))","v":1215.3672576928227},{"$f":"IF(R21=\"y\",AF30*AG30-1*(D27+D28+D29+D30+2),AF30*AG30)","v":2162.8367833184238},{"$f":"AH30*140/2000","v":151.39857483228965}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"A2",{"$f":"(AG26+AH26)/2","v":1.4761349637370622},{"$f":"((($H$24+$H$33)/2)-2)*(SUM($D$28:$D$29)+4)","v":576},{"$f":"AF31*AG31","v":850.25373911254781},{"$f":"AH31*140/2000","v":59.517761737878345}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"A3",{"$f":"(AH26+AI26)/2","v":1.1587116545790206},{"$f":"(((G24+G33)/2))*(SUM(D28:D29)+4)","v":640},{"$f":"AF32*AG32","v":741.57545893057318},{"$f":"AH32*140/2000","v":51.910282125140128}]
[null,null,null,null,null,10,20,20,{"$f":"IF(J33<5,20-J33,15)","v":15},{"$f":"TAN(J22*PI()/180)*(D29+D30)","v":8.007345153856452},null,null,null,{"$f":"(TAN(J22*PI()/180)*(T27+T28+T29+T30))+O24","v":30.286749839180498},{"$f":"TAN(#REF!*PI()/180)*(I29+I30)","v":{"$error":"#REF!"}},20,20,10,null,null,null,null,null,null,null,null,null,null,null,null,"A4",{"$f":"(AI26+AJ26)/2","v":1},{"$f":"(((F24+F33)/2))*(SUM(D28:D29)+4)","v":320},{"$f":"AF33*AG33","v":320},{"$f":"AH33*140/2000","v":22.4}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Totals:",{"$f":"SUM(AG30:AG33)","v":2751.3672576928229},{"$f":"SUM(AH30:AH33)","v":4074.6659813615452},{"$f":"SUM(AI30:AI33)","v":285.2266186953081}]
[null,null,null,null,null,null,null,"Wing Wall and Transition Length (ft)",null,null,null,"Upper Lt.","Upper Rt.","Lower Lt.","Lower Rt.",null,null,null,null,null,null,null,null,null,null,null,"Slope:",{"$f":"(Z23+AA23+AB23)/1","v":63.007345153856448},":1"]
[null,null,null,null,null,null,null,null,null,null,null,7,7,7,7]
[]
[null,null,null,null,null,null,null,null,"Approach Quantities (Tab 112-6)",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"(M25*(T27+T28))+O24","v":22.279404685324046},{"$f":"P24","v":20},{"$f":"Q24","v":20},{"$f":"R24","v":10},null,"Length of bridge end post (m)",null,null,"Upper Rt.","Lower Rt."]
[null,null,null,null,null,null,null,null,"Item",null,null,"Left","Right","Total",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"M36","v":7},{"$f":"O36","v":7}]
[null,null,null,null,null,null,null,null,"Pay Length",null,null,{"$f":"(ABS($I$33-$I$24)*((SUM($D$29:D$30)/SUM($D$27:$D$30)))+I33)+SUM(F33:H33)","v":73.007345153856448},{"$f":"(ABS($N$33-$O$24)*((SUM($T$27:T$28)/SUM($T$27:$T$30)))+O24)+SUM(P24:R24)","v":72.279404685324039},{"$f":"L40+M40","v":145.28674983918049},"ft",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"End Depth (ft)","1st","2nd","3rd","4th","5th"]
[null,null,null,null,null,null,null,null,"Double Reinforced Approach",null,null,{"$f":"(((($I$24+$I$33)/2)*(SUM($D$27:$D$30)+2))-(($N$36+$L$36)*((6/12)+2)))/9","v":113.70420856415519},{"$f":"(((($O$24+$N$33)/2)*((SUM($T$27:$T$30)+2))-(($O$36+$M$36)*((6/12)+2))))/9","v":106.81205516244123},220.51626372659643,"yd2",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,2,{"$f":"(2-Z38/AB51)","v":1.6422668970923204},{"$f":"(2-(Z38+AA38)/AB51)","v":1.3211334485461603},1,1]
[null,null,null,null,null,null,null,null,"Single Reinforced Approach",null,null,{"$f":"((H24+H33)/2)*(D28+D29)/9","v":62.222222222222221},{"$f":"((P24+P33)/2)*(T28+T29)/9","v":57.777777777777779},120,"yd2"]
[null,null,null,null,null,null,null,null,"Non-Reinforced Approach",null,null,{"$f":"((G33+F33+G24+F24)/2)*(D28+D29)/9","v":93.333333333333329},{"$f":"((Q24+R24+Q33+R33)/2)*(T28+T29)/9","v":86.666666666666671},180,"yd2",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Avg. Depth (ft)","Area (ft2)","Volume (ft3)","Qty. (Tons)"]
[null,null,null,null,null,null,null,null,"Polymer Grid",null,null,{"$f":"SUM(AG30:AG33)/9","v":305.70747307698031},{"$f":"SUM(AG45:AG48)/9","v":287.54244401559242},593.24991709257279,"yd2"]
[null,null,null,null,null,null,null,null,"Modified Subbase",null,null,{"$f":"AI34","v":285.2266186953081},{"$f":"AI49","v":269.00330982289313},554.22992851820118,"Tons",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"A1",{"$f":"(AF41+AG41)/2","v":1.8211334485461603},{"$f":"(((($O$24+$N$33)/2)+2))*((SUM($T$27:$T$30)+6))-(($O$36+$M$36)*((6/12)+2))","v":1147.8819961403319},{"$f":"IF(R21=\"y\",AF45*AG45-1*(T27+T28+T29+T30+2),AF45*AG45)","v":2046.4462981550928},{"$f":"AH45*140/2000","v":143.25124087085649}]
[null,null,null,null,null,null,null,null,"Pannel Quantities:",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"A2",{"$f":"(AG41+AH41)/2","v":1.4817001728192403},{"$f":"(((P24+P33)/2)-2)*(SUM(T28:T29)+4)","v":540},{"$f":"AF46*AG46","v":800.11809332238977},{"$f":"AH46*140/2000","v":56.008266532567283}]
[null,null,null,null,null,null,null,null,"Paved Shoulder",null,null,{"$f":"+I65","v":44.444444444444443},{"$f":"R65","v":44.444444444444443},{"$f":"L47+M47","v":88.888888888888886},"yd2",null,null," - User Input",null,null,null,null,null,null,null,null,null,null,null,null,"A3",{"$f":"(AH41+AI41)/2","v":1.1605667242730802},{"$f":"((Q24+Q33)/2)*(SUM(T28:T29)+4)","v":600},{"$f":"AF47*AG47","v":696.34003456384812},{"$f":"AH47*140/2000","v":48.743802419469368}]
[null,null,null,null,null,null,null,null,"Modified Subbase",null,null,{"$f":"G65","v":41.331778984637744},{"$f":"P65","v":41.487604838938729},{"$f":"L48+M48","v":82.819383823576473},"Tons",null,null," - Calculation (Locked)",null,null,null,null,null,null,null,null,null,null,null,null,"A4",{"$f":"(AI41+AJ41)/2","v":1},{"$f":"((R24+R33)/2)*(SUM(T28:T29)+4)","v":300},{"$f":"AF48*AG48","v":300},{"$f":"AH48*140/2000","v":21}]
[null,null,null,"Tips for Use:",null,null,null,null,"Polymer Grid",null,null,{"$f":"I65","v":44.444444444444443},{"$f":"R65","v":44.444444444444443},{"$f":"L49+M49","v":88.888888888888886},"yd2",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Totals:",{"$f":"SUM(AG45:AG48)","v":2587.8819961403319},{"$f":"SUM(AH45:AH48)","v":3842.9044260413311},{"$f":"SUM(AI45:AI48)","v":269.00330982289313}]
[null,null,null,"1)  Fill in dimensions in feet.",null,null,null,null,null,null,null,null,null,null,null,null,null," - Non-Reinforced Section"]
[null,null,null,"2)  Calculated quantities include 4\" sloped curb.",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Slope:",{"$f":"(Z38+AA38+AB38)/1","v":62.279404685324046},":1"]
[null,null,null,"3)  All values based on Standard Road Plan RK-20(1-3)",null,null,null,null,null,null,null,null,null,null,null,null,null," - Single Reinforced Section"]
[]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null," - Double Reinforced Section"]
[]
[]
[null,null,null,"Paved Shoulder Panels for Sod Flume or Bridge End Drain (See Standard Road Plans RF-38, RF-39, & RF-40 as well as Tabs 104-8 and 104-8A)"]
[null,null,null,null,"Lt. Side",null,null,null,null,null,"1Not a Bid Item",null,null,"Rt. Side"]
[null,null,null,null,"Req'd Panel","Y/N","1Modified Subbase(Ton)",null,"1Polymer Grid (yd2)",null,null,null,null,"Req'd Panel","Y/N","1Modified Subbase(Ton)",null,"1Polymer Grid (Yd2)"]
[]
[null,null,null,null,"A","Y",{"$f":"I61*AF31*9*140/2000","v":20.665889492318872},null,{"$f":"IF($F$61=\"y\",$H$24*($D$27+2),0)/9","v":22.222222222222221},null,null,null,null,"A","Y",{"$f":"R61*AF46*9*140/2000","v":20.743802419469365},null,{"$f":"IF($O$61=\"y\",$P$33*($T$30+2),0)/9","v":22.222222222222221}]
[null,null,null,null,"B","Y",{"$f":"I62*AF31*9*140/2000","v":20.665889492318872},null,{"$f":"IF($F$62=\"y\",$H$33*($D$30+2),0)/9","v":22.222222222222221},null,null,null,null,"B","Y",{"$f":"R62*AF46*9*140/2000","v":20.743802419469365},null,{"$f":"IF($O$62=\"y\",$P$24*($T$27+2),0)/9","v":22.222222222222221}]
[null,null,null,null,"C",null,{"$f":"I63*AF32*9*140/2000","v":0},null,{"$f":"IF($F$63=\"y\",($D$30+2)*$G$33,0)/9","v":0},null,null,null,null,"C",null,{"$f":"R63*AF47*9*140/2000","v":0},null,{"$f":"IF($O$63=\"y\",$Q$24*($T$27+2),0)/9","v":0}]
[null,null,null,null,"D",null,{"$f":"I64*AF32*9*140/2000","v":0},null,{"$f":"IF($F$64=\"y\",$G$24*(2+$D$27),0)/9","v":0},null,null,null,null,"D",null,{"$f":"R64*AF47*9*140/2000","v":0},null,{"$f":"IF($O$64=\"y\",$Q$33*($T$30+2),0)/9","v":0}]
[null,null,null,null,"Total:",null,{"$f":"SUM(G61:H64)","v":41.331778984637744},null,{"$f":"SUM(I61:J64)","v":44.444444444444443},null,null,null,null,"Total:",null,{"$f":"SUM(P61:Q64)","v":41.487604838938729},null,{"$f":"SUM(R61:S64)","v":44.444444444444443}]
[null,null,null,null,"B+C=",null,{"$f":"+G62+G63","v":20.665889492318872},null,{"$f":"+I62+I63","v":22.222222222222221},null,null,null,null,"B+C=",null,{"$f":"+P62+P63","v":20.743802419469365},null,{"$f":"+R62+R63","v":22.222222222222221}]
[null,null,null,null,"A+D= ",null,{"$f":"+G61+G64","v":20.665889492318872},null,{"$f":"+I61+I64","v":22.222222222222221},null,null,null,null,"A+D= ",null,{"$f":"+P61+P64","v":20.743802419469365},null,{"$f":"+R61+R64","v":22.222222222222221}]
[null,null,null,null,null,null,null,null,null,null,"Panel","Area (yd2)",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Subdrain Outlet Location",null,null,"4\" Subdrain",null,"Porous Backfill"]
[null,null,null,null,null,null,null,null,null,null,null,"Lt. Side","Rt. Side",null,null,null,null,null,null,null,null,null,null,null,null,"Begin Bridge Station",null,{"$f":"49316.5-1.5","v":49315},null,{"$f":"+AB69-(ABS(I33-I24)*(SUM(D29:D30)/SUM(D27:D30))+I33)-SUM(G33:H33)","v":49251.992654846144},null,null,{"$f":"ROUNDUP(SUM(D28:D30)+(2.75*6)+((3/12)*6)+(IF($F$61=\"y\",+D27,0)+10),0)","v":72},{"$f":"ROUNDUP(SUM(#REF!)+(2.75*6)+((3/12)*6)+10,0)","v":{"$error":"#REF!"}},{"$f":"ROUNDUP((2.667*AG69)*120/2000,0)","v":12}]
[null,null,null,null,null,null,null,null,null,null,"A",{"$f":"IF($F$61=\"y\",($H$24*($D$27+2))/9,0)","v":22.222222222222221},{"$f":"IF($O$61=\"y\",(($P$33)*($T$30+2)/9),0)","v":22.222222222222221},null,null,null,null,null,null,null,null,null,null,null,null,"End Bridge Station",null,{"$f":"49446.5+1.5","v":49448},null,{"$f":"+AB70+(ABS(N33-O24)*(SUM(T27:T28)/SUM(T27:T30))+O24)+SUM(P24:Q24)","v":49510.279404685323},null,null,{"$f":"ROUNDUP(SUM(T28:T30)+(2.75*6)+((3/12)*6)+(IF($O$61=\"y\",+T27,0)+10),0)","v":70},{"$f":"ROUNDUP(SUM(#REF!)+(2.75*6)+((3/12)*6)+10,0)","v":{"$error":"#REF!"}},{"$f":"ROUNDUP((2.667*AG70)*120/2000,0)","v":12}]
[null,null,null,null,null,null,null,"B+C=",{"$f":"+L71+L72","v":22.222222222222221},null,"B",{"$f":"IF($F$62=\"y\",($H$33*($D$30+2))/9,0)","v":22.222222222222221},{"$f":"IF($O$62=\"y\",($P$24*($T$27+2)/9),0)","v":22.222222222222221},"B+C=",{"$f":"+M71+M72","v":22.222222222222221}]
[null,null,null,null,null,null,null,"A+D=",{"$f":"+L70+L73","v":22.222222222222221},null,"C",{"$f":"IF($F$63=\"y\",($D$30*($G$33+2)/9),0)","v":0},{"$f":"IF($O$63=\"y\",($Q$24*($T$27+2)/9),0)","v":0},"A+D=",{"$f":"+M70+M73","v":22.222222222222221},null,null,null,null,null,null,null,null,null,null,"Longitudinal Grooving"]
[null,null,null,null,null,null,null,null,null,null,"D",{"$f":"IF($F$64=\"y\",($G$24*($D$27+2)),0)","v":0},{"$f":"IF($O$64=\"y\",($Q$33*($T$30+2)/9),0)","v":0},null,null,null,null,null,null,null,null,null,null,null,null,"Begin Bridge Approach",null,{"$f":"SUM(L41:L43)","v":269.25976411971072}]
[null,null,null,null,null,null,null,null,null,null,"Total:",{"$f":"SUM(L70:L73)","v":44.444444444444443},{"$f":"SUM(M70:M73)","v":44.444444444444443},null,null,null,null,null,null,null,null,null,null,null,null,"Bridge",null,null,null,"Quantity generated by Bridge Design and shown on TS&L. Face-to-Face of Backwall or Face-to-Face of Paving Notch (equivalent)."]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"End Bridge Approach",null,{"$f":"SUM(M41:M43)","v":251.25649960688565}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Total",null,{"$f":"SUM(AB73:AC75)","v":520.51626372659643}]

{"sheet":"Rt. Skewed Bridge","index":1,"n_rows":59,"n_cols":29,"rows_kept":59,"cut":false,"hidden":false,"merged":[[9,27,10,27],[46,1,46,2],[46,10,46,11],[46,12,46,13],[46,14,46,15],[46,3,46,4],[46,5,46,6],[43,12,43,13],[40,12,41,13],[43,14,43,15],[44,5,44,6],[45,5,45,6],[40,10,41,10],[40,11,41,11],[40,14,41,15],[45,12,45,13],[44,12,44,13],[45,14,45,15],[42,14,42,15],[42,12,42,13],[47,1,47,2],[47,3,47,4],[47,5,47,6],[48,1,48,2],[48,3,48,4],[48,5,48,6],[21,5,21,7],[22,5,22,7],[20,5,20,7],[39,10,39,15],[39,7,41,9],[26,5,26,7],[23,5,23,7],[44,3,44,4],[45,3,45,4],[27,5,27,7],[28,5,28,7],[40,5,41,6],[39,1,39,6],[42,5,42,6],[43,5,43,6],[43,3,43,4],[42,3,42,4],[40,3,41,4],[30,5,30,7],[29,5,29,7],[38,0,38,16],[40,1,41,1],[40,2,41,2],[44,14,44,15],[24,27,25,27],[0,0,0,16],[2,0,2,1],[2,2,2,5],[0,17,0,28],[2,10,2,13],[19,5,19,11],[4,23,5,25],[19,23,20,25],[16,11,16,12],[24,24,25,24],[24,25,25,25],[24,26,25,26],[17,11,17,12],[24,5,24,7],[16,4,17,7],[25,5,25,7],[9,26,10,26],[9,24,10,24],[9,25,10,25],[6,23,7,23],[21,23,22,23],[5,10,5,11],[14,5,14,6],[50,27,50,28],[49,25,49,26],[49,27,49,28],[50,18,50,19],[50,20,50,21],[49,18,49,19],[51,27,51,28],[51,18,51,19],[51,20,51,21],[51,25,51,26],[51,22,51,24],[47,14,47,15],[48,14,48,15],[50,22,50,24],[49,22,49,24],[49,20,49,21],[47,10,47,11],[47,12,47,13],[48,10,48,11],[50,25,50,26],[53,11,53,12],[52,5,52,6],[53,5,53,6],[49,7,50,7],[49,8,49,9],[51,11,51,12],[48,12,48,13],[58,18,58,19],[58,20,58,21],[54,18,54,21],[55,18,55,19],[55,20,55,21],[56,18,56,19],[56,20,56,21],[57,18,57,19],[57,20,57,21],[52,18,52,19],[52,20,52,21],[50,11,50,12],[52,11,52,12]]}
["Bridge Approach Calculations (ENGLISH)",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Modified Subbase"]
[{"$f":"CELL(\"filename\")","v":"c:\\pw_work\\pwmain\\kbell\\d0797717\\[06030230C01.xlsm]PrintSheets"}]
["Bridge Station:",null,24147575.719999999,null,null,null,"SB/NB",null,"Lt","Rt","Is Abutment Moveable?",null,null,null,"n","Y/N"]
[null,null,null,"Skew Angle",null,null,0]
[null,null,null,null,null,null,null,"Skew :",{"$f":"DEGREES(ATAN((F6-F15)/(A9+A10+A11+A12)))","v":0},{"$f":"DEGREES(ATAN((K6-L15)/(Q9+Q10+Q11+Q12)))","v":0},"Deg",null,null,null,null,null,null,null,{"$f":"F15+(I7*(A12+A11))","v":20},{"$f":"E6","v":20},{"$f":"D6","v":20},{"$f":"C6","v":10},null,"Length of bridge end post (ft)",null,null,"Upper Lt.","Lower Lt."]
[null,null,10,20,20,{"$f":"IF(G6<5,20-G6,15)","v":20},{"$f":"TAN(G4*PI()/180)*(A9+A10)","v":0},null,null,null,{"$f":"(TAN(G4*PI()/180)*(Q9+Q10+Q11+Q12))+L15","v":20},{"$f":"TAN(#REF!*PI()/180)*(F2+F3)","v":{"$error":"#REF!"}},20,20,10,null,null,null,null,null,null,null,null,null,null,null,{"$f":"I18","v":7},{"$f":"K18","v":7}]
[null,null,null,null,null,null,null,"Slope:",{"$f":"(F6-F15)/(A9+A10+A11+A12)","v":0},{"$f":"(K6-L15)/(Q9+Q10+Q11+Q12)","v":0},"Ft/Ft",null,null,null,null,null,null,null,null,null,null,null,null,"End Depth (ft)","1st","2nd","3rd","4th","5th"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,2,{"$f":"(2-S5/U17)","v":1.6666666666666667},{"$f":"(2-(S5+T5)/U17)","v":1.3333333333333335},1,1]
[9.5832999999999995,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,8]
[14,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,14,null,null,null,null,null,null,null,"Avg. Depth (ft)","Area (ft2)","Volume (ft3)","Qty. (Tons)"]
[14,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,14]
[9.5832999999999995,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,8,null,null,null,null,null,null,"A1",{"$f":"(Y8+Z8)/2","v":1.8333333333333335},{"$f":"(((($F$6+$F$15)/2))*(SUM($A$9:$A$12)+6))-IF(I18<F6+2,(($I$18)*(3)),(F6+2)*3)-IF(K18<F15+2,K18*3,(F15+2)*3)","v":1021.3320000000001},{"$f":"IF(O3=\"y\",Y12*Z12-1*(A9+A10+A11+A12+2),Y12*Z12)","v":1872.4420000000002},{"$f":"AA12*140/2000","v":131.07094000000001}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"A2",{"$f":"(Z8+AA8)/2","v":1.5},{"$f":"((($E$6+$E$15)/2)-2)*(SUM($A$10:$A$11)+4)","v":576},{"$f":"Y13*Z13","v":864},{"$f":"AA13*140/2000","v":60.48}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"A3",{"$f":"(AA8+AB8)/2","v":1.1666666666666667},{"$f":"(((D6+D15)/2))*(SUM(A10:A11)+4)","v":640},{"$f":"Y14*Z14","v":746.66666666666674},{"$f":"AA14*140/2000","v":52.266666666666673}]
[null,null,10,20,20,{"$f":"(TAN(G4*PI()/180)*(A9+A10+A11+A12))+F6","v":20},null,null,null,null,{"$f":"TAN(G4*PI()/180)*(Q11+Q12)","v":0},{"$f":"IF(K15<5,20-K15,15)","v":20},20,20,10,null,null,null,null,null,null,null,null,"A4",{"$f":"(AB8+AC8)/2","v":1},{"$f":"(((C6+C15)/2))*(SUM(A10:A11)+4)","v":320},{"$f":"Y15*Z15","v":320},{"$f":"AA15*140/2000","v":22.4}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Totals:",{"$f":"SUM(Z12:Z15)","v":2557.3320000000003},{"$f":"SUM(AA12:AA15)","v":3803.108666666667},{"$f":"SUM(AB12:AB15)","v":266.21760666666665}]
[null,null,null,null,"Wing Wall and End Post Length (ft)",null,null,null,"Upper Lt.","Upper Rt.","Lower Lt.","Lower Rt.",null,null,null,null,null,null,null,"Slope:",{"$f":"(S5+T5+U5)/1","v":60},":1"]
[null,null,null,null,null,null,null,null,7,7,7,7]
[]
[null,null,null,null,null,"Approach Quantities (Tab 112-6)",null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"(J7*(Q12+Q11))+L15","v":20},{"$f":"M6","v":20},{"$f":"N6","v":20},{"$f":"O6","v":10},null,"Length of bridge end post (m)",null,null,"Upper Rt.","Lower Rt."]
[null,null,null,null,null,"Item",null,null,"Left","Right","Total",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"J18","v":7},{"$f":"L18","v":7}]
[null,null,null,null,null,"Pay Length",null,null,{"$f":"(ABS($F$15-$F$6)*((SUM($A$9:A$10)/SUM($A$9:$A$12)))+F6)+SUM(C15:E15)","v":70},{"$f":"(ABS($L$15-$K$6)*((SUM($Q$11:Q$12)/SUM($Q$9:$Q$12)))+L15)+SUM(M6:O6)","v":70},{"$f":"I22+J22","v":140},"ft",null,null,null,null,null,null,null,null,null,null,null,"End Depth (ft)","1st","2nd","3rd","4th","5th"]
[null,null,null,null,null,"Double Reinforced Approach",null,null,{"$f":"(((($F$6+$F$15)/2)*(SUM($A$9:$A$12)+2))-IF(I18<F6,I18*1,F6*1)-IF(K18<F15,K18*1,F15*1))/9","v":107.70355555555557},{"$f":"(((($K$6+$L$15)/2)*((SUM($Q$9:$Q$12)+2))-IF(J18<K6,J18*1,K6*1)-IF(L18<L15,L18*1,L15*1)))/9","v":100.66666666666667},208.37022222222225,"yd2",null,null,null,null,null,null,null,null,null,null,null,null,2,{"$f":"(2-S20/U33)","v":1.6666666666666667},{"$f":"(2-(S20+T20)/U33)","v":1.3333333333333335},1,1]
[null,null,null,null,null,"Single Reinforced Approach",null,null,{"$f":"((E6+E15)/2)*(A10+A11)/9","v":62.222222222222221},{"$f":"((M6+M15)/2)*(Q10+Q11)/9","v":62.222222222222221},124.44444444444444,"yd2"]
[null,null,null,null,null,"Non-Reinforced Approach",null,null,{"$f":"((D15+C15+D6+C6)/2)*(A10+A11)/9","v":93.333333333333329},{"$f":"((N6+O6+N15+O15)/2)*(Q10+Q11)/9","v":93.333333333333329},186.66666666666666,"yd2",null,null,null,null,null,null,null,null,null,null,null,null,"Avg. Depth (ft)","Area (ft2)","Volume (ft3)","Qty. (Tons)"]
[null,null,null,null,null,"Polymer Grid",null,null,{"$f":"SUM(Z12:Z15)/9","v":284.14800000000002},{"$f":"SUM(Z27:Z30)/9","v":288.22222222222223},572.37022222222231,"yd2"]
[null,null,null,null,null,"Modified Subbase",null,null,{"$f":"AB16","v":266.21760666666665},{"$f":"AB31","v":270.92333333333335},537.14094,"Tons",null,null,null,null,null,null,null,null,null,null,null,"A1",{"$f":"(Y23+Z23)/2","v":1.8333333333333335},{"$f":"(((($K$6+$L$15)/2)+2))*((SUM($Q$9:$Q$12)+6))-IF(J18<K6+2,J18*3,(K6+2)*3)-IF(L18<L15+2,L18*3,(L15+2)*3)","v":1058},{"$f":"IF(O3=\"y\",Y27*Z27-1*(Q9+Q10+Q11+Q12+2),Y27*Z27)","v":1939.6666666666667},{"$f":"AA27*140/2000","v":135.7766666666667}]
[null,null,null,null,null,"Pannel Quantities:",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"A2",{"$f":"(Z23+AA23)/2","v":1.5},{"$f":"(((M6+M15)/2)-2)*(SUM(Q10:Q11)+4)","v":576},{"$f":"Y28*Z28","v":864},{"$f":"AA28*140/2000","v":60.48}]
[null,null,null,null,null,"Paved Shoulder",null,null,{"$f":"+F47","v":0},{"$f":"O47","v":80},{"$f":"I29+J29","v":80},"yd2",null,null," - User Input",null,null,null,null,null,null,null,null,"A3",{"$f":"(AA23+AB23)/2","v":1.1666666666666667},{"$f":"((N6+N15)/2)*(SUM(Q10:Q11)+4)","v":640},{"$f":"Y29*Z29","v":746.66666666666674},{"$f":"AA29*140/2000","v":52.266666666666673}]
[null,null,null,null,null,"Modified Subbase",null,null,{"$f":"D47","v":0},{"$f":"M47","v":67.2},{"$f":"I30+J30","v":67.2},"Tons",null,null," - Calculation (Locked)",null,null,null,null,null,null,null,null,"A4",{"$f":"(AB23+AC23)/2","v":1},{"$f":"((O6+O15)/2)*(SUM(Q10:Q11)+4)","v":320},{"$f":"Y30*Z30","v":320},{"$f":"AA30*140/2000","v":22.4}]
["Tips for Use:",null,null,null,null,"Polymer Grid",null,null,{"$f":"F47","v":0},{"$f":"O47","v":80},{"$f":"I31+J31","v":80},"yd2",null,null,null,null,null,null,null,null,null,null,null,null,"Totals:",{"$f":"SUM(Z27:Z30)","v":2594},{"$f":"SUM(AA27:AA30)","v":3870.3333333333339},{"$f":"SUM(AB27:AB30)","v":270.92333333333335}]
["1)  Fill in dimensions in feet.",null,null,null,null,null,null,null,null,null,null,null,null,null," - Non-Reinforced Section"]
["2)  Calculated quantities include 4\" sloped curb.",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Slope:",{"$f":"(S20+T20+U20)/1","v":60},":1"]
["3)  All values based on Standard Road Plan RK-20(1-3)",null,null,null,null,null,null,null,null,null,null,null,null,null," - Single Reinforced Section"]
[]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null," - Double Reinforced Section"]
[]
[]
["Paved Shoulder Panels for Sod Flume or Bridge End Drain (See Standard Road Plans RF-38, RF-39, & RF-40 as well as Tabs 104-8 and 104-8A)"]
[null,"Lt. Side",null,null,null,null,null,"1Not a Bid Item",null,null,"Rt. Side"]
[null,"Req'd Panel","Y/N","1Modified Subbase(Ton)",null,"1Polymer Grid (yd2)",null,null,null,null,"Req'd Panel","Y/N","1Modified Subbase(Ton)",null,"1Polymer Grid (Yd2)"]
[]
[null,"A","N",{"$f":"F43*Y13*9*140/2000","v":0},null,{"$f":"IF($C$43=\"y\",(E15)*(A12+3-2)-IF(K18<F15+2,0,IF(K18<SUM(E15:G15),(K18-(F15+2))*3,E15*3)),0)/9","v":0},null,null,null,null,"A","Y",{"$f":"O43*Y28*9*140/2000","v":18.899999999999999},null,{"$f":"IF($L$43=\"y\",M6*(Q9+3-2)-IF(J18<K6+2,0,IF(J18<(K6+M6),(J18-(K6+2))*3,M6*3)),0)/9","v":20}]
[null,"B","N",{"$f":"F44*Y13*9*140/2000","v":0},null,{"$f":"IF($C$44=\"y\",(E6)*(A9+3-2)-IF(I18<F6+2,0,IF(I18<(SUM(E6:F6)+2),(I18-(F6+2))*3,E6*3)),0)/9","v":0},null,null,null,null,"B","Y",{"$f":"O44*Y28*9*140/2000","v":18.899999999999999},null,{"$f":"IF($L$44=\"y\",M15*(Q12+3-2)-IF(L18<L15+2,0,IF(L18<SUM(L15:M15),(L18-(L15+2))*3,M15*3)),0)/9","v":20}]
[null,"C","N",{"$f":"F45*Y14*9*140/2000","v":0},null,{"$f":"IF($C$45=\"y\",(A9+3-2)*D6-IF(I18<SUM(E6:F6)+2,0,(I18-(SUM(E6:F6)+2))*3),0)/9","v":0},null,null,null,null,"C","Y",{"$f":"O45*Y29*9*140/2000","v":14.700000000000001},null,{"$f":"IF($L$45=\"y\",N15*(Q12+1)-IF(L18<SUM(L15:M15)+2,0,(L18-(SUM(L15:M15)+2))*3),0)/9","v":20}]
[null,"D","N",{"$f":"F46*Y14*9*140/2000","v":0},null,{"$f":"IF($C$46=\"y\",D15*(A12+3-2)-IF(K18<SUM(E15:F15)+2,0,(K18-(SUM(E15:F15)+2))*3),0)/9","v":0},null,null,null,null,"D","Y",{"$f":"O46*Y29*9*140/2000","v":14.700000000000001},null,{"$f":"IF($L$46=\"y\",N6*(Q9+3-2)-IF(J18<(M6+K6)+2,0,(J18-(SUM(K6:M6)+2))*3),0)/9","v":20}]
[null,"Total:",null,{"$f":"SUM(D43:E46)","v":0},null,{"$f":"SUM(F43:G46)","v":0},null,null,null,null,"Total:",null,{"$f":"SUM(M43:N46)","v":67.2},null,{"$f":"SUM(O43:P46)","v":80}]
[null,"B+C=",null,{"$f":"+D44+D45","v":0},null,{"$f":"+F44+F45","v":0},null,null,null,null,"B+C=",null,{"$f":"+M44+M45","v":33.6},null,{"$f":"+O44+O45","v":40}]
[null,"A+D= ",null,{"$f":"+D43+D46","v":0},null,{"$f":"+F43+F46","v":0},null,null,null,null,"A+D= ",null,{"$f":"+M43+M46","v":33.6},null,{"$f":"+O43+O46","v":40}]
[null,null,null,null,null,null,null,"Panel","Area (yd2)",null,null,null,null,null,null,null,null,null,"Begin Bridge Approach Station",null,{"$f":"U51-I22","v":24147375.719999999},null,"Subdrain Outlet Location",null,null,"4\" Subdrain",null,"Porous Backfill"]
[null,null,null,null,null,null,null,null,"Lt. Side","Rt. Side",null,null,null,null,null,null,null,null,"Begin Bridge Station",null,24147445.719999999,null,24147370,null,null,{"$f":"ROUNDUP(SUM(A10:A12)+(2.75*6)+((3/12)*6)+(IF($C$43=\"y\",+A9,0)+10)+16,0)","v":82},{"$f":"ROUNDUP(SUM(#REF!)+(2.75*6)+((3/12)*6)+10,0)","v":{"$error":"#REF!"}},{"$f":"ROUNDUP((2.667*Z51)*120/2000,0)","v":14}]
[null,null,null,null,null,null,null,"A",{"$f":"IF($C$43=\"y\",((E15*(A12+1)-IF(K18<F15,0,IF(K18<(E15+F15),(K18-F15)*1,E15*1)))/9),0)","v":0},{"$f":"IF(L43=\"y\",((M6*(Q9+1)-IF(J18<K6,0,IF(J18<(M6+K6),(J18-K6)*1,M6*1)))/9),0)","v":20},null,null,null,null,null,null,null,null,"End Bridge Station",null,24147705.719999999,null,{"$f":"+U52+(ABS(L15-K6)*(SUM(Q11:Q12)/SUM(Q9:Q12))+L15)+SUM(M6:N6)","v":24147765.719999999},null,null,{"$f":"ROUNDUP(SUM(Q10:Q12)+(2.75*6)+((3/12)*6)+(IF($L$43=\"y\",+Q9,0)+10),0)","v":72},{"$f":"ROUNDUP(SUM(#REF!)+(2.75*6)+((3/12)*6)+10,0)","v":{"$error":"#REF!"}},{"$f":"ROUNDUP((2.667*Z52)*120/2000,0)","v":12}]
[null,null,null,null,"B+C=",{"$f":"+I53+I54","v":0},null,"B",{"$f":"IF($C$44=\"y\",(E6*(A9+1)-IF(I18<F6,0,IF(I18<(E6+F6),(I18-F6)*1,E6*1)))/9,0)","v":0},{"$f":"IF(L44=\"y\",(M15*(Q12+1)-IF(L18<L15,0,IF(L18<(M15+L15),(L18-L15)*1,M15*1)))/9,0)","v":20},"B+C=",{"$f":"+J53+J54","v":40},null,null,null,null,null,null,"End Bridge Approach Station",null,{"$f":"U52+J22","v":24147775.719999999}]
[null,null,null,null,"A+D=",{"$f":"+I52+I55","v":0},null,"C",{"$f":"IF($C$45=\"y\",(((A9+1)*D6-IF(I18<(E6+F6),0,I18-SUM(E6:F6)))/9),0)","v":0},{"$f":"IF(L45=\"y\",(((Q12+1)*N15-IF(L18<(M15+L15),0,L18-SUM(L15:M15)))/9),0)","v":20},"A+D=",{"$f":"+J52+J55","v":40}]
[null,null,null,null,null,null,null,"D",{"$f":"IF($C$46=\"y\",(D15*(1+A12)-IF(I18<(E15+F15),0,I18-(E15+F15)))/9,0)","v":0},{"$f":"IF(L46=\"y\",(N6*(1+Q9)-IF(J18<(M6+K6),0,J18-(M6+K6)))/9,0)","v":20},null,null,null,null,null,null,null,null,"Longitudinal Grooving"]
[null,null,null,null,null,null,null,"Total:",{"$f":"SUM(I52:I55)","v":0},{"$f":"SUM(J52:J55)","v":80},null,null,null,null,null,null,null,null,"Begin Bridge Approach",null,{"$f":"SUM(I23:I25)","v":263.25911111111111}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Bridge",null,{"$f":"((U52-U51)*(Q9+Q10+Q11+Q12))/9","v":1271.1111111111111},null,"Quantity generated by Bridge Design and shown on TS&L. Face-to-Face of Backwall or Face-to-Face of Paving Notch (equivalent)."]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"End Bridge Approach",null,{"$f":"SUM(J23:J25)","v":256.22222222222223}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Total",null,{"$f":"SUM(U56:V58)","v":1790.5924444444445}]

{"sheet":"Lt. Skewed Bridge","index":2,"n_rows":59,"n_cols":29,"rows_kept":59,"cut":false,"hidden":false,"merged":[[47,1,47,2],[47,3,47,4],[47,5,47,6],[48,1,48,2],[48,3,48,4],[48,5,48,6],[58,18,58,19],[52,5,52,6],[53,5,53,6],[47,10,47,11],[47,12,47,13],[48,10,48,11],[48,12,48,13],[49,7,50,7],[58,20,58,21],[54,18,54,21],[57,18,57,19],[57,20,57,21],[56,18,56,19],[56,20,56,21],[55,18,55,19],[55,20,55,21],[49,8,49,9],[52,18,52,19],[52,20,52,21],[52,11,52,12],[53,11,53,12],[49,27,49,28],[50,27,50,28],[51,27,51,28],[50,20,50,21],[51,20,51,21],[49,18,49,19],[49,20,49,21],[49,25,49,26],[50,25,50,26],[45,12,45,13],[45,14,45,15],[47,14,47,15],[48,14,48,15],[51,25,51,26],[50,18,50,19],[51,18,51,19],[49,22,49,24],[51,22,51,24],[50,22,50,24],[50,11,50,12],[51,11,51,12],[46,1,46,2],[46,10,46,11],[46,12,46,13],[46,14,46,15],[46,3,46,4],[46,5,46,6],[42,12,42,13],[42,14,42,15],[14,10,14,11],[39,10,39,15],[40,11,41,11],[27,5,27,7],[28,5,28,7],[24,5,24,7],[23,5,23,7],[40,5,41,6],[40,3,41,4],[39,7,41,9],[45,3,45,4],[42,5,42,6],[43,5,43,6],[44,5,44,6],[45,5,45,6],[42,3,42,4],[43,3,43,4],[44,3,44,4],[21,5,21,7],[22,5,22,7],[20,5,20,7],[9,25,10,25],[16,4,17,7],[39,1,39,6],[9,24,10,24],[24,24,25,24],[24,25,25,25],[38,0,38,16],[40,1,41,1],[40,2,41,2],[40,14,41,15],[29,5,29,7],[30,5,30,7],[26,5,26,7],[40,10,41,10],[43,12,43,13],[40,12,41,13],[43,14,43,15],[44,12,44,13],[44,14,44,15],[24,26,25,26],[24,27,25,27],[6,23,7,23],[21,23,22,23],[19,23,20,25],[9,27,10,27],[9,26,10,26],[0,0,0,16],[2,0,2,1],[2,2,2,5],[2,10,2,13],[19,5,19,11],[0,17,0,28],[4,23,5,25],[5,5,5,6],[16,11,16,12],[17,11,17,12],[25,5,25,7]]}
["Bridge Approach Calculations (ENGLISH)",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Modified Subbase"]
[{"$f":"CELL(\"filename\")","v":"c:\\pw_work\\pwmain\\kbell\\d0797717\\[06030230C01.xlsm]PrintSheets"}]
["Bridge Station:",null,null,null,null,null,"EBL\\NBL",null,"Lt","Rt","Is Abutment Moveable?",null,null,null,"Y","Y/N"]
[null,null,null,"Skew Angle",null,null,0]
[null,null,null,null,null,null,null,"Skew L:",{"$f":"DEGREES(ATAN((F6-F15)/(A9+A10+A11+A12)))","v":0},{"$f":"ABS(DEGREES(ATAN((L6-K15)/(Q9+Q10+Q11+Q12))))","v":0},"deg.",null,null,null,null,null,null,null,{"$f":"F15+(I7*(A12+A11))","v":20},{"$f":"E6","v":20},{"$f":"D6","v":20},{"$f":"C6","v":10},null,"Length of bridge end post (m)",null,null,"Upper Lt.","Lower Lt."]
[null,null,10,20,20,{"$f":"(TAN(G4*PI()/180)*(A9+A10+A11+A12))+F15","v":20},{"$f":"TAN(#REF!*PI()/180)*(A2+A3)","v":{"$error":"#REF!"}},null,null,null,{"$f":"TAN(G4*PI()/180)*(Q9+Q10)","v":0},{"$f":"IF(K6<5,20-K6,15)","v":20},20,20,10,null,null,null,null,null,null,null,null,null,null,null,{"$f":"I18","v":7},{"$f":"K18","v":7}]
[null,null,null,null,null,null,null,"Slope:",{"$f":"(F6-F15)/(A9+A10+A11+A12)","v":0},{"$f":"(K15-L6)/(Q9+Q10+Q11+Q12)","v":0},"Ft/Ft",null,null,null,null,null,null,null,null,null,null,null,null,"End Depth (ft)","1st","2nd","3rd","4th","5th"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,2,{"$f":"(2-S5/U17)","v":1.6666666666666667},{"$f":"(2-(S5+T5)/U17)","v":1.3333333333333335},1,1]
[6,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,6]
[12,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,12,null,null,null,null,null,null,null,"Avg. Depth (ft)","Area (ft2)","Volume (ft3)","Qty. (Tons)"]
[14,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,14]
[8,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,8,null,null,null,null,null,null,"A1",{"$f":"(Y8+Z8)/2","v":1.8333333333333335},{"$f":"(((($F$6+$F$15)/2+2))*(SUM($A$9:$A$12)+6))-IF(I18<F6+2,(($I$18)*(3)),(F6+2)*3)-IF(K18<F15+2,K18*3,(F15+2)*3)","v":970},{"$f":"IF(O3=\"y\",Y12*Z12-1*(A9+A10+A11+A12+2),Y12*Z12)","v":1736.3333333333335},{"$f":"AA12*140/2000","v":121.54333333333334}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"A2",{"$f":"(Z8+AA8)/2","v":1.5},{"$f":"((($E$6+$E$15)/2)-2)*(SUM($A$10:$A$11)+4)","v":540},{"$f":"Y13*Z13","v":810},{"$f":"AA13*140/2000","v":56.7}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"A3",{"$f":"(AA8+AB8)/2","v":1.1666666666666667},{"$f":"(((D6+D15)/2))*(SUM(A10:A11)+4)","v":600},{"$f":"Y14*Z14","v":700},{"$f":"AA14*140/2000","v":49}]
[null,null,10,20,20,{"$f":"IF(G15<5,20-G15,15)","v":20},{"$f":"TAN(G4*PI()/180)*(A11+A12)","v":0},null,null,null,{"$f":"(TAN(G4*PI()/180)*(Q9+Q10+Q11+Q12))+L6","v":20},{"$f":"TAN(#REF!*PI()/180)*(F11+F12)","v":{"$error":"#REF!"}},20,20,10,null,null,null,null,null,null,null,null,"A4",{"$f":"(AB8+AC8)/2","v":1},{"$f":"(((C6+C15)/2))*(SUM(A10:A11)+4)","v":300},{"$f":"Y15*Z15","v":300},{"$f":"AA15*140/2000","v":21}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Totals:",{"$f":"SUM(Z12:Z15)","v":2410},{"$f":"SUM(AA12:AA15)","v":3546.3333333333335},{"$f":"SUM(AB12:AB15)","v":248.24333333333334}]
[null,null,null,null,"Wing Wall and End Post Length (ft)",null,null,null,"Upper Lt.","Upper Rt.","Lower Lt.","Lower Rt.",null,null,null,null,null,null,null,"Slope:",{"$f":"(S5+T5+U5)/1","v":60},":1"]
[null,null,null,null,null,null,null,null,7,7,7,7]
[]
[null,null,null,null,null,"Approach Quantities (Tab 112-6)",null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"(J7*(Q9+Q10))+L6","v":20},{"$f":"M6","v":20},{"$f":"N6","v":20},{"$f":"O6","v":10},null,"Length of bridge end post (m)",null,null,"Upper Rt.","Lower Rt."]
[null,null,null,null,null,"Item",null,null,"Left","Right","Total",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"J18","v":7},{"$f":"L18","v":7}]
[null,null,null,null,null,"Pay Length",null,null,{"$f":"(ABS($F$15-$F$6)*((SUM($A$9:A$10)/SUM($A$9:$A$12)))+F15)+SUM(C15:E15)","v":70},{"$f":"(ABS(K15-L6)*((SUM($Q$11:Q$12)/SUM($Q$9:$Q$12)))+L6)+SUM(M6:O6)","v":70},{"$f":"I22+J22","v":140},"ft",null,null,null,null,null,null,null,null,null,null,null,"End Depth (ft)","1st","2nd","3rd","4th","5th"]
[null,null,null,null,null,"Double Reinforced Approach",null,null,{"$f":"(((($F$6+$F$15)/2)*(SUM($A$9:$A$12)+2))-IF(I18<F6,I18*1,F6*1)-IF(K18<F15,K18*1,F15*1))/9","v":91.777777777777771},{"$f":"((((L6+K15)/2)*((SUM($Q$9:$Q$12)+2))-IF(J18<L6,J18*1,L6*1)-IF(L18<K15,L18*1,K15*1)))/9","v":91.777777777777771},183.55555555555554,"yd2",null,null,null,null,null,null,null,null,null,null,null,null,2,{"$f":"(2-S20/U33)","v":1.6666666666666667},{"$f":"(2-(S20+T20)/U33)","v":1.3333333333333335},1,1]
[null,null,null,null,null,"Single Reinforced Approach",null,null,{"$f":"((E6+E15)/2)*(A10+A11)/9","v":57.777777777777779},{"$f":"((M6+M15)/2)*(Q10+Q11)/9","v":57.777777777777779},115.55555555555556,"yd2"]
[null,null,null,null,null,"Non-Reinforced Approach",null,null,{"$f":"((D15+C15+D6+C6)/2)*(A10+A11)/9","v":86.666666666666671},{"$f":"((N6+O6+N15+O15)/2)*(Q10+Q11)/9","v":86.666666666666671},173.33333333333334,"yd2",null,null,null,null,null,null,null,null,null,null,null,null,"Avg. Depth (ft)","Area (ft2)","Volume (ft3)","Qty. (Tons)"]
[null,null,null,null,null,"Polymer Grid",null,null,{"$f":"SUM(Z12:Z15)/9","v":267.77777777777777},{"$f":"SUM(Z27:Z30)/9","v":267.77777777777777},535.55555555555554,"yd2"]
[null,null,null,null,null,"Modified Subbase",null,null,{"$f":"AB16","v":248.24333333333334},{"$f":"AB31","v":248.24333333333334},496.48666666666668,"Tons",null,null,null,null,null,null,null,null,null,null,null,"A1",{"$f":"(Y23+Z23)/2","v":1.8333333333333335},{"$f":"((((L6+K15)/2)+2))*((SUM($Q$9:$Q$12)+6))-IF(J18<L6+2,J18*3,(L6+2)*3)-IF(L18<K15+2,L18*3,(K15+2)*3)","v":970},{"$f":"IF(O3=\"y\",Y27*Z27-1*(Q9+Q10+Q11+Q12+2),Y27*Z27)","v":1736.3333333333335},{"$f":"AA27*140/2000","v":121.54333333333334}]
[null,null,null,null,null,"Pannel Quantities:",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"A2",{"$f":"(Z23+AA23)/2","v":1.5},{"$f":"(((M6+M15)/2)-2)*(SUM(Q10:Q11)+4)","v":540},{"$f":"Y28*Z28","v":810},{"$f":"AA28*140/2000","v":56.7}]
[null,null,null,null,null,"Paved Shoulder",null,null,{"$f":"+F47","v":35.555555555555557},{"$f":"O47","v":35.555555555555557},{"$f":"I29+J29","v":71.111111111111114},"yd2",null,null," - User Input",null,null,null,null,null,null,null,null,"A3",{"$f":"(AA23+AB23)/2","v":1.1666666666666667},{"$f":"((N6+N15)/2)*(SUM(Q10:Q11)+4)","v":600},{"$f":"Y29*Z29","v":700},{"$f":"AA29*140/2000","v":49}]
[null,null,null,null,null,"Modified Subbase",null,null,{"$f":"D47","v":33.599999999999994},{"$f":"M47","v":33.599999999999994},{"$f":"I30+J30","v":67.199999999999989},"Tons",null,null," - Calculation (Locked)",null,null,null,null,null,null,null,null,"A4",{"$f":"(AB23+AC23)/2","v":1},{"$f":"((O6+O15)/2)*(SUM(Q10:Q11)+4)","v":300},{"$f":"Y30*Z30","v":300},{"$f":"AA30*140/2000","v":21}]
["Tips for Use:",null,null,null,null,"Polymer Grid",null,null,{"$f":"F47","v":35.555555555555557},{"$f":"O47","v":35.555555555555557},{"$f":"I31+J31","v":71.111111111111114},"yd2",null,null,null,null,null,null,null,null,null,null,null,null,"Totals:",{"$f":"SUM(Z27:Z30)","v":2410},{"$f":"SUM(AA27:AA30)","v":3546.3333333333335},{"$f":"SUM(AB27:AB30)","v":248.24333333333334}]
["1)  Fill in dimensions in feet.",null,null,null,null,null,null,null,null,null,null,null,null,null," - Non-Reinforced Section"]
["2)  Calculated quantities include 4\" sloped curb.",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Slope:",{"$f":"(S20+T20+U20)/1","v":60},":1"]
["3)  All values based on Standard Road Plan RK-20(1-3)",null,null,null,null,null,null,null,null,null,null,null,null,null," - Single Reinforced Section"]
[]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null," - Double Reinforced Section"]
[]
[]
["Paved Shoulder Panels for Sod Flume or Bridge End Drain (See Standard Road Plans RF-38, RF-39, & RF-40 as well as Tabs 104-8 and 104-8A)"]
[null,"Lt. Side",null,null,null,null,null,"1Not a Bid Item",null,null,"Rt. Side"]
[null,"Req'd Panel","Y/N","1Modified Subbase(Ton)",null,"1Polymer Grid (yd2)",null,null,null,null,"Req'd Panel","Y/N","1Modified Subbase(Ton)",null,"1Polymer Grid (Yd2)"]
[]
[null,"A","Y",{"$f":"F43*Y13*9*140/2000","v":14.7},null,{"$f":"IF($C$43=\"y\",(E6)*(A9+3-2)-IF(I18<F6+2,0,IF(I18<SUM(E6:G6),(I18-(F6+2))*3,E6*3)),0)/9","v":15.555555555555555},null,null,null,null,"A","Y",{"$f":"O43*Y28*9*140/2000","v":18.899999999999999},null,{"$f":"IF($L$43=\"y\",M15*(Q12+3-2)-IF(L18<K15+2,0,IF(L18<(K15+M15),(L18-(K15+2))*3,M15*3)),0)/9","v":20}]
[null,"B","Y",{"$f":"F44*Y13*9*140/2000","v":18.899999999999999},null,{"$f":"IF($C$44=\"y\",(E15)*(A12+3-2)-IF(K18<F15+2,0,IF(K18<(SUM(E15:F15)+2),(K18-(F15+2))*3,E15*3)),0)/9","v":20},null,null,null,null,"B","Y",{"$f":"O44*Y28*9*140/2000","v":14.7},null,{"$f":"IF($L$44=\"y\",M6*(Q9+3-2)-IF(J18<L6+2,0,IF(J18<SUM(L6:M6),(J18-(L6+2))*3,M6*3)),0)/9","v":15.555555555555555}]
[null,"C",null,{"$f":"F45*Y14*9*140/2000","v":0},null,{"$f":"IF($C$45=\"y\",(A12+3-2)*D15-IF(K18<SUM(E15:F15)+2,0,(K18-(SUM(E15:F15)+2))*3),0)/9","v":0},null,null,null,null,"C",null,{"$f":"O45*Y29*9*140/2000","v":0},null,{"$f":"IF($L$45=\"y\",N6*(Q9+1)-IF(J18<SUM(L6:M6)+2,0,(J18-(SUM(L6:M6)+2))*3),0)/9","v":0}]
[null,"D",null,{"$f":"F46*Y14*9*140/2000","v":0},null,{"$f":"IF($C$46=\"y\",D6*(A9+3-2)-IF(I18<SUM(E6:F6)+2,0,(I18-(SUM(E6:F6)+2))*3),0)/9","v":0},null,null,null,null,"D",null,{"$f":"O46*Y29*9*140/2000","v":0},null,{"$f":"IF($L$46=\"y\",N15*(Q12+3-2)-IF(L18<(M15+K15)+2,0,(L18-(SUM(K15:M15)+2))*3),0)/9","v":0}]
[null,"Total:",null,{"$f":"SUM(D43:E46)","v":33.599999999999994},null,{"$f":"SUM(F43:G46)","v":35.555555555555557},null,null,null,null,"Total:",null,{"$f":"SUM(M43:N46)","v":33.599999999999994},null,{"$f":"SUM(O43:P46)","v":35.555555555555557}]
[null,"B+C=",null,{"$f":"+D44+D45","v":18.899999999999999},null,{"$f":"+F44+F45","v":20},null,null,null,null,"B+C=",null,{"$f":"+M44+M45","v":14.7},null,{"$f":"+O44+O45","v":15.555555555555555}]
[null,"A+D= ",null,{"$f":"+D43+D46","v":14.7},null,{"$f":"+F43+F46","v":15.555555555555555},null,null,null,null,"A+D= ",null,{"$f":"+M43+M46","v":18.899999999999999},null,{"$f":"+O43+O46","v":20}]
[null,null,null,null,null,null,null,"Panel","Area (yd2)",null,null,null,null,null,null,null,null,null,"Begin Bridge Approach Station",null,{"$f":"U51-I22","v":49245},null,"Subdrain Outlet Location",null,null,"4\" Subdrain",null,"Porous Backfill"]
[null,null,null,null,null,null,null,null,"Lt. Side","Rt. Side",null,null,null,null,null,null,null,null,"Begin Bridge Station",null,{"$f":"49316.5-1.5","v":49315},null,{"$f":"+U51-(ABS(F15-F6)*(SUM(A11:A12)/SUM(A9:A12))+F15)-SUM(D15:E15)","v":49255},null,null,{"$f":"ROUNDUP(SUM(A10:A12)+(2.75*6)+((3/12)*6)+(IF($C$43=\"y\",+A9,0)+10),0)","v":68},{"$f":"ROUNDUP(SUM(#REF!)+(2.75*6)+((3/12)*6)+10,0)","v":{"$error":"#REF!"}},{"$f":"ROUNDUP((2.667*Z51)*120/2000,0)","v":11}]
[null,null,null,null,null,null,null,"A",{"$f":"IF($C$43=\"y\",((E6*(A9+1)-IF(I18<F6,0,IF(I18<(E6+F6),(I18-F6)*1,E6*1)))/9),0)","v":15.555555555555555},{"$f":"IF(L43=\"y\",((M15*(Q12+1)-IF(L18<K15,0,IF(L18<(M15+K15),(L18-K15)*1,M15*1)))/9),0)","v":20},null,null,null,null,null,null,null,null,"End Bridge Station",null,{"$f":"49446.5+1.5","v":49448},null,{"$f":"+U52+(ABS(K15-L6)*(SUM(Q9:Q10)/SUM(Q9:Q12))+L6)+SUM(M6:N6)","v":49508},null,null,{"$f":"ROUNDUP(SUM(Q10:Q12)+(2.75*6)+((3/12)*6)+(IF($L$43=\"y\",+Q9,0)+10),0)","v":68},{"$f":"ROUNDUP(SUM(#REF!)+(2.75*6)+((3/12)*6)+10,0)","v":{"$error":"#REF!"}},{"$f":"ROUNDUP((2.667*Z52)*120/2000,0)","v":11}]
[null,null,null,null,"B+C=",{"$f":"+I53+I54","v":20},null,"B",{"$f":"IF($C$44=\"y\",(E15*(A12+1)-IF(K18<F15,0,IF(K18<(E15+F15),(K18-F15)*1,E15*1)))/9,0)","v":20},{"$f":"IF(L44=\"y\",(M6*(Q9+1)-IF(J18<L6,0,IF(J18<(M6+L6),(J18-L6)*1,M6*1)))/9,0)","v":15.555555555555555},"B+C=",{"$f":"+J53+J54","v":15.555555555555555},null,null,null,null,null,null,"End Bridge Approach Station",null,{"$f":"U52+J22","v":49518}]
[null,null,null,null,"A+D=",{"$f":"+I52+I55","v":15.555555555555555},null,"C",{"$f":"IF($C$45=\"y\",(((A12+1)*D15-IF(K18<(E15+F15),0,K18-SUM(E15:F15)))/9),0)","v":0},{"$f":"IF(L45=\"y\",(((Q9+1)*N6-IF(J18<(M6+L6),0,J18-SUM(L6:M6)))/9),0)","v":0},"A+D=",{"$f":"+J52+J55","v":20}]
[null,null,null,null,null,null,null,"D",{"$f":"IF($C$46=\"y\",(D6*(1+A9)-IF(I18<(E6+F6),0,I18-(E6+F6)))/9,0)","v":0},{"$f":"IF(L46=\"y\",(N15*(1+Q12)-IF(L18<(M15+K15),0,L18-(M15+K15)))/9,0)","v":0},null,null,null,null,null,null,null,null,"Longitudinal Grooving"]
[null,null,null,null,null,null,null,"Total:",{"$f":"SUM(I52:I55)","v":35.555555555555557},{"$f":"SUM(J52:J55)","v":35.555555555555557},null,null,null,null,null,null,null,null,"Begin Bridge Approach",null,{"$f":"SUM(I23:I25)","v":236.22222222222223}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Bridge",null,null,null,"Quantity generated by Bridge Design and shown on TS&L. Face-to-Face of Backwall or Face-to-Face of Paving Notch (equivalent)."]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"End Bridge Approach",null,{"$f":"SUM(J23:J25)","v":236.22222222222223}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Total",null,{"$f":"SUM(U56:V58)","v":472.44444444444446}]