DPS Spreadsheets

[shepardG]

Are you capping acc. With carbonara and no hunters roll?

meh, i guess i'm thinking about NM's in delve, if you have those rolls/food up would you be wiffing alot on 5NM's + Boss

[ccl]

Well for boss run we have 8song SVing and they die before SV wear off.

For NMs between 2 mad/geo eva down, it's not that hard to cap, it all depends if you can trust your buffer/debuff or not.

[Motenten]

War updated with geo stuff. Also did a full subjob split, so you can directly compare things like DW /nin vs GA /sam.

[Fival]

Issue with the updated War Spreadsheet;

TP Set 1, when you go to change the main hand axe, the sub weapon category, or the sub weapon the only option in the drop down is "#REF!". Then moving over to TP Set 2, when you try and change grips, the only options are daggers in the drop down menu, changing the sub category still keeps the only options as daggers.

Edit: Also wondering if its possible to add support job abilities for DRK sub on the WAR sheet, just for curiosity's sake, since DRK is already a listed sub on the sheet but doesn't have any of its abilities included.
Edit2: Just realized the numbers for the LR JA haste are not listed anywhere, vary by level of the DRK job, and are probably unknown and not worth adding, so ignore that.

[Fival]

Played with the latest DRG sheet as well, seems manually adding any mobs or gear in the lists creates problems too, only shows "#REF!" in place of all the result outputs.

[Yugl]

Note for users" Manhibozo (however the fuck that's spelled) is missing 4% haste for R15.

[Motenten]

For which spreadsheet?

[Motenten]

Issue with the updated War Spreadsheet;

TP Set 1, when you go to change the main hand axe, the sub weapon category, or the sub weapon the only option in the drop down is "#REF!". Then moving over to TP Set 2, when you try and change grips, the only options are daggers in the drop down menu, changing the sub category still keeps the only options as daggers.

I'm not sure I understand what you're talking about, as I can't get it to do anything remotely like what you describe.

Edit: Also wondering if its possible to add support job abilities for DRK sub on the WAR sheet, just for curiosity's sake, since DRK is already a listed sub on the sheet but doesn't have any of its abilities included.
Edit2: Just realized the numbers for the LR JA haste are not listed anywhere, vary by level of the DRK job, and are probably unknown and not worth adding, so ignore that.

I'll work on adding those in.

[Motenten]

Played with the latest DRG sheet as well, seems manually adding any mobs or gear in the lists creates problems too, only shows "#REF!" in place of all the result outputs.

Also can't replicate this problem. It works perfectly fine on mine.

[Yugl]

For which spreadsheet?

MNK. My bad.

[Motenten]

Ah, and you meant body, too. Ok, fixed.

[Fival]

Sorry, i don't know how to quite put it into words, i'll use some crude screenshots.
WAR when i open it:

Spoiler: show

Then DRG when i manually add peices of armor to the gear lists, without even equipping that armor, the results on the setup page get all messed up.

Spoiler: show

I had someone download the war sheet and they said they encountered the same thing.

[Fival]

Also just realized when comparing sets, if armor in the set next to it doesn't match, theirs no longer a color code. Someone brought it to my attention there was a post earlier in this thread that i missed about file conversions recently, so it may have something to do with that and OpenOffice? If thats the case my bad i guess.

[Motenten]

OK, on the drg sheet, I'm not seeing that while testing in LibreOffice. If I add a new piece of gear, everything behaves normally.

On the issue in the war sheet, I *do* see that. The problem is in the data validation config. The offhand dropdown (Dagger/Axe/Grip/etc) sets its validation list based on the value of A3, however when I look at it in Calc, it just shows a #Ref!3 error. Likewise, B4 defines its validation list as A4&"List". In that case, A4 becomes a #Ref!4 error. That is, it replaces the 'A' part of the cell reference with brokenness. I have absolutely no idea why.

Now, if I correct the bug in Calc, setting the validation list for the offhand A4 cell to reference A3 properly and save that back as a new .xlsx file, attempting to open it in Excel gives me an "unreadable content" error (essentially, a corrupt file).

Essentially, Calc is completely broken when dealing with validation info in .xlsx files. I'm not really surprised, but it is annoying to find out after making the conversion.

After making the corrections, I can save the file as .ods and Calc can reopen it fine, and things work normally. However attempting to open .ods files in Excel 2007 isn't possible (sees it as a corrupt file, etc). If I want to use .ods, I'll have to upgrade to Office 2010 or 2013. However, even if doing so, .ods files can't be used with Google Sheets.

Overall, it seems I can have a solution that only works in 2 out of the 3 options people have for accessing the spreadsheets:

1) .xls - Works in Excel and Calc, but not on Google
2) .ods - Works in Excel 2010+ and Calc, but not on Google
3) .xlsx - Works in Excel and (mostly) on Google, but not in Calc

The only other options I have are:
1) Write a full standalone program so that it's not dependent on any of that, but that's a major pain.
2) Save a copy of each spreadsheet as 2003 .xls that can be downloaded for use with Calc, as Calc seems to handle that without any issue. I'll probably go with this.

[Motenten]

Created said directory of .xls files, currently uploading. Also, converting them back to 2003 brought to light a number of minor bugs in the main files, so those have been fixed and are being uploaded as well.

[Fival]

Thanks, i downloaded the DRG.xls and the problem i was encountering on the other DRG sheet when adding to lists has gone away as well, whatever it was.

[lolwut]

On delve fodder no tenryu+1.


Ionis: 5save tp

Miser's: 20(can save random deal/snake eyes to lucky or XI it, there are prolly build allowing 17 save tp too but can't remember)
sam: 30
chaos: 20%
fighters: 16%

Food: Carbonara.

MarchX2/MinX2/Boost str(500)/Hasso

Tp:

Tsuru/duplus X Hagneia
Yao / Ganesha / 7DA/2stp ears
Usu+1/karihands/Kayre/rajas
Atheling/goading/unkai+2/usu feet

WS:

Yao helm/gorget/moonshade/brutal
Phorcys/Phorcys/PyrosoulX2
Atheling/belt/miki rank15/Whirlpool feet

Set dps: 1359

I can't have anything beat that w/o tenryu tekko+2.

Removing Misers:

Usu body+brego = 1249

Porthos+phorcys = 1247

I know I've said this before, but I really think you significantly overestimate the average roll you'll receive in a four roll cycle.

If I had to guess, I'd say the Sam Roll is the only one where it would be consistently accurate, and Chaos when the Drk and the Sam are in the same party. Otherwise you'd only have 20+% Chaos on lucky/11, or when Tricorne decides to proc.

Saving Random Deal/Snake eyes only for Miser's means getting stuck with unlucky's on your other rolls, and it's still very doubtful it would average higher than 13 - 15. Even if we brought War along, you'd only hit a 16% fighter's maybe 12% of the time. Again, half that if you rely on Tricorne procs.

So to get even close to your numbers, you'd require a WAR/SAM/DRK party and lose Mantra or give up your in party WHM, and still wouldn't hit them the majority of the time.

[lolwut]

I also have the following build coming out ahead of both the Usu+1 and Porthos builds on Fodder/Boss using the buffs in Ccl's post:

Slot Gear
Weapon Tsurumaru
Grip Duplus
Ammo Black Tathlum
Head Yaoyotl
Neck Ganesha
Earring Bladeborn
Earring Steelflash
Body Unkai +2
Hands Karieyh
Ring Rajas
Ring oneiros
Back Atheling
Waist Dynamic +1
Legs Unkai +2
Feet Mikinaak
Set Bonus
Custom

Total


WS Set 1
Slot Gear
Weapon Tsurumaru
Grip Duplus
Ammo Thew Bomblet
Head Yaoyotl
Neck Gorget
Earring Brutal
Earring Moonshade AttTP
Body Phorcys
Hands Phorcys
Ring Pyrosoul
Ring Pyrosoul
Back Atheling
Waist Ele.Belt
Legs Mikinaak
Feet Whirlpool

Anyone mind double checking it for me in case I changed something else and I'm just missing it?

[ccl]

lol mp merit
I have your set far behind the one I posted with the same buff (50-60dps on fodder, didn't bother to check boss).
I know about the roll things, just too lazy to change them. We also should make a drk war sam pt at some point, shit is boring when it's stunned to death 99 fear tactics of stun locking mob is so boring :/ make SE fix it!

[lolwut]

Re downloaded the spreadsheet to do it again at home, got completely different results than what I had earlier. Going to have to compare the two on monday and see what I did to the old one to get it so far off.