Elitist Jerks Hunter Spreadsheets -- In development

 03/09/08, 4:05 PM #1636 Glaurong King Hippo     Glauwrong Goblin Hunter   Hyjal The rate that AP converts to Spell Damage for pets is well known and shows up on your pet's character page. It is 12.5% When they nerfed LB they reduced that specific spell's coefficient (It was 100%). If the spell does scale at 1.5% that means it has a 12% coefficient, which is an odd number. The current 1.25% is derived from tests like yours and the assumption they set the coefficient to something simple and arbitrary, 10%. Also, rounding happens in two places, once for AP -> Spell Damage, and again from Spell Damage -> Actual Damage (coefficient). Log Parser for BM Hunters (Right click, save as) - Updated 10/11/2007
03/09/08, 11:04 PM   #1637
Grondarg
Von Kaiser

Orc Death Knight

 Originally Posted by Tiberium As for the speciffic rotation quesion, using /Castrandom is a very efficient way of including additional Arcanes or Multis, however it not modelable. I don't really understand what it is you are trying to get at. The 1 1:5 rotation for me looks like ...A,S,M,A,S,A,S,Ar,A,S,A,S,Ar,A,S repeat Indeed the elements of both that you refer to are why its not modelled or modelable. Bottom line is drop the /Castsequence if you can, if not.... /castsequence reset=3 !Auto Shot, Steady Shot /castrandom Arcane Shot, Multi-Shot Is absolutely fine, just don't expect the spreadsheet to offer a rotation that fits what you see in game using it.
Using this macro the rotation looks like:

A,S,M;A,S,Ar

A typical 1.5 puts an Auto and Steady where i put the semi-colon. So the cooldown timer for Arcance starts almost 4 seconds earlier with the macro i have listed. The reason 1.5 has that extra A,S is because of Autoshot delay. I'm trying to see if the auto delay is going to cost me more dps than it's worth. With the macro i'm testing arcane and multi fire immediately after the Steady because the macro "queue's them up" like the 2:1 Steady macro but doesn't cause the chaining problem that the 2:1 has. So while it's not as good as a perfect 2:1 shot rotation I feel that it is better than a typical 1.5 rotation because it doesnt follow the long chain of /castsequence shots necessary to be accurate with the 1.5 rotation shown in the spreadsheet.

03/09/08, 11:13 PM   #1638
Grondarg
Von Kaiser

Orc Death Knight

 Originally Posted by Littlehelper I don't see why there should be a difference between a pure /castsequence and the mixed macro. With the mixed macro you still got the disadvantage of the /castsequence after the autoshot - you still have to wait for the autoshot to fire at your computer before the steadyshot starts. And after the steadyshot both a pure castsequence and the mixed makro have to wait for your GCD, because the steadyshot finishes about 200ms before the GCD. As long as you have less as 200ms ping, the pure castsequence wouldn't be worse/slower. So actually the mixed macro is not really behaving different than a pure castsequence(as long as you may spam it) and the mixed macro is just written in a shorter way.. so: -> castsequence-option of the sheet should simulate the macro best. (+manually fitting in the shots)
Well if the spreadsheet assumes that your shot rotation has all the shots in a cast sequence macro then it's possibly adding a delay for every shot. When if fact the macro i posted only has to wait on 2 shots and then has arcane or multi fire immediately after steady.

03/09/08, 11:56 PM   #1639
alienangel
Bald Bull

Draenei Hunter

Eredar
 Originally Posted by Tsook In an only tangentially-related issue, [Harbinger of Doom] is incorrectly spelled 'Harbringer of Doom' in the spreadsheet. :P
wow, blast from the past. we used to argue back and forth so much about that dagger's name.

03/10/08, 11:10 AM   #1640
Quizzle
Glass Joe

Night Elf Hunter

Feathermoon
 Originally Posted by Intermission The first thing you need to do is enable macros in your spreadsheet. For example, if you use Office 2007, you should see a bar dropdown from the toolbar saying that macro content is blocked. Click the button and unblock it. If you use a 2003 or older version, I dont know where the warning appears... but I'm sure it would be easy to enable macros if you're looking for it.
I tried to search for an answer, so forgive me if I'm asking something that's already been answered. I'm using Mac:Excel 2004, I enable macros when I open the file, but I just cannot get any of the macros to work. Has anyone else encountered this and worked out a solution?

Thanks.

 03/11/08, 1:47 PM #1642 Algalzoth Glass Joe   Algalzoth Troll Hunter   Thunderhorn Not sure what's going on, but every time I load gear from the armory, I get "Battlemaster's Cruelty is not supported in Trinket 1 please use Custom Gear for it" when it's listed in the pull down. Am I doing something stupid or is it a bug?
 03/11/08, 1:59 PM #1643 Lactose Don Lactose     Lactose Tauren Hunter   Talnivarr (EU) I've had this reported by others as well, but I'm not sure why. It seems to be listed correctly in the spreadsheet. For reference, looking at the source when viewing your profile lists the following for the trinket: ` ` Look, Lactose, we'd rather you didn't eradicate the whole human race. - Sam & Max
 03/12/08, 7:43 AM #1644 Anthony Glass Joe     Baenri Draenei Shaman   Thunderhorn I've looked around some in the forums, so pardon if this has been answered somewhere. I was wondering if anyone has a set of values somewhere for hunters to enter into something like lootzer.com or pawn? By the way, this is an awesome spreadsheet. It's helping me as a new hunter immensely.
03/12/08, 11:01 AM   #1645
revelator
Glass Joe

Night Elf Hunter

Zangarmarsh
Probably just a misplaced quote or something in the item name. The item appears in the dropdown box as just "Cruel" and can be selected and has the correct stats on it. Without looking at the source, I suspect there is some sort of errant punctuation that prevents the "Battlemaster" from being part of the item name.

 Originally Posted by Lactose I've had this reported by others as well, but I'm not sure why. It seems to be listed correctly in the spreadsheet. For reference, looking at the source when viewing your profile lists the following for the trinket: ` `

03/12/08, 11:28 AM   #1646
alienangel
Bald Bull

Draenei Hunter

Eredar
 Originally Posted by Anthony I've looked around some in the forums, so pardon if this has been answered somewhere. I was wondering if anyone has a set of values somewhere for hunters to enter into something like lootzer.com or pawn? By the way, this is an awesome spreadsheet. It's helping me as a new hunter immensely.

The settings tab has a "dps gained from stat" table IIRC that you can base pawn scores off for your current setup.

Older versions actually had a table that provided cross equivalences for every stat pair, which made it really simple to make pawn scales calibrated in whatever stat you wanted, but this was removed around 0.40

Last edited by alienangel : 03/12/08 at 11:44 AM. Reason: capitalization

 03/12/08, 11:36 AM #1647 Anthony Glass Joe     Baenri Draenei Shaman   Thunderhorn Thanks alien. I'll check that out and see what i can come up with.
03/12/08, 5:09 PM   #1648
Ragnar
Von Kaiser

Dwarf Hunter

Magtheridon
 Originally Posted by alienangel The settings tab has a "dps gained from stat" table IIRC that you can base pawn scores off for your current setup. Older versions actually had a table that provided cross equivalences for every stat pair, which made it really simple to make pawn scales calibrated in whatever stat you wanted, but this was removed around 0.40
Are these working for you, then? For me, they don't reflect the stats based off the gear I put in. Simplest example is that +hit offers a DPS increase for me while I'm hit capped.

Beyond that, I get these values off the spread-sheet Settings page:
Attribute -- DPS
Agility + 1 = 0.446
AP + 1 = 0.232
Crit + 1 = 0.387

If I manually add 1 of each stat to my Gear in the Hand Adjust section of the Gear page:
Agility + 1 = 0.66
AP + 1 = 0.28
Crit + 1 = 0.56

So I don't know where the table on the Settings and Results page is getting it's data from, but it doesn't take your gear / buffs into account.

03/12/08, 6:05 PM   #1649
alienangel
Bald Bull

Draenei Hunter

Eredar
 Originally Posted by Ragnar Are these working for you, then? For me, they don't reflect the stats based off the gear I put in. Simplest example is that +hit offers a DPS increase for me while I'm hit capped. Beyond that, I get these values off the spread-sheet Settings page: Attribute -- DPS Agility + 1 = 0.446 AP + 1 = 0.232 Crit + 1 = 0.387 If I manually add 1 of each stat to my Gear in the Hand Adjust section of the Gear page: Agility + 1 = 0.66 AP + 1 = 0.28 Crit + 1 = 0.56 So I don't know where the table on the Settings and Results page is getting it's data from, but it doesn't take your gear / buffs into account.
Interesting. I haven't tried updating my Pawn scales since the change to this table (since I've been using a RAP equivalence scale since AQ days and don't have the heart to break it into a DPS equivalence scale now), so don't know if they're working for me. The old cross-equivalence table used to work though, I'm fairly sure I checked a few stats on it once.

 03/12/08, 6:34 PM #1650 Ebonleaf Von Kaiser   Ebonleaf Night Elf Hunter   Stormrage For my money, i just mix a /castsequence 1:1 steady with a manual weave arcane or multi. You get your 1:1:5 rot, good dps, and your not watching the timer the whole fight.

 Elitist Jerks Hunter Spreadsheets -- In development