Hunter Spreadsheets -- In development - Page 39

Cheeky · 10/26/07, 11:55 AM

Originally Posted by Osse

Armory import makes things so much faster, gj.

Only thing worth mentioning is that the import doesnt copy ring enchants, otherwise no 'bugs' so far.

It doesn't copy any enchants. I'm still at a loss on how to get the enchant name from the Armory.

And, thanks!

Osse · 10/26/07, 12:01 PM

Hmm, I guess your own profile had all the same enchants I did then apart from ring the ones.

Jemsky · 10/26/07, 12:05 PM

This version is really cool Cheeky

Just having a couple of problems

Its saying Band of Eternity 2 is not Supported use Custom Gear for it

Same with Timeless Arrows

Edit: It did not pick up race when loaded

Cheeky · 10/26/07, 12:09 PM

Originally Posted by Jemsky

This version is really cool Cheeky

Just having a couple of problems

Its saying Band of Eternity 2 is not Supported use Custom Gear for it

Same with Timeless Arrows

None of the reputation rings are supported. They all have the same name, so I can't differentiate them without analyzing the specific stats, and I don't have the infrastructure in place for that yet.

[Timeless Arrow] is probably a spelling mistake. For both of those you can still use the drop down menu to select them.

Jemsky · 10/26/07, 12:11 PM

I did that Cheeky, its not really a big problem, very well done

Cheeky · 10/26/07, 12:14 PM

OO Version updated. Mostly just gear corrections, since 95% of all the neat changes are Excel-only.

dreamtheatre · 10/26/07, 12:28 PM

Cheeky, I like the spreadsheet. I have one of my own, very similar to yours. I'd like to make couple of suggestions though. Add a worksheet for quik comparisons of the differents saved sets, showing dps, crit rate, mana, hp, rotations, etc. This will make it a lot easier for people to view the differences between the created sets. Also in my spreadsheet I set up the talents with several preset, cookie cutter specs, which I can quickly loadup and tweek from there if need be. Also I have a reset for BM talents, MM talents and SV talents.

Just some ideas I thought you maybe intested in. Also the armory link downlaod is a great idea. Nice job on the sheet.

_dodger_ · 10/26/07, 1:58 PM

The armory import doesn't work for me because the Armory seems to return the item names in german. I'm using an english version of Excel 2007 but running on a german Windows XP.

The solution is to open the Internet Explorer and add english as the default language.

In german: Extras -> Internetoptionen -> Allgemein -> Sprachen -> Hinzufügen. Und dann "Englisch [en]" auswählen und in der Liste ganz nach oben schieben.

In english: Tools -> Internet Options -> General -> Languages... -> Add. And then add "English [en]" and move it to the top of the list.

Now the Armory should return the results in english. I don't know if there is a better workaround for this.

And thanks again for this new version - going to check if everything was imported fine now.

Cheeky · 10/26/07, 2:20 PM

Originally Posted by _dodger_

The armory import doesn't work for me because the Armory seems to return the item names in german. I'm using an english version of Excel 2007 but running on a german Windows XP.

The solution is to open the Internet Explorer and add english as the default language.

In german: Extras -> Internetoptionen -> Allgemein -> Sprachen -> Hinzufügen. Und dann "Englisch [en]" auswählen und in der Liste ganz nach oben schieben.

In english: Tools -> Internet Options -> General -> Languages... -> Add. And then add "English [en]" and move it to the top of the list.

Now the Armory should return the results in english. I don't know if there is a better workaround for this.

And thanks again for this new version - going to check if everything was imported fine now.

I wonder if I can build URLs such that it defaults to English. I'll play around with it and see. It would definitely make things easier.

Belzi.ET · 10/26/07, 2:34 PM

Today I was once again on worldofraids.com to check some of the PTR-news.

As Teza pointed out in the news (Worldofraids forums :: New PTR Build , Daily Blue, Heroic Badge Sets) there are a arena-gun and arena-bow found on the PTRs.

I don't know if you wanna add these to your spreadsheets at the moment, but for me as a Dwarf-Hunter the arena-gun may be quite an upgrade.

For your interest:
Vengeful Gladiator's Rifle and Vengeful Gladiator's Longbow

Lactose · 10/26/07, 2:34 PM

There's an option for selecting language on the armory pages.

GERMAN
<page globalSearch="1" lang="de_de" requestUrl="/character-sheet.xml">
<characterInfo>
<character battleGroup="Verderbnis" charUrl="r=Khaz%27goroth&amp;n=Yerr"

ENGLISH
<page globalSearch="1" lang="en_gb" requestUrl="/character-sheet.xml">
<characterInfo>
<character battleGroup="Verderbnis" charUrl="r=Khaz%27goroth&amp;n=Yerr"

EDIT: URL stays the same in both cases.
The World of Warcraft Armory

In other words:
English --> en_gb
German --> de_de
French --> fr_fr
Spanish --> es_es

Tsook · 10/26/07, 5:31 PM

Originally Posted by Cheeky

- Meta Gems for Gladiator Gear and Engineering Helms will now appear in the correct socket locations. You may need to correct this if you load an old saved file with them. (The check to do this honestly wasn't worth the effort.)

Now Relentless Earthstorm diamond doesn't get credit on the Calculations tab if it's in the top slot for engineering helms. I had to swap it to the bottom slot and then it showed up in calculations, but of course I've lost the socket bonus.

Cheeky · 10/26/07, 6:41 PM

Originally Posted by Tsook

Now Relentless Earthstorm diamond doesn't get credit on the Calculations tab if it's in the top slot for engineering helms. I had to swap it to the bottom slot and then it showed up in calculations, but of course I've lost the socket bonus.

Gah, sorry about that. Not sure if I'll have time to fix it tonight, I'll try though.

Tsook · 10/26/07, 7:36 PM

Originally Posted by Cheeky

Gah, sorry about that. Not sure if I'll have time to fix it tonight, I'll try though.

But what if I have a THEORYCRAFT EMERGENCY before then? What will I do?!

No worries, Cheeky. You've done far too much work for free for the hunter community to be worried about fixing minor bugs like that same-day.

Carlaena · 10/27/07, 7:13 PM

According to the SS [Leggings of Beast Mastery] have 490 haste and 52 armor penetration. If that's true can I have them please

Edit: Just downloaded the latest version. Thankyou so much for adding EU support from the armory import

Edit2: Ignore the [Leggings of Beast Mastery] post it's been fixed

Koroshiya · 10/29/07, 2:03 PM

I see you are already aware of this issue. :-)

Sumpfmolch · 10/29/07, 4:48 PM

will kill command be integrated into shot rotations ? it seems to delay other shots a little bit (0,2s ?)

Stinkerbelle · 10/30/07, 12:10 AM

Originally Posted by Sumpfmolch

will kill command be integrated into shot rotations ? it seems to delay other shots a little bit (0,2s ?)

From casual observation and inference, KC seems to delay shots by whatever my latency is at the time.

Mentoras · 10/30/07, 9:45 AM

Greetings Cheeky,

I would appreciate if you would include the new epic Arrows & Shells which comes in 2.3

Muarf · 10/30/07, 12:56 PM

When I switch from any aspect to "Aspect of the monkey" (wowhead), in the Talent sheets I get only 5% dodge instead of 8 (the 6 more % with 3 points in Improved Aspect of the monkey are ok)

Cheeky · 10/30/07, 2:16 PM

Originally Posted by Muarf

When I switch from any aspect to "Aspect of the monkey" (wowhead), in the Talent sheets I get only 5% dodge instead of 8 (the 6 more % with 3 points in Improved Aspect of the monkey are ok)

Yep, that's a bug. And you are the first person, to my knowledge, to ever select Aspect of the Monkey in the spreadsheet.

Muarf · 10/30/07, 2:48 PM

Originally Posted by Cheeky

Yep, that's a bug. And you are the first person, to my knowledge, to ever select Aspect of the Monkey in the spreadsheet.

I put a lot of +agi items in the spreadsheet and I just wanted to know what would the %dodge be (51,7% with the aspect without talent)

Sumpfmolch · 10/31/07, 5:47 AM

Originally Posted by Muarf

I put a lot of +agi items in the spreadsheet and I just wanted to know what would the %dodge be (51,7% with the aspect without talent)

raidbufft with deterrence dodge+parry = 99,45% :-D (with better items it should be far above 100%)

Vec · 10/31/07, 1:53 PM

It looks like [Vengeful Gladiator's Chain Helm] is missing it's Armor Penetration in the current spreadsheet.

Xeno · 10/31/07, 8:17 PM

[Cursed Vision of Sargeras] is unsupported atm.