hvac preventive maintenance checklist template excel pdf

HVAC Preventive Maintenance Schedule and Service Log

This system provides a structured framework for tracking routine inspections and servicing of climate control assets. It is designed to ensure compliance with manufacturer specifications, extend equipment lifespan, and minimize operational downtime.

Cadence: Perform inspections [Quarterly/Bi-Annually/Annually]. Scope: Covers all [Facility Name] primary HVAC assets including AHUs, condensers, and filtration systems.

Column Definitions

• Asset ID: [Alphanumeric] Unique identifier for the unit.
• Equipment Type: [Text] Category of the system (e.g., AHU, RTU, Chiller).
• Last Service Date: [Date] The actual date the last maintenance was performed.
• Status: [Dropdown] Select from: "Completed", "Pending", "Overdue", or "Requires Repair".
• Technician Initials: [Text] Identifier for the person performing the work.
• Next Due Date: [Date] Calculated date based on the service interval.

Formulas

Calculate Next Due Date (6-month interval):

=EDATE([Last Service Date Cell], 6)

Count Overdue Items:

=COUNTIF([Status Column Range], "Overdue")

Flag Maintenance Needs (Conditional Logic):

=IF(TODAY()>[Next Due Date Cell], "ACTION REQUIRED", "UP TO DATE")

Conditional Formatting & Data Validation

1. Status Dropdown Validation: Select the "Status" column, go to Data > Data Validation, and select "List". Enter: Completed, Pending, Overdue, Requires Repair.
2. Overdue Highlight: Apply conditional formatting to the "Status" column. Set rule: Cell Value equal to "Overdue" and format with a Light Red fill and Dark Red text.
3. Upcoming Due Date Highlight: Apply conditional formatting to the "Next Due Date" column. Set formula: =AND([Next Due Date Cell]-TODAY()<=14, [Next Due Date Cell]-TODAY()>=0). Format with Yellow fill to alert that maintenance is due within 14 days.