PM1實測地質(zhì)剖面數(shù)據(jù)計算表,,,,,,,,,,,,,,,,,,,,,,,

,,,,,,,,,,,,,,,,,,,,,X:,,

項目（礦區(qū)）：剖面位置：,,,,,,,,,,,,,,,,,,,起點坐標：,,Y:,,

,,,,,,,,,,,,,,,,,,,,,H:,,

"導線

編號",,,"導線方位角

（°）","斜距

（m）

（L）","傾向（°）

","傾角（°）

（α）","坡度

（°）

（β）","巖層走

向與剖

面線夾

角（°）（γ）",y=sinα·cosβ·sinγ±cosα·sinβ,,,,,,,,"導線端點

高差h=

L·sinβ","導線平距m=

L·cosβ",分層,,,"分層

累計

厚度

（m）",備注

,,,,,,,,,sinα,cosβ,sinγ,積,±,cosα,sinβ,積,,,編號,"斜長

Lf(m)","真厚

度（m）

D=Lf

·y",,

,,,,,,,,,,,,,,,,,,,,,,,,

,,,,,,,,,,,,,,,,,,,,,,,,

,,,,,,,,,,,,,,,,,,,,,,,,

0,—,1,125,45,145,41,1,70,0.66,1.00,0.94,0.62,+,0.75,0.02,0.01,0.79,44.99,1,45,28.33,28.33,∈2q2

,,,125,5,147,31,1,68,0.52,1.00,0.93,0.48,+,0.86,0.02,0.01,0.09,5.00,2,5,2.46,2.46,∈3g

1,—,2,146,40,132,38,1,76,0.62,1.00,0.97,0.60,+,0.79,0.02,0.01,0.70,39.99,3,40,24.44,26.90,

,,,146,10,147,34,1,89,0.56,1.00,1.00,0.56,+,0.83,0.02,0.01,0.17,10.00,4,10,5.73,32.64,

2,—,3,123,5,147,34,12,66,0.56,0.98,0.91,0.50,+,0.83,0.21,0.17,1.04,4.89,4,5,3.36,36.00,

,,,123,27,147,34,12,66,0.56,0.98,0.91,0.50,+,0.83,0.21,0.17,5.61,26.41,5,27,18.15,54.14,

3,—,4,105,39,147,34,0,48,0.56,1.00,0.74,0.42,+,0.83,0.00,0.00,0.00,39.00,5,39,16.21,70.35,

4,—,5,122,44,147,34,-15,65,0.56,0.97,0.91,0.49,+,0.83,-0.26,-0.21,-11.39,42.50,5,44,12.10,82.45,

5,—,6,118,5,155,35,-5,53,0.57,1.00,0.80,0.46,+,0.82,-0.09,-0.07,-0.44,4.98,5,5,1.92,84.37,

,,,118,45,155,35,-5,53,0.57,1.00,0.80,0.46,+,0.82,-0.09,-0.07,-3.92,44.83,6,45,17.32,17.32,∈3-4l

6,—,7,110,50,155,35,-10,45,0.57,0.98,0.71,0.40,+,0.82,-0.17,-0.14,-8.68,49.24,6,50,12.86,30.18,

7,—,8,124,50,155,35,0,59,0.57,1.00,0.86,0.49,+,0.82,0.00,0.00,0.00,50.00,6,50,24.58,54.76,

8,—,9,104,50,155,35,-2,39,0.57,1.00,0.63,0.36,+,0.82,-0.03,-0.03,-1.74,49.97,6,50,16.61,71.37,

9,—,10,135,7,175,47,0,50,0.73,1.00,0.77,0.56,+,0.68,0.00,0.00,0.00,7.00,6,7,3.92,75.29,

,,,135,43,175,47,0,50,0.73,1.00,0.77,0.56,+,0.68,0.00,0.00,0.00,43.00,7,43,24.09,99.38,

10,—,11,126,50,175,47,1,41,0.73,1.00,0.66,0.48,+,0.68,0.02,0.01,0.87,49.99,7,50,24.58,123.97,

11,—,12,160,50,175,47,-1,75,0.73,1.00,0.97,0.71,+,0.68,-0.02,-0.01,-0.87,49.99,8,50,34.72,158.69,

12,—,13,168,33,175,47,0,83,0.73,1.00,0.99,0.73,+,0.68,0.00,0.00,0.00,33.00,8,33,23.95,182.64,

13,—,14,135,50,160,50,1,65,0.77,1.00,0.91,0.69,+,0.64,0.02,0.01,0.87,49.99,9,50,35.27,217.91,

14,—,15,155,50,160,50,5,85,0.77,1.00,1.00,0.76,+,0.64,0.09,0.06,4.36,49.81,9,50,40.81,258.72,

15,—,16,153,39,160,50,1,83,0.77,1.00,0.99,0.76,+,0.64,0.02,0.01,0.68,38.99,9,39,30.09,288.81,

16,—,17,140,50,160,50,-1,70,0.77,1.00,0.94,0.72,+,0.64,-0.02,-0.01,-0.87,49.99,9,50,35.43,324.24,

17,—,18,142,50,160,50,0,72,0.77,1.00,0.95,0.73,+,0.64,0.00,0.00,0.00,50.00,9,50,36.43,360.66,

18,—,19,112,50,160,50,1,42,0.77,1.00,0.67,0.51,+,0.64,0.02,0.01,0.87,49.99,9,50,26.19,386.85,

19,—,20,103,50,160,50,0,33,0.77,1.00,0.54,0.42,+,0.64,0.00,0.00,0.00,50.00,10,50,20.86,407.71,

20,—,21,104,50,160,50,0,34,0.77,1.00,0.56,0.43,+,0.64,0.00,0.00,0.00,50.00,10,50,21.42,429.13,

21,—,22,120,50,160,50,-11,50,0.77,0.98,0.77,0.58,+,0.64,-0.19,-0.12,-9.54,49.08,10,50,22.67,451.80,

22,—,23,120,50,160,50,3,50,0.77,1.00,0.77,0.59,+,0.64,0.05,0.03,2.62,49.93,10,50,30.98,482.78,

23,—,24,135,50,160,50,1,65,0.77,1.00,0.91,0.69,+,0.64,0.02,0.01,0.87,49.99,10,50,35.27,518.05,

24,—,25,119,21,160,42,1,49,0.67,1.00,0.75,0.50,+,0.74,0.02,0.01,0.37,21.00,11,21,10.88,528.93,

25,—,26,137,50,160,42,-1,67,0.67,1.00,0.92,0.62,+,0.74,-0.02,-0.01,-0.87,49.99,11,50,30.14,559.07,

26,—,27,128,4,160,42,0,58,0.67,1.00,0.85,0.57,+,0.74,0.00,0.00,0.00,4.00,12,4,2.27,561.34,

,,,128,46,160,42,0,58,0.67,1.00,0.85,0.57,+,0.74,0.00,0.00,0.00,46.00,12,46,26.10,587.44,

27,—,28,95,50,160,42,0,25,0.67,1.00,0.42,0.28,+,0.74,0.00,0.00,0.00,50.00,12,50,14.14,601.58,

28,—,29,102,50,160,42,0,32,0.67,1.00,0.53,0.35,+,0.74,0.00,0.00,0.00,50.00,12,50,17.73,619.31,

29,—,30,112,50,160,42,0,42,0.67,1.00,0.67,0.45,+,0.74,0.00,0.00,0.00,50.00,12,50,22.39,641.70,

30,—,31,122,50,160,42,1,52,0.67,1.00,0.79,0.53,+,0.74,0.02,0.01,0.87,49.99,12,50,27.01,668.71,

31,—,32,110,50,160,42,0,40,0.67,1.00,0.64,0.43,+,0.74,0.00,0.00,0.00,50.00,12,50,21.51,690.21,

32,—,33,118,38,160,42,0,48,0.67,1.00,0.74,0.50,+,0.74,0.00,0.00,0.00,38.00,12,38,18.90,709.11,

33,—,34,128,20,160,42,1,58,0.67,1.00,0.85,0.57,+,0.74,0.02,0.01,0.35,20.00,12,20,11.61,720.71,

,,,128,30,160,42,1,58,0.67,1.00,0.85,0.57,+,0.74,0.02,0.01,0.52,30.00,13,30,17.41,738.12,

34,—,35,104,46,160,42,1,34,0.67,1.00,0.56,0.37,+,0.74,0.02,0.01,0.80,45.99,13,46,17.81,755.93,

35,—,36,144,6,150,30,11,84,0.50,0.98,0.99,0.49,+,0.87,0.19,0.17,1.14,5.89,13,6,3.92,759.85,

,,,144,26,150,30,11,84,0.50,0.98,0.99,0.49,+,0.87,0.19,0.17,4.96,25.52,14,26,16.99,776.84,

36,—,37,138,35,150,30,7,78,0.50,0.99,0.98,0.49,+,0.87,0.12,0.11,4.27,34.74,14,35,20.68,797.52,

37,—,38,15,33,150,30,10,45,0.50,0.98,0.71,0.35,-,0.87,0.17,0.15,5.73,32.50,14,33,6.53,804.05,

38,—,39,117,27,150,30,15,57,0.50,0.97,0.84,0.41,+,0.87,0.26,0.22,6.99,26.08,14,27,16.99,821.04,

39,—,40,110,25,150,30,15,50,0.50,0.97,0.77,0.37,+,0.87,0.26,0.22,6.47,24.15,14,25,14.85,835.89,

40,—,41,90,27,150,30,11,30,0.50,0.98,0.50,0.25,+,0.87,0.19,0.17,5.15,26.50,14,27,11.09,846.98,

41,—,42,167,8,150,30,10,73,0.50,0.98,0.96,0.47,+,0.87,0.17,0.15,1.39,7.88,14,8,4.97,851.95,

42,—,43,126,50,150,30,13,66,0.50,0.97,0.91,0.45,+,0.87,0.22,0.19,11.25,48.72,15,50,31.99,883.94,

43,—,44,118,28,150,30,15,58,0.50,0.97,0.85,0.41,+,0.87,0.26,0.22,7.25,27.05,15,28,17.74,901.69,F16

44,—,45,85,39,150,30,6,25,0.50,0.99,0.42,0.21,+,0.87,0.10,0.09,4.08,38.79,15,39,11.73,913.41,F16

45,—,46,117,27,150,30,7,57,0.50,0.99,0.84,0.42,+,0.87,0.12,0.11,3.29,26.80,15,27,14.09,927.50,F16

46,—,47,98,17,116,67,10,72,0.92,0.98,0.95,0.86,+,0.39,0.17,0.07,2.95,16.74,15,17,15.81,943.31,F16

,,,98,12,116,67,10,72,0.92,0.98,0.95,0.86,+,0.39,0.17,0.07,2.08,11.82,16,12,11.16,954.47,F16

47,—,48,90,10,116,67,14,64,0.92,0.97,0.90,0.80,+,0.39,0.24,0.09,2.42,9.70,17,10,8.97,963.44,F16

,,,90,13,116,67,14,64,0.92,0.97,0.90,0.80,+,0.39,0.24,0.09,3.14,12.61,18,13,11.66,11.66,∈2q1

48,—,49,66,29,116,67,13,40,0.92,0.97,0.64,0.58,+,0.39,0.22,0.09,6.52,28.26,18,29,19.27,30.93,

49,—,50,64,29,120,50,11,34,0.77,0.98,0.56,0.42,+,0.64,0.19,0.12,5.53,28.47,18,29,15.75,46.68,

50,—,51,78,5,120,50,15,48,0.77,0.97,0.74,0.55,+,0.64,0.26,0.17,1.29,4.83,18,5,3.58,50.27,

,,,78,17,120,50,15,48,0.77,0.97,0.74,0.55,+,0.64,0.26,0.17,4.40,16.42,19,17,12.18,62.44,

,,,78,4,142,39,15,26,0.63,0.97,0.44,0.27,+,0.78,0.26,0.20,1.04,3.86,20,4,1.87,64.31,

51,—,52,90,13,142,39,12,38,0.63,0.98,0.62,0.38,+,0.78,0.21,0.16,2.70,12.72,21,13,7.03,71.34,

52,—,53,77,36,142,39,3,25,0.63,1.00,0.42,0.27,+,0.78,0.05,0.04,1.88,35.95,21,36,11.03,82.37,

53,—,54,60,18,142,39,12,8,0.63,0.98,0.14,0.09,+,0.78,0.21,0.16,3.74,17.61,21,18,4.45,86.82,

54,—,55,100,15,142,39,7,48,0.63,0.99,0.74,0.46,+,0.78,0.12,0.09,1.83,14.89,21,15,8.38,95.20,

55,—,56,54,19,117,52,12,27,0.79,0.98,0.45,0.35,+,0.62,0.21,0.13,3.95,18.58,22,19,9.08,104.28,

56,—,57,85,38,265,55,7,90,0.82,0.99,1.00,0.81,-,0.57,0.12,0.07,4.63,37.72,22,38,28.24,132.52,

57,—,58,90,11,265,55,0,85,0.82,1.00,1.00,0.82,+,0.57,0.00,0.00,0.00,11.00,22,11,8.98,141.50,

58,—,59,65,13,300,28,11,35,0.47,0.98,0.57,0.26,-,0.88,0.19,0.17,2.48,12.76,22,13,1.25,142.74,

59,—,60,75,35,300,28,0,45,0.47,1.00,0.71,0.33,+,0.88,0.00,0.00,0.00,35.00,23,35,11.62,154.36,

60,—,61,70,18,268,40,1,72,0.64,1.00,0.95,0.61,-,0.77,0.02,0.01,0.31,18.00,23,18,10.76,165.12,

61,—,62,87,16,268,40,13,89,0.64,0.97,1.00,0.63,-,0.77,0.22,0.17,3.60,15.59,24,16,7.26,172.38,

62,—,63,88,17,268,40,17,90,0.64,0.96,1.00,0.61,-,0.77,0.29,0.22,4.97,16.26,24,17,6.64,179.03,

63,—,64,125,16,268,40,15,53,0.64,0.97,0.80,0.50,-,0.77,0.26,0.20,4.14,15.45,24,16,4.76,183.79,

64,—,65,105,17,268,40,17,73,0.64,0.96,0.96,0.59,-,0.77,0.29,0.22,4.97,16.26,24,17,6.19,189.97,

65,—,66,137,10,268,40,2,41,0.64,1.00,0.66,0.42,-,0.77,0.03,0.03,0.35,9.99,24,10,3.95,193.92,

,,,137,27,268,40,2,41,0.64,1.00,0.66,0.42,-,0.77,0.03,0.03,0.94,26.98,25,27,10.66,204.58,

66,—,67,137,14,268,40,14,41,0.64,0.97,0.66,0.41,-,0.77,0.24,0.19,3.39,13.58,25,14,3.13,207.71,

67,—,68,120,50,133,31,0,77,0.52,1.00,0.97,0.50,+,0.86,0.00,0.00,0.00,50.00,25,50,25.09,232.80,

68,—,69,93,5,133,31,-8,50,0.52,0.99,0.77,0.39,+,0.86,-0.14,-0.12,-0.70,4.95,25,5,1.36,234.16,

,,,93,20,115,50,-8,68,0.77,0.99,0.93,0.70,+,0.64,-0.14,-0.09,-2.78,19.81,26,20,12.28,246.44,

,,,93,5,115,50,-8,68,0.77,0.99,0.93,0.70,+,0.64,-0.14,-0.09,-0.70,4.95,27,5,3.07,249.51,

69,—,70,107,50,115,50,-6,82,0.77,0.99,0.99,0.75,+,0.64,-0.10,-0.07,-5.23,49.73,27,50,34.36,280.80,

70,—,71,104,50,125,40,-3,69,0.64,1.00,0.93,0.60,+,0.77,-0.05,-0.04,-2.62,49.93,27,50,27.96,308.76,

71,—,72,104,50,125,40,1,69,0.64,1.00,0.93,0.60,+,0.77,0.02,0.01,0.87,49.99,27,50,30.67,339.43,

72,—,73,122,18,125,40,2,87,0.64,1.00,1.00,0.64,+,0.77,0.03,0.03,0.63,17.99,27,18,12.03,351.46,

73,—,74,105,50,125,40,-8,70,0.64,0.99,0.94,0.60,+,0.77,-0.14,-0.11,-6.96,49.51,27,50,24.58,376.03,

74,—,75,116,50,125,40,-5,81,0.64,1.00,0.99,0.63,+,0.77,-0.09,-0.07,-4.36,49.81,27,50,28.28,404.32,

75,—,76,117,50,142,49,-3,65,0.75,1.00,0.91,0.68,+,0.66,-0.05,-0.03,-2.62,49.93,27,50,32.44,436.76,

76,—,77,114,22,142,49,0,62,0.75,1.00,0.88,0.67,+,0.66,0.00,0.00,0.00,22.00,27,22,14.66,451.42,

77,—,78,106,50,142,49,-6,54,0.75,0.99,0.81,0.61,+,0.66,-0.10,-0.07,-5.23,49.73,27,50,26.93,478.35,

78,—,79,130,6,142,49,-4,78,0.75,1.00,0.98,0.74,+,0.66,-0.07,-0.05,-0.42,5.99,27,6,4.14,482.49,

,,,130,31,142,49,-4,78,0.75,1.00,0.98,0.74,+,0.66,-0.07,-0.05,-2.16,30.92,28,31,21.41,21.41,∈2q2

79,—,80,110,41,126,34,-9,74,0.56,0.99,0.96,0.53,+,0.83,-0.16,-0.13,-6.41,40.50,28,41,16.45,37.86,

80,—,81,142,37,98,26,-1,46,0.44,1.00,0.72,0.32,+,0.90,-0.02,-0.02,-0.65,36.99,28,37,11.09,48.95,

81,—,82,138,1.5,98,26,5,50,0.44,1.00,0.77,0.33,+,0.90,0.09,0.08,0.13,1.49,28,1.5,0.62,49.57,

,,,138,8.5,132,24,5,84,0.41,1.00,0.99,0.40,+,0.91,0.09,0.08,0.74,8.47,29,8.5,4.10,4.10,∈3a1

82,—,83,105,18,132,24,-26,63,0.41,0.90,0.89,0.33,+,0.91,-0.44,-0.40,-7.89,16.18,29,18,-1.35,2.76,

83,—,84,140,31,132,24,-4,82,0.41,1.00,0.99,0.40,+,0.91,-0.07,-0.06,-2.16,30.92,29,31,10.48,13.24,

84,—,85,116,25,132,24,-9,74,0.41,0.99,0.96,0.39,+,0.91,-0.16,-0.14,-3.91,24.69,29,25,6.08,19.32,

85,—,86,120,20,132,24,-6,78,0.41,0.99,0.98,0.40,+,0.91,-0.10,-0.10,-2.09,19.89,30,20,6.00,25.32,

86,—,87,121,35,132,24,-7,79,0.41,0.99,0.98,0.40,+,0.91,-0.12,-0.11,-4.27,34.74,30,35,9.97,35.30,

87,—,88,112,20,132,24,-14,70,0.41,0.97,0.94,0.37,+,0.91,-0.24,-0.22,-4.84,19.41,30,20,3.00,38.29,

88,—,89,127,18,132,24,-20,85,0.41,0.94,1.00,0.38,+,0.91,-0.34,-0.31,-6.16,16.91,30,18,1.23,39.52,

89,—,90,78,38,120,24,-18,48,0.41,0.95,0.74,0.29,+,0.91,-0.31,-0.28,-11.74,36.14,30,38,0.20,0.20,∈3a2

,,,78,2,120,24,-18,48,0.41,0.95,0.74,0.29,+,0.91,-0.31,-0.28,-0.62,1.90,31,2,0.01,0.21,

90,—,91,110,22,120,24,-14,80,0.41,0.97,0.98,0.39,+,0.91,-0.24,-0.22,-5.32,21.35,31,22,3.69,3.90,

91,—,92,113,27,120,24,-25,83,0.41,0.91,0.99,0.37,+,0.91,-0.42,-0.39,-11.41,24.47,31,27,-0.55,3.35,

92,—,93,98,32,120,24,-13,68,0.41,0.97,0.93,0.37,+,0.91,-0.22,-0.21,-7.20,31.18,31,32,5.18,8.53,

93,—,94,82,40,125,20,-18,47,0.34,0.95,0.73,0.24,+,0.94,-0.31,-0.29,-12.36,38.04,32,40,-2.10,6.43,

94,—,95,113,10,125,20,-14,78,0.34,0.97,0.98,0.32,+,0.94,-0.24,-0.23,-2.42,9.70,32,10,0.97,7.41,

,,,113,35,125,20,-14,78,0.34,0.97,0.98,0.32,+,0.94,-0.24,-0.23,-8.47,33.96,33,35,3.40,10.81,

,,,113,5,125,20,-14,78,0.34,0.97,0.98,0.32,+,0.94,-0.24,-0.23,-1.21,4.85,34,5,0.49,11.30,

95,—,96,103,37,125,20,-5,68,0.34,1.00,0.93,0.32,+,0.94,-0.09,-0.08,-3.22,36.86,34,37,8.66,19.95,

96,—,97,133,42,125,20,-8,82,0.34,0.99,0.99,0.34,+,0.94,-0.14,-0.13,-5.85,41.59,34,42,8.59,28.55,

97,—,98,110,28,125,20,3,75,0.34,1.00,0.97,0.33,+,0.94,0.05,0.05,1.47,27.96,34,28,10.61,39.16,

98,—,99,143,29,125,20,-1,72,0.34,1.00,0.95,0.33,+,0.94,-0.02,-0.02,-0.51,29.00,34,29,8.96,48.12,

99,—,100,87,32,129,14,-1,48,0.24,1.00,0.74,0.18,+,0.97,-0.02,-0.02,-0.56,32.00,34,32,5.21,53.33,

,,,87,15,129,14,-1,48,0.24,1.00,0.74,0.18,+,0.97,-0.02,-0.02,-0.26,15.00,35,15,2.44,2.44