A comprehensive pump preventive maintenance program, organized by daily to annual tasks, is essential for extending equipment life and preventing failures, with Excel-based checklists offering dynamic tracking, scheduling, and data validation. Key elements of an active ("hot") checklist include asset details, task scheduling, completion logs, and automated status updates to ensure timely maintenance. Detailed checklists and customizable templates are available from resources such as FMX.
This story follows "Hot" Harry, a veteran plant manager who learned the hard way that a "hot" pump is a cry for help. After a catastrophic failure, Harry built a robust Excel-based Preventive Maintenance (PM) Checklist to keep his facility running cool. The Story of "Hot" Harry and the Near-Boil
Harry’s nickname wasn't from his temper; it was because he always seemed to be dealing with overheating equipment. One Tuesday, Pump 4—the heart of the cooling system—seized after running at a scorching 95°C (203°F). The repair cost thousands, and the downtime cost millions.
That night, Harry sat down with an Excel sheet and a mission: No more surprises.
He realized that "hot" pumps are usually the result of neglected lubrication, misalignment, or clogged suction. He created a dynamic tracker with specific, color-coded tasks to ensure every pump stays within its optimal thermal and operational range. Harry’s Pump PM Checklist (Excel Format) pump preventive maintenance checklist excel hot
To keep your pumps from getting "hot," use this structure for your Excel template. You can set up columns for Responsibility 1. Daily Thermal & Visual Checks (The "Hot" Indicators) Bearing Temperature
: Measure bearing and motor temperatures. Excess heat indicates overload or lubrication issues. Vibration Analysis
: Check for unusual noise or vibration, which can lead to friction and heat. Leak Detection
: Inspect exterior for leaks or weeping, especially around seals and gaskets. Surroundings Mistake #3: Ignoring the "Hot" Data Collecting vibration
: Clean debris from the pump area to ensure proper airflow and cooling. 2. Monthly Mechanical Integrity Lubrication Management
: Check lubricant levels and condition. Replenish or replace if contaminated or low. Alignment & Mounting
: Verify the alignment between the pump and motor. Misalignment is a primary cause of heat buildup. Seal Inspection : Inspect mechanical seals for wear or signs of damage. 3. Quarterly & Annual Overhaul Pump Maintenance Checklist – Tasks, Tips & Template 2026
Here’s a draft piece you can use or adapt for creating a Pump Preventive Maintenance Checklist in Excel. It’s written as an instructional / template guide – suitable for a blog post, SOP, or internal memo. vibration (via accelerometer)
Collecting vibration data but never looking at the trend graph is pointless. Fix: Set a reminder in Outlook for the Maintenance Manager every Friday to review the "Alert" tab.
Create columns in Excel with these headers:
| Frequency | Component | Action Item | Acceptable Criteria | Hot-Service Note | |-----------|-----------|-------------|----------------------|-------------------| | Daily | Bearing housing | Check temp (thermometer or IR gun) | <180°F (82°C) for oil; <200°F for grease | Log trend; sudden rise = failure warning | | Daily | Mechanical seal | Check for leakage | <5 drops/min from drain port | More leakage = seal faces warped from heat | | Daily | Casing | Listen for cavitation/rumbling | Smooth sound | High temp reduces NPSH – check suction pressure | | Weekly | Lubrication | Check oil level & color | Clear, no milky/black | Hot pumps need synthetic oil if >200°F | | Weekly | Coupling alignment | Thermal alignment check (when hot) | Within 0.002" parallel, 0.001" angular | Align at operating temp, not cold | | Monthly | Jacketed stuffing box | Verify cooling flow | Flow visible in sight glass or temp <150°F | Critical for hot pumps | | Monthly | Vibration | Measure at DE & NDE | <0.2 in/s RMS (ISO 10816-3) | Increase frequency if hot service | | Quarterly | Flush piping | Check for coking / scale | No blockage in flush line | Common in hot oil pumps | | Annually | Internal clearances | Measure wear rings | Within pump manual spec | Heat accelerates wear |
Pass/Fail/Limit) and conditional formatting to highlight Fail.