DPS Spreadsheets

[Motenten]

Boo. Will make stat gathering more difficult.

[Fake]

What makes stat gathering even worse is the 3 minute messages that floor your accuracy for the following 30 seconds (in ceizak). Only reliable way to do it would be turn parse on for the last 11mins of the run, 33min message is the final one I believe someone posted.

NMs will be easier since you can do them outside, but ofcourse you'd have to pick one that hasn't got an evasion based gimmick such as pieste.

[Carraway]

All new gear has been added to all jobs (including set handling for the earrings).

War DW spreadsheet removed; DW handled in main War spreadsheet now.

Gear list pages have been revamped to be compatible across jobs (for the most part), so that it's easy to copy and paste between them. This also means that there's stats on each sheet that may not apply to that job; don't worry about it, it doesn't affect anything. There's a possibility of some things getting slightly messed up in the process, so let me know if you see anything odd.

Fixed a few misc bugs.

Note: I'm not dealing with any augmented gear/weapons. If you want that accounted for, use the Custom lines.

I use Bukhis personally as I'm not completely done with Abyssea for a few jobs. DRK spreadsheet seems to be missing Quauhpilli Helm, Letalis Mantle, and Pak Corselet +1. WAR spreadsheet is missing Brigantia Pebble/Oneiros Pebble. Not a huge deal since gear can be manually added. And, of course, thanks for all the work you've put into maintaining these.

[Malicat]

Ihina posted this on my ffxiah thf guide thread about fracture fodder stats:

Well with my old set, I was TP'ing in about 170dex and had a 22% or so crit rate. Current set, I'm around 150 and that puts me around 14%. No crit rate from gear. Unless they have some crit evasion, I'd guess they have around 130~ agi, and unless I screwed up the math somewhere, they have around 600 evasion(including agi).

Unfortunately that gives you zero idea about the level correction, defense, and VIT, but at least it's something approaching a ballpark figure for AGI and evasion.

[RicFlair]

Are the new formulas in the updated spreadsheet not compatible with Google Docs? I've been uploading it there without a problem until now. I can see the DPS values if i preview it via the .xls file but once i open it via Google Sheets, the DPS values (along with some set bonus gear) just say #N/A... Any way I Can fix this?

[Vyvian]

Ihina posted this on my ffxiah thf guide thread about fracture fodder stats:



Unfortunately that gives you zero idea about the level correction, defense, and VIT, but at least it's something approaching a ballpark figure for AGI and evasion.

If you go off what they said, all that changed about level correction is that it starts at 2 levels above the player, and at 2 levels its only as strong as 1 level used to be.
So old:
Greater of (MobLV - PlayerLV) or 0.

New:
Greater of (MobLV - PlayerLV)-1 or 0.

[Motenten]

Updated the level correction for all sheets.

For the Google Sheets issue, it seems to be a problem with the default handling of hlookup(). Adding an extra parameter flag seems to make it work properly (tested with the mnk spreadsheet), so I'll update the rest with the same fix later this evening.

[Motenten]

I use Bukhis personally as I'm not completely done with Abyssea for a few jobs. DRK spreadsheet seems to be missing Quauhpilli Helm, Letalis Mantle, and Pak Corselet +1. WAR spreadsheet is missing Brigantia Pebble/Oneiros Pebble. Not a huge deal since gear can be manually added. And, of course, thanks for all the work you've put into maintaining these.

Added that gear.

Updated all spreadsheets with the hlookup() fix for Google Sheets.

[Motenten]

Delve Eft added to all spreadsheets, with the following stats:

Level: 107
Evasion: 590
Defense: 610
Vit: 136
Agi: 136
Int: 136 (for spreadsheets that use it; no valid basis for value, just copying the others)

[Detzu]

Ihina posted this on my ffxiah thf guide thread about fracture fodder stats:



Unfortunately that gives you zero idea about the level correction, defense, and VIT, but at least it's something approaching a ballpark figure for AGI and evasion.

I thought there was no level correction in Adoulin's contents.

[ccl]

Sam spreadsheet doesn't seems to include /drg accuracy bonus I, also addition of jump for /drg would be cool(if only just for the tp gain/faster ws).

[Kincard]

Some small things on NIN sheet:

-Uguisu is actually 3% DW
-TPB Moonshade not listed

[Motenten]

Sam /drg acc fixed.
Updated nin gear.

I'll see about adding jumps to sam spreadsheet at some point.

[Zirael]

Motenten, since Adoulin end game events emphasize using accuracy to improve your DPS, would you consider adding ACC+ rolls and songs to your spreadsheets? Also, GEO spells provide ATK+/ACC+/STR+/DEX+ party buffs and DEF-/EVA- debuffs on enemies.

Secondly, currently the [Data] tab displays your HitRate% cRatio etc, which is nice (even though a bit buried deep within spreadsheet) - would it be possible to display that data somewhere in the front-end, since it kind of has a huge impact on your DPS. And also, would it be possible to display somewhere in the front-end how much accuracy/attack/STR you need (or by how much you're overshooting the caps) to cap hitrate/cRatio/fSTR? Info like that is already displayed for magic/gear/JA/DualWield/MartialArts Haste/Delay in the [Data] tab (shows number in green when you cap each category) and I can say it's nice to see clearly.

[Motenten]

Madrigal is already there, but yes, I should have Hunter's Roll in there. Will add it.

Haven't added Geo buffs/debuffs yet because I'm running out of space.. Will work on that. Def Down, at least, can just be added to the percentage modifier on the mob target.

As for a better summary of where you currently stand... It would certainly be worthwhile; just have to figure out how to fit it all in there.

[Fwahm]

Will Ionis be an available buff sometime in the future? I understand if it's a bit difficult to make variable.

[Bikpik]

In the drk spreadsheet, if I use the exact same equipment in both sets, and I turn on fighter's roll, it gives me different results for the same set, is anyone else having this issue?

[Vyvian]

In the drk spreadsheet, if I use the exact same equipment in both sets, and I turn on fighter's roll, it gives me different results for the same set, is anyone else having this issue?

On the other spreadsheets in the bottom right of the first page, there's a roll potency for set 1 and set 2, and they're set to different numbers by default.. Did you change them to match?

[Bikpik]

On the other spreadsheets in the bottom right of the first page, there's a roll potency for set 1 and set 2, and they're set to different numbers by default.. Did you change them to match?

That did it, thanks

[ccl]

Where does your max value from pizza+1/sushi comes from did youdo your own testing ? I tried to look around but wasn't able to find anything.