Hunter Spreadsheets -- In development - Page 110

Glaurong · 03/09/08, 4:05 PM

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).

Grondarg · 03/09/08, 11:04 PM

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.

Grondarg · 03/09/08, 11:13 PM

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.

alienangel · 03/09/08, 11:56 PM

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.

Quizzle · 03/10/08, 11:10 AM

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.

Tenkai · 03/10/08, 8:02 PM

Why is it that when I plug any gear level (even high-end BT gear with 4 Gronnstalker bonus) into Cheeky's Spreadsheet with, say, Bristleblitz on a 3:2 rotation, then change nothing about the gear but plug in Barrel-Blade Longrifle with a 1:1 rotation, the Barrel-Blade and 1:1 outclass the 3:2 rotation every time (and by a fair amount too, 15 or so DPS)? Is this an error in the spreadsheet or something having to do with it not representing shot rotations correctly?

This makes me wonder if a moderate amount of passive haste gear coupled with a 1:1 rotation and a medium-slow weapon like Crossbow of Relentless Strikes would outclass a slow weapon like Bristleblitz, no passive haste gear, and a 2:3 rotation. Any history of people trying this? When I spreadsheet both setups, they come out damn near even, though I gotta think there's something wrong with the spreadsheet. Cheeky's seems really iffy about paper doll attack speed and how it affects rotations.

Plus, in my experience, a 1:1 rotation makes it a lot easier to thread in KC without clipping your auto (one of the several advantages the cleaner 1:1 rot has over the sloppy 2:3).

(posted in the BM bible thread as well, because the theorycrafting applies there but the spreadsheet questions apply here)

Algalzoth · 03/11/08, 1:47 PM

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?

Lactose · 03/11/08, 1:59 PM

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:

        <item durability="0" gem0Id="0" gem1Id="0" gem2Id="0" icon="ability_warrior_focusedrage" id="34163" maxDurability="0" permanentenchant="0" randomPropertiesId="0" seed="0" slot="12"/>

Anthony · 03/12/08, 7:43 AM

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.

revelator · 03/12/08, 11:01 AM

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:

        <item durability="0" gem0Id="0" gem1Id="0" gem2Id="0" icon="ability_warrior_focusedrage" id="34163" maxDurability="0" permanentenchant="0" randomPropertiesId="0" seed="0" slot="12"/>

alienangel · 03/12/08, 11:28 AM

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

Anthony · 03/12/08, 11:36 AM

Thanks alien. I'll check that out and see what i can come up with.

Ragnar · 03/12/08, 5:09 PM

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.

alienangel · 03/12/08, 6:05 PM

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.

Ebonleaf · 03/12/08, 6:34 PM

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.