Excel with VBA

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.

這本書是由動態系統分析師Francis Hauser博士創作的，他發現了這個完美整合的程式設計平台的威力。他意識到這對他作為一名學生、實踐工程師和大學教師來說有多麼有幫助，於是決定「必須將這個告訴大家」。

從這本書中，讀者可以期待使用Microsoft Office Excel和VBA來撰寫電腦程式。這本書以漸進的方式定義和演示VBA語法，使用的範例程式從常見的數學問題（如找到多項式的根）到更高級的問題（如使用QR算法找到一般矩陣的特徵值）。

完整的程式碼清單包含以下主題：

- 多項式的根
- 線性代數方程式
- Runge-Kutta數值積分
- 3D物體旋轉
- Newton-Raphson非線性方程式
- 方程式的線性化
- 方程式的狀態變量形式
- 使用QR算法求特徵值
- 使用QR算法求傳輸函數
- 頻率響應
- 根軌跡
- Dantzig的Simplex算法
- 離散傅立葉變換

這些程式碼清單通過深入的教程來解釋，並包含從經驗中學到的檢查方法。這本指南將幫助工程師、數學家或學生，只需使用眾多人已經熟悉的Microsoft Office套件即可。本書適用於PC和Mac。