My Mosquito dbs, and other time-wasters

Discussion in 'Aviation' started by mhuxt, Dec 9, 2015.

  1. mhuxt

    mhuxt Active Member

    Joined:
    Jul 16, 2004
    Messages:
    826
    Likes Received:
    72
    Trophy Points:
    28
    So, I’ve been mis-spending my middle age compiling Mosquito databases and other similar time-wasters.
    For a variety of reasons, these now do little good just sitting on my hard-drive, so I’m spamming the internet to give them away to anyone who may be interested.
    I’ve used DropBox – I’m told one does not have to have DropBox installed to access files which have been marked as shared – please let me know if these downloads don’t work and I’ll fiddle with the access rights.
    A couple of kindly fellows who have helped me test this out say a sign in/sign-up window appears, but there is a “No thanks just download” button. One describes it as closing the sign on/up window by clicking the X in top right corner, you can click the download button and it will simply download the relevant file.
    In order of what the files are, and their relative levels of interest:
    “Mosquito Claims for Enemy Aircraft” – collection of Mossie claims air-to-air and air-to-ground in various theatres, as much info as I have been able to assemble per claim, with associated analyses. Please pay close heed to the Source and Source Notes information in columns C and D, and to the details in column AB, though these are narrow for reasons of layout – best read in the formula bar.
    Link: https://www.dropbox.com/s/v2gr3x0rn59your/Mosquito Claims for Enemy Aircraft.xlsx?dl=0

    “Mosquito Fates” based on the Air Britain files and a transcription thereof available elsewhere on the web, an attempt to pursue as much info on the fates of individual aircraft, with associated analyses.
    Link: https://www.dropbox.com/s/2rd2wfbr37sdhz0/Mosquito Fates.xlsx?dl=0

    Mosquito Serial-Marking Combos – collection of Mosquito serial numbers and associated squadron markings. Has at least one combination for just shy of 50% of aircraft produced to end December ’44.
    Link: https://www.dropbox.com/s/4lemp4fpkwqvdyu/Mosquito Serial-Marking Combos.xlsx?dl=0

    Mosquito Production – zip file containing info, mostly from the graphs and tables in Sharp Bowyers “Mosquito” regarding likely delivery month of individual airframes, monthly production by Marque, Series, factory, and a small file on comparative delivery numbers.
    Link: https://www.dropbox.com/s/jcssi2uvry8xrg3/Mosquito Production.zip?dl=0

    Mosquito Bombing – List of all Mosquito bombing raids, excluding fighter-bombers of 2nd TAF, a depiction of the trend in day bomber losses (they were on their way down consistently to June ’43), plus some extremely worthwhile files from American Aviation Historian Richard G Davis on “Bombing the European Axis Powers”, plus a tidbit from the USSBS re: late ’44 USAAF accuracy.
    Link: https://www.dropbox.com/s/cyyty8lyfum0tuw/Mosquito Bombing.zip?dl=0

    Mosquito Strength – Three brief files, compiled from published sources, about the relative level of frontline and overall Mosquito force strength in the U.K. and around the globe from June ’44 to August ’45.
    Link: https://www.dropbox.com/s/fh96ipy9ae1y00i/Mosquito Strength.zip?dl=0

    Mosquito Sorties – Full listing of the Mosquito sorties of No. 23 Squadron, RAF, and a very much work-in-progress attempt to count Mossie sorties into contested airspace (i.e. excludes defensive night-fighter sorties) with a focus on 1943. Least well-developed of all the files, but shows about 3,000 sorties into contested airspace by day, 4,000 by night, in 1943.
    Link: https://www.dropbox.com/s/4qeiuwpaaw69xai/Mosquito Sorties.zip?dl=0

    Life Expectancy – Couple of views, using info from the databases above, about Mosquito life expectancy.
    Link: https://www.dropbox.com/s/0k36cllxnkeeunh/Life Expectancy.zip?dl=0
     
    • Like Like x 6
    • Bacon Bacon x 4
  2. GregP

    GregP Well-Known Member

    Joined:
    Jul 28, 2003
    Messages:
    5,906
    Likes Received:
    853
    Trophy Points:
    113
    Occupation:
    Electrical Engineer, Aircraft Restoration
    Location:
    Rancho Cucamonga, California, U.S.A.
    Thanks mhuxt. :) Nice to see someone sharing WWII information freely. Kudos.
     
  3. buffnut453

    buffnut453 Well-Known Member

    Joined:
    Jul 25, 2007
    Messages:
    2,176
    Likes Received:
    227
    Trophy Points:
    63
    Gender:
    Male
    Location:
    Virginia, US of A
    Absolutely brilliant! Thank you!!! Have a load of bacon on me!
     
  4. tomo pauk

    tomo pauk Creator of Interesting Threads

    Joined:
    Apr 3, 2008
    Messages:
    7,996
    Likes Received:
    440
    Trophy Points:
    83
    Works fine, Mark, many thanks :)

    Hmm - ever thought to write a book on the subject?
     
  5. Capt. Vick

    Capt. Vick Well-Known Member

    Joined:
    Jul 23, 2008
    Messages:
    7,903
    Likes Received:
    639
    Trophy Points:
    113
    Gender:
    Male
    Location:
    Long Island, New York
    Impressive set of records. Thanks!
     
  6. Airframes

    Airframes Benevolens Magister

    Joined:
    Aug 24, 2008
    Messages:
    47,707
    Likes Received:
    1,420
    Trophy Points:
    113
    Gender:
    Male
    Occupation:
    Retired
    Location:
    Cheshire, UK
    Great work Mark, and I agree about the book suggestion.
     
  7. fastmongrel

    fastmongrel Well-Known Member

    Joined:
    May 28, 2009
    Messages:
    2,342
    Likes Received:
    408
    Trophy Points:
    83
    Gender:
    Male
    Occupation:
    Motor Mechanic
    Location:
    Lancashire
    Tried to download some of the files but it keeps coming up saying I need to install Office to open .xlsx files. I had a look at buying the basic Office 365 £79.99 :shock:

    Unless anyone knows how to open xlsx files for free I am afraid I wont be able to view them.
     
  8. tomo pauk

    tomo pauk Creator of Interesting Threads

    Joined:
    Apr 3, 2008
    Messages:
    7,996
    Likes Received:
    440
    Trophy Points:
    83
    This is the Excel Viewer download: link

    Alternatively: link
     
  9. fastmongrel

    fastmongrel Well-Known Member

    Joined:
    May 28, 2009
    Messages:
    2,342
    Likes Received:
    408
    Trophy Points:
    83
    Gender:
    Male
    Occupation:
    Motor Mechanic
    Location:
    Lancashire
    Thanks Tomo I will have a go tomorrow. :thumbleft:
     
  10. Gnomey

    Gnomey World Travelling Doctor
    Staff Member Moderator

    Joined:
    Nov 28, 2004
    Messages:
    41,780
    Likes Received:
    518
    Trophy Points:
    113
    Gender:
    Male
    Occupation:
    Doctor
    Location:
    Portsmouth / Royal Deeside, UK
    Home Page:
    Great stuff! Thanks for sharing.
     
  11. cherry blossom

    Joined:
    Apr 23, 2007
    Messages:
    233
    Likes Received:
    18
    Trophy Points:
    18
  12. Marcel

    Marcel Well-Known Member

    Joined:
    Sep 19, 2006
    Messages:
    6,977
    Likes Received:
    570
    Trophy Points:
    113
    Gender:
    Male
    Occupation:
    Bioinformatician
    Location:
    Dordrecht
    Still asks me to sign in on Dropbox :(
     
    • Like Like x 1
  13. fastmongrel

    fastmongrel Well-Known Member

    Joined:
    May 28, 2009
    Messages:
    2,342
    Likes Received:
    408
    Trophy Points:
    83
    Gender:
    Male
    Occupation:
    Motor Mechanic
    Location:
    Lancashire
    Me too
     
  14. GrauGeist

    GrauGeist Well-Known Member

    Joined:
    Aug 29, 2008
    Messages:
    15,209
    Likes Received:
    2,045
    Trophy Points:
    113
    Occupation:
    Public Safety Automotive Technician
    Location:
    Redding, California
    Home Page:
    Apache's OpenOffice (openoffice.org) should be able to open those files. They've just released the latest version (4.1.2) that has quite a few new features, too.

    I have MS office on my machines and got tired of the quirks and such, so I've been using Open Office for years now without any issues (and it's free)
     
    • Like Like x 1
  15. tomo pauk

    tomo pauk Creator of Interesting Threads

    Joined:
    Apr 3, 2008
    Messages:
    7,996
    Likes Received:
    440
    Trophy Points:
    83
    In the upper right corner there is a dark gray 'X' in the sign-up form, click on it and the form should dissapear.
     
    • Like Like x 1
  16. fubar57

    fubar57 Well-Known Member

    Joined:
    Nov 22, 2009
    Messages:
    11,130
    Likes Received:
    1,047
    Trophy Points:
    113
    Occupation:
    Heavy Equipment Operator
    Location:
    Jungles of Canada
    Thanks Mhuxt and Tomo. Now I just have to convert them to PDF.




    Geo
     
  17. fubar57

    fubar57 Well-Known Member

    Joined:
    Nov 22, 2009
    Messages:
    11,130
    Likes Received:
    1,047
    Trophy Points:
    113
    Occupation:
    Heavy Equipment Operator
    Location:
    Jungles of Canada
Loading...

Share This Page