Not sure what the issue is but when i fix my spec to the same as my armory profile and click recalculate dps im encountered with the gear planner showing everything i currently wear as BIS. Obviously this isnt true as 264 t10 is not superior to 277 yet it is showed as such. Any reason for this or am i simply not using it correctly?
@acer6798:
Check that the setting to hide items above x ilvl is set to something above 277. You might need to scroll to the right on the Gear Planner tab to see it.
*(Deleted with problem solved, thanks everyone)
P.S. it's wierd that it actually fixed the ranking with my trinket slot too (previously the slot I had my normal-DBW on which now has the heroic-DBW correctly ranks higher than that), though the other trinket slot still ranks normal-DBW higher than the heroic version. (Not a big deal though as they will be exclusive anyway)
Select Case SocketBonusStat
Case "Strength":
.Cells(cgRow, 22).value = SocketBonusValue
Case "Stamina":
.Cells(cgRow, 23).value = SocketBonusValue
Case "Agility":
.Cells(cgRow, 24).value = SocketBonusValue
Case "Intellect":
.Cells(cgRow, 25).value = SocketBonusValue
Case "Spirit":
.Cells(cgRow, 26).value = SocketBonusValue
Case "Attack Power":
.Cells(cgRow, 27).value = SocketBonusValue
Case "Critical Strike Rating":
.Cells(cgRow, 28).value = SocketBonusValue
Case "Hit Rating":
.Cells(cgRow, 29).value = SocketBonusValue
Case "Mana per 5 sec.":
.Cells(cgRow, 30).value = SocketBonusValue
Case "Resilience Rating":
.Cells(cgRow, 31).value = SocketBonusValue
Case "Armor Penetration Rating":
.Cells(cgRow, 32).value = SocketBonusValue
Case "Haste Rating":
.Cells(cgRow, 33).value = SocketBonusValue
Case Else:
MsgBox "Unknown socket bonus: " & SocketBonusStat
End Select
Else
'Should never reach this I think. If an item has no sockets this node is not present
MsgBox "Error. Socket node present but no sockets?"
Exit Sub
End If
Else
'No sockets
End If
End With
End If
End Sub
@ taaveti and acer6798: I was having your same issue with items that are of higher ilvl being shown below the items I had equipped - this with a high all red gems as Arp build. After going to the Settings tab and changing not only the red gem but all gems except the meta and the nightmare tear to activate the meta, from agility to arpen by default, I now get correct gear listings in the Gear Planner tab. Hope this helps you too.
As Shandra hinted at, the issue is the result of the gems being assigned by the Gear Planner being different to what you're using in your gear. For example, many profiles use ArPen Red gems but neglect to update the Default Red gem setting. This means that when the Gear Planner calculates the dps value of an item with a red slot, it won't use the ArPen that you're using, but rather the Default Red gem as seen in the settings tab.
The current version is giving the 9% buff to Steady Shot in Ferocious Inspiration in place of the 9% to Arcane. It has been confirmed that it should be in addition to the Arcane buff.
I noticed today by chance that [Marrowstrike] is listed as ilvl 213 in the spreadsheet (ilvl 219 according to wowhead and ingame data via AtlasLoot). I'm not sure if this has any impact for anything whatsoever - except that it looks odd.
Perhaps someone could explain what is going on below as i can't figure out why the spreadsheet
is listing upgrades for a friends gear in the order that is displayed. For example, [Sylvanas' Cunning]
is a 26 dps loss over the currently equipped [Recovered Scarlet Onslaught Cape].
These wierd occurances only happen if all AGI gems are replaced with ARPEN gems.
<Header><Version>V1</Version><Date>2010/03/04</Date><ProfileName>Shandara (Shandara EU-Azjol-Nerub)</ProfileName></Header><Player><Name>Rambozo</Name><Level>80</Level><Realm>Karazhan</Realm><Region>EU</Region><Profession1>Enchanting</Profession1><Profession2>Leatherworking</Profession2><Profession1Level>450</Profession1Level><Profession2Level>450</Profession2Level><Target>WotLK Boss</Target><Glyphs><Major1>Glyph of Serpent Sting</Major1><Major2>Glyph of Kill Shot</Major2><Major3>Glyph of Steady Shot</Major3><Minor1>Glyph of Feign Death</Minor1><Minor2>Glyph of Scare Beast</Minor2><Minor3>Glyph of Mend Pet</Minor3></Glyphs><AltGlyphs><Major1>Glyph of Serpent Sting</Major1><Major2>Glyph of Steady Shot</Major2><Major3>Glyph of Kill Shot</Major3><Minor1>Glyph of Mend Pet</Minor1><Minor2>Glyph of Feign Death</Minor2><Minor3>Glyph of Scare Beast</Minor3></AltGlyphs></Player><Gear><Race>Orc</Race><MainHand><Name>Hellion Glaive (H)</Name><Enchant>Massacre (Two Hand)</Enchant><Gem1>Deadly Ametrine (10 Agi, 10 Crit)</Gem1><Gem2>Fractured Cardinal Ruby (20 ArP)</Gem2><Gem3>None</Gem3></MainHand><OffHand><Name>None</Name><Enchant>None</Enchant><Gem1>None</Gem1><Gem2>None</Gem2><Gem3>None</Gem3></OffHand><Head><Name>Ahn'Kahar Blood Hunter's Headpiece</Name><Enchant>Arcanum of Torment</Enchant><Gem1>Relentless Earthsiege Diamond (21 Agi)</Gem1><Gem2>Fractured Cardinal Ruby (20 ArP)</Gem2><Gem3>None</Gem3></Head><Neck><Name>Collar of Unending Torment</Name><Gem1>None</Gem1><Gem2>None</Gem2></Neck><Shoulder><Name>Ahn'Kahar Blood Hunter's Spaulders</Name><Enchant>Greater Inscription of the Axe</Enchant><Gem1>Fractured Cardinal Ruby (20 ArP)</Gem1><Gem2>None</Gem2></Shoulder><Back><Name>Recovered Scarlet Onslaught Cape</Name><Enchant>Major Agility</Enchant><Gem1>Fractured Cardinal Ruby (20 ArP)</Gem1><Gem2>None</Gem2></Back><Chest><Name>Ahn'Kahar Blood Hunter's Tunic</Name><Enchant>Powerful Stats</Enchant><Gem1>Fractured Cardinal Ruby (20 ArP)</Gem1><Gem2>Fractured Cardinal Ruby (20 ArP)</Gem2><Gem3>None</Gem3></Chest><Wrist><Name>Bracers of the Silent Massacre (H)</Name><Enchant>Fur Lining - Attack Power</Enchant><Gem1>Deadly Ametrine (10 Agi, 10 Crit)</Gem1><Gem2>None</Gem2></Wrist><Hands><Name>Ahn'Kahar Blood Hunter's Handguards</Name><Enchant>Major Agility</Enchant><Gem1>Fractured Cardinal Ruby (20 ArP)</Gem1><Gem2>None</Gem2><Gem3>None</Gem3></Hands><Waist><Name>Waistguard of Deathly Dominion</Name><Enchant>None</Enchant><Gem1>Deadly Ametrine (10 Agi, 10 Crit)</Gem1><Gem2>None</Gem2><Gem3>Fractured Cardinal Ruby (20 ArP)</Gem3></Waist><Legs><Name>Leggings of the Lurking Threat (H)</Name><Enchant>Icescale Leg Armor</Enchant><Gem1>Nightmare Tear (+10 to all stats)</Gem1><Gem2>Glinting Ametrine (10 Agi, 10 Hit)</Gem2><Gem3>Fractured Cardinal Ruby (20 ArP)</Gem3></Legs><Feet><Name>Rock-Steady Treads</Name><Enchant>Icewalker</Enchant><Gem1>Fractured Cardinal Ruby (20 ArP)</Gem1><Gem2>Fractured Cardinal Ruby (20 ArP)</Gem2></Feet><Ring1><Name>Ashen Band of Endless Vengeance</Name><Enchant>Assault</Enchant><Gem1>Glinting Ametrine (10 Agi, 10 Hit)</Gem1></Ring1><Ring2><Name>Saurfang's Cold-Forged Band</Name><Enchant>Assault</Enchant><Gem1>Deadly Ametrine (10 Agi, 10 Crit)</Gem1></Ring2><Trinket1><Name>Banner of Victory</Name><Gem1>None</Gem1><Gem2>None</Gem2></Trinket1><Trinket2><Name>Deathbringer's Will</Name><Gem1>None</Gem1><Gem2>None</Gem2></Trinket2><Ranged><Name>Zod's Repeating Longbow</Name><Enchant>Heartseeker Scope</Enchant><Gem1>None</Gem1><Gem2>None</Gem2></Ranged><Ammo>Iceblade Arrow</Ammo></Gear><Talents><Hunter><BeastMastery><Improved Aspect of the Hawk>5</Improved Aspect of the Hawk><Endurance Training>0</Endurance Training><Focused Fire>2</Focused Fire><Improved Aspect of the Monkey>0</Improved Aspect of the Monkey><Thick Hide>0</Thick Hide><Improved Revive Pet>0</Improved Revive Pet><Pathfinding>0</Pathfinding><Aspect Mastery>0</Aspect Mastery><Unleashed Fury>0</Unleashed Fury><Improved Mend Pet>0</Improved Mend Pet><Ferocity>0</Ferocity><Spirit Bond>0</Spirit Bond><Intimidation>0</Intimidation><Bestial Discipline>0</Bestial Discipline><Animal Handler>0</Animal Handler><Frenzy>0</Frenzy><Ferocious Inspiration>0</Ferocious Inspiration><Bestial Wrath>0</Bestial Wrath><Cat Like Reflexes>0</Cat Like Reflexes><Invigoration>0</Invigoration><Serpent's Swiftness>0</Serpent's Swiftness><Longevity>0</Longevity><The Beast Within>0</The Beast Within><Cobra Strikes>0</Cobra Strikes><Kindred Spirits>0</Kindred Spirits><Beast Mastery>0</Beast Mastery></BeastMastery><Marksmanship><Improved Concussive Shot>0</Improved Concussive Shot><Focused Aim>2</Focused Aim><Lethal Shots>5</Lethal Shots><Careful Aim>3</Careful Aim><Improved Hunter's Mark>0</Improved Hunter's Mark><Mortal Shots>5</Mortal Shots><Go For the Throat>1</Go For the Throat><Improved Arcane Shot>0</Improved Arcane Shot><Aimed Shot>1</Aimed Shot><Rapid Killing>2</Rapid Killing><Improved Stings>3</Improved Stings><Efficiency>0</Efficiency><Concussive Barrage>0</Concussive Barrage><Readiness>1</Readiness><Barrage>3</Barrage><Combat Experience>2</Combat Experience><Ranged Weapon Specialization>3</Ranged Weapon Specialization><Piercing Shots>3</Piercing Shots><True Shot Aura>1</True Shot Aura><Improved Barrage>3</Improved Barrage><Master Marksman>5</Master Marksman><Rapid Recuperation>2</Rapid Recuperation><Wild Quiver>3</Wild Quiver><Silencing Shot>1</Silencing Shot><Improved Steady Shot>2</Improved Steady Shot><Marked for Death>5</Marked for Death><Chimera Shot>1</Chimera Shot></Marksmanship><Survival><Improved Tracking>5</Improved Tracking><Hawk Eye>0</Hawk Eye><Savage Strikes>0</Savage Strikes><Surefooted>0</Surefooted><Entrapment>0</Entrapment><Trap Mastery>0</Trap Mastery><Survival Instincts>2</Survival Instincts><Survivalist>0</Survivalist><Scatter Shot>0</Scatter Shot><Deflection>0</Deflection><Survival Tactics>0</Survival Tactics><T.N.T>0</T.N.T><Lock and Load>0</Lock and Load><Hunter vs Wild>0</Hunter vs Wild><Killer Instinct>0</Killer Instinct><Counterattack>0</Counterattack><Lightning Reflexes>0</Lightning Reflexes><Resourcefullness>0</Resourcefullness><Expose Weakness>0</Expose Weakness><Wyvern Sting>0</Wyvern Sting><Thrill of the Hunt>0</Thrill of the Hunt><Master Tactician>0</Master Tactician><Noxious Stings>0</Noxious Stings><Point of No Escape>0</Point of No Escape><Black Arrow>0</Black Arrow><Sniper Training>0</Sniper Training><Hunting Party>0</Hunting Party><Explosive Shot>0</Explosive Shot></Survival></Hunter></Talents><AltTalents><Hunter><BeastMastery><Improved Aspect of the Hawk>5</Improved Aspect of the Hawk><Endurance Training>0</Endurance Training><Focused Fire>2</Focused Fire><Improved Aspect of the Monkey>0</Improved Aspect of the Monkey><Thick Hide>0</Thick Hide><Improved Revive Pet>0</Improved Revive Pet><Pathfinding>0</Pathfinding><Aspect Mastery>0</Aspect Mastery><Unleashed Fury>0</Unleashed Fury><Improved Mend Pet>0</Improved Mend Pet><Ferocity>0</Ferocity><Spirit Bond>0</Spirit Bond><Intimidation>0</Intimidation><Bestial Discipline>0</Bestial Discipline><Animal Handler>0</Animal Handler><Frenzy>0</Frenzy><Ferocious Inspiration>0</Ferocious Inspiration><Bestial Wrath>0</Bestial Wrath><Cat Like Reflexes>0</Cat Like Reflexes><Invigoration>0</Invigoration><Serpent's Swiftness>0</Serpent's Swiftness><Longevity>0</Longevity><The Beast Within>0</The Beast Within><Cobra Strikes>0</Cobra Strikes><Kindred Spirits>0</Kindred Spirits><Beast Mastery>0</Beast Mastery></BeastMastery><Marksmanship><Improved Concussive Shot>0</Improved Concussive Shot><Focused Aim>3</Focused Aim><Lethal Shots>5</Lethal Shots><Careful Aim>3</Careful Aim><Improved Hunter's Mark>0</Improved Hunter's Mark><Mortal Shots>5</Mortal Shots><Go For the Throat>1</Go For the Throat><Improved Arcane Shot>0</Improved Arcane Shot><Aimed Shot>1</Aimed Shot><Rapid Killing>2</Rapid Killing><Improved Stings>3</Improved Stings><Efficiency>0</Efficiency><Concussive Barrage>0</Concussive Barrage><Readiness>1</Readiness><Barrage>3</Barrage><Combat Experience>2</Combat Experience><Ranged Weapon Specialization>3</Ranged Weapon Specialization><Piercing Shots>3</Piercing Shots><True Shot Aura>1</True Shot Aura><Improved Barrage>3</Improved Barrage><Master Marksman>5</Master Marksman><Rapid Recuperation>1</Rapid Recuperation><Wild Quiver>3</Wild Quiver><Silencing Shot>1</Silencing Shot><Improved Steady Shot>2</Improved Steady Shot><Marked for Death>5</Marked for Death><Chimera Shot>1</Chimera Shot></Marksmanship><Survival><Improved Tracking>5</Improved Tracking><Hawk Eye>0</Hawk Eye><Savage Strikes>0</Savage Strikes><Surefooted>0</Surefooted><Entrapment>0</Entrapment><Trap Mastery>0</Trap Mastery><Survival Instincts>2</Survival Instincts><Survivalist>0</Survivalist><Scatter Shot>0</Scatter Shot><Deflection>0</Deflection><Survival Tactics>0</Survival Tactics><T.N.T>0</T.N.T><Lock and Load>0</Lock and Load><Hunter vs Wild>0</Hunter vs Wild><Killer Instinct>0</Killer Instinct><Counterattack>0</Counterattack><Lightning Reflexes>0</Lightning Reflexes><Resourcefullness>0</Resourcefullness><Expose Weakness>0</Expose Weakness><Wyvern Sting>0</Wyvern Sting><Thrill of the Hunt>0</Thrill of the Hunt><Master Tactician>0</Master Tactician><Noxious Stings>0</Noxious Stings><Point of No Escape>0</Point of No Escape><Black Arrow>0</Black Arrow><Sniper Training>0</Sniper Training><Hunting Party>0</Hunting Party><Explosive Shot>0</Explosive Shot></Survival></Hunter></AltTalents><Pet><Family>Wolf</Family><Level>80</Level><Talents><Cunning><Cobra Reflexes>0</Cobra Reflexes><Dive><Dash>0</Dash></Dive><Great Stamina>0</Great Stamina><Natural Armor>0</Natural Armor><Boar's Speed>0</Boar's Speed><Mobility>0</Mobility><Owl's Focus>0</Owl's Focus><Spiked Collar>0</Spiked Collar><Culling the Herd>0</Culling the Herd><Lionhearted>0</Lionhearted><Carrion Feeder>0</Carrion Feeder><Great Resistance>0</Great Resistance><Cornered>0</Cornered><Feeding Frenzy>0</Feeding Frenzy><Wolverine Bite>0</Wolverine Bite><Roar of Recovery>0</Roar of Recovery><Bullheaded>0</Bullheaded><Grace of the Mantis>0</Grace of the Mantis><Wild Hunt>0</Wild Hunt><Roar of Sacrifice>0</Roar of Sacrifice></Cunning><Ferocity><Cobra Reflexes>2</Cobra Reflexes><Dive><Dash>1</Dash></Dive><Great Stamina>0</Great Stamina><Natural Armor>0</Natural Armor><Improved Cower>0</Improved Cower><Bloodthirsty>1</Bloodthirsty><Spiked Collar>3</Spiked Collar><Boar's Speed>0</Boar's Speed><Culling the Herd>3</Culling the Herd><Lionhearted>0</Lionhearted><Charge><Swoop>0</Swoop></Charge><Heart of the Phoenix>0</Heart of the Phoenix><Spider's Bite>3</Spider's Bite><Great Resistance>0</Great Resistance><Rabid>1</Rabid><Lick Your Wounds>0</Lick Your Wounds><Call of the Wild>1</Call of the Wild><Shark Attack>0</Shark Attack><Wild Hunt>1</Wild Hunt></Ferocity><Tenacity><Cobra Reflexes>0</Cobra Reflexes><Charge>0</Charge><Great Stamina>0</Great Stamina><Natural Armor>0</Natural Armor><Spiked Collar>0</Spiked Collar><Boar's Speed>0</Boar's Speed><Blood of the Rhino>0</Blood of the Rhino><Pet Barding>0</Pet Barding><Culling the Herd>0</Culling the Herd><Guard Dog>0</Guard Dog><Lionhearted>0</Lionhearted><Thunderstomp>0</Thunderstomp><Grace of the Mantis>0</Grace of the Mantis><Great Resistance>0</Great Resistance><Last Stand>0</Last Stand><Taunt>0</Taunt><Roar of Sacrifice>0</Roar of Sacrifice><Intervene>0</Intervene><Silverback>0</Silverback><Wild Hunt>0</Wild Hunt></Tenacity></Talents></Pet><Buffs><Hunter><Greater Blessing of Kings><Value>Yes</Value><Modifier></Modifier></Greater Blessing of Kings><Greater Blessing of Might><Value>Rank 5</Value><Modifier>Improved 2/2</Modifier></Greater Blessing of Might><Battle Shout><Value>Rank 9</Value><Modifier>Com. Pres. 5/5</Modifier></Battle Shout><Commanding Shout><Value>Yes</Value><Modifier>Com. Pres. 5/5</Modifier></Commanding Shout><Greater Blessing of Wisdom><Value>Rank 5</Value><Modifier>Improved 2/2</Modifier></Greater Blessing of Wisdom><True Shot Aura (not you)><Value>Yes</Value><Modifier></Modifier></True Shot Aura (not you)><Leader of the Pack><Rampage><Value>Yes</Value><Modifier></Modifier></Rampage></Leader of the Pack><Arcane Brilliance><Value>Rank 3</Value><Modifier></Modifier></Arcane Brilliance><Fel Intelligence><Value>Rank 5</Value><Modifier></Modifier></Fel Intelligence><Mana Spring Totem><Value>Yes</Value><Modifier>Improved 3/3</Modifier></Mana Spring Totem><Horn of Winter><Value>Yes</Value><Modifier></Modifier></Horn of Winter><Strength of Earth><Value>Rank 8</Value><Modifier>Enhanced 3/3</Modifier></Strength of Earth><Gift of the Wild><Value>Rank 4</Value><Modifier>Improved 2/2</Modifier></Gift of the Wild><Prayer of Fortitude><Value>Rank 4</Value><Modifier>Improved 2/2</Modifier></Prayer of Fortitude><Blood Pact><Value>Rank 7</Value><Modifier>Improved Imp 3/3</Modifier></Blood Pact><Swift Ret & Moonkin Aura><Value>Yes</Value><Modifier>Rank 3/3</Modifier></Swift Ret & Moonkin Aura><Ret Aura & Feroc. Insp.><Value>Yes</Value><Modifier></Modifier></Ret Aura & Feroc. Insp.><Replenishment (Uptime)><Value>Yes</Value><Modifier>1</Modifier></Replenishment (Uptime)><Abo. Might & Unl. Rage><Value>Yes</Value><Modifier>1</Modifier></Abo. Might & Unl. Rage><Draenei racial (not you)><Value>No</Value><Modifier></Modifier></Draenei racial (not you)><Scroll><Value>No</Value><Modifier>None</Modifier></Scroll></Hunter><Personal><1>Blackened Dragonfin</1><2>None</2><3>None</3><4>Flask of Endless Rage</4><5>None</5><6>None</6></Personal><Pet><Greater Blessing of Kings><Value>Yes</Value><Modifier></Modifier></Greater Blessing of Kings><Commanding Shout><Value>Yes</Value><Modifier>Com. Pres. 5/5</Modifier></Commanding Shout><Greater Blessing of Might><Value>Rank 5</Value><Modifier>Improved 2/2</Modifier></Greater Blessing of Might><Battle Shout><Value>Rank 9</Value><Modifier>Com. Pres. 5/5</Modifier></Battle Shout><True Shot Aura (not you)><Value>Yes</Value><Modifier></Modifier></True Shot Aura (not you)><Leader of the Pack><Rampage><Value>Yes</Value><Modifier></Modifier></Rampage></Leader of the Pack><Strength of Earth Totem><Value>Rank 8</Value><Modifier>Enhanced 3/3</Modifier></Strength of Earth Totem><Horn of Winter><Value>Yes</Value><Modifier></Modifier></Horn of Winter><Gift of the Wild><Value>Rank 4</Value><Modifier>Improved 2/2</Modifier></Gift of the Wild><Prayer of Fortitude><Value>Rank 4</Value><Modifier>Improved 2/2</Modifier></Prayer of Fortitude><Blood Pact><Value>Rank 7</Value><Modifier>Improved Imp 3/3</Modifier></Blood Pact><WF Totem & Imp. Icy Talons><Value>Yes</Value><Modifier>Improved 2/2</Modifier></WF Totem & Imp. Icy Talons><Abo. Might & Unl. Rage><Value>Yes</Value><Modifier>1</Modifier></Abo. Might & Unl. Rage><Swift Ret & Moonkin Aura><Value>Yes</Value><Modifier>Rank 3/3</Modifier></Swift Ret & Moonkin Aura><Ret Aura & Feroc. Insp.><Value>Yes</Value><Modifier></Modifier></Ret Aura & Feroc. Insp.><Draenei racial (not you)><Value>No</Value><Modifier></Modifier></Draenei racial (not you)><Scroll of Strength><Value>No</Value><Modifier>None</Modifier></Scroll of Strength><PetFood>Spiced Mammoth Treats</PetFood></Pet><Target><Judgment of Wisdom><Value>Yes</Value><Modifier></Modifier></Judgment of Wisdom><Heart of the Crusader><Value>Yes</Value><Modifier>Improved 3/3</Modifier></Heart of the Crusader><Curse of Elements><Value>Rank 6</Value><Modifier></Modifier></Curse of Elements><Sunder Armor Stacks><Value>Yes</Value><Modifier>5</Modifier></Sunder Armor Stacks><Curse of Weakness><Value>Yes</Value><Modifier></Modifier></Curse of Weakness><Hunter's Mark (not you)><Value>Yes</Value><Modifier>Both</Modifier></Hunter's Mark (not you)><Mangle & Trauma><Value>Yes</Value><Modifier>1</Modifier></Mangle & Trauma><Blood Frenzy & Savage Combat><Value>Yes</Value><Modifier>1</Modifier></Blood Frenzy & Savage Combat><Earth and Moon stacks><Value>Yes</Value><Modifier></Modifier></Earth and Moon stacks><Faerie Fire><Value>Yes</Value><Modifier></Modifier></Faerie Fire></Target></Buffs><Rotation><Aspect>Dragonhawk</Aspect><Latency>200</Latency><Wait Time>800</Wait Time><Hunter Rotation><1>Serpent Sting</1><2>Silencing Shot</2><3>Rapid Fire</3><4>Chimera Shot</4><5>Kill Shot</5><6>Aimed Shot</6><7>Readiness</7><8>Steady Shot</8></Hunter Rotation><Pet Rotation><1>Furious Howl</1><2>Bite</2></Pet Rotation></Rotation><Settings><Carry over %damage bonuses when refreshing Serpent Sting>Yes</Carry over %damage bonuses when refreshing Serpent Sting></Settings><Optimizer><Helm #1>None</Helm #1><Helm #2>None</Helm #2><Helm #3>None</Helm #3><Helm #4>None</Helm #4><Helm #5>None</Helm #5><HelmEnchant>Arcanum of Torment</HelmEnchant><Neck #1>None</Neck #1><Neck #2>None</Neck #2><Neck #3>None</Neck #3><Neck #4>None</Neck #4><Neck #5>None</Neck #5><Shoulders #1>None</Shoulders #1><Shoulders #2>None</Shoulders #2><Shoulders #3>None</Shoulders #3><Shoulders #4>None</Shoulders #4><Shoulders #5>None</Shoulders #5><ShouldersEnchant>Greater Inscription of the Axe</ShouldersEnchant><Back #1>None</Back #1><Back #2>None</Back #2><Back #3>None</Back #3><Back #4>None</Back #4><Back #5>None</Back #5><BackEnchant>Flexweave Underlay</BackEnchant><Chest #1>None</Chest #1><Chest #2>None</Chest #2><Chest #3>None</Chest #3><Chest #4>None</Chest #4><Chest #5>None</Chest #5><ChestEnchant>Powerful Stats</ChestEnchant><Wrist #1>None</Wrist #1><Wrist #2>None</Wrist #2><Wrist #3>None</Wrist #3><Wrist #4>None</Wrist #4><Wrist #5>None</Wrist #5><WristEnchant>Fur Lining - Attack Power</WristEnchant><Melee #1>None</Melee #1><Melee #2>None</Melee #2><Melee #3>None</Melee #3><Melee #4>None</Melee #4><Melee #5>None</Melee #5><MeleeEnchant>None</MeleeEnchant><OffHand #1>None</OffHand #1><OffHand #2>None</OffHand #2><OffHand #3>None</OffHand #3><OffHand #4>None</OffHand #4><OffHand #5>None</OffHand #5><OffHandEnchant>None</OffHandEnchant><Gloves #1>None</Gloves #1><Gloves #2>None</Gloves #2><Gloves #3>None</Gloves #3><Gloves #4>None</Gloves #4><Gloves #5>None</Gloves #5><GlovesEnchant>None</GlovesEnchant><Waist #1>None</Waist #1><Waist #2>None</Waist #2><Waist #3>None</Waist #3><Waist #4>None</Waist #4><Waist #5>None</Waist #5><Legs #1>None</Legs #1><Legs #2>None</Legs #2><Legs #3>None</Legs #3><Legs #4>None</Legs #4><Legs #5>None</Legs #5><LegsEnchant>Icescale Leg Armor</LegsEnchant><Feet #1>None</Feet #1><Feet #2>None</Feet #2><Feet #3>None</Feet #3><Feet #4>None</Feet #4><Feet #5>None</Feet #5><FeetEnchant>Nitro Boosts</FeetEnchant><Rings #1>None</Rings #1><Rings #2>None</Rings #2><Rings #3>None</Rings #3><Rings #4>None</Rings #4><Rings #5>None</Rings #5><RingsEnchant>None</RingsEnchant><Trinkets #1>None</Trinkets #1><Trinkets #2>None</Trinkets #2><Trinkets #3>None</Trinkets #3><Trinkets #4>None</Trinkets #4><Trinkets #5>None</Trinkets #5><Ranged #1>None</Ranged #1><Ranged #2>None</Ranged #2><Ranged #3>None</Ranged #3><Ranged #4>None</Ranged #4><Ranged #5>None</Ranged #5><RangedEnchant>Heartseeker Scope</RangedEnchant></Optimizer>
What are the default gems?
Did you hit recalculate DPS on the gearplanner?
Since it only occurs when switching to ArP gems its 1 of 2 things most likely;
1) The default gem is set to agi (or something else) while ArP is better, meaning that the spreadsheet calculates [Sylvanas' Cunning] with an agi (or other) gem (which is worse than [Recovered Scarlet Onslaught Cape] with ArP gem for example)
2) You switch the stats and the gems but don't recalculate the dps so its still the old calculations for all ites that aren't currently equipped via the gear tab.
It's a bit difficult to track, but it looks like Wild Quiver might not be being adjusted by the "Global Adjust" value for magic damage (on the Overview tab). I was hoping to use this to simulate Hellscream's Warsong / Strength of Wrynn. Alternatively, a separate way to enter that buff wouldn't be a bad thing either.
The value you see there is the dps contribution per point of hit going from 0 hit rating to the hit cap. This does not mean that you should keep stacking hit, but rather that hit is worth that much dps while uncapped.
I have a question about hit chance in the spreedsheet.
I have 99,79% hit chance on top of Gear tab at "Ranged Hit Chance vs. Level 83" and on Calculations tab as "Hit - Unadjusted Total". But below that at "Total" it's says 100%, and calculates with 100,00% at every shot's Hit chance.
Another interesting thing about this:
I have 157 hit rating and 3/3 Focused Aim (99,79% hit chance), and I got 12128,21 DPS.
I have manually adjust 1 more hit, chance become 99,82%, DPS stays the same.
I have manually adjust 2 more hit, chance become 99,85%, DPS stays the same.
I have manually adjust 3 more hit, chance become 99,88%, DPS stays the same.
And the end:
I have manually adjust 7 more hit, chance become 100%, DPS became 12138,76.
(If I manually subtract 1 hit from my rating, the DPS decrease correctly.)
Is this the normal? I think WoW calculates every bit of hit, not rounding it.
For the hunter, it's true that hit chance derived from rating won't be rounded at all. However, going to take a wild guess here, because the variance of hit chance that you applied is too small incrementally (less than 0.1% difference), the spreadsheet shot simulator doesn't detect any difference in miss rate during the 6-minute simulated-fight.
Before 3.2, pet's hit chance is derived from the hunter's hit rounded down. So hunter with 7.99% hit chance would have a pet with 7% hit chance. After 3.2, (when pet's hit, expertise, and spell hit are made to scale in percentage of the hunter's hit; barring bugs such as Focused Aim and Draenei's Heroic presence), I'm not too sure whether this mechanics of pet's hit rounding-down is still in place. I'm assuming that whether this mechanics is still in-game or not, the spreadsheet seems to still be using it in its calculation.
For the hunter, it's true that hit chance derived from rating won't be rounded at all. However, going to take a wild guess here, because the variance of hit chance that you applied is too small incrementally (less than 0.1% difference), the spreadsheet shot simulator doesn't detect any difference in miss rate during the 6-minute simulated-fight.
As I see in the spreadsheet there are no missed shots to simulate hit chance, hit chance is taken into consideration regarding the shot's average damage. (hit chance * possible damage = average damage with missed shots)
In this case the spreadsheet should show some DPS change at even 1 hit rating change. (because the average dmg / shot is changed in the model with a little bit.)
And it's not explain how 99,79% gets to round up to 100,00% at calculations tab.
Before 3.2, pet's hit chance is derived from the hunter's hit rounded down. So hunter with 7.99% hit chance would have a pet with 7% hit chance. After 3.2, (when pet's hit, expertise, and spell hit are made to scale in percentage of the hunter's hit; barring bugs such as Focused Aim and Draenei's Heroic presence), I'm not too sure whether this mechanics of pet's hit rounding-down is still in place. I'm assuming that whether this mechanics is still in-game or not, the spreadsheet seems to still be using it in its calculation.
I tested this recently (on 1.25.2010 to be precise) and the rounding down of pet hit still exists.
I have a question about hit chance in the spreedsheet.
I have 99,79% hit chance on top of Gear tab at "Ranged Hit Chance vs. Level 83" and on Calculations tab as "Hit - Unadjusted Total". But below that at "Total" it's says 100%, and calculates with 100,00% at every shot's Hit chance.
Another interesting thing about this:
I have 157 hit rating and 3/3 Focused Aim (99,79% hit chance), and I got 12128,21 DPS.
I have manually adjust 1 more hit, chance become 99,82%, DPS stays the same.
I have manually adjust 2 more hit, chance become 99,85%, DPS stays the same.
I have manually adjust 3 more hit, chance become 99,88%, DPS stays the same.
And the end:
I have manually adjust 7 more hit, chance become 100%, DPS became 12138,76.
(If I manually subtract 1 hit from my rating, the DPS decrease correctly.)
Is this the normal? I think WoW calculates every bit of hit, not rounding it.
Is it set alliance? Do have best raid buffs enabled? Is it applying the Draeni hit buff to you and your pet? Thats about the only reason I could see it not properly adjusting when your below the hit cap. It should adjust even when you add 1 hit if your anywhere below the cap. It does for me anyway and Im using the current version.
There is something i don't understand in this spreadsheet and i would know if this is just for me or i'm not alone in this case : My stats scale is in this order : hit > int > agi > mp5 > crit > arp > haste > AP > Pet hit > stamina
Why Int before agi and mp5 before crit ? I'm still perplex about it.
And i've got one problem (v 93i) : The profiles' array in "Overview" isn't anymore update even if I Save profile, etc. I've tried a lot of things but nothing seems to work. If someone have any idea about it..
There is something i don't understand in this spreadsheet and i would know if this is just for me or i'm not alone in this case : My stats scale is in this order : hit > int > agi > mp5 > crit > arp > haste > AP > Pet hit > stamina
Why Int before agi and mp5 before crit ? I'm still perplex about it.
As mentioned, if you merely import your gearset and talents, without applying any raid buffs (especially Judgement of Wisdom, Replenishment, Blessing of Wisdom, Arcane Intellect) the spreadsheet or online tool will show that Int and MP5 take precedence over other DPS stats, due to running OOM real fast and having to switch to Viper frequently.
03/01/10, 8:53 AM
Similar Threads
