Jump to content


Photo

Warlock Spreadsheet (4.0.3a)


  • Please log in to reply
16 replies to this topic

#1 Mupki

Mupki

    Glass Joe

  • Members
  • 15 posts

Posted 16 October 2010 - 06: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.

Posted Image

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

#2 Dudeshesdead

Dudeshesdead

    Glass Joe

  • Members
  • 1 posts

Posted 16 October 2010 - 12:26 PM

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

#3 Grenchlok

Grenchlok

    Glass Joe

  • Members
  • 1 posts

Posted 17 October 2010 - 06:37 AM

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

#4 Colraw80

Colraw80

    Glass Joe

  • Members
  • 2 posts

Posted 21 October 2010 - 09: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.

#5 inktomi

inktomi

    Von Kaiser

  • Members
  • 25 posts

Posted 27 October 2010 - 12:15 AM

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).
<irL> - looking for members today! Inktomi#1227

#6 Unknowndiv

Unknowndiv

    Von Kaiser

  • Members
  • 39 posts

Posted 27 October 2010 - 01:26 PM

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?

#7 Mupki

Mupki

    Glass Joe

  • Members
  • 15 posts

Posted 01 November 2010 - 07:37 AM

New build released, just a few changes.

#8 Unknowndiv

Unknowndiv

    Von Kaiser

  • Members
  • 39 posts

Posted 07 November 2010 - 12:09 PM

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

#9 Mupki

Mupki

    Glass Joe

  • Members
  • 15 posts

Posted 07 November 2010 - 06: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 :(

#10 Mupki

Mupki

    Glass Joe

  • Members
  • 15 posts

Posted 22 November 2010 - 08:39 AM

New update is here!

I added in level 85 content.

#11 jondeplume

jondeplume

    Glass Joe

  • Members
  • 1 posts

Posted 30 November 2010 - 08: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

#12 Mupki

Mupki

    Glass Joe

  • Members
  • 15 posts

Posted 01 December 2010 - 09:48 AM

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

#13 zeros

zeros

    Glass Joe

  • Members
  • 1 posts

Posted 05 December 2010 - 02:37 PM

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...

#14 Modibybob

Modibybob

    Glass Joe

  • Members
  • 2 posts

Posted 27 December 2010 - 08:30 PM

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

#15 Solaros

Solaros

    Glass Joe

  • Members
  • 1 posts

Posted 26 January 2011 - 03:12 AM

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

[TABLE]Health 108106 108106
Mana 83027 83027
Armor 7387 7387
Stamina 5013 5013
Intellect 3920 3920
Spirit 181 181
Spellpower 1954 1954[/TABLE]

[TABLE]Rating Percentages
Hit 1746 17.04
Crit 434 18.16
Haste 1296 10.12
Mastery 993 13.54[/TABLE]


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:

[TABLE]+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[/TABLE]

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.

#16 Poupette

Poupette

    Glass Joe

  • Members
  • 12 posts

Posted 27 January 2011 - 05:09 PM

I think you just forget to click on the "Calculate" button on the spreadsheet after add your own values

#17 Skellingtoon

Skellingtoon

    Glass Joe

  • Members
  • 9 posts

Posted 25 February 2011 - 10:35 PM

Can you add Burning Shadowspirit Diamond to the calculation?




0 user(s) are reading this topic

0 members, 0 guests, 0 anonymous users