← Back to Skills Marketplace
Review Summary
by
lialia691691-alt
· GitHub ↗
· v1.0.0
· MIT-0
35
Downloads
0
Stars
0
Active Installs
1
Versions
Install in OpenClaw
/install review-summary
Description
Generate 4-sheet Excel review summary (评审汇总表) from 广联达 export data for budget review projects. Auto-classifies review line items into 7 categories: repeat-bi...
README (SKILL.md)
评审汇总表生成
从广联达导表自动生成4张评审汇总表。
用法
python3 scripts/generate_review_summary.py \x3C数据目录> \x3C输出.xlsx> \
--project "项目名" --building-area 208465.8
数据目录下需含 分部分项汇总审核导表.xlsx 和 总审核导表.xlsx。
输出
| Sheet | 内容 |
|---|---|
| 评审底稿 | 封面：送审/审定金额汇总、签名栏 |
| 汇总表 | 单位工程 × 7大类别矩阵 |
| 导表填写 | 逐条清单分类映射（含审增减原因原文） |
| 审增减明细生成表 | 按7类别归集的正式审增减清单 |
分类规则
脚本按优先级匹配关键字自动分类，详见 references/classification.md。
⚠️ 自动分类需人工复核：
[调价]项默认归入材料价格，可能实为定额子目调整- 关键字无法识别隐式重复计取
- 措施费/税金调整依赖"基数/税金"等关键字命中
复核后修正分类，重新运行即可。
模板
原始模板位于 assets/评审汇总表模板（四张表）.xls，作为样式参考。
详细参考
- 模板4张Sheet的完整列结构和数据映射：
references/template_structure.md - 7类审增减分类规则及判断依据：
references/classification.md
Usage Guidance
This appears safe for its stated purpose, but it will run local Python code on budget review spreadsheets. Use it on the intended folder only, verify that Python/openpyxl are available, and manually review the automatically classified categories as the skill itself recommends.
Capability Analysis
Type: OpenClaw Skill
Name: review-summary
Version: 1.0.0
The skill bundle is a specialized utility for generating construction budget review reports from Glodon (广联达) Excel exports. The Python script (scripts/generate_review_summary.py) uses the openpyxl library to process local data and generate a multi-sheet summary without any network activity, shell execution, or unauthorized file access. The documentation (SKILL.md and references/) accurately describes the tool's logic and classification rules, and no evidence of malicious intent or prompt injection was found.
Capability Assessment
Purpose & Capability
The stated purpose—generating a 4-sheet budget review summary from 广联达 Excel exports—matches the visible script behavior of reading named Excel files, classifying rows, and producing an output workbook.
Instruction Scope
The instructions are user-directed and tied to clear trigger phrases or a provided data folder; they do not attempt to override user intent, force hidden tool use, or change stopping conditions.
Install Mechanism
The registry says there is no install spec or required binary, but the skill instructs running a Python script and the code imports openpyxl. This is not suspicious, but users should ensure the runtime dependency is available.
Credentials
The script processes local project Excel files and writes a new Excel workbook. This local file access is proportionate to the skill purpose, but users should run it only on intended project folders because the data may contain business or budget information.
Persistence & Privilege
No credentials, network calls, background persistence, startup hooks, or privilege escalation are evident in the provided artifacts.
How to Use
- Make sure OpenClaw is installed (local or Docker)
- Run the install command in chat:
/install review-summary - After installation, invoke the skill by name or use
/review-summary - Provide required inputs per the skill's parameter spec and get structured output
Version History
v1.0.0
Initial release of the review-summary skill.
- Automatically generates a 4-sheet Excel review summary (评审汇总表) from 广联达 export data for budget review projects.
- Auto-classifies review line items into 7 standard categories: repeat-billing, omission, quantity, quota-subitem, material-price, other, base-adjustment.
- Supports direct input of folders with required 广联达导表 files for processing.
- Produces a comprehensive package including 评审底稿, 汇总表, 导表填写, and 审增减明细 sheets.
- Includes instructions for usage, folder requirements, and classification rules for effective review and adjustment.
Metadata
Frequently Asked Questions
What is Review Summary?
Generate 4-sheet Excel review summary (评审汇总表) from 广联达 export data for budget review projects. Auto-classifies review line items into 7 categories: repeat-bi... It is an AI Agent Skill for Claude Code / OpenClaw, with 35 downloads so far.
How do I install Review Summary?
Run "/install review-summary" in the OpenClaw or Claude Code chat to install it in one step — no extra setup required.
Is Review Summary free?
Yes, Review Summary is completely free, licensed under MIT-0. You can download, install and use it at no cost.
Which platforms does Review Summary support?
Review Summary is cross-platform and runs anywhere OpenClaw / Claude Code is available (cross-platform).
Who created Review Summary?
It is built and maintained by lialia691691-alt (@lialia691691-alt); the current version is v1.0.0.
More Skills