It is currently Wed Dec 11, 2019 7:44 pm

All times are UTC




Post new topic  Reply to topic  [ 14 posts ]  Go to page 1 2 Next
Author Message
PostPosted: Sat Feb 25, 2017 5:16 pm 
Offline
Loreseeker
User avatar

Joined: Mon Feb 06, 2017 9:42 am
Posts: 79
Has thanked: 8 times
Been thanked: 19 times
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.

Image

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*
[+] SPOILER
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*
[+] SPOILER
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*
[+] SPOILER
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*
[+] SPOILER
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*
[+] SPOILER
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.

_________________
Exiled Kingdoms Trait Planner
http://www.exiledkingdoms.com/forum/viewtopic.php?f=4&t=10171


Last edited by Roukan on Tue May 23, 2017 12:37 pm, edited 22 times in total.


Top
   
PostPosted: Sat Feb 25, 2017 5:32 pm 
Offline
User avatar

Joined: Mon Nov 07, 2016 3:59 am
Posts: 579
Has thanked: 18 times
Been thanked: 42 times
Roukan wrote:
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?


Top
   
PostPosted: Sat Feb 25, 2017 5:36 pm 
Offline
Loreseeker
User avatar

Joined: Mon Feb 06, 2017 9:42 am
Posts: 79
Has thanked: 8 times
Been thanked: 19 times
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.

_________________
Exiled Kingdoms Trait Planner
http://www.exiledkingdoms.com/forum/viewtopic.php?f=4&t=10171


Top
   
PostPosted: Sat Feb 25, 2017 8:15 pm 
Offline
EK Developer, Admin
User avatar

Joined: Sat Feb 28, 2015 11:00 am
Posts: 5813
Has thanked: 384 times
Been thanked: 695 times
Looks great, but shouldn't this be in the general forum? I'd say it's EK-related :D

_________________
Image


Top
   
PostPosted: Sat Feb 25, 2017 9:45 pm 
Offline
Loreseeker
User avatar

Joined: Mon Feb 06, 2017 9:42 am
Posts: 79
Has thanked: 8 times
Been thanked: 19 times
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.

_________________
Exiled Kingdoms Trait Planner
http://www.exiledkingdoms.com/forum/viewtopic.php?f=4&t=10171


Top
   
PostPosted: Sun Feb 26, 2017 6:38 am 
Offline
Loreseeker
User avatar

Joined: Mon Feb 06, 2017 9:42 am
Posts: 79
Has thanked: 8 times
Been thanked: 19 times
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.

_________________
Exiled Kingdoms Trait Planner
http://www.exiledkingdoms.com/forum/viewtopic.php?f=4&t=10171


Top
   
PostPosted: Wed Mar 01, 2017 1:33 am 
Offline
Loreseeker
User avatar

Joined: Mon Feb 06, 2017 9:42 am
Posts: 79
Has thanked: 8 times
Been thanked: 19 times
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.

_________________
Exiled Kingdoms Trait Planner
http://www.exiledkingdoms.com/forum/viewtopic.php?f=4&t=10171


Last edited by Roukan on Wed Mar 01, 2017 8:10 am, edited 3 times in total.


Top
   
PostPosted: Wed Mar 01, 2017 3:14 am 
Offline
User avatar

Joined: Mon Nov 07, 2016 3:59 am
Posts: 579
Has thanked: 18 times
Been thanked: 42 times
This really is phenomenal work


Top
   
PostPosted: Wed Mar 01, 2017 5:25 pm 
Offline

Joined: Mon Jan 11, 2016 9:08 pm
Posts: 1317
Has thanked: 180 times
Been thanked: 92 times
Really nice work, can it be included in wiki somehow?


Top
   
PostPosted: Wed Mar 01, 2017 6:41 pm 
Offline
Loreseeker
User avatar

Joined: Mon Oct 31, 2016 7:10 am
Posts: 1009
Location: Germany
EK Translator: German
Has thanked: 20 times
Been thanked: 173 times
Alan_SP wrote:
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
   
Display posts from previous:  Sort by  
Post new topic  Reply to topic  [ 14 posts ]  Go to page 1 2 Next

All times are UTC


Who is online

Users browsing this forum: No registered users and 9 guests


You cannot post new topics in this forum
You cannot reply to topics in this forum
You cannot edit your posts in this forum
You cannot delete your posts in this forum
You cannot post attachments in this forum

Search for:
Jump to:  

Powered by phpBB® Forum Software © phpBB Limited
@2016 4DGames. All rights reserved

[ GZIP: Off ]