Hunter Spreadsheets -- In development - Page 42

Enova · 11/11/07, 1:37 PM

Originally Posted by Talithin

Has there been extensive research into the 2.2 mechanics of aspect of the viper yet? I tried searching the forums for any reference, but as you know there's so many threads and posts with slight references, that finding anything of significance was rather a shot in the dark. If a general formula (even if different between certain ranges) could be made, then you should be able to model mana usage more accurately.

Glaurong has apparently worked out a formula and a small excel worksheet for the new viper model.

You can find the post here: SURVIVAL Raiding in 2.1

Fendryl · 11/12/07, 5:07 PM

v37 - [Gronnstalker's Helmet] is giving a 4 RAP socket bonus instead of 4 Crit

danison · 11/12/07, 6:23 PM

Any chance you can put up a new version to include the reduction in cast time of Aimed Shot that goes live tomorrow. (3.5 to 3.0 seconds). Thanks.

Cheeky · 11/12/07, 6:24 PM

Originally Posted by Fendryl

v37 - [Gronnstalker's Helmet] is giving a 4 RAP socket bonus instead of 4 Crit

Originally Posted by danison

Any chance you can put up a new version to include the reduction in cast time of Aimed Shot that goes live tomorrow. (3.5 to 3.0 seconds). Thanks.

I'll get these updated by the end of the week. Aimed Shot still won't be a viable shot in a PvE DPS rotation, but I'll adjust the time.

danison · 11/12/07, 6:27 PM

Originally Posted by Cheeky

I'll get these updated by the end of the week. Aimed Shot still won't be a viable shot in a PvE DPS rotation, but I'll adjust the time.

Eh, I know, I am just anal about that sort of thing.

Also will be interesting to mess around with now that it has the healing debuff added.

hjm87 · 11/13/07, 1:32 PM

When i attempt to equip the trinket romulos poison vial with the Hourglass or the Dragon spine trophy it gives me a #N/A on the calculations.
Is there something I'm missing?

Cheeky · 11/13/07, 2:54 PM

Originally Posted by hjm87

When i attempt to equip the trinket romulos poison vial with the Hourglass or the Dragon spine trophy it gives me a #N/A on the calculations.
Is there something I'm missing?

Maybe, but I won't discount the possibility of a bug. Have you set up DST shot rotations? Also, in the 'Calculations' tab there is a section for [Romulo's Poison Vial], where is the first field that shows an error?

Lutherien · 11/14/07, 1:19 AM

Cheeky,

v37 has Choker of Serrated Blades at 33 stam, 64 ap, 175 armor pen
It is actually 37 stam, 70ap, 175 armor pen

v/r
Luth

Lutherien · 11/14/07, 1:28 AM

Medallion of the Alliance could be added just for pvp sets.

Also armor pen is not showing up on the Vengeful s3 hunter chest.

v/r
Luth

Lutherien · 11/14/07, 1:30 AM

Sorry to be anal, also the 15 resil enchant for chest piece is missing.

v/r
Luth

queco · 11/14/07, 8:24 PM

Noob question: why if i Auto Shot Dr. Doom (doing nothing else and with no pet) i get a time between shots (on the combat log) of 2.15 (2.01 w/ quick shots) when my paper doll (and the spreadsheet) say it is 1.92?

Armory profile

I am not hitting any keys or doing anything else on the interface. Is this the client sending each auto shot command separately, and thus being affected by lag?

Instnt · 11/15/07, 8:57 PM

Why can't I click any of the buttons? :o

Leneson · 11/15/07, 11:51 PM

So basically, i plugged in every single point of my gear and then made myself a survival build to see where i would sit raid buffed and at 0 buffs. It says arond 37% crit and over 800 agi with buffs. Yet I am raiding SSC tonight and i have FAR FAR less. Literally only 30% buffed crit, thats a HUGE drop from what i thought and its a serious disappointment.
This seems like a ginourmous problem, unless im missing something BLATANTLY huge.
Thx for the help!

Edit: Messed up a #

Cheeky · 11/16/07, 12:36 AM

Originally Posted by Leneson

So basically, i plugged in every single point of my gear and then made myself a survival build to see where i would sit raid buffed and at 0 buffs. It says arond 37% crit and over 800 agi with buffs. Yet I am raiding SSC tonight and i have FAR FAR less. Literally only 30% buffed crit, thats a HUGE drop from what i thought and its a serious disappointment.
This seems like a ginourmous problem, unless im missing something BLATANTLY huge.
Thx for the help!

Edit: Messed up a #

Wait, you took your gear and changed your talents to Survival and saw 800+ Agility and 37% crit. Then you went and raided with the BM spec in your armory and didn't see those numbers? Honey, that's not a bug, it's not realizing that a BM spec has different Agility and crit rates than a Survival build.

Your build in the Armory clearly states 41/20/0. If you use that in the spreadsheet do the numbers match up?

• Glaurong · 11/16/07, 4:31 AM

Originally Posted by Cheeky

Wait, you took your gear and changed your talents to Survival and saw 800+ Agility and 37% crit. Then you went and raided with the BM spec in your armory and didn't see those numbers? Honey, that's not a bug, it's not realizing that a BM spec has different Agility and crit rates than a Survival build.

Your build in the Armory clearly states 41/20/0. If you use that in the spreadsheet do the numbers match up?

Oh! Cheeky called you Honey!

Leneson · 11/16/07, 4:36 AM

Guys, please, i'm not retarded(although my guild would argue otherwise). Armory hasn't updated, I specced tonight to survival. I had at MOST 32.5% crit fully buffed and thats with even more buffs than in the spreadsheet. And thanks, i guess, for calling me honey?
Edit: The L word??? *sigh*

Cheeky · 11/16/07, 10:11 AM

Originally Posted by Leneson

Guys, please, i'm not retarded(although my guild would argue otherwise). Armory hasn't updated, I specced tonight to survival. I had at MOST 32.5% crit fully buffed and thats with even more buffs than in the spreadsheet. And thanks, i guess, for calling me honey lol?

It is a term of endearment.

I'm actually very concerned that the Agility score the spreadsheet calculated wasn't within 1 of what you see in game. For crit %, I average in the gain from Master Tactician, the character sheet doesn't. I can't access Armory from work, so I won't be able to plug your gear directly in and see what's wrong. Please try looking over the 'Calculations' tab and see if something looks screwy.

Jerem · 11/16/07, 10:19 AM

Cheeky, if I may suggest one (minor) upgrade I'd like to see, it'd be the possibility to save "buff sets" (in the same way you save "gear sets").
I would mainly use it to "study" and play around with group synergy (we sometimes have 1 feral druid, some times two, same with Enh. Shamans, and so on).

Every time you release an update, I am truly amazed by what you manage to do with this spreadsheet. If what I suggest is too time-consuming, pointless, or simply annoying for you, just tell me to shut up, and I'll still be happy with what you gave us.

Midnight · 11/16/07, 10:55 AM

Why does your Spreadsheet always shows me having exactly 0.6% less crit than the Armory does? I compared my base stats and agility as well as crit rating are exactly the same it just seems like the armory is calculating 0.6% base crit more.

edit: It seems like you subtract 0.6% crit due to "Weapon Skill Adjustment" at the calculations sheet. Is that the reason? If so, where does that come from? Is that taking into account the 3 levels bosses have over me?

Cheeky · 11/16/07, 12:02 PM

Originally Posted by Midnight

Why does your Spreadsheet always shows me having exactly 0.6% less crit than the Armory does? I compared my base stats and agility as well as crit rating are exactly the same it just seems like the armory is calculating 0.6% base crit more.

edit: It seems like you subtract 0.6% crit due to "Weapon Skill Adjustment" at the calculations sheet. Is that the reason? If so, where does that come from? Is that taking into account the 3 levels bosses have over me?

Yes, and I think this exact question has been addressed over a half dozen times in the thread previously.

Leneson · 11/16/07, 3:18 PM

Originally Posted by Cheeky

It is a term of endearment.

I'm actually very concerned that the Agility score the spreadsheet calculated wasn't within 1 of what you see in game. For crit %, I average in the gain from Master Tactician, the character sheet doesn't. I can't access Armory from work, so I won't be able to plug your gear directly in and see what's wrong. Please try looking over the 'Calculations' tab and see if something looks screwy.

Ive got to take a terrible calculus test but before i go i must say these exact numbers. With my gear plugged exactly as it is on the armory, with zero buffs, i get 608 agility, and 27.22% crit chance. On armory, and on my character sheet i get 585 agility and 26.44%crit. I just realized i had put points into expose weakness which made for the false crit ratings. Sorry. I took it out and the numbers there reflect that. Ill check all the gems and thing to make sure but im quite sure everything is right. Oh P.S Why dont the macros work on Excel for mac? I enabled macros but i cant actually click anything...

Thanks in advance!

Cheeky · 11/16/07, 3:32 PM

Originally Posted by Leneson

Ive got to take a terrible calculus test but before i go i must say these exact numbers. With my gear plugged exactly as it is on the armory, with zero buffs, i get 608 agility, and 27.22% crit chance. On armory, and on my character sheet i get 585 agility and 26.44%crit. I just realized i had put points into expose weakness which made for the false crit ratings. Sorry. I took it out and the numbers there reflect that. Ill check all the gems and thing to make sure but im quite sure everything is right. Oh P.S Why dont the macros work on Excel for mac? I enabled macros but i cant actually click anything...

Thanks in advance!

23 Agility is actually a lot to be off. I'll check your Armory talents/gear and punch it in and see what I get.

Be aware that the Armory button does not update enchants, you'll get whatever was previously listed.

◊ Lactose · 11/16/07, 3:36 PM

Sounds like a +20 enchant too much (--> 23 Agility with Lightning Reflexes).

Leneson · 11/16/07, 4:50 PM

Ok the crit is right now, i had the wrong scope on my bow

. Annnnyways....
I also fixed a leg enchant and another enchant on gloves and now the agi is only 2 higher, and the crit is actually a little lower. Im just going to pass this off as me not be very careful. But as it seems the crit it still minorly off.