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

Hello There, Guest! Register

 DPS Excel calculator for Sorcerer / Sage
01-12-2012, 05:36 AM (This post was last modified: 01-12-2012 05:40 AM by Kaedis.)
Post: #29
 Kaedis Super Moderator Posts: 1,587 Joined: Sep 2011 Reputation: 7
RE: DPS Excel calculator for SI Sorcerer
Quote:In the Rotation sheet it appears that Lightning Barrage'd Force Lightnings are being cast every 10 seconds whenever Lightning Barrage is taken and Affliction is up, which I believe is unreasonable. My understanding of the skill was that it had a 10 second cool down then needed an Affliction tick to crit to get the buff. Is that understanding incorrect? I remember reading a post from Kor where he roughed out some math around that phenomenon but now I can't find it.

That's correct. Average time between procs = 9 + 3 / CritChance. Example, at 30% crit chance, average time between procs is 9 + 3/.3 = 19 seconds.

Reasoning behind the equation: the equation for average time between procs is TimeBetweenAttacks/ProcChance. An ICD simply adds a period of time in which that's not possible, so the equation for average time between ICD effects is ICD + TimeBetweenAttacks/ProcChance. Even though ICD is 10, it effectively is 9 (the 9 second tick is the last ineligible tick). At 100% crit, this would give 9 + 3/1 = 12 second, which is exactly how often it would proc at 100% proc chance per tick outside of the ICD.

Incidentally, this means that the dps benefit of Lightning Barrage, assuming you use every proc, is equal to (ForceLightingDamage*0.5)/(9 + 3 / CritChance), or ForceLightingDamage/(9 + 3 / CritChance) if you use the double-barrage bug every time. This is because a Barrage FL deals the full damage of FL in half the time, effectively dealing half of the damage of the channel "extra" during that time. If you double-barrage, you've cast two FLs in the span of 1, gaining an every FL's worth of damage per proc.

To put it another way, since a Barrage'd FL takes the place of a normal FL, you basically get the difference in DPCT for the duration. For a single Barrage, that's double the DPCT for half the time, minus the DPCT of FL, meaning you gain the DPCT of FL times half it's normal duration, or half the damage of a full FL. Double-barrages gain twice this value.

Even Angels must kill from time to time...
 « Next Oldest | Next Newest »

 Messages In This Thread DPS Excel calculator for Sorcerer / Sage - lostdummy - 01-06-2012, 10:16 PM RE: DPS Excel calculator for SI Sorcerer - CaseyTheRetard - 01-07-2012, 04:35 AM RE: DPS Excel calculator for SI Sorcerer - Kaedis - 01-07-2012, 04:45 AM RE: DPS Excel calculator for SI Sorcerer - CaseyTheRetard - 01-07-2012, 05:42 AM RE: DPS Excel calculator for SI Sorcerer - lostdummy - 01-07-2012, 08:53 AM RE: DPS Excel calculator for SI Sorcerer - CaseyTheRetard - 01-07-2012, 10:14 AM RE: DPS Excel calculator for SI Sorcerer - Kaedis - 01-07-2012, 10:51 AM RE: DPS Excel calculator for SI Sorcerer - lostdummy - 01-07-2012, 09:21 PM RE: DPS Excel calculator for SI Sorcerer - lostdummy - 01-08-2012, 02:50 AM RE: DPS Excel calculator for SI Sorcerer - Kaedis - 01-08-2012, 04:34 AM RE: DPS Excel calculator for SI Sorcerer - lostdummy - 01-08-2012, 04:42 AM RE: DPS Excel calculator for SI Sorcerer - Kaedis - 01-08-2012, 05:20 AM RE: DPS Excel calculator for SI Sorcerer - Kaedis - 01-08-2012, 09:11 AM RE: DPS Excel calculator for SI Sorcerer - lostdummy - 01-08-2012, 10:28 AM RE: DPS Excel calculator for SI Sorcerer - Kaedis - 01-08-2012, 10:30 AM RE: DPS Excel calculator for SI Sorcerer - lostdummy - 01-08-2012, 11:00 AM RE: DPS Excel calculator for SI Sorcerer - Kaedis - 01-08-2012, 12:05 PM RE: DPS Excel calculator for SI Sorcerer - lostdummy - 01-08-2012, 08:46 PM RE: DPS Excel calculator for SI Sorcerer - lostdummy - 01-11-2012, 10:20 PM RE: DPS Excel calculator for SI Sorcerer - lostdummy - 01-08-2012, 09:43 PM RE: DPS Excel calculator for SI Sorcerer - Pestulan - 01-09-2012, 04:37 PM RE: DPS Excel calculator for SI Sorcerer - lostdummy - 01-09-2012, 07:09 PM RE: DPS Excel calculator for SI Sorcerer - Lucai - 01-10-2012, 03:32 PM RE: DPS Excel calculator for SI Sorcerer - lostdummy - 01-10-2012, 07:10 PM RE: DPS Excel calculator for SI Sorcerer - frmorrison - 01-10-2012, 04:09 PM RE: DPS Excel calculator for SI Sorcerer - lostdummy - 01-10-2012, 07:35 PM RE: DPS Excel calculator for SI Sorcerer - Pestulan - 01-11-2012, 12:39 PM RE: DPS Excel calculator for SI Sorcerer - Erasmian - 01-12-2012, 05:27 AM RE: DPS Excel calculator for SI Sorcerer - lostdummy - 01-12-2012, 08:31 AM RE: DPS Excel calculator for SI Sorcerer - Kaedis - 01-12-2012 05:36 AM RE: DPS Excel calculator for SI Sorcerer - lostdummy - 01-13-2012, 01:03 AM RE: DPS Excel calculator for SI Sorcerer - Saitta - 01-13-2012, 04:30 AM RE: DPS Excel calculator for SI Sorcerer - lostdummy - 01-13-2012, 06:30 AM RE: DPS Excel calculator for SI Sorcerer - frmorrison - 01-13-2012, 07:05 AM RE: DPS Excel calculator for SI Sorcerer - Lucai - 01-13-2012, 07:21 AM RE: DPS Excel calculator for SI Sorcerer - CaseyTheRetard - 01-13-2012, 07:46 AM RE: DPS Excel calculator for SI Sorcerer - lostdummy - 01-13-2012, 08:08 AM RE: DPS Excel calculator for SI Sorcerer - CaseyTheRetard - 01-13-2012, 08:47 AM RE: DPS Excel calculator for SI Sorcerer - lostdummy - 01-13-2012, 09:18 AM RE: DPS Excel calculator for SI Sorcerer - CaseyTheRetard - 01-13-2012, 09:24 AM RE: DPS Excel calculator for SI Sorcerer - lostdummy - 01-13-2012, 10:26 AM RE: DPS Excel calculator for SI Sorcerer - CaseyTheRetard - 01-14-2012, 12:51 AM RE: DPS Excel calculator for SI Sorcerer - lostdummy - 01-14-2012, 01:36 AM RE: DPS Excel calculator for SI Sorcerer - lostdummy - 01-14-2012, 09:36 PM RE: DPS Excel calculator for SI Sorcerer - Kaedis - 01-15-2012, 01:48 AM RE: DPS Excel calculator for SI Sorcerer - lostdummy - 01-16-2012, 07:29 AM RE: DPS Excel calculator for SI Sorcerer - lostdummy - 01-19-2012, 11:08 PM RE: DPS Excel calculator for SI Sorcerer - DPSFTW - 01-20-2012, 03:09 AM RE: DPS Excel calculator for SI Sorcerer - frmorrison - 01-20-2012, 06:07 AM RE: DPS Excel calculator for SI Sorcerer - lostdummy - 01-20-2012, 11:31 PM RE: DPS Excel calculator for SI Sorcerer - CaseyTheRetard - 01-21-2012, 05:24 AM RE: DPS Excel calculator for SI Sorcerer - lostdummy - 01-21-2012, 06:38 AM RE: DPS Excel calculator for SI Sorcerer - lostdummy - 01-24-2012, 11:58 PM RE: DPS Excel calculator for SI Sorcerer - Caltiom - 01-25-2012, 06:06 PM RE: DPS Excel calculator for SI Sorcerer - lostdummy - 01-25-2012, 07:15 PM RE: DPS Excel calculator for Sorcerer / Sage - Kaedis - 01-26-2012, 01:29 AM RE: DPS Excel calculator for Sorcerer / Sage - Armageddus - 01-26-2012, 10:37 AM RE: DPS Excel calculator for Sorcerer / Sage - lostdummy - 01-26-2012, 07:47 PM RE: DPS Excel calculator for Sorcerer / Sage - lostdummy - 01-26-2012, 08:43 PM RE: DPS Excel calculator for Sorcerer / Sage - runlevelsix - 01-27-2012, 12:13 AM RE: DPS Excel calculator for Sorcerer / Sage - lostdummy - 01-27-2012, 12:52 AM RE: DPS Excel calculator for Sorcerer / Sage - haldirgoth - 01-26-2012, 11:47 PM RE: DPS Excel calculator for Sorcerer / Sage - lostdummy - 01-27-2012, 01:08 AM RE: DPS Excel calculator for Sorcerer / Sage - frmorrison - 01-27-2012, 05:55 AM RE: DPS Excel calculator for Sorcerer / Sage - lostdummy - 01-27-2012, 07:16 PM RE: DPS Excel calculator for Sorcerer / Sage - CaseyTheRetard - 01-31-2012, 03:33 AM RE: DPS Excel calculator for Sorcerer / Sage - Khadroth - 01-31-2012, 11:55 PM RE: DPS Excel calculator for Sorcerer / Sage - Armageddus - 01-27-2012, 10:49 AM RE: DPS Excel calculator for Sorcerer / Sage - CaseyTheRetard - 01-28-2012, 04:37 AM RE: DPS Excel calculator for Sorcerer / Sage - lostdummy - 01-30-2012, 11:41 PM RE: DPS Excel calculator for Sorcerer / Sage - frmorrison - 02-01-2012, 03:35 AM RE: DPS Excel calculator for Sorcerer / Sage - Khadroth - 02-01-2012, 03:49 AM RE: DPS Excel calculator for Sorcerer / Sage - zii - 02-02-2012, 08:06 AM RE: DPS Excel calculator for Sorcerer / Sage - CaseyTheRetard - 02-02-2012, 09:13 AM RE: DPS Excel calculator for Sorcerer / Sage - zii - 02-02-2012, 12:47 PM RE: DPS Excel calculator for Sorcerer / Sage - frmorrison - 02-02-2012, 03:47 PM RE: DPS Excel calculator for Sorcerer / Sage - Bored - 02-02-2012, 11:01 PM RE: DPS Excel calculator for Sorcerer / Sage - zii - 02-03-2012, 04:18 AM RE: DPS Excel calculator for Sorcerer / Sage - CaseyTheRetard - 02-03-2012, 05:00 AM RE: DPS Excel calculator for Sorcerer / Sage - Erasmian - 02-08-2012, 03:58 AM RE: DPS Excel calculator for Sorcerer / Sage - CaseyTheRetard - 02-08-2012, 04:07 AM RE: DPS Excel calculator for Sorcerer / Sage - lostdummy - 02-09-2012, 08:28 PM RE: DPS Excel calculator for Sorcerer / Sage - Paavo - 02-07-2012, 01:30 AM RE: DPS Excel calculator for Sorcerer / Sage - CaseyTheRetard - 02-07-2012, 02:44 AM RE: DPS Excel calculator for Sorcerer / Sage - lostdummy - 02-07-2012, 09:57 PM RE: DPS Excel calculator for Sorcerer / Sage - frmorrison - 02-07-2012, 02:45 AM RE: DPS Excel calculator for Sorcerer / Sage - Kaedis - 02-07-2012, 05:12 AM RE: DPS Excel calculator for Sorcerer / Sage - frmorrison - 02-08-2012, 03:18 AM RE: DPS Excel calculator for Sorcerer / Sage - Kaedis - 02-09-2012, 08:47 PM RE: DPS Excel calculator for Sorcerer / Sage - lostdummy - 02-09-2012, 09:09 PM RE: DPS Excel calculator for Sorcerer / Sage - lostdummy - 02-15-2012, 01:47 AM RE: DPS Excel calculator for Sorcerer / Sage - semirage - 02-16-2012, 08:26 PM RE: DPS Excel calculator for Sorcerer / Sage - alencooperr - 02-16-2012, 09:13 AM RE: DPS Excel calculator for Sorcerer / Sage - Kaedis - 02-16-2012, 09:10 PM RE: DPS Excel calculator for Sorcerer / Sage - semirage - 02-16-2012, 09:41 PM RE: DPS Excel calculator for Sorcerer / Sage - Lucai - 02-17-2012, 03:13 AM RE: DPS Excel calculator for Sorcerer / Sage - Armageddus - 02-17-2012, 10:03 PM RE: DPS Excel calculator for Sorcerer / Sage - lacerated - 02-17-2012, 11:50 PM RE: DPS Excel calculator for Sorcerer / Sage - tyfon - 02-18-2012, 08:18 AM RE: DPS Excel calculator for Sorcerer / Sage - frmorrison - 02-18-2012, 08:48 AM RE: DPS Excel calculator for Sorcerer / Sage - Kaedis - 02-18-2012, 08:28 AM RE: DPS Excel calculator for Sorcerer / Sage - kutmulc472 - 02-25-2012, 01:29 AM RE: DPS Excel calculator for Sorcerer / Sage - Kaedis - 02-25-2012, 07:46 AM RE: DPS Excel calculator for Sorcerer / Sage - odlaw - 03-12-2012, 01:44 AM RE: DPS Excel calculator for Sorcerer / Sage - lostdummy - 03-19-2012, 11:27 PM RE: DPS Excel calculator for Sorcerer / Sage - sipylus - 03-14-2012, 12:51 PM RE: DPS Excel calculator for Sorcerer / Sage - Kaedis - 03-14-2012, 03:48 PM RE: DPS Excel calculator for Sorcerer / Sage - lostdummy - 03-19-2012, 11:43 PM RE: DPS Excel calculator for Sorcerer / Sage - Kaedis - 03-20-2012, 12:08 AM RE: DPS Excel calculator for Sorcerer / Sage - frmorrison - 03-20-2012, 01:25 AM RE: DPS Excel calculator for Sorcerer / Sage - lostdummy - 03-20-2012, 04:12 AM RE: DPS Excel calculator for Sorcerer / Sage - Kaedis - 03-20-2012, 02:23 AM RE: DPS Excel calculator for Sorcerer / Sage - CaseyTheRetard - 03-20-2012, 06:32 AM RE: DPS Excel calculator for Sorcerer / Sage - TheDarkness - 03-20-2012, 12:46 PM RE: DPS Excel calculator for Sorcerer / Sage - Kaedis - 03-20-2012, 04:36 AM RE: DPS Excel calculator for Sorcerer / Sage - lostdummy - 03-20-2012, 04:40 AM RE: DPS Excel calculator for Sorcerer / Sage - Kaedis - 03-20-2012, 04:48 AM RE: DPS Excel calculator for Sorcerer / Sage - lostdummy - 03-20-2012, 05:22 AM RE: DPS Excel calculator for Sorcerer / Sage - Kaedis - 03-20-2012, 06:44 AM RE: DPS Excel calculator for Sorcerer / Sage - lostdummy - 03-20-2012, 07:13 PM RE: DPS Excel calculator for Sorcerer / Sage - CaseyTheRetard - 03-21-2012, 01:50 AM RE: DPS Excel calculator for Sorcerer / Sage - sipylus - 03-20-2012, 07:51 AM RE: DPS Excel calculator for Sorcerer / Sage - lostdummy - 03-20-2012, 06:45 PM RE: DPS Excel calculator for Sorcerer / Sage - lostdummy - 03-21-2012, 05:10 AM RE: DPS Excel calculator for Sorcerer / Sage - CaseyTheRetard - 03-21-2012, 05:31 AM RE: DPS Excel calculator for Sorcerer / Sage - lostdummy - 03-21-2012, 06:10 AM RE: DPS Excel calculator for Sorcerer / Sage - lostdummy - 03-22-2012, 12:12 AM RE: DPS Excel calculator for Sorcerer / Sage - Caltiom - 03-22-2012, 12:42 AM RE: DPS Excel calculator for Sorcerer / Sage - lostdummy - 03-22-2012, 01:08 AM RE: DPS Excel calculator for Sorcerer / Sage - CaseyTheRetard - 03-22-2012, 01:26 AM RE: DPS Excel calculator for Sorcerer / Sage - lostdummy - 03-22-2012, 01:35 AM RE: DPS Excel calculator for Sorcerer / Sage - CaseyTheRetard - 03-22-2012, 01:12 AM RE: DPS Excel calculator for Sorcerer / Sage - CaseyTheRetard - 03-22-2012, 01:49 AM RE: DPS Excel calculator for Sorcerer / Sage - CaseyTheRetard - 03-22-2012, 02:04 AM RE: DPS Excel calculator for Sorcerer / Sage - lostdummy - 03-22-2012, 03:17 AM RE: DPS Excel calculator for Sorcerer / Sage - CaseyTheRetard - 03-22-2012, 04:13 AM RE: DPS Excel calculator for Sorcerer / Sage - lostdummy - 03-22-2012, 04:58 AM RE: DPS Excel calculator for Sorcerer / Sage - CaseyTheRetard - 03-22-2012, 06:12 AM RE: DPS Excel calculator for Sorcerer / Sage - lostdummy - 03-22-2012, 06:56 AM RE: DPS Excel calculator for Sorcerer / Sage - CaseyTheRetard - 03-22-2012, 07:14 AM RE: DPS Excel calculator for Sorcerer / Sage - lostdummy - 03-22-2012, 07:56 AM RE: DPS Excel calculator for Sorcerer / Sage - CaseyTheRetard - 03-22-2012, 08:33 AM RE: DPS Excel calculator for Sorcerer / Sage - lostdummy - 03-22-2012, 07:20 PM RE: DPS Excel calculator for Sorcerer / Sage - Caltiom - 03-22-2012, 08:35 PM RE: DPS Excel calculator for Sorcerer / Sage - lostdummy - 03-22-2012, 09:21 PM RE: DPS Excel calculator for Sorcerer / Sage - Caltiom - 03-22-2012, 10:40 PM RE: DPS Excel calculator for Sorcerer / Sage - lostdummy - 03-23-2012, 12:24 AM RE: DPS Excel calculator for Sorcerer / Sage - CaseyTheRetard - 03-23-2012, 01:14 AM RE: DPS Excel calculator for Sorcerer / Sage - lostdummy - 03-23-2012, 02:11 AM RE: DPS Excel calculator for Sorcerer / Sage - CaseyTheRetard - 03-23-2012, 04:37 AM RE: DPS Excel calculator for Sorcerer / Sage - lostdummy - 03-23-2012, 06:14 AM RE: DPS Excel calculator for Sorcerer / Sage - CaseyTheRetard - 03-23-2012, 07:20 AM RE: DPS Excel calculator for Sorcerer / Sage - lostdummy - 03-23-2012, 06:58 PM RE: DPS Excel calculator for Sorcerer / Sage - Torinth - 07-11-2012, 05:22 AM RE: DPS Excel calculator for Sorcerer / Sage - Atreas - 03-13-2013, 12:27 AM

Forum Jump:

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