THREE-DAY CLASS (Live)

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

Tuition includes a printed and bound copy of Microsoft Excel for Traffic Crash Reconstruction: A Concise Reference, by Andrew Rich

If you choose to be invoiced for the registration, please have your registration paid in full, no later than 45 days prior to June 2nd, 2026. If you are with a Law Enforcement Agency, and your agency is responsible for your registration and they want to pay by check, please have them contact our Administrator Wade Bartlett at admin@napars.org asap to set the payment up please. Thank you for your understanding. 

Fort Worth PD has recommended lodging at the Hyatt Place Fort Worth/Cityview at 5900 Cityview Blvd. Fort Worth, Texas 76132. (The hotel is approximately 7 miles from the facility hosting the class) They have offered a special rate by clicking on the link below.

https://www.hyatt.com/hyatt-place/en-US/dfwzc-hyatt-place-fort-worth-cityview