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 | $0.00040 | $0.01284 |
| Sonnet 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 10d 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.
- 10d 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 (7 stars, last pushed 4mo ago), licensed MIT. It adds 80 tokens to every session and 2,568 once invoked, about $0.0004 per session on Opus 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
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, .csv, or .tsv file (e.g., adding columns, computing formulas, formatting, charting, cleaning messy data); create a new spreadsheet from scratch or…
xlsx
Create, edit, analyze, or convert Excel spreadsheets (.xlsx, .xlsm, .xltx) where the workbook file is the primary deliverable. Use for formulas, formatting, financial models, multi-sheet workbooks, and tabular cleanup exported to Excel. Also applies to .csv/.tsv when the user wants spreadsheet output. Do NOT use for…
document-generation
Generate Word (.docx), Excel (.xlsx) and PowerPoint (.pptx) documents and fill existing PDF forms, from real NetClaw data, with per-element provenance and no fabrication. Use when someone needs a deliverable rather than an answer — a change record to attach to a CR, an audit workbook for a compliance reviewer, a…
dgn-to-excel
Convert DGN files (v7-v8) to Excel databases. Extract elements, levels, and properties from infrastructure CAD files.
dwg-to-excel
Convert AutoCAD DWG files (1983-2026) to Excel databases using DwgExporter CLI. Extract layers, blocks, attributes, and geometry data without Autodesk licenses.
ifc-to-excel
Convert IFC files (2x3, 4x1, 4x3) to Excel databases using IfcExporter CLI. Extract BIM data, properties, and geometry without proprietary software.