Vontre's Mage DPS Spreadsheet - Page 4

Praanz · 04/20/07, 7:48 AM

Edit - I just DL'ed the latest version ...and this was already implemented

Reklaw · 04/20/07, 1:55 PM

In playing with the itemized sheet I noticed that spellpower ring enchant was coming up at 15, instead of 12. Otherwise it's looking great, thanks for the work guys.

Micah · 04/20/07, 5:54 PM

I just downloaded your spreadsheet and is very interesting and enlightening when it comes to certain gear choices. I really appreciate the effort put forth to create this and share it with others.

I do have one question regarding the +hit cap that is not entirely specific to your spreadsheet but you seem to have a deeper understanding of the mage class than most so you would be a good person to ask. :P

I noticed today while on the armory website that when I hovered over my intellect tooltip it showed that affects +hit to a certain degree. In my case (armory link+motw) I have 544 int at the time which tells me I have an added +6.59% to hit. My hit rating is 106 (8.4%) and I have elemental precision.

6.59 + 8.4 + 3 = 17.99%

Can this be right? Am I really 2% passed the cap or is there something I dont know? For the spreadsheet, I can increase my +hit rating to +164 before the numbers cap but according to the numbers I observed above I should be able to lose some +hit without affecting much, if anything.

Tempestra · 04/20/07, 6:01 PM

Int doesn't affect spell hit.

You probably misread +6.59 to crit as +6.59 to hit.

That, or you just found an armory bug =)

Vontre · 04/20/07, 6:02 PM

Probably an armory bug. It should be affecting crit, not hit.

Micah · 04/20/07, 6:08 PM

Hmmm.... Anyone know where I can buy some +Reading gems IRL?

Vontre · 04/20/07, 6:31 PM

Originally Posted by Micah

Hmmm.... Anyone know where I can buy some +Reading gems IRL?

http://www.lenscrafters.com/

Ghalt · 04/23/07, 10:58 AM

I have it up all the time. I play with different builds, gear upgrades, etc.

I'm trying to tweak my build to be the best for the raid.

One thing that I'd love to see is the ability to theorycraft various spell sequences that don't involve Arcane Blast.

For example, what would the DPS and Time to OOM be for Fireball x2, Scorch, Fireblast, repeat.

Ghalt · 04/24/07, 3:36 PM

From what I'm reading, a player's own Ignites will roll/stack.

Can that be accounted for in your spreadsheet? That seems like a serious piece of work to include that, but would make a big difference in dps based on crit gear on long fights, I would think.

I know you have a life, and aren't at my behest to keep updating the spreadsheet on my whims. I wish it were so, but alas...

But seriously, thanks for your hard work on this, and I'd love to hear your thoughts.

Kalman · 04/24/07, 4:18 PM

Rolling ignites, if they're personal, can probably be modeled, but it's not worth putting in the effort until it's confirmed that the mechanic is making a return.

Zene · 04/25/07, 12:26 PM

Hi Vontre,

Great job on the excel spreadsheet.

You might have covered this already, but I was curious how you modelled +spell hit rating in your DPS calculations. There seems to be a couple of schools of thought the 1 roll system versus the 2 roll system.

Thanks,

Z

Vendethiel · 04/25/07, 4:29 PM

You are able to choose, wheter you want to apply the 1-roll-system or the 2-roll-system... On the Main Sheet, some way down in "Misc." area there ist an option you can set: "Two-Roll System***" Either set it to yes or no depending if you want to use it or not...

Vontre · 04/25/07, 4:57 PM

Originally Posted by Ghalt

From what I'm reading, a player's own Ignites will roll/stack.

Can that be accounted for in your spreadsheet? That seems like a serious piece of work to include that, but would make a big difference in dps based on crit gear on long fights, I would think.

I know you have a life, and aren't at my behest to keep updating the spreadsheet on my whims. I wish it were so, but alas...

But seriously, thanks for your hard work on this, and I'd love to hear your thoughts.

=D thanks. I do most of this when I'm bored at work, actually.

Rolling ignites is an interesting concept to model. I would be excited about their return if they were compensated for by a reduction in direct or critical damage from fire to compensate... yeah. I like the idea, I miss the old fire blast after an ignite proc, but I'm not too excited about fire specs further pushing ahead of ice/arcane on damage charts.

Here's what I'm thinking. Chance to roll an ignite is the same, basically, as chance to crit two spells in a row. Or in the case of scorch not in a row, but we're still talking about a crit on two spells. The chance to crit two spells can be calculated easily enough, so I suppose that could serve as a decent "ignite proc chance" and count as added average damage. If you have say 7% chance to roll an ignite, 7% of the added damage is applied to the average.Which would probably end up 20-30 additional damage overall to the average. Which would be roughly 1-2% increase for overall dps.

I could add more tables for chance to proc a third, fourth, and fifth ignite, which increase in power but decrease in likelihood.

Liebestod · 04/25/07, 7:12 PM

Hey there, I was directed to this sheet when I was looking into the possibility of creating something similar to this myself. Nice to see others have done most of the work for me, though. I'll probably try to peek into the code in the future, though, to see what's going on.

A couple things I'd like to suggest, though:

1) Having more flags for specific item effects would be nice, eg. +dmg trinkets, Nexus-Horn, Mark of Defiance, Quagmirran's Eye, and more set bonuses. I'm running a crit-heavy Arcane/Fire build at the moment which isn't doing too hot on the DPS calculations, but is good on efficiency without mad raid buffs.. I'm wondering how it would be affected by being able to add these kinds of considerations. I also wonder if the current spreadsheet can factor in things like AP/PoM/Pyro every 3 minutes into DPS.. kinda doubt it, but these considerations are relevant.. maybe I'm just trying to console myself though.

2) Having a feature that calculates the marginal DPS/longevity bonus of an additional point of various stats would be pretty useful and easy to implement - right now it can effectively be done by just adding a 1-unit upgrade of the various stat, but it's a bit cumbersome, especially when one would like to compare multiple stats at once. If the marginal values could be weighted based on their slotmod value, then very useful itemization advice could be given: "The highest return given your current data would be to invest in _________."

3) Spell penetration should probably be included somewhere, but it would only be useful if target resistances could be imputed. That data isn't always forthcoming (at best one could use long-term resist rate data to try to guess the values for various targets), but... it's a huge omission atm.

4) As was already mentioned, more rotations could be added. I generally use a Scorch/Fireblast rotation, for example, which can't be modeled atm. I realize that factoring FB in would be difficult because its cooldown could be altered by talents, but at least having various rotations that use 0/3 Imp FB and 3/3 Imp FB would be useful. Also, I'm curious as to how effective a Scorch/FB/AB rotation would be... I know this is even more difficult to model, but it'd be nice to see the more common rotations thrown in.

Overall.. great work so far! I'm not very familiar with spreadsheet coding, but if possible I might try to code in some data that could be implemented in a modular fashion - maybe more of the flags I mentioned earlier.

Vontre · 04/25/07, 7:44 PM

Thank you, though in the case of those trinkets modeling them when they are often used in conjuction with player abilities like arcane power is fairly difficult.

Modeling additional rotations is not hard, it's cumbersome from a user-interface standpoint. I'll look into it.

Spell penetration is pretty irrelevant, until this changes I'll be ignoring it completely.

Regarding #2: So you've been using the upgrade comparison module to compare stats, but you're saying you'd like a module to compare each stat at once? Interesting... this is the one I'm most likely to actually implement =)