Complete Protection Warrior DPS/TPS spreadsheet

This thread is purely for the development of the Protection Warrior spreadsheet and the baseline conclusion from the numbers produced. Please keep any discussions about specific gear and encounters in their respective threads. And ofcourse, feel free to add or link to this thread.

Why a spreadsheet and why now?
After the 3.2 changes with Devastate and its Glyph, a lot of people, including myself, considered using Devastate more prominently in their cycle/rotation to get an increase in TPS and/or DPS. Due to some errors and the already extensive lengths of the posts in the earlier Devastate Glyph math thread I set out to make a spreadsheet to do all the math for me in a more structured overview.

What does this spreadsheet do?
Once you fill out the yellow cells, the spreadsheet calculates average damage, threat, rage efficiency per ability, your cycle/rotation TPS and DPS as well as some numbers on damage intake. Basicly all the stuff you would want to know once you want to compare gear without having to get raid group together. As of version 1.05+ it also calculates defensive stats.

What does this spreadsheet NOT do?
Tell you what to do. If you totally don’t have a clue how to maximize threat/DPS, you should either reroll to Super Mario, or wait for someone to do the work for you and post it here for everyone to read. There is a basic guide in the next post, but it assumes youre already aware of basic rotations and ability usage.

Special Thanks to:
Rashor, for starting me off with his personal spreadsheet, as well as checking all my math and formulas before I posted them here.
Also a lot of other people from the old Devastate threat to point out my errors in a constructive manner.
My guild, for making me feel like the geek I probably am.

Small Warning: I use OpenOffice.org for spreadsheets, which I then convert to .xls format to upload it. This could possibly give problems in future versions when certain code is incompatible with Excel. Unfortunately, I can’t do anything about that unless someone is willing to buy me an MS Office package. Starting V1.05, all zip packages include both .ods and .xls versions.

Prot Warrior Spreadsheet V1.10.zip

Source: http://www.tankspot.com/

Incoming search terms for the article:

Facebook Twitter Digg Delicious Reddit

Related Articles:

Protection Warrior Tanking Guide

This guide is meant to be more of a “nexus” for information, rather than a compendium of all tanking information. Most of what I’m saying has been posted on Tankspot for a while,...

DK Cataclysm Tanking FAQ

1) How do I spec to tank? In Cataclysm, Blizzard has been kind enough to provide us with a single tree that is dedicated to tanking – Blood. That is what you will be picking and...

Patch 4.0.1 Glyph System Guide

Glyphs are spell and ability enhancements created by scribes. Until used, they are not soulbound and can be traded or sold. The colors used in Glyphs are colors of the class for which they are...

Warrior Tank Guide

A tank is a character whose primary role is to absorb damage and prevent others from being attacked. Tanks are “meatshields”, so to speak, putting themselves between the mobs and the more vulnerable...

WotLK

Warrior Builds Guide

Warriors have the choice of three talent trees: Arms, Fury, and Protection. Arms is known for Mortal Strike and Bladestorm which makes it popular for PvP, along with Juggernaut, which enables you to use charge while...

Fjola Lightbane

Fjola Lightbane

Fjola Lightbane is one of the Twin Val’kyr, high lieutenants of the Lich King, captured by the Argent Crusade. She and Eydis serve as the fourth encounter in the Trial of the...

Cataclysm Balance Druid Guide

Cataclysm Balance Druid Guide

This is a compendium of information on raiding as a Balance Druid. It contains everything a beginner needs to achieve basic competence at raid DPS, as well more detailed discussion for people more...

Guide to Leveling a Priest

This guide is not a definite, be all and end all manifesto of any particular priest levelling spec. This guide does not place X spec above Y spec because of Z reason, rather...