{"text_format":"1","workbook":"xlsx","n_sheets":6,"sheets":["Introduction","Input","Summary","Transition Width","Calcs","Options"],"not_rendered":{"charts":0,"images":30,"macros":1,"external_links":0,"defined_names":6,"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":"Introduction","index":0,"n_rows":32,"n_cols":10,"rows_kept":32,"cut":false,"hidden":false,"merged":[[31,0,32,8],[0,9,12,18],[21,0,21,8],[23,0,23,8],[9,2,9,3],[9,4,9,5],[15,0,15,8],[17,0,17,8],[19,0,19,8],[13,0,13,8],[10,4,10,5],[11,4,11,5],[0,3,0,5],[5,2,5,3],[7,2,7,3],[5,4,5,5],[6,4,6,5],[7,4,7,5],[2,4,2,5],[3,4,3,5],[6,1,6,3],[30,0,30,8],[25,0,25,1],[26,0,26,8],[27,0,27,8],[28,0,28,8],[29,0,29,8]]}
[null,null,null,"INTRODUCTION",null,null,null,null,null,"DISCLAIMER: The Louisiana Department of Transportation and Development (LaDOTD) makes these documents and software available on an \"as is\" basis. All warranties and representations of any kind with regard to said documents and software are disclaimed, including the implied warranties of merchantability and fitness for a particular use. Under no circumstances will the LaDOTD, or any of its officers or employees be liable for any consequential, incidental, special or exemplary damages even if apprised of the likelihood of such damages occurring. The LaDOTD does not warrant the documents and software against deficiencies of any kind. The use of any of these documents and software for work that is under contract with the LaDOTD does not relieve the contractor from any obligations assumed by the contract, or from complete and proper fulfillment of the terms of the contract, nor does it entitle the contractor to compensation for damages or loss which could be attributed to such use.\n\nInformation on this web site is posted to aid in the efficient dissemination of information to designers. The data contained within this web site is periodically updated. Designers are responsible to be aware of any updates and incorporate significant changes into their final design."]
[]
[null,null,null,"Date:","2019-03-18"]
[null,null,null,"Version:","1.1"]
[]
[null,null,"Developed By:",null,"Ching Tsai"]
[null,"Checked and Modified By:",null,null,"Qiming Chen",null," "]
[null,null,"Reviewed By:","QA","Heather Patton",null," "]
[]
[null,null,"Maintained By:",null,"Qiming Chen"]
[null,null,null,"Email:","qiming.chen@la.gov"]
[null,null,null,"Phone:","225-379-1412"]
[]
["Genearl: This spreadsheet is designed to aid a qualified engineer in completing the bridge load rating analysis of a reinforced concrete pipe cuvlert structure (DOTD culvert structure type: CONPIP). Sound engineering judgement and familiariry with the analysis are required to choose appropriate input values and to recognize situations that may deviate from the standard case on which these spreadsheets based. Excel VBA programming is used in this spreadsheet for load rating analysis. This spreadsheet is comprised of six worksheets: Introduction, Input, Summary, Transition Width, Options, and Calcs. The Input and Summary worksheets are protected. The passoword is \"Rating\"."]
[]
["Input Worksheet:  Yellow shaded cells are required input, please input a appropriate value or choose a appropriate option from the drop-down list. After finishing inputing all values, please click \"Click to Rate the Structure\" to do load rating analysis."]
[]
["Summary Worksheet: This worksheet will be updated automatically after clicking \"Click to Rate the Structure\" in the Input Worksheet. This worksheet contains the general information and rating facotrs of the concrete pipe defined in the Input Worksheet."]
[]
["Transition Width Worksheet:  This worksheet is a reference table that is reproduced from ACPA's Concrete Pipe Design Manul."]
[]
["Options Worksheet (Hidden):  This worksheet contains data used by excel VBA programs for load rating analysis. This worksheet also contains tabulated values that are accessed using lookup funcions based on selections from the drop down cells in the Input worksheet."]
[]
["Calcs Worksheet (Hidden):  This worksheet contains the calculations to obtain rating weigtht, governing rating factor, governing load model, and recommended posting load in the Summary Worksheet."]
[]
["References:"]
["AASHTO LRFD Bridge Design Specifications, Seventh Edition, Section 3, 4 & 12."]
["ACPA Concrete Pipe Design Manual (Revised October 2011)."]
["LaDOTD Bridge Design & Evaluation Manual REV 7, Section 6."]
["AASHTO Manual for Bridge Evaluation, Second Edition."]
["ASTM C-76."]
["\"Physical Evaluation of the Dissipation of a Concentrated Load When Applied to Reinforced Concrete Pipe\", Pipelines Conference 2012, August 19-22, 2012, Miami Beach, Flordia"]

{"sheet":"Input","index":1,"n_rows":54,"n_cols":15,"rows_kept":54,"cut":false,"hidden":false,"merged":[[52,4,52,7],[44,4,44,7],[48,4,48,7],[14,5,14,8],[4,4,4,7],[4,8,4,9],[5,4,5,7],[5,8,5,9],[2,4,2,7],[2,8,2,9],[2,10,2,12],[3,4,3,7],[3,8,3,9],[3,10,3,12],[15,0,15,2],[15,5,15,8],[36,0,36,1],[44,0,44,1],[4,10,4,12],[5,10,5,12],[48,0,48,1],[14,0,14,2],[6,10,6,12],[12,9,12,12],[13,5,13,8],[13,9,13,10],[7,4,7,7],[7,8,7,9],[7,10,7,12],[8,1,8,12],[10,0,10,3],[12,0,12,3],[12,4,12,8],[6,4,6,7],[6,8,6,9],[7,1,7,2],[0,0,0,2],[2,1,2,2],[4,1,4,2],[6,1,6,2],[5,1,5,2],[3,1,3,2]]}
["Bridge Data"]
[]
["District    ",2,null,"Structure Number","P2630001901501",null,null,null,"Bridge Name ",null,"Canal #14/Bainbridge"]
["Parish   ",26,null,"Recall Number",100214,null,null,null,"Inspection Date",null,"04/27/2017"]
["Route","Bainbridge Ave",null,"Year Built",1970,null,null,null,"Overall",null,"7"]
["Bridge Posting","-",null,"Design Load","-",null,null,null,"Deck",null,"N"]
["Bridge Type","CONPIP",null,"Roadway Width","-",null,null,null,"Super",null,"N"]
["Bridge Length",22,null,"Plan Location","-",null,null,null,"Sub",null,"N"]
["Standard Plan","ASTM C76 (126\" diameter)"]
[]
["Bridge Load Rating Summary"]
[]
["Dead Load",null,null,null,"LRFR Evaluation Factors",null,null,null,null,"Traffic"]
["Surface Thickness (in)",null,null,30,"Condition Factor (φc)",1,null,null,null,"ADTT (one way)",null,null,5,null,"Yellow shaded areas are required input."]
["Wearing Surface Type",null,null,"-","System Factor (φs)",1,null,null,null,null,null,null,null,null,"Input a value or choose a option from a drop-down list."]
["Non-Structural Attachments",null,null,"-","Surface Rating ","-"]
[]
[]
[]
[]
["Pipe Information"]
["Pipe Type","Circular"]
["Pipe Size",48,"inches"]
["Wall Thickness","C","ASTM C76"]
["D-Load Rating",1350,"lb/ft"]
[]
[]
["Bedding"]
["Installation Type","No Bedding/No Backfill Spec"]
[]
[]
["Backfill"]
["Material","No Bedding/No Backfill Spec"]
[]
[]
["Installation Method (See Figures)"]
["Unknown"]
[]
[null,null,null,null,"Construction"]
["Water",null,null,null,null,null,"Fill thickenss above pipe (H)",{"$f":"D14/12","v":2.5},"ft"]
[null,"Yes",null,null,null,null,"Backfill unit weight",120,"pcf"]
[null,null,null," ",null,null,"Excavation Width (Bd)",110,"feet"]
[]
["Traffic Direction",null,null,null,"Transition Width"]
["Parallel to the pipe span",null,null,null,9.1999999999999993,null,null,null,"ft"]
[]
[]
["Pavement Type",null,null,null,"Section Loss"]
[" Asphalt",null,null,null,0,null,null,null,"in."]
[]
[]
["Live Load Distribution Factor",null,null,null,"Resistance Factor"]
[" ",{"$f":"IF(H40<2,1.15,(IF(B23<=24,1.15,(IF(B23>=96,1.75,0.6*(B23-24)/(96-24)+1.15)))))","v":1.3499999999999999},null,null,1]
[null," "]

{"sheet":"Summary","index":2,"n_rows":57,"n_cols":11,"rows_kept":57,"cut":false,"hidden":false,"merged":[[57,0,57,10],[58,0,58,10],[59,0,59,10],[60,0,60,10],[61,0,61,10],[54,1,54,3],[45,6,45,7],[45,12,45,13],[46,6,46,7],[46,12,46,13],[47,12,47,13],[51,1,51,3],[52,1,52,3],[52,4,52,5],[52,6,52,7],[53,1,53,3],[53,5,53,7],[40,0,40,1],[41,0,41,1],[43,6,43,8],[43,12,43,13],[20,0,22,0],[20,1,22,1],[20,2,20,5],[20,6,20,10],[21,2,22,2],[44,6,44,8],[44,12,44,13],[21,3,22,3],[21,4,22,4],[21,5,22,5],[21,6,22,6],[21,7,22,7],[21,8,22,8],[21,10,22,10],[18,0,18,2],[18,4,18,5],[18,8,18,10],[19,0,19,2],[19,8,19,10],[16,0,16,2],[16,4,16,5],[16,8,16,10],[17,0,17,2],[17,4,17,5],[17,8,17,10],[13,8,13,10],[14,0,14,2],[14,4,14,6],[14,8,14,10],[15,4,15,5],[15,8,15,10],[12,8,12,10],[7,1,7,2],[7,4,7,6],[7,8,7,10],[8,1,8,2],[8,4,8,6],[8,8,8,10],[9,1,9,2],[9,4,9,6],[9,8,9,10],[10,1,10,10],[11,8,11,10],[5,1,5,2],[5,4,5,6],[5,8,5,10],[6,1,6,2],[6,4,6,6],[6,8,6,10],[0,8,0,10],[1,0,1,10],[2,8,2,10],[3,8,3,10],[4,1,4,2],[4,4,4,6],[4,8,4,10]]}
[]
["  Bridge Load Rating Summary Sheet"]
["Bridge Data"]
[]
["District    ",{"$f":"Input!B3","v":2},null,"Structure Number",{"$f":"Input!E3","v":"P2630001901501"},null,null,"Bridge Name ",{"$f":"Input!K3","v":"Canal #14/Bainbridge"}]
["Parish   ",{"$f":"Input!B4","v":26},null,"Recall Number",{"$f":"Input!E4","v":100214},null,null,"Inspection Date",{"$f":"Input!K4","v":"04/27/2017"}]
["Route",{"$f":"Input!B5","v":"Bainbridge Ave"},null,"Year Built",{"$f":"Input!E5","v":1970},null,null,"Overall",{"$f":"Input!K5","v":"7"}]
["Bridge Posting",{"$f":"Input!B6","v":"-"},null,"Design Load",{"$f":"Input!E6","v":"-"},null,null,"Deck",{"$f":"Input!K6","v":"N"}]
["Bridge Type",{"$f":"Input!B7","v":"CONPIP"},null,"Roadway Width",{"$f":"Input!E7","v":"-"},null,null,"Super",{"$f":"Input!K7","v":"N"}]
["Bridge Length",{"$f":"Input!B8","v":22},null,"Plan Location"," ",null,null,"Sub",{"$f":"Input!K8","v":"N"}]
["Standard Plan",{"$f":"Input!B9","v":"ASTM C76 (126\" diameter)"}]
[]
["Bridge/Culvert Load Rating Summary"]
[]
["Dead Load",null,null,null,"LRFR Evaluation Factors",null,null,"Traffic"]
["Wearing Surface Thickness (in)",null,null," ","Condition Factor, super (φc)",null,{"$f":"Input!F14","v":1},"ADTT (one way)",{"$f":"Input!M14","v":5}]
["Wearing Surface Type",null,null," ","Condition Factor, sub (φc)"]
["Non-Structural Attachments",null,null,{"$f":"Input!D16","v":"-"},"System Factor, super (φs)",null,{"$f":"Input!F15","v":1}]
["Fill Thickness (in)",null,null,{"$f":"Input!D14","v":30},"System Factor, sub (φs)"]
[]
["Vehicle Type","GVW (kips)","Superstructure/Deck/Culvert",null,null,null,"Substructure"]
[null,null,"Rating Factor","Rating Weight (tons)","Controlling Member","Controlling Load Effect","Rating Factor","Posting Weight (tons)","Controlling Member",null,"Controlling Load Effect"]
[]
["HL-93 (INV)","N/A",1.0351596986768254,null,"N/A","D-Load"]
["HL-93 (OPR)","N/A",1.3418736834699587,null,"N/A","D-Load"]
["LADV-11(INV)","N/A"]
["LA Type 3",41,2.1738353672213337,{"$f":"+Calcs!G20","v":44.563625028037343},"N/A","D-Load",null,{"$f":"IF(ISNUMBER(G27),Calcs!M20,\"\")","v":""}]
["LA Type 3S2",73,2.1738353672213337,{"$f":"+Calcs!G26","v":79.344990903578676},"N/A","D-Load",null,{"$f":"IF(ISNUMBER(G28),Calcs!M21,\"\")","v":""}]
["Type 3-3",80,2.1738353672213337,{"$f":"+Calcs!G27","v":86.953414688853343},"N/A","D-Load",null,{"$f":"IF(ISNUMBER(G29),Calcs!M22,\"\")","v":""}]
["LA Type 6",80,1.8800738311103422,{"$f":"+Calcs!G28","v":75.202953244413692},"N/A","D-Load",null,{"$f":"IF(ISNUMBER(G30),Calcs!M23,\"\")","v":""}]
["LA Type 8",88,1.8800738311103422,{"$f":"+Calcs!G29","v":82.723248568855055},"N/A","D-Load",null,{"$f":"IF(ISNUMBER(G31),Calcs!M24,\"\")","v":""}]
["NRL",80,2.0459626985612553,{"$f":"+Calcs!G19","v":44.563625028037343},"N/A","D-Load",null,{"$f":"IF(ISNUMBER(G32),Calcs!M25,\"\")","v":""}]
["SU4",54,2.0459626985612553,{"$f":"+Calcs!G21","v":55.240992861153892},"N/A","D-Load",null,{"$f":"IF(ISNUMBER(G33),Calcs!M26,\"\")","v":""}]
["SU5",62,2.0459626985612553,{"$f":"+Calcs!G22","v":63.424843655398917},"N/A","D-Load",null,{"$f":"IF(ISNUMBER(G34),Calcs!M27,\"\")","v":""}]
["SU6",69.5,2.0459626985612553,{"$f":"+Calcs!G23","v":71.097203775003621},"N/A","D-Load",null,{"$f":"IF(ISNUMBER(G35),Calcs!M28,\"\")","v":""}]
["SU7",77.5,2.0459626985612553,{"$f":"+Calcs!G24","v":79.281054569248639},"N/A","D-Load",null,{"$f":"IF(ISNUMBER(G36),Calcs!M29,\"\")","v":""}]
["Lane-Type I","N/A"]
["Lane Type II","N/A"]
[]
[]
[]
[]
["Posting Analysis Summary",null,null,null,null,"Please Check the following boxes that apply:"]
[null,null,null,null,null,null,"Plans do not exist"]
["Governing Rating Factor",null,null,{"$f":"Calcs!F31","v":1.8800738311103422},null,null,"Exterior girder controls the load rating"]
["Governing Load Model",null,null,{"$f":"+Calcs!B31","v":"LA Type 6"},null," ","As-designed rating"]
["Recommended Posting Load",null,null,{"$f":"+Calcs!H31","v":"No Limit"},null,null,"Striped lane rating"]
[]
[]
["QC/QA"]
[]
["Rated By:"]
["Checked By:",null,null,null,"Design Project Number:"]
["QA By:",null,null,null,"Rating Software:"]
["Date Rated:"]
[]
["NOTES"]

{"sheet":"Transition Width","index":3,"n_rows":0,"n_cols":0,"rows_kept":0,"cut":false,"hidden":false,"merged":[]}

{"sheet":"Calcs","index":4,"n_rows":31,"n_cols":13,"rows_kept":31,"cut":false,"hidden":true,"merged":[[1,1,1,4],[18,0,24,0],[25,0,29,0]]}
[]
[null,"Posting Sign Table"]
[null,"Group A","Group B"," Sign #","Post Sign"]
[null,0,0,1,"Closed"]
[null,3,3,2,"3"]
[null,4,4,3,"4"]
[null,5,5,4,"5"]
[null,10,15,5,"10-15"]
[null,15,25,6,"15-25"]
[null,20,35,7,"20-35"]
[null,25,40,8,"25-40"]
[null,"<=25",">40",9,"25-NL"]
[null,"<=30",">40",10,"30-NL"]
[null,"<=35",">40",11,"35-NL"]
[null,">35",">40",12,"No Limit"]
[]
[]
[null,"Vehicle Type","GVW (kips)","Super RF","Sub RF","Min RF","Post Weight"," Post Sign ","Sign #",null,"WT IF RF<1",null,"Sub WT"]
["Group A","NRL",80,{"$f":"+Summary!C32","v":2.0459626985612553},{"$f":"+Summary!G32","v":0},{"$f":"IF(E19=0,D19,MIN(D19:E19))","v":2.0459626985612553},{"$f":"PostingWeight(F20,C20)","v":44.563625028037343},null,null,null,null,null,{"$f":"INT((IF(E19<0.3,0,IF(AND(E19>=0.3,E19<1),(C19/(2*0.7))*(E19-0.3),IF(E19>=1,(C19/2)*(E19),\"error\")))*100+0.5))/100","v":0}]
[null,"LA Type 3",41,{"$f":"Summary!C27","v":2.1738353672213337},{"$f":"Summary!G27","v":0},{"$f":"IF(E20=0,D20,MIN(D20:E20))","v":2.1738353672213337},{"$f":"PostingWeight(F20,C20)","v":44.563625028037343},{"$f":"postingsignA(G20,F20,MinRatingB)","v":"No Limit"},{"$f":"INDEX($D$4:$D$15,MATCH($H20,$E$4:$E$15,0))","v":12},null,{"$f":"IF(F20<1,PostingWeight(F20,C20), 40)","v":40},null,{"$f":"INT((IF(E20<0.3,0,IF(AND(E20>=0.3,E20<1),(C20/(2*0.7))*(E20-0.3),IF(E20>=1,(C20/2)*(E20),\"error\")))*100+0.5))/100","v":0}]
[null,"SU4",54,{"$f":"Summary!C33","v":2.0459626985612553},{"$f":"Summary!G33","v":0},{"$f":"IF(E21=0,D21,MIN(D21:E21))","v":2.0459626985612553},55.240992861153892,{"$f":"postingsignA(G21,F21,MinRatingB)","v":"No Limit"},{"$f":"INDEX($D$4:$D$15,MATCH($H21,$E$4:$E$15,))","v":12},null,{"$f":"IF(F21<1,PostingWeight(F21,C21), 40)","v":40},null,{"$f":"INT((IF(E21<0.3,0,IF(AND(E21>=0.3,E21<1),(C21/(2*0.7))*(E21-0.3),IF(E21>=1,(C21/2)*(E21),\"error\")))*100+0.5))/100","v":0}]
[null,"SU5",62,{"$f":"Summary!C34","v":2.0459626985612553},{"$f":"Summary!G34","v":0},2.0459626985612553,63.424843655398917,{"$f":"postingsignA(G22,F22,MinRatingB)","v":"No Limit"},{"$f":"INDEX($D$4:$D$15,MATCH($H22,$E$4:$E$15,))","v":12},null,40,null,0]
[null,"SU6",69.5,{"$f":"Summary!C35","v":2.0459626985612553},{"$f":"Summary!G35","v":0},2.0459626985612553,71.097203775003621,{"$f":"postingsignA(G23,F23,MinRatingB)","v":"No Limit"},{"$f":"INDEX($D$4:$D$15,MATCH($H23,$E$4:$E$15,))","v":12},null,40,null,0]
[null,"SU7",77.5,{"$f":"Summary!C36","v":2.0459626985612553},{"$f":"Summary!G36","v":0},2.0459626985612553,79.281054569248639,{"$f":"postingsignA(G24,F24,MinRatingB)","v":"No Limit"},{"$f":"INDEX($D$4:$D$15,MATCH($H24,$E$4:$E$15,))","v":12},null,40,null,0]
[null,{"$f":"IF(F25>=1,INDEX(B20:B24,MATCH(F25,F20:F24,0)),INDEX(B20:B24,MATCH($G$25,$G20:$G24,0)))","v":"SU4"},null,null,null,{"$f":"MIN(F20:F24)","v":2.0459626985612553},{"$f":"IF(I25=12,INDEX(G20:G24,MATCH(F25,F20:F24,0)),K25)","v":55.240992861153892},{"$f":"INDEX(H20:H24,MATCH($G$25,$G20:$G24,0))","v":"No Limit"},{"$f":"+MIN(I20:I24)","v":12},null,{"$f":"IF(I25=12,0,IF(MAX(K20:K24)=0,0,SMALL(K20:K24,COUNTIF(K20:K24,0)+1)))","v":0}]
["Group B","LA Type 3S2",73,{"$f":"Summary!C28","v":2.1738353672213337},{"$f":"Summary!G28","v":0},{"$f":"IF(E26=0,D26,MIN(D26:E26))","v":2.1738353672213337},{"$f":"PostingWeight(F26,C26)","v":79.344990903578676},{"$f":"postingsignB(G26, F26)","v":"No Limit"},{"$f":"INDEX($D$4:$D$15,MATCH($H26,$E$4:$E$15,))","v":12},null,{"$f":"IF(F26<1,PostingWeight(F26,C26), 40)","v":40},null,0]
[null,"Type 3-3",80,{"$f":"Summary!C29","v":2.1738353672213337},{"$f":"Summary!G29","v":0},2.1738353672213337,{"$f":"PostingWeight(F27,C27)","v":86.953414688853343},{"$f":"postingsignB(G27, F27)","v":"No Limit"},{"$f":"INDEX($D$4:$D$15,MATCH($H27,$E$4:$E$15,))","v":12},null,{"$f":"IF(F27<1,PostingWeight(F27,C27), 40)","v":40},null,0]
[null,"LA Type 6",80,{"$f":"Summary!C30","v":1.8800738311103422},{"$f":"Summary!G30","v":0},1.8800738311103422,75.202953244413692,"No Limit",{"$f":"INDEX($D$4:$D$15,MATCH($H28,$E$4:$E$15,))","v":12},null,40,null,0]
[null,"LA Type 8",88,{"$f":"Summary!C31","v":1.8800738311103422},{"$f":"Summary!G31","v":0},1.8800738311103422,82.723248568855055,"No Limit",{"$f":"INDEX($D$4:$D$15,MATCH($H29,$E$4:$E$15,))","v":12},null,40,null,0]
[null,{"$f":"IF(F30>=1,INDEX(B26:B29,MATCH(F30,F26:F30,0)),INDEX(B26:B29,MATCH($G$30,$G26:$G29,0)))","v":"LA Type 6"},null,null,null,{"$f":"MIN(F26:F29)","v":1.8800738311103422},{"$f":"IF(I30=12,INDEX(G26:G29,MATCH(F30,F26:F29,0)),K30)","v":75.202953244413692},{"$f":"INDEX(H26:H29,MATCH($G$30,$G26:$G29,0))","v":"No Limit"},{"$f":"MIN(I26:I29)","v":12},null,{"$f":"IF(I30=12,0,IF(MAX(K26:K29)=0,0,SMALL(K26:K29,COUNTIF(K26:K29,0)+1)))","v":0}]
["Critical",{"$f":"IF(F31>=1,INDEX(B20:B29,MATCH(F31,F20:F29,0)),INDEX(B20:B29,MATCH($G$31,$G20:$G29,0)))","v":"LA Type 6"},null,null,null,{"$f":"IF(I31=9,SMALL(F$20:F$29,COUNTIF($F$20:$F$29,0)+1),INDEX(F20:F29,MATCH($G$31,$G20:$G29,0)))","v":1.8800738311103422},{"$f":"IF(I25<I30,G25,G30)","v":75.202953244413692},{"$f":"INDEX(H20:H29,MATCH($I$31,$I20:$I29,0))","v":"No Limit"},{"$f":"MIN(I25,I30)","v":12}]

{"sheet":"Options","index":5,"n_rows":99,"n_cols":18,"rows_kept":99,"cut":false,"hidden":true,"merged":[[47,1,47,4],[48,11,48,13]]}
["Pipe Shape",null,null,null,"Trench Friction",null,null,null,null,"Pipe Wall Thickness"]
["Circular",null,null,null,null,0.19239999999999999,null,null,null,"Pipe Size","A","B","C"]
["Elliptical",null,null,null,null,0.16500000000000001,null,null,null,12,1.75,2,2.75]
["Arch",null,null,null,null,0.15,null,null,null,15,1.875,2.25,3]
[null,null,null,null,null,0.13,null,null,null,18,2,2.5,3.25]
[null,null,null,null,null,0.11,null,null,null,21,2.25,2.75,3.5]
["Pipe Info.","(ASTM C76)","D-Load",null,null,null,null,null,null,24,2.5,3,3.75]
["Class","Crack","Ultimate",null,null,null,null,null,null,27,2.625,3.25,4]
[1,800,1000,null,null,null,null,null,null,30,2.75,3.5,4.25]
[2,1000,1500,null,null,null,null,null,null,33,2.875,3.75,4.5]
[3,1350,2000,null,null,null,null,null,null,36,3,4,4.75]
[4,2000,3000,null,null,null,null,null,null,42,3.5,4.5,5.25]
[5,3000,3750,null,null,null,null,null,null,48,4,5,5.75]
[null,null,null,null,null,null,null,null,null,54,4.5,5.5,6.25]
[null,null,null,null,null,null,null,null,null,60,5,6,6.75]
["Backfill and Bedding","(DOTD Standard Specifications for Roads and Bridges - Section 701.08)",null,null,null,null,null,null,null,66,5.5,6.5,7.25]
["DOTD Type A",null," - Stones, Recycled Concrete, Flowable Fill, or RAP",null,null,null,null,null,null,72,6,7,7.75]
["DOTD Type B",null," - Select soils, Granular Material",null,null,null,null,null,null,78,6.5,7.5,8.25]
["No Bedding/No Backfill Spec",null,null,null,null,null,null,null,null,84,7,8,8.75]
[null,null,null,null,null,null,null,null,null,90,7.5,8.5,9.25]
[null,null,null,null,null,null,null,null,null,96,8,9,9.75]
["Installation",null,null,null,null,null,null,null,null,102,8.5,9.5,10.25]
["Trench",null,null,null,null,null,null,null,null,108,9,10,10.75]
["Embankment (positive projecting)",null,null,null,null,null,null,null,null,114,9.5,9.5,9.5]
["Embankment (negative projecting)",null,null,null,null,null,null,null,null,120,10,10,10]
["Unknown",null,null,null,null,null,null,null,null,126,10.5,10.5,10.5]
[" ",null,null,null,null,null,null,null,null,132,11,11,11]
["Load Direction",null,null,null,null,null,null,null,null,138,11.5,11.5,11.5]
["Parallel to the pipe span",null,null,null,null,null,null,null,null,144,12,12,12]
["Perpendicular to the pipe span",null,null,null,null,null,null,null,null,150,12.5,12.5,12.5]
[null,null,null,null,null,null,null,null,null,156,13,13,13]
[null,null,null,null,null,null,null,null,null,162,13.5,13.5,13.5]
["Surface Pavement",null,null,null,null,null,null,null,null,168,14,14,14]
[" Concrete",null,null,null,null,null,null,null,null,174,14.5,14.5,14.5]
[" Asphalt",null,null,null,null,null,null,null,null,180,15,15,15]
[" Stone"]
[" No Pavement"]
[null,null,null,null,null,null,null,null,null,"Arching Coefficient"]
[null,null,null,null,null,null,null,null,null,1,1.35]
["Live Load Distribution Factor",null,null,null,null,null,null,null,null,2,1.4]
["AASHTO",null,null,null,null,null,null,null,null,3,1.4]
[1,null,null,null,null,null,null,null,null,4,1.45]
[1.1499999999999999]
[1.5]
[1.75,null,null,null,null,null,null,null,null,"Water Load Options"]
[null,null,null,null,null,null,null,null,null,"Yes"]
["Bedding Factors (Bfe)",null,null,null,null,null,null,null,null,"No"]
[null,"Embankment"]
[null,"Type 1","Type 2","Type 3","Type 4",null,null,null,null,"Live Load Factor",null,"ADTT"]
[12,4.4000000000000004,3.2,2.5,1.7,null,null,null,null,null,null,100,1000,5000]
[18,4.3,3.1,2.4500000000000002,1.7,null,null,null,null,"HL-93 Truck Inventory",null,1.75,1.75,1.75]
[24,4.2,3,2.4,1.7,null,null,null,null,"HL-93 Truck Operating",null,1.35,1.35,1.35]
[30,4.0999999999999996,2.95,2.35,1.7,null,null,null,null,"HL-93 Tandem Inventory",null,1.75,1.75,1.75]
[36,4,2.9,2.2999999999999998,1.7,null,null,null,null,"HL-93 Tandem Operating",null,1.35,1.35,1.35]
[42,{"$f":"($A55-$A$54)/($A$60-$A$54)*(B$60-B$54)+B$54","v":3.9666666666666668},{"$f":"($A55-$A$54)/($A$60-$A$54)*(C$60-C$54)+C$54","v":2.8833333333333333},{"$f":"($A55-$A$54)/($A$60-$A$54)*(D$60-D$54)+D$54","v":2.2833333333333332},{"$f":"($A55-$A$54)/($A$60-$A$54)*(E$60-E$54)+E$54","v":1.7},null,null,null,null,"LA Type 3",null,1.3,1.3,1.45]
[48,{"$f":"($A56-$A$54)/($A$60-$A$54)*(B$60-B$54)+B$54","v":3.9333333333333331},2.8666666666666667,2.2666666666666666,1.7,null,null,null,null,"LA Type 3S2",null,1.3,1.3,1.45]
[54,3.9,2.8499999999999996,2.25,1.7,null,null,null,null,"LA Type 3-3",null,1.3,1.3,1.45]
[60,3.8666666666666667,2.833333333333333,2.2333333333333334,1.7,null,null,null,null,"LA Type 6",null,1.3,1.3,1.45]
[66,3.833333333333333,2.8166666666666664,2.2166666666666668,1.7,null,null,null,null,"LA Type 8",null,1.3,1.3,1.45]
[72,3.8,2.8,2.2000000000000002,1.7,null,null,null,null,"NRL",null,1.3,1.3,1.45]
[84,{"$f":"($A61-$A$60)/($A$68-$A$60)*(B$68-B$60)+B$60","v":3.7666666666666666},2.8,2.2000000000000002,1.7,null,null,null,null,"SU4",null,1.3,1.3,1.45]
[90,3.75,2.8,2.2000000000000002,1.7,null,null,null,null,"SU5",null,1.3,1.3,1.45]
[96,3.7333333333333334,2.8,2.2000000000000002,1.7,null,null,null,null,"SU6",null,1.3,1.3,1.45]
[108,3.7,2.8,2.2000000000000002,1.7,null,null,null,null,"SU7",null,1.3,1.3,1.45]
[120,3.6666666666666665,2.8,2.2000000000000002,1.7]
[126,3.65,2.8,2.2000000000000002,1.7]
[132,3.6333333333333333,2.8,2.2000000000000002,1.7]
[144,3.6,2.8,2.2000000000000002,1.7]
[]
["Bedding Factors (Bfo)"]
["Type 1",2.2999999999999998]
["Type 2",1.9]
["Type 3",1.7]
["Type 4",1.5]
["Bedding Factors (BfLL)"]
[null,12,24,30,36,42,48,54,60,66,72,84,90,96,108,120,126,144]
[0.5,2.2000000000000002,1.7,{"$f":"(C77+E77)/2","v":1.5499999999999998},1.4,{"$f":"(E77+G77)/2","v":1.35},1.3,{"$f":"(G77+I77)/2","v":1.3},1.3,{"$f":"AVERAGE(I77,K77)","v":1.2000000000000002},1.1000000000000001,1.1000000000000001,{"$f":"AVERAGE(L77,N77)","v":1.1000000000000001},1.1000000000000001,1.1000000000000001,1.1000000000000001,{"$f":"($Q$76-$P$76)/($R$76-$P$76)*(R77-P77)+P77","v":1.1000000000000001},1.1000000000000001]
[1,2.2000000000000002,2.2000000000000002,{"$f":"(C78+E78)/2","v":1.9500000000000002},1.7,{"$f":"(E78+G78)/2","v":1.6},1.5,{"$f":"(G78+I78)/2","v":1.45},1.4,{"$f":"AVERAGE(I78,K78)","v":1.35},1.3,1.3,{"$f":"AVERAGE(L78,N78)","v":1.3},1.3,1.1000000000000001,1.1000000000000001,{"$f":"($Q$76-$P$76)/($R$76-$P$76)*(R78-P78)+P78","v":1.1000000000000001},1.1000000000000001]
[1.5,2.2000000000000002,2.2000000000000002,{"$f":"(C79+E79)/2","v":2.1500000000000004},2.1,1.9500000000000002,1.8,1.65,1.5,1.45,1.4,1.4,1.35,1.3,1.3,1.3,1.25,1.1000000000000001]
[2,2.2000000000000002,2.2000000000000002,2.2000000000000002,2.2000000000000002,2.1,2,1.9,1.8,1.65,1.5,1.5,1.45,1.4,1.4,1.3,1.3,1.3]
[2.5,2.2000000000000002,2.2000000000000002,2.2000000000000002,2.2000000000000002,2.2000000000000002,2.2000000000000002,2.1,2,1.9,1.8,1.7,1.6,1.5,1.4,1.4,1.375,1.3]
[3,2.2000000000000002,2.2000000000000002,2.2000000000000002,2.2000000000000002,2.2000000000000002,2.2000000000000002,2.2000000000000002,2.2000000000000002,2.2000000000000002,2.2000000000000002,1.8,1.75,1.7,1.5,1.5,1.4750000000000001,1.4]
[3.5,2.2000000000000002,2.2000000000000002,2.2000000000000002,2.2000000000000002,2.2000000000000002,2.2000000000000002,2.2000000000000002,2.2000000000000002,2.2000000000000002,2.2000000000000002,1.9,1.85,1.8,1.7,1.5,1.4750000000000001,1.4]
[4,2.2000000000000002,2.2000000000000002,2.2000000000000002,2.2000000000000002,2.2000000000000002,2.2000000000000002,2.2000000000000002,2.2000000000000002,2.2000000000000002,2.2000000000000002,2.1,2,1.9,1.8,1.7,1.65,1.5]
[4.5,2.2000000000000002,2.2000000000000002,2.2000000000000002,2.2000000000000002,2.2000000000000002,2.2000000000000002,2.2000000000000002,2.2000000000000002,2.2000000000000002,2.2000000000000002,2.2000000000000002,2.1,2,1.9,1.8,1.7749999999999999,1.7]
[5,2.2000000000000002,2.2000000000000002,2.2000000000000002,2.2000000000000002,2.2000000000000002,2.2000000000000002,2.2000000000000002,2.2000000000000002,2.2000000000000002,2.2000000000000002,2.2000000000000002,2.2000000000000002,2.2000000000000002,2,1.9,1.875,1.8]
[50,2.2000000000000002,2.2000000000000002,2.2000000000000002,2.2000000000000002,2.2000000000000002,2.2000000000000002,2.2000000000000002,2.2000000000000002,2.2000000000000002,2.2000000000000002,2.2000000000000002,2.2000000000000002,2.2000000000000002,2,1.9,1.875,1.8]
[]
[null,{"$f":"$A77/B$76","v":4.1666666666666664E-2},{"$f":"$A77/C$76","v":2.0833333333333332E-2},1.6666666666666666E-2,1.3888888888888888E-2,1.1904761904761904E-2,1.0416666666666666E-2,9.2592592592592587E-3,8.3333333333333332E-3,7.575757575757576E-3,{"$f":"$A77/K$76","v":6.9444444444444441E-3},5.9523809523809521E-3,{"$f":"$A77/M$76","v":5.5555555555555558E-3},5.208333333333333E-3,4.6296296296296294E-3,4.1666666666666666E-3,{"$f":"$A77/Q$76","v":3.968253968253968E-3},3.472222222222222E-3]
[null,{"$f":"$A78/B$76","v":8.3333333333333329E-2},4.1666666666666664E-2,3.3333333333333333E-2,2.7777777777777776E-2,2.3809523809523808E-2,2.0833333333333332E-2,1.8518518518518517E-2,1.6666666666666666E-2,1.5151515151515152E-2,{"$f":"$A78/K$76","v":1.3888888888888888E-2},1.1904761904761904E-2,{"$f":"$A78/M$76","v":1.1111111111111112E-2},1.0416666666666666E-2,9.2592592592592587E-3,8.3333333333333332E-3,7.9365079365079361E-3,6.9444444444444441E-3]
[null,{"$f":"$A79/B$76","v":0.125},6.25E-2,0.05,4.1666666666666664E-2,3.5714285714285712E-2,3.125E-2,2.7777777777777776E-2,2.5000000000000001E-2,2.2727272727272728E-2,2.0833333333333332E-2,1.7857142857142856E-2,{"$f":"$A79/M$76","v":1.6666666666666666E-2},1.5625E-2,1.3888888888888888E-2,1.2500000000000001E-2,1.1904761904761904E-2,1.0416666666666666E-2]
[null,{"$f":"$A80/B$76","v":0.16666666666666666},8.3333333333333329E-2,6.6666666666666666E-2,5.5555555555555552E-2,4.7619047619047616E-2,4.1666666666666664E-2,3.7037037037037035E-2,3.3333333333333333E-2,3.0303030303030304E-2,2.7777777777777776E-2,2.3809523809523808E-2,{"$f":"$A80/M$76","v":2.2222222222222223E-2},2.0833333333333332E-2,1.8518518518518517E-2,1.6666666666666666E-2,1.5873015873015872E-2,1.3888888888888888E-2]
[null,{"$f":"$A81/B$76","v":0.20833333333333334},0.10416666666666667,8.3333333333333329E-2,6.9444444444444448E-2,5.9523809523809521E-2,5.2083333333333336E-2,4.6296296296296294E-2,4.1666666666666664E-2,3.787878787878788E-2,3.4722222222222224E-2,2.976190476190476E-2,{"$f":"$A81/M$76","v":2.7777777777777776E-2},2.6041666666666668E-2,2.3148148148148147E-2,2.0833333333333332E-2,1.984126984126984E-2,1.7361111111111112E-2]
[null,{"$f":"$A82/B$76","v":0.25},0.125,0.1,8.3333333333333329E-2,7.1428571428571425E-2,6.25E-2,5.5555555555555552E-2,0.05,4.5454545454545456E-2,4.1666666666666664E-2,3.5714285714285712E-2,{"$f":"$A82/M$76","v":3.3333333333333333E-2},3.125E-2,2.7777777777777776E-2,2.5000000000000001E-2,2.3809523809523808E-2,2.0833333333333332E-2]
[null,{"$f":"$A83/B$76","v":0.29166666666666669},0.14583333333333334,0.11666666666666667,9.7222222222222224E-2,8.3333333333333329E-2,7.2916666666666671E-2,6.4814814814814811E-2,5.8333333333333334E-2,5.3030303030303032E-2,4.8611111111111112E-2,4.1666666666666664E-2,{"$f":"$A83/M$76","v":3.888888888888889E-2},3.6458333333333336E-2,3.2407407407407406E-2,2.9166666666666667E-2,2.7777777777777776E-2,2.4305555555555556E-2]
[null,{"$f":"$A84/B$76","v":0.33333333333333331},0.16666666666666666,0.13333333333333333,0.1111111111111111,9.5238095238095233E-2,8.3333333333333329E-2,7.407407407407407E-2,6.6666666666666666E-2,6.0606060606060608E-2,5.5555555555555552E-2,4.7619047619047616E-2,{"$f":"$A84/M$76","v":4.4444444444444446E-2},4.1666666666666664E-2,3.7037037037037035E-2,3.3333333333333333E-2,3.1746031746031744E-2,2.7777777777777776E-2]
[null,{"$f":"$A85/B$76","v":0.375},0.1875,0.15,0.125,0.10714285714285714,9.375E-2,8.3333333333333329E-2,7.4999999999999997E-2,6.8181818181818177E-2,6.25E-2,5.3571428571428568E-2,{"$f":"$A85/M$76","v":0.05},4.6875E-2,4.1666666666666664E-2,3.7499999999999999E-2,3.5714285714285712E-2,3.125E-2]
[null,{"$f":"$A86/B$76","v":0.41666666666666669},0.20833333333333334,0.16666666666666666,0.1388888888888889,0.11904761904761904,0.10416666666666667,9.2592592592592587E-2,8.3333333333333329E-2,7.575757575757576E-2,6.9444444444444448E-2,5.9523809523809521E-2,{"$f":"$A86/M$76","v":5.5555555555555552E-2},5.2083333333333336E-2,4.6296296296296294E-2,4.1666666666666664E-2,3.968253968253968E-2,3.4722222222222224E-2]
[null,{"$f":"$A87/B$76","v":4.166666666666667},2.0833333333333335,1.6666666666666667,1.3888888888888888,1.1904761904761905,1.0416666666666667,0.92592592592592593,0.83333333333333337,0.75757575757575757,0.69444444444444442,0.59523809523809523,{"$f":"$A87/M$76","v":0.55555555555555558},0.52083333333333337,0.46296296296296297,0.41666666666666669,0.3968253968253968,0.34722222222222221]