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.
Microsoft Excel 2007
There is a basic description on the Intro sheet that tells you how to use it.
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
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
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.
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?
Last edited by Unknowndiv : 10/27/10 at 9:32 AM.
Reason: Add metagem
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
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
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.
Error in cell F16: The formula in this cell refers to cells that are currently empty
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
Error in cells listing "Damage Per Cast": The formula in this cell refers to cells that are currently empty
Error in many cells such as cell B123: The formula in this cell differs from the formulas in this area of the spreadsheet
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">
<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>
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...