Thanks for the replies guys, I appreciate it. Hopefully was can add to it.
It was said above that the Spitfires were in combat longer than the P-51. I was waiting for that with baited breath and knew it was coming ... so ...
In my claims file, the first P-51 claim shows up on 19 Aug 1942. In fact, the first three P-51 claims show up on 19 Aug 1942.
The reason I put the data into Excel is for easy analysis.
An advanced filter tells me that from 19 Aug 1942 through the end of the war the Germans claimed 1,034 P-51's. During that same timeframe the Germans claimed 1,752 Spitfires. That's 69% more Spitfires claimed shot down over Europe, against the same air force, in the timeframe from when the P-51 first made an appearance in German claims through the end of the war. That's 35% of all the Spitfire claims (4,997) happening from when the P-51 showed up in claims through the end of the war, so we're backing out 65% of the Spitfire claims to make the comparison fair to the immortal Spitfire.
I don't care who is looking at the data or how they look at it, 69% more losses, rather claimed losses, over the same time period is significant. If it isn't, someone needs remndial math. Even if the losses are … say … 80% accurate (you pick the number), that difference is not insignificant. That's the beautry of having the data in Excel, it is easy to investigate these things without taking years.
I suppose it could be insiginficant if someone thinks the Germans overclaimed 3 to 1 for the Spitfire but somehow were 100% accurate for the P-51. That's a scenario I strongly doubt.
It wouldn't take much to look at the breakout of units claiming the P-51's versus units claiming the Spits, either ... just a few filters and pivot tables.
This at least gives me some good food for thought about the investigation of losses.
Now if was could get a good file of Allied losses in theaters versus Germany admitted by type, we'd have some real opportunities for investigation. Personally I KNOW the Germans overcalimed, everyone did, so they aren't alone there and it's no knock against German pilots ... it was war. However, I also doubt very much that the admitted losses were 100% accurate. Again, this was war. Lying aboyut one's losses was standard procedure everywhere to keep up morale and deceive the enemy.
So two good questions might be what % overcaliming is about fair and what percent under-admiting of losses is about fair?
If we can answer these two questions, we are 75% of the way toward having a reasonable tool for looking at victories and losses in theaters versus Germany during WWII ... which was a large part of my goal when I started. That's 2 questions answered (hopefully) and the fact that we have the German claim data, or at least one version of it. What we're missing is admitted Allied losses by type in the ETO and theatrers versus Germany.