Hunter Spreadsheets -- In development - Page 48

Glaurong · 09/13/07, 1:12 AM

Plug your gear into the spreadsheet, play with a custom offhand or whatever slot you can to determine how much 1 point of each stat is worth for you.

Take those and plug them into lootzor.com.

Win.

Raba_Storm · 09/13/07, 1:29 AM

Originally Posted by Koroshiya

I did a few searches for 'hunter's gear guide' and 'hunter excel gear list' and came up empty on both regards...

I have looked at Cheeky's excel sheet and it's pretty neat but for someone just hitting 70 and not familiar with the plethora of gear options.. a simple gear ranking sheet would be extremely helpful. Is there something I am not finding because of my search parameters?

I know the rogues have an excellent gear ranking guide based of AEP, MAEP, DAEP, etc.. I used it a whole lot making my rogue and it truly helped immensely. Is there something comparable for hunters?

If there's not would anyone be interested in working with me to create one? I have the template done for one, just need some help adjusting the weight of stats in order to get an appropriate AEP rating for hunters.

HAEP: Homepage is a good site for comparing items with your own preferred HAEP values.

• vank · 09/13/07, 2:19 AM

Originally Posted by Glaurong

Plug your gear into the spreadsheet, play with a custom offhand or whatever slot you can to determine how much 1 point of each stat is worth for you.

Take those and plug them into lootzor.com.

Win.

Except the gems that are defaults aren't what I'd use. Is there a way to change the selection?

Glaurong · 09/13/07, 2:43 AM

Originally Posted by vank

Except the gems that are defaults aren't what I'd use. Is there a way to change the selection?

It is supposed to use the gem combination that will give you the highest score (including the bonus if it can get it). Perhaps include the score for Agility with kings?

Jakt · 09/13/07, 3:22 AM

This may have already been covered, but I plugged in my gear into the latest version of the spreadsheet and was a bit surprised at the discrepancy between my average auto-shot/steady shot damage as shown by WWS and the average auto-shot damage I was expecting from the spreadsheet.

What I found was that I had to add about 50% armor mitigation for these values to match. That seems a bit much for your average fully sundered boss (for ease of use I was looking at the huntsman). I was expecting mitigation to be much closer to 30% and have a hard time believing that the remaining 20% is made up by slightly sub-optimal hunter's mark and trinket use.

Any ideas?

Tiberium · 09/13/07, 4:00 AM

Originally Posted by Koroshiya

I have looked at Cheeky's excel sheet and it's pretty neat but for someone just hitting 70 and not familiar with the plethora of gear options.. a simple gear ranking sheet would be extremely helpful. Is there something I am not finding because of my search parameters?

Whilst by no means perfect I find, Compare Hunter Items - survival-raid-pure-damage - Head to be a very good "aid" to at a glance gear selection. Configurable to boot.

khel · 09/13/07, 10:10 AM

Originally Posted by Glaurong

Plug your gear into the spreadsheet, play with a custom offhand or whatever slot you can to determine how much 1 point of each stat is worth for you.

Take those and plug them into lootzor.com.

Win.

Yep. Using Cheeky's spreadsheet and my current gear, with my typical raid buffs, I came up with the following values:

1 agi = 0.639 dps
1 ap = 0.276 dps
1 cr = 0.530 dps

I just multiplied by 10 when setting the values to make things a bit easier, (1agi = 6.39, 1ap = 2.76, 1cr = 5.30), and estimated some values for hit rating (because it caps), intellect, mana/5, and stamina. Really these values fluctuate from fight to fight, depending on your assignment and group setup...since sometimes you might have a shadowpriest and then as BM, intellect and mana/5 become useless. Some fights stamina is worth more than others. On Vashj you don't need to max out your hit rating really to kill elementals and bats effectively.

I just used:

1 agi = 6.39
1 ap = 2.76
1 cr = 5.3
1 hr = 5.0
1 int = 1.0
1 stam = 1.0
1 mana/5 = 6.39

and feel fairly confident with the results so far.

Cheeky · 09/13/07, 10:43 AM

Originally Posted by Jakt

This may have already been covered, but I plugged in my gear into the latest version of the spreadsheet and was a bit surprised at the discrepancy between my average auto-shot/steady shot damage as shown by WWS and the average auto-shot damage I was expecting from the spreadsheet.

What I found was that I had to add about 50% armor mitigation for these values to match. That seems a bit much for your average fully sundered boss (for ease of use I was looking at the huntsman). I was expecting mitigation to be much closer to 30% and have a hard time believing that the remaining 20% is made up by slightly sub-optimal hunter's mark and trinket use.

Any ideas?

Hunter's Mark would be my first guess. It's amazing how much damage you loose when it falls off. For a 2.7s weapon that's ~85 damage before modifiers.

Also, different bosses have different armor values. Try a bit of Dr. Boom testing to see how accurate the numbers are for you. I think Boom has between 25-30% armor.

Lactose · 09/13/07, 10:45 AM

Regarding the whole x AP gives y DPS, mentioned in other threads, especially after the mention of the macro stuff...

Would it be possible to do something like the following:

Have a new table, with the following information:
+1 Agility = x DPS (personal/pet + total?)
Same for Crit, AP, Hit, etc

1. Copy current stats (Agility, Crit, AP, Hit, DPS (pet+personal), etc somewhere
2. Increase Agility by 1
3. Compare new DPS to copied DPS
4. Input change in DPS into the new table
5. Repeat 1-4 with other stats (Crit, AP, Hit, etc)
6. Copy old stats back

This would then, when the macro was executed, fill a table with how much adding +1 of any relevant stat would increase your DPS, allowing you to easily make equivalency points for your current gear/spec, and compare stats more directly, e.g. for gemming purposes.

Koroshiya · 09/13/07, 10:53 AM

Okay to clear up a few things...

1. I like the AEP system because for me not knowing what gear I want at all helps me narrow the list. Right now Cheeky's spreadsheet has A LOT of gear.. and I don't know where a lot of it is. So the AEP system allows me to narrow the gear to 5 mans only to start, then move on to Kara and above... It helps me at a glance learn what's available for each slot.. and then I know if I want Head Slot A from say BM, then there is no reason to take Head Slot B from Arc, unless no one needs it and it's an upgrade. I prefer to pass or greed on items I will only consider temporary items, because I would rather someone be given a shot at an item, if nothing else for the gold, then upgrade only to turn around and vendor sell it an hour later when I get the piece I really want. At higher instances it's less of an issue because you don't progress as fast as you do through the 5 man stage.

2. I appreciate all the links of information, I am researching them now. Cheeky again great job on the spreadsheet, it's just a bit overwhelming when you have no clue of what's available to you as an unguilded hunter trying to get geared before app'ing to a guild.

Side Note: I recently returned to the game and transferred off a PvP server to a PvE server, to play with a real life friend. We are both unguilded at the moment and want to make sure we get our gear in order and present ourselves as respectable players before app'ing to a guild.

Cheeky · 09/13/07, 11:33 AM

Originally Posted by Lactose

Regarding the whole x AP gives y DPS, mentioned in other threads, especially after the mention of the macro stuff...

Would it be possible to do something like the following:

Have a new table, with the following information:
+1 Agility = x DPS (personal/pet + total?)
Same for Crit, AP, Hit, etc

1. Copy current stats (Agility, Crit, AP, Hit, DPS (pet+personal), etc somewhere
2. Increase Agility by 1
3. Compare new DPS to copied DPS
4. Input change in DPS into the new table
5. Repeat 1-4 with other stats (Crit, AP, Hit, etc)
6. Copy old stats back

This would then, when the macro was executed, fill a table with how much adding +1 of any relevant stat would increase your DPS, allowing you to easily make equivalency points for your current gear/spec, and compare stats more directly, e.g. for gemming purposes.

I'll play around with that this evening. I need to get some work in to update the DST model for 2.2 anyway. One problem I've run into in the past is having macros that span different sheets. For some reason they always error on me. I might have to put the button on the gear page, but the results could still show up on the 'Settings and Results' tab.

Jakt · 09/13/07, 12:35 PM

Originally Posted by Cheeky

Hunter's Mark would be my first guess. It's amazing how much damage you loose when it falls off. For a 2.7s weapon that's ~85 damage before modifiers.

Also, different bosses have different armor values. Try a bit of Dr. Boom testing to see how accurate the numbers are for you. I think Boom has between 25-30% armor.

Alright, went to Dr Boom and fired a few hundred shots while keeping Hunter's Mark up. This has gotten me a little closer to actually observed numbers, but I am still finding I need to put in 37.5% mitigation to get my observed numbers. Still doesn't seem right. Maybe there are input ranges for which the spreadsheet is less accurate?

Lactose · 09/13/07, 12:37 PM

I'll check Dr. Boom's armor mitigation when I get back home, so roughly 30-45 minutes.

Jakt · 09/13/07, 1:04 PM

Just to give some more info on how I have been testing:

1) In the spreadsheet
- I have double checked that the values derived from gear match those on my character sheet

- I've turned off things like TBW and +AP from on-use trinkets

- When making the comparison I've taken into account that I won't have FI on Dr Boom

2) Testing against Dr Boom
- I keep Hunter's Mark refreshed. I realize that the first 30 shots will average out a little lower, but that this effect will be fairly minimal over a longer period of time. If I did the math correctly the AP contribution from hunters mark should be 110 + 330/2 = 275 instead of 440 for those shots. I just did some back of the envelope calculations and the 30 initial shots should not impact the average accross 400 shots by more than 1%.

- My averages are for around 400 auto shots. The average does not seem to move a whole lot at this point. I'm not using trinkets/TBW

Lactose · 09/13/07, 1:33 PM

Tested, Dr. Boom has 37.0% armor mitigation, +/- 0.3%.