{"text_format":"1","workbook":"xlsx","n_sheets":4,"sheets":["LoadFactors","PermitTruckData","SpecCheck","Revisions"],"not_rendered":{"charts":0,"images":2,"macros":1,"external_links":0,"defined_names":0,"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":"LoadFactors","index":0,"n_rows":22,"n_cols":4,"rows_kept":22,"cut":false,"hidden":false,"merged":[[0,1,0,3]]}
[null,"CTDOT Strength Live Load Factors"]
[]
[]
[null,"Bridge Length",4,"ft"]
[null,"ADTT",3600,"Trucks per Day"]
[null,"Analysis Type","Other"]
[null,"Bridge Type","Other"]
[null,"Vehicle","ɣLL","Permit Type"]
[null,"CT-P76.5",{"$f":"ROUNDUP(VLOOKUP(LoadFactors!B9,SpecCheck!E:K,7,FALSE),2)","v":1.39},"Routine - Unlimited"]
[null,"CT-P120(6)",{"$f":"VLOOKUP(LoadFactors!B10,SpecCheck!E:K,7,FALSE)","v":1.2650000000000001},"Routine - Unlimited"]
[null,"CT-P140(7)a",{"$f":"ROUNDUP(VLOOKUP(LoadFactors!B11,SpecCheck!E:K,7,FALSE),2)","v":1.27},"Routine - Unlimited"]
[null,"CT-P140(7)b",{"$f":"ROUNDUP(VLOOKUP(LoadFactors!B12,SpecCheck!E:K,7,FALSE),2)","v":1.27},"Routine - Unlimited"]
[null,"CT-P160(8)a",{"$f":"ROUNDUP(VLOOKUP(LoadFactors!B13,SpecCheck!E:K,7,FALSE),2)","v":1.27},"Routine - Unlimited"]
[null,"CT-P160(8)b",{"$f":"ROUNDUP(VLOOKUP(LoadFactors!B14,SpecCheck!E:K,7,FALSE),2)","v":1.27},"Routine - Unlimited"]
[null,"CT-P180(9)",{"$f":"ROUNDUP(VLOOKUP(LoadFactors!B15,SpecCheck!E:K,7,FALSE),2)","v":1.2},"Special - Mixed"]
[null,"CT-P200(10)",{"$f":"ROUNDUP(VLOOKUP(LoadFactors!B16,SpecCheck!E:K,7,FALSE),2)","v":1.2},"Special - Mixed"]
[null,"CT-P380",{"$f":"ROUNDUP(VLOOKUP(LoadFactors!B17,SpecCheck!E:K,7,FALSE),2)","v":1.1000000000000001},"Special - Escorted"]
[null,"CT-TLC",{"$f":"ROUNDUP(VLOOKUP(LoadFactors!B18,SpecCheck!E:K,7,FALSE),2)","v":1.2},"Special - Mixed"]
[null,"Legal",{"$f":"ROUNDUP(VLOOKUP(LoadFactors!B19,SpecCheck!E:K,7,FALSE),2)","v":1.4},"N/A"]
[null,"Emergency",{"$f":"ROUNDUP(VLOOKUP(LoadFactors!B20,SpecCheck!E:K,7,FALSE),2)","v":1.3},"N/A"]
[null,"Inventory",{"$f":"ROUNDUP(VLOOKUP(LoadFactors!B21,SpecCheck!E:K,7,FALSE),2)","v":1.75},"N/A"]
[null,"Operating",{"$f":"ROUNDUP(VLOOKUP(LoadFactors!B22,SpecCheck!E:K,7,FALSE),2)","v":1.35},"N/A"]

{"sheet":"PermitTruckData","index":1,"n_rows":27,"n_cols":29,"rows_kept":27,"cut":false,"hidden":false,"merged":[[25,7,26,7],[25,8,26,8],[25,2,26,2],[25,3,26,3],[25,4,26,4],[25,5,26,5],[25,6,26,6],[19,8,20,8],[21,8,22,8],[23,8,24,8],[7,8,8,8],[9,8,10,8],[11,8,12,8],[13,8,14,8],[15,8,16,8],[17,8,18,8],[17,7,18,7],[19,7,20,7],[21,7,22,7],[23,7,24,7],[7,6,8,6],[9,6,10,6],[11,6,12,6],[7,7,8,7],[9,7,10,7],[11,7,12,7],[13,7,14,7],[15,7,16,7],[13,6,14,6],[15,6,16,6],[17,6,18,6],[19,6,20,6],[21,6,22,6],[23,6,24,6],[7,5,8,5],[9,5,10,5],[11,5,12,5],[13,5,14,5],[15,5,16,5],[19,4,20,4],[21,4,22,4],[23,4,24,4],[17,5,18,5],[19,5,20,5],[21,5,22,5],[23,5,24,5],[17,4,18,4],[17,3,18,3],[19,3,20,3],[21,3,22,3],[23,3,24,3],[7,4,8,4],[9,4,10,4],[11,4,12,4],[13,4,14,4],[15,4,16,4],[7,3,8,3],[9,3,10,3],[11,3,12,3],[13,3,14,3],[15,3,16,3],[7,2,8,2],[9,2,10,2],[11,2,12,2],[13,2,14,2],[15,2,16,2],[17,2,18,2],[19,2,20,2],[21,2,22,2],[23,2,24,2],[5,3,6,3],[3,10,3,28],[3,2,4,2],[3,3,4,3],[3,4,4,4],[3,5,4,5],[3,6,4,6],[3,7,4,7],[3,8,4,8],[5,8,6,8],[5,7,6,7],[5,6,6,6],[5,5,6,5],[5,4,6,4],[5,2,6,2],[27,7,28,7],[27,8,28,8],[29,2,30,2],[29,3,30,3],[29,4,30,4],[29,5,30,5],[29,6,30,6],[29,7,30,7],[29,8,30,8],[27,2,28,2],[27,3,28,3],[27,4,28,4],[27,5,28,5],[27,6,28,6],[31,7,32,7],[31,8,32,8],[33,2,34,2],[33,3,34,3],[33,4,34,4],[33,5,34,5],[33,6,34,6],[33,7,34,7],[33,8,34,8],[31,2,32,2],[31,3,32,3],[31,4,32,4],[31,5,32,5],[31,6,32,6],[35,7,36,7],[35,8,36,8],[37,2,38,2],[37,3,38,3],[37,4,38,4],[37,5,38,5],[37,6,38,6],[37,7,38,7],[37,8,38,8],[35,2,36,2],[35,3,36,3],[35,4,36,4],[35,5,36,5],[35,6,36,6],[39,7,40,7],[39,8,40,8],[41,2,42,2],[41,3,42,3],[41,4,42,4],[41,5,42,5],[41,6,42,6],[41,7,42,7],[41,8,42,8],[39,2,40,2],[39,3,40,3],[39,4,40,4],[39,5,40,5],[39,6,40,6],[47,7,48,7],[47,8,48,8],[47,2,48,2],[47,3,48,3],[47,4,48,4],[47,5,48,5],[47,6,48,6],[43,7,44,7],[43,8,44,8],[45,2,46,2],[45,3,46,3],[45,4,46,4],[45,5,46,5],[45,6,46,6],[45,7,46,7],[45,8,46,8],[43,2,44,2],[43,3,44,3],[43,4,44,4],[43,5,44,5],[43,6,44,6]]}
[]
[]
[]
[null,null,"Vehicle","Permit Type","Frequency","Load Condition","Number of Axels","Gross Vehicle Weight (kips)","Vehicle Length (ft)",null,"Axel Number"]
[null,null,null,null,null,null,null,null,null,null,1,2,3,4,5,6,7,8,9,10,11,12,13,14,15,16,17,18,19]
[null,null,"CT-P76.5","Annual","Unlimited","Mixed",4,76.5,{"$f":"SUM(K6:AC6)","v":18.2},"Spacing (ft)",9.6,4.0999999999999996,4.5,0]
[null,null,null,null,null,null,null,null,null,"Axel Load (k)",13.5,18,22.5,22.5]
[null,null,"CT-P120(6)","Annual","Unlimited","Mixed",6,120,{"$f":"SUM(K8:AC8)","v":47},"Spacing (ft)",11,4,24,4,4,0]
[null,null,null,null,null,null,null,null,null,"Axel Load (k)",11,23,23,21,21,21]
[null,null,"CT-P140(7)a","Annual","Unlimited","Mixed",7,140,74.899999999999991,"Spacing (ft)",15.2,4.5,42.3,4.3,4.3,4.3,0]
[null,null,null,null,null,null,null,null,null,"Axel Load (k)",12,24,24,20,20,20,20]
[null,null,"CT-P140(7)b","Annual","Unlimited","Mixed",7,140,74.899999999999991,"Spacing (ft)",15.2,4.5,42.3,4.3,4.3,4.3,0]
[null,null,null,null,null,null,null,null,null,"Axel Load (k)",12,32,32,16,16,16,16]
[null,null,"CT-P160(8)a","Annual","Unlimited","Mixed",8,160,76.099999999999994,"Spacing (ft)",11.8,4.5,4.5999999999999996,42.3,4.3,4.3,4.3,0]
[null,null,null,null,null,null,null,null,null,"Axel Load (k)",12,22,22,22,20.5,20.5,20.5,20.5]
[null,null,"CT-P160(8)b","Annual","Unlimited","Mixed",8,160,67.7,"Spacing (ft)",10.3,4.5,4.5,35.799999999999997,4.2,4.2,4.2,0]
[null,null,null,null,null,null,null,null,null,"Axel Load (k)",12,24.67,24.67,24.67,18.5,18.5,18.5,18.5]
[null,null,"CT-P180(9)","Special","Single-Trip","Mixed",9,180,78.7,"Spacing (ft)",11.6,4,11.3,4.2,35,4.2,4.2,4.2,0]
[null,null,null,null,null,null,null,null,null,"Axel Load (k)",12,21,21,21,21,21,21,21,21]
[null,null,"CT-P200(10)","Special","Single-Trip","Mixed",9,180,74.999999999999986,"Spacing (ft)",10.1,4.2,4.5999999999999996,5.5,4.3,33.4,4.3,4.3,4.3,0]
[null,null,null,null,null,null,null,null,null,"Axel Load (k)",12,18.8,18.8,18.8,18.8,18.8,23.5,23.5,23.5,23.5]
[null,null,"CT-P380","Special","Single-Trip","Escorted",19,380,177.40000000000003,"Spacing (ft)",14.08,5,5,14.08,5,5,14.08,5,5,47,5,5,14.08,5,5,14.08,5,5,0]
[null,null,null,null,null,null,null,null,null,"Axel Load (k)",12.8,20.3,20.3,20.3,21,21,21,20.3,20.3,20.3,20.55,20.55,20.55,19.7,19.7,19.7,20.55,20.55,20.55]
[null,null,"CT-TLC","Special","Single-Trip","Mixed",9,279.60000000000002,84.77,"Spacing (ft)",9.6,4.0999999999999996,4.5,18,14.33,24.74,3,6.5,0]
[null,null,null,null,null,null,null,null,null,"Axel Load (k)",13.5,18,22.5,22.5,63.7,64.900000000000006,18,18,38.5]
[null,null,"CT-P204","Annual","Unlimited","Mixed",8,180,{"$f":"SUM(K26:AC26)","v":55},"Spacing (ft)",11,4,4,24,4,4,4,0]
[null,null,null,null,null,null,null,null,null,"Axel Load (k)",15,27,27,27,27,27,27,27]

{"sheet":"SpecCheck","index":2,"n_rows":16,"n_cols":11,"rows_kept":16,"cut":false,"hidden":false,"merged":[]}
[null,null,null,null,"Truck","PWR","AL","GVW","Start Axel","End Axel","LLF"]
[null,"Bridge Length",{"$f":"CONVERT(LoadFactors!C4,LoadFactors!D4,\"ft\")","v":4},"ft","Inventory",null,null,null,null,null,1.75]
[null,"ADTT",{"$f":"LoadFactors!C5","v":3600},null,"Operating",null,null,null,null,null,1.35]
[null,null,null,null,"Legal",null,null,null,null,null,1.3975]
[null,null,null,null,"Emergency",null,null,null,null,null,1.3]
[null,null,null,null,"CT-P76.5",null,0,22.5,4,1,1.3825000000000001]
[null,null,null,null,"CT-P120(6)",10.5,4,42,4,6,1.2650000000000001]
[null,null,null,null,"CT-P140(7)a",10.5,0,12,1,1,1.2650000000000001]
[null,null,null,null,"CT-P140(7)b",10.5,0,12,1,1,1.2650000000000001]
[null,null,null,null,"CT-P160(8)a",10.5,0,12,1,1,1.2650000000000001]
[null,null,null,null,"CT-P160(8)b",10.5,0,12,1,1,1.2650000000000001]
[null,null,null,null,"CT-P180(9)",null,null,null,null,null,1.2]
[null,null,null,null,"CT-P200(10)",null,null,null,null,null,1.2]
[null,null,null,null,"CT-P380",null,null,null,null,null,1.1000000000000001]
[null,null,null,null,"CT-TLC",null,null,null,null,null,1.2]
[null,null,null,null,"CT-P204",10.5,0,15,1,1,1.2650000000000001]

{"sheet":"Revisions","index":3,"n_rows":11,"n_cols":5,"rows_kept":11,"cut":false,"hidden":false,"merged":[]}
[]
[]
[]
[]
[]
["#","Verision","Date","By","Description"]
[1,1.1000000000000001,"2017-04-03","cmp","Expanded Legal Functatility to RC Box Culvert"]
[2,1.1000000000000001,"2017-04-03","cmp","Formatting"]
[3,2,"2017-12-18","cmp","Added Emergency Vehicles"]
[4,2,"2017-12-19","cmp","moved Inventory, Operating, Legal, and Emergency ratings to SpecCheck"]
[5,2,"2017-03-29","cmp","updated permit classifications per BLRM 2018.1.0"]