UNIVERSITY OF SOUTH ALABAMA

 Structural Geology Spreadsheets CommonPlane.xlsm: Calculates the strike and dip of a structural plane given two linear attitudes that lie in the plane. (macro-enabled 2010 Excel) http://www.usouthal.edu/geography/allison/GY403/CommonPlane.xlsm ThreePoint.xlsm: Calculates the strike and dip of a structural plane that contains 3 points of known location and elevation. Also calculates the hydraulic gradient if the 3 points are water table elevations. (macro-enabled 2010 Excel) http://www.usouthal.edu/geography/allison/GY403/ThreePoint.xlsm IntersectingPlanes.xlsm: Calculates the plunge and bearing of the intersection of 2 planar structures. (macro-enabled 2010 Excel) http://www.usouthal.edu/geography/allison/GY403/IntersectingPlanes.xlsm Rotation.xlsm: Calculates the new orientation of a line given a starting orientation, a rotational axis orientation, and the amount and sense of rotation. The algorithm may also be used to find the rotated orientation of a structural plane if the orientation of the pole to the plane is used as the starting orientation. (macro-enabled 2010 Excel) http://www.usouthal.edu/geography/allison/GY403/Rotation.xlsm SCslip.xlsm: Calculates the orientation of the slip vector given the attitude of the S and C planes measured from an S/C mylonite zone. (macro-enabled 2010 Excel) http://www.usouthal.edu/geography/allison/GY403/SCslip.xlsm SphericalRotation.xlsm: Calculates the new geodetic position of a point on Earth given the starting geodetic coordinates (latitude/longitude), and the geodetic coordinates of the rotation axis, and the amount and sense of the rotation. This algorithm is typically used to track tectonic plate position over time given an absolute pole of rotation. http://www.usouthal.edu/geography/allison/GY403/SphericalRotation.xlsm Alidade_Datasheet.xlsm: reduces data taken with a standard alidade (stadia intercept, crosshair, vertical angle) and converts to the vertical and horizontal offset from the instrument base position. http://www.usouthal.edu/geography/allison/GY403/ALIDADE_DataSheet.xlsm Smart-Phone QuickOffice versions of above spreadsheets Rotation.xlsx CommonPlane.xlsx IntersectingPlanes.xlsx ThreePoint.xlsx

 Web page maintained by: David Allison University of South Alabama