Hunter Spreadsheets -- In development - Page 45

Lactose · 09/01/07, 10:03 AM

Proc Per Minute Mechanics & Haste

This seems to indicate PPM staying consistant regardless of haste effects.
Hard to say with specials included, though.

Belzi.ET · 09/01/07, 1:01 PM

Originally Posted by Cheeky

Does anyone know of an addon that can track refreshes of procs, as well as the basic proc count?

I heard about a tank-addon that cancels specified buffs. For example a tank isn't interested in pulling with a Powerword: Shield.
This addon just cancels such buffs automatically.

If we go shot Dr. Boom with a proc-meter and this tank-addon to cancel Don Santos' buff we should receive accurate data about the proc-rate.

Here are the downloads:
Cancellation (Ace-Addon)
ProcMeter (on Curse)

I'll try the two addons and hopefully be able to post a set of results.

And sorry if some skills or NPCs are misspelled, I'm gaming with a german client.

Houze · 09/02/07, 2:33 AM

First, thank you Cheeky for a amasing job with the spreadsheet, it's a great tool.

Now to my question, will you implement more target debuffs in the Buffs page?
At the moment i wonder about Shadow Priests Misery (adds 5% to spell damage), I asume this affect things like Arcane Shot, Lightning Breath and maybe Scorpid Poison?

Rhoi · 09/02/07, 10:36 AM

My shot rotation page seems broken. I have macros enabled but even when i click on the buttons and they show that they are pressing the shot rotaion doesnt change or when i press reset nothing happens.

Im using open office, is this a problem? how do i fix this please as currently its stuck on steady/auto rotaion permenantly

Thalestris · 09/02/07, 10:39 AM

Originally Posted by Rhoi

My shot rotation page seems broken. I have macros enabled but even when i click on the buttons and they show that they are pressing the shot rotaion doesnt change or when i press reset nothing happens.

Im using open office, is this a problem? how do i fix this please as currently its stuck on steady/auto rotaion permenantly

Macros don't work with Open Office. You have to enter your shot rotation manually.

Cheeky · 09/02/07, 12:51 PM

Originally Posted by Houze

First, thank you Cheeky for a amasing job with the spreadsheet, it's a great tool.

Now to my question, will you implement more target debuffs in the Buffs page?
At the moment i wonder about Shadow Priests Misery (adds 5% to spell damage), I asume this affect things like Arcane Shot, Lightning Breath and maybe Scorpid Poison?

I'm hoping to add some of the other judgments on there soon. Misery should apply to everything you list as well. It should be fairly straightforward to add in.

KayossZero · 09/02/07, 3:10 PM

Originally Posted by Rhoi

My shot rotation page seems broken. I have macros enabled but even when i click on the buttons and they show that they are pressing the shot rotaion doesnt change or when i press reset nothing happens.

Im using open office, is this a problem? how do i fix this please as currently its stuck on steady/auto rotaion permenantly

Download and use OpenOffice.org 2 Novell Edition, Novell: Downloads it has support for macros and seems to work fine for me.

stormrunner · 09/02/07, 4:48 PM

This is a fantastic spreadsheet - very useful indeed.

While messing with it today (v28), noticed that "Trueshot Aura" does not seem to have any impact on results. Problem looks like the formula in J10 on Buffs tab has the 2nd IF clause the wrong way round.

All the best.

Storm

Rhoi · 09/02/07, 9:22 PM

Originally Posted by KayossZero

Download and use OpenOffice.org 2 Novell Edition, Novell: Downloads it has support for macros and seems to work fine for me.

thats what i have. i select enable macros and have even gone into the spreadsheet settings and set macro security to low to try to fix it but nothing. tried downloading fresh spreadsheet as well.

everything else on it works fine for me tho, guess ill have to live without the rotation section

Sapa · 09/03/07, 3:58 AM

From DST analysis topic:

I can second the info's that Tyran provided, i ran 3 sessions of ~10 minutes each on the ptr and live realms and with (almost) identical gear i hovered between 25% uptime ptr and 45% uptime live.

It seems that DST now has 20-25 internal CD (on PTR).
Cheeky you might want to add that change on your ToDo list.

• Intermission · 09/04/07, 1:58 AM

I use Office 2007, I have enabled macros.

I assume the grey buttons on the spreadsheet are supposed to do something. Eg: Save, Load, Shot Rotations, etc. When I click them... well, I cant click them. Its like the button just isnt there.

Should I have not converted it out of compatibility mode into native 07 mode?

Cheeky · 09/04/07, 10:12 AM

Originally Posted by Intermission

I use Office 2007, I have enabled macros.

I assume the grey buttons on the spreadsheet are supposed to do something. Eg: Save, Load, Shot Rotations, etc. When I click them... well, I cant click them. Its like the button just isnt there.

Should I have not converted it out of compatibility mode into native 07 mode?

I don't have Excel 2007, so I have no idea how it behaves if you convert it. If it gives you the option to use it in 2002 mode (the program I develop it in) try that and see if the buttons work.

Hirashin · 09/04/07, 10:36 AM

Hi, great spreadsheet. One question that I've been unsucessfully searching for answers for is what values to put in the target AR. Is there a typical value for bosses/mobs per level?

Kolusius · 09/04/07, 2:57 PM

Putting it at about 30% reduction is what I generally do. There are a couple mods out there that will calculate it based on your damage done, but bosses will vary. The reduction you'll see on Void Reaver, and that which you'll see on Astromancer are two very different things.

Edit: While I'm in -- I noticed that when comparing, say, the Gronnstalker's Shoulders with the Spaulders of the Hidden Predator, the Predator shoulders come out ahead for personal dps, and behind for overall dps. This struck me as odd, since the Predator shoulders are ahead in both ap and agi. Upon looking, the armor penetration on the shoulders is affecting the pet calculations. Is this actually how it works? Or is it a spreadsheet bug? Apologies if I missed this discussion, haven't been able to turn up anything related to it on a search.

Lactose · 09/04/07, 3:20 PM

I don't think armor penetration affects pets.