Elitist Jerks
Register
Blogs
Forums


Go Back   Elitist Jerks » Public Discussion » Class Mechanics

 
 
LinkBack Thread Tools
Old 05/03/07, 4:26 AM   #1
Punscho
Piston Honda
 
Punscho's Avatar
 
Gnome Rogue
 
Ravencrest (EU)
[Warrior] Tanking TPS sheet.

After seeing rather many threads about different parts of warrior tanking and TPS I decided to release my little project. We've seen many DPS sheets but this is a TPS sheet for us walking tin cans. This is where you should look if you are interested in how hit, crit, ap, block value, weapon skill, expertise, buffs, slow/fast weapons, talents, enchants, devastate and so on influence your TPS.

The threatdown! Beta 4

OpenOffice 2.0: Free file hosting by Savefile.com
Excel XP/2000: Free file hosting by Savefile.com
Excel 95: Free file hosting by Savefile.com

Major changes for this release:

Changed to the new windfury implementation (only white swings/on next ability).
Added the new weapon skill theory.
Added haste rating.
Merged the devastate and sunder armor cycles and added Devastate as a talent.

Upcoming PTR release:
Expertise.
Tactical mastery and the MS/BT change.

Newer version I'm not actually in charge of later in this post:
http://elitistjerks.com/552487-post161.html

Last edited by Punscho : 05/26/08 at 5:06 PM. Reason: Released Beta 4. Added xls 95.

Offline
Old 05/03/07, 4:57 AM   #2
Thecrowbar
Bald Bull
 
Thecrowbar's Avatar
 
--Retired--
Human Paladin
 
No WoW Account
Originally Posted by Punscho View Post
After seeing rather many threads about different parts of warrior tanking and TPS I decided to release my little project. We've seen many DPS sheets and this is a TPS sheet for us walking tin cans.

The problem is just that I don't have a _good_ place to host it.
http://www.mediafire.com/?7mjnxrumoym

I've tried to include enough stuff for most people but I have of course missed some things. Please be nice this first version and keep the feedback coming.
Had a quick run through it and it looks really nice.

I'll have a better look through it all later as I have to be off now, but the one thing I noticed is you have no option for Cruelty in the talent section.

United States Offline
Old 05/03/07, 10:30 AM   #3
jayowen
Von Kaiser
 
Undead Warlock
 
Thaurissan
I'll have a better look through it all later as I have to be off now, but the one thing I noticed is you have no option for Cruelty in the talent section.
Well, there's really no need since you fill in your crit value anyway.

Offline
Old 05/03/07, 12:20 PM   #4
Thecrowbar
Bald Bull
 
Thecrowbar's Avatar
 
--Retired--
Human Paladin
 
No WoW Account
Originally Posted by jayowen View Post
Well, there's really no need since you fill in your crit value anyway.
I filled in my crit value and it added 5 to it, so I guess it always assumes Cruelty.

United States Offline
Old 05/03/07, 12:31 PM   #5
Suesse
Don Flamenco
 
Suesse's Avatar
 
Human Death Knight
 
Llane
I assume this is some staroffice black magic? Can this be opened on Excel easily?

Edit: It downloaded quick enough. I'm good.

Last edited by Suesse : 05/03/07 at 1:53 PM. Reason: Lazy? Maybe.

Offline
Old 05/03/07, 1:52 PM   #6
Suesse
Don Flamenco
 
Suesse's Avatar
 
Human Death Knight
 
Llane
One thing that would be nice would be a listing of how each stat effects each cycle. For example, for a 2 devastate, shield slam, revenge, full heroic strike cycle
1 block value gives: W tps
1 hit rating gives: X tps
1 crit rating gives: Y tps
1 ap gives: Z tps
This type of info is useful for sites like lootzor or mods like pawn.
Of course, you can also do this by incrementing each stat and noting the tps difference.

Offline
Old 05/03/07, 2:08 PM   #7
Twid
Bald Bull
 
Twid's Avatar
 
Beepz
Human Warrior
 
No WoW Account
Is anyone able to get this to run in Excel? I shouldn't really install extraneous software here at work.

Originally Posted by Kalman View Post
Get you some purple drank and slow yo roll.

Offline
Old 05/03/07, 2:50 PM   #8
 Asmik
snow hook
 
Asmik's Avatar
 
Fiddler Asmik
Orc Warrior
 
No WoW Account
I'm very interested as well, but excel / google spreadsheet available only, any chance of getting a version in either?

Canada Offline
Old 05/03/07, 6:10 PM   #9
jayowen
Von Kaiser
 
Undead Warlock
 
Thaurissan
Originally Posted by Thecrowbar View Post
I filled in my crit value and it added 5 to it, so I guess it always assumes Cruelty.
Perhaps you have lotp set to 1 in the buffs section. The character sheet already takes cruelty into account, I see no reason for the spreadsheet to do so as well.

Offline
Old 05/03/07, 6:12 PM   #10
mutagen
Don Flamenco
 
mutagen's Avatar
 
Dwarf Priest
 
Proudmoore
I removed links to ancient versions of spreadsheets from a year ago.

Last edited by mutagen : 05/29/08 at 2:03 PM.

Offline
Old 05/03/07, 6:18 PM   #11
Zamaar
Von Kaiser
 
Undead Warrior
 
Skullcrusher
The Excel version has all the dmg values show as #NA

Btw, I saw cycles going up to 7 secs, shouldn't cycles be at a maximum of 5-6 secs (untill revenge / shield slam up again)?

Offline
Old 05/03/07, 6:37 PM   #12
Joy
Piston Honda
 
Worgen Mage
 
Frostmourne
Perhaps he is adjusting for reasonable latency

Offline
Old 05/03/07, 7:07 PM   #13
Punscho
Piston Honda
 
Punscho's Avatar
 
Gnome Rogue
 
Ravencrest (EU)
Thanks for the interest, I'll just add an Excel version (exporting from OO) and there should be no problems I believe.


The thing about cruely is that what you are supposed to insert in the upper left is your unbuffed stats and cruelty is already counted in your char sheet. Then apply the various buffs you wanna play around with.


About the cycles...
I use different cycles, the most common being a 4 skill cycle and 4 global cooldowns amounts to some lag that makes the cycle a little longer in reality. The default in the sheet is 0.1 second which will make the ordinary cycle about 6.4 seconds.

Then there's the 3 skill cycle that just uses 3 skills before going back to shield slam again. That of course will not be subject to a longer cycle due to lag because you just have to fit 3 gcds in 6 seconds and that's easy. At most just minor lag between cycles.

Revenge is 5 second cooldown but if you want to use all available time for skills you'll probably end up using it about every 6 second. If you want a longer cycle where you fit revenges every 5 second then please describe it so I can add it.


About the TPS per stat point thinking that will be added in the future but it's quite tedious to add so I wanted to know if people were interested before starting on that. It's work in progress.

Offline
Old 05/03/07, 7:14 PM   #14
Twid
Bald Bull
 
Twid's Avatar
 
Beepz
Human Warrior
 
No WoW Account
I'm having issues getting the spreadsheet to work on my work machine. Is it able to handle comparisons between cycles? ie: a SS/Rev/Dev with 200 ms latency versus a SS/Rev/Dev/Dev with 200 ms latency, where the latter cycle has SS off cooldown briefly each rotation.

Originally Posted by Kalman View Post
Get you some purple drank and slow yo roll.

Offline
Old 05/03/07, 7:33 PM   #15
Punscho
Piston Honda
 
Punscho's Avatar
 
Gnome Rogue
 
Ravencrest (EU)
Originally Posted by Twid View Post
I'm having issues getting the spreadsheet to work on my work machine. Is it able to handle comparisons between cycles? ie: a SS/Rev/Dev with 200 ms latency versus a SS/Rev/Dev/Dev with 200 ms latency, where the latter cycle has SS off cooldown briefly each rotation.
Yes, see the "4 skill cycle: ss, rev, dev, dev + variable hs" and compare it to the "3 skill cycle: ss, rev, dev + variable hs". Change the Lag parameter to 0.2.

"Variable hs" means a variable number of heroic strikes per cycle, so you can state approximately how many heroic strikes per cycle you deal, and the other swings will be counted as normal white damage. Change the number in the gray box next to "Heroic strike". You could of course set it to 0 aswell.

"Full hs" means full heropic strike usage and is there for reference since it's pretty hard keeping ALL swings heroic. The top cycles use full heroic.



I've been playing around with this for a couple of weeks so it's no trouble for me but it could really use a cleanup for readability, I know.

Offline
 

Go Back   Elitist Jerks » Public Discussion » Class Mechanics

Thread Tools

Similar Threads
Thread Thread Starter Forum Replies Last Post
[Warrior] One Button Tanking Macro wiseman The Dung Heap 36 06/08/07 3:54 PM
[Warrior] Hit rating while tanking. How important? Barash The Dung Heap 2 05/25/07 10:47 AM
[Warrior] Level 70 Tanking Enchants Pixen Class Mechanics 65 04/10/07 6:46 AM
[Warrior] +12 stam in tanking gear. Insect Class Mechanics 66 04/04/07 5:21 AM
Warrior tanking mechanics vorda Class Mechanics 52 03/06/07 12:16 AM