punch list template for excel

Construction & Project Deficiency Tracking Log

This document serves as a centralized registry for identifying, tracking, and resolving outstanding work items or deficiencies before project closeout. It is designed for project managers, contractors, and site supervisors. Update this log daily during the final inspection phase and weekly during active remediation.

Project Deficiency Log

Column Definitions

• Item ID: Alphanumeric unique identifier (e.g., P-001).
• Description: Detailed explanation of the required corrective work.
• Location: Specific room, floor, or grid coordinate where the issue exists.
• Assigned To: Name of the trade partner or individual responsible for remediation.
• Priority: Urgency level (High, Medium, Low).
• Status: Current state of the item (Open, In Progress, Pending Inspection, Closed).
• Due Date: Target completion date for the specific task.

Essential Formulas

Calculate Percentage of Completion: Use this formula to track the ratio of closed items versus total items: =COUNTIF(F2:F100, "Closed") / COUNTA(A2:A100)

Identify Overdue Items: Flag items where the status is not "Closed" and the due date has passed (assuming current date is in cell Z1): =IF(AND(F2<>"Closed", G2<$Z$1), "OVERDUE", "On Track")

Data Validation & Formatting

1. Status Dropdown (Data Validation): Select the "Status" column, go to Data > Data Validation, and select "List". Enter: Open, In Progress, Pending Inspection, Closed.

2. Priority Color Coding (Conditional Formatting): Apply a "Highlight Cell Rule" to the Priority column:

• If text contains "High", set to Light Red Fill with Dark Red Text.
• If text contains "Medium", set to Yellow Fill with Dark Yellow Text.

3. Row Completion Strikethrough: Select the entire row range. Create a new Conditional Formatting rule using a formula: =$F2="Closed". Set the format to Strikethrough and Grey font color.