Author Topic: A starting point for attrition modeling: limited airframes and delivery schedules  (Read 431 times)

Offline sparow

  • Nickel Member
  • ***
  • Posts: 579
      • http://249sqn.wordpress.com/
Hi all,

A couple of years ago, I put into a spreadsheet the data I collected from a book I bought. Innacurate this numbers may be, I admit, but they must not be very far from the truth.

I believe that a proportional distribution of makes and models could bring an important change in behaviour to AvA pilots.

I don't believe that these numbers were not enough for a whole TOD, even in the lemmingiest AvA attitude...

Aircraft Type/Model   Total produced (ac. to source) (1)   Percent. of this total (2)   per Campaign

Boeing B-17 Flying Fortress   12371   4,0%   589
Consolidated B-24 Liberator   19203   6,3%   914
North American B-25 Mitchell   1000   0,3%   48
Grumman F4F Wildcat   7251   2,4%   345
Chance Vought F4U Corsair   12681   4,1%   604
Grumman F6F Hellcat   12275   4,0%   585
Hawker Hurricane   12975   4,2%   618
De Havilland Mosquito   7785   2,5%   371
Lockeed P-38 Lightning   9923   3,2%   473
Bell P-39 Airacobra   9588   3,1%   457
Curtiss P-40 Warhawk   5331   1,7%   254
Republic P-47 Thunderbolt   15660   5,1%   746
North American P-51 Mustang   8456   2,8%   403
Curtiss SB2C Helldiver   1194   0,4%   57
Douglas SBD Dauntless   5936   1,9%   283
Supermarine Seafire   1779   0,6%   85
Supermarine Spitfire   20360   6,7%   970
Grumman TBF Avenger   9836   3,2%   468
Yakovlev Yak-3                   4848   1,6%   231
Yakovlev Yak-9                  16796   5,5%       800
                                       9298
         
         
Mitsubishi A6M2/A6M8 Zero Zeke      9136   3,0%   435
Nakajima B5N1 / B5N2 Kate                      1149   0,4%   55
Messerschimdt Bf 109                    31898   10,4%   1519
Messerschmidt Bf 110                      6257   2,0%   298
Aichi D3A Val                                      1495   0,5%   71
Focke-Wulf FW 190                                    20051   6,6%   955
Focke-Wulf FW190 D9 Dora                      1805   0,6%   86
Mitsubishi G4M Betty                       2446   0,8%   116
Junkers JU52                                       2804   0,9%   134
Junkers JU87 Stuka                                       4890   1,6%   233
Junkers JU88 6 - 6                                       3915   1,3%   186
Junkers JU88 A4                                     16911   5,5%   805
Kawasaki Ki-61 Tony                        3150   1,0%   150
Nakajima Ki-84 Frank                        3078   1,0%   147
Messerschmidt Me262 Schwalbe        1430   0,5%   68
Messerschmidt Me262 B1-A Schwalbe            67   0,0%   3
                                                        5261
         
         
                                                     305730   100,0%   14559

But there's more...

Let's apply year of entry into service along WW2 timeline and divide it in 3 delivery batches and we would have someting like this:

1939

Aircraft Type/Model   total|50%infieldsatstart |20%indelivery|30%inprod.Line

Boeing B-17 Flying Fortress   84   42   17   25
Consolidated B-24 Liberator   0   0   0   0
North American B-25 Mitchell   0   0   0   0
Grumman F4F Wildcat   0   0   0   0
Chance Vought F4U Corsair   0   0   0   0
Grumman F6F Hellcat   0   0   0   0
Hawker Hurricane                 88   44   18   26
De Havilland Mosquito   0   0   0   0
Lockeed P-38 Lightning   0   0   0   0
Bell P-39 Airacobra   0   0   0   0
Curtiss P-40 Warhawk   0   0   0   0
Republic P-47 Thunderbolt   0   0   0   0
North American P-51 Mustang   0   0   0   0
Curtiss SB2C Helldiver   0   0   0   0
Douglas SBD Dauntless   40   20   8   12
Supermarine Seafire   0   0   0   0
Supermarine Spitfire   139   69   28   42
Grumman TBF Avenger   0   0   0   0
Yakovlev Yak-3                   0   0   0   0
Yakovlev Yak-9                   0   0   0   0
                                351   176   70   105
            
            
Mitsubishi A6M2/A6M8    0   0   0   0
Nakajima B5N1 / B5N2 Kate   0   0   0   0
Messerschimdt Bf 109   217   108   43   65
Messerschmidt Bf 110   43   21   9   13
Aichi D3A Val                    0   0   0   0
Focke-Wulf FW 190                    0   0   0   0
Focke-Wulf FW190 D9     0   0   0   0
Mitsubishi G4M Betty    0   0   0   0
Junkers JU52                  19   10   4   6
Junkers JU87 Stuka                  33   17   7   10
Junkers JU88 6 - 6                  27   13   5   8
Junkers JU88 A4                115   58   23   35
Kawasaki Ki-61 Tony   0   0   0   0
Nakajima Ki-84 Frank   0   0   0   0
Messerschmidt Me262   0   0   0   0
Messerschmidt Me262 B1-A    0   0   0   0
                                454   227   91   136

1940

Aircraft Type/Model|50%infieldatstart|20%indelivery|30%inprod.Line
Boeing B-17 Flying Fortress   84   42   17   25
Consolidated B-24 Liberator   0   0   0   0
North American B-25 Mitchell   8   4   2   2
Grumman F4F Wildcat   58   29   12   17
Chance Vought F4U Corsair   0   0   0   0
Grumman F6F Hellcat   0   0   0   0
Hawker Hurricane   88   44   18   26
De Havilland Mosquito   0   0   0   0
Lockeed P-38 Lightning   0   0   0   0
Bell P-39 Airacobra   0   0   0   0
Curtiss P-40 Warhawk   0   0   0   0
Republic P-47 Thunderbolt   0   0   0   0
North American P-51 Mustang   0   0   0   0
Curtiss SB2C Helldiver   0   0   0   0
Douglas SBD Dauntless   40   20   8   12
Supermarine Seafire   0   0   0   0
Supermarine Spitfire   139   69   28   42
Grumman TBF Avenger   0   0   0   0
Yakovlev Yak-3                   0   0   0   0
Yakovlev Yak-9                   0   0   0   0
                                417   208   83   125
            
            
Mitsubishi A6M2/A6M8 Zero    73   36   15   22
Nakajima B5N1 / B5N2 Kate   9   5   2   3
Messerschimdt Bf 109   217   108   43   65
Messerschmidt Bf 110   43   21   9   13
Aichi D3A Val   12   6   2   4
Focke-Wulf FW 190   0   0   0   0
Focke-Wulf FW190 D9 Dora   0   0   0   0
Mitsubishi G4M Betty   0   0   0   0
Junkers JU52                 19   10   4   6
Junkers JU87 Stuka                 33   17   7   10
Junkers JU88 6 - 6                 27   13   5   8
Junkers JU88 A4                 115   58   23   35
Kawasaki Ki-61 Tony   0   0   0   0
Nakajima Ki-84 Frank   0   0   0   0
Messerschmidt Me262    0   0   0   0
Messerschmidt Me262 B1-A    0   0   0   0
                               547   274   109   164

And the same goes for 1941...
Sparow
249 Sqn RAF "Gold Coast"
Consistently beeing shot down since Tour 33 (MA) and Tour 8  (CT/AvA)

Visit us at http://249sqn.wordpress.com/

Offline sparow

  • Nickel Member
  • ***
  • Posts: 579
      • http://249sqn.wordpress.com/
Numbers for 1941, 1942 and 1943
« Reply #1 on: February 07, 2008, 05:32:55 PM »
1941

Boeing B-17 Flying Fortress   84   42   17   25
Consolidated B-24 Liberator   0   0   0   0
North American B-25 Mitchell   8   4   2   2
Grumman F4F Wildcat   58   29   12   17
Chance Vought F4U Corsair   0   0   0   0
Grumman F6F Hellcat   0   0   0   0
Hawker Hurricane   88   44   18   26
De Havilland Mosquito   74   37   15   22
Lockeed P-38 Lightning   95   47   19   28
Bell P-39 Airacobra   91   46   18   27
Curtiss P-40 Warhawk   51   25   10   15
Republic P-47 Thunderbolt   149   75   30   45
North American P-51 Mustang   0   0   0   0
Curtiss SB2C Helldiver   0   0   0   0
Douglas SBD Dauntless   40   20   8   12
Supermarine Seafire   0   0   0   0
Supermarine Spitfire   139   69   28   42
Grumman TBF Avenger   0   0   0   0
Yakovlev Yak-3   0   0   0   0
Yakovlev Yak-9   0   0   0   0
   877   438   175   263
            
            
Mitsubishi A6M2/A6M8 Zero Zeke   73   36   15   22
Nakajima B5N1 / B5N2 Kate   9   5   2   3
Messerschimdt Bf 109   217   108   43   65
Messerschmidt Bf 110   43   21   9   13
Aichi D3A Val   12   6   2   4
Focke-Wulf FW 190   191   95   38   57
Focke-Wulf FW190 D9 Dora   0   0   0   0
Mitsubishi G4M Betty   23   12   5   7
Junkers JU52   19   10   4   6
Junkers JU87 Stuka   33   17   7   10
Junkers JU88 6 - 6   27   13   5   8
Junkers JU88 A4   115   58   23   35
Kawasaki Ki-61 Tony   0   0   0   0
Nakajima Ki-84 Frank   0   0   0   0
Messerschmidt Me262 Schwalbe   0   0   0   0
Messerschmidt Me262 B1-A Schwalbe   0   0   0   0
   761   381   152   228

1942

Boeing B-17 Flying Fortress   84   42   17   25
Consolidated B-24 Liberator   229   114   46   69
North American B-25 Mitchell   8   4   2   2
Grumman F4F Wildcat   58   29   12   17
Chance Vought F4U Corsair   151   75   30   45
Grumman F6F Hellcat   0   0   0   0
Hawker Hurricane   88   44   18   26
De Havilland Mosquito   74   37   15   22
Lockeed P-38 Lightning   95   47   19   28
Bell P-39 Airacobra   91   46   18   27
Curtiss P-40 Warhawk   51   25   10   15
Republic P-47 Thunderbolt   149   75   30   45
North American P-51 Mustang   101   50   20   30
Curtiss SB2C Helldiver   0   0   0   0
Douglas SBD Dauntless   40   20   8   12
Supermarine Seafire   21   11   4   6
Supermarine Spitfire   139   69   28   42
Grumman TBF Avenger   117   59   23   35
Yakovlev Yak-3   0   0   0   0
Yakovlev Yak-9   0   0   0   0
   1495   748   299   449
            
            
Mitsubishi A6M2/A6M8 Zero Zeke   73   36   15   22
Nakajima B5N1 / B5N2 Kate   9   5   2   3
Messerschimdt Bf 109   217   108   43   65
Messerschmidt Bf 110   43   21   9   13
Aichi D3A Val   12   6   2   4
Focke-Wulf FW 190   191   95   38   57
Focke-Wulf FW190 D9 Dora   0   0   0   0
Mitsubishi G4M Betty   23   12   5   7
Junkers JU52   19   10   4   6
Junkers JU87 Stuka   33   17   7   10
Junkers JU88 6 - 6   27   13   5   8
Junkers JU88 A4   115   58   23   35
Kawasaki Ki-61 Tony   0   0   0   0
Nakajima Ki-84 Frank   0   0   0   0
Messerschmidt Me262 Schwalbe   0   0   0   0
Messerschmidt Me262 B1-A Schwalbe   0   0   0   0
   761   381   152   228

1943

Boeing B-17 Flying Fortress   84   42   17   25   84
Consolidated B-24 Liberator   229   114   46   69   229
North American B-25 Mitchell   8   4   2   2   8
Grumman F4F Wildcat   58   29   12   17   58
Chance Vought F4U Corsair   151   75   30   45   151
Grumman F6F Hellcat   195   97   39   58   195
Hawker Hurricane   88   44   18   26   88
De Havilland Mosquito   74   37   15   22   74
Lockeed P-38 Lightning   95   47   19   28   95
Bell P-39 Airacobra   91   46   18   27   91
Curtiss P-40 Warhawk   51   25   10   15   51
Republic P-47 Thunderbolt   149   75   30   45   149
North American P-51 Mustang   101   50   20   30   101
Curtiss SB2C Helldiver   19   9   4   6   19
Douglas SBD Dauntless   40   20   8   12   40
Supermarine Seafire   21   11   4   6   21
Supermarine Spitfire   139   69   28   42   139
Grumman TBF Avenger   117   59   23   35   117
Yakovlev Yak-3   77   38   15   23   77
Yakovlev Yak-9   0   0   0   0   400
   1786   893   357   536   2186
               
               
Mitsubishi A6M2/A6M8 Zero Zeke   73   36   15   22   73
Nakajima B5N1 / B5N2 Kate   9   5   2   3   9
Messerschimdt Bf 109   217   108   43   65   217
Messerschmidt Bf 110   43   21   9   13   43
Aichi D3A Val   12   6   2   4   12
Focke-Wulf FW 190   191   95   38   57   191
Focke-Wulf FW190 D9 Dora   0   0   0   0   0
Mitsubishi G4M Betty   23   12   5   7   23
Junkers JU52   19   10   4   6   19
Junkers JU87 Stuka   33   17   7   10   33
Junkers JU88 6 - 6   27   13   5   8   27
Junkers JU88 A4   115   58   23   35   115
Kawasaki Ki-61 Tony   50   25   10   15   50
Nakajima Ki-84 Frank   0   0   0   0   73
Messerschmidt Me262 Schwalbe   0   0   0   0   0
Messerschmidt Me262 B1-A Schwalbe   0   0   0   0   0
   811   406   162   243   885

Numbers for 1944 and 1945 follows...
Sparow
249 Sqn RAF "Gold Coast"
Consistently beeing shot down since Tour 33 (MA) and Tour 8  (CT/AvA)

Visit us at http://249sqn.wordpress.com/

Offline sparow

  • Nickel Member
  • ***
  • Posts: 579
      • http://249sqn.wordpress.com/
Number for 1944 and 1945
« Reply #2 on: February 07, 2008, 05:35:59 PM »
1944

Boeing B-17 Flying Fortress   84   42   17   25
Consolidated B-24 Liberator   229   114   46   69
North American B-25 Mitchell   8   4   2   2
Grumman F4F Wildcat   58   29   12   17
Chance Vought F4U Corsair   151   75   30   45
Grumman F6F Hellcat   195   97   39   58
Hawker Hurricane   88   44   18   26
De Havilland Mosquito   74   37   15   22
Lockeed P-38 Lightning   95   47   19   28
Bell P-39 Airacobra   91   46   18   27
Curtiss P-40 Warhawk   51   25   10   15
Republic P-47 Thunderbolt   149   75   30   45
North American P-51 Mustang   101   50   20   30
Curtiss SB2C Helldiver   19   9   4   6
Douglas SBD Dauntless   40   20   8   12
Supermarine Seafire   21   11   4   6
Supermarine Spitfire   139   69   28   42
Grumman TBF Avenger   117   59   23   35
Yakovlev Yak-3   77   38   15   23
Yakovlev Yak-9   400   200   80   120
   2186   1093   437   656
            
            
Mitsubishi A6M2/A6M8 Zero Zeke   73   36   15   22
Nakajima B5N1 / B5N2 Kate   9   5   2   3
Messerschimdt Bf 109   217   108   43   65
Messerschmidt Bf 110   43   21   9   13
Aichi D3A Val   12   6   2   4
Focke-Wulf FW 190   191   95   38   57
Focke-Wulf FW190 D9 Dora   0   0   0   0
Mitsubishi G4M Betty   23   12   5   7
Junkers JU52   19   10   4   6
Junkers JU87 Stuka   33   17   7   10
Junkers JU88 6 - 6   27   13   5   8
Junkers JU88 A4   115   58   23   35
Kawasaki Ki-61 Tony   50   25   10   15
Nakajima Ki-84 Frank   73   37   15   22
Messerschmidt Me262 Schwalbe   0   0   0   0
Messerschmidt Me262 B1-A Schwalbe   0   0   0   0
   885   442   177   265

1945

Boeing B-17 Flying Fortress   84   42   17   25
Consolidated B-24 Liberator   229   114   46   69
North American B-25 Mitchell   8   4   2   2
Grumman F4F Wildcat   58   29   12   17
Chance Vought F4U Corsair   151   75   30   45
Grumman F6F Hellcat   195   97   39   58
Hawker Hurricane   88   44   18   26
De Havilland Mosquito   74   37   15   22
Lockeed P-38 Lightning   95   47   19   28
Bell P-39 Airacobra   91   46   18   27
Curtiss P-40 Warhawk   51   25   10   15
Republic P-47 Thunderbolt   149   75   30   45
North American P-51 Mustang   101   50   20   30
Curtiss SB2C Helldiver   19   9   4   6
Douglas SBD Dauntless   40   20   8   12
Supermarine Seafire   21   11   4   6
Supermarine Spitfire   139   69   28   42
Grumman TBF Avenger   117   59   23   35
Yakovlev Yak-3   77   38   15   23
Yakovlev Yak-9   400   200   80   120
   2186   1093   437   656
            
            
Mitsubishi A6M2/A6M8 Zero Zeke   73   36   15   22
Nakajima B5N1 / B5N2 Kate   9   5   2   3
Messerschimdt Bf 109   217   108   43   65
Messerschmidt Bf 110   43   21   9   13
Aichi D3A Val   12   6   2   4
Focke-Wulf FW 190   191   95   38   57
Focke-Wulf FW190 D9 Dora   86   43   17   26
Mitsubishi G4M Betty   23   12   5   7
Junkers JU52   19   10   4   6
Junkers JU87 Stuka   33   17   7   10
Junkers JU88 6 - 6   27   13   5   8
Junkers JU88 A4   115   58   23   35
Kawasaki Ki-61 Tony   50   25   10   15
Nakajima Ki-84 Frank   73   37   15   22
Messerschmidt Me262 Schwalbe   68   34   14   20
Messerschmidt Me262 B1-A Schwalbe   3   2   1   1
   1042   521   208   313

That's it...Do you think we can waste more than 14,500 airframes in a month?
Sparow
249 Sqn RAF "Gold Coast"
Consistently beeing shot down since Tour 33 (MA) and Tour 8  (CT/AvA)

Visit us at http://249sqn.wordpress.com/

Offline Easyscor

  • Plutonium Member
  • *******
  • Posts: 10899
Hi Sparow,

That's a lot of work you've done there. S!

I'll admit I didn't plow through the whole thing. Many of us have similar data bases, however the key elements are model, deployment in squadron strength in the field, and which theater of operations they were deployed in. Often it was many months between production and squadron strength deployment, so you see this can be a critical bit of information if you expect your setup not to be challenged.

Also, I think you said you were depending on a single book, and it may be an excellent reference, but I'd want to know what it was before I counted on this data, and I had trouble tracking the meaning of the four and sometimes five numbers after the plane name. Probably because it's been a long day and I need a nap lol.
Easy in-game again.
Since Tour 19 - 2001

Offline sparow

  • Nickel Member
  • ***
  • Posts: 579
      • http://249sqn.wordpress.com/
Hi Easyscor!

LOL! Yep, my IT capabilities are not enough to insert a spreadsheet properly in this BB...Sorry, it's a bit messy, really...

It was not much work, only required a little patience to insert data, the rest are array copied formulas...it's easy and it's ready to work with other figures, more models, different ratios, etc, etc...

To be honest, I compiled this data and much more...Would you like to know how many Amiot Bombers the French had in 1939?

I will gladly send you this sheet by e-mail or PM if it is possible to attach files. Then you may fiddle with the numbers at your will, lol!

My source was Aircraft of World War II - A visual encyclopedia, by Michael Sharpe, Jerry Scuts and Dan March, first published in 1999 by PRC Publishing Ltd, London. ISBN 1 902616 62 6 .

Even I must admit that these are unofficial data, and even historians strive to arrive to correct prodution figures, so, they must be handled with some caution...

Anyway, just a quick explanation about this numbers and the whole idea behind that:

I allways - since WB - that I thought that resource management should play an important role in the whole simulation. So, I got these total production figures and determined his percentual weight in the total aircraft production.

Then - and this is very important - I divided the total aircraft by 21, the number of days a WB TOD would take to do a whole WW2 plane set.

Based on that figure, I applied the 1st ratio and obtained the total number of each model to be allocated to a single TOD.

Then, I divided the simulated total number of aircraft by his years of service, since introduced.

That's why the Late War models are tottally zeroed in the first years of conflict...

Finally, I distributed the yearly total allotment of aircraft in 3 installments:

50% would be available right from the start of the TOD;
25% would be in delivery process and would be available at 1/3 of the time defined for a year (a couple of days);
25% would be beeing built in a factory running at 100% strenght; during 1/3 of the period defined for a year, they would be building and, if the factory had not been destroyed or damaged, they would release their batches of aircraft into the delivery stream, that would take a few days to deliver them to the front, making them available for the last 1/3 of the "year" period. This, in optimal conditions, because damage would hamper speed or output, maybe both...

In the "next year" the aircraft delivered would remain available until expended...

Because every time an aircraft was shot down, the HOST would reduce it's total number by one...And when it arrived to zero...well, it would be time to get another kite...

Tell me if you want the file. These are the models covered:

Amiot143   138
Morane-Saulnier MS406   1098
Bloch 151   140
LeO 451   452
Bloch 152   488
Potez 630 / 631   1300
Breguet 690   304
Dewoitine D520   905
   4825
   
   
De Haviland Tiger Moth   8700
Supermarine Walrus   761
Fairey Swordfish   2391
Avro Anson   9932
Gloster Gladiator   747
Armstrong Withworth Whitley   1814
Fairey Battle   2201
Bristol Blenheim   6355
Airspeed Oxford   8586
Hawker Hurricane   12975
Handley-Page Hereford   152
Short Sunderland   749
Handley-Page Hampden   1432
Westland Lysander   1652
Vickers Wellington   11462
Supermarine Spitfire   20360
Boulton-Paul Defiant   1075
Bristol Beaufort   1930
Fairey Fulmar   602
Fairey Albacore   802
Short Stirling   2374
Bristol Beaufighter   5918
Handley-Page Halifax   6179
Hawker Typhoon   3270
Avro Lancaster   7378
Fairey Firefly   978
Fairey Barracuda   2602
Gloster Meteor   230
Hawker Tempest   806
De Havilland Mosquito   7785
Supermarine Seafire   1779
   133977
   
Junkers JU52   2804
Fieseler FI156 Storch   2549
Heinkel He111   5678
Dornier DO 17 / 215   528
Arado AR196   593
Junkers JU87 Stuka   4890
Messerschmidt Bf 110   6257
Junkers JU88 A4   16911
Messerschimdt Bf 109   31898
Focke-Wulf FW 200 Condor   276
Dornier DO 217   1730
Focke-Wulf FW 190   20051
Junkers JU 188   1076
Heinkel He177   1146
Messerschmidt Me410   113
Heinkel He219   268
Messerschmidt Me210   356
Arado AR234   222
Messerschmidt Me163 Komet   470
Messerschmidt Me262 B1-A Schwalbe   67
Messerschmidt Me262 Schwalbe   1430
Focke-Wulf FW190 D9 Dora   1805
Junkers JU88 6 - 6   3915
   105033
   
Savoia-Marchetti SM.81 Pipistrello   535
Savoia-Marchetti SM.79 Sparviero   1230
FIAT BR.20   599
CANT Z.506 Airone   95
CANT Z.1007 Alcione   600
FIAT G.50 Freccia   778
Macchi MC.200 Saetta   1150
FIAT CR.42   1781
Macchi MC.205 V Veltro   262
   7030
   
Mitsubishi G3M Nell   1048
Mitsubishi Ki-21 Sally   2064
Nakajima Ki-27 Nate   3399
Nakajima B5N1 / B5N2 Kate   1149
Aichi D3A Val   1495
Mitsubishi A6M2/A6M8 Zero Zeke   9136
Kawasaki Ki-45 Nick   1370
Mitsubishi Ki-46 Dinah   1742
Mitsubishi G4M Betty   2446
Kawanishi H8K2 Emily   167
Nakajima J1N1 Irving   486
Nakajima Ki-43 Oscar   5919
Mitsubishi J2M Jack   476
Nakajima B6N Jill   1268
Kawanishi N1K2 George   401
Nakajima C6N Myrt   463
Kawanishi N1K1 Shiden George   1007
Kawasaki Ki-100 Tony   377
Kawasaki Ki-61 Tony   3078
Nakajima Ki-84 Frank   3382
   40873
   
Polikarpov I - 16 Rata   9450
Tupolev SB-2   6831
Ilyushin DB3 / Il-4   6784
Polikarpov I - 153   3437
Petlyakov PE-8   93
Yakovlev Yak 1 / 7   8734
Petlyakov PE-2   11427
MIG 1 / 3   3322
LAGG 1 / 3   6528
Ilyushin Il-2   36163
Lavochkin LA5   9920
Lavochkin LA7   5753
Yakovlev Yak-9   16796
Yakovlev Yak-3   4848
   130086
   
Boeing B-17 Flying Fortress   12371
North American T-6 Texan   15109
Douglas C-47 Skytrain   10048
Beech 18 / UC45 Expeditor   4000
Douglas SBD Dauntless   5936
Douglas A-20 Havoc   7385
North American B-25 Mitchell   1000
Martin B-26 Marauder B / G   5157
Grumman F4F Wildcat   7251
Curtiss P-36 Hawk / Mohawk   210
Curtiss C-46 Commando   3160
Consolidated PBY Catalina   3276
Bell P-39 Airacobra   9588
Republic P-47 Thunderbolt   15660
Lockheed PV1 / 2 Harpoon   535
North American P-51 Mustang   8456
Grumman TBF Avenger   9836
Bell P-63 Kingcobra   1725
Boieng B-29 Superfortress   2181
Douglas A-26 Invader   10000
Grumman F6F Hellcat   12275
Grumman F8F Bearcat   12275
Martin B-26 Marauder G   893
Northrop P-61 Black Widow   941
Curtiss P-40 Warhawk   5331
Lockeed P-38 Lightning   9923
Consolidated B-24 Liberator   19203
Chance Vought F4U Corsair   12681
Curtiss SB2C Helldiver   1194
Beech AT-11 Kansan   1582
   209182
   
   631006

Cheers and
Sparow
249 Sqn RAF "Gold Coast"
Consistently beeing shot down since Tour 33 (MA) and Tour 8  (CT/AvA)

Visit us at http://249sqn.wordpress.com/

Offline Shifty

  • Plutonium Member
  • *******
  • Posts: 9377
      • 307th FS
Great idea, and good work Sparow!:aok
I hope something like this is used in the future.

JG-11"Black Hearts"...nur die Stolzen, nur die Starken

"Haji may have blown my legs off but I'm still a stud"~ SPC Thomas Vandeventer Delta1/5 1st CAV

Offline sparow

  • Nickel Member
  • ***
  • Posts: 579
      • http://249sqn.wordpress.com/
Thank you Shifty!

I already recalculated these figures for a 30 day TOD (more planes!) and changed the allocation % to 50/20/30. Also calculated that each year of conflict would correspond to 4 days, 6 hours and 43 minutes of AH time.

I sent the Excel spreadsheet to Easyscor by e-mail to be shared by whoever wishes to do so.

Maybe they'll give it a chance, who knows?

Cya soon,
Sparow
249 Sqn RAF "Gold Coast"
Consistently beeing shot down since Tour 33 (MA) and Tour 8  (CT/AvA)

Visit us at http://249sqn.wordpress.com/