DPS Spreadsheets

**Motenten** · 2013-04-29 06:06

Updated Leisilonu in dnc.

Added brd spreadsheet. Next major project will probably be rng/cor.

**Taim Meich** · 2013-04-29 10:50

RUN spreadhseet lacks Hasso's contribution to Accuracy.

**Motenten** · 2013-04-29 16:11

Originally Posted by Taim Meich

RUN spreadhseet lacks Hasso's contribution to Accuracy.

Fixed.

Also:

New gear added.
Edit: Added new gear from the dat mining thread; see that there's a ton more on the wiki, so will have to go back and finish that.

All merit weaponskills' WSC adjusted to 82.35% + 3.53% * #merits. This scales to the values in the update notes after you apply the 0.85 alpha, though there's the possibility of slight rounding errors for all but 5/5.

Desperate Blows not added in yet; need data on the haste effect first.

**Taim Meich** · 2013-04-29 16:22

Any chance you'll add Lunge to the RUN spreadhseet? Not even needed to add MAB gear, you could just make a MAB cell to be filled.

**Stanislaus** · 2013-04-29 17:27

Originally Posted by Stanislaus

NQ Hexed Armor does not get the max augment that the Hexed -1 does, if you want to fill in the Augments.

**Motenten** · 2013-04-29 20:09

All spreadsheets have had their set handling updated to a slightly better code setup. Can now specify two distinct items to form a set (so "Lava's" and "Kusha's", instead of "Lava's+Kusha" that needed to be entered in both slots). This is necessary to deal with some of the new set items showing up in the dats, but also makes gear entry a little cleaner (ie: I don't need to add in "Toci+Ocelomeh" type pseudo-entries).

**Evenstar** · 2013-04-30 07:07

First of all thanks for the spreadsheet.

I was checking the BST spreadsheet and I am a bit confused by the Oce. set bonus. It gives 9% to TA, that should be 3% no?

**Motenten** · 2013-04-30 14:05

Which combination of gear gives you that bonus?

Edit: Never mind, found it. Hmm. This'll be a bit tricky.

Edit2: Ok, found a fix for it. Working on updating all the spreadsheets.

**Motenten** · 2013-04-30 14:47

Ok, fixed and uploading.

**Toioiz** · 2013-05-01 09:11

Have a question about the SAM Spreadsheet. It looks like the store TP pieces use the full number value when calculating DPS, even when they don't boost you to a 'new x-hit'. Trying to figure out if that was intended, or the logic behind it. example, at the point that I'm at a 5 hit without rings, why would a tyrant's ring be better than a ATTK+10 ring for TP if it doesn't take me to a 4 hit?

**Jem** · 2013-05-01 09:37

I assume it's because the extra TP increases WS damage so outdoes the extra 2 attack on TP phase.

**Motenten** · 2013-05-02 02:33

By the way, can anyone point me at the posts that were going over the changes in level correction after the March patch? Just realized I didn't adjust that in the spreadsheets.

**Whiteknight** · 2013-05-03 16:43

Hey.
Can you add the new polearms, and the new stuff to drg?
Yayotlm helm, K'aryes ring, Bladeborn/steelflash earing, mikinaak greeves/legs, whrilpool greaves, and upukirex.
Also, is the dmg on the new weapon correctly factored in the spreadsheets?

Thank you

**Motenten** · 2013-05-06 23:57

All new gear has been added to all jobs (including set handling for the earrings).

War DW spreadsheet removed; DW handled in main War spreadsheet now.

Gear list pages have been revamped to be compatible across jobs (for the most part), so that it's easy to copy and paste between them. This also means that there's stats on each sheet that may not apply to that job; don't worry about it, it doesn't affect anything. There's a possibility of some things getting slightly messed up in the process, so let me know if you see anything odd.

Fixed a few misc bugs.

Note: I'm not dealing with any augmented gear/weapons. If you want that accounted for, use the Custom lines.

**Motenten** · 2013-05-07 02:11

Seeking a high-end (and maybe a mid-high) suggested target for the Adoulin mobs. If you have a suggestion for a mob target that you think would be suitable for generalized use, please list it.

Also considering dropping the Hydra targets, and perhaps Bukhis, from the lists. Not sure anyone actually uses them, and their main purpose (high def, low level correction) has been superseded by Adoulin mobs. If anyone has an opinion on the matter, let me know.

**Taim Meich** · 2013-05-07 02:33

I stopped using Hydras when you added Chapulis, they serve the same purpose. Bukhis, I've almost never used it, but I guess it's nice for some Abyssea calculations?

Thank for the great work, as always!

**Fake** · 2013-05-07 13:52

Fugacious Diremite/Crawler and Fugacious Luckybug both found in Ceizak fracture.

Diremite/Crawler should have fairly neutral stats and Luckybugs seem to be more evasive.

Both those mobs should cover the new delve fodder. There may also be a suitable high defense fodder mob in Foret, but I'm purely speculating since I've never done it.

**Malicat** · 2013-05-08 14:59

I'd love to see both fracture fodder (like Fugacious Diremite) AND a delve NM included for Adoulin mobs.

I don't use the Hydra listing, but I do use Bukhis for Abyssea Evisceration sets.

Any luck finding the level correction changes from the March update?

**Motenten** · 2013-05-08 18:55

No, no info on the level correction yet. I'll probably add the diremite, maybe the ladybug, and eventually try to get stats for one of the bosses. Do fodder mobs show up as ITG? I don't remember offhand. If not, anyone could provide a bit of data on level range, defense and evasion.

**Yugl** · 2013-05-08 18:59

They're ITG as well.

Thread: DPS Spreadsheets

Thread Tools

Latest Threads

Up & Coming Threads

Hottest Threads