Getting it into your agent
One page per mod, every tool's command on it. A separate URL per tool would split the same page into five that compete with each other.
npx skills add Bwkyd/wps-skills --skill wps-formulagit clone --depth 1 https://github.com/Bwkyd/wps-skillsWrote this? Show the measurements
A badge with what this costs and how it scanned, read live from this page, so it follows the numbers instead of freezing them. Markdown for a README, HTML for a documentation site or a project page.
[](https://agentmods.dev/skills/bwkyd/wps-skills/wps-formula)<a href="https://agentmods.dev/skills/bwkyd/wps-skills/wps-formula"><img src="https://agentmods.dev/badge/skills/bwkyd/wps-skills/wps-formula/github.svg" alt="Measured on agentmods" height="20"></a>Or the 80×15 button, for a site that already has a row of RSS and ATOM ones. Only the verdict fits; the numbers stay here.
<a href="https://agentmods.dev/skills/bwkyd/wps-skills/wps-formula"><img src="https://agentmods.dev/badge/skills/bwkyd/wps-skills/wps-formula.svg" alt="Reviewed on agentmods" width="80" height="20"></a>What it costs to keep this loaded
Counted locally with the o200k_base tokenizer, which is exact for GPT models; Claude uses its own tokenizer and its counts differ. Treat this as one consistent yardstick across the catalogue rather than a bill. Prices are per million input tokens.
| Model | Per session | Once invoked |
|---|---|---|
| Fable 5.1 | $0.00080 | $0.02568 |
| Opus 5.5 | $0.00032 | $0.01027 |
| Sonnet 5.5 | $0.00016 | $0.00514 |
| Haiku 4.5 | $0.00008 | $0.00257 |
Grade A, and why
wps-formula scanned grade A with 0 findings against 26 rules in 11 categories — prompt injection, anti-refusal, data exfiltration, privilege escalation, supply chain, agent snooping, system-prompt leakage, SSRF and excessive agency — measured 1mo ago.
A static scan of the body, not an audit. Every finding is printed with the line that produced it so you can judge whether it matters here. A mod is markdown that instructs an agent; that is exactly why what it instructs is worth reading.
Nothing flagged
None of the 26 patterns this scan looks for appear in this file: no shell pipes, no recursive deletes, no credential paths, no hidden text, no instruction-override or anti-refusal phrasing, no agent-config snooping. That is not a guarantee, it is the absence of the things that are checkable.
How it starts
The opening of the file, as written. The whole thing — 210 lines — stays where its author put it; the contents beside it link to each section on GitHub.
WPS 公式专家
用中文描述你想算什么 → 自动生成 WPS 表格公式。
核心原则：生成的公式必须在 WPS 表格中可直接使用。注意 WPS 与 Excel 的函数差异。
When to Use
- 用户不知道该用什么函数
- 用户需要复杂的嵌套公式
- 用户遇到公式错误（#VALUE!, #REF!, #N/A等）
- 用户需要从自然语言描述转换为公式
- 用户问"怎么用公式实现XXX"
When NOT to Use
- 用户需要编写WPS宏脚本 → 使用
wps-jsa-macro - 用户需要数据清洗（去重/去空）→ 使用
wps-data-clean - 用户需要创建数据透视表 → 使用
wps-pivot
工作流程
Step 1: 理解需求
确认：
- 数据位置：数据在哪些单元格/列？（如"A列是姓名，B列是销售额"）
- 计算目标：想得到什么结果？
- 特殊条件：是否有筛选条件、多条件、跨表引用？
Step 2: 生成公式
输出格式必须包含：
📌 公式：
=YOUR_FORMULA_HERE
📝 说明：
- 逐段解释公式的每个部分
- 指出关键函数的作用
📋 使用方法：
- 在哪个单元格输入
- 是否需要下拉填充
- 注意事项
⚠️ 注意：
- WPS兼容性提醒（如有）
- 常见陷阱
Step 3: 公式调试（如遇到错误）
用户反馈错误时，按此流程排查：
#VALUE! → 数据类型不匹配（文本vs数字），检查是否有空格或隐藏字符
#REF! → 引用的单元格被删除或超出范围
#N/A → 查找函数未找到匹配值，检查查找值是否完全一致
#NAME? → 函数名拼写错误或WPS不支持该函数
#DIV/0! → 除数为零，用IFERROR包裹
#NUM! → 数值参数无效
循环引用 → 公式直接或间接引用了自身所在单元格
WPS 函数速查（按场景分类）
查找匹配（最高频！）
| 场景 | 推荐公式 | 示例 |
|---|---|---|
| 精确查找 | VLOOKUP |
=VLOOKUP(A2,Sheet2!A:C,3,0) |
| 左向查找 | INDEX+MATCH |
=INDEX(A:A,MATCH(D2,C:C,0)) |
| 多条件查找 | INDEX+MATCH嵌套 |
=INDEX(D:D,MATCH(1,(A:A=F2)*(B:B=G2),0)) ⚠️需Ctrl+Shift+Enter |
| 模糊匹配 | VLOOKUP通配符 |
=VLOOKUP("*"&A2&"*",B:C,2,0) |
| 存在性检查 | COUNTIF |
=IF(COUNTIF(B:B,A2)>0,"有","无") |
条件统计
| 场景 | 推荐公式 | 示例 |
|---|---|---|
| 单条件求和 | SUMIF |
=SUMIF(A:A,"销售部",B:B) |
| 多条件求和 | SUMIFS |
=SUMIFS(C:C,A:A,"销售部",B:B,">1000") |
| 单条件计数 | COUNTIF |
=COUNTIF(A:A,"合格") |
| 多条件计数 | COUNTIFS |
=COUNTIFS(A:A,"男",B:B,">=90") |
| 条件平均 | AVERAGEIF |
=AVERAGEIF(A:A,"A班",B:B) |
| 条件最大 | MAXIFS |
=MAXIFS(B:B,A:A,"销售部") ⚠️WPS2019+ |
文本处理
| 场景 | 推荐公式 | 示例 |
|---|---|---|
| 提取前N字符 | LEFT |
=LEFT(A2,3) |
| 提取后N字符 | RIGHT |
=RIGHT(A2,4) |
| 提取中间 | MID |
=MID(A2,4,8) 从第4位取8个字符 |
| 查找位置 | FIND/SEARCH |
=FIND("@",A2) FIND区分大小写 |
| 替换 | SUBSTITUTE |
=SUBSTITUTE(A2," ","") 去空格 |
| 合并文本 | CONCATENATE/& |
=A2&"-"&B2 |
| 文本转数字 | VALUE |
=VALUE(A2) |
| 数字转文本 | TEXT |
=TEXT(A2,"0.00") |
| 去首尾空格 | TRIM |
=TRIM(A2) |
| 提取中文 | 正则不支持 | 用VBA/JSA替代 |
What ships with it
2 files beside SKILL.md in the same directory: the scripts, references and assets a skill reads on demand. Not counted in the per-session cost; read them before you install if any of them is executable.
What this file has done since we first saw it
Hashed on every crawl. A supply-chain change to an agent config is a question of when, not whether, so the history is kept rather than the latest state alone.
- 1mo ago First seen · 210 lines · 80 tokens per session scan A b94e240c7ab9
wps-formula is a skill published in the GitHub repository Bwkyd/wps-skills (10 stars, last pushed 5mo ago), licensed MIT. It adds 80 tokens to every session and 2,568 once invoked, about $0.0003 per session on Opus 5.5. A static security scan graded it A with 0 findings. No closer match exists in the catalogue, so it is treated as the original; first seen 2026-08-31.
Other skills, from other repositories
mqc-chronicle-master
A document-preparation workflow that turns a collection of legal materials into a dated case timeline. It copies facts from the source, records dates, parties, page references, and conflicts, and produces Word, Excel, and a short visual version.
xlsx
Use this skill any time a spreadsheet file is the primary input or output. This means any task where the user wants to: open, read, edit, or fix an existing .xlsx, .xlsm, .xltx, .csv, or .tsv file (e.g., adding columns, computing formulas, formatting, charting, cleaning messy data); create a new spreadsheet from…
genoffice
Create, convert, read and edit Office documents locally with GenOffice's command line. Build a new presentation (pptx) from a brief through a checked outline, per-page spec and render pipeline, a new spreadsheet (xlsx) from CSV or JSON data with formulas, a new Word document (docx) from Markdown or HTML, or a PDF…
budget-planner
Turn a business plan into an annual or project budget with account lines, monthly spread, summaries and a separate assumptions sheet, delivered as an Excel workbook.
data-cleaning
Define cleaning rules, then deduplicate and standardise dirty data into a clean table with a line-by-line cleaning log, delivered as an Excel workbook.
expense-report
Turn a pile of receipts into an expense claim summary that flags missing receipts, over-limit items and duplicates, delivered as an Excel workbook.