Page 1 of 2 12 LastLast
Results 1 to 15 of 26

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

  1. #1
    Platinum Member Contributor Level 8 Dreddster's Avatar
    Join Date
    Nov 2014
    Posts
    400
    Rep Power
    20

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

    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

  2. #2
    Silver Member Contributor Level 5 tdhoang89@yahoo.com's Avatar
    Join Date
    Dec 2014
    Posts
    135
    Rep Power
    0
    Wow :-o

    Thank you for your hard work man

  3. #3
    Silver Member Contributor Level 4 Neph's Avatar
    Join Date
    Nov 2014
    Posts
    93
    Rep Power
    10
    Thank you very much Sir.

  4. #4
    Prime Leader Contributor Level 11
    Join Date
    Nov 2014
    Posts
    2,135
    Rep Power
    80
    Very nice. How can I change the order of the heroes? Do I just need to retype everything?

  5. #5
    Platinum Member Contributor Level 8 Dreddster's Avatar
    Join Date
    Nov 2014
    Posts
    400
    Rep Power
    20
    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:

  6. #6
    Diamond Member Contributor Level 9 Ferico's Avatar
    Join Date
    Oct 2014
    Location
    Goblin Merchant
    Posts
    748
    Rep Power
    32
    Dreddstar, you da the real mvp! Very much helpful to everyone, indeed. Thanks a lot!

  7. #7
    Bronze Member Contributor Level 3
    Join Date
    Dec 2014
    Posts
    44
    Rep Power
    0
    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

  8. #8
    Iron Member Contributor Level 1
    Join Date
    Oct 2014
    Location
    Italy
    Posts
    9
    Rep Power
    7
    Quote Originally Posted by nyak View Post
    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).

  9. #9
    Gold Member Contributor Level 6
    Join Date
    Oct 2014
    Posts
    162
    Rep Power
    12

    Awesome

    Someone please give this guy a medal

  10. #10
    Platinum Member Contributor Level 8 Dreddster's Avatar
    Join Date
    Nov 2014
    Posts
    400
    Rep Power
    20
    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!

  11. #11
    New Comers
    Join Date
    Feb 2015
    Posts
    2
    Rep Power
    7
    Can u re-upload de excel file ?

    Thanks

  12. #12
    Bronze Member Contributor Level 3
    Join Date
    Nov 2014
    Posts
    40
    Rep Power
    0
    the file not there anymore

  13. #13
    Iron Member Contributor Level 2
    Join Date
    Feb 2015
    Posts
    22
    Rep Power
    7
    Oooh someone re-upload pls =)

  14. #14
    Gold Member Contributor Level 6 Heathen's Avatar
    Join Date
    Dec 2014
    Posts
    168
    Rep Power
    12
    I've been editing the original, adding a few other useful tabs

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

  15. #15
    New Comers Contributor Level 1
    Join Date
    Jan 2015
    Posts
    6
    Rep Power
    7
    Dreddster, can you upload your version again? It looks awesome & I love using spreadsheets...

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •