Rozzenwyn

Load From Talents on DPS page does not load Master Conjurer properly. When I load talents from Armory it fills it correctly on the talents page but when I then say Load from Talents on DPS page it stays 0 even though I have 2 points in Master conjurer. I fix it manually but thought I'd report the bug.

 

Oth

Note: In the version I downloaded, the Gear Buff tab is still looking for 4 pieces of T7 rather than 2 when calculating this.

Also: I know my gear is lousy, but it would be nice to add some of the decent green trinkets as well (Will of the Red Dragonflight, for example...)

EDIT: Oh, another item-related deal. Shattered Sun Pendants of <X> are in the gear buff calculations, but aren't in the gear list, so they don't get loaded when reading from the armory (example: me, don't ask).

http://sig.gamerdna.com/quizzes/INFL...h-cenarius.png

 

Debby

Anybody tried to open this one with excel 2007? I get so many unrecognized text errors...

 

Yinchie

Using Excel 2007 as well, still got errors.

 

Bakka

New version posted at WoW Warlock DPS Spreadsheet

I included some fixes from Whitetooth's sheet along with some of my own. Though I greatly appreciate people finding issues with the spreadsheet and reporting them, I prefer that people not post alternate versions of my spreadsheet or even a completely separate spreadsheet in this thread. Please simply report the problems with my version in this thread. If you have a version of a spreadsheet you wish to share with the community, please create your own thread. This thread is one of two ways for people to report issues with my sheet and if there are multiple sheets in one thread, it is difficult for me to know which sheet a person is reporting a bug for.

Also please stop reporting people (myself included) for their posts. People being banned for actually contributing to the community is stupid.

Thanks.

 

ostoles

I am using Excel 2007 and when attempting to use spreadsheet that Whitetooth posted (r16), I was indeed having issues that seem to be related to the lookups of items/etc. That being said, within the last ~10 minutes Leulier's site was updated with 3.03i which seems to incorporate some (all?) of Whitetooth's fixes. I am using that currently and experiencing none of the issues I experienced opening r16 from Whitetooth.

edit: I guess it was only some of the fixes according to Bakka's post.

 

Yinchie

Nice update, experiencing no problems or issues now with the warlock_dps_v303i version in Excell 2007.
Keep up the great job

 

Whitetooth

Thanks Bakka. My intent was not to create a separate version of this spreadsheet, but to not only report bugs to you and also help provide a solution you could easily add to your next version.

You can see I've have a very detailed documentation on every change I made, so that you can easily find them.

My reports with recommended fixes will always be based on your most recent version so that it doesn't become a separate version of its own.

Issues I've fixed in warlock_dps_v303h_whitetooth_r16.xls that still remain in 3.0.3i:

- Armory Import: Fixed meta gems VBA code
Please check out the armory import code for head slot, or the meta gem will always be "None"

- Total Crit is still wrong, Warlocks have 1.7% base spell crit

- 2 decimal places for values for ratings required for 1% crit, hit, and haste isn't enough

- weapon dps sorting isn't fixed, the real solution is redefining the items_mh table

- Items: Hit Option: Ignore after cap still isn't working, also needs to be able to set the hit cap you want in the calculation for it to be useful.

- T7 bonus isn't in, what do you think of my model?
- 4pc Tier7 support: Gives spirit based on life tap frequency in DPS tab
- 2pc Tier7 support: Shadow Bolt and Incinerate has increased crit chance by 10% * Demonic Soul uptime
Demonic Soul uptime calculation: Filler_Frequency = Filler_Cast_Time / Filler_Ratio
CI = Corruption and Immolate ticks per sec (depends on if you use it in your rotation)
Demonic Soul uptime = 1 - (1 - 0.15)^(Filler_Frequency * CI)

- In your new Trinket Procs tab:
- The proper formula for Avg proc period for a CD proc is: CD + [attack period] * (1-proc%) / proc%, not CD + [attack period] / proc%
- For attack period, you should use the calculated in the Advanced infos tab, its accurate.

- Items page still hard to read, please use alternating backgound color and proper borders like the original TBC spreadsheet.

- +1 int, +1 stam, +1 spi values should consider stat modifiers like BOK and Human Spirit if set in Gear_Buffs tab.

- Shawl of the Old Maid really does gives 39 spirit, even though it says +38 spirit (I have the item, checked without BOK, and I'm not human) can anyone confirm?

- These items need to be removed:
- Trinkets that do nothing (like Argent Dawn Banner...etc)
- Trinkets that give attack power on use/proc
- Trinkets that require melee attacks or direct heals to proc

Hotdogee@Ner'zhul US <Bahamut>
Author of RatingBuster

 

Delc

Thanks much for your awesome work. Started messing with this today and ran across a couple small problems. Demonic Aegis doesn't seem to be buffing fel armor correctly, the bonus is only applying to the base damage and not the spirit bonus. I think the cell on the gear_buffs page should read:

=IF(B76,(180+M4*0.3)* (1+daegis*0.1),0)

On the import talents page, improved corruption and improved drain soul seem to be reversed. Inscription shoulder enchants are missing as well.

 

Bakka

RE: Whitetooth
Thanks for the info and time, I'll make sure to include some of these changes in the next version.

Your equation for avg proc is wrong though. According to your equation a proc rate of 50% and higher would be less than or equal to 1. 1/x is the correct formula for determining avg number of attempts it takes for a proc to occur.

 

Whitetooth

Let me explain with some examples how it works, it'll make sense once you realize your first attack starts at time 0 rather then time [attack period].

CD + [attack period] * (1-proc%) / proc%

what we are calculating here is how long it takes to proc after CD time.

If the proc is 100%, the proc will go off immediately when the CD ends at time 0, which means the every CD seconds:
CD + [attack period] * (1-1)/1 = CD + [attack period] * 0

If the proc is 50%, it will proc on average every 2 hits, the first hit at time 0 and the second hit at time [attack period] after the CD ends, which actually translates to 1 [attack period], not 2:
CD + [attack period] * (1-0.5)/0.5 = CD + [attack period] * 1

If the proc is higher then 50%, it would actually take less then 1 [attack period] to proc on average:
CD + [attack period] * (1-0.75)/0.75 = CD + [attack period] * 0.333

This formula was originally used by Leulier's which I believe is a better model.

Hotdogee@Ner'zhul US <Bahamut>
Author of RatingBuster

 

Rozzenwyn

version I - Looks like the trinkets page is looking for a page called "Models" that does not exist for some trinkets (example Embrace of the Spider) and this breaks calculations giving an N/A for the "trinket procs" column which then gives N/A for all sorts of other columns on the DPS page.

 

Abidos

I can confirm Shawl of the old maid giving 39 spirit, instead of 38. BE so human spirit buff doesn't apply

 

Carabar

Posting asks / corrections here as requested.

It would be great if you could add sockets for rings and trinkets, as some of the newer rings and the JC trinkets have 1-2 gem sockets each, which are currently not reflected in the spreadsheet.

 

Bakka

It's also a best case scenario assuming that a cast is landing at time 0 which is far from realistic. My equation is a worst case scenario and I feel closer to a realistic model.

Umm works for me.

Already added to my current working version; so you'll see it in version j.


If there are problems with item stats being incorrect, report it to wowhead. They won't get changed in the spreadsheet unless they get changed in wowhead.

 

Whitetooth

In the case of Shawl of the Old Maid, there is nothing wrong with wowhead saying its +38 Spirit, because thats just how it is displayed in game. The problems is it "actually" gives +39 Spirit, its one of those rare cases that an item doesn't give what it says it gives. You can pull item data out of wowhead with a script, but sometimes manual editing is still needed.

Hotdogee@Ner'zhul US <Bahamut>
Author of RatingBuster

 

Rozzenwyn

Sheesh guys, how much is ONE spirit really gonna change your calculations? IMO not enough to bug Bakka about it since you admit that its an IN GAME bug and all the reporting features have it wrong because the game itself has it wrong.


Bakka - Hmm its working from work today but last night from home the trinket lookup seemed to be broken. Strange since work is 2007 (which most people seem to have lots of issues using the spreadsheet with but I don't) and home is 2003. Thanks for looking at it though. This worksheet is a godsend for me!

 

Whitetooth

Since the aim of this spreadsheet is neither best case nor worst case, but the average case scenario. I suggest using an average case formula to model trinket proc calculations:

CD + ([attack period] / proc%) - ([attack period] * 0.5)
= CD + [attack period] * (1-0.5*proc%) / proc%

Hotdogee@Ner'zhul US <Bahamut>
Author of RatingBuster

 

Grevann

I'm using OpenOffice 3.0, and getting many many "#MACRO?" errors all over the spreadsheet. I was using 2.4 and getting version G to work fine, although nothing since then. After updating to OO3.0 every version is just completely broken. Bakka has made it clear that he doesn't provide troubleshooting, or a user guide. So, I suppose my question is: Does this spreadsheet work on anything besides Excell 2007? And if so, what?

 

Aedius

The dps from hit raiting doesn't seem to be getting calculated.

Edit: Nevermind this post. Somehow I broke something right as I opened the speadsheet.

 

Selrach

In version 3.0.3i, the items_wand region is missing the 5 first wands while the items_wand_list have them

 

Evyle

In a post by Whitetooth there was mention of removing the "requires a direct heal to proc" trinkets from the list.
At current the Egg trinket will proc from fel armor ticks (I am still stuck using it till a better trinket drops). It is hard to have much control over it.. but you will still get a few procs here and there from it during any given boss fight.

 

Evyle

Maybe I am just missing where it is at... but under the selectable raid buffs

I do not see a selection for

Totem of Wrath Rank 4
Summons a Totem of Wrath with 5 health at the feet of the caster. The totem increases spell power by 280 for all party and raid members, and increases the critical strike chance of all attacks by 3% against all enemies within 40 yards. Lasts 5 min.

Fel Intelligence Rank 5 (we don't have a raiding disc priest... but we have a fel puppy out for the spirit bonus)
20 yd range
Instant
Increases party and raid members Intellect by 48 and Spirit by 64

 

Rozzenwyn

Better hope something else drops quick. This is expected to change next patch to no longer be useful to locks at all.


Evyle - Totem of Wrath is listed as one of the buffs on the gears_buffs tab that you can select. There are no ranks, it assumes the highest. I'm not sure if Fel Intelligence is listed there or not. I haven't noticed it so its possible its not but I haven't looked for it directly either.

 

inktomi

I'm getting an error when I try to open this in the latest Excel for OS X.

"This workbook contains defined names that conflict with valid cell references."

"To correct this issue, underscores (_) have been added to the defined names that conflict with the cell references. Conflicting names in XLM macro code have not been changed, and must be corrected manually."

Any tips on fixing this? I'll try it in Open Office - but I'm not crossing my fingers if it's got advanced macros in it =\

(edit)
Actually, it looks like this just won't work on OS X at all. It doesn't support Visual Basic macros. I'll have to get another copy of Excel for windows and run it under VMWare Fusion I guess.

realmRanker - an Achievement ranking and tracking system http://www.realmranker.com