Excel Hot | Pump Preventive Maintenance Checklist

Pump Preventive Maintenance Checklist Excel Template

• Column I: Differential Pressure = =E2-D2 (If this drops 15%, schedule service)
• Column J: Efficiency % = =(Flow_Rate*Head)/3960 (If below 50%, blockage likely)
• Column K: Status = =IF(G2>180,"ALERT - Hot Bearing","Normal")

Week 1: The Baseline

Excel Formula for Thermal Growth (Cell E2):

=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.

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 pump preventive maintenance checklist excel hot

Hot Suggestion:

Create a VLOOKUP formula. When you select "P-101" in the dropdown, the "Seal Part Number" and "Bearing Part Number" automatically populate. Pump Preventive Maintenance Checklist Excel Template