{"text_format":"1","workbook":"xlsx","n_sheets":4,"sheets":["Data From Ellis","Work Types","Data from CAS-TAS","data"],"not_rendered":{"charts":0,"images":0,"macros":1,"external_links":0,"defined_names":5,"comments":0,"pivot_tables":1},"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":"Data From Ellis","index":0,"n_rows":501,"n_cols":10,"rows_kept":501,"cut":false,"hidden":false,"merged":[]}
["Design Build Projects as recorded in ODOT Ellis computer system",null,null,null,null,null,"Data Updated:","2013-06-05"]
["Query: Design Builds ",null,null,null,"Date Saved:","2013-06-05T17:45:35"]
["Award Date Fiscal Year","District","PID","Project Name (ie CRS)","Primary Work Category","Project Description","Awarded Sale Amount","Construction Estimate (PE, R/W COSTS NOT INCLUDED)"]
[1998,7,8410,"CLA US 68 12.52","New Construction","CONSTRUCT A CONNECTION BETWEEN CLA-68-15.19 AND CHP-68-0.00, TO BETTER  UTILIZE EXISTING L/A SECTION OF ROADWAY. DESIGN & BUILD PROJECT.",15126788.732999999,15926877.4,{"$f":"IF(G4=\"\",H4,G4)","v":15126788.732999999},{"$f":"IF(B4=\"Subtotal\",SUMIF($A$4:$A$500,A4,$I$4:$I$500)-I4,\"\")","v":""}]
[1998,"No. of Projects",{"$f":"SUBTOTAL(3,C4:C4)","v":1},null,null,null,null,null,{"$f":"IF(G5=\"\",H5,G5)","v":0},{"$f":"IF(B5=\"Subtotal\",SUMIF($A$4:$A$500,A5,$I$4:$I$500)-I5,\"\")","v":""}]
[1998,"Subtotal","_",null,null,null,null,15126788.732999999,15126788.732999999,{"$f":"IF(B6=\"Subtotal\",SUMIF($A$4:$A$500,A6,$I$4:$I$500)-I6,\"\")","v":15126788.732999999}]
[2000,3,18200,"MED IR 0271 00.00","Major Reconstruction","PAVEMENT RECONSTRUCTION DESIGN BUILD PROJECT",18856379.748,21362542.210000001,18856379.748,{"$f":"IF(B7=\"Subtotal\",SUMIF($A$4:$A$500,A7,$I$4:$I$500)-I7,\"\")","v":""}]
[2000,4,18703,"ATB SR 0045 19.92","Bridge Replacement","WIDENING OF BRIDGE ATB-45-19.92 OVER IR 90. DESIGN/BUILD. HIGH PRIORITY PROJECT MAX $1,555,082.",3228037.6009999998,3133281.08,3228037.6009999998,{"$f":"IF(B8=\"Subtotal\",SUMIF($A$4:$A$500,A8,$I$4:$I$500)-I8,\"\")","v":""}]
[2000,4,20411,"STA IR 0077 11.59","Major Reconstruction","MAJOR UPGRADE TO INCLUDE MODIFICATIONS TO MAINLINE, RAMPS, SERVICE ROADS AND BRIDGES. ADD LANE BOTH DIRCTIONS; CONSTRUCT FOR 12874; TRC ON DIST BRIDGE ONLY. DBrelates to pids 20410, 20412, 10769",26159793.022999998,24905922.300000001,26159793.022999998,{"$f":"IF(B9=\"Subtotal\",SUMIF($A$4:$A$500,A9,$I$4:$I$500)-I9,\"\")","v":""}]
[2000,6,20681,"FRA IR 71 14.39","Major Reconstruction","IR71: PARTIAL AND FULL DEPTH PAVT REPAIR PAVT INLAY. SR315: REMOVE/REPLACE PAVT A ND SUBBASE, CURB, INLETS. REPLACE CONC BARRIER, LIGHTS, SIGNS, GUARDRAIL. D/B.",4015250.3879999998,3758870.58,4015250.3879999998,{"$f":"IF(B10=\"Subtotal\",SUMIF($A$4:$A$500,A10,$I$4:$I$500)-I10,\"\")","v":""}]
[2000,7,11160,"MIA IR 75 4.94","Major Widening","ADD ADDITIONAL LANES AND RECONSTRUCT EXISTING ROADWAY, UPGRADE ALL STRUCTURES AND PROVIDE 16'6\" VERTICAL CLEARANCE. REMOVE MIA-75-0733L&R.* MNC MAX $18MIL.",49534522.074000001,50524044.439999998,49534522.074000001,{"$f":"IF(B11=\"Subtotal\",SUMIF($A$4:$A$500,A11,$I$4:$I$500)-I11,\"\")","v":""}]
[2000,8,18899,"PRE IR 70 0.00","Minor Rehabilitation - Pavement Prmy Sys","PROJECT CONSISTS OF PLANING, SUPERPAVING, INSTALL RAISED PAVEMENT MARKERS, WIDENING MAINLINE BRIDGES, AND PAINTING 12 INTERSTATE BRIDGES.  DESIGN/BUILD. COMBINED WITH PIDS 19391 AND 19411.",22364931.905000001,21869858.879999999,22364931.905000001,{"$f":"IF(B12=\"Subtotal\",SUMIF($A$4:$A$500,A12,$I$4:$I$500)-I12,\"\")","v":""}]
[2000,"No. of Projects",{"$f":"SUBTOTAL(3,C7:C12)","v":6},null,null,null,null,null,0,{"$f":"IF(B13=\"Subtotal\",SUMIF($A$4:$A$500,A13,$I$4:$I$500)-I13,\"\")","v":""}]
[2000,"Subtotal","_",null,null,null,null,124158914.73899999,124158914.73899999,{"$f":"IF(B14=\"Subtotal\",SUMIF($A$4:$A$500,A14,$I$4:$I$500)-I14,\"\")","v":124158914.73899999}]
[2001,1,21082,"ALL US30 18.18","Bridge Repair","REPLACE DECKS ON STRUCTURES OVER IR75 AND NORFOLK SOUTHERN R.R. MICRO-SILICA   OVERLAY DECKS ON STRUCTURES OVER NAPOLEON ROAD. NO R/W REQ'D. DESIGN BUILD.",2365518.9920000001,2514997,2365518.9920000001,{"$f":"IF(B15=\"Subtotal\",SUMIF($A$4:$A$500,A15,$I$4:$I$500)-I15,\"\")","v":""}]
[2001,3,17891,"LOR IR 0090 10.76","Resurfacing, Divided System","4-LANE RESURFACING & BRIDGE DECK OVERLAY INCL. ADD A LANE SR611 TO EXIST 6-LANE ENVIRONMENTAL CLEARED WITH PID 11385 DESIGN BUILD PROJECT",15072549.698999999,17843111.109999999,15072549.698999999,{"$f":"IF(B16=\"Subtotal\",SUMIF($A$4:$A$500,A16,$I$4:$I$500)-I16,\"\")","v":""}]
[2001,4,18722,"MAH SR 0011 16.04","Bridge Replacement","MAJOR BRIDGE WORK ON MAH. SR 11 - 16.04 L, SB OVER I80 EB AND MAH. SR 11 - 16.15 L, SB OVER I 680 WB RAMP & SR 11-16.05L OVER IR80 EB.COMBINED W/CANCEL PID 19322",4508109.0420000004,4266200,4508109.0420000004,{"$f":"IF(B17=\"Subtotal\",SUMIF($A$4:$A$500,A17,$I$4:$I$500)-I17,\"\")","v":""}]
[2001,4,19854,"POR US 0224 00.00","Resurfacing,  Undivided System","TWO LANE RESURFACING FROM SUMMIT CO. TO SR183.SAFETY IMPRV. BY ADDING TURN LANE TO MARTIN, CONGRESS LAKE AND WATERLOO INTERSECTION. DESIGN BUILD PROJECT.",4029915.7560000001,3726804,4029915.7560000001,{"$f":"IF(B18=\"Subtotal\",SUMIF($A$4:$A$500,A18,$I$4:$I$500)-I18,\"\")","v":""}]
[2001,4,19899,"ATB SR 0011 23.33","Bridge Repair","REDECK, ABUT. CARSON ROAD OVER SR 11. DESIGN BUILD PROJECT.",680428.43,607458.5,680428.43,{"$f":"IF(B19=\"Subtotal\",SUMIF($A$4:$A$500,A19,$I$4:$I$500)-I19,\"\")","v":""}]
[2001,4,22163,"TRU IR 0080 09.08","Resurfacing, Divided System","4 LANE RESURFACING WITH BRIDGEWORK.",5373166.9749999996,5219099.9800000004,5373166.9749999996,{"$f":"IF(B20=\"Subtotal\",SUMIF($A$4:$A$500,A20,$I$4:$I$500)-I20,\"\")","v":""}]
[2001,8,12412,"HAM IR 471 0.26","Minor Rehabilitation - Pavement Prmy Sys","MAJOR REHABILITATION OF EXISTING PAVEMENT AND SAFETY UPGRADE.  0.47 MILES DESIGN BUILD PROJECT",16821520.425999999,16583439.98,16821520.425999999,{"$f":"IF(B21=\"Subtotal\",SUMIF($A$4:$A$500,A21,$I$4:$I$500)-I21,\"\")","v":""}]
[2001,8,19705,"HAM IR 71 11.08","Resurfacing, Divided System","PROJECT CONSISTS OF PLANING AND RESURFACING AND INSTALLING PAVEMENT      MARKINGS.CLOSURE OF NOISE WALL GAPS.  PAINT AND LANDSCAPE EXISTING WALLS.",11791608.163000001,11789259.99,11791608.163000001,{"$f":"IF(B22=\"Subtotal\",SUMIF($A$4:$A$500,A22,$I$4:$I$500)-I22,\"\")","v":""}]
[2001,8,19786,"HAM IR 275 32.27","Resurfacing, Divided System","PROJECT CONSISTS OF PLANING, RESURFACING, PAVEMEMT MARKINGS AND STRUCTURAL STEEL RETROFIT, OVERLAY AND NEW PARAPETS FOR MAINLINE BR. OVER GREAT MIAMI RIVER",32140257.513999999,31561632.690000001,32140257.513999999,{"$f":"IF(B23=\"Subtotal\",SUMIF($A$4:$A$500,A23,$I$4:$I$500)-I23,\"\")","v":""}]
[2001,10,21053,"ATH US 33 10.41","Bridge Repair","BRIDGE DECK REHABILITATION. INCLUDES ATH-33-10.41R. DETOUR APPLICATION REQUIRED. DESIGN BUILD.",1899668.915,1899900,1899668.915,{"$f":"IF(B24=\"Subtotal\",SUMIF($A$4:$A$500,A24,$I$4:$I$500)-I24,\"\")","v":""}]
[2001,11,12761,"TUS IR 77 3.94","Resurfacing, Divided System","4-LANE MAJOR RHABILITAION - RUBBLIZE AND ROLL; SIGNING, LIGHTING, FENCING, GUARD- RAIL, MODIFY OR REPAIR 5 BRIDGES. DESIGN BUILD.",10011441.859999999,9618699.9900000002,10011441.859999999,{"$f":"IF(B25=\"Subtotal\",SUMIF($A$4:$A$500,A25,$I$4:$I$500)-I25,\"\")","v":""}]
[2001,"No. of Projects",{"$f":"SUBTOTAL(3,C15:C25)","v":11},null,null,null,null,null,0,{"$f":"IF(B26=\"Subtotal\",SUMIF($A$4:$A$500,A26,$I$4:$I$500)-I26,\"\")","v":""}]
[2001,"Subtotal","_",null,null,null,null,104694185.77200001,104694185.77200001,{"$f":"IF(B27=\"Subtotal\",SUMIF($A$4:$A$500,A27,$I$4:$I$500)-I27,\"\")","v":104694185.77200001}]
[2002,1,21490,"HAR SR 81 16.54","Bridge Repair","REPLACE DECK ON STRUCTURE OVER THE BLANCHARD RIVER.",358972.054,337250,358972.054,{"$f":"IF(B28=\"Subtotal\",SUMIF($A$4:$A$500,A28,$I$4:$I$500)-I28,\"\")","v":""}]
[2002,1,23567,"ALL CR 88 0.36","Major Widening","WIDEN EXISTING ROADWAY TO THREE LANES TO PROVIDE FOR A TWO WAY LEFT TURN LANE FROM WEST OF GRONE RD. TO EAST OF LEHMAN RD. FEDERAL MAX $116,500",126885.659,239694.04,126885.659,{"$f":"IF(B29=\"Subtotal\",SUMIF($A$4:$A$500,A29,$I$4:$I$500)-I29,\"\")","v":""}]
[2002,2,22516,"HEN SR 108 15.61","Bridge Repair","REHAB EXISTING BRIDGE BY REPLACING PARAPETS, SIDEWALKS & WEARING SURFACE; PATCH CONC SPANDRAL WALLS AS REQUIRED; PERFORM  NECESSARY RELATED WORK. DESIGN-BUILD",1025541.085,934490,1025541.085,{"$f":"IF(B30=\"Subtotal\",SUMIF($A$4:$A$500,A30,$I$4:$I$500)-I30,\"\")","v":""}]
[2002,5,22587,"PER CR 57 05.60","Bridge Replacement","REPLACE 4 BRIDGES. INCLUDES PID 21426.",732832.75199999998,673850,732832.75199999998,{"$f":"IF(B31=\"Subtotal\",SUMIF($A$4:$A$500,A31,$I$4:$I$500)-I31,\"\")","v":""}]
[2002,5,22627,"GUE CR 73 00.00","Bridge Replacement","REPLACE 6 BRIDGES",537263.28700000001,494288,537263.28700000001,{"$f":"IF(B32=\"Subtotal\",SUMIF($A$4:$A$500,A32,$I$4:$I$500)-I32,\"\")","v":""}]
[2002,7,19669,"MOT SR 4 4.83","Bridge Replacement","REPLACE 28FT STRUCTURE OVER DRY RUN WITH MINIMAL APPROACH WORK.  CLEAR SPAN = 25 FT",306540.50400000002,299860,306540.50400000002,{"$f":"IF(B33=\"Subtotal\",SUMIF($A$4:$A$500,A33,$I$4:$I$500)-I33,\"\")","v":""}]
[2002,7,24375,"MER CR 22 1.32","Bridge Replacement","REMOVE THREE EXISTING BRIDGE AND ASSOC.  ROADWAY APPROACH PAVT. CONSTRUCT NEW PRECAST CONCRETE BOX BRIDGES AND ASSOC. ROADWAY APPROACH. DESIGN/BUILD.",405588.103,373390,405588.103,{"$f":"IF(B34=\"Subtotal\",SUMIF($A$4:$A$500,A34,$I$4:$I$500)-I34,\"\")","v":""}]
[2002,8,21713,"PRE US 40 1.33","Bridge Replacement","REPLACE BRIDGE NO. PRE-40-0133 OVER TRIBUTARY OF THE EAST FORK OF THE        WHITEWATER RIVER.  DESIGN BUILD PROJECT",262920.15500000003,265540,262920.15500000003,{"$f":"IF(B35=\"Subtotal\",SUMIF($A$4:$A$500,A35,$I$4:$I$500)-I35,\"\")","v":""}]
[2002,8,24434,"PRE TR 444 0.80 & VAR DB","Bridge Replacement","REPLACE THREE EXISTING TRUSS BRIDGES     (TR444-.80 TR453-1.25, AND TR409-1.60)   AND REPLACE EXISTINGSTEEL BEAM BRIDGE    (CR56-.60) DESIGN BUILD PROJECT.",1430890.5560000001,1579238.71,1430890.5560000001,{"$f":"IF(B36=\"Subtotal\",SUMIF($A$4:$A$500,A36,$I$4:$I$500)-I36,\"\")","v":""}]
[2002,"No. of Projects",{"$f":"SUBTOTAL(3,C28:C36)","v":9},null,null,null,null,null,0,{"$f":"IF(B37=\"Subtotal\",SUMIF($A$4:$A$500,A37,$I$4:$I$500)-I37,\"\")","v":""}]
[2002,"Subtotal","_",null,null,null,null,5187434.1550000003,5187434.1550000003,{"$f":"IF(B38=\"Subtotal\",SUMIF($A$4:$A$500,A38,$I$4:$I$500)-I38,\"\")","v":5187434.1550000003}]
[2003,1,24297,"PAU CR 111 4.65","Bridge Repair","REHABILITATE TWO EXISTING STRUCTURES BY REPLACING THE EXISTING DECKS. THIS WILL BE A DESIGN BUILD PROJECT.",948266.08499999996,540955.35,948266.08499999996,{"$f":"IF(B39=\"Subtotal\",SUMIF($A$4:$A$500,A39,$I$4:$I$500)-I39,\"\")","v":""}]
[2003,1,24518,"HAN CR 8 4.85","Bridge Replacement","REPLACE 6 EXISTING STRUCTURES IN HANCOCK COUNTY WITH NEW STRUCTURES. THIS WILL BE A DESIGN BUILD PROJECT.",1018570.5429999999,817520,1018570.5429999999,{"$f":"IF(B40=\"Subtotal\",SUMIF($A$4:$A$500,A40,$I$4:$I$500)-I40,\"\")","v":""}]
[2003,3,24442,"HUR CR 0124 01.880","Bridge Replacement","DESIGN BUILD PROJECT ON TR91 (TERRY RD) OVER THE HURON RIVER AND ON CR241 (WASHINGTON RD) OVER A BRANCH OF THE HURON RIVER",785137.96100000001,730581.4,785137.96100000001,{"$f":"IF(B41=\"Subtotal\",SUMIF($A$4:$A$500,A41,$I$4:$I$500)-I41,\"\")","v":""}]
[2003,4,18718,"SUM SR 0021 01.79","Bridge Repair","REHAB ONE STRUCTURE ON SR21 IN SUMMIT CO INCLUDES PIDS 18719 AND 13337.",1088493.798,1066510,1088493.798,{"$f":"IF(B42=\"Subtotal\",SUMIF($A$4:$A$500,A42,$I$4:$I$500)-I42,\"\")","v":""}]
[2003,4,19791,"STA IR 0077 00.00","Resurfacing, Divided System","FOUR LANE RESURFACING/UPGRADING FROM TUSCARAWAS COUNTY TO CANTON CORPORATION LIMIT.  INCLUDING WORK ON 5 BRIDGES",5189057.0930000003,5077263,5189057.0930000003,{"$f":"IF(B43=\"Subtotal\",SUMIF($A$4:$A$500,A43,$I$4:$I$500)-I43,\"\")","v":""}]
[2003,4,22174,"ATB SR 0011 25.16","Bridge Repair","REDECK STRUCTURE, MAKE STRUCTURAL STEEL CONTINUOUS AND PAINT STRUCTURAL STEEL ON THE LEFT AND RIGHT PARTS OF THE BRIDGE",10085422.189999999,10140920,10085422.189999999,{"$f":"IF(B44=\"Subtotal\",SUMIF($A$4:$A$500,A44,$I$4:$I$500)-I44,\"\")","v":""}]
[2003,4,22229,"SUM IR 0077 15.47","Bridge Repair","REDECK/PAINT BRIDGE UNDER STONER ST. OLD PID 19922",1536568.9920000001,1545830,1536568.9920000001,{"$f":"IF(B45=\"Subtotal\",SUMIF($A$4:$A$500,A45,$I$4:$I$500)-I45,\"\")","v":""}]
[2003,4,23672,"SUM Main Street","Major Reconstruction","DECK REPLACEMENT AND RELATED IMPROVEMENT.DESIGN-BUILD PROJECT.",5260233.9570000004,5920548.7699999996,5260233.9570000004,{"$f":"IF(B46=\"Subtotal\",SUMIF($A$4:$A$500,A46,$I$4:$I$500)-I46,\"\")","v":""}]
[2003,4,23929,"TRU SR 0011 09.08","Lighting","INSTALL INTERCHANGE LIGHTING FOR SR82 AT SR11 INTERCHANGE, ALSO RESURFACE THE INTERCHANGE INCLUDING ALL RAMPS WITH SKID-RESISTANT MATERIAL",2251812.0159999998,2235652.1,2251812.0159999998,{"$f":"IF(B47=\"Subtotal\",SUMIF($A$4:$A$500,A47,$I$4:$I$500)-I47,\"\")","v":""}]
[2003,4,24038,"ATB CR 0020 00.02","Bridge Replacement","REPLACE A 3 SPAN 60FOOT BY 116FOOT BY 50FOOT PRATT TRUSS BRIDGE OVER NORFOLK & SOUTHERN RAILROAD (PLYMOUTH RIDGE ROAD)",1082067.8289999999,865977,1082067.8289999999,{"$f":"IF(B48=\"Subtotal\",SUMIF($A$4:$A$500,A48,$I$4:$I$500)-I48,\"\")","v":""}]
[2003,4,24447,"POR CR 0176 00.17","Bridge Replacement","BRIDGE REPLACEMENT. DESIGN BUILD PROJECT",238318.49600000001,203039.9,238318.49600000001,{"$f":"IF(B49=\"Subtotal\",SUMIF($A$4:$A$500,A49,$I$4:$I$500)-I49,\"\")","v":""}]
[2003,4,24663,"TRU CR 0302 02.40","Bridge Replacement","(DONLEY ROAD) REPLACE EXISTING BRIDGES OVER SWINE CREEK & BRAND RIVER",484343.79800000001,463586.98,484343.79800000001,{"$f":"IF(B50=\"Subtotal\",SUMIF($A$4:$A$500,A50,$I$4:$I$500)-I50,\"\")","v":""}]
[2003,5,19821,"GUE IR 77 07.68","Bridge Repair","DECK REPLACEMENT AND PAINTING ON TWO BRIDGES / DESIGN BUILD LANDSCAPING TE FUNDS",2175146.9380000001,2120800,2175146.9380000001,{"$f":"IF(B51=\"Subtotal\",SUMIF($A$4:$A$500,A51,$I$4:$I$500)-I51,\"\")","v":""}]
[2003,5,24369,"COS SR 16 07.18","Culvert Construction/Reconstr/Repair","Replace 2 culverts/1 bridge using the ODOT Design Build PolicyCos-16-7.18 = From SR 16E: SR 83S to CR-271E to Second Street E to SR 541N to SR 16ELic-13-17.11 = From SR 13N to TR-76 (Weaver Rd) to TR-75 (Preston Rd) to TR-105 (Joseph Rd) to SR 13Gue-821-0",524045.39500000002,553324.80000000005,524045.39500000002,{"$f":"IF(B52=\"Subtotal\",SUMIF($A$4:$A$500,A52,$I$4:$I$500)-I52,\"\")","v":""}]
[2003,6,12769,"PIC US 22 16.96","Bridge Repair","REHAB 633FT BRIDGE OVER SCIOTO RIVER WITH SHORT APPROACH AND APPROACH GUARDRAIL. DESIGN/BUILD FAST TRACK CONST",2967458.023,3528190,2967458.023,{"$f":"IF(B53=\"Subtotal\",SUMIF($A$4:$A$500,A53,$I$4:$I$500)-I53,\"\")","v":""}]
[2003,6,23948,"UNI CR 23 02.070","Bridge Replacement","CEAO DESIGN/BUILD PROJECT TO REPLACE TWO STRUCTURES ON CR23 AND CR213. PREVIOUSLY PROGRAMMED AS 2 SEPARATE PIDS; PID 23949 (CR213) COMBINED WITH THIS PID.",698623.72499999998,832293.9,698623.72499999998,{"$f":"IF(B54=\"Subtotal\",SUMIF($A$4:$A$500,A54,$I$4:$I$500)-I54,\"\")","v":""}]
[2003,6,23997,"FRA IR 270 1.52","Noise Wall","CONSTRUCTION OF TYPE2 (RETROFIT) NOISE WALL.  DESIGN/BUILD.",571530.03899999999,569250,571530.03899999999,{"$f":"IF(B55=\"Subtotal\",SUMIF($A$4:$A$500,A55,$I$4:$I$500)-I55,\"\")","v":""}]
[2003,7,24384,"DAR SR 705 11.02","Bridge Replacement","REPLACE A 27FT STRUCTURE OVER BRANCH OF MILE CREEK WITH MINIMAL APPROACH WORK. DESIGN/BUILD.",235092.44200000001,208670,235092.44200000001,{"$f":"IF(B56=\"Subtotal\",SUMIF($A$4:$A$500,A56,$I$4:$I$500)-I56,\"\")","v":""}]
[2003,8,21019,"BUT TR 175 0.51","Bridge Replacement","REPLACE TWO DEFICIENT STRUCTURES.  COUNTY DESIGN BUILD PROJECT.",1055632.047,989592.46,1055632.047,{"$f":"IF(B57=\"Subtotal\",SUMIF($A$4:$A$500,A57,$I$4:$I$500)-I57,\"\")","v":""}]
[2003,10,24446,"MEG CR0028 06.240","Bridge Replacement","BRIDGE REPLACEMENT PROJECT USING THE DESIGN/BUILD PROCESS. INCLUDES MEG- CR029-0268.",340903.10100000002,292900,340903.10100000002,{"$f":"IF(B58=\"Subtotal\",SUMIF($A$4:$A$500,A58,$I$4:$I$500)-I58,\"\")","v":""}]
[2003,11,20996,"TUS IR 77 7.55","Resurfacing, Divided System","4 LANE MAJ REHAB-RUBBLIZE &ROLL;SIGNING GUARDRAIL,REPAIR 5 BRIDGES.   SIGNING IN CLUDED 00.00-3.88SECTION",9197739.9220000003,8853710,9197739.9220000003,{"$f":"IF(B59=\"Subtotal\",SUMIF($A$4:$A$500,A59,$I$4:$I$500)-I59,\"\")","v":""}]
[2003,12,24356,"CUY SPAFFORD ROAD","Bridge Replacement","REPLACE THE SPAFFORD RD BRIDGE #23 OVER E.BRCH OF ROCKY RIVER IN BROOK PARK AND OLMSTED TWP LOCAL, NON-TRADITIONAL, DESIGN BUILD",873877.326,938585,873877.326,{"$f":"IF(B60=\"Subtotal\",SUMIF($A$4:$A$500,A60,$I$4:$I$500)-I60,\"\")","v":""}]
[2003,12,24364,"LAK RAVENNA ROAD /VARIOUS","Bridge Replacement","REPLACE BRIDGES: RAVENNA ROAD OVER KELLOG CREEK / CUNNINGHAM ROAD OVER ARCOLA CREEK / PINEHILL ROAD OVER ELLISON CREEK IN MADISON & CONCORD TOWNSHIPS. LOCAL, NON-TRADITIONAL, DESIGN-BUILD",1442295.6710000001,1367347.34,1442295.6710000001,{"$f":"IF(B61=\"Subtotal\",SUMIF($A$4:$A$500,A61,$I$4:$I$500)-I61,\"\")","v":""}]
[2003,"No. of Projects",{"$f":"SUBTOTAL(3,C39:C61)","v":23},null,null,null,null,null,0,{"$f":"IF(B62=\"Subtotal\",SUMIF($A$4:$A$500,A62,$I$4:$I$500)-I62,\"\")","v":""}]
[2003,"Subtotal","_",null,null,null,null,50050637.386999995,50050637.386999995,{"$f":"IF(B63=\"Subtotal\",SUMIF($A$4:$A$500,A63,$I$4:$I$500)-I63,\"\")","v":50050637.386999995}]
[2004,1,21607,"HAN SR 37 10.81","Bridge Repair","REHABILITATE EXISTING STRUCTURE OVER THE BLANCHARD RIVER BY REPLACING THE DECK,   BACKWALLS AND APPROACH SLABS.",492600.62400000001,480910,492600.62400000001,{"$f":"IF(B64=\"Subtotal\",SUMIF($A$4:$A$500,A64,$I$4:$I$500)-I64,\"\")","v":""}]
[2004,2,24102,"SEN SR 67 9.87","Resurfacing,  Undivided System","2-LANE RESURFACING WITH PAVEMENT REPAIRS  AS NEEDED (Cold in Place recycling); PERFORM NECESSARY RELATED WORK.",1795192.4609999999,1703351,1795192.4609999999,{"$f":"IF(B65=\"Subtotal\",SUMIF($A$4:$A$500,A65,$I$4:$I$500)-I65,\"\")","v":""}]
[2004,2,75172,"D02-SIGN-FY2004(A)","Signs","District wide sign upgrade; perform necessary related work",364319.76699999999,322850,364319.76699999999,{"$f":"IF(B66=\"Subtotal\",SUMIF($A$4:$A$500,A66,$I$4:$I$500)-I66,\"\")","v":""}]
[2004,6,75280,"FRA IR 270 20.03","Noise Wall","Construct noisewalls along both sides of I-270 to fulfill commitments made when I-270 was widened to four lanes in each direction.  Noise abatement for PIDs-12505, 12504, 12494, and 12495.",7891961.2400000002,7970600,7891961.2400000002,{"$f":"IF(B67=\"Subtotal\",SUMIF($A$4:$A$500,A67,$I$4:$I$500)-I67,\"\")","v":""}]
[2004,7,19670,"MOT SR 48 5.16","Bridge Replacement","REPLACE 21FT STRUCTURE OVER TRIBUTARY TO HOLES CREEK WITH MINIMAL APPROACH WORK. ELIMINATE GUARDRAIL. CLEAR SPAN = 19FT.",340560.01899999997,286480,340560.01899999997,{"$f":"IF(B68=\"Subtotal\",SUMIF($A$4:$A$500,A68,$I$4:$I$500)-I68,\"\")","v":""}]
[2004,11,19572,"D11 Sign FY2004A","Signs","REPLACE OR EPOXY SEAL OVERHEAD SIGN SUPPORT STRUCTURES IN  COL, HAS, JEF AND TUS COUNTIESUpgrade existing signs including all interchanges and intersections on Has-22 and Jef-22 locations.  Includes Hopedale.",591897.09299999999,510130,{"$f":"IF(G69=\"\",H69,G69)","v":591897.09299999999},{"$f":"IF(B69=\"Subtotal\",SUMIF($A$4:$A$500,A69,$I$4:$I$500)-I69,\"\")","v":""}]
[2004,11,19575,"D11 Sign FY2004 B","Signs","UPGRADE EXISTING SIGNS INCLUDING ALL INTERCHANGES ON IR 470",570522.57799999998,514942,570522.57799999998,{"$f":"IF(B70=\"Subtotal\",SUMIF($A$4:$A$500,A70,$I$4:$I$500)-I70,\"\")","v":""}]
[2004,"No. of Projects",{"$f":"SUBTOTAL(3,C64:C70)","v":7},null,null,null,null,null,0,{"$f":"IF(B71=\"Subtotal\",SUMIF($A$4:$A$500,A71,$I$4:$I$500)-I71,\"\")","v":""}]
[2004,"Subtotal","_",null,null,null,null,12047053.782,12047053.782,{"$f":"IF(B72=\"Subtotal\",SUMIF($A$4:$A$500,A72,$I$4:$I$500)-I72,\"\")","v":12047053.782}]
[2005,6,75279,"FRA/DEL IR 71 25.36/1.16","Noise Wall","Construct noise walls along both sides of I-71 to fulfill environmental commitments when I-71 was widened (under PID-7278).",9338893.4110000003,8843450,9338893.4110000003,{"$f":"IF(B73=\"Subtotal\",SUMIF($A$4:$A$500,A73,$I$4:$I$500)-I73,\"\")","v":""}]
[2005,6,76564,"FAY SR 41 22.18","Bridge Repair","REPLACE DECK WITH A WIDER (THREE LANE) DECK AND APPROACH WORK FOR FUTURE WIDENING OF SR 41. DESIGN/BUILD PROJECT.",2323913.5660000001,2300761,2323913.5660000001,{"$f":"IF(B74=\"Subtotal\",SUMIF($A$4:$A$500,A74,$I$4:$I$500)-I74,\"\")","v":""}]
[2005,7,25295,"MER SR 117 9.31","Bridge Replacement","REPLACE TWO BRIDGES.  DESIGN BUILD PROJECT.",440897.71299999999,403929.8,440897.71299999999,{"$f":"IF(B75=\"Subtotal\",SUMIF($A$4:$A$500,A75,$I$4:$I$500)-I75,\"\")","v":""}]
[2005,10,76160,"WAS IR 77 6.59","Major Rehabilitation","Four-lane major rehabilitation project.  WAS IR 77 6.59-17.59 and NOB IR 77 0.00-1.56.  Includes WAS IR 77 11.53 LT and WAS IR 77 12.08 RT bridges.  PID's now combined with this job are: 76239 (WAS 77 10.90 and NOB 77 0.13 Landslide locations) and 21857 (",21855150.756000001,20279824,21855150.756000001,{"$f":"IF(B76=\"Subtotal\",SUMIF($A$4:$A$500,A76,$I$4:$I$500)-I76,\"\")","v":""}]
[2005,"No. of Projects",{"$f":"SUBTOTAL(3,C73:C76)","v":4},null,null,null,null,null,0,{"$f":"IF(B77=\"Subtotal\",SUMIF($A$4:$A$500,A77,$I$4:$I$500)-I77,\"\")","v":""}]
[2005,"Subtotal","_",null,null,null,null,33958855.446000002,33958855.446000002,{"$f":"IF(B78=\"Subtotal\",SUMIF($A$4:$A$500,A78,$I$4:$I$500)-I78,\"\")","v":33958855.446000002}]
[2006,4,23703,"STA US 0062 08.32","Bridge Repair","REDECK AND PAINTING OF ONE STRUCTURE.Design/Build.",906007.17099999997,826506.54,906007.17099999997,{"$f":"IF(B79=\"Subtotal\",SUMIF($A$4:$A$500,A79,$I$4:$I$500)-I79,\"\")","v":""}]
[2006,4,25072,"STA SR 0225 00.76","Bridge Repair","REPLACEMENT OF EXISTING DECK.",657647.28099999996,579280,657647.28099999996,{"$f":"IF(B80=\"Subtotal\",SUMIF($A$4:$A$500,A80,$I$4:$I$500)-I80,\"\")","v":""}]
[2006,8,25499,"HAM SR 562 0.00","Resurfacing, Divided System","REHABILITATE SR 562.",5923664.1749999998,5768190,5923664.1749999998,{"$f":"IF(B81=\"Subtotal\",SUMIF($A$4:$A$500,A81,$I$4:$I$500)-I81,\"\")","v":""}]
[2006,9,76169,"SCI CR 15 0.12 Dixon Mill Road","Bridge Replacement","Replace existing deficient bridge on Dixon Mill ROad over the Little Scioto River, Scioto County Road 15. This project is a Design Build project per the Scioto County Engineer.",1583075.581,1365475.03,1583075.581,{"$f":"IF(B82=\"Subtotal\",SUMIF($A$4:$A$500,A82,$I$4:$I$500)-I82,\"\")","v":""}]
[2006,"No. of Projects",{"$f":"SUBTOTAL(3,C79:C82)","v":4},null,null,null,null,null,0,{"$f":"IF(B83=\"Subtotal\",SUMIF($A$4:$A$500,A83,$I$4:$I$500)-I83,\"\")","v":""}]
[2006,"Subtotal","_",null,null,null,null,9070394.2080000006,9070394.2080000006,{"$f":"IF(B84=\"Subtotal\",SUMIF($A$4:$A$500,A84,$I$4:$I$500)-I84,\"\")","v":9070394.2080000006}]
[2007,9,76170,"SCI CR 48 2.85 Arion Road Brdg","Bridge Replacement","Replace existing deficient one lane bridge on Arion Road over Scioto Brush Creek. Scioto County Road 48.",1633720.93,1687500,1633720.93,{"$f":"IF(B85=\"Subtotal\",SUMIF($A$4:$A$500,A85,$I$4:$I$500)-I85,\"\")","v":""}]
[2007,12,79599,"CUY IR 071 11.88 NOISE WALL","Noise Wall","Construct noise walls.",6408455.5039999997,6255500,6408455.5039999997,{"$f":"IF(B86=\"Subtotal\",SUMIF($A$4:$A$500,A86,$I$4:$I$500)-I86,\"\")","v":""}]
[2007,"No. of Projects",{"$f":"SUBTOTAL(3,C85:C86)","v":2},null,null,null,null,null,0,{"$f":"IF(B87=\"Subtotal\",SUMIF($A$4:$A$500,A87,$I$4:$I$500)-I87,\"\")","v":""}]
[2007,"Subtotal","_",null,null,null,null,8042176.4339999994,8042176.4339999994,{"$f":"IF(B88=\"Subtotal\",SUMIF($A$4:$A$500,A88,$I$4:$I$500)-I88,\"\")","v":8042176.4339999994}]
[2008,3,20375,"CRA SR 0602 06.00","Bridge Repair","NEW DECK, CHANGE TO SEMI-INTREGAL ABUT INCL NEW APPROACH SLAB",664856.42299999995,629850,664856.42299999995,{"$f":"IF(B89=\"Subtotal\",SUMIF($A$4:$A$500,A89,$I$4:$I$500)-I89,\"\")","v":""}]
[2008,4,23753,"STA SR 0021 08.98","Bridge Repair","REDECK with Widening AND PAINTING OF ONE STRUCTURE IN STARK COUNTY ON SR 21.",2030063.8060000001,1776526.5,2030063.8060000001,{"$f":"IF(B90=\"Subtotal\",SUMIF($A$4:$A$500,A90,$I$4:$I$500)-I90,\"\")","v":""}]
[2008,6,81281,"FRA IR 71 19.09","Noise Wall","Provide noise barrier walls along I-71 at various locations as warranted.  Preliminary studies and public involvement will be performed under an OES task order contract.  Construction will be under a design/build contract.",4435007.7520000003,4209700,4435007.7520000003,{"$f":"IF(B91=\"Subtotal\",SUMIF($A$4:$A$500,A91,$I$4:$I$500)-I91,\"\")","v":""}]
[2008,6,81547,"UNI CR 307 4.89","Bridge Replacement","STRUCTURE REPLACEMENT WITH APPROACH ROADWAY IMPROVEMENTS.LOCAL-LET PROJECT SOLD/ADMINISTERED BY UNI COUNTY ENGINEER.",534594.33100000001,539921.25,534594.33100000001,{"$f":"IF(B92=\"Subtotal\",SUMIF($A$4:$A$500,A92,$I$4:$I$500)-I92,\"\")","v":""}]
[2008,8,75633,"CLE SR 32 13.14","Bridge Repair","Bridge rehabilitation project of twin mainline SR 32 bridges over SR 276.  Bridge Nos. CLE-32-1314 L/R, SFNs:  1300458/1300466, will receive new reinforced concrete decks; have the structural steel painted; and will receive other minor bridge work.  Desig",1762403.682,1726450,1762403.682,{"$f":"IF(B93=\"Subtotal\",SUMIF($A$4:$A$500,A93,$I$4:$I$500)-I93,\"\")","v":""}]
[2008,"No. of Projects",{"$f":"SUBTOTAL(3,C89:C93)","v":5},null,null,null,null,null,0,{"$f":"IF(B94=\"Subtotal\",SUMIF($A$4:$A$500,A94,$I$4:$I$500)-I94,\"\")","v":""}]
[2008,"Subtotal","_",null,null,null,null,9426925.9940000009,9426925.9940000009,{"$f":"IF(B95=\"Subtotal\",SUMIF($A$4:$A$500,A95,$I$4:$I$500)-I95,\"\")","v":9426925.9940000009}]
[2009,1,81299,"HAN CR 26-17.59","Bridge Replacement","REMOVE AND REPLACE EXISTING STRUCTURALLY DEFICIENT BRIDGE OVER THE BLANCHARD RIVER.",829222.28700000001,843035,829222.28700000001,{"$f":"IF(B96=\"Subtotal\",SUMIF($A$4:$A$500,A96,$I$4:$I$500)-I96,\"\")","v":""}]
[2009,4,25277,"SUM IR 0077 30.96","Bridge Repair","Re-deck and paint of 8 structures.",10971100.426000001,10651703.67,10971100.426000001,{"$f":"IF(B97=\"Subtotal\",SUMIF($A$4:$A$500,A97,$I$4:$I$500)-I97,\"\")","v":""}]
[2009,6,81548,"UNI CR 310 0.70","Bridge Replacement","STRUCTURE REPLACEMENT WITH APPROACH ROADWAY IMPROVEMENTS.LOCAL-LET DESIGN/BUILD PROJECT SOLD/ADMINISTERED BY UNI COUNTY ENGINEER.",548449.91899999999,523111.6,548449.91899999999,{"$f":"IF(B98=\"Subtotal\",SUMIF($A$4:$A$500,A98,$I$4:$I$500)-I98,\"\")","v":""}]
[2009,8,23302,"HAM IR 275 7.02","Slide Repair","CONSTRUCT EARTHWORK BENCH AND COUNTER BERM TO STABILIZE THE LANDSLIDE ALONG EB IR275 RAMP TO EB IR74.PID 79999 combined for Construction. Installation of drainage tile to dewater landslide area at 0.59 miles south of IR74.",1261014.7290000001,1164020,1261014.7290000001,{"$f":"IF(B99=\"Subtotal\",SUMIF($A$4:$A$500,A99,$I$4:$I$500)-I99,\"\")","v":""}]
[2009,11,80922,"BEL IR 70 0.000","Signs","Upgrade existing signing along IR 70 and the signing at the interchanges in the project area.",459783.527,426420,459783.527,{"$f":"IF(B100=\"Subtotal\",SUMIF($A$4:$A$500,A100,$I$4:$I$500)-I100,\"\")","v":""}]
[2009,"No. of Projects",{"$f":"SUBTOTAL(3,C96:C100)","v":5},null,null,null,null,null,0,{"$f":"IF(B101=\"Subtotal\",SUMIF($A$4:$A$500,A101,$I$4:$I$500)-I101,\"\")","v":""}]
[2009,"Subtotal","_",null,null,null,null,14069570.888000002,14069570.888000002,{"$f":"IF(B102=\"Subtotal\",SUMIF($A$4:$A$500,A102,$I$4:$I$500)-I102,\"\")","v":14069570.888000002}]
[2010,1,82163,"HAN IR 75 22.12","Bridge Replacement","Replace CR 109 bridge over Interstate 75.  DESIGN/BUILD.",1734162.0930000001,1621090,1734162.0930000001,{"$f":"IF(B103=\"Subtotal\",SUMIF($A$4:$A$500,A103,$I$4:$I$500)-I103,\"\")","v":""}]
[2010,1,82330,"HAN CR 169-0.83","Bridge Replacement","REPLACE BRIDGE ON HAN CR 169-0.83 over Blanchard River (Design Build)",700376.16299999994,708355,700376.16299999994,{"$f":"IF(B104=\"Subtotal\",SUMIF($A$4:$A$500,A104,$I$4:$I$500)-I104,\"\")","v":""}]
[2010,2,86328,"OTT TR 54 (Billman Rd) Brdg ARRA","Bridge Repair","An ARRA funded project to rehabilitate  the steel truss bridge on Billman Rd (TR 54) over Cedar Creek; perform necessary related work.",289480.10100000002,292365,289480.10100000002,{"$f":"IF(B105=\"Subtotal\",SUMIF($A$4:$A$500,A105,$I$4:$I$500)-I105,\"\")","v":""}]
[2010,3,80196,"LOR SR 0058 09.83","Bridge Deck Replacement","Replace the Deck of LOR-058-09.83 over the West Branch of the Black Rivercoordinate with PID:82773 LOR SR 0058 08.34 - Resurfacing",717748.06200000003,674850,717748.06200000003,{"$f":"IF(B106=\"Subtotal\",SUMIF($A$4:$A$500,A106,$I$4:$I$500)-I106,\"\")","v":""}]
[2010,3,83445,"HUR US 0224 08.55","Bridge Replacement","Bridge Replacement",1006644.38,951500,1006644.38,{"$f":"IF(B107=\"Subtotal\",SUMIF($A$4:$A$500,A107,$I$4:$I$500)-I107,\"\")","v":""}]
[2010,3,83446,"LOR SR 0058 25.34","Bridge Repair","Bridge Rehabilitation(Design by Burgess & Niple under D/B contract with Perk Company)",497813.283,444580,497813.283,{"$f":"IF(B108=\"Subtotal\",SUMIF($A$4:$A$500,A108,$I$4:$I$500)-I108,\"\")","v":""}]
[2010,3,84604,"WAY US 0042 00.60","Bridge Replacement","Bridge Replacement",757359.26,686590,757359.26,{"$f":"IF(B109=\"Subtotal\",SUMIF($A$4:$A$500,A109,$I$4:$I$500)-I109,\"\")","v":""}]
[2010,3,86254,"LOR SR 0057 12.54","Bridge Deck Replacement","Repair twin structures LOR-057-12.54 L&R over branch of Black RiverBridge Deck ReplacementsPID:18982 previously awarded and then terminated",1390405.426,1344310,1390405.426,{"$f":"IF(B110=\"Subtotal\",SUMIF($A$4:$A$500,A110,$I$4:$I$500)-I110,\"\")","v":""}]
[2010,4,25223,"TRU SR 0011 07.69","Bridge Repair","REMOVE AND REPLACE EXISTING DECK OF TWO STRUCTURES, TRU-SR11-0959L & TRU-SR11- 0959R. Redeck of TRU-11-9.28. Replacement of TRU-11-19.52.Minor rehabilitation from SLM 7.69 to King Graves interchange.",13985579.497,13097559.18,13985579.497,{"$f":"IF(B111=\"Subtotal\",SUMIF($A$4:$A$500,A111,$I$4:$I$500)-I111,\"\")","v":""}]
[2010,6,85039,"UNI 2009 HISTORIC BRIDGE PRESERV","Bridge Maintenance","INSTALLATION OF LIGHTING SYSTEMS AND HEAT DETECTION SYSTEMS ON FOUR HISTORIC COVERED BRIDGES IN UNION COUNTY. POTTERSBURG COVERED BRIDGE ON NORTH LEWISBURG MULTI PURPOSE TRAIL; SPAIN CREEK COVERED BRIDGE ON CR163 (INSKEEP-CRATTY ROAD) OVER SPAIN CREEK; CU",266187.59700000001,265640,266187.59700000001,{"$f":"IF(B112=\"Subtotal\",SUMIF($A$4:$A$500,A112,$I$4:$I$500)-I112,\"\")","v":""}]
[2010,6,85537,"FRA IR 71 19.09 (Phase 2)","Noise Wall","Provide noise barrier walls along I-71 at various locations as waranted.  Design/build contract.",5247566.085,4621550,5247566.085,{"$f":"IF(B113=\"Subtotal\",SUMIF($A$4:$A$500,A113,$I$4:$I$500)-I113,\"\")","v":""}]
[2010,6,86359,"MAD CR 12 (Old Xenia Rd)","Bridge Replacement","Replace bridge on MAD CR 12 (Old Xenia Rd) on Woolsey Ditch/Paint Creek.",389587.984,355337.5,389587.984,{"$f":"IF(B114=\"Subtotal\",SUMIF($A$4:$A$500,A114,$I$4:$I$500)-I114,\"\")","v":""}]
[2010,6,86459,"DEL CR 24 5.020","Bridge Deck Replacement","Replace deck and superstructure members.Modify or replace bridge abutments.Possible piers work, minor roadway approach work, guardrail replacement.MORPC Stimulus funded project - cap amount of $1,500,000.",718568.19,767656.33,718568.19,{"$f":"IF(B115=\"Subtotal\",SUMIF($A$4:$A$500,A115,$I$4:$I$500)-I115,\"\")","v":""}]
[2010,8,84497,"HAM IR 75 10.09","Minor Rehabilitation - Pavement Prmy Sys","Resurface and perform pavement repair on I-75 from south of SR 126 to south of the Lockland Corp. Project includes several minor bridge rehabilitations.",7018498.1610000003,6964179.7699999996,7018498.1610000003,{"$f":"IF(B116=\"Subtotal\",SUMIF($A$4:$A$500,A116,$I$4:$I$500)-I116,\"\")","v":""}]
[2010,9,85830,"LAW S.P. INTERMODAL ROADWAY","Inter-modal Facility","It is proposed to improve access roads that would allow for better access and handling between river barges, rail, and highway freight.    Note: Split to PID 86717 \"LAW S.P. INTERMODAL RAIL\"",1132713.1780000001,1461028.62,1132713.1780000001,{"$f":"IF(B117=\"Subtotal\",SUMIF($A$4:$A$500,A117,$I$4:$I$500)-I117,\"\")","v":""}]
[2010,9,86717,"LAW S.P. Intermodal Rail","Inter-modal Facility","It is proposed to construct rail lines and a concrete transfer pad to facilitate cargo transfer from rail to highway. Note: Split from PID 85830 \"LAW S.P. INTERMODAL ROADWAY\"",2501989.1469999999,2452617.38,2501989.1469999999,{"$f":"IF(B118=\"Subtotal\",SUMIF($A$4:$A$500,A118,$I$4:$I$500)-I118,\"\")","v":""}]
[2010,11,76825,"BEL IR 70 7.61","Major Reconstruction","UBCO on existing mainline and ramps, full depth removal and rigid replacement at overhead bridges, reconstruct median and median drainage, replace guardrail and signs, rehabilitation of 4 bridges, reconstruction of passenger car parking are in EB rest are",25534892.589000002,25055850,25534892.589000002,{"$f":"IF(B119=\"Subtotal\",SUMIF($A$4:$A$500,A119,$I$4:$I$500)-I119,\"\")","v":""}]
[2010,11,78478,"COL US0030/SR0011 25.09/10.82","Signs","Upgrade all existing signing along US 30 & SR 11 including the signing at the interchanges",779020.22100000002,721880,779020.22100000002,{"$f":"IF(B120=\"Subtotal\",SUMIF($A$4:$A$500,A120,$I$4:$I$500)-I120,\"\")","v":""}]
[2010,11,81587,"HAS US 250 11.720","Major Rehabilitation","Major rehabilitation of existing pavement with unbonded concrete overlay - Major 2 funding; ADDED BY CHANGE ORDER: FHWA OH11-02 flood site; DSR HAS-002: Embankment Failure/ Two Slides - 250ft. Landslide above SR250. The crown of slide is located  near old",4701505.7560000001,4635638,4701505.7560000001,{"$f":"IF(B121=\"Subtotal\",SUMIF($A$4:$A$500,A121,$I$4:$I$500)-I121,\"\")","v":""}]
[2010,11,86367,"JEF SR 43 0.00","Major Rehabilitation","Concrete pavement replacement, spot roadway base repair, curb repair and replacement, catch basin replacements, guardrail replacement, street lighting replacement, retaining wall repair, signing and pavement marking replacement.  ARRA ODOT Tracking ID is",7715848.3020000001,7830667.0899999999,7715848.3020000001,{"$f":"IF(B122=\"Subtotal\",SUMIF($A$4:$A$500,A122,$I$4:$I$500)-I122,\"\")","v":""}]
[2010,11,87863,"BEL Shadyside - salt storage","Buildings - Mix Shed,etc.","construction of 500 ton salt storage - tensioned Fabric structure",147721.04699999999,149190,147721.04699999999,{"$f":"IF(B123=\"Subtotal\",SUMIF($A$4:$A$500,A123,$I$4:$I$500)-I123,\"\")","v":""}]
[2010,11,87864,"JEF Dillonvale - salt storage","Buildings - Mix Shed,etc.","construction of 1000 ton salt storage - Tensioned Fabric Structure",213363.95300000001,215490,213363.95300000001,{"$f":"IF(B124=\"Subtotal\",SUMIF($A$4:$A$500,A124,$I$4:$I$500)-I124,\"\")","v":""}]
[2010,11,87879,"JEF SR 7 1.660","Bridge Repair","Remove existing MSC overlay and replace with new MSC overlay (including approach slabs) and perform some full-depth repairs to the deck.",796287.86699999997,804220,796287.86699999997,{"$f":"IF(B125=\"Subtotal\",SUMIF($A$4:$A$500,A125,$I$4:$I$500)-I125,\"\")","v":""}]
[2010,12,87632,"CUY IR 077 00.38/VAR","Bridge Deck Replacement","Bridge Deck:  Replace the bridge decks over I-77 at Snowville Road, Highland Drive, Valley Parkway, and Oakes Road in Brecksville.  Valley Parkway moved to PID 91820.",4143850.3640000001,3782540,4143850.3640000001,{"$f":"IF(B126=\"Subtotal\",SUMIF($A$4:$A$500,A126,$I$4:$I$500)-I126,\"\")","v":""}]
[2010,12,87633,"CUY IR 077 03.45/VAR","Bridge Deck Replacement","Bridge Deck:  Replace the bridge decks over I-77 at Harris Road, Lacey Lane, and Chestnut Road in the Cities of Independence and Broadview Heights.",2810196.0469999998,2527440,2810196.0469999998,{"$f":"IF(B127=\"Subtotal\",SUMIF($A$4:$A$500,A127,$I$4:$I$500)-I127,\"\")","v":""}]
[2010,"No. of Projects",{"$f":"SUBTOTAL(3,C103:C127)","v":25},null,null,null,null,null,0,{"$f":"IF(B128=\"Subtotal\",SUMIF($A$4:$A$500,A128,$I$4:$I$500)-I128,\"\")","v":""}]
[2010,"Subtotal","_",null,null,null,null,85197364.753000006,85197364.753000006,{"$f":"IF(B129=\"Subtotal\",SUMIF($A$4:$A$500,A129,$I$4:$I$500)-I129,\"\")","v":85197364.753000006}]
[2011,1,84564,"ALL SR 81 4.89","Bridge Deck Replacement","REPLACE THE CONCRETE BRIDGE DECK ON THE BRIDGE OVER THE AUGLAIZE RIVER",717813.95499999996,654790,717813.95499999996,{"$f":"IF(B130=\"Subtotal\",SUMIF($A$4:$A$500,A130,$I$4:$I$500)-I130,\"\")","v":""}]
[2011,2,76710,"SAN US 20 03.77 Rehab","Minor Rehabilitation - Pavement Prmy Sys","A district funded project to rehabilitate SAN-20 from east of Woodville east corp line to a butt joint west of TR138; perform necessary related work. See PID 85241 for WB resurf. Update: Central office pavement visited the project site. New treatment reco",13313963.521,12908730,13313963.521,{"$f":"IF(B131=\"Subtotal\",SUMIF($A$4:$A$500,A131,$I$4:$I$500)-I131,\"\")","v":""}]
[2011,3,87315,"MED Mud Lake Rd Replace Bridge","Bridge Replacement","MED Mud Lake Rd Bridge Replacement (SFN #5238714) - Split from PID 85697.",1711437.5689999999,1642355.49,1711437.5689999999,{"$f":"IF(B132=\"Subtotal\",SUMIF($A$4:$A$500,A132,$I$4:$I$500)-I132,\"\")","v":""}]
[2011,3,88375,"D3 ERI/HUR Salt Storage Building","Salt Dome","Design Build contract for Salt Storage structure at Erie and Huron County Garages.Design Build-will contain PE and CO Phase funding eventsD3 Building Superintendent: Richard Feldkamp",762403.10100000002,700000,{"$f":"IF(G133=\"\",H133,G133)","v":762403.10100000002},{"$f":"IF(B133=\"Subtotal\",SUMIF($A$4:$A$500,A133,$I$4:$I$500)-I133,\"\")","v":""}]
[2011,3,88662,"WAY SR 0003 24.25","Culvert Construction/Reconstr/Repair","Culvert Replacement WAY-003-24.25 +/-",161111.579,136870,161111.579,{"$f":"IF(B134=\"Subtotal\",SUMIF($A$4:$A$500,A134,$I$4:$I$500)-I134,\"\")","v":""}]
[2011,4,25501,"ATB SR 0011 13.30","Minor Rehabilitation - Pavement Prmy Sys","PAVEMENT REPAIR AND BRIDGE WORK",11701964,11360330.949999999,11701964,{"$f":"IF(B135=\"Subtotal\",SUMIF($A$4:$A$500,A135,$I$4:$I$500)-I135,\"\")","v":""}]
[2011,4,84631,"TRU US 0422 19.94","Bridge Replacement","Superstructure replacement.",851713.17799999996,850842.4,851713.17799999996,{"$f":"IF(B136=\"Subtotal\",SUMIF($A$4:$A$500,A136,$I$4:$I$500)-I136,\"\")","v":""}]
[2011,4,86995,"ATB 90/45 (2.33)(7.43)/19.89","Bridge Deck Replacement","Bridge re-deck. Second structure at SLM ATB-90-7.43. Sealing sfn#0402591 at ATB-45-19.89.",1173311.1429999999,1180300,1173311.1429999999,{"$f":"IF(B137=\"Subtotal\",SUMIF($A$4:$A$500,A137,$I$4:$I$500)-I137,\"\")","v":""}]
[2011,4,87318,"POR-Rock Spring/Knapp Rds Brdgs","Bridge Replacement","POR Rock Springs Rd Replace Bridge (SFN #6730809)- Split from PID 85697.   SEE PID 80658 $700,000 replacement of same bridge (SFN 6730809).  Added POR Knapp Rd Replace Bridge, PID 87317 (SFN #6741150) as of 01/20/2010.",5645671.0060000001,5483569.8200000003,5645671.0060000001,{"$f":"IF(B138=\"Subtotal\",SUMIF($A$4:$A$500,A138,$I$4:$I$500)-I138,\"\")","v":""}]
[2011,4,87319,"TRU 5th Street Replace Bridge","Bridge Replacement","TRU 5th Street Replace Bridge replacement - Split from PID 85697.",1928999.6510000001,1911110,1928999.6510000001,{"$f":"IF(B139=\"Subtotal\",SUMIF($A$4:$A$500,A139,$I$4:$I$500)-I139,\"\")","v":""}]
[2011,4,87966,"POR IR 0076 (17.59)(19.61)","Bridge Repair","Superstructure replacements.",1910364.341,1901000,1910364.341,{"$f":"IF(B140=\"Subtotal\",SUMIF($A$4:$A$500,A140,$I$4:$I$500)-I140,\"\")","v":""}]
[2011,6,77369,"FRA IR 71 17.760 (Pjt 1)","Major Reconstruction","FIRST CONSTRUCTION PROJECT RESULTING FROM MAJOR INVESTMENT/PRELIMINARY ENGINEERING STUDY (PID 23318).Reconstruction of the 670/71 Interchange. Work involves realignment of I-670 EB so through traffic stays to the left and traffic to I-71 exits to the righ",218210658.91499999,255190121,218210658.91499999,{"$f":"IF(B141=\"Subtotal\",SUMIF($A$4:$A$500,A141,$I$4:$I$500)-I141,\"\")","v":""}]
[2011,6,82358,"UNI TR 279 1.04","Bridge Replacement","CEAO FUNDED BRIDGE REPLACEMENT PROJECT.UNI-TR279-1.04 (SNEDIKER ROAD) OVER FULTON CREEK. CLAIBOURNE TOWNSHIP.PROJECT TO BE SOLD AS DESIGN/BUILD BY UNION COUNTY ENGINEER.",664053.10100000002,670670,664053.10100000002,{"$f":"IF(B142=\"Subtotal\",SUMIF($A$4:$A$500,A142,$I$4:$I$500)-I142,\"\")","v":""}]
[2011,6,85950,"D06 ExtruSign FY11A","Signing","Extru sign replacement for improved reflectivity for safety.  Limits include I-270 and lead-in signs.Upgrade existing ground and overhead mounted extrusheet signs on mainline and ramps.Upgrade extrusheet signs on side street approaches to interchanges tha",5220095.6119999997,5037260,5220095.6119999997,{"$f":"IF(B143=\"Subtotal\",SUMIF($A$4:$A$500,A143,$I$4:$I$500)-I143,\"\")","v":""}]
[2011,8,83047,"Pre TR259/329 Des Build Br Rep","Bridge Replacement","Junction Road (TR 259) Replace S.D. steel truss bridge Ketterman Road (TR 329) Replace S.D. bridge with minimal approach work",828514.34100000001,836770,828514.34100000001,{"$f":"IF(B144=\"Subtotal\",SUMIF($A$4:$A$500,A144,$I$4:$I$500)-I144,\"\")","v":""}]
[2011,8,85364,"GRE IR 675 3.10","Noise Wall Maintenance/Repair (NEW)","Replace existing noise wall panels on existing noise wall, investigate salvaging existing steel posts, replace steel posts where warranted.(Design Build Project)",2057399.2250000001,2053150,2057399.2250000001,{"$f":"IF(B145=\"Subtotal\",SUMIF($A$4:$A$500,A145,$I$4:$I$500)-I145,\"\")","v":""}]
[2011,9,79855,"ADA US 52 1.10 Brdg Replace","Bridge Replacement","It is proposed to replace bridge number 0101621.",1460197.9839999999,1355400,1460197.9839999999,{"$f":"IF(B146=\"Subtotal\",SUMIF($A$4:$A$500,A146,$I$4:$I$500)-I146,\"\")","v":""}]
[2011,11,84323,"COL SR 7 0.00","Signs","Upgrading the existing signing along SR 7 in Columbiana and Jefferson county and US 36 and US 250 in Tuscarawas county.",1324784.3019999999,1274620,1324784.3019999999,{"$f":"IF(B147=\"Subtotal\",SUMIF($A$4:$A$500,A147,$I$4:$I$500)-I147,\"\")","v":""}]
[2011,12,85531,"CUY IR 090 14.90 WB Design Build","New Bridge","Design Build ContractOther Consultant Contracts: DBE Outreach(Dec 7 2009), Project Controls-Scheduling(Apr 12 2010), Project Controls-Reporting, Document Management, etc.(Apr 12 2010), Construction Inspection (2)(Fall 2010), Material Testing (2) (Fall 201",313020930.23299998,314401840.80000001,313020930.23299998,{"$f":"IF(B148=\"Subtotal\",SUMIF($A$4:$A$500,A148,$I$4:$I$500)-I148,\"\")","v":""}]
[2011,"No. of Projects",{"$f":"SUBTOTAL(3,C130:C148)","v":19},null,null,null,null,null,0,{"$f":"IF(B149=\"Subtotal\",SUMIF($A$4:$A$500,A149,$I$4:$I$500)-I149,\"\")","v":""}]
[2011,"Subtotal","_",null,null,null,null,582665386.75699997,582665386.75699997,{"$f":"IF(B150=\"Subtotal\",SUMIF($A$4:$A$500,A150,$I$4:$I$500)-I150,\"\")","v":582665386.75699997}]
[2012,2,84319,"OTT Ferry Terminal Building","Dock Facilities","A ferry boat discretionary (FBD) funded project to utilize and showcase solar technology at the Port Clinton and Put-in-Bay terminal buildings.  The terminal buildings will receive new roofing and solar technology will be incorporated with either solar pa",374918.26,365231,374918.26,{"$f":"IF(B151=\"Subtotal\",SUMIF($A$4:$A$500,A151,$I$4:$I$500)-I151,\"\")","v":""}]
[2012,2,89226,"SEN/WIL Vestibule Additions","Facility Renovation","A lands & building funded project to remove and re-install of the entrance door so as to open outward.  A new wall and door will be added within the vastibule in a similar format; perform necessary related work. UPDATE (3-8-11): project includes PID 89227",103468.992,104500,103468.992,{"$f":"IF(B152=\"Subtotal\",SUMIF($A$4:$A$500,A152,$I$4:$I$500)-I152,\"\")","v":""}]
[2012,3,82255,"LOR SR 0002 SYSSIGN FY2012","Signs","Systematic Sign ReplacementLOR-002-03.50 - 11.14 / LOR-090-10.78 - 23.33exclude signs associated with Avon Interchange PID:83607I-90 was previously programmed as PID:82256",1043865.988,1007260,1043865.988,{"$f":"IF(B153=\"Subtotal\",SUMIF($A$4:$A$500,A153,$I$4:$I$500)-I153,\"\")","v":""}]
[2012,4,76295,"ATB SR 0011 23.85","Bridge Repair","Miscellaneous bridge work to six structures.",4192732.3840000001,4130379.82,4192732.3840000001,{"$f":"IF(B154=\"Subtotal\",SUMIF($A$4:$A$500,A154,$I$4:$I$500)-I154,\"\")","v":""}]
[2012,4,76403,"SUM IR 0077 24.29","Bridge Deck Replacement","Seven Bridge re-decks. Miscellaneous bridge work.",7528050.4479999999,6813755,7528050.4479999999,{"$f":"IF(B155=\"Subtotal\",SUMIF($A$4:$A$500,A155,$I$4:$I$500)-I155,\"\")","v":""}]
[2012,4,91094,"POR IR 0076 (3.93)(4.74)","Bridge Deck Replacement","Re-deck and painting of two structures.",2023635.659,1863992.65,2023635.659,{"$f":"IF(B156=\"Subtotal\",SUMIF($A$4:$A$500,A156,$I$4:$I$500)-I156,\"\")","v":""}]
[2012,6,82359,"UNI CR 338 0.39","Bridge Replacement","CEAO FUNDED BRIDGE REPLACEMENT PROJECT.UNI-CR338-0.39 (COBB-HARRIMAN ROAD) OVER RUSH CREEK (JACKSON TOWNSHIP).DESIGN/BUILD PROJECT.",964007.53099999996,922412,964007.53099999996,{"$f":"IF(B157=\"Subtotal\",SUMIF($A$4:$A$500,A157,$I$4:$I$500)-I157,\"\")","v":""}]
[2012,6,86916,"MRW IR 71 12.190","Major Widening","Full depth pavement replacement with addition of third median lane in each direction.Multi-lane Reconstruction funding.  Pvmt work - 19% NH and 81% IM approved by S Lowry via e-mail dated 11/4/10.Env phase also for PID's 86920   & 86921D6 Environmental Co",45784459.446000002,44205370,45784459.446000002,{"$f":"IF(B158=\"Subtotal\",SUMIF($A$4:$A$500,A158,$I$4:$I$500)-I158,\"\")","v":""}]
[2012,6,86921,"DEL IR 71 11.500","Major Widening","Full depth pavement replacement and addition of 3rd median lane.Replace and widen ML Bridge MRW-71-3.00Env on PID 86916Consultant Project Manager - Jim Prevost",54157286.836999997,53244740,54157286.836999997,{"$f":"IF(B159=\"Subtotal\",SUMIF($A$4:$A$500,A159,$I$4:$I$500)-I159,\"\")","v":""}]
[2012,6,87948,"FRA Various Noisewall Repair","Noise Wall","Repair damaged noisewalls along IR 71, IR 270, IR 670, and SR 315 in Franklin CountySR-315:  SLM 5.18-6.17 (Ackerman Rd to Olentangy River Rd)IR-670:  SLM 7.15-7.56 (US-62 to US-62/Fifth Ave)IR-71:  SLM 18.75-19.09 (E Second Ave to 5th Ave)IR-71:  SLM 24.",281000,271150,281000,{"$f":"IF(B160=\"Subtotal\",SUMIF($A$4:$A$500,A160,$I$4:$I$500)-I160,\"\")","v":""}]
[2012,8,84444,"HAM SR 562 0004L","Bridge Deck Replacement","Rehabilitate Bridge HAM-562-0.04L by replacing the concrete deck and including other related rehabilitation work.Design Build project.",800490.58100000001,719370,800490.58100000001,{"$f":"IF(B161=\"Subtotal\",SUMIF($A$4:$A$500,A161,$I$4:$I$500)-I161,\"\")","v":""}]
[2012,8,87172,"CLI US 68 14.39","Bridge Replacement","Replace bridge CLI-68-1443 (SFN 1401173) over Lytle Creek in the City of Wilmington.",1096654.7790000001,901550,1096654.7790000001,{"$f":"IF(B162=\"Subtotal\",SUMIF($A$4:$A$500,A162,$I$4:$I$500)-I162,\"\")","v":""}]
[2012,11,84331,"BEL SR 7 6.110","Signs","Upgrading existing sigining along SR 7 including the signing at the interchanges in Belmont and Jefferson counties.",1031177.422,980920,1031177.422,{"$f":"IF(B163=\"Subtotal\",SUMIF($A$4:$A$500,A163,$I$4:$I$500)-I163,\"\")","v":""}]
[2012,"No. of Projects",{"$f":"SUBTOTAL(3,C151:C163)","v":13},null,null,null,null,null,0,{"$f":"IF(B164=\"Subtotal\",SUMIF($A$4:$A$500,A164,$I$4:$I$500)-I164,\"\")","v":""}]
[2012,"Subtotal","_",null,null,null,null,119381748.32700001,119381748.32700001,{"$f":"IF(B165=\"Subtotal\",SUMIF($A$4:$A$500,A165,$I$4:$I$500)-I165,\"\")","v":119381748.32700001}]
[2013,2,93473,"D02 GR FY2013 Safety","Guardrail Maintenance/Repair (NEW)","A safety funded project to upgarde guardrail at various D-2 locations, perform necessary related work",3389889.2439999999,3126670,3389889.2439999999,{"$f":"IF(B166=\"Subtotal\",SUMIF($A$4:$A$500,A166,$I$4:$I$500)-I166,\"\")","v":""}]
[2013,3,82257,"RIC IR 0071 SYSSIGN FY2013","Signs","Design Build - Supports and signs on those supports along RIC/ASD/WAY 71Project to include Sign Structures that were to be replaced with PID:82254 ASD IR 0071 SYSSIGN FY2012Plan filed as:  RIC-71-12.93, ASD-71/60-0.00/15.28, WAY-71-0.00",910962.79099999997,878790,910962.79099999997,{"$f":"IF(B167=\"Subtotal\",SUMIF($A$4:$A$500,A167,$I$4:$I$500)-I167,\"\")","v":""}]
[2013,3,93717,"LOR Boston Road R/R Xing","Spot Safety","Improve vertical profile to meet 45MPH design speed criteriaReplace existing pavementReplace small culvert",662092.63600000006,595790,662092.63600000006,{"$f":"IF(B168=\"Subtotal\",SUMIF($A$4:$A$500,A168,$I$4:$I$500)-I168,\"\")","v":""}]
[2013,4,76411,"TRU IR 0080 04.70","Minor Rehabilitation - Pavement Prmy Sys","Minor rehabilitation with bridge work.",10643704.93,10060290,10643704.93,{"$f":"IF(B169=\"Subtotal\",SUMIF($A$4:$A$500,A169,$I$4:$I$500)-I169,\"\")","v":""}]
[2013,6,82357,"UNI CR 110 1.16","Bridge Replacement","CEAO FUNDED BRIDGE REPLACEMENT PROJECT.UNI-CR110-1.16 (DELAWARE COUNTY LINE ROAD) OVER BLUES CREEK. DOVER TOWNSHIP.",849996.68200000003,858466,849996.68200000003,{"$f":"IF(B170=\"Subtotal\",SUMIF($A$4:$A$500,A170,$I$4:$I$500)-I170,\"\")","v":""}]
[2013,6,83245,"MAD IR 70 10.270 Phase 1","Interchange, Reconstruction","Improve MAD IR 70 at SR 29 interchange by constructing a roundabout at the IR 70 WB on and off ramps, widen SR 29 to accommodate the roundabout, and widen the EB off ramp.  This PID to include environmental clearance for the footprint of work on the south",3859420.64,3897880,3859420.64,{"$f":"IF(B171=\"Subtotal\",SUMIF($A$4:$A$500,A171,$I$4:$I$500)-I171,\"\")","v":""}]
[2013,6,83958,"PIC SR 674 4.210","Bridge Replacement","Bridge Replacement and widening of structure over Turkey Run",1195602.7209999999,1040600,1195602.7209999999,{"$f":"IF(B172=\"Subtotal\",SUMIF($A$4:$A$500,A172,$I$4:$I$500)-I172,\"\")","v":""}]
[2013,6,86298,"FRA US 62 32.780","Bridge Deck Replacement","Bridge Replacement over Blacklick Creek. Single-span steel beam.Design Build Project. No R/W. FY12 Reservoir.",597732.66799999995,552050,597732.66799999995,{"$f":"IF(B173=\"Subtotal\",SUMIF($A$4:$A$500,A173,$I$4:$I$500)-I173,\"\")","v":""}]
[2013,6,86920,"MRW IR 71 3.170","Major Widening","Full depth replacement and addition of 3rd median lane.Remove mainline bridge SLM 5.96 over abandoned RR.Bridge painting of overhead structure, sealing of mainline structuresEnv on PID 86916D6 Environmental Coordinator - Brian Tatman",56417829.457000002,54151050,56417829.457000002,{"$f":"IF(B174=\"Subtotal\",SUMIF($A$4:$A$500,A174,$I$4:$I$500)-I174,\"\")","v":""}]
[2013,6,92610,"FRA IR 270 52.720","Major Widening","Major Rehab Funding.   Final design and construction of the widening of I-270 between I-71 and US-23 on south side of Columbus.  Replace the mainline pavement with a 20 year design. Widening of the mainline pavement to accommodate one (1) additional throu",null,28380000,28380000,{"$f":"IF(B175=\"Subtotal\",SUMIF($A$4:$A$500,A175,$I$4:$I$500)-I175,\"\")","v":""}]
[2013,6,93159,"FRA IR 270 35.520 (Noise Wall)","Noise Wall","Design build noise wall on I-270 from Johnstown Rd to Goshen Lane (north side of I-270 near I-670).FY13 noise wall funding",730382.17099999997,683760,730382.17099999997,{"$f":"IF(B176=\"Subtotal\",SUMIF($A$4:$A$500,A176,$I$4:$I$500)-I176,\"\")","v":""}]
[2013,7,91984,"DAR SR 705 9.02/9.47/10.33","Bridge Replacement","Three span concrete slab deck removal and replacement with minimal approach work,  possible guardrail end treatment upgrades.SFN 1903845 Darke 705 0947 over Holsapple DitchSFN 1903969 Darke 705 1033 over East Branch Baurers DitchSFN 1903810 Darke 705 0902",1167875.209,1019480,1167875.209,{"$f":"IF(B177=\"Subtotal\",SUMIF($A$4:$A$500,A177,$I$4:$I$500)-I177,\"\")","v":""}]
[2013,8,90412,"PRE CR18/TR150 1.55/1.35 Des-Bld","Bridge Replacement","Project involves the replacement of the structurally deficient Bridge No. PRE-CR18-0155 (SFN: 6836267), which carries California School Road (CR-18) over Four Mile Creek and the replacement of structurally deficient Bridge No. PRE-TR 15-0135 (SFN: 6839401",null,832091,832091,{"$f":"IF(B178=\"Subtotal\",SUMIF($A$4:$A$500,A178,$I$4:$I$500)-I178,\"\")","v":""}]
[2013,8,90413,"PRE CR 80 0.12 Des-Build Br Repl","Bridge Replacement","Project includes replacing structurally deficient Bridge No. PRE-CR 80-0010 (SFN: 6835643) which carries Barnets Mill Road (CR-80) over Seven Mile Creek. Work includes minor approach work, pavement repairs, and vertical alignment adjustments, as necessary",null,725910,725910,{"$f":"IF(B179=\"Subtotal\",SUMIF($A$4:$A$500,A179,$I$4:$I$500)-I179,\"\")","v":""}]
[2013,8,90897,"BUT Lakota SRTS","Signs","Install sidewalks along Beckett Ridge, Beckett Station, and Spruce Roads.   Upgrade school signing in the vicinity of Freedom Elementary and Lakota Rigde Schools.",344377.48100000003,334884,344377.48100000003,{"$f":"IF(B180=\"Subtotal\",SUMIF($A$4:$A$500,A180,$I$4:$I$500)-I180,\"\")","v":""}]
[2013,8,90962,"PRE TR218 0.20 Des-Build Br Repl","Bridge Replacement","Project involves replacement of the structurally deficient Bridge No. PRE-TR 218-0020 (SFN: 6836402), which carries Concord-Fairhaven Road (TR-218) over Four Mile Creek. Work includes minor approach work, pavement repairs, and vertical alignment adjustmen",null,531300,531300,{"$f":"IF(B181=\"Subtotal\",SUMIF($A$4:$A$500,A181,$I$4:$I$500)-I181,\"\")","v":""}]
[2013,8,91685,"GRE CR25 2.48 Des-Build Br Rehab","Bridge Deck Replacement","Repair deteriorated bridge by replacing the existing box beams, minor repairs to the existing abutments and wingwalls, installation of guardrail, and a new wearing surface. Design Build project.",324022.40700000001,346044,324022.40700000001,{"$f":"IF(B182=\"Subtotal\",SUMIF($A$4:$A$500,A182,$I$4:$I$500)-I182,\"\")","v":""}]
[2013,8,91951,"CLE E. Fork State Park Resurface","Mill and Fill","Design-Build project will resurface roadways and parking areas within East Fork State Park in Clermont County.",2236632.4939999999,2064180,2236632.4939999999,{"$f":"IF(B183=\"Subtotal\",SUMIF($A$4:$A$500,A183,$I$4:$I$500)-I183,\"\")","v":""}]
[2013,8,92236,"HAM IR 275 24.40","Drainage Improvement","Drainage improvement in the ramp infields of Ramps C & D of the interchange of I-275 and SR 747 in Hamilton County.",214398.64300000001,187720,214398.64300000001,{"$f":"IF(B184=\"Subtotal\",SUMIF($A$4:$A$500,A184,$I$4:$I$500)-I184,\"\")","v":""}]
[2013,9,80094,"SCI US 52 16.75","Minor Rehabilitation - Pavement Prmy Sys","It is proposed to repair and the resurface the highway.",13160114.388,12606500,13160114.388,{"$f":"IF(B185=\"Subtotal\",SUMIF($A$4:$A$500,A185,$I$4:$I$500)-I185,\"\")","v":""}]
[2013,9,91922,"D09 Scioto Trail & ShawneeForest","Culvert Construction/Reconstr/Repair","In Shawnee State Forest, it is proposed to repair/replace 43 culverts on Forest Road #1, 66 culverts on Forest Road #2, and 3 culverts on Forest Road #16. The work ranges from placing headwalls at the inlet, replacing some deteriorated corrugated metal pi",639002.58200000005,657100,639002.58200000005,{"$f":"IF(B186=\"Subtotal\",SUMIF($A$4:$A$500,A186,$I$4:$I$500)-I186,\"\")","v":""}]
[2013,10,83703,"WAS CR 14 0.060","Bridge Replacement","Bridge replacement project over the Little Musking River.  WAS CR 14 0.06, SFN 8430403.  CEAO funded project using Credit Bridge.",1233319.8910000001,1146638.04,1233319.8910000001,{"$f":"IF(B187=\"Subtotal\",SUMIF($A$4:$A$500,A187,$I$4:$I$500)-I187,\"\")","v":""}]
[2013,11,81486,"BEL SR 7 11.870","Minor Rehabilitation - Pavement Prmy Sys","Priority System minor rehabilation of existing concrete pavement:  minimal joint repair, overlay with asphalt, replace median barrier, replace guardrail.  The project will also include minor deck patching on bridges within the project limits.",3524504.69,3375340,3524504.69,{"$f":"IF(B188=\"Subtotal\",SUMIF($A$4:$A$500,A188,$I$4:$I$500)-I188,\"\")","v":""}]
[2013,11,84332,"COL US 30 34.40","Signs","Upgrade existing signing along US 30 and SR 39 in Columbiana County and along US 22 in Jefferson County.  This includes all signing at the interchanges along these routes.",593857.55799999996,557870,593857.55799999996,{"$f":"IF(B189=\"Subtotal\",SUMIF($A$4:$A$500,A189,$I$4:$I$500)-I189,\"\")","v":""}]
[2013,12,92951,"CUY IR 090 18.15","Bridge Deck Replacement","Replace the deck of the South Marginal Rd bridge over IR-90 in Cleveland.",854272.674,807790,854272.674,{"$f":"IF(B190=\"Subtotal\",SUMIF($A$4:$A$500,A190,$I$4:$I$500)-I190,\"\")","v":""}]
[2013,"No. of Projects",{"$f":"SUBTOTAL(3,C166:C190)","v":25},null,null,null,null,null,0,{"$f":"IF(B191=\"Subtotal\",SUMIF($A$4:$A$500,A191,$I$4:$I$500)-I191,\"\")","v":""}]
[2013,"Subtotal","_",null,null,null,null,134019292.95700003,134019292.95700003,{"$f":"IF(B192=\"Subtotal\",SUMIF($A$4:$A$500,A192,$I$4:$I$500)-I192,\"\")","v":134019292.95700003}]
[2014,3,93093,"RIC SR 0096 13.41","Bridge Deck Replacement","Box Beam Replacement @ RIC-096-13.41",null,403907,403907,{"$f":"IF(B193=\"Subtotal\",SUMIF($A$4:$A$500,A193,$I$4:$I$500)-I193,\"\")","v":""}]
[2014,4,76340,"STA US 62/62T/173/183/225 VAR","Bridge Deck Replacement","Re-Deck of 2 bridges (Beeson & Vine) and Miscellaneous bridge work to 9 structures.",null,5086000,5086000,{"$f":"IF(B194=\"Subtotal\",SUMIF($A$4:$A$500,A194,$I$4:$I$500)-I194,\"\")","v":""}]
[2014,4,84754,"MAH IR 680 12.10/14.37","Bridge Replacement","Bridge replacement and widening. Construct a Westbound right turn lane on Western Reserve Road at the intersection with the IR-680 Northbound on-ramp. Resurfacing of IR-680 from US-224 to Ohio Turnpike, with minor bridge work.",null,8822000,8822000,{"$f":"IF(B195=\"Subtotal\",SUMIF($A$4:$A$500,A195,$I$4:$I$500)-I195,\"\")","v":""}]
[2014,4,88372,"POR Rock Spring (CR 0052) 02.78","Bridge Repair","Bridge rehabilitation.Credit Bridge funding being utilized. MAXed at $340,650.",null,1760000,1760000,{"$f":"IF(B196=\"Subtotal\",SUMIF($A$4:$A$500,A196,$I$4:$I$500)-I196,\"\")","v":""}]
[2014,4,89458,"SUM IR 0271 12.62","Major Reconstruction","Widening from four to six lanes, including the replacing and widening of four structures (Over SR82 and over Conrail RR).",null,62000000,{"$f":"IF(G197=\"\",H197,G197)","v":62000000},{"$f":"IF(B197=\"Subtotal\",SUMIF($A$4:$A$500,A197,$I$4:$I$500)-I197,\"\")","v":""}]
[2014,4,93445,"SUM SR 0008 16.66","Noise Wall","Construction of noise wall.",null,5500000,5500000,{"$f":"IF(B198=\"Subtotal\",SUMIF($A$4:$A$500,A198,$I$4:$I$500)-I198,\"\")","v":""}]
[2014,4,94516,"MAH US 0422 03.62","Bridge Deck Replacement","Bridge re-deck of sfn# 5004434, provide repairs to slope protection, including steel retaining wall. Replace signing. In the City of Youngstown, Mahoning County, Ohio.",null,2075000,2075000,{"$f":"IF(B199=\"Subtotal\",SUMIF($A$4:$A$500,A199,$I$4:$I$500)-I199,\"\")","v":""}]
[2014,6,83340,"UNI CR 84 0.261","Bridge Replacement","Replace existing steel truss bridge with a new structure.Over Little Darby Creek.Local-let with Union County as lead agency.",null,1108400,1108400,{"$f":"IF(B200=\"Subtotal\",SUMIF($A$4:$A$500,A200,$I$4:$I$500)-I200,\"\")","v":""}]
[2014,6,83953,"DEL SR 605 1.900","Bridge Repair","Replace bridge over Duncan Run.",null,930000,930000,{"$f":"IF(B201=\"Subtotal\",SUMIF($A$4:$A$500,A201,$I$4:$I$500)-I201,\"\")","v":""}]
[2014,6,94460,"FRA IR 70/Hilliard Rome Int","Section Improvement","FRA-70/Hilliard Rome Rd interflush projectNew Signal at N side of interchang with ramp realigments and wideningAdd lane both directions between I-70 & Meijer DriveAdd NB dual left turn lanes on Hilliard Rome at Renner Rd",null,5905000,5905000,{"$f":"IF(B202=\"Subtotal\",SUMIF($A$4:$A$500,A202,$I$4:$I$500)-I202,\"\")","v":""}]
[2014,7,76667,"MOT IR 70 10.79","Major Reconstruction","Full depth removal and replacement of the existing IR 70 mainline pavement, including interchange ramps; Addition of a third lane in each direction as a result of MOT operations; rehabilitation or replacement of various bridges; and, other roadway improve",null,50439046.649999999,50439046.649999999,{"$f":"IF(B203=\"Subtotal\",SUMIF($A$4:$A$500,A203,$I$4:$I$500)-I203,\"\")","v":""}]
[2014,8,75643,"HAM IR 71 1.34 Phase 1","Bridge Repair","Project will perform general rehabilitation and repair to the Lytle Tunnel, Bridge No. HAM-71-0134, SFN:  3106578.  Repairs will include sealing of tunnel joints, replacement of tiling, and repair/replacement/upgrade of lighting systems.  Electrical syste",null,12567000,12567000,{"$f":"IF(B204=\"Subtotal\",SUMIF($A$4:$A$500,A204,$I$4:$I$500)-I204,\"\")","v":""}]
[2014,8,82976,"HAM IR 275 10.57","Major Rehabilitation","Plane, repair, and pave a portion of IR 275 in Hamilton County from the overlap section with I-74 (SLM 10.57) to approximately milepost 34 (SLM 16.12). Overlay and misc bridge work to bridges including HAM-74-0979 (SFN 3108414), HAM-275-1070R (SFN 3116298",null,33500000,33500000,{"$f":"IF(B205=\"Subtotal\",SUMIF($A$4:$A$500,A205,$I$4:$I$500)-I205,\"\")","v":""}]
[2014,8,87128,"WAR SR 48 8.94","Bridge Deck Replacement","Rehabilitate bridge WAR-48-0896 by replacing the concrete deck and painting the structural steel.",null,1284000,1284000,{"$f":"IF(B206=\"Subtotal\",SUMIF($A$4:$A$500,A206,$I$4:$I$500)-I206,\"\")","v":""}]
[2014,8,87401,"HAM/WAR IR71 19.41/0.00 Loop Rmp","Interchange, Reconstruction","Project will improve safety and reduce congestion by constructing a NB loop ramp from I-71 to Mason Montgomery Rd. This ramp will reduce traffic at the intersection of the existing NB exit ramp with Mason Rd. and the intersection of Fields-Ertel Rd. with",null,13432600,13432600,{"$f":"IF(B207=\"Subtotal\",SUMIF($A$4:$A$500,A207,$I$4:$I$500)-I207,\"\")","v":""}]
[2014,8,92105,"WAR/GRE US 42 17.94/0.00","Minor Rehabilitation - Pavement Gnrl Sys","Rehabilitation of the 4-Lane section of US 42 in Warren and Greene Counites.  This work is primarily pavement rehabilitation.  The existing pavement to be break & seat with a new asphalt overlay.",null,15622000,15622000,{"$f":"IF(B208=\"Subtotal\",SUMIF($A$4:$A$500,A208,$I$4:$I$500)-I208,\"\")","v":""}]
[2014,8,94289,"BUT TR 134 7.36 D-B Bridge Rehab","Bridge Deck Replacement","Improvements to Bridge No. BUT-TR 134-7.36 which carries Yankee Road over Dick's Creek. Improvements include replacement of the existing concrete deck, replacement of existing steel beams, removing and replacing the concrete backwalls and expansion joints",null,1014000,1014000,{"$f":"IF(B209=\"Subtotal\",SUMIF($A$4:$A$500,A209,$I$4:$I$500)-I209,\"\")","v":""}]
[2014,8,94628,"HAM IR 71 14.33","Spot Safety","Provide an auxiliary lane for southbound IR71 from the Pfeiffer on ramp to the SR126 off ramp.  Requires moving of a short section of noise wall.",null,2700000,2700000,{"$f":"IF(B210=\"Subtotal\",SUMIF($A$4:$A$500,A210,$I$4:$I$500)-I210,\"\")","v":""}]
[2014,8,95745,"CLE CR 62 5.63 Des-Bld Br Rehab","Bridge Deck Replacement","Project proposes to replace the existing bridge deck, painting of the existing steel beams and cross frames, bearing replacement, end cross frame replacement, and beam end repairs. Bridge carries CR-62 (Jackson Pike) over the East Fork Little Miami River.",null,958636,958636,{"$f":"IF(B211=\"Subtotal\",SUMIF($A$4:$A$500,A211,$I$4:$I$500)-I211,\"\")","v":""}]
[2014,9,93801,"BRO US 68 30.72 Safety","Turn Lane Addition","Within the Village of Mt. Orab, it is proposed to add left turn lanes on US68 at both SR32 ramp intersections and coordinate the signaels with adjacent signals. Add right turn lane on SR32 eastbound off ramp at it intersections with US68.",null,2277115.15,2277115.15,{"$f":"IF(B212=\"Subtotal\",SUMIF($A$4:$A$500,A212,$I$4:$I$500)-I212,\"\")","v":""}]
[2014,11,94449,"COL SR 11 17.770","Bridge Deck Replacement","Replace existing superstructure on two (L & R) continuous steel beam bridges. Slight profile adjustment will be required to increase vertical clearance.",null,1750900,1750900,{"$f":"IF(B213=\"Subtotal\",SUMIF($A$4:$A$500,A213,$I$4:$I$500)-I213,\"\")","v":""}]
[2014,11,95660,"HAS US 250 7.800","Bridge Replacement","Replace existing bridge with new single span slab bridge",null,418550,418550,{"$f":"IF(B214=\"Subtotal\",SUMIF($A$4:$A$500,A214,$I$4:$I$500)-I214,\"\")","v":""}]
[2014,12,82119,"CUY IR 090 14.90 EB Design Build","Bridge Replacement","Design-Build-Finance ContractConstruct a new structure to replace existng Innerbelt Bridge (1809393).  CCG2.  Work includes the demolition of the existing structure,  (PID 88318) and the replacement of the I-71 bridge deck over I-90/490 (PID 86824).",null,366415906,366415906,{"$f":"IF(B215=\"Subtotal\",SUMIF($A$4:$A$500,A215,$I$4:$I$500)-I215,\"\")","v":""}]
[2014,12,94723,"CUY IR 480 11.60 Interchange","Intersection Improvement","Upgrade the IR-480 and Tiedeman Interchange in the City of Brooklyn to improve traffic flow.  SFY2013 pilot Quick Clear project.",null,2482300,2482300,{"$f":"IF(B216=\"Subtotal\",SUMIF($A$4:$A$500,A216,$I$4:$I$500)-I216,\"\")","v":""}]
[2014,"No. of Projects",{"$f":"SUBTOTAL(3,C193:C216)","v":24},null,null,null,null,null,0,{"$f":"IF(B217=\"Subtotal\",SUMIF($A$4:$A$500,A217,$I$4:$I$500)-I217,\"\")","v":""}]
[2014,"Subtotal","_",null,null,null,null,598452360.79999995,598452360.79999995,{"$f":"IF(B218=\"Subtotal\",SUMIF($A$4:$A$500,A218,$I$4:$I$500)-I218,\"\")","v":598452360.79999995}]
[2015,2,95437,"HAN/WOO 75 19.22/0.00 Pav Widen","Major Widening","A major new funded project to widen I-75 to three lanes in each direction; perform necessary related work.",null,51500000,51500000,{"$f":"IF(B219=\"Subtotal\",SUMIF($A$4:$A$500,A219,$I$4:$I$500)-I219,\"\")","v":""}]
[2015,3,88825,"LOR SR 0018 12.29","Bridge Repair","Replace Box Beam SuperstructureLOR-SR-18-12.29Design Build selected at 07/18/11 WP Meeting",null,440000,440000,{"$f":"IF(B220=\"Subtotal\",SUMIF($A$4:$A$500,A220,$I$4:$I$500)-I220,\"\")","v":""}]
[2015,6,16707,"MAD TR 24 02.750","Bridge Replacement","Replacement of deficient narrow structure over Little Darby Creek",null,1486000,1486000,{"$f":"IF(B221=\"Subtotal\",SUMIF($A$4:$A$500,A221,$I$4:$I$500)-I221,\"\")","v":""}]
[2015,8,84613,"CLE SR 32 7.69N","Bridge Deck Replacement","Replace continuous slab superstructure of bridge CLE-32-0769N.",null,1262800,1262800,{"$f":"IF(B222=\"Subtotal\",SUMIF($A$4:$A$500,A222,$I$4:$I$500)-I222,\"\")","v":""}]
[2015,10,87371,"GAL CR 20 9.370","Bridge Replacement","Bridge replacement project. Work includes removal of superstructure and selective demolition of piers, abutments and substructure.  Replacement to include widening to new standards. GAL CR 20 9.37 SFN 2734109. Bridge width 20', Pavement/Roadway width 19',",null,1322289.95,1322289.95,{"$f":"IF(B223=\"Subtotal\",SUMIF($A$4:$A$500,A223,$I$4:$I$500)-I223,\"\")","v":""}]
[2015,"No. of Projects",{"$f":"SUBTOTAL(3,C219:C223)","v":5},null,null,null,null,null,0,{"$f":"IF(B224=\"Subtotal\",SUMIF($A$4:$A$500,A224,$I$4:$I$500)-I224,\"\")","v":""}]
[2015,"Subtotal","_",null,null,null,null,56011089.950000003,56011089.950000003,{"$f":"IF(B225=\"Subtotal\",SUMIF($A$4:$A$500,A225,$I$4:$I$500)-I225,\"\")","v":56011089.950000003}]
[2016,4,93501,"SUM IR 0076 00.00","Major Rehabilitation","Complete pavement replacement from Medina County line to State Route 21. Pavement replacement and widening to six lanes from State Route 21 to State Route 619.",null,134269000,134269000,{"$f":"IF(B226=\"Subtotal\",SUMIF($A$4:$A$500,A226,$I$4:$I$500)-I226,\"\")","v":""}]
[2016,6,83988,"FRA IR 270-49.00 (at Alum Cr Dr)","Interchange, Reconstruction","Unfunded projectConstruct new IR 270 SB to WB on ramp, widen IR 270 EB off ramp, widen Alum Creek Dr to provide appropriate turn lanes including the structure over IR 2703rd project resulting from study of I-270/Alum Creek interchange for safety and capac",null,null,0,{"$f":"IF(B227=\"Subtotal\",SUMIF($A$4:$A$500,A227,$I$4:$I$500)-I227,\"\")","v":""}]
[2016,8,88679,"HAM IR 74 9.53","Minor Rehabilitation - Pavement Prmy Sys","Minor rehab on the pavement including structures of I-74 from the overlap section to I-75.  The mainline and ramp work at the North Bend interchange is omitted with this project and included in pid 93079.",null,16663900,16663900,{"$f":"IF(B228=\"Subtotal\",SUMIF($A$4:$A$500,A228,$I$4:$I$500)-I228,\"\")","v":""}]
[2016,8,90438,"PRE CR 45 6.89 Des-Build Br Repl","Bridge Replacement","Project includes replacement of structurally deficient Bridge No. PRE-CR 45-0100 (SFN: 6835414), which serves to carry CR-45 over Paint Creek. Improvements include pavement repairs, and improvements to the vertical alignment/profile of the roadway.",null,388000,388000,{"$f":"IF(B229=\"Subtotal\",SUMIF($A$4:$A$500,A229,$I$4:$I$500)-I229,\"\")","v":""}]
[2016,9,87298,"ADA US 52 12.49 Brdg Replace","Bridge Replacement","It is proposed to replace the deficient structure (SFN0101982).",null,1733400,1733400,{"$f":"IF(B230=\"Subtotal\",SUMIF($A$4:$A$500,A230,$I$4:$I$500)-I230,\"\")","v":""}]
[2016,10,87862,"D10 Signal Maint. FY 2016","Signals","Signal Maintenance project.  Replacement of poles, signal heads, pavement loops, wiring, etc.. at various locations in D-10.",null,364000,364000,{"$f":"IF(B231=\"Subtotal\",SUMIF($A$4:$A$500,A231,$I$4:$I$500)-I231,\"\")","v":""}]
[2016,"No. of Projects",{"$f":"SUBTOTAL(3,C226:C231)","v":6},null,null,null,null,null,0,{"$f":"IF(B232=\"Subtotal\",SUMIF($A$4:$A$500,A232,$I$4:$I$500)-I232,\"\")","v":""}]
[2016,"Subtotal","_",null,null,null,null,153418300,153418300,{"$f":"IF(B233=\"Subtotal\",SUMIF($A$4:$A$500,A233,$I$4:$I$500)-I233,\"\")","v":153418300}]
[2017,5,93273,"FAI US 22 23.88","New Bridge","Replace Bridge",null,10700000,10700000,{"$f":"IF(B234=\"Subtotal\",SUMIF($A$4:$A$500,A234,$I$4:$I$500)-I234,\"\")","v":""}]
[2017,10,93152,"GAL TR 752 0.29","Bridge Replacement","Bridge replacement project. GAL TR 752 0.29 (SFN 2743531).",null,1043000,1043000,{"$f":"IF(B235=\"Subtotal\",SUMIF($A$4:$A$500,A235,$I$4:$I$500)-I235,\"\")","v":""}]
[2017,"No. of Projects",{"$f":"SUBTOTAL(3,C234:C235)","v":2},null,null,null,null,null,0,{"$f":"IF(B236=\"Subtotal\",SUMIF($A$4:$A$500,A236,$I$4:$I$500)-I236,\"\")","v":""}]
[2017,"Subtotal","_",null,null,null,null,11743000,11743000,{"$f":"IF(B237=\"Subtotal\",SUMIF($A$4:$A$500,A237,$I$4:$I$500)-I237,\"\")","v":11743000}]
[2018,6,93446,"FRA IR 71 Noise Wall Repair","Noise Wall","Design Build project to replace existing noise wall panels with fibergalss panels.  Reuse existing steel posts.SB 5th Ave ramp to I-71 SBSB 5th Ave ramp to I-670 WB",null,1100000,1100000,{"$f":"IF(B238=\"Subtotal\",SUMIF($A$4:$A$500,A238,$I$4:$I$500)-I238,\"\")","v":""}]
[2018,9,93983,"SCI TR 99 4.81 Brdg Replace","Bridge Replacement","On TR 99, Mackletree Road, 4.81m 0.29 miles from where it ends and intersects with SR125, it is proposed to replace the structure (SFN 7332882).",null,1578785,1578785,{"$f":"IF(B239=\"Subtotal\",SUMIF($A$4:$A$500,A239,$I$4:$I$500)-I239,\"\")","v":""}]
[2018,10,93151,"GAL CR 121 1.52","Bridge Replacement","Bridge replacement project. GAL CR 121 1.52 (SFN 2740516).",null,290000,290000,{"$f":"IF(B240=\"Subtotal\",SUMIF($A$4:$A$500,A240,$I$4:$I$500)-I240,\"\")","v":""}]
[2018,10,93153,"GAL TR 766 0.05","Bridge Replacement","Bridge replacement project. GAL TR 766 0.05 (SFN 2743566).",null,927000,927000,{"$f":"IF(B241=\"Subtotal\",SUMIF($A$4:$A$500,A241,$I$4:$I$500)-I241,\"\")","v":""}]
[2018,12,82380,"CUY INNERBELT CCG3","Major Rehabilitation","CCG3: Improve I-90 in the ôCentral Interchangeö area between E 9th Street and E 22nd Street; improve E 22nd Street using part-width construction; remove the Cedar Avenue bridge over I-90; improve I-77 north of the Kingsbury Run Bridge; and replace the Car",null,398950000,398950000,{"$f":"IF(B242=\"Subtotal\",SUMIF($A$4:$A$500,A242,$I$4:$I$500)-I242,\"\")","v":""}]
[2018,"No. of Projects",{"$f":"SUBTOTAL(3,C238:C242)","v":5},null,null,null,null,null,0,{"$f":"IF(B243=\"Subtotal\",SUMIF($A$4:$A$500,A243,$I$4:$I$500)-I243,\"\")","v":""}]
[2018,"Subtotal","_",null,null,null,null,402845785,402845785,{"$f":"IF(B244=\"Subtotal\",SUMIF($A$4:$A$500,A244,$I$4:$I$500)-I244,\"\")","v":402845785}]
[2025,6,93605,"MAD IR 70 10.270 Phase 2","Interchange, Reconstruction","Construction of the second phase of work at the I-70 and SR-29 interchange.Includes construction of an adjacent bridge structure over I-70, a two-lane roundabout at the I-70 EB exit/entrance ramps, pavement widening, RW south of I-70, and expansion of sec",null,11000000,11000000,{"$f":"IF(B245=\"Subtotal\",SUMIF($A$4:$A$500,A245,$I$4:$I$500)-I245,\"\")","v":""}]
[2025,"No. of Projects",{"$f":"SUBTOTAL(3,C245:C245)","v":1},null,null,null,null,null,0,{"$f":"IF(B246=\"Subtotal\",SUMIF($A$4:$A$500,A246,$I$4:$I$500)-I246,\"\")","v":""}]
[2025,"Subtotal","_",null,null,null,null,11000000,11000000,{"$f":"IF(B247=\"Subtotal\",SUMIF($A$4:$A$500,A247,$I$4:$I$500)-I247,\"\")","v":11000000}]
["-",3,87914,"ASD SIGN REPLACEMENT FY2010","Signs","Systematic Sign ReplacementUNSELECTED Stimulus 2 Design Build candidate - SJN:437971Removed Funds ($70,000 PE / $735,723 CO UNFU) and Sale and Award (FY2011)",null,null,0,{"$f":"IF(B248=\"Subtotal\",SUMIF($A$4:$A$500,A248,$I$4:$I$500)-I248,\"\")","v":""}]
["-",3,87915,"LOR SIGN REPLACEMENT FY2010","Signs","Systematic Sign ReplacementUNSELECTED Stimulus 2 Design Build candidate - SJN:437972Removed Funds ($168,000 PE / $1,662,615 CO UNFU) and Sale and Award (FY2011)",null,null,0,{"$f":"IF(B249=\"Subtotal\",SUMIF($A$4:$A$500,A249,$I$4:$I$500)-I249,\"\")","v":""}]
["-",3,87916,"RIC SIGN REPLACEMENT FY2010","Signs","Systematic Sign ReplacementUNSELECTED Stimulus 2 Design Build candidate - SJN:437973Removed Funds ($217,000 PE / $2,012,400 CO UNFU) and Sale and Award (FY2011)",null,null,0,{"$f":"IF(B250=\"Subtotal\",SUMIF($A$4:$A$500,A250,$I$4:$I$500)-I250,\"\")","v":""}]
["-",3,87917,"WAY SIGN REPLACEMENT FY2010","Signs","Systematic Sign Replacement Design Build - candidate",null,null,0,{"$f":"IF(B251=\"Subtotal\",SUMIF($A$4:$A$500,A251,$I$4:$I$500)-I251,\"\")","v":""}]
["-",3,96227,"MED IR 0071 24.02 (SR303 RmpClr)","Intersection Improvement","FY2014 Design Acquire Build project (M May approved D-A-B in FY 2015)MED-071-24.02 - 24.22/MED-303-09.04Improve southbound exit from I-71 to SR 303 withexit ramp wideing/extending/restriping on I-71 and SR 303.(Scope of Services to be completed by Distric",null,null,0,{"$f":"IF(B252=\"Subtotal\",SUMIF($A$4:$A$500,A252,$I$4:$I$500)-I252,\"\")","v":""}]
["-",8,85630,"HAM IR 71 2.80","Noise Wall","Install type two noise barriers at various warranted locations within stated termini-stimulus project. Design Build project",null,null,0,{"$f":"IF(B253=\"Subtotal\",SUMIF($A$4:$A$500,A253,$I$4:$I$500)-I253,\"\")","v":""}]
["-",8,91719,"HAM/WAR IR 71 19.89/0.09","Bridge Repair","Rehabilitate bridges HAM-71-1989L/R and WAR-71-0009 L/R installing new rigid overlays and replacing the roadway barrier between the northbound bridges, and perfroming other minor bridge rehabilitation items. Project will be design build and combined with",null,null,0,{"$f":"IF(B254=\"Subtotal\",SUMIF($A$4:$A$500,A254,$I$4:$I$500)-I254,\"\")","v":""}]
["-",12,94577,"CUY US 006 21.27","Bridge Repair","Rehabilitate, replace, or otherwise upgrade the 15' stone arch drainage structure carrying Dugaway Brook under Euclid Avenue (US-6) located just east of Superior Avenue in East Cleveland.",null,null,0,{"$f":"IF(B255=\"Subtotal\",SUMIF($A$4:$A$500,A255,$I$4:$I$500)-I255,\"\")","v":""}]
["-","No. of Projects",{"$f":"SUBTOTAL(3,C248:C255)","v":8},null,null,null,null,null,0,{"$f":"IF(B256=\"Subtotal\",SUMIF($A$4:$A$500,A256,$I$4:$I$500)-I256,\"\")","v":""}]
["-","Subtotal","_",null,null,null,null,0,0,{"$f":"IF(B257=\"Subtotal\",SUMIF($A$4:$A$500,A257,$I$4:$I$500)-I257,\"\")","v":0}]
[null,null,null,null,null,null,null,null,{"$f":"IF(G258=\"\",H258,G258)","v":0},{"$f":"IF(B258=\"Subtotal\",SUMIF($A$4:$A$500,A258,$I$4:$I$500)-I258,\"\")","v":""}]
[null,null,null,null,null,null,null,null,0,{"$f":"IF(B259=\"Subtotal\",SUMIF($A$4:$A$500,A259,$I$4:$I$500)-I259,\"\")","v":""}]
[null,null,null,null,null,null,null,null,0,{"$f":"IF(B260=\"Subtotal\",SUMIF($A$4:$A$500,A260,$I$4:$I$500)-I260,\"\")","v":""}]
[null,null,null,null,null,null,null,null,0,{"$f":"IF(B261=\"Subtotal\",SUMIF($A$4:$A$500,A261,$I$4:$I$500)-I261,\"\")","v":""}]
[null,null,null,null,null,null,null,null,0,{"$f":"IF(B262=\"Subtotal\",SUMIF($A$4:$A$500,A262,$I$4:$I$500)-I262,\"\")","v":""}]
[null,null,null,null,null,null,null,null,0,{"$f":"IF(B263=\"Subtotal\",SUMIF($A$4:$A$500,A263,$I$4:$I$500)-I263,\"\")","v":""}]
[null,null,null,null,null,null,null,null,0,{"$f":"IF(B264=\"Subtotal\",SUMIF($A$4:$A$500,A264,$I$4:$I$500)-I264,\"\")","v":""}]
[null,null,null,null,null,null,null,null,0,{"$f":"IF(B265=\"Subtotal\",SUMIF($A$4:$A$500,A265,$I$4:$I$500)-I265,\"\")","v":""}]
[null,null,null,null,null,null,null,null,0,{"$f":"IF(B266=\"Subtotal\",SUMIF($A$4:$A$500,A266,$I$4:$I$500)-I266,\"\")","v":""}]
[null,null,null,null,null,null,null,null,0,{"$f":"IF(B267=\"Subtotal\",SUMIF($A$4:$A$500,A267,$I$4:$I$500)-I267,\"\")","v":""}]
[null,null,null,null,null,null,null,null,0,{"$f":"IF(B268=\"Subtotal\",SUMIF($A$4:$A$500,A268,$I$4:$I$500)-I268,\"\")","v":""}]
[null,null,null,null,null,null,null,null,0,{"$f":"IF(B269=\"Subtotal\",SUMIF($A$4:$A$500,A269,$I$4:$I$500)-I269,\"\")","v":""}]
[null,null,null,null,null,null,null,null,0,{"$f":"IF(B270=\"Subtotal\",SUMIF($A$4:$A$500,A270,$I$4:$I$500)-I270,\"\")","v":""}]
[null,null,null,null,null,null,null,null,0,{"$f":"IF(B271=\"Subtotal\",SUMIF($A$4:$A$500,A271,$I$4:$I$500)-I271,\"\")","v":""}]
[null,null,null,null,null,null,null,null,0,{"$f":"IF(B272=\"Subtotal\",SUMIF($A$4:$A$500,A272,$I$4:$I$500)-I272,\"\")","v":""}]
[null,null,null,null,null,null,null,null,0,{"$f":"IF(B273=\"Subtotal\",SUMIF($A$4:$A$500,A273,$I$4:$I$500)-I273,\"\")","v":""}]
[null,null,null,null,null,null,null,null,0,{"$f":"IF(B274=\"Subtotal\",SUMIF($A$4:$A$500,A274,$I$4:$I$500)-I274,\"\")","v":""}]
[null,null,null,null,null,null,null,null,0,{"$f":"IF(B275=\"Subtotal\",SUMIF($A$4:$A$500,A275,$I$4:$I$500)-I275,\"\")","v":""}]
[null,null,null,null,null,null,null,null,0,{"$f":"IF(B276=\"Subtotal\",SUMIF($A$4:$A$500,A276,$I$4:$I$500)-I276,\"\")","v":""}]
[null,null,null,null,null,null,null,null,0,{"$f":"IF(B277=\"Subtotal\",SUMIF($A$4:$A$500,A277,$I$4:$I$500)-I277,\"\")","v":""}]
[null,null,null,null,null,null,null,null,0,{"$f":"IF(B278=\"Subtotal\",SUMIF($A$4:$A$500,A278,$I$4:$I$500)-I278,\"\")","v":""}]
[null,null,null,null,null,null,null,null,0,{"$f":"IF(B279=\"Subtotal\",SUMIF($A$4:$A$500,A279,$I$4:$I$500)-I279,\"\")","v":""}]
[null,null,null,null,null,null,null,null,0,{"$f":"IF(B280=\"Subtotal\",SUMIF($A$4:$A$500,A280,$I$4:$I$500)-I280,\"\")","v":""}]
[null,null,null,null,null,null,null,null,0,{"$f":"IF(B281=\"Subtotal\",SUMIF($A$4:$A$500,A281,$I$4:$I$500)-I281,\"\")","v":""}]
[null,null,null,null,null,null,null,null,0,{"$f":"IF(B282=\"Subtotal\",SUMIF($A$4:$A$500,A282,$I$4:$I$500)-I282,\"\")","v":""}]
[null,null,null,null,null,null,null,null,0,{"$f":"IF(B283=\"Subtotal\",SUMIF($A$4:$A$500,A283,$I$4:$I$500)-I283,\"\")","v":""}]
[null,null,null,null,null,null,null,null,0,{"$f":"IF(B284=\"Subtotal\",SUMIF($A$4:$A$500,A284,$I$4:$I$500)-I284,\"\")","v":""}]
[null,null,null,null,null,null,null,null,0,{"$f":"IF(B285=\"Subtotal\",SUMIF($A$4:$A$500,A285,$I$4:$I$500)-I285,\"\")","v":""}]
[null,null,null,null,null,null,null,null,0,{"$f":"IF(B286=\"Subtotal\",SUMIF($A$4:$A$500,A286,$I$4:$I$500)-I286,\"\")","v":""}]
[null,null,null,null,null,null,null,null,0,{"$f":"IF(B287=\"Subtotal\",SUMIF($A$4:$A$500,A287,$I$4:$I$500)-I287,\"\")","v":""}]
[null,null,null,null,null,null,null,null,0,{"$f":"IF(B288=\"Subtotal\",SUMIF($A$4:$A$500,A288,$I$4:$I$500)-I288,\"\")","v":""}]
[null,null,null,null,null,null,null,null,0,{"$f":"IF(B289=\"Subtotal\",SUMIF($A$4:$A$500,A289,$I$4:$I$500)-I289,\"\")","v":""}]
[null,null,null,null,null,null,null,null,0,{"$f":"IF(B290=\"Subtotal\",SUMIF($A$4:$A$500,A290,$I$4:$I$500)-I290,\"\")","v":""}]
[null,null,null,null,null,null,null,null,0,{"$f":"IF(B291=\"Subtotal\",SUMIF($A$4:$A$500,A291,$I$4:$I$500)-I291,\"\")","v":""}]
[null,null,null,null,null,null,null,null,0,{"$f":"IF(B292=\"Subtotal\",SUMIF($A$4:$A$500,A292,$I$4:$I$500)-I292,\"\")","v":""}]
[null,null,null,null,null,null,null,null,0,{"$f":"IF(B293=\"Subtotal\",SUMIF($A$4:$A$500,A293,$I$4:$I$500)-I293,\"\")","v":""}]
[null,null,null,null,null,null,null,null,0,{"$f":"IF(B294=\"Subtotal\",SUMIF($A$4:$A$500,A294,$I$4:$I$500)-I294,\"\")","v":""}]
[null,null,null,null,null,null,null,null,0,{"$f":"IF(B295=\"Subtotal\",SUMIF($A$4:$A$500,A295,$I$4:$I$500)-I295,\"\")","v":""}]
[null,null,null,null,null,null,null,null,0,{"$f":"IF(B296=\"Subtotal\",SUMIF($A$4:$A$500,A296,$I$4:$I$500)-I296,\"\")","v":""}]
[null,null,null,null,null,null,null,null,0,{"$f":"IF(B297=\"Subtotal\",SUMIF($A$4:$A$500,A297,$I$4:$I$500)-I297,\"\")","v":""}]
[null,null,null,null,null,null,null,null,0,{"$f":"IF(B298=\"Subtotal\",SUMIF($A$4:$A$500,A298,$I$4:$I$500)-I298,\"\")","v":""}]
[null,null,null,null,null,null,null,null,0,{"$f":"IF(B299=\"Subtotal\",SUMIF($A$4:$A$500,A299,$I$4:$I$500)-I299,\"\")","v":""}]
[null,null,null,null,null,null,null,null,0,{"$f":"IF(B300=\"Subtotal\",SUMIF($A$4:$A$500,A300,$I$4:$I$500)-I300,\"\")","v":""}]
[null,null,null,null,null,null,null,null,0,{"$f":"IF(B301=\"Subtotal\",SUMIF($A$4:$A$500,A301,$I$4:$I$500)-I301,\"\")","v":""}]
[null,null,null,null,null,null,null,null,0,{"$f":"IF(B302=\"Subtotal\",SUMIF($A$4:$A$500,A302,$I$4:$I$500)-I302,\"\")","v":""}]
[null,null,null,null,null,null,null,null,0,{"$f":"IF(B303=\"Subtotal\",SUMIF($A$4:$A$500,A303,$I$4:$I$500)-I303,\"\")","v":""}]
[null,null,null,null,null,null,null,null,0,{"$f":"IF(B304=\"Subtotal\",SUMIF($A$4:$A$500,A304,$I$4:$I$500)-I304,\"\")","v":""}]
[null,null,null,null,null,null,null,null,{"$f":"IF(G305=\"\",H305,G305)","v":0},{"$f":"IF(B305=\"Subtotal\",SUMIF($A$4:$A$500,A305,$I$4:$I$500)-I305,\"\")","v":""}]
[null,null,null,null,null,null,null,null,0,{"$f":"IF(B306=\"Subtotal\",SUMIF($A$4:$A$500,A306,$I$4:$I$500)-I306,\"\")","v":""}]
[null,null,null,null,null,null,null,null,0,{"$f":"IF(B307=\"Subtotal\",SUMIF($A$4:$A$500,A307,$I$4:$I$500)-I307,\"\")","v":""}]
[null,null,null,null,null,null,null,null,0,{"$f":"IF(B308=\"Subtotal\",SUMIF($A$4:$A$500,A308,$I$4:$I$500)-I308,\"\")","v":""}]
[null,null,null,null,null,null,null,null,0,{"$f":"IF(B309=\"Subtotal\",SUMIF($A$4:$A$500,A309,$I$4:$I$500)-I309,\"\")","v":""}]
[null,null,null,null,null,null,null,null,0,{"$f":"IF(B310=\"Subtotal\",SUMIF($A$4:$A$500,A310,$I$4:$I$500)-I310,\"\")","v":""}]
[null,null,null,null,null,null,null,null,0,{"$f":"IF(B311=\"Subtotal\",SUMIF($A$4:$A$500,A311,$I$4:$I$500)-I311,\"\")","v":""}]
[null,null,null,null,null,null,null,null,0,{"$f":"IF(B312=\"Subtotal\",SUMIF($A$4:$A$500,A312,$I$4:$I$500)-I312,\"\")","v":""}]
[null,null,null,null,null,null,null,null,0,{"$f":"IF(B313=\"Subtotal\",SUMIF($A$4:$A$500,A313,$I$4:$I$500)-I313,\"\")","v":""}]
[null,null,null,null,null,null,null,null,0,{"$f":"IF(B314=\"Subtotal\",SUMIF($A$4:$A$500,A314,$I$4:$I$500)-I314,\"\")","v":""}]
[null,null,null,null,null,null,null,null,0,{"$f":"IF(B315=\"Subtotal\",SUMIF($A$4:$A$500,A315,$I$4:$I$500)-I315,\"\")","v":""}]
[null,null,null,null,null,null,null,null,0,{"$f":"IF(B316=\"Subtotal\",SUMIF($A$4:$A$500,A316,$I$4:$I$500)-I316,\"\")","v":""}]
[null,null,null,null,null,null,null,null,0,{"$f":"IF(B317=\"Subtotal\",SUMIF($A$4:$A$500,A317,$I$4:$I$500)-I317,\"\")","v":""}]
[null,null,null,null,null,null,null,null,0,{"$f":"IF(B318=\"Subtotal\",SUMIF($A$4:$A$500,A318,$I$4:$I$500)-I318,\"\")","v":""}]
[null,null,null,null,null,null,null,null,0,{"$f":"IF(B319=\"Subtotal\",SUMIF($A$4:$A$500,A319,$I$4:$I$500)-I319,\"\")","v":""}]
[null,null,null,null,null,null,null,null,0,{"$f":"IF(B320=\"Subtotal\",SUMIF($A$4:$A$500,A320,$I$4:$I$500)-I320,\"\")","v":""}]
[null,null,null,null,null,null,null,null,0,{"$f":"IF(B321=\"Subtotal\",SUMIF($A$4:$A$500,A321,$I$4:$I$500)-I321,\"\")","v":""}]
[null,null,null,null,null,null,null,null,0,{"$f":"IF(B322=\"Subtotal\",SUMIF($A$4:$A$500,A322,$I$4:$I$500)-I322,\"\")","v":""}]
[null,null,null,null,null,null,null,null,0,{"$f":"IF(B323=\"Subtotal\",SUMIF($A$4:$A$500,A323,$I$4:$I$500)-I323,\"\")","v":""}]
[null,null,null,null,null,null,null,null,0,{"$f":"IF(B324=\"Subtotal\",SUMIF($A$4:$A$500,A324,$I$4:$I$500)-I324,\"\")","v":""}]
[null,null,null,null,null,null,null,null,0,{"$f":"IF(B325=\"Subtotal\",SUMIF($A$4:$A$500,A325,$I$4:$I$500)-I325,\"\")","v":""}]
[null,null,null,null,null,null,null,null,0,{"$f":"IF(B326=\"Subtotal\",SUMIF($A$4:$A$500,A326,$I$4:$I$500)-I326,\"\")","v":""}]
[null,null,null,null,null,null,null,null,0,{"$f":"IF(B327=\"Subtotal\",SUMIF($A$4:$A$500,A327,$I$4:$I$500)-I327,\"\")","v":""}]
[null,null,null,null,null,null,null,null,0,{"$f":"IF(B328=\"Subtotal\",SUMIF($A$4:$A$500,A328,$I$4:$I$500)-I328,\"\")","v":""}]
[null,null,null,null,null,null,null,null,0,{"$f":"IF(B329=\"Subtotal\",SUMIF($A$4:$A$500,A329,$I$4:$I$500)-I329,\"\")","v":""}]
[null,null,null,null,null,null,null,null,0,{"$f":"IF(B330=\"Subtotal\",SUMIF($A$4:$A$500,A330,$I$4:$I$500)-I330,\"\")","v":""}]
[null,null,null,null,null,null,null,null,0,{"$f":"IF(B331=\"Subtotal\",SUMIF($A$4:$A$500,A331,$I$4:$I$500)-I331,\"\")","v":""}]
[null,null,null,null,null,null,null,null,0,{"$f":"IF(B332=\"Subtotal\",SUMIF($A$4:$A$500,A332,$I$4:$I$500)-I332,\"\")","v":""}]
[null,null,null,null,null,null,null,null,0,{"$f":"IF(B333=\"Subtotal\",SUMIF($A$4:$A$500,A333,$I$4:$I$500)-I333,\"\")","v":""}]
[null,null,null,null,null,null,null,null,0,{"$f":"IF(B334=\"Subtotal\",SUMIF($A$4:$A$500,A334,$I$4:$I$500)-I334,\"\")","v":""}]
[null,null,null,null,null,null,null,null,0,{"$f":"IF(B335=\"Subtotal\",SUMIF($A$4:$A$500,A335,$I$4:$I$500)-I335,\"\")","v":""}]
[null,null,null,null,null,null,null,null,0,{"$f":"IF(B336=\"Subtotal\",SUMIF($A$4:$A$500,A336,$I$4:$I$500)-I336,\"\")","v":""}]
[null,null,null,null,null,null,null,null,0,{"$f":"IF(B337=\"Subtotal\",SUMIF($A$4:$A$500,A337,$I$4:$I$500)-I337,\"\")","v":""}]
[null,null,null,null,null,null,null,null,0,{"$f":"IF(B338=\"Subtotal\",SUMIF($A$4:$A$500,A338,$I$4:$I$500)-I338,\"\")","v":""}]
[null,null,null,null,null,null,null,null,0,{"$f":"IF(B339=\"Subtotal\",SUMIF($A$4:$A$500,A339,$I$4:$I$500)-I339,\"\")","v":""}]
[null,null,null,null,null,null,null,null,0,{"$f":"IF(B340=\"Subtotal\",SUMIF($A$4:$A$500,A340,$I$4:$I$500)-I340,\"\")","v":""}]
[null,null,null,null,null,null,null,null,0,{"$f":"IF(B341=\"Subtotal\",SUMIF($A$4:$A$500,A341,$I$4:$I$500)-I341,\"\")","v":""}]
[null,null,null,null,null,null,null,null,0,{"$f":"IF(B342=\"Subtotal\",SUMIF($A$4:$A$500,A342,$I$4:$I$500)-I342,\"\")","v":""}]
[null,null,null,null,null,null,null,null,0,{"$f":"IF(B343=\"Subtotal\",SUMIF($A$4:$A$500,A343,$I$4:$I$500)-I343,\"\")","v":""}]
[null,null,null,null,null,null,null,null,0,{"$f":"IF(B344=\"Subtotal\",SUMIF($A$4:$A$500,A344,$I$4:$I$500)-I344,\"\")","v":""}]
[null,null,null,null,null,null,null,null,0,{"$f":"IF(B345=\"Subtotal\",SUMIF($A$4:$A$500,A345,$I$4:$I$500)-I345,\"\")","v":""}]
[null,null,null,null,null,null,null,null,0,{"$f":"IF(B346=\"Subtotal\",SUMIF($A$4:$A$500,A346,$I$4:$I$500)-I346,\"\")","v":""}]
[null,null,null,null,null,null,null,null,0,{"$f":"IF(B347=\"Subtotal\",SUMIF($A$4:$A$500,A347,$I$4:$I$500)-I347,\"\")","v":""}]
[null,null,null,null,null,null,null,null,0,{"$f":"IF(B348=\"Subtotal\",SUMIF($A$4:$A$500,A348,$I$4:$I$500)-I348,\"\")","v":""}]
[null,null,null,null,null,null,null,null,0,{"$f":"IF(B349=\"Subtotal\",SUMIF($A$4:$A$500,A349,$I$4:$I$500)-I349,\"\")","v":""}]
[null,null,null,null,null,null,null,null,0,{"$f":"IF(B350=\"Subtotal\",SUMIF($A$4:$A$500,A350,$I$4:$I$500)-I350,\"\")","v":""}]
[null,null,null,null,null,null,null,null,0,{"$f":"IF(B351=\"Subtotal\",SUMIF($A$4:$A$500,A351,$I$4:$I$500)-I351,\"\")","v":""}]
[null,null,null,null,null,null,null,null,0,{"$f":"IF(B352=\"Subtotal\",SUMIF($A$4:$A$500,A352,$I$4:$I$500)-I352,\"\")","v":""}]
[null,null,null,null,null,null,null,null,0,{"$f":"IF(B353=\"Subtotal\",SUMIF($A$4:$A$500,A353,$I$4:$I$500)-I353,\"\")","v":""}]
[null,null,null,null,null,null,null,null,0,{"$f":"IF(B354=\"Subtotal\",SUMIF($A$4:$A$500,A354,$I$4:$I$500)-I354,\"\")","v":""}]
[null,null,null,null,null,null,null,null,0,{"$f":"IF(B355=\"Subtotal\",SUMIF($A$4:$A$500,A355,$I$4:$I$500)-I355,\"\")","v":""}]
[null,null,null,null,null,null,null,null,0,{"$f":"IF(B356=\"Subtotal\",SUMIF($A$4:$A$500,A356,$I$4:$I$500)-I356,\"\")","v":""}]
[null,null,null,null,null,null,null,null,0,{"$f":"IF(B357=\"Subtotal\",SUMIF($A$4:$A$500,A357,$I$4:$I$500)-I357,\"\")","v":""}]
[null,null,null,null,null,null,null,null,0,{"$f":"IF(B358=\"Subtotal\",SUMIF($A$4:$A$500,A358,$I$4:$I$500)-I358,\"\")","v":""}]
[null,null,null,null,null,null,null,null,0,{"$f":"IF(B359=\"Subtotal\",SUMIF($A$4:$A$500,A359,$I$4:$I$500)-I359,\"\")","v":""}]
[null,null,null,null,null,null,null,null,0,{"$f":"IF(B360=\"Subtotal\",SUMIF($A$4:$A$500,A360,$I$4:$I$500)-I360,\"\")","v":""}]
[null,null,null,null,null,null,null,null,0,{"$f":"IF(B361=\"Subtotal\",SUMIF($A$4:$A$500,A361,$I$4:$I$500)-I361,\"\")","v":""}]
[null,null,null,null,null,null,null,null,0,{"$f":"IF(B362=\"Subtotal\",SUMIF($A$4:$A$500,A362,$I$4:$I$500)-I362,\"\")","v":""}]
[null,null,null,null,null,null,null,null,0,{"$f":"IF(B363=\"Subtotal\",SUMIF($A$4:$A$500,A363,$I$4:$I$500)-I363,\"\")","v":""}]
[null,null,null,null,null,null,null,null,0,{"$f":"IF(B364=\"Subtotal\",SUMIF($A$4:$A$500,A364,$I$4:$I$500)-I364,\"\")","v":""}]
[null,null,null,null,null,null,null,null,0,{"$f":"IF(B365=\"Subtotal\",SUMIF($A$4:$A$500,A365,$I$4:$I$500)-I365,\"\")","v":""}]
[null,null,null,null,null,null,null,null,0,{"$f":"IF(B366=\"Subtotal\",SUMIF($A$4:$A$500,A366,$I$4:$I$500)-I366,\"\")","v":""}]
[null,null,null,null,null,null,null,null,0,{"$f":"IF(B367=\"Subtotal\",SUMIF($A$4:$A$500,A367,$I$4:$I$500)-I367,\"\")","v":""}]
[null,null,null,null,null,null,null,null,0,{"$f":"IF(B368=\"Subtotal\",SUMIF($A$4:$A$500,A368,$I$4:$I$500)-I368,\"\")","v":""}]
[null,null,null,null,null,null,null,null,{"$f":"IF(G369=\"\",H369,G369)","v":0},{"$f":"IF(B369=\"Subtotal\",SUMIF($A$4:$A$500,A369,$I$4:$I$500)-I369,\"\")","v":""}]
[null,null,null,null,null,null,null,null,0,{"$f":"IF(B370=\"Subtotal\",SUMIF($A$4:$A$500,A370,$I$4:$I$500)-I370,\"\")","v":""}]
[null,null,null,null,null,null,null,null,0,{"$f":"IF(B371=\"Subtotal\",SUMIF($A$4:$A$500,A371,$I$4:$I$500)-I371,\"\")","v":""}]
[null,null,null,null,null,null,null,null,0,{"$f":"IF(B372=\"Subtotal\",SUMIF($A$4:$A$500,A372,$I$4:$I$500)-I372,\"\")","v":""}]
[null,null,null,null,null,null,null,null,0,{"$f":"IF(B373=\"Subtotal\",SUMIF($A$4:$A$500,A373,$I$4:$I$500)-I373,\"\")","v":""}]
[null,null,null,null,null,null,null,null,0,{"$f":"IF(B374=\"Subtotal\",SUMIF($A$4:$A$500,A374,$I$4:$I$500)-I374,\"\")","v":""}]
[null,null,null,null,null,null,null,null,0,{"$f":"IF(B375=\"Subtotal\",SUMIF($A$4:$A$500,A375,$I$4:$I$500)-I375,\"\")","v":""}]
[null,null,null,null,null,null,null,null,0,{"$f":"IF(B376=\"Subtotal\",SUMIF($A$4:$A$500,A376,$I$4:$I$500)-I376,\"\")","v":""}]
[null,null,null,null,null,null,null,null,0,{"$f":"IF(B377=\"Subtotal\",SUMIF($A$4:$A$500,A377,$I$4:$I$500)-I377,\"\")","v":""}]
[null,null,null,null,null,null,null,null,0,{"$f":"IF(B378=\"Subtotal\",SUMIF($A$4:$A$500,A378,$I$4:$I$500)-I378,\"\")","v":""}]
[null,null,null,null,null,null,null,null,0,{"$f":"IF(B379=\"Subtotal\",SUMIF($A$4:$A$500,A379,$I$4:$I$500)-I379,\"\")","v":""}]
[null,null,null,null,null,null,null,null,0,{"$f":"IF(B380=\"Subtotal\",SUMIF($A$4:$A$500,A380,$I$4:$I$500)-I380,\"\")","v":""}]
[null,null,null,null,null,null,null,null,0,{"$f":"IF(B381=\"Subtotal\",SUMIF($A$4:$A$500,A381,$I$4:$I$500)-I381,\"\")","v":""}]
[null,null,null,null,null,null,null,null,0,{"$f":"IF(B382=\"Subtotal\",SUMIF($A$4:$A$500,A382,$I$4:$I$500)-I382,\"\")","v":""}]
[null,null,null,null,null,null,null,null,0,{"$f":"IF(B383=\"Subtotal\",SUMIF($A$4:$A$500,A383,$I$4:$I$500)-I383,\"\")","v":""}]
[null,null,null,null,null,null,null,null,0,{"$f":"IF(B384=\"Subtotal\",SUMIF($A$4:$A$500,A384,$I$4:$I$500)-I384,\"\")","v":""}]
[null,null,null,null,null,null,null,null,0,{"$f":"IF(B385=\"Subtotal\",SUMIF($A$4:$A$500,A385,$I$4:$I$500)-I385,\"\")","v":""}]
[null,null,null,null,null,null,null,null,0,{"$f":"IF(B386=\"Subtotal\",SUMIF($A$4:$A$500,A386,$I$4:$I$500)-I386,\"\")","v":""}]
[null,null,null,null,null,null,null,null,0,{"$f":"IF(B387=\"Subtotal\",SUMIF($A$4:$A$500,A387,$I$4:$I$500)-I387,\"\")","v":""}]
[null,null,null,null,null,null,null,null,0,{"$f":"IF(B388=\"Subtotal\",SUMIF($A$4:$A$500,A388,$I$4:$I$500)-I388,\"\")","v":""}]
[null,null,null,null,null,null,null,null,0,{"$f":"IF(B389=\"Subtotal\",SUMIF($A$4:$A$500,A389,$I$4:$I$500)-I389,\"\")","v":""}]
[null,null,null,null,null,null,null,null,0,{"$f":"IF(B390=\"Subtotal\",SUMIF($A$4:$A$500,A390,$I$4:$I$500)-I390,\"\")","v":""}]
[null,null,null,null,null,null,null,null,0,{"$f":"IF(B391=\"Subtotal\",SUMIF($A$4:$A$500,A391,$I$4:$I$500)-I391,\"\")","v":""}]
[null,null,null,null,null,null,null,null,0,{"$f":"IF(B392=\"Subtotal\",SUMIF($A$4:$A$500,A392,$I$4:$I$500)-I392,\"\")","v":""}]
[null,null,null,null,null,null,null,null,0,{"$f":"IF(B393=\"Subtotal\",SUMIF($A$4:$A$500,A393,$I$4:$I$500)-I393,\"\")","v":""}]
[null,null,null,null,null,null,null,null,0,{"$f":"IF(B394=\"Subtotal\",SUMIF($A$4:$A$500,A394,$I$4:$I$500)-I394,\"\")","v":""}]
[null,null,null,null,null,null,null,null,0,{"$f":"IF(B395=\"Subtotal\",SUMIF($A$4:$A$500,A395,$I$4:$I$500)-I395,\"\")","v":""}]
[null,null,null,null,null,null,null,null,0,{"$f":"IF(B396=\"Subtotal\",SUMIF($A$4:$A$500,A396,$I$4:$I$500)-I396,\"\")","v":""}]
[null,null,null,null,null,null,null,null,0,{"$f":"IF(B397=\"Subtotal\",SUMIF($A$4:$A$500,A397,$I$4:$I$500)-I397,\"\")","v":""}]
[null,null,null,null,null,null,null,null,0,{"$f":"IF(B398=\"Subtotal\",SUMIF($A$4:$A$500,A398,$I$4:$I$500)-I398,\"\")","v":""}]
[null,null,null,null,null,null,null,null,0,{"$f":"IF(B399=\"Subtotal\",SUMIF($A$4:$A$500,A399,$I$4:$I$500)-I399,\"\")","v":""}]
[null,null,null,null,null,null,null,null,0,{"$f":"IF(B400=\"Subtotal\",SUMIF($A$4:$A$500,A400,$I$4:$I$500)-I400,\"\")","v":""}]
[null,null,null,null,null,null,null,null,0,{"$f":"IF(B401=\"Subtotal\",SUMIF($A$4:$A$500,A401,$I$4:$I$500)-I401,\"\")","v":""}]
[null,null,null,null,null,null,null,null,0,{"$f":"IF(B402=\"Subtotal\",SUMIF($A$4:$A$500,A402,$I$4:$I$500)-I402,\"\")","v":""}]
[null,null,null,null,null,null,null,null,0,{"$f":"IF(B403=\"Subtotal\",SUMIF($A$4:$A$500,A403,$I$4:$I$500)-I403,\"\")","v":""}]
[null,null,null,null,null,null,null,null,0,{"$f":"IF(B404=\"Subtotal\",SUMIF($A$4:$A$500,A404,$I$4:$I$500)-I404,\"\")","v":""}]
[null,null,null,null,null,null,null,null,0,{"$f":"IF(B405=\"Subtotal\",SUMIF($A$4:$A$500,A405,$I$4:$I$500)-I405,\"\")","v":""}]
[null,null,null,null,null,null,null,null,0,{"$f":"IF(B406=\"Subtotal\",SUMIF($A$4:$A$500,A406,$I$4:$I$500)-I406,\"\")","v":""}]
[null,null,null,null,null,null,null,null,0,{"$f":"IF(B407=\"Subtotal\",SUMIF($A$4:$A$500,A407,$I$4:$I$500)-I407,\"\")","v":""}]
[null,null,null,null,null,null,null,null,0,{"$f":"IF(B408=\"Subtotal\",SUMIF($A$4:$A$500,A408,$I$4:$I$500)-I408,\"\")","v":""}]
[null,null,null,null,null,null,null,null,0,{"$f":"IF(B409=\"Subtotal\",SUMIF($A$4:$A$500,A409,$I$4:$I$500)-I409,\"\")","v":""}]
[null,null,null,null,null,null,null,null,0,{"$f":"IF(B410=\"Subtotal\",SUMIF($A$4:$A$500,A410,$I$4:$I$500)-I410,\"\")","v":""}]
[null,null,null,null,null,null,null,null,0,{"$f":"IF(B411=\"Subtotal\",SUMIF($A$4:$A$500,A411,$I$4:$I$500)-I411,\"\")","v":""}]
[null,null,null,null,null,null,null,null,0,{"$f":"IF(B412=\"Subtotal\",SUMIF($A$4:$A$500,A412,$I$4:$I$500)-I412,\"\")","v":""}]
[null,null,null,null,null,null,null,null,0,{"$f":"IF(B413=\"Subtotal\",SUMIF($A$4:$A$500,A413,$I$4:$I$500)-I413,\"\")","v":""}]
[null,null,null,null,null,null,null,null,0,{"$f":"IF(B414=\"Subtotal\",SUMIF($A$4:$A$500,A414,$I$4:$I$500)-I414,\"\")","v":""}]
[null,null,null,null,null,null,null,null,0,{"$f":"IF(B415=\"Subtotal\",SUMIF($A$4:$A$500,A415,$I$4:$I$500)-I415,\"\")","v":""}]
[null,null,null,null,null,null,null,null,0,{"$f":"IF(B416=\"Subtotal\",SUMIF($A$4:$A$500,A416,$I$4:$I$500)-I416,\"\")","v":""}]
[null,null,null,null,null,null,null,null,0,{"$f":"IF(B417=\"Subtotal\",SUMIF($A$4:$A$500,A417,$I$4:$I$500)-I417,\"\")","v":""}]
[null,null,null,null,null,null,null,null,0,{"$f":"IF(B418=\"Subtotal\",SUMIF($A$4:$A$500,A418,$I$4:$I$500)-I418,\"\")","v":""}]
[null,null,null,null,null,null,null,null,0,{"$f":"IF(B419=\"Subtotal\",SUMIF($A$4:$A$500,A419,$I$4:$I$500)-I419,\"\")","v":""}]
[null,null,null,null,null,null,null,null,0,{"$f":"IF(B420=\"Subtotal\",SUMIF($A$4:$A$500,A420,$I$4:$I$500)-I420,\"\")","v":""}]
[null,null,null,null,null,null,null,null,0,{"$f":"IF(B421=\"Subtotal\",SUMIF($A$4:$A$500,A421,$I$4:$I$500)-I421,\"\")","v":""}]
[null,null,null,null,null,null,null,null,0,{"$f":"IF(B422=\"Subtotal\",SUMIF($A$4:$A$500,A422,$I$4:$I$500)-I422,\"\")","v":""}]
[null,null,null,null,null,null,null,null,0,{"$f":"IF(B423=\"Subtotal\",SUMIF($A$4:$A$500,A423,$I$4:$I$500)-I423,\"\")","v":""}]
[null,null,null,null,null,null,null,null,0,{"$f":"IF(B424=\"Subtotal\",SUMIF($A$4:$A$500,A424,$I$4:$I$500)-I424,\"\")","v":""}]
[null,null,null,null,null,null,null,null,0,{"$f":"IF(B425=\"Subtotal\",SUMIF($A$4:$A$500,A425,$I$4:$I$500)-I425,\"\")","v":""}]
[null,null,null,null,null,null,null,null,0,{"$f":"IF(B426=\"Subtotal\",SUMIF($A$4:$A$500,A426,$I$4:$I$500)-I426,\"\")","v":""}]
[null,null,null,null,null,null,null,null,0,{"$f":"IF(B427=\"Subtotal\",SUMIF($A$4:$A$500,A427,$I$4:$I$500)-I427,\"\")","v":""}]
[null,null,null,null,null,null,null,null,0,{"$f":"IF(B428=\"Subtotal\",SUMIF($A$4:$A$500,A428,$I$4:$I$500)-I428,\"\")","v":""}]
[null,null,null,null,null,null,null,null,0,{"$f":"IF(B429=\"Subtotal\",SUMIF($A$4:$A$500,A429,$I$4:$I$500)-I429,\"\")","v":""}]
[null,null,null,null,null,null,null,null,0,{"$f":"IF(B430=\"Subtotal\",SUMIF($A$4:$A$500,A430,$I$4:$I$500)-I430,\"\")","v":""}]
[null,null,null,null,null,null,null,null,0,{"$f":"IF(B431=\"Subtotal\",SUMIF($A$4:$A$500,A431,$I$4:$I$500)-I431,\"\")","v":""}]
[null,null,null,null,null,null,null,null,0,{"$f":"IF(B432=\"Subtotal\",SUMIF($A$4:$A$500,A432,$I$4:$I$500)-I432,\"\")","v":""}]
[null,null,null,null,null,null,null,null,{"$f":"IF(G433=\"\",H433,G433)","v":0},{"$f":"IF(B433=\"Subtotal\",SUMIF($A$4:$A$500,A433,$I$4:$I$500)-I433,\"\")","v":""}]
[null,null,null,null,null,null,null,null,0,{"$f":"IF(B434=\"Subtotal\",SUMIF($A$4:$A$500,A434,$I$4:$I$500)-I434,\"\")","v":""}]
[null,null,null,null,null,null,null,null,0,{"$f":"IF(B435=\"Subtotal\",SUMIF($A$4:$A$500,A435,$I$4:$I$500)-I435,\"\")","v":""}]
[null,null,null,null,null,null,null,null,0,{"$f":"IF(B436=\"Subtotal\",SUMIF($A$4:$A$500,A436,$I$4:$I$500)-I436,\"\")","v":""}]
[null,null,null,null,null,null,null,null,0,{"$f":"IF(B437=\"Subtotal\",SUMIF($A$4:$A$500,A437,$I$4:$I$500)-I437,\"\")","v":""}]
[null,null,null,null,null,null,null,null,0,{"$f":"IF(B438=\"Subtotal\",SUMIF($A$4:$A$500,A438,$I$4:$I$500)-I438,\"\")","v":""}]
[null,null,null,null,null,null,null,null,0,{"$f":"IF(B439=\"Subtotal\",SUMIF($A$4:$A$500,A439,$I$4:$I$500)-I439,\"\")","v":""}]
[null,null,null,null,null,null,null,null,0,{"$f":"IF(B440=\"Subtotal\",SUMIF($A$4:$A$500,A440,$I$4:$I$500)-I440,\"\")","v":""}]
[null,null,null,null,null,null,null,null,0,{"$f":"IF(B441=\"Subtotal\",SUMIF($A$4:$A$500,A441,$I$4:$I$500)-I441,\"\")","v":""}]
[null,null,null,null,null,null,null,null,0,{"$f":"IF(B442=\"Subtotal\",SUMIF($A$4:$A$500,A442,$I$4:$I$500)-I442,\"\")","v":""}]
[null,null,null,null,null,null,null,null,0,{"$f":"IF(B443=\"Subtotal\",SUMIF($A$4:$A$500,A443,$I$4:$I$500)-I443,\"\")","v":""}]
[null,null,null,null,null,null,null,null,0,{"$f":"IF(B444=\"Subtotal\",SUMIF($A$4:$A$500,A444,$I$4:$I$500)-I444,\"\")","v":""}]
[null,null,null,null,null,null,null,null,0,{"$f":"IF(B445=\"Subtotal\",SUMIF($A$4:$A$500,A445,$I$4:$I$500)-I445,\"\")","v":""}]
[null,null,null,null,null,null,null,null,0,{"$f":"IF(B446=\"Subtotal\",SUMIF($A$4:$A$500,A446,$I$4:$I$500)-I446,\"\")","v":""}]
[null,null,null,null,null,null,null,null,0,{"$f":"IF(B447=\"Subtotal\",SUMIF($A$4:$A$500,A447,$I$4:$I$500)-I447,\"\")","v":""}]
[null,null,null,null,null,null,null,null,0,{"$f":"IF(B448=\"Subtotal\",SUMIF($A$4:$A$500,A448,$I$4:$I$500)-I448,\"\")","v":""}]
[null,null,null,null,null,null,null,null,0,{"$f":"IF(B449=\"Subtotal\",SUMIF($A$4:$A$500,A449,$I$4:$I$500)-I449,\"\")","v":""}]
[null,null,null,null,null,null,null,null,0,{"$f":"IF(B450=\"Subtotal\",SUMIF($A$4:$A$500,A450,$I$4:$I$500)-I450,\"\")","v":""}]
[null,null,null,null,null,null,null,null,0,{"$f":"IF(B451=\"Subtotal\",SUMIF($A$4:$A$500,A451,$I$4:$I$500)-I451,\"\")","v":""}]
[null,null,null,null,null,null,null,null,0,{"$f":"IF(B452=\"Subtotal\",SUMIF($A$4:$A$500,A452,$I$4:$I$500)-I452,\"\")","v":""}]
[null,null,null,null,null,null,null,null,0,{"$f":"IF(B453=\"Subtotal\",SUMIF($A$4:$A$500,A453,$I$4:$I$500)-I453,\"\")","v":""}]
[null,null,null,null,null,null,null,null,0,{"$f":"IF(B454=\"Subtotal\",SUMIF($A$4:$A$500,A454,$I$4:$I$500)-I454,\"\")","v":""}]
[null,null,null,null,null,null,null,null,0,{"$f":"IF(B455=\"Subtotal\",SUMIF($A$4:$A$500,A455,$I$4:$I$500)-I455,\"\")","v":""}]
[null,null,null,null,null,null,null,null,0,{"$f":"IF(B456=\"Subtotal\",SUMIF($A$4:$A$500,A456,$I$4:$I$500)-I456,\"\")","v":""}]
[null,null,null,null,null,null,null,null,0,{"$f":"IF(B457=\"Subtotal\",SUMIF($A$4:$A$500,A457,$I$4:$I$500)-I457,\"\")","v":""}]
[null,null,null,null,null,null,null,null,0,{"$f":"IF(B458=\"Subtotal\",SUMIF($A$4:$A$500,A458,$I$4:$I$500)-I458,\"\")","v":""}]
[null,null,null,null,null,null,null,null,0,{"$f":"IF(B459=\"Subtotal\",SUMIF($A$4:$A$500,A459,$I$4:$I$500)-I459,\"\")","v":""}]
[null,null,null,null,null,null,null,null,0,{"$f":"IF(B460=\"Subtotal\",SUMIF($A$4:$A$500,A460,$I$4:$I$500)-I460,\"\")","v":""}]
[null,null,null,null,null,null,null,null,0,{"$f":"IF(B461=\"Subtotal\",SUMIF($A$4:$A$500,A461,$I$4:$I$500)-I461,\"\")","v":""}]
[null,null,null,null,null,null,null,null,0,{"$f":"IF(B462=\"Subtotal\",SUMIF($A$4:$A$500,A462,$I$4:$I$500)-I462,\"\")","v":""}]
[null,null,null,null,null,null,null,null,0,{"$f":"IF(B463=\"Subtotal\",SUMIF($A$4:$A$500,A463,$I$4:$I$500)-I463,\"\")","v":""}]
[null,null,null,null,null,null,null,null,0,{"$f":"IF(B464=\"Subtotal\",SUMIF($A$4:$A$500,A464,$I$4:$I$500)-I464,\"\")","v":""}]
[null,null,null,null,null,null,null,null,0,{"$f":"IF(B465=\"Subtotal\",SUMIF($A$4:$A$500,A465,$I$4:$I$500)-I465,\"\")","v":""}]
[null,null,null,null,null,null,null,null,0,{"$f":"IF(B466=\"Subtotal\",SUMIF($A$4:$A$500,A466,$I$4:$I$500)-I466,\"\")","v":""}]
[null,null,null,null,null,null,null,null,0,{"$f":"IF(B467=\"Subtotal\",SUMIF($A$4:$A$500,A467,$I$4:$I$500)-I467,\"\")","v":""}]
[null,null,null,null,null,null,null,null,0,{"$f":"IF(B468=\"Subtotal\",SUMIF($A$4:$A$500,A468,$I$4:$I$500)-I468,\"\")","v":""}]
[null,null,null,null,null,null,null,null,0,{"$f":"IF(B469=\"Subtotal\",SUMIF($A$4:$A$500,A469,$I$4:$I$500)-I469,\"\")","v":""}]
[null,null,null,null,null,null,null,null,0,{"$f":"IF(B470=\"Subtotal\",SUMIF($A$4:$A$500,A470,$I$4:$I$500)-I470,\"\")","v":""}]
[null,null,null,null,null,null,null,null,0,{"$f":"IF(B471=\"Subtotal\",SUMIF($A$4:$A$500,A471,$I$4:$I$500)-I471,\"\")","v":""}]
[null,null,null,null,null,null,null,null,0,{"$f":"IF(B472=\"Subtotal\",SUMIF($A$4:$A$500,A472,$I$4:$I$500)-I472,\"\")","v":""}]
[null,null,null,null,null,null,null,null,0,{"$f":"IF(B473=\"Subtotal\",SUMIF($A$4:$A$500,A473,$I$4:$I$500)-I473,\"\")","v":""}]
[null,null,null,null,null,null,null,null,0,{"$f":"IF(B474=\"Subtotal\",SUMIF($A$4:$A$500,A474,$I$4:$I$500)-I474,\"\")","v":""}]
[null,null,null,null,null,null,null,null,0,{"$f":"IF(B475=\"Subtotal\",SUMIF($A$4:$A$500,A475,$I$4:$I$500)-I475,\"\")","v":""}]
[null,null,null,null,null,null,null,null,0,{"$f":"IF(B476=\"Subtotal\",SUMIF($A$4:$A$500,A476,$I$4:$I$500)-I476,\"\")","v":""}]
[null,null,null,null,null,null,null,null,0,{"$f":"IF(B477=\"Subtotal\",SUMIF($A$4:$A$500,A477,$I$4:$I$500)-I477,\"\")","v":""}]
[null,null,null,null,null,null,null,null,0,{"$f":"IF(B478=\"Subtotal\",SUMIF($A$4:$A$500,A478,$I$4:$I$500)-I478,\"\")","v":""}]
[null,null,null,null,null,null,null,null,0,{"$f":"IF(B479=\"Subtotal\",SUMIF($A$4:$A$500,A479,$I$4:$I$500)-I479,\"\")","v":""}]
[null,null,null,null,null,null,null,null,0,{"$f":"IF(B480=\"Subtotal\",SUMIF($A$4:$A$500,A480,$I$4:$I$500)-I480,\"\")","v":""}]
[null,null,null,null,null,null,null,null,0,{"$f":"IF(B481=\"Subtotal\",SUMIF($A$4:$A$500,A481,$I$4:$I$500)-I481,\"\")","v":""}]
[null,null,null,null,null,null,null,null,0,{"$f":"IF(B482=\"Subtotal\",SUMIF($A$4:$A$500,A482,$I$4:$I$500)-I482,\"\")","v":""}]
[null,null,null,null,null,null,null,null,0,{"$f":"IF(B483=\"Subtotal\",SUMIF($A$4:$A$500,A483,$I$4:$I$500)-I483,\"\")","v":""}]
[null,null,null,null,null,null,null,null,0,{"$f":"IF(B484=\"Subtotal\",SUMIF($A$4:$A$500,A484,$I$4:$I$500)-I484,\"\")","v":""}]
[null,null,null,null,null,null,null,null,0,{"$f":"IF(B485=\"Subtotal\",SUMIF($A$4:$A$500,A485,$I$4:$I$500)-I485,\"\")","v":""}]
[null,null,null,null,null,null,null,null,0,{"$f":"IF(B486=\"Subtotal\",SUMIF($A$4:$A$500,A486,$I$4:$I$500)-I486,\"\")","v":""}]
[null,null,null,null,null,null,null,null,0,{"$f":"IF(B487=\"Subtotal\",SUMIF($A$4:$A$500,A487,$I$4:$I$500)-I487,\"\")","v":""}]
[null,null,null,null,null,null,null,null,0,{"$f":"IF(B488=\"Subtotal\",SUMIF($A$4:$A$500,A488,$I$4:$I$500)-I488,\"\")","v":""}]
[null,null,null,null,null,null,null,null,0,{"$f":"IF(B489=\"Subtotal\",SUMIF($A$4:$A$500,A489,$I$4:$I$500)-I489,\"\")","v":""}]
[null,null,null,null,null,null,null,null,0,{"$f":"IF(B490=\"Subtotal\",SUMIF($A$4:$A$500,A490,$I$4:$I$500)-I490,\"\")","v":""}]
[null,null,null,null,null,null,null,null,0,{"$f":"IF(B491=\"Subtotal\",SUMIF($A$4:$A$500,A491,$I$4:$I$500)-I491,\"\")","v":""}]
[null,null,null,null,null,null,null,null,0,{"$f":"IF(B492=\"Subtotal\",SUMIF($A$4:$A$500,A492,$I$4:$I$500)-I492,\"\")","v":""}]
[null,null,null,null,null,null,null,null,0,{"$f":"IF(B493=\"Subtotal\",SUMIF($A$4:$A$500,A493,$I$4:$I$500)-I493,\"\")","v":""}]
[null,null,null,null,null,null,null,null,0,{"$f":"IF(B494=\"Subtotal\",SUMIF($A$4:$A$500,A494,$I$4:$I$500)-I494,\"\")","v":""}]
[null,null,null,null,null,null,null,null,0,{"$f":"IF(B495=\"Subtotal\",SUMIF($A$4:$A$500,A495,$I$4:$I$500)-I495,\"\")","v":""}]
[null,null,null,null,null,null,null,null,0,{"$f":"IF(B496=\"Subtotal\",SUMIF($A$4:$A$500,A496,$I$4:$I$500)-I496,\"\")","v":""}]
[null,null,null,null,null,null,null,null,{"$f":"IF(G497=\"\",H497,G497)","v":0},{"$f":"IF(B497=\"Subtotal\",SUMIF($A$4:$A$500,A497,$I$4:$I$500)-I497,\"\")","v":""}]
[null,null,null,null,null,null,null,null,0,{"$f":"IF(B498=\"Subtotal\",SUMIF($A$4:$A$500,A498,$I$4:$I$500)-I498,\"\")","v":""}]
[null,null,null,null,null,null,null,null,0,{"$f":"IF(B499=\"Subtotal\",SUMIF($A$4:$A$500,A499,$I$4:$I$500)-I499,\"\")","v":""}]
[null,null,null,null,null,null,null,null,0,{"$f":"IF(B500=\"Subtotal\",SUMIF($A$4:$A$500,A500,$I$4:$I$500)-I500,\"\")","v":""}]
["Totals",null,"No. of Projects:",{"$f":"SUBTOTAL(3,E4:E500)","v":210},"Sum of Awarded Sales:",{"$f":"SUBTOTAL(9,G4:G500)","v":1276627429.3319998},"Sum of Estimated Sales:",{"$f":"SUBTOTAL(9,J4:J500)","v":2540567266.0819998}]

{"sheet":"Work Types","index":1,"n_rows":163,"n_cols":3,"rows_kept":163,"cut":false,"hidden":false,"merged":[]}
[]
[]
[null,"Values"]
["Project Work Category by Year","No. of Projects","Sum Amount"]
["-",8,0]
["Signs",4,0]
["Intersection Improvement",1,0]
["Noise Wall",1,0]
["Bridge Repair",2,0]
[]
[1998,1,15126788.732999999]
["New Construction",1,15126788.732999999]
[]
[2000,6,124158914.73899999]
["Major Reconstruction",3,49031423.158999994]
["Bridge Replacement",1,3228037.6009999998]
["Major Widening",1,49534522.074000001]
["Minor Rehabilitation - Pavement Prmy Sys",1,22364931.905000001]
[]
[2001,11,104694185.772]
["Bridge Repair",3,4945616.3370000003]
["Bridge Replacement",1,4508109.0420000004]
["Minor Rehabilitation - Pavement Prmy Sys",1,16821520.425999999]
["Resurfacing, Divided System",5,74389024.210999995]
["Resurfacing,  Undivided System",1,4029915.7560000001]
[]
[2002,9,5187434.1550000003]
["Bridge Repair",2,1384513.139]
["Bridge Replacement",6,3676035.3569999998]
["Major Widening",1,126885.659]
[]
[2003,23,50050637.387000009]
["Noise Wall",1,571530.03899999999]
["Bridge Repair",6,18801356.026000001]
["Major Reconstruction",1,5260233.9570000004]
["Bridge Replacement",11,8254862.9389999993]
["Resurfacing, Divided System",2,14386797.015000001]
["Lighting",1,2251812.0159999998]
["Culvert Construction/Reconstr/Repair",1,524045.39500000002]
[]
[2004,7,12047053.781999998]
["Signs",3,1526739.4380000001]
["Noise Wall",1,7891961.2400000002]
["Bridge Repair",1,492600.62400000001]
["Bridge Replacement",1,340560.01899999997]
["Resurfacing,  Undivided System",1,1795192.4609999999]
[]
[2005,4,33958855.446000002]
["Noise Wall",1,9338893.4110000003]
["Bridge Repair",1,2323913.5660000001]
["Bridge Replacement",1,440897.71299999999]
["Major Rehabilitation",1,21855150.756000001]
[]
[2006,4,9070394.2080000006]
["Bridge Repair",2,1563654.452]
["Bridge Replacement",1,1583075.581]
["Resurfacing, Divided System",1,5923664.1749999998]
[]
[2007,2,8042176.4339999994]
["Noise Wall",1,6408455.5039999997]
["Bridge Replacement",1,1633720.93]
[]
[2008,5,9426925.9940000009]
["Noise Wall",1,4435007.7520000003]
["Bridge Repair",3,4457323.9110000003]
["Bridge Replacement",1,534594.33100000001]
[]
[2009,5,14069570.888000002]
["Signs",1,459783.527]
["Bridge Repair",1,10971100.426000001]
["Bridge Replacement",2,1377672.206]
["Slide Repair",1,1261014.7290000001]
[]
[2010,25,85197364.753000021]
["Signs",1,779020.22100000002]
["Noise Wall",1,5247566.085]
["Bridge Repair",4,15569160.748]
["Major Reconstruction",1,25534892.589000002]
["Bridge Replacement",5,4588129.88]
["Minor Rehabilitation - Pavement Prmy Sys",1,7018498.1610000003]
["Major Rehabilitation",2,12417354.058]
["Bridge Deck Replacement",5,9780768.0889999997]
["Bridge Maintenance",1,266187.59700000001]
["Inter-modal Facility",2,3634702.3250000002]
["Buildings - Mix Shed,etc.",2,361085]
[]
[2011,19,582665386.75699997]
["Signs",1,1324784.3019999999]
["Bridge Repair",1,1910364.341]
["Major Reconstruction",1,218210658.91499999]
["Bridge Replacement",7,13090586.83]
["Minor Rehabilitation - Pavement Prmy Sys",2,25015927.520999998]
["Culvert Construction/Reconstr/Repair",1,161111.579]
["Bridge Deck Replacement",2,1891125.0979999998]
["Salt Dome",1,762403.10100000002]
["Signing",1,5220095.6119999997]
["Noise Wall Maintenance/Repair (NEW)",1,2057399.2250000001]
["New Bridge",1,313020930.23299998]
[]
[2012,13,119381748.32699999]
["Signs",2,2075043.4100000001]
["Noise Wall",1,281000]
["Bridge Repair",1,4192732.3840000001]
["Bridge Replacement",2,2060662.31]
["Major Widening",2,99941746.282999992]
["Bridge Deck Replacement",3,10352176.688000001]
["Dock Facilities",1,374918.26]
["Facility Renovation",1,103468.992]
[]
[2013,25,134019292.95700002]
["Signs",3,1849197.8299999998]
["Noise Wall",1,730382.17099999997]
["Bridge Replacement",7,6536095.5029999996]
["Major Widening",2,84797829.457000002]
["Minor Rehabilitation - Pavement Prmy Sys",3,27328324.008000001]
["Culvert Construction/Reconstr/Repair",1,639002.58200000005]
["Bridge Deck Replacement",3,1776027.7489999998]
["Guardrail Maintenance/Repair (NEW)",1,3389889.2439999999]
["Spot Safety",1,662092.63600000006]
["Interchange, Reconstruction",1,3859420.64]
["Mill and Fill",1,2236632.4939999999]
["Drainage Improvement",1,214398.64300000001]
[]
[2014,24,598452360.79999995]
["Intersection Improvement",1,2482300]
["Noise Wall",1,5500000]
["Bridge Repair",3,15257000]
["Major Reconstruction",2,112439046.65000001]
["Bridge Replacement",4,376764856]
["Major Rehabilitation",1,33500000]
["Bridge Deck Replacement",7,12572443]
["Spot Safety",1,2700000]
["Interchange, Reconstruction",1,13432600]
["Section Improvement",1,5905000]
["Minor Rehabilitation - Pavement Gnrl Sys",1,15622000]
["Turn Lane Addition",1,2277115.15]
[]
[2015,5,56011089.950000003]
["Bridge Repair",1,440000]
["Bridge Replacement",2,2808289.95]
["Major Widening",1,51500000]
["Bridge Deck Replacement",1,1262800]
[]
[2016,6,153418300]
["Bridge Replacement",2,2121400]
["Minor Rehabilitation - Pavement Prmy Sys",1,16663900]
["Major Rehabilitation",1,134269000]
["Interchange, Reconstruction",1,0]
["Signals",1,364000]
[]
[2017,2,11743000]
["Bridge Replacement",1,1043000]
["New Bridge",1,10700000]
[]
[2018,5,402845785]
["Noise Wall",1,1100000]
["Bridge Replacement",3,2795785]
["Major Rehabilitation",1,398950000]
[]
[2025,1,11000000]
["Interchange, Reconstruction",1,11000000]
[]
["Grand Total",210,2540567266.0819998]

{"sheet":"Data from CAS-TAS","index":2,"n_rows":86,"n_cols":9,"rows_kept":86,"cut":false,"hidden":false,"merged":[]}
["Design Build Projects as recorded in ODOT CMS computer system"]
["Query: Design Build_ImportPID from Ellis (run in CAS-TAS)",null,null,null,null,null,null,"Updated:","2013-06-05T17:41:46"]
["District","PID","Project Number ","Project Status","Original Contract Amount ($)","Total Paid-to-Date Amount ($)","% Complete","Letting Date","Current Completion Date"]
[]
[8410,7,980233,"Complete",13888653,15435365.640000001,100,"1998-05-13","2001-09-20"]
[11160,7,993001,"Complete",45480095,51280525.340000004,99.38,"2000-02-01","2004-08-18"]
[18200,3,3002,"Complete",17312975,19709213.629999999,100,"2000-03-01","2002-10-31"]
[18703,4,3005,"Complete",2963821,3330523.08,104.72,"2000-03-15","2001-08-01"]
[18899,8,3003,"Complete",20534350.289999999,21107859.219999999,99.82,"2000-03-15","2002-09-15"]
[20681,6,3009,"Complete",3686600,3905853.05,100,"2000-04-12","2002-01-18"]
[20411,4,3008,"Complete",24018600,26030515.699999999,100,"2000-05-16","2003-06-30"]
[21082,1,3010,"Complete",2171900,2308256.41,100,"2000-09-27","2001-11-25"]
[19786,8,3012,"Complete",29509560.280000001,31747888.57,99.73,"2000-11-08","2005-09-15"]
[17891,3,3015,"Complete",13838853.460000001,14801828.470000001,100,"2000-11-29","2002-08-31"]
[18722,4,13000,"Complete",4139117.91,4215940.68,99.55,"2001-01-24","2002-10-30"]
[12761,11,13003,"Complete",9192000,9816715.9000000004,100,"2001-02-07","2003-03-18"]
[21053,10,13001,"Complete",1744180,2082260.74,99.95,"2001-02-14","2002-08-09"]
[22163,4,13002,"Complete",4933370.3899999997,4990467.79,100,"2001-02-14","2002-06-30"]
[12412,8,13006,"Complete",15444670,16099823.77,100,"2001-02-21","2002-10-22"]
[19899,4,13005,"Complete",624735,648052.35,100,"2001-02-21","2002-05-30"]
[19705,8,13009,"Complete",10826458.74,11863517.84,100,"2001-03-20","2005-10-15"]
[19854,4,13010,"Complete",3700065,4366233.5599999996,100,"2001-04-25","2002-08-31"]
[21713,8,13011,"Complete",241400,238398.27,100,"2001-09-05","2002-08-23"]
[21490,1,13012,"Complete",329590,333706,98.41,"2001-10-03","2002-07-06"]
[22516,2,13014,"Complete",941600,361098.91,100,"2001-12-12","2002-10-31"]
[19669,7,13013,"Complete",281450,286494,100,"2001-12-19","2003-05-01"]
[22174,4,23000,"Complete",9259925,9560630.25,100,"2002-09-25","2004-09-05"]
[22229,4,23001,"Complete",1410800,1474224.02,100,"2002-09-25","2003-08-31"]
[24384,7,23002,"Complete",215850,215850,100,"2002-09-25","2003-05-24"]
[19791,4,23003,"Complete",4764330,6391719.5700000003,100,"2002-11-20","2004-10-28"]
[18718,4,23004,"Complete",999400,1046734,102.94,"2002-11-22","2003-11-15"]
[12769,6,23006,"Complete",2724570,4297652.42,113.17,"2002-12-06","2004-10-07"]
[19821,5,23005,"Complete",1997110,2412918.2000000002,108.83,"2002-12-06","2005-10-09"]
[20996,11,23008,"Complete",8444900,9857105.9600000009,100,"2002-12-18","2004-06-30"]
[23929,4,23007,"Complete",2067500,2075212,100,"2002-12-18","2004-06-12"]
[24369,5,33000,"Complete",481152,494650,104.21,"2003-01-08","2003-10-31"]
[23997,6,33001,"Complete",524750,530171.91,100,"2003-02-12","2004-05-12"]
[24102,2,33002,"Complete",1648255,1924836.97,99.97,"2003-09-24","2004-09-10"]
[19572,11,33003,"Complete",543450,540950,100,"2003-10-22","2005-04-30"]
[19575,11,33004,"Complete",523825,600366.31000000006,100,"2003-10-22","2005-10-31"]
[19670,7,33005,"Complete",312685,332462.65000000002,100,"2003-10-22","2004-08-30"]
[75172,2,33006,"Complete",334500,446670.7,99.78,"2003-11-19","2004-08-03"]
[21607,1,33007,"Complete",452281,442893.63,100,"2003-12-03","2004-09-01"]
[75280,6,43000,"Complete",7246000,5852910.8899999997,100,"2004-03-24","2006-10-15"]
[25295,7,43001,"Complete",404810,398314,100,"2004-09-22","2005-06-15"]
[76564,6,43002,"Complete",2133700,2303861.04,102.67,"2004-11-23","2008-09-27"]
[76160,10,53000,"Complete",20066295,21611278.73,100,"2005-02-02","2007-09-01"]
[75279,6,53001,"Complete",8574500,8826800.9600000009,100,"2005-06-08","2007-05-27"]
[25499,8,53002,"Complete",5438809.0999999996,5523297.5899999999,99.95,"2005-09-21","2006-11-28"]
[25072,4,53003,"Complete",603818.5,605275.82999999996,100,"2005-12-02","2006-10-15"]
[23703,4,53004,"Complete",831850,804726.55,98.24,"2005-12-14","2006-10-22"]
[79599,12,63000,"Complete",5883920,6253772.4400000004,100,"2006-09-06","2008-06-03"]
[23753,4,73000,"Complete",1863902,1846334.53,100,"2007-10-12","2009-06-30"]
[75633,8,73001,"Complete",1618150,1638023.9,100,"2007-10-12","2009-07-31"]
[20375,3,83000,"Complete",610437.56999999995,606084.47,100,"2008-01-25","2008-10-24"]
[81281,6,83001,"Complete",4072000,4124470.38,100,"2008-06-04","2009-07-31"]
[80922,11,83002,"Complete",422150,421399,100,"2008-09-24","2009-12-31"]
[25277,4,83003,"Complete",10073110,9983977.9700000007,100,"2008-10-08","2010-11-19"]
[23302,8,93001,"Complete",1157800,1156302.46,100,"2009-04-29","2011-05-31"]
[84497,8,93002,"Complete",6444030.3399999999,6644503.1900000004,100,"2009-07-15","2011-09-15"]
[78478,11,93003,"Complete",715257,749454.25,100,"2009-09-30","2011-01-03"]
[25223,4,93004,"Complete",12840852.35,12936414.689999999,100,"2009-11-04","2011-11-15"]
[76825,11,93005,"Complete",23444848,25158533.359999999,100,"2009-12-09","2012-06-18"]
[85537,6,103001,"Complete",4818050,4889268.43,100,"2010-02-25","2011-08-10"]
[81587,11,103002,"Complete",4316685,4468724.88,100,"2010-03-25","2011-07-12"]
[82163,1,103004,"Complete",1592220,1622383.91,100,"2010-05-06","2011-11-18"]
[87863,11,103003,"Complete",135630,135630,100,"2010-05-07","2011-06-06"]
[84604,3,103007,"Complete",695369,675648.62,97.97,"2010-05-13","2011-09-01"]
[87864,11,103005,"Complete",195900,195900,100,"2010-05-21","2010-12-23"]
[80196,3,103011,"Complete",659000,693468.65,100,"2010-06-03","2011-09-30"]
[83445,3,103014,"Complete",924250,928607.66,100,"2010-06-03","2011-09-30"]
[83446,3,103009,"Complete",457067,455952.46,100,"2010-06-03","2011-10-12"]
[86254,3,103013,"Complete",1276600,1331205.1499999999,100,"2010-06-03","2012-05-15"]
[87632,12,103010,"Complete",3804674,2720071.24,71.290000000000006,"2010-06-03","2011-10-23"]
[87633,12,103012,"Complete",2580180,2310637.71,89.5,"2010-06-03","2011-11-13"]
[87879,11,100397,"Complete",731111.28,706265.1,100,"2010-06-03","2010-10-10"]
[84564,1,103015,"Complete",659060.5,635841.73,100,"2010-07-29","2011-08-26"]
[85531,12,103000,"Complete",287400000,51065668.450000003,17.670000000000002,"2010-08-05","2014-09-30"]
[25501,4,103016,"Complete",10744152,8812767.5,81.2,"2010-10-07","2012-05-17"]
[79855,9,103018,"Complete",1340680,1343713.81,100,"2010-10-21","2012-05-07"]
[86995,4,103017,"Complete",1077275,1082860.5,100,"2010-10-21","2011-10-17"]
[87966,4,103019,"Complete",1754000,1743326,100,"2010-10-21","2011-11-30"]
[84631,4,103021,"Complete",782000,761642.5,100,"2010-12-02","2011-09-30"]
[84323,11,103020,"Complete",1216350,1231724.3500000001,100,"2010-12-16","2012-05-15"]
[88662,3,113002,"Complete",147924.51,152150.65,100,"2011-03-24","2012-05-15"]
[88375,3,112006,"Complete",700000,646000,92.29,"2011-06-03","2012-05-15"]

{"sheet":"data","index":3,"n_rows":500,"n_cols":10,"rows_kept":500,"cut":false,"hidden":false,"merged":[]}
["Award Date Fiscal Year","District","PID","Project Name (ie CRS)","Primary Work Category","Project Description","Awarded Sale Amount","Construction Estimate (PE, R/W COSTS NOT INCLUDED)","Amount","Filtered\nAmount"]
["-",3,87914,"ASD SIGN REPLACEMENT FY2010","Signs","Systematic Sign ReplacementUNSELECTED Stimulus 2 Design Build candidate - SJN:437971Removed Funds ($70,000 PE / $735,723 CO UNFU) and Sale and Award (FY2011)",null,null,{"$f":"IF(G2=\"\",H2,G2)","v":0},{"$f":"IF(G2<>0,G2,H2)","v":0}]
["-",3,87915,"LOR SIGN REPLACEMENT FY2010","Signs","Systematic Sign ReplacementUNSELECTED Stimulus 2 Design Build candidate - SJN:437972Removed Funds ($168,000 PE / $1,662,615 CO UNFU) and Sale and Award (FY2011)",null,null,0,{"$f":"IF(G3<>0,G3,H3)","v":0}]
["-",3,87916,"RIC SIGN REPLACEMENT FY2010","Signs","Systematic Sign ReplacementUNSELECTED Stimulus 2 Design Build candidate - SJN:437973Removed Funds ($217,000 PE / $2,012,400 CO UNFU) and Sale and Award (FY2011)",null,null,{"$f":"IF(G4=\"\",H4,G4)","v":0},0]
["-",3,87917,"WAY SIGN REPLACEMENT FY2010","Signs","Systematic Sign Replacement Design Build - candidate",null,null,{"$f":"IF(G5=\"\",H5,G5)","v":0},0]
["-",3,96227,"MED IR 0071 24.02 (SR303 RmpClr)","Intersection Improvement","FY2014 Design Acquire Build project (M May approved D-A-B in FY 2015)MED-071-24.02 - 24.22/MED-303-09.04Improve southbound exit from I-71 to SR 303 withexit ramp wideing/extending/restriping on I-71 and SR 303.(Scope of Services to be completed by Distric",null,null,0,0]
["-",8,85630,"HAM IR 71 2.80","Noise Wall","Install type two noise barriers at various warranted locations within stated termini-stimulus project. Design Build project",null,null,0,0]
["-",8,91719,"HAM/WAR IR 71 19.89/0.09","Bridge Repair","Rehabilitate bridges HAM-71-1989L/R and WAR-71-0009 L/R installing new rigid overlays and replacing the roadway barrier between the northbound bridges, and perfroming other minor bridge rehabilitation items. Project will be design build and combined with",null,null,0,0]
["-",12,94577,"CUY US 006 21.27","Bridge Repair","Rehabilitate, replace, or otherwise upgrade the 15' stone arch drainage structure carrying Dugaway Brook under Euclid Avenue (US-6) located just east of Superior Avenue in East Cleveland.",null,null,0,0]
[1998,7,8410,"CLA US 68 12.52","New Construction","CONSTRUCT A CONNECTION BETWEEN CLA-68-15.19 AND CHP-68-0.00, TO BETTER  UTILIZE EXISTING L/A SECTION OF ROADWAY. DESIGN & BUILD PROJECT.",15126788.732999999,15926877.4,15126788.732999999,15126788.732999999]
[2000,3,18200,"MED IR 0271 00.00","Major Reconstruction","PAVEMENT RECONSTRUCTION DESIGN BUILD PROJECT",18856379.748,21362542.210000001,18856379.748,18856379.748]
[2000,4,18703,"ATB SR 0045 19.92","Bridge Replacement","WIDENING OF BRIDGE ATB-45-19.92 OVER IR 90. DESIGN/BUILD. HIGH PRIORITY PROJECT MAX $1,555,082.",3228037.6009999998,3133281.08,3228037.6009999998,3228037.6009999998]
[2000,4,20411,"STA IR 0077 11.59","Major Reconstruction","MAJOR UPGRADE TO INCLUDE MODIFICATIONS TO MAINLINE, RAMPS, SERVICE ROADS AND BRIDGES. ADD LANE BOTH DIRCTIONS; CONSTRUCT FOR 12874; TRC ON DIST BRIDGE ONLY. DBrelates to pids 20410, 20412, 10769",26159793.022999998,24905922.300000001,26159793.022999998,26159793.022999998]
[2000,6,20681,"FRA IR 71 14.39","Major Reconstruction","IR71: PARTIAL AND FULL DEPTH PAVT REPAIR PAVT INLAY. SR315: REMOVE/REPLACE PAVT A ND SUBBASE, CURB, INLETS. REPLACE CONC BARRIER, LIGHTS, SIGNS, GUARDRAIL. D/B.",4015250.3879999998,3758870.58,4015250.3879999998,4015250.3879999998]
[2000,7,11160,"MIA IR 75 4.94","Major Widening","ADD ADDITIONAL LANES AND RECONSTRUCT EXISTING ROADWAY, UPGRADE ALL STRUCTURES AND PROVIDE 16'6\" VERTICAL CLEARANCE. REMOVE MIA-75-0733L&R.* MNC MAX $18MIL.",49534522.074000001,50524044.439999998,49534522.074000001,49534522.074000001]
[2000,8,18899,"PRE IR 70 0.00","Minor Rehabilitation - Pavement Prmy Sys","PROJECT CONSISTS OF PLANING, SUPERPAVING, INSTALL RAISED PAVEMENT MARKERS, WIDENING MAINLINE BRIDGES, AND PAINTING 12 INTERSTATE BRIDGES.  DESIGN/BUILD. COMBINED WITH PIDS 19391 AND 19411.",22364931.905000001,21869858.879999999,22364931.905000001,22364931.905000001]
[2001,1,21082,"ALL US30 18.18","Bridge Repair","REPLACE DECKS ON STRUCTURES OVER IR75 AND NORFOLK SOUTHERN R.R. MICRO-SILICA   OVERLAY DECKS ON STRUCTURES OVER NAPOLEON ROAD. NO R/W REQ'D. DESIGN BUILD.",2365518.9920000001,2514997,2365518.9920000001,2365518.9920000001]
[2001,3,17891,"LOR IR 0090 10.76","Resurfacing, Divided System","4-LANE RESURFACING & BRIDGE DECK OVERLAY INCL. ADD A LANE SR611 TO EXIST 6-LANE ENVIRONMENTAL CLEARED WITH PID 11385 DESIGN BUILD PROJECT",15072549.698999999,17843111.109999999,15072549.698999999,15072549.698999999]
[2001,4,18722,"MAH SR 0011 16.04","Bridge Replacement","MAJOR BRIDGE WORK ON MAH. SR 11 - 16.04 L, SB OVER I80 EB AND MAH. SR 11 - 16.15 L, SB OVER I 680 WB RAMP & SR 11-16.05L OVER IR80 EB.COMBINED W/CANCEL PID 19322",4508109.0420000004,4266200,4508109.0420000004,4508109.0420000004]
[2001,4,19854,"POR US 0224 00.00","Resurfacing,  Undivided System","TWO LANE RESURFACING FROM SUMMIT CO. TO SR183.SAFETY IMPRV. BY ADDING TURN LANE TO MARTIN, CONGRESS LAKE AND WATERLOO INTERSECTION. DESIGN BUILD PROJECT.",4029915.7560000001,3726804,4029915.7560000001,4029915.7560000001]
[2001,4,19899,"ATB SR 0011 23.33","Bridge Repair","REDECK, ABUT. CARSON ROAD OVER SR 11. DESIGN BUILD PROJECT.",680428.43,607458.5,680428.43,680428.43]
[2001,4,22163,"TRU IR 0080 09.08","Resurfacing, Divided System","4 LANE RESURFACING WITH BRIDGEWORK.",5373166.9749999996,5219099.9800000004,5373166.9749999996,5373166.9749999996]
[2001,8,12412,"HAM IR 471 0.26","Minor Rehabilitation - Pavement Prmy Sys","MAJOR REHABILITATION OF EXISTING PAVEMENT AND SAFETY UPGRADE.  0.47 MILES DESIGN BUILD PROJECT",16821520.425999999,16583439.98,16821520.425999999,16821520.425999999]
[2001,8,19705,"HAM IR 71 11.08","Resurfacing, Divided System","PROJECT CONSISTS OF PLANING AND RESURFACING AND INSTALLING PAVEMENT      MARKINGS.CLOSURE OF NOISE WALL GAPS.  PAINT AND LANDSCAPE EXISTING WALLS.",11791608.163000001,11789259.99,11791608.163000001,11791608.163000001]
[2001,8,19786,"HAM IR 275 32.27","Resurfacing, Divided System","PROJECT CONSISTS OF PLANING, RESURFACING, PAVEMEMT MARKINGS AND STRUCTURAL STEEL RETROFIT, OVERLAY AND NEW PARAPETS FOR MAINLINE BR. OVER GREAT MIAMI RIVER",32140257.513999999,31561632.690000001,32140257.513999999,32140257.513999999]
[2001,10,21053,"ATH US 33 10.41","Bridge Repair","BRIDGE DECK REHABILITATION. INCLUDES ATH-33-10.41R. DETOUR APPLICATION REQUIRED. DESIGN BUILD.",1899668.915,1899900,1899668.915,1899668.915]
[2001,11,12761,"TUS IR 77 3.94","Resurfacing, Divided System","4-LANE MAJOR RHABILITAION - RUBBLIZE AND ROLL; SIGNING, LIGHTING, FENCING, GUARD- RAIL, MODIFY OR REPAIR 5 BRIDGES. DESIGN BUILD.",10011441.859999999,9618699.9900000002,10011441.859999999,10011441.859999999]
[2002,1,21490,"HAR SR 81 16.54","Bridge Repair","REPLACE DECK ON STRUCTURE OVER THE BLANCHARD RIVER.",358972.054,337250,358972.054,358972.054]
[2002,1,23567,"ALL CR 88 0.36","Major Widening","WIDEN EXISTING ROADWAY TO THREE LANES TO PROVIDE FOR A TWO WAY LEFT TURN LANE FROM WEST OF GRONE RD. TO EAST OF LEHMAN RD. FEDERAL MAX $116,500",126885.659,239694.04,126885.659,126885.659]
[2002,2,22516,"HEN SR 108 15.61","Bridge Repair","REHAB EXISTING BRIDGE BY REPLACING PARAPETS, SIDEWALKS & WEARING SURFACE; PATCH CONC SPANDRAL WALLS AS REQUIRED; PERFORM  NECESSARY RELATED WORK. DESIGN-BUILD",1025541.085,934490,1025541.085,1025541.085]
[2002,5,22587,"PER CR 57 05.60","Bridge Replacement","REPLACE 4 BRIDGES. INCLUDES PID 21426.",732832.75199999998,673850,732832.75199999998,732832.75199999998]
[2002,5,22627,"GUE CR 73 00.00","Bridge Replacement","REPLACE 6 BRIDGES",537263.28700000001,494288,537263.28700000001,537263.28700000001]
[2002,7,19669,"MOT SR 4 4.83","Bridge Replacement","REPLACE 28FT STRUCTURE OVER DRY RUN WITH MINIMAL APPROACH WORK.  CLEAR SPAN = 25 FT",306540.50400000002,299860,306540.50400000002,306540.50400000002]
[2002,7,24375,"MER CR 22 1.32","Bridge Replacement","REMOVE THREE EXISTING BRIDGE AND ASSOC.  ROADWAY APPROACH PAVT. CONSTRUCT NEW PRECAST CONCRETE BOX BRIDGES AND ASSOC. ROADWAY APPROACH. DESIGN/BUILD.",405588.103,373390,405588.103,405588.103]
[2002,8,21713,"PRE US 40 1.33","Bridge Replacement","REPLACE BRIDGE NO. PRE-40-0133 OVER TRIBUTARY OF THE EAST FORK OF THE        WHITEWATER RIVER.  DESIGN BUILD PROJECT",262920.15500000003,265540,262920.15500000003,262920.15500000003]
[2002,8,24434,"PRE TR 444 0.80 & VAR DB","Bridge Replacement","REPLACE THREE EXISTING TRUSS BRIDGES     (TR444-.80 TR453-1.25, AND TR409-1.60)   AND REPLACE EXISTINGSTEEL BEAM BRIDGE    (CR56-.60) DESIGN BUILD PROJECT.",1430890.5560000001,1579238.71,1430890.5560000001,1430890.5560000001]
[2003,1,24297,"PAU CR 111 4.65","Bridge Repair","REHABILITATE TWO EXISTING STRUCTURES BY REPLACING THE EXISTING DECKS. THIS WILL BE A DESIGN BUILD PROJECT.",948266.08499999996,540955.35,948266.08499999996,948266.08499999996]
[2003,1,24518,"HAN CR 8 4.85","Bridge Replacement","REPLACE 6 EXISTING STRUCTURES IN HANCOCK COUNTY WITH NEW STRUCTURES. THIS WILL BE A DESIGN BUILD PROJECT.",1018570.5429999999,817520,1018570.5429999999,1018570.5429999999]
[2003,3,24442,"HUR CR 0124 01.880","Bridge Replacement","DESIGN BUILD PROJECT ON TR91 (TERRY RD) OVER THE HURON RIVER AND ON CR241 (WASHINGTON RD) OVER A BRANCH OF THE HURON RIVER",785137.96100000001,730581.4,785137.96100000001,785137.96100000001]
[2003,4,18718,"SUM SR 0021 01.79","Bridge Repair","REHAB ONE STRUCTURE ON SR21 IN SUMMIT CO INCLUDES PIDS 18719 AND 13337.",1088493.798,1066510,1088493.798,1088493.798]
[2003,4,19791,"STA IR 0077 00.00","Resurfacing, Divided System","FOUR LANE RESURFACING/UPGRADING FROM TUSCARAWAS COUNTY TO CANTON CORPORATION LIMIT.  INCLUDING WORK ON 5 BRIDGES",5189057.0930000003,5077263,5189057.0930000003,5189057.0930000003]
[2003,4,22174,"ATB SR 0011 25.16","Bridge Repair","REDECK STRUCTURE, MAKE STRUCTURAL STEEL CONTINUOUS AND PAINT STRUCTURAL STEEL ON THE LEFT AND RIGHT PARTS OF THE BRIDGE",10085422.189999999,10140920,10085422.189999999,10085422.189999999]
[2003,4,22229,"SUM IR 0077 15.47","Bridge Repair","REDECK/PAINT BRIDGE UNDER STONER ST. OLD PID 19922",1536568.9920000001,1545830,1536568.9920000001,1536568.9920000001]
[2003,4,23672,"SUM Main Street","Major Reconstruction","DECK REPLACEMENT AND RELATED IMPROVEMENT.DESIGN-BUILD PROJECT.",5260233.9570000004,5920548.7699999996,5260233.9570000004,5260233.9570000004]
[2003,4,23929,"TRU SR 0011 09.08","Lighting","INSTALL INTERCHANGE LIGHTING FOR SR82 AT SR11 INTERCHANGE, ALSO RESURFACE THE INTERCHANGE INCLUDING ALL RAMPS WITH SKID-RESISTANT MATERIAL",2251812.0159999998,2235652.1,2251812.0159999998,2251812.0159999998]
[2003,4,24038,"ATB CR 0020 00.02","Bridge Replacement","REPLACE A 3 SPAN 60FOOT BY 116FOOT BY 50FOOT PRATT TRUSS BRIDGE OVER NORFOLK & SOUTHERN RAILROAD (PLYMOUTH RIDGE ROAD)",1082067.8289999999,865977,1082067.8289999999,1082067.8289999999]
[2003,4,24447,"POR CR 0176 00.17","Bridge Replacement","BRIDGE REPLACEMENT. DESIGN BUILD PROJECT",238318.49600000001,203039.9,238318.49600000001,238318.49600000001]
[2003,4,24663,"TRU CR 0302 02.40","Bridge Replacement","(DONLEY ROAD) REPLACE EXISTING BRIDGES OVER SWINE CREEK & BRAND RIVER",484343.79800000001,463586.98,484343.79800000001,484343.79800000001]
[2003,5,19821,"GUE IR 77 07.68","Bridge Repair","DECK REPLACEMENT AND PAINTING ON TWO BRIDGES / DESIGN BUILD LANDSCAPING TE FUNDS",2175146.9380000001,2120800,2175146.9380000001,2175146.9380000001]
[2003,5,24369,"COS SR 16 07.18","Culvert Construction/Reconstr/Repair","Replace 2 culverts/1 bridge using the ODOT Design Build PolicyCos-16-7.18 = From SR 16E: SR 83S to CR-271E to Second Street E to SR 541N to SR 16ELic-13-17.11 = From SR 13N to TR-76 (Weaver Rd) to TR-75 (Preston Rd) to TR-105 (Joseph Rd) to SR 13Gue-821-0",524045.39500000002,553324.80000000005,524045.39500000002,524045.39500000002]
[2003,6,12769,"PIC US 22 16.96","Bridge Repair","REHAB 633FT BRIDGE OVER SCIOTO RIVER WITH SHORT APPROACH AND APPROACH GUARDRAIL. DESIGN/BUILD FAST TRACK CONST",2967458.023,3528190,2967458.023,2967458.023]
[2003,6,23948,"UNI CR 23 02.070","Bridge Replacement","CEAO DESIGN/BUILD PROJECT TO REPLACE TWO STRUCTURES ON CR23 AND CR213. PREVIOUSLY PROGRAMMED AS 2 SEPARATE PIDS; PID 23949 (CR213) COMBINED WITH THIS PID.",698623.72499999998,832293.9,698623.72499999998,698623.72499999998]
[2003,6,23997,"FRA IR 270 1.52","Noise Wall","CONSTRUCTION OF TYPE2 (RETROFIT) NOISE WALL.  DESIGN/BUILD.",571530.03899999999,569250,571530.03899999999,571530.03899999999]
[2003,7,24384,"DAR SR 705 11.02","Bridge Replacement","REPLACE A 27FT STRUCTURE OVER BRANCH OF MILE CREEK WITH MINIMAL APPROACH WORK. DESIGN/BUILD.",235092.44200000001,208670,235092.44200000001,235092.44200000001]
[2003,8,21019,"BUT TR 175 0.51","Bridge Replacement","REPLACE TWO DEFICIENT STRUCTURES.  COUNTY DESIGN BUILD PROJECT.",1055632.047,989592.46,1055632.047,1055632.047]
[2003,10,24446,"MEG CR0028 06.240","Bridge Replacement","BRIDGE REPLACEMENT PROJECT USING THE DESIGN/BUILD PROCESS. INCLUDES MEG- CR029-0268.",340903.10100000002,292900,340903.10100000002,340903.10100000002]
[2003,11,20996,"TUS IR 77 7.55","Resurfacing, Divided System","4 LANE MAJ REHAB-RUBBLIZE &ROLL;SIGNING GUARDRAIL,REPAIR 5 BRIDGES.   SIGNING IN CLUDED 00.00-3.88SECTION",9197739.9220000003,8853710,9197739.9220000003,9197739.9220000003]
[2003,12,24356,"CUY SPAFFORD ROAD","Bridge Replacement","REPLACE THE SPAFFORD RD BRIDGE #23 OVER E.BRCH OF ROCKY RIVER IN BROOK PARK AND OLMSTED TWP LOCAL, NON-TRADITIONAL, DESIGN BUILD",873877.326,938585,873877.326,873877.326]
[2003,12,24364,"LAK RAVENNA ROAD /VARIOUS","Bridge Replacement","REPLACE BRIDGES: RAVENNA ROAD OVER KELLOG CREEK / CUNNINGHAM ROAD OVER ARCOLA CREEK / PINEHILL ROAD OVER ELLISON CREEK IN MADISON & CONCORD TOWNSHIPS. LOCAL, NON-TRADITIONAL, DESIGN-BUILD",1442295.6710000001,1367347.34,1442295.6710000001,1442295.6710000001]
[2004,1,21607,"HAN SR 37 10.81","Bridge Repair","REHABILITATE EXISTING STRUCTURE OVER THE BLANCHARD RIVER BY REPLACING THE DECK,   BACKWALLS AND APPROACH SLABS.",492600.62400000001,480910,492600.62400000001,492600.62400000001]
[2004,2,24102,"SEN SR 67 9.87","Resurfacing,  Undivided System","2-LANE RESURFACING WITH PAVEMENT REPAIRS  AS NEEDED (Cold in Place recycling); PERFORM NECESSARY RELATED WORK.",1795192.4609999999,1703351,1795192.4609999999,1795192.4609999999]
[2004,2,75172,"D02-SIGN-FY2004(A)","Signs","District wide sign upgrade; perform necessary related work",364319.76699999999,322850,364319.76699999999,364319.76699999999]
[2004,6,75280,"FRA IR 270 20.03","Noise Wall","Construct noisewalls along both sides of I-270 to fulfill commitments made when I-270 was widened to four lanes in each direction.  Noise abatement for PIDs-12505, 12504, 12494, and 12495.",7891961.2400000002,7970600,7891961.2400000002,7891961.2400000002]
[2004,7,19670,"MOT SR 48 5.16","Bridge Replacement","REPLACE 21FT STRUCTURE OVER TRIBUTARY TO HOLES CREEK WITH MINIMAL APPROACH WORK. ELIMINATE GUARDRAIL. CLEAR SPAN = 19FT.",340560.01899999997,286480,340560.01899999997,340560.01899999997]
[2004,11,19572,"D11 Sign FY2004A","Signs","REPLACE OR EPOXY SEAL OVERHEAD SIGN SUPPORT STRUCTURES IN  COL, HAS, JEF AND TUS COUNTIESUpgrade existing signs including all interchanges and intersections on Has-22 and Jef-22 locations.  Includes Hopedale.",591897.09299999999,510130,591897.09299999999,591897.09299999999]
[2004,11,19575,"D11 Sign FY2004 B","Signs","UPGRADE EXISTING SIGNS INCLUDING ALL INTERCHANGES ON IR 470",570522.57799999998,514942,570522.57799999998,570522.57799999998]
[2005,6,75279,"FRA/DEL IR 71 25.36/1.16","Noise Wall","Construct noise walls along both sides of I-71 to fulfill environmental commitments when I-71 was widened (under PID-7278).",9338893.4110000003,8843450,9338893.4110000003,{"$f":"IF(G67<>0,G67,H67)","v":9338893.4110000003}]
[2005,6,76564,"FAY SR 41 22.18","Bridge Repair","REPLACE DECK WITH A WIDER (THREE LANE) DECK AND APPROACH WORK FOR FUTURE WIDENING OF SR 41. DESIGN/BUILD PROJECT.",2323913.5660000001,2300761,2323913.5660000001,2323913.5660000001]
[2005,7,25295,"MER SR 117 9.31","Bridge Replacement","REPLACE TWO BRIDGES.  DESIGN BUILD PROJECT.",440897.71299999999,403929.8,{"$f":"IF(G69=\"\",H69,G69)","v":440897.71299999999},440897.71299999999]
[2005,10,76160,"WAS IR 77 6.59","Major Rehabilitation","Four-lane major rehabilitation project.  WAS IR 77 6.59-17.59 and NOB IR 77 0.00-1.56.  Includes WAS IR 77 11.53 LT and WAS IR 77 12.08 RT bridges.  PID's now combined with this job are: 76239 (WAS 77 10.90 and NOB 77 0.13 Landslide locations) and 21857 (",21855150.756000001,20279824,21855150.756000001,21855150.756000001]
[2006,4,23703,"STA US 0062 08.32","Bridge Repair","REDECK AND PAINTING OF ONE STRUCTURE.Design/Build.",906007.17099999997,826506.54,906007.17099999997,906007.17099999997]
[2006,4,25072,"STA SR 0225 00.76","Bridge Repair","REPLACEMENT OF EXISTING DECK.",657647.28099999996,579280,657647.28099999996,657647.28099999996]
[2006,8,25499,"HAM SR 562 0.00","Resurfacing, Divided System","REHABILITATE SR 562.",5923664.1749999998,5768190,5923664.1749999998,5923664.1749999998]
[2006,9,76169,"SCI CR 15 0.12 Dixon Mill Road","Bridge Replacement","Replace existing deficient bridge on Dixon Mill ROad over the Little Scioto River, Scioto County Road 15. This project is a Design Build project per the Scioto County Engineer.",1583075.581,1365475.03,1583075.581,1583075.581]
[2007,9,76170,"SCI CR 48 2.85 Arion Road Brdg","Bridge Replacement","Replace existing deficient one lane bridge on Arion Road over Scioto Brush Creek. Scioto County Road 48.",1633720.93,1687500,1633720.93,1633720.93]
[2007,12,79599,"CUY IR 071 11.88 NOISE WALL","Noise Wall","Construct noise walls.",6408455.5039999997,6255500,6408455.5039999997,6408455.5039999997]
[2008,3,20375,"CRA SR 0602 06.00","Bridge Repair","NEW DECK, CHANGE TO SEMI-INTREGAL ABUT INCL NEW APPROACH SLAB",664856.42299999995,629850,664856.42299999995,664856.42299999995]
[2008,4,23753,"STA SR 0021 08.98","Bridge Repair","REDECK with Widening AND PAINTING OF ONE STRUCTURE IN STARK COUNTY ON SR 21.",2030063.8060000001,1776526.5,2030063.8060000001,2030063.8060000001]
[2008,6,81281,"FRA IR 71 19.09","Noise Wall","Provide noise barrier walls along I-71 at various locations as warranted.  Preliminary studies and public involvement will be performed under an OES task order contract.  Construction will be under a design/build contract.",4435007.7520000003,4209700,4435007.7520000003,4435007.7520000003]
[2008,6,81547,"UNI CR 307 4.89","Bridge Replacement","STRUCTURE REPLACEMENT WITH APPROACH ROADWAY IMPROVEMENTS.LOCAL-LET PROJECT SOLD/ADMINISTERED BY UNI COUNTY ENGINEER.",534594.33100000001,539921.25,534594.33100000001,534594.33100000001]
[2008,8,75633,"CLE SR 32 13.14","Bridge Repair","Bridge rehabilitation project of twin mainline SR 32 bridges over SR 276.  Bridge Nos. CLE-32-1314 L/R, SFNs:  1300458/1300466, will receive new reinforced concrete decks; have the structural steel painted; and will receive other minor bridge work.  Desig",1762403.682,1726450,1762403.682,1762403.682]
[2009,1,81299,"HAN CR 26-17.59","Bridge Replacement","REMOVE AND REPLACE EXISTING STRUCTURALLY DEFICIENT BRIDGE OVER THE BLANCHARD RIVER.",829222.28700000001,843035,829222.28700000001,829222.28700000001]
[2009,4,25277,"SUM IR 0077 30.96","Bridge Repair","Re-deck and paint of 8 structures.",10971100.426000001,10651703.67,10971100.426000001,10971100.426000001]
[2009,6,81548,"UNI CR 310 0.70","Bridge Replacement","STRUCTURE REPLACEMENT WITH APPROACH ROADWAY IMPROVEMENTS.LOCAL-LET DESIGN/BUILD PROJECT SOLD/ADMINISTERED BY UNI COUNTY ENGINEER.",548449.91899999999,523111.6,548449.91899999999,548449.91899999999]
[2009,8,23302,"HAM IR 275 7.02","Slide Repair","CONSTRUCT EARTHWORK BENCH AND COUNTER BERM TO STABILIZE THE LANDSLIDE ALONG EB IR275 RAMP TO EB IR74.PID 79999 combined for Construction. Installation of drainage tile to dewater landslide area at 0.59 miles south of IR74.",1261014.7290000001,1164020,1261014.7290000001,1261014.7290000001]
[2009,11,80922,"BEL IR 70 0.000","Signs","Upgrade existing signing along IR 70 and the signing at the interchanges in the project area.",459783.527,426420,459783.527,459783.527]
[2010,1,82163,"HAN IR 75 22.12","Bridge Replacement","Replace CR 109 bridge over Interstate 75.  DESIGN/BUILD.",1734162.0930000001,1621090,1734162.0930000001,1734162.0930000001]
[2010,1,82330,"HAN CR 169-0.83","Bridge Replacement","REPLACE BRIDGE ON HAN CR 169-0.83 over Blanchard River (Design Build)",700376.16299999994,708355,700376.16299999994,700376.16299999994]
[2010,2,86328,"OTT TR 54 (Billman Rd) Brdg ARRA","Bridge Repair","An ARRA funded project to rehabilitate  the steel truss bridge on Billman Rd (TR 54) over Cedar Creek; perform necessary related work.",289480.10100000002,292365,289480.10100000002,289480.10100000002]
[2010,3,80196,"LOR SR 0058 09.83","Bridge Deck Replacement","Replace the Deck of LOR-058-09.83 over the West Branch of the Black Rivercoordinate with PID:82773 LOR SR 0058 08.34 - Resurfacing",717748.06200000003,674850,717748.06200000003,717748.06200000003]
[2010,3,83445,"HUR US 0224 08.55","Bridge Replacement","Bridge Replacement",1006644.38,951500,1006644.38,1006644.38]
[2010,3,83446,"LOR SR 0058 25.34","Bridge Repair","Bridge Rehabilitation(Design by Burgess & Niple under D/B contract with Perk Company)",497813.283,444580,497813.283,497813.283]
[2010,3,84604,"WAY US 0042 00.60","Bridge Replacement","Bridge Replacement",757359.26,686590,757359.26,757359.26]
[2010,3,86254,"LOR SR 0057 12.54","Bridge Deck Replacement","Repair twin structures LOR-057-12.54 L&R over branch of Black RiverBridge Deck ReplacementsPID:18982 previously awarded and then terminated",1390405.426,1344310,1390405.426,1390405.426]
[2010,4,25223,"TRU SR 0011 07.69","Bridge Repair","REMOVE AND REPLACE EXISTING DECK OF TWO STRUCTURES, TRU-SR11-0959L & TRU-SR11- 0959R. Redeck of TRU-11-9.28. Replacement of TRU-11-19.52.Minor rehabilitation from SLM 7.69 to King Graves interchange.",13985579.497,13097559.18,13985579.497,13985579.497]
[2010,6,85039,"UNI 2009 HISTORIC BRIDGE PRESERV","Bridge Maintenance","INSTALLATION OF LIGHTING SYSTEMS AND HEAT DETECTION SYSTEMS ON FOUR HISTORIC COVERED BRIDGES IN UNION COUNTY. POTTERSBURG COVERED BRIDGE ON NORTH LEWISBURG MULTI PURPOSE TRAIL; SPAIN CREEK COVERED BRIDGE ON CR163 (INSKEEP-CRATTY ROAD) OVER SPAIN CREEK; CU",266187.59700000001,265640,266187.59700000001,266187.59700000001]
[2010,6,85537,"FRA IR 71 19.09 (Phase 2)","Noise Wall","Provide noise barrier walls along I-71 at various locations as waranted.  Design/build contract.",5247566.085,4621550,5247566.085,5247566.085]
[2010,6,86359,"MAD CR 12 (Old Xenia Rd)","Bridge Replacement","Replace bridge on MAD CR 12 (Old Xenia Rd) on Woolsey Ditch/Paint Creek.",389587.984,355337.5,389587.984,389587.984]
[2010,6,86459,"DEL CR 24 5.020","Bridge Deck Replacement","Replace deck and superstructure members.Modify or replace bridge abutments.Possible piers work, minor roadway approach work, guardrail replacement.MORPC Stimulus funded project - cap amount of $1,500,000.",718568.19,767656.33,718568.19,718568.19]
[2010,8,84497,"HAM IR 75 10.09","Minor Rehabilitation - Pavement Prmy Sys","Resurface and perform pavement repair on I-75 from south of SR 126 to south of the Lockland Corp. Project includes several minor bridge rehabilitations.",7018498.1610000003,6964179.7699999996,7018498.1610000003,7018498.1610000003]
[2010,9,85830,"LAW S.P. INTERMODAL ROADWAY","Inter-modal Facility","It is proposed to improve access roads that would allow for better access and handling between river barges, rail, and highway freight.    Note: Split to PID 86717 \"LAW S.P. INTERMODAL RAIL\"",1132713.1780000001,1461028.62,1132713.1780000001,1132713.1780000001]
[2010,9,86717,"LAW S.P. Intermodal Rail","Inter-modal Facility","It is proposed to construct rail lines and a concrete transfer pad to facilitate cargo transfer from rail to highway. Note: Split from PID 85830 \"LAW S.P. INTERMODAL ROADWAY\"",2501989.1469999999,2452617.38,2501989.1469999999,2501989.1469999999]
[2010,11,76825,"BEL IR 70 7.61","Major Reconstruction","UBCO on existing mainline and ramps, full depth removal and rigid replacement at overhead bridges, reconstruct median and median drainage, replace guardrail and signs, rehabilitation of 4 bridges, reconstruction of passenger car parking are in EB rest are",25534892.589000002,25055850,25534892.589000002,25534892.589000002]
[2010,11,78478,"COL US0030/SR0011 25.09/10.82","Signs","Upgrade all existing signing along US 30 & SR 11 including the signing at the interchanges",779020.22100000002,721880,779020.22100000002,779020.22100000002]
[2010,11,81587,"HAS US 250 11.720","Major Rehabilitation","Major rehabilitation of existing pavement with unbonded concrete overlay - Major 2 funding; ADDED BY CHANGE ORDER: FHWA OH11-02 flood site; DSR HAS-002: Embankment Failure/ Two Slides - 250ft. Landslide above SR250. The crown of slide is located  near old",4701505.7560000001,4635638,4701505.7560000001,4701505.7560000001]
[2010,11,86367,"JEF SR 43 0.00","Major Rehabilitation","Concrete pavement replacement, spot roadway base repair, curb repair and replacement, catch basin replacements, guardrail replacement, street lighting replacement, retaining wall repair, signing and pavement marking replacement.  ARRA ODOT Tracking ID is",7715848.3020000001,7830667.0899999999,7715848.3020000001,7715848.3020000001]
[2010,11,87863,"BEL Shadyside - salt storage","Buildings - Mix Shed,etc.","construction of 500 ton salt storage - tensioned Fabric structure",147721.04699999999,149190,147721.04699999999,147721.04699999999]
[2010,11,87864,"JEF Dillonvale - salt storage","Buildings - Mix Shed,etc.","construction of 1000 ton salt storage - Tensioned Fabric Structure",213363.95300000001,215490,213363.95300000001,213363.95300000001]
[2010,11,87879,"JEF SR 7 1.660","Bridge Repair","Remove existing MSC overlay and replace with new MSC overlay (including approach slabs) and perform some full-depth repairs to the deck.",796287.86699999997,804220,796287.86699999997,796287.86699999997]
[2010,12,87632,"CUY IR 077 00.38/VAR","Bridge Deck Replacement","Bridge Deck:  Replace the bridge decks over I-77 at Snowville Road, Highland Drive, Valley Parkway, and Oakes Road in Brecksville.  Valley Parkway moved to PID 91820.",4143850.3640000001,3782540,4143850.3640000001,4143850.3640000001]
[2010,12,87633,"CUY IR 077 03.45/VAR","Bridge Deck Replacement","Bridge Deck:  Replace the bridge decks over I-77 at Harris Road, Lacey Lane, and Chestnut Road in the Cities of Independence and Broadview Heights.",2810196.0469999998,2527440,2810196.0469999998,2810196.0469999998]
[2011,1,84564,"ALL SR 81 4.89","Bridge Deck Replacement","REPLACE THE CONCRETE BRIDGE DECK ON THE BRIDGE OVER THE AUGLAIZE RIVER",717813.95499999996,654790,717813.95499999996,717813.95499999996]
[2011,2,76710,"SAN US 20 03.77 Rehab","Minor Rehabilitation - Pavement Prmy Sys","A district funded project to rehabilitate SAN-20 from east of Woodville east corp line to a butt joint west of TR138; perform necessary related work. See PID 85241 for WB resurf. Update: Central office pavement visited the project site. New treatment reco",13313963.521,12908730,13313963.521,13313963.521]
[2011,3,87315,"MED Mud Lake Rd Replace Bridge","Bridge Replacement","MED Mud Lake Rd Bridge Replacement (SFN #5238714) - Split from PID 85697.",1711437.5689999999,1642355.49,1711437.5689999999,1711437.5689999999]
[2011,3,88375,"D3 ERI/HUR Salt Storage Building","Salt Dome","Design Build contract for Salt Storage structure at Erie and Huron County Garages.Design Build-will contain PE and CO Phase funding eventsD3 Building Superintendent: Richard Feldkamp",762403.10100000002,700000,762403.10100000002,762403.10100000002]
[2011,3,88662,"WAY SR 0003 24.25","Culvert Construction/Reconstr/Repair","Culvert Replacement WAY-003-24.25 +/-",161111.579,136870,161111.579,161111.579]
[2011,4,25501,"ATB SR 0011 13.30","Minor Rehabilitation - Pavement Prmy Sys","PAVEMENT REPAIR AND BRIDGE WORK",11701964,11360330.949999999,11701964,11701964]
[2011,4,84631,"TRU US 0422 19.94","Bridge Replacement","Superstructure replacement.",851713.17799999996,850842.4,851713.17799999996,851713.17799999996]
[2011,4,86995,"ATB 90/45 (2.33)(7.43)/19.89","Bridge Deck Replacement","Bridge re-deck. Second structure at SLM ATB-90-7.43. Sealing sfn#0402591 at ATB-45-19.89.",1173311.1429999999,1180300,1173311.1429999999,1173311.1429999999]
[2011,4,87318,"POR-Rock Spring/Knapp Rds Brdgs","Bridge Replacement","POR Rock Springs Rd Replace Bridge (SFN #6730809)- Split from PID 85697.   SEE PID 80658 $700,000 replacement of same bridge (SFN 6730809).  Added POR Knapp Rd Replace Bridge, PID 87317 (SFN #6741150) as of 01/20/2010.",5645671.0060000001,5483569.8200000003,5645671.0060000001,5645671.0060000001]
[2011,4,87319,"TRU 5th Street Replace Bridge","Bridge Replacement","TRU 5th Street Replace Bridge replacement - Split from PID 85697.",1928999.6510000001,1911110,1928999.6510000001,1928999.6510000001]
[2011,4,87966,"POR IR 0076 (17.59)(19.61)","Bridge Repair","Superstructure replacements.",1910364.341,1901000,1910364.341,1910364.341]
[2011,6,77369,"FRA IR 71 17.760 (Pjt 1)","Major Reconstruction","FIRST CONSTRUCTION PROJECT RESULTING FROM MAJOR INVESTMENT/PRELIMINARY ENGINEERING STUDY (PID 23318).Reconstruction of the 670/71 Interchange. Work involves realignment of I-670 EB so through traffic stays to the left and traffic to I-71 exits to the righ",218210658.91499999,255190121,218210658.91499999,218210658.91499999]
[2011,6,82358,"UNI TR 279 1.04","Bridge Replacement","CEAO FUNDED BRIDGE REPLACEMENT PROJECT.UNI-TR279-1.04 (SNEDIKER ROAD) OVER FULTON CREEK. CLAIBOURNE TOWNSHIP.PROJECT TO BE SOLD AS DESIGN/BUILD BY UNION COUNTY ENGINEER.",664053.10100000002,670670,664053.10100000002,664053.10100000002]
[2011,6,85950,"D06 ExtruSign FY11A","Signing","Extru sign replacement for improved reflectivity for safety.  Limits include I-270 and lead-in signs.Upgrade existing ground and overhead mounted extrusheet signs on mainline and ramps.Upgrade extrusheet signs on side street approaches to interchanges tha",5220095.6119999997,5037260,5220095.6119999997,5220095.6119999997]
[2011,8,83047,"Pre TR259/329 Des Build Br Rep","Bridge Replacement","Junction Road (TR 259) Replace S.D. steel truss bridge Ketterman Road (TR 329) Replace S.D. bridge with minimal approach work",828514.34100000001,836770,828514.34100000001,828514.34100000001]
[2011,8,85364,"GRE IR 675 3.10","Noise Wall Maintenance/Repair (NEW)","Replace existing noise wall panels on existing noise wall, investigate salvaging existing steel posts, replace steel posts where warranted.(Design Build Project)",2057399.2250000001,2053150,2057399.2250000001,2057399.2250000001]
[2011,9,79855,"ADA US 52 1.10 Brdg Replace","Bridge Replacement","It is proposed to replace bridge number 0101621.",1460197.9839999999,1355400,1460197.9839999999,1460197.9839999999]
[2011,11,84323,"COL SR 7 0.00","Signs","Upgrading the existing signing along SR 7 in Columbiana and Jefferson county and US 36 and US 250 in Tuscarawas county.",1324784.3019999999,1274620,1324784.3019999999,1324784.3019999999]
[2011,12,85531,"CUY IR 090 14.90 WB Design Build","New Bridge","Design Build ContractOther Consultant Contracts: DBE Outreach(Dec 7 2009), Project Controls-Scheduling(Apr 12 2010), Project Controls-Reporting, Document Management, etc.(Apr 12 2010), Construction Inspection (2)(Fall 2010), Material Testing (2) (Fall 201",313020930.23299998,314401840.80000001,313020930.23299998,313020930.23299998]
[2012,2,84319,"OTT Ferry Terminal Building","Dock Facilities","A ferry boat discretionary (FBD) funded project to utilize and showcase solar technology at the Port Clinton and Put-in-Bay terminal buildings.  The terminal buildings will receive new roofing and solar technology will be incorporated with either solar pa",374918.26,365231,374918.26,{"$f":"IF(G131<>0,G131,H131)","v":374918.26}]
[2012,2,89226,"SEN/WIL Vestibule Additions","Facility Renovation","A lands & building funded project to remove and re-install of the entrance door so as to open outward.  A new wall and door will be added within the vastibule in a similar format; perform necessary related work. UPDATE (3-8-11): project includes PID 89227",103468.992,104500,103468.992,103468.992]
[2012,3,82255,"LOR SR 0002 SYSSIGN FY2012","Signs","Systematic Sign ReplacementLOR-002-03.50 - 11.14 / LOR-090-10.78 - 23.33exclude signs associated with Avon Interchange PID:83607I-90 was previously programmed as PID:82256",1043865.988,1007260,{"$f":"IF(G133=\"\",H133,G133)","v":1043865.988},1043865.988]
[2012,4,76295,"ATB SR 0011 23.85","Bridge Repair","Miscellaneous bridge work to six structures.",4192732.3840000001,4130379.82,4192732.3840000001,4192732.3840000001]
[2012,4,76403,"SUM IR 0077 24.29","Bridge Deck Replacement","Seven Bridge re-decks. Miscellaneous bridge work.",7528050.4479999999,6813755,7528050.4479999999,7528050.4479999999]
[2012,4,91094,"POR IR 0076 (3.93)(4.74)","Bridge Deck Replacement","Re-deck and painting of two structures.",2023635.659,1863992.65,2023635.659,2023635.659]
[2012,6,82359,"UNI CR 338 0.39","Bridge Replacement","CEAO FUNDED BRIDGE REPLACEMENT PROJECT.UNI-CR338-0.39 (COBB-HARRIMAN ROAD) OVER RUSH CREEK (JACKSON TOWNSHIP).DESIGN/BUILD PROJECT.",964007.53099999996,922412,964007.53099999996,964007.53099999996]
[2012,6,86916,"MRW IR 71 12.190","Major Widening","Full depth pavement replacement with addition of third median lane in each direction.Multi-lane Reconstruction funding.  Pvmt work - 19% NH and 81% IM approved by S Lowry via e-mail dated 11/4/10.Env phase also for PID's 86920   & 86921D6 Environmental Co",45784459.446000002,44205370,45784459.446000002,45784459.446000002]
[2012,6,86921,"DEL IR 71 11.500","Major Widening","Full depth pavement replacement and addition of 3rd median lane.Replace and widen ML Bridge MRW-71-3.00Env on PID 86916Consultant Project Manager - Jim Prevost",54157286.836999997,53244740,54157286.836999997,54157286.836999997]
[2012,6,87948,"FRA Various Noisewall Repair","Noise Wall","Repair damaged noisewalls along IR 71, IR 270, IR 670, and SR 315 in Franklin CountySR-315:  SLM 5.18-6.17 (Ackerman Rd to Olentangy River Rd)IR-670:  SLM 7.15-7.56 (US-62 to US-62/Fifth Ave)IR-71:  SLM 18.75-19.09 (E Second Ave to 5th Ave)IR-71:  SLM 24.",281000,271150,281000,281000]
[2012,8,84444,"HAM SR 562 0004L","Bridge Deck Replacement","Rehabilitate Bridge HAM-562-0.04L by replacing the concrete deck and including other related rehabilitation work.Design Build project.",800490.58100000001,719370,800490.58100000001,800490.58100000001]
[2012,8,87172,"CLI US 68 14.39","Bridge Replacement","Replace bridge CLI-68-1443 (SFN 1401173) over Lytle Creek in the City of Wilmington.",1096654.7790000001,901550,1096654.7790000001,1096654.7790000001]
[2012,11,84331,"BEL SR 7 6.110","Signs","Upgrading existing sigining along SR 7 including the signing at the interchanges in Belmont and Jefferson counties.",1031177.422,980920,1031177.422,1031177.422]
[2013,2,93473,"D02 GR FY2013 Safety","Guardrail Maintenance/Repair (NEW)","A safety funded project to upgarde guardrail at various D-2 locations, perform necessary related work",3389889.2439999999,3126670,3389889.2439999999,3389889.2439999999]
[2013,3,82257,"RIC IR 0071 SYSSIGN FY2013","Signs","Design Build - Supports and signs on those supports along RIC/ASD/WAY 71Project to include Sign Structures that were to be replaced with PID:82254 ASD IR 0071 SYSSIGN FY2012Plan filed as:  RIC-71-12.93, ASD-71/60-0.00/15.28, WAY-71-0.00",910962.79099999997,878790,910962.79099999997,910962.79099999997]
[2013,3,93717,"LOR Boston Road R/R Xing","Spot Safety","Improve vertical profile to meet 45MPH design speed criteriaReplace existing pavementReplace small culvert",662092.63600000006,595790,662092.63600000006,662092.63600000006]
[2013,4,76411,"TRU IR 0080 04.70","Minor Rehabilitation - Pavement Prmy Sys","Minor rehabilitation with bridge work.",10643704.93,10060290,10643704.93,10643704.93]
[2013,6,82357,"UNI CR 110 1.16","Bridge Replacement","CEAO FUNDED BRIDGE REPLACEMENT PROJECT.UNI-CR110-1.16 (DELAWARE COUNTY LINE ROAD) OVER BLUES CREEK. DOVER TOWNSHIP.",849996.68200000003,858466,849996.68200000003,849996.68200000003]
[2013,6,83245,"MAD IR 70 10.270 Phase 1","Interchange, Reconstruction","Improve MAD IR 70 at SR 29 interchange by constructing a roundabout at the IR 70 WB on and off ramps, widen SR 29 to accommodate the roundabout, and widen the EB off ramp.  This PID to include environmental clearance for the footprint of work on the south",3859420.64,3897880,3859420.64,3859420.64]
[2013,6,83958,"PIC SR 674 4.210","Bridge Replacement","Bridge Replacement and widening of structure over Turkey Run",1195602.7209999999,1040600,1195602.7209999999,1195602.7209999999]
[2013,6,86298,"FRA US 62 32.780","Bridge Deck Replacement","Bridge Replacement over Blacklick Creek. Single-span steel beam.Design Build Project. No R/W. FY12 Reservoir.",597732.66799999995,552050,597732.66799999995,597732.66799999995]
[2013,6,86920,"MRW IR 71 3.170","Major Widening","Full depth replacement and addition of 3rd median lane.Remove mainline bridge SLM 5.96 over abandoned RR.Bridge painting of overhead structure, sealing of mainline structuresEnv on PID 86916D6 Environmental Coordinator - Brian Tatman",56417829.457000002,54151050,56417829.457000002,56417829.457000002]
[2013,6,92610,"FRA IR 270 52.720","Major Widening","Major Rehab Funding.   Final design and construction of the widening of I-270 between I-71 and US-23 on south side of Columbus.  Replace the mainline pavement with a 20 year design. Widening of the mainline pavement to accommodate one (1) additional throu",null,28380000,28380000,28380000]
[2013,6,93159,"FRA IR 270 35.520 (Noise Wall)","Noise Wall","Design build noise wall on I-270 from Johnstown Rd to Goshen Lane (north side of I-270 near I-670).FY13 noise wall funding",730382.17099999997,683760,730382.17099999997,730382.17099999997]
[2013,7,91984,"DAR SR 705 9.02/9.47/10.33","Bridge Replacement","Three span concrete slab deck removal and replacement with minimal approach work,  possible guardrail end treatment upgrades.SFN 1903845 Darke 705 0947 over Holsapple DitchSFN 1903969 Darke 705 1033 over East Branch Baurers DitchSFN 1903810 Darke 705 0902",1167875.209,1019480,1167875.209,1167875.209]
[2013,8,90412,"PRE CR18/TR150 1.55/1.35 Des-Bld","Bridge Replacement","Project involves the replacement of the structurally deficient Bridge No. PRE-CR18-0155 (SFN: 6836267), which carries California School Road (CR-18) over Four Mile Creek and the replacement of structurally deficient Bridge No. PRE-TR 15-0135 (SFN: 6839401",null,832091,832091,832091]
[2013,8,90413,"PRE CR 80 0.12 Des-Build Br Repl","Bridge Replacement","Project includes replacing structurally deficient Bridge No. PRE-CR 80-0010 (SFN: 6835643) which carries Barnets Mill Road (CR-80) over Seven Mile Creek. Work includes minor approach work, pavement repairs, and vertical alignment adjustments, as necessary",null,725910,725910,725910]
[2013,8,90897,"BUT Lakota SRTS","Signs","Install sidewalks along Beckett Ridge, Beckett Station, and Spruce Roads.   Upgrade school signing in the vicinity of Freedom Elementary and Lakota Rigde Schools.",344377.48100000003,334884,344377.48100000003,344377.48100000003]
[2013,8,90962,"PRE TR218 0.20 Des-Build Br Repl","Bridge Replacement","Project involves replacement of the structurally deficient Bridge No. PRE-TR 218-0020 (SFN: 6836402), which carries Concord-Fairhaven Road (TR-218) over Four Mile Creek. Work includes minor approach work, pavement repairs, and vertical alignment adjustmen",null,531300,531300,531300]
[2013,8,91685,"GRE CR25 2.48 Des-Build Br Rehab","Bridge Deck Replacement","Repair deteriorated bridge by replacing the existing box beams, minor repairs to the existing abutments and wingwalls, installation of guardrail, and a new wearing surface. Design Build project.",324022.40700000001,346044,324022.40700000001,324022.40700000001]
[2013,8,91951,"CLE E. Fork State Park Resurface","Mill and Fill","Design-Build project will resurface roadways and parking areas within East Fork State Park in Clermont County.",2236632.4939999999,2064180,2236632.4939999999,2236632.4939999999]
[2013,8,92236,"HAM IR 275 24.40","Drainage Improvement","Drainage improvement in the ramp infields of Ramps C & D of the interchange of I-275 and SR 747 in Hamilton County.",214398.64300000001,187720,214398.64300000001,214398.64300000001]
[2013,9,80094,"SCI US 52 16.75","Minor Rehabilitation - Pavement Prmy Sys","It is proposed to repair and the resurface the highway.",13160114.388,12606500,13160114.388,13160114.388]
[2013,9,91922,"D09 Scioto Trail & ShawneeForest","Culvert Construction/Reconstr/Repair","In Shawnee State Forest, it is proposed to repair/replace 43 culverts on Forest Road #1, 66 culverts on Forest Road #2, and 3 culverts on Forest Road #16. The work ranges from placing headwalls at the inlet, replacing some deteriorated corrugated metal pi",639002.58200000005,657100,639002.58200000005,639002.58200000005]
[2013,10,83703,"WAS CR 14 0.060","Bridge Replacement","Bridge replacement project over the Little Musking River.  WAS CR 14 0.06, SFN 8430403.  CEAO funded project using Credit Bridge.",1233319.8910000001,1146638.04,1233319.8910000001,1233319.8910000001]
[2013,11,81486,"BEL SR 7 11.870","Minor Rehabilitation - Pavement Prmy Sys","Priority System minor rehabilation of existing concrete pavement:  minimal joint repair, overlay with asphalt, replace median barrier, replace guardrail.  The project will also include minor deck patching on bridges within the project limits.",3524504.69,3375340,3524504.69,3524504.69]
[2013,11,84332,"COL US 30 34.40","Signs","Upgrade existing signing along US 30 and SR 39 in Columbiana County and along US 22 in Jefferson County.  This includes all signing at the interchanges along these routes.",593857.55799999996,557870,593857.55799999996,593857.55799999996]
[2013,12,92951,"CUY IR 090 18.15","Bridge Deck Replacement","Replace the deck of the South Marginal Rd bridge over IR-90 in Cleveland.",854272.674,807790,854272.674,854272.674]
[2014,3,93093,"RIC SR 0096 13.41","Bridge Deck Replacement","Box Beam Replacement @ RIC-096-13.41",null,403907,403907,403907]
[2014,4,76340,"STA US 62/62T/173/183/225 VAR","Bridge Deck Replacement","Re-Deck of 2 bridges (Beeson & Vine) and Miscellaneous bridge work to 9 structures.",null,5086000,5086000,5086000]
[2014,4,84754,"MAH IR 680 12.10/14.37","Bridge Replacement","Bridge replacement and widening. Construct a Westbound right turn lane on Western Reserve Road at the intersection with the IR-680 Northbound on-ramp. Resurfacing of IR-680 from US-224 to Ohio Turnpike, with minor bridge work.",null,8822000,8822000,8822000]
[2014,4,88372,"POR Rock Spring (CR 0052) 02.78","Bridge Repair","Bridge rehabilitation.Credit Bridge funding being utilized. MAXed at $340,650.",null,1760000,1760000,1760000]
[2014,4,89458,"SUM IR 0271 12.62","Major Reconstruction","Widening from four to six lanes, including the replacing and widening of four structures (Over SR82 and over Conrail RR).",null,62000000,62000000,62000000]
[2014,4,93445,"SUM SR 0008 16.66","Noise Wall","Construction of noise wall.",null,5500000,5500000,5500000]
[2014,4,94516,"MAH US 0422 03.62","Bridge Deck Replacement","Bridge re-deck of sfn# 5004434, provide repairs to slope protection, including steel retaining wall. Replace signing. In the City of Youngstown, Mahoning County, Ohio.",null,2075000,2075000,2075000]
[2014,6,83340,"UNI CR 84 0.261","Bridge Replacement","Replace existing steel truss bridge with a new structure.Over Little Darby Creek.Local-let with Union County as lead agency.",null,1108400,1108400,1108400]
[2014,6,83953,"DEL SR 605 1.900","Bridge Repair","Replace bridge over Duncan Run.",null,930000,930000,930000]
[2014,6,94460,"FRA IR 70/Hilliard Rome Int","Section Improvement","FRA-70/Hilliard Rome Rd interflush projectNew Signal at N side of interchang with ramp realigments and wideningAdd lane both directions between I-70 & Meijer DriveAdd NB dual left turn lanes on Hilliard Rome at Renner Rd",null,5905000,5905000,5905000]
[2014,7,76667,"MOT IR 70 10.79","Major Reconstruction","Full depth removal and replacement of the existing IR 70 mainline pavement, including interchange ramps; Addition of a third lane in each direction as a result of MOT operations; rehabilitation or replacement of various bridges; and, other roadway improve",null,50439046.649999999,50439046.649999999,50439046.649999999]
[2014,8,75643,"HAM IR 71 1.34 Phase 1","Bridge Repair","Project will perform general rehabilitation and repair to the Lytle Tunnel, Bridge No. HAM-71-0134, SFN:  3106578.  Repairs will include sealing of tunnel joints, replacement of tiling, and repair/replacement/upgrade of lighting systems.  Electrical syste",null,12567000,12567000,12567000]
[2014,8,82976,"HAM IR 275 10.57","Major Rehabilitation","Plane, repair, and pave a portion of IR 275 in Hamilton County from the overlap section with I-74 (SLM 10.57) to approximately milepost 34 (SLM 16.12). Overlay and misc bridge work to bridges including HAM-74-0979 (SFN 3108414), HAM-275-1070R (SFN 3116298",null,33500000,33500000,33500000]
[2014,8,87128,"WAR SR 48 8.94","Bridge Deck Replacement","Rehabilitate bridge WAR-48-0896 by replacing the concrete deck and painting the structural steel.",null,1284000,1284000,1284000]
[2014,8,87401,"HAM/WAR IR71 19.41/0.00 Loop Rmp","Interchange, Reconstruction","Project will improve safety and reduce congestion by constructing a NB loop ramp from I-71 to Mason Montgomery Rd. This ramp will reduce traffic at the intersection of the existing NB exit ramp with Mason Rd. and the intersection of Fields-Ertel Rd. with",null,13432600,13432600,13432600]
[2014,8,92105,"WAR/GRE US 42 17.94/0.00","Minor Rehabilitation - Pavement Gnrl Sys","Rehabilitation of the 4-Lane section of US 42 in Warren and Greene Counites.  This work is primarily pavement rehabilitation.  The existing pavement to be break & seat with a new asphalt overlay.",null,15622000,15622000,15622000]
[2014,8,94289,"BUT TR 134 7.36 D-B Bridge Rehab","Bridge Deck Replacement","Improvements to Bridge No. BUT-TR 134-7.36 which carries Yankee Road over Dick's Creek. Improvements include replacement of the existing concrete deck, replacement of existing steel beams, removing and replacing the concrete backwalls and expansion joints",null,1014000,1014000,1014000]
[2014,8,94628,"HAM IR 71 14.33","Spot Safety","Provide an auxiliary lane for southbound IR71 from the Pfeiffer on ramp to the SR126 off ramp.  Requires moving of a short section of noise wall.",null,2700000,2700000,2700000]
[2014,8,95745,"CLE CR 62 5.63 Des-Bld Br Rehab","Bridge Deck Replacement","Project proposes to replace the existing bridge deck, painting of the existing steel beams and cross frames, bearing replacement, end cross frame replacement, and beam end repairs. Bridge carries CR-62 (Jackson Pike) over the East Fork Little Miami River.",null,958636,958636,958636]
[2014,9,93801,"BRO US 68 30.72 Safety","Turn Lane Addition","Within the Village of Mt. Orab, it is proposed to add left turn lanes on US68 at both SR32 ramp intersections and coordinate the signaels with adjacent signals. Add right turn lane on SR32 eastbound off ramp at it intersections with US68.",null,2277115.15,2277115.15,2277115.15]
[2014,11,94449,"COL SR 11 17.770","Bridge Deck Replacement","Replace existing superstructure on two (L & R) continuous steel beam bridges. Slight profile adjustment will be required to increase vertical clearance.",null,1750900,1750900,1750900]
[2014,11,95660,"HAS US 250 7.800","Bridge Replacement","Replace existing bridge with new single span slab bridge",null,418550,418550,418550]
[2014,12,82119,"CUY IR 090 14.90 EB Design Build","Bridge Replacement","Design-Build-Finance ContractConstruct a new structure to replace existng Innerbelt Bridge (1809393).  CCG2.  Work includes the demolition of the existing structure,  (PID 88318) and the replacement of the I-71 bridge deck over I-90/490 (PID 86824).",null,366415906,366415906,366415906]
[2014,12,94723,"CUY IR 480 11.60 Interchange","Intersection Improvement","Upgrade the IR-480 and Tiedeman Interchange in the City of Brooklyn to improve traffic flow.  SFY2013 pilot Quick Clear project.",null,2482300,2482300,2482300]
[2015,2,95437,"HAN/WOO 75 19.22/0.00 Pav Widen","Major Widening","A major new funded project to widen I-75 to three lanes in each direction; perform necessary related work.",null,51500000,51500000,51500000]
[2015,3,88825,"LOR SR 0018 12.29","Bridge Repair","Replace Box Beam SuperstructureLOR-SR-18-12.29Design Build selected at 07/18/11 WP Meeting",null,440000,440000,440000]
[2015,6,16707,"MAD TR 24 02.750","Bridge Replacement","Replacement of deficient narrow structure over Little Darby Creek",null,1486000,1486000,{"$f":"IF(G195<>0,G195,H195)","v":1486000}]
[2015,8,84613,"CLE SR 32 7.69N","Bridge Deck Replacement","Replace continuous slab superstructure of bridge CLE-32-0769N.",null,1262800,1262800,1262800]
[2015,10,87371,"GAL CR 20 9.370","Bridge Replacement","Bridge replacement project. Work includes removal of superstructure and selective demolition of piers, abutments and substructure.  Replacement to include widening to new standards. GAL CR 20 9.37 SFN 2734109. Bridge width 20', Pavement/Roadway width 19',",null,1322289.95,{"$f":"IF(G197=\"\",H197,G197)","v":1322289.95},1322289.95]
[2016,4,93501,"SUM IR 0076 00.00","Major Rehabilitation","Complete pavement replacement from Medina County line to State Route 21. Pavement replacement and widening to six lanes from State Route 21 to State Route 619.",null,134269000,134269000,134269000]
[2016,6,83988,"FRA IR 270-49.00 (at Alum Cr Dr)","Interchange, Reconstruction","Unfunded projectConstruct new IR 270 SB to WB on ramp, widen IR 270 EB off ramp, widen Alum Creek Dr to provide appropriate turn lanes including the structure over IR 2703rd project resulting from study of I-270/Alum Creek interchange for safety and capac",null,null,0,0]
[2016,8,88679,"HAM IR 74 9.53","Minor Rehabilitation - Pavement Prmy Sys","Minor rehab on the pavement including structures of I-74 from the overlap section to I-75.  The mainline and ramp work at the North Bend interchange is omitted with this project and included in pid 93079.",null,16663900,16663900,16663900]
[2016,8,90438,"PRE CR 45 6.89 Des-Build Br Repl","Bridge Replacement","Project includes replacement of structurally deficient Bridge No. PRE-CR 45-0100 (SFN: 6835414), which serves to carry CR-45 over Paint Creek. Improvements include pavement repairs, and improvements to the vertical alignment/profile of the roadway.",null,388000,388000,388000]
[2016,9,87298,"ADA US 52 12.49 Brdg Replace","Bridge Replacement","It is proposed to replace the deficient structure (SFN0101982).",null,1733400,1733400,1733400]
[2016,10,87862,"D10 Signal Maint. FY 2016","Signals","Signal Maintenance project.  Replacement of poles, signal heads, pavement loops, wiring, etc.. at various locations in D-10.",null,364000,364000,364000]
[2017,5,93273,"FAI US 22 23.88","New Bridge","Replace Bridge",null,10700000,10700000,10700000]
[2017,10,93152,"GAL TR 752 0.29","Bridge Replacement","Bridge replacement project. GAL TR 752 0.29 (SFN 2743531).",null,1043000,1043000,1043000]
[2018,6,93446,"FRA IR 71 Noise Wall Repair","Noise Wall","Design Build project to replace existing noise wall panels with fibergalss panels.  Reuse existing steel posts.SB 5th Ave ramp to I-71 SBSB 5th Ave ramp to I-670 WB",null,1100000,1100000,1100000]
[2018,9,93983,"SCI TR 99 4.81 Brdg Replace","Bridge Replacement","On TR 99, Mackletree Road, 4.81m 0.29 miles from where it ends and intersects with SR125, it is proposed to replace the structure (SFN 7332882).",null,1578785,1578785,1578785]
[2018,10,93151,"GAL CR 121 1.52","Bridge Replacement","Bridge replacement project. GAL CR 121 1.52 (SFN 2740516).",null,290000,290000,290000]
[2018,10,93153,"GAL TR 766 0.05","Bridge Replacement","Bridge replacement project. GAL TR 766 0.05 (SFN 2743566).",null,927000,927000,927000]
[2018,12,82380,"CUY INNERBELT CCG3","Major Rehabilitation","CCG3: Improve I-90 in the ôCentral Interchangeö area between E 9th Street and E 22nd Street; improve E 22nd Street using part-width construction; remove the Cedar Avenue bridge over I-90; improve I-77 north of the Kingsbury Run Bridge; and replace the Car",null,398950000,398950000,398950000]
[2025,6,93605,"MAD IR 70 10.270 Phase 2","Interchange, Reconstruction","Construction of the second phase of work at the I-70 and SR-29 interchange.Includes construction of an adjacent bridge structure over I-70, a two-lane roundabout at the I-70 EB exit/entrance ramps, pavement widening, RW south of I-70, and expansion of sec",null,11000000,11000000,11000000]
[null,null,null,null,null,null,null,null,0,0]
[null,null,null,null,null,null,null,null,0,0]
[null,null,null,null,null,null,null,null,0,0]
[null,null,null,null,null,null,null,null,0,0]
[null,null,null,null,null,null,null,null,0,0]
[null,null,null,null,null,null,null,null,0,0]
[null,null,null,null,null,null,null,null,0,0]
[null,null,null,null,null,null,null,null,0,0]
[null,null,null,null,null,null,null,null,0,0]
[null,null,null,null,null,null,null,null,0,0]
[null,null,null,null,null,null,null,null,0,0]
[null,null,null,null,null,null,null,null,0,0]
[null,null,null,null,null,null,null,null,0,0]
[null,null,null,null,null,null,null,null,0,0]
[null,null,null,null,null,null,null,null,0,0]
[null,null,null,null,null,null,null,null,0,0]
[null,null,null,null,null,null,null,null,0,0]
[null,null,null,null,null,null,null,null,0,0]
[null,null,null,null,null,null,null,null,0,0]
[null,null,null,null,null,null,null,null,0,0]
[null,null,null,null,null,null,null,null,0,0]
[null,null,null,null,null,null,null,null,0,0]
[null,null,null,null,null,null,null,null,0,0]
[null,null,null,null,null,null,null,null,0,0]
[null,null,null,null,null,null,null,null,0,0]
[null,null,null,null,null,null,null,null,0,0]
[null,null,null,null,null,null,null,null,0,0]
[null,null,null,null,null,null,null,null,0,0]
[null,null,null,null,null,null,null,null,0,0]
[null,null,null,null,null,null,null,null,0,0]
[null,null,null,null,null,null,null,null,0,0]
[null,null,null,null,null,null,null,null,0,0]
[null,null,null,null,null,null,null,null,0,0]
[null,null,null,null,null,null,null,null,0,0]
[null,null,null,null,null,null,null,null,0,0]
[null,null,null,null,null,null,null,null,0,0]
[null,null,null,null,null,null,null,null,0,0]
[null,null,null,null,null,null,null,null,0,0]
[null,null,null,null,null,null,null,null,0,0]
[null,null,null,null,null,null,null,null,0,0]
[null,null,null,null,null,null,null,null,0,0]
[null,null,null,null,null,null,null,null,0,0]
[null,null,null,null,null,null,null,null,0,0]
[null,null,null,null,null,null,null,null,0,0]
[null,null,null,null,null,null,null,null,0,0]
[null,null,null,null,null,null,null,null,0,0]
[null,null,null,null,null,null,null,null,0,0]
[null,null,null,null,null,null,null,null,0,{"$f":"IF(G259<>0,G259,H259)","v":0}]
[null,null,null,null,null,null,null,null,0,0]
[null,null,null,null,null,null,null,null,{"$f":"IF(G261=\"\",H261,G261)","v":0},0]
[null,null,null,null,null,null,null,null,0,0]
[null,null,null,null,null,null,null,null,0,0]
[null,null,null,null,null,null,null,null,0,0]
[null,null,null,null,null,null,null,null,0,0]
[null,null,null,null,null,null,null,null,0,0]
[null,null,null,null,null,null,null,null,0,0]
[null,null,null,null,null,null,null,null,0,0]
[null,null,null,null,null,null,null,null,0,0]
[null,null,null,null,null,null,null,null,0,0]
[null,null,null,null,null,null,null,null,0,0]
[null,null,null,null,null,null,null,null,0,0]
[null,null,null,null,null,null,null,null,0,0]
[null,null,null,null,null,null,null,null,0,0]
[null,null,null,null,null,null,null,null,0,0]
[null,null,null,null,null,null,null,null,0,0]
[null,null,null,null,null,null,null,null,0,0]
[null,null,null,null,null,null,null,null,0,0]
[null,null,null,null,null,null,null,null,0,0]
[null,null,null,null,null,null,null,null,0,0]
[null,null,null,null,null,null,null,null,0,0]
[null,null,null,null,null,null,null,null,0,0]
[null,null,null,null,null,null,null,null,0,0]
[null,null,null,null,null,null,null,null,0,0]
[null,null,null,null,null,null,null,null,0,0]
[null,null,null,null,null,null,null,null,0,0]
[null,null,null,null,null,null,null,null,0,0]
[null,null,null,null,null,null,null,null,0,0]
[null,null,null,null,null,null,null,null,0,0]
[null,null,null,null,null,null,null,null,0,0]
[null,null,null,null,null,null,null,null,0,0]
[null,null,null,null,null,null,null,null,0,0]
[null,null,null,null,null,null,null,null,0,0]
[null,null,null,null,null,null,null,null,0,0]
[null,null,null,null,null,null,null,null,0,0]
[null,null,null,null,null,null,null,null,0,0]
[null,null,null,null,null,null,null,null,0,0]
[null,null,null,null,null,null,null,null,0,0]
[null,null,null,null,null,null,null,null,0,0]
[null,null,null,null,null,null,null,null,0,0]
[null,null,null,null,null,null,null,null,0,0]
[null,null,null,null,null,null,null,null,0,0]
[null,null,null,null,null,null,null,null,0,0]
[null,null,null,null,null,null,null,null,0,0]
[null,null,null,null,null,null,null,null,0,0]
[null,null,null,null,null,null,null,null,0,0]
[null,null,null,null,null,null,null,null,0,0]
[null,null,null,null,null,null,null,null,0,0]
[null,null,null,null,null,null,null,null,0,0]
[null,null,null,null,null,null,null,null,0,0]
[null,null,null,null,null,null,null,null,0,0]
[null,null,null,null,null,null,null,null,0,0]
[null,null,null,null,null,null,null,null,0,0]
[null,null,null,null,null,null,null,null,0,0]
[null,null,null,null,null,null,null,null,0,0]
[null,null,null,null,null,null,null,null,0,0]
[null,null,null,null,null,null,null,null,0,0]
[null,null,null,null,null,null,null,null,0,0]
[null,null,null,null,null,null,null,null,0,0]
[null,null,null,null,null,null,null,null,0,0]
[null,null,null,null,null,null,null,null,0,0]
[null,null,null,null,null,null,null,null,0,0]
[null,null,null,null,null,null,null,null,0,{"$f":"IF(G323<>0,G323,H323)","v":0}]
[null,null,null,null,null,null,null,null,0,0]
[null,null,null,null,null,null,null,null,{"$f":"IF(G325=\"\",H325,G325)","v":0},0]
[null,null,null,null,null,null,null,null,0,0]
[null,null,null,null,null,null,null,null,0,0]
[null,null,null,null,null,null,null,null,0,0]
[null,null,null,null,null,null,null,null,0,0]
[null,null,null,null,null,null,null,null,0,0]
[null,null,null,null,null,null,null,null,0,0]
[null,null,null,null,null,null,null,null,0,0]
[null,null,null,null,null,null,null,null,0,0]
[null,null,null,null,null,null,null,null,0,0]
[null,null,null,null,null,null,null,null,0,0]
[null,null,null,null,null,null,null,null,0,0]
[null,null,null,null,null,null,null,null,0,0]
[null,null,null,null,null,null,null,null,0,0]
[null,null,null,null,null,null,null,null,0,0]
[null,null,null,null,null,null,null,null,0,0]
[null,null,null,null,null,null,null,null,0,0]
[null,null,null,null,null,null,null,null,0,0]
[null,null,null,null,null,null,null,null,0,0]
[null,null,null,null,null,null,null,null,0,0]
[null,null,null,null,null,null,null,null,0,0]
[null,null,null,null,null,null,null,null,0,0]
[null,null,null,null,null,null,null,null,0,0]
[null,null,null,null,null,null,null,null,0,0]
[null,null,null,null,null,null,null,null,0,0]
[null,null,null,null,null,null,null,null,0,0]
[null,null,null,null,null,null,null,null,0,0]
[null,null,null,null,null,null,null,null,0,0]
[null,null,null,null,null,null,null,null,0,0]
[null,null,null,null,null,null,null,null,0,0]
[null,null,null,null,null,null,null,null,0,0]
[null,null,null,null,null,null,null,null,0,0]
[null,null,null,null,null,null,null,null,0,0]
[null,null,null,null,null,null,null,null,0,0]
[null,null,null,null,null,null,null,null,0,0]
[null,null,null,null,null,null,null,null,0,0]
[null,null,null,null,null,null,null,null,0,0]
[null,null,null,null,null,null,null,null,0,0]
[null,null,null,null,null,null,null,null,0,0]
[null,null,null,null,null,null,null,null,0,0]
[null,null,null,null,null,null,null,null,0,0]
[null,null,null,null,null,null,null,null,0,0]
[null,null,null,null,null,null,null,null,0,0]
[null,null,null,null,null,null,null,null,0,0]
[null,null,null,null,null,null,null,null,0,0]
[null,null,null,null,null,null,null,null,0,0]
[null,null,null,null,null,null,null,null,0,0]
[null,null,null,null,null,null,null,null,0,0]
[null,null,null,null,null,null,null,null,0,0]
[null,null,null,null,null,null,null,null,0,0]
[null,null,null,null,null,null,null,null,0,0]
[null,null,null,null,null,null,null,null,0,0]
[null,null,null,null,null,null,null,null,0,0]
[null,null,null,null,null,null,null,null,0,0]
[null,null,null,null,null,null,null,null,0,0]
[null,null,null,null,null,null,null,null,0,0]
[null,null,null,null,null,null,null,null,0,0]
[null,null,null,null,null,null,null,null,0,0]
[null,null,null,null,null,null,null,null,0,0]
[null,null,null,null,null,null,null,null,0,0]
[null,null,null,null,null,null,null,null,0,0]
[null,null,null,null,null,null,null,null,0,0]
[null,null,null,null,null,null,null,null,0,{"$f":"IF(G387<>0,G387,H387)","v":0}]
[null,null,null,null,null,null,null,null,0,0]
[null,null,null,null,null,null,null,null,{"$f":"IF(G389=\"\",H389,G389)","v":0},0]
[null,null,null,null,null,null,null,null,0,0]
[null,null,null,null,null,null,null,null,0,0]
[null,null,null,null,null,null,null,null,0,0]
[null,null,null,null,null,null,null,null,0,0]
[null,null,null,null,null,null,null,null,0,0]
[null,null,null,null,null,null,null,null,0,0]
[null,null,null,null,null,null,null,null,0,0]
[null,null,null,null,null,null,null,null,0,0]
[null,null,null,null,null,null,null,null,0,0]
[null,null,null,null,null,null,null,null,0,0]
[null,null,null,null,null,null,null,null,0,0]
[null,null,null,null,null,null,null,null,0,0]
[null,null,null,null,null,null,null,null,0,0]
[null,null,null,null,null,null,null,null,0,0]
[null,null,null,null,null,null,null,null,0,0]
[null,null,null,null,null,null,null,null,0,0]
[null,null,null,null,null,null,null,null,0,0]
[null,null,null,null,null,null,null,null,0,0]
[null,null,null,null,null,null,null,null,0,0]
[null,null,null,null,null,null,null,null,0,0]
[null,null,null,null,null,null,null,null,0,0]
[null,null,null,null,null,null,null,null,0,0]
[null,null,null,null,null,null,null,null,0,0]
[null,null,null,null,null,null,null,null,0,0]
[null,null,null,null,null,null,null,null,0,0]
[null,null,null,null,null,null,null,null,0,0]
[null,null,null,null,null,null,null,null,0,0]
[null,null,null,null,null,null,null,null,0,0]
[null,null,null,null,null,null,null,null,0,0]
[null,null,null,null,null,null,null,null,0,0]
[null,null,null,null,null,null,null,null,0,0]
[null,null,null,null,null,null,null,null,0,0]
[null,null,null,null,null,null,null,null,0,0]
[null,null,null,null,null,null,null,null,0,0]
[null,null,null,null,null,null,null,null,0,0]
[null,null,null,null,null,null,null,null,0,0]
[null,null,null,null,null,null,null,null,0,0]
[null,null,null,null,null,null,null,null,0,0]
[null,null,null,null,null,null,null,null,0,0]
[null,null,null,null,null,null,null,null,0,0]
[null,null,null,null,null,null,null,null,0,0]
[null,null,null,null,null,null,null,null,0,0]
[null,null,null,null,null,null,null,null,0,0]
[null,null,null,null,null,null,null,null,0,0]
[null,null,null,null,null,null,null,null,0,0]
[null,null,null,null,null,null,null,null,0,0]
[null,null,null,null,null,null,null,null,0,0]
[null,null,null,null,null,null,null,null,0,0]
[null,null,null,null,null,null,null,null,0,0]
[null,null,null,null,null,null,null,null,0,0]
[null,null,null,null,null,null,null,null,0,0]
[null,null,null,null,null,null,null,null,0,0]
[null,null,null,null,null,null,null,null,0,0]
[null,null,null,null,null,null,null,null,0,0]
[null,null,null,null,null,null,null,null,0,0]
[null,null,null,null,null,null,null,null,0,0]
[null,null,null,null,null,null,null,null,0,0]
[null,null,null,null,null,null,null,null,0,0]
[null,null,null,null,null,null,null,null,0,0]
[null,null,null,null,null,null,null,null,0,0]
[null,null,null,null,null,null,null,null,0,0]
[null,null,null,null,null,null,null,null,0,{"$f":"IF(G451<>0,G451,H451)","v":0}]
[null,null,null,null,null,null,null,null,0,0]
[null,null,null,null,null,null,null,null,{"$f":"IF(G453=\"\",H453,G453)","v":0},0]
[null,null,null,null,null,null,null,null,0,0]
[null,null,null,null,null,null,null,null,0,0]
[null,null,null,null,null,null,null,null,0,0]
[null,null,null,null,null,null,null,null,0,0]
[null,null,null,null,null,null,null,null,0,0]
[null,null,null,null,null,null,null,null,0,0]
[null,null,null,null,null,null,null,null,0,0]
[null,null,null,null,null,null,null,null,0,0]
[null,null,null,null,null,null,null,null,0,0]
[null,null,null,null,null,null,null,null,0,0]
[null,null,null,null,null,null,null,null,0,0]
[null,null,null,null,null,null,null,null,0,0]
[null,null,null,null,null,null,null,null,0,0]
[null,null,null,null,null,null,null,null,0,0]
[null,null,null,null,null,null,null,null,0,0]
[null,null,null,null,null,null,null,null,0,0]
[null,null,null,null,null,null,null,null,0,0]
[null,null,null,null,null,null,null,null,0,0]
[null,null,null,null,null,null,null,null,0,0]
[null,null,null,null,null,null,null,null,0,0]
[null,null,null,null,null,null,null,null,0,0]
[null,null,null,null,null,null,null,null,0,0]
[null,null,null,null,null,null,null,null,0,0]
[null,null,null,null,null,null,null,null,0,0]
[null,null,null,null,null,null,null,null,0,0]
[null,null,null,null,null,null,null,null,0,0]
[null,null,null,null,null,null,null,null,0,0]
[null,null,null,null,null,null,null,null,0,0]
[null,null,null,null,null,null,null,null,0,0]
[null,null,null,null,null,null,null,null,0,0]
[null,null,null,null,null,null,null,null,0,0]
[null,null,null,null,null,null,null,null,0,0]
[null,null,null,null,null,null,null,null,0,0]
[null,null,null,null,null,null,null,null,0,0]
[null,null,null,null,null,null,null,null,0,0]
[null,null,null,null,null,null,null,null,0,0]
[null,null,null,null,null,null,null,null,0,0]
[null,null,null,null,null,null,null,null,0,0]
[null,null,null,null,null,null,null,null,0,0]
[null,null,null,null,null,null,null,null,0,0]
[null,null,null,null,null,null,null,null,0,0]
[null,null,null,null,null,null,null,null,0,0]
[null,null,null,null,null,null,null,null,0,0]
[null,null,null,null,null,null,null,null,0,0]
[null,null,null,null,null,null,null,null,0,0]
[null,null,null,null,null,null,null,null,0,0]
[null,null,null,null,null,null,null,null,0,0]