Vontre's Mage DPS Spreadsheet - Page 22

galzohar · 04/09/08, 5:12 PM

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.

Samuraiboy · 04/10/08, 9:27 AM

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.

Joeblack · 04/11/08, 8:44 AM

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??

arch · 04/11/08, 11:06 AM

Works just fine for me in Open Office

Keibler · 04/14/08, 9:43 AM

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.

Vontre · 04/15/08, 4:29 PM

Better openoffice support is something I want to implement for version 3 as well. It is a bit sketchy right now.

Joeblack · 04/15/08, 10:42 PM

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.

Sguz · 04/17/08, 5:41 AM

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

Allanonn · 04/18/08, 10:21 AM

Vontre,

Any chance you can model the Sorcerer's Alchemist Stone on magegraf.com?

Didn't know where else to post this...

Vontre · 04/18/08, 12:56 PM

Just uploaded beta revision 2 of the spreadsheet. It should now work in Open Office.

Moander · 04/19/08, 11:54 PM

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!

Elyasviel · 04/21/08, 12:55 AM

Is there an updated gear selector spreadsheet with new badge gear out already?

hypetech · 04/21/08, 1:13 AM

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.

Vontre · 04/21/08, 3:06 PM

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

hypetech · 04/22/08, 4:04 PM

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.

Sguz · 04/26/08, 7:18 AM

there seems to be a problem with gear selector and the main sheet:
when i switch my trinket in the gear selector, it isnt recognized in the mainsheed (would be ok when it were 2 different calculations)
but when i switch the trinket in the mainsheet, the vaules in the gear selector sheets change.
is this intended?

and I found some missing stats at the gear selector (bracers of nimble thougt, illidan staff and so on)
greets

/edit: in the gear selector, the gems @wands are bugged (no field to paste in, no selection, no changing in calculation)

asys · 04/26/08, 5:16 PM

Vontre, any chance of getting Bloodlust out of the maths for http://www.magegraf.com/ ? I'd guess more than 50% of the mages on our (and any) server would not have it

Vontre · 04/26/08, 6:54 PM

Originally Posted by asys

Vontre, any chance of getting Bloodlust out of the maths for http://www.magegraf.com/ ? I'd guess more than 50% of the mages on our (and any) server would not have it

Mages should be the first class to get bloodlust...

But there's an option under Buffs/Debuffs. I still haven't figured out how to make it obvious you can click on those, I suck at interface.

asys · 04/27/08, 4:58 AM

Originally Posted by Vontre

Mages should be the first class to get bloodlust...

But there's an option under Buffs/Debuffs. I still haven't figured out how to make it obvious you can click on those, I suck at interface.

Lol - if I had only clicked on the

Other Bonuses
Consumables
Buffs/Debuffs
Mana Regen

To see the stuff under it...

Add a (click to expand) note perhaps? or a [+]

- On another side note it sees only 137 of my 139 spell haste when importing from Armory?

MyrddinE · 04/28/08, 4:08 AM

The beta spreadsheet appears to be missing Prayer of Spirit & Improved Prayer of Spirit.

rafikki · 05/02/08, 8:15 AM

The gear.xls file is missing haste on at least Mantle of Nimble Thought. Also, echoing Damien's comments above, the beta sheet just isn't matching up to the old one. It shows me almost 300 dps higher with the same gear/set up.

Vontre · 05/02/08, 3:11 PM

Originally Posted by rafikki

The gear.xls file is missing haste on at least Mantle of Nimble Thought. Also, echoing Damien's comments above, the beta sheet just isn't matching up to the old one. It shows me almost 300 dps higher with the same gear/set up.

I'll be taking another look at it when I have time. This is why I went with a beta instead of direct upgrade. =p

On that note I just made several calculation improvements and fixes for magegraf, most notably improving the arcane logic.

Perrier · 05/17/08, 7:27 AM

Okay, I am definitely no math wiz, and i am pretty sure my spelling, typing, and grammar suck too. That said i seem to be getting a bit of diminishing returns on my spell damage. I am currently using these values:

387 Int
182 spi
774 sd
167 crit
156 hit
0 mp5
172 fire/arcane dmg

42 haste

I have 3/3 spellfire
and 2/2 spellstrike

Lightning cap

my build is 4/46/11

i have all bonuses set to 0 ( ie wrath of air, totem of wrath, vamparic embrace etc)

I am using imp scorch

and have it set for a 360 second (6 min) encounter

with push back at 45

when i add the 101 spell dmage directly and with the option for WoA i get a "return"or increase of 68 dps. 67%

but if i put in 50 spell damage i get 33 dps. 66%

75 spell damage i get 51 dps. 68%

finally ( i added this because 50/75/100 are multiples of 25 so i figure it must be consistant due to distribution)

60 spell damage is 40 dps also 67%.

can you tell me why i only get 67% of my spell damage as dps?

Can you add an option to compare a 5s-8fb-1s vs. 5s-7fb- 1s vs. 5s-9fb-5s rotation?

Sguz · 05/24/08, 4:54 AM

I can't wait for the next version
Please Vontre, give an update or do you only support magegraf now?

roknir · 05/24/08, 2:30 PM

There's a bug in the Vontre sheet when you copy in the talent link from the official talent calculator. Blizzard must have slightly changed their url for it. There's a section in their new url's that you need to take out for the spreedsheet to read it properly. That section is "tal=".