PDA

View Full Version : Hex Rewards Calculator



Kami
06-05-2013, 01:58 PM
Download:

http://bit.ly/HexCalc

Credit goes to Matthew Foster who started it here:

http://bit.ly/14pW7XE

Other Stats:



Number of Pledges (KS and confirmed PP)
19,206

$2,557,205








Set 1 Boosters
1,679,560

$3,359,120


Set 2 Boosters
165,126

$330,252


Set 3 Boosters
110,626

$221,252


Primal Boosters
11,025




Normal Starters
65,616

$656,160


Dragon's Blood Starter
8,302

$83,020


Free Drafts (Total)
55,092

$385,644


VIP Months (Total)
29,368
$117,472
$234,944


1 of Each Crafting Component
8,302




Bonus Legendary Equipment
16,604




Exclusive Alternative Art (Collector)
21,708
904.5 Sets



2x Dungeon Loot (DC)
2,090




Bonus Equipment (DC)
41,800




10% XP Bonus for Guild (GM)
1,977




Set 1 Boosters (GM)
177,930

$355,860


Raid Leader Blessing
1,241




Free Draft per Week (1.5 year)
2,757

$1,505,322


Free Draft per Week (Life) and KS Tournament (PP+)
2,090

$760,760/year


Likeness In-Game (Vanity Card)
90




Every Non-Exclusive Card in Set 1
210
52.5 Sets



Every Equipment in Set 1
15




Design-a-Dungeon
15




Design-a-Card
14










PVE cards





Chest'O Hex
39,376
9,844 Sets



Princess Cory
39,376
9,844 Sets



Lady Cassandra
38,537
9,634.25 Sets



Void Marauder
32,575
8,143.75 Sets



Spectral Assassin
32,575
8,143.75 Sets



Prospero, Sylvan Enchanter
27,141
6,785.25 Sets



Orson's Dream
27.141
6,785.25 Sets



Crowd Roars
27,141
6,785.25 Sets



Scourge Knight
23,859
5,964.75 Sets



Moment of Glory
23,859
5,964.75 Sets



Ninja Training
23,859
5,964.75 Sets



The Wrath of Zakiir
20,269
5,067.25 Sets



Spectral Oak

10,111
2,527.75 Sets/Day









PVP Cards





Replicator's Gambit
32,575
8,143.75 Sets



Princess Victoria
27,141
6,785.25 Sets



Extinction
23,859
5,964.75 Sets



Rage Fire
20,269
5,067.25 Sets



Pack Raptor
18,413
4,603.25 Sets









Estimated Value Given (Minimum 1st Year)

3.46x

$7,892,334



Continued... (http://forums.cryptozoic.com/showthread.php?t=24831&p=247599&viewfull=1#post247599)

gilby123
06-05-2013, 02:04 PM
Very handy! Thanks!

Trothael
06-05-2013, 02:07 PM
It's a little buggy, but it works great all the same :D

Thanks!

jaxsonbateman
06-05-2013, 02:12 PM
Danke - made me notice that the +1 of every exclusive card was for the PvE stuff only... >.<
Now I need to decide if I can afford to fork out another 250 for Collector, so I get full playsets of the AA PvP cards. >.>

Trothael
06-05-2013, 02:15 PM
I just noticed that the info for the PVP cards is wrong.
I went DC/Collector and it's telling me I only have 3 of each PVP card when it should be 5. One of the KS updates confirmed that the 660k stretch goal applied to PvE and PvP cards.

Zephyr
06-05-2013, 02:18 PM
Jaxson, just to be clear - the +1 does double the PvP cards as well - they mentioned this in update #16 - http://www.kickstarter.com/projects/cze/hex-mmo-trading-card-game/posts?page=3 .

Great link though, definitely helpful!

jaxsonbateman
06-05-2013, 02:23 PM
Oh, phew, that's a relief. I think the spreadsheet is wrong on that count then, as it was saying I'd only get 2 PvP cards (when, if the +1 applies, it should be 4 for a DC/RL like myself).

Kami
06-05-2013, 03:53 PM
Still working on it. ^^;

Had to fix up a few things already from the original. Some of the formulas get a bit complicated.

PvP/PvE Cards total should be fixed now in the calculator.

Vomitlord
06-05-2013, 03:57 PM
Wow seems Some of you really need the game to come out. :D

Vibraxus
06-05-2013, 03:58 PM
Looks like Grand King only might be wrong, it has happened before. It shows as YES for Gen Con dinner, and only 1 Dragon's blood starter.

Lazybum
06-05-2013, 04:03 PM
with GK collectors and 2 king it tells me i get an invite to the gen con dinner

fido_one
06-05-2013, 04:06 PM
Super awesome excel sheet, super minor thing to note: it says I can go to Gencon though I don't have the DL tier...

Which I think means change this: IF(((SUM(B2:R2))>=1),"YES","NO")

to this:

IF(((SUM(O2:R2))>=1),"YES","NO")

Chance
06-05-2013, 04:13 PM
if you multi pledge you still only get 1 of each crafting or do you get multiple?

EDIT: Also you need to add the Tier 3 cards we ge

PS. THIS FUCKING ROCKS

Gerogero
06-05-2013, 04:20 PM
Also, I did a King and a Knight and it was still giving me a yes in all of the 250 tier bonuses of DC, RL, and GM.

MaxtionHero
06-05-2013, 04:23 PM
I believe GK gets 3 SLG; 2 frpm Collector and one from King, correct?

Gerogero
06-05-2013, 04:28 PM
No, because collector already includes king.

MaxtionHero
06-05-2013, 04:30 PM
Ah, ok. I see now. Thanks for clearing that up. =)

fido_one
06-05-2013, 04:33 PM
All changes are good - don't know if it's the excel sheet or my misunderstanding: dragon deck starter - does that math on the calculator look right to everyone else?

Lazybum
06-05-2013, 04:38 PM
gk+collector+king gives me 8 of every card but only 5 lotus. looks like spreadsheet is pretty good now

Kami
06-05-2013, 05:17 PM
Sorry for the quietness, I've been doing massive updates to the Excel sheet. I think I've got everything fixed, including adding Set 3 Boosters and Equipment (Yes/No)!

[Note: I can't edit the Google spreadsheet, only the DropBox Excel one I'm working on locally and uploading.]

Lazybum
06-05-2013, 05:19 PM
kami you are my hero

Boozecluez
06-05-2013, 06:16 PM
Awesome work ,for people who plan on keeping the 3x30 set 1 boosters for themselves just manually edit the booster section by adding 90 to the total.

Kami
06-05-2013, 06:24 PM
Awesome work ,though not sure if mentioned but can't see the 3x30 set 1 boosters included on the applicable tiers..Could always assume people will keep themselves so simply change 155 to 245 instead

That was intentional because it's been stated it would be a code that provides 30 Set 1 each to three individuals. While it's true you could technically claim it yourself, the assumption is that you'd share.

DjiN
06-05-2013, 06:24 PM
Thanks for the calculator Kami, it's great!

Ozmono
06-05-2013, 06:25 PM
Is this calculator accurate regarding the free 1 draft a week for the 250 tiers and above stacking? People on the KS comments page told me they don't stack.

DjiN
06-05-2013, 06:28 PM
Two things not working right atm:

-Free 1 year draft stacking
-spectral lotus garden receiving the +1 on every PvE card KS bonus

Ozmono
06-05-2013, 06:32 PM
Okay thanks.
I really don't understand why they don't stack the 1 year free drafts. I will probably end up using two accounts because of this and there is no other reason why I would.

Kami
06-05-2013, 06:38 PM
Is this calculator accurate regarding the free 1 draft a week for the 250 tiers and above stacking? People on the KS comments page told me they don't stack.

As far as I know, the draft for one year stacks with itself (for one year total but multiple drafts per week) but if you have the draft for life, you can't stack the one year draft.

i.e. 2xCollector = 2xDraft per week for one year

i.e. 1xCollector + 1x Pro Player = 1xDraft per week for life

I could be wrong though?

Edit:

Changed so that the draft/wk (one year) no longer stacks and fixed the Garden count.

Ozmono
06-05-2013, 06:42 PM
As far as I know, the draft for one year stacks with itself (for one year total but multiple drafts per week) but if you have the draft for life, you can't stack the one year draft.

i.e. 2xCollector = 2xDraft per week for one year

i.e. 1xCollector + 1x Pro Player = 1xDraft per week for life

I could be wrong though?
Well I hope you are right. I started a thread about it regardless though so hopefully I'll find out for sure.

DjiN
06-05-2013, 06:50 PM
i.e. 2xCollector = 2xDraft per week for one year


Will be 1x Draft per week for one year



i.e. 1xCollector + 1x Pro Player = 1xDraft per week for life


Will be 1x Draft per week for life + 1x Draft per week for one year

Kami
06-05-2013, 06:53 PM
Will be 1x Draft per week for life + 1x Draft per week for one year

This part I'm sure is wrong. Cory stated it live.

schild
06-05-2013, 07:53 PM
Spectral Lotus Garden calculation still broken. They need to not be clumped in with the other Kickstarter exclusive cards. It is its own thing.

Kami
06-05-2013, 08:04 PM
Spectral Lotus Garden calculation still broken. They need to not be clumped in with the other Kickstarter exclusive cards. It is its own thing.

Apparently it didn't save properly the first time I fixed it. ^^:

TheWrathofShane
06-05-2013, 08:13 PM
Danke - made me notice that the +1 of every exclusive card was for the PvE stuff only... >.<
Now I need to decide if I can afford to fork out another 250 for Collector, so I get full playsets of the AA PvP cards. >.>

The +1 of every exclusive card is also for the PvP AA stuff, including the collector exclusive rewards. SO collector gets x2 of 6 different PvP AA cards..

fido_one
06-07-2013, 06:13 AM
I'm bumping this for the good of the community in the final hours here, this excel sheet can come in mighty handy if you're trying to figure out your pledge[s].

nickon
06-07-2013, 07:11 AM
I've found this online excel (visually) more useful: click here (https://docs.google.com/spreadsheet/ccc?key=0Aq5x4_DeZngPdGdVTXdDWkplWjcyNmtYalEzWWdOb 2c#gid=0), so I thought I might add it in here as well for late-backers. Not sure who posted it again on the forums, but credits to the author and other people involved in creating this!

nicosharp
06-07-2013, 03:07 PM
got a 0 and 7 reversed for the dragon starter deck

Kami
06-07-2013, 03:11 PM
got a 0 and 7 reversed for the dragon starter deck

Fixed.

Aeromis
06-09-2013, 01:20 AM
Thanks for the calculator!

Zarien
06-09-2013, 02:32 AM
this is awesome! well done!

Gorgol
06-09-2013, 04:33 AM
Amazing

Kami
06-09-2013, 08:00 AM
Additional stats I couldn't fit on the front:



Mercenaries



Zoltog
15383


Bergamot Ebonrock
12666


Bebo
12666


Moof
11025


Glorfenblort
11025


Cardboard Tube Samurai
9230


Monkey of 9 Tails
8302


Aethynia
8302

Saeijou
04-30-2014, 10:23 AM
awesome! thank you

elfstone
04-30-2014, 10:03 PM
whoah there Saeijou. almost a 1 year thread necro :p

Gwaer
04-30-2014, 10:16 PM
Man, I hadn't commented on this one either. Great job Kami! =)

arastor
05-01-2014, 07:27 AM
The Midnight Shepherds would be proud of this necromancy.