Sample_Audit_Sheet.xlsx

XLSX spreadsheet 15 KB Posted

Attached to
Busfinder Inspections
Solicitation number
2024-RFP-0264
Issued by
Los Angeles County, California

About this file

The file is an Excel audit sheet for the City of Pasadena Department of Transportation Transit Division, specifically related to their BusFinder inspection program. The document contains a comprehensive listing of 119 bus stop locations across Pasadena that are equipped with BusFinder solar-powered, e-ink arrival time devices. The contract opportunity involves monthly inspections of these BusFinders, requiring documentation of device conditions and photographic evidence of any issues discovered. The contract term is structured for 2 years with two additional one-year option years, covering inspections of bus stops serving Pasadena Transit, LA Metro, and Foothill Transit.

The audit sheet provides a detailed inventory of bus stop locations, categorized by street names, directions (north/south/east/west bound), and specific intersections. Each location is tracked with potential inspection criteria including device functionality, solar panel condition, screen integrity, graffiti presence, and other potential problems. While specific pricing details are not provided in the documents, the scope suggests a systematic, location-by-location inspection process across Pasadena's transit infrastructure. The program appears to be part of a broader effort to maintain and improve real-time transit information accessibility for residents, visitors, and workers within the city's transportation network.

View the file

Other files

Show all 11

On GovTribe

Work with this file

  • Download the original file
  • Contacts named in this file
  • Similar government files
  • Ask GovTribe AI about this file

Text version

Sheet1

Stop NumberLocationDevice Works OK (Y/N)Solar Panel OK (Y/N)Screen OK (Y/N)Graffiti (Y/N)Other Problem - Note in Comments (Y/N)Date CheckedObservation/Comments
Allen.nb_Maple.fs
Allen.nb_Orange Grove.ns
Allen.sb_Corson.fs
Allen.sb_Orange Grove.fs
Altadena.nb_Paloma.fs
Altadena.nb_Washington.fs
Altadena.sb_Washington.fs
Arroyo Pkwy.nb_Fillmore.fs
Arroyo Pkwy.sb_California.fs
ArtCenter Parking Lot
California.eb_Arroyo Pky.fs
California.wb_Lake.fs
Colorado.eb_Arroyo Pkwy.fs
Colorado.eb_Bonnie.fs
Colorado.eb_El Molino.fs
Colorado.eb_Fair Oaks.fs
Colorado.eb_Garfield.fs
Colorado.eb_Los Robles.fs
Colorado.eb_Oak Knoll.fs
Colorado.eb_Raymond.fs
Colorado.wb_Fair Oaks.fs
Colorado.wb_Garfield.fs
Colorado.wb_Lake.fs
Colorado.wb_Los Robles.fs
Colorado.wb_Oak Knoll.fs
Colorado.wb_Raymond.fs
Del Mar.eb_Bonnie.ns
Del Mar.eb_Hill.ns
Del Mar.eb_Kinneloa.mid
Del Mar.eb_Lake.fs
Del Mar.wb_Bonnie.ns
Del Mar.wb_Hill.fs
Del Mar.wb_Madre.fs
Fair Oaks.nb_California.fs
Fair Oaks.nb_Congress.t
Fair Oaks.nb_Howard.fs
Fair Oaks.nb_Orange Grove.fs
Fair Oaks.nb_Washington.fs
Fair Oaks.nb_Woodbury.ns
Fair Oaks.sb_California.fs
Fair Oaks.sb_Del Mar.fs
Fair Oaks.sb_Hammond.fs
Fair Oaks.sb_Howard.fs
Fair Oaks.sb_Mountain.fs
Fair Oaks.sb_Orange Grove.fs
Fair Oaks.sb_Penn.t
Fair Oaks.sb_Tremont.fs
Fair Oaks.sb_Washington.fs
Fair Oaks.sb_Woodbury.fs
Foothill.eb_Halstead.fs
Foothill.eb_San Gabriel.fs
Foothill.eb_SMV.fs
Foothill.wb_Rosemead.fs
Foothill.wb_San Gabriel.fs
Foothill.wb_SMV.fs
Green.eb_Arroyo.ns
Green.eb_Orange Grove.fs
Lake.nb_Colorado.fs
Lake.nb_Del Mar.fs
Lake.nb_Maple.ns
Lake.nb_Mountain.ns
Lake.nb_Orange Grove.fs
Lake.nb_San Pasqual.fs
Lake.nb_Villa.fs
Lake.nb_Washington.fs
Lake.sb_Colorado.fs
Lake.sb_Corson.ns (Lake Station)
Lake.sb_Del Mar.fs
Lake.sb_Mountain.fs
Lake.sb_Orange Grove.fs
Lake.sb_San Pasqual.t
Lake.sb_Villa.fs
Lake.sb_Washington.fs
Lake.sb_Woodbury.fs
Lincoln.nb_Orange Grove.fs
Lincoln.nb_Woodbury.ns
Lincoln.nb_Wyoming.fs
Los Robles.nb_Villa.ns
Los Robles.sb_Villa.fs
Marengo.nb_Villa.fs
Marengo.sb_Orange Grove.fs
Mountain.wb_Fair Oaks.fs
New York.nb_Bradley.fs
New York.sb_Bradley.fs
Oak Grove/before JPL security
Orange Grove.eb_Fair Oaks.fs
Orange Grove.eb_Lincoln.fs
Orange Grove.wb_Marengo.fs
Raymond.nb_Del Mar Station.mb
Raymond.nb_Fillmore.fs
Raymond.nb_Glenarm.fs
Raymond.nb_Holly.fs
Raymond.sb_Del Mar Station.mb
Raymond.sb_Holly.ns
Rosemead.nb_Foothill.fs
Seco.eb_Arroyo.fs (next to Lot I)
Sierra Madre.wb_Michillinda.fs
Villa.eb_Lake.fs
Villa.eb_Madison.fs
Villa.wb_Lake.ns
Villa.wb_Madison.ns
Walnut.eb_Garfield.fs
Walnut.wb_Garfield.ns
Washington.eb_Fair Oaks.fs
Washington.eb_Lake.fs
Washington.eb_Los Robles.fs
Washington.eb_Marengo.fs
Washington.wb_Allen.fs
Washington.wb_Altadena.fs
Washington.wb_Fair Oaks.fs
Washington.wb_Lake.ns
Woodbury.eb_Los Robles.fs
Woodbury.wb_Lake.fs
0

&P of &N

File details come from the government source that posted it. Updated .