Receipt Segmented AM06 - Google Sheets

	B	C	D	E	F	G	H	I	J	K	L	M	N	O
1		Periode :	16/12/2024		s/d	16/12/2024
2		LM :	01/08/2024		s/d	16/12/2024
3
4		REVIEW TRX ALL RECEIPT AM06
5		MTD 14 JULY 2024
6
7	NO	FLAG	TRX	TRX LM	TRX vs LM	VALUE	VALUE LM	VALUE vs LM	BS	% CONTR. VALUE	%CONTR. TRX TO ALL RECEIPT	%CONTR. TRX ALL vs LM	BS LM	BS vs LM
8	1	< 50.000	139	#REF!	#REF!	4.744.039	#REF!	#REF!	34.130	0,9%	13,4%	#REF!	#REF!	#REF!
9	2	50K - 200K	367	#REF!	#REF!	42.152.932	#VALUE!	#VALUE!	114.858	7,9%	35,3%	#REF!	#VALUE!	#VALUE!
10	3	200K - 300K	100	#REF!	#REF!	25.025.236	#VALUE!	#VALUE!	250.252	4,7%	9,6%	#REF!	#VALUE!	#VALUE!
11	4	300K - 500K	112	#REF!	#REF!	41.622.757	#VALUE!	#VALUE!	371.632	7,8%	10,8%	#REF!	#VALUE!	#VALUE!
12	5	500K - 1M	172	#VALUE!	#VALUE!	84.170.166	#VALUE!	#VALUE!	489.361	15,9%	16,5%	#REF!	#VALUE!	#VALUE!
13	6	1M - 5M	115	#REF!	#REF!	218.362.695	#VALUE!	#VALUE!	1.898.806	41,1%	11,0%	#REF!	#VALUE!	#VALUE!
14	7	5M - 10M	12	#REF!	#REF!	85.077.591	#VALUE!	0,0%	7.089.799	16,0%	1,2%	#REF!	0	0,0%
15	8	10M - 20M	23	#REF!	#REF!	3.578.340	#VALUE!	0,0%	155.580	0,7%	2,2%	#REF!	0	0,0%
16	9	20M - 50M	1	#REF!	#REF!	26.260.181	#REF!	0,0%	26.260.181	4,9%	0,1%	#REF!	0	0,0%
17	10	50M - 100M	0	#REF!	0,0%	0	#REF!	0,0%	0	0,0%	0,0%	#REF!	0	0,0%
18	11	>100M	0	#REF!	0,0%	0	#REF!	0,0%	0	0,0%	0,0%	#REF!	0	0,0%
19		TOTAL	1.041	#REF!	#REF!	530.993.937	#REF!	#REF!	510.081	100%	100%	#REF!	#REF!	#REF!
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