Elitist Jerks
Register
Blogs
Forums


Go Back   Elitist Jerks » Rogues

Reply
 
LinkBack Thread Tools
Old 12/20/09, 12:48 PM   #601
Axodry
Von Kaiser
 
Troll Rogue
 
Mal'Ganis
First off, thanks again to Mavanas for putting so much effort into this.

For those that might be wondering, Mavanas has changed the formula to account for socket bonus's, so do not worry about deleting the extra "1's" from the various activate socket bonus's for the same piece of gear.

On a side note, I assume that what is supposed to happen when you unactivate an item and activate another, the activated item's row will then be highlighted in yellow and the unactivated item goes to white. This was happening for the wpn's, but this wasn't the case for other the other items. I also noted that for the weapons, the change of color was conditional on deleting the "1" before activating another item with a "1". I assume you have some sort of conditional formatting going on? I've never messed with that unfortunately so i'm not sure how to offer a suggestion to fix. I would be curious to know how you did that regardless.
Thanks,

Offline
Reply With Quote
Old 12/20/09, 6:24 PM   #602
 sp00n
banned
 
Night Elf Rogue
 
Wrathbringer (EU)
Originally Posted by Axodry View Post
On a side note, I assume that what is supposed to happen when you unactivate an item and activate another, the activated item's row will then be highlighted in yellow and the unactivated item goes to white. This was happening for the wpn's, but this wasn't the case for other the other items. I also noted that for the weapons, the change of color was conditional on deleting the "1" before activating another item with a "1". I assume you have some sort of conditional formatting going on? I've never messed with that unfortunately so i'm not sure how to offer a suggestion to fix. I would be curious to know how you did that regardless.
Thanks,
Could you elaborate a bit more?
Yes, it's conditional formating, purely depending on a 1 in the 'Active' cell. It doesn't check for multiple selections nor does it deactivate an old item when selecting a new one.


Offline
Reply With Quote
Old 12/21/09, 2:10 AM   #603
Rhøy
Glass Joe
 
Human Rogue
 
La Croisade Ecarlate (EU)
Thank you for the new version !

I just have a little promblem: with a mutilate spec' i have 40 expertise more that i should have. i checked every part but i don't find where the problem can come from.

EDIT: sorry for my bad english

Offline
Reply With Quote
Old 12/21/09, 2:16 AM   #604
siralop
Glass Joe
 
siralop's Avatar
 
Blood Elf Rogue
 
Twisting Nether
Originally Posted by Rhøy View Post
Thank you for the new version !

I just have a little promblem: with a mutilate spec' i have 40 expertise more that i should have. i checked every part but i don't find where the problem can come from.

EDIT: sorry for my bad english
Expertise Food is on by default

Offline
Reply With Quote
Old 12/21/09, 4:46 AM   #605
Mavanas
Great Tiger
 
Night Elf Rogue
 
Lightning's Blade
Sp00n has basically explained the conditional formatting part. As long as you select an item, the entire row will be highlighted. I think it was his suggestion a couple pages ago.

As for socket bonuses, you do not need to deselect them in the "Activate Bonus" column when you change items. They will only contribute to your stats if the item is selected. Activating the bonus does change the dps value of the item, if you are using that score to select items. Note that these scores are based on ilvl264 BiS gear, and can only be used as a starting point to selecting items. Ultimately, you would still need to run the simulation to be sure which item is better.

Offline
Reply With Quote
Old 12/21/09, 7:57 AM   #606
 sp00n
banned
 
Night Elf Rogue
 
Wrathbringer (EU)
Originally Posted by Axodry View Post
On a side note, I assume that what is supposed to happen when you unactivate an item and activate another, the activated item's row will then be highlighted in yellow and the unactivated item goes to white. This was happening for the wpn's, but this wasn't the case for other the other items. I also noted that for the weapons, the change of color was conditional on deleting the "1" before activating another item with a "1". I assume you have some sort of conditional formatting going on? I've never messed with that unfortunately so i'm not sure how to offer a suggestion to fix. I would be curious to know how you did that regardless.
So I've dug (sic?) a bit deeper regarding that matter, and it seems that this is a bug in Excel 2007 when using compatibility mode only. It works fine in Excel 2003.

More precisely, the bug manifests as conditonal formatting not immediately applying to the affected cells. When you scroll down and back up so that the specific cells are off screen, or you select the specific cells, the conditional formatting kicks in and updates/refreshes the screen correctly.

Copying the whole content of the gear sheet to a new sheet within the same document removes the bug (of course this doesn't update the references in the formulae of the sheet, so this is no quick fix). Creating a new sheet in the same document and applying conditional formatting to some new arbitrary data also doesn't show the buggy behaviour.
Saving the spreadsheet when opened in Excel 2007 and reopening doesn't work, neither does saving it in the new .xlsm format.


There might be a chance that copying the gear sheet to a new tab, adapting ALL formulae and saving it with Office 2007 as an .xls may solve the problem, but that would be a lot of work (I guess).
I have not found any solution so far, only a few posts regarding that matter.


Conditional formatting - cell format not immediately updated - Excel Help Forum
Microsoft Excel Conditional formatting in 2007
Excel 2007 Conditional formatting not refreshing as it did in 2003 - microsoft.public.excel.misc | Google Groups

And possibly related to
Odd refresh behavior after you specify a conditional format in Excel


Offline
Reply With Quote
Old 12/22/09, 12:20 AM   #607
Mavanas
Great Tiger
 
Night Elf Rogue
 
Lightning's Blade
If you are getting a #NAME error in the last version, it means randbetween function did not translate well into your excel. As a quick fix till I rewrite that formula using RAND(), go to cell DO577 and replace СЛУЧМЕЖДУ by RANDBETWEEN, so the formula reads:

=IF(OR(AvDamage!$Y$25=Gear!$B$372,AvDamage!$Y$25=Gear!$B$375),IF(SUM(DK427:DK576)=0,0,IF($DK576,RANDBETWEEN(1,3),DO576)),IF(OR(AvDamage!$Y$26=Gear!$B$372,AvDamage!$Y$26=Gear!$B$375),IF(SUM(DL427:DL576)=0,0,IF($DL576,RANDBETWEEN(1,3),DO576)),0))
Then copy that formula down.

Offline
Reply With Quote
Old 12/22/09, 1:23 PM   #608
Gmpotu
Glass Joe
 
Undead Rogue
 
Shattered Hand
Would it be safe to use the EP value on DPS output to compare two separate pieces of gear?
ex. Find a baseline dps. Then run 1000 iterations with new piece A. Then run 1000 iterations with new piece B. And the one with the higher EP would be the better piece assuming 1.96xSE < .35?

An example I can think of is if both are very close in terms of dps output.
Tell me if I'm completely wrong here.

Offline
Reply With Quote
Old 12/22/09, 7:24 PM   #609
Mavanas
Great Tiger
 
Night Elf Rogue
 
Lightning's Blade
If you need to compare two pieces of gear, you do not need EP values. Run the simsheet with piece A and save the dps as baseline. Then run the simsheet with piece B. The piece that gave you higher dps is the better piece. To know if that result is statistically significant, look at the p-value below the DPS values. If that value is less that 10%, you can be 90% sure that the result was not obtained just through RNG. If it's less than 5%, then you are 95% sure and so forth.

Offline
Reply With Quote
Old 12/23/09, 6:35 AM   #610
 sp00n
banned
 
Night Elf Rogue
 
Wrathbringer (EU)
Hm. I think reworking / adding information on how the p-value works would be quite helpful. I still have problems to work out what it exactly means everytime I haven't used the sheet for quite some time.
Maybe add exactly that what you have explained above.


Offline
Reply With Quote
Old 12/23/09, 3:32 PM   #611
Devanar
Glass Joe
 
Night Elf Rogue
 
Shadowsong
Mavanas,

I noticed your edit regarding heartpierce and now how you've claimed that it is the best ilvl 264 dagger. I've read the data posts about how the proc works and how it can proc off your poisons now. I'd just like to know if you have done simulations on the matter and would it outperform the rib spreader?

I noticed in your 3.3c sheet that it is not currently supporting the new findings to how heartpierce works.

Offline
Reply With Quote
Old 12/23/09, 6:51 PM   #612
Mavanas
Great Tiger
 
Night Elf Rogue
 
Lightning's Blade
I added an explanation about statistical significance to the front page. I also added a Q&A section for adding new gear and selecting gear using the simsheet, and I encourage you to read that section to use the simsheet to its fullest.

Also I am releasing an updated version of 3.3c, which has support for custom DPS Value of Gear: that's when you run your own EP values and then use them to calculate the DPS value of each gear piece in the simsheet's Gear Tab (more about that in the Q&A section on the front page of this thread). Also I have updated Heartpierce proc mechanics based on the recent findings. It is in fact the BiS dagger if our understanding of its proc mechanics is accurate. It is better than Rib Spreader by some 120 dps, and it is better than Blood Sipper Heroic by about 90 dps. Using Heartpierce can change your EP stats. It benefits from some amounts of white hit and haste up to a point, but if you get too much haste, the uptime of Invigoration should start dropping due buff resets. It does not mean haste becomes worthless, it's just a warning that you need to run the simsheet to find out how haste scores relative to other stats when using the Heartpierce.

As always your suggestions regarding the interface of the spreadsheet, its ease-of-use, its flexibility and usefullness are encouraged. Also if you find some strange behavior or bugs, let me know as well. Just a warning: strange behavior does not include your comparisons of the DPS value that comes out from the simsheet to what you observe in a raid. There are a ton of posts by now that explain the limitations of inferences based on your raid dps, so I am not going to go over them again.

The new sheet is located here.

P.S. Those that were having a problem with randbetween function translation, see if my new implementation continues to cause #NAME problems in the Combat tab.

Offline
Reply With Quote
Old 12/24/09, 8:39 AM   #613
Caffeine
Von Kaiser
 
Caffeine's Avatar
 
Goblin Rogue
 
Kilrogg (EU)
Regarding Heartpierce in the updated 3.3c version, if I'm understanding your code correctly you are checking if a proc occurred in the last 10 seconds (12 for the heroic version) and add energy accordingly. This doesn't seem to take into account that refreshing the buff will reset the tick timer, as shown in Incoming Rogue Changes Discussion.

Offline
Reply With Quote
Old 12/24/09, 9:40 AM   #614
Devanar
Glass Joe
 
Night Elf Rogue
 
Shadowsong
Mavanas,

Thanks for all your hard work as I have been a fan of your spreadsheet and simulations. I've done some simulations/tests regarding vigor + heartpierce and it appears that I am experiencing a 95-99% confidence rate that it is increasing my DPS by about ~50 or so (I'm using your default settings that came with the sheet download and have only manipulated my gear, professions, vigor talent, and removed heroism / potion of speed (since they don't have a constant uptime)). The interesting point is that when I try the same test with Twin spike Heroic 258, I am seeing only a small ~10 DPS increase with only about 50% confidence.

Offline
Reply With Quote
Old 12/24/09, 12:43 PM   #615
Mavanas
Great Tiger
 
Night Elf Rogue
 
Lightning's Blade
Originally Posted by Caffeine View Post
Regarding Heartpierce in the updated 3.3c version, if I'm understanding your code correctly you are checking if a proc occurred in the last 10 seconds (12 for the heroic version) and add energy accordingly. This doesn't seem to take into account that refreshing the buff will reset the tick timer, as shown in Incoming Rogue Changes Discussion.
It'sa bug. I forgot to delete the old implementation. You are probably looking at the energy regen column. The implementation that takes into account tick timer reset is in column DR and it adds to your energy. However, that also means that in the last implementation, energy from HP was double counted. When I fix the error, HP scores below same ilvl daggers by about 140-150 dps. I have updated the uploaded file, so you will need to redownload it from the front page.

Offline
Reply With Quote
Old 12/24/09, 1:19 PM   #616
 Andeh
The Titleless
 
Goblin Rogue
 
Balnazzar
Originally Posted by Mavanas View Post
It'sa bug. I forgot to delete the old implementation. You are probably looking at the energy regen column. The implementation that takes into account tick timer reset is in column DR and it adds to your energy. However, that also means that in the last implementation, energy from HP was double counted. When I fix the error, HP scores below same ilvl daggers by about 140-150 dps. I have updated the uploaded file, so you will need to redownload it from the front page.
Yeah, I'm getting it as about a 130 DPS loss from the heroic 258 dagger (0.0% Pvalue) as well. That sort of jives with my gut instinct that the 258 heroic weapons would be nearly as good as the 264 weapons with stats, and that even with pretty high uptime HP won't hold up.

United States Offline
Reply With Quote
Old 12/24/09, 1:58 PM   #617
Mavanas
Great Tiger
 
Night Elf Rogue
 
Lightning's Blade
Indeed Twin Spike Heroic appears to be far superior to HP normal.

As for Vigor, first make sure you are doing it right. Whenever you change total energy, you need to change "Do not use if energy is above (HaT only)" setting in the DPS rules. It's there to prevent energy capping in GCD-starved situations, but in this case, you need to change it from 100 to your total energy (110 if you have vigor, 120 if you have it glyphed too). I am seeing the following regarding Vigor:
- dps with Heartpierce increases by 70 when you have glyphed Vigor
- dps with Twin Spike increases by 30 when you have glyphed Vigor
The effect if Vigor on dps is higher for Heartpierce because you have higher energy regen and therefore higher chance to get energy capped. Vigor+glyph reduces the chance to get energy capped. This may also indicate that reducing or eliminating energy pooling may be beneficial to your dps. Check "Do not use if energy is below (energy pooling)" setting for envenom. By default it is set to 60.

P.S. I was right about energy pooling. Consider this table:
Energy Pooling	Vigor+Glyph	Heartpierce	Twin Spike
Yes		No		12998		13148
Yes		Yes		13069		13181
No		No		13021		13153
No		Yes		13047		13181
As you can see, the effect of vigor is seriously diminished when you do not have energy pooling. Also energy pooling is definitely limiting the effectiveness of Heartpierce. Also energy pooling is still effective for Heartpierce, but only when you have more energy. It's probably worth also trying an intermediate energy pooling case, say 50 energy.

Last edited by Mavanas : 12/24/09 at 2:55 PM.

Offline
Reply With Quote
Old 12/25/09, 10:00 PM   #618
Blakcghost
Glass Joe
 
Troll Rogue
 
Skullcrusher
I noticed on the table that the dps with h twin spike is the same for energy pooling with vigor+glyph as it is for no energy pooling but vigor+glyph. Is this because pooling energy is less significant because your not getting the extra energy regen from heartpierce?

Offline
Reply With Quote
Old 12/26/09, 12:22 AM   #619
Mavanas
Great Tiger
 
Night Elf Rogue
 
Lightning's Blade
It's basically not significant. It neither helps nor causes you to get energy capped.

Offline
Reply With Quote
Old 12/28/09, 12:50 PM   #620
Nekrosis
Glass Joe
 
Gnome Rogue
 
Moonrunner
cant load sheet?

I downloaded the current 3.3c but when trying to use it is giving me an error that it cant access /corrupted or is located on a server that is not responding or ect. I've never ran into this before is it on my end or yours?
-Thanks again for the #1 sheet i.m.o Mavanas!

Offline
Reply With Quote
Old 12/28/09, 6:09 PM   #621
Mavanas
Great Tiger
 
Night Elf Rogue
 
Lightning's Blade
Could be neither end. Most likely it is a corrupted download case, try downloading again please. If the outcome is the same, I will create a filefront mirror.

Offline
Reply With Quote
Old 12/28/09, 8:15 PM   #622
Nekrosis
Glass Joe
 
Gnome Rogue
 
Moonrunner
Tryed downloading agin (5 times) to be total and still the same outcome--May be corrupted, located on a server that is not responding, or readonly.

Offline
Reply With Quote
Old 12/28/09, 10:23 PM   #623
Mavanas
Great Tiger
 
Night Elf Rogue
 
Lightning's Blade
Try this mirror.

Offline
Reply With Quote
Old 12/29/09, 8:48 AM   #624
Nekrosis
Glass Joe
 
Gnome Rogue
 
Moonrunner
That one works perfect thanks alot!

Offline
Reply With Quote
Old 12/30/09, 11:12 AM   #625
Mavanas
Great Tiger
 
Night Elf Rogue
 
Lightning's Blade
3.3 BIS

I find the following sets to be best in slot:

Mutilate DPS: 13682

Profession: JC/Engineering (bombs and hyperspeed on cooldown)

DPS Strat: classic 4+, ToTT used on cooldown, no energy pooling, 51/18/2 spec

Gear:
Lungbreaker Heroic (DP)
Heartpierce Heroic (IP)
Gluth's Fetching Knife Heroic
Sanctified Shadowblade Helmet Heroic
Sindragosa's Cruel Claw Heroic
Sanctified Shadowblade Pauldrons Heroic
Shadowvault Slayer's Cloak Heroic
Ikfirus's Sack of Wonder Heroic
Toskk's Maximized Wristguards Heroic
Sanctified Shadowblade Gauntlets Heroic
Astrylian's Sutured Cinch Heroic
Sanctified Shadowblade Legplates Heroic
Frostbitten Fur Boots Heroic
Ashen Band of Endless Vengeance
Band of the Bone Colossus Heroic
Tiny Abomination in a Jar Heroic
Deathbringer's Will Heroic


Gems and enchants:
Double berserking, 1 prismatic in the chest, 34 haste x 3, 20 haste x 11, 20 ap/10 haste x 6 - basically gemming ap/haste in red slots and haste elsewhere. Haste food.


Combat DPS: 13480

Profession: JC/Engineering (bombs and hyperspeed on cooldown)

DPS Strat: 5pt eviscerate, ToTT used on cooldown, 60 energy pooling

Gear:
Bloodvenom Blade Heroic
Scourgeborne Waraxe Heroic
Steakthrower Heroic
Sanctified Shadowblade Helmet Heroic
Sindragosa's Cruel Claw Heroic
Sanctified Shadowblade Pauldrons Heroic
Vereesa's Dexterity
Sanctified Shadowblade Breastplate Heroic
Toskk's Maximized Wristguards Heroic
Aldriana's Gloves of Secrecy Heroic
Astrylian's Sutured Cinch Heroic
Sanctified Shadowblade Legplates Heroic
Frostbitten Fur Boots Heroic
Ashen Band of Endless Vengeance
Frostbrood Sapphire Ring Heroic
Tiny Abomination in a Jar Heroic
Deathbringer's Will Heroic


Gems and enchants:
Double berserking, 1 prismatic in the belt, 34 Arpen x 3, 10hit/10exp x 2, 20ap/10hit x 3, 20 Arpen x 12 - gemming hit and accuracy gems almost up to hard crit cap and expertise cap. The rest are armor pen gems, which end up being just below hard cap. Arpen food.

Thus by the time armor pen gains it's full value near the hard cap, combat almost catches up mutilate in single target dps.

Last edited by Mavanas : 01/21/10 at 7:37 PM. Reason: Updated for TAJ and HP fixes

Offline
Reply With Quote
Reply

Go Back   Elitist Jerks » Rogues

Thread Tools

Similar Threads
Thread Thread Starter Forum Replies Last Post
Cherubael's Rogue Spreadsheet Rosethorn Rogues 29 02/16/09 12:42 PM
Rogue Gear Spreadsheet Aldriana Class Mechanics 2892 08/03/08 5:10 AM
[Rogue] DPS Spreadsheet Ellos Class Mechanics 1595 01/12/08 5:32 PM
Rogue DPS Spreadsheet pf Class Mechanics 2735 07/20/07 5:42 PM
Rogue Spreadsheet tynan Public Discussion 2 12/06/06 5:30 AM