The Roguecraft Spreadsheet - Page 7

Deepeaess · 08/07/08, 5:27 PM

Interesting, I didn't think Murder would be worth nearly as much as the proc. Thanks though.

• Vulajin · 08/07/08, 7:41 PM

Version 0.3.1 is available via the link in the first post. Changes:

- Fixed a bug where a meta gem other than "None" would provide its full effects even if there was no meta socket in the equipped helm.
- Improved the accuracy of the agility-to-crit conversion.

The exact changes were:

Cell R30 on "Gear" sheet now reads (new portion bolded): =AND(S29>=S30,T29>=T30,U29>=U30,A30="Meta")
Cell I32 on "Talents & Settings" sheet now reads: 40
Cell I33 on "Talents & Settings" sheet now reads: -0.295

That's all, feel free to just patch these changes into your 0.3.0 spreadsheet if you don't want to have to download the new one and re-enter all your settings.

Ztil · 08/12/08, 8:47 PM

Hey!
Thanks for this spreadsheet Vulajin, it's pretty damn good. Unfortunately I seem to have run into some sort of bugg with mace spec and while browsing through this thread I cant find anyone else with the same problem. Maybe I accidentaly altered or changed something I shouldn't have?

I have a mace equipped in mainhand and a sword in offhand. When altering talent points in mace specialization from 0 to 5 points it doesnt affect the dps at all. 5% increased critical strike dmg with the mace should alter the dps. Maybe not as much as fist spec but still.

drumbum · 08/13/08, 2:18 AM

It appears that Mace Specialization is not implemented at all on the spreadsheet.

• Vulajin · 08/13/08, 8:11 AM

That's a fascinating, and hilarious, omission. I'll fix it in 0.3.2.

AirH · 08/13/08, 6:41 PM

I have the Merciless swords equipped and the expertise rating doesn't seem to change when I switch from Human to any other race. It should be 26, since I have the shard and 2 pt. talents, but it shows as 21.

Aeverius · 08/13/08, 7:14 PM

Originally Posted by AirH

I have the Merciless swords equipped and the expertise rating doesn't seem to change when I switch from Human to any other race. It should be 26, since I have the shard and 2 pt. talents, but it shows as 21.

Perhaps I'm misunderstanding, but as far as I can tell the sheet works fine in this regard (I've been using the BC sheet, but the LK one doesn't look different with regard to expertise, nor should it). Switching from Human to any other race should result in a 5 expertise loss on MH/OH equipped with a sword/mace; this appears to be implemented correctly. If I set it to Human with two swords, 10 exp from talents, and no expertise on gear but Shard (worth 11 expertise), I get 26 expertise on both hands, and changing only the race will drop that to 21. Looks fine to me.

• Vulajin · 08/13/08, 7:17 PM

Originally Posted by AirH

I have the Merciless swords equipped and the expertise rating doesn't seem to change when I switch from Human to any other race. It should be 26, since I have the shard and 2 pt. talents, but it shows as 21.

The expertise bonus for humans does not apply to the display at the top of the 'DPS Calc' sheets, nor the main DPS/stat headers, it is calculated separately for each type of attack, since some use the MH and others the OH, and you could have two different weapon types equipped.

Dwardu · 08/22/08, 3:14 AM

I'm getting the extra 180 health from the Mark of The Wild buff wether its on, off, improved or not, or at least, I have 180 health more than i actually do which I can't seem to fix no matter how many times i re-check what I've entered into the sheet. Turning Mark of The Wild on and off has no effect on my health so I thought it would be this.

Athan · 08/31/08, 1:27 PM

I didn't notice this until I'd filled out my gear (in a copy)... but then I made a fresh copy and checked straight away and it's there from the start.

The 'White DPS' (Gear:C2 and D2) is coming out as 'Err:529', which I'm guessing in turn causes a load of other errors (Gear D:3-7 are '#DIV/0!'), and makes the total DPS (Gear C:8) come out as 0.00. Not very helpful.

The actual contents of Gear:C2 are "=mhdps+ohdps+wfadjdps", which looks correct. If that's referring to DPS B39:41, then know that both B39 and B40 there are also 'Err:529'.

That error seems to be what's described here. Given it appears to be an OoO bug I don't know if you can work around it.

Cyberion · 08/31/08, 10:32 PM

Just a quick thanks for your continued efforts and valuable time sink, always an excellent source for Theorycrafting.

Quick question and I may be completely blind but I am unable to find the area for Heroic Presence
Heroic Presence - Spell - World of Warcraft in the spreadsheet has this buff been included?

• Vulajin · 09/01/08, 3:20 AM

Count that among "forget to include" type stuff, I raid Horde and don't usually have to worry about Draenei. Next version will have it.

Speaking of which, I'm going to go ahead and forgo further versions of the BC sheet and simply focus on Wrath from now on. The next version will be 0.2.0, and will feature the various bug fixes from the previous couple pages as well as all the changes that have been announced thus far. Depending on how long it takes me to complete this, stuff like the talent revamp may wait until 0.2.1, but 0.2.0 will have the buff/debuff changes, new Cut to the Chase, and a lot of cycle changes. For example, the energy pooling model may well be eliminated since Find Weakness is slated to be made passive and AToL will almost certainly be outclassed by new trinkets once we hit 80.

Graivewynd · 09/02/08, 3:58 PM

This spreadsheet is awesome, but I have the Assassin's Alchemist Stone and it does not show up under the trinket menu. I realize that it is static and so could i just modify my AP to compensate for it?

Iliyan · 09/03/08, 1:59 AM

Vulajin, or anyone else, do you have any information regarding the 4pt Darkmantle set bonus? 35 energy proc off any attack...

Whats the proc rate? Any CD? I remember that it used to proc quite a lot, and whenever it did, you would surely notice such a huge energy gain..

• Vulajin · 09/03/08, 2:04 AM

Do I even want to know why you're asking about an obsolete set bonus from an obsolete set?