home // Programming // Visual Basic
File Size: 355.89 KB
Last Download : 34 days 22 hours 59 minutes ago
Share this info:
Short Description: Advanced numerical methods. In the first part of this workbook you will learn how to implement the Euler and Runge-. Kutta solution in Visual Basic for ...
Content Inside: Advanced numerical methods In the first part of this workbook you will learn how to implement the Euler and Runge- Kutta solution in Visual Basic for Applications (VBA), and also a more advanced method of numerical integration. This will also develop the introduction you had to VBA macros in the second Excel workbook. The second part of the workbook is an introduction to uncertainty analysis using Monte Carlo simulation. Numerical integration in VBA Copy file "PredatorPreyVBA" from \\ic.ac.uk\group\foe\cv\teaching\hydroinformatics onto your H:. Open this file. Choose "Enable macros" after opening this file. This Excel file contains three solutions to the predator prey example; 1. Euler's method using a VBA program (module 1) 2. Runge-Kutta 4th order using a VBA program (module 2) 3. An adaptive time-step solution using a VBA program (module 3) First, note that on the spreadsheets there are no formulae in the cells; all the calculations are done by the VBA program. Second, note that the program is run using the buttons embedded on the spreadsheet (you can create buttons to run any macro see Appendix 1 if you are interested). Press Alt-F11 to start the VBA editor, and view the macro in module1 (double-click on the module 1 link): Document OutlineUncertainty analysis using Monte Carlo simulation