I see it now, thanks.

Ahah. That explains it. Thanks.

the link posted about this site MaxDPS.com: A World of Warcraft Formula Site - Fire Mage DPS Gear Rankings seems to have different out comes than your spreadsheet when i calculate it out. So what i would be asking is.

1) is your spreadsheet better than his
and
2) when i calculate out the items on his chart in your spreadsheet, i come out with different rankings. so i am guessing that site is not as correct as stated? or am i wrong, is that site indeed have the correct rankings?


edit: i could also not be comparing two items right, or using the proper part of the spreadsheet. =[ but what would you suggest i do / use to compare 2 different pieces of loot to see which is better? i am pretty lost with it, been fooling with the spreadsheet for some time now hhaa.

I noticed that Vindicator's Silk Footguards has 25 haste rating in the spreadsheet. Now you can manually remove it (go to the Boots tab, and look up the Vindicator's Silk Footguards line and enter 0 instead of 25 haste rating), but is it there for a reason I am not aware of? Because it is quite the boost to DPS if it is... Those boots actually are equal to Boots of Blasting for me if that 25 haste is appropriate...

The footpads of madness, 2 lines above them are missing 25 haste rating. Looks like it was just input on the wrong line to me.

Another calculation related bug report:

If you select the "Carved Witch Doctor's Stick", the wand's socket color should be shown as "blue".
However, it shows up as "Red" instead(wrong) and the conditional formatting for the socket bonus value is also wrong.

The actual item is correctly entered into the "ItemDB" sheet, but the calcuations which use the data on the "Gear" sheet are incorrect.

Specifically, "Gear"!cell Z96 should just be "=AP95" where the correctly formatted socket string is located.

Then cell "Gear"!G54 should use the "LEFT(" version of the socket formula like the necklace does:
"=IF(VALUE(LEFT(TEXT(Z96,"0000"),1))=1,"red",IF(VALUE(LEFT(TEXT(Z96,"0000"),1))=2,"bl ue",IF(VALUE(LEFT(TEXT(Z96,"0000"),1))=3,"yellow","")))"

Finally, the conditional formatting for "Gear"!H55" should be "=IF(AI97,TRUE)" and "=NOT(IF(AI97,TRUE))" for blue and orange respectively.

P.S.> It may be worth checking all similar socket formulas on the Gear sheet.

I understood that Fireblast is a DPS loss only in the case of hasted Fireballs. Without haste, Fireblast still has more than 50% of the damage of Fireball, which means it is a net increase in DPS as long as its real cast time is 50% of Fireball.

No, I think galzohar was referencing to the ignite bug involving fireball/fireblast. Check thread [Mage] Rolling Ignites: are they back? for more info (or rather, check my latest post).

If my theory is correct, you are almost 100% of the time getting a DPS loss doing fireblasts doing your fireballs, haste notwithstanding.

My simplistic understanding of your thread: Inserting a Fireblast which crits before a Fireball which crits will likely have its ignite eaten by the ignites from the Fireball. Your hypothesis is that 100% back to back crits will eat one or the other ignite contribution.

Reductio: 0% crit yields a DPS increase when interleaving Fireblast with Fireball. At some point, back to back crits start dropping damage to the point where Fireblast crits are counterproductive. What crit % is required before you start losing damage with respect to Fireball only?

No actually you only got half of the theory correct, although you are right to say that what I mentioned is incomplete.

My thread is about getting > 40% damage from ignite, mostly by having an ignite tick while your fireball is in mid-air. The side effects of this is that effectively a fireball/fireblast crit will end up having your fireball crit disappear.

Can anyone help me?

what would you suggest i do / use to compare 2 different pieces of loot to see which is better? i am pretty lost with it, been fooling with the spreadsheet for some time now haha.

can anyone explain what to do and then how to use it?

Two ways you can do this.

First way: Stat comparison

On the main sheet is a stat comparison table (I4).

After inputing your gear's stats (or gear selector, or armory import if you have office 2000), put in the stats of the two items. Put the first item's stats in option 1, and the second item's stats in option 2.
It should then tell you the dps difference (it compares how much better option 2 is compared to option 1) and bob's your uncle it's done!

Second way: Gear selector

On the main sheet you should see a cell highlighted in green called 'Manual Stat Entry' (Cell A6).

When you click on that cell, you should see an arrow that drops down a box that allows you to choose between :Manual Stat entry, gear selector, and armory import.

Choose the gear selector and then move on to the 'Gear' sheet (press CTRL + Page down, if you can't find the worksheet or your sheet selecter itself is bugged).

Voila! Put in the gear you currently have and then switch between the two pieces of gear you want, and you should see a box in the gear sheet that shows your dps change with the two different items.

Hope this helps, and if this isn't what you were looking for, then sorry :P

yeah, that does help, i was just wondering if that is how you do it... secondly can anyone explain if maxdps.com is a good thing to use or is accurate, because right now it doesnt look like its very accurate. if it was, that would be sick.

forgot to say, thank you for your help too!

[Shroud of the Highborne] seems to be missing the 23 damage part in the itemdb.

Also, I have some trouble getting rid of some gem-bonus values in the gear selection. Even if I put all red gems into items with red/yellow/blue sockets I get the socket bonus. I looked at the "=IF(OR(AA28=0;AA28="0,C");"n/a";LEFT(AA28;1)&" "&INDIRECT("'Stat Names'!"&RIGHT(AA28;1)&"1"))" bit, but I have no idea how to correct it.

I'm also wondering how I would go about adding the BT gems that are missing, like Glowing Shadowsong Amethyst etc.

Chrismasters

According to Vontre, the maxdps site is fine, and the only thing is that it uses a 1 roll system.

I won't go too deeply into the specifics of the roll system, but it seems that most people agree that spells work on a 2 roll system, while melee dmg works on a 1 roll system.

The 2 roll system suggests that crit is based only on the spells that hit.
First the WoW client rolls a number which decides whether your spell is a hit or a miss.
Then the WoW client rolls another number which decides whether your spell is a normal or a crit.

The 1 roll system suggests that spells will either crit, hit, or miss.
So if you have a 30% chance to crit, it means you will crit on all spells, including your misses.


That being said, there are people who do not believe in the 2 roll system, and hence the maxdps site is a good alternative to those who want to see their dps based on a 1 roll system without having to download any spreadsheet.

You can enable the 1 roll system in Vontre's spreadsheet on the mainsheet in the Misc table (cell B57).



Ninor

Not sure if you already changed the 23 dmg on shroud, but here's how you do it anyway for those that might want to.

1. Go to the Itemdb sheet (its the last one).
2. Go to row 1505. You should see Shroud of the Higborne (it's spelt that way in the sheet).
3. Go to the spelldmg column (H).
4. Write 28 in the blank cell
5. Done!


Tell me which items you are having problems with in terms of gem socket bonuses, and I'll see what I can do.


To add gems
1. Go to the gems sheet
2. Select a row in which the gem is categorised in (ex: your Shadowsong gem is in the red/blue section, hence select row 21).
3. Right click the row number, and click on 'Insert'.
4. Add the gem title that you want (I suggest sticking to the '[red/blue] +6 dmg/+6 stm (glowing tanzanite)' format).
5. Move right and add the values of the gem (use the columns to see which stat is for which column).
6. The type of gem should be marked at the end under the 'Red' 'Blue' and 'Yellow' columns. If your gem is red, put a 1 in the red, and 0 in the blue and yellow. If your gem is purple, put 1 in the red and 1 in the blue, 0 in the yellow.



I hope that helps

thank you so much akuman. that explains some things, i was just wondering about that site, because somethings dont make sense to me on that site like t5 being better than grend engineers helm. or just some small things, but i think ill use Vontre's still to be 100% sure about those small calculations.

last question: what should i put my boss duration, mob level, and pushback at for the average numbers to come out with the best dps comparisons if i dont wanna calculate whats best for each boss. what would be a good average to put in there to compare two items.

Did you get an opportunity to update this spreadhseet with the IV changes, yet?

Chrismasters

It really depends on so many factors...so I don't think there is a way of putting in values and coming out with your average dps.

I mean, with Elemental precision, you need +13% hit on bosses, and only +2% hit on mobs.
And then in longer fights you will be dealing less dps, while in shorter fights you might be dealing amazing dps due to it's brevity.

What I suggest you do is put on your gear for bosses, set the level of the mob for 73, and see your dps.
Then put on your gear for trash, set the level of the mob for 72, and see your dps.

Your average dps would be somewhere between the two I suppose :P


Ninor
I put 3 Runed Crimson Spinel's in both of the items and it works as intendid. You do not get the socket bonus.

The box will always say 'Bonus +5dmg' but if it's red the socket bonus is not active. If its green it will be active.

When I change Winter's Chill on target to "on", it does not change my frost damage done. Is this a bug, or is it already implied that Winter's Chill is stacked in its entirety when calculating damage?

thank you very much akuman, you have been an outstanding help. if i have any other questions later on, i will be sure to ask you. thanks again.

yea, any word on updates for 2.3.2 ?

For gear selector, how can i, or vontre can you add the epic gems to the gear selector tabs? Or am i missing something on how choose the epic gems?