Forum Discussion

deokars43's avatar
deokars43
Copper Contributor
Oct 29, 2022

Microsoft excel average function.

Spoiler
 

I want help with Microsoft excel average function. Please help me with following conditions in excel.
Data is attached below.

1What is the average total USD rev/parent?
2What is the average total USD rev/parent if you exclude parents which have revenue only in D product (i.e 0 rev in other products)
3What % of revenue comes from parents whose total revenue <100 USD, 100-200 USD, 200-500 USD, >500 USD
4How many parents have revenue >100 USD in date range of Dec 1 to Dec 10

 

Data 

All rev in USD     
Child IdParent Company IDDate RangeRev from Product ARev from Product BRev from Product CRev from Product D
1b12017-12-01 -> 2017-12-0100.1900
2b12017-12-18 -> 2017-12-18000.310
3b12017-12-07 -> 2017-12-07000.460
4b22017-12-24 -> 2017-12-25001.070
5b32017-12-06 -> 2017-12-20001.180
6b32017-12-24 -> 2017-12-29001.470
1b12017-12-01 -> 2017-12-01002.180
2b12017-12-01 -> 2017-12-01002.690
3b12017-12-26 -> 2017-12-30002.970
4b22017-12-01 -> 2017-12-01002.990
5b32017-12-19 -> 2017-12-30004.270
6b32017-12-21 -> 2017-12-22005.010
7b72017-12-29 -> 2017-12-30006.820
1b12017-12-01 -> 2017-12-02006.790
1b12017-12-01 -> 2017-12-23008.650
12b82017-12-16 -> 2017-12-17008.910
17b92017-12-18 -> 2017-12-3109.7200
18b92017-12-01 -> 2017-12-01010.5200
19b102017-12-01 -> 2017-12-030011.260
20b102017-12-08 -> 2017-12-31011.3600
21b112017-12-24 -> 2017-12-270012.930
22b112017-12-07 -> 2017-12-090013.610
23b22017-12-01 -> 2017-12-040013.990
24b22017-12-22 -> 2017-12-220014.410
25b132017-12-17 -> 2017-12-210015.490
26b132017-12-13 -> 2017-12-260015.580
27b142017-12-01 -> 2017-12-300015.590
28b142017-12-01 -> 2017-12-140015.670
29b32017-12-30 -> 2017-12-3116.13000
30b32017-12-01 -> 2017-12-070016.090
31b162017-12-07 -> 2017-12-07019.0700
32b162017-12-01 -> 2017-12-030019.670
33b172017-12-04 -> 2017-12-26020.9800
34b172017-12-06 -> 2017-12-1021.42000
35b42017-12-02 -> 2017-12-0508.6713.430
36b42017-12-20 -> 2017-12-230022.660
37b192017-12-12 -> 2017-12-190022.590
38b192017-12-21 -> 2017-12-300021.551.88
39b202017-12-28 -> 2017-12-3023.49000
40b202017-12-05 -> 2017-12-120023.310
41b212017-12-28 -> 2017-12-310024.070
42b212017-12-07 -> 2017-12-160021.283.12
43b222017-12-01 -> 2017-12-020024.790
44b62017-12-21 -> 2017-12-31025.0700
45b72017-12-01 -> 2017-12-050024.830
46b232017-12-07 -> 2017-12-2200620.040
47b242017-12-04 -> 2017-12-05024.8200
48b242017-12-15 -> 2017-12-190025.520
49b252017-12-12 -> 2017-12-170025.580
50b252017-12-01 -> 2017-12-030025.930
51b262017-12-08 -> 2017-12-110026.130
52b262017-12-13 -> 2017-12-170026.450
53b272017-12-06 -> 2017-12-130026.40
54b272017-12-16 -> 2017-12-160026.820
55b282017-12-01 -> 2017-12-040026.780
56b282017-12-11 -> 2017-12-13027.8900
57b292017-12-21 -> 2017-12-260028.960
58b292017-12-01 -> 2017-12-300027.321.88
59b302017-12-10 -> 2017-12-120029.770
60b302017-12-03 -> 2017-12-090030.210
61b312017-12-07 -> 2017-12-23455.26000
62b312017-12-01 -> 2017-12-170031.020
63b322017-12-21 -> 2017-12-280032.490
64b322017-12-01 -> 2017-12-0532.9000
65b332017-12-01 -> 2017-12-030033.080
66b332017-12-07 -> 2017-12-190034.120
67b342017-12-04 -> 2017-12-300035.220
68b342017-12-01 -> 2017-12-03035.300
69b352017-12-01 -> 2017-12-150036.970
70b352017-12-12 -> 2017-12-180037.680
71b362017-12-08 -> 2017-12-120038.290
72b362017-12-16 -> 2017-12-19039.700
73b372017-12-21 -> 2017-12-300041.70
74b372017-12-01 -> 2017-12-300041.510
75b382017-12-01 -> 2017-12-090046.480
76b382017-12-27 -> 2017-12-290047.580
77b392017-12-04 -> 2017-12-280034.9213.16
78b392017-12-01 -> 2017-12-2002.5325.4120.86
79b402017-12-01 -> 2017-12-040050.250
80b402017-12-13 -> 2017-12-160050.560
81b412017-12-01 -> 2017-12-040051.460
82b412017-12-15 -> 2017-12-180053.820
83b422017-12-07 -> 2017-12-180053.750
84b422017-12-01 -> 2017-12-2303.5150.670
85b432017-12-05 -> 2017-12-200048.355.91
86b432017-12-20 -> 2017-12-300054.790
87b442017-12-01 -> 2017-12-050054.660
88b442017-12-01 -> 2017-12-090055.910
89b452017-12-07 -> 2017-12-080056.030
90b452017-12-01 -> 2017-12-070056.240
91b462017-12-05 -> 2017-12-100056.671.55
92b462017-12-20 -> 2017-12-2658.95000
93b472017-12-01 -> 2017-12-20058.8800
94b472017-12-01 -> 2017-12-080059.190
95b482017-12-28 -> 2017-12-310060.60
96b482017-12-01 -> 2017-12-070060.390
97b492017-12-01 -> 2017-12-150061.130
98b492017-12-04 -> 2017-12-300062.870
99b502017-12-04 -> 2017-12-060065.060
100b502017-12-06 -> 2017-12-280065.520
101b512017-12-01 -> 2017-12-150065.510
102b512017-12-15 -> 2017-12-270066.780
103b522017-12-01 -> 2017-12-180069.390
104b522017-12-10 -> 2017-12-260070.560
105b532017-12-01 -> 2017-12-120021.3549.68
106b532017-12-01 -> 2017-12-090071.140
107b542017-12-01 -> 2017-12-300072.490
108b542017-12-01 -> 2017-12-300073.270
109b552017-12-01 -> 2017-12-300073.530
110b552017-12-01 -> 2017-12-220075.240
111b562017-12-27 -> 2017-12-300075.770
112b562017-12-03 -> 2017-12-150075.20
113b572017-12-01 -> 2017-12-030077.820
114b572017-12-01 -> 2017-12-070078.270
115b582017-12-01 -> 2017-12-19078.500
116b582017-12-01 -> 2017-12-190079.010
117b592017-12-12 -> 2017-12-160079.330
118b592017-12-26 -> 2017-12-300080.540
119b602017-12-01 -> 2017-12-250081.060
120b602017-12-21 -> 2017-12-300083.370
121b612017-12-11 -> 2017-12-31084.8100.31
122b612017-12-29 -> 2017-12-300086.130
123b622017-12-04 -> 2017-12-170086.50
124b622017-12-01 -> 2017-12-28087.700
125b632017-12-01 -> 2017-12-31087.9300
126b632017-12-01 -> 2017-12-050089.580
127b642017-12-05 -> 2017-12-300091.980
128b642017-12-22 -> 2017-12-300097.140
129b652017-12-01 -> 2017-12-100098.350
130b652017-12-01 -> 2017-12-050098.780
131b662017-12-21 -> 2017-12-3100101.050
132b662017-12-14 -> 2017-12-16000204.03
133b672017-12-04 -> 2017-12-130096.245.28
134b672017-12-28 -> 2017-12-3174.84029.570
135b682017-12-07 -> 2017-12-200060.5344.7
136b682017-12-01 -> 2017-12-2700107.930
137b692017-12-01 -> 2017-12-2500110.990
138b692017-12-26 -> 2017-12-3000112.180
139b702017-12-09 -> 2017-12-1900113.50
140b702017-12-01 -> 2017-12-3000116.890
141b712017-12-07 -> 2017-12-31024.8391.921.87
142b712017-12-01 -> 2017-12-1600119.310
143b722017-12-11 -> 2017-12-3000120.410
144b722017-12-01 -> 2017-12-1100121.480
145b732017-12-01 -> 2017-12-3001.83121.440
146b732017-12-11 -> 2017-12-280100.61028.38
147b742017-12-01 -> 2017-12-31046.5683.410
148b742017-12-20 -> 2017-12-3000132.120
149b752017-12-01 -> 2017-12-2300132.280
150b752017-12-08 -> 2017-12-3005.41121.310.29
151b762017-12-01 -> 2017-12-1700137.460
152b762017-12-20 -> 2017-12-3000139.820
153b772017-12-01 -> 2017-12-0900138.770
154b772017-12-30 -> 2017-12-31070.5772.230
155b782017-12-01 -> 2017-12-1200143.870
156b782017-12-05 -> 2017-12-2400145.860
157b792017-12-12 -> 2017-12-3000146.530.31
158b792017-12-01 -> 2017-12-1100146.980
159b802017-12-17 -> 2017-12-3000156.590
160b802017-12-02 -> 2017-12-30049.72107.230
161b812017-12-01 -> 2017-12-2500160.80.31
162b812017-12-01 -> 2017-12-3000161.510
163b822017-12-02 -> 2017-12-1304.84157.720
164b822017-12-29 -> 2017-12-3008.29156.160
165b832017-12-01 -> 2017-12-1900164.60
166b832017-12-15 -> 2017-12-2900167.461.87
167b842017-12-01 -> 2017-12-3000169.980
168b842017-12-21 -> 2017-12-2900172.240
169b852017-12-01 -> 2017-12-11170.76000
170b852017-12-01 -> 2017-12-21139.34038.460
171b862017-12-01 -> 2017-12-2500177.510
172b862017-12-10 -> 2017-12-1900179.610
173b872017-12-19 -> 2017-12-3103.5178.50
174b872017-12-27 -> 2017-12-30097.2590.620
175b882017-12-01 -> 2017-12-3100187.10
176b882017-12-01 -> 2017-12-310192.9600
177b892017-12-01 -> 2017-12-3100179.8913.08
178b892017-12-04 -> 2017-12-070192.4500
179b902017-12-01 -> 2017-12-1500192.590
180b902017-12-01 -> 2017-12-2900200.830
181b912017-12-01 -> 2017-12-2700210.430
182b912017-12-13 -> 2017-12-3000212.940
183b922017-12-15 -> 2017-12-2500214.480
184b922017-12-01 -> 2017-12-080065.89152.68
185b932017-12-18 -> 2017-12-3000231.980
186b932017-12-06 -> 2017-12-2989.710142.310
187b942017-12-11 -> 2017-12-2900236.690
188b942017-12-01 -> 2017-12-1100238.180
189b952017-12-15 -> 2017-12-2700243.220
190b952017-12-01 -> 2017-12-3000243.020
191b962017-12-01 -> 2017-12-3100245.750
192b962017-12-01 -> 2017-12-18246.13000
193b972017-12-12 -> 2017-12-3000248.850
194b972017-12-01 -> 2017-12-070252.2100
195b982017-12-16 -> 2017-12-3000264.760
196b982017-12-01 -> 2017-12-2300266.30
197b992017-12-01 -> 2017-12-2900269.460
198b992017-12-01 -> 2017-12-1800270.020
199b1002017-12-01 -> 2017-12-30095.01177.660
200b1002017-12-15 -> 2017-12-2100271.291.88
201b1012017-12-01 -> 2017-12-2000277.780
202b1012017-12-01 -> 2017-12-2200279.470
203b1022017-12-20 -> 2017-12-2500075.18
204b1022017-12-01 -> 2017-12-300127.97153.830
205b1032017-12-01 -> 2017-12-1100282.80
206b1032017-12-06 -> 2017-12-2300285.460
207b1042017-12-10 -> 2017-12-3000291.490
208b1042017-12-21 -> 2017-12-2700285.279.19
209b1052017-12-13 -> 2017-12-3000302.520
210b1052017-12-01 -> 2017-12-1700305.730
211b1062017-12-23 -> 2017-12-300052.3914.76
212b1062017-12-23 -> 2017-12-2701.75310.110
213b1072017-12-18 -> 2017-12-2700311.40
214b1072017-12-18 -> 2017-12-2700311.320
215b1082017-12-22 -> 2017-12-280065.130
216b1082017-12-11 -> 2017-12-2700310.360
217b1092017-12-05 -> 2017-12-2700064.13
218b1092017-12-13 -> 2017-12-2700310.330
219b1102017-12-22 -> 2017-12-290062.340
220b1102017-12-07 -> 2017-12-2700310.010
221b1102017-12-12 -> 2017-12-2508.27301.720
222b1102017-12-19 -> 2017-12-2900312.990
223b1102017-12-13 -> 2017-12-3000312.480
224b1102017-12-07 -> 2017-12-19010.44300.810
225b1102017-12-11 -> 2017-12-2900312.250
226b1102017-12-01 -> 2017-12-2200290.7528.19
227b1102017-12-05 -> 2017-12-2800057.98
228b1102017-12-01 -> 2017-12-3000328.670
229b1102017-12-01 -> 2017-12-2900331.340.31
230b1152017-12-01 -> 2017-12-13330.83000
231b1162017-12-01 -> 2017-12-1700334.370
232b1162017-12-05 -> 2017-12-3000339.490
233b1172017-12-01 -> 2017-12-2100341.890
234b1172017-12-01 -> 2017-12-31342.5000
235b1182017-12-01 -> 2017-12-1500349.60
236b1182017-12-01 -> 2017-12-2600350.660
237b1192017-12-01 -> 2017-12-1800355.260
238b1192017-12-22 -> 2017-12-290051.190
239b1202017-12-01 -> 2017-12-3100359.320
240b1202017-12-01 -> 2017-12-3100360.110.31
241b1212017-12-01 -> 2017-12-23362.68000
242b1212017-12-01 -> 2017-12-110373.2100
243b1222017-12-06 -> 2017-12-170379.2800
244b1222017-12-07 -> 2017-12-090047.310
245b1232017-12-15 -> 2017-12-2700384.190
246b1232017-12-01 -> 2017-12-310383.2700
247b1242017-12-01 -> 2017-12-310216169.810
248b1242017-12-07 -> 2017-12-2900041.3
249b1252017-12-22 -> 2017-12-280039.740
250b1252017-12-01 -> 2017-12-160386.1100
251b1262017-12-22 -> 2017-12-270039.560
252b1262017-12-20 -> 2017-12-2600389.360
253b1272017-12-01 -> 2017-12-270172.79240.490
254b1272017-12-01 -> 2017-12-31302.8815.6499.260
255b1282017-12-22 -> 2017-12-290036.420
256b1282017-12-22 -> 2017-12-300035.990
257b1292017-12-01 -> 2017-12-270418.2400
258b1292017-12-22 -> 2017-12-3100422.780
259b1302017-12-01 -> 2017-12-2700420.820
260b1302017-12-01 -> 2017-12-140193.11115.78119.33
261b1312017-12-01 -> 2017-12-3000430.70
262b1312017-12-01 -> 2017-12-2900451.880
263b1322017-12-01 -> 2017-12-1600451.480
264b1322017-12-01 -> 2017-12-28088.88374.380
265b1332017-12-01 -> 2017-12-150462.4600
266b1332017-12-01 -> 2017-12-2500463.910
267b1342017-12-14 -> 2017-12-1900028.99
268b1342017-12-24 -> 2017-12-2700470.190
269b1352017-12-12 -> 2017-12-3100469.010
270b1352017-12-05 -> 2017-12-2996.05336.9334.970
271b1362017-12-06 -> 2017-12-2600026.8
272b1362017-12-05 -> 2017-12-2800468.290
273b1372017-12-07 -> 2017-12-27034.98433.830
274b1372017-12-09 -> 2017-12-31386.84096.270
275b1382017-12-01 -> 2017-12-3000485.570
276b1382017-12-19 -> 2017-12-3000026
277b1392017-12-01 -> 2017-12-2900511.510
278b1392017-12-01 -> 2017-12-300105.97408.640.99
279b1402017-12-14 -> 2017-12-280509.5233.470
280b1402017-12-01 -> 2017-12-3000539.139.69
281b1412017-12-01 -> 2017-12-290264.29367.120
282b1412017-12-16 -> 2017-12-3103.14685.760
283b1422017-12-15 -> 2017-12-2900699.810
284b1422017-12-01 -> 2017-12-31046.53694.210
285b1432017-12-05 -> 2017-12-3100743.390
286b1432017-12-01 -> 2017-12-3000743.580
287b1442017-12-01 -> 2017-12-230743.7900
288b1442017-12-01 -> 2017-12-240399.4369.640
289b1452017-12-01 -> 2017-12-2100023.31
290b1452017-12-01 -> 2017-12-3000780.930
291b1462017-12-01 -> 2017-12-3000787.070
292b1462017-12-19 -> 2017-12-270789.7600
293b1472017-12-05 -> 2017-12-2200791.070
294b1472017-12-28 -> 2017-12-2900815.290
295b1482017-12-22 -> 2017-12-300020.790
296b1482017-12-01 -> 2017-12-3000020.19
297b1492017-12-01 -> 2017-12-2600020.03
298b1492017-12-01 -> 2017-12-270768.4289.310
299b1502017-12-01 -> 2017-12-300772.85126.210
300b1502017-12-22 -> 2017-12-300018.580
301b1512017-12-09 -> 2017-12-2100018.33
302b1512017-12-29 -> 2017-12-300017.540
303b1522017-12-22 -> 2017-12-300016.280
304b1522017-12-01 -> 2017-12-3000912.630
305b1532017-12-12 -> 2017-12-27389.43264.39281.80
306b1532017-12-01 -> 2017-12-2900951.010
307b1542017-12-01 -> 2017-12-30001013.890
308b1542017-12-01 -> 2017-12-27001012.948.8
309b1552017-12-06 -> 2017-12-3000015.54
310b1552017-12-01 -> 2017-12-2800871.33164.55
311b1562017-12-01 -> 2017-12-230101.15881.6862.08
312b1562017-12-01 -> 2017-12-3100014.41
313b1572017-12-12 -> 2017-12-2801171.3800
314b1572017-12-26 -> 2017-12-290013.970
315b1582017-12-01 -> 2017-12-30001170.80
316b1582017-12-28 -> 2017-12-3000013.46
317b1592017-12-04 -> 2017-12-2100013.37
318b1592017-12-22 -> 2017-12-280013.170
319b1602017-12-09 -> 2017-12-1701168.2600
320b1602017-12-11 -> 2017-12-1200012.74
321b1612017-12-01 -> 2017-12-2800011.88
322b1612017-12-08 -> 2017-12-2700011.54
323b1622017-12-22 -> 2017-12-270011.410
324b1622017-12-01 -> 2017-12-27001131.6951.23
325b1632017-12-01 -> 2017-12-30001356.930
326b1632017-12-11 -> 2017-12-2800010.93
327b1642017-12-01 -> 2017-12-2501472.2900
328b1642017-12-14 -> 2017-12-1400010.26
329b1652017-12-01 -> 2017-12-23001506.30
330b1652017-12-29 -> 2017-12-300009.72
331b1662017-12-01 -> 2017-12-30001561.10
332b1662017-12-22 -> 2017-12-29008.860
333b1672017-12-02 -> 2017-12-240875.59686.30
334b1672017-12-28 -> 2017-12-28008.550
335b1682017-12-25 -> 2017-12-280008.15
336b1682017-12-02 -> 2017-12-110008.07
337b1692017-12-06 -> 2017-12-220007.78
338b1692017-12-12 -> 2017-12-300007.78
339b1702017-12-19 -> 2017-12-260007.51
340b1702017-12-18 -> 2017-12-280007.19
341b1712017-12-06 -> 2017-12-180006.89
342b1712017-12-19 -> 2017-12-31022.161566.320
343b1722017-12-01 -> 2017-12-2901268.35391.210
344b1722017-12-01 -> 2017-12-290006.54
345b1732017-12-27 -> 2017-12-270005.92
346b1732017-12-22 -> 2017-12-30005.840
347b1742017-12-22 -> 2017-12-23005.780
348b1742017-12-04 -> 2017-12-310005.61
349b1752017-12-23 -> 2017-12-240005.33
350b1752017-12-21 -> 2017-12-220005.32
351b1762017-12-12 -> 2017-12-210005.31
352b1762017-12-01 -> 2017-12-290625.61363.140
353b1772017-12-01 -> 2017-12-300005
354b1772017-12-01 -> 2017-12-310004.89
355b1782017-12-11 -> 2017-12-290004.67
356b1782017-12-04 -> 2017-12-210004.66
357b1792017-12-07 -> 2017-12-110004.35
358b1792017-12-07 -> 2017-12-140004.35
359b1802017-12-04 -> 2017-12-070004.35
360b1802017-12-01 -> 2017-12-030004.34
361b1812017-12-01 -> 2017-12-31002071.820
362b1812017-12-30 -> 2017-12-300004.08
363b1822017-12-22 -> 2017-12-270004.07
364b1822017-12-06 -> 2017-12-240004.06
365b1832017-12-05 -> 2017-12-280004.05
366b1832017-12-27 -> 2017-12-30003.890
367b1842017-12-22 -> 2017-12-270003.76
368b1842017-12-01 -> 2017-12-010003.72
369b1852017-12-07 -> 2017-12-310003.71
370b1852017-12-30 -> 2017-12-300003.45
371b1862017-12-22 -> 2017-12-270003.45
372b1862017-12-21 -> 2017-12-210003.45
373b1872017-12-13 -> 2017-12-290003.42
374b1872017-12-29 -> 2017-12-300003.13
375b1882017-12-19 -> 2017-12-190003.12
376b1882017-12-13 -> 2017-12-240003.12
377b1892017-12-14 -> 2017-12-260003.11
378b1892017-12-01 -> 2017-12-2602103.3900
379b1902017-12-21 -> 2017-12-30019.332349.750
380b1902017-12-01 -> 2017-12-310002.81
381b1912017-12-01 -> 2017-12-080002.8
382b1912017-12-07 -> 2017-12-110002.8
383b1922017-12-01 -> 2017-12-281285.1301557.050
384b1922017-12-20 -> 2017-12-250002.51
385b1932017-12-14 -> 2017-12-250002.5
386b1932017-12-08 -> 2017-12-200002.49
387b1942017-12-11 -> 2017-12-280002.49
388b1942017-12-01 -> 2017-12-300002.48
389b1952017-12-01 -> 2017-12-240298400
390b1952017-12-15 -> 2017-12-210002.18
391b1962017-12-13 -> 2017-12-230002.18
392b1962017-12-07 -> 2017-12-110002.17
393b1972017-12-13 -> 2017-12-130002.17
394b1972017-12-01 -> 2017-12-010002.17
395b1982017-12-04 -> 2017-12-280001.96
396b1982017-12-11 -> 2017-12-130001.96
397b1992017-12-22 -> 2017-12-28001.920
398b1992017-12-16 -> 2017-12-260001.88
399b2002017-12-20 -> 2017-12-200001.88
400b2002017-12-13 -> 2017-12-270001.87
401b2012017-12-13 -> 2017-12-190001.87
402b2012017-12-04 -> 2017-12-040001.86
403b2022017-12-19 -> 2017-12-300001.57
404b2022017-12-23 -> 2017-12-310001.57
405b2032017-12-23 -> 2017-12-290001.57
406b2032017-12-02 -> 2017-12-310001.56
407b2042017-12-15 -> 2017-12-150001.56
408b2042017-12-03 -> 2017-12-260001.56
409b2052017-12-11 -> 2017-12-220001.56
410b2052017-12-26 -> 2017-12-29003550.80
411b2062017-12-29 -> 2017-12-30001.370
412b2062017-12-27 -> 2017-12-280001.25
413b2072017-12-11 -> 2017-12-190001.24
414b2072017-12-04 -> 2017-12-300001.24
415b2082017-12-11 -> 2017-12-110001.24
416b2082017-12-13 -> 2017-12-130001.24
417b2092017-12-04 -> 2017-12-130001.24
418b2092017-12-04 -> 2017-12-312505.15385.44723.580
419b2102017-12-01 -> 2017-12-312235.2419.452263.120
420b2102017-12-01 -> 2017-12-180001
421b2112017-12-15 -> 2017-12-290000.99
422b2112017-12-06 -> 2017-12-280000.99
423b2122017-12-13 -> 2017-12-130000.98
424b2122017-12-23 -> 2017-12-260000.94
425b2132017-12-18 -> 2017-12-260000.94
426b2132017-12-28 -> 2017-12-300000.94
427b2142017-12-21 -> 2017-12-210000.94
428b2142017-12-28 -> 2017-12-280000.94
429b2152017-12-14 -> 2017-12-140000.93
430b2152017-12-06 -> 2017-12-080000.93
431b2162017-12-22 -> 2017-12-28000.830
432b2162017-12-01 -> 2017-12-030000.77
433b2172017-12-04 -> 2017-12-070000.77
434b2172017-12-22 -> 2017-12-28000.650
435b2182017-12-23 -> 2017-12-230000.63
436b2182017-12-23 -> 2017-12-270000.63
437b2192017-12-26 -> 2017-12-280000.63
438b2192017-12-21 -> 2017-12-210000.63
439b2202017-12-01 -> 2017-12-260000.62
440b2202017-12-12 -> 2017-12-180000.62
441b2212017-12-15 -> 2017-12-150000.62
442b2212017-12-04 -> 2017-12-190000.62
443b2222017-12-01 -> 2017-12-210000.62
444b2222017-12-04 -> 2017-12-040000.62
445b2232017-12-04 -> 2017-12-040000.62
446b2232017-12-01 -> 2017-12-126208.44000
447b2242017-12-01 -> 2017-12-31037.676815.380
448b2242017-12-30 -> 2017-12-300000.31
449b2252017-12-23 -> 2017-12-290000.31
450b2252017-12-29 -> 2017-12-290000.31
451b2262017-12-28 -> 2017-12-300000.31
452b2262017-12-05 -> 2017-12-300000.31
453b2272017-12-17 -> 2017-12-170000.31
454b2272017-12-19 -> 2017-12-190000.31
455b2282017-12-15 -> 2017-12-170000.31
456b2282017-12-14 -> 2017-12-140000.31
457b2292017-12-14 -> 2017-12-140000.31
458b2292017-12-05 -> 2017-12-090000.31
459b2302017-12-05 -> 2017-12-050000.31
460b2302017-12-11 -> 2017-12-110000.31
461b2312017-12-06 -> 2017-12-120000.31
462b2312017-12-14 -> 2017-12-140000.31
463b2322017-12-09 -> 2017-12-090000.31
464b2322017-12-13 -> 2017-12-130000.31
465b2332017-12-03 -> 2017-12-030000.31
466b2332017-12-22 -> 2017-12-28000.290
467b2342017-12-22 -> 2017-12-22000.280
468b2342017-12-19 -> 2017-12-28000.260
469b2352017-12-01 -> 2017-12-210249.4410169.30
470b2352017-12-28 -> 2017-12-28000.040
Spoiler
 

I want help with Microsoft excel average function. Please help me with following conditions in excel.
Data is attached below.

1What is the average total USD rev/parent?
2What is the average total USD rev/parent if you exclude parents which have revenue only in D product (i.e 0 rev in other products)
3What % of revenue comes from parents whose total revenue <100 USD, 100-200 USD, 200-500 USD, >500 USD
4How many parents have revenue >100 USD in date range of Dec 1 to Dec 10

 

Data 

All rev in USD     
Child IdParent Company IDDate RangeRev from Product ARev from Product BRev from Product CRev from Product D
1b12017-12-01 -> 2017-12-0100.1900
2b12017-12-18 -> 2017-12-18000.310
3b12017-12-07 -> 2017-12-07000.460
4b22017-12-24 -> 2017-12-25001.070
5b32017-12-06 -> 2017-12-20001.180
6b32017-12-24 -> 2017-12-29001.470
1b12017-12-01 -> 2017-12-01002.180
2b12017-12-01 -> 2017-12-01002.690
3b12017-12-26 -> 2017-12-30002.970
4b22017-12-01 -> 2017-12-01002.990
5b32017-12-19 -> 2017-12-30004.270
6b32017-12-21 -> 2017-12-22005.010
7b72017-12-29 -> 2017-12-30006.820
1b12017-12-01 -> 2017-12-02006.790
1b12017-12-01 -> 2017-12-23008.650
12b82017-12-16 -> 2017-12-17008.910
17b92017-12-18 -> 2017-12-3109.7200
18b92017-12-01 -> 2017-12-01010.5200
19b102017-12-01 -> 2017-12-030011.260
20b102017-12-08 -> 2017-12-31011.3600
21b112017-12-24 -> 2017-12-270012.930
22b112017-12-07 -> 2017-12-090013.610
23b22017-12-01 -> 2017-12-040013.990
24b22017-12-22 -> 2017-12-220014.410
25b132017-12-17 -> 2017-12-210015.490
26b132017-12-13 -> 2017-12-260015.580
27b142017-12-01 -> 2017-12-300015.590
28b142017-12-01 -> 2017-12-140015.670
29b32017-12-30 -> 2017-12-3116.13000
30b32017-12-01 -> 2017-12-070016.090
31b162017-12-07 -> 2017-12-07019.0700
32b162017-12-01 -> 2017-12-030019.670
33b172017-12-04 -> 2017-12-26020.9800
34b172017-12-06 -> 2017-12-1021.42000
35b42017-12-02 -> 2017-12-0508.6713.430
36b42017-12-20 -> 2017-12-230022.660
37b192017-12-12 -> 2017-12-190022.590
38b192017-12-21 -> 2017-12-300021.551.88
39b202017-12-28 -> 2017-12-3023.49000
40b202017-12-05 -> 2017-12-120023.310
41b212017-12-28 -> 2017-12-310024.070
42b212017-12-07 -> 2017-12-160021.283.12
43b222017-12-01 -> 2017-12-020024.790
44b62017-12-21 -> 2017-12-31025.0700
45b72017-12-01 -> 2017-12-050024.830
46b232017-12-07 -> 2017-12-2200620.040
47b242017-12-04 -> 2017-12-05024.8200
48b242017-12-15 -> 2017-12-190025.520
49b252017-12-12 -> 2017-12-170025.580
50b252017-12-01 -> 2017-12-030025.930
51b262017-12-08 -> 2017-12-110026.130
52b262017-12-13 -> 2017-12-170026.450
53b272017-12-06 -> 2017-12-130026.40
54b272017-12-16 -> 2017-12-160026.820
55b282017-12-01 -> 2017-12-040026.780
56b282017-12-11 -> 2017-12-13027.8900
57b292017-12-21 -> 2017-12-260028.960
58b292017-12-01 -> 2017-12-300027.321.88
59b302017-12-10 -> 2017-12-120029.770
60b302017-12-03 -> 2017-12-090030.210
61b312017-12-07 -> 2017-12-23455.26000
62b312017-12-01 -> 2017-12-170031.020
63b322017-12-21 -> 2017-12-280032.490
64b322017-12-01 -> 2017-12-0532.9000
65b332017-12-01 -> 2017-12-030033.080
66b332017-12-07 -> 2017-12-190034.120
67b342017-12-04 -> 2017-12-300035.220
68b342017-12-01 -> 2017-12-03035.300
69b352017-12-01 -> 2017-12-150036.970
70b352017-12-12 -> 2017-12-180037.680
71b362017-12-08 -> 2017-12-120038.290
72b362017-12-16 -> 2017-12-19039.700
73b372017-12-21 -> 2017-12-300041.70
74b372017-12-01 -> 2017-12-300041.510
75b382017-12-01 -> 2017-12-090046.480
76b382017-12-27 -> 2017-12-290047.580
77b392017-12-04 -> 2017-12-280034.9213.16
78b392017-12-01 -> 2017-12-2002.5325.4120.86
79b402017-12-01 -> 2017-12-040050.250
80b402017-12-13 -> 2017-12-160050.560
81b412017-12-01 -> 2017-12-040051.460
82b412017-12-15 -> 2017-12-180053.820
83b422017-12-07 -> 2017-12-180053.750
84b422017-12-01 -> 2017-12-2303.5150.670
85b432017-12-05 -> 2017-12-200048.355.91
86b432017-12-20 -> 2017-12-300054.790
87b442017-12-01 -> 2017-12-050054.660
88b442017-12-01 -> 2017-12-090055.910
89b452017-12-07 -> 2017-12-080056.030
90b452017-12-01 -> 2017-12-070056.240
91b462017-12-05 -> 2017-12-100056.671.55
92b462017-12-20 -> 2017-12-2658.95000
93b472017-12-01 -> 2017-12-20058.8800
94b472017-12-01 -> 2017-12-080059.190
95b482017-12-28 -> 2017-12-310060.60
96b482017-12-01 -> 2017-12-070060.390
97b492017-12-01 -> 2017-12-150061.130
98b492017-12-04 -> 2017-12-300062.870
99b502017-12-04 -> 2017-12-060065.060
100b502017-12-06 -> 2017-12-280065.520
101b512017-12-01 -> 2017-12-150065.510
102b512017-12-15 -> 2017-12-270066.780
103b522017-12-01 -> 2017-12-180069.390
104b522017-12-10 -> 2017-12-260070.560
105b532017-12-01 -> 2017-12-120021.3549.68
106b532017-12-01 -> 2017-12-090071.140
107b542017-12-01 -> 2017-12-300072.490
108b542017-12-01 -> 2017-12-300073.270
109b552017-12-01 -> 2017-12-300073.530
110b552017-12-01 -> 2017-12-220075.240
111b562017-12-27 -> 2017-12-300075.770
112b562017-12-03 -> 2017-12-150075.20
113b572017-12-01 -> 2017-12-030077.820
114b572017-12-01 -> 2017-12-070078.270
115b582017-12-01 -> 2017-12-19078.500
116b582017-12-01 -> 2017-12-190079.010
117b592017-12-12 -> 2017-12-160079.330
118b592017-12-26 -> 2017-12-300080.540
119b602017-12-01 -> 2017-12-250081.060
120b602017-12-21 -> 2017-12-300083.370
121b612017-12-11 -> 2017-12-31084.8100.31
122b612017-12-29 -> 2017-12-300086.130
123b622017-12-04 -> 2017-12-170086.50
124b622017-12-01 -> 2017-12-28087.700
125b632017-12-01 -> 2017-12-31087.9300
126b632017-12-01 -> 2017-12-050089.580
127b642017-12-05 -> 2017-12-300091.980
128b642017-12-22 -> 2017-12-300097.140
129b652017-12-01 -> 2017-12-100098.350
130b652017-12-01 -> 2017-12-050098.780
131b662017-12-21 -> 2017-12-3100101.050
132b662017-12-14 -> 2017-12-16000204.03
133b672017-12-04 -> 2017-12-130096.245.28
134b672017-12-28 -> 2017-12-3174.84029.570
135b682017-12-07 -> 2017-12-200060.5344.7
136b682017-12-01 -> 2017-12-2700107.930
137b692017-12-01 -> 2017-12-2500110.990
138b692017-12-26 -> 2017-12-3000112.180
139b702017-12-09 -> 2017-12-1900113.50
140b702017-12-01 -> 2017-12-3000116.890
141b712017-12-07 -> 2017-12-31024.8391.921.87
142b712017-12-01 -> 2017-12-1600119.310
143b722017-12-11 -> 2017-12-3000120.410
144b722017-12-01 -> 2017-12-1100121.480
145b732017-12-01 -> 2017-12-3001.83121.440
146b732017-12-11 -> 2017-12-280100.61028.38
147b742017-12-01 -> 2017-12-31046.5683.410
148b742017-12-20 -> 2017-12-3000132.120
149b752017-12-01 -> 2017-12-2300132.280
150b752017-12-08 -> 2017-12-3005.41121.310.29
151b762017-12-01 -> 2017-12-1700137.460
152b762017-12-20 -> 2017-12-3000139.820
153b772017-12-01 -> 2017-12-0900138.770
154b772017-12-30 -> 2017-12-31070.5772.230
155b782017-12-01 -> 2017-12-1200143.870
156b782017-12-05 -> 2017-12-2400145.860
157b792017-12-12 -> 2017-12-3000146.530.31
158b792017-12-01 -> 2017-12-1100146.980
159b802017-12-17 -> 2017-12-3000156.590
160b802017-12-02 -> 2017-12-30049.72107.230
161b812017-12-01 -> 2017-12-2500160.80.31
162b812017-12-01 -> 2017-12-3000161.510
163b822017-12-02 -> 2017-12-1304.84157.720
164b822017-12-29 -> 2017-12-3008.29156.160
165b832017-12-01 -> 2017-12-1900164.60
166b832017-12-15 -> 2017-12-2900167.461.87
167b842017-12-01 -> 2017-12-3000169.980
168b842017-12-21 -> 2017-12-2900172.240
169b852017-12-01 -> 2017-12-11170.76000
170b852017-12-01 -> 2017-12-21139.34038.460
171b862017-12-01 -> 2017-12-2500177.510
172b862017-12-10 -> 2017-12-1900179.610
173b872017-12-19 -> 2017-12-3103.5178.50
174b872017-12-27 -> 2017-12-30097.2590.620
175b882017-12-01 -> 2017-12-3100187.10
176b882017-12-01 -> 2017-12-310192.9600
177b892017-12-01 -> 2017-12-3100179.8913.08
178b892017-12-04 -> 2017-12-070192.4500
179b902017-12-01 -> 2017-12-1500192.590
180b902017-12-01 -> 2017-12-2900200.830
181b912017-12-01 -> 2017-12-2700210.430
182b912017-12-13 -> 2017-12-3000212.940
183b922017-12-15 -> 2017-12-2500214.480
184b922017-12-01 -> 2017-12-080065.89152.68
185b932017-12-18 -> 2017-12-3000231.980
186b932017-12-06 -> 2017-12-2989.710142.310
187b942017-12-11 -> 2017-12-2900236.690
188b942017-12-01 -> 2017-12-1100238.180
189b952017-12-15 -> 2017-12-2700243.220
190b952017-12-01 -> 2017-12-3000243.020
191b962017-12-01 -> 2017-12-3100245.750
192b962017-12-01 -> 2017-12-18246.13000
193b972017-12-12 -> 2017-12-3000248.850
194b972017-12-01 -> 2017-12-070252.2100
195b982017-12-16 -> 2017-12-3000264.760
196b982017-12-01 -> 2017-12-2300266.30
197b992017-12-01 -> 2017-12-2900269.460
198b992017-12-01 -> 2017-12-1800270.020
199b1002017-12-01 -> 2017-12-30095.01177.660
200b1002017-12-15 -> 2017-12-2100271.291.88
201b1012017-12-01 -> 2017-12-2000277.780
202b1012017-12-01 -> 2017-12-2200279.470
203b1022017-12-20 -> 2017-12-2500075.18
204b1022017-12-01 -> 2017-12-300127.97153.830
205b1032017-12-01 -> 2017-12-1100282.80
206b1032017-12-06 -> 2017-12-2300285.460
207b1042017-12-10 -> 2017-12-3000291.490
208b1042017-12-21 -> 2017-12-2700285.279.19
209b1052017-12-13 -> 2017-12-3000302.520
210b1052017-12-01 -> 2017-12-1700305.730
211b1062017-12-23 -> 2017-12-300052.3914.76
212b1062017-12-23 -> 2017-12-2701.75310.110
213b1072017-12-18 -> 2017-12-2700311.40
214b1072017-12-18 -> 2017-12-2700311.320
215b1082017-12-22 -> 2017-12-280065.130
216b1082017-12-11 -> 2017-12-2700310.360
217b1092017-12-05 -> 2017-12-2700064.13
218b1092017-12-13 -> 2017-12-2700310.330
219b1102017-12-22 -> 2017-12-290062.340
220b1102017-12-07 -> 2017-12-2700310.010
221b1102017-12-12 -> 2017-12-2508.27301.720
222b1102017-12-19 -> 2017-12-2900312.990
223b1102017-12-13 -> 2017-12-3000312.480
224b1102017-12-07 -> 2017-12-19010.44300.810
225b1102017-12-11 -> 2017-12-2900312.250
226b1102017-12-01 -> 2017-12-2200290.7528.19
227b1102017-12-05 -> 2017-12-2800057.98
228b1102017-12-01 -> 2017-12-3000328.670
229b1102017-12-01 -> 2017-12-2900331.340.31
230b1152017-12-01 -> 2017-12-13330.83000
231b1162017-12-01 -> 2017-12-1700334.370
232b1162017-12-05 -> 2017-12-3000339.490
233b1172017-12-01 -> 2017-12-2100341.890
234b1172017-12-01 -> 2017-12-31342.5000
235b1182017-12-01 -> 2017-12-1500349.60
236b1182017-12-01 -> 2017-12-2600350.660
237b1192017-12-01 -> 2017-12-1800355.260
238b1192017-12-22 -> 2017-12-290051.190
239b1202017-12-01 -> 2017-12-3100359.320
240b1202017-12-01 -> 2017-12-3100360.110.31
241b1212017-12-01 -> 2017-12-23362.68000
242b1212017-12-01 -> 2017-12-110373.2100
243b1222017-12-06 -> 2017-12-170379.2800
244b1222017-12-07 -> 2017-12-090047.310
245b1232017-12-15 -> 2017-12-2700384.190
246b1232017-12-01 -> 2017-12-310383.2700
247b1242017-12-01 -> 2017-12-310216169.810
248b1242017-12-07 -> 2017-12-2900041.3
249b1252017-12-22 -> 2017-12-280039.740
250b1252017-12-01 -> 2017-12-160386.1100
251b1262017-12-22 -> 2017-12-270039.560
252b1262017-12-20 -> 2017-12-2600389.360
253b1272017-12-01 -> 2017-12-270172.79240.490
254b1272017-12-01 -> 2017-12-31302.8815.6499.260
255b1282017-12-22 -> 2017-12-290036.420
256b1282017-12-22 -> 2017-12-300035.990
257b1292017-12-01 -> 2017-12-270418.2400
258b1292017-12-22 -> 2017-12-3100422.780
259b1302017-12-01 -> 2017-12-2700420.820
260b1302017-12-01 -> 2017-12-140193.11115.78119.33
261b1312017-12-01 -> 2017-12-3000430.70
262b1312017-12-01 -> 2017-12-2900451.880
263b1322017-12-01 -> 2017-12-1600451.480
264b1322017-12-01 -> 2017-12-28088.88374.380
265b1332017-12-01 -> 2017-12-150462.4600
266b1332017-12-01 -> 2017-12-2500463.910
267b1342017-12-14 -> 2017-12-1900028.99
268b1342017-12-24 -> 2017-12-2700470.190
269b1352017-12-12 -> 2017-12-3100469.010
270b1352017-12-05 -> 2017-12-2996.05336.9334.970
271b1362017-12-06 -> 2017-12-2600026.8
272b1362017-12-05 -> 2017-12-2800468.290
273b1372017-12-07 -> 2017-12-27034.98433.830
274b1372017-12-09 -> 2017-12-31386.84096.270
275b1382017-12-01 -> 2017-12-3000485.570
276b1382017-12-19 -> 2017-12-3000026
277b1392017-12-01 -> 2017-12-2900511.510
278b1392017-12-01 -> 2017-12-300105.97408.640.99
279b1402017-12-14 -> 2017-12-280509.5233.470
280b1402017-12-01 -> 2017-12-3000539.139.69
281b1412017-12-01 -> 2017-12-290264.29367.120
282b1412017-12-16 -> 2017-12-3103.14685.760
283b1422017-12-15 -> 2017-12-2900699.810
284b1422017-12-01 -> 2017-12-31046.53694.210
285b1432017-12-05 -> 2017-12-3100743.390
286b1432017-12-01 -> 2017-12-3000743.580
287b1442017-12-01 -> 2017-12-230743.7900
288b1442017-12-01 -> 2017-12-240399.4369.640
289b1452017-12-01 -> 2017-12-2100023.31
290b1452017-12-01 -> 2017-12-3000780.930
291b1462017-12-01 -> 2017-12-3000787.070
292b1462017-12-19 -> 2017-12-270789.7600
293b1472017-12-05 -> 2017-12-2200791.070
294b1472017-12-28 -> 2017-12-2900815.290
295b1482017-12-22 -> 2017-12-300020.790
296b1482017-12-01 -> 2017-12-3000020.19
297b1492017-12-01 -> 2017-12-2600020.03
298b1492017-12-01 -> 2017-12-270768.4289.310
299b1502017-12-01 -> 2017-12-300772.85126.210
300b1502017-12-22 -> 2017-12-300018.580
301b1512017-12-09 -> 2017-12-2100018.33
302b1512017-12-29 -> 2017-12-300017.540
303b1522017-12-22 -> 2017-12-300016.280
304b1522017-12-01 -> 2017-12-3000912.630
305b1532017-12-12 -> 2017-12-27389.43264.39281.80
306b1532017-12-01 -> 2017-12-2900951.010
307b1542017-12-01 -> 2017-12-30001013.890
308b1542017-12-01 -> 2017-12-27001012.948.8
309b1552017-12-06 -> 2017-12-3000015.54
310b1552017-12-01 -> 2017-12-2800871.33164.55
311b1562017-12-01 -> 2017-12-230101.15881.6862.08
312b1562017-12-01 -> 2017-12-3100014.41
313b1572017-12-12 -> 2017-12-2801171.3800
314b1572017-12-26 -> 2017-12-290013.970
315b1582017-12-01 -> 2017-12-30001170.80
316b1582017-12-28 -> 2017-12-3000013.46
317b1592017-12-04 -> 2017-12-2100013.37
318b1592017-12-22 -> 2017-12-280013.170
319b1602017-12-09 -> 2017-12-1701168.2600
320b1602017-12-11 -> 2017-12-1200012.74
321b1612017-12-01 -> 2017-12-2800011.88
322b1612017-12-08 -> 2017-12-2700011.54
323b1622017-12-22 -> 2017-12-270011.410
324b1622017-12-01 -> 2017-12-27001131.6951.23
325b1632017-12-01 -> 2017-12-30001356.930
326b1632017-12-11 -> 2017-12-2800010.93
327b1642017-12-01 -> 2017-12-2501472.2900
328b1642017-12-14 -> 2017-12-1400010.26
329b1652017-12-01 -> 2017-12-23001506.30
330b1652017-12-29 -> 2017-12-300009.72
331b1662017-12-01 -> 2017-12-30001561.10
332b1662017-12-22 -> 2017-12-29008.860
333b1672017-12-02 -> 2017-12-240875.59686.30
334b1672017-12-28 -> 2017-12-28008.550
335b1682017-12-25 -> 2017-12-280008.15
336b1682017-12-02 -> 2017-12-110008.07
337b1692017-12-06 -> 2017-12-220007.78
338b1692017-12-12 -> 2017-12-300007.78
339b1702017-12-19 -> 2017-12-260007.51
340b1702017-12-18 -> 2017-12-280007.19
341b1712017-12-06 -> 2017-12-180006.89
342b1712017-12-19 -> 2017-12-31022.161566.320
343b1722017-12-01 -> 2017-12-2901268.35391.210
344b1722017-12-01 -> 2017-12-290006.54
345b1732017-12-27 -> 2017-12-270005.92
346b1732017-12-22 -> 2017-12-30005.840
347b1742017-12-22 -> 2017-12-23005.780
348b1742017-12-04 -> 2017-12-310005.61
349b1752017-12-23 -> 2017-12-240005.33
350b1752017-12-21 -> 2017-12-220005.32
351b1762017-12-12 -> 2017-12-210005.31
352b1762017-12-01 -> 2017-12-290625.61363.140
353b1772017-12-01 -> 2017-12-300005
354b1772017-12-01 -> 2017-12-310004.89
355b1782017-12-11 -> 2017-12-290004.67
356b1782017-12-04 -> 2017-12-210004.66
357b1792017-12-07 -> 2017-12-110004.35
358b1792017-12-07 -> 2017-12-140004.35
359b1802017-12-04 -> 2017-12-070004.35
360b1802017-12-01 -> 2017-12-030004.34
361b1812017-12-01 -> 2017-12-31002071.820
362b1812017-12-30 -> 2017-12-300004.08
363b1822017-12-22 -> 2017-12-270004.07
364b1822017-12-06 -> 2017-12-240004.06
365b1832017-12-05 -> 2017-12-280004.05
366b1832017-12-27 -> 2017-12-30003.890
367b1842017-12-22 -> 2017-12-270003.76
368b1842017-12-01 -> 2017-12-010003.72
369b1852017-12-07 -> 2017-12-310003.71
370b1852017-12-30 -> 2017-12-300003.45
371b1862017-12-22 -> 2017-12-270003.45
372b1862017-12-21 -> 2017-12-210003.45
373b1872017-12-13 -> 2017-12-290003.42
374b1872017-12-29 -> 2017-12-300003.13
375b1882017-12-19 -> 2017-12-190003.12
376b1882017-12-13 -> 2017-12-240003.12
377b1892017-12-14 -> 2017-12-260003.11
378b1892017-12-01 -> 2017-12-2602103.3900
379b1902017-12-21 -> 2017-12-30019.332349.750
380b1902017-12-01 -> 2017-12-310002.81
381b1912017-12-01 -> 2017-12-080002.8
382b1912017-12-07 -> 2017-12-110002.8
383b1922017-12-01 -> 2017-12-281285.1301557.050
384b1922017-12-20 -> 2017-12-250002.51
385b1932017-12-14 -> 2017-12-250002.5
386b1932017-12-08 -> 2017-12-200002.49
387b1942017-12-11 -> 2017-12-280002.49
388b1942017-12-01 -> 2017-12-300002.48
389b1952017-12-01 -> 2017-12-240298400
390b1952017-12-15 -> 2017-12-210002.18
391b1962017-12-13 -> 2017-12-230002.18
392b1962017-12-07 -> 2017-12-110002.17
393b1972017-12-13 -> 2017-12-130002.17
394b1972017-12-01 -> 2017-12-010002.17
395b1982017-12-04 -> 2017-12-280001.96
396b1982017-12-11 -> 2017-12-130001.96
397b1992017-12-22 -> 2017-12-28001.920
398b1992017-12-16 -> 2017-12-260001.88
399b2002017-12-20 -> 2017-12-200001.88
400b2002017-12-13 -> 2017-12-270001.87
401b2012017-12-13 -> 2017-12-190001.87
402b2012017-12-04 -> 2017-12-040001.86
403b2022017-12-19 -> 2017-12-300001.57
404b2022017-12-23 -> 2017-12-310001.57
405b2032017-12-23 -> 2017-12-290001.57
406b2032017-12-02 -> 2017-12-310001.56
407b2042017-12-15 -> 2017-12-150001.56
408b2042017-12-03 -> 2017-12-260001.56
409b2052017-12-11 -> 2017-12-220001.56
410b2052017-12-26 -> 2017-12-29003550.80
411b2062017-12-29 -> 2017-12-30001.370
412b2062017-12-27 -> 2017-12-280001.25
413b2072017-12-11 -> 2017-12-190001.24
414b2072017-12-04 -> 2017-12-300001.24
415b2082017-12-11 -> 2017-12-110001.24
416b2082017-12-13 -> 2017-12-130001.24
417b2092017-12-04 -> 2017-12-130001.24
418b2092017-12-04 -> 2017-12-312505.15385.44723.580
419b2102017-12-01 -> 2017-12-312235.2419.452263.120
420b2102017-12-01 -> 2017-12-180001
421b2112017-12-15 -> 2017-12-290000.99
422b2112017-12-06 -> 2017-12-280000.99
423b2122017-12-13 -> 2017-12-130000.98
424b2122017-12-23 -> 2017-12-260000.94
425b2132017-12-18 -> 2017-12-260000.94
426b2132017-12-28 -> 2017-12-300000.94
427b2142017-12-21 -> 2017-12-210000.94
428b2142017-12-28 -> 2017-12-280000.94
429b2152017-12-14 -> 2017-12-140000.93
430b2152017-12-06 -> 2017-12-080000.93
431b2162017-12-22 -> 2017-12-28000.830
432b2162017-12-01 -> 2017-12-030000.77
433b2172017-12-04 -> 2017-12-070000.77
434b2172017-12-22 -> 2017-12-28000.650
435b2182017-12-23 -> 2017-12-230000.63
436b2182017-12-23 -> 2017-12-270000.63
437b2192017-12-26 -> 2017-12-280000.63
438b2192017-12-21 -> 2017-12-210000.63
439b2202017-12-01 -> 2017-12-260000.62
440b2202017-12-12 -> 2017-12-180000.62
441b2212017-12-15 -> 2017-12-150000.62
442b2212017-12-04 -> 2017-12-190000.62
443b2222017-12-01 -> 2017-12-210000.62
444b2222017-12-04 -> 2017-12-040000.62
445b2232017-12-04 -> 2017-12-040000.62
446b2232017-12-01 -> 2017-12-126208.44000
447b2242017-12-01 -> 2017-12-31037.676815.380
448b2242017-12-30 -> 2017-12-300000.31
449b2252017-12-23 -> 2017-12-290000.31
450b2252017-12-29 -> 2017-12-290000.31
451b2262017-12-28 -> 2017-12-300000.31
452b2262017-12-05 -> 2017-12-300000.31
453b2272017-12-17 -> 2017-12-170000.31
454b2272017-12-19 -> 2017-12-190000.31
455b2282017-12-15 -> 2017-12-170000.31
456b2282017-12-14 -> 2017-12-140000.31
457b2292017-12-14 -> 2017-12-140000.31
458b2292017-12-05 -> 2017-12-090000.31
459b2302017-12-05 -> 2017-12-050000.31
460b2302017-12-11 -> 2017-12-110000.31
461b2312017-12-06 -> 2017-12-120000.31
462b2312017-12-14 -> 2017-12-140000.31
463b2322017-12-09 -> 2017-12-090000.31
464b2322017-12-13 -> 2017-12-130000.31
465b2332017-12-03 -> 2017-12-030000.31
466b2332017-12-22 -> 2017-12-28000.290
467b2342017-12-22 -> 2017-12-22000.280
468b2342017-12-19 -> 2017-12-28000.260
469b2352017-12-01 -> 2017-12-210249.4410169.30
470b2352017-12-28 -> 2017-12-28000.040

1 Reply

Resources