In Q19 of the sExe1 tab on the Warrior_Sim.xls sheet (among other tabs and cells) it appears that the formula's a bit off. Here's the formula used for calculating rage gen:
We all know how reliable a freely-editable resource like WoWWiki is, but based on the rage gen forumla there shouldn't it be this instead?
I'm probably reading it wrong or just suck at this but wanted to clarify either way.

Rage per hit does not decrease with haste. I know a lot of people (me included) thought it did -- probably due to testing on the PTR when they first changed the rage gen formula -- but it doesn't. So, the rage formula in the sheet uses the base weapon speed to calculate rage per hit, and then divides by the hasted weapon speed to get rage per second. The formula looks right to me.

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.

Oh, that's good to know. That information could definitely alter some views on the value of haste. Previous discussions I've had were not able to factually determine whether the hasted speed was used for rage gen or the base speed. I assume the testing for this is documented somewhere on these forums. I'll see if I can find it. If you have a link it would be helpful.

http://elitistjerks.com/f31/t23083-w...p7/#post697493

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.

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

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.

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.

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.

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.

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.

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.

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?

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.

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.

Well, its not big enough of a difference(at least I feel so) as arms to warrant me taking it over a BM hunter/Enh shaman/rogue etc
If only I could say sapphire was my second trinket, alas TK

And yes, Ragesteel>Heroic MgT shoulders, because they are awful -_-

i'll check it out when i can. it turns out my training week got swapped and I wasn't informed until monday afternoon (the class started on monday morning) so, I will be in Tellabs NGX class all week, so don't expect an update till next week.

I'm getting BASIC runtime errors (Incorrect property value) when I open this in OpenOffice.

Sub FixIt(Optional thesheet As String)

is the line that is highlighted by the debugger when I click "Fix it".

However, by clicking "No" when it asks to update links it seems to work, even if it looks pretty screwed up.

It doesn't work in OO, try using the sheet by landsoul (http://elitistjerks.com/f31/t23083-w...adsheet_2_4_a/) if you only have OO.

ok, i am back on the job.

I have a working model for shard of contempt. Looks like it's coming to about 35% up-time for a 2h; about 80 avg. ArPn. That sound about right?