Welcome to the University of rizona Dept. of Geosciences
Reflection Seismology Program

Spreadsheets, etc.



Home
Up
Spreadsheets, etc.
Links

This area is Under Construction!

elastic4.xls    Excel spreadsheet to calculate various elastic-parameter values based on entry of density and any two elastic-parameter values.

zoeprtz4-raj.xls    Excel spreadsheet to calculate reflection and transmission coefficients for P- and S-waves up to the critical angle.

zoepplot.xls    Excel spreadsheet showing numerical results from calculations of reflection and transmission coefficients as functions of angle of incidence from 0 to 90 degrees.  This spreadsheet contains no formulas, but the data can be used to plot example reflection and transmission coefficients (amplitude versus angle of incidence) for a particular boundary.

reflect-t-vs-x-dip.xls  Excel spreadsheet to calculate travel times as a function of source-receiver distance and create a simple plot of the reflection travel-time curve.  This spreadsheet allows input of dip to see the effect of non-horizontal boundaries.

t-x--dip.xls Excel spreadsheet to calculate and plot travel times (t - x) and t2 - x2 plots.  When the reflecting boundary is not dipping, the t2 - x2 plot is a single straight line, the slope of which gives the reciprocal of the velocity2.  If the boundary is dipping, the t - x plot is asymmetric, and the t2 - x2 plot shows two branches.

Fourier-Definitions-2006.nb  Mathematica notebook showing basic definitions of Fourier series and Fourier transforms used in digital signal processing.  This notebook requires MathReader, a free software application available from Wolfram Resources, Inc. (http://www.wolfram.com/products/mathreader/) or a working version of Mathematica.  The same information is contained in the PDF file:
Fourier-Definitions-2006.pdf, which is viewable using Adobe Acrobat Reader.

FTNotes-04.nb Mathematica notebook showing settings for "Fourier Parameters" appropriate for signal processing when using the "FourierTransform" and "InverseFourierTransform" commands in Mathematica.  (Requires Mathematica or MathReader).

Delta-shift.nb  Mathematica notebook showing that a time shift results in a linear phase shift.  (Requires Mathematica or MathReader).

Autocorr-PowerSpec.nb  Mathematica notebook showing that the autocorrelation of a function is the same as the transform of its power spectrum.  (Requires Mathematica or MathReader).

Autocorr-seismogram.nb (1.25 Mb)  Mathematica notebook that explores the convolutional relationship between a random reflectivity function and a wavelet to form a seismogram.  It also considers the estimation of the wavelet spectrum based on the autocorrelation of the seismogram.  (Requires Mathematica or MathReader).