To keep data entry clean and standardized, avoid letting technicians type whatever they want into the Status column. Select the cells in . Go to the Data tab in Excel -> Data Validation . Under Allow, select List . In the Source box, type: Pass, Fail, Action Required, N/A . 4. Apply Conditional Formatting for High Visibility
A cold pump is misleading. As it reaches operating temperature, components expand and change; this is when you find the true picture of its health. The major categories of these "hot checks" are:
Essential for calculating the next due date. pump preventive maintenance checklist excel hot
Check for high-pitched squealing (bearing wear) or a sound resembling pumping gravel (cavitation).
Maintaining a pump handling hot fluids (such as boiler feed water, domestic hot water loops, or thermal oil) requires strict attention to variables that ambient-temperature systems do not face: To keep data entry clean and standardized, avoid
For quantitative parameters like bearing temperature or motor current, use logical formulas to compare the entered operator value against the maximum thresholds established in your Master Asset Registry tab.
Measure current to ensure the motor isn't overloaded. Tips for Optimizing Your Excel Checklist Under Allow, select List
Highlight risks automatically. Set up a conditional formatting rule that turns a row light red if the Status is "Fail," or if a recorded temperature exceeds a safe threshold (e.g., >180°F for standard bearings).