Microsoft excel average function.

[deokars43]

Spoiler

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

1	What is the average total USD rev/parent?
2	What 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)
3	What % of revenue comes from parents whose total revenue <100 USD, 100-200 USD, 200-500 USD, >500 USD
4	How many parents have revenue >100 USD in date range of Dec 1 to Dec 10

Data 

All rev in USD
Child Id	Parent Company ID	Date Range	Rev from Product A	Rev from Product B	Rev from Product C	Rev from Product D
1	b1	2017-12-01 -> 2017-12-01	0	0.19	0	0
2	b1	2017-12-18 -> 2017-12-18	0	0	0.31	0
3	b1	2017-12-07 -> 2017-12-07	0	0	0.46	0
4	b2	2017-12-24 -> 2017-12-25	0	0	1.07	0
5	b3	2017-12-06 -> 2017-12-20	0	0	1.18	0
6	b3	2017-12-24 -> 2017-12-29	0	0	1.47	0
1	b1	2017-12-01 -> 2017-12-01	0	0	2.18	0
2	b1	2017-12-01 -> 2017-12-01	0	0	2.69	0
3	b1	2017-12-26 -> 2017-12-30	0	0	2.97	0
4	b2	2017-12-01 -> 2017-12-01	0	0	2.99	0
5	b3	2017-12-19 -> 2017-12-30	0	0	4.27	0
6	b3	2017-12-21 -> 2017-12-22	0	0	5.01	0
7	b7	2017-12-29 -> 2017-12-30	0	0	6.82	0
1	b1	2017-12-01 -> 2017-12-02	0	0	6.79	0
1	b1	2017-12-01 -> 2017-12-23	0	0	8.65	0
12	b8	2017-12-16 -> 2017-12-17	0	0	8.91	0
17	b9	2017-12-18 -> 2017-12-31	0	9.72	0	0
18	b9	2017-12-01 -> 2017-12-01	0	10.52	0	0
19	b10	2017-12-01 -> 2017-12-03	0	0	11.26	0
20	b10	2017-12-08 -> 2017-12-31	0	11.36	0	0
21	b11	2017-12-24 -> 2017-12-27	0	0	12.93	0
22	b11	2017-12-07 -> 2017-12-09	0	0	13.61	0
23	b2	2017-12-01 -> 2017-12-04	0	0	13.99	0
24	b2	2017-12-22 -> 2017-12-22	0	0	14.41	0
25	b13	2017-12-17 -> 2017-12-21	0	0	15.49	0
26	b13	2017-12-13 -> 2017-12-26	0	0	15.58	0
27	b14	2017-12-01 -> 2017-12-30	0	0	15.59	0
28	b14	2017-12-01 -> 2017-12-14	0	0	15.67	0
29	b3	2017-12-30 -> 2017-12-31	16.13	0	0	0
30	b3	2017-12-01 -> 2017-12-07	0	0	16.09	0
31	b16	2017-12-07 -> 2017-12-07	0	19.07	0	0
32	b16	2017-12-01 -> 2017-12-03	0	0	19.67	0
33	b17	2017-12-04 -> 2017-12-26	0	20.98	0	0
34	b17	2017-12-06 -> 2017-12-10	21.42	0	0	0
35	b4	2017-12-02 -> 2017-12-05	0	8.67	13.43	0
36	b4	2017-12-20 -> 2017-12-23	0	0	22.66	0
37	b19	2017-12-12 -> 2017-12-19	0	0	22.59	0
38	b19	2017-12-21 -> 2017-12-30	0	0	21.55	1.88
39	b20	2017-12-28 -> 2017-12-30	23.49	0	0	0
40	b20	2017-12-05 -> 2017-12-12	0	0	23.31	0
41	b21	2017-12-28 -> 2017-12-31	0	0	24.07	0
42	b21	2017-12-07 -> 2017-12-16	0	0	21.28	3.12
43	b22	2017-12-01 -> 2017-12-02	0	0	24.79	0
44	b6	2017-12-21 -> 2017-12-31	0	25.07	0	0
45	b7	2017-12-01 -> 2017-12-05	0	0	24.83	0
46	b23	2017-12-07 -> 2017-12-22	0	0	620.04	0
47	b24	2017-12-04 -> 2017-12-05	0	24.82	0	0
48	b24	2017-12-15 -> 2017-12-19	0	0	25.52	0
49	b25	2017-12-12 -> 2017-12-17	0	0	25.58	0
50	b25	2017-12-01 -> 2017-12-03	0	0	25.93	0
51	b26	2017-12-08 -> 2017-12-11	0	0	26.13	0
52	b26	2017-12-13 -> 2017-12-17	0	0	26.45	0
53	b27	2017-12-06 -> 2017-12-13	0	0	26.4	0
54	b27	2017-12-16 -> 2017-12-16	0	0	26.82	0
55	b28	2017-12-01 -> 2017-12-04	0	0	26.78	0
56	b28	2017-12-11 -> 2017-12-13	0	27.89	0	0
57	b29	2017-12-21 -> 2017-12-26	0	0	28.96	0
58	b29	2017-12-01 -> 2017-12-30	0	0	27.32	1.88
59	b30	2017-12-10 -> 2017-12-12	0	0	29.77	0
60	b30	2017-12-03 -> 2017-12-09	0	0	30.21	0
61	b31	2017-12-07 -> 2017-12-23	455.26	0	0	0
62	b31	2017-12-01 -> 2017-12-17	0	0	31.02	0
63	b32	2017-12-21 -> 2017-12-28	0	0	32.49	0
64	b32	2017-12-01 -> 2017-12-05	32.9	0	0	0
65	b33	2017-12-01 -> 2017-12-03	0	0	33.08	0
66	b33	2017-12-07 -> 2017-12-19	0	0	34.12	0
67	b34	2017-12-04 -> 2017-12-30	0	0	35.22	0
68	b34	2017-12-01 -> 2017-12-03	0	35.3	0	0
69	b35	2017-12-01 -> 2017-12-15	0	0	36.97	0
70	b35	2017-12-12 -> 2017-12-18	0	0	37.68	0
71	b36	2017-12-08 -> 2017-12-12	0	0	38.29	0
72	b36	2017-12-16 -> 2017-12-19	0	39.7	0	0
73	b37	2017-12-21 -> 2017-12-30	0	0	41.7	0
74	b37	2017-12-01 -> 2017-12-30	0	0	41.51	0
75	b38	2017-12-01 -> 2017-12-09	0	0	46.48	0
76	b38	2017-12-27 -> 2017-12-29	0	0	47.58	0
77	b39	2017-12-04 -> 2017-12-28	0	0	34.92	13.16
78	b39	2017-12-01 -> 2017-12-20	0	2.53	25.41	20.86
79	b40	2017-12-01 -> 2017-12-04	0	0	50.25	0
80	b40	2017-12-13 -> 2017-12-16	0	0	50.56	0
81	b41	2017-12-01 -> 2017-12-04	0	0	51.46	0
82	b41	2017-12-15 -> 2017-12-18	0	0	53.82	0
83	b42	2017-12-07 -> 2017-12-18	0	0	53.75	0
84	b42	2017-12-01 -> 2017-12-23	0	3.51	50.67	0
85	b43	2017-12-05 -> 2017-12-20	0	0	48.35	5.91
86	b43	2017-12-20 -> 2017-12-30	0	0	54.79	0
87	b44	2017-12-01 -> 2017-12-05	0	0	54.66	0
88	b44	2017-12-01 -> 2017-12-09	0	0	55.91	0
89	b45	2017-12-07 -> 2017-12-08	0	0	56.03	0
90	b45	2017-12-01 -> 2017-12-07	0	0	56.24	0
91	b46	2017-12-05 -> 2017-12-10	0	0	56.67	1.55
92	b46	2017-12-20 -> 2017-12-26	58.95	0	0	0
93	b47	2017-12-01 -> 2017-12-20	0	58.88	0	0
94	b47	2017-12-01 -> 2017-12-08	0	0	59.19	0
95	b48	2017-12-28 -> 2017-12-31	0	0	60.6	0
96	b48	2017-12-01 -> 2017-12-07	0	0	60.39	0
97	b49	2017-12-01 -> 2017-12-15	0	0	61.13	0
98	b49	2017-12-04 -> 2017-12-30	0	0	62.87	0
99	b50	2017-12-04 -> 2017-12-06	0	0	65.06	0
100	b50	2017-12-06 -> 2017-12-28	0	0	65.52	0
101	b51	2017-12-01 -> 2017-12-15	0	0	65.51	0
102	b51	2017-12-15 -> 2017-12-27	0	0	66.78	0
103	b52	2017-12-01 -> 2017-12-18	0	0	69.39	0
104	b52	2017-12-10 -> 2017-12-26	0	0	70.56	0
105	b53	2017-12-01 -> 2017-12-12	0	0	21.35	49.68
106	b53	2017-12-01 -> 2017-12-09	0	0	71.14	0
107	b54	2017-12-01 -> 2017-12-30	0	0	72.49	0
108	b54	2017-12-01 -> 2017-12-30	0	0	73.27	0
109	b55	2017-12-01 -> 2017-12-30	0	0	73.53	0
110	b55	2017-12-01 -> 2017-12-22	0	0	75.24	0
111	b56	2017-12-27 -> 2017-12-30	0	0	75.77	0
112	b56	2017-12-03 -> 2017-12-15	0	0	75.2	0
113	b57	2017-12-01 -> 2017-12-03	0	0	77.82	0
114	b57	2017-12-01 -> 2017-12-07	0	0	78.27	0
115	b58	2017-12-01 -> 2017-12-19	0	78.5	0	0
116	b58	2017-12-01 -> 2017-12-19	0	0	79.01	0
117	b59	2017-12-12 -> 2017-12-16	0	0	79.33	0
118	b59	2017-12-26 -> 2017-12-30	0	0	80.54	0
119	b60	2017-12-01 -> 2017-12-25	0	0	81.06	0
120	b60	2017-12-21 -> 2017-12-30	0	0	83.37	0
121	b61	2017-12-11 -> 2017-12-31	0	84.81	0	0.31
122	b61	2017-12-29 -> 2017-12-30	0	0	86.13	0
123	b62	2017-12-04 -> 2017-12-17	0	0	86.5	0
124	b62	2017-12-01 -> 2017-12-28	0	87.7	0	0
125	b63	2017-12-01 -> 2017-12-31	0	87.93	0	0
126	b63	2017-12-01 -> 2017-12-05	0	0	89.58	0
127	b64	2017-12-05 -> 2017-12-30	0	0	91.98	0
128	b64	2017-12-22 -> 2017-12-30	0	0	97.14	0
129	b65	2017-12-01 -> 2017-12-10	0	0	98.35	0
130	b65	2017-12-01 -> 2017-12-05	0	0	98.78	0
131	b66	2017-12-21 -> 2017-12-31	0	0	101.05	0
132	b66	2017-12-14 -> 2017-12-16	0	0	0	204.03
133	b67	2017-12-04 -> 2017-12-13	0	0	96.24	5.28
134	b67	2017-12-28 -> 2017-12-31	74.84	0	29.57	0
135	b68	2017-12-07 -> 2017-12-20	0	0	60.53	44.7
136	b68	2017-12-01 -> 2017-12-27	0	0	107.93	0
137	b69	2017-12-01 -> 2017-12-25	0	0	110.99	0
138	b69	2017-12-26 -> 2017-12-30	0	0	112.18	0
139	b70	2017-12-09 -> 2017-12-19	0	0	113.5	0
140	b70	2017-12-01 -> 2017-12-30	0	0	116.89	0
141	b71	2017-12-07 -> 2017-12-31	0	24.83	91.92	1.87
142	b71	2017-12-01 -> 2017-12-16	0	0	119.31	0
143	b72	2017-12-11 -> 2017-12-30	0	0	120.41	0
144	b72	2017-12-01 -> 2017-12-11	0	0	121.48	0
145	b73	2017-12-01 -> 2017-12-30	0	1.83	121.44	0
146	b73	2017-12-11 -> 2017-12-28	0	100.61	0	28.38
147	b74	2017-12-01 -> 2017-12-31	0	46.56	83.41	0
148	b74	2017-12-20 -> 2017-12-30	0	0	132.12	0
149	b75	2017-12-01 -> 2017-12-23	0	0	132.28	0
150	b75	2017-12-08 -> 2017-12-30	0	5.41	121.3	10.29
151	b76	2017-12-01 -> 2017-12-17	0	0	137.46	0
152	b76	2017-12-20 -> 2017-12-30	0	0	139.82	0
153	b77	2017-12-01 -> 2017-12-09	0	0	138.77	0
154	b77	2017-12-30 -> 2017-12-31	0	70.57	72.23	0
155	b78	2017-12-01 -> 2017-12-12	0	0	143.87	0
156	b78	2017-12-05 -> 2017-12-24	0	0	145.86	0
157	b79	2017-12-12 -> 2017-12-30	0	0	146.53	0.31
158	b79	2017-12-01 -> 2017-12-11	0	0	146.98	0
159	b80	2017-12-17 -> 2017-12-30	0	0	156.59	0
160	b80	2017-12-02 -> 2017-12-30	0	49.72	107.23	0
161	b81	2017-12-01 -> 2017-12-25	0	0	160.8	0.31
162	b81	2017-12-01 -> 2017-12-30	0	0	161.51	0
163	b82	2017-12-02 -> 2017-12-13	0	4.84	157.72	0
164	b82	2017-12-29 -> 2017-12-30	0	8.29	156.16	0
165	b83	2017-12-01 -> 2017-12-19	0	0	164.6	0
166	b83	2017-12-15 -> 2017-12-29	0	0	167.46	1.87
167	b84	2017-12-01 -> 2017-12-30	0	0	169.98	0
168	b84	2017-12-21 -> 2017-12-29	0	0	172.24	0
169	b85	2017-12-01 -> 2017-12-11	170.76	0	0	0
170	b85	2017-12-01 -> 2017-12-21	139.34	0	38.46	0
171	b86	2017-12-01 -> 2017-12-25	0	0	177.51	0
172	b86	2017-12-10 -> 2017-12-19	0	0	179.61	0
173	b87	2017-12-19 -> 2017-12-31	0	3.5	178.5	0
174	b87	2017-12-27 -> 2017-12-30	0	97.25	90.62	0
175	b88	2017-12-01 -> 2017-12-31	0	0	187.1	0
176	b88	2017-12-01 -> 2017-12-31	0	192.96	0	0
177	b89	2017-12-01 -> 2017-12-31	0	0	179.89	13.08
178	b89	2017-12-04 -> 2017-12-07	0	192.45	0	0
179	b90	2017-12-01 -> 2017-12-15	0	0	192.59	0
180	b90	2017-12-01 -> 2017-12-29	0	0	200.83	0
181	b91	2017-12-01 -> 2017-12-27	0	0	210.43	0
182	b91	2017-12-13 -> 2017-12-30	0	0	212.94	0
183	b92	2017-12-15 -> 2017-12-25	0	0	214.48	0
184	b92	2017-12-01 -> 2017-12-08	0	0	65.89	152.68
185	b93	2017-12-18 -> 2017-12-30	0	0	231.98	0
186	b93	2017-12-06 -> 2017-12-29	89.71	0	142.31	0
187	b94	2017-12-11 -> 2017-12-29	0	0	236.69	0
188	b94	2017-12-01 -> 2017-12-11	0	0	238.18	0
189	b95	2017-12-15 -> 2017-12-27	0	0	243.22	0
190	b95	2017-12-01 -> 2017-12-30	0	0	243.02	0
191	b96	2017-12-01 -> 2017-12-31	0	0	245.75	0
192	b96	2017-12-01 -> 2017-12-18	246.13	0	0	0
193	b97	2017-12-12 -> 2017-12-30	0	0	248.85	0
194	b97	2017-12-01 -> 2017-12-07	0	252.21	0	0
195	b98	2017-12-16 -> 2017-12-30	0	0	264.76	0
196	b98	2017-12-01 -> 2017-12-23	0	0	266.3	0
197	b99	2017-12-01 -> 2017-12-29	0	0	269.46	0
198	b99	2017-12-01 -> 2017-12-18	0	0	270.02	0
199	b100	2017-12-01 -> 2017-12-30	0	95.01	177.66	0
200	b100	2017-12-15 -> 2017-12-21	0	0	271.29	1.88
201	b101	2017-12-01 -> 2017-12-20	0	0	277.78	0
202	b101	2017-12-01 -> 2017-12-22	0	0	279.47	0
203	b102	2017-12-20 -> 2017-12-25	0	0	0	75.18
204	b102	2017-12-01 -> 2017-12-30	0	127.97	153.83	0
205	b103	2017-12-01 -> 2017-12-11	0	0	282.8	0
206	b103	2017-12-06 -> 2017-12-23	0	0	285.46	0
207	b104	2017-12-10 -> 2017-12-30	0	0	291.49	0
208	b104	2017-12-21 -> 2017-12-27	0	0	285.27	9.19
209	b105	2017-12-13 -> 2017-12-30	0	0	302.52	0
210	b105	2017-12-01 -> 2017-12-17	0	0	305.73	0
211	b106	2017-12-23 -> 2017-12-30	0	0	52.39	14.76
212	b106	2017-12-23 -> 2017-12-27	0	1.75	310.11	0
213	b107	2017-12-18 -> 2017-12-27	0	0	311.4	0
214	b107	2017-12-18 -> 2017-12-27	0	0	311.32	0
215	b108	2017-12-22 -> 2017-12-28	0	0	65.13	0
216	b108	2017-12-11 -> 2017-12-27	0	0	310.36	0
217	b109	2017-12-05 -> 2017-12-27	0	0	0	64.13
218	b109	2017-12-13 -> 2017-12-27	0	0	310.33	0
219	b110	2017-12-22 -> 2017-12-29	0	0	62.34	0
220	b110	2017-12-07 -> 2017-12-27	0	0	310.01	0
221	b110	2017-12-12 -> 2017-12-25	0	8.27	301.72	0
222	b110	2017-12-19 -> 2017-12-29	0	0	312.99	0
223	b110	2017-12-13 -> 2017-12-30	0	0	312.48	0
224	b110	2017-12-07 -> 2017-12-19	0	10.44	300.81	0
225	b110	2017-12-11 -> 2017-12-29	0	0	312.25	0
226	b110	2017-12-01 -> 2017-12-22	0	0	290.75	28.19
227	b110	2017-12-05 -> 2017-12-28	0	0	0	57.98
228	b110	2017-12-01 -> 2017-12-30	0	0	328.67	0
229	b110	2017-12-01 -> 2017-12-29	0	0	331.34	0.31
230	b115	2017-12-01 -> 2017-12-13	330.83	0	0	0
231	b116	2017-12-01 -> 2017-12-17	0	0	334.37	0
232	b116	2017-12-05 -> 2017-12-30	0	0	339.49	0
233	b117	2017-12-01 -> 2017-12-21	0	0	341.89	0
234	b117	2017-12-01 -> 2017-12-31	342.5	0	0	0
235	b118	2017-12-01 -> 2017-12-15	0	0	349.6	0
236	b118	2017-12-01 -> 2017-12-26	0	0	350.66	0
237	b119	2017-12-01 -> 2017-12-18	0	0	355.26	0
238	b119	2017-12-22 -> 2017-12-29	0	0	51.19	0
239	b120	2017-12-01 -> 2017-12-31	0	0	359.32	0
240	b120	2017-12-01 -> 2017-12-31	0	0	360.11	0.31
241	b121	2017-12-01 -> 2017-12-23	362.68	0	0	0
242	b121	2017-12-01 -> 2017-12-11	0	373.21	0	0
243	b122	2017-12-06 -> 2017-12-17	0	379.28	0	0
244	b122	2017-12-07 -> 2017-12-09	0	0	47.31	0
245	b123	2017-12-15 -> 2017-12-27	0	0	384.19	0
246	b123	2017-12-01 -> 2017-12-31	0	383.27	0	0
247	b124	2017-12-01 -> 2017-12-31	0	216	169.81	0
248	b124	2017-12-07 -> 2017-12-29	0	0	0	41.3
249	b125	2017-12-22 -> 2017-12-28	0	0	39.74	0
250	b125	2017-12-01 -> 2017-12-16	0	386.11	0	0
251	b126	2017-12-22 -> 2017-12-27	0	0	39.56	0
252	b126	2017-12-20 -> 2017-12-26	0	0	389.36	0
253	b127	2017-12-01 -> 2017-12-27	0	172.79	240.49	0
254	b127	2017-12-01 -> 2017-12-31	302.88	15.64	99.26	0
255	b128	2017-12-22 -> 2017-12-29	0	0	36.42	0
256	b128	2017-12-22 -> 2017-12-30	0	0	35.99	0
257	b129	2017-12-01 -> 2017-12-27	0	418.24	0	0
258	b129	2017-12-22 -> 2017-12-31	0	0	422.78	0
259	b130	2017-12-01 -> 2017-12-27	0	0	420.82	0
260	b130	2017-12-01 -> 2017-12-14	0	193.11	115.78	119.33
261	b131	2017-12-01 -> 2017-12-30	0	0	430.7	0
262	b131	2017-12-01 -> 2017-12-29	0	0	451.88	0
263	b132	2017-12-01 -> 2017-12-16	0	0	451.48	0
264	b132	2017-12-01 -> 2017-12-28	0	88.88	374.38	0
265	b133	2017-12-01 -> 2017-12-15	0	462.46	0	0
266	b133	2017-12-01 -> 2017-12-25	0	0	463.91	0
267	b134	2017-12-14 -> 2017-12-19	0	0	0	28.99
268	b134	2017-12-24 -> 2017-12-27	0	0	470.19	0
269	b135	2017-12-12 -> 2017-12-31	0	0	469.01	0
270	b135	2017-12-05 -> 2017-12-29	96.05	336.93	34.97	0
271	b136	2017-12-06 -> 2017-12-26	0	0	0	26.8
272	b136	2017-12-05 -> 2017-12-28	0	0	468.29	0
273	b137	2017-12-07 -> 2017-12-27	0	34.98	433.83	0
274	b137	2017-12-09 -> 2017-12-31	386.84	0	96.27	0
275	b138	2017-12-01 -> 2017-12-30	0	0	485.57	0
276	b138	2017-12-19 -> 2017-12-30	0	0	0	26
277	b139	2017-12-01 -> 2017-12-29	0	0	511.51	0
278	b139	2017-12-01 -> 2017-12-30	0	105.97	408.64	0.99
279	b140	2017-12-14 -> 2017-12-28	0	509.52	33.47	0
280	b140	2017-12-01 -> 2017-12-30	0	0	539.13	9.69
281	b141	2017-12-01 -> 2017-12-29	0	264.29	367.12	0
282	b141	2017-12-16 -> 2017-12-31	0	3.14	685.76	0
283	b142	2017-12-15 -> 2017-12-29	0	0	699.81	0
284	b142	2017-12-01 -> 2017-12-31	0	46.53	694.21	0
285	b143	2017-12-05 -> 2017-12-31	0	0	743.39	0
286	b143	2017-12-01 -> 2017-12-30	0	0	743.58	0
287	b144	2017-12-01 -> 2017-12-23	0	743.79	0	0
288	b144	2017-12-01 -> 2017-12-24	0	399.4	369.64	0
289	b145	2017-12-01 -> 2017-12-21	0	0	0	23.31
290	b145	2017-12-01 -> 2017-12-30	0	0	780.93	0
291	b146	2017-12-01 -> 2017-12-30	0	0	787.07	0
292	b146	2017-12-19 -> 2017-12-27	0	789.76	0	0
293	b147	2017-12-05 -> 2017-12-22	0	0	791.07	0
294	b147	2017-12-28 -> 2017-12-29	0	0	815.29	0
295	b148	2017-12-22 -> 2017-12-30	0	0	20.79	0
296	b148	2017-12-01 -> 2017-12-30	0	0	0	20.19
297	b149	2017-12-01 -> 2017-12-26	0	0	0	20.03
298	b149	2017-12-01 -> 2017-12-27	0	768.42	89.31	0
299	b150	2017-12-01 -> 2017-12-30	0	772.85	126.21	0
300	b150	2017-12-22 -> 2017-12-30	0	0	18.58	0
301	b151	2017-12-09 -> 2017-12-21	0	0	0	18.33
302	b151	2017-12-29 -> 2017-12-30	0	0	17.54	0
303	b152	2017-12-22 -> 2017-12-30	0	0	16.28	0
304	b152	2017-12-01 -> 2017-12-30	0	0	912.63	0
305	b153	2017-12-12 -> 2017-12-27	389.43	264.39	281.8	0
306	b153	2017-12-01 -> 2017-12-29	0	0	951.01	0
307	b154	2017-12-01 -> 2017-12-30	0	0	1013.89	0
308	b154	2017-12-01 -> 2017-12-27	0	0	1012.94	8.8
309	b155	2017-12-06 -> 2017-12-30	0	0	0	15.54
310	b155	2017-12-01 -> 2017-12-28	0	0	871.33	164.55
311	b156	2017-12-01 -> 2017-12-23	0	101.15	881.68	62.08
312	b156	2017-12-01 -> 2017-12-31	0	0	0	14.41
313	b157	2017-12-12 -> 2017-12-28	0	1171.38	0	0
314	b157	2017-12-26 -> 2017-12-29	0	0	13.97	0
315	b158	2017-12-01 -> 2017-12-30	0	0	1170.8	0
316	b158	2017-12-28 -> 2017-12-30	0	0	0	13.46
317	b159	2017-12-04 -> 2017-12-21	0	0	0	13.37
318	b159	2017-12-22 -> 2017-12-28	0	0	13.17	0
319	b160	2017-12-09 -> 2017-12-17	0	1168.26	0	0
320	b160	2017-12-11 -> 2017-12-12	0	0	0	12.74
321	b161	2017-12-01 -> 2017-12-28	0	0	0	11.88
322	b161	2017-12-08 -> 2017-12-27	0	0	0	11.54
323	b162	2017-12-22 -> 2017-12-27	0	0	11.41	0
324	b162	2017-12-01 -> 2017-12-27	0	0	1131.69	51.23
325	b163	2017-12-01 -> 2017-12-30	0	0	1356.93	0
326	b163	2017-12-11 -> 2017-12-28	0	0	0	10.93
327	b164	2017-12-01 -> 2017-12-25	0	1472.29	0	0
328	b164	2017-12-14 -> 2017-12-14	0	0	0	10.26
329	b165	2017-12-01 -> 2017-12-23	0	0	1506.3	0
330	b165	2017-12-29 -> 2017-12-30	0	0	0	9.72
331	b166	2017-12-01 -> 2017-12-30	0	0	1561.1	0
332	b166	2017-12-22 -> 2017-12-29	0	0	8.86	0
333	b167	2017-12-02 -> 2017-12-24	0	875.59	686.3	0
334	b167	2017-12-28 -> 2017-12-28	0	0	8.55	0
335	b168	2017-12-25 -> 2017-12-28	0	0	0	8.15
336	b168	2017-12-02 -> 2017-12-11	0	0	0	8.07
337	b169	2017-12-06 -> 2017-12-22	0	0	0	7.78
338	b169	2017-12-12 -> 2017-12-30	0	0	0	7.78
339	b170	2017-12-19 -> 2017-12-26	0	0	0	7.51
340	b170	2017-12-18 -> 2017-12-28	0	0	0	7.19
341	b171	2017-12-06 -> 2017-12-18	0	0	0	6.89
342	b171	2017-12-19 -> 2017-12-31	0	22.16	1566.32	0
343	b172	2017-12-01 -> 2017-12-29	0	1268.35	391.21	0
344	b172	2017-12-01 -> 2017-12-29	0	0	0	6.54
345	b173	2017-12-27 -> 2017-12-27	0	0	0	5.92
346	b173	2017-12-22 -> 2017-12-30	0	0	5.84	0
347	b174	2017-12-22 -> 2017-12-23	0	0	5.78	0
348	b174	2017-12-04 -> 2017-12-31	0	0	0	5.61
349	b175	2017-12-23 -> 2017-12-24	0	0	0	5.33
350	b175	2017-12-21 -> 2017-12-22	0	0	0	5.32
351	b176	2017-12-12 -> 2017-12-21	0	0	0	5.31
352	b176	2017-12-01 -> 2017-12-29	0	625.6	1363.14	0
353	b177	2017-12-01 -> 2017-12-30	0	0	0	5
354	b177	2017-12-01 -> 2017-12-31	0	0	0	4.89
355	b178	2017-12-11 -> 2017-12-29	0	0	0	4.67
356	b178	2017-12-04 -> 2017-12-21	0	0	0	4.66
357	b179	2017-12-07 -> 2017-12-11	0	0	0	4.35
358	b179	2017-12-07 -> 2017-12-14	0	0	0	4.35
359	b180	2017-12-04 -> 2017-12-07	0	0	0	4.35
360	b180	2017-12-01 -> 2017-12-03	0	0	0	4.34
361	b181	2017-12-01 -> 2017-12-31	0	0	2071.82	0
362	b181	2017-12-30 -> 2017-12-30	0	0	0	4.08
363	b182	2017-12-22 -> 2017-12-27	0	0	0	4.07
364	b182	2017-12-06 -> 2017-12-24	0	0	0	4.06
365	b183	2017-12-05 -> 2017-12-28	0	0	0	4.05
366	b183	2017-12-27 -> 2017-12-30	0	0	3.89	0
367	b184	2017-12-22 -> 2017-12-27	0	0	0	3.76
368	b184	2017-12-01 -> 2017-12-01	0	0	0	3.72
369	b185	2017-12-07 -> 2017-12-31	0	0	0	3.71
370	b185	2017-12-30 -> 2017-12-30	0	0	0	3.45
371	b186	2017-12-22 -> 2017-12-27	0	0	0	3.45
372	b186	2017-12-21 -> 2017-12-21	0	0	0	3.45
373	b187	2017-12-13 -> 2017-12-29	0	0	0	3.42
374	b187	2017-12-29 -> 2017-12-30	0	0	0	3.13
375	b188	2017-12-19 -> 2017-12-19	0	0	0	3.12
376	b188	2017-12-13 -> 2017-12-24	0	0	0	3.12
377	b189	2017-12-14 -> 2017-12-26	0	0	0	3.11
378	b189	2017-12-01 -> 2017-12-26	0	2103.39	0	0
379	b190	2017-12-21 -> 2017-12-30	0	19.33	2349.75	0
380	b190	2017-12-01 -> 2017-12-31	0	0	0	2.81
381	b191	2017-12-01 -> 2017-12-08	0	0	0	2.8
382	b191	2017-12-07 -> 2017-12-11	0	0	0	2.8
383	b192	2017-12-01 -> 2017-12-28	1285.13	0	1557.05	0
384	b192	2017-12-20 -> 2017-12-25	0	0	0	2.51
385	b193	2017-12-14 -> 2017-12-25	0	0	0	2.5
386	b193	2017-12-08 -> 2017-12-20	0	0	0	2.49
387	b194	2017-12-11 -> 2017-12-28	0	0	0	2.49
388	b194	2017-12-01 -> 2017-12-30	0	0	0	2.48
389	b195	2017-12-01 -> 2017-12-24	0	2984	0	0
390	b195	2017-12-15 -> 2017-12-21	0	0	0	2.18
391	b196	2017-12-13 -> 2017-12-23	0	0	0	2.18
392	b196	2017-12-07 -> 2017-12-11	0	0	0	2.17
393	b197	2017-12-13 -> 2017-12-13	0	0	0	2.17
394	b197	2017-12-01 -> 2017-12-01	0	0	0	2.17
395	b198	2017-12-04 -> 2017-12-28	0	0	0	1.96
396	b198	2017-12-11 -> 2017-12-13	0	0	0	1.96
397	b199	2017-12-22 -> 2017-12-28	0	0	1.92	0
398	b199	2017-12-16 -> 2017-12-26	0	0	0	1.88
399	b200	2017-12-20 -> 2017-12-20	0	0	0	1.88
400	b200	2017-12-13 -> 2017-12-27	0	0	0	1.87
401	b201	2017-12-13 -> 2017-12-19	0	0	0	1.87
402	b201	2017-12-04 -> 2017-12-04	0	0	0	1.86
403	b202	2017-12-19 -> 2017-12-30	0	0	0	1.57
404	b202	2017-12-23 -> 2017-12-31	0	0	0	1.57
405	b203	2017-12-23 -> 2017-12-29	0	0	0	1.57
406	b203	2017-12-02 -> 2017-12-31	0	0	0	1.56
407	b204	2017-12-15 -> 2017-12-15	0	0	0	1.56
408	b204	2017-12-03 -> 2017-12-26	0	0	0	1.56
409	b205	2017-12-11 -> 2017-12-22	0	0	0	1.56
410	b205	2017-12-26 -> 2017-12-29	0	0	3550.8	0
411	b206	2017-12-29 -> 2017-12-30	0	0	1.37	0
412	b206	2017-12-27 -> 2017-12-28	0	0	0	1.25
413	b207	2017-12-11 -> 2017-12-19	0	0	0	1.24
414	b207	2017-12-04 -> 2017-12-30	0	0	0	1.24
415	b208	2017-12-11 -> 2017-12-11	0	0	0	1.24
416	b208	2017-12-13 -> 2017-12-13	0	0	0	1.24
417	b209	2017-12-04 -> 2017-12-13	0	0	0	1.24
418	b209	2017-12-04 -> 2017-12-31	2505.15	385.44	723.58	0
419	b210	2017-12-01 -> 2017-12-31	2235.2	419.45	2263.12	0
420	b210	2017-12-01 -> 2017-12-18	0	0	0	1
421	b211	2017-12-15 -> 2017-12-29	0	0	0	0.99
422	b211	2017-12-06 -> 2017-12-28	0	0	0	0.99
423	b212	2017-12-13 -> 2017-12-13	0	0	0	0.98
424	b212	2017-12-23 -> 2017-12-26	0	0	0	0.94
425	b213	2017-12-18 -> 2017-12-26	0	0	0	0.94
426	b213	2017-12-28 -> 2017-12-30	0	0	0	0.94
427	b214	2017-12-21 -> 2017-12-21	0	0	0	0.94
428	b214	2017-12-28 -> 2017-12-28	0	0	0	0.94
429	b215	2017-12-14 -> 2017-12-14	0	0	0	0.93
430	b215	2017-12-06 -> 2017-12-08	0	0	0	0.93
431	b216	2017-12-22 -> 2017-12-28	0	0	0.83	0
432	b216	2017-12-01 -> 2017-12-03	0	0	0	0.77
433	b217	2017-12-04 -> 2017-12-07	0	0	0	0.77
434	b217	2017-12-22 -> 2017-12-28	0	0	0.65	0
435	b218	2017-12-23 -> 2017-12-23	0	0	0	0.63
436	b218	2017-12-23 -> 2017-12-27	0	0	0	0.63
437	b219	2017-12-26 -> 2017-12-28	0	0	0	0.63
438	b219	2017-12-21 -> 2017-12-21	0	0	0	0.63
439	b220	2017-12-01 -> 2017-12-26	0	0	0	0.62
440	b220	2017-12-12 -> 2017-12-18	0	0	0	0.62
441	b221	2017-12-15 -> 2017-12-15	0	0	0	0.62
442	b221	2017-12-04 -> 2017-12-19	0	0	0	0.62
443	b222	2017-12-01 -> 2017-12-21	0	0	0	0.62
444	b222	2017-12-04 -> 2017-12-04	0	0	0	0.62
445	b223	2017-12-04 -> 2017-12-04	0	0	0	0.62
446	b223	2017-12-01 -> 2017-12-12	6208.44	0	0	0
447	b224	2017-12-01 -> 2017-12-31	0	37.67	6815.38	0
448	b224	2017-12-30 -> 2017-12-30	0	0	0	0.31
449	b225	2017-12-23 -> 2017-12-29	0	0	0	0.31
450	b225	2017-12-29 -> 2017-12-29	0	0	0	0.31
451	b226	2017-12-28 -> 2017-12-30	0	0	0	0.31
452	b226	2017-12-05 -> 2017-12-30	0	0	0	0.31
453	b227	2017-12-17 -> 2017-12-17	0	0	0	0.31
454	b227	2017-12-19 -> 2017-12-19	0	0	0	0.31
455	b228	2017-12-15 -> 2017-12-17	0	0	0	0.31
456	b228	2017-12-14 -> 2017-12-14	0	0	0	0.31
457	b229	2017-12-14 -> 2017-12-14	0	0	0	0.31
458	b229	2017-12-05 -> 2017-12-09	0	0	0	0.31
459	b230	2017-12-05 -> 2017-12-05	0	0	0	0.31
460	b230	2017-12-11 -> 2017-12-11	0	0	0	0.31
461	b231	2017-12-06 -> 2017-12-12	0	0	0	0.31
462	b231	2017-12-14 -> 2017-12-14	0	0	0	0.31
463	b232	2017-12-09 -> 2017-12-09	0	0	0	0.31
464	b232	2017-12-13 -> 2017-12-13	0	0	0	0.31
465	b233	2017-12-03 -> 2017-12-03	0	0	0	0.31
466	b233	2017-12-22 -> 2017-12-28	0	0	0.29	0
467	b234	2017-12-22 -> 2017-12-22	0	0	0.28	0
468	b234	2017-12-19 -> 2017-12-28	0	0	0.26	0
469	b235	2017-12-01 -> 2017-12-21	0	249.44	10169.3	0
470	b235	2017-12-28 -> 2017-12-28	0	0	0.04	0 Spoiler I want help with Microsoft excel average function. Please help me with following conditions in excel. Data is attached below. 1 What is the average total USD rev/parent? 2 What 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) 3 What % of revenue comes from parents whose total revenue <100 USD, 100-200 USD, 200-500 USD, >500 USD 4 How many parents have revenue >100 USD in date range of Dec 1 to Dec 10 Data  All rev in USD           Child Id Parent Company ID Date Range Rev from Product A Rev from Product B Rev from Product C Rev from Product D 1 b1 2017-12-01 -> 2017-12-01 0 0.19 0 0 2 b1 2017-12-18 -> 2017-12-18 0 0 0.31 0 3 b1 2017-12-07 -> 2017-12-07 0 0 0.46 0 4 b2 2017-12-24 -> 2017-12-25 0 0 1.07 0 5 b3 2017-12-06 -> 2017-12-20 0 0 1.18 0 6 b3 2017-12-24 -> 2017-12-29 0 0 1.47 0 1 b1 2017-12-01 -> 2017-12-01 0 0 2.18 0 2 b1 2017-12-01 -> 2017-12-01 0 0 2.69 0 3 b1 2017-12-26 -> 2017-12-30 0 0 2.97 0 4 b2 2017-12-01 -> 2017-12-01 0 0 2.99 0 5 b3 2017-12-19 -> 2017-12-30 0 0 4.27 0 6 b3 2017-12-21 -> 2017-12-22 0 0 5.01 0 7 b7 2017-12-29 -> 2017-12-30 0 0 6.82 0 1 b1 2017-12-01 -> 2017-12-02 0 0 6.79 0 1 b1 2017-12-01 -> 2017-12-23 0 0 8.65 0 12 b8 2017-12-16 -> 2017-12-17 0 0 8.91 0 17 b9 2017-12-18 -> 2017-12-31 0 9.72 0 0 18 b9 2017-12-01 -> 2017-12-01 0 10.52 0 0 19 b10 2017-12-01 -> 2017-12-03 0 0 11.26 0 20 b10 2017-12-08 -> 2017-12-31 0 11.36 0 0 21 b11 2017-12-24 -> 2017-12-27 0 0 12.93 0 22 b11 2017-12-07 -> 2017-12-09 0 0 13.61 0 23 b2 2017-12-01 -> 2017-12-04 0 0 13.99 0 24 b2 2017-12-22 -> 2017-12-22 0 0 14.41 0 25 b13 2017-12-17 -> 2017-12-21 0 0 15.49 0 26 b13 2017-12-13 -> 2017-12-26 0 0 15.58 0 27 b14 2017-12-01 -> 2017-12-30 0 0 15.59 0 28 b14 2017-12-01 -> 2017-12-14 0 0 15.67 0 29 b3 2017-12-30 -> 2017-12-31 16.13 0 0 0 30 b3 2017-12-01 -> 2017-12-07 0 0 16.09 0 31 b16 2017-12-07 -> 2017-12-07 0 19.07 0 0 32 b16 2017-12-01 -> 2017-12-03 0 0 19.67 0 33 b17 2017-12-04 -> 2017-12-26 0 20.98 0 0 34 b17 2017-12-06 -> 2017-12-10 21.42 0 0 0 35 b4 2017-12-02 -> 2017-12-05 0 8.67 13.43 0 36 b4 2017-12-20 -> 2017-12-23 0 0 22.66 0 37 b19 2017-12-12 -> 2017-12-19 0 0 22.59 0 38 b19 2017-12-21 -> 2017-12-30 0 0 21.55 1.88 39 b20 2017-12-28 -> 2017-12-30 23.49 0 0 0 40 b20 2017-12-05 -> 2017-12-12 0 0 23.31 0 41 b21 2017-12-28 -> 2017-12-31 0 0 24.07 0 42 b21 2017-12-07 -> 2017-12-16 0 0 21.28 3.12 43 b22 2017-12-01 -> 2017-12-02 0 0 24.79 0 44 b6 2017-12-21 -> 2017-12-31 0 25.07 0 0 45 b7 2017-12-01 -> 2017-12-05 0 0 24.83 0 46 b23 2017-12-07 -> 2017-12-22 0 0 620.04 0 47 b24 2017-12-04 -> 2017-12-05 0 24.82 0 0 48 b24 2017-12-15 -> 2017-12-19 0 0 25.52 0 49 b25 2017-12-12 -> 2017-12-17 0 0 25.58 0 50 b25 2017-12-01 -> 2017-12-03 0 0 25.93 0 51 b26 2017-12-08 -> 2017-12-11 0 0 26.13 0 52 b26 2017-12-13 -> 2017-12-17 0 0 26.45 0 53 b27 2017-12-06 -> 2017-12-13 0 0 26.4 0 54 b27 2017-12-16 -> 2017-12-16 0 0 26.82 0 55 b28 2017-12-01 -> 2017-12-04 0 0 26.78 0 56 b28 2017-12-11 -> 2017-12-13 0 27.89 0 0 57 b29 2017-12-21 -> 2017-12-26 0 0 28.96 0 58 b29 2017-12-01 -> 2017-12-30 0 0 27.32 1.88 59 b30 2017-12-10 -> 2017-12-12 0 0 29.77 0 60 b30 2017-12-03 -> 2017-12-09 0 0 30.21 0 61 b31 2017-12-07 -> 2017-12-23 455.26 0 0 0 62 b31 2017-12-01 -> 2017-12-17 0 0 31.02 0 63 b32 2017-12-21 -> 2017-12-28 0 0 32.49 0 64 b32 2017-12-01 -> 2017-12-05 32.9 0 0 0 65 b33 2017-12-01 -> 2017-12-03 0 0 33.08 0 66 b33 2017-12-07 -> 2017-12-19 0 0 34.12 0 67 b34 2017-12-04 -> 2017-12-30 0 0 35.22 0 68 b34 2017-12-01 -> 2017-12-03 0 35.3 0 0 69 b35 2017-12-01 -> 2017-12-15 0 0 36.97 0 70 b35 2017-12-12 -> 2017-12-18 0 0 37.68 0 71 b36 2017-12-08 -> 2017-12-12 0 0 38.29 0 72 b36 2017-12-16 -> 2017-12-19 0 39.7 0 0 73 b37 2017-12-21 -> 2017-12-30 0 0 41.7 0 74 b37 2017-12-01 -> 2017-12-30 0 0 41.51 0 75 b38 2017-12-01 -> 2017-12-09 0 0 46.48 0 76 b38 2017-12-27 -> 2017-12-29 0 0 47.58 0 77 b39 2017-12-04 -> 2017-12-28 0 0 34.92 13.16 78 b39 2017-12-01 -> 2017-12-20 0 2.53 25.41 20.86 79 b40 2017-12-01 -> 2017-12-04 0 0 50.25 0 80 b40 2017-12-13 -> 2017-12-16 0 0 50.56 0 81 b41 2017-12-01 -> 2017-12-04 0 0 51.46 0 82 b41 2017-12-15 -> 2017-12-18 0 0 53.82 0 83 b42 2017-12-07 -> 2017-12-18 0 0 53.75 0 84 b42 2017-12-01 -> 2017-12-23 0 3.51 50.67 0 85 b43 2017-12-05 -> 2017-12-20 0 0 48.35 5.91 86 b43 2017-12-20 -> 2017-12-30 0 0 54.79 0 87 b44 2017-12-01 -> 2017-12-05 0 0 54.66 0 88 b44 2017-12-01 -> 2017-12-09 0 0 55.91 0 89 b45 2017-12-07 -> 2017-12-08 0 0 56.03 0 90 b45 2017-12-01 -> 2017-12-07 0 0 56.24 0 91 b46 2017-12-05 -> 2017-12-10 0 0 56.67 1.55 92 b46 2017-12-20 -> 2017-12-26 58.95 0 0 0 93 b47 2017-12-01 -> 2017-12-20 0 58.88 0 0 94 b47 2017-12-01 -> 2017-12-08 0 0 59.19 0 95 b48 2017-12-28 -> 2017-12-31 0 0 60.6 0 96 b48 2017-12-01 -> 2017-12-07 0 0 60.39 0 97 b49 2017-12-01 -> 2017-12-15 0 0 61.13 0 98 b49 2017-12-04 -> 2017-12-30 0 0 62.87 0 99 b50 2017-12-04 -> 2017-12-06 0 0 65.06 0 100 b50 2017-12-06 -> 2017-12-28 0 0 65.52 0 101 b51 2017-12-01 -> 2017-12-15 0 0 65.51 0 102 b51 2017-12-15 -> 2017-12-27 0 0 66.78 0 103 b52 2017-12-01 -> 2017-12-18 0 0 69.39 0 104 b52 2017-12-10 -> 2017-12-26 0 0 70.56 0 105 b53 2017-12-01 -> 2017-12-12 0 0 21.35 49.68 106 b53 2017-12-01 -> 2017-12-09 0 0 71.14 0 107 b54 2017-12-01 -> 2017-12-30 0 0 72.49 0 108 b54 2017-12-01 -> 2017-12-30 0 0 73.27 0 109 b55 2017-12-01 -> 2017-12-30 0 0 73.53 0 110 b55 2017-12-01 -> 2017-12-22 0 0 75.24 0 111 b56 2017-12-27 -> 2017-12-30 0 0 75.77 0 112 b56 2017-12-03 -> 2017-12-15 0 0 75.2 0 113 b57 2017-12-01 -> 2017-12-03 0 0 77.82 0 114 b57 2017-12-01 -> 2017-12-07 0 0 78.27 0 115 b58 2017-12-01 -> 2017-12-19 0 78.5 0 0 116 b58 2017-12-01 -> 2017-12-19 0 0 79.01 0 117 b59 2017-12-12 -> 2017-12-16 0 0 79.33 0 118 b59 2017-12-26 -> 2017-12-30 0 0 80.54 0 119 b60 2017-12-01 -> 2017-12-25 0 0 81.06 0 120 b60 2017-12-21 -> 2017-12-30 0 0 83.37 0 121 b61 2017-12-11 -> 2017-12-31 0 84.81 0 0.31 122 b61 2017-12-29 -> 2017-12-30 0 0 86.13 0 123 b62 2017-12-04 -> 2017-12-17 0 0 86.5 0 124 b62 2017-12-01 -> 2017-12-28 0 87.7 0 0 125 b63 2017-12-01 -> 2017-12-31 0 87.93 0 0 126 b63 2017-12-01 -> 2017-12-05 0 0 89.58 0 127 b64 2017-12-05 -> 2017-12-30 0 0 91.98 0 128 b64 2017-12-22 -> 2017-12-30 0 0 97.14 0 129 b65 2017-12-01 -> 2017-12-10 0 0 98.35 0 130 b65 2017-12-01 -> 2017-12-05 0 0 98.78 0 131 b66 2017-12-21 -> 2017-12-31 0 0 101.05 0 132 b66 2017-12-14 -> 2017-12-16 0 0 0 204.03 133 b67 2017-12-04 -> 2017-12-13 0 0 96.24 5.28 134 b67 2017-12-28 -> 2017-12-31 74.84 0 29.57 0 135 b68 2017-12-07 -> 2017-12-20 0 0 60.53 44.7 136 b68 2017-12-01 -> 2017-12-27 0 0 107.93 0 137 b69 2017-12-01 -> 2017-12-25 0 0 110.99 0 138 b69 2017-12-26 -> 2017-12-30 0 0 112.18 0 139 b70 2017-12-09 -> 2017-12-19 0 0 113.5 0 140 b70 2017-12-01 -> 2017-12-30 0 0 116.89 0 141 b71 2017-12-07 -> 2017-12-31 0 24.83 91.92 1.87 142 b71 2017-12-01 -> 2017-12-16 0 0 119.31 0 143 b72 2017-12-11 -> 2017-12-30 0 0 120.41 0 144 b72 2017-12-01 -> 2017-12-11 0 0 121.48 0 145 b73 2017-12-01 -> 2017-12-30 0 1.83 121.44 0 146 b73 2017-12-11 -> 2017-12-28 0 100.61 0 28.38 147 b74 2017-12-01 -> 2017-12-31 0 46.56 83.41 0 148 b74 2017-12-20 -> 2017-12-30 0 0 132.12 0 149 b75 2017-12-01 -> 2017-12-23 0 0 132.28 0 150 b75 2017-12-08 -> 2017-12-30 0 5.41 121.3 10.29 151 b76 2017-12-01 -> 2017-12-17 0 0 137.46 0 152 b76 2017-12-20 -> 2017-12-30 0 0 139.82 0 153 b77 2017-12-01 -> 2017-12-09 0 0 138.77 0 154 b77 2017-12-30 -> 2017-12-31 0 70.57 72.23 0 155 b78 2017-12-01 -> 2017-12-12 0 0 143.87 0 156 b78 2017-12-05 -> 2017-12-24 0 0 145.86 0 157 b79 2017-12-12 -> 2017-12-30 0 0 146.53 0.31 158 b79 2017-12-01 -> 2017-12-11 0 0 146.98 0 159 b80 2017-12-17 -> 2017-12-30 0 0 156.59 0 160 b80 2017-12-02 -> 2017-12-30 0 49.72 107.23 0 161 b81 2017-12-01 -> 2017-12-25 0 0 160.8 0.31 162 b81 2017-12-01 -> 2017-12-30 0 0 161.51 0 163 b82 2017-12-02 -> 2017-12-13 0 4.84 157.72 0 164 b82 2017-12-29 -> 2017-12-30 0 8.29 156.16 0 165 b83 2017-12-01 -> 2017-12-19 0 0 164.6 0 166 b83 2017-12-15 -> 2017-12-29 0 0 167.46 1.87 167 b84 2017-12-01 -> 2017-12-30 0 0 169.98 0 168 b84 2017-12-21 -> 2017-12-29 0 0 172.24 0 169 b85 2017-12-01 -> 2017-12-11 170.76 0 0 0 170 b85 2017-12-01 -> 2017-12-21 139.34 0 38.46 0 171 b86 2017-12-01 -> 2017-12-25 0 0 177.51 0 172 b86 2017-12-10 -> 2017-12-19 0 0 179.61 0 173 b87 2017-12-19 -> 2017-12-31 0 3.5 178.5 0 174 b87 2017-12-27 -> 2017-12-30 0 97.25 90.62 0 175 b88 2017-12-01 -> 2017-12-31 0 0 187.1 0 176 b88 2017-12-01 -> 2017-12-31 0 192.96 0 0 177 b89 2017-12-01 -> 2017-12-31 0 0 179.89 13.08 178 b89 2017-12-04 -> 2017-12-07 0 192.45 0 0 179 b90 2017-12-01 -> 2017-12-15 0 0 192.59 0 180 b90 2017-12-01 -> 2017-12-29 0 0 200.83 0 181 b91 2017-12-01 -> 2017-12-27 0 0 210.43 0 182 b91 2017-12-13 -> 2017-12-30 0 0 212.94 0 183 b92 2017-12-15 -> 2017-12-25 0 0 214.48 0 184 b92 2017-12-01 -> 2017-12-08 0 0 65.89 152.68 185 b93 2017-12-18 -> 2017-12-30 0 0 231.98 0 186 b93 2017-12-06 -> 2017-12-29 89.71 0 142.31 0 187 b94 2017-12-11 -> 2017-12-29 0 0 236.69 0 188 b94 2017-12-01 -> 2017-12-11 0 0 238.18 0 189 b95 2017-12-15 -> 2017-12-27 0 0 243.22 0 190 b95 2017-12-01 -> 2017-12-30 0 0 243.02 0 191 b96 2017-12-01 -> 2017-12-31 0 0 245.75 0 192 b96 2017-12-01 -> 2017-12-18 246.13 0 0 0 193 b97 2017-12-12 -> 2017-12-30 0 0 248.85 0 194 b97 2017-12-01 -> 2017-12-07 0 252.21 0 0 195 b98 2017-12-16 -> 2017-12-30 0 0 264.76 0 196 b98 2017-12-01 -> 2017-12-23 0 0 266.3 0 197 b99 2017-12-01 -> 2017-12-29 0 0 269.46 0 198 b99 2017-12-01 -> 2017-12-18 0 0 270.02 0 199 b100 2017-12-01 -> 2017-12-30 0 95.01 177.66 0 200 b100 2017-12-15 -> 2017-12-21 0 0 271.29 1.88 201 b101 2017-12-01 -> 2017-12-20 0 0 277.78 0 202 b101 2017-12-01 -> 2017-12-22 0 0 279.47 0 203 b102 2017-12-20 -> 2017-12-25 0 0 0 75.18 204 b102 2017-12-01 -> 2017-12-30 0 127.97 153.83 0 205 b103 2017-12-01 -> 2017-12-11 0 0 282.8 0 206 b103 2017-12-06 -> 2017-12-23 0 0 285.46 0 207 b104 2017-12-10 -> 2017-12-30 0 0 291.49 0 208 b104 2017-12-21 -> 2017-12-27 0 0 285.27 9.19 209 b105 2017-12-13 -> 2017-12-30 0 0 302.52 0 210 b105 2017-12-01 -> 2017-12-17 0 0 305.73 0 211 b106 2017-12-23 -> 2017-12-30 0 0 52.39 14.76 212 b106 2017-12-23 -> 2017-12-27 0 1.75 310.11 0 213 b107 2017-12-18 -> 2017-12-27 0 0 311.4 0 214 b107 2017-12-18 -> 2017-12-27 0 0 311.32 0 215 b108 2017-12-22 -> 2017-12-28 0 0 65.13 0 216 b108 2017-12-11 -> 2017-12-27 0 0 310.36 0 217 b109 2017-12-05 -> 2017-12-27 0 0 0 64.13 218 b109 2017-12-13 -> 2017-12-27 0 0 310.33 0 219 b110 2017-12-22 -> 2017-12-29 0 0 62.34 0 220 b110 2017-12-07 -> 2017-12-27 0 0 310.01 0 221 b110 2017-12-12 -> 2017-12-25 0 8.27 301.72 0 222 b110 2017-12-19 -> 2017-12-29 0 0 312.99 0 223 b110 2017-12-13 -> 2017-12-30 0 0 312.48 0 224 b110 2017-12-07 -> 2017-12-19 0 10.44 300.81 0 225 b110 2017-12-11 -> 2017-12-29 0 0 312.25 0 226 b110 2017-12-01 -> 2017-12-22 0 0 290.75 28.19 227 b110 2017-12-05 -> 2017-12-28 0 0 0 57.98 228 b110 2017-12-01 -> 2017-12-30 0 0 328.67 0 229 b110 2017-12-01 -> 2017-12-29 0 0 331.34 0.31 230 b115 2017-12-01 -> 2017-12-13 330.83 0 0 0 231 b116 2017-12-01 -> 2017-12-17 0 0 334.37 0 232 b116 2017-12-05 -> 2017-12-30 0 0 339.49 0 233 b117 2017-12-01 -> 2017-12-21 0 0 341.89 0 234 b117 2017-12-01 -> 2017-12-31 342.5 0 0 0 235 b118 2017-12-01 -> 2017-12-15 0 0 349.6 0 236 b118 2017-12-01 -> 2017-12-26 0 0 350.66 0 237 b119 2017-12-01 -> 2017-12-18 0 0 355.26 0 238 b119 2017-12-22 -> 2017-12-29 0 0 51.19 0 239 b120 2017-12-01 -> 2017-12-31 0 0 359.32 0 240 b120 2017-12-01 -> 2017-12-31 0 0 360.11 0.31 241 b121 2017-12-01 -> 2017-12-23 362.68 0 0 0 242 b121 2017-12-01 -> 2017-12-11 0 373.21 0 0 243 b122 2017-12-06 -> 2017-12-17 0 379.28 0 0 244 b122 2017-12-07 -> 2017-12-09 0 0 47.31 0 245 b123 2017-12-15 -> 2017-12-27 0 0 384.19 0 246 b123 2017-12-01 -> 2017-12-31 0 383.27 0 0 247 b124 2017-12-01 -> 2017-12-31 0 216 169.81 0 248 b124 2017-12-07 -> 2017-12-29 0 0 0 41.3 249 b125 2017-12-22 -> 2017-12-28 0 0 39.74 0 250 b125 2017-12-01 -> 2017-12-16 0 386.11 0 0 251 b126 2017-12-22 -> 2017-12-27 0 0 39.56 0 252 b126 2017-12-20 -> 2017-12-26 0 0 389.36 0 253 b127 2017-12-01 -> 2017-12-27 0 172.79 240.49 0 254 b127 2017-12-01 -> 2017-12-31 302.88 15.64 99.26 0 255 b128 2017-12-22 -> 2017-12-29 0 0 36.42 0 256 b128 2017-12-22 -> 2017-12-30 0 0 35.99 0 257 b129 2017-12-01 -> 2017-12-27 0 418.24 0 0 258 b129 2017-12-22 -> 2017-12-31 0 0 422.78 0 259 b130 2017-12-01 -> 2017-12-27 0 0 420.82 0 260 b130 2017-12-01 -> 2017-12-14 0 193.11 115.78 119.33 261 b131 2017-12-01 -> 2017-12-30 0 0 430.7 0 262 b131 2017-12-01 -> 2017-12-29 0 0 451.88 0 263 b132 2017-12-01 -> 2017-12-16 0 0 451.48 0 264 b132 2017-12-01 -> 2017-12-28 0 88.88 374.38 0 265 b133 2017-12-01 -> 2017-12-15 0 462.46 0 0 266 b133 2017-12-01 -> 2017-12-25 0 0 463.91 0 267 b134 2017-12-14 -> 2017-12-19 0 0 0 28.99 268 b134 2017-12-24 -> 2017-12-27 0 0 470.19 0 269 b135 2017-12-12 -> 2017-12-31 0 0 469.01 0 270 b135 2017-12-05 -> 2017-12-29 96.05 336.93 34.97 0 271 b136 2017-12-06 -> 2017-12-26 0 0 0 26.8 272 b136 2017-12-05 -> 2017-12-28 0 0 468.29 0 273 b137 2017-12-07 -> 2017-12-27 0 34.98 433.83 0 274 b137 2017-12-09 -> 2017-12-31 386.84 0 96.27 0 275 b138 2017-12-01 -> 2017-12-30 0 0 485.57 0 276 b138 2017-12-19 -> 2017-12-30 0 0 0 26 277 b139 2017-12-01 -> 2017-12-29 0 0 511.51 0 278 b139 2017-12-01 -> 2017-12-30 0 105.97 408.64 0.99 279 b140 2017-12-14 -> 2017-12-28 0 509.52 33.47 0 280 b140 2017-12-01 -> 2017-12-30 0 0 539.13 9.69 281 b141 2017-12-01 -> 2017-12-29 0 264.29 367.12 0 282 b141 2017-12-16 -> 2017-12-31 0 3.14 685.76 0 283 b142 2017-12-15 -> 2017-12-29 0 0 699.81 0 284 b142 2017-12-01 -> 2017-12-31 0 46.53 694.21 0 285 b143 2017-12-05 -> 2017-12-31 0 0 743.39 0 286 b143 2017-12-01 -> 2017-12-30 0 0 743.58 0 287 b144 2017-12-01 -> 2017-12-23 0 743.79 0 0 288 b144 2017-12-01 -> 2017-12-24 0 399.4 369.64 0 289 b145 2017-12-01 -> 2017-12-21 0 0 0 23.31 290 b145 2017-12-01 -> 2017-12-30 0 0 780.93 0 291 b146 2017-12-01 -> 2017-12-30 0 0 787.07 0 292 b146 2017-12-19 -> 2017-12-27 0 789.76 0 0 293 b147 2017-12-05 -> 2017-12-22 0 0 791.07 0 294 b147 2017-12-28 -> 2017-12-29 0 0 815.29 0 295 b148 2017-12-22 -> 2017-12-30 0 0 20.79 0 296 b148 2017-12-01 -> 2017-12-30 0 0 0 20.19 297 b149 2017-12-01 -> 2017-12-26 0 0 0 20.03 298 b149 2017-12-01 -> 2017-12-27 0 768.42 89.31 0 299 b150 2017-12-01 -> 2017-12-30 0 772.85 126.21 0 300 b150 2017-12-22 -> 2017-12-30 0 0 18.58 0 301 b151 2017-12-09 -> 2017-12-21 0 0 0 18.33 302 b151 2017-12-29 -> 2017-12-30 0 0 17.54 0 303 b152 2017-12-22 -> 2017-12-30 0 0 16.28 0 304 b152 2017-12-01 -> 2017-12-30 0 0 912.63 0 305 b153 2017-12-12 -> 2017-12-27 389.43 264.39 281.8 0 306 b153 2017-12-01 -> 2017-12-29 0 0 951.01 0 307 b154 2017-12-01 -> 2017-12-30 0 0 1013.89 0 308 b154 2017-12-01 -> 2017-12-27 0 0 1012.94 8.8 309 b155 2017-12-06 -> 2017-12-30 0 0 0 15.54 310 b155 2017-12-01 -> 2017-12-28 0 0 871.33 164.55 311 b156 2017-12-01 -> 2017-12-23 0 101.15 881.68 62.08 312 b156 2017-12-01 -> 2017-12-31 0 0 0 14.41 313 b157 2017-12-12 -> 2017-12-28 0 1171.38 0 0 314 b157 2017-12-26 -> 2017-12-29 0 0 13.97 0 315 b158 2017-12-01 -> 2017-12-30 0 0 1170.8 0 316 b158 2017-12-28 -> 2017-12-30 0 0 0 13.46 317 b159 2017-12-04 -> 2017-12-21 0 0 0 13.37 318 b159 2017-12-22 -> 2017-12-28 0 0 13.17 0 319 b160 2017-12-09 -> 2017-12-17 0 1168.26 0 0 320 b160 2017-12-11 -> 2017-12-12 0 0 0 12.74 321 b161 2017-12-01 -> 2017-12-28 0 0 0 11.88 322 b161 2017-12-08 -> 2017-12-27 0 0 0 11.54 323 b162 2017-12-22 -> 2017-12-27 0 0 11.41 0 324 b162 2017-12-01 -> 2017-12-27 0 0 1131.69 51.23 325 b163 2017-12-01 -> 2017-12-30 0 0 1356.93 0 326 b163 2017-12-11 -> 2017-12-28 0 0 0 10.93 327 b164 2017-12-01 -> 2017-12-25 0 1472.29 0 0 328 b164 2017-12-14 -> 2017-12-14 0 0 0 10.26 329 b165 2017-12-01 -> 2017-12-23 0 0 1506.3 0 330 b165 2017-12-29 -> 2017-12-30 0 0 0 9.72 331 b166 2017-12-01 -> 2017-12-30 0 0 1561.1 0 332 b166 2017-12-22 -> 2017-12-29 0 0 8.86 0 333 b167 2017-12-02 -> 2017-12-24 0 875.59 686.3 0 334 b167 2017-12-28 -> 2017-12-28 0 0 8.55 0 335 b168 2017-12-25 -> 2017-12-28 0 0 0 8.15 336 b168 2017-12-02 -> 2017-12-11 0 0 0 8.07 337 b169 2017-12-06 -> 2017-12-22 0 0 0 7.78 338 b169 2017-12-12 -> 2017-12-30 0 0 0 7.78 339 b170 2017-12-19 -> 2017-12-26 0 0 0 7.51 340 b170 2017-12-18 -> 2017-12-28 0 0 0 7.19 341 b171 2017-12-06 -> 2017-12-18 0 0 0 6.89 342 b171 2017-12-19 -> 2017-12-31 0 22.16 1566.32 0 343 b172 2017-12-01 -> 2017-12-29 0 1268.35 391.21 0 344 b172 2017-12-01 -> 2017-12-29 0 0 0 6.54 345 b173 2017-12-27 -> 2017-12-27 0 0 0 5.92 346 b173 2017-12-22 -> 2017-12-30 0 0 5.84 0 347 b174 2017-12-22 -> 2017-12-23 0 0 5.78 0 348 b174 2017-12-04 -> 2017-12-31 0 0 0 5.61 349 b175 2017-12-23 -> 2017-12-24 0 0 0 5.33 350 b175 2017-12-21 -> 2017-12-22 0 0 0 5.32 351 b176 2017-12-12 -> 2017-12-21 0 0 0 5.31 352 b176 2017-12-01 -> 2017-12-29 0 625.6 1363.14 0 353 b177 2017-12-01 -> 2017-12-30 0 0 0 5 354 b177 2017-12-01 -> 2017-12-31 0 0 0 4.89 355 b178 2017-12-11 -> 2017-12-29 0 0 0 4.67 356 b178 2017-12-04 -> 2017-12-21 0 0 0 4.66 357 b179 2017-12-07 -> 2017-12-11 0 0 0 4.35 358 b179 2017-12-07 -> 2017-12-14 0 0 0 4.35 359 b180 2017-12-04 -> 2017-12-07 0 0 0 4.35 360 b180 2017-12-01 -> 2017-12-03 0 0 0 4.34 361 b181 2017-12-01 -> 2017-12-31 0 0 2071.82 0 362 b181 2017-12-30 -> 2017-12-30 0 0 0 4.08 363 b182 2017-12-22 -> 2017-12-27 0 0 0 4.07 364 b182 2017-12-06 -> 2017-12-24 0 0 0 4.06 365 b183 2017-12-05 -> 2017-12-28 0 0 0 4.05 366 b183 2017-12-27 -> 2017-12-30 0 0 3.89 0 367 b184 2017-12-22 -> 2017-12-27 0 0 0 3.76 368 b184 2017-12-01 -> 2017-12-01 0 0 0 3.72 369 b185 2017-12-07 -> 2017-12-31 0 0 0 3.71 370 b185 2017-12-30 -> 2017-12-30 0 0 0 3.45 371 b186 2017-12-22 -> 2017-12-27 0 0 0 3.45 372 b186 2017-12-21 -> 2017-12-21 0 0 0 3.45 373 b187 2017-12-13 -> 2017-12-29 0 0 0 3.42 374 b187 2017-12-29 -> 2017-12-30 0 0 0 3.13 375 b188 2017-12-19 -> 2017-12-19 0 0 0 3.12 376 b188 2017-12-13 -> 2017-12-24 0 0 0 3.12 377 b189 2017-12-14 -> 2017-12-26 0 0 0 3.11 378 b189 2017-12-01 -> 2017-12-26 0 2103.39 0 0 379 b190 2017-12-21 -> 2017-12-30 0 19.33 2349.75 0 380 b190 2017-12-01 -> 2017-12-31 0 0 0 2.81 381 b191 2017-12-01 -> 2017-12-08 0 0 0 2.8 382 b191 2017-12-07 -> 2017-12-11 0 0 0 2.8 383 b192 2017-12-01 -> 2017-12-28 1285.13 0 1557.05 0 384 b192 2017-12-20 -> 2017-12-25 0 0 0 2.51 385 b193 2017-12-14 -> 2017-12-25 0 0 0 2.5 386 b193 2017-12-08 -> 2017-12-20 0 0 0 2.49 387 b194 2017-12-11 -> 2017-12-28 0 0 0 2.49 388 b194 2017-12-01 -> 2017-12-30 0 0 0 2.48 389 b195 2017-12-01 -> 2017-12-24 0 2984 0 0 390 b195 2017-12-15 -> 2017-12-21 0 0 0 2.18 391 b196 2017-12-13 -> 2017-12-23 0 0 0 2.18 392 b196 2017-12-07 -> 2017-12-11 0 0 0 2.17 393 b197 2017-12-13 -> 2017-12-13 0 0 0 2.17 394 b197 2017-12-01 -> 2017-12-01 0 0 0 2.17 395 b198 2017-12-04 -> 2017-12-28 0 0 0 1.96 396 b198 2017-12-11 -> 2017-12-13 0 0 0 1.96 397 b199 2017-12-22 -> 2017-12-28 0 0 1.92 0 398 b199 2017-12-16 -> 2017-12-26 0 0 0 1.88 399 b200 2017-12-20 -> 2017-12-20 0 0 0 1.88 400 b200 2017-12-13 -> 2017-12-27 0 0 0 1.87 401 b201 2017-12-13 -> 2017-12-19 0 0 0 1.87 402 b201 2017-12-04 -> 2017-12-04 0 0 0 1.86 403 b202 2017-12-19 -> 2017-12-30 0 0 0 1.57 404 b202 2017-12-23 -> 2017-12-31 0 0 0 1.57 405 b203 2017-12-23 -> 2017-12-29 0 0 0 1.57 406 b203 2017-12-02 -> 2017-12-31 0 0 0 1.56 407 b204 2017-12-15 -> 2017-12-15 0 0 0 1.56 408 b204 2017-12-03 -> 2017-12-26 0 0 0 1.56 409 b205 2017-12-11 -> 2017-12-22 0 0 0 1.56 410 b205 2017-12-26 -> 2017-12-29 0 0 3550.8 0 411 b206 2017-12-29 -> 2017-12-30 0 0 1.37 0 412 b206 2017-12-27 -> 2017-12-28 0 0 0 1.25 413 b207 2017-12-11 -> 2017-12-19 0 0 0 1.24 414 b207 2017-12-04 -> 2017-12-30 0 0 0 1.24 415 b208 2017-12-11 -> 2017-12-11 0 0 0 1.24 416 b208 2017-12-13 -> 2017-12-13 0 0 0 1.24 417 b209 2017-12-04 -> 2017-12-13 0 0 0 1.24 418 b209 2017-12-04 -> 2017-12-31 2505.15 385.44 723.58 0 419 b210 2017-12-01 -> 2017-12-31 2235.2 419.45 2263.12 0 420 b210 2017-12-01 -> 2017-12-18 0 0 0 1 421 b211 2017-12-15 -> 2017-12-29 0 0 0 0.99 422 b211 2017-12-06 -> 2017-12-28 0 0 0 0.99 423 b212 2017-12-13 -> 2017-12-13 0 0 0 0.98 424 b212 2017-12-23 -> 2017-12-26 0 0 0 0.94 425 b213 2017-12-18 -> 2017-12-26 0 0 0 0.94 426 b213 2017-12-28 -> 2017-12-30 0 0 0 0.94 427 b214 2017-12-21 -> 2017-12-21 0 0 0 0.94 428 b214 2017-12-28 -> 2017-12-28 0 0 0 0.94 429 b215 2017-12-14 -> 2017-12-14 0 0 0 0.93 430 b215 2017-12-06 -> 2017-12-08 0 0 0 0.93 431 b216 2017-12-22 -> 2017-12-28 0 0 0.83 0 432 b216 2017-12-01 -> 2017-12-03 0 0 0 0.77 433 b217 2017-12-04 -> 2017-12-07 0 0 0 0.77 434 b217 2017-12-22 -> 2017-12-28 0 0 0.65 0 435 b218 2017-12-23 -> 2017-12-23 0 0 0 0.63 436 b218 2017-12-23 -> 2017-12-27 0 0 0 0.63 437 b219 2017-12-26 -> 2017-12-28 0 0 0 0.63 438 b219 2017-12-21 -> 2017-12-21 0 0 0 0.63 439 b220 2017-12-01 -> 2017-12-26 0 0 0 0.62 440 b220 2017-12-12 -> 2017-12-18 0 0 0 0.62 441 b221 2017-12-15 -> 2017-12-15 0 0 0 0.62 442 b221 2017-12-04 -> 2017-12-19 0 0 0 0.62 443 b222 2017-12-01 -> 2017-12-21 0 0 0 0.62 444 b222 2017-12-04 -> 2017-12-04 0 0 0 0.62 445 b223 2017-12-04 -> 2017-12-04 0 0 0 0.62 446 b223 2017-12-01 -> 2017-12-12 6208.44 0 0 0 447 b224 2017-12-01 -> 2017-12-31 0 37.67 6815.38 0 448 b224 2017-12-30 -> 2017-12-30 0 0 0 0.31 449 b225 2017-12-23 -> 2017-12-29 0 0 0 0.31 450 b225 2017-12-29 -> 2017-12-29 0 0 0 0.31 451 b226 2017-12-28 -> 2017-12-30 0 0 0 0.31 452 b226 2017-12-05 -> 2017-12-30 0 0 0 0.31 453 b227 2017-12-17 -> 2017-12-17 0 0 0 0.31 454 b227 2017-12-19 -> 2017-12-19 0 0 0 0.31 455 b228 2017-12-15 -> 2017-12-17 0 0 0 0.31 456 b228 2017-12-14 -> 2017-12-14 0 0 0 0.31 457 b229 2017-12-14 -> 2017-12-14 0 0 0 0.31 458 b229 2017-12-05 -> 2017-12-09 0 0 0 0.31 459 b230 2017-12-05 -> 2017-12-05 0 0 0 0.31 460 b230 2017-12-11 -> 2017-12-11 0 0 0 0.31 461 b231 2017-12-06 -> 2017-12-12 0 0 0 0.31 462 b231 2017-12-14 -> 2017-12-14 0 0 0 0.31 463 b232 2017-12-09 -> 2017-12-09 0 0 0 0.31 464 b232 2017-12-13 -> 2017-12-13 0 0 0 0.31 465 b233 2017-12-03 -> 2017-12-03 0 0 0 0.31 466 b233 2017-12-22 -> 2017-12-28 0 0 0.29 0 467 b234 2017-12-22 -> 2017-12-22 0 0 0.28 0 468 b234 2017-12-19 -> 2017-12-28 0 0 0.26 0 469 b235 2017-12-01 -> 2017-12-21 0 249.44 10169.3 0 470 b235 2017-12-28 -> 2017-12-28 0 0 0.04 0

[#2]

@deokars43 

AVERAGE function

This link describes the formula syntax and usage of the AVERAGE  function in Microsoft Excel.

How To Calculate Averages in Excel (2 Methods and Examples)

...some more informations and exambles.

Excel Function Bible for Excel

examble files from the upper link.

Any articles, templates, third-party products or information I have provided are for reference only. While I endeavor to keep the information up to date and correct as far as I can. I make no representations or warranties, express or implied, as to the completeness, correctness, reliability, suitability, or availability of any product or information, article, file, template, or related graphic on my posts in this forum. The trust you place in such information is therefore entirely at your own risk.

Hope I could help you with these information / links.

NikolinoDE

I know I don't know anything (Socrates)