Aces High Bulletin Board
General Forums => Axis vs Allies => Topic started by: sparow on February 07, 2008, 05:29:26 PM
-
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...
-
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...
-
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?
-
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.
-
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
-
Great idea, and good work Sparow!:aok
I hope something like this is used in the future.
-
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,