Excel Chapter 7 Prepare Case - Spa
abparsley
Parsley_Excel_CH07_Prepare_Spa.xlsxIstas
| Turquoise Oasis Spa | |||||
| A Passion for Helping People Relax | |||||
| 5/16/22 | |||||
| Time | Service | Hours | Charge/Hour | Total Charges | Running Total |
| 8:30 AM | Massage - Deep Tissue | 1 | $ 100.00 | ||
| 9:00 AM | 0 | $ - 0 | |||
| 9:30 AM | Body Detox Steam Therapy | 2 | $ 100.00 | ||
| 10:00 AM | 0 | $ - 0 | |||
| 10:30 AM | 0 | $ - 0 | |||
| 11:00 AM | 0 | $ - 0 | |||
| 11:30 AM | Massage - Shiatsu | 1 | $ 125.00 | ||
| 12:00 PM | 0 | $ - 0 | |||
| 12:30 PM | 0 | $ - 0 | |||
| 1:00 PM | Sound Therapy | 1 | $ 75.00 | ||
| 1:30 PM | 0 | $ - 0 | |||
| 2:00 PM | Tibetan Reiki Therapy | 2 | $ 200.00 | ||
| 2:30 PM | 0 | $ - 0 | |||
| 3:00 PM | 0 | $ - 0 | |||
| 3:30 PM | 0 | $ - 0 | |||
| 4:00 PM | Massage - Fusion, Couples | 1 | $ 150.00 | ||
| 4:30 PM | 0 | $ - 0 | |||
| 5:00 PM | 0 | $ - 0 | |||
&F Copyright © 2014 Pearson Education, Inc. Publishing as Prentice Hall
Mault
| Turquoise Oasis Spa | |||||
| A Passion for Helping People Relax | |||||
| 5/16/22 | |||||
| Time | Service | Hours | Charge/Hour | Total Charges | Running Total |
| 8:30 AM | Massage - Deep Tissue | 0.5 | $ 100.00 | ||
| 9:00 AM | Mud Bath | 1 | $ 100.00 | ||
| 9:30 AM | 0 | $ - 0 | |||
| 10:00 AM | Body Detox Electrotherapy | 0.5 | $ 150.00 | ||
| 10:30 AM | Body Detox Steam Therapy | 0.5 | $ 100.00 | ||
| 11:00 AM | 0 | $ - 0 | |||
| 11:30 AM | Sound Therapy | 1 | $ 75.00 | ||
| 12:00 PM | 0 | $ - 0 | |||
| 12:30 PM | 0 | $ - 0 | |||
| 1:00 PM | 0 | $ - 0 | |||
| 1:30 PM | Tibetan Reiki Therapy | 1 | $ 200.00 | ||
| 2:00 PM | 0 | $ - 0 | |||
| 2:30 PM | Massage - Shiatsu | 1 | $ 125.00 | ||
| 3:00 PM | 0 | $ - 0 | |||
| 3:30 PM | 0 | $ - 0 | |||
| 4:00 PM | Massage - Fusion, Couples | 0.5 | $ 150.00 | ||
| 4:30 PM | 0 | $ - 0 | |||
| 5:00 PM | Aroma & Sound Therapy Package | 0.5 | $ 125.00 | ||
&F Copyright © 2014 Pearson Education, Inc. Publishing as Prentice Hall
Niese
| Turquoise Oasis Spa | |||||
| A Passion for Helping People Relax | |||||
| 5/16/22 | |||||
| Time | Service | Hours | Charge/Hour | Total Charges | Running Total |
| 8:30 AM | Massage - Shiatsu | 0.5 | $ 125.00 | ||
| 9:00 AM | Mud Bath | 1 | $ 100.00 | ||
| 9:30 AM | Aroma & Sound Therapy Package | 0.5 | $ 125.00 | ||
| 10:00 AM | 0 | $ - 0 | |||
| 10:30 AM | Massage - Deep Tissue | 1 | $ 100.00 | ||
| 11:00 AM | 0 | $ - 0 | |||
| 11:30 AM | Reflexology | 0.5 | $ 150.00 | ||
| 12:00 PM | Body Detox Electrotherapy | 0.5 | $ 150.00 | ||
| 12:30 PM | 0 | $ - 0 | |||
| 1:00 PM | Steam Bath | 0.5 | $ 65.00 | ||
| 1:30 PM | Aroma & Sound Therapy Package | 0.5 | $ 125.00 | ||
| 2:00 PM | Massage - Fusion | 1 | $ 125.00 | ||
| 2:30 PM | 0 | $ - 0 | |||
| 3:00 PM | Tibetan Reiki Therapy | 1.5 | $ 200.00 | ||
| 3:30 PM | 0 | $ - 0 | |||
| 4:00 PM | 0 | $ - 0 | |||
| 4:30 PM | Massage - Shiatsu | 1 | $ 125.00 | ||
| 5:00 PM | Massage - Shiatsu | 1 | $ 125.00 | ||
&F Copyright © 2014 Pearson Education, Inc. Publishing as Prentice Hall
HoursSummary
| Turquoise Oasis Spa | ||
| A Passion for Helping People Relax | ||
| 5/16/22 | ||
| Time | Hours | Total Charges |
| 8:30 AM | ||
| 9:00 AM | ||
| 9:30 AM | ||
| 10:00 AM | ||
| 10:30 AM | ||
| 11:00 AM | ||
| 11:30 AM | ||
| 12:00 PM | ||
| 12:30 PM | ||
| 1:00 PM | ||
| 1:30 PM | ||
| 2:00 PM | ||
| 2:30 PM | ||
| 3:00 PM | ||
| 3:30 PM | ||
| 4:00 PM | ||
| 4:30 PM | ||
| 5:00 PM | ||
| Total | 0 | $ - 0 |
&F Copyright © 2014 Pearson Education, Inc. Publishing as Prentice Hall
ChargesSummary
| Turquoise Oasis Spa | ||
| A Passion for Helping People Relax | ||
| 5/16/22 | ||
| Time | Total Charges | Running Total |
| 8:30 AM | ||
| 9:00 AM | ||
| 9:30 AM | ||
| 10:00 AM | ||
| 10:30 AM | ||
| 11:00 AM | ||
| 11:30 AM | ||
| 12:00 PM | ||
| 12:30 PM | ||
| 1:00 PM | ||
| 1:30 PM | ||
| 2:00 PM | ||
| 2:30 PM | ||
| 3:00 PM | ||
| 3:30 PM | ||
| 4:00 PM | ||
| 4:30 PM | ||
| 5:00 PM | ||
| Total | ||
&F Copyright © 2014 Pearson Education, Inc. Publishing as Prentice Hall
ServiceSummary
| Turquoise Oasis Spa | ||
| A Passion for Helping People Relax | ||
| 5/16/22 | ||
| $ - 0 | ||
&F Copyright © 2014 Pearson Education, Inc. Publishing as Prentice Hall
ChargesSummaryLinked
| Turquoise Oasis Spa |
| A Passion for Helping People Relax |
| 5/16/22 |
&F Copyright © 2014 Pearson Education, Inc. Publishing as Prentice Hall
PriceList
| Product | Location | Price | Unit |
| Facial - Mud & Citrus | Salon | $ 75.00 | Each |
| Facial - Steam Exfoliation | Salon | $ 75.00 | Each |
| Hair Coloring | Salon | $ 100.00 | Each |
| Hair Style & Cut - Men | Salon | $ 35.00 | Each |
| Hair Style & Cut - Women | Salon | $ 50.00 | Each |
| Makeup Consultation | Salon | $ 75.00 | Each |
| Manicure & Pedicure Package | Salon | $ 50.00 | Each |
| Manicure & Polish | Salon | $ 35.00 | Each |
| Pedicure & Polish | Salon | $ 35.00 | Each |
| Waxing - Body | Salon | $ 60.00 | Each |
| Waxing - Facial | Salon | $ 25.00 | Each |
| Aroma & Sound Therapy Package | Spa | $ 125.00 | Hour |
| Aroma Therapy | Spa | $ 75.00 | Hour |
| Body Detox Electrotherapy | Spa | $ 150.00 | Hour |
| Body Detox Steam Therapy | Spa | $ 100.00 | Hour |
| Massage - Deep Tissue | Spa | $ 100.00 | Hour |
| Massage - Deep Tissue, Couples | Spa | $ 90.00 | Hour |
| Massage - Fusion | Spa | $ 125.00 | Hour |
| Massage - Fusion, Couples | Spa | $ 150.00 | Hour |
| Massage - Shiatsu | Spa | $ 125.00 | Hour |
| Mud Bath | Spa | $ 100.00 | Hour |
| Reflexology | Spa | $ 150.00 | Hour |
| Sound Therapy | Spa | $ 75.00 | Hour |
| Steam Bath | Spa | $ 65.00 | Hour |
| Tibetan Reiki Therapy | Spa | $ 200.00 | Hour |
&F Copyright © 2014 Pearson Education, Inc. Publishing as Prentice Hall
SpaSales
| Date | Appointment | Therapist | Service | Duration |
| 5/16/22 | 8:00 AM | Istas, Christy | Massage - Deep Tissue | 1 |
| 5/16/22 | 8:30 AM | Istas, Christy | 0 | |
| 5/16/22 | 9:00 AM | Istas, Christy | Body Detox Steam Therapy | 2 |
| 5/16/22 | 9:30 AM | Istas, Christy | 0 | |
| 5/16/22 | 10:00 AM | Istas, Christy | 0 | |
| 5/16/22 | 10:30 AM | Istas, Christy | 0 | |
| 5/16/22 | 11:00 AM | Istas, Christy | Massage - Shiatsu | 1 |
| 5/16/22 | 11:30 AM | Istas, Christy | 0 | |
| 5/16/22 | 5:00 PM | Istas, Christy | 0 | |
| 5/16/22 | 5:30 PM | Istas, Christy | Sound Therapy | 1 |
| 5/16/22 | 1:00 PM | Istas, Christy | 0 | |
| 5/16/22 | 1:30 PM | Istas, Christy | Tibetan Reiki Therapy | 2 |
| 5/16/22 | 2:00 PM | Istas, Christy | 0 | |
| 5/16/22 | 2:30 PM | Istas, Christy | 0 | |
| 5/16/22 | 3:00 PM | Istas, Christy | 0 | |
| 5/16/22 | 3:30 PM | Istas, Christy | Massage - Fusion, Couples | 0.5 |
| 5/16/22 | 4:00 PM | Istas, Christy | 0 | |
| 5/16/22 | 4:30 PM | Istas, Christy | 0 | |
| 5/16/22 | 8:00 AM | Mault, Kendra | Massage - Deep Tissue | 0.5 |
| 5/16/22 | 8:30 AM | Mault, Kendra | Mud Bath | 1 |
| 5/16/22 | 9:00 AM | Mault, Kendra | 0 | |
| 5/16/22 | 9:30 AM | Mault, Kendra | Body Detox Electrotherapy | 0.5 |
| 5/16/22 | 10:00 AM | Mault, Kendra | Body Detox Steam Therapy | 0.5 |
| 5/16/22 | 10:30 AM | Mault, Kendra | 0 | |
| 5/16/22 | 11:00 AM | Mault, Kendra | Sound Therapy | 1 |
| 5/16/22 | 11:30 AM | Mault, Kendra | 0 | |
| 5/16/22 | 5:00 PM | Mault, Kendra | 0 | |
| 5/16/22 | 5:30 PM | Mault, Kendra | 0 | |
| 5/16/22 | 1:00 PM | Mault, Kendra | Tibetan Reiki Therapy | 1 |
| 5/16/22 | 1:30 PM | Mault, Kendra | 0 | |
| 5/16/22 | 2:00 PM | Mault, Kendra | Massage - Shiatsu | 1 |
| 5/16/22 | 2:30 PM | Mault, Kendra | 0 | |
| 5/16/22 | 3:00 PM | Mault, Kendra | 0 | |
| 5/16/22 | 3:30 PM | Mault, Kendra | Massage - Fusion, Couples | 0.5 |
| 5/16/22 | 4:00 PM | Mault, Kendra | 0 | |
| 5/16/22 | 4:30 PM | Mault, Kendra | Aroma & Sound Therapy Package | 0.5 |
| 5/16/22 | 8:00 AM | Niese, Jason | Massage - Shiatsu | 0.5 |
| 5/16/22 | 8:30 AM | Niese, Jason | Mud Bath | 1 |
| 5/16/22 | 9:00 AM | Niese, Jason | Aroma & Sound Therapy Package | 0.5 |
| 5/16/22 | 9:30 AM | Niese, Jason | 0 | |
| 5/16/22 | 10:00 AM | Niese, Jason | Massage - Deep Tissue | 1 |
| 5/16/22 | 10:30 AM | Niese, Jason | 0 | |
| 5/16/22 | 11:00 AM | Niese, Jason | Reflexology | 0.5 |
| 5/16/22 | 11:30 AM | Niese, Jason | Body Detox Electrotherapy | 0.5 |
| 5/16/22 | 5:00 PM | Niese, Jason | 0 | |
| 5/16/22 | 5:30 PM | Niese, Jason | Steam Bath | 0.5 |
| 5/16/22 | 1:00 PM | Niese, Jason | Aroma & Sound Therapy Package | 0.5 |
| 5/16/22 | 1:30 PM | Niese, Jason | Massage - Fusion | 1 |
| 5/16/22 | 2:00 PM | Niese, Jason | 0 | |
| 5/16/22 | 2:30 PM | Niese, Jason | Tibetan Reiki Therapy | 1.5 |
| 5/16/22 | 3:00 PM | Niese, Jason | 0 | |
| 5/16/22 | 3:30 PM | Niese, Jason | 0 | |
| 5/16/22 | 4:00 PM | Niese, Jason | Massage - Shiatsu | 1 |
| 5/16/22 | 4:30 PM | Niese, Jason | Massage - Shiatsu | 1 |
&F Copyright © 2014 Pearson Education, Inc. Publishing as Prentice Hall
