perhitungan debit.xlsx

9
PERHITUNGAN DEBIT SUNGAI Lebar Pias 1 m Durasi Data 30 s K = 1 Miring K = 2 Kotak untuk n<3.13;v=0.133n+0.017-> V = 0.133 c = 0.017 Batas Data n 3.13 untuk n>3.13;v=0.1297n+0.022-> V = 0.1297 c = 0.022 No. Data putaran H [cm] Konversi n (rps) konversi v [m/s] 1 0.00 80.00 0.00 60 0.00 2.67 0.00 0.00 0.37 0.00 2 0.00 75.00 0.00 55 0.00 2.50 0.00 0.00 0.35 0.00 3 0.00 73.00 0.00 52 0.00 2.43 0.00 0.00 0.34 0.00 4 0.00 60.00 0.00 47 0.00 2.00 0.00 0.00 0.28 0.00 5 0.00 71.00 0.00 59 0.00 2.37 0.00 0.00 0.33 0.00 6 62.00 0.00 75.00 67 2.07 0.00 2.50 0.29 0.00 0.35 7 78.00 0.00 83.00 70 2.60 0.00 2.77 0.36 0.00 0.38 8 76.00 0.00 87.00 74 2.53 0.00 2.90 0.35 0.00 0.40 9 77.00 0.00 82.00 68 2.57 0.00 2.73 0.35 0.00 0.38 10 0.00 79.00 0.00 60 0.00 2.63 0.00 0.00 0.37 0.00 11 79.00 0.00 88.00 79 2.63 0.00 2.93 0.36 0.00 0.40 N0.2 N0.6 N0.8 n0.2 n0.6 n0.8 V0.2 V0.6 V0.8

Upload: arganegara-putra

Post on 17-Dec-2015

6 views

Category:

Documents


5 download

DESCRIPTION

PErhitungan debit sungai

TRANSCRIPT

Sheet1PERHITUNGAN DEBIT SUNGAILebar Pias1mDurasi Data30sK = 1MiringK = 2Kotakuntuk nV =0.133c =0.017Batas Data n3.13untuk n>3.13;v=0.1297n+0.022->V =0.1297c =0.022No.Data putaranH [cm]Konversi n (rps)konversi v [m/s]V [m/s]H' [cm]A1 [m2]A2 [m2]A3 [m2]A4 [m2]Luas [m2]Debit [m3/s]N0.2N0.6N0.8n0.2n0.6n0.8V0.2V0.6V0.810.0080.000.00600.002.670.000.000.370.000.37300.150.0750.3-0.006250.518750.1957.520.0075.000.00550.002.500.000.000.350.000.3557.50.2875-0.006250.275-0.003750.55250.1953.530.0073.000.00520.002.430.000.000.340.000.3453.50.2675-0.003750.26-0.006250.51750.1849.540.0060.000.00470.002.000.000.000.280.000.2849.50.2475-0.006250.2350.0150.491250.145350.0071.000.00590.002.370.000.000.330.000.33530.2650.0150.2950.010.5850.1963662.000.0075.00672.070.002.500.290.000.350.16630.3150.010.3350.003750.663750.1168.5778.000.0083.00702.600.002.770.360.000.380.1968.50.34250.003750.350.0050.701250.1372876.000.0087.00742.530.002.900.350.000.400.19720.360.0050.37-0.00750.72750.1471977.000.0082.00682.570.002.730.350.000.380.18710.355-0.00750.34-0.010.67750.1264100.0079.000.00600.002.630.000.000.370.000.37640.32-0.010.30.023750.633750.2369.51179.000.0088.00792.630.002.930.360.000.400.1969.50.34750.023750.395-0.001250.7650.1578.51276.000.0086.00782.530.002.870.350.000.390.1978.50.3925-0.001250.39-0.003750.77750.1476.51373.000.0083.00752.430.002.770.340.000.380.1876.50.3825-0.003750.375-0.0150.738750.13691465.000.0071.00632.170.002.370.300.000.330.16690.345-0.0150.315-0.0350.610.1049150.0053.000.00350.001.770.000.000.250.000.25490.245-0.0350.175-0.043750.341250.0917.5Bentuk Sungai000160-60255-55352-52447-47559-59667-67770-70874-74968-681078-781179-791278-781375-751463-631535-351600

Sheet2sPERHITUNGAN DEBIT SUNGAILebar Pias1mDurasi Data30sK = 1MiringK = 2Kotakuntuk nV =0.133c =0.017Batas Data n3.13untuk n>3.13;v=0.1297n+0.022->V =0.1297c =0.022No.Data putaranHKonversi nkonversi vVH'A1A2A3A4LuasDebitN0.2N0.6N0.8n0.2n0.6n0.8V0.2V0.6V0.810.0090.000.00580.003.000.000.000.420.000.42290.1450.07250.29-0.00250.5050.215720.0070.000.00560.002.330.000.000.330.000.33570.285-0.00250.28-0.003750.558750.1854.530.0075.000.00530.002.500.000.000.350.000.3554.50.2725-0.003750.265-0.016250.51750.1846.540.0065.000.00400.002.170.000.000.310.000.3146.50.2325-0.016250.20.0250.441250.135050.0073.000.00600.002.430.000.000.340.000.34500.250.0250.30.006250.581250.2062.5665.000.0070.00652.170.002.330.300.000.320.1662.50.31250.006250.3250.006250.650.1067.5778.000.0083.00702.600.002.770.360.000.380.1967.50.33750.006250.350.006250.70.1372.5879.000.0080.00752.630.002.670.360.000.370.1872.50.36250.006250.375-0.00750.736250.1372975.000.0083.00692.500.002.770.350.000.380.18720.36-0.00750.345-0.011250.686250.1264.5100.0077.000.00600.002.570.000.000.360.000.3664.50.3225-0.011250.30.020.631250.23681175.000.0089.00762.500.002.970.350.000.410.19680.340.020.38-0.006250.733750.1473.51272.000.0088.00712.400.002.930.330.000.400.1873.50.3675-0.006250.3550.00250.718750.13721374.000.0082.00732.470.002.730.340.000.380.18720.360.00250.365-0.011250.716250.1368.51464.000.0075.00642.130.002.500.300.000.350.1668.50.3425-0.011250.32-0.030.621250.1052150.0055.000.00400.001.830.000.000.260.000.26520.26-0.030.2-0.050.380.1020Bentuk Sungai000160-60255-55352-52447-47559-59667-67770-70874-74968-681078-781179-791278-781375-751463-631535-351600