Master Spreadsheet to track all your needs in HC (XP, Gold, SS, Gear)

[Dreddster]

Hey guys,

I combined some of the spreadsheets that I found on the forum, created by other members, to develop one to track the gold, XP, SS and Gear needed while we play the game.

You can use the spreadsheet to:
1. Track how much XP and gold you will need for your next level.
2. Calculate how much gold and XP you need to level up a hero from a certain level to another level (for example from 10 to 80) to find out whether you can afford it.
3. Calculate how much XP are worth all your XP items in the inventory.
4. Total XP, Total Gold, Total SS, for selected heroes to level up to 90.
5. The date you will reach lvl 90 based on the number of recharges per day.

Keep in mind that the gold needed for skills after level 80 is calculated as previous + 1000. Someone please confirm how much gold is needed for skills at level 81.

I am also working on the gear calculator - for example how many bags of holding, moonglow etc. you need for your heroes till level 90 and till the next gear upgrade.

However I need some help here. I don't have the gear for certain heroes (like Bear, Cloudwalker, Poisoned one, etc.). I have listed them on sheet "Items". If you have any data on these, please contact me so I can add it.

If you have any questions and suggestions, or you see something that is not working properly, please let me know!

Link to the spreadsheet:
https://www.dropbox.com/s/qirjtpegur...HCV3.xlsx?dl=0

[tdhoang89@yahoo.com]

Wow :-o

Thank you for your hard work man

[Neph]

Thank you very much Sir.

[tonyvuknome]

Very nice. How can I change the order of the heroes? Do I just need to retype everything?

[Dreddster]

If you want to sort them, Select the whole table. Then click on Sort & Filter button, and select "Custom Sort". I have sorted them the way Ucool sorts them in their interface, which is first Current Level, then Current Stars.
If you want to change the sorting, just push up whichever column you prefer to be first, second etc., or add another one in the interface.

Here is a pic, showing it:

[Ferico]

Dreddstar, you da the real mvp! Very much helpful to everyone, indeed. Thanks a lot!

[nyak]

There is a steak in the exp calculator. is it an exp items to be released in the next updates or at higher time rifts?? It gives 7500 exp as i see

[en3rgizer]

There is a steak in the exp calculator. is it an exp items to be released in the next updates or at higher time rifts?? It gives 7500 exp as i see

I think this item has been added with the last patch (1.6).

[BJack]

Someone please give this guy a medal

[Dreddster]

Thanks guys, I am glad you like it!

But lets make the gear section as well.
On sheet "Items" there are the heroes I don't have the gear for. The rest are just hidden rows.
You can type the gear there, or just select it from the dropdown. Then add it in this topic or give a dropbox link.

I will add it to the master version and setup the gear report section.
If you have any ideas about additional functionality, just let me know!

[pombas]

Can u re-upload de excel file ?

Thanks

[Ovelhazinha]

the file not there anymore

[dispalt]

Oooh someone re-upload pls =)

[Heathen]

I've been editing the original, adding a few other useful tabs

https://www.dropbox.com/s/5njy7zw3vf...heet.xlsx?dl=0

[•Z•]

Dreddster, can you upload your version again? It looks awesome & I love using spreadsheets...