• Dochas

We normally pop heroism in caster group in Phase 2 Illidan about 70% into the first elemental. When frost I was saving elemental/trinkets etc for this time untill I noticed that my elemental went OOM in 20 seconds and then ran up to melee range of the flame and died.

Totems and trinkets = good but heroism doesn't seem to be very effective for elementals.

 

Zipher

Thats weird behavior. I didn't think the elemental had a melee attack. Mine just stands still when it runs OOM. It definitely needs to get a larger percentage of the mages intellect though since it runs OOM without bloodlust even if you don't have a shadow priest.

 

frosty

I'm wondering, if your new version includes the haste changes already, that go live tomorrow?

I also noticed some weird bugs: First of all i had a huge increase in my base spell dmg at one point after switching talents and gear back and forth a bit (value as shown in 'calculation' F47), and the new base spelldmg was just unrealistically high. I also noticed weird values for my gear-based hitrating - it's simply too high compared to my live stat (which is 166 compared to 201 in your sheet). There might be a bug with the 4-set T6 bonus, b/c each time i unequip the 4th T6 item, i lose a chunk of the hit rating ... could it be, that you add some hitrating when applying the 4*T6 bonus?

 

Rouncer

no shadowpriest? when I was frost I never had my elemental run OOM when bloodlusted due to VT mana return.

 

◊ Vontre

That is what is happening, some of the old set bonus code is adding a bunch of hit for T6.

I included the updated haste changes.

Edit: Just uploaded a hotfix.

www.magegraf.com

Raiding is full of challenge. Sometimes there is fire. You have to not be in the fire.

"We agree with Communism." - Greg Street 2009

 

◊ Vontre

Dochas, a shadow priest usually covers my water elementals mana issues, even when lusted.

www.magegraf.com

Raiding is full of challenge. Sometimes there is fire. You have to not be in the fire.

"We agree with Communism." - Greg Street 2009

 

• Dochas

My fault for not thinking about other fights. We run 1 SP for Illidan (well for everything now that our other SP wowquit). Normally the SP is with 3 mages and a elem shammy but for Illidan hes with a healer group.

Guess I wasn't paying enough attention to the few other fights I did as frost with bloodlusted elemental when I did have a SP.

 

Thermomenes

Hi Vontre,

I sent you a private message about this before i checked this thread. I am posting here after I remembered the thread. I am using your mage spreadsheet and noticed there are several dps totals for the same spell school and build. Which one is the true max theoretical dps for that build while casting in a 5 min fight?

1) Spells DPS TIME TOTAL
Fireball: 1930 6:30 578,976 max

2) Fire Frost Arcane
Build Comparison: 1,971 1,796 1,783 DPS

OR

3) Under "cycle builder" tab
DPS: 1884.433587
Time: 6:44
Total Damage: 565,330

Also, why is the build comparison dps different than the spells dps? As I was reading through this thread I read somewhere that cycle builder took into account mana consumption too. I'll venture a guess to my own question and assume the mana consumption part of the cycle builder brings the dps down.

 

Roywyn

Hm, Vontre? Which version of the spreadsheet is the lastest one?

The one I get when downloading is 2.7.1 from august 27th, with the "35 spell hit 3/5 T6" set bonus and other oddities :o

I know you're not working on it anymore, but I'd like to know which one the most up to date sheet is.

Edit:
Thanks, Ashtongue. I fail at clicking files that I downloaded ... *headdesk*

 

• frmorrison

Using Vontre's sig the version that I get is 2.7.2.1 modified on 25 September.

 

ReignConfused

Has he released an updated version? Or could anyone direct me to a viable way to remove the co-efficient to compare everything pre 2.3 and post 2.3?

 

frosty

In order to remove the dmg-coefficients go to sheet 'Calculations' into field G47 (for fireball) and H47 (frostbolt).

The formula in G47 will look like:

[top](F47+G86+G91+G94+G88+G101+F$9+WENN('Main Sheet'!$B$47

"yes";'Game Stats'!$E$36;0))*(('Game Stats'!$B$78+Talents!$B67*0,03)*(1-Talents!$B58*0,02))

Now just remove the last part which is '*(1-Talents!$B58*0,02)'

Do the same in H47 (where it's actually '*(1-Talents!$B47*0,02)').

That should do the trick.

 

Roywyn

As frosty said, you have to modify the entries in the sheet 'Calculations' in the way he descibed it.

G47, H47 for the gear in your current gear and spec.
X47, Y47 for the gear with your spec, and the changed gear stats (grey box in the 'Main Sheet').
G247, H247, G447, H447, G647, H647 to change it for the calculation with the calculations with a fire, frost and arcane spec.

 

Sorbe

With items on the current spreadsheet...

[1] The socket combo boxes dont work on the "Talon of the Tempest" dagger
[2] The "Fang of the Leviathan" sword still has old data listed in the latest spreadsheet. (Full refresh time?)
[3] The "Wrath of Cenarius" ring is missing entirely.
[4] The "Elixir of Draenic Wisdom" is missing (often paired with Adept's Elixir).

I'm sure there are other issues -- just found those from digging around.

 

Rayga

JoW on Arcane Missiles is incorrect as well. It's currently modeled to proc it only once.

Spellfire bonus is not in the spot on the gear it used to be in the newest version. I'm not sure if it was removed or if it was just moved.

 

Cardynal

Just wanted to see if people were getting similar results.

With the best possible gear tailored for each spec...I get the following theory dps

Arcane Am spam - 1852 dps
This is assuming spamming 10 AM's and getting 1 CC.

Fire 6xFireball 1xScorch - 1857 dps

Frost Frostbolt spam as full frost- 1589 dps
Water elemental is 240dps...so it can burst to 1829dps. In a 5 minute fight...you can
summon your water elemental 3 times...which would average out
to 1697dps.

Frostbolt spam as 40/0/21 with another frost mage doing winter's chill - 1683dps

 

◊ Vontre

There's my mana calculations... I'll have a fix in the next version along with the 2.3 changes.

www.magegraf.com

Raiding is full of challenge. Sometimes there is fire. You have to not be in the fire.

"We agree with Communism." - Greg Street 2009

 

aznxk3vi17

Is there any way I can do this through a 3rd party, possibly? I don't have Office installed on any computers here (I forgot to uh... buy it). I'm currently confused as to what my current optimal spec is, as I was trying out many different rotations last night, but none were very satisfying.

 

Aldric

OpenOffice.org: Home

Once you get your install done Calc is the program you're looking for. The only thing that probably won't work is the Armory importer, although it might, I've never tried.

 

Rayga

Yep, it was a simple change so I went ahead and modded it and added a few custom things myself (flame cap, destruction potion, scryer's bloodgem)

 

Cardynal

how would I go about adding this new gem (12crit/3% crit dmg) to the spreadsheet?

(nvm, I just added 12 crit to the RED...and my version still works for spells. )

It's only a 10dps loss when using the new caster meta over the current version of the MSD

If the MSD is a 45 second cooldown...and if the proc rate went up to 33%...then you would cast 18 fireballs per 1 proc...assuming no passive haste. This gives it basically a passive haste rating of 15.26 when using fire. This actually scales negativly with passive haste.

I'm seeing a 23dps gain when using the new caster meta gem (12crit/3%crit dmg) over the New MSD for deep fire.

 

Aldric

Followed Rowyn's example and moved my response on the issue over to the maga-thread to help keep things clean.

 

Roywyn

Replied in the general mage thread, to keep this clear.

Basically, your numbers confuse me a lot, my results are different :o

http://elitistjerks.com/509210-post3101.html

 

Cardynal

delete please

 

Cardynal

umm...I was using the same math that the RED did...since I simply modified the RED and gave it 12 crit rating.

Ah...I see what I did for the New MSD now...

If it procs 33% of the time (this is an assumption to simply make it easier) then it will half the cast time of 1 fireball...meaning it would cast in 1.5 seconds. The following 15 fireballs would not have a chance to proc the gem...15x3 = 45. Then assume 1 of the next 3 will proc the gem...so that's roughly another 7.5 seconds....or 52.5. So that saved you 1.5 seconds...since 18 fireballs would have taken 54 seconds.

that's roughly 2.78% decrease in cast time...which would come out to a passive 43.61 haste. According to the spreadsheet...it is a 4dps increase over the method i used to calculate the CSD