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

| Symptom | Solution | |---------|----------| | "Column not recognized" warning | Add column name to column_mappings in config.json | | "Date parsing failed" errors | Add format to date_formats array in config | | API timeout or empty response | Check API URL in config, test network connectivity | | Output file has fewer rows than expected | Input may have invalid/summary rows being filtered |

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

References

• API_REFERENCE.md - Detailed API documentation
• CONFIGURATION.md - Complete configuration guide