Partnership for Integration of Computation into Undergraduate Physics

This Faculty Commons entry contains numerical spreadsheet implementations of several mechanical systems. These implementations are complete, with many thousands of iterations (rows in the spreadsheet) and allow one to change the time step in the control panel over a wide range; thus, the files are somewhat large. These files are all located in the "Completed Code" section. All the spreadsheet files were produced in Excel, but can also be opened in most of the open source spreadsheet programs. I have also included in the "Documents" section some PowerPoint files, pertaining to numerical integration, spreadsheets, and Euler methods, that I have used in various classes and workshops in the past. The QM263 PowerPoint is a variation of the numerical integration slides for business students. Finally, I have decided to post the links here (below this paragraph) to several tutorial videos on implementing numerical solutions in spreadsheets. These videos contain content that have been the subject of many PICUP workshops over the last decade. Though the videos were produced using open source spreadsheet programs and google sheets, the functionality is identical to that found in Excel, with only minor differences in syntax and menu commands. [Building a Control Panel - Excel/LibreOffice](https://www.youtube.com/watch?v=rlLAyalCgyA) [Building a Control Panel - Google Sheets](https://www.youtube.com/watch?v=GLog6wTUUSI) [Basic Iterative Calculations and Building a Kinematic Problem Solver - Excel/LibreOffice](https://www.youtube.com/watch?v=yn9Dygxxrns) [Basic Iterative Calculations and Building a Kinematic Problem Solver - Google Sheets](https://www.youtube.com/watch?v=GsQW4rado54) [Review of Simple Euler Method](https://www.youtube.com/watch?v=EepfwEQryWI) [Falling Sphere without Air Resistance](https://www.youtube.com/watch?v=RdoKShdE3Ro) [Falling Sphere with Air Resistance - part 1](https://youtu.be/MpbsjUozfUQ) [Falling Sphere with Air Resistance - part 2](https://youtu.be/qHP24Vivmio) WARNING: Google sheets is not a good choice for numerical spreadsheet solutions requiring thousands of rows as performance will severely lag. Google sheets can be used to visualize the building of numerical algorithms (e.g. Euler-Cromer) for a small number of time steps, but if many thousands of iterations are required, it is best to implement the numerical solution in a local application like Excel or another spreadsheet program. If you should encounter any difficulties with these spreadsheet files or have any questions about any aspect of implementing numerical solutions with spreadsheets, please reach out any time.