Radmsc

Awesome job on updating that spreadsheet, allthough there are some little things which could be updated in the next version if that's possible:

- Typo in "Split Greathammer"
- I can't find Enchanted Tear in the gem list so I added it manually
- Fish feast (80 attack power for rogues) is not in the buff list

I hope to see this updated, keep up the good work!

 

StijnH

It's just not in the description. Set 'AP Food' to TRUE and it'll work just fine.

 

Tinmazter

So I am using aldriana's spreadsheet and now seeing vef's I see some differences, does anyone have any idea which one is more accurate because I keep struggling between using void sabre and rune etched and some other differences make me wonder.

 

Onodrim

I use both spreadsheets and in my experience they're are fairly close in terms of calculating my total, potential dps. However, as far as I can gather, the respective spreadsheets are constructed on slighty varying premisses. I don't think that necessarily means one is more accurate than the other(s), but rather that each of them have their different strong points and inherent compromises when it comes to modelling the dps output of a RNG based event like a boss fight.

That being said, though, Vulajin hasn't himself made an updated version of his spreadsheet available for download, as far as I know; and he did make a post a few months ago where he recommended using Aldriana's spreadsheet instead of his own. I know Vef's been working on updating the 0.4.7 version of Vulajin's sheet, however, I'm not Excell savvy enough to know if not being the person who actually developed the sheet puts you at a disadvantage when it comes to achieving as much accuracy as possible. I suspect it doesn't exactly help. So, in this light, a cautious guess would be that at least until Vulajin releases the 0.4.8 version, Aldriana's sheet might just be the width of a hair ahead of Vulajin's in terms of being updated and accurate.

 

Druss

For some reason these just stopped working for me - i can change the gear etc but the dps value seems frozen and does not change. Even downloaded it all over again but still no joy. Any suggestions?

Im trying to test whether it is worth breaking a 4p T7.5 for the 8.5 gloves.......suspect not worth it but like to see.

 

Ringo

Apologies for what is probably a dumb question. I have never posted before as all the information is already there in front of me but I am cracking up not being able to find this answer. On the 3.1 combat spreadsheet I cannot see the gem slot bonuses (by satisfying colour requirements) or find a way of activating them so they appear in my overall stats. Is there something I need to do. Sorry

 

Mavanas

This could be an automatic calculation problem. First check if pressing F9 (manual recalculate) changes the values of the cells. If it does, it means that somewhere in a VBA code, which was interrupted early, there was a call to turn off automatic calculation. You can turn it back on in Tools -->Options-->Calculation tab.

 

Sadyr

I'm not an excel expert but I do know my way around. I couldn't find in any of the several spreadsheets where the human racial bonus for swords was included in the expertise bonus. I was wondering if I was wrong or if it just wasn't that important to add.

P.S. Thank you for all of the hard work on the spreadsheets, you guys rock!

 

Tinmazter

Ok so seeing these replies which would you guys think is best? Rune Etched or Void Sabre, I couldn't see much difference

 

evoslayer

It is probably Void Sabre, but again, use the spreadsheet.

Depending on your specific gear the values of items could vary dramatically, this is why loot ranking websites, although providing very rough guidelines for loot quality, are useless in making close gear decision, for the same reason it is unwise to ask someone who may have different gear than you which you should use, and really there is no reason to, because there are numerous good spreadsheets out there that can give you an answer easily that is more accurate than anything anyone else can tell you.

 

Tinmazter

I did do that and one spreadsheet says void sabre and the other says rune etched that's the reason why i started to ask here

 

Valustria

In that case, they are very close and either one you choose is likely to be "good enough". I'd look at both on both spreadsheets, account for the difference, and go with whichever one has the higher average DPS value.

"In emptiness there is good, but no evil. Wisdom exists, logic exists, the way exists, and the mind is empty."
~ Miyamoto Musashi, The Scroll of Emptiness, The Book of Five Rings

 

Vef

I added the new hardmode loot. I also want to say that the sheet currently assumes an experimental 10% proc chance on 2pt9.

Roguecraft_macro_3.2

 

Infuria

Vef, the 3.2 Mutilate download link is broken.

Where are you seeing the 10 % proc rate? Wowhead has it listed as 2 % in the tooltip. (That said, I trust you much more than wowhead in this regard!)

 

everix1992

I have a quick question about something i ran into on the spreadsheet. I am currently wearing 3/5 t8/t8.5 and 2/5 t7.5. When I went in and put myself in 4/5 t8 and 1/5 t7 the dps results dropped. I am curious if you guys think this should be right as I would assume that getting the four piece bonus for t8 would outweigh losing the t7 two piece bonus. Any thoughts?

 

DarkKnight388

Didn't you lose the Meta gem requirement, by any chance?

 

everix1992

No I didn't. I'm using the Relentless Earthsiege Diamond and the Red gems are easy to meet with the rest of my gear and my belt is holding a purple gem.

 

Blizisyimhot

I'm still unable to download the 3.2 mutilate sheet. Its still still giving me the not found/removed error. Anyone else experience this?

 

Infuria

Yes. I sent Vef a PM regarding this. You are not alone. I presume the 500+ downloads from the link are all failed downloads =(.

 

Meateater

I ask me the question, if the 3.2 combat sheets includes the new buff on orc rogues.

I am wearing Calamitys Grasp as a Fist with additional 5 expertise througt race-bonus and a Dagger (Steel Bladebreaker ) with no additional expertise. (Orc now gains 5 additional expertise on fists and axes as you know)

My expertise without any stuff but the weapons is 15/10 as a Combat rogue. The sheet shows that i have got 24 not including the information for both hands. In real I have 6,00%/4,75% or 24/19 expertise.

Another Question I found, is why the value for expertise is set in the dps-calculation table to zero (there are the aep-values shown for the dps-dependent values)

 

faruthia

could I request that the stygian bladebreaker be added to the main hand list under the mutilate spreadsheet? Also it seems that there are alot of gems missing from the gem list.

 

Vef

I changed the orc racial bonus and the t92pc is 2% now :X I don't include all the gems like +20 haste and stuff because the're all not viable.

 

Infuria

The link to your downloadable sheets has not reflected this change. How do you adjust the % of the 2-piece set in your sheet?

 

Vef

I added a XeYrZe (CttC) cycle to the mutilate sheet, which is slightly better than Xe/Yr (CttC).
Set the combo points to 4e3r4e or something like that and you'll see a small dps boost, tested in t9 gear.

Roguecraft 3.2
sp00n's Roguesheet AEP Values

 

Maweric

So if it is as it looks like after few ulduar25 runs, thats double IP evi mutilate build goes ahead ip dp build, wouldnt it be more efficient to use slow dagger in OH also for better change to proc IP on mutilates