skills.rest
CBoser
CBoserCOMMUNITY
Explore all skills by this author →
GitHub

ecir-report-analyzer

Analyze ECIR Excel reports for insights, trends, and patterns.

Updated Aug 27, 2026
Search Tags:#reports#insights#json#excel#trends#analyze#ecir
One-click install
npx skills add https://github.com/CBoser/ConstructionPlatform --skill ecir-report-analyzer
Or copy as Structured Prompt for Agent▼
Please help me install this Agent Skill.
Skill: ecir-report-analyzer
Source: https://github.com/CBoser/ConstructionPlatform/tree/main/docs/archive/skills/claude_skills/ECIR_Processing/ecir-report-analyzer/ecir-report-analyzer
Command: npx skills add https://github.com/CBoser/ConstructionPlatform --skill ecir-report-analyzer

SYSTEM DOCUMENTATION & REQUIREMENTS

💡 This Skill requires pandas, openpyxl, and includes scripts (resource) and references (resource) components.

What problem does it solve?

This skill analyzes completed ECIR (Engineering Change Impact Report) Excel files to extract actionable insights, identify trends, and detect patterns across single or multiple reports. It enables stakeholders to understand cost variances, change drivers, and the impact of engineering changes on project scope and suppliers.

Core Features & Use Cases

  • Single ECIR analysis: Extract header metrics, status distribution, and category impacts to summarize the report.
  • Multi-ECIR trend analysis: Compare multiple ECIRs to identify variance patterns, common change reasons, and supplier changes.
  • Use Case: Suppose you receive several ECIR reports; this skill can produce a concise executive summary and a JSON payload for downstream dashboards.
  • Output formats: Human-readable text or JSON for programmatic processing.

Quick Start

python scripts/analyze_ecir.py path/to/ecir.xlsx python scripts/compare_ecirs.py ecir1.xlsx ecir2.xlsx

Frequently Asked Questions about ecir-report-analyzer

High-intent search queries and answers about installing and using this skill.

FAQPage Schema
How do I analyze ECIR Excel reports to extract insights and trends?▼

Analyze ECIR Excel reports using Python scripts that read Header, Summary, and Detail_All sheets with pandas and openpyxl to extract cost variances, change drivers, status distribution, and category impacts as text or JSON output.

Can I compare multiple ECIR reports to identify variance patterns across them?▼

Yes, use the compare_ecirs.py script to run multi-ECIR trend analysis, which detects variance patterns, common change reasons, supplier changes, and produces executive summaries and JSON payloads for downstream dashboards.

What Excel sheet structure does this tool expect from ECIR files?▼

The tool reads standard ECIR workbooks containing three sheets: Header for report metadata, Summary for aggregated metrics, and Detail_All for line-item engineering changes and their impacts.

Do I need Python 3.9 or later to run ECIR analysis?▼

Yes, ECIR analysis requires Python 3.9 or higher along with pandas and openpyxl dependencies to read and process Excel files and compute insights.

What output formats does ECIR analysis support for downstream use?▼

The skill produces both human-readable text summaries for stakeholders and JSON-structured outputs for programmatic processing in dashboards or data pipelines.

Can this tool work with non-standard ECIR Excel layouts or custom column names?▼

The tool is designed for standard ECIR sheet structures; custom layouts or column names outside the Header, Summary, and Detail_All format may require modification to the analysis scripts.

Related Skills

Explore More Data & Analytics Skills→
rpoole-devrpoole-dev

datapack-builder

Extract, normalize, and standardize financial data into Excel workbooks.

Community
Advanced
kongaharshakongaharsha
1

create-viz

Generate publication-quality static and interactive charts from data.

Community
Intermediate
Wesley1600Wesley1600

Python Script Skill Template

Executes Python scripts that process CLI input and return JSON-formatted results.

Community
Basic
ailabs-393ailabs-393
438

business-analytics-reporter

Generates HTML or Markdown business analytics reports from CSV files.

Community
Intermediate