Scribd
Upload
18 views4 pages

Rainfall Hyetograph Analysis in Excel

The document contains data from a rainfall hyetograph showing time, rainfall tips, cumulative depth, and depth over 30 minute intervals. It also includes graphs of the hyetograph data and rainfall intensity over time. Tables show maximum rainfall depths and intensities over 30 minutes and 1 hour, and precipitation return periods for different rainfall amounts over 30 minutes.

Uploaded by

Mohd Hairul
Copyright
© Attribution Non-Commercial (BY-NC)
We take content rights seriously. If you suspect this is your content, claim it here.
Available Formats
Download as XLS, PDF, TXT or read online on Scribd
18 views4 pages

Rainfall Hyetograph Analysis in Excel

The document contains data from a rainfall hyetograph showing time, rainfall tips, cumulative depth, and depth over 30 minute intervals. It also includes graphs of the hyetograph data and rainfall intensity over time. Tables show maximum rainfall depths and intensities over 30 minutes and 1 hour, and precipitation return periods for different rainfall amounts over 30 minutes.

Uploaded by

Mohd Hairul
Copyright
© Attribution Non-Commercial (BY-NC)
We take content rights seriously. If you suspect this is your content, claim it here.
Available Formats
Download as XLS, PDF, TXT or read online on Scribd

Q1.

a
Time Tips Cumulative Depth (mm) Depth (mm)
9.30 0.0 0 0
9.40 3.0 0.8 0.9
9.50 4.0 1.0 0.3
10.00 12.0 3.0 2.0
10.10 29.0 7.4 4.3
10.20 38.0 9.7 2.3
10.30 42.0 10.7 1.0

rainfall hyetograph

4.5

3.5

3
rainfall (mm)

2.5

1.5

0.5

0
9.30 9.40 9.50 10.00 10.10 10.20 10.30

time (hour)
Q1.b

Time Tips Cumulative Depth (mm) Depth (mm) Intensity (mm/hr)


9.30 0.0 0 0.00 0.00
9.50 4.0 1.0 0.90 2.70
10.10 29.0 7.4 6.35 19.05
10.30 42.0 10.7 3.30 9.91
10.50 52.0 13.2 2.54 7.62
11.10 56.0 14.2 1.02 3.05
11.30 61.0 15.5 1.27 3.81
11.50 70.0 17.8 2.29 6.86
12.10 74.0 18.8 1.02 3.05
12.30 80.0 20.3 1.52 4.57
12.50 84.0 21.3 1.02 3.05
13.10 86.0 21.8 0.51 1.52
13.30 86.0 21.8 0.00 0.00

intensity vs time
25

20

15
mm/hr

10

0
9.30 9.50 10.10 10.30 10.50 11.10 11.30 11.50 12.10 12.30 12.50 13.10 13.30

time
Time Tips Cumulative Depth (mm) Running Total
30 min 1hour
9.30 0.0 0
9.40 3.0 0.8
9.50 4.0 1.0
10.00 12.0 3.0 3.0
10.10 29.0 7.4 6.60
10.20 38.0 9.7 8.64
10.30 42.0 10.7 7.62 10.67
10.40 46.0 11.7 4.32 10.92
10.50 52.0 13.2 3.56 12.19
11.00 54.0 13.7 3.05 10.67
11.10 56.0 14.2 2.54 6.86
11.20 58.0 14.7 1.52 5.08
11.30 61.0 15.5 1.78 4.83
11.40 64.0 16.3 2.03 4.57
11.50 70.0 17.8 3.05 4.57
12.00 73.0 18.5 3.05 4.83
12.10 74.0 18.8 2.54 4.57
12.20 78.0 19.8 2.03 5.08
12.30 80.0 20.3 1.78 4.83
12.40 83.0 21.1 2.29 4.83
12.50 84.0 21.3 1.52 3.56
13.00 85.0 21.6 1.27 3.05
13.10 86.0 21.8 0.76 3.05
13.20 86.0 21.8 0.51 2.03
13.30 86.0 21.8 0.25 1.52
Max Depth (mm) 8.64 12.19
Max Intensity (mm/hr) 17.27 12.19
Q4
Rank,m Precipitation (mm) Return Period Return Period mm intensity
30 minute (mm/hr)
1 100 31.0 30 99.7 199.4
2 96 15.5 20 97.2 194.4
3 93 10.3 10 91.6 183.2
4 90 7.8
5 89 6.2
6 88 5.2
7 86 4.4
8 85 3.9
9 84 3.4
10 83 3.1
11 79 2.8
12 77 2.6
13 76 2.4
14 75 2.2
15 70 2.1
16 71 1.9
17 68 1.8
18 67 1.7
19 66 1.6
20 65 1.6
21 63 1.5
22 62 1.4
23 61 1.3
24 60 1.3
25 59 1.2
26 56 1.2
27 55 1.1
28 52 1.1
29 50 1.1
30 50 1.0

You might also like