Warlock Spreadsheet (3.3.5)
Posted 20 January 2010 - 07:45 PM
If you have any formulas that would help me with these things, it would be much appreciated.
Posted 20 January 2010 - 08:36 PM
(Also, your sum is wrong--you need to include the binomial coefficent 6Cn. And multiply by the number of procs n in each case. The correct sum is:
, which equals 0.72)
Posted 20 January 2010 - 10:07 PM
Simplified outlook to start: all cast time is spent on either Shadow Bolt or Incinerate.
At any given moment, Molten Core will be up if it has procced within the amount of time it takes to cast 3 Incinerates. Given a bit of reaction time, etc., let's say that there always 2 Corruption ticks in the time it takes to chaincast 3 Incinerates. In other words, if at time T, one of your last two Corruption ticks has procced MC, you'll still be casting Incinerate. Otherwise, you'll be casting SB (since two Corruption ticks is the time it takes to use up your 3 MC charges).
One of your two Corruption ticks will have procced MC with probability (1-0.88^2)= 22.6%. So a good first-order estimate is that you'll be casting Incinerate 22.6% of the time, and Shadow Bolt the rest of the time. Curiously, this is constant with respect to haste, which may be counterintuitive at first but makes sense when you think about it.
Note that 22.6 is very close to Mahida's above empirical estimate of 27%*82%.
The big wrench in the works is all the execution time spent on things other then Incinerate or SB (including Corruption itself). I think the best way to deal with this is to average in the cast time spent on anything other than nukes in the form of added Corruption ticks (since, from the perspective of the Immolate/SB question, the time spent casting other stuff only matters insofar as it provides extra time during which Corruption may have ticked). Essentially if you spend a fraction X of your time casting things other than SB/Incinerate, perform the same computation I did above, but imagine that Corruption ticks 1/(1-X) times more quickly.
So, above, I assumed that the ratio of Incinerate cast time to Corruption tick time (call this R) is 2/3. Here let's start with the real value of R=C/3 (where C is the pre-haste cast time of a buffed Incinerate, 25/13). And, using the approximation from the last paragraph, we'll instead model the ratio as R=C/(3*(1-X)).
Now basically repeat what I did in the top half of the post. Since Corruption will tick R times during one Incinerate cast, it will tick 3R times during 3 Incinerate casts. So, at any time, you'll find yourself casting Incinerate instead of SB if any of the last 3R Corruption ticks have procced MC. This leads to a time spent casting Incinerate (as a fraction of total time spent casting nukes) of:
, where C = 25/13 (pre-haste cast time of Incinerate).
Posted 21 January 2010 - 12:07 AM
However, when I try loading my character from the armory into the spreadsheet it says:
" 48667 is not a supported Back please use Custom Gear for it "
Why is this error message being displayed (maybe I just don't understand what it's asking me to do) and how do I fix it?
Posted 21 January 2010 - 12:17 AM
Posted 21 January 2010 - 12:30 AM
Base damage range for normal Nibelung is 1591-1785. It's affected by level-based partial resists, and by caster debuffs on the target (Earth and Moon, Imp. Scorch, Totem of Wrath). 50% crit bonus, 0% base crit rate, 0% miss. Casts on average 17 Smites per proc if it stays still. 1% proc rate, but a bunch of weird talents and things proc it; you'll have to experiment some yourself.
Posted 21 January 2010 - 07:04 AM
My main concern is I'm getting a ton of #N/A errors in cells where there's supposed to be DPS/Damage numbers. Anyone else having this issue?
Here's a picture of the spreadsheet after I import my armory to avoid confusion:
Posted 21 January 2010 - 07:51 AM
Posted 21 January 2010 - 08:15 AM
Posted 21 January 2010 - 04:55 PM
You're getting those errors because you have 2 items that aren't in the spreadsheet's database. Also ran into a bunch of bugs with loading a character...Ill try and fix all this by tomorrow.
That's what I figured - just wanted to report in case it was something else.
The two items for me were: Bindings of Dark Essence - wrists from ToC 25 and the Icehowl Cinch from ToGC 10.
Posted 21 January 2010 - 08:32 PM
Firstly, I'd like to compliment you on the great changes visually and in terms of organization. They were long overdue in my opinion.
There are a few things I need some clarification on though just so I can give proper feedback on if the models are functioning correctly:
1) In the T10 4pc bonus, where does the ^3.3 come from in the calculation? Is this somehow representing the proc chance on the 5 UA or Immo ticks without detailing the math behind it?
As I understand it, this would assume the proc downtime after 3.3 ticks/chances, which is obviously won't always be the case:
Chance to not proc = .85
Therefore, taking an excerpt from the formula (1-(1-.15)^3.3), after 3.3 chances to proc:
.85^3.3 = .58 chance to have not procced still. ** I might add that the "1-.15" is a bit superfluous when you can do that one in your head, lol**
I'm just confused about this assumption. In a case of bad RNG, you could theoretically go an entire fight without the proc occuring- it's just very unlikely; specifically it's y = .85^x with y approaching 0 as X approaches infinity. In other words, the chance of such a bad RNG string happening go exponentially down closer to zero but never reaches it (a limit function).
2) For the Dislodged Foreign Object proc, what is the 2.5 multiplier at the end representing? As far as I can tell, nothing in the formula accounts for the proc chance (10%) unless that does somehow. Using the Sundial of the Exile- a trinket already in the spreadsheet with a similar proc- as an example, shouldn't it look something like this instead?:
I suppose you could also include the IfErrorWDS() function like so:
Basically, this same approach can be taken for similar trinkets as well. Not sure yet about Phylactery though because it's only periodic damage and that will change greatly with the Quick Decay glyph I imagine.
If I think of anything else, I'll let you know.
Posted 22 January 2010 - 01:04 AM
2) The Models!B27 is your average cast time, the 2.5 represents 40% proc rate, which some say it is. I've also seen 10%, but from what I've seen, it procs every 50s or so which seems more like 40% to me.
Posted 22 January 2010 - 09:49 AM
Some of my items are *ahem* lower than what you may add, namely my OH which is from naxx. When I add custom gear, I am still getting the "N/A" errors, which mean nothing is computing correctly. My attempts at adding custom gear/tweaking have no resolved this.
Meanwhile, +rep for an excellent spreadsheet. Looking very much forward to the final version for 3.3.
Posted 22 January 2010 - 04:09 PM
Syphilisia - We're working on getting all of the items added in.
Posted 22 January 2010 - 05:50 PM
Posted 24 January 2010 - 08:05 AM
Posted 25 January 2010 - 04:40 AM
ItemID 49307 is not implemented, asked to be reported.
Because of this I'm unable to calculate for total dps etc, something similar to screenshot above.
Cheers and thanks for the hard work
Posted 26 January 2010 - 04:16 AM
Posted 26 January 2010 - 08:31 AM
AN INFECTION HAS BEEN DISCOVERED!
Scan type: Auto-Protect Scan
Event: Risk Found!
Security risk detected: W97M.Cooldown
Action: Pending Side Effects Analysis : Access denied
Date: 26. januar 2010 09:00:15
This is listed as an alias of MSWord.Cooldown on Kaspersky, and is rated as a severe threat from Micrrosoft.
Posted 26 January 2010 - 02:48 PM
Systemerror &H80072EFD (-2147012867)
anyone got a idea how to fix this
1 user(s) are reading this topic
0 members, 1 guests, 0 anonymous users