How do I avoid double-counting Draft matches in a spreadsheet?

Xiao K · FFTQL developer ·

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 guide

Recognise 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

  1. Normalise the league, GW and team-pair fields.
  2. 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.

Sources and useful pages