Skip to content

aiskillstore/marketplace / skills/1102tools-dev/ot-cost-analysis

ot-cost-analysis

Verified

Trigger for: Other Transaction or OT should-cost, cost estimate, cost-share analysis, milestone pricing, funding profile, proposed-price comparison, prototype price analysis, research OT budget, production follow-on OT estimate, or OT price-reasonableness support under 10 U.S.C. 4021 or 4022. Build auditable milestone-based .xlsx workbooks using BLS OEWS wages, CALC+ positioning, GSA Per Diem, materials, cost sharing, and agreement-specific fees. Use for pre-solicitation budgets and proposal comparisons. Do NOT use for FAR-based IGCEs, OT project descriptions, grants, or an Agreements Officer's determination. Requires the bls-oews, gsa-calc, and, when travel applies, gsa-perdiem MCP servers.

skill-report.json

View on GitHub
{
  "schema_version": "2.0",
  "meta": {
    "generated_at": "2026-08-24T13:00:13.810Z",
    "slug": "1102tools-dev-ot-cost-analysis",
    "source_url": "https://github.com/1102tools-dev/federal-contracting-skills/tree/6c8edf1c45e63acd1bdbb276392924435dde28b3/skills/ot-cost-analysis",
    "source_ref": "6c8edf1c45e63acd1bdbb276392924435dde28b3",
    "model": "codex",
    "analysis_version": "3.0.0",
    "source_type": "community",
    "content_hash": "2754bc444eb4e6b9e0e8d61dc0baf6479924091491b5f04f8536f102dffaad4a",
    "tree_hash": "06cb5d110d84d0916430ef9765732f56095bf628db4ec3fc93790a0ebe0f7673",
    "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": "ot-cost-analysis",
    "description": "Build auditable, milestone-based Other Transaction cost analyses using labor benchmarks, travel rates, materials, cost sharing, fees, scenarios, and funding profiles.",
    "summary": "Create formula-driven OT should-cost workbooks and neutral proposed-amount comparisons.",
    "icon": "📦",
    "author": "1102tools-dev",
    "license": "MIT",
    "category": "office",
    "tags": [
      "other-transactions",
      "cost-analysis",
      "government-contracting",
      "excel-workbooks",
      "cost-sharing"
    ],
    "supported_tools": [
      "claude",
      "codex",
      "claude-code"
    ],
    "risk_factors": [
      "external_commands",
      "filesystem"
    ]
  },
  "security_audit": {
    "risk_level": "safe",
    "is_blocked": false,
    "safe_to_publish": true,
    "analysis_status": "ok",
    "summary": "All 40 static findings are false positives caused by ordinary prose, Markdown code formatting, input validation, and a constrained LibreOffice validation command. No prompt injection, credential handling, command injection, unsafe archive extraction, or malicious intent was found in the reviewed files.",
    "remediation": [],
    "risk_factor_evidence": [
      {
        "factor": "external_commands",
        "evidence": [
          {
            "file": "scripts/validate_workbook.py",
            "line_start": 175,
            "line_end": 175
          },
          {
            "file": "SKILL.md",
            "line_start": 53,
            "line_end": 53
          },
          {
            "file": "SKILL.md",
            "line_start": 54,
            "line_end": 54
          },
          {
            "file": "SKILL.md",
            "line_start": 66,
            "line_end": 66
          },
          {
            "file": "SKILL.md",
            "line_start": 67,
            "line_end": 67
          },
          {
            "file": "SKILL.md",
            "line_start": 68,
            "line_end": 68
          },
          {
            "file": "SKILL.md",
            "line_start": 69,
            "line_end": 69
          },
          {
            "file": "SKILL.md",
            "line_start": 77,
            "line_end": 77
          },
          {
            "file": "SKILL.md",
            "line_start": 124,
            "line_end": 124
          },
          {
            "file": "SKILL.md",
            "line_start": 140,
            "line_end": 140
          },
          {
            "file": "SKILL.md",
            "line_start": 158,
            "line_end": 158
          },
          {
            "file": "SKILL.md",
            "line_start": 178,
            "line_end": 188
          },
          {
            "file": "SKILL.md",
            "line_start": 188,
            "line_end": 213
          },
          {
            "file": "SKILL.md",
            "line_start": 213,
            "line_end": 214
          },
          {
            "file": "SKILL.md",
            "line_start": 214,
            "line_end": 215
          },
          {
            "file": "SKILL.md",
            "line_start": 215,
            "line_end": 215
          }
        ]
      },
      {
        "factor": "filesystem",
        "evidence": [
          {
            "file": "scripts/validate_workbook.py",
            "line_start": 13,
            "line_end": 13
          },
          {
            "file": "scripts/validate_workbook.py",
            "line_start": 166,
            "line_end": 166
          },
          {
            "file": "scripts/validate_workbook.py",
            "line_start": 167,
            "line_end": 167
          },
          {
            "file": "scripts/validate_workbook.py",
            "line_start": 248,
            "line_end": 248
          },
          {
            "file": "scripts/validate_workbook.py",
            "line_start": 174,
            "line_end": 174
          },
          {
            "file": "scripts/validate_workbook.py",
            "line_start": 14,
            "line_end": 14
          },
          {
            "file": "scripts/validate_workbook.py",
            "line_start": 241,
            "line_end": 241
          },
          {
            "file": "scripts/validate_workbook.py",
            "line_start": 292,
            "line_end": 292
          },
          {
            "file": "testing.md",
            "line_start": 38,
            "line_end": 38
          }
        ]
      }
    ],
    "static_findings": [
      {
        "id": "blocker:references/authority-and-cost-sharing.md:22:system-reconnaissance",
        "category": "blocker",
        "severity": "low",
        "pattern": "System reconnaissance",
        "file": "references/authority-and-cost-sharing.md",
        "line_start": 22,
        "line_end": 22,
        "snippet": "| C | At least one-third of total prototype-project cost is paid from non-Federal sources | Require "
      },
      {
        "id": "sensitive:references/data-source-operations.md:88:certificate-key-files",
        "category": "sensitive",
        "severity": "high",
        "pattern": "Certificate/key files",
        "file": "references/data-source-operations.md",
        "line_start": 88,
        "line_end": 88,
        "snippet": "aggregations.labor_category.buckets[*].key"
      },
      {
        "id": "blocker:references/workbook-specification.md:24:system-reconnaissance",
        "category": "blocker",
        "severity": "low",
        "pattern": "System reconnaissance",
        "file": "references/workbook-specification.md",
        "line_start": 24,
        "line_end": 24,
        "snippet": "| B5 | Government-paid fee rate | Blue user input; zero unless supplied |"
      },
      {
        "id": "blocker:scripts/recompute_expected_values.py:15:system-reconnaissance",
        "category": "blocker",
        "severity": "low",
        "pattern": "System reconnaissance",
        "file": "scripts/recompute_expected_values.py",
        "line_start": 15,
        "line_end": 15,
        "snippet": "\"\"\"Raised for invalid validation inputs.\"\"\""
      },
      {
        "id": "blocker:scripts/recompute_expected_values.py:133:system-reconnaissance",
        "category": "blocker",
        "severity": "low",
        "pattern": "System reconnaissance",
        "file": "scripts/recompute_expected_values.py",
        "line_start": 133,
        "line_end": 133,
        "snippet": "milestone_id = _text(raw.get(\"id\"), f\"milestones[{index}].id\")"
      },
      {
        "id": "blocker:scripts/recompute_expected_values.py:238:system-reconnaissance",
        "category": "blocker",
        "severity": "low",
        "pattern": "System reconnaissance",
        "file": "scripts/recompute_expected_values.py",
        "line_start": 238,
        "line_end": 238,
        "snippet": "raise InputError(f\"invalid JSON in {path}: {exc}\") from exc"
      },
      {
        "id": "external_commands:scripts/validate_workbook.py:175:python-subprocess-run",
        "category": "external_commands",
        "severity": "high",
        "pattern": "Python subprocess.run",
        "file": "scripts/validate_workbook.py",
        "line_start": 175,
        "line_end": 175,
        "snippet": "completed = subprocess.run("
      },
      {
        "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:166:temp-file-creation",
        "category": "filesystem",
        "severity": "low",
        "pattern": "Temp file creation",
        "file": "scripts/validate_workbook.py",
        "line_start": 166,
        "line_end": 166,
        "snippet": "def recalculate(source: Path, executable: Path) -> tuple[tempfile.TemporaryDirectory[str], Path]:"
      },
      {
        "id": "filesystem:scripts/validate_workbook.py:167:temp-file-creation",
        "category": "filesystem",
        "severity": "low",
        "pattern": "Temp file creation",
        "file": "scripts/validate_workbook.py",
        "line_start": 167,
        "line_end": 167,
        "snippet": "temporary = tempfile.TemporaryDirectory(prefix=\"ot-workbook-validation-\")"
      },
      {
        "id": "filesystem:scripts/validate_workbook.py:248:temp-file-creation",
        "category": "filesystem",
        "severity": "low",
        "pattern": "Temp file creation",
        "file": "scripts/validate_workbook.py",
        "line_start": 248,
        "line_end": 248,
        "snippet": "temporary: tempfile.TemporaryDirectory[str] | None = None"
      },
      {
        "id": "filesystem:scripts/validate_workbook.py:174:python-shutil-operations",
        "category": "filesystem",
        "severity": "medium",
        "pattern": "Python shutil operations",
        "file": "scripts/validate_workbook.py",
        "line_start": 174,
        "line_end": 174,
        "snippet": "shutil.copy2(source, copied)"
      },
      {
        "id": "filesystem:scripts/validate_workbook.py:14:python-archive-libraries",
        "category": "filesystem",
        "severity": "medium",
        "pattern": "Python archive libraries",
        "file": "scripts/validate_workbook.py",
        "line_start": 14,
        "line_end": 14,
        "snippet": "import zipfile"
      },
      {
        "id": "filesystem:scripts/validate_workbook.py:241:python-archive-libraries",
        "category": "filesystem",
        "severity": "medium",
        "pattern": "Python archive libraries",
        "file": "scripts/validate_workbook.py",
        "line_start": 241,
        "line_end": 241,
        "snippet": "if not zipfile.is_zipfile(path):"
      },
      {
        "id": "filesystem:scripts/validate_workbook.py:292:python-archive-libraries",
        "category": "filesystem",
        "severity": "medium",
        "pattern": "Python archive libraries",
        "file": "scripts/validate_workbook.py",
        "line_start": 292,
        "line_end": 292,
        "snippet": "except (InputError, OSError, ValueError, zipfile.BadZipFile) as exc:"
      },
      {
        "id": "blocker:scripts/validate_workbook.py:42:system-reconnaissance",
        "category": "blocker",
        "severity": "low",
        "pattern": "System reconnaissance",
        "file": "scripts/validate_workbook.py",
        "line_start": 42,
        "line_end": 42,
        "snippet": "raise InputError(f\"invalid workbook cell reference: {reference}\")"
      },
      {
        "id": "blocker:scripts/validate_workbook.py:242:system-reconnaissance",
        "category": "blocker",
        "severity": "low",
        "pattern": "System reconnaissance",
        "file": "scripts/validate_workbook.py",
        "line_start": 242,
        "line_end": 242,
        "snippet": "return {\"status\": \"fail\", \"failures\": [\"file is not a valid XLSX ZIP\"]}"
      },
      {
        "id": "external_commands:SKILL.md:53:ruby-shell-backtick-execution",
        "category": "external_commands",
        "severity": "medium",
        "pattern": "Ruby/shell backtick execution",
        "file": "SKILL.md",
        "line_start": 53,
        "line_end": 53,
        "snippet": "8. **CALC+ signature:** Use `/v3/api/ceilingrates/` with `keyword=` when keyword search is required."
      },
      {
        "id": "external_commands:SKILL.md:54:ruby-shell-backtick-execution",
        "category": "external_commands",
        "severity": "medium",
        "pattern": "Ruby/shell backtick execution",
        "file": "SKILL.md",
        "line_start": 54,
        "line_end": 54,
        "snippet": "9. **BLS vintage and aging:** Call `detect_latest_year` at runtime. Store BLS vintage and agreement "
      },
      {
        "id": "external_commands:SKILL.md:66:ruby-shell-backtick-execution",
        "category": "external_commands",
        "severity": "medium",
        "pattern": "Ruby/shell backtick execution",
        "file": "SKILL.md",
        "line_start": 66,
        "line_end": 66,
        "snippet": "1. For a build, require `bls-oews` operations `detect_latest_year`, `get_wage_data`, metro lookup, a"
      },
      {
        "id": "external_commands:SKILL.md:67:ruby-shell-backtick-execution",
        "category": "external_commands",
        "severity": "medium",
        "pattern": "Ruby/shell backtick execution",
        "file": "SKILL.md",
        "line_start": 67,
        "line_end": 67,
        "snippet": "2. Require `gsa-perdiem` operations `estimate_travel_cost`, `lookup_city_perdiem`, and `get_mie_brea"
      },
      {
        "id": "external_commands:SKILL.md:68:ruby-shell-backtick-execution",
        "category": "external_commands",
        "severity": "medium",
        "pattern": "Ruby/shell backtick execution",
        "file": "SKILL.md",
        "line_start": 68,
        "line_end": 68,
        "snippet": "3. Require an `.xlsx` authoring path and Python 3.10 or later with openpyxl for the bundled validato"
      },
      {
        "id": "external_commands:SKILL.md:69:ruby-shell-backtick-execution",
        "category": "external_commands",
        "severity": "medium",
        "pattern": "Ruby/shell backtick execution",
        "file": "SKILL.md",
        "line_start": 69,
        "line_end": 69,
        "snippet": "4. For a build, test `detect_latest_year` before wage retrieval. Test Per Diem only when travel firs"
      },
      {
        "id": "external_commands:SKILL.md:77:ruby-shell-backtick-execution",
        "category": "external_commands",
        "severity": "medium",
        "pattern": "Ruby/shell backtick execution",
        "file": "SKILL.md",
        "line_start": 77,
        "line_end": 77,
        "snippet": "Use when the user supplies a milestone table or the approved handoff from `ot-project-description-bu"
      },
      {
        "id": "external_commands:SKILL.md:124:ruby-shell-backtick-execution",
        "category": "external_commands",
        "severity": "medium",
        "pattern": "Ruby/shell backtick execution",
        "file": "SKILL.md",
        "line_start": 124,
        "line_end": 124,
        "snippet": "Treat a table labeled `MILESTONE HANDOFF TABLE` and identified for OT Cost Analysis as user-reviewed"
      },
      {
        "id": "external_commands:SKILL.md:140:ruby-shell-backtick-execution",
        "category": "external_commands",
        "severity": "medium",
        "pattern": "Ruby/shell backtick execution",
        "file": "SKILL.md",
        "line_start": 140,
        "line_end": 140,
        "snippet": "4. Propose milestone ID, objective, duration, entry conditions, completion evidence, payment type ma"
      },
      {
        "id": "external_commands:SKILL.md:158:ruby-shell-backtick-execution",
        "category": "external_commands",
        "severity": "medium",
        "pattern": "Ruby/shell backtick execution",
        "file": "SKILL.md",
        "line_start": 158,
        "line_end": 158,
        "snippet": "2. Call `detect_latest_year`, then retrieve metro, state, or national BLS percentiles using the docu"
      },
      {
        "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": 188,
        "snippet": "```text"
      },
      {
        "id": "external_commands:SKILL.md:188:ruby-shell-backtick-execution",
        "category": "external_commands",
        "severity": "medium",
        "pattern": "Ruby/shell backtick execution",
        "file": "SKILL.md",
        "line_start": 188,
        "line_end": 213,
        "snippet": "```"
      },
      {
        "id": "external_commands:SKILL.md:213:ruby-shell-backtick-execution",
        "category": "external_commands",
        "severity": "medium",
        "pattern": "Ruby/shell backtick execution",
        "file": "SKILL.md",
        "line_start": 213,
        "line_end": 214,
        "snippet": "1. Run `scripts/validate_workbook.py <workbook> --expected <inputs.json> --engine none`."
      },
      {
        "id": "external_commands:SKILL.md:214:ruby-shell-backtick-execution",
        "category": "external_commands",
        "severity": "medium",
        "pattern": "Ruby/shell backtick execution",
        "file": "SKILL.md",
        "line_start": 214,
        "line_end": 215,
        "snippet": "2. Run `scripts/recompute_expected_values.py <inputs.json>`."
      },
      {
        "id": "external_commands:SKILL.md:215:ruby-shell-backtick-execution",
        "category": "external_commands",
        "severity": "medium",
        "pattern": "Ruby/shell backtick execution",
        "file": "SKILL.md",
        "line_start": 215,
        "line_end": 215,
        "snippet": "3. If LibreOffice is available, rerun the validator with `--engine auto` or `--engine libreoffice`; "
      },
      {
        "id": "sensitive:SKILL.md:53:certificate-key-files",
        "category": "sensitive",
        "severity": "high",
        "pattern": "Certificate/key files",
        "file": "SKILL.md",
        "line_start": 53,
        "line_end": 53,
        "snippet": "8. **CALC+ signature:** Use `/v3/api/ceilingrates/` with `keyword=` when keyword search is required."
      },
      {
        "id": "blocker:SKILL.md:187:system-reconnaissance",
        "category": "blocker",
        "severity": "low",
        "pattern": "System reconnaissance",
        "file": "SKILL.md",
        "line_start": 187,
        "line_end": 187,
        "snippet": "Government funding requirement = Government share + Government-paid fee"
      },
      {
        "id": "blocker:test.md:53:system-reconnaissance",
        "category": "blocker",
        "severity": "low",
        "pattern": "System reconnaissance",
        "file": "test.md",
        "line_start": 53,
        "line_end": 53,
        "snippet": "A normal Codex CLI mixed-milestone workbook run preserved approvals and stopped because the host's g"
      },
      {
        "id": "filesystem:testing.md:38:hard-link-creation",
        "category": "filesystem",
        "severity": "medium",
        "pattern": "Hard link creation",
        "file": "testing.md",
        "line_start": 38,
        "line_end": 38,
        "snippet": "| 6 | Quantum RF sensing, MIT Lincoln Lab | 10 USC 4021 research | FFRDC, 4022(d) inapplicable | A |"
      },
      {
        "id": "blocker:testing.md:59:system-reconnaissance",
        "category": "blocker",
        "severity": "low",
        "pattern": "System reconnaissance",
        "file": "testing.md",
        "line_start": 59,
        "line_end": 59,
        "snippet": "| Paid hours (2080) vs productive hours (1880) split explicit | Step 2d / Step 6 | Tests 1, 2, 4 ris"
      },
      {
        "id": "blocker:testing.md:85:system-reconnaissance",
        "category": "blocker",
        "severity": "low",
        "pattern": "System reconnaissance",
        "file": "testing.md",
        "line_start": 85,
        "line_end": 85,
        "snippet": "| 10 USC 4022(f) cost-share wording contradiction resolved | Step 2 production branch | Authority Ga"
      },
      {
        "id": "blocker:testing.md:99:system-reconnaissance",
        "category": "blocker",
        "severity": "low",
        "pattern": "System reconnaissance",
        "file": "testing.md",
        "line_start": 99,
        "line_end": 99,
        "snippet": "- Hybrid FAR+OT arrangements (unusual but possible)"
      },
      {
        "id": "blocker:testing.md:111:system-reconnaissance",
        "category": "blocker",
        "severity": "low",
        "pattern": "System reconnaissance",
        "file": "testing.md",
        "line_start": 111,
        "line_end": 111,
        "snippet": "Each wave consisted of four cold sub-agent runs. Each sub-agent read `SKILL.md` fresh with no conver"
      }
    ],
    "finding_verdicts": [
      {
        "id": "blocker:references/authority-and-cost-sharing.md:22:system-reconnaissance",
        "verdict": "false_positive",
        "confidence": 0.99,
        "reason": "The line states a statutory one-third non-Federal cost-share threshold. It performs no system discovery or host inspection."
      },
      {
        "id": "sensitive:references/data-source-operations.md:88:certificate-key-files",
        "verdict": "false_positive",
        "confidence": 0.99,
        "reason": "The token key is a JSON field name in a documented CALC+ response path. It is not a certificate, private key, credential, or file reference."
      },
      {
        "id": "blocker:references/workbook-specification.md:24:system-reconnaissance",
        "verdict": "false_positive",
        "confidence": 0.99,
        "reason": "The line defines workbook cell B5 as a user-supplied fee rate. It does not inspect the operating system or environment."
      },
      {
        "id": "blocker:scripts/recompute_expected_values.py:15:system-reconnaissance",
        "verdict": "false_positive",
        "confidence": 0.99,
        "reason": "This is the docstring for an input-validation exception. It has no reconnaissance behavior."
      },
      {
        "id": "blocker:scripts/recompute_expected_values.py:133:system-reconnaissance",
        "verdict": "false_positive",
        "confidence": 0.99,
        "reason": "The code validates a milestone identifier from the supplied JSON payload. It does not query host or system information."
      },
      {
        "id": "blocker:scripts/recompute_expected_values.py:238:system-reconnaissance",
        "verdict": "false_positive",
        "confidence": 0.99,
        "reason": "The line converts a JSON parsing failure into a clear input error. It does not enumerate files or inspect system state."
      },
      {
        "id": "external_commands:scripts/validate_workbook.py:175:python-subprocess-run",
        "verdict": "false_positive",
        "confidence": 0.97,
        "reason": "The validator invokes the discovered LibreOffice executable with a fixed argument list and shell execution disabled. User paths remain separate arguments, so no command-injection path is present."
      },
      {
        "id": "filesystem:scripts/validate_workbook.py:13:temp-file-creation",
        "verdict": "false_positive",
        "confidence": 0.99,
        "reason": "This line only imports Python's tempfile module for isolated workbook recalculation. Importing the module does not create or modify a file."
      },
      {
        "id": "filesystem:scripts/validate_workbook.py:166:temp-file-creation",
        "verdict": "false_positive",
        "confidence": 0.99,
        "reason": "The function signature returns a managed TemporaryDirectory used for validation. The temporary workspace is local, isolated, and explicitly cleaned."
      },
      {
        "id": "filesystem:scripts/validate_workbook.py:167:temp-file-creation",
        "verdict": "false_positive",
        "confidence": 0.98,
        "reason": "The validator creates a uniquely named temporary directory for a copied workbook. Cleanup occurs on success and failure, and no sensitive location is targeted."
      },
      {
        "id": "filesystem:scripts/validate_workbook.py:248:temp-file-creation",
        "verdict": "false_positive",
        "confidence": 0.99,
        "reason": "This is a typed variable initialized to None for later cleanup. It does not create a file or directory."
      },
      {
        "id": "filesystem:scripts/validate_workbook.py:174:python-shutil-operations",
        "verdict": "false_positive",
        "confidence": 0.97,
        "reason": "The validator copies the user-selected workbook into its managed temporary input directory before recalculation. The operation neither overwrites the source nor targets unrelated files."
      },
      {
        "id": "filesystem:scripts/validate_workbook.py:14:python-archive-libraries",
        "verdict": "false_positive",
        "confidence": 0.99,
        "reason": "This line only imports zipfile so the validator can confirm that an XLSX is a valid ZIP container. No archive content is extracted."
      },
      {
        "id": "filesystem:scripts/validate_workbook.py:241:python-archive-libraries",
        "verdict": "false_positive",
        "confidence": 0.99,
        "reason": "zipfile.is_zipfile performs a format check on the requested workbook. It does not extract entries or permit path traversal."
      },
      {
        "id": "filesystem:scripts/validate_workbook.py:292:python-archive-libraries",
        "verdict": "false_positive",
        "confidence": 0.99,
        "reason": "The line catches malformed ZIP errors and reports validation failure. Exception handling does not perform archive operations."
      },
      {
        "id": "blocker:scripts/validate_workbook.py:42:system-reconnaissance",
        "verdict": "false_positive",
        "confidence": 0.99,
        "reason": "The code rejects an invalid workbook cell reference. It does not inspect the host system."
      },
      {
        "id": "blocker:scripts/validate_workbook.py:242:system-reconnaissance",
        "verdict": "false_positive",
        "confidence": 0.99,
        "reason": "The line returns a validation error when the input is not a valid XLSX ZIP. This is file-format validation, not reconnaissance."
      },
      {
        "id": "external_commands:SKILL.md:53:ruby-shell-backtick-execution",
        "verdict": "false_positive",
        "confidence": 0.99,
        "reason": "Backticks are Markdown formatting around API routes and parameter names. The line contains no Ruby or shell execution instruction."
      },
      {
        "id": "external_commands:SKILL.md:54:ruby-shell-backtick-execution",
        "verdict": "false_positive",
        "confidence": 0.99,
        "reason": "Backticks format MCP operation names and spreadsheet formulas in prose. They are not executable shell syntax in this Markdown file."
      },
      {
        "id": "external_commands:SKILL.md:66:ruby-shell-backtick-execution",
        "verdict": "false_positive",
        "confidence": 0.99,
        "reason": "The line names required MCP operations using inline Markdown code. It does not invoke a shell or interpolate command output."
      },
      {
        "id": "external_commands:SKILL.md:67:ruby-shell-backtick-execution",
        "verdict": "false_positive",
        "confidence": 0.99,
        "reason": "The line documents GSA Per Diem MCP operations in Markdown. No external process is launched."
      },
      {
        "id": "external_commands:SKILL.md:68:ruby-shell-backtick-execution",
        "verdict": "false_positive",
        "confidence": 0.99,
        "reason": "The backticks format the .xlsx extension in dependency prose. There is no command substitution or executable content."
      },
      {
        "id": "external_commands:SKILL.md:69:ruby-shell-backtick-execution",
        "verdict": "false_positive",
        "confidence": 0.99,
        "reason": "The line describes testing an MCP operation before use. Markdown backticks do not create Ruby or shell execution."
      },
      {
        "id": "external_commands:SKILL.md:77:ruby-shell-backtick-execution",
        "verdict": "false_positive",
        "confidence": 0.99,
        "reason": "The backticks identify another skill by name. This is a workflow reference, not a command."
      },
      {
        "id": "external_commands:SKILL.md:124:ruby-shell-backtick-execution",
        "verdict": "false_positive",
        "confidence": 0.99,
        "reason": "The line formats a trusted handoff table label in Markdown. It neither executes code nor directs a shell."
      },
      {
        "id": "external_commands:SKILL.md:140:ruby-shell-backtick-execution",
        "verdict": "false_positive",
        "confidence": 0.99,
        "reason": "The backticks mark the literal status PENDING in a proposed milestone. No executable statement is present."
      },
      {
        "id": "external_commands:SKILL.md:158:ruby-shell-backtick-execution",
        "verdict": "false_positive",
        "confidence": 0.99,
        "reason": "The line names an MCP operation in inline code formatting. It does not run a local command."
      },
      {
        "id": "external_commands:SKILL.md:178:ruby-shell-backtick-execution",
        "verdict": "false_positive",
        "confidence": 0.99,
        "reason": "This is the opening fence of a text block containing cost formulas. A Markdown fence is not Ruby backtick execution."
      },
      {
        "id": "external_commands:SKILL.md:188:ruby-shell-backtick-execution",
        "verdict": "false_positive",
        "confidence": 0.99,
        "reason": "This is the closing fence for a non-executable text formula block. It does not launch a command."
      },
      {
        "id": "external_commands:SKILL.md:213:ruby-shell-backtick-execution",
        "verdict": "false_positive",
        "confidence": 0.98,
        "reason": "The line documents running the bundled validator on user-selected files. Its backticks are Markdown, and the referenced script uses structured argument parsing."
      },
      {
        "id": "external_commands:SKILL.md:214:ruby-shell-backtick-execution",
        "verdict": "false_positive",
        "confidence": 0.98,
        "reason": "The line documents running the bundled deterministic recomputation script. It is an expected local validation step, not hidden shell execution."
      },
      {
        "id": "external_commands:SKILL.md:215:ruby-shell-backtick-execution",
        "verdict": "false_positive",
        "confidence": 0.98,
        "reason": "The line documents allowed validator engine options in Markdown. The options select a constrained LibreOffice validation path and do not contain shell syntax."
      },
      {
        "id": "sensitive:SKILL.md:53:certificate-key-files",
        "verdict": "false_positive",
        "confidence": 0.99,
        "reason": "The word keyword appears as an HTTP query parameter for CALC+ search. The line contains no certificate, key material, secret, or credential path."
      },
      {
        "id": "blocker:SKILL.md:187:system-reconnaissance",
        "verdict": "false_positive",
        "confidence": 0.99,
        "reason": "The line defines a Government funding arithmetic formula. It has no system inspection behavior."
      },
      {
        "id": "blocker:test.md:53:system-reconnaissance",
        "verdict": "false_positive",
        "confidence": 0.99,
        "reason": "The line records a prior host capability test and its fallback artifact format. It does not direct the skill to enumerate host details."
      },
      {
        "id": "filesystem:testing.md:38:hard-link-creation",
        "verdict": "false_positive",
        "confidence": 0.99,
        "reason": "Lincoln Lab is an organization name in a test scenario. The line contains no hard-link command or filesystem operation."
      },
      {
        "id": "blocker:testing.md:59:system-reconnaissance",
        "verdict": "false_positive",
        "confidence": 0.99,
        "reason": "The line discusses paid and productive labor hours in a testing record. It does not inspect system information."
      },
      {
        "id": "blocker:testing.md:85:system-reconnaissance",
        "verdict": "false_positive",
        "confidence": 0.99,
        "reason": "The line documents correction of a cost-share wording contradiction. It contains no reconnaissance action."
      },
      {
        "id": "blocker:testing.md:99:system-reconnaissance",
        "verdict": "false_positive",
        "confidence": 0.99,
        "reason": "The line lists hybrid FAR and OT arrangements as an untested case. It does not query the host environment."
      },
      {
        "id": "blocker:testing.md:111:system-reconnaissance",
        "verdict": "false_positive",
        "confidence": 0.99,
        "reason": "The line describes the methodology of prior isolated test runs. It does not instruct runtime system discovery."
      }
    ],
    "semantic_findings": [],
    "critical_findings": [],
    "high_findings": [],
    "medium_findings": [],
    "low_findings": [],
    "dangerous_patterns": [],
    "files_scanned": 12,
    "total_lines": 1702,
    "audit_model": "codex",
    "audited_at": "2026-08-24T13:00:13.810Z",
    "agent_auto_install_policy": "allowed",
    "manual_install_policy": "allowed"
  },
  "content": {
    "user_title": "Build Auditable OT Cost Analyses",
    "value_statement": "Other Transaction budgets can mix cost shares, milestone payments, fees, and unlike price bases. This skill builds traceable workbooks with neutral comparisons and validated formulas.",
    "seo_keywords": [
      "Claude",
      "Codex",
      "Claude Code",
      "OT cost analysis",
      "Other Transaction cost estimate",
      "milestone pricing",
      "cost share analysis",
      "government funding profile",
      "Excel should-cost workbook"
    ],
    "actual_capabilities": [
      "Builds seven-sheet, formula-driven XLSX workbooks organized by OT milestone.",
      "Benchmarks labor with BLS OEWS data and positions rates against CALC+ results.",
      "Calculates project cost, performer contribution, Government share, fees, ceilings, and funding needs.",
      "Models low, working, and high scenarios from documented assumptions.",
      "Validates workbook structure and independently recomputes expected values with bundled Python scripts."
    ],
    "limitations": [
      "Requires user-supplied authority, cost-share terms, fee treatment, milestones, and other agreement facts.",
      "Does not make legal, eligibility, price-reasonableness, or negotiation determinations.",
      "Needs configured BLS OEWS, GSA CALC+, and applicable GSA Per Diem MCP operations.",
      "Cannot independently execute spreadsheet formulas without Excel, LibreOffice, or another supported calculation engine."
    ],
    "use_cases": [
      {
        "title": "Prepare a pre-solicitation budget",
        "description": "Build a milestone-based should-cost and funding profile before proposed prices are available.",
        "target_user": "Government acquisition analyst"
      },
      {
        "title": "Compare a proposed amount",
        "description": "Normalize the proposal basis and present neutral variances, benchmarks, and scenario positions.",
        "target_user": "Agreements Officer"
      },
      {
        "title": "Plan performer cost sharing",
        "description": "Model cash and in-kind contributions by milestone while preserving approved ratios and fee treatment.",
        "target_user": "OT program manager"
      }
    ],
    "prompt_templates": [
      {
        "title": "Start an OT cost estimate",
        "prompt": "Build an OT cost estimate from these approved milestones: [milestones]. Ask me for missing authority, contribution, staffing, location, and fee inputs.",
        "scenario": "Beginner estimate from an approved milestone plan"
      },
      {
        "title": "Create a pre-solicitation workbook",
        "prompt": "Create a pre-solicitation workbook for a [research/prototype/production] OT. Use [authority path] and this approved performer contribution: [terms].",
        "scenario": "Intermediate workbook without a proposal"
      },
      {
        "title": "Compare a proposal neutrally",
        "prompt": "Compare this proposed amount without making a price-reasonableness determination. Confirm its basis, then show variance, benchmarks, scenarios, and missing evidence.",
        "scenario": "Advanced proposed-amount analysis"
      },
      {
        "title": "Model mixed milestone economics",
        "prompt": "Model fixed and cost-type milestones using these approved ceilings, contribution terms, fees, labor assumptions, materials, travel, and funding dates: [inputs].",
        "scenario": "Advanced multi-basis funding and sensitivity analysis"
      }
    ],
    "output_examples": [
      {
        "input": "Prototype OT with three milestones, a one-third performer share, and no proposal.",
        "output": "A seven-sheet workbook showing milestone costs, contributions, scenarios, labor benchmarks, methodology, raw source records, and a cumulative Government funding profile."
      },
      {
        "input": "Cost-type proposal with an approved ceiling and a user-supplied administrative fee.",
        "output": [
          "Independent should-cost and ceiling views use the same contribution basis.",
          "The fee is displayed separately using the supplied rate, base, timing, and treatment.",
          "Proposal variance is presented without a fair-and-reasonable conclusion."
        ]
      },
      {
        "input": "Concept-stage research OT with incomplete milestones and multiple performer locations.",
        "output": "A candidate milestone table for approval, followed by location-specific labor benchmarking only after the user confirms the structure."
      }
    ],
    "best_practices": [
      "Provide the approved authority, contribution arrangement, milestone structure, proposal basis, and fee treatment before calculation.",
      "Keep each performer and location separate when selecting labor benchmarks.",
      "Run structural, independent recomputation, and real spreadsheet engine validation before delivery."
    ],
    "anti_patterns": [
      "Do not ask the skill to choose statutory authority or determine participant eligibility.",
      "Do not compare a Government funding request directly with total project cost.",
      "Do not invent burden rates, fees, learning curves, cost shares, or specialty premiums."
    ],
    "faq": [
      {
        "question": "Can this skill produce a FAR-based IGCE?",
        "answer": "No. It is limited to Other Transaction cost analysis and does not produce FAR 15.404 analyses."
      },
      {
        "question": "Can it decide whether a proposed price is reasonable?",
        "answer": "No. It presents neutral evidence, variances, and scenarios while leaving the determination to the Agreements Officer."
      },
      {
        "question": "Which data services are required?",
        "answer": "A build requires BLS OEWS and GSA CALC+ operations. GSA Per Diem operations are required when covered travel applies."
      },
      {
        "question": "Can it start without approved milestones?",
        "answer": "Yes. It can propose a candidate structure, but it waits for user approval before pricing or workbook assembly."
      },
      {
        "question": "How are cost-type milestones handled?",
        "answer": "The workbook shows independent should-cost and approved ceiling views using the same contribution basis."
      },
      {
        "question": "Does the workbook calculate formulas automatically?",
        "answer": "The workbook contains formulas. Independent execution requires Excel, LibreOffice, or another supported calculation engine."
      }
    ]
  },
  "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": "authority-and-cost-sharing.md",
          "type": "file",
          "path": "references/authority-and-cost-sharing.md",
          "lines": 99
        },
        {
          "name": "data-source-operations.md",
          "type": "file",
          "path": "references/data-source-operations.md",
          "lines": 138
        },
        {
          "name": "labor-and-costing-methods.md",
          "type": "file",
          "path": "references/labor-and-costing-methods.md",
          "lines": 102
        },
        {
          "name": "runtime-adaptation.md",
          "type": "file",
          "path": "references/runtime-adaptation.md",
          "lines": 40
        },
        {
          "name": "validation-gates.md",
          "type": "file",
          "path": "references/validation-gates.md",
          "lines": 141
        },
        {
          "name": "workbook-specification.md",
          "type": "file",
          "path": "references/workbook-specification.md",
          "lines": 170
        }
      ]
    },
    {
      "name": "scripts",
      "type": "dir",
      "path": "scripts",
      "children": [
        {
          "name": "recompute_expected_values.py",
          "type": "file",
          "path": "scripts/recompute_expected_values.py",
          "lines": 268
        },
        {
          "name": "validate_workbook.py",
          "type": "file",
          "path": "scripts/validate_workbook.py",
          "lines": 308
        }
      ]
    },
    {
      "name": "SKILL.md",
      "type": "file",
      "path": "SKILL.md",
      "lines": 240
    },
    {
      "name": "test.md",
      "type": "file",
      "path": "test.md",
      "lines": 54
    },
    {
      "name": "testing.md",
      "type": "file",
      "path": "testing.md",
      "lines": 134
    }
  ]
}
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