Skip to main content

Advertisement

SpringerLink
Log in

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

  • Original Paper
  • Published:
Arabian Journal of Geosciences Aims and scope Submit manuscript

Abstract

Spreadsheet-based programming has become a worldwide computational tool and a powerful platform for executing scientific calculations in different engineering disciplines. The inherent advantage of spreadsheets exists in integrated storage and the ability to manipulate matrices along with wide-ranging mathematical calculations, plotting, and diagrammatic presentation. This paper presents a user-friendly and interactive spreadsheet program “AVA-anisotropy” to characterize the primary P-wave amplitude versus incident angle (AVA) responses in vertically transverse isotropic (VTI), horizontally transverse isotropic (HTI), and orthorhombic media. The set of Rüger’s equations for isotropic, VTI, HTI, and orthorhombic media are solved to describe the seismic energy partitioning at an anisotropic interface. The spreadsheet program has three main sections: basic concepts, data input, and AVA modeling for anisotropic media. The interactive data input and on-screen mathematical and graphic presentation of the spreadsheet enables the students to have an in-depth examination of the effects of changing input data and the resulting model. This greatly helps them in understanding the energy partitioning in anisotropic medium.

This is a preview of subscription content, log in via an institution to check access.

Access this article

Log in via an institution

Price excludes VAT (USA)
Tax calculation will be finalised during checkout.

Instant access to the full article PDF.

Institutional subscriptions

Fig. 1
Fig. 2
Fig. 3
Fig. 4

Similar content being viewed by others

References

  • Ahmad M, Ahmed N, Khalid P, Badar MA, Akram S, Hussain M, Anwar MA, Mahmood A, Ali S, Rehman AU (2019) Impact of pore fluid heterogeneities on angle-dependent reflectivity in poroelastic layers: a study driven by seismic petrophysics. Geomech Eng 17:343–354

    Google Scholar 

  • Ahmed N, Khalid P, Shafi HMB, Connolly P (2017) DHI evaluation by combining rock physics simulation and statistical techniques for fluid identification of Cambrian-to-Cretaceous clastic reservoirs in Pakistan. Acta Geophys 65:991–1007

    Article  Google Scholar 

  • Aliane N (2009) Use of spreadsheets in control engineering education. Int J Eng Educ 25:1–10

    Google Scholar 

  • Antar MA, Mokheimer EM (2002) Spreadsheet modelling of transient three-dimensional heat conduction with various standard boundary conditions. Int J Mech Eng Educ 30:17–34

    Article  Google Scholar 

  • Auken E, Nebel L, Sorensen K, Breiner M, Pellerin L, Christensen NB (2002) EMMA—a geophysical training and education tool for electromagnetic modeling and analysis. J Environ Eng Geophys 7:57–68

    Article  Google Scholar 

  • Bangash AA, Khan KA, Akhter G (2017) Spreadsheets for understanding seismic energy partitioning equations. Comput Appl Eng Educ 25:441–448

    Article  Google Scholar 

  • Berger WH (1997) Experimenting with Ice-Age cycles in a spreadsheet. J Geosci Educ 45:428–439

    Article  Google Scholar 

  • Bermúdez M, Puertas J, Cea L (2019) Introducing Excel spreadsheet calculations and numerical simulations with professional software into an undergraduate hydraulic engineering course. Comput Appl Eng Educ 28:193–206

    Article  Google Scholar 

  • Boyd TM, Romig PR (1997) Cross-disciplinary education: the use of interactive case studies to teach geophysical exploration. Comput Geosci 23:593–599

    Article  Google Scholar 

  • Chehab A, El-Hajj A, Al-Husseini M, Artail H (2004) Spreadsheet applications in electrical engineering: a review. Int J Eng Educ 20:902–908

    Google Scholar 

  • Cooke BA (1997) Some ideas for using spreadsheets in physics. Phys Educ 32:80–87

    Article  Google Scholar 

  • Costa MI, Barroso J, Soares S (2012) Signal processing interpolation educational workbench. Comput Appl Eng Educ 20:356–363

    Article  Google Scholar 

  • Crampin S (1981) Review of wave motion in anisotropic and cracked elastic-media. Wave Motion 3:343–391

    Article  Google Scholar 

  • Crampin S (1984) An introduction to wave propagation in anisotropic media. Geophys J Roy Astr Soc 76:17–28

    Article  Google Scholar 

  • Crampin S (1985) Evidence for aligned cracks in the earth’s crust. First Break 3:12–15

    Google Scholar 

  • Diamond D, Hanratty VCA (1997) Spreadsheet applications in chemistry using Microsoft Excel, Wiley, ISBN 0471140872

  • Dinçkal Ç (2018) Design of integral spreadsheet calculator for engineering applications. Comput Appl Eng Educ 26:1159–1172

    Article  Google Scholar 

  • Durbin JM (2002) The benefits of combining computer technology and traditional teaching methods in large enrollment geoscience classes. J Geosci Educ 50:56–63

    Article  Google Scholar 

  • Dutch SI (1991) Geochemical calculations using spreadsheets. J Geosci Educ 39:127–132

    Google Scholar 

  • El-Fadel M, Bsat R, Adada M (2004) Use of spreadsheets in environmental education: an application for solid waste management. Int J Eng Educ 20:909–919

    Google Scholar 

  • Fu TT (2003) Applications of computer simulation in mechanism teaching. Comput Appl Eng Educ 11:156–165

    Article  Google Scholar 

  • Graham I (1987) The application of spreadsheets to data analysis in biology. J Biol Educ 21:51–56

    Article  Google Scholar 

  • Hegazy T, Ersahin T (2001) Simplified spreadsheet solutions. II: overall schedule optimization. J Constr Eng Manage 127:469–475

    Article  Google Scholar 

  • Heyen G, Kalitventzeff B (1999) Spreadsheet based teaching aids in chemical engineering education. Comput Chem Educ 23:S629

    Google Scholar 

  • Holm PE (1988) Triangular plots and spreadsheet software. J Geosci Educ 36:157–159

    Google Scholar 

  • Huelsman LR (1984) Electrical engineering applications of microcomputer spreadsheets analysis programs. IEEE Trans E-27:86–92

    Google Scholar 

  • Kabalan KY, El-Hajj A, Diab H, Fakhreddine S (1997) Analog computer simulation using spreadsheets. Simulation 68:101–106

    Article  Google Scholar 

  • Khan KA, Ahmed N (2016) TICalc - a transverse isotropic calculator for computing reflection coefficients based on Rüger equations. Geophys Res J 2:66–70

    Google Scholar 

  • Khan KA, Akhtar G (2015) Computer-based experiments for learning seismic signal processing concepts. Comput Appl Eng Educ 23:959–966

    Article  Google Scholar 

  • Khan KA, Akhtar G, Ahmed Z, Khan MA, Naveed A (2006) Wavelets—a computer based training tool for seismic signal processing. Pak J Hydrocarbon Res 16:37–43

    Google Scholar 

  • Khan KA, Anees A, Ahmed N (2015) An educational tool for Zoeppritz equations and their various approximations. Geophys Res J 1:49–54

    Google Scholar 

  • Kim AS, Park C, Park S (2003) Development of Web-Based Engineering Numerical Software (WENS) using MATLAB: applications to linear algebra. Comput Appl Eng Educ 11:67–73

    Article  Google Scholar 

  • Klasner JS, Crockett JJ, Horton KB (1992) Hands-on teaching through a student field project in applied geophysics. J GeosciEduc 40:53–61

    Google Scholar 

  • Larrieu TL (1995) Basin analysis with a spreadsheet. J Geosci Educ 43:107–113

    Google Scholar 

  • McDonal JH (2014) Handbook of Biological Statistics. Rutgers Cooperative Extension, New Brunswick, NJ

    Google Scholar 

  • Mokheimer EM, Antar MA (2002) On the use of spreadsheet in heat conduction analysis. Int J Mech Eng Educ 28:113–139

    Article  Google Scholar 

  • Niazkar M, Afzali SH (2015) Application of Excel spreadsheet in engineering education. First International & Fourth National Conference on Engineering Education Shiraz University, Iran 10-12 November 2015

  • Oke S (2004) Spreadsheet applications in engineering education: a review. Int J Eng Educ 20:893–901

    Google Scholar 

  • Rao ND (1984) Typical applications of microcomputer spreadsheets to electrical engineering problems. IEEE Trans E-27:237–242

    Google Scholar 

  • Renshaw CE, Taylor HA, Reynolds CH (2018) Impact of computer-assisted instruction in hydrogeology on critical-thinking skills. J Geosci Educ 46:274–279

    Article  Google Scholar 

  • Rüger A (1997) P-wave reflection coefficients for transversely isotropic models with vertical and horizontal axis of symmetry. Geophysics 62:713–722

    Article  Google Scholar 

  • Rüger A (1998) Variation of P-wave reflectivity with offset and azimuth in anisotropic media. Geophysics 63:935–947

    Article  Google Scholar 

  • Schumack MR (1996) Teaching heat transfer using automotive-related case studies with a spreadsheet analysis package. Int J Mech Eng Educ 25:177–196

    Article  Google Scholar 

  • Shuey RT (1985) A simplification of the Zoeppritz equations. Geophysics 50:609–614

    Article  Google Scholar 

  • Tabor G (2004) Teaching computational fluid dynamics using spreadsheets. Int J Mech Eng Educ 32:31–54

    Article  Google Scholar 

  • Thomsen L (1986) Weak elastic anisotropy. Geophysics 51:1954–1966

    Article  Google Scholar 

  • Thomsen L (1988) Reflection seismology over azimuthally anisotropic media. Geophysics 53:304–313

    Article  Google Scholar 

  • Thomsen L (1993) Weak anisotropic reflections, in offset dependent reflectivity, Castagna J. Society of Exploration Geophysicists, USA, Backus MEds, pp 103–114

    Google Scholar 

  • Thomsen L (1995) Elastic anisotropy due to aligned cracks in porous rock. Geophys Prospect 43:805–829

    Article  Google Scholar 

  • Tsvankin I (1996) Effective parameters and reflection seismic signatures for orthorhombic anisotropy, Center for Wave Phenomena report CWP-199

  • Tsvankin I (1997) Reflection moveout and parameter estimation for horizontal transverse isotropy. Geophysics 62:614–629

    Article  Google Scholar 

  • Xu S, Wu X, Huang X, Yin H (2005) Evaluation of anisotropic rock properties in sedimentary rocks from well logs. Offshore Technology Conference held in Houston TX USA 2–5 May 2005

  • Zoeppritz K (1919) Erdbebenwellen VIIIB, On the reflection and propagation of seismic waves. Gottinger Nachrichten 1:66–84

    Google Scholar 

Download references

Author information

Authors and Affiliations

  1. Department of Energy Resources, University of Stavanger, 4036, Stavanger, Norway

    Nisar Ahmed & Wiktor Waldemar Weibull

  2. Institute of Geology, University of the Punjab, Lahore, 54590, Pakistan

    Mubasher Ahmad & Perveiz Khalid

  3. K-tron Research Inc., 347-A Westridge I, Rawalpindi, Pakistan

    Khalid Amin Khan

Authors
  1. Nisar Ahmed
    View author publications

    You can also search for this author in PubMed Google Scholar

  2. Mubasher Ahmad
    View author publications

    You can also search for this author in PubMed Google Scholar

  3. Khalid Amin Khan
    View author publications

    You can also search for this author in PubMed Google Scholar

  4. Wiktor Waldemar Weibull
    View author publications

    You can also search for this author in PubMed Google Scholar

  5. Perveiz Khalid
    View author publications

    You can also search for this author in PubMed Google Scholar

Corresponding author

Correspondence to Khalid Amin Khan.

Ethics declarations

Conflict of interest

The authors declare that they have no competing interests.

Additional information

Responsible Editor: Narasimman Sundararajan

Rights and permissions

Reprints and permissions

About this article

Check for updates. Verify currency and authenticity via CrossMark

Cite this article

Ahmed, N., Ahmad, M., Khan, K.A. et al. AVA-anisotropy: spreadsheets program to model the variation of P-wave reflectivity with angle in VTI, HTI, and orthorhombic media. Arab J Geosci 14, 875 (2021). https://doi.org/10.1007/s12517-021-07028-z

Download citation

  • Received:

  • Accepted:

  • Published:

  • DOI: https://doi.org/10.1007/s12517-021-07028-z

Keywords

Search

Navigation