Spreadsheets for understanding seismic energy partitioning equations

Abstract

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 http://www.wileyonlinelibrary.com/journal/cae; DOI

AVA-anisotropy: spreadsheets program to model the variation of P-wave reflectivity with angle in VTI, HTI, and orthorhombic media

“…Nowadays the spreadsheet models are virtually applied in almost every field of science and engineering like physics (Cooke 1997), chemistry (Diamond and Hanratty 1997), biological sciences (Graham 1987), statistics (McDonal 2014, mechanical (Schumack 1996;Mokheimer and Antar 2002;Antar and Mokheimer 2002), electrical (Huelsman 1984;Rao 1984;Chehab et al 2004;Kabalan et al 1997), civil (Hegazy and Ersahin 2001), chemical (Heyen andKalitventzeff 1999), andenvironmental (El-Fadel et al 2004) engineering. Similarly, they are widely used in geological sciences and geotechnical engineering (Holm 1988;Dutch 1991;Klasner et al 1992;Larrieu 1995;Berger 1997;Bangash et al 2017). Similarly, Dinçkal (2018) design an algorithm named integral spreadsheet calculator that uses both Gauss Legendre and Newton-Cotes formulations that can be used to compute numerically and analytically the true percent relative error for evaluation purposes in the engineering discipline.…”

“…These programs are quite interactive, but unlike spreadsheets, they do not show the values of all the internal variables. Bangash et al (2017) published the spreadsheet programs to solve the Zoeppritz Equation (Zoeppritz 1919) and its approximations to calculate the P converted P-wave reflection coefficients but did not consider the anisotropy in the porous media caused by heterogeneous material. Rüger (1997Rüger ( , 1998 presented mathematical relations to compute the P-wave reflection amplitudes as a function of incident angles in anisotropic (HTI, VTI, and orthorhombic) media.…”

Detection of saliva morphine using surface‐enhanced Raman spectroscopy combined with immunochromatographic assay

“…In comparison, the spreadsheet programs are equipped in most computers and can be incorporated with other programming languages and add‐ins. Spreadsheets have been used for data analysis in various fields, such as finance, management, education, and physical sciences . Most of those applications used Excel add‐in “Solver” or Visual Basic for Applications that need complex programming.…”