There is a problem when people start with a sub-optimal (from the spreadsheet view) gemming, because during the gear planning process it has to re-gem when it equips a new item..
I have the opposite problem. My gemming is more optimal than the gemmer can do, so I lose 10 or so DPS if I hit regem. I guess this would decrease the reported value of all the gear I don't have currently equipped on the Gear Planner.
Out of curiousity, why does it regem for socket bonuses when that leads to lower DPS?
I have the opposite problem. My gemming is more optimal than the gemmer can do, so I lose 10 or so DPS if I hit regem. I guess this would decrease the reported value of all the gear I don't have currently equipped on the Gear Planner.
Out of curiousity, why does it regem for socket bonuses when that leads to lower DPS?
The gemmer is making a mistake with the socket bonus on your chest. It's putting a +hit gem in there, because it's a blue socket with a +hit bonus. That makes sense, but the amount needed for your to hit-cap is so small the bonus is enough to cover it. So it should put the enchanted tears into that socket, instead of a vivid forest emerald.
A few edge cases like these have popped up which I'll fix soon.
The gemmer is making a mistake with the socket bonus on your chest. It's putting a +hit gem in there, because it's a blue socket with a +hit bonus. That makes sense, but the amount needed for your to hit-cap is so small the bonus is enough to cover it. So it should put the enchanted tears into that socket, instead of a vivid forest emerald.
A few edge cases like these have popped up which I'll fix soon.
On the 89 version, I would gain 4 dps if I'd upgrade a 16 agi gem to 16arp. Now I am losing 4 dps by doing the same. Same talents/spec/gear, etc. I'm not sure what is causing this, I've looked at everything that be be doing so. Is arp itemized differently in this version 91?
What I dont understand is why my Valorous Scourgestalker equipment has a higher DPS than the Conqueror's Version. The Conq is a bigger version of the same set.
Small re-upload, fixing some reported issues.
- The gemming issue mentioned above
- An issue with trinkets (Death's Choice/Verdict) breaking the gear planner
@The poster above:
I have never seen the conqueror set be lower than the valorous set myself. Could you upload your sheet somewhere?
Even though I have both 'Naxxramas' and '10-man' selected on the gear planner, Naxx10 items are not showing up in the results. I made a pretty narrow selection and some slots have less than 10 items listed, so even if the Naxx10 items aren't very good they should still be in the list, be it at the bottom. UD10 and Naxx25 items are showing up in the lists so that would rule out wrong selections. And yes, I did click recalculate DPS for all slots after I made my selection.
On closer inspection, two Naxx10 items are listed: the Cloak of Mastery, which I am wearing and the Nerubian Conqueror.
Even though I have both 'Naxxramas' and '10-man' selected on the gear planner, Naxx10 items are not showing up in the results. I made a pretty narrow selection and some slots have less than 10 items listed, so even if the Naxx10 items aren't very good they should still be in the list, be it at the bottom. UD10 and Naxx25 items are showing up in the lists so that would rule out wrong selections. And yes, I did click recalculate DPS for all slots after I made my selection.
On closer inspection, two Naxx10 items are listed: the Cloak of Mastery, which I am wearing and the Nerubian Conqueror.
Are you adjusting the iLevel cutoff properly? It's on the right-hand top of the tab.
EDIT:
Fixed the link to the pre-PTR version, I'd cleaned up my upload space accidentally removing it.
I think the Kill Command calculations are broken in v91. If you spec into Catlike Reflexes, your dps goes down, which doesn't make sense (as in the spreadsheet tells me I'll have more dps even if I don't spend the points on anything). When I check the "Pet Calculations" tab, under KC both the "total dps of specials" and "average damage per special" are listed at 0.00. It seems that KC isn't adding any damage, but it is costing mana, so dps goes down if you lower the CD and use it more often. "Use Kill Command" is enabled on the Settings, btw.
Hello everyone. I'm a little puzzled by something the spread sheet is telling me and want to get a little understanding.
Firstly its telling me pendant of the dragonsworn is better dps than my broach of wailing night.
Also it says Enovy of Mortality is better dps than my Siren's Cry
And lastly when I put my aged winter cloak in the gear tab it says the Shawl of the shattered giant is better dps. But when I put that in the gear slot it says the aged winter cloak is better?
And anyone point me into the direct of what I'm doing wrong?
Please disregard the melee weapons show on the armory. I raid with Spire of Withering Dreams
I think the Kill Command calculations are broken in v91. If you spec into Catlike Reflexes, your dps goes down, which doesn't make sense (as in the spreadsheet tells me I'll have more dps even if I don't spend the points on anything). When I check the "Pet Calculations" tab, under KC both the "total dps of specials" and "average damage per special" are listed at 0.00. It seems that KC isn't adding any damage, but it is costing mana, so dps goes down if you lower the CD and use it more often. "Use Kill Command" is enabled on the Settings, btw.
Check that you have the appropriate pet abilities enabled on the pet ability queue. If you don't have any pet specials turned on that do damage then Kill Command has no effect besides the use of your mana. If your Time to OOM is less than the fight length, using mana for nothing = increasing AotV uptime = lowering your overall dps.
I noticed the latest spreadsheet kept regemming for agility. I wanted to change the red gem of choice to Arp as I run an Arp based MM build myself but found the sheet to be locked and as a result, I was unable to change my gem preferences.
Below is a macro you can use to unlock the spreadsheet in order to make said changes. If there is a password posted somewhere, I apologize.
Sub PasswordBreaker()
Dim i As Integer, j As Integer, k As Integer
Dim l As Integer, m As Integer, n As Integer
Dim i1 As Integer, i2 As Integer, i3 As Integer
Dim i4 As Integer, i5 As Integer, i6 As Integer
On Error Resume Next
For i = 65 To 66: For j = 65 To 66: For k = 65 To 66
For l = 65 To 66: For m = 65 To 66: For i1 = 65 To 66
For i2 = 65 To 66: For i3 = 65 To 66: For i4 = 65 To 66
For i5 = 65 To 66: For i6 = 65 To 66: For n = 32 To 126
ActiveSheet.Unprotect Chr(i) & Chr(j) & Chr(k) & _
Chr(l) & Chr(m) & Chr(i1) & Chr(i2) & Chr(i3) & _
Chr(i4) & Chr(i5) & Chr(i6) & Chr(n)
If ActiveSheet.ProtectContents = False Then
MsgBox "One usable password is " & Chr(i) & Chr(j) & _
Chr(k) & Chr(l) & Chr(m) & Chr(i1) & Chr(i2) & _
Chr(i3) & Chr(i4) & Chr(i5) & Chr(i6) & Chr(n)
ActiveWorkbook.Sheets(1).Select
Range("a1").FormulaR1C1 = Chr(i) & Chr(j) & _
Chr(k) & Chr(l) & Chr(m) & Chr(i1) & Chr(i2) & _
Chr(i3) & Chr(i4) & Chr(i5) & Chr(i6) & Chr(n)
Exit Sub
End If
Next: Next: Next:
Next: Next: Next
Next: Next: Next:
Next: Next: Next
End Sub
I'm having trouble with the optimizer. Using my same spec and settings (including the exact same enchants) I lose 50 dps when I "optimize" my gear. It seems that it might not be taking the t7.5 set bonus into account, because it always breaks my 2-piece. I'm also losing 10 dps, as others have posted, when I regem.
I have a quick question, just want to clarify I'm doing this right. Once I've plugged in all my corresponding information into the spread sheet and hit the "Calcattributes" button do I then go to the gear planner and hit "Recalculate DPS" in order for it to show me my item upgrades? It seems I get different items at the top every time I do things a little different.
For the PTR version of the spreadsheet, using the sample 7/57/7 MM build, I can move the DPS up to 9289 from 9278 by simply switching aimed shot's priority above arcane shot's priority on the shot rotation tab. This agrees with what quite a few MM are actually doing for their shot priorities as well.
Btw, great work on the spreadsheet Shandara - I've used this for months and love it.
So I've been playing with current version of the sheet and still having some problems. The sheet is still saying pendant of the dragonsworn is a dps upgrade over broach of wailing night. So when I set my gear to equip my pendant and re-run calc attributes and recalc dps the broach shows as a dps upgrade. I'm a little confused. Same happens with a few other pieces. Can anyone offer any help? Anyone else getting the same thing?
07/23/09, 7:58 PM
Similar Threads
