Alrighty...had to take some of my lunchtime to complete this...here is the modified excel file. Right click to download it.
Gunnery Adjusted QPM excel 2007 fileI added 4 columns for you guys asking for the stuff: 1)visibility, 2)ballistics, 3)ammo, 4)lethality. You can determine which weighting you want. I just left it at 25%/25%/25%/25% for the time being. Adjust as you wish.
The gunnery modifier algorithm is:
A) Derive a gunnery score based on the above factors.
B) Divide this score by the reference score.
C) adjust this score by a scaling factor (user adjustable, currently set at 1/2).
D) mutliply both the X and Y axis by the modified score.
You just now need to go through and set your reference gunnery score, the weighting factors, scaling factor
and go and fill out the visibility, ballistics, ammo, lethality ratings for every airplane. Have fun storming the castle!
I stripped out the exponents for my S/W*P/W*P metric to keep it simple. The gunnery modifier section makes up 60% of the spreadsheet
.