Jump to content

Attention: In order to reply to messages, create topics, have access to other features of the community you must sign up for an account.
Sign in to follow this  
TheSubwayStation

Subway Travel Time Charts

Recommended Posts

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 (D) 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

  • Upvote 4

Share this post


Link to post
Share on other sites

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))

 

  • Upvote 1

Share this post


Link to post
Share on other sites

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...

Share this post


Link to post
Share on other sites

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.

Share this post


Link to post
Share on other sites

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...

  • Upvote 1

Share this post


Link to post
Share on other sites

Unfortunately, that's not working for me...

 

 

Well use Excel and take a screenshot...

Share this post


Link to post
Share on other sites

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.

Edited by Amtrak7
  • Upvote 1

Share this post


Link to post
Share on other sites

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.

Share this post


Link to post
Share on other sites

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

Share this post


Link to post
Share on other sites

I'm working on these lines:

 

(1)(3)(B)(C)(G)(H)(L)(M)

 

The other ones have so many variants I don't know how to approach them...what variant is that (4)?

 

Thanks for that site, I forgot about it. Are you rounding up or down?

Edited by Amtrak7

Share this post


Link to post
Share on other sites

The other ones have so many variants I don't know how to approach them...what variant is that (4)?

 

It's Utica Av - Woodlawn, express in Brooklyn and Manhattan, and stops at 138 St-Grand Concourse. It's the typical off-peak northbound (4) schedule.

Share this post


Link to post
Share on other sites

The rounding errors really add up. For the (3)(C)(G) the added time is 5 minutes more than schedule.

Edited by Amtrak7

Share this post


Link to post
Share on other sites

Join the conversation

You can post now and register later. If you have an account, sign in now to post with your account.

Guest
Reply to this topic...

×   Pasted as rich text.   Restore formatting

  Only 75 emoji are allowed.

×   Your link has been automatically embedded.   Display as a link instead

×   Your previous content has been restored.   Clear editor

×   You cannot paste images directly. Upload or insert images from URL.

Sign in to follow this  


×
×
  • Create New...

Important Information

By using this site, you agree to our Terms of Use.