Vehicle Class Counts Output - Length 2 lane.xlsx

This file is a vehicle classification count output spreadsheet from the Maine Department of Transportation (MaineDOT) Traffic Engineering Division, documenting traffic monitoring data for a 2-lane roadway segment at Station 131914004504 throughout 2022. The spreadsheet tracks daily vehicle counts across 13 classification categories (motorcycles, cars, pickup trucks, buses, single-unit trucks, and various tractor-trailer configurations) for both northbound and southbound directions, with additional metrics including heavy truck percentages, axle counts, and Average Daily Traffic (ADT) calculations. Summary report sections are provided for each direction, along with monthly and seasonal breakdowns of traffic patterns, with particular emphasis on heavy truck classifications (Classes 4-13) and subcategories (Classes 4-7 and Classes 8-13). The data includes the 30th highest hour analysis dated July 2, 2022 at 14:00 for northbound traffic, with 50 heavy trucks recorded out of 521 total vehicles, representing a 9.6% heavy truck percentage. The spreadsheet contains editable chart templates designed to display traffic trends by direction and time period, with the first Sunday of the year designated as the baseline for week number calculations.

This spreadsheet serves as a data output tool supporting MaineDOT's comprehensive traffic monitoring program, which manages approximately 5,000-7,000 annual portable short-duration counts, 130+ continuous count sites, 22 continuous turning movement sites, and 16 weigh-in-motion sites across Maine. The data architecture is compatible with the Traffic Count Software as a Service (SaaS) solution that MaineDOT is procuring through RFP #202510141, with a proposal submission deadline of December 3, 2025. The historical traffic count data from 2022 represented in this file exemplifies the type of information that will require conversion and integration into the new cloud-based platform, which must support federal reporting requirements including HPMS and TMAS submissions. The spreadsheet's standardized format for vehicle classification and directional analysis demonstrates MaineDOT's established data collection protocols that the selected vendor will need to accommodate and enhance through the new SaaS solution.