Elitist Jerks
Register
Blogs
Forums


Go Back   Elitist Jerks » Class Mechanics » Shamans

Closed Thread
 
LinkBack Thread Tools
Old 08/26/10, 4:45 AM   #91
Xijan
Glass Joe
 
Xijan's Avatar
 
Tauren Shaman
 
Destromath (EU)
Hello EJ community,

I just wanted to be sure if this are the right macros to evaluate my crit + raidbuffs and the crit cap

I have this as Macro

/script DEFAULT_CHAT_FRAME:AddMessage("Crit:"..(((UnitStat("player", 2)+178+52)*.1+178+52)/83.33+3+5+9+GetCritChance()-4.8))
/script DEFAULT_CHAT_FRAME:AddMessage("Critcap:"..100-(27-(GetCombatRatingBonus(6)+6))-(24))

is that right?


and as well as many others these 4,8% are bothering me i dont get how this realy works. Does it mean that my crit can be 4,8% above my crit cap and im still not wasting any crit? In other words is my critcap = 100-24-%miss+4,8?

thx for any help and explaining

Last edited by Xijan : 08/26/10 at 5:34 AM.

Offline
Old 10/13/10, 8:36 AM   #92
Aeolian
No.
 
Aeolian's Avatar
 
Iyosin
Troll Druid
 
No WoW Account
To avoid people asking for this to be updated, I messed around with it and it should be accurate for 4.0.1. I won't be uploading a download because the change is very easy.

On the Total Agility line in the Green area, click on the actual number on the right and change the formula to: =(E5+155)*1.05

I removed the 51 Agility from MotW, the extra 23 Agility from the Imp SoE talent and changed the Kings multiplier.

I do not see anything else that needs to changed at the moment.

United States Offline
Old 10/13/10, 10:50 AM   #93
Hothgor
Piston Honda
 
Orc Shaman
 
Stormreaver
Originally Posted by Aeolian View Post
To avoid people asking for this to be updated, I messed around with it and it should be accurate for 4.0.1. I won't be uploading a download because the change is very easy.

On the Total Agility line in the Green area, click on the actual number on the right and change the formula to: =(E5+155)*1.05

I removed the 51 Agility from MotW, the extra 23 Agility from the Imp SoE talent and changed the Kings multiplier.

I do not see anything else that needs to changed at the moment.
A couple of other changes need to be made as well.
  • For the Total Agi after buffs, you need to change the formula to =(E5+155)*1.05
  • For the SoE+MotW+Kings Crit, you need to divide by 83.19 instead of 83.33.
  • For the Chance to miss, you need to change the formula from its 32.79 hit value to 30.7548
  • For Fully Buffed Crit, you have to change plus 17 to plus 14 to reflect the new raid buffs.
  • For Hit rating needed to reach crit cap, you have to also change the 32.79 value to 30.7548.

I THINK that is all of the changes needed for our purposes.

Last edited by Hothgor : 10/13/10 at 11:18 AM.

Offline
Old 10/13/10, 11:09 AM   #94
Aeolian
No.
 
Aeolian's Avatar
 
Iyosin
Troll Druid
 
No WoW Account
Originally Posted by Hothgor View Post
  • For the Total Agi after buffs, you need to change the formula to (EF+155)*1.05
What does this represent? Because as it's written it can't be used in the formula for a spreadsheet. I have a feeling I am missing something obvious.

United States Offline
Old 10/13/10, 11:19 AM   #95
Hothgor
Piston Honda
 
Orc Shaman
 
Stormreaver
Originally Posted by Aeolian View Post
What does this represent? Because as it's written it can't be used in the formula for a spreadsheet. I have a feeling I am missing something obvious.
Fixed. I should copy instead of write it out manually more often :P

Offline
Old 10/14/10, 12:16 AM   #96
ziff
Piston Honda
 
Orc Shaman
 
Feathermoon
There is one other fixup needed. There is a cell doing the dodge calculation based on expertise in cell I13 that should be =6.5-(0.25*((E8/7.68869)+(3*G5)+8)). A little more verbose than before, but should be obvious what the calculation is doing.

Offline
Old 10/16/10, 11:01 AM   #97
Aphex242
Glass Joe
 
Draenei Shaman
 
Blackhand
Ziff just a note - for players even 1 point over expertise cap that creates a negative chance to be dodged, which throws everything else off slightly. I'm sure there's a max command or something in excel but I'm not aware of it.

This is easily fixed by just throwing a zero in chance to be dodged, but that's less than elegant.

Offline
Old 10/17/10, 5:22 AM   #98
ziff
Piston Honda
 
Orc Shaman
 
Feathermoon
I think that's already handled in the spreadsheet. If you look at cell E9 it's listed as =IF(I13>0,I13,0). So the spreadsheet should already be handling the negative case. That's I think why they did the two cell trick to calculate the dodge chance.

Offline
Old 10/18/10, 2:55 AM   #99
Skulmaster
Von Kaiser
 
Draenei Shaman
 
Burning Blade (EU)
Originally Posted by Hothgor View Post
A couple of other changes need to be made as well.
  • For the Total Agi after buffs, you need to change the formula to =(E5+155)*1.05
  • For the SoE+MotW+Kings Crit, you need to divide by 83.19 instead of 83.33.
  • For the Chance to miss, you need to change the formula from its 32.79 hit value to 30.7548
  • For Fully Buffed Crit, you have to change plus 17 to plus 14 to reflect the new raid buffs.
  • For Hit rating needed to reach crit cap, you have to also change the 32.79 value to 30.7548.

I THINK that is all of the changes needed for our purposes.
Not sure if it's intentional, but the Leatherworking drums, drums of Forgotten Kings give a +4% stats boost that seems to stack on top of the 5% that MotW provide. But MotW need to be cast first and drums need to be cast after, or MotW will overwrite the drums. Not sure if BoK and Drums stack, haven't tested that yet, but MotW and drums do.

So
->[*]For the Total Agi after buffs, you need to change the formula to =(E5+155)*1.09

Last edited by Skulmaster : 10/18/10 at 3:04 AM. Reason: typo

Offline
Old 10/18/10, 4:58 AM   #100
SentinelBorg
Don Flamenco
 
SentinelBorg's Avatar
 
Tauren Shaman
 
Blackrock (EU)
Originally Posted by Skulmaster View Post
Not sure if it's intentional, but the Leatherworking drums, drums of Forgotten Kings give a +4% stats boost that seems to stack on top of the 5% that MotW provide. But MotW need to be cast first and drums need to be cast after, or MotW will overwrite the drums. Not sure if BoK and Drums stack, haven't tested that yet, but MotW and drums do.

So
->[*]For the Total Agi after buffs, you need to change the formula to =(E5+155)*1.09
That is clearly a bug that will be fixed soon. I don't think we should change the formula because of that.

Germany Offline
Old 10/31/10, 7:48 PM   #101
Tsukihime
Glass Joe
 
Tsukihime's Avatar
 
Draenei Shaman
 
Drek'Thar (EU)
Hi there.

Looking at the .xml file. I may be wrong, or maybe I didn't understood anything, but here is what I saw.
On the file, 20 agility give 0.02% crit. Yet, in the game, 20 agility give 0.25% crit.

Is there anything I didn't got right?

Offline
Old 11/01/10, 5:02 AM   #102
Sidira
Glass Joe
 
Orc Shaman
 
Destromath
Originally Posted by ziff View Post
There is one other fixup needed. There is a cell doing the dodge calculation based on expertise in cell I13 that should be =6.5-(0.25*((E8/7.68869)+(3*G5)+8)). A little more verbose than before, but should be obvious what the calculation is doing.
Is this fix calculating the exp cap at the 26 cap or the post-4.0 23('ish) cap? I assume the former because when I enter in my exp with the fix it's still giving me a .85 chance to doge.

Offline
Old 11/01/10, 5:22 AM   #103
ziff
Piston Honda
 
Orc Shaman
 
Feathermoon
Originally Posted by Sidira View Post
Is this fix calculating the exp cap at the 26 cap or the post-4.0 23('ish) cap? I assume the former because when I enter in my exp with the fix it's still giving me a .85 chance to doge.
This formula is for a boss with a 6.5% dodge chance. Since it looks like lvl 83 bosses have a 5.625% chance to dodge, you can just replace the number in that formula to update it for 4.0.1.

Offline
Old 11/14/10, 12:59 AM   #104
Tsukihime
Glass Joe
 
Tsukihime's Avatar
 
Draenei Shaman
 
Drek'Thar (EU)
Crit Cap

Okey, here is my crit cap analysis...



I'm a bit surprised. I have 584 hit score, it tell me I should take off 535. So, 49 would be left. Nuts a bit.
I know that if I change hit to crit, all that values will change as well of course.

I don't know what is best. Having hard hit cap and try to reach crit cap?
Loosing hit to reach crit cap?
Heard haste was better, but useless if we miss no?

If someone is able to help me, would be great.

Offline
Closed Thread

Go Back   Elitist Jerks » Class Mechanics » Shamans

Thread Tools

Similar Threads
Thread Thread Starter Forum Replies Last Post
Critical damage multiplier Dirich Public Discussion 1 11/28/07 1:17 PM
Damage Increase Per Critical Strike bloodurst Class Mechanics 7 06/29/07 11:01 AM
Blocked critical attacks possible? polocabbit Public Discussion 29 09/06/06 11:50 AM
Critical Threat and Off-hand Weapon Speed Krag Public Discussion 9 03/09/06 7:35 AM