Hunter Spreadsheets -- In development - Page 151

groma · 07/08/08, 5:59 AM

Originally Posted by Reinforce

My knowledge about Excel isn't any good, so I need some help. Whenever I'm done putting in the gear and wants to save the profile, the next time I open Excel again I find it unsaved, even if I load the profile, it's still the same as if I never saved anything.

You have to save the .xls file too after saving the profile.

Reinforce · 07/08/08, 9:02 AM

The save button stays grey all the time though (but it used to be able to save before).

Is there anything in the options I need to check or something?

groma · 07/08/08, 11:07 AM

Originally Posted by Reinforce

The save button stays grey all the time though (but it used to be able to save before).

Is there anything in the options I need to check or something?

Maybe you need to enable Macros / "Active content" for the Spreadsheet

Itsnoteasy · 07/10/08, 5:02 AM

Firstly, thanks for all the work you're putting into this, and in making an OpenOffice.org version.

A few things I've found when putting my gear in. For reference, this is the setup I'm using: chardev.org - A World of Warcraft character planner v.3.a.

Firstly, I have three pieces of the Beast Lord set, but the spreadsheet is only saying I have one. Under the "Item Set" column in the Gear tab, only the cuirass is listed as being part of Beast Lord. The mantle is "Dungeon" and the handguards are "1".

Next, I can't see any explicit support for the 4-piece bonus from Beast Lord: +600 ArPen to the hunter for 15 seconds on every use of Kill Command. I'm currently adding this in by specifying that the target has the Expose Weakness debuff, with a modifier of 600 (I had to go in and modify the cell's validation since it is capped at 500.)

The gear planner is fantastic, but I think it could be nice if each list had an 11th slot for your current item if it happens to not be in the top 10... even with everything unchecked, my current gear doesn't show up in a lot of places, which is somewhat worrying. It also doesn't tell me how far off the list I currently am. :P That said, it's nice to know that I don't have to worry much about upgrading my goggles until I hit Black Temple, if that even happens at all.

Again; fantastic work. Many thanks.

alienangel · 07/10/08, 11:32 AM

Originally Posted by Itsnoteasy

Next, I can't see any explicit support for the 4-piece bonus from Beast Lord: +600 ArPen to the hunter for 15 seconds on every use of Kill Command. I'm currently adding this in by specifying that the target has the Expose Weakness debuff, with a modifier of 600 (I had to go in and modify the cell's validation since it is capped at 500.)

Again; fantastic work. Many thanks.

Expose Weakness is an AP buff though, and 600 ArP is ArP, so that might not be quite what you want to do...

And I could swear I saw the 4pc bonus on the calculations tab.

Uthane · 07/11/08, 3:16 PM

Don't know if this was mentioned or not, but the [Golden Bow of Quel'Thalas] can only be used as custom gear currently.

Bikiniwax · 07/11/08, 3:43 PM

Originally Posted by Uthane

Don't know if this was mentioned or not, but the [Golden Bow of Quel'Thalas] can only be used as custom gear currently.

Yeah, we're all still waiting for version 50 to appear.

Kamaa · 07/11/08, 7:07 PM

Dear Cheeky,

We miss you. Please come back soon.

Varesz · 07/14/08, 6:37 AM

Originally Posted by Uthane

Don't know if this was mentioned or not, but the [Golden Bow of Quel'Thalas] can only be used as custom gear currently.

In the last spreadsheet(49) it's there with correct values for me. I checked with using Custom Weapon and did no dps difference at all.

Shambz · 07/15/08, 5:08 AM

Might just be my old eyes not seeing it, but I havent seen anything about this, so here goes.

According to wowwiki, a hunter without the survival talent Surefooted, needs 142 hit rating to cap and have the best possible chance of hitting Level 73 (boss mobs).

But when I check gear in the spread sheet (the newest of course), I get a 100% chance to hit a level 73 even at 107 hit rating, and dropping to 99,58% if I drop my hit rating to 88.

Is it just me misunderstanding stuff or what ?

khel · 07/15/08, 5:22 AM

Originally Posted by Shambz

Might just be my old eyes not seeing it, but I havent seen anything about this, so here goes.

According to wowwiki, a hunter without the survival talent Surefooted, needs 142 hit rating to cap and have the best possible chance of hitting Level 73 (boss mobs).

But when I check gear in the spread sheet (the newest of course), I get a 100% chance to hit a level 73 even at 107 hit rating, and dropping to 99,58% if I drop my hit rating to 88.

Is it just me misunderstanding stuff or what ?

You probably need to doublecheck your target's level, make sure you don't have improved FF up, check your food buffs (hit rating food..). I don't think there is a hit bug with v49.

Shambz · 07/15/08, 7:58 AM

Well I had checked everything..... except the fairy fire thingy

God I feel stupid now

Dafeaz · 07/15/08, 10:36 AM

Just a quick question. I'm trying to benchmark my DPS against Cheeky's. Is there a way to configure it so that it assumes the target is, say, Dr. Boom? I can only seem to configure for bosses.

Cheeky · 07/15/08, 1:40 PM

Originally Posted by Kamaa

Dear Cheeky,

We miss you. Please come back soon.

Yeah, I kind of got burned out on Hunter mechanics/theorycrafting for a while. Sorry about that.

I started work on v50 this morning. Hope to have most points asked for addressed. I want to especially thank Cole for getting me started at looking at performance optimizations. They make a world of difference on speeding up usage. I've also added planner filters for PvP/Leather/Professions. I'll look through Lactose's bug list and see what else I can get done.

I am discontinuing support of the OO version. I do plan on providing a completely unlocked spreadsheet to Drakier, to see if he wants to update it for OO. I just don't have time to do both.

I'll also be starting to play around with modeling DPS with non-interfering shot mechanics. This isn't too hard, as specials are once every 1.5s, and Auto Shot can be freely influenced by haste (I get to trash 3 sheets of rotations!). I won't start on the new pet mechanics/abilities announced for WotLK until we have a better understanding of them. One bonus of the new shot mechanics is I can finally model all haste effects.

Hey, does anyone have a link to a great model for the [Blackened Naaru Sliver] proc?

Borona · 07/15/08, 1:51 PM

Originally Posted by Dafeaz

Just a quick question. I'm trying to benchmark my DPS against Cheeky's. Is there a way to configure it so that it assumes the target is, say, Dr. Boom? I can only seem to configure for bosses.

You can change the targets armor and level in the "Settings and Results"-tab under "Control Settings".

You can change the level only down to 70 but Dr. Boom is 68 so you would have to costomly add 1% (15.77 rating) hit to your gear after selecting level 70.

I don't know Dr. Boom's armor but looking to this post: [RAID] Boss armor values
"A similar pattern occurs in the trash mobs: 5475/5700/5950 or 6800/7100/7400 for level 70/71/72 mobs."

I would guess his armor is 6200 (he is a warrior typ mob).

The armor value is probably wrong but i couldn't find any better infos on it.