Smee

Thanks Shandara! Awesome work as always!

With the changes certainly answers my query regarding 6/14/51 versus 0/15/56. With the lesser mana generation of JoW, cutting out the mana regen talents in the survival tree pushes you into almost 10% uptime on Viper.

 

lawjpbo

Since a lot of people have been apparently been bugging for a non MS Office version of this spreadsheet I am taking it upon myself to create a VB.Net(2.0) version of this fine spreadsheet with a nice form based GUI. I have emailed Shandara about doing this hoping to get more information on the formulas used since I don't fully understand Excel's syntax. Baring any major snafu's I'm hoping to release the first version within a couple of weeks or so. If anyone has any interest in helping put this together feel free to email me. Things I need help with are listed below:

JPEG/ICO/PNG/BMP versions of the ability and inventory icons (currently in Blizzard's BLP format)
An expanded list of Hunter-desirable level 80 gear (rare or better)
Details of the formulas used

 

Nurru

So your solution to the easily editable spreadsheet is to create an application that only runs on one OS and is more or less a complete rewrite rather than just making the spreadsheet work in something like Openoffice as well as MS Office? Spreadsheet compatibility is a nail and you're trying desperately to screw it in with a power drill.

 

lawjpbo

And a VB.Net app is the way I know how I can contribute. If providing a VB.Net version lets even one more person use this tool to improve their playing then any amount of effort is worth it to me. If you chose not to use it fine, no one is going to force you.

 

Rosamonde

I loaded up the new spreadsheet, and on the gear planner tab, I see that my Darkmoon Card: Greatness is not displaying properly. It seems as though the Greatness card is not in the database at all.

It looks like this:

Trinket Delta 1/2 Location
1 Bandit's Insignia -------------139.33 / 31.9----Naxxramas-25
2 Wrathstone-------------------119.76 / 12.33---Unknown
3 Fury of the Five Flights-------112.75 / 5.32----Obsidian Sanctum-25
4 Darkmoon Card: Death------111.69 / 4.26----Inscription
5 Mirror of Truth----------------107.43 / 0--------5/10-man Token
6 Loatheb's Shadow-------------93.41 / -14.02--Naxxramas
7 Incisor Fragment --------------90.47 / -16.96--WotLK 5-man
8 Grim Toll-----------------------89.81 / -17.63--Naxxramas-25
9 Meteorite Whetstone----------83.87 / -23.56--WotLK 5-man
10 Blackened Naaru Sliver--------72.24 / -35.19--TBC
T1 Darkmoon Card: Greatness----------0.00------Inscription
T2 Mirror of Truth----------------------107.43------5/10-man Token

Cave canum...

Florimel (hunter) / Argent Dawn
Rosamonde (mage) / Argent Dawn
Lisieau (priest) / Argent Dawn

 

Shandara

Agility is valued at 0 dps atm. Hit the 'calculate attributes' button, since I forgot to do so to properly reset the sheet before uploading.

WotLK Hunter DPS Spreadsheet

 

alienangel

While I'm also a little dismayed at the amount of effort you're going to have to put into this, I'll point out that while I can't use Excel at work, I can almost certainly use .NET apps, so I'd at least use your program if you kept it up to date with the spreadsheet

SimulationCraft's hunter module (it's on GoogleCode, and I believe linked in a thread on this forum somewhere) also seems to keep up to date, and its formulae may be easier to read than excel ones, so you could probably pull some from there as well.

 

lawjpbo

Thanks for the suggestion on where to find formulas and such. The upkeep and transfer won't be as hard as it first seems as the macros are already written in VB for Applications(VBA) which is virtually identical in structure and syntax to VB.Net Also as pointed out enabling the macros in a spreadsheet might not always be an option due to security restrictions beyond your control.

 

Smee

I think they're still looking for someone to update the Rawr module for Hunters. Not sure if that'd be easier than a whole new app, but just flagging it up to you guys.

 

Ghumganuk

Ran across this from some emails at my job. I haven't had the free time to attempt a conversion but it claims to supports XLS to ODS conversion. I wonder if it would work on the spreadsheet or not.

Online Document Converter | Art of Solving

 

Ebonleaf

What is hitting the 'calc att' button supposed to do? It seems to stay the same.

And always, I'm sure we all appreciate your efforts on keeping this current.

 

• VRoscioli

Ok here's something I've been puzzling over, but haven't been able to work out:

I have a 2-handed weapon equipped. When looking at the gear planner at 1-handed melee weapons, it appears to be comparing them against half of the 2-handed weapon's DPS value (which makes sense). However, for every 1-handed weapon, it seems to be more valuable as an off-hand than as a main-hand weapon. (For example, the "Delta MH/OH" column contains entries like "-15.29/33.83".) I can't seem to come up with a reason for this. Can someone please enlighten me?

EDIT: I figured it out. It seems the enchant from the 2-handed weapon is only compared with the main-hand weapon. I wonder if there is a reason that it is not split evenly across the two?

 

krankster

OK, i'm confused. I would have expected my ingame dps to be slightly lower than the spreadsheet. Instead I'm seeing the opposite. I'm currently spec'd BM 55/16 w/ a cat pet with a "standard" ferocity build. (I'm still working on my gear so it's horrible)

The spreadsheet shows me getting dps of 1422. I finished H-UK last night and did 1618 dps. That's a fairly large delta and not what I expected.

I'm also testing via the spreadsheet a 3/14/54 build to help w/ raids and groups for my guild 'cause I think ( my alt/co-main is a raid healer ) the .25% mana for 15s is a big bonus. The survival spec config in the spreadsheet shows 50 more dps than the BM spec which I didn't expect pre 3.1. The shot rotation for BM is, BW, SpS, AimS, ArS, SS. The shot rotation for SV spec is SpS, AimS, ES, SS.

Are these expected results to everyone ?

wowarmory link for me is The World of Warcraft Armory

 

Aestil

Considering that SV is the strongest of the 3 spec's on live right now, I'm not sure why you expected your dps to be higher as BM.

Short priority for SV is Kill Shot > ExS > Multi > SrS > SS

 

krankster

I was under the misunderstanding that bm was still the king and sv wouldn't get buffed up until 3.1. <sigh> that's what I get for listening to others in PuG's...I'll try that rotation you're mentioning and see how much better it works. So you don't used Aimed at all and allocate that point elsewhere ? Reason I'm asking is I'm trying to decide whether to dump points into AoH or Sniper - ie what gives the bigger dps bump. I'll test on spreadsheet later.

thx!

 

Whitefyst

I obviously do not know exactly how you used the spreadsheet, but I have several possibilities for why the numbers are off:

1) You did not include the same set of buffs in the spreadsheet as in your 5-man. If your spreadsheet data was calculated with no buffs selected in the buffs and you ran with buffs in the 5-man, you are obviously going to perform better.

2) You did not model your shot rotation correctly in the spreadsheet.

3) Maybe you didn't select your pet talents on the pet tab and your pet DPS was just the default in the spreadsheet and not your actual pet.

4) Maybe you didn't update the Gathering Skill on the overview tab for you being a skinner.

5) You were probably using the default boss type in the spreadsheet while the actual creatures you fought, which included trash, had less armor and/or were more susceptible to some of your attacks.

6) Your DPS on the spreadsheet is calculated for single target DPS. You probably did some AoE attacks (Volley and/or Mulishot) during many of those fights (would be silly if you didn't), which increased your DPS.

7) You didn't include your glyphs in the spreadsheet on the Overview tab.

BTW... I would suggest using the relentless meta gem on your next helm for whatever spec of hunter you use. I would also suggest getting hit capped (you are a little less that 4% hit chance short) and avoiding stamina enchants if you want to increase your DPS.

 

Dch48

The current sheet is showing Darkmoon Card Death as providing 3 more dps than Greatness in the gear planner. When they are actually plugged in on my gear tab, Greatness is 50 dps better. Why would there be such a discrepancy? I applied the calc attributes and ranged weapons buttons, so that's not it.

Also, sunder armor is still not working right in the default 10 man buff profile. You have to set it to yes and then save the buffs to fix it.

 

Shandara

I would not try comparing spreadsheet dps to 5-man heroics. No matter the fight, they are just too short and too RNG prone to make any useful comparison. The same goes for Naxx really, even Patchwerk is just too short a fight to eliminate RNG as the deciding factor.

EDIT:
To the people with Darkmoon Card: Greatness, run the "Calculate Attributes" button, it should update the value for +1 agility on the Overview tab and restore the card to proper dps on the gear planner. You should in any case always be running that macro after making changes to your gear/spec/whatever so the gear planner values are updated properly.

WotLK Hunter DPS Spreadsheet

 

Gaahl

Am I right in assuming this change would also be true for the live version of the spreadsheet, or does it reflect something in 3.1?

 

Shandara

This is on Live as well, but this fix has not been applied to the live version.

WotLK Hunter DPS Spreadsheet

 

Iru

In part that's probably just easier, but also remember that you can enchant two 1-handers for more additional AP than you can enchant a 2-hander. 2x [Formula: Enchant Weapon - Superior Potency] > [Formula: Enchant 2H Weapon - Massacre]

 

krankster

#5 and #6 got it. incorrect boss type + aoe attacks/traps...plus shandara's comment about the fights makes sense..i'm working on dropping stamina gems and switching to hit/ap..my gear is a major work in progress. thx for the reply!

I also wanted to thank Shandara and all else who helped on this spreadsheet. It is an incredibly powerful tool and I am in awe of the amount of time you had to have spent on it. Thank you very much for all of your hard work.

 

cigs

With 3.1 approaching, I’m using the sheet to compare the merits of BM v Survival for dual speccing when it becomes available. I’ve been a long time BM, but held off on any respec knowing that it will be easier to play around with it in 3.1. I’ve also been using the Spreadsheet for about 2 yrs, so pretty familiar with most of its workings and have found it to be pretty consistent in that time.

Using a tweek of my current BM build (speccing Longevity as it didn’t seem to give much benefit pre-naxx) the 86d sheet shows that I have. (Full 10man T7, minimal buffs - BoM, Hit food, WotlKBoss, Skinning)

BM - Hunter 1718 + Pet 1145 = Total 2863 Dps

Survival - Hunter 2809 + Pet 462 = Total 3271 Dps.

While I expected survival to be better, this is a significant difference. Can anyone ratify these results?

My toon is Foresthunter, Alonsus EU.
The World of Warcraft Armory
I know my hit looks low, but I use the + 40 hit food.

Thanks

 

GwolfGarona

did you remember to change your shot rotation when you changed specs? Also do you still have 20points spent in your pet as SV vs 16?

These are both mistakes I've made before.

 

Ebonleaf

I closed and reopened my spreadsheet, doing as you suggested, and it worked that time. Thanks Shand.