WotLK DPS spreadsheet - Page 290

Whitefyst · 08/30/10, 12:58 PM

Originally Posted by wilegenuis

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.).

KergeKacsa · 09/19/10, 12:27 PM

I found an interesting thing:
As I know ArP IS modify Auto Shot's damage.

But I don't find a line where it modifies it's damage in the spreadsheet.
I tested, and true, 1000 or 1400 ArP, the Auto Shot's damage stays the same.

Is this a bug?

baklava · 09/29/10, 10:26 AM

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?

Sup Darkies · 09/29/10, 1:38 PM

@Whitefyst

Cat's swiftness is the best boot enchant, for anything other than a Patchwerk fight.

Mingan · 10/06/10, 7:50 PM

Originally Posted by baklava

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.

mopsie2002 · 10/07/10, 8:47 PM

Hopefully you're working on a new spreadsheet to incorporate the upcoming lack or armor penetration? I rely on this spreadsheet far too much....

Luckyshot · 10/11/10, 7:41 PM

Originally Posted by mopsie2002

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.

Shandara · 10/12/10, 5:52 AM

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.

Hirgux · 10/12/10, 5:45 PM

/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?

torii · 10/17/10, 2:46 PM

Originally Posted by Shandara

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?

SourceForge.net: Download and Develop Open Source Software for Free
GettingStarted - support - A quick guide to getting started with project hosting on Google Code. - Project Hosting on Google Code

Cheers,
Toriigate of Saurfang

MaikuMori · 10/17/10, 4:08 PM

Originally Posted by torii

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.

Shandara · 10/18/10, 4:52 AM

Originally Posted by MaikuMori

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.

Chasim · 10/20/10, 7:17 PM

Shandara - Will the revised spreadsheet handle Reforging in some way?

baklava · 10/21/10, 2:37 AM

Originally Posted by Chasim

Shandara - Will the revised spreadsheet handle Reforging in some way?

I believe it is easy task to do, So most probably there will be! The main problem will be the stats, rotation and theoretical dps values.

Cactuscat · 10/22/10, 8:30 AM

Originally Posted by Nooska

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.