WotLK DPS spreadsheet - Page 29

Decker · 11/26/08, 5:28 PM

Bug:

Bright Cardinal Ruby is listed as a "Yellow" socket.

Shandara · 11/26/08, 5:42 PM

Originally Posted by SpartanKillian

Edit: I also noticed that when I test the 53/11/7 build and set my rotation priorities to Beast Within/Rapid Fire/Serpent Sting/Steady Shot, my Rotation Test tab still calculated Readiness at 3.20... despite refreshing. I can't seem to find a way to disable Readiness and it's obviously throwing non 50/21/0 numbers off. Any suggestions?

I'm not sure what you mean here. You don't put Readiness in your rotation and you have no talent points in it, yet it shows up in the Shot Rotation Test?

SpartanKillian · 11/26/08, 5:58 PM

Originally Posted by Shandara

I'm not sure what you mean here. You don't put Readiness in your rotation and you have no talent points in it, yet it shows up in the Shot Rotation Test?

That's what happened--Readiness would remain in the Rotation Test calculations and affect other abilities accordingly even if I was untalented and didn't include it in my priority list. I was using v78; I switched to 78a and the problem isn't replicated, so I suppose it's no big deal after all. Thanks for all your work on this.

• Tsook · 11/26/08, 6:27 PM

Originally Posted by Faerdael

Regarding AP vs Agility thresholds, yes there are breakpoints, where one becomes better than the other. On the spreadsheet, I can take my lvl 70 raid gear (bad crit), slap 5000 attack power into the hand adjust field and 1 agility overtakes 2 ap again. Heck, I can even add 10k AP and 1 crit > 1 agil > 2 ap. These are extreme cases, however, and you shouldn't really run into them.

Sure, you'll always be able to *force* agi to be better than AP by throwing a bunch of AP on without a lot of crit. What I was curious about was *with the way Blizzard is itemizing*, is it likely to hit that point. That's why I compared at three actual gear levels that are attainable in game right now. Obviously until we see how Tier 8 and 9 are itemized we can't say for sure whether it will, in fact, hit the inflection point, but I attempted to demonstrate with real-world stats that the spreadsheet's valuation looks likely to cross with gear attainable this expansion.

KergeKacsa · 11/26/08, 6:56 PM

2 missing thing when imported from Armory:
Hauberk of Arcane Wraith
Enchant Feet - Icewalker

Shandara · 11/27/08, 3:43 AM

I'm nearly done with adding the Blacksmithing belt buckle. I just need a few profiles to test it on. None of my guildies use the belt buckle at this moment.

Preferably I'd want to have one belt without natural sockets, a belt with 1 socket and a belt with 2 sockets and see how each of them is handled by the Armory when a Prismatic Socket is added.

Azurei · 11/27/08, 3:50 AM

[Treads of the Icewalker] is listed as Icewalker in the tooltip. The Text field for it is currently set to the bonuses and is not being recognized in v78a. [Titanium Weapon Chain] is listed as Titanium Weapon Chain in the tooltip and is not in the v78a version of the sheet, if you would please add it. Thanks.

One more thing I forgot...
[Aviary Guardsman's Hauberk] is listed as Aviary Guard(-s)man's Hauberk in v78a.

Smoggers · 11/27/08, 5:55 AM

Anyone else experiencing strange results as far as health / mana are concerned? I've doublechecked my gear / spec / level / race and anything else I could think of, and my health is still a full 4k short and my mana over 2k short.

To see what I mean, you can quickly load me directly from armory (Smogh - Frostwolf - US) on the gear and talents page, and then compare my health on armory and my health in the spreadsheet. They aren't even close.

edit: I seem to have gotten it working. All I changed was a single gem and suddenly my health and mana values snapped back to their appropriate level. Not entirely sure what happened, but the issue has been resolved.

Mathorli · 11/27/08, 5:57 AM

Originally Posted by Shandara

I'm nearly done with adding the Blacksmithing belt buckle. I just need a few profiles to test it on. None of my guildies use the belt buckle at this moment.

Preferably I'd want to have one belt without natural sockets, a belt with 1 socket and a belt with 2 sockets and see how each of them is handled by the Armory when a Prismatic Socket is added.

My belt has one natural socket and then the buckle.
The World of Warcraft Armory
Sorry I cant help with the rest.

Shandara · 11/27/08, 8:13 AM

Originally Posted by Smoggers

Anyone else experiencing strange results as far as health / mana are concerned? I've doublechecked my gear / spec / level / race and anything else I could think of, and my health is still a full 4k short and my mana over 2k short.

To see what I mean, you can quickly load me directly from armory (Smogh - Frostwolf - US) on the gear and talents page, and then compare my health on armory and my health in the spreadsheet. They aren't even close.

edit: I seem to have gotten it working. All I changed was a single gem and suddenly my health and mana values snapped back to their appropriate level. Not entirely sure what happened, but the issue has been resolved.

I only have the correct base stats for Night Elf hunters at the moment (since I could just record them while leveling). I still need the base stats for all levels for all other races. Or at least the correct level 80 base stats.

@Mathorli:
Checking your Armory profile you mean Vereesa's Chain Belt? If so, the Armory isn't showing the extra socket yet. It does seem to provide the info with the item-tooltip.xml, though. This will take a bit more thinking.

@Bomzix below:
There's a bug with the Ranged Weapon comparison at the moment, because I finished adding all possible socket bonuses (like haste and Mp5) to all items (including ranged). This bug means the code doesn't update the DPS numbers for all ranged weapons properly. Will be fixed when I hopefully release a new version tonight.

bomzix · 11/27/08, 8:23 AM

Using a Nesingwary 4000 it shows a Delta of 352,70 on Accursed Bow of the Elite, pretty sure it's a bug. Can you confirm this?

Bomzix

flimflam · 11/27/08, 10:49 AM

A few item typos i found:

Feet: Crippled Threads should be Crippled Treads

Ranged Weapon: Nerubian Conqueror should be Nerubian Conquerer

Gloves: Gloves of Calculated Risks should be Gloves of Calculated Risk

This is using version 78a.

Thanks for all the hard work on this spreadsheet!

Mathorli · 11/27/08, 2:37 PM

Originally Posted by Shandara

-snip
@Mathorli:
Checking your Armory profile you mean Vereesa's Chain Belt? If so, the Armory isn't showing the extra socket yet. It does seem to provide the info with the item-tooltip.xml, though. This will take a bit more thinking.
-snip

Yes that is the belt. I put on the extra socket right when I got it so I assume its not an Armory update issue.
Does anyone else have a profile to confirm it doesn't show on the Armory?

Xeno · 11/27/08, 5:46 PM

Spreadsheet 78a, calculations tab, E51 isn't counting 3% crit damage on [Chaotic Skyflare Diamond]. Thanks for all the work.

Shandara · 11/28/08, 7:08 AM

Originally Posted by Xeno

Spreadsheet 78a, calculations tab, E51 isn't counting 3% crit damage on [Chaotic Skyflare Diamond]. Thanks for all the work.

Update:

- Fixed some item/enchant names
- Added some belt enchants, including prismatic sockets
- Some pet talents now fixed to only work if the pet is the right family (armor/hp talents)

Adding the Blacksmith belt socket unfortunately will break gear import. Saved talent specs and buff profiles will load. I've tested the belt buckle with a few a profiles of users who have it, but unfortunately the Armory isn't displaying it properly. The sheet tries to 'guess' whether the buckle is used depending on the number of gems socketed (the Armory only displays the gems in the natural socket, but the XML tooltip source does give us all gems). Let me know if it breaks on your specific belt item.

EDIT:
Small re-upload. I'd forgotten to clear out some stuff on the Overview page. There's now a Pawn rating window there, which uses the listing given earlier in this thread. It bases the gems on the 'default gems' for each socket-type, so you can customise that with the custom values on the settings tab.

EDIT:
Small fix made to profile saving, should work now.

Lerastes · 11/28/08, 6:31 PM

Shandara, have you ever considered working with an AddOn author to try and work some of your calculations into a WoW addon to display how certain talents affect DPS or if items would be DPS upgrades?

thehittmann1981 · 11/28/08, 10:46 PM

Originally Posted by Lerastes

Shandara, have you ever considered working with an AddOn author to try and work some of your calculations into a WoW addon to display how certain talents affect DPS or if items would be DPS upgrades?

Something like cat points?

Lerastes · 11/29/08, 8:02 AM

I'm not sure if this is just me but I can't seem to get BM to ever be higher DPS than Marksmanship. These are the two specs I was using.

Talent Calculator - World of Warcraft 15/51/5 MM with a wolf pet
Talent Calculator - World of Warcraft 54/12/5 with a devilsaur pet

The gear in both profiles is the same as my armory. I set the proper shot rotations, set pet skills, set glyphs, etc. But the MM build and wolf pet and the debuffs/buffs my raid usually has is 2906 and BM is 2680. Am I missing something?

dragoonvengance · 11/29/08, 8:11 AM

Originally Posted by Lerastes

Shandara, have you ever considered working with an AddOn author to try and work some of your calculations into a WoW addon to display how certain talents affect DPS or if items would be DPS upgrades?

Shandara just implemented pawns import format.... So you can tell what items are upgrades..

Lerastes · 11/29/08, 8:14 AM

Originally Posted by dragoonvengance

Shandara just implemented pawns import format.... So you can tell what items are upgrades..

Yes, but it does not support talent DPS, anything pet related, or buffs/debuffs.

dragoonvengance · 11/29/08, 8:15 AM

Shandara,

I just did Aurchcavon Vault's last boss in the 25man raid. Rarly had to move and it was mainly just me shooting. The end DPS of the fight was 2056 for my scorpid and 2053 for me. When I imported everything into the spread sheet and setup all of the buffs ect. The spreadsheet had my pet 99.9% accurate. Including how much dps his sting would do and his normal melee.

But for myself the sheet was only saying I should of done 1600ish DPS. Would anyone have any clue what could factor into that large of a disparity.

Here is my armory link I have only changed my gear a little since yesterday.

The World of Warcraft Armory

Joheltro · 11/29/08, 8:37 AM

Profile saving is still bugged with version 78b.
Seems the belt is screwing it up, looks like maybe the enchant colum. So everything below that gets one place to high.

/Edit - Bah, Ninja updates confused me, Im used to changed version numbers when things change...

Shandara · 11/29/08, 9:20 AM

Originally Posted by Joheltro

Profile saving is still bugged with version 78b.
Seems the belt is screwing it up, looks like maybe the enchant colum. So everything below that gets one place to high.

I should've fixed that with a ninja upload, have you redownloaded after my last edit?

@Lerastes:
The reason BM lags behind is because you don't use buffs. Your pet scales really really well with buffs.

Esoth · 11/29/08, 12:01 PM

Can you add Elixir of Mighty Thoughts (45 int)? I've been curious as to whether using this with the new agi elixir will be better than the new flask.

Osse · 11/29/08, 1:42 PM

Originally Posted by Esoth

Can you add Elixir of Mighty Thoughts (45 int)? I've been curious as to whether using this with the new agi elixir will be better than the new flask.

Hand adjustment is handy when spreadsheet doesn't support something.