CSI MasterFormat Divisions 00–48 Spec & Submittal Shredder API

Shreds 500-page Project Manuals and Special Provisions into structured CSI Divisions 00–48 submittal logs, liquidated damages ($/day), retainage caps, and warranty terms.

{
  "spec_text": "SECTION 01 10 00 SUMMARY: Replace 4 prestressed bridge spans and place 68,000 tons of Item 341 Superpave HMA. Liquidated damages are $4,200/day.",
  "project_id": "TXDOT-CSJ-0015-13-412",
  "target_trade": "Heavy Civil / Highway & Bridge"
}

{
  "status": "success",
  "project_id": "TXDOT-CSJ-0015-13-412",
  "liquidated_damages_per_day_usd": 4200,
  "retainage_terms": "5.0% statutory public works retainage cap",
  "shredded_csi_divisions": [
    {
      "division": "Division 01 \u2014 General Requirements",
      "mandatory_submittals": [
        "Baseline Primavera P6 CPM Schedule (15 Days Post-NTP)"
      ]
    },
    {
      "division": "Division 03/05 \u2014 Concrete & Structural Steel",
      "mandatory_submittals": [
        "HPC Class S Mix Design",
        "AISC Shop Drawings & BABA Mill Certs"
      ]
    }
  ]
}

50-State DOT Historical Item Bid Tabulation & Spread Modeler API

Queries 36-month historical State DOT unit bid tabulations by pay item, state, and takeoff quantity to output low/median/75th-percentile unit prices ($/Ton, $/LF, $/CY) and Recommended Unit Bid.

{
  "state_code": "TX",
  "pay_item_description": "Dense-Graded Hot-Mix Asphalt (Superpave SP-C PG 76-22)",
  "unit": "TON",
  "quantity": 68000
}

{
  "status": "success",
  "state_code": "TX",
  "historical_36mo_lettings_sampled": 42,
  "unit_price_benchmarks": {
    "historical_winning_low_unit_usd": 117.59,
    "historical_median_bid_unit_usd": 127.02,
    "recommended_competitive_unit_bid_usd": 121.17
  },
  "unbalanced_bid_guardrail": "Compliant under 23 CFR 635.102"
}

Davis-Bacon (29 CFR 5) & State Prevailing Wage Fringe Calculator API

Maps project county and construction type to SAM.gov WDOL / state prevailing wage base hourly rates, health/pension fringes, weighted crew burden, and Form WH-347 certified payroll compliance.

{
  "state_code": "TX",
  "county": "Travis County",
  "construction_type": "Highway",
  "estimated_crew_hours": 14500
}

{
  "status": "success",
  "wage_determination_reference": "TX20260028 (Highway Construction \u2014 29 CFR Part 5)",
  "weighted_composite_hourly_usd": 54.21,
  "fully_burdened_crew_hourly_usd": 64.24,
  "total_estimated_prevailing_labor_usd": 931480.0
}

52-Portal Live State DOT Lettings, USACE & Public Works Feed API

Exposes pre-vetted heavy-civil, highway, bridge, utility, and commercial construction lettings across all 50 State DOTs, USACE Civil Works, and Municipal portals.

{
  "state": "TX",
  "limit": 5
}

{
  "status": "success",
  "portals_monitored": 52,
  "count": 12,
  "lettings": [
    {
      "project_id": "TXDOT-CSJ-0015-13-412",
      "agency": "Texas Department of Transportation (TxDOT)",
      "engineers_estimate_usd": 18450000.0,
      "dbe_goal_pct": 11.5
    }
  ]
}

Build America, Buy America (BABA / 23 CFR 635.410) Material Auditor API

Audits Bill of Materials (BOM) submittals against federal/FHWA domestic iron, steel, and manufactured product thresholds (>55% US cost) and OMB M-24-02 De Minimis waivers.

{
  "project_id": "USACE-W912EP-27-B-0004",
  "funding_agency": "FHWA / USACE Infrastructure"
}

{
  "status": "success",
  "project_id": "USACE-W912EP-27-B-0004",
  "overall_baba_posture": "COMPLIANT (99.3% Domestic US Melt/Manufacture; 0.7% OMB M-24-02 De Minimis)"
}

DOT DBE (49 CFR Part 26) Subcontractor & Good Faith Effort Generator API

Calculates certified DBE/MBE/WBE participation credit (100% subcontractor vs. 60% regular dealer), verifies Commercially Useful Function (CUF), and builds Good Faith Effort (GFE) logs.

{
  "project_id": "TXDOT-CSJ-0015-13-412",
  "total_bid_amount_usd": 17850000.0,
  "dbe_goal_pct": 11.5
}

{
  "status": "success",
  "contract_dbe_goal_pct": 11.5,
  "achieved_dbe_participation_pct": 12.18,
  "goal_compliance_status": "GOAL MET OR EXCEEDED \u2014 Full responsiveness under 49 CFR 26.53"
}

AIA G702 / G703 Schedule of Values (SOV) & Retainage Billing API

Converts bid items into a balanced, front-load-compliant AIA Document G702 Application for Payment and G703 Continuation Sheet with retainage math.

{
  "project_id": "TXDOT-CSJ-0015-13-412",
  "contractor_name": "Webber Civil Constructors LLC",
  "contract_sum_usd": 17850000.0,
  "retainage_pct": 5.0
}

{
  "status": "success",
  "g702_summary": {
    "line_1_original_contract_sum_usd": 17850000.0,
    "line_4_total_completed_and_stored_to_date_usd": 3748500.0,
    "line_8_current_payment_due_usd": 3561075.0
  }
}

Miller Act (40 U.S.C. 3131) & Surety Bond Capacity Underwriter API

Evaluates contractor working capital, net worth, and uncompleted WIP backlog to underwrite Single/Aggregate Surety Bond limits and SF-24/SF-25 bond premiums.

{
  "contractor_name": "Apex Civil & Utility Constructors LLC",
  "current_assets_usd": 4850000.0,
  "current_liabilities_usd": 2150000.0,
  "net_worth_equity_usd": 4200000.0,
  "target_project_bid_usd": 12400000.0
}

{
  "status": "success",
  "verified_working_capital_usd": 2700000.0,
  "single_project_bond_limit_usd": 18900000.0,
  "aggregate_work_program_limit_usd": 42000000.0,
  "miller_act_approval_status": "APPROVED FOR BID BOND (SF-24) & 100% PERFORMANCE/PAYMENT BONDS"
}

Construction RFI, Differing Site Conditions & AIA G701 Change Order API

Analyzes plan discrepancies and Type I/II differing subsurface conditions (FAR 52.236-2), models Critical Path Time-Impact Analysis (TIA), and prices AIA G701 Change Orders.

{
  "project_id": "CALTRANS-04-2Q7404",
  "issue_summary": "Encountered uncharted 48-inch cast-iron main at Bent 4 micropile elevation -38.0 ft.",
  "direct_cost_impact_usd": 184500.0,
  "critical_path_delay_days": 14
}

{
  "status": "success",
  "entitlement_basis": "Type I Differing Site Condition (FAR 52.236-2 / DOT Spec 104.02)",
  "pco_pricing_summary": {
    "total_aia_g701_change_order_request_usd": 214296.75
  }
}

OSHA 29 CFR 1926, USACE EM 385-1-1 AHA & Insurance EMR Auditor API

Generates trade-specific Activity Hazard Analyses (AHA), Site-Specific Safety Plans (SSSP), and Experience Modification Rate (EMR) bid-eligibility audits.

{
  "project_id": "USACE-W912EP-27-B-0004",
  "contractor_emr_current": 0.78
}

{
  "status": "success",
  "contractor_emr_current": 0.78,
  "prequalification_eligibility": "TIER-1 PREFERRED (< 0.85 EMR \u2014 Eligible for all USACE & DOT Lettings)"
}

DOT Planholder List, Competitor Bid Behavior & MLOT Analyzer API

Analyzes official DOT project planholder lists against historical head-to-head letting results to predict the winning low bid, Margin Left on Table (MLOT), and optimal markup.

{
  "project_id": "TXDOT-CSJ-0015-13-412",
  "engineers_estimate_usd": 18450000.0,
  "planholders": [
    "Webber LLC",
    "Granite Construction Inc.",
    "Jordan Foster Construction LLC",
    "Lone Star Paving Co.",
    "Capital Excavation Company"
  ]
}

{
  "status": "success",
  "predicted_winning_low_bid_usd": 16881750.0,
  "predicted_margin_left_on_table_usd": 523334.25,
  "recommended_markup_pct": 7.8
}

Trade Subcontractor Invitation to Bid (ITB), Scope Gap & AIA A401 API

Generates trade-specific Subcontractor Scope Checklists, exclusions to reject, and AIA A401 subcontract flow-down clauses.

{
  "project_id": "TXDOT-CSJ-0015-13-412",
  "trade_package": "Division 26 \u2014 Roadway ITS Fiber Duct Bank & High-Mast Illumination",
  "prime_contractor": "Webber Civil Constructors LLC"
}

{
  "status": "success",
  "trade_package": "Division 26 \u2014 Roadway ITS Fiber Duct Bank & High-Mast Illumination",
  "mandatory_scope_inclusions": [
    "100% turnkey furnishing, trenching & OTDR testing",
    "Davis-Bacon WH-347 & BABA compliance"
  ]
}