dodge-parry ratio

Warning: Theorycraft inside.

Moderators: Fridmarr, Worldie, Aergis, theckhd

dodge-parry ratio

Postby Shinigamix » Wed Feb 16, 2011 3:58 pm

Hi,
I've been searching for a macro, link, formula or something else about dodge parry ratio.
or should we just stack both equally?

thx in advance, shini
Shinigamix
 
Posts: 1
Joined: Wed Oct 27, 2010 3:44 am

Re: dodge-parry ratio

Postby lythac » Wed Feb 16, 2011 4:30 pm

At current avoidance levels Parry should be (roughly) 1% higher than dodge on your char sheet after raid buffs.
Ryshad / Lythac of <Heretic> Nagrand-EU
User avatar
lythac
Moderator
 
Posts: 2687
Joined: Wed Sep 24, 2008 8:10 am

Re: dodge-parry ratio

Postby Marblehead » Wed Feb 16, 2011 6:46 pm

During WotLK, I have found (probably here in MTadin) a spreadsheet that could be used to calculate the diminishing returns of avoidance stats. Since I really liked it, I modified it to work for Cata too. You can download the spreadsheet here. All you have to do is insert your unbuffed stats and it will spit out all kinds of numbers. What you want is for the numbers in "Lost to DR" cells for dodge and parry to be equal.

Credits for this go to the guy who originally created this during WotLK (unfortunately I don't remember his name) and Theckhd, since all the formulas used are either from the Matlab code or his Armor/Mastery derivation.


Edit: I don't know if there are any compatibility problems with different Excel versions. If so, poke me and I'll try to do something about it.
Image
Life is not difficult, people are.
User avatar
Marblehead
 
Posts: 202
Joined: Sun Aug 02, 2009 9:28 pm
Location: Bloodhoof (EU)

Re: dodge-parry ratio

Postby Galo » Thu Feb 17, 2011 4:20 pm

I'm getting some calculation errors (using Excel 2007)
Galo
 
Posts: 26
Joined: Tue Aug 28, 2007 5:19 am

Re: dodge-parry ratio

Postby Marblehead » Thu Feb 17, 2011 4:36 pm

Ok then, either try using this one or go to the copy I have in googledocs and try to download it from there.
Image
Life is not difficult, people are.
User avatar
Marblehead
 
Posts: 202
Joined: Sun Aug 02, 2009 9:28 pm
Location: Bloodhoof (EU)

Re: dodge-parry ratio

Postby d503 » Thu Feb 17, 2011 5:24 pm

Marblehead wrote:Ok then, either try using this one or go to the copy I have in googledocs and try to download it from there.


Can you make a version of the GDoc that's Save As...-able so we can just use the cloud document?
User avatar
d503
 
Posts: 574
Joined: Fri Jul 04, 2008 12:31 pm
Location: Northern California, US

Re: dodge-parry ratio

Postby Marblehead » Thu Feb 17, 2011 5:51 pm

d503 wrote:
Marblehead wrote:Ok then, either try using this one or go to the copy I have in googledocs and try to download it from there.


Can you make a version of the GDoc that's Save As...-able so we can just use the cloud document?

What I wanted to do is to protect the formulas and only allow specific cells to be editable by everyone, but I don't know if it's possible in googledocs. Anyway, I unlocked the spreadsheet. If someone breaks it by mistake, I'll upload it again.
Image
Life is not difficult, people are.
User avatar
Marblehead
 
Posts: 202
Joined: Sun Aug 02, 2009 9:28 pm
Location: Bloodhoof (EU)

Re: dodge-parry ratio

Postby rodos » Thu Feb 17, 2011 7:07 pm

Marblehead wrote:
d503 wrote:
Marblehead wrote:Ok then, either try using this one or go to the copy I have in googledocs and try to download it from there.


Can you make a version of the GDoc that's Save As...-able so we can just use the cloud document?

What I wanted to do is to protect the formulas and only allow specific cells to be editable by everyone, but I don't know if it's possible in googledocs. Anyway, I unlocked the spreadsheet. If someone breaks it by mistake, I'll upload it again.

This is a really annoying thing with Google Docs. AFACT you used to be able to duplicate a read-only spreadsheet, but you can't any more. I think you can protect a sheet, but not a cell range, so if you move all your formulas to another sheet and leave one open for input it's slightly better (but more annoying to use).
User avatar
rodos
 
Posts: 1120
Joined: Mon Sep 24, 2007 8:20 pm

Re: dodge-parry ratio

Postby mtgeekman » Fri Feb 18, 2011 3:06 pm

Marblehead wrote:Ok then, either try using this one or go to the copy I have in googledocs and try to download it from there.



Can I recommend adding Block Rating somewhere? I use the +40 block on my shield and it adds .45% block chance.

88.3594 block rating = 1%

Been trying to get the numbers on the spread sheet to line up with whats on my armory page and finally realized that it doesn't take that into account.
mtgeekman
 
Posts: 2
Joined: Wed Feb 09, 2011 1:37 pm

Re: dodge-parry ratio

Postby Marblehead » Fri Feb 18, 2011 3:31 pm

I have completely forgotten about the block enchant. I didn't add a block rating field, since the only thing with block rating is the enchant, so I just add a Yes/No field in the buff section. It should be fine now.
Image
Life is not difficult, people are.
User avatar
Marblehead
 
Posts: 202
Joined: Sun Aug 02, 2009 9:28 pm
Location: Bloodhoof (EU)

Re: dodge-parry ratio

Postby mtgeekman » Fri Feb 18, 2011 4:40 pm

Well, I was sure trying to over complicate that...

Thanks!

also, I cleaned up the DIV by 0 errors on the Google docs sheet, and a few things that I'm not sure if I screwed up or not. The Change in Stat for Mastery, Parry, and Dodge were not pointing to anything, just had 0 in them. and the Validation for the Block enchant was pointing to the range for the food buff.
mtgeekman
 
Posts: 2
Joined: Wed Feb 09, 2011 1:37 pm

Re: dodge-parry ratio

Postby PsiVen » Sat Feb 19, 2011 9:49 am

The ideal ratio is actually slightly more parry rating than dodge, assuming you have Windwalk. I'd like to see what exactly that number is, but I'm guessing it's ~70 and impossible to hit for most reforging setups.
Gladiator Psiven, Retired Tankadin
WoW-sober since March 2014
Longtime addict of Space - Glory Through Conquest
User avatar
PsiVen
Moderator
 
Posts: 4364
Joined: Fri Jun 01, 2007 5:28 pm
Location: On a Boat

Re: dodge-parry ratio

Postby inthedrops » Sat Feb 19, 2011 1:39 pm

PsiVen wrote:The ideal ratio is actually slightly more parry rating than dodge, assuming you have Windwalk. I'd like to see what exactly that number is, but I'm guessing it's ~70 and impossible to hit for most reforging setups.


With all the strength on our gear, and the amount of gear also including parry, I find it impossible to reach the ideal dodge/parry values these days and more or less gave up. I suppose different rings or something might help but with my current gear it's not possible. And yes, this is after reforging where possible/sensible from parry to dodge.
inthedrops
Maintankadonor
 
Posts: 1281
Joined: Mon Oct 29, 2007 9:19 am

Re: dodge-parry ratio

Postby vexryn » Sun Feb 20, 2011 8:37 am

lythac wrote:At current avoidance levels Parry should be (roughly) 1% higher than dodge on your char sheet after raid buffs.


Can someone point me to where this was theorycrafted? Maybe I'm blind, but I can't find any stickies on it or see it in the MATLAB thread.
vexryn
Maintankadonor
 
Posts: 157
Joined: Tue Oct 28, 2008 3:12 pm

Re: dodge-parry ratio

Postby theckhd » Sun Feb 20, 2011 9:06 am

The DR ratios for dodge and parry are the same, but you get 5% base parry and only ~3.9% base dodge. Hence, to keep DR balanced, parry should be about 1% higher.
"Theck, Bringer of Numbers and Pounding Headaches," courtesy of Grehn|Skipjack.
MATLAB 5.x, Simcraft 6.x, Call to Arms 6.0, Talent Spec & Glyph Guide 5.x, Blog: Sacred Duty
User avatar
theckhd
Moderator
 
Posts: 7984
Joined: Thu Jul 31, 2008 3:06 pm
Location: Harrisburg, PA

Next

Return to Advanced Theorycraft and Calculations

Who is online

Users browsing this forum: Bing [Bot] and 1 guest

Who is online

In total there are 2 users online :: 1 registered, 0 hidden and 1 guest (based on users active over the past 5 minutes)
Most users ever online was 380 on Tue Oct 14, 2008 6:28 pm

Users browsing this forum: Bing [Bot] and 1 guest