| A | B | C | D | E | F | G | H | I | J | K | L | M | N | O | P | Q | R | S | T | |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
1 | Main Copy (Always Most Recent Update) | To Download A Copy For Yourself, Go To File --> Make a Copy... | Click here for the Reddit Help Thread | |||||||||||||||||
2 | 10/8/19 - Reevaluating my time investment with Blizzard and Hearthstone after recent banning of Blitzchung. Not sure if I will continue making/updating community content for it. | |||||||||||||||||||
3 | Click the links below for how to set up the sheet | |||||||||||||||||||
4 | Select Source | Username/ID | Server | |||||||||||||||||
5 | HSReplay | 26787020 | US | 26787020 | ||||||||||||||||
6 | HearthPwn Setup | |||||||||||||||||||
7 | Enter Data Here | Collection Snapshot | Select your "Source" as Hearthpwn and use your Hearthpwn username | |||||||||||||||||
8 | Standard | Wild | ||||||||||||||||||
9 | Current Dust | 1,680 | Percent Completed | #REF! | #REF! | Set your Collection to Public! | ||||||||||||||
10 | ||||||||||||||||||||
11 | Disenchant Dust | 0 | Dust Needed | #REF! | #REF! | HSReplay Setup | ||||||||||||||
12 | Select your Source as HSReplay and your correct server. | |||||||||||||||||||
13 | Gold | 7,645 | Best Pack To Open | #REF! | ||||||||||||||||
14 | Set Collection to "Public" in settings | |||||||||||||||||||
15 | Unopened Packs | 0 | Value of Collection | #REF! | ||||||||||||||||
16 | Go to "My Data" --> "My Collection" | |||||||||||||||||||
17 | Dust From Extra Gold Cards? | #REF! | ||||||||||||||||||
18 | Max Dust | #REF! | ID can be found on last part of "Copy" for your collection link. | |||||||||||||||||
19 | Copy/Paste that number under Username/ID. | |||||||||||||||||||
20 | ||||||||||||||||||||
21 | Quick Breakdown Of Tabs. (Try Hovering Mouse Here to Read Notes) | Golden Hero | 100.0% | |||||||||||||||||
22 | Unique Class Hero | 84.0% | ||||||||||||||||||
23 | Summary | Breaks down your collection by class, set, and rarity. And gives general pack information and moneyary values. | Class | Wins | ||||||||||||||||
24 | Druid | 3,285 | ||||||||||||||||||
25 | Cards | Lists all the cards including how many you own. You can expand the cells above Coloumn J to see all card information. You can even weight the cards (0-100) how badly you want them to calculate a different pack formula on "Packs" tab. | Hunter | 571 | ||||||||||||||||
26 | Mage | 626 | ||||||||||||||||||
27 | Missing Cards | This will show you a list of all the cards you are missing max copies of. You can also filter by card tier lists which use HSReplay data. It is sorted exactly how your "Cards" tab is sorted. | Paladin | 1,423 | ||||||||||||||||
28 | Priest | 842 | ||||||||||||||||||
29 | Packs | Advanced breakdown of which pack to buy. More data and allows you to weight custom packs based on which cards you do or don't want. Also toggle the Expansions you want compared on the Summary tab. | Rogue | 523 | ||||||||||||||||
30 | Shaman | 1,893 | ||||||||||||||||||
31 | Changelog | List of changes/updates to the spreadsheet. Most recent changes are listed at the top. | Warlock | 2,154 | ||||||||||||||||
32 | Warrior | 2,853 | ||||||||||||||||||
33 | ||||||||||||||||||||