DPS Spreadsheets

**EjinCaitsith** · 2013-07-30 03:48

Would it be possible to add an Impact toggle under the 'Target' section?

**Motenten** · 2013-07-30 15:28

I'll start adding it in as I revise spreadsheets with Geo buffs/debuffs.

**Fake** · 2013-08-03 12:09

Was setting default job level to 80 on MNK sheet intentional? I couldn't figure out why my accuracy was so bad for like 5mins until I saw I only had 317 skill.

**Motenten** · 2013-08-03 20:54

Ah, that was some comparison I was doing regarding how Footwork fared at level 80 cap. Had to fix something at the same time, but thought I put it back at 99 before uploading. Will upload a new version.

**Motenten** · 2013-08-06 03:36

All the .xlsx files have been updated with the new weapon stats. Still have to add armor, then will do the conversion to .xls.

**Motenten** · 2013-08-06 05:48

All existing armors have had their stats updated (except the magic spreadsheet, where there's other work that needs to be done). New armor hasn't been added yet. .xlsx only for now. Will work on the remainder tomorrow.

**Motenten** · 2013-08-07 03:50

All new armor added, for all spreadsheets except magic damage. .xls versions uploaded as well. (may be a few minutes after this post before they finish uploading)

**Foldypaws** · 2013-08-07 16:42

DRG spreadsheet is missing Letalis Mantle, for whatever that's worth.

**Motenten** · 2013-08-07 17:25

Added.

**Alahra** · 2013-08-07 19:40

Would it be possible to add a Dagger toggle for the off-hand at some point on the NIN sheet, as with the off-hand toggles on some of the other sheets? Without Pamun, Aphotic seems to be a reasonable off-hand choice.

**Motenten** · 2013-08-08 02:12

Updated for that. Note that dagger can only be selected for the offhand. Only dagger included is Aphotic.

**Motenten** · 2013-08-08 19:01

Magic spreadsheet updated with the new armor, and with proper Helix spell formulas (not always perfect, but should generally be within a point of actual). There's also a toggle for initial damage vs total damage on the setup page, though I didn't completely validate how many ticks there were supposed to be; just used info from the wiki.

**Slytribal** · 2013-08-09 15:22

There appears to be a problem with the Drk spreadsheet. Gear set 2 has an error 508 on most of it's stats, and I can't figure out a way to fix it at all.

**Motenten** · 2013-08-09 19:01

Which version of the spreadsheet are you using, and what program are you using to edit it?

**Fwahm** · 2013-08-09 19:04

Hey Motenten, think there will be a way to put Ionis as a buff in the future?

Unless I missed it, which is entirely possible.

**urat** · 2013-08-10 02:46

Would it be possible to make a copy of the set DPS cell underneath the the TPing armor set. Having to constantly scroll back and forth between the armor list and checking what my DPS is now is a giant pain in the ass. Every time you update I need to re add one of my own and I think it might be a quality of life increase for the DPS sheets.

Just a little cell that copies the value from the normal DPS cell does the trick.

Edit: also to check, do you have the proper stats for xux trousers atm, or do we even know all of them. SE added acc to a lot of armor so its possible Xux trousers has more than jus str/dex/agi and may have different attack/acc then it has in its .dat

**Feel** · 2013-08-10 05:55

Cataclysm with Velkk Staff or Spinning Attack with Oatixur, does anyone know which would do more damage for AoE farming in Abyssea?

**Motenten** · 2013-08-10 07:32

Originally Posted by urat

Would it be possible to make a copy of the set DPS cell underneath the the TPing armor set. Having to constantly scroll back and forth between the armor list and checking what my DPS is now is a giant pain in the ass. Every time you update I need to re add one of my own and I think it might be a quality of life increase for the DPS sheets.

Just a little cell that copies the value from the normal DPS cell does the trick.

Unfortunately the Gear page is already more cramped than I'd like. As it is, it's designed to fit on a 1680x1050 screen and show all vertical data, though you need to turn off the ribbon if you're using Excel 2007+ (Excel 2003 and Calc should be fine if you have a single toolbar at the top).

However I can see your point on putting the overall DPS value closer to the TP gear, and leaving the weaponskill damage under the weaponskill gear. Even on relatively small screens, it should still be possible to keep all relevant information within visual range. It may not be immediately obvious that Set DPS includes weaponskill damage, but it shouldn't be too difficult to work out. I'll update the spreadsheets for that.

Originally Posted by urat

Edit: also to check, do you have the proper stats for xux trousers atm, or do we even know all of them. SE added acc to a lot of armor so its possible Xux trousers has more than jus str/dex/agi and may have different attack/acc then it has in its .dat

Xux Trousers stats are pulled from the ones I have, which I verified for all stats except accuracy (assuming that that didn't change). As far as I noticed, there wasn't a single piece of existing armor that had any of its pre-patch stats changed; only new stats were added.

**Motenten** · 2013-08-10 08:23

Layout adjustments made; uploading now.

**Motenten** · 2013-08-10 08:24

Originally Posted by Fwahm

Hey Motenten, think there will be a way to put Ionis as a buff in the future?

Unless I missed it, which is entirely possible.

I'll see about it.

Thread: DPS Spreadsheets

Thread Tools

Latest Threads

Up & Coming Threads

Hottest Threads