MICROSOFT EXCEL for TRAFFIC CRASH RECONSTRUCTION

Instructor:  Andy Rich

Iowa State Police
260 N.W. 48th Place
Des Moines, IA 50313

This course will teach the reconstructionist how to use Microsoft Excel to solve just about every reconstruction problem that may be encountered. NO prior experience with Excel is necessary. This course begins at Step 1! Some of the topics covered:

• Writing formulas in Excel
• Spin Analysis
• Conservation of Linear Momentum ("360 Momentum").
• Airborne
• Critical speed yaw
• Sensitivity analysis
• Performing Monte Carlo simulation with Excel
• Performing finite difference analysis with Excel
• Using Excel for EDR analysis
• Closing speed analysis
• Obtaining delta-V from acceleration data
• Graphing for the jury
• Programming your own user-defined reconstruction functions and add-ins
• Solving simultaneous energy/restitution and momentum equations using Solver
• Cell formatting
• Conditional formula execution
• Option buttons
• List boxes
• Using names to refer to cells and ranges

Requirements: All students must have completed reconstruction or technical and must have access to a laptop running Microsoft Excel version 2010 or greater.

This course has been approved for 24 ACTAR CEUs