Rich Consulting LLC

Accident Reconstruction Consulting & Training

office (234) 201-7676
fax (234) 678-0246

Microsoft Excel for Traffic Crash Reconstruction (24 ACTAR CEUs)

THREE-DAY CLASS

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
  • Statistics primer for Excel
  • Using Excel for spin analysis
  • Using Excel for stiffness coefficients and damage analysis
  • Sensitivity analysis
  • Performing Monte Carlo analysis with Excel
  • Performing finite difference analysis with Excel
  • Graphing for the jury
  • Programming your own user-defined reconstruction functions and add-ins
  • Solving simultaneous energy and momentum equations using Solver
  • Programming dialog boxes
  • Using Excel to solve Woods' pole impact algorithm
  • Conditional formatting
  • Conditional formula execution
  • Option buttons
  • Programming your own accident reconstruction App

Requirements: All students must have completed reconstruction or technical and must have access to a laptop running Microsoft Excel version 2007 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

Download course flyer here

Cancelation Policy: You may cancel your registration outside of 30 days of the first day of class for a 100% refund. Within 30 days of the first day of class, a 25% administrative fee will be charged.

 

 

Scheduled Courses:

Tempe, AZ: October 18-20, 2017 Sponsored by the Scottsdale, AZ Police Department. Held at Tom Hontz Police and Fire Training Facility, 911 North Stadem Drive, Tempe, AZ  85281 (Open to civilians and LEOs). Tuition before August 15, 2017 is $375. Tuition after August 15, 2017 is $475. Click HERE to register.

Anaheim, CA: October 23-25, 2017
Sponsored by CA2RS. Held at the Anaheim Police East Station, 8201 E. Santa Ana Canyon Rd., Anaheim, CA 92808. Open to civilians and law enforcement. Tuition before September 15, 2017 is $375. After September 15, 2017 $475. Special hotel rate of $142/night (includes breakfast and drinks at night) at the Embassy Suites Anaheim Orange, 400 N State College Blvd., Orange, CA 92868. Click HERE to register.

Morristown, NJ: December 13-15, 2017 Sponsored by the Morris County Prosecutor's Office. Held at Morris County Public Safety and Training Academy, 500 West Hanover Ave., Morristown, NJ 07960 (Open to civilians and LEOs). Tuition before November 15, 2017 is $375. Tuition after November 15, 2017 is $475. Click HERE to register.


Contact us about hosting your own Excel class and receiving free tuition!


Testimonials:

"I would not hesitate to recommend this training to everyone. I learned a lot during the week and picked up some valuable techniques to analyze traffic crashes in ways one would not think of." -- Mike Reade, CD, Forensic Reconstruction Specialists Inc.

"Very informative class that will benefit me in my reconstruction investigations." -- Tpr. Angela Porter, Maine State Police.

"Andy provided a clear step-by-step process in developing programs in Excel for crash reconstruction formulas. As a reconstructionist, I am better equipped to logically explain the input data and derived answers to my clients and jurors." --Lt. Ed Weber (Ret), Waldwick, NJ Police.

"Thanks for putting on an excellent piece of instruction. I learned quite a bit not only about Excel, but also about statistics and the other more intricate areas of accident reconstruction I do not normally use. With the programming of the formulas in Excel, that I will use at some point soon, I feel like my time was very well spent and worth the cost of tuition."--Stephen Motyczka, Westfield Investigative Group.

"Great Class! Very informative. Really opened my eyes to how much can be done with Excel to simplify our reconstructions. Thanks!"--Sgt. Steve Carbajal, Tempe (AZ) Police Vehicular Crimes Unit.

"Great class, got more valuable information than I hoped for. I would strongly recommend this class to anyone who uses a computer for reconstruction."--Mike Broughton, Phoenix, AZ.

"The course was full of interesting Excel programming. Andy and Michelle made the class exciting, interesting, and informative. Thanks for 3 great days of instruction!"--Tim Pebler.

"The class helps by opening up the world of Excel to officers who have the tool in the toolbox without an added expense of additional software."--Det. Cam Siewert, AZDPS.

"A great class, the power of Excel is amazing! I have been a crash reconstructionist for 14 years and this a great addition to my toolbox. A must for any reconstructionist!!"--Aaron Rankin, Cabarrus County Sheriff's Office, Concord, NC.
 
"Andy and Michelle are excellent. They are a great combo for teaching this class. This class exceeded my expectations. The instruction was clear and easy to follow. Thanks for a great class." -- Joseph Buschelman.

"This class gave me a new perspective on whether to use commercial recon programs. I look forward to making my own spreadsheets with the info he provided." -- Lt. Steve Ashton, Ret (ACTAR 1474).

"Andy Rich and Michelle Fish were outstanding in the presentation of Microsoft Excel for Traffic Crash Reconstruction. I would highly recommend this course for the reconstructionist looking to build their own Excel workbooks for reconstruction. Excellent course!" -- Trooper Mark Dicocco, CT State Police

"Thank you for your professionalism, patience, willingness to share, willingness to help me understand." -- Pat Doherty

"The course was well managed moving along at the pace of the slowest person making sure that everyone was in the same place with any issues addressed before moving forward. Both you and Michelle were always available during class as well as coming in early before and staying late after class to help anyone who needed assistance. I have a moderate level on competency with Excel but feel much better now moving forward, having a better understanding of how it works, what to look for in others data sets and how it will help me in the future both with my own entry of formula for reconstruction problems and that of RC Monte Carlo. The course was given in plain easily understood language and I would sincerely recommend it for anyone who wants to improve their abilities in this ever changing field." --Dalton Brown, MVC Forensics, Inc.