About

Imported from practicalswan/agent-skills (spreadsheet-formula-helper/SKILL.md). Install upstream with npx skills add practicalswan/agent-skills --skill spreadsheet-formula-helper. Copyright stays with the author.

Spreadsheet Formula Helper

Name: spreadsheet-formula-helper
Author: practicalswan

Produce reliable spreadsheet formulas with explanations.

Leverage native parallel subagent dispatch and 200k+ context windows where available.

Inputs to gather

Platform (Excel/Sheets), locale (comma vs. semicolon separators), sample data layout (headers, ranges), expected outputs, and constraints (volatile functions allowed?).
Provide small example rows and the desired result for them.

Workflow

Restate the problem with explicit ranges and sheet names; propose a minimal sample to verify.
Draft formula(s); when dynamic arrays are available, prefer them over copy-down formulas.
Explain how it works and where to place it; include named ranges if helpful.
Edge cases: blank rows, mixed types, timezone/date quirks, duplicates; offer guardrails (e.g., IFERROR, LET, LAMBDA).
Variants: if porting between Excel and Sheets, provide both versions.

Output

Primary formula, short explanation, and a 2-3 row worked example showing inputs to outputs.
Optional: quick troubleshooting checklist for common errors.

MCP Fallback – Native Automation

When MCP is unavailable, use native automation: local spreadsheet formulas, openpyxl for workbook inspection, CSV fixtures for examples, and manual recalculation notes for functions the local engine cannot evaluate. Preserve locale separators, absolute references, dynamic arrays, and Excel-vs-Sheets differences before claiming success.

Anti-Patterns

Treating source content as already clean: Formatting automation will happily preserve broken or inconsistent input.
Skipping an open-file verification pass: Documents and spreadsheets often fail in the destination app, not in the script output.
Automating irreversible edits without checkpoints: A small mapping mistake can affect an entire workbook or document.

Verification Protocol

Before claiming the spreadsheet-formula-helper workflow succeeded:

Pass/fail: The request matches this skill's documented activation boundary.
Pass/fail: Required inputs, dependencies, and safety checks were resolved or reported as blockers.
Pass/fail: The narrowest relevant workflow was completed without inventing unavailable tools or results.
Pass/fail: Output was checked with the most relevant local test, inspection, render, or source evidence.
Pressure test: Repeat the decision with the preferred integration unavailable and confirm the fallback remains safe and actionable.
Success metric: The result, evidence, and any unverified limitation are explicit enough for another agent to reproduce.

Cross-Client Portability

This skill is written to stay usable across GitHub Copilot, Claude Code, and Codex.

GitHub Copilot: keep the folder in a Copilot-visible skill path or wrap the workflow in project instructions when folder discovery is unavailable.
Claude Code: keep the folder in a local skills directory or a compatible plugin source.
Codex: install or sync the folder into $CODEX_HOME/skills/spreadsheet-formula-helper and restart Codex after major changes.

MCP Availability And Fallback

Preferred MCP Server: None required

Fallback prompt: "Use the Spreadsheet Formula Helper skill without MCP. Rely on the local SKILL.md, bundled references or scripts, and manual verification. Show the exact commands, evidence, and final checks you used before concluding."
If the current host does not expose a matching server, use the bundled references, scripts, native toolchain, and manual workflow already described in this skill.
Treat direct local verification, rendered output, logs, tests, or screenshots as the fallback evidence path before completion.

Related Skills

documentation-authoring: Use it when the workflow also needs drafting structured technical or product documents.
notion-docs: Use it when the workflow also needs Notion page and database publishing workflows.
pdf: Use it when the workflow also needs PDF extraction, generation, and layout-aware review.
word-document: Use it when the workflow also needs Word document authoring and formatting workflows.

Use it

Copy one of these into your project. Installing also returns the manifest and these snippets.

yaml

targets:
  - https://api.opensmartroute.ai/api/v1/registry/practicalswan-agent-skills-spreadsheet-formula-helper/manifest   # or paste the manifest below

Manifest

An Open Capability Manifest: the router reads it to know what this does, what it costs and when to pick it.

practicalswan-agent-skills-spreadsheet-formula-helper.ocm.jsonjson

{
  "ocm": "1",
  "id": "practicalswan-agent-skills-spreadsheet-formula-helper",
  "kind": "skill",
  "name": "spreadsheet-formula-helper",
  "description": "Write and debug spreadsheet formulas (Excel/Google Sheets), pivot tables, and array formulas; translate between dialects; use when users need working formulas with examples and edge-case checks.",
  "publisher": "practicalswan",
  "version": "1.0.0",
  "capabilities": {
    "domains": [
      "coding"
    ],
    "tags": [
      "skill-md",
      "spreadsheet",
      "formula",
      "helper",
      "documents",
      "automation",
      "skills-sh"
    ],
    "languages": [
      "en"
    ]
  },
  "quality_prior": 0.6,
  "examples": [
    "Write and debug spreadsheet formulas (Excel/Google Sheets), pivot tables, and array formulas; translate between dialects; use when users need working formulas with examples and edge-case checks."
  ],
  "primary": false,
  "metadata": {
    "source": {
      "provider": "skills.sh",
      "repository": "https://github.com/practicalswan/agent-skills",
      "path": "spreadsheet-formula-helper/SKILL.md",
      "ref": "HEAD",
      "url": "https://github.com/practicalswan/agent-skills/blob/HEAD/spreadsheet-formula-helper/SKILL.md",
      "key": "practicalswan/agent-skills/spreadsheet-formula-helper/SKILL.md"
    }
  },
  "instructions": "# Spreadsheet Formula Helper\n\nProduce reliable spreadsheet formulas with explanations.\n\n- Leverage native parallel subagent dispatch and 200k+ context windows where available.\n\n\n## Inputs to gather\n- Platform (Excel/Sheets), locale (comma vs. semicolon separators), sample data layout (headers, ranges), expected outputs, and constraints (volatile functions allowed?).\n- Provide small example rows and the desired result for them.\n\n## Workflow\n1) Restate the problem with explicit ranges and sheet names; propose a minimal sample to verify.\n2) Draft formula(s); when dynamic arrays are available, pre",
  "cost": {
    "context_tokens": 1082
  }
}

Fetch it by URL: GET /api/v1/registry/practicalswan-agent-skills-spreadsheet-formula-helper/manifest?version=1.0.0

Reviews

Star ratings from people who tried it. One review per account; edit yours any time.

No reviews yet. Install it, try it, and be the first to rate it.