Appendix A1 Southwest and Grand Region update.xlsx

Appendix A1 is a spreadsheet detailing Transportation Service Center (TSC) required routes for the Southwest and Grand Regions of Michigan, covering multiple counties including Marshall, Coloma, Allegan, and Kalamazoo. The document provides a comprehensive breakdown of highway patrol routes across interstate highways (I-69, I-94, I-196, I-194), business loops, and US highways (US-31, US-131), specifying route lengths, patrol requirements, and directional coverage.

The spreadsheet indicates routine patrol requirements for each route segment, with total patrol miles calculated for each county area. Specifically, Marshall County has 211 total patrol miles, Coloma has 210 patrol miles, Allegan County has 116 patrol miles, and Kalamazoo County has 113 patrol miles. Routes are consistently marked for patrol in both directions, with most segments requiring full patrol coverage. The document appears to be an operational planning tool for transportation service and highway maintenance, providing precise mileage and patrol specifications for different road segments across southwestern Michigan.