Elitist Jerks
Register
Blogs
Forums


Go Back   Elitist Jerks » Class Mechanics » Warlocks

Closed Thread
 
LinkBack Thread Tools
Old 01/21/10, 3:32 PM   #31
Dalmasca
Glass Joe
 
Gnome Warlock
 
Duskwood
Since I was in the process of updating my own copy of the sheet the other day, I'll share with you some of my thoughts.

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?:

=577.5*(20/(45+Models!$B$27/.10))

I suppose you could also include the IfErrorWDS() function like so:

=577.5*(20/(45+IfErrorWDS(Models!$B$27,0)/.10))


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.

Offline
Old 01/21/10, 8:04 PM   #32
Mupki
Glass Joe
 
Orc Warlock
 
Mal'Ganis
1) The 3.3 is how many immolate/ua ticks happen in the duration of 10 seconds. Unless I'm doing it wrong, I was using uptime formula as 1-(1-proc chance)^(duration of buff/frequency of the spell that procs it). I think that's what it is anyways. If that's wrong, any help would be appreciated.
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.

Offline
Old 01/22/10, 4:49 AM   #33
Syphilisia
Glass Joe
 
Undead Warlock
 
Frostmourne
Can I ask the correct way to add custom gear?

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.

Offline
Old 01/22/10, 11:09 AM   #34
Cerula
Von Kaiser
 
Tauren Warrior
 
Mal'Ganis
Tilly64 - This spreadsheet uses a lot of features from Excel and some macro functions from 2007. It cannot be ported to anything else

Syphilisia - We're working on getting all of the items added in.

Offline
Old 01/22/10, 12:50 PM   #35
Cerula
Von Kaiser
 
Tauren Warrior
 
Mal'Ganis
Released a new version. If you downloaded the previous version just overwrite it with this one. Check the main page for the changelog.

Offline
Old 01/24/10, 3:05 AM   #36
rockaround
Glass Joe
 
Human Warlock
 
Warsong
I got two item IDs not implemented errors :

ID 47663
ID 49187

Offline
Old 01/24/10, 11:40 PM   #37
Furyio
Glass Joe
 
Human Warlock
 
Outland (EU)
Dont know if you wanted the bugs reported here or some email, but i had this open so Ill do here


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

Last edited by Furyio : 01/24/10 at 11:54 PM.

Offline
Old 01/25/10, 11:16 PM   #38
Cerula
Von Kaiser
 
Tauren Warrior
 
Mal'Ganis
New version released. Check the initial post for the changes.

Offline
Old 01/26/10, 3:31 AM   #39
Datalord
Glass Joe
 
Undead Warlock
 
Runetotem (EU)
I hate to spread panic, but my Symantech Antivirus immeditely quaranteened and alerted me when I enabled the macros in the spreadsheet

AN INFECTION HAS BEEN DISCOVERED!

Scan type: Auto-Protect Scan
Event: Risk Found!
Security risk detected: W97M.Cooldown
File: (hidden)\AppData\Roaming\Microsoft\Excel\~ar2CB4.xar
Location: (hidden)\AppData\Roaming\Microsoft\Excel
Computer: (hidden)
User: (hidden)
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.

Offline
Old 01/26/10, 9:48 AM   #40
LemmiLemming
Glass Joe
 
Gnome Warlock
 
Ambossar (EU)
Im trying to get it to work for several hours now ... got everything enabled etc. but always get the error when i click on the "Load Character from the Armory" button:

Systemerror &H80072EFD (-2147012867)

anyone got a idea how to fix this

Offline
Old 01/26/10, 1:21 PM   #41
Cerula
Von Kaiser
 
Tauren Warrior
 
Mal'Ganis
Datalord - Well if you look at the warnings that Excel gives you, macros are not safe to use. Macros should only be used on spreadsheets that you trust. Essentially, running a macro can result in someone taking over your computer.

Lemmi - If you could give me the character name and realm that you're trying to load that would be helpful.

Some more items were reported and I added those, tried to fix the bug that Lemmi was having too. Check the initial post for more details.

Offline
Old 01/26/10, 7:15 PM   #42
Syphilisia
Glass Joe
 
Undead Warlock
 
Frostmourne
Item id 48722 is not implemented and is being reported per request ^^

Edit:

Just to test things out, I selected a similar item from the drop-down menu to replace the N/A item. However, even after having replaced the N/A item, I continue to receive erroneous values on the Main page.

Specifically, 'Spell Power' and 'Total Crit %' in the Stats Summary are both returning '#Div/0!'. As a result of those values, obviously damage calculations are not working.

Edit #2:

Also just noticed that pDPS on the Gear_buffs sheet is returning '#####' even with all item slots correctly filled.

Last edited by Syphilisia : 01/26/10 at 7:38 PM.

Offline
Old 01/26/10, 7:25 PM   #43
Pirotess
Glass Joe
 
Blood Elf Warlock
 
Coilfang
Reporting ItemID 45618 as missing.

Offline
Old 01/26/10, 8:32 PM   #44
Cerula
Von Kaiser
 
Tauren Warrior
 
Mal'Ganis
Build 0003 released. Check the initial post for details.

Last edited by Cerula : 01/26/10 at 8:41 PM.

Offline
Old 01/26/10, 9:18 PM   #45
Syphilisia
Glass Joe
 
Undead Warlock
 
Frostmourne
Errors listed above seem fixed.

Stat profitability expressed as negatives, however, is this meant to be?

Offline
Closed Thread

Go Back   Elitist Jerks » Class Mechanics » Warlocks

Thread Tools

Similar Threads
Thread Thread Starter Forum Replies Last Post
Leulier's Warlock DPS Spreadsheet Bakka Warlocks 503 02/02/10 4:00 AM