OpenSkillIndex← back to search
claude-code

Claude-skill-registry fuel-bill-processor

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 燃油差价费.

install
source · Clone the upstream repo
git clone https://github.com/majiayu000/claude-skill-registry
Claude Code · Install into ~/.claude/skills/
T=$(mktemp -d) && git clone --depth=1 https://github.com/majiayu000/claude-skill-registry "$T" && mkdir -p ~/.claude/skills && cp -r "$T/skills/data/fuel-bill-processor" ~/.claude/skills/majiayu000-claude-skill-registry-fuel-bill-processor && rm -rf "$T"
manifest: skills/data/fuel-bill-processor/SKILL.md
source content

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:

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:

    python3 scripts/analyze.py input_file.xls

  2. Execute suggested command:

    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