( Tankadin Spreadsheet

Warning: Theorycraft inside.

Moderators: Fridmarr, Worldie, Aergis, theckhd

( Tankadin Spreadsheet

Postby Rhî » Sat Oct 20, 2007 10:21 am

What is this Tankadin Spreadsheet?
It is a very complex Microsoft Excel spreadsheet including alot thinkable aspects of a Protection Paladin aka Tankadin. It's working in Open Office, too. But to a minor degree (no macros there, no stat comparison available). You can customize your items with enchants, jewels, etc, your talents, your glyphs, your (raid)buffs and see your tanking stats like avoidance or threat in several pages.

You can see, what stat is best for you with your current gear, your raidbuffs and versus what kind of enemy.

With the preset gear (melee hit capped, dodge expertise capped)) the stats are weighted like the following:
Offensive Stats*
Hit ............................. 0,58
Strength ........................ 2,90
Block Value ..................... 1,43
Expertise ....................... 1,78
Critical Strike Rating .......... 1,04
Attack Power .................... 0,88
Agility.......................... 0,91
Haste Rating..................... 0,68
Spell Power...................... 0,41

Defensive Stats*²
Defense Rating .... 0,209%
Dodge Rating ...... 0,230%
Parry Rating ....... 0,191%
Agility............... 0,180%


Download Link
Latest Builds available at http://tank.abits.biz sponsored by abinning. Thank you very much!


09.01.2009 Tankadin







Download History
10.12.2008 Tankadin
22.01.2009 Tankadin
18.02.2009 Tankadin
20.02.2009 Tankadin
25.02.2009 Tankadin
PTR-Version: 30.03.2009 Tankadin
PTR-Version: 03.04.2009 Tankadin
26.04.2009 Tankadin
03.06.2009 Tankadin
PTR: 23.07.2009 Tankadin
24.07.2009 Tankadin
PTR 10.09.2009 Tankadin

The Tankadin Spreadsheet is a work in progress. I'm trying to be as up to date as possible. I'm always looking for more accurate new coefficients. Let me know if you find any errors or want some features to be added. Constructive feedback is always welcome.

* read: 1 point of the stat converts into x TPS.
*² read: 16 points of the stat converts into x % avoidance.
Last edited by Rhî on Sat Jan 09, 2010 3:14 pm, edited 43 times in total.
Posts: 305
Joined: Fri Sep 21, 2007 4:41 am

Postby Mithos » Sat Oct 20, 2007 11:16 am

Any chance you could host it somewhere other than rapidshare? :(
Posts: 728
Joined: Thu Aug 30, 2007 7:54 am

Postby Rhî » Sat Oct 20, 2007 11:23 am

No, not really. Any problems with rapdishare?
Posts: 305
Joined: Fri Sep 21, 2007 4:41 am

Postby Mithos » Sat Oct 20, 2007 2:41 pm

Hmm, I just tried and managed to download it first go. I can safely say, that is the first time in my life rapidshare have let me download anything, I guess they've fixed some horrendous error :) will take a look.
Posts: 728
Joined: Thu Aug 30, 2007 7:54 am

Postby Nemi » Wed Oct 24, 2007 8:57 am

I d/l'd it.. but maybe i'm tarded or something but I cant figure out how to imput equipment.. or is it just hey look if you had this gear this would be the result?
Posts: 190
Joined: Thu Jul 19, 2007 7:46 am

Postby Rhî » Wed Oct 24, 2007 1:23 pm

Sounds like I should make a F.A.Q.

For now, open it with excel, say yes to activated macros, change to item-sheet and go for example on the cell where the head-item 'faceplate of the impenetrable' is. You should get a dropdown menu. From there you can select several items for the headslot. I dont added all heads, but the most common from ilvl 115+.
Posts: 305
Joined: Fri Sep 21, 2007 4:41 am

Postby cordelia » Sun Nov 04, 2007 6:13 pm

So here's my list of constructive criticisms (you asked :) so far:

(1) Enchants: missing shoulder enchants from Aldor. You should have all 4, not just exalted.

(2) Gems: missing all the heroic gems? Or at least some of them. eg. Stalwart Fire Opal from Setthek Halls. A great tanking gem.

(3) Feet: Missing Eaglecrest warboots, a legitimate upgrade from Flesh Beasts.

(4) Rings: missing lots. The pre-raid gearing list is a good checklist for decent rings. Also, Protector's mark of the redemption, Yor's Revenge, Ring of unyielding force, band of impenetrable defenses

(5) trinkets: missing the other DMC, engineering trinkets, dabiri's, adamantite figurine

(6) Temporary buffs: missing a guardian/battle elixir combo instead of flasks. also missing other flasks, such as the BEM ones. Also missing scrolls such as +agi/+protection. Also missing temporary enchants such as rune of warding.

(7) resist set items are all missing. probably purposefully. But they would be nice.

(8 ) if this is 2.3'ified. Why does PoJ only have 2 available talent points?

Otherwise, it looks really cool. I can't wait to actually fill it out with my gear.

User avatar
Posts: 630
Joined: Tue Oct 09, 2007 3:33 am

Postby Fearonir » Sun Nov 04, 2007 9:01 pm

I agree, it's a nice thing to have, but very limited in most of the options. Especially the lack of the heroic dungeon gems.

Posts: 115
Joined: Sun Oct 14, 2007 8:02 am

Postby fiorina » Sun Nov 04, 2007 9:16 pm

Very nice. A bit buggy tho, I've tried to change to Lightbringer shoulders + Unbreakable will and both gave me some errors #DIV/0 for example. I gave up :)
User avatar
Posts: 1027
Joined: Mon Aug 27, 2007 6:07 pm

Postby Girard » Sun Nov 04, 2007 10:05 pm

Or only nethercleft armor for legs, as opposed to the crappy +30stamina some of us have =)
Posts: 418
Joined: Wed May 30, 2007 2:15 pm

Postby Rhî » Tue Nov 06, 2007 2:57 am

I'm putting it on the To Do list, maybe you can tell me where and how to look for a heroic gem list?

And thank you for your feedback. I've already fixed some issues, but I want to do some minor changes until the release of a new version.
Posts: 305
Joined: Fri Sep 21, 2007 4:41 am

Postby adese » Tue Nov 06, 2007 5:30 am

Rhî wrote:I'm putting it on the To Do list, maybe you can tell me where and how to look for a heroic gem list?

Here is a WoWHead search of all epic gems that aren't crafted, from PvP, or from a quest. I the gems that don't don't have a source are new gems in 2.3 that are quest rewards (the one I looked at was from a ZA quest).

In any event, if you only look at the ones that have a source of "Drop" that should be your list.
Posts: 692
Joined: Wed May 09, 2007 7:33 pm
Location: Aggramar

Postby Haus » Thu Nov 08, 2007 9:22 am

Nice. I would suggest also adding the three heroic epic items that compliment the Righteous set.

http://www.wowhead.com/?items=4.4&filte ... rs=1;crv=0
Posts: 1
Joined: Thu Nov 08, 2007 9:13 am

Postby Rhî » Sat Nov 10, 2007 11:24 am

Posts: 305
Joined: Fri Sep 21, 2007 4:41 am

Postby Lieris » Sat Nov 10, 2007 3:10 pm

It's full of errors (Err:508) when using Neo Office (Mac version of Open Office) :(
Posts: 2181
Joined: Mon Jun 18, 2007 7:49 am


Return to Advanced Theorycraft and Calculations

Who is online

Users browsing this forum: golfinguy and 1 guest

Who is online

In total there are 2 users online :: 1 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: golfinguy and 1 guest