Oh... Haha. I'm so dumb! ;) I misread your instructions. RTFM, right?
It's very simple! Download the document in your prefered format. You got a card? Select the box and hit backspace, deleting all the content in the box. The numbers will automatically update.
Anyways. Thanks a lot for your help. Amazingly friendly of you that you actually changed the spreadsheet for me.
Woo! Noob question, is there a way to paste over our existing spreadsheet on the new one? I don't want to go through deleting everything again.
With GvG I recall I was able to copy past in the new sections and line things up so it all still worked. May have to check a few of the totals to make sure it works.
Changes: Added card percentages, totals, dust missing at the top of the sheet for clearer view. Thanks to CaioCavalero for the idea. because of this also removed the totals from the bottom. Added totals behind each section for quicker view. And ofcourse - added all the TGT cards!
Hi, thx BHTrix...I don't really care for the percentages the poster above me mentioned (although it would be best if they are correct :P), I just like your spreadsheet for keeping up with what I have and don't have in an easy way...
I just wanted to say I found a spelling error, Mechenical Yeti :P
I would like to comment an error that you are making on calculating the total chance of getting in a pack a card that you are missing.
For example, imagine that someone is begging his/her collection so the chances of getting a missing card of each type are (I have just made up the numbers):
Legendary: 5%
Epic: 20%
Rare: 80%
Common: 60%
According to the spreadsheet, the total chance of getting a missing card, independly of the type, is:
Total chance of getting a missing card: 5%+20%+80%+60%=165% (wrong)
However, this is wrong. These chances are not independent among them so they cannot be added directly. Besides, probabilities should never exceed 100%.
The correct way of calculating that is tho calculate the probabilities of NOT getting a card that you are missing of each tipe, that is, the opposites of the previous probabilities:
Legendary: 100% - 5% = 95%
Epic: 100% - 20% = 80%
Rare: 100% - 80% = 20%
Common: 100% - 60% = 40%
With this, you can calculate the probability of not getting any card that you are missing, that is, the chances of not getting a legendary card AND not getting an epic card AND not getting a rare card AND not getting a common card. To calculate this probability, we have to MULTIPLY.
Total chance of NOT getting a missing card: 95% x 80% x 20% x 40% = 6.08%
The chance of getting a card that you are missing is the opposite of that.
Total chance of getting a missing card: 100% - 6.08% = 95.92% (correct)
I hope that this is helpful.
Thanks for the work done!
You forgot to take into account that a new card pack consists of 5 cards, not 1 card. Hence your first pack has a 499% chance to contain new cards, or... as you will - 5 new cards. With a very small chance that your first pack will get duplicates. Your calculations do not take into account getting multiple new cards from a pack. That said, your way of calculating might be better - however it's still missing a piece of the equation.
Also when you find a card, your chances to get a rare/epic or legendary card, do not go down, they remain the same, however - you now have a small chance to get a double - which needs to be deducted. All in all I think the way it's currently done in my spreadsheet is fairly accurate - accurate enough for sure.
Hi, thx BHTrix...I don't really care for the percentages the poster above me mentioned (although it would be best if they are correct :P), I just like your spreadsheet for keeping up with what I have and don't have in an easy way...
I just wanted to say I found a spelling error, Mechenical Yeti :P
thank you once again, very useful stuff :)
Good spot! thanks! fixed it.
Rollback Post to RevisionRollBack
Worlds "bestest" collectors spreadsheet, download at your leisure:
There's an error with the calculations, I believe. I'm not very good at explaining so bear with me here.
I'll try to explain with an example as it's the easiest and clearest way.
Let's say there are 50 total epics in a set, so 25 different cards, and I'm missing 2. The chance that a pack has an epic I'm missing will always be (2/50 x 23.14)%, which is 0.92% per pack. And that's true, if those two cards are the same, because it's (1/25 x 23.14)%, which is accurate because that's what I'm missing.
But what if the two cards I'm missing are different? Isn't the chance to find a card you're missing in a pack double, which is 1.84%? Because it doesn't matter if you're missing one or two of the same card, the chance to find them is the same (the chance to find them both in a pack is taken into account in 23.14). So each individual card should always count as 2/50, regardless of if you're missing one or two of them. In that line of thought, missing two different cards would be (4/50 x 23.14)=1.84%.
To implement this into excel, you'd have to see it the other way, meaning you'd do the calculations taking into account only one of each card and ignore every bracket that has a duplicate name with another. Or if that's too difficult, make two different lists of cards, A and B that have the same cards, and ask people to delete cards from B first and only take into account A's percentages.
Hopefully you understood what I meant, thanks for reading and keep up the good work!
Mm, wanted to argue with nikos, but thinking about it he may be right. for each individual rolled epic, it's more likely if the cards are different.
I don't think that's true.
The way I've learned it: Say you get 2 epic cards.You roll your first epic card, it has a 1/100 chance to be Brawl, example given. Then you roll your second epic card, does it now have less chance (or as you put it, is it now less likely?, to roll brawl? No, chance is still 1/100.
Mm, wanted to argue with nikos, but thinking about it he may be right. for each individual rolled epic, it's more likely if the cards are different.
I don't think that's true.
The way I've learned it: Say you get 2 epic cards.You roll your first epic card, it has a 1/100 chance to be Brawl, example given. Then you roll your second epic card, does it now have less chance (or as you put it, is it now less likely?, to roll brawl? No, chance is still 1/100.
As for the other post, that -might- be true. It depends on how the game rolls for a card. If the game rolls a random card from all the cards in the game, it's probably true, but I don't think that's how the game rolls for cards. I think when the game rolls for a card, there's 1 copy of each card it rolls through.
Seems way more logical to me, because why would you make the random roll more CPU intensive by doubling it's options, if you can just have it roll through single copies.
That's only specifically in the case when you're rolling two epics, not just one. And consider this. If you're missing two brawls, the first one has to be brawl, and the second has to be brawll, so 1%*1%. But if you'r missing one Brawl and one Crush, then the first one can be either brawl or crush, so 2%, and then the second has te be which ever the first wasnt, which, no matter which is it, is back to 1%. so even rolling two epics, it's twice as likely to get two cards you need if they're different, because there's two permutations. There one way to get two heads, but two ways to get one heads and one tails.
Basically, order doesn't matter, assuming the game doesn't distinguish between the first copy of a card and the second, so missing brawl A and brawl B can only be fulfilled one way, by rolling Brawl, while Missing one brawl and one crush can be fulfilled in two ways.
There's an error with the calculations, I believe. I'm not very good at explaining so bear with me here.
I'll try to explain with an example as it's the easiest and clearest way.
Let's say there are 50 total epics in a set, so 25 different cards, and I'm missing 2. The chance that a pack has an epic I'm missing will always be (2/50 x 23.14)%, which is 0.92% per pack. And that's true, if those two cards are the same, because it's (1/25 x 23.14)%, which is accurate because that's what I'm missing.
But what if the two cards I'm missing are different? Isn't the chance to find a card you're missing in a pack double, which is 1.84%? Because it doesn't matter if you're missing one or two of the same card, the chance to find them is the same (the chance to find them both in a pack is taken into account in 23.14). So each individual card should always count as 2/50, regardless of if you're missing one or two of them. In that line of thought, missing two different cards would be (4/50 x 23.14)=1.84%.
To implement this into excel, you'd have to see it the other way, meaning you'd do the calculations taking into account only one of each card and ignore every bracket that has a duplicate name with another. Or if that's too difficult, make two different lists of cards, A and B that have the same cards, and ask people to delete cards from B first and only take into account A's percentages.
Hopefully you understood what I meant, thanks for reading and keep up the good work!
Oh I see what you're thinking.
You're saying that if I miss Brawl and Shield Slam, and there's 100 different epic cards, that now you have a 2% chance to get a card you're missing. But when I miss Brawl x2, and there's 100 different epic cards, that now I have a 1% chance to get a card I'm missing
Could be true, but I don't think I can ignore same named fields.
Also, I think the discrepancy is incredibly marginal.
Thirdly it's not true for legendary cards, since you can only obtain 1 of them.
If you figure out the formula to fix it I will add it. I'm not going to add multiple rows and make the sheet more complicated - less user friendly, to fix a discrepancy of 1%.
Also, if you really want to break your brain - here's a fun one for you.
What's the chance that after getting 98 epic out of 100 epic cards, you are left missing 2x the same card, instead of 2 different cards?
There's an error with the calculations, I believe. I'm not very good at explaining so bear with me here.
I'll try to explain with an example as it's the easiest and clearest way.
Let's say there are 50 total epics in a set, so 25 different cards, and I'm missing 2. The chance that a pack has an epic I'm missing will always be (2/50 x 23.14)%, which is 0.92% per pack. And that's true, if those two cards are the same, because it's (1/25 x 23.14)%, which is accurate because that's what I'm missing.
But what if the two cards I'm missing are different? Isn't the chance to find a card you're missing in a pack double, which is 1.84%? Because it doesn't matter if you're missing one or two of the same card, the chance to find them is the same (the chance to find them both in a pack is taken into account in 23.14). So each individual card should always count as 2/50, regardless of if you're missing one or two of them. In that line of thought, missing two different cards would be (4/50 x 23.14)=1.84%.
To implement this into excel, you'd have to see it the other way, meaning you'd do the calculations taking into account only one of each card and ignore every bracket that has a duplicate name with another. Or if that's too difficult, make two different lists of cards, A and B that have the same cards, and ask people to delete cards from B first and only take into account A's percentages.
Hopefully you understood what I meant, thanks for reading and keep up the good work!
Oh I see what you're thinking.
You're saying that if I miss Brawl and Shield Slam, and there's 100 different epic cards, that now you have a 2% chance to get a card you're missing. But when I miss Brawl x2, and there's 100 different epic cards, that now I have a 1% chance to get a card I'm missing
Could be true, but I don't think I can ignore same named fields.
Also, I think the discrepancy is incredibly marginal.
Thirdly it's not true for legendary cards, since you can only obtain 1 of them.
If you figure out the formula to fix it I will add it. I'm not going to add multiple rows and make the sheet more complicated - less user friendly, to fix a discrepancy of 1%.
Also, if you really want to break your brain - here's a fun one for you.
What's the chance that after getting 98 epic out of 100 epic cards, you are left missing 2x the same card, instead of 2 different cards?
On this I agree, the discrepancy isn't biased in any particular direction, so when you're, for example, comparing which pack you should buy, it's probably still going to be accurate which pack has the highest chance. also, lemme think about those problems for a sec.
Oh... Haha. I'm so dumb! ;) I misread your instructions. RTFM, right?
Anyways. Thanks a lot for your help. Amazingly friendly of you that you actually changed the spreadsheet for me.
Getting ready to add more rows, ey?
Haha, ye, almost done.
Version 2 will be uploaded soon :)
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
Woo! Noob question, is there a way to paste over our existing spreadsheet on the new one? I don't want to go through deleting everything again.
Nice! Thank you :)
With GvG I recall I was able to copy past in the new sections and line things up so it all still worked. May have to check a few of the totals to make sure it works.
Should be possible, google docs does tend to automatically update formulas if you add stuff in between.
There's a few additions in version 2, make sure you copy paste every addition and it should update just fine.
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
Working on it. Hoping it'll be done by monday since I've got a few busy days ahead.
Cards are basically added just need to fix formula's.
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, version 2.0 is completed.
Changes:
Added card percentages, totals, dust missing at the top of the sheet for clearer view. Thanks to CaioCavalero for the idea.
because of this also removed the totals from the bottom.
Added totals behind each section for quicker view.
And ofcourse - added all the TGT cards!
https://docs.google.com/spreadsheets/d/1rZobj5ALRs_7X4tH40Sx1g2h5QexptLifeeobAjorJw/edit?usp=sharing
hope you enjoy!
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
Found a small bug in the golden dust calculations at the top of the document - it is now resolved.
You can copy paste it into your own document, and it should fix any issues, or you could redownload version 2.
If anyone else finds any bugs, be sure to let me know! I'll fix it as soon as I can.
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
Hi, thx BHTrix...I don't really care for the percentages the poster above me mentioned (although it would be best if they are correct :P), I just like your spreadsheet for keeping up with what I have and don't have in an easy way...
I just wanted to say I found a spelling error, Mechenical Yeti :P
thank you once again, very useful stuff :)
You can't stop the signal.
You forgot to take into account that a new card pack consists of 5 cards, not 1 card. Hence your first pack has a 499% chance to contain new cards, or... as you will - 5 new cards. With a very small chance that your first pack will get duplicates. Your calculations do not take into account getting multiple new cards from a pack. That said, your way of calculating might be better - however it's still missing a piece of the equation.
Also when you find a card, your chances to get a rare/epic or legendary card, do not go down, they remain the same, however - you now have a small chance to get a double - which needs to be deducted. All in all I think the way it's currently done in my spreadsheet is fairly accurate - accurate enough for sure.
I'm however open for improvement.
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
Good spot! thanks! fixed 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
There's an error with the calculations, I believe. I'm not very good at explaining so bear with me here.
I'll try to explain with an example as it's the easiest and clearest way.
Let's say there are 50 total epics in a set, so 25 different cards, and I'm missing 2. The chance that a pack has an epic I'm missing will always be (2/50 x 23.14)%, which is 0.92% per pack. And that's true, if those two cards are the same, because it's (1/25 x 23.14)%, which is accurate because that's what I'm missing.
But what if the two cards I'm missing are different? Isn't the chance to find a card you're missing in a pack double, which is 1.84%? Because it doesn't matter if you're missing one or two of the same card, the chance to find them is the same (the chance to find them both in a pack is taken into account in 23.14). So each individual card should always count as 2/50, regardless of if you're missing one or two of them. In that line of thought, missing two different cards would be (4/50 x 23.14)=1.84%.
To implement this into excel, you'd have to see it the other way, meaning you'd do the calculations taking into account only one of each card and ignore every bracket that has a duplicate name with another. Or if that's too difficult, make two different lists of cards, A and B that have the same cards, and ask people to delete cards from B first and only take into account A's percentages.
Hopefully you understood what I meant, thanks for reading and keep up the good work!
Mm, wanted to argue with nikos, but thinking about it he may be right. for each individual rolled epic, it's more likely if the cards are different.
I don't think that's true.
The way I've learned it:
Say you get 2 epic cards.You roll your first epic card, it has a 1/100 chance to be Brawl, example given.
Then you roll your second epic card, does it now have less chance (or as you put it, is it now less likely?, to roll brawl?
No, chance is still 1/100.
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
That's only specifically in the case when you're rolling two epics, not just one. And consider this. If you're missing two brawls, the first one has to be brawl, and the second has to be brawll, so 1%*1%. But if you'r missing one Brawl and one Crush, then the first one can be either brawl or crush, so 2%, and then the second has te be which ever the first wasnt, which, no matter which is it, is back to 1%. so even rolling two epics, it's twice as likely to get two cards you need if they're different, because there's two permutations. There one way to get two heads, but two ways to get one heads and one tails.
Basically, order doesn't matter, assuming the game doesn't distinguish between the first copy of a card and the second, so missing brawl A and brawl B can only be fulfilled one way, by rolling Brawl, while Missing one brawl and one crush can be fulfilled in two ways.
Oh I see what you're thinking.
You're saying that if I miss Brawl and Shield Slam, and there's 100 different epic cards, that now you have a 2% chance to get a card you're missing.
But when I miss Brawl x2, and there's 100 different epic cards, that now I have a 1% chance to get a card I'm missing
Could be true, but I don't think I can ignore same named fields.
Also, I think the discrepancy is incredibly marginal.
Thirdly it's not true for legendary cards, since you can only obtain 1 of them.
If you figure out the formula to fix it I will add it. I'm not going to add multiple rows and make the sheet more complicated - less user friendly, to fix a discrepancy of 1%.
Also, if you really want to break your brain - here's a fun one for you.
What's the chance that after getting 98 epic out of 100 epic cards, you are left missing 2x the same card, instead of 2 different cards?
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
On this I agree, the discrepancy isn't biased in any particular direction, so when you're, for example, comparing which pack you should buy, it's probably still going to be accurate which pack has the highest chance. also, lemme think about those problems for a sec.
Well, great thanks to Dinaverg, new formula's are in - should be even more accurate now in determining which packs are best!
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