Swiss Event

In a Swiss Event there is no pre-determined order of play beyond Round 1, rather the game-pairings are determined by team rankings as the event progresses. So the cream will soon rise to the top, and at some stage you may need to decide whether 2 players or teams can play each other more than once.

Begin by gathering the entries on an Entries sheet and initialising as many rounds as you think you might need.

Delete the masterdata (in the grey columns) for round 2 onwards.

Don't delete the formulas in the purple columns. To toggle formula display on/off go Control backtick Ctrl+`.

Run the Pool play job Sort all pools by rank to set column A to the pool rank.

Swiss1

After round 1 sort the pool by column A and pair off from the top.

Swiss2

After round 2 do the same.

Swiss3

And after round 3.

Swiss4

After the set number of rounds you are almost certainly guarenteed to have a clear winner.

Swiss5

The equivalent eliminatory event format is Lives Ranking Play.