Author Topic: Excel Switch Lists?  (Read 1205 times)

0 Members and 1 Guest are viewing this topic.

wm3798

  • Crew
  • *
  • Posts: 13207
  • Gender: Male
  • I like models. She likes antiques. Perfect!
  • Respect: +1408
    • Western Maryland Railway Western Lines
Re: Excel Switch Lists?
« Reply #15 on: August 22, 2019, 06:43:19 PM »
0
@GaryHinshaw I was not aware that JMRI could function for anything but a DCC layout.  I will definitely explore that.  If you look at the latest madness I've posted over in my Retro thread, you'll see that I'm trying to squeeze a little ops out of the smaller space I have.
Sometimes it pays to get trolled!

But I wonder if the system can handle the occasional time warp when I swap my 1890s steam out for a Metroliner!

Lee
Route of the Alpha Jets

Lee Weldon www.wmrywesternlines.net

cfritschle

  • Crew
  • *
  • Posts: 812
  • Respect: +117
    • N Scale Vehicle Association
Re: Excel Switch Lists?
« Reply #16 on: August 22, 2019, 09:39:00 PM »
+1
While not an Excel spreadsheet, Ship It! from Albion Software does produce computer generated switchlists.  http://www.albionsoftware.com/

I have used to sparingly, but I have some friends that use it for regular operating sessions.  There is even a Yahoo Group where you can get technical help.  https://groups.yahoo.com/neo/groups/shipit/info?guccounter=1&guce_referrer=aHR0cHM6Ly9ncm91cHMueWFob28uY29tL25lby9ncm91cHMvc2hpcGl0L2NvbnZlcnNhdGlvbnMvbWVzc2FnZXM&guce_referrer_sig=AQAAAAtWLCubBMZ0dlELA53afh7T1Wdl_2_VHBXux-Ds6c-Ldsk_3E-WLCaIrSROYCzBXrd4unQCmSl60on04GJFLHs1kuXHgbIeoImzyznhs1yunUCFjd52QyrzBsNLbQ_zcVaLZoxVYKVXw_PMjkzwnVfsVyNH_IYlxpbDjuHdCihQ


Carter

N Scale Vehicle Association
"For the modeler and collector of 1:160 scale model vehicles and equipment"
http://nscalevehicles.org/

Maletrain

  • Crew
  • *
  • Posts: 1247
  • Respect: +146
Re: Excel Switch Lists?
« Reply #17 on: August 23, 2019, 10:04:56 AM »
0
First draft, based on Ed's CR example. I don't know what a DiCCS is, so I took artistic license and made it "Dispatch Center". Also tweaked a few other things:

Excel spreadsheet here: http://www.everywherewest.com/trw_switchlist.xlsx

Labels are in locked fields so as to not anger the fat-finger gods, the data fields are all normal. Sheet has protection turned on, but without password; turn off sheet protection to modify the labels.

Thank you, Mike!

wm3798

  • Crew
  • *
  • Posts: 13207
  • Gender: Male
  • I like models. She likes antiques. Perfect!
  • Respect: +1408
    • Western Maryland Railway Western Lines
Re: Excel Switch Lists?
« Reply #18 on: August 25, 2019, 01:15:59 PM »
0
I reduced these from actual WM paperwork and have them in a ready to print format...


Route of the Alpha Jets

Lee Weldon www.wmrywesternlines.net

peteski

  • Crew
  • *
  • Posts: 21112
  • Gender: Male
  • Honorary Resident Curmudgeon
  • Respect: +1927
    • Coming (not so) soon...
Re: Excel Switch Lists?
« Reply #19 on: August 25, 2019, 01:29:26 PM »
0
I reduced these from actual WM paperwork and have them in a ready to print format...



Lee,  the document looks cool, but with all the background "noise", is this a scan of a poor quality copy of the document?
--- Peteski de Snarkski

-"Look at me, I'm satirical!!!"
-"Look at me, I'm anal retentive!!!"
-"Look at me, I have the most posts evahhhh!!!"
-"Look at me, I'm snarky!!!!"
-"Look at me, I have OCD!!!"
-"Look at me, I'm a curmudgeon!!!!"
-"Look at me, I'm puzzled!!!!

C855B

  • Crew
  • *
  • Posts: 7940
  • Respect: +997
Re: Excel Switch Lists?
« Reply #20 on: August 25, 2019, 02:05:02 PM »
+1
Lee,  the document looks cool, but with all the background "noise", is this a scan of a poor quality copy of the document?

It looks like it had scanned through the paper and captured the printing on the flip side. If there's an opportunity to scan again, placing medium gray (NOT black) paper behind it will mitigate the problem without blowing the contrast. Discovered this technique developing an OCR system 25 years ago.
...mike

http://www.gibboncozadandwestern.com

We don't make mistakes, we have happy accidents. We just don't tell anybody. -Bob Ross

CRL

  • Crew
  • *
  • Posts: 739
  • Needs More Dirt.
  • Respect: +174
Re: Excel Switch Lists?
« Reply #21 on: August 25, 2019, 02:29:55 PM »
0
You could make this document even more realistic with a lot of greasy fingerprints all over it.

peteski

  • Crew
  • *
  • Posts: 21112
  • Gender: Male
  • Honorary Resident Curmudgeon
  • Respect: +1927
    • Coming (not so) soon...
Re: Excel Switch Lists?
« Reply #22 on: August 25, 2019, 03:30:12 PM »
0
It looks like it had scanned through the paper and captured the printing on the flip side. If there's an opportunity to scan again, placing medium gray (NOT black) paper behind it will mitigate the problem without blowing the contrast. Discovered this technique developing an OCR system 25 years ago.

I use black backing sheet (from a craft store) and  it works perfectly well too.  Also the contrast and white and black thresholds can be easily modified (either in the scanner's settings  or in a graphic editor post-scanning), so the printing can be made nice and dark, while the paper is pure white (if one is after that type of a look).  But you are professional graphic guy, so you already know all that. I only do  this as a hobby.  :)
--- Peteski de Snarkski

-"Look at me, I'm satirical!!!"
-"Look at me, I'm anal retentive!!!"
-"Look at me, I have the most posts evahhhh!!!"
-"Look at me, I'm snarky!!!!"
-"Look at me, I have OCD!!!"
-"Look at me, I'm a curmudgeon!!!!"
-"Look at me, I'm puzzled!!!!

Steveruger45

  • Crew
  • *
  • Posts: 687
  • Gender: Male
  • Respect: +118
Re: Excel Switch Lists?
« Reply #23 on: August 25, 2019, 03:50:09 PM »
+2
You could make this document even more realistic with a lot of greasy fingerprints all over it.

 weathering switch lists.  Great idea.
Steve
Atascocita, Texas

wm3798

  • Crew
  • *
  • Posts: 13207
  • Gender: Male
  • I like models. She likes antiques. Perfect!
  • Respect: +1408
    • Western Maryland Railway Western Lines
Re: Excel Switch Lists?
« Reply #24 on: August 25, 2019, 03:52:35 PM »
0
I believe the original may have been onion skin paper, since several carbon copies (remember them?) had to be cut for the records.  The copy I made was an original sheet.
I also have some Form 19s, also on onion skin...  I resized the copy in Publisher and set up 4 to a sheet.

Route of the Alpha Jets

Lee Weldon www.wmrywesternlines.net

wm3798

  • Crew
  • *
  • Posts: 13207
  • Gender: Male
  • I like models. She likes antiques. Perfect!
  • Respect: +1408
    • Western Maryland Railway Western Lines
Re: Excel Switch Lists?
« Reply #25 on: August 25, 2019, 03:54:51 PM »
0
The other one I used a lot of was the "Station Record of Train Movements"  ... When the operator says the train is "O.S." or "On Sheet", this is the one they are talking about...

Route of the Alpha Jets

Lee Weldon www.wmrywesternlines.net

Ed Kapuscinski

  • Global Moderator
  • Crew
  • *
  • Posts: 18016
  • Has a degree in American History & Culture.
  • Respect: +2233
    • Conrail 1285
Re: Excel Switch Lists?
« Reply #26 on: August 25, 2019, 05:23:57 PM »
0
And that's why I recreated the Conrail ones in InDesign.

Doing the WM forms shouldn't be that hard either.

GaryHinshaw

  • Global Moderator
  • Crew
  • *
  • Posts: 5482
  • Respect: +622
Re: Excel Switch Lists?
« Reply #27 on: August 25, 2019, 05:31:40 PM »
+1
The other one I used a lot of was the "Station Record of Train Movements"  ... When the operator says the train is "O.S." or "On Sheet", this is the one they are talking about...

This is why they used to teach us to stay within the lines in penmanship.

ncbqguy

  • Crew
  • *
  • Posts: 154
  • Respect: +90
Re: Excel Switch Lists?
« Reply #28 on: August 25, 2019, 10:38:56 PM »
0
I don't pretend to be an Operations Expert but I have operated on a number of railroads using different systems for freight car movement and this is what I've gathered:
There is a difference between Wheel Reports (all the cars that are in a train and to be picked up) which is a document for the Conductor....basically a distillation of the Waybills associated with all the cars that a particular train is going to handle....and Switch Lists which are the notes hand written by the Brakeman on the ground to plan moves. 
I've found that writing out switch lists is much better than trying to keep track of a stack of Car Cards or juggling them on a shelf or worse leaning them against cuts of cars in a yard or town.  You can write down cars that you don't have waybills for (cars that are staying where they are but have to be moved to perform your work).     
Switch lists are useful even when you get a full printout of the cars from a computer.  It takes less time to jot down the reporting marks and car numbers than having to refer back to the source documents each time you make a move.
I have been on railroads where the owner lays out every move for every car but most times you arrive in town with the car cards / waybills in your train, look through them to see what you're dropping off, look at the sidings to see what cars you have to pick up or leave.  The handwritten Switch List is only good for that one town or yard and is flexible if you encounter a car not picked up or not where it is supposed to be.   
Charlie Vlk 

Shipsure

  • Crew
  • *
  • Posts: 1497
  • Gender: Male
  • Respect: +616
Re: Excel Switch Lists?
« Reply #29 on: August 27, 2019, 11:56:06 AM »
0
Will this work for the 99.999% of modelers who don't do Conrail??  :D :D


The CRHS has just the thing for you!

(Attachment Link)

1 pack of 50 is just $5.

https://conrailshoppe.com/reproduction-conrail-industry-switch-lists/

I designed these for my own use and figured the CRHS could benefit from the fundraiser.

I've also got the yard version of it too, if you need those. We haven't decided on if we're going to print those or not yet.