Vontre's Mage DPS Spreadsheet - Page 28

Tonin · 01/15/08, 1:41 PM

Thanks a lot. Also, would you be able to edit your original post indicating the date you most recently updated your spreadsheet in terms of gear/calculations? It would help me out a lot in keeping up to date

.

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

Originally Posted by Cloudo

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?

Well without looking too deep into that specific fathom lord fight I first see you have more fireball hits, but also a larger amount of dps lost to partial resists. Pyro crit more than you did and there's also the chance that he popped his cooldowns in MF range, or scored more crits in mf range than you - or potentially all of your partials were on crits. Pyro also used fire blast a few times possibly making up for the fireballs.

Chrismasters · 01/16/08, 12:29 AM

First off, 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?

Secondly, i believe the item/weapon called the maelstrom's fury off najentus is not in the gear selector tab for the sword.

ninor · 01/16/08, 3:43 AM

Originally Posted by Chrismasters

First off, 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?

Akuman answered this on the previous page in a post with your name right on top of it.

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.

galzohar · 01/16/08, 7:16 AM

Assuming a 1 roll system will greatly devaluate hit below cap compared to a 2-roll system, however if you're already assuming you're hit capped, the differences between 1 roll and 2 roll are very, very small.

Amarilia · 01/16/08, 7:54 AM

It's not really a question about mages but is there any way to save the tabs where you edit the gear in? It's pretty annoying to edit epic gems and new items every time a new patch comes out(and I need to get a new version of the spreadsheet).

Akuman · 01/16/08, 9:35 AM

You could always open the new spreadsheet, and copy paste the epic gems from your old spreadsheet.

But I do believe there are other ways within the program (which I am unaware of) but the above is a quick alternative until you find a proper answer :P

Theegirly · 01/16/08, 10:25 AM

I have been reading this forum for a while now. I use Vontre's SS and I can't get the DPS that is listed on it. With my gear and the buffs I have every raid. I am lucky if I can break 1000 DPS. The only things that saves me is my DPS time on the target. I was wondering if you guy could give me some hints on what I am doing wrong.

Wow Web Stats

Also on the Leo fight has anyone else noticed the high miss rates?

Docjowles · 01/16/08, 10:50 AM

Unless you are standing still chain-nuking for the entire fight, with no lag, no spell pushback and no mistakes, you are unlikely to get all that close to your theoretical DPS on the sheet. You can tweak a couple of those parameters, but it tends to assume optimal conditions.

Tarrke · 01/22/08, 6:08 AM

Heya here,

seems for me that there is a slight error in the spread sheet, nothing really important, but you know, what everything to be clean ^^

So in the cycle builder sheet, you got at cell J 42 the best dpm damage, that is the damage done by the best dpm spell i assume. The formula here is this one :

RECHERCHEV($L$40;$L$26:$M$30;2)

If I check the L 40 cell i found this formula, looking for the best dpm spell in a list :

MAX(L26:L34)

So the question is, why this difference in the data you read ? Theses two formulas are incoherent, i assume that either the first should be L26 to M34 or the other should be L26 to L30.

PS : sorry my own version of excel is in french, so the RECHERCHEV function should be something like searchV or Vsearch, don't know the english version of that.

galzohar · 01/22/08, 10:33 AM

How is bloodlust accounted for? Does it assume its used on an optimal time or just a passive haste %? And if it's the former will you consider including in the future "# of bloodlusts" option and "optimal bloodlust timing" option?
I was mostly wondering if the bloodlusted elemental and BL stacking with other stuff was taken into account, considering the spreadsheet doesn't actual request a bloodlust "count" but rather "uptime".

galzohar · 01/25/08, 10:07 AM

Noticed that when I drop my SP from 200 mp5 to 150 I do the same DPS but MORE dmg done total. How is this possible?

(both cases I get "max" under my dmg, does this mean in both cases I didn't oom?)
Same goes for mana regen consumeables - not using them keeps same dps but increases my damage done total, and both say "max".

Setia · 01/27/08, 3:18 PM

Originally Posted by Tarrke

PS : sorry my own version of excel is in french, so the RECHERCHEV function should be something like searchV or Vsearch, don't know the english version of that.

I believe you're referring to VLOOKUP.

Akuman · 01/27/08, 7:04 PM

Galzohar

Try downloading the most recent spreadsheet, and try again.

I'm pretty sure there is no way you can gain more dmg done while reducing the Vampiric Touch to 150 from 200.

The mana regen consumables I can sort of understand in a realistic sense, because it allows you to use flame cap over the mana gem.

I understand that in longer fights, while your dps remains the same, you might oom earlier without the proper mana regen facilities.
So if your dps stayed the same, but your dmg decreased by having 150 mana from vampiric embrace instead of 200, that would make sense in fights where your dps time is shorter than the encounter duration.

However, unless there is some error within the spreadsheet, I don't think its possible to get better dmg from reducing the amount of mana from vampiric touch.

Are you sure you didn't change the encounter duration as well?

Could you host your modified excel spreadsheet or link some screenshots with the two different results.

Make sure you don't change anything except those two exact variables.

Oh and btw, the 'max' under the build comparison tables is put there in order to point out which of the dps cycles would bring you the most dmg.

If frostbolting brings you more dmg than fireballs and scorch, then the 'max' would go under the frost column.

If you're looking for the amount of time you can dps with a spell, you can find it in 'Spells' table on the main sheet, in the column 'Time'.

Tarrke

Yeah, I think it is a mistake in the spreadsheet calculations though I'm not sure.

If I were to guess. I would think it would have to do with Vontre's initial spreadsheet calculations that did not include different levels of Arcane Blast.

Although I'm speculating, I think that the code should be read like this:

Cell J42

=VLOOKUP($L$40;$L$26:$M$39;2)

Cell L40

=MAX(L26:L39)

It's also possible that this is not a mistake, and was intended to be calculated like that...or another explanation is that the table you mentioned isn't really used in the calculations and was put there as a convenience or simply was added and never removed.

Either way, I hope this helps

Myrdinn · 01/29/08, 7:42 PM

Hey Vontre,

Sorry to bother, any chance you release your simulator soon ?

Thanks!