agentsclimarketplace

Spreadsheet formula helper

Skill bg-szy/TOP-SKILLS/skills/agent-skills/spreadsheet-formula-helper

全球最大的 Claude Code 技能聚合库 · 收录 3900+ 来自 12+ 来源的技能，提供在线搜索与趋势分析看板 / The world's largest Claude Code skill aggregation hub — 3900+ skills from 12+ sources with online search and trend dashboard

Install
npx -y skills add bg-szy/TOP-SKILLS --skill spreadsheet-formula-helper

Assembled from the repository path, not quoted from the project. Check it against their README if it does not work.

2 things to look at

  • no licenseNo license file was found in the repository. Code published without one is not open source by default, so using it at work is a question for whoever answers licensing questions where you are.
  • 4 stars4 stars. Stars are a popularity signal and not a quality one, but at this level it is likely that nobody has read this closely except its author, and you would be relying on your own review.

What its author says it does

Copied from the file, not written here

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.

SKILL.md

4.6 KB, 885 tokens by cl100k_base, as published. Nobody here has run it

Spreadsheet Formula Helper

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

  1. Restate the problem with explicit ranges and sheet names; propose a minimal sample to verify.
  2. Draft formula(s); when dynamic arrays are available, prefer them over copy-down formulas.
  3. Explain how it works and where to place it; include named ranges if helpful.
  4. Edge cases: blank rows, mixed types, timezone/date quirks, duplicates; offer guardrails (e.g., IFERROR, LET, LAMBDA).
  5. 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.
<!-- MCP:START --> <!-- PORTABILITY:START -->

Verification Protocol

Before claiming the spreadsheet-formula-helper workflow succeeded:

  1. Pass/fail: The request matches this skill's documented activation boundary.
  2. Pass/fail: Required inputs, dependencies, and safety checks were resolved or reported as blockers.
  3. Pass/fail: The narrowest relevant workflow was completed without inventing unavailable tools or results.
  4. Pass/fail: Output was checked with the most relevant local test, inspection, render, or source evidence.
  5. Pressure test: Repeat the decision with the preferred integration unavailable and confirm the fallback remains safe and actionable.
  6. 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.
<!-- PORTABILITY:END -->

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.
<!-- MCP:END -->

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.

Keep looking

Skills are one crate of 328,083. Ordering is by how many stacks a row turns up in, so the top of any crate is what has actually been picked rather than what has the most stars.