Scrubbed Table specs.xlsx

	G	H	I	J	K	L	N	O	P	Q	R	S	T	U	V	W	X
1	Raw data						Transformed data
2	Category Name	Brand Cells	Measure/KPI	MAT Q2 2022 (MAT)	MAT Q2 2022 vs. MAT Q2 2021 (MAT Sig)	Performance Classification			Perceived	Perceived	Perceived	Power	Power	Power	Premium	Premium	Premium
3	XYZ	AM	Perceived	36.0	0	Good	Category Name	Brand Cells	MAT Q2 2022 (MAT)	MAT Q2 2022 vs. MAT Q2 2021 (MAT Sig)	Performance Classification	MAT Q2 2022 (MAT)	MAT Q2 2022 vs. MAT Q2 2021 (MAT Sig)	Performance Classification	Power Index	MAT Q2 2022 vs. MAT Q2 2021 (MAT Sig)	Performance Classification
4	XYZ	Ay	Perceived	67.0	1	Bad	XYZ	AM
5	XYZ	AM	Power	1.0	-1	Good	XYZ	Ay
6	XYZ	Ay	Power	33.0	0	Good
7	XYZ	AM	Premium	47.0	0	Bad
8	XYZ	Ay	Premium	90.0	1	Bad
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
32
33
34
35
36
37
38
39
40
41
42
43
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