lls-local-excel-vba-data-processor SKILL.md skillA

lls-local-excel-vba-data-processor from philrobinluo/ai-coevolution-skills is an agent skill: a SKILL.md folder an AI agent loads when a task calls for it.

Install it, pinned
mdr add philrobinluo/ai-coevolution-skills/lls-local-excel-vba-data-processor@git:20260728.98e6d92

Pins git:20260728.98e6d92 in mdr.lock. Pin the fingerprint instead.

Audit grade
A, 17 of 17 checks passed
Kind
SKILL.md skill
Repository
philrobinluo/ai-coevolution-skills
Path
skills/lls-local-excel-vba-data-processor/SKILL.md
Versions recorded
5
Latest version
git:20260728.98e6d92, committed Jul 28, 2026
First version recorded
Jul 28, 2026
Size
8,230 bytes
Repository stars
4
License
a license file GitHub does not identify

在数据不离开本机的前提下,设计、审查和交付 Excel VBA 数据处理方案。用于批量清洗、匹配、拆分、汇总、生成报表或处理敏感表格;必须先确认工作簿结构、备份与样例,再给出带中文注释、日志、异常处理、回滚和验收步骤的宏,不要求上传真实数据。.

Collected from public GitHub. Every version is saved exactly as it was and never changes. Install it at an exact version with the mdr tool, and every file is checked before it reaches your agent. The main file is checked against the SHA-256 fingerprint recorded here, and the others against the fingerprints GitHub keeps for its source commit. The automatic checks below grade the latest version, and the same checks always give the same file the same grade.

What the file says

<!-- workbuddy-install: published; slug: lls-local-excel-vba-data-processor -->
## 在 WorkBuddy 中找到并安装

**Skill slug:`lls-local-excel-vba-data-processor`**

在 WorkBuddy 新会话粘贴:

```text
请按 https://skillhub.cn/install/skillhub.md 检查 SkillHub,搜索 `lls-local-excel-vba-data-processor`;仅在 slug 完全一致时安装到 `~/.workbuddy/skills/`。安装后读取 `~/.workbuddy/skills/lls-local-excel-vba-data-processor/SKILL.md`,核对 name、version 和实际路径,然后新开会话触发该 Skill。
```

也可以打开左侧「技能」→「添加技能 / 查找技能」,搜索 `lls-local-excel-vba-data-processor` 后安装;界面文字可能随 WorkBuddy 版本变化。

# 罗老师 Excel VBA 本地数据处理

## 核心目标

帮助用户把重复的 Excel 操作变成可审计、可回滚、可复用的本地宏。

这个 Skill 的重点不是“快速吐出一段 VBA”,而是:

1. 先理解表格结构和业务规则;
2. 用脱敏样例验证规则;
3. 生成有保护措施的 VBA;
4. 明确运行、备份、日志和验收方法;
5. 让真实数据始终保留在用户自己的电脑中。

## 适用场景

- 多张工作表批量合并或拆分;
- 按编号、姓名或组合键匹配数据;
- 清洗空格、日期、金额、重复记录和异常值;
- 生成分类汇总、月报或部门报表;
- 批量建立文件、工作表或打印区域;
- 处理人事、财务、客户等不适合上传的数据。

## 不适用场景

- 多人实时协作或需要数据库级并发;
- 超过 Excel 可稳定承载的数据规模;
- 用户需要绕过工作簿保护、访问控制或审计机制;
- 规则尚未明确,却要求直接在唯一原件上运行。

## 隐私优先规则

1. 默认不要求上传真实工作簿;
2. 优先使用字段名、三到十行脱敏样例和规则描述;
3. 姓名、手机号、身份证号、银行卡号和客户编号使用占位符;
4. 宏默认不联网、不发邮件、不调用外部 API;
5. 任何文件写入位置都由用户明确指定;
6. 第一次运行只处理副本。

## 开始前的最小信息

询问不超过五个关键问题:

1. Excel 是 Windows 版还是 Mac 版,版本大致是什么?
2. 输入工作簿、工作表和表头分别是什么?
…

Read the whole file at its exact version.

How to install

The exact contents, by fingerprint
mdr add philrobinluo/ai-coevolution-skills/lls-local-excel-vba-data-processor@sha256:853dbc9e0e4152b8

The line at the top of this page pins the label git:20260728.98e6d92, which is what most people want. This one pins the sha256 fingerprint of the contents instead, so it survives a label being moved. Either way the exact version is written to mdr.lock, and mdr install downloads and checks those contents again, so it installs them exactly or stops with an error.

Badge

mdr badge

[![mdr](https://markdownregistry.com/badge/art_5ibxpqy4hufpmoep.svg)](https://markdownregistry.com/a/art_5ibxpqy4hufpmoep)

3 badge image fetches in 30 days. What the badge shows.

Versions

The registry has recorded 5 versions of this file, all committed on Jul 28, 2026.

versioncommittedcommitsizeaudit
git:20260728.98e6d92 latest2026-07-28 98e6d92 8,230 BA view · diff
git:20260728.7cf79262026-07-28 7cf7926 8,230 BA view · diff
v1.2.02026-07-28 b17ce21 8,245 BA view · diff
git:20260728.2143e6a2026-07-28 2143e6a 7,475 BA view · diff
git:20260728.c020fe62026-07-28 c020fe6 6,838 BA view

Audit of the latest version

A  17 of 17 checks passed. Fixed automatic checks with no AI involved, so the same checks give the same answer every run.
  • pass: Frontmatter block present
  • pass: Frontmatter declares a name
  • pass: Frontmatter declares a description
  • pass: Size between 200 bytes and 200 KB (8230 bytes)
  • pass: No zero-width or bidi control characters
  • pass: No instruction hidden inside an HTML comment
  • pass: No link to an exfiltration or paste host
  • pass: No credential-shaped string
  • pass: No instruction to send local credentials anywhere
  • pass: No text hidden with inline styles
  • pass: No prompt-injection phrasing
  • pass: No curl or wget piped into a shell
  • pass: No recursive delete of root, home or parent
  • pass: No instruction to read or print local credentials
  • pass: No base64 blob over 200 characters
  • pass: No link to a raw IP address
  • pass: No script tag

Source

GitHub

philrobinluo/ai-coevolution-skills · 4 stars · license a license file GitHub does not identify · pushed 2026-09-09 · branch main

API

GET https://markdownregistry.com/api/v1/artifacts/art_5ibxpqy4hufpmoep
GET https://markdownregistry.com/api/v1/resolve?ref=philrobinluo/ai-coevolution-skills/lls-local-excel-vba-data-processor
GET https://markdownregistry.com/api/v1/blob/853dbc9e0e4152b8da64335e0018ff78a337b8a34017e91fabff750826fea743

Your AI assistant does the legwork. You hear about the deals worth your word. Hand yours the standing instructions at modelranch.com and it joins the network that reads files like this one.

Guides: the SKILL.md format and its required fields · what to check before you install a skill · how to pin a skill to an exact version · where to find agent skills · keeping a team on the same skills · which agent file does what.

More from philrobinluo/ai-coevolution-skills

AGENTS.md AGENTS.md file
philrobinluo/ai-coevolution-skills · AGENTS.md
git:20260728.3d3a455 · audit A · 4 stars
lls-best-minds-consultation SKILL.md skill
philrobinluo/ai-coevolution-skills · adapted/lls-best-minds-consultation/SKILL.md · 为高不确定决策选择少量相关专家视角,分别论证后汇总共识、冲突、行动和反证条件。 当用户面对相应复杂任务并需要可验证结果时使用。
git:20260728.f8dcb06 · audit A · 4 stars
bilingual-reader-maker SKILL.md skill
philrobinluo/ai-coevolution-skills · skills/bilingual-reader-maker/SKILL.md · Use when the user asks to make bilingual reading materials, bilingual PDFs, Chinese-English study editions…
git:20260728.7cf7926 · audit A · 4 stars
concept-explainer SKILL.md skill
philrobinluo/ai-coevolution-skills · skills/concept-explainer/SKILL.md · Plain-language concept explainer and task knowledge-card generator. Use when a task contains tools, commands, files…
git:20260728.7cf7926 · audit A · 4 stars
lls-ai-data-analysis-starter SKILL.md skill
philrobinluo/ai-coevolution-skills · skills/lls-ai-data-analysis-starter/SKILL.md · 带普通用户把 Excel、CSV 或表格问题转成可复核的数据分析。用于第一次做数据清洗、描述统计、分组比较、趋势、异常检查、图表和结论汇报时;必须先明确业务问题、字段含义、时间范围与统计口径,再检查数据质量并生成可重复步骤,不把相关性写成因…
git:20260728.7cf7926 · audit A · 4 stars
lls-ai-drawing-prompt-coach SKILL.md skill
philrobinluo/ai-coevolution-skills · skills/lls-ai-drawing-prompt-coach/SKILL.md · 把用户的模糊画面想法整理成可测试、可迭代的文生图提示词和视觉方案。用于角色、场景、商品氛围图、插画、封面素材或概念图创作时;必须先明确画面用途、主体、叙事瞬间、构图、光线、色彩与限制,一次只调整一个变量并记录结果,不堆砌互相冲突的风格词。
git:20260728.7cf7926 · audit A · 4 stars
lls-ai-microdrama-planner SKILL.md skill
philrobinluo/ai-coevolution-skills · skills/lls-ai-microdrama-planner/SKILL.md · 把一个题材想法发展成可连续生产的 AI 漫剧或短剧方案。用于确定受众承诺、人物欲望、冲突引擎、单集节拍、悬念钩子、分镜资产与连续性规则时;必须区分故事设定、已发生事实和待验证假设,不用随机反转、旁白堆积或视觉奇观代替因果推进。
git:20260728.7cf7926 · audit A · 4 stars
lls-ai-novel-prompt-engineer SKILL.md skill
philrobinluo/ai-coevolution-skills · skills/lls-ai-novel-prompt-engineer/SKILL.md · 为中长篇小说建立可持续迭代的提示词与状态管理系统。用于从故事承诺、人物弧线、世界规则和情节因果生成大纲、场景、续写或修订时;必须把固定事实、当前状态、创作意图和本轮任务分层管理,先规划再生成、生成后更新账本,避免模型遗忘、设定漂移、万能文风…
git:20260728.7cf7926 · audit A · 4 stars
lls-ai-poster-design-coach SKILL.md skill
philrobinluo/ai-coevolution-skills · skills/lls-ai-poster-design-coach/SKILL.md · 把活动、课程、产品或品牌信息整理成可执行的海报内容与版式方案。用于需要明确传播目标、信息优先级、文案、尺寸、安全区、视觉方向、生成素材和导出验收时;必须先建立信息层级,再设计版式和图像,不把全部文字塞进画面,也不依赖图像模型生成准确正文。
git:20260728.7cf7926 · audit A · 4 stars
lls-ai-video-script-planner SKILL.md skill
philrobinluo/ai-coevolution-skills · skills/lls-ai-video-script-planner/SKILL.md · 把主题、受众、素材和制作条件规划成可拍摄或可由视频生成工具执行的分镜脚本。用于知识视频、产品演示、品牌故事、教程或 AI 辅助视频制作,需要故事节拍、旁白、镜头、画面提示、素材清单和制作验收时;必须先锁定传播目标与真实证据,再设计镜头,不用…
git:20260728.7cf7926 · audit A · 4 stars
lls-aida-marketing-copywriter SKILL.md skill
philrobinluo/ai-coevolution-skills · skills/lls-aida-marketing-copywriter/SKILL.md · 用 AIDA 结构把真实产品、课程、活动或服务材料写成可验证的营销文案。用于广告、落地页、私域消息、海报文案和短视频转化段落时;必须先明确受众处境、产品事实、可信证据、渠道和行动成本,再组织注意、兴趣、渴望与行动,不制造虚假稀缺、伪造评价、…
git:20260728.7cf7926 · audit A · 4 stars
lls-article-screenshot SKILL.md skill
philrobinluo/ai-coevolution-skills · skills/lls-article-screenshot/SKILL.md · 为教程、产品复盘和操作说明规划并采集能证明关键步骤的真实界面截图。用于决定截图证据点、清理演示环境、在 macOS 选择区域/窗口/全屏模式、规范命名、生成 Markdown…
git:20260728.436c346 · audit A · 4 stars

Every file in philrobinluo/ai-coevolution-skills

Browse by kind, by grade A, or by owner.