punch list template excel free

Construction and Project Deficiency Tracking Log

This document serves as the master record for identifying, tracking, and resolving outstanding work items prior to project closeout. The scope covers all physical deficiencies, site corrections, and pending administrative tasks. This log should be updated daily by the [Project Manager] or [Site Superintendent] to ensure real-time status visibility for all stakeholders.

Project Deficiency Log

Column Definitions

• ID: [Numeric] Unique identifier for each deficiency.
• Item Description: [Text] Detailed explanation of the work required.
• Location: [Text] Specific area or room number where the work is located.
• Assigned To: [Text/Dropdown] Name of the responsible party or trade.
• Priority: [Dropdown] Select from: High, Medium, Low.
• Status: [Dropdown] Select from: Open, In Progress, Completed, Deferred.
• Due Date: [Date] Deadline for item completion (Format: YYYY-MM-DD).

Essential Formulas

Calculate completion percentage (Paste in a summary cell):

=COUNTIF(F2:F100, "Completed") / COUNTA(F2:F100)

Count remaining high-priority items:

=COUNTIFS(E2:E100, "High", F2:F100, "<>Completed")

Identify overdue items (Assuming today's date is in cell A1):

=IF(AND(G2 < TODAY(), F2 <> "Completed"), "OVERDUE", "On Track")

Formatting and Validation Rules

1. Status Conditional Formatting: Apply a "Color Scale" or "Highlight Cell Rule" to the Status column. Set "Completed" to green fill, "In Progress" to yellow, and "Open" to red.
2. Priority Data Validation: Select the Priority column, go to Data > Data Validation, and select "List." Enter: High, Medium, Low.
3. Date Validation: Select the Due Date column, go to Data > Data Validation, and select "Date." Set the criteria to "Is valid date" to ensure consistent formatting for sorting.