WotLK DPS spreadsheet - Page 286

Repaxan · 05/04/10, 6:39 PM

Originally Posted by Allara

Microsoft Office 2010 has been released (available to MSDN/TechNet at the moment). Using the RTM build, I receive the following errors when clicking Recalculate DPS (93i). This is the 64-bit build -- I'm not sure if they changed anything in the VBA system. I believe some 32-bit users of 2010 beta were mentioning this issue as well.

I'm also getting errors in 32-bit Office 2010. It won't even let me save the spreadsheet, a "Errors were detected while saving" dialog pops up.

edit: This only seems to happen in 32 or 64 bit Office 2010, on a 64 bit Windows install. Office 2010 on a 32-bit windows computer seems to work fine.

Shandara · 05/05/10, 4:11 AM

Originally Posted by mako

The spreadsheet version available for download right now has not been updated to 93j. (i.e. no distant land (H), nor are the update notes present).

I hope this was just a caching issue. I just downloaded it myself and it is the correct version.

Dch48 · 05/05/10, 8:09 PM

You can't get the new version by clicking on the link, at least not in IE8. You get the warning that IE has blocked the site from downloading files and when you click to allow the download, you just come back to the main forum page. I had to right click and choose save target as to get the file.

GwolfGarona · 05/12/10, 7:54 PM

Even with use progress bar set to no, the spreadsheet still bugs out unless the offending component is commented out. Small annoyance but I've gotten used to doing it.

Ketari · 05/12/10, 8:51 PM

Hi Shandara;

First, experimenting with the 2H wep enchant Scourgebane, it gives me an error on armoury import about the weapon enchant "+140 AP versus undead" not being supported.

Edit: Never mind the second problem, fixed

(Need to adjust the spreadsheet to ArP gems on the settings page)

GwolfGarona · 05/13/10, 2:56 AM

The first and last comments are all you need to do to fix the spreadsheet in Office 2010 beta x64 (likely x32 as well).

This screen will show automatically when you run the spreadsheet for the first time. Just pop a ' to comment. This is a Microsoft problem, not a Shandara problem, that will hopefully be fixed before the general public gets Office 2010.

Allara · 05/13/10, 3:38 PM

Originally Posted by GwolfGarona

This is a Microsoft problem, not a Shandara problem, that will hopefully be fixed before the general public gets Office 2010.

Office 2010 has already been released to RTM. It's not going to change. The issue needs to be fixed in the spreadsheet eventually.

Methyl · 05/13/10, 6:26 PM

Originally Posted by Allara

Office 2010 has already been released to RTM. It's not going to change. The issue needs to be fixed in the spreadsheet eventually.

I do not know if anyone has tried it in the new Office 2010 RTM,I am using 2010 Professional plus RTM, and everything but the progress bar used to work in the beta, though i just commented that out and it worked fine. Now every time I do anything on the spreadsheet it totally breaks and it throws me the

error Compile error: Can't find project or library

for any of the Visual Basic that it is trying to run for example when i try to load a profile it gives me that error and it displays this.

Function FindProfileSlot(name As String)
    Dim count As Integer
    
    count = 1
    
    For Each cell In Worksheets("Profiles").Range("SavedSetNames")
        If cell.value = name Then
            FindProfileSlot = count
            Exit Function
        End If
        count = count + 1
    Next

With the Function FindProfileSlot(name As String) part highlighted in yellow and cell highlighted in black.
I know how to set up the spreadsheet so it is not an issue with that, it was working with the 2010 Beta but it seems with the 2010 RTM it has just gotten even worse in terms of compatibility.

Keibler · 05/15/10, 7:19 PM

Originally Posted by Methyl

I do not know if anyone has tried it in the new Office 2010 RTM,I am using 2010 Professional plus RTM, and everything but the progress bar used to work in the beta, though i just commented that out and it worked fine. Now every time I do anything on the spreadsheet it totally breaks and it throws me the

error Compile error: Can't find project or library

for any of the Visual Basic that it is trying to run for example when i try to load a profile it gives me that error and it displays this.

Function FindProfileSlot(name As String)
    Dim count As Integer
    
    count = 1
    
    For Each cell In Worksheets("Profiles").Range("SavedSetNames")
        If cell.value = name Then
            FindProfileSlot = count
            Exit Function
        End If
        count = count + 1
    Next

With the Function FindProfileSlot(name As String) part highlighted in yellow and cell highlighted in black.
I know how to set up the spreadsheet so it is not an issue with that, it was working with the 2010 Beta but it seems with the 2010 RTM it has just gotten even worse in terms of compatibility.

In the VBA editor click on the stop button in the toolbar, then go to tools, references. You will see a box checked that says MISSING: Windows Common Controls. Just simply uncheck that box and it should fix this error.

KraxisSingular · 05/18/10, 6:09 PM

So far two pieces of gear have been gleaned from Halion.

A nice Hit necklace, if you have the Onyxia necklace or Wodin's it should be a pretty nice upgrade, and quite possibly even if you don't but run around with the 3/3 Focused Shots build, which I suppose many do.

The other is the trinket, massive passive ArP and a powerful AP proc. Going to be another fight to the death trinket.

[EDIT] My skills of observations are not with me today. It is of course a ring like alienangel mentions and NOT a necklace. Disregard previous comment on it.

alienangel · 05/18/10, 6:22 PM

Also a Hit crit ring (and didn't see a hit neck :o):
http://static.mmo-champion.com/mmoc/...item_53133.jpg

The heroic versions of these items will be 284 I suppose. I imagine they'll go with ICC's unique-equip-by-name model instead of ToC's, but if they don't equipping the regular and heroic version of the trinket is a delicious amount of ArP. Although if you have it, I imagine heroic DBW still works out better than normal Sharpened Twilight Scale.

KraxisSingular · 05/18/10, 6:41 PM

I'm not entirely sure.

It is the same as DBW in terms of construction. ArP as passive and a pretty hefty proc. However, DBW has the problem of using Crit as one proc. First of all it is less value than AP for all three specs, for Survival in particular it has diminishing returns, but even MM can reach and pass the critcap for Aimed Shot. Naturally you can get around it somewhat, but it is still there. DBW also has Agility which is better than AP for all three specs, so it might become a wash in total.

But basically I would say that the new trinket is marginally better since you can be 100% sure of it's value. Getting all Crit procs from DBW is not too great, and of course the longer ICD can mess with encounters. Not saying it is bad, but it does have some unattractive characteristics. Of course it does have the awesome shapeshifting bonus, so I would personally still get it over the Scale.

Rhy · 05/19/10, 3:15 AM

In fact, what we should be looking at is changing our 2nd trinket to Sharpened Twilight Scale and leaving DBW.

If I take my gear as example, I am ArP capped with full ArP gems and my 2nd trinket is DV heroic. Lets say I swap it for Sharpened Twilight Scale. That means that I can change about half of my ArP gems to agility, which basically means the trinket will provide me with 160 agility passive vs the 288 AP from DV. Then, if you compare the procs of both trinkets, the Twilight Scale should provide a small increase over DV heroic. So in the end, the Sharpened Twilight Scale I believe will be a slight upgrade (or maybe I am underestimating it a bit) when compared to DV heroic. Clearly, Sharpened Twilight Scale heroic would be even better.

The problem there is that the example I gave will only work for people who have quite good gear, or in other words the ones that can reach the ArP cap. I really have no idea how the trinkets would compare to each other if you can use all the ArP on Sharpened Twilight Scale without changing anything else on your gear. I can only guess here, and say that its value might even go up, but that will depend largely on the gear you use to compare it to other trinkets, and mainly your ArP level.

Clearly, comparing Sharpened Twilight Scale to WFS will involve some more math, that I am not really too good at. That, together with the fact that I'm actually not that big of a fan of WFS means someone else should do that.

Rivkah · 05/19/10, 3:31 AM

I have added Sharpened Twilight Scale to the online version of the spreadsheet so that people can test out how it compares to alternatives. Since we don't yet know the proc rate and ICD I've set it to use the same as the WFS since those seem like likely numbers. I'll add the heroic one later when we have the exact stats for it.

One advantage I can see for pairing it with another shorter cooldown trinket like WFS is that you could more easily stack cooldowns with both procs.

Mad_Murdock · 05/20/10, 3:19 PM

Originally Posted by davepoobond

I've been experiencing some oddities with the spreadsheet today, Whispering Fanged Skull Heroic is being shown as a 3 dps loss compared to WFS normal. This changes when I equip WFS Heroic on my character then recalculate dps. If I Recalculate DPS in the gear planner with what I have equipped after this, WFS Heroic resumes its "3 dps less" position.

Any ideas on how to fix this or is it just a bug with the spreadsheet right now?

Hope I didn't miss the obvious on this. I'm having the same issue with version 93J. Almost all the items that were upgrades in the 93i version, show has a DPS loss in the 93J version. For example, the Santified Gloves (i264), show has a 39 dps loss compared to the basic (i251) gloves. But, if I go under teh Gear tab and manually switch the gloves, it shows a ~70dps gain. When I choose to "Recalculate DPS" in gear planner, it then shows the i264 gloves has being better and the i251 gloves a 169 dps loss. Interesting to note, it then shows the Heroic version of the gloves has a 7.72 dps loss.

Is there a settings change that I missed from 93i to 93j ? I just cant figure out why the upgrade gear is showing has a loss in the gear planner. I'v re-ran these under 93i and it's results are as expected in that higher Tier or Heroic items are worth more than their non heroic\lower Tier items

**Update** Ok, I think I found the difference. Under settings, I had 93i set to default to ArP gems instead of Agil gems. If I make that same change to 93J, then it sorts the gear to the more expected results. I'm not sure I understand why that makes a difference. Wouldn't a piece of gear that's an upgrade, be an upgrade regardless of Gems ? Or is the gear planner also factoring in gems like Agi, instead of ArP and that's lower it's value against, an lesser item, but correctly gemmed item?