GENERATORS SPREADSHEET.xlsx

This is a generator maintenance tracking spreadsheet documenting inspection discrepancies, repair costs, and maintenance activities for multiple generators under the Department of Veterans Affairs contract J059 for Generator Maintenance & Load Banking Services.

The spreadsheet tracks nine generators from various manufacturers including DMT, Kohler, Cummins/Terex, Pramac, Caterpillar, and John Deere/SDMO models, with serial numbers, tag numbers, and identification numbers cross-referenced across multiple systems (GEN-TECH, VISTA, and internal databases). Repair activities documented span from February 2024 through May 2025, with costs ranging from $239.08 to $3,842.18 per repair item. Common discrepancies identified include battery replacements ($653.80-$711.70), belt replacements ($335.93-$2,662.73), air filter servicing, radiator maintenance and hose replacement ($906.12-$3,842.18), fuel system issues, and coolant services ($239.08-$800.15). Repairs were primarily performed by GEN-TECH with quote numbers referenced for tracking purposes. Notable entries include a canceled Messer service order exceeding $3,500 in June 2024, and multiple generators flagged for fuel sample polishing requirements in FY 25. Several repairs were completed in-house, while others required external vendor coordination through purchase orders and quote processes.