Posts by Dracco

  • Need help with missing formula

    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.

  • Gladiatus-tools

    Hello,


    today I wanted to visit gladiatus-tools.com but the site is unreachable. Does anyone know how long it's been like this? Hope it's just a temporary problem.