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.

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

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.

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

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.

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.

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

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

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.

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

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

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.