DPS Spreadsheets

[Motenten]

I didn't do any gear optimization. Those were just a few numbers to indicate what sort of range of values I was getting, and where it was pushing limits.

Can toss in a kraken weapon to see what it looks like at cap. Using the exact same setup as above, with capped acc/att, 99 Farsha/Ganelon DA is 435 DPS; 99 Farsha/Kraken is 446 DPS. Not enough of an edge that I'd think it would be worth messing with.

[dasva]

Yeah just saying that's why it gains so little from haste samba. You'd actually be better off going empty waist slot and on earring.

Oh yeah would probably have to change the gear setup a bit for kclub since all that DA is probably hurting it a bit. It's possibly to just input a weapon with kclubs stats on the gear tab right? I might try to make a set more suited for it if so

[Byrthnoth]

Those are pretty much the same values that I got (maybe exactly, but my computer isn't here right now). And yeah, you can make some swaps once you have Haste Samba that boost your DPS. I think I did Windbuffet + Ravager's Earring and might have changed some more too.

[dasva]

Is there a way to do it on war or are you forced to mess with bst?

[Motenten]

I've uploaded the War DW spreadsheet, which is a partial conversion of bst to war. I figure most the gear will be compatible, though I won't guarantee anything specific. It's also missing the Restraint and Warcry stuff, but figure that's minor extra for now.

[Motenten]

All spreadsheets updated to 2.25 max cRatio.

[Malicat]

Hi Motenten, two questions for you:

* for the THF2 spreadsheet you have the Raider's Armlets +2 Sneak Attack bonus at 15%. BG Wiki (I am unable to link) and the other two wikis all say it's 20%. Where'd you get your 15% from?
* I noticed the gear haste calculation rounds up. So, if I have 250/1024 gear haste, it'll show 25% haste instead of 24%. All the haste information I can find... doesn't really clarify the issue, but is it correct to be rounding up?

Thanks!

[Motenten]

I don't remember where I got the number for the thf hands. I'll see about revising that.

The haste percentage shown comes from Excel's rounding, to keep the display neat; that's not the actual value used. If it's 250/1024, that's the actual multiplier used.

[mdkuser]

in SAM spreadsheets kogarasumaru has +25% bonus to tachi: Rana while BGwiki lists a +30% bonus. WHich is right?

[Byrthnoth]

+30%: http://forum.square-enix.com/ffxi/th...l=1#post261286

[Motenten]

Fixed.

[mdkuser]

MNK spreadsheet. Victory smite's crits are not caped at 3.0 (WS tab, W18 cell and below). Each $J$14+1 should be MIN($J$14+1,3)

Actually melee critical hits aren't caped either, same as kicks (data tab line 97).

BLU spreadsheet: melee crits are caped at 3.15, the cap is 3.0. WS crits on CDC are not caped.

probably all 1handed DDs aren't caped.

Edit: back to MNK spreadsheet. I have my own simulation which gives the exact same results with 0.5% error as your spread sheet, EXCEPT for the critical hit rate during impetus on victory smite. I realize you use the same critical hit rate bonus from impetus during melee and victorysmite in the spreadsheet, but it's not the case.

Im using simulation and the spreadsheet with the same gears. WS damage is the same outside of impetus but not during impetus. Running my simulation I find out that impetu's bonus is closer to 22% during victorysmite when its 17% during melee.

[Baki20xx]

Any plans to generate a RUN spreadsheet? Be able to check the math on Thaumas and the new thurandaut gear with GSs. At this point I'm just guessing for capped haste sets and STR for reso. A spreadsheet would be much appreciated ^.^

[Taim Meich]

I'm working with a modified WAR one. Put in the Set Bonus the following (assuming hume): +20 GS skill, -5 STR, -3 DEX, -22 attack, -15% double attack, -8% critical hit damage. Then modify Scholar's or Summoner's skill so that selecting their enspells will generate your current enspell damage (you will have to unlock the range of values on the cell to be able to get enspells of 36+), and then add the relevant gear to the gear cells.

You'll only miss the contribution of Lunge, which you can easily apply by calculating how much Lunge damage you do, divide it by 180, and then add that value to the DPS. Oh, and Swordplay, but the bonuses are currently unknown, so you basically don't care.

[Motenten]

There will be eventually, when I get some time to dedicate to it.

[Baki20xx]

Awesome, thank you Mot. And to Taim... that all sounds WAY over my head with excel skills I've been using a modified WAR spread but not to that extent

[Motenten]

Run spreadsheet added. It has some /drk stuff in it (since it was copied from the drk spreadsheet) in the event that the Last Resort changes eventually take place. Don't necessarily trust the Souleater stuff, though.

Does not deal with Lunge at this point in time. Also, I'm trying to find any data on the formulas for the rune enspell damage. It's not listed on the wiki, nor is there a general page for all the runes (as opposed to each individual rune element).

Let me know if you spot any problems.

[Taim Meich]

Lunge could be implemented by having a separate equipment page accounting for the MAB and skill pieces used for it, and then just divide that damage by 180 and add it to the DPS. Then again, I'm sure you've already thought of that.

About Enspell... Dasva had a pretty reasonable theory about it, that seemed to predict the general trend, but there's nothing quantified yet.

As always, thanks a lot!


Edit: I see a couple of important pieces of gear missing: epona's and twilight belt.

[Motenten]

I see a couple of important pieces of gear missing: epona's and twilight belt.

Updated.

[Zirael]

Motenten, any chance of adding automatic calculation of Neo-Nyzul and Neo-Salvage item set bonuses into your spreadsheets? Here's an example (utilizing simple countif() function on "Phorcys" and "Ares +1") for your latest PLD spreadsheet:
http://www.filedropper.com/dpscalcul...lin-pld20apr13

Edit:
Your PLD spreadsheet is missing Nefarious Collar (used for TPing instead of Rancor collar, for tanking purposes), Portus Collar, Tyrant's Ring, Wanion Belt.