analisa curah hujan van breen
TRANSCRIPT
Intensitas Hujan untuk kota Jakarta
durasi (mIntensitas Hujan (mm/jam)untuk Perioda Ulang (tahun)
2 5 10 25 505 126 146 155 180 191
10 114 126 138 156 16820 103 114 123 135 14440 76 87 96 105 11460 61 43 81 91 100
120 36 45 51 58 63240 21 27 30 35 40
Intensitas Hujan Menurut Van breen sebelum dikoreksiPUH R desain (mm/24 jam) Intensitas (mm/jam)
2 90.63 20.3925 101.96 22.941
10 109.47 24.63125 118.95 26.76450 125.99 28.348
Intensitas hujan Menurut Van breen setelah dikoreksiDurasi ( Intensitas Hujan (mm/jam)
untuk periode ulang(tahun)2 5 10 25 50
5 122 124 127 138 13510 111 107 113 119 11920 100 97 101 103 10240 74 74 79 80 8160 59 37 67 70 71
120 35 38 42 44 45240 20 23 25 27 28
Pemilihan rumus intensitas hujan PUH 2 Tahunpersamaan Talbot
t I I.t I2 I2t log t5 122 612 14970 74848 0.70
10 111 1107 12254 122541 1.0020 100 2000 10003 200067 1.3040 74 2952 5446 217850 1.6060 59 3554 3509 210514 1.78
120 35 4195 1222 146641 2.08
240 20 4894 416 99798 2.38495 521 19314 47820 1072259 11
Talbot Shermana b a n
6251.88 40.83 2.52 7.34
No. t I (data) I Talbot Delta I I (sherman)1 5 122 136 14 1.863E-052 10 111 123 12 1.149E-073 20 100 103 3 7.091E-104 40 74 77 4 4.375E-125 60 59 62 3 2.230E-136 120 35 39 4 1.376E-157 240 20 22 2 8.489E-18
Jumlah 41Rata-rata 6
PUH 25 Tahunt I I.t I2 I2t log t5 138 688 18945 94727 0.70
10 119 1193 14230 142301 1.0020 103 2065 10657 213135 1.3040 80 3212 6447 257867 1.6060 70 4175 4842 290531 1.78
120 44 5322 1967 236045 2.08240 27 6423 716 171912 2.38
495 581 23078 57804 1406518 11
Talbot Shermana b a n
9534.98 53.32 2.50 7.52
No. t I (data) I Talbot Delta I I (sherman)1 5 138 164 26 1.382E-052 10 119 151 31 7.517E-083 20 103 130 27 4.090E-104 40 80 102 22 2.225E-125 60 70 84 15 1.054E-136 120 44 55 11 5.734E-167 240 27 33 6 3.120E-18
Jumlah 137Rata-rata 20
PUH 5 Tahunlog I log t. log I log t2 akar t I akar t I2 akar t t2.09 1.46 0.49 2.24 274 33473 52.04 2.04 1.00 3.16 350 38751 102.00 2.60 1.69 4.47 447 44736 201.87 2.99 2.57 6.32 467 34445 401.77 3.15 3.16 7.75 459 27177 601.54 3.21 4.32 10.95 383 13386 120
1.31 3.12 5.67 15.49 316 6442 24013 19 19 50 2695 198411 495
Ishiguroa b
404.73 0.26
Delta I I (Ishiguro) Delta I No.-1.224E+02 176.4 54.0 1-1.107E+02 126.3 15.6 2-1.000E+02 89.9 -10.1 3-7.380E+01 63.8 -10.0 4-5.923E+01 52.1 -7.1 5-3.496E+01 36.9 1.9 6-2.039E+01 26.1 5.7 7
-521 50 Jumlah-74 7 Rata-rata
PUH 50 Tahunlog I log t. log I log t2 akar t I akar t I2 akar t t2.14 1.49 0.49 2.24 308 42363 52.08 2.08 1.00 3.16 377 44999 102.01 2.62 1.69 4.47 462 47659 201.90 3.05 2.57 6.32 508 40772 401.84 3.28 3.16 7.75 539 37507 601.65 3.42 4.32 10.95 486 21548 1201.43 3.40 5.67 15.49 415 11097 240
13 19 19 50 3094 245946
Ishiguroa b
536.88 1.14
Delta I I (Ishiguro) Delta I No.-1.376E+02 216.6 79.0 1-1.193E+02 160.8 41.5 2-1.032E+02 116.8 13.5 3-8.029E+01 83.7 3.4 4-6.959E+01 68.7 -0.9 5-4.435E+01 48.8 4.4 6-2.676E+01 34.6 7.8 7
-581 149 Jumlah-83 21 Rata-rata
PUH 5 TahunI I.t I2 I2t log t log I log t. log I log t2 akar t
124 620 15389 76944 0.70 2.09 1.46 0.49 2.24107 1071 11461 114614 1.00 2.03 2.03 1.00 3.1697 1937 9382 187645 1.30 1.99 2.58 1.69 4.4774 2957 5464 218573 1.60 1.87 2.99 2.57 6.3237 2192 1335 80091 1.78 1.56 2.78 3.16 7.7538 4588 1462 175430 2.08 1.58 3.29 4.32 10.95
23 5506 526 126309 2.38 1.36 3.24 5.67 15.49500 18871 45020 979606 11 12 18 19 50
Talbot Sherman Ishiguroa b a n a b
5564.53 39.23 2.48 7.25 383.12 0.22
t I (data) I Talbot Delta I I (sherman) Delta I I (Ishiguro) Delta I5 124 126 2 2.113E-05 -1.241E+02 167.7 43.7
10 107 113 6 1.385E-07 -1.071E+02 119.9 12.820 97 94 -3 9.077E-10 -9.686E+01 85.2 -11.740 74 70 -4 5.949E-12 -7.392E+01 60.4 -13.560 37 56 20 3.142E-13 -3.654E+01 49.4 12.8
120 38 35 -3 2.059E-15 -3.824E+01 34.9 -3.3240 23 20 -3 1.350E-17 -2.294E+01 24.7 1.8
14 -500 432 -71 6
PUH 50 TahunI I.t I2 I2t log t log I log t. log I log t2 akar t
135 677 18322 91612 0.70 2.13 1.49 0.49 2.24119 1191 14175 141754 1.00 2.08 2.08 1.00 3.16102 2041 10415 208292 1.30 2.01 2.61 1.69 4.4781 3232 6527 261088 1.60 1.91 3.06 2.57 6.3271 4252 5022 301348 1.78 1.85 3.29 3.16 7.7545 5358 1993 239210 2.08 1.65 3.43 4.32 10.9528 6803 804 192863 2.38 1.45 3.46 5.67 15.49
581 23553 57259 1436167 11 13 19 19 50
Talbot Sherman Ishiguroa b a n a b
21372.10 57.59 2.48 7.52 561.22 1.38
t I (data) I Talbot Delta I I (sherman) Delta I I (Ishiguro) Delta I5 135 341 206 1.374E-05 -1.354E+02 222.1 86.7
10 119 316 197 7.481E-08 -1.191E+02 166.3 47.320 102 275 173 4.074E-10 -1.021E+02 121.4 19.340 81 219 138 2.219E-12 -8.079E+01 87.2 6.460 71 182 111 1.051E-13 -7.087E+01 71.6 0.8
120 45 120 76 5.725E-16 -4.465E+01 50.9 6.3240 28 72 43 3.118E-18 -2.835E+01 36.1 7.8
945 -581 175135 -83 25
PUH 10 TahunI akar t I2 akar t t I I.t I2 I2t log t
277 34410 5 127 636 16195 80974 0.70339 36244 10 113 1133 12837 128372 1.00433 41959 20 101 2020 10198 203964 1.30468 34559 40 79 3153 6212 248494 1.60283 10340 60 67 3990 4423 265359 1.78419 16014 120 42 5025 1753 210394 2.08
355 8153 240 25 5911 607 145602 2.382574 181680 495 553 21868 52225 1283159 11
Talbot Shermana b a n
8539.80 52.55 2.48 7.44
No. t I (data) I Talbot Delta I I (sherman)1 5 127 148 21 1.565E-052 10 113 137 23 9.014E-083 20 101 118 17 5.191E-104 40 79 92 13 2.990E-125 60 67 76 9 1.464E-136 120 42 49 8 8.432E-167 240 25 29 5 4.856E-18
Jumlah 96Rata-rata 14
I akar t I2 akar t303 40970377 44827456 46575511 41282549 38904489 21837439 12449
3124 246844
log I log t. log I log t2 akar t I akar t I2 akar t2.10 1.47 0.49 2.24 285 362132.05 2.05 1.00 3.16 358 405952.00 2.61 1.69 4.47 452 456081.90 3.04 2.57 6.32 498 392901.82 3.24 3.16 7.75 515 342581.62 3.37 4.32 10.95 459 19206
1.39 3.31 5.67 15.49 382 939913 19 19 50 2948 224568
Ishiguroa b
500.52 1.00
Delta I I (Ishiguro) Delta I-1.273E+02 204.3 77.0-1.133E+02 150.9 37.6-1.010E+02 109.2 8.2-7.882E+01 78.2 -0.7-6.650E+01 64.1 -2.4-4.187E+01 45.5 3.6-2.463E+01 32.2 7.6
-553 131-79 19
Intensitas Hujan Van Breen2 5 10 25 50
5 136 126 148 164 34110 123 113 137 151 31620 103 94 118 130 27540 77 70 92 102 21960 62 56 76 84 182
120 39 35 49 55 120240 22 20 29 33 72
Intensitas Hujan Van Breen2 5 10 25 50
5 1.863E-05 2.113E-05 1.565E-05 1.382E-05 1.374E-0510 1.149E-07 1.385E-07 9.014E-08 7.517E-08 7.481E-0820 7.091E-10 9.077E-10 5.191E-10 4.090E-10 4.074E-1040 4.375E-12 5.949E-12 2.990E-12 2.225E-12 2.219E-1260 2.230E-13 3.142E-13 1.464E-13 1.054E-13 1.051E-13
120 1.376E-15 2.059E-15 8.432E-16 5.734E-16 5.725E-16240 8.489E-18 1.350E-17 4.856E-18 3.120E-18 3.118E-18
Durasi (Menit)
Durasi (Menit)
0 50 100 150 200 250 3000.000E+00
5.000E-06
1.000E-05
1.500E-05
2.000E-05
2.500E-05
2
5
10
25
50
0 50 100 150 200 250 3000
50
100
150
200
250
300
350
400
Kurva IDF Van Breen
2
5
10
25
50
Durasi Waktu (menit)
Inte
nsita
s (m
m/J
am)
0 50 100 150 200 250 3000
50
100
150
200
250
300
350
400
Kurva IDF Van Breen
2
5
10
25
50
Durasi Waktu (menit)
Inte
nsita
s (m
m/J
am)
Compatibility Report for analisa curah hujan sampai kurva idf.xlsRun on 07/05/2012 11:30
Significant loss of functionality # of occurrences
2
The following features in this workbook are not supported by earlier versions of Excel. These features may be lost or degraded when you save this workbook in an earlier file format.
Earlier versions of Excel only support line colors from the color palette. When the workbook is opened in an earlier version of Excel, all line colors will be mapped to the closest color in the color palette, and a chart may display multiple series in the same color.
'Sheet2'!A1:M27