Posted 11 December 2008 - 04:51 AM
Posted 11 December 2008 - 11:00 PM
Posted 12 December 2008 - 05:18 AM
While I hold WoWhead in high esteem, it's not always 100% correct, especially when it comes to drop locations. Mixing normal drops with heroic ones is a known issue there and this shield is a good example. If you check it on Armory, you'll see only "The Eye of Eternity" as a drop location, which means 10-man version (25-man would be listed as "The Eye of Eternity (Heroic)"). Items that drop in both versions are listed like this.
There are actually quite a few Naxx items that wowhead has listed as "Drops in both Normal and Heroic". I can't personally verify that info so I simply trust that it is true. However, on the sheet I just list those items as Naxx10, because it helps you get a sense of how difficult it is to obtain, and that's primarily how I use the source column.
There is a change to that in the lastest PTR patch notes - it will be 50 Stamina instead of 500 HP.
- added 500 HP bonus for miners
Posted 14 December 2008 - 08:06 PM
Posted 16 December 2008 - 08:34 AM
AC Str Agi Sta Def Dod Par Res Blk BV Hit Crit Exp AP Has ArP B R Y
1.0 3.5 8.1 14.0 10.5 8.8 7.6 0.0 3.5 4.0 4.0 1.1 5.0 0.5 0.8 1.2 336 238 252
1.0 3.3 8.3 11.3 9.4 8.8 6.7 0.0 5.0 3.5 3.0 1.2 13.8 0.5 1.0 1.4
From everything I have read from responses Expertise weighs so high since it works till Parry cap? I just figured as Tauren Stamina would still hold higher weight per point. Just curious is all since I want to make sure I am working towards best in slot based on overall stats. Thanks for help, was just concerned with I saw + hit so low when I am only at +164 rating.
Posted 16 December 2008 - 08:41 AM
I just figured as Tauren Stamina would still hold higher weight per point.
Remember that Endurance only increases base health by 5% now.
Posted 16 December 2008 - 09:31 AM
Posted 16 December 2008 - 03:53 PM
However, the huge caveat is that many (most?) of the hardest hitting bosses do not parry-haste. So if you're gearing for Patchwerk, make sure you select him on the Options sheet. The parry-haste math doesn't apply to trash pulls either, so it's probably not the best general gearing strategy for heroics. All these factors lead me to give it a value of 5 on the GearList, for general gearing.
When we get a list of bosses that DO parry-haste, then we'll know when to gear for expertise, but AFAIK no raid bosses have been confirmed to parry-haste yet. As always, I'll try to watch out for more info, but I'd love for someone to bring it to me if they find something reliable.
Posted 18 December 2008 - 09:32 AM
Stats: The formula at Numbers!$B$14 appears to be incorrect for Tauren hp calculation. It is adding 478hp if Tauren and assuming a base health of 7941 this number should be 7941 * .05 = 397.05?
Posted 18 December 2008 - 06:34 PM
- changed base miss rate vs a boss to 8% (was 9%)
- changed crit depression from attacking a boss to 4.8% (was 0.6%)
- adjusted Patchwerk settings
- divided Patchwerk into two bosses, one for the MT role and one for the OT role (hatefuls)
- added Snapper Extreme (+hit food)
- fixed a bug with the new gem slot on Neck
- added gem slots for trinkets on the GemChoices sheet (the JC trinket)
- replaced Enchant Shield - Shield Block with Titanium Plating (from PTR, +40 BV)
- added 10man versions of Patchwerk (he hits softer but faster --> block rating / value actually becomes good)
- added Enchant Weapon - Titanguard (from PTR, +75 Sta)
- added Enchant Bracer - Major Stamina (from PTR, +40 Sta)
- added a button to sort everything in the GearList sheet (should work in both Excel and OpenOffice)
- changed Tauren HP bonus to 5% of base health instead of 5% of base health and 5% of health from base stamina
Posted 18 December 2008 - 09:45 PM
- fixed a bug with the threat/dps value of armor/def/dod
- fixed a bug with Gems sheet not getting the correct stat weights from GearList (introduced in the last release)
- added Loatheb to the boss list
- attached different TTL/Burst/Threat/DPS proportions to each boss
- added MagicDPS for bosses, simply gets added to physical DPS without mitigation (for now)
Posted 19 December 2008 - 03:29 AM
Thank you very much for additions to new chants , + hit food and Jcing gem slots that rocks. Love all the hard work you put into this to give us solid way of looking at all options to choose from for upgrades.
Posted 19 December 2008 - 07:58 AM
Posted 19 December 2008 - 12:50 PM
With the last update of the spreadsheet items with block rating/value are rated far superior compared to items without block rating/value than the the spreadsheet version released at 12-05-2008 does.
Is this a bug of the current version or a result of a bug fix?
For example (with TTL and Burst weight equal set to 0.5 and Filler WotLK Boss):
Helm of Vital Protection - 6376 AEP, 0 BR/BV
Valorous Dreadnaught Greathelm - 6247 AEP, 77 BV
Herores' Dreadnaught Greathelm - 5786 AEP, 65 BV
Pauldrons of Unnatural Death - 4651, 0 BR/BV
Valorous Dreadnaught Pauldrons - 4619, 29 BR
Burdened Shoulderplates - 4348, 50 BR
Valorous Dreadnaught Greathelm - 8617 AEP, 77 BV
Heroes' Dreadnaught Greathelm - 7873 AEP, 65 BV
Helm of Vital Protection - 7647 AEP, 0 BR/BV
Burdened Shoulderplates - 6453, 50 BR
Valorous Dreadnaught Pauldrons - 6163, 29 BR
Pauldrons of Unnatural Death - 5374 0 BR/BV
Posted 19 December 2008 - 01:15 PM
Posted 19 December 2008 - 01:24 PM
Posted 19 December 2008 - 02:50 PM
If you don't use the calculated conversions then your are not optimising as they take into account hit/expertise cap, DR on dodge/parry etc.
TLDR: Yeah, plug in your gear and copy numbers to the line above.
Posted 19 December 2008 - 03:30 PM
To answer the other question about the calculated conversions - yes, you need to copy the calculated values to the line above. I don't want to force people to use the calculated values because the basic function of the sheet is to allow people to rate gear based on whatever criteria they see fit. I see the calculated values as a recommendation and nothing more, so you have to act on that advice in order for it to affect the gear rankings.
Furthermore, if you try to link the values in with the calculations Excel will error out. This is because the sheet makes a few choices based on stat weights, so there is a logical loop if you try to hardcode the calculated values to automatically become the real values.
0 user(s) are reading this topic
0 members, 0 guests, 0 anonymous users