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

File Type Posted
RFP 25-005 EAMS - Appendix D - Current Asset List.xlsx XLSX spreadsheet
RFP 25-005 EAMS - Appendix J - Inventory Report.xlsx XLSX spreadsheet
RFP 25-005 EAMS - Appendix K - Vehicle Maintenance Report.xlsx XLSX spreadsheet
RFP 25-005 EAMS - Exhibit 9 - Price Proposal.xlsx XLSX spreadsheet
RFP 25-005 EAMS Exhibits 1-10 Proposer Forms~1.pdf PDF
RFP 25-005 EAMS - Appendix E - Work Order Example.pdf PDF
RFP 25-005 EAMS - Appendix G - Purchase Order Example.pdf PDF
RFP 25-005 EAMS Intructions to Proposers_Final~1.pdf PDF
RFP 25-005 EAMS - Exhibit 9 - Price Proposal~1.xlsx XLSX spreadsheet
Brand Name Specificaion AppcCrcle.pdf PDF
RFP 25-005 EAMS - Appendix A - General Terms and Conditions.pdf PDF
RFP 25-005 EAMS - Appendix B - Master Software as a Service Contract.pdf PDF
RFP 25-005 EAMS - Appendix I - System Database Report.xlsx XLSX spreadsheet
Addendum 1_25-005 RFP EAMS.pdf PDF
RFP 25-005 EAMS - Appendix C - Federal Terms and Conditions.pdf PDF
RFP 25-005 EAMS - Appendix F - Work Orders Report.xlsx XLSX spreadsheet
RFP 25-005 EAMS - Appendix H - Purchase Order Report.xlsx XLSX spreadsheet
RFP 25-005 EAMS - Exhibit 10 Compliance Matrix.xlsx XLSX spreadsheet
Addendum 2_25-005 RFP EAMS.pdf PDF
Addendum 3_25-005 RFP EAMS.pdf PDF
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

WorkOrderNoManagerTitle
1V38692James DudinProlo

ProblemCodeTable

ProblemCodeDescriptionWorkOrderClassPrioritySeqNo
A/CAIR CONDITIONING PROBLEMS10
ACCACCIDENT10
AIRAIR PRESSURE PROBLEMS10
DENTSCRATCHES & DENTS10
FIREFIRE ON BUS10
FUELFUEL PROBLEMS10
HEHOT ENGINE10
HEATHEATING PROBLEMS10
JAMFARE BOX JAMMED10
OILOIL PRESSURE PROBLEMS10
TIRESTIRE PROBLEMS10
TRANSTRANSMISSION PROBLEMS10
WATERLOW COOLANT10

ProblemDefectTable

VehicleNumberReportDateReportTimeSequenceNoOperatorNoProblemTypeProblemCodeWorkOrderNoWorkOrderLineNoOpenedByDispatcherNoVandalismFlagComment
101012/16/0212/31/9911151DAIR1151FALSEAIR PRESSURE PROBLEMS
102012/10/0212/31/9911151DACC1151FALSEACCIDENT

ProblemHistoryTable

VehicleNumberProblemTypeProblemCodeLastOccurredMilesSinceLastOccurrenceMaxMilesBetweenOccurrenceMinMilesBetweenOccurrenceLifeToDateVehicleMiles
1010DFIRE12/18/02000341330
1010MAIR12/18/02000341330
1010MJAM2/6/02000340500
1010OJAM9/20/02130450130341080
1020MJAM11/13/02000346453
1020OJAM11/13/02468468468346453
1030DA/C11/13/02000343657
1030DWATER12/9/02000343657
1030MACC2/8/02000343657

ProblemMasterTable

WorkOrderNoVehicleNumberOperatorProblemTypeProblemCodeReportDateReportTimeDispatchDateDispatchTimeLocationOfVehicleDirectionOfVehicleRouteWorkAssignmentDispatcherVandalismFlagClosedWorkOrderClassMinutesDelayedBusRepairedOnRoadFlagBusTowedInFlagEmergencyFlagDepartureFromGarageArrivalAtBusLocationBusReleasedScheduledRouteDepartureReplacementVehicleNoTripsLostPassengersDelayedRevenueMilesNonRevenueMilesMechanicReturnedMechanicNoSec15RoadcallFlagComment
5004102001122OJAM1/31/0212/31/991/31/0212/31/99MEADOWS MALLIN2041102FALSE10TRUEFALSEFALSE1/31/021/31/021/31/021/31/0200001/31/0210055FALSECASINO TOKEN STUCK IN BOX
50091010102OJAM2/6/0212/31/992/6/0212/31/99RAINBOW & SAHARAIN201162FALSE2/6/0210TRUEFALSEFALSE2/6/022/6/022/6/022/6/0200002/6/0201123FALSEAPPEARS TO BE CASINO TOKEN
50101030102MACC2/8/0212/31/992/8/0212/31/99HEREIN20001122FALSE2/8/0210TRUEFALSEFALSE0000FALSEACCIDENT
50111010102OJAM9/20/0212/31/999/20/0212/31/99SAHARA & RAINBOWIN100114011FALSE10TRUEFALSEFALSE9/20/029/20/029/20/029/20/0200009/20/0219014FALSECUSTOMER PAID WITH CASINO CHIPNEEDS TO BE REMOVED
501210201151OJAM11/13/0212/31/9911/13/0212/31/99SAHARA & STRIPIN10022134FALSE10TRUEFALSEFALSE11/13/0211/13/0211/13/0211/13/02000011/13/022159FALSECASINO CHIP USED INSTEAD
501310302713DA/C11/13/0212/31/992201FALSE10FALSEFALSEFALSE0000FALSEAIR CONDITIONING PROBLEMS
502710301151DWATER12/9/0212/31/991151FALSE10FALSEFALSEFALSE0000FALSETEST
502810101151MAIR12/18/0212/31/9912/18/0212/31/99AT STOPS10111151FALSE10TRUEFALSEFALSE12/18/0212/18/0212/18/021000FALSETHIS IS A TEST
502910101151DFIRE12/18/0212/31/991151FALSE10FALSEFALSEFALSE0000FALSESEAT ON FIRE

ProblemTypeHistoryTable

VehicleNumberProblemTypeLastOccurredMilesSinceLastOccurrenceMaxMilesBetweenOccurrenceMinMilesBetweenOccurrenceLifeToDateVehicleMiles
1010D12/18/02000341330
1010M12/18/02830830830341330
1010O9/20/02130450130341080
1020M11/13/02000346453
1020O11/13/02468468468346453
1030D12/9/02000343657
1030M2/8/02000343657

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