Crash Tool Photos Compiler

Submitted by: Northwest District

Innovation Description and Benefit:

Excel VBA Macro programmed to input photos taken of highway crash scenes and process/format into series of photo pages complete with needed information, for archiving and legal purposes. Uses existing MS Windows/Excel capabilities to enable user to take collection of several photos and compile each into a standard-formatted and populated form using only a few buttons clicks. Macros and user form performs series of tasks that otherwise would take several steps by user.

 

For More Information Contact

Northwest District - Maintenance 

Joseph Turner at joseph.turner@modot.mo.gov or 816-387-2439.