Pump Preventive Maintenance Checklist Excel Hot Access

For qualitative checks (like leaks or unusual sounds), use to restrict inputs to a clean dropdown menu: Pass , Fail , Action Required .

Hyperlink the pump serial number to a PDF of the manufacturer's manual stored in your company drive.

For those looking to download or build a custom tool, several providers offer pre-filled Excel spreadsheets: pump preventive maintenance checklist excel hot

: Cells should turn red when a task is overdue or when a reading deviates more than 25% from its baseline.

Shut down the pump, let it reach ambient temperature, and run a laser alignment check. Hot water pumps must often be aligned with an intentional cold offset so that they expand into perfect alignment at operating temperature. 2. Coupling Inspection For qualitative checks (like leaks or unusual sounds),

Feel the bearing housing and motor for excessive heat.

Utilize a handheld digital vibration pen or analyzer. Record velocity (in/s or mm/s) at the pump and motor bearing caps. Track these numbers against ISO 10816 standards to catch bearing wear early. 2. Lubrication Management Shut down the pump, let it reach ambient

A well-designed Excel spreadsheet transforms a static list into a living tool. Here's how to structure yours:

Inspect motor starters and tighten electrical connections. 💡 Pro-Tips for Your Excel Tracker

Create columns in Excel with these headers:

| Column | Heading | Description | |--------|---------|-------------| | A | Date | Date PM performed | | B | Task ID | Link to master checklist | | C | Pump Tag | e.g., P-101 | | D | Reading 1 – Pressure (psi) | Actual gauge reading | | E | Reading 2 – Vibration (mm/s) | If available | | F | Reading 3 – Temp (°C or °F) | Bearing or casing temp | | G | Corrective Action Taken? | Yes/No + notes | | H | Performed By | Initials or name | | I | Next Due Date | Auto-calc based on frequency |