COUNT_Processing Sample.xlsx

This is a traffic count data processing spreadsheet maintained by the Maine Department of Transportation (MaineDOT) Traffic Engineering Division, documenting portable short-duration traffic counts (SDCs) conducted across the state in 2022. The dataset contains 462 records of individual count stations, each identified by a unique Count_ID and Station_ID, with corresponding traffic volume data, adjustment factors, count classifications (by vehicle class or axle groups), and quality control metrics. The counts were conducted throughout 2022 across various weeks, with duration periods typically ranging from 24 to 95 hours, and represent diverse location types classified by Roman numerals (I, II, III) and alphanumeric codes (38704, 92003, 07507, 37007) indicating functional classification or road type. Data entry was performed by Alexander Hanscom on January 9, 2023, with subsequent updates on February 16, 2023, and select entries on March 6, 2023. The spreadsheet includes quality assurance flags, with BadCount indicators marking 18 entries as problematic and numerous entries marked as VirtualCount or assigned to specific School IDs, and references corresponding source Excel workbooks stored in temporary factoring directories or SharePoint locations containing detailed class-based and volume-based count data.

The data reflects MaineDOT's comprehensive traffic monitoring methodology, utilizing adjustment factors (FACTOR column) ranging from 0.67 to 1.05 to annualize or standardize short-duration counts into estimated Annual Average Daily Traffic (AADT) values. Each record includes the raw count volume, the applied factor, the resulting AADT estimate, and metadata indicating count type (C for regular counts, S for special counts, X or Y for volume-based counts, and V for variant counts), count groups (I, II, III combinations or special codes), and duration in hours. The Notes field captures quality concerns, procedural notes, and data corrections, with entries referencing edits to peak hour counts, factor changes, and workbook status. This dataset feeds MaineDOT's traffic monitoring program, which supports the planned Traffic Count Software as a Service (SaaS) procurement (RFP #202510141) designed to manage and process approximately 5,000-7,000 annual portable counts alongside continuous monitoring sites, demonstrating the operational scale and data complexity requiring modernized cloud-based management solutions with capabilities for data validation, federal reporting compliance (HPMS and TMAS), and historical data integration spanning multiple years of accumulated traffic information.