Three Spreadsheet Models Of A Simple Pendulum
The paper gives three spreadsheet models of simple pendulum motion. In two of them, the graph of the pendulum angle is drawn upon the exact integral solution using numeric integration – the simpler model only uses spreadsheet functions, the general model uses a VBA program. The period results direct...
| Main Author: | |
|---|---|
| Format: | Article |
| Language: | English |
| Published: |
McMaster University
2008-10-01
|
| Series: | Spreadsheets in Education |
| Subjects: | |
| Online Access: | http://epublications.bond.edu.au/ejsie/vol3/iss1/5 |
| Summary: | The paper gives three spreadsheet models of simple pendulum motion. In two of them, the graph of the pendulum angle is drawn upon the exact integral solution using numeric integration – the simpler model only uses spreadsheet functions, the general model uses a VBA program. The period results directly from the calculations. In the third model, the period is calculated first using the power series formula. The graph of the pendulum angle is drawn afterwards using Euler’s method of solving differential equations. The error in gravity acceleration if calculated upon the standard cosine approximate formula instead of the exact one is graphed. |
|---|---|
| ISSN: | 1448-6156 |