RFP 25-005 EAMS - Appendix L - Vehicle Problems Report.xlsx
XLSX spreadsheet 17 KB Posted
- Attached to
- Enterprise Asset Management Software
- Solicitation number
- S-KS2410-00013228
- Issued by
- Marion County, Oregon
About this file
The file "RFP 25-005 EAMS - Appendix L - Vehicle Problems Report.xlsx" appears to be a detailed vehicle maintenance and problem tracking spreadsheet, likely for a public transit or transportation agency. The document contains multiple tables tracking vehicle issues, including problem codes, vehicle defects, problem history, and problem type history for a fleet of vehicles with numbers 1010, 1020, and 1030. The spreadsheet systematically records various vehicle problems such as air conditioning issues, accidents, fare box jams, tire problems, and other mechanical or operational concerns.
The spreadsheet provides comprehensive data tracking for each vehicle incident, including vehicle number, report dates, problem types, work order numbers, operator information, and detailed comments about specific issues. Notable entries include problems like casino tokens jamming fare boxes, air pressure issues, and even a reported fire on a bus. The document appears to be a robust system for monitoring and managing vehicle maintenance, tracking problem occurrences, mileage between incidents, and documenting repair and dispatch information for each reported vehicle issue.
View the file
Other files
Show all 20
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
NoticeSignatureTable
| WorkOrderNo | Manager | Title |
| 1V38692 | James Dudin | Prolo |
ProblemCodeTable
| ProblemCode | Description | WorkOrderClass | PrioritySeqNo |
| A/C | AIR CONDITIONING PROBLEMS | 1 | 0 |
| ACC | ACCIDENT | 1 | 0 |
| AIR | AIR PRESSURE PROBLEMS | 1 | 0 |
| DENT | SCRATCHES & DENTS | 1 | 0 |
| FIRE | FIRE ON BUS | 1 | 0 |
| FUEL | FUEL PROBLEMS | 1 | 0 |
| HE | HOT ENGINE | 1 | 0 |
| HEAT | HEATING PROBLEMS | 1 | 0 |
| JAM | FARE BOX JAMMED | 1 | 0 |
| OIL | OIL PRESSURE PROBLEMS | 1 | 0 |
| TIRES | TIRE PROBLEMS | 1 | 0 |
| TRANS | TRANSMISSION PROBLEMS | 1 | 0 |
| WATER | LOW COOLANT | 1 | 0 |
ProblemDefectTable
| VehicleNumber | ReportDate | ReportTime | SequenceNo | OperatorNo | ProblemType | ProblemCode | WorkOrderNo | WorkOrderLineNo | OpenedByDispatcherNo | VandalismFlag | Comment |
| 1010 | 12/16/02 | 12/31/99 | 1 | 1151 | D | AIR | 1151 | FALSE | AIR PRESSURE PROBLEMS | ||
| 1020 | 12/10/02 | 12/31/99 | 1 | 1151 | D | ACC | 1151 | FALSE | ACCIDENT |
ProblemHistoryTable
| VehicleNumber | ProblemType | ProblemCode | LastOccurred | MilesSinceLastOccurrence | MaxMilesBetweenOccurrence | MinMilesBetweenOccurrence | LifeToDateVehicleMiles |
| 1010 | D | FIRE | 12/18/02 | 0 | 0 | 0 | 341330 |
| 1010 | M | AIR | 12/18/02 | 0 | 0 | 0 | 341330 |
| 1010 | M | JAM | 2/6/02 | 0 | 0 | 0 | 340500 |
| 1010 | O | JAM | 9/20/02 | 130 | 450 | 130 | 341080 |
| 1020 | M | JAM | 11/13/02 | 0 | 0 | 0 | 346453 |
| 1020 | O | JAM | 11/13/02 | 468 | 468 | 468 | 346453 |
| 1030 | D | A/C | 11/13/02 | 0 | 0 | 0 | 343657 |
| 1030 | D | WATER | 12/9/02 | 0 | 0 | 0 | 343657 |
| 1030 | M | ACC | 2/8/02 | 0 | 0 | 0 | 343657 |
ProblemMasterTable
| WorkOrderNo | VehicleNumber | Operator | ProblemType | ProblemCode | ReportDate | ReportTime | DispatchDate | DispatchTime | LocationOfVehicle | DirectionOfVehicle | Route | WorkAssignment | Dispatcher | VandalismFlag | Closed | WorkOrderClass | MinutesDelayed | BusRepairedOnRoadFlag | BusTowedInFlag | EmergencyFlag | DepartureFromGarage | ArrivalAtBusLocation | BusReleased | ScheduledRouteDeparture | ReplacementVehicleNo | TripsLost | PassengersDelayed | RevenueMiles | NonRevenueMiles | MechanicReturned | MechanicNo | Sec15RoadcallFlag | Comment |
| 5004 | 1020 | 01122 | O | JAM | 1/31/02 | 12/31/99 | 1/31/02 | 12/31/99 | MEADOWS MALL | IN | 204 | 1 | 102 | FALSE | 1 | 0 | TRUE | FALSE | FALSE | 1/31/02 | 1/31/02 | 1/31/02 | 1/31/02 | 0 | 0 | 0 | 0 | 1/31/02 | 10055 | FALSE | CASINO TOKEN STUCK IN BOX | ||
| 5009 | 1010 | 102 | O | JAM | 2/6/02 | 12/31/99 | 2/6/02 | 12/31/99 | RAINBOW & SAHARA | IN | 201 | 1 | 62 | FALSE | 2/6/02 | 1 | 0 | TRUE | FALSE | FALSE | 2/6/02 | 2/6/02 | 2/6/02 | 2/6/02 | 0 | 0 | 0 | 0 | 2/6/02 | 01123 | FALSE | APPEARS TO BE CASINO TOKEN | |
| 5010 | 1030 | 102 | M | ACC | 2/8/02 | 12/31/99 | 2/8/02 | 12/31/99 | HERE | IN | 200 | 01122 | FALSE | 2/8/02 | 1 | 0 | TRUE | FALSE | FALSE | 0 | 0 | 0 | 0 | FALSE | ACCIDENT | ||||||||
| 5011 | 1010 | 102 | O | JAM | 9/20/02 | 12/31/99 | 9/20/02 | 12/31/99 | SAHARA & RAINBOW | IN | 100 | 1 | 14011 | FALSE | 1 | 0 | TRUE | FALSE | FALSE | 9/20/02 | 9/20/02 | 9/20/02 | 9/20/02 | 0 | 0 | 0 | 0 | 9/20/02 | 19014 | FALSE | CUSTOMER PAID WITH CASINO CHIPNEEDS TO BE REMOVED | ||
| 5012 | 1020 | 1151 | O | JAM | 11/13/02 | 12/31/99 | 11/13/02 | 12/31/99 | SAHARA & STRIP | IN | 100 | 2 | 2134 | FALSE | 1 | 0 | TRUE | FALSE | FALSE | 11/13/02 | 11/13/02 | 11/13/02 | 11/13/02 | 0 | 0 | 0 | 0 | 11/13/02 | 2159 | FALSE | CASINO CHIP USED INSTEAD | ||
| 5013 | 1030 | 2713 | D | A/C | 11/13/02 | 12/31/99 | 2201 | FALSE | 1 | 0 | FALSE | FALSE | FALSE | 0 | 0 | 0 | 0 | FALSE | AIR CONDITIONING PROBLEMS | ||||||||||||||
| 5027 | 1030 | 1151 | D | WATER | 12/9/02 | 12/31/99 | 1151 | FALSE | 1 | 0 | FALSE | FALSE | FALSE | 0 | 0 | 0 | 0 | FALSE | TEST | ||||||||||||||
| 5028 | 1010 | 1151 | M | AIR | 12/18/02 | 12/31/99 | 12/18/02 | 12/31/99 | AT STOP | S | 101 | 1 | 1151 | FALSE | 1 | 0 | TRUE | FALSE | FALSE | 12/18/02 | 12/18/02 | 12/18/02 | 1 | 0 | 0 | 0 | FALSE | THIS IS A TEST | |||||
| 5029 | 1010 | 1151 | D | FIRE | 12/18/02 | 12/31/99 | 1151 | FALSE | 1 | 0 | FALSE | FALSE | FALSE | 0 | 0 | 0 | 0 | FALSE | SEAT ON FIRE |
ProblemTypeHistoryTable
| VehicleNumber | ProblemType | LastOccurred | MilesSinceLastOccurrence | MaxMilesBetweenOccurrence | MinMilesBetweenOccurrence | LifeToDateVehicleMiles |
| 1010 | D | 12/18/02 | 0 | 0 | 0 | 341330 |
| 1010 | M | 12/18/02 | 830 | 830 | 830 | 341330 |
| 1010 | O | 9/20/02 | 130 | 450 | 130 | 341080 |
| 1020 | M | 11/13/02 | 0 | 0 | 0 | 346453 |
| 1020 | O | 11/13/02 | 468 | 468 | 468 | 346453 |
| 1030 | D | 12/9/02 | 0 | 0 | 0 | 343657 |
| 1030 | M | 2/8/02 | 0 | 0 | 0 | 343657 |
File details come from the government source that posted it. Updated .