Yea, pretty sure. Is that the number thats missing in sheet or directly from your stats? Roundings in the formulas might mess it a bit
Found it, quite close to what I thought of.
Weaponskill above 375. Every point gives 0,04.
1,142+0,16=1,3 exactly what I wanted to find and I did find it, of course, in the Rogue sheet^^.
### 0.6
Fixed small things. Quite usable now.
Attention! I had some errors in my items.
Crit seems to be as good for MS as AP is for Fury. Never thought it would be so much. Brb ordering some Lionseyes . That makes items with sockets very good.
A minor note, but the Draenei race has a hit aura that also affects themselves; in the sheets (yours and previous ones) I've downloaded this has never been included in calculations when they are selected. I think the last version of your sheet I downloaded was 0.3.
You can, of course, input that manually, but I thought I'd run it by you regardless.
So I have several DW Fury Itemrack sets saved and I'm not sure which of them would provide the most raid DPS. I narrowed them down to these 3, been browsing these forums for a while now and would like some other opinions.
These are unbuffed stats.
My weapon skill is 350 and i use the same weapons with both sets. T3 Axe w/ Mongoose and Malchazeen w/ +20 STR
Set 1
2092 AP, 206 hit rating (16.06% w/ Talent), 29.45% Crit w/ Berserker, 38 Haste Rating (3.61%)
Notes: Bloodlust Broach for on use AP.
Set 2
2000 AP, 205 hit rating (16% w/ Talent), 32.49% Crit w/ Berserker, 0 Haste Rating
Notes: Hourglass for AP on proc.
Set 3
1962 AP, 205 hit rating (16% w/ Talent), 33.19% Crit w/ Berserker. 0 Haste Rating
Notes: Hourglass for AP on proc.
Right now I'm using the 3rd set because I like having more Crit to keep flurry up, but I'm thinking that the first one would be better damage if it can keep the flurry up.
I also have a Brutalizer to offhand to get the 3% hit from the 5 Weapon skill, but the difference between that and my current offhand is 99AP and 16 hit.
I also have a lot of gear in the bank to swap around with, generally I try to stay at 205 hit rating and no less, so if I should need more Crit or more AP I can usually swap things around. I don't have the gear though to get like 2100AP and 33% Crit though.
I suggest you download the sheet and put in your gear (or, I guess, put "none" in all slots and input the your stat values in the "manual values" box). Then you can compare these gear sets yourself.
Without running any detailed tests with the sheets it's hard to tell which of these three is the best, my feeling is that nr 1 would be the best one (based on some SEP values I calculated with the old spreadsheet). Haste is a very good stat, better than crit rating definitely (and before haste nerf I think it's almost better than str). The 130 extra AP with nr 1 almost makes up for the loss of 3.7 % crit, with the haste added, nr 1 is a winner. But try to use the spreadsheet yourself, perhaps you'll geta different answer. With ~30% crit selfbuffed you will probably reach 35-40% crit fully buffed, at that level of crit Flurry will be up about 80% of the time, which is quite fine.
About hit, my feeling is that if you have the gear, you can probably trade something like 50 hit rating to get more STR/AP or crit (or even better, haste). If you have any +hit gems, get rid of them and get crit/str gems instead.
Getting 3% hit from the Brutalizer is not worth it, if you loose 99AP/16 hit (assuming that you have more hit than 9%). Again using my old SEP values, from only the addition of +hit form the weapon skill, I estimate that 5 weapon skill is about equivalent to about 30 str.
dr_AllCOM3 - thanks very much for the good work on the spreadsheet, much appreciated.
The Mongoose enchant seems to be undervalued though (comes out much worse than Potency in the configurations I tried for MS and DW Fury), is it correctly modelled?
Would it be possible to put gems in the item sheet aswell?
I've found that some gems aren't available in your sheet, and when I edit them in I get "######" & "#VALUE" errors in the sheet, I tried using the error button but it didn't work either.
Btw, really ace work on the sheet so far, it's working good and the way to input items is quite handy.
The Mongoose enchant seems to be undervalued though (comes out much worse than Potency in the configurations I tried for MS and DW Fury), is it correctly modelled?
Not modelled at all. That's why I have you to test the sheet .
Are these spreadsheets accurate? I was using dr_AllCOM3's latest one, ### 0.6.
According to the spreadsheet, potency is better than mongoose. And also my two-hander build would be greater DPS than my dual wield fury build.
I'm not saying that it is right or wrong. I just thought most of the EJ forum readers agreed that mongoose was better than potency. And that DW fury was better for personal raid dps versus any two-hander build.
Edit: damn, I just noticed a newer version of the spreadsheet was released, 0.8. It fixed the issue with potency versus mongoose, but two-hander dps is still greater than dualwield fury.
Last edited by HeavyTwenty : 09/19/07 at 12:55 PM.
Skill Crit Factor is not calculated correctly. It checks first if there is an Relentless Diamond and if there isn't, it just ignores Impale.
Whoops.
Originally Posted by HeavyTwenty
Edit: damn, I just noticed a newer version of the spreadsheet was released, 0.8. It fixed the issue with potency versus mongoose, but two-hander dps is still greater than dualwield fury.
I noticed that too. You'll never be able to execute Slam perfectly thou.
Reading more than the latest post helps indeed.
### 0.9
Save/Load Talents and DPS. SEP.
Kinda easy once you can copy&paste.
I managed to get the basics working in OpenOffice (no scripts work however, despite the fact that OpenOffice should be able to handle Excel VBA code, not sure what's wrong). If anyone is interested, I did it like this: I first saved both the sheets as .ods files. When you start the DPS spreadsheet you get an error about the script, and the scripting editor opens up. Go into the script editor and just comment out all the commands (put "rem" or " ' " in front of each row) for this script. Save and reopen the sheet (but now you must manually open the ITEMs sheet first otherwise it won't work). You get an error message. but the sheet will work.
However, none of the fancy stuff (save/load configs, AEP/SEP calculations) will work in OpenOffice. Mayeb it's the old version of OOC at work (2.04) that's causing the problem, haven't had time to try it at home.
Some things are not accounted for and that is rage starvation & rampage/BS recasting.
Rampage will not have a 100% uptime. if you want to maximise the slam cycle you should recast BS/Rampage in the 4th instantslot. What is the possiblility this is not possible to cast (ie no crits right before) or being rage starved. how do rampage/bs becing cast instead of a WW affect dps?
And what are the probabilities of being ragestarved and failing a cycle? It happens every now and then and the possibility increases as your weapon get's faster (faster cycles and less rage per hit).
Just some details that might skew the balance and too heavily favour rampage and hasterating and or fast weapons
Anyways great work, your sheet is a great indication what works and what does not.
Nice work and puts my own previous efforts to shame
Noticed something today though, I was adding in a "wish list" set and noted that, with half of the items loaded, I only have +5.3% hit for a 2-hand build.
However, the main page showed 0.00% miss.
I then tried unequipping all the +hit gear to have ZERO +hit and still the same, it shows 0.00% chance to miss.
I had a look at it and the buffed stats page has the correct 9% standard miss rate and a formula in K13 reads
=MAX(S2-P10-S8*IF(S8>5,0.1,0.4),0)
but evaluates to 0% miss. Have I missed something, or has this formula gone wonky?
Rampage is fully integrated. A cycle lasts ~15s and there is a free GCD. That's why I hate 2h Fury, the cycles are too vulnerable.
Rage starvation happens, I can only work with the average. Look into the sheet, I've mage new cycles that take rage starvation into account.
I know there is a free GCD, but have you accounted for the possibility you might not be able to cast it? ie you did not crit so it's posible to cast (you have to crit before you can cast it).
If it was not possible to cast, you will be without rampage when it fades and you will have to wait until next free GCD (~15 sec)
Thanks again for the update AllCOM. Really appreciate you taking the time to work on this, especially adding the SEP chart. But, mine doesn't seem to be working properly. It lists crit at 0.0, hit at -0.4 and armor pen at -.07.
Hey, would it be possible to add an ability to configure the resilience of your target? It would be interesting to see how resilience affects our dps in arena. Obviously not a high-priority feature, but it would be very helpful for those of us who like to pvp as well as raid!
Can someone rehost the sheet somewhere? Rapidshare is telling me there are too many free user downloads and I have to wait 33 minutes :/
To add some content to this post, I picked up [Rod of the Sun King] last night for hardly any DKP - but I'm not sure if it's worth using over S2 weapons even after the 2.2 buff. The proc rate seemed poor from my limited testing, anyone used it ever?
Thanks again for the update AllCOM. Really appreciate you taking the time to work on this, especially adding the SEP chart. But, mine doesn't seem to be working properly. It lists crit at 0.0, hit at -0.4 and armor pen at -.07.
I got something wrong there^^. Plus the sheet doesn't seem to like +1 crit, so I changed it to 10 Str. It clearly gives some better numbers now.
Originally Posted by nubb3y
Hey, would it be possible to add an ability to configure the resilience of your target? It would be interesting to see how resilience affects our dps in arena. Obviously not a high-priority feature, but it would be very helpful for those of us who like to pvp as well as raid!
I don't like to PvP. You have to wear your arena set anyway, go calculate it youself. Isn't that hard.
Originally Posted by Dralmoo
Can someone rehost the sheet somewhere? Rapidshare is telling me there are too many free user downloads and I have to wait 33 minutes :/
To add some content to this post, I picked up [Rod of the Sun King] last night for hardly any DKP - but I'm not sure if it's worth using over S2 weapons even after the 2.2 buff. The proc rate seemed poor from my limited testing, anyone used it ever?
Not while I'm testing (or letting you test).
Just use the sheet for [Rod of the Sun King], don't ask someone else to do it for you .
I don't believe the sheet models the proc effect at all? Or did I miss somewhere to fill that in?
Anyhow I was able to get it from rapdishare from a different network, so apologies for asking for a rehost. And thanks for the great work on updating it.
09/18/07, 4:21 PM
. That makes items with sockets very good.
.
.
Similar Threads
