DPS Spreadsheets

[Motenten]

I don't see Nematoma anywhere, so can't add. Got Abatteur from BGWiki (wasn't on FFXIAH), and added to all appropriate jobs. Also added Sljor and Portos to all their respective jobs while I was at it.

There's actually been a JP who's been in contact with me regarding the spreadsheets, and at least a few on that side that are using them. He's also asked to translate them for wider use. I should find out where he's hosting them.

[Motenten]

Okay, how easy would it be then to just math at capped pdif at wich point(enemy level) namas > kaiten for sam ?

Well, you'd need to raise the max cRatio to 3.0 at the very least. Plus it wouldn't account for the different fStr formula or different level correction. And a few other places along the line that would need adjustments (eg: r.att vs regular att, differences in skill, etc). Honestly, I don't think you can get anything close to a real value with the current spreadsheets without some significant changes.

[pchan]

It's nemetona cap, best head gear to mnk atm.

http://www.ffxiah.com/item/10445/nemetona-cap

[Motenten]

OK, thanks for finding that. Added it to all the jobs that can wear it.

[Martel]

Some DRG related discoveries.

Jump stuffs
-Spirit Jump has a +25% ATK bonus with wyvern present.
-Soul Jump has a +50% ATK bonus with wyvern present.
-Drachen Greaves grants Jump(and only normal jump) a +15% ATK bonus.
-Skanda Boots grants Jump(and only normal jump) a +15% ATK bonus.
-Ryunohige(99) grants Jump(and only normal Jump) a +35% ATK bonus
-Spirit Surge grants 100% Acc on jump, and likely high jump.(High/spirit/soul not tested)

Tests here. And in several posts following that one.

Dear SE, Could I have had some of these atk boosts on Drakes, please? >.<;

Huh, I only just now noticed that there's not a spirit surge Option in the DRG sheet. <,<
Eh, well. I pretty much never use it in any case.

[Motenten]

Assuming that Ryu's bonus is scaled up with the tier 1/2/3/4/5 "augments jump" on the weapon? Will use 10%/20%/25%/30%/35% unless you believe it may be a simple flat bonus for all levels of the weapon.

Added Spirit Surge. If Spirit Surge is active, it overrides the Wyvern Present? flag.

Assumed 100% hit rate for High Jump under Spirit Surge, but didn't change hit rate for Spirit/Soul Jumps.

Otherwise, added all the above data to the drg spreadsheet.


Also modified the mnk spreadsheet to allow you to choose between English and Japanese text. Had to do some font tweaking as well. If there aren't any problems with it, will eventually expand that to all the spreadsheets.

[Martel]

Awesome, thanks.

I'd assume that Ryu's jump atk bonus scales up form 75 to 99. Else why make it go from II~V when nothing changes? I haven't Done any tests on ~95 Ryu aug yet. Not sure if I will or not.

I just Confirmed that spirit/soul do NOT get Spirit Surge's 100% Jump Acc. Although, looking at my parse, I seem to have forgot to try high jump. Probably works on high jump though.

[Motenten]

Final buckled down and upgraded thf spreadsheet.

Full general upgrade to new format.

Mythic AM2/3.

Proper OAx calculations (but only handles up to OA4; didn't want the hassle of up to OA8 for kraken).

Added Assassin's Charge (including QA procs; 5/5 AC is about 2% higher in weaponskill damage than 1/5 AC).

Fixed a few bugs in cell references between sets 1 and 2.

[pancakesandsex]

Can anyone explain the set ratio section, why they are set how they are by default, etc. I don't think I use it properly.

[Motenten]

Set ratio averages together two different buff settings, to help simplify such calculations. The default is a 3 minute/2 minute split (eg: Berserk up/Berserk down), with the numbers set in seconds.

[Byrthnoth]

If you missed it in the other testing thread, Ryunohige's level 75 Attack bonus was shown to be +0%.

[Motenten]

For jumps? Ok, rescaled to 0/10/20/30/35.

[Stanislaus]

What ho, there's a thread for these sheets!

I have a suggestion! For Mandau's OD3, I use ODD=((1/Melee.F11)*0.26). Melee.F11 being mainhand swings per round, 0.26 the conversion rate of Mandau's hidden OD3 proc rate and potency into ODD. The result (I believe) is the Mandau's hidden OD3 is converted into ODD, and weighted so that it is as if only the first swing may proc.

Not to backseat spreadsheet design, but perhaps a "Relic Hidden OD3" 0/1 option on the setup page, if 1, use the output of that formula in the ODD line, if 0, user defined. Or user defined hidden effect proc rate and potency, which are then incorporated into the aforementioned one hidden ODX per round formula. Or detect relics in the equipment sets, and act accordingly. Totally up to you, just my thoughts so far!

Thanks again for the work!

[Vyvian]

I just downloaded the MNK spreadsheet and it wouldn't allow me to select Red C Bun as food. I fixed it myself by moving it from being very last to somewhere in the middle (similar to if I added something myself), but this was doing it to the data that was already there so I thought I'd point it out.

[Motenten]

Thanks. Fixed.

[Motenten]

All spreadsheets have been updated with the neo Salvage gear (and other stuff from this update) now.

[Loziel]

There is something strange up with the drg spreadsheet. Exactly matching gear sets and buffs for set 1 & 2 are giving me different dps readings for each. Not sure why

[Motenten]

Identical setups give identical DPS for me. Only thing I could find is that ODD rate isn't set to mark the righthand value with a different color if the values are different, so you may have missed a difference there.

[Martel]

Any plans for adding excal add effect support to the PLD spreadsheet?

[Byrthnoth]

The Dancer spreadsheet seems to have lost Red Curry Buns. (The food structures need to be extended by 1 row)

It also lost Tessera's Saio.

It also has Fire Bomblet, which we can't wear.

Missing Rancorous Mantle.