Djinn

I can also confirm the trinket doesn't have a internal CD. Have seen a few back to back procs with it.

Forest Prowler's Helm doesn't have a Meta option.
Add Band of Devastation.

 

Barakdorin

The Crystalforged Trinket +dam doesn't appear to be calculating at all. The math you have is looking for the +7 dam X the # of trinkets. The Crystalforge is unique I believe.

Regardless the look-up for how many trinkets you have equiped doesn't appear to work either.

Hope I caught you in time to sneak this in the next version. I have been experimenting around with it lately and it's actually a pretty nice trinket. The shorter cooldown for the Use effect is fairly significant.

Thanks.

 

Serpica

Quickstrider Moccasins are missing: Quickstrider Moccasins - Items - World of Warcraft

 

Cheeky

Here is the final change log:
- Couple more fixes for Open Office compatibility. Some things (like macos and gem selection) just aren't going to work because Open Office does not support the levels of functionality I need as Excel does.
- Removed Strength only and Spirit only gems. No Hunter is his right mind would ever use these.
- Fixed some item values (High Warlord's Chain Leggings, Felsteel Reaper, Rift Stalker Helm, Band of Eternity, Band of Accuria, Forest Prowler's Helm)
- Modeled pet ability Screech
- Added stat bonuses to gem names to make selecting them easier.
- Added socket bonuses for Custom melee weapons.
- Fixed bug with protection of cell for "Type" of Custom ranged weapon.
- Added hand adjust fields for Weapon Skill on Gear tab.
- Added modeling for 4 piece Beast Lord set bonus, based on Kill Command frequency.
- Added support for gear that modifies pet statistics.
- Added Leggings of Beast Mastery, Alchemist's Stone, Band of Devastation.
- Added the Settings tab for control information from the user to customize how the data is calculated.
- Ability to average out "On Use" +AP trinkets provided through Settings tab
- Ability to average out The Beast Within effect provided through Settings tab
- Ability to average out Bestial Wrath effect provided through Settings tab
- Fixed a bug with the Crystal Forged Trinket not being counted properly.
- Modeled the Ashtongue Talisman of Swiftness, based on Steady Shot rate from Shot Rotation and Quick Shots (weighted by Quick Shots up time.)


Things I still want to do:
- Provide timing information for the [Dragonspine Trophy].
- Get a model for the [Darkmoon Card: Crusade] and add it too.

Cheeky of Havoc

 

RavenXce

Bug: Relentless Earthstorm Diamond is not counting properly.

Problem is at cell Calculations!E44 where "Relentless Earthstorm Diamond" should really be "Relentless Earthstorm Diamond (12 Agi)".

 

Cheeky

Version 25 is now available to fix this bug. Thanks to all who messaged me about it!

(This is the only difference with Version 24.)

Cheeky of Havoc

 

Cheeky

With a suggestion from Lactose, and Norwest's equations for Improved Aspect of the Hawk, I think I have a solid working model on determining the uptime of the [Dragonspine Trophy] and Quick Shots as they interrelate with each other.

Now there are two things I need feedback on before putting it all together and polishing it up for release:

1 - PPM rate for the trinket. I'm leaning towards leaving it user settable. I can easily derive everything for any ppm rate. (The equations seem to break down at anything over 10 ppm, which is unrealistic anyways.)

2 - How to present the data? I'm thinking of having 2 more tabs that appear when the trinket is selected as a gear item. One that allows you to specify a DST-proc rotation, and one for Quick Shots + DST. I can then ratio the DPS totals based on the various uptimes. This is a complication for casual use of the spreadsheet, but in the interests of accuracy I'm willing to do it. I'd have them both defaulted to a pure Auto/Steady rotation with whatever clipping that entails.

Any ideas are welcome. I've pretty much left "simple" behind a long time ago as a description of this tool, so I'm not too bothered by adding more tabs.

Cheeky of Havoc

 

Ishmaael

I would love a DST option added in, as well as quickshots. A constant question in my mind was how DST and its veritable OP proc compares with Tsunami or the BT proc which lowers armor, and there better passive stats.

As i accidentally posted in the BM thread, i've been trying to make my stats match my ingame stats with your spreadsheet, but continuously find my crit% around .6% lower than it should be, and have no idea whatsoever why.

I could just be retarded.

 

Cheeky

Because your in-game stats are always relative to a target at your level. The default mob level in the spreadhseet is 73. You can adjust this on the gear tab (it's at the top).

Cheeky of Havoc

 

Ishmaael

Ahh that is a nice feature! however i noticed that the top area was generally a scenario (with armor factors and such). I was more reffering to the basic character stats on the calculation page, However since getting some fresh gear and throwing it in i seem to have erased the problem. I think i was using the belt of deep shadow which i intended to craft the night i filled it out but never did, as i mentioned i have down syndrome thanks cheeky and this spreadsheet is "the bomb"

 

Groggan

Hey cheeky, did you get enough of the open office bugs out of the spreadsheet to make it useable?

 

Cheeky

Not really. There are two things I just can't seem to work around:

1 - Open Office doesn't support indirect list name validation. This isn't a big deal, I use it only for gem slot pull-downs to support having no sockets vs. sockets providing different listings.

2 - Open Office doesn't support Visual Basic of any kind. I use VB for clearing sockets when you switch gear, and all the nice buttons that you see.

Everything else seems to work fine right now. All the calculations are correct, and provide just the same answers Excel does.

Groggan, if you don't mind hand timing your shot rotation I can email you a version with full gem listings turned on for all sockets. Just pm me a email address and I'll try and get it to you tonight.

Cheeky of Havoc

 

• Glaurong

The Novell edition of Open Office has support for using/porting VBA.

You can get it at http://download.novell.com

Log Parser for BM Hunters (Right click, save as) - Updated 10/11/2007

 

Carlaena

Could we add the Primalstrike set and Cobrascale Hood please

 

Phanuel

Pristine Fire Opal needs to be corrected, it's supposed to be 10 AP and +4 Hit Rating. Currently it's 10 AP and 5 Crit Rating in your spreadsheet making two gems that do the same thing.

 

Breakerone

Is this really on purpose that having IAoth lowers your overall dps as an MM? I believe this happens because you calculate another rotation as long as Quick Shots is up, which gives less damage but you still have the option to continue with your regular rotation without any positiv or negativ effect by QS.

On another note, the timeless ammo is 53 dps now. Oh, and please add the Black Bow of the Betrayer.

 

Tazrach

Hey cheeky,

I may be missing something but I have checked and double checked my gear as entered into the spreadsheet, looked at my spec to ensure everything is right, however I am sill getting .57% crit less than it says in my paper doll 32.63% on armory and paper doll vs 32.06% in the spreadsheet.

 

Shandara

Are you sure you changed the target level to 70? (it's standard set to 73/boss)

 

Tazrach

That did it, thanks, thought I was going crazy

 

Torquemada

Link to my current armory

The Armory

Playing with the spreadsheet I take dps losses for

Serpent Spine Longbow - Items - World of Warcraft

Arcanite Steam-Pistol - Items - World of Warcraft
and
Merciless Gladiator's Crossbow of the Phoenix - Items - World of Warcraft


Is our itemization really that bad for the Kara bow to remain king or am I doing something incorrectly? I understand the Steam-Pistol to a degree as I am hit capped but I don't understand how the Serpent Spine would not be a better weapon. Any help would be appreciated.

 

Cheeky

You can figure out why yourself, just look at the changes in damage your shots do, and the frequency you can cast them. The slower weapons may be adding more "dead time" to your rotation than they make up for in stats or native DPS. The DPS of your ranged weapon is very minor in over all damage calculations. Most of it comes from your RAP, this is especially true for Steady Shot.

Edit: I am Cheeky, not Chucky. (I am not a psychopathic animated doll.)

Cheeky of Havoc

 

Hoverpuma

Wow, thanks very much to Cheeky for all the work on this tool. It's been a real eye-opener for me.

I do have a couple minor issues regarding revision 25.

Shouldn't Serpent Sting trigger the GCD? It's set to "No" at the moment in the "Shot Rotation" sheet, which allows me to create rotations with a "free" sting taking zero time and artificially inflating the rotation's DPS. (Yes, I realize that SS is almost never "worth" the mana or GCD compared to arcane/multi, but I'm playing around with creating rotations for situations where one of the other instants is unavailable due to arcane immunity, CC, or whatever.)

On another note, I'm having trouble configuring the sheet for a wolf with Furious Howl. Please pardon me if I'm making some noob mistake, but if I turn off all pet abilities except FH as "primary", it shows up as 0 DPS and puts up several #DIV/0! errors on the "Pet" sheet. I do see that an actual computation is being done in the "Pet Calculations" sheet, but it doesn't seem to be reflected in any DPS totals on the "Pet" or other sheets, even if I add a Bite to the pet ability priority to get rid of the #DIV/0! errors.

(I suspect that I'll end up doing better with some other pet than the wolf, but I would like to figure out some real numbers rather than going on hunches.)

 

Cheeky

The furious howl is currently using the rank for Dive to look up cool down and focus on the pet page. You can use that to see how ranks 1-3 work. I'll have it corrected in the next version.


Does anyone have any good ideas on how to handle different shot rotations for the [Dragonspine Trophy]? I think adding 2 more (one for just Haste, one for Haste + Quick Shots) is going to be really cumbersome. I'm looking for some feedback from those who are already using the current rotations.

One thought I had was hiding all the derivative data in the shot rotations and combining them into one tab. This would make tracking down my mistakes much harder though.

Cheeky of Havoc

 

Shaile

You have to stand within 15 yards to receive FH, that should be enough of a hunch.
Seriously, wolfs are sub par dps pets, no real focus dump and no fotm pet ability. The only time me and my guilds hunters used wolfs were on patchwerk in naxx when we had a hunter group of 4 hunters and 1 shaman and we all stood within FH range. Even then i'm not sure if it ended up being more dps than if we were to use cats.