Results 1 to 13 of 13

Thread: HC Equip Calculator

  1. #1
    Iron Member Contributor Level 2
    Join Date
    Mar 2016
    Posts
    25
    Rep Power
    2

    HC Equip Calculator

    Hi everybody.

    i want to present my work i have done to finally sum up, what equip i need most for the heroes i focus on.

    My problem was, that i always was like: "Yeah need that to upg to R+1/2/3 (whatever)".
    K switched phone back, went online 2 hours later and didnt remember anything i said
    2 hours before . Maybe someone else sees himself in this. So got a bit chaotic in this and
    so i started to work on a solution in excel. Now i wanted to share it with you all, so i moved to Google sheets.

    For those that never touched Google sheets, here are some informations:
    You can download the file or best make a copy of it for your GoogleAccount. Why do that? Because everybody can now change the file i share,
    so your constellation will be overwritten by someone else, if you work with the shared file.

    There are apps for google sheets, so you dont need a PC (but believe me, handling this on a smartphone is a bit shitty, i suggest PC/Mac)
    For android users go here: Google Sheets for Android
    For iOS users go here: Google Sheets for iOS

    So may i present you: My Equip Calculator

    How the fuck do i use that?

    Easy thing. First there is a small tutorial in the sheets, but i will explain it here again:
    1) First you put on the left side how many items you have (not the pieces) in Column B.
    There is a nice overview ingame: Inventory -> Gear
    Pieces are not needed for now.
    2) Then you pick the Hero/es you like to focus on an upgrade.
    Then pick the current status of the hero (O,O+1...R+3,R+4) and uncheck the items he currently doesn't have.
    (Sadly you can't use correct checkboxes in goggle sheets, it is just a workaround in gsheets)
    Then choose the status you want the hero to have in future. And uncheck the boxes of the items you don't want to have him on this status
    (like gear that is only equippable at lvl 109 or so for R+4)
    3) Now you can see which items are needed most ranked after their Quality and then Quantity. This maybe helps you
    to decide which items to prefer picking at 40% Sale, which chapter to Raid, which item to queue in Raid, to forge or whatelse to get.
    And you always have an overview of what you have planned.

    Hope you enjoy my work and have fun with it.

    Any questions/suggestions? Ask here or leave a comment in original document.
    If you find a bug/prob contact me here or ingame or in Line (LineID:ezekielsc).

    FYI:
    I started with Orange +0 because i think the majority in this game, don't need to track equip below it.
    If i am wrong i maybe implement purple gear.
    Plans for the future are, that you see which is the best chapter to raid, to get the most out of your stamina
    (i know, Dragon's Pearl chapter will be a long time the top, but afterwards?).
    But for that, i need a lot of droprate information for the chapters.

    If you like you can join my FB group for news and links.
    https://www.facebook.com/groups/293075304432697/

    Greetings Ezekiel.
    Last edited by [SC] Ezekiel; 09-04-2017 at 07:54 AM. Reason: Editing
    My Equip Calculator: https://docs.google.com/spreadsheets/d/1PtxvIFcbyBu5_iW8LNQSxQ88PquL46pgwQ2_y6d__7w/edit?usp=sharing

  2. #2
    Diamond Member Contributor Level 9 [GY] Nader's Avatar
    Join Date
    Nov 2015
    Location
    Beirut, Lebanon
    Posts
    798
    Rep Power
    29
    Hi Ezekiel,

    I took me some time to analyse your work. Good Job, I know it took a lot of work.
    I have just minor comments:
    1- When you don't have the item (blanks square), the item name is hidden. isn't it better if the item name stays?
    2- For user equipment, you can associate each item by its level, and then add hero level as an optional field, then the system automatically assign all items that meet level criteria (of course user should still have the option to "unequip" the item).

  3. #3
    Iron Member Contributor Level 2
    Join Date
    Mar 2016
    Posts
    25
    Rep Power
    2
    Hi Nader ,

    1) Good idea. Think i will change that. First thought was, that i wanted something visible to see it is counted or not, because the checkbox is really small.
    I think i will keep the name but the backgroundcolor will change or something like that.
    2) As it is a young project, i just made it "quick". That is still on my To-Do-List.

    Thanks for your feedback.
    My Equip Calculator: https://docs.google.com/spreadsheets/d/1PtxvIFcbyBu5_iW8LNQSxQ88PquL46pgwQ2_y6d__7w/edit?usp=sharing

  4. #4
    Iron Member Contributor Level 2
    Join Date
    Mar 2016
    Posts
    25
    Rep Power
    2
    Hi,

    i changed the visuality a bit. Now if you uncheck an item, it gets light red. If you check one it is light green and bold.
    My Equip Calculator: https://docs.google.com/spreadsheets/d/1PtxvIFcbyBu5_iW8LNQSxQ88PquL46pgwQ2_y6d__7w/edit?usp=sharing

  5. #5
    Silver Member Contributor Level 5
    Join Date
    Nov 2016
    Posts
    141
    Rep Power
    5
    Good work.

    It is useful for people going 107

  6. #6
    Gold Member Contributor Level 6
    Join Date
    Dec 2015
    Posts
    183
    Rep Power
    8
    Very useful, thanks for sharing!

    Could you maybe add fields for almighty fragments?

  7. #7
    Iron Member Contributor Level 2
    Join Date
    Mar 2016
    Posts
    25
    Rep Power
    2
    Hi,
    @llamateizer2: definitely, because you can upg some Heroes to R4 4/5 with 107.

    @[V] homer: Is on my list. Only question is for me: How do i calculate them in? Do i subtract it from the most needed item? Or from the "rarest"?
    But how do i define what is the rarest? I mean for example: Corruption Mask. Is one of shittiest orange items to get, because the Stage where you can farm it, drops nothing really useful by side.
    Wraith Lorica is better. So if you need 8 Wraith Lorica and 3 Corruption Mask...i maybe would use the almighty fragments for Corruption Mask. Thats the dilemma

    Maybe any idea?
    My Equip Calculator: https://docs.google.com/spreadsheets/d/1PtxvIFcbyBu5_iW8LNQSxQ88PquL46pgwQ2_y6d__7w/edit?usp=sharing

  8. #8
    Diamond Member Contributor Level 9 [GY] Nader's Avatar
    Join Date
    Nov 2015
    Location
    Beirut, Lebanon
    Posts
    798
    Rep Power
    29
    Quote Originally Posted by [SC] Ezekiel View Post
    Hi,
    @llamateizer2: definitely, because you can upg some Heroes to R4 4/5 with 107.

    @[V] homer: Is on my list. Only question is for me: How do i calculate them in? Do i subtract it from the most needed item? Or from the "rarest"?
    But how do i define what is the rarest? I mean for example: Corruption Mask. Is one of shittiest orange items to get, because the Stage where you can farm it, drops nothing really useful by side.
    Wraith Lorica is better. So if you need 8 Wraith Lorica and 3 Corruption Mask...i maybe would use the almighty fragments for Corruption Mask. Thats the dilemma

    Maybe any idea?
    You can do it as an additional input, (select which items will use almighty stones). You could cap it to three items per color.
    Server 27 - 30. Guild Miracle.
    VIP 14 20 R3, 35 R2, 28 max trained heroes.
    Guild miracle is looking for a strong and active players to help in GT.
    Minimum requirement: VIP 11+ (20 max trained heroes, 40+ heroes >= R2), VIP 10- (25 max trained heroes, 50+ heroes >= R2).
    Not for the faint of heart. If you are looking for a brutal arena fights, welcome home.

  9. #9
    Bronze Member Contributor Level 3
    Join Date
    Jul 2015
    Posts
    41
    Rep Power
    4
    Can you please add more rows in heroes to up? i need more than 19 heroes and there are no formulas in the bottom after that. thank you for your lovely work! really appreciated!

  10. #10
    Iron Member Contributor Level 2
    Join Date
    Mar 2016
    Posts
    25
    Rep Power
    2
    Quote Originally Posted by [GY] Nader View Post
    You can do it as an additional input, (select which items will use almighty stones). You could cap it to three items per color.
    I think i will make another column, where you put in how much pieces you wanna use for that and that item. Will take a bit of work to do.

    Quote Originally Posted by jingx View Post
    Can you please add more rows in heroes to up? i need more than 19 heroes and there are no formulas in the bottom after that. thank you for your lovely work! really appreciated!
    Yeah i will do. Didn't thought someone is planning with more then 10 or so in the beginning .
    Edit: BTW i hope you copy the sheet, after filling up all these heroes. Because from time to time, i clear the complete sheet for new users and it would be sad,
    when everything from your input is deleted.

    Thank you all for your feedback. Helps me a lot to improve this.
    My Equip Calculator: https://docs.google.com/spreadsheets/d/1PtxvIFcbyBu5_iW8LNQSxQ88PquL46pgwQ2_y6d__7w/edit?usp=sharing

  11. #11
    Iron Member Contributor Level 2
    Join Date
    Mar 2016
    Posts
    25
    Rep Power
    2
    Hi stocked up to 30 heroes now. Or do you need more ?
    My Equip Calculator: https://docs.google.com/spreadsheets/d/1PtxvIFcbyBu5_iW8LNQSxQ88PquL46pgwQ2_y6d__7w/edit?usp=sharing

  12. #12
    Bronze Member Contributor Level 3
    Join Date
    Jul 2015
    Posts
    41
    Rep Power
    4
    Thanks..That is more than enough yeah, I will copy the sheet. I did halfway and noticed someone can edit too!

  13. #13
    Silver Member Contributor Level 4
    Join Date
    Nov 2016
    Posts
    99
    Rep Power
    4
    This is an awesome tool, thanks for sharing
    [SOL] Ocular, Server 102
    FB: Ocular HC

Posting Permissions

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