Skip to content
Anthony ERIBON

Projects / Information systems

Forecast ingestion and review

Forecasts arrive in documents whose quantities, schemas and formats keep changing. Columns move, periods switch between rows and headers, and new versions arrive. Fixed ETL mappings are brittle; manually rebuilding planning records is repetitive.

forecast-ingest discovers and extracts documents automatically into a validated draft. A reviewer corrects and approves it before publication; source revisions and previous approvals remain traceable.

Two spreadsheet layouts encode the same forecast with periods in columns or rows. Automatic discovery, deduplication, extraction and validation produce a draft. A human reviews, corrects and approves it before planning rows are published with source and version history.
Automate intake and extraction; keep correction and publication under human review. Fictional document layouts and values. Full size