WotLK DPS spreadsheet - Page 100

Shandara · 01/30/09, 1:32 PM

Update:

- Swift Skyflare Diamond gem requirements fixed
- Solid Sky Sapphire is now a blue gem
- Added Titan-forged Chain Helm/Sabatons of Triumph
- Fixed confirmation dialog on deleting a profile
- Rapid Fire/Kill Shot no longer on GCD
- Fixed bug involving elixirs not loading properly from profiles

Kharthus · 01/30/09, 11:23 PM

One small bug:

Jormungar Leg Reinforcements is showing as 18agi/50stam when it should be 22agi/55stam.

Khallas · 01/31/09, 7:03 PM

I am not sure why this is still in the spreadsheet, but the Mana Oil's cannot be put on level 71+ weapons. Having this included in the default Lvl 80 raid buff profile skews DPS results a little bit.

Grimzim · 02/01/09, 3:23 AM

I have one question regarding the spreadsheet DPS numbers - I'm trying to test my spec and verify the values on the lvl 80 boss target dummy, however I'm ending up with ~300 DPS less than the spreadsheet tells me I should have. As far as I know I entered all data correct, from glyphs to gear, talents, shot rotation, latency etc. - I double checked all tabs of the spreadsheet. I'm using the buff profile with no buffs set and I'm current speced survicval (0/17/54).

Any ideas on what might cause this 10% DPS difference (I'm getting ~2700 DPS instead of ~3000 the spreadsheet models)?

Hunterlin · 02/01/09, 4:11 AM

Deleting my post.
While there are some minor stat differences between char and sheet(sheet have 2 int less than my char), my posted stats where with talents so completely wrong too.

Vitaro · 02/01/09, 7:06 AM

Originally Posted by Grimzim

Any ideas on what might cause this 10% DPS difference (I'm getting ~2700 DPS instead of ~3000 the spreadsheet models)?

You must be doing something wrong. I've tested a Survival spec similar to yours with worse gear and gotten up to 3.2k at the heroic boss dummy. Are you properly letting Explosive Shot do all of it's ticks while under TnT? Did you get the highest rank in ES from the trainer? Most likely you did or you'd be hard pressed getting to 2.7k in the first place. Are you certain that you are standing outside of 30 yards range for Sniper Training?

The spreadsheet is not wrong in projecting 3k for your gear level: In fact I think that's on the low side - you should actually be doing about 10% more.

Grimzim · 02/01/09, 7:55 AM

Originally Posted by Vitaro

You must be doing something wrong. I've tested a Survival spec similar to yours with worse gear and gotten up to 3.2k at the heroic boss dummy. Are you properly letting Explosive Shot do all of it's ticks while under TnT? Did you get the highest rank in ES from the trainer? Most likely you did or you'd be hard pressed getting to 2.7k in the first place. Are you certain that you are standing outside of 30 yards range for Sniper Training?

The spreadsheet is not wrong in projecting 3k for your gear level: In fact I think that's on the low side - you should actually be doing about 10% more.

Thanks for reply - that answers my question regaring correctness of the spreadsheet and modeling of unbuffed target dummy DPS. I checked everything and I assume it's coming from a bugged / wrong Recount version - after updating my addons I get much higher values now (~3k to 3.3k DPS).

ahhzz · 02/01/09, 8:36 AM

Where did the Custom Trink spot go? And while I REALLY appreciate you taking this up from Cheeky, Shan, Is there a reason you keep pulling out more and more gear as you go?

Nooska · 02/01/09, 8:37 AM

Originally Posted by ahhzz

Where did the Custom Trink spot go? And while I REALLY appreciate you taking this up from Cheeky, Shan, Is there a reason you keep pulling out more and more gear as you go?

More and more of the gear becomes useless in regards to the spread sheets purpose.

Shandara · 02/01/09, 9:01 AM

Originally Posted by ahhzz

Where did the Custom Trink spot go? And while I REALLY appreciate you taking this up from Cheeky, Shan, Is there a reason you keep pulling out more and more gear as you go?

There never was a custom trinket spot.

And the main reason I'm removing old gear is that it needlessly bloats and slows down the spreadsheet. I can not imagine anyone interested in raid dps (which is what this sheet is designed for) will be wearing pre-TBC gear at this point.

I understand people are interested in leveling and maybe 5-man gearing, but that isn't really what this sheet is aimed at.

ahhzz · 02/01/09, 9:29 AM

Using Darkmoon Crusade right now. Haven't found anything better yet.

TrevvyTrev · 02/01/09, 10:55 AM

Originally Posted by ahhzz

Using Darkmoon Crusade right now. Haven't found anything better yet.

I thought trinkets weren't supposed to be removed anyway, but in any event you probably did find something better, but didn't know it. Using an older version of the spreadsheet that still has the Darkmoon Card: Crusade, I got increased dps by upgrading it to WotLK quest rewards, like Fezzik's Pocketwatch, for example.

jmlsteele · 02/01/09, 11:56 AM

Going through the spreadsheet trying to get it to work in OOo (don't expect anything amazing, just looking at base functionality thus far) and If I find any errors I'll report them back to you as I find them.

Calculations.B19: TrueShotRankSet should be TSARankSet

Syreesaebe · 02/01/09, 9:12 PM

On the next spreadsheet update, would be good to get an option to customise the two trinket slots.

Vaxum · 02/02/09, 4:21 AM

Bug report - [Arcanum of Ferocity] is incorrectly adding 10% haste on top of the base stats.

Calculations!H22 is doing a test of "=IF(Gear!B22=Head!A45,1.01,1)*...", comparing the selected head enchant to "Arcanum of Ferocity" in Head then adding 10% haste. This looks like a bad reference (should be to Head!A46, not A45), and also vestige of old code where Arcanum of Rapidity added 10% haste, not +10 haste rating - so even Arcanum of Rapidity would now be wrong.