Okay, finally got my Excel concatenate statement to mirror your format and paste into this little box correctly.
Stats are fun, here are my weapon stats ordered by average damage per match descending.
I'm a little surprised the UAC5s are so much higher than everything else, but everything else isn't my 3 UAC5 Muromets. And Yes, I love MPLAS. Blame MW2.
ULTRA AC/5 at accuracy 56.67% for 365.69 per match
MED PULSE LASER at accuracy 89.99% for 270.27 per match
PPC at accuracy 58.67% for 257.25 per match
SRM 6 at accuracy 53.68% for 228.12 per match
AC/5 at accuracy 66.21% for 219.05 per match
ER PPC at accuracy 60.14% for 218.01 per match
SML PULSE LASER at accuracy 86.08% for 217.51 per match
ER LARGE LASER at accuracy 78.79% for 207.62 per match
LARGE LASER at accuracy 86.39% for 207.35 per match
AC/20 at accuracy 71.87% for 204.43 per match
LRM 15 at accuracy 34.77% for 193.65 per match
AC/2 at accuracy 62.65% for 191.17 per match
LRG PULSE LASER at accuracy 82.83% for 185.63 per match
AC/10 at accuracy 72.2% for 162.93 per match
GAUSS RIFLE at accuracy 61.67% for 162.8 per match
LB 10-X AC at accuracy 64.37% for 157.6 per match
LRM 10 at accuracy 35.02% for 141.64 per match
MEDIUM LASER at accuracy 88.89% for 130.17 per match
If anyone else wants to play, you can copy/paste your stats into excel. This is the concatenate statement I used, "=CONCATENATE(A2," at accuracy ",(C2*100),"% for ",ROUND(E2,2)," per match")"
The A Column should have your weapon name.
The B Column should hold your matches used.
The C Column should have your accuracy.
The D Column should have your total damage.
The E column should be a calculation of damage/matches played (=D2/B2)
Copy the column with the concat into Notepad and then paste it into the MWO forum editor.
I also removed weapons like AMS, Narc, TAG.
Edited by Atomicoxen, 17 August 2013 - 06:58 AM.
0
