I've been working on a spreadsheet of my own for my near-total TC of the future WinWW2; and I've punched in all the revelant data for most aircraft guns/cannon for WWII, and have been playing around with some rating schemes...
I'm curious as to what the SPCAMO designers and the other forumites think of my ideas:
I'm thinking of HEK for aircraft guns/cannon as being based around how many kilograms of shells/explosives the weapon can fire in a burst of X seconds, in the table above, I have it set up for 4 second bursts and HEK for non-exploding weapons being equal to the kg per burst, but can change that easily.
I might simply make the HEK effects for .30~ MGs to be 3; while .50~ MGs to be 6; and use the kg/burst rating system for cannons exclusively; I'm still thinking this through.
Explosive-tipped weapons like 20mm cannons or the like get a 50% boost to their HEK because of the fragmentation effects of the exploding rounds.
Accuracy is based upon Muzzle Velocity divided by 60; on the assumption that it's far easier to hit your target with a 1,200 m/sec 37mm BordKanone APCR round than with a 600 m/sec 55mm Mk 112 round.