Since we put Patch on farm status, I've moved down to Superior/Combat Mana Pots and Demonic Runes (very easily farmed)-- these, combined with BoW/JoW keep my mana bar afloat, easily.

Thanks for the Spreadsheet btw, Lactose. :)

Just did patchwerk last night, 6:21 kill, as alliance with Ash. JoW was up the entire fight, and I used two runes, two mana pots. one mana oil(one chage left, and I do DW =/ ), no mageblood, no nightfin (I used squid instead). I ended the kill with mana to spare. I have about 4900 mana buffed, for what its worth.

This was with a normal cycle as well. I do have 5/5 for 10% less mana cost on shots. I guess one thing that people can forget is to pop your pot or rune as soon as it would fill you to full, to get your cooldowns going.

WTB paladins.

Ahhh, the SCT +40 mana +59 mana spam :P

If JoW is up the entire time, and you aren't doing something stupid (like spamming serpent sting) you don't need anything more than major mana pots to not go OOM.

Hell, our last kill I only used 1 major mana pot, and I still didn't have any mana issues. The fight didn't even last long enough for me to get my second rapid fire off, but going to 7 minutes isn't going to drastically change anything if you're using the first pot as soon as you're short 2250 mana.

10% less...

on...

Are you using Arcane Shot...?

yea, effiecency. must have had a mental blip and left out the word.

Ah, yeah for some reason 5/5 Strikers popped into my head instead of 5/5 Efficiency~ I very often take Efficiency for granted. I did some work for mana stability for Patchwerk and got called on my shot cost numbers by one of our hunters since he's PvP spec'd (5/5 Imp. Conc.). Oops~ :D

I would spec a mix of effiency and conc even for pvp =/ I always run dry for mana long before getting a free refill from dying.

You could do what healers do and grab muse/old spirit vs. int and just find out how much time you spend under the 5SR empirically. Patchwerk is long enough that you should be able to get a fairly accurate number.

Lovely, an update :). I've been trying variations on the old download link to check if you've been sneakily updating it for a while :)

Would it be hard for you to print out values for Buffed RAP and Buffed Crit as well? Just to satisfy my curosity whether I've got everything filled in right and the spreadsheet values agree with my screenshotted character sheet values (aside from Hunter's Mark of course)?

PvP gloves noted, will see when I find the time to add it.
Post buff stats: Check cells B/C 145-148

hmm. either I'm misunderstanding something, or the buffed stats aren't quite right (probably Bok).

Here's a screenshot of me buffed a while back - note my melee crit rate is visible in the top centre:



624 agi, 1650 RAP with AotH VII and TSA, and 23.79% melee crit (28.79 ranged).

Here's a CT profile with the unbuffed stats for that particular set of gear: http://ctprofiles.net/3323732

526 agi, 1234 RAP unbuffed and 19.90% melee crit (24.9 ranged).

Here's a screenshot of the spreadsheet, with buffs enabled:



I'm not sure what the values in cells B145:C148 represent, but they seem similar to the AGI RAP Crit values, but slightly off:

571 agi, 1544.2 RAP 27.75 ranged crit

Note that in cell B7 I entered my unbuffed RAP + AotH, since the comment only said to leave off TSA.

Am I misunderstanding something about the values I'm supposed to fill in?

edit: I looked at the formulae you're using, I think you're not applying the BoK modifier to base agi, only to buff agi >.>. So B145 should be:
and C145 should be:
And the Buffed RAP and Crit calculations need corresponding adjustments.

Should be fixed now. Care to test? =)
Changed cell B/C 141.

Edit: Other than that, how are people liking it? Lots of views, not so many comments :P

can you do the kiss of the spider vs slayer's crest math with full CS/slavemaker/etc ? :-P

trying to figure out if i should steal the next kiss or hold out for the crest :)

http://ctprofiles.net/160297
Would using that gear be fine? (Swap other trinket to..?)
Guessing you mean having 1 equipped all the time, using when possible and figuring out the average damage gains?

I just do the same cycle calculations, adding 1% crit, 1 agility (converted to RAP and crit based on buffs and talents), and 1 RAP. Then I get the damage gained from this compared to the standard cycles, and compare them each other.
I guess I should explain it like...
Adding 1% crit would give the same damage boost per cycle as adding X agi or Y RAP.

yeah, i generally mean using 1 all the time with DFT. both of them may be possible eventually, but one or other for the time being :)

ah, thanks. Your values certainly seem correct since plugging in the +RAP gives the same final DPS as plugging in +1% crit. Still brainfarting on where I went wrong in balancing my own equation :(

This spreadsheet has been incredibly useful to me, but there is one minor feature that I would like to see added...

Could you possibly add a +4% damage to multi-shot bonus (available on the "new" rare and epic PvP set gloves)? I realize that messing with the value for the Giantstalker bonus would have the same effect, but I'm having trouble finding/editing the formulae to reflect that change properly.

Thanks in advance!

Fayrn, he's already working on getting the PvP glove bonus worked in.

Hm, the way i calculate the pvp gloves is pretty simple. Since you can not get 8 pc GS and pvp glove at the same time, you can just change the GS bonus to .04. But it is possible that the bonuses are calculated differently... I'm no math expert :*(