Be Excellent To Each Other

Oh looks interesting EBG I'll give that a go.

Do you certify that it is malware and virus free?

I considered spreadsheeting it, but then I figured there would be someone even more nerdy than me who might

I'll give it a go, cheers.

Yes, just enter your bank account number and sort code and I guarantee* no issues.



* Not guaranteed.

I noticed that you had only calculated the crafting costs for the neutrals, so here is a version with crafting costs for all classes and a summary of cards needed by rarity

Cool. I'll incorporate that and probably doing something to highlight things based on their card type (with relevant colours).

Here you go, now there is a "nicer" totals page which shows each class

Probably could do with a nicer total for everything on that page too, and it might be easier to put in your numbers if the card lists were ordered the same way as they are in the collection.

I'll have a play later if you haven't already.

I am waiting for v6.2 of the spreadsheet, you know the one that inputs the data itself so I don't have to do anything

Good job btw

This is fun!

This is where i'm up to.



The summary page tells you how many normal cards you are missing for each class, their rarity, how much it would cost to craft them. Plus it tells you the same info for the neutral cards, and also all cards.
It also tells you how much dust you have available in any disenchantable golden cards you have in your collection, if you are like me and aren't bothered about them and just use them for their dust value

I'm going through and swapping the cards around so they are ordered by the collection order, which makes it easy to fill in the number, then i'll upload this version.
All you have to do is fill in the cards you have in the relevant tab, and everything is automagically calculated from that.

Having already filled in my cards, this will make switching over to anything new almost impossibly difficult

When I was sourcing the card list, the fields did also contain mana cost, which I discarded as somewhat irrelevent, however the order of the list in the game goes by mana cost then alphabetical, so had I left that in then the 'correct' order would have been easy to implement. Ooops. Sorry about that

It actually seems to go by mana cost, then type, then alphabet. Which is quite annoying

Oh, and if the cards are in order, it's a 10 minute job to fill in the numbers

I don't think I can be arsed to do even that! Although I'm finding it very enjoyable so far to update the sheet every time I get a card for something, even basic goldens. The trick will be remembering to do it.

I was quite surprised just how many of the class cards I have, I don't need very many at all to finish them off. Neutrals is another matter...

Anyway I've earned enough for my third arena in as many days, fingers crossed it's not a shit one.

All done

This is me



I've added two summary pages, a normal one and a golden card one.
Everything is sorted to make filling out easier.
All you have to do is fill in the numbers in the yellow boxes on each sheet, should take about 10-15 minutes the first time, everything after that is calculated.

I might post it on reddit later, if that is ok with you, I'll give you equal credit

That's fine, although I already posted a version yesterday and it tanked! No upvotes ;(

Heh, I won't bother then

7/1 on this Arena so far... must... hold on.

Bah, 9/3.

155 gold, pack, Golden Sense Demons, 25 dust. Not bad.

Last game ridiculous, insane deck.

New Arena with my winnings. Went 1/2, and somehow pulled back to 7/3. Adopted a truly silly strategy in the last game by trying to coldblood conceal a zombie chow, and I got him to 4, and then it went horribly wrong and I was dead on turn 5. So close!

Reward: A pack and 185 gold.

The gold for more Arena keeps coming! It's possible to keep it going!

My arena card draws have been terrible recently. This is what i'm working with this time, and these were the best choices! Be lucky to get to 3/3 with this shit.




2 defenders of argus is nice, especially as I have an ancient watcher. I dropped the watcher on turn 2 and died on turn 10 without seeing one..

Exactly the fucking same again!

...and 0/3. Don't think i've ever had that before!

I've had 0/3 once or twice. Sometimes the draft is irrecoverably bad! What was the reward?

1 pack, 25 dust.

The pack was junk, so I got 40 dust from that.

6/3 on the third run of the day. A pack and 140 gold. Pack had a golden common.

I have enough for a fourth, so fuck it, let's see how long I can keep going.

I will pretend that people are even reading this and keep posting.

Fourth run: 7/3. Pack, 175 gold.

I appear to be good enough to make a consistent profit. Currently at 285 gold so at least enough for two more runs tomorrow. Phew. I don't think I've played as much Hearthstone as I have today... ever.

Ok, so this spreadsheet now give me extra annoyance. I have 2000 dust, do I craft a new legendary, and if so which one, or do I finish off my Shaman, as that only needs 900 dust...

I wouldn't have known that if I didn't track it

Surely a legendary is a better spend than class cards for a class you don't even play? Unless you're just getting a bit OCD about completing the sets? (Plus of course, many of the class cards are absolute stinkers and you'd never actually use them.)

I'm sat on 1755 dust at the moment so have the luxury of choosing a legendary but I really don't know what I want....

I'd love to do a control warrior but I'm missing FOUR legendaries for that deck....

Left last night's Arena on 3/2.

Stupidly I'm likely to craft captain greenskin soon, so I can complete the set and unlock the captain's parrot.

I also discovered that while you can craft gelbin mekatorp, the gold version is locked out as it was a promo reward for spending money during beta. I imagine they'll eventually change it as it's pretty inconsistent to lock out a card, especially to all 1.0 first time players whether they spent the cash or not!

A bit OCD? Have you seen the spreadsheet we have created?

I'll download and fill it in today, yesterday afternoon and evening disappeared into a long session at the pub followed up by a seriously horrible Chinese meal. (So bad we actually complained, had two of the meals completely removed from the bill and 20% knocked off the rest of the bill.)

OCD or not though, a legendary has to be #1 Priority IMO.

The damn spreadsheet made me play about 40 games yesterday, including some rare levelling up of Warlock and getting some golden basics. Each one was noted accordingly

I think the best strategy is merely to acquire cards until you know there's something you want, and then craft only that. Crafting for completeness is unwise unless it's to literally finish off the collection as you might unpack it naturally in the meantime.

Legendary cards ordered by usefulness (as defined by the amount of decks that use them on hearthhead)
The Naxx cards are out of sequence as they are so new, but being as everyone has them already, then that doesn't really make a difference when you are deciding which legendary to craft next

Ragnaros the Firelord
Bloodmage Thalnos
Leeroy Jenkins
Cairne Bloodhoof
Sylvanas Windrunner
The Black Knight
Ysera
Alexstrasza
Nat Pagle
Tirion Fordring
Tinkmaster Overspark
Grommash Hellscream
Lord Jaraxxus
Archmage Antonidas
Edwin VanCleef
Cenarius
Hogger
Malygos
Old Murk-Eye
Prophet Velen
King Mukla
Al'Akir the Windlord
Baron Geddon
Illidan Stormrage
Loatheb
Harrison Jones
Captain Greenskin
King Krush
Deathwing
Onyxia
Gruul
Lorewalker Cho
The Beast
Gelbin Mekkatorque
Maexxna
Baron Rivendare
Feugen
Stalagg
Nozdormu
Millhouse Manastorm
Elite Tauren Chieftain
Kel'Thuzad

From that list, this is what I have:

Ragnaros the Firelord
Bloodmage Thalnos
Leeroy Jenkins
Cairne Bloodhoof
Sylvanas Windrunner
The Black Knight
Ysera
Alexstrasza
Nat Pagle
Tirion Fordring
Tinkmaster Overspark
Grommash Hellscream
Lord Jaraxxus
Archmage Antonidas
Edwin VanCleef
Cenarius
Hogger
Malygos
Old Murk-Eye
Prophet Velen
King Mukla
Al'Akir the Windlord
Baron Geddon
Illidan Stormrage
Loatheb
Harrison Jones
Captain Greenskin
King Krush
Deathwing
Onyxia
Gruul
Lorewalker Cho
The Beast
Gelbin Mekkatorque
Maexxna
Baron Rivendare
Feugen
Stalagg
Nozdormu
Millhouse Manastorm
Elite Tauren Chieftain
Kel'Thuzad

I've crossed the ones I have out - still LOTS needed.

Ragnaros the Firelord
Bloodmage Thalnos
Leeroy Jenkins
Cairne Bloodhoof
Sylvanas Windrunner
The Black Knight
Ysera
Alexstrasza
Nat Pagle
Tirion Fordring
Tinkmaster Overspark
Grommash Hellscream
Lord Jaraxxus
Archmage Antonidas
Edwin VanCleef
Cenarius
Hogger
Malygos
Old Murk-Eye
Prophet Velen
King Mukla
Al'Akir the Windlord
Baron Geddon
Illidan Stormrage
Loatheb
Harrison Jones
Captain Greenskin
King Krush
Deathwing
Onyxia
Gruul
Lorewalker Cho
The Beast
Gelbin Mekkatorque
Maexxna
Baron Rivendare
Feugen
Stalagg
Nozdormu
Millhouse Manastorm
Elite Tauren Chieftain
Kel'Thuzad

Same list for me....

Ragnaros the Firelord
Bloodmage Thalnos
Leeroy Jenkins
Cairne Bloodhoof
Sylvanas Windrunner
The Black Knight
Ysera
Alexstrasza
Nat Pagle
Tirion Fordring
Tinkmaster Overspark
Grommash Hellscream
Lord Jaraxxus
Archmage Antonidas
Edwin VanCleef
Cenarius
Hogger
Malygos
Old Murk-Eye
Prophet Velen
King Mukla
Al'Akir the Windlord
Baron Geddon
Illidan Stormrage
Loatheb
Harrison Jones
Captain Greenskin
King Krush
Deathwing
Onyxia
Gruul
Lorewalker Cho
The Beast
Gelbin Mekkatorque
Maexxna
Baron Rivendare
Feugen
Stalagg
Nozdormu
Millhouse Manastorm
Elite Tauren Chieftain
Kel'Thuzad

So quite a few in there but some real shit ones.....

I crafted Rag and Leeroy, the rest of mine I got in packs, naxx or as a reward. I might craft Sylvanas as I can see that being useful in most decks.

Modified my list to strikethrough, as that is a much better way of showing it

I really should dust my golden cho and get a better legendary, but he is great fun when you just want to arse around

The other thing I really need is the giants, I don't have any of them. I keep waiting for them in packs, but they never arrive

I think I dusted my Nat Pagle, judging that in his post-nerf state that I'd never use him and the dust would be better.

Dusting is so inefficient though really, you get 1/4 of its worth, so you really need to be desperate to get whatever you're looking to craft. It hasn't stopped me doing just that on multiple occasions!

Sylvannas is a big want of mine. For Priest or Warrior it's a fairly easy mind control to kill it yourself and steal whatever tasty minion is on the other side. It's also pretty good against a lone rag on the board.

I crafted one Molten giant the other day, took a lot of disechants and I didn't end up using it. They're all epics so rather expensive and exceedingly rare in regular packs.

Dusting a golden isn't so bad though, as my golden cho is worth 1600, so it will be a straight swap for another legendary.

I don't dust anything else though, unless I already have 2 of them (or 1 if it is a legend). I've got some golden cards waiting to be dusted when I get their normal equivalent filled up! I have a few cards where I have one normal and one golden, which annoys me, but I won't dust the goldens yet, just in case...

OK, here's how you format for rarity;



You have to create the ruleset as above for the first worksheet, and then copy the highlighted row from sheet one, and then highlight the rows in the other worksheets and Paste Special > Formatting to transfer the rule over. No nicer way of doing it afaik.

Depends on your goals. If you ultimately want ALL GOLDEN EVERYTHING YEEAHHAAAA, then dusting anything golden is even more crippling because the cost to remake later is 4 times as bad!

But again, that hasn't stopped me doing that on multiple occasions

7/3 in arena today, that's a bit more like it I almost had him too, if he didn't top deck a charge, that would have been it.

I dragged a horrible Hunter deck to 4/3.

The cards weren't terrible, but no synergy. Offered me a 1/1 wolf first up and then two random animal companions... and then no more animals the entire load. No Hyena, no Buzzard, no UTH. Also gave me some secrets leverage up front and then 1 secret. And kept drawing the same cards and over and over, not once in 7 games giving me the 3 or 4 cards I most wanted. Silly thing.

Have gone for a Mage deck next, seems decent enough despite the lack of Flamestrike, but can't play it until the child goes to bed.

5/3 Arena, worst one for a while. 60 gold, Eaglehorn bow. Pack contained two epics and a rare though, woo!

New tab on the spreadsheet for Arena results/awards tracking

Speaking of 0/3 Arenas.... yep. Very annoyed, as the draft was pretty good. Just came up against 3 decks that crushed me quickly before I could get any momentum going.

1 pack, 30 gold, and unlocked a golden wisp! Woohoo?

Spotted a relevant reminder on reddit today that there are only 5 days of free first wing of Naxx left.

This means unlock it on Asia and North America too, just because you can. Purchases are region-sepcific and this is just in case you ever want to switch about in future.

I have started playing this, so help me God. Is it addictive or what? Yes. Yes, it is.

So far I am at rank 21 with a mage deck hastily cobbled together by basically taking all the mage cards I had and adding supporting cards in the form of minions with "spell damage +1" and suchlike. Seems to work pretty well, actually.

To elaborate a bit:

The presentation is sublime, obviously, because Blizzard. The rules seem to work very well indeed; they obviously spent a lot of time testing and adjusting to get it right. It is rather simple compared to Magic: The Gathering, though, so I wonder if it will be enough to stay entertaining in the long run, but on the flip-side it doesn't have any of Magic's brokenness rules-wise.

I refuse to spend real money, so if it turns out to be pay-to-win in the better ranks then I will stop playing when I am no longer having fun.