Vintage Champs 2019
 Share
The version of the browser you are using is no longer supported. Please upgrade to a supported browser.Dismiss

Comment only
 
 
ABCDEFGHIJKLMNOPQRSTUVWXYZAAABACADAEAFAGAHAIAJAKALAMANAO
1
List of ArchetypesList of Tags
(as many as you want)
2
Under "Players and Wins", enter the username of every player alphabetically.
ShopsTaxing
Sphere of Resistance, Thorn of Amethyst, Thalia, Guardian of Thraben
List of Archetypes
ShopsEldraziDredgeBUGOathPOXeroxComboOther BlueLandsSurvivalOther
3
Click the "Name" field in the event on MTGO to sort the list of players alphabetically.
EldraziEldrazi
Thought-Knot Seer, Reality Smasher, Eldrazi Displacer
List of TagsTaxingEldraziFOWOkoDrainOathBudgetShopsStormDredgeFastbondFOVNull RodTinkerRavagerPONarsetArcanistMystic SancBazaar
4
Don't delete *BYE*
DredgeFOWForce of Will
5
The list of usernames (excluding *BYE*) will popular to each swiss round sheet.
BUGOkoOh, yOko!
6
OathDrainMana Drain
7
While the tournament is going on (if you have time):
POOathOath of Druids
8
Enter the results from each round:
XeroxBudget
No Moxen, Black Lotus, Bazaar of Baghdad, Mishra's Workshop, Time Walk, or Ancestral
9
Enter the username of each player's opponent.
ComboShopsMishra's Workshop
10
In the "Result" field, enter 0 for a loss and 1 for a win.
Other BlueStorm
Tendrils of Agony, Empty the Warrens
11
Do not enter anything for the "Archetype", "Subarchetype", or "Tags" fields; these will be autofilled later.
LandsDredge
Bazaar of Baghdad and Golgari Grave Troll
12
If a player received a bye, enter their opponent as *BYE* and leave the result blank.
SurvivalFastbondFastbond
13
If it's clear a player was a no show, leave the result for both them and their opponent blank.
OtherFOVForce of Vigor
14
Check the wins and losses in K2-L2 to ensure # of wins is equal to # of losses
Null Rod
Null Rod, Stony Silence, Ouphe
15
Enter results from the top8 similar to the swiss rounds.
TinkerTinker
16
RavagerArcbound Ravager
17
Once the tournament finishes:
POParadoxical Outcome
18
Enter results from any rounds you haven't yet entered.
Narset
Leovold, Emissary of Trest or Narset, Parter of Veils
19
Watch replays to determine the appropriate archetype, deck name, and tags for each player's deck who is below top 32 (top 32 gets posted by WOTC).
ArcanistDreadhorde Arcanist
20
***When exiting a replay, use the reverse arrow in the bottom left. Closing the window can lock you out of viewing more replays.
Mystic SancMystic Sanctuary
21
Your archetype and tags don't need to be from the list on this sheet--they are merely what we used in one tournament. Feel free to leave them as they are though.
BazaarBazaar of Baghdad
22
Tags should be comma separated (e.g. "Taxing, Shops, Ravager")
23
If after watching a few replays you are still unsure about some tags (e.g. you cannot tell if an eldrazi deck plays null rod), note that in the F column.
24
Decks names are optional
25
After watching enough replays, I'll look at what people played and adjust the list of archetypes and tags if necessary.
26
***Adjust archetype and tags on this sheet. Everywhere else will auto update using formulas.
27
Try to keep the number of archetypes to exactly 9. Archetypes and tags with 0 decks in them are fine.
28
If you increase the total number of tags let us know because we need to quickly update a couple formulas.
29
Increasing the total number of archetypes is more annoying to rework.
30
31
Check for Errors:
32
Look through the round sheets. Check if an opponent's archetype/tags are filled out. Probable fix: if missing, opponent's name was probably mistyped.
33
When going through the round sheets, double check the wins and losses in K2-L2 to ensure # of wins is equal to # of losses.
34
Under "Player and Wins" the S column should be "TRUE" for each player. Probable fix: if "FALSE", one of that player's opponents' archetypes is not on the list of archetypes on this sheet.
35
Under "Archetype and Subarchetype Breakdown", X11 (total wins) should equal Y11 (total losses)
36
Also on this sheet, check that the win% matrix makes sense. For example, H14 plus B20 should sum to 100%, since (shops vs. mentor win%)+(mentor vs. shops win%) = 100%
37
Finding where errors on the "Archetype and Subarchetype Breakdown" come from is usually more difficult. If you can't find the source let one of us know it exists and we can help.
38
39
Notes:
40
Other than the copying in the initial step, avoid copy/pasting and dragging values. This often messes up the formulas and leads to difficult to find errors. Instead, enter everything manually.
41
Look at "Players and Wins" and "Round 1" for examples
42
We're currently not using subarchetypes.
43
Decklists for the top32 players will be eventually posted by WOTC.
44
Therefore, if you're short on time the essential information is the round by round results and the information for players' decks not finishing in the top 32.
45
You need to enter the P9 to see the replays, but anyone can view the round by round results. If you aren't playing but are willing to help, entering in the round results would be very helpful.
46
47
Thank you for your help!
48
49
50
51
52
53
54
55
56
57
58
59
60
61
62
63
64
65
66
67
68
69
70
71
72
73
74
75
76
77
78
79
80
81
82
83
84
85
86
87
88
89
90
91
92
93
94
95
96
97
98
99
100
Loading...