First off, a very big thanks for this sheet! I was trying to build my own to analyze all the cards so this is a good starting point. The collection % complete is nice, but something I only implemented for the totals, not every card in detail.
How did you and do you get the list of raw card data?
And one thing to update, Innervate generates 1 mana crystal this turn, not 2 (post-nerf).
First off, a very big thanks for this sheet! I was trying to build my own to analyze all the cards so this is a good starting point. The collection % complete is nice, but something I only implemented for the totals, not every card in detail.
How did you and do you get the list of raw card data?
And one thing to update, Innervate generates 1 mana crystal this turn, not 2 (post-nerf).
And nowadays I input the raw card data manually whenever the reveal for a new expansion starts, but when I started out I did copy a lot of that information from websites or other spreadsheet to make things easier.
You're very welcome and I like your approach of updating each card of an update on a signal, not just one! If only more people were attentive like that. But since you're doing it manually, it is unavoidable to make errors. I'm trying to get more lists from hearthstone.gamepedia uncollapsed, but no success since their database switch yet. If I get more lists, It becomes easy to compare them and see any mismatches.
I'm also trying to develop a minion, weapon, spell and hero power formula to automatically compare all cards in a point system. But it all starts with the raw data.
Nice! Thank you for putting this together. I use the HS deck tracker with associated plug-ins, but I like the idea of having it in excel and a ton of people I know only use their tablets so syncing like this one time even will give them assistance w their collections. If I had the skills I would create an IOS app that is similar.
DELETED
First off, a very big thanks for this sheet! I was trying to build my own to analyze all the cards so this is a good starting point. The collection % complete is nice, but something I only implemented for the totals, not every card in detail.
How did you and do you get the list of raw card data?
And one thing to update, Innervate generates 1 mana crystal this turn, not 2 (post-nerf).
DELETED
People dont understand this amazing work... thanks you so much :D
You're very welcome and I like your approach of updating each card of an update on a signal, not just one! If only more people were attentive like that. But since you're doing it manually, it is unavoidable to make errors. I'm trying to get more lists from hearthstone.gamepedia uncollapsed, but no success since their database switch yet. If I get more lists, It becomes easy to compare them and see any mismatches.
I'm also trying to develop a minion, weapon, spell and hero power formula to automatically compare all cards in a point system. But it all starts with the raw data.
DELETED
Nice! Thank you for putting this together. I use the HS deck tracker with associated plug-ins, but I like the idea of having it in excel and a ton of people I know only use their tablets so syncing like this one time even will give them assistance w their collections. If I had the skills I would create an IOS app that is similar.
DELETED
Thank you for the update. Greatly appreciated!!
Thanks for the update, this sheet is amazing to help look at your collection in a big overview.
Love this spreadsheet, was using another one that is completely abandoned now, then I found yours!
Any idea if you will update for Darkmoon faire?
Also there are a few N/A's showing as errors on the sheet? Don't think they were there before? could be to do with the new expansions.
Love your work! Please try and keep it going!
DELETED
Anxiously awaiting a Barrens update. :) love your work!
DELETED