computer science 7
Dominica
SC_Excel2013_CS_C1-3_P1a_DominicaEsonoNseng_1.xlsxDocumentation
| Shelly Cashman Excel 2013 | |
| Chapters 1-3: SAM Capstone Project 1a | |
| Island Recycling | |
| MODIFY A SERVICE REPORT AND CREATE A CHART | |
| Author: | Dominica Esono Nseng |
| 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. | |
Statistics
| Fir Recycling | ||||||||||||
| 12/28/16 | ||||||||||||
| Bin Prices | ||||||||||||
| Quarter 2 | ||||||||||||
| Quarter 1 | Quarter 3 | Quarter 4 | ||||||||||
| Number of Bins | January | |||||||||||
| Retunable bottles/cans | 40 | 25 | 21 | 23 | 60 | 78 | 91 | 121 | 50 | 26 | 10 | 61 |
| Plastic containers/bags | 15 | 13 | 16 | 16 | 15 | 18 | 24 | 28 | 16 | 13 | 4 | 12 |
| Mixed paper | 15 | 13 | 16 | 21 | 16 | 27 | 5 | 11 | 26 | 50 | 21 | 60 |
| Glass | 5 | 2 | 1 | 3 | 3 | 4 | 6 | 8 | 2 | 1 | 1 | 3 |
| Total Bins | ||||||||||||
| Revenue: Bottles/Cans | ||||||||||||
| Revenue: Plastics | ||||||||||||
| Revenue: Mixed Paper | ||||||||||||
| Revenue: Glass | ||||||||||||
| Total Revenue | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 |
| Average bins per month | 19 | 13 | 13 | 16 | 23 | 32 | 31 | 42 | 23 | 22 | 9 | 34 |
| Avrage revenue per month | ||||||||||||
| Maximum revenue | ||||||||||||
| Minimum revenue | ||||||||||||
| Revenue Rank | ||||||||||||
| Quarter 3 Glass | ||||||||||||
Volunteer Educators
| Volunteer Educators | ||||
| Slot # | Day | Time | Volunteer | Phone Number |
| 1 | Thursday | 9:00 to 11:00 | John Courtney | 206-555-3344 |
| 2 | 11:00 to 1:00 | Mary Marshal | 206-555-5411 | |
| 1:00 to 3:00 | Sharon Nelson | 206-555-1289 | ||
| Friday | Rick Lamark | 206-555-1799 | ||
| Glenn Vazquez | 206-555-5900 | |||
| Sharon Nelson | 206-555-1289 | |||
| Saturday | 9:00 to 11:00 | John Courtney | 206-555-3344 | |
| 11:00 to 1:00 | Christie Shea | 206-555-3901 | ||
| 1:00 to 3:00 | Bree Shea | 206-555-3901 | ||
| Sunday | Randy Hodgkins | 206-555-4190 | ||
| Mary Marshal | 206-555-5411 | |||
| Charmaine Lobb | 206-555-8122 |
Recycling Companies
| Service Companies | ||||||||||
| Company | Contact First Name | Contact Last Name | Street Address | City | State | Zip | Phone Number | Email Address | Category | Delivery Day |
| Waste Not | Jocelyn | Grisby | 1503 Seaview Lane | Seattle | WA | 98102 | 206-555-3367 | [email protected] | Glass | Wednesday |
| Waste Not | Sammy | Cleary | 1503 Seaview Lane | Seattle | WA | 98102 | 206-555-3367 | [email protected] | Metal | Thursday |
| Markham Waste Distributors | Carmen | Demay | 1203 Elm Street | Tacoma | WA | 98402 | 253-555-1809 | [email protected] | Mixed Paper | Thursday |
| North Shore Recycling | Earl | Herod | 1800 Pacific Avenue | Seattle | WA | 98105 | 206-555-1789 | [email protected] | Electronics | Friday |
| Mariposa Recycling and Waste Management Depot | Elly | Hardwick | 30 Western Boulevard | Everett | WA | 98201 | 425-555-1823 | [email protected] | Mixed Paper | Monday |
