Excel Hidrologi [PDF]

Citation preview

B. Menyelidiki Konsistensi Data Hujan di Setiap Stasiun



Tabel 3.B.1 Curah hujan harian tahunan maksimal di STA A (Pahoman) Tahun



Polinela (mm)



Kumulatif



2012 2013 2014 2015 2016



102.1 107.2 102.8 91.6 87.5



102.100 209.300 312.100 403.700 491.200



Konsistensi Data Hujan di STA A label rang linear



Kumulatif A0 600.000



500 1000 1500 2000



400.000 200.000 0.000



1



2



Linea 100 r



0 200 400 600 4 800



200 300 400 500



3



5



3.B.6 Grafik konsistensi data hujan di stasiun A



Tabel 3.B.2 Curah hujan harian tahunan maksimal di STA B (Sukarame) Tahun



B (mm)



A (mm)



C (mm)



1997 1998 1999 2000 2001 2002 2003 2004 2005 2006 2007 2008



73.17228 75.11 67.11 55.05 50.61 71.44 80.11 61.11 76.45 74.64 84.11 94.46



130.11 129.91 67.11 69.11 45.46 95.11 75.11 95.11 70.11 72.11 102.11 150.11



67.85936 103.517 85.11 60.11 76.61 153.11 180.11 86.78 73.55 105.33 90.11 63.11



STA di Kumulatif B Kumulatif D (mm) Rerata A,C,D rerata A,C,D 83.11 96.57 168.11 148.11 74.38 105.11 70.11 87.11 91.11 148.11 90.11 105.11



93.6931 109.9990 106.7767 92.4433 65.4833 117.7767 108.4433 89.6667 78.2567 108.5167 94.1100 106.1100



73.1723 148.2823 215.3923 270.4423 321.0523 392.4923 472.6023 533.7123 610.1623 684.8023 768.9123 863.3723



93.6931 203.6921 310.4688 402.9121 468.3955 586.1721 694.6155 784.2821 862.5388 971.0555 1065.1655 1171.2755



Konsistensi Data Hujan di STA B Kumul atif B



Kumul atif A,C,D



Li near



1400.0000 1200.0000 1000.0000 800.0000 600.0000 400.0000 200.0000 0.0000



1



2



3



4



5



6



7



8



9



10



11



12



11



12



11



12



3.B.7 Grafik konsistensi data hujan di stasiun B Tabel 3.B.3 Curah hujan harian tahunan maksimal di STA C (Sumur Puteri) Tahun



C (mm)



B (mm)



A (mm)



D (mm)



1997 1998 1999 2000 2001 2002 2003 2004 2005 2006 2007 2008



67.85936 103.517 85.11 60.11 76.61 153.11 180.11 86.78 73.55 105.33 90.11 63.11



73.17228 75.11 67.11 55.05 50.61 71.44 80.11 61.11 76.45 74.64 84.11 94.46



130.11 129.91 67.11 69.11 45.46 95.11 75.11 95.11 70.11 72.11 102.11 150.11



83.11 96.57 168.11 148.11 74.38 105.11 70.11 87.11 91.11 148.11 90.11 105.11



Rerata STA di Kumulatif Kumulatif C rerata B,A,D B,A,D 95.4641 100.5300 100.7767 90.7567 56.8167 90.5533 75.1100 81.1100 79.2233 98.2867 92.1100 116.5600



67.8594 171.3764 256.4864 316.5964 393.2064 546.3164 726.4264 813.2064 886.7564 992.0864 1082.1964 1145.3064



95.4641 195.9941 296.7708 387.5274 444.3441 534.8974 610.0074 691.1174 770.3408 868.6274 960.7374 1077.2974



Konsistensi Data Hujan di STA C Kumul atif c



Kumulatif B,A,D



Li nea r



1400.0000 1200.0000 1000.0000 800.0000 600.0000 400.0000 200.0000 0.0000



1



2



3



4



5



6



7



8



9



10



3.B.8 Grafik konsistensi data hujan di stasiun C Tabel 3.B.4 Curah hujan harian tahunan maksimal di STA D (Sumberejo) Tahun



D (mm)



B (mm)



A (mm)



1997 1998 1999 2000 2001 2002 2003 2004 2005 2006 2007 2008



83.11 96.57 168.11 148.11 74.38 105.11 70.11 87.11 91.11 148.11 90.11 105.11



73.17228 75.11 67.11 55.05 50.61 71.44 80.11 61.11 76.45 74.64 84.11 94.46



130.11 129.91 67.11 69.11 45.46 95.11 75.11 95.11 70.11 72.11 102.11 150.11



STA di Kumulatif D Kumulatif C (mm) Rerata B,C,A rerata B,C,A 67.85936 103.517 85.11 60.11 76.61 153.11 180.11 86.78 73.55 105.33 90.11 63.11



90.3805 102.8457 73.1100 61.4233 57.5600 106.5533 111.7767 81.0000 73.3700 84.0267 92.1100 102.5600



83.1100 179.6800 347.7900 495.9000 570.2800 675.3900 745.5000 832.6100 923.7200 1071.8300 1161.9400 1267.0500



90.3805 193.2262 266.3362 327.7595 385.3195 491.8729 603.6495 684.6495 758.0195 842.0462 934.1562 1036.7162



Konsiste nsi Data Hujan di STA D Kumulatif D



Kumulatif B,C,A



Linea r



1400.0000 1200.0000 1000.0000 800.0000 600.0000 400.0000 200.0000 0.0000



1



2



3



4



5



6



7



8



9



10



3.B.9 Grafik konsistensi data hujan di stasiun D



C. Perhitungan curah hujan rata-rata dengan metode poligon Thiessen Tabel 3.C.1 Curah hujan harian tahunan max di sta a (pahoman) Tahun



Tanggal



Polinela (mm)



2012 2013 2014 2015 2016



9-Oct 28-Jul 27-Mar 8-Apr 7-Feb



102.1 107.2 102.8 91.6 87.5



KOEF THIESSEN A



Luas (A)=



0.1103



231.019



Tabel 3.C.5 Curah hujan maksimum No



Tahun



1 2 3 4 5



2012 2013 2014 2015 2016 jumlah Rratarata



R 102.100 107.200 102.800 91.600 87.500 491.2000 98.2400



Ln R



M



4.626 4.675 4.633 4.517 4.472 22.9225 4.5845



R terurut 1 2 3 4 5



87.500 91.600 102.100 102.800 107.200 491.2000



R-Rratarata



(R-Rratarata)^2



-10.7400 -6.6400 3.8600 4.5600 8.9600



Non Logaritmik Cs= -0.016863 Ck= 0.650388 Cv= 0.254579 S= 16.2224



(R-Rratarata)^3



115.3476 44.0896 14.8996 20.7936 80.2816 275.4120 Logaritmik Cs= Ck= Cv= s=



-1238.8332 -292.7549 57.5125 94.8188 719.3231 -659.9338



-0.6185 3.1783 0.0661 0.2726



(R-Rratarata)^4 13305.0688 1943.8928 221.9981 432.3738 6445.1353 22348.4688



Ln R - Ln Rrata) 0.0415 0.0902 0.0483 -0.0671 -0.1129 0.0000



(Ln R - Ln Rrata)^2 0.0017 0.0081 0.0023 0.0045 0.0127 0.0294



(Ln R - Ln (Ln R - Ln Rrata)^3 Rrata)^4 0.0001 0.0000 0.0007 0.0001 0.0001 0.0000 -0.0003 0.0000 -0.0014 0.0002 -0.0008 0.0003



rata rata log R= 1.9910234338 Log R/10=



Log R



P = m/(n+1)



1.9420 1.9619 2.0090 2.0120 2.0302 9.9551



7.6923 15.3846 23.0769 30.7692 38.4615 115.3846



r urut



log R 86 88 90 95 100 105 110 112 120 125 130 135 140 150 155 160 1901



1.9345 1.9445 1.9542 1.9777 2.0000 2.0212 2.0414 2.0492 2.0792 2.0969 2.1139 2.1303 2.1461 2.1761 2.1903 2.2041 33.0598 118.8125



log r - log rrata log r - log rrata^2 -0.1404 -0.1304 -0.1206 -0.0971 -0.0749 -0.0537 -0.0335 -0.0256 0.0043 0.0220 0.0391 0.0555 0.0713 0.1012 0.1155 0.1293 -0.1380 2.0749



0.0197 0.0170 0.0145 0.0094 0.0056 0.0029 0.0011 0.0007 0.0000 0.0005 0.0015 0.0031 0.0051 0.0102 0.0133 0.0167 0.1214



log r - log rrata^3 -0.0028 -0.0022 -0.0018 -0.0009 -0.0004 -0.0002 0.0000 0.0000 0.0000 0.0000 0.0001 0.0002 0.0004 0.0010 0.0015 0.0022 -0.0029



Log R - (Log R - Log Log Rrata Rrata)^2 -0.0490 0.0024 -0.0291 0.0008 0.0180 0.0003 0.0210 0.0004 0.0392 0.0015 0.0055



(Log R - Log Rrata)^3 -0.0001 0.0000 0.0000 0.0000 0.0001 -0.0001



G



Std log R



Log t



Rt



5 25 50 100



0.857 1.5209 1.7099 1.8668



0.1184 0.1184 0.1184 0.1184



1.0970 1.1756 1.1980 1.2165



12.5020 14.9826 15.7748 16.4642



0.631



R



0.1300 0.0650 0.0433 0.0325 0.0260 0.2968



Huj. ranc (tahun) 0.995512



c=



1995 1996 1997 1998 1999 2000 2001 2002 2003 2004 2005 2006 2007 2008 2009 2010 jumlah



T = 1/p



km= 10^6



Dimensi penampang Huj. ranc (tahun) b1 5 25 50 100



90% Rt



b2 13 14 15 16



itensitas hujan (mm/jam) jam ke 2 40% jam ke3 40%



jam ke1 10%



11.2518 13.4843 14.1973 14.8178



1.1252 1.3484 1.4197 1.4818



h1 15 23 24 25



4.5007 5.3937 5.6789 5.9271



h2 6 6 6 6



I 5 5 5 5



I (mm/jam)



jam ke4 10%



4.5007 5.3937 5.6789 5.9271



1.1252 1.3484 1.4197 1.4818



m 0.008 0.008 0.008 0.008



n 1 1 1 1



Q (m3/s)



4.5007 5.3937 5.6789 5.9271



182.2458 218.4054 229.9540 240.0037



A (m2) 0.025 0.025 0.025 0.025



214.0000 260.0000 271.0000 282.0000



Q teoritis 2604.2573 3130.5347 3302.3036 3475.1836



P (kel. Basah) R 34.1127 6.2733 42.1127 6.1739 43.1127 6.2859 44.1127 6.3927



uas hidrologi 1 juli data hujan harian maksimum tahunan di sta A jan feb mar apr mei jun jul agt sep okt nov des



50 60 50 40 40 15 10 0 5 20 30 80



data hujan harian maksimum tahunan di sta B jan feb mar apr mei jun jul agt sep okt nov des



55 70 45 65 20 10 15 4 5 40 40 56



data hujan harian maksimum tahunan di sta C jan feb mar apr mei jun jul agt sep



88 70 40 52 35 30 5 0 25



okt nov des



20 30 60