aiskillstore/marketplace / skills/1102tools-dev/ot-cost-analysis
ot-cost-analysis
VerifiedTrigger 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.
| File | Kind | Size |
|---|---|---|
| SKILL.md | skill md | 17.3 KB |
| agents/openai.yaml | config | 300 B |
| references/authority-and-cost-sharing.md | markdown | 4.9 KB |
| references/data-source-operations.md | markdown | 6.2 KB |
| references/labor-and-costing-methods.md | markdown | 3.8 KB |
| references/runtime-adaptation.md | markdown | 2.6 KB |
| references/validation-gates.md | markdown | 4.7 KB |
| references/workbook-specification.md | markdown | 6.3 KB |
| scripts/recompute_expected_values.py | script | 10.2 KB |
| scripts/validate_workbook.py | script | 12.2 KB |
| skill-report.json | config | 41.5 KB |
| test.md | markdown | 4.1 KB |
| testing.md | markdown | 11.2 KB |
references/validation-gates.md
View on GitHub# OT Cost Analysis Validation Gates
Run all available layers against the final workbook and rerun after any change.
## 1. Validation input
Create temporary JSON from the same raw objects used to build the workbook. Minimal shape:
```json
{
"assumptions": {
"authority": "prototype",
"authority_path": "C",
"performer_share_ratio": 0.3333333333333333,
"fee_rate": 0.02,
"burden_multiplier": 2.0,
"labor_aging_factor": 1.03,
"labor_escalation_rate": 0.025,
"materials_escalation_rate": 0.03,
"cost_type_ceiling_margin": 0.15
},
"milestones": [
{
"id": "M1",
"payment_type": "Fixed",
"months_from_start": 0,
"labor_lines": [
{"name": "Software Developer", "annual_wage": 132000, "hours": 1880}
],
"materials": 100000,
"travel": 10000,
"odcs": 5000,
"proposed_amount": null,
"workbook_project_cost_cell": "'OT Cost Summary'!D19",
"workbook_government_funding_cell": "'OT Cost Summary'!I19"
}
],
"workbook_total_project_cost_cell": "'OT Cost Summary'!D20",
"workbook_total_government_funding_cell": "'OT Cost Summary'!I20",
"formula_assertions": [
{
"cell": "'OT Cost Summary'!B8",
"contains": ["VALUE(LEFT(B7,4))", "VALUE(MID(B7,6,2))"],
"not_contains": ["DATEDIF", "YEAR("]
}
]
}
```
For production, set `production_ratio_source` to a nonempty user-supplied source. Do not label the ratio inherited. For Path D, set `exceptional_circumstances_confirmed` only from user-supplied facts.
## 2. Formula structure
Run:
```text
python scripts/validate_workbook.py workbook.xlsx --expected inputs.json --engine none
```
The audit checks:
- Seven required sheets
- Summary B8/B9 aging formulas and forbidden `DATEDIF`/`YEAR(` patterns
- Formula presence and formula-error tokens
- Cost-share and fee formulas supplied as assertions
- Blank pre-solicitation proposed cells and conditional variance formulas
- Cost-type Government and performer branches using the same ceiling basis
- No stale `competition commitment` Path D language
- No automatic 100% Government funding claim for 4021 or 4022(f)
- No generated price-reasonableness conclusion
## 3. Independent recomputation
Run:
```text
python scripts/recompute_expected_values.py inputs.json
```
The script independently computes aged labor, burdened labor, materials escalation, total project cost, contribution shares, fee, cost-type ceiling view, and Government funding requirement. It also validates authority-path arithmetic.
Do not derive expected values from workbook formula results.
## 4. Real-engine verification
Run:
```text
python scripts/validate_workbook.py workbook.xlsx --expected inputs.json --engine auto
```
The validator recalculates a temporary copy through LibreOffice when available and reopens cached values. It scans every cell on every recalculated worksheet for cached spreadsheet errors before comparing referenced cells with the independent computation. Use `--engine libreoffice` to require this layer.
## 5. Named regression gates
### Authority and cost share
- Path D means written exceptional circumstances, never competition commitment.
- Path C performer share is at least exact one-third of total project cost.
- Research ratio is user supplied; no automatic zero or 50 percent.
- Production ratio is user supplied; no automatic zero and no inherited prototype ratio.
- Government and performer project shares reconcile before separately treated fees.
### Proposed amount
- Amount basis is explicit.
- Comparison uses the matching workbook basis.
- A blank proposed amount yields a blank variance, not text or a formula error.
### Formula behavior
- BLS aging is cell referenced.
- Materials escalation uses milestone-start months.
- Cost-type Government and performer values use the same ceiling basis.
- Fee uses an approved base and defaults to zero.
- Cumulative Government funding is a running formula.
- Dynamic Milestone Detail blocks do not rely on a fixed row stride.
### Data sources and pacing
- CALC+ keyword calls use `keyword=`, never `q=`.
- Discovery records `aggregations.labor_category.buckets` keys and counts.
- `detect_latest_year` controls the BLS vintage.
- Keyed calls are serialized with at least three seconds between them.
### AI boundary
- Workflow B first response stops at Option A or B without tool calls.
- Option A contains neutral evidence and no verdict.
- Option B conclusion text is verbatim user text and visibly marked DRAFT.
## 6. Result language
When all three layers pass, state:
> Formula structure, independent calculations, and LibreOffice formula execution passed.
Without a real engine, state exactly:
> Formula structure and independent calculations passed. Formula execution was not independently verified in Excel or LibreOffice.
Related skills
| Skill | Stars | Updated | Works with | Status | Install |
|---|---|---|---|---|---|
| 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: 472k | Updated | Claude CodeCodex | Verified | Install |
| 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: 472k | Updated | Claude CodeCodex | Verified | Install |
| rea-tool-designmorluto/reaAudit, investigate, design, or change REA investigation tools, CLI/MCP contracts, provider capabilities, and Evidence semantics. | Stars: 472k | Updated | Claude CodeCodex | Verified | Install |
| ponytail-auditDietrichGebert/ponytailQuality audit of the whole repo: bugs, security, real load, missing tests, speed, and what to delete. Most important first. | Stars: 194k | Updated | Claude CodeCodex | Verified | Install |