I was playing around last night with Excel creating a “Work Order” for pick up and deliveries around my layout so I could print off work orders and I am wondering if I am missing anything or should go about it differently. The way I have it so far is to have each field is done as a pull down item that feeds off a different sheet so I can updated my roster/industries without having to change a lot of info. For each location it list if the car is picked up or dropped off and its current status. This would an exampel of what I have in mind. Once I get some input on any changes I will post or link the spread sheet for use by everyone.
Engine Unit number: CSX 2769 CSX 9016
Number of stops: 3
Location #1 CSX Yard
Unit Number: BNSF 39485 Hopper Pick up-Empty
CSX 5687 Box Car Pick up-Loaded
UP 8747 Box Car Pick up-Loaded
Location #2 Magic Pan Bakery
Unit Number: CN 87859 Hopper Pick Up-Empty
CN 87863 Hopper Pick UP-Empty
CSX 5687 Box Car Deliver-Loaded
UP 8747 Box Car Deliver-Loaded
Location #3 Flintstone Gravel
BNSF 39485 Hopper Deliver-Empty
C&O 8577 Hopper Pick Up-Loaded
I model CSX also. A year or two ago somebody posted an actual CSX work order. What you've done is very close to the real thing, at least as far as what modelers are interested in. Not that it matters but the CSX code for Deliver-Loaded was PL short for 'place'. The code for pick up was, PU. If you have multi spot industries you might want a column for the actual car spot at an industry.
Lance
Visit Miami's Downtown Spur at www.lancemindheim.com
Thanks, I updated it with pick up and drop codes.