Combat and Mutilate Spreadsheets (Obsolete as of 4.0.x) - Page 39

Joigahdenn · 05/14/09, 4:40 PM

Originally Posted by Speaker

Right now there doesn't appear to be any way to see your current stats, or the stats of items that you are equipping, which would be nice to know. Or is there a way to add/remove/edit the current items from the drop down lists? I am not an excel expert, but it would be nice to know. Thanks for all your work Aldriana.

Originally Posted by saedo

Unhide the gear sheet.

Just to clarify for those a little less experienced with dps spreadsheets or excel in general. On the gear sheet (which needs to be unhidden first as Saedo pointed out) in Cells I241-R241 give you ungemmed stats (including enchantments), and cells I324-R324 give you your stat totals (I changed my sheet a little, but I think those are the original cells). If you want to get a little more fancy, you can reference these cells somewhere on the Equipment Page (at the top where there is room for exampe) by entering the following code (for each cell): =Gear!I324 where "Gear!" will reference the gear sheet and I324 is the specific cell you are referencing (in this case strength).

• Aldriana · 05/14/09, 4:45 PM

1) I discussed the possibility of adding engineering in post 539. It will require some work, and I haven't quite figured out how to prioritize it versus other features.

2) Socketing is currently done on an item-by-item basis. It doesn't account for metagem activation, because it's only looking at one item and a time and, for that individual item, it's never optimal to put the blue gem *there*. This is also why it doesn't recommend Stormjewels or Dragon's Eyes - because it would clearly be optimal to use them *everywhere* which, of course, you can't do. Fixing this is similarly discussed in post 539.

3) Gem recommendations are made with current EP values and - subject to the caveats in point 2 - should generally be optimal unless you're using Dragon's Eyes or Stormjewels. It may occasionally be ever so marginally inferior due to nonlinearity of gear benefits, but if it's off by more then a tenth of a DPS or two, it's likely a bug - send me your sheet, and I'll take a look at it.

wyndchill · 05/14/09, 5:24 PM

Two questions:

1. How can I add a value into the calculations page for 1.3 speed weapons (would like to value the lpc). I see the columns for the various speeds, but i'm unsure as to how I can fit this in w/o causing an error.

2. How are the rank value, base value, and score in the sheet calculated? I would like to add the new version of Namlak's and the librarian paper cutter to my copy.

• Aldriana · 05/14/09, 5:37 PM

1) Short version: you can't. 1.3 speed weapons could be added, but it's not something that would be easy to explain how to do. I may or may not support this in a future version - I'm leaning towards not, because

2) LPC isn't really that interesting anymore. Each .1 speed appears to make up for about a tier of DPS difference for combat and somewhat less than that as Mutilate; hence, LPC is comparable to a 143 DPS 1.4 speed dagger or a 156 DPS 1.5 speed dagger - which just isn't that hard to get a hold of.

wyndchill · 05/14/09, 8:03 PM

Originally Posted by Aldriana

1) Short version: you can't. 1.3 speed weapons could be added, but it's not something that would be easy to explain how to do. I may or may not support this in a future version - I'm leaning towards not, because

2) LPC isn't really that interesting anymore. Each .1 speed appears to make up for about a tier of DPS difference for combat and somewhat less than that as Mutilate; hence, LPC is comparable to a 143 DPS 1.4 speed dagger or a 156 DPS 1.5 speed dagger - which just isn't that hard to get a hold of.

I hadn't understood that. Thank you for answering.

Could you still answer as to how the values, scores, etc are computed for the various weapons? I'd like to try to get a graps on the mechanics going on in that department if possible.

Shaker · 05/15/09, 2:11 AM

Poison Miss rate in Equipment H1 is calculating off Calcs B60, should be B61. B60 is Yellow Miss rate.

Looks good - fun to go back to the ol' familiar. :P

My recommendation on BS sockets would be to just add them to every piece of gear and let it be user controlled whether they're filled or not.

Wodahs · 05/15/09, 11:59 AM

Add another 2 items called Blacksmithing slot 1 and blacksmithing slot 2 and give them no stats but a gem slot. Would be an easy way to add Gems for BS Sockets, you dont necessarily need to add a socket to all gloves/bracers.

Chigga · 05/15/09, 8:05 PM

I'm a newbie at this spreadsheet stuff, but I'm currently sitting at 10 expertise (from talents with 0 from gear). The combat spreadsheet is telling me that gemming for Agi is still superior to gemming for expertise, but from what I've read, you should be trying to hit the 26 expertise cap? Can anyone clarify this? Thanks!

Joigahdenn · 05/15/09, 8:17 PM

Originally Posted by Chigga

I'm a newbie at this spreadsheet stuff, but I'm currently sitting at 10 expertise (from talents with 0 from gear). The combat spreadsheet is telling me that gemming for Agi is still superior to gemming for expertise, but from what I've read, you should be trying to hit the 26 expertise cap? Can anyone clarify this? Thanks!

From a pure DPS perspective, expertise has a lower EP than Agi. However, if you are running a mutilate spec, the actual value of expertise is a little harder to measure. If you run a tight cycle, a dodged envenom can cause slice and dice to drop off, which needs to be restarted by SnD again as opposed to just refreshing it via Cut to the Chase, which is a dps loss. So, for mutilate, if you gem for expertise you might be losing a little in terms of raw DPS potential compared to gemming Agi, however, you're giving yourself a sort of insurance. I don't have numbers to back this up, but I guessing that dropping SnD even once during a fight is more of a loss in DPS than gemming expertise to the cap (or close to it).

As combat, which you obviously are (since you have 10 expertise from talents), it matters much less since you have Surprise Attacks (finishers can't be dodged) and you're not dependent on an attack such as envenom to keep SnD running.

nonmagical · 05/15/09, 9:45 PM

I just realized you updated the layout of your spreadsheet. The one I was using from a while back was frustrating and tedious to use, but this new one is simply amazing! Having all the information of whether getting socket bonuses is best, and what upgrades I should aim for all in one place makes life so much easier. Thanks Aldriana!

chultt · 05/16/09, 5:33 AM

Im curious as to the Rune Etched Nightblade being the best offhand. On the previous spreadsheet, it had the highest point value for any offhand. My MH is a Calamity's Grasp. I had read that sword/fist was a sub optimal spec, however, I find that any other main hand sword is a drop in dps to the CG. So, should I assume that sword/fist to still be viable?

Also, Ar Pen. At which point does this become worth gemming for? I have a fair amount of ar pen on my gear, and a grim toll. Between that, the ar pen buff from food, and an ar pen elixer, what point should one start seeing gains over agility? Also, if Grim Toll and an Executioner proc at the same time, especially with expose armor up, would this be optimal, or a waste of time? Still trying different things with the ar pen buff, but was curious. Any insights would be welcome. Thanks much.

koaschten · 05/16/09, 10:49 AM

Check on your spent talent points, i bet you spent more than you should to get both CQC and SS.

On the ArP topic, the sheet will tell you when the EP for ArP pass Agi.

Kumar · 05/16/09, 11:06 AM

Originally Posted by chultt

Im curious as to the Rune Etched Nightblade being the best offhand. On the previous spreadsheet, it had the highest point value for any offhand. My MH is a Calamity's Grasp. I had read that sword/fist was a sub optimal spec, however, I find that any other main hand sword is a drop in dps to the CG. So, should I assume that sword/fist to still be viable?

Gear should always be evaluated in terms of how it would fit with the rest of your gear. If you have Rune-etched Nightblade then MH Mailce will give you more DPS than Calamity's Grasp. Even if Calamity's Grasp on its own maybe better, the switch to Malice and SS will give you better DPS.

Baudz · 05/16/09, 9:34 PM

I havn't seen it mentioned here, so i assume i did something wrong since i am less familiar with this particular spreadsheet. I plugged the new Masticator stats into the combat spreadsheet and showed a dps gain over golden saronite dragon even tho the score was lower.

Valustria · 05/16/09, 9:53 PM

Originally Posted by Baudz

I havn't seen it mentioned here, so i assume i did something wrong since i am less familiar with this particular spreadsheet. I plugged the new Masticator stats into the combat spreadsheet and showed a dps gain over golden saronite dragon even tho the score was lower.

Did you remove the Golden Saronite Dragon? It's possible with Aldriana's spreadsheets, if I'm not mistaken, to have more than one piece of gear per slot equipped. You could have accidentally left both MH weapons equipped...