| Time | Pump Tag | Task | Hot-Specific Note | OK (1) | Fail (0) | Temp Reading | | :--- | :--- | :--- | :--- | :--- | :--- | :--- | | 07:00 | P-101 | Bearing Housing Temp | Max 180°F for grease; 200°F for oil | ☐ | ☐ | 172°F | | 07:00 | P-101 | Mechanical Seal Flush | Is the flush cool? Hot flush = seal failure imminent | ☐ | ☐ | 210°F | | 07:00 | P-101 | Stuffing Box Leakage | Hot fluid should drip at 10-20 drops/min; steam flashing? | ☐ | ☐ | N/A | | 07:00 | P-101 | Casing Condensate | Steam tracing on? Cold spots indicate plugging | ☐ | ☐ | N/A | | 07:00 | P-101 | Baseplate Contact | Listen for "ticking" - thermal expansion scraping | ☐ | ☐ | N/A |
They programmed the Excel sheet to calculate the required cold offset. After two alignment cycles logged in Excel, the pump ran for 18 months without failure. Savings: $200,000 in downtime and parts. Conclusion: Don’t Run Hot Without a Smart Sheet A standard checklist is a PDF. A pump preventive maintenance checklist in Excel (hot service optimized) is a living predictive tool. It tracks thermal trends, warns you of alignment drift, and forces operators to respect thermodynamics. pump preventive maintenance checklist excel hot
Use Data Validation (Data > Data Validation > List) for the "OK/Fail" column so operators just click a dropdown (Yes/No). Add a column for "Notes" to log unusual noises (e.g., "Loud rattling after 2 hours of hot run"). Tab 3: Monthly Thermal Alignment & Vibration This is the most critical tab for hot pumps. Most engineers align pumps cold, but they run hot. | Time | Pump Tag | Task |
=C2-D2 Use conditional formatting: If E2 > 3 mils, turn red. This tells you the pump’s support legs are not accommodating for thermal expansion. Cold spots indicate plugging | ☐ | ☐
Open Excel. Create the four tabs above. Input your pump data. Set the conditional formatting to turn red at 200°F bearing temps. You will immediately reduce your Mean Time Between Failures (MTBF).