AgentSkillsCN

fuel-bill-processor

处理来自 Excel 文件的航空燃油附加费账单。支持自动识别与 Claude 辅助两种模式。能够自动检测表头、匹配各列、解析日期与航线，并通过 API 获取合同编号。适用于处理航空燃油账单、Excel 文件处理，或当用户提及燃油附加费、航空燃油账单，或燃油差价费时使用。

SKILL.md
--- frontmatter
name: fuel-bill-processor
description: Process aviation fuel surcharge bills from Excel files. Supports both automatic detection and Claude-assisted modes. Detects headers, matches columns, parses dates/routes, and fetches contract numbers via API. Use when working with aviation fuel bills, Excel file processing, or when user mentions fuel surcharges,航空燃油账单, or 燃油差价费.

Fuel Bill Processor

Process aviation fuel surcharge bills from Excel files with automatic format detection or Claude-assisted mode.

Processing Workflow

Step 1: Try Automatic Mode First

Always try automatic mode first:

bash
python3 scripts/process.py input_file.xls [-o output.xlsx]

Step 2: Claude-Assisted Mode (Only if Step 1 Fails)

Use when auto mode fails (header beyond row 15, non-standard columns, complex structure).

  1. •

    Analyze structure:

    bash
    python3 scripts/analyze.py input_file.xls
  2. •

    Execute suggested command:

    bash
    python3 scripts/process.py input_file.xls \
  --header-row 2 --date-column B --route-column C \
  --flight-column D --price-column E

Parameters: --header-row (0-based), --date-column, --route-column, --flight-column, --price-column (column letters like A/B/C or column names).

Step 3: Verify Results

Confirm output file created with expected rows and populated fields.

Configuration

Uses assets/config.json (ready out of the box). See CONFIGURATION.md for details.

Troubleshooting

SymptomSolution
"Column not recognized" warningAdd column name to column_mappings in config.json
"Date parsing failed" errorsAdd format to date_formats array in config
API timeout or empty responseCheck API URL in config, test network connectivity
Output file has fewer rows than expectedInput may have invalid/summary rows being filtered

For complex table issues, run analyze.py to diagnose structure.

References