WotLK DPS spreadsheet - Page 131

Eilleye · 08/09/09, 5:40 PM

Use the custom gear tab and input the numbers. Items will show up in the gear planner. Unfortunately, you can only model one of each slot.

Stara · 08/09/09, 8:00 PM

Originally Posted by Thorinson

The gear planner assumes you always regem when you switch any piece of gear. I bet that if you made the first swap you mentioned and hit the regem button, the DPS increase is exactly what the gear planner indicated.

Why you are correct sir.

Things look a lot better there now. Thanks.

GwolfGarona · 08/09/09, 10:19 PM

Originally Posted by Thorinson

Now that Shandara seems to be occupied, I'd like to add some new gear that's still missing to the spreadsheet myself. I'd really like them to show up in the gear planner.

Does anybody know if this is possible and more importantly how to do this?

You can also unhide the tabs for gear lists and add a new row(s). Nothing is locked on the hidden tab and unhiding is not protected. But you can break the sheet entirely if you are not careful.

Shariah · 08/09/09, 10:53 PM

Im sorry if this seems stupid, kinda new to this thing, does the spreadsheet work on vista?e

gravemente · 08/10/09, 10:08 AM

Hey, been driving myself nuts with this thing all morning. The spreadsheet appeared to be giving me a score that differed in hit rating from that displayed in my character tab by 6.

After messing around with it and equiping different items, it seems the game gives a +6 hit rating bonus for the enchanted tear gem while the spreadsheet doesnt. Im assuming this is a known bug in the spreadsheet and that the game calculator is correct. Can someone confirm?

gravemente · 08/10/09, 10:45 AM

Ive been using the gear planner to evaluate whether to roll on drops in raids quickly since I believed that would an accurate guide. I thought Delta in the gear planner was some sort of calulation of the total dps value of each item (with a score generated for each stat depending on its value to the character).

So Ive been trying to decide between Gloves of Taut Grip (Ilevel 219) and Gloves of the Firey Behemoth (Ilevel 226). The second item shows a -47.38 Delta to the first item even though its of a higher level. The strange thing is that when I change the item in the spreadsheet manually (and correct for gems etc) my calculated dps rises from 6963 to 6979.

So Im wondering what delta actually is and whether the gear planner tab in the spreadsheet can actually be used to calculate which items are best for which slot. If it cant, Im guessing Ive missing out on rolling on some choice items over the past few months. Can anyone help with this?

Esoth · 08/10/09, 11:22 AM

Delta means difference. In this case it refers to the expected value of a piece of gear in the gear planner subtracted by the expected value of your equipped item.

Kathucka · 08/10/09, 3:03 PM

Originally Posted by gravemente

Ive been using the gear planner to evaluate whether to roll on drops in raids quickly since I believed that would an accurate guide. I thought Delta in the gear planner was some sort of calulation of the total dps value of each item (with a score generated for each stat depending on its value to the character).

It was done this way, but this led to poor calculations, due to the way it dealt with hit rating.

Now, it swaps in each item, re-gems your gear, and calculates the DPS. This has poor calculations, due to the way it re-gems somewhat sub-optimally.

In short, the deltas from the gear planner shouldn't be trusted. They're probably wrong.

So Ive been trying to decide between Gloves of Taut Grip (Ilevel 219) and Gloves of the Firey Behemoth (Ilevel 226). The second item shows a -47.38 Delta to the first item even though its of a higher level. The strange thing is that when I change the item in the spreadsheet manually (and correct for gems etc) my calculated dps rises from 6963 to 6979.

Swapping the item in manually and re-gemming and re-enchanting manually, as you have done, is the only way to get a good comparison. It's not really reasonable to do that during a raid, though.

So Im wondering what delta actually is

It's the difference in DPS between the gear you have now, and the gear you would have if you swapped in that item.

and whether the gear planner tab in the spreadsheet can actually be used to calculate which items are best for which slot.

Until it gets fixed, no. (Disclaimer: It may already be fixed. I haven't checked.)

If it cant, Im guessing Ive missing out on rolling on some choice items over the past few months.

Probably. In particular, it tends to show items you're not wearing with a DPS stat that is too low. Sorry.

vith · 08/10/09, 5:22 PM

Custom item import from armory seems to have problems with [Stormrune Edge]. First I got a type-mismatch, but when I tried to reproduce the exact error to report it, no error occurred but every field is #N/A for it on the Gear tab. But anyway it's just a rename of "Rune Edge".

Kaubel · 08/11/09, 12:27 PM

I swear you guys are almost as bad as DKs. Six posts on this page alone had to be tossed, and I have much better things to do with my time than clean up after a bunch of retarded paladins.

If I see one more post asking about updates, or commenting about what operating systems do and don't work with the spreadsheet, I'm going to go fucking nuts with the banhammer.

Whitefyst · 08/11/09, 5:03 PM

Originally Posted by Kathucka

Swapping the item in manually and re-gemming and re-enchanting manually, as you have done, is the only way to get a good comparison. It's not really reasonable to do that during a raid, though.

Actually, if you set up all of the regemming options properly on the Setttings Tab for what you would normally do, it does a very good estimate of the delta DPS of the item. Originally, the numbers generated were way off for me until I discovered that I incorrectly used some of the settings. Now it is a pretty accurate estimate (within the limitations of the gemming choices I set up). Is it perfect? No, the gems used may still not be optimal, although in most cases they are since the choices are pretty straight forward, and when they are not, the optimal set is usually not much better. As such, I found that I need to spend a lot less time doing manual checks ahead of time of the real deltas. The only ones I worry about are the changes that are within a small DPS difference of each other (in which case it is usually not a big deal if you do not take the item); otherwise, the answer is usually pretty clear.

Something that helps the situation is the fact that we can now trade items within a certain period of time so there usually is not as much rush to have an answer immediately if your guild leaders are flexible and it really doesn't take that long to do a manual swap of an item in real-time.

Bees · 08/11/09, 9:02 PM

possible item bug with Signet of Edward the Odd - the effect uses a static 'Average Time Per Shot' of 0.9 (in Calculations!T72), when it should probably use =IF(TotalShotsPerSecond>0,1/TotalShotsPerSecond/FinalHit,0)

[edit] Although of course TotalShotsPerSecond needs haste to calculate it, and this ring causes haste. So this is a reasonable estimation unless you want to calculate everything once without the ring, then add it in, then recalculate.

[edit2] Calculations!P131 incorrectly says Pyrite Infuser when it is in fact Tears of Bitter Anguish

[edit3] AP from Call of the Wild ('Pet Calculations'C52) should use the frequency of CotW, not the cooldown

[edit4] On Proc +AP box has duplicates for 'Fury of the Five Flights' and 'Pyrite Infuser' - the second versions (E74:E75) will always be zero and can be removed.

[edit5] Madness of the Betrayer is no longer available for selection, nor is its effect calculated. It should be removed from the ArP on proc list at Calulations!P18

[edit6] Troll Berserking uses the cooldown rather than the real frequency for effect calculation (Calculations!H27)

Shandara · 08/12/09, 10:51 AM

Having just returned from my vacation I see patch 3.2 has arrived! I will be doing some catching up first and then I'll see about fixing the bugs that have crept up.

Aciara · 08/12/09, 1:27 PM

I seem to be to stupid to use the Gear Optimizer Tab. When I put in some of my gear into all of the slots and hit the Optimize button a new bar pops up saying Loop 1 of 20 (or whatever I have iterations set to) and this bar counts forward until the loop is "done". This goes on with no error message what so ever but after it's done I can't see any result in any of the tabs (the gear I put in doesn't change places either I've tried with different gear on the top).

I'd very much like to try this feature and neither your short FAQ, nor the linked guide nor any of the last few pages (+search) helped me. If you could point me in the right direction it would be very much appreciated, thanks.

Shandara · 08/12/09, 2:03 PM

Originally Posted by Aciara

I seem to be to stupid to use the Gear Optimizer Tab. When I put in some of my gear into all of the slots and hit the Optimize button a new bar pops up saying Loop 1 of 20 (or whatever I have iterations set to) and this bar counts forward until the loop is "done". This goes on with no error message what so ever but after it's done I can't see any result in any of the tabs (the gear I put in doesn't change places either I've tried with different gear on the top).

I'd very much like to try this feature and neither your short FAQ, nor the linked guide nor any of the last few pages (+search) helped me. If you could point me in the right direction it would be very much appreciated, thanks.

After the optimizer has run the Gear tab will have the 'optimum' set.

Allara · 08/12/09, 4:48 PM

[Armbands of the Northern Stalker] (from Colliseum 10) are incorrectly named Bracers of the Northern Stalker in the spreadsheet.

Nandei · 08/12/09, 5:00 PM

Originally Posted by Allara

[Armbands of the Northern Stalker] (from Colliseum 10) are incorrectly named Bracers of the Northern Stalker in the spreadsheet.

That isn't exactly incorrect. [Bracers of the Northern Stalker] is the Horde version of the same item.

Shandara · 08/12/09, 5:19 PM

Update:

- corrected spelling of Kirin Tor ring upgrade
- Added some missing gear: Charge of the Demon Lord, Banner of Victory, Mark of Supremacy, Shard of the Crystal Heart, Relentless Gladiator's Repeater, Dextrous Brightstone Ring, Pauldrons of the Devourer, Ancient Pendant of Arathor, Warsong Poacher's Greaves, Sentinel Scouting Greaves, Blood Fury, Stygian/Steel Bladebreaker, Breastplate/Cuirass of Cruel Intent, Leggings/Legguards of the Lurking Threat
- Fixed spelling on Greaves/Sabatons of Ruthless Judgment and Ring/Band of Callous Aggression
- Renamed Rune Edge to Stormrune Edge
- Mjolnir trinket now 665 ArP
- Fixed trinkets with +haste on-use effects
- Fixed Mighty/Assassin's Alchemist Stones
- Fixed Nitro Boosts feet enchant
- Corrected spelling on Collar of Unending/Ceaseless Torment
- Custom items will now be checked by the Gear Planner, it disregards the iLevel check for them
- Upgraded default gems to their epic versions
- Scorpid Poison dps now uses actual frequency
- Scorpid Poison/Spirit Strike now also use the 4.29% pet scaling factor
- Fixed various 'pet skills' tab bugs 
- Poison Spit dps now uses the actual number of ticks
- Spore Cloud also uses the real frequency now
- Fixed #DIV/0 bug with Acid Spit
- Monstrous Bite calculations now use real frequency
- Changing any talent on the pet talent tab now updates the list of abilities available to the pet
- Fixed pet skill drop-down menus to include missing skills for Cunning/Tenacity pets
- Bestial Wrath's mana reduction now affects Kill Command
- Fixed ranged weapon type on relentless gladiatior's gun

If I forgot anything that was PM'ed to me or posted in this thread, please tell me again. Also let me know if you still have problems importing things from the Armory.

dvorjak · 08/12/09, 5:30 PM

Rune edge will not load, and it should be renamed Stormrune Edge.

Shandara · 08/12/09, 5:37 PM

Originally Posted by dvorjak

Rune edge will not load, and it should be renamed Stormrune Edge.

I did change the name for it in the sheet, but forgot to repopulate the drop-down menu. I've re-uploaded the sheet fixing this issue.

Crydak · 08/12/09, 6:03 PM

Not sure,but how about the new LnL procc?

Bees · 08/12/09, 6:04 PM

[edit] ignore me, had the wrong settings toggled - it's correctly back at freq=0 when i managed to disable the rotation test

Shandara · 08/12/09, 6:06 PM

Originally Posted by Bees

something seems to be up with Kill Shot - when i put it in my rotation I get it showing up with a frequency/dps/mps even though i have kill shot usage set to Sub-20% (I'm using the frequency calculator, not the rotation test).

not certain what's wrong yet, but trying to figure it out

It automatically factors in Kill Shot use based on the the sub-20% setting, i.e. 1/5th of the boss fight. Set it to 'never' to disable it (or remove it from the rotation) or set the boss hp to sub-20% to make it active 100% of the time.

bronnum · 08/12/09, 6:17 PM

Any possibility you will release a version with editable proc rating for LnL, as it seems to be way higher than 6% atm, seems to be somewhere between 15-20% proc rating according to small test samples.

yes/no?

pabelanger · 08/12/09, 6:36 PM

I'm still running into 'Run-time error '13': Type mismatch with the latest version. I can reproduce it every time by attempting to re-load your 'gear from armory'.

Rift Stalker Mantle
Rift Stalker Hauberk
Etched Band of the Kirin Tor