TheSubwayStation Posted August 18, 2012 Share #1 Posted August 18, 2012 Recently, I came up with the idea to make a new type of schedule format based on the MTA's schedules. The MTA apparently used to print this kind of chart during the 1990s. The purpose of it is to let you easily figure out how long it would take to travel from one station to another station anywhere on a subway line. I started working on one for the line: https://docs.google....dJRWFQZHc#gid=0 What do you guys think of this idea? It seems pretty good, but it's really time-consuming to type in a different formula for every single cell of the spreadsheet. Is there anyone who's experienced with spreadsheets and could tell me an easier formula that applies to more than one cell at a time? Or does none exist? Thanks, TSS Link to comment Share on other sites More sharing options...
Quill Depot Posted August 18, 2012 Share #2 Posted August 18, 2012 I don't think one exists. Good job though. Link to comment Share on other sites More sharing options...
Amtrak7 Posted August 18, 2012 Share #3 Posted August 18, 2012 There is an easier way...put in all the constants then put the formula below in A3, then copy paste to all the other variable cells and Excel should do the rest for you. Note that if A1 is not the first station name then things get really complicated. =A2+INDIRECT(ADDRESS(ROW(A3),ROW(A3)-1)) Link to comment Share on other sites More sharing options...
N4 Via Merrick Rd Posted August 18, 2012 Share #4 Posted August 18, 2012 Good job. for a minute i didn't know how to read this. Link to comment Share on other sites More sharing options...
TheSubwayStation Posted August 18, 2012 Author Share #5 Posted August 18, 2012 There is an easier way...put in all the constants then put the formula below in A3, then copy paste to all the other variable cells and Excel should do the rest for you. Note that if A1 is not the first station name then things get really complicated. =A2+INDIRECT(ADDRESS(ROW(A3),ROW(A3)-1)) THANK YOU! I'll try that out...Does that code also work for Google Docs Spreadsheets (which I was using)? If not, I think I have Excel on my computer... Link to comment Share on other sites More sharing options...
Amtrak7 Posted August 18, 2012 Share #6 Posted August 18, 2012 THANK YOU! I'll try that out...Does that code also work for Google Docs Spreadsheets (which I was using)? If not, I think I have Excel on my computer... Not a clue, I only use Google Docs as a hosting service and never make non-visual edits on it. Link to comment Share on other sites More sharing options...
Amtrak7 Posted August 18, 2012 Share #7 Posted August 18, 2012 I did the ...rounded to the nearest minute as every trip has a few second's worth of runtime variation. https://docs.google.com/spreadsheet/ccc?key=0AlGvV8zOxI2SdG5YWHF1U2FsaWhrdmpmTHM2ckVKSFE Link to comment Share on other sites More sharing options...
TheSubwayStation Posted August 18, 2012 Author Share #8 Posted August 18, 2012 I see. So even if I use your code, I'll have to modify the code for each cell? My hope was that I could be able to paste the same code into each variable cell. Link to comment Share on other sites More sharing options...
Amtrak7 Posted August 18, 2012 Share #9 Posted August 18, 2012 I see. So even if I use your code, I'll have to modify the code for each cell? My hope was that I could be able to paste the same code into each variable cell. No...Excel should modify the "A2" and "A3" automatically for you if you copy and paste... Link to comment Share on other sites More sharing options...
TheSubwayStation Posted August 18, 2012 Author Share #10 Posted August 18, 2012 No...Excel should modify the "A2" and "A3" automatically for you if you copy and paste... Unfortunately, that's not working for me... Link to comment Share on other sites More sharing options...
Threxx Posted August 18, 2012 Share #11 Posted August 18, 2012 Unfortunately, that's not working for me... Well use Excel and take a screenshot... Link to comment Share on other sites More sharing options...
Amtrak7 Posted August 18, 2012 Share #12 Posted August 18, 2012 Unfortunately, that's not working for me... Paste the formula into A3, then copy and paste A3. If you copy and paste the formula straight in to other cells it won't work. Link to comment Share on other sites More sharing options...
TheSubwayStation Posted August 18, 2012 Author Share #13 Posted August 18, 2012 Paste the formula into A3, then copy and paste A3. If you copy and paste the formula straight in to other cells it won't work. IT'S WORKING! Thank you so much. Link to comment Share on other sites More sharing options...
TheSubwayStation Posted August 18, 2012 Author Share #14 Posted August 18, 2012 Okay, here's the final version of the train time chart: Spreadsheet Version: https://docs.google....FfcThkcXc#gid=0 PDF Version: https://docs.google....LW9RanRSN0c1U2M I'm going to start making more now that Amtrak7's code has made it so much easier . Link to comment Share on other sites More sharing options...
TheSubwayStation Posted August 18, 2012 Author Share #15 Posted August 18, 2012 Updated PDF (bigger text, easier to read): https://docs.google.com/open?id=0B2SOSjyroaotd1AwQ1ZVN0dzeTg Link to comment Share on other sites More sharing options...
Amtrak7 Posted August 18, 2012 Share #16 Posted August 18, 2012 Where did you get the times from? I got them from the GTFS, but it gives them down to the second and they vary by time of day. Link to comment Share on other sites More sharing options...
TheSubwayStation Posted August 18, 2012 Author Share #17 Posted August 18, 2012 I got the times from this website: http://boerumhillscott.com/transit/index.php I'm almost 100 percent confident that this site gets its info from GTFS, though. Yes, schedules do vary depending on time of day. Rush hour travel times are longer. My charts are based on early morning schedules from around 6:00 to 7:00 AM. BTW, I'll be keeping all of my completed charts in this folder, so you can check this for updates: https://docs.google.com/folder/d/0B2SOSjyroaotczNxZy1KY3c5akU/edit?pli=1 Link to comment Share on other sites More sharing options...
Amtrak7 Posted August 18, 2012 Share #18 Posted August 18, 2012 I'm working on these lines: The other ones have so many variants I don't know how to approach them...what variant is that ? Thanks for that site, I forgot about it. Are you rounding up or down? Link to comment Share on other sites More sharing options...
TheSubwayStation Posted August 18, 2012 Author Share #19 Posted August 18, 2012 The other ones have so many variants I don't know how to approach them...what variant is that ? It's Utica Av - Woodlawn, express in Brooklyn and Manhattan, and stops at 138 St-Grand Concourse. It's the typical off-peak northbound schedule. Link to comment Share on other sites More sharing options...
Amtrak7 Posted August 18, 2012 Share #20 Posted August 18, 2012 The rounding errors really add up. For the the added time is 5 minutes more than schedule. Link to comment Share on other sites More sharing options...
TheSubwayStation Posted August 18, 2012 Author Share #21 Posted August 18, 2012 Thanks for that site, I forgot about it. Are you rounding up or down? I'm trying to round half up and half down. It's kind of a challenge, but it makes it accurate. Link to comment Share on other sites More sharing options...
RestrictOnTheHanger Posted August 19, 2012 Share #22 Posted August 19, 2012 Nicely done. The MTA should print charts like this again, though they wouldn't be 100% accurate during GOs. Link to comment Share on other sites More sharing options...
Recommended Posts
Archived
This topic is now archived and is closed to further replies.