{"text_format":"1","workbook":"xlsx","n_sheets":3,"sheets":["2-Point Bearing","3-Point Bearing","Dropdown Values"],"not_rendered":{"charts":0,"images":5,"macros":1,"external_links":0,"defined_names":2,"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":"2-Point Bearing","index":0,"n_rows":107,"n_cols":26,"rows_kept":107,"cut":false,"hidden":false,"merged":[[1,16,1,17],[2,5,2,6],[2,9,2,10],[2,13,2,14],[2,16,2,17],[3,5,3,6],[4,6,4,15],[5,6,5,15],[6,4,7,6],[1,5,1,6],[1,9,1,10],[1,13,1,14]]}
[]
[null,null,null,null,"County:",null,null,null,"Highway:",null,null,null,"Design:","Last, F.",null," Date:","MM/DD/YYYY"]
[null,null,null,null,"C-S-J:",null,null,null,"ID# :",null,null,null,"Checker:","Last, F.",null," Date:","MM/DD/YYYY"]
[]
[null,null,null,null,null,"Description:"]
[]
[null,null,null,null,"Bridge Division"]
[]
[]
[null,null,"INSTRUCTIONS:"]
[]
[null,null,1,"Select appropriate number of bents and spans from the dropdowns below. Note changing number of spans or bents will delete previous information."]
[null,null,2,"Create the Bearing Seat report in OBM and export to CSV."]
[null,null,3,"Copy row by row of elevations from then OBM Report to the Green Fields"]
[null,null,4,"Manually enter the Bearing Seat elevations from BGS in the Orange fields"]
[null,null,5,"The discrepancies between values will be calculated below, a positive value indicates OBM is over and negative indicates OBM is lower."]
[]
[null,null,null,"Number of Beams",null,null,null,"Number of Bents"]
[]
[]
[null,null,"Bearing Seat Elevations - One Pad per Beam"]
[]
[null,null,null,"Open Bridge Modeler Report"]
[]
[null,null,null,null,null,"Location",null,"Beam 1",null,"Beam 2",null,"Beam 3",null,"Beam 4",null,"Beam 5",null,"Beam 6",null,"Beam 7",null,"Beam 8",null,"Beam 9",null,"Beam 10"]
[null,null,null,"Abutment 1",null,"Fwd"]
[]
[null,null,null,"Bent 2",null,"Back"]
[null,null,null,null,null,"Fwd"]
[]
[null,null,null,"Bent 3",null,"Back"]
[null,null,null,null,null,"Fwd"]
[]
[null,null,null,"Bent 4",null,"Back"]
[null,null,null,null,null,"Fwd"]
[]
[null,null,null,"Bent 5",null,"Back"]
[null,null,null,null,null,"Fwd"]
[]
[null,null,null,"Bent 6",null,"Back"]
[null,null,null,null,null,"Fwd"]
[]
[null,null,null,"Bent 7",null,"Back"]
[null,null,null,null,null,"Fwd"]
[]
[null,null,null,"Bent 8",null,"Back"]
[null,null,null,null,null,"Fwd"]
[]
[null,null,null,"Abutment 9",null,"Back"]
[]
[]
[null,null,null,"LS4 Output from BGS"]
[]
[null,null,null,null,null,"Location",null,"Beam 1",null,"Beam 2",null,"Beam 3",null,"Beam 4",null,"Beam 5",null,"Beam 6",null,"Beam 7",null,"Beam 8",null,"Beam 9",null,"Beam 10"]
[null,null,null,"Abutment 1",null,"Fwd"]
[]
[null,null,null,"Bent 2",null,"Back"]
[null,null,null,null,null,"Fwd"]
[]
[null,null,null,"Bent 3",null,"Back"]
[null,null,null,null,null,"Fwd"]
[]
[null,null,null,"Bent 4",null,"Back"]
[null,null,null,null,null,"Fwd"]
[]
[null,null,null,"Bent 5",null,"Back"]
[null,null,null,null,null,"Fwd"]
[]
[null,null,null,"Bent 6",null,"Back"]
[null,null,null,null,null,"Fwd"]
[]
[null,null,null,"Bent 7",null,"Back"]
[null,null,null,null,null,"Fwd"]
[]
[null,null,null,"Bent 8",null,"Back"]
[null,null,null,null,null,"Fwd"]
[]
[null,null,null,"Abutment 9",null,"Back"]
[]
[]
[null,null,null,"Discrepancies"]
[]
[null,null,null,null,null,"Location",null,"Beam 1",null,"Beam 2",null,"Beam 3",null,"Beam 4",null,"Beam 5",null,"Beam 6",null,"Beam 7",null,"Beam 8",null,"Beam 9",null,"Beam 10"]
[null,null,null,"Abutment 1",null,"Fwd",null,{"$f":"$H$26-$H$55","v":0},null,{"$f":"$J$26-$J$55","v":0},null,{"$f":"$L$26-$L$55","v":0},null,{"$f":"$N$26-$N$55","v":0},null,{"$f":"$P$26-$P$55","v":0},null,{"$f":"$R$26-$R$55","v":0},null,{"$f":"$T$26-$T$55","v":0},null,{"$f":"$V$26-$V$55","v":0},null,{"$f":"$X$26-$X$55","v":0},null,{"$f":"$Z$26-$Z$55","v":0}]
[]
[null,null,null,"Bent 2",null,"Back",null,{"$f":"$H$28-$H$57","v":0},null,{"$f":"$J$28-$J$57","v":0},null,{"$f":"$L$28-$L$57","v":0},null,{"$f":"$N$28-$N$57","v":0},null,{"$f":"$P$28-$P$57","v":0},null,{"$f":"$R$28-$R$57","v":0},null,{"$f":"$T$28-$T$57","v":0},null,{"$f":"$V$28-$V$57","v":0},null,{"$f":"$X$28-$X$57","v":0},null,{"$f":"$Z$28-$Z$57","v":0}]
[null,null,null,null,null,"Fwd",null,{"$f":"$H$29-$H$58","v":0},null,{"$f":"$J$29-$J$58","v":0},null,{"$f":"$L$29-$L$58","v":0},null,{"$f":"$N$29-$N$58","v":0},null,{"$f":"$P$29-$P$58","v":0},null,{"$f":"$R$29-$R$58","v":0},null,{"$f":"$T$29-$T$58","v":0},null,{"$f":"$V$29-$V$58","v":0},null,{"$f":"$X$29-$X$58","v":0},null,{"$f":"$Z$29-$Z$58","v":0}]
[]
[null,null,null,"Bent 3",null,"Back",null,{"$f":"$H$31-$H$60","v":0},null,{"$f":"$J$31-$J$60","v":0},null,{"$f":"$L$31-$L$60","v":0},null,{"$f":"$N$31-$N$60","v":0},null,{"$f":"$P$31-$P$60","v":0},null,{"$f":"$R$31-$R$60","v":0},null,{"$f":"$T$31-$T$60","v":0},null,{"$f":"$V$31-$V$60","v":0},null,{"$f":"$X$31-$X$60","v":0},null,{"$f":"$Z$31-$Z$60","v":0}]
[null,null,null,null,null,"Fwd",null,{"$f":"$H$32-$H$61","v":0},null,{"$f":"$J$32-$J$61","v":0},null,{"$f":"$L$32-$L$61","v":0},null,{"$f":"$N$32-$N$61","v":0},null,{"$f":"$P$32-$P$61","v":0},null,{"$f":"$R$32-$R$61","v":0},null,{"$f":"$T$32-$T$61","v":0},null,{"$f":"$V$32-$V$61","v":0},null,{"$f":"$X$32-$X$61","v":0},null,{"$f":"$Z$32-$Z$61","v":0}]
[]
[null,null,null,"Bent 4",null,"Back",null,{"$f":"$H$34-$H$63","v":0},null,{"$f":"$J$34-$J$63","v":0},null,{"$f":"$L$34-$L$63","v":0},null,{"$f":"$N$34-$N$63","v":0},null,{"$f":"$P$34-$P$63","v":0},null,{"$f":"$R$34-$R$63","v":0},null,{"$f":"$T$34-$T$63","v":0},null,{"$f":"$V$34-$V$63","v":0},null,{"$f":"$X$34-$X$63","v":0},null,{"$f":"$Z$34-$Z$63","v":0}]
[null,null,null,null,null,"Fwd",null,{"$f":"$H$35-$H$64","v":0},null,{"$f":"$J$35-$J$64","v":0},null,{"$f":"$L$35-$L$64","v":0},null,{"$f":"$N$35-$N$64","v":0},null,{"$f":"$P$35-$P$64","v":0},null,{"$f":"$R$35-$R$64","v":0},null,{"$f":"$T$35-$T$64","v":0},null,{"$f":"$V$35-$V$64","v":0},null,{"$f":"$X$35-$X$64","v":0},null,{"$f":"$Z$35-$Z$64","v":0}]
[]
[null,null,null,"Bent 5",null,"Back",null,{"$f":"$H$37-$H$66","v":0},null,{"$f":"$J$37-$J$66","v":0},null,{"$f":"$L$37-$L$66","v":0},null,{"$f":"$N$37-$N$66","v":0},null,{"$f":"$P$37-$P$66","v":0},null,{"$f":"$R$37-$R$66","v":0},null,{"$f":"$T$37-$T$66","v":0},null,{"$f":"$V$37-$V$66","v":0},null,{"$f":"$X$37-$X$66","v":0},null,{"$f":"$Z$37-$Z$66","v":0}]
[null,null,null,null,null,"Fwd",null,{"$f":"$H$38-$H$67","v":0},null,{"$f":"$J$38-$J$67","v":0},null,{"$f":"$L$38-$L$67","v":0},null,{"$f":"$N$38-$N$67","v":0},null,{"$f":"$P$38-$P$67","v":0},null,{"$f":"$R$38-$R$67","v":0},null,{"$f":"$T$38-$T$67","v":0},null,{"$f":"$V$38-$V$67","v":0},null,{"$f":"$X$38-$X$67","v":0},null,{"$f":"$Z$38-$Z$67","v":0}]
[]
[null,null,null,"Bent 6",null,"Back",null,{"$f":"$H$40-$H$69","v":0},null,{"$f":"$J$40-$J$69","v":0},null,{"$f":"$L$40-$L$69","v":0},null,{"$f":"$N$40-$N$69","v":0},null,{"$f":"$P$40-$P$69","v":0},null,{"$f":"$R$40-$R$69","v":0},null,{"$f":"$T$40-$T$69","v":0},null,{"$f":"$V$40-$V$69","v":0},null,{"$f":"$X$40-$X$69","v":0},null,{"$f":"$Z$40-$Z$69","v":0}]
[null,null,null,null,null,"Fwd",null,{"$f":"$H$41-$H$70","v":0},null,{"$f":"$J$41-$J$70","v":0},null,{"$f":"$L$41-$L$70","v":0},null,{"$f":"$N$41-$N$70","v":0},null,{"$f":"$P$41-$P$70","v":0},null,{"$f":"$R$41-$R$70","v":0},null,{"$f":"$T$41-$T$70","v":0},null,{"$f":"$V$41-$V$70","v":0},null,{"$f":"$X$41-$X$70","v":0},null,{"$f":"$Z$41-$Z$70","v":0}]
[]
[null,null,null,"Bent 7",null,"Back",null,{"$f":"$H$43-$H$72","v":0},null,{"$f":"$J$43-$J$72","v":0},null,{"$f":"$L$43-$L$72","v":0},null,{"$f":"$N$43-$N$72","v":0},null,{"$f":"$P$43-$P$72","v":0},null,{"$f":"$R$43-$R$72","v":0},null,{"$f":"$T$43-$T$72","v":0},null,{"$f":"$V$43-$V$72","v":0},null,{"$f":"$X$43-$X$72","v":0},null,{"$f":"$Z$43-$Z$72","v":0}]
[null,null,null,null,null,"Fwd",null,{"$f":"$H$44-$H$73","v":0},null,{"$f":"$J$44-$J$73","v":0},null,{"$f":"$L$44-$L$73","v":0},null,{"$f":"$N$44-$N$73","v":0},null,{"$f":"$P$44-$P$73","v":0},null,{"$f":"$R$44-$R$73","v":0},null,{"$f":"$T$44-$T$73","v":0},null,{"$f":"$V$44-$V$73","v":0},null,{"$f":"$X$44-$X$73","v":0},null,{"$f":"$Z$44-$Z$73","v":0}]
[]
[null,null,null,"Bent 8",null,"Back",null,{"$f":"$H$46-$H$75","v":0},null,{"$f":"$J$46-$J$75","v":0},null,{"$f":"$L$46-$L$75","v":0},null,{"$f":"$N$46-$N$75","v":0},null,{"$f":"$P$46-$P$75","v":0},null,{"$f":"$R$46-$R$75","v":0},null,{"$f":"$T$46-$T$75","v":0},null,{"$f":"$V$46-$V$75","v":0},null,{"$f":"$X$46-$X$75","v":0},null,{"$f":"$Z$46-$Z$75","v":0}]
[null,null,null,null,null,"Fwd",null,{"$f":"$H$47-$H$76","v":0},null,{"$f":"$J$47-$J$76","v":0},null,{"$f":"$L$47-$L$76","v":0},null,{"$f":"$N$47-$N$76","v":0},null,{"$f":"$P$47-$P$76","v":0},null,{"$f":"$R$47-$R$76","v":0},null,{"$f":"$T$47-$T$76","v":0},null,{"$f":"$V$47-$V$76","v":0},null,{"$f":"$X$47-$X$76","v":0},null,{"$f":"$Z$47-$Z$76","v":0}]
[]
[null,null,null,"Abutment 9",null,"Back",null,{"$f":"$H$49-$H$78","v":0},null,{"$f":"$J$49-$J$78","v":0},null,{"$f":"$L$49-$L$78","v":0},null,{"$f":"$N$49-$N$78","v":0},null,{"$f":"$P$49-$P$78","v":0},null,{"$f":"$R$49-$R$78","v":0},null,{"$f":"$T$49-$T$78","v":0},null,{"$f":"$V$49-$V$78","v":0},null,{"$f":"$X$49-$X$78","v":0},null,{"$f":"$Z$49-$Z$78","v":0}]

{"sheet":"3-Point Bearing","index":1,"n_rows":314,"n_cols":26,"rows_kept":314,"cut":false,"hidden":false,"merged":[[48,7,48,9],[51,7,51,9],[1,5,1,6],[1,9,1,10],[1,13,1,14],[1,16,1,17],[2,5,2,6],[2,9,2,10],[2,13,2,14],[2,16,2,17],[27,7,27,9],[3,5,3,6],[4,6,4,15],[5,6,5,15],[6,4,7,6],[27,15,27,17],[33,7,33,9],[36,7,36,9],[39,7,39,9],[42,7,42,9],[45,7,45,9],[33,15,33,17],[36,15,36,17],[39,15,39,17],[24,23,24,25],[24,7,24,9],[24,11,24,13],[24,15,24,17],[24,19,24,21],[27,23,27,25],[30,23,30,25],[27,19,27,21],[30,19,30,21],[27,11,27,13],[30,11,30,13],[30,15,30,17],[30,7,30,9],[93,7,93,9],[96,7,96,9],[69,7,69,9],[72,7,72,9],[75,7,75,9],[78,7,78,9],[81,7,81,9],[54,7,54,9],[57,7,57,9],[60,7,60,9],[63,7,63,9],[66,7,66,9],[114,7,114,9],[117,7,117,9],[33,11,33,13],[36,11,36,13],[39,11,39,13],[42,11,42,13],[45,11,45,13],[48,11,48,13],[51,11,51,13],[54,11,54,13],[57,11,57,13],[60,11,60,13],[63,11,63,13],[66,11,66,13],[69,11,69,13],[72,11,72,13],[99,7,99,9],[102,7,102,9],[105,7,105,9],[108,7,108,9],[111,7,111,9],[84,7,84,9],[87,7,87,9],[90,7,90,9],[117,11,117,13],[90,11,90,13],[93,11,93,13],[96,11,96,13],[99,11,99,13],[102,11,102,13],[75,11,75,13],[78,11,78,13],[81,11,81,13],[84,11,84,13],[87,11,87,13],[42,15,42,17],[45,15,45,17],[105,11,105,13],[108,11,108,13],[111,11,111,13],[114,11,114,13],[87,15,87,17],[90,15,90,17],[63,15,63,17],[66,15,66,17],[69,15,69,17],[72,15,72,17],[75,15,75,17],[48,15,48,17],[51,15,51,17],[54,15,54,17],[57,15,57,17],[60,15,60,17],[108,15,108,17],[111,15,111,17],[114,15,114,17],[117,15,117,17],[33,19,33,21],[36,19,36,21],[39,19,39,21],[42,19,42,21],[45,19,45,21],[48,19,48,21],[51,19,51,21],[54,19,54,21],[57,19,57,21],[60,19,60,21],[63,19,63,21],[66,19,66,21],[93,15,93,17],[96,15,96,17],[99,15,99,17],[102,15,102,17],[105,15,105,17],[78,15,78,17],[81,15,81,17],[84,15,84,17],[108,19,108,21],[111,19,111,21],[84,19,84,21],[87,19,87,21],[90,19,90,21],[93,19,93,21],[96,19,96,21],[69,19,69,21],[72,19,72,21],[75,19,75,21],[78,19,78,21],[81,19,81,21],[75,23,75,25],[78,23,78,25],[81,23,81,25],[84,23,84,25],[87,23,87,25],[114,19,114,21],[117,19,117,21],[33,23,33,25],[36,23,36,25],[39,23,39,25],[42,23,42,25],[45,23,45,25],[48,23,48,25],[51,23,51,25],[54,23,54,25],[57,23,57,25],[60,23,60,25],[63,23,63,25],[66,23,66,25],[69,23,69,25],[72,23,72,25],[99,19,99,21],[102,19,102,21],[105,19,105,21],[105,23,105,25],[108,23,108,25],[111,23,111,25],[114,23,114,25],[117,23,117,25],[90,23,90,25],[93,23,93,25],[96,23,96,25],[99,23,99,25],[102,23,102,25],[137,7,137,9],[140,7,140,9],[143,7,143,9],[146,7,146,9],[149,7,149,9],[122,7,122,9],[125,7,125,9],[128,7,128,9],[131,7,131,9],[134,7,134,9],[167,7,167,9],[170,7,170,9],[173,7,173,9],[176,7,176,9],[179,7,179,9],[152,7,152,9],[155,7,155,9],[158,7,158,9],[161,7,161,9],[164,7,164,9],[197,7,197,9],[200,7,200,9],[203,7,203,9],[206,7,206,9],[209,7,209,9],[182,7,182,9],[185,7,185,9],[188,7,188,9],[191,7,191,9],[194,7,194,9],[122,11,122,13],[125,11,125,13],[128,11,128,13],[131,11,131,13],[134,11,134,13],[137,11,137,13],[140,11,140,13],[143,11,143,13],[146,11,146,13],[149,15,149,17],[152,15,152,17],[155,15,155,17],[158,15,158,17],[194,11,194,13],[197,11,197,13],[200,11,200,13],[203,11,203,13],[206,11,206,13],[179,11,179,13],[182,11,182,13],[185,11,185,13],[188,11,188,13],[191,11,191,13],[164,11,164,13],[167,11,167,13],[170,11,170,13],[173,11,173,13],[176,11,176,13],[149,11,149,13],[152,11,152,13],[155,11,155,13],[158,11,158,13],[161,11,161,13],[122,15,122,17],[125,15,125,17],[128,15,128,17],[131,15,131,17],[134,15,134,17],[137,15,137,17],[140,15,140,17],[143,15,143,17],[146,15,146,17],[185,15,185,17],[188,15,188,17],[161,15,161,17],[164,15,164,17],[167,15,167,17],[170,15,170,17],[173,15,173,17],[209,11,209,13],[212,11,212,13],[206,15,206,17],[209,15,209,17],[212,15,212,17],[215,15,215,17],[122,19,122,21],[125,19,125,21],[128,19,128,21],[131,19,131,21],[134,19,134,21],[137,19,137,21],[140,19,140,21],[143,19,143,21],[146,19,146,21],[149,19,149,21],[152,19,152,21],[155,19,155,21],[191,15,191,17],[194,15,194,17],[197,15,197,17],[200,15,200,17],[203,15,203,17],[176,15,176,17],[179,15,179,17],[182,15,182,17],[173,19,173,21],[176,19,176,21],[179,19,179,21],[182,19,182,21],[185,19,185,21],[158,19,158,21],[161,19,161,21],[164,19,164,21],[167,19,167,21],[170,19,170,21],[203,19,203,21],[206,19,206,21],[209,19,209,21],[212,19,212,21],[215,19,215,21],[188,19,188,21],[191,19,191,21],[194,19,194,21],[197,19,197,21],[200,19,200,21],[137,23,137,25],[140,23,140,25],[143,23,143,25],[146,23,146,25],[149,23,149,25],[179,23,179,25],[197,23,197,25],[200,23,200,25],[203,23,203,25],[206,23,206,25],[209,23,209,25],[182,23,182,25],[185,23,185,25],[188,23,188,25],[191,23,191,25],[194,23,194,25],[122,23,122,25],[125,23,125,25],[128,23,128,25],[131,23,131,25],[134,23,134,25],[167,23,167,25],[170,23,170,25],[173,23,173,25],[176,23,176,25],[152,23,152,25],[155,23,155,25],[158,23,158,25],[161,23,161,25],[164,23,164,25],[229,7,229,9],[232,7,232,9],[235,7,235,9],[238,7,238,9],[241,7,241,9],[212,23,212,25],[215,23,215,25],[220,7,220,9],[223,7,223,9],[226,7,226,9],[220,15,220,17],[223,15,223,17],[226,15,226,17],[220,23,220,25],[223,23,223,25],[226,23,226,25],[215,11,215,13],[212,7,212,9],[215,7,215,9],[229,15,229,17],[232,15,232,17],[235,15,235,17],[238,15,238,17],[241,15,241,17],[283,7,283,9],[286,7,286,9],[259,7,259,9],[262,7,262,9],[265,7,265,9],[268,7,268,9],[271,7,271,9],[244,7,244,9],[247,7,247,9],[250,7,250,9],[253,7,253,9],[256,7,256,9],[304,7,304,9],[307,7,307,9],[310,7,310,9],[313,7,313,9],[220,11,220,13],[223,11,223,13],[226,11,226,13],[229,11,229,13],[232,11,232,13],[235,11,235,13],[238,11,238,13],[241,11,241,13],[244,11,244,13],[247,11,247,13],[250,11,250,13],[253,11,253,13],[289,7,289,9],[292,7,292,9],[295,7,295,9],[298,7,298,9],[301,7,301,9],[274,7,274,9],[277,7,277,9],[280,7,280,9],[313,11,313,13],[286,11,286,13],[289,11,289,13],[292,11,292,13],[295,11,295,13],[298,11,298,13],[271,11,271,13],[274,11,274,13],[277,11,277,13],[280,11,280,13],[283,11,283,13],[301,11,301,13],[304,11,304,13],[307,11,307,13],[310,11,310,13],[256,11,256,13],[259,11,259,13],[262,11,262,13],[265,11,265,13],[268,11,268,13],[283,15,283,17],[286,15,286,17],[259,15,259,17],[262,15,262,17],[265,15,265,17],[268,15,268,17],[271,15,271,17],[244,15,244,17],[247,15,247,17],[250,15,250,17],[253,15,253,17],[256,15,256,17],[304,15,304,17],[307,15,307,17],[310,15,310,17],[313,15,313,17],[220,19,220,21],[223,19,223,21],[226,19,226,21],[229,19,229,21],[232,19,232,21],[235,19,235,21],[238,19,238,21],[241,19,241,21],[244,19,244,21],[247,19,247,21],[250,19,250,21],[253,19,253,21],[289,15,289,17],[292,15,292,17],[295,15,295,17],[298,15,298,17],[301,15,301,17],[274,15,274,17],[277,15,277,17],[280,15,280,17],[271,19,271,21],[274,19,274,21],[277,19,277,21],[280,19,280,21],[283,19,283,21],[256,19,256,21],[259,19,259,21],[262,19,262,21],[265,19,265,21],[268,19,268,21],[301,19,301,21],[304,19,304,21],[307,19,307,21],[310,19,310,21],[313,19,313,21],[286,19,286,21],[289,19,289,21],[292,19,292,21],[295,19,295,21],[298,19,298,21],[244,23,244,25],[247,23,247,25],[250,23,250,25],[253,23,253,25],[256,23,256,25],[229,23,229,25],[232,23,232,25],[235,23,235,25],[238,23,238,25],[241,23,241,25],[274,23,274,25],[277,23,277,25],[280,23,280,25],[283,23,283,25],[286,23,286,25],[259,23,259,25],[262,23,262,25],[265,23,265,25],[268,23,268,25],[271,23,271,25],[304,23,304,25],[307,23,307,25],[310,23,310,25],[313,23,313,25],[289,23,289,25],[292,23,292,25],[295,23,295,25],[298,23,298,25],[301,23,301,25]]}
[]
[null,null,null,null,"County:",null,null,null,"Highway:",null,null,null,"Design:",null,null," Date:",{"$f":"TODAY()","v":"2024-06-05"}]
[null,null,null,null,"C-S-J:",null,null,null,"ID# :",null,null,null,"Checker:",null,null," Date:"]
[]
[null,null,null,null,null,"Description:"]
[]
[null,null,null,null,"Bridge Division"]
[]
[]
[null,null,"INSTRUCTIONS:"]
[]
[null,null,1,"Select appropriate number of bents and spans from the dropdowns below. Note changing number of spans or bents will delete previous information."]
[null,null,2,"Create the Bearing Seat report in OBM and export to CSV."]
[null,null,3,"Copy row by row of elevations from then OBM Report to the Green Fields"]
[null,null,4,"Manually enter the Bearing Seat elevations from BGS in the Orange fields"]
[null,null,5,"The discrepancies between values will be calculated below, a positive value indicates OBM is over and negative indicates OBM is lower."]
[]
[null,null,null,"Number of Beams",null,null,null,"Number of Bents"]
[]
[]
[null,null,"Bearing Seat Elevations - 3 Pads per Beam"]
[]
[null,null,null,"Open Bridge Modeler Report"]
[]
[null,null,null,null,null,"Location",null,"Beam 1",null,null,null,"Beam 2",null,null,null,"Beam 3",null,null,null,"Beam 4",null,null,null,"Beam 5"]
[null,null,null,"Abutment 1",null,"Fwd"]
[]
[null,null,null,"Bent 2",null,"Back"]
[null,null,null,null,null,"Fwd"]
[]
[null,null,null,"Bent 3",null,"Back"]
[null,null,null,null,null,"Fwd"]
[]
[null,null,null,"Bent 4",null,"Back"]
[null,null,null,null,null,"Fwd"]
[]
[null,null,null,"Bent 5",null,"Back"]
[null,null,null,null,null,"Fwd"]
[]
[null,null,null,"Bent 6",null,"Back"]
[null,null,null,null,null,"Fwd"]
[]
[null,null,null,"Bent 7",null,"Back"]
[null,null,null,null,null,"Fwd"]
[]
[null,null,null,"Bent 8",null,"Back"]
[null,null,null,null,null,"Fwd"]
[]
[null,null,null,"Bent 9",null,"Back"]
[null,null,null,null,null,"Fwd"]
[]
[null,null,null,"Bent 10",null,"Back"]
[null,null,null,null,null,"Fwd"]
[]
[null,null,null,"Bent 11",null,"Back"]
[null,null,null,null,null,"Fwd"]
[]
[null,null,null,"Bent 12",null,"Back"]
[null,null,null,null,null,"Fwd"]
[]
[null,null,null,"Bent 13",null,"Back"]
[null,null,null,null,null,"Fwd"]
[]
[null,null,null,"Bent 14",null,"Back"]
[null,null,null,null,null,"Fwd"]
[]
[null,null,null,"Bent 15",null,"Back"]
[null,null,null,null,null,"Fwd"]
[]
[null,null,null,"Bent 16",null,"Back"]
[null,null,null,null,null,"Fwd"]
[]
[null,null,null,"Bent 17",null,"Back"]
[null,null,null,null,null,"Fwd"]
[]
[null,null,null,"Bent 18",null,"Back"]
[null,null,null,null,null,"Fwd"]
[]
[null,null,null,"Bent 19",null,"Back"]
[null,null,null,null,null,"Fwd"]
[]
[null,null,null,"Bent 20",null,"Back"]
[null,null,null,null,null,"Fwd"]
[]
[null,null,null,"Bent 21",null,"Back"]
[null,null,null,null,null,"Fwd"]
[]
[null,null,null,"Bent 22",null,"Back"]
[null,null,null,null,null,"Fwd"]
[]
[null,null,null,"Bent 23",null,"Back"]
[null,null,null,null,null,"Fwd"]
[]
[null,null,null,"Bent 24",null,"Back"]
[null,null,null,null,null,"Fwd"]
[]
[null,null,null,"Bent 25",null,"Back"]
[null,null,null,null,null,"Fwd"]
[]
[null,null,null,"Bent 26",null,"Back"]
[null,null,null,null,null,"Fwd"]
[]
[null,null,null,"Bent 27",null,"Back"]
[null,null,null,null,null,"Fwd"]
[]
[null,null,null,"Bent 28",null,"Back"]
[null,null,null,null,null,"Fwd"]
[]
[null,null,null,"Bent 29",null,"Back"]
[null,null,null,null,null,"Fwd"]
[]
[null,null,null,"Bent 30",null,"Back"]
[null,null,null,null,null,"Fwd"]
[]
[null,null,null,"Bent 31",null,"Back"]
[null,null,null,null,null,"Fwd"]
[]
[null,null,null,"Abutment 32",null,"Back"]
[]
[]
[null,null,null,"LS4 Output from BGS"]
[]
[null,null,null,null,null,"Location",null,"Beam 1",null,null,null,"Beam 2",null,null,null,"Beam 3",null,null,null,"Beam 4",null,null,null,"Beam 5"]
[null,null,null,"Abutment 1",null,"Fwd"]
[]
[null,null,null,"Bent 2",null,"Back"]
[null,null,null,null,null,"Fwd"]
[]
[null,null,null,"Bent 3",null,"Back"]
[null,null,null,null,null,"Fwd"]
[]
[null,null,null,"Bent 4",null,"Back"]
[null,null,null,null,null,"Fwd"]
[]
[null,null,null,"Bent 5",null,"Back"]
[null,null,null,null,null,"Fwd"]
[]
[null,null,null,"Bent 6",null,"Back"]
[null,null,null,null,null,"Fwd"]
[]
[null,null,null,"Bent 7",null,"Back"]
[null,null,null,null,null,"Fwd"]
[]
[null,null,null,"Bent 8",null,"Back"]
[null,null,null,null,null,"Fwd"]
[]
[null,null,null,"Bent 9",null,"Back"]
[null,null,null,null,null,"Fwd"]
[]
[null,null,null,"Bent 10",null,"Back"]
[null,null,null,null,null,"Fwd"]
[]
[null,null,null,"Bent 11",null,"Back"]
[null,null,null,null,null,"Fwd"]
[]
[null,null,null,"Bent 12",null,"Back"]
[null,null,null,null,null,"Fwd"]
[]
[null,null,null,"Bent 13",null,"Back"]
[null,null,null,null,null,"Fwd"]
[]
[null,null,null,"Bent 14",null,"Back"]
[null,null,null,null,null,"Fwd"]
[]
[null,null,null,"Bent 15",null,"Back"]
[null,null,null,null,null,"Fwd"]
[]
[null,null,null,"Bent 16",null,"Back"]
[null,null,null,null,null,"Fwd"]
[]
[null,null,null,"Bent 17",null,"Back"]
[null,null,null,null,null,"Fwd"]
[]
[null,null,null,"Bent 18",null,"Back"]
[null,null,null,null,null,"Fwd"]
[]
[null,null,null,"Bent 19",null,"Back"]
[null,null,null,null,null,"Fwd"]
[]
[null,null,null,"Bent 20",null,"Back"]
[null,null,null,null,null,"Fwd"]
[]
[null,null,null,"Bent 21",null,"Back"]
[null,null,null,null,null,"Fwd"]
[]
[null,null,null,"Bent 22",null,"Back"]
[null,null,null,null,null,"Fwd"]
[]
[null,null,null,"Bent 23",null,"Back"]
[null,null,null,null,null,"Fwd"]
[]
[null,null,null,"Bent 24",null,"Back"]
[null,null,null,null,null,"Fwd"]
[]
[null,null,null,"Bent 25",null,"Back"]
[null,null,null,null,null,"Fwd"]
[]
[null,null,null,"Bent 26",null,"Back"]
[null,null,null,null,null,"Fwd"]
[]
[null,null,null,"Bent 27",null,"Back"]
[null,null,null,null,null,"Fwd"]
[]
[null,null,null,"Bent 28",null,"Back"]
[null,null,null,null,null,"Fwd"]
[]
[null,null,null,"Bent 29",null,"Back"]
[null,null,null,null,null,"Fwd"]
[]
[null,null,null,"Bent 30",null,"Back"]
[null,null,null,null,null,"Fwd"]
[]
[null,null,null,"Bent 31",null,"Back"]
[null,null,null,null,null,"Fwd"]
[]
[null,null,null,"Abutment 32",null,"Back"]
[]
[]
[null,null,null,"Discrepancies"]
[]
[null,null,null,null,null,"Location",null,"Beam 1",null,null,null,"Beam 2",null,null,null,"Beam 3",null,null,null,"Beam 4",null,null,null,"Beam 5"]
[null,null,null,"Abutment 1",null,"Fwd",null,{"$f":"$H$26-$H$124","v":0},null,{"$f":"$J$26-$J$124","v":0},null,{"$f":"$L$26-$L$124","v":0},null,{"$f":"$N$26-$N$124","v":0},null,{"$f":"$P$26-$P$124","v":0},null,{"$f":"$R$26-$R$124","v":0},null,{"$f":"$T$26-$T$124","v":0},null,{"$f":"$V$26-$V$124","v":0},null,{"$f":"$X$26-$X$124","v":0},null,{"$f":"$Z$26-$Z$124","v":0}]
[]
[null,null,null,"Bent 2",null,"Back",null,{"$f":"$H$28-$H$126","v":0},null,null,null,{"$f":"$L$28-$L$126","v":0},null,null,null,{"$f":"$P$28-$P$126","v":0},null,null,null,{"$f":"$T$28-$T$126","v":0},null,null,null,{"$f":"$X$28-$X$126","v":0}]
[null,null,null,null,null,"Fwd",null,{"$f":"$H$29-$H$127","v":0},null,{"$f":"$J$29-$J$127","v":0},null,{"$f":"$L$29-$L$127","v":0},null,{"$f":"$N$29-$N$127","v":0},null,{"$f":"$P$29-$P$127","v":0},null,{"$f":"$R$29-$R$127","v":0},null,{"$f":"$T$29-$T$127","v":0},null,{"$f":"$V$29-$V$127","v":0},null,{"$f":"$X$29-$X$127","v":0},null,{"$f":"$Z$29-$Z$127","v":0}]
[]
[null,null,null,"Bent 3",null,"Back",null,{"$f":"$H$31-$H$129","v":0},null,null,null,{"$f":"$L$31-$L$129","v":0},null,null,null,{"$f":"$P$31-$P$129","v":0},null,null,null,{"$f":"$T$31-$T$129","v":0},null,null,null,{"$f":"$X$31-$X$129","v":0}]
[null,null,null,null,null,"Fwd",null,{"$f":"$H$32-$H$130","v":0},null,{"$f":"$J$32-$J$130","v":0},null,{"$f":"$L$32-$L$130","v":0},null,{"$f":"$N$32-$N$130","v":0},null,{"$f":"$P$32-$P$130","v":0},null,{"$f":"$R$32-$R$130","v":0},null,{"$f":"$T$32-$T$130","v":0},null,{"$f":"$V$32-$V$130","v":0},null,{"$f":"$X$32-$X$130","v":0},null,{"$f":"$Z$32-$Z$130","v":0}]
[]
[null,null,null,"Bent 4",null,"Back",null,{"$f":"$H$34-$H$132","v":0},null,null,null,{"$f":"$L$34-$L$132","v":0},null,null,null,{"$f":"$P$34-$P$132","v":0},null,null,null,{"$f":"$T$34-$T$132","v":0},null,null,null,{"$f":"$X$34-$X$132","v":0}]
[null,null,null,null,null,"Fwd",null,{"$f":"$H$35-$H$133","v":0},null,{"$f":"$J$35-$J$133","v":0},null,{"$f":"$L$35-$L$133","v":0},null,{"$f":"$N$35-$N$133","v":0},null,{"$f":"$P$35-$P$133","v":0},null,{"$f":"$R$35-$R$133","v":0},null,{"$f":"$T$35-$T$133","v":0},null,{"$f":"$V$35-$V$133","v":0},null,{"$f":"$X$35-$X$133","v":0},null,{"$f":"$Z$35-$Z$133","v":0}]
[]
[null,null,null,"Bent 5",null,"Back",null,{"$f":"$H$37-$H$135","v":0},null,null,null,{"$f":"$L$37-$L$135","v":0},null,null,null,{"$f":"$P$37-$P$135","v":0},null,null,null,{"$f":"$T$37-$T$135","v":0},null,null,null,{"$f":"$X$37-$X$135","v":0}]
[null,null,null,null,null,"Fwd",null,{"$f":"$H$38-$H$136","v":0},null,{"$f":"$J$38-$J$136","v":0},null,{"$f":"$L$38-$L$136","v":0},null,{"$f":"$N$38-$N$136","v":0},null,{"$f":"$P$38-$P$136","v":0},null,{"$f":"$R$38-$R$136","v":0},null,{"$f":"$T$38-$T$136","v":0},null,{"$f":"$V$38-$V$136","v":0},null,{"$f":"$X$38-$X$136","v":0},null,{"$f":"$Z$38-$Z$136","v":0}]
[]
[null,null,null,"Bent 6",null,"Back",null,{"$f":"$H$40-$H$138","v":0},null,null,null,{"$f":"$L$40-$L$138","v":0},null,null,null,{"$f":"$P$40-$P$138","v":0},null,null,null,{"$f":"$T$40-$T$138","v":0},null,null,null,{"$f":"$X$40-$X$138","v":0}]
[null,null,null,null,null,"Fwd",null,{"$f":"$H$41-$H$139","v":0},null,{"$f":"$J$41-$J$139","v":0},null,{"$f":"$L$41-$L$139","v":0},null,{"$f":"$N$41-$N$139","v":0},null,{"$f":"$P$41-$P$139","v":0},null,{"$f":"$R$41-$R$139","v":0},null,{"$f":"$T$41-$T$139","v":0},null,{"$f":"$V$41-$V$139","v":0},null,{"$f":"$X$41-$X$139","v":0},null,{"$f":"$Z$41-$Z$139","v":0}]
[]
[null,null,null,"Bent 7",null,"Back",null,{"$f":"$H$43-$H$141","v":0},null,null,null,{"$f":"$L$43-$L$141","v":0},null,null,null,{"$f":"$P$43-$P$141","v":0},null,null,null,{"$f":"$T$43-$T$141","v":0},null,null,null,{"$f":"$X$43-$X$141","v":0}]
[null,null,null,null,null,"Fwd",null,{"$f":"$H$44-$H$142","v":0},null,{"$f":"$J$44-$J$142","v":0},null,{"$f":"$L$44-$L$142","v":0},null,{"$f":"$N$44-$N$142","v":0},null,{"$f":"$P$44-$P$142","v":0},null,{"$f":"$R$44-$R$142","v":0},null,{"$f":"$T$44-$T$142","v":0},null,{"$f":"$V$44-$V$142","v":0},null,{"$f":"$X$44-$X$142","v":0},null,{"$f":"$Z$44-$Z$142","v":0}]
[]
[null,null,null,"Bent 8",null,"Back",null,{"$f":"$H$46-$H$144","v":0},null,null,null,{"$f":"$L$46-$L$144","v":0},null,null,null,{"$f":"$P$46-$P$144","v":0},null,null,null,{"$f":"$T$46-$T$144","v":0},null,null,null,{"$f":"$X$46-$X$144","v":0}]
[null,null,null,null,null,"Fwd",null,{"$f":"$H$47-$H$145","v":0},null,{"$f":"$J$47-$J$145","v":0},null,{"$f":"$L$47-$L$145","v":0},null,{"$f":"$N$47-$N$145","v":0},null,{"$f":"$P$47-$P$145","v":0},null,{"$f":"$R$47-$R$145","v":0},null,{"$f":"$T$47-$T$145","v":0},null,{"$f":"$V$47-$V$145","v":0},null,{"$f":"$X$47-$X$145","v":0},null,{"$f":"$Z$47-$Z$145","v":0}]
[]
[null,null,null,"Bent 9",null,"Back",null,{"$f":"$H$49-$H$147","v":0},null,null,null,{"$f":"$L$49-$L$147","v":0},null,null,null,{"$f":"$P$49-$P$147","v":0},null,null,null,{"$f":"$T$49-$T$147","v":0},null,null,null,{"$f":"$X$49-$X$147","v":0}]
[null,null,null,null,null,"Fwd",null,{"$f":"$H$50-$H$148","v":0},null,{"$f":"$J$50-$J$148","v":0},null,{"$f":"$L$50-$L$148","v":0},null,{"$f":"$N$50-$N$148","v":0},null,{"$f":"$P$50-$P$148","v":0},null,{"$f":"$R$50-$R$148","v":0},null,{"$f":"$T$50-$T$148","v":0},null,{"$f":"$V$50-$V$148","v":0},null,{"$f":"$X$50-$X$148","v":0},null,{"$f":"$Z$50-$Z$148","v":0}]
[]
[null,null,null,"Bent 10",null,"Back",null,{"$f":"$H$52-$H$150","v":0},null,null,null,{"$f":"$L$52-$L$150","v":0},null,null,null,{"$f":"$P$52-$P$150","v":0},null,null,null,{"$f":"$T$52-$T$150","v":0},null,null,null,{"$f":"$X$52-$X$150","v":0}]
[null,null,null,null,null,"Fwd",null,{"$f":"$H$53-$H$151","v":0},null,{"$f":"$J$53-$J$151","v":0},null,{"$f":"$L$53-$L$151","v":0},null,{"$f":"$N$53-$N$151","v":0},null,{"$f":"$P$53-$P$151","v":0},null,{"$f":"$R$53-$R$151","v":0},null,{"$f":"$T$53-$T$151","v":0},null,{"$f":"$V$53-$V$151","v":0},null,{"$f":"$X$53-$X$151","v":0},null,{"$f":"$Z$53-$Z$151","v":0}]
[]
[null,null,null,"Bent 11",null,"Back",null,{"$f":"$H$55-$H$153","v":0},null,null,null,{"$f":"$L$55-$L$153","v":0},null,null,null,{"$f":"$P$55-$P$153","v":0},null,null,null,{"$f":"$T$55-$T$153","v":0},null,null,null,{"$f":"$X$55-$X$153","v":0}]
[null,null,null,null,null,"Fwd",null,{"$f":"$H$56-$H$154","v":0},null,{"$f":"$J$56-$J$154","v":0},null,{"$f":"$L$56-$L$154","v":0},null,{"$f":"$N$56-$N$154","v":0},null,{"$f":"$P$56-$P$154","v":0},null,{"$f":"$R$56-$R$154","v":0},null,{"$f":"$T$56-$T$154","v":0},null,{"$f":"$V$56-$V$154","v":0},null,{"$f":"$X$56-$X$154","v":0},null,{"$f":"$Z$56-$Z$154","v":0}]
[]
[null,null,null,"Bent 12",null,"Back",null,{"$f":"$H$58-$H$156","v":0},null,null,null,{"$f":"$L$58-$L$156","v":0},null,null,null,{"$f":"$P$58-$P$156","v":0},null,null,null,{"$f":"$T$58-$T$156","v":0},null,null,null,{"$f":"$X$58-$X$156","v":0}]
[null,null,null,null,null,"Fwd",null,{"$f":"$H$59-$H$157","v":0},null,{"$f":"$J$59-$J$157","v":0},null,{"$f":"$L$59-$L$157","v":0},null,{"$f":"$N$59-$N$157","v":0},null,{"$f":"$P$59-$P$157","v":0},null,{"$f":"$R$59-$R$157","v":0},null,{"$f":"$T$59-$T$157","v":0},null,{"$f":"$V$59-$V$157","v":0},null,{"$f":"$X$59-$X$157","v":0},null,{"$f":"$Z$59-$Z$157","v":0}]
[]
[null,null,null,"Bent 13",null,"Back",null,{"$f":"$H$61-$H$159","v":0},null,null,null,{"$f":"$L$61-$L$159","v":0},null,null,null,{"$f":"$P$61-$P$159","v":0},null,null,null,{"$f":"$T$61-$T$159","v":0},null,null,null,{"$f":"$X$61-$X$159","v":0}]
[null,null,null,null,null,"Fwd",null,{"$f":"$H$62-$H$160","v":0},null,{"$f":"$J$62-$J$160","v":0},null,{"$f":"$L$62-$L$160","v":0},null,{"$f":"$N$62-$N$160","v":0},null,{"$f":"$P$62-$P$160","v":0},null,{"$f":"$R$62-$R$160","v":0},null,{"$f":"$T$62-$T$160","v":0},null,{"$f":"$V$62-$V$160","v":0},null,{"$f":"$X$62-$X$160","v":0},null,{"$f":"$Z$62-$Z$160","v":0}]
[]
[null,null,null,"Bent 14",null,"Back",null,{"$f":"$H$64-$H$162","v":0},null,null,null,{"$f":"$L$64-$L$162","v":0},null,null,null,{"$f":"$P$64-$P$162","v":0},null,null,null,{"$f":"$T$64-$T$162","v":0},null,null,null,{"$f":"$X$64-$X$162","v":0}]
[null,null,null,null,null,"Fwd",null,{"$f":"$H$65-$H$163","v":0},null,{"$f":"$J$65-$J$163","v":0},null,{"$f":"$L$65-$L$163","v":0},null,{"$f":"$N$65-$N$163","v":0},null,{"$f":"$P$65-$P$163","v":0},null,{"$f":"$R$65-$R$163","v":0},null,{"$f":"$T$65-$T$163","v":0},null,{"$f":"$V$65-$V$163","v":0},null,{"$f":"$X$65-$X$163","v":0},null,{"$f":"$Z$65-$Z$163","v":0}]
[]
[null,null,null,"Bent 15",null,"Back",null,{"$f":"$H$67-$H$165","v":0},null,null,null,{"$f":"$L$67-$L$165","v":0},null,null,null,{"$f":"$P$67-$P$165","v":0},null,null,null,{"$f":"$T$67-$T$165","v":0},null,null,null,{"$f":"$X$67-$X$165","v":0}]
[null,null,null,null,null,"Fwd",null,{"$f":"$H$68-$H$166","v":0},null,{"$f":"$J$68-$J$166","v":0},null,{"$f":"$L$68-$L$166","v":0},null,{"$f":"$N$68-$N$166","v":0},null,{"$f":"$P$68-$P$166","v":0},null,{"$f":"$R$68-$R$166","v":0},null,{"$f":"$T$68-$T$166","v":0},null,{"$f":"$V$68-$V$166","v":0},null,{"$f":"$X$68-$X$166","v":0},null,{"$f":"$Z$68-$Z$166","v":0}]
[]
[null,null,null,"Bent 16",null,"Back",null,{"$f":"$H$70-$H$168","v":0},null,null,null,{"$f":"$L$70-$L$168","v":0},null,null,null,{"$f":"$P$70-$P$168","v":0},null,null,null,{"$f":"$T$70-$T$168","v":0},null,null,null,{"$f":"$X$70-$X$168","v":0}]
[null,null,null,null,null,"Fwd",null,{"$f":"$H$71-$H$169","v":0},null,{"$f":"$J$71-$J$169","v":0},null,{"$f":"$L$71-$L$169","v":0},null,{"$f":"$N$71-$N$169","v":0},null,{"$f":"$P$71-$P$169","v":0},null,{"$f":"$R$71-$R$169","v":0},null,{"$f":"$T$71-$T$169","v":0},null,{"$f":"$V$71-$V$169","v":0},null,{"$f":"$X$71-$X$169","v":0},null,{"$f":"$Z$71-$Z$169","v":0}]
[]
[null,null,null,"Bent 17",null,"Back",null,{"$f":"$H$73-$H$171","v":0},null,null,null,{"$f":"$L$73-$L$171","v":0},null,null,null,{"$f":"$P$73-$P$171","v":0},null,null,null,{"$f":"$T$73-$T$171","v":0},null,null,null,{"$f":"$X$73-$X$171","v":0}]
[null,null,null,null,null,"Fwd",null,{"$f":"$H$74-$H$172","v":0},null,{"$f":"$J$74-$J$172","v":0},null,{"$f":"$L$74-$L$172","v":0},null,{"$f":"$N$74-$N$172","v":0},null,{"$f":"$P$74-$P$172","v":0},null,{"$f":"$R$74-$R$172","v":0},null,{"$f":"$T$74-$T$172","v":0},null,{"$f":"$V$74-$V$172","v":0},null,{"$f":"$X$74-$X$172","v":0},null,{"$f":"$Z$74-$Z$172","v":0}]
[]
[null,null,null,"Bent 18",null,"Back",null,{"$f":"$H$76-$H$174","v":0},null,null,null,{"$f":"$L$76-$L$174","v":0},null,null,null,{"$f":"$P$76-$P$174","v":0},null,null,null,{"$f":"$T$76-$T$174","v":0},null,null,null,{"$f":"$X$76-$X$174","v":0}]
[null,null,null,null,null,"Fwd",null,{"$f":"$H$77-$H$175","v":0},null,{"$f":"$J$77-$J$175","v":0},null,{"$f":"$L$77-$L$175","v":0},null,{"$f":"$N$77-$N$175","v":0},null,{"$f":"$P$77-$P$175","v":0},null,{"$f":"$R$77-$R$175","v":0},null,{"$f":"$T$77-$T$175","v":0},null,{"$f":"$V$77-$V$175","v":0},null,{"$f":"$X$77-$X$175","v":0},null,{"$f":"$Z$77-$Z$175","v":0}]
[]
[null,null,null,"Bent 19",null,"Back",null,{"$f":"$H$79-$H$177","v":0},null,null,null,{"$f":"$L$79-$L$177","v":0},null,null,null,{"$f":"$P$79-$P$177","v":0},null,null,null,{"$f":"$T$79-$T$177","v":0},null,null,null,{"$f":"$X$79-$X$177","v":0}]
[null,null,null,null,null,"Fwd",null,{"$f":"$H$80-$H$178","v":0},null,{"$f":"$J$80-$J$178","v":0},null,{"$f":"$L$80-$L$178","v":0},null,{"$f":"$N$80-$N$178","v":0},null,{"$f":"$P$80-$P$178","v":0},null,{"$f":"$R$80-$R$178","v":0},null,{"$f":"$T$80-$T$178","v":0},null,{"$f":"$V$80-$V$178","v":0},null,{"$f":"$X$80-$X$178","v":0},null,{"$f":"$Z$80-$Z$178","v":0}]
[]
[null,null,null,"Bent 20",null,"Back",null,{"$f":"$H$82-$H$180","v":0},null,null,null,{"$f":"$L$82-$L$180","v":0},null,null,null,{"$f":"$P$82-$P$180","v":0},null,null,null,{"$f":"$T$82-$T$180","v":0},null,null,null,{"$f":"$X$82-$X$180","v":0}]
[null,null,null,null,null,"Fwd",null,{"$f":"$H$83-$H$181","v":0},null,{"$f":"$J$83-$J$181","v":0},null,{"$f":"$L$83-$L$181","v":0},null,{"$f":"$N$83-$N$181","v":0},null,{"$f":"$P$83-$P$181","v":0},null,{"$f":"$R$83-$R$181","v":0},null,{"$f":"$T$83-$T$181","v":0},null,{"$f":"$V$83-$V$181","v":0},null,{"$f":"$X$83-$X$181","v":0},null,{"$f":"$Z$83-$Z$181","v":0}]
[]
[null,null,null,"Bent 21",null,"Back",null,{"$f":"$H$85-$H$183","v":0},null,null,null,{"$f":"$L$85-$L$183","v":0},null,null,null,{"$f":"$P$85-$P$183","v":0},null,null,null,{"$f":"$T$85-$T$183","v":0},null,null,null,{"$f":"$X$85-$X$183","v":0}]
[null,null,null,null,null,"Fwd",null,{"$f":"$H$86-$H$184","v":0},null,{"$f":"$J$86-$J$184","v":0},null,{"$f":"$L$86-$L$184","v":0},null,{"$f":"$N$86-$N$184","v":0},null,{"$f":"$P$86-$P$184","v":0},null,{"$f":"$R$86-$R$184","v":0},null,{"$f":"$T$86-$T$184","v":0},null,{"$f":"$V$86-$V$184","v":0},null,{"$f":"$X$86-$X$184","v":0},null,{"$f":"$Z$86-$Z$184","v":0}]
[]
[null,null,null,"Bent 22",null,"Back",null,{"$f":"$H$88-$H$186","v":0},null,null,null,{"$f":"$L$88-$L$186","v":0},null,null,null,{"$f":"$P$88-$P$186","v":0},null,null,null,{"$f":"$T$88-$T$186","v":0},null,null,null,{"$f":"$X$88-$X$186","v":0}]
[null,null,null,null,null,"Fwd",null,{"$f":"$H$89-$H$187","v":0},null,{"$f":"$J$89-$J$187","v":0},null,{"$f":"$L$89-$L$187","v":0},null,{"$f":"$N$89-$N$187","v":0},null,{"$f":"$P$89-$P$187","v":0},null,{"$f":"$R$89-$R$187","v":0},null,{"$f":"$T$89-$T$187","v":0},null,{"$f":"$V$89-$V$187","v":0},null,{"$f":"$X$89-$X$187","v":0},null,{"$f":"$Z$89-$Z$187","v":0}]
[]
[null,null,null,"Bent 23",null,"Back",null,{"$f":"$H$91-$H$189","v":0},null,null,null,{"$f":"$L$91-$L$189","v":0},null,null,null,{"$f":"$P$91-$P$189","v":0},null,null,null,{"$f":"$T$91-$T$189","v":0},null,null,null,{"$f":"$X$91-$X$189","v":0}]
[null,null,null,null,null,"Fwd",null,{"$f":"$H$92-$H$190","v":0},null,{"$f":"$J$92-$J$190","v":0},null,{"$f":"$L$92-$L$190","v":0},null,{"$f":"$N$92-$N$190","v":0},null,{"$f":"$P$92-$P$190","v":0},null,{"$f":"$R$92-$R$190","v":0},null,{"$f":"$T$92-$T$190","v":0},null,{"$f":"$V$92-$V$190","v":0},null,{"$f":"$X$92-$X$190","v":0},null,{"$f":"$Z$92-$Z$190","v":0}]
[]
[null,null,null,"Bent 24",null,"Back",null,{"$f":"$H$94-$H$192","v":0},null,null,null,{"$f":"$L$94-$L$192","v":0},null,null,null,{"$f":"$P$94-$P$192","v":0},null,null,null,{"$f":"$T$94-$T$192","v":0},null,null,null,{"$f":"$X$94-$X$192","v":0}]
[null,null,null,null,null,"Fwd",null,{"$f":"$H$95-$H$193","v":0},null,{"$f":"$J$95-$J$193","v":0},null,{"$f":"$L$95-$L$193","v":0},null,{"$f":"$N$95-$N$193","v":0},null,{"$f":"$P$95-$P$193","v":0},null,{"$f":"$R$95-$R$193","v":0},null,{"$f":"$T$95-$T$193","v":0},null,{"$f":"$V$95-$V$193","v":0},null,{"$f":"$X$95-$X$193","v":0},null,{"$f":"$Z$95-$Z$193","v":0}]
[]
[null,null,null,"Bent 25",null,"Back",null,{"$f":"$H$97-$H$195","v":0},null,null,null,{"$f":"$L$97-$L$195","v":0},null,null,null,{"$f":"$P$97-$P$195","v":0},null,null,null,{"$f":"$T$97-$T$195","v":0},null,null,null,{"$f":"$X$97-$X$195","v":0}]
[null,null,null,null,null,"Fwd",null,{"$f":"$H$98-$H$196","v":0},null,{"$f":"$J$98-$J$196","v":0},null,{"$f":"$L$98-$L$196","v":0},null,{"$f":"$N$98-$N$196","v":0},null,{"$f":"$P$98-$P$196","v":0},null,{"$f":"$R$98-$R$196","v":0},null,{"$f":"$T$98-$T$196","v":0},null,{"$f":"$V$98-$V$196","v":0},null,{"$f":"$X$98-$X$196","v":0},null,{"$f":"$Z$98-$Z$196","v":0}]
[]
[null,null,null,"Bent 26",null,"Back",null,{"$f":"$H$100-$H$198","v":0},null,null,null,{"$f":"$L$100-$L$198","v":0},null,null,null,{"$f":"$P$100-$P$198","v":0},null,null,null,{"$f":"$T$100-$T$198","v":0},null,null,null,{"$f":"$X$100-$X$198","v":0}]
[null,null,null,null,null,"Fwd",null,{"$f":"$H$101-$H$199","v":0},null,{"$f":"$J$101-$J$199","v":0},null,{"$f":"$L$101-$L$199","v":0},null,{"$f":"$N$101-$N$199","v":0},null,{"$f":"$P$101-$P$199","v":0},null,{"$f":"$R$101-$R$199","v":0},null,{"$f":"$T$101-$T$199","v":0},null,{"$f":"$V$101-$V$199","v":0},null,{"$f":"$X$101-$X$199","v":0},null,{"$f":"$Z$101-$Z$199","v":0}]
[]
[null,null,null,"Bent 27",null,"Back",null,{"$f":"$H$103-$H$201","v":0},null,null,null,{"$f":"$L$103-$L$201","v":0},null,null,null,{"$f":"$P$103-$P$201","v":0},null,null,null,{"$f":"$T$103-$T$201","v":0},null,null,null,{"$f":"$X$103-$X$201","v":0}]
[null,null,null,null,null,"Fwd",null,{"$f":"$H$104-$H$202","v":0},null,{"$f":"$J$104-$J$202","v":0},null,{"$f":"$L$104-$L$202","v":0},null,{"$f":"$N$104-$N$202","v":0},null,{"$f":"$P$104-$P$202","v":0},null,{"$f":"$R$104-$R$202","v":0},null,{"$f":"$T$104-$T$202","v":0},null,{"$f":"$V$104-$V$202","v":0},null,{"$f":"$X$104-$X$202","v":0},null,{"$f":"$Z$104-$Z$202","v":0}]
[]
[null,null,null,"Bent 28",null,"Back",null,{"$f":"$H$106-$H$204","v":0},null,null,null,{"$f":"$L$106-$L$204","v":0},null,null,null,{"$f":"$P$106-$P$204","v":0},null,null,null,{"$f":"$T$106-$T$204","v":0},null,null,null,{"$f":"$X$106-$X$204","v":0}]
[null,null,null,null,null,"Fwd",null,{"$f":"$H$107-$H$205","v":0},null,{"$f":"$J$107-$J$205","v":0},null,{"$f":"$L$107-$L$205","v":0},null,{"$f":"$N$107-$N$205","v":0},null,{"$f":"$P$107-$P$205","v":0},null,{"$f":"$R$107-$R$205","v":0},null,{"$f":"$T$107-$T$205","v":0},null,{"$f":"$V$107-$V$205","v":0},null,{"$f":"$X$107-$X$205","v":0},null,{"$f":"$Z$107-$Z$205","v":0}]
[]
[null,null,null,"Bent 29",null,"Back",null,{"$f":"$H$109-$H$207","v":0},null,null,null,{"$f":"$L$109-$L$207","v":0},null,null,null,{"$f":"$P$109-$P$207","v":0},null,null,null,{"$f":"$T$109-$T$207","v":0},null,null,null,{"$f":"$X$109-$X$207","v":0}]
[null,null,null,null,null,"Fwd",null,{"$f":"$H$110-$H$208","v":0},null,{"$f":"$J$110-$J$208","v":0},null,{"$f":"$L$110-$L$208","v":0},null,{"$f":"$N$110-$N$208","v":0},null,{"$f":"$P$110-$P$208","v":0},null,{"$f":"$R$110-$R$208","v":0},null,{"$f":"$T$110-$T$208","v":0},null,{"$f":"$V$110-$V$208","v":0},null,{"$f":"$X$110-$X$208","v":0},null,{"$f":"$Z$110-$Z$208","v":0}]
[]
[null,null,null,"Bent 30",null,"Back",null,{"$f":"$H$112-$H$210","v":0},null,null,null,{"$f":"$L$112-$L$210","v":0},null,null,null,{"$f":"$P$112-$P$210","v":0},null,null,null,{"$f":"$T$112-$T$210","v":0},null,null,null,{"$f":"$X$112-$X$210","v":0}]
[null,null,null,null,null,"Fwd",null,{"$f":"$H$113-$H$211","v":0},null,{"$f":"$J$113-$J$211","v":0},null,{"$f":"$L$113-$L$211","v":0},null,{"$f":"$N$113-$N$211","v":0},null,{"$f":"$P$113-$P$211","v":0},null,{"$f":"$R$113-$R$211","v":0},null,{"$f":"$T$113-$T$211","v":0},null,{"$f":"$V$113-$V$211","v":0},null,{"$f":"$X$113-$X$211","v":0},null,{"$f":"$Z$113-$Z$211","v":0}]
[]
[null,null,null,"Bent 31",null,"Back",null,{"$f":"$H$115-$H$213","v":0},null,null,null,{"$f":"$L$115-$L$213","v":0},null,null,null,{"$f":"$P$115-$P$213","v":0},null,null,null,{"$f":"$T$115-$T$213","v":0},null,null,null,{"$f":"$X$115-$X$213","v":0}]
[null,null,null,null,null,"Fwd",null,{"$f":"$H$116-$H$214","v":0},null,{"$f":"$J$116-$J$214","v":0},null,{"$f":"$L$116-$L$214","v":0},null,{"$f":"$N$116-$N$214","v":0},null,{"$f":"$P$116-$P$214","v":0},null,{"$f":"$R$116-$R$214","v":0},null,{"$f":"$T$116-$T$214","v":0},null,{"$f":"$V$116-$V$214","v":0},null,{"$f":"$X$116-$X$214","v":0},null,{"$f":"$Z$116-$Z$214","v":0}]
[]
[null,null,null,"Abutment 32",null,"Back",null,{"$f":"$H$118-$H$216","v":0},null,null,null,{"$f":"$L$118-$L$216","v":0},null,null,null,{"$f":"$P$118-$P$216","v":0},null,null,null,{"$f":"$T$118-$T$216","v":0},null,null,null,{"$f":"$X$118-$X$216","v":0}]

{"sheet":"Dropdown Values","index":2,"n_rows":32,"n_cols":2,"rows_kept":32,"cut":false,"hidden":true,"merged":[]}
["# Beams","# Bents"]
[{"$f":"_xlfn.SEQUENCE(20,1,1,1)","v":1},{"$f":"_xlfn.SEQUENCE(31,1,0,1)","v":0}]
[2,1]
[3,2]
[4,3]
[5,4]
[6,5]
[7,6]
[8,7]
[9,8]
[10,9]
[11,10]
[12,11]
[13,12]
[14,13]
[15,14]
[16,15]
[17,16]
[18,17]
[19,18]
[20,19]
[null,20]
[null,21]
[null,22]
[null,23]
[null,24]
[null,25]
[null,26]
[null,27]
[null,28]
[null,29]
[null,30]