 |
05/10/09, 8:59 PM
|
#2376
|
|
Glass Joe
|
I really can't see how any hunter could do without this sheet, it really is just absolutely amazing
One thing though (sorry it might have been covered but I have not read all 95 pages of thread) why are we not getting the +3% Crit from Meta Gem "Relentless Earthsiege Diamond"
I also seem to be loosing crit somewhere else as in game my crit is 28.32% with no buffs and on the sheet it only shows 23.52% Crit
EDIT: The sheet also shows that I have 16 gems socketed where in actual fact I only have 13
Last edited by Snaile : 05/10/09 at 9:06 PM.
|
|
|
|
|
05/10/09, 9:45 PM
|
#2377
|
|
Banned
Blood Elf Hunter
Runetotem (EU)
|
Originally Posted by Snaile
One thing though (sorry it might have been covered but I have not read all 95 pages of thread) why are we not getting the +3% Crit from Meta Gem "Relentless Earthsiege Diamond"
EDIT: The sheet also shows that I have 16 gems socketed where in actual fact I only have 13
|
If I have understood you correctly you are asking why you don't get 3% crit from the meta, right? Well, that's how the meta is. It doesn't give you crit (aside from what the Agi gives), what it does provide you with is 3% critdamage. Think of it like Mortal Shots (only it isn't exactly like that, though it along those lines).
The number of gems mentioned can be misleading. But this is only because it tracks the three colours individually, so purple, orange and green all count as two colours each. And a prismatic counts as three. That is why the count seems higher.
|
|
|
|
|
05/10/09, 10:45 PM
|
#2378
|
|
Glass Joe
|
On the gear planner. Am i reading it right? the higher the delta the better the gear? I am seeing Lotrafen at 226.49 and my 2 1-handers at a total delta of 265.23, leading me to believe that they are superior to the polearm.
|
|
|
|
|
05/10/09, 10:49 PM
|
#2379
|
|
Don Flamenco
|
The delta is the difference in DPS. A positive delta means its a DPS gain and a negative means its a DPS loss. They are not the specific DPS value of the item.
|
|
|
|
|
05/11/09, 3:30 AM
|
#2380
|
|
Glass Joe
|
Originally Posted by KraxisSingular
If I have understood you correctly you are asking why you don't get 3% crit from the meta, right? Well, that's how the meta is. It doesn't give you crit (aside from what the Agi gives), what it does provide you with is 3% critdamage. Think of it like Mortal Shots (only it isn't exactly like that, though it along those lines).
The number of gems mentioned can be misleading. But this is only because it tracks the three colours individually, so purple, orange and green all count as two colours each. And a prismatic counts as three. That is why the count seems higher.
|
Sorry looked again and noticed its 3% Crit Damage :s I have always read it as 3% Crit.
I am still loosing crit somewhere then as in game I have 28.32% and on the sheet I have 23.53%
|
|
|
|
|
05/11/09, 3:55 AM
|
#2381
|
|
Great Tiger
Night Elf Hunter
Azjol-Nerub (EU)
|
Originally Posted by Snaile
I really can't see how any hunter could do without this sheet, it really is just absolutely amazing
One thing though (sorry it might have been covered but I have not read all 95 pages of thread) why are we not getting the +3% Crit from Meta Gem "Relentless Earthsiege Diamond"
I also seem to be loosing crit somewhere else as in game my crit is 28.32% with no buffs and on the sheet it only shows 23.52% Crit
EDIT: The sheet also shows that I have 16 gems socketed where in actual fact I only have 13
|
The gem count is more a color count, it shows how much gems match either Red, Yellow or Blue. So multi-color gems will add to both colors.
You're not losing crit, but there's a few factors involved:
a) Your in-game crit displayed is versus a level 80 mob, versus a level 83 you will suffer some. Testing revealed a crit depression of roughly 4.2%.
b) The displayed crit % in the sheet includes procs from talents and gear (i.e. Master Tactician).
c) It also includes buffs on the target
After adding/subtracting all this the sheet ends up at 23.52% _effective_ crit rate.
|
|
|
|
05/11/09, 9:52 AM
|
#2382
|
|
Glass Joe
Dwarf Hunter
Moonglade (EU)
|
Hi im noticing something in the spreedsheet that i canot explain.
When i check how much i benefit from stats i get this numbers:
Agility + 1 1,030 1,030
AP + 1 0,625 1,250
Crit + 1 0,618 0,618 Needed to cap Hit:
Hunter Hit + 1 0,000 0,000 1
Pet Hit + 1 0,000 0,000 1
Int + 1 0,656 0,656
ArP Rating+1 0,783 0,783
Haste + 1 0,499 0,499
Stamina+1 0,000 0,000
Mp5 0,000 0,000
Haste Cap+1: 0,499 Haste to Cap 0
But when i chancge my buffs Drenai aura to NO and food to Snapper Extreme i get these numbers
Agility + 1 0,791 0,791
AP + 1 0,384 0,767
Crit + 1 0,616 0,616 Needed to cap Hit: For Pet:
Hunter Hit + 1 0,000 0,000 -6 -32
Pet Hit + 1 0,000 0,000 -7 -33
Int + 1 0,417 0,417
ArP Rating+1 0,777 0,777
Haste + 1 0,495 0,495
Stamina+1 0,000 0,000
Mp5 0,000 0,000
Haste Cap+1: 0,495 Haste to Cap 0
I wuld like to know whay does the AP fall behind Aggi. As i am BM spec and whay do the numbers chancge so much. Thanks
|
|
|
|
|
05/11/09, 4:04 PM
|
#2383
|
|
chiefly comprised of water
Tsook
Troll Hunter
No WoW Account
|
I was thinking about how to design the UI so that it would be easier to make decisions around hit cap. The way the gear planner works currently, (assuming you are capped), it will nearly always recommend a new piece with hit for any slot that has hit in it already, and discourage a new piece with hit for any slot without hit in it already (because it simply looks at the DPS delta of subtracting the value of the stats on the current item and adding the stats of the new item). This makes it more difficult to make decisions that involve swapping more than one piece in order to stay hitcapped, or evaluate which of several hit-containing items is better in situations where you know you can maintain hit capped regardless with various banked items or gems.
"Assume 100% hit" is useful, and as was just suggested, "Assume 0% hit" could also be useful, but maybe we're thinking about the problem wrong. It doesn't matter where we get the hit from -- in some sense the dps value of hit on an item is interchangeable between items: 10 hit rating on your helm is the same DPS as 10 hit rating on your legs.
It seems like, in the gear planner, a breakdown could make this clearer: have two DPS numbers for each item. One number is how much DPS the item represents excluding the effect of hit, and the second number is just the amount of DPS that the hit on the item represents by itself (I suppose you might also want a third number which is just the total that we see today). So in a slot where you have a hit piece equipped, you can see at a glance that (e.g.) 20 of its DPS value is from the hit on it, and that other option that's 5 slots down in the list is actually much more DPS (if you can get hit capped elsewhere). I think it would still make sense to sort by the total DPS delta, just as it is today, as that's still an accurate representation of what would happen if you made that exact swap and only that swap.
|
|
|
|
|
05/11/09, 7:03 PM
|
#2384
|
|
Glass Joe
|
Gear-less stats at level 80
I'm working on the Rawr.Hunter update and am in need of the base stats for each race at level 80. There is some debate on the variance in base health values used on this sheet. If someone could point me to the source for these values or how they were arrived at that would be greatly appreciated.
|
|
|
|
|
05/11/09, 7:29 PM
|
#2385
|
|
Banned
Blood Elf Hunter
Runetotem (EU)
|
Originally Posted by Thuor
Hi im noticing something in the spreedsheet that i canot explain.
When i check how much i benefit from stats i get this numbers:
Agility + 1 1,030 1,030
AP + 1 0,625 1,250
Crit + 1 0,618 0,618 Needed to cap Hit:
Hunter Hit + 1 0,000 0,000 1
Pet Hit + 1 0,000 0,000 1
Int + 1 0,656 0,656
ArP Rating+1 0,783 0,783
Haste + 1 0,499 0,499
Stamina+1 0,000 0,000
Mp5 0,000 0,000
Haste Cap+1: 0,499 Haste to Cap 0
But when i chancge my buffs Drenai aura to NO and food to Snapper Extreme i get these numbers
Agility + 1 0,791 0,791
AP + 1 0,384 0,767
Crit + 1 0,616 0,616 Needed to cap Hit: For Pet:
Hunter Hit + 1 0,000 0,000 -6 -32
Pet Hit + 1 0,000 0,000 -7 -33
Int + 1 0,417 0,417
ArP Rating+1 0,777 0,777
Haste + 1 0,495 0,495
Stamina+1 0,000 0,000
Mp5 0,000 0,000
Haste Cap+1: 0,495 Haste to Cap 0
I wuld like to know whay does the AP fall behind Aggi. As i am BM spec and whay do the numbers chancge so much. Thanks
|
It's rather simple. It is the bane of BM being so petcentric and not having enough stats that gets transfered to the pet.
Agility is a better scaling stat, however it doesn't beat AP initially due to the amount of damage the pet does in relation to the Hunter.
A newly raiding BM will gain a lot more from AP than Agility because his pet does the amount of damage it does. But he gains new and better gear the pet will slowly lose relative DPS compared to the Hunter. And then at some point it becomes more worthwhile to boost hte Hunter's damage than the pet's.
|
|
|
|
|
05/11/09, 7:31 PM
|
#2386
|
|
Glass Joe
Dwarf Hunter
Lightbringer
|
nm.
Last edited by dangerbird : 05/11/09 at 7:39 PM.
|
|
|
|
|
05/11/09, 9:31 PM
|
#2387
|
|
Glass Joe
Blood Elf Hunter
Caelestrasz
|
Hi. Sorry if this has been mentioned before:-
- Custom gear import from Armory for Ranged Weapon speed seems incorrect, e.g. 2.80 becomes 0.28. It doesn't update the weapon type either, but that doesn't seem to affect anything.
- Custom ranged weapon in the Gear Planner shows as 0 dps when equipped.
|
|
|
|
|
05/12/09, 12:23 AM
|
#2388
|
|
Piston Honda
|
Does the spreadsheet add T8 2pc serpent sting bonus to Chimera Shot - Serpent?
There seems to be a discussion in Marks thread suggesting that it doesn't increase Chimera Shot - Serpent damage.
Also, Dreambinder doesn't seem to have socket bonus implemented.
Last edited by sihyunie : 05/12/09 at 12:55 AM.
|
|
|
|
|
05/12/09, 2:13 AM
|
#2389
|
|
Glass Joe
Night Elf Hunter
Turalyon (EU)
|

Originally Posted by Tsook
I was thinking about how to design the UI so that it would be easier to make decisions around hit cap. The way the gear planner works currently, (assuming you are capped), it will nearly always recommend a new piece with hit for any slot that has hit in it already, and discourage a new piece with hit for any slot without hit in it already (because it simply looks at the DPS delta of subtracting the value of the stats on the current item and adding the stats of the new item). This makes it more difficult to make decisions that involve swapping more than one piece in order to stay hitcapped, or evaluate which of several hit-containing items is better in situations where you know you can maintain hit capped regardless with various banked items or gems.
"Assume 100% hit" is useful, and as was just suggested, "Assume 0% hit" could also be useful, but maybe we're thinking about the problem wrong. It doesn't matter where we get the hit from -- in some sense the dps value of hit on an item is interchangeable between items: 10 hit rating on your helm is the same DPS as 10 hit rating on your legs.
It seems like, in the gear planner, a breakdown could make this clearer: have two DPS numbers for each item. One number is how much DPS the item represents excluding the effect of hit, and the second number is just the amount of DPS that the hit on the item represents by itself (I suppose you might also want a third number which is just the total that we see today). So in a slot where you have a hit piece equipped, you can see at a glance that (e.g.) 20 of its DPS value is from the hit on it, and that other option that's 5 slots down in the list is actually much more DPS (if you can get hit capped elsewhere). I think it would still make sense to sort by the total DPS delta, just as it is today, as that's still an accurate representation of what would happen if you made that exact swap and only that swap.
|
Thank you for pointing this out. I have noticed the same thing also but was reluctant to post about it until I found a solution. What I have been doing lately is taking the calculated attributes values and using them as weights in wowhead. It works quite nicely but it would be great if it could be done directly in the spreadsheet itself.
Brilliant spreadsheet. Keep up the excellent work.
|
|
|
|
|
05/12/09, 2:59 AM
|
#2390
|
|
Great Tiger
Night Elf Hunter
Azjol-Nerub (EU)
|
Originally Posted by sihyunie
Does the spreadsheet add T8 2pc serpent sting bonus to Chimera Shot - Serpent?
There seems to be a discussion in Marks thread suggesting that it doesn't increase Chimera Shot - Serpent damage.
Also, Dreambinder doesn't seem to have socket bonus implemented.
|
Originally Posted by myuu
Hi. Sorry if this has been mentioned before:-
- Custom gear import from Armory for Ranged Weapon speed seems incorrect, e.g. 2.80 becomes 0.28. It doesn't update the weapon type either, but that doesn't seem to affect anything.
- Custom ranged weapon in the Gear Planner shows as 0 dps when equipped.
|
@Shilyunie: It currently applies the bonus to both the main CS damage and the -serpent part. I'm following the discussion and will probably have to make adjustments soon (unless a blizzard dev comes out and tells us it's a bug).
@Myuu:
Run the "ranged weapons" macro button on the Gear Planner after putting in the stats for the custom weapon. The linked dps values on the gear planner for ranged weapons are static and dynamically computed like other slots.
As for the gear import from the Armory, I suspect it is some sort of localisation problem. What locale of Excel are you using?
Last edited by Shandara : 05/12/09 at 3:32 AM.
|
|
|
|
05/12/09, 5:27 AM
|
#2391
|
|
Glass Joe
Dwarf Hunter
Moonglade (EU)
|
Originally Posted by KraxisSingular
It's rather simple. It is the bane of BM being so petcentric and not having enough stats that gets transfered to the pet.
Agility is a better scaling stat, however it doesn't beat AP initially due to the amount of damage the pet does in relation to the Hunter.
A newly raiding BM will gain a lot more from AP than Agility because his pet does the amount of damage it does. But he gains new and better gear the pet will slowly lose relative DPS compared to the Hunter. And then at some point it becomes more worthwhile to boost hte Hunter's damage than the pet's.
|
While that might be the case but i do not touch my gear to get so diffrent results it chancges compared if I am hit capped or not. Basicly if i am missing 1 PT in hit cap the values are; Agility + 1 1,030 1,030
AP + 1 0,625 1,250
Over 1 dps per 1 aggi or 2 AP but when i get hit capped the vaues of aggi and ap fall down a lot to:
Agility + 1 0,791 0,791
AP + 1 0,384 0,767
Wich tells me that I gain a lot less from AP and Aggi before i am Hitcaped. I belive that is not the case and I wonder if that might be a bug.
My armory: The World of Warcraft Armory
Not a native speaker so sorry for misstypes
|
|
|
|
|
05/12/09, 10:52 AM
|
#2392
|
|
Piston Honda
Night Elf Hunter
Laughing Skull
|
Originally Posted by Thuor
Wich tells me that I gain a lot less from AP and Aggi before i am Hitcaped. I belive that is not the case and I wonder if that might be a bug.
My armory: The World of Warcraft Armory
|
Your armoury shows that you have just over 6.80% Hit (223 hit rating). This means that not only are you loosing a significant amount of DPS from lack of hit, your pet only has 6% hit rating (a 2% hit loss for your pet).
However, using +40 Hit food should bring you and your pt up to the hit cap (263).
|
|
|
|
|
05/12/09, 12:02 PM
|
#2393
|
|
Glass Joe
Dwarf Hunter
Moonglade (EU)
|
Originally Posted by Bikiniwax
Your armoury shows that you have just over 6.80% Hit (223 hit rating). This means that not only are you loosing a significant amount of DPS from lack of hit, your pet only has 6% hit rating (a 2% hit loss for your pet).
However, using +40 Hit food should bring you and your pt up to the hit cap (263).
|
Yes i am using Hit food but still havent gotten a response whay do, when I use hit food or get hit capped by other means the value of AP and Aggi point per point fall down so much. Is that supposed to happen or is it a bug.
|
|
|
|
|
05/12/09, 12:18 PM
|
#2394
|
|
Glass Joe
Draenei Hunter
Gorgonnash
|
First off, thank you for keeping the spreadsheet up-to-date and as accurate as possible for us. It's often a thankless job and I'm sure requires a lot more work than people think.
Anyways, I just wanted to point out that Improved Arcane Shot is not modeled in the spreadsheet.
|
|
|
|
|
05/12/09, 1:00 PM
|
#2395
|
|
Glass Joe
|
Originally Posted by Spamurai
Anyways, I just wanted to point out that Improved Arcane Shot is not modeled in the spreadsheet.
|
Not sure why you say that, it is in the calculations section of arcane shot, and you can easily check it by adding the talent points and watching the arcane shot damage change. Make sure you are actually using arcane shot in your rotation.
Last edited by Gorektar : 05/12/09 at 1:10 PM.
|
|
|
|
|
05/12/09, 1:51 PM
|
#2396
|
|
Glass Joe
Draenei Hunter
Gorgonnash
|
You're correct. Somehow my macro security level got changed and it wasn't updating correctly in the calculations tab when updating the rotation.
My bad, thanks for the help!
Last edited by Spamurai : 05/12/09 at 2:09 PM.
|
|
|
|
|
05/12/09, 2:11 PM
|
#2397
|
|
Bald Bull
Worgen Hunter
Whisperwind
|
Calculations!N21 has a check that effective armor is greater than 0, otherwise it just does a 0% armor mitigation. Current discussion suggests this isn't true; you can get a target to negative armor and have it act as a multiplier, meaning you do more damage than an unmitigated attack.
|
|
|
|
|
05/12/09, 2:46 PM
|
#2398
|
|
Von Kaiser
|
Not to speak for anyone, but I believe Shandara stated that he/she was watching the discussion closely and would make the change when/if it was decided for sure, or if a blue comes out and says something specific about it. It will be interesting to see if that's the case, since our gear in Ulduar has so much ArP on it.
|
|
|
|
|
05/12/09, 2:49 PM
|
#2399
|
|
Great Tiger
Night Elf Hunter
Azjol-Nerub (EU)
|
Originally Posted by lawjpbo
I'm working on the Rawr.Hunter update and am in need of the base stats for each race at level 80. There is some debate on the variance in base health values used on this sheet. If someone could point me to the source for these values or how they were arrived at that would be greatly appreciated.
|
They were mostly from in-game testing, values by myself and reports from others. They are in serious need of being re-checked, especially the lower levels.
|
|
|
|
05/12/09, 2:54 PM
|
#2400
|
|
Bald Bull
Worgen Hunter
Whisperwind
|
Originally Posted by Kurianna
Not to speak for anyone, but I believe Shandara stated that he/she was watching the discussion closely and would make the change when/if it was decided for sure, or if a blue comes out and says something specific about it. It will be interesting to see if that's the case, since our gear in Ulduar has so much ArP on it.
|
Shandara already updated the mechanics to those expressed there, it just still has this 0 armor limit.
|
|
|
|
|
|