E-Book Excel for Scientists and Engineers - Numerical Methods

Introducing Visual Basic for Applications .................................... 1
Fundamentals of Programming with VBA .................................. 15
Worksheet Functions for Working with Matrices ....................... 57
Number Series .................................................. ........................... 69
Interpolation .................................................. .............................. 77
Differentiation .................................................. ........................... 99
Integration .................................................. ............................... 127
Roots of Equations .................................................. .................. 147
Numerical Integration of Ordinary Differential Equations
Part I: Initial Conditions .................................................. .......... 217
Numerical Integration of Ordinary Differential Equations
Part 11: Boundary Conditions .................................................. ... 245
Partial Differential Equations .................................................. .. 263
Nonlinear Regression Using the Solver ..................................... 313
Random Numbers and the Monte Carlo Method ....................... 341
Systems of Simultaneous Equations .......................................... 189
Linear Regression and Curve Fitting ......................................... 287
APPENDICES
Appendix 2 Shortcut Keys for VBA .................................................. ........... 387
.................................................. .... 389
Appendix 4 Some Equations for Curve Fitting ............................................. 409
Appendix 5 Engineering and Other Functions .............................................. 423
Appendix 6 ASCII Codes .................................................. ............................ 427
Appendix 7 Bibliography .................................................. ............................ 429
Appendix 8 Answers and Comments for End-of-Chapter Problems ............ 431
Appendix 1 Selected VBA Keywords .................................................. ......... 365
Appendix 3 Custom Functions Help File

JSF

“I would rather die standing up, than live life on my knees.”