DPS Spreadsheets

[Fwahm]

In the DRK spreadsheet (which I redownloaded today), I'm getting discrepancies in attack and accuracy.

Hume DRK/SAM, Ragnarok 119, 15 STR and DEX merits, Ionis, and no other gear, /checkparam says that I have 856 attack and 745 accuracy, while the data page of the spreadsheet says that I should have 868 attack and 752 accuracy, discrepancies of 12 and 7.

In my standard low accuracy meleeing set, with the same weapon, merits, and Ionis, /checkparam says that I have 1060 attack and 885 accuracy, while the data page says that I should have 1072 attack and 883 accuracy, discrepancies of 12 and -2.

In my high accuracy meleeing set, with the same weapon, merits, and Ionis, /checkparam says that I have 1060 attack and 963 accuracy, while the data page says that I should have 1077 attack and 960 accuracy, discrepancies of 17 and -3.

Also, the weapon skill column on the gear page (the one that shows you your DPS at the bottom of the gearset), the numbers are all blank regardless of weapon, though weapon skill is still increasing your attack and accuracy.

In addition, for some reason, adding Mekira-oto +1, Ele belt, and Ele gorget to one gearset results in a 0.29 fTP total in the gear page, instead of 0.30.

Finally, I was wondering; on the gear stat page, what's the difference between fTP (such as on Mekira-oto +1) and DfTP (such as on Ele belt and Ele gorget)?

My low accuracy meleeing set is:

Ragnarok 119/Bloodrain/-/Ginsen
Otomi/Ganesha's/Bladeborn/Steelflash
Xaddi R15 A/Xaddi R15 C/Rajas/K'ayres
Atheling/Windbuffet/Xaddi R15 A/Xaddi R15 A

My high accuracy meleeing set is:

Ragnarok 119/Bloodrain/-/Ginsen
Yaoyotl/Iqaba/Bladeborn/Steelflash
Xaddi R15 A/Xaddi R15 C/Rajas/Mars's
Letalis/Anguinus/Xaddi R15 A/Xaddi R15 A

[Motenten]

Also, the weapon skill column on the gear page (the one that shows you your DPS at the bottom of the gearset), the numbers are all blank regardless of weapon, though weapon skill is still increasing your attack and accuracy.

If you mean iLvl skill, that's because that's handled differently. The weapon "skill" category is for things like Love Torque increasing Dagger skill. That skill is applied to all weapons equally. 'Combat Skill' on iLvl weapons, however, is only applied to each weapon individually. I didn't add it to the gear page because there's no point in doing so; the skill for each weapon applies only to that weapon, and doesn't get added with any other gear. Plus the gear pages are already pretty wide, and I try not to add more columns if I don't have to.

In addition, for some reason, adding Mekira-oto +1, Ele belt, and Ele gorget to one gearset results in a 0.29 fTP total in the gear page, instead of 0.30.

That's because their value is actually 100/1024, not an exact 0.1. 300/1024 = 0.29296875

Finally, I was wondering; on the gear stat page, what's the difference between fTP (such as on Mekira-oto +1) and DfTP (such as on Ele belt and Ele gorget)?

You have that backwards. DfTP is for the Mekira-oto, and ordinary fTP is for the gorgets and such. The difference is that the DfTP values only get applied if you also set the flag on the Setup page for "Day for fTP bonus", since they only work on certain game days.

Hume DRK/SAM, Ragnarok 119, 15 STR and DEX merits, Ionis, and no other gear, /checkparam says that I have 856 attack and 745 accuracy, while the data page of the spreadsheet says that I should have 868 attack and 752 accuracy, discrepancies of 12 and 7.

Hm. If I set Hume drk/sam with Rag 119 and 15 str/dex merits, all buffs set to 0, no food, no songs, etc, I get 856 attack and 745 acc. You possibly forgot to turn off brd songs? Brd af3 bonus adds to the stat corresponding to the song element, so if you left Marches on, you may have gotten an extra 10 dex (and thus, 7 acc). Not sure on the att side, though, since Minuets would have changed more than that. Hmm. It would end up at 868 att if you had Boost-Str on with 400 Enhancing skill.

[Fwahm]

I did have the bard songs clicked in, which moves down my accuracy by 7-8. However, now the discrepancies on the my other two sets are larger (-10 and -10). Also, I didn't have Boost-STR active.

The discrepancies change with the gear I equip, which means it's not entirely from buffs that I've clicked on elsewhere.

[Fwahm]

I found the error, for accuracy at least. Xaddi Mail R15 Path A only has 10 accuracy in the spreadsheet, while it actually has 20.

Also, if you find some extra time, some nice things to have in the next major update to the DRK spreadsheet would be Mars's ring, Scourge, and areas to input VIT, INT, and MND as merits on the main page.

I'm still stumped on the attack difference.

[Motenten]

Xaddi Mail fixed for all jobs that use it. Added Scourge to drk and war. Added Mars Ring to drk. Added Vit/Int/Mnd merits to drk.

[Staesse]

Thanks for all of the hard work put into keeping these updated!

Found a couple things in the Ranger spreadsheet:
Data, Row 140, Relic Rates:
IF(OR(RIGHT(R.Gear!$B5, 4)="(95)", RIGHT(R.Gear!$B5, 4)="(99)")
I think the weapons' names were changed at some point. They are now "99" and "95" instead of "(99)" and "(95)". Also, 119 isn't in the calculation
Gear List, Body, Sylvan +2:
Doesn't have a Snapshot +5 associated with it while Velocity Shot is active
Melee, Row 184, Set 2 Barrage:
Named "Melee Hit Rate", it is using the Ranged hit rate though, just the name is wrong.

Edit:
It also looks like the Arcadian Hat is not being used to calculate Recycle TP Bonus.
Edit 2:
Also, the Barrage calculations are not correct on the Melee page. Shot 11 is subtracting Shot 9 ACC from Base Ranged ACC. Should use Shot 10 ACC from Base Ranged ACC for 57% chance of hitting all 11 shots.

[Motenten]

Data, Row 140, Relic Rates

Fixed.

Gear List, Body, Sylvan +2:
Doesn't have a Snapshot +5 associated with it while Velocity Shot is active

It does, but it's in the Data page summation.

Melee, Row 184, Set 2 Barrage:
Named "Melee Hit Rate", it is using the Ranged hit rate though, just the name is wrong.

Fixed.

It also looks like the Arcadian Hat is not being used to calculate Recycle TP Bonus.

Fixed.

Also, the Barrage calculations are not correct on the Melee page. Shot 11 is subtracting Shot 9 ACC from Base Ranged ACC. Should use Shot 10 ACC from Base Ranged ACC for 57% chance of hitting all 11 shots.

Fixed a few copy/paste errors for shots 10-12 in both sets.


Thanks for the info. New version pushed.

[Prothescar]

Not sure if it's true for all of them, but BLU spreadsheet has -10 Store TP for Smoldering Salisbury Steak whereas the food hasn't got that on it; attack values are 160cap, 21%. I added the recent BLU spells to it for my copy but can't figure out how to actually make it detect them on the spell list sheet, I can provide the data for them if you want to add to the main repository version.

[Motenten]

Steak fixed
Added new spells to selectable list
Added Nature's Meditation flag and attack bonus
Rewrote spell set/lookup page, using newly available info (number of trait points per spell)
Acc and Att traits now get actual tier bonus instead of just first tier bonus
Revised how it gets totals for stats per set spell

New version pushed. Let me know if I broke anything.

[Prothescar]

thanks will check it out in a little bit


edit: Nat. meditation, Fighter's roll, Rogue's roll, and Enspells (incl. Ifrit) don't seem to be doing anything when toggled on, unless I'm doing something wrong

[Motenten]

Nature's Meditation will only boost your attack if it's also in the set spell list. The others I'll look at.

[KuKuKaChoo]

On the RNG spreadsheet, the Base TP value is 50 too high. For Anni, it should be 167 instead of 217. I don't know if it's adding the Recycle TP early or if it's some other error, since that's still being added after STP calculations.

[Prothescar]

Nature's Meditation will only boost your attack if it's also in the set spell list. The others I'll look at.

have got it in both, I'll play around with it a bit more and see if I'm just botching it somehow

edit: yeah I dunno. it looks like it's calculating the attack bonus appropriately but isn't actually adding it to anything

Spoiler: show

[Motenten]

Yeah, found the problem. Fixing that and the others now.

[Motenten]

Ok, fixed and uploaded.

[Motenten]

On the RNG spreadsheet, the Base TP value is 50 too high. For Anni, it should be 167 instead of 217. I don't know if it's adding the Recycle TP early or if it's some other error, since that's still being added after STP calculations.

That's a known unknown, and at least confirmed as being incorrect now. No one's done the data collecting to determine the TP formula at higher delay values yet.

[Prothescar]

hate to keep coming in with problems but:

set 2 is getting extra tp/hit from somewhere (or set 1 isn't getting enough) and set 2's nat. med doesn't work. sorry D:


edit: i think set1 isn't getting the benefit of Store TP trait from spells, it looks like the store TP code references O26 instead of H26

[Motenten]

set 2's nat. med doesn't work.

Fixed.

set 2 is getting extra tp/hit from somewhere (or set 1 isn't getting enough)

Possibly have Store TP trait from the second spell set?

[Prothescar]

all seems well now, thanks much

[KuKuKaChoo]

That's a known unknown, and at least confirmed as being incorrect now. No one's done the data collecting to determine the TP formula at higher delay values yet.

Well, in the meantime, I can manually input whatever base TP I need easily enough. I did come across a few more errors:

In Data G107, looks for gear in R.Gear S11 instead of X11

In Data G46, I46, K46, looks for Prelude 1 value in Setup K30 instead of K31. In addition, Prelude 2 base value is listed as 30, should be 40. Prelude 1 is listed as 15, should be 30.

In Data N48, base Sharpshot Acc is listed at 100, should be 50

Pot-au-feu in food data is missing Ratt Multi of 15%, Ratt Cap of 60

In Weaponskill Q1073, Q1606 only checks for Scout +2 (no Arcadian/+1) in TP gear (row 7), not WS gear (row 33)