computer science 5
Dominica
SC_Excel2013_C1_P1a_DominicaEsonoNseng_11.xlsxDocumentation
| Shelly Cashman Excel 2013 | |
| Chapter 1: SAM Project 1a | |
| Flex Cab Company | |
| 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. | |
Pickup Analysis
| Area | 2012 | 2013 | 2014 | 2015 | 2016 |
| Downtown | 20574 | 22856 | 23686 | 27958 | |
| North of Downtown | 10123 | 11582 | 13058 | 15025 | |
| South of Downtown | 7294 | 8184 | 8245 | 8624 | |
| East of Downtown | 5591 | 5312 | 5883 | 6121 | |
| West of Downtown | |||||
| Total | |||||
| On-time Pickup Percentages | |||||
| Area | 2012 | 2013 | 2014 | 2015 | |
| Downtown | 60.6% | 62.3% | 71.5% | 84.6% | |
| North of Downtown | 50.2% | 55.1% | 63.9% | 73.2% | |
| South of Downtown | 23.8% | 28.9% | 49.6% | 65.1% | |
| East of Downtown | 57.1% | 60.4% | 68.8% | 72.2% | |
| West of Downtown | 66.0% | 68.9% | 72.5% | 79.8% |
Number of Pickups
2012 Downtown North of Downtown South of Downtown East of Downtown West of Downtown Total 20574 10123 7294 5591 2013 Downtown North of Downtown South of Downtown East of Downtown West of Downtown Total 22856 11582 8184 5312 2014 Downtown North of Downtown South of Downtown East of Downtown West of Downtown Total 23686 13058 8245 5883 2015 Downtown North of Downtown South of Downtown East of Downtown West of Downtown Total 27958 15025 8624 6121
On-Time Pickup Percentages in 2015
2015 Downtown North of Downtown South of Downtown East of Downtown West of Downtown 0.84599999999999997 0.73199999999999998 0.65100000000000002 0.72199999999999998 0.7980000000 0000004
