Warlock Spreadsheet (4.0.3a)

Mupki · 10/16/10, 2:27 AM

Here is the remodeled spreadsheet I've been working on with Cerula in my spare time. If you guys would please test out your characters to make sure everything seems as accurate as possible in regards to rotations and calculations, and posting glaring disparities would be beneficial.

There are a few things I would like to add, but I am not sure the best way to model them to give useful results. Such as Bloodlust and other haste effects, would it be better to just average it's benefit out during the whole duration of a fight, or be able to toggle it on or off to see the differences.

I'll try to release updates as often as I can, especially as they change our class mechanics more.

Anyways, I'll let you guys mess around with it as you want, but be warned some sheets in this have no function yet.

Requirements:
Microsoft Excel 2007

How To:
There is a basic description on the Intro sheet that tells you how to use it.

Known Bugs
We need feedback on any bugs / errors that appear.
We need feedback on the numbers shown to you
We need feedback on some of the formulas used

Changelog:
11/30/2010 - Build 005

Added new races
Fixed a few formulas

11/21/2010 - Build 004

Updated to work at level 85

10/31/2010 - Build 003

Few fixes

10/16/2010 - Build 002

Fixed the Imp's casting speed and some Doomguard changes
Removed connections that did nothing

10/15/2010 - Build 001

Overhaul for Cataclysm and patch 4.0.1 - Initial release

Donate:
You can donate here to support the future of this spreadsheet (updates, additions) as well as the hard work we have put into making this spreadsheet possible.

Download Via:
Dropbox - Hosted out of my DropBox public folder.

Dudeshesdead · 10/16/10, 8:26 AM

Doesn't seem to be working, excel crashes everytime I try to open it.

Grenchlok · 10/17/10, 2:37 AM

Can you implement Alliance Races please? Thank you so much for revamping this!

Colraw80 · 10/21/10, 5:50 PM

Under rotation, if you remove Shadow Bolt and only leave Incinerate and Soul Fire checked (using Incinerate for filler on Demo spec) the DPS jumps by 6k, since it is take Soul Fire as your filler.

inktomi · 10/26/10, 8:15 PM

Excel also seems to hang and crash when I try opening this. I'm using Excel 2011 for mac - which does support VBScripting (so it should all work).

Unknowndiv · 10/27/10, 9:26 AM

Change link at coefficients Improved SoulFire formula Rotation!C31 (Liftap) to Rotation!C30(Soulfire >80%) and add a note for unbuffed intellect "Character page shows buffed int".
Also Focus magic formula change from 3 to =IF(C78; 3; 0)
--------
Almost forgot: Critical strike chance calculates as critical strike rating plus 21 rating from chaotic gem. Maybe I don't understand something?

Mupki · 11/01/10, 3:37 AM

New build released, just a few changes.

Unknowndiv · 11/07/10, 7:09 AM

I'm trying to understand incenirate damage formula at rotation page.
"=IF(C21; IF(A21="Incinerate (Molten Core)"; Damage!$Q$162*coeffs_moltencore_dmg; IF(C23; 0; IF(C11; Damage!$Q$162; Damage!$N$162/coeffs_firebrimstone_dmg)));0)" C23 is Shadowbolt as a filler spell only? What if I use it only to refresh 5% crit debuff. And C11 is "Nuke" string

I think there must be C9 - Immolate.
Add: Shadowbolt damage formula is odd. "=ЕСЛИ(C23; ЕСЛИ(C20; 0; Damage!$D$150);0)" C20 is Fel Flame! Assuming another -2 rows, C18 is Drain Life. This is formula for Affliction DL vs. SB fillers?
Add: I'm going to add "bugs" in realtime

Soul Fire ratio formula seems odd. Example: If I choose only Incenirate spell, Incenirate ratio is 100%. Then I choose SF and Inc ratio is still 100%, SF ratio is 0%. Example #2: If I choose only SF spell, SF ration is 100%. Then I choose Inc and SF ratio is still 100%, Inc ratio is 0%.
Add: Incenirate's ratio below zero

Turned off every haste buff, set haste rating 0. Using spells BoD, Immo, Corr, Inc, Bacdraft and Inc's ratio is below 0. There is something wrong with ratio formula

Mupki · 11/07/10, 1:23 PM

You can't have two fillers active at the same time, unless one is an execute range filler like Soul Fire for Demonology. You can only choose to cast one or the other.

For the Incinerate ratio "bug" you were mentioning, if you are Destruction you will only have time to cast Backdraft Incinerates depending on how you set up the rest of your rotation. Without enough haste rating, you simply won't have time to cast Incinerate fillers before Conflagrate is up again (depending on glyphs as well).

Thanks for the other fixes, when I add in new spells to the rotation, it messes with the pointers in my formulas

Mupki · 11/22/10, 3:39 AM

New update is here!

I added in level 85 content.

jondeplume · 11/30/10, 3:09 AM

I am not sure how large you user pool is for Office 2011 (Mac), but it appears there are errors preventing proper use of your excellent spreadsheet. Previous versions of Office for Mac did not support macros. I will list the errors that the Excel Error Checker is presenting me. I assume these do not apply to other users, but if they can help you in any way I am happy to be of service. Thank you again for all the work you have selflessly provided to the community. I apologize if this is a waste of your time and not worth pursuing. I am using Microsoft Excel for Mac 2011, Version 14.0.1.

Sheet 2:
Error in cell F16: The formula in this cell refers to cells that are currently empty

Sheet 3:
Error in cell K38, J38: The formula in this cell refers to cells that are currently empty
Error in cell H19, H21, K22: The formula in this cell differs from the formulas in this area of the spreadsheet

Sheet 4:
Error in cells listing "Damage Per Cast": The formula in this cell refers to cells that are currently empty

Sheet 5:
Error in many cells such as cell B123: The formula in this cell differs from the formulas in this area of the spreadsheet

Mupki · 12/01/10, 4:48 AM

Released a new version.
Please report any issues you have and what you would like to see implemented.

zeros · 12/05/10, 9:37 AM

Excel 2010 is saying this file is corrupt and needs to be repaired

  <?xml version="1.0" encoding="UTF-8" standalone="yes" ?> 
- <recoveryLog xmlns="http://schemas.openxmlformats.org/spreadsheetml/2006/main">
  <logFileName>error022440_01.xml</logFileName> 
  <summary>Errors were detected in file 'C:\Users\zeros\Downloads\cata_warlock_dps_4.0.1_build_005.xlsm'</summary> 
- <removedParts summary="Following is a list of removed parts:">
  <removedPart>Removed Part: /xl/vbaProject.bin part. (Visual Basic for Applications (VBA))</removedPart> 
  </removedParts>
  </recoveryLog>

I ran my office installer and added Visual Basic for Applications and now it does not give me this error
You may want to add this to your list of requirements. It needs more then just excel...

Modibybob · 12/27/10, 3:30 PM

I am getting the above error as well with the VB editor...hopefully it's not a 64-bit OS error.

Solaros · 01/25/11, 10:12 PM

I'm trying to learn how to use the spreadsheet. I have the following entered for my stats:

Health 108106 108106

Mana 83027 83027

Armor 7387 7387

Stamina 5013 5013

Intellect 3920 3920

Spirit 181 181

Spellpower 1954 1954

Rating Percentages

Crit 434 18.16

Haste 1296 10.12

Mastery 993 13.54

I kept the buffed / unbuffed the same since I'm just trying to get a general feel for the stat weights / ratios.

This is what I see as the output after I set up the rotation:

+10 Intellect 6,629.4 0.00 per Intellect

+10 Spell Power 6,629.4 0.00 per Spell Power

+10 Hit 6,629.4 0.00 per Hit

+10 Haste 6,632.1 0.27 per Haste

+10 Crit 6,632.4 0.30 per Crit

+10 Mastery 6,631.8 0.24 per Mastery

But I'm not really sure what that means... It seems to say that an increase in 10 mastery is 2.4 dps and that an increase in 10 spellpower is 0 ... How should I be reading this.

Thanks.