HCP data process assist

从 HCP 仪器结果文件中提取汇总表。适用于用户提供的 HCP 类 Excel 文件，其中第一个 sheet 或原始文本包含 Sample、QC、Standards 等 Group 分段，并希望按样例格式生成新的汇总 sheet。

Security Scan

The skill's code and instructions match its stated purpose (extracting HCP instrument group summaries into a new Excel sheet); nothing in the files attempts network exfiltration or unrelated access, though the package assumes Python/OpenPyXL are available despite no declared install requirements.

Purpose & Capability

Name, description, SKILL.md, and the included Python script all describe the same operation: parsing HCP-style Excel/UTF-16 TSV exports and producing a formatted summary sheet. The required behavior is coherent with the stated purpose.

Instruction Scope

SKILL.md instructs the agent to run the included script on user-provided files and explains input/output behavior. The instructions only reference local file reads/writes and do not direct the agent to read unrelated system files or send data to external endpoints.

Install Mechanism

There is no install spec (instruction-only), which is low-risk. However, the script requires a Python runtime and the openpyxl package; these dependencies are not declared in the registry metadata or SKILL.md 'requirements' section. Users must ensure their environment has Python and openpyxl available.

Credentials

The skill requests no environment variables, credentials, or config paths. The script operates purely on files provided by the user and writes local output files—this is proportionate to the stated task.

Persistence & Privilege

always is false and the skill does not request persistent agent-level privileges. It does not modify other skills or system settings.

Assessment

This skill appears to do what it says: parse HCP-style Excel/TSV exports and generate a formatted summary sheet. Before installing or running it: (1) ensure you have Python 3 and the openpyxl package available (pip install openpyxl) because the registry metadata doesn't declare these; (2) run the script on copies of your files first (it writes new _extracted.xlsx files and can overwrite with --overwrite); (3) inspect the included script yourself (scripts/extract_hcp.py) if you have any security concerns—it performs only local file parsing and Excel writes and contains no network calls; (4) run it in a restricted environment or sandbox if the input files are sensitive until you are comfortable with its behavior.

HCP结果提取

当 HCP 结果文件遵循 hcp_dataextract/ 中样例的导出结构时，使用这个 skill。

功能说明

• 读取 .xlsx 工作簿，以及 UTF-16 制表符分隔的 .xls 导出文件。
• 从第一个 sheet 或原始导出文本中解析 Group: 分段。
• 提取 Sample、MeanResult 或 Meanresult、CV% 或 CV。
• 按样例布局生成新的汇总 sheet，起始位置为第 C 列、第 4 行。
• 仅对生成的汇总 sheet 设置背景色：分组行、表头行、分组后的空白行用浅蓝色，数据行用淡绿色。

使用命令

运行内置脚本：

python scripts/extract_hcp.py <input-path>

常用参数：

• --output-dir <dir>：将处理结果写入指定目录。
• --sheet-name <name>：指定生成的汇总 sheet 名称，默认是 Sheet1。
• --overwrite：若输出文件已存在则覆盖。

输入路径既可以是单个文件，也可以是目录。若传入目录，脚本会扫描其中的 .xlsx、.xlsm、.xls 文件。

输出行为

• 对 .xlsx 和 .xlsm 文件，脚本会复制原工作簿，替换或创建汇总 sheet，并另存为以 _extracted.xlsx 结尾的新文件。
• 对 UTF-16 文本形式的 .xls 导出文件，脚本会生成新的 .xlsx 工作簿，其中：
  • 第 1 个 sheet：导入后的原始数据
  • 第 2 个 sheet：提取后的汇总表
• 第一个 sheet 的原始数据不设置颜色，只有第二个 sheet 的汇总表会应用背景色。

说明

• 解析逻辑基于表头名称而不是固定列号，因此兼容 MeanResult / Meanresult 以及 CV% / CV。
• 会忽略空白续行，只提取每个样本的主记录行。
• 只有汇总 sheet 会设置样式，原始数据的第一个 sheet 不做颜色处理。
• 汇总 sheet 的样式与样例保持一致：分组行、表头行、分组后的空白行使用浅蓝色，数据行使用淡绿色。