Arsenal DPS spreadsheet

[bural]

Regarding Unload:
I've fixed some of the issues, but I simply can't see why Unload is doing lower damage than it does ingame. I have a feeling something really basic is escaping me, so I'm hoping one of you guys would take a look at the Ability DMG of Unload in the CalcsV2 tab. For instance, does it use the correct weapon damage or have I forgot to factor in something stupidly simple? It would make sense the bug related to weapon damage given that it's apparently affecting both Rapid Shots and Unload (and presumably Rail Shot).

Regarding Trooper regen:
Nice work. Would be soooo much easier if the regen rates and intervals turned out to be the same after all. I noticed your version of TV also gives a indicates a slightly different rate.

As 1) and 2) keeps you from testing specific ammo regen intervals, I'd suggest emptying your bar completely and see how long it takes to regen. If the systems works identically and it's UI rounding issues, it should take equally long time to regenerate a full bar. So, use that as a working hypothesis, fill up your bar and see how long it takes to recharge. Make sure to use a backloaded ability as the last ability. If it works the same way as Bounty Hunters, you'll have 3 intervals of 20% and one of 40% where regen is 2,3,4,5% per second respectively, giving you a total regen time of 29.67 seconds. If the 5% interval goes to 33% and not 40%, it should take 29.92 seconds to fully recharge. You're gonna want at least 30fps for the test and the more observations the better although there randomness shouldn't play too large a factor. If the regen rate is higher, it should be easy enough to see.
This should cover the test of 1).

Let's cover 2) and 3) once 1) sorted.

edit: forget what I wrote about trooper regen, it's a brainfart.
Focus instead on http://ge.tt/8HmsRaD and these tests:
Hypothesis1: Trooper regen is different to BH and ability cost is the same 16%
Support if regen time after 10 abilities is 22,6secs
Hypothesis2: Trooper regen is different to BH and ability cost is 2ammo
Support if regen time after 10 abilities is 27,16 secs
Hypothesis3: Trooper regen is identical to BH and ability cost is the same 16%
Support if regen time after 10 abilities is 22,42secs
Hypothesis4: Trooper regen is identical to BH and ability cost is 2ammo
Support if regen time after 10 abilities is 25,42 secs