=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.
In hot pump reliability, you aren't fighting friction—you're fighting heat. Keep your checklist as hot as your process. Need the actual Excel file? Download our free read-only template at [YourCompanyLink] or build your own using the formulas and tables provided above.
You can instantly see which pumps are running outside their thermal envelope. Use Excel’s Conditional Formatting (Home > Conditional Formatting > Color Scales) to turn cells red when Delta T exceeds 40°F. Tab 2: Daily/Weekly Hot Service Checklist This is your operator’s go-to sheet. Print it or use a tablet. Every cell should be a checkbox or a data entry field. 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.
=(TODAY()-C2)/(D2*30) Format as percentage. How to Download & Customize Your "Hot" Excel Checklist You can build the above in 10 minutes, but to save time, search for " Pump preventive maintenance checklist excel hot template " or use the structure above to create your own. =C2-D2 Use conditional formatting: If E2 > 3
| Component | Hot Service Life (Months) | Install Date | Last Temp Reading | % Life Used (Excel Calc) | Action | | :--- | :--- | :--- | :--- | :--- | :--- | | Carbon Graphite Bushings | 6 | 2/1/2025 | 450°F | 83% | Order by 8/1 | | High-Temp Grease (Synthetic) | 3 | 5/1/2025 | 380°F | 33% | OK | | Metal Bellows Seal | 12 | 1/15/2025 | 600°F | 45% | OK | | Motor Fan (Heat degraded) | 8 | 3/10/2025 | 350°F | 62% | Inspect |
| Date | Pump ID | Cold Alignment (mils) | Hot Alignment (mils) | Thermal Growth (mils) | Vibration Velocity (in/s) | Info | | :--- | :--- | :--- | :--- | :--- | :--- | :--- | | 6/1/2025 | P-101 | 2.0 | 5.5 | 3.5 (FAIL) | 0.45 | Re-shimmed | | 7/1/2025 | P-101 | 2.0 (Cold offset) | 2.1 (Running hot) | 0.1 (PASS) | 0.22 | Good | Keep your checklist as hot as your process
Let’s build the ultimate hot pump PM checklist inside an Excel workbook. Before we dive into the Excel template, we must address the thermal factor. Standard ambient-temperature pump checks are not sufficient for hot service.