Spreadsheet: 20f3720f-f036-43a1-b805-60aa83f41721
Sheet: Culv7 -NewAlg

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
1 | SR-58W | 25.34 |  | 0 | 1 |  |  | 7' x 3' Precast Conct. Box | 7 | 3 | 21 |  |  |  |  |  |  | 0.287 | 0.11 | 3.676 |  |  |  |  |  |  |  |  | 1 | SR-58W | 10' x 3.46' Open Bottom Corrugated Metal Arch | 25 |  |  |  |  | 0.526 | 0.14 | 3.521
 |  |  |  |  |  | created hy8 file |  | 7' x 3' Conct. Box | 7 | 3 | 21 |  | 476.5 | 1.803 | 0.13 |  | 478.45 | 0.41 |  | 2.36 |  | 484.21 | 476.24 | 1 | 1 | 0.6 |  |  |  |  | 10' x 3.46' Open Bottom Corrugated Metal Arch | 25 |  |  |  |  | 0.58 |  | 2.04
 |  |  |  |  |  | reduced structure size-1 |  | 6' x 3' Conct. Box | 6 | 3 | 18 |  |  |  | 1 |  | 478.52 | 0.48 |  | 2.76 |  |  |  |  |  |  |  |  |  |  | 9' x 3.88' Open Bottom Corrugated Metal Arch | 26.5 |  |  | 478.55 |  | 0.51 |  | 2.1
 |  |  |  |  |  | reduced structure size-2 |  | 5' x 3' Conct. Box | 5 | 3 | 15 |  |  |  |  |  | 478.61 | 0.57 |  | 3.31 |  |  |  |  |  |  |  |  |  |  | 8' x 2.92' Open Bottom Corrugated Metal Arch | 17 |  |  | 478.71 |  | 0.67 |  | 2.74
 |  |  |  |  |  | reduced structure size-3 |  | 4' x 3' conc. Box | 4 | 3 | 12 |  |  |  |  |  | 478.74 | 0.7 |  | 10.06 |  |  |  |  |  |  |  |  |  |  | 6' x 3.17' Open Bottom Corrugated Metal Arch | 15 |  |  | 478.87 |  | 0.83 |  | 3.23
 |  |  |  |  |  | reduced structure size-4 |  | 3' x 3' conc. Box | 3 | 3 |  |  |  |  |  |  | 479.3 | 1.26 |  | 9.89 |  |  |  |  |  |  |  | voilation of BW |  |  | 6' x 2.29' Open Bottom Corrugated Metal Arch | 10 |  |  | 479.54 |  | 1.5 |  |  |  | voilation of AHW and BW
 |  |  |  |  |  | reduced structure size -4 |  | 3' dia circular conc. Pipe | 3 | 3 |  |  |  |  |  |  | 479.96 | 1.92 |  | 10.28 |  |  |  |  |  |  |  | voilation of AHW and BW
 |  |  |  |  |  | reduced structure size -5 |  | 4' dia circular conc. Pipe | 4 | 4 |  |  |  |  |  |  | 479.24 | 1.2 |  | 9.9 |  |  |  |  |  |  |  | voilation of BW
 |  |  |  |  |  | reduced structure size -6 |  | 5' dia circular conc. Pipe | 5 | 5 |  |  |  |  |  |  | 478.89 | 0.85 |  | 9.65
2 | CN-224400, Seg-11 | 19.02 |  | 0 | 1 |  |  | 7' x 3'  precast box | 7 | 3 | 21 |  |  |  |  |  |  | 0.232 | 0.13' | 3.459 |  |  |  |  |  |  |  |  | 2 | CN-224400, Seg-11 | 8' x 4.17' corrugated metal arch | 26 |  |  |  |  | 0.148 | 0.14
 |  |  |  |  |  | created hy8 file |  | 7' x 3'  conc box | 7 | 3 | 21 |  |  |  |  |  |  | -0.05 |  | 5.63 |  |  |  |  |  |  |  |  |  |  | 8' x 4.17' corrugated metal arch | 26 |  |  |  |  | 0.11 |  | 3.1
 |  |  |  |  |  | reduced structure size-1 |  | 5' x 3' conc box | 5 | 3 | 15 |  | 466.5 | 1.612 | 1 |  | 468.43 | 0.32 |  | 7.74 |  | 485.7 | 466.5 | 1 | 1 | 0.6 |  |  |  |  | 7' x 3.67' corrugated metal arch | 20 |  |  | 467.9 |  | 0.29 |  | 3.57
 |  |  |  |  |  | reduced structure size 2 |  | 4' x 3' conc box | 4 | 3 |  |  |  |  |  |  | 468.73 | 0.62 |  | 7.99 |  |  |  |  |  |  |  |  |  |  | 6' x 2.29' corrugated metal arch | 10 |  |  | 468.58 |  | 0.97 |  | 4.67
 |  |  |  |  |  | reduced structure size 3 |  | 3' x 3' conc box | 3 | 3 |  |  |  |  |  |  | 469.21 | 1.1 |  | 8.1 |  |  |  |  |  |  |  | voilation of AHW and BW
 |  |  |  |  |  | reduced structure size 4 |  | 4' dia circular conc. Pipe | 4 | 4 |  |  |  |  |  |  | 469.21 | 1.1 |  | 8.57 |  |  |  |  |  |  |  | voilation of AHW and BW
 |  |  |  |  |  | reduced structure size 5 |  | 5' dia circular conc. Pipe | 5 | 5 |  |  |  |  |  |  | 468.9 | 0.79 |  | 8.43
3 | CN-231200, Seg-11 | 31.49 |  | 0 | 1 |  |  | 3.5' RCP | 3.5 | 3.5 |  |  |  |  |  |  |  | 0.14 |  | 5.271 |  |  |  |  |  |  |  |  | 3 | CN-231200, Seg-11 | 5.33' x 3.58' [NAME] | 14.7 |  |  |  |  | 0.07 |  | 4.28
 |  |  |  |  |  | created hy8 file |  | 3.5' RCP | 3.5 | 3.5 |  |  | 474.13 | 4.28 | 1 |  | 478.55 | 0.14 |  | 5.271 |  | 490.14 | 474.13 | 1 | 1 | 0.6 |  |  |  |  | 5.33' x 3.58' [NAME] | 14.7 |  |  |  |  | 0.07 |  | 3.36
 |  |  |  |  |  | reduced structure size |  | 3' RCP |  |  |  |  |  |  |  |  |  | 1.14 |  | 7.17 |  |  |  |  |  |  |  | voilation of back water |  |  | 4.75' x 3.17' [NAME] | 11.6 |  |  |  |  | 0.79 |  | 4.28
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 4.08' x 2.75' [NAME] |  |  |  | 480.82 |  | 2.41 |  |  |  | voilation of AHW and BW
4 | CN-225300, Seg-11 | 14.08 |  | 0 | 1 |  |  | 5' x 3.17' elleptical RCP |  |  | 12.85 |  |  |  |  |  |  | 0.11 |  | 6.868 |  |  |  |  |  |  |  |  | 4 | CN-225300, Seg-11 | 5.92' x 3.92' CMA | 18.1 |  |  |  |  | 0.14 |  | 6.776
 |  |  |  |  |  | created hy8 file |  | 5' x 3.17' elleptical RCP |  |  | 12.85 |  | 467.49 | 1.733 | 1 |  |  | 0.11 |  | 6.87 |  | 483.17 | 467.49 | 1 | 1 | 0.6 |  |  |  |  | 5.92' x 3.92' CMA | 18.1 |  |  |  |  | 0.12 |  | 3.37
 |  |  |  |  |  | reduced structure size-1 |  | 4.41' x 2.83' elleptical RCP |  |  | 10.15 |  |  |  |  |  | 469.49 | 0.27 |  | 6.99 |  |  |  |  |  |  |  |  |  |  | 4.75' x 3.17' CMA | 11.6 |  |  | 469.7 |  | 0.48 |  | 4.18
 |  |  |  |  |  | reduced structure size 2 |  | 4.08' x 2.66' elleptical RCP |  |  | 8.81 |  |  |  |  |  | 469.58 | 0.36 |  | 7.01 |  |  |  |  |  |  |  |  |  |  | 4.08' x 2.75' CMA | 8.9 |  |  | 469.96 |  | 0.74 |  | 4.77
 |  |  |  |  |  | reduced structure size 3 |  | 3.50' x 2.25' elleptical RCP |  |  | 6.37 |  |  |  |  |  | 469.75 | 0.53 |  | 8.03 |  |  |  |  |  |  |  |  |  |  | 3.5' x 2.42' CMA | 6.5 |  |  | 470.99 |  | 1.77 |  | 5.56 |  | voilation of AHW and BW
 |  |  |  |  |  | reduced structure size 3 |  | 3' dia cicular conc. Pipe |  |  | 7.06 |  |  |  |  |  | 470.2 | 0.98 |  | 7.54
5 | CN-222800, Seg-11 | 55.99 |  | 0 | 1 |  |  | 9' x 5' PCB | 9 | 5 |  |  |  |  |  |  |  | 0.14 |  | 3.789 |  |  |  |  |  |  |  |  | 5 | CN-222800, Seg-11 | 15' x 4.63' open bottom CMA | 50 |  |  |  |  | 0.14 |  | 3.26
 |  |  |  |  |  | created hy8 file |  | 9' x 5' PCB | 9 | 5 |  |  | 472.03 | 3.142 | 1 |  | 474.83 | -0.34 |  | 3.79 |  | 480.64 | 472.03 | 1 | 1 | 0.6 |  |  |  |  | 15' x 4.63' open bottom CMA | 50 |  |  |  |  | -0.01 |  | 2.68
 |  |  |  |  |  | reduced structure size-1 |  | 6' x 4' PCB | 6 | 4 |  |  |  |  |  |  | 475.47 | 0.3 |  | 5.68 |  |  |  |  |  |  |  |  |  |  | 12' x 5' open bottom CMA | 45 |  |  | 475.4 |  | 0.23 |  | 3.18
 |  |  |  |  |  | reduced structure size 2 |  | 5' x 4' PCB | 5 | 4 |  |  |  |  |  |  | 475.91 | 0.74 |  | 6.82 |  |  |  |  |  |  |  |  |  |  | 10' x 4.42' open bottom CMA | 34 |  |  | 475.88 |  | 0.71 |  | 3.87
 |  |  |  |  |  | reduced structure size 3 |  | 4 ' x 4' PCB |  |  |  |  |  |  |  |  | 476.57 | 1.4 |  | 8.53 |  |  |  |  |  |  |  | voilation of AHW and BW |  |  | 9' x 3.88' open bottom CMA | 26.5 |  |  | 476.75 |  | 1.58 |  | 4.46 |  | voilation of AHW and BW
 |  |  |  |  |  | reduced structure size 4 |  | 5' dia circular conc. Pipe |  |  |  |  |  |  |  |  | 476.78 | 1.61 |  | 8.26 |  |  |  |  |  |  |  | voilation of AHW and BW
 |  |  |  |  |  | reduced structure size 5 |  | 6' dia circular conc. Pipe | 6 | 6 |  |  |  |  |  |  | 476.09 | 0.92 |  | 8.53
6 | [NAME], Seg - 4 |  | 593 cfs | 0 | 1 |  | 0.755 | 18' x 8' CB | 18 | 8 |  |  |  |  |  |  |  | 0.06 |  | 5.564 |  |  |  |  |  |  |  |  | 6 | [NAME], Seg - 4
 |  |  |  |  |  | given HY-8 file |  | 18' x 8' CB | 18 | 8 |  |  | 443.84 | 5.921 | 0.13 |  | 449.45 | -0.31 |  | 5.564 |  | 452 | 443.84 | 1 | 1 | 0.6 |  | voilation of cover requirements
 |  |  |  |  |  | reduced structure size-1 |  | 14' x 8' CB | 14 | 8 |  |  | 443.84 | 5.921 | 1 |  | 449.95 | 0.19 |  | 7.15 |  |  |  |  |  |  |  | voilation of cover requirements
 |  |  |  |  |  | reduced structure size 2 |  | 12' x 6' CB | 12 | 6 |  |  |  |  |  |  | 450.54 | 0.78 |  | 15.67
 |  |  |  |  |  | reduced structure size 3 |  | 11' x 6' CB | 11 | 6 |  |  |  |  |  |  | 451.03 | 1.27 |  |  |  |  |  |  |  |  |  | voilation of AHW and BW
7 | RAMP2-US50, Seg-7 | 35.9 |  | 0 | 1 |  |  | 9' x 4' CB | 9 | 4 |  |  |  |  |  |  |  | 0.11 |  | 6.29 |  |  |  |  |  |  |  |  | 7 | RAMP2-US50, Seg-7 | 12.87' x 8.31' CMA | 85.2 |  |  |  |  | 0.13 |  | 3.16 | revision suggested
 |  |  |  |  |  | given HY-8 file |  | 9' x 4'CB | 9 | 4 |  |  | 479.28 | 1.401 | 0.13 |  | 480.93 | 0.25 |  | 12.55 |  | 493.96 | 479.28 | 1 | 1 | 0.6 |  |  |  |  | 12.87' x 8.31' CMA | 85.2 |  |  |  |  | 0.26 |  | 6.03
 |  |  |  |  |  | reduced structure size - 1 |  | 7' x 4' CB | 7 | 4 |  |  | 480.28 | 1.401 | 1 |  | 482.23 | 0.45 |  | 13.56 |  |  |  |  |  |  |  |  |  |  | 10.22' x 6.76' CMA | 54.51 |  |  | 482.17 |  | 0.49 |  | 6.03
 |  |  |  |  |  | reduced structure size 2 |  | 6' x 4' CB | 6 | 4 |  |  |  |  |  |  | 482.41 | 0.73 |  | 12.74 |  |  |  |  |  |  |  |  |  |  | 8.61' x 5.97' CMA | 40.46 |  |  | 482.53 |  | 0.85 |  | 6.42
 |  |  |  |  |  | reduced structure size 3 |  | 5' x 4' CB | 5 | 4 |  |  |  |  |  |  | 482.69 | 1.01 |  | 13.19 |  |  |  |  |  |  |  | voilation of AHW and BW |  |  | 7.93' x 5.6 ' CMA | 35.39 |  |  | 482.59 |  | 0.91 |  | 6.33
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 6.76' x 4.91' CMA | 26.16 |  |  | 482.7 |  | 1.02 |  | 6.69 |  | voilation of AHW and BW
 | RCP | Reinforced Concrete Pipe
 | CMP | Corrugated Metal Pipe
 | CMA | Corrugated Metal Arch
 | PCB | Precast Concrete Box
Sl. No | Corssing Name | Backwater1 |  | dec. Ar 1 | [NAME] velo inc 1 | Backwater2 | dec. Ar 2 | [NAME] velo inc 2
1 | SR-58W
2 | CN-224400, Seg-11
3 | CN-231200, Seg-11
4 | CN-225300, Seg-11
5 | CN-222800, Seg-11
6 | [NAME], Seg - 4
7 | RAMP2-US50, Seg-7
 | Summary of reduced size structure  shown in color as in the next cell
 |  | Final Backwater | Decrease in culvert area (%) | Increse in outltet velocity %
 | Average
 | Minimum
 | Maximum
 | Standard Deviation
 | Sample Size
Sl. No | Corssing Name | minimum structure Size for 0.14' back water | mimimum strructure size for 1.0' back water | average saving in the bid price per unit length (feet) of structure from data | % saving from data | % saving from model
1 | SR-58W | 7' X 3' CB | 4' X 3' CB | 80 | 0.18 | 0.12
2 | CN-224400, Seg-11
5 | CN-222800, Seg-11 | 9' X 5' CB | 5' X 4' CB | 392 | 0.58 | 0.31
6 | [NAME], Seg - 4 | 18' X 8' CB | 12' X 6' CB | 682 | 0.44 | 0.65
7 | RAMP2-US50, Seg-7 | 9' x 4' CB | 6' X 4' CB | 181 | 0.31 | 0.16