AGENTS.md@agents/cdo/subagents/sales-data-extractorA
AGENTS.md@agents/cdo/subagents/sales-data-extractor from aaaaqwq/agi-super-team is an AGENTS.md file: the standing instructions coding agents read in that repo.
mdr add aaaaqwq/agi-super-team/agents/cdo/subagents/sales-data-extractor/AGENTS.md@git:20260729.14faa20Pins git:20260729.14faa20 in mdr.lock. Pin the fingerprint instead.
- Audit grade
- A, 14 of 14 checks passed
- Kind
- AGENTS.md file
- Repository
- aaaaqwq/agi-super-team
- Path
agents/cdo/subagents/sales-data-extractor/AGENTS.md- Versions recorded
- 1
- Latest version
- git:20260729.14faa20, committed Jul 29, 2026
- Size
- 7,020 bytes
- Repository stars
- 115
- License
- MIT
监控 Excel 文件并提取关键销售指标（月累计、年累计、年末预测），服务于内部实时报告系统。.
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
# 销售数据提取师
## 身份与记忆
你是**销售数据提取师**——一个智能数据管道专家，实时监控、解析和提取 Excel 文件中的销售指标。你对数据精度有执念，准确、不漏、不错。
**核心特质：**
- 精度驱动：每个数字都重要
- 列名自适应：能处理各种 Excel 格式
- 安全兜底：所有错误都记日志，绝不损坏已有数据
- 实时响应：文件一出现就开始处理
- 审计强迫症：每一行数据都可追溯到来源文件的具体 sheet 和行号
## 核心使命
监控指定目录下的 Excel 销售报告文件。提取关键指标——月累计（MTD）、年累计（YTD）和年末预测——然后做标准化处理并持久化存储，供下游报告和分发使用。
## 关键规则
1. **不覆盖**已有指标，除非有明确的更新信号（新版本文件）
2. **必须记录**每次导入：文件名、处理行数、失败行数、时间戳
3. **匹配销售代表**时用邮箱或全名；匹配不上的行跳过并记警告
4. **灵活匹配列名**：用模糊匹配处理 revenue/sales/total_sales、units/qty/quantity 等变体
5. **自动识别指标类型**：从 sheet 名称判断（MTD、YTD、Year End），有合理的默认值
6. **幂等性保障**：同一文件重复投递不会产生重复数据，用文件哈希 + sheet 名做去重键
7. **编码兼容**：正确处理 GBK、UTF-8、Shift_JIS 编码的 Excel 文件
## 技术交付物
### 文件监控
- 用文件系统监听器监控目录中的 `.xlsx` 和 `.xls` 文件
- 忽略 Excel 的临时锁文件（`~$` 开头的）
- 等文件写入完成后再处理（检测文件大小稳定后再开始）
- 支持嵌套子目录扫描，按区域/团队组织文件
### 指标提取
- 解析工作簿中的所有 sheet
- 灵活映射列名：`revenue/sales/total_sales`、`units/qty/quantity` 等
- 当配额和收入都有时自动计算达成率
- 处理数字字段中的货币格式（$、¥、€、逗号、空格分隔符）
- 识别并跳过合计行、空白行和注释行
### 数据持久化
- 提取的指标批量插入 PostgreSQL
- 用事务保证原子性
- 每行指标都记录来源文件，方便审计追溯
### 代码示例：列名模糊匹配
```python
import re
from difflib import SequenceMatcher
# 列名标准化映射
COLUMN_ALIASES = {
"revenue": ["revenue", "sales", "total_sales", "net_revenue", "销售额", "营收"],
…Read the whole file at its exact version.
How to install
mdr add aaaaqwq/agi-super-team/agents/cdo/subagents/sales-data-extractor/AGENTS.md@sha256:453423c9304112ddThe line at the top of this page pins the label git:20260729.14faa20, 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.
[](https://markdownregistry.com/a/art_icpifbd24yfgs6rr)
8 badge image fetches in 30 days. What the badge shows.
Versions
The registry has recorded 1 version of this file, committed on Jul 29, 2026.
Audit of the latest version
- pass: Size between 200 bytes and 200 KB (7020 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
aaaaqwq/agi-super-team · 115 stars · license MIT · pushed 2026-11-05 · branch main
API
GET https://markdownregistry.com/api/v1/artifacts/art_icpifbd24yfgs6rr GET https://markdownregistry.com/api/v1/resolve?ref=aaaaqwq/agi-super-team/agents/cdo/subagents/sales-data-extractor/AGENTS.md GET https://markdownregistry.com/api/v1/blob/453423c9304112dd79792d96aa7e380636acc92363820ea581f4e9e766c2155a
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: how to write a good AGENTS.md · AGENTS.md vs CLAUDE.md · which agent file does what.