Skip to content

aiskillstore/marketplace / skills/1102tools-dev/igce-builder-cr

igce-builder-cr

Verified

Trigger for: cost-reimbursement IGCE, CR cost estimate, CPFF, CPAF, CPIF, cost-plus estimate, BAA estimate, fixed-fee analysis, award-fee analysis, incentive-fee analysis, proposed CR rate validation, cost-pool buildup, share-ratio scenario, price-reasonableness memo, or fair-and-reasonable analysis. Build auditable CR estimates using BLS OEWS wages, fringe/overhead/G&A/FCCM pools, contract-type-specific fee, GSA CALC+ positioning, and GSA Per Diem travel. Do NOT use for FFP, LH/T&M, grants, or cooperative agreements. Requires the bls-oews, gsa-calc, and gsa-perdiem MCP servers.

skill-report.json

View on GitHub
{
  "schema_version": "2.0",
  "meta": {
    "generated_at": "2026-08-24T12:41:32.269Z",
    "slug": "1102tools-dev-igce-builder-cr",
    "source_url": "https://github.com/1102tools-dev/federal-contracting-skills/tree/6c8edf1c45e63acd1bdbb276392924435dde28b3/skills/igce-builder-cr",
    "source_ref": "6c8edf1c45e63acd1bdbb276392924435dde28b3",
    "model": "codex",
    "analysis_version": "3.0.0",
    "source_type": "community",
    "content_hash": "c9dd352d42ef139ed0ea7793dd36e04d3ab108918ebb994252f9e9708de4de6b",
    "tree_hash": "d53114f06ed952dc51a0f8de705f2da043c622dd280db469aed65037bdfb40c6",
    "provenance": {
      "model_effective": "codex",
      "fallback_chain": [
        {
          "agent": "codex",
          "outcome": "success"
        }
      ],
      "analysis_version": "3.0.0"
    },
    "upstream_version_raw": null,
    "upstream_version_normalized": null,
    "upstream_version_source": "none",
    "upstream_version_status": "missing",
    "upstream_commit_sha": "6c8edf1c45e63acd1bdbb276392924435dde28b3"
  },
  "skill": {
    "name": "igce-builder-cr",
    "description": "Build auditable cost-reimbursement IGCE workbooks for CPFF, CPAF, and CPIF acquisitions. Combine BLS wages, indirect cost pools, fee scenarios, CALC+ benchmarks, and GSA travel data.",
    "summary": "Build and validate traceable CPFF, CPAF, and CPIF government cost estimates.",
    "icon": "📦",
    "author": "1102tools-dev",
    "license": "MIT",
    "tags": [
      "government-contracting",
      "cost-estimation",
      "IGCE",
      "spreadsheet",
      "acquisition"
    ],
    "supported_tools": [
      "claude",
      "codex",
      "claude-code"
    ],
    "risk_factors": [
      "external_commands",
      "filesystem"
    ],
    "category": "office"
  },
  "security_audit": {
    "risk_level": "safe",
    "is_blocked": false,
    "safe_to_publish": true,
    "analysis_status": "ok",
    "summary": "All 48 static findings are false positives after contextual review. The only subprocess call uses a fixed argument list without shell interpolation, while temporary files stay in a managed validation directory. No prompt injection, credential access, data exfiltration, reconnaissance, or malicious intent was found.",
    "remediation": [],
    "risk_factor_evidence": [
      {
        "factor": "external_commands",
        "evidence": [
          {
            "file": "scripts/validate_workbook.py",
            "line_start": 280,
            "line_end": 280
          },
          {
            "file": "SKILL.md",
            "line_start": 35,
            "line_end": 35
          },
          {
            "file": "SKILL.md",
            "line_start": 38,
            "line_end": 38
          },
          {
            "file": "SKILL.md",
            "line_start": 45,
            "line_end": 45
          },
          {
            "file": "SKILL.md",
            "line_start": 51,
            "line_end": 51
          },
          {
            "file": "SKILL.md",
            "line_start": 75,
            "line_end": 75
          },
          {
            "file": "SKILL.md",
            "line_start": 92,
            "line_end": 92
          },
          {
            "file": "SKILL.md",
            "line_start": 94,
            "line_end": 94
          },
          {
            "file": "SKILL.md",
            "line_start": 120,
            "line_end": 120
          },
          {
            "file": "SKILL.md",
            "line_start": 146,
            "line_end": 149
          },
          {
            "file": "SKILL.md",
            "line_start": 149,
            "line_end": 151
          },
          {
            "file": "SKILL.md",
            "line_start": 151,
            "line_end": 159
          },
          {
            "file": "SKILL.md",
            "line_start": 159,
            "line_end": 168
          },
          {
            "file": "SKILL.md",
            "line_start": 168,
            "line_end": 178
          },
          {
            "file": "SKILL.md",
            "line_start": 178,
            "line_end": 182
          },
          {
            "file": "SKILL.md",
            "line_start": 182,
            "line_end": 186
          },
          {
            "file": "SKILL.md",
            "line_start": 186,
            "line_end": 192
          },
          {
            "file": "SKILL.md",
            "line_start": 192,
            "line_end": 192
          },
          {
            "file": "SKILL.md",
            "line_start": 217,
            "line_end": 220
          }
        ]
      },
      {
        "factor": "filesystem",
        "evidence": [
          {
            "file": "scripts/validate_workbook.py",
            "line_start": 13,
            "line_end": 13
          },
          {
            "file": "scripts/validate_workbook.py",
            "line_start": 262,
            "line_end": 262
          },
          {
            "file": "scripts/validate_workbook.py",
            "line_start": 263,
            "line_end": 263
          },
          {
            "file": "scripts/validate_workbook.py",
            "line_start": 393,
            "line_end": 393
          },
          {
            "file": "scripts/validate_workbook.py",
            "line_start": 270,
            "line_end": 270
          },
          {
            "file": "testing.md",
            "line_start": 70,
            "line_end": 70
          },
          {
            "file": "testing.md",
            "line_start": 70,
            "line_end": 70
          }
        ]
      }
    ],
    "static_findings": [
      {
        "id": "sensitive:references/data-source-operations.md:165:certificate-key-files",
        "category": "sensitive",
        "severity": "high",
        "pattern": "Certificate/key files",
        "file": "references/data-source-operations.md",
        "line_start": 165,
        "line_end": 165,
        "snippet": "aggregations.labor_category.buckets[*].key"
      },
      {
        "id": "blocker:references/data-source-operations.md:29:system-reconnaissance",
        "category": "blocker",
        "severity": "low",
        "pattern": "System reconnaissance",
        "file": "references/data-source-operations.md",
        "line_start": 29,
        "line_end": 29,
        "snippet": "Serialize credentialed federal API calls and leave at least three seconds between them, including ca"
      },
      {
        "id": "blocker:references/data-source-operations.md:114:system-reconnaissance",
        "category": "blocker",
        "severity": "low",
        "pattern": "System reconnaissance",
        "file": "references/data-source-operations.md",
        "line_start": 114,
        "line_end": 114,
        "snippet": "The requested datatypes provide mean plus P10, P25, P50, P75, and P90. Valid operation datatypes inc"
      },
      {
        "id": "blocker:references/data-source-operations.md:133:system-reconnaissance",
        "category": "blocker",
        "severity": "low",
        "pattern": "System reconnaissance",
        "file": "references/data-source-operations.md",
        "line_start": 133,
        "line_end": 133,
        "snippet": "- Mid or journeyman: P50"
      },
      {
        "id": "blocker:references/workbook-specification.md:13:system-reconnaissance",
        "category": "blocker",
        "severity": "low",
        "pattern": "System reconnaissance",
        "file": "references/workbook-specification.md",
        "line_start": 13,
        "line_end": 13,
        "snippet": "Include `Travel Detail` even when travel is zero. Put `Travel Not Applicable` and numeric zero in th"
      },
      {
        "id": "blocker:references/wrap-rate-presets.md:7:system-reconnaissance",
        "category": "blocker",
        "severity": "low",
        "pattern": "System reconnaissance",
        "file": "references/wrap-rate-presets.md",
        "line_start": 7,
        "line_end": 7,
        "snippet": "| Component | Low | Mid | High | Application base |"
      },
      {
        "id": "blocker:scripts/recompute_expected_values.py:203:system-reconnaissance",
        "category": "blocker",
        "severity": "low",
        "pattern": "System reconnaissance",
        "file": "scripts/recompute_expected_values.py",
        "line_start": 203,
        "line_end": 203,
        "snippet": "raise InputError(f\"invalid JSON in {path}: {exc}\") from exc"
      },
      {
        "id": "external_commands:scripts/validate_workbook.py:280:python-subprocess-run",
        "category": "external_commands",
        "severity": "high",
        "pattern": "Python subprocess.run",
        "file": "scripts/validate_workbook.py",
        "line_start": 280,
        "line_end": 280,
        "snippet": "completed = subprocess.run(command, capture_output=True, text=True, timeout=120, check=False)"
      },
      {
        "id": "filesystem:scripts/validate_workbook.py:13:temp-file-creation",
        "category": "filesystem",
        "severity": "low",
        "pattern": "Temp file creation",
        "file": "scripts/validate_workbook.py",
        "line_start": 13,
        "line_end": 13,
        "snippet": "import tempfile"
      },
      {
        "id": "filesystem:scripts/validate_workbook.py:262:temp-file-creation",
        "category": "filesystem",
        "severity": "low",
        "pattern": "Temp file creation",
        "file": "scripts/validate_workbook.py",
        "line_start": 262,
        "line_end": 262,
        "snippet": "def recalculate_with_libreoffice(source: Path, executable: Path) -> tuple[tempfile.TemporaryDirector"
      },
      {
        "id": "filesystem:scripts/validate_workbook.py:263:temp-file-creation",
        "category": "filesystem",
        "severity": "low",
        "pattern": "Temp file creation",
        "file": "scripts/validate_workbook.py",
        "line_start": 263,
        "line_end": 263,
        "snippet": "temp = tempfile.TemporaryDirectory(prefix=\"cr-workbook-validation-\")"
      },
      {
        "id": "filesystem:scripts/validate_workbook.py:393:temp-file-creation",
        "category": "filesystem",
        "severity": "low",
        "pattern": "Temp file creation",
        "file": "scripts/validate_workbook.py",
        "line_start": 393,
        "line_end": 393,
        "snippet": "temp: tempfile.TemporaryDirectory[str] | None = None"
      },
      {
        "id": "filesystem:scripts/validate_workbook.py:270:python-shutil-operations",
        "category": "filesystem",
        "severity": "medium",
        "pattern": "Python shutil operations",
        "file": "scripts/validate_workbook.py",
        "line_start": 270,
        "line_end": 270,
        "snippet": "shutil.copy2(source, copied)"
      },
      {
        "id": "blocker:scripts/validate_workbook.py:48:system-reconnaissance",
        "category": "blocker",
        "severity": "low",
        "pattern": "System reconnaissance",
        "file": "scripts/validate_workbook.py",
        "line_start": 48,
        "line_end": 48,
        "snippet": "raise InputError(f\"invalid workbook cell reference: {reference}\")"
      },
      {
        "id": "external_commands:SKILL.md:35:ruby-shell-backtick-execution",
        "category": "external_commands",
        "severity": "medium",
        "pattern": "Ruby/shell backtick execution",
        "file": "SKILL.md",
        "line_start": 35,
        "line_end": 35,
        "snippet": "- Use neutral positional language such as `at CALC+ P77 (n=42)` or `above CALC+ P50 by 18%`."
      },
      {
        "id": "external_commands:SKILL.md:38:ruby-shell-backtick-execution",
        "category": "external_commands",
        "severity": "medium",
        "pattern": "Ruby/shell backtick execution",
        "file": "SKILL.md",
        "line_start": 38,
        "line_end": 38,
        "snippet": "- When the user supplies rationale or a determination, preserve it verbatim and label the resulting "
      },
      {
        "id": "external_commands:SKILL.md:45:ruby-shell-backtick-execution",
        "category": "external_commands",
        "severity": "medium",
        "pattern": "Ruby/shell backtick execution",
        "file": "SKILL.md",
        "line_start": 45,
        "line_end": 45,
        "snippet": "2. **CALC+ query signature:** Use `/v3/api/ceilingrates/` with `keyword=`. Never use `q=`; it silent"
      },
      {
        "id": "external_commands:SKILL.md:51:ruby-shell-backtick-execution",
        "category": "external_commands",
        "severity": "medium",
        "pattern": "Ruby/shell backtick execution",
        "file": "SKILL.md",
        "line_start": 51,
        "line_end": 51,
        "snippet": "8. **Aging formula:** Store BLS vintage and contract start as assumptions. Calculate month gap with "
      },
      {
        "id": "external_commands:SKILL.md:75:ruby-shell-backtick-execution",
        "category": "external_commands",
        "severity": "medium",
        "pattern": "Ruby/shell backtick execution",
        "file": "SKILL.md",
        "line_start": 75,
        "line_end": 75,
        "snippet": "The entire first response must be exactly the boundary block below. Begin with `I can provide` and a"
      },
      {
        "id": "external_commands:SKILL.md:92:ruby-shell-backtick-execution",
        "category": "external_commands",
        "severity": "medium",
        "pattern": "Ruby/shell backtick execution",
        "file": "SKILL.md",
        "line_start": 92,
        "line_end": 92,
        "snippet": "2. Workflows A and A+ require `bls-oews` wage, vintage, SOC, and metro operations plus `gsa-calc` su"
      },
      {
        "id": "external_commands:SKILL.md:94:ruby-shell-backtick-execution",
        "category": "external_commands",
        "severity": "medium",
        "pattern": "Ruby/shell backtick execution",
        "file": "SKILL.md",
        "line_start": 94,
        "line_end": 94,
        "snippet": "4. Before workbook creation, require `.xlsx` authoring, Python 3.10+, openpyxl, and the bundled vali"
      },
      {
        "id": "external_commands:SKILL.md:120:ruby-shell-backtick-execution",
        "category": "external_commands",
        "severity": "medium",
        "pattern": "Ruby/shell backtick execution",
        "file": "SKILL.md",
        "line_start": 120,
        "line_end": 120,
        "snippet": "Treat a user-reviewed table labeled `STAFFING HANDOFF TABLE` as approved input regardless of heading"
      },
      {
        "id": "external_commands:SKILL.md:146:ruby-shell-backtick-execution",
        "category": "external_commands",
        "severity": "medium",
        "pattern": "Ruby/shell backtick execution",
        "file": "SKILL.md",
        "line_start": 146,
        "line_end": 149,
        "snippet": "```text"
      },
      {
        "id": "external_commands:SKILL.md:149:ruby-shell-backtick-execution",
        "category": "external_commands",
        "severity": "medium",
        "pattern": "Ruby/shell backtick execution",
        "file": "SKILL.md",
        "line_start": 149,
        "line_end": 151,
        "snippet": "```"
      },
      {
        "id": "external_commands:SKILL.md:151:ruby-shell-backtick-execution",
        "category": "external_commands",
        "severity": "medium",
        "pattern": "Ruby/shell backtick execution",
        "file": "SKILL.md",
        "line_start": 151,
        "line_end": 159,
        "snippet": "At 1,880 productive hours, one 24x7x365 seat is `8,760 / 1,880 = 4.6596 FTE`; two seats are 9.3191. "
      },
      {
        "id": "external_commands:SKILL.md:159:ruby-shell-backtick-execution",
        "category": "external_commands",
        "severity": "medium",
        "pattern": "Ruby/shell backtick execution",
        "file": "SKILL.md",
        "line_start": 159,
        "line_end": 168,
        "snippet": "1. Call `detect_latest_year` and record the returned vintage."
      },
      {
        "id": "external_commands:SKILL.md:168:ruby-shell-backtick-execution",
        "category": "external_commands",
        "severity": "medium",
        "pattern": "Ruby/shell backtick execution",
        "file": "SKILL.md",
        "line_start": 168,
        "line_end": 178,
        "snippet": "```text"
      },
      {
        "id": "external_commands:SKILL.md:178:ruby-shell-backtick-execution",
        "category": "external_commands",
        "severity": "medium",
        "pattern": "Ruby/shell backtick execution",
        "file": "SKILL.md",
        "line_start": 178,
        "line_end": 182,
        "snippet": "```"
      },
      {
        "id": "external_commands:SKILL.md:182:ruby-shell-backtick-execution",
        "category": "external_commands",
        "severity": "medium",
        "pattern": "Ruby/shell backtick execution",
        "file": "SKILL.md",
        "line_start": 182,
        "line_end": 186,
        "snippet": "```text"
      },
      {
        "id": "external_commands:SKILL.md:186:ruby-shell-backtick-execution",
        "category": "external_commands",
        "severity": "medium",
        "pattern": "Ruby/shell backtick execution",
        "file": "SKILL.md",
        "line_start": 186,
        "line_end": 192,
        "snippet": "```"
      },
      {
        "id": "external_commands:SKILL.md:192:ruby-shell-backtick-execution",
        "category": "external_commands",
        "severity": "medium",
        "pattern": "Ruby/shell backtick execution",
        "file": "SKILL.md",
        "line_start": 192,
        "line_end": 192,
        "snippet": "Use `igce_benchmark` for statistics-only queries. Use `keyword_search` only when category buckets ar"
      },
      {
        "id": "external_commands:SKILL.md:217:ruby-shell-backtick-execution",
        "category": "external_commands",
        "severity": "medium",
        "pattern": "Ruby/shell backtick execution",
        "file": "SKILL.md",
        "line_start": 217,
        "line_end": 220,
        "snippet": "2. Run `scripts/validate_workbook.py <workbook> --expected <sidecar> --engine auto`."
      },
      {
        "id": "blocker:SKILL.md:55:system-reconnaissance",
        "category": "blocker",
        "severity": "low",
        "pattern": "System reconnaissance",
        "file": "SKILL.md",
        "line_start": 55,
        "line_end": 55,
        "snippet": "12. **Credentialed API pacing:** Serialize credentialed federal API calls and leave at least three s"
      },
      {
        "id": "blocker:SKILL.md:162:system-reconnaissance",
        "category": "blocker",
        "severity": "low",
        "pattern": "System reconnaissance",
        "file": "SKILL.md",
        "line_start": 162,
        "line_end": 162,
        "snippet": "4. Calculate aging from the returned vintage to contract start, store every assumption in the workbo"
      },
      {
        "id": "blocker:test.md:29:network-reconnaissance",
        "category": "blocker",
        "severity": "low",
        "pattern": "Network reconnaissance",
        "file": "test.md",
        "line_start": 29,
        "line_end": 30,
        "snippet": "- Formula-structure audit: pass"
      },
      {
        "id": "blocker:test.md:30:network-reconnaissance",
        "category": "blocker",
        "severity": "low",
        "pattern": "Network reconnaissance",
        "file": "test.md",
        "line_start": 30,
        "line_end": 31,
        "snippet": "- Independent cost, fee, and estimated-price recomputation: pass"
      },
      {
        "id": "blocker:test.md:31:network-reconnaissance",
        "category": "blocker",
        "severity": "low",
        "pattern": "Network reconnaissance",
        "file": "test.md",
        "line_start": 31,
        "line_end": 32,
        "snippet": "- LibreOffice formula execution and cached-value comparison: pass"
      },
      {
        "id": "blocker:test.md:41:network-reconnaissance",
        "category": "blocker",
        "severity": "low",
        "pattern": "Network reconnaissance",
        "file": "test.md",
        "line_start": 41,
        "line_end": 42,
        "snippet": "- Skill frontmatter validator: pass"
      },
      {
        "id": "blocker:test.md:43:network-reconnaissance",
        "category": "blocker",
        "severity": "low",
        "pattern": "Network reconnaissance",
        "file": "test.md",
        "line_start": 43,
        "line_end": 44,
        "snippet": "- Python compile and command-line help: pass"
      },
      {
        "id": "filesystem:testing.md:70:hidden-file-in-home-directory",
        "category": "filesystem",
        "severity": "high",
        "pattern": "Hidden file in home directory",
        "file": "testing.md",
        "line_start": 70,
        "line_end": 70,
        "snippet": "- Local `~/.claude/skills/igce-builder-cr/SKILL.md` post-Wave 1 inheritance"
      },
      {
        "id": "filesystem:testing.md:70:hidden-file-access",
        "category": "filesystem",
        "severity": "medium",
        "pattern": "Hidden file access",
        "file": "testing.md",
        "line_start": 70,
        "line_end": 70,
        "snippet": "- Local `~/.claude/skills/igce-builder-cr/SKILL.md` post-Wave 1 inheritance"
      },
      {
        "id": "blocker:testing.md:21:system-reconnaissance",
        "category": "blocker",
        "severity": "low",
        "pattern": "System reconnaissance",
        "file": "testing.md",
        "line_start": 21,
        "line_end": 21,
        "snippet": "| CPFF AFRL BAA (Dayton) | CPFF 8% | Detailed prompt: \"cpff for a BAA with AFRL out of Wright-Patt. "
      },
      {
        "id": "blocker:testing.md:22:system-reconnaissance",
        "category": "blocker",
        "severity": "low",
        "pattern": "System reconnaissance",
        "file": "testing.md",
        "line_start": 22,
        "line_end": 22,
        "snippet": "| CPAF HHS Claims (DC+Baltimore) | CPAF 3%+7% | Detailed prompt: \"cpaf igce for HHS O&M claims proce"
      },
      {
        "id": "blocker:testing.md:23:system-reconnaissance",
        "category": "blocker",
        "severity": "low",
        "pattern": "System reconnaissance",
        "file": "testing.md",
        "line_start": 23,
        "line_end": 23,
        "snippet": "| CPIF Sandia RF (Albuquerque) | CPIF 7.5% target, 80/20 over, 70/30 under | Detailed prompt: \"cpif "
      },
      {
        "id": "blocker:testing.md:65:system-reconnaissance",
        "category": "blocker",
        "severity": "low",
        "pattern": "System reconnaissance",
        "file": "testing.md",
        "line_start": 65,
        "line_end": 65,
        "snippet": "Each scenario had a 14-point binary assertion matrix covering skill activation, fee type selection, "
      },
      {
        "id": "blocker:testing.md:88:system-reconnaissance",
        "category": "blocker",
        "severity": "low",
        "pattern": "System reconnaissance",
        "file": "testing.md",
        "line_start": 88,
        "line_end": 88,
        "snippet": "- **CALC+ query optimizations:** keyword_search to igce_benchmark for stats-only; tier-matched keywo"
      },
      {
        "id": "blocker:testing.md:124:system-reconnaissance",
        "category": "blocker",
        "severity": "low",
        "pattern": "System reconnaissance",
        "file": "testing.md",
        "line_start": 124,
        "line_end": 124,
        "snippet": "14. **Sheet 5 travel skip-or-include contradiction resolved.** Prior copy said \"skip if no travel\" i"
      },
      {
        "id": "blocker:testing.md:183:system-reconnaissance",
        "category": "blocker",
        "severity": "low",
        "pattern": "System reconnaissance",
        "file": "testing.md",
        "line_start": 183,
        "line_end": 183,
        "snippet": "- **NASA KSC Jacobs CPIF with FPRA + FCCM + pass-through ODCs + asymmetric share ratios:** All 4 pat"
      }
    ],
    "finding_verdicts": [
      {
        "id": "sensitive:references/data-source-operations.md:165:certificate-key-files",
        "verdict": "false_positive",
        "confidence": 0.99,
        "reason": "The text is a CALC+ response field ending in .key. It does not reference certificate files, private keys, or credentials."
      },
      {
        "id": "blocker:references/data-source-operations.md:29:system-reconnaissance",
        "verdict": "false_positive",
        "confidence": 0.99,
        "reason": "This is rate-limit guidance for declared federal API calls. It discourages rapid requests and performs no system reconnaissance."
      },
      {
        "id": "blocker:references/data-source-operations.md:114:system-reconnaissance",
        "verdict": "false_positive",
        "confidence": 0.99,
        "reason": "The line documents valid BLS datatype identifiers. It contains no host, process, account, or network discovery instruction."
      },
      {
        "id": "blocker:references/data-source-operations.md:133:system-reconnaissance",
        "verdict": "false_positive",
        "confidence": 0.99,
        "reason": "This is a wage-percentile convention for mid-level labor. It has no system discovery behavior."
      },
      {
        "id": "blocker:references/workbook-specification.md:13:system-reconnaissance",
        "verdict": "false_positive",
        "confidence": 0.99,
        "reason": "The line defines a required workbook sheet and zero-value placeholder. It does not inspect the execution environment."
      },
      {
        "id": "blocker:references/wrap-rate-presets.md:7:system-reconnaissance",
        "verdict": "false_positive",
        "confidence": 0.99,
        "reason": "The matched text is a cost-rate table header. It contains no reconnaissance command or instruction."
      },
      {
        "id": "blocker:scripts/recompute_expected_values.py:203:system-reconnaissance",
        "verdict": "false_positive",
        "confidence": 0.99,
        "reason": "The line raises a local input-validation error for malformed JSON. It does not collect system information."
      },
      {
        "id": "external_commands:scripts/validate_workbook.py:280:python-subprocess-run",
        "verdict": "false_positive",
        "confidence": 0.96,
        "reason": "The validator invokes a discovered LibreOffice executable with a fixed argument list and shell execution disabled. No input is interpolated into a shell command."
      },
      {
        "id": "filesystem:scripts/validate_workbook.py:13:temp-file-creation",
        "verdict": "false_positive",
        "confidence": 0.99,
        "reason": "This line only imports the standard tempfile module. Temporary files are later confined to an automatically managed validation directory."
      },
      {
        "id": "filesystem:scripts/validate_workbook.py:262:temp-file-creation",
        "verdict": "false_positive",
        "confidence": 0.98,
        "reason": "The function uses a temporary directory solely for isolated LibreOffice recalculation. The directory object is returned for controlled cleanup."
      },
      {
        "id": "filesystem:scripts/validate_workbook.py:263:temp-file-creation",
        "verdict": "false_positive",
        "confidence": 0.99,
        "reason": "TemporaryDirectory creates an isolated system-managed directory with a fixed prefix. The code does not choose a sensitive destination."
      },
      {
        "id": "filesystem:scripts/validate_workbook.py:393:temp-file-creation",
        "verdict": "false_positive",
        "confidence": 0.99,
        "reason": "This is a type annotation for the temporary directory handle. Cleanup occurs in the function finally block."
      },
      {
        "id": "filesystem:scripts/validate_workbook.py:270:python-shutil-operations",
        "verdict": "false_positive",
        "confidence": 0.97,
        "reason": "The validator copies the user-selected workbook into its isolated temporary input directory. It does not overwrite the source or an arbitrary destination."
      },
      {
        "id": "blocker:scripts/validate_workbook.py:48:system-reconnaissance",
        "verdict": "false_positive",
        "confidence": 0.99,
        "reason": "The line rejects an invalid workbook cell reference. It neither probes the host nor enumerates system resources."
      },
      {
        "id": "external_commands:SKILL.md:35:ruby-shell-backtick-execution",
        "verdict": "false_positive",
        "confidence": 0.99,
        "reason": "Backticks mark an inline CALC+ reporting example in Markdown. They are not shell or Ruby execution syntax in this document."
      },
      {
        "id": "external_commands:SKILL.md:38:ruby-shell-backtick-execution",
        "verdict": "false_positive",
        "confidence": 0.99,
        "reason": "Backticks format the DRAFT label in Markdown. The line does not execute a command."
      },
      {
        "id": "external_commands:SKILL.md:45:ruby-shell-backtick-execution",
        "verdict": "false_positive",
        "confidence": 0.99,
        "reason": "Backticks format API route and parameter names in prose. No shell invocation is present."
      },
      {
        "id": "external_commands:SKILL.md:51:ruby-shell-backtick-execution",
        "verdict": "false_positive",
        "confidence": 0.99,
        "reason": "Backticks format spreadsheet function and date-text names. They do not denote executable shell content."
      },
      {
        "id": "external_commands:SKILL.md:75:ruby-shell-backtick-execution",
        "verdict": "false_positive",
        "confidence": 0.99,
        "reason": "Backticks delimit required response phrases in workflow guidance. The text is not a command."
      },
      {
        "id": "external_commands:SKILL.md:92:ruby-shell-backtick-execution",
        "verdict": "false_positive",
        "confidence": 0.99,
        "reason": "Backticks identify declared MCP server names. This line only describes workflow dependencies."
      },
      {
        "id": "external_commands:SKILL.md:94:ruby-shell-backtick-execution",
        "verdict": "false_positive",
        "confidence": 0.99,
        "reason": "Backticks format the xlsx extension. The line lists workbook prerequisites without embedding an executable command."
      },
      {
        "id": "external_commands:SKILL.md:120:ruby-shell-backtick-execution",
        "verdict": "false_positive",
        "confidence": 0.99,
        "reason": "Backticks format a staffing-table label used for workflow selection. No code execution occurs."
      },
      {
        "id": "external_commands:SKILL.md:146:ruby-shell-backtick-execution",
        "verdict": "false_positive",
        "confidence": 0.99,
        "reason": "This is the opening fence for a Markdown text block containing arithmetic formulas. It is not executable code."
      },
      {
        "id": "external_commands:SKILL.md:149:ruby-shell-backtick-execution",
        "verdict": "false_positive",
        "confidence": 0.99,
        "reason": "This is the closing fence for a Markdown text block. It has no execution semantics."
      },
      {
        "id": "external_commands:SKILL.md:151:ruby-shell-backtick-execution",
        "verdict": "false_positive",
        "confidence": 0.99,
        "reason": "Backticks format a staffing arithmetic example. No shell, Ruby, or subprocess operation is described."
      },
      {
        "id": "external_commands:SKILL.md:159:ruby-shell-backtick-execution",
        "verdict": "false_positive",
        "confidence": 0.99,
        "reason": "Backticks format the name of a declared BLS MCP operation. They do not execute that name through a shell."
      },
      {
        "id": "external_commands:SKILL.md:168:ruby-shell-backtick-execution",
        "verdict": "false_positive",
        "confidence": 0.99,
        "reason": "This is a Markdown text-block fence for cost formulas. It does not invoke an interpreter."
      },
      {
        "id": "external_commands:SKILL.md:178:ruby-shell-backtick-execution",
        "verdict": "false_positive",
        "confidence": 0.99,
        "reason": "This closes a Markdown text block of arithmetic formulas. No external command is present."
      },
      {
        "id": "external_commands:SKILL.md:182:ruby-shell-backtick-execution",
        "verdict": "false_positive",
        "confidence": 0.99,
        "reason": "This opens a Markdown text block explaining fee arithmetic. The content is descriptive, not executable."
      },
      {
        "id": "external_commands:SKILL.md:186:ruby-shell-backtick-execution",
        "verdict": "false_positive",
        "confidence": 0.99,
        "reason": "This closes a Markdown text block. It cannot execute shell or Ruby code."
      },
      {
        "id": "external_commands:SKILL.md:192:ruby-shell-backtick-execution",
        "verdict": "false_positive",
        "confidence": 0.99,
        "reason": "Backticks format two MCP operation names in procedural guidance. They are not passed to a command interpreter."
      },
      {
        "id": "external_commands:SKILL.md:217:ruby-shell-backtick-execution",
        "verdict": "false_positive",
        "confidence": 0.97,
        "reason": "The line documents an explicit bundled validator command with file arguments. Markdown backticks do not execute it, and the validator avoids shell interpolation."
      },
      {
        "id": "blocker:SKILL.md:55:system-reconnaissance",
        "verdict": "false_positive",
        "confidence": 0.99,
        "reason": "This is defensive API pacing guidance that serializes credentialed requests. It does not discover system or network details."
      },
      {
        "id": "blocker:SKILL.md:162:system-reconnaissance",
        "verdict": "false_positive",
        "confidence": 0.99,
        "reason": "The line instructs the estimate to calculate wage aging from known dates. It contains no reconnaissance behavior."
      },
      {
        "id": "blocker:test.md:29:network-reconnaissance",
        "verdict": "false_positive",
        "confidence": 0.99,
        "reason": "This is a test-result bullet stating that a formula-structure audit passed. It performs no network action."
      },
      {
        "id": "blocker:test.md:30:network-reconnaissance",
        "verdict": "false_positive",
        "confidence": 0.99,
        "reason": "This test-result bullet reports independent cost recomputation. It contains no host or network probing."
      },
      {
        "id": "blocker:test.md:31:network-reconnaissance",
        "verdict": "false_positive",
        "confidence": 0.99,
        "reason": "This test-result bullet reports LibreOffice formula validation. It is historical documentation, not a reconnaissance instruction."
      },
      {
        "id": "blocker:test.md:41:network-reconnaissance",
        "verdict": "false_positive",
        "confidence": 0.99,
        "reason": "The line records that a frontmatter validator passed. It does not scan or probe a network."
      },
      {
        "id": "blocker:test.md:43:network-reconnaissance",
        "verdict": "false_positive",
        "confidence": 0.99,
        "reason": "The line records local Python compilation and help checks. It does not perform network discovery."
      },
      {
        "id": "filesystem:testing.md:70:hidden-file-in-home-directory",
        "verdict": "false_positive",
        "confidence": 0.98,
        "reason": "The line documents the local skill path used in historical testing. It neither creates nor modifies a hidden home-directory file."
      },
      {
        "id": "filesystem:testing.md:70:hidden-file-access",
        "verdict": "false_positive",
        "confidence": 0.98,
        "reason": "The path is a historical environment description in testing documentation. No code or instruction reads that home-directory file."
      },
      {
        "id": "blocker:testing.md:21:system-reconnaissance",
        "verdict": "false_positive",
        "confidence": 0.99,
        "reason": "This is a documented CPFF test scenario and result. It does not inspect the host system."
      },
      {
        "id": "blocker:testing.md:22:system-reconnaissance",
        "verdict": "false_positive",
        "confidence": 0.99,
        "reason": "This is a documented CPAF test scenario and result. It contains no reconnaissance behavior."
      },
      {
        "id": "blocker:testing.md:23:system-reconnaissance",
        "verdict": "false_positive",
        "confidence": 0.99,
        "reason": "This is a documented CPIF test scenario and result. It contains no system discovery instruction."
      },
      {
        "id": "blocker:testing.md:65:system-reconnaissance",
        "verdict": "false_positive",
        "confidence": 0.99,
        "reason": "The line describes a test assertion matrix. It does not enumerate or probe system resources."
      },
      {
        "id": "blocker:testing.md:88:system-reconnaissance",
        "verdict": "false_positive",
        "confidence": 0.99,
        "reason": "The line summarizes CALC+ query changes in a testing record. It does not perform network reconnaissance."
      },
      {
        "id": "blocker:testing.md:124:system-reconnaissance",
        "verdict": "false_positive",
        "confidence": 0.99,
        "reason": "The line documents resolution of a workbook specification contradiction. It has no system inspection behavior."
      },
      {
        "id": "blocker:testing.md:183:system-reconnaissance",
        "verdict": "false_positive",
        "confidence": 0.99,
        "reason": "The line reports a regression-test scenario and outcome. It neither probes the environment nor issues commands."
      }
    ],
    "semantic_findings": [],
    "critical_findings": [],
    "high_findings": [],
    "medium_findings": [],
    "low_findings": [],
    "dangerous_patterns": [],
    "files_scanned": 11,
    "total_lines": 1887,
    "audit_model": "codex",
    "audited_at": "2026-08-24T12:41:32.269Z",
    "agent_auto_install_policy": "allowed",
    "manual_install_policy": "allowed"
  },
  "content": {
    "user_title": "Build Auditable Cost-Reimbursement IGCEs",
    "value_statement": "Cost-reimbursement estimates require traceable wages, indirect pools, fee treatment, travel, and benchmark data. This skill builds auditable CPFF, CPAF, and CPIF workbooks with validation steps.",
    "seo_keywords": [
      "Claude",
      "Codex",
      "Claude Code",
      "cost-reimbursement IGCE",
      "CPFF estimate",
      "CPAF workbook",
      "CPIF analysis",
      "BLS OEWS wages",
      "GSA CALC+"
    ],
    "actual_capabilities": [
      "Builds structured cost-reimbursement estimates for CPFF, CPAF, and CPIF contract types.",
      "Maps labor categories to SOC codes and uses BLS wage percentiles.",
      "Calculates fringe, overhead, G&A, FCCM, fee, and estimated price layers.",
      "Positions estimated rates against CALC+ benchmarks without making procurement determinations.",
      "Adds GSA Per Diem travel estimates and separates fee-bearing costs from pass-through costs.",
      "Validates workbook formulas through structure checks, independent recomputation, and optional LibreOffice execution."
    ],
    "limitations": [
      "Requires BLS OEWS, GSA CALC+, and GSA Per Diem MCP operations for complete estimates.",
      "Does not support FFP, labor-hour, time-and-materials, grants, or cooperative agreements.",
      "Does not make cost-realism, fair-and-reasonable, negotiation, or legal determinations.",
      "Formula execution is not independently verified when LibreOffice or another spreadsheet engine is unavailable."
    ],
    "use_cases": [
      {
        "title": "Prepare a CPFF IGCE",
        "description": "Create a traceable labor, indirect cost, travel, and fixed-fee estimate for a research or services acquisition.",
        "target_user": "Federal acquisition analyst"
      },
      {
        "title": "Model CPAF fee outcomes",
        "description": "Compare base-only, assumed-earned, and full award-fee outcomes across low, mid, and high cost scenarios.",
        "target_user": "Contracting officer representative"
      },
      {
        "title": "Analyze CPIF scenarios",
        "description": "Model target cost, separate overrun and underrun shares, and minimum or maximum fee boundaries.",
        "target_user": "Cost and pricing specialist"
      }
    ],
    "prompt_templates": [
      {
        "title": "Basic CPFF Estimate",
        "prompt": "Build a CPFF IGCE for [labor roles], [location], [period], and [staffing]. Use [rate source] and assume [travel scope].",
        "scenario": "Start with a structured cost-reimbursement requirement."
      },
      {
        "title": "Decompose a Requirement",
        "prompt": "Decompose this SOW into task areas, labor categories, SOC mappings, and missing inputs before estimating: [requirement].",
        "scenario": "Turn an unstructured SOW, PWS, or BAA into an approved staffing basis."
      },
      {
        "title": "Build a CPAF Workbook",
        "prompt": "Create a CPAF IGCE using [staffing], [locations], [indirect rates], [base fee], [award pool], and [travel details].",
        "scenario": "Compare award-fee outcomes and benchmark labor rates."
      },
      {
        "title": "Model Advanced CPIF Outcomes",
        "prompt": "Build a CPIF estimate with [target fee], [overrun share], [underrun share], [fee bounds], [ODCs], and [option periods].",
        "scenario": "Analyze asymmetric incentive shares, bound crossings, and fee-bearing classifications."
      }
    ],
    "output_examples": [
      {
        "input": "Build a three-year CPFF estimate for four biomedical scientists in Bethesda with no travel.",
        "output": [
          "An IGCE workbook with assumptions, cost buildup, scenarios, rate validation, methodology, and raw data sheets.",
          "A CPFF completion or term designation with the applicable fee ceiling.",
          "Validation results for formula structure and independent cost recomputation."
        ]
      },
      {
        "input": "Model a CPIF engineering effort with different overrun and underrun shares.",
        "output": [
          "A scenario matrix showing cost changes, incentive fee changes, and total estimated price.",
          "Separate contractor shares for overruns and underruns.",
          "The first scenario where minimum or maximum fee limits apply."
        ]
      },
      {
        "input": "Show where proposed labor rates sit against BLS and CALC+ data.",
        "output": "A neutral benchmark table with wage percentiles, CALC+ sample sizes, arithmetic differences, and source limitations. It does not provide a procurement determination."
      }
    ],
    "best_practices": [
      "Confirm contract type, staffing, location, period, indirect rates, and fee-bearing classifications before building the workbook.",
      "Record each source, fallback, proxy, vintage, and user-approved assumption in the workbook.",
      "Run formula checks and independent recomputation before using the estimate in an acquisition file."
    ],
    "anti_patterns": [
      "Do not apply fee automatically to travel, pass-through ODCs, or the entire estimated cost.",
      "Do not treat CALC+ positioning as a fair-and-reasonable or cost-realism determination.",
      "Do not claim spreadsheet formulas executed when only openpyxl inspection was available."
    ],
    "faq": [
      {
        "question": "Which contract types does this skill support?",
        "answer": "It supports CPFF, CPAF, and CPIF cost-reimbursement estimates. It does not support FFP, labor-hour, or time-and-materials estimates."
      },
      {
        "question": "Which data services are required?",
        "answer": "Complete workflows require BLS OEWS and GSA CALC+ operations. GSA Per Diem operations are required when travel is included."
      },
      {
        "question": "Can it decide whether a proposed price is fair and reasonable?",
        "answer": "No. It provides neutral positioning data, while the Contracting Officer owns the determination and negotiation position."
      },
      {
        "question": "How does it handle indirect rates?",
        "answer": "It accepts disclosed estimates or user-supplied audited rates. User-supplied FPRA, FPRR, or DCAA rates take precedence over generic defaults."
      },
      {
        "question": "How are workbook formulas validated?",
        "answer": "The bundled validator checks formula structure and independently recomputes expected values. LibreOffice can execute formulas when available."
      },
      {
        "question": "Can it build an estimate from an unstructured SOW or PWS?",
        "answer": "Yes. It first decomposes the requirement and asks the user to confirm labor categories and SOC mappings before collecting build inputs."
      }
    ]
  },
  "file_structure": [
    {
      "name": "agents",
      "type": "dir",
      "path": "agents",
      "children": [
        {
          "name": "openai.yaml",
          "type": "file",
          "path": "agents/openai.yaml",
          "lines": 8
        }
      ]
    },
    {
      "name": "references",
      "type": "dir",
      "path": "references",
      "children": [
        {
          "name": "data-source-operations.md",
          "type": "file",
          "path": "references/data-source-operations.md",
          "lines": 308
        },
        {
          "name": "runtime-adaptation.md",
          "type": "file",
          "path": "references/runtime-adaptation.md",
          "lines": 38
        },
        {
          "name": "validation-gates.md",
          "type": "file",
          "path": "references/validation-gates.md",
          "lines": 105
        },
        {
          "name": "workbook-specification.md",
          "type": "file",
          "path": "references/workbook-specification.md",
          "lines": 169
        },
        {
          "name": "wrap-rate-presets.md",
          "type": "file",
          "path": "references/wrap-rate-presets.md",
          "lines": 93
        }
      ]
    },
    {
      "name": "scripts",
      "type": "dir",
      "path": "scripts",
      "children": [
        {
          "name": "recompute_expected_values.py",
          "type": "file",
          "path": "scripts/recompute_expected_values.py",
          "lines": 233
        },
        {
          "name": "validate_workbook.py",
          "type": "file",
          "path": "scripts/validate_workbook.py",
          "lines": 449
        }
      ]
    },
    {
      "name": "SKILL.md",
      "type": "file",
      "path": "SKILL.md",
      "lines": 239
    },
    {
      "name": "test.md",
      "type": "file",
      "path": "test.md",
      "lines": 51
    },
    {
      "name": "testing.md",
      "type": "file",
      "path": "testing.md",
      "lines": 194
    }
  ]
}
rea-analysis-optimizationmorluto/reaOptimize REA providers and shared analysis workflows for agent context, latency, CPU, and memory while preserving correctness and Evidence. Use for analysis bottlenecks and cache or query design; CI/test-suite optimization belongs to rea-ci-tests-audit.Stars: 472kUpdated Claude CodeCodexVerifiedInstall
rea-ci-tests-auditmorluto/reaAudit REA CI and test suites for correctness, fixture drift, false passes, and measured performance; use for suite or workflow investigations and efficiency changes, rather than ordinary feature testing or a single test failure.Stars: 472kUpdated Claude CodeCodexVerifiedInstall
rea-tool-designmorluto/reaAudit, investigate, design, or change REA investigation tools, CLI/MCP contracts, provider capabilities, and Evidence semantics.Stars: 472kUpdated Claude CodeCodexVerifiedInstall
ponytail-auditDietrichGebert/ponytailQuality audit of the whole repo: bugs, security, real load, missing tests, speed, and what to delete. Most important first.Stars: 194kUpdated Claude CodeCodexVerifiedInstall