ABCDEFGHIJKLMNOPQRSTUVWXYZAAABACADAEAFAGAHAIAJAKALAMANAOAPAQARASATAUAVAWAXAYAZBABBBCBDBE
1
name
rarity
color
number_collected
collector_number
sort_like_collection
sort_like_draft
draft_type
starting_rares
ending_rares
passed_rares
seen_rares
winslosses
notes
Rare-collecting details (don't change all this)QDPDP2CONTDGem-cost details (don't change all this)QDPDP2CONTD
Gems paid details (don't change all this)
QDPDP2CONTD
2
Academic AscentCW02321Number of unopened packs:400
Modelling details (the defaults are all reasonable):
0: We need to know the rares you will gain per draft. It is equal to the sum of:
5.312.07.411.011.9
0: We need to know the gems you will gain per draft. It is equal to the product of:
3478205501686794
3
Aerid KonstrariMRG0121240207
Are you willing to use wild cards gained from packs to complete your collection?
Rares gained in the draft: 1 Gems earned in each possible result: 1
4
Afterthought SentryCC016626797Can I start opening packs?
No, keep drafting
yes/no:no Rares gained from packs: 2 Probability of each possible result: 2
5
Ajani ResoluteMW0195422
Yes: when you do get to opening packs, you'll use the wildcards you get doing that
1: The rares gained in the draft process can be from a number of sources:4.310.16.310.110.1 … of 0 wins6613013
6
Ajani UnrelentingMR0242150239Rare Completion: to finish off your missing rares. Prefab data from BtM or me4.310.16.310.110.1 … of 1 win191938094
7
Ajani's AnguishRR072154259Quick drafts remaining before opening packs:43
No: you want to use those wildcards for something else (Historic, completing
A specific number you defined4.010.06.010.010.0 … of 2 wins38471500375
8
Apex WitchstalkerCB048114237 Cost of those quick draft:17318 Standard sets you missed, etc). Data from your own previous runs: 3 … of 3 wins47156188219313
9
Arcane AmphisbaenaCG09715868
Premier drafts remaining before opening packs:
191a: This is then modified by current set completion:4.310.16.310.110.1 … of 4 wins53164163328
10
Archive ArbiterUC0167276245 Cost of those premier drafts:12929
How will you figure out how many rares and mythics you see in the average draft?
2: The rares gained via packs is equal to the product of:1.01.91.10.91.8 … of 5 wins53131263
11
Arni, Humble ScribeUU021154114
Contender drafts remaining before opening packs:
21 data source:1 Rares per pack: 4 … of 6 wins4698230
12
Arni, Renowned ChampionUR0243139190 Cost of those contender drafts:27595
1: Use prefab data on this. These data come either from Jim Davis' Bronze to Mythic
Number of packs earned per draft: 5 … of 7 wins85198647
13
Artifist AcumenCR07311610
Pick-two drafts remaining before opening packs:
31
series (for player drafts) or from my own drafts (for quick drafts).
3: Data from your own previous runs depends on a number of factors:#DIV/0!#DIV/0!#DIV/0!#DIV/0!#DIV/0!1: Gems earned from each possible result (from the client):
Number of drafts with each possible result:
14
Avatar of Burgeoning EchoesMUG012225795 Cost of those pick-two drafts:10850
2: Use specific numbers that you will put in the
4
Rares seen per QD
You only want to use the data from this set: 6 … 0 wins5050500100 … 0 wins00000
15
Awaken the InfernoCR074145222
Traditional drafts remaining before opening packs:
19 blue boxes to the right.10
Rares seen per PD/con
You want to combine this set's data with previous sets': 7 … 1 win1001001500250 … 1 win00000
16
Bestial IncursionCG098176196 Cost of those traditional drafts:13419
3: Use the data from your own previous runs,
10
Rares seen per TD
4: The rares per pack depends on how you treat wildcards:0.780.780.780.780.78 … 2 wins20025080001000 … 2 wins00000
17
Blazing CrescendoCR07511957Packs to buy if you do not want to draft:290 recorded in this spreadsheet, to predict the6
Rares seen per P2
Wildcards are saved for use in other sets0.780.780.780.780.78 … 3 wins3001000100014002500 … 3 wins00000
18
Blessed GhoulCWB012320016 Cost of those packs:58000
to predict the rares and mythics in future runs.
Wildcards are spent on this set0.960.960.960.960.96 … 4 wins450140013002800 … 4 wins0000
19
Bloodline Recollector // Ancestral Craving
MB0498145Packs to buy (if you are getting Golden Packs):194-2425: The number of packs earned per draft is the product of:1.32.51.41.22.4 … 5 wins65016003200 … 5 wins000
20
BloombruteUWG0124253209 Cost of those packs:38800-48400
If you are using your own draft data, you will need to make a few more decisions.
Number of packs earned in each possible result: 8 … 6 wins85018004200 … 6 wins000
21
Blossom-Blessed Angel // Seed SutureCWG03254210
Do you expect to see the same number of rares and mythics in PD as in TD?
Probability of each possible result: 9 … 7 wins95022007200 … 7 wins000
22
Break Under PressureUB05093126Set statistics: yes/no:yes … from 0 wins0.150.130.250.000.132: Probability of each possible result:
23
Budding InsurgentCG099167147 Win rate, quick draft:No drafts yet
Do you want to use your data from previous sets, or only use the data from this set?
… from 1 win0.230.190.250.000.38 … of 0 wins13%13%25%13%13%Gems paid for those drafts
24
Campus CrierCW04523 Win rate, premier draft:No drafts yet
Combine this set's data with previous sets' data?
yes … from 2 wins0.230.380.190.001.13 … of 1 win19%19%25%19%38% … 0 wins00000
25
Carnivorous Cultivator // EnrootRG010015969 Win rate, traditional draft:No drafts yet … from 3 wins0.200.310.380.470.75 … of 2 wins19%19%19%19%38% … 1 win00000
26
Cast Away DoubtCB05194127 Gems spent on draft:0
How will you figure out how many wins you will get in your average draft?
… from 4 wins0.150.350.380.70 … of 3 wins16%16%19%16%13% … 2 wins00000
27
Chandra's EmberlingCR076130138 data source:1 … from 5 wins0.110.330.66 … of 4 wins12%12%13%12% … 3 wins00000
28
Chandra, Chill of ComplianceMU021255115Current Set Completion:
1: Use specific numbers that you will put in the
50%
QD win percent (games)
… from 6 wins0.080.270.55 … of 5 wins8%8%8% … 4 wins0000
29
Chandra, Torch of DefianceMR0244140191 Cards in set:280 blue boxes to the right.50%
PD win percent (games)
… from 7 wins0.180.541.08 … of 6 wins5%5%5% … 5 wins000
30
Charge the SanctumCWR0125245167 Cards in collection:0
2: Use the data from your own previous runs,
50%
TD win percent (matches)
6: Rares per draft, calculated from this set, depends on:#DIV/0!#DIV/0!#DIV/0!#DIV/0!#DIV/0! … of 7 wins9%9%9% … 6 wins000
31
Clash of ElementsUUR0126217159 Proportion of cards with 1+ copy:0% recorded in this spreadsheet, to predict your50%
P2 win percent (games)
Data from Premier and Traditional drafts are combined: 10 … 7 wins000
32
Codie, Ravenous CodexRC0168272172 Proportion of cards with 4 copies:0% wins in future runs.50%
CON win percent (games)
Data from Premier and Traditional drafts are separate: 11
33
Command the StageUR077131139Total set completion:0%7: Rares per draft, calculated from all sets' data, depends on:#DIV/0!#DIV/0!#DIV/0!#DIV/0!#DIV/0!Gems earned by those drafts
34
Compel BrutalityCG010116070
If you are using your own draft data, you will need to make a few more decisions.
Data from Premier and Traditional drafts are combined: 12 … 0 wins00000
35
CountersculptUU0254334Mythics in set:26
Do you want to use your data from previous sets, or only use the data from this set?
Data from Premier and Traditional drafts are separate: 13 … 1 win00000
36
Craftwork CrusherURG0127241251 Mythic cards in collection:0
Combine this set's data with previous sets' data?
yes8: Number of packs earned in each possible result: … 2 wins00000
37
Craterclaw ColossusMR078152247 Proportion of mythics with 1+ copy:0%
Do you think your win percent will be different in different Bo1 events?
… from 0 wins1.21101 … 3 wins00000
38
Cruel CalculationsRU02656116 Proportion of mythics with 4 copies:0% yes/no:no … from 1 win1.221101 … 4 wins0000
39
Cryotheory AdeptCU0274435Mythic completion:0%
Yes: choose this if you think that your winning percentage is different AND you have
… from 2 wins1.242103 … 5 wins000
40
Curse-Marred DemonRR079141192
a lot of data for the relevant draft types (5+ drafts of each).
… from 3 wins1.262236 … 6 wins000
41
Danitha, Spear of AgonyUB022795128Rares in set:64 No: choose this otherwise. … from 4 wins1.3336 … 7 wins000
42
Danitha, Sword of HopeUW019616102 Rare cards in collection:0
Do you think that your win percent in Bo1 is dfferent from Bo3?
… from 5 wins1.3548
43
Dark Matter ManipulatorRB052787 Proportion of rares with 1+ copy:0% yes/no:no … from 6 wins1.4510
44
Darklight PhoenixMB053105185 Proportion of rares with 4 copies:0%
Yes: choose this if you think that they are different, AND you have a lot of data for
… from 7 wins2612
45
Dedicated CommonsCWR0175248275Rare completion:0% both Bo1 and Bo3 (5+ drafts of each).
9: Probability of each possible result is estimated from your win percentage: 14
46
Denzilore FateholdMWU0128196200 No: choose this otherwise. … of 0 wins13%13%25%13%13%
47
Deserted BeachRUB0176212265Uncommons in set:109 … of 1 win19%19%25%19%38%
48
Desperate FuturescribeUWU0129197201 Uncommon cards in collection:0Set-specific details: … of 2 wins19%19%19%19%38%
49
Diviner of Victory // Unwind HistoryRU028393 Proportion of uncommons with 1+ copy:0% Rare:mythic ratio in packs5.923076923 … of 3 wins16%16%19%16%13%
50
Divining DuelistCU02957117 Proportion of uncommons with 4 copies:0%
Probability of opening a R/M wildcard in a pack
0.03333333333 … of 4 wins12%12%13%12%
51
Draconic VisitorRR080146223Uncommon completion:0% … of 5 wins8%8%8%
52
Eardrum RattlerCR08112058Rare Drafting NumbersQDPDCONP2TD … of 6 wins5%5%5%
53
Edgar, Ancient BloodlordUWB027020180Commons in set:81 Rares still needed in collection256256256256256 … of 7 wins9%9%9%
54
Edgar, Moonlit SovereignUG0257180227 Common cards in collection:0 Rares in packs313131313110: This set's rares per draft, premier and traditional numbers combined:#DIV/0!#DIV/0!#DIV/0!#DIV/0!#DIV/0!
55
Emergency Phytomedic // Seed SutureCWG013024919 Proportion of commons with 1+ copy:0% Rares still needed via draft22522522522522511: This set's rares per draft, premier and traditional numbers separate:#DIV/0!#DIV/0!#DIV/0!#DIV/0!#DIV/0!
56
Emrakul, the Exigent DoomMC01277257 Proportion of commons with 4 copies:0% Drafts of that type remaining431921311912: Rares per draft, from all sets' data, PD/TD combined#DIV/0!#DIV/0!#DIV/0!#DIV/0!#DIV/0!
57
Enlightened ConfidantMW05624Common completion:0% Costs of those drafts:173181292927595108501341913: Rares per draft, from all sets' data, PD/TD separate#DIV/0!#DIV/0!#DIV/0!#DIV/0!#DIV/0!
58
Entrust the SparkRUG013126123414: Source of the single winning percentage used to predict results:50%50%50%50%50%
59
Essence BurnUR08212159Pack Buying NumbersNumberCost A specific number you defined50%50%50%50%50%
60
Extended AbsenceCB054106186 Packs needed (ignoring Golden)29058000 You only want to use the data from this set: 15
61
Extrapolate the ImpossibleRB0558246 Packs needed (Golden best-case)19438800 You want to combine this set's data with previous sets': 16
62
Eye of JaceUC017026620 Packs needed (Golden worst-case)2424840015: The win rate from this set depends on:#DIV/0!#DIV/0!#DIV/0!#DIV/0!#DIV/0!
63
Face YourselfRR083153248 You want to separate Bo1 and Bo3: 17
64
Fatehold AnnexCUB0177213266Gems Spent NumbersQDPDCONP2TD You want to combine Bo1 and Bo3#DIV/0!#DIV/0!#DIV/0!#DIV/0!#DIV/0!
65
Fatehold CharmUWU013219277 Drafts done0000016: The win rate from all sets combined depends on:#DIV/0!#DIV/0!#DIV/0!#DIV/0!#DIV/0!
66
Fatehold Chronologist // Peer ReviewCWU013319378 Gems spent per draft00000 You want to separate Bo1 and Bo3: 18
67
Fateshaper AspirantCW0632212 Total gems spent00000 You want to combine Bo1 and Bo3#DIV/0!#DIV/0!#DIV/0!#DIV/0!#DIV/0!
68
Fblthp, Impossibly LostUU0213453617: Win rate from this set, Bo1/Bo3 separate, depends on:#DIV/0!#DIV/0!#DIV/0!#DIV/0!#DIV/0!
69
Fblthp, Knows the WayUG0258190260 You want to separate QD from PD#DIV/0!#DIV/0!#DIV/0!#DIV/0!#DIV/0!
70
Ferocity of the HuntCBG013423088 You want to combine QD and PD#DIV/0!#DIV/0!#DIV/0!#DIV/0!#DIV/0!
71
Flickering HoundRW072817518: Win rate from all sets, Bo1/Bo3 separate, depends on:#DIV/0!#DIV/0!#DIV/0!#DIV/0!#DIV/0!
72
Flourishing GrappleUG010215513 You want to separate QD from PD: 43#DIV/0!#DIV/0!#DIV/0!#DIV/0!#DIV/0!
73
Formidable CommonsCBG0178234272 You want to combined QD from PD: 44#DIV/0!#DIV/0!#DIV/0!#DIV/0!#DIV/0!
74
Frostbite PyromentalRUR0135218160
75
Fulminous ForteUR084132140
76
Gallia, Tragic HostUB02288347
77
Gallia, the MerrymakerUR024512260
78
GardenizeRG0103168148
79
Garruk, Curse BreakerMG0259181228
80
Garruk, Veiled ButcherMB0229110218
81
Geist of Saint ThaliaUU02144637
82
Generous RevivalUW0817103
83
Germinate RecruitsRW0918104
84
Ghalta the ImmovableUW019736253
85
Ghalta the UnstoppableUG0260189255
86
Gideon the OathlessRB023096129
87
Gideon's MemorialRW0198725
88
Graft SurgeonCW01019105
89
Greenhouse PropagatorCG0104169149
90
Grim RepriserUBR013622285
91
Guiding HydraRW01138258
92
Hall of EchoesRC0179278278
93
Hallway Heckler // Vicious VerseCBR085225161
94
Hapatra, the Desert FangUBG0271233233
95
Hapatra, the Desert FrostUU021566179
96
Haunted RidgeRBR0180228270
97
Heartstring PullerCR086142193
98
Heartwood Crafter // Soul TetherURG010523518
99
Hexhaven BattalionCW01234235
100
Hexhaven Dueling ArenaUC0181279279