Skip to main content
skill CX Codex

daily-progress-report — Claude Code skill: reports and setup

daily-progress-report builds daily site progress reports from structured project data, covering work, labor, equipment, and weather. Useful for keeping field records consistent.

MIT 137 installs ★ 434 updated 2026-10-19

Install into Claude Code · Skills CLI (Vercel) All methods and platforms ↓
npx skills add datadrivenconstruction/DDC_Skills_for_AI_Agents_in_Construction --skill daily-progress-report -a claude-code
Open on GitHub

What daily-progress-report does

This skill creates a daily report for a project, date, weather conditions, temperatures, work activities, labor entries, and equipment. It also stores delays, safety incidents, visitors, and deliveries. Each activity can include planned and actual quantities, a location, crew size, worked hours, and notes.

Its Python implementation defines data structures for activities, labor, equipment, weather, work status, and the report itself. It calculates totals for workers, man-hours, overtime, equipment hours, activity states, safety incidents, and deliveries. An Excel export uses pandas with openpyxl, while activity status follows the planned-versus-actual quantity.

The skill requires the python3 executable. Without it, the skill will not start.

What it helps with

  • assemble a daily site progress report
  • record completed and delayed work activities
  • calculate man-hours and overtime
  • track equipment hours
  • export a report to Excel

Example prompts for the agent

  • Create a daily progress report from the project’s work, labor, equipment, and weather data.
  • Add a work activity with its planned quantity, actual quantity, location, crew size, and hours worked.
  • Calculate the report summary for workers, man-hours, overtime, equipment hours, and delayed activities.

How to install daily-progress-report

1Skills CLI (Vercel)

npx skills add datadrivenconstruction/DDC_Skills_for_AI_Agents_in_Construction --skill daily-progress-report -a claude-code

2Manually: put the files in place

~/.claude/skills/daily-progress-report/SKILL.md

Copy the whole skill folder; for one project use .claude/skills/daily-progress-report/

Step by step, with commands for each platform: How to install skills in Claude Code: five ways

Questions about daily-progress-report

How do I install daily-progress-report in Claude Code?

Run npx skills add datadrivenconstruction/DDC_Skills_for_AI_Agents_in_Construction --skill daily-progress-report -a claude-code. The installed skill will be available at ~/.claude/skills/daily-progress-report/SKILL.md.

What does daily-progress-report do?

It builds daily reports from site data covering work, labor, equipment, weather, delays, safety incidents, visitors, and deliveries. It also calculates summary metrics and supports Excel export.

How does the skill assign a work status?

An activity is marked completed when actual quantity reaches planned quantity. Partial progress is in progress, while zero actual quantity against a positive plan is delayed.

Source text

SKILL.md · MIT
---
name: "daily-progress-report"
description: "Generate automated daily progress reports from site data. Track work completed, labor hours, equipment usage, and weather conditions."
homepage: "https://datadrivenconstruction.io"
metadata: {"openclaw": {"emoji": "📊", "os": ["darwin", "linux", "win32"], "homepage": "https://datadrivenconstruction.io", "requires": {"bins": ["python3"]}}}
---
# Daily Progress Report Generator

## Business Case

### Problem Statement
Site managers spend hours creating daily reports:
- Manual data collection
- Inconsistent formats
- Delayed submissions
- Missing information

### Solution
Automated daily progress report generation from structured site data inputs.

## Technical Implementation

```python
import pandas as pd
from datetime import datetime, date
from typing import Dict, Any, List
from dataclasses import dataclass
from enum import Enum


class WeatherCondition(Enum):
    CLEAR = "clear"
    CLOUDY = "cloudy"
    RAIN = "rain"
    SNOW = "snow"
    WIND = "wind"
    EXTREME = "extreme"


class WorkStatus(Enum):
    COMPLETED = "completed"
    IN_PROGRESS = "in_progress"
    DELAYED = "delayed"
    NOT_STARTED = "not_started"


@dataclass
class WorkActivity:
    activity_id: str
    description: str
    location: str
    planned_qty: float
    actual_qty: float
    unit: str
    status: WorkStatus
    crew_size: int
    hours_worked: float
    notes: str = ""


@dataclass
class LaborEntry:
    trade: str
    company: str
    workers: int
    hours: float
    overtime_hours: float = 0


@dataclass
class EquipmentEntry:
    equipment_type: str
    equipment_id: str
    hours_used: float
    status: str  # active, idle, maintenance
    operator: str = ""


@dataclass
class DailyReport:
    report_date: date
    project_name: str
    project_number: str
    weather: WeatherCondition
    temperature_high: float
    temperature_low: float
    work_activities: List[WorkActivity]
    labor: List[LaborEntry]
    equipment: List[EquipmentEntry]
    delays: List[str]
    safety_incidents: int
    visitors: List[str]
    deliveries: List[str]
    prepared_by: str


class DailyProgressReporter:
    """Generate daily progress reports."""

    def __init__(self, project_name: str, project_number: str):
        self.project_name = project_name
        self.project_number = project_number

    def create_report(self,
                      report_date: date,
                      weather: WeatherCondition,
                      temp_high: float,
                      temp_low: float,
                      prepared_by: str) -> DailyReport:
        """Create new daily report."""

        return DailyReport(
            report_date=report_date,
            project_name=self.project_name,
            project_number=self.project_number,
            weather=weather,
            temperature_high=temp_high,
            temperature_low=temp_low,
            work_activities=[],
            labor=[],
            equipment=[],
            delays=[],
            safety_incidents=0,
            visitors=[],
            deliveries=[],
            prepared_by=prepared_by
        )

    def add_work_activity(self,
                          report: DailyReport,
                          activity_id: str,
                          description: str,
                          location: str,
                          planned_qty: float,
                          actual_qty: float,
                          unit: str,
                          crew_size: int,
                          hours_worked: float,
                          notes: str = ""):
        """Add work activity to report."""

        # Determine status
        if actual_qty >= planned_qty:
            status = WorkStatus.COMPLETED
        elif actual_qty > 0:
            status = WorkStatus.IN_PROGRESS
        elif actual_qty == 0 and planned_qty > 0:
            status = WorkStatus.DELAYED
        else:
            status = WorkStatus.NOT_STARTED

        activity = WorkActivity(
            activity_id=activity_id,
            description=description,
            location=location,
            planned_qty=planned_qty,
            actual_qty=actual_qty,
            unit=unit,
            status=status,
            crew_size=crew_size,
            hours_worked=hours_worked,
            notes=notes
        )

        report.work_activities.append(activity)

    def add_labor(self,
                  report: DailyReport,
                  trade: str,
                  company: str,
                  workers: int,
                  hours: float,
                  overtime_hours: float = 0):
        """Add labor entry."""

        report.labor.append(LaborEntry(
            trade=trade,
            company=company,
            workers=workers,
            hours=hours,
            overtime_hours=overtime_hours
        ))

    def add_equipment(self,
                      report: DailyReport,
                      equipment_type: str,
                      equipment_id: str,
                      hours_used: float,
                      status: str,
                      operator: str = ""):
        """Add equipment entry."""

        report.equipment.append(EquipmentEntry(
            equipment_type=equipment_type,
            equipment_id=equipment_id,
            hours_used=hours_used,
            status=status,
            operator=operator
        ))

    def calculate_summary(self, report: DailyReport) -> Dict[str, Any]:
        """Calculate report summary metrics."""

        total_workers = sum(l.workers for l in report.labor)
        total_manhours = sum(l.workers * l.hours for l in report.labor)
        total_overtime = sum(l.workers * l.overtime_hours for l in report.labor)
        equipment_hours = sum(e.hours_used for e in report.equipment)

        completed = sum(1 for a in report.work_activities if a.status == WorkStatus.COMPLETED)
        in_progress = sum(1 for a in report.work_activities if a.status == WorkStatus.IN_PROGRESS)
        delayed = sum(1 for a in report.work_activities if a.status == WorkStatus.DELAYED)

        return {
            'total_workers': total_workers,
            'total_manhours': round(total_manhours, 1),
            'total_overtime': round(total_overtime, 1),
            'equipment_hours': round(equipment_hours, 1),
            'activities_completed': completed,
            'activities_in_progress': in_progress,
            'activities_delayed': delayed,
            'safety_incidents': report.safety_incidents,
            'deliveries_count': len(report.deliveries)
        }

    def export_to_excel(self, report: DailyReport, output_path: str) -> str:
        """Export report to Excel."""

        with pd.ExcelWriter(output_path, engine='openpyxl') as writer:
            # Header
            header_df = pd.DataFrame([{
                'Project': report.project_name,
                'Project #': report.project_number,
                'Date': report.report_date,
                'Weather': report.weather.value,
                'High Temp': report.temperature_high,
                'Low Temp': report.temperature_low,
                'Prepared By': report.prepared_by
            }])
            header_df.to_excel(writer, sheet_name='Summary', index=False)

            # Work Activities
            if report.work_activities:
                activities_df = pd.DataFrame([
                    {
                        'Activity ID': a.activity_id,
                        'Description': a.description,
                        'Location': a.location,
                        'Planned': a.planned_qty,
                        'Actual': a.actual_qty,
                        'Unit': a.unit,
                        'Status': a.status.value,
                        'Crew': a.crew_size,
                        'Hours': a.hours_worked,
                        'Notes': a.notes
                    }
                    for a in report.work_activities
                ])
                activities_df.to_excel(writer, sheet_name='Work Activities', index=False)

            # Labor
            if report.labor:
                labor_df = pd.DataFrame([
                    {
                        'Trade': l.trade,
                        'Company': l.company,
                        'Workers': l.workers,
                        'Hours': l.hours,
                        'Overtime': l.overtime_hours,
                        'Total Hours': l.workers * (l.hours + l.overtime_hours)
                    }
                    for l in report.labor
                ])
                labor_df.to_excel(writer, sheet_name='Labor', index=False)

            # Equipment
            if report.equipment:
                equip_df = pd.DataFrame([
                    {
                        'Type': e.equipment_type,
                        'ID': e.equipment_id,
                        'Hours': e.hours_used,
                        'Status': e.status,
                        'Operator': e.operator
                    }
                    for e in report.equipment
                ])
                equip_df.to_excel(writer, sheet_name='Equipment', index=False)

        return output_path

    def generate_text_report(self, report: DailyReport) -> str:
        """Generate text version of report."""

        summary = self.calculate_summary(report)

        lines = [
            f"DAILY PROGRESS REPORT",
            f"=" * 50,
            f"Project: {report.project_name}",
            f"Project #: {report.project_number}",
            f"Date: {report.report_date}",
            f"Prepared by: {report.prepared_by}",
            f"",
            f"WEATHER CONDITIONS",
            f"-" * 30,
            f"Conditions: {report.weather.value}",
            f"Temperature: {report.temperature_low}°C - {report.temperature_high}°C",
            f"",
            f"SUMMARY",
            f"-" * 30,
            f"Total Workers: {summary['total_workers']}",
            f"Total Man-hours: {summary['total_manhours']}",
            f"Equipment Hours: {summary['equipment_hours']}",
            f"Activities Completed: {summary['activities_completed']}",
            f"Activities In Progress: {summary['activities_in_progress']}",
            f"Activities Delayed: {summary['activities_delayed']}",
            f"Safety Incidents: {summary['safety_incidents']}",
        ]

        if report.delays:
            lines.extend([f"", f"DELAYS", f"-" * 30])
            for delay in report.delays:
                lines.append(f"• {delay}")

        return "\n".join(lines)
```

## Quick Start

```python
from datetime import date

# Initialize reporter
reporter = DailyProgressReporter("Office Tower A", "PRJ-2024-001")

# Create report
report = reporter.create_report(
    report_date=date.today(),
    weather=WeatherCondition.CLEAR,
    temp_high=28,
    temp_low=18,
    prepared_by="John Smith"
)

# Add activities
reporter.add_work_activity(
    report,
    activity_id="A-101",
    description="Pour concrete slab Level 3",
    location="Level 3, Zone A",
    planned_qty=150,
    actual_qty=150,
    unit="m3",
    crew_size=8,
    hours_worked=10
)

# Add labor
reporter.add_labor(report, "Concrete", "ABC Concrete Co", 8, 10, 2)

# Export
reporter.export_to_excel(report, "daily_report.xlsx")
```

## Common Use Cases

### 1. Generate Text Summary
```python
text = reporter.generate_text_report(report)
print(text)
```

### 2. Track Delays
```python
report.delays.append("Weather delay - rain from 14:00-16:00")
report.delays.append("Material delivery late by 2 hours")
```

### 3. Calculate Metrics
```python
summary = reporter.calculate_summary(report)
print(f"Productivity: {summary['total_manhours']} man-hours")
```

## Resources
- **DDC Book**: Chapter 4.1 - Site Data Collection

© datadrivenconstruction · MIT · datadrivenconstruction/DDC_Skills_for_AI_Agents_in_Construction

Similar skills

All skills for Data and databases →
daily-production-report official anthropics daily-production-report — a skill for Claude Code and Codex that generates daily morning manufacturing reports. Runs before morning production standups using raw MES and ERP data exports. CX Codex +1 ★ 47,914repo stars daily-news-report sickn33 daily-news-report — a Claude Code skill that walks a preset URL list, keeps the solid technical pieces, and turns them into a Markdown report for one day. It is a single run: one pass, one NewsReport/ folder, then it stops. CX Codex +1 1,000installs report-to-google-doc official Data Analytics Maintainers report-to-google-doc turns an existing HTML analytics report into a DOCX and uploads it to Google Drive. Handy when the report has to reach someone as a link. CX Codex GP ChatGPT +1 ★ 8,052repo stars daily-news-60s vikiboss daily-news-60s is a Claude Code skill that fetches 15 curated Chinese-language news items and a daily quote via API, for the latest digest or a historical date. CX Codex +1 497installs batch-script-progress official github batch-script-progress keeps generated batch scripts observable: start, progress, per-item failures and a final summary. Useful when a script chews through files in silence. CX Codex +1 4installs people-report official anthropics people-report — a skill to generate headcount, attrition, diversity, and org health reports from HR data. Pulls snapshots by team, analyzes turnover trends and flight risk indicators across the organization. CX Codex +1 2,800installs

From the same set156

The whole set →
critical-path-analyzer critical-path-analyzer analyzes project schedule networks to calculate the critical path, determine float values, and identify near-critical tasks that risk delaying deadlines. CX Codex +1 141installs drone-site-survey drone-site-survey processes drone survey data for construction sites: generates orthomosaics, calculates stockpile volumes, and links survey data with BIM models. CX Codex +1 141installs budget-variance-analyzer budget-variance-analyzer is a skill for Claude Code that compares budget figures with actual costs, flags overruns, and forecasts a project's final cost. It tracks spending variances by project line item. CX Codex +1 139installs cwicr-cost-calculator The cwicr-cost-calculator skill calculates construction costs using CWICR resource-based methodology, separating labor, materials, and equipment expenses into auditable components. CX Codex +1 138installs safety-inspection safety-inspection is a Claude Code skill for managing construction site inspections with checklists, hazard records, and incident reports. It tracks corrective actions and supports compliance reporting. CX Codex +1 137installs rvt-to-excel rvt-to-excel is a Claude Code skill that exports Revit model data, element properties, and quantities to Excel for reports and analytics workflows. CX Codex +1 135installs bim-validation-report The bim-validation-report skill runs automated quality checks on BIM model elements, flagging missing attributes, bad naming, and geometric defects. It produces a structured compliance report directly in your agent workspace. CX Codex +1 133installs safety-inspection-checklist Generates and runs digital safety inspection checklists for construction sites. Captures inspection data, photos, tracks defects, and produces compliance reports automatically. CX Codex +1 133installs

Project sponsors

Companies that keep this analytics open