DPS Spreadsheets

[Darkmagi]

Fully buffed oatixur will absolutely cap pdif with defense down applied. I'm surprised the damage didn't change at all, it should have gone down if you were capped pdif. Did you look at the individual ws damage?

[TSFFXI]

Mob defense should be listed under the mob you choose on the first sheet.

[suji]

Or is there an input that I did not see for mob's DEF?

All of the mob types available on the setup page are referencing mob templates on the "Other Lists" page, each of which has a predefined defense value. You can usually search around mathy bits to get some understanding for how these values were arrived at.

You were probably capped attack in your setup but keep in mind that Tojil usually has a strong Attack Down aura (not sure what %) so your results may be misleading.

[Alistrianna]

Was messing with the MNK spreadsheet and noticed Haste Samba do not get applied to JA haste in the data section.

[Martel]

In the PLD sheet, When I try to single wield and put a shield in the sub slot, The DPS value becomes N/A. To get a value I have to set sub to sword then select none.

[CDF]

For those who are trying to figure out a way to account for Quiahuiz Helm and Quiahuiz Leggings damage, as well as for the relic damage multiplier affecting only the first attack, I came up with an effective Empyrean ODD rate calculation that can be put into the corresponding ODD rate cells. (This is based on using expected number of attacks per round, so it should be appropriate for the average dps output.)

This assumes that Increases "Double Attack" damage does not affect weapon skills (as shown with Warrior's Cuisses +2).

p_emp = true Empyrean ODD rate (a binomial proportion taking values between 0 and 1 inclusive)

p_relic = Relic damage multiplier rate (also a binomial proportion)
M_relic = Relic damage multiplier (e.g., 2.0 for Bravura, 2.5 for Ragnarok)

q = quadruple attack (QA) rate
t = triple attack (TA) rate (unconditional)
d = double attack (DA) rate (unconditional)
t' = TA rate given that a QA doesn't occur [t' = (1-q)t]
d' = DA rate given that a QA doesn't occur and a TA doesn't occur [d' = (1-q)(1-t)d]

M_d = DA damage multiplier (e.g., 1.05 for Quiahuiz Helm)

For Relic weapons

effective ODD rate = [p_relic(M_relic - 1) + 1 + M_d*d]/(1+d) - 1

Limiting cases:

d = 0 (no double attack) or M_d = 1 (no DA damage bonus): effective ODD rate = p_relic(M_relic - 1)

p_relic = 0 or M_relic = 1 (no Relic damage bonus): (1 + M_d*d)/(1+d) - 1

For Empyrean weapons or anything else that isn't relic

effective ODD rate = [(1 + M_d*d)/(1+d)](1+p_emp) - 1

Limiting cases:

d = 0 (no double attack) or M_d = 1 (no DA damage bonus): effective ODD rate = p_emp

p_emp = 0: effective ODD rate = (1 + M_d*d)/(1+d) - 1

Note: for spreadsheets d needs to be a reference to the total DA rate in the data tab

EDIT: I forgot about Increases "Double Attack" damage also affecting the first attack, as well as the possibility of relic damage multiplier stacking with Increases "Double Attack" damage, along with the occurrence of TAs and QAs. So accounting for all these, I get the following

For Relic weapons

effective ODD rate = {M_d*d'[p_relic*(M_relic-1) + 2] + (1-d')*[p_relic*(M_relic-1)+1] + 2t' + 3q}/(1 + d' + 2t' + 3q) - 1

Limiting cases:

M_d = 1 (no DA damage bonus): effective ODD rate = [p_relic*(M_relic - 1) + 1 + d' + 2t' + 3q]/(1 + d' + 2t' + 3q) - 1

The presence of DA, TA, and/or QA reduces the effective ODD rate compared to the case with no DA, TA, and QA, as the relic damage multiplier affects only the main attack

p_relic = 0 or M_relic = 1 (no relic damage bonus): effective ODD rate = [d'(M_d - 1) + 1 + M_d*d' + 2t' + 3q]/(1 + d' + 2t' + 3q) - 1

The presence of DA, TA, and/or QA reduces the effective ODD rate compared to the case with no DA, TA, and QA, as the DA damage multiplier affects only the main attack and the additional attack from DA proc

For Empyrean weapons or anything else that isn't relic or involves mythic AM3

effective ODD rate = (p_emp + 1)*[d'(M_d - 1) + 1 + M_d*d' + 2t' + 3q]/(1 + d' + 2t' + 3q) - 1

M_d = 1 (no DA damage bonus): effective ODD rate = p_emp (all attacks receive ODD bonus at rate p_emp)

p_emp = 0 (no Empyrean ODD bonus): effective ODD rate = [d'(M_d - 1) + 1 + M_d*d' + 2t' + 3q]/(1 + d' + 2t' + 3q) - 1

Other comments: As long as the expected number of (landed) attacks in the spreadsheet is not decomposed so that particular damage bonuses are applied to specific attacks, the above seems to be a reasonable substitution as they exclude applying DA damage bonus to WS damage and indiscriminately to all attacks, inflating the benefit of Increases "Double Attack" damage beyond what is warranted based on testing (the damage bonus not affecting WS) and the illogic of this bonus applying to TA and QA

One may choose to account for kick attacks and/or mythic AM3 by adjusting d', 2t', 3q accordingly and adding a kick attack term. It is presumed that Quiahuiz DA bonus wouldn't affect any mythic AM3 multi-attack procs.

Examples:

60% DA rate, 1.05 DA damage: Quiahuiz confers an effective ODD rate of 3.75%
100% DA rate, 1.05 DA damage: Quiahuiz confers an effective ODD rate of 5% (makes sense... all hits getting 5% damage is equivalent (in expected value terms) to 5% of all hits getting 2x damage, or 1.05*1 = 2*.05 + 1*.95)

100% Relic 2x damage rate, 100% DA rate, 1.0 DA damage: effective ODD rate of 50% (50% of attacks are DAs, 50% of attacks get the relic 2x bonus)

100% Relic 3x damage rate, 100% DA rate, 1.0 DA damage: effective ODD rate of 100% (50% of attacks are DAs, 50% of attacks get the relic 3x bonus. This is equivalent to 100% of attacks getting 2x damage, or 3*.5 + 1*.5 = 2*1)

[Motenten]

All new gear has been added to all the spreadsheets (except for the magic damage spreadsheet). Next update will be to automatically handle relic ODD effects, and make that separate from the ODD field on the Setup page, so that relic and empy bonuses won't interfere with each other. Also, adding in handling of Quauhpilli DA effects.

Mnk spreadsheet has the relic and Quauhpilli stuff already done.

[Motenten]

Quauhpilli, relic and ODD stuff done for all melee jobs. Not applied to cor or rng for now.

Relic ODD/OTD is now automatically handled. You don't need to use the ODD field on the Setup page, and any ODD value there will be ignored if using a relic.

ODD from the Setup page will properly apply to all hits of the main hand. (Relic only applies to first hit.)

[pancakesandsex]

Motenten, has anyone ever told you that you are a lovely boy? You are a lovely boy. Thanks for keeping these up to date.

[Motenten]

Mnk spreadsheet updated with experimental pDif usage in place of cRatio. There's a toggle for whether to use pDif on the Setup page. Affects melee and weaponskills. Actual difference from cRatio values isn't really that large, but may impact setups that were fairly close together.

Please provide thoughts on how it seems to be working.

[DanDan]

I was just messing around with the DPS sheet and with everything set to default on the THF sheet except:

Hume
/NIN
No food
Ionis
SA - Solo
TA - Solo
No Haste spell active or Berserk or Haste Samba

and this gear-set for Melee Set 1 (random gear):

Forefront Dagger
Triplus Dagger
Full Thurandaut +1
Suppa/Brutal
Epona's/Raja
Atheling Mantle
Twilight Belt
Nefarious Collar

which puts it at 24% haste, if I add any more haste (without taking anything away) the DPS doesn't increase. I'm using the latest spreadsheet. Any ideas why?

[Martel]

Ionis gives 2% haste.

[DanDan]

Doh! Been away from this game since a few weeks into the expansion and, even though I skimmed through Ionis' current effects, I must have forgot about it. Thanks.

...sigh, so that's at least one more gear-set I need to create/farm/store.

[CDF]

Ionis is still 12/1024 at best (it says 24/1024 in the latest MNK spreadsheet but there is no evidence of such). There is no moderate haste effect from Ionis.

If there's an easy way to check the haste effect without accounting for moderate fast cast effect these days (not doing time to 1000 attack rounds), I'd like to know.

[Dotsudoku]

Byrth's(I think?) more recent testing seems to show that Ionis is either 12/1024 or less(he seemed uncertain about FC's impact), but absolutely not more.

Kind of annoying that it ever even became a thing. I know a lot of people who adjusted their gear based on the initial claim.

[Alistrianna]

The Civil Registrar for Courier's Coalition says that a specific Edification gives Moderate Haste effect to Ionis but the Ionis NPC does not specify it. Has there been any testing done to confirm that it didn't go up?

[Motenten]

Testing Ionis

First, we know that Ionis has a Fast Cast value. Therefore we're testing for two potential unknowns.

I have a spreadsheet for analyzing haste and fast cast. I'm using that to select test spells when differentiating between haste and fast cast values.

Spell recast time is determined by watching the value shown from the menu in game.

FC = Fast Cast
FCr = Fast Cast recast

First determine the FC portion of Ionis, since we can isolate that by capping gear haste (since Byrth's test indicated Ionis was gear-based haste).

Zelus Tiara
Goliard Saio
Bokwus hands/legs/feet
Goading Belt

27% haste, exceeds cap.

With 256/1024 haste, the first test to see if any FC exists is Cure IV.

256 haste, 0% FCr = 6 second recast
256 haste, 1% FCr = 5 second recast

Result: 5 second recast

Continue until we find the FCr threshhold.

Shellra V
256 haste, 1% FCr = 14 second recast
256 haste, 2% FCr = 13 second recast

Result: 14 second recast

Implies no more than 1% fast cast recast, which means no more than 3% fast cast.


Add Swith cape for 3% FC

Protectra
256 haste, 2% FCr = 11 second recast
256 haste, 3% FCr = 10 second recast

Result: 10 second recast


Conclusion: Ionis moderate fast cast effect is 3%.


Next, on to the haste portion.

With 1% FCr, Curaga II can distinguish between above/below 13/1024 haste. That would show whether the moderate Ionis haste effect has increased (unless it only increased from 12 to 13/1024).

Curaga II
13 haste, 1% FCr = 10 second recast
14 haste, 1% FCr = 9 second recast

Result: 10 second recast


Refining lower to get an exact value.

Klimaform
12 haste, 1% FCr = 176 second recast
13 haste, 1% FCr = 175 second recast

Result: 176 second recast


Regen IV
11 haste, 3% FCr = 23 second recast
12 haste, 3% FCr = 22 second recast

Result: 22 second recast

Conclusion: Ionis moderate haste effect is 12/1024.


Spreadsheets will be adjusted accordingly.

[Fwahm]

The haste misconception started because the Civil Registrar for the Couriers' Coalition, when asked for details on the Bay Roof expansion, said that it gave a Moderate Haste bonus to Ionis. Since Minor was ~1.2%, people assumed that Moderate would be at least ~2%

Talking to the Ionis NPCs and testing shows that this was a typo, and that the Bay Roof gives Moderate Critical Hit Rate instead.

[Motenten]

So the crit rate value on the spreadsheets should be 2% instead?

[Fwahm]

Possibly. I don't think anyone ever quantified either Minor or Moderate critical hit rate increase.