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
Search
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