WotLK DPS spreadsheet - Page 60

Kharthus · 01/29/09, 1:04 PM

Shandara,

Is there any way to get the armory import to use the Internet Options settings instead of assuming you're directly connected to the internet? This would allow people behind proxy servers to do gear imports.

Thanks.

jmlsteele · 01/29/09, 2:39 PM

Originally Posted by daeranmoth

thank you seoman but i was talking about the tab "overview" and in the hunter statistics section after hitting the buton "calcattributes" it shows me that hunter hit +1 is equal to 1,415dps and is the second best after the agility+1 which is equal to 1,423dps. In the "needed to cap hit" i have " -27" which is correct.
Is it a bug for the hunter hit +1 or not ?

It's not a bug so much as a design feature. The way the rest of the CalcAttributes stats work are to temporarily add 10 of that attribute, compare the new DPS, and then divide by 10. Hit used to be this way, but it is currently commented out and has been replaced by a function that temporarily removes all your +hit from your gear, and then compares the DPS you would do then with the DPS you would do while capped, and then divides by however much +hit you need to cap.

The effect this has is that changing the amount of hit on your gear (so long as everything else stays the same) doesn't change the value of hit.

I'm not the one who wrote this part of it, just someone who was wondering the same thing as you, with the ability to understand the code

Looks like it was changed back on May 12th to allow for better item comparisons.

Originally Posted by Changelog

- Provide value of hit based off of have 0 +hit gear (useful for item DPS comparisons.)

desseb · 01/29/09, 4:01 PM

What does "Lock&Load # of shots replaced" mean in the settings tab?

Is it the # of shots you interleave between LnL procs? I checked the last few pages but didn't see anything on this new setting.

zigmund555 · 01/29/09, 4:55 PM

Am I missing something here?

It seems that whenever you add in replenishment/mana buffs it always shows a DPS increase. If I change the replenishment uptime to 100%, Judgement of Wisdom to Yes and add in Elixir of Mighty Thoughts, it shows a DPS increase. In a 25-man setting my mana bar barely moves the entire fight. It seems that taking the Int elixir is sort of a waste.

Seoman · 01/29/09, 5:12 PM

Gem behavior

1. Not that it's the best gem or anything (and I don't have the best helmet yet) but the spreadsheet seems to think Swift Skyflare Diamond needs 2 Blue Gems in order for its AP to be operational, when in fact it needs 2 Yellow and 1 Red.

2. I haven't tested fully for other varieties, but at least Solid Sky Sapphire +24, clearly blue, is called Yellow by the spreadsheet, for the purposes of item socket bonuses and Meta requirements.

Seoman · 01/29/09, 5:15 PM

Originally Posted by zigmund555

Am I missing something here?

It seems that whenever you add in replenishment/mana buffs it always shows a DPS increase. If I change the replenishment uptime to 100%, Judgement of Wisdom to Yes and add in Elixir of Mighty Thoughts, it shows a DPS increase. In a 25-man setting my mana bar barely moves the entire fight. It seems that taking the Int elixir is sort of a waste.

I can't speak for the mechanics of Replenishment, etc. but the Int Elixir gives you AP via Careful Aim... kinda nice for a Guardian Elixir, no?

noglen · 01/29/09, 7:27 PM

Originally Posted by Kharthus

Shandara,

Is there any way to get the armory import to use the Internet Options settings instead of assuming you're directly connected to the internet? This would allow people behind proxy servers to do gear imports.

Thanks.

You can use the proxycfg command from a command prompt to set a proxy.

To do so, click start, run, type cmd and click OK

type proxycfg -p [proxy name]:[port] and hit enter

thehittmann1981 · 01/30/09, 12:16 AM

There seems to be a bug with latency in the Spreadsheet. Here are my current buffed dps outcomes when changing latency.

0.1 - 6025.12dps
0.2 - 5857.80dps
0.3 - 5696.52dps
0.4 - 5531.74dps
0.5 - 5779.99dps (back up again)

kanttori · 01/30/09, 9:38 AM

Noticed a bug when deleting a profile in the Gear tab, even if you change your mind and choose "no" it still deletes it.

♦ arison · 01/30/09, 1:59 PM

Rapid Fire and Kill Shot are no longer on the GCD (yay).

Shandara · 01/30/09, 2:32 PM

Update:

- Swift Skyflare Diamond gem requirements fixed
- Solid Sky Sapphire is now a blue gem
- Added Titan-forged Chain Helm/Sabatons of Triumph
- Fixed confirmation dialog on deleting a profile
- Rapid Fire/Kill Shot no longer on GCD
- Fixed bug involving elixirs not loading properly from profiles

Kharthus · 01/31/09, 12:23 AM

One small bug:

Jormungar Leg Reinforcements is showing as 18agi/50stam when it should be 22agi/55stam.

Khallas · 01/31/09, 8:03 PM

I am not sure why this is still in the spreadsheet, but the Mana Oil's cannot be put on level 71+ weapons. Having this included in the default Lvl 80 raid buff profile skews DPS results a little bit.

Grimzim · 02/01/09, 4:23 AM

I have one question regarding the spreadsheet DPS numbers - I'm trying to test my spec and verify the values on the lvl 80 boss target dummy, however I'm ending up with ~300 DPS less than the spreadsheet tells me I should have. As far as I know I entered all data correct, from glyphs to gear, talents, shot rotation, latency etc. - I double checked all tabs of the spreadsheet. I'm using the buff profile with no buffs set and I'm current speced survicval (0/17/54).

Any ideas on what might cause this 10% DPS difference (I'm getting ~2700 DPS instead of ~3000 the spreadsheet models)?

Hunterlin · 02/01/09, 5:11 AM

Deleting my post.
While there are some minor stat differences between char and sheet(sheet have 2 int less than my char), my posted stats where with talents so completely wrong too.

Vitaro · 02/01/09, 8:06 AM

Originally Posted by Grimzim

Any ideas on what might cause this 10% DPS difference (I'm getting ~2700 DPS instead of ~3000 the spreadsheet models)?

You must be doing something wrong. I've tested a Survival spec similar to yours with worse gear and gotten up to 3.2k at the heroic boss dummy. Are you properly letting Explosive Shot do all of it's ticks while under TnT? Did you get the highest rank in ES from the trainer? Most likely you did or you'd be hard pressed getting to 2.7k in the first place. Are you certain that you are standing outside of 30 yards range for Sniper Training?

The spreadsheet is not wrong in projecting 3k for your gear level: In fact I think that's on the low side - you should actually be doing about 10% more.

Grimzim · 02/01/09, 8:55 AM

Originally Posted by Vitaro

You must be doing something wrong. I've tested a Survival spec similar to yours with worse gear and gotten up to 3.2k at the heroic boss dummy. Are you properly letting Explosive Shot do all of it's ticks while under TnT? Did you get the highest rank in ES from the trainer? Most likely you did or you'd be hard pressed getting to 2.7k in the first place. Are you certain that you are standing outside of 30 yards range for Sniper Training?

The spreadsheet is not wrong in projecting 3k for your gear level: In fact I think that's on the low side - you should actually be doing about 10% more.

Thanks for reply - that answers my question regaring correctness of the spreadsheet and modeling of unbuffed target dummy DPS. I checked everything and I assume it's coming from a bugged / wrong Recount version - after updating my addons I get much higher values now (~3k to 3.3k DPS).

ahhzz · 02/01/09, 9:36 AM

Where did the Custom Trink spot go? And while I REALLY appreciate you taking this up from Cheeky, Shan, Is there a reason you keep pulling out more and more gear as you go?

Nooska · 02/01/09, 9:37 AM

Originally Posted by ahhzz

Where did the Custom Trink spot go? And while I REALLY appreciate you taking this up from Cheeky, Shan, Is there a reason you keep pulling out more and more gear as you go?

More and more of the gear becomes useless in regards to the spread sheets purpose.

Shandara · 02/01/09, 10:01 AM

Originally Posted by ahhzz

Where did the Custom Trink spot go? And while I REALLY appreciate you taking this up from Cheeky, Shan, Is there a reason you keep pulling out more and more gear as you go?

There never was a custom trinket spot.

And the main reason I'm removing old gear is that it needlessly bloats and slows down the spreadsheet. I can not imagine anyone interested in raid dps (which is what this sheet is designed for) will be wearing pre-TBC gear at this point.

I understand people are interested in leveling and maybe 5-man gearing, but that isn't really what this sheet is aimed at.

ahhzz · 02/01/09, 10:29 AM

Using Darkmoon Crusade right now. Haven't found anything better yet.

TrevvyTrev · 02/01/09, 11:55 AM

Originally Posted by ahhzz

Using Darkmoon Crusade right now. Haven't found anything better yet.

I thought trinkets weren't supposed to be removed anyway, but in any event you probably did find something better, but didn't know it. Using an older version of the spreadsheet that still has the Darkmoon Card: Crusade, I got increased dps by upgrading it to WotLK quest rewards, like Fezzik's Pocketwatch, for example.

jmlsteele · 02/01/09, 12:56 PM

Going through the spreadsheet trying to get it to work in OOo (don't expect anything amazing, just looking at base functionality thus far) and If I find any errors I'll report them back to you as I find them.

Calculations.B19: TrueShotRankSet should be TSARankSet

Syreesaebe · 02/01/09, 10:12 PM

On the next spreadsheet update, would be good to get an option to customise the two trinket slots.

Vaxum · 02/02/09, 5:21 AM

Bug report - [Arcanum of Ferocity] is incorrectly adding 10% haste on top of the base stats.

Calculations!H22 is doing a test of "=IF(Gear!B22=Head!A45,1.01,1)*...", comparing the selected head enchant to "Arcanum of Ferocity" in Head then adding 10% haste. This looks like a bad reference (should be to Head!A46, not A45), and also vestige of old code where Arcanum of Rapidity added 10% haste, not +10 haste rating - so even Arcanum of Rapidity would now be wrong.