excel_-_problem_solving.xlsx
1. JittersCoffee_data
| Key |
| Jitters = North |
| Bean Scene = South |
| Product | Month | Store | Revenue |
| Regular | January | North | 4320 |
| Regular | February | North | 4500 |
| Regular | March | North | 3528 |
| Regular | April | North | 3960 |
| Regular | May | North | 3996 |
| Regular | June | North | 3960 |
| Regular | July | North | 3960 |
| Regular | August | North | 4230 |
| Regular | September | North | 4230 |
| Regular | October | North | 4275 |
| Regular | November | North | 4365 |
| Regular | December | North | 4455 |
| Regular | January | South | 3960 |
| Regular | February | South | 4230 |
| Regular | March | South | 4230 |
| Regular | April | South | 4275 |
| Regular | May | South | 4365 |
| Regular | June | South | 4455 |
| Regular | July | South | 4128 |
| Regular | August | South | 4176 |
| Regular | September | South | 3936 |
| Regular | October | South | 4090 |
| Regular | November | South | 3936 |
| Regular | December | South | 4350 |
| Decaf | January | North | 4350 |
| Decaf | February | North | 4350 |
| Decaf | March | North | 4350 |
| Decaf | April | North | 3610 |
| Decaf | May | North | 3640 |
| Decaf | June | North | 3610 |
| Decaf | July | North | 2210 |
| Decaf | August | North | 2430 |
| Decaf | September | North | 2430 |
| Decaf | October | North | 2460 |
| Decaf | November | North | 2540 |
| Decaf | December | North | 2310 |
| Decaf | January | South | 2620 |
| Decaf | February | South | 2450 |
| Decaf | March | South | 2430 |
| Decaf | April | South | 2480 |
| Decaf | May | South | 2540 |
| Decaf | June | South | 2610 |
| Decaf | July | South | 2340 |
| Decaf | August | South | 2380 |
| Decaf | September | South | 2540 |
| Decaf | October | South | 2310 |
| Decaf | November | South | 2400 |
| Decaf | December | South | 2320 |
| French Roast | January | North | 2290 |
| French Roast | February | North | 5290 |
| French Roast | March | North | 4320 |
| French Roast | April | North | 4500 |
| French Roast | May | North | 3528 |
| French Roast | June | North | 3960 |
| French Roast | July | North | 3996 |
| French Roast | August | North | 3960 |
| French Roast | September | North | 3960 |
| French Roast | October | North | 4230 |
| French Roast | November | North | 4230 |
| French Roast | December | North | 4275 |
| French Roast | January | South | 4365 |
| French Roast | February | South | 4455 |
| French Roast | March | South | 3960 |
| French Roast | April | South | 4230 |
| French Roast | May | South | 4230 |
| French Roast | June | South | 4275 |
| French Roast | July | South | 4365 |
| French Roast | August | South | 4455 |
| French Roast | September | South | 4128 |
| French Roast | October | South | 4176 |
| French Roast | November | South | 3936 |
| French Roast | December | South | 4090 |
| Vanilla | January | North | 3936 |
| Vanilla | February | North | 4350 |
| Vanilla | March | North | 4350 |
| Vanilla | April | North | 4350 |
| Vanilla | May | North | 4350 |
| Vanilla | June | North | 3610 |
| Vanilla | July | North | 3640 |
| Vanilla | August | North | 3610 |
| Vanilla | September | North | 2210 |
| Vanilla | October | North | 2430 |
| Vanilla | November | North | 2430 |
| Vanilla | December | North | 2460 |
| Vanilla | January | South | 2540 |
| Vanilla | February | South | 2310 |
| Vanilla | March | South | 2620 |
| Vanilla | April | South | 2450 |
| Vanilla | May | South | 2430 |
| Vanilla | June | South | 2480 |
| Vanilla | July | South | 2540 |
| Vanilla | August | South | 2610 |
| Vanilla | September | South | 2340 |
| Vanilla | October | South | 2380 |
| Vanilla | November | South | 2540 |
| Vanilla | December | South | 2310 |
| Irish Cream | January | North | 2400 |
| Irish Cream | February | North | 2320 |
| Irish Cream | March | North | 2290 |
| Irish Cream | April | North | 5290 |
| Irish Cream | May | North | 4350 |
| Irish Cream | June | North | 4350 |
| Irish Cream | July | North | 4350 |
| Irish Cream | August | North | 4350 |
| Irish Cream | September | North | 3610 |
| Irish Cream | October | North | 3640 |
| Irish Cream | November | North | 3610 |
| Irish Cream | December | North | 2210 |
| Irish Cream | January | South | 2430 |
| Irish Cream | February | South | 2430 |
| Irish Cream | March | South | 2460 |
| Irish Cream | April | South | 2540 |
| Irish Cream | May | South | 2310 |
| Irish Cream | June | South | 2620 |
| Irish Cream | July | South | 2450 |
| Irish Cream | August | South | 2430 |
| Irish Cream | September | South | 2480 |
| Irish Cream | October | South | 2540 |
| Irish Cream | November | South | 2610 |
| Irish Cream | December | South | 4350 |
| Hazelnut | January | North | 3610 |
| Hazelnut | February | North | 3640 |
| Hazelnut | March | North | 3610 |
| Hazelnut | April | North | 2210 |
| Hazelnut | May | North | 2430 |
| Hazelnut | June | North | 2430 |
| Hazelnut | July | North | 2460 |
| Hazelnut | August | North | 2540 |
| Hazelnut | September | North | 2310 |
| Hazelnut | October | North | 2620 |
| Hazelnut | November | North | 2450 |
| Hazelnut | December | North | 2430 |
| Hazelnut | January | South | 2480 |
| Hazelnut | February | South | 2540 |
| Hazelnut | March | South | 2610 |
| Hazelnut | April | South | 2340 |
| Hazelnut | May | South | 2380 |
| Hazelnut | June | South | 2540 |
| Hazelnut | July | South | 2310 |
| Hazelnut | August | South | 2400 |
| Hazelnut | September | South | 2320 |
| Hazelnut | October | South | 2290 |
| Hazelnut | November | South | 5290 |
| Hazelnut | December | South | 4320 |
2. Employee_data
| ID | First Name | Last Name | Department | Title | Salary | Hire Date | Birth Date | Gender | Clearance |
| 2956 | Michael | Goldstein | Engineering | Engineer | 51,000 | 4/11/97 | 3/7/63 | M | TS |
| 4123 | Steve | Ballmer | Engineering | Engineer | 42,900 | 5/1/02 | 4/14/70 | M | N |
| 3117 | Frederich | Bednarczyk | Engineering | Engineer | 56,700 | 5/14/99 | 5/27/70 | M | S |
| 2122 | Yuan | Chang | Engineering | Engineer | 46,540 | 9/5/95 | 3/4/64 | M | TS |
| 2451 | Francine | Detweiler | Engineering | Engineer | 56,700 | 10/10/95 | 4/29/70 | F | S |
| 2896 | Samuel | Gates | Engineering | Engineer | 66,300 | 1/28/97 | 4/10/74 | M | S |
| 2768 | Phyllis | Leonard | Engineering | Engineer | 59,800 | 12/13/96 | 7/2/70 | F | TS |
| 1119 | Sharad | Manispour | Engineering | Manager | 54,500 | 10/13/90 | 2/4/69 | M | S |
| 2344 | Nemesha | Mehta | Engineering | Engineer | 65,000 | 10/1/95 | 2/12/65 | F | S |
| 3210 | Carmen | Ortega-Molina | Engineering | Engineer | 46,000 | 9/16/99 | 3/28/52 | F | S |
| 2002 | Edgar | Rothrock | Engineering | Engineer | 53,300 | 2/8/94 | 3/21/70 | M | S |
| 3015 | Patti | Stonesifer | Engineering | Engineer | 64,300 | 7/6/98 | 3/10/66 | F | S |
| 2678 | Koshi | Yamamoto | Engineering | Engineer | 49,600 | 11/16/95 | 1/24/63 | F | S |
| 2733 | John | Zumkowski | Engineering | Staff | 33,000 | 4/18/96 | 12/12/72 | M | TS |
| 3314 | Svetlana | Kartashev | Human Resources | Staff | 38,000 | 11/5/01 | 5/3/82 | F | N |
| 4006 | Alice | Rovik | Human Resources | Manager | 43,000 | 12/1/01 | 1/26/55 | M | S |
| 2042 | Hillary | Cushner | Management | Staff | 32,000 | 8/26/94 | 5/6/61 | F | TS |
| 1851 | Melinda | English | Management | Manager | 62,040 | 10/1/93 | 2/14/56 | F | TS |
| 1355 | Barbara | Grabowski | Management | Manager | 75,700 | 10/13/92 | 4/10/65 | F | C |
| 1173 | Roberta | Kurzweil | Management | Manager | 63,000 | 6/16/92 | 12/22/58 | F | S |
| 1441 | James | Van Horn | Management | Manager | 66,500 | 12/18/92 | 2/3/58 | M | S |
| 1042 | Maria | Andretti | Marketing | CSR | 42,500 | 3/21/90 | 8/20/70 | F | N |
| 1032 | Hillary | Flintsteel | Marketing | Staff | 34,500 | 3/21/90 | 8/22/58 | F | N |
| 1009 | Kevin | Grundies | Marketing | CSR | 38,900 | 12/24/89 | 3/4/61 | M | C |
| 1614 | Artie | Lambros | Marketing | CSR | 41,000 | 5/16/93 | 7/13/70 | M | N |
| 2105 | Luca | Pacioli | Marketing | Staff | 42,300 | 8/26/95 | 5/6/50 | M | S |
| 1016 | Oscar | Gomez | Marketing | CSR | 43,500 | 2/16/90 | 4/29/67 | M | N |
3. RedRocks_data
| Submitted | Employee ID | Last Name | First Name | Organization | Amount | Donation Sent |
| 11/29/11 | 688 | Abbs | Don | Habitat for Humanity | $ 50 | 12/1/11 |
| 12/5/11 | 08T | Adams | David | Red Cross | $ 100 | 12/6/11 |
| 12/9/11 | Y7CA | Ascott | Karen | Red Cross | $ 100 | 12/18/11 |
| 12/5/11 | M5NA | Bagby | Sharon | Rotary Club | $ 25 | 12/6/11 |
| 12/3/11 | 39N | Butler | Barry | Rotary Club | $ 250 | 12/10/11 |
| 12/3/11 | 0NNA | Clark | Jolene | Toastmasters | $ 20 | 12/5/11 |
| 12/2/11 | 0NNA | Clark | Jolene | Make a Wish Foundation | $ 75 | 12/4/11 |
| 12/6/11 | 0NNA | Clark | Jolene | Leukemia Society | $ 60 | 12/19/11 |
| 12/16/11 | CT8A | Donovan | Gary | Make a Wish Foundation | $ 130 | 12/21/11 |
| 12/12/11 | 1XBA | Doster | Glenn | Amnisty International | $ 200 | 12/21/11 |
| 12/16/11 | L3H | Dunn | Elaine | Make a Wish Foundation | $ 225 | 12/29/11 |
| 12/4/11 | 56NA | Foster | Scott | Rotary Club | $ 125 | 12/10/11 |
| 12/2/11 | 56NA | Foster | Scott | Meals on WHeels | $ 125 | 12/26/11 |
| 12/17/11 | 1F9A | Hughes | Gary | Red Cross | $ 50 | 12/22/11 |
| 12/27/11 | J5M | Johnson | Les | Foster Children's Fund | $ 25 | 12/30/11 |
| 12/10/11 | 44JA | Kelleher | George | Romania Relief | $ 180 | 12/14/11 |
| 12/20/11 | 57XA | Lomstein | Thomas | Meals on WHeels | $ 115 | 12/22/11 |
| 12/12/11 | FA5A | Peters | Roger | Toastmasters | $ 35 | 12/15/11 |
| 12/14/11 | FA5A | Peters | Roger | Foster Children's Fund | $ 80 | 12/19/11 |
| 12/6/11 | R9M | Simpson | Joseph | Red Cross | $ 50 | 12/19/11 |
| 12/13/11 | R9M | Simpson | Jospeh | Habitat for Humanity | $ 150 | 12/23/11 |
| 12/6/11 | 08A | Thimsen | Timothy | Rotary Club | $ 50 | 12/14/11 |
| 12/3/11 | C3P | Warren | James | Lion's Club | $ 60 | 12/13/11 |
| 12/27/11 | R45A | Womak | Anthony | Habitat for Humanity | $ 100 | 12/29/11 |
Rickross69
