Vontre's Mage DPS Spreadsheet - Page 21

Krystaal · 03/31/08, 5:03 PM

Originally Posted by hypetech

Alright I put the 2.4 gear in the spreadsheet following the standard of the existing items, but the Gear Selector is showing N/A on all the stats, so I'll let you work your excel magic on that. Should be a lot easier now that the gear data is there though :-\

Mage DPS spreadsheet with 2.4 gear added (Gear selector not working)

I found where all the N/A errors were coming from, when you renamed the +8 hit gem you didn't change the gems in the gear selector sheet (i.e. all the gems that weren't showing) those were causing your N/A errors.

Also, the wand section is showing the wrong socket color for the bonus. If you change (on the Gear sheet) Z96 to =AP95 and G54 to =IF(VALUE(MID(TEXT(Z96,"0000"),1,1))=1,"red",IF(VALUE(MID(TEXT(Z96,"0000"),1,1))=2,"b lue",IF(VALUE(MID(TEXT(Z96,"0000"),1,1))=3,"yellow","")))
it fixes the issue and shows the proper socket color.

hypetech · 03/31/08, 5:08 PM

Bah I didn't even mean to include that change, I was just testing the rename for my personal spreadsheet

Looks like even if I change the gem sheet back to it's original state it still has all N/A. I fail.

Krystaal · 03/31/08, 5:10 PM

well, it's probably best it's in there now, easier to figure out anyways.

Krystaal · 03/31/08, 5:33 PM

Originally Posted by hypetech

Bah I didn't even mean to include that change, I was just testing the rename for my personal spreadsheet

Looks like even if I change the gem sheet back to it's original state it still has all N/A. I fail.

Try changing the gems in the Gear sheet, all of them, including the ones that aren't showing atm. that should fix it.

this is my fixed version
RapidShare: 1-Click Webhosting

Vontre · 03/31/08, 6:02 PM

I'm going to go ahead and release the gear list template. It contains slots for up to 50 items per equipment slot, as well as gems and enchants. It should be self-explanatory enough for anyone to use it (I hope). Post any questions here. If anyone wants to fill in with a nice list of items I'd be grateful. I'll be posting spreadsheet 3.0 before too long, I want to have some gear templated first.

http://www.magegraf.com/gear.xls

hypetech · 03/31/08, 6:14 PM

I already have a dedicated spreadsheet for 2.4 gear, so I'll start adding that in.

Docjowles · 03/31/08, 8:01 PM

Any chance you could add [Scryer's Bloodgem] to the available trinkets on Magegraf? It's not the world's most fabulous trinket but it's nice for getting yourself hit capped.

Edit: I also noticed something odd under Effect Timing...it seems like it has me using a destruction pot right at the start of the fight, and then a mana potion 15 seconds later, which is impossible. Am I just misunderstanding the output? http://www.magegraf.com/index.php?ha...8b3194a7407005

Vontre · 04/01/08, 1:39 PM

Beta version of spreadsheet 3.0 is up! You can find it here.

http://www.magegraf.com/vontre's_mage_dps.zip

Cherise · 04/01/08, 4:12 PM

"P.S. This spreadsheet is an April Fool's joke. Don't use it."

Oh darnit, you got me. Good one, haha.

hypetech · 04/01/08, 5:58 PM

Alright here's the 2.4 Gear in your template mode. Wasn't sure if [Ember Skyfire Diamond] would fit in the normal gem section, so I left it out. Also, I only added the static stats for the new trinkets but it looks like that's how the old ones are in there anyhow.

Intoxify · 04/02/08, 10:08 AM

Any chance of getting [Shattered Sun Pendant of Acumen] added to the DB?

hypetech · 04/02/08, 12:54 PM

Originally Posted by Intoxify

Any chance of getting [Shattered Sun Pendant of Acumen] added to the DB?

Added to my spreadsheet. The effect of course will have to be modeled elsewhere with Vontre's magic.

Sguz · 04/07/08, 6:59 AM

Hi Vontre

Can you please implent Nightfall Proc on the mob?
And how do you calculate the haste of the drums - always on or 1person who uses it on CD?
Greets

sguz

Vontre · 04/07/08, 2:14 PM

Hey so here's the actual beta for spreadsheet 3.0

http://www.magegraf.com/vontre's_mage_dps.zip

Vontre · 04/07/08, 6:38 PM

Major update to magegraf.com was just posted. I added fire warlock support, fixed a stacking timer issues, and reworked the database code to be MUCH MUCH FASTER.

www.magegraf.com

Akuman · 04/07/08, 9:57 PM

Vontre, the gear selector sheet's calculation for dps is incorrect.

It incorporates the talent changes in the main sheet, but for some reason it's showing arcane to still be on top. Something with the calculations assuming arcane potency or something not really sure though.

Or is this simply a continuation of the April Fool's joke

The hyperlink back to the mage dps spreadsheet from the gear spreadsheet tries to open mage dps lite.xls rather than mage dps beta.xls

hypetech · 04/07/08, 11:09 PM

Magegraf is only showing me with 108 spell haste when I do my import when I actually have 110.

Alvira · 04/08/08, 6:36 AM

Hi Vontre,

Just looked at it again. The logic for arcane spells usage has some issues.

It seems that the program will automatically fit in some low mana efficiency rotation like spamming frostbolts in the last 1 minute or so of the boss fight irrespective of whether it has the mana to continue spamming arcane blast for the whole battle.

I discovered this when I tweaked the length of the boss fight. Theoratically, a short boss fight of 2 minutes will allow arcane specs to spam AB the entire fight (hence the highest possible DPS). Yet, when I check the results and mana usage, even with plenty of mana left at that point, arcane specs will lapse into a mana efficient mode.

So, this creates a wierd situation where arcane DPS in the summary will go down as you decrease the length of the boss fight, which seems intuitively wrong.

Samuraiboy · 04/08/08, 11:55 AM

In the Spreadsheet, the Average spell damage given by spell damage trinkets(Like Icon of the Silver Crescent and Xiri's gift.) is based on the following formula:
((Duration of Buff)/(Cooldown)+(Duration of Buff)/(Time of Boss Fight))*(Spell damage given by buff)
I understand the (Duration of Buff)/(Cooldown) part (although it should be (Duration of Buff)/(Cooldown+Duration of Buff). However, I do not understand the (Duration of Buff)/(Time of Boss Fight) part of the equation. This means that at very low length boss fights, the spell damage, and thus the DPS spikes. Because DPS should be independent of length of boss fight (barring OOM), this is a problem. I was just wondering if Vontre, or any one else who understands this could explain it to me. Thank you!

RoboStac · 04/08/08, 12:05 PM

Originally Posted by Samuraiboy

In the Spreadsheet, the Average spell damage given by spell damage trinkets(Like Icon of the Silver Crescent and Xiri's gift.) is based on the following formula:
((Duration of Buff)/(Cooldown)+(Duration of Buff)/(Time of Boss Fight))*(Spell damage given by buff)
I understand the (Duration of Buff)/(Cooldown) part (although it should be (Duration of Buff)/(Cooldown+Duration of Buff).

Trinket buffs start cooldown instantly on cast, so the duration is included in the cooldown, so it's correct as it is.

Originally Posted by Samuraiboy

However, I do not understand the (Duration of Buff)/(Time of Boss Fight) part of the equation. This means that at very low length boss fights, the spell damage, and thus the DPS spikes. Because DPS should be independent of length of boss fight (barring OOM), this is a problem. I was just wondering if Vontre, or any one else who understands this could explain it to me. Thank you!

If your using a trinket which is up for 30 seconds and then on cooldown for 90seconds, having a bossfight of 30seconds will be better DPS than 60seconds as the trinket will be in use for 100% of the boss fight instead of 50%. DPS is only independent of fight length if nothing changes that would affect your damage. Attacking 30% faster, or with 200 extra damage increases your dps for the duration of the buff.

Vontre · 04/08/08, 1:56 PM

Originally Posted by Samuraiboy

Because DPS should be independent of length of boss fight (barring OOM), this is a problem.

Your assumption is very much wrong.

Raencloud · 04/08/08, 2:34 PM

The simulator is still popping destro potions and mana potions like they are not sharing a cooldown as well as flame caps and mana gems. I can work around this for destro pots by disabling mana potions completely (or vice versa), however there isn't an option I can find to disable mana gems that I could find. I've noticed it doing this for a while, but I seem to remember somewhere that you knew about it and it would be fixed later, so if that's still the case then I'm sorry for posting about it again.

Samuraiboy · 04/08/08, 7:12 PM

Ok, thank you both of you, that makes more sense. However, I think that the way that its done is not the right way to do it mathematically. I'm working on a formula now that will give a better estimate of trinket average damage for a boss fight. I'll let you know.

Samuraiboy · 04/08/08, 7:58 PM

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.)

Joeblack · 04/09/08, 4:44 PM

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.