Sheet1A. Tabel data hasil pengukuranB.Tabel perhitungan jarak optis, beda tinggi dan elevasi titik pengukuranC. Tabel perhitungan jarak rerata antara patok*Pembacaan Pergi* Pembacaan PergiSlagJarakJarak Optis (m)JarakJarakAlatTitikPembacaan Baak (m)JarakTinggi AlatTitikPembacaan Baak (m)Jarak OptisBeda Tinggi (m)ElevasiRollmeter (m)PergiPulangRerata (m)Komulatif (m)E. Tabel Perhitungan Elevasi Titik DetaildiTembakBelakangMuka(m)(m)BelakangMuka(m)-+A-BP1A1160.500* Pembacaan PulangA3B-CAlat diTitikBt (m)TGBElevasiSketsa Saluran158.200AlatTitikPembacaan Baak (m)JarakTinggi AlatC-DP1155.600diTembakBelakangMuka(m)(m)D-EA2143.000P5F3216.700B3E-F142.600213.950142.000211.200A3217.500E3231.400C3D. Tabel perhitungan beda tinggi dan elevasi rerata titik pengukuran215.000228.900TitikBeda Tinggi (m)Elevasi212.500226.400PergiPulangRerataP2A4165.000P4E3210.500D3A162.000208.000158.000205.500BA5105.500D3229.500E3103.000227.000C100.300224.500B1147.200P3D3208.500F3DP3144.600205.100142.300203.200EB2139.500C3224.500137.200222.100F134.600219.500B3206.700P2C3214.200204.300211.800* Pembacaan PulangP4201.400209.800TitikPembacaan Baak (m)Jarak OptisBeda Tinggi (m)ElevasiB4155.200B3226.700BelakangMuka(m)-+153.000224.000F3150.200222.500B5104.800P1B3206.700102.300204.300E3100.000201.400P5P2B3226.700A3217.500224.000215.000D3222.500212.500C1151.800149.200C3146.900C2146.200144.000B3141.200C3214.200211.800A3209.800C4156.800155.700154.200C5102.800100.10097.800P3C3224.500222.100219.500D1149.000146.500144.000D2136.600134.200131.300D3208.500205.100203.200D4153.400151.000148.500D593.40090.70088.000P4D3229.500227.000224.500E1155.800153.400151.000E2139.500136.900134.300E3210.500208.000205.500E4161.400158.900156.400E593.20090.70088.200P5E3231.400228.900226.400F1163.100160.300157.900F2147.500145.030142.600F3216.700213.950211.200F4163.400160.900158.400F5113.500110.350108.200A. Tabel data hasil pengukuranB.Tabel perhitungan jarak optis, beda tinggi dan elevasi titik pengukuranC. Tabel perhitungan jarak rerata antara patok*Pembacaan Pergi* Pembacaan PergiSlagJarakJarak Optis (m)JarakJarakAlatTitikPembacaan Baak (m)JarakTinggi AlatTitikPembacaan Baak (m)Jarak OptisBeda Tinggi (m)ElevasiRollmeter (m)PergiPulangRerata (m)Komulatif (m)E. Tabel Perhitungan Elevasi Titik DetaildiTembakBelakangMuka(m)(m)BelakangMuka(m)+-A-B10.0004.40010.5007.4507.450P1A11.60510.001.400* Pembacaan PulangA32.1755.000120.000B-C10.0005.30010.0007.65015.100Alat diTitikBt (m)TGBElevasiSketsa Saluran1.58210.00AlatTitikPembacaan Baak (m)JarakTinggi Alat2.1505.3000.107C-D10.0005.00010.3007.65022.750P1A11.582112.8231.55610.00diTembakBelakangMuka(m)(m)2.12510.3000.146D-E10.0005.5008.6007.05029.800A21.426112.979A21.43010.00P5F32.16210.0001.580B32.2672.0674.200120.253E-F10.0000.00010.3005.15034.950A32.150114.405112.2551.42610.002.13510.0002.2402.0434.4000.122A41.620112.7851.42010.002.10710.0002.2252.0148.6000.146A51.030113.375A32.17510.00E32.30910.000C32.2452.1425.000120.522D. Tabel perhitungan beda tinggi dan elevasi rerata titik pengukuran2.15010.002.28410.0002.2212.1185.3000.170TitikBeda Tinggi (m)Elevasi2.12510.002.25910.0002.1952.09810.3000.146PergiPulangRerataP2B11.446112.777A41.65010.00P4E32.10010.0001.520D32.2952.0855.000120.838A112.255B21.372112.8511.62010.002.07510.0002.2702.0515.0000.1900.0000.1500.075B32.043114.223112.1801.58010.002.05010.0002.2452.03210.0000.146B112.180B41.530112.693A51.05510.00D32.29010.000E32.3142.1055.000121.1750.0000.1900.095B51.023113.2001.03010.002.26510.0002.2892.0805.5000.150C112.0851.00310.002.24010.0002.2642.05510.5000.1460.0000.1700.085B11.47210.00P3D32.08010.0001.520F32.167121.471D112.000P3C11.492112.7111.44610.002.04610.0002.1400.0000.1220.061C21.440112.7631.42310.002.02710.0002.112E111.939C32.118114.203112.085B21.39510.00C32.24010.0000.0000.1070.053C41.557112.6461.37210.002.21610.000Faktor koreksi=0.732F111.886C51.001113.2021.34610.002.19010.000n=5.000B32.06710.00P2C32.13710.0001.540fk=0.1462.04310.002.11310.000* Pembacaan PulangP4D11.465112.5862.01410.002.09310.000TitikPembacaan Baak (m)Jarak OptisBeda Tinggi (m)ElevasiD21.342112.709B41.55210.00B32.26210.000BelakangMuka(m)-+D32.051114.051112.0001.53010.002.23510.000F32.162D41.510112.5411.50210.002.22010.0002.1350.150111.661D50.907113.144B51.04810.00P1B32.06210.0001.4202.1071.02310.002.03810.000E32.1002.3091.00010.002.00910.0002.0752.28410.5000.190111.810P5E11.534112.485P2B32.26710.001.520A32.17010.0002.0502.259E21.369112.6502.24010.002.14510.000D32.0802.290E32.080114.019111.9392.22510.002.12010.0002.0462.26510.0000.170112.000E41.589112.430C11.51810.002.0272.240E50.907113.1121.49210.00C32.1372.240muka tanahtrotoarsalurantangguljalan1.46910.002.1132.21610.3000.122112.170113.375112.979112.255112.785112.823C21.46210.002.0932.190113.200112.851112.180112.693112.777P5F11.603112.4221.44010.00B32.0622.262113.202112.763112.085112.646112.711F21.450112.5751.41210.002.0382.2358.6000.107112.292113.144112.709112.000112.541112.586F32.140114.025111.886C32.14210.002.0092.220113.112112.650111.939112.430112.485F41.609112.4162.11810.00A32.170112.922112.575111.886112.416112.422F51.104112.9222.09810.002.14510.300112.399muka tanahTrotoartanggulJalanC41.56810.002.1200.5900.7240.5300.1561.55710.000.5070.6710.5130.0741.54210.000.5560.6780.5610.052C51.02810.000.6030.7090.5410.1231.00110.000.6820.7110.4910.1650.97810.000.5050.6890.5310.153P3C32.24510.001.5002.22110.002.19510.00D11.49010.001.46510.001.44010.00D21.36610.001.34210.001.31310.00D32.08510.002.05110.002.03210.00D41.53410.001.51010.001.48510.00D50.93410.000.90710.000.88010.00P4D32.29510.001.5002.27010.002.24510.00E11.55810.001.53410.001.51010.00E21.39510.001.36910.001.34310.00E32.10510.002.08010.002.05510.00E41.61410.001.58910.001.56410.00E50.93210.000.90710.000.88210.00P5E32.31410.001.5602.28910.002.26410.00F11.63110.001.60310.001.57910.00F21.47510.001.45010.001.42610.00F32.16710.002.14010.002.11210.00F41.63410.001.60910.001.58410.00F51.13510.001.10410.001.08210.00

Sheet2F. Tabel Perhitungan Slope Dasar Saluran LamaG. Tabel Perhitungan Jarak HorisontalTitikBeda TinggiJarakJarak HorisontalTitikElevasiBeda TinggiJarakSlopeUtamaRerata (m)(m)DasarA0.0757.4507.450A3112.2550.0100.0757.450B0.0957.6507.649B3112.1800.0120.0957.649C0.0857.6507.650C3112.0850.0110.0857.650D0.0617.0507.050D3112.0000.0090.0617.050E0.0535.1505.150E3111.9390.0100.0535.150FF3111.886JUMLAH0.36934.95034.948SLOPE0.011

Sheet3PERHITUNGAN VOLUME GALIAN DAN TIMBUNAN SALURAN RENCANAINTERVALTITIK YANGLUASLUASJARAKVOLUMEVOLUMETITIKDIUKURGALIANTIMBUNANGALIANTIMBUNANA - A'A0.12310.079818.7502.38591.0294A'0.13140.03A' - BA'0.13140.0331.5006.01490.4977B0.25050.0016B - B'B0.25050.001641.0007.32060.4982B'0.10660.0227B' - CB'0.10660.02279.0001.02780.2498C0.12180.0328C - DC0.12180.032850.0005.44001.2850D0.09580.0186D - ED0.09580.018650.0004.86000.9550E0.09860.0196TOTAL27.04924.5150Jadi jumlah total volume galian saluran rencana = 27.0492 m3Sedangkan jumlah total volume timbunan saluran rencana = 4.5150 m3

Sheet4