Using Microsoft Excel with Advanced Monte Carlo Analysis for Traffic Reconstruction

Event Description

Prerequisites: The student must have successfully completed an accident reconstruction/technical class.

Why use Excel for Traffic Crash Reconstruction? Consider the following points:
 Errors have been found in commercial accident reconstruction software.
 You do not know what goes behind the scenes in commercial accident reconstruction software because you did
not program it.
 Most jurors have at least heard of Excel because it comes free with many store-bought computers. Jurors are
comfortable with Excel.
 You can testify that you programmed the equations yourself and that nothing unusual is happening behind the
scenes.
 With Excel, you are not stuck with a pre-formatted results output. Your data may be customized for each
reconstruction that you do.
 Excel can handle multiple phases of a crash reconstruction, while commercial software must deal with one phase
at a time. For example, a spin analysis may be combined with any number of energy losses in one spreadsheet.
 There is not one accident reconstruction program that does everything. Excel can be programmed to do just about
anything. You are only limited by your imagination.
 This four-day class includes an extra day dedicated to monte Carlo analysis.