Spreadsheet DPS Vanguard 2.0+ for gear optimazition

[X-Boson]

I worked out a spreadsheet for vanguard/powertech to optimize DPS here:

 

Updated 2.4

 

https://docs.google.com/spreadsheet/ccc?key=0Ah1yO39E99OmdDh5WE43MjJwVFpXWk9ZZUtkRHZwOEE&usp=drive_web#gid=0

 

 

 

Pre 2.4

 

https://docs.google.com/spreadsheet/ccc?key=0Ah1yO39E99OmdGkyZGhpWG9zZ0E5ejJkcVVnU1pSamc#gid=0

 

 

 

This involves seven independent sheets for seven builds: three Assault/Pyro, three Hybrids and Tactics/Adv Prototype. In each sheet, all you need to do is input your stats and your parse data like number of hits from each abilities. After that you can check the calculated ability´s tooltip dmg and ofc estimate DPS with pinpoint accuracy (match over 95%).

As I know the difference between Vangaurd and Powertech is max/min basic weapon damage (Cell B8 and B9), but average is the same. Further vanguard hits 7 times with each hammer shot and powertech 5 times with each rapid shot. So these are the differences between vanguard and powertech spreadsheeet.

 

 

The keyword is: "What average DPS you should have done with another gear/build."

 

 

The objective is definitely NOT to create a MB large file with all kinds of stuff from swtor universe (sry, don't feel like it), but a clear and simple file of a few KB which is readily accessible. I´ve already done a similar spreadsheet for all of sniper´s builds. For a detailed description of formulae I used, check that thread at my sig. Assumed you know how to work with excel/openoffice/googledoc(basicly no difference), then you can sequentially achieve following things:

 

 

1. Calculate DPS with the help of parse, find out the max-output build/rotation
    
    
   
2. Find out the best gearing and scale stats out of DPS(power, aim, crit, surge, barrel dmg)
    
    
   
3. Decide which skill points for which build are optimal
   

 

 

There are many advantages of using parse. First of all, unlike a preset formula for rotation, you dont have to consider any kind of proc chaining like Ionic Accelerator or ability´s CD or your own reaction time, but basically only number of hits from each ability in any real combat. All this information can be indirectly read from parse. Say an ability has a good DPS but very long CD. Then it wont be on top of dmg. This makes calculation much easier but principally more realistic. Since parse reflects movement and dynamic during a fight. Ammo/Heat management is not considered in this sheet. However you should have a solid rotation before starting parse analyse at all. Othwerwise you can imporve it afterwards.

 

 

 

 

 

How to use it?

 

 

 

1. First of all, free for download in all kinds of spreadsheet format! I´ll inform you about each update
    
    
   
2. Choose the right sheet (build in hyperlink) and input your gear stats from cell B1 to B11. All this infomation can be read from your ingame character sheet. Simply mouseover your Bonus Damage, Accuracy, Critical Chance, Critical Multiplier and Main-/Offhand. Otherwise try web-builder askmrrobot Preset in spreadsheet is optimized for max-output. For gear modification, you can use "change crit/power mod 31, surge/accuracy enhancement 31 and pri-stat/accuracy augment 28" from cell G11 to G13. For any other stats than preset simply edit cell B1 to B11.
    
    
   
3. Input your total damage done, average DPS, total hit number and % miss chance from your parse at cell B22 to B25. First two inputs are for calc of combat length, last two for calc of relic´s DPS. Underworld power proc and click are preset. Try Relic DPS calculator for any other relics.
    
    
   
4. Input how many times Battle Focus/Explosive Fuel activated(cell F18) and how many times any kind of power adrenal used (cell F21&F22)
    
    
   
5. Input target´s defense and if 20% armor debuff was present. Preset is for a boss target without 20% armor debuff
    
    
   
6. Input number of hits from each ability (row 45 and row 60) from your log at torparse! Abilities are sorted in descending order of damage ranking, according to row 42 or 57 "Average inflicted DPS or DMG per GCD"(left to right, top to bottom)
    
    
   
7. Done! Now check outputs like estimated DPS and its deviation, Power to DPS conversion and Effective GCD between ability use.
    
   

 

 

 

 

Important Results:

 

1. Assumed your rotation loop remains unchanged. According to Spreadsheet, 8-22-16 should be better than 2-22-22 (round 47 DPS higher). For 2-22-22 builds, 2/2 Assault Fire/Firebug should be better than 2/3 Rain of Fire (round 50 DPS difference).
    
    
    
   
2. Damage ranking in Hybrid: Gut > Inc Round > Pulse Cannon > High Impact Bolt > Stockstrike > Ion Pulse > Shoulder Cannon > Hammer Shot
    
   Damage ranking in Tactics: Gut > Pulse Cannon > Fire Pulse > High Impact Bolt > Stockstrike > Ion Pulse > Shoulder Cannon > Hammer Shot
    
    
    
   
3. Conq Eli PvP 4 set boni is better than PvE, but not good enough to balance out the loss of pri stat (10-20 DPS difference)
    
    
    
   
4. In all builds 395 accuracy rating should be optimal in end gear, so 109.51% tech accuracy with skillpoints & comp effection.
    
    
    
   
5. In all builds aim has prio in gear, so never use power or accuracy augments
    
    
    
   
6. In 2-22-22 with 2/2 Assault Fire/Firebug, 2x crit mods 31 with 114 crit rating instead of power mod will increase DPS slightly (about +3DPS). In any other builds included Tactics/Adv. Prototype, 0 crit-rating is optimal.
    
    
    
   
7. With 72 end gear, each power converts into 0.34 to 0.38 DPS using real effective GCD which is about 0.2 to 0.3 sec longer than 1.5sec. Otherwise 1 power would be 0.42-0.43 DPS
    
    
    
   
8. Each activation of Battle Focus/Explosive Fuel inreases DPS by 23-30, each nano-infused adrenal round 15
    
    
    
   
9. Just for theorycrafters: Rain of fire and Triump/BloodTracker from skill tree stack multiplicatively (say 1.3*1.03), all others included high energy cell/cylinder stack additively (say 1/1.3*(1+0.3+0.03) instead of 1.3*1.03). I assumed set boni for +9% HiB/RS stack additively too. But not sure about that, since I dont go PvE.
    
   

 

 

I´ve alrdy input log data taken from DPS Leaderboard 2.0+ into spreadsheet.

 

First three sheets are Hybrid 2-22-22: 2/2 Assault Fire/Firebug in first, 2/3 Rain of Fire in second and 8-22-16 in third. They all based on log data from Thoric here. So you can check the DPS difference between these builds. Tactics/Adv.Prototype is based on powertech data from Ka'sumi here. All builds are hyperlinked in sheet. As mentioned all gears are preset for max-output (input at cell B1-B11) on the basis of these logs, so same data in vanguard and powertech sheet. The only modification is at HammerShot/RapidShot (7 or 5 shots each time). So as powertech pls dont be mad about 3x hybrid gear/data from a vanguard friend. Basically we are the same This only makes a small difference in DPS and combat length estimation. This sheet is basicly designed for individual. So I´ll leave to you to input your own stuff. Small remark: The crit chance in most parse I saw is somehow much higher than given in tooltip. Thats why I didnt take log from Mruniverse, its nothing personal.

 

 

You are welcome for further questions and suggestions

Edited October 5, 2013 by X-Boson

[X-Boson]

Update 17.07.13:

 

 

1. Two Assault/Pyro specs added: 4-6-36 and 8-7-31. Theoretically 4-6-36 should be the best full Assault/Pyro spec with AP/TD. Lets say 3/3 Focused Impact/Puncture is presuming. First of all, 2/2 Domolition/PBE should be better than 2/3 OCC/Hyper Fuel. After that 1/1 3% tech crit should be better than either 2/2 +6% HiB/RS or 3/3 +9% Aim. At last +3% Aim is better than +3% HiB/RS. Use 2x crit mod 31 (+114 crit rating) should increase DPS slightly in these builds ( round +1 DPS). 3/3 burnout effect is not considered. I guess this should give u less than 100 extra DPS.
    
    
    
   
2. Corrected 2/2 Domolition/PBE into calc (forgot to add that before): This (OCC/Hyper Fuel as well) concerns DoTs of AP/TD, IR/IM, Plasma Cell/CGC and also Pulse Cannon/FT, IP/FB, Fire pulse/Immolate and Exp. Surge/Flame Sweep. Now calculated DPS deviation from real DPS has become much smaller (match over 99%!).
    
   

 

Remark: the parse data I used for Assault/Pyro based on my own PvP logs. I´ve corrected fight length to achieve a "Effective GCD between ability use" of 1.7 sec, just like in other specs. Any other log data than used "Hit numbers from parse" is wrong. But this does not mean the outcoming result is wrong (thats why DPS deviation is so high there), but rather realistic for a dynamic PvP combat. In that case, better consider total damage divided by expected combat length as DPS (simply do "=B21/B26" in any empty cell). Otherwise you will waste too many DPS due to time out of combat. As expected, Assault/Pyro has round 600 lower DPS than Hybrid. It would be nice if someone has a (solid) dummy log to link here. Anyway as mentioned, this spreadsheet is designed to improve individual play style in real combat.

Edited July 17, 2013 by X-Boson

[Arch_Angel_Gabe]

http://www.torparse.com/a/312358/time/1372390158/1372390483/0/Overview

 

Hopefully this can help you. This was done with an 8/7/31 build but I have recently changed to an 8/8/30 build. I prefer 8/8/30 (10 meter range build), but I have not really parsed with it. Although this is my best parse (and of course, being best means it was more favorable than previous parses) I do know that I can hit 2600+ consistently. I'd say 7 out of 10 parses I will hit 2600+ and 10/10 I'd hit 2500+. I am using the Partisan PVP Eliminator set.

 

My best Dread Guard for 8M HM with the 8/8/30 build can be found here@ 2660 DPS. I'd like to note that this parse is *not* inflated by doing AoE damage to all three. This is 99.9% single target DPS on each of the bosses.

 

Everyone has their preference. I really like the 10 meter build because I can avoid all forms of floor candy and can constantly be on the move. FWIW, my gear level isn't all that great. 72MH/OH with 72 Mods and the rest is 69 (enhancements, implants, ear, relics)

 

Edit ** Forget to mention - Nice spreadsheet.

 

---------------------------

 

Found my old post here, this is when I was 69 only with the exception of Bracers and Belt (those were 72) I also had PVP Eliminator set from 1.7 WH. But, this should give you three parses to look through.

 

Finally decided to gear up my VG. Still very far from BIS, but definitely geared up nicely now. All 69's except for belt, offhand and bracers, those are 72. All L66 augments. Assault spec (Pyro: Mirror)

 

I have done about 5 parses, asside from mistakes, I nearly always come in with the exact same numbers (within a few single digit DPS). I'll provide two logs, which have very similar results. Time to get some Assault love on those scoreboards.

 

Blackbox - Vanguard - Assault - 7/8/31 - 2526 - 2526 Torparse

 

Blackbox - Vanguard - Assault - 7/8/31 - 2524 - 2524 Torparse

 

Thought it would be fun to exclude Shockstrike from my rotation (actually, I used it three times by accident). This effectively makes the Assault Vanguard a 10 meter ranged class.

 

Blackbox - Vanguard - Assault - 7/8/31 - 2522 - [url="Blackbox - Vanguard - Assault - 7/8/31 http://www.torparse.com/a/278314/time/1370828952/1370829251/0/Overview [Link refuses to work properly, manually copy and paste into browser]

Edited July 17, 2013 by Arch_Angel_Gabe

[Rahizm]

In 2-22-22 with 2/2 Assault Fire/Firebug, 2x keen mods 31 with 114 crit rating instead of power mod will increase DPS slightly (about +3DPS). In any other builds included Tactics/Adv. Prototype, 0 crit-rating is optimal.

 

Since we're talking about Vanguards here (with an Aim boost talent), I'm wondering why Keen mods (cunning+crit) is mentioned instead of Nimble mods (aim+crit).

[Arch_Angel_Gabe]

Since we're talking about Vanguards here (with an Aim boost talent), I'm wondering why Keen mods (cunning+crit) is mentioned instead of Nimble mods (aim+crit).

 

I think his main is a slinger [Err.. Sniper]... :-) I believe the signature gives it away.

Edited July 17, 2013 by Arch_Angel_Gabe

[X-Boson]

I think his main is a slinger [Err.. Sniper]... :-) I believe the signature gives it away.

 

Thy for feedback, corrected keen mod to CRIT mod(...cant go wrong now). Btw sniper is not my main. Actually dont rlly know which char should be my main (=FotM)

 

 

I updated your dummy log here for 8-7-31. Looks very promising with 3% deviation (u got many crits ). Anyway I used best gear atm, that should be fair enough. Further I updated 8-8-30 and put the same log in it(check "Assault_3"). According to calc, you would have done 2 DPS more with 8-8-30. In both builds 3x CRIT mods instead of 2x will increase DPS by 0.6.

Edited July 17, 2013 by X-Boson

[Arch_Angel_Gabe]

Thy for feedback, corrected keen mod to CRIT mod(...cant go wrong now). Btw sniper is not my main. Actually dont rlly know which char should be my main (=FotM)

 

 

I updated your dummy log here for 8-7-31. Looks very promising with 3% deviation (u got many crits ). Anyway I used best gear atm, that should be fair enough. Further I updated 8-8-30 and put the same log in it(check "Assault_3"). According to calc, you would have done 2 DPS more with 8-8-30. In both builds 3x CRIT mods instead of 2x will increase DPS by 0.6.

 

Very cool. I wish I could say that my crits are abnormal, but most of my parses pretty much look like that. I am running with 240 crit rating, which is about 6% I think. Plus the 15% extra crit on HIB, and the 6% crits to elemental, combined with battle focus. It is definitely a heavy crit build. But, it works out decently because I believe 80% of my crit damage is getting a 1.97 multiplier (I don't want to drop below 100% accuracy - personal preference).

 

Thanks for making this available to us. It is really interestign to see how the different specs compare, on paper. They also seem to line up pretty close to real world results on dummy testing. But I suppose you could argue that case because it is taken from dummy parses...

Edited July 17, 2013 by Arch_Angel_Gabe

[X-Boson]

Very cool. I wish I could say that my crits are abnormal, but most of my parses pretty much look like that. I am running with 240 crit rating, which is about 6% I think. Plus the 15% extra crit on HIB, and the 6% crits to elemental, combined with battle focus. It is definitely a heavy crit build. But, it works out decently because I believe 80% of my crit damage is getting a 1.97 multiplier (I don't want to drop below 100% accuracy - personal preference).

 

Actually there is a common problem with crit which is actually "good" for us. Lets say all crits over 40% you did is statistically too high. HiB for example is a ranged attack, therefore max 40% with 240 crit rating + 15% crit from set boni. Statistically if one ability crits higher than expected, we could simultaneously expect another ability crits lower than expected! Thats the point. If we can see that is happening all the time, then RNG is in order. I believe there is something triggered a chain reaction of crit. Dont know if someone has reported this alrdy. For a programmer analyst, this process can easily be simulated using another fuctioning RNG.

 

Thanks for making this available to us. It is really interestign to see how the different specs compare, on paper. They also seem to line up pretty close to real world results on dummy testing. But I suppose you could argue that case because it is taken from dummy parses...

 

Always my pleasure to do math. This spreadsheet is definitely NOT only for dummy parse, but rather for dynamic raid fight or PvP. Your hit numbers from last combat shows you your rotation there. Say u have to move a lot, then you probably wont see any dmg from pulse cannon. Quite different from a wz game where you could do a lot of AOE dmg in mass with Mortar Volley, explosive surge. That will change the scaling factors of your DPS in a way.

Edited July 18, 2013 by X-Boson

[X-Boson]

Updated for 2.4

 

Recalculated for all class ability changes in patch notes, as well as changes which are NOT listed. Damage of Pulse Cannon/Flamethrower and Gut/Retr. Blade has been slightly reduced, while Firepulse/Immolate

does slightly more dmg. You can check ability´s coefficients in spreadsheets before and after 2.4.

 

Notice I only updated formulas, NOT ability´s hit numbers from parse data which reproduce your DPS rotation during a combat. The first spec Assault_1/Pyro_1 used data from my own wz log, not to compare with other specs which were done on dummy (just didnt had a full Assault/Pyro dummy spec). In fact, you can optimize your DPS on each boss, not only on a dummy.

 

 

Based on the old rotations which were read out from pre-2.4 combat logs, 8-22-16 still remains the best spec (open spreadsheet for further details). Now this result could be wrong with new 2.4 rotations. Since ammo cost of Inc Round/Inc Missile is reduced considerably. For that reason you are also welcome to share your solid combat parse here(spec and only on single target dmg!).

Edited October 6, 2013 by X-Boson

[Aelaias]

Full pyro, to crit proc relic or not to crit proc relic. My eternal belief is that in pvp the only thing that counts is burst and crit is burst.

[X-Boson]

Full pyro, to crit proc relic or not to crit proc relic. My eternal belief is that in pvp the only thing that counts is burst and crit is burst.

 

Its true that some ppl only use crit even in high end pvp. To be honest, this is really a matter of taste. That reminds me someone survived with 10hp, or someone missed two deathblow hits in succession, just because he only had 1% miss-chance. In that case he would say "if I used power or accuracy instead of crit.

 

Use 2 or max 3 crit mods is fine, its about 1-2 dps difference.

Edited October 6, 2013 by X-Boson

[Arch_Angel_Gabe]

This parse was done on the test server after the changes were made to Pyro... It is actually lower than my pre-2.4 parse that I did about 2 weeks before it launched. Anyhow, I only did two parses with Pyro on the test server. 63/69 gear mostly, a handful of 72 items.

 

http://www.torparse.com/a/393783/time/1377127699/1377128031/0/Overview

 

Anyhow, it would be cool to see this in your spread sheet. I am losing interest in the game, which is why I am referencing this parse... I don't really have the drive to farm new gear and parse further. Not sure, but 2.4 was a letdown for me and has nothing to do with our class.

 

Edit ** 4/6/36 spec. Full Pyro. 2790 DPS.

Edited October 8, 2013 by Arch_Angel_Gabe

[X-Boson]

This parse was done on the test server after the changes were made to Pyro... It is actually lower than my pre-2.4 parse that I did about 2 weeks before it launched. Anyhow, I only did two parses with Pyro on the test server. 63/69 gear mostly, a handful of 72 items.

 

http://www.torparse.com/a/393783/time/1377127699/1377128031/0/Overview

 

Anyhow, it would be cool to see this in your spread sheet. I am losing interest in the game, which is why I am referencing this parse... I don't really have the drive to farm new gear and parse further. Not sure, but 2.4 was a letdown for me and has nothing to do with our class.

 

Edit ** 4/6/36 spec. Full Pyro. 2790 DPS.

 

thy for that very nice parse,

 

Anyway now I now updated for DF stats.

 

in your full UW gear, using 3x crit (171 crit rating) instead of 2x crit mod (pre-2.4) will achieve best DPS result. Calculated DPS was 2712.04, compare to parse 2790.39 only 2.81% deviation.

 

Optimized 72 UW gear from spreadsheet

 

 

Aim 3167

Power 1182

Cunning 155

Accuracy Rating 395

Surge Rating 395

Crit rating 171

Alacrity rating 0

 

 

 

As for skill points, 1/2 for HiB, 3/3 for +9% aim and 1/1 for +3% tech crit remains the best points distribution for 4-6-36, as used in spreadsheet.

 

 

Now all want to see 78 DF gear, first of all best full 78 would look like this (no stim):

 

Aim 3577 (max, +316)

Power 1605 (max, +252)

Accuracy or Surge Rating 940(max, +150)

 

Hope no mistake at this point, now with "blue stim" optimized DF stats would be

 

 

------------Full Asault/Pyro-------------

Aim 3770

Power 1399

Cunning 155

Accuracy Rating 470

Surge Rating 470

Crit rating 276

Alacrity rating 0

max main-hand basic weapon dmg 863

min main-hand basic weapon dmg 575

main-hand tech power 1151

off-hand tech power 1151

 

------------Hybrid 2-22-2-------------

http://www.torhead.com/skill-calc#801bZrsMrobRMZfG0rzRr.3

Aim 3671

Power 1468

Cunning 155

Accuracy Rating 470

Surge Rating 470

Crit rating 276

Alacrity rating 0

max main-hand basic weapon dmg 863

min main-hand basic weapon dmg 575

main-hand tech power 1151

off-hand tech power 1151

 

 

 

------------Hybrid 8-22-16-------------

http://www.torhead.com/skill-calc#801hMhZMsMrRbRMZfG0rzo.3

 

Aim 3770

Power 1606

Cunning 155

Accuracy Rating 470

Surge Rating 470

Crit rating 69

Alacrity rating 0

max main-hand basic weapon dmg 863

min main-hand basic weapon dmg 575

main-hand tech power 1151

off-hand tech power 1151

 

 

------------Tactic/AP 8-36-2-------------

http://www.torhead.com/skill-calc#801hMhZRsMrorRRoGGzZb.3

Aim 3770

Power 1537

Cunning 155

Accuracy Rating 470

Surge Rating 470

Crit rating 138

Alacrity rating 0

max main-hand basic weapon dmg 863

min main-hand basic weapon dmg 575

main-hand tech power 1151

off-hand tech power 1151

 

 

In all specs 470 acc to 470 surge rating should be optimal ratio due to their DR, in all kinds of (Full) Assualt/Pyro 276 crit rating should be used. Compare to old UW gear there we have a over 10% dmg increase in full DF gear. Btw, spreadsheet free to download then u can input your own stats.

 

Im still missing parse from other specs. Anyway as told before hybrid 8-22-16 remains the best spec, (even) using pre-2.4 parses (100-200DPS higher than other specs). Full Assualt/Pyro can now reach the DPS of Tactic/AP.

Edited October 16, 2013 by X-Boson

[Arch_Angel_Gabe]

(even) using pre-2.4 parses (100-200DPS higher than other specs). Full Assualt/Pyro can now reach the DPS of Tactic/AP.

 

Would you mind converting this to 2.4? The only reason I am asking is because of the last comment. I didn't really play 4/6/36 often, but when I knew 2.4 was coming, I started to re-learn it again. This parse was from 2.0 and was in 63/69/72 gear. So when I did my 2.4 test server parse, I had quite a few mistakes in that parse, and also the additional HIB damage didn't exist either. They stealthed in that change last minute... Maybe someone else can step up and provide some parses? I know I could easily beat my 2790 value, I just don't feel like playing the game anymore. I just need a long break.

 

http://www.torparse.com/a/428432/time/1379474209/1379474513/0/Overview

 

Forgot to mention - This thread is very valuable... I am really surprised it doesn't get more attention. Anyhow, it is appreciated from at least one VG.

Edited October 9, 2013 by Arch_Angel_Gabe

[X-Boson]

Thy again for the parse,

 

I uploaded that. Indeed this one is better, 3241 to 3208 converting in 2.4, so +33DPS. This is acutally a lot, since each Battle Focus will only give about 30DPS and adrenal 16. Also, 1% more miss-chance was unlucky.

 

You overstacked Inc Round´s DoT a bit more on test-server. You can see that by comparing IR to its DoT from both parses.

 

Anyway we should expect a reduced use of HammerShot in 2.4, coz IR´s ammo is reduced.

Edited October 9, 2013 by X-Boson