| A | B | C | D | E | F | G | H | I | J | K | L | M | N | O | P | |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
1 | Order ID | Date | Customer ID | Customer Name | Sales Person | Region | Item | Price | Quantity | Revenue | ||||||
2 | 0001 | 1/1/2018 | 11 | Company K | Michael Fox | New Mexico | Item 2 | 199 | 3 | 597 | ||||||
3 | 0002 | 1/2/2018 | 1 | Company A | Anna Weber | Texas | Item 5 | 289 | 7 | 2023 | ||||||
4 | 0003 | 1/3/2018 | 9 | Company I | Kim Fishman | California | Item 4 | 159 | 3 | 477 | ||||||
5 | 0004 | 1/3/2018 | 18 | Company R | Oscar Knox | Arizona | Item 5 | 289 | 3 | 867 | ||||||
6 | 0005 | 1/4/2018 | 16 | Company P | Oscar Knox | Arizona | Item 3 | 69 | 4 | 276 | ||||||
7 | 0006 | 1/4/2018 | 13 | Company M | Michael Fox | New Mexico | Item 2 | 199 | 2 | 398 | ||||||
8 | 0007 | 1/4/2018 | 17 | Company Q | Andrew James | Arizona | Item 5 | 289 | 9 | 2601 | ||||||
9 | 0008 | 1/5/2018 | 14 | Company N | Michael Fox | New Mexico | Item 2 | 199 | 5 | 995 | ||||||
10 | 0009 | 1/5/2018 | 20 | Company T | Andrew James | Arizona | Item 1 | 399 | 5 | 1995 | ||||||
11 | 0010 | 1/5/2018 | 3 | Company C | Anna Weber | Texas | Item 2 | 199 | 0 | 0 | ||||||
12 | 0011 | 1/5/2018 | 8 | Company H | Laura Larsen | California | Item 5 | 289 | 9 | 2601 | ||||||
13 | 0012 | 1/5/2018 | 6 | Company F | Laura Larsen | California | Item 1 | 399 | 6 | 2394 | ||||||
14 | 0013 | 1/5/2018 | 9 | Company I | Kim Fishman | California | Item 2 | 199 | 6 | 1194 | ||||||
15 | 0014 | 1/5/2018 | 4 | Company D | Anna Weber | Texas | Item 1 | 399 | 4 | 1596 | ||||||
16 | 0015 | 1/5/2018 | 6 | Company F | Kim Fishman | California | Item 2 | 199 | 2 | 398 | ||||||
17 | 0016 | 1/6/2018 | 13 | Company M | Michael Fox | New Mexico | Item 3 | 69 | 0 | 0 | ||||||
18 | 0017 | 1/7/2018 | 14 | Company N | Michael Fox | New Mexico | Item 5 | 289 | 0 | 0 | ||||||
19 | 0018 | 1/7/2018 | 19 | Company S | Oscar Knox | Arizona | Item 4 | 159 | 5 | 795 | ||||||
20 | 0019 | 1/7/2018 | 10 | Company J | Laura Larsen | California | Item 3 | 69 | 2 | 138 | ||||||
21 | 0020 | 1/7/2018 | 5 | Company E | Anna Weber | Texas | Item 1 | 399 | 3 | 1197 | ||||||
22 | 0021 | 1/7/2018 | 10 | Company J | Laura Larsen | California | Item 3 | 69 | 2 | 138 | ||||||
23 | 0022 | 1/7/2018 | 11 | Company K | Anne Lee | New Mexico | Item 5 | 289 | 6 | 1734 | ||||||
24 | 0023 | 1/7/2018 | 8 | Company H | Laura Larsen | California | Item 4 | 159 | 4 | 636 | ||||||
25 | 0024 | 1/7/2018 | 12 | Company L | Michael Fox | New Mexico | Item 1 | 399 | 2 | 798 | ||||||
26 | 0025 | 1/8/2018 | 3 | Company C | Ben Wallace | Texas | Item 1 | 399 | 0 | 0 | ||||||
27 | 0026 | 1/8/2018 | 14 | Company N | Michael Fox | New Mexico | Item 5 | 289 | 0 | 0 | ||||||
28 | 0027 | 1/8/2018 | 14 | Company N | Anne Lee | New Mexico | Item 2 | 199 | 1 | 199 | ||||||
29 | 0028 | 1/8/2018 | 19 | Company S | Andrew James | Arizona | Item 1 | 399 | 7 | 2793 | ||||||
30 | 0029 | 1/9/2018 | 10 | Company J | Laura Larsen | California | Item 2 | 199 | 3 | 597 | ||||||
31 | 0030 | 1/9/2018 | 12 | Company L | Anne Lee | New Mexico | Item 5 | 289 | 0 | 0 | ||||||
32 | 0031 | 1/9/2018 | 6 | Company F | Kim Fishman | California | Item 4 | 159 | 2 | 318 | ||||||
33 | 0032 | 1/9/2018 | 6 | Company F | Laura Larsen | California | Item 1 | 399 | 3 | 1197 | ||||||
34 | 0033 | 1/10/2018 | 6 | Company F | Laura Larsen | California | Item 3 | 69 | 2 | 138 | ||||||
35 | 0034 | 1/11/2018 | 1 | Company A | Ben Wallace | Texas | Item 2 | 199 | 8 | 1592 | ||||||
36 | 0035 | 1/11/2018 | 16 | Company P | Andrew James | Arizona | Item 2 | 199 | 5 | 995 | ||||||
37 | 0036 | 1/11/2018 | 13 | Company M | Anne Lee | New Mexico | Item 5 | 289 | 1 | 289 | ||||||
38 | 0037 | 1/11/2018 | 13 | Company M | Anne Lee | New Mexico | Item 1 | 399 | 4 | 1596 | ||||||
39 | 0038 | 1/12/2018 | 20 | Company T | Oscar Knox | Arizona | Item 1 | 399 | 3 | 1197 | ||||||
40 | 0039 | 1/12/2018 | 19 | Company S | Andrew James | Arizona | Item 3 | 69 | 8 | 552 | ||||||
41 | 0040 | 1/12/2018 | 14 | Company N | Michael Fox | New Mexico | Item 5 | 289 | 3 | 867 | ||||||
42 | 0041 | 1/13/2018 | 9 | Company I | Kim Fishman | California | Item 1 | 399 | 4 | 1596 | ||||||
43 | 0042 | 1/13/2018 | 17 | Company Q | Andrew James | Arizona | Item 3 | 69 | 5 | 345 | ||||||
44 | 0043 | 1/13/2018 | 13 | Company M | Anne Lee | New Mexico | Item 4 | 159 | 8 | 1272 | ||||||
45 | 0044 | 1/13/2018 | 7 | Company G | Laura Larsen | California | Item 1 | 399 | 5 | 1995 | ||||||
46 | 0045 | 1/13/2018 | 12 | Company L | Anne Lee | New Mexico | Item 5 | 289 | 4 | 1156 | ||||||
47 | 0046 | 1/13/2018 | 14 | Company N | Michael Fox | New Mexico | Item 4 | 159 | 7 | 1113 | ||||||
48 | 0047 | 1/13/2018 | 17 | Company Q | Oscar Knox | Arizona | Item 5 | 289 | 0 | 0 | ||||||
49 | 0048 | 1/13/2018 | 16 | Company P | Oscar Knox | Arizona | Item 3 | 69 | 1 | 69 | ||||||
50 | 0049 | 1/13/2018 | 4 | Company D | Ben Wallace | Texas | Item 4 | 159 | 5 | 795 | ||||||
51 | 0050 | 1/13/2018 | 5 | Company E | Ben Wallace | Texas | Item 4 | 159 | 7 | 1113 | ||||||
52 | 0051 | 1/13/2018 | 19 | Company S | Andrew James | Arizona | Item 1 | 399 | 6 | 2394 | ||||||
53 | 0052 | 1/13/2018 | 1 | Company A | Ben Wallace | Texas | Item 3 | 69 | 2 | 138 | ||||||
54 | 0053 | 1/14/2018 | 17 | Company Q | Andrew James | Arizona | Item 3 | 69 | 7 | 483 | ||||||
55 | 0054 | 1/15/2018 | 8 | Company H | Laura Larsen | California | Item 5 | 289 | 1 | 289 | ||||||
56 | 0055 | 1/15/2018 | 7 | Company G | Laura Larsen | California | Item 1 | 399 | 0 | 0 | ||||||
57 | 0056 | 1/15/2018 | 20 | Company T | Andrew James | Arizona | Item 3 | 69 | 9 | 621 | ||||||
58 | 0057 | 1/15/2018 | 8 | Company H | Laura Larsen | California | Item 2 | 199 | 5 | 995 | ||||||
59 | 0058 | 1/15/2018 | 11 | Company K | Michael Fox | New Mexico | Item 3 | 69 | 9 | 621 | ||||||
60 | 0059 | 1/15/2018 | 9 | Company I | Kim Fishman | California | Item 1 | 399 | 7 | 2793 | ||||||
61 | 0060 | 1/15/2018 | 10 | Company J | Laura Larsen | California | Item 2 | 199 | 3 | 597 | ||||||
62 | 0061 | 1/16/2018 | 2 | Company B | Anna Weber | Texas | Item 4 | 159 | 8 | 1272 | ||||||
63 | 0062 | 1/17/2018 | 20 | Company T | Andrew James | Arizona | Item 4 | 159 | 9 | 1431 | ||||||
64 | 0063 | 1/17/2018 | 9 | Company I | Laura Larsen | California | Item 5 | 289 | 7 | 2023 | ||||||
65 | 0064 | 1/18/2018 | 9 | Company I | Laura Larsen | California | Item 1 | 399 | 1 | 399 | ||||||
66 | 0065 | 1/19/2018 | 9 | Company I | Laura Larsen | California | Item 2 | 199 | 6 | 1194 | ||||||
67 | 0066 | 1/19/2018 | 10 | Company J | Laura Larsen | California | Item 5 | 289 | 3 | 867 | ||||||
68 | 0067 | 1/20/2018 | 16 | Company P | Oscar Knox | Arizona | Item 3 | 69 | 2 | 138 | ||||||
69 | 0068 | 1/20/2018 | 13 | Company M | Anne Lee | New Mexico | Item 2 | 199 | 8 | 1592 | ||||||
70 | 0069 | 1/21/2018 | 19 | Company S | Andrew James | Arizona | Item 2 | 199 | 8 | 1592 | ||||||
71 | 0070 | 1/21/2018 | 6 | Company F | Laura Larsen | California | Item 2 | 199 | 0 | 0 | ||||||
72 | 0071 | 1/21/2018 | 17 | Company Q | Oscar Knox | Arizona | Item 4 | 159 | 4 | 636 | ||||||
73 | 0072 | 1/22/2018 | 15 | Company O | Anne Lee | New Mexico | Item 1 | 399 | 4 | 1596 | ||||||
74 | 0073 | 1/23/2018 | 15 | Company O | Anne Lee | New Mexico | Item 4 | 159 | 1 | 159 | ||||||
75 | 0074 | 1/23/2018 | 20 | Company T | Oscar Knox | Arizona | Item 5 | 289 | 1 | 289 | ||||||
76 | 0075 | 1/23/2018 | 13 | Company M | Michael Fox | New Mexico | Item 5 | 289 | 5 | 1445 | ||||||
77 | 0076 | 1/24/2018 | 18 | Company R | Oscar Knox | Arizona | Item 3 | 69 | 7 | 483 | ||||||
78 | 0077 | 1/24/2018 | 8 | Company H | Laura Larsen | California | Item 3 | 69 | 2 | 138 | ||||||
79 | 0078 | 1/24/2018 | 5 | Company E | Ben Wallace | Texas | Item 5 | 289 | 1 | 289 | ||||||
80 | 0079 | 1/24/2018 | 19 | Company S | Oscar Knox | Arizona | Item 5 | 289 | 8 | 2312 | ||||||
81 | 0080 | 1/24/2018 | 10 | Company J | Kim Fishman | California | Item 5 | 289 | 3 | 867 | ||||||
82 | 0081 | 1/24/2018 | 7 | Company G | Laura Larsen | California | Item 1 | 399 | 6 | 2394 | ||||||
83 | 0082 | 1/24/2018 | 5 | Company E | Anna Weber | Texas | Item 3 | 69 | 1 | 69 | ||||||
84 | 0083 | 1/24/2018 | 10 | Company J | Laura Larsen | California | Item 3 | 69 | 2 | 138 | ||||||
85 | 0084 | 1/25/2018 | 18 | Company R | Andrew James | Arizona | Item 1 | 399 | 1 | 399 | ||||||
86 | 0085 | 1/26/2018 | 4 | Company D | Ben Wallace | Texas | Item 1 | 399 | 9 | 3591 | ||||||
87 | 0086 | 1/26/2018 | 12 | Company L | Michael Fox | New Mexico | Item 1 | 399 | 2 | 798 | ||||||
88 | 0087 | 1/27/2018 | 17 | Company Q | Andrew James | Arizona | Item 4 | 159 | 3 | 477 | ||||||
89 | 0088 | 1/27/2018 | 12 | Company L | Michael Fox | New Mexico | Item 3 | 69 | 2 | 138 | ||||||
90 | 0089 | 1/27/2018 | 8 | Company H | Kim Fishman | California | Item 2 | 199 | 5 | 995 | ||||||
91 | 0090 | 1/27/2018 | 12 | Company L | Anne Lee | New Mexico | Item 3 | 69 | 2 | 138 | ||||||
92 | 0091 | 1/27/2018 | 19 | Company S | Andrew James | Arizona | Item 5 | 289 | 4 | 1156 | ||||||
93 | 0092 | 1/28/2018 | 20 | Company T | Oscar Knox | Arizona | Item 1 | 399 | 6 | 2394 | ||||||
94 | 0093 | 1/29/2018 | 7 | Company G | Kim Fishman | California | Item 1 | 399 | 1 | 399 | ||||||
95 | 0094 | 1/29/2018 | 8 | Company H | Kim Fishman | California | Item 2 | 199 | 2 | 398 | ||||||
96 | 0095 | 1/29/2018 | 7 | Company G | Laura Larsen | California | Item 3 | 69 | 8 | 552 | ||||||
97 | 0096 | 1/30/2018 | 15 | Company O | Michael Fox | New Mexico | Item 3 | 69 | 9 | 621 | ||||||
98 | 0097 | 1/30/2018 | 11 | Company K | Anne Lee | New Mexico | Item 3 | 69 | 7 | 483 | ||||||
99 | 0098 | 1/30/2018 | 19 | Company S | Oscar Knox | Arizona | Item 4 | 159 | 8 | 1272 | ||||||
100 | 0099 | 1/30/2018 | 8 | Company H | Laura Larsen | California | Item 2 | 199 | 9 | 1791 |