Capsim - COMPXM - Free Excel File for Prediction and Calculation - For CompXM 2023.xlsx

	A	B	C	D	E	F	G	H	I	J	K	L	M	N	O	P	Q	R	S	T	U
1		Thrift		Core		Nano		Elite		SWEET SPOTS		Thrift		Core		Nano		Elite		SWEET 2
2	Round	Pfmn	Size	Pfmn	Size	Pfmn	Size	Pfmn	Size	STRATEGY 4	Round	Pfmn	Size	Pfmn	Size	Pfmn	Size	Pfmn	Size	STRATEGY 3
3	1	7.6	12.5							add 1/3 IDEAL	1	7.6	12.5							add 1/2 IDEAL
4	2	8.1	12.0							33% adjust	2	8.1	12.0							50% adjust
5	3	8.6	11.5								3	8.6	11.5
6	4	9.1	11.0	12.0	8.1						4	9.1	11.0	12.0	8.1
7		-	-	0.13	(0.13)	0.26	(0.36)	0.36	(0.26)			-	-	0.02	(0.02)	0.04	(0.06)	0.06	(0.04)
8		Thrift		Core		Nano		Elite		IDEAL SPOTS		Thrift		Core		Nano		Elite		STRATEGY 1
9	Round	Pfmn	Size	Pfmn	Size	Pfmn	Size	Pfmn	Size	STRATEGY 2	Round	Pfmn	Size	Pfmn	Size	Pfmn	Size	Pfmn	Size
10											0	7.1	13.0	8.8	11.3	10.3	8.1	12.0	9.8	START HERE	Replace this row only by numbers from YOUR CompXM Industry Condition Report
11	1	7.6	12.5	10.0	10.1	11.9	5.9	14.2	8.2		1	7.6	12.5	9.6	10.5	11.1	7.0	13.1	9.0
12	2	8.1	12.0	10.8	9.3	12.7	4.8	15.3	7.4		2	8.1	12.0	10.4	9.7	11.9	5.9	14.2	8.2
13	3	8.6	11.5	11.6	8.5	13.5	3.7	16.4	6.6		3	8.6	11.5	11.2	8.9	12.7	4.8	15.3	7.4
14	4	9.1	11.0	12.4	7.7	14.3	2.6	17.5	5.8		4	9.1	11.0	12.0	8.1	13.5	3.7	16.4	6.6
15											Drift	0.5	(0.5)	0.8	(0.8)	0.8	(1.1)	1.1	(0.8)
16		-	-	0.4	(0.4)	0.8	(1.1)	1.1	(0.8)		Ideal Spot	-	-	0.4	(0.4)	0.8	(1.1)	1.1	(0.8)
17												14000	20000	16000	22000	18000	24000	20000	26000
18												16000		18,000		20000		22000
19		Growth
20	Thrift	11%
21	Core	10%
22	Nano	14%
23	Elite	16%
24
25	Thrift	Price	14	26	55%	20		AFT	20	22
26		MTBF	14000	20000	20%	17000		18000
27		Ideal	6.8	13.2	15%
28		Age	3		10%
29
30	Core	Price	20	32	46%	26		AGAPE	30	30
31		Age	2		20%
32		MTBF	16000	22000	18%	19000		20000
33		Ideal	8.9	11.1	16%
34
35	Nano	Ideal	10.8	7.2	35%			ABBY	39	38
36		Price	28	40	27%	34
37		Age	1		20%
38		MTBF	18000	24000	18%	21000		22000
39
40	Elite	Age	0		34%			ALAN	41	42
41		Price	33	42	24%	38
42		Ideal	12.8	9.2	22%
43		MTBF	20000	26000	20%	23000		24000
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