spreadsheet-formula-helper
The spreadsheet-formula-helper generates and debugs formulas for Excel and Google Sheets. It handles pivot tables, array formulas, and dialect translation while providing examples and edge-case guardrails.
Is spreadsheet-formula-helper safe to install?
Safe to install: our audit of spreadsheet-formula-helper's source files found 0 shell commands, 0 external URLs, no file writes (none risk). Every command and URL listed appears verbatim in the skill's source. The skill performs text generation based on user input and does not interact with the file system or network.
How we audit skills: our security review methodology.
Who is this skill for?
Users requiring assistance with spreadsheet formula construction, debugging, or porting between Excel and Google Sheets.
What can you do with it?
- Drafting Excel and Google Sheets formulas
- Debugging spreadsheet errors
- Creating pivot tables
- Translating formulas between Excel and Google Sheets
- Implementing array formulas and dynamic range logic
How good is this skill?
Quality score: 5/10. The skill documentation provides a clear workflow and specific input requirements for formula generation.
What does the skill file contain?
# Spreadsheet 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 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 n...
Frequently asked questions
Does this skill execute formulas in my spreadsheet?
No. The skill provides formula text and explanations for the user to implement manually.
What information does the skill require to function?
The skill requires the platform type, locale settings, sample data layout, expected outputs, and any specific constraints.
Can the skill handle differences between Excel and Google Sheets?
Yes. The skill provides variants for both platforms when porting formulas.
Related skills
customer-research
46.7KProduct marketers, founders, and researchers who need to ground their strategy in customer data
The customer-research skill provides a framework for analyzing existing research assets and gathering new insights from online communities to inform product marketing, messaging, and persona development.
content-pattern-analyzer-sms
602Social media managers and content creators who want to identify which content strategies drive engagement and which underperform
The content-pattern-analyzer-sms skill identifies performance trends in social media content by analyzing post history across seven dimensions, including topic, format, timing, length, hook type, tone, and platform. It produces a structured report detailing content to prioritize, content to reduce, and experimental gaps to test.
market-research-analysis
595Consultants, product managers, and market researchers who need to perform industry analysis, competitive landscape mapping, and generate long-form research reports
This skill provides a framework for conducting market research, including market sizing, competitive analysis, consumer research, and the generation of professional consulting-style reports using LaTeX and automated visual generation.
sheets-terminal-spreadsheet
593Developers and terminal users who need to view, edit, or programmatically manipulate CSV files without leaving the command line
Sheets is a terminal-based spreadsheet tool for viewing and editing CSV files. It provides vim-like keybindings, formula support, visual selection, and non-interactive command-line access for reading or modifying specific cells.