A Thread for Data Files

Ad: This forum contains affiliate links to products on Amazon and eBay. More information in Terms and rules


If you want another reference to check against, you may want to take a look at N.L. Avery's book B-25 Mitchell — The Magnificent Medium (Phalanx Publishing, 1992). It has many appendixes, several of which involve aircraft serial numbers. Some examples:

Appendix C — USN/USAAF PBJ Serial Numbers
Appendix G — Dutch Lend Lease for 60 Aircraft
Appendix I — Royal Netherlands Flying School B-25s
Appendix J — B-25s of 320 Sqn (RAF) Royal Netherlands Naval Air Service
Appendix K — B-25 Allocations to Netherlands East Indies Air Force and Royal Australian Air Force
Appendix O — RCAF Mitchells
 
Another file for everyone's consideration. This one puts into a spreadsheet details from the USAF publication Combat Squadrons of the Air Force, World War II.

Specifically, it lists all the USAAF fighter and bombardment squadrons which were stated as having seen combat in the ETO and/or MTO. The information included is squadron number, squadron type, event, base location, date, day of the week, assignment, attachment, and combat. The 'event' column mostly lists when the squadron moved to a new base, but also includes if the squadron was assigned to a different higher unit, or attached to another unit, and so forth. The 'combat' column mostly lists the word combat, but will note if the squadron performed other duties, e.g. a bombardment squadron which switched to weather recon, ECM operations, etc.

The data for each squadron is for the time period between when the squadron was listed as having started and ended combat for the war, as given in the source publication. The combat start row is shaded in light green and the combat end row is shaded in light red to provide a visual break for each squadron. In some cases the 'date' column only shows the month and year as per the source document.

By my count, 149 fighter squadrons and 331 bombardment squadrons (18 light, 60 medium, and 253 heavy) saw combat in the ETO and/or MTO.

(At some point I will add the reconnaissance squadrons.)
 

Attachments

  • USAAF squadron details ETO and MTO.xlsx
    155 KB · Views: 42
Thanks, 33k!

Here's one you guys might like. It's not complete, but has many tables from the Statistical Digest of World War Two. So, it's USAAF, but not USN/MC.

If anyone adds tables, please share what you added.

I have found several errors in table math. Can't tell if the data are wrong or the totals are wrong. So. I assumed that, like it was before spreadsheets and easy addition of many numbers, the data were correct and the totals were wrong.

Cheers.
 

Attachments

  • Statistical_Digest_Tables_WWII.xlsx
    511.3 KB · Views: 51
Last edited:
Another file. This one contains the key specifications for air-dropped ordnance of WW2 from various ordnance manuals available at the Bulletpicker website. It primarily covers bombs, but there are some entries for other devices such as depth bombs, depth charges, mines, etc.

There are six worksheets: Allied Bombs, Allied Clusters, Axis Bombs, Axis Clusters, Rockets, and Abbr (which lists the abbreviations used). The publication from which the data is drawn is listed. The 'Index' column is a convenience to allow the file to be sorted back to its original order. The weaponry is listed in the order it appeared in each source document.

The file is a work-in-progress, so the Axis sheets are somewhat sparse, but the Allied sheets are nearly complete.
 

Attachments

  • WW2 Bomb Specifications.xlsx
    254.4 KB · Views: 42
Geoffrey Sinclair said:
As the title suggests, basic charts to calculate fuel and bomb loads.
Click to expand...

That is an outstanding file! Thanks very much for posting it, as it contains the kind of data I've been wanting to find. Do you know if similar tables were prepared for the medium bombers, e.g. the Hampden, Mosquito, Wellington, etc.? What about American bombers in British service, e.g. Boston, Liberator, Mitchell, etc.?

Now if only the USAAF had created and published similar tables for its bomber operations . . .
 
Jettison/drop tanks made by Britain from December 1943 onwards. A request for some of the figures meant a tidy up was done and it now looks presentable, hopefully without typos.
 

Attachments

  • British Jettison tank production.xlsx
    26 KB · Views: 9
Hello, I'd love to see the CAD drawings
 
Here's the one I did first in grayscale:



and here's the one I did recently:



perhaps a bit more colorful. Oops! I left in the under-the-prop scoop on the front view!. SO, here's the correction below!



Actually, the sharp-eyed among you will see I left off the underside coloring in the front view, too. Ah well, another thing to fix when I get the time!

OK, fixed it.



Better ...
 
Last edited:
You must log in or register to reply here.

Users who are viewing this thread

Total: 1 (members: 0, guests: 1)

Similar threads

A locked thread "Wellington Registrations"
Replies
5
Views
786
Wurger
W
Here's a test for you all...
2
Replies
25
Views
2K
GrauGeist
Records for Jagdgeschwader 400
Replies
6
Views
838
MikeMeech
M
Aircraft comparison for operational-level wargames and alt history forums
Replies
8
Views
895
SaparotRob
C
Tricycle Training(?) for Fighter Directors
Replies
5
Views
509
EAIAnalog