S
spreadsheet-formula-helper
About spreadsheet-formula-helper
A skill for producing spreadsheet formulas with explanations, aimed at people solving tasks in Excel or Sheets. It gathers platform, data layout, expected results, and constraints, then develops and checks formula options.
Key features
- 01Gather platform and data details
- 02Draft formulas for the stated task
- 03Explain formula placement and logic
- 04Address edge cases and errors
- 05Offer Excel and Sheets variants
Use cases
- 01Calculate results from sample data
- 02Handle blanks, duplicates, or mixed types
- 03Port a formula between Excel and Sheets
Install
Copy the command and run it in a terminal.
$
npx skills add https:/After installing, type/spreadsheet-formula-helperin Claude Code to confirm it loaded.
Details
From the project READMESpreadsheet Formula Helper
Produce reliable spreadsheet formulas with explanations.
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 → outputs.
- Optional: quick troubleshooting checklist for common errors.
Comments
Markdown supported