Skip to main content
U.S. flag

An official website of the United States government

An apparent dip calculator for spreadsheets

February 25, 2022

This report and spreadsheet calculator contain Microsoft Excel-based equations that are useful in structural geology to calculate plunge or apparent dip when measuring lineations on a plane. The spreadsheet allows users to measure the trend or the plunge of a lineation and calculate the corresponding unknown value of trend or plunge. The spreadsheet provides the user with two options:

Option 1: Calculates the plunge of a lineation from the measured strike and dip of a plane and the measured trend of a lineation.

Option 2: Calculates two potential trends of a lineation from the measured strike and dip of a plane and a measured plunge of a lineation. The user can decide which trend is appropriate for their data.

Publication Year 2022
Title An apparent dip calculator for spreadsheets
DOI 10.3133/tm7C28
Authors Gregory J. Walsh
Publication Type Report
Publication Subtype USGS Numbered Series
Series Title Techniques and Methods
Series Number 7-C28
Index ID tm7C28
Record Source USGS Publications Warehouse
USGS Organization Florence Bascom Geoscience Center