 |
08/10/09, 10:11 PM
|
#1006
|
|
Glass Joe
|
Is Aldriana making an official updated sheet soon? Not that I don't appreciate the ones people have posted already but I just like official releases.
|
|
|
|
|
08/10/09, 11:33 PM
|
#1007
|
|
Von Kaiser
|
Aldriana (including his current signature) says that it'll be out when it's out and not to bug him about it. As Mavanas quite rightly pointed out, there hasn't been a whole lot of change to the actual calculations worth rushing anything out.
If all your looking to do is play with the shiny new gear, either of the updates will suit you just fine. It's really easy to add gear to either sheet if that's all your looking to do.
The only reason I've updated the mutilate sheet is that I wanted to fix up a few little issues, and add the socket bonus stuff in (and previously the raid buffs etc), mainly since Aldriana stated that they were focusing on the combat sheet (given that the fact that combat seems to be on average the spec of choice, I just can't get combat weapons to drop to save myself) and were going to let the mutilate spreadsheet slip. Adding the new gear was just an afterthought.
|
|
|
|
|
08/11/09, 7:52 AM
|
#1008
|
|
Banned
|
I agree with Nerms, I would like an official release as well by Aldriana, not that I do not appreciate all the hard work he has put into his spreadsheets through out the years. I think that yeah, tooling around with the new gear would be cool, but I am also seeing and hearing from other rogues that Arp is the new way to gem. Forgive me if I did not see it in another post, but I would like to play around with the new epic gems in a spreadsheet.... At the same time, no rush Aldriana. 
|
|
|
|
|
08/11/09, 7:55 AM
|
#1009
|
|
Von Kaiser
Troll Rogue
Shadow Council
|
Originally Posted by Jarathag
I agree with Nerms, I would like an official release as well by Aldriana, not that I do not appreciate all the hard work he has put into his spreadsheets through out the years. I think that yeah, tooling around with the new gear would be cool, but I am also seeing and hearing from other rogues that Arp is the new way to gem. Forgive me if I did not see it in another post, but I would like to play around with the new epic gems in a spreadsheet.... At the same time, no rush Aldriana. 
|
It's really not hard to edit new gear into your existing sheet. I did it myself while I quietly and patiently wait for Aldriana's sheet to be finished. At the same time, you can download one of the sheets edited by another member of the rogue community and use that.
|
|
|
|
|
08/11/09, 8:18 AM
|
#1010
|
|
Banned
|
To be honest good sir, I do not know the first step in editing a spreadsheet, I just bask in the glory of Aldriana's hard work. I started hardcore raiding back in the middle of TBC and have been using his spreadsheet's ever since. Hats off to you sir.
|
|
|
|
|
08/11/09, 8:45 AM
|
#1011
|
|
In the rear with the gear!
Troll Rogue
Khaz'goroth (EU)
|
Just unhide the needed sheets, you should be able to figure that out. Renaming the gems and changing 16 to 20 should be trivial then.
|
|
|
|
08/11/09, 10:07 AM
|
#1012
|
|
Piston Honda
|
At risk of sounding condescending or acting too much as a moderator, all this talk of Aldriana's anticipated spreadsheet is getting old quickly and just taking up forum space. His sheet will be ready when it is ready, and constantly asking when it will come out won't make it come out any faster. Lets please try to keep the discussion in these forums related to spreadsheet specific questions, and not keep asking "When will the new sheet come out?", "How do I edit the spreadsheet?", "Is this better or that?". Very little has changed in this patch aside from new gear and gems. These questions have all been answered multiple times and can very easily found by skimming most the last pages of many of the threads in the rogue forums, or possibly even by doing a quick google search.
|
|
|
|
|
08/11/09, 8:21 PM
|
#1013
|
|
Glass Joe
|
Something I've been pondering that I found missing in the current incarnation of the combat spreasheet had to do with ArP. With the current emphasis on ArP over agility, and the EP values of ArP escalating even further in T9 level gear, perhaps it might deem looking into to model Executioner into the enchants for the weapons. Executioner caught up with Mongoose in SWP gear levels, if memory serves properly, and that was before ArP got a sizable buff.
Last edited by Loria : 08/13/09 at 6:54 PM.
Reason: spelling
|
|
|
|
|
08/11/09, 8:53 PM
|
#1014
|
|
Mike Tyson
Night Elf Rogue
Doomhammer
|
ArPen did get a significant buff... but before that, it received a significant nerf. As such, Executioner - which never actually caught Mongoose in effectiveness (that it ever appeared to was merely a spreadsheet bug), was, until the recent buff, *way* behind other options in terms of efficacy.
Let us consider a moment what would need to happen for Executioner to catch Berserking. Given that they seem to have similar proc rates, one presumes that it would require the Executioner proc (120 ArPen) to be competitive with the Berserking proc (400 AP). And this will be the case only if 1 ArPen is as good as 3.33 AP, i.e., its worth 3.33 EP.
Only with the most ArPen-heavy setups does the value of ArPen even crack 3. And in those setups, the goal is to *passively* push the ArPen cap, at which point there's no room for Executioner anyway. As such, there's little reason to believe that Executioner will ever be competitive. Plus, it's a nuisance to model correctly. Hence, I have no particular plans to ever do so, until such time there is reason to believe that it will compete with Berserking.
Mongoose, on the other hand, gives 120 Agi and 2% haste; 2% haste, depending on one's current haste rating, is typically worth something approaching 70 haste rating. With extreme high-end stats, the values of Agi and Haste can crest 2.1 and 1.8, respectively, giving that enchant a value on the order of 2.1 * 120 + 1.8 * 70 = 378 AP. It is thus not inconceivable that, with the improved scaling of agi and haste relative to AP, we may reach a point where Mongoose eclipses the value of Berserking.
...assuming, of course that the proc rates are indeed identical. Which I'm not sure we've ever actually proven. But it is something to keep in mind.
|
|
|
|
|
08/12/09, 6:11 AM
|
#1015
|
|
Glass Joe
Blood Elf Rogue
Defias Brotherhood (EU)
|
Originally Posted by Tinwhisker
You can add it yourself by "un-hiding" the proper sheets and inserting it in along with its stats.
|
As easy as I'm sure this is to most people, I have no idea how to do this.
|
|
|
|
|
08/12/09, 8:31 AM
|
#1016
|
|
Glass Joe
|
Originally Posted by veiled25
As easy as I'm sure this is to most people, I have no idea how to do this.
|
Right click one of the tabs at the bottom and the option should be there
http://img.photobucket.com/albums/v2...p-e/unhide.jpg
It's not an option for me as I've already shown everything (as far as I know), but you should still be able to see what I mean in the above link.
|
|
|
|
|
08/12/09, 8:45 AM
|
#1017
|
|
Glass Joe
Undead Rogue
Bleeding Hollow
|
Originally Posted by Cheeseus
Right click one of the tabs at the bottom and the option should be there
http://img.photobucket.com/albums/v2...p-e/unhide.jpg
It's not an option for me as I've already shown everything (as far as I know), but you should still be able to see what I mean in the above link.
|
I guess my version is too old, I have Excel 2003 and it doesn't have any of those options.
This is what I see on mine: http://img21.imageshack.us/img21/4609/oldi.gif
I tried "view code", but it didn't show any gear or anything like that, it just showed stuff like this:
"Private Sub Worksheet_SelectionChange(ByVal Target As Range)
End Sub"
|
|
|
|
|
08/12/09, 9:00 AM
|
#1018
|
|
Glass Joe
Night Elf Rogue
Silvermoon (EU)
|
Instead try this:
In the top menu; File, Edit etc, go to:
Format -> Sheet -> Unhide
A little "pop up" boks should appear where you can chose what sheet you want to unhide.
That should work.
|
|
|
|
|
08/12/09, 9:40 AM
|
#1019
|
|
Von Kaiser
|
Comparable?
Hey guys, I hope this post is OK here, but I want to know if the Combat and Mutilate spreadsheets from here(ether original or updates) DPS results are comparable across spreadsheets?
To give a slightly more specific example If I have both spreadsheets setup with my gear (same on both) and my standard Mut spec on the one, and my standard Combat spec on other with the glyphs being appropriate to each spec, should the DPS numbers be comparable to each other across spreadsheets to see how certain items effect each spec differently?
Specifically I tested my Sinister Revenge x2 on my Mut SS and got X DPS. Now on my Combat SS (with hack and slash) I tried Malice/Remorse sword combo and I got X-800 DPS. Now I bet I am missing something stupid, so I hope someone can explain. I expected with the slightly higher iLVL of the swords and with them being decently well itemized I would see similar if not better DPS, but I did not.
Am I doing something wrong trying to compare across or would those weapons accurately be that much lower with a combat build?
|
|
|
|
|
08/13/09, 4:54 PM
|
#1020
|
|
Glass Joe
|
So I'm sorry if this is a stupid question. I tried looking through the posts and couldn't find a definitive answer. Once you reach the Poison Hit Cap (315) and the Expertise Cap at which point is it better to start stacking ArPen gems vs. Agi gems?
Using Aldriana's spreadsheet it shows that Agi is the way to go but I see all the top rogues stacking ArPen...what gives?
I'm currently 4/5 T8 and have rest uld10/25 gear.
|
|
|
|
|
|