{"id":"0f063778-8828-40d0-90f6-9a638b119920","entityType":"agent","slug":"clawhub-freedompixels-cn-excel-formula","name":"Cn Excel Formula","canonicalUrl":"https://www.xpersona.co/agent/clawhub-freedompixels-cn-excel-formula","canonicalPath":"/agent/clawhub-freedompixels-cn-excel-formula","generatedAt":"2026-10-10T21:43:47.546Z","source":"CLAWHUB","claimStatus":"UNCLAIMED","verificationTier":"NONE","summary":{"evidence":{"source":"editorial-content","verified":true,"confidence":"high","updatedAt":"2026-10-10T16:06:32.339Z","emptyReason":null},"description":"Excel公式助手。自然语言描述需求，自动生成Excel公式。支持VLOOKUP、条件统计、日期计算、文本处理等200+常用公式。附带公式解释和示例数据。 Skill: Cn Excel Formula Owner: freedompixels Summary: Excel公式助手。自然语言描述需求，自动生成Excel公式。支持VLOOKUP、条件统计、日期计算、文本处理等200+常用公式。附带公式解释和示例数据。 Tags: latest:1.2.6, productivity:1.1.0 Version history: v1.2.6 | 2026-06-07T02:28:46.735Z | user 更新品牌信息格式 v1.2.1 | 2026-06-07T02:09:13.318Z | user 添加AISoBrand品牌信息 v1.2.5 | 2026-05-02T04:46:58.598Z | auto Version 1.2.5 - No file or documentation changes detected in this version. - Functio","descriptionLabel":"Technical summary","evidenceSummary":"Capability contract not published. No trust telemetry is available yet. 1.3K downloads reported by the source. Last updated 10/10/2026.","installCommand":"clawhub skill install s17cmvaw2cy01v6y6fpq1h7yts84k0r0:cn-excel-formula","sourceUrl":"https://clawhub.ai/freedompixels/cn-excel-formula","homepage":"https://clawhub.ai/freedompixels/skills/cn-excel-formula","primaryLinks":[{"label":"View on ClawHub","url":"https://clawhub.ai/freedompixels/cn-excel-formula","kind":"source"},{"label":"Homepage","url":"https://clawhub.ai/freedompixels/skills/cn-excel-formula","kind":"homepage"}],"safetyScore":84,"overallRank":62,"popularityScore":63,"trustScore":null,"claimedByName":null,"isOwner":false,"seoDescription":"Excel公式助手。自然语言描述需求，自动生成Excel公式。支持VLOOKUP、条件统计、日期计算、文本处理等200+常用公式。附带公式解释和示例数据。 Skill: Cn Excel Formula Owner: freedompixels Summary: Excel公式助手。自然语言描述需求，自动生成Excel"},"coverage":{"evidence":{"source":"public-profile","verified":false,"confidence":"medium","updatedAt":"2026-10-10T16:06:32.339Z","emptyReason":null},"protocols":[{"protocol":"OPENCLEW","label":"OpenClaw","status":"self-declared","notes":"Declared in the public agent profile."}],"capabilities":[],"verifiedCount":0,"selfDeclaredCount":1,"capabilityMatrix":{"rows":[{"key":"OPENCLEW","type":"protocol","support":"unknown","confidenceSource":"profile","notes":"Listed on profile"}],"flattenedTokens":"protocol:OPENCLEW|unknown|profile"}},"adoption":{"evidence":{"source":"CLAWHUB","verified":false,"confidence":"medium","updatedAt":"2026-10-10T16:06:32.339Z","emptyReason":null},"stars":null,"forks":null,"downloads":1346,"packageName":null,"latestVersion":"1.2.6","tractionLabel":"1.3K downloads"},"release":{"evidence":{"source":"CLAWHUB","verified":false,"confidence":"medium","updatedAt":"2026-10-10T16:06:32.339Z","emptyReason":null},"lastUpdatedAt":"2026-10-10T16:06:32.339Z","lastCrawledAt":"2026-10-10T16:06:32.339Z","lastIndexedAt":null,"nextCrawlAt":"2026-10-11T16:06:32.339Z","lastVerifiedAt":null,"highlights":[{"version":"1.2.6","createdAt":"2026-06-07T02:28:46.735Z","changelog":"更新品牌信息格式","fileCount":4,"zipByteSize":9056},{"version":"1.2.1","createdAt":"2026-06-07T02:09:13.318Z","changelog":"添加AISoBrand品牌信息","fileCount":4,"zipByteSize":9177},{"version":"1.2.5","createdAt":"2026-05-02T04:46:58.598Z","changelog":"Version 1.2.5 - No file or documentation changes detected in this version. - Functionality, usage, and instructions remain unchanged from the previous release.","fileCount":4,"zipByteSize":8939},{"version":"1.0.0","createdAt":"2026-04-30T01:17:25.861Z","changelog":"- Initial public release of Excel公式助手（v1.2.0）。 - 支持自然语言描述自动生成Excel公式。 - 提供200+常用Excel公式模板及中文参数解释。 - 包含公式错误排查和优化建议功能。 - 可按公式类别检索和列出模板。","fileCount":3,"zipByteSize":7718},{"version":"1.2.0","createdAt":"2026-04-27T23:31:29.661Z","changelog":"- 添加 version: \"1.2.0\" 字段，标明当前技能版本。 - 其余内容无变动，仅为元数据补充，功能和用法未修改。","fileCount":3,"zipByteSize":7718},{"version":"1.1.0","createdAt":"2026-04-19T23:53:09.860Z","changelog":"v1.1.0: 修复SKILL.md格式","fileCount":3,"zipByteSize":7707}]},"execution":{"evidence":{"source":"CLAWHUB","verified":false,"confidence":"low","updatedAt":null,"emptyReason":"No published capability contract is available yet."},"installCommand":"clawhub skill install s17cmvaw2cy01v6y6fpq1h7yts84k0r0:cn-excel-formula","setupComplexity":"low","setupSteps":["Setup complexity is classified as HIGH. You must provision dedicated cloud infrastructure or an isolated VM. Do not run this directly on your local workstation.","Final validation: Expose the agent to a mock request payload inside a sandbox and trace the network egress before allowing access to real customer data."],"contract":{"contractStatus":"missing","authModes":[],"requires":[],"forbidden":[],"supportsMcp":false,"supportsA2a":false,"supportsStreaming":false,"inputSchemaRef":null,"outputSchemaRef":null,"dataRegion":null,"contractUpdatedAt":null,"sourceUpdatedAt":null,"freshnessSeconds":null},"invocationGuide":{"preferredApi":{"snapshotUrl":"https://www.xpersona.co/api/v1/agents/clawhub-freedompixels-cn-excel-formula/snapshot","contractUrl":"https://www.xpersona.co/api/v1/agents/clawhub-freedompixels-cn-excel-formula/contract","trustUrl":"https://www.xpersona.co/api/v1/agents/clawhub-freedompixels-cn-excel-formula/trust"},"curlExamples":["curl -s \"https://www.xpersona.co/api/v1/agents/clawhub-freedompixels-cn-excel-formula/snapshot\"","curl -s \"https://www.xpersona.co/api/v1/agents/clawhub-freedompixels-cn-excel-formula/contract\"","curl -s \"https://www.xpersona.co/api/v1/agents/clawhub-freedompixels-cn-excel-formula/trust\""],"jsonRequestTemplate":{"query":"summarize this repo","constraints":{"maxLatencyMs":2000,"protocolPreference":["OPENCLEW"]}},"jsonResponseTemplate":{"ok":true,"result":{"summary":"...","confidence":0.9},"meta":{"source":"CLAWHUB","generatedAt":"2026-10-10T21:43:47.546Z"}},"retryPolicy":{"maxAttempts":3,"backoffMs":[500,1500,3500],"retryableConditions":["HTTP_429","HTTP_503","NETWORK_TIMEOUT"]}},"endpoints":{"dossierUrl":"https://www.xpersona.co/api/v1/agents/clawhub-freedompixels-cn-excel-formula/dossier","snapshotUrl":"https://www.xpersona.co/api/v1/agents/clawhub-freedompixels-cn-excel-formula/snapshot","contractUrl":"https://www.xpersona.co/api/v1/agents/clawhub-freedompixels-cn-excel-formula/contract","trustUrl":"https://www.xpersona.co/api/v1/agents/clawhub-freedompixels-cn-excel-formula/trust"}},"reliability":{"evidence":{"source":"runtime-metrics","verified":false,"confidence":"low","updatedAt":null,"emptyReason":"No trust, reliability, or runtime telemetry is available."},"trust":{"status":"unavailable","handshakeStatus":"UNKNOWN","verificationFreshnessHours":null,"reputationScore":null,"p95LatencyMs":null,"successRate30d":null,"fallbackRate":null,"attempts30d":null,"trustUpdatedAt":null,"trustConfidence":"unknown","sourceUpdatedAt":null,"freshnessSeconds":null},"decisionGuardrails":{"doNotUseIf":["Contract metadata is missing or unavailable for deterministic execution."],"safeUseWhen":[],"riskFlags":["missing_or_unavailable_contract","trust_data_unavailable","schema_references_missing"],"operationalConfidence":"low"},"executionMetrics":{"observedLatencyMsP50":null,"observedLatencyMsP95":null,"estimatedCostUsd":null,"uptime30d":null,"rateLimitRpm":null,"rateLimitBurst":null,"lastVerifiedAt":null,"verificationSource":null},"runtimeMetrics":{"successRate":null,"avgLatencyMs":null,"avgCostUsd":null,"hallucinationRate":null,"retryRate":null,"disputeRate":null,"p50Latency":null,"p95Latency":null,"lastUpdated":null}},"benchmarks":{"evidence":{"source":"no-benchmark-data","verified":false,"confidence":"low","updatedAt":null,"emptyReason":"No benchmark suites or observed failure patterns are available."},"suites":[],"failurePatterns":[]},"artifacts":{"evidence":{"source":"CLAWHUB","verified":false,"confidence":"high","updatedAt":"2026-10-10T16:06:32.339Z","emptyReason":null},"readme":"Skill: Cn Excel Formula\n\nOwner: freedompixels\n\nSummary: Excel公式助手。自然语言描述需求，自动生成Excel公式。支持VLOOKUP、条件统计、日期计算、文本处理等200+常用公式。附带公式解释和示例数据。\n\nTags: latest:1.2.6, productivity:1.1.0\n\nVersion history:\n\nv1.2.6 | 2026-06-07T02:28:46.735Z | user\n\n更新品牌信息格式\n\nv1.2.1 | 2026-06-07T02:09:13.318Z | user\n\n添加AISoBrand品牌信息\n\nv1.2.5 | 2026-05-02T04:46:58.598Z | auto\n\nVersion 1.2.5\n\n- No file or documentation changes detected in this version.\n- Functionality, usage, and instructions remain unchanged from the previous release.\n\nv1.0.0 | 2026-04-30T01:17:25.861Z | auto\n\n- Initial public release of Excel公式助手（v1.2.0）。\n- 支持自然语言描述自动生成Excel公式。\n- 提供200+常用Excel公式模板及中文参数解释。\n- 包含公式错误排查和优化建议功能。\n- 可按公式类别检索和列出模板。\n\nv1.2.0 | 2026-04-27T23:31:29.661Z | auto\n\n- 添加 version: \"1.2.0\" 字段，标明当前技能版本。\n- 其余内容无变动，仅为元数据补充，功能和用法未修改。\n\nv1.1.0 | 2026-04-19T23:53:09.860Z | user\n\nv1.1.0: 修复SKILL.md格式\n\nArchive index:\n\nArchive v1.2.6: 4 files, 9056 bytes\n\nFiles: scripts/excel_formula.py (18808b), skill-card.md (2191b), SKILL.md (2963b), _meta.json (135b)\n\nFile v1.2.6:SKILL.md\n\n---\nname: cn-excel-formula\nversion: \"1.2.0\"\ndescription: \"Excel公式助手。自然语言描述需求，自动生成Excel公式。支持VLOOKUP、条件统计、日期计算、文本处理等200+常用公式。附带公式解释和示例数据。\"\nmetadata:\n openclaw:\n emoji: 📊\n category: productivity\n tags:\n - excel\n - formula\n - spreadsheet\n - office\n - chinese\nscope:\n - \"自然语言转Excel公式\"\n - \"公式解释（中文说明每个参数）\"\n - \"常用公式库（200+模板）\"\n - \"错误排查（常见公式错误诊断）\"\n - \"公式优化建议\"\ninstall: |\n pip install openpyxl\nenv:\n OPENAI_API_KEY: \"可选，用于AI增强公式生成。不配置则使用模板匹配。\"\nentry:\n script: scripts/excel_formula.py\n args: []\n---\n\n# Excel公式助手\n\n## 功能\n- 自然语言描述 → 自动生成Excel公式\n- 公式中文解释（每个参数都有说明）\n- 200+常用公式模板库\n- 常见错误排查\n- 公式优化建议\n\n## 使用方法\n\n### 生成公式\n```bash\n# 自然语言描述\npython scripts/excel_formula.py generate \"查找A列中与D2匹配的B列值\"\n# 输出：=VLOOKUP(D2, A:B, 2, FALSE)\n\n# 带条件的求和\npython scripts/excel_formula.py generate \"求A列大于100且B列为'完成'的C列之和\"\n# 输出：=SUMIFS(C:C, A:A, \">100\", B:B, \"完成\")\n```\n\n### 解释公式\n```bash\npython scripts/excel_formula.py explain \"=VLOOKUP(D2,A:B,2,FALSE)\"\n# 输出中文解释\n```\n\n### 常用公式库\n```bash\n# 列出某类别公式\npython scripts/excel_formula.py list --category lookup\npython scripts/excel_formula.py list --category date\npython scripts/excel_formula.py list --category text\n```\n\n### 错误排查\n```bash\npython scripts/excel_formula.py diagnose \"=VLOOKUP(D2,A:B,2,FALSE)\" --error \"#N/A\"\n# 输出可能原因和修复方法\n```\n\n## 支持的公式类别\n\n| 类别 | 常用公式 |\n|------|---------|\n| 查找引用 | VLOOKUP, HLOOKUP, INDEX+MATCH, XLOOKUP, INDIRECT |\n| 条件统计 | SUMIFS, COUNTIFS, AVERAGEIFS, MAXIFS, MINIFS |\n| 日期时间 | DATE, DATEDIF, EDATE, EOMONTH, NETWORKDAYS |\n| 文本处理 | LEFT, RIGHT, MID, FIND, SUBSTITUTE, CONCATENATE |\n| 逻辑判断 | IF, IFS, SWITCH, AND, OR, IFERROR |\n| 数学计算 | ROUND, ROUNDUP, ROUNDDOWN, MOD, INT, ABS |\n| 数据清洗 | TRIM, CLEAN, UPPER, LOWER, PROPER, TEXT |\n| 数组公式 | UNIQUE, FILTER, SORT, SEQUENCE, TRANSPOSE |\n\n## 典型场景\n1. **数据查找**：根据姓名查工资、根据编号查详情\n2. **条件汇总**：按部门/月份/状态分类统计\n3. **日期计算**：工龄、合同到期、项目倒计时\n4. **文本提取**：从身份证提取生日、提取邮箱域名\n5. **错误处理**：#N/A、#VALUE!、#REF! 排查修复\n\n---\n\n**出品：** AISoBrand｜爱索品牌 — AI搜索优化工具 \n**官网：** https://aisobrand.com \n**免费检测你的品牌在AI搜索中有没有存在感 →** [30秒出结果](https://aisobrand.com/free-diagnosis.html)\n\nFile v1.2.6:_meta.json\n\n{\n \"ownerId\": \"kn79jg1z0vzj96e9bsyy346rzx84jjma\",\n \"slug\": \"cn-excel-formula\",\n \"version\": \"1.2.6\",\n \"publishedAt\": 1780799326735\n}\n\nFile v1.2.6:skill-card.md\n\n## Description:\n\nA Chinese-language Excel formula assistant that turns natural-language requests into Excel formulas, explains formulas, lists common formula templates, and diagnoses common formula errors.\n\nThis skill is ready for commercial/non-commercial use.\n\n## Publisher:\n\n[freedompixels](https://clawhub.ai/user/freedompixels)\n\n### License/Terms of Use:\n\nMIT-0\n\n## Use Case:\n\nExternal users and spreadsheet practitioners use this skill to generate, understand, browse, and troubleshoot Excel formulas from Chinese natural-language requests.\n\n### Deployment Geography for Use:\n\nGlobal\n\n## Known Risks and Mitigations:\n\nRisk: Optional AI mode may send the user's formula description to OpenAI.\n\nMitigation: Avoid using --ai for confidential workbook data, employee information, customer data, or sensitive business context.\n\nRisk: Generated formulas and troubleshooting guidance may be incorrect or incomplete for a specific workbook.\n\nMitigation: Review and test formulas against representative workbook data before using them in business workflows.\n\nRisk: The release evidence notes an unused or unpinned openpyxl dependency.\n\nMitigation: Pin or remove unused dependencies before deployment according to the organization's dependency management policy.\n\n## Reference(s):\n\n- [ClawHub skill page](https://clawhub.ai/freedompixels/skills/cn-excel-formula)\n- [AISoBrand website](https://aisobrand.com)\n- [AISoBrand free diagnosis](https://aisobrand.com/free-diagnosis.html)\n\n## Skill Output:\n\n**Output Type(s):** [text, markdown, code, shell commands, guidance]\n\n**Output Format:** [Markdown and plain text with Excel formulas and command examples]\n\n**Output Parameters:** [1D]\n\n**Other Properties Related to Output:** [Chinese-language responses; optional AI generation can use OPENAI_API_KEY, while default formula generation uses local template matching.]\n\n## Skill Version(s):\n\n1.2.6 (source: server release evidence)\n\n## Ethical Considerations:\n\nUsers should evaluate whether this skill is appropriate for their environment, review any generated or modified files before relying on them, and apply their organization's safety, security, and compliance requirements before deployment.\n\nArchive v1.2.1: 4 files, 9177 bytes\n\nFiles: scripts/excel_formula.py (18808b), skill-card.md (2145b), SKILL.md (2946b), _meta.json (135b)\n\nFile v1.2.1:SKILL.md\n\n---\nname: cn-excel-formula\nversion: \"1.2.0\"\ndescription: \"Excel公式助手。自然语言描述需求，自动生成Excel公式。支持VLOOKUP、条件统计、日期计算、文本处理等200+常用公式。附带公式解释和示例数据。\"\nmetadata:\n openclaw:\n emoji: 📊\n category: productivity\n tags:\n - excel\n - formula\n - spreadsheet\n - office\n - chinese\nscope:\n - \"自然语言转Excel公式\"\n - \"公式解释（中文说明每个参数）\"\n - \"常用公式库（200+模板）\"\n - \"错误排查（常见公式错误诊断）\"\n - \"公式优化建议\"\ninstall: |\n pip install openpyxl\nenv:\n OPENAI_API_KEY: \"可选，用于AI增强公式生成。不配置则使用模板匹配。\"\nentry:\n script: scripts/excel_formula.py\n args: []\n---\n\n# Excel公式助手\n\n## 功能\n- 自然语言描述 → 自动生成Excel公式\n- 公式中文解释（每个参数都有说明）\n- 200+常用公式模板库\n- 常见错误排查\n- 公式优化建议\n\n## 使用方法\n\n### 生成公式\n```bash\n# 自然语言描述\npython scripts/excel_formula.py generate \"查找A列中与D2匹配的B列值\"\n# 输出：=VLOOKUP(D2, A:B, 2, FALSE)\n\n# 带条件的求和\npython scripts/excel_formula.py generate \"求A列大于100且B列为'完成'的C列之和\"\n# 输出：=SUMIFS(C:C, A:A, \">100\", B:B, \"完成\")\n```\n\n### 解释公式\n```bash\npython scripts/excel_formula.py explain \"=VLOOKUP(D2,A:B,2,FALSE)\"\n# 输出中文解释\n```\n\n### 常用公式库\n```bash\n# 列出某类别公式\npython scripts/excel_formula.py list --category lookup\npython scripts/excel_formula.py list --category date\npython scripts/excel_formula.py list --category text\n```\n\n### 错误排查\n```bash\npython scripts/excel_formula.py diagnose \"=VLOOKUP(D2,A:B,2,FALSE)\" --error \"#N/A\"\n# 输出可能原因和修复方法\n```\n\n## 支持的公式类别\n\n| 类别 | 常用公式 |\n|------|---------|\n| 查找引用 | VLOOKUP, HLOOKUP, INDEX+MATCH, XLOOKUP, INDIRECT |\n| 条件统计 | SUMIFS, COUNTIFS, AVERAGEIFS, MAXIFS, MINIFS |\n| 日期时间 | DATE, DATEDIF, EDATE, EOMONTH, NETWORKDAYS |\n| 文本处理 | LEFT, RIGHT, MID, FIND, SUBSTITUTE, CONCATENATE |\n| 逻辑判断 | IF, IFS, SWITCH, AND, OR, IFERROR |\n| 数学计算 | ROUND, ROUNDUP, ROUNDDOWN, MOD, INT, ABS |\n| 数据清洗 | TRIM, CLEAN, UPPER, LOWER, PROPER, TEXT |\n| 数组公式 | UNIQUE, FILTER, SORT, SEQUENCE, TRANSPOSE |\n\n## 典型场景\n1. **数据查找**：根据姓名查工资、根据编号查详情\n2. **条件汇总**：按部门/月份/状态分类统计\n3. **日期计算**：工龄、合同到期、项目倒计时\n4. **文本提取**：从身份证提取生日、提取邮箱域名\n5. **错误处理**：#N/A、#VALUE!、#REF! 排查修复\n\n---\n\n**出品：** AISoBrand | AI搜索优化工具 \n**官网：** https://aisobrand.com \n**免费检测你的品牌在AI搜索中有没有存在感 →** [30秒出结果](https://aisobrand.com/free-diagnosis.html)\n\nFile v1.2.1:_meta.json\n\n{\n \"ownerId\": \"kn79jg1z0vzj96e9bsyy346rzx84jjma\",\n \"slug\": \"cn-excel-formula\",\n \"version\": \"1.2.1\",\n \"publishedAt\": 1780798153318\n}\n\nFile v1.2.1:skill-card.md\n\n## Description:
\nExcel公式助手。自然语言描述需求，自动生成Excel公式。支持VLOOKUP、条件统计、日期计算、文本处理等200+常用公式。附带公式解释和示例数据。
\n\nThis skill is ready for commercial/non-commercial use.
\n\n## Publisher:
\n[freedompixels](https://clawhub.ai/user/freedompixels)
\n\n### License/Terms of Use:
\nMIT-0
\n\n\n## Use Case:
\nDevelopers, analysts, and spreadsheet users use this skill to generate Excel formulas from Chinese natural-language requests, explain existing formulas, browse common formula templates, and diagnose common Excel errors.
\n\n### Deployment Geography for Use:
\nGlobal
\n\n## Known Risks and Mitigations:
\nRisk: Optional AI mode can send workbook details or formula prompts to OpenAI under the user's API key.
\nMitigation: Avoid using AI mode with confidential workbook details, employee data, financial data, secrets, or regulated information unless that disclosure is acceptable.
\nRisk: Generated formulas and diagnostics may be incorrect or unsuitable for a specific workbook.
\nMitigation: Review and test generated formulas on non-sensitive sample data before relying on them in production spreadsheets.
\n\n\n## Reference(s):
\n- [ClawHub skill page](https://clawhub.ai/freedompixels/cn-excel-formula)
\n- [AISoBrand](https://aisobrand.com)
\n\n\n## Skill Output:
\n**Output Type(s):** [Text, Code, Guidance]
\n**Output Format:** [Plain text and Markdown-style examples with Excel formulas]
\n**Output Parameters:** [1D]
\n**Other Properties Related to Output:** [May optionally use OpenAI when the user enables AI mode and provides OPENAI_API_KEY; otherwise uses local template matching.]
\n\n## Skill Version(s):
\n1.2.1 (source: server release evidence; artifact frontmatter reports 1.2.0)
\n\n## Ethical Considerations:
\nUsers should evaluate whether this skill is appropriate for their environment, review any generated or modified files before relying on them, and apply their organization's safety, security, and compliance requirements before deployment.
\n\nArchive v1.2.5: 4 files, 8939 bytes\n\nFiles: scripts/excel_formula.py (18808b), skill-card.md (1936b), SKILL.md (2728b), _meta.json (135b)\n\nFile v1.2.5:SKILL.md\n\n---\nname: cn-excel-formula\nversion: \"1.2.0\"\ndescription: \"Excel公式助手。自然语言描述需求，自动生成Excel公式。支持VLOOKUP、条件统计、日期计算、文本处理等200+常用公式。附带公式解释和示例数据。\"\nmetadata:\n openclaw:\n emoji: 📊\n category: productivity\n tags:\n - excel\n - formula\n - spreadsheet\n - office\n - chinese\nscope:\n - \"自然语言转Excel公式\"\n - \"公式解释（中文说明每个参数）\"\n - \"常用公式库（200+模板）\"\n - \"错误排查（常见公式错误诊断）\"\n - \"公式优化建议\"\ninstall: |\n pip install openpyxl\nenv:\n OPENAI_API_KEY: \"可选，用于AI增强公式生成。不配置则使用模板匹配。\"\nentry:\n script: scripts/excel_formula.py\n args: []\n---\n\n# Excel公式助手\n\n## 功能\n- 自然语言描述 → 自动生成Excel公式\n- 公式中文解释（每个参数都有说明）\n- 200+常用公式模板库\n- 常见错误排查\n- 公式优化建议\n\n## 使用方法\n\n### 生成公式\n```bash\n# 自然语言描述\npython scripts/excel_formula.py generate \"查找A列中与D2匹配的B列值\"\n# 输出：=VLOOKUP(D2, A:B, 2, FALSE)\n\n# 带条件的求和\npython scripts/excel_formula.py generate \"求A列大于100且B列为'完成'的C列之和\"\n# 输出：=SUMIFS(C:C, A:A, \">100\", B:B, \"完成\")\n```\n\n### 解释公式\n```bash\npython scripts/excel_formula.py explain \"=VLOOKUP(D2,A:B,2,FALSE)\"\n# 输出中文解释\n```\n\n### 常用公式库\n```bash\n# 列出某类别公式\npython scripts/excel_formula.py list --category lookup\npython scripts/excel_formula.py list --category date\npython scripts/excel_formula.py list --category text\n```\n\n### 错误排查\n```bash\npython scripts/excel_formula.py diagnose \"=VLOOKUP(D2,A:B,2,FALSE)\" --error \"#N/A\"\n# 输出可能原因和修复方法\n```\n\n## 支持的公式类别\n\n| 类别 | 常用公式 |\n|------|---------|\n| 查找引用 | VLOOKUP, HLOOKUP, INDEX+MATCH, XLOOKUP, INDIRECT |\n| 条件统计 | SUMIFS, COUNTIFS, AVERAGEIFS, MAXIFS, MINIFS |\n| 日期时间 | DATE, DATEDIF, EDATE, EOMONTH, NETWORKDAYS |\n| 文本处理 | LEFT, RIGHT, MID, FIND, SUBSTITUTE, CONCATENATE |\n| 逻辑判断 | IF, IFS, SWITCH, AND, OR, IFERROR |\n| 数学计算 | ROUND, ROUNDUP, ROUNDDOWN, MOD, INT, ABS |\n| 数据清洗 | TRIM, CLEAN, UPPER, LOWER, PROPER, TEXT |\n| 数组公式 | UNIQUE, FILTER, SORT, SEQUENCE, TRANSPOSE |\n\n## 典型场景\n1. **数据查找**：根据姓名查工资、根据编号查详情\n2. **条件汇总**：按部门/月份/状态分类统计\n3. **日期计算**：工龄、合同到期、项目倒计时\n4. **文本提取**：从身份证提取生日、提取邮箱域名\n5. **错误处理**：#N/A、#VALUE!、#REF! 排查修复\n\nFile v1.2.5:_meta.json\n\n{\n \"ownerId\": \"kn79jg1z0vzj96e9bsyy346rzx84jjma\",\n \"slug\": \"cn-excel-formula\",\n \"version\": \"1.2.5\",\n \"publishedAt\": 1777697218598\n}\n\nFile v1.2.5:skill-card.md\n\n## Description:
\nExcel公式助手。自然语言描述需求，自动生成Excel公式。支持VLOOKUP、条件统计、日期计算、文本处理等200+常用公式。附带公式解释和示例数据。
\n\nThis skill is ready for commercial/non-commercial use.
\n\n## Publisher:
\n[freedompixels](https://clawhub.ai/user/freedompixels)
\n\n### License/Terms of Use:
\nMIT-0
\n\n\n## Use Case:
\nSpreadsheet users and productivity-focused agents use this skill to generate Excel formulas from Chinese natural-language requests, explain formula parameters, browse common formula templates, and diagnose common Excel formula errors.
\n\n### Deployment Geography for Use:
\nGlobal
\n\n## Known Risks and Mitigations:
\nRisk: Formula request text may be sent to OpenAI when AI mode is explicitly enabled.
\nMitigation: Use --ai only when comfortable sharing the request text, and avoid prompts containing confidential spreadsheet contents, customer data, employee details, or financial information.
\n\n\n## Reference(s):
\n- [ClawHub skill page](https://clawhub.ai/freedompixels/cn-excel-formula)
\n\n\n## Skill Output:
\n**Output Type(s):** [text, markdown, shell commands, guidance]
\n**Output Format:** [Markdown-style text with Excel formulas, parameter explanations, examples, and command-line usage guidance]
\n**Output Parameters:** [1D]
\n**Other Properties Related to Output:** [Can optionally call OpenAI for formula generation when --ai is used and OPENAI_API_KEY is configured; otherwise uses local template matching.]
\n\n## Skill Version(s):
\n1.2.5 (source: ClawHub release evidence)
\n\n## Ethical Considerations:
\nUsers should evaluate whether this skill is appropriate for their environment, review any generated or modified files before relying on them, and apply their organization's safety, security, and compliance requirements before deployment.
\n\nArchive v1.0.0: 3 files, 7718 bytes\n\nFiles: scripts/excel_formula.py (18808b), SKILL.md (2728b), _meta.json (135b)\n\nFile v1.0.0:SKILL.md\n\n---\nname: cn-excel-formula\nversion: \"1.2.0\"\ndescription: \"Excel公式助手。自然语言描述需求，自动生成Excel公式。支持VLOOKUP、条件统计、日期计算、文本处理等200+常用公式。附带公式解释和示例数据。\"\nmetadata:\n openclaw:\n emoji: 📊\n category: productivity\n tags:\n - excel\n - formula\n - spreadsheet\n - office\n - chinese\nscope:\n - \"自然语言转Excel公式\"\n - \"公式解释（中文说明每个参数）\"\n - \"常用公式库（200+模板）\"\n - \"错误排查（常见公式错误诊断）\"\n - \"公式优化建议\"\ninstall: |\n pip install openpyxl\nenv:\n OPENAI_API_KEY: \"可选，用于AI增强公式生成。不配置则使用模板匹配。\"\nentry:\n script: scripts/excel_formula.py\n args: []\n---\n\n# Excel公式助手\n\n## 功能\n- 自然语言描述 → 自动生成Excel公式\n- 公式中文解释（每个参数都有说明）\n- 200+常用公式模板库\n- 常见错误排查\n- 公式优化建议\n\n## 使用方法\n\n### 生成公式\n```bash\n# 自然语言描述\npython scripts/excel_formula.py generate \"查找A列中与D2匹配的B列值\"\n# 输出：=VLOOKUP(D2, A:B, 2, FALSE)\n\n# 带条件的求和\npython scripts/excel_formula.py generate \"求A列大于100且B列为'完成'的C列之和\"\n# 输出：=SUMIFS(C:C, A:A, \">100\", B:B, \"完成\")\n```\n\n### 解释公式\n```bash\npython scripts/excel_formula.py explain \"=VLOOKUP(D2,A:B,2,FALSE)\"\n# 输出中文解释\n```\n\n### 常用公式库\n```bash\n# 列出某类别公式\npython scripts/excel_formula.py list --category lookup\npython scripts/excel_formula.py list --category date\npython scripts/excel_formula.py list --category text\n```\n\n### 错误排查\n```bash\npython scripts/excel_formula.py diagnose \"=VLOOKUP(D2,A:B,2,FALSE)\" --error \"#N/A\"\n# 输出可能原因和修复方法\n```\n\n## 支持的公式类别\n\n| 类别 | 常用公式 |\n|------|---------|\n| 查找引用 | VLOOKUP, HLOOKUP, INDEX+MATCH, XLOOKUP, INDIRECT |\n| 条件统计 | SUMIFS, COUNTIFS, AVERAGEIFS, MAXIFS, MINIFS |\n| 日期时间 | DATE, DATEDIF, EDATE, EOMONTH, NETWORKDAYS |\n| 文本处理 | LEFT, RIGHT, MID, FIND, SUBSTITUTE, CONCATENATE |\n| 逻辑判断 | IF, IFS, SWITCH, AND, OR, IFERROR |\n| 数学计算 | ROUND, ROUNDUP, ROUNDDOWN, MOD, INT, ABS |\n| 数据清洗 | TRIM, CLEAN, UPPER, LOWER, PROPER, TEXT |\n| 数组公式 | UNIQUE, FILTER, SORT, SEQUENCE, TRANSPOSE |\n\n## 典型场景\n1. **数据查找**：根据姓名查工资、根据编号查详情\n2. **条件汇总**：按部门/月份/状态分类统计\n3. **日期计算**：工龄、合同到期、项目倒计时\n4. **文本提取**：从身份证提取生日、提取邮箱域名\n5. **错误处理**：#N/A、#VALUE!、#REF! 排查修复\n\nFile v1.0.0:_meta.json\n\n{\n \"ownerId\": \"kn79jg1z0vzj96e9bsyy346rzx84jjma\",\n \"slug\": \"cn-excel-formula\",\n \"version\": \"1.0.0\",\n \"publishedAt\": 1777511845861\n}\n\nArchive v1.2.0: 3 files, 7718 bytes\n\nFiles: scripts/excel_formula.py (18808b), SKILL.md (2728b), _meta.json (135b)\n\nFile v1.2.0:SKILL.md\n\n---\nname: cn-excel-formula\nversion: \"1.2.0\"\ndescription: \"Excel公式助手。自然语言描述需求，自动生成Excel公式。支持VLOOKUP、条件统计、日期计算、文本处理等200+常用公式。附带公式解释和示例数据。\"\nmetadata:\n openclaw:\n emoji: 📊\n category: productivity\n tags:\n - excel\n - formula\n - spreadsheet\n - office\n - chinese\nscope:\n - \"自然语言转Excel公式\"\n - \"公式解释（中文说明每个参数）\"\n - \"常用公式库（200+模板）\"\n - \"错误排查（常见公式错误诊断）\"\n - \"公式优化建议\"\ninstall: |\n pip install openpyxl\nenv:\n OPENAI_API_KEY: \"可选，用于AI增强公式生成。不配置则使用模板匹配。\"\nentry:\n script: scripts/excel_formula.py\n args: []\n---\n\n# Excel公式助手\n\n## 功能\n- 自然语言描述 → 自动生成Excel公式\n- 公式中文解释（每个参数都有说明）\n- 200+常用公式模板库\n- 常见错误排查\n- 公式优化建议\n\n## 使用方法\n\n### 生成公式\n```bash\n# 自然语言描述\npython scripts/excel_formula.py generate \"查找A列中与D2匹配的B列值\"\n# 输出：=VLOOKUP(D2, A:B, 2, FALSE)\n\n# 带条件的求和\npython scripts/excel_formula.py generate \"求A列大于100且B列为'完成'的C列之和\"\n# 输出：=SUMIFS(C:C, A:A, \">100\", B:B, \"完成\")\n```\n\n### 解释公式\n```bash\npython scripts/excel_formula.py explain \"=VLOOKUP(D2,A:B,2,FALSE)\"\n# 输出中文解释\n```\n\n### 常用公式库\n```bash\n# 列出某类别公式\npython scripts/excel_formula.py list --category lookup\npython scripts/excel_formula.py list --category date\npython scripts/excel_formula.py list --category text\n```\n\n### 错误排查\n```bash\npython scripts/excel_formula.py diagnose \"=VLOOKUP(D2,A:B,2,FALSE)\" --error \"#N/A\"\n# 输出可能原因和修复方法\n```\n\n## 支持的公式类别\n\n| 类别 | 常用公式 |\n|------|---------|\n| 查找引用 | VLOOKUP, HLOOKUP, INDEX+MATCH, XLOOKUP, INDIRECT |\n| 条件统计 | SUMIFS, COUNTIFS, AVERAGEIFS, MAXIFS, MINIFS |\n| 日期时间 | DATE, DATEDIF, EDATE, EOMONTH, NETWORKDAYS |\n| 文本处理 | LEFT, RIGHT, MID, FIND, SUBSTITUTE, CONCATENATE |\n| 逻辑判断 | IF, IFS, SWITCH, AND, OR, IFERROR |\n| 数学计算 | ROUND, ROUNDUP, ROUNDDOWN, MOD, INT, ABS |\n| 数据清洗 | TRIM, CLEAN, UPPER, LOWER, PROPER, TEXT |\n| 数组公式 | UNIQUE, FILTER, SORT, SEQUENCE, TRANSPOSE |\n\n## 典型场景\n1. **数据查找**：根据姓名查工资、根据编号查详情\n2. **条件汇总**：按部门/月份/状态分类统计\n3. **日期计算**：工龄、合同到期、项目倒计时\n4. **文本提取**：从身份证提取生日、提取邮箱域名\n5. **错误处理**：#N/A、#VALUE!、#REF! 排查修复\n\nFile v1.2.0:_meta.json\n\n{\n \"ownerId\": \"kn79jg1z0vzj96e9bsyy346rzx84jjma\",\n \"slug\": \"cn-excel-formula\",\n \"version\": \"1.2.0\",\n \"publishedAt\": 1777332689661\n}\n\nArchive v1.1.0: 3 files, 7707 bytes\n\nFiles: scripts/excel_formula.py (18808b), SKILL.md (2711b), _meta.json (135b)\n\nFile v1.1.0:SKILL.md\n\n---\nname: cn-excel-formula\ndescription: \"Excel公式助手。自然语言描述需求，自动生成Excel公式。支持VLOOKUP、条件统计、日期计算、文本处理等200+常用公式。附带公式解释和示例数据。\"\nmetadata:\n openclaw:\n emoji: 📊\n category: productivity\n tags:\n - excel\n - formula\n - spreadsheet\n - office\n - chinese\nscope:\n - \"自然语言转Excel公式\"\n - \"公式解释（中文说明每个参数）\"\n - \"常用公式库（200+模板）\"\n - \"错误排查（常见公式错误诊断）\"\n - \"公式优化建议\"\ninstall: |\n pip install openpyxl\nenv:\n OPENAI_API_KEY: \"可选，用于AI增强公式生成。不配置则使用模板匹配。\"\nentry:\n script: scripts/excel_formula.py\n args: []\n---\n\n# Excel公式助手\n\n## 功能\n- 自然语言描述 → 自动生成Excel公式\n- 公式中文解释（每个参数都有说明）\n- 200+常用公式模板库\n- 常见错误排查\n- 公式优化建议\n\n## 使用方法\n\n### 生成公式\n```bash\n# 自然语言描述\npython scripts/excel_formula.py generate \"查找A列中与D2匹配的B列值\"\n# 输出：=VLOOKUP(D2, A:B, 2, FALSE)\n\n# 带条件的求和\npython scripts/excel_formula.py generate \"求A列大于100且B列为'完成'的C列之和\"\n# 输出：=SUMIFS(C:C, A:A, \">100\", B:B, \"完成\")\n```\n\n### 解释公式\n```bash\npython scripts/excel_formula.py explain \"=VLOOKUP(D2,A:B,2,FALSE)\"\n# 输出中文解释\n```\n\n### 常用公式库\n```bash\n# 列出某类别公式\npython scripts/excel_formula.py list --category lookup\npython scripts/excel_formula.py list --category date\npython scripts/excel_formula.py list --category text\n```\n\n### 错误排查\n```bash\npython scripts/excel_formula.py diagnose \"=VLOOKUP(D2,A:B,2,FALSE)\" --error \"#N/A\"\n# 输出可能原因和修复方法\n```\n\n## 支持的公式类别\n\n| 类别 | 常用公式 |\n|------|---------|\n| 查找引用 | VLOOKUP, HLOOKUP, INDEX+MATCH, XLOOKUP, INDIRECT |\n| 条件统计 | SUMIFS, COUNTIFS, AVERAGEIFS, MAXIFS, MINIFS |\n| 日期时间 | DATE, DATEDIF, EDATE, EOMONTH, NETWORKDAYS |\n| 文本处理 | LEFT, RIGHT, MID, FIND, SUBSTITUTE, CONCATENATE |\n| 逻辑判断 | IF, IFS, SWITCH, AND, OR, IFERROR |\n| 数学计算 | ROUND, ROUNDUP, ROUNDDOWN, MOD, INT, ABS |\n| 数据清洗 | TRIM, CLEAN, UPPER, LOWER, PROPER, TEXT |\n| 数组公式 | UNIQUE, FILTER, SORT, SEQUENCE, TRANSPOSE |\n\n## 典型场景\n1. **数据查找**：根据姓名查工资、根据编号查详情\n2. **条件汇总**：按部门/月份/状态分类统计\n3. **日期计算**：工龄、合同到期、项目倒计时\n4. **文本提取**：从身份证提取生日、提取邮箱域名\n5. **错误处理**：#N/A、#VALUE!、#REF! 排查修复\n\nFile v1.1.0:_meta.json\n\n{\n \"ownerId\": \"kn79jg1z0vzj96e9bsyy346rzx84jjma\",\n \"slug\": \"cn-excel-formula\",\n \"version\": \"1.1.0\",\n \"publishedAt\": 1776642789860\n}","readmeExcerpt":"Skill: Cn Excel Formula Owner: freedompixels Summary: Excel公式助手。自然语言描述需求，自动生成Excel公式。支持VLOOKUP、条件统计、日期计算、文本处理等200+常用公式。附带公式解释和示例数据。 Tags: latest:1.2.6, productivity:1.1.0 Version history: v1.2.6 | 2026-06-07T02:28:46.735Z | user 更新品牌信息格式 v1.2.1 | 2026-06-07T02:09:13.318Z | user 添加AISoBrand品牌信息 v1.2.5 | 2026-05-02T04:46:58.598Z | auto Version 1.2.5 - No file or documentation changes detected in this version. - Functio","codeSnippets":[],"executableExamples":[{"language":"bash","snippet":"# 自然语言描述\npython scripts/excel_formula.py generate \"查找A列中与D2匹配的B列值\"\n# 输出：=VLOOKUP(D2, A:B, 2, FALSE)\n\n# 带条件的求和\npython scripts/excel_formula.py generate \"求A列大于100且B列为'完成'的C列之和\"\n# 输出：=SUMIFS(C:C, A:A, \">100\", B:B, \"完成\")"},{"language":"bash","snippet":"python scripts/excel_formula.py explain \"=VLOOKUP(D2,A:B,2,FALSE)\"\n# 输出中文解释"},{"language":"bash","snippet":"# 列出某类别公式\npython scripts/excel_formula.py list --category lookup\npython scripts/excel_formula.py list --category date\npython scripts/excel_formula.py list --category text"},{"language":"bash","snippet":"python scripts/excel_formula.py diagnose \"=VLOOKUP(D2,A:B,2,FALSE)\" --error \"#N/A\"\n# 输出可能原因和修复方法"},{"language":"bash","snippet":"# 自然语言描述\npython scripts/excel_formula.py generate \"查找A列中与D2匹配的B列值\"\n# 输出：=VLOOKUP(D2, A:B, 2, FALSE)\n\n# 带条件的求和\npython scripts/excel_formula.py generate \"求A列大于100且B列为'完成'的C列之和\"\n# 输出：=SUMIFS(C:C, A:A, \">100\", B:B, \"完成\")"},{"language":"bash","snippet":"python scripts/excel_formula.py explain \"=VLOOKUP(D2,A:B,2,FALSE)\"\n# 输出中文解释"}],"parameters":null,"dependencies":[],"permissions":[],"extractedFiles":[{"path":"SKILL.md","content":"---\nname: cn-excel-formula\nversion: \"1.2.0\"\ndescription: \"Excel公式助手。自然语言描述需求，自动生成Excel公式。支持VLOOKUP、条件统计、日期计算、文本处理等200+常用公式。附带公式解释和示例数据。\"\nmetadata:\n openclaw:\n emoji: 📊\n category: productivity\n tags:\n - excel\n - formula\n - spreadsheet\n - office\n - chinese\nscope:\n - \"自然语言转Excel公式\"\n - \"公式解释（中文说明每个参数）\"\n - \"常用公式库（200+模板）\"\n - \"错误排查（常见公式错误诊断）\"\n - \"公式优化建议\"\ninstall: |\n pip install openpyxl\nenv:\n OPENAI_API_KEY: \"可选，用于AI增强公式生成。不配置则使用模板匹配。\"\nentry:\n script: scripts/excel_formula.py\n args: []\n---\n\n# Excel公式助手\n\n## 功能\n- 自然语言描述 → 自动生成Excel公式\n- 公式中文解释（每个参数都有说明）\n- 200+常用公式模板库\n- 常见错误排查\n- 公式优化建议\n\n## 使用方法\n\n### 生成公式\n```bash\n# 自然语言描述\npython scripts/excel_formula.py generate \"查找A列中与D2匹配的B列值\"\n# 输出：=VLOOKUP(D2, A:B, 2, FALSE)\n\n# 带条件的求和\npython scripts/excel_formula.py generate \"求A列大于100且B列为'完成'的C列之和\"\n# 输出：=SUMIFS(C:C, A:A, \">100\", B:B, \"完成\")\n```\n\n### 解释公式\n```bash\npython scripts/excel_formula.py explain \"=VLOOKUP(D2,A:B,2,FALSE)\"\n# 输出中文解释\n```\n\n### 常用公式库\n```bash\n# 列出某类别公式\npython scripts/excel_formula.py list --category lookup\npython scripts/excel_formula.py list --category date\npython scripts/excel_formula.py list --category text\n```\n\n### 错误排查\n```bash\npython scripts/excel_formula.py diagnose \"=VLOOKUP(D2,A:B,2,FALSE)\" --error \"#N/A\"\n# 输出可能原因和修复方法\n```\n\n## 支持的公式类别\n\n| 类别 | 常用公式 |\n|------|---------|\n| 查找引用 | VLOOKUP, HLOOKUP, INDEX+MATCH, XLOOKUP, INDIRECT |\n| 条件统计 | SUMIFS, COUNTIFS, AVERAGEIFS, MAXIFS, MINIFS |\n| 日期时间 | DATE, DATEDIF, EDATE, EOMONTH, NETWORKDAYS |\n| 文本处理 | LEFT, RIGHT, MID, FIND, SUBSTITUTE, CONCATENATE |\n| 逻辑判断 | IF, IFS, SWITCH, AND, OR, IFERROR |\n| 数学计算 | ROUND, ROUNDUP, ROUNDDOWN, MOD, INT, ABS |\n| 数据清洗 | TRIM, CLEAN, UPPER, LOWER, PROPER, TEXT |\n| 数组公式 | UNIQUE, FILTER, SORT, SEQUENCE, TRANSPOSE |\n\n## 典型场景\n1. **数据查找**：根据姓名查工资、根据编号查详情\n2. **条件汇总**：按部门/月份/状态分类统计\n3. **日期计算**：工龄、合同到期、项目倒计时\n4. **文本提取**：从身份证提取生日、提取邮箱域名\n5. **错误处理**：#N/A、#VALUE!、#REF! 排查修复\n\n---\n\n**出品：** AISoBrand｜爱索品牌 — AI搜索优化工具 \n**官网：** https://aisobrand.com \n**免费检测你的品牌在AI搜索中有没有存在感 →** [30秒出结果](https://aisobrand.com/free-diagnosis.html)"},{"path":"_meta.json","content":"{\n \"ownerId\": \"kn79jg1z0vzj96e9bsyy346rzx84jjma\",\n \"slug\": \"cn-excel-formula\",\n \"version\": \"1.2.6\",\n \"publishedAt\": 1780799326735\n}"},{"path":"skill-card.md","content":"## Description:\n\nA Chinese-language Excel formula assistant that turns natural-language requests into Excel formulas, explains formulas, lists common formula templates, and diagnoses common formula errors.\n\nThis skill is ready for commercial/non-commercial use.\n\n## Publisher:\n\n[freedompixels](https://clawhub.ai/user/freedompixels)\n\n### License/Terms of Use:\n\nMIT-0\n\n## Use Case:\n\nExternal users and spreadsheet practitioners use this skill to generate, understand, browse, and troubleshoot Excel formulas from Chinese natural-language requests.\n\n### Deployment Geography for Use:\n\nGlobal\n\n## Known Risks and Mitigations:\n\nRisk: Optional AI mode may send the user's formula description to OpenAI.\n\nMitigation: Avoid using --ai for confidential workbook data, employee information, customer data, or sensitive business context.\n\nRisk: Generated formulas and troubleshooting guidance may be incorrect or incomplete for a specific workbook.\n\nMitigation: Review and test formulas against representative workbook data before using them in business workflows.\n\nRisk: The release evidence notes an unused or unpinned openpyxl dependency.\n\nMitigation: Pin or remove unused dependencies before deployment according to the organization's dependency management policy.\n\n## Reference(s):\n\n- [ClawHub skill page](https://clawhub.ai/freedompixels/skills/cn-excel-formula)\n- [AISoBrand website](https://aisobrand.com)\n- [AISoBrand free diagnosis](https://aisobrand.com/free-diagnosis.html)\n\n## Skill Output:\n\n**Output Type(s):** [text, markdown, code, shell commands, guidance]\n\n**Output Format:** [Markdown and plain text with Excel formulas and command examples]\n\n**Output Parameters:** [1D]\n\n**Other Properties Related to Output:** [Chinese-language responses; optional AI generation can use OPENAI_API_KEY, while default formula generation uses local template matching.]\n\n## Skill Version(s):\n\n1.2.6 (source: server release evidence)\n\n## Ethical Considerations:\n\nUsers should evaluate whether this skill is appropriate for their environment, review any generated or modified files before relying on them, and apply their organization's safety, security, and compliance requirements before deployment."}],"languages":[],"docsSourceLabel":"CLAWHUB","editorialOverview":"Excel公式助手。自然语言描述需求，自动生成Excel公式。支持VLOOKUP、条件统计、日期计算、文本处理等200+常用公式。附带公式解释和示例数据。 Skill: Cn Excel Formula Owner: freedompixels Summary: Excel公式助手。自然语言描述需求，自动生成Excel公式。支持VLOOKUP、条件统计、日期计算、文本处理等200+常用公式。附带公式解释和示例数据。 Tags: latest:1.2.6, productivity:1.1.0 Version history: v1.2.6 | 2026-06-07T02:28:46.735Z | user 更新品牌信息格式 v1.2.1 | 2026-06-07T02:09:13.318Z | user 添加AISoBrand品牌信息 v1.2.5 | 2026-05-02T04:46:58.598Z | auto Version 1.2.5 - No file or documentation changes detected in this version. - Functio","editorialQuality":{"score":100,"threshold":65,"status":"ready","wordCount":773,"uniquenessScore":63,"reasons":[]}},"media":{"evidence":{"source":"no-media","verified":false,"confidence":"low","updatedAt":"2026-10-10T16:06:32.339Z","emptyReason":"No screenshots, media assets, or demo links are available."},"primaryImageUrl":null,"mediaAssetCount":0,"assets":[],"demoUrl":null},"ownerResources":{"evidence":{"source":"unclaimed","verified":false,"confidence":"low","updatedAt":"2026-10-10T16:06:32.339Z","emptyReason":"This page has not been claimed by the agent owner."},"hasCustomPage":false,"customPageUpdatedAt":null,"customLinks":[],"structuredLinks":{"docsUrl":null,"demoUrl":null,"supportUrl":null,"pricingUrl":null,"statusUrl":null},"customPage":null},"relatedAgents":{"evidence":{"source":"protocol-neighbors","verified":false,"confidence":"medium","updatedAt":"2026-10-10T21:43:47.546Z","emptyReason":null},"items":[{"id":"8ebccd8e-3863-4187-8355-c3f14e1f9edf","entityType":"agent","canonicalPath":"/agent/iofficeai-aionui","slug":"iofficeai-aionui","name":"AionUi","description":"Free, local, open-source 24/7 Cowork app and OpenClaw for Gemini CLI, Claude Code, Codex, OpenCode, Qwen Code, Goose CLI, Auggie, and more | 🌟 Star if you like it!","url":"https://github.com/iOfficeAI/AionUi","homepage":"https://www.aionui.com","source":"GITHUB_REPOS","protocols":["MCP","OPENCLAW"],"capabilities":[],"safetyScore":100,"overallRank":70,"updatedAt":"2026-10-09T19:11:12.944Z","createdAt":"2026-02-25T03:38:16.584Z","downloads":null},{"id":"b917f68a-ebff-438e-84f8-3f4b2494c0bc","entityType":"agent","canonicalPath":"/agent/activepieces-activepieces","slug":"activepieces-activepieces","name":"activepieces","description":"AI Agents & MCPs & AI Workflow Automation • (~400 MCP servers for AI agents) • AI Automation / AI Agent with MCPs • AI Workflows & AI Agents • MCPs for AI Agents","url":"https://github.com/activepieces/activepieces","homepage":"https://www.activepieces.com","source":"GITHUB_REPOS","protocols":["OPENCLAW"],"capabilities":[],"safetyScore":100,"overallRank":70,"updatedAt":"2026-04-15T02:22:12.426Z","createdAt":"2026-02-25T03:38:12.412Z","downloads":null},{"id":"5cb26759-3a39-483f-94cf-276a98c13bb8","entityType":"agent","canonicalPath":"/agent/cherryhq-cherry-studio","slug":"cherryhq-cherry-studio","name":"cherry-studio","description":"AI productivity studio with smart chat, autonomous agents, and 300+ assistants. Unified access to frontier LLMs","url":"https://github.com/CherryHQ/cherry-studio","homepage":"https://cherry-ai.com","source":"GITHUB_REPOS","protocols":["MCP","OPENCLAW"],"capabilities":[],"safetyScore":100,"overallRank":70,"updatedAt":"2026-04-11T14:38:40.986Z","createdAt":"2026-02-25T03:38:19.379Z","downloads":null},{"id":"6f6582d0-5d76-4f0f-b81d-86520247950b","entityType":"agent","canonicalPath":"/agent/copilotkit-copilotkit","slug":"copilotkit-copilotkit","name":"CopilotKit","description":"The Frontend for Agents & Generative UI. React + Angular","url":"https://github.com/CopilotKit/CopilotKit","homepage":"https://docs.copilotkit.ai","source":"GITHUB_REPOS","protocols":["OPENCLAW"],"capabilities":[],"safetyScore":100,"overallRank":70,"updatedAt":"2026-03-25T09:50:57.846Z","createdAt":"2026-02-25T03:39:14.617Z","downloads":null}],"links":{"hub":"/agent","source":"/agent/source/clawhub","protocols":[{"label":"OpenClaw","href":"/agent/protocol/openclew"}]}}}