Skill Creator

CBoser

15 published skills · 0 GitHub stars across the catalog. View on GitHub ↗

data-extraction-sync

CBoser's avatarfrom CBoser

Extract data from complex Excel layouts and synchronize across multiple sheets. Use when parsing non-standard Excel structures, extracting data from visual/formatted layouts, synchronizing data between sheets bidirectionally, detecting and tracking changes, mapping data between different structures, or maintaining consistency across related worksheets. Includes patterns for whiteboard extraction, change detection, update propagation, and data validation during sync.

excel-vba-refactoring

CBoser's avatarfrom CBoser

Comprehensive guide for refactoring and modernizing Excel VBA projects. Use when users need to clean up legacy VBA code, implement modular architecture, add error handling, create working mode systems, transition from color-based to field-based status management, implement centralized configuration, add validation and business rules, or prepare VBA projects for future migration to web platforms.

construction-api-developer

CBoser's avatarfrom CBoser

Specialized skill for developing RESTful APIs for the construction project management platform. Use when building backend services for job management, plan specifications (40 plans, 567 options), PDSS integration, schedule coordination, contract/PO tracking, or subdivision management (31 subdivisions). Includes API design patterns, data models, business logic, validation rules, and integration endpoints specific to construction workflows.

construction-po-reconciliation

CBoser's avatarfrom CBoser

Automated reconciliation of construction purchase orders across multiple PO types (Framing, Options, Siding, Add-ons). Use when working with BuildPro POs, tracking combined contracts, analyzing option pricing variance by plan, detecting missing POs, calculating EPO estimates, or reconciling actual vs expected costs for residential construction projects.

ecir-report-analyzer

CBoser's avatarfrom CBoser

Analyze completed ECIR (Engineering Change Impact Report) Excel files to extract insights, identify trends, and detect patterns across single or multiple reports. Use when the user asks to analyze ECIR reports, find trends in ECIRs, compare multiple ECIRs, identify cost variance patterns, or generate insights from completed ECIR Excel files. This skill works with the output files from the ECIR Advanced Tool.

construction-testing-qa

CBoser's avatarfrom CBoser

Specialized skill for testing and quality assurance of the construction project management platform. Use when writing unit tests, integration tests, E2E tests, performance tests, or security tests for job management, plan specifications (40 plans, 567 options), workflows, APIs, or UI components. Includes test strategies, coverage requirements, test data generation, CI/CD integration, and quality gates specific to construction workflows.

csv-validator

CBoser's avatarfrom CBoser

Validates and fixes BOM CSV files for ECIR tool compatibility. Use when users need to check CSV files before running ECIR comparisons, fix CSV formatting issues, ensure required columns exist, or diagnose why ECIR tool fails to process a CSV file.

construction-ui-components

CBoser's avatarfrom CBoser

Specialized skill for building React UI components for the construction project management platform. Use when creating interfaces for dashboard, job management, plan specification (40 plans, 567 options selector), schedule board, PDSS tracking, subdivision portfolio (31 subdivisions), or contract management. Includes component patterns, state management, form handling, real-time updates, and mobile-responsive designs specific to construction workflows.

readyframe-material-calculator

CBoser's avatarfrom CBoser

Calculate exact material quantities for ReadyFrame panelized wall framing systems using proven formulas for plates, studs, trimmers, headers, and opening components. Use when calculating ReadyFrame materials, determining quantities for takeoffs, computing stud counts, calculating plate requirements, sizing opening components, optimizing stock lengths, or validating material estimates. Also use for questions like "how many studs needed", "calculate plates for this wall", "what header size for opening", or "trimmer quantities for windows".

plan-change-analyzer

CBoser's avatarfrom CBoser

Analyzes before/after architectural and structural plan PDFs to identify engineering changes, focusing on framing and hardware modifications. Use when users need to compare plan revisions, identify changes before creating BOMs, validate ECIR line items against plans, document visual evidence of engineering changes, or train estimators on plan-to-cost relationships. Handles 20-30 page residential plans (architectural/structural sheets only).

html-dashboard-export

CBoser's avatarfrom CBoser

Create professional Excel dashboards and export data to styled HTML reports. Use when users need to create interactive dashboards in Excel, export Excel data to HTML with modern CSS styling, generate reports with visualizations, create printable schedules, build responsive web reports from Excel data, or design data visualization interfaces. Includes patterns for stat cards, navigation bars, responsive tables, charts, and multi-page report layouts.

construction-workflow-automation

CBoser's avatarfrom CBoser

Specialized skill for implementing automated workflows and business logic for the construction platform. Use when building workflow engines for job lifecycle management (plan start → completion), PDSS document routing, option validation logic, schedule optimization, contract approvals, notification systems, or time-based triggers. Includes state machines, business rules, notification patterns, and integration orchestration for construction processes.

construction-data-migration

CBoser's avatarfrom CBoser

Specialized skill for migrating Excel-based construction project management data to web platform. Use when the user needs to transform, validate, or migrate data from Excel systems including Plan Start Sheets (40 plans, 567 options), PDSS workflows, job coordination data, contract tracking, time entries (3,355+ records), or subdivision data (31 subdivisions). Also use for data structure design, ETL pipeline creation, and data validation for construction workflows.

supplypro-api

CBoser's avatarfrom CBoser

Integration with Hyphen SupplyPro SPConnect API v13 for construction supply order management. Use when working with SupplyPro orders, BuildPro integration, sending order responses, delivery notifications (ASN), handling OAuth authentication, or automating construction material order workflows. Supports order acceptance/rejection, shipment tracking, and two-way ERP integration.

readyframe-takeoff-validator

CBoser's avatarfrom CBoser

Validates ReadyFrame material takeoffs against all system rules and specifications to catch errors before materials are ordered. Use when validating takeoffs, checking material quantities, reviewing ReadyFrame compliance, verifying plate ratios, checking stud counts, validating opening components, ensuring grade assignments are correct, or when asked to "check this takeoff", "validate materials", "review for errors", or "does this look right". Critical for quality assurance before ordering materials.