DPS Spreadsheets

[ccl]

Would it be easy to change pdif cap to 3 and fstr formula to fstr2 to an existing spreadsheet ? I wasn't able to find where I could change that, and I wanna be lazy when comparing namas gear.

[Motenten]

Yes, just change the cRatio and fStr values on the Data page. Should be around lines 70-80, depending on which spreadsheet you're using.

[ccl]

ok I see that now, thx.

[Byrthnoth]

Increasing ratio's cap to 3.0 isn't going to change the Melee pDIF equations into Ranged pDIF. You'd need to do these things:
1) Replace the Melee pDIF equations with Ranged pDIF equations.
2) Increase the Ratio cap to 3.0
3) Decrease level correction from 0.05/Level to 0.025/Level
4) Change fSTR to fSTR2
5) Change the fSTR cap from Weapon Rank + 8 to (Weapon Rank + 8)*2

[ccl]

Increasing ratio's cap to 3.0 isn't going to change the Melee pDIF equations into Ranged pDIF. You'd need to do these things:
1) Replace the Melee pDIF equations with Ranged pDIF equations.
2) Increase the Ratio cap to 3.0
3) Decrease level correction from 0.05/Level to 0.025/Level
4) Change fSTR to fSTR2
5) Change the fSTR cap from Weapon Rank + 8 to (Weapon Rank + 8)*2

1) I planned to manually estimate ratt at 1st and just add/remove attack under set, cause I don't know much more than doing that.
3) I totally forgot to do that, gotta find where it is now

4/5) I added a gkt with Yoichi dmg and tried to make it somewhat work, but idk how to make it add arrow dmg w/o it considering the ammo in fstr and wpn rank but considering it for dmg. (is that possible at all in the current form of the sam one ?)

I also just add -da on set to ignore it.

[Bikpik]

I keep getting this error when trying to save the Drk spreadsheet, that's without making any changes, just right after download. I'm using excel 2010, any suggestions?

[theshun]

NIN sheets: Majimun OAT doesn't show up correctly, I think. It just needs the 40% and 100% added in cells X39 and Y39, respectively, making it match the Enchu +1-+3 OAT cells.

[dasva]

Theres no att bonus on ruinator in there.

[Motenten]

I keep getting this error when trying to save the Drk spreadsheet, that's without making any changes, just right after download. I'm using excel 2010, any suggestions?

An issue for Excel 2007+. Fixed names. New version uploaded.

NIN sheets: Majimun OAT doesn't show up correctly, I think. It just needs the 40% and 100% added in cells X39 and Y39, respectively, making it match the Enchu +1-+3 OAT cells.

Majimun fixed.

Theres no att bonus on ruinator in there.

Please specify details. BGWiki has no attack bonus for Ruinator, and neither does the spreadsheet, so I'm not even sure which end you're referring to as an error, or if it's merely a statement of fact.

[dasva]

Please specify details. BGWiki has no attack bonus for Ruinator, and neither does the spreadsheet, so I'm not even sure which end you're referring to as an error, or if it's merely a statement of fact.

Bg wiki says "Attack Modifier: 1.35 (1.375?)"

Also noticed looking thru gear lists on some jobs and Kclub is missing.

[Motenten]

KClub is missing for most jobs since I don't have handling of club skill on them.

Missed the attack modifier when checking Ruinator before. Will add that as +35%.

[dasva]

Ah yeah was just kinda curious how offhanding it might be with some jobs like days of old now that 1hd getting a boost. That and just how strong bst has gotten. But yeah suppose that would be a decent bit more work since different weapon type and all

[Bikpik]

An issue for Excel 2007+. Fixed names. New version uploaded.



Majimun fixed.



Please specify details. BGWiki has no attack bonus for Ruinator, and neither does the spreadsheet, so I'm not even sure which end you're referring to as an error, or if it's merely a statement of fact.

Much appreciated

[Motenten]

The long-awaited automatic set bonus handling has been added to all spreadsheets (except rdm and whm, for now edit: just remembered Nares gives stat bonuses, so adding those to rdm and whm).

Sets that get bonuses applied are listed on the Other Lists page. That block is the only place that needs to be updated in order to get new sets added (ie: no changes are needed on the Gear page). The same set can be listed multiple times (such as for Thaumas stat bonuses), and the same bonus can be listed multiple times (such as NQ and HQ Salvage gear). It can handle any commonly-named set items, for any quantity from 1 to 5 pieces. It's not limited to visible armor, so you could add the weapon/earring sets, earring/earring sets, the waist/neck/back sets, or whatever. However they do need to be given the same names -- for example, you would need Altdorf+Wilhelm as a single item, not Altdorf and Wilhelm separately (though as a set you now get the 8 agi from having both equipped, but not 4 agi for each one).

I found and fixed a couple naming issues that would block it from working (eg: Denali Bonnet instead of just Denali); let me know if you come across other such issues.

Let me know of any missing sets that should be included. I just put in a few basic common ones to fill things in.

[Byrthnoth]

Did I forget anything obvious when converting the BST sheet for Axe/Axe WAR?
http://www.bluegartr.com/threads/112...=1#post5644719

[Jem]

Did I forget anything obvious when converting the BST sheet for Axe/Axe WAR?
http://www.bluegartr.com/threads/112...=1#post5644719

Possibly a silly question but did it auto-disable Berserk because your subjob wasn't WAR and because you were on the BST spreadsheet it didn't factor in your main job?

You said you were attack capped so it shouldn't be an issue but I'm stumped otherwise.

[Byrthnoth]

No, but I didn't use Berserk because it didn't matter.

[dasva]

Well if we are assuming capped att at least on ruinator there are a few swaps you could do.

[Motenten]

Did I forget anything obvious when converting the BST sheet for Axe/Axe WAR?
http://www.bluegartr.com/threads/112...=1#post5644719

Went and redid bst > DW war myself (and will put up the copy on my docs list, though it's still missing stuff). Only detail you didn't mention that could affect things is all the killer effects, and an increase of cRatio to 2.25 (assuming this is part of that discussion). Otherwise, didn't see anything significant missed.

No idea what all you were doing for the comparison, but I used the gear you listed vs Pil, with buffs of: Haste, 2x March, Boost-str, Chaos Roll, Berserk, Aggressor; and compared with 99 Ukko war with whatever gear was in the spreadsheet. DW War: 435 DPS (3260 WS); Ukko War: 472 DPS (2512 WS). Ukko drops to 346 without Hasso; DW only increases to 453 with Haste Samba. If I drop Chaos Roll (since a large chunk of DW's att was wasted on WS), it's 410 for DW, 435 for Ukko.

[dasva]

Did you gear change with haste samba? With capped magical haste and the gear setup he has he is just barely under the delay cap which is probably why such a small gain from it. Though doing the math he could take out all the dw gear and go down to 20% gear haste and still cap total delay if he had haste samba.

Also I'm highly curious what a kclub is as useful now with a good axe ws as it was back at 75 when it just had rampage