Page 1 of 1
Creating Timetables in Excel for CSV format to import 13/07/2011 at 21:10 #3397 | |
pedroathome
![]() 906 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
![]() 906 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
![]() 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
![]() 1842 posts |
ipswich said:s is set down eg 10s48 means a train is booked to set down at 1048 and may leave station earlierset 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
![]() 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
![]() 5377 posts |
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
![]() 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 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
![]() 1108 posts |
ipswich said:s is set down eg 10s48 means a train is booked to set down at 1048 and may leave station earlierTo 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
![]() 2766 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 agreeThe 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
![]() 906 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
![]() 906 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
![]() 989 posts |
pedroathome said:Noisynoel said: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.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 Noisynoel Log in to reply |