writing-performant-formulas
Execution skill. Use when reviewing or finalizing Pigment formulas before delivery. Provides the mandatory pre-delivery checklist, sparsity preservation rules, scope-first patterns, and anti-patterns to avoid.
Install
With your agent
Install OMGSkills skill "gopigment/ai-plugins:skills/writing-performant-formulas" into this agent's normal skills directory: call the OMGSkills MCP get_install_plan tool for your agent and run the script it returns (it installs only the pinned commit and verifies SKILL.md), and stop if MCP or the pin is unavailable. Do not overwrite or change existing skills without asking me.
Manual command
git clone https://github.com/gopigment/ai-plugins /tmp/ai-plugins && ln -s /tmp/ai-plugins/skills/writing-performant-formulas ~/.claude/skills/writing-performant-formulasFrom README
Writing Performant Pigment Formulas Apply this skill to every formula before delivery. Pigment is a sparse multidimensional engine: only defined cells are stored. Performance depends on keeping formulas sparse and scoped. Simple same-dimension arithmetic (e.g. 'A' + 'B') needs no special performance wrapping. Always review the checklist; deep rewrite when any item fails. For profiler-based troubleshooting after delivery, see skill:diagnosing-performance-issues. Pre-Delivery Checklist Before delivering any formula, verify each item. Rewrite until all pass. Identifiers: Correctly quoted — single quotes for names ('Revenue'), double quotes for items and text literals. Dimension alignment: No unintended ADD or dimension mismatch. Sparsity: No unnecessary 0, FALSE, or TRUE where BLANK suffices. Existence checks: Prefer ISDEFINED / IFDEFINED / IFBLANK over ISBLANK / ISNOTBLANK (see skill:using-formula-functions for rare valid exceptions).