Carnage/Combat stat weight spreadsheet online

[Melanie]

i was thinking there was something wrong with the dummies, i always get 3.2-3.4k force scream on the dummy but not in the real world if there is no armor reduction going on. so the damage is abit higher on the dummy then it should be.

[Lucifel]

Quote:I played around a bit with the sheet and upgraded the "Upgrade Advisor" so it uses a few more stats and considers DR's.

https://docs.google.com/spreadsheet/ccc?...FlPZjc4QXc

It might not be the most elegant solution but it seems to work quite well.

Oh, very nice work! This is a very real improvement of the upgrade advisor. Definitely incorporating that in my next draft.

Now the bad news. I noticed a few small problems.
Typo in the stims box, "strenh".
In the advisor side of the front page, Willpower got a static value instead of one based on the user-entered stats.
Some references that look to the Talents page now look at the wrong talent box. (For instance, the effects of Ravager/Master Focus are triggered by points in Malice/Insight instead.)

[Tahreyn]

(04-27-2012 08:24 AM)Lucifel Wrote:  

Quote:I played around a bit with the sheet and upgraded the "Upgrade Advisor" so it uses a few more stats and considers DR's.

https://docs.google.com/spreadsheet/ccc?...FlPZjc4QXc

It might not be the most elegant solution but it seems to work quite well.

Oh, very nice work! This is a very real improvement of the upgrade advisor. Definitely incorporating that in my next draft.

Now the bad news. I noticed a few small problems.
Typo in the stims box, "strenh".
In the advisor side of the front page, Willpower got a static value instead of one based on the user-entered stats.
Some references that look to the Talents page now look at the wrong talent box. (For instance, the effects of Ravager/Master Focus are triggered by points in Malice/Insight instead.)

Thanks for noticing those errors. I fixed the errors you noticed on the stats page and I'll have a look on the ability_data sheet later today. Is your ability_data sheet updated with all the correct look-ups? In that case I'll go and grab that one to correct the errors which have occured in mine. I've to be better to use absolute referenses ($B$1) instead of relative ones so stuff wont get messed up when moving things around.

On another note. According to the formulas used here STR is always prefered above Power. I thought that there were DR's in play with the +crit STR gives. DR's that would result in Power generating more damage after X STR. However. The crit chance values I get from STR when buffed on the sheet are in fact the same as what I get ingame. Is this correct that STR always gives more dps than Power?

[Tumri]

Well strength is .8 power and .4 crit and then gets a 5% increase in effectiveness from Inq buff. It's a very good stat that's hard to pass up. You would need to have an obscene amount of Str to eat into DR too much. It's likely Str > Power unless they introduce crazy gear inflation.

[Lucifel]

Okay, I've got a new version incorporating Tahreyn's work. I think I have all the talent benefits applying appropriately again.
I also fixed a couple other things I turned up. For instance, Force Choke, Ravage, and Battering Assault were all being implemented slightly wrong. (Too few swings/ticks.) Also, embarrassingly, in the Rage rotation I had made calculations to determine the average Shockwave bonus, but not actually implemented the damage bonus' application. *facepalm*

https://docs.google.com/spreadsheet/ccc?...UhQaE82TGc

(The previous version is still up at the old link, if you want to compare results.)

[Lucifel]

A quick note to people testing and logging on the dummies:

If your dummy doesn't have "MK-5" at the end of the name, it's the level 10 target.
Combat Training Target MK-5 is a level 50 Strong.
Operations Training Target MK-5 is a level 50 Champion.

[Melanie]

actually i prob hit the lvl 10 dummy next to the 50 one didnt even notice they were diffrent levels

[Tahreyn]

Nicely done with the upgrades to the spreadsheet Lucifel.

I used the operation dummy earlier today to check it out. It seems like the miss/hit works as it should, 100% acc will give you 100% hits with your MH. However. It seems like the dummy can't dodge/parry (http://www.swtor.com/community/showthrea...t4039844). I wasn't able find that they'd patched it, so I'd guess the defense on the dummy is still broken.

I'm thinking about writing a Java program based on these spreadsheets later on, maybe port it to Android too. It wouldn't be too hard to write a program that use the formulas from the spreadsheet and create a small item database with late game gear. Aka. A simplified version of RAWR but only for sentinels/marauders to begin with.

[Lucifel]

(05-02-2012 01:36 AM)Tahreyn Wrote:  Nicely done with the upgrades to the spreadsheet Lucifel.

I used the operation dummy earlier today to check it out. It seems like the miss/hit works as it should, 100% acc will give you 100% hits with your MH. However. It seems like the dummy can't dodge/parry (http://www.swtor.com/community/showthrea...t4039844). I wasn't able find that they'd patched it, so I'd guess the defense on the dummy is still broken.

I'm thinking about writing a Java program based on these spreadsheets later on, maybe port it to Android too. It wouldn't be too hard to write a program that use the formulas from the spreadsheet and create a small item database with late game gear. Aka. A simplified version of RAWR but only for sentinels/marauders to begin with.

Ooh, that could be fun. My programming experience is all C++, and not terribly thorough even there, but I'd be willing to help out.

[Lucifel]

Tested the kinetic/energy mitigation on the dummies with Force Choke, since it's a flat damage number rather than random within a range. The Strong 50 has a 0.2, and the Champion 50 has a 0.35. I tried each with and without Gore.
(The level 10 has around 0.044ish, if you're curious.)

None appear to have any internal/elemental mitigation.

I'm going to have to test large logs to see if miss chance varies at all between Strong and Champion.