Be Excellent To Each Other
https://www.beexcellenttoeachother.com/forum/

Hearthstone thread
https://www.beexcellenttoeachother.com/forum/viewtopic.php?f=3&t=9861
Page 36 of 72

Author:  Hearthly [ Sat Aug 23, 2014 17:22 ]
Post subject:  Re: Hearthstone thread

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

Do you certify that it is malware and virus free? :D

Author:  Trooper [ Sat Aug 23, 2014 17:25 ]
Post subject:  Re: Hearthstone thread

:D 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.

Author:  ElephantBanjoGnome [ Sat Aug 23, 2014 17:27 ]
Post subject:  Re: Hearthstone thread

Hearthly wrote:
Do you certify that it is malware and virus free? :D

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



* Not guaranteed.

Author:  Trooper [ Sat Aug 23, 2014 17:51 ]
Post subject:  Re: Hearthstone thread

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 :)

Author:  ElephantBanjoGnome [ Sat Aug 23, 2014 18:00 ]
Post subject:  Re: Hearthstone thread

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

Author:  Trooper [ Sat Aug 23, 2014 18:32 ]
Post subject:  Re: Hearthstone thread

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

Author:  Trooper [ Sat Aug 23, 2014 18:37 ]
Post subject:  Re: Hearthstone thread

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.

Author:  Slightly Green [ Sun Aug 24, 2014 9:37 ]
Post subject:  Re: Hearthstone thread

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 :D

Good job btw

Author:  Trooper [ Sun Aug 24, 2014 11:27 ]
Post subject:  Re: Hearthstone thread

This is fun! :D

This is where i'm up to.

Attachment:
Screen Shot 2014-08-24 at 11.20.48.jpg


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.

Author:  ElephantBanjoGnome [ Sun Aug 24, 2014 11:42 ]
Post subject:  Re: Hearthstone thread

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 :D

Author:  Trooper [ Sun Aug 24, 2014 11:50 ]
Post subject:  Re: Hearthstone thread

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

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

Author:  ElephantBanjoGnome [ Sun Aug 24, 2014 12:15 ]
Post subject:  Re: Hearthstone thread

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.

Author:  Trooper [ Sun Aug 24, 2014 12:59 ]
Post subject:  Re: Hearthstone thread

All done :)

This is me

Attachment:
Screen Shot 2014-08-24 at 12.56.58.jpg


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.

Attachment:
Hearthstone Cards V4.xlsx

Author:  Trooper [ Sun Aug 24, 2014 13:01 ]
Post subject:  Re: Hearthstone thread

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

Author:  ElephantBanjoGnome [ Sun Aug 24, 2014 13:07 ]
Post subject:  Re: Hearthstone thread

Trooper wrote:
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 ;(

Author:  Trooper [ Sun Aug 24, 2014 13:12 ]
Post subject:  Re: Hearthstone thread

Heh, I won't bother then :D

Author:  ElephantBanjoGnome [ Sun Aug 24, 2014 13:26 ]
Post subject:  Re: Hearthstone thread

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

Author:  ElephantBanjoGnome [ Sun Aug 24, 2014 13:54 ]
Post subject:  Re: Hearthstone thread

Bah, 9/3.

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

Last game ridiculous, insane deck.

Author:  ElephantBanjoGnome [ Sun Aug 24, 2014 15:17 ]
Post subject:  Re: Hearthstone thread

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! :D

Author:  Trooper [ Sun Aug 24, 2014 16:40 ]
Post subject:  Re: Hearthstone thread

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.

Attachment:
Screen Shot 2014-08-24 at 16.38.37.jpg

Attachment:
Screen Shot 2014-08-24 at 16.38.47.jpg


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..

Author:  Trooper [ Sun Aug 24, 2014 16:51 ]
Post subject:  Re: Hearthstone thread

Trooper wrote:
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!

Author:  Trooper [ Sun Aug 24, 2014 17:00 ]
Post subject:  Re: Hearthstone thread

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

Author:  ElephantBanjoGnome [ Sun Aug 24, 2014 18:09 ]
Post subject:  Re: Hearthstone thread

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

Author:  Trooper [ Sun Aug 24, 2014 18:18 ]
Post subject:  Re: Hearthstone thread

ElephantBanjoGnome wrote:
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.

Author:  ElephantBanjoGnome [ Sun Aug 24, 2014 19:43 ]
Post subject:  Re: Hearthstone thread

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.

Author:  ElephantBanjoGnome [ Sun Aug 24, 2014 21:27 ]
Post subject:  Re: Hearthstone thread

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.

Author:  Trooper [ Mon Aug 25, 2014 8:57 ]
Post subject:  Re: Hearthstone thread

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 :D

Author:  Hearthly [ Mon Aug 25, 2014 9:39 ]
Post subject:  Re: Hearthstone thread

Trooper wrote:
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 :D


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....

Author:  ElephantBanjoGnome [ Mon Aug 25, 2014 9:47 ]
Post subject:  Re: Hearthstone thread

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!

Author:  Trooper [ Mon Aug 25, 2014 9:53 ]
Post subject:  Re: Hearthstone thread

Hearthly wrote:
Trooper wrote:
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 :D


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?


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

Author:  Hearthly [ Mon Aug 25, 2014 10:02 ]
Post subject:  Re: Hearthstone thread

Trooper wrote:
A bit OCD? Have you seen the spreadsheet we have created? :D


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.

Author:  ElephantBanjoGnome [ Mon Aug 25, 2014 10:04 ]
Post subject:  Re: Hearthstone thread

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.

Author:  Trooper [ Mon Aug 25, 2014 10:06 ]
Post subject:  Re: Hearthstone thread

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

Author:  Trooper [ Mon Aug 25, 2014 10:09 ]
Post subject:  Re: Hearthstone thread

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

Author:  ElephantBanjoGnome [ Mon Aug 25, 2014 10:15 ]
Post subject:  Re: Hearthstone thread

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

Author:  Hearthly [ Mon Aug 25, 2014 10:28 ]
Post subject:  Re: Hearthstone thread

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.....

Author:  Trooper [ Mon Aug 25, 2014 10:29 ]
Post subject:  Re: Hearthstone thread

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.

Author:  Trooper [ Mon Aug 25, 2014 10:33 ]
Post subject:  Re: Hearthstone thread

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

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

Author:  Trooper [ Mon Aug 25, 2014 10:35 ]
Post subject:  Re: Hearthstone thread

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 :(

Author:  ElephantBanjoGnome [ Mon Aug 25, 2014 10:37 ]
Post subject:  Re: Hearthstone thread

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.

Author:  Trooper [ Mon Aug 25, 2014 10:44 ]
Post subject:  Re: Hearthstone thread

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...

Author:  ElephantBanjoGnome [ Mon Aug 25, 2014 11:01 ]
Post subject:  Re: Hearthstone thread

OK, here's how you format for rarity;

Attachment:
formatting.jpg


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.

Author:  ElephantBanjoGnome [ Mon Aug 25, 2014 11:03 ]
Post subject:  Re: Hearthstone thread

Trooper wrote:
Dusting a golden isn't so bad though

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 :DD

Author:  Trooper [ Mon Aug 25, 2014 13:58 ]
Post subject:  Re: Hearthstone thread

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.

Author:  Curiosity [ Mon Aug 25, 2014 17:37 ]
Post subject:  Re: Hearthstone thread

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.

Author:  ElephantBanjoGnome [ Mon Aug 25, 2014 19:27 ]
Post subject:  Re: Hearthstone thread

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 :facepalm:

Author:  ElephantBanjoGnome [ Tue Aug 26, 2014 13:52 ]
Post subject:  Re: Hearthstone thread

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?

Author:  ElephantBanjoGnome [ Wed Aug 27, 2014 14:41 ]
Post subject:  Re: Hearthstone thread

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.

Author:  lasermink [ Fri Aug 29, 2014 13:48 ]
Post subject:  Re: Hearthstone thread

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.

Author:  lasermink [ Fri Aug 29, 2014 14:01 ]
Post subject:  Re: Hearthstone thread

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.

Page 36 of 72 All times are UTC [ DST ]
Powered by phpBB © 2000, 2002, 2005, 2007 phpBB Group
http://www.phpbb.com/