How regista6/ea-fc-automated-sbc-solving works
Project type and purpose
• This is a Python‐based command-line tool (full-stack only in the sense of input → processing → output) for solving EA FC Squad Building Challenges (SBCs) using integer programming.
• The README makes it clear: it reads club/player data (CSV), applies constraints from input.py, builds a CP-SAT model in optimize.py, runs Google OR-Tools to minimize total cost, and writes the squad to output.xlsx.
File structure
• Top level:
• input.py ‒ defines all SBC constraints (formation, max league, unique country, club, rarity, etc.) and objective settings
• main.py ‒ orchestrates data loading (CSV), preprocessing (filters), kicks off optimization
• optimize.py ‒ contains functions to create each constraint in the CP-SAT model and to solve it
• *.csv ‒ datasets for different clubs or a master input.csv for broad player data
• output.xlsx ‒ final squad result
• requirements.txt, LICENSE, README.md, .gitignore
• No front-end, no web server—purely a local Python pipeline.
• Dependencies controlled via requirements.txt; Google OR-Tools is the core solver.
README for additional insights
• The README walks through how to configure constraints in input.py, which lines to uncomment in optimize.py, and how to run main.py.
• It lists external integration points: a Chrome extension for data download and mentions FutDB API use for large datasets.
Detailed elements
• Configuration Module (input.py)
• Data Layer (pandas + CSV files)
• Preprocessor (main.py filters)
• Constraint Factory (optimize.py functions grouped by type: league, club, rarity, chemistry, etc.)
• OR-Tools CP-SAT Solver
• Output Writer (main.py + openpyxl)
• External Data Source (Chrome extension or API)