What do I need to use Formula Detangler?

The formula, verbatim; The believed behavior; The platform; The blast radius.

Is Formula Detangler free to use?

Yes — run it free in the browser playground (no API key needed for the sponsored trial, or bring any provider key), or install it into Claude Code, Cursor, ChatGPT and more via npx pm-claude-skills. MIT-licensed and open source.

Formula Detangler

Q: How do I know the Formula Detangler output is good?

The skill verifies itself against its own quality checks: Every layer has its plain-language sentence; Every error-suppression names what it swallows; Helper columns carry job-stating headers; The rebuild was parallel-run against real data before switchover.

🔵 Stable🕐 updated 2026-07-19 🔷 SkillSpec L3 pm-cowork

Untangle the spreadsheet formula nobody dares touch — decompose the seven-function nest into named readable steps, explain what it actually does (vs. what it's believed to do), and rebuild it maintainably with helper columns and modern functions. Use when asked what does this formula do, this IFERROR-VLOOKUP monster broke, make this formula maintainable, or nobody understands the sheet the analyst left. Produces the plain-language decode, the step decomposition into helper columns, the believed-vs-actual gaps, and the rebuilt version.

▶ Run it free — no key needed 📝 Grade your existing draft View SKILL.md ↗

What to give it

▸The formula, verbatim — and the cells/ranges it references (the decode reads the actual text, not a description)

▸The believed behavior — what the team *thinks* it does ("it pulls the latest price for the customer's tier") — the decode is diffed against this, and the diff is often the payoff

▸The platform — Excel/Sheets and roughly the version; rebuild options (XLOOKUP, LET, IFS, dynamic arrays) depend on it

▸The blast radius — what reads this cell; rebuilds get verified against current outputs before anything switches over

✅ The bar it holds itself to

Every skill in this library self-verifies — these are this skill's own quality checks, straight from its definition.

✓Every layer has its plain-language sentence

✓Every error-suppression names what it swallows

✓Helper columns carry job-stating headers

✓The rebuild was parallel-run against real data before switchover

✓Diffs were investigated as possible original-bugs, not auto-matched

⚠️ What it refuses to do

Do not "fix" before decoding — editing a formula you can't narrate is surgery blindfolded

Do not preserve heroic one-liners for pride — maintainability is the requirement; cleverness was the problem

Do not let IFERROR survive uninterrogated — silent blanks are how sheets lie politely

Do not match the rebuild to the original's bugs — believed-vs-actual gaps get decided, not replicated

Do not switch over without the parallel diff — equivalence is demonstrated, never assumed

Install

npx pm-claude-skills add --agent claude   # or codex · cursor · gemini · hermes
# or one-line MCP (every skill, any client):
claude mcp add pm-skills -- npx -y pm-claude-skills-mcp

Related skills

🔌 Embed this skill

Drop this on your blog, docs, or site — it renders a "Run this skill" card:

<div data-pm-skill="formula-detangler"></div>
<script src="https://mohitagw15856.github.io/pm-claude-skills/embed.js" async></script>

💬 Discussion

Formula Detangler is one of 750 open-source professional AI agent skills — all SkillSpec L3. Try them all in the browser · ⭐ Star on GitHub · Browse the full catalog