Vontre's Mage DPS Spreadsheet - Page 3

Kalman · 04/12/07, 3:42 PM

The most recent version I have from Vontre is uploaded.

Vontre:

Contextual menus are done via the Validation drop-down and the VLOOKUP function. The way the sheet is structured right now, it might be a little ugly; if you do a little rearranging though, it's easy enough to do contextual menuing via validation/vlookup. Check out the rogue spreadsheet if you want examples, or hold off until I get the gear page done; it'll use that method.

Kalman · 04/13/07, 2:23 AM

As promised, I have a first pass on a gear interface into Vontre's sheet.

I'm sure it has significant, major, horrifyingly wrong issues.

FIND THEM. Add pieces of gear. Tell me what's wrong/missing and Vontre and I will get it fixed. There's also a *lot* of modeling that isn't yet done, mostly for onhit type procs. I also model trinkets as averaged over their duration, which isn't really correct for a specified fight length, but we can fight with that later.

For now: have at it.

http://www.radiationnow.net/wow/beta/mage_dps_gear.ods (verified as working for OpenOffice)
http://www.radiationnow.net/wow/beta/mage_dps_gear.xls (might or might not work right in Excel)

kelben · 04/13/07, 5:50 AM

My first thought was complicated... way too complicated ; / I've been using Irontygres's Theorycrafting for Mages program http://hosted.filefront.com/Irontygre - unforuantely it was never completed and theres mistakes through out the orginal item files... I've modded mine to reflect the correct values and added additional items...

However, i can't seem to get the menus to work in excel, but I'll play around in a bit with your update

Kalman · 04/13/07, 9:11 AM

The menus may not work in Excel - OpenOffice doesn't seem to save validation information through to Excel formatted documents, which is annoying. I don't know how exactly I'd make it less complicated - it's got to handle gear and sockets and enchants, and dropdowns for each of those (if they were working) are the appropriate way.

Also, it throws a bunch of error: 502s on non-socketed items. These are just visual, they don't affect operation of the document.

Vontre · 04/13/07, 12:33 PM

Menus don't work in excel, this is a problem for me.

I have to get some actual work done today anyway, though =p

Wynna · 04/14/07, 1:16 PM

Oh nice, I've been looking forward for the mage spreadsheet to start looking like the rogue one, that way I could make 2 or 3 changes of gear and see what would be the overall benefit instead of only knowing what is what isn't a single upgrade

<3 Vontre

Edit: I also just got the latest version of the spreadsheet and it doesn't show any damage increase when I have Improved Scorch on the target btw.

Edit2: Another weird thing I noticed on this new version... I don't know, I'm getting the feeling +hit is not being as good and it used to show me it was, and I also lose like 100 dps from sheet 2.2 to this 2.3.5, what changes caused this exactly? (with obviously the same stats)

Vontre · 04/14/07, 3:33 PM

I fixed several bugs between those versions. Also, a non-confusing implementation of the scorch/wc values... I don't know. If you have the talent, it assumes it is up already. If not, it uses the settings to see if someone else is doing it for you.

Wynna · 04/14/07, 5:14 PM

Oh ok! Thanks.

Another question, the haste rating thing added, I have a quag's eye so I should just go ahead and put 320 over there? Does it account for its hidden cooldown and all that though? Because I usually use an Icon of the Silver Crescent + Nelth tear, and I believe the the Icon is a lot better since you'll use it everytime you use combustion, which gives a bigger burst although I know there's not really a way to add that to the sheet. Thanks in advance =]

Vontre · 04/14/07, 7:18 PM

No it's for modeling temporary effects. The spreadsheet has no idea about cooldowns or proc rates, it just shows dps while you have [x] haste rating.

fr0d0b0ls0n · 04/16/07, 11:12 AM

I was thinking in trying this build:

http://www.worldofwarcraft.com/info/...10230010040000

The idea behind it is Ice Shard + Spell Power, for a 150% bonus crit damage, with Winter Chill, A. Instability and high crit items. But this sheet doesnt seem to stack Ice Shard with Spell Power... is a bug, or I'm wrong?

Is my first post here... i hope i havent done anything wrong

Kalman · 04/16/07, 11:21 AM

Originally Posted by fr0d0b0ls0n

I was thinking in trying this build:

http://www.worldofwarcraft.com/info/...10230010040000

The idea behind it is Ice Shard + Spell Power, for a 150% bonus crit damage, with Winter Chill, A. Instability and high crit items. But this sheet doesnt seem to stack Ice Shard with Spell Power... is a bug, or I'm wrong?

Is my first post here... i hope i havent done anything wrong

Shards + Spellpower isn't a 150% crit bonus for a 250% crit, it's 250% of base crit bonus (50%) for 125% crit bonus, or 225% crits.

And I just checked the sheet, it seems to be calculating crit bonus correctly.

fr0d0b0ls0n · 04/16/07, 2:24 PM

Originally Posted by Kalman

Shards + Spellpower isn't a 150% crit bonus for a 250% crit, it's 250% of base crit bonus (50%) for 125% crit bonus, or 225% crits.

And I just checked the sheet, it seems to be calculating crit bonus correctly.

I know that, it seems i was looking a wrong place in the Calculations tab, my fault. It works perfectly. But that build dont have the raw power of another, more common, builds.

Thanks for your help.

Kalman · 04/17/07, 2:04 PM

Thanks to the efforts of Maklar there's an Excel version of the sheet with functioning gear dropdowns.

http://www.radiationnow.net/wow/beta/mage_dps_gear.xls

Leto · 04/17/07, 2:50 PM

Good stuff... could you add Seal of the Exorcist in the next push?

Vontre · 04/17/07, 4:18 PM

Yeah, we're going to be working on a somewhat major upgrade that will include a new features, most notably the gear selector, we'll be refining it and working it into the main sheet more elegantly and such. It will also be updated for patch 2.1 with all the talent/consumable changes and such.

This might take about a week's time or so.