excel need now
Philicia
SC_EX16_CS1-3a_RoCocoDevereaux_13.xlsxDocumentation
| Shelly Cashman Excel 2016 | Modules 1–3: SAM Capstone Project 1a | |
| Campus Fitness Center | |
| MODIFY A SERVICE REPORT AND CREATE A CHART | |
| Author: | RoCoco Devereaux |
| 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] |
