aiskillstore/marketplace / skills/1102tools-dev/igce-builder-lh-tm
igce-builder-lh-tm
VerifiedTrigger for: Labor-Hour IGCE, LH estimate, Time-and-Materials IGCE, T&M estimate, burdened hourly rate, burden multiplier, labor-category ceiling hours, materials estimate, proposed LH/T&M rate validation, price-reasonableness memo, or fair-and-reasonable analysis. Build auditable LH/T&M estimates using BLS OEWS wages, explicit burden multipliers, GSA CALC+ positioning, GSA Per Diem travel, and separately priced T&M materials. Do NOT use for FFP, cost-reimbursement, grants, or cooperative agreements. Requires the bls-oews, gsa-calc, and gsa-perdiem MCP servers.
| File | Kind | Size |
|---|---|---|
| SKILL.md | skill md | 15.7 KB |
| agents/openai.yaml | config | 297 B |
| references/data-source-operations.md | markdown | 13.4 KB |
| references/runtime-adaptation.md | markdown | 2.7 KB |
| references/validation-gates.md | markdown | 3.9 KB |
| references/workbook-specification.md | markdown | 5.9 KB |
| references/wrap-rate-presets.md | markdown | 2.8 KB |
| scripts/recompute_expected_values.py | script | 8.4 KB |
| scripts/validate_workbook.py | script | 22.3 KB |
| skill-report.json | config | 51.5 KB |
| test.md | markdown | 3.8 KB |
| testing.md | markdown | 31.6 KB |
references/validation-gates.md
View on GitHub# LH/T&M Workbook Validation Gates
Run all applicable gates before delivery.
## Automated structure
The bundled validator checks:
- All seven required sheets exist.
- Summary month-gap and aging formulas use the portable `YYYY-MM` pattern.
- Scenario Analysis blocks follow the 13-row layout.
- Direct hourly is the fifth row of each block and cross-sheet formulas do not reference the aged-wage row.
- Low, mid, and high burdened rates use only labor and the stated multiplier.
- Formula text contains no error tokens and annotations are escaped.
- Custom formula assertions from the JSON sidecar pass.
## Independent recomputation
Create a sidecar from raw inputs. Example:
```json
{
"assumptions": {
"contract_type": "T&M",
"burden_low": 1.8,
"burden_mid": 2.0,
"burden_high": 2.2,
"aging_factor": 1.025,
"productive_hours": 1880,
"ceiling_price": 900000
},
"labor_lines": [
{
"name": "Software Developer",
"annual_wage": 135000,
"fte": 2,
"months": 12,
"ceiling_hours": 3760,
"workbook_low_rate_cell": "'Scenario Analysis'!B8",
"workbook_mid_rate_cell": "'Scenario Analysis'!B10",
"workbook_high_rate_cell": "'Scenario Analysis'!B12"
}
],
"non_labor_lines": [
{
"name": "Cloud hosting",
"category": "materials",
"amount": 24000,
"workbook_total_cell": "'Materials Detail'!B10"
}
],
"material_handling_assertions": [
{
"cell": "'Materials Detail'!G10",
"equals": 1250,
"basis": "User-supplied accounting practice dated 2026-08-23"
}
],
"workbook_low_total_cell": "'IGCE Summary'!B30",
"workbook_mid_total_cell": "'IGCE Summary'!B31",
"workbook_high_total_cell": "'IGCE Summary'!B32",
"workbook_ceiling_price_cell": "'IGCE Summary'!B13"
}
```
The recomputation rejects positive materials in an LH estimate. For continuous coverage, add `annual_coverage_hours`; incompatible FTE and productive hours are rejected.
Material handling defaults to numeric zero. Every nonzero input or formula in a `Material Handling` column must have a matching `material_handling_assertions` entry containing the exact cell, value or formula, and a non-empty user-supplied accounting or solicitation basis. An undisclosed percentage formula is a validation failure.
Run:
```text
python scripts/recompute_expected_values.py validation-input.json
python scripts/validate_workbook.py output.xlsx --expected validation-input.json --engine auto
```
## Real-engine verification
When LibreOffice is present, `--engine auto` executes formulas headlessly and compares cached values with independent Python results. Without a real engine, use the exact disclosure in Step 8.5 and do not call openpyxl recalculation.
## Manual gates
- Contract type is user-confirmed as LH or T&M.
- Labor-category ceiling hours and total ceiling price are shown as inputs.
- The IGCE total is not mislabeled as the binding ceiling.
- Burden applies only to labor.
- T&M materials, including travel and computer usage, remain outside labor burden.
- Material handling is supported indirect cost, not an arbitrary fee or profit percentage.
- Every nonzero material-handling input or formula resolves to the exact sidecar cell, value or formula, and disclosed basis.
- LH has no positive materials amount.
- Day-trip M&IE is discounted exactly once.
- CALC+ comparison uses burdened labor and neutral language.
- BLS vintage is runtime-confirmed and aging is cell-referenced.
## Fault injection
At minimum, confirm rejection of:
1. `DATEDIF` or `YEAR` on text for aging.
2. A summary formula that references the aged-wage row instead of a rate.
3. Positive materials in an LH sidecar.
4. A 4.2 FTE by 1,880-hour basis against 8,760 coverage hours.
5. A material formula multiplied by the labor burden.
6. A material-handling percentage with no disclosed source.
Record automated and manual results in `test.md`.
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 |