The coloring was removed for values containing parenthesis. This is because the conditional formating in excel can only format cells containing numbers, not strings.
Ranges to kill for guns with rapid fire was added (they are in parenthesis). Some minor adjustments to the range values were also made.
Removed rows for the Select Fire variations of each weapon except for SWAT-556.
SWAT-556's min damage was correctly calculated as 24 instead of the previous 30.
Supressor and Long Barrel range multipliers were added for each weapon class.
Sniper and headshot multipliers were added (credit to Marvel4).
Time to kill was calculated for each weapon in the form X - Y where X is the time to kill at max damage and Y is the time to kill at min damage. The times were calculated using the formula: T = 1001*(GAP*(BULLETS-1)+BULLETS)/60000
Fast mag values were removed to make the table smaller. Columns were given variable widths for the same reason. The table was also resized to roughly fit a 16:9 aspect ratio for better display.
i see what you did there with 16:9 ratio and i love it marvel (or someone else) did hipfire spread for each gun (i believe) so an idea would be to add the numbers for laser, and crouch/prone/walking for hipfire, and extend the bottom with notes and you can keep the 16:9 ratio
The coloring was removed for values containing parenthesis. This is because the conditional formatting in excel can only format cells containing numbers, not strings.
Marvel4 has apparently gotten higher rates of fire for the semi-auto FAL and SMR, as well as for the Five-seveN and Tac-45, than what your table shows. FAL - 625RPM (600 at 60FPS) SMR - 535RPM (515) Five-seveN - 750RPM (720) Tac-45 - 625RPM (600)
He's also gotten burst delays, if your interested in adding that: SWAT - 0.2s M8A1 - 0.12s Chicom - None (less than 0.01s if any) B23R - 0.064s
Also, HAMR's first 7 shots are at 937.5RPM (900), unaffected by Rapid Fire. That's something else you might like to add.
Just to add to the questions: What units are these ranges measured in? In previous COD's ranges have always been measured just below and above 1,000 units (regardless of real life equivalents) but now all of a sudden, Black Ops II measurements are giving units in 10's and low-100's.
Hoping that someone understands my point, any light on why the units have gone from 100's and 1,000's to 10's and 100's would be greatly appreciated!
Last Edit: Nov 21, 2012 16:19:53 GMT -5 by Tyzerra
I'm pretty sure you were right with your first response Mega. Multiplying all these ranges by 12 to get them in inches (close to usual COD units) puts them more in-line with other COD games. Until either Pwnsweet or Corpse respond to this, I'm just gonna assume these ranges are in feet.
Last Edit: Nov 21, 2012 16:55:37 GMT -5 by Tyzerra