Scribd Logo
Upload

Welcome to Scribd!

  • 895 views

    Rake Plunge Calculator

    Uploaded by

    Rifqi Mochammad Suwondo
    This document contains a spreadsheet that calculates the plunge and trend of a line based on the strike and dip of the plane containing the line and the rake of the line. It provides the equations for calculating trend and plunge. Test data is included to demonstrate the calculations.

    Copyright:

    Attribution Non-Commercial (BY-NC)
    Download as XLS, PDF, TXT or read online from Scribd

    Rake Plunge Calculator

    Uploaded by

    Rifqi Mochammad Suwondo
    895 views3 pages
    This document contains a spreadsheet that calculates the plunge and trend of a line based on the strike and dip of the plane containing the line and the rake of the line. It provides the equations for calculating trend and plunge. Test data is included to demonstrate the calculations.

    Original Description:

    struktur geologi

    Copyright

    © Attribution Non-Commercial (BY-NC)

    Available Formats

    XLS, PDF, TXT or read online from Scribd

    Did you find this document useful?

    Is this content inappropriate?

    This document contains a spreadsheet that calculates the plunge and trend of a line based on the strike and dip of the plane containing the line and the rake of the line. It provides the equations for calculating trend and plunge. Test data is included to demonstrate the calculations.

    Copyright:

    Attribution Non-Commercial (BY-NC)
    Download as XLS, PDF, TXT or read online from Scribd
    Download as xls, pdf, or txt
    895 views3 pages

    Rake Plunge Calculator

    Uploaded by

    Rifqi Mochammad Suwondo
    This document contains a spreadsheet that calculates the plunge and trend of a line based on the strike and dip of the plane containing the line and the rake of the line. It provides the equations for calculating trend and plunge. Test data is included to demonstrate the calculations.

    Copyright:

    Attribution Non-Commercial (BY-NC)
    Download as XLS, PDF, TXT or read online from Scribd
    Download as xls, pdf, or txt
    of 3

    This spreadsheet calculates plunge and trend of a line knowing strike and dip of the plane containing the

    line, and the rake of the line. Strike is entered in right-hand-rule (RHR) format: strike azimuth (0-360) is 90 counterclockwise from dip direction. Rake is entered in 0-90 format in column D. Column E has RHR format rake: (0-180 measured from RHR strike), and is entered directly if RHR rake is <90 [examples lines 4 and 5 below], or is calculated (180-column C)[examples lines 1-3 below]. The data below show tests of the equations. Do not delete the top test line (it has the equations). S D R RHR-R T P T -raw strike dip rake RHRrake trend plunge tanR cosD sinD sinR tan(180-R) b 180-b trend 287 81 17 163 104 17 -0.31 0.16 0.99 0.29 -0.31 3 177 464 030 79 50 130 197 49 -1.19 0.19 0.98 0.77 -1.19 13 167 197 020 30 20 160 183 10 -0.36 0.87 0.50 0.34 -0.36 17 163 183 090 30 40 40 126 19 0.84 0.87 0.50 0.64 -0.84 36 144 126 090 30 60 60 146 26 1.73 0.87 0.50 0.87 -1.73 56 124 146

    Equations: T = S+b = S+(arctan(tanR*cosD)) P = arcsin(sinD*sinR)

    Eric Nelson Colorado School of Mines Cell equations:


    A B C D E F

    S D R RHR-R T P strike dip rake RHRrake trend plunge 0 30 80 =180-C3 =IF(O3>360,O3-360,O3) =DEGREES(ASIN(J3*K3))

    tanR cosD sinD sinR =TAN(RADIANS(D3)) =COS(RADIANS(B3)) =SIN(RADIANS(B3)) =SIN(RADIANS(D3))

    tan(180-R) b =TAN(RADIANS(180-D3)) =ABS(DEGREES(ATAN(H3*I3)))

    T -raw trend =180-M3 =IF(D3>90,A3+N3,A3+M3) 180-b

    You might also like