DPS Spreadsheets

**timboly** · 2013-08-12 14:12

For the COR spreadsheet, it seems like it's not picking up the combat skill + from the main hand/offhand and ranged weapons. The gear list page is also missing the Halachuinic sword's combat skill values.

**Motenten** · 2013-08-12 23:41

Fixed.

**Motenten** · 2013-08-16 05:50

White magic nukes implemented.

Placeholders for dark element black magic (Comet/Meteor/Impact/Kaustra) in place, but not implemented yet.

**Viar** · 2013-08-20 11:39

Another COR spreadsheet question: Is it possible to separate snapshot in ranged TP set, since most players has different set for snapshot precast?? Right now high snapshot gears are boosting /ra TP DPS higher than it should be. For example, Commodore +2 with 7 rattk/racc and 5 AGI beating mani R15 with 30 rattk, 10 racc and 10 AGI.

**Seha** · 2013-08-20 11:42

Relic gloves have 9% snap, Manibozho 4%, seems normal that the former have higher dps.

**Viar** · 2013-08-21 07:58

Originally Posted by Seha

Relic gloves have 9% snap, Manibozho 4%, seems normal that the former have higher dps.

No no, what I mean was, you're supposed to finish /ra in Manibozho, and Manibozho is supposed to have higher DPS than relic gloves because you have separate snapshot set with relic gloves.

But spreadsheet kinda calculate your /ra DPS as if players shoot in snapshot and don't gear swap.

**Dotsudoku** · 2013-08-21 14:17

Potentially user error, but if it is I can't figure out the source for the life of me. The RNG spreadsheets are giving me really bizarre acc/racc values with Donderbuss

**Dotsudoku** · 2013-08-21 18:00

Derp, figured it out. It seems as if combat skills from weapons aren't making their way into the calculations, even though they're in the gear lists (correctly?)

**Motenten** · 2013-08-21 19:45

Rng fixed.

**kenshyn** · 2013-08-23 13:51

Originally Posted by Motenten

Rng fixed.

Holy hell no wonder I was scratching my head on all the racc and agi I needed to cap hit rate on Tojil guess I should have look deeper instead of stacking more racc lol Thanks....

Doh
1130 1032
1.4459 1.3455
205.0% 156.0%
95.0% 95.0%
LMAO

**Fwahm** · 2013-08-26 20:46

If I wanted to add Ionis to the Dark Knight spreadsheet, how would I go about adding it to the front page, and giving it the relevant bonuses?

**IceSylph** · 2013-08-27 19:39

Happened to notice that DRG, BLU, DRK are missing Minuet 3 and also missing all the GEO buffs/debuffs on the spreadsheet.

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

Those adjustments take a lot of time to complete (it can take an hour or two per spreadsheet, and there are 18 spreadsheets....), and I haven't had a lot of time to work on the spreadsheets recently. Will get to them eventually.

**kenshyn** · 2013-09-05 08:51

Any chance of adding range to the sam sheet for apex arrow/Namas arrow ws?

**suji** · 2013-09-07 19:48

In the RNG spreadsheet, the Recycle bonus for using Scout's Beret +2 during WS is not being added to WS TP.

Edit: btw, if you wouldn't mind, can you paste the contents and location of the fixed cell here so I can avoid having to redo all of my gear sets? thanks!

**Fwahm** · 2013-09-17 10:45

Pak Corselet/+1 still have the pre-item level patch stats on the DRK and PLD spreadsheets (including no haste), and none of the Adoulin gear added before Skirmish v2 have any HP listed on the DRK spreadsheet.

**Matoks** · 2013-10-03 09:56

Many thanks for the excellent spreadsheets! As an ex-modeller myself, I fully appreciate the skill ... and the effort!

One question about the MNK spreadsheet. Tab = Setup, Cell = B21. This cell toggles (I think?) whether you use boost before Shijin. Yet when I change it from 0 to 1, the value in cell B36 (total WS damage) does not change. Am I using this toggle incorrectly, or does boost not affect WS damage when using Shijin?

**TSFFXI** · 2013-10-03 10:45

Is your attack already capped?

**Darkmagi** · 2013-10-03 11:45

Alternatively boost is bad and it's slowing your ws frequency down.

**Matoks** · 2013-10-03 14:10

Thanks for the two responses.

As I understand it (and I could well be mistaken!) the "attack cap" is not on the absolute amount of att but on the att/def ratio. The ratio can not exceed 2.25. I generally fight strong NMs (eg: Tojil) so I would not anticipate that I would reach this ratio, even for a fully buffed Oatixur MNK. Does the spreadsheet apply an attack cap? Or is there an input that I did not see for mob's DEF?

On the second point: I agree that boost slows down the Shijin, but I would be surprised if the damage increase and speed decrease would offset so perfectly that the average WS damage in B36 does not change by even 1. I note that even when I change gear, and the WS damage figure changes, the removal of boost has zero effect.

Thread: DPS Spreadsheets

Thread Tools

Latest Threads

Up & Coming Threads

Hottest Threads