Skip to content
Gallery
Mini E-Commerce ERP
Mini E-Commerce ERP
Shipping
Receiving
Inventory
Picking issues
Goals
Appendix
More
Share
Explore
Shipping

icon picker
Data w/ formulas

Input daily data here.
This section calculates a summary of the
Raw Shipping Data
⁠
, 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
Daily Shipping Report
⁠
.
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
Daily Shipping Report
⁠
, 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
1
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
​
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
0
​
0
​
0
​
0
​
0
​
0
​
Excellent
1/24/2019
85
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
86
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
87
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
88
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
89
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
90
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
91
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
92
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
93
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
94
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
95
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
96
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
97
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
98
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
99
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
100
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
101
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.
Try clicking the ⋯ next to your doc name or using a keyboard shortcut (
CtrlP
) instead.