Warrior DPS Calculation Spreadsheet - Page 5

yojoe · 12/05/08, 11:40 PM

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 · 12/07/08, 11:07 PM

Originally Posted by landsoul

Never knew that was even in the game. This will be an interesting card to add. Sometimes you will have more agility than strength, because there are good mail and leather items, and also because there is Mongoose in the absence of Berserking. However I do believe that you will be able to choose between 90 STR and 90 Agility. I do see on wowhead that it is a 35% chance proc trigger spell, undoubtedly with a 45 second ICD.

There's a lot of talk on wowhead about this card right now, whether or not you can use the 90 str and 90 agi simultaneously, or even if you could, would the procs stack? That would be pretty rediculously awesome. I'd want to wait until some actual usable data/comments come out with it from the inscriptors after the actual Darkmoon event.

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.

landsoul · 12/08/08, 12:51 AM

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

Azhag · 12/08/08, 9:28 AM

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

well I think this will be included in your huge update

Wolvynskye · 12/08/08, 1:55 PM

Originally Posted by 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.

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 · 12/09/08, 5:27 PM

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 · 12/09/08, 6:16 PM

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 · 12/09/08, 7:28 PM

Current build has berserking uptime worked into total avg armor.

Azhag · 12/10/08, 4:59 AM

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 · 12/10/08, 7:39 AM

Originally Posted by 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)

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 · 12/10/08, 11:28 AM

Originally Posted by Azhag

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

well I think this will be included in your huge update

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 · 12/10/08, 1:08 PM

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 · 12/10/08, 3:07 PM

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

chiznitz · 12/10/08, 3:23 PM

Originally Posted by 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...

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 · 12/11/08, 11:01 AM

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.