Only enter the skill damage if you want to see how it applies to your char sheet dps. If you are looking at how much FO orb you do, for example, then don't enter Black Hole damage. Similarly, if you use FO, don't include fire, arcane, or lightning damage.
Also, check to make sure the stats match (int, cc, cd) with your in game stats. Then, check to be sure you have the right buffs selected. If you're using Force Weapon, you have to enable Magic Weapon too, since they work separately. Finally, for paragon points, enter how many points you allocate to the specific values, so if you have 50 points in CC, put 50, not 5 or 0.5. The same is true for the other stats.
If you still can't get the stats to match up, take a screenshot of the spreadsheet, or post your copy of the spreadsheet through googledrive or something like that, and I'll see what's going on.
It's not completely an issue of toughness but also off life replenishment. On your gear, all I see is one piece with LPS and about 10k LaK. You have AR on one piece of gear and no extra armor rolls. In short, you get hit for a lot of damage and don't replenish it very fast. Of course, part of that depends on how you have your paragon points spent, which don't show on your char sheet.
My recommendation is to pick up some AR and armor rolls on pieces, particularly pants, chest, shoulders, boots at least. I also recommend getting some LoH and/or using the Templar for some extra LPS. You can try putting paragon into LPS over AR, but I prefer AR since Templar gives a lot and I love having as much mitigation as I can get (since I run with Power of the Storm instead of EA).
Quote from Kajikami»Well, going with your numbers: A: (1 + .5*4.75) = 3.375B: (1 + (.35-.45)*(3.50-4))*1.4 = 3.115-3.92 So it depends where exactly in those ranges you fall. It's just simple math. That said, as Ebola pointed out, it is entirely possible to find pieces with both crit chance/damage and elemental damage.
This math seems flawed. Shoudnt it be .5*1 + .5*4.75 = 2.875. 1 is your base hit, but when you crit you dont do your base hit, you only do your crit hit. So you only do your base hit 50% of the times with 50% crit chance. With your formula, 50% crit chance and 0% crit damage you would end up with: 1+.5*1.5=1.75 damage, which makes no sense considering your crits are only 1.5 damage to begin with. The correct way would be: .5*1+.5*1.5=1.25 damage. Which makes sense because with 50% extra damage on a crit 50% of the times you obviously end up doing 25% more damage.
The math is right. If you have 50% CC and 475% CD, and say 100 dps, half the time you do 100 damage, the other half the time you do 575 damage. That averages out to 337.5 damage per hit, or a modifier of 3.375
The formula you're looking for is along the lines of
(1-CC)+CC*(1+CD)
In words, you do base damage a fraction of the hits equal to (1-CC). When you crit, you do CD extra damage above the base, i.e., with 100% CD you do double the base damage.
That's why I have a dps spreadsheet. It's meant for wizards but with some creativity you can use it for other classes (just not dual wielding, but that shouldn't make too much difference between CC/CD vs ele, unless you are talking about on weapons.
Loroese is right but since they stack multiplicatively, the optimal ratio is 10 armor to 1 resist.
Where can I find the functions that calculate damage reduction for AR and armor? I've seen the one that calculates total damage mitigation, but it doesn't hint at the optimal ratio.
I have the calculations in my spreadsheet, or you can calculate them manually. The in game tooltip is for lvl 70 mobs, but gives a reasonable approximation (assuming mobs are lvl 73, if they aren't, someone please let me know).
I'm seeing this posted 2-3 times per day on the official forums. One is called Disintegrate, the other skill is called Disintegration Wave. Answer the question, are they the same skill? There's your answer.
where dr1, dr2, dr3, etc. are the AR, Armor, Blur, or any other damage reduction stat. MobLevel is the level of the mob, which I think is 73 at max level since it used to be 63 when the cap was 60. The in game values are based on lvl 70, if I'm not mistaken, because they just use your level for that stat.
I find it much easier to go with survivability factors instead of damage reductions, actually. Unless you want to alt-tab and load spreadsheet instead, that is.
Toughness = HP*armor_mod*res_mod*...
Where armor_mod is inverse of the damage reduction from armor, so it's "1+armor/3500" at lvl 70. Res_mod is "1+res/350". This makes it quite obvious what to pick, just take the mod which increases the respective factor by higher % of its current amount.
For examply, say, you've got 300k HP, 7k armor and 1.4k resists and you're making a choice between 100 AR, 600 armor(let's say it's a chest piece) and 10% life. Without any other modifiers considered life is the best toughness booster(though not necessarily the best choice, since it doesn't affect incoming healing), but if you have paragon armor boost, then it's a different story.
Anyway, the AR vs armor will most likely ever be a question(due to 4 primaries) on shoulders, chest piece and pants. Other slots have more valuable stats available and to add insult to the injury, they roll less armor values than those. Chest and pants will almost always be better off with armor rolls at a decent gear level, however. High paragon level makes it even more advantageous.
My main issue with toughness is it factors in too many things. It includes single resists, so you might have some item showing as higher toughness with armor than AR, but it's because you have +lightning resistance or something like that. Against anything except lightning, the item could be worse. Or maybe it has +melee damage reduction, which is great for melee damage, but useless for projectiles that are all too deadly for wizards. That will be overinflated in toughness since it factors in that too. That's why I prefer EHP and damage reduction. That way I know exactly what I'm getting, in a conservative way since I use AR and ignore single resists.
What I prefer to do is stockpile some pieces that might be useful, then play around with them in a spreadsheet to see what they actually do.
I do agree that for chest and pants, wizards are almost universally better off with armor than AR (I prefer both, but that depends on where you get your vit from).
Don't worry about a ratio, just get as much as you want to feel comfortable. For me that's as much as I can get and the higher I can stack them the higher the difficulty I'll run (that's the theory anyway).
If you use EA without PA, that just means you might get more EHP from an armor roll vs a AR roll on some pieces besides chest and pants.
Your unbuffed and buffed char sheet dps should match those of the spreadsheet when unbuffed or fully buffed, respectively. If not, then chances are you entered something wrong. If you're absolutely sure you entered everything right, let me know and I can either find the bug or figure out what isn't entered correctly.
Regarding your questions:
1) The legacy affix is "Adds +x% [elemental] damage" like on the SoJ in my profile. The new +Elemental Damage% affix says "[Elemental] skills deal x% more damage"
The spreadsheet is only meant to track one skill of one element. If you want to compare different gear sets or look how your damage is different for a different element and/or skill, you'd have to utilize the gear comparison tab, or can use multiple copies of the spreadsheet. Including functionality for multiple skills or elements will mostly overcomplicate the spreadsheet.
2) Conflag is one of several buffs I haven't gotten around to adding to the spreadsheet. The simple fix for now is to simply add 6% crit to one of your items to see the relative gain.
3) The spreadsheet is meant to mainly be used to compare items in a simple manner, like switching an elemental item for a non elemental, CD vs CC, and things like that. It is not meant to compute your total effective dps, since those calculations tend to be fairly complex, especially when combined with some of the new legendary procs. The spreadsheet can help compare weapons since it can show an effective dps for each, but you'll have to account for the approximate value of the proc yourself.
Thank you very much. I still haven't gotten my DPS to line up correctly. I'm thinking it has to do with my legendary items and/or the +% skill damage (Magic Missile). The DPS in the spreadsheet seems to be slightly lower than in game. So this seems like it could be the legs. If you wouldn't mind I'd like to send you my spreadsheet to take a look.
The skill damage buffs don't show on your char sheet dps, so you can't match the "effective dps" entry with what you see in game. Main thing I can think of is maybe you're putting the skills and/or elemental stuff in the wrong row. The +Damage% as Elemental [Legacy] row, or row 19, should be all blank for you. Otherwise I'm not seeing anything on your gear that should give different results, so if that's not the issue I'll have to take a look at your entries in the spreadsheet.
Thanks for your amazing spreadsheet ! But i have a "problem", my "Unbuffed Char Sheet DPS" is not what i see ingame ( i have tried to turn off Glass canon etc.) but my "Buffed Char Sheet DPS" is ok ! Do you have any ideas ?
You'd have to link me your in game profile but it sounds like you forgot to disable a buff or two (unwavering will maybe?). If the buffed works, then everything should be fine.
where dr1, dr2, dr3, etc. are the AR, Armor, Blur, or any other damage reduction stat. MobLevel is the level of the mob, which I think is 73 at max level since it used to be 63 when the cap was 60. The in game values are based on lvl 70, if I'm not mistaken, because they just use your level for that stat.
How do you guys have such high damage reduction? I think I'm under 70% damage mitigation, but my AR is over 2k. I forget exactly what my Armor is, but I do know my pants have Armor stacked. I also use blur.
I always talk of total mitigation, which is a multiplicative combination of armor, AR, and blur damage reduction. When I calculate my personal mitigation, I'm around 94.1% in my gear set (though what I have equipped now is a little difference since I was trying some normal mode speed bounties). That means whena mob hits for 100k, I only take 5.9k damage.If I add 100 AR to that, I would only take around 5.5k, or about 6% less damage. Let me phrase that another way: 100 AR makes me take about 6% less damage. That's pretty similar for every 100 AR I add, though there's some slight scaling issue due to how armor and AR add to total mitigation.
As for the "10 armor= 1 AR" statement people like to quote on occasion, itis only true if you have 10x the armor as your AR. For wizards, that's nearly impossible since we get AR from our primary stat. Most of us are probably floating around the 6:1 ratio. For example, based on my torrent farming gear stats, 1 AR gives me 2933 EHP. 10 armor gives me 5311 EHP. That means my 1 AR is worth about 5.5 Armor. To give another example, that means an armor roll of 400 on a piece of gear gives me about the same EHP gain as a roll of 72 AR, which is why I prefer an AR roll on most pieces.
There is not much point going beyond 1500 AR as you get ~5% dmg reduction for ~500 ress after it. And you need about 10-11k armor for ~80% reduction. I'm thinking of rolling some items with armor as opposed to all ress.
The problem is if you're at say 80% total damage reduction, and say 500 AR puts you to 85%, you're not just gaining 5% reduction, you're taking 25% less damage since you go from taking 20% to 15% damage from mobs. Or, you're taking 33% more damage at 80% mitigation than someone with 85% mitigation. That's why AR and armor is always good.
With my current knowledge and testing, i came to the conclusion that 5 armor is better than 1 AR. So i usually try to roll armor on pieces that can get only 100AR but close to 600 armor like chest and pants. While I haven't testes all possible skill/ gear combinations it seemed like this holds for all cases.
That depends on your actual values of AR and armor. For me, 1 AR is worth about 5.44 armor, and I don't use EA. If you use Energy Armor or crystalize, it swings a bit more in favor of Armor. That's also part of the reason I use my spreadsheet. I also go for armor on chest and pants for the same reason.
from what i have learned and was told maxing AR so high can be kind of redundant at a point. You could easily roll a bit more vit without sacraficing much AR keeping your AR still high (which yours is extremely) and doubling your life. you wont take double damage just by taking away a reasonable amount of AR and you will be better off.
However if you are bound on staying with that kind of vit, then life regen / LoH will do wonders since your pool is so low.
Higher AR and armor definitely does wonders for your life replenishment. That's the purpose of damage mitigation: sustainability. The purpose of life/vit is to live through burst damage and give a bit of a cushion depending on the sustained damage.
The reason I say vit is overrated is because once you have enough total EHP to survive a couple large hits from whatever you want to survive, extra vit likely won't help much at all. Also, if you don't have much Armor or AR, you'll take damage faster than you can replenish it, meaning you either have to kite (and lose edps) or you die more often, resulting in slower play.
In the end, as Bagstone said, it's about balance, and everyone will have their own balance. I happen to prefer around 200k hp and then as much AR and armor as I can get. For higher torment I wouldn't want to go much higher anyway, because it will make replenishing it a pain.
Your unbuffed and buffed char sheet dps should match those of the spreadsheet when unbuffed or fully buffed, respectively. If not, then chances are you entered something wrong. If you're absolutely sure you entered everything right, let me know and I can either find the bug or figure out what isn't entered correctly.
Regarding your questions:
1) The legacy affix is "Adds +x% [elemental] damage" like on the SoJ in my profile. The new +Elemental Damage% affix says "[Elemental] skills deal x% more damage"
The spreadsheet is only meant to track one skill of one element. If you want to compare different gear sets or look how your damage is different for a different element and/or skill, you'd have to utilize the gear comparison tab, or can use multiple copies of the spreadsheet. Including functionality for multiple skills or elements will mostly overcomplicate the spreadsheet.
2) Conflag is one of several buffs I haven't gotten around to adding to the spreadsheet. The simple fix for now is to simply add 6% crit to one of your items to see the relative gain.
3) The spreadsheet is meant to mainly be used to compare items in a simple manner, like switching an elemental item for a non elemental, CD vs CC, and things like that. It is not meant to compute your total effective dps, since those calculations tend to be fairly complex, especially when combined with some of the new legendary procs. The spreadsheet can help compare weapons since it can show an effective dps for each, but you'll have to account for the approximate value of the proc yourself.
A good rule for every class: stack AR up to ~900-1100. Then think about Vit/%Life.
I disagree. I'd rather stack AR and armor as high as I can and just keep enough hp to not get 2-3 shot by things. That makes it easier to manage loh/life regen and such. If you take 50% less damage, your LoH is twice as good, in other words.
Like a lot of others on the official forums, I tend to think vit and life% are overrated for most people.
0
Also, check to make sure the stats match (int, cc, cd) with your in game stats. Then, check to be sure you have the right buffs selected. If you're using Force Weapon, you have to enable Magic Weapon too, since they work separately. Finally, for paragon points, enter how many points you allocate to the specific values, so if you have 50 points in CC, put 50, not 5 or 0.5. The same is true for the other stats.
If you still can't get the stats to match up, take a screenshot of the spreadsheet, or post your copy of the spreadsheet through googledrive or something like that, and I'll see what's going on.
0
My recommendation is to pick up some AR and armor rolls on pieces, particularly pants, chest, shoulders, boots at least. I also recommend getting some LoH and/or using the Templar for some extra LPS. You can try putting paragon into LPS over AR, but I prefer AR since Templar gives a lot and I love having as much mitigation as I can get (since I run with Power of the Storm instead of EA).
0
The formula you're looking for is along the lines of
(1-CC)+CC*(1+CD)
In words, you do base damage a fraction of the hits equal to (1-CC). When you crit, you do CD extra damage above the base, i.e., with 100% CD you do double the base damage.
0
0
0
0
What I prefer to do is stockpile some pieces that might be useful, then play around with them in a spreadsheet to see what they actually do.
I do agree that for chest and pants, wizards are almost universally better off with armor than AR (I prefer both, but that depends on where you get your vit from).
0
If you use EA without PA, that just means you might get more EHP from an armor roll vs a AR roll on some pieces besides chest and pants.
0
0
0
Armor_dr = Armor / (Armor + 50*MobLevel)
total DR = 1-(1-dr1)*(1-dr2)*(1-dr3)...
where dr1, dr2, dr3, etc. are the AR, Armor, Blur, or any other damage reduction stat. MobLevel is the level of the mob, which I think is 73 at max level since it used to be 63 when the cap was 60. The in game values are based on lvl 70, if I'm not mistaken, because they just use your level for that stat.
0
As for the "10 armor= 1 AR" statement people like to quote on occasion, itis only true if you have 10x the armor as your AR. For wizards, that's nearly impossible since we get AR from our primary stat. Most of us are probably floating around the 6:1 ratio. For example, based on my torrent farming gear stats, 1 AR gives me 2933 EHP. 10 armor gives me 5311 EHP. That means my 1 AR is worth about 5.5 Armor. To give another example, that means an armor roll of 400 on a piece of gear gives me about the same EHP gain as a roll of 72 AR, which is why I prefer an AR roll on most pieces.
0
That depends on your actual values of AR and armor. For me, 1 AR is worth about 5.44 armor, and I don't use EA. If you use Energy Armor or crystalize, it swings a bit more in favor of Armor. That's also part of the reason I use my spreadsheet. I also go for armor on chest and pants for the same reason.
Higher AR and armor definitely does wonders for your life replenishment. That's the purpose of damage mitigation: sustainability. The purpose of life/vit is to live through burst damage and give a bit of a cushion depending on the sustained damage.
The reason I say vit is overrated is because once you have enough total EHP to survive a couple large hits from whatever you want to survive, extra vit likely won't help much at all. Also, if you don't have much Armor or AR, you'll take damage faster than you can replenish it, meaning you either have to kite (and lose edps) or you die more often, resulting in slower play.
In the end, as Bagstone said, it's about balance, and everyone will have their own balance. I happen to prefer around 200k hp and then as much AR and armor as I can get. For higher torment I wouldn't want to go much higher anyway, because it will make replenishing it a pain.
0
Regarding your questions:
1) The legacy affix is "Adds +x% [elemental] damage" like on the SoJ in my profile. The new +Elemental Damage% affix says "[Elemental] skills deal x% more damage"
The spreadsheet is only meant to track one skill of one element. If you want to compare different gear sets or look how your damage is different for a different element and/or skill, you'd have to utilize the gear comparison tab, or can use multiple copies of the spreadsheet. Including functionality for multiple skills or elements will mostly overcomplicate the spreadsheet.
2) Conflag is one of several buffs I haven't gotten around to adding to the spreadsheet. The simple fix for now is to simply add 6% crit to one of your items to see the relative gain.
3) The spreadsheet is meant to mainly be used to compare items in a simple manner, like switching an elemental item for a non elemental, CD vs CC, and things like that. It is not meant to compute your total effective dps, since those calculations tend to be fairly complex, especially when combined with some of the new legendary procs. The spreadsheet can help compare weapons since it can show an effective dps for each, but you'll have to account for the approximate value of the proc yourself.
0
Like a lot of others on the official forums, I tend to think vit and life% are overrated for most people.