Assignor

Upload spreadsheets → run algorithm → edit → export

Step 1 — Upload your data

Games

One row per game. Required: id, date, time, location, level.

Referees

One row per referee. Required: id, name, certLevel.

Expected column reference

Games

  • id, date, time, location, level — required
  • refsNeeded — defaults to config value (usually 2)
  • lat, lng — venue coordinates for distance
  • durationMinutes — defaults to 75
  • homeTeam, awayTeam — display only

Referees

  • id, name, certLevel — required
  • lat, lng — home coordinates
  • preferredLocations — comma/semicolon separated
  • preferredLevels — comma/semicolon separated
  • maxGamesPerDay — overrides config default

Header rows are case-insensitive and tolerate spaces/underscores. CSV, XLSX, and XLS are all accepted.