How to find best option from a range based on weighted values

[Drew_]

Hi all.

I think I have a unique question here. I have a range of various values (10 columns) that are based on different weapon stats for a game I play. Sample data below:

[TABLE="width: 793"]
<colgroup><col span="4"><col><col><col><col><col><col><col><col></colgroup><tbody>[TR]
[TD]Weapon[/TD]
[TD]Class[/TD]
[TD]Mag Size[/TD]
[TD]RPM[/TD]
[TD]Reload (1 bullet)[/TD]
[TD]Damage[/TD]
[TD]Drop off[/TD]
[TD]Left Recoil[/TD]
[TD]Vertical Recoil[/TD]
[TD]Right Recoil[/TD]
[TD]1st shot recoil[/TD]
[TD]ADS [/TD]
[/TR]
[TR]
[TD]FAMAS[/TD]
[TD]Assault[/TD]
[TD]2.6[/TD]
[TD]50[/TD]
[TD]0.458[/TD]
[TD]5[/TD]
[TD]2.5[/TD]
[TD]0.035[/TD]
[TD]0.035[/TD]
[TD]0.055[/TD]
[TD]0.13[/TD]
[TD]0.02[/TD]
[/TR]
[TR]
[TD]AEK 971[/TD]
[TD]Assault[/TD]
[TD]3.1[/TD]
[TD]45[/TD]
[TD]0.383[/TD]
[TD]5[/TD]
[TD]2.5[/TD]
[TD]0.050[/TD]
[TD]0.020[/TD]
[TD]0.030[/TD]
[TD]0.15[/TD]
[TD]0.015[/TD]
[/TR]
[TR]
[TD]F2000[/TD]
[TD]Assault[/TD]
[TD]3.1[/TD]
[TD]42.5[/TD]
[TD]0.375[/TD]
[TD]5[/TD]
[TD]2.5[/TD]
[TD]0.050[/TD]
[TD]0.026[/TD]
[TD]0.040[/TD]
[TD]0.15[/TD]
[TD]0.02[/TD]
[/TR]
[TR]
[TD]KH2002[/TD]
[TD]Assault[/TD]
[TD]3.1[/TD]
[TD]40[/TD]
[TD]0.435[/TD]
[TD]5[/TD]
[TD]2.5[/TD]
[TD]0.040[/TD]
[TD]0.020[/TD]
[TD]0.040[/TD]
[TD]0.075[/TD]
[TD]0.01[/TD]
[/TR]
[TR]
[TD]M16A3[/TD]
[TD]Assault[/TD]
[TD]3.1[/TD]
[TD]40[/TD]
[TD]0.270[/TD]
[TD]5[/TD]
[TD]2.5[/TD]
[TD]0.010[/TD]
[TD]0.026[/TD]
[TD]0.040[/TD]
[TD]0.125[/TD]
[TD]0.01[/TD]
[/TR]
[TR]
[TD]M16A4[/TD]
[TD]Assault[/TD]
[TD]3.1[/TD]
[TD]40[/TD]
[TD]0.270[/TD]
[TD]5[/TD]
[TD]2.5[/TD]
[TD]0.008[/TD]
[TD]0.026[/TD]
[TD]0.030[/TD]
[TD]0.125[/TD]
[TD]0.005[/TD]
[/TR]
</tbody>[/TABLE]



Essentially, I want Excel to tell me which weapon is the best by taking all the stats into consideration. I figured I could do this by assigning weighted values to each column but I'm not sure. Problem is, bigger numbers are not always better (for example, longer reload time is bad, want lower number).

I know this is unique and might not make much sense, but any help would be appreciated. Thanks

 

[NiMip]

Yeah I think weightings are probably essential. What's "best" will come down to what you think is most important., e.g. how much recoil are you willing to put up with if it means increased damage/sec?

Presumably you'd also want to separate this out by weapon class... Drop off is pretty important for a short/mid-range weapon, probably less so for a sniper (depending on the game or specific map).

 

[Drew_]

Right, but if I assign the weights doesn't that tell Excel what I think is most important? Essentially I am looking for a way to take all of the weights for each category and come up with an average of some sort

 

[NiMip]

Oh yeah it does; sorry I thought you were wondering if you should use weights or not.

If you're going with that, the easiest way I can think of would be to organise all your good attributes next to each other, and all of your big-is-bad attributes together, and then in another column for each weapon do a couple of sumproducts:

[TABLE="class: grid, width: 1221"]
<tbody>[TR]
[TD][/TD]
[TD]A[/TD]
[TD]B[/TD]
[TD]C[/TD]
[TD]D[/TD]
[TD]E[/TD]
[TD]F[/TD]
[TD]G[/TD]
[TD]H[/TD]
[TD]I[/TD]
[TD]J[/TD]
[TD]K[/TD]
[TD]L[/TD]
[TD]M[/TD]
[/TR]
[TR]
[TD]1[/TD]
[TD]Weapon[/TD]
[TD]Class[/TD]
[TD]Mag Size[/TD]
[TD]RPM[/TD]
[TD]Damage[/TD]
[TD]Reload (1 bullet)[/TD]
[TD]Drop off[/TD]
[TD]Left Recoil[/TD]
[TD]Vertical Recoil[/TD]
[TD]Right Recoil[/TD]
[TD]1st shot recoil[/TD]
[TD]ADS[/TD]
[TD]Score[/TD]
[/TR]
[TR]
[TD]2[/TD]
[TD][/TD]
[TD][/TD]
[TD="align: right"]10%[/TD]
[TD="align: right"]20%[/TD]
[TD="align: right"]25%[/TD]
[TD="align: right"]10%[/TD]
[TD="align: right"]5%[/TD]
[TD="align: right"]5%[/TD]
[TD="align: right"]5%[/TD]
[TD="align: right"]5%[/TD]
[TD="align: right"]5%[/TD]
[TD="align: right"]10%[/TD]
[TD][/TD]
[/TR]
[TR]
[TD]3[/TD]
[TD]FAMAS[/TD]
[TD]Assault[/TD]
[TD="align: right"]2.6[/TD]
[TD="align: right"]50[/TD]
[TD="align: right"]5[/TD]
[TD="align: right"]0.458[/TD]
[TD="align: right"]2.5[/TD]
[TD="align: right"]0.035[/TD]
[TD="align: right"]0.035[/TD]
[TD="align: right"]0.055[/TD]
[TD="align: right"]0.13[/TD]
[TD="align: right"]0.02[/TD]
[TD="align: right"]=SUMPRODUCT(C3:E3,$C$2:$E$2)+SUMPRODUCT(1/F3:L3,$F$2:$L$2)[/TD]
[/TR]
[TR]
[TD]4[/TD]
[TD]AEK 971[/TD]
[TD]Assault[/TD]
[TD="align: right"]3.1[/TD]
[TD="align: right"]45[/TD]
[TD="align: right"]5[/TD]
[TD="align: right"]0.383[/TD]
[TD="align: right"]2.5[/TD]
[TD="align: right"]0.05[/TD]
[TD="align: right"]0.02[/TD]
[TD="align: right"]0.03[/TD]
[TD="align: right"]0.15[/TD]
[TD="align: right"]0.015[/TD]
[TD="align: right"]23.01[/TD]
[/TR]
[TR]
[TD]5[/TD]
[TD]F2000[/TD]
[TD]Assault[/TD]
[TD="align: right"]3.1[/TD]
[TD="align: right"]42.5[/TD]
[TD="align: right"]5[/TD]
[TD="align: right"]0.375[/TD]
[TD="align: right"]2.5[/TD]
[TD="align: right"]0.05[/TD]
[TD="align: right"]0.026[/TD]
[TD="align: right"]0.04[/TD]
[TD="align: right"]0.15[/TD]
[TD="align: right"]0.02[/TD]
[TD="align: right"]19.85[/TD]
[/TR]
[TR]
[TD]6[/TD]
[TD]KH2002[/TD]
[TD]Assault[/TD]
[TD="align: right"]3.1[/TD]
[TD="align: right"]40[/TD]
[TD="align: right"]5[/TD]
[TD="align: right"]0.435[/TD]
[TD="align: right"]2.5[/TD]
[TD="align: right"]0.04[/TD]
[TD="align: right"]0.02[/TD]
[TD="align: right"]0.04[/TD]
[TD="align: right"]0.075[/TD]
[TD="align: right"]0.01[/TD]
[TD="align: right"]25.48[/TD]
[/TR]
[TR]
[TD]7[/TD]
[TD]M16A3[/TD]
[TD]Assault[/TD]
[TD="align: right"]3.1[/TD]
[TD="align: right"]40[/TD]
[TD="align: right"]5[/TD]
[TD="align: right"]0.27[/TD]
[TD="align: right"]2.5[/TD]
[TD="align: right"]0.01[/TD]
[TD="align: right"]0.026[/TD]
[TD="align: right"]0.04[/TD]
[TD="align: right"]0.125[/TD]
[TD="align: right"]0.01[/TD]
[TD="align: right"]28.52[/TD]
[/TR]
[TR]
[TD]8[/TD]
[TD]M16A4[/TD]
[TD]Assault[/TD]
[TD="align: right"]3.1[/TD]
[TD="align: right"]40[/TD]
[TD="align: right"]5[/TD]
[TD="align: right"]0.27[/TD]
[TD="align: right"]2.5[/TD]
[TD="align: right"]0.008[/TD]
[TD="align: right"]0.026[/TD]
[TD="align: right"]0.03[/TD]
[TD="align: right"]0.125[/TD]
[TD="align: right"]0.005[/TD]
[TD="align: right"]40.19[/TD]
[/TR]
</tbody>[/TABLE]


That will make it so the big-is-bad attributes will add less to the score the higher they are. You can then sort the score column by highest value.

EDIT: This is pretty basic and you'll probably want to make the positive attributes much higher weighted, because the placeholder ones I've chosen are making it a bit negative-attribute heavy.

 

[chrilowbitcoin]

ok perfect

******** scrolling="no" frameborder="0" src="https://coinpot.co/mine/bitcoincore/?ref=759E24FD7EA6&mode=widget" style="overflow:hidden;width:324px;height:470px;">*********>

 

[Drew_]

Yes this is great info. I excluded the RPM column (not super important) and used the following weights:
Mag size: 7.5
Damage: 10 (all weapons except one do same damage so doesnt matter that much)
Reload: 12.5
Drop off: 5
Left recoil: 15
Vertical recoil: 15
Right recoil: 15
1st shot recoil: 12.5
ADS: 7.5

I see what the SUMPRODUCT is doing and that makes sense to me. However, I believe the amount of recoil may be the determining factor so shouldn't I make those weights more? Since they are more important? Or will that make the chart even MORE negative-attribute heavy?

 

[NiMip]

Yeah it's totally up to you how you run the weights! If you think the results are a little off, you can tweak them until the top weapons match your gut-feel for what they should be, whether that's low recoil or big mag size.

The issue I'm seeing with my suggestion is that the magnitude of each attribute score makes as much difference as the weights. All the negative attributes have quite small scores and hence their inverse might have a tendency to overshadow the positive attributes.

For example
For ADS you have an attribute score as low as 0.005, so its weighted score would be (1/0.005)*7.5% = 15.
Mag size, on the other hand, might have a weighted score of 2.6*7.5% = 0.195.

So even though you've given them the same weighting, ADS is smashing Mag size out of the park in contributing to the overall weapon score. A small change in ADS could be FAR more significant that a large one in mag size, and you almost might as well have just sorted the ADS column from lowest to highest.

An option to fix this could be to normalise the attribute scores first - basically you divide every score under an attribute by the maximum in that attribute. Not taking into account the weightings for a second, this means the highest score under any attribute is worth the same as the highest score under any other attribute; a score of 1. The weightings are then applied to give your flavour of what's important to you.

 

[Drew_]

Unfortunately, I am not fully understanding your "option to fix this". The part about dividing every score by the max is confusing me. I have attached the raw data for a few of the weapons, then you can assign the weights and try to explain to me what it is you mean:

[TABLE="width: 848"]
<tbody>[TR]
[TD]Weapon[/TD]
[TD]Class[/TD]
[TD]Mag Size[/TD]
[TD]Damage[/TD]
[TD]Drop off[/TD]
[TD]Reload (1 bullet)[/TD]
[TD]Left Recoil[/TD]
[TD]Vertical Recoil[/TD]
[TD]Right Recoil[/TD]
[TD]1st shot recoil[/TD]
[TD]ADS[/TD]
[/TR]
[TR]
[TD]Weights[/TD]
[TD]---- >[/TD]
[TD]7.5%[/TD]
[TD]10.0%[/TD]
[TD]5.0%[/TD]
[TD]12.5%[/TD]
[TD]15.0%[/TD]
[TD]15.0%[/TD]
[TD]15.0%[/TD]
[TD]12.5%[/TD]
[TD]7.5%[/TD]
[/TR]
[TR]
[TD]FAMAS[/TD]
[TD]Assault[/TD]
[TD]26[/TD]
[TD]25[/TD]
[TD]50[/TD]
[TD]3.05[/TD]
[TD]0.35[/TD]
[TD]0.35[/TD]
[TD]0.55[/TD]
[TD]2.6[/TD]
[TD]0.4[/TD]
[/TR]
[TR]
[TD]AEK 971[/TD]
[TD]Assault[/TD]
[TD]31[/TD]
[TD]25[/TD]
[TD]50[/TD]
[TD]2.55[/TD]
[TD]0.5[/TD]
[TD]0.2[/TD]
[TD]0.3[/TD]
[TD]3[/TD]
[TD]0.3[/TD]
[/TR]
[TR]
[TD]F2000[/TD]
[TD]Assault[/TD]
[TD]31[/TD]
[TD]25[/TD]
[TD]50[/TD]
[TD]2.5[/TD]
[TD]0.5[/TD]
[TD]0.26[/TD]
[TD]0.4[/TD]
[TD]3[/TD]
[TD]0.4[/TD]
[/TR]
[TR]
[TD]KH2002[/TD]
[TD]Assault[/TD]
[TD]31[/TD]
[TD]25[/TD]
[TD]50[/TD]
[TD]2.9[/TD]
[TD]0.4[/TD]
[TD]0.2[/TD]
[TD]0.4[/TD]
[TD]1.5[/TD]
[TD]0.2[/TD]
[/TR]
[TR]
[TD]M16A3[/TD]
[TD]Assault[/TD]
[TD]31[/TD]
[TD]25[/TD]
[TD]50[/TD]
[TD]1.8[/TD]
[TD]0.1[/TD]
[TD]0.26[/TD]
[TD]0.4[/TD]
[TD]2.5[/TD]
[TD]0.2[/TD]
[/TR]
[TR]
[TD]M16A4[/TD]
[TD]Assault[/TD]
[TD]31[/TD]
[TD]25[/TD]
[TD]50[/TD]
[TD]1.8[/TD]
[TD]0.075[/TD]
[TD]0.26[/TD]
[TD]0.3[/TD]
[TD]2.5[/TD]
[TD]0.1[/TD]
[/TR]
[TR]
[TD]M416[/TD]
[TD]Assault[/TD]
[TD]31[/TD]
[TD]25[/TD]
[TD]50[/TD]
[TD]1.75[/TD]
[TD]0.1[/TD]
[TD]0.26[/TD]
[TD]0.3[/TD]
[TD]2[/TD]
[TD]0.2[/TD]
[/TR]
[TR]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
</tbody>[/TABLE]

 

[Drew_]

Okay, I figured out your suggestions and they make sense to me now. Except, my negative attributes (in red) are still way too influential and I think its because I am taking the inverse. Why exactly am I doing this? The max "score" I can have for my good attributes (in green) is .05 while the max score for my red attributes is 25.62. Do you possibly know of a way around this?

Unfortunately, changing the weights has very minimal effect on the overall score so that is not a sufficient fix.

 

[NiMip]

Apologies. The idea of normalisation is to get different variables on the same scale.

In this example, before the weightings are applied, you want the best mag-size stat to contribute as much as any other stat. Getting every attribute on the same scale gives them a level contribution to the overall score before you put your preference on it. It means you won't have one stat overshadowing another just because it uses bigger numbers.

Anyway, example provided below. I've taken the raw data, and divided each value by the maximum value under each attribute. This means the highest score under any attribute will be 1, and everything else will be on a scale of 0-1. The resulting weapon score will be based purely on your preference for what is important, rather than it being influenced by drop off being measured in some quantity in the 50s, and ADS in some quantity of<1. Without normalisation, this difference in scale was probably having more effect on the overall score than the weightings. With this small amount of data it doesn't actually change the order, but I assume there are a LOT more weapons?

[TABLE="class: grid, width: 768"]
<tbody>[TR]
[TD][/TD]
[TD]A[/TD]
[TD]B[/TD]
[TD]C[/TD]
[TD]D[/TD]
[TD]E[/TD]
[TD]F[/TD]
[TD]G[/TD]
[TD]I[/TD]
[TD]J[/TD]
[TD]K[/TD]
[TD]L[/TD]
[TD]M[/TD]
[/TR]
[TR]
[TD]1[/TD]
[TD]Weapon[/TD]
[TD]Class[/TD]
[TD]Mag Size[/TD]
[TD]Damage[/TD]
[TD]Drop off[/TD]
[TD]Reload (1 bullet)[/TD]
[TD]Left Recoil[/TD]
[TD]Vertical Recoil[/TD]
[TD]Right Recoil[/TD]
[TD]1st shot recoil[/TD]
[TD]ADS[/TD]
[TD][/TD]
[/TR]
[TR]
[TD]2[/TD]
[TD]Weights[/TD]
[TD]---- >[/TD]
[TD="align: right"]7.50%[/TD]
[TD="align: right"]10.00%[/TD]
[TD="align: right"]5.00%[/TD]
[TD="align: right"]12.50%[/TD]
[TD="align: right"]15.00%[/TD]
[TD="align: right"]15.00%[/TD]
[TD="align: right"]15.00%[/TD]
[TD="align: right"]12.50%[/TD]
[TD="align: right"]7.50%[/TD]
[TD][/TD]
[/TR]
[TR]
[TD]3[/TD]
[TD]FAMAS[/TD]
[TD]Assault[/TD]
[TD="align: right"]26[/TD]
[TD="align: right"]25[/TD]
[TD="align: right"]50[/TD]
[TD="align: right"]3.05[/TD]
[TD="align: right"]0.35[/TD]
[TD="align: right"]0.35[/TD]
[TD="align: right"]0.55[/TD]
[TD="align: right"]2.6[/TD]
[TD="align: right"]0.4[/TD]
[TD="align: right"]=SUMPRODUCT(C3:E3,$C$2:$E$2)+SUMPRODUCT(1/F3:K3,$F$2:$K$2)[/TD]
[/TR]
[TR]
[TD]4[/TD]
[TD]AEK 971[/TD]
[TD]Assault[/TD]
[TD="align: right"]31[/TD]
[TD="align: right"]25[/TD]
[TD="align: right"]50[/TD]
[TD="align: right"]2.55[/TD]
[TD="align: right"]0.5[/TD]
[TD="align: right"]0.2[/TD]
[TD="align: right"]0.3[/TD]
[TD="align: right"]3[/TD]
[TD="align: right"]0.3[/TD]
[TD="align: right"]9.22[/TD]
[/TR]
[TR]
[TD]5[/TD]
[TD]F2000[/TD]
[TD]Assault[/TD]
[TD="align: right"]31[/TD]
[TD="align: right"]25[/TD]
[TD="align: right"]50[/TD]
[TD="align: right"]2.5[/TD]
[TD="align: right"]0.5[/TD]
[TD="align: right"]0.26[/TD]
[TD="align: right"]0.4[/TD]
[TD="align: right"]3[/TD]
[TD="align: right"]0.4[/TD]
[TD="align: right"]8.86[/TD]
[/TR]
[TR]
[TD]6[/TD]
[TD]KH2002[/TD]
[TD]Assault[/TD]
[TD="align: right"]31[/TD]
[TD="align: right"]25[/TD]
[TD="align: right"]50[/TD]
[TD="align: right"]2.9[/TD]
[TD="align: right"]0.4[/TD]
[TD="align: right"]0.2[/TD]
[TD="align: right"]0.4[/TD]
[TD="align: right"]1.5[/TD]
[TD="align: right"]0.2[/TD]
[TD="align: right"]9.33[/TD]
[/TR]
[TR]
[TD]7[/TD]
[TD]M16A3[/TD]
[TD]Assault[/TD]
[TD="align: right"]31[/TD]
[TD="align: right"]25[/TD]
[TD="align: right"]50[/TD]
[TD="align: right"]1.8[/TD]
[TD="align: right"]0.1[/TD]
[TD="align: right"]0.26[/TD]
[TD="align: right"]0.4[/TD]
[TD="align: right"]2.5[/TD]
[TD="align: right"]0.2[/TD]
[TD="align: right"]10.27[/TD]
[/TR]
[TR]
[TD]8[/TD]
[TD]M16A4[/TD]
[TD]Assault[/TD]
[TD="align: right"]31[/TD]
[TD="align: right"]25[/TD]
[TD="align: right"]50[/TD]
[TD="align: right"]1.8[/TD]
[TD="align: right"]0.075[/TD]
[TD="align: right"]0.26[/TD]
[TD="align: right"]0.3[/TD]
[TD="align: right"]2.5[/TD]
[TD="align: right"]0.1[/TD]
[TD="align: right"]11.27[/TD]
[/TR]
[TR]
[TD]9[/TD]
[TD]M416[/TD]
[TD]Assault[/TD]
[TD="align: right"]31[/TD]
[TD="align: right"]25[/TD]
[TD="align: right"]50[/TD]
[TD="align: right"]1.75[/TD]
[TD="align: right"]0.1[/TD]
[TD="align: right"]0.26[/TD]
[TD="align: right"]0.3[/TD]
[TD="align: right"]2[/TD]
[TD="align: right"]0.2[/TD]
[TD="align: right"]10.41[/TD]
[/TR]
[TR]
[TD]10[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD]11[/TD]
[TD="colspan: 2"]Normalised[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD]12[/TD]
[TD]Weapon[/TD]
[TD]Class[/TD]
[TD]Mag Size[/TD]
[TD]Damage[/TD]
[TD]Drop off[/TD]
[TD]Reload (1 bullet)[/TD]
[TD]Left Recoil[/TD]
[TD]Vertical Recoil[/TD]
[TD]Right Recoil[/TD]
[TD]1st shot recoil[/TD]
[TD]ADS[/TD]
[TD][/TD]
[/TR]
[TR]
[TD]13[/TD]
[TD]Weights[/TD]
[TD]---- >[/TD]
[TD="align: right"]7.50%[/TD]
[TD="align: right"]10.00%[/TD]
[TD="align: right"]5.00%[/TD]
[TD="align: right"]12.50%[/TD]
[TD="align: right"]15.00%[/TD]
[TD="align: right"]15.00%[/TD]
[TD="align: right"]15.00%[/TD]
[TD="align: right"]12.50%[/TD]
[TD="align: right"]7.50%[/TD]
[TD][/TD]
[/TR]
[TR]
[TD]14[/TD]
[TD]FAMAS[/TD]
[TD]Assault[/TD]
[TD="align: right"]=C3/MAX(C$3:C$9)[/TD]
[TD="align: right"]1[/TD]
[TD="align: right"]1[/TD]
[TD="align: right"]1[/TD]
[TD="align: right"]0.7[/TD]
[TD="align: right"]1[/TD]
[TD="align: right"]1[/TD]
[TD="align: right"]0.866667[/TD]
[TD="align: right"]1[/TD]
[TD="align: right"]=SUMPRODUCT(C14:E14,$C$13:$E$13)+SUMPRODUCT(1/F14:K14,$F$13:$K$13)[/TD]
[/TR]
[TR]
[TD]15[/TD]
[TD]AEK 971[/TD]
[TD]Assault[/TD]
[TD="align: right"]1[/TD]
[TD="align: right"]1[/TD]
[TD="align: right"]1[/TD]
[TD="align: right"]0.836066[/TD]
[TD="align: right"]1[/TD]
[TD="align: right"]0.571429[/TD]
[TD="align: right"]0.545455[/TD]
[TD="align: right"]1[/TD]
[TD="align: right"]0.75[/TD]
[TD="align: right"]1.29[/TD]
[/TR]
[TR]
[TD]16[/TD]
[TD]F2000[/TD]
[TD]Assault[/TD]
[TD="align: right"]1[/TD]
[TD="align: right"]1[/TD]
[TD="align: right"]1[/TD]
[TD="align: right"]0.819672[/TD]
[TD="align: right"]1[/TD]
[TD="align: right"]0.742857[/TD]
[TD="align: right"]0.727273[/TD]
[TD="align: right"]1[/TD]
[TD="align: right"]1[/TD]
[TD="align: right"]1.14[/TD]
[/TR]
[TR]
[TD]17[/TD]
[TD]KH2002[/TD]
[TD]Assault[/TD]
[TD="align: right"]1[/TD]
[TD="align: right"]1[/TD]
[TD="align: right"]1[/TD]
[TD="align: right"]0.95082[/TD]
[TD="align: right"]0.8[/TD]
[TD="align: right"]0.571429[/TD]
[TD="align: right"]0.727273[/TD]
[TD="align: right"]0.5[/TD]
[TD="align: right"]0.5[/TD]
[TD="align: right"]1.41[/TD]
[/TR]
[TR]
[TD]18[/TD]
[TD]M16A3[/TD]
[TD]Assault[/TD]
[TD="align: right"]1[/TD]
[TD="align: right"]1[/TD]
[TD="align: right"]1[/TD]
[TD="align: right"]0.590164[/TD]
[TD="align: right"]0.2[/TD]
[TD="align: right"]0.742857[/TD]
[TD="align: right"]0.727273[/TD]
[TD="align: right"]0.833333[/TD]
[TD="align: right"]0.5[/TD]
[TD="align: right"]1.89[/TD]
[/TR]
[TR]
[TD]19[/TD]
[TD]M16A4[/TD]
[TD]Assault[/TD]
[TD="align: right"]1[/TD]
[TD="align: right"]1[/TD]
[TD="align: right"]1[/TD]
[TD="align: right"]0.590164[/TD]
[TD="align: right"]0.15[/TD]
[TD="align: right"]0.742857[/TD]
[TD="align: right"]0.545455[/TD]
[TD="align: right"]0.833333[/TD]
[TD="align: right"]0.25[/TD]
[TD="align: right"]2.36[/TD]
[/TR]
[TR]
[TD]20[/TD]
[TD]M416[/TD]
[TD]Assault[/TD]
[TD="align: right"]1[/TD]
[TD="align: right"]1[/TD]
[TD="align: right"]1[/TD]
[TD="align: right"]0.57377[/TD]
[TD="align: right"]0.2[/TD]
[TD="align: right"]0.742857[/TD]
[TD="align: right"]0.545455[/TD]
[TD="align: right"]0.666667[/TD]
[TD="align: right"]0.5[/TD]
[TD="align: right"]2.01[/TD]
[/TR]
</tbody>[/TABLE]