Tanking Spreadsheet 3.3 - Page 2

cidninja · 12/22/09, 3:51 AM

I noticed that Neverending Winter and the heroic version have no block value listed. I added it in myself and it made a pretty big difference in their rankings.

Also these don't matter as much since they're outdated at this point, but I guess I'll mention it anyway. The stats for Indestructible Plate Girdle and Shadow of the Ghoul are wrong. Each of them jumped up a bit after being corrected, too.

ZorbaTHut · 12/27/09, 5:43 AM

Originally Posted by cidninja

I noticed that Neverending Winter and the heroic version have no block value listed. I added it in myself and it made a pretty big difference in their rankings.

Also these don't matter as much since they're outdated at this point, but I guess I'll mention it anyway. The stats for Indestructible Plate Girdle and Shadow of the Ghoul are wrong. Each of them jumped up a bit after being corrected, too.

Fixed. Thanks!

Backgoode · 12/27/09, 5:35 PM

[Sindragosa's Flawless Fang] is listed as a ring.

Also, [Dreamhunter's Carbine] is missing the blue socket.

hellgoat · 12/28/09, 8:08 AM

Juggernaut Band - Item - World of Warcraft and the heroic version both miss their socket.

Executation · 01/04/10, 1:00 PM

Zorba,

I'm trying to input accurate numbers into the boss profiles and I was able to discover how to do this correctly for the DPS column. I have been putting in a hit size based on what the result is in "Stats.C23" and matching it up to a my log data. I'm finding that Anub hits me for about 17000 on average in 10 man hard mode. So, by backtracking, I've entered a value of 33600 in cell "Talents+Setup.J17" and a value of 1.75 in cell "Talents+Setup.J19" (the second value is the bosses attack speed which I got from my combat log).

Entering those things gives me an output value of around 17000 in cell "Stats.C23" with all the appropriate raid buffs, consumables, gear equipped, etc. used at the time of the fight.

So now I'm trying to figure out a good way to model magic damage and I was wondering if you could help me with how the spreadsheet uses the boss profile in it's calculations. Obviously cell "Stats.K18" is the value that the spreadsheet user plays with. What sort of number should I be putting there? Should I add up all the magic damage that could possibly hit me at once? Or should I add up the magic damage taken over the length of the fight and divide it by the time giving me a dps number? Or should I take a short section of time where I see a large burst of magic damage, total it up and divide by the short section's time length in seconds?

todemax · 01/04/10, 1:23 PM

As far as I recall, the burst calcs is based on how long you will survive without heals with rng against you, in steady state dps. So I believe it is averaged. On a typical boss, I myself would choose to use dps values from the highest dps phase of the encounter, and increase the value of the burst weighing to accommodate the 'burstyness' of the damage.

On a side note, it would be nice to include unavoidable damage, bleeds and maybe a combination of both to the boss profiles.

Executation · 01/04/10, 3:16 PM

Deleted.

todemax · 01/04/10, 3:21 PM

Originally Posted by Executation

I noticed something, in cell "Stats.C23" the boss damage is multiplied by the boss swing timer when it should be divided.

It's the boss dps timed the swing speed, which equals the damage per hit.

Executation · 01/04/10, 6:25 PM

After reviewing my combat logs this is the info that I entered into my sheet. Marrowgar has crazy high dps, it being the tank and healer check.

Enemy Profiles
DPS
Spd
MagicDPS

Anub'Arak 10 (H)
25500
1.75
208

Marrowgar 10
38500
1.1
1707

Deathwhisper 10
20800
2.4
5698

Saurfang 10
28750
1
1455

Reeshet · 01/08/10, 3:31 PM

Originally Posted by hellgoat

Juggernaut Band - Item - World of Warcraft and the heroic version both miss their socket.

and the stam and dodge values are incorrect.

Also, Sentinel's Winter cloak has 124 stamina.

janaka · 01/09/10, 7:01 PM

Here are the numbers I found for ICC25 so far (only physical damage):

		Marrowgar	Deathwhisper	Muradin		Saurfang	Festergut	Rotface

Base Speed	1,2		1,5		0,75		1,0		1,5		1,5
											
Raw Melee	57500		55000		60000		42500		75000		70000