You would be incorrect. Someone can charge money for open source software if they wish. They just have to provide source code (and changes) - per whatever GL license they got the software under.

You could in fact, go and download OpenOffice right now, change some stuff, and try and sell it as BakkaOffice if you wanted to - but you'd have to make the source code fully available for anyone to download and compile, etc, etc.

Please don't speak of what you don't know.

Bakka, is there any way to separate the information for SB and Drain Soul? I'm trying to determine if I should use Nightfall procs sub 25%, and I would like to be able to compare the DPCT with that of Drain Soul only.

Well since we are going on about the compatability issues, I have a question as well. I have been using the sheet just fine at work. I didnt realize until today that I only have Excel 2003. I took the sheet home to continue to work with it last night and when I opened it, I got the #NAME, #MACRO, etc errors. I looked and saw I only had 2003 at home and assumed that was the issue. This morning when I checked my version at work and noticed it was also 2003, I opened the file and it was also screwed up. I find that I can take a freshly downloaded file, open it, import from Armory, manipulate whatever I want and it all works fine. When I save and close it, its screwed the next time I open it.

I use a few sheets for work with alot of macros and VB code built in, but these sheets were written over the last 10 years so they are based in older versions. Is my problem simply 2003 or is it caused by me using a work generated sheet and some settings in Excel get changed to hose it?

In other news, I downloaded the new version with the Melee info added in for the Felguard and I am pleased, thank you! I did have to manipulate it alot, but I was able to adjust things enough that I am fairly confident with the calculated DPS for the felguard. There are a few errors in the sheet I can list if you want, though I may not be able to recover the changes I made since the sheet is screwed again. One thing I noticed is that you have a flat 220 AP for BoM, but if the felguard is buffed with BoM he actually gets 687 AP (if improved BoM) and another major issue is the chance to miss. My understanding is that the pets recieve the hit rating from their master and that should more than eliminate any chance to miss. Melee hit rating is 32.79=1%, using the typical 14% hit that a warlock should have (367 rating) it should give the Felguard 11.2% hit which is more than the 8.6 needed. I found no easy way to adjust that with an equation referring to my gear so I simply changed the 8.6 to 0%. There are a few adjustments that could be made to the haste and AP equations as well, but those I need to copy from my sheet.

I am going to try to download that open office from Novell and see if it works better, let me know if I am chasing my tail and there is a better solution.

Try again, Marthisdil: "of or relating to or being computer software for which the source code is freely available" this is from
wordnet.princeton.edu/perl/webwn

"Open Source is a general term describing several parts of the Free Software Licence movement."
kanarenmarkt.com/portal/help/mambo.glossary.html

Be nice or don't post. Constructive criticism is helpful. Yours isn't.

I've been looking into the spreadsheet quite a bit recently and came across a couple things that could help make it a bit more accurate. Here's what I've found:

Partial Resists
I have not came across anything in the spreadsheet that calculates in DPS loss due to partial resists. I'm not aware of any extensive testing that has been done on this since WotLK, but initially it looks to still be around 6% for raid bosses (2% for each level the target is above the caster). In any case we know the DPS loss due to partial resists is not 0% and it would be nice to have it modeled in the spreadsheet as a configurable percentage. I recognize that this does not change the relative weight of any of the TNS calculations, but it does make the model more accurate.

I changed my copy of the spreadsheet to take partial resists into account by doing the following:

1. Add a cell named "partial_resist_pct" and default it to 6%
2. Make all sheets visible by running the "Toggle_Sheets" macro.
3. Add a "*(1-partial_resist_pct)" to the end of each spells damage calculation on the DPS sheet as well as all the TNS sheets.
   • Note: For immolate make sure that the partial resist is applied to both the direct damage and dot damage calculations.
4. Hide the sheets by running the "Toggle_Sheets" macro again.

Deaths Embrace
It looks like Deaths Embrace is modeled as a 12% increase in damage for 35% of the fight. In reality the boss tends to die quicker when under 35% health as other classes Execute type abilities and talents kick in. It would be nice to be able to make the percentage of time that the target is under 35% health configurable. Setting the configurable value's default to around 30% seems like a reasonable default, but other class discussions may have calculated a more appropriate value for this.

I was able to change this in the spreadsheet by doing the following:

1. Add a cell named "de_pct" and default it to 30%
2. Make all sheets visible by running the "Toggle_Sheets" macro.
3. Do a find and replace (seems to have caught everything that needed changed):
   • Find Value: deaths_embrace*0.04*0.35
   • Replace Value: deaths_embrace*0.04*de_pct
4. Hide the sheets by running the "Toggle_Sheets" macro again.

Dot Gap
Instead of modeling time between dot casts as a dot gap I've been playing around with modeling it as a Dot Uptime Percentage.

I have been using to following formula to convert a dot_gap as used by the spreadsheet to a DoT Uptime Percent:

dot_uptime = dot_duration/(dot_duration + dot_gap)

For Immolate we get:

dot_duration = 15 seconds
dot_gap = 1 (default in the spreadsheet)

.9375 (or 93.75%) = 15 / (15 + 1)

Continuing this for other dots we get the following uptimes
Dot Gap of 1:

Corruption 94.74%
UA 93.75%
CoA 96.00%
SL 96.77%
Immolate 93.75%

DoT Gap of 2:

Corruption 90.00%
UA 88.24%
CoA 92.31%
SL 93.75%
Immolate 88.24%

After playing around with different dot gap values, I didn't come across one that would really work well in modeling something close to reality (~97% uptime for Corruption, and ~90% uptime for all other dots), so I changed the model to use a Percent Uptime which was configurable for each dot.

To go from a DoT Percent Uptime to a Dot Gap the above formula can be adjusted to solve for dot_gap. This gives us:

dot_gap = (dot_duration/dot_uptime) - dot_duration

For immolate we get:

dot_duration = 15
dot_uptime = .90

1.66 seconds = (15/.90) - 15

So a dot_gap of 1.66 seconds would represent a 90% dot uptime for Immolate.

To incorporate this into the spreadsheet I did the following:

1. Add a Dot Uptime Percent column to the end of the Spell table in the DPS sheet.
2. Label each of the cells with "<SpellName>_uptime" as this uptime will need to be used on the TNS sheets as well
3. Set default values of Corruption = 97%, and 90% for everything else.
   • Note: I did not change Haunt as it should be up 100% and that is what is currently modeled by the spreadsheet.
4. Update the Duration/Frequency column for each DoT to use the uptime instead of dot_gap
   • Immolate: Replace "dot_gap" with "((15/immolate_uptime)-15)"
   • Alternatively the calculation can be simplified, but the above change is sufficient to use the uptime. To simplify the
     calculation the "15+" in the current formula can be removed and "dot_gap" replaced with "(15/immolate_uptime)".
5. Make similar updates for CoA, Corruption, Siphon Life, and Unstable Affliction on the DPS and TNS sheets.

As always, many thanks to Bakka and others who are working to make the spreadsheet as accurate as possible.

I just respecced from afflic to Fel+Ember, and I noticed that FG DPS in XLS is now even more different from reality than before: it shows only 471 DPS , while my first 25man post-patch raid showed 1200ish DPS on felguard on Grand Widow with lag (so I expect even more on Patch without lag).

Main problem seems to be missing melee buffs and some kind of approximation on damage formula.

After playing a bit with pet_dps tab, I managed to make it fairly close to what I could see on my last raid. Since I had only one post-patch 25man raid, and since main problem with full buffs can be only tested on 25man raids , this is not 100% checked, but result in much closer than before.

Corrections that I made:
1) added C8 = pet_raid_buffs , this cell (values 0 or 1) enables me to switch all raid buffs on or off

2) added ten (10) melee or caster/melee buffs that were missing, descriptions are A52-61, values are from H52 to H61:
2b) set Bloodlust value at H59= 30*40/oom_time

3) changed armor coefficient to correct: E3 =1-1/(1+15232/(13083-pet_raid_buffs*H54)) // 13083 = Naxx boss Armor

3b) changed miss rate value to include your hit at E6= melee_miss = MAX(0; 8.6%-(Gear_Buffs!J4/32.79/100) )

4) added another melee stat at G7 = pet_melee_perc_inc =1+pet_raid_buffs*(H52+H60)/100

5) added another melee stat at E7 = pet_melee_haste = 1+pet_raid_buffs*(H53+H58+H59)/100

6) changed AP bonus stat E4 = other_ap =pet_raid_buffs*(C13+H56+C12*0.02*314*2) //314=pet STR, kings influence AP now

7) changed melee crit E5 = other_crit =pet_raid_buffs*(H55+H61+C12*0.02*90/18)/100

8) changed FG AP at B34 =(1+pet_raid_buffs*H57/100)*(608+pet_ap+other_ap)*(1+B33*(0.05+demo_brut*0.01))*(1+0.1*glyph_felguard)

9) changed FG Auto-attack damage at E31 =(412.5+fg_ap/7)*1.05*(1-melee_miss+fg_melee_crit-(1-glancing_red)*glanc_perc-target_dodge)*armor*(1+0.04*unholy_po)*(1+md*0.01)*pet_melee_perc_inc* IF(demonic_empathy;1+demonic_empathy*0.01*Models!B33;1)

10) changed FG Cleave damage at E32 ==(412.5+fg_ap/7+124)*1.05*(1-melee_miss+fg_melee_crit-target_dodge)*armor*(1+0.04*unholy_po)*(1+md*0.01)*pet_melee_perc_inc* IF(demonic_empathy;1+demonic_empathy*0.01*Models!B33;1)

11) changed FG Auto-attack frequency at F31 =2/pet_melee_haste*(1-IF(demonic_empowerment;15/60;0)*0.2)

12) set FG Cleave frequency at F32 = 6

13) set old BoM value to 0, B13=0

14) changed Pet AP Bonus from player, B2= pet_ap =Gear_Buffs!G4*0.57

15) changed Glancing reduction value at G4=glancing_red = 85% (value from multiple WWS parses)

After those changes (if I didnt forget some changed cell), result should reflect better theoretical melee damage. Main change were:
(3) using real armor based damage reduction for "armor" coefficient
(9,10) real tooltip based damages , (597+fg_ap/7) instead of (206+fg_ap/7)
(2) introducing *lot* of melee buffs and changing how they influence AP, dmg, haste...

All that resulted in 1176 DPS for my spec/gear on FG, which is much closer to observed 1200 DPS.

I think that I didn't use any value/coefficient that is not somehow backed up with damage theory, which means less "tweaking" will be needed when compared to real values. I posted changes in this way (instead of just posting changed XLS) in hope that people will check above formulas, and that whoever is maintaining DPS XLS will find it easier to change in his XLS if needed. Again, it is possible that I missed something in these numbers, but so far result looks much closer to reality. Also, same changes could be made for Succubus and Felhunter melee parts i guess - but I didn't check/change those.

Edit:
-fixed back Cleave frequency to 6, due to presumed CD of 6sec which would nullify any haste.
-changed miss rate to include player hit, from post #216
-added Demonic_emphaty multiplier to swing and cleave damages(E31,E32), using already existing (at least in 303k version) pet uptime field.
-changed Pet AP bonus from player so +dmg buffs affect it: B2=pet_ap= (Gear_Buffs!G4-Gear_Buffs!G89)*0.57
-changed Bloodlust effect depending on duration of fight, H59= 30*40/oom_time
-changed base pet damage to (412.5+fg_ap/7)*1.05, which should be same for all melee pets with only coeficiant changed (1.05 for succ also, 0.80 for FH, 0.86 for VW)

Since sometimes its easier to see in XLS what those changes mean, you can find example of XLS with those (and Meta) changes at:

warlock_dps_demo.xls

Just curious if it would be possible to add in melee raid buffs? 5% crit from warriors/feral druids, Windfury, Strength of Earth totem ect. I believe this would boost dps up a bit for Demo warlocks (and to a lesser extent the other warlock specs). Also for the Meta/Ruin spec, is Leulier applying the Master Demonologist buff to the Felguard?

I just cringe a bit seeing Leulier list Felguard as being worth 579dps for me when I'm in a raid setting. I know he's pushing 1-1.5k now.

*Edit* Pretty much exactly what Nenad posted heh.

I've been fiddling around with the spreadsheet and no where can I find the math for the 4pT7 bonus. Am I just blind? Can someone please point me to this so I can continue my fiddling

Chaosbolt base damage is not changed for 3.0.8

There is a bug in some tns lists for backdraft damage calculation - "Models!$B$14" should be replaced to "B57" in c32 cells

Yes - although I listed buff effects, not buff names. So to make it easier to check, here are buff names also:

All buffs in same line (same effect) do NOT stack, and they produce effect shown to right. For buffs that last limited period of time (like Bloodlust) approximation was calculated for 4min fight.

chaos bolt should be changed from 1175 average damage to 1621.5 rounded however you wish.

One thing I saw from Nenad's post was that he is adding 688 AP for blessing of might. 220 AP is already included in the calculations from the current tables, this is referring to an older version of BoM. I simply edited the existing table from 220 to 688. However it is handled is fine, so long as the 220 AP is removed.

Also dont forget about what I posted earlier. Hit rating is applicable to all now and since or pets get our Hit rating handed down to them, you can take the raw hit rating number (not including talents or Misery) and divide by 32.79 to get the Hit % equivalent that the pet is receiving from our gear. Subtract that number from 8.6% and normalize any negative results to 0% and you will have removed the "Melee miss rate" error also.

@TogTog... I was also curious about the 4pT7, if I swap 2 items that would otherwise be very near the same DPS, one being a T7 and one not, the effect of 4pT7 is completely ignored. As it is now, I have 4pT7, but I also have Heigan's robes and I choose to run them and ignore the 4p bonus. I dont really know if this is right or not, wish the spreadsheet had a calc for it. If you look in the "advanced tab" it also shows no calculations.

Sheet is really coming along nicely, thanks alot.

:EDIT: Does imp's firebolt cast get any effect from raid haste buffs such as wrath of air and improved moonkin? Because from what I see, the imp's firebolt cast is only effected by dem_pow

:EDIT2: Cell D26 on the DPS tab is the calculation for Immolate's dot duration. Is this calculation is still assuming Conflag consumes the Immolate? I might be reading it wrong, I am starting to get better at writing these calculations (I need them for work now also) but I'm still pretty new.

I'm actually trying to test the DPS difference between my Heroes robes and the Robes of Mutation and couldn't find that 4pT7 anywhere. The robes come out at about 6DPS better, but if its not modelling the Heroes robes then I have a sneaking suspicion that I might be worse off now :/

2 things to note here. If you are trying to add these changes into the sheet, Nenad has ; where there should be , as such:

F31 =2/pet_melee_haste*(1-IF(demonic_empowerment,15/60,0)*0.2)

F32 = 6/pet_melee_haste*(1-IF(demonic_empowerment,15/60,0)*0.2)

And the other concern I have is unless I am mistaken, Cleave is a "spell" with a 6 sec CD and therefore should not be modified by any haste effect. I think you want to leave Cell F32 alone as "6". I could be wrong here though, but I cant find any reason why it would ever happen more often than once per 6 sec.

Also I am still curious as to what the "220" is for Blessing of might. Nenad's new equations still use that value in them in addition to adding 688 from the newly entered Cell H56. I believe this is giving the Felguard 220 (plus modifiers) too much AP. It lowered my Felguard's DPS by ~52.

I also changed E6 =MIN(0,(8.6%-((Gear_Buffs!J4/32.79)/100))) which effectively adjusts his miss rate to compensate for your hit rating buffing him. Assuming you have atleast 11% spell hit, he should never miss. This increased my Felguard's DPS by 81.

Next thing someone needs to tackle for this sheet is Metamorphosis' effect on damage output. This is of course assuming that the latest posts are correct that Meta has in some way gotten a huge buff and it isnt simply some errant bug from this last (terribly buggy) patch. I dont even know where to begin on this one.

I don't see an option to include imp faerie fire so the sheet overvalues hit for me currently. Would be nice to put it in there.

I'm new to your spreadsheet but it seems to think that embrace of the spider is up all the time, saying my incinerate's effective cast time is 1.66 seconds?

Strange, it is actually ";" for me, not "," - I guess that depends on some Excel settings.

I considered this, but after checking my WWS logs I think that on some fights frequency of Cleave was better than every 6sec. I was not sure on this one, and maybe it was spell haste that influenced it, or cleave on multiple mobs was counted, or just wrong log.

If haste really do not effect it, then it should be left at F32=6 ... but I'll try and check again on that one.

You are correct, in order not to count Blessing of Might twice for FG, you should set B13 = 0, ie exclude old BoM.

Nice - I was not sure if our hit is reflected to pet hit, but if that is the case, it looks good ;p
But when I put that in my XLS (and i have 299 +hit), i got negative value, so it should be:
F6=MAX(0; 8.6%-(Gear_Buffs!J4/32.79/100) )
Note that again my XLS ask me to use ";" instead of ","

I didnt have Meta (since Fel-Ember), and I was not sure if Meta also has effect on pet,but if it does then we should add to end of E31 and E32:
E31= (597+fg_ap/7).... *(1+IF(metamorph;0.2*30/180;0))
E32= (597+fg_ap/7+124) .... *(1+IF(metamorph;0.2*30/180;0))

Im sorry, I think I wasnt clear. I didnt think that Meta effected pets, if it does GREAT! but I dont think it does. I was just referring to the sheet itself modelling a way of using meta, as you said, during Bloodlusts and reusing it on cooldown. Another thing that would need to be modelled is Immolation Aura, Cleave, etc. Is it worth it to pop Meta, charge, Immolation aura and then go back to the regular casting sequence while the aura ticks away. As far as I know, the sheet doesnt even add a percentage of your own damage increase if you talent the Meta.

On the excel issues, I am using an old version (2003 I think it is) and that may be the difference between the ; , It could also be the difference as to why it doesnt work right on excel's older than 2007. As it is now, every time I want to try something new on the spread sheet, I start from scratch on a fresh copy of the file, reinput all of my info, buffs, talents, gear, etc. AND reinput all the equations Nenad added, and then I can try my new idea. Once I am finished, I just exist out and all is lost. If at any point I save the file, close it and reopen it, I get all the #NAME and #MACRO errors and all my numbers are screwed up.

I use Sun's OpenOffice, and every time I try to open the spreadsheet it just closes down while loading it up. Has anyone with this program been successful in opening it? If not, is there any plan to make the spreadsheet work with Sun's OpenOffice? I depend on this spreadsheet for my min/max mentality, and would appreciate any help.

Well, one part of Meta effect is increased multiplier that I posted above (which should not influence pet dps then)

Second part of Meta effect is Immolation Aura. In order to add that to result, I did following:
1) Insert new row 41 at DPS sheet , under "Felguard" (copy row 40 into it), and name it "immolation Aura" - that will move down other rows

2) set B84 = meta_count = =IF(metamorph>0;TRUNC(oom_time/180)+IF(oom_time-TRUNC(oom_time/180)*180>30;1;(oom_time-TRUNC(oom_time/180)*180)/30);0)

3) set meta_mult (this is same meta_mult as before, only now it use meta_count) at B85 = meta_mult =IF(metamorph>0;1+(meta_count*0.2+0.043)*30/oom_time;1)

4) set Immolation Aura data in row 86. Damage in B86:

B86= (451*15+2.43*add_f)*(1+ember*0.03)
*IF(dem_sac;IF(pet="Imp";1.1;IF(pet="Felguard";1.07;1));(1+md*IF(pet="Imp";0.01;IF(pe t="Felguard";0.01;0))))
*coe
*IF(metamorph>0;1.2;1)
*(1+0.1*mc_uptime)
*(1+IF(Gear_Buffs!$D$91="Spellstone";0.01;0))
*(1+0.01*malediction)
*IF(demonic_empathy;(1+demonic_empathy*0.01*Models!B38);1)


5) set Immolation Aura cast time. This also include miss chance. I presumed afflic or destro talents do not work with it.
C86=MAX(gcd;1.5/(1+haste/100)/(1-MAX(0;base_miss-hit)/100))

6) Set Immolation Aura mana cost in D86. I could not test what "64% of base mana" means, but since "base_mana" cell already exist in XLS, i used:
D86= 0.64* base_mana

-- now set values for added "Immolation Aura" row at 41:
7) set Damage at C41=B41*metamorph*B86
8) set Frequency at D41=IF(meta_count>0;oom_time/meta_count;oom_time)
9) set Cast time at E41=C86
11) set CastRatio at F41=IF(C41;E41/D41;0)
12) set DPS at G41=C41/D41
13) set DPS% at I41=IF(dps; G41/dps; 0)
14) set MPS at J41=-B41*meta_count*D86/oom_time
15) set TPS at L41=G41*(1-IF(metagem="BracED";0.02;0))

16) change filler CastRatio at F34=IF(use_filler;1-SUM(F26:F33;F35:F39;F41);0)

17) change needed LifeTaps at D39. I changed only part for "oom_time", so:
D39 =
.... old stuff....
IF(lt_mod="oom_time";MAX(-lt_mana/(mana/oom_time+SUM(J26:J38;J41)+mp5/5+J40);0);0))))
.... old stuff


This will result (for fully buffed Meta spec with 5500ish DPS) in ImmoAura with some 180 DPS, but only about 120 real DPS increase when its turned on with B41=1, due to LifeTaps needed to fill lost mana and due to used GCDs on casts - which was expected, and 120 DPS is still very good. Overall DPS increase with Meta is about 430 DPS, meaning that majority is still coming from (modified) 20% increase to other spells.

Above example numbers are for fight of duration (oom_time)= 220sec (usual Patch Fight). For fights of different lengths, numbers are different. For example, for 360sec Meta gives 260 DPS, and Immo Aura gives 80 DPS of those.

Edit: I changed Damage formula for ImmoAura (B86) to better reflect Meta effect, and used 2.43 spell coeficient from wiki - this match fairly well some posted data on aura damage

Will you be supporting BS sockets, and is there any way I can compare the actual DPCT of DS with that of SB?

Not sure if this is a problem with anyone else, but about 70% of the macros in the spreadsheet are not working. I updated to OpenOffice 3.0 and am at least able to open the spreadsheet. If I set certain values to 0, then the macros work. If I change them they macros don't work.

Earlier in this thread people asked the same questions. Links to the two solutions:
Download a different OO version: http://elitistjerks.com/1060628-post189.html
Add your own macros: http://elitistjerks.com/1060616-post188.html