Check suction and discharge pressure gauges to ensure they align with the pump’s design curve. 2. Weekly & Monthly Inspections (System Health)
Routine checks prevent unexpected breakdowns, keeping production lines running.
When building your Excel workbook, organize the columns to capture the lifecycle of the maintenance task. Your header row should include: pump preventive maintenance checklist excel hot
Use Data Validation to make a dropdown menu for the Status column. Limit choices to , Pending , or Overdue to keep your data clean.
Which would you prefer?
Listen for unusual grinding, clicking, or cavitation sounds (which sound like pumping marbles).
Measure the motor’s amperage and voltage. Unusually high draw indicates mechanical resistance or electrical faults. Check suction and discharge pressure gauges to ensure
| 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 |
(assuming weekly = 7 days) =IF(FREQUENCY="Weekly", LastDone+7, IF(FREQUENCY="Monthly", LastDone+30, LastDone+365)) When building your Excel workbook, organize the columns
Use checkboxes and timestamps to verify completion.
You can add specific parameters for your pump model (e.g., specific torque values or pressure ratings).