CMA/CRA calculator

	A	B	C	D	E	F	G	H	I	J	K	L	M	N	O	P	Q	R	S	T	W	X	Y	AA	AB
1	User modifies these stats																					On Average Dice Rolls
2										CMA/CRA Modifiers												Single Target	Multiple Targets
3	Attacker	Attacker AT	Attacker P+S	Target	Target DEF	Target ARM	Target Health	Damage Dice (charge, weaponmaster)	CMA/CRA Configuration	CR1	CR2	CR3	CR4	CR5	CR6	CR7	CR8	CR9	CR10	# Possible Targets	Chance for CR1 to hit single attack	Single Target, Expected Dmg	Multi-Target, Expected Hits	Expected number of attacks to exceed Target Health (# of kills)	Notes and interpretations

4	Bloodtrackers	8	11	Misc warjack	13	13	1	3	1,1,1,1,1,1,1,1,1,1	#REF!										0	0%	70.8	8	8	Between these cases, the expected number of dead models is the same for the two spread-out options, but the 2,2,2,2,2 has less variability.
5	Bloodtrackers	8	11	Misc warjack	10	19	32	3	1,1,1,1,1,1,1,1,1,1	#REF!										0	0%	24.5	10	0
6	Bloodtrackers	8	11	Misc warjack	10	19	32	3	1,1,1,1,1,1,1,1,1,1	#REF!										0	0%	24.5	10	0
7	Bloodtrackers	8	11	Misc warjack	10	19	32	3	1,1,1,1,1,1,1,1,1,1	#REF!										0	0%	24.5	10	0
8	Long Gunner	5	10	Bastions	11	16	8	2	5,5	#REF!										0	0%	11.7	2	1
9	Long Gunner	5	10	Bastions	11	16	8	2	4,3,3	#REF!										0	0%	12.7	3	0
10	Long Gunner	5	10	Bastions	11	16	8	2	2,2,2,2,2	#REF!										0	0%	13.8	5	0
11	Long Gunner	5	10	Bastions	11	16	8	2	1,1,1,1,1,1,1,1,1,1	#REF!										0	0%	7.2	7	0
12	Long Gunner	5	10	Kayazy	14	11	1	2	5,5	#REF!										0	0%	20.2	2	2
13	Long Gunner	5	10	Kayazy	14	11	1	2	4,3,3	#REF!										0	0%	21.3	2	2
14	Long Gunner	5	10	Kayazy	14	11	1	2	2,2,2,2,2	#REF!										0	0%	23.3	3	3
15	Long Gunner	5	10	Kayazy	14	11	1	2	1,1,1,1,1,1,1,1,1,1	#REF!										0	0%	16.7	3	3
16	Stormblades	7	15	Iron Fang Pikemen	13	14	1	2	6	6										1	98%	13.7	1	1
17	Stormblades	7	15	Iron Fang Pikemen	13	14	1	2	6	6										1	98%	13.7	1	1
18	Stormblades	7	15	Iron Fang Pikemen	13	14	1	2	2,2,2	#REF!										0	0%	27.5	3	3
19	Stormblades	7	15	Iron Fang Pikemen	13	14	1	2	1,1,1,1,1,1	#REF!										0	0%	34.7	4	4
20	Stormblades	7	15	Bastions	11	16	8	2	2,2,2	#REF!										0	0%	23.5	3	2	The lesson here is "don't walk up your Stormblades and expect to kill many Bastions"
21	Stormblades	7	15	Bastions	11	16	8	2	1,1,1,1,1,1	#REF!										0	0%	33.0	6	2
22	Stormblades	7	15	Bastions	11	16	8	2	2,2,2	#REF!										0	0%	23.5	3	2
23	Stormblades	7	15	Bastions	11	16	8	2	1,1,1,1,1,1	#REF!										0	0%	33.0	6	2
24	Stormblades	7	15	Mountain King	9	21	49	2	8	8										1	98%	8.8	1	0	Obviously it's better to charge than not, but with un-boosted attacks, the damage difference between a 4,4 and an 8-man CMA is not that great.
25	Stormblades	7	15	Mountain King	9	21	49	2	4,4	#REF!										0	0%	9.8	2	0
26	Stormblades	7	15	Mountain King	9	21	49	3	8	8										1	98%	12.2	1	0	This shows that more damage will occur with two seperate attacks at 4,4, than with one single CMA
27	Stormblades	7	15	Mountain King	9	21	49	3	4,4	#REF!										0	0%	16.6	2	0
28									1,1,1,1,1	#REF!										0	0%	#NUM!	0	0
29										#NUM!										0	0%	#NUM!	0	0
30										#NUM!										0	0%	#NUM!	0	0
31										#NUM!										0	0%	#NUM!	0	0
32										#NUM!										0	0%	#NUM!	0	0
33										#NUM!										0	0%	#NUM!	0	0
34										#NUM!										0	0%	#NUM!	0	0
35										#NUM!										0	0%	#NUM!	0	0
36										#NUM!										0	0%	#NUM!	0	0
37
38
39	* doesn't take into account the higher MAT/RAT of some unit leaders
40																						version	0.7
41
42	This work is licensed under a Creative Commons Attribution-NonCommercial-ShareAlike 3.0 Unported License																					http://geeklyminis.blogspot.com/
43	http://creativecommons.org/licenses/by-nc-sa/3.0/deed.en_US
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