Was kicking around the ideas last night. Think the work you did was very good. A great starting point. Is there a counter work that you could combine (something that shows the losses on a given day by German Aircraft) that would give depth to the numbers you list.
I have done so to a limited degree. An example is also presented on Mike Williams' site under April 24, 1944 Mission. Huge help from several people - notably Erich, Dr. Caldwell and several others.
In this example it is easy to do two things - 1. match up USAAF Awards for 8th FC claims versus referenced Number of losses, and 2.) discover a very large % of over claim on part of LW on both Mustangs and B-17's in this battle. The key problem on the Awards for the 355th FG and 357th FG around Munich is that, if correct, it does not leave more than 4-6 valid awards for the bombers!
My point of questioning is of the data supporting any conclusions at all. As listed, it is simply data on victories claimed by American Fighter Groups. We are talking about the WW2 stats. What was the numberical effect on the opposing fighter groups. It might then lead to better interpertation.
Valid question and may never be truly answered. Dr. Prien confirmed my assumptions regarding the record keeping policies of the LW on a/c damaged/repairable, damaged/scrapped(>60% usually), destroyed. This helped me understand why many LW researchers held a view that USAAF claims (Fighters) are grossly overstated...
For example a 109 shot down by a Mustang on the deck and crash lands, is legitimately assigned credit for an 'a/c destroyed' (based on 8th FC award policies). But that a/c may have been repaired. It will go on LW books as damaged in a air battle but will not be recorded as a 'loss' and won't be a 'destroyed' in LW recording even if it is scrapped.
We had the same policy for Cat E battle damaged a/c if it limped back to friendly territory so some of the claims for USAAF 'shot down' by LW, may not have resulted in lost crew, but many of those that got home never flew again.
So, these examples will appear in my tables as an 'award' simply because it is a historical record based on the best research available in USAF.
Don't even need to touch on Bomber claims as we know they were grossly overstated on any metric you choose.
What will make a relatively accurate accounting nigh impossibles are several factors. First the records of the LW are incomplete - many lost or destroyed at end of war during the chaos around Berlin, for example. Much of what has been 'recovered' is due to diligent and painful research on the part of people like Dr. Prien, Tony Woods, Erich Brown, Frank Olynyk, etc.
Second is the differentiation between 'views' (8th pilot chases fighter to crash land and awarded 'Destroyed' - LW repairs or salvages and records as 'Damaged'
Last, perhaps is an a/c destroyed that is only claimed as Probable or Damaged by either side, or shot down but the shooter in turn is KIA before able to make a claim or not seen by anyone else.
If a 109 (or Mustang) was found in a smoking crater, say, by LW, it might be recorded as Destroyed - unknown cause' even if suspected lost to fighters when bad weather present or solid overcast, etc could have been the cause.
As for the Vietnam kills, oy-vey, that one could go on forever. Two different wars (WW2/Vietnam) and two totally different rules of engagement (very limited ROE in WW2 vs. very limiting in Vietnam).
As noted earlier, your stats are a great place to start. Interesting stuff.