DPS Spreadsheets

These are the spreadsheets people use when then compare sets and such right? Or are there different ones?

Google Docs

And if they are... I noticed an error in the Warrior one... Or at least in my version (which I just downloaded so it should be the most current)...So who do I report it to?

(More specifically under the gear tab(or sheet), cells P20/P42 and AI20/AI42 should be the same but they aren't...)

Really no one knows what I'm talking about?

/le sigh

They're motenten's spreadsheets. He's on these forums from time to time. Yes, there are a couple bugs, there's one in the DRK one as well. Should be able to just look carefully and change it yourself. The DRK one was simple enough to figure out. If not, light the Motenten signal.

Yes, those are my spreadsheets.

On P20/P42 and AI20/AI42, why do you think they should be the same? The column value is WS Dmg, but it's a sum of the gear for each of their respective sections. WS Dmg for TP gear is irrelevant, but is included because that's a remnant of when I started splitting up stats that were only relevant for melee or weaponskill. There's nothing else to put in the melee sections, so it had a leftover entry.

Regardless, P20 is the sum of the TP set 1, while P42 is the sum of the WS set 1, and there's no reason to expect them to be the same.


Also, please let me know what the bug in the drk spreadsheet is.

One thing I noticed when I was using the DNC spreadsheet is that it didn't recognize that Coruscanti's Critical Hit Rate + affects both hands.

In the version I had (I since fixed it...) P42 was Which is the sum of the WSdmg column for WS Set 1..

However AI42 which is the sum of the WSdmg column for WS set 2 was...

Not sure if i remember them all, but one of them was that twilight gear doesnt have all the stats on it. Int, Mnd and Agi are used as modifiers for some weaponskills. I think catastrophe haste wasn't being applied to lvl 95 apoc for the second gearset (C94 on the data worksheet). That's all i can remember right now.

Simple fixes. They're great tools, thanks a lot. Can't tell you how much i use them.

Ah, ok, I understand now. Fixed that.

Also made some significant updates to the war spreadsheet. Added greatswords and Resolution due to a request. Added a flag for Mighty Strikes. Updated the weapons list.

Fixed the Apocolypse haste issue and Twilight stats for drk.

On Coruscanti, that's a little trickier to do, though possible. For now you need to set fake versions of your offhand weapons with the extra crit rate.

Anyone ever come across a DPS spreadsheet for BST?

Thanks for the updates... ^^

NIN Spreadsheet... Byakko CR(Safe to assume Byakko with Crit +4%?) doesn't give haste, or Crit +4%.

Yeah, that's what I did :D

Speaking of which,I have a copy with all of these changes plus some additional equipment (99 magians etc) and automatic adjustments for Athos and Ocelomeh set bonuses that I can send you if you want. I also changed values for Innin to better reflect averages as it decays over 3 minutes.

SAM spreadsheet, last time I looked Kogarasumaru had WSDMG+15% on it instead of a bonus a la relic WS. Speaking of which, two questions. Are there any plans to incorporate mythic OA2-3 (unique in that it can proc once on WS) and split relic/emp ODD since empyrean ODD can proc more than once per round? Barring H2H anyway.

Fixed.


Fixed.


Leaving as is until I can see the test data.


Fixed (for all jobs that use it)


Already updated, just hadn't uploaded a new version yet.


Added Store TP. Made separate versions for crit dmg vs crit rate. And as noted, fixed haste.


Fixed.


Missed that one when I was updating that bit of coding. Fixed.


I've been gradually transitioning the calculations for hits-per-round to properly accomodate OA2-3/OA2-4/etc type weapons, however there's still a lot of underlying work to make the Mythic work properly. I have no easy means of adding an OAx proc to weaponskills. By more than once per round, do you mean an OAx can proc off of a DA or similar? That would also be aggravatingly difficult to incorporate.




Fixes will be in the process of being uploaded, but take a while, so it may be later tonight before they're up.

Easier if people just let me know what's missing, I think (and provide stats if it's augmented stuff). Also, updated the Innin crit rate average.

Fair enough, was just offering in case it was more convenient for you.

Sorry, I wasn't clear. Empyrean ODD (barring H2H?) can proc on any and all hits executed with that weapon, but from what I can tell your spreadsheet only allows it to proc once per round per relic proc mechanics.

Not sure I understand here, are you talking about Haidate? I'm not aware of any way to augment them with crit rate.

EDIT: missing items:
Moonshade Earring
Shura Kabuto aug/+1 aug (wsdmg+2/3%, possibly dex/attack/conserve TP)
Ninja Chainmail +1 (minor, just 5 DEX)
Athos's Gloves
Mars's Ring
Athos's Boots

If I see any others I'll let you know. Additionally, might be worth adding Store TP to augmented Shura Haidate/+1 as it's one of the common augments.

Bad info on wiki, then? It lists both crit rate and crit damage.

BGwiki doesn't have critrate listed and I've never seen a critrate augment on Haidate, whether in a screenshot or in my own synergy attempts for myself and others. Nothing I've seen indicates it's a possible random pool augment either. Probably just an erroneous report that made its way onto the wiki.

For the Rdm spreadsheet, is Requiescat's ftp carried over for additional hits?

On the War sheet, is Resolution's attack penalty being applied?

Nin: Got rid of bogus Byakko's
Rdm/Pld: Fixed Req's fTP carry-over
War: Missing att penalty fixed

All: Misc gear additions; new target mob (Dynamis DC) based on actual Dynamis 'Nightmare' mob stats. (very similar to Fodder, so may be getting rid of Fodder eventually, or re-purpose it)

What I don't understand is how to use the spread sheets in the first place> I downloaded the thing to my google drive, but i see no way to input information, I may be a little slow, but is there an instruction manual somewhere? Or do I have to have some kind of accounting background to use these? Any help would be appreciated

Can just open it with excel you know.

I've had the same problem with OpenOffice.
If i use Excel at work though it seems to fix the problem.

If you use OpenOffice/LibreOffice, download the .xls versions from the "XLS files for Calc" subdirectory. OO/LO don't deal well with the .xlsx files Excel saves, but Google Docs no longer handles the .xls files, so the .xlsx versions are now the default.

I must be doing something wrong, I added my Lekboza (great axe) under great axes in the gear list on the war spread sheet, and saved it, but when I go to the gear page it doesn't show up in the drop down menu for great axes, and I'm trying to see how it compares to Minos.

I believe it was stated at some point that if you add in gear at the beginning or end of a list it won't work. If you insert it in the middle however it should be fine(or overwrite something that is already there if you want). Not sure if that's your problem.

Ok I'll try that, thanks