Looking for some help making a damage calculator

[Solinar]

Ive got a good start, but I need some more info from all the parsers out there.

Im trying to make a damage calculator that will account for player and mob level and attack for different weapons.

Right now I think I have it pretty much nailed down for atk and weapons on the katta banker. I have been able to accurately predict DPS for any weapons combo and atk level (up to 1600ish, hard to get a 6+ hour parse with greater atk than that).

What I need is a significant length parse (4+ hours I'd say) including the following info for red and blue con mobs:
Mob level or con
ATK
Weapon(s) [note cant use same type weapon in both hands. Either use a 2h, or 2 different type 1h, or 1h + shield]
Total Damage
Total Damage from crits
Total # of crits
Total # of swings for each weapon type
Total # of hits for each weapon type
Total time of parse

EQcompanion will provide all of this.

I have been going through, and will continue to go through the other parses in this section to grab what info I can from them.

Thanks

Edit: Looking for warrior parses only at the moment. I dont have definitive data on which classes are on different damage tables at this time, so just starting with warriors.

[Thorbadin]

I was just thinking about that in fact.

Just today I got my old excel dmg calculator up and recheck some values. Problem I have is that 2-handers seem to give too high dmg atm compare to what we saw recently.

Can you give more infos on your formula please? Can also help validate them.

Let me put the numbers I use, they are estimate, and I think some are wrong (really unsure about the DW percentage for example).

Dual Wield % : 0.516666667
Double Attack % : 0.62
Hit percentage% : 0.6
haste % : 0.41
low hit dmg average : 0.4
medium hit dmg average : 0.67
high hit dmg average : 0.8
Max dmg multiplier : 5.95
tripple attack % : 0.05
crit % 0.05 : War crit % : 0.03
Punish Blade :0.08
Ambidextery : 0.08

The low/med/high hit are to simulate different atk lvl and can be eventually replaced by direct atk.

I didn't include flury yet and I don't think I have ferocity %. Any more infos on that? WHen you flurry do you always get to try for 2 more hits?

I also attached the excelt sheet if you want to look at it (rename to xls because the board can't blah blah). Really easy to play with the numbers, still pretty basic.

The main thing would be to explain why 2-handers are too low, then it should be pretty straighforward from there.

Thorbadin
Triton

[Solinar]

Right now Im basing it on warriors with maxxed offensive skills only. After I get that nailed down I can start changing the rest.

For a warrior with maxxed offensive skills.

1.80 attacks per round from main hand.
1.53 attacks preround from offhand
1.85 attacks per round from a 2h (due to PB)

Hit percentage is based on mob/player level.

Multiplier for average damage, for a level 1 katta banker, is very close to atk/450. For example

1400 atk, 16/20 weapon
1400/450=3.11
average hit = 3.11*16+13 = 62.8

increasing to 1600 atk
1600/450=3.56
average hit = 3.56*16+13 = 69.9

Id like to figure out the relationship between mob/player levels and hit rate, and mob/player levels and hit multiplier.

[Graal the Dorf]

There are other variables that make the hit rate and hit multiplier fuzzier. Different mobs of the same level have different avoidance/mitigation values.

thorbadin, DW rate is 85%, not 52%
1.80 attacks per round from main hand.
1.53 attacks preround from offhand

1.53 total attacks from offhand per round/1.80 double attack rate = 0.85=85%

[Solinar]

There are other variables that make the hit rate and hit multiplier fuzzier. Different mobs of the same level have different avoidance/mitigation values.

Mitigation? yes. Avoidance? maybe not. I cant recall a specific mob I have ever fought that avoided noticably more hits than any other mob if its level. Im inclined to believe that mob evasion of your attacks is based purely on level ratio and nothing else.

[Rajsy]

Can take a look at my formula/parses that I made. It takes into account single,double,triple, crits, atk(somewhat), haste, damage bonus and so on.

http://forums.interealms.com/ranger/showthread.php?threadid=27733

[Rajsy]

For those that doen't like links I'll repost it here instead. Here it comes:

You might remember my last thread on weapon comparison formulas. If you dont then check this thread out

http://forums.interealms.com/ranger...p?threadid=7665

Well I have improved it by using data from parses now. The values I wanted to parse were dual wield chance, double attack chance, triple attack chance and some average hit values. I used EQ Companion to show double and triple attack percentages.

I have all offensive AAs for reference.

To measure dual wield chance I used two weapons with the same delay but different types(crush,slash). I compared the number of slashes with the number of crushes and could decide the dual wield chance. The double attack chance is shown in the parser.

15 20 1hb primary, 13 20 1hs offhand in Sol Ro, 2300-2500ish swings per weapon:
Dual Wield chance: 90%
Single attacks: 33%
Double attacks: 67%
Triple attacks: 0%

Warders Ornate Broadsword in Sol Ro, 2200ish swings:
Single attacks: 33%
Double attacks: 61%
Triple attacks: 6%

An interesting result to note is that PB3 does not make single hits into double hits but only double hits into triple hits.

I checked some average hit percent values without avatar and with avatar and got:
1770ATK: AH=0.615 (with avatar)
1620ATK: AH=0.583 (without avatar)

The hit/(hit+miss) ratio was 0.6 for all parses.

Now that I had all these values I got to work and made a new weapon comparison formula that shows approximate DPS for a planar ranger when fully hasted.

AH=Average hit percent
DW=Dual wield percent. 100% for a primary weapon.
SA=Single attack percent
DA=Double attack percent
TA=Triple attack percent
Dmg=Damage for the weapon
Dly=Delay for the weapon
DB=Damage bonus
LR=Level ratio for damage calculation. 5.7 at lvl 60 and 5.92 at lvl 65, approximately.
Crit=The chance to make a critical hit. Forgot to check my logs on this one, but I guess it varies with dex so I will have to check with max dex sometime.

All percent values are in the range 0 to 1 with 1 being 100% and 0 being 0% and 0.5 being 50%. I hope you get my meaning. Haste works the same in this formula with 1 being 100%.

Anyway here is the formula for one weapon. When dual wielding just add your weapons together and be sure to apply the correct DW value to your offhand.

Damage per second = (1+Haste) * (1+0.7*Crit) * (0.6*DW*(SA+DA*2+TA*3)*(LR*AH*Dmg+DB)) / (0.1*Dly)

To simplify this a bit for comparison purposes only we set Crit=0 and haste=0 and put together the SA DA TA values for 1h and 2h weapons. This makes the formula correct only for persons with all offensive AAs. Also merge with the hit percent(0.6) to simplify as much as possible.

Comparison Value 1hander = (1.002*DW*(LR*AH*Dmg+DB)) / (0.1*Dly)

Comparison value for 2hander = (1.038*(LR*AH*Dmg+DB)) / (0.1*Dly)

Well anyway an example for me is Warders ornate broadsword 45 35 with 38 damage bonus. Plug this into the damage per second formula with say 5% crits(0.05), 100% haste(1), AH=0.6(same as SolRo parse) and we get:

WoB DPS = 121.45

Assuming crit chance is 10% instead of 5%(forgot to parse) then we get:

Wob DPS = 125.56

This is consistent with parses as I always get about 125 DPS from my WoB when im fully hasted.

Using AHB 16 19 offhand and agnarr sword 17 20 main we get if using 10% crits:

AHB off DPS= 57.725
Agnarr main DPS = 78.678
Summed DPS = 136. 4

This is also consistent with my parses as I outdamage WoB with agnarr AHB combo.

Now a sword I dont own SEWS. 45 30 with DB=36
SEWS DPS = 140

Make of this what you will but I will use it to compare weapons all the time. If you have higher ATK than me then you need to increase the AH value some to match the DPS you will get from your weapons. The AH value can also change depending on the mobs AC.