ABCDEFGHIJKLMNOPQRSTUVWXYZ
1
end_weekchain_idretail_numberstore_ziphq_indicatorcarton
2
11/9/20241c112345N100
3
11/9/20241c212346Y0
4
11/9/20241c312347N-5
5
11/9/20241c412348N100
6
11/9/20240s112345N200
7
11/9/20240s212346N300
8
11/9/20240s312348N400
9
11/9/20240s412348N-20
10
11/9/20240s512348N500
11
12
Trade Area (TA) definition
13
find all store zipcode for selected chain and end_week, only includes non-hq store zip when store total volume > 0
14
in the example, the TA zipcodes are 12345 and 12348
15
16
Chain volume = sum carton for selected chain = 195
17
18
Chain store count = count store with total volume > 0 = 2
19
20
TA volume gross (TA volume include selected chain volume) = 1280 (all high-lighted rows above)
21
TA volume net (TA volume excludes selected chain volume) = 1080 (high-lighted rows above in pink)
22
23
store count : only include store when total store volume >0
24
TA store count gross (TA store count include selected chain store count) = 5 (all high-lighted rows above except row 9)
25
TA store count net (TA store count excludes selected chain store count) = 2 (high-lighted rows above in pink without store s4)
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