USAAF Victory Credits

Discussion in 'Aviation' started by GregP, Jul 28, 2014.

  1. GregP

    GregP Well-Known Member

    Joined:
    Jul 28, 2003
    Messages:
    5,905
    Likes Received:
    853
    Trophy Points:
    113
    Occupation:
    Electrical Engineer, Aircraft Restoration
    Location:
    Rancho Cucamonga, California, U.S.A.
    I just finished getting the USAAF WWII victory credits into Excel. It, too, comes form Jan Safarik’s website, available to the public. The total victories awarded amount to 15,448.4.

    I did a basic analysis by ranks and theater of operations: 46% in the ETO, 23% in the MTO, 20% in the Southwest Pacific, 7% in CBI, 3% in the Central Pacific, and a very small number in Alaska and Iceland. 45% by 1st Lieutenants, 24% by 2nd Lieutenants, 18% by Captains, 6.5% by Majors, 2.4% by Lieutenant Colonels, and it drops off from there for the rest of the flying ranks.

    Data on 1st tab and basic analysis on 2nd tab.

    Without further ado, here is the file.

    View attachment USAAF_Victories.zip
     
  2. fubar57

    fubar57 Well-Known Member

    Joined:
    Nov 22, 2009
    Messages:
    11,089
    Likes Received:
    1,046
    Trophy Points:
    113
    Occupation:
    Heavy Equipment Operator
    Location:
    Jungles of Canada
    Thank you for the Zip File Greg. You're doing some great work here.

    Geo
     
  3. GregP

    GregP Well-Known Member

    Joined:
    Jul 28, 2003
    Messages:
    5,905
    Likes Received:
    853
    Trophy Points:
    113
    Occupation:
    Electrical Engineer, Aircraft Restoration
    Location:
    Rancho Cucamonga, California, U.S.A.
    #3 GregP, Jul 28, 2014
    Last edited: Jul 28, 2014
    Thanks Geo, you are welcome.

    Since I can't find these data in usable form very much, I'm trying to make it available to the people in here. If I'm curious, I'm sure others are, too.

    Unfortunately, this file does NOT have the victim type, so we know the credits, but not the breakdown. Perhaps that will become avialable later, maybe in another file than can be cross referenced.

    I suppose we'll see down the pike.

    I suggest you guys combine the data into one spreadsheet. I would, but it would become too big to post at some point.

    Maybe one of the mods can make the posts with the files attached into a sticky so they are easily able to be found by members and visitors? Maybe just the files and the source? Just a thought ...
     
  4. fubar57

    fubar57 Well-Known Member

    Joined:
    Nov 22, 2009
    Messages:
    11,089
    Likes Received:
    1,046
    Trophy Points:
    113
    Occupation:
    Heavy Equipment Operator
    Location:
    Jungles of Canada
    I've got the U.S. Navy Claims and Losses on PDF is you want it.

    Geo
     
  5. GregP

    GregP Well-Known Member

    Joined:
    Jul 28, 2003
    Messages:
    5,905
    Likes Received:
    853
    Trophy Points:
    113
    Occupation:
    Electrical Engineer, Aircraft Restoration
    Location:
    Rancho Cucamonga, California, U.S.A.
    You bet! Please post it in here or a new thread

    And thanks!

    The pdf I have is unreadable to OCR as text and is probably from a 1950's microfiche.
     
  6. fubar57

    fubar57 Well-Known Member

    Joined:
    Nov 22, 2009
    Messages:
    11,089
    Likes Received:
    1,046
    Trophy Points:
    113
    Occupation:
    Heavy Equipment Operator
    Location:
    Jungles of Canada
  7. GregP

    GregP Well-Known Member

    Joined:
    Jul 28, 2003
    Messages:
    5,905
    Likes Received:
    853
    Trophy Points:
    113
    Occupation:
    Electrical Engineer, Aircraft Restoration
    Location:
    Rancho Cucamonga, California, U.S.A.
    #7 GregP, Jul 28, 2014
    Last edited: Jul 28, 2014
    Yeah, that's the same one I have. If you want to use it, you have to type in what you want ... it isn't saved as text.

    But I certainly thank you for the effort!
     
  8. cimmex

    cimmex Member

    Joined:
    May 4, 2011
    Messages:
    356
    Likes Received:
    9
    Trophy Points:
    18
    I don't understand. I can copy and paste the text to word or excell.
    cimmex
     
  9. GregP

    GregP Well-Known Member

    Joined:
    Jul 28, 2003
    Messages:
    5,905
    Likes Received:
    853
    Trophy Points:
    113
    Occupation:
    Electrical Engineer, Aircraft Restoration
    Location:
    Rancho Cucamonga, California, U.S.A.
    #9 GregP, Jul 28, 2014
    Last edited: Jul 28, 2014
    Yes, but it isn't inrtelligible.

    When I paste in a table, it is jibberish ... the numbers are there, but scrambled. Maybe you habve a diferent file? I'm not interested in the text ... but the numbers and categories for the numbers.
     
  10. cimmex

    cimmex Member

    Joined:
    May 4, 2011
    Messages:
    356
    Likes Received:
    9
    Trophy Points:
    18
    Sorry, my fault! I only tried a text block at the beginning….
    cimmex
     
  11. wuzak

    wuzak Well-Known Member

    Joined:
    Jun 5, 2011
    Messages:
    4,179
    Likes Received:
    167
    Trophy Points:
    63
    Location:
    Hobart Tasmania
    Thanks Greg and Fubar.
     
  12. GregP

    GregP Well-Known Member

    Joined:
    Jul 28, 2003
    Messages:
    5,905
    Likes Received:
    853
    Trophy Points:
    113
    Occupation:
    Electrical Engineer, Aircraft Restoration
    Location:
    Rancho Cucamonga, California, U.S.A.
    You're welcome. I'll collect what I've put together so far from the US Navy and USAAF files files I have and post it.
     
  13. GregP

    GregP Well-Known Member

    Joined:
    Jul 28, 2003
    Messages:
    5,905
    Likes Received:
    853
    Trophy Points:
    113
    Occupation:
    Electrical Engineer, Aircraft Restoration
    Location:
    Rancho Cucamonga, California, U.S.A.
    I found a reference that says the above file was for the USAAF in the ETO, but it was a bit vague sounding and the theaters are an entry. I have other files that say about that number in the ETO alone for the USAAF, with considerably more if the other theaters are thrown in. The disparity is large, making me wonder if the larger numbers are claims and the file above is awarded victories.

    I may post the other files an let the forum members make up their own minds ... I'm thinking on it.
     
Loading...

Share This Page