Vontre's Mage DPS Spreadsheet - Page 27

ninor · 01/11/08, 5:13 AM

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

Akuman · 01/11/08, 9:43 AM

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

Chrismasters · 01/11/08, 11:06 AM

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.

ninor · 01/11/08, 11:39 AM

Thats awesome help Akuman, thanks a lot! I did fix the Shroud's entry, but thought I'd mention it for a future revision. As you explained it was a pretty simple solution.

The items I have trouble with are [Leggings of Channeled Elements] and [Robes of the Tempest]. In both of these I have 3 red gems, Runed Crimson Spinel +12 dmg, but still it says "Bonus 5+ dmg".

I'll add the gems now, thanks!

Fayenoor · 01/11/08, 1:48 PM

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

Akuman · 01/11/08, 3:41 PM

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.

Tonin · 01/11/08, 4:32 PM

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?

Chrismasters · 01/11/08, 8:22 PM

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.

trif · 01/13/08, 6:33 PM

yea, any word on updates for 2.3.2 ?

Chrismasters · 01/14/08, 1:51 AM

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?

Vontre · 01/14/08, 1:56 AM

Originally Posted by Tonin

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?

Stacking is if you have the talent.

Cloudo · 01/15/08, 12:13 PM

I have been using Vontre's to maximize dps... but I have been coming in utterly low on wow web stats compared to vontre's spreadsheet calculations. Perhaps I'm not interpreting his spreadsheet correctly, but assuming I am...

(1) My typical build is 2/48/11 .
(2) I'm 2x scorch (2 other scorch mages helping apply buff) 8x fireball, 1xscorch... repeat

My armory is in my profile.

Or you can view my spreadsheet: http://www.getgorm.com/WoW/Cloudo_new.xls (**EDIT: I had the main page settings with enhancements that I am not recieving from different groups. But, the difference dropped the dps to 1430ish and looking at my dps times on Hydros, I am still not close to the estimated #**)

_________________________________________________________________________________

Some WoW Webstats data:
_________________________________________________________________________________

HYDROS: #5 Cloudo - 98 % presence /// 297 574 dmg /// 7 % total dmg /// 833 dps /// 92 % dps time

Fireball (Fire) Total 257 504 // % // Hits 62 // Avg 2518 // Dots 121 // Avg 24 // Max 31 // Crits % 28% // Max 4680 // Missed 1.1% // Mitigated % 4.4%

(seems as if no scorch debuff was ever applied by any mage)

Ignite (Fire) Total 37 904 // % 12% // Dots 43 // Avg 881 // Max 1402

Fire Blast (Fire) Total 1 863 // % 0% // Hits 1 // Avg 1863

Frost Nova (Frost) Total 303 // % 0% // Hits 2 // Avg 151

-------------------------------------------------------------------------------------
LURKER: #3 Cloudo - 100 % presence /// 329 391 dmg /// 7 % total dmg /// 980 dps /// 65 % dps time
(Lurker I'm on the furthest island on sheep duty only hitting lurker and (1) other elite)

-------------------------------------------------------------------------------------

HIGH ASTROMANCER: #2 Cloudo -100 % presence /// 452 767 dmg /// 9 % total dmg /// 1 243 dps /// 81 % dps time
(The dps is higher, but this is an aoe fight)

//////////////////////////////////////////////

Final word,

On Fathom Lord, one of my other mages beat me out by 10K. He had 65 hits to my 71. He was at 3% miss, to my 1% 100~ less spell dmg. Using the spreadsheet he was below me.

The only stat he had was 3% more to crit. When does Hit > spell dmg > crit come into play? Between me and him it seems Crit > Hit > Spell dmg

( WWS Loading... )

manly · 01/15/08, 1:28 PM

A few notes:

1- please link directly to WWS, it is much much easier for everyone to read and for you to type as well

2- it is very rare that a mage can reach on WWS the TC-dps. Theorycraft mostly assumes non-stop casting, which is not the case under almost every encounter. As such, I wouldn't really expect to get those numbers, unless you use teron as fight.

Etherealz · 01/15/08, 1:34 PM

Originally Posted by Cloudo

I have been using Vontre's to maximize dps... but I have been coming in utterly low on wow web stats compared to vontre's spreadsheet calculations. Perhaps I'm not interpreting his spreadsheet correctly, but assuming I am...

Text

( WWS Loading... )

Well I see this in the first bit of fathom lord combat.

03:23'33.625	Cloudo's Fireball crits Fathom-Guard Sharkkis for 4267 Fire damage - First fireball
03:23'35.703	Cloudo's Fireball dots Fathom-Guard Sharkkis for 21 Fire damage (6 resisted)
03:23'36.391	Cloudo's Ignite dots Fathom-Guard Sharkkis for 854 Fire damage
03:23'37.125	Cloudo's Fireball hits Fathom-Guard Sharkkis for 3132 Fire damage - 3.766s fireball
03:23'38.391	Cloudo's Ignite dots Fathom-Guard Sharkkis for 854 Fire damage
03:23'39.047	Cloudo's Fireball dots Fathom-Guard Sharkkis for 30 Fire damage
03:23'40.328	Cloudo's Fireball hits Fathom-Guard Sharkkis for 3448 Fire damage - 3.203s fireball
03:23'42.266	Cloudo's Fireball dots Fathom-Guard Sharkkis for 30 Fire damage
03:23'43.438	Cloudo's Fireball hits Fathom-Guard Sharkkis for 3400 Fire damage - 3.110s fireball

It would seem your main problem is being a tad slow at chain casting.

Cloudo · 01/15/08, 1:36 PM

Originally Posted by manly

A few notes:
1- please link directly to WWS, it is much much easier for everyone to read and for you to type as well

It's at the bottom of the post, I most likely edited as you were typing it out>

Originally Posted by Etherealz

Well I see this in the first bit of fathom lord combat.

03:23'33.625	Cloudo's Fireball crits Fathom-Guard Sharkkis for 4267 Fire damage - First fireball
03:23'35.703	Cloudo's Fireball dots Fathom-Guard Sharkkis for 21 Fire damage (6 resisted)
03:23'36.391	Cloudo's Ignite dots Fathom-Guard Sharkkis for 854 Fire damage
03:23'37.125	Cloudo's Fireball hits Fathom-Guard Sharkkis for 3132 Fire damage - 3.766s fireball
03:23'38.391	Cloudo's Ignite dots Fathom-Guard Sharkkis for 854 Fire damage
03:23'39.047	Cloudo's Fireball dots Fathom-Guard Sharkkis for 30 Fire damage
03:23'40.328	Cloudo's Fireball hits Fathom-Guard Sharkkis for 3448 Fire damage - 3.203s fireball
03:23'42.266	Cloudo's Fireball dots Fathom-Guard Sharkkis for 30 Fire damage
03:23'43.438	Cloudo's Fireball hits Fathom-Guard Sharkkis for 3400 Fire damage - 3.110s fireball

It would seem your main problem is being a tad slow at chain casting.

Yeah, that may be the case, I do remember being idle for a big portion of the fight due to mana issues (No shadow priests and was out of range for the mana totem for a lot of the fight) But cast for cast I cast more than pyro, doesn't that neglect the speed?