[Warrior] DPS Spreadsheet 2.3 and beyond - Page 63

Nunki · 04/16/08, 12:04 PM

Originally Posted by Nunki

I was wondering about the viability of the Shattered Sun Pendent of Might, [Shattered Sun Pendant of Might], for raiding and I didn't see it on the spreadsheet. I did some quick math but I'm not sure if it is correct. I believe the proc to be worth roughly 33 AP for Aldor, giving a total of 97 ap, 18 agi and 19 stam. The proc, for Aldor, lasts for 10 seconds and is 200 Ap. It has a 45 second internal cool down.
I believe the scryers proc is 500 (arcane?) damage that can crit.
If some one else has done some math or has other information regarding this item I would greatly appreciate it.

I just realized, I may of done the math wrong, or well correct based on an assumption i made which may be wrong.

On items with internal cooldowns does the cooldown start ticking as soon as the item procs or when the proc ends?

If it is when the proc ends then this is roughly correct maybe off by 3-4 ap. If the internal cooldown starts counting immediately then the proc would be better by almost triple.

Any help would be appreciated.

Ryuuichi · 04/16/08, 3:45 PM

Originally Posted by Nunki

I just realized, I may of done the math wrong, or well correct based on an assumption i made which may be wrong.

On items with internal cooldowns does the cooldown start ticking as soon as the item procs or when the proc ends?

If it is when the proc ends then this is roughly correct maybe off by 3-4 ap. If the internal cooldown starts counting immediately then the proc would be better by almost triple.

Any help would be appreciated.

The cooldown starts as soon as it procs, so there should only be a 35 sec gap with no buff in ideal conditions. Also, when modeling items with procs in the spreadsheets should I input the average stat boost given by the procs, or ignore the procs when entering stats?

Kaan · 04/17/08, 12:19 AM

Originally Posted by Ryuuichi

The cooldown starts as soon as it procs, so there should only be a 35 sec gap with no buff in ideal conditions. Also, when modeling items with procs in the spreadsheets should I input the average stat boost given by the procs, or ignore the procs when enterig stats?

Enter average stats, the spreadsheet would do the same, if the item had been modeled.

landsoul · 04/18/08, 11:42 AM

Originally Posted by Ryuuichi

The cooldown starts as soon as it procs, so there should only be a 35 sec gap with no buff in ideal conditions. Also, when modeling items with procs in the spreadsheets should I input the average stat boost given by the procs, or ignore the procs when entering stats?

Well how I do it is I setup a formula like this:

uptime = duration / (hidden cooldown + avg time to reproc)

avg time to reproc = 60 / the combined average PPM of the proc

with high end gear levels the combined real PPM of a 1.0 PPM base swiging with both weapons, specials, etc. can go somewhere like 2.5-3 ppm.

so for approximate representation: 10/(45+60/2.75) * 200AP = 29.93

Comes out to around 30 AP depending on what your other stats are.

Gruntle · 04/18/08, 12:55 PM

Originally Posted by landsoul

Well how I do it is I setup a formula like this:

uptime = duration / (hidden cooldown + avg time to reproc)

avg time to reproc = 60 / the combined average PPM of the proc

with high end gear levels the combined real PPM of a 1.0 PPM base swiging with both weapons, specials, etc. can go somewhere like 2.5-3 ppm.

so for approximate representation: 10/(45+60/2.75) * 200AP = 29.93

Comes out to around 30 AP depending on what your other stats are.

But how sure are you about the ppm values of items with hidden cooldowns? The cooldowns must make it very tricky to find ppms, maybe those procs are not even ppm based. You're saying that it will take about 25 sec for the proc to go off again, I think that is ay too long. I have no hard evidence but a lot of people are saying that the proc comes up again after 45 sec much quicker than that. Not that "a lot of people" is particularly trustworthy, maybe you're basing it on solid data.

hamsterboat · 04/18/08, 4:27 PM

Just started using this spread sheet, trying it out, when i open all 3 documents. i am getting massive errors in the dps document one. I click the fix it button nothing really happens. and when trying to select an item from the drop down menu for each slot nothing is showing up, either errors or #NA. If any one can help me out with that much appreciation.

landsoul · 04/19/08, 8:04 PM

Originally Posted by Gruntle

But how sure are you about the ppm values of items with hidden cooldowns? The cooldowns must make it very tricky to find ppms, maybe those procs are not even ppm based. You're saying that it will take about 25 sec for the proc to go off again, I think that is ay too long. I have no hard evidence but a lot of people are saying that the proc comes up again after 45 sec much quicker than that. Not that "a lot of people" is particularly trustworthy, maybe you're basing it on solid data.

The bad thing is, is its just a guess and there's no real solid data for this particular item, I just based it off of our [Dragonspine Trophy] data which seemed to be tested out the rear.

Grim13 · 04/21/08, 11:58 AM

Originally Posted by Rezarel

In Warrior_Sim.xls, page sExe1 (and all the other similar mechanics pages), cell H47 (the DW Execute cooldown) uses the formula

=IF(B21=E21,B21,H48/((H48/L10)+H52))

B21 and E21 are the base MH and OH weapon speeds. If they're equal, then it sets the DW Execute cooldown to the un-hasted MH speed B21, ignoring the effects of flurry, heroism, and haste rating. I think this is part of why the sheet penalizes matched speed weapons during executes so much. The correct formula should be

I see what you mean, I'll get that handled ASAP. Sorry for the delay guys. Just got back from vacation. Lots of parts I don't remember, but based on how much damage my Jeep and myself have suffered, and how much less .45 ACP and 12 ga. ammo I now have, it seems to have been a very fun time. I'll try and get something done with the sheet this week, but no promises.

Koshnek · 04/22/08, 12:13 PM

Hey, the Shard of Contempt is way better than the Hourglass of the Unraveller, isn't it? I have those two and Bloodlust Broach available to me at the moment. My DPS gear is t4/t5 level...except my shoulders, heh.

stompingbull · 04/22/08, 12:45 PM

i cant get the dps spreadsheet to work on my computer, it just errors out.
i am trying to plug in my current gear and spec and see which is the bigger dps upgrade for me, the new badge ring, or the badge axe. if someone has the spare time and feels like it,

The World of Warcraft Armory

i would greatley appreciate it. from what i can see i think the axe is the bigger upgrade then the ring.

I know cats edge is better, or jihnrock, or kaels, but we havent downed kael, and jihn rock has not dropped in 45 kills. we are f'n around in hyjal, but cant make it past first boss atm.

Giantlol · 04/22/08, 3:16 PM

Originally Posted by Koshnek

Hey, the Shard of Contempt is way better than the Hourglass of the Unraveller, isn't it? I have those two and Bloodlust Broach available to me at the moment. My DPS gear is t4/t5 level...except my shoulders, heh.

Shard is probably hands down the best trinket you can get for a dps warrior. Expertise is just too good, plus it has a decent proc.

Slik · 04/22/08, 4:28 PM

Has anyone else noticed, when setting all the gear sets to 'none' and talent spec the same, that 'gear 1' and 'gear 6' yield an additional dps value than gear sets 2 - 5?

Modrack · 04/22/08, 4:31 PM

Originally Posted by Giantlol

Shard is probably hands down the best trinket you can get for a dps warrior. Expertise is just too good, plus it has a decent proc.

Dragonspine Trophy is actually slightly better, and should definitely be used by fury warriors. As arms the dps loss is small enough that shard is worth it for greater ease of slam rotations. Assuming your second trinket is always sapphire of course.

Koshnek · 04/23/08, 3:20 AM

Alright, thanks. I thought it was, but I just wanted to double check :-).

One more question, I'm still using Ragesteel Shoulders. I have the new Shoulderplates of Everlasting Plate from Magisters, but it shows up as less DPS, is that right or did I mess up? The rest of my DPS gear is T4 or T5 quality, except those stupid shoulders.

Gruntle · 04/23/08, 8:20 AM

Ragesteel are better than Everlasting pain ones. Ragesteel shoulders are better than everything until you get T5 or Hydross shoulders.

Of course if you need some extra survivability the Everlasting pain shoulders are a better, but for pure dps you lose slightly by going for them.