Mnk DPS Spreadsheets

I was wanting a central location for Mnk DPS spreadsheets if you all have them public.

Here is the link for Motenten's it's the only spreadsheet I've messed with so far.

Motenten's Mnk spreadsheet

How accurate are these in calculating set bonus? For instance Athos, Thaumas, or Tantra +2?

I've been messing with it a bit too... Not sure how accurate it is... According to it, I came up with the following for Victory Smite...

Heafoc + Tantra Gaiters+2 beats out Heafoc and Kacura Leggings +1...

...but Mustela Gloves + Kacura+1 beats Mustela and Tantra+2...

Seems odd to me... A few other things were a bit surprising...

That sounds like an acc issue to me.

overvalues/undervalues attack quite considerably, disparity between an average pDIF and an average cRatio, so if there's some sizable difference in attack between x vs y, you could see some inaccuracy based on what you'd assume to be better compared to what the spreadsheet spits out.

I've come across a couple of things that weren't correct in various spreadsheets - it's not really surprising, they contain a ton of stuff, and it's not like they go through a QC process. If something looks wrong, it very well could be, but I've found that if you look into it, the problem can be easily understood. They're still a very good tool.

As far as other unexpected results, I've definitely been surprised, too. But in those cases, it ended up being something like having Berserk active when I thought it was inactive, or having the wrong mob selected.

No less accurate than the methods these programs utilize to incorporate the stats from all other gear as far as I know. Whenever a set effect has been relevant to one of the sets I was looking at, I would give one of the pieces of gear in the set whatever the additional stats are acquired by the set effect. For instance, when looking at a set that has Athos Hands and Legs equipped at the same time, I added 3% crit rate to athos's gloves in the armor database to account for the set bonus from having two items equipped. (Just be sure to return the item's values to normal after you have finished examining the numbers).

I'm also confused on the first page what Set Ratios are. They are found under combined results. Set 1 is set as 180 and Set 2 as 120.

Time ratios for each set for the purpose of calculating net DPS. 180 seconds and 120 seconds in that case, which lines up with Berserk/Impetus uptimes and the following cooldown.

The set bonus field at the bottom of each set is user-editable for this purpose.

Thank you; that is very helpful to know.

What should I put into the set bonus for Tantra +2 gear?

Set bonus for Tantra+2 gear is already handled by the spreadsheet. However that is the only set bonus handled automatically, because it's more complicated than just "+5 str" or whatever.

All other set bonuses are things you'll need to add manually to the blue line, for your particular testing purposes.