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 |
| _version_ | 1797967272708407296 |
|---|---|
| author | Jan Benacka |
| author_facet | Jan Benacka |
| author_sort | Jan Benacka |
| collection | DOAJ |
| description | 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. |
| first_indexed | 2024-04-11T02:28:38Z |
| format | Article |
| id | doaj.art-f2377664b78b488a995e731a1c4e1eb0 |
| institution | Directory Open Access Journal |
| issn | 1448-6156 |
| language | English |
| last_indexed | 2024-04-11T02:28:38Z |
| publishDate | 2008-10-01 |
| publisher | McMaster University |
| record_format | Article |
| series | Spreadsheets in Education |
| spelling | doaj.art-f2377664b78b488a995e731a1c4e1eb02023-01-02T22:20:43ZengMcMaster UniversitySpreadsheets in Education1448-61562008-10-01311055Three Spreadsheet Models Of A Simple PendulumJan BenackaThe 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.http://epublications.bond.edu.au/ejsie/vol3/iss1/5simple pendulumperiodspreadsheet modelgravity acceleration |
| spellingShingle | Jan Benacka Three Spreadsheet Models Of A Simple Pendulum Spreadsheets in Education simple pendulum period spreadsheet model gravity acceleration |
| title | Three Spreadsheet Models Of A Simple Pendulum |
| title_full | Three Spreadsheet Models Of A Simple Pendulum |
| title_fullStr | Three Spreadsheet Models Of A Simple Pendulum |
| title_full_unstemmed | Three Spreadsheet Models Of A Simple Pendulum |
| title_short | Three Spreadsheet Models Of A Simple Pendulum |
| title_sort | three spreadsheet models of a simple pendulum |
| topic | simple pendulum period spreadsheet model gravity acceleration |
| url | http://epublications.bond.edu.au/ejsie/vol3/iss1/5 |
| work_keys_str_mv | AT janbenacka threespreadsheetmodelsofasimplependulum |