实测地质剖面数据计算表(有公式_自动计算)

1、计算人： 计算日期： 检查人：检查日期： 1 PM1PM1 实实 测测 地地 质质 剖剖 面面 数数 据据 计计 算算 表表X: 项目（矿区）： 剖面位置： 起点坐标： Y:H:导线编号导线方位角（）斜距（m）（L）倾向（）倾角（）（）坡度（）（）岩层走向与剖面线夹角（）（）y=sincossincossin导线端点高差h=Lsin导线平距m=Lcos分层分层累计厚度（m）备注sincossin积cossin积编号斜长Lf(m)真厚度（m）D=Lfy0112545145411700.661.000.940.62+0.750.020.010.7944.9914528.3328.332q21255

2、147311680.521.000.930.48+0.860.020.010.095.00252.462.463g1214640132381760.621.000.970.60+0.790.020.010.7039.9934024.4426.9014610147341890.561.001.000.56+0.830.020.010.1710.004105.7332.642312351473412660.560.980.910.50+0.830.210.171.044.89453.3636.00123271473412660.560.980.910.50+0.830.210.175.6126.4

3、152718.1554.143410539147340480.561.000.740.42+0.830.000.000.0039.0053916.2170.354 51224414734-15650.560.970.910.49+0.83-0.26-0.21-11.3942.5054412.1082.455 6118515535-5530.571.000.800.46+0.82-0.09-0.07-0.444.98551.9284.371184515535-5530.571.000.800.46+0.82-0.09-0.07-3.9244.8364517.3217.323-4l67110501

4、5535-10450.570.980.710.40+0.82-0.17-0.14-8.6849.2465012.8630.187812450155350590.571.000.860.49+0.820.000.000.0050.0065024.5854.76891045015535-2390.571.000.630.36+0.82-0.03-0.03-1.7449.9765016.6171.379 101357175470500.731.000.770.56+0.680.000.000.007.00673.9275.2913543175470500.731.000.770.56+0.680.0

5、00.000.0043.0074324.0999.3810 1112650175471410.731.000.660.48+0.680.020.010.8749.9975024.58123.9711 121605017547-1750.731.000.970.71+0.68-0.02-0.01-0.8749.9985034.72158.6912 1316833175470830.731.000.990.73+0.680.000.000.0033.0083323.95182.6413 1413550160501650.771.000.910.69+0.640.020.010.8749.99950

6、35.27217.9114 1515550160505850.771.001.000.76+0.640.090.064.3649.8195040.81258.7215 1615339160501830.771.000.990.76+0.640.020.010.6838.9993930.09288.8116 171405016050-1700.771.000.940.72+0.64-0.02-0.01-0.8749.9995035.43324.2417 1814250160500720.771.000.950.73+0.640.000.000.0050.0095036.43360.6618 19

7、11250160501420.771.000.670.51+0.640.020.010.8749.9995026.19386.8519 2010350160500330.771.000.540.42+0.640.000.000.0050.00105020.86407.7120 2110450160500340.771.000.560.43+0.640.000.000.0050.00105021.42429.1321 221205016050-11500.770.980.770.58+0.64-0.19-0.12-9.5449.08105022.67451.80计算人： 计算日期： 检查人：检查

8、日期： 2 PM1PM1 实实 测测 地地 质质 剖剖 面面 数数 据据 计计 算算 表表X: 项目（矿区）： 剖面位置： 起点坐标： Y:H:导线编号导线方位角（）斜距（m）（L）倾向（）倾角（）（）坡度（）（）岩层走向与剖面线夹角（）（）y=sincossincossin导线端点高差h=Lsin导线平距m=Lcos分层分层累计厚度（m）备注sincossin积cossin积编号斜长Lf(m)真厚度（m）D=Lfy22 2312050160503500.771.000.770.59+0.640.050.032.6249.93105030.98482.7823 2413550160501650

9、.771.000.910.69+0.640.020.010.8749.99105035.27518.0524 2511921160421490.671.000.750.50+0.740.020.010.3721.00112110.88528.9325 261375016042-1670.671.000.920.62+0.74-0.02-0.01-0.8749.99115030.14559.0726 271284160420580.671.000.850.57+0.740.000.000.004.001242.27561.3412846160420580.671.000.850.57+0.740

10、.000.000.0046.00124626.10587.4427 289550160420250.671.000.420.28+0.740.000.000.0050.00125014.14601.5828 2910250160420320.671.000.530.35+0.740.000.000.0050.00125017.73619.3129 3011250160420420.671.000.670.45+0.740.000.000.0050.00125022.39641.7030 3112250160421520.671.000.790.53+0.740.020.010.8749.991

11、25027.01668.7131 3211050160420400.671.000.640.43+0.740.000.000.0050.00125021.51690.2132 3311838160420480.671.000.740.50+0.740.000.000.0038.00123818.90709.1133 3412820160421580.671.000.850.57+0.740.020.010.3520.00122011.61720.7112830160421580.671.000.850.57+0.740.020.010.5230.00133017.41738.1234 3510

12、446160421340.671.000.560.37+0.740.020.010.8045.99134617.81755.9335 3614461503011840.500.980.990.49+0.870.190.171.145.891363.92759.85144261503011840.500.980.990.49+0.870.190.174.9625.52142616.99776.8436 3713835150307780.500.990.980.49+0.870.120.114.2734.74143520.68797.5237 3815331503010450.500.980.71

13、0.35-0.870.170.155.7332.5014336.53804.0538 39117271503015570.500.970.840.41+0.870.260.226.9926.08142716.99821.0439 40110251503015500.500.970.770.37+0.870.260.226.4724.15142514.85835.8940 4190271503011300.500.980.500.25+0.870.190.175.1526.50142711.09846.9841 4216781503010730.500.980.960.47+0.870.170.

14、151.397.881484.97851.9542 43126501503013660.500.970.910.45+0.870.220.1911.2548.72155031.99883.9443 44118281503015580.500.970.850.41+0.870.260.227.2527.05152817.74901.69F1644 458539150306250.500.990.420.21+0.870.100.094.0838.79153911.73913.41F163-4l计算人： 计算日期： 检查人：检查日期： 3 PM1PM1 实实 测测 地地 质质 剖剖 面面 数数 据

15、据 计计 算算 表表X: 项目（矿区）： 剖面位置： 起点坐标： Y:H:导线编号导线方位角（）斜距（m）（L）倾向（）倾角（）（）坡度（）（）岩层走向与剖面线夹角（）（）y=sincossincossin导线端点高差h=Lsin导线平距m=Lcos分层分层累计厚度（m）备注sincossin积cossin积编号斜长Lf(m)真厚度（m）D=Lfy45 4611727150307570.500.990.840.42+0.870.120.113.2926.80152714.09927.50F1646 4798171166710720.920.980.950.86+0.390.170.072.95

16、16.74151715.81943.31F1698121166710720.920.980.950.86+0.390.170.072.0811.82161211.16954.47F1647 4890101166714640.920.970.900.80+0.390.240.092.429.7017108.97963.44F1690131166714640.920.970.900.80+0.390.240.093.1412.61181311.6611.662q148 4966291166713400.920.970.640.58+0.390.220.096.5228.26182919.2730.

17、9349 5064291205011340.770.980.560.42+0.640.190.125.5328.47182915.7546.6850 517851205015480.770.970.740.55+0.640.260.171.294.831853.5850.2778171205015480.770.970.740.55+0.640.260.174.4016.42191712.1862.447841423915260.630.970.440.27+0.780.260.201.043.862041.8764.3151 5290131423912380.630.980.620.38+0

18、.780.210.162.7012.7221137.0371.3452 537736142393250.631.000.420.27+0.780.050.041.8835.95213611.0382.3753 546018142391280.630.980.140.09+0.780.210.163.7417.6121184.4586.8254 5510015142397480.630.990.740.46+0.780.120.091.8314.8921158.3895.2055 5654191175212270.790.980.450.35+0.620.210.133.9518.5822199

19、.08104.2856 578538265557900.820.991.000.81-0.570.120.074.6337.72223828.24132.5257 589011265550850.821.001.000.82+0.570.000.000.0011.0022118.98141.5058 5965133002811350.470.980.570.26-0.880.190.172.4812.7622131.25142.7459 607535300280450.471.000.710.33+0.880.000.000.0035.00233511.62154.3660 617018268

20、401720.641.000.950.61-0.770.020.010.3118.00231810.76165.1261 6287162684013890.640.971.000.63-0.770.220.173.6015.5924167.26172.3862 6388172684017900.640.961.000.61-0.770.290.224.9716.2624176.64179.0363 64125162684015530.640.970.800.50-0.770.260.204.1415.4524164.76183.7964 65105172684017730.640.960.96

21、0.59-0.770.290.224.9716.2624176.19189.9765 6613710268402410.641.000.660.42-0.770.030.030.359.9924103.95193.9213727268402410.641.000.660.42-0.770.030.030.9426.98252710.66204.58计算人： 计算日期： 检查人：检查日期： 4 PM1PM1 实实 测测 地地 质质 剖剖 面面 数数 据据 计计 算算 表表X: 项目（矿区）： 剖面位置： 起点坐标： Y:H:导线编号导线方位角（）斜距（m）（L）倾向（）倾角（）（）坡度（）（）岩

22、层走向与剖面线夹角（）（）y=sincossincossin导线端点高差h=Lsin导线平距m=Lcos分层分层累计厚度（m）备注sincossin积cossin积编号斜长Lf(m)真厚度（m）D=Lfy66 67137142684014410.640.970.660.41-0.770.240.193.3913.5825143.13207.7167 6812050133310770.521.000.970.50+0.860.000.000.0050.00255025.09232.8068 6993513331-8500.520.990.770.39+0.86-0.14-0.12-0.704.9

23、52551.36234.16932011550-8680.770.990.930.70+0.64-0.14-0.09-2.7819.81262012.28246.4493511550-8680.770.990.930.70+0.64-0.14-0.09-0.704.952753.07249.5169 701075011550-6820.770.990.990.75+0.64-0.10-0.07-5.2349.73275034.36280.8070 711045012540-3690.641.000.930.60+0.77-0.05-0.04-2.6249.93275027.96308.7671

24、 7210450125401690.641.000.930.60+0.770.020.010.8749.99275030.67339.4372 7312218125402870.641.001.000.64+0.770.030.030.6317.99271812.03351.4673 741055012540-8700.640.990.940.60+0.77-0.14-0.11-6.9649.51275024.58376.0374 751165012540-5810.641.000.990.63+0.77-0.09-0.07-4.3649.81275028.28404.3275 7611750

25、14249-3650.751.000.910.68+0.66-0.05-0.03-2.6249.93275032.44436.7676 7711422142490620.751.000.880.67+0.660.000.000.0022.00272214.66451.4277 781065014249-6540.750.990.810.61+0.66-0.10-0.07-5.2349.73275026.93478.3578 79130614249-4780.751.000.980.74+0.66-0.07-0.05-0.425.992764.14482.491303114249-4780.75

26、1.000.980.74+0.66-0.07-0.05-2.1630.92283121.4121.412q279 801104112634-9740.560.990.960.53+0.83-0.16-0.13-6.4140.50284116.4537.8680 81142379826-1460.441.000.720.32+0.90-0.02-0.02-0.6536.99283711.0948.9581 821381.598265500.441.000.770.33+0.900.090.080.131.49281.50.6249.571388.5132245840.411.000.990.40

27、+0.910.090.080.748.47298.54.104.103a182 831051813224-26630.410.900.890.33+0.91-0.44-0.40-7.8916.182918-1.352.7683 841403113224-4820.411.000.990.40+0.91-0.07-0.06-2.1630.92293110.4813.2484 851162513224-9740.410.990.960.39+0.91-0.16-0.14-3.9124.6929256.0819.3285 861202013224-6780.410.990.980.40+0.91-0

28、.10-0.10-2.0919.8930206.0025.3286 871213513224-7790.410.990.980.40+0.91-0.12-0.11-4.2734.7430359.9735.3087 881122013224-14700.410.970.940.37+0.91-0.24-0.22-4.8419.4130203.0038.292q1计算人： 计算日期： 检查人：检查日期： 5 PM1PM1 实实 测测 地地 质质 剖剖 面面 数数 据据 计计 算算 表表X: 项目（矿区）： 剖面位置： 起点坐标： Y:H:导线编号导线方位角（）斜距（m）（L）倾向（）倾角（）（）坡

29、度（）（）岩层走向与剖面线夹角（）（）y=sincossincossin导线端点高差h=Lsin导线平距m=Lcos分层分层累计厚度（m）备注sincossin积cossin积编号斜长Lf(m)真厚度（m）D=Lfy88 891271813224-20850.410.941.000.38+0.91-0.34-0.31-6.1616.9130181.2339.5289 90783812024-18480.410.950.740.29+0.91-0.31-0.28-11.7436.1430380.200.203a278212024-18480.410.950.740.29+0.91-0.31-0.

30、28-0.621.903120.010.2190 911102212024-14800.410.970.980.39+0.91-0.24-0.22-5.3221.3531223.693.9091 921132712024-25830.410.910.990.37+0.91-0.42-0.39-11.4124.473127-0.553.3592 93983212024-13680.410.970.930.37+0.91-0.22-0.21-7.2031.1831325.188.5393 94824012520-18470.340.950.730.24+0.94-0.31-0.29-12.3638

31、.043240-2.106.4394 951131012520-14780.340.970.980.32+0.94-0.24-0.23-2.429.7032100.977.411133512520-14780.340.970.980.32+0.94-0.24-0.23-8.4733.9633353.4010.81113512520-14780.340.970.980.32+0.94-0.24-0.23-1.214.853450.4911.3095 961033712520-5680.341.000.930.32+0.94-0.09-0.08-3.2236.8634378.6619.9596 9

32、71334212520-8820.340.990.990.34+0.94-0.14-0.13-5.8541.5934428.5928.5597 9811028125203750.341.000.970.33+0.940.050.051.4727.96342810.6139.1698 991432912520-1720.341.000.950.33+0.94-0.02-0.02-0.5129.0034298.9648.1299 100873212914-1480.241.000.740.18+0.97-0.02-0.02-0.5632.0034325.2153.33871512914-1480.241.000.740.18+0.97-0.02-0.02-0.2615.0035152.442.443a3100 10111818129145790.241.000.980.24+0.970.090.081.5717.9335185.788.2211832129145790.241.000.980.24+0.970.090.082.7931.88363210.2