Crash Facts Report Generator - An excel visual basic program for automating the Iowa annual crash facts report

Date
2021-01-01
Authors
He, Yue
Major Professor
Anthony Townsend
Advisor
Committee Member
Journal Title
Journal ISSN
Volume Title
Publisher
Altmetrics
Authors
Research Projects
Organizational Units
Journal Issue
Series
Department
Information Systems and Business Analytics
Abstract

This work proposes a tool for the automatic creation of Iowa annual crash facts reports by clicking programmed buttons in two separate user interfaces designed in Excel. A dedicated Visual Basic code has been developed; to perform data retrieval from crash databases in Access, to update crash data visualizations in Excel, and to export the visualizations to a Portable Document Format report.

Comments
Description
Keywords
Citation
DOI
Source