MMO News and theorycrafting for advanced MMO gamers. News and articles that relate to your gameplay. World of Warcraft, SWTOR, Guild Wars 2, Rift, TERA, Eve Online, Star Wars the Old Republic, Diablo3, The Secret World and all Western AAA MMOs

Your login from any MMO-Mechanics forum or site will work here.

Hello There, Guest! Register

Post Reply 
Arsenal DPS spreadsheet
02-11-2012, 06:27 AM (This post was last modified: 02-11-2012 09:56 PM by bural.)
Post: #24
RE: Arsenal DPS spreadsheet
(02-11-2012 03:58 AM)Rakunvar Wrote:  Not sure if you've gotten back online yet or not but figured I should let ya know ahead of time on this.

PTS Note for new build recently. Surge rating has been re-balanced. It now reaches diminishing returns the same way as other damage ratings, and its per point damage contribution has been reduced by approximately 10%.
I have taken notes of your comments, they're most appreciated and I will adress them as soon as I find the time. I've just had a lot on my plate these past few days and will unfortunately have so in weekend as well. Furthermore it's damn frustrating not being able to test bugs ingame myself...
I've seen the patch notes. I'll make an option to toggle between the current and future surge calculations. Naturally it'll reduce the value of surge and crit. This should make the advice mentioned in the DPS compendium about focusing on accuracy before crit and surge pretty much universally correct.

(02-10-2012 03:44 AM)Rakunvar Wrote:  I'm assuming I am understanding the EP+1 correctly as they are just weights basically, but I wanted to confirm. If this is so then my questions below still follow.

Is there something wrong with the Diminishing returns on crit. now? Seems it has a very high value that barely moves and between 360-370 it drops from 1.00 weight to .56ish.
Your understanding of EP+1 is correct. There'll be a DPS/stat in the version as well. I could make a cross table to show how much of each stat can be traded for 1 of another, but frankly it wouldn't be very helpfull. Do notice the complications discussed in this thread on stat weights.
The sudden drop in the value of crit rating is noteworthy. However, I don't believe there's anything wrong with the calculations per se. The implementation of Terminal Velocity (TV) is still a work in progress and the drop you see relates to this implementation. As previously mentioned, I calculate the average time between crits from abilities capable of proccing TV. The number of procs over a given time period is used as the number of TV procs. However, the calculated average has a minimum value of 3 to reflect the internal cooldown. The word "softcap" comes to mind, but do notice it's one that is mainly introduced by the sheet. It exist ingame as well, but the dropoff isn't as abrupt as currently depicted by the sheet. It appears it kicks in around 356 crit rating depending on your level of alacrity and aim. See cell CalcsV2!B216.
In sum, there's nothing wrong per se and it doesn't relate to the diminishing returns, but the TV model could be improved. I find it surprising we're hitting "the TV wall" this early on atleast. I'm all ears and open to suggestions if anyone have a good suggestion as to how to incorporate ability sequencing and its effect on the internal cooldown of TV.

(02-10-2012 03:44 AM)Rakunvar Wrote:  Also is alacrity modeled right and such? It doesnt seem to affect "calculated DPS" when its changed for me for some reason. Also shows kinda strange as #.##E-## could be intentional as well.. #=w/e numbers. I "Thought" the more you messed with the 1.5 on tracer etc with alacrity the more you just hurt yourself with heat and such is also why I ask.
I believe the alacrity model is pretty much spot on. The cells uses the "scientific" formatting of numbers. E-05 means *10^(-5) so 3.65E-05 = 0.0000365. It's to save space on a frankly speaking horrible dps stat. I've outlined some if the issues with alacrity in a previous post, but in addition in worth noticing some levels of alacrity may be decrimental to TV heat venting. This isn't modeled by the sheet however.

(02-10-2012 03:44 AM)Rakunvar Wrote:  Is Critical Reaction from Bodyguard supposed to only show a 2.5 increase when the talent has a 50% chance to proc but a 5% boost to alacrity @ 1 point and also @ 6.50 for 2 points. These numbers are in the K-38/39.
I believe it's implemented as 2.5% per point, which admittedly is incorrect when only speccing 1 point in it. However, I actually have the calculations for number crits per second and by inverting this I should be able to calculate uptime of Critical Reaction and use it as a proper implementation of the talent. You can manually edit it to 5% for 1 talent point if you want. For sustained dps purposes there appears to be little reason for speccing more than 1 point in it. Atleast, you see far larger returns from the first talent point than from the second point.

(02-11-2012 02:51 AM)GWARRR Wrote:  This looks great. I've finally stumbled on some time to do stuff so I can tinker with the table and see what happens. I may link to this thread/spreadsheet in the Compendium, if you don't mind at all. This will definitely allow for complete optimization. Guess I should start looking at that BiS list I've been meaning to compile...
Please, be my guestSmile Naturally, I don't mind at all, the more the merrier etc. Do link to the thread though. With the issues still haunting the sheet, I feel it's paramount people read the currently known issues before using it - a list I'll make sure to keep as comprehensive as possible. While I'm fairly satisfied with the way the sheet models our way of doing damage, there are definitely still bugs in there that skews the results to a significant degree.

I found a exhaustive list of names for mirror abilities and talents earlier today and will use as a basis for a Trooper port. The previously discussed issues in this regard will still need to be handled somehow. It's a side project as I want to improve and verify the validity of the BH model first.

I appreciate the link to the issues with Trooper mechanics, but once again it would be a great help if a list of known BH and Trooper issues could be compiled and maintained. Given BWs trackrecord this past month, discrepancies between the model and ingame behavior may as much be due to ingame bugs as bugs in the sheet.
Once the major bugs have been sorted out, I will be cleaning up the ability tables and then move to implement various trinkets. Another feature that could be interesting to have in the HUD is modifications suggestions based on current EP weights. Not sure if the surge change makes this feature useless though.

Almost universally, every mark 25 enhancement should have 37 power and 51 to a secondary and every mod should have 37 power 48 primary, or else you're probably doing it wrong.

Bural's Arsenal DPS spreadsheet
Find all posts by this user
Quote this message in a reply
Post Reply 


Messages In This Thread
Arsenal DPS spreadsheet - bural - 02-03-2012, 10:12 AM
RE: Arsenal DPS spreadsheet - bural - 02-03-2012, 10:24 PM
RE: Arsenal DPS spreadsheet - bural - 02-03-2012, 10:54 PM
RE: Arsenal DPS spreadsheet - Kindread - 02-04-2012, 01:55 AM
RE: Arsenal DPS spreadsheet - Kindread - 02-04-2012, 02:06 AM
RE: Arsenal DPS spreadsheet - bural - 02-04-2012, 02:29 AM
RE: Arsenal DPS spreadsheet - Rakunvar - 02-05-2012, 03:03 AM
RE: Arsenal DPS spreadsheet - bural - 02-05-2012, 05:26 AM
RE: Arsenal DPS spreadsheet - Rakunvar - 02-05-2012, 08:09 PM
RE: Arsenal DPS spreadsheet - Qed - 02-08-2012, 08:02 AM
RE: Arsenal DPS spreadsheet - bural - 02-08-2012, 09:17 PM
RE: Arsenal DPS spreadsheet - Qed - 02-09-2012, 03:42 AM
RE: Arsenal DPS spreadsheet - bural - 02-20-2012, 12:16 AM
RE: Arsenal DPS spreadsheet - Qed - 02-24-2012, 02:22 AM
RE: Arsenal DPS spreadsheet - bural - 02-24-2012, 03:01 AM
RE: Arsenal DPS spreadsheet - Krix - 02-25-2012, 06:40 AM
RE: Arsenal DPS spreadsheet - bural - 02-08-2012, 08:03 AM
RE: Arsenal DPS spreadsheet - Crythe - 02-08-2012, 09:55 PM
RE: Arsenal DPS spreadsheet - bural - 02-08-2012, 11:07 PM
RE: Arsenal DPS spreadsheet - bural - 02-09-2012, 06:08 AM
RE: Arsenal DPS spreadsheet - Crythe - 02-09-2012, 08:05 AM
RE: Arsenal DPS spreadsheet - bural - 02-09-2012, 08:35 AM
RE: Arsenal DPS spreadsheet - Qed - 02-09-2012, 09:50 AM
RE: Arsenal DPS spreadsheet - Rakunvar - 02-10-2012, 03:44 AM
RE: Arsenal DPS spreadsheet - Sarkastro - 02-10-2012, 09:03 AM
RE: Arsenal DPS spreadsheet - GWARRR - 02-11-2012, 02:51 AM
RE: Arsenal DPS spreadsheet - Rakunvar - 02-11-2012, 03:58 AM
RE: Arsenal DPS spreadsheet - bural - 02-11-2012 06:27 AM
RE: Arsenal DPS spreadsheet - Crythe - 02-11-2012, 08:06 AM
RE: Arsenal DPS spreadsheet - Rakunvar - 02-11-2012, 10:10 AM
RE: Arsenal DPS spreadsheet - bural - 02-12-2012, 12:34 AM
RE: Arsenal DPS spreadsheet - bural - 02-14-2012, 10:33 PM
RE: Arsenal DPS spreadsheet - bural - 02-16-2012, 12:10 AM
RE: Arsenal DPS spreadsheet - Crythe - 02-16-2012, 08:18 PM
RE: Arsenal DPS spreadsheet - bural - 02-16-2012, 08:43 PM
RE: Arsenal DPS spreadsheet - Fado - 02-16-2012, 11:49 PM
RE: Arsenal DPS spreadsheet - Crythe - 02-17-2012, 01:51 AM
RE: Arsenal DPS spreadsheet - bural - 02-17-2012, 02:21 AM
RE: Arsenal DPS spreadsheet - Allah - 02-17-2012, 02:22 AM
RE: Arsenal DPS spreadsheet - bural - 02-17-2012, 02:42 AM
RE: Arsenal DPS spreadsheet - Allah - 02-17-2012, 02:51 AM
RE: Arsenal DPS spreadsheet - Fado - 02-17-2012, 04:25 AM
RE: Arsenal DPS spreadsheet - Allah - 02-17-2012, 05:19 AM
RE: Arsenal DPS spreadsheet - Fado - 02-17-2012, 10:43 PM
RE: Arsenal DPS spreadsheet - Rakunvar - 02-19-2012, 12:23 AM
RE: Arsenal DPS spreadsheet - Qed - 02-24-2012, 03:46 AM
RE: Arsenal DPS spreadsheet - bural - 02-24-2012, 04:18 AM
RE: Arsenal DPS spreadsheet - bural - 02-24-2012, 04:41 AM
RE: Arsenal DPS spreadsheet - Crythe - 02-24-2012, 08:06 AM
RE: Arsenal DPS spreadsheet - Tsikinator - 02-24-2012, 10:24 PM
RE: Arsenal DPS spreadsheet - bural - 02-24-2012, 11:45 PM
RE: Arsenal DPS spreadsheet - bural - 02-25-2012, 08:10 AM
RE: Arsenal DPS spreadsheet - Krix - 02-25-2012, 08:43 AM
RE: Arsenal DPS spreadsheet - Simo - 02-25-2012, 08:35 AM
RE: Arsenal DPS spreadsheet - bural - 02-25-2012, 09:16 AM
RE: Arsenal DPS spreadsheet - Krix - 02-25-2012, 10:59 AM
RE: Arsenal DPS spreadsheet - Qed - 02-25-2012, 12:23 PM
RE: Arsenal DPS spreadsheet - Krix - 02-25-2012, 06:41 PM
RE: Arsenal DPS spreadsheet - bural - 02-25-2012, 08:00 PM
RE: Arsenal DPS spreadsheet - RuQu - 03-03-2012, 11:02 AM
RE: Arsenal DPS spreadsheet - Qed - 02-25-2012, 10:03 AM
RE: Arsenal DPS spreadsheet - Qed - 03-04-2012, 08:18 AM
RE: Arsenal DPS spreadsheet - bural - 03-05-2012, 12:51 AM
RE: Arsenal DPS spreadsheet - kray - 03-05-2012, 02:18 AM
RE: Arsenal DPS spreadsheet - RuQu - 03-05-2012, 02:22 AM
RE: Arsenal DPS spreadsheet - bural - 03-05-2012, 05:39 AM
RE: Arsenal DPS spreadsheet - RuQu - 03-05-2012, 05:47 AM
RE: Arsenal DPS spreadsheet - bural - 03-05-2012, 06:54 AM
RE: Arsenal DPS spreadsheet - RuQu - 03-05-2012, 07:01 AM
RE: Arsenal DPS spreadsheet - bural - 03-05-2012, 07:20 AM
RE: Arsenal DPS spreadsheet - Qed - 03-05-2012, 08:27 AM
RE: Arsenal DPS spreadsheet - bural - 03-05-2012, 09:03 PM
RE: Arsenal DPS spreadsheet - bural - 03-05-2012, 10:03 PM
RE: Arsenal DPS spreadsheet - Qed - 03-05-2012, 11:51 PM
RE: Arsenal DPS spreadsheet - bural - 03-06-2012, 12:40 AM
RE: Arsenal DPS spreadsheet - Thepixel - 03-06-2012, 04:28 AM
RE: Arsenal DPS spreadsheet - bural - 03-06-2012, 08:56 AM
RE: Arsenal DPS spreadsheet - Rakunvar - 03-08-2012, 03:01 PM
RE: Arsenal DPS spreadsheet - MagicSN - 03-09-2012, 11:05 PM
RE: Arsenal DPS spreadsheet - thrust - 03-14-2012, 06:35 AM
RE: Arsenal DPS spreadsheet - Allah - 03-14-2012, 09:22 AM
RE: Arsenal DPS spreadsheet - thrust - 03-14-2012, 09:40 AM
RE: Arsenal DPS spreadsheet - bural - 03-15-2012, 09:45 PM
RE: Arsenal DPS spreadsheet - Naplam - 03-22-2012, 02:16 PM
RE: Arsenal DPS spreadsheet - Crythe - 04-13-2012, 04:23 AM
RE: Arsenal DPS spreadsheet - Estra - 04-17-2012, 12:58 AM
RE: Arsenal DPS spreadsheet - complexxL9 - 04-27-2012, 07:12 PM

Forum Jump:


User(s) browsing this thread: 1 Guest(s)