Laserfiche WebLink
BACKWATR-CD.XLS <br /> I BACKWATER CALCULATION SHEET <br /> PROJ: JAMES MONROE ELEMENTARY Calculated by: M.A.D. <br /> I WO: 26-09-040 Checked by:ARM <br /> DATE:3/19f2010 Date Checked:3/25/10 <br /> . FILE:Q109t040James Monroe Ele n Modernization\Drainage\[StonnTcch Cumulative Storages Spreadsheet.xls]Cumulative Volumes Imperial <br /> (1) (2) (3) (4) (5) (6) (7) (8) (9) (10) (11) (12) (13) (14) (15) (16) (17) (18) (19) (20) <br /> Pipe Barrel Barrel Barrel Friction Entrance Entrance Exit Outlet Inlet Approach Bend Junction HW <br /> I <br /> Pipe Segment Q Length Diameter "n" Outlet Elev Inlet Elev Area Velocity Vel Head TW Elev Loss HGL Elev head loss head loss contr.Elev contr. Elev vel.head head loss head loss elev. <br /> CB to CB (cfs) (ft} (ink Value (ft) (ft) (sqft) {fps) (ft) (ft) (ft) (ft) (ft) (ft) (ft) (ft) (ft) (ft) (ft) (ft) <br /> CB 5 CB 6 13.47 19 24 0.012 443.35 443.45 3.142 4.288 0.285 447.270 0.057 447.327 0.057 0.285 447.670 0.235 0.000 0.000 447.435 <br /> ICB6 CB 8 -__12.22 90 24 0.012 443.45 443.75 3.142 3.890 0.235 447.435 0.222 447.657 0.047 0.235 447.939 0.403 0.000 0.000 447.536 <br /> CB 8 CB 11 9 43 18 0.012 444.25 444.75 1.767 5.093 0.403 447.536 0.267 447.802 0.081 0.403 448.286 0.388 0.000 0.000 447.898 <br /> CB 11 CB 13 8.83 79 IS 0.012 444.75 445.1 1.767 4.997 0.388 447.898 0.472 448.370 0.078 0.388 448.835 0.226 0.000 0.000 448.609 <br /> CB 13 CB 14 6.74 148 18 0.012 445.1 446.2 1.767 3.814 0.226 448.609 0.515 449.124 0.045 0.226 449.395 0.127 0.000 0.000 449.267 <br /> CB 14 CB 16 5_06 130 _ 18 0.012 446.2 446.6 1.767 2.863 0.127 449.267 0.255 449.522 0.025 -0.127 449.675 0.109 0.000 0.000 449.566 <br /> ... <br /> CB 16 CB 17 4.69 76 18 0.012 446.6 447.7 1.767 2.654 0.109 449.566 0.128 449.694 O.Q22 0.1 Q9 449.825 0.082 0.000 0.000 449.743 <br /> CB 17 CB 18 4.06 76 18 0.012 446.2 446.8 1.767 2.297 0.082 449.743 0.096 449.839 0.016 0.082 449.937 0.106 0.000 0.000 449.831 <br /> CB 18 CB 19 2.05 74 12 0.012 445.8 446.25 0.785 2.610 0.106 449.831 0.207 450.038 0.021 0.106 450.165 - -- 0.103 0.000 0.000 450.062 <br /> ICB 19 CB 20 2.02 143 12 0.012 445.25 446 0.785 2.572 0.103 450.062 0.388 450.450 0.021 0.103 450.573 0.000 0.000 0.000 450.573 <br /> CB 18 . ' CB 21 1.9 53 12 0.012 447.3 447.9 0.785 2.419 0.091 450.062 0.127 450.190 0.018 0.091 450.299 0.079 0.000_ 0.000 450.220 <br /> CB 21 _ CB 22 1.77 71 12 0.012 447.9 448.4 0.785 2.254 _ 0.079 450.220 0.148 450.368 0.016 0.079 450.462 0.014 0.000 0.000 450.448 <br /> I CB-2-2- CB 23 0.74 91 12 0.012 448.4 449.5 0.785 0.942 0.014 450.448 0.033 450.482 0.003 0.014 450.498 0.002 0.000 0.000 450.496 <br /> CB 23 CB 24 0.27 91 12 0.012 449.5 450_3 0.785 0.344 0.002 450.496 0.004 450.501 0.000 0.002 450.503 0.000 0.000 0.000 450.503 <br /> • <br /> I CB 13- CB 27 1.8 <br /> 6 126 12 0.012 447 448.3 0.785 _ 2.368 0.087 449.267 0.290 449.557 0.017 0.087 449.662 0.067 0.000 0.000 449.595 <br /> CB 27 CB 28 1,63 69 12 0.012 448.3 448.8 0.785 2.075 0.067 449.595 0.122 449.717 0.013 0.067 449.797 0.037 - 0.000 0.000 449.759 <br /> CB 28 CB 29 1.22 98 12 0.012 448.8 449.5 0.785 1.553 0.037 449.759 0.097 449.856 0.007 0.037 449.901 _ _ 0.001 _ 0.000 0.000 449.900 <br /> CB 29 CB 30 0.23 59 12 0.012 449.5 450.5 0.785 0.293 0.001 449.90.0 0.002 449.902 -0.000- 0.001 449.904 0.001 0.000 0.000 449.903 <br /> ICB 30 "-CB 31 0.21 37 12 0.012 450.5 458.2 0.785 0.267 0.001 449.903 0.001 449.904 0.000 0.001 449.905 0.000 0.000 0.000 449.905 <br /> • <br /> I SEE PAGE 4.3.4-21 OF THE KING COUNTY SURFACE WATER DESIGN MANUAL <br /> FOR THE CORRESPONDING EQUATIONS AND A DETAILED EXPLAINAT1ON <br /> ON HOW TO USE THIS SPREADSHEET. <br /> I <br /> BASED ON 100-YR STORM EVENT <br /> I <br /> • <br /> I . <br /> • <br /> Page 1 <br /> I`: <br /> I <br />