DPS Spreadsheets

**Motenten** · 2012-10-10 17:01

Originally Posted by ccl

Would it be possible to add an "open with sekka ws?" button ?

Will try to add this in, but won't be immediate.

**Kincard** · 2012-10-11 13:01

Do you think you could add the option to change sub weapon into shield or empty hand on dual wield jobs (NIN, THF, DNC). Wondering how mythics work if you single-wield them since AM3 might make offhand actually lower your damage.

**Motenten** · 2012-10-11 19:48

Can already do that on Dnc (select 'None' as the weapon). Given that the difference is marginal at best on dnc, I can't imagine it being useful for nin, especially since the weaponskill is so horrible, and the weapon's delay is so high. May add the option for thf, though again the weak weaponskill makes it an extremely difficult sell.

**Baki20xx** · 2012-10-19 17:40

Hey mot, new poster, but very frequent, long time, reader. I was wondering if you could add the koga kyahan +2 to the nin spread sheet. I've been using them in my blade:Hi build until i get something better. I was wondering how they match up. Thank you

Koga Kyahan +2
DEF:20 STR+7 DEX+7 VIT+9 AGI+9
Ninjutsu skill +15
Enmity+4
Lv.90 NIN

EDIT: also the Kudzu Aketon from Morta. I would like to see how it holds up as well.

Kudzu Aketon
DEF:60 STR+10 AGI+10
Attack+13 Ranged Attack+13
"DOuble Attack"+3% "Store TP"+5

**Motenten** · 2012-10-21 02:41

Added.

**Baki20xx** · 2012-10-21 04:47

Thanks, you're the man.

**BruHaus** · 2012-10-31 13:55

On the WHM Spreadsheet, seems Suppanomimi's Sword skill is adding to damage with Clubs on. Manually edited it out myself in the Gear lists on my spreadsheet, but just thought I'd throw it out there if you wanna edit the downloadable one. :3

**Motenten** · 2012-10-31 17:36

Thanks for the note. Fixed it.

Need to get back and fix some of the last upgrades... meh.

**EGWe** · 2012-11-04 07:28

Dear Motenten,

I would like to personally thank you for the great work in Spreadsheet it has increased my overall damage and understanding of stats especially for my thf sets.

I would like to know if there are any plans to have one applied for ranged attack that can be used for rng.

Thanks

**Nightfyre** · 2012-11-04 13:06

DRK AM3 doesn't work on set 2 (references wrong cell) and set 2 weaponskill grip seems to have its own list rather than referencing the TP grip cell.

**Motenten** · 2012-11-04 18:02

Originally Posted by Nightfyre

DRK AM3 doesn't work on set 2 (references wrong cell) and set 2 weaponskill grip seems to have its own list rather than referencing the TP grip cell.

Do you have the latest version? The AM3 should have been fixed a while back.

Grip fixed. New version uploaded.

**Motenten** · 2012-11-04 18:04

Originally Posted by EGWe

I would like to know if there are any plans to have one applied for ranged attack that can be used for rng.

It's something I'd like to eventually get to, but it's not on the immediate list of things to do.

**Aja** · 2012-11-06 19:52

Perhaps a space for 12 AGI merits also, I have AGI merits because of Ranger.

**Loziel** · 2012-11-07 07:55

Drg spreadsheet the mekira oto ftp bonus is not pulling through properly on set 2

Where does it factor in the special extra damage for relics? Do you need to add that in somewhere, I haven't been able to locate the info on double/triple damage and the proc rate

Do empys come pre loaded with odd at the correct levels or does that need to he manually added?

Thanks

**Motenten** · 2012-11-07 14:01

Drg spreadsheet the mekira oto ftp bonus is not pulling through properly on set 2

Make sure "Day for fTP Bonus" flag is set on the Setup page.

Where does it factor in the special extra damage for relics?

The "Relic Bonus" line on the Data page. It's line 99 on the Drg sheet.

Do empys come pre loaded with odd at the correct levels or does that need to he manually added?

The value needs to be set manually, since it varies based on TP used, and the TP used for the aftermath may not be the same as the TP used in the weaponskill calculations.

**Martel** · 2012-11-07 22:53

I'm wondering how to measure the DMG potential of the new DRG SP. In case you hadn't seen it:

Dragoon DRG SP2 While effect is active, there will be no cool down timer for Jump.

So, in regards to the spreadsheet. Would setting the Delay/Round for jump to 2~3 be an decent representation of this effect?

**Motenten** · 2012-11-08 11:39

Considered using Over-Time value, but that wouldn't actually work out right. Also, found a bug in that set 2's jumps were referencing set 1's Over-Time value. Fixed.

Added an extra flag for SP2, and put an assumed 3 second delay on jumps when it's active (being generous and assuming a stacked Jump/High Jump, or Spirit Jump/Soul Jump, as frequently as possible), ignoring merits and Over-Time delay. In doing so, also found a flaw in integrating jump damage with normal melee/weaponskill damage. This will reduce normal DPS a small bit, but at the SP2 level of delay it would have doubled the effective damage from jumps. SP2 damage is probably not completely accurate, but should be workable.

**pancakesandsex** · 2012-11-09 09:54

Suggestion:

In order to facilitate ease of use, change the ODD field to a drop down where you can select "MAM1, 2, 3, EAM1, 2, 3" etc.

**Khary** · 2012-11-09 10:09

I'd love to make use of your sheets, but all I can do is view what's been filled in. Are we supposed to be able to plug in our gear and get information about it or have you designed them to simply be viewed?

**NynJa** · 2012-11-09 10:12

Run them on your pc, works for me.

Thread: DPS Spreadsheets

Thread Tools

Koga Feet +2 add please?

Latest Threads

Up & Coming Threads

Hottest Threads