Trait planner, armor optimizer, DPS calculator

Roukan

Loreseeker
Joined
06/02/2017
Messages
79
I'd initially had a really messy version made for personal use. Tidied it up a little to make it more accessible.

This spreadsheet rounds down the non-existent stat increases from some traits if they're odd numbered, rounds them up when paired with stat-boosting equips, does comparisons across the next two levels of trait investment, etc.

Ah, it's a lot to say...so here's a picture in place of a description. Simply, you type your character details into the orange cells, and you get recommended a trait that gives you the most bang for your AP.



For those who are interested in comparing the actual DPS differences between fast and slow weapons, 2 handed vs. light, etc., this one factors in enemy armor and resistances for a more realistic prediction of DPS. Default target value is set to the unweakened Undermother's stats, the stuff of nightmares... Well, have fun with that. Orange cells are required inputs which are used for calculations, yellow ones can be filled with whatever.

Oh, and I hope you lore seekers don't mind too much that I just went and borrowed your weapon table from the wiki for this. I apologize for that.

It works just fine on my phone, so why not give it a try?

*Update*
Re-did the formulas, corrected some errors, tidied it up a little.
Added the new Battle Prayer and Body Development advanced skills
Updated the weapon table with new weapons
Added armor optimiser

New link to updated file. https://1drv.ms/x/s!AhA-BFYn_0aKgRp35LncOOXg-icb

Separate version for companions. https://1drv.ms/x/s!AhA-BFYn_0aKgRxfslyBcXLZu-JY

*About the armor optimizer*
Calculations involve the use of a "toughness" variable which is the sum of the percentages of damage reduced across all
relevant elements. As for what damage type is relevant, that's for you to decide. Just fill up the orange boxes of unmitigated damage received with numbers representing the amount of damage you expect to receive; or leave it blank if you don't want it included in calculations.

Note that it works best with exact values, e.g. if gearing up to reduce the Broken Crown of Tol life drain, set death damage to 12. Default values are set to the highest average damage of each category you'd expect to find on a normal play through. Spirit is listed as 100 to more accurately represent the flooring of resistances in the game. Setting an element at a low value causes the optimizer to be more parsimonious with calculations; ideal for identifying the exact amount of resistance required to shave off an extra point of damage. Setting them to 100 would cause the optimizer to generously count any increase in resistance % as an increase in toughness.

Recommendations for the best armor are based on overall toughness. As there are diminishing returns to elemental resistance, the optimizer dynamically changes recommendations based on your current total resists.

If it stubbornly recommends an armor that you just can't or won't use, you can increase the number in the 'Xth best option' box till you find a suitable armor.

As for the contributions to defensive stats from traits, input is taken from the trait planner tab, so remember to fill that up too.

*Note* Yeah, technically, spirit damage doesn't really apply against player characters, but let's include it in the toughness calculation kay?

*Rationale for default stat weights*
The default stat weights and stat inclusions are set to create a jack of all trades-type of character. One that gets the most out of all stats.

Atk and Armor are set at 1 as increases in those two stats from traits, with the exception of 2 handed weapons, increase in increments of 1. Without tilting a bias towards any particular stat, modifying the basic increments in either of those two stats to the same value would serve as a basic standard of comparison; i.e. by default stat weights of 1, 1 ATK is worth the same as 1 Armor. It could be any number really; 1 is used for simplicity sake.

HP and Mana increase by increments of "character level" per trait level. At max character level of 25, HP and Mana, if increased by traits, increase by increments of 25 at a time. With an added 5 HP increase per trait point in the case of HP from endurance, or 0.2 of a 1 point stat stat weight at max level. This extra 0.2 from endurance is kept constant across all character levels to avoid an early-game overvaluing of endurance. Following the previous standards of setting basic increments at stat weights of 1, each level dependent increase in HP/Mana matches the stat weights of the basic increments of Atk and Armor from traits. I.e. current level no. of HP/Mana = 1 Atk = Armor.

TLDR, the default stat weights are set to numbers that assign the same relative value to the basic increments in each stat from increases in trait level. By setting stat weights to the same value, you're placing each basic increment at equal value.

*Notes on usage of multiple weapon types and their effect on stat weights*
For the builds that involve the use of multiple weapon types, e.g. an archer-rogue who keeps a dagger on hand for close combat situations, you can check the cells for both weapons with "Yes". This results in an overvalued Atk stat due to there being an extra source of Atk input, i.e. (Ranged Atk + HP + Armor) vs. (Ranged Atk + Light Weapon Atk + HP + Armor).

To correct for this overvalued Atk, consider dividing the stat weight of Atk by the number of added weapons.

I.e. From the default stat weight distribution,

Stat weights for 1 weapon,
Atk: 1
HP: 1
Armor: 1

Stat weights for 2 weapons,
Atk: 0.5
HP: 1
Armor: 1

Stat weights for 3 weapons (seriously?!),
Atk: 1
HP: 3
Armor: 3

*On stat inclusion*
In the event that you do not consider a particular stat to have any value in your character build, e.g. HP stat in a "Healer" build or HP & Armor in a "Glass Cannon", simply set the respective stat inclusion cell to "No". All increases in the excluded stat would not be used in calculating the relative gains/AP for trait recommendations.

Alternatively, setting the stat weight to 0 does the same thing.

*Sample stat weights for different purposes*
Glass Cannon
Atk: 1
HP: 0
Armor: 0

Attack-oriented
Atk: 1
HP: 0.5
Armor: 0.5

Pure Tank
Atk: 0
HP: 1
Armor: 1

HP Sponge
Atk: 0.5
HP: 1
Armor: 0.5

Dedicated Healer
Atk: 0
HP: 0
Armor: 0.5
Mana: 1

Just some of the many ways to use stat weights to optimize your own personalized character.
 

Sounkeng

Member
Joined
07/11/2016
Messages
579
Re: A fun little trait planner for the min-maxers

Roukan":3f32mhms said:
I'd initially had a really messy version made for personal use. Tidied it up a little to make it more accessible.

This spreadsheet rounds down the non-existent stat increases from some traits if they're odd numbered, rounds them up when paired with stat-boosting equips, does comparisons across the next two levels of trait investment, etc.

Ah, it's a lot to say...so here's some pictures in place of a description. Simply, you type your character details into the blue cells, and you get recommended a trait that gives you the most bang for your AP.

It works just fine on my phone, so why not give it a try?

https://1drv.ms/x/s!AhA-BFYn_0aKcp3olE9ePwL_nEw
Nice work!

Quick question about the last 3 rows. The way I read them the first is the gain I get for the next point. The second if I were to boost that stat by 2 and the last row is if I were to boost it by 3?
 

Roukan

Loreseeker
Joined
06/02/2017
Messages
79
Re: A fun little trait planner for the min-maxers

Actually, the first one isn't really important; just for those who want to see what their already-invested AP points were worth. The bottom two gain/APs are the ones used for calculation. It predicts 1 point ahead of the current trait level, then 2 points ahead; just to account for the possibility that you get more out of investing enough to land on an even trait number.
 

DavidBVal

Developer
Staff member
Administrator
Joined
28/02/2015
Messages
6,011
Re: A fun little trait planner for the min-maxers

Looks great, but shouldn't this be in the general forum? I'd say it's EK-related :D
 

Roukan

Loreseeker
Joined
06/02/2017
Messages
79
Re: A fun little trait planner for the min-maxers

Oh yeah, maybe the general forum would be more appropriate. Guess I just saw the programming tag figured that pet projects would go here. Err...if possible, could a mod help me move this topic over to general forum? Many thanks.
 

Roukan

Loreseeker
Joined
06/02/2017
Messages
79
Re: A fun little trait planner for the min-maxers

Spotted an error in the STR HP formula (forgot to set it to multiply by character level); so sorry about that. Anyway, It's been corrected. Checked it once through and didn't find any weird or missing results this time.
 

Roukan

Loreseeker
Joined
06/02/2017
Messages
79
Re: A fun little trait planner for the min-maxers. Added a DPS calculator

Added a DPS calculator to the trait planner file. This one factors in the target's armor and resistances to give a more realistic prediction of average DPS. Great for finding out which weapon type is better for your build; things such as STR 2 handed vs. AGI light weapon, or Jester's Bow vs. Mist Hunter's Bow, etc.

Damage and elemental damage values are rounded down under normal circumstances, damage is rounded up when below minimum possible value. Most of the impossible scenarios such as a a warrior with Arbenos' Might have been set to be excluded from the calculations; or at least I hope they have. Let me know if you guys get strange values or errors, alright?

Thanks, and enjoy.
 

Sounkeng

Member
Joined
07/11/2016
Messages
579
Re: A fun little trait planner for the min-maxers. Added a DPS calculator

This really is phenomenal work
 

Alan_SP

Staff member
Administrator
Joined
11/01/2016
Messages
1,512
Re: A fun little trait planner for the min-maxers. Added a DPS calculator

Really nice work, can it be included in wiki somehow?
 

MikeB

Staff member
Loreseeker
Joined
31/10/2016
Messages
1,092
Location
Germany
Re: A fun little trait planner for the min-maxers. Added a DPS calculator

Alan_SP":3nsntqlx said:
Really nice work, can it be included in wiki somehow?
I already thought about ways to do it, but couldn't come up with a simple solution. I will probably start a separate thread in the Wiki forum so we may discuss the technical possibilities (Mighty M3lkor, we need your help!).

Provided, of course, Roukan agrees to use or publish this fine piece of work on the Wiki in the first place.

EDIT: Moved all technical discussions to the Wiki forum...
 

Top