Attachment J.xlsx

This is a resource allocation and staffing schedule document for traffic data collection services in South Carolina, detailing technician assignments and work timelines across all 46 counties in the state. The spreadsheet identifies specific counts of data collection points for each county, the number of double counts (repeated measurements), assigned technicians, and the specific weeks or months when data collection activities are scheduled to occur. County assignments vary significantly, with Spartanburg County representing the largest collection effort (609 counts with 150 double counts), followed by Richland (529 counts with 189 double counts) and Greenville (540 counts with 154 double counts), while smaller counties such as McCormick and Allendale require minimal resources. The data collection activities are distributed throughout the calendar year with varying intensities by month and location.

The document indicates staffing assignments distributed among several designated technicians including John Cockrell, Julie Powell, Larry Grooms, William Johnson, and Alice Biggers, with several counties marked as "Vacant for 2013" or "Vacant," suggesting open positions requiring fill or updated assignments. Staffing allocations range from single-week assignments in smaller counties to multi-month engagements in high-volume areas such as Orangeburg and Spartanburg. This scheduling framework appears designed to optimize technician utilization and ensure systematic coverage of traffic data collection requirements across the entire state of South Carolina throughout 2013.