ABCDEFGH
1
InstructionsSet Abbreviations, Format, and RotationFuture Features
2
1. Go to File -> Make a Copy to add this sheet to your own Google DriveIKOIkoria: Lair of
Behemoths
StandardRotates
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 inTHBTheros Beyond DeathAdd 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 themELDThrone of EldraineAdd 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 ownM20Magic Core Set 2020StandardRotates
Fall 2020
6
5. Then fill in the number of packs you already ownWARWar of the Spark
7
6. When you draft, refer to your collection tracker to see which cards you already have four copies ofRNARavnica Allegiance
8
7. Remember to take every rare and mythic rare that you don't already have four copies ofGRNGuilds 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 performanceM19Magic Core Set 2019HistoricNon-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!DOMDominaria
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!RIXRivals 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!XLNIxalan
13
HA1Historic Anthology 1
14
HA2Historic 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.