Anaximander

Yes, Devotion Aura grants you attack power via AttT.

 

RyvenZ

I think the information for these stats would be more useful if, during a respec, you were to strip down and jot all stats down.

Be in Battle Stance when it's done as well. This will provide a standardized base for all races. I can talk to others in my guild/server to see if I can get all this info for the horde races.

I realized after looking at the gnome's stats that were posted that things like zerk stance, vitality & a plethora of other stats modification factors are in effect unless the character is taken down to CORE ability.

Also, doing this will allow the calculations for talents to be individually analyzed and calculated via the spreadsheet.
Maybe even a before and after (naked & all talents reset, then naked & all talents allocated).

Sound good, Landsoul?

 

Webb

In some of the other forums (the casters i've read) they have an "optimum DPS set" of gear currently available. Is it possible for fury warriors to make such a set? Hence, not a "what loot do I need" but the best endgame piece for every slot, or best combination to fulfill the caps and stack the stats?

Or would such a thing defy both forum regulatives and the need for a spreadsheet?

 

• ebs2002

A note about racial expertise: it seems that you want either a 1 or a 0 as the value in this table, but there's no way of knowing that (especially considering it's next to spec activator, which is a 0-5 input value.

You may want to either limit the possible input to 0 or 1, or put some descriptive text here

 

IceBox

Maybe a 0-3-5 selection because Humans only get 3 Exp for Swords/Maces?

 

Graul

How exactly does the sheet determine the DPS from activated trinkets, are you simply averaging out the gains over time? If that's the case, wouldn't it be quite different from simply using a trinket when it's up compared to always using it with Death Wish or is it the same?

 

SquattingCow

Why would my SEP calc at the top be showing an ExP value of 1.0908, but in the 'last calc run', of 8.9422 (obviously i've pressed refresh with the same/similar sets of gear :P)

 

Rallik

The sheet does average over time for both trinkets and Death Wish, and yeah that causes it to underrate DW/2m trinket buff stacking. If you wanted to model it somewhat more accurately on your own, you could multiply the on-use effect of a trinket you stack with DW 100% of the time by ~1.143, which would approximate always having it up during death wish rather than the average of only ~25% of the time on that the sheet will assume. 1.143 is used since 1.05(base assumption with 25% uptime) * 1.143 ~= 1.2(100% concurrent uptime). So, i.e. you'd write in 670*1.143 ~= 766 AP for loatheb's shadow's on-use effect instead. It's certainly not perfect, but it's somewhat more accurate and will increase the value of on-use trinkets relative to random procs by a fair amount, /shrug.

 

Rallik

Ignore the 8.9422, the spreadsheet has to calculate it that way because expertise only comes in chunks, so it gets the DPS gain of reaching the next expertise threshold and divides it by the rating needed rather than just showing the DPS gain of a single point of expertise rating on its own, which would either be... 0 or 8.9422 in your case, depending on whether or not that single point of expertise rating put you over an expertise threshold. That result would be misleading, which is why you just read what the SEP box says instead.

 

SquattingCow

Ahh ok, that makes sense. Thanks

 

yojoe

Hi I'm not very good with excel but is there any way to export the gear you have selected and import it to the new version of the spreadsheat to avoid having to re-add everything again?

 

aylene

As to the proc:

My initial testing shows me that the numbers mentioned before is pretty much spot on. I haven't yet to wait for more than 46 seconds, mostly 45 seconds between procs. It generally also procs pretty much right away when entering combat thus giving it a great chance to proc whenever the inner cooldown is up. Counting you won't always swing the same second the inner cooldown is up the uptime appears to be ~30 %, thus the proc's worth is just below 100 static strength not counting berserker stance, kings and unleashed rage.

Alongside with the passive strength bonus this places it quite ahead of Fury of the Five Flights in terms of raw AP, which was presumed before.

entering godmode since '06

 

• landsoul

I have a huge update coming hopefully by Friday, sorry about the long wait on some things.

Visit my Youtube Channel for an increasing selection of warrior videos, including Undermanning, PvP, and LK Raids:
http://www.youtube.com/user/LandsoulWoW

 

Azhag

I miss the following chest item: [Breastplate of Undeath]

well I think this will be included in your huge update

 

Wolvynskye

I am seeing the same results with the card; proc is guaranteed within the first few seconds of combat, it simply is amazing. Also I am seeing the 45 second ICD.

 

rjb

Did you take into consideration Armed to the Teeth for the Berserking weapon enchant?

It won't cancel out the AP, but it will still take a hit.

Armored to the Teeth (3/3) is 3 additional AP for every 180 armor, and vice versa you will lose 3 AP for every 180 armor lost, or to simplify: 1 AP for every 60 armor lost.

Assuming 12k armor total, the armor lost by the proc will be 3k. 3000/60 = 50 lost AP, so the proc is only worth 350 bonus AP instead of the indicated 400.

Assuming 15k armor, armor lost from the proc will be 3750. 3750/60 = 62.5 AP. so the proc will only be worth 337.5 bonus AP.

Depending on the proc rate of this enchant, it may be more worth it to have a constantly up Massacre enchant or the 25hit/crit rating Accuracy enchant.

Note for DKs with Bladed Armor: this talent is 5 AP for every 180 armor, so this enchant is even less effective than it is for Warriors:

at 12k armor: this proc is worth 318 AP.
at 15k armor: this proc is worth 296 AP.

Also I read that unlike Double Executioner that can proc from both weapons, but it merely refreshes the buff, both weapons proc independently of each other and it is possible to get +800 AP and -50% armor if you dual wield and they both proc.

So could Berkerking MH and OH be the best?

 

Ryo Saeba

I'm very interested about this, I'm about to enchant my 2x Two-Handed weapons with Massacrebut first I want to be sure about Berserking issue.

 

• landsoul

Current build has berserking uptime worked into total avg armor.

Visit my Youtube Channel for an increasing selection of warrior videos, including Undermanning, PvP, and LK Raids:
http://www.youtube.com/user/LandsoulWoW

 

Azhag

Sorry, I still don't really understand how I can add items to the sheet which aren't included (yet). I have read the intro and this thread, but maybe I missed something. Do I have to manually insert the gearstats below "Gearstats Array"? I can't chose <insert> in the item lists and if I want to insert the item name excel says it's invalid. (using the 97 version)

 

Whistles

Go to the Lookup worksheet. Highlight an item and all it's stats in the list and then right click -> Insert -> Shift Cells Down. Then add your item.

 

Cranium

It is possible to add this item in yourself via the lookup sheet. Since it is a blue item, I'm guessing it wouldn't be the highest priority on a spreadsheet on the EJ forums. If you have some questions as to how to add an item though, I'm sure someone here could help you figure it out. :-)

My idea would be to pick an item you will never get or simple do not want from the chest pieces on the list, and type over all of its information if inserting an items fails you.

 

Lord Pendragon

I was a big fan of the OpenOffice spreadsheet in BC, so I thought it was about time to get the new Excel version and start planning out my warrior's gear. However, after inputting all my current gear, the dps calculation has changed to "N/A". Likewise the SEP calculations, after I click on the green button, also all change to "N/A".

Obviously I'm doing something wrong. Could someone enlighten me? I'd love to start using this spreadsheet, but I have a feeling my inexperience with Excel may be getting in the way...

 

Anaximander

I noticed that the "+7 STR & +7 Hit" gem is being treated as STR and Haste. (v2.010beta)

 

chiznitz

I've had this happen to me before as well. One solution although painful is to make a change, when you see your dps # calculate correct press alt+s to save the page. Then make another change. If you end up with the #N/A close the spreadsheet and re-open to the previously saved version. It may be a pain but it got me past my issue.



*Adding New Items* - I find it to be more work to insert a new row. I just take an item that has crap stats and rename it and replace all of the values on the lookup tab. I've add several items this way. I steer clear of items with procs/on use abilities and let that magic up to landsoul.


*Side Note - After patchwerk last night the spreadsheet seems to be a very accurate modeling utility. I did not reach the speadsheets DPS, but I was fairly close. Thanks again for the hard work landsoul

 

Conquistador

Newest patch notes say that the hit cap for TG is going to be removed. Don't know how complicated that is to implement or if you might want to push back your release schedule in light of this, but its something I think should be mentioned.