Dragoon Damage Spreadsheet

[Miraun]

I compiled most of the gear, and all of the damage equations into a fancy excel spreadsheet.

mirauns-drg-spreadsheet - Project Hosting on Google Code


What it does:

Calculates ACC/ATT/Average Damage per melee hit, Jump, High jump, WSs, Damage per minute, Weapon skills per minute.

Allows 3 gear sets, and shows stats based upon gear selections. Selectable series of buffs.


What it does NOT do (yet)
Take into account Hasso / Berserk / Warcry from subjobs
Piercing Bonus on Birds
Augmented ACP/Moogle Augmented Gear
... Handle any augmented gear


If there is anything to add to the spreadsheet, please attach an issue report with what you would like to see added.


If anyone knows a good repository for HNM or other mobs' DEF, EVA, AGL, and VIT values, please send me a PM. Thank you.

[Darkslitter]

Calculates ACC/ATT/Average Damage per melee hit, Jump, High jump, WSs, Damage per minute, Weapon skills per minute.

ftfy

Spoiler: show

bring it back.

[Yugl]

Apparently my excel cannot take on the features of this spreadsheet, so I cannot see the values calculated. Looked very nice though. Don't make one for other classes no matter how much they ask you though.

[Cream Soda]

As I said on alla, great first try, but w/o ability of hasso, all numbers involving haste will be thrown off

[Miraun]

As I replied... If you're using hasso that often in a merit party on DRG, you're likely not at a point to worry about this.

If it's something you want that badly to toggle Hasso, fill out an issue ticket like I requested. I'm not going to be checking 3 different forums, PMs, etc to find people with individual add item X / Y, etc.

[Cream Soda]

There's many situations where you can fulltime hasso, and some where you can't, but if you're in the situation where you have to full seigan, then you should prolly be doing a /pcmd leave in the first place. I do my comparisons out by hand, am not good w/ spreadsheet, so I have no interest in making any modifications. I'm just making an observation that the actual data that is presented, provided its correct, is still not going to be viable in a lot of situations.

[Therin]

I really don't know much about coding or what kind of work goes into making a spreadsheet like this. I do know, however, that in most situations it is more efficient to use Hasso. If the purpose of this spreadsheet is simply for calculating optimums, I would say adding Hasso functionality is paramount. In the real world, there are many unaccounted for variables though. As a DRG I find myself using Hasso more often than not (as DRG often has other ways to mitigate its own damage taken), unless I'm in merits. However, the thing about merits is that parsing in general is always inaccurate unless you have a ridiculously large number of parties and situations in which to compare two melee. This is especially true on birds, where your strongest DDs are by nature handicapped due to Feather Tickle.

Overall this looks to be a decently useful guide. My point is that spreadsheets and parsing alike are for calculating optimums - you'll rarely see in-game results that approach what your calculations might suggest, for a number of variables. For that reason, adding Hasso is a good idea - since you're probably only operating under "the best conditions" anyway.

[Miraun]

I really don't know much about coding or what kind of work goes into making a spreadsheet like this. I do know, however, that in most situations it is more efficient to use Hasso. If the purpose of this spreadsheet is simply for calculating optimums, I would say adding Hasso functionality is paramount. In the real world, there are many unaccounted for variables though. As a DRG I find myself using Hasso more often than not (as DRG often has other ways to mitigate its own damage taken), unless I'm in merits. However, the thing about merits is that parsing in general is always inaccurate unless you have a ridiculously large number of parties and situations in which to compare two melee. This is especially true on birds, where your strongest DDs are by nature handicapped due to Feather Tickle.

Overall this looks to be a decently useful guide. My point is that spreadsheets and parsing alike are for calculating optimums - you'll rarely see in-game results that approach what your calculations might suggest, for a number of variables. For that reason, adding Hasso is a good idea - since you're probably only operating under "the best conditions" anyway.

It's a fix that'll take 3 minutes. I'll roll it out with a sheet for augmented expansion bodies / hats. I should have a new version by Friday with those.