'Complete' Protection Warrior 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 when 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 you are 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.