Structural Geology Spreadsheets

CommonPlane.xlsm: Calculates the strike and dip of a
structural plane given two linear attitudes that lie in the plane.
(macroenabled 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. (macroenabled 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. (macroenabled 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. (macroenabled 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. (macroenabled 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

SmartPhone QuickOffice versions of above spreadsheets

Rotation.xlsx

CommonPlane.xlsx

IntersectingPlanes.xlsx

ThreePoint.xlsx
