Link to old formula's in the above sheet. Warning: Cards are no longer being updated, you will have to add these yourself.
UPDATE: Version 2 is now complete. Link has been updated.
Hello everyone,
I made a little spreadsheet to help me calculate which card set has the highest number of cards missing to simplify which deck, gvg or classic, I should buy in order to get the highest possible chance for new cards.
Also, because I'm a completionist and want to have every card in the game at some point :P
I figured I'd share it with everyone!
You can simple download the document at this link, and then start 'striping off' the cards you already have, to see how many cards you're missing, and which you still need. There's a little percentage box that tells you your completion level per set.
IMPORTANT NOTE ON FORMULAS! The new formulas do not work with every spreadsheet program. Therefor, if you decide to download the spreadsheet in any format, first see if the formulas work (they are in row 276, 425 and 575) if not, download the old version, and use that instead. The best idea is to simply make an online copy of the document to use for your own.
Changelog: - New boxes showing total number of cards - New top UI for quicker view - Added TGT cards - New formula's for determining which packs are best, now even more accurate by excluding duplicates.
Great feedback, I think dust might be a better way to calculate how much you really still need. So I added a dust line below the total card line calculating the amount of dust required per rarity, total and a percentage of total dust for both classic and gvg.
Rollback Post to RevisionRollBack
Worlds "bestest" collectors spreadsheet, download at your leisure:
Thank you for sharing! Using it. Found some small typos you may want to know about.
BloodKnight = Blood Knight
Hemit Nesingwary = Hemet Nesingwary
BTW: Adding dust total was a bad idea. I was thinking I had a decent collection until I saw how much dust I need to complete it! OUCH!!!! :) :)
May be a good idea: Subtotal for each classes. You have to look at two places to find how many cards you're missing for a particular class. Basically, adding 9 lines with total for GvG +Classic, so you know how many cards you're missing for each classes.
Thank you very much for this, I actually wrote my data from the classic packs down two days ago and thought how great it would be to have it all in excel. I assume "golden dust" is there for people who make a second version of this about their golden cards?
Ye, I could've added a second page by copy pasting the whole thing for your gold collection, and maybe I should, but in general I added it for those who want an excel for their golden collection progress, so you can just use a second copy, and stripe off only your golden cards. I have to say, very daunting task, especially when you see the dust numbers haha :P 667200! dust and that's excluding the golden naxx cards which are only craftable also.
I'll probably add a golden sheet later, but this was a simple quick fix for the whole thing :)
Glad you enjoy it!
Rollback Post to RevisionRollBack
Worlds "bestest" collectors spreadsheet, download at your leisure:
I figure to be as dust efficient as possible, I'll only craft golden Naxxramas cards for the time being. Since there's always the chance of getting non-Naxx golden cards through other means, this is probably the best route.
yep, and after thatthe best route is to open packs consistently until you have the exact amount of dust required to craft what you are missing, to avoid getting doubles by crafting :p
Rollback Post to RevisionRollBack
Worlds "bestest" collectors spreadsheet, download at your leisure:
+ a propability "you have a xx% chance to get sth useful on you next pack" statistic would be awesome
+ maybe, but I dont know if you can do this in excel: if I highlight some cards with green (cards that I really want, like say Dr Boom) or if I highlight some cards in red (cards I dont need, say Whisp), show me all the same statistics, but only about cards with greens, or all but without red, etc
"Hence: if you wish to maximize the chances on new cards when buying packs, buy the packs of which you miss the highest % of cards!"
is just wrong I guess?
If I miss 10% of classic set,but they are all common and miss 10% of GvG but they are all legendary, that aint the same, right? The chance of a new card is way higher with classic packs, since there are ~3,5 commons per pack, but only 1/20 legendary per pack.
Vinotan, that's a lot of replies :P Glad that you are thinking with me.
I added a legend, which I hope is sufficient.
As for your second suggestion, adding a way that if you highlight cards, you know the chance to get them in a pack: I have no idea if that is possible in Excel. I do know that those calculations are going to be pretty immense to put in :P I do not have the know how to do so. If you find someone that does, or figure it out yourself I would be happy to update the sheet with those neat features.
As for the %'something useful' in next pack, it's pretty accurate if you look at it the right way. I agree that the total combined numbers, i.e. you only need 53% more of the cards for full collection are a bit misleading, however below each column, legendary, epic, rare, uncommon is a % also. These are the percentages you want to be looking at.
If you are missing 75% of the legendary cards, you have infact a 75/100*1.25 = 0.9375% chance to get a legendary card that you are missing when opening a pack (and 0.3125% chance that it's one you already have). I wish I could add these numbers correctly, but I do not have the information required. I need to know what the exact chance of a legendary card per pack is, and the exact chance of an epic card per pack. I believe legendary is 1.25% chance, but I'm not sure. Epic I have no idea. It get's even harder for rare and uncommon. I believe it works like this: You are guaranteed at least 1 rare, BUT this 1 rare could also be of higher quality.. so you can get a pack with 1 legendary and 4 uncommon, for example, which means that you do not get a rare card 100% of the time, same for uncommon, but I could be wrong.
I will add a total number at the end calculating the exact numbers you require, of total legendary, underneath both classic, gvg, and 1 table that combines the two at the bottom.
Rollback Post to RevisionRollBack
Worlds "bestest" collectors spreadsheet, download at your leisure:
I also noticed a small flaw, which I corrected in the classic percentage calcs, that was only calculating the total percent of neutrals (ignoring class cards) /sadface
but it's fixed now! /happyface
Rollback Post to RevisionRollBack
Worlds "bestest" collectors spreadsheet, download at your leisure:
Using Californ1a's collected data from opening 1143 packs when I crunched the numbers and a post that apparently states from Blizzard how packs are (mostly) generated, this happens for every pack you open:
Randomly generate a non-gold common
Give it a 1 in 5 chance of being turned instead into a non-gold rare
If now a rare, give it a 1 in 5 chance of being turned instead into a non-gold epic
If now an epic, give it a 1 in 5 chance of being turned instead into a non-gold legendary
Now determine if it should be turned into a gold version of the card, using this chart: Odds of being promoted to golden: Common: 1 in 50 Rare: 1 in 20 Epic: 1 in 15 Legendary: 1 in 10
Repeat steps 1-6 four more times to make 5 cards in a pack. If, after doing this, all cards are common, turn a random card into a rare and go to step 3) for it."
RAYMAN taking over PROJECT:
new formula's
https://docs.google.com/spreadsheets/d/1dX1-sQD3UVNvk5_AfjtIMzaydii4TXDfnlKVvB_Px20/edit#gid=191287612
Link to old formula's in the above sheet. Warning: Cards are no longer being updated, you will have to add these yourself.
UPDATE:
Version 2 is now complete. Link has been updated.
Hello everyone,
I made a little spreadsheet to help me calculate which card set has the highest number of cards missing to simplify which deck, gvg or classic, I should buy in order to get the highest possible chance for new cards.
Also, because I'm a completionist and want to have every card in the game at some point :P
I figured I'd share it with everyone!
You can simple download the document at this link, and then start 'striping off' the cards you already have, to see how many cards you're missing, and which you still need. There's a little percentage box that tells you your completion level per set.
IMPORTANT NOTE ON FORMULAS!
The new formulas do not work with every spreadsheet program. Therefor, if you decide to download the spreadsheet in any format, first see if the formulas work (they are in row 276, 425 and 575) if not, download the old version, and use that instead.
The best idea is to simply make an online copy of the document to use for your own.
The following versions are outdated!
Version with new formulas:
https://docs.google.com/spreadsheets/d/1rZobj5ALRs_7X4tH40Sx1g2h5QexptLifeeobAjorJw/edit?usp=sharing
Version with older formulas:
https://docs.google.com/spreadsheets/d/1GhqNiBv453OozFX3Fts6orc3wH5sfMmmkNPCjM7nfoE/edit#gid=191287612
Enjoy!
Kind regards,
-BHTrix
Changelog:
- New boxes showing total number of cards
- New top UI for quicker view
- Added TGT cards
- New formula's for determining which packs are best, now even more accurate by excluding duplicates.
Worlds "bestest" collectors spreadsheet, download at your leisure:
version 2.1 with a big thanks to Rayman001:
https://docs.google.com/spreadsheets/d/1dX1-sQD3UVNvk5_AfjtIMzaydii4TXDfnlKVvB_Px20/edit#gid=191287612
Great feedback, I think dust might be a better way to calculate how much you really still need. So I added a dust line below the total card line calculating the amount of dust required per rarity, total and a percentage of total dust for both classic and gvg.
Worlds "bestest" collectors spreadsheet, download at your leisure:
version 2.1 with a big thanks to Rayman001:
https://docs.google.com/spreadsheets/d/1dX1-sQD3UVNvk5_AfjtIMzaydii4TXDfnlKVvB_Px20/edit#gid=191287612
:o thanks
fixed that :p
Worlds "bestest" collectors spreadsheet, download at your leisure:
version 2.1 with a big thanks to Rayman001:
https://docs.google.com/spreadsheets/d/1dX1-sQD3UVNvk5_AfjtIMzaydii4TXDfnlKVvB_Px20/edit#gid=191287612
Fixed another small issue where at classic set it wouldn't calculate dust from class cards, it's now fixed.
Worlds "bestest" collectors spreadsheet, download at your leisure:
version 2.1 with a big thanks to Rayman001:
https://docs.google.com/spreadsheets/d/1dX1-sQD3UVNvk5_AfjtIMzaydii4TXDfnlKVvB_Px20/edit#gid=191287612
Thank you for sharing! Using it. Found some small typos you may want to know about.
BloodKnight = Blood Knight
Hemit Nesingwary = Hemet Nesingwary
BTW: Adding dust total was a bad idea. I was thinking I had a decent collection until I saw how much dust I need to complete it! OUCH!!!! :) :)
May be a good idea: Subtotal for each classes. You have to look at two places to find how many cards you're missing for a particular class. Basically, adding 9 lines with total for GvG +Classic, so you know how many cards you're missing for each classes.
Added the totals besides the normal totals for both Classic and GvG combined, also added on the bottom
total dust requirements for both classic and GvG combined, to scare you even more :P
mwhahaha
but ye, I need 19% of classic cards, but they are 56% of the dust >.< hehe
Worlds "bestest" collectors spreadsheet, download at your leisure:
version 2.1 with a big thanks to Rayman001:
https://docs.google.com/spreadsheets/d/1dX1-sQD3UVNvk5_AfjtIMzaydii4TXDfnlKVvB_Px20/edit#gid=191287612
Fixxed the spelling errors too, thanks :>
Worlds "bestest" collectors spreadsheet, download at your leisure:
version 2.1 with a big thanks to Rayman001:
https://docs.google.com/spreadsheets/d/1dX1-sQD3UVNvk5_AfjtIMzaydii4TXDfnlKVvB_Px20/edit#gid=191287612
Thank you very much for this, I actually wrote my data from the classic packs down two days ago and thought how great it would be to have it all in excel. I assume "golden dust" is there for people who make a second version of this about their golden cards?
Ye, I could've added a second page by copy pasting the whole thing for your gold collection, and maybe I should, but in general I added it for those who want an excel for their golden collection progress, so you can just use a second copy, and stripe off only your golden cards. I have to say, very daunting task, especially when you see the dust numbers haha :P 667200! dust and that's excluding the golden naxx cards which are only craftable also.
I'll probably add a golden sheet later, but this was a simple quick fix for the whole thing :)
Glad you enjoy it!
Worlds "bestest" collectors spreadsheet, download at your leisure:
version 2.1 with a big thanks to Rayman001:
https://docs.google.com/spreadsheets/d/1dX1-sQD3UVNvk5_AfjtIMzaydii4TXDfnlKVvB_Px20/edit#gid=191287612
I updated the sheet,I added a second page for the golden cards.
This page also includes all craftable golden Naxxramas cards.
the numbers are daunting :D
enjoy!
https://docs.google.com/spreadsheets/d/1VZ7ThgAk9_gG_rUtCNRqx9OeDecinkJnZenpYrSW4ec/edit?usp=sharing
Worlds "bestest" collectors spreadsheet, download at your leisure:
version 2.1 with a big thanks to Rayman001:
https://docs.google.com/spreadsheets/d/1dX1-sQD3UVNvk5_AfjtIMzaydii4TXDfnlKVvB_Px20/edit#gid=191287612
Very daunting indeed! Thanks for this!
I figure to be as dust efficient as possible, I'll only craft golden Naxxramas cards for the time being. Since there's always the chance of getting non-Naxx golden cards through other means, this is probably the best route.
^_^
yep, and after thatthe best route is to open packs consistently until you have the exact amount of dust required to craft what you are missing, to avoid getting doubles by crafting :p
Worlds "bestest" collectors spreadsheet, download at your leisure:
version 2.1 with a big thanks to Rayman001:
https://docs.google.com/spreadsheets/d/1dX1-sQD3UVNvk5_AfjtIMzaydii4TXDfnlKVvB_Px20/edit#gid=191287612
thank you very much for this !
maybe note what the numbers mean. I needed quite some time to get that the last (green) column is classic + gvg.
+ a propability "you have a xx% chance to get sth useful on you next pack" statistic would be awesome
+ maybe, but I dont know if you can do this in excel:
if I highlight some cards with green (cards that I really want, like say Dr Boom) or
if I highlight some cards in red (cards I dont need, say Whisp), show me all the same statistics, but only about cards with greens, or all but without red, etc
"Hence: if you wish to maximize the chances on new cards when buying packs, buy the packs of which you miss the highest % of cards!"
is just wrong I guess?
If I miss 10% of classic set,but they are all common and miss 10% of GvG but they are all legendary, that aint the same, right? The chance of a new card is way higher with classic packs, since there are ~3,5 commons per pack, but only 1/20 legendary per pack.
maybe at the end write how many cards total (legendarys, epics, rare and commons) you miss in total, not only in % and dust (gvg + classic)
You're welcome Apple_Of_Sodom.
Vinotan, that's a lot of replies :P
Glad that you are thinking with me.
I added a legend, which I hope is sufficient.
As for your second suggestion, adding a way that if you highlight cards, you know the chance to get them in a pack: I have no idea if that is possible in Excel. I do know that those calculations are going to be pretty immense to put in :P I do not have the know how to do so. If you find someone that does, or figure it out yourself I would be happy to update the sheet with those neat features.
As for the %'something useful' in next pack, it's pretty accurate if you look at it the right way. I agree that the total combined numbers, i.e. you only need 53% more of the cards for full collection are a bit misleading, however below each column, legendary, epic, rare, uncommon is a % also. These are the percentages you want to be looking at.
If you are missing 75% of the legendary cards, you have infact a 75/100*1.25 = 0.9375% chance to get a legendary card that you are missing when opening a pack (and 0.3125% chance that it's one you already have). I wish I could add these numbers correctly, but I do not have the information required.
I need to know what the exact chance of a legendary card per pack is, and the exact chance of an epic card per pack. I believe legendary is 1.25% chance, but I'm not sure. Epic I have no idea. It get's even harder for rare and uncommon. I believe it works like this: You are guaranteed at least 1 rare, BUT this 1 rare could also be of higher quality.. so you can get a pack with 1 legendary and 4 uncommon, for example, which means that you do not get a rare card 100% of the time, same for uncommon, but I could be wrong.
I will add a total number at the end calculating the exact numbers you require, of total legendary, underneath both classic, gvg, and 1 table that combines the two at the bottom.
Worlds "bestest" collectors spreadsheet, download at your leisure:
version 2.1 with a big thanks to Rayman001:
https://docs.google.com/spreadsheets/d/1dX1-sQD3UVNvk5_AfjtIMzaydii4TXDfnlKVvB_Px20/edit#gid=191287612
Ok I've updated the sheet.
I also noticed a small flaw, which I corrected in the classic percentage calcs, that was only calculating the total percent of neutrals (ignoring class cards) /sadface
but it's fixed now! /happyface
Worlds "bestest" collectors spreadsheet, download at your leisure:
version 2.1 with a big thanks to Rayman001:
https://docs.google.com/spreadsheets/d/1dX1-sQD3UVNvk5_AfjtIMzaydii4TXDfnlKVvB_Px20/edit#gid=191287612
about the pack propabilities: I have in mind: epic: ~20% per pack, legendary ~5% per pack, rare ~80% per pack.
lots of math done here:
http://www.reddit.com/r/hearthstone/comments/23mxqq/calculations_for_exact_pack_probabilities_and/
"Want to know more?
Using Californ1a's collected data from opening 1143 packs when I crunched the numbers and a post that apparently states from Blizzard how packs are (mostly) generated, this happens for every pack you open:
Odds of being promoted to golden:
Common: 1 in 50
Rare: 1 in 20
Epic: 1 in 15
Legendary: 1 in 10
Here are some statistics of 15.000 cards
http://i.imgur.com/nNI6ISf.png
Cheers, I'm going to crunch those numbers later today though, I'll update when I have.
Worlds "bestest" collectors spreadsheet, download at your leisure:
version 2.1 with a big thanks to Rayman001:
https://docs.google.com/spreadsheets/d/1dX1-sQD3UVNvk5_AfjtIMzaydii4TXDfnlKVvB_Px20/edit#gid=191287612