Create Excel Template to import camera data quickly

[atdservicebot]

What application are you using?

Other / Not sure

Describe the problem.

We are needing an Excel template created that can be "quick filled" using data pulled from our data collection camera.

How soon do you need this?

Soon — Within a week

Is there anything else we should know?

Currently we are manually creating these documents which takes staff about an hour for each request.

Requested By Shelby S.

Request ID: DTS23-109560

[ChristinaTremel]

9/7 Updates

• Called Shelby in the morning and she showed me the process that's currently happening to populate the All-Way Shoalmont Dr and Shoalwood Avenue.xls report. Currently takes users 1 to 1.5 hours to compile all the data into this report.
• Talked with the Data Science team and determined that we might not be able to build an excel template and there's not a super easy way to automatically pull this data together. Our thought is to instead create a help guide of instructions to make this process quicker for TED to put together using pivot tables.
• Tried using excel Pivot Tables and was able to get the "24 Hour Intersection Volume Report" populated in less than 10 minutes.
• Called Shelby to sync and showed her the pivot table process and she thought this would work to speed up their process, but she's going to sync with Cody and Eric to make sure this works for them as well.
• I'm going to create a simple help guide to walk users through creating a pivot table based on the volume data collected in the field.

[ChristinaTremel]

• Created a help guide for Pivot Table for 24 Hour Intersection Volume Report.pdf
• Emailed it to Shelby 9/13.