Originally Posted by Cerula
chiyeuk:
-Ill look into the gem bonuses thing, probably just an oversight. Should be fixed in the next release.
-If you can re-create the dps calculation error you were having please let me know (confirm that it's now working?)
-Ill look at the % hit as well
|
When I said "the following [...] works now" I meant the % hit (my third point), not the DPS calculation on upgrades (my second point), just wanted to clarify myself so you don't spend lots of time figuring the % hit problem.
Regarding the DPS calculation error:
Sorry, I don't know the behind-the-scenes of this spreadsheet well enough. I don't know what other information I can provide you apart from the numbers I am seeing. The gear I ran the spreadsheet with is the gear shown on my Armory page (except switch out non-heroic Ring of Rapid Ascent with the rings mentioned below) and the spec is my primary affliction one.
The Items worksheet shows:
[Ring of Rapid Ascent] (Heroic) = 365.6 DPS
[Memory of Malygos] (Heroic) = 358.2 DPS
The difference is +7.4 DPS.
The Gear_Buffs worksheet shows:
Equipping
[Ring of Rapid Ascent] (Heroic) with
[Purified Dreadstone] = 9470 DPS
Equipping
[Memory of Malygos] (Heroic) with
[Reckless Ametrine] = 9487 DPS
The difference is -17 DPS.
(In my previous post, I mentioned a difference of -6 DPS, that one was with BIS gear. This time I tried with my current gear to see if the result is negative again).
I don't think the DPS calculation has to do with recognizing gems as I suggested, I just tried changing the colours of the gems and the DPS of the items changed. Though it could be the DPS value of gems. When I switch a blue socket to a yellow socket, the DPS increase is less than the numbers on the Gems sheet says.
The Gems worksheet shows:
[Veiled Ametrine] = 37.97 DPS
[Purified Dreadstone] = 29.77 DPS
The difference is +8.2 DPS.
The Items worksheet shows:
[Ring of Rapid Ascent] (Heroic) with
[Purified Dreadstone]= 365.6 DPS
[Ring of Rapid Ascent] (Heroic) with
[Reckless Ametrine] = 368.7 DPS
The difference by manually changing the SOCKET from a blue socket to a yellow socket is +3.1 DPS.
Is it suppose to be that low? But again, I don't know the math functions and relationships in the spreadsheet.. so this is completely a guess and it could also be that I don't understand how the Items sheet and Gear sheet work together.