| A | B | C | D | E | F | G | H | |
|---|---|---|---|---|---|---|---|---|
1 | Instructions | Set Abbreviations, Format, and Rotation | Future Features | |||||
2 | 1. Go to File -> Make a Copy to add this sheet to your own Google Drive | IKO | Ikoria: Lair of Behemoths | Standard | Rotates Fall 2021 | Add non-booster cards from THB, ELD, M20, WAR, RNA, GRN, M19, DOM, RIX, and XLN for completeness. | ||
3 | 2. Boxes that are colored light blue are for you to fill in | THB | Theros Beyond Death | Add support for noting whether or not gold or gems were used to pay for draft, calculate gems earned accordingly. | ||||
4 | 3. Boxes that are colored light yellow have formulas in them | ELD | Throne of Eldraine | Add a Flag to count Wildcards as rares/mythic rares for the currently in-progress set, reducing the number of drafts needed accordingly. | ||||
5 | 4. For each set you want to track, fill in the number of rares, mythics, and uncommons you already own | M20 | Magic Core Set 2020 | Standard | Rotates Fall 2020 | |||
6 | 5. Then fill in the number of packs you already own | WAR | War of the Spark | |||||
7 | 6. When you draft, refer to your collection tracker to see which cards you already have four copies of | RNA | Ravnica Allegiance | |||||
8 | 7. Remember to take every rare and mythic rare that you don't already have four copies of | GRN | Guilds of Ravnica | |||||
9 | 8. Put your draft results in the table for the set you're collecting, this will update the formula based on your average performance | M19 | Magic Core Set 2019 | Historic | Non-Rotating | |||
10 | 9. When the number of drafts needed to collect all rares goes down to zero, its time to open up all your packs! | DOM | Dominaria | |||||
11 | 10. At this point you likely will not have a full set of mythic rares, so keep drafting but at least you don't have to take every rare anymore! | RIX | Rivals of Ixalan | |||||
12 | 11. Hold onto your packs again until the mythic rare counter also goes down to zero. You'll finish your mythic rare set and likely have a bunch of gems, wildcards, and maybe even a vault opening! | XLN | Ixalan | |||||
13 | HA1 | Historic Anthology 1 | ||||||
14 | HA2 | Historic Anthology 2 | ||||||
15 | ||||||||
16 | Changelog | |||||||
17 | Version 1.3 (April 2020): Added Ikoria and Historic Anthology 2. Renamed Historic Anthology I to Historic Anthology 1 (Roman Numeral changed to Arabic Numeral) | |||||||
18 | Version 1.2 (January 2020): Added Theros Beyond Death and Historic Anthology I; Color-Coded set tabs based on format and rotation.Added key for set abbreviations and format/rotation colors to Instructions tab. Added changelog to instructions tab.Renamed instructions tab to Introduction. Added future features to introduction. Changed formatting of Introduction tab. Fixed several typos. | |||||||