Elitist Jerks » Search Forums Search Results

Username Remember me? Password

Showing results 1 to 44 of 44 Search took 0 seconds. Search: Posts Made By: ZorbaTHut

Forum: Warriors 08/09/10, 2:26 AM

Replies: 49 Tanking Spreadsheet 3.3 Views: 124,693 Posted By ZorbaTHut The spreadsheet doesn't model resistances in any... The spreadsheet doesn't model resistances in any fashion, so the Sindragosa trinket on-use ability is given zero value. It ends up comparing the Sindragosa trinket's stamina against The Black...

Forum: Warriors 07/23/10, 2:53 PM

Replies: 49 Tanking Spreadsheet 3.3 Views: 124,693 Posted By ZorbaTHut Whoa hey someone resurrected the thread. I may... Whoa hey someone resurrected the thread. I may go through it and update the recent armor values, since I'm just getting back into raiding. Look for it in a few weeks at best, though, my time's been...

Forum: Authorization 07/22/10, 3:40 PM

Replies: 2 Authorization Views: 787 Posted By ZorbaTHut Authorization Requesting authorization, Noressa is sponsoring me.

Forum: Warriors 01/26/10, 11:25 PM

Replies: 49 Tanking Spreadsheet 3.3 Views: 124,693 Posted By ZorbaTHut I'm curious - where are you getting that number... I'm curious - where are you getting that number from? Damage-wise, the only thing it doesn't take into account already is bleed damage and magic school resistance. It already handles magic and...

Forum: Warriors 01/26/10, 8:35 PM

Replies: 49 Tanking Spreadsheet 3.3 Views: 124,693 Posted By ZorbaTHut Whoops, left some of the boss overrides on.... Whoops, left some of the boss overrides on. Fixed, and updated the T10 tank armor. bam (http://www.pavlovian.net/wow/wotlk_war_prot_2010_01_26b.ods)

Forum: Warriors 01/26/10, 6:05 PM

Replies: 49 Tanking Spreadsheet 3.3 Views: 124,693 Posted By ZorbaTHut Every bug reported above should now be fixed,... Every bug reported above should now be fixed, especially the 100%-avoidance bug. Thanks for the reports, everyone! I also tracked down and fixed a few small issues with threat calculations, so it...

Forum: Warriors 12/27/09, 5:43 AM

Replies: 49 Tanking Spreadsheet 3.3 Views: 124,693 Posted By ZorbaTHut Fixed... Fixed (http://www.pavlovian.net/wow/wotlk_war_prot_2009_12_27.ods). Thanks!

Forum: Warriors 12/20/09, 5:48 PM

Replies: 49 Tanking Spreadsheet 3.3 Views: 124,693 Posted By ZorbaTHut Dang that's a nice chest. Both those issues will... Dang that's a nice chest. Both those issues will be fixed in the next version. Also, if anyone still gets N/A errors with the 12/20 version, let me know, because they should be fixed.

Forum: Warriors 12/20/09, 12:11 PM

Replies: 49 Tanking Spreadsheet 3.3 Views: 124,693 Posted By ZorbaTHut Whoops. I implemented it in terms of the Essence... Whoops. I implemented it in terms of the Essence of Gossamer proc because that seemed closest. Looking at it again, yeah, that's not even remotely what it does. Hard to figure out a sensible way to...

Forum: Warriors 12/15/09, 11:06 PM

Replies: 49 Tanking Spreadsheet 3.3 Views: 124,693 Posted By ZorbaTHut Unless someone else wants to maintain one, no -... Unless someone else wants to maintain one, no - I'm not getting paid enough to fight with Excel ;) As mentioned, OO is free, use OO. Oops, forgot about this bug. Yeah, as mentioned, it's the...

Forum: Warriors 12/15/09, 8:07 AM

Replies: 49 Tanking Spreadsheet 3.3 Views: 124,693 Posted By ZorbaTHut Curious, I think they reduced the emblem prices... Curious, I think they reduced the emblem prices in 3.3. Got that fixed in my local version. I'm not going to make a push yet, I'll see if there's other issues. Thanks :)

Forum: Warriors 12/14/09, 11:14 PM

Replies: 340 Tanking Spreadsheet Views: 287,509 Posted By ZorbaTHut New version, new thread... New version, new thread (http://elitistjerks.com/f81/t84604-tanking_spreadsheet_3_3_a/). Let's let this one die so I can update the OP in the new one.

Forum: Warriors 12/14/09, 11:14 PM

Replies: 49 Tanking Spreadsheet 3.3 Views: 124,693 Posted By ZorbaTHut Tanking Spreadsheet 3.3 Here's a new thread for a new maintainer so I can edit the OP. Old thread is here (http://elitistjerks.com/f81/t36981-tanking_spreadsheet/). Current version (updated 1/26)...

Forum: Warriors 12/12/09, 1:19 AM

Replies: 340 Tanking Spreadsheet Views: 287,509 Posted By ZorbaTHut Okay, here we have it. 3.3-Compatible Sheet... Okay, here we have it. 3.3-Compatible Sheet (http://www.pavlovian.net/wow/wotlk_war_prot_2009_12_11.ods) No 3.3 equipment is currently included. I don't have any real numbers for bosses, so I made...

Forum: Warriors 12/12/09, 12:58 AM

Replies: 340 Tanking Spreadsheet Views: 287,509 Posted By ZorbaTHut I love you forever. :D I've actually been... I love you forever. :D I've actually been procrastinating on this just because I don't want to do the data entry - I've got a version with the dodge debuff included already, I just don't have the...

Forum: Warriors 11/17/09, 4:07 AM

Replies: 340 Tanking Spreadsheet Views: 287,509 Posted By ZorbaTHut I actually don't think it's anywhere near as bad... I actually don't think it's anywhere near as bad as you think. Yes, technically the possibilities are exponential, but back in reality, there isn't a single case where the Saronite Defender is going...

Forum: Warriors 11/04/09, 4:28 PM

Replies: 340 Tanking Spreadsheet Views: 287,509 Posted By ZorbaTHut I think it's not entirely clear that this is a... I think it's not entirely clear that this is a thing that actually happens, though. Boss attacks include a reasonably large random factor, the various "multiple attacks" hit at unpredictable...

Forum: Warriors 10/31/09, 11:06 PM

Replies: 340 Tanking Spreadsheet Views: 287,509 Posted By ZorbaTHut I'm actually not sure what you're looking at... I'm actually not sure what you're looking at there. Are you sure you've got the latest version (http://www.pavlovian.net/wow/wotlk_war_prot_2009_10_22.ods)? The worst-case blocks/min is simply set to...

Forum: Warriors 10/28/09, 1:47 AM

Replies: 340 Tanking Spreadsheet Views: 287,509 Posted By ZorbaTHut Not that I know of. I'd like to fix it, but I've... Not that I know of. I'd like to fix it, but I've got a lot of other stuff on my plate, and I don't have time to work on this often - I've been spending the time making the spreadsheet better,...

Forum: Warriors 10/27/09, 4:28 AM

Replies: 340 Tanking Spreadsheet Views: 287,509 Posted By ZorbaTHut Well, apparently it's a problem, because like... Well, apparently it's a problem, because like three people have reported it as a bug :D Personally, when I'm rigging up my gear, I usually do it by just typing the name. I can remember...

Forum: Warriors 10/26/09, 5:46 AM

Replies: 340 Tanking Spreadsheet Views: 287,509 Posted By ZorbaTHut That's exactly what I'm doing, but the problem is... That's exactly what I'm doing, but the problem is that the dropdowns in the equip list. When you drop down, it cleverly grabs the text of the source cell . . . not the equation . . . so it ends up...

Forum: Warriors 10/24/09, 3:26 AM

Replies: 340 Tanking Spreadsheet Views: 287,509 Posted By ZorbaTHut Yeah, but this makes it harder to use. You're... Yeah, but this makes it harder to use. You're either penalizing horde or alliance users by requiring them to know the name of the alternative for text search purposes. Think I've come up with a...

Forum: Warriors 10/22/09, 7:49 PM

Replies: 340 Tanking Spreadsheet Views: 287,509 Posted By ZorbaTHut The problem is that some of the "default... The problem is that some of the "default equipment" is Alliance-specific. If you go and set your equipment to be your equipment, it'll work fine. I'm not quite sure how to fix this in an elegant...

Forum: Warriors 10/22/09, 12:54 AM

Replies: 340 Tanking Spreadsheet Views: 287,509 Posted By ZorbaTHut Alright here have a totally experimental... Alright here have a totally experimental spreadsheet (http://www.pavlovian.net/wow/wotlk_war_prot_2009_10_22.ods). There may be bugs, but I've tested it a bit. It now supports a more objective "score...

Forum: Warriors 10/21/09, 5:51 PM

Replies: 340 Tanking Spreadsheet Views: 287,509 Posted By ZorbaTHut The Sanct bonus doesn't stack with Kings. If... The Sanct bonus doesn't stack with Kings. If you've got enough paladins to put Sanct on people, you absolutely have enough paladins to put Kings on people. Also, I'm pretty sure that, while the 3%...

Forum: Warriors 10/21/09, 5:44 AM

Replies: 340 Tanking Spreadsheet Views: 287,509 Posted By ZorbaTHut - Fix Titanium Plating - Add more boss numbers ... - Fix Titanium Plating - Add more boss numbers - Add a useful Custom Boss config option Download new version (http://www.pavlovian.net/wow/wotlk_war_prot_2009_10_21.ods). This will be the last...

Forum: Warriors 10/16/09, 10:35 AM

Replies: 340 Tanking Spreadsheet Views: 287,509 Posted By ZorbaTHut New version!... New version! (http://www.pavlovian.net/wow/wotlk_war_prot_2009_10_16.ods) Mostly a maintenance release. - Fix gem requirements (I hope) - Update the dodge% change in 3.2 - Opened up second gem...

Forum: Warriors 10/16/09, 10:29 AM

Replies: 340 Tanking Spreadsheet Views: 287,509 Posted By ZorbaTHut Alrighty then, I'll update the spreadsheet... Alrighty then, I'll update the spreadsheet :) fuck it, making a maintenance/bugfix release

Forum: Warriors 10/15/09, 9:45 AM

Replies: 340 Tanking Spreadsheet Views: 287,509 Posted By ZorbaTHut I am hesitant to do this before it's been proven... I am hesitant to do this before it's been proven that I'm not a slacker. If I'm still keeping it maintained in a week or two, then I'll start my own thread. I like the idea, but keep in mind that...

Forum: Warriors 10/14/09, 7:12 AM

Replies: 340 Tanking Spreadsheet Views: 287,509 Posted By ZorbaTHut This is pretty much what it already is as well ;)... This is pretty much what it already is as well ;) No dodge/parry/block, tripled crit chance. If it's not already I'm also going to get in there and triple the chance of being parried, so that parry...

Forum: Warriors 10/13/09, 3:51 PM

Replies: 340 Tanking Spreadsheet Views: 287,509 Posted By ZorbaTHut This is true, and this is clearly the problem.... This is true, and this is clearly the problem. The solution is that I want to provide some sort of Quality Point system, where a set of gear can be objectively measured and given a total quality...

Forum: Warriors 10/13/09, 4:37 AM

Replies: 340 Tanking Spreadsheet Views: 287,509 Posted By ZorbaTHut I am talking about the total AEP values, and my... I am talking about the total AEP values, and my goal is to make them interesting. Right now the only thing the spreadsheet can tell you is whether one item is better than another (and it even gets...

Forum: Warriors 10/12/09, 6:22 PM

Replies: 340 Tanking Spreadsheet Views: 287,509 Posted By ZorbaTHut Actually, I think I know what's going on there -... Actually, I think I know what's going on there - one of the first things I did was look at all the hardcoded ranges, say "oh no way, I am not going to maintain that", and rig up a horrifying system...

Forum: Warriors 10/12/09, 10:14 AM

Replies: 340 Tanking Spreadsheet Views: 287,509 Posted By ZorbaTHut New version! Get it while it's a version!... New version! Get it while it's a version! (http://www.pavlovian.net/wow/wotlk_war_prot_2009_10_12.ods) - Added craftable Crusader Orb gear - Highlighted equipped items - Added delta-EP column -...

Forum: Warriors 10/10/09, 7:13 AM

Replies: 340 Tanking Spreadsheet Views: 287,509 Posted By ZorbaTHut About two weeks I asked Talia if I could take... About two weeks I asked Talia if I could take over the spreadsheet. I was told I could! So I finally managed to squeeze out enough spare time to put some work into it. So far, I've got: * Updated...

Forum: Warriors 08/19/09, 12:57 PM

Replies: 2,923 Warrior DPS Calculation Spreadsheet Views: 3,330,356 Posted By ZorbaTHut But, as I said, he could fix this - OO has a... But, as I said, he could fix this - OO has a scripting language, and he could do the scripting in OO. Also, if he's mentioning torrents as being one of his major customer bases . . . well, OO is...

Forum: Warriors 08/19/09, 11:10 AM

Replies: 2,923 Warrior DPS Calculation Spreadsheet Views: 3,330,356 Posted By ZorbaTHut I'm pretty sure Landsoul could fix this if he... I'm pretty sure Landsoul could fix this if he really wanted to. It's not like OpenOffice has a bug that makes it impossible to calculate Warrior DPS.

Forum: Warriors 06/28/09, 3:19 PM

Replies: 2,923 Warrior DPS Calculation Spreadsheet Views: 3,330,356 Posted By ZorbaTHut I also get errors constantly, though it's usually... I also get errors constantly, though it's usually #N/A, not #DIV/0. Things that can trigger 'em: * Mistyping an item or enchant. Go to cloak enchant, type "asd", hit enter. Boom! Now go fix the...

Forum: Warriors 06/01/09, 6:00 AM

Replies: 40 Rage Generation is changed Views: 30,251 Posted By ZorbaTHut I don't really see why it should be assumed that... I don't really see why it should be assumed that any of those regressions will fit properly. I'd personally expect to see major slope discontinuities at 60 and 70. If we really wanted to get...

Forum: Warriors 05/23/09, 1:48 PM

Replies: 340 Tanking Spreadsheet Views: 287,509 Posted By ZorbaTHut But then why is Expertise's value doubled in that... But then why is Expertise's value doubled in that situation?

Forum: Warriors 05/22/09, 2:29 PM

Replies: 340 Tanking Spreadsheet Views: 287,509 Posted By ZorbaTHut Right, but then what's going on with... Right, but then what's going on with C14? =IF($Bosses.$G$13;1;(1-0.24*$Bosses.$C13*C48*(2/3+1/C58)))*$Bosses.$C13 Bosses.G13 is the parry flag. So it's saying "if the parry flag is on, then the...

Forum: Warriors 05/20/09, 12:44 AM

Replies: 340 Tanking Spreadsheet Views: 287,509 Posted By ZorbaTHut A little confused about some aspects of the... A little confused about some aspects of the spreadsheet - hopefully I can ask some questions and get them cleared up :) The "parry flag" on the bosses is a bit unclear. It seems like it's a flag...

Forum: Warriors 05/07/09, 3:54 PM

Replies: 340 Tanking Spreadsheet Views: 287,509 Posted By ZorbaTHut Yeah, I managed to figure out what the problem... Yeah, I managed to figure out what the problem was and fix it - remember, the problem ended up being "I'd chosen the wrong equipment" - I'm just saying that it'd be better if the problem didn't exist...

Forum: Warriors 05/06/09, 9:31 PM

Replies: 340 Tanking Spreadsheet Views: 287,509 Posted By ZorbaTHut Ran into a few bugs in the spreadsheet. *... Ran into a few bugs in the spreadsheet. * Reticulated Armor Glove eng enchant is missing (800 armor) * On the Gems worksheet, "Special" (L2) points at "Crit" on the gearlist worksheet. I assume it...

Showing results 1 to 44 of 44