This exercise should be on excel. exercise 1.4 I used 10 different strike and dip
3. From the poles to bedding that you calculated for your measurements in exer- cise 1.4 in Chapter 1, calculate the mean pole vector and its uncertainty (Eqn 2.12). You should recognize the table below; they are the same problems as in Week 1 of the course. The table below lists a series of orientations. Planes are given in az- imuth format and lines in trend, plunge format. Asterisks show missing values; *** is a missing azimuth or bearing, and ** is a missing plunge or dip. Some of the val- ues are redundant: for example, once you know the true dip and dip direction, you also know the strike and dip. Datum Strike & Dip of Plane True Dip (T&P) Apparent Dip(s) (T&P) 1 *** 050, ***** 090, 25 2 *** *** *** ** 159, 34 and 270, 43 3 *** ** ** 010, 48 321, ** and 090,* The formula for the rake in cell B5 is just: 1 2 Line: 3 Plane: 4 5 rake - Trend or strike Plunge or Dip cos(alpha) cos(beta) cos(gamma) magnitude 182.1 30.3 -0.8628 -0.0316 0.5045 53 37 0.6018 0.7986 0.0000 123.0 Figure 2.12 Spreadsheet for calculating the rake of a line in a plane. Note that the direction cosines in row 3 are for a line with a trend of 053 and a plunge of 00. ... not what we want at all. F (cos(gamma) G (Magnitude) SIN(RADIANS(C2)) SQRT(D2^2 + E2*2 + F2*2) row(s) D (cos(alpha)) COS(RADIANS(B2)) 2-6 *COS(RADIANS(C2)) 8 SUM(D2:06) 9 D8/5 11 D9/$G$9 Table 2.2 E cos(beta)) SIN(RADIANS(B2)) *COS (RADIANS(C2)) SUM(E2:E6) E8/5 E9/$G$9 SUM(F2:56) F8/5 F9/$G$9 SORT(D8^2 + E8^2 + F8*2) SQRT(D9-2 + E9-2 + F9-2) SQRT(D11*2 + E11^2 + F11-2) To get the trend of the mean vector in row 11, column B, we need to use a conditional statement (i.e., if... then... else...) because we have to check the sign of cosa as described above. The formula for the trend is: =IF(D11>=0, DEGREES(ATAN(E11/D11)), DEGREES(ATAN(E11/D11))+180) 3. From the poles to bedding that you calculated for your measurements in exer- cise 1.4 in Chapter 1, calculate the mean pole vector and its uncertainty (Eqn 2.12). You should recognize the table below; they are the same problems as in Week 1 of the course. The table below lists a series of orientations. Planes are given in az- imuth format and lines in trend, plunge format. Asterisks show missing values; *** is a missing azimuth or bearing, and ** is a missing plunge or dip. Some of the val- ues are redundant: for example, once you know the true dip and dip direction, you also know the strike and dip. Datum Strike & Dip of Plane True Dip (T&P) Apparent Dip(s) (T&P) 1 *** 050, ***** 090, 25 2 *** *** *** ** 159, 34 and 270, 43 3 *** ** ** 010, 48 321, ** and 090,* The formula for the rake in cell B5 is just: 1 2 Line: 3 Plane: 4 5 rake - Trend or strike Plunge or Dip cos(alpha) cos(beta) cos(gamma) magnitude 182.1 30.3 -0.8628 -0.0316 0.5045 53 37 0.6018 0.7986 0.0000 123.0 Figure 2.12 Spreadsheet for calculating the rake of a line in a plane. Note that the direction cosines in row 3 are for a line with a trend of 053 and a plunge of 00. ... not what we want at all. F (cos(gamma) G (Magnitude) SIN(RADIANS(C2)) SQRT(D2^2 + E2*2 + F2*2) row(s) D (cos(alpha)) COS(RADIANS(B2)) 2-6 *COS(RADIANS(C2)) 8 SUM(D2:06) 9 D8/5 11 D9/$G$9 Table 2.2 E cos(beta)) SIN(RADIANS(B2)) *COS (RADIANS(C2)) SUM(E2:E6) E8/5 E9/$G$9 SUM(F2:56) F8/5 F9/$G$9 SORT(D8^2 + E8^2 + F8*2) SQRT(D9-2 + E9-2 + F9-2) SQRT(D11*2 + E11^2 + F11-2) To get the trend of the mean vector in row 11, column B, we need to use a conditional statement (i.e., if... then... else...) because we have to check the sign of cosa as described above. The formula for the trend is: =IF(D11>=0, DEGREES(ATAN(E11/D11)), DEGREES(ATAN(E11/D11))+180)
