Computerised train graphs

 
  DavidB Moderator

Location: Canberra
We went down the scatter plot path in 2003 and it wasn't satisfactory for the reasons already stated. If you can exactly reproduce this train graph I posted, then we'll revisit Excel.



Try it without the train lines first. I'd like to know how to display the Y axis gridlines at anything other than fixed intervals.

Cheers
David

Sponsored advertisement

  DavidB Moderator

Location: Canberra
Actually start with something simpler, an actual example from my 1979 Southern Division WTT. Here it is in tabular form.

 Dist                      467
from                      Exp
Sydney                     Frt

485.670  Junee        arr  4 31
                     dep  4 41
497.612  Harefield    arr  4 54
                     dep  5 04
504.614  Shepherd's
513.691  Bomen        arr  
                     dep  5 17
521.160  Wagga Wagga  arr  
                     dep  5 23


                 468
                 Exp
                 Frt

Wagga Wagga  arr  
            dep  4 40
Bomen        arr  
            dep  4 48
Shepherd's
Harefield    arr
            dep  5 01
Junee        arr  5 14
            dep  5 24


See if you can plot that and make it look exactly like the train graph.

Cheers
David
  sarailway Station Master

Done it using an X-Y scatterplot as I had suggested.

Dead easy..... BUT I see no easy way to input station names. If I had more time I could figure it out. Also, I do not know of any functionality where you can have the grid lines on the the Y-axis (or the X-axis for that matter) at an irregular interval.

PM me with your e-mail address and I'll send you the spreadsheet i did of your tabular data. It took me about five minutes to do.

Cheers
  DavidB Moderator

Location: Canberra
Done it using an X-Y scatterplot as I had suggested.

Dead easy..... BUT I see no easy way to input station names. If I had more time I could figure it out. Also, I do not know of any functionality where you can have the grid lines on the the Y-axis (or the X-axis for that matter) at an irregular interval.
"sarailway"

Precisely. You've to exactly the same point we did in 2003 before abandoning Excel. Smile

Cheers
David
  sarailway Station Master

David,

I have reviewed all of your posts on this tread. I believe that in fact I am ahead of your 2003 status. I have put together a basic timetable using excel that I believe is at least a 90% solution to what you want.

Since my last post I have subsequently solved the station name issue. Also pretty easy as it turns out.

The only thing I seem unable to do is have a "raised" train when two or more trains are in the same station at the same time and have irregular Y-axis grid lines.

These seem to be pretty minor points to me, however, I take it that these things are major stumbling blocks to you. If that is the case, then I think you need to either:
1. Shell out the large sums of money for the professional software.
2. Learn programming and write your own software (I suggest IDL as a language).
3. Draw them by hand. or
4. Compromise on the issue.

Good luck.

Sponsored advertisement

Subscribers: Aaron, DavidB, tasrail

Display from:   

Quick Reply

We've disabled Quick Reply for this thread as it was last updated more than six months ago.