(3.2.2.1) Tankadin Spreadsheet

Warning: Theorycraft inside.

Moderators: Fridmarr, Worldie, Aergis, theckhd

Re: (3.1.1.1) Tankadin Spreadsheet

Postby Florisia » Wed May 13, 2009 5:44 am

Great. Been waiting for this. :)

Things are much easier with a spreadsheet of gear.
Image
Florisia
 
Posts: 140
Joined: Sun May 10, 2009 10:37 am

Re: (3.1.0.3) Tankadin Spreadsheet

Postby blakk » Wed May 13, 2009 6:32 am

mandm413 wrote:
Florisia wrote:I actually use the Teldrassil Protector. I normally don't get a chance to run anything outside of heroics(taking care of an infant is taxing on my raiding life :P). Definately a good idea to add it.

All in all, this is great. Lets me easily add up things without having to do it myself. :D


I am about a week away from having the Teldrassil Protector myself but you don't have any of the weapons from the ragemane quest which is the hammer I have right now. I see though that you have many older weapons than that listed. Also you don't have Dabri's or some of the other trinkets from BC that many of us that didn't run kara still use.


Great spread sheet thanks again.


i'm in the same boat. have hammer of quiet mourning and it's not in the spreadsheet :?
blakk
 
Posts: 484
Joined: Tue Apr 07, 2009 6:33 am

Re: (3.1.1.1) Tankadin Spreadsheet

Postby Extrememaster » Mon May 18, 2009 3:50 am

The New Ulduar enchants for weapons don't seem to be in there either, Blade Warding and Blood Draining.
Image
Extrememaster
 
Posts: 7
Joined: Thu Apr 09, 2009 1:15 pm

Re: (3.1.1.1) Tankadin Spreadsheet

Postby Corman » Tue May 19, 2009 9:52 am

Question: Is BlockCap on this accurate (amends dodge/etc levels to those against an 83) or is it only against same level enemies (100 percent)?
Image
Corman
 
Posts: 453
Joined: Wed Jun 11, 2008 5:47 am

Re: (3.1.1.1) Tankadin Spreadsheet

Postby Euclide » Wed May 20, 2009 11:39 am

nice site. Will read up on a lot of this.
Image
Euclide
 
Posts: 1
Joined: Wed May 20, 2009 11:30 am

Re: (3.1.1.1) Tankadin Spreadsheet

Postby Rhî » Thu May 21, 2009 3:04 am

Corman wrote:Question: Is BlockCap on this accurate (amends dodge/etc levels to those against an 83) or is it only against same level enemies (100 percent)?


Correct versus selected enemy level.

If you choose, that your enemy is level 80, your shown stats are like the ingame player sheet.
If you choose, that your enemy is level 83, your stats are reduced by the proper amount.
Image
Rhî
 
Posts: 305
Joined: Fri Sep 21, 2007 4:41 am

Re: (3.1.1.1) Tankadin Spreadsheet

Postby Corman » Thu May 21, 2009 7:17 am

Ty!

On a seperate note, the stats for Shiedwall of the Breaker will need to be updated, it leaves off the expertise...
Sadly, despite getting it last night, its actually worse nearly everything, my Heroes' Surrender outdoing it on both threat and dtps :/
Slight, nay microscopic, EH boost but not worth it, imo.
Image
Corman
 
Posts: 453
Joined: Wed Jun 11, 2008 5:47 am

Re: (3.1.3.1) Tankadin Spreadsheet

Postby Rhî » Wed Jun 03, 2009 5:57 am

New version is available; see 1st post.
Image
Rhî
 
Posts: 305
Joined: Fri Sep 21, 2007 4:41 am

Re: (3.1.3.1) Tankadin Spreadsheet

Postby Nitra » Wed Jun 03, 2009 1:06 pm

Is there any way that I can add the updated stats for Shiver to this even if it's manually?
Image
Nitra
 
Posts: 11
Joined: Wed May 06, 2009 12:38 pm

Re: (3.1.3.1) Tankadin Spreadsheet

Postby Rhî » Wed Jun 03, 2009 2:57 pm

You've encountered a nice error. :)

Yes, if you have some office skills, you can easily change the item by yourself. The sheet 'mainhand' is hidden. you have to make it visible. after that, you see all available weapons with their stats, including shiver.
Image
Rhî
 
Posts: 305
Joined: Fri Sep 21, 2007 4:41 am

Re: (3.1.3.1) Tankadin Spreadsheet

Postby Nitra » Wed Jun 03, 2009 4:20 pm

I found it, and changed it, thanks for putting this together, it's a fantastic help :D
Image
Nitra
 
Posts: 11
Joined: Wed May 06, 2009 12:38 pm

Re: (3.1.3.1) Tankadin Spreadsheet

Postby Nitra » Thu Jun 04, 2009 2:42 pm

Small suggestion, would it be at all possible to add Agility to the stat comparison for avoidance?
Image
Nitra
 
Posts: 11
Joined: Wed May 06, 2009 12:38 pm

Re: (3.1.3.1) Tankadin Spreadsheet

Postby JohnnyC » Tue Jun 16, 2009 10:20 am

Hey, this spreadsheet is wonderful, and i want to thank you for taking the time to put something like this together :)

One thing i was hoping you might add in your next update is the PvP shoulder enchant that quite a few tanks are using (+30 Stam +15 Resil). Ever since the diminishing returns on avoidance, I've switched over to prioritizing stamina, especially for hard modes, and i know this enchant is on my enchant list. Just need to check if they fit into my gear with respect to going under 540 defense and what my health would look like (was using WoW Sandbox, but it seems to be a tad innacurate).

much appreciated!
-JC
JohnnyC
 
Posts: 1
Joined: Tue Jun 16, 2009 10:09 am

Re: (3.1.3.1) Tankadin Spreadsheet

Postby Rhî » Tue Jun 16, 2009 1:49 pm

Nitra wrote:Small suggestion, would it be at all possible to add Agility to the stat comparison for avoidance?


I don't think, that I will add this in the near future. Time is a rare jewel at the moment and this feature would require some coding.

JohnnyC wrote:Hey, this spreadsheet is wonderful, and i want to thank you for taking the time to put something like this together :)

One thing i was hoping you might add in your next update is the PvP shoulder enchant that quite a few tanks are using (+30 Stam +15 Resil). Ever since the diminishing returns on avoidance, I've switched over to prioritizing stamina, especially for hard modes, and i know this enchant is on my enchant list. Just need to check if they fit into my gear with respect to going under 540 defense and what my health would look like (was using WoW Sandbox, but it seems to be a tad innacurate).

much appreciated!
-JC


That's a quick thing. Will add this, but do not expect a updated version too soon.
Image
Rhî
 
Posts: 305
Joined: Fri Sep 21, 2007 4:41 am

Re: (3.1.3.1) Tankadin Spreadsheet

Postby bentglasstube » Mon Jul 13, 2009 12:08 pm

I noticed a tiny error in the Stats_Calc sheet that was giving me one more stamina than expected. For reference here is the character I was using to check this: http://www.wowarmory.com/character-shee ... &n=Forsyte

Now the spreadsheet gives me 1787 Stamina rather than the expected 1786. What I found is that the game rounds the stamina two separate times, once for base stamina and toughness and once for stamina from gear and buffs. When I take (base+toughness+gear)*1.08*1.06, I get 1787 like the spreadsheet gives. If, however, I use the formula [(base+toughness)*1.08*1.06]+[gear*1.08*1.06] (I am using the square brackets here to mean the greatest integer/floor function), I get 1786 as the armory and client show. I'm assuming that stamina from buffs will be added to the second half as they show as "green" in the client tooltips. Thus, I think the correct formula for Stats_Calc!B17 should be =FLOOR(SUM(C17,H17)*I17*J17*K17, 1)+FLOOR(SUM(D17:G17)*I17*J17*K17,1)

On another note, I also noticed that the human base health seems to be off by 20 at level 80 (24614-17680=6934 base health w/o stamina)
User avatar
bentglasstube
 
Posts: 40
Joined: Mon Jul 13, 2009 11:46 am
Location: Phoenix, AZ

PreviousNext

Return to Advanced Theorycraft and Calculations

Who is online

Users browsing this forum: No registered users and 1 guest

Who is online

In total there is 1 user online :: 0 registered, 0 hidden and 1 guest (based on users active over the past 5 minutes)
Most users ever online was 380 on Tue Oct 14, 2008 6:28 pm

Users browsing this forum: No registered users and 1 guest