Arsenal DPS spreadsheet

[Allah]

(03-14-2012 06:35 AM)thrust Wrote:  Any one got BIS for MERC Arsenal spec?

Columi implants/ear piece with an augment slot
Fabricator trinket+matrix shard
Rakata weapons
until we can replace Rakata set piece armorings, Rakata chest/legs/boots/gloves with an orange helm with 58 armoring/mod/enhancement
Belt/Bracers is moddable ones with 58 armoring/mod or if you went armormech the augment slot crafted rakata ones are best.


For what enhancements you should use, thats pretty much what these spreadsheets are aiming to calculate. Exact levels of alacrity/surge/accuracy, and crit/power are still being figured out.

[thrust]

(03-14-2012 09:22 AM)Allah Wrote:  

(03-14-2012 06:35 AM)thrust Wrote:  Any one got BIS for MERC Arsenal spec?

Columi implants/ear piece with an augment slot
Fabricator trinket+matrix shard
Rakata weapons
until we can replace Rakata set piece armorings, Rakata chest/legs/boots/gloves with an orange helm with 58 armoring/mod/enhancement
Belt/Bracers is moddable ones with 58 armoring/mod or if you went armormech the augment slot crafted rakata ones are best.


For what enhancements you should use, thats pretty much what these spreadsheets are aiming to calculate. Exact levels of alacrity/surge/accuracy, and crit/power are still being figured out.

thx

[bural]

(03-09-2012 11:05 PM)MagicSN Wrote:  I am currently putting in the math for Arsenal/Gunnery to support them into my "Project Shield" standalone executable program. I learned a lot of your spreadsheet (I do not play this class), basically implementing your maths into my program (thanks for the great work!) I hope you don't mind that I reuse your maths in this way ;-)

I've basically had zero time to play the game or look into the spreadsheet since my last post. I'll try and answer your questions as best I can.

(03-09-2012 11:05 PM)MagicSN Wrote:  - If in the frontend I set "5% damage" to 1 (by default it is 0 on your spreadsheet) it
multiplies all skill damage values by 1.05. I assume this is the Jedi Knight/Warrior
buff? If yes, why do you

1.05*(1.27*dps->mhdmgmax+1.9*dps->mdmgbonus+0.19*1610),

and not

1.27*dps->mhdmgmax+1.9*dps->mdmgbonus*1.05+0.19*1610

??? Or have I been doing this completely wrong until now? Always assumed that it just multiplies on the damagebonus

I'll get back to you on this one.

(03-09-2012 11:05 PM)MagicSN Wrote:  1) In the unload values is it on purpose that offhand damage is multiplied with 0.7
two times like 0.7*offhand*0.7 ? Or is this a double by mistake?
2) What's the sense in adding offhand damage at all? Troopers of that AC don't
carry an offhand, or am I totally wrong?

(0.18*dps->mhdmgmax+0.7*dps->ohdmgmax*0.7+1.05*dps->mdmgbonus+0.105*1610)*1.33

As for 2): No, Troopers doesn't use an offhand and you will find their weapon damage to be slightly different. However, Bounty Hunters dual wield and the sheet was developed for this class initially. If you read through the last few pages on this thread, you'll find a number if issues arose from me using torhead to get ability details. Nodeviewer is somewhat better. Most importantly, torhead reports some offhand coefficients incorrectly. I can't remember which ones of the top of my head, but it's here in the thread somewhere. On the subject of porting from Arsenal to Gunnery, you'll find an number of additional issues has been discussed in this thread, most importantly various resource discrepancies.

1) Ability Damage Max = ( AmountModifierPercent + 1 ) * MainHandMax + ( AmountModifierPercent + 1 ) * OffHandMax * 0.3 + Coefficient * DamageBonus + StandardHealthPercentMax * StandardHealth
The first (-0.3+1) is the AmountModifierPercent+1. The second 0.7 relates to the offhand penalty. I remember changing it from 0.3 to 0.7 in relation to this post http://sithwarrior.com/forums/Thread-Ars...#pid14214, but currently I can't spell out exactly why. Like I said: I haven't really spend time on this in a while so the details sort of escape me
Last but not least: it's not refering to DPS.[/i]

[Naplam]

Hey, just a quick question/comment.

I noticed the spreadsheet doesn't have any numbers for the relic: Gravity Wave Device. Similar to the other proc ones. Torhead and Darth Hater's DB have the wrong info on them so I'll post it here.

+72 Endurance
Equip: Damaging attacks have a 30% chance to deal 208 additional kinetic damage to the target. This effect can only occur once every 4.5 seconds, and shares this limit with similar damage dealing effects.

[Crythe]

Hey, since Bural hasn't been around for a while I made a quick patch 1.2 update for the spreadsheet myself.

Changelog:

Changed default armor and avoidance to recently discovered values
1.2 Expertise calculations
1.2 Tracer, Heatseeker & Barrage changes
Added new relics

I noticed that after applying all the 1.2 "nerfs" (+ Barrage proc change) DPS went down by only 0,12%. The ~4% DPS loss that was claimed previously was most likely due to not taking the Barrage change into account properly (i'm 90% sure that it's fixed in this version). It would make sense that BW didn't pick the new numbers randomly, but calculated them so that overall DPS remained the same while making plain Tracer spam less effective. So, while our burst went down a bit, the sustained DPS should be about the same as before as long as Barrage procs are used up properly.

[Estra]

So has this project died? I haven't seen Bural making any posts. I see Crythe put up updated one for 1.2.

I am in a really busy part of the season or I would work on it. I think that several other class spreadsheets are using Mr. Robot to import gear. Might see about using that to import. The only issue I see it that you would have to make slots in the spreadsheet for mods and augments. Seems pretty easy though.

I made a similar spreadsheet in that other MMO for my S-Priest using Simulationscraft. I might see whats there. With all the mod-ability of gear after 1.2, seems that a good spreadsheet would work wonders. I myself, would like to figure out the "No Crap" BIS mods and gear. And the most viable spec. We do have logs now to verify. Its reported DPS for Arsenal is between 1200 -1600. I am in that area with FULL Rakata (with some mod changes)

Any other thoughts?

[complexxL9]

Is this any good for 1.2?