• Hi All

    Please note that at the Chandoo.org Forums there is Zero Tolerance to Spam

    Post Spam and you Will Be Deleted as a User

    Hui...

  • When starting a new post, to receive a quicker and more targeted answer, Please include a sample file in the initial post.

Anyone attempted to create this using Excel ?

pacochin

New Member
Hi,

For those who are familiar with Edward Tufte book, he talked about this interesting visualization example of a Paris Train Schedule by E.J. Marey.


http://c82.net/posts.php?id=66


Wonder if we can re-create this in Excel ?
 

SirJB7

Excel Rōnin
Hi, pacochin!

I immediately loved this chart. I'm gonna give it a try as an exercise this week.

Still interested on it?

Regards.
 

Hui

Excel Ninja
Staff member
Pacochin

It can be done as an Excel Scatter Chart

do you have a set of data which is applicable ?
 

SirJB7

Excel Rōnin
Hi, pacochin!

Bet you wanna take a look at this:

http://www.2shared.com/file/SGRD32VT/Railroad_chart_from_Edward_Tuf.html

As you posted, I don't know if anyone had attempted to do this in Excel... but I tried.

Just as an exercise, it was funny, specially Excel metrics where I had to make a couple of tricky things (that origined a new topic as well). Check out the VBA code.

Hope you enjoy it.

Regards!


EDIT: 23/08/2012


Hi!

New download link since 2shared became erratically available:

https://dl.dropbox.com/u/60558749/Railroad%20chart%20from%20Edward%20Tufte%20book%20%28for%20pacochin%20at%20chandoo.org%29.xlsm

Regards!
 

rougeux

New Member
Hi everyone. I'm the author of that blog post mentioned above (thanks for visiting) and I'm looking for the Excel file created by SirJB7. I'm interested in seeing what's possible when trying to create train schedules like this in Excel. Does anyone have the file?


Nick
 

Hui

Excel Ninja
Staff member
Hi Nick


Firstly, Welcome to the Chandoo.org forums.


I don't believe anybody ever tackled it as no data was ever posted


Hui...
 

NARAYANK991

Excel Ninja
Hi Nick ,


With apologies to the author ( Pablo , aka SirJB7 ) , download it from here :


http://speedy.sh/CyCnb/Railroad-chart-from-Edward-Tufte-book-for-pacochin-at-chandoo.org.xlsm


Narayan
 

SirJB7

Excel Rōnin
Hi, rougeux!


I edited my previous comment with a new working and permanent link to the related file.


Within the workbook you'll find a sample schedule file from a local railway branch that passes near my home. The data source is originally a PDF file which has been copied and pasted. If you have another input source or design just get back to me and we'll see.


Please just advise if any issue.


Regards!
 

SirJB7

Excel Rōnin
@NARAYANK991

Hi, Narayan!

Thanks for helping people find my old uploaded files, yesterday I had many issues like that with 2shared and 4shared. I'm moving them to DropBox as they're required.

Regards!
 

rougeux

New Member
Thanks both of you, Narayan and SirJB7. I appreciate you making the file available. I was able to download it just fine. It looks to be a lot more complicated than I expected!
 

SirJB7

Excel Rōnin
Hi, rougeux!

Yes, it's been a nice and interesting exercise. Nice and interesting implies hard as the hell sine qua non. But you yet know, just advise if any issue.

Regards!
 

SirJB7

Excel Rōnin
Hi, delvillardennis!


Thank you for your kind words and glad to hear you liked it, ask me if you got stuck with something.


But there's no need to dig up so deep your Spanish dictionary as:

a) worksheet "Instrucciones" (Instructions) is both in Spanish and English

b) worksheet "Estaciones" (Stations), just 10 column headers (2 groups of 2 by 2 options + 2)

c) worksheet "Horarios" (Schedule), just 5 column headers, all the rest are station names

d) worksheet "Parametros" (Parameters), 4 column headers, 8 values and 8 descriptions

e) worksheet "Diagrama" (Diagram), nothing at all :)

f) VBA project uses English, ok, the names, not any problem if done all previous


Regards!
 
Top