Excelª VBA for physicists :a primer /

---

"Version: 20161101"--Title page verso."A Morgan & Claypool publication as part of IOP Concise Physics"--Title page verso.Includes bibliographical references.Preface -- 1. Introduction -- 1.1. Preparation -- 1.2. Demonstrating a simple function -- 1.3. Saving a macro-enabled workbook -- 1.4. Using constants and VB functions -- 1.5. User-defined array function -- 1.6. Notes on VBA functions -- 1.7. A simple subroutine -- 1.8. Linking an image to a subroutine -- 1.9. Recording a macro -- 1.10. Finding a home for macros -- 1.11. Typographical matters2. Variables, Dim statements, and data types -- 2.1. Naming variables -- 2.2. The Dim statement -- 2.3. The major reason for variable declarations -- 2.4. Declarations in function headers and for constants -- 2.5. Data types -- 2.6. A second reason for variable declarations -- 2.7. Dimensioning arrays -- 2.8. The Set statement -- 2.9. The With ... End With structure3. Structured programming -- 3.1. Branching structures (If and Select Case) -- 3.2. Looping structures (For ... Next and Do ... While/Until) -- 3.3. Some further examples4. The Excel object model -- 4.1. Examples of properties, methods and events -- 4.2. The Range object properties -- 4.3. Range object methods -- 4.4. WorksheetFunction object -- 4.5. Workbook and worksheet events -- 4.6. Code for sending email5. Working with add-ins -- 5.1. Creating an add-in -- 5.2. Installation -- 5.3. Using the add-in -- 5.4. Making changes to the add-in -- 5.5. Viewing worksheets -- 5.6. Protecting the add-in -- 5.7. Reversing everything6. Numerical integration -- 6.1. The trapezoid approximation -- 6.2. The Simpson 1/3 approximation -- 6.3. An aside -- 6.4. Monte Carlo integration -- 6.5. Gaussian and Romberg integration7. Numerical methods for differential equations -- 7.1. Euler's method -- 7.2. The Runge-Kutta fourth-order method -- 7.3. Simultaneous OEDs -- 7.4. Example of a system of two OEDs -- 7.5. Higher order OEDs -- 7.6. R-L circuit8. Finding roots -- 8.1. The bisection method -- 8.2. The successive iteration method -- 8.3. Root finding with Solver -- 8.4. Using range names.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.Suitable for physicists and other scientists and engineers, including students.Also available in print.Mode of access: World Wide Web.System requirements: Adobe Acrobat Reader.Bernard V. Liengme is a Retired Professor of Chemistry and Lecturer in Information Systems of St Francis Xavier University in Nova Scotia, Canada. He is the author of several Microsoft Excelª guides for business and scientists and engineers, and two other titles published with IOP ebooks. Bernard has been awarded the Microsoft Most Valued Professional award in Excelª in eight consecutive years.Title from PDF title page (viewed on December 7, 2016).

---

Availability

No copy data

Detail Information

Series Title

-

Call Number

-

Publisher

: .,

Collation

1 online resource (various pagings) :color illustrations.

Language

English

ISBN/ISSN

9781681744612

Classification

005.13/3

Content Type

-

Media Type

-

Carrier Type

-

Edition

-

Subject(s)

SCIENCE / Physics / Mathematical & Computational.
Mathematical physics.
SCIENCE / Physics / General.
Physics.
Physics
Applied physics.

Specific Detail Info

-

Statement of Responsibility

Bernard V. Liengme.

Other version/related

File Attachment

Comments

---

You must be logged in to post a comment