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:
    6,183
    Likes Received:
    977
    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,375
    Likes Received:
    298
    Trophy Points:
    83
    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:
    8,256
    Likes Received:
    509
    Trophy Points:
    113
    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:
    8,489
    Likes Received:
    739
    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:
    49,351
    Likes Received:
    1,667
    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,385
    Likes Received:
    421
    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:
    8,256
    Likes Received:
    509
    Trophy Points:
    113
    This is the Excel Viewer download: link

    Alternatively: link
     
  9. fastmongrel

    fastmongrel Well-Known Member

    Joined:
    May 28, 2009
    Messages:
    2,385
    Likes Received:
    421
    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:
    43,190
    Likes Received:
    611
    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:
    234
    Likes Received:
    18
    Trophy Points:
    18
  12. Marcel

    Marcel Well-Known Member

    Joined:
    Sep 19, 2006
    Messages:
    7,080
    Likes Received:
    617
    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,385
    Likes Received:
    421
    Trophy Points:
    83
    Gender:
    Male
    Occupation:
    Motor Mechanic
    Location:
    Lancashire
    Me too
     
  14. GrauGeist

    GrauGeist Well-Known Member

    Joined:
    Aug 29, 2008
    Messages:
    15,456
    Likes Received:
    2,170
    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:
    8,256
    Likes Received:
    509
    Trophy Points:
    113
    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:
    12,332
    Likes Received:
    1,332
    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:
    12,332
    Likes Received:
    1,332
    Trophy Points:
    113
    Occupation:
    Heavy Equipment Operator
    Location:
    Jungles of Canada
Loading...

Share This Page