DPS Spreadsheets

[Motenten]

Pizza came from back in the colibri days, I believe. Sushi caps were provided by someone who gave me links to jp testing. I'll have to go find them again.

[Motenten]

Found the message; wasn't an actual test, but from one of their data books:

sole sushi Acc Mult Cap is 72.
squid 72 bream 76.
these are written in a japanese book.(ファイナルファンタジーXI 電撃の旅団 編 ヴァナ・ディール公式ワールドガ[イド]2010 Vol.2
so ive not seen the test. its a kind of leaked info.

Note: brackets added to prevent forum message breaking.

[Fake]

Manibozho head R15 STR on mnk spreadsheet has 0 haste, should be 61

[Motenten]

Fixed.

[Aumaan_Kujata]

Just so I can feel like I contributed in a very small way to these amazing spreadsheets, here's some minor "bugs" I've run across while being one of the probably not that many users of the... melee rdm spreadsheet:

Gear that's not there that probably should be:
cheruski needle
hasty pinion
bendis hairpin
hyaline hat
ghillie+1 earring
houyi gorget
neptune's pearl
vara brigandine
karka ring
mars's ring
tjukurrpa annulet
letalis mantle
wanion belt
warlock+1 boots

Gear that's on there that rdm can't wear:
lucky coin
kemas earring
ample gloves
sharpeye mantle
bullwhip belt
nusku's sash
sentry belt
matre bragenzenn

Other:
rancor gorget typo: 6atk should be 6acc
row 59 on Data tab (Base Acc 2) is using HLOOKUP("Att"... instead of HLOOKUP("Acc"... in all four cells


Now I can sit back and contemplate the idea of very slightly reducing the global quality of the ffxi population by causing a tiny delay in the improvement of the real DD spreadsheets as Motenten spends an extra moment on the rdm sheet.

[noodles355]

Or you could just add/remove them to/from the spreadsheet yourself.

[Jem]

Is Hasty Pinion even a DPS gain in any likely/sensible scenario?

[Motenten]

Now I can sit back and contemplate the idea of very slightly reducing the global quality of the ffxi population by causing a tiny delay in the improvement of the real DD spreadsheets as Motenten spends an extra moment on the rdm sheet.

Everything is useful. In this case, I used rdm as the basis for making the cor spreadsheet (which will then be the basis of the rng spreadsheet) because it already handles dual wielding, and a mix of dagger and sword options. So fixes to rdm also help fix cor (and brd).

Cor is currently about halfway done; have to deal with the tediousness of updating all the gear lists, and then finish some of the more specific implementation details.

Is Hasty Pinion even a DPS gain in any likely/sensible scenario?

Unlikely, but it may -look- like something useful to some people, so having it in the spreadsheet serves the purpose of being able to see that it compares poorly to other options.

[Aumaan_Kujata]

Unlikely, but it may -look- like something useful to some people, so having it in the spreadsheet serves the purpose of being able to see that it compares poorly to other options.

Basically this. For a job where Eurus' Ledelsens are still usually within a fraction of a percent of the best tp feet choice, it's sometimes worth a quick verification when juggling haste gear that, yeah, this still isn't a good idea. It may be the smallest of many reasons to love these spreadsheets, but it's still A reason, heh.

[Taim Meich]

Realizing how wrong one is in certain gear/buffs assumptions in one of the best parts of the spreadsheets, indeed.

And speaking of that, PUP spreadsheet doesn't include Rouge's Roll into the total crit rate, the crit rate cells are missing a reference to the Rouge's Roll cells. By the way, once included, at least for Delve farm, Fighter's Roll is still better than Rouge's for a PUP using Stringing Pummel.

[noodles355]

Cor is currently about halfway done; have to deal with the tediousness of updating all the gear lists, and then finish some of the more specific implementation details.

You could pretty much copy/paste most of Thf's gear over, then just add the few missing /ra and MAB pieces.

Tho somethings obviously could be left out. Like I don't think either spreadsheet needs Jupiter's Rings on them, considering Thundersoul are pretty much the same price lol.

[Shadida]

If COR is nearly done, does that mean RNG will be quick to follow?

[Motenten]

And speaking of that, PUP spreadsheet doesn't include Rouge's Roll into the total crit rate, the crit rate cells are missing a reference to the Rouge's Roll cells. By the way, once included, at least for Delve farm, Fighter's Roll is still better than Rouge's for a PUP using Stringing Pummel.

Fixed.

You could pretty much copy/paste most of Thf's gear over, then just add the few missing /ra and MAB pieces.

Tho somethings obviously could be left out. Like I don't think either spreadsheet needs Jupiter's Rings on them, considering Thundersoul are pretty much the same price lol.

Yeah, will probably try for that to speed things up.

Jupiter's is still there cause old stuff almost never gets removed. Plus you can get Jupiters as quest rewards with augments (eg: I have one with +3 att on it), so they're 'free' options.

If COR is nearly done, does that mean RNG will be quick to follow?

For a given definition of 'quick'. Even cor is probably still another 6 hours of work.

[Motenten]

Cor spreadsheet done. Please check it out and let me know of any problems you find, since it's likely got errors in it.

Edit: Already fixed a couple errors in the last couple minutes. If you downloaded immediately after I posted, get the newer version.

[Motenten]

Tons of errors fixed in the cor spreadsheet.

Rng spreadsheet added.

[Jem]

Toggling Fighter's Roll On/Off on BST spreadsheet does nothing at all. Think something must be broke?

Also missing Letalis Mantle and Oneiros Pebble.

[Viar]

Cor spreadsheet done. Please check it out and let me know of any problems you find, since it's likely got errors in it.

Edit: Already fixed a couple errors in the last couple minutes. If you downloaded immediately after I posted, get the newer version.

Hi, thanks for all the work. A couple of suggestions for gear list: You can add Epona's ring, eva/AGI path delve weapon augment(AGI for last stand/WF spam), Mercurial Kris, regain/rattk and racc moonshade. And maybe /BLM and /BLU for subjob(BLU with attack bonus/MAB job trait on with every AGI spell set)? Thanks.

Also if I remember correctly, Velocity shot doesn't work as SJ but spreadsheet has it.

[Motenten]

Toggling Fighter's Roll On/Off on BST spreadsheet does nothing at all. Think something must be broke?

Also missing Letalis Mantle and Oneiros Pebble.

Fixed.

[Motenten]

Hi, thanks for all the work. A couple of suggestions for gear list: You can add Epona's ring, eva/AGI path delve weapon augment(AGI for last stand/WF spam), Mercurial Kris. And maybe /BLM and /BLU for subjob(BLU with attack bonus/MAB job trait on with every AGI spell set)? Thanks.

Also if I remember correctly, Velocity shot doesn't work as SJ but spreadsheet has it.

Gear added.

/blm added. /blu I'll have to look into to find what stats to add.

Ah, BGWiki didn't have that limitation on Velocity Shot noted. I'll have to remove it.

[Viar]

Gear added.

/blm added. /blu I'll have to look into to find what stats to add.

Ah, BGWiki didn't have that limitation on Velocity Shot noted. I'll have to remove it.

Another question, when I try ranged WS+ melee TP, my WS damage seems to be affected by melee weapons? I used "melee+ranged WS" fighting style, melee weapon skill=none, ranged WS=last stand.