Excel in Kinematics
by Jon Wittwer
This page contains some supplementary notes, handouts, and examples for an introductory course on the design of mechanisms that I taught at BYU in the Fall of 2003 around the same time I first created Vertex42.com.
Excel Tutorials and Examples
- Basic Excel Tutorial
- Units and Unit Systems in Excel
- Using Named Ranges
- Ready-Made Unit System Template
- Variable Length Vector
Kinematics Tutorials and Examples
- Advanced Excel Topics for Kinematics (pdf)
- Complex Numbers Example
- Matrix Math Example
- Solve System of Equations Using the Solver
- Excel Solver Example
- Planetary Gear Example
Math Summary Sheets
You may print as many paper copies of these summary sheets as you need.
Conversion Factor Table
Download the PDF
⤓ Download
Description
This worksheet includes some of the most conversion factors used in Mechanical Engineering. This was one of my most-used summary sheets in college.
Integral Table and Derivative Sheet
Download the PDF
⤓ Download
Description
You'll need an excellent printer and good eyes to use this summary sheet, but every engineer needs something like this.
Trigonometry Summary Sheet
Download the PDF
⤓ Download
Description
This summarizes pretty much everything I ever used related to trigonometry.
