Tanking Spreadsheet 3.3

ZorbaTHut · 12/14/09, 11:14 PM

Here's a new thread for a new maintainer so I can edit the OP. Old thread is here.

Current version (updated 1/26)
(OpenOffice only)

This spreadsheet now theoretically includes all 3.3 items that have been discovered. Yay! I'm missing some socket bonuses because for some weird reason they're not listed on the major sites. This will be fixed eventually.

Known bugs:

* 2pc/4pc bonuses are not implemented.
* Some procs may be simulated inaccurately, especially new procs (many of which don't have known proc rates or ICDs), double-especially the +heal procs on new weapons because I have no good way of simulating them right now.
* Icecrown boss profiles are essentially pulled out of thin air and from the posts of people in this thread, many of which contradict each other. Awesome. If you've got reliable numbers for ICC bosses, please let me know so I can add them.
* Deep Wounds modeling does not properly take into account your rotation and modified crit values on abilities, thus underestimating the value of Deep Wounds and the player's threat in general.
* The spreadsheet does not reconcile Mitigation and Burst terribly well, relying on hardcoded values for how important they are. Similarly, Burst itself is kind of a hodgepodge of hacks to make it "burstier" (tripled crit chance, doubled hit chance, removed dodge and parry) and it's questionable how meaningful this number actually is.

If there are common questions I'll update this area with answers.

Thanks to Damgaard and Gaiko for a lot of data entry!

Gaiko · 12/15/09, 3:27 AM

I'm missing some socket bonuses because for some weird reason they're not listed on the major sites. This will be fixed eventually.

Fortunately the missing data is on drops from bosses that have not been unlocked yet, so it should not affect anyone in any major way; look at it as more of a wishlist. Another thing that sent me searching was the absence of the normal mode version of the Bile-Encrusted Medallion (Rotface 25, Heroic) but again, as MMO-Champion has basically given us all the data it has at the moment, we will have to remain patient until those bosses are unlocked and their loot tables are fleshed out.

Excuses for my shortcomings aside, I have seen one minor typo; the Eyes of Zul. You have it in there as two u's. There are some prices on your list that are not accurate as well:

Hellscream's (Wrynn's) Pauldrons and Handguards of Conquest are 30 Emblems of Triumph, not 45.
Hellscream's (Wrynn's) Greathelm, Breastplate, and Legguards of Conquest are 50 Emblems, not 75.

The Triumph versions are all the correct price.

ZorbaTHut · 12/15/09, 8:07 AM

Originally Posted by Gaiko

Excuses for my shortcomings aside, I have seen one minor typo; the Eyes of Zul. You have it in there as two u's. There are some prices on your list that are not accurate as well:

Hellscream's (Wrynn's) Pauldrons and Handguards of Conquest are 30 Emblems of Triumph, not 45.
Hellscream's (Wrynn's) Greathelm, Breastplate, and Legguards of Conquest are 50 Emblems, not 75.

The Triumph versions are all the correct price.

Curious, I think they reduced the emblem prices in 3.3.

Got that fixed in my local version. I'm not going to make a push yet, I'll see if there's other issues. Thanks

Trickswow · 12/15/09, 8:32 AM

When opening the spreadsheet in Excel 2007 i get a error saying unreadable content do you want to recover content? I click yes then get the message it was able to open the file by repairing or removing the unreadable content. Is this effecting any functionality of the spreadsheet?

After a little investigating i now see its for open office. Will there be a excel version posted?

Gromgoth · 12/15/09, 1:10 PM

Probably not. There hasn't been an excel version for the last few months. Just download OpenOffice. Its free...

Gromgoth · 12/15/09, 1:42 PM

Is it possible to fix the race function? I have a working horde version and a working alliance version. But if i change race in both i get #N/A errors in equipment.

If its possible but needs some work, let me know how so i can try to fix it myself and repost it if it works.

todemax · 12/15/09, 3:39 PM

If you change the race from an alliance race to a horde race, you have to change the equipment to the horde version as well. That is probably why you get those errors. The equipment cells on the Equip tab is just text, so it doesn't update from the if statements on the gearlist tab.

ZorbaTHut · 12/15/09, 11:06 PM

Originally Posted by Trickswow

After a little investigating i now see its for open office. Will there be a excel version posted?

Unless someone else wants to maintain one, no - I'm not getting paid enough to fight with Excel

As mentioned, OO is free, use OO.

Originally Posted by Gromgoth

Is it possible to fix the race function? I have a working horde version and a working alliance version. But if i change race in both i get #N/A errors in equipment.

If its possible but needs some work, let me know how so i can try to fix it myself and repost it if it works.

Oops, forgot about this bug. Yeah, as mentioned, it's the multiple-names-for-items issue. I think I've got an idea on how to patch it up, I'll go take a shot at it right now.

DeathRabbit · 12/16/09, 9:54 PM

Originally Posted by ZorbaTHut

Oops, forgot about this bug. Yeah, as mentioned, it's the multiple-names-for-items issue. I think I've got an idea on how to patch it up, I'll go take a shot at it right now.

Another related bug I found, Draenei are listed as horde, thus are assigned to the horde only version of the armor set. May have been mentioned already though.

Executation · 12/18/09, 12:37 PM

At first look it seems like the special on this trinket is rated too high, and here's is what I found.

A boss is going to remove this extra "bubble" from you with a single strike because bosses usually hit for over 3200, or you will otherwise receive 3200 damage rather quickly. At best it can assist in recovering from spike damage. That being said, the current spreadsheet value is skewed because of the "uptime" formula for this trinket's proc. The current formula is:

"=1/6"

Because the "on-use" says it will be up for 20 seconds on a 2 minute cooldown. However, since the bubble will be removed on the bosses next attack, I thought it would give a better result to base the "uptime" formula on the bosses attack speed:

"='Talents+Setup'.K19/120"

Hexadril · 12/19/09, 4:38 PM

I still have to pretend I am a gnome to get this spreadsheet to work.

Any horde race and I get a bunch of N/A errors, and yes - after I reset all the gear to horde.

ZorbaTHut · 12/20/09, 12:11 PM

Originally Posted by Executation

At first look it seems like the special on this trinket is rated too high, and here's is what I found.

Whoops. I implemented it in terms of the Essence of Gossamer proc because that seemed closest. Looking at it again, yeah, that's not even remotely what it does.

Hard to figure out a sensible way to model it, though.

Anyway let's have a new version. Oughta fix the faction issues and add bonus threat to Devastate (missing for some reason).

winkiller · 12/20/09, 4:11 PM

Hellscream's Legguards of Conquest show Red/Yellow gem slots in the 12_20 version, but it's Red/Blue in fact (didn't check if calculations are wrong as well). Oh, and thanks for the work.

spaace · 12/20/09, 4:35 PM

Cataclysmic Chestguard (EoFx95) is currently missing.

As for the N/A Error when chosing horde, from alliance, reset the gear no a non-faction specific type (anything pre-toc) then change your class. It works fine for me.

ZorbaTHut · 12/20/09, 5:48 PM

Dang that's a nice chest.

Both those issues will be fixed in the next version. Also, if anyone still gets N/A errors with the 12/20 version, let me know, because they should be fixed.