2
Quote from Mister_Smith »If you want to discuss a card at least remember it's name. How are we supposed to take you serious if you confuse Freezing Trap with Ice Trap?
Thanks for being constructive and nice and stuff. What's up your ass?
Agreed. "Ha one of the words you used was slightly off, let me belittle you with my superior hearthstone knowledge!"
2
He killed her himself and got mad at us &*^*#&$%^)#^%
1
Thanks for this great resource!
Forecast.
1
Hi! i have a way to keep my collecton too, but it is in PT-BR (portuguese)
Have a look at it, maybe it helps in someway?
here is the google drive link: https://drive.google.com/file/d/0BzKsPK_AZlQvOUNUQ0pYc1QzWVU/view?usp=sharing
Obs* i need to remake all the naming of cards and the formulas to work properly, if you guys like it, i'll make it. Thanks!
1
Quote from DialM4Murloc »It doesn't seem to work for me :/ Nothing seems to happen when I press backspace :S
Nevermind!
4
Is it even necessary to write a guide?
Step 1 : Have minions/weapon ? Play it.
Step 2 : Have a minions/weapon to hit face? Hit it.
Step 3 : Have enough mana for Hero Power? Use it.
Step 4 : Kill Command to close the game.
TL;DR : Hit face.
PS: I'm a facehuntard hater. All the decks I'm facing in the ladder are totally cancerous (Sitting at Rank4 now) especially Facehuntard. I don't even feel fun playing Huntardstone anymore.
1
Thank you for taking the time and putting in the effort to create this for the community.
1
I just copied it to my own google drive, works fine there.
1
Thank you for this! Really useful.
I found a small error though: GvG neutral epic card total value is fixed to 16, so it's not automatically updated (both normal and golden sheets).
Very nice find!
Thank you.I've updated the original one.
For those that more rather change the code instead of downloading the new one and striping off their entire collection again:here's the code for the box
=COUNTA(C348:C392)
(C384 is the first Epic Neutral card box, C392 the last one, it then counts the filled boxes, so if you have deleted lines, you might need to adjust)
-BHTrix
I suddenly truly feel the value of git/Github
1
Hi
I've been testing your sheet.
First of all, I've downloaded it with extension .XLSX and numbers are not updating when I delete a card by using backspace. It sux ! ^_^
Second, i've noticed that some Legendaries from Base Set are missing:
Old Murk Eye (Murloc Legendary obtained when you have all the Murlocs Cards)
Elite Tauren Chieftain (2013 Blizzcon Gift. This card is now only obtainable from Crafting)
Gelbin Mekkatorque (Gifted when you bought a pack during Beta, now only obtainable from Crafting)
Click on the buttons to change the PopCard background.
Click on the button to hide or unhide popcard elements.
1
I was thinking of posting this on the heroes forums, but then I thought, won't there just be people that already play heroes on those forums?
Therefor, I figured I'd offer my remaining keys here.
I got 4 beta keys, first to leave their battletags, or pm me their battletags get a key.
1
Killed him 1st try, refined it a bit 60% winrate no legendary minions, super cheap deck.
9
replace with the new 5/6 dragon that's soon released and problem solved
1
eh, midrange > face
1
Try to expand into midrange hunter.
7
Priest vs Emperor Thaurissan.
Turn 6, cabal priest his, already 1/5, Moira (shielded it, prooo)
Turn 7, back to back divine spirit - 1/15 Moira, prooooooo, I'm thinking, bitch can't die now, right? :D
Inner Fire, go face. End Turn.
Emperor uses Big Game Hunter on Moira. Hero Power on my face, I lose.
GG :D
1
Updated for Blackrock Mountain, added all the cards in the golden collector's tab.
Fixed a few bugs in the golden tab calculations.
https://docs.google.com/spreadsheets/d/1VZ7ThgAk9_gG_rUtCNRqx9OeDecinkJnZenpYrSW4ec/edit?usp=sharing
New total for full golden card collection: 759200 dust. Happy Hunting!
2
I'll add a few
1
Well then!
The spreadsheet should now have the "exact" percentage chance you have on obtaining a card you do not yet have when opening a card pack.
These numbers are based on a pretty big pool, but, without confirmation from blizzard on the -exact numbers- are sure to not be 100% accurate. However, they should be pretty accurate and therefor a decent measure.
Now there's a small thing I did, simply because in my opinion it makes more sense.
As you can see in the Normal Sheet, you have a 499.99% chance when you open your first pack to get a card you're missing (so yep, you'll probably get 5 cards you are missing) and (Yep, you have a 0.01% chance to get 3 the same or more common's and actually get doubles on your first pack, hahaha:D) This number is a COMBINATION of the chance you have to get a normal AND a golden version of the card. If I would have only used the chance you have to get a normal version, the chance would be somewhere at 483%, and you'll also have a 17% chance to get a golden card.
Now In my opinion, if I get a golden version of the card, but I do not have a normal version of the card, for me, that still counts towards my normal progression also, because for me, my normal collection is mainly just about getting all the cards, and I'm not going to be very sad if I have a card in my collection that's golden instead of normal. (I really hope I'm still making sense for everyone :P) hence: the normal sheet % chance is a combination of the chances you have to get normal AND golden cards. Whereas the golden sheet page has only the % chance on golden cards.
So without further ado,
Happy collecting everyone!
2
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.