{"text_format":"1","workbook":"xlsx","n_sheets":2,"sheets":["Strike-Dip Calculator","Formulas-ReadOnly"],"not_rendered":{"charts":1,"images":9,"macros":1,"external_links":0,"defined_names":9,"comments":0,"pivot_tables":0},"unopened":[],"bounds":{"document_bytes":16777216,"sheet_cells":100000,"rows_first":2000,"rows_last":500,"rows_between":2000,"halvings":0,"cell_chars":16384,"cell_head_chars":4096},"cells_cut":0,"cells_raw":0,"read":"whole","date_system":"1900"}

{"sheet":"Strike-Dip Calculator","index":0,"n_rows":12,"n_cols":29,"rows_kept":12,"cut":false,"hidden":false,"merged":[]}
["This worksheet calculates the strike and dip, given 3 points on a plane.",null,null,null,null,null,null,null,"Last modified: Dec. 4, 2011 by LEH",null,null,null,null,null,null,null,"This chart shows the strike of the feature"]
["The calculation finds the pole to the plane by computing the cross product of two vectors constructed between 3 pts on a plane."]
["A chart for plotting the strike line is given at  right."]
["You can copy-paste the formulas in Columns 11-17 for additional points that you add.",null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Output values of strike and dip."]
["Row 10 provides an example…",null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Strike is consistent with right hand rule"]
["Or use the macros to read/write Global Mapper text files...",null,null,null,null,"UTM Coordinates",null,null,null,null,null,null,null,null,null,"Strike vector has been corrected for pole orientation"]
["Paste coordinates of your points for a geologic feature below in columns 2-10.",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Data for writing to files…"]
[null,"Point 1",null,null,"Point 2",null,null,"Point 3",null,null,"Calculated Values",null,null,null,null,null,null,"Strike vector",null,null,null,null,null,"UTM Coordinates"]
["ID","Easting, m","Northing, m","Elevation, m","Easting, m","Northing, m","Elevation, m","Easting, m","Northing, m","Elevation, m","U1 i ","-U2 j","U3 k ","easting","northing","Strike, degrees","Dip, degrees","start x","end x","start y","end y",{"$f":"P9","v":"Strike, degrees"},{"$f":"Q9","v":"Dip, degrees"},"Easting,m","Northing, m","Elevation, m","Point ID","Dot Product of vectors","Problem Pts"]
["Example Row",591506.17299999995,3719214.8160000001,88.915999999999997,591529.92500000005,3719201.4339999999,102.35,591533.60600000003,3719187.3829999999,95.625,{"$f":"((C10-F10)*(J10-G10)-(I10-F10)*(D10-G10))","v":-278.75508400115268},{"$f":"-((B10-E10)*(J10-G10)-(H10-E10)*(D10-G10))","v":-209.18275400040096},{"$f":"((B10-E10)*(I10-F10)-(H10-E10)*(C10-F10))","v":284.48021000024534},{"$f":"IF(M10<0,L10,-L10)","v":209.18275400040096},{"$f":"IF(M10>0,K10,-K10)","v":-278.75508400115268},{"$f":"DEGREES(IF(N10>=0,ACOS(O10/(N10^2+O10^2)^0.5),2*PI()-ACOS(O10/(N10^2+O10^2)^0.5)))","v":143.11478800111533},{"$f":"DEGREES(ASIN((K10^2+L10^2)^0.5/(K10^2+L10^2+M10^2)^0.5))","v":50.776377602088893},0,{"$f":"N10/(N10^2+O10^2)^0.5","v":0.60021380727162854},0,{"$f":"O10/(N10^2+O10^2)^0.5","v":-0.79983959989518916},{"$f":"P10","v":143.11478800111533},{"$f":"Q10","v":50.776377602088893},{"$f":"AVERAGE(B10,E10,H10)","v":591523.2346666666},{"$f":"AVERAGE(C10,F10,I10)","v":3719201.2109999997},{"$f":"AVERAGE(D10,G10,J10)","v":95.630333333333326},null,0.1,{"$f":"IF(1-ABS(AB10)<0.1,\"HEY\",\"\")","v":""}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,291,29,591136.79700000002,3719108.253,85.954999999999998,"PC02"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,275,29,591234.10499999998,3719198.4419999998,93.311000000000007,"PC03"]

{"sheet":"Formulas-ReadOnly","index":1,"n_rows":24,"n_cols":24,"rows_kept":24,"cut":false,"hidden":false,"merged":[]}
[]
["Formulas used in the strike dip calculator"]
["Given three points: P1 (x1, y1, z1), P2 (x2, y2, z2), and P3 (x3, y3, z3). Let the vector from P2 to P1 be V1, and the vector from P2 to P3 be V2. "]
["Find the pole to the plane, then determine strike and dip from the components of the pole."]
["V1",null," "]
["V2"]
["Cross product"]
["Components of pole"]
[]
[null,null,null,null,null,null,null,null,null,"If the sign of U3 is negative, we need to change the direction of the strike line, and we do so by changing the sign of (E,N) to (-E,-N). "]
["Strike line"]
["Bearing b of strike",null," "]
[null,null,". "]
["Azimuth of strike",null,"if 0<= b <=180, b* 180/p; else 360 - b*180/p"]
[]
[]
["Dip angle",null," "]
[null,null,". "]
[]
[]
["Paste coordinates of your points for a geologic feature below in columns 2-10."]
[null,"Point 1",null,null,"Point 2","UTM Coordinates",null,"Point 3",null,null,"Calculated Values",null,null,null,null,null,null,"Strike vector",null,null,null,"Centroid of Plane, UTM Coordinates"]
["Geologic Feature ID","Easting, m","Northing, m","Elevation, m","Easting, m","Northing, m","Elevation, m","Easting, m","Northing, m","Elevation, m","U1 i ","-U2 j","U3 k ","easting","northing","Strike, degrees","Dip, degrees","start x","end x","start y","end y","Easting,m","Northing, m","Elevation, m"]
["sd-1",591506.17299999995,3719214.8160000001,88.915999999999997,591529.92500000005,3719201.4339999999,102.35,591533.60600000003,3719187.3829999999,95.625,{"$f":"((C24-F24)*(J24-G24)-(I24-F24)*(D24-G24))","v":-278.75508400115268},{"$f":"-((B24-E24)*(J24-G24)-(H24-E24)*(D24-G24))","v":-209.18275400040096},{"$f":"((B24-E24)*(I24-F24)-(H24-E24)*(C24-F24))","v":284.48021000024534},{"$f":"IF(M24>0,-L24,L24)","v":209.18275400040096},{"$f":"IF(M24>0,K24,-K24)","v":-278.75508400115268},{"$f":"DEGREES(IF(N24>=0,ACOS(O24/(N24^2+O24^2)^0.5),2*PI()-ACOS(O24/(N24^2+O24^2)^0.5)))","v":143.11478800111533},{"$f":"DEGREES(ASIN((K24^2+L24^2)^0.5/(K24^2+L24^2+M24^2)^0.5))","v":50.776377602088893},0,{"$f":"N24/(N24^2+O24^2)^0.5","v":0.60021380727162854},0,{"$f":"O24/(N24^2+O24^2)^0.5","v":-0.79983959989518916},{"$f":"AVERAGE(B24,E24,H24)","v":591523.2346666666},{"$f":"AVERAGE(C24,F24,I24)","v":3719201.2109999997},{"$f":"AVERAGE(D24,G24,J24)","v":95.630333333333326}]