
Excel VBA for Physicists
A Primer
Bernard V. Liengme(Author)
Morgan & Claypool Publishers
Published on 7. December 2016
Book
Hardback
91 pages
978-1-64327-903-9 (ISBN)
Description
This book is both an introduction and a demonstration of how Visual Basic for Applications (VBA) can greatly enhance Microsoft Excel(R) 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(R) workbooks are available for each chapter and there is nothing to buy or install.
More details
Series
Language
English
Place of publication
San Rafael
United States
Product notice
sewn/stitched
Cloth over boards
Dimensions
Height: 254 mm
Width: 178 mm
Thickness: 6 mm
Weight
381 gr
ISBN-13
978-1-64327-903-9 (9781643279039)
Copyright in bibliographic data and cover images is held by Nielsen Book Services Limited or by the publishers or by their respective licensors: all rights reserved.
Schweitzer Classification
Person
Bernard V Liengme attended Imperial College London for his undergraduate and postgraduate degrees; he held post-doctoral fellowships at Carnegie-Mellon University and the University of British Columbia. He has conducted extensive research in surface chemistry and the Mossbauer effect. He has been at St Francis Xavier University in Canada since 1968 as a Professor, Associate Dean, and Registrar, as well as teaching chemistry and computer science. He currently lectures part-time on business information systems. Bernard is also the author of other successful books: COBOL by Command (1996), A Guide to Microsoft Excel for Scientists and Engineers (now in its fourth edition), A Guide to Microsoft Excel for Business and Management (now in its second edition), Modelling Physics with Microsoft Excel(R) (2014), and SMath for Physics: A Primer (2015).
Content
- Preface
- Acknowledgements
- Author biography
- Ch1. Introduction
- Ch2. Variables, Dim statements, and data types
- Ch3. Structured programming
- Ch4. The Excel object model
- Ch5. Working with add-ins
- Ch6. Numerical integration
- Ch7. Numerical methods for differential equations
- Ch8. Finding roots
- Acknowledgements
- Author biography
- Ch1. Introduction
- Ch2. Variables, Dim statements, and data types
- Ch3. Structured programming
- Ch4. The Excel object model
- Ch5. Working with add-ins
- Ch6. Numerical integration
- Ch7. Numerical methods for differential equations
- Ch8. Finding roots