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:
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
Date
Team-hours
Save as values
#Orders
#Orders/hour
Orders Performance
#Items
#Items/hour
Items Performance
Items picked Bailey's
Items picked Company B
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
5/1/2019
18
Save as values
274
15.22
Excellent
1427
79.28
Excellent
0
0
80
29.20%
187
68.25%
2
0.73%
0
0.00%
5
1.82%
Good
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
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/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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
1/24/2019
42.5
Save as values
0
0.00
Very Poor
0
0.00
Very Poor
0
0
0
0
0
0
0
Excellent
1/24/2019
1/23/2019
64
Save as values
0
0.00
Very Poor
0
0.00
Very Poor
0
0
0
0
0
0
0
Excellent
1/23/2019
1/22/2019
40
Save as values
0
0.00
Very Poor
0
0.00
Very Poor
0
0
0
0
0
0
0
Excellent
1/22/2019
1/19/2019
24
Save as values
0
0.00
Very Poor
0
0.00
Very Poor
0
0
0
0
0
0
0
Excellent
1/19/2019
1/18/2019
40
Save as values
0
0.00
Very Poor
0
0.00
Very Poor
0
0
0
0
0
0
0
Excellent
1/18/2019
1/17/2019
21
Save as values
0
0.00
Very Poor
0
0.00
Very Poor
0
0
0
0
0
0
0
Excellent
1/17/2019
1/15/2019
21
Save as values
0
0.00
Very Poor
0
0.00
Very Poor
0
0
0
0
0
0
0
Excellent
1/15/2019
1/14/2019
21
Save as values
0
0.00
Very Poor
0
0.00
Very Poor
0
0
0
0
0
0
0
Excellent
1/14/2019
1/12/2019
21
Save as values
0
0.00
Very Poor
0
0.00
Very Poor
0
0
0
0
0
0
0
Excellent
1/12/2019
1/11/2019
21
Save as values
0
0.00
Very Poor
0
0.00
Very Poor
0
0
0
0
0
0
0
Excellent
1/11/2019
1/10/2019
21
Save as values
0
0.00
Very Poor
0
0.00
Very Poor
0
0
0
0
0
0
0
Excellent
1/10/2019
1/9/2019
14
Save as values
0
0.00
Very Poor
0
0.00
Very Poor
0
0
0
0
0
0
0
Excellent
1/9/2019
1/8/2019
21
Save as values
0
0.00
Very Poor
0
0.00
Very Poor
0
0
0
0
0
0
0
Excellent
1/8/2019
1/7/2019
21
Save as values
0
0.00
Very Poor
0
0.00
Very Poor
0
0
0
0
0
0
0
Excellent
1/7/2019
1/5/2019
21
Save as values
0
0.00
Very Poor
0
0.00
Very Poor
0
0
0
0
0
0
0
Excellent
1/5/2019
1/4/2019
21
Save as values
0
0.00
Very Poor
0
0.00
Very Poor
0
0
0
0
0
0
0
Excellent
1/4/2019
1/3/2019
15
Save as values
0
0.00
Very Poor
0
0.00
Very Poor
0
0
0
0
0
0
0
Excellent
1/3/2019
1/2/2019
14
Save as values
0
0.00
Very Poor
0
0.00
Very Poor
0
0
0
0
0
0
0
Excellent
1/2/2019
There are no rows in this table
Want to print your doc?
This is not the way.
This is not the way.
Try clicking the ⋯ next to your doc name or using a keyboard shortcut (
CtrlP
) instead.