How do I avoid double-counting Draft matches in a spreadsheet?
Identify a contest by the league, season, GW and pair of teams, then update that record instead of adding a duplicate view.
FFTQL Draft lookup guideRecognise reversed descriptions
A row labelled A versus B and another labelled B versus A can describe the same matchup from opposite perspectives. Standardise the team-pair representation before aggregating results. Keep correction timestamps on the existing match record so later updates do not become additional matches.
Check the completed-match count against the official history. A duplicated row can distort wins, points and averages even when every copied score is individually accurate.
Practical checks
- Normalise the league, GW and team-pair fields.
- Deduplicate records and reconcile the completed-match count.
Context and sources
The numbers here are worked examples. Check your actual league type and official results when applying them. FFTQL provides a view of public data, which may change as matches finish and the official game updates.