OpenSkillIndex← back to search
claude-codeopenclawautomation

Skills cutting-time-statistics

Cutting Time Statistics Skill

install
source · Clone the upstream repo
git clone https://github.com/openclaw/skills
Claude Code · Install into ~/.claude/skills/
T=$(mktemp -d) && git clone --depth=1 https://github.com/openclaw/skills "$T" && mkdir -p ~/.claude/skills && cp -r "$T/skills/brucetangc/cutting-time-statistics" ~/.claude/skills/openclaw-skills-cutting-time-statistics && rm -rf "$T"
OpenClaw · Install into ~/.openclaw/skills/
T=$(mktemp -d) && git clone --depth=1 https://github.com/openclaw/skills "$T" && mkdir -p ~/.openclaw/skills && cp -r "$T/skills/brucetangc/cutting-time-statistics" ~/.openclaw/skills/openclaw-skills-cutting-time-statistics && rm -rf "$T"
manifest: skills/brucetangc/cutting-time-statistics/SKILL.md
tags
#pdf-parsing#data-extraction#excel-generation#automation#report-generation#data-analysis
source content

Cutting Time Statistics Skill

Prerequisites

Requires Aiwei time template file to work!

Template path: 

/home/admin/.openclaw/media/inbound/艾威时间模板.xlsx

Template file is not included, users need to prepare it themselves.

Function

Extract cutting time from laser cutting PDF files, summarize by thickness, and generate Excel report in Aiwei template format.

Usage

python3 calculator.py <zip_path> [output_path]

Example

python3 calculator.py AW-25-2072.7z
# Output: AW-25-2072_Cutting_time_statistics.xlsx

Features

  • Extract thickness from PDF filename
  • Extract cutting time from Job data in PDF
  • Merge same thickness (e.g., 5mm + 5Mn)
  • D column empty, E column with total time (2 decimal places)
  • Auto-update formulas (F/H/L columns)
  • Summary in remark row with border and center alignment
  • Built-in self-check function

Version

5.0.0