DPS Spreadsheets

**Motenten** · 2013-04-19 23:43

That was added already in a recent round of updates. NNI and Salvage sets should work, as do some other sets (eg: Aurore, Perle, Denali, etc). I noticed that I'd left out Toci/Ocelomeh sets, so have been adding those a bit at a time as well. If anyone notices other sets that are missing, let me know.

Note: Checked your spreadsheet, and you're already using a version that has the set bonus figure added in. Set a few pieces of gear to Ares +1, for example, and you'll see that both the Set Bonus line (mine) and the Custom line (yours) give you the extra DA value.

I held off on adding set bonuses until I could create a clean, generic method of adding any new set, for any arbitrary bonus with any number of pieces for any given stat. That's what the current version does. If you look at the formulas, you'll note that none of them use any sort of hard-coding of specific set types like Phorcys. Instead you just add a new line to the list of sets that it recognizes and give it the parameters to use for a given number of pieces, and everything else is handled automatically. I'm actually rather proud of how it works.

**Zirael** · 2013-04-19 23:51

Oh, I see it now, been using an older version of your file without that until now. Thanks!

Another question:
I see you've added some Adoulin mobs to list targets. Does your spreadsheet take into account no level correction in Adoulin when fighting those enemies (i.e. Chapuli)?

**Motenten** · 2013-04-19 23:53

Does your spreadsheet take into account no level correction in Adoulin when fighting those enemies (i.e. Chapuli)?

Yes. That's what the last round of updates dealt with.

Also: Updated Run so that you can hand-specify the enspell damage (some value between 0 and 50), until such time as an actual formula is determined.

**Zirael** · 2013-04-20 00:02

Small comment regarding RUN: for weapon slots, sub-weapon slot is named "Grip" no matter if you pick 1-handed or 2-handed weapon in the main slot. Maybe "Sub" would be more universal, or if you're reaaaally bored, it could auto update the text just like weapon list updates depending on main slot.

Edit: Would it be possible to add Hecatomb+1 (especially feet, but head, legs and hands are still competitive against other gear with good augments)

**Dotsudoku** · 2013-04-20 01:05

Not familiar enough with head augments to say definitively, but hands/legs are definitely not competitive with current options

**Motenten** · 2013-04-20 01:14

Grip/Weapon text: Fixed.

Hecatomb: added

**Carraway** · 2013-04-20 07:25

Just noticed a little typo: in the most recent WAR sheet, under Gear Lists, Legs, "Karieyh" is listed as "Karieyj".

**Motenten** · 2013-04-20 10:41

Fixed.

**Zirael** · 2013-04-20 14:52

Originally Posted by Dotsudoku

Not familiar enough with head augments to say definitively, but hands/legs are definitely not competitive with current options

I meant RUN pre-Salvage+1, NNI mostly. Hecatomb+1 feet can get max of STR+11, DEX+4, ATK+6. Head max STR+12, DEX+6, ATK+10, Double Attack +4%. Arguably, for head, you could just use Nemetona cap, Chocaliztli Mask or Thurandaut Chapeau tho.

**Belgaer** · 2013-04-25 02:28

Do these spreadsheets factor in downtime on buffs like Berserk on DPS? Or does it calculate it as if it were up 100% of the time if you have it on?

**Vyvian** · 2013-04-25 08:51

Originally Posted by Belgaer

Do these spreadsheets factor in downtime on buffs like Berserk on DPS? Or does it calculate it as if it were up 100% of the time if you have it on?

It assumes its on if you turned it on for that set. To get total DPS you set up both sets to be what you'd use, reflecting any gear changes (like if you'd use different gear while berserk is on rather than off), and you set one set to off and one set to on. In the bottom left of the first section makes a reference of time ratio, which you reflect how long you'd be in that state, 180 seconds for berserk, 120 for not. Then it averages the 2 together to give you total DPS.

**Belgaer** · 2013-04-25 09:30

Originally Posted by Vyvian

It assumes its on if you turned it on for that set. To get total DPS you set up both sets to be what you'd use, reflecting any gear changes (like if you'd use different gear while berserk is on rather than off), and you set one set to off and one set to on. In the bottom left of the first section makes a reference of time ratio, which you reflect how long you'd be in that state, 180 seconds for berserk, 120 for not. Then it averages the 2 together to give you total DPS.

Makes sense. Thanks a lot.

Is there any way we could get a Triumphant Roar toggle on the BLU spreadsheet? The only trouble is that it has a 3 sec casting time and it's magic (meaning both the casting time and the recast can be lowered), so it doesn't have a set recast (it can be lowered enough to full time the effect). I'm really curious if it's enough of a DPS increase to full time the effect these days.

**Vyvian** · 2013-04-25 12:15

It's labeled Set Ratios, 2nd to last line on the left column of the first page. I believe 180 120 is set by default as that is the most common up:down ratio. Basically just assume its in seconds and go from there. You can adjust the values if recast merits are in play, such as on WAR. Also, in an A or B situation, you can give set 2 the other buffs, like on MNK I like to do Berserk Aggressor Impetus, and when all 3 are down, I use Dodge and Focus.

The combined result is the last line on the left column of the first page, the result updates in real time whenever you change anything.

**Motenten** · 2013-04-25 15:00

Originally Posted by Belgaer

Is there any way we could get a Triumphant Roar toggle on the BLU spreadsheet? The only trouble is that it has a 3 sec casting time and it's magic (meaning both the casting time and the recast can be lowered), so it doesn't have a set recast (it can be lowered enough to full time the effect). I'm really curious if it's enough of a DPS increase to full time the effect these days.

Added. Also added fields for time spent casting in a given period. For example, if you use Triumphant Roar every 60 seconds, you can set "Cast Time" to 3 and "Per N Seconds" to 60. Effect up/down duration uses the standard Set Ratio split mechanism.

**Belgaer** · 2013-04-25 20:30

Originally Posted by Motenten

Added. Also added fields for time spent casting in a given period. For example, if you use Triumphant Roar every 60 seconds, you can set "Cast Time" to 3 and "Per N Seconds" to 60. Effect up/down duration uses the standard Set Ratio split mechanism.

You're a total boss, sir. Thank you.

**Byrthnoth** · 2013-04-27 09:55

The DNC spreadsheet is missing Xux Trousers, Macoquetza (D64/200 delay), Leisilonu (D64/183 Delay +6 DEX, +5% Critical Hit Rate), and Chocaliztli Mask.

**Motenten** · 2013-04-27 15:09

Added all but Leisilonu. Since it's augmented, trying to decide on how to handle it.

**theshun** · 2013-04-28 13:17

I put Kannakiri as max possible in NIN sheets (D90/227 Delay, STR +10, DEX+3, WSD 5%) just to see the DPS. I would just put full max or min. We will have to know to adjust them no matter how they get added.

Edit: You have Byakko's and Seiryu's as base item and then base item+max augments.

**suji** · 2013-04-28 19:30

hey Mot,

Latest THF2 spreadsheet has a bug in how Chaos Roll is applied. On row 40 (Chaos) of Data, SASet1, TASet1, WSSet1, SAWSSet1, and TAWSSet1 all have the wrong reference for the Chaos roll percentage (it should be $Setup.M40).

Also, last time I checked, Quauhpilli Helm wasn't in the WAR spreadsheet.

thanks

**Motenten** · 2013-04-28 22:27

Fixed and updated.

Thread: DPS Spreadsheets

Thread Tools

Latest Threads

Up & Coming Threads

Hottest Threads