Compute and plot problems about water resources in Excel file

HW13 Problem #1 -- Solution

Δt for Lagging Procedure (hours) = 2.00 Base Flow for Simulated Flood, QB (cfs) = 1,500

Effective Rainfall Increments: R1 (inches) = 0.60 R2 (inches) = 0.60

Simulated Flood Components Elapsed 24-Hour Unit ERH Increment R1 ERH Increment R2 Base Total Flood

Time Hydrograph, QUHi Hydrograph, Qi Hydrograph, Qi Flow, QB Flow, QTi (hr) (cfs/in) (cfs) (cfs) (cfs) (cfs) 0.00 0 0 1,500 1,500 2.00 43 26 1,500 1,526 4.00 86 51 1,500 1,551 6.00 128 77 1,500 1,577 8.00 171 103 1,500 1,603

10.00 214 128 1,500 1,628 12.00 257 154 1,500 1,654 14.00 385 231 1,500 1,731 16.00 513 308 1,500 1,808 18.00 642 385 1,500 1,885 20.00 1,027 616 1,500 2,116 22.00 1,412 847 1,500 2,347 24.00 1,797 1,078 0 1,500 2,578 26.00 2,781 1,669 26 1,500 3,195 28.00 3,766 2,259 51 1,500 3,811 30.00 4,750 2,850 77 1,500 4,427 32.00 6,547 3,928 103 1,500 5,531 34 00 8 344 5 007 128 1 500 6 63534.00 8,344 5,007 128 1,500 6,635 36.00 11,168 6,701 154 1,500 8,355 38.00 15,020 9,012 231 1,500 10,743 40.00 14,955 8,973 308 1,500 10,781 42.00 14,891 8,935 385 1,500 10,820 44.00 14,806 8,883 616 1,500 11,000 46.00 14,720 8,832 847 1,500 11,179 48.00 14,634 8,781 1,078 1,500 11,359 50.00 13,736 8,242 1,669 1,500 11,410 52.00 12,837 7,702 2,259 1,500 11,462 54.00 11,939 7,163 2,850 1,500 11,513 56.00 11,425 6,855 3,928 1,500 12,283 58.00 10,912 6,547 5,007 1,500 13,054 60.00 10,398 6,239 6,701 1,500 14,440 62.00 10,141 6,085 9,012 1,500 16,597 Peak Flow 64.00 9,885 5,931 8,973 1,500 16,404 66.00 9,628 5,777 8,935 1,500 16,212 68.00 9,286 5,571 8,883 1,500 15,955 70.00 8,943 5,366 8,832 1,500 15,698 72.00 8,601 5,161 8,781 1,500 15,441 74.00 8,344 5,007 8,242 1,500 14,748 76.00 8,087 4,852 7,702 1,500 14,055 78.00 7,831 4,698 7,163 1,500 13,362 80.00 7,574 4,544 6,855 1,500 12,900 82.00 7,317 4,390 6,547 1,500 12,437

1 of 8

Simulated Flood Components Elapsed 24-Hour Unit ERH Increment R1 ERH Increment R2 Base Total Flood

Time Hydrograph, QUHi Hydrograph, Qi Hydrograph, Qi Flow, QB Flow, QTi (hr) (cfs/in) (cfs) (cfs) (cfs) (cfs)

84.00 7,061 4,236 6,239 1,500 11,975 86.00 6,782 4,069 6,085 1,500 11,654 88.00 6,504 3,903 5,931 1,500 11,333 90.00 6,226 3,736 5,777 1,500 11,012 92.00 5,948 3,569 5,571 1,500 10,640 94.00 5,670 3,402 5,366 1,500 10,268 96.00 5,392 3,235 5,161 1,500 9,896 98.00 5,092 3,055 5,007 1,500 9,562 100.00 4,793 2,876 4,852 1,500 9,228 102.00 4,493 2,696 4,698 1,500 8,894 104.00 4,194 2,516 4,544 1,500 8,561 106.00 3,894 2,336 4,390 1,500 8,227 108.00 3,594 2,157 4,236 1,500 7,893 110.00 3,509 2,105 4,069 1,500 7,675 112.00 3,423 2,054 3,903 1,500 7,456 114.00 3,338 2,003 3,736 1,500 7,238 116.00 3,252 1,951 3,569 1,500 7,020 118.00 3,167 1,900 3,402 1,500 6,802 120.00 3,081 1,849 3,235 1,500 6,584 122.00 2,974 1,784 3,055 1,500 6,340 124.00 2,867 1,720 2,876 1,500 6,096 126.00 2,760 1,656 2,696 1,500 5,852 128.00 2,653 1,592 2,516 1,500 5,608 130.00 2,546 1,528 2,336 1,500 5,364 132.00 2,439 1,463 2,157 1,500 5,120 134.00 2,332 1,399 2,105 1,500 5,005 136.00 2,225 1,335 2,054 1,500 4,889 138.00 2,118 1,271 2,003 1,500 4,774 140.00 2,011 1,207 1,951 1,500 4,658 142.00 1,904 1,143 1,900 1,500 4,542 144.00 1,797 1,078 1,849 1,500 4,427 146.00 1,733 1,040 1,784 1,500 4,324 148.00 1,669 1,001 1,720 1,500 4,222 150.00 1,605 963 1,656 1,500 4,119 152.00 1,540 924 1,592 1,500 4,016 154.00 1,476 886 1,528 1,500 3,913 156.00 1,412 847 1,463 1,500 3,811 158.00 1,369 822 1,399 1,500 3,721 160.00 1,327 796 1,335 1,500 3,631 162.00 1,284 770 1,271 1,500 3,541 164.00 1,241 745 1,207 1,500 3,451 166.00 1,198 719 1,143 1,500 3,361 168.00 1,155 693 1,078 1,500 3,272 170.00 1,113 668 1,040 1,500 3,207 172.00 1,070 642 1,001 1,500 3,143 174.00 1,027 616 963 1,500 3,079 176.00 984 591 924 1,500 3,015 178.00 941 565 886 1,500 2,951 180.00 899 539 847 1,500 2,886 182.00 834 501 822 1,500 2,822 184.00 770 462 796 1,500 2,758 186.00 706 424 770 1,500 2,694 188.00 642 385 745 1,500 2,630 190.00 578 347 719 1,500 2,565

2 of 8

Simulated Flood Components Elapsed 24-Hour Unit ERH Increment R1 ERH Increment R2 Base Total Flood

Time Hydrograph, QUHi Hydrograph, Qi Hydrograph, Qi Flow, QB Flow, QTi (hr) (cfs/in) (cfs) (cfs) (cfs) (cfs)

192.00 513 308 693 1,500 2,501 194.00 503 302 668 1,500 2,469 196.00 492 295 642 1,500 2,437 198.00 481 289 616 1,500 2,405 200.00 471 282 591 1,500 2,373 202.00 460 276 565 1,500 2,341 204.00 449 270 539 1,500 2,309 206.00 439 263 501 1,500 2,264 208.00 428 257 462 1,500 2,219 210.00 417 250 424 1,500 2,174 212.00 407 244 385 1,500 2,129 214.00 396 237 347 1,500 2,084 216.00 385 231 308 1,500 2,039 218.00 364 218 302 1,500 2,020 220.00 342 205 295 1,500 2,001 222.00 321 193 289 1,500 1,981 224.00 300 180 282 1,500 1,962 226.00 278 167 276 1,500 1,943 228.00 257 154 270 1,500 1,924 230.00 235 141 263 1,500 1,904 232.00 214 128 257 1,500 1,885 234.00 193 116 250 1,500 1,866 236.00 171 103 244 1,500 1,847 238.00 150 90 237 1,500 1,827 240.00 128 77 231 1,500 1,808 242.00 107 64 218 1,500 1,782 244.00 86 51 205 1,500 1,757 246.00 64 39 193 1,500 1,731 248.00 43 26 180 1,500 1,705 250.00 21 13 167 1,500 1,680 252.00 0 0 154 1,500 1,654 254.00 141 1,500 1,641 256.00 128 1,500 1,628 258.00 116 1,500 1,616 260.00 103 1,500 1,603 262.00 90 1,500 1,590 264.00 77 1,500 1,577 266.00 64 1,500 1,564 268.00 51 1,500 1,551 270.00 39 1,500 1,539 272.00 26 1,500 1,526 274.00 13 1,500 1,513 276.00 0 1,500 1,500

Peak Discharge (cfs) = 16,597

3 of 8

8,000

10,000

12,000

14,000

16,000

18,000

D is

ch ar

ge , Q

(c fs

)

Simulated Flood Hydrograph

ERH Increment R1 Hydrograph, Qi

ERH Increment R2 Hydrograph, Qi Base Flow, QB

Total Flood Flow, QTi

0

2,000

4,000

6,000

0 50 100 150 200 250 300 Time (hr)

HW 13 Problem #2 -- Solution

Δt for Lagging Procedure (hours) = 2.00 Base Flow for Simulated Flood, QB (cfs) = 1,200

Effective Rainfall Increments: R1 (inches) = 0.40 R2 (inches) = 0.70 R3 (inches) = 0.20 R4 (inches) = 1.80

Simulated Flood Components Elapsed 24-Hour Unit ERH Increment R1 ERH Increment R2 ERH Increment R3 ERH Increment R4 Base Total Flood

Time Hydrograph, QUHi Hydrograph, Qi Hydrograph, Qi Hydrograph, Qi Hydrograph, Qi Flow, QB Flow, QTi (hr) (cfs/in) (cfs) (cfs) (cfs) (cfs) (cfs) (cfs) 0.00 0 0 1,200 1,200 2.00 43 17 1,200 1,217 4.00 86 34 1,200 1,234 6.00 128 51 1,200 1,251 8.00 171 68 1,200 1,268

10.00 214 86 1,200 1,286 12.00 257 103 1,200 1,303 14.00 385 154 1,200 1,354 16.00 513 205 1,200 1,405 18.00 642 257 1,200 1,457 20.00 1,027 411 1,200 1,611 22.00 1,412 565 1,200 1,765 24.00 1,797 719 0 1,200 1,919 26.00 2,781 1,113 30 1,200 2,343 28.00 3,766 1,506 60 1,200 2,766 30.00 4,750 1,900 90 1,200 3,190 32.00 6,547 2,619 120 1,200 3,939 34.00 8,344 3,338 150 1,200 4,687 36.00 11,168 4,467 180 1,200 5,847 38.00 15,020 6,008 270 1,200 7,477 40.00 14,955 5,982 359 1,200 7,542 42.00 14,891 5,956 449 1,200 7,606 44.00 14,806 5,922 719 1,200 7,841 46.00 14,720 5,888 988 1,200 8,077 48.00 14,634 5,854 1,258 0 1,200 8,312 50.00 13,736 5,494 1,947 9 1,200 8,650 52.00 12,837 5,135 2,636 17 1,200 8,988 54.00 11,939 4,775 3,325 26 1,200 9,326 56.00 11,425 4,570 4,583 34 1,200 10,387 58.00 10,912 4,365 5,841 43 1,200 11,448 60.00 10,398 4,159 7,818 51 1,200 13,229 62.00 10,141 4,057 10,514 77 1,200 15,847 64.00 9,885 3,954 10,469 103 1,200 15,725 66.00 9,628 3,851 10,424 128 1,200 15,603 68.00 9,286 3,714 10,364 205 1,200 15,484 70.00 8,943 3,577 10,304 282 1,200 15,364 72.00 8,601 3,440 10,244 359 0 1,200 15,244 74.00 8,344 3,338 9,615 556 77 1,200 14,786 76.00 8,087 3,235 8,986 753 154 1,200 14,328 78.00 7,831 3,132 8,357 950 231 1,200 13,870 80.00 7,574 3,030 7,998 1,309 308 1,200 13,845 82.00 7,317 2,927 7,638 1,669 385 1,200 13,819 84.00 7,061 2,824 7,279 2,234 462 1,200 13,999 86.00 6,782 2,713 7,099 3,004 693 1,200 14,709 88.00 6,504 2,602 6,919 2,991 924 1,200 14,636 90.00 6,226 2,490 6,740 2,978 1,155 1,200 14,564 92.00 5,948 2,379 6,500 2,961 1,849 1,200 14,889 94.00 5,670 2,268 6,260 2,944 2,542 1,200 15,214 96.00 5,392 2,157 6,021 2,927 3,235 1,200 15,539 98.00 5,092 2,037 5,841 2,747 5,007 1,200 16,832 100.00 4,793 1,917 5,661 2,567 6,778 1,200 18,124 102.00 4,493 1,797 5,482 2,388 8,550 1,200 19,416 104.00 4,194 1,677 5,302 2,285 11,785 1,200 22,249 106.00 3,894 1,558 5,122 2,182 15,020 1,200 25,082 108.00 3,594 1,438 4,942 2,080 20,103 1,200 29,763 110.00 3,509 1,404 4,748 2,028 27,035 1,200 36,415 Peak Flow 112.00 3,423 1,369 4,553 1,977 26,920 1,200 36,019 114.00 3,338 1,335 4,358 1,926 26,804 1,200 35,623 116.00 3,252 1,301 4,164 1,857 26,650 1,200 35,172 118.00 3,167 1,267 3,969 1,789 26,496 1,200 34,720 120.00 3,081 1,232 3,774 1,720 26,342 1,200 34,269

5 of 8

Simulated Flood Components Elapsed 24-Hour Unit ERH Increment R1 ERH Increment R2 ERH Increment R3 ERH Increment R4 Base Total Flood

Time Hydrograph, QUHi Hydrograph, Qi Hydrograph, Qi Hydrograph, Qi Hydrograph, Qi Flow, QB Flow, QTi (hr) (cfs/in) (cfs) (cfs) (cfs) (cfs) (cfs) (cfs)

122.00 2,974 1,190 3,564 1,669 24,725 1,200 32,348 124.00 2,867 1,147 3,355 1,617 23,107 1,200 30,426 126.00 2,760 1,104 3,145 1,566 21,490 1,200 28,505 128.00 2,653 1,061 2,935 1,515 20,565 1,200 27,277 130.00 2,546 1,018 2,726 1,463 19,641 1,200 26,049 132.00 2,439 976 2,516 1,412 18,717 1,200 24,821 134.00 2,332 933 2,456 1,356 18,255 1,200 24,200 136.00 2,225 890 2,396 1,301 17,792 1,200 23,580 138.00 2,118 847 2,336 1,245 17,330 1,200 22,959 140.00 2,011 804 2,276 1,190 16,714 1,200 22,185 142.00 1,904 762 2,217 1,134 16,098 1,200 21,410 144.00 1,797 719 2,157 1,078 15,482 1,200 20,636 146.00 1,733 693 2,082 1,018 15,020 1,200 20,013 148.00 1,669 668 2,007 959 14,557 1,200 19,390 150.00 1,605 642 1,932 899 14,095 1,200 18,768 152.00 1,540 616 1,857 839 13,633 1,200 18,145 154.00 1,476 591 1,782 779 13,171 1,200 17,523 156.00 1,412 565 1,707 719 12,709 1,200 16,900 158.00 1,369 548 1,632 702 12,208 1,200 16,290 160.00 1,327 531 1,558 685 11,708 1,200 15,680 162.00 1,284 513 1,483 668 11,207 1,200 15,071 164.00 1,241 496 1,408 650 10,706 1,200 14,461 166.00 1,198 479 1,333 633 10,206 1,200 13,851 168.00 1,155 462 1,258 616 9,705 1,200 13,241 170.00 1,113 445 1,213 595 9,166 1,200 12,619 172.00 1,070 428 1,168 573 8,627 1,200 11,996 174.00 1,027 411 1,123 552 8,087 1,200 11,374 176.00 984 394 1,078 531 7,548 1,200 10,751 178.00 941 377 1,033 509 7,009 1,200 10,128 180.00 899 359 988 488 6,470 1,200 9,506 182.00 834 334 959 466 6,316 1,200 9,275 184.00 770 308 929 445 6,162 1,200 9,044 186.00 706 282 899 424 6,008 1,200 8,813 188.00 642 257 869 402 5,854 1,200 8,581 190.00 578 231 839 381 5,700 1,200 8,350 192.00 513 205 809 359 5,546 1,200 8,119 194.00 503 201 779 347 5,353 1,200 7,880 196.00 492 197 749 334 5,161 1,200 7,640 198.00 481 193 719 321 4,968 1,200 7,400 200.00 471 188 689 308 4,775 1,200 7,161 202.00 460 184 659 295 4,583 1,200 6,921 204 00 449 180 629 282 4 390 1 200 6 682204.00 449 180 629 282 4,390 1,200 6,682 206.00 439 175 584 274 4,198 1,200 6,431 208.00 428 171 539 265 4,005 1,200 6,181 210.00 417 167 494 257 3,813 1,200 5,931 212.00 407 163 449 248 3,620 1,200 5,680 214.00 396 158 404 240 3,428 1,200 5,430 216.00 385 154 359 231 3,235 1,200 5,180 218.00 364 145 352 223 3,119 1,200 5,039 220.00 342 137 344 214 3,004 1,200 4,899 222.00 321 128 337 205 2,888 1,200 4,759 224.00 300 120 329 197 2,773 1,200 4,619 226.00 278 111 322 188 2,657 1,200 4,479 228.00 257 103 315 180 2,542 1,200 4,339 230.00 235 94 307 167 2,465 1,200 4,233 232.00 214 86 300 154 2,388 1,200 4,127 234.00 193 77 292 141 2,311 1,200 4,021 236.00 171 68 285 128 2,234 1,200 3,915 238.00 150 60 277 116 2,157 1,200 3,809 240.00 128 51 270 103 2,080 1,200 3,703 242.00 107 43 255 101 2,003 1,200 3,601 244.00 86 34 240 98 1,926 1,200 3,498 246.00 64 26 225 96 1,849 1,200 3,395 248.00 43 17 210 94 1,772 1,200 3,292 250.00 21 9 195 92 1,695 1,200 3,190 252.00 0 0 180 90 1,617 1,200 3,087 254.00 165 88 1,502 1,200 2,954 256.00 150 86 1,386 1,200 2,822 258.00 135 83 1,271 1,200 2,689 260.00 120 81 1,155 1,200 2,556 262.00 105 79 1,040 1,200 2,424 264.00 90 77 924 1,200 2,291 266.00 75 73 905 1,200 2,253 268.00 60 68 886 1,200 2,214 270.00 45 64 867 1,200 2,176

6 of 8

Simulated Flood Components Elapsed 24-Hour Unit ERH Increment R1 ERH Increment R2 ERH Increment R3 ERH Increment R4 Base Total Flood

Time Hydrograph, QUHi Hydrograph, Qi Hydrograph, Qi Hydrograph, Qi Hydrograph, Qi Flow, QB Flow, QTi (hr) (cfs/in) (cfs) (cfs) (cfs) (cfs) (cfs) (cfs)

272.00 30 60 847 1,200 2,137 274.00 15 56 828 1,200 2,099 276.00 0 51 809 1,200 2,060 278.00 47 789 1,200 2,037 280.00 43 770 1,200 2,013 282.00 39 751 1,200 1,989 284.00 34 732 1,200 1,966 286.00 30 712 1,200 1,942 288.00 26 693 1,200 1,919 290.00 21 655 1,200 1,876 292.00 17 616 1,200 1,833 294.00 13 578 1,200 1,791 296.00 9 539 1,200 1,748 298.00 4 501 1,200 1,705 300.00 0 462 1,200 1,662 302.00 424 1,200 1,624 304.00 385 1,200 1,585 306.00 347 1,200 1,547 308.00 308 1,200 1,508 310.00 270 1,200 1,470 312.00 231 1,200 1,431 314.00 193 1,200 1,393 316.00 154 1,200 1,354 318.00 116 1,200 1,316 320.00 77 1,200 1,277 322.00 39 1,200 1,239 324.00 0 1,200 1,200

Peak Discharge (cfs) = 36,415

7 of 8

15,000

20,000

25,000

30,000

35,000

40,000

sc ha

rg e,

Q (c

fs )

Simulated Flood Hydrograph

ERH Increment R1 Hydrograph, Qi

ERH Increment R2 Hydrograph, Qi

ERH Increment R3 Hydrograph, Qi

ERH Increment R4 Hydrograph, Qi

Base Flow, QB

Total Flood Flow, QTi

0

5,000

10,000

0 50 100 150 200 250 300 350

D is

Time (hr)