DPS Spreadsheets

[Motenten]

Fixed. Also fixed external reference.

[Motenten]

Pup upgraded.

[Foldypaws]

Is there any way to get the stats from atmacites in the spreadsheet? I don't see a way to manually enter regain and such anymore.

[Motenten]

Is there any way to get the stats from atmacites in the spreadsheet? I don't see a way to manually enter regain and such anymore.

You can manually force a regain value by setting the value used for Tactician's Roll. Atmacites are still a bit further down the list of things to do, though. Will probably implement them like Atmas, but since they touch on so many stats, will require another large revamp period.

[Motenten]

Got an idea for handing the 'by day' fTP boost items (added flag on Setup page for whether it applies). Sadly, didn't get to use the truly convoluted code, as a much simpler idea worked itself out.

Also made fTP a regular property instead of a hidden check. Implemented on mnk; will expand to others that use Athos and Mekira gear as I get time.

[pchan]

Insurgency with level 99 liberator is only getting 25% bonus, it should be 30%.

[Motenten]

Fixed.

Also want to say, thanks for going over the spreadsheets with such a fine-toothed comb. Glad to have someone else going over my work to catch these mistakes.

[Taim Meich]

Pup upgraded.

Thanks!

I've been playing around with it, using Pchan's conditions in the mythic thread, and, after changing a lot of gear to optimize for such a strange environment, I get 606 DPS using maneuvers, 665 without. However, if I change the 100% TP crit modifier from 10% to the 35% suggested by the wiki, I get 636 with, 700 without. All of this assuming AM3 always up, berserk and aggressor always up (that is, a 3 min zerg).

I have my doubts about that 35% crit bonus at 100% TP, as I think it's too high and the 10% motenten uses matches better my own experience. When I return to the game in 2-3 months, I'll try to test it to know for sure.

[Nightfyre]

Ragnarok 99's critrate should be 14% instead of 13% in the DRK and WAR spreadsheets.

[diasetsu]

Unless I'm just missing it, MNK spreadsheet does not account for Augments Focus with Glanz. I am just manually entering 5% attack, 3% crit and the corresponding accuracy into the set bonus columns though.

[ccl]

On the DRK spreadsheet; Desperate Blow is considered 24% JA haste and hasso actually add 1% JA haste to it and put it at 25%, is this mistake or does Desperate Blow not really cap JA haste?

[Byrthnoth]

It's not very easy to quantify JA haste because it doesn't affect recasts. All tests of it have been done using FRAPs and counting frames, which has limited accuracy. We probably don't actually know. Similarly, DNC's Haste Samba being 100/1024 Haste is a guess.

[Motenten]

Ragnarok 99's critrate should be 14% instead of 13% in the DRK and WAR spreadsheets.

Fixed.

[Motenten]

Unless I'm just missing it, MNK spreadsheet does not account for Augments Focus with Glanz. I am just manually entering 5% attack, 3% crit and the corresponding accuracy into the set bonus columns though.

Added.

[ccl]

It's not very easy to quantify JA haste because it doesn't affect recasts. All tests of it have been done using FRAPs and counting frames, which has limited accuracy. We probably don't actually know. Similarly, DNC's Haste Samba being 100/1024 Haste is a guess.

I see, thx.

I guess the only way to know for sure would be to have someone ask on the official forum and hope for an answer.

[Motenten]

Upgraded pld.

[Motenten]

Don't forget DRK gets +45 Acc from Diabolic Eye (last for 3:30 on a 5min timer)

Souleater also adds +25 Acc which is not accounted for on the spreadsheet.

Added these, though Diabolic Eye is only +40 acc from the description (20 acc from first merit, +5 acc per each of the next 4 merits).

[ccl]

I think the drk spreadsheet doesn't take resolution attack penality into account, on Ig-alima, with no def down I capped attack on ws with less than expected.
I did ((750*0.08 )+750))*2.25 = 1822.5; yet 1700ish attack was capping my ws Cratio, or did I do anything wrong ?

[Motenten]

Capped attack for a 750 def mob using a 2-handed weapon would be 1,688 attack. That would put cRatio at 1.20. For Resolution, I get that with 1834 base attack (added a flat value as a custom bonus), which is then penalized by 8%, 146 att, for a final of 1688 att.

If you're looking at line D56/E56 for the final attack, that's after the Resolution attack penalty is accounted for.

Seemed to be working properly on my end.

[Nightfyre]

You appear to have added rather than subtracted, if I understand what you're doing right. Should also be done as 750*2.25=1687 post-penalty, or 1687/(1-0.08)=1834 attack pre-penalty.

beaten