An edition of Excel® VBA for physicists (2016)

Excel® VBA for physicists

a primer

by

  • 1 Currently reading
Cover of: Excel® VBA for physicists by Bernard V. Liengme, Bernard V. Liengme
Preview
Borrow Listen

My Reading Lists:

Create a new list

Check-In

×Close
Add an optional check-in date. Check-in dates are used to track yearly reading goals.
Today
Notes
  • 1 Currently reading
Notes

Check nearby libraries

Buy this book

Last edited by ImportBot
February 27, 2022 | History
Edit
An edition of Excel® VBA for physicists (2016)

Excel® VBA for physicists

a primer

by

  • 1 Currently reading

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.

Publish Date
Publisher
Morgan & Claypool Publishers
Language
English

Check nearby libraries

Buy this book

Previews available in: English

Subjects

Physics, Data processing, Mathematical Physics, Applied Physics, SCIENCE, General, Mathematical & Computational, Visual Basic, Microsoft Excel (Computer file), Microsoft visual basic (computer program)
Edition Availability
Cover of: Excel® VBA for physicists
Excel® VBA for physicists: a primer
2016, Morgan & Claypool Publishers
in English

Add another edition?

Book Details

Table of Contents

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 matters.
2. 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 structure.
3. Structured programming
3.1. Branching structures (If and Select Case)
3.2. Looping structures (For ... Next and Do ... While/Until)
3.3. Some further examples.
4. 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 email.
5. 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 everything.
6. 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 integration.
7. 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 circuit.
8. Finding roots
8.1. The bisection method
8.2. The successive iteration method
8.3. Root finding with Solver
8.4. Using range names.

Edition Notes

"Version: 20161101"--Title page verso.

"A Morgan & Claypool publication as part of IOP Concise Physics"--Title page verso.

Title from PDF title page (viewed on December 7, 2016).

Includes bibliographical references.

Access restricted to Ryerson students, faculty and staff.

Suitable for physicists and other scientists and engineers, including students.

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.

Published in
San Rafael [California] (40 Oak Drive, San Rafael, CA, 94903, USA)
Series
IOP concise physics, IOP concise physics
Other Titles
Excel® Visual Basic for applications for physicists :

Classifications

Dewey Decimal Class
005.13/3
Library of Congress
QC52 .L544 2016eb, QC52

The Physical Object

Pagination
1 online resource (1 volume (various pagings))

ID Numbers

Open Library
OL36621972M
Internet Archive
excelvbaforphysi0000lien
ISBN 10
1681744619, 1681744635, 1681744600
ISBN 13
9781681744612, 9781681744636, 9781681744605
OCLC/WorldCat
965604951

Source records

Internet Archive item record
Better World Books record
Better World Books record
Promise Item

Community Reviews (0)

Feedback?
No community reviews have been submitted for this work.

Lists

This work does not appear on any lists.

History

Download catalog record: RDF / JSON
February 27, 2022 Edited by ImportBot import existing book
January 2, 2022 Created by ImportBot import new book