DPS Spreadsheets

[Malicat]

On the THF spreadsheet, Plunderer's Vest +1 is listed as 4% crit damage, but the item tooltip only says 3. The 4% crit rate is correct, though, so I'm guessing you picked up the 4 crit damage by adjusting from the NQ Plunderer's Vest.

[Dotsudoku]

Getting some bizarre damage figures on the BLM gear tab. Triple-digit values for high tier nukes, and whatnot

[Martel]

How would I enable AM3 in the RUN spreadsheet? You can set it to 1, but it has no effect. iirc in other sheets there's some kinda check so that AM3 doesn't work if you're not wearing a mythic. But RUN mythic isn't in the sheet. <,<;;

[Viar]

How would I enable AM3 in the RUN spreadsheet? You can set it to 1, but it has no effect. iirc in other sheets there's some kinda check so that AM3 doesn't work if you're not wearing a mythic. But RUN mythic isn't in the sheet. <,<;;

I can't enable AM3 in BLU and COR spreadsheet as well. Even with mythic equipped there are no DPS change after setting AM3 to 1.

[Byrthnoth]

I looked at the magic damage sheet for the first time seriously today. It's amazing how much more intense it is to model magic damage compared to melee. In order to get a more complete model, the sheet would also need to:
1) Include a precast set
2) Include an idle set
3) Also model sources of Refresh in all three phases (which is going to dramatically affect decisions based on Average MP, Damage/MP, etc.)
4) Include an Enmity model
5) Include a Magic Hit Rate model

I implemented an easy version of #3 (one number across all phases, multiplied by the reuse time and divided by 3) and it changes the playstyle recommendations of the sheet in situations where you have any substantial amount of refresh, redefines the role of Seidr / Spaekona's +1, etc. Based on the sheet, I don't think it's unreasonable to expect that a pimped out BLM could hit 1k DPS regularly, which is where the Enmity model would have to come in.

[Motenten]

On the THF spreadsheet, Plunderer's Vest +1 is listed as 4% crit damage, but the item tooltip only says 3. The 4% crit rate is correct, though, so I'm guessing you picked up the 4 crit damage by adjusting from the NQ Plunderer's Vest.

Fixed.

[Motenten]

Getting some bizarre damage figures on the BLM gear tab. Triple-digit values for high tier nukes, and whatnot

Make sure you set the Detail value (W22) to Damage and not Dmg/MP or DPS or whatever.

[Motenten]

How would I enable AM3 in the RUN spreadsheet? You can set it to 1, but it has no effect. iirc in other sheets there's some kinda check so that AM3 doesn't work if you're not wearing a mythic. But RUN mythic isn't in the sheet. <,<;;

Simply add the weapon with the appropriate AM3 values. It will be in the next update pushed out.

[Motenten]

I can't enable AM3 in BLU and COR spreadsheet as well. Even with mythic equipped there are no DPS change after setting AM3 to 1.

Apparently I failed to implement AM3 for blu. I'll work on getting that in before the next push.

Ranged stuff is more annoying, but I'll see about cor as well.

[Motenten]

I looked at the magic damage sheet for the first time seriously today. It's amazing how much more intense it is to model magic damage compared to melee. In order to get a more complete model, the sheet would also need to:
1) Include a precast set
2) Include an idle set
3) Also model sources of Refresh in all three phases (which is going to dramatically affect decisions based on Average MP, Damage/MP, etc.)
4) Include an Enmity model
5) Include a Magic Hit Rate model

I implemented an easy version of #3 (one number across all phases, multiplied by the reuse time and divided by 3) and it changes the playstyle recommendations of the sheet in situations where you have any substantial amount of refresh, redefines the role of Seidr / Spaekona's +1, etc. Based on the sheet, I don't think it's unreasonable to expect that a pimped out BLM could hit 1k DPS regularly, which is where the Enmity model would have to come in.

Precast set is already in place. The gear is on the far right of the general result tables, so might not be obvious depending on your screen setup.

Magical hit rate has been in the back of my head for a long time, but I hadn't worked on actually implementing it yet.

An enmity model is something else entirely.

I could see fitting the refresh portion in, which will necessarily include an idle set as well. Will see about working on that.

[Motenten]

New versions of all spreadsheets pushed out.

Added all May patch gear.

Updated all weaponskills with known changes, and speculated unknown changes. Known changes are new WSC values and the removal of the alpha multiplier. Unknown changes are new fTP values and new crit rate values. Will still need lots of testing done after the patch, but about half the spreadsheet work is done.

Also left a folder of the pre-weaponskill modifications (pushed after adding the May gear) if people wanted to compare before-and-after values.

Also fixed the blu AM3 issue.

[Dotsudoku]

Mot, think you could add Apex Arrow to the SAM spreadsheets?

[Motenten]

Archery weaponskills added to sam spreadsheet. It's a rather significant change, so if you find any problems, let me know.

[Dotsudoku]

Thanks a lot!

[Langly]

Couple things on the NIN Sheet. Feel free to correct me.

Set 2 on the data page is having a few issues. It is reference Set 1 WS's attack for it's Set 2 TP gear sets. (Give a check over Column C, since it seems a few things aren't referenced correctly.)

Kikoku's added relic Dmg/Rnd is being multiplied by a 2, rather than a 3 as it is a Triple Damage effect. (Data page, B195 and C195)

119 Kikoku has been left out of the IF's for the 40% dmg bonus (up to 99 is present). (D213 and E213)

Thank you Motenten!

[Dotsudoku]

May have just been an oversight in the SAM spreadsheet, but do we have any reason to believe Hangaku's TP bonus does/doesn't apply to melee WS?

[Motenten]

Set 2 on the data page is having a few issues. It is reference Set 1 WS's attack for it's Set 2 TP gear sets. (Give a check over Column C, since it seems a few things aren't referenced correctly.)

The only thing I found was for calculating Chaos Roll. Fixed that. If there's anything else, please be more specific.

Kikoku's added relic Dmg/Rnd is being multiplied by a 2, rather than a 3 as it is a Triple Damage effect. (Data page, B195 and C195)

That's supposed to be that way. That's extra damage added on top of the normal hit's damage, so 3 - 1 = 2.

119 Kikoku has been left out of the IF's for the 40% dmg bonus (up to 99 is present). (D213 and E213)

Fixed.

May have just been an oversight in the SAM spreadsheet, but do we have any reason to believe Hangaku's TP bonus does/doesn't apply to melee WS?

It doesn't. It was a pain to add ranged stuff to sam, and I was getting lazy by the end. You can always cancel it out on the custom line, but I figured the most common use of ranged slot when not using ranged weaponskills would be Cibi, so it generally wouldn't come up. I may go back and fix it later.

[Prothescar]

Nat. Meditation is missing from the BLU spreadsheet (can't use it as a set spell and the buffs section is still using Triumphant Roar).


actually missing all of the newest spells, I may just be using an older version by mistake

[Langly]

Thanks for the heads up Motenten. The version I was looking at may have been broken by me at some point or was just wrong in the past in regards to column C (referencing a blank field in the F column).

The version I just downloaded and tested came out perfect! Thank you!

[Motenten]

All spreadsheets updated with the new TP formulas.

Note: All ranged weapons are assumed to use the same 176+ delay formula as normal weapons. No data on them has been presented yet.