cwicr-historical-cost
Track and analyze historical cost data using CWICR. Compare actual vs estimated costs, build project cost database, and improve future estimates.
Install / Use
npx skills add datadrivenconstruction/DDC_Skills_for_AI_Agents_in_Construction --skill cwicr-historical-costInstalls into whichever agent you are using.
SKILL.md
Installable skill definition
Quality Score
Category
Data & AnalyticsSupported Platforms
Our assessment of cwicr-historical-cost
cwicr-historical-cost scores 91/100 on our quality scale, 269th of 599 Data & Analytics skills we index (top 45%).
Its SKILL.md is 15 KB long, well organised into 16 sections with 5 code examples: a thorough specification that gives an agent plenty to work with.
It has 333 GitHub stars, a meaningful sign that others use it.
Maintenance, license and trust
- The repository was last updated about 3 months ago, so cwicr-historical-cost is actively maintained.
- Our last check on 2026-11-20 found the source still online.
- It is released under the MIT license, a permissive license that allows use, modification and commercial use with attribution.
- Its trust signals score 100/100, with no cautions. These come from repository metadata, not a code audit — read the skill file before letting an agent act on it.
Safety scan
No issues foundOur scan of the whole file found no instruction hijacking, hidden characters, credential access, data exfiltration or destructive commands. An AI review of the same text found nothing harmful.
AI review by kimi-k2.7-code on 2026-10-06. Automated pattern scan on 2026-10-05. It catches known dangerous patterns, not every risk — read a skill before letting an agent act on it.
cwicr-historical-cost compared with similar skills
All 4 of these similar skills score higher than cwicr-historical-cost; compare them before choosing.
| Skill | Score | Stars | Updated | Format |
|---|---|---|---|---|
| cwicr-historical-cost (this skill)by datadrivenconstruction | 91 | 333 | 3mo ago | SKILL.md |
| Agent-Reachby Panniantong | 100 | 113.3k | 12d ago | CLAUDE.md |
| headroomby headroomlabs-ai | 100 | 80.2k | today | CLAUDE.md |
| Scraplingby D4Vinci | 100 | 104.4k | 2d ago | MCP Server |
| crawl4aiby unclecode | 100 | 87.6k | today | MCP Server |
Frequently asked questions
- How do I install cwicr-historical-cost?
- Run
npx skills add datadrivenconstruction/DDC_Skills_for_AI_Agents_in_Construction --skill cwicr-historical-cost. The install tabs above show the steps for each supported agent. - Which AI agents does cwicr-historical-cost work with?
- It is written for Universal, as a SKILL.md file. Other agents that read the same format can often use it too.
- Is cwicr-historical-cost safe to use?
- Our scan of the whole file found no instruction hijacking, hidden characters, credential access, data exfiltration or destructive commands. An AI review of the same text found nothing harmful. It is MIT-licensed and scores 100/100 on trust signals. Skills are instructions an agent will follow, so read the file before installing it and do not approve commands you do not understand.
- Is cwicr-historical-cost still maintained?
- The repository was last updated about 3 months ago, so cwicr-historical-cost is actively maintained.
Skill content
View source on GitHubname: "cwicr-historical-cost" description: "Track and analyze historical cost data using CWICR. Compare actual vs estimated costs, build project cost database, and improve future estimates." homepage: "https://datadrivenconstruction.io" metadata: {"openclaw": {"emoji": "🗄️", "os": ["darwin", "linux", "win32"], "homepage": "https://datadrivenconstruction.io", "requires": {"bins": ["python3"]}}}
CWICR Historical Cost Tracker
Business Case
Problem Statement
Improving estimates requires:
- Actual cost feedback
- Historical comparisons
- Trend analysis
- Lessons learned
Solution
Track actual costs against CWICR estimates, build historical database, and use data to improve future estimating accuracy.
Business Value
- Accuracy improvement - Learn from actuals
- Benchmarking - Project comparisons
- Trend analysis - Cost movement patterns
- Organizational knowledge - Cost database
Technical Implementation
import pandas as pd
import numpy as np
from typing import Dict, Any, List, Optional
from dataclasses import dataclass, field
from datetime import datetime, date
from enum import Enum
import json
class ProjectStatus(Enum):
"""Project status."""
ESTIMATED = "estimated"
IN_PROGRESS = "in_progress"
COMPLETED = "completed"
CANCELLED = "cancelled"
@dataclass
class CostRecord:
"""Historical cost record."""
project_id: str
project_name: str
work_item_code: str
quantity: float
estimated_cost: float
actual_cost: float
variance: float
variance_percent: float
completion_date: date
notes: str = ""
@dataclass
class ProjectCostSummary:
"""Project cost summary."""
project_id: str
project_name: str
project_type: str
location: str
status: ProjectStatus
estimated_total: float
actual_total: float
variance: float
variance_percent: float
start_date: date
completion_date: Optional[date]
item_count: int
class CWICRHistoricalCost:
"""Track historical costs using CWICR data."""
def __init__(self, cwicr_data: pd.DataFrame = None):
self.cwicr = cwicr_data
self._projects: Dict[str, ProjectCostSummary] = {}
self._records: List[CostRecord] = []
if cwicr_data is not None:
self._index_cwicr()
def _index_cwicr(self):
"""Index CWICR data."""
if 'work_item_code' in self.cwicr.columns:
self._cwicr_index = self.cwicr.set_index('work_item_code')
else:
self._cwicr_index = None
def add_project(self,
project_id: str,
project_name: str,
project_type: str,
location: str,
estimated_total: float,
start_date: date) -> str:
"""Add new project to historical database."""
summary = ProjectCostSummary(
project_id=project_id,
project_name=project_name,
project_type=project_type,
location=location,
status=ProjectStatus.ESTIMATED,
estimated_total=estimated_total,
actual_total=0,
variance=0,
variance_percent=0,
start_date=start_date,
completion_date=None,
item_count=0
)
self._projects[project_id] = summary
return project_id
def record_actual_cost(self,
project_id: str,
work_item_code: str,
quantity: float,
actual_cost: float,
completion_date: date = None,
notes: str = "") -> CostRecord:
"""Record actual cost for work item."""
# Get estimated cost from CWICR
estimated_unit_cost = 0
if self._cwicr_index is not None and work_item_code in self._cwicr_index.index:
item = self._cwicr_index.loc[work_item_code]
labor = float(item.get('labor_cost', 0) or 0)
material = float(item.get('material_cost', 0) or 0)
equipment = float(item.get('equipment_cost', 0) or 0)
estimated_unit_cost = labor + material + equipment
estimated_cost = estimated_unit_cost * quantity
variance = actual_cost - estimated_cost
variance_pct = (variance / estimated_cost * 100) if estimated_cost > 0 else 0
record = CostRecord(
project_id=project_id,
project_name=self._projects.get(project_id, {}).project_name if project_id in self._projects else "",
work_item_code=work_item_code,
quantity=quantity,
estimated_cost=round(estimated_cost, 2),
actual_cost=round(actual_cost, 2),
variance=round(variance, 2),
variance_percent=round(variance_pct, 1),
completion_date=completion_date or date.today(),
notes=notes
)
self._records.append(record)
# Update project summary
if project_id in self._projects:
proj = self._projects[project_id]
proj.actual_total += actual_cost
proj.variance = proj.actual_total - proj.estimated_total
proj.variance_percent = (proj.variance / proj.estimated_total * 100) if proj.estimated_total > 0 else 0
proj.item_count += 1
proj.status = ProjectStatus.IN_PROGRESS
return record
def complete_project(self, project_id: str, completion_date: date = None):
"""Mark project as completed."""
if project_id in self._projects:
self._projects[project_id].status = ProjectStatus.COMPLETED
self._projects[project_id].completion_date = completion_date or date.today()
def get_work_item_history(self, work_item_code: str) -> Dict[str, Any]:
"""Get historical data for specific work item."""
records = [r for r in self._records if r.work_item_code == work_item_code]
if not records:
return {'work_item_code': work_item_code, 'records': 0}
variances = [r.variance_percent for r in records]
actual_costs = [r.actual_cost / r.quantity if r.quantity > 0 else 0 for r in records]
return {
'work_item_code': work_item_code,
'records': len(records),
'average_variance_pct': round(np.mean(variances), 1),
'variance_std': round(np.std(variances), 1),
'average_actual_unit_cost': round(np.mean(actual_costs), 2),
'min_actual_unit_cost': round(min(actual_costs), 2),
'max_actual_unit_cost': round(max(actual_costs), 2),
'projects': list(set(r.project_id for r in records)),
'trend': 'increasing' if len(records) > 2 and actual_costs[-1] > actual_costs[0] else 'stable'
}
def get_accuracy_metrics(self) -> Dict[str, Any]:
"""Calculate overall estimating accuracy metrics."""
if not self._records:
return {}
variances = [r.variance_percent for r in self._records]
# Accuracy by category
by_category = {}
for record in self._records:
category = record.work_item_code.split('-')[0] if '-' in record.work_item_code else 'Other'
if category not in by_category:
by_category[category] = []
by_category[category].append(record.variance_percent)
category_accuracy = {
cat: {
'average_variance': round(np.mean(vals), 1),
'count': len(vals)
}
for cat, vals in by_category.items()
}
return {
'total_records': len(self._records),
'average_variance_pct': round(np.mean(variances), 1),
'variance_std': round(np.std(variances), 1),
'within_5pct': sum(1 for v in variances if abs(v) <= 5) / len(variances) * 100,
'within_10pct': sum(1 for v in variances if abs(v) <= 10) / len(variances) * 100,
'overestimated_pct': sum(1 for v in variances if v < 0) / len(variances) * 100,
'underestimated_pct': sum(1 for v in variances if v > 0) / len(variances) * 100,
'by_category': category_accuracy
}
def suggest_adjustment_factors(self) -> Dict[str, float]:
"""Suggest adjustment factors based on historical variance."""
factors = {}
for record in self._records:
category = record.work_item_code.split('-')[0] if '-' in record.work_item_code else 'Other'
if category not in factors:
factors[category] = []
if record.estimated_cost > 0:
actual_factor = record.actual_cost / record.estimated_cost
factors[category].append(actual_factor)
return {
cat: round(np.mean(vals), 3)
for cat, vals in factors.items()
if len(vals) >= 3 # Require minimum data points
}
def compare_projects(self,
project_ids: List[str] = None) -> pd.DataFrame:
"""Compare multiple projects."""
if project_ids:
projects = [self._projects[pid] for pid in project_ids if pid in self._projects]
else:
projects = list(self._projects.values())
if not projects:
return pd.DataFrame()
return pd.DataFrame([
{
'Project ID': p.project_id,
'Project Name': p.project_name,
'Type': p.project_type,
'Location': p.location,
'Status': p.status.value,
'Estimated': p.estimated_total,
'Actual': p.actual_total,
'Variance': p.variance,
'Variance %': p.variance_percent,
'Items': p.item_count
}
for p in projects
])
def get_benchmarks_by_type(self, project_type: str) -> Dict[str, Any]:
"""Get cost benchmarks for project type."""
projects = [p for p in self._projects.values() if p.project_type == project_type]
if not projects:
return {}
actuals = [p.actual_total for p in projects if p.status == ProjectStatus.COMPLETED]
return {
'project_type': project_type,
'completed_projects': len(actuals),
'average_cost': round(np.mean(actuals), 2) if actuals else 0,
'min_cost': round(min(actuals), 2) if actuals else 0,
'max_cost': round(max(actuals), 2) if actuals else 0,
'average_variance': round(np.mean([p.variance_percent for p in projects]), 1)
}
def export_historical_data(self, output_path: str) -> str:
"""Export historical data to Excel."""
with pd.ExcelWriter(output_path, engine='openpyxl') as writer:
# Projects
if self._projects:
projects_df = self.compare_projects()
projects_df.to_excel(writer, sheet_name='Projects', index=False)
# Records
if self._records:
records_df = pd.DataFrame([
{
'Project': r.project_id,
'Work Item': r.work_item_code,
'Quantity': r.quantity,
'Estimated': r.estimated_cost,
'Actual': r.actual_cost,
'Variance': r.variance,
'Variance %': r.variance_percent,
'Date': r.completion_date,
'Notes': r.notes
}
for r in self._records
])
records_df.to_excel(writer, sheet_name='Records', index=False)
# Accuracy metrics
metrics = self.get_accuracy_metrics()
if metrics:
metrics_df = pd.DataFrame([{
Truncated for display — read the full file on GitHub.
Related Skills
Agent-Reach
113.3kGive your AI agent eyes to see the entire internet. Read & search Twitter, Reddit, YouTube, GitHub, Bilibili, XiaoHongShu — one CLI, zero API fees.
headroom
80.2kCompress tool outputs, logs, files, and RAG chunks before they reach the LLM. 20% fewer tokens for coding agents, 60-95% fewer tokens for JSON, same answers. Library, proxy, MCP server.
Scrapling
104.4k🕷️ The BEST Web Scraping framework that handles everything from a single request to a full-scale crawl! Don't be shy, join here: https://discord.gg/EMgGbDceNQ and follow here for daily tips and tricks: https://x.com/Scrapling_dev
crawl4ai
87.6kOfficial Crawl4AI Cloud: a hosted web scraping, extraction, and search API for AI agents. Free API key, 1,000 credits a month, no card. Fully open source: this repo is the Apache-2.0 crawler that powers it, and you can self-host it.
Languages
Trust signals
From repository metadata: license, adoption, age and documentation. Not a code audit — see the Safety scan above for what the skill file itself contains.
