Report Automation#
The WSDOT Toll Division received transactional data and summarized it into monthly reports. These reports were shared with internal and external stakeholders, and one of the primary uses was distillation for the division’s annual report.
The previous workflow was to download reports from the vendor, rename files, and then use a set of workbooks to summarize and aggregate data. While this process offered some time savings from spreadsheet macros and employee’s familiarity, it did not scale, had little to no error checking, and was difficult to update.
This script streamlined the entire process by automating all steps - renaming, validating data, summarizing, and generation of final reports. All actions were logged and could be used to track the speed and outputs.