ABCDEFGHIJKLMNOPQRSTUVWXYZAAABACADAEAFAGAHAI
1
You will need to make a copy of this document to edit it.
2
Double click in "week starting" cell to see a calendar.
3
Enter target # of listings per week, then track your actual # of listings each day.
4
If a cell is colored YELLOW, do not edit or it will break the formula.
5
Target # of listings is divided by 6 days: 5 weekdays and 1 weekend. It is also rounding down to a whole number.
6
WEEK STARTINGTARGET # OF LISTINGSMONDAYTUESDAYWEDNESDAYTHURSDAYFRIDAYWEEKENDWEEKLY TOTALRUNNING TOTAL:49<--- ACTUAL
7
PER WEEKTARGETACTUALTARGETACTUALTARGETACTUALTARGETACTUALTARGETACTUALTARGETACTUAL40<--- TARGETED
8
9/8/20242545454443434020<--- example data
9
9/15/202415343430373431029<--- example data
10
0000000
11
0000000
12
0000000
13
0000000
14
0000000
15
0000000
16
0000000
17
0000000
18
0000000
19
0000000
20
0000000
21
0000000
22
0000000
23
0000000
24
0000000
25
0000000
26
0000000
27
0000000
28
0000000
29
0000000
30
0000000
31
0000000
32
0000000
33
0000000
34
0000000
35
0000000
36
0000000
37
0000000
38
0000000
39
0000000
40
0000000
41
0000000
42
0000000
43
0000000
44
0000000
45
0000000
46
0000000
47
0000000
48
0000000
49
0000000
50
0000000
51
0000000
52
0000000
53
0000000
54
0000000
55
0000000
56
0000000
57
0000000
58
0000000
59
0000000
60
0000000
61
0000000
62
0000000
63
0000000
64
0000000
65
0000000
66
0000000
67
0000000
68
0000000
69
0000000
70
0000000
71
0000000
72
0000000
73
0000000
74
0000000
75
0000000
76
0000000
77
0000000
78
0000000
79
0000000
80
0000000
81
0000000
82
0000000
83
0000000
84
0000000
85
0000000
86
0000000
87
0000000
88
0000000
89
0000000
90
0000000
91
0000000
92
0000000
93
0000000
94
0000000
95
0000000
96
0000000
97
0000000
98
0000000
99
0000000
100
0000000