{"text_format":"1","workbook":"xlsx","n_sheets":7,"sheets":["Manual Input Report","Culvert Report","Culvert Copy and Paste","Copy and Paste","Report ","README","Dropdown "],"not_rendered":{"charts":0,"images":27,"macros":1,"external_links":1,"defined_names":9,"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":"Manual Input Report","index":0,"n_rows":78,"n_cols":52,"rows_kept":78,"cut":false,"hidden":false,"merged":[[0,1,0,54],[2,13,2,22],[2,23,2,39],[2,40,2,44],[2,45,2,53],[3,13,3,22],[3,23,3,39],[3,41,3,44],[3,45,3,53],[9,2,9,17],[9,18,9,38],[9,39,9,44],[9,45,9,53],[11,3,11,17],[11,18,11,40],[11,41,11,44],[11,45,12,53],[5,35,5,44],[5,45,5,53],[6,4,6,20],[7,2,7,17],[7,18,7,37],[7,39,7,44],[7,45,7,53],[16,45,16,53],[16,54,16,55],[17,4,17,20],[13,4,13,17],[13,45,13,53],[15,5,15,17],[15,18,15,40],[15,41,15,44],[15,45,15,54],[13,18,13,37],[13,38,13,44],[21,4,21,20],[22,2,22,6],[22,7,22,16],[22,17,22,26],[22,27,22,33],[22,35,22,40],[16,5,16,17],[16,18,16,38],[16,39,16,44],[25,1,25,18],[25,19,25,29],[25,31,25,43],[25,44,25,54],[26,2,26,18],[26,19,26,31],[26,44,26,54],[22,41,22,45],[22,47,22,52],[22,53,23,54],[24,2,24,18],[24,19,24,29],[24,30,24,43],[24,44,24,54],[26,32,26,43],[35,25,35,27],[35,28,35,34],[35,35,35,37],[28,47,33,54],[31,6,34,10],[31,11,34,14],[31,15,34,17],[31,18,34,19],[31,20,34,24],[31,25,34,27],[31,38,34,39],[31,40,34,43],[31,44,34,46],[28,6,30,14],[28,15,30,19],[28,20,30,27],[28,28,34,34],[28,38,30,46],[34,35,34,37],[34,47,34,54],[28,1,34,5],[35,38,35,39],[35,40,35,43],[35,44,35,46],[35,47,35,54],[36,1,36,5],[36,6,36,10],[36,11,36,14],[36,15,36,17],[36,18,36,19],[36,20,36,24],[36,47,36,54],[36,25,36,27],[36,28,36,34],[36,35,36,37],[36,38,36,39],[36,40,36,43],[36,44,36,46],[35,1,35,5],[35,6,35,10],[35,11,35,14],[35,15,35,17],[35,18,35,19],[35,20,35,24],[37,47,37,54],[38,1,38,5],[38,6,38,10],[38,11,38,14],[38,15,38,17],[38,18,38,19],[38,20,38,24],[38,47,38,54],[38,25,38,27],[38,28,38,34],[38,35,38,37],[38,38,38,39],[38,40,38,43],[38,44,38,46],[37,1,37,5],[37,6,37,10],[37,11,37,14],[37,15,37,17],[37,18,37,19],[37,20,37,24],[37,25,37,27],[37,28,37,34],[37,35,37,37],[39,15,39,17],[39,18,39,19],[39,20,39,24],[39,25,39,27],[39,28,39,34],[39,35,39,37],[37,38,37,39],[37,40,37,43],[37,44,37,46],[41,20,41,24],[41,25,41,27],[41,28,41,34],[41,35,41,37],[39,38,39,39],[39,40,39,43],[39,44,39,46],[39,47,39,54],[40,1,40,5],[40,6,40,10],[40,11,40,14],[40,15,40,17],[40,18,40,19],[40,20,40,24],[40,47,40,54],[40,25,40,27],[40,28,40,34],[40,35,40,37],[40,38,40,39],[40,40,40,43],[40,44,40,46],[39,1,39,5],[39,6,39,10],[39,11,39,14],[43,28,43,34],[43,35,43,37],[41,38,41,39],[41,40,41,43],[41,44,41,46],[41,47,41,54],[42,1,42,5],[42,6,42,10],[42,11,42,14],[42,15,42,17],[42,18,42,19],[42,20,42,24],[42,47,42,54],[42,25,42,27],[42,28,42,34],[42,35,42,37],[42,38,42,39],[42,40,42,43],[42,44,42,46],[41,1,41,5],[41,6,41,10],[41,11,41,14],[41,15,41,17],[41,18,41,19],[43,38,43,39],[43,40,43,43],[43,44,43,46],[43,47,43,54],[44,1,44,5],[44,6,44,10],[44,11,44,14],[44,15,44,17],[44,18,44,19],[44,20,44,24],[44,47,44,54],[44,25,44,27],[44,28,44,34],[44,35,44,37],[44,38,44,39],[44,40,44,43],[44,44,44,46],[43,1,43,5],[43,6,43,10],[43,11,43,14],[43,15,43,17],[43,18,43,19],[43,20,43,24],[43,25,43,27],[45,38,45,39],[45,40,45,43],[45,44,45,46],[45,47,45,54],[46,1,46,5],[46,6,46,10],[46,11,46,14],[46,15,46,17],[46,18,46,19],[46,20,46,24],[45,1,45,5],[45,6,45,10],[45,11,45,14],[45,15,45,17],[45,18,45,19],[45,20,45,24],[45,25,45,27],[45,28,45,34],[45,35,45,37],[52,29,52,33],[52,36,52,44],[53,3,54,9],[53,16,53,27],[53,28,53,44],[54,16,54,27],[54,28,54,44],[46,47,46,54],[47,28,48,39],[49,2,51,13],[49,47,50,52],[50,14,50,27],[50,29,50,33],[50,37,50,44],[46,25,46,27],[46,28,46,34],[46,35,46,37],[46,38,46,39],[46,40,46,43],[46,44,46,46],[59,6,59,9],[60,6,60,9],[61,47,61,55],[63,1,64,11],[67,2,67,5],[67,6,67,11],[55,6,55,9],[55,16,55,27],[55,28,55,44],[57,6,57,9],[57,12,57,46],[58,6,58,9],[77,2,77,19],[77,45,77,48],[77,49,77,54],[80,27,80,44],[80,46,80,53],[69,2,69,5],[69,6,69,11],[71,2,71,5],[71,6,71,11],[71,46,71,52],[74,6,75,53]]}
[null,"Load Rating Summary"]
[]
[null,null,null,null,null,null,null,null,null,null,null,null,null,"Structure ID:",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,"Analyst:"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,"Location:",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,"QC By:"]
[]
[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,null,null,null,null,"Load Rating Date (B.LR.03):"]
[null,null,null,null,"Structure Identification"]
[null,null,"Feature Intersected:",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,null,null,null,null,null,"County:"]
[]
[null,null,"Material Main Span (B.SP.04):",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,null,null,null,null,null,"NHS Designation:"]
[]
[null,null,null,"Design for Main Span (B.SP.06):",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,null,null,null,null,null,null,"District:"]
[]
[null,null,null,null,"Year Built:",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,null,null,"Admin Owner:"]
[]
[null,null,null,null,null,"Maintainer:",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,null,null,null,null,"Name:"]
[null,null,null,null,null,"Owner:",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,null,null,"Emergency Route:"]
[null,null,null,null,"Description"]
[]
[]
[]
[null,null,null,null,"Ratings and Loads"]
[null,null,"Deck (B.C.01):",null,null,null,null,null,null,null,null,null,null,null,null,null,null,"SuperStructure (B.C.02):",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Substructure (B.C.03):",null,null,null,null,null,null,null,null,null,null,null,"Culvert (B.C.04):"]
[]
[null,null,"   Design Load (B.LR.01):",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,"Type of Overlay:"]
[null,"Design Method (B.LR.02):",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,"Overlay Thickness / Fill Height (in):"]
[null,null,"LR Method (B.LR.04):",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,"Load Posting Status (B.PS.01):"]
[]
[null,"  Truck",null,null,null,null,"Inventory\nRating",null,null,null,null,null,null,null,null,"Operating\nRating",null,null,null,null,"Legal",null,null,null,null,null,null,null,"Posting\nValue\n(tons)",null,null,null,null,null,null,null,null,null,"Control Location"]
[]
[]
[null,null,null,null,null,null," Rating Factor ",null,null,null,null,"Tons",null,null,null," Rating Factor ",null,null,"Tons ",null," Rating Factor ",null,null,null,null,"Tons",null,null,null,null,null,null,null,null,null,null,null,null,"Span",null,"Location\n(ft)",null,null,null,"Percent\nof\nSpan"]
[]
[]
[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,null,null,null,null,"Member",null,null,null,null,null,null,null,null,null,null,null,"Limit State"]
[null,"HS/HL93",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,"N/A"]
[null,"HS/HL93",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,"N/A"]
[null,"SU4",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,"SU5",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,"SU6",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,"SU7",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,"NE Type 3",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,{"$f":"IF('Dropdown '!B262= 0,\"\",'Dropdown '!B262)","v":""}]
[null,"NE Type 3S2",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,{"$f":"IF(U43<1,TRUNC(Z43),\"\")","v":0}]
[null,"NE Type 3-3",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,{"$f":"IF(U44<1,TRUNC(Z44),\"\")","v":0}]
[null,"EV2",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,"N/A"]
[null,"EV3",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,"N/A"]
[null,"Triple-Triple",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,"N/A"]
[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,"Documentation"]
[]
[]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Rating Information Provided:",null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Plans",null,null,null,null,null,null,null,"Field Measurements"]
[]
[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,"Testing",null,null,null,null,null,null,"No Information Exists "]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"BrR Computations Submitted:"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Analysis Engine Version:"]
[null,null,null,null,null,null,{"$f":"IF(AC42<>\"\",AC42&\"T\",\"t\")","v":"t"},null,null,null,null,null,null,null,null,null,"Rating Program Used: "]
[null,null,null,null,null,null,"0T"]
[null,null,null,null,null,null,{"$f":"IF(AC43<>\"\",AC43&\"T\",\"t\")","v":"0T"},null,null,null,null,null,"Additional Comments "]
[null,null,null,null,null,null,{"$f":"IF(AC45=\"\",\"t\",MIN('Dropdown '!B157:B162)&\"T\")","v":"0T"}]
[null,null,null,null,null,null,{"$f":"IF(AC44<>\"\",AC44&\"T\",\"t\")","v":"0T"}]
[null,null,null,null,null,null,{"$f":"IF(AC47=\"\",\"t\",MIN('Dropdown '!B159:B164)&\"T\")","v":"0T"},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,null,null,null,null,null,null,null,null,null,null,null,null,null,"2025-09-12"]
[]
[]
[null,"EMERGENCY VEHICLE AXEL WEIGHT LIMIT"]
[]
[]
[]
[null,null,"SINGLE"]
[]
[null,null,"TANDEM"]
[]
[null,null,"GROSS"]
[]
[]
[null,null,null,null,null,null,"The Rating and Posting Values for this structure is based on a theoretical analysis of the structural elements involved and on a limited amount of information concerning the structural condition. These weight limits are intended only as a general guideline and may be varied accordingly by the officials responsible for this structure after an investigation of the structural condition, reaction to vehicular loads and any other items where judgment is required to establish a proper weight limit."]
[]
[]
[null,null,"BR Form 465, version 2.0 [Updated:1 9 2026]",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,null,null,null,null,null,null,null,null,null,null,null,"Print Time:",null,null,null,"01/14/2026  02:26:59PM"]

{"sheet":"Culvert Report","index":1,"n_rows":78,"n_cols":54,"rows_kept":78,"cut":false,"hidden":true,"merged":[[0,1,0,54],[2,13,2,22],[2,23,2,39],[2,40,2,44],[2,45,2,53],[3,13,3,22],[3,23,3,39],[3,41,3,44],[3,45,3,53],[9,2,9,17],[9,18,9,38],[9,39,9,44],[9,45,9,53],[11,3,11,17],[11,18,11,40],[11,41,11,44],[11,45,12,53],[5,35,5,44],[5,45,5,53],[6,4,6,20],[7,2,7,17],[7,18,7,37],[7,39,7,44],[7,45,7,53],[16,45,16,53],[16,54,16,55],[17,4,17,20],[13,4,13,17],[13,45,13,53],[15,5,15,17],[15,18,15,40],[15,41,15,44],[15,45,15,54],[13,38,13,44],[13,18,13,37],[21,4,21,20],[22,2,22,6],[22,7,22,16],[22,17,22,26],[22,27,22,33],[22,35,22,40],[16,5,16,17],[16,18,16,38],[16,39,16,44],[25,1,25,18],[25,19,25,29],[25,31,25,43],[25,44,25,54],[26,2,26,18],[26,19,26,31],[26,44,26,54],[22,41,22,45],[22,47,22,52],[22,53,23,54],[24,2,24,18],[24,19,24,29],[24,30,24,43],[24,44,24,54],[26,32,26,43],[35,25,35,27],[35,28,35,34],[35,35,35,37],[28,47,33,54],[31,6,34,10],[31,11,34,14],[31,15,34,17],[31,18,34,19],[31,20,34,24],[31,25,34,27],[31,38,34,39],[31,40,34,43],[31,44,34,46],[28,6,30,14],[28,15,30,19],[28,20,30,27],[28,28,34,34],[28,38,30,46],[34,35,34,37],[34,47,34,54],[28,1,34,5],[35,38,35,39],[35,40,35,43],[35,44,35,46],[35,47,35,54],[36,1,36,5],[36,6,36,10],[36,11,36,14],[36,15,36,17],[36,18,36,19],[36,20,36,24],[36,47,36,54],[36,25,36,27],[36,28,36,34],[36,35,36,37],[36,38,36,39],[36,40,36,43],[36,44,36,46],[35,1,35,5],[35,6,35,10],[35,11,35,14],[35,15,35,17],[35,18,35,19],[35,20,35,24],[37,47,37,54],[38,1,38,5],[38,6,38,10],[38,11,38,14],[38,15,38,17],[38,18,38,19],[38,20,38,24],[38,47,38,54],[38,25,38,27],[38,28,38,34],[38,35,38,37],[38,38,38,39],[38,40,38,43],[38,44,38,46],[37,1,37,5],[37,6,37,10],[37,11,37,14],[37,15,37,17],[37,18,37,19],[37,20,37,24],[37,25,37,27],[37,28,37,34],[37,35,37,37],[39,15,39,17],[39,18,39,19],[39,20,39,24],[39,25,39,27],[39,28,39,34],[39,35,39,37],[37,38,37,39],[37,40,37,43],[37,44,37,46],[41,20,41,24],[41,25,41,27],[41,28,41,34],[41,35,41,37],[39,38,39,39],[39,40,39,43],[39,44,39,46],[39,47,39,54],[40,1,40,5],[40,6,40,10],[40,11,40,14],[40,15,40,17],[40,18,40,19],[40,20,40,24],[40,47,40,54],[40,25,40,27],[40,28,40,34],[40,35,40,37],[40,38,40,39],[40,40,40,43],[40,44,40,46],[39,1,39,5],[39,6,39,10],[39,11,39,14],[43,28,43,34],[43,35,43,37],[41,38,41,39],[41,40,41,43],[41,44,41,46],[41,47,41,54],[42,1,42,5],[42,6,42,10],[42,11,42,14],[42,15,42,17],[42,18,42,19],[42,20,42,24],[42,47,42,54],[42,25,42,27],[42,28,42,34],[42,35,42,37],[42,38,42,39],[42,40,42,43],[42,44,42,46],[41,1,41,5],[41,6,41,10],[41,11,41,14],[41,15,41,17],[41,18,41,19],[43,38,43,39],[43,40,43,43],[43,44,43,46],[43,47,43,54],[44,1,44,5],[44,6,44,10],[44,11,44,14],[44,15,44,17],[44,18,44,19],[44,20,44,24],[44,47,44,54],[44,25,44,27],[44,28,44,34],[44,35,44,37],[44,38,44,39],[44,40,44,43],[44,44,44,46],[43,1,43,5],[43,6,43,10],[43,11,43,14],[43,15,43,17],[43,18,43,19],[43,20,43,24],[43,25,43,27],[45,38,45,39],[45,40,45,43],[45,44,45,46],[45,47,45,54],[46,1,46,5],[46,6,46,10],[46,11,46,14],[46,15,46,17],[46,18,46,19],[46,20,46,24],[45,1,45,5],[45,6,45,10],[45,11,45,14],[45,15,45,17],[45,18,45,19],[45,20,45,24],[45,25,45,27],[45,28,45,34],[45,35,45,37],[52,29,52,33],[52,36,52,44],[53,3,54,9],[53,16,53,27],[53,28,53,44],[54,16,54,27],[54,28,54,44],[46,47,46,54],[47,28,48,39],[49,2,51,13],[49,47,50,52],[50,14,50,27],[50,29,50,33],[50,37,50,44],[46,25,46,27],[46,28,46,34],[46,35,46,37],[46,38,46,39],[46,40,46,43],[46,44,46,46],[59,6,59,9],[60,6,60,9],[63,1,64,11],[67,2,67,5],[67,6,67,11],[55,6,55,9],[55,16,55,27],[55,28,55,44],[57,6,57,9],[57,12,57,46],[58,6,58,9],[61,47,61,55],[77,2,77,19],[80,27,80,44],[80,46,80,53],[69,2,69,5],[69,6,69,11],[71,2,71,5],[71,6,71,11],[71,46,71,52],[74,6,75,53],[77,45,77,48],[77,49,77,54]]}
[null,"Load Rating Summary"]
[]
[null,null,null,null,null,null,null,null,null,null,null,null,null,"Structure ID:",null,null,null,null,null,null,null,null,null,"C006901205",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Analyst:",null,null,null,null,"A. Kime"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,"Location:",null,null,null,null,null,null,null,null,null,"5.5N 7.4E BERTRAND",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"QC By:",null,null,null,"T. Ismail"]
[]
[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,null,null,null,null,"Load Rating Date (B.LR.03):",null,null,null,null,null,null,null,null,null,"2026-05-07"]
[null,null,null,null,"Structure Identification"]
[null,null,"Feature Intersected:",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"IRRIGATION CANAL",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"County:",null,null,null,null,null,"Phelps(137)"]
[]
[null,null,"Material Main Span (B.SP.04):",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"C01 R/C- Cast in Place",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"NHS Designation:",null,null,null,null,null,"N Non-NHS"]
[]
[null,null,null,"Design for Main Span (B.SP.06):",null,null,null,null,null,null,null,null,null,null,null,null,null,null,"F02 Frame- Four Sided",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"District:",null,null,null,"District 7"]
[]
[null,null,null,null,"Year Built:",null,null,null,null,null,null,null,null,null,null,null,null,null,2026,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Admin Owner:",null,null,null,null,null,null,"Phelps County"]
[]
[null,null,null,null,null,"Maintainer:",null,null,null,null,null,null,null,null,null,null,null,null,"L01 County Highway Agency ",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Name:"]
[null,null,null,null,null,"Owner:",null,null,null,null,null,null,null,null,null,null,null,null,"L01 County Highway Agency ",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Emergency Route:",null,null,null,null,null,"N Not an Evac Emergency Rte"]
[null,null,null,null,"Description"]
[]
[]
[]
[null,null,null,null,"Ratings and Loads"]
[null,null,"Deck (B.C.01):",null,null,null,null,"N N/A ",null,null,null,null,null,null,null,null,null,"SuperStructure (B.C.02):",null,null,null,null,null,null,null,null,null,"N N/A ",null,null,null,null,null,null,null,"Substructure (B.C.03):",null,null,null,null,null,"N N/A ",null,null,null,null,null,"Culvert (B.C.04):",null,null,null,null,null,"9 Excellent "]
[]
[null,null,"   Design Load (B.LR.01):",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"HL93",null,null,null,null,null,null,null,null,null,null,"Type of Overlay:",null,null,null,null,null,null,null,null,null,null,null,null,null,"E01 Earth- Gravel or Soil"]
[null,"Design Method (B.LR.02):",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"LRFD",null,null,null,null,null,null,null,null,null,null,null,"Overlay Thickness / Fill Height (in):",null,null,null,null,null,null,null,null,null,null,null,null,48]
[null,null,"LR Method (B.LR.04):",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"LRFR",null,null,null,null,null,null,null,null,null,null,null,null,"Load Posting Status (B.PS.01):",null,null,null,null,null,null,null,null,null,null,null,"PO"]
[]
[null,"  Truck",null,null,null,null,"Inventory\nRating",null,null,null,null,null,null,null,null,"Operating\nRating",null,null,null,null,"Legal",null,null,null,null,null,null,null,"Posting\nValue\n(tons)",null,null,null,null,null,null,null,null,null,"Control Location"]
[]
[]
[null,null,null,null,null,null," Rating Factor ",null,null,null,null,"Tons",null,null,null," Rating Factor ",null,null,"Tons ",null," Rating Factor ",null,null,null,null,"Tons",null,null,null,null,null,null,null,null,null,null,null,null,"Span",null,"Location\n(ft)",null,null,null,"Percent\nof\nSpan"]
[]
[]
[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,null,null,null,null,"Member",null,null,null,null,null,null,null,null,null,null,null,"Limit State"]
[null,"HS/HL93",null,null,null,null,{"$f":"TRUNC('Dropdown '!G213,2)","v":1.51},null,null,null,null,{"$f":"G36*36","v":54.36},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"N/A",null,null,null,null,null,null,{"$f":"'Dropdown '!H215","v":"Top Slab"},null,null,{"$f":"'Dropdown '!I215","v":"1"},null,{"$f":"'Dropdown '!I213","v":2.4},null,null,null,{"$f":"'Dropdown '!J213","v":20},null,null,{"$f":"'Dropdown '!K213","v":"Flexure"}]
[null,"HS/HL93",null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"TRUNC('Dropdown '!G218,2)","v":1.96},null,null,{"$f":"'Dropdown '!F218","v":70.75},null,null,null,null,null,null,null,null,null,"N/A",null,null,null,null,null,null,{"$f":"'Dropdown '!H220","v":"Top Slab"},null,null,{"$f":"'Dropdown '!I220","v":"1"},null,{"$f":"'Dropdown '!I218","v":2.4},null,null,null,{"$f":"'Dropdown '!J218","v":20},null,null,{"$f":"'Dropdown '!K218","v":"Flexure"}]
[null,"SU4",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"TRUNC('Culvert Copy and Paste'!F11,2)","v":2.27},null,null,null,null,{"$f":"U38*27","v":61.29},null,null,"-",null,null,null,null,null,null,{"$f":"'Dropdown '!I232","v":"Bottom Slab"},null,null,{"$f":"'Dropdown '!J232","v":"3"},null,{"$f":"'Culvert Copy and Paste'!H11","v":7.2},null,null,null,{"$f":"'Culvert Copy and Paste'!I11","v":60},null,null,{"$f":"'Culvert Copy and Paste'!J11","v":"Flexure"}]
[null,"SU5",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"TRUNC('Culvert Copy and Paste'!F12,2)","v":2.25},null,null,null,null,{"$f":"U39*31","v":69.75},null,null,"-",null,null,null,null,null,null,{"$f":"'Dropdown '!I233","v":"Bottom Slab"},null,null,{"$f":"'Dropdown '!J233","v":"3"},null,{"$f":"'Culvert Copy and Paste'!H12","v":7.2},null,null,null,{"$f":"'Culvert Copy and Paste'!I12","v":60},null,null,{"$f":"'Culvert Copy and Paste'!J12","v":"Flexure"}]
[null,"SU6",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"TRUNC('Culvert Copy and Paste'!F13,2)","v":2.2799999999999998},null,null,null,null,{"$f":"U40*34.75","v":79.22999999999999},null,null,"-",null,null,null,null,null,null,{"$f":"'Dropdown '!I234","v":"Bottom Slab"},null,null,{"$f":"'Dropdown '!J234","v":"3"},null,{"$f":"'Culvert Copy and Paste'!H13","v":7.2},null,null,null,{"$f":"'Culvert Copy and Paste'!I13","v":60},null,null,{"$f":"'Culvert Copy and Paste'!J13","v":"Flexure"}]
[null,"SU7",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"TRUNC('Culvert Copy and Paste'!F14,2)","v":2.2999999999999998},null,null,null,null,{"$f":"U41*38.75","v":89.125},null,null,"-",null,null,null,null,null,null,{"$f":"'Dropdown '!I235","v":"Bottom Slab"},null,null,{"$f":"'Dropdown '!J235","v":"3"},null,{"$f":"'Culvert Copy and Paste'!H14","v":7.2},null,null,null,{"$f":"'Culvert Copy and Paste'!I14","v":60},null,null,{"$f":"'Culvert Copy and Paste'!J14","v":"Flexure"}]
[null,"NE Type 3",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"TRUNC('Culvert Copy and Paste'!F6,2)","v":2.33},null,null,null,null,{"$f":"U42*25","v":58.25},null,null,{"$f":"IF('Dropdown '!B245= 0,\"\",'Dropdown '!B245)","v":""},null,null,null,null,null,null,{"$f":"'Dropdown '!I227","v":"Top Slab"},null,null,{"$f":"'Dropdown '!J227","v":"1"},null,{"$f":"'Culvert Copy and Paste'!H6","v":2.4},null,null,null,{"$f":"'Culvert Copy and Paste'!I6","v":20},null,null,{"$f":"'Culvert Copy and Paste'!J6","v":"Flexure"}]
[null,"NE Type 3S2",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"TRUNC('Culvert Copy and Paste'!F7,2)","v":2.5499999999999998},null,null,null,null,{"$f":"U43*37","v":94.35},null,null,{"$f":"IF(U43<1,TRUNC(Z43),\"\")","v":""},null,null,null,null,null,null,{"$f":"'Dropdown '!I228","v":"Top Slab"},null,null,{"$f":"'Dropdown '!J228","v":"1"},null,{"$f":"'Culvert Copy and Paste'!H7","v":2.4},null,null,null,{"$f":"'Culvert Copy and Paste'!I7","v":20},null,null,{"$f":"'Culvert Copy and Paste'!J7","v":"Flexure"}]
[null,"NE Type 3-3",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"TRUNC('Culvert Copy and Paste'!F8,2)","v":2.83},null,null,null,null,{"$f":"U44*43","v":121.69},null,null,{"$f":"IF(U44<1,TRUNC(Z44),\"\")","v":""},null,null,null,null,null,null,{"$f":"'Dropdown '!I229","v":"Top Slab"},null,null,{"$f":"'Dropdown '!J229","v":"1"},null,{"$f":"'Culvert Copy and Paste'!H8","v":2.4},null,null,null,{"$f":"'Culvert Copy and Paste'!I8","v":20},null,null,{"$f":"'Culvert Copy and Paste'!J8","v":"Flexure"}]
[null,"EV2",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"TRUNC('Culvert Copy and Paste'!F9,2)","v":1.75},null,null,null,null,{"$f":"U45*28.75","v":50.3125},null,null,"N/A",null,null,null,null,null,null,{"$f":"'Dropdown '!I230","v":"Top Slab"},null,null,{"$f":"'Dropdown '!J230","v":"1"},null,{"$f":"'Culvert Copy and Paste'!H9","v":2.4},null,null,null,{"$f":"'Culvert Copy and Paste'!I9","v":20},null,null,{"$f":"'Culvert Copy and Paste'!J9","v":"Flexure"}]
[null,"EV3",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"TRUNC('Culvert Copy and Paste'!F10,2)","v":1.28},null,null,null,null,{"$f":"U46*43","v":55.04},null,null,"N/A",null,null,null,null,null,null,{"$f":"'Dropdown '!I231","v":"Top Slab"},null,null,{"$f":"'Dropdown '!J231","v":"1"},null,{"$f":"'Culvert Copy and Paste'!H10","v":2.4},null,null,null,{"$f":"'Culvert Copy and Paste'!I10","v":20},null,null,{"$f":"'Culvert Copy and Paste'!J10","v":"Flexure"}]
[null,"Triple-Triple",null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"TRUNC('Culvert Copy and Paste'!F15,2)","v":2.87},null,null,{"$f":"P47*70","v":200.9},null,null,null,null,null,null,null,null,null,"N/A",null,null,null,null,null,null,{"$f":"'Dropdown '!I236","v":"Bottom Slab"},null,null,{"$f":"'Dropdown '!J236","v":"3"},null,{"$f":"'Culvert Copy and Paste'!H15","v":7.2},null,null,null,{"$f":"'Culvert Copy and Paste'!I15","v":60},null,null,{"$f":"'Culvert Copy and Paste'!J15","v":"Flexure"}]
[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,"Documentation"]
[]
[]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Rating Information Provided:",null,null,null,null,null,null,null,null,null,null,null,null,null,"X","Plans",null,null,null,null,null,null,null,"Field Measurements"]
[]
[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,"Testing",null,null,null,null,null,null,"No Information Exists "]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"BrR Computations Submitted:",null,null,null,null,null,null,null,null,null,null,null,"Yes"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Analysis Engine Version:",null,null,null,null,null,null,null,null,null,null,null,"AASHTO LFR Engine Version 7.5.1.3001"]
[null,null,null,null,null,null,{"$f":"IF(AC42<>\"\",AC42&\"T\",\"t\")","v":"t"},null,null,null,null,null,null,null,null,null,"Rating Program Used: ",null,null,null,null,null,null,null,null,null,null,null,"0 AASHTOWare BrR"]
[null,null,null,null,null,null,"0T"]
[null,null,null,null,null,null,{"$f":"IF(AC43<>\"\",AC43&\"T\",\"t\")","v":"t"},null,null,null,null,null,"Additional Comments "]
[null,null,null,null,null,null,{"$f":"IF(AC45=\"\",\"t\",MIN('Dropdown '!B157:B162)&\"T\")","v":"0T"}]
[null,null,null,null,null,null,{"$f":"IF(AC44<>\"\",AC44&\"T\",\"t\")","v":"t"}]
[null,null,null,null,null,null,{"$f":"IF(AC47=\"\",\"t\",MIN('Dropdown '!B159:B164)&\"T\")","v":"0T"},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,null,null,null,null,null,null,null,null,null,null,null,null,null,"2025-09-12"]
[]
[]
[null,"EMERGENCY VEHICLE AXEL WEIGHT LIMIT"]
[]
[]
[]
[null,null,"SINGLE"]
[]
[null,null,"TANDEM"]
[]
[null,null,"GROSS"]
[]
[]
[null,null,null,null,null,null,"The Rating and Posting Values for this structure is based on a theoretical analysis of the structural elements involved and on a limited amount of information concerning the structural condition. These weight limits are intended only as a general guideline and may be varied accordingly by the officials responsible for this structure after an investigation of the structural condition, reaction to vehicular loads and any other items where judgment is required to establish a proper weight limit."]
[]
[]
[null,null,"BR Form 465, version 2.0 [Updated:1 9 2026]",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,null,null,null,null,null,null,null,null,null,null,null,"Print Time:",null,null,null,"05/07/2026  03:19:18PM"]

{"sheet":"Culvert Copy and Paste","index":2,"n_rows":15,"n_cols":18,"rows_kept":15,"cut":false,"hidden":true,"merged":[]}
["FROM BrR:",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Only Use for Culverts"]
["HL-93 (US)","Axle Load","LRFR","Inventory",62.09,1.7250000000000001,"Top Slab 2",12,100,"Flexure","As Requested","As Requested"]
["HL-93 (US)","Axle Load","LRFR","Operating",80.48,2.2360000000000002,"Top Slab 2",12,100,"Flexure","As Requested","As Requested"]
["HL-93 (US)","Tandem","LRFR","Inventory",54.58,1.516,"Top Slab 1",2.4,20,"Flexure","As Requested","As Requested"]
["HL-93 (US)","Tandem","LRFR","Operating",70.75,1.9650000000000001,"Top Slab 1",2.4,20,"Flexure","As Requested","As Requested"]
["1 NE Type 3","Axle Load","LRFR","Legal",58.38,2.335,"Top Slab 1",2.4,20,"Flexure","As Requested","As Requested"]
["2 NE Type 3S2","Axle Load","LRFR","Legal",94.52,2.5550000000000002,"Top Slab 1",2.4,20,"Flexure","As Requested","As Requested"]
["3 NE Type 3-3","Axle Load","LRFR","Legal",121.96,2.8359999999999999,"Top Slab 1",2.4,20,"Flexure","As Requested","As Requested"]
["EV2","Axle Load","LRFR","Legal",50.33,1.7509999999999999,"Top Slab 1",2.4,20,"Flexure","As Requested","As Requested"]
["EV3","Axle Load","LRFR","Legal",55.06,1.2809999999999999,"Top Slab 1",2.4,20,"Flexure","As Requested","As Requested"]
["SU4","Axle Load","LRFR","Legal",61.39,2.274,"Bottom Slab 3",7.2,60,"Flexure","As Requested","As Requested"]
["SU5","Axle Load","LRFR","Legal",69.930000000000007,2.2559999999999998,"Bottom Slab 3",7.2,60,"Flexure","As Requested","As Requested"]
["SU6","Axle Load","LRFR","Legal",79.349999999999994,2.2839999999999998,"Bottom Slab 3",7.2,60,"Flexure","As Requested","As Requested"]
["SU7","Axle Load","LRFR","Legal",89.29,2.3039999999999998,"Bottom Slab 3",7.2,60,"Flexure","As Requested","As Requested"]
["P3","Axle Load","LRFR","Permit",201.3,2.8759999999999999,"Bottom Slab 3",7.2,60,"Flexure","As Requested","As Requested"]

{"sheet":"Copy and Paste","index":3,"n_rows":38,"n_cols":10,"rows_kept":38,"cut":false,"hidden":true,"merged":[[4,21,4,22],[20,0,20,1]]}
["FROM BrR"]
["Bridge Name: C000101510 Used 36 ksi .."]
["NBI Structure ID: C000101510"]
["Bridge ID: C000101510"]
[]
["Analyzed By: STN\\Joel.Buettner"]
["Analyze Date: Monday, April 13, 2026 15:04:50"]
["Analysis Engine: AASHTO LFR Engine Version 7.5.1.3001"]
["Analysis Preference Setting: None"]
[]
["Report By: STN\\Joel.Buettner"]
["Report Date: Monday, April 13, 2026 15:05:41"]
[]
["Structure Definition Name: Span 1"]
["Member Name: G2"]
["Member Alternative Name: Copy of W 16 X 58"]
[]
["Load Factor Rating Summary"]
[]
["Girder Summary"]
[null,null,"Rating",null,"Capacity",null,"Location"]
["Live Load",null,"Factor","Controls","(Ton)","Span","(ft)","Percent","Impact","Lane"]
["1 NE Type 3","Legal Opr.",1.494,"Design Flexure - Steel",37.36,1,12.25,50,"As Requested","As Requested"]
["2 NE Type 3S2","Legal Opr.",1.5649999999999999,"Design Flexure - Steel",57.91,1,12.25,50,"As Requested","As Requested"]
["3 NE Type 3-3","Legal Opr.",1.8149999999999999,"Design Flexure - Steel",78.03,1,12.25,50,"As Requested","As Requested"]
["EV2","Legal Opr.",1.2689999999999999,"Design Flexure - Steel",36.49,1,12.25,50,"As Requested","As Requested"]
["EV3","Legal Opr.",0.82,"Design Flexure - Steel",35.24,1,12.25,50,"As Requested","As Requested"]
["HS 20-44","Inventory",0.79600000000000004,"Design Flexure - Steel",28.64,1,12.25,50,"As Requested","As Requested"]
["HS 20-44","Operating",1.329,"Design Flexure - Steel",47.83,1,12.25,50,"As Requested","As Requested"]
["P3","Permit Opr.",0.93799999999999994,"Design Flexure - Steel",65.69,1,12.25,50,"As Requested","As Requested"]
["SU4","Legal Opr.",1.256,"Design Flexure - Steel",33.92,1,12.25,50,"As Requested","As Requested"]
["SU5","Legal Opr.",1.161,"Design Flexure - Steel",36,1,12.25,50,"As Requested","As Requested"]
["SU6","Legal Opr.",1.079,"Design Flexure - Steel",37.51,1,12.25,50,"As Requested","As Requested"]
["SU7","Legal Opr.",1.075,"Design Flexure - Steel",41.65,1,12.25,50,"As Requested","As Requested"]
[]
["Note:"]
["\"N/A\" indicates not applicable"]
["\"**\" indicates not available"]

{"sheet":"Report ","index":4,"n_rows":78,"n_cols":54,"rows_kept":78,"cut":false,"hidden":true,"merged":[[25,44,25,54],[45,20,45,24],[38,38,38,39],[36,47,36,54],[37,47,37,54],[38,47,38,54],[39,47,39,54],[40,47,40,54],[41,47,41,54],[42,47,42,54],[43,47,43,54],[38,40,38,43],[38,44,38,46],[42,44,42,46],[44,38,44,39],[39,38,39,39],[34,35,34,37],[36,28,36,34],[36,35,36,37],[36,38,36,39],[35,28,35,34],[25,31,25,43],[35,47,35,54],[26,32,26,43],[45,15,45,17],[45,18,45,19],[43,35,43,37],[39,40,39,43],[40,40,40,43],[45,1,45,5],[45,35,45,37],[43,38,43,39],[42,20,42,24],[42,25,42,27],[42,28,42,34],[41,1,41,5],[43,1,43,5],[43,11,43,14],[43,15,43,17],[43,18,43,19],[43,20,43,24],[43,25,43,27],[43,28,43,34],[40,1,40,5],[40,25,40,27],[44,40,44,43],[42,35,42,37],[42,38,42,39],[40,6,40,10],[44,44,44,46],[41,38,41,39],[41,40,41,43],[0,1,0,54],[44,47,44,54],[45,47,45,54],[28,47,33,54],[34,47,34,54],[43,40,43,43],[43,44,43,46],[44,1,44,5],[44,11,44,14],[44,15,44,17],[44,18,44,19],[44,20,44,24],[44,25,44,27],[44,28,44,34],[44,35,44,37],[24,30,24,43],[42,1,42,5],[42,11,42,14],[45,11,45,14],[41,35,41,37],[40,15,40,17],[40,18,40,19],[40,20,40,24],[42,15,42,17],[42,18,42,19],[41,44,41,46],[40,28,40,34],[40,35,40,37],[42,40,42,43],[40,38,40,39],[77,2,77,19],[53,28,53,44],[46,44,46,46],[71,6,71,11],[49,2,51,13],[46,6,46,10],[47,28,48,39],[46,47,46,54],[52,29,52,33],[50,29,50,33],[52,36,52,44],[69,2,69,5],[71,2,71,5],[74,6,75,53],[67,6,67,11],[57,12,57,46],[57,6,57,9],[55,6,55,9],[53,3,54,9],[71,46,71,52],[69,6,69,11],[53,16,53,27],[61,47,61,55],[77,49,77,54],[80,27,80,44],[50,14,50,27],[45,38,45,39],[45,40,45,43],[50,37,50,44],[45,44,45,46],[46,1,46,5],[46,11,46,14],[46,15,46,17],[46,18,46,19],[46,20,46,24],[46,25,46,27],[46,28,46,34],[46,35,46,37],[46,38,46,39],[46,40,46,43],[80,46,80,53],[54,16,54,27],[54,28,54,44],[55,16,55,27],[55,28,55,44],[63,1,64,11],[59,46,59,53],[67,2,67,5],[38,1,38,5],[38,11,38,14],[38,15,38,17],[38,18,38,19],[38,20,38,24],[38,25,38,27],[38,28,38,34],[38,35,38,37],[39,1,39,5],[39,11,39,14],[39,15,39,17],[39,18,39,19],[39,20,39,24],[39,25,39,27],[39,28,39,34],[39,35,39,37],[38,6,38,10],[39,6,39,10],[37,1,37,5],[37,11,37,14],[37,15,37,17],[37,18,37,19],[37,20,37,24],[37,25,37,27],[37,28,37,34],[37,35,37,37],[37,40,37,43],[37,6,37,10],[37,38,37,39],[41,6,41,10],[42,6,42,10],[43,6,43,10],[58,6,58,9],[31,20,34,24],[31,25,34,27],[31,40,34,43],[31,44,34,46],[35,6,35,10],[36,6,36,10],[36,40,36,43],[36,44,36,46],[45,25,45,27],[45,28,45,34],[45,6,45,10],[39,44,39,46],[40,44,40,46],[41,11,41,14],[41,15,41,17],[41,18,41,19],[41,20,41,24],[41,25,41,27],[41,28,41,34],[40,11,40,14],[17,4,17,20],[21,4,21,20],[36,1,36,5],[36,11,36,14],[36,15,36,17],[36,18,36,19],[36,20,36,24],[36,25,36,27],[35,18,35,19],[35,15,35,17],[35,11,35,14],[35,1,35,5],[35,25,35,27],[35,20,35,24],[31,18,34,19],[44,6,44,10],[25,19,25,29],[24,19,24,29],[2,45,2,53],[3,45,3,53],[5,35,5,44],[5,45,5,53],[7,39,7,44],[7,45,7,53],[9,45,9,53],[3,41,3,44],[11,45,12,53],[16,39,16,44],[9,39,9,44],[11,41,11,44],[2,40,2,44],[35,35,35,37],[35,38,35,39],[35,40,35,43],[35,44,35,46],[13,45,13,53],[16,45,16,53],[15,45,15,54],[22,0,22,6],[28,38,30,46],[37,44,37,46],[3,13,3,22],[3,23,3,39],[28,6,30,14],[28,15,30,19],[28,20,30,27],[28,28,34,34],[31,15,34,17],[31,6,34,10],[24,2,24,18],[25,1,25,18],[26,2,26,18],[22,27,22,33],[6,4,6,20],[22,41,22,45],[26,44,26,54],[24,44,24,54],[22,47,22,52],[22,53,23,54],[16,54,16,55],[13,32,13,44],[22,7,22,16],[22,17,22,26],[77,45,77,48],[59,6,59,9],[60,6,60,9],[2,13,2,22],[2,23,2,39],[31,38,34,39],[31,11,34,14],[26,19,26,31],[7,2,7,17],[7,18,7,37],[9,2,9,17],[9,18,9,38],[11,3,11,17],[11,18,11,40],[13,4,13,17],[13,18,13,31],[15,5,15,17],[15,18,15,40],[16,5,16,17],[16,18,16,38],[15,41,15,44],[28,1,34,5],[49,47,50,52],[22,35,22,40]]}
[null,"Load Rating Summary"]
[]
[null,null,null,null,null,null,null,null,null,null,null,null,null,"Structure ID:",null,null,null,null,null,null,null,null,null,"C000101510",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Analyst:",null,null,null,null,"Joel Buettner"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,"Location:",null,null,null,null,null,null,null,null,null,"12990 S. BLADEN AVENUE",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"QC By:"]
[]
[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,null,null,null,null,"Load Rating Date (B.LR.03):",null,null,null,null,null,null,null,null,null,"2026-04-13"]
[null,null,null,null,"Structure Identification"]
[null,null,"Feature Intersected:",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"COTTONWOOD CREEK",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"County:",null,null,null,null,null,"Adams(001)"]
[]
[null,null,"Material Main Span (B.SP.04):",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"S01 Steel- Rolled",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"NHS Designation:",null,null,null,null,null,"N Non-NHS"]
[]
[null,null,null,"Design for Main Span (B.SP.06):",null,null,null,null,null,null,null,null,null,null,null,null,null,null,"G01 Girder/Beam- I Shaped adj. ",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"District:",null,null,null,"District 4"]
[]
[null,null,null,null,"Year Built:",null,null,null,null,null,null,null,null,null,null,null,null,null,1974,null,null,null,null,null,null,null,null,null,null,null,null,null,"Admin Owner:",null,null,null,null,null,null,null,null,null,null,null,null,"Admins County"]
[]
[null,null,null,null,null,"Maintainer:",null,null,null,null,null,null,null,null,null,null,null,null,"L01 County Highway Agency ",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Name:",null,null,null,"O 6-1"]
[null,null,null,null,null,"Owner:",null,null,null,null,null,null,null,null,null,null,null,null,"L01 County Highway Agency ",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Emergency Route:",null,null,null,null,null,"N Not an Evac Emergency Rte"]
[null,null,null,null,"Description"]
[]
[]
[]
[null,null,null,null,"Ratings and Loads"]
["Deck (B.C.01):",null,null,null,null,null,null,"6 Satisfactory ",null,null,null,null,null,null,null,null,null,"SuperStructure (B.C.02):",null,null,null,null,null,null,null,null,null,"6 Satisfactory ",null,null,null,null,null,null,null,"Substructure (B.C.03):",null,null,null,null,null,"7 Good",null,null,null,null,null,"Culvert (B.C.04):",null,null,null,null,null,"N N/A "]
[]
[null,null,"   Design Load (B.LR.01):",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"H15",null,null,null,null,null,null,null,null,null,null,"Type of Overlay:"]
[null,"Design Method (B.LR.02):",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"LFD",null,null,null,null,null,null,null,null,null,null,null,"Overlay Thickness / Fill Height (in):"]
[null,null,"LR Method (B.LR.04):",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"LFR",null,null,null,null,null,null,null,null,null,null,null,null,"Load Posting Status (B.PS.01):"]
[]
[null,"  Truck",null,null,null,null,"Inventory\nRating",null,null,null,null,null,null,null,null,"Operating\nRating",null,null,null,null,"Legal",null,null,null,null,null,null,null,"Posting\nValue\n(tons)",null,null,null,null,null,null,null,null,null,"Control Location"]
[]
[]
[null,null,null,null,null,null," Rating Factor ",null,null,null,null,"Tons",null,null,null," Rating Factor ",null,null,"Tons ",null," Rating Factor ",null,null,null,null,"Tons",null,null,null,null,null,null,null,null,null,null,null,null,"Span",null,"Location\n(ft)",null,null,null,"Percent\nof\nSpan"]
[]
[]
[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,null,null,null,null,"Member",null,null,null,null,null,null,null,null,null,null,null,"Limit State"]
[null,"HS/HL93",null,null,null,null,{"$f":"TRUNC('Copy and Paste'!C28,2)","v":0.79},null,null,null,null,{"$f":"G36*36","v":28.44},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"N/A",null,null,null,null,null,null,{"$f":"'Dropdown '!$C$194","v":"G2"},null,null,{"$f":"'Copy and Paste'!F28","v":1},null,{"$f":"'Copy and Paste'!G28","v":12.25},null,null,null,{"$f":"'Copy and Paste'!H28","v":50},null,null,{"$f":"'Copy and Paste'!D28","v":"Design Flexure - Steel"}]
[null,"HS/HL93",null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"TRUNC('Copy and Paste'!C29,2)","v":1.32},null,null,{"$f":"P37*36","v":47.52},null,null,null,null,null,null,null,null,null,"N/A",null,null,null,null,null,null,{"$f":"'Dropdown '!$C$194","v":"G2"},null,null,{"$f":"'Copy and Paste'!F29","v":1},null,{"$f":"'Copy and Paste'!G29","v":12.25},null,null,null,{"$f":"'Copy and Paste'!H29","v":50},null,null,{"$f":"'Copy and Paste'!D29","v":"Design Flexure - Steel"}]
[null,"SU4",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"TRUNC('Copy and Paste'!C31,2)","v":1.25},null,null,null,null,{"$f":"U38*27","v":33.75},null,null,"-",null,null,null,null,null,null,{"$f":"'Dropdown '!$C$194","v":"G2"},null,null,{"$f":"'Copy and Paste'!F31","v":1},null,{"$f":"'Copy and Paste'!G31","v":12.25},null,null,null,{"$f":"'Copy and Paste'!H31","v":50},null,null,{"$f":"'Copy and Paste'!D31","v":"Design Flexure - Steel"}]
[null,"SU5",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"TRUNC('Copy and Paste'!C32,2)","v":1.1599999999999999},null,null,null,null,{"$f":"U39*31","v":35.96},null,null,"-",null,null,null,null,null,null,{"$f":"'Dropdown '!$C$194","v":"G2"},null,null,{"$f":"'Copy and Paste'!F32","v":1},null,{"$f":"'Copy and Paste'!G32","v":12.25},null,null,null,{"$f":"'Copy and Paste'!H32","v":50},null,null,{"$f":"'Copy and Paste'!D32","v":"Design Flexure - Steel"}]
[null,"SU6",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"TRUNC('Copy and Paste'!C33,2)","v":1.07},null,null,null,null,{"$f":"U40*34.75","v":37.182500000000005},null,null,"-",null,null,null,null,null,null,{"$f":"'Dropdown '!$C$194","v":"G2"},null,null,{"$f":"'Copy and Paste'!F33","v":1},null,{"$f":"'Copy and Paste'!G33","v":12.25},null,null,null,{"$f":"'Copy and Paste'!H33","v":50},null,null,{"$f":"'Copy and Paste'!D33","v":"Design Flexure - Steel"}]
[null,"SU7",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"TRUNC('Copy and Paste'!C34,2)","v":1.07},null,null,null,null,{"$f":"U41*38.75","v":41.462500000000006},null,null,"-",null,null,null,null,null,null,{"$f":"'Dropdown '!$C$194","v":"G2"},null,null,{"$f":"'Copy and Paste'!F34","v":1},null,{"$f":"'Copy and Paste'!G34","v":12.25},null,null,null,{"$f":"'Copy and Paste'!H34","v":50},null,null,{"$f":"'Copy and Paste'!D34","v":"Design Flexure - Steel"}]
[null,"NE Type 3",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"TRUNC('Copy and Paste'!C23,2)","v":1.49},null,null,null,null,{"$f":"U42*25","v":37.25},null,null,{"$f":"IF('Dropdown '!B159<>0,'Dropdown '!B159,\"\")","v":""},null,null,null,null,null,null,{"$f":"'Dropdown '!$C$194","v":"G2"},null,null,{"$f":"'Copy and Paste'!F23","v":1},null,{"$f":"'Copy and Paste'!G23","v":12.25},null,null,null,{"$f":"'Copy and Paste'!H23","v":50},null,null,{"$f":"'Copy and Paste'!D23","v":"Design Flexure - Steel"}]
[null,"NE Type 3S2",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"TRUNC('Copy and Paste'!C24,2)","v":1.56},null,null,null,null,{"$f":"U43*37","v":57.72},null,null,{"$f":"IF(U43<1,TRUNC(Z43),\"\")","v":""},null,null,null,null,null,null,{"$f":"'Dropdown '!$C$194","v":"G2"},null,null,{"$f":"'Copy and Paste'!F24","v":1},null,{"$f":"'Copy and Paste'!G24","v":12.25},null,null,null,{"$f":"'Copy and Paste'!H24","v":50},null,null,{"$f":"'Copy and Paste'!D24","v":"Design Flexure - Steel"}]
[null,"NE Type 3-3",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"TRUNC('Copy and Paste'!C25,2)","v":1.81},null,null,null,null,{"$f":"U44*43","v":77.83},null,null,{"$f":"IF(U44<1,TRUNC(Z44),\"\")","v":""},null,null,null,null,null,null,{"$f":"'Dropdown '!$C$194","v":"G2"},null,null,{"$f":"'Copy and Paste'!F25","v":1},null,{"$f":"'Copy and Paste'!G25","v":12.25},null,null,null,{"$f":"'Copy and Paste'!H25","v":50},null,null,{"$f":"'Copy and Paste'!D25","v":"Design Flexure - Steel"}]
[null,"EV2",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"TRUNC('Copy and Paste'!C26,2)","v":1.26},null,null,null,null,{"$f":"U45*28.75","v":36.225000000000001},null,null,"N/A",null,null,null,null,null,null,{"$f":"'Dropdown '!$C$194","v":"G2"},null,null,{"$f":"'Copy and Paste'!F26","v":1},null,{"$f":"'Copy and Paste'!G26","v":12.25},null,null,null,{"$f":"'Copy and Paste'!H26","v":50},null,null,{"$f":"'Copy and Paste'!D26","v":"Design Flexure - Steel"}]
[null,"EV3",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"TRUNC('Copy and Paste'!C27,2)","v":0.82},null,null,null,null,{"$f":"U46*43","v":35.26},null,null,"N/A",null,null,null,null,null,null,{"$f":"'Dropdown '!$C$194","v":"G2"},null,null,{"$f":"'Copy and Paste'!F27","v":1},null,{"$f":"'Copy and Paste'!G27","v":12.25},null,null,null,{"$f":"'Copy and Paste'!H27","v":50},null,null,{"$f":"'Copy and Paste'!D27","v":"Design Flexure - Steel"}]
[null,"Triple-Triple",null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"TRUNC('Copy and Paste'!C30,2)","v":0.93},null,null,{"$f":"P47*70","v":65.100000000000009},null,null,null,null,null,null,null,null,null,"N/A",null,null,null,null,null,null,{"$f":"'Dropdown '!$C$194","v":"G2"},null,null,{"$f":"'Copy and Paste'!F30","v":1},null,{"$f":"'Copy and Paste'!G30","v":12.25},null,null,null,{"$f":"'Copy and Paste'!H30","v":50},null,null,{"$f":"'Copy and Paste'!D30","v":"Design Flexure - Steel"}]
[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,"Documentation"]
[]
[]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Rating Information Provided:",null,null,null,null,null,null,null,null,null,null,null,null,null,"X","Plans",null,null,null,null,null,null,null,"Field Measurements"]
[]
[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,"Testing",null,null,null,null,null,null,"No Information Exists "]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"BrR Computations Submitted:",null,null,null,null,null,null,null,null,null,null,null,"Yes"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Analysis Engine Version:",null,null,null,null,null,null,null,null,null,null,null,"AASHTO LFR Engine Version 7.5.0.3001"]
[null,null,null,null,null,null,{"$f":"IF(AC42=\"\",\"t\",AC42&\"T\")","v":"t"},null,null,null,null,null,null,null,null,null,"Rating Program Used: ",null,null,null,null,null,null,null,null,null,null,null,"0 AASHTOWare BrR"]
[null,null,null,null,null,null,"0T"]
[null,null,null,null,null,null,{"$f":"IF(AC43=\"\",\"t\",AC43&\"T\")","v":"t"},null,null,null,null,null,"Additional Comments "]
[null,null,null,null,null,null,{"$f":"IF(AC45=\"\",\"t\",MIN('Dropdown '!B157:B162)&\"T\")","v":"0T"}]
[null,null,null,null,null,null,{"$f":"IF(AC44=\"\",\"t\",AC44&\"T\")","v":"t"}]
[null,null,null,null,null,null,{"$f":"IF(AC47=\"\",\"t\",MIN('Dropdown '!B159:B164)&\"T\")","v":"0T"}]
[]
[]
[null,"EMERGENCY VEHICLE               AXEL WEIGHT LIMIT"]
[]
[]
[]
[null,null,"SINGLE"]
[]
[null,null,"TANDEM"]
[]
[null,null,"GROSS"]
[]
[]
[null,null,null,null,null,null,"The Rating and Posting Values for this structure is based on a theoretical analysis of the structural elements involved and on a limited amount of information concerning the structural condition. These weight limits are intended only as a general guideline and may be varied accordingly by the officials responsible for this structure after an investigation of the structural condition, reaction to vehicular loads and any other items where judgment is required to establish a proper weight limit."]
[]
[]
[null,null,"BR Form 465, version 2.0 [Updated:1 9 2026]",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,null,null,null,null,null,null,null,null,null,null,null,"Print Time:",null,null,null,"01/09/2026  12:14:55PM"]

{"sheet":"README","index":5,"n_rows":215,"n_cols":32,"rows_kept":215,"cut":false,"hidden":false,"merged":[[48,1,50,2],[96,28,98,30],[134,31,136,33],[119,1,121,2]]}
["README: "]
[]
[]
[null,"In the textbox, press CTRL+SHIFT+ENTER to go to the next line"]
[]
[]
[null,"Load Posting Status (B.PS.01) :"]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
["Instructions: "]
[]
["1. Run BrR Analysis"]
[]
["2. Click on tools then on the Report Tool "]
[]
["3. Select analysis output (LFR/LRFR)"]
[]
[]
[]
[]
[]
[]
[]
[]
[null,null,"4. Select and generate the Overall Summary"]
[]
[]
[]
[]
[]
["5. Review the overall summary report output"]
[]
["6. Identify and select the controlling member output, including the Bridge Name"]
["Double check if the Inventory and Operating type is controlling in another member when using report function sheet!!!!"]
[]
[]
[]
[]
[]
[]
[null,"Copy from here"]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[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,"To Here"]
[]
[]
[]
[]
[]
[null,null,null,null,null,null,null,null,null,"OR If a Culvert is being done "]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[null,"Copy from here"]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[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,"To Here"]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
["7. Click on \"Copy and Paste\" sheet"]
[]
["8. Paste the controlling summary report in $A$2 as shown below "]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
["9. Click on the Report Tab, and fill out Bridge Identification data above the Bridge Description Box; some cells may have a drop-down menu"]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
["10. Add bridge description; add any additional ocmments, and make sure comments are visible in boxes"]
[]
["11. Click download button to generate LRSS in pdf format. The pdf will save to wherever this sheet will be placed. "]

{"sheet":"Dropdown ","index":6,"n_rows":287,"n_cols":21,"rows_kept":287,"cut":false,"hidden":true,"merged":[[166,0,166,2]]}
["Yes"]
["No"]
[null,"Software Used"]
["1 BARS-PC","0 AASHTOWare BrR",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"County"]
["10 NDOR Timber Program","1 Excel ",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Adams(001)"]
["11 NDOR Steel Program","2 Load Testing",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Antelope(003)"]
["12 Consultant","3 Hand Calculations",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Arthur(005)"]
["13 Hand Calcs","4 NDOT Assigned Rating",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Banner(007)"]
["14 BrR","5 NDOT Policy",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Blaine(009)"]
["15 LARS","6 Consultant",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Boone(011)"]
["16 LARS","7 LARS",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Box Butte(0013)"]
["2 BARS (mainframe)","8 BRASS",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Boyd(015)"]
["3 BRASS",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Brown(017)"]
["36 NDOR Assigned Rating",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Buffalo(019)"]
["37 NDOR Policy",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Burt(021)"]
["38 Engineering Judgement",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Butler(023)"]
["4 VIRTIS",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Cass(025)"]
["99 -",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Cedar(027)"]
["A Cycle A",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Chase(029)"]
["U Update",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Cherry(031)"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Cheyenne(033)"]
[null,null,null,null,null,null,"Monday",null,null,null,null,null,null,null,null,null,null,null,null,null,"Clay(035)"]
[{"$f":"_xlfn.TEXTSPLIT('[1]Copy and Paste Info '!A15,\":\")","v":"Member Name"}," G2",null,null,null,null,"Tuesday",null,null,null,null,null,null,null,null,null,null,null,null,null,"Colfax(037)"]
[{"$f":"_xlfn.TEXTSPLIT('[1]Copy and Paste Info '!A8,\":\")","v":"Analysis Engine"}," AASHTO LFR Engine Version 7.5.1.3001",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Cuming(039)"]
[{"$f":"'[1]Copy and Paste Info '!A12","v":"Report Date: Wednesday, August 20, 2025 15:39:59"},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Custer(041)"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Dakota(043)"]
[{"$f":"RIGHT(A25,8)","v":"15:39:59"},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Dawes(045)"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Dawson(047)"]
[null,"Span Type ",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Deuel(049)"]
["00 Other","A01 Arch- Under Fill w/o Spandrel",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Dixon(051)"]
["01 Slab ","A02 Arch- Open Spandrel ",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Dodge(053)"]
["02 Stringer/Girder","A03 Arch- Closed Spandrel",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Douglas(055)"]
["04 Tee Beam ","A04 Arch- Through",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Dundy(057)"]
["05 Multiple Box Beam ","A05 Arch- Tied",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Fillmore(059)"]
["06 Single/Spread Box","B01 Box Girder/Beam- Single",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Franklin(061)"]
["07 Frame","B02 Box Girder/Beam- Mult adj.",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Frontier(063)"]
["08 Orthotropic","B03 Box Girder/Beam- Mult Spread",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Furnas(065)"]
["09 Truss-Deck","B04 Box Girder/Beam- Segmental",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Gage(067)"]
["10 Truss-Thru","F01 Frame- Three Sided",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Garden(069)"]
["11 Arch-Deck","F02 Frame- Four Sided",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Garfield(071)"]
["12 Arch-Thru ","F03 Frame- K Shaped",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Gosper(073)"]
["13 Suspension","F04 Frame- Delta Shaped",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Grant(075)"]
["14 Stayed Girder","G01 Girder/Beam- I Shaped adj. ",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Greeley(077)"]
["15 Movable-Lift","G02 Girder/Beam- I Shaped Spread",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Hall(079)"]
["16 Movable-Basscule","G03 Girder/Beam- Tee Beam",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Hamilton(081)"]
["17 Movable-Swing ","G04 Girder/Beam- Inverted Tee",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Harlan(083)"]
["18 Tunnel","G05 Girder/Beam- Double Tee adj. ",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Hayes(085)"]
["19 Culvert ","G06 Girder/Beam- Double Tee Spread ",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Hitchcock(087)"]
["20 Mixed types","G07 Girder/Beam- Channel adj. ",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Holt(089)"]
["21 Segmental Box Girder","G08 Girder/Beam- Channel Spread ",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Hooker(091)"]
["22 Channel Beam ","G09 Girder/Beam- Girder & Floor Beam",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Howard(093)"]
[null,"G10 Girder/Beam- Through Girder",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Jefferson(095)"]
[null,"GX Girder/Beam - Other","Material for Main Span",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Johnson(097)"]
["1 Concrete","L01 Cable- Suspension","A01 Aluminum",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Kearney(099)"]
["2 Concrete Continuous","L02 Cable- Cable Stayed","C01 R/C- Cast in Place",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Keith(101)"]
["3 Steel","L03 Cable- Extradosed","C02 R/C- Precast",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Keya Paha(103)"]
["4 Steel Continuous","LX- Cable- Other","C03 P/C- Pre Tensioned",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Kimball(105)"]
["5 Prestress Concrete","M01 Movable- Vertical Lift","C04 P/C- Cast in Place PostTensioned",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Knox(107)"]
["6 P/S Conc Continuous","M02 Movable- Bascule","C05 P/C- Precast PostTensioned",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Lancaster(109)"]
["7 Wood or Timber","M03 Moveable- Swing ","CX Concrete- other",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Lincoln(111)"]
["8 Masonry ","MX Moveable - Other ","F01 FRP Composite- Aramid Fiber",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Logan(113)"]
["9 Aluminum or Iron","P01 Pipe- Rigid ","F02 FRP Composite- Carbon Fiber",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Loup(115)"]
["0 Other","P02 Pipe- Flexible","F03 FRP Composite- Glass Fiber",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"McPherson(117)"]
[null,"S01 Slab- Solid","FX FRP Composite- Other",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Madison(117)"]
["National Highway System indicator","S02 Slab- Voided","I01 Iron- Cast",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Merrick(121)"]
["N Non-NHS","T01 Truss- Deck","I02 Iron- Wrought",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Morrill(123)"]
["Y NHS","T02 Truss- Through","M01 Massonry- Block",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Nance(125)"]
[null,"T03 Truss- Pony","M02 Massonry- Stone",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Nemaha(127)"]
["District","X01 Other- Railroad Flat Car","P01 Plastic- Polyethylene",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Nuckolls(129)"]
["District 1 ","X02 Other- Ferry Transfer","PX Plastic- Other",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Otoe(131)"]
["District 2","X03 Other- Floating","S01 Steel- Rolled",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Pawnee(133)"]
["District 3","X Other","S02 Steel- Welded",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Perkins(135)"]
["District 4",null,"S03 Steel- Bolted",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Phelps(137)"]
["District 5",null,"S04 Steel- Riveted",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Pierce(139)"]
["District 6",null,"S05 Steel- Bolted&Riveted",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Platte(141)"]
["District 7",null,"SX Steel- Other",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Polk(143)"]
["District 8",null,"T01 Timber- Glue Laminated",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Red Willow(145)"]
[null,null,"T02 Timber- Nail Laminated",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Richardson(147)"]
["Emergency Route",null,"T03 Timber- Solid Sawn",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Rock(149)"]
["N Not an Evac Emergency Rte",null,"T04 Timber- Stress Laminated",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Saline(151)"]
["Y Emergency Evac Rte",null,"TX Timber- Other",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Sarpy(153)"]
[null,null,"X Other",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Saunders(155)"]
["Condition",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Scotts Bluff(157)"]
["N N/A ",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Seward(159)"]
["9 Excellent ",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Sheridan(161)"]
["8 Very Good ",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Sherman(163)"]
["7 Good",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Sioux(165)"]
["6 Satisfactory ",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Stanton(167)"]
["5 Fair ",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Thayer(169)"]
["4 Poor ",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Thomas(171)"]
["3 Serious",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Thurston(173)"]
["2 Critical ",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Valley(175)"]
["1 Imm. Failure",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Washington(177)"]
["0 Failed",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Wayne(179)"]
["Design Load",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Webster(181)"]
["H10",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Wheeler(183)"]
["H15",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"York(185)"]
["H20"]
["HS15"]
["HS20"]
["HS20M"]
["HS20Plus"]
["HL93",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Admin Area"]
["HL93Plus",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"901 - Unknown"]
["RR Railroad",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"902 - Not Applicable"]
["U Unknown",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"AL-Alliance "]
["X Other ",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"BL-Blair"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"BT-Beatrice"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"BV-Bellevue"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"CL-Columbus"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"CR-Crete"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"EH-Elkhorn"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"FM-Fremont"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"GI-Grand Island"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"GR-Gering"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"HA-Hastings"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"KY-Kearney"]
["Design Method",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"LN-Lincoln "]
["ASD",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"LV-La Vista"]
["LFD",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"LX-Lexington"]
["LRFD",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"MC-McCook"]
["U Unknown",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"NC-Nebraska City"]
["X Other",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"NF-Norfolk "]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"NP-North Platte"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"OG-Ogallala"]
["Load Rating Method",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"OM-Omaha "]
["LFR",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"PP-Papillion"]
["ASR",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"PS-Plattsmouth"]
["LRFR",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"SD-Seward"]
["LT Load Testing",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"SI-Sidney"]
["AR Assigned Rating",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"XL-Holdredge"]
["EJ Engineering Judgement",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"YR-York"]
["N No Rating Eval "]
[]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Maintainer/owner"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"U Unknown "]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"P Private "]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"R Railroad"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"X Other"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"S01 State Transportation Department"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"S02 State Pk/Frst/Reserv"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"S03 State Toll Authority"]
["Posting Equation:",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"SX Other State Agency "]
[{"$f":"MIN([1]Report!S33:V37)","v":2.0299999999999998},{"$f":"VLOOKUP('Dropdown '!A144,B147:D151,2,FALSE)","v":38.75},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"L01 County Highway Agency "]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"L02 Town/Township Highway Agency "]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"L03 City/Municipal Highway Agency "]
["SU4",{"$f":"[1]Report!S33","v":2.66},27,{"$f":"[1]Report!W33","v":71.86},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"L04 Local Park/Frst/Reserv"]
["SU5",{"$f":"[1]Report!S34","v":2.36},31,{"$f":"[1]Report!W34","v":73.319999999999993},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"L05 Local Toll Authority "]
["SU6",{"$f":"[1]Report!S35","v":2.1800000000000002},34.75,{"$f":"[1]Report!W35","v":75.88},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"LX Other Local Agency "]
["SU7",{"$f":"[1]Report!S36","v":2.0299999999999998},38.75,{"$f":"[1]Report!W36","v":78.680000000000007},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"F01 Agricultural Research Servis (ARS)"]
["NE Type 3",{"$f":"[1]Report!S37","v":2.91},25,{"$f":"[1]Report!W37","v":72.87},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"F02 Deparment of Energy (DOE)"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"F03 GSA"]
[null,"Posting Contestants",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"F04 NASA"]
[null,{"$f":"IF('Report '!U38<1,'Report '!Z38, \"\")","v":""},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"F05 Smithsonian - National Zoo"]
[null,{"$f":"IF('Report '!U39<1,'Report '!Z39, \"\")","v":""},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"F06 Tennessee Valley Authority (TVA)"]
[null,{"$f":"IF('Report '!U40<1,'Report '!Z40, \"\")","v":""},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"F07 U.S. Department of Veterans Affairs "]
[null,{"$f":"IF('Report '!U41<1,'Report '!Z41, \"\")","v":""},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"F08 FEMA"]
[null,{"$f":"IF('Report '!U42<1,'Report '!Z42, \"\")","v":""},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"F09 USIBWC"]
[null,{"$f":"TRUNC(MIN(B154:B158))","v":0},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"FX Other Federal Agency "]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"FL01 Bureau of Indian Affairs (BIA)"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"FL02 Bureau of Land Mangement (BLM)"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"FL03 Bureau of Reclamation (USBR)"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"FL04 U.S Fish and Wildlife Service"]
[null,null,null,null,null,null,null,null,null,null,null,{"$f":"TRUNC(B154,1)","v":{"$error":"#VALUE!"}},null,null,null,null,null,null,null,null,"FL05 National Park Service (NPS)"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"FL06 USACE"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"FL07 U.S. Forest Service (USFS)"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"FL0X Other Federal Lands Agency "]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"I Indian Tribal Government "]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"D01 Air Force"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"D02 Army"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"D03 Navy/Marines"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"D04 Pentagon"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"D05 National Security Agency  (NSA)"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"DX Other Deparment of Defense"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"T Transit Agency/Authority"]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[{"$f":"_xlfn.TEXTSPLIT('Copy and Paste'!A15,\" \")","v":"Member"},"Name:","G2"]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[null,null,"TONS","RF","Component","Location","Percent"]
["HL-93 (US)","Inventory",{"$f":"'Culvert Copy and Paste'!E2","v":62.09},{"$f":"'Culvert Copy and Paste'!F2","v":1.7250000000000001},{"$f":"'Culvert Copy and Paste'!G2","v":"Top Slab 2"},{"$f":"'Culvert Copy and Paste'!H2","v":12},{"$f":"'Culvert Copy and Paste'!I2","v":100},{"$f":"'Culvert Copy and Paste'!J2","v":"Flexure"},{"$f":"'Culvert Copy and Paste'!K2","v":"As Requested"},{"$f":"'Culvert Copy and Paste'!L2","v":"As Requested"}]
["HL-93 (US)","Inventory",{"$f":"'Culvert Copy and Paste'!E4","v":54.58},{"$f":"'Culvert Copy and Paste'!F4","v":1.516},{"$f":"'Culvert Copy and Paste'!G4","v":"Top Slab 1"},{"$f":"'Culvert Copy and Paste'!H4","v":2.4},{"$f":"'Culvert Copy and Paste'!I4","v":20},{"$f":"'Culvert Copy and Paste'!J4","v":"Flexure"},{"$f":"'Culvert Copy and Paste'!K4","v":"As Requested"},{"$f":"'Culvert Copy and Paste'!L4","v":"As Requested"}]
["HL-93 (US)","Operating",{"$f":"'Culvert Copy and Paste'!E3","v":80.48},{"$f":"'Culvert Copy and Paste'!F3","v":2.2360000000000002},{"$f":"'Culvert Copy and Paste'!G3","v":"Top Slab 2"},{"$f":"'Culvert Copy and Paste'!H3","v":12},{"$f":"'Culvert Copy and Paste'!I3","v":100},{"$f":"'Culvert Copy and Paste'!J3","v":"Flexure"},{"$f":"'Culvert Copy and Paste'!K3","v":"As Requested"},{"$f":"'Culvert Copy and Paste'!L3","v":"As Requested"}]
["HL-93 (US)","Operating",{"$f":"'Culvert Copy and Paste'!E5","v":70.75},{"$f":"'Culvert Copy and Paste'!F5","v":1.9650000000000001},{"$f":"'Culvert Copy and Paste'!G5","v":"Top Slab 1"},{"$f":"'Culvert Copy and Paste'!H5","v":2.4},{"$f":"'Culvert Copy and Paste'!I5","v":20},{"$f":"'Culvert Copy and Paste'!J5","v":"Flexure"},{"$f":"'Culvert Copy and Paste'!K5","v":"As Requested"},{"$f":"'Culvert Copy and Paste'!L5","v":"As Requested"}]
[]
[]
[]
[]
[null,null,null,null,"Inventory",{"$f":"MIN(C205,C206)","v":54.58},{"$f":"VLOOKUP($F$213,$C205:$J$206,2,FALSE)","v":1.516},{"$f":"VLOOKUP($F$213,$C205:$J$206,3,FALSE)","v":"Top Slab 1"},{"$f":"VLOOKUP($F$213,$C205:$J$206,4,FALSE)","v":2.4},{"$f":"VLOOKUP($F$213,$C205:$J$206,5,FALSE)","v":20},{"$f":"VLOOKUP($F$213,$C205:$J$206,6,FALSE)","v":"Flexure"}]
[null,null,null,null,null,null,null,{"$f":"_xlfn.TEXTSPLIT(H213,\" \")","v":"Top"},"Slab","1"]
[null,null,null,null,null,null,null,{"$f":"(H214&\" \"&I214)","v":"Top Slab"},{"$f":"J214","v":"1"}]
[]
[]
[null,null,null,null,"Operating",{"$f":"MIN(C207,C208)","v":70.75},{"$f":"VLOOKUP($F$218,$C$207:$J$208,2,FALSE)","v":1.9650000000000001},{"$f":"VLOOKUP($F$218,$C$207:$J$208,3,FALSE)","v":"Top Slab 1"},{"$f":"VLOOKUP($F$218,$C$207:$J$208,4,FALSE)","v":2.4},{"$f":"VLOOKUP($F$218,$C$207:$J$208,5,FALSE)","v":20},{"$f":"VLOOKUP($F$218,$C$207:$J$208,6,FALSE)","v":"Flexure"}]
[null,null,null,null,null,null,null,{"$f":"_xlfn.TEXTSPLIT(H218,\" \")","v":"Top"},"Slab","1"]
[null,null,null,null,null,null,null,{"$f":"(H219&\" \"&I219)","v":"Top Slab"},{"$f":"J219","v":"1"}]
[]
[]
[]
[]
[]
[null,"Member"]
["1 NE Type 3",{"$f":"'Culvert Copy and Paste'!G6","v":"Top Slab 1"},null,null,{"$f":"_xlfn.TEXTSPLIT(B227,\" \",)","v":"Top"},"Slab","1",null,{"$f":"E227&\" \"&F227","v":"Top Slab"},{"$f":"G227","v":"1"}]
["2 NE Type 3S2",{"$f":"'Culvert Copy and Paste'!G7","v":"Top Slab 1"},null,null,{"$f":"_xlfn.TEXTSPLIT(B228,\" \",)","v":"Top"},"Slab","1",null,{"$f":"E228&\" \"&F228","v":"Top Slab"},{"$f":"G228","v":"1"}]
["3 NE Type 3-3",{"$f":"'Culvert Copy and Paste'!G8","v":"Top Slab 1"},null,null,{"$f":"_xlfn.TEXTSPLIT(B229,\" \",)","v":"Top"},"Slab","1",null,"Top Slab","1"]
["EV2",{"$f":"'Culvert Copy and Paste'!G9","v":"Top Slab 1"},null,null,{"$f":"_xlfn.TEXTSPLIT(B230,\" \",)","v":"Top"},"Slab","1",null,"Top Slab","1"]
["EV3",{"$f":"'Culvert Copy and Paste'!G10","v":"Top Slab 1"},null,null,{"$f":"_xlfn.TEXTSPLIT(B231,\" \",)","v":"Top"},"Slab","1",null,"Top Slab","1"]
["SU4",{"$f":"'Culvert Copy and Paste'!G11","v":"Bottom Slab 3"},null,null,{"$f":"_xlfn.TEXTSPLIT(B232,\" \",)","v":"Bottom"},"Slab","3",null,"Bottom Slab","3"]
["SU5",{"$f":"'Culvert Copy and Paste'!G12","v":"Bottom Slab 3"},null,null,{"$f":"_xlfn.TEXTSPLIT(B233,\" \",)","v":"Bottom"},"Slab","3",null,"Bottom Slab","3"]
["SU6",{"$f":"'Culvert Copy and Paste'!G13","v":"Bottom Slab 3"},null,null,{"$f":"_xlfn.TEXTSPLIT(B234,\" \",)","v":"Bottom"},"Slab","3",null,"Bottom Slab","3"]
["SU7",{"$f":"'Culvert Copy and Paste'!G14","v":"Bottom Slab 3"},null,null,{"$f":"_xlfn.TEXTSPLIT(B235,\" \",)","v":"Bottom"},"Slab","3",null,"Bottom Slab","3"]
["P3",{"$f":"'Culvert Copy and Paste'!G15","v":"Bottom Slab 3"},null,null,{"$f":"_xlfn.TEXTSPLIT(B236,\" \",)","v":"Bottom"},"Slab","3",null,"Bottom Slab","3"]
[]
[]
[null,"Culvert Posting"]
[null,{"$f":"IF('Culvert Report'!U38<1,'Culvert Report'!Z38, \"\")","v":""}]
[null,{"$f":"IF('Culvert Report'!U39<1,'Culvert Report'!Z39, \"\")","v":""}]
[null,{"$f":"IF('Culvert Report'!U40<1,'Culvert Report'!Z40, \"\")","v":""}]
[null,{"$f":"IF('Culvert Report'!U41<1,'Culvert Report'!Z41, \"\")","v":""}]
[null,{"$f":"IF('Culvert Report'!U42<1,'Culvert Report'!Z42, \"\")","v":""}]
[null,{"$f":"TRUNC(MIN(B240:B244))","v":0}]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[null,"Manual Posting"]
[null,{"$f":"IF('Manual Input Report'!U38<1,'Manual Input Report'!Z38, \"\")","v":0}]
[null,{"$f":"IF('Manual Input Report'!U38<1,'Manual Input Report'!Z38, \"\")","v":0}]
[null,{"$f":"IF('Manual Input Report'!U39<1,'Manual Input Report'!Z39, \"\")","v":0}]
[null,{"$f":"IF('Manual Input Report'!U40<1,'Manual Input Report'!Z40, \"\")","v":0}]
[null,{"$f":"IF('Manual Input Report'!U41<1,'Manual Input Report'!Z41, \"\")","v":0}]
[null,{"$f":"TRUNC(MIN(B257:B261))","v":0}]
[]
[]
[]
[]
[]
[]
["Wearing Surface: "]
["0 None"]
["X Other"]
["B01 Bituminous (Asphalt)"]
["C01 Concrete- Monolithic "]
["C02 Concrete- Unmodified"]
["C03 Concrete- Latex Modified "]
["C04 Concrete- Low Slump"]
["C05 Concrete- Fiber Reinforced"]
["C06 Concrete- Microsilica"]
["C07 Concrete- Polyester"]
["CX Concrete- Other"]
["CU Concrete- Unknown"]
["E01 Earth- Gravel or Soil"]
["P01 Polymer- Epoxy"]
["P02 Polymer- Polyester"]
["PX Polymer- Other"]
["S01 Steel "]
["T01 Timber- Running Planks "]