Hi guys,
I have a spreadsheet that contains numeric product IDs in column A, days in column B, number of orders in column C, returns in column D, cancellations in column E and debts in column F. I have included an extract for reference.
I am trying to come up with a formula for a rolling 5 day totals of net order numbers for each product.
To do this I need to look at column A for all products with the same ID, find the lowest 5 numbers for that product in column B (which may start from any number between 1 and 120 and may not be sequential), sum the corresponding numbers in column C and deduct the numbers in columns D, E and F. I then want to do the same for the lowest 2-6, 3-7, 4-8, etc until there are no more days for that product.
Is there a formula I can use to do this?
Thanks,
Rob
I have a spreadsheet that contains numeric product IDs in column A, days in column B, number of orders in column C, returns in column D, cancellations in column E and debts in column F. I have included an extract for reference.
I am trying to come up with a formula for a rolling 5 day totals of net order numbers for each product.
To do this I need to look at column A for all products with the same ID, find the lowest 5 numbers for that product in column B (which may start from any number between 1 and 120 and may not be sequential), sum the corresponding numbers in column C and deduct the numbers in columns D, E and F. I then want to do the same for the lowest 2-6, 3-7, 4-8, etc until there are no more days for that product.
Is there a formula I can use to do this?
Thanks,
Rob
Book1 | ||||||||
---|---|---|---|---|---|---|---|---|
A | B | C | D | E | F | |||
1 | productId | cDay | orders | returns | cancels | debts | ||
2 | 1031433 | 93 | 0 | 0 | 0 | 0 | ||
3 | 1031433 | 94 | 1 | 0 | 1 | 0 | ||
4 | 1031433 | 96 | 1 | 0 | 0 | 1 | ||
5 | 1031433 | 97 | 2 | 0 | 0 | 0 | ||
6 | 1031433 | 98 | 4 | 0 | 0 | 0 | ||
7 | 1031433 | 99 | 2 | 0 | 0 | 0 | ||
8 | 1031433 | 100 | 1 | 0 | 1 | 0 | ||
9 | 1031433 | 105 | 2 | 0 | 0 | 0 | ||
10 | 1031433 | 106 | 0 | 0 | 0 | 0 | ||
11 | 1031435 | 77 | 1 | 0 | 0 | 0 | ||
12 | 1031435 | 82 | 4 | 4 | 0 | 0 | ||
13 | 1031435 | 83 | 1 | 1 | 0 | 0 | ||
14 | 1031435 | 85 | 1 | 0 | 0 | 0 | ||
15 | 1031435 | 87 | 1 | 0 | 1 | 0 | ||
16 | 1031435 | 89 | 0 | 0 | 0 | 0 | ||
17 | 1031435 | 90 | 1 | 0 | 0 | 0 | ||
18 | 1031435 | 91 | 4 | 0 | 4 | 0 | ||
19 | 1031435 | 92 | 0 | 0 | 0 | 0 | ||
20 | 1031435 | 93 | 2 | 0 | 0 | 0 | ||
21 | 1031435 | 94 | 2 | 0 | 0 | 0 | ||
22 | 1031435 | 95 | 1 | 0 | 0 | 0 | ||
23 | 1031435 | 100 | 6 | 0 | 0 | 0 | ||
24 | 1031435 | 101 | 4 | 0 | 0 | 0 | ||
25 | 1031435 | 102 | 0 | 0 | 0 | 0 | ||
26 | 1031435 | 109 | 2 | 0 | 0 | 0 | ||
27 | 1031435 | 110 | 2 | 0 | 0 | 0 | ||
28 | 1031435 | 111 | 2 | 0 | 0 | 0 | ||
29 | 1031435 | 112 | 6 | 0 | 0 | 0 | ||
30 | 1031435 | 113 | 1 | 0 | 0 | 0 | ||
31 | 1031435 | 116 | 0 | 0 | 0 | 0 | ||
32 | 1031435 | 117 | 0 | 0 | 0 | 0 | ||
33 | 1031665 | 40 | 0 | 0 | 0 | 0 | ||
34 | 1031665 | 41 | 1 | 0 | 0 | 0 | ||
35 | 1031665 | 48 | 0 | 0 | 0 | 0 | ||
36 | 1031665 | 51 | 0 | 0 | 0 | 0 | ||
37 | 1031665 | 52 | 2 | 0 | 0 | 0 | ||
38 | 1031665 | 53 | 4 | 0 | 0 | 0 | ||
39 | 1031665 | 54 | 1 | 0 | 0 | 0 | ||
40 | 1031665 | 55 | 2 | 0 | 0 | 0 | ||
41 | 1031665 | 56 | 0 | 0 | 0 | 0 | ||
42 | 1031665 | 57 | 1 | 0 | 0 | 0 | ||
43 | 1031665 | 59 | 1 | 0 | 0 | 0 | ||
44 | 1031665 | 64 | 2 | 0 | 0 | 0 | ||
45 | 1031665 | 65 | 2 | 0 | 0 | 0 | ||
46 | 1031665 | 66 | 1 | 0 | 0 | 0 | ||
47 | 1031665 | 67 | 2 | 0 | 0 | 0 | ||
48 | 1031665 | 68 | 0 | 0 | 0 | 0 | ||
49 | 1031665 | 69 | 0 | 0 | 0 | 0 | ||
50 | 1031665 | 70 | 4 | 0 | 0 | 0 | ||
51 | 1031665 | 71 | 0 | 0 | 0 | 0 | ||
52 | 1031665 | 72 | 1 | 0 | 0 | 0 | ||
53 | 1031665 | 73 | 0 | 0 | 0 | 0 | ||
54 | 1031665 | 74 | 2 | 0 | 0 | 0 | ||
55 | 1031665 | 75 | 1 | 0 | 0 | 0 | ||
56 | 1031665 | 76 | 1 | 0 | 0 | 1 | ||
57 | 1031665 | 77 | 1 | 0 | 0 | 0 | ||
58 | 1031665 | 81 | 1 | 0 | 0 | 0 | ||
59 | 1031665 | 83 | 1 | 0 | 0 | 0 | ||
60 | 1031665 | 85 | 0 | 0 | 0 | 0 | ||
61 | 1034827 | 102 | 1 | 0 | 0 | 0 | ||
62 | 1034827 | 103 | 0 | 0 | 0 | 0 | ||
63 | 1034827 | 104 | 0 | 0 | 0 | 0 | ||
64 | 1034827 | 105 | 1 | 0 | 0 | 0 | ||
65 | 1034827 | 109 | 1 | 0 | 0 | 0 | ||
66 | 1034827 | 112 | 4 | 0 | 0 | 0 | ||
67 | 1034827 | 113 | 2 | 0 | 0 | 0 | ||
68 | 1034827 | 114 | 6 | 0 | 0 | 0 | ||
69 | 1034827 | 117 | 0 | 0 | 0 | 0 | ||
70 | 1034827 | 118 | 0 | 0 | 0 | 0 | ||
71 | 1034829 | 85 | 0 | 0 | 0 | 0 | ||
72 | 1034829 | 86 | 0 | 0 | 0 | 0 | ||
73 | 1068300 | 39 | 4 | 0 | 0 | 0 | ||
74 | 1068300 | 40 | 2 | 0 | 0 | 0 | ||
75 | 1068300 | 41 | 0 | 0 | 0 | 0 | ||
76 | 1068300 | 42 | 0 | 0 | 0 | 0 | ||
77 | 1068300 | 44 | 1 | 0 | 0 | 0 | ||
78 | 1068300 | 47 | 4 | 0 | 0 | 0 | ||
79 | 1068300 | 48 | 0 | 0 | 0 | 0 | ||
80 | 1068300 | 50 | 1 | 0 | 0 | 0 | ||
81 | 1068300 | 53 | 2 | 0 | 0 | 0 | ||
82 | 1068300 | 54 | 1 | 0 | 0 | 0 | ||
83 | 1068300 | 55 | 1 | 0 | 0 | 0 | ||
84 | 1068300 | 58 | 2 | 0 | 0 | 0 | ||
85 | 1068300 | 59 | 1 | 0 | 0 | 0 | ||
86 | 1068300 | 62 | 6 | 0 | 0 | 0 | ||
87 | 1068300 | 63 | 1 | 0 | 0 | 0 | ||
88 | 1068300 | 65 | 1 | 0 | 0 | 0 | ||
89 | 1068300 | 71 | 2 | 0 | 0 | 0 | ||
90 | 1068300 | 72 | 1 | 0 | 0 | 0 | ||
91 | 1068300 | 73 | 1 | 0 | 0 | 0 | ||
92 | 1068300 | 76 | 4 | 0 | 0 | 0 | ||
93 | 1068300 | 77 | 0 | 0 | 0 | 0 | ||
94 | 1068300 | 78 | 1 | 0 | 0 | 0 | ||
95 | 1068300 | 79 | 2 | 0 | 0 | 0 | ||
96 | 1068300 | 80 | 6 | 0 | 0 | 0 | ||
97 | 1068300 | 81 | 0 | 0 | 0 | 0 | ||
98 | 1068300 | 82 | 1 | 0 | 0 | 0 | ||
99 | 1068300 | 85 | 1 | 0 | 0 | 1 | ||
100 | 1068300 | 85 | 2 | 0 | 0 | 0 | ||
101 | 1068300 | 86 | 0 | 0 | 0 | 0 | ||
102 | 1068300 | 87 | 1 | 0 | 0 | 0 | ||
103 | 1068300 | 91 | 1 | 0 | 0 | 0 | ||
104 | 1068300 | 97 | 4 | 0 | 0 | 0 | ||
105 | 1068300 | 98 | 1 | 0 | 0 | 0 | ||
106 | 1068300 | 101 | 0 | 0 | 0 | 0 | ||
107 | 1068300 | 102 | 3 | 0 | 0 | 0 | ||
108 | 1068300 | 103 | 1 | 0 | 1 | 0 | ||
109 | 1068300 | 105 | 2 | 0 | 0 | 0 | ||
110 | 1068300 | 106 | 0 | 0 | 0 | 0 | ||
111 | 1068300 | 107 | 0 | 0 | 0 | 0 | ||
112 | 1068300 | 108 | 0 | 0 | 0 | 0 | ||
113 | 1068310 | 32 | 0 | 0 | 0 | 0 | ||
114 | 1068310 | 33 | 1 | 0 | 0 | 0 | ||
115 | 1068310 | 35 | 6 | 0 | 0 | 0 | ||
116 | 1068310 | 36 | 4 | 0 | 0 | 0 | ||
117 | 1068310 | 40 | 1 | 0 | 0 | 0 | ||
118 | 1068310 | 45 | 0 | 0 | 0 | 0 | ||
119 | 1068310 | 46 | 1 | 0 | 0 | 0 | ||
120 | 1068310 | 49 | 1 | 0 | 0 | 0 | ||
121 | 1068310 | 52 | 2 | 0 | 0 | 0 | ||
122 | 1068310 | 52 | 2 | 0 | 0 | 0 | ||
123 | 1068310 | 53 | 0 | 0 | 0 | 0 | ||
124 | 1068310 | 54 | 4 | 0 | 0 | 0 | ||
125 | 1068310 | 56 | 1 | 0 | 0 | 0 | ||
126 | 1068310 | 58 | 0 | 0 | 0 | 0 | ||
127 | 1068310 | 59 | 0 | 0 | 0 | 0 | ||
128 | 1068310 | 60 | 6 | 0 | 0 | 0 | ||
129 | 1068310 | 62 | 4 | 0 | 0 | 0 | ||
130 | 1068310 | 63 | 4 | 0 | 0 | 0 | ||
131 | 1068310 | 64 | 3 | 0 | 0 | 0 | ||
132 | 1068310 | 65 | 1 | 0 | 0 | 1 | ||
133 | 1068310 | 66 | 1 | 0 | 0 | 0 | ||
134 | 1068310 | 67 | 0 | 0 | 0 | 0 | ||
135 | 1068318 | 41 | 1 | 0 | 0 | 0 | ||
136 | 1068318 | 46 | 1 | 0 | 0 | 0 | ||
137 | 1068318 | 50 | 2 | 0 | 0 | 0 | ||
138 | 1068318 | 51 | 0 | 0 | 0 | 0 | ||
139 | 1068318 | 52 | 0 | 0 | 0 | 0 | ||
140 | 1068318 | 53 | 6 | 0 | 0 | 0 | ||
141 | 1068318 | 54 | 0 | 0 | 0 | 0 | ||
142 | 1068318 | 56 | 1 | 0 | 0 | 0 | ||
143 | 1068318 | 58 | 4 | 0 | 0 | 0 | ||
144 | 1068318 | 59 | 1 | 0 | 0 | 0 | ||
145 | 1068318 | 61 | 0 | 0 | 0 | 0 | ||
146 | 1068318 | 62 | 4 | 0 | 0 | 0 | ||
147 | 1068318 | 63 | 1 | 0 | 0 | 1 | ||
148 | 1068318 | 63 | 2 | 0 | 0 | 0 | ||
149 | 1068318 | 64 | 4 | 0 | 0 | 0 | ||
150 | 1068318 | 65 | 1 | 0 | 0 | 0 | ||
151 | 1068318 | 68 | 1 | 0 | 0 | 0 | ||
152 | 1068318 | 71 | 0 | 0 | 0 | 0 | ||
153 | 1068318 | 72 | 0 | 0 | 0 | 0 | ||
154 | 1068324 | 40 | 1 | 0 | 0 | 0 | ||
155 | 1068324 | 42 | 1 | 0 | 0 | 0 | ||
156 | 1068324 | 43 | 1 | 0 | 0 | 1 | ||
157 | 1068324 | 43 | 0 | 0 | 0 | 0 | ||
158 | 1068324 | 44 | 4 | 0 | 0 | 0 | ||
159 | 1068324 | 45 | 2 | 0 | 0 | 0 | ||
160 | 1068324 | 46 | 1 | 0 | 0 | 0 | ||
161 | 1068324 | 48 | 3 | 0 | 0 | 0 | ||
162 | 1068324 | 49 | 0 | 0 | 0 | 0 | ||
163 | 1068324 | 50 | 1 | 0 | 0 | 0 | ||
164 | 1068324 | 53 | 4 | 0 | 0 | 0 | ||
165 | 1068324 | 54 | 1 | 0 | 0 | 0 | ||
166 | 1068324 | 55 | 1 | 0 | 0 | 0 | ||
167 | 1068324 | 59 | 0 | 0 | 0 | 0 | ||
168 | 1068324 | 60 | 1 | 0 | 0 | 0 | ||
169 | 1068324 | 61 | 1 | 0 | 0 | 0 | ||
170 | 1068324 | 63 | 1 | 0 | 0 | 0 | ||
171 | 1068324 | 65 | 1 | 0 | 0 | 0 | ||
172 | 1068324 | 70 | 1 | 0 | 0 | 0 | ||
173 | 1068324 | 73 | 0 | 0 | 0 | 0 | ||
174 | 1068324 | 74 | 1 | 0 | 0 | 0 | ||
175 | 1068324 | 77 | 1 | 0 | 0 | 0 | ||
176 | 1068324 | 80 | 1 | 0 | 0 | 0 | ||
177 | 1068324 | 84 | 1 | 0 | 0 | 0 | ||
178 | 1068324 | 85 | 1 | 0 | 0 | 0 | ||
179 | 1068324 | 87 | 1 | 0 | 0 | 0 | ||
180 | 1068324 | 90 | 1 | 0 | 0 | 0 | ||
181 | 1068324 | 91 | 2 | 0 | 0 | 0 | ||
182 | 1068324 | 92 | 0 | 0 | 0 | 0 | ||
183 | 1068324 | 93 | 2 | 0 | 0 | 0 | ||
184 | 1068324 | 93 | 0 | 0 | 0 | 0 | ||
185 | 1068324 | 94 | 1 | 0 | 0 | 0 | ||
186 | 1068324 | 99 | 1 | 0 | 0 | 0 | ||
187 | 1068324 | 101 | 1 | 0 | 0 | 0 | ||
188 | 1068324 | 103 | 1 | 0 | 0 | 0 | ||
189 | 1068324 | 105 | 4 | 0 | 0 | 0 | ||
190 | 1068324 | 106 | 1 | 0 | 0 | 1 | ||
191 | 1068324 | 106 | 0 | 0 | 0 | 0 | ||
192 | 1068324 | 107 | 1 | 0 | 0 | 0 | ||
193 | 1068346 | 35 | 0 | 0 | 0 | 0 | ||
194 | 1068346 | 36 | 0 | 0 | 0 | 0 | ||
195 | 1068346 | 39 | 1 | 0 | 0 | 0 | ||
196 | 1068346 | 44 | 1 | 0 | 0 | 0 | ||
197 | 1068346 | 46 | 2 | 0 | 0 | 0 | ||
198 | 1068346 | 47 | 0 | 0 | 0 | 0 | ||
199 | 1068351 | 50 | 0 | 0 | 0 | 0 | ||
200 | 1068351 | 51 | 1 | 0 | 0 | 0 | ||
201 | 1068351 | 54 | 0 | 0 | 0 | 0 | ||
202 | 1068351 | 58 | 0 | 0 | 0 | 0 | ||
203 | 1068373 | 37 | 1 | 0 | 0 | 0 | ||
204 | 1068373 | 40 | 1 | 0 | 0 | 0 | ||
205 | 1068373 | 42 | 1 | 0 | 0 | 0 | ||
206 | 1068373 | 43 | 1 | 0 | 0 | 0 | ||
207 | 1068373 | 45 | 0 | 0 | 0 | 0 | ||
208 | 1068373 | 46 | 1 | 0 | 0 | 0 | ||
209 | 1068373 | 48 | 1 | 0 | 0 | 0 | ||
210 | 1068373 | 49 | 3 | 0 | 0 | 0 | ||
211 | 1068373 | 53 | 1 | 0 | 0 | 0 | ||
212 | 1068373 | 56 | 1 | 0 | 0 | 0 | ||
213 | 1068373 | 58 | 1 | 0 | 0 | 0 | ||
214 | 1068373 | 60 | 1 | 0 | 0 | 0 | ||
215 | 1068373 | 61 | 1 | 0 | 0 | 0 | ||
216 | 1068373 | 63 | 1 | 0 | 0 | 0 | ||
217 | 1068373 | 65 | 2 | 0 | 0 | 0 | ||
218 | 1068373 | 66 | 1 | 0 | 0 | 0 | ||
219 | 1068373 | 67 | 1 | 0 | 0 | 0 | ||
220 | 1068373 | 74 | 3 | 0 | 0 | 0 | ||
221 | 1068373 | 76 | 1 | 0 | 1 | 0 | ||
222 | 1068373 | 78 | 4 | 0 | 0 | 0 | ||
223 | 1068373 | 82 | 4 | 0 | 0 | 0 | ||
224 | 1068373 | 83 | 1 | 0 | 0 | 0 | ||
225 | 1068373 | 87 | 1 | 0 | 0 | 0 | ||
226 | 1068373 | 92 | 2 | 0 | 0 | 0 | ||
227 | 1068373 | 93 | 2 | 0 | 0 | 0 | ||
228 | 1068373 | 94 | 1 | 0 | 0 | 0 | ||
229 | 1068373 | 99 | 2 | 0 | 0 | 0 | ||
230 | 1068373 | 100 | 4 | 0 | 0 | 0 | ||
231 | 1068373 | 101 | 1 | 0 | 0 | 0 | ||
232 | 1068373 | 103 | 2 | 0 | 0 | 0 | ||
233 | 1068373 | 104 | 2 | 0 | 0 | 0 | ||
234 | 1068373 | 105 | 1 | 0 | 0 | 0 | ||
235 | 1068373 | 107 | 1 | 0 | 0 | 0 | ||
236 | 1068373 | 109 | 6 | 0 | 0 | 0 | ||
237 | 1068373 | 110 | 0 | 0 | 0 | 0 | ||
238 | 1068373 | 111 | 4 | 0 | 0 | 0 | ||
239 | 1068373 | 112 | 1 | 0 | 0 | 0 | ||
240 | 1068373 | 115 | 4 | 0 | 0 | 0 | ||
241 | 1068373 | 116 | 2 | 0 | 0 | 0 | ||
242 | 1068373 | 117 | 1 | 0 | 0 | 0 | ||
243 | 1068373 | 118 | 4 | 0 | 0 | 0 | ||
244 | 1068373 | 119 | 6 | 0 | 0 | 0 | ||
245 | 1068373 | 120 | 2 | 0 | 0 | 0 | ||
246 | 1068378 | 12 | 0 | 0 | 0 | 0 | ||
247 | 1068378 | 16 | 0 | 0 | 0 | 0 | ||
248 | 1068378 | 17 | 6 | 0 | 0 | 0 | ||
249 | 1068378 | 18 | 1 | 0 | 0 | 0 | ||
250 | 1068378 | 19 | 1 | 0 | 0 | 0 | ||
251 | 1068378 | 25 | 0 | 0 | 0 | 0 | ||
252 | 1068382 | 43 | 0 | 0 | 0 | 0 | ||
253 | 1068382 | 44 | 0 | 0 | 0 | 0 | ||
254 | 1068382 | 45 | 0 | 0 | 0 | 0 | ||
255 | 1068382 | 46 | 1 | 0 | 0 | 0 | ||
256 | 1068382 | 47 | 2 | 0 | 0 | 0 | ||
257 | 1068382 | 48 | 0 | 0 | 0 | 0 | ||
258 | 1068382 | 50 | 1 | 0 | 0 | 0 | ||
259 | 1068382 | 56 | 1 | 0 | 0 | 0 | ||
260 | 1068382 | 60 | 1 | 0 | 0 | 0 | ||
261 | 1068382 | 61 | 4 | 0 | 0 | 0 | ||
262 | 1068382 | 62 | 1 | 0 | 0 | 0 | ||
263 | 1068382 | 63 | 1 | 0 | 0 | 0 | ||
264 | 1068382 | 66 | 1 | 0 | 0 | 0 | ||
265 | 1068382 | 67 | 6 | 0 | 0 | 0 | ||
266 | 1068382 | 68 | 0 | 0 | 0 | 0 | ||
267 | 1068382 | 69 | 1 | 0 | 0 | 0 | ||
268 | 1068382 | 77 | 4 | 0 | 0 | 0 | ||
269 | 1068382 | 78 | 0 | 0 | 0 | 0 | ||
270 | 1068382 | 82 | 1 | 0 | 0 | 0 | ||
271 | 1068382 | 85 | 4 | 0 | 0 | 0 | ||
272 | 1068382 | 86 | 1 | 0 | 0 | 0 | ||
273 | 1068382 | 88 | 0 | 0 | 0 | 0 | ||
274 | 1068382 | 89 | 1 | 0 | 0 | 0 | ||
275 | 1068382 | 91 | 1 | 0 | 0 | 0 | ||
276 | 1068382 | 94 | 0 | 0 | 0 | 0 | ||
277 | 1068382 | 95 | 4 | 0 | 0 | 0 | ||
278 | 1068382 | 96 | 4 | 0 | 0 | 0 | ||
279 | 1068382 | 98 | 1 | 0 | 0 | 0 | ||
280 | 1068382 | 102 | 2 | 0 | 0 | 0 | ||
281 | 1068382 | 103 | 5 | 0 | 0 | 5 | ||
282 | 1068382 | 104 | 6 | 0 | 0 | 0 | ||
283 | 1068382 | 105 | 0 | 0 | 0 | 0 | ||
284 | 1068382 | 106 | 2 | 0 | 0 | 0 | ||
285 | 1068382 | 107 | 0 | 0 | 0 | 0 | ||
286 | 1068382 | 108 | 1 | 0 | 0 | 0 | ||
287 | 1068382 | 109 | 0 | 0 | 0 | 0 | ||
288 | 1068382 | 110 | 2 | 0 | 0 | 0 | ||
289 | 1068382 | 111 | 1 | 0 | 0 | 0 | ||
290 | 1068382 | 114 | 2 | 0 | 0 | 0 | ||
291 | 1068382 | 116 | 2 | 0 | 0 | 0 | ||
292 | 1068382 | 117 | 0 | 0 | 0 | 0 | ||
293 | 1068401 | 49 | 0 | 0 | 0 | 0 | ||
294 | 1068401 | 50 | 0 | 0 | 0 | 0 | ||
295 | 1068401 | 51 | 6 | 0 | 0 | 0 | ||
296 | 1068401 | 52 | 1 | 0 | 0 | 0 | ||
297 | 1068401 | 54 | 1 | 0 | 0 | 0 | ||
298 | 1068401 | 55 | 1 | 0 | 0 | 0 | ||
299 | 1068401 | 59 | 1 | 0 | 0 | 0 | ||
300 | 1068401 | 61 | 2 | 0 | 0 | 0 | ||
301 | 1068401 | 62 | 1 | 0 | 0 | 0 | ||
302 | 1068401 | 66 | 0 | 0 | 0 | 0 | ||
303 | 1068401 | 73 | 4 | 0 | 0 | 0 | ||
304 | 1068401 | 74 | 1 | 0 | 0 | 0 | ||
305 | 1068401 | 76 | 2 | 0 | 0 | 0 | ||
306 | 1068401 | 77 | 1 | 0 | 0 | 0 | ||
307 | 1068401 | 80 | 1 | 0 | 0 | 1 | ||
308 | 1068401 | 80 | 2 | 0 | 0 | 0 | ||
309 | 1068401 | 81 | 0 | 0 | 0 | 0 | ||
310 | 1068411 | 41 | 0 | 0 | 0 | 0 | ||
311 | 1068411 | 42 | 0 | 0 | 0 | 0 | ||
312 | 1068411 | 46 | 0 | 0 | 0 | 0 | ||
313 | 1068411 | 47 | 2 | 0 | 0 | 0 | ||
314 | 1068411 | 48 | 2 | 0 | 0 | 0 | ||
315 | 1068411 | 51 | 0 | 0 | 0 | 0 | ||
316 | 1068411 | 52 | 1 | 0 | 0 | 0 | ||
317 | 1068411 | 54 | 1 | 0 | 0 | 0 | ||
318 | 1068411 | 55 | 1 | 0 | 0 | 0 | ||
319 | 1068411 | 57 | 1 | 0 | 0 | 0 | ||
320 | 1068411 | 59 | 1 | 0 | 0 | 0 | ||
321 | 1068411 | 62 | 2 | 0 | 0 | 0 | ||
322 | 1068411 | 63 | 1 | 0 | 0 | 0 | ||
323 | 1068411 | 67 | 2 | 0 | 0 | 0 | ||
324 | 1068411 | 68 | 1 | 0 | 0 | 0 | ||
325 | 1068411 | 70 | 0 | 0 | 0 | 0 | ||
326 | 1068411 | 71 | 0 | 0 | 0 | 0 | ||
327 | 1068411 | 72 | 0 | 0 | 0 | 0 | ||
328 | 1068411 | 75 | 0 | 0 | 0 | 0 | ||
329 | 1068411 | 76 | 0 | 0 | 0 | 0 | ||
330 | 1068411 | 77 | 1 | 1 | 0 | 0 | ||
331 | 1068411 | 80 | 0 | 0 | 0 | 0 | ||
332 | 1068411 | 81 | 6 | 0 | 0 | 0 | ||
333 | 1068411 | 82 | 0 | 0 | 0 | 0 | ||
334 | 1068411 | 83 | 4 | 0 | 0 | 0 | ||
335 | 1068411 | 84 | 1 | 0 | 0 | 0 | ||
336 | 1068411 | 85 | 4 | 0 | 0 | 0 | ||
337 | 1068411 | 86 | 1 | 0 | 0 | 0 | ||
338 | 1068411 | 88 | 4 | 0 | 0 | 0 | ||
339 | 1068411 | 89 | 1 | 0 | 0 | 0 | ||
340 | 1068411 | 91 | 0 | 0 | 0 | 0 | ||
341 | 1068411 | 92 | 0 | 0 | 0 | 0 | ||
342 | 1068411 | 93 | 0 | 0 | 0 | 0 | ||
343 | 1068411 | 94 | 1 | 0 | 0 | 0 | ||
344 | 1068411 | 98 | 6 | 0 | 0 | 0 | ||
345 | 1068411 | 99 | 2 | 0 | 0 | 0 | ||
346 | 1068411 | 100 | 1 | 0 | 0 | 0 | ||
347 | 1068411 | 102 | 1 | 0 | 0 | 0 | ||
348 | 1068411 | 103 | 1 | 0 | 0 | 0 | ||
349 | 1068411 | 105 | 1 | 0 | 0 | 1 | ||
350 | 1068411 | 105 | 4 | 0 | 0 | 0 | ||
351 | 1068421 | 41 | 1 | 0 | 0 | 0 | ||
352 | 1068421 | 43 | 1 | 0 | 0 | 0 | ||
353 | 1068421 | 47 | 0 | 0 | 0 | 0 | ||
354 | 1068421 | 48 | 1 | 0 | 0 | 0 | ||
355 | 1068421 | 49 | 1 | 0 | 0 | 0 | ||
356 | 1068421 | 51 | 2 | 0 | 0 | 0 | ||
357 | 1068421 | 52 | 1 | 0 | 0 | 0 | ||
358 | 1068421 | 54 | 1 | 0 | 0 | 0 | ||
359 | 1068421 | 55 | 1 | 0 | 0 | 0 | ||
360 | 1068421 | 57 | 1 | 0 | 0 | 0 | ||
361 | 1068421 | 58 | 1 | 0 | 0 | 1 | ||
362 | 1068421 | 59 | 4 | 0 | 0 | 0 | ||
363 | 1068421 | 60 | 0 | 0 | 0 | 0 | ||
364 | 1068421 | 63 | 1 | 0 | 0 | 0 | ||
365 | 1068421 | 65 | 1 | 0 | 0 | 0 | ||
366 | 1068421 | 68 | 1 | 0 | 0 | 0 | ||
367 | 1068421 | 70 | 1 | 0 | 0 | 0 | ||
368 | 1068421 | 74 | 6 | 0 | 0 | 0 | ||
369 | 1068421 | 75 | 1 | 0 | 0 | 0 | ||
370 | 1068421 | 77 | 2 | 0 | 0 | 0 | ||
371 | 1068421 | 78 | 1 | 0 | 0 | 0 | ||
372 | 1068421 | 79 | 1 | 0 | 0 | 0 | ||
373 | 1068421 | 81 | 1 | 0 | 0 | 0 | ||
374 | 1068421 | 83 | 1 | 0 | 0 | 0 | ||
375 | 1068421 | 85 | 2 | 0 | 0 | 0 | ||
376 | 1068421 | 86 | 0 | 0 | 0 | 0 | ||
377 | 1068421 | 87 | 0 | 0 | 0 | 0 | ||
378 | 1068421 | 88 | 1 | 0 | 0 | 0 | ||
379 | 1068421 | 90 | 1 | 0 | 0 | 0 | ||
380 | 1068421 | 91 | 4 | 0 | 0 | 0 | ||
381 | 1068421 | 92 | 1 | 0 | 0 | 0 | ||
382 | 1068421 | 96 | 1 | 0 | 0 | 0 | ||
383 | 1068421 | 97 | 1 | 0 | 0 | 0 | ||
384 | 1068421 | 99 | 6 | 0 | 0 | 0 | ||
385 | 1068421 | 100 | 1 | 0 | 0 | 0 | ||
386 | 1068421 | 104 | 1 | 0 | 0 | 0 | ||
387 | 1068421 | 106 | 4 | 0 | 0 | 0 | ||
388 | 1068421 | 107 | 0 | 0 | 0 | 0 | ||
389 | 1068421 | 108 | 1 | 0 | 0 | 0 | ||
390 | 1068421 | 109 | 0 | 0 | 0 | 0 | ||
391 | 1068421 | 110 | 1 | 0 | 0 | 0 | ||
392 | 1068421 | 113 | 2 | 0 | 0 | 0 | ||
393 | 1068421 | 114 | 0 | 0 | 0 | 0 | ||
394 | 1072317 | 60 | 1 | 0 | 0 | 0 | ||
395 | 1072317 | 61 | 1 | 0 | 0 | 0 | ||
396 | 1072317 | 65 | 1 | 0 | 0 | 0 | ||
397 | 1072317 | 67 | 1 | 0 | 0 | 0 | ||
398 | 1072317 | 69 | 1 | 0 | 0 | 0 | ||
399 | 1072317 | 72 | 0 | 0 | 0 | 0 | ||
400 | 1072317 | 73 | 1 | 0 | 0 | 1 | ||
401 | 1072317 | 74 | 0 | 0 | 0 | 0 | ||
402 | 1072318 | 25 | 0 | 0 | 0 | 0 | ||
403 | 1072318 | 26 | 0 | 0 | 0 | 0 | ||
404 | 1072318 | 27 | 0 | 0 | 0 | 0 | ||
405 | 1072318 | 28 | 0 | 0 | 0 | 0 | ||
406 | 1072318 | 29 | 1 | 0 | 0 | 0 | ||
407 | 1072318 | 32 | 0 | 0 | 0 | 0 | ||
408 | 1072318 | 33 | 0 | 0 | 0 | 0 | ||
409 | 1072318 | 34 | 4 | 0 | 0 | 0 | ||
410 | 1072318 | 35 | 0 | 0 | 0 | 0 | ||
411 | 1072318 | 36 | 1 | 0 | 0 | 0 | ||
412 | 1072318 | 37 | 2 | 0 | 0 | 0 | ||
413 | 1072318 | 38 | 1 | 0 | 0 | 0 | ||
414 | 1072318 | 42 | 3 | 0 | 0 | 0 | ||
415 | 1072318 | 43 | 0 | 0 | 0 | 0 | ||
416 | 1072318 | 44 | 1 | 0 | 0 | 0 | ||
417 | 1072318 | 48 | 2 | 0 | 0 | 0 | ||
418 | 1072318 | 50 | 1 | 0 | 0 | 0 | ||
419 | 1072318 | 53 | 4 | 0 | 0 | 0 | ||
420 | 1072318 | 54 | 1 | 0 | 0 | 0 | ||
421 | 1072318 | 55 | 1 | 0 | 0 | 0 | ||
422 | 1072318 | 57 | 0 | 0 | 0 | 0 | ||
423 | 1072318 | 58 | 1 | 0 | 0 | 0 | ||
424 | 1072318 | 62 | 1 | 0 | 0 | 1 | ||
425 | 1072318 | 63 | 1 | 0 | 0 | 0 | ||
426 | 1072318 | 67 | 0 | 0 | 0 | 0 | ||
427 | 1072318 | 68 | 0 | 0 | 0 | 0 | ||
428 | 1072318 | 69 | 1 | 0 | 0 | 0 | ||
429 | 1072318 | 76 | 0 | 0 | 0 | 0 | ||
430 | 1072318 | 77 | 1 | 0 | 0 | 0 | ||
431 | 1072318 | 79 | 1 | 0 | 0 | 0 | ||
432 | 1072318 | 81 | 1 | 0 | 0 | 0 | ||
433 | 1072318 | 84 | 0 | 0 | 0 | 0 | ||
434 | 1072318 | 87 | 0 | 0 | 0 | 0 | ||
435 | 1072318 | 88 | 2 | 2 | 0 | 0 | ||
436 | 1072318 | 89 | 1 | 0 | 0 | 0 | ||
437 | 1072318 | 91 | 1 | 0 | 0 | 0 | ||
438 | 1072318 | 94 | 0 | 0 | 0 | 0 | ||
439 | 1072318 | 95 | 1 | 0 | 0 | 0 | ||
440 | 1072318 | 97 | 1 | 0 | 0 | 0 | ||
441 | 1072318 | 100 | 0 | 0 | 0 | 0 | ||
442 | 1072318 | 101 | 1 | 0 | 0 | 1 | ||
443 | 1072318 | 101 | 2 | 0 | 0 | 0 | ||
444 | 1072318 | 102 | 0 | 0 | 0 | 0 | ||
445 | 1072318 | 106 | 1 | 0 | 0 | 1 | ||
446 | 1072318 | 106 | 4 | 0 | 0 | 0 | ||
447 | 1072318 | 107 | 0 | 0 | 0 | 0 | ||
448 | 1072318 | 108 | 2 | 0 | 0 | 0 | ||
449 | 1072318 | 110 | 1 | 0 | 0 | 0 | ||
450 | 1072318 | 114 | 2 | 0 | 0 | 0 | ||
451 | 1072318 | 117 | 2 | 0 | 0 | 0 | ||
452 | 1072318 | 118 | 1 | 0 | 0 | 0 | ||
453 | 1072318 | 120 | 0 | 0 | 0 | 0 | ||
454 | 1072319 | 66 | 1 | 0 | 0 | 0 | ||
455 | 1072319 | 67 | 0 | 0 | 0 | 0 | ||
456 | 1072319 | 68 | 1 | 0 | 0 | 0 | ||
457 | 1072319 | 72 | 0 | 0 | 0 | 0 | ||
458 | 1072321 | 75 | 1 | 0 | 0 | 0 | ||
459 | 1072321 | 77 | 0 | 0 | 0 | 0 | ||
460 | 1072321 | 78 | 0 | 0 | 0 | 0 | ||
461 | 1072321 | 80 | 1 | 0 | 0 | 0 | ||
462 | 1072321 | 84 | 0 | 0 | 0 | 0 | ||
463 | 1082592 | 3 | 5 | 0 | 0 | 0 | ||
464 | 1082592 | 7 | 4 | 0 | 0 | 0 | ||
465 | 1082592 | 8 | 0 | 0 | 0 | 0 | ||
466 | 1082592 | 9 | 4 | 0 | 0 | 0 | ||
467 | 1082592 | 10 | 0 | 0 | 0 | 0 | ||
468 | 1082592 | 11 | 0 | 0 | 0 | 0 | ||
469 | 1082592 | 12 | 0 | 0 | 0 | 0 | ||
470 | 1082592 | 20 | 0 | 0 | 0 | 0 | ||
471 | 1082592 | 21 | 0 | 0 | 0 | 0 | ||
472 | 1082592 | 22 | 6 | 0 | 0 | 0 | ||
473 | 1082592 | 23 | 6 | 0 | 0 | 0 | ||
474 | 1082592 | 24 | 0 | 0 | 0 | 0 | ||
475 | 1082592 | 29 | 1 | 0 | 0 | 0 | ||
Sheet1 |