{"text_format":"1","workbook":"xlsx","n_sheets":2,"sheets":["Unit 1","Data"],"not_rendered":{"charts":0,"images":1,"macros":1,"external_links":0,"defined_names":38,"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":"Unit 1","index":0,"n_rows":34,"n_cols":18,"rows_kept":34,"cut":false,"hidden":false,"merged":[[5,5,5,14],[6,4,7,6],[25,3,25,4],[25,11,25,12],[33,3,33,4],[33,11,33,12],[29,3,29,4],[29,11,29,12],[1,16,1,17],[2,16,2,17],[1,13,1,14],[2,13,2,14],[4,5,4,14],[1,5,1,6],[1,9,1,10],[3,5,3,6],[2,9,2,10],[2,5,2,6]]}
[]
[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,"Description:  "]
[]
[null,null,null,null,"Bridge Division"]
[]
[]
[null,null,"INSTRUCTIONS:"]
[]
[null,null,1,"Create the quantities report in OBM and export to Excel."]
[null,null,2,"Make a copy of this sheet for every Unit in the Bridge, OBM reports quantities per unit."]
[null,null,3,"Use the buttons on the right to insert elements in the same order as they are listed in the OBM Report."]
[null,null,4,"If rows were added by mistake simply delete the entire row(s) and continue added elements using the buttons."]
[null,null,5,"Change the component name in the OBM section to a more descriptive name (i.e. Wingwall Abutment #1 Cap; SSTR Barrier; Tx54 Beams)"]
[null,null,6,"Copy and Paste the quantities from the OBM Report into the Green fields, Note that the Deck Area may need to be entered manually."]
[null,null,7,"Copy and Paste the manually calculated values to the Orange fields or enter formulas as you would normally calculate your values."]
[null,null,8,"The discrepancies between values will be calculated, a positive value indicates OBM is over and negative indicates OBM is lower."]
[]
[null,null,"QUANTITIES:"]
[]
[null,null,"OpenBridge Modeler Quantities",null,null,null,null,null,null,null,"Manually calculated or Other method Quantities",null,null,null,null,null,null,"Discrepancies"]
[]
[null,null,"Superstructure Quantities",null,null,null,null,null,null,null,"Superstructure Quantities"]
[null,null,null,"Component Name",null,null,"Pay Unit","Quantity",null,null,null,"Component Name",null,null,"Pay Unit","Quantity"]
[]
[]
[null,null,"Substructure Quantities",null,null,null,null,null,null,null,"Substructure Quantities"]
[null,null,null,"Component Name",null,null,"Pay Unit","Quantity",null,null,null,"Component Name",null,null,"Pay Unit","Quantity"]
[]
[]
[null,null,"Miscellaneous Quantities",null,null,null,null,null,null,null,"Miscellaneous Quantities"]
[null,null,null,"Component Name",null,null,"Pay Unit","Quantity",null,null,null,"Component Name",null,null,"Pay Unit","Quantity"]

{"sheet":"Data","index":1,"n_rows":58,"n_cols":18,"rows_kept":58,"cut":false,"hidden":true,"merged":[[3,3,3,4],[3,11,3,12],[3,17,3,18],[41,3,41,4],[41,11,41,12],[41,17,41,18],[5,3,5,4],[5,11,5,12],[5,17,5,18],[7,3,7,4],[7,11,7,12],[7,17,7,18],[38,3,38,4],[38,11,38,12],[38,17,38,18],[39,3,39,4],[15,3,15,4],[15,11,15,12],[15,17,15,18],[39,11,39,12],[39,17,39,18],[36,11,36,12],[36,17,36,18],[37,3,37,4],[48,3,48,4],[48,11,48,12],[48,17,48,18],[52,3,52,4],[52,11,52,12],[52,17,52,18],[49,3,49,4],[49,11,49,12],[49,17,49,18],[51,3,51,4],[51,11,51,12],[51,17,51,18],[9,3,9,4],[9,11,9,12],[9,17,9,18],[21,3,21,4],[21,11,21,12],[21,17,21,18],[17,3,17,4],[17,11,17,12],[17,17,17,18],[19,3,19,4],[19,11,19,12],[19,17,19,18],[20,3,20,4],[20,11,20,12],[20,17,20,18],[11,3,11,4],[11,11,11,12],[11,17,11,18],[13,3,13,4],[13,11,13,12],[13,17,13,18],[23,3,23,4],[23,11,23,12],[23,17,23,18],[25,3,25,4],[25,11,25,12],[25,17,25,18],[55,3,55,4],[55,11,55,12],[55,17,55,18],[34,11,34,12],[34,17,34,18],[32,3,32,4],[32,11,32,12],[30,3,30,4],[30,11,30,12],[30,17,30,18],[27,3,27,4],[27,11,27,12],[27,17,27,18],[29,3,29,4],[29,11,29,12],[29,17,29,18],[42,17,42,18],[43,3,43,4],[57,3,57,4],[57,11,57,12],[57,17,57,18],[36,3,36,4],[32,17,32,18],[33,3,33,4],[33,11,33,12],[33,17,33,18],[34,3,34,4],[37,11,37,12],[37,17,37,18],[47,3,47,4],[47,11,47,12],[47,17,47,18],[42,3,42,4],[42,11,42,12],[43,11,43,12],[43,17,43,18],[44,3,44,4],[44,11,44,12],[44,17,44,18],[45,3,45,4],[45,11,45,12],[45,17,45,18]]}
[]
[]
[]
[null,null,null,"Approach Slab",null,null,"CY",null,null,null,null,{"$f":"D4","v":"Approach Slab"},null,null,"CY",null,null,{"$f":"H4-P4","v":0}]
[]
[null,null,null,"Deck",null,null,"CY",null,null,null,null,{"$f":"D6","v":"Deck"},null,null,"CY",null,null,{"$f":"H6-P6","v":0}]
[]
[null,null,null,"Haunch",null,null,"CY",null,null,null,null,{"$f":"D8","v":"Haunch"},null,null,"CY",null,null,{"$f":"H8-P8","v":0}]
[]
[null,null,null,"Deck Area",null,null,"SF",null,null,null,null,{"$f":"D10","v":"Deck Area"},null,null,"SF",null,null,{"$f":"H10-P10","v":0}]
[]
[null,null,null,"Beams (Conc)",null,null,"LF",null,null,null,null,{"$f":"D12","v":"Beams (Conc)"},null,null,"LF",null,null,{"$f":"H12-P12","v":0}]
[]
[null,null,null,"Barrier",null,null,"LF",null,null,null,null,{"$f":"D14","v":"Barrier"},null,null,"LF",null,null,{"$f":"H14-P14","v":0}]
[]
[null,null,null,"Bearing Pads",null,null,"EA",null,null,null,null,{"$f":"D16","v":"Bearing Pads"},null,null,"LF",null,null,{"$f":"H16-P16","v":0}]
[]
[null,null,null,"Beams (Steel - Rolled)",null,null,"LBS",null,null,null,null,{"$f":"D18","v":"Beams (Steel - Rolled)"},null,null,"LBS",null,null,{"$f":"H18-P18","v":0}]
[]
[null,null,null,"Bottom Flange",null,null,"LBS",null,null,null,null,{"$f":"D20","v":"Bottom Flange"},null,null,"LBS",null,null,{"$f":"H20-P20","v":0}]
[null,null,null,"Top Flange",null,null,"LBS",null,null,null,null,{"$f":"D21","v":"Top Flange"},null,null,"LBS",null,null,{"$f":"H21-P21","v":0}]
[null,null,null,"Web",null,null,"LBS",null,null,null,null,"Web",null,null,"LBS",null,null,0]
[]
[null,null,null,"Cross Frames",null,null,"LBS",null,null,null,null,{"$f":"D24","v":"Cross Frames"},null,null,"LBS",null,null,{"$f":"H24-P24","v":0}]
[]
[null,null,null,"Stiffeners",null,null,"LBS",null,null,null,null,{"$f":"D26","v":"Stiffeners"},null,null,"LBS",null,null,{"$f":"H26-P26","v":0}]
[]
[null,null,null,"Shear Studs",null,null,"LBS",null,null,null,null,{"$f":"D28","v":"Shear Studs"},null,null,"LBS",null,null,{"$f":"H28-P28","v":0}]
[]
[null,null,null,"Field Splice - Bolts",null,null,"EA",null,null,null,null,{"$f":"D30","v":"Field Splice - Bolts"},null,null,"EA",null,null,{"$f":"H30-P30","v":0}]
[null,null,null,"Field Splice - Plates",null,null,"LBS",null,null,null,null,{"$f":"D31","v":"Field Splice - Plates"},null,null,"LBS",null,null,{"$f":"H31-P31","v":0}]
[]
[null,null,null,"Abutment Cap",null,null,"CY",null,null,null,null,{"$f":"D33","v":"Abutment Cap"},null,null,"CY",null,null,{"$f":"H33-P33","v":0}]
[null,null,null,"Abutment Piles",null,null,"LF",null,null,null,null,{"$f":"D34","v":"Abutment Piles"},null,null,"LF",null,null,{"$f":"H34-P34","v":0}]
[null,null,null,"Abutment Brng Seats",null,null,"CY",null,null,null,null,"Abutment Brng Seats",null,null,"CY",null,null,0]
[]
[null,null,null,"Bent Cap",null,null,"CY",null,null,null,null,{"$f":"D37","v":"Bent Cap"},null,null,"CY",null,null,{"$f":"H37-P37","v":0}]
[null,null,null,"Bent Cols",null,null,"CY",null,null,null,null,{"$f":"D38","v":"Bent Cols"},null,null,"CY",null,null,{"$f":"H38-P38","v":0}]
[null,null,null,"Bent Piles",null,null,"LF",null,null,null,null,"Bent Piles",null,null,"LF",null,null,0]
[null,null,null,"Bent Brng Seats",null,null,"CY",null,null,null,null,"Bent Brng Seats",null,null,"CY",null,null,{"$f":"H40-P40","v":0}]
[]
[null,null,null,"Bent Cap",null,null,"CY",null,null,null,null,{"$f":"D42","v":"Bent Cap"},null,null,"CY",null,null,{"$f":"H42-P42","v":0}]
[null,null,null,"Bent Cols",null,null,"CY",null,null,null,null,{"$f":"D43","v":"Bent Cols"},null,null,"CY",null,null,{"$f":"H43-P43","v":0}]
[null,null,null,"Bent Footing",null,null,"CY",null,null,null,null,"Bent Footing",null,null,"CY",null,null,0]
[null,null,null,"Bent Piles",null,null,"LF",null,null,null,null,"Bent Piles",null,null,"LF",null,null,0]
[null,null,null,"Bent Brng Seats",null,null,"CY",null,null,null,null,{"$f":"D46","v":"Bent Brng Seats"},null,null,"CY",null,null,{"$f":"H46-P46","v":0}]
[]
[null,null,null,"Wingwall Wall",null,null,"CY",null,null,null,null,{"$f":"D48","v":"Wingwall Wall"},null,null,"CY",null,null,{"$f":"H48-P48","v":0}]
[null,null,null,"Wingwall Cap",null,null,"CY",null,null,null,null,{"$f":"D49","v":"Wingwall Cap"},null,null,"CY",null,null,{"$f":"H49-P49","v":0}]
[null,null,null,"Wingwall Piles",null,null,"LF",null,null,null,null,"Wingwall Piles",null,null,"LF",null,null,0]
[]
[null,null,null,"Wingwall Wall",null,null,"CY",null,null,null,null,{"$f":"D52","v":"Wingwall Wall"},null,null,"CY",null,null,{"$f":"H52-P52","v":0}]
[null,null,null,"Wingwall Cap",null,null,"CY",null,null,null,null,{"$f":"D53","v":"Wingwall Cap"},null,null,"CY",null,null,{"$f":"H53-P53","v":0}]
[]
[]
[null,null,null,"Wingwall Wall",null,null,"CY",null,null,null,null,{"$f":"D56","v":"Wingwall Wall"},null,null,"CY",null,null,{"$f":"H56-P56","v":0}]
[]
[null,null,null,"Sleeper Slab",null,null,"CY",null,null,null,null,{"$f":"D58","v":"Sleeper Slab"},null,null,"CY",null,null,{"$f":"H58-P58","v":0}]