Need help with missing formula

    Hi guys,


    I'm missing an important formula in my arsenal.


    1. I need the formula that calculates how damage is applied to a base weapon/armour when a prefix and/or a suffix is applied.

    When we add Trafans prefix to Long sword base weapon. We get on green unconditioned Trafans Long sword:


    From:

    Damage 3 - 4

    Level 4

    Durability 5917

    Conditioning 1480


    To:


    Damage 93 - 112

    Level 64

    Durability 94684

    Conditioning 23672


    Level plays a part of course.


    If someone knows it, please share it. If we figure this out, ill be able to make character/item planners on the fansite.


    Same for how durability and conditioning grows when the same happens.


    Michalus has already figured it out https://en.gladiatus-tools.com/equipment but he hasn't come back to me (I asked him a week ago)

    I only figured out formulas for a dagger and a spear because all the other weapons are basically useless but here you go, these are formulas straight from my personal excel calculator so if you create structured table with same column names you can just copy paste these:


    Dagger lower threshold:


    ((2*[@Level]- 1 + 2 * FLOOR.MATH(([@Level] - 1)/5))-1) + 4* [@[DMG_SCROLL]]


    Dagger upper threshold:


    (8+2*FLOOR.MATH([@Level]/2)+4 * FLOOR.MATH(([@Level]-1)/2)) + 4*[@[DMG_SCROLL]]


    @Level - level of the weapon(prefix + sufix + 1)

    @DMG_SCROLL - value of +dmg from both scrolls combined




    Spear lower threshold:


    (8+(2*[@[Level_value]]- 1 + 2 * FLOOR.MATH(([@[Level_value]] - 1)/5))-1) + 4* [@[DMG_SCROLL]]


    Spear upper threshold:


    (2*FLOOR.MATH([@[Level_value]]/2)+4 * FLOOR.MATH(([@[Level_value]]-1)/2)+20) + 4*[@[DMG_SCROLL]]


    @Level_value - same formula as the dagger but in order for the excel table to show the correct level of the weapon AND calculate properly I had to use an extra column with a different name :)


    If you want I can share you my excel table where you can check the results :)


    Oh also I forgot to mention that these formulas are for RED quality only. I didn't bother finding it out for every quality because I don't need it for the purpose of my calculator.

    Edited once, last by Dracco ().