As for chaosbolt, if you're using it in the backdraft, then it does need to be turned off on the main dps part. If you're not using it during backdraft, then you can set it to on and it's assumed you're casting it sometime in the middle.
When I did take it out of the Backdraft Rotation and set it to 'on' I noticed that setting it to 'on' scrambled all the Next Stat and gem values into negative values.
No clue. Spreadsheet could be inaccurate. Start by comparing individual spell damage values and compare what you're seeing to what is reported.
I don´t think that it is spreadsheet innacuracy. Most people tend to look at it like it always express the truth no matter what happens.
For those of you who aren´t familiar with it: Every single spreadsheet here on this forum tells you what your dps/damage will be if you play flawlessly.
This one (since is the one that matters for us) tells you how much dps you will deliver if you:
A - Set your party/raid buffs properly
B - Set your gear properly
C -Keep your dot uptimes= 100% (after considering latency and dot gap)
So if your not been able to do as much dps the spreadsheet said you would, don´t worry. Work your rotation, double check your party buffs and other settings and don´t forget the RNG.
Only then you can wonder if any of the calculations has a problem or if there´s a bug with the spell.
* Master Conjuror talent in Demonology now since it increases dps for our 'oils'
* Stats for Doomguaird now that it is becoming a viable choice to Demonic Sac and have a DG Doomguard. This would also entail a way to implement a distinction between Sacced pet (H4) and Enslaved Pet (perhaps Dropdown in A40?
As an FYI for anything demonology related. I will not ever spec or test demonolgy talents. I don't like the spec and think it does subpar dmg to aff and destro. As such if you see something wrong with demo please provide as much info as possible. Having said that...
What are the actual effects of Master Conjurer on the stones at each talent level?
What are all the raw stats for a L70 DG? What are it's skills? What are their dmg, cast times, cooldowns, etc.?
I've never had problems using the spreadsheets until the 3.0 versions. Is there something you're doing wrong?
Installed Excel and I am still seeing errors. #NAME? is everywhere and Macros are enabled which did fix some of them.
EDIT: Weird... I set haunt and SB to 0 which were the ones giving me problems then set then back to 1 and it worked I had excel set to automatically calculate and would even force it to and it would never help, I dunno how switching the values back and forth fixed it.
If you had no filler spell, then it has a great big "?" for what to do with all the remaining cast time.
EDIT: Also, selecting a non-DPS curse doesn't work, since the VLOOKUP doesn't search "exact", it will find the closest thing to CoE (for instance) and will give you a good DPS increase.
What are the actual effects of Master Conjurer on the stones at each talent level?
What are all the raw stats for a L70 DG? What are it's skills? What are their dmg, cast times, cooldowns, etc.?
Master Conjuror Rank 1
Increases the effects granted by your conjured Firestone and Spellstone by 15%.
Master Conjuror Rank 2
Increases the effects granted by your conjured Firestone and Spellstone by 30%.
They should just straightup enhance the Values for both stones in your oil_list which you are using in Gear_Buff > SelfBuffs > Oil. Should not have impact anywhere else since you apply them before combat.
I can't seem to get the spreadsheet to work correctly. all I see is #VALUE! everywhere and i choose my build under the drop down menu and click load and nothing happens.
I get that when I don't activate the macros on my excel program. Once I have, to solve the problem I put the affected spells to 0 and then to 1 again and they work fine.
Master Conjuror Rank 1
Increases the effects granted by your conjured Firestone and Spellstone by 15%.
Master Conjuror Rank 2
Increases the effects granted by your conjured Firestone and Spellstone by 30%.
They should just straightup enhance the Values for both stones in your oil_list which you are using in Gear_Buff > SelfBuffs > Oil. Should not have impact anywhere else since you apply them before combat.
Cannot yet comment on L70 DG stats.
I can read talent descriptions on a calculator. I want to what they actually do; not what they should. I saw a blizz post the other day indicating these may not be working as one would expect.
We have an issue if using CoA and Molten Core procs:
Models tab has B5 expression ...(6*24/DPS!D27)...
TNS-... tabs have b46 expression ...(4*24/$D$22)...
The version I uploaded I forgot to fix the TNS for UA, try the new version and let me know if you still see these results.
Okay, this is the best release of the Spreadsheet yet. It is consistent and correct now for me on Office 2003 SP3 Win32 and I'll try on OS X Office 2008 and Office 2007 Windows Vista later (probably tonight).
Enhancement request: Hellfire-Encased Pendant is now flat 42 spellpower with no bias towards Fire.
Issue report: Runed Spell-cuffs are disliked by the armory loader. The Hyjal rings are also not identified correctly but the notifications on both inform the user that they're not being loaded correctly.
Still trying to dig through the formulas for why, but I think TNS is still goofy. On the itemlist I am seeing one item superior to the other by a substantial margin but when equipping it, the DPS goes down.
I noticed this for the neck slot between Brooch of Nature's Mercy and Hellfire-Encased Pendant (hellfire shows top but drops DPS when equipped over the brooch).
I am trying to replicate the condition where the DPS values for Items gets into quad-digits.
It seems to happen after I'm enabling and disabling raid buffs like Blessing of Wisdom, Totems, etc.
Removing them doesn't make it go away once they show up. I'm going to try harder to get it set back to default and try to find out what it is that triggers it into bizzaro-mode.
I am trying to replicate the condition where the DPS values for Items gets into quad-digits.
It seems to happen after I'm enabling and disabling raid buffs like Blessing of Wisdom, Totems, etc.
Removing them doesn't make it go away once they show up. I'm going to try harder to get it set back to default and try to find out what it is that triggers it into bizzaro-mode.
It's more likely to be a skill you switched on or off, since those very high DPS values on the item screen come from overly high TNS numbers. That generally means one of the TNS sheets is calculating differently from the main DPS sheet.
EDIT:
Originally Posted by Trickykid
Still trying to dig through the formulas for why, but I think TNS is still goofy. On the itemlist I am seeing one item superior to the other by a substantial margin but when equipping it, the DPS goes down.
I noticed this for the neck slot between Brooch of Nature's Mercy and Hellfire-Encased Pendant (hellfire shows top but drops DPS when equipped over the brooch).
So I just tried adding one point to each of the appropriate stats and compared to the TNS version:
Hmm can't seme to get armory import to work, Using Mac excel 2k4 11.3.3 neither buttons seem to work,
Armory info is all right, Supplicium Dark Iron U.S. Unless I have to do something special with the Dark Iron.
Also A clause at the bottom of the talents page that reads:
=SUM(E2:E29+H2:H28+K2:K27) and then on the cell next to it =Sum(<previous sum cell>-9) for required level.
edit-
After loading in all My info, My Dps Is currently about 100 less then my last boss long boss fight (council last night) and about 250+ short of my last not running like a chicken boss fight (muru) from tuesday, pre immolate/corruption buff and pre 3.0.3 dmg boosts. Not sure what's going odd here
Thanks
No clue tbh. I was successfully able to retrieve your info. My guess is the code I use for retrieval is MS friendly and not mac friendly.
Originally Posted by Trickykid
It's more likely to be a skill you switched on or off, since those very high DPS values on the item screen come from overly high TNS numbers. That generally means one of the TNS sheets is calculating differently from the main DPS sheet.
EDIT:
So I just tried adding one point to each of the appropriate stats and compared to the TNS version:
At least for undervaluing haste, it appears gcd remains the same on "TNS-haste" as it does on "DPS". It should be affected. Not sure about the others.
Hrm, I've made it so TNS uses the exact same formulas as DPS. I just c/p them from DPS to TNS in the right spots nowadays. And I'm fairly certain they're all the same now. So don't know why you would see a discrepancy. How are you actually adding 1?
Also I've added gcd to each TNS now so that will be fixed in future version. Though it had very little impact.
Hrm, I've made it so TNS uses the exact same formulas as DPS. I just c/p them from DPS to TNS in the right spots nowadays. And I'm fairly certain they're all the same now. So don't know why you would see a discrepancy. How are you actually adding 1?
Also I've added gcd to each TNS now so that will be fixed in future version. Though it had very little impact.
I just c/p the stats as values, saved the DPS value and then went down the stat-list doing +1, recording the DPS, setting it back to zero and moving to the next one. I checked through the formula and they look good at first glance, so I will just mess around with it some more to see if I can track it back to anything. My guess is somehow SOME of the cells still reference another sheet's crit, haste or something like that.
The GCD fix affected a destro cycle by increasing the next stat value by almost 20%, basically I just used your GlobalCoolDdown formula wherever I saw "gcd" referenced so that it referenced the haste on that particular sheet.
--- EDIT: Okay, I think I found the remaining issues. When I fixed the gcd, TNS for shadow, crit, haste and mp5 were correct. That leaves fire, hit, int and spirit.
-Fire and Hit TNS appear not to count increases in pet DPS (as in, the main DPS tab calculates that correctly, it's just not accounted for in the TNS tabs).
-Spirit is off because life tap mana is used from the main tab instead of with +1 spirit.
-Intellect was off because I pasted the stats as values so obviously crit wasn't going to increase with +1 int. DOH!
With those changes it matches up on mine for destro at least. Demo TNS is probably more off due to the pet DPS problems.
I noticed a few inconsistencies in the spell list in terms of main DPS calculation vs TNS stat calculation which was causing some weird numbers when spells/talents were adjusted:
-The TNS values of the duration/frequency of Corruption are off compared to the DPS sheet. (I believe an incorrect link to ea_uptime on Models sheet)
-TNS damage, cast ratio and mps values for Haunt & NF/GoC reads the used/option value on that sheet, which from what I see it should now be reading it from the main DPS sheet to determine if it's being used or not in a rotation.
-TNS damage value for Conflag also needs to use the used_conflag name.
-Adjusting Dark Pact used/option to 0 causes VALUE errors (TNS values attempting to divide the string '-' I believe).
Great work as always on this! It's really helping the confusing times post-3.0 raiding.
I just c/p the stats as values, saved the DPS value and then went down the stat-list doing +1, recording the DPS, setting it back to zero and moving to the next one. I checked through the formula and they look good at first glance, so I will just mess around with it some more to see if I can track it back to anything. My guess is somehow SOME of the cells still reference another sheet's crit, haste or something like that.
The GCD fix affected a destro cycle by increasing the next stat value by almost 20%, basically I just used your GlobalCoolDdown formula wherever I saw "gcd" referenced so that it referenced the haste on that particular sheet.
--- EDIT: Okay, I think I found the remaining issues. When I fixed the gcd, TNS for shadow, crit, haste and mp5 were correct. That leaves fire, hit, int and spirit.
-Fire and Hit TNS appear not to count increases in pet DPS (as in, the main DPS tab calculates that correctly, it's just not accounted for in the TNS tabs).
-Spirit is off because life tap mana is used from the main tab instead of with +1 spirit.
-Intellect was off because I pasted the stats as values so obviously crit wasn't going to increase with +1 int. DOH!
With those changes it matches up on mine for destro at least. Demo TNS is probably more off due to the pet DPS problems.
Thanks Tricky. I've made the necessary changes to the next version.
Originally Posted by MooMan65
I noticed a few inconsistencies in the spell list in terms of main DPS calculation vs TNS stat calculation which was causing some weird numbers when spells/talents were adjusted:
-The TNS values of the duration/frequency of Corruption are off compared to the DPS sheet. (I believe an incorrect link to ea_uptime on Models sheet)
-TNS damage, cast ratio and mps values for Haunt & NF/GoC reads the used/option value on that sheet, which from what I see it should now be reading it from the main DPS sheet to determine if it's being used or not in a rotation.
-TNS damage value for Conflag also needs to use the used_conflag name.
-Adjusting Dark Pact used/option to 0 causes VALUE errors (TNS values attempting to divide the string '-' I believe).
Great work as always on this! It's really helping the confusing times post-3.0 raiding.
1. Unable to duplicate. They're all the same on my sheet.
2. Fixed
3. It's working right.
4. Unable to duplicate. Using the Haunt spec I switched back and forth multiple times with no issues.
1) I'm getting the same thing happening again on the latest version. A quickest way to reproduce it is using a fresh copy of v303c, change the EA talent to 0/5. The TNS values jump off the scale immediately. I noticed that with EA Corruption's duration is 200, without it's 21. But on the TNS sheets even with 0/5 EA Corruption's still at a 200 duration. The DPS sheet references Models!B11 in the IF statement, while the TNS stat ones reference Models!B6, which is SL's MC contribution rather than the EA figure. So if your rotation included Siphon Life, it actually screws up the Corruption TNS duration figure. If this isn't happening on your machine even with the same public file download, any ideas how the formula could be different on someone elses machine? I've not heard of this before.
3 & 4) It seems to be fixed in the latest version with the used/option in the TNS sheets now linking to the DPS!$B$36 value, but in the previous version it was hardcoded to 0 all the time. That same thing fixed the Dark Pact issue too. Before in v303b the used/option values were hardcoded to 'max' instead of linking to DPS!$B!38.
10/22/08, 12:28 PM
I had excel set to automatically calculate and would even force it to and it would never help, I dunno how switching the values back and forth fixed it.
Similar Threads
