Elitist Jerks
Register
Blogs
Forums


Go Back   Elitist Jerks » Hunters

Closed Thread
 
LinkBack Thread Tools
Old 04/13/09, 2:19 PM   #2026
Shandara
Great Tiger
 
Shandara's Avatar
 
Night Elf Hunter
 
Azjol-Nerub (EU)
Originally Posted by Lionizer View Post
I've been trying to import talent specs from wowhead's PTR site, but apparently only live site is accepted.

Last attempted in 86e with this url:
ptr . wowhead.com/?talent=cZ0eVoobZe00i0cIhxdAhsu

I figure it's a minor change to let it understand both www . wowhead . com and ptr.wowhead.com but I might be wrong.

Thanks for all your work with this, it's highly appreciated.

Edit: spelling and extra spaces in URLs to suppress bloody auto-code generator :s
Yes, the import checks for the
http://www.wowhead.com/?talent= ...
header and it's an easy enough change to implement.


Offline
Old 04/14/09, 4:14 AM   #2027
cloudy09
Glass Joe
 
Night Elf Hunter
 
Alexstrasza (EU)
are there any changes in Hit raiting since v.86d ?

in v.86e i have 100,05% Hit against lv83 with a Hit rating of 230.

in v.86d it is 99.05 against lvl83 with a Hit raiting of 230.


no, there are no points in focused aim

Offline
Old 04/14/09, 4:24 AM   #2028
sihyunie
Piston Honda
 
Dwarf Hunter
 
Bonechewer
You probably have heroic presence on to give you 1% extra hit.

Offline
Old 04/14/09, 4:33 AM   #2029
cloudy09
Glass Joe
 
Night Elf Hunter
 
Alexstrasza (EU)
loaded buffs "none", then loeaded "lvl 80 Buffs"

now it works fine and i'm on 99,02

Offline
Old 04/14/09, 6:44 AM   #2030
lmk
Glass Joe
 
Night Elf Hunter
 
Bronzebeard
I'm having a problem with the spreadsheet on Excel:mac 2008. Every time I try to change anything I get the error 'Microsoft Excel cannot calculate a formula.' I believe, but am not sure, that this is due to Microsoft's self-admitted idiotic decision to remove VBA from Mac Office 2008 (they're putting it back in the next incarnation, but who knows when that will be). When Cheeky did the spreadsheet this wasn't much of a problem as he only used macros for automation - I couldn't download from armory, or hit any of the 'auto-rotation' buttons, but I could just input everything manually and it would work, as all the actual dps computations were simply formulas. It was more work than if I had macros, but nevertheless I could use the spreadsheet.

Correct me if I'm wrong, but I believe your version uses macros much more pervasively and actually in the computations, not just for ease of use. I obviously don't expect you to go back and remove the macros and replace them with formulas, as you've added a lot of functionality that didn't exist before and asking you to create a gimped version for a small userbase isn't really something I'd want. Can you, however, confirm that this is my problem, and I'm not missing something completely obvious? If it is a macro problem a note in the FAQ for Mac users might also be nice.

(Apologies if this has been addressed before, unfortunately 'mac' is too small a search term for the forum.)

Last edited by lmk : 04/14/09 at 6:53 AM.

Offline
Old 04/14/09, 11:57 AM   #2031
Kharthus
Piston Honda
 
Dwarf Hunter
 
Deathwing
What are you trying to change? I can swap gear and talents in Excel 2008, just stuff like the armory import doesn't work.

Offline
Old 04/14/09, 12:00 PM   #2032
Hirgux
Von Kaiser
 
Dwarf Hunter
 
Blackhand (EU)
Could you add something, that will prevent, for example aimed shot, from being included into the rotation when it is not 'learned' via talent? So I want to have a priority list with aimed shot, but it should only calculate it when I have the talent - so it would be faster to compare specs, when you don't always have to change the priority.

Offline
Old 04/14/09, 12:10 PM   #2033
lmk
Glass Joe
 
Night Elf Hunter
 
Bronzebeard
Originally Posted by Kharthus View Post
What are you trying to change? I can swap gear and talents in Excel 2008, just stuff like the armory import doesn't work.
Everything. I change a piece of gear, a gem, a talent point, an enchant, anything at all that will affect my stats and I get 'Microsoft Excel Cannot Calculate a Formula'. I have also realized since I posted that it is only the PTR spreadsheet (v86) giving me this problem, the Live speadsheet (v84) works perfectly. Can you confirm that the PTR spreadsheet works on your Excel 2008?

Here is a screenshot of the exact error I'm getting:


Offline
Old 04/14/09, 12:53 PM   #2034
GhostRoc
Glass Joe
 
Blood Elf Hunter
 
Spinebreaker
Hello everyone,

I'm hoping someone can help me with a problem.

I have Windows Excel Mobile on my PDA, but no Excel on my desktop (I'm currently away from my usual desktop).

The Hunter_DPS.xls file can't be opened by my PDA's Excel Mobile. The exact error message I'm getting is "Cannot open password protected Microspft Excel workbooks."

Any suggestions on how I can view this spreadsheet? My current tools available are:-
1) PDA with Windows Excel Mobile
2) Desktop with NO Excel
3) Working internet connection

So far I've tried looking for a free xls viewer in the internet, but the ones I've found can't seem to view the workbook well enough (I can't play with talents, gear or specs!)

I'd appreciate any help - my email is ghostroc@yahoo.com

Good hunting!

Offline
Old 04/14/09, 3:58 PM   #2035
Kharthus
Piston Honda
 
Dwarf Hunter
 
Deathwing
Originally Posted by lmk View Post
Everything. I change a piece of gear, a gem, a talent point, an enchant, anything at all that will affect my stats and I get 'Microsoft Excel Cannot Calculate a Formula'. I have also realized since I posted that it is only the PTR spreadsheet (v86) giving me this problem, the Live speadsheet (v84) works perfectly. Can you confirm that the PTR spreadsheet works on your Excel 2008?

Here is a screenshot of the exact error I'm getting:
I've used both versions without issue. Not sure what's causing that error message.

I'll verify tonight in case something changed.

Update: Works fine for me. Not sure why yours is bugged.

Last edited by Kharthus : 04/15/09 at 2:22 AM.

Offline
Old 04/14/09, 5:17 PM   #2036
Nagisamuro
Piston Honda
 
Nagisamuro's Avatar
 
Orc Hunter
 
Cho'gall
Originally Posted by GhostRoc View Post
Any suggestions on how I can view this spreadsheet? My current tools available are:-
1) PDA with Windows Excel Mobile
2) Desktop with NO Excel
3) Working internet connection
Microsoft offers a fully functional 60 day (I think) trial of Excel. No credit card or anything required (I don't remember even being asked for my email address, but I may be wrong about that).

It'll get you through the next 60 days, at least.

Offline
Old 04/14/09, 6:59 PM   #2037
Esoth
Bald Bull
 
Esoth's Avatar
 
Worgen Hunter
 
Whisperwind
It seems Icewalker is now called "+12 hit rating and +12 crit rating" which makes it fail on reading from the armory. I'm guessing the same is true for the other boot enchants.


United States Offline
Old 04/14/09, 9:07 PM   #2038
krankster
Glass Joe
 
krankster's Avatar
 
Undead Mage
 
Malfurion
physical mechanics assist

I am sure I will get yet another infraction for this but I want to solicit opinions. I've been spamming shot macros for either BM or MM from 1 - 80 on my hunter. Now that I have changed to SV spec, and reading these forums, I realize I'm sacrifcing dps by spamming the macro. I'm trying to solicit different options for how other hunters physically handle the manual weave of shots - i.e. mouse click on action bar, hot keys, etc to get ideas on what is working for different people. Averaging 1700-1900 or so dps works on heroics but I want 2k + before i start raiding with my hunter.

Thanks!

United States Offline
Old 04/15/09, 8:52 AM   #2039
Dralmoo
Don Flamenco
 
Orc Hunter
 
Shadowmoon
Can the sheet's armor pen calculations be updated to match the ones in the combat ratings at 80 thread? People in that thread have confirmed it's live as described (including .81 multiplier to ArP from gear).

edit: doing the math, I get a boss having about 460 more armor using that formula vs the sheet, for my gear, so while it's not a huge difference I expect it would change the relative values of several items.

Last edited by Dralmoo : 04/15/09 at 9:08 AM.

Offline
Old 04/15/09, 9:02 AM   #2040
khunad
Glass Joe
 
Night Elf Hunter
 
Burning Legion (EU)
so any1 can confirm that 6/14/51 ( Talent Calculator - World of Warcraft ) spec is best DPS spec atm ?

Offline
Old 04/15/09, 9:25 AM   #2041
Onouris
Von Kaiser
 
Night Elf Hunter
 
Ravencrest (EU)
Is there an ETA on a final live version of the sheet? The latest one gives a runtime error 13 each time I change something in the shot rotation, and loading profiles created with the sheet causes another runtime error and changes none of the settings.

Also seems wowhead's talent string has changed again to

http://www.wowhead.com/?talent#....
@Khunad with my quick go on the sheet I used 6/14/51 and it was quite a way ahead of the BM and MM specs I tried.

Offline
Old 04/15/09, 9:48 AM   #2042
valiloramov
Banned
 
Night Elf Hunter
 
Chromaggus (EU)
Hey,

I've downloaded the spreadsheet now on both my Mac and my work Windows PC and I can't get either to work! Everytime I follow the instructions here (How to use the DPS Spreadsheet! � OutDPS!) when I get to the "Load Gear from Armory" I get an error message saying "There is no Valilor of Chromaggus on the EU Servers."

There is! It's me! http://armorylite.com/eu/Chromaggus/valilor

Any ideas?

Offline
Old 04/15/09, 10:25 AM   #2043
Nagisamuro
Piston Honda
 
Nagisamuro's Avatar
 
Orc Hunter
 
Cho'gall
Originally Posted by valiloramov View Post
...when I get to the "Load Gear from Armory" I get an error message saying "There is no Valilor of Chromaggus on the EU Servers."...
Any ideas?
99% of the time (making up statistics ftw) that's because the armory website is down. It may also occur (I'm not sure) if the armory takes too long to respond. There is always a high correlation between armory slowness/breakage and patch day.

Just try again later - check the official armory site and make sure you can pull up your profile first.

edit: Yeah, it just took me ~4 minutes to load your armory page.

Offline
Old 04/15/09, 10:35 AM   #2044
Leonina
Von Kaiser
 
Night Elf Druid
 
Ravencrest (EU)
Originally Posted by khunad View Post
so any1 can confirm that 6/14/51 ( Talent Calculator - World of Warcraft ) spec is best DPS spec atm ?
I can do the opposit, I can deny that it is; something along the lines of Talent Calculator - World of Warcraft have been proven better with BiS-, or near-BiS,-gear.

Last edited by Leonina : 04/15/09 at 10:44 AM.

Offline
Old 04/15/09, 10:37 AM   #2045
Ferlog
Glass Joe
 
Dwarf Hunter
 
Shadowsong
Wolverine Bite/Roar of Recovery

Hello,

The pet abilities Wolverine Bite/RoR for Cunning pets aren't available in the dropdown after picking them up with the pet talents. Also Feeding Frenzy doesn't appear to be granting the cunning pet any additional damage.

Thanks

Offline
Old 04/15/09, 10:38 AM   #2046
valiloramov
Banned
 
Night Elf Hunter
 
Chromaggus (EU)
Originally Posted by Leonina View Post
I can do the opposit, I can deny that it is; something along the lines of Talent Calculator - World of Warcraft have been proven better with BiS-, or near-BiS,-gear.
I tested your link and the glyps appear to be wrong...explosive trap? I thought the consensus here was for Explosive Shot? Also, The pack? I think something has gone wrong somewhere....

Offline
Old 04/15/09, 10:43 AM   #2047
Leonina
Von Kaiser
 
Night Elf Druid
 
Ravencrest (EU)
Talents seems to be correct, it should be Explosive Shot and not Trap ofc, minors are irrelevant anyways, Revive Pet or the pack, your choice, DPS isn't affected.
If you have low haste (sub-290), change serpent glyph with Hawk and remove a point in Hunting Party and put it in IAotH.

EDIT: Talent Calculator - World of Warcraft
EDIT2: updated original post.

Offline
Old 04/15/09, 10:49 AM   #2048
Shandara
Great Tiger
 
Shandara's Avatar
 
Night Elf Hunter
 
Azjol-Nerub (EU)
Originally Posted by Ferlog View Post
Hello,

The pet abilities Wolverine Bite/RoR for Cunning pets aren't available in the dropdown after picking them up with the pet talents. Also Feeding Frenzy doesn't appear to be granting the cunning pet any additional damage.

Thanks
These abilities are automatically averaged when you select the talent. Feeding Frenzy only works currently if you set the boss hp % to lower than 35% on the settings tab.


Offline
Old 04/15/09, 10:54 AM   #2049
kabes
Von Kaiser
 
Orc Hunter
 
Thrall
The engineering tinker Hand-mounted Pyro Rocket doesn't seem to be doing the correct amount of damage on 3.1 live. It was only hitting for around 900 (it's old damage) but it does have the updated 45 sec cooldown and it's off the GCD. I'm guessing its less or equal DPS to the Crusher enchant like this. Spreadsheet shows it as better than Crusher w/ the tool tip numbers.

Offline
Old 04/15/09, 12:01 PM   #2050
Destinova
Glass Joe
 
Tauren Hunter
 
<SG>
Bleeding Hollow
Hello,

The Wolf talent spec in the 0/15/56 profile on the sheet doesn't seem to work. It has 1 point in Rabid and 1 point in Wild Hunt. On live 1 point of Call of the Wild is required for Wild Hunt - the profile seems to have an impossible spec.

I added the point to Shark Attack instead, and the dps loss was marginal. It appears that Call of the Wild/Wild Hunt is lower dps than Rabid/Shark Attack.

Thanks for all your work!

Last edited by Destinova : 04/17/09 at 12:45 PM.

Offline
Closed Thread

Go Back   Elitist Jerks » Hunters

Thread Tools

Similar Threads
Thread Thread Starter Forum Replies Last Post
Moonkin DPS Spreadsheet Efejel Druids 1925 11/04/08 2:34 PM
Hunter lvl 70 DPS spreadsheet Solaris Public Discussion 12 12/03/06 6:09 AM