M60A3TTS
Posts: 4014
Joined: 5/13/2011 Status: offline
|
quote:
ORIGINAL: Telemecus I have some spreadsheets set up as the "total" solution with vlookups, pivot tables etc. for all the data points for all types. So at least I have them there built in as an option if it is something to track. Whether you actually do or not depends on whether it is worth it I guess. I like to have everything ready if I do, and just leave blank or cut out if I do not. I need to re-learn how to do that cool macro stuff and use pivot tables. This is a sample of my ho-hum airplane data on simple notepad. VVS Start Turn 1 FFB Regiments 124 29 Polikarpov biplanes (23.4%) I-153 23 I-15bis 6 1,970 deployed 790 in reserve 2,760 total 65 Polikarpov monoplanes (52.4%) I-16 T5 2 I-16 T18 23 I-16 T24 37 I-16 T29 3 30 2nd gen fighter bombers (24.2%) LaGG-3 6 MiG-3 22 Yak-1 2 FFB Battalions 38 15 Polikarpov biplanes (39.5%) I-153 11 I-15bis 4 16 Polikarpov biplanes (42.1%) I-16 T18 5 I-16 T24 9 I-16 T29 2 7 2nd gen fighter bombers (18.4%) MiG-3 5 Yak-1 2 All Polikarpov biplane formations I-153 34 I-15bis 10 1,970 deployed 790 in reserve 2,760 total All Polikarpov monoplane formations I-16 T5 2 I-16 T18 28 I-16 T24 46 I-16 T29 5 3,359 deployed 711 in reserve 4,070 total All 2nd gen fighter bomber formations LaGG-3 6 MiG-3 26 Yak-1 4 1,258 deployed 710 in reserve 1,968 total All FFBs 6,587 deployed 2,211 in reserve 8,799 total
< Message edited by M60A3TTS -- 9/4/2017 6:31:15 PM >
|