Excel with VBA Contributor(s): Hauser, Francis (Author) |
|
ISBN: 151182008X ISBN-13: 9781511820080 Publisher: Createspace Independent Publishing Platform OUR PRICE: $23.74 Product Type: Paperback Published: June 2015 |
Additional Information |
BISAC Categories: - Computers | Programming Languages - Visual Basic |
Physical Information: 0.4" H x 8.5" W x 11.02" (0.98 lbs) 186 pages |
Descriptions, Reviews, Etc. |
Publisher Description: This book was born when dynamic systems analyst Francis Hauser, PhD, discovered the power of this well-integrated programming platform. He realized how helpful this would have been to him as a student and as a practicing engineer and university teacher. He decided "this has got to be told." From this book, the reader can expect to be writing computer programs using Microsoft Office Excel with VBA. This book defines and demonstrates VBA syntax incrementally using example programs that range from common math problems like finding roots of polynomials to more advanced problems like finding eigenvalues of general matrices using the QR algorithm. Example programs with complete code listings cover the following topics: Roots of polynomials Linear algebraic equations Runge-Kutta numerical integration 3D object rotation Newton-Raphson for nonlinear equations Linearizing equations State variable form of equations Eigenvalues via the QR algorithm Transfer functions via the QR algorithm Frequency response Root locus Dantzig's Simplex Algorithm Discrete Fourier transform These code listings are explained by in depth tutorials on the topics, and include checkout methods learned from experience. This guidebook will help you as an engineer, mathematician, or student using nothing more than the Microsoft Office suite that many are already familiar with. The book is for PCs and Macs. |