跳到正文
cccskills
免费在 GitHub 公开

spreadsheet-formula-helper

Create and debug formulas for Excel and Google Sheets, including formulas that return multiple results. Get placement instructions, worked examples, checks for blanks and duplicates, and equivalent formulas when moving between platforms.

中文简介正在准备中。当前显示英语简介。

原文查看原文说明

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.

集成工具Google SheetsExcel
查看安装方法

适用场景

  • Create formulas from sample data and expected results
  • Fix errors caused by blanks or duplicate values
  • Convert formulas between Excel and Google Sheets
  • Build array formulas and pivot tables

包含的文件(1)

  • SKILL.md1.3 KB

SKILL.md(原文)

安装前可以查看交给 AI 代理的指令内容。

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 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 → outputs.
  • Optional: quick troubleshooting checklist for common errors.

评价

还没有评价。欢迎分享你的使用感受。

评论

无需登录即可发表。欢迎分享使用感受、提问,或说明在哪些环境下无法运行。

还没有评论。来写第一条吧。

提交后会立即公开。请勿填写邮箱、电话等个人信息。URL 最多 2 个。

0 / 1000 字

此表单受 reCAPTCHA 保护,适用 Google 的隐私权政策和服务条款。

同一仓库的技能

Automate 21risk operations through Rube MCP, a connection for agent tools. The skill discovers available actions, checks the service connection, and uses current input requirements to carry out requested tasks.

中文简介正在准备中。当前显示英语简介。

  • Find available 21risk actions
  • Run tasks after checking the service connection
  • Process multiple operations in bulk
composio-community/awesome-codex-skills1.7万2026年7月26日 更新

Automate supported 2chat tasks through Rube MCP and Composio. The skill finds available tools, checks the service connection, and uses current input requirements to carry out the requested operations.

中文简介正在准备中。当前显示英语简介。

  • Find tools for a 2chat task
  • Check the 2chat connection before running tasks
  • Run multiple supported operations together
composio-community/awesome-codex-skills1.7万2026年7月26日 更新

Automate Ably operations through Rube MCP and Composio. The skill discovers tools for your task, checks current input requirements, verifies an active connection, and guides execution of single operations or batches.

中文简介正在准备中。当前显示英语简介。

  • Discover available tools for an Ably task
  • Check the Ably connection before execution
  • Run multiple Ably operations together
composio-community/awesome-codex-skills1.7万2026年7月26日 更新

Automate Abstract tasks using Rube MCP, a connection for agent tools. The skill searches for available operations, confirms an active service connection, and runs actions according to their current input requirements.

中文简介正在准备中。当前显示英语简介。

  • Discovering supported Abstract operations
  • Executing Abstract tasks through an agent
  • Fetching all pages of a tool response
composio-community/awesome-codex-skills1.7万2026年7月26日 更新

Automate Abuselpdb operations through Rube MCP, a connection for agent tools. Discover available actions and their required inputs, verify the service connection, and execute tasks using the current tool definitions.

中文简介正在准备中。当前显示英语简介。

  • Finding available Abuselpdb actions
  • Checking the connection before running tasks
  • Automating repeated Abuselpdb operations
composio-community/awesome-codex-skills1.7万2026年7月26日 更新

Automate Abyssale operations through Rube MCP, a connection for agent tools. The skill discovers available actions and their current input requirements, checks the service connection, and executes the tools returned by the search.

中文简介正在准备中。当前显示英语简介。

  • Discovering available Abyssale operations
  • Checking the Abyssale connection before execution
  • Running Abyssale operations through an agent
composio-community/awesome-codex-skills1.7万2026年7月26日 更新

查看 composio-community 的全部技能

报告此技能的问题