Elitist Jerks Vontre's Mage DPS Spreadsheet

04/09/08, 5:12 PM   #526
galzohar
Bald Bull

Darksorrow (EU)
 Originally Posted by Samuraiboy Ok, here are my equations. They are probably a bit too idealistic, but I think they are still more accurate than the current equations. So the average + spell damage for a trinket with Duration=D, Cooldown=C, +Spell Dmg=S, and Boss fight Time=T is as follows: If MOD(T/C)<=D(If the Boss Fight stops in the middle, or right at the end of the trinket buff) Then (DS*INT(T/C))+MOD(T/C)S)/T (The total damage increased+the damage increased in the last buff all divided by the length of the boss fight) Else(If the Boss fight ends when the buff is not applied) (DS*INT(T/C))+DS)/T(The total damage increased+The total damage increased in the last Cooldown cycle of the trinket all divided by length of boss fight) When I say "the total damage increased" it is basically (the Spell damage given by the trinket)*(the duration of the effect)*(the total number of times that the trinket is activated). That value does not really manifest itself in game, but it is useful for calculations. I know this is a bit confusing, but let me know if I am dead wrong in my Theorycrafting, or if you don't understand it. Thanks! (Vontre I have these formulas in excel format too if you want them.)
Current theorycraft already takes those kings of factors into account plus much more such as cooldown stackings.

04/10/08, 9:27 AM   #527
Samuraiboy
Glass Joe

Lothar
 Originally Posted by galzohar Current theorycraft already takes those kings of factors into account plus much more such as cooldown stackings.
Right, but I'm pretty sure the spreadsheet doesn't.

04/11/08, 8:44 AM   #528
Joeblack
Glass Joe

Orc Warrior

Cho'gall
 Originally Posted by Joeblack Open Office "Err:502" I get this instead of a list of gear when i click on the dropdown arrow. Yes, my gear selector option on the main page is selected.
is Excel a requirement or something??

 04/11/08, 11:06 AM #529 arch Don Flamenco     Eriond Undead Mage   Al'Akir (EU) Works just fine for me in Open Office
 04/14/08, 9:43 AM #530 Keibler Glass Joe   Keibler Gnome Mage   Lothar It appears there's something strange with the formulas on the gear selector page for the pants slot and the boots slot. The intellect stat is being ignored or counted as spirit instead of int.
 04/15/08, 4:29 PM #531 Vontre Mr. Sandman     Vontre Gnome Mage   No WoW Account Better openoffice support is something I want to implement for version 3 as well. It is a bit sketchy right now. Raiding is full of challenge. Sometimes there is fire. You have to not be in the fire.
04/15/08, 10:42 PM   #532
Joeblack
Glass Joe

Orc Warrior

Cho'gall
 Originally Posted by Joeblack Open Office "Err:502" I get this instead of a list of gear when i click on the dropdown arrow. Yes, my gear selector option on the main page is selected.
I'd like to use your spreadsheet, but am still unable to due to the above error.

 04/17/08, 5:41 AM #533 Sguz Glass Joe   Sguz Undead Mage   Eredar (EU) found a bug in the gear import engine: The first column of the "Pants" isnt correctly imported - when you import for example "leggings of the chan. e." int becomes spirit, spirit becomes fire and so on
 04/18/08, 10:21 AM #534 Allanonn Von Kaiser   Switters Tauren Shaman   Greymane Vontre, Any chance you can model the Sorcerer's Alchemist Stone on magegraf.com? Didn't know where else to post this...
 04/18/08, 12:56 PM #535 Vontre Mr. Sandman     Vontre Gnome Mage   No WoW Account Just uploaded beta revision 2 of the spreadsheet. It should now work in Open Office. Raiding is full of challenge. Sometimes there is fire. You have to not be in the fire.
 04/19/08, 11:54 PM #536 Moander Glass Joe   Moander Undead Warlock   Uldum Hey Vontre, I was playing with the magegraf.com version trying to model the impact of a totem of wrath for mage vs. warlock (very nice program btw ). I did get a surprising result that I wanted to run by you to see whether or not its a bug. If I add 67 crit rating to a shadow destro warlock, I get a 3.44% DPS increase (3% personal plus 0.4% due to ISB) which is exactly what I predicted from the math. When I do it for a mage though, increasing crit rating by 67 only gives a 2.15% DPS increase instead of the 3.3% (crit plus ignite damage) I was expecting to see. Is this a bug in the program or is it accurate? If it's accurate, would you mind explaining to me how you arrive at that value? Also, on an unrelated note, may I ask what are the assumptions that you put into the ISB uptime calculation (ie number of spriests and aff locks vs number shadow destro)? My apologies if you've posted it somewhere else; please just shoot me a link if thats the case. Thanks for the nice tool, and thanks in advance for the help!
 04/21/08, 12:55 AM #537 Elyasviel Von Kaiser   Riyomorii Human Mage   Blackrock Is there an updated gear selector spreadsheet with new badge gear out already?
04/21/08, 1:13 AM   #538
hypetech
Don Flamenco

Draenei Mage

Elune
 Originally Posted by Elyasviel Is there an updated gear selector spreadsheet with new badge gear out already?
Yes and no. The beta spreadsheet he released has 2.4 gear, but it has ONLY 2.4 gear atm.

 04/21/08, 3:06 PM #539 Vontre Mr. Sandman     Vontre Gnome Mage   No WoW Account Beta revision 3 of the new spreadsheet is posted. Someone sent me an updated gear selector, and it should have all the old gear now as well as the set bonuses. http://www.magegraf.com/mage_dps_beta.xls http://www.magegraf.com/gear.xls Raiding is full of challenge. Sometimes there is fire. You have to not be in the fire.
 04/22/08, 4:04 PM #540 hypetech Don Flamenco     Damien Draenei Mage   Elune The old spreadsheet shows me at 1755 dps and the new beta one shows me at 1858 in the same gear with the same consumable/buff options. Also it shows that a +12 damage gem in t6 gloves is about 5 dps better than using a reckless pyrestone (6 dmg/ 5 haste) while the pyrestone nets you the +2 damage socket bonus. That doesn't seem right.

 Elitist Jerks Vontre's Mage DPS Spreadsheet