Without knowing exactly what settings you have in your spreadsheet, these may or may not be spreadsheet problems and may be user "problems" instead.
For the first problem, I ran it my copy of the spreadsheet and saw a 60 DPS increase with moving KS up to right after ES. I do see a a small decrease of 6 DPS from that when moving KS to above ES for a 54 DPS gain from the original priority. The reason for the smaller increase is a swap of a Aimed Shot for a Steady Shot.
Concerning the Optimizer, it only optimizes per the constraints you provide it. Most often when someone has a problem with the optimizer, it is due to a bad setting. If you do not have the best gem options chosen for your spec, it can cause a decrease to optimize using them. If you are concerned that your meta gem requirements are not being satisified, make sure that the Setting for Gem-for-meta-requirements has a Nightmare's Tear.
Using the default settings in the spreadsheet (I redownloaded a fresh version to check), I get a 78 DPS upgrade by regemming you current gems. Ignoring the socket bonus on Logsplitters is about a 1.5 DPS upgrade. And losing the socket bonus on your legs by replacing both the blue and yellow sockets with agility gems is a 7 DPS gain for SV.
Agreed. You are getting exactly what I get if I simply regem using the default gem settings. Please RESET in gear sheet, then load Optimizer giving it options like all T9 gear, all emblem gear and the gear I am wearing. For me on default settings it will choose the gear I am wearing, gem it ok, but the DPS will be way off. The dps is over 400dps less then if you manually just choose the same gems the optimizer does.
I dont know what setting I could have changed. I ignore that page since its best not to goof with it unless you know it well...and I do not.
Can you give me an example of what I might have changed, or what default setting could cause this error?
Is there a way to force the spreadsheet to focus on MM hunters that want to go the ArPen route? So that the optimizer only chooses items that will get you to 1400 (whilst including elixirs and rhino food buffs)?
Agreed. You are getting exactly what I get if I simply regem using the default gem settings. Please RESET in gear sheet, then load Optimizer giving it options like all T9 gear, all emblem gear and the gear I am wearing. For me on default settings it will choose the gear I am wearing, gem it ok, but the DPS will be way off. The dps is over 400dps less then if you manually just choose the same gems the optimizer does.
I dont know what setting I could have changed. I ignore that page since its best not to goof with it unless you know it well...and I do not.
Can you give me an example of what I might have changed, or what default setting could cause this error?
Ah, I have never used the Reset Gear button before. So I decided to do some quick experiments.
A couple things to note first that can cause problems:
1) If you change any gem setting, it is recommended to change them all even if you are choosing the default. This was a problem that was previously reported.
2) On the Optimizer tab make sure all of the enchants are correct for you and that your 2H weapon enchant is in the 2H Enchant slot. If you put it into the normal Enchant slot, it will disappear when you optimize since you are telling the optimizer not to use a 2H enchant.
I loaded your current gear/talents into the spreadsheet. On the Settings tab, I changed all gem settings to Delicates except for Red/Yellow/Full +hit gems, meta gem, and meta gem requirement gems for which I set the slots to the same as the default. I did Recalculate DPS on the Gear Planner. Your current DPS was 10662.73 with the Gear Planner stating you could gain 3.34 DPS from a regem.
In the optimizer I set all your current gear and enchants, then added additional inferior items so that it would still select your current gear.
Optimize Run 1: Did not press Reset Gear button and had the Start with Current Equipped Gear checked on the Optiomizer tab. The result was 10666.07, which was exactly as expected from what the Gear Planner stated would be the benefit with a regem.
Optimize Run 2: Did not press Reset Gear button and had the Start with Current Equipped Gear unchecked on the Optiomizer tab. The result was originally 10592.07. I quickly realized that the problem was due to losing the 2H weapon enchant per 2) above. I added the enchant and the result was 10666.07 as expected. I reran again with the 2H enchant correct and got 10666.07 as expected.
Optimize Run 3: Pressed Reset Gear button and had the Start with Current Equipped Gear checked on the Optiomizer tab. The result was 9804.14. It lost all of the enchants. Even with adding the enchants back in, the DPS was only 10212.66.
Optimize Run 4: Pressed Reset Gear button and had the Start with Current Equipped Gear unchecked on the Optiomizer tab. The result was 10234.14.
I am not really sure why the results are incorrect with using the Reset Gear button first either way. Maybe as part of the optimization it Recalculates the attributes +1 information as if you are naked and then uses it throughout; however, the attributes +1 data on the Overview tab was unchanged. Does anyone have an idea? I do not currently have the time to dig through the code and figure it out.
Anyway, I would suggest not hitting the Reset Gear button before doing an Optimization.
It seems it's not recalculating the sheet at some intermediate/end step(s), resulting in the differing. You can try to hit F9 and/or recalculate the shot rotation test to see if it fixes the problem.
The sheet doesn't recalculate all the cells and re-do the shot rotation at every step in the process, since Excel is so inefficient that would take a lot of time.
The losing of the enchants is a bit strange though, I'll have a look at it. Mind, you the optimizer hasn't really been a function that was, err, tested much. It was a simple extension of the functionality I made for the gear planner.
Ah, after doing some more quick tests, I found what is causing the difference in Run 4 (and also affecting Run 3).
When the Reset Gear button is pressed, the Ammo choice is removed; however, the Gear Optimizer does not know what ammo is used and leaves the selection blanked. By manually selecting the Ammo after running the Optimizer, the DPS correctly went from the 10234.44 calculated to the expected 10666.07. Hence, the way to fix this is to add the Ammo selection to the Ranged area of the Gear Optimizer. I do not know though if you want to bother with the change now though since Ammo is going away in Cataclysm.
I believe that everything else is fine in this case since the Hunter Statistics and Gear Statistics remained unchanged as expected and since the result ended up as expected once the Ammo choice was made.
Concerning Run 3 and the enchants going away, here is some additional information. In Run 4, only a single iteration was necessary to come to the solution. In Run 3, it stopped after the 17th iteration. This got me thinking that it seems like a bad idea to clear all your gear and then tell the Optimizer to start with your currently equipped gear since the iterations are probably trying to make comparisons against with the character being naked. The Optimizer should still ideally work in this situation and add in the enchants, but it is a bad choice of settings to make, so I suggest avoiding the combination of using the Gear Optimizer with your gear cleared and the Start with currently equpped gear option selected.
Manually adding in the enchants and the Ammo in Run 3 after it completed does correctly provide the 10666.07 DPS expected. So the problem in that case does indeed only seem to be the missing enchants.
As per the hunter union site the best Feet enchant would be Superior Agility with +16 Agl, as I'm eng, I can also go with Nitro Boosts that deliver critical strike of 24 (+some speed boost that is not connected directly to DPS gain). On theory +16 agl is better than 24 crit, but as per the spreadsheet Nitro Boosts provide extra +9 DPS.
Is it because the spreadsheet count the speed boost as a factor for DPS or just calc that 24 crit > 16 ag for my stat?
As per the hunter union site the best Feet enchant would be Superior Agility with +16 Agl, as I'm eng, I can also go with Nitro Boosts that deliver critical strike of 24 (+some speed boost that is not connected directly to DPS gain). On theory +16 agl is better than 24 crit, but as per the spreadsheet Nitro Boosts provide extra +9 DPS.
Is it because the spreadsheet count the speed boost as a factor for DPS or just calc that 24 crit > 16 ag for my stat?
As MM, crit rating is highly valued, not only due to our high crit bonus but also do to PS procs and pet focus regen. That is part of the reason MMs usually choose Deadly gems in yellow sockets to get most socket bonuses.
For your char as he currently is, it shows:
Agi+1 1.978
Crit+1 1.687
24 * 1.687 = 40.488 > 31.648 = 16 * 1.978 by about the 9 DPS you see when making the change. Furthermore, using the speed boost from the boots at the right time can increase DPS uptime/survivability, resulting in higher DPS.
Is it possible that [Rowan's Rifle of Silver Bullets] and [Herkuml War Token] would be a bigger dps gain than [Njorndar Bone Bow] and [Whispering Fanged Skull]? Every web resource I found always points that both the Njorndar Bone Bow and the Whispering Fanged Skull are on a higher place in terms of dps gain. Rawr also points the same thing. Recently I used the spreadsheet for the first time in my hunter career and when I listed the items I have/have possibility to gain with adding Rowan's Rifle and War Token in the Optimize Gear section after the process both Rifle and Token showed me a dps increase over Bow and Skull for about 40 dps each. How's that possible?
Last edited by Fafiq : 08/28/10 at 5:59 AM.
Reason: Bug with Wowhead linking
@Fafiq
Yes, Rowans is a better weapon than the 251 ones. It is a tier above (ili264) with resultant higehr dps, and its a faster weapon meaning more procs of 2t10. The small loss that you experience on the non-normalized shots will - depending on gear - often be made up for by the higher dps and the more procs from faster speed. Ignore the stats, they are such an insignificant part of your dps. Herkuml is good on any fight where you shoot at least 1 shot every 10 seconds after getting it up (Rowan's helps with that too) since its a buff on you, but the spreadsheet can't really evaluate it when there are fights with 10 second (or longer) pauses, since it drops completely and needs to build up again. However the proc trinkets aren't fully utilized on these same fights too if unlucky , nothing prevents a proc from the last shot before a pause.
Based on the spreadsheet and Rawr, it seems that even now that my ArP is ~600, my DPS will increase if I replace my Agl gems with ArP gems (thanks again for the tip Whitefyst btw). Based on the reading I’ve done, the min level to gem ArP will be only around 800 ArP. Should I start gemming right now or wait for the “official” 800 ArP limit?
I wonder if the reason why it is recommended to start ArP gems only at 800 and not based on the spreadsheet math is the distance between theory and reality? I guess the spreadsheet cannot take into account the hunter’s movement and it assume that hunter does not move at all during the battle. Is that the reason for the distance between the level we should start ArP gemming?
Based on the spreadsheet and Rawr, it seems that even now that my ArP is ~600, my DPS will increase if I replace my Agl gems with ArP gems (thanks again for the tip Whitefyst btw). Based on the reading I’ve done, the min level to gem ArP will be only around 800 ArP. Should I start gemming right now or wait for the “official” 800 ArP limit?
I wonder if the reason why it is recommended to start ArP gems only at 800 and not based on the spreadsheet math is the distance between theory and reality? I guess the spreadsheet cannot take into account the hunter’s movement and it assume that hunter does not move at all during the battle. Is that the reason for the distance between the level we should start ArP gemming?
The 800 ArP for switching to ArP gems is really only a guideline since the choice is not totally on how much ArP you have but also on some of your other stats, particularly crit. ArP and crit have a huge synergy for MMs. When the 800 ArP guideline came out around the start of this year, it was really kind of the mid-point of a 700-900 ArP range where the transition to ArP gems occurred depending on your current crit rating. Now that time has passed and more higher level gear is available, hunters generally have higher crit percentages, which has lowered the ArP gemming transition point.
So the actual value at which to switch is on a case by case basis, mostly affected by your ArP on gear and crit percentage. Generally, when the tools tell you that the ArP gemming provides better DPS than the traditional gemming, it is time to think about regemming. Even then, it may be better to wait until the ArP gemming provides 20 or so DPS more to help account some for the relative DPS loss when not being able to shoot the ideal number of SSs (due to moving, stuns, having to use utility abilities, etc.).
The spreadsheet is unfortunately not working with Office 2010.
When I try to change something or load it says "could not load an object because it is not available on this machine" and at Virtual Basic Code screen, it says "Compile Error: Can't find project or library" while standing on "server" and "cell" variables.
Is there a way to fix this problem with Office 2010?
The spreadsheet is unfortunately not working with Office 2010.
When I try to change something or load it says "could not load an object because it is not available on this machine" and at Virtual Basic Code screen, it says "Compile Error: Can't find project or library" while standing on "server" and "cell" variables.
Is there a way to fix this problem with Office 2010?
Click OK through the errors and it should get you into a window where the code is being displayed...
Take the two lines you see below the one highlighted and comment out where you see ProgressBarFrame (put a single quote in front of both lines) so that it looks like this"
Sub progress(percent As Single)
If Worksheets("Settings").Range("UseProgressBar").value = "Yes" Then
'ProgressBarFrame.ProgressBar.value = percent
'ProgressBarFrame.percLabel.caption = Int(percent) & "%"
DoEvents
End If
'Application.StatusBar = Int(percent) & "%"
End Sub
Press F5 to let the program continue and it will choke on the next spot that references the Progress Bar.. comment it out as well by putting the single quote in front of line:
Function getprogress()
'getprogress = ProgressBarFrame.ProgressBar.value
End Function
Press F5 again and it then the program will run until completion. Big difference here of course is that since you commented out those lines for the progress bar.,.. the bar will not show nor update and you will be stuck with a window with a label in it.. but the program is still running.. there is just no visual indication that is.
I am sure that there is a better way to fix it... but it has been years since I have worked with VBA.
Hopefully you're working on a new spreadsheet to incorporate the upcoming lack or armor penetration? I rely on this spreadsheet far too much....
You realize its not just about armor penetration on gear. Our whole resource system and class mechanics will change tuesday. Changing gear itemization alone will not maintain accuracy of the spreadsheet. This is no small undertaking and hopefully Shandara plans to still maintain it.
I do plan to update the sheet. With 4.0.1 imminent and hopefully all the gear changes going onto the armoury I hope to find some time to update the sheet.
As said above, it will require reworking of the whole shot rotation logic, although the larger framework should be staying the same.
/cheer
I don't know how all item are formatted in you excel sheet, but maybe you can put the item/stat list on googledocs and we all can help you editing the new values?
I do plan to update the sheet. With 4.0.1 imminent and hopefully all the gear changes going onto the armoury I hope to find some time to update the sheet.
As said above, it will require reworking of the whole shot rotation logic, although the larger framework should be staying the same.
Greetings and many thanks to you Shandara,
As an avid user of this spreadsheet for quite some time I look forward to a 4.0.1 version. On the surface to me it seems like a relatively large undertaking -- the sheer volume of item, talent and resource changes is nontrivial.
That said, do you think it would be helpful to create a sourceforge or googlecode site for it so others might be able to help contribute/reduce the load with the core changes?
the sheer volume of item, talent and resource changes is nontrivial.
I believe the item changes are simply pulled in from a source such as wow armory or most likely wowhead.com. I don't think it's done by hand. Updating the logic and calculations is the real problem.
I believe the item changes are simply pulled in from a source such as wow armory or most likely wowhead.com. I don't think it's done by hand. Updating the logic and calculations is the real problem.
The items aren't the problem, no, merely a case of fixing my wowhead scraping routines and running them.
EDIT:
Finished importing updated items, working on stats now.
I do agree that making a spreadsheet for 4.0.1 is not a priority
But of course, a lot of the work that would go into a spreadsheet for 4.0.1 should be (relatively) easily transferable to a spreadsheet for full-blown Cata - even if the numbers are adjusted, the general algorithms should stay the same. So yes, while we don't need a spreadsheet for 4.0.1, the work isn't wasted. Anyway, any work Shandara puts in is greatly appreciated by all of us here, I'm sure.
Regarding the reforging question... How would the spreadsheet handle that? As of all the previous versions, I'm fairly certain (correct me if I'm wrong) that it was just getting raw item data from Wowhead.
08/14/10, 8:26 PM
Similar Threads
