Air Trade Calculator.xlsx

	A	B	C	E	F	G	H	I	K	L	M	N	O	P	Q	R	S
1	Aircraft base stats			Modifiers for us					Modifiers for enemy						Defines
2		Our	Enemy		speed	agility	attack	defense		speed	agility	attack	defense		AIR_WING_MAX_STATS_AGILITY	100
3	speed	592	589	designer	0.1	0.1	0	0	designer	0.1	0.1	0	0		AIR_WING_MAX_STATS_SPEED	800
4	agility	65	65	airwing exp (lvl3)	0	0.009	0.06	0	airwing exp (lvl3)	0	0.009	0.06	0		BIGGEST_AGILITY_FACTOR_DIFF	4
5	attack	36	36	doctrine (SD)	0	0.3	0.2	0.2	doctrine (SD)	0	0.3	0.2	0.2		BIGGEST_SPEED_FACTOR_DIFF	3.5
6	defense	25	19												TOP_SPEED_DAMAGE_BONUS_FACTOR	0	(This parameter seems to have no effect in my testing)
7	ic	32.4	37												COMBAT_DAMAGE_STATS_MULTILPIER	0.2
8															COMBAT_BETTER_AGILITY_DAMAGE_REDUCTION	0.3
9															COMBAT_BETTER_SPEED_DAMAGE_INCREASE	0.6
10
11
12	version: 1.12.11			Results					Stats Library
13	How to use:			trade (#)	1.32	(this doesnt consider ic)				eng f2 e4	eng f2 e3	ita f2 e4	ita f2 e3	ita f2 e2
14	Download the spreadsheet,			trade (ic)	1.31	(>1 = our design is better)			speed	810	592	807	589	483
15	fill in stats in "Aircraft base stats"								agility	65	65	65	65	63
16	and results will be displayed in "Results"								attack	36	36	36	36	40
17	actual loss	396	468	actual trade (#)	1.18	(from testings, pls ignore this)			defense	21	21	19	19	15
18	(from testings)	396	468	error	11.9%	(for verification)			ic	39	37	39	37	35
19
20										ai eng 1941	ai eng/jap	ai ger	ai sov	f2 e3 2armor 1seal
21									speed	589	504	489	498	592
22									agility	59	55	44	47	65
23									attack	36	16	24	18	36
24									defense	11	9	9	9	25
25									ic	34	25	28	26	36
26
27														503
28														38.5
29														48
30														36
31														62.9
32
33				sum of our modifiers	1.1	1.4417	1.272	1.2	sum of enemy modifiers	1.1	1.4417	1.272	1.2
34
35	stats w/ modifiers			combat_stats	0.000825
36	speed	651.2	647.9	own_agility reduction	0
37	agility	93.7105	93.7105	enemy_agility reduction	0
38	attack	45.792	45.792	own_diff_speed bonus	0.003056027165
39	defense	30	22.8	enemy_diff_speed bonus	0
40	ic	32.4	37	own_net_speed bonus	0
41				enemy_net_speed bonus	0
42				Our damage to enemy	0.0504
43				enemy damage to us	0.0381
44
45
46
47
48
49
50
51
52
53
54
55
56
57
58
59
60
61
62
63
64
65
66
67
68
69
70
71
72
73
74
75
76
77
78
79
80
81
82
83
84
85
86
87
88
89
90
91
92
93
94
95
96
97
98
99
100