Vontre's Mage DPS Spreadsheet - Page 17

Keleborn · 08/30/07, 4:08 PM

I belive the armory import is not working as intended. When i upload the profile all the stats are reduced to 0 and it literally shows the armory page on the spreadsheet

Edit: I am running excel '03. Also i belive the armory domain has changed form armory.worldofwarcraft.com to wowarmory.com not sure if that could cause an issue

Balynn · 08/31/07, 11:17 AM

I've got a question about Water Elemental DPS. I apologize in advance if this has already been answered, but I did a quick search and didn't see anything.

If I manually enter 1092 spell damage (all schools), and zero frost damage, it calculates the WE at 448dps. If I swap those values (zero to all schools, 1092 frost), and leave everything else the same, it has the WE at 701dps. Finally, zeroing out both of them puts him at 228dps.

Is this a bug, or does the WE actually get more of a bonus from pure +frost dmg?

Eisenwrought · 09/01/07, 9:23 PM

Originally Posted by Keleborn

I belive the armory import is not working as intended. When i upload the profile all the stats are reduced to 0 and it literally shows the armory page on the spreadsheet

Edit: I am running excel '03. Also i belive the armory domain has changed form armory.worldofwarcraft.com to wowarmory.com not sure if that could cause an issue

I am also having this problem and I am using Excel 2007.

Selecting e19 as a cell does not bring up the proper "get external data" options

I have tried going under Connections->Properties->Definition->Edit Query which causes the address to automatically change to The Armory in the address box yet results in "The XML Page cannot be Displayed --> Cannot view xml input using style sheet. Please correct.... Access is denied error processing resource 'http://armory.worldofwarcraft.com/character-sheet.xml?r=Lightinghoof&n=Vontre..."

Clicking on GO next to the correct wowarmory link loads the proper page and gives one arrow to click on for the entire page as a table selection. Selecting the table and importing results in data being filled into cells to the right and downwards of E19 with all stats and values going to zero.

Vontre · 09/02/07, 4:21 AM

Originally Posted by Balynn

I've got a question about Water Elemental DPS. I apologize in advance if this has already been answered, but I did a quick search and didn't see anything.

If I manually enter 1092 spell damage (all schools), and zero frost damage, it calculates the WE at 448dps. If I swap those values (zero to all schools, 1092 frost), and leave everything else the same, it has the WE at 701dps. Finally, zeroing out both of them puts him at 228dps.

Is this a bug, or does the WE actually get more of a bonus from pure +frost dmg?

Must be a bug, I'll take a look at it.

Asahina · 09/04/07, 4:39 AM

This is probably me being stupid again but I'm unsure if the 5% bonus damage from 4 piece tempest is being taken into account. When wearing only 3 bits and the mantle of nimble thought, I am getting more dps than if I am wearing the tempest shoulders too. Is this right and 38 haste rating is really better than 5% fireball damage, or am I missing something?

jogjog · 09/04/07, 5:36 AM

5% on FB base dmg.... maybe

Vontre · 09/04/07, 7:23 PM

Originally Posted by Asahina

This is probably me being stupid again but I'm unsure if the 5% bonus damage from 4 piece tempest is being taken into account. When wearing only 3 bits and the mantle of nimble thought, I am getting more dps than if I am wearing the tempest shoulders too. Is this right and 38 haste rating is really better than 5% fireball damage, or am I missing something?

Ah actually there is a problem with the logic handle for this, it's giving you the set bonus at 3 pieces instead of 4. I'll have a hotfix in a few days probably (little busy here at work).

maxi · 09/07/07, 9:17 AM

Sorry if this question was answered already, but i was wondering if Arcane Power yes/no field should affect the Build Comparison Fire and Frost fields?

Tarrke · 09/10/07, 2:53 PM

Hy Vontre,

first thanks for your hard work but i was used to use an old version of your spreadsheet and just download the last version. In this one it seems that the stam bonuses of my spellstrike pants and hood obtained throught gemming are missing.

I can understand that you just decided that this stat isn't revelant when it comes to DPS and other stat calculation and if so i'd just like to know it. To me this stat is revelant as I like to upgrade bit by bit my stam in order to get some survavibility in raids.

Thanks for answer and appology if this was debated beteween the pages of this thread i've read.

Roywyn · 09/10/07, 7:08 PM

Originally Posted by Tarrke

first thanks for your hard work but i was used to use an old version of your spreadsheet and just download the last version. In this one it seems that the stam bonuses of my spellstrike pants and hood obtained throught gemming are missing.

The sheet doesn't calculate anything stamina, that's why there is no socket bonus for the spellstrike items listed.

Tarrke · 09/11/07, 3:13 AM

Thanks a lot for this piece of information Roywyn, just have now to play with it

Kalman · 09/11/07, 10:14 AM

Originally Posted by Roywyn

I downloaded what I thought was the latest version, it was 2.6.2. Guess I fail at downloading

I'll check again tomorrow, too sleepy now.

Another thing though:
I toyed around a bit with an arcane (okay, 40arc/18fire/3frost, still arcane blast rotation spec) to see how much mana/intellect benefits me. But there isn't much to see, or nothing measurable:
Your sheet checks your available mana and fishes up the rotation that does most damage while still fulfilling the mana constraint.
If I add only some mana (int/spi/mp5/whatever), nothing changes. If I add more, I'll eventually get to another rotation, making my damage leap at one point. That's kind of expected

How about adding one more easy calculation in the cycle sheet:
For any maximum sustainable rotation (like 4AB, AM, Sc), the next entry to the right is 1 AB more (5AB, AM, Sc). It is not sustainable, but a combination of those two cycles is sustainable.
It only takes one line of computation to find that you can do x% of (4AB,AM,Sc) and 100%-x% of (5AB,AM,Sc) which will leave you at 0 mana at the end.

That way, one can see damage increases even small increments of mana.

( The 2-cycle theorem states that the best damage is the use of 2 cycles. Those will most likely not be a*AB/(X for 6.5s+) and (a+1)*AB/(X for 6.5s+), but a*AB/X and a*AB/Y, so what we get is not exactly the optimum thing. But still, what we would calculate is closer to the maximum output since we manage to burn some excess mana. )

There's an additional point to be made here: any cycle >3AB is equivalent to a 3AB cycle plus a certain amount of AB spam (this is ignoring time-restricted effects like Bloodlust or trinkets, or averaging them across the board). So the 2-cycle theorem in this case is actually telling us that our low-burn is a 3AB rotation and our high burn is AB spam to empty the remaining mana pool.

It's the same idea, but may be easier to implement.

(Simple proof of this point: All ABs >3 have the same time/mana cost. AB spam has this time/mana cost per AB as well. Thus, all ABs >3 are time-invariant with respect to damage/mana. So we can relocate them in time into a blast spam section without changing our mana constraint or our damage goal.)

Vontre · 09/11/07, 11:55 AM

Originally Posted by Tarrke

Hy Vontre,

first thanks for your hard work but i was used to use an old version of your spreadsheet and just download the last version. In this one it seems that the stam bonuses of my spellstrike pants and hood obtained throught gemming are missing.

I can understand that you just decided that this stat isn't revelant when it comes to DPS and other stat calculation and if so i'd just like to know it. To me this stat is revelant as I like to upgrade bit by bit my stam in order to get some survavibility in raids.

Thanks for answer and appology if this was debated beteween the pages of this thread i've read.

Me too actually, I definitely consider stamina an important pve stat to maintain, but the spreadsheet in particular is only designed to calculate dps.

In regards to the 2-cycles, I certainly plan on visiting this in the future but it is unlikely it will be part of the spreadsheet. I'm working on a replacement theorycrafting simulator which will run free on a website, in order to expand my options. Some of you may have noticed my calculations are getting a little too big for Excel (and my armory import doesn't work =p).

No ETA right now, it'll take some time to redo stuff in php. It'll be ready when it's ready.

Vontre · 09/12/07, 3:34 PM

I threw up a new version of the spreadsheet, this has some accumulated minor fixes, and a new "bloodlust uptime" option that I should've included a long time ago. One bloodlust in a 5 minute fight would be 15% uptime. That's pretty much it.

manly · 09/13/07, 11:12 PM

I'm surprised you put a bloodlust uptime. I would rather have had assumed you would select the number of recieved bloodlust (1, 2, 3, etc.) and then count that in relation with boss kill time to know bloodlust_time%. I think it is 'safe' to assume we always get a full duration out of bloodlust. But then again I am picky on detail :P