i have homework in Excel and i need help
mustafa88sc_ex16_cs1-3a_alyasalawam_1_1.xlsx
Documentation
Shelly Cashman Excel 2016 | Modules 1–3: SAM Capstone Project 1a | |
Campus Fitness Center | |
MODIFY A SERVICE REPORT AND CREATE A CHART | |
Author: | alyas alawam |
Note: Do not edit this sheet. If your name does not appear in cell B6, please download a new copy of the file from the SAM website. | |
Class Statistics
Campus Athletic Center | ||||||||||||
43439 | ||||||||||||
Class Prices | ||||||||||||
Spring Semester | ||||||||||||
Fall Semester | Summer Break | |||||||||||
Class Attendance | September | |||||||||||
Cardio Boot Camp | 67.00 | 67.00 | 72.00 | 81.00 | 62.00 | 62.00 | 100.00 | 76.00 | 107.00 | 69.00 | 27.00 | 38.00 |
Hip-Hop | 92.00 | 80.00 | 106.00 | 76.00 | 49.00 | 79.00 | 119.00 | 106.00 | 120.00 | 89.00 | 35.00 | 33.00 |
Spining | 106.00 | 93.00 | 99.00 | 88.00 | 61.00 | 119.00 | 88.00 | 102.00 | 81.00 | 98.00 | 48.00 | 21.00 |
Yoga | 65.00 | 92.00 | 95.00 | 78.00 | 110.00 | 115.00 | 110.00 | 62.00 | 97.00 | 108.00 | 21.00 | 37.00 |
Zumba | 102.00 | 80.00 | 96.00 | 69.00 | 93.00 | 117.00 | 93.00 | 103.00 | 116.00 | 114.00 | 27.00 | 44.00 |
Total Attendees | ||||||||||||
Revenue: Cardio Boot Camp | ||||||||||||
Revenue: Hip-Hop | 0.00 | 0.00 | 0.00 | 0.00 | 0.00 | 0.00 | 0.00 | 0.00 | 0.00 | 0.00 | 0.00 | 0.00 |
Revenue: Spinning | 0.00 | 0.00 | 0.00 | 0.00 | 0.00 | 0.00 | 0.00 | 0.00 | 0.00 | 0.00 | 0.00 | 0.00 |
Revenue: Yoga | ||||||||||||
Revenue: Zumba | ||||||||||||
Total Revenue | 0.00 | 0.00 | 0.00 | 0.00 | 0.00 | 0.00 | 0.00 | 0.00 | 0.00 | 0.00 | 0.00 | 0.00 |
Average attnedance per month | 86 | 82 | 94 | 78 | 75 | 98 | 102 | 90 | 104 | 96 | 32 | 35 |
Average revenue per month | ||||||||||||
Maximum revenue | ||||||||||||
Minimum revenue | ||||||||||||
Revenue Rank | ||||||||||||
Spring Semester Spinning Attendance |
Personal Trainers
Personal Trainers | |||||
Slot # | Day | Time | Trainer | Code | Extension |
1 | Monday | 9a-11a | Noah Thedford | Mon-9:11-NoTh | x3344 |
2 | Monday | 11a-1p | Loren Wade | x5411 | |
3 | Monday | 1p-3p | Janina Lopez | x1289 | |
4 | Tuesday | Bobby Dixon | x1799 | ||
5 | Tuesday | Jonah Moss | x5900 | ||
6 | Tuesday | Janina Lopez | x1289 | ||
7 | Wednesday | Noah Thedford | x3344 | ||
8 | Wednesday | Michele Macy | x8122 | ||
9 | Wednesday | Bobby Dixon | x1799 | ||
10 | Thursday | Randy Hodgkins | x4190 | ||
11 | Thursday | Loren Wade | x5411 | ||
12 | Thursday | Michele Macy | x8122 | ||
13 | Friday | Randy Hodgkins | x4190 | ||
14 | Friday | Loren Wade | x5411 | ||
15 | Friday | Michele Macy | x8122 |
Physical Therapists
Physical Therapists | ||||||||
Company | Contact First Name | Contact Last Name | Street Address | City | State | Zip | Phone Number | Email Address |
A-OK Physical Therapy | Jeremy | Grisby | 1503 Seaview Lane | Seattle | WA | 98102 | 206-555-3367 | [email protected] |
A-OK Physical Therapy | Shaunda | Cleary | 1503 Seaview Lane | Seattle | WA | 98102 | 206-555-3367 | [email protected] |
Right On Track PT | Carey | Demay | 1203 Elm Street | Tacoma | WA | 98402 | 253-555-1809 | [email protected] |
Earl Herod Physical Therapy | Earl | Herod | 1800 Pacific Avenue | Seattle | WA | 98105 | 206-555-1789 | [email protected] |
Central Physical Therapy | Elly | Nichol | 30 Western Boulevard | Everett | WA | 98201 | 425-555-1823 | [email protected] |