Hunter Spreadsheets -- In development - Page 91

groma · 07/08/08, 6: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, 10: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, 12:07 PM

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, 6: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, 12:32 PM

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, 4: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, 4: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, 8:07 PM

Dear Cheeky,

We miss you. Please come back soon.

Varesz · 07/14/08, 7: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, 6: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, 6: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, 8:58 AM

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

God I feel stupid now

Dafeaz · 07/15/08, 11: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, 2: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, 2: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.

Keltarrant · 07/15/08, 4:46 PM

says the file is passworded for me

dont know how to fix this

Cheeky · 07/15/08, 5:19 PM

Originally Posted by Keltarrant

says the file is passworded for me

dont know how to fix this

That's only a problem if you want to modify it.

Keltarrant · 07/15/08, 6:27 PM

Originally Posted by Cheeky

That's only a problem if you want to modify it.

what do you mean?
because ive tryed saving it and opening it and it gives me that response
if i try just straight opening it, i get that response

Cheeky · 07/15/08, 6:49 PM

Originally Posted by Keltarrant

what do you mean?
because ive tryed saving it and opening it and it gives me that response
if i try just straight opening it, i get that response

What application are you using? When, exactly, are you getting this message?

RSkillz · 07/16/08, 4:03 AM

Originally Posted by Cheeky

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

That's fully understandable.

I'm wondering if there are otheres around that could take over your 'legacy' if (god forbid) you really decide to stop updating the spreadsheet.

Great to hear you're working on the performance part.

Keep up the great work!

Indora · 07/16/08, 10:47 AM

Originally Posted by Cheeky

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

As far as I know it's 10% procchance and 45 sec internal cooldown, just as the most other trinkets.
(These values are also used in every other Spreadsheet I could find.)

Here's a little calculation for the average ap gain over the 20 seconds uptime:

A1: Shots per Second

A2: Seconds until fully buffed:
10 / A1

A3: AP Boost:
IF( A2 > 20 ; 20 * A1 * 44 / 2 ; A2 / 20 * 220 + (1- A1) / 20 * 440)

edit:
reference

Cheeky · 07/16/08, 12:17 PM

Originally Posted by Indora

As far as I know it's 10% procchance and 45 sec internal cooldown, just as the most other trinkets.
(These values are also used in every other Spreadsheet I could find.)

Here's a little calculation for the average ap gain over the 20 seconds uptime:

A1: Shots per Second

A2: Seconds until fully buffed:
10 / A1

A3: AP Boost:
IF( A2 > 20 ; 20 * A1 * 44 / 2 ; A2 / 20 * 220 + (1- A1) / 20 * 440)

edit:
reference

Using a 45 second internal cooldown, and 10% chance to proc, I'm getting an average +AP gain of 126.5 for my gear and setup. Um, wow, this is a really nice trinket!

The Gear Planner lists it as 9 DPS better than the [Madness of the Betrayer], which sounds about right. (Equipping it for me doesn't help as much as my [Tsunami Talisman] since I am so close to my haste cap.)

◊ Sarutobi · 07/16/08, 12:28 PM

Originally Posted by Indora

A1: Shots per Second

A2: Seconds until fully buffed:
10 / A1

Wait. Shouldn't that be 10 * A1. Dividing by shots per second would imply that it took longer to get the max stack the faster your attack speed was. And really, it should be 10 * (A1 / hit chance).

Or maybe I'm misreading something.

Cheeky · 07/16/08, 12:59 PM

Originally Posted by Sarutobi

Wait. Shouldn't that be 10 * A1. Dividing by shots per second would imply that it took longer to get the max stack the faster your attack speed was. And really, it should be 10 * (A1 / hit chance).

Or maybe I'm misreading something.

Here is the model I landed up using:

Blackened Naaru Sliver	
Cooldown			45
Chance per shot to proc		10%
Max stack			10
+AP per stack			44 (Sap)
Maximum +AP			440 (Map)
Seconds per Shot		0.90 (Sps)
Time for Buff			20 (T)
Time to maximize proc		8.95 (Tm)
Average AP while under proc	341.51
Time between procs		53.95
Average uptime			37.07%
Average benefit in AP		126.59

My Calculation for the Average AP is as follows:

if (Tm < T)
  AP = ((Map * Tm * 0.5) + (Map * (T - Tm))) / 20
else
  AP = floor(T/SpS) * 44 * 0.5
endif

For time between procs:
10 * Sps + 45 (number shots to proc * seconds per shot + cooldown)

Anyone see any flaws? I will modify Seconds per Shot to be influenced by chance to hit (seconds per shot / hit %) With my 141 hit rating this lowers the average AP gain by 0.03 AP (to 126.56).

Unless, like Quick Shots, we discover the proc can occur on missed shots as well.

Lawled · 07/16/08, 1:54 PM

Originally Posted by Cheeky

Here is the model I landed up using:

Blackened Naaru Sliver	
Cooldown			45
Chance per shot to proc		10%
Max stack			10
+AP per stack			44 (Sap)
Maximum +AP			440 (Map)
Seconds per Shot		0.90 (Sps)
Time for Buff			20 (T)
Time to maximize proc		8.95 (Tm)
Average AP while under proc	341.51
Time between procs		53.95
Average uptime			37.07%
Average benefit in AP		126.59

My Calculation for the Average AP is as follows:

if (Tm < T)
  AP = ((Map * Tm * 0.5) + (Map * (T - Tm))) / 20
else
  AP = floor(T/SpS) * 44 * 0.5
endif

For time between procs:
10 * Sps + 45 (number shots to proc * seconds per shot + cooldown)

Anyone see any flaws? I will modify Seconds per Shot to be influenced by chance to hit (seconds per shot / hit %) With my 141 hit rating this lowers the average AP gain by 0.03 AP (to 126.56).

Unless, like Quick Shots, we discover the proc can occur on missed shots as well.

I'm not to good with it comes this this stuff ..

But for "Time to maximize proc 8.95 (Tm)"

Does that mean it takes 9 seconds to get the full 440 AP? If it procs 1/10 hits, to get a full 10 stack you would need 100 shots .. correct?

Don't quote me on this, maybe I'm just confused lol.