DPS Spreadsheets

[ccl]

Okay I'll keep doing it using rng Namas for ws dmg then swaping stat on ws gear on sam one to get the same number with same buff lol, ty foryour answer ^^

[Fwahm]

Pak Corselet is still listed as having 0 haste in the DRK spreadsheet.

[Motenten]

Fixed, uploaded.

[suji]

In the RNG spreadsheet, the Recycle bonus for using Scout's Beret +2 during WS is not being added to WS TP.

I think this one slipped through the cracks. Still seeing it with a fresh DL of the RNG spreadsheet.

[Motenten]

Added.

[suji]

Thanks!

[theshun]

Mote, thank you for all of this work. I thought adding Trust Buffs Toggles might be something for future additions.

[Motenten]

Won't be added. You can set March manually, just adjusting the March tier. Are there any other relevant buffs?

[suji]

Regain moonshade doesn't seem to work in the RNG spreadsheet.

[suji]

I would like to request recommendations for a selection of target mobs for the spreadsheets to use.

General:
Trivial fodder -- Should be capping all stats even with low-grade gear
Basic fodder -- Just on the verge of capping attack with food and mid/high grade gear, but no buffs or debuffs (notably, not likely to be capped on offhand weapons)
Common farming mobs -- Not difficult, but will need some support before reaching caps
Basic NMs -- Mobs that represent some degree of difficulty to fight, needing coordinated support (eg: T1-5 Delve NMs)
High end NMs -- Mobs that represent alliance-level fights


Common targets:
Dynamis DC. May qualify for the Basic Fodder category.
Kamihr Drifts fodder mobs? Something strong enough to be a minor challenge. Easier to get data on then delve fodder mobs, and roughly the same difficulty.


Specialized targets:
Mobs that represent a particular difficulty, such as very high evasion, but aren't necessarily alliance-fought NMs
Probably a series for: Normal SKC mobs, Diff SKC mobs, VD SKC mobs; Normal AA NM, Diff AA NM, VD AA NM. For the AA NM, figure probably the hume?

And of the mobs selected, have stats determined as well as possible (vit and int should be exact; evasion and defense should be exact for non-NMs, and reasonably close for NMs; agi determined as best as can be figured)


Will likely remove the likes of Pil, Ig-alima, Hydra mobs, etc, though I probably want to keep a high level-correction mob in there. Let me know of any suggestions on what to keep or discard.

I think ditching the VW mobs and adding the following four AA templates would cover your bases:
- AA normal non-evasive
- AA normal evasive
- AA VD non-evasive
- AA VD evasive

Honestly, the only one I've needed to model myself recently was AA VD Evasive. Its stats are so different than Delve bosses that simply adding artificial attack penalties and what not was a pain. I used 1100 evasion iirc but I assume you would know that better than me. I think using HM to cover them all would be a mistake though; HM and MR fit into a higher accuracy bucket, and the rest are much lower.

[TSFFXI]

I'm getting a strange result with the ranger spreadsheet. When I switch from an Aphrotic Kukri R15 STr to a Hurlbat the DPS plummets from 499 to 366.

I set everything to Ranged Only mode, but it must be getting some sort of benefit from the skill on the daggers. Am I doing something wrong?

Edit: Or possibly due to something other than the skill? The drop is much less if I change the Mainhand to Hurlbat rather than the sub slot.

[ccl]

Where does the 13% snapshot come from on sylvan head+2 ? Also does snapshot on spreadsheet count 1 snapshot = 1% delay or 1 snapshot= 2% delay ?

[Motenten]

I'm getting a strange result with the ranger spreadsheet. When I switch from an Aphrotic Kukri R15 STr to a Hurlbat the DPS plummets from 499 to 366.

I set everything to Ranged Only mode, but it must be getting some sort of benefit from the skill on the daggers. Am I doing something wrong?

Edit: Or possibly due to something other than the skill? The drop is much less if I change the Mainhand to Hurlbat rather than the sub slot.

Problem was that the tables for ranged 'melee' rounds allows the offhand to count when totalling the values up. Fixed.

Where does the 13% snapshot come from on sylvan head+2 ?

No idea. Probably mimicking the other stats on the piece. Adjusting to 5%, per the Snapshot BG wiki page.

Also does snapshot on spreadsheet count 1 snapshot = 1% delay or 1 snapshot= 2% delay ?

1 snapshot = 1% delay, but 1 snapshot merit = 2 snapshot

[Byrthnoth]

The DNC spreadsheet doesn't account for Horos Tights/+1's 1~5% enhancement based on Saber Dance.

Turns out Horos Feet and Closed Position merits are much better, for anyone out there who was watching.

[Motenten]

Horos pants fixed on dnc. Also did some cleanup on the mobs list in the dnc spreadsheet (will gradually propagate through the others). Still need data values for AA mobs, though.

[IceSylph]

On the latest MNK spreadsheet, I don't think that the ODD is being calculated correctly, if at all. Tried placing 13,30,40,50% ODD but DPS didn't rise on any.

[Motenten]

On the latest MNK spreadsheet, I don't think that the ODD is being calculated correctly, if at all. Tried placing 13,30,40,50% ODD but DPS didn't rise on any.

Were you using Spharai? ODD is ignored for Spharai since relic bonus damage works differently. The spreadsheet handles the relic damage internally; you don't need to specify anything on the setup page.

[Motenten]

Finally got caught up on all the Feb/March/April gear updates for the spreadsheets. Yay.

[Dotsudoku]

Thanks a lot Mot, much appreciated

[Motenten]

Updated Serac Rabbit stats from other thread.
Fixed acc from skill calculations, based on new info.