DPS Spreadsheets

**Motenten** · 2012-09-04 15:25

The WS set doesn't account for a lack of Dual Wield when figuring out WS TP returns with None selected as the offhand on the Data Sheet (D+E, 54+55).

Whoops. Fixed.

You may want to add Airy Buckler and Kudzu Aketon to the DNC sheet.

Done.

**pchan** · 2012-09-04 16:21

Suggesting capping crit rate ratio at 3 for 2 handed DDs. At capped pdif a crit is worth 3.25 (+44%) when it's ~ 3/2.25=+33%. Free 10% crit damage for lol dragoons.

**Motenten** · 2012-09-04 16:31

Line 80 of the data page (drg), it caps the crit portion of the damage (1+cRatio) at 3. Pretty sure that limit is applied to all other 2-handed DDs as well, but will try to check as I upgrade them.

**pchan** · 2012-09-04 17:21

I was checking ukko's fury damage calculation lines and you use stuff like

Code:

 (1-$L$10)*$J$14+$L$10*(1+$J$14)*$M$10

I think it's the same for drakesbane too.

1+J14 would be 1 + cratio even if cratio is 2.25 ?

edit : yes melee crit ratio is capped at 3, but not ws it seems.

**Martel** · 2012-09-04 20:28

Originally Posted by Motenten

Total duration of AM3 is 120 seconds

Mythic AM3 duration is 180 seconds. Since the lvl 80 version I think.

**Motenten** · 2012-09-04 20:58

edit : yes melee crit ratio is capped at 3, but not ws it seems.

Ah, yeah. Mistake. Fixed for drg, will fix on others as I get to them.

Mythic AM3 duration is 180 seconds. Since the lvl 80 version I think.

Eh, completely misread that, not sure how. Well, adjust totals as appropriate, then. Just makes the aftermath better than I what I considered initially.

**Motenten** · 2012-09-05 09:01

On to war next, as it's a popular job, and not too complicated.

1) Fixed max crit cRatio in melee and weaponskill calculations.
2) Added Hrafn/Huginn gear; Wanion belt
3) Converted to new Setup page
4) Added AM3

**pchan** · 2012-09-05 09:51

Thanks, found 2 missing attack trait values ; war is missing attack bonus 2 (you give 10 att bonus) and DRG has no attack bonus.

**Yugl** · 2012-09-05 09:54

NVM.

**pchan** · 2012-09-05 10:56

The DRG DPS sheet returns a similar dps as in the mythic thread, under the same buffs, so it looks good. I just need to know what "AM3=60%,AM3-2=67%,AM3-3=33%" means. Is that a byproduct of 40% oa2/20% oa3 (from BG wiki) or is it another model (gives similar results anyway) ?

**Byrthnoth** · 2012-09-05 10:58

It is the same as 40% OA3 and 20% OA2. Motenten modeled OAx as being a base proc rate for OAx and then a distribution within that.

Also, I found my parse of DA/TA rate:
http://www.bluegartr.com/threads/108...=1#post5090848

**Motenten** · 2012-09-05 12:19

Upgraded Sam. Also added Tenryu gear.

Fixed attack bonus traits for Drg and War.

Misc tidying up.

Originally Posted by pchan

I just need to know what "AM3=60%,AM3-2=67%,AM3-3=33%" means. Is that a byproduct of 40% oa2/20% oa3 (from BG wiki) or is it another model (gives similar results anyway) ?

I treat OAx as a proc in and of itself. That is, an OA2-3 weapon doesn't get a DA check, then an OA2 check, then an OA3 check, it gets a DA check, then an OAx check; if OAx passes, it's split among the different results it can produce.

Since parsed data indicates a 40% chance of 2x and a 20% chance of 3x, that's converted into a 60% chance of some sort of OAx proc, with a 2:1 split among its constituent parts.

**Martel** · 2012-09-06 11:10

In the DRG sheet, After making all settings/gear identical for sets 1 and 2, I'm getting higher DPS on set 2. It looks like the difference is in jump dmg, but I can't figure out what's causing it.

**Yugl** · 2012-09-06 11:15

Perhaps buffs? Link the sheet if ya can.

**Martel** · 2012-09-06 11:39

I don't really have a convenient way of uploading files. Lemme see if i can duplicate the effect with a freshly downloaded version.

EDIT: So far, I haven't been able to cause it on a fresh sheet. I've no idea what the deal is. I suppose i should just use the new sheet.

Edit2: Ok, looks like it was just me derping. I dunno how my eyes managed to glaze over the ODD on set 2 being 20% while set1 was 0. /derp.

**Martel** · 2012-09-06 12:04

Oh, but this actually brings up a valid issue. Adding ODD also increased jump DMG... But as far as I know, ODD doesn't proc on jumps. Well, actually. I'm not too sure about relic ODD, But I'm fairly sure Empy aftermath ODD doesn't.

Gonna hop on the test server. Shouldn't take long to find out for sure. <,<

**Byrthnoth** · 2012-09-06 12:36

Relic ODD can proc on jumps. Iirc I've seen a ~2500 damage jump by a Brovura WAR/DRG (DA, crits, 2x damage).

**Martel** · 2012-09-06 12:46

Is there actually a controlled test for this somewhere? And don't WARs have some kinda DA enhancement gear that makes the second hit do x2 dmg?

Also, is there a proc rate listing for Relic ODD somewhere? I know they all were equivalent to 20% ODD, but the actual proc rate varied by what the time x dmg was right?

**Yugl** · 2012-09-06 12:47

Yeah, I've never heard of ODD on Jumps. That's why OAT used to be boss by comparison.

**Martel** · 2012-09-06 13:12

I'm on the test server right now jumping wild rabbits with a 99 Gungnir. 54 jumps in so far, and no procs. I'm not sure what 99 Gungnir's proc rate is, so I can't say how unlikely this is assuming ODD can proc on jumps.

Thread: DPS Spreadsheets

Thread Tools

Latest Threads

Up & Coming Threads

Hottest Threads