This was the first class I have taken from Andy and Michelle, and I hope it is not my last. The class was well structured and I learned a lot. I look forw...
Read MoreThis was the first class I have taken from Andy and Michelle, and I hope it is not my last. The class was well structured and I learned a lot. I look forward to designing (and redesigning) some spreadsheets to make my job easier. I cannot wait to attend an advanced class if they offer one. Kent E. Boots, ACTAR #1170
Read LessAlthough this is one of the more difficult classes I have taken in my reconstruction career, it is also one of the best and most helpful classes. Andy takes...
Read MoreAlthough this is one of the more difficult classes I have taken in my reconstruction career, it is also one of the best and most helpful classes. Andy takes a subject that may be daunting to some and explains and teaches the material is a way that flows well and is easy to understand. I can immediately put to use in my reconstruction work many of the tools and skills that I have learned in this class. I would HIGHLY recommend it. Kerry Alvino
Read LessAndy and Michelle are giants in their field! The training programs offered by Rich Consulting are top notch. They stay on top of developments in accident re...
Read MoreAndy and Michelle are giants in their field! The training programs offered by Rich Consulting are top notch. They stay on top of developments in accident reconstruction concepts. Every student receives as much individual attention as is necessary to ensure success. I highly recommend Rich Consulting training!
Read LessBest online course I have taken...
Best online course I have taken...
Read LessChallenging and engaging. Not a walk in the park. You need to think and apply what you learn. Excellent support and guidance.
Challenging and engaging. Not a walk in the park. You need to think and apply what you learn. Excellent support and guidance.
Read LessThe course is so good, I took it twice (once in-person and the second time online). Andy teaches the online course as if you were sitting in a classroom wit...
Read MoreThe course is so good, I took it twice (once in-person and the second time online). Andy teaches the online course as if you were sitting in a classroom with him. He walks you through creating your own, customized, crash reconstruction calculator with step-by-step instructions. If you encounter an issue or have a question, he is extremely timely with his responses. Most of all, Andy stays available after the course to assist you with crash reconstruction concerns. I have used the Excel program he teaches you to make on almost all of my crash investigations.
Read LessThis course is extremely useful for accident reconstructionists! I had no idea that Excel offered so many tools that can be utilized to design Excel sheets ...
Read MoreThis course is extremely useful for accident reconstructionists! I had no idea that Excel offered so many tools that can be utilized to design Excel sheets for all forms of reconstructions. I would definitely recommend this course to an accident reconstructionist or anyone who is just looking to become more diverse with Excel. The instructor, Andy Rich, is also great! He is extremely helpful and very patient with students.
Read LessAndy and Michelle do a great job of presenting Excel and its application to accident reconstruction. They also teach a lot of accident reconstruction in the ...
Read MoreAndy and Michelle do a great job of presenting Excel and its application to accident reconstruction. They also teach a lot of accident reconstruction in the class making the class on the order of a class you would take through the Society of Automotive Engineers. They go well beyond the typical accident reconstruction classes taught by Northwestern or IPTM. This is not a class that you can take lightly. They really make you think. Thanks Andy, Michelle, Edison, and Tesla.
Read LessThis class was great. The course chapters were broken into short videos which were perfect in length. They covered what needed to be covered and were broken ...
Read MoreThis class was great. The course chapters were broken into short videos which were perfect in length. They covered what needed to be covered and were broken up at the right time. For an online Excel class this far exceeded expectations. I recommend this course to any reconstructionist that is serious about their skill and wants to improve reconstructions.
Read LessHow to Use and Navigate this Class
Course Materials
Instructor Introduction--Andrew Rich
Instructor Introduction-Michelle Fish-Rich
Student Survey
Introduction to Microsoft Excel
Common Errors and Getting Help
Common Errors Quiz
Chapter 1 Survey
The Excel Graphic User Interface
The Graphic User Interface Quiz
Chapter 2 Survey
Excel Options and Add-ins
Excel Options and Add-in Quiz
Chapter 3 Survey
Writing Equations in Excel Part I
Writing Equations in Excel Part II
Writing Equations in Excel Quiz
Chapter 4 Survey
Basic Excel Spreadsheet Design Skills Part I (Minimum Speed Equation)
Basic Excel Spreadsheet Design Part I Quiz
Basic Excel Spreadsheet Design Part II
Basic Excel Spreadsheet Design Part II Quiz
Basic Excel Spreadsheet Design Part III
Basic Excel Spreadsheet Design Basics Part III Quiz
Basic Excel Spreadsheet Design Part IV
Basic Excel Spreadsheet Design Part IV Quiz
Chapter 5 Survey
Entering Formulas & Debugging (Minimum Speed)
Entering Formulas & Debugging Quiz
Chapter 6 Survey
The Equation Editor and Sheet Names (Minimum Speed)
The Equation Editor & Sheet Names Quiz
Chapter 7 Survey
Creating Charts (Minimum Speed)
Creating Charts Quiz
Chapter 8 Survey
Option Buttons, If Function & Data Tables Part I (Airborne)
Option Buttons, If function & Data Tables Part I Quiz
Option Buttons, IF function & Data Tables Part II
Option Buttons, IF Function & Data Tables Part II Quiz
Option Buttons, If Function & Data Tables Part III
Option Buttons, IF Function & Data Tables Part III Quiz
Option Buttons, If Function & Data Tables Part IV
Option Buttons, IF Function & Data Tables Part IV Quiz
Option Buttons, IF Function & Data Tables Part V
Option Buttons, IF Function & Data Tables Part V Quiz
Option Buttons, IF Function & Data Tables Part VI
Option Buttons, IF Function & Data Tables Quiz Part VI
Chapter 9 Survey
Using Names Part I (Minimum Speed)
Using Names Part I Quiz
Using Names Part II (Momentum)
Using Names Part II Quiz
Using Names Part III
Using Names Part III Quiz
Using Names Part IV
Using Names Part IV Quiz
Using Names Part V
Using Names Part V Quiz
Chapter 10 Survey
Assignment I Introduction (Critical Speed Yaw)
Assignment 1 Submission
Assignment 1 Survey
Spin Analysis Part I
Spin Analysis Part I Quiz
Spin Analysis Part II
Spin Analysis Part II Quiz
Spin Analysis Part III
Spin Analysis Part III Quiz
Chapter 11 Survey
Introduction to Sensitivity Analysis
Introduction to Sensitivity Analysis Quiz
Statistics: Definitions & Probability Distributions
Statistics: Definitions & Probability Distributions Quiz
Statistics: Mean and Median
Statistics: Mean and Median Quiz
Statistics: Standard Deviation
Statistics: Standard Deviation Quiz
Statistics: The 68-95-99.7% Rule (The Empirical Rule)
Statistics: The 68-95-99.7% Rule Quiz
Chapter 12 Survey
Introduction to the Method of Finite Differences (Pedestrian)
Introduction to the Method of Finite Differences Quiz
The Method of Finite Differences: Sample Calculations
The Method of Finite Differences: Sample Calculations Quiz
The Method of Finite Differences Project Part I
The Method of Finite Differences Project Part II
The Method of Finite Differences Project Part III
Chapter 13 Survey
Assignment 2 Introduction (Finite Differences on an Inline Collision Using EDR Data)
Assignment 2 Submission
Assignment 2 Survey
Basic Monte Carlo Analysis Part I (Monte Carlo Simulation on a Pedestrian Crash)
Basic Monte Carlo Analysis Part I Quiz
Basic Monte Carlo Analysis Part II
Basic Monte Carlo Analysis Part III
Why 15,000 Simulations
Chapter 14 Survey
Assignment 3 Introduction (Monte Carlo Simulation on an Inline Collision Using EDR Data)
Assignment 3 Submission
Assignment 3 Survey
How to Find Standard Deviations for Use in Accident Reconstruction
How to Determine Uncertainty Quiz
Chapter 15 Survey
Introduction to User-Defined Functions
Introduction to User-Defined Functions Quiz
Creating UDFs Part I (Minimum Speed Formula)
Creating UDFs Part I Quiz
Creating UDFs Part II (The Airborne Formula)
Creating UDFs Part II Quiz
Creating UDFs Part III (Trig Functions That Work With Degrees)
Creating UDFs Part IV (Saving Your UDFs As An Add-in)
Creating UDFs Part IV (Saving Your UDFs As An Add-In) Quiz
Creating UDFs Part V (Error Trapping)
Creating UDFs Part V (Error Trapping) Quiz
Creating UDFs Part VI (User-Defined Array Functions--Searle)
Update on Creating User-Defined Array Functions: August 2022
Creating User-Defined Array Functions Part VI Quiz
Chapter 16 Survey
Assignment 4 Introduction (Quadratic Equation)
Assignment 4 Submission
Assignment 4 Survey
Using Excel to Calculate Stiffness Coefficients from NHTSA Crash Test Data Part I
Using Excel to Calculate Stiffness Coefficients from NHTSA Crash Test Data Part I Quiz
Using Excel to Calculate Stiffness Coefficients from NHTSA Crash Test Data Part II
Chapter 17 Survey
Two-Car CRASH3 Project Introduction
Two-Car CRASH3 Project Introduction Quiz
Two-Car CRASH3 Project
Chapter 18 Survey
Area Under the Curve
Area Under the Curve Quiz
Chapter 19 Survey
Chrysler Delta-V Project Introduction
Chrysler Delta-V Project Introduction Quiz
Chrysler EDR Delta-V Project Part I
Chrysler EDR Delta-V Project Part II
Chapter 20 Survey
Assignment 5 Introduction (Calculating Toyota Lateral Delta-V from EDR Data)
How to Import a CSV File (Optional)
Assignment 5 Submission
Assignment 5 Survey
Advanced Monte Carlo Techniques Introduction
Advanced Monte Carlo Techniques: Programming a List Box
Advanced Monte Carlo Techniques: Adding Labels, Data and Names
Advanced Monte Carlo Techniques: Column Headings, Random Numbers and Filters
Advanced Monte Carlo Techniques: Completing the Random Numbers & Filters. Programming the Governing Equation.
Advanced Monte Carlo Techniques: Histogram Calculations Part I
Advanced Monte Carlo Techniques: Histogram Calculations Part II
Advanced Monte Carlo Techniques: Creating the Histogram
Advanced Monte Carlo Techniques: The CORREL Function
Advanced Monte Carlo techniques: Adding the Bell Curve
Advanced Monte Carlo Techniques: Adding the Cumulative Probability Curve
Handling Skewed Data Sets
Handling Skewed Data Sets Quiz
Writing VBA User-Defined Functions to Generate Random numbers
Chapter 21 Survey
Using Excel to Analyze EDR Stability Control System Data--Part I
Using Excel to Analyze EDR Stability Control System Data--Part II
Using Excel to Analyze EDR Stability Control System Data--Part III
Using Excel to Analyze EDR Stability Control Data--Part IV
Chapter 22 Quiz
Chapter 22 Survey
Using Solver to Solve Simultaneous Equations
Chapter 23 Survey
Final Exam
Final Exam Survey
Final Project
Final Project Survey
Course Closing
Class Evaluation
The prerequisite for this class is any reconstruction class. Some areas refer to that as technical. If you have training in momentum, minimum speed, critical speed yaw and airborne you have the required knowledge to successfully complete this course. Successful completion of specialty classes such as pedestrian, commercial motor vehicle, EDR is NOT required.
No. This course starts from the very basics of Excel. We assume that you have never opened Excel on a computer.
We currently support Excel 2010 and later. However, users of 2010 should understand that there will be some differences in their interface and some Excel functions. Our manual will point out the difference in the Excel functions. However, our videos that show how to create charts will be different from the 2010 interface. Our experience with live classes and testers for the online class is that most students can figure out how to create the charts in 2010.
There are a few options here. The instructors constantly monitor the discussion forums and answer questions ASAP. Of course, we have a consulting business and we do sleep sometimes! There will be times when we are taking care of a consulting commitment and a reply will be delayed. There are also time zone issues to consider. Dinner time on the west coast is bed time for us! For those who do not want to publicly post a question in a discussion forum, direct email is available. We also offer telephone support as well as screen sharing support such as TeamViewer or Zoom. There is also Google. Most issues that students run into may be solved by a Google search.
It takes the average student 28 hours to complete the course. That includes watching the videos, taking quizzes, doing assignments and taking the final exam and completing the final project. That comes out to less than 1 hour per day. The 30-day limit should not be an issue for most students. However, we understand that life happens. Extensions are available for those who have a legitimate reason for not completing the course in 30 days. Students must have shown a meaningful attempt at participating in the course to receive an extension.
The class has been preapproved for 24 ACTAR CEUs.
Once you complete the course send an email to [email protected]. Make sure that you include your ACTAR number. That's it! We will take care of the rest including payment of all fees to ACTAR.
Yes! All topics in accident reconstruction are explained (except for the very basic stuff such as minimum speed, airborne, momentum and critical speed yaw. All other topics are explained, such as EDR analysis, Monte Carlo simulation and spin analysis.
Yes! There are many lectures that guide you through understanding what Monte Carlo is and how it works. Monte Carlo simulation has become one of the most popular sections of our live class.