09-06-2014, 11:28 AM
My latest version for weekend ponder.
In an attempt to keep this simple and focus on switching industries, I've dumbed down the yard and this will become the staging. I will build the trains by hand (with some small amount of switching). The trains will be built according to the switch list generator I'm using, see below, cars set out and pull per list. The train will return to yard/staging and cars removed by me.
The switch list generator was found on the internet. It's a spreadsheet file that uses a database of your cars and randomly builds trains for set out and tells you what to pull. I truly wish I could remember where I found this. Want to give credit where credit is due. Please, if anyone recognizes this program and knows the author, post. You can determine maximum length of trains, max munber of turns the cars are out before pull and % of dummies or place holders in train. The car inventory columns can be customized. The database shown below came with the program. I have not yet entered my car information. I believe the original file was an .xls I have since converted to .ods (open office). It does contain macros, but I've been playing with it for months now and haven't encountered a problem. If anyone wants a copy PM me and I'll email it to you (if that's appropriate).
Have a good weekend!
In an attempt to keep this simple and focus on switching industries, I've dumbed down the yard and this will become the staging. I will build the trains by hand (with some small amount of switching). The trains will be built according to the switch list generator I'm using, see below, cars set out and pull per list. The train will return to yard/staging and cars removed by me.
The switch list generator was found on the internet. It's a spreadsheet file that uses a database of your cars and randomly builds trains for set out and tells you what to pull. I truly wish I could remember where I found this. Want to give credit where credit is due. Please, if anyone recognizes this program and knows the author, post. You can determine maximum length of trains, max munber of turns the cars are out before pull and % of dummies or place holders in train. The car inventory columns can be customized. The database shown below came with the program. I have not yet entered my car information. I believe the original file was an .xls I have since converted to .ods (open office). It does contain macros, but I've been playing with it for months now and haven't encountered a problem. If anyone wants a copy PM me and I'll email it to you (if that's appropriate).
Have a good weekend!
Thanks
NSHO
NSHO