1. Home
  2. Library
  3. Data

Upcoming Games

No games to display
Full list
Add a game

Upcoming Events

No events to display

Who's Online

Creating Timetables in Excel for CSV format to import

You are here: Home > Forum > General > Timetabling > Creating Timetables in Excel for CSV format to import

Page 1 of 1

Creating Timetables in Excel for CSV format to import 13/07/2011 at 21:10 #3397
pedroathome
Avatar
892 posts 		I am in the process of creating a timetable for the Exeter sim. Working on the commuter lines (for Barnstaple and Exmouth) there are a few request stops. I am wanting to treat these as set down only, as this is a suitable time for a odd passenger here and there to get on or off. What I am trying to get to here is, in Excel, how do I tell it to just set down. Also, what is the code for a through line stop?

Sorry if this is on the forum somewhere else or in the instructions, but so far, I have not been able to find any information on this.
Log in to reply
Creating Timetables in Excel for CSV format to import 13/07/2011 at 21:10 #17601
pedroathome
Avatar
892 posts 		I am in the process of creating a timetable for the Exeter sim. Working on the commuter lines (for Barnstaple and Exmouth) there are a few request stops. I am wanting to treat these as set down only, as this is a suitable time for a odd passenger here and there to get on or off. What I am trying to get to here is, in Excel, how do I tell it to just set down. Also, what is the code for a through line stop?

Sorry if this is on the forum somewhere else or in the instructions, but so far, I have not been able to find any information on this.
Log in to reply
Creating Timetables in Excel for CSV format to import 13/07/2011 at 21:28 #17603
ipswich
Avatar
247 posts 		s is set down eg 10s48 means a train is booked to set down at 1048 and may leave station earlier
t is through line stop

hope that helps
Log in to reply
Creating Timetables in Excel for CSV format to import 13/07/2011 at 21:45 #17604
AndyG
Avatar
1835 posts 		ipswich said:
s is set down  eg  10s48  means a train is booked to set down at 1048 and may leave station earlier
set down appears as 10d48 in TTs
I can only help one person a day. Today's not your day. Tomorrow doesn't look too good either.
Log in to reply
Creating Timetables in Excel for CSV format to import 13/07/2011 at 22:19 #17606
Noisynoel
Avatar
989 posts 		Right, if you want it in CSV format to convert to SimSig then it isn't possible as far as I know. If, in the spreadsheet you use anything other than : in the time then it will not load correctly. The other way you could try is the other import/export option which converts it to a txt file. In this format you can alter so much more.
Noisynoel
Log in to reply
Creating Timetables in Excel for CSV format to import 13/07/2011 at 22:23 #17607
Peter Bennet
Avatar
5363 posts
Online 		There's a bit about timetables on the WIKI but it looks like the pages on how to write a timetable have never been written.

Peter
I identify as half man half biscuit - crumbs!
Log in to reply
Creating Timetables in Excel for CSV format to import 14/07/2011 at 00:40 #17608
Quizman
Avatar
276 posts 		ipswich said:
s is set down eg 10s48 means a train is booked to set down at 1048 and may leave station earlier
t is through line stop

AndyG said:
set down appears as 10d48 in TTs

Peter Bennet said:
it looks like the pages on how to write a timetable have never been written.

Ummmmm could someone with time on their hands be able to do the definitive timetable writing basics as it would appear that even the 'experts' can't agree ::
Log in to reply
Creating Timetables in Excel for CSV format to import 14/07/2011 at 06:18 #17609
Meld
Avatar
1098 posts
Online 		ipswich said:
s is set down eg 10s48 means a train is booked to set down at 1048 and may leave station earlier
t is through line stop

hope that helps
To add a little clalrification - in public and working timetables a time of 10s48 indicates a set down point and the train may leave as soon as ready. In SimSig timetables the d character is used instead to get the same effect.

I personally use the set down facility a lot to speed up Loco run rounds and shunt moves, especially if a reverse is required on a running line.
0E62S
SHEFFIELD --:-- 03d00 P2
SHEFFIELD SS&CWM --:-- 03d04
SHEFFIELD SS(S87/92) --:-- 03t11
SHEFFIELD 03:12h 03:35 P1B J:1E62 N:5E62

In the above example from Pascals Sheffield 19/83/4 t/t a shunter is booked to move after attaching vans in P2 to goto P1 to detach vans from another service. The vans are attached before 0248, the 03d00 & 03d04 departure times allow the shunter to move as required down to the carriage washer to reverse back to S92 to await the arrival of 1E62 in P1B which arrives @ 0310, before drawing down to join 1E62 and form the empty vans as 5E62. The 03t11 time indicates the through line stop which holds the shunter there till 1E62 arrives.

A rule can also be added to 0E62S to make the 03t11 extend in the case of 1E62 running late

HTH
Passed the age to be doing 'Spoon Feeding' !!!
Log in to reply
Creating Timetables in Excel for CSV format to import 14/07/2011 at 06:28 #17610
clive
Avatar
2738 posts 		Quizman said:
Ummmmm could someone with time on their hands be able to do the definitive timetable writing basics as it would appear that even the 'experts' can't agree
The convert to/from Excel was the original feature and can't cope with all the facilities that have since been added to timetables. Geoff may correct me, but I have the impression that it's no longer supported.

There's a guide to using Convdata and how to write a timetable with it here.
Log in to reply
Creating Timetables in Excel for CSV format to import 14/07/2011 at 09:25 #17614
pedroathome
Avatar
892 posts 		I know that it is possible to import CSV, as I have created a simple version before
Log in to reply
Creating Timetables in Excel for CSV format to import 14/07/2011 at 09:26 #17615
pedroathome
Avatar
892 posts 		Noisynoel said:
Right, if you want it in CSV format to convert to SimSig then it isn't possible as far as I know. If, in the spreadsheet you use anything other than : in the time then it will not load correctly. The other way you could try is the other import/export option which converts it to a txt file. In this format you can alter so much more.
know that it is possible to import CSV, as I have created a simple version before
Log in to reply
Creating Timetables in Excel for CSV format to import 14/07/2011 at 14:31 #17622
Noisynoel
Avatar
989 posts 		pedroathome said:
Noisynoel said:
Right, if you want it in CSV format to convert to SimSig then it isn't possible as far as I know. If, in the spreadsheet you use anything other than : in the time then it will not load correctly. The other way you could try is the other import/export option which converts it to a txt file. In this format you can alter so much more.
know that it is possible to import CSV, as I have created a simple version before
Sorry, as was pointed out to me yesterday (Been too busy to change). Itis not impossible to import CSV files, what I meant was it is impossible to show things like trains set down only or through line stop. Using CSV you can either show them as stopping or passing trains. Anyway, it's so much easier to use the notepad method.
Noisynoel
Log in to reply
Back