Module 5
QueenQuanna
June4.xlsxDocumentation
| Victoria's Veggies | |||
| Author | |||
| Date | |||
| Purpose | To track daily sales for June | ||
| Data Definition Table | |||
| Field | Description | Data Type | Notes |
| Sale Date | Date of the sale | Date | Use the mm/dd/yyyy format |
| Day | Day of the week | Text | Monday, Tuesday, Wednesday, … |
| Sales ID | Salesperson ID | Number | 1=Victoria, 2=Miguel, 3=Michelle, 4=Sandy, 5=James |
| Business | Type of business for the sale | Text | Group Home, Individual, Residential Care, and Restaurant |
| Amount | Sales total for a specific transaction date and business type | Number | Use the Accounting format and show two decimal places |
Sales Data
| Sale Date | Day | Sales ID | Business | Amount |
| 6/1/17 | Thursday | 3 | Restaurant | 507.52 |
| 6/1/17 | Thursday | 3 | Residential Care | 295.01 |
| 6/1/17 | Thursday | 3 | Group Home | 202.87 |
| 6/1/17 | Thursday | 3 | Individual | 76.23 |
| 6/2/17 | Friday | 1 | Individual | 275.09 |
| 6/2/17 | Friday | 1 | Restaurant | 244.79 |
| 6/2/17 | Friday | 1 | Group Home | 168.12 |
| 6/2/17 | Friday | 1 | Residential Care | 123.16 |
| 6/3/17 | Saturday | 2 | Restaurant | 412.88 |
| 6/3/17 | Saturday | 2 | Residential Care | 279 |
| 6/3/17 | Saturday | 2 | Group Home | 187.72 |
| 6/3/17 | Saturday | 2 | Individual | 182.55 |
| 6/5/17 | Monday | 4 | Residential Care | 349.39 |
| 6/5/17 | Monday | 4 | Restaurant | 336.81 |
| 6/5/17 | Monday | 4 | Group Home | 295.05 |
| 6/5/17 | Monday | 4 | Individual | 197.19 |
| 6/6/17 | Tuesday | 1 | Restaurant | 380.65 |
| 6/6/17 | Tuesday | 1 | Residential Care | 308.04 |
| 6/6/17 | Tuesday | 1 | Group Home | 221.11 |
| 6/6/17 | Tuesday | 1 | Individual | 192.05 |
| 6/7/17 | Wednesday | 5 | Restaurant | 346.84 |
| 6/7/17 | Wednesday | 5 | Group Home | 170.24 |
| 6/7/17 | Wednesday | 5 | Individual | 158.33 |
| 6/7/17 | Wednesday | 5 | Residential Care | 158.25 |
| 6/8/17 | Thursday | 2 | Restaurant | 459.72 |
| 6/8/17 | Thursday | 2 | Individual | 238.89 |
| 6/8/17 | Thursday | 2 | Group Home | 217.6 |
| 6/8/17 | Thursday | 2 | Residential Care | 168.59 |
| 6/9/17 | Friday | 1 | Individual | 499 |
| 6/9/17 | Friday | 1 | Restaurant | 330.87 |
| 6/9/17 | Friday | 1 | Group Home | 207.79 |
| 6/9/17 | Friday | 1 | Residential Care | 196.15 |
| 6/10/17 | Saturday | 3 | Individual | 323.49 |
| 6/10/17 | Saturday | 3 | Restaurant | 281.68 |
| 6/10/17 | Saturday | 3 | Group Home | 194.68 |
| 6/10/17 | Saturday | 3 | Residential Care | 118.07 |
| 6/12/17 | Monday | 4 | Group Home | 355.53 |
| 6/12/17 | Monday | 4 | Restaurant | 322.71 |
| 6/12/17 | Monday | 4 | Individual | 197.33 |
| 6/12/17 | Monday | 4 | Residential Care | 195.17 |
| 6/13/17 | Tuesday | 5 | Restaurant | 480.67 |
| 6/13/17 | Tuesday | 5 | Individual | 159.89 |
| 6/13/17 | Tuesday | 5 | Group Home | 135.75 |
| 6/13/17 | Tuesday | 5 | Residential Care | 38.13 |
| 6/14/17 | Wednesday | 3 | Individual | 363.32 |
| 6/14/17 | Wednesday | 3 | Restaurant | 275.12 |
| 6/14/17 | Wednesday | 3 | Group Home | 189.36 |
| 6/14/17 | Wednesday | 3 | Residential Care | 64.43 |
| 6/15/17 | Thursday | 1 | Individual | 357.16 |
| 6/15/17 | Thursday | 1 | Restaurant | 307.45 |
| 6/15/17 | Thursday | 1 | Group Home | 142.6 |
| 6/15/17 | Thursday | 1 | Residential Care | 43.91 |
| 6/16/17 | Friday | 1 | Individual | 434.68 |
| 6/16/17 | Friday | 1 | Restaurant | 419.55 |
| 6/16/17 | Friday | 1 | Group Home | 377.4 |
| 6/16/17 | Friday | 1 | Group Home | 377.4 |
| 6/16/17 | Friday | 1 | Residential Care | 189.36 |
| 6/17/17 | Saturday | 4 | Restaurant | 441.32 |
| 6/17/17 | Saturday | 4 | Group Home | 240.64 |
| 6/17/17 | Saturday | 4 | Individual | 162.35 |
| 6/17/17 | Saturday | 4 | Residential Care | 156.65 |
| 6/19/17 | Monday | 3 | Restaurant | 430.2 |
| 6/19/17 | Monday | 3 | Residential Care | 250.49 |
| 6/19/17 | Monday | 3 | Group Home | 197.64 |
| 6/19/17 | Monday | 3 | Individual | 98.96 |
| 6/20/17 | Tuesday | 4 | Individual | 349.69 |
| 6/20/17 | Tuesday | 4 | Restaurant | 235.71 |
| 6/20/17 | Tuesday | 4 | Group Home | 193.29 |
| 6/20/17 | Tuesday | 4 | Residential Care | 0 |
| 6/21/17 | Wednesday | 5 | Group Home | 440.03 |
| 6/21/17 | Wednesday | 5 | Restaurant | 371.87 |
| 6/21/17 | Wednesday | 5 | Individual | 206.33 |
| 6/21/17 | Wednesday | 5 | Residential Care | 73.24 |
| 6/22/17 | Thursday | 1 | Restaurant | 471.33 |
| 6/22/17 | Thursday | 1 | Individual | 241.21 |
| 6/22/17 | Thursday | 1 | Group Home | 228.71 |
| 6/22/17 | Thursday | 1 | Residential Care | 226.16 |
| 6/23/17 | Friday | 1 | Individual | 605.52 |
| 6/23/17 | Friday | 1 | Restaurant | 450.43 |
| 6/23/17 | Friday | 1 | Group Home | 411.24 |
| 6/23/17 | Friday | 1 | Residential Care | 242.67 |
| 6/24/17 | Saturday | 3 | Individual | 321.8 |
| 6/24/17 | Saturday | 3 | Restaurant | 238.48 |
| 6/24/17 | Saturday | 3 | Group Home | 219.64 |
| 6/24/17 | Saturday | 3 | Residential Care | 160.4 |
| 6/26/17 | Monday | 4 | Individual | 394.96 |
| 6/26/17 | Monday | 4 | Restaurant | 275.45 |
| 6/26/17 | Monday | 4 | Group Home | 216.12 |
| 6/26/17 | Monday | 4 | Residential Care | 194.83 |
| 6/27/17 | Tuesday | 5 | Restaurant | 290.59 |
| 6/27/17 | Tuesday | 5 | Individual | 224.95 |
| 6/27/17 | Tuesday | 5 | Group Home | 221.29 |
| 6/27/17 | Tuesday | 5 | Residential Care | 144.39 |
| 6/28/17 | Wednesday | 2 | Restaurant | 407.23 |
| 6/28/17 | Wednesday | 2 | Group Home | 304.16 |
| 6/28/17 | Wednesday | 2 | Residential Care | 192.8 |
| 6/28/17 | Wednesday | 2 | Individual | 54.73 |
| 6/29/17 | Thursday | 3 | Individual | 368.59 |
| 6/29/17 | Thursday | 3 | Restaurant | 366.91 |
| 6/29/17 | Thursday | 3 | Group Home | 165.87 |
| 6/29/17 | Thursday | 3 | Residential Care | 157.19 |
