Originally Posted by bellator
Haste does effect SoB in the sheet
Briefly, how item calc works. Lets say you've set up your gear and it's saying you have 1000dps. When you run Item calc, it will first look at your head gear. It goes through each helm item and works out the dps if you had each helm. It looks at Helm X and the dps drops to 990. It then looks at Helm Y and dps is 1010, so it lists Helm Y with 10 (dps increase next it it). It does that with all items. The enchants you set up will stay the same, but every socket of every item it compares is filled with +Str gems (to keep things even), as it's impossible to know exactly how you would socket it. Ideally it would socket each item based on the gemming combination which gives the highest dps, but the calculation time would be tooo big
The hit cap is 9% hit
|
Socketing everything to str would be fine comparing 2 items in a void, but the spreadsheet compares 2 different items using the rest of your gear as a base. This means anyone without 9% total hit using any combination of 15 of their 16 items will have at least 1 item comparison that overvalues +hit since you're no longer capped and hit is the biggest dps increase stat when you're not capped. When you have sockets you can stick +hit gems in that is probably not the best comparison.
I've reworked my copy of v30 to socket to 9% hit and then socket str if that's something you would be interested in incorporating in future versions bellator. It helps keep the spreadsheet from grossly overvaluing items with +hit on them for people who have to socket some +hit to cap (or could be better off socketing hit to cap). I think this is a lot better way to work the comparison for anyone who isn't already several percent beyond the hit cap because it brings down the value of straight +hit vs. sockets to something reasonable. It could on occasion screw you out of a tiny bit of dps where it would be better to gem str and live with 8.x% hit instead of gemming to 9.x but I consider that an acceptable tradeoff. Gemming for +hit is the right answer over staying uncapped the vast majority of the time.
The spreadsheet is currently unable to tell you the very best combination of items. It can find a combination of items for which there is no single item that results in a dps upgrade however, which makes for a fairly solid ending gearset. The one I found had all str gems socketed, even with the option to socket +hit, so I'm inclined to believe people at high (T6 farm) levels of gear have very little need for this enhancement, but it may find some combinations you wouldn't otherwise see I suppose.
One more tip for people, if you don't want to see a socket bonus on an item broken up, you can add the item again yourself and use the stats you would have socketed instead and simply not include any sockets (except meta if applicable).
-----------
If anyone is interested in using what I wrote:
Changes the function of "Socket Strength" to fill with Strength Gems like normal and then backfill hit gems into yellow, blue, and red sockets in that order as needed to reach 9% hit (or run out of sockets).
Please note I'm using 8 Str and 8 Hit gems. You can obviously just change the 8's to 10's to go back to using 10's if they are available to you.
1.) Name your +hit total cell (H17) to "Hit" (no quotes)
2.) In the macro editor go to module2 and replace from Public Sub Socket_Str() to the first End Sub with the following

Public Sub Socket_Str()
Dim PlusHit
Dim CurCell As Object
For Each CurCell In Range(Names("MyGems"))
If CurCell.Offset(0, -1).Value = "m" Then
CurCell.Value = "12 Agi & 3% Increased Crit Dmg"
ElseIf CurCell.Offset(0, -1).Value = "y" Then
CurCell.Value = "8 Str"
ElseIf CurCell.Offset(0, -1).Value = "b" Then
CurCell.Value = "8 Str"
ElseIf CurCell.Offset(0, -1).Value = "r" Then
CurCell.Value = "8 Str"
Else
CurCell.Value = "None"
End If
Next
'only bother to socket hit if the base gear doesn't have it
PlusHit = Range(Names("Hit")).Value
If PlusHit < 9 Then
'socket hit to yellows first
For Each CurCell In Range(Names("MyGems"))
If CurCell.Offset(0, -1).Value = "y" Then
PlusHit = Range(Names("Hit")).Value
If PlusHit < 9 Then
CurCell.Value = "8 Hit"
Else
Exit Sub
End If
End If
Next
'socket hit to blues next
For Each CurCell In Range(Names("MyGems"))
If CurCell.Offset(0, -1).Value = "b" Then
PlusHit = Range(Names("Hit")).Value
If PlusHit < 9 Then
CurCell.Value = "8 Hit"
Else
Exit Sub
End If
End If
Next
'socket hit to red last
For Each CurCell In Range(Names("MyGems"))
If CurCell.Offset(0, -1).Value = "r" Then
PlusHit = Range(Names("Hit")).Value
If PlusHit < 9 Then
CurCell.Value = "8 Hit"
Else
Exit Sub
End If
End If
Next
End If
End Sub