Hunter Spreadsheets -- In development - Page 71

alienangel · 03/30/08, 6:16 AM

Small bug report, when I did an Export Buffs from v43 and then imported into v46, it had the Value dropdown for Faerie Fire set to 1 instead of to "Yes". This seems to prevent the -armour value being filled in. There was something similar wrong with Sunders too. Took a while to figure out where I lost ~300dps between the versions

alienangel · 03/30/08, 2:07 PM

Originally Posted by alienangel

Small bug report, when I did an Export Buffs from v43 and then imported into v46, it had the Value dropdown for Faerie Fire set to 1 instead of to "Yes". This seems to prevent the -armour value being filled in. There was something similar wrong with Sunders too. Took a while to figure out where I lost ~300dps between the versions

Also, the load/save buffs buttons don't save the AP value from a pet's custom buffs, even when saving and loading within the same spreadsheet (I was trying to simulate the effect of Unleashed Rage on a pet by just putting 10% of its AP in custom buffs line - it would be sweet if you could just make Unleashed Rage one of the pet buffs available, since it does add a fair bit to pet DPS).

Juggling different group compositions, it looks like for me, in order of increasing DPS, groups are:

3:2 rotation grouped with Spriest and Resto Shaman: 2049 dps
1:1 rotation grouped with feral druid: 2090 dps
1:1 rotation grouped with warrior and enhancement shaman: 2113 dps

None of those values consider heroism though, which isn't available in the feral druid group

Fleabite · 03/31/08, 12:11 PM

On target Debuffs if I change Expose weakness to "yes" so its present...I actually lose dps, something looks slightly odd with it :S

abron · 03/31/08, 2:56 PM

Some small things you could maybe add, the possiblility to put both scrolls on the pet, an int buff for the pet because i'm really looking forward to give my no-go-caster-pally-windserpent some testings, more crit per agi AND spellcrit what eventually turns out great with nice gear and endgame buffs. I'm really looking forward to p3 on sunwell when the new weappon-oils get available and maybe dualwielding them both is the way to go.

thanks and much respect for your great work!

Cheeky · 03/31/08, 3:50 PM

Originally Posted by abron

Some small things you could maybe add, the possiblility to put both scrolls on the pet, an int buff for the pet because i'm really looking forward to give my no-go-caster-pally-windserpent some testings, more crit per agi AND spellcrit what eventually turns out great with nice gear and endgame buffs. I'm really looking forward to p3 on sunwell when the new weappon-oils get available and maybe dualwielding them both is the way to go.

thanks and much respect for your great work!

Just an FYI - I have no plans to model caster pets.

◊ Lactose · 03/31/08, 4:14 PM

Originally Posted by Cheeky

Just an FYI - I have no plans to model caster pets.

Based on what I've seen in a completely buffed raid (including both scrolls, pet food, etc), it's not worth it either.

Rifeus · 03/31/08, 7:24 PM

This question might be rather dumb, but under the "Haste Breakdown" -> "Cycle Time" is that your attackspeed under the diffrent haste effects?

Rokh · 04/01/08, 11:42 AM

Some info and suggestions on how to model the Proc from [Shattered Sun Pendant of Might], the Exalted Shattered Sun Offensive Necklace. It seems both versions (Aldor, and Scryer) have an internal cooldown of 45 seconds, and proc quite often after that is up; I had procs in the same 50 seconds of testing, 45 seconds apart. The Aldor version is a 200ap proc for 10 seconds, while the Scryer proc is weaker at a straight arcane blast of 350 damage. This breaks down to about 44 AP static for the Aldor version, and about 7.7dps static for the Scryer version, excluding crits and such.

What you'll have to do is have 2 versions of the neck, for example, "Shattered Sun Pendant of Might (Aldor)" and "Shattered Sun Pendant of Might (Scryer)". Should be simple enough to do, although reading it from the armory would be impossible I imagine. But as long as people are sure to change it by hand it shouldn't be a problem.

For me personally, being Aldor makes this an actual upgrade for me. I'll be testing it tonight in a full raiding situation, but from what I'm seeing on Dr. Boom it's promising.

Garf · 04/02/08, 9:27 PM

First, Cheeky, thanks a lot for your efforts with this sheet!

I especially love the evaluation of stat values on the settings and results page - plugging this into Pawn allows great ingame gear evaluation at a glance.

However, using Open Office 2.1, I cannot seem to get that page to update according to my changes. This is clear since changing gear or even talents does not change the values for me.

Am I missing something obvious here? Is this simply not supported in the OO version?

baldeagle · 04/02/08, 10:43 PM

are there any plans to incorporate some of the trinkets form heroic Mag Terrace run? Such as Shard of Contempt? I cannot use custom gear for this since it is a trinket and there is not a trinket option on the custom gear tab. Any suggestions?

◊ vank · 04/02/08, 11:30 PM

At the bottom of the gear page there is a row marked "Hand Adjust". Use that.

Cheeky · 04/03/08, 4:54 PM

Originally Posted by Garf

First, Cheeky, thanks a lot for your efforts with this sheet!

I especially love the evaluation of stat values on the settings and results page - plugging this into Pawn allows great ingame gear evaluation at a glance.

However, using Open Office 2.1, I cannot seem to get that page to update according to my changes. This is clear since changing gear or even talents does not change the values for me.

Am I missing something obvious here? Is this simply not supported in the OO version?

It requires Visual Basic scripts to execute. OO has no support for Visual Basic. Sorry.

Its also still bugged on automatically updating for gear changes. I keep forgetting to fix that, but one day I'll remember. (And we'll all have flying cars too.)

The CalcAttributes button does work perfectly well.

Driga · 04/04/08, 2:14 PM

I don't see the new alchemist's stone -- Assassin's Alchemist Stone -- in the spreadsheet. Could it be added?

Cheeky · 04/04/08, 4:40 PM

Originally Posted by Driga

I don't see the new alchemist's stone -- Assassin's Alchemist Stone -- in the spreadsheet. Could it be added?

Sure.

Zearon · 04/04/08, 8:36 PM

tell me plz... why in spreadsheet X-bow of relentles strikes (the one for 150 bages) shows lower dps than Illidan's bow or Archimonde's?
this is an only high content bow with 2.8 speed

P.S: beastmaster 41/20/0
gear: 4xt6+forest prowler+ etc + etc. 3/2 rotation

thanks

KraxisSingular · 04/05/08, 12:23 AM

Originally Posted by Zearon

tell me plz... why in spreadsheet X-bow of relentles strikes (the one for 150 bages) shows lower dps than Illidan's bow or Archimonde's?
this is an only high content bow with 2.8 speed

P.S: beastmaster 41/20/0
gear: 4xt6+forest prowler+ etc + etc. 3/2 rotation

thanks

There's your answer likely. THe crossbow really cuts it close on a 3:2 rotation.

ahhzz · 04/05/08, 12:43 AM

Shard of Contempt missing and thanks

and didn't we used to have a custom Trink spot? thanks again

Rifeus · 04/05/08, 10:28 AM

Expertice rating doesn't add to a hunters dps, makes the trinket pretty horrible so who cares if it's there or not. :x

baldeagle · 04/05/08, 11:26 AM

Originally Posted by Rifeus

Expertice rating doesn't add to a hunters dps, makes the trinket pretty horrible so who cares if it's there or not. :x

Of course you're right about the expertise factor, but the extra 230 AP for 20 secs procs every 45 secs. Yes, the Shard of Contempt is primarily a melee class trinket, but any trinket that provides 230 AP that procs that often is worth considering for a hunter.

That's why I want to check it out in the spreadsheet. Vank, thanks for the suggestion to use the hand adjust at bottom of gear page. Only issue there is not sure how to hand adjust for the proc.

Sandrielle · 04/05/08, 12:29 PM

hello, i love your spreadsheet, its great. if you could be so kind to add Elixir of Demonslaying to the Battle Elixirs 265 AP, cause it is used against Brutallus and i would love to do my calculations with it.

thx a lot for your work, much appreciated

Rifeus · 04/05/08, 12:41 PM

Originally Posted by Sandrielle

hello, i love your spreadsheet, its great. if you could be so kind to add Elixir of Demonslaying to the Battle Elixirs 265 AP, cause it is used against Brutallus and i would love to do my calculations with it.

thx a lot for your work, much appreciated

I don't think you'd be meleeing brutallus anytime soon. Becouse currently it doesn't work with ranged.

Nakari · 04/05/08, 12:42 PM

Originally Posted by Sandrielle

hello, i love your spreadsheet, its great. if you could be so kind to add Elixir of Demonslaying to the Battle Elixirs 265 AP, cause it is used against Brutallus and i would love to do my calculations with it.

thx a lot for your work, much appreciated

Elixir of Demonslaying doesn't affect Ranged Attack Power, so it's useless for Hunters... just stick with Flask of Relentless Assault oder Elixir of Major Agility.

Lonescout · 04/05/08, 6:19 PM

Ok, I have tried to follow all 71 pages of this post.. but how do you take the data from the spreadsheet and create a macro for your shot rotation? I do not have very good control over my hands due to an injury so one button is easier for me to keep up with..

Thanks...

Heaters · 04/06/08, 3:20 AM

I admit, i haven't read through the whole thread, but I am curious: could you tell me the password to unlock the sheets?

oshawa03 · 04/06/08, 4:05 AM

Hey Cheeky!

I was just using your spreadsheet to check out how the new Shattered Sun Pendant of Might stacks up, but I got the impression that the proc on the trinket was not included (since I made an identical 'custom' neck and my dps did not change').

Any plans to add this or is that not possible?

Thanks!

***edit: I just noticed the above posts about suggestions on how to include it into the spreadsheet, so this is obviously known