Pocket Guide to WOTLK (Updated for 3.3) - Page 85

Kidneythief · 08/23/09, 3:03 PM

Originally Posted by Rahdik

If you go to Format -> Sheet -> Unhide, and choose Gear, you'll get the gear spreadsheet that has all the information about any of the gear you can choose in the Equipment sheet. To add in Favor of the Dragon Queen I would Insert a new row, copy the entire row for Pendulum of Infinity (if it happens to be in row 16, click on the Number 16, you should get a sideways arrow, then choose copy), and paste it in the new row you just created. Change the name to Favor of the Dragon Queen, and then all you should have to do is change the stats to what match the FotDG piece. Since Pendulum already has a socket (and a blue one at that) you shouldn't have to mess with any of the socket information.

You'll also need to edit the listname to reflect the fact it now has one extra row in it, at least that's what I need to do in both Excel 2000 and OO. In Excel, this is "Insert, Name, Define" then change the values for Necks (if it's a Necklace you're adding) to include the extra row.

LetsRock · 08/23/09, 4:19 PM

Originally Posted by Rahdik

If you go to Format -> Sheet -> Unhide, and choose Gear, you'll get the gear spreadsheet that has all the information about any of the gear you can choose in the Equipment sheet. To add in Favor of the Dragon Queen I would Insert a new row, copy the entire row for Pendulum of Infinity (if it happens to be in row 16, click on the Number 16, you should get a sideways arrow, then choose copy), and paste it in the new row you just created. Change the name to Favor of the Dragon Queen, and then all you should have to do is change the stats to what match the FotDG piece. Since Pendulum already has a socket (and a blue one at that) you shouldn't have to mess with any of the socket information.

Thanks alot for the info,

I got about half way done and realized i didnt know the stats to fill in.

I suck at excel but appreciate you trying.

Rock

dinesh · 08/23/09, 4:38 PM

Originally Posted by Kidneythief

You'll also need to edit the listname to reflect the fact it now has one extra row in it, at least that's what I need to do in both Excel 2000 and OO. In Excel, this is "Insert, Name, Define" then change the values for Necks (if it's a Necklace you're adding) to include the extra row.

You don't need to do this if you insert the blank row into the middle of the section, rather than at the beginning or end.

darwinism · 08/25/09, 7:26 PM

Ok, so I suck at math, but according to the ep in this thread 1.46 haste is equal to 1 ap.

I'm trying to figure out which trinket to buy with Triumph emblems. [Mark of Supremacy] or [Shard of the Crystal Heart]

With my rudimentary understanding of statistic weights, the haste on the Mark of Supremacy is equal to 747.52 AP, which would make the Shard of the Crystal Heart much better.

However, Maxdps.com has the Mark of Supremacy rated much higher, and Rawr has them exactly even.

Could someone help me out here.

Daarky · 08/25/09, 7:49 PM

Granted, this is with my gear, not yours- but the spreadsheet has mark of supremacy a good 35dps higher than the shard of the crystal heart

Venomous · 08/25/09, 8:15 PM

Originally Posted by Aldriana

Okay, new BIS proposal. As usual, all drops are heroic if available:

T9 Helm, Shoulders, Chest, and Legs
Collar of Ceaseless Torment
Vereesa's Dexterity
Bracers of Dark Determination
Gloves of the Silver Assassin
Belt of the Merciless Killer
Treads of the Icewalker
Ring of Callous Aggression
Planestalker Signet
Death's Verdict
Comet's Trail
Remorseless
Steel Bladebreaker
Talonstrike
BS/JC
1 Nightmare Tear in the helm, everything else straight ArPen.
All enchants the obvious thing; boots are Cat's Swiftness, not because it's best for sustained DPS but because I suspect we'll find it to be a good idea in general from what I've seen so far.

As a check, fully enchanted and gemmed, this comes out to:
20 Str
1419 Agi
1467 Sta
2645 AP
651 Crit Rating
417 Hit Rating
154 Expertise Rating
194 Haste Rating
1007 ArPen Rating

So, food is ArPen, flask as usual, target fully debuffed, 5/5 Mace Spec, 1/5 CQC, Haste Potion used once in a 5 min fight.

So, at 15/51/5, doing the usual Xs5r5e cycle, this comes out to do 9884.1 DPS. Which is pretty good. But here's where it gets wierd.

If we drop Glyph of Rupture for Glyph of Evis, and 2 points of Blood Spatter and 1 of Ruthlessness to get 3/3 Improved Eviscerate, and then drop Rupture from our cycles entirely and just do Xs5e5e, that number goes up to 9945.0. And if we replace that cycle with the optimal one (which I'll define in a moment), our estimate gets all the way up to 9979.8. (And if we switch to Icewalker on Boots, we crack the 10k mark - 10008.8. But that's sort of a separate issue).

So, what is this optimal cycle? Briefly stated, the priority is to refresh SnD early as little as possible. Hence: we perform an SnD. We then build 5 CPs. If there are 5 seconds or less on SnD, we pool energy as high as we dare, and then refresh SnD. Otherwise, we drop an Evis and start building CPs again. If at any time SnD has less than 2 seconds left, we just refresh it with whatever CPs we have. That is: the priority is to refresh it as late as possible, more so than worrying about how big the SnD winds up being.

Note, of course, that this only works at extremely high gear levels. But assuming you do have said very high gear level, this appears to be optimal.

With your suggested BiS Aldriana, I'm assuming this is due to the fact that your Alliance and unfortunately don't have access to Hordes' 1.5 Axe - [Blood Fury]? This being the case, I then assume it would be more advisable for Horde players to go - Hellscream Slicer [Heroic] /// Blood Fury [Heroic] (Obviously with 5/5 Hack & Slash)?

This was based on quick testing in the 1.2 Spreadsheet.

Petergriffin · 08/25/09, 8:32 PM

Originally Posted by darwinism

Ok, so I suck at math, but according to the ep in this thread 1.46 haste is equal to 1 ap.

I'm trying to figure out which trinket to buy with Triumph emblems. [Mark of Supremacy] or [Shard of the Crystal Heart]

With my rudimentary understanding of statistic weights, the haste on the Mark of Supremacy is equal to 747.52 AP, which would make the Shard of the Crystal Heart much better.

However, Maxdps.com has the Mark of Supremacy rated much higher, and Rawr has them exactly even.

Could someone help me out here.

There's a small flaw in your logic: A Stat having an EP value of 1.46, or shall I rather say, in our case, an APEP value of 1.46 means that 1 point of this stat is worth as much as 1.46 AP.
However, you calculated the ep value of the Haste On-Use correctly, but you confused the two trinkets; Mark of Supremacy is the one with the AP effect and the Shard has the Haste effect, thus leading to the higher rating of the Mark vs the Shard, as 1024 AP is worth more than 512 Haste Rating.

• Aldriana · 08/25/09, 8:37 PM

Alliance axe is now 1.5 speed as well. And even with that, mace spec is just so stupidly powerful at the levels of ArPen we're talking that mace/dagger beats axe/axe anyway.

Venomous · 08/25/09, 9:00 PM

Originally Posted by Aldriana

Alliance axe is now 1.5 speed as well. And even with that, mace spec is just so stupidly powerful at the levels of ArPen we're talking that mace/dagger beats axe/axe anyway.

Understood, however at low level/gearing up til BiS - I'd assume Mace/Dagger doesn't come into play? This is simply based on a quick hack in 1.2 comparing my current BiS Uldar/Early non-H ToC gear with Mace/Dag vs. Axe/Axe (Axe/Axe came out on top) - but as you mentioned this is no doubt due to low lvl ArPen gear.

Just thinking about min/max for Guild and if I should be moving from Golden/Stygian straight to Mace/H Stygian or since no MH Mace drops normal 25 - make the move to Axe/Axe first.

Istarian · 08/26/09, 11:00 AM

I asked this awhile back, but want to reiterate with the t9 2 pc in mind (not that I'd use it anytime soon with my gear (4 pc t8)); assume this situation:
You have 5 Combo Points.
Slice and Dice is at 25 seconds.
Rupture is at 5 seconds.
You have a warrior so you are not inclined to use EA.
You have 20 energy.
Blade Flurry is active. Adrenaline Rush is not.
Your options are:
-Eviscerate, rebuild up to a Rupture with a risk of moderate / large Rupture downtime (and less chance of proccing the set bonus if acquired)
-Pool up, you generate energy through CP, and cap, wait until Rupture falls before reapplying and "uncapping".
-Pool up, you generate energy through CP, use a Sinister Strike (wasted CP) to avoid capping and reapplying Rupture when it falls.
-Pool up, you generate energy through CP, clip Rupture (being very careful to only clip one tick), thus wasting a Rupture tick yet assuring Rupture uptime.

Which of these options is the optimal choice?

• Aldriana · 08/26/09, 4:23 PM

The answer is pool as high as you dare, and then rupture if the previous Rupture is still going and Rupture if it isn't. Basically, the damage contribution of 2/5 T9 isn't very large, so plays very little role in this sort of decision, and assuming that your gear is good enough to be breaking 4/5 T8, the damage difference between Eviscerate and Rupture is small enough that you don't actually lose very much damage by having Rupture down for a bit.

Where this question would be somewhat difficult to answer is with 4/5 T8, which makes good rupture uptime vastly more important. Of course, the correct solution in that case is to craft your cycle so as never to be in that position in the first place.

Mavanas · 08/26/09, 8:04 PM

Small-case "rupture" in the previous post, probably has to be replaced with "eviscerate." I just have a question, what's the gain from pooling energy in this situation as opposed to eviscerating right away and then rebuilding for a rupture?

• Aldriana · 08/26/09, 8:11 PM

Well, pooling doesn't hurt anything - building the next rupture is energy-limited rather than GCD-limited, so pooling has no bearing on when the next Rupture is going to occur; and if you happen to not get any combat potency procs in that time, you may be able to stall long enough to rupture rather than needing to weave an eviscerate. I mean, if it's actually 20 energy and actually 5 seconds, probably not, but if we're talking 18 energy and 4.5 seconds, it starts to look pretty feasible. Basically, the reason in short is "because there's no reason not to".

Mavanas · 08/27/09, 12:20 AM

Well the person who asked the question, did it with t9 in mind, so if there is no strong benefit from pooling, which there does not seem to be, I would not pool past 60, just for that off chance of t9 2-piece proccing and energy going to waste. It's true that the set bonus is not very big in percent terms compared to some we've seen before, but there is no reason to waste it either. Assuming 80% rupture uptime, 80%*2%*40/2 is 0.32 energy per second if not wasted. If a sinister strike hits for 3k on average and all that extra energy goes to sinister strikes, 2-piece set bonus is around 24 dps, or around 0.25% dps. If a portion of it goes to eviscerate, the benefit is going to be slightly higher.

• Aldriana · 08/27/09, 6:41 AM

So, it's sort of a risk versus reward computation. Pooling past 60 may mean you waste, say, 15 energy if T9 2/5 procs, and 15 energy, when you work it out, tends to be worth on the order of 3000 damage... but you only lose that 3000 damage 2% of the time, so your *expected* damage loss is only 60. So the question is: do you gain more or less than 60 damage by pooling? And depending on the exact timing, the answer - at least some of the time - is going to be yes.