What a great and timely post

I am going to begin watching the videos now. Thank you for sharing and to the folks that spent time to do the videos and to MRH for having this wonderful free site and to the advertisers that support the magazine. Be advised that when I begin looking for products this is where I start if I am looking at suppliers and advertisers.

Rob in Texas

Nicely done...

Great job, thanks for posting these!  It would be great to have that Excel file posted somewhere.  The fifth video got stuck just a couple of minutes in, but I'm sure that was my internet connection again.  I'll try again tonight.  I did have to brush up a little on my Canadian in order to understand everything!    

thanks! 

Randy

"Timely Post"

Thanks Rob.  It is a complex subject and labour intensive process, but when completed it is easy to make changes to your railroad operation.  Like you I enjoy MRH a great deal.

Nicely Done...

Thanks Randy.  It would be great if we could manage getting the Excel in some how through MRH.  That would be up to Joe.

Well Done!

I thoroughly enjoyed your videos, and love the idea of using Excel. Change one thing and everything else changes with it. Very clever.

When I made up the time table for my Rwy. I started out with the string diagram first. Being of the right brained artsy type I tend to think visually so I drew out the diagram, setting the distances between points roughly to scale, and started fitting in the trains. It worked well for me. We had to nudge a few things around a bit after the first couple of sessions, but I now have a "feel" for how long things take on the Ruphe and Tumbelle.

Thanks for the vids.

Re:Well Done

I am glad you liked the videos.  Excel is ideal if you want to change up or test fit your trains extras etc.  Your method works as well I am sure Michel had to do some nudging as well.  Thanks for sharing your experience.

Excel worksheet...

I made this up quickly and thought somebody else might find it useful.  The link will take you to a spreadsheet where you can input your distance in feet, your fast clock ratio, and your speed in SMH and it will figure your elapsed fast clock time and your distance in SMH.  This is for HO.    

https://docs.google.com/spreadsheet/ccc?key=0AqVc7IFJmnGjdGlfblB6OWducnZVa1dhOUJLZTJxQkE&usp=sharing

Randy

Excel Worksheets

I have Michel's worksheets and diagrams.  How did you post them Randy?

Timetable Docs

Here are Michel's worksheets

https://drive.google.com/file/d/0B0_yDEYo07XCR3hhbDZpRy0zU2s/edit?usp=sharing

https://drive.google.com/file/d/0B0_yDEYo07XCQTZFZDVMSzFMcGM/edit?usp=sharing

Enjoy

Dispatchers call list

No preview

https://drive.google.com/file/d/0B0_yDEYo07XCMHpzb3VXM2JiWlk/edit?usp=sharing
/>  

I created the worksheet in Google Drive

What I did was make a new worksheet in Google Drive, but it looks like you figured it out even better.    

Thanks for posting all of those!  That is extremely helpful.  This is fascinating stuff to me.  

thanks, 

Randy

PowerPoint on Building Timetables

Here is the PowerPoint presentation on the process Michel used to generate these worksheets etc.

https://drive.google.com/file/d/0B0_yDEYo07XCRVZxaWhXRG9hcUE/edit?usp=sharing

Thanks.  I had a look at Google docs and it works great.  I learned something very valuable from you Randy.

I published the Official TimeTable No:28 in Electronic Form

Michel has published the Official timetable in Electronic form this also maybe of use for your railroad operations as a template for consideration.

https://drive.google.com/file/d/0B0_yDEYo07XCNE4tY0R0LW9OSEk/edit?usp=sharing

Excell??

Does anyone know if this will translate to 'Numbers' on OSX and secondly what needs changing for "S" Scale???

Donwload Michels Time table XLS file

Hi

Great set of videos - thanks guys who spent so much time.

I am trying to download the XLS speadsheet from page 1 of the Blog

Select "File" then "Download"

Try clicking on "File" in the upper left, then scroll down in the pop-up window to select "download" and see if that doesn't work for you.  

Worked for me.  If that doesn't do it I could probably email the files directly to you. 

Randy

Randy's method worked as I just gave it a go

The banner came up in my test but I followed Randy's method and it downloaded fine.  Thanks Randy for your help.

S scale

Instead of using HO sale 1/87 use 1/64th in the formulas.  You may also want to change the distance for a scale mile.  Michel used 1ft for a scale mile.  This could be critical for short distances in 1/64th in terms of the model's actual scale train speeds when operating.  I cannot answer your question regarding OSX.   

Creating Michels String Diagram HELP

I have watched the videos several times.  I have created a time table chart with arrival and departure times.

I can not get the string diagram chart to come out like yours; not even close.  Could you provide some help on the chart options you chose and how you set them up?

That would really help.

Marshall

String Diagram help

Most issues that happen when creating the string diagram have to do with the scale intervals used for each axis.  Michel mentioned this a bit.  If you are trying to spread out he string you will have to expand the intervals so that there is some distance between say 1300 and 1330.  I am not sure if this helps.  You may know someone who does statistics graphs or economic graphs at work that can help you.  Hope this helps