Home
News
What's new
New posts
Latest activity
Authors
Forums
New posts
Search forums
Wiki
Exiled Kingdoms Wiki
Archaelund Wiki
What's new
New posts
Latest activity
Members
Registered members
Current visitors
Log in
Register
What's new
Search
Search
Search titles only
By:
New posts
Search forums
Menu
Log in
Register
Install the app
Install
Forums
Exiled Kingdoms
General Forum
Some questions about armor and resistance
JavaScript is disabled. For a better experience, please enable JavaScript in your browser before proceeding.
You are using an out of date browser. It may not display this or other websites correctly.
You should upgrade or use an
alternative browser
.
Reply to thread
Message
<blockquote data-quote="KYTX" data-source="post: 44222" data-attributes="member: 13162"><p>I can't be bothered switching to a windows machine to do a VBA script. I'm using Excel for Android, so only equasions, no cyclic algorithms. At first I thought it'd be hard but I found a workaround to the hardest part. It looks ugly af but it seems to work.</p><p></p><p>Main issue was working out probabilities for damage taken, given the 20% mechanic, so dispersion was not the same function all the time. Then I threw the whole (well, most of) the probability theory stuff out because all the random values are discrete (thanks to his rounding). Instead I have a large (101x101) table with all Armor and all Attack values from 0 to 100. For each of 10k+ cell I wrote a simple IF clause that reflects the 20% min damage mechanic. Now, when you know specific weapon's min and max attack and your min/max armor, you get a rectangular subset of the table with all the possible damages. Find average of that and that'll be your expected physical DPH. Add that to elemental DPH which is easy to count, times weapon speed/10 and you have the expected DPS of a given weapon against a given target.</p></blockquote><p></p>
[QUOTE="KYTX, post: 44222, member: 13162"] I can't be bothered switching to a windows machine to do a VBA script. I'm using Excel for Android, so only equasions, no cyclic algorithms. At first I thought it'd be hard but I found a workaround to the hardest part. It looks ugly af but it seems to work. Main issue was working out probabilities for damage taken, given the 20% mechanic, so dispersion was not the same function all the time. Then I threw the whole (well, most of) the probability theory stuff out because all the random values are discrete (thanks to his rounding). Instead I have a large (101x101) table with all Armor and all Attack values from 0 to 100. For each of 10k+ cell I wrote a simple IF clause that reflects the 20% min damage mechanic. Now, when you know specific weapon's min and max attack and your min/max armor, you get a rectangular subset of the table with all the possible damages. Find average of that and that'll be your expected physical DPH. Add that to elemental DPH which is easy to count, times weapon speed/10 and you have the expected DPS of a given weapon against a given target. [/QUOTE]
Insert quotes…
Verification
Post reply
Forums
Exiled Kingdoms
General Forum
Some questions about armor and resistance
Exiled Kingdoms
This site uses cookies to help personalise content, tailor your experience and to keep you logged in if you register.
By continuing to use this site, you are consenting to our use of cookies.
Accept
Learn more…
Top