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.

基于电子表格的编程已成为一种全球计算工具和一个强大的平台，可以在不同的工程学科中执行科学计算。电子表格的固有优势在于集成存储以及处理矩阵以及广泛的数学计算，绘图和图形表示的能力。本文介绍了一种用户友好的交互式电子表格程序“ AVA各向异性”，以表征垂直横观各向同性（VTI），水平横观各向同性（HTI）和正交各向异性介质中的主P波振幅与入射角（AVA）响应。求解了各向同性，VTI，HTI和正交各向异性介质的Rüger方程组，以描述各向异性界面处的地震能量分配。电子表格程序包含三个主要部分：基本概念，数据输入和各向异性介质的AVA建模。电子表格的交互式数据输入以及屏幕上的数学和图形表示形式使学生能够深入研究更改输入数据和生成的模型的影响。这极大地帮助他们了解各向异性介质中的能量分配。