[TERA PC & Console] En Masse is closing, but TERA lives on! We will continue to support TERA PC (NA) and TERA Console until service is transferred. Stay tuned for more information.
[TERA Console] The Grotto of Lost Souls update (v85) is now live! Read the patch notes here: https://bit.ly/TERACon_v85

[TERA PC] The 64-bit update (v97) is now live. Check out all the changes delivered on August 11 here: https://bit.ly/tera64_patchnotes
[TERA PC & CONSOLE] Summerfest Part 2: The Beach Bash is on from August 11 until September 1! Participate in event activities to earn tokens redeemable for costumes, consumables, mounts, and more! Details: https://bit.ly/tera_sf20

Gear Planner

«1

Comments

  • KetothKetoth ✭✭✭✭
    Updated:
    -Added new gear set lilith and rakelith (names based on yosha translation)
    -Added new jewerly set (Still waiting for names)
    -Chest roll working now
  • UltemeciaUltemecia ✭✭✭
    Oh, now that right there is cool af. Good job with this!
  • KetothKetoth ✭✭✭✭
    edited July 2016
    Update.: Impossible situations will be highlight in red (duplicate weapon rolls,weapon crystals or +15 in gear pieces that cant be awaken).

    Adding dyads secondary effects soon

    Any error please report here or make a comment on the spreadsheet.
  • can you please add conflate?
  • KetothKetoth ✭✭✭✭
    navjack27 wrote: »
    can you please add conflate?

    Added the updated version that Ktera that ktera have now.
  • Idi0ticGeniusIdi0ticGenius ✭✭✭✭✭
    edited August 2016
    @Ketoth I really love this and all your work. I'm sorry for digging through your sheet (if that is a problem) but when I recommended this to someone to plan their gear they had similar issues so I couldn't help but to look into your sheet; so I just wanted to point out:

    1. Conflate belt is giving out wrong defense value, probably because

    =VLOOKUP(C35;Plan1!$DB$85:$DN$89;4) should be something like =VLOOKUP(C35;Plan1!$DB$85:$DN$90;4)

    2. Slaughter, Imperator, Conflate, Lilith, and VM8 Sleeves (Cloth Glove) have 12 Endurance as a re-rollable line.

    3. Slaughter, Imperator, Conflate, Lilith, and VM8 Grieves/Boots/Shoes have Replenish 2% MP every 5 seconds re-rollable line. Only Starfall from this sheet has 1% MP replenishment every 5 second.

    This one isn't too important, but healer jewelries are missing and I guess there's really no need for it. However, if someone wants to produce a build in certain way, such as using Dreadnaught accessories (or even time), then they'd have to manually do that-- which they could, if they take their time since the formulas are all in the sheet. There have been healer jewelry changes where all healing jewelries were nerfed as well as additional 199 / 217 / 256 Healing lines to Time, Dreadnaught, Gate/Vain, Maze, and new jewleries.

    But aside from those minor errors, which is understandable with this amount of impressive work, I want to thank you for creating such spreadsheet.
  • DivineRemnantDivineRemnant ✭✭✭
    edited August 2016
    This is a very nice spreadsheet! Well done! If you have the chance, could you add grounding vyrsks to the dropdown for armors? And as Idi0ticGenius mentioned, having the 12 endurance rerollable stat for cloth gloves would be great as well!
    Keep up the good work! :hurrah:
  • KetothKetoth ✭✭✭✭
    @Ketoth I really love this and all your work. I'm sorry for digging through your sheet (if that is a problem) but when I recommended this to someone to plan their gear they had similar issues so I couldn't help but to look into your sheet; so I just wanted to point out:

    1. Conflate belt is giving out wrong defense value, probably because

    =VLOOKUP(C35;Plan1!$DB$85:$DN$89;4) should be something like =VLOOKUP(C35;Plan1!$DB$85:$DN$90;4)

    2. Slaughter, Imperator, Conflate, Lilith, and VM8 Sleeves (Cloth Glove) have 12 Endurance as a re-rollable line.

    3. Slaughter, Imperator, Conflate, Lilith, and VM8 Grieves/Boots/Shoes have Replenish 2% MP every 5 seconds re-rollable line. Only Starfall from this sheet has 1% MP replenishment every 5 second.

    This one isn't too important, but healer jewelries are missing and I guess there's really no need for it. However, if someone wants to produce a build in certain way, such as using Dreadnaught accessories (or even time), then they'd have to manually do that-- which they could, if they take their time since the formulas are all in the sheet. There have been healer jewelry changes where all healing jewelries were nerfed as well as additional 199 / 217 / 256 Healing lines to Time, Dreadnaught, Gate/Vain, Maze, and new jewleries.

    But aside from those minor errors, which is understandable with this amount of impressive work, I want to thank you for creating such spreadsheet.

    1-fixed; when i add a new gear set, there so many cell that need change, that sometimes i miss some of them

    2- added;

    3-fixed (more or less)

    4- added healer rolls.

    the problem that adding old jewerly is that i will have to add the old crit and power also. This will add so many items in the box, that maybe will cause some confusion. My intention is just keep between 2-3sets( one older, the one we have now, and the next one when ktera get).

    for gears, when vm9 comes out i will remove slaughter and starfall, since will not be to get them again

    This is a very nice spreadsheet! Well done! If you have the chance, could you add grounding vyrsks to the dropdown for armors? And as Idi0ticGenius mentioned, having the 12 endurance rerollable stat for cloth gloves would be great as well!
    Keep up the good work! :hurrah:


    added grounding vykrs

    I also added the effect of charms / healer's buffs and stance in the stats
  • Wow, so fast! Thank you! Keep it up :smile:
  • KetothKetoth ✭✭✭✭
    edited August 2016
    I dont know if this will work when creating a copy. But here it is:
    I added a number in the bottom of the planner that will show what is choice ratio of crit/power.

    If your ratio choice is higher than the number showed, you choose crit, if is less you choose power.
    I used Enrage uptime = 50% and back time =90%. Also it doesnt consider carving glyphs effects

    Maybe i add in future a option to change this values

  • Hi, Can you say me what is the good crit/power ratio? I cant understand yet. Thanks o/
  • KetothKetoth ✭✭✭✭
    edited August 2016
    dave27 wrote: »
    Hi, Can you say me what is the good crit/power ratio? I cant understand yet. Thanks o/

    If you pull all your gear, and for example are missing 1 etch for weapon, and you want decide if 10 power is better than 18 crit.

    this ratio is 1,8.

    you get from the calculator a ratio of 1,5. since the number is lower than 1,8, the 18 crit will be a better option, but if the planners showed 2 instead of 1,5 , the 10 power would be better. But this doesn't consider glyphs yet
  • Err, I'm dumb and know nothing about spreadsheets. Is this only for archer? I can't seem to make the first page show any other class. All in all I'm confused but I really want to understand this because it looks really useful and helpful! I'm sorry for my ignorance ahh.
  • KetothKetoth ✭✭✭✭
    Err, I'm dumb and know nothing about spreadsheets. Is this only for archer? I can't seem to make the first page show any other class. All in all I'm confused but I really want to understand this because it looks really useful and helpful! I'm sorry for my ignorance ahh.

    Make a copy in your drive, should have a arrow on right side of the cell to change the class
  • Ah, thank you!
Sign In or Register to comment.