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
03-05-2012, 02:22 AM
Post: #65
RE: Arsenal DPS spreadsheet
(03-05-2012 12:51 AM)bural Wrote:  Sorry I've been missing in action lately. Had a busy week. Should have time to have a look in the upcoming week though.

My rotation for the burn cycle is Vent Heat>TSO>RS>HSM>Unload>TM. Admittedly, that section of the list has alot of clutter from intermediate calculations that nolonger serves a purpose. However, the sheet breaks down fight time into chunks casting different abilities. After subtracting time spend on Vent Heat and TSO casts, Rail and HSM time is deducted to give a time interval for Unload+TM. This time interval is split to ensure 1/0.3 TM casts per Unload. From here I deduce the number of casts of each ability and consequently the heat spenditure over a given fight duration. Dividing Heat spenditure with fight duration I get the required HPS to maintain the cycle (which is obviously well above the a sustainable level). Additionally, I can calculate the effective average heat dispersion (or whatever we call resource regeneration). The difference between these two numbers forms the basis for the uptime of the Rapid Shots including rotation, which prioritizes Vent Heat>TSO>RS>HSM>Unload>Heat Signature>Rapid Shots i.e. it solely casts Rapid Shots as filler and only uses 1 TM every 15 secs to maintain Heat Signature.

With our usual conjecture of "the damage increase from Alacrity comes from an increase in the damage contribution of Rapid Shot", setting the damage of rapid shots to 0 should indeed make EP_Alacrity zero. I'm trying to think of secondary effects that might cause it to be negative, but as the sheet is purely working on averages atm, I can't think of a reasonable explanation.


I'll revisit the calculations and get back to you. While we are at it: any idea whether relic procs uses tech or ranged crit?

I'm not sure how you are doing your rotation decisions or calculations, but one possible cause, based on what I've seen in my simulations, is that the increased Effective Cost with increased Alacrity (less regen while casting, so the "out of pocket" cost goes up) can result in small decreases in the non-filler abilities, especially if it causes you to clip a regen threshold. This can be masked by the increased filler use, but once filler is set to 0, you would then see a slight negative in those rating bands.
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)