HomeBrowseUpload
← Back to registry
// Skill profile

Cutting Time Statistics Skill

**Requires Aiwei time template file to work!**

by brucetangc · published 2026-04-01

数据处理
Total installs
0
Stars
★ 0
Last updated
2026-04
// Install command
$ claw add gh:brucetangc/brucetangc-cutting-time-statistics
View on GitHub
// Full documentation

# 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

    // Comments
    Sign in with GitHub to leave a comment.
    // Related skills

    More tools from the same signal band