DPS Spreadsheet v3.0

October 15th, 2008

Hello all.  As some of you may know from reading the EJ post, I(Bakka of Kalecgos) have taken over the spreadsheet while Leulier has given the addiction we all know as WoW. :)   So without any further delay here’s version 3.0 of the spreadsheet.  There are still a number of issues which I plan on fixing between now and wrath.  So as to avoid any unnecessary posts, here’s what I’m aware doesn’t work/has changed.

  • Removed lag from calculations
  • The Next Stat(TNS) equations are out of whack.
  • Healing gear isn’t included in the items list.  Unfortunately I have no intention of adding healing gear to the list of items at this point.  You can add a custom gear and set the stats yourself if you’re using one.

Warlock DPS Spreadsheet v3.0.2a

So please feel free to comment here or in the EJ post with any problems or suggestions you have.

Thanks,

Bakka

8 Responses to “DPS Spreadsheet v3.0”

Yvgenie

October 15th, 2008 - 7:53 pm Reply to this comment

The dps values of the “Items” page are broken. They show several thousand dps difference.

Btw: It’s great that you continue the spreadsheet. Thanks! :)

Leulier

October 15th, 2008 - 8:27 pm Reply to this comment

Thanks for taking care of my baby :-p

Neil

October 16th, 2008 - 4:26 pm Reply to this comment

The DPS item value isn’t working because the next-stat equasions are out of wack as he said. I’ve started fixing my version before I looked here and saw it was a known issue.

So far I’ve fixed a problem with the nf procs. the equasions for both the main page and the tns pages had problems and didn’t agree.
On the assumption that having 2 nf + the glyph gives you 8% chance of a proc, I’m using:

=IF(AND(C32,OR(nf,glyph_corr),B32,OR(use_corr,filler=”Drain Life”)),1/(IF(use_corr,(nf*2+glyph_corr*4)/100,0)+IF(filler=”Drain Life”,(nf*2+glyph_corr*4)/100,0)),1)

for nf frequency

and for the tns pages the nf damage (cells c27) changed
VLOOKUP(A27,tns_fdmg,2),
to
VLOOKUP(”SB”,tns_fdmg,2),

The frequency of Dark Pact set to max is also different between the main and tns sheets. This changes the frequency of the filler spell, and leads to the other major difference I’ve seen.

I haven’t worked out the right formula to use yet for DP max

Hope this helps.

Maeolock

October 16th, 2008 - 5:08 pm Reply to this comment

I just want to say thank you for taking this over. This is the best tool for a Warlock out there trying to maximize their abilities.

Neil

October 16th, 2008 - 5:34 pm Reply to this comment

Making the above changes has gotten the spreadsheet next-point and item value working

I’ve set all of the TNS pages to use the same Max DarkPact frequency.

This is a small error, as things like int and spirit would change the pet’s mana recovery, which would change the rate of DP which would change the value of int/spirit, but only by a small amount.

I wouldn’t have bothered if I didn’t love this spreadsheet.

Neil

October 16th, 2008 - 6:10 pm Reply to this comment

The hit cap on the new spreadsheet is 17% instead of 16%.

Is this intentional? I hadn’t heard that the patch removed the 1% failure chance to hit with spells.

Neil

October 17th, 2008 - 8:43 pm Reply to this comment

The mana cost listed for Chaosbolt was negative if the character is hitcapped and has additional talents providing +hit. According to the spreadsheet I was getting 600 mana a sec for casting chaosbolt, instead of losing on average 26 mana

I’ve changed
(D35*(1-(base_miss-hit-cataclysm)))
to
(D35*(1-MIN(base_miss-hit-cataclysm,1)/100))
on my copy, which I think is more accurate.

I’m in the process of examining the other mps formula.

I also surrounded the equation in ‘Models’!B27 named max_dp_frequency with ‘MAX(0,’ and ‘)’ so that there wouldn’t be a negative frequency if my imp was firing firebolts while I was stealing it’s mana.

I hope this is helpful. Please ignore it if it isn’t

Bakka

October 18th, 2008 - 12:49 am Reply to this comment

Thanks for the comments. I found the errors in MPS calculations earlier today and they’ll be fixed in the next version. Also your calculation for CB is incorrect. You want MAX(0,base_miss-…etc) instead of the MIN function. The 1% resist chance was removed in the 3.0 patch though it’s not in the notes. So 17% is the new cap.

Leave a Reply