I have a slight problem with the spreadsheet and I couldn't find this anywhere. So I replaced the values of one of the trinkets with fezzik's pocketwatch, where I just put in flat values and gave an EP of somewhere around 140, and then equipped it. I substitute it with Mirror's Truth on the equipment menu, and I lose DPS, despite the fact that it has a way higher EP value, and this also happens with other trinkets. When fezzik's equipped, its 140 EP is even shown on the equipment menu as well.
First ill like to say THX alot for the spreadsheets.
I have been inserting other items in the spreadsheet (Equipment i had, that was not there (ilvl200), it's not that hard
When i change Delicate Cardinal Ruby (20 Agi) with a Glinting Ametrine (10 Agi/10 Hit) ((Only in yellow sockets that is )) then my Rough DPS is larger
im Combat specc, 15,51,1 Mace.
so here is my question. IS the Spreadsheet so accurate, that i should use Glinting Ametrine (10 Agi/10 Hit)in all yellow sockets instead of Delicate Cardinal Ruby (20 Agi)
hmmmm.... looks understandable ..hehe, sorry if im not making my question clear...then plz ask me what i mean, and ill try to write it in another way
The modelling of the spreadsheets is based on testing and a set of assumptions which result in certain EP values for the respective gear stats. Those EP values are affected by your spec, your gear and however you're buffed. To this end, as your gear changes, so may whichever stat is strongest (holds the highest EP value) for you.
As the EP values to some extent are based on assumptions, the spreadsheets will invariably hold some inherent flaws which cause inaccuracies. That means you have to choose whichever spreadsheet you trust the most or works best for you.
At any rate, please note this:
1. The spreadsheets are generally very skillfully modelled and their inaccuracies kept at a minimum.
2. In applying a pragmatic approach, ask yourself this: If you decide to disregard the spreadsheets on account of not trusting their accuracy, what other, more precise tools will you then use to decide what gear to wear and how to gem?
In short; yes, the spreadsheets are plenty accurate for you to trust them - and they're also the best gear selection tools available.
As a side note: I can't access your armory profile, but if you're currently wearing ilvl 200 gear, I reckon it's fair to assume that your gear'll be upgraded shortly (Emb. of Conquest/ToCh). To this end, a friendly advice would be not to use epic gems yet since your EP values could soon change a fair bit. Everyone's own decision, of course.
Don't misunderstand me, im VERY happy with the spreadsheet, even putting items in there my self.
I have now put in the name of my toon, so you should be able to look at it, dont think there are much to say about me ...(im not all ilvl 200 only 2 or 3 items left)
just want to do max DPS ...like everyone else and understand how things work
Thx for the answer
I had a question that I've searched around for but can't seem to find an answer to: at what point is using double Wound superior to using Wound/Deadly?
I understand that on fights with alot of target switching it is superior to use double Wound, but I cannot figure out what the breaking point is for using double Wound on a target where we stand and dps. I assume, through what I've read and experimentation with the sheet, that it has alot to do with the amount of time that we are dpsing our primary target. For instance, with double Berserking enchants 138 seconds is the breaking point for my suggested offhand poison to be Wound, while with double Mongoose that number jumps to 192 seconds.
Can anyone please clarify? Does it ever become superior to run a double wound setup on a target with a large amount of uptime (3+ min)? Is there a minimum amount of haste needed to maintain a permanent double Wound setup?
I had a question that I've searched around for but can't seem to find an answer to: at what point is using double Wound superior to using Wound/Deadly?
I understand that on fights with alot of target switching it is superior to use double Wound, but I cannot figure out what the breaking point is for using double Wound on a target where we stand and dps. I assume, through what I've read and experimentation with the sheet, that it has alot to do with the amount of time that we are dpsing our primary target. For instance, with double Berserking enchants 138 seconds is the breaking point for my suggested offhand poison to be Wound, while with double Mongoose that number jumps to 192 seconds.
Can anyone please clarify? Does it ever become superior to run a double wound setup on a target with a large amount of uptime (3+ min)? Is there a minimum amount of haste needed to maintain a permanent double Wound setup?
Play with the spreadsheet. Ultimately, the point at which the break occurs is when the amount of ticks you get from deadly poison + ramp up time for five stacks doesn't exceed the damage output by wound poison -- which doesn't have the same ramp up time but hits for less when it procs. I do not believe it is currently feasible to stack so much haste that wound poison exceeds deadly poison in overall damage for lengthy fights.
Hello, first time poster here. I just wanted to make sure I'm using aldriana's spreadsheet properly. I recently went to an evis only spec. Under the settings options I wanna make sure I'm clear on whats enabled and not, currently I have use agi value for armor pen turned to "No" and use 3.2.2 armor pen Conversions turned to "Yes". With these settings its recommending I gem for armor pen just want to make sure I have the proper settings enabled before I go re-gem everything
Thank you
I have a question regarding a speadsheet calculation.
Recently i've been seeing this a lot, it seems as if I get more dps if I replace my only blue socket with a dps gem (usually to hit ArP soft cap). Basically, I lose my meta socket requirements and It's a dps increase?
Can anyone clarify this? Does the spreadsheet include the meta gem bonus and It's requirements?
Hello, first time poster here. I just wanted to make sure I'm using aldriana's spreadsheet properly. I recently went to an evis only spec. Under the settings options I wanna make sure I'm clear on whats enabled and not, currently I have use agi value for armor pen turned to "No" and use 3.2.2 armor pen Conversions turned to "Yes". With these settings its recommending I gem for armor pen just want to make sure I have the proper settings enabled before I go re-gem everything
Thank you
Yes you have it set correctly. Use agi value for armor pen should only be set to yes (and iirc will automatically set itself to yes) once you pass the armor penetration cap.
I have a question regarding a speadsheet calculation.
Recently i've been seeing this a lot, it seems as if I get more dps if I replace my only blue socket with a dps gem (usually to hit ArP soft cap). Basically, I lose my meta socket requirements and It's a dps increase?
Can anyone clarify this? Does the spreadsheet include the meta gem bonus and It's requirements?
It doesn't ensure that you meet the requirements. Best thing is to manually ensure you meet them and if not, pack a nightmare tear into a slot where the sheet recommends that you should try and get the socket bonus.
In yellow sockets 10agi/10crit , 10agi/10haste, or even in your case 10agi/10hit will always show up as a dps increase compared to a bland 20agi gem.
No they won't.
Yellow sockets getting 10agi/10crit or 10agi/10haste is based on whether the socket bonus will allow the combined socketbonus + gem ep to exceed that of doing straight 20agi/40AP (i.e. A yellow gem with an EP value around 37 + a 6EP socket bonus > a 20agi gem of around 41-42EP)
It just so happens that most of the yellow sockets are in the combination of just yellow or red + yellow so this is typically the case. There is gear with red + yellow + blue where this doesn't hold true, the cost of gemming a blue gem to meet the socket bonus means it's better to gem completely with red.
Yellow sockets getting 10agi/10crit or 10agi/10haste is based on whether the socket bonus will allow the combined socketbonus + gem ep to exceed that of doing straight 20agi/40AP (i.e. A yellow gem with an EP value around 37 + a 6EP socket bonus > a 20agi gem of around 41-42EP)
It just so happens that most of the yellow sockets are in the combination of just yellow or red + yellow so this is typically the case. There is gear with red + yellow + blue where this doesn't hold true, the cost of gemming a blue gem to meet the socket bonus means it's better to gem completely with red.
That depends on spec as well. For example, for mutilate weaponswap spec, haste has EP value of 1.97, which makes 20ap10haste gem better than 40 ap in any yellow socket.
I tried skimming through the thread but didn't see anything on it but does the spreadsheet take weapon swapping into account with the ruptureless rotations? I know there is a dps simulation but im coming up with different numbers for 51/137 and 51/18/2 on each.
I tried skimming through the thread but didn't see anything on it but does the spreadsheet take weapon swapping into account with the ruptureless rotations? I know there is a dps simulation but im coming up with different numbers for 51/137 and 51/18/2 on each.
No, there's no weapon swap included in this spreadsheet.
So I was wondering why it is that when I change the settings on the combat spreadsheet from Race: Night Elf to Race: Human I lose 6 dps.
Now granted that I'm projected to be at 7328.4 (not BiS and in a smaller guild so likely never will be) it isn't a meaningful change, I just can't figure out why it would be there at all.
Especially considering how useful I've found Every Man For Himself to be for my time on target. I'm using fist/dagger, so it's not the shift in expertise.
So I was wondering why it is that when I change the settings on the combat spreadsheet from Race: Night Elf to Race: Human I lose 6 dps.
Now granted that I'm projected to be at 7328.4 (not BiS and in a smaller guild so likely never will be) it isn't a meaningful change, I just can't figure out why it would be there at all.
Especially considering how useful I've found Every Man For Himself to be for my time on target. I'm using fist/dagger, so it's not the shift in expertise.
I am trying to understand some results I am seeing using the 1.3b4 Combat sheet. I've entered my gear and switched my race and then left all the settings as they came except for the 'Use 3.2.2 ArPen Conversion', which I set to 'Yes'. As my guild is working on ToC-10H and ToC-25 regular, I have set ToC-25H to No in the zone filters.
With my current shoulders (Spaulders of the Snow Bandit), the sheet calculates a DPS value of 7422.7. Three potential upgrades are listed for me (with the values for them listed): Spaulders of the Snow Bandit (Heroic) 78.03; VanCleef's Pauldrons of Triumph 60.72; Duskstalker Shoulderpads 60.00. That would seem to indicate that the Heroic Spaulders of the Snow Bandit are better than the VanCleef's, which it turn are marginally better than the Duskstalkers, which are noticeably better than my current shoulders.
However, if I actually switch my equipped shoulders in the spreadsheet to each of the recommended options, the resulting DPS values don't agree with the order of the suggestions. The VanCleef's come in at 7389.9, Heroic Snow Bandit at 7455, and Duskstalker at 7475.4. The lowest of the recommendations has the largest increase in DPS, and the Van Cleef's actually reduces my DPS.
Can anyone explain the discrepancy between the rankings of the recommended upgrades and the calculated DPS values when actually equipping the different shoulders. I assume the calculated DPS is more accurate than the numbers being generated for the recommendations, but I'd like to understand why better before I spend the badges on the Duskstalker Shoulderpads.
When your spreadsheet calculates your top three upgrades, it's using your EP values (Right side of your sheet). When you change different pieces of gear around, those EP values change as well. In your case, my guess is equipping Duststalker shoulders changed some of your EP values (Probably Armor Pen). You'll notice the same thing when you change gems around, the dps value will change as you change gems/gear. This is what makes spreadsheets better tools to calculate your gear.
Not sure if this is 100% correct, but I guess at least the underlying mechanic is correct.
The sheet uses your current stats for calculating the upgrades and the DPS numbers. For simplicitys sake, let's just say that it uses the AEP values to calculate this (which is actually not the case, but the mechanic is the same).
And of course your AEP change as your gear changes. Maybe you have reached the expertise cap, maybe you have reached the spell hit cap, and all of this influences how much of an upgrade an item really is.
Theoretically and AEP-wise all this expertise on the T9 helm looks good, but if you're already near the cap, it won't help your DPS.
The values you see are just predictions, based on your current gear. They are not actually calculated with the new stats.
10/21/09, 2:49 AM
