An Apparent Dip Calculator for Spreadsheets

Techniques and Methods 7-C28
By:

Links

Abstract

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.

Suggested Citation

Walsh, G.J., 2022, An apparent dip calculator for spreadsheets: U.S. Geological Survey Techniques and Methods, book 7, chap. C28, 3 p., https://doi.org/10.3133/tm7C28.

ISSN: 2328-7055 (online)

Table of Contents

  • Abstract
  • Methods
  • References Cited
Publication type Report
Publication Subtype USGS Numbered Series
Title An apparent dip calculator for spreadsheets
Series title Techniques and Methods
Series number 7-C28
DOI 10.3133/tm7C28
Year Published 2022
Language English
Publisher U.S. Geological Survey
Publisher location Reston, VA
Contributing office(s) Florence Bascom Geoscience Center
Description Report: iii, 3 p.; Software
Larger Work Type Report
Larger Work Subtype USGS Numbered Series
Larger Work Title Section C: Computer programs in Book 7: Automated data processing and computations
Online Only (Y/N) Y
Additional Online Files (Y/N) Y
Google Analytic Metrics Metrics page
Additional publication details