Compute and plot problems about water resources in Excel file

ruowan

hw12.pdf

Home >Computer Science homework help >Compute and plot problems about water resources in Excel file

Page 1 of 6

Homework No. 12 -- Solution

1. Watershed Information

Watershed Drainage Area, Ad (mi 2 ) = 1,406

2. Observed Flood Hydrograph, Base Flow Separation, Direct Runoff Hydrograph Derivation, Unit Hydrograph Derivation, and Numerical Integration

Incremental Incremental Direct Runoff

Flood Direct Runoff Direct Runoff 24-Hour Unit Unit Hydrograph and Unit

Elapsed Time, ti Time Increment, Dti Hydrograph, Qi Hydrograph, QRi 1

Volume, DVRi 2

Hydrograph, QUHi 3

Volume, DVUHi 4

Hydrograph

Date and Time (hours) (hours) (cfs) (cfs) (ft 3 ) (cfs/in) (ft

3 /in) Index, i

7/10/1986 0:00 0 2 1,400 0 120,000 0 154,047 1

7/10/1986 2:00 2 2 1,433 33 360,000 43 462,142 2

7/10/1986 4:00 4 2 1,467 67 600,000 86 770,237 3

7/10/1986 6:00 6 2 1,500 100 840,000 128 1,078,331 4

7/10/1986 8:00 8 2 1,533 133 1,080,000 171 1,386,426 5

7/10/1986 10:00 10 2 1,567 167 1,320,000 214 1,694,520 6

7/10/1986 12:00 12 2 1,600 200 1,800,000 257 2,310,710 7

7/10/1986 14:00 14 2 1,700 300 2,520,000 385 3,234,994 8

7/10/1986 16:00 16 2 1,800 400 3,240,000 513 4,159,277 9

7/10/1986 18:00 18 2 1,900 500 4,680,000 642 6,007,845 10

7/10/1986 20:00 20 2 2,200 800 6,840,000 1,027 8,780,697 11

7/10/1986 22:00 22 2 2,500 1,100 9,000,000 1,412 11,553,548 12

7/11/1986 0:00 24 2 2,800 1,400 12,840,000 1,797 16,483,062 13

7/11/1986 2:00 26 2 3,567 2,167 18,360,000 2,781 23,569,239 14

7/11/1986 4:00 28 2 4,333 2,933 23,880,000 3,766 30,655,415 15

7/11/1986 6:00 30 2 5,100 3,700 31,680,000 4,750 40,668,490 16

7/11/1986 8:00 32 2 6,500 5,100 41,760,000 6,547 53,608,465 17

7/11/1986 10:00 34 2 7,900 6,500 54,720,000 8,344 70,245,574 18

7/11/1986 12:00 36 2 10,100 8,700 73,440,000 11,168 94,276,955 19

7/11/1986 14:00 38 2 13,100 11,700 84,060,000 15,020 107,910,142 20

7/11/1986 16:00 40 2 13,050 11,650 83,700,000 14,955 107,448,000 21

7/11/1986 18:00 42 2 13,000 11,600 83,280,000 14,891 106,908,834 22

7/11/1986 20:00 44 2 12,933 11,533 82,800,000 14,806 106,292,645 23

7/11/1986 22:00 46 2 12,867 11,467 82,320,000 14,720 105,676,456 24

7/12/1986 0:00 48 2 12,800 11,400 79,560,000 14,634 102,133,368 25

7/12/1986 2:00 50 2 12,100 10,700 74,520,000 13,736 95,663,381 26

7/12/1986 4:00 52 2 11,400 10,000 69,480,000 12,837 89,193,394 27

7/12/1986 6:00 54 2 10,700 9,300 65,520,000 11,939 84,109,832 28

7/12/1986 8:00 56 2 10,300 8,900 62,640,000 11,425 80,412,697 29

7/12/1986 10:00 58 2 9,900 8,500 59,760,000 10,912 76,715,561 30

7/12/1986 12:00 60 2 9,500 8,100 57,600,000 10,398 73,942,710 31

7/12/1986 14:00 62 2 9,300 7,900 56,160,000 10,141 72,094,142 32

7/12/1986 16:00 64 2 9,100 7,700 54,720,000 9,885 70,245,574 33

7/12/1986 18:00 66 2 8,900 7,500 53,040,000 9,628 68,088,912 34

7/12/1986 20:00 68 2 8,633 7,233 51,120,000 9,286 65,624,155 35

7/12/1986 22:00 70 2 8,367 6,967 49,200,000 8,943 63,159,398 36

7/13/1986 0:00 72 2 8,100 6,700 47,520,000 8,601 61,002,735 37

7/13/1986 2:00 74 2 7,900 6,500 46,080,000 8,344 59,154,168 38

Page 2 of 6

7/13/1986 4:00 76 2 7,700 6,300 44,640,000 8,087 57,305,600 39

7/13/1986 6:00 78 2 7,500 6,100 43,200,000 7,831 55,457,032 40

7/13/1986 8:00 80 2 7,300 5,900 41,760,000 7,574 53,608,465 41

7/13/1986 10:00 82 2 7,100 5,700 40,320,000 7,317 51,759,897 42

7/13/1986 12:00 84 2 6,900 5,500 38,820,000 7,061 49,834,305 43

7/13/1986 14:00 86 2 6,683 5,283 37,260,000 6,782 47,831,690 44

7/13/1986 16:00 88 2 6,467 5,067 35,700,000 6,504 45,829,075 45

7/13/1986 18:00 90 2 6,250 4,850 34,140,000 6,226 43,826,460 46

7/13/1986 20:00 92 2 6,033 4,633 32,580,000 5,948 41,823,845 47

7/13/1986 22:00 94 2 5,817 4,417 31,020,000 5,670 39,821,230 48

7/14/1986 0:00 96 2 5,600 4,200 29,400,000 5,392 37,741,591 49

7/14/1986 2:00 98 2 5,367 3,967 27,720,000 5,092 35,584,929 50

7/14/1986 4:00 100 2 5,133 3,733 26,040,000 4,793 33,428,267 51

7/14/1986 6:00 102 2 4,900 3,500 24,360,000 4,493 31,271,604 52

7/14/1986 8:00 104 2 4,667 3,267 22,680,000 4,194 29,114,942 53

7/14/1986 10:00 106 2 4,433 3,033 21,000,000 3,894 26,958,280 54

7/14/1986 12:00 108 2 4,200 2,800 19,920,000 3,594 25,571,854 55

7/14/1986 14:00 110 2 4,133 2,733 19,440,000 3,509 24,955,665 56

7/14/1986 16:00 112 2 4,067 2,667 18,960,000 3,423 24,339,475 57

7/14/1986 18:00 114 2 4,000 2,600 18,480,000 3,338 23,723,286 58

7/14/1986 20:00 116 2 3,933 2,533 18,000,000 3,252 23,107,097 59

7/14/1986 22:00 118 2 3,867 2,467 17,520,000 3,167 22,490,908 60

7/15/1986 0:00 120 2 3,800 2,400 16,980,000 3,081 21,797,695 61

7/15/1986 2:00 122 2 3,717 2,317 16,380,000 2,974 21,027,458 62

7/15/1986 4:00 124 2 3,633 2,233 15,780,000 2,867 20,257,222 63

7/15/1986 6:00 126 2 3,550 2,150 15,180,000 2,760 19,486,985 64

7/15/1986 8:00 128 2 3,467 2,067 14,580,000 2,653 18,716,748 65

7/15/1986 10:00 130 2 3,383 1,983 13,980,000 2,546 17,946,512 66

7/15/1986 12:00 132 2 3,300 1,900 13,380,000 2,439 17,176,275 67

7/15/1986 14:00 134 2 3,217 1,817 12,780,000 2,332 16,406,039 68

7/15/1986 16:00 136 2 3,133 1,733 12,180,000 2,225 15,635,802 69

7/15/1986 18:00 138 2 3,050 1,650 11,580,000 2,118 14,865,566 70

7/15/1986 20:00 140 2 2,967 1,567 10,980,000 2,011 14,095,329 71

7/15/1986 22:00 142 2 2,883 1,483 10,380,000 1,904 13,325,092 72

7/16/1986 0:00 144 2 2,800 1,400 9,900,000 1,797 12,708,903 73

7/16/1986 2:00 146 2 2,750 1,350 9,540,000 1,733 12,246,761 74

7/16/1986 4:00 148 2 2,700 1,300 9,180,000 1,669 11,784,619 75

7/16/1986 6:00 150 2 2,650 1,250 8,820,000 1,605 11,322,477 76

7/16/1986 8:00 152 2 2,600 1,200 8,460,000 1,540 10,860,335 77

7/16/1986 10:00 154 2 2,550 1,150 8,100,000 1,476 10,398,194 78

7/16/1986 12:00 156 2 2,500 1,100 7,800,000 1,412 10,013,075 79

7/16/1986 14:00 158 2 2,467 1,067 7,560,000 1,369 9,704,981 80

7/16/1986 16:00 160 2 2,433 1,033 7,320,000 1,327 9,396,886 81

7/16/1986 18:00 162 2 2,400 1,000 7,080,000 1,284 9,088,791 82

7/16/1986 20:00 164 2 2,367 967 6,840,000 1,241 8,780,697 83

7/16/1986 22:00 166 2 2,333 933 6,600,000 1,198 8,472,602 84

7/17/1986 0:00 168 2 2,300 900 6,360,000 1,155 8,164,508 85

7/17/1986 2:00 170 2 2,267 867 6,120,000 1,113 7,856,413 86

7/17/1986 4:00 172 2 2,233 833 5,880,000 1,070 7,548,318 87

7/17/1986 6:00 174 2 2,200 800 5,640,000 1,027 7,240,224 88

Page 3 of 6

7/17/1986 8:00 176 2 2,167 767 5,400,000 984 6,932,129 89

7/17/1986 10:00 178 2 2,133 733 5,160,000 941 6,624,034 90

7/17/1986 12:00 180 2 2,100 700 4,860,000 899 6,238,916 91

7/17/1986 14:00 182 2 2,050 650 4,500,000 834 5,776,774 92

7/17/1986 16:00 184 2 2,000 600 4,140,000 770 5,314,632 93

7/17/1986 18:00 186 2 1,950 550 3,780,000 706 4,852,490 94

7/17/1986 20:00 188 2 1,900 500 3,420,000 642 4,390,348 95

7/17/1986 22:00 190 2 1,850 450 3,060,000 578 3,928,206 96

7/18/1986 0:00 192 2 1,800 400 2,850,000 513 3,658,624 97

7/18/1986 2:00 194 2 1,792 392 2,790,000 503 3,581,600 98

7/18/1986 4:00 196 2 1,783 383 2,730,000 492 3,504,576 99

7/18/1986 6:00 198 2 1,775 375 2,670,000 481 3,427,553 100

7/18/1986 8:00 200 2 1,767 367 2,610,000 471 3,350,529 101

7/18/1986 10:00 202 2 1,758 358 2,550,000 460 3,273,505 102

7/18/1986 12:00 204 2 1,750 350 2,490,000 449 3,196,482 103

7/18/1986 14:00 206 2 1,742 342 2,430,000 439 3,119,458 104

7/18/1986 16:00 208 2 1,733 333 2,370,000 428 3,042,434 105

7/18/1986 18:00 210 2 1,725 325 2,310,000 417 2,965,411 106

7/18/1986 20:00 212 2 1,717 317 2,250,000 407 2,888,387 107

7/18/1986 22:00 214 2 1,708 308 2,190,000 396 2,811,363 108

7/19/1986 0:00 216 2 1,700 300 2,100,000 385 2,695,828 109

7/19/1986 2:00 218 2 1,683 283 1,980,000 364 2,541,781 110

7/19/1986 4:00 220 2 1,667 267 1,860,000 342 2,387,733 111

7/19/1986 6:00 222 2 1,650 250 1,740,000 321 2,233,686 112

7/19/1986 8:00 224 2 1,633 233 1,620,000 300 2,079,639 113

7/19/1986 10:00 226 2 1,617 217 1,500,000 278 1,925,591 114

7/19/1986 12:00 228 2 1,600 200 1,380,000 257 1,771,544 115

7/19/1986 14:00 230 2 1,583 183 1,260,000 235 1,617,497 116

7/19/1986 16:00 232 2 1,567 167 1,140,000 214 1,463,449 117

7/19/1986 18:00 234 2 1,550 150 1,020,000 193 1,309,402 118

7/19/1986 20:00 236 2 1,533 133 900,000 171 1,155,355 119

7/19/1986 22:00 238 2 1,517 117 780,000 150 1,001,308 120

7/20/1986 0:00 240 2 1,500 100 660,000 128 847,260 121

7/20/1986 2:00 242 2 1,483 83 540,000 107 693,213 122

7/20/1986 4:00 244 2 1,467 67 420,000 86 539,166 123

7/20/1986 6:00 246 2 1,450 50 300,000 64 385,118 124

7/20/1986 8:00 248 2 1,433 33 180,000 43 231,071 125

7/20/1986 10:00 250 2 1,417 17 60,000 21 77,024 126 n-1

7/20/1986 12:00 252 2 1,400 0 N/A 0 N/A 127 n

7/20/1986 14:00 254 2 1,383 N/A N/A N/A N/A N/A

7/20/1986 16:00 256 2 1,367 N/A N/A N/A N/A N/A

7/20/1986 18:00 258 2 1,350 N/A N/A N/A N/A N/A

7/20/1986 20:00 260 2 1,333 N/A N/A N/A N/A N/A

7/20/1986 22:00 262 2 1,317 N/A N/A N/A N/A N/A

7/21/1986 0:00 264 N/A 1,300 N/A N/A N/A N/A N/A

Total Total

Base Direct Runoff Unit Hydrograph

Flow, QB (cfs) 6 = 1,400 Volume, VR (ft

3 )

7 = 2,544,480,000 Volume, VUH (ft

3 /in)

8 = 3,266,419,200

VR (acre-ft) = 58,413 VUH (acre-ft/in) = 74,987

Page 4 of 6

Page 5 of 6

1,000

2,000

3,000

4,000

5,000

6,000

7,000

8,000

9,000

10,000

11,000

12,000

13,000

14,000

0 24 48 72 96 120 144 168 192 216 240 264 288

D is

c h

a rg

e (

c fs

)

Time (hours)

Flood Hydrograph

Base Flow, QB = 1,400 cfs

Horizontal Base Flow Separation Line

Page 6 of 6

Unit Hydrograph Derivation