Sample_Audit_Sheet.xlsx

The provided file is an Excel audit sheet for the City of Pasadena Department of Transportation Transit Division's BusFinder system, documenting the inspection status of 109 solar-powered electronic bus stop information devices across multiple locations in Pasadena, California. The city is seeking informal bids from qualified firms or individuals to conduct monthly inspections of all BusFinders, which are e-ink devices providing real-time bus arrival information for Pasadena Transit, LA Metro, and Foothill Transit at shared stops. The audit sheet comprehensively lists 80+ specific bus stop locations throughout Pasadena, tracking device functionality including solar panel performance, screen condition, presence of graffiti, and other potential issues.

The contract opportunity involves inspecting 109 BusFinders installed at various city bus stops, with the primary objective of documenting device conditions and photographing any discovered problems. These devices serve Pasadena's transit network, which includes six local fixed routes connecting residents, visitors, and workers to key city destinations and the regional transportation network. While specific pricing, funding sources, and contract duration are not explicitly detailed in the provided documents, the informal bid request suggests a straightforward monthly inspection service aimed at maintaining the effectiveness and reliability of the city's advanced bus stop information system.