Cutting Time Statistics

What This Skill Does

The Cutting Time Statistics skill by brucetangc is a specialized automation tool designed for laser cutting manufacturing workflows. It streamlines the tedious process of calculating production hours from unstructured PDF job data. By analyzing batches of laser cutting reports, the skill extracts the material thickness and total cutting time, then formats the output into a standardized Aiwei Excel template. It effectively replaces manual data entry with high-precision automation, ensuring that production tracking remains accurate and standardized across the entire manufacturing floor.

Installation

To integrate this skill into your OpenClaw environment, ensure you have the necessary dependencies installed and the Aiwei template file configured at the required path. Run the following command in your terminal:

clawhub install openclaw/skills/skills/brucetangc/cutting-time-statistics

Before running, ensure you have placed your personal 艾威时间模板.xlsx at /home/admin/.openclaw/media/inbound/. The skill will fail if this file is missing, as it serves as the rigid structure for the generated report.

Use Cases

This skill is ideal for shop floor managers, production planners, and cost estimators. Primary use cases include:

• Aggregating daily production times from multiple laser machine output files.
• Generating end-of-day reports to track machine utilization rates.
• Standardizing cost estimation data for multi-thickness batch runs.
• Reducing human error in manual spreadsheet data compilation for large-scale manufacturing projects.

Example Prompts

1. "OpenClaw, run the cutting time calculator on the zip file located at /data/jobs/weekly_production_batch.7z and save the summary to the current folder."
2. "Process the recent laser cutting batch AW-25-2072.7z using the cutting-time-statistics skill and let me know when the Excel report is generated."
3. "Summarize the production times for the PDFs inside factory_output.7z using the standard template and format the results by thickness."

Tips & Limitations

• Template Sensitivity: The skill is strictly dependent on the Aiwei template. Ensure your template file is not corrupted and adheres to the expected column structure (D, E, F, H, L columns).
• Naming Conventions: The skill identifies material thickness directly from the PDF filenames. Ensure your source files follow a consistent naming convention to guarantee accurate aggregation.
• Data Integrity: The skill includes a built-in self-check function. If the output appears incorrect, run the tool again to trigger the internal validation logic.
• File Paths: Since this tool performs file system operations, ensure the OpenClaw agent has appropriate read/write permissions for both the input directory and the target output path.