Skip to content
Shipping

Data w/ formulas

Input daily data here.

This section calculates a summary of the
, which is updated daily. Instead of leaving all the daily raw data in the doc, we just save the summary values that are calculated in this section. Once the
Save as values
button is clicked, the summary data from the table below is saved in
.

Instructions:
Input team hours for the day
Review the summarized values in each of the columns
Click the green button to save as values

Note: if you need to edit the data in a day, delete the row for that day in
, and then re-save the data here.

Add new row

Daily Data
0
Date
Team-hours
Save as values
#Orders
#Orders/hour
Orders Performance
#Items
#Items/hour
Items Performance
Items picked Bailey's
Items picked Peyton Bre
Daily Performance
Shipping Time (< 1 day)
% Shipping Time (< 1 day)
Shipping Time (>=1 & <2 days)
% Shipping Time (>=1 & <2 days)
Shipping Time (>=2 & <3 days)
% Shipping Time (>=2 & <3 days)
Shipping Time (>=3 & <4 days)
% Shipping Time (>=3 & <4 days)
Shipping Time (>= 4 days)
% Shipping Time (>= 4 days)
Shipping Performance
Linked to Row
1
5/1/2019
18
Save as values
274
15.22
Excellent
1427
79.28
Excellent
1,147
279
80
29.20%
187
68.25%
2
0.73%
0
0.00%
5
1.82%
Good
2
4/30/2019
26
Save as values
0
0.00
Very Poor
0
0.00
Very Poor
0
0
0
0
0
0
0
Excellent
4/30/2019
3
4/29/2019
23
Save as values
0
0.00
Very Poor
0
0.00
Very Poor
0
0
0
0
0
0
0
Excellent
4/29/2019
4
4/27/2019
24
Save as values
0
0.00
Very Poor
0
0.00
Very Poor
0
0
0
0
0
0
0
Excellent
4/27/2019
5
4/26/2019
25
Save as values
0
0.00
Very Poor
0
0.00
Very Poor
0
0
0
0
0
0
0
Excellent
4/26/2019
6
4/25/2019
24
Save as values
0
0.00
Very Poor
0
0.00
Very Poor
0
0
0
0
0
0
0
Excellent
4/25/2019
7
4/24/2019
44
Save as values
0
0.00
Very Poor
0
0.00
Very Poor
0
0
0
0
0
0
0
Excellent
4/24/2019
8
4/23/2019
40
Save as values
0
0.00
Very Poor
0
0.00
Very Poor
0
0
0
0
0
0
0
Excellent
4/23/2019
9
4/22/2019
28.5
Save as values
0
0.00
Very Poor
0
0.00
Very Poor
0
0
0
0
0
0
0
Excellent
4/22/2019
10
4/20/2019
22
Save as values
0
0.00
Very Poor
0
0.00
Very Poor
0
0
0
0
0
0
0
Excellent
4/20/2019
11
4/19/2019
32.5
Save as values
0
0.00
Very Poor
0
0.00
Very Poor
0
0
0
0
0
0
0
Excellent
4/19/2019
12
4/18/2019
37
Save as values
0
0.00
Very Poor
0
0.00
Very Poor
0
0
0
0
0
0
0
Excellent
4/18/2019
13
4/17/2019
33
Save as values
0
0.00
Very Poor
0
0.00
Very Poor
0
0
0
0
0
0
0
Excellent
4/17/2019
14
4/16/2019
36.5
Save as values
0
0.00
Very Poor
0
0.00
Very Poor
0
0
0
0
0
0
0
Excellent
4/16/2019
15
4/15/2019
36
Save as values
0
0.00
Very Poor
0
0.00
Very Poor
0
0
0
0
0
0
0
Excellent
4/15/2019
16
4/13/2019
24
Save as values
0
0.00
Very Poor
0
0.00
Very Poor
0
0
0
0
0
0
0
Excellent
4/13/2019
17
4/12/2019
21
Save as values
0
0.00
Very Poor
0
0.00
Very Poor
0
0
0
0
0
0
0
Excellent
4/12/2019
18
4/11/2019
24
Save as values
0
0.00
Very Poor
0
0.00
Very Poor
0
0
0
0
0
0
0
Excellent
4/11/2019
19
4/10/2019
26.5
Save as values
0
0.00
Very Poor
0
0.00
Very Poor
0
0
0
0
0
0
0
Excellent
4/10/2019
20
4/9/2019
23
Save as values
0
0.00
Very Poor
0
0.00
Very Poor
0
0
0
0
0
0
0
Excellent
4/9/2019
21
4/8/2019
32
Save as values
0
0.00
Very Poor
0
0.00
Very Poor
0
0
0
0
0
0
0
Excellent
4/8/2019
22
4/6/2019
24
Save as values
0
0.00
Very Poor
0
0.00
Very Poor
0
0
0
0
0
0
0
Excellent
4/6/2019
23
4/5/2019
21
Save as values
0
0.00
Very Poor
0
0.00
Very Poor
0
0
0
0
0
0
0
Excellent
4/5/2019
24
4/4/2019
21
Save as values
0
0.00
Very Poor
0
0.00
Very Poor
0
0
0
0
0
0
0
Excellent
4/4/2019
25
4/3/2019
30
Save as values
0
0.00
Very Poor
0
0.00
Very Poor
0
0
0
0
0
0
0
Excellent
4/3/2019
26
4/2/2019
32
Save as values
0
0.00
Very Poor
0
0.00
Very Poor
0
0
0
0
0
0
0
Excellent
4/2/2019
27
4/1/2019
22.5
Save as values
0
0.00
Very Poor
0
0.00
Very Poor
0
0
0
0
0
0
0
Excellent
4/1/2019
28
3/30/2019
24
Save as values
0
0.00
Very Poor
0
0.00
Very Poor
0
0
0
0
0
0
0
Excellent
3/30/2019
29
3/29/2019
28
Save as values
0
0.00
Very Poor
0
0.00
Very Poor
0
0
0
0
0
0
0
Excellent
3/29/2019
30
3/28/2019
28
Save as values
0
0.00
Very Poor
0
0.00
Very Poor
0
0
0
0
0
0
0
Excellent
3/28/2019
31
3/27/2019
21
Save as values
0
0.00
Very Poor
0
0.00
Very Poor
0
0
0
0
0
0
0
Excellent
3/27/2019
32
3/26/2019
33
Save as values
0
0.00
Very Poor
0
0.00
Very Poor
0
0
0
0
0
0
0
Excellent
3/26/2019
33
3/25/2019
38.5
Save as values
0
0.00
Very Poor
0
0.00
Very Poor
0
0
0
0
0
0
0
Excellent
3/25/2019
34
3/23/2019
24
Save as values
0
0.00
Very Poor
0
0.00
Very Poor
0
0
0
0
0
0
0
Excellent
3/23/2019
35
3/22/2019
26.5
Save as values
0
0.00
Very Poor
0
0.00
Very Poor
0
0
0
0
0
0
0
Excellent
3/22/2019
36
3/21/2019
40.5
Save as values
0
0.00
Very Poor
0
0.00
Very Poor
0
0
0
0
0
0
0
Excellent
3/21/2019
37
3/20/2019
32
Save as values
0
0.00
Very Poor
0
0.00
Very Poor
0
0
0
0
0
0
0
Excellent
3/20/2019
38
3/19/2019
58.5
Save as values
0
0.00
Very Poor
0
0.00
Very Poor
0
0
0
0
0
0
0
Excellent
3/19/2019
39
3/18/2019
34.25
Save as values
0
0.00
Very Poor
0
0.00
Very Poor
0
0
0
0
0
0
0
Excellent
3/18/2019
40
3/16/2019
30
Save as values
0
0.00
Very Poor
0
0.00
Very Poor
0
0
0
0
0
0
0
Excellent
3/16/2019
41
3/15/2019
58.5
Save as values
0
0.00
Very Poor
0
0.00
Very Poor
0
0
0
0
0
0
0
Excellent
3/15/2019
42
3/14/2019
45.5
Save as values
0
0.00
Very Poor
0
0.00
Very Poor
0
0
0
0
0
0
0
Excellent
3/14/2019
43
3/13/2019
45
Save as values
0
0.00
Very Poor
0
0.00
Very Poor
0
0
0
0
0
0
0
Excellent
3/13/2019
44
3/12/2019
25.5
Save as values
0
0.00
Very Poor
0
0.00
Very Poor
0
0
0
0
0
0
0
Excellent
3/12/2019
45
3/11/2019
32
Save as values
0
0.00
Very Poor
0
0.00
Very Poor
0
0
0
0
0
0
0
Excellent
3/11/2019
46
3/9/2019
25
Save as values
0
0.00
Very Poor
0
0.00
Very Poor
0
0
0
0
0
0
0
Excellent
3/9/2019
47
3/8/2019
40
Save as values
0
0.00
Very Poor
0
0.00
Very Poor
0
0
0
0
0
0
0
Excellent
3/8/2019
48
3/7/2019
31
Save as values
0
0.00
Very Poor
0
0.00
Very Poor
0
0
0
0
0
0
0
Excellent
3/7/2019
49
3/6/2019
29
Save as values
0
0.00
Very Poor
0
0.00
Very Poor
0
0
0
0
0
0
0
Excellent
3/6/2019
50
3/5/2019
33
Save as values
0
0.00
Very Poor
0
0.00
Very Poor
0
0
0
0
0
0
0
Excellent
3/5/2019
51
3/4/2019
44.5
Save as values
0
0.00
Very Poor
0
0.00
Very Poor
0
0
0
0
0
0
0
Excellent
3/4/2019
52
3/2/2019
19.5
Save as values
0
0.00
Very Poor
0
0.00
Very Poor
0
0
0
0
0
0
0
Excellent
3/2/2019
53
3/1/2019
36.5
Save as values
0
0.00
Very Poor
0
0.00
Very Poor
0
0
0
0
0
0
0
Excellent
3/1/2019
54
2/28/2019
20
Save as values
0
0.00
Very Poor
0
0.00
Very Poor
0
0
0
0
0
0
0
Excellent
2/28/2019
55
2/27/2019
36
Save as values
0
0.00
Very Poor
0
0.00
Very Poor
0
0
0
0
0
0
0
Excellent
2/27/2019
56
2/26/2019
36
Save as values
0
0.00
Very Poor
0
0.00
Very Poor
0
0
0
0
0
0
0
Excellent
2/26/2019
57
2/25/2019
37
Save as values
0
0.00
Very Poor
0
0.00
Very Poor
0
0
0
0
0
0
0
Excellent
2/25/2019
58
2/23/2019
33
Save as values
0
0.00
Very Poor
0
0.00
Very Poor
0
0
0
0
0
0
0
Excellent
2/23/2019
59
2/22/2019
73
Save as values
0
0.00
Very Poor
0
0.00
Very Poor
0
0
0
0
0
0
0
Excellent
2/22/2019
60
2/21/2019
44.5
Save as values
0
0.00
Very Poor
0
0.00
Very Poor
0
0
0
0
0
0
0
Excellent
2/21/2019
61
2/20/2019
41.5
Save as values
0
0.00
Very Poor
0
0.00
Very Poor
0
0
0
0
0
0
0
Excellent
2/20/2019
62
2/19/2019
35
Save as values
0
0.00
Very Poor
0
0.00
Very Poor
0
0
0
0
0
0
0
Excellent
2/19/2019
63
2/18/2019
32
Save as values
0
0.00
Very Poor
0
0.00
Very Poor
0
0
0
0
0
0
0
Excellent
2/18/2019
64
2/16/2019
22
Save as values
0
0.00
Very Poor
0
0.00
Very Poor
0
0
0
0
0
0
0
Excellent
2/16/2019
65
2/15/2019
16
Save as values
0
0.00
Very Poor
0
0.00
Very Poor
0
0
0
0
0
0
0
Excellent
2/15/2019
66
2/14/2019
33.4
Save as values
0
0.00
Very Poor
0
0.00
Very Poor
0
0
0
0
0
0
0
Excellent
2/14/2019
67
2/13/2019
13
Save as values
0
0.00
Very Poor
0
0.00
Very Poor
0
0
0
0
0
0
0
Excellent
2/13/2019
68
2/12/2019
18
Save as values
0
0.00
Very Poor
0
0.00
Very Poor
0
0
0
0
0
0
0
Excellent
2/12/2019
69
2/11/2019
22
Save as values
0
0.00
Very Poor
0
0.00
Very Poor
0
0
0
0
0
0
0
Excellent
2/11/2019
70
2/9/2019
20
Save as values
0
0.00
Very Poor
0
0.00
Very Poor
0
0
0
0
0
0
0
Excellent
2/9/2019
71
2/8/2019
21
Save as values
0
0.00
Very Poor
0
0.00
Very Poor
0
0
0
0
0
0
0
Excellent
2/8/2019
72
2/7/2019
22
Save as values
0
0.00
Very Poor
0
0.00
Very Poor
0
0
0
0
0
0
0
Excellent
2/7/2019
73
2/6/2019
30
Save as values
0
0.00
Very Poor
0
0.00
Very Poor
0
0
0
0
0
0
0
Excellent
2/6/2019
74
2/5/2019
24
Save as values
0
0.00
Very Poor
0
0.00
Very Poor
0
0
0
0
0
0
0
Excellent
2/5/2019
75
2/4/2019
20
Save as values
0
0.00
Very Poor
0
0.00
Very Poor
0
0
0
0
0
0
0
Excellent
2/4/2019
76
2/2/2019
10
Save as values
0
0.00
Very Poor
0
0.00
Very Poor
0
0
0
0
0
0
0
Excellent
2/2/2019
77
2/1/2019
27
Save as values
0
0.00
Very Poor
0
0.00
Very Poor
0
0
0
0
0
0
0
Excellent
2/1/2019
78
1/31/2019
24
Save as values
0
0.00
Very Poor
0
0.00
Very Poor
0
0
0
0
0
0
0
Excellent
1/31/2019
79
1/30/2019
66.5
Save as values
0
0.00
Very Poor
0
0.00
Very Poor
0
0
0
0
0
0
0
Excellent
1/30/2019
80
1/29/2019
58
Save as values
0
0.00
Very Poor
0
0.00
Very Poor
0
0
0
0
0
0
0
Excellent
1/29/2019
81
1/28/2019
37.5
Save as values
0
0.00
Very Poor
0
0.00
Very Poor
0
0
0
0
0
0
0
Excellent
1/28/2019
82
1/26/2019
30
Save as values
0
0.00
Very Poor
0
0.00
Very Poor
0
0
0
0
0
0
0
Excellent
1/26/2019
83
1/25/2019
52
Save as values
0
0.00
Very Poor
0
0.00
Very Poor
0
0
0
0
0
0
0
Excellent
1/25/2019
84
1/24/2019
42.5
Save as values
0
0.00
Very Poor
0
0.00
Very Poor
0