September 03, 2010, 01:04:28 PM *
Welcome, Guest. Please login or register.

Login with username, password and session length
News:
 
  Home Blog Help Search Calendar Login Register  
Pages: [1] 2 3 ... 5
  Print  
This topic has not yet been rated!
You have not rated this topic. Select a rating:
Author Topic: Tanking Stats Spread Sheet  (Read 22749 times)
0 Members and 1 Guest are viewing this topic.
Tantlin
*
Posts: 58



« on: October 08, 2008, 08:18:20 PM »

Here's the third version of my tanking mitigation simulator.

Download DKTankCraftV3.12 Excel 2007

Download DKTankCraftV3.12 97-2003

Download DKTankCraftV3.12 Open Office

Jan 14 2009: note this tool has not been updated to reflect the 3.08 patch changes. Once that happens we can re-sticky it. -Gravity

**Important Please Read**
There are a few circular formulas within the spreadsheet because of this it is possible that you will load the spread sheet and get a few N/A's in the sheet. If this is the case toggling the red cell on the mitigation sheet should fix it.

If this does not work, make sure Enable Iterative Calculations is checked in Excel Options/Formulas.





The Excel 2007 version has a fully functional talent tree that's plugged into the equations.


Stats based on talents, buffs, gear and race.


Works Just like the websites, left click to add points, right click to subtract. Even has tooltips.


Choose your gear.


TPS calculator that suggest the highest TPS rotation for your spec.

The Work Sheet isn't locked so feel free to modify it for your uses. If you find any bugs/mistakes please feel free to comment on them.
« Last Edit: January 13, 2009, 08:31:24 PM by Gravity » Logged

I don't make em... I just brake em.

http://crazytank.wordpress.com/
Sielk
*
Posts: 59


« Reply #1 on: October 08, 2008, 09:32:22 PM »

Because I love you guys, this will let you run it in older versions.

http://www.microsoft.com/downloads/details.aspx?FamilyId=941b3470-3ae9-4aee-8f43-c6bb74cd1466&displaylang=en

Working on a fix to get it into openoffice for those of us who refuse to pay for word processing.

http://www.openoffice.org
« Last Edit: October 08, 2008, 09:48:52 PM by Sielk » Logged

[char=Uther:30d6e]sylvok[/char:30d6e]
[char=Uther:30d6e]Sielk[/char:30d6e]
Tantlin
*
Posts: 58



« Reply #2 on: October 08, 2008, 09:41:17 PM »

Little bit tired so almost forgot to give credit where credit is due.

Theres not a whole lot of similarity anymore but my jumping off point was from this:

http://maintankadin.failsafedesign.com/viewtopic.php?t=14692
Logged

I don't make em... I just brake em.

http://crazytank.wordpress.com/
Predatory
*
Posts: 6


« Reply #3 on: October 10, 2008, 07:53:26 AM »

Or you could just have people install the 2007 compatibility pack from MS.  buck2

PS.  Awesome work!
Logged
futhark
Runemaster
M.V.D.K.
******
Posts: 2317



« Reply #4 on: October 10, 2008, 11:34:44 AM »

This analysis is above me. 

Someone distill it and tell me what to do! Tongue


Edit: Get this thread out of General and put it somewhere it won't get buried!
« Last Edit: October 10, 2008, 11:36:50 AM by futhark » Logged

Farsight
Vault Dweller
*****
Posts: 2531


DPS Theoryhouse


« Reply #5 on: October 10, 2008, 12:03:38 PM »

I'd recommend the Raiding Forum.

Futhark: Put on plate and get crunked in the face a bunch. Don't die.

SEE? I HELPED!
Logged

Tantlin
*
Posts: 58



« Reply #6 on: October 10, 2008, 01:07:03 PM »

Updated version plus some of the tools helping me figure out the enigma that is BS.

Fast Attack Model

Slow Attack Model

DK Tank Simulator V2.04
Logged

I don't make em... I just brake em.

http://crazytank.wordpress.com/
Ryadasu
the Quitter
*****
Posts: 1587



« Reply #7 on: October 10, 2008, 07:23:59 PM »

Moved to Tanking
Logged

Iscariote
Deathtank!
*****
Posts: 1442



« Reply #8 on: October 11, 2008, 02:58:51 AM »

great job!

I have been waiting for something like this! Smiley
time to play, hihi
Logged

Raiding is hard. Sometimes there is fire.
You have to not be in the fire.

Tantlin
*
Posts: 58



« Reply #9 on: October 11, 2008, 05:37:29 PM »

Upgraded talents spec page to allow 3 different saves, right click to save left click to recover.


http://www.savefile.com/files/1833755
Logged

I don't make em... I just brake em.

http://crazytank.wordpress.com/
Kaera
On Hiatus
**
Posts: 141



« Reply #10 on: October 12, 2008, 04:56:31 AM »

You can also get Official Trials of Office 2007 from the Homepage - it WILL convince you to buy it, if only to use for this nifty spreadsheet.

Go. Now  smiley
Logged
Iscariote
Deathtank!
*****
Posts: 1442



« Reply #11 on: October 12, 2008, 05:36:51 AM »

hmm, is it usable with http://www.openoffice.org/ perhaps?
Logged

Raiding is hard. Sometimes there is fire.
You have to not be in the fire.

Kaera
On Hiatus
**
Posts: 141



« Reply #12 on: October 12, 2008, 07:16:59 AM »

Just wondering if there will be any support for Crafted Items/Heroic/Instance drops for pre Naxx? or have I missed something glaringly obvious?  grin
Logged
Carow
Jack of all trades, master of none.
**
Posts: 258



« Reply #13 on: October 12, 2008, 07:27:11 AM »

Since I think this is going to be a great help to everyone and don't want to see it go lower then the first page it is now stickied.
Logged

I am a Death Knight, loyal only to the Lich King.
Tantlin
*
Posts: 58



« Reply #14 on: October 12, 2008, 09:51:35 AM »

Just wondering if there will be any support for Crafted Items/Heroic/Instance drops for pre Naxx? or have I missed something glaringly obvious?  grin

There are some crafted items and I plan on adding more items, however if anyone can add wowhead links of items I missed it will make the process faster.
Logged

I don't make em... I just brake em.

http://crazytank.wordpress.com/
Pages: [1] 2 3 ... 5
  Print  
 
Jump to:  

Powered by MySQL Powered by PHP Powered by SMF 1.1.11 | SMF © 2006-2009, Simple Machines LLC
SC2 theme by Vaun. Based on AF316 theme by Fedhog.
Valid XHTML 1.0! Valid CSS!