{"text_format":"2","workbook":"xls","n_sheets":3,"sheets":["main","equations","Sheet3"],"not_rendered":{"charts":0,"images":4,"macros":0,"external_links":0,"defined_names":0,"comments":0,"pivot_tables":0},"unopened":[],"bounds":{"document_bytes":16777216,"sheet_cells":100000,"run_cost":"one","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","formulas":"cached_only"}

{"sheet":"main","index":0,"n_rows":36,"n_cols":15,"rows_kept":36,"cut":false,"hidden":false,"merged":[],"flags":["formulas_cached_only"]}
["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 ",{"$nulls":8},"T -raw"]
["strike","dip","rake","RHRrake","trend","plunge",null,"tanR","cosD","sinD","sinR","tan(180-R)","b","180-b","trend"]
[287,81,17,163,104.26181182770318,16.78445914660324,null,-0.3057306814586602,0.15643446504023092,0.9876883405951378,0.2923717047227366,-0.3057306814586602,2.738188172296818,177.26181182770318,464.2618118277032]
[30,79,50,130,197.18894687768577,48.761319000393506,null,-1.19175359259421,0.19080899537654492,0.981627183447664,0.766044443118978,-1.19175359259421,12.811053122314235,167.18894687768577,197.18894687768577]
[20,30,20,160,182.50475924300022,9.84655193983408,null,-0.36397023426620256,0.8660254037844387,0.49999999999999994,0.3420201433256689,-0.36397023426620256,17.49524075699978,162.50475924300022,182.50475924300022]
[90,30,40,40,126.00521481878653,18.7472372510375,null,0.8390996311772799,0.8660254037844387,0.49999999999999994,0.6427876096865393,-0.8390996311772804,36.005214818786534,143.99478518121347,126.00521481878653]
[90,30,60,60,146.3099324740202,25.658906273255273,null,1.7320508075688767,0.8660254037844387,0.49999999999999994,0.8660254037844386,-1.7320508075688783,56.30993247402021,123.6900675259798,146.3099324740202]
[]
[]
[]
[{"$nulls":10},"Equations:"]
[{"$nulls":9},"T = S+b = S+(arctan(tanR*cosD))"]
[{"$nulls":9},"P = arcsin(sinD*sinR)"]
{"$rows_empty":9}
[{"$nulls":11},"Eric Nelson"]
[{"$nulls":11},"Colorado School of Mines"]
[]
["Cell equations:"]

{"sheet":"equations","index":1,"n_rows":3,"n_cols":15,"rows_kept":3,"cut":false,"hidden":false,"merged":[],"flags":["formulas_cached_only"]}
["S","D ","R ","RHR-R","T","P ",{"$nulls":8},"T -raw"]
["strike","dip","rake","RHRrake","trend","plunge",null,"tanR","cosD","sinD","sinR","tan(180-R)","b","180-b","trend"]
[0,30,80,100,101.50839336582231,29.498704231103652,null,-5.671281819617711,0.8660254037844387,0.49999999999999994,0.984807753012208,5.671281819617707,78.49160663417769,101.50839336582231,101.50839336582231]

{"sheet":"Sheet3","index":2,"n_rows":0,"n_cols":0,"rows_kept":0,"cut":false,"hidden":false,"merged":[],"flags":["formulas_cached_only"]}