Celtic Heroes

Calculator updated to add the new skill formulas http://celticheroes.blogspot.com/2014/0 ... lator.html

Great, ty!

Need more ranger data Although, I guess no one would bother to get the crap skills to level 50 to work out their formula.

Thanks to Vultum's data, we now have this frenzy formula.

Level 50 Frenzy Attack Boost = 24.109*sqrt(Strength) + 10.698*sqrt(Melee Combat) + 301.75
Level 50 Frenzy Damage Boost = [0.026073*sqrt(Strength) + 0.010691*sqrt(Melee Combat) + 0.23222] * Physical Damage

The attack boost is a fixed number that depends only on strength and melee combat and nothing else.

Warriors, do not be worried by the very low numbers on the frenzy damage boost formula. The damage boost is a multiplier of your physical damage (elemental damage not included). It also depends on strength and melee combat.

With 993 strength, 1910 melee combat, and 190 pierce damage (30 pierce from dagger of bounty + 160 pierce from dark halberd), Vultum gains 289 damage by using frenzy.
If he unequips the dagger of bounty, he gains 243 damage with frenzy.
If he then equips a fiery axe of conquest (300 heat damage), he still gains 243 damage with frenzy (neglecting the strength bonus). This is because elemental damage doesn't affect frenzy.

So in conclusion, higher physical damage (pierce/crush/slash) = better frenzy damage boost.

The 150 strength from the axe didnt affect frenzy bonus?

The 150 strength from the axe didnt affect frenzy bonus?

Oops, I should correct that.

If he then equips a fiery axe of conquest (300 heat damage), he still gains 243 damage with frenzy (neglecting the strength bonus). This is because elemental damage doesn't affect frenzy.

Thanks.

Excuse the necro post.

New level 50 longshot formula for rangers!

Level 50 Longshot Damage = 81.594*sqrt(Dexterity) + 21.767*sqrt(Ranged Combat) + 459.38 + Auto Attack Damage

Credit to Bitey for the data:

Dex: 230, Ranged: 2458, dmg: 4414, auto damage: 1638
Dex: 530, Ranged: 2458, dmg: 4777, auto damage: 1360
Dex: 230, Ranged: 2158, dmg: 4150, auto damage: 1442

Nice but these weren't reverse engineered, they were just spotted in the code .

good work nonetheless to all who worked on this.

Nice but these weren't reverse engineered, they were just spotted in the code .

No, these were reverse engineered. I collect player skill data and solve for a skill formula. Had these been taken from the code, this topic would have been deleted for violating the ToS.

I'll show you how I did Longshot to prove my point. Bitey gave me this:

Dex: 230, Ranged: 2458, dmg: 4414, auto damage: 1638
Dex: 530, Ranged: 2458, dmg: 4777, auto damage: 1360
Dex: 230, Ranged: 2158, dmg: 4150, auto damage: 1442

We want to isolate the skill damage by subtracting auto damage from total damage:

Dex: 230, Ranged: 2458, skill dmg: 4414-1638 = 2776
Dex: 530, Ranged: 2458, skill dmg: 4777-1360 = 3417
Dex: 230, Ranged: 2158, skill dmg: 4150-1442 = 2708

The general form of a skill formula is this:

Skill dmg = a*sqrt(Stat) + b*sqrt(Ability) + c

We want to solve for a, b, and c. That's 3 unknowns, so we need 3 equations. Since Bitey gave me 3 lines, we have enough data to solve:

2776 = a*sqrt(230) + b*sqrt(2458) + c
3417 = a*sqrt(530) + b*sqrt(2458) + c
2708 = a*sqrt(230) + b*sqrt(2158) + c

I won't go through how to solve a system of 3 equations, but after doing some math you get:

a = 81.594
b = 21.767
c = 459.38

Which gives you the final equation:

Level 50 Longshot Damage = 81.594*sqrt(Dexterity) + 21.767*sqrt(Ranged Combat) + 459.38 + Auto Attack Damage

Nice but these weren't reverse engineered, they were just spotted in the code .

No, these were reverse engineered. I collect player skill data and solve for a skill formula. Had these been taken from the code, this topic would have been deleted for violating the ToS.

I'll show you how I did Longshot to prove my point. Bitey gave me this:

Dex: 230, Ranged: 2458, dmg: 4414, auto damage: 1638
Dex: 530, Ranged: 2458, dmg: 4777, auto damage: 1360
Dex: 230, Ranged: 2158, dmg: 4150, auto damage: 1442

We want to isolate the skill damage by subtracting auto damage from total damage:

Dex: 230, Ranged: 2458, skill dmg: 4414-1638 = 2776
Dex: 530, Ranged: 2458, skill dmg: 4777-1360 = 3417
Dex: 230, Ranged: 2158, skill dmg: 4150-1442 = 2708

The general form of a skill formula is this:

Skill dmg = a*sqrt(Stat) + b*sqrt(Ability) + c

We want to solve for a, b, and c. That's 3 unknowns, so we need 3 equations. Since Bitey gave me 3 lines, we have enough data to solve:

2776 = a*sqrt(230) + b*sqrt(2458) + c
3417 = a*sqrt(530) + b*sqrt(2458) + c
2708 = a*sqrt(230) + b*sqrt(2158) + c

I won't go through how to solve a system of 3 equations, but after doing some math you get:

a = 81.594
b = 21.767
c = 459.38

Which gives you the final equation:

Level 50 Longshot Damage = 81.594*sqrt(Dexterity) + 21.767*sqrt(Ranged Combat) + 459.38 + Auto Attack Damage

You don't seriously go through all three equations hand by hand right? There a programs than can do that would save you tons of work.

You don't seriously go through all three equations hand by hand right? There a programs than can do that would save you tons of work.

I'm guessing she uses an abacus.