Elitist Jerks
Register
Blogs
Forums


Go Back   Elitist Jerks » Warriors

Closed Thread
 
LinkBack Thread Tools
Old 11/12/09, 5:11 PM   #2001
landsoul
Myrmidon Champion
 
landsoul's Avatar
 
Worgen Warrior
 
Alterac Mountains
Originally Posted by Shha View Post

Only test to really matter i think is : Assuming increase in ICC gear to easily geyt us to higher ARP then toc, will it be better to have

400 STR + Scorpion

or

400 ArP + Deaths Verdict (245)

Again - if you are low enough on GEAR ArP so that mjolnir is fully utilized, then its clearly better. But it might not be the case in ICC.
Scorpion already loses to Runestone in all situations hands down, so this argument is moot in the first place. Once you get passed the point where DV is better than Runestone from the opportunity of passive penetration, then Scorption is then out of the question. ~900 ArP + 245 DV barely edges out of 735 ArP + Runestone setup in the first place from what we have seen in TOC.

Also, what's the proc chance on connect of the Axe's thing? 10%?

Last edited by landsoul : 11/12/09 at 5:16 PM.

>--Coaching Site--< Private coaching / Warrior Resource
>--Stream--< Tues, Wed, 7 Eastern.

Offline
Old 11/13/09, 6:05 AM   #2002
Jambo354
Glass Joe
 
Orc Warrior
 
Zenedar (EU)
Page: LOOKUP
Error Type: TYPO
[Darkmaw Crossbow] - showing 43 agility instead of 35

Page: FURY(?)
Error Type: ?
[Legplates of Ascension] - The yellow socket is bugged. I can't activate the socket bonus unless I gem the yellow socket with Nightmare Tear.

Offline
Old 11/13/09, 12:48 PM   #2003
suffer
Von Kaiser
 
Tauren Warrior
 
Eredar
Originally Posted by Grayson Carlyle View Post
As for the weapon speed, load up the spreadsheet and lower the speed of DBB/JB by .1 and see what actually happens for Fury.

The fact that it's 3.4 hurts Arms but helps Fury, and not by a lot in either case. It's the Rets and DKs who will be crying, as .1 DPS for them is several hundred SEP.
Could you please explain this, I don't believe it. I have a hunch that you lowered the swing speed but didn't adjust the low-end and top-end damage to compensate, thus generating a weapon with a higher DPS in the process.

I thought slower weapon speed benefits fury warriors due to WW.

Offline
Old 11/13/09, 1:08 PM   #2004
Grayson Carlyle
Take what ye can;
 
Grayson Carlyle's Avatar
 
Tauren Warrior
 
Turalyon
Originally Posted by suffer View Post
Could you please explain this, I don't believe it. I have a hunch that you lowered the swing speed but didn't adjust the low-end and top-end damage to compensate, thus generating a weapon with a higher DPS in the process.
You are entirely correct. I saw the SEP for .1 speed as -0.2, and wondered how that came to be. I changed the weapon speed myself and saw that it did in fact lower overall DPS, not realizing that it decreased the DPS on the weapon because DPS isn't a stored value.

Canada Offline
Old 11/16/09, 6:44 PM   #2005
Reeno
Glass Joe
 
Human Warrior
 
Defias Brotherhood (EU)
[Edit] - Post removed as its content is now invalid

Last edited by Reeno : 11/17/09 at 8:13 PM.

Offline
Old 11/17/09, 3:39 AM   #2006
Aracross
Glass Joe
 
Aracross's Avatar
 
Human Warrior
 
Exodar (EU)
Windows 7 problem

Does anyone else have problems reading this and older versions in Windows 7?
I'm unable to run it, because it says "file is corrupt", and fixing it destroy the macros. I've been using it perfectly in XP and Vista (both x64).

Thanks for any help in the matter.

Offline
Old 11/17/09, 8:11 PM   #2007
Reeno
Glass Joe
 
Human Warrior
 
Defias Brotherhood (EU)
Another update on Needle-Encrusted Scorpion - Items - Sigrie Look's pretty much finalized now with its new proc value of 678, that along with the extra 12 crit rating accounts for the 6 ilv increase from Mjolnir. Its safe to also assume the internal CD has been revised back to the traditional 45 seconds.

The only downside I can see to this now is the fact you still need to land a critical strike to proc it so unless the proc % is high that mechanic may damage its viability as its still only a minor upgrade from Mjolnir assuming their procs have identical uptime.

Offline
Old 11/17/09, 9:21 PM   #2008
Yazuka
Glass Joe
 
Orc Warrior
 
Xavius (EU)
So Shadow's Edge got datamined yesterday and putting in the stats it comes out as a 173 DPS increase over Dual-Blade Butcher.

Stat comparison over DBB:

.1 Speed decrease
61-92 Weapon Damage increase
13 DPS increase
27 Strength increase
11 Stamina increase
Red Socket instead of Blue Socket so +6 strength
2 Crit and 2 Armor Pen loss

The proc for shadowmourne also got changed to become a 40 strength stacking proc for 10 stacks and a 2k damage meaning 400 strength for however long the proc is making that a very nice proc when you upgrade the weapon.

If we go by adding straight 40 strength to the spreadsheet it comes out as a 93 DPS upgrade for me. 400 Strength closing in on close to 1k and the 2k damage is also a small damage increase. Assuming with 2 second attack speed and 50% chance to proc it'd take about 20 seconds from just white hits assuming no missing or dodges and guessing 10 second proc uptime with 30-45 second icd, making the proc alone a very nice change compared to the old 7k hit.

Last edited by Yazuka : 11/17/09 at 9:52 PM.

Offline
Old 11/18/09, 6:39 AM   #2009
landsoul
Myrmidon Champion
 
landsoul's Avatar
 
Worgen Warrior
 
Alterac Mountains
Well it looks like we're going to be able to hit all 4 hard caps (expertise, hit, armor pen, and crit) as fury with only the 277 set and the 264 gear. Too bad our set bonuses aren't too great compared to other classes.

>--Coaching Site--< Private coaching / Warrior Resource
>--Stream--< Tues, Wed, 7 Eastern.

Offline
Old 11/18/09, 8:31 AM   #2010
Yazuka
Glass Joe
 
Orc Warrior
 
Xavius (EU)
If only they changed bloodsurge to work like sudden doom then the 4 piece would be extremly nice.

Offline
Old 11/18/09, 9:01 AM   #2011
Reeno
Glass Joe
 
Human Warrior
 
Defias Brotherhood (EU)
At least now we have 3 BiS tier peices from the 277 set (ArP pieces) and the 4th one can be decided once we see which offset pieces with hit & expertise qualify as BiS. One major flaw in the 4-pieces set bonus is why blizzard still havnt granted slam the ability to come off GCD when bloodsurge procs. While reducing the GCD by 2/3 and doubling the buff duration, by not allowing the buff to accumilate past 2 from the set bonus and still being restricted by the GCD were still going to find situations where we hold off to use higher priority abilties and in turn these may trigger wasted bloodsurge procs.

Offline
Old 11/18/09, 9:09 AM   #2012
Guyfromlv
Glass Joe
 
Human Warrior
 
Aszune (EU)
Originally Posted by landsoul View Post
Also, I am looking to do something new in terms of formatting maybe a new backdrop texture, intro page background, new functionality something. Let me know what you want or give me your suggestions.
DPS/SEP values for Set Bonuses.

Offline
Old 11/18/09, 1:28 PM   #2013
PsychoKodiac
Glass Joe
 
Tauren Warrior
 
Maelstrom
I had a question about the ArP values between battle stance/ 2 piece T9 and straight ArP from gear stats.

Is it a straight forward addition to determine the % of ArP value you have? If tool tip says 60% ArP can I just add another 16% for 76% ArP to the tool tip value to get my final amount from stance + T9 bonus?

I've been looking at the % given in the spread sheet and I believe it says I should be in the neighborhood of ~90% ArP but looking at my tool tip and adding in my stance plus T9 only gives me a value of roughly in the ~85%

The World of Warcraft Armory

If anyone can give me a heads up on what I need to do to determine my actual % it would be appreciated.

Offline
Old 11/18/09, 3:37 PM   #2014
Bonquida
Glass Joe
 
Draenei Shaman
 
Khaz Modan
I've seen a lot of questions about how to download the spreadsheet from filefront and no answers. I am wanting to get this for my warrior, is there any other source for the download? I have tried to download this file probably 15 times now and it gets to roughly 500 kb and stops the download.

Anyone have a clue? I am clicking "save" not just "open".

Offline
Old 11/18/09, 4:48 PM   #2015
landsoul
Myrmidon Champion
 
landsoul's Avatar
 
Worgen Warrior
 
Alterac Mountains
In all honesty I don't see why we won't be able to make all 5 pieces work unless there are better leather or mail equivalents. There's only hit and expertise on one piece each and we still need those to cap out on avoidance.

Also, the problem with SEP for bonuses is implementation. You can't split them evenly across each item, because you only need 4 out of 5 and 2 out of 5 and there are many combinations of choosing what to wear for those bonii. If you chose to wear all 5 pieces, and the bonii were split into 4 across each of the 5 items, there would be an overestimation for the 5th piece, which could be either of the 5. Same thing if you chose to wear 3/5 for the 2 bonus. You can't split the 2 piece DPS across 3 pieces. Which pieces would you give it to? The only way I can think is a button that will allow the finding of change in DPS of the set bonii based on your stats and it being posted somewhere for quick reference on the lookup page.

Also, I still am aware of the demand for the '97 version. I have found a solution to the cell limitation problem for '97, but it involves formatting the lookup page a different way to be able to fit more columns per item before reaching the column limit for '97, effectively splitting up the DPS, SEP, and DPS diff column into three different columns. This will allow cross-compatibility of the same spreadsheet release across both excel platforms.

Also, please don't forget that I am always accepting donations as updating this massive spreadsheet on time and making it better with each rendition requires a lot of hard work and time spent. Check the first post on how to do so in case you don't know already.

Last edited by landsoul : 11/18/09 at 5:04 PM.

>--Coaching Site--< Private coaching / Warrior Resource
>--Stream--< Tues, Wed, 7 Eastern.

Offline
Old 11/18/09, 6:28 PM   #2016
Glokki
Glass Joe
 
Glokki's Avatar
 
Orc Warrior
 
Frostmourne
Originally Posted by PsychoKodiac View Post
If tool tip says 60% ArP can I just add another 16% for 76% ArP to the tool tip value to get my final amount from stance + T9 bonus?
Yes this is correct

Australia Offline
Old 11/19/09, 6:53 AM   #2017
ZeTodu
Von Kaiser
 
Human Warrior
 
Neptulon (EU)
Landsoul - can you please put Shadowmourne - Items - Sigrie in to sheet?

Offline
Old 11/19/09, 7:11 AM   #2018
Yazuka
Glass Joe
 
Orc Warrior
 
Xavius (EU)
You can easily add it with the current build and the proc can be measured by adding 40 strength per stack the 2k damage i cant measure however as proc rate and how there applied is unkown.

Offline
Old 11/19/09, 8:50 AM   #2019
Whorane
Glass Joe
 
Human Warrior
 
Tichondrius
Page: Arms
Error Type: Typo
The agility enchant on boots is broken, it says 20 agility, the actual enchant is 16 agility, and the 20 agility enchant in the spreadsheet even seem to give more than 20 agility (however I'm not sure about this part because I can't figure out how to see unbuffed attributes).

Offline
Old 11/19/09, 2:24 PM   #2020
Lotuseyes
Glass Joe
 
Human Warrior
 
Moonrunner
For those without Excel

To anyone who would like to use the spreadsheet, but is unable to due to lack of software; Microsoft has made the beta test of Office 2010 available to the public. You can get it here. I have tried it, and so far everything works (SEP, Armory import, DPS).

Offline
Old 11/19/09, 3:26 PM   #2021
landsoul
Myrmidon Champion
 
landsoul's Avatar
 
Worgen Warrior
 
Alterac Mountains
Excel 2010

"Microsoft Excel Web App. Edit documents in a Web browser when you’re away from your office, home, or school without compromising the quality of your viewing experience."

"Co-authoring through the Microsoft Excel Web App makes it possible for you to edit the same spreadsheet with others simultaneously from different locations. You can see who’s working on a spreadsheet with you at the same time. All modifications are instantly shown and flagged so you can see where others are editing and who those editors are."

Interesting. I will be most excited about the Web App. I won't have to be on my home machine to make modifications. Also others with 2010 can apparently log into the web app and view the spreadsheet online.

>--Coaching Site--< Private coaching / Warrior Resource
>--Stream--< Tues, Wed, 7 Eastern.

Offline
Old 11/19/09, 5:15 PM   #2022
Bonquida
Glass Joe
 
Draenei Shaman
 
Khaz Modan
I have noticed that weapon speed values in the fury dps spreadsheet are not adjusted by the user's chosen increment. This means that a change of .1 weapon speed is always used no matter how huge of increases your other stats are getting. So even if you use a large increment where each stat affects your dps by a huge amount your weapon speed is still having the same piddly effect.

In effect, doubling your increment divides the effect of weapon speed by two. All you have to do to fix this is to multiply cells C102 and C104 (the weapon speed cells) by D26 (the increment cell).

Also, is there any way we can calculate weapon damage in SEP? Higher item level items will have higher weapon dps, which is definitely good, but the item might still not be an upgrade if it isn't itemized quite right. It'd be nice to check.

TY for all the hard work.

Offline
Old 11/19/09, 10:26 PM   #2023
landsoul
Myrmidon Champion
 
landsoul's Avatar
 
Worgen Warrior
 
Alterac Mountains
That's already there but the weapon speed SEP has been bugged as you said with higher (other than 1) increments. The fix is listed on the errors section on the front page.

>--Coaching Site--< Private coaching / Warrior Resource
>--Stream--< Tues, Wed, 7 Eastern.

Offline
Old 11/20/09, 8:51 AM   #2024
markabey
Glass Joe
 
Orc Warrior
 
Frostwhisper (EU)
Landsoul's Horned Greathelm

Landsoul's Horned Greathelm - Items - Sigrie

Gratz Landsoul!

Theres the bit of T10 that you can drop :P
Will make sure to donate after 3.3 sheet release. TBH I find the sheet almost as fun as actually playing wow

Offline
Old 11/20/09, 10:03 AM   #2025
xavier2k3
Von Kaiser
 
Human Warrior
 
Kor'gall (EU)
Not quite sure about dropping that bit of t10 personally as there are other pieces which aren't set pieces that have hit on them. Far too much plate gear found so far having hit/arp or exp/arp most likely to keep crit rates down.

On another note, Congrats landsoul on your item. Recognition for the significant contribution you've made to the warrior community. A much deserved reward.

Offline
Closed Thread

Go Back   Elitist Jerks » Warriors

Thread Tools

Similar Threads
Thread Thread Starter Forum Replies Last Post
Mongoose calculation or simulation? sag_ich_nicht Public Discussion 1 08/05/08 9:59 AM
[Rogue] Backstab damage calculation Karmon Class Mechanics 5 11/04/07 5:22 PM
Range Calculation Nite_Moogle Theorycrafting Think Tank 0 09/21/07 12:02 PM
Ilvl calculation Drauk Public Discussion 9 03/24/06 4:30 PM