Example

	A	B	C	D	H	I	J	K
1	ID	taskID	percentComplete	targetCompletion		taskID	goal
2	9134	7380	0	8/20/2020 0:00		7380	2
3	7809	7380	0	8/20/2020 0:00		9919	4
4	5608	9919	1	12/31/2019 0:00		9922	4
5	9134	9919	1	12/31/2019 0:00		9923	3
6	8134	9919	0.963636364	4/30/2020 0:00		9924	3
7	9405	9919	0.945454545	6/30/2020 0:00
8	9980	9919	1	12/31/2019 0:00			total = 14
9	7809	9919	1	3/31/2020 0:00
10	5608	9922	1	12/31/2019 0:00	Count of Overdue for 7380	0		Should be 0 (because targetCompletion > Today)
11	9134	9922	1	12/31/2019 0:00	Count of overdue for 9919	2		Should be 0 (there are 4 complete which meets the goal)
12	8134	9922	1	3/31/2020 0:00	Count of overdue for 9922	2		Should be 0 (there are 4 complete which meets the goal)
13	9405	9922	0.913043478	5/1/2020 0:00	Count of overdue for 9923	1		Should be 0 (there are 3 complete which meets the goal)
14	9980	9922	1	2/28/2020 0:00	Count of overdue for 9924	3		Should be 2 (there is a goal of 3 and 1 is complete, so only 2 should be overdue)
15	7809	9922	1	3/31/2020 0:00
16	5608	9923	1	12/31/2019 0:00	total =	8		Should be 2
17	9134	9923	1	12/31/2019 0:00
18	8134	9923	0.933333333	4/30/2020 0:00
19	9980	9923	1	4/30/2020 0:00
20	7809	9923	1	3/31/2020 0:00
21	5608	9924	0.769230769	5/29/2020 0:00
22	9134	9924	1	6/19/2020 0:00
23	9980	9924	0.307692308	4/30/2020 0:00
24	7809	9924	0.307692308	11/13/2020 0:00
25
26
27
28
29
30
31
32
33
34
35
36
37
38
39
40
41
42
43
44
45
46
47
48
49
50
51
52
53
54
55
56
57
58
59
60
61
62
63
64
65
66
67
68
69
70
71
72
73
74
75
76
77
78
79
80
81
82
83
84
85
86
87
88
89
90
91
92
93
94
95
96
97
98
99
100