ABCDEFGHIJKLMNOPQRSTUVWXYZAAABACADAEAFAGAHAIAJAKALAMANAOAPAQARASATAUAVAW
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)QDPDTDGem-cost details (don't change all this)QDPDTD
Gems paid details (don't change all this)
QDPDTD
2
Action News CrewCW01614Number 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.412.112.0
0: We need to know the gems you will gain per draft. It is equal to the product of:
347820794
3
Agent Bishop, Man in BlackRW021364
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
Anchovy & Banana PizzaCB05774121Can I start opening packs?
No, keep drafting
yes/no:no Rares gained from packs: 2 Probability of each possible result: 2
5
April O'Neil, HacktivistRU02945116
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.110.1 … of 0 wins6613
6
April O'Neil, Kunoichi TraineeCW03715Rare Completion: to finish off your missing rares. Prefab data from BtM or me4.310.110.1 … of 1 win191994
7
April, Reporter of the WeirdUU0303570Quick drafts remaining before opening packs:34
No: you want to use those wildcards for something else (Historic, completing
A specific number you defined4.010.010.0 … of 2 wins3847375
8
Armaggon, Future SharkRB05884179 Cost of those quick draft:13693 Standard sets you missed, etc). Data from your own previous runs: 3 … of 3 wins47156313
9
Baxter StockmanUUR0139151160
Premier drafts remaining before opening packs:
151a: This is then modified by current set completion:4.310.110.1 … of 4 wins53164
10
Bebop & RocksteadyRBG0140157103 Cost of those premier drafts:10207
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.12.01.9 … of 5 wins53131
11
Bebop, Warthog WarriorCB05980148
Traditional drafts remaining before opening packs:
15 data source:1 Rares per pack: 4 … of 6 wins4698
12
Bespoke BōUU0313671 Cost of those traditional drafts:10594
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 wins85198
13
Bot Bashing TimeCR085101127Packs to buy if you do not want to draft:220
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!1: Gems earned from each possible result (from the client):
Number of drafts with each possible result:
14
Brilliance UnleashedUUR0141153173 Cost of those packs:44000
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 wins5050100 … 0 wins000
15
Broadcast TakeoverMR086106151Packs to buy (if you are getting Golden Packs):147-184 blue boxes to the right.10
Rares seen per PD
You want to combine this set's data with previous sets': 7 … 1 win100100250 … 1 win000
16
Buzz BotsCU0323121 Cost of those packs:29400-36800
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.820.820.82 … 2 wins2002501000 … 2 wins000
17
Casey Jones, Jury-Rig JusticiarUR0878534 recorded in this spreadsheet, to predict the Wildcards are saved for use in other sets0.820.820.82 … 3 wins30010002500 … 3 wins000
18
Casey Jones, VigilanteRR0889686Set statistics:
to predict the rares and mythics in future runs.
Wildcards are spent on this set1.001.001.00 … 4 wins4501400 … 4 wins00
19
Chrome DomeRC017217859 Win rate, quick draft:No drafts yet5: The number of packs earned per draft is the product of:1.32.52.4 … 5 wins6501600 … 5 wins00
20
Cool but RudeRR0898635 Win rate, premier draft:No drafts yet
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 wins8501800 … 6 wins00
21
Courier of ComestiblesUG011211545 Win rate, traditional draft:No drafts yet
Do you expect to see the same number of rares and mythics in PD as in TD?
Probability of each possible result: 9 … 7 wins9502200 … 7 wins00
22
Cowabunga!CG011311210 Gems spent on draft:0 yes/no:yes … from 0 wins0.150.130.132: Probability of each possible result:
23
Crustacean CommandoCU0333222
Do you want to use your data from previous sets, or only use the data from this set?
… from 1 win0.230.190.38 … of 0 wins13%13%13%Gems paid for those drafts
24
Dark Leo & ShredderMWB014214051Current Set Completion:
Combine this set's data with previous sets' data?
yes … from 2 wins0.230.381.13 … of 1 win19%19%38% … 0 wins000
25
Death in the FamilyUB0615925 Cards in set:190 … from 3 wins0.200.310.75 … of 2 wins19%19%38% … 1 win000
26
Dimension XCWR0183169186 Cards in collection:0
How will you figure out how many wins you will get in your average draft?
… from 4 wins0.150.35 … of 3 wins16%16%13% … 2 wins000
27
Dimensional ExileUW04816 Proportion of cards with 1+ copy:0% data source:1 … from 5 wins0.110.33 … of 4 wins12%12% … 3 wins000
28
Does MachinesRU0343323 Proportion of cards with 4 copies:0%
1: Use specific numbers that you will put in the
50%
QD win percent (games)
… from 6 wins0.080.27 … of 5 wins8%8% … 4 wins00
29
Don & Leo, Problem SolversRWU0143139159Total set completion:0% blue boxes to the right.50%
PD win percent (games)
… from 7 wins0.180.54 … of 6 wins5%5% … 5 wins00
30
Don & Raph, Hard ScienceRUR0144149101
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! … of 7 wins9%9% … 6 wins00
31
Donatello's TechniqueUU0393772Mythics in set:15 recorded in this spreadsheet, to predict your Data from Premier and Traditional drafts are combined: 10 … 7 wins00
32
Donatello, Gadget MasterRU0353873 Mythic cards in collection:0 wins in future runs. Data from Premier and Traditional drafts are separate: 11
33
Donatello, Mutant MechanicMU03646117 Proportion of mythics with 1+ copy:0%7: Rares per draft, calculated from all sets' data, depends on:#DIV/0!#DIV/0!#DIV/0!Gems earned by those drafts
34
Donatello, Turtle TechieCU03747118 Proportion of mythics with 4 copies:0%
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 wins000
35
Donatello, Way with MachinesUU0383974Mythic completion:0%
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 win000
36
Dream BeaversUB062578
Combine this set's data with previous sets' data?
yes8: Number of packs earned in each possible result: … 2 wins000
37
EPF Point SquadCWR0145166105Rares in set:53
Do you think your win percent in PD is different from QD?
… from 0 wins1.211 … 3 wins000
38
East Wind AvatarCW0519110 Rare cards in collection:0 yes/no:no … from 1 win1.2211 … 4 wins00
39
Escape TunnelCC0184188188 Proportion of rares with 1+ copy:0%
Yes: choose this if you think that your winning percentage is different AND you have
… from 2 wins1.2423 … 5 wins00
40
Everything PizzaUC017317960 Proportion of rares with 4 copies:0%
a lot of data for both draft types (5+ drafts of each).
… from 3 wins1.2626 … 6 wins00
41
Featherbrained FilcherUW0611Rare completion:0% No: choose this otherwise. … from 4 wins1.33 … 7 wins00
42
Foot EliteCWB014614197
Do you think that your win percent in Bo1 is dfferent from Bo3?
… from 5 wins1.354
43
Foot HeadquartersCWB0185146183Uncommons in set:55 yes/no:no … from 6 wins1.45
44
Foot MysticCB06375122 Uncommon cards in collection:0
Yes: choose this if you think that they are different, AND you have a lot of data for
… from 7 wins26
45
Foot NinjasCWB0147145171 Proportion of uncommons with 1+ copy:0% both Bo1 and Bo3 (5+ drafts of each).
9: Probability of each possible result is estimated from your win percentage: 14
46
Frog ButlerCG011411646 Proportion of uncommons with 4 copies:0% No: choose this otherwise. … of 0 wins13%13%13%
47
Fugitive DroidUU040296Uncommon completion:0% … of 1 win19%19%38%
48
General Traag, Heart of StoneUR090107152Set-specific details: … of 2 wins19%19%38%
49
Genghis FrogUUG014817158Commons in set:67 Rare:mythic ratio in packs8.066666667 … of 3 wins16%16%13%
50
Go Ninja GoUWR014916455 Common cards in collection:0
Probability of opening a R/M wildcard in a pack
0.03333333333 … of 4 wins12%12%
51
Groundchuck & DirtbagRG0115135169 Proportion of commons with 1+ copy:0% … of 5 wins8%8%
52
Grounded for LifeCW0725142 Proportion of commons with 4 copies:0%Rare Drafting NumbersQDPDTD … of 6 wins5%5%
53
Guac & Marshmallow PizzaCG011611311Common completion:0% Rares still needed in collection212212212 … of 7 wins9%9%
54
Hamato Guardian StanceCW0822 Rares in packs33333310: This set's rares per draft, premier and traditional numbers combined:#DIV/0!#DIV/0!#DIV/0!
55
Hard-Won JitteUR0918736 Rares still needed via draft17917917911: This set's rares per draft, premier and traditional numbers separate:#DIV/0!#DIV/0!#DIV/0!
56
HenchbotsUC0174185141 Drafts of that type remaining34151512: Rares per draft, from all sets' data, PD/TD combined#DIV/0!#DIV/0!#DIV/0!
57
High-Flying AceCW091465 Costs of those drafts:13693102071059413: Rares per draft, from all sets' data, PD/TD separate#DIV/0!#DIV/0!#DIV/0!
58
Ice Cream KittyCBG01501565414: Source of the single winning percentage used to predict results:50%50%50%
59
Illegitimate BusinessCBG0186162185Pack Buying NumbersNumberCost A specific number you defined50%50%50%
60
Improvised ArsenalRR0928837 Packs needed (ignoring Golden)22044000 You only want to use the data from this set: 15
61
Insectoid ExterminatorCB0646880 Packs needed (Golden best-case)14729400 You want to combine this set's data with previous sets': 16
62
Jennika's TechniqueUR0939787 Packs needed (Golden worst-case)1843680015: The win rate from this set depends on:#DIV/0!#DIV/0!#DIV/0!
63
Jennika, Bad Apple Big SisterCW01026143 You want to separate Bo1 and Bo3: 17
64
Karai's TechniqueUWB015214298Gems Spent NumbersQDPDTD You want to combine Bo1 and Bo3#DIV/0!#DIV/0!#DIV/0!
65
Karai, Future of the FootUWB015114399 Drafts done00016: The win rate from all sets combined depends on:#DIV/0!#DIV/0!#DIV/0!
66
Kitsune's TechniqueRU04253165 Gems spent per draft000 You want to separate Bo1 and Bo3: 18
67
Kitsune, Dragon's DaughterRU04154166 Total gems spent000 You want to combine Bo1 and Bo3#DIV/0!#DIV/0!#DIV/0!
68
Koya, Death from AboveUW011156617: Win rate from this set, Bo1/Bo3 separate, depends on:#DIV/0!#DIV/0!#DIV/0!
69
Krang & ShredderRUB0153147172 You want to separate QD from PD#DIV/0!#DIV/0!#DIV/0!
70
Krang, Master MindRU04356178 You want to combine QD and PD#DIV/0!#DIV/0!#DIV/0!
71
Krang, Utrom WarlordMC017518718018: Win rate from all sets, Bo1/Bo3 separate, depends on:#DIV/0!#DIV/0!#DIV/0!
72
Leader's TalentRW013917 You want to separate QD from PD: 43#DIV/0!#DIV/0!#DIV/0!
73
Leatherhead, Swamp StalkerRG0117127132 You want to combined QD from PD: 44#DIV/0!#DIV/0!#DIV/0!
74
Leonardo's TechniqueRW01820111
75
Leonardo, Big BrotherCW0141667
76
Leonardo, Cutting EdgeRW0151018
77
Leonardo, Leader in BlueUW01633
78
Leonardo, Sewer SamuraiMW01721112
79
Lessons from LifeUUG0155173139
80
Lita, Little Orphan AmphibianUW0191119
81
Lord Dregg, Insect InvaderUB06576123
82
Madame Null, Power BrokerRB0666981
83
Make Your MoveCW0201768
84
Manhole MissileCR0948938
85
Mechanized Ninja CavalryCWR015616556
86
MetalheadUU04450145
87
Michelangelo's TechniqueRG0122132156
88
Michelangelo, Game MasterCG011812191
89
Michelangelo, ImproviserMG0119128133
90
Michelangelo, Mutant BFFUG0120129134
91
Michelangelo, Weirdness to 11RG012111747
92
Mighty MutanimalsUW02122113
93
Mikey & Don, Party PlannersRUG0157174140
94
Mikey & Leo, Chaos & OrderRWG015817057
95
Mind Transfer ProtocolCU0454075
96
Mona Lisa, Science GeekUG012312292
97
Mondo GeckoMU0464176
98
Mouser Attack!CR0959039
99
Mouser FoundryCR0969140
100
Mouser Mark IIICUR015914852