Spreadsheets for understanding seismic energy partitioning equations

Spreadsheets have come a long way and have become a universal computational tool and a powerful platform for performing scientific and engineering calculations. Their inherent strength lies in integrated storage and manipulation of data, together with a wide range of calculations, charting, and graphics presentation capabilities. These facilities make them ideal tools for prototyping mathematical equations and algorithms that can be adapted for instructional purposes to improve the quality of engineering education. This paper presents a set of spreadsheets that help in understanding the mathematical details behind the Zoeppritz equations and their various approximations that describe the partitioning of seismic wave energy at a planar interface between two homogeneous isotropic and elastic layers of rock. © 2017 Wiley Periodicals, Inc. Comput Appl Eng Educ 25:441–448, 2017; View this article online at wileyonlinelibrary.com/journal/cae; DOI 10.1002/cae.21811

[1]  G. C. Smith,et al.  Detection of gas in sandstone reservoirs using AVO analysis: A 3-D seismic case history using the Geostack technique , 1994 .

[2]  David Gray,et al.  Bridging the Gap - Using AVO to Detect Changes in Fundamental Elastic Constants , 1999 .

[3]  G. H. F. Gardner,et al.  FORMATION VELOCITY AND DENSITY—THE DIAGNOSTIC BASICS FOR STRATIGRAPHIC TRAPS , 1974 .

[4]  W. J. Ostrander.  Plane Wave Reflection Coefficients For Gas Sands At Nonnormal Angles of Incidence , 1982 .

[5]  G. C. Smith,et al.  Weighted stacking for rock property estimation and detection of gas , 1987 .

[6]  S. A. OKE.  Spreadsheet Applications in Engineering Education: A Review* , 2004 .

[7]  Steven R. Rutherford,et al.  Amplitude-versus-offset variations in gas sands , 1989 .

[8]  Ali Chehab,et al.  Spreadsheet applications in electrical engineering: A review , 2004 .

[9]  Steven I. Dutch.  Geochemical Calculations Using Spreadsheets , 1991 .

[10]  Jan Herrington,et al.  Moving from an instructivist to a constructivist multimedia learning environment , 2000 .

[11]  Wolfgang H Berger.  Experimenting with ice-age cycles in a spreadsheet , 1997 .

[12]  John Samuel Klasner,et al.  Hands-On Teaching through a Student Field Project in Applied Geophysics. , 1992 .

[13]  Ali El-Hajj,et al.  Analog Computer Simulation Using Spreadsheets , 1997, Simul..

[14]  Lu Xiuli,et al.  Elastic Parameter AVO Approximations And Their Applications , 2008 .

[15]  Nutakki D. Rao.  Typical Applications of Microcomputer Spreadsheets to Electrical Engineering Problems , 1984, IEEE Transactions on Education.

[16]  R. Bortfeld,et al.  APPROXIMATIONS TO THE REFLECTION AND TRANSMISSION COEFFICIENTS OF PLANE LONGITUDINAL AND TRANSVERSE WAVES , 1961 .

[17]  Lawrence P. Huelsman.  Electrical Engineering Applications of Microcomputer Spreadsheet Analysis Programs , 1984, IEEE Transactions on Education.

[18]  Richard Verm,et al.  Lithology, color-coded seismic sections; the calibration of AVO crossplotting to rock properties , 1995 .

[19]  Tarek Hegazy,et al.  Simplified Spreadsheet Solutions. II: Overall Schedule Optimization , 2001 .

[20]  Paul G. Richards,et al.  Quantitative Seismology: Theory and Methods , 1980 .

[21]  Paul Eric Holm.  Triangular Plots and Spreadsheet Software. , 1988 .

[22]  Mark Schumack.  Teaching Heat Transfer Using Automotive-Related Case Studies with a Spreadsheet Analysis Package , 1997 .

[23]  O. Koefoed,et al.  Reflection and Transmission Coefficients for Plane Longitudinal Incident Waves , 1962 .

[24]  Mohamed A. Antar,et al.  Spreadsheet Modelling of Transient Three Dimensional Heat Conduction with Various Standard Boundary Conditions , 2002 .

[25]  W. J. Ostrander.  Plane-wave reflection coefficients for gas sands at nonnormal angles of incidence , 1984 .

[26]  Mohamed A. Antar,et al.  On the Use of Spreadsheets in Heat Conduction Analysis , 2000 .

[27]  R. Bsat,et al.  Use of Spreadsheets in Environmental Education: an Application for Solid Waste Management* , 2004 .

[28]  R. T. Shuey,et al.  A simplification of the Zoeppritz equations , 1985 .

[29]  C. G. Knott.  III. Reflexion and refraction of elastic waves, with seismological applications , 1899 .

[30]  O. Koefoed,et al.  On the effect of poisson's ratios of rock strata on the reflection coefficients of plane waves , 1955 .

[31]  Boris Kalitventzeff,et al.  Spreadsheet based teaching aids in chemical engineering education , 1999 .

[32]  Theodore Lloyd Larrieu.  Basin Analysis with a Spreadsheet , 1995 .