 |
| Welcome to Elitist Jerks |
We're testing some new features on the site regarding OpenID registration and coordination with gamerDNA. If you experience any issues with registering an account, please take the time to fill out a report and send it to this e-mail address. We would appreciate any assistance you could provide in making sure everything is functioning as intended. Thanks!
If this is your first visit, please be sure to check out the FAQ and the forum rules. Users must register to post and new registrations are subject to a one day "mute" period to get acquainted with the community.
|
07/08/08, 6:59 AM
|
#2251
|
|
Glass Joe
Night Elf Hunter
Mug'thol (EU)
|
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.
|
|
|
|
|
|
07/08/08, 10:02 AM
|
#2252
|
|
Glass Joe
Night Elf Hunter
Outland (EU)
|
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?
|
|
|
|
|
|
07/08/08, 12:07 PM
|
#2253
|
|
Glass Joe
Night Elf Hunter
Mug'thol (EU)
|
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
|
|
|
|
|
|
07/10/08, 6:02 AM
|
#2254
|
|
Glass Joe
|
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.
|
|
|
|
|
|
07/10/08, 12:32 PM
|
#2255
|
|
Bald Bull
|
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.
|
|
|
|
|
|
07/11/08, 4:43 PM
|
#2257
|
|
Piston Honda
Night Elf Hunter
Laughing Skull
|
Originally Posted by Uthane
|
Yeah, we're all still waiting for version 50 to appear.

|
|
|
|
|
|
07/11/08, 8:07 PM
|
#2258
|
|
Free Arrows For Life
Tauren Death Knight
Mal'Ganis
|
Dear Cheeky,
We miss you. Please come back soon.
|
Omegatron has arrived.
|
|
|
|
07/14/08, 7:37 AM
|
#2259
|
|
Von Kaiser
Night Elf Hunter
Ravencrest (EU)
|
Originally Posted by Uthane
|
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.
|
|
|
|
|
|
07/15/08, 6:08 AM
|
#2260
|
|
Glass Joe
Orc Hunter
Earthen Ring (EU)
|
Hit
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 ?
|
|
|
|
|
|
07/15/08, 6:22 AM
|
#2261
|
|
Piston Honda
Tauren Druid
Stormreaver (EU)
|
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.
|
|
|
|
|
|
07/15/08, 8:58 AM
|
#2262
|
|
Glass Joe
Orc Hunter
Earthen Ring (EU)
|
Well I had checked everything..... except the fairy fire thingy
 God I feel stupid now
|
|
|
|
|
|
07/15/08, 11:36 AM
|
#2263
|
|
Von Kaiser
|
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.
|
Some people think they can outsmart me. Maybe.
Maybe.
I've yet to meet one who can outsmart bullet.
|
|
|
|
07/15/08, 2:40 PM
|
#2264
|
|
Bastard
Cheeky
Troll Hunter
No WoW Account
|
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?
|
|
|
|
|
07/15/08, 2:51 PM
|
#2265
|
|
Piston Honda
Dwarf Warrior
Blackrock (EU)
|
|
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.
|
|
|
|
|
|
07/15/08, 4:46 PM
|
#2266
|
|
Glass Joe
|
password
says the file is passworded for me 
dont know how to fix this
|
|
|
|
|
|
07/15/08, 5:19 PM
|
#2267
|
|
Bastard
Cheeky
Troll Hunter
No WoW Account
|
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.
|
|
|
|
|
07/15/08, 6:27 PM
|
#2268
|
|
Glass Joe
|
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
|
|
|
|
|
|
07/15/08, 6:49 PM
|
#2269
|
|
Bastard
Cheeky
Troll Hunter
No WoW Account
|
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?
|
|
|
|
|
07/16/08, 4:03 AM
|
#2270
|
|
Von Kaiser
Tauren Hunter
Azjol-Nerub (EU)
|
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!
|
|
|
|
|
|
07/16/08, 10:47 AM
|
#2271
|
|
Von Kaiser
Draenei Hunter
Azshara (EU)
|
Originally Posted by Cheeky
|
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
Last edited by Indora : 07/16/08 at 3:18 PM.
|
|
|
|
|
|
07/16/08, 12:17 PM
|
#2272
|
|
Bastard
Cheeky
Troll Hunter
No WoW Account
|
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.)
|
|
|
|
|
07/16/08, 12:28 PM
|
#2273
|
|
Needs to think of a better user title.
Blood Elf Paladin
Mal'Ganis
|
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.
|
Originally Posted by DeeNogger
Every time I bite into an oatmeal raisin cookie mistaken for a chocolate-chip an angle loses its wings. Fucking trani's of the cookie world!
|
Originally Posted by castille
Squirrel sex. Get your nut and go home.
|
|
|
|
|
07/16/08, 12:59 PM
|
#2274
|
|
Bastard
Cheeky
Troll Hunter
No WoW Account
|
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.
|
|
|
|
|
07/16/08, 1:54 PM
|
#2275
|
|
Glass Joe
Blood Elf Hunter
Azjol-Nerub
|
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.
|
|
|
|
|
|
|