Part II – Subway You run a subway. Look at “Her.xlsx”. This has data on how many
ID: 3300143 • Letter: P
Question
Part II – Subway
You run a subway. Look at “Her.xlsx”. This has data on how many people get on and off each stop. For instance, in total, 259 people get on at Times Square (the sum of row 5), and 30 get off at 34th street, 40 get off at 28th street, and so on. Also, in total, 165 people are getting off on Canal. This is a southbound train and runs only in one direction (starting at Times Square).
Assume 50 people fit on a train car. How many southbound train cars to you need to carry all the people at the route’s most crowded? Turn in 2 versions of your spreadsheet. Remember, you spreadsheet should be flexible enough that if new data comes to light, you can easily type this new data in the spreadsheet and the number of subway cars will be automatically updated.
You may find of use a function called “CEILING.MATH” to convert the fractional number of subway cars needed into whole cars. Use google or Excel help to learn about this function. (“FLOOR.MATH” is its complement).
This is the shareable link for this question: https://drive.google.com/file/d/0B4gY0toGAj-IWndncS16M3BkV1U/view?usp=sharing
Explanation / Answer
Answer -
Calculate the following -
Make sure passengers in the train at Rector street comes out equal to passengers that get down at South Ferry.
Then the Train cars required at it's most crowded point is - 24 for sheet 1
Similarily for sheet 2, just copy paste the value in the excel sheet with formulae -
And number of train cars required is calculated as - 478
Destination Stop Passengers in the train at each station Times Square – 42nd Street 34th Street – Penn Station 28th Street 23rd Street 18th Street 14th Street Christopher Street – Sheridan Square Houston Street Canal Street Franklin Street Chambers Street Cortlandt Street Rector Street South Ferry Total number of passenger hopping inside at each station Origin Stop Times Square – 42nd Street 259 30 40 11 30 19 24 23 2 32 3 32 7 6 259 34th Street – Penn Station 259 +263 -30 492 9 12 13 4 33 35 10 45 30 32 5 35 263 28th Street 492 +302 - 49 745 22 28 7 45 43 34 29 40 2 45 7 302 23rd Street 745 +269 - 45 969 24 9 29 6 37 17 26 27 45 49 269 18th Street and so on 1051 31 5 6 23 47 5 11 2 47 177 14th Street 1192 22 10 36 40 8 15 30 50 211 Christopher Street – Sheridan Square 1127 10 8 5 9 46 13 2 93 Houston Street 1148 15 15 18 42 31 33 154 Canal Street 1177 23 48 47 29 47 194 Franklin Street 1044 27 42 3 48 120 Chambers Street 935 21 38 46 105 Cortlandt Street 649 3 28 31 Rector Street 432 34 34 Total number of passenger getting down at each station 30 49 45 95 70 158 133 165 253 214 317 251 432