Spreadsheet: 20f3720f-f036-43a1-b805-60aa83f41721
Sheet: Culv9-Replace

Sl. No. | Crossing Name | Drainage Area (acres) |  | DNR Permit (Yes - 1, No - 0) | Rpalcement (0) / New Allignment (1) |  | Reamrks if any | Area in sq. mile | Inlet Elev | trail water depth at dsg. Dischrg | allowable back water | AHW | Roadway Crest elev | cover | pavment thickness | pipe thicness | maximum allowable rise | Existing Structure size | Area | [NAME] | Eixsting outlet velocity | EHW | proposed inlet elv (if different from the exiting elev) | trail water depth at dsg. Dischrg | allowable back water | AHW | Roadway Crest elev | cover | pavment thickness | pipe thicness | maximum allowable rise | [NAME] | DHW 1 | BW1 | oulet velocity 1 for Q100 | [NAME] | DHW 2 | BW2 | oulet velocity 2 for Q100 | Remarks if any
1 | CR1200N | 99.63 |  | 0 | 0 |  | 1' backwater was practiced |  | 473.02 | 3.56 | 1 |  | 477.12 | 1 | 1 | 0.6 |  | 1.25' CMP |  | 1.06' |  | 477.63 | 473.03 | 3.56 | 1 |  | 512.98 | 1 | 1 | 0.6 |  | 6' x 4' precast conc box | 477.59 | 1.01 | 6.5' ft/sec | 9' x 4.71' Arch Open Bottom Corrugated Steel | 477.3 | 0.72 | 4.87 ft/sec
2 | US 421 Carol County, Des. # 0201034 |  |  | 1 | 0 |  | 3.02' backwater, approved by INDOT | 2.36 |  |  |  |  |  |  |  |  |  | See remarks |  | 4.25' |  |  |  |  |  |  |  |  |  |  |  | 12' x 5' conc box |  | 3.02 | 10.4' ft/sec | Special permission was given based on outlet velocity (< 10 ft/sec) and raod serviceability than backwater critria
3 | US 24 Newton County, Des. # 0200068 |  |  | 0 | 0 |  | 1' backwater was practiced | 0.5 |  |  |  |  |  |  |  |  |  | 4' x 3' conc box |  | 3.1' |  |  | road overtopping complain within lanst few years, may be undersized due to improvement in the catchment area |  |  |  |  |  |  |  |  | 9' x 4' reinforced conc box |  | 0.79 | 8.6 ft/sec
4 | SR66 [NAME] Des# 0800794 |  |  | 1 | 0 |  | 1' backwater was practiced | 1.81 |  |  |  |  |  |  |  |  |  | 10' dia structural steel plate pipe |  | 4.38' | 11.52 ft/sec |  |  |  |  |  |  |  |  |  |  | 12' x 8' conc. Box |  | 1 | 10.53 ft/sec
5 | CN-49600-US50, Seg-7 | 116.6 |  | 0 | 0 |  | 1' backwater was practiced |  |  |  |  |  |  |  |  |  |  | 18' x 3' conc. Box |  | 0.71 | 10.508 | 470.3 |  |  |  |  |  |  |  |  |  | 19' x 4' conc. Box | 470.57 | 0.68 | 5.423 ft/sec | 21.5' x 7,75' corrugated steel arch | 470.6 | 0.71 | 4.86 ft/sec | New structure is needed due to relocation of US50 on new alignment
6 | SR58-SER | 13.15 |  | 0 | 1 |  | 1' backwater was practiced |  | 478.57 | 1.79 | 1 |  | 489.47 | 1 | 1 | 0.6 |  | not mentioned, see the remarks |  |  |  |  |  |  |  |  |  |  |  |  |  | 3' RCP | 481.31 | 0.952 | 9.5 ft/sec | 4.5' dia corrugated steel pipe | 481.36 | 1 | 5.75 ft/sec | Head water is contained fully within th INDOT right-of-way
7 | SR58-SWR | 18.33 |  | 0 | 1 |  | 1' backwater was practiced |  | 478.27 | 1.88 | 1 |  | 489.84 | 1 | 1 | 0.6 |  | not mentioned, see the remarks |  |  |  |  |  |  |  |  |  |  |  |  |  | 3.5' RCP | 481 | 0.851 | 10.272 ft/sec | 5' dia corrugated steel pipe | 481.12 | 0.975 | 5.57 ft/sec | Head water is contained fully within th INDOT right-of-way
8 | CN-51750-US50, Seg-7 | 53.3 |  | 0 | 0 |  | replacement strcture |  | 472.18 | 1.55 | 1 |  | 486.75 | 1 | 1 | 0.6 |  | 3' dia corrugated steel pipe |  | 9.5' | 12.11 ft/sec | 483.27 | 471.58 | 1.55 | 1 |  | 486.75 | 1 | 1 | 0.6 |  | 9' x 4' CB | 474 | 0.87 | 6.12 ft/sec | 11.40' x 7.24' CMA | 474.13 | 1 | 5.0 ft/sec | Watershed is located entirely within the interchnage infield area
Sl. No. | Crossing Name | Drainage Area (acres) |  | design discharge | DNR Permit (Yes - 1, No - 0) |  | Rpalcement (0) / New Allignment (1) | Reamrks if any | Area in sq. mile | [NAME] | d1 | d2 | Area (ft2) | Decrease in Area | Inlet Elev | trail water depth at design discharge | allowable back water | Allowable Head Water |  | Design Head Water | Backwater 1 (feet) | Backwater 1 (feet)  Erroneously reported | outlet velocity for 100 yr friquency 1 (ft/sec) | inc in velocity | roadway crest elev | inlet elev | cover | pavement thickness | pipe/box thicness | maximum allowable rise | Remarkes | Sl. No. | Crossing Name | [NAME] Proposed 2 | Area (ft2) | are dec | AHW | Design head water | Maximum rise of cluvert | [NAME] (feet) | [NAME] (feet)  Erroneously reported | outlet velocity for 100 yr frequency 2 (ft/sec) | inc in velocity | Remarks
9 | CN-51200-US50, Seg-7 | 18.7 |  |  | 0 |  | 1 |  |  | 4' x 3' CB | 4 | 3 |  |  |  |  |  |  |  |  | 0.6 |  | 6.551 |  |  |  |  |  |  |  |  | 8 | CN-51200-US50, Seg-7 | 7.02' x 5.09' CMA | 28.4 |  |  |  |  | 0.83 |  | 4.83
 |  |  |  | 27.8 |  |  |  | given HY-8 file |  | 4' x 3' CB | 4 | 3 |  |  | 474.79 | 0.934 | 1 |  |  | 476.68 | 0.87 |  | 11.78 |  | 483.47 | 474.79 | 1 | 1 | 0.6 |  |  |  |  | 7.02' x 5.09' CMA | 28.4 |  |  | 476.45 |  | 0.77 |  | 5.08
 |  |  |  |  |  |  |  | reduced structure size |  | NA |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 6.33' x 4.76' CMA | 24.1 |  |  | 476.54 |  | 0.86 |  | 5.17
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 6.08' x 4.58' CMA | 22.09 |  |  | 476.5 |  | 0.82 |  | 5.34 |  | this is the lowest structure size in this shape
 | RCP | Reinforced Concrete Pipe
 | CMP | Corrugated Metal Pipe
 | CMA | Corrugated Metal Arch
 | PCB | Precast Concrete Box
Sl. No | Corssing Name | Existing Structure | Existing bcakwater | area (ft2) | Proposed Replacement Structure size | proposed backwater | area (ft2) | average increase in the bid price per unit length (feet) of structure from data | % incease from data | increase in the bid price per unit length (feet) of structure from model | % incease from model | Remarkes
1 | US 24 Newton County, Des. # 0200068 | 4' x 3' conc box | 3.1' | 12 | 9' X 4' CB | 0.79' | 36 | 218 | 0.61 | 151 | 0.425
2 | CN-49600-US50, Seg-7 | 18' x 3' conc box | 0.71 | 54 | 19' X 4' CB | 0.68' | 76 | 136 | 0.19 | 252 | 0.383 | increase from data is caluated from 10*8 size sturcture because no 19*4 structure was available in the data
3 | CR1200N | 1.25' CMP | 1.06' | 1.2 | 6' x 4' CB | 1.01' | 24 |  |  | 121 | 0.4 | no data correcspond g to pipe steructure is avaible. Hence for existing structure bid price is calculted from corrsponding area 4 sided structure using the model
4 | SR66 [NAME] Des# 0800794 | 10' dia structural steel plate pipe | 4.38' | 78.5 | 12' x 8' CB | 1.0' | 96 |  |  | 278 | 0.295
5 | CN-51750-US50, Seg-7 | 3' dia corrugated steel pipe | 9.5' | 7.1 | 9' X4' CB | 0.87' | 36 |  |  | 176 | 0.53
Sl. No | Corssing Name | Existing Structure | Existing bcakwater | Proposed Replacement Structure size | proposed backwater | average increase in the bid price per unit length (feet) of structure from data | % incease from data | increase in the bid price per unit length (feet) of structure from model | % incease from model | Remarkes
1 | US 24 Newton County, Des. # 0200068 | 4' x 3' conc box | 3.1' | 9' X 4' CB | 0.79' | 218 | 0.61 | 151 | 0.425
2 | CN-49600-US50, Seg-7 | 18' x 3' conc box | 0.71 | 19' X 4' CB | 0.68' | 136 | 0.19 | 252 | 0.383 | Note 1
3 | CR1200N | 1.25' CMP | 1.06' | 6' x 4' CB | 1.01' |  |  | 121 | 0.4 | Note 2
4 | SR66 [NAME] Des# 0800794 | 10' dia structural steel plate pipe | 4.38' | 12' x 8' CB | 1.0' |  |  | 278 | 0.295
5 | CN-51750-US50, Seg-7 | 3' dia corrugated steel pipe | 9.5' | 9' X4' CB | 0.87' |  |  | 176 | 0.53
Note 1 | increase from data is caluated from 10*8 size sturcture because no 19*4 structure was available in the data
Note 2 | no data correcspond g to pipe steructure is avaible. Hence for existing structure bid price is calculted from corrsponding area 4 sided structure using the model