Bridge_Sweeping_-_Box_Sheet.xlsx

The document is an Excel spreadsheet detailing bridge sweeping specifications for multiple bridges across several Alabama counties, including Colbert, Lauderdale, Lawrence, Limestone, Morgan, and Franklin. The spreadsheet provides comprehensive data on bridge locations, including Bridge Inventory Numbers (BIN), routes, county locations, milepost ranges, and shoulder miles for sweeping services. The document appears to outline a bi-monthly bridge sweeping contract cycle, with calculations for total shoulder miles swept annually for each bridge location, totaling 105.840 miles for the Morgan County bridges, 37.728 miles for Lauderdale County bridges, 1.776 miles for Lawrence County bridges, 6.816 miles for Limestone County bridges, 100.512 miles for Colbert County bridges, and 16.032 miles for Franklin County bridges.

The spreadsheet does not include specific pricing information, contract terms, or funding sources. Instead, it serves as a detailed inventory and measurement document for bridge sweeping services, providing precise measurements of outside and inside shoulder miles for each bridge segment. The data suggests a systematic approach to bridge maintenance, with detailed tracking of sweeping requirements across multiple counties and routes. Each bridge entry includes specific route numbers, begin and end mileposts, and calculated sweeping distances, which could be used for bid preparation, contract specification, or maintenance planning purposes.