Excel R Vba For Physicists

Excel VBA for Physicists

Excel VBA for Physicists

This book is both an introduction and a demonstration of how Visual Basic for Applications (VBA) can greatly enhance Microsoft Excel® by giving users the ability to create their own functions within a worksheet and to create subroutines to perform repetitive actions. The book is written so readers are encouraged to experiment with VBA programming with examples using fairly simple physics or non-complicated mathematics such as root finding and numerical integration. Tested Excel® workbooks are available for each chapter and there is nothing to buy or install.

Mathematical Methods for Physics using Microsoft EXCEL

In Mathematical Methods for Physics using Microsoft Excel, readers will investigate topics from classical to quantum mechanics, which are often omitted from the course work. Some of these topics include rocket propulsion, Rutherford scattering, precession and nutation of a top under gravity, parametric oscillation, relativistic Doppler effect, concepts of entropy, kinematics of wave packets, and boundary value problems and associated special functions as orthonormal bases. Recent topics such as the Lagrange point of the James Webb Space Telescope, a muon detector in relation to Cherenkov’s radiation, and information entropy and H-function are also discussed and analyzed. Additional interdisciplinary topics, such as self-avoiding random walks for polymer length and population dynamics, are also described. This book will allow readers to reproduce and replicate the data and experiments often found in physics textbooks, with a stronger foundation of knowledge. While investigating these subjects, readers will follow a step-by-step introduction to computational algorithms for solving differential equations for which analytical solutions are often challenging to find. For computational analysis, features of Microsoft Excel® including AutoFill, Iterative Calculation, and Visual Basic for Applications are useful to conduct hands-on projects. For the visualization of computed outcomes, the Chart output feature can be readily used. There are several first-time attempts on various topics introduced in this book such as 3D-like graphics using Euler’s angle and the behavior of wave functions of harmonic oscillators and hydrogen atoms near the true eigenvalues.