model-audit-tieout — Codex skill: what it does, how to install
Audits existing public equity spreadsheets and valuation files for broken formulas, hardcodes, and source gaps. Does not build new models from scratch.
npx skills add openai/plugins --skill model-audit-tieout -a codexWhat model-audit-tieout does
This workflow runs quality assurance across pre-built valuation spreadsheets and equity forecast workbooks. It flags volatile functions, unlinked plugs, broken references, circular math, and hardcoded numbers where calculations belong. It leaves original workbook formulas intact unless remediation is directly requested.
The inspection flow relies on scripts/audit_workbook.py to parse .xlsx files. Running that helper script without openpyxl installed in your Python environment causes an immediate failure. Findings are compiled into an issue log, tie-out records against filings, and a readiness verdict covering whether the model can back investment decisions.
What it helps with
- detect hardcoded inputs, circularity, and broken links across spreadsheet tabs
- reconcile valuation drivers against primary earnings filings and company reports
- produce an audit memo with a prioritized list of model defects
- verify downside scenarios for dilution and multiple compression risks
Example prompts for the agent
- Inspect
dcf_model.xlsxfor formula inconsistencies and hidden tabs - Tie out the operating forecast assumptions against the latest earnings release
- Run an audit on the equity workbook and create a standalone HTML report
How to install model-audit-tieout
1Skills CLI (Vercel)
npx skills add openai/plugins --skill model-audit-tieout -a codex2Manually: put the files in place
.agents/skills/model-audit-tieout/SKILL.mdFor all projects use ~/.agents/skills/
1Skills CLI (Vercel)
npx skills add openai/plugins --skill model-audit-tieout -a claude-code2Manually: put the files in place
~/.claude/skills/model-audit-tieout/SKILL.mdCopy the whole skill folder; for one project use .claude/skills/model-audit-tieout/
Manually: put the files in place
.cursor/skills/model-audit-tieout/SKILL.mdCursor also reads .agents/skills/ and .claude/skills/
1GitHub CLI
gh skill install openai/plugins model-audit-tieout2Manually: put the files in place
.github/skills/model-audit-tieout/SKILL.mdPlatform CLI
gemini skills install https://github.com/openai/plugins --path plugins/public-equity-investing/skills/model-audit-tieoutManually: put the files in place
.devin/skills/model-audit-tieout/SKILL.mdThe legacy .windsurf/skills/ path still works
Claude.ai
Zip the folder and upload it in Settings → Capabilities → Skills
Step by step, with commands for each platform: Codex skills: how to install, where they live, how to call them
Questions about model-audit-tieout
How do I install model-audit-tieout in Codex?
Run npx skills add openai/plugins --skill model-audit-tieout -a codex. Codex places the skill configuration under .agents/skills/model-audit-tieout/SKILL.md.
What is model-audit-tieout used for?
It verifies existing public equity valuation files and spreadsheets before they are used in portfolio decisions. The skill checks formula integrity, flags unsupported assumptions, and issues an explicit audit verdict.
Which dependencies does the local inspection script need?
The included scripts/audit_workbook.py utility requires openpyxl to inspect Excel workbooks. You can install it using python -m pip install -r scripts/requirements.txt.