{"text_format":"1","workbook":"xlsx","n_sheets":6,"sheets":["TITLE1","NOTES","NOTES (2)","GEN SUM","STRUCTURES","STRUCTURES 2"],"not_rendered":{"charts":0,"images":4,"macros":1,"external_links":0,"defined_names":6,"comments":1,"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":"TITLE1","index":0,"n_rows":57,"n_cols":32,"rows_kept":57,"cut":false,"hidden":false,"merged":[[57,16,57,18],[57,19,57,21],[53,19,53,21],[54,16,54,18],[54,19,54,21],[52,16,52,18],[52,19,52,21],[53,16,53,18],[56,13,56,15],[56,16,56,18],[56,19,56,21],[55,19,55,21],[46,19,46,21],[47,16,47,18],[47,19,47,21],[48,16,48,18],[48,19,48,21],[54,13,54,15],[50,13,50,15],[52,13,52,15],[53,13,53,15],[51,13,51,15],[53,28,53,30],[53,31,53,33],[54,28,54,30],[57,22,57,24],[54,31,54,33],[56,28,56,30],[57,25,57,27],[56,31,56,33],[55,28,55,30],[55,31,55,33],[54,25,54,27],[53,25,53,27],[53,22,53,24],[55,22,55,24],[54,22,54,24],[57,28,57,30],[57,31,57,33],[35,17,35,20],[46,31,46,33],[47,28,47,30],[47,31,47,33],[56,22,56,24],[56,25,56,27],[48,25,48,27],[46,22,46,24],[46,25,46,27],[47,22,47,24],[47,25,47,27],[46,28,46,30],[55,25,55,27],[51,22,51,24],[51,25,51,27],[48,31,48,33],[49,28,49,30],[49,31,49,33],[52,28,52,30],[52,31,52,33],[48,22,48,24],[48,28,48,30],[52,25,52,27],[50,28,51,33],[27,9,27,16],[0,17,3,33],[45,19,45,21],[52,22,52,24],[49,22,49,24],[49,25,49,27],[50,22,50,24],[50,25,50,27],[51,16,51,18],[51,19,51,21],[49,16,49,18],[49,19,49,21],[50,16,50,18],[50,19,50,21],[21,15,21,16],[40,21,40,27],[45,31,45,33],[45,22,45,24],[45,25,45,27],[45,28,45,30],[25,11,25,16],[43,28,44,33],[43,10,44,27],[40,17,40,20],[34,1,38,15],[31,1,33,15],[20,15,20,16],[24,1,24,14],[23,1,23,14],[18,1,18,8],[33,21,33,33],[38,21,38,33],[32,21,32,33],[37,21,37,33],[35,21,35,27],[30,1,30,15],[24,15,24,16],[18,9,18,16],[37,17,37,20],[25,18,30,33],[19,18,24,33],[13,18,18,33],[32,17,32,20],[21,1,21,14],[20,1,20,14],[27,1,27,8],[28,1,28,8],[28,9,28,16],[4,17,4,23],[10,18,12,33],[7,24,7,33],[5,24,6,33],[8,24,9,33],[8,17,9,23],[7,17,7,23],[5,17,6,23],[4,24,4,33],[54,1,55,2],[55,10,55,12],[55,13,55,15],[55,16,55,18],[49,10,49,12],[45,16,45,18],[42,1,42,8],[39,1,40,15],[54,10,54,12],[47,13,47,15],[46,16,46,18],[51,10,51,12],[56,3,57,8],[56,1,57,2],[22,1,22,14],[46,13,46,15],[46,1,53,8],[49,13,49,15],[48,10,48,12],[45,10,45,12],[45,13,45,15],[45,1,45,8],[48,13,48,15],[50,10,50,12],[52,10,52,12],[53,10,53,12],[46,10,46,12],[47,10,47,12],[43,1,44,8],[25,1,25,10],[23,15,23,16],[22,15,22,16],[57,10,57,12],[56,10,56,12],[57,13,57,15],[54,3,55,8]]}
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"D09-BH-FY2022(A)"]
[]
[]
[]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"PID No.",null,null,null,null,null,null,"FEDERAL PROJECT No."]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,102848,null,null,null,null,null,null,"NON-FEDERAL"]
[]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"STATE JOB No.",null,null,null,null,null,null,"CONSTRUCTION PROJECT No."]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,499564]
[]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"PROJECT DESCRIPTION\nCONCRETE BRIDGE DECK SEALING AT VARIOUS BRIDGES IN BROWN AND ROSS COUNTIES ON US 62, 68, 35, AND S.R. 32."]
[]
[]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"2019 SPECIFICATIONS\nTHE STANDARD SPECIFICATIONS OF THE STATE OF OHIO, DEPARTMENT OF TRANSPORTATION, INCLUDING SUPPLEMENTAL SPECIFICATIONS LISTED IN THE PLANS AND CHANGES LISTED IN THE PROPOSAL SHALL GOVERN THIS IMPROVEMENT."]
[]
[]
[]
[]
[null,"LATITUDE: N 39° 19' 29\"",null,null,null,null,null,null,null,"LONGITUDE: W 82° 57' 47\""]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"LIMITED ACCESS\nTHIS IMPROVEMENT IS ESPECIALLY DESIGNED FOR THROUGH TRAFFIC AND HAS BEEN DECLARED A LIMITED ACCESS HIGHWAY, OR FREEWAY, BY ACTION OF THE DIRECTOR IN ACCORDANCE WITH THE PROVISIONS OF SECTION 5511.02 OF THE OHIO REVISED CODE."]
[null,"EARTH DISTURBED AREA:",null,null,null,null,null,null,null,null,null,null,null,null,null,"N/A*"]
[null,"PROJECT EARTH DISTURBED AREA:",null,null,null,null,null,null,null,null,null,null,null,null,null,"N/A*"]
[null,"EST. CONTRACTOR EARTH DISTURBED AREA:",null,null,null,null,null,null,null,null,null,null,null,null,null,"N/A*"]
[null,"NOTICE OF INTENT EARTH DISTURBED AREA:",null,null,null,null,null,null,null,null,null,null,null,null,null,"N/A*"]
[null,"RAILROAD INVOLVEMENT:",null,null,null,null,null,null,null,null,null,null,null,null,null,"NONE"]
[null,"*TYPE OF PROJECT:",null,null,null,null,null,null,null,null,null,"MAINTENANCE",null,null,null,null,null,null,"I HEREBY APPROVE THESE PLANS AND DECLARE THAT THE MAKING OF THIS IMPROVEMENT WILL NOT REQUIRE THE CLOSING OF THE HIGHWAY TO TRAFFIC AND THAT PROVISIONS FOR THE MAINTENANCE AND SAFETY OF TRAFFIC WILL BE AS SET FORTH IN THESE PLANS AND ESTIMATES."]
[]
[null,"DESIGN DESIGNATION:",null,null,null,null,null,null,null,"(SEE SHEET 2)"]
[null,"DESIGN EXCEPTION:",null,null,null,null,null,null,null,"NONE"]
[]
[]
[]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"APPROVED:"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"DISTRICT DEPUTY DIRECTOR"]
[]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"DATE:"]
[]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"APPROVED:"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"DIRECTOR, DEPARTMENT OF TRANSPORTATION"]
[]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"DATE:"]
[]
[null,"PLANS PREPARED BY:"]
[null,"ODOT, DISTRICT 9 - P & E\nCHILLICOTHE, OH",null,null,null,null,null,null,null,null,"STANDARD CONSTRUCTION DRAWINGS",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"SUPPLEMENTAL\nSPECIFICATIONS"]
[]
[null,"ENGINEERS SEAL:",null,null,null,null,null,null,null,null,"MT-95.30",null,null,"2019-07-19",null,null,null,null,null,null,null,null,null,null,null,null,null,null,800,null,null,"2021-04-16"]
[null,null,null,null,null,null,null,null,null,null,"MT-97.10",null,null,"2019-04-19",null,null,null,null,null,null,null,null,null,null,null,null,null,null,821,null,null,"2012-04-20"]
[null,null,null,null,null,null,null,null,null,null,"MT-98.10",null,null,"2020-01-17",null,null,null,null,null,null,null,null,null,null,null,null,null,null,832,null,null,"2018-10-19"]
[null,null,null,null,null,null,null,null,null,null,"MT-98.11",null,null,"2020-01-17",null,null,null,null,null,null,null,null,null,null,null,null,null,null,921,null,null,"2012-04-20"]
[null,null,null,null,null,null,null,null,null,null,"MT-98.20",null,null,"2019-04-19"]
[null,null,null,null,null,null,null,null,null,null,"MT-98.22",null,null,"2020-01-17",null,null,null,null,null,null,null,null,null,null,null,null,null,null,"SPECIAL\nPROVISIONS"]
[null,null,null,null,null,null,null,null,null,null,"MT-98.28",null,null,"2020-01-17"]
[null,null,null,null,null,null,null,null,null,null,"MT-101.90",null,null,"2020-07-17",null,null,null,null,null,null,null,null,null,null,null,null,null,null,"NONE"]
[null,null,null,null,null,null,null,null,null,null,"MT-105.10",null,null,"2020-01-17"]
[null,"SIGN:"]
[]
[null,"DATE:",null,"  4/26/2021"]

{"sheet":"NOTES","index":1,"n_rows":49,"n_cols":4,"rows_kept":49,"cut":false,"hidden":false,"merged":[[48,1,48,3],[47,1,47,3],[46,1,46,3],[2,0,7,0],[9,0,14,0],[16,0,19,0],[44,0,45,0],[44,1,45,3]]}
["ITEM 512 - SEALING CONCRETE BRIDGE DECKS WITH HMWM RESIN, AS PER PLAN"]
[]
["THIS ITEM SHALL CONSIST OF SEALING OPENED CRACKS AND CONSTRUCTION JOINTS ON THE BRIDGE DECK AND APPROACH SLABS WITH HMWM RESIN.  PRIOR TO SEALING THE JOINTS AND CRACKS, THE ENGINEER SHALL MARK ALL AREAS TO BE SEALED.  THE SEALING WIDTH SHALL BE A MINIMUM OF 1'-0\" CENTERED ON THE OPENING."]
[]
[]
[]
[]
[]
[]
["ITEM 512, SEALING OF CONCRETE BRIDGE DECKS WITH HMWM RESIN, AS PER PLAN SHALL BE ALLOWED TO CURE IN ACCORDANCE WITH CMS 512.04.  THEN THE DECK SURFACE AND APPROACH SLABS MAY BE CLEANED AND TREATED WITH ITEM 512, SEALING CONCRETE BRIDGE DECKS WITH SRS (INCLUDING APPROACH SLABS) IN ACCORDANCE WITH CMS 512.05."]
[]
[]
[]
[]
[]
[]
["PAYMENT FOR ALL LABOR, MATERIAL, AND EQUIPMENT REQUIRED TO PERFORM THE WORK OUTLINED ABOVE SHALL BE INCLUDED IN THE SQUARE YARD CONTRACT PRICE FOR ITEM 512, SEALING OF CONCRETE BRIDGE DECKS WITH HMWM RESIN, AS PER PLAN, UNLESS SEPERATELY ITEMIZED IN THE PLANS."]
[]
[]
[]
[]
[]
["DESIGN DESIGNATION                                                            SR 32  "," US 35 "," US 62 "," US 68 "]
["CURRENT ADT (2021)                                                              24000",34000,4700,"5100"]
["DESIGN YEAR ADT(2041)                                                        29000",37000,5200,"7400"]
["DESIGN HOURLY VOLUME (2041)                                            3500",3700,450,"750"]
["DIRECTIONAL DISTRIBUTION                                                     70%",0.5,0.56000000000000005,0.56000000000000005]
["TRUCKS (24 HOUR B&C)                                                             7%",0.28000000000000003,0.18,0.1]
["DESIGN SPEED                                                                     60 MPH","60 MPH","55 MPH","55 MPH"]
["LEGAL SPEED                                                                       60 MPH","60 MPH","55 MPH","55 MPH"]
["DESIGN FUNCTIONAL CLASSIFICATION"]
["          02 OTHER FREEWAYS OR EXPRESSWAYS (RURAL)"]
["NHS PROJECT                                                                          YES"]
[]
[]
["SPECIAL CONSTRUCTION REQUIREMENT"]
["THE CONTRACTOR SHALL PERFORM THE WORK IN THE"]
["FOLLOWING SEQUENCE:"]
["     1. REMOVE ALL FOREIGN MATERIAL."]
["     2. APPLY HMWM RESIN."]
["     3. APPLY SRS."]
[]
[]
["LANE VALUE CONTRACT TABLE"]
["DESCRIPTION OF CRITICAL LANE/RAMP TO BE MAINTAINED","DISINCENTIVE $ PER MINUTE PER LANE"]
[]
["4 LANES OF US 35 FROM SLM 6.65 TO SLM 18.52",50]
["4 LANES OF US 35 FROM SLM 18.65 TO SLM 19.50",75]
["ALL OTHER ROUTES ON PROJECT",50]

{"sheet":"NOTES (2)","index":2,"n_rows":73,"n_cols":6,"rows_kept":73,"cut":false,"hidden":false,"merged":[[72,0,74,1],[67,0,70,1],[71,3,72,5],[59,3,60,3],[62,3,63,3],[62,5,63,5],[65,3,68,5],[70,3,70,5],[53,3,53,5],[2,3,8,5],[10,3,18,5],[55,3,57,3],[20,3,23,5],[25,3,28,5],[31,3,41,5],[43,3,51,5],[2,0,9,1],[11,0,12,1],[0,0,0,1],[0,3,0,5],[30,3,30,5],[55,0,56,0],[57,0,58,0],[62,0,63,0],[64,0,65,0],[14,0,22,1],[24,0,31,1],[33,0,36,1],[43,0,46,1],[47,0,48,0],[47,1,48,1],[49,0,50,0],[51,0,52,0],[53,0,54,0]]}
["ITEM 614 - MAINTAINING TRAFFIC",null,null,"ITEM 614 - MAINTAINING TRAFFIC CONTINUED"]
[]
["A MINIMUM OF ONE 10'-0\" LANE OF TRAFFIC IN EACH DIRECTION ON S.R. 32, U.S. 35, U.S. 62 AND A MINIMUM OF ONE 10'-0\" LANE OF TWO-WAY TRAFFIC ON U.S. 68 SHALL BE MAINTAINED AT ALL TIMES BY USE OF THE EXISTING PAVEMENT. A MINIUMUM OF ONE 10'-0\" LANE OF TRAFFIC ON ALL RAMPS AND ACCELERATION & DECELERATION LANES SHALL BE MAINTAINED AT ALL TIMES BY THE USE OF THE EXISTING PAVEMENT.",null,null,"THE CONTRACTOR SHALL ARRANGE FOR ALL MAINTENANCE OF TRAFFIC OPERATIONS SUCH THAT THERE WILL BE NO OBSTRUCTIONS TO THE CONTINUOUS FLOW OF TRAFFIC.  A MINIMUM OF ONE LANE OF TRAFFIC SHALL BE MAINTAINED ON ALL COUNTY AND TOWNSHIP ROADS AND ALL INTERSECTIONS (INCLUDING DRIVEWAYS) AND CROSS-OVERS SHALL BE OPEN TO TRAFFIC AT ALL TIMES."]
[]
[]
[]
[]
[]
[]
[]
[null,null,null,"BEFORE THE WORK BEGINS, THE CONTRACTOR SHALL SUBMIT TO THE ENGINEER THE NAME(S) AND TELEPHONE NUMBER(S) OF A PERSON OR PERSONS WHO CAN BE CONTACTED TWENTY-FOUR (24) HOURS PER DAY BY THE OHIO DEPARTMENT OF TRANSPORTATION AND ALL INTERESTED POLICE AGENCIES.  THIS PERSON OR PERSONS SHALL BE RESPONSIBLE FOR PLACING OR REPLACING NECESSARY TRAFFIC CONTROL DEVICES IN ACCORDANCE WITH THE OHIO MANUAL OF UNIFORM TRAFFIC CONTROL DEVICES."]
["LANE CLOSURES WILL BE LIMITED TO THREE CONSECUTIVE CALENDAR DAYS."]
[]
[]
["LENGTH AND DURATION OF LANE CLOSURES AND RESTRICTIONS SHALL BE AT THE APPROVAL OF THE ENGINEER.  IT IS THE INTENT TO MINIMIZE THE IMPACT TO THE TRAVELING PUBLIC.  LANE CLOSURES OR RESTRICTIONS OVER SEGMENTS OF THE PROJECT IN WHICH NO WORK IS ANTICIPATED WITHIN A REASONABLE TIME FRAME, AS DETERMINED BY THE ENGINEER, SHALL NOT BE PERMITTED.  THE LEVEL OF UTILIZATION OF MAINTENANCE OF TRAFFIC DEVICES SHALL BE COMMENSURATE WITH THE WORK IN PROGRESS."]
[]
[]
[]
[]
[]
[null,null,null,"ALL WORK AND TRAFFIC CONTROL DEVICES SHALL BE IN ACCORDANCE WITH CMS 614 AND OTHER APPLICABLE PORTIONS OF THE SPECIFICATIONS, AS WELL AS THE OHIO MANUAL OF UNIFORM TRAFFIC CONTROL DEVICES."]
[]
[]
[]
["ALL TRAFFIC CONTROL SIGNS, DEVICES, AND OPERATIONS USED FOR THE TEMPORARY MAINTENANCE AND CONTROL SHALL AT ALL TIMES BE SUBJECT TO THE DIRECTION AND CONTROL OF THE ENGINEER IN RESPECT TO THEIR CONDITIONS, LOCATIONS, AND TIMES OF APPLICATION.  VISIBLE SIGNS AND DEVICES SHALL CONSISTENTLY REFLECT THE CONDITIONS ACTUALLY EXISTING.  INAPPROPRIATE SIGNS OR DEVICES SHALL BE REMOVED OR COVERED."]
[null,null,null,"PAYMENT FOR ALL LABOR, EQUIPMENT AND MATERIALS SHALL BE INCLUDED IN THE LUMP SUM CONTRACT PRICE FOR ITEM 614 MAINTAINING TRAFFIC UNLESS SEPERATELY ITEMIZED IN THE PLANS."]
[]
[]
[]
[]
[null,null,null,"NOTIFICATION OF TRAFFIC RESTRICTIONS"]
[null,null,null,"THROUGHOUT THE DURATION OF THE PROJECT, THE CONTRACTOR SHALL NOTIFY THE PROJECT ENGINEER IN WRITING OF ALL TRAFFIC RESTRICTIONS AND UPCOMING MAINTENANCE OF TRAFFIC CHANGES.  THE CONTRACTOR SHALL ENSURE THE WRITTEN NOTIFACTION IS SUBMITTED IN A TIMELY MANNER TO ALLOW THE PROJECT ENINGEER TO MEET THE REQUIRED TIME FRAMES SET FORTH IN THE TABLE BELOW TO INFORM THE SPECIAL HAULINCG PERMITS SECTION AND THE DISTRICT PUBLIC INFOMRATION OFFICE (PIO).  THIS NOTIFICATION SHALL BE RECIEVED BY THE PROJECT ENGINEER PRIOR TO THE PHUSICAL SETUP OF ANY APPLICABLE SIGNS OR MESSAGE BOARDS."]
[]
["NO WORK SHALL BE PERFORMED AND ALL EXISTING LANES SHALL BE OPEN TO TRAFFIC (EXCEPT FOR THE LANE CLOSURES FOR THE BRIDGE WORK ZONES) DURING THE FOLLOWING DESIGNATED HOLIDAYS OR EVENTS:"]
[]
[]
[]
[]
["CHRISTMAS","LABOR DAY"]
["NEW YEARS","THANKSGIVING"]
["MEMORIAL DAY","SPECIAL LOCAL EVENTS"]
["FOURTH OF JULY","(OTHER HOILDAY OR EVENT)"]
[]
["THE PERIOD OF TIME THAT THE LANES ARE TO BE OPEN DEPENDS ON THE DAY OF THE WEEK ON WHICH THE HOLIDAY OR EVENT FALLS.  THE FOLLOWING SCHEDULE SHALL BE USED TO DETERMINE THIS PERIOD:",null,null,"INFORMATION SHOULD INCLUDE, BUT IS NOT LIMITED TO, ALL CONSTRUCTION ACTIVITIES THAT IMPAC OR INTERFERE WITH TRAFFIC AND SHALL LIST THE SPECIFIC LCOATION, TYPE OF WORK, ROAD STATUS, DATE AND TIME OF RESTRICTION, DURATION OF RESTRICTION, NUMBER OF LANES MAINTAINED, NUMBER OF LANES CLOSED, MINIMUM VERTICAL CLEARANCE, MINIMUM WIDTH OF DRIVEABLE PAVEMENT, DETOUR ROUTES, IF APPLICABLE, AND ANY OTHER INFORMATION REQURESTED BY THE PROJECT ENGINEER."]
[]
[]
[]
["DAY OF HOLIDAY OR EVENT","TIME ALL LANES MUST BE OPEN TO TRAFFIC"]
[]
["   SUNDAY","12:00N FRIDAY THROUGH "]
[null,"6:00AM MONDAY"]
["   MONDAY","12:00N FRIDAY THROUGH"]
[null,"6:00AM MONDAY"]
["   TUESDAY","12:00N MONDAY THROUGH",null,"NOTIFICATION TIME TABLE"]
[null,"6:00AM MONDAY",null,"ITEM","DURATION OF CLOSURE","NOTICE REQ'D."]
["   WEDNESDAY","12:00N TUESDAY THROUGH",null,"RAMP AND ROAD CLOSURE",">= 2 WEEKS","21 CALENDARDAYS"]
[null,"6:00AM MONDAY",null,null,">12 HOURS & < 2 WEEKS","14 CALENDAR DAYS"]
["   THURSDAY","12:00N WEDNESDAY THROUGH",null,null,"<= 2 WEEKS","4 BUSINESS DAYS"]
[null,"6:00AM FRIDAY"]
["   THURSDAY","6:00AM WEDNESDAY THROUGH",null,"LANE CLOSURES AND RSTRICTIONS",">= 2 WEEKS","14 CALENDAR DAYS"]
["   (THANKSGIVING","6:00AM MONDAY",null,null,"< 2 WEEKS","5 BUSINESS DAYS"]
["   ONLY)"]
["   FRIDAY","12:00N THURSDAY THROUGH",null,"START OF CONSTRUCTION",null,"14 CALENDAR DAYS"]
[null,"6:00AM MONDAY"]
["   SATURDAY","12:00N FRIDAY THROUGH"]
[null,"6:00AM MONDAY",null,"ANY UNFORSEEN CONDITIONS NOT SPECIFIED IN THE PLANS REQUIRING TRAFFIC RESTRICTIONS SHALL ALSO BE REPORTED TO THE PROJECT ENGINEER USING THE NOTIFICATION TIME TABLE."]
[]
["NO EXTENSIONS OF TIME SHALL BE GRANTED FOR DELAYS IN MATERIAL DELIVERIES, UNLESS SUCH DELAYS ARE INDUSTRY-WIDE, OR FOR LABOR STRIKES, UNLESS SUCH STRIKES ARE AREA-WIDE."]
[]
[]
[null,null,null,"EXISTING SHOULDERS"]
[null,null,null,"TRAFFIC SHALL NOT BE REQUIRED TO TRAVEL ALONG THE EXISTING SHOULDERS THAT HAVE RUMBLE STRIPS."]
["SHOULD THE CONTRACTOR FAIL TO MEET ANY OF THESE REQUIREMENTS, THE CONTRACTOR SHALL BE ASSESSED A DISINCENTIVE PER THE LANE VALUE CONTRACT (PN 127)."]

{"sheet":"GEN SUM","index":3,"n_rows":108,"n_cols":14,"rows_kept":108,"cut":false,"hidden":false,"merged":[[0,1,1,13],[33,0,36,0],[81,0,84,0],[0,0,17,0],[55,13,58,13],[2,13,5,13],[26,0,32,0],[55,1,56,7],[4,10,5,10],[2,11,5,11],[2,12,5,12],[2,10,3,10],[55,10,56,10],[55,11,58,11],[55,12,58,12],[2,8,5,8],[2,9,3,9],[4,1,5,1],[4,9,5,9],[4,2,5,2],[4,3,5,3],[2,1,3,4],[4,4,5,4],[74,0,80,0],[57,9,58,9],[57,10,58,10],[57,5,58,5],[57,6,58,6],[57,7,58,7],[57,4,58,4],[57,1,58,1],[57,2,58,2],[57,3,58,3],[55,8,58,8],[55,9,56,9],[9,5,9,7],[12,5,12,7],[4,5,5,7],[2,5,3,7],[6,5,6,7],[7,5,7,7],[8,5,8,7],[11,5,11,7],[10,5,10,7],[13,5,13,7],[14,5,14,7],[15,5,15,7],[24,5,24,7],[29,5,29,7],[28,5,28,7],[16,5,16,7],[18,5,18,7],[23,5,23,7],[22,5,22,7],[21,5,21,7],[17,5,17,7],[20,5,20,7],[19,5,19,7],[31,5,31,7],[33,5,33,7],[25,5,25,7],[26,5,26,7],[27,5,27,7],[42,5,42,7],[43,5,43,7],[35,5,35,7],[36,5,36,7],[37,5,37,7],[38,5,38,7],[41,5,41,7],[54,5,54,7],[30,5,30,7],[32,5,32,7],[34,5,34,7],[49,5,49,7],[50,5,50,7],[51,5,51,7],[52,5,52,7],[53,5,53,7],[44,5,44,7],[45,5,45,7],[46,5,46,7],[47,5,47,7],[48,5,48,7],[39,5,39,7],[40,5,40,7]]}
["TO USE MACRO FOR PLACING ITEMS - CLICK THE BUTTON.  IN THE DIALOG BOX, CLICK FILE THEN NAVIGATE TO I:\\ODOTstd\\V8istd\\vba\\data AND SELECT THE APPROPRIATE FILE (E = ENGLISH UNITS). CLICK 'OPEN'. THEN FROM THE DROP DOWN YOU CAN BEGIN SELECTING YOUR ITEMS.\n\nWARNING: BE SURE TO SELECT A CELL IN THE \"ITEM\" COLUMN PRIOR TO PLACING ANY ITEM FROM THE MACRO WINDOW.\n|\n|\n\\/","The shape object  InnerSheetBorder  represents the drawing area of an 8.5\"x11\" ODOT General Summary sheet "]
[]
[null,"SHEET NUMBER",null,null,null,"PLAN SPLIT",null,null,"ITEM","ITEM","GRAND","UNIT","DESCRIPTION","SEE SHEET NO"]
[]
[null,null,null,5,6,"01/NFA/BR",null,null,null,"EXT","TOTAL"]
[]
[]
[null,null,null,null,null,null,null,null,null,null,null,null,"EROSION CONTROL"]
[]
[null,null,null,null,null,1000,null,null,"832","30000",1000,"EACH","EROSION CONTROL"]
[]
[null,null,null,null,null,null,null,null,null,null,null,null,"TRAFFIC CONTROL "]
[]
[null,null,null,{"$f":"STRUCTURES!P44","v":1.23},1.35,{"$f":"D14+E14","v":2.58},null,null,"642","00104",{"$f":"D14+E14","v":2.58},"MILE","EDGE LINE, 6\", TYPE 1"]
[null,null,null,{"$f":"STRUCTURES!R44","v":0.64},{"$f":"'STRUCTURES 2'!R44","v":0.71},{"$f":"D15+E15","v":1.35},null,null,"642","00204",{"$f":"D15+E15","v":1.35},"MILE","LANE LINE, 6\", TYPE 1"]
[null,null,null,{"$f":"STRUCTURES!S44","v":418},0,418,null,null,"642","00404",418,"FT","CHANNELIZING LINE, 12\", TYPE 1"]
[null,null,null,{"$f":"STRUCTURES!O44","v":0.05},0,{"$f":"K17","v":0.05},null,null,"642","00300",{"$f":"D17+E17","v":0.05},"MILE","CENTERLINE, TYPE 1"]
[null,null,null,null,0]
[null,null,null,null,null,null,null,null,null,null,null,null,"STRUCTURE REPAIR"]
[]
[null,null,null,{"$f":"STRUCTURES!H44","v":526},{"$f":"'STRUCTURES 2'!H44","v":591},{"$f":"K21","v":1117},null,null,"512","74000",{"$f":"D21+E21","v":1117},"SY","REMOVAL OF EXISTING COATINGS FROM CONCRETE SURFACES"]
[null,null,null,{"$f":"STRUCTURES!J44","v":1467},{"$f":"'STRUCTURES 2'!J44","v":1391},{"$f":"K22","v":2858},null,null,"512","10301",{"$f":"D22+E22","v":2858},"SY","SEALING CONCRETE BRIDGE DECKS WITH HMWM RESIN, AS PER PLAN",2]
[null,null,null,{"$f":"STRUCTURES!I44","v":14667},{"$f":"'STRUCTURES 2'!I44","v":13909},28576,null,null,"512","10400",28576,"SY","TREATING OF CONCRETE BRIDGE DECKS WITH SRS (INCLUDING APPROACH SLABS)"]
[]
[]
[null,null,null,null,null,null,null,null,null,null,null,null,"INCINDENTALS"]
["SHEET 1"]
[null,null,null,null,null,"LUMP",null,null,"614","11000","LUMP",null,"MAINTAINING TRAFFIC"]
[null,null,null,null,null,"LUMP",null,null,"624","10000","LUMP",null,"MOBILIZATION"]
[]
[]
[]
[]
["CLICK HERE FOR THE\nITEM MASTER VIA INTRANET"]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[null,"SHEET NUMBER",null,null,null,null,null,null,"ITEM","ITEM","GRAND","UNIT","DESCRIPTION","SEE SHEET NO."]
[]
[null,null,null,null,null,null,null,null,null,"EXT.","TOTAL"]
[]
[null,null,null,null,null,null,null,null,null,null,{"$f":"SUM(B60:H60)","v":0}]
[null,null,null,null,null,null,null,null,null,null,0]
[null,null,null,null,null,null,null,null,null,null,0]
[null,null,null,null,null,null,null,null,null,null,0]
[null,null,null,null,null,null,null,null,null,null,0]
[null,null,null,null,null,null,null,null,null,null,0]
[null,null,null,null,null,null,null,null,null,null,0]
[null,null,null,null,null,null,null,null,null,null,0]
[null,null,null,null,null,null,null,null,null,null,0]
[null,null,null,null,null,null,null,null,null,null,0]
[null,null,null,null,null,null,null,null,null,null,0]
[null,null,null,null,null,null,null,null,null,null,0]
[null,null,null,null,null,null,null,null,null,null,0]
[null,null,null,null,null,null,null,null,null,null,0]
[null,null,null,null,null,null,null,null,null,null,0]
["SHEET 2",null,null,null,null,null,null,null,null,null,0]
[null,null,null,null,null,null,null,null,null,null,0]
[null,null,null,null,null,null,null,null,null,null,0]
[null,null,null,null,null,null,null,null,null,null,0]
[null,null,null,null,null,null,null,null,null,null,0]
[null,null,null,null,null,null,null,null,null,null,0]
[null,null,null,null,null,null,null,null,null,null,0]
["CLICK HERE FOR THE\nITEM MASTER VIA INTRANET",null,null,null,null,null,null,null,null,null,0]
[null,null,null,null,null,null,null,null,null,null,0]
[null,null,null,null,null,null,null,null,null,null,0]
[null,null,null,null,null,null,null,null,null,null,0]
[null,null,null,null,null,null,null,null,null,null,0]
[null,null,null,null,null,null,null,null,null,null,0]
[null,null,null,null,null,null,null,null,null,null,0]
[null,null,null,null,null,null,null,null,null,null,0]
[null,null,null,null,null,null,null,null,null,null,0]
[null,null,null,null,null,null,null,null,null,null,0]
[null,null,null,null,null,null,null,null,null,null,{"$f":"SUM(B92:H92)","v":0}]
[null,null,null,null,null,null,null,null,null,null,0]
[null,null,null,null,null,null,null,null,null,null,0]
[null,null,null,null,null,null,null,null,null,null,0]
[null,null,null,null,null,null,null,null,null,null,0]
[null,null,null,null,null,null,null,null,null,null,0]
[null,null,null,null,null,null,null,null,null,null,0]
[null,null,null,null,null,null,null,null,null,null,0]
[null,null,null,null,null,null,null,null,null,null,0]
[null,null,null,null,null,null,null,null,null,null,0]
[null,null,null,null,null,null,null,null,null,null,0]
[null,null,null,null,null,null,null,null,null,null,0]
[null,null,null,null,null,null,null,null,null,null,0]
[null,null,null,null,null,null,null,null,null,null,0]
[null,null,null,null,null,null,null,null,null,null,0]
[null,null,null,null,null,null,null,null,null,null,0]
[null,null,null,null,null,null,null,null,null,null,0]

{"sheet":"STRUCTURES","index":4,"n_rows":44,"n_cols":41,"rows_kept":44,"cut":false,"hidden":false,"merged":[[41,15,41,16],[42,15,42,16],[43,15,43,16],[1,21,7,21],[41,0,41,4],[42,0,42,4],[43,0,43,4],[0,0,8,0],[0,1,7,1],[0,2,7,2],[0,3,7,3],[0,4,7,4],[1,12,7,12],[1,7,7,7],[1,14,7,14],[1,11,7,11],[0,23,8,23],[1,5,7,5],[1,8,7,8],[1,9,7,9],[1,17,7,17],[0,15,0,16],[1,15,3,16],[4,15,7,15],[4,16,7,16],[1,18,7,18],[1,20,7,20],[1,22,7,22],[1,19,7,19],[1,13,7,13],[1,6,7,6],[1,10,7,10]]}
["BRIDGE NUMBER","WIDTH (TOE/TOE OF PARAPETS)","LENGTH (BRIDGE LIMITS)","REAR APPROACH SLAB LENGTH","FORWARD APPROACH SLAB LENGTH","SPECIAL",null,512,512,512,null,null,516,null,642,642,null,642,642,null,null,null,512,"STRUCTURAL FILE NUMBER"]
[null,null,null,null,null,"PATCHING CONCRETE BRIDGE DECK OVERLAY WITH MICRO-SILICA MODIFIED CONCRETE",null,"REMOVAL OF EXISTING COATINGS FROM CONCRETTE SURFACES ","TREATING OF CONCRETE BRIDGE DECKS WITH SRS (INCLUDING APPROACH SLABS)","SEALING CONCRETE BRIDGE DECKS WITH HMWM RESIN, AS PER PLAN (ESTIMATED AT 10% OF SRS AREA)",null,null,"PREFORMED ELASTOMERIC COMPRESSION JOINT SEAL",null,"CENTERLINE, TYPE 1","EDGE LINE, 6\", TYPE 1",null,"LANE LINE, 6\", TYPE 1","CHANNELIZING LINE, 12\", TYPE 1",null,null,null,"REMOVAL OF EXISTING COATINGS FROM CONCRETTE SURFACES "]
[]
[]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"WHITE","YELLOW"]
[]
[]
[]
[null,"FT","FT","FT","FT","SQ YD",null,"SQ YD","SQ YD","SQ YD",null,null,"FT",null,"FT","FT","FT","FT","FT",null,null,null,"SQ YD"]
["BRO-62-1311 L",37,148.19999999999999,25,25,null,null,{"$f":"+($C10+$D10+$E10)*0.75*0.222222222222222","v":33.033333333333296},{"$f":"((C10*B10)+((E10*B10)+(D10*B10)))/9","v":814.82222222222219},{"$f":"I10*0.1","v":81.482222222222219},null,null,55,null,null,{"$f":"+C10+D10+E10","v":198.2},{"$f":"+C10+D10+E10","v":198.2},{"$f":"+C10+D10+E10","v":198.2},null,null,null,null,{"$f":"+(C10+D10+E10)*0.75*0.222222222222222","v":33.033333333333296},"0801356"]
["BRO-62-1312 R",37,148.19999999999999,25,25,null,null,{"$f":"+($C11+$D11+$E11)*0.75*0.222222222222222","v":33.033333333333296},{"$f":"((C11*B11)+((E11*B11)+(D11*B11)))/9","v":814.82222222222219},{"$f":"I11*0.1","v":81.482222222222219},null,null,54,null,null,{"$f":"+C11+D11+E11","v":198.2},{"$f":"+C11+D11+E11","v":198.2},{"$f":"+C11+D11+E11","v":198.2},null,null,null,null,{"$f":"+(C11+D11+E11)*0.75*0.222222222222222","v":33.033333333333296},"0801380"]
[]
["BRO-68-0160",48,190.97,20,20,null,null,38.494999999999955,{"$f":"((C13*B13)+((E13*B13)+(D13*B13)))/9","v":1231.8399999999999},{"$f":"I13*0.1","v":123.184},null,null,null,null,{"$f":"C13+D13+E13","v":230.97},{"$f":"(+C13+D13+E13)*2","v":461.94},null,null,null,null,null,null,{"$f":"+(C13+D13+E13)*0.75*0.222222222222222","v":38.494999999999955},"0801313"]
[null,null,null,null,null,null,null,null,null,null,null,null,84,null,null,null,null,null,null,null,null,null,{"$f":"+(C14+D14+E14)*0.75*0.222222222222222","v":0}]
["BRO-32-0504 L",58.08,73.12,25,25,null,null,{"$f":"+($C15+$D15+$E15)*0.75*0.222222222222222","v":20.519999999999978},{"$f":"((C15*B15)+((E15*B15)+(D15*B15)))/9","v":794.53440000000001},{"$f":"I15*0.1","v":79.453440000000001},null,null,null,null,null,{"$f":"+C15+D15+E15","v":123.12},{"$f":"+C15+D15+E15","v":123.12},{"$f":"+C15+D15+E15","v":123.12},{"$f":"118+112","v":230},null,null,null,null,"0800074"]
["BRO-32-0505 R",47,73.12,25,25,null,null,20.519999999999978,{"$f":"((C16*B16)+((E16*B16)+(D16*B16)))/9","v":642.96},{"$f":"I16*0.1","v":64.296000000000006},null,null,null,null,null,123.12,123.12,{"$f":"(+C16+D16+E16)*2","v":246.24},null,null,null,null,{"$f":"+(C16+D16+E16)*0.75*0.222222222222222","v":20.519999999999978},"0800082"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"+(C17+D17+E17)*0.75*0.222222222222222","v":0}]
["BRO-32-0540 R",59.5,92.66,25,25,null,null,23.776666666666642,{"$f":"((C18*B18)+((E18*B18)+(D18*B18)))/9","v":943.14111111111117},{"$f":"I18*0.1","v":94.314111111111117},null,null,null,null,null,285.32,167.66,{"$f":"+C18+D18+E18","v":142.66},117.66,null,null,null,null,"0800112"]
["BRO-32-0541 L",47,92.66,25,25,null,null,23.776666666666642,{"$f":"((C19*B19)+((E19*B19)+(D19*B19)))/9","v":745.00222222222214},{"$f":"I19*0.1","v":74.50022222222222},null,null,40,null,null,142.66,142.66,{"$f":"(+C19+D19+E19)*2","v":285.32},null,null,null,null,{"$f":"+(C19+D19+E19)*0.75*0.222222222222222","v":23.776666666666642},"0800104",null,null,null,675,"R ",7101546,80,40,3197,0,0,30,4.5,1.5,"Y",20,"OLD TOWN RUN             "]
[null,null,null,null,null,null,null,null,null,null,null,null,80,null,null,null,null,null,null,null,null,null,{"$f":"+(C20+D20+E20)*0.75*0.222222222222222","v":0},null,null,null,null,675,"L ",7101554,80,40,3197,0,0,30,4.5,1.5,"Y",20,"OLD TOWN RUN             "]
["BRO-32-1140 R",37,210.26,25,25,null,null,43.376666666666623,{"$f":"((C21*B21)+((E21*B21)+(D21*B21)))/9","v":1069.9577777777777},{"$f":"I21*0.1","v":106.99577777777777},null,null,null,null,null,260.26,260.26,260.26,null,null,null,null,null,"0800252",null,null,null,869,"R ",7101589,18,40,721,0,0,4,4.5,1.5,"N",0,"STREAM                   "]
["BRO-32-1141 L",37,210.26,25,25,null,null,43.376666666666623,{"$f":"((C22*B22)+((E22*B22)+(D22*B22)))/9","v":1069.9577777777777},{"$f":"I22*0.1","v":106.99577777777777},null,null,69,null,null,260.26,260.26,260.26,null,null,null,null,{"$f":"+(C22+D22+E22)*0.75*0.222222222222222","v":43.376666666666623},"0800236",null,null,null,869,"L ",7101600,18,40,721,0,0,4,4.5,1.5,"N",0,"STREAM                   "]
[null,null,null,null,null,null,null,null,null,null,null,null,74,null,null,null,null,null,null,null,null,null,{"$f":"+(C23+D23+E23)*0.75*0.222222222222222","v":0},null,null,null,null,1472,"R ",7101724,167,42,7018,0,0,30,3.5,1.5,"N",0,"CO RD 550                "]
["ROS-35-0674 L",37,79.72,25,25,null,null,21.619999999999976,{"$f":"((C24*B24)+((E24*B24)+(D24*B24)))/9","v":533.29333333333329},{"$f":"I24*0.1","v":53.329333333333331},null,null,null,null,null,129.72,129.72,129.72,null,null,null,null,null,"7101554",null,null,null,1472,"L ",7101732,167,51,8514,0,0,30,3.5,1.5,"N",0,"CO RD 550                "]
["ROS-35-0675 R",37,79.72,25,25,null,null,21.619999999999976,{"$f":"((C25*B25)+((E25*B25)+(D25*B25)))/9","v":533.29333333333329},{"$f":"I25*0.1","v":53.329333333333331},null,null,82,null,null,129.72,129.72,129.72,null,null,null,null,{"$f":"+(C25+D25+E25)*0.75*0.222222222222222","v":21.619999999999976},"7101546",null,null,null,1663,"L ",7101740,127,42,5339,0,0,37,3.5,1.5,"N",0,"CO RD 550                "]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,1663,"R ",7101805,127,42,5339,0,0,37,3.5,1.5,"N",0,"CO RD 550                "]
["ROS-35-0869 R",37,18.5,25,25,null,null,11.416666666666655,{"$f":"((C27*B27)+((E27*B27)+(D27*B27)))/9","v":281.61111111111109},{"$f":"I27*0.1","v":28.161111111111111},null,null,100,null,null,{"$f":"+C27+D27+E27","v":68.5},{"$f":"+C27+D27+E27","v":68.5},{"$f":"+C27+D27+E27","v":68.5},null,null,null,null,{"$f":"+(C27+D27+E27)*0.75*0.222222222222222","v":11.416666666666655},"7101589",null,null,null,1851,"L ",7101864,266,36.299999999999997,9645,0,0,55,3.5,1.5,"N",0,"SR 104                   "]
["ROS-35-0869 L",37,18.5,25,25,null,null,11.416666666666655,{"$f":"((C28*B28)+((E28*B28)+(D28*B28)))/9","v":281.61111111111109},{"$f":"I28*0.1","v":28.161111111111111},null,null,100,null,null,{"$f":"+C28+D28+E28","v":68.5},{"$f":"+C28+D28+E28","v":68.5},{"$f":"+C28+D28+E28","v":68.5},null,null,null,null,{"$f":"+(C28+D28+E28)*0.75*0.222222222222222","v":11.416666666666655},"7101600"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,1919,"L ",7101988,1181,36,42518,0,0,20,2.5,1.5,"N",0,"SCIOTO RIVER             "]
["ROS-35-1471 R",38.5,166.8,25,25,null,null,36.133333333333297,{"$f":"((C30*B30)+((E30*B30)+(D30*B30)))/9","v":927.4222222222221},92.74222222222221,null,null,96,null,null,{"$f":"+C30+D30+E30","v":216.8},{"$f":"+C30+D30+E30","v":216.8},216.8,null,null,null,null,{"$f":"+(C30+D30+E30)*0.75*0.222222222222222","v":36.133333333333297},"7101724",null,null,null,1919,"R ",7102011,1181,36,42518,0,0,20,2.5,1.5,"N",0,"SCIOTO RIVER             "]
["ROS-35-1472 L",53.04,166.8,25,25,null,null,36.133333333333297,{"$f":"((C31*B31)+((E31*B31)+(D31*B31)))/9","v":1277.6746666666668},{"$f":"I31*0.1","v":127.76746666666668},null,null,96,null,null,{"$f":"+C31+D31+E31","v":216.8},{"$f":"+C31+D31+E31","v":216.8},363.6,70,null,null,null,{"$f":"+(C31+D31+E31)*0.75*0.222222222222222","v":36.133333333333297},"7101732",null,null,null,1972,"L ",7102046,174,59,10269,0,0,7,2.5,1.5,"N",0,"SR 159 (BRIDGE ST)       "]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,1972,"R ",7102070,174,42,7309,0,0,7,2.5,1.5,"N",0,"SR 159 (BRIDGE ST)       "]
["ROS-35-1551 R",38.04,92.5,25,25,null,null,23.749999999999975,{"$f":"((C33*B33)+((E33*B33)+(D33*B33)))/9","v":602.29999999999995},{"$f":"I33*0.1","v":60.23},null,null,68,null,null,{"$f":"+C33+D33+E33","v":142.5},{"$f":"+C33+D33+E33","v":142.5},{"$f":"+C33+D33+E33","v":142.5},null,null,null,null,{"$f":"+(C33+D33+E33)*0.75*0.222222222222222","v":23.749999999999975},"7101686",null,null,null,2014,"L ",7102100,145,42,6092,0,0,1,2.5,1.5,"Y",25,"N&W RR                   "]
["ROS-35-1551 L",38.04,92.5,25,25,null,null,23.749999999999975,{"$f":"((C34*B34)+((E34*B34)+(D34*B34)))/9","v":602.29999999999995},{"$f":"I34*0.1","v":60.23},null,null,null,null,null,{"$f":"+C34+D34+E34","v":142.5},{"$f":"+C34+D34+E34","v":142.5},{"$f":"+C34+D34+E34","v":142.5},null,null,null,null,{"$f":"+(C34+D34+E34)*0.75*0.222222222222222","v":23.749999999999975},"7101651",null,null,null,2014,"R ",7102135,145,42,6092,0,0,1,2.5,1.5,"Y",25,"N&W RR                   "]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,2042,0,7102194,233,37,8622,0,0,59,2.5,1.5,"Y",25,"S.B. US 23               "]
["ROS-35-1659 R",37.67,129.13999999999999,25,25,null,null,29.856666666666634,{"$f":"((C36*B36)+((E36*B36)+(D36*B36)))/9","v":749.8004222222221},{"$f":"I36*0.1","v":74.98004222222221},null,null,116,null,null,{"$f":"+C36+D36+E36","v":179.14},{"$f":"+C36+D36+E36","v":179.14},{"$f":"+C36+D36+E36","v":179.14},null,null,null,null,{"$f":"+(C36+D36+E36)*0.75*0.222222222222222","v":29.856666666666634},"7101805",null,null,null,2419,"L ",7102259,1286,36,46296,0,0,0,2,1.5,"Y",25,"SCIOTO RIVER             "]
["ROS-35-1660 L",37.67,129.13999999999999,25,25,null,null,29.856666666666634,{"$f":"((C37*B37)+((E37*B37)+(D37*B37)))/9","v":749.8004222222221},{"$f":"I37*0.1","v":74.98004222222221},null,null,116,null,null,{"$f":"+C37+D37+E37","v":179.14},{"$f":"+C37+D37+E37","v":179.14},{"$f":"+C37+D37+E37","v":179.14},null,null,null,null,{"$f":"+(C37+D37+E37)*0.75*0.222222222222222","v":29.856666666666634},"7101740"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,2419,"R ",7102291,1280.3,39,49934,0,0,10,1,1.5,"Y",25,"SCIOTO RIVER             "]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,2604,"R ",7102410,79.599999999999994,45,3584,0,0,20,1,1.5,"Y",25,"DRY RUN                  "]
[]
[]
["TOTAL",null,null,null,null,{"$f":"SUM(F14:F40)","v":0},null,{"$f":"+SUM(H10:H41)","v":525.46166666666613},{"$f":"+SUM(I10:I41)","v":14666.144355555552},{"$f":"+SUM(J10:J41)","v":1466.6144355555557},null,null,{"$f":"+SUM(M10:M41)","v":1230},null,{"$f":"SUM(O10:O37)","v":230.97},{"$f":"+SUM(P10:Q40)","v":6473.2000000000016},null,{"$f":"+SUM(R10:R41)","v":3334.3799999999997},{"$f":"+SUM(S10:S41)","v":417.65999999999997},null,null,null,{"$f":"SUM(W10:W41)","v":416.16833333333295},null,null,null,null,3343,"R ",7102623,150.69999999999999,45,6781,0,0,9,1,1.5,"Y",25,"JACKSON SHORT LINE R.R.  "]
["CONVERT TO MILES",null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"O42/5280","v":4.3744318181818183E-2},{"$f":"+P42/5280","v":1.2259848484848488},null,{"$f":"+R42/5280","v":0.63151136363636362},null,null,null,null,null,null,null,null,null,3402,0,7102607,222,39,8654,0,0,0,1,1.5,"Y",25,"VIGO ROAD (CR 207)       "]
["TOTALS CARRIED TO GENERAL SUMMARY",null,null,null,null,{"$f":"F42","v":0},null,{"$f":"+ROUNDUP(H42,0)","v":526},{"$f":"+ROUNDUP(I42,0)","v":14667},{"$f":"+ROUNDUP(J42,0)","v":1467},null,null,{"$f":"+ROUNDUP(M42,0)","v":1230},null,{"$f":"+ROUNDUP(O43,2)","v":0.05},{"$f":"+ROUNDUP(P43,2)","v":1.23},null,{"$f":"+ROUNDUP(R43,2)","v":0.64},{"$f":"+ROUNDUP(S42,0)","v":418},null,null,null,{"$f":"+ROUNDUP(W42,0)","v":417},null,null,null,null,3418,"L ",7102666,283,55.8,15780,0,0,20,1,1.5,"Y",25,"SALT CREEK               "]

{"sheet":"STRUCTURES 2","index":5,"n_rows":44,"n_cols":41,"rows_kept":44,"cut":false,"hidden":false,"merged":[[41,0,41,4],[41,15,41,16],[42,0,42,4],[42,15,42,16],[43,0,43,4],[43,15,43,16],[1,17,7,17],[1,18,7,18],[1,19,7,19],[1,20,7,20],[1,21,7,21],[1,22,7,22],[0,23,8,23],[1,5,7,5],[1,6,7,6],[1,7,7,7],[1,8,7,8],[1,9,7,9],[1,10,7,10],[1,11,7,11],[1,12,7,12],[1,13,7,13],[0,15,0,16],[1,14,7,14],[1,15,3,16],[4,15,7,15],[4,16,7,16],[0,0,8,0],[0,1,7,1],[0,2,7,2],[0,3,7,3],[0,4,7,4]]}
["BRIDGE NUMBER","WIDTH (TOE/TOE OF PARAPETS)","LENGTH (BRIDGE LIMITS)","REAR APPROACH SLAB LENGTH","FORWARD APPROACH SLAB LENGTH","SPECIAL",null,512,512,512,null,null,516,null,null,642,null,642,null,null,null,null,512,"STRUCTURAL FILE NUMBER"]
[null,null,null,null,null,"PATCHING CONCRETE BRIDGE DECK OVERLAY WITH MICRO-SILICA MODIFIED CONCRETE",null,"REMOVAL OF EXISTING COATINGS FROM CONCRETTE SURFACES ","TREATING OF CONCRETE BRIDGE DECKS WITH SRS (INCLUDING APPROACH SLABS)","SEALING CONCRETE BRIDGE DECKS WITH HMWM RESIN, AS PER PLAN (ESTIMATED AT 10% OF SRS AREA)",null,null,"PREFORMED ELASTOMERIC COMPRESSION JOINT SEAL",null,null,"EDGE LINE, 6\", TYPE 1",null,"LANE LINE, 6\", TYPE 1",null,null,null,null,"REMOVAL OF EXISTING COATINGS FROM CONCRETTE SURFACES "]
[]
[]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"WHITE","YELLOW"]
[]
[]
[]
[null,"FT","FT","FT","FT","SQ YD",null,"SQ YD","SQ YD","SQ YD",null,null,"FT",null,null,"FT","FT","FT",null,null,null,null,"SQ YD"]
["ROS-35-1848 L",32.92,269.83999999999997,25,25,null,null,{"$f":"+($C10+$D10+$E10)*0.75*0.222222222222222","v":53.306666666666608},{"$f":"((C10*B10)+((E10*B10)+(D10*B10)))/9","v":1169.9036444444444},{"$f":"I10*0.1","v":116.99036444444444},null,null,55,null,null,{"$f":"+C10+D10+E10","v":319.83999999999997},{"$f":"+C10+D10+E10","v":319.83999999999997},{"$f":"+C10+D10+E10","v":319.83999999999997},null,null,null,null,{"$f":"+(C10+D10+E10)*0.75*0.222222222222222","v":53.306666666666608},7101864]
["ROS-35-1849 R",32.92,269.83999999999997,25,25,null,null,{"$f":"+($C11+$D11+$E11)*0.75*0.222222222222222","v":53.306666666666608},{"$f":"((C11*B11)+((E11*B11)+(D11*B11)))/9","v":1169.9036444444444},{"$f":"I11*0.1","v":116.99036444444444},null,null,54,null,null,{"$f":"+C11+D11+E11","v":319.83999999999997},{"$f":"+C11+D11+E11","v":319.83999999999997},{"$f":"+C11+D11+E11","v":319.83999999999997},null,null,null,null,{"$f":"+(C11+D11+E11)*0.75*0.222222222222222","v":53.306666666666608},7101899]
[]
["ROS-35-1874 L",47.67,169.9,25,25,null,null,36.649999999999963,{"$f":"((C13*B13)+((E13*B13)+(D13*B13)))/9","v":1164.7370000000001},{"$f":"I13*0.1","v":116.47370000000001},null,null,null,null,null,{"$f":"+C13+D13+E13","v":219.9},{"$f":"+C13+D13+E13","v":219.9},{"$f":"+C13+D13+E13","v":219.9},null,null,null,null,{"$f":"+(C13+D13+E13)*0.75*0.222222222222222","v":36.649999999999963},7101929]
["ROS-35-1877 R",52.92,169.9,25,25,null,null,36.649999999999963,{"$f":"((C14*B14)+((E14*B14)+(D14*B14)))/9","v":1293.0119999999999},{"$f":"I14*0.1","v":129.30119999999999},null,null,84,null,null,{"$f":"+C14+D14+E14","v":219.9},{"$f":"+C14+D14+E14","v":219.9},414.8,null,null,null,null,{"$f":"+(C14+D14+E14)*0.75*0.222222222222222","v":36.649999999999963},7101953]
[null,null,null,null,null,45]
["ROS-35-1920 L",33.25,1183,25,25,null,null,205.49999999999977,{"$f":"((C16*B16)+((E16*B16)+(D16*B16)))/9","v":4555.25},{"$f":"I16*0.1","v":455.52500000000003},null,null,null,null,null,{"$f":"+C16+D16+E16","v":1233},{"$f":"+C16+D16+E16","v":1233},{"$f":"+C16+D16+E16","v":1233},null,null,null,null,{"$f":"+(C16+D16+E16)*0.75*0.222222222222222","v":205.49999999999977},7101988]
["ROS-35-1921 R",33.25,1183,25,25,null,null,205.49999999999977,{"$f":"((C17*B17)+((E17*B17)+(D17*B17)))/9","v":4555.25},455.52500000000003,null,null,null,null,null,{"$f":"+C17+D17+E17","v":1233},{"$f":"+C17+D17+E17","v":1233},{"$f":"+C17+D17+E17","v":1233},null,null,null,null,null,7102011]
[]
[null,null,null,null,null,null,null,null,null,null,null,null,40,null,null,null,null,null,null,null,null,null,{"$f":"+(C19+D19+E19)*0.75*0.222222222222222","v":0},null,null,null,null,675,"R ",7101546,80,40,3197,0,0,30,4.5,1.5,"Y",20,"OLD TOWN RUN             "]
[null,null,null,null,null,null,null,null,null,null,null,null,80,null,null,null,null,null,null,null,null,null,{"$f":"+(C20+D20+E20)*0.75*0.222222222222222","v":0},null,null,null,null,675,"L ",7101554,80,40,3197,0,0,30,4.5,1.5,"Y",20,"OLD TOWN RUN             "]
[null,null,null,null,null,0,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,869,"R ",7101589,18,40,721,0,0,4,4.5,1.5,"N",0,"STREAM                   "]
[null,null,null,null,null,null,null,null,null,null,null,null,69,null,null,null,null,null,null,null,null,null,{"$f":"+(C22+D22+E22)*0.75*0.222222222222222","v":0},null,null,null,null,869,"L ",7101600,18,40,721,0,0,4,4.5,1.5,"N",0,"STREAM                   "]
[null,null,null,null,null,null,null,null,null,null,null,null,74,null,null,null,null,null,null,null,null,null,{"$f":"+(C23+D23+E23)*0.75*0.222222222222222","v":0},null,null,null,null,1472,"R ",7101724,167,42,7018,0,0,30,3.5,1.5,"N",0,"CO RD 550                "]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,1472,"L ",7101732,167,51,8514,0,0,30,3.5,1.5,"N",0,"CO RD 550                "]
[null,null,null,null,null,null,null,null,null,null,null,null,82,null,null,null,null,null,null,null,null,null,{"$f":"+(C25+D25+E25)*0.75*0.222222222222222","v":0},null,null,null,null,1663,"L ",7101740,127,42,5339,0,0,37,3.5,1.5,"N",0,"CO RD 550                "]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,1663,"R ",7101805,127,42,5339,0,0,37,3.5,1.5,"N",0,"CO RD 550                "]
[null,null,null,null,null,null,null,null,null,null,null,null,100,null,null,null,null,null,null,null,null,null,{"$f":"+(C27+D27+E27)*0.75*0.222222222222222","v":0},null,null,null,null,1851,"L ",7101864,266,36.299999999999997,9645,0,0,55,3.5,1.5,"N",0,"SR 104                   "]
[null,null,null,null,null,null,null,null,null,null,null,null,100,null,null,null,null,null,null,null,null,null,{"$f":"+(C28+D28+E28)*0.75*0.222222222222222","v":0}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,1919,"L ",7101988,1181,36,42518,0,0,20,2.5,1.5,"N",0,"SCIOTO RIVER             "]
[null,null,null,null,null,null,null,null,null,null,null,null,96,null,null,null,null,null,null,null,null,null,{"$f":"+(C30+D30+E30)*0.75*0.222222222222222","v":0},null,null,null,null,1919,"R ",7102011,1181,36,42518,0,0,20,2.5,1.5,"N",0,"SCIOTO RIVER             "]
[null,null,null,null,null,null,null,null,null,null,null,null,96,null,null,null,null,null,null,null,null,null,{"$f":"+(C31+D31+E31)*0.75*0.222222222222222","v":0},null,null,null,null,1972,"L ",7102046,174,59,10269,0,0,7,2.5,1.5,"N",0,"SR 159 (BRIDGE ST)       "]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,1972,"R ",7102070,174,42,7309,0,0,7,2.5,1.5,"N",0,"SR 159 (BRIDGE ST)       "]
[null,null,null,null,null,null,null,null,null,null,null,null,68,null,null,null,null,null,null,null,null,null,{"$f":"+(C33+D33+E33)*0.75*0.222222222222222","v":0},null,null,null,null,2014,"L ",7102100,145,42,6092,0,0,1,2.5,1.5,"Y",25,"N&W RR                   "]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"+(C34+D34+E34)*0.75*0.222222222222222","v":0},null,null,null,null,2014,"R ",7102135,145,42,6092,0,0,1,2.5,1.5,"Y",25,"N&W RR                   "]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,2042,0,7102194,233,37,8622,0,0,59,2.5,1.5,"Y",25,"S.B. US 23               "]
[null,null,null,null,null,null,null,null,null,null,null,null,116,null,null,null,null,null,null,null,null,null,{"$f":"+(C36+D36+E36)*0.75*0.222222222222222","v":0},null,null,null,null,2419,"L ",7102259,1286,36,46296,0,0,0,2,1.5,"Y",25,"SCIOTO RIVER             "]
[null,null,null,null,null,null,null,null,null,null,null,null,116,null,null,null,null,null,null,null,null,null,{"$f":"+(C37+D37+E37)*0.75*0.222222222222222","v":0}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,2419,"R ",7102291,1280.3,39,49934,0,0,10,1,1.5,"Y",25,"SCIOTO RIVER             "]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,2604,"R ",7102410,79.599999999999994,45,3584,0,0,20,1,1.5,"Y",25,"DRY RUN                  "]
[]
[]
["TOTAL",null,null,null,null,{"$f":"SUM(F14:F40)","v":45},null,{"$f":"+SUM(H10:H41)","v":590.91333333333273},{"$f":"+SUM(I10:I41)","v":13908.056288888889},{"$f":"+SUM(J10:J41)","v":1390.805628888889},null,null,{"$f":"+SUM(M10:M41)","v":1230},null,null,{"$f":"+SUM(P10:Q40)","v":7090.96},null,{"$f":"+SUM(R10:R41)","v":3740.38},null,null,null,null,{"$f":"SUM(W10:W41)","v":385.4133333333329},null,null,null,null,3343,"R ",7102623,150.69999999999999,45,6781,0,0,9,1,1.5,"Y",25,"JACKSON SHORT LINE R.R.  "]
["CONVERT TO MILES",null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"+P42/5280","v":1.3429848484848486},null,{"$f":"+R42/5280","v":0.70840530303030302},null,null,null,null,null,null,null,null,null,3402,0,7102607,222,39,8654,0,0,0,1,1.5,"Y",25,"VIGO ROAD (CR 207)       "]
["TOTALS CARRIED TO GENERAL SUMMARY",null,null,null,null,{"$f":"F42","v":45},null,{"$f":"+ROUNDUP(H42,0)","v":591},{"$f":"+ROUNDUP(I42,0)","v":13909},{"$f":"+ROUNDUP(J42,0)","v":1391},null,null,{"$f":"+ROUNDUP(M42,0)","v":1230},null,null,{"$f":"+ROUNDUP(P43,2)","v":1.35},null,{"$f":"+ROUNDUP(R43,2)","v":0.71},null,null,null,null,{"$f":"+ROUNDUP(W42,0)","v":386},null,null,null,null,3418,"L ",7102666,283,55.8,15780,0,0,20,1,1.5,"Y",25,"SALT CREEK               "]