Examining ΔV from an EDR file with Excel

This will be an extension of the "Excel zoomie" in February, but instead of a skid-to-stop test with digital integration, we'll spend more time discussing DV and PDOF and making informative and easy to read charts.

-Finding the data in the .csv file

-Calculate total DV

-Plotting ΔVx -  ΔVy -  ΔVtotal

-Clean up the chart to suit with desired gridlines, border, scales, titles, tic marks, colors, markers, lines, labels, words

-What does ΔV tell us about the travel speed?

-Calculate PDOF over time and plot it

-Other charting tasks as time permits

-Handouts will include an Excel Shortcut cheat sheet, and a few pages regarding PDOF and the addition of acceleration vectors.

DATE: Friday, 06 June 2025
TIME: 12pm (noon) - 2 pm EST (GMT-5)
COST: Free for NAPARS members;  $6 for non-members
ACTAR: This event has been submitted to ACTAR for CEU consideration. Accredited attendees should be prepared to sign in with i-Attend app on a phone during the presentation, assuming they are approved.

All attendees will be able to request an attendance certificate during the show.

The show will be recorded and put in the Reference Library along with various supporting material.

Our Speaker: 

Wade Bartlett has degrees in Mechanical Engineering (1989 and 1994), holds ACTAR #789, and is a licensed professional engineer in NH. He has run a private engineering and accident reconstruction consulting business for 30 years, and has been a certified part-time police officer in NH since 2003, currently employed by Farmington PD and Strafford County Sheriff's Office. He is also the administrator for NAPARS.