ISBN-10:
151182008X
ISBN-13:
9781511820080
Pub. Date:
Publisher:
Excel with VBA

Excel with VBA

by Francis Hauser

Paperback

$24.99
Choose Expedited Shipping at checkout for delivery by Thursday, October 28

Overview

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.


Related collections and offers

Product Details

ISBN-13: 9781511820080
Publisher: CreateSpace Publishing
Publication date: 06/29/2015
Pages: 186
Product dimensions: 8.50(w) x 11.00(h) x 0.40(d)

About the Author

Francis D. Hauser, PhD, earned a doctorate in electrical engineering from the University of Denver in 1972. He is a dynamic systems analyst in the motions and control of launch and reentry vehicles; multibody spacecraft; fixed- and rotor-wing aircraft; large, high-speed oceangoing watercraft; land craft; and wind-driven turbines. He is also a university and college lecturer in graduate, undergraduate, and continuing education courses on conventional, modern, and space vehicle control, general optimization theory, Newtonian mechanics (statics and dynamics), linear algebra, and Fourier analysis.


When he realized that he could do a complete autopilot stability analysis of a large flexible launch vehicle right on his laptop using Microsoft Office with Excel/VBA, he decided he must share his discovery, and thus his book Excel with VBA, written for engineers and mathematicians, was born.

Customer Reviews