MRH-RE

-12-p_31.jpg 

Buy this issue!

Share this:
  [email]  [facebook]  [twitter]  [email]

Please post any comments or questions you have here.

Want more articles like this one? Give us a like on the lower right thumbs-up.png

◀   Back to issue home page

Reply 3
David Husman dave1905

Car cards?

This may seem like a silly question but where are these waybills supposed to be used?  Is this a way to generate better waybills for a "conventional" CC&WB system?  He talks about the cycling etc, but never really says when the waybills go or whether they are used with conventional car cards, etc.  I would assumer they are because there is no car information (which car the waybill belongs to) on the waybills.

Are the waybills cut apart or folded when used? 

I assume they are single use because he is crossing stuff off at the top, so after the cycle is completed, you toss the old waybills and then generate, print out, and cut apart new waybills for the next session.

Dave Husman

Visit my website :  https://wnbranch.com/

Blog index:  Dave Husman Blog Index

Reply 0
lineswestfan

Waybills go into car card pockets

Sorry for the confusion Dave, the stack of waybills for a given shipment all are placed into a car card's pocket.  When a leg is done (dropping off the empty, loading done, etc.) the top waybill is removed showing the next step (loading, waybill to receiver, etc.)   

I would have sworn I had that in there, must have been lost in the editing process, and I missed catching it in the proof.

As it does say, I cut them apart.  

And after a year of cutting for a larger layout than my first, I've gotten tired of that chore.  So I'm now working on reformating the output report to make a single, step-wise card that I can just cross off each step.  Still will have to cut apart the way bills, but now it will only be one per car, rather than up to four per car.  Nice thing about the database back end is that I can change the report without having to rewrite each and every 4-cycle card.

Richard Kurschner
Superintendent, Lynnsport & Eastern

Reply 1
David Husman dave1905

Technicolor on train ops

This is no criticism on the article or application, just some comments on the train operations mentioned.

The decision to run an extra would most likely reside with the trainmaster or possibly with the agent in the 1920's rather the dispatcher.  If it was a road train it would involve the dispatcher to arrange for the crew, caboose and power.  If it was a local they would source it from the pool of local crews and the dispatcher wouldn't have as much of a say.  The tricky part is finding an engine and caboose.

Having said that it would be rare to call an extra to handle empties (except in a coal, grain or perishable area), the trainmaster wouldn't want to spend the money to run the extra and in the 1920's the big expense is the crew costs.  They would fill out the regular train or double the hill if required.  Hours of service was 16 hours so the crews had LOTS of time to flounder around and using a single job for 12-16 hours was often cheaper than calling two crews.

Regarding "canceling" a local if there was no business, the technical railroad term they would use is "annulling" the local and it wouldn't be done that often because locals tend to be assigned crews.  They are bulletined to operate over a specific territory on specific days by labor agreement.  That means they get paid at least a basic day for each of those days, whether they run or not, whether they handle a single car or not.  Since they are getting paid, the railroad will usually find something for them to do.

FYI, a cool book to read about operations in this era is a book called "Set Up Running : the life of a Pennsylvania RR engineman 1904-1949", by Oscar Orr.

Dave Husman

Visit my website :  https://wnbranch.com/

Blog index:  Dave Husman Blog Index

Reply 0
David Husman dave1905

Access

I created my own Access app to generate car cards and waybills, but don't have any back end logic to drive what roues/shipments are selected.

Unfortunately, Access doesn't have the ability to print rotated (or at least I haven't found it yet).  When I do multi-sided or top and bottom waybills it means multiple passes through the printer rotating the paper manually.  On the other hand, Excel can rotate 90 degrees both left and right, so you can do top and bottom in one pass.  One thing I haven't tried is exporting the data to an Excel spreadsheet (as a data table) and then using a formatted spreadsheet linked to the "data" spreadsheet to print the actual waybills.  

The limitation with that is the formatted spreadsheet in Excel would only read a set number of rows, so the Access app could only export a set number of records at one time.

Dave Husman

Visit my website :  https://wnbranch.com/

Blog index:  Dave Husman Blog Index

Reply 0
David Husman dave1905

Overhead

One concept that is handy with car forwarding for overhead business is the concept of a "block".  A block is a group of cars handled from one place to the next place they will be handled.  That could be a yard where they will be reclassified, to an interchange or to a station.  Train carry certain blocks and cars are assigned to certain blocks based on their destinations.  The block to which a car is assigned is dynamic depend on where it is and what blocks that yard and its trains handle.

On my system I have blocks that drive cars to staging yards and my overhead and through business just gets a waybill with the block name on it.  I do differentiate between loaded and empty cars (mostly because of open top cars) but the waybill block is the same.  I don't indicate car type, shipper, consignee (reciever), origin, destination or lading (if loaded).  It's irrelevant as far as the car movement is concerned.  The waybill has the block on it.  The block will be either be the interchange or off junction if its a thru car, or the yard from which the local/switcher that serves the industry originates (in the case of a car going to industry). Each through freight carries specific blocks.  The yard bundles up the cars in each block and then adds them to the trains that carry that business.

Blocking is a powerful way to route cars simply without having to have a lot of detail behind it.  And having used it for the 37 years of my railroad career, its prototypical.

The real place it shines is for overhead trains from staging to interchanges or staging.  If you have a 20 car train in staging and all it does is stet out and pick up at junctions, interchanges or staging, you can just use waybills with the block names on them to drive the movement without any of the detail of a normal waybill.  For example if I have a train coming out of Reading staging and it has a block of 9 cars for the B&O at Elsmere and 11 cars for the PRR at Wilmington, I just get 9 waybills that read "B&O - Elsmere" and put them on the head 9 cars and then 11 waybills that read "PRR-Wilmington" on the rear cars.  Done.  Coming back, I put waybills that read "Reading" on the cars at the B&O and PRR interchanges and the train going back to Reading picks up those cars off the PRR and B&O.

The nice thing about that is if you are looking for a concise way to route cars, having a small footprint on a waybill, blocking may be helpful.  And 100% prototypical, even back in the 1920's.

 

Dave Husman

Visit my website :  https://wnbranch.com/

Blog index:  Dave Husman Blog Index

Reply 0
anteaum2666

Good article - Cool App!!

Hi Richard,

I enjoyed your article and am particularly interested in the App you've designed.  I will download it as soon as it becomes available in the December Extras. 

What intrigues me so much is that this app generates the waybill requests and is different each time.  I use 4 part waybills, and my beef with them is the repetitive nature.  I can change them out when they finish a cycle, but that's just a "fix".  I've also looked at Switchlist programs, and I've liked a few.  But my beef with them, as you say, is keeping the layout in lock-step with computer, and having to use the computer DURING the operating session as trains come and go from yards.

Your App seems to solve both these problems, so I'm anxious to give it a try.

Now, if we can just find a printer that will print single waybills on 2x3 perforated paper so we don't have to cut them out!!!

Michael - Superintendent and Chief Engineer
ndACLogo.jpg
View My Blogs

Reply 2
David Husman dave1905

One per car

One way to do the "one per car" thing is to make two sided or top and bottom waybills.  Two sided would preserve the info at the bottom of the waybill.

For the two sided waybills, at the bottom of the visible area or inconspicuously at the top you could have the loading/unloading "timer" on move 1.  Retain the marks because they are really the only thing "active" on the second waybill.  Spot the car with move one.  Leave the waybill alone and then every session check off the timer marks on the top of the waybill.  Since the waybill is on whatever the status was when it was spotted and the destination is the place where it is spotted, it says leave me here.  It's also prototypical, since an empty spotted isn't billed until it's loaded so it's considered still an empty.  Same thing with the loads.

When the time was up, turn the waybill to move two and have the outbound waybill info, with the timer info in it.  Spot the car according to move 2, then check off the move 2 timer marks as required.  When those marks are done, pull the waybill.  

For two sided waybills there are two tricks.  The first is getting the output positioned on the page so that when its run through the printer the second time the positions on the front and back line up.  Second is that you have to change the order of the waybills on the page.  If the waybills in the first row are numbered 1-2-3-4, when you flip the page they need to be numbered 4-3-2-1.

The way I do that is to have a table for side 1 with the waybill order on it and then a table for side 2 with the reverse waybill order.  I have two print order fields, side 1 and side 2, I update the table of waybills to print with the print orders for each side and then sort by the side one field on pass and by side 2 on the second pass. 

That would give you one waybill per car with two moves and retain the load/unload timers.

Dave Husman

Visit my website :  https://wnbranch.com/

Blog index:  Dave Husman Blog Index

Reply 0
joef

Extras are up

Quote:

I will download it as soon as it becomes available in the December Extras.

The December Bonus extras are now up.

https://mrhmag.com/magazine/mrh2021-12/bonus-extras

Joe Fugate​
Publisher, Model Railroad Hobbyist magazine

[siskiyouBtn]

Read my blog

Reply 0
David Husman dave1905

Car cards vs CC&WB

If you don't want to cut out a bunch of waybills, you might want to explore "car cards" vs CC&WB.  Car cards have a table of rows with sequential destinations and columns for each cycle.  As cars are moved the boxes are checked off.  An application of these was described in the MRH articles on the Wyoming railroad.

To merge that with your system, I would have two columns dedicated to each move.  The first column would designate the arrival at destination and the second column would be the dwell.  The dwell would be blank for 2 session dwell.  The car would be spotted and the spot box checked off.  If the box in the dwell column was empty, the car would dwell for two sessions.  The next session a slash would be marked in the dwell box and the session after that, another slash added to make an "X" and the third session the car would be moved to the next destination.  If the car was to be moved on the second session teh computer would put a slash in the dwell box and only one more slash added  to make an X and then the car moved the next session.  If the car was to be moved the next session the computer would put an X in the dwell box and the next session it would be moved.  This plan would work for both loading and unloading.

You could have the computer randomly list 8-10 moves per card and with 6 columns for 3 cycles, the car card could last for dozens of sessions before it needed to be replaced.  

Dave Husman

Visit my website :  https://wnbranch.com/

Blog index:  Dave Husman Blog Index

Reply 0
lineswestfan
Good Input Dave

Thanks  @dave1905 , lots of interesting information as always.
 
I do understand that typically the dispatcher would not be the one calling the extras and second sections.  But most model railroads don't have trainmasters.  Well, actually I guess they do:  the owner.  And it really does make sense for the owner to call the extras since he or she who know that extra operators showed up.  It is easy to find an extra crew when they are already sitting in your crew lounge!
 
Now what's this about the AGENT calling for an extra?  I get it that they might be aware of local needs for extra movements, but they have such authority?
 
It never occurred to me to try rotating text in Access since I didn't want that form of waybill.  But you are right, it doesn't give that capability to you.  Surprised me.  What you can do is create your own font that is visually upside down and writing right to left.  But I think I'd rather scratch build something that go through that.
 
Blocks as I understood them are a multiple car shipment such as 3 reefers from packing house to distribution house.  And while this program allows multiple car shipments, it definitely does not handle keeping them together.  A limitation that I know of, but haven't worked on.  
 
Blocks in a train I've also used, but only by grouping the cards:  once you get to the first San Francisco card, all the rest are also bound their.  Your comment makes me think of adding a card that simply says "Block SF", but that is another card in the stack which many would find undesirable. Your comment also makes me realize the staging yard should be color coded. Access makes coloring the background of "San Francisco" green real easy.  Also see later post on story cards.
 
You are right, turning the card top to bottom and front to back would make fewer cards in the pocket and fewer cards to be cut apart.  But it makes printing more tedious.   My initial concept was removing cards and avoiding turning, so I never considered your alternative.  Funny how the mind fixates.  But again see my later post on story cards. 

Richard Kurschner
Superintendent, Lynnsport & Eastern

Reply 1
lineswestfan
Printing options

@anteaum2666, thank you for the kind words.  Your frustration with the repetativeness of the common 4-cycle cards was one of the considerations that drove me to do this.
 
Actually there ARE printers that will do what you suggest.  First are label printers that are designed to use continuous-feed sticky label stock.  The second option is to use mailing labels on 8.5"x11" carrier paper though your normal printer.  In either case pull the stickers off the carrier and slap 'em on some card stock.  A third option is to use perforated business card stock that comes in 8.5"x11" sheets, just tear them apart.  Downside of these options is the cost of the printer, the stock, or both.  So I got a $13 paper slicer from the art store.

Richard Kurschner
Superintendent, Lynnsport & Eastern

Reply 1
lineswestfan
Story Cards

In long term use, cutting all of the cards apart gets tedious (and somewhat wasteful).  So I've started working on what I'm calling story cards.
 
The database builds a story of a car's movements.  What is shown in the article is a way to print that story as a series of individual cards defining individual movements.  Since I submitted the article, I've started exploring putting that entire story on a single card.  Turns out it is the same story, just a different report.
 
Mechanically it is slightly different, instead of removing the top card, you cross off the top line.  This actually harkens back to an old style of tracking car movements where a paper clip was put on an index card to mark the place in the list of moves.  I seem to recall that Frank Ellison used this method. Back then the paper clip was simply moved back up to the top of the card at the end; you didn't want to throw out the card since you spent the effort to manually type them up.  Below is an example of what I've done so far.
 
@dave1905 comments makes me realize I could easily include blocking information on the card to make it easier on the engineer/conductor/yardmaster.
Screenshot_2.jpg 

Richard Kurschner
Superintendent, Lynnsport & Eastern

Reply 1
David Husman dave1905
Now what's this about the AGENT calling for an extra?  I get it that they might be aware of local needs for extra movements, but they have such authority? 


Depends on the era and depends on the railroad.  Agents were the business managers of the railroad.  They were in charge of all the money, they were the representatives of the railroad with customers.  And there were waaaaay more agents than trainmasters.  They would know what business they would need to cover at their stations (or area of responsibility.)  In the 1920's an agent was a pretty important position on the railroad.

For example when I was Asst. Trainmaster in Kansas, I still had an agent (but no yardmaster).  When I was away, he was in charge.  There still is the chain of command and authority as far as actually calling an extra, but he could request one.  The dispatcher wouldn't have a clue what the local customers wanted and what traffic was in the yard, especially in the 1920's.
 
Quote:
What you can do is create your own font that is visually upside down and writing right to left.  But I think I'd rather scratch build something that go through that.


I scratchbuild stuff all the time and I would waaaaaay rather scratchbuild a car than try to get Access to print sideways or upside down.

However you could export an Access developed table to a data spreadsheet and then have a formatted spreadsheet that reads the data spreadsheet, then print the formatted spreadsheet to get two moves on one side.  A little unhandy but every page only goes through the printer once.
 
Quote:
Blocks as I understood them are a multiple car shipment such as 3 reefers from packing house to distribution house. 


"Block" is one of those cool railroad words that has about a zillion definitions and meanings depending on context.

Model railroaders think of "blocks" as putting locals in "station order" (all the cars for Anna together, all the cars for Bess together, all the cars for Cloy together, etc.)  Station order is a type of blocking but real railroads use a much broader definition of blocking and blocking is how railroads manage their trains and classifications.  Model class yards are commonly set up for one track for each "destination" or train.  On a real railroad, a class yard is set up by assigning blocks to tracks.  Cars belong to a block and you switch the cars by block.  A block can have a much broader definition that just a "destination".  For example,  on the UP in the yard at Los Angeles they might have 100 "North Platte" cars.  None of those cars will actually be going to North Platte, they will all be going to places east of North Platte, but N Plate is where they will next be switched.  All the paperwork, all the crews and all the references to what's on the train will call them N Plattes.
 
Quote:
You are right, turning the card top to bottom and front to back would make fewer cards in the pocket and fewer cards to be cut apart.  But it makes printing more tedious.   My initial concept was removing cards and avoiding turning, so I never considered your alternative. 

Welcome to the wonderful world of why Car cards and waybills were invented in the first place.  The whole concept of CC&WB is you print them once, you use them 1000 times.

To that end, here is a concept that might work.  You might only need to print unique cards for one move.

If your railroad is like mine, I only have a few ways off the railroad.  If you have a staging yard at either end and no interchanges you really only have two ways off.  Throw in a couple blocks (expedited vs. drag freight) and you only have a possibility of 4 outbound blocks.  So that means all the moves driving a car off the layout are one of four choices. 
You could make a bunch of single move waybills  that drive cars to industries, regardless of whether they are loaded or empty, and then suggest one of the 4 outbound routes.  You then have a bunch hold/placed/spotted waybills.

You print all the cards once.  you cut apart the cards once.

To bill a car you select an inbound waybill (car type, commodity and industry specific), then it tells you what the outbound route is, you select that outbound route card (not car type or commodity specific), then select however many hold cards you want.  Place the waybills in the car card pocket, front to back:  inbound, hold, hold, outbound.

The car is moved from staging to the location on the inbound and spotted.
You pull the inbound waybill revealing a hold.
After the next session you pull a hold, revealing another hold.
After the next session you pull a hold, revealing the outbound move.
Car moves outbound to staging, last card pulled, ready for next sequence.

Upsides, you are just pulling waybills, no turning, everything printed upright, all the paperwork is reusable for multiple trips.
Downsides, the outbound moves won't have shipment detail or destination detail other than the outbound block.

Dave Husman

Dave Husman

Visit my website :  https://wnbranch.com/

Blog index:  Dave Husman Blog Index

Reply 0
engineer
Thank you very much for this article! I hoped to get an easier way for car routing than with JMRI. But it's a pity that it's programmed in a proprietary software not everybody has or wants. It would have been great to see this realized with LibreOffice, the open source office solution. And an additional benefit would be the easy multi-platform use, for example on a Raspi.

________________________________________________________________________

    [1]   

Somewhere Southwest at MRH: http://model-railroad-hobbyist.com/node/21520
Modern monopole billboard in MRH: https://forum.mrhmag.com/post/modern-monopole-billboard-for-your-layout-13129796

Prototype Pics: https://somewhere-southwest.de/index.php/Prototype

Reply 0
David Husman dave1905
Several years back I tried to replicate my Car Card and Waybill generator in OpenOffice and wasn't able to do it.  MS Access was so much easier to work with and set up to do exactly what I wanted.  At that time, it was sorta like the difference between working in Word and working in Notepad.  Maybe LibreOffice has additional functionality.  I tried to use LibreOffice but never could get it to actually do anything, it was always giving me error messages, wanting me to download something else, wanting me to register something or wanted to change default extensions. 

Having said that, you can set up a similar thing in MS Excel or a spreadsheet application that will format a sheet of info to print it.  It just it takes more manual steps and there might not have the automatic logic behind it. 

Dave Husman

Visit my website :  https://wnbranch.com/

Blog index:  Dave Husman Blog Index

Reply 0
lineswestfan
@engineer, I am glad you liked the article!

engineer wrote:
But it's a pity that it's programmed in a proprietary software not everybody has or wants. It would have been great to see this realized with LibreOffice, the open source office solution. And an additional benefit would be the easy multi-platform use, for example on a Raspi.

Yeah, multi-platform, open source is nice.  But only if it works.  As I mentioned in the Bonus Materials, I did look a little bit at Base by LibreOffice.  And it wasn't great.  I found it clunky, and it seemed to be lacking in features.    It may be a Base issue as @dave1905,  suggests, or it may be a me problem that I just don't have enough experience with the product.  In the end, I just didn't care to spend my hobby time trying to figure it out.   I had tried other open-source/free options and found them to be much more work than I wanted to commit to.  But that said, I encourage you to take the data flow diagram in the article, and see what you can come up with!

Richard Kurschner
Superintendent, Lynnsport & Eastern

Reply 0
barr_ceo

Yeah, multi-platform, open source is nice.  But only if it works.  As I mentioned in the Bonus Materials, I did look a little bit at Base by LibreOffice.  And it wasn't great.  I found it clunky, and it seemed to be lacking in features.    It may be a Base issue as @dave1905,  suggests, or it may be a me problem that I just don't have enough experience with the product.  In the end, I just didn't care to spend my hobby time trying to figure it out.   I had tried other open-source/free options and found them to be much more work than I wanted to commit to.  But that said, I encourage you to take the data flow diagram in the article, and see what you can come up with!
 

Just a thought... did you try loading the finished files into Base? I knowm I can load Word documents into LibreOffice, even on Mac....

Read my Journal / Blog...

!BARR_LO.GIF Freelanced N scale Class I   Digitrax & JMRI

 NRail  T-Trak Standards  T-Trak Wiki    My T-Trak Wiki Pages

Reply 0
lineswestfan
barr_ceo wrote:
 

Just a thought... did you try loading the finished files into Base? I knowm I can load Word documents into LibreOffice, even on Mac....


I did not physically try loading them into either OpenOffice or LibreOffice version of Base.  I read along the way that Base was the only app in either suite that could not use the matching MS Office file format and took that at face value.   

Richard Kurschner
Superintendent, Lynnsport & Eastern

Reply 0
lineswestfan

Welcome to the wonderful world of why Car cards and waybills were invented in the first place.  The whole concept of CC&WB is you print them once, you use them 1000 times.

To that end, here is a concept that might work.  You might only need to print unique cards for one move.

...

You print all the cards once.  you cut apart the cards once.

To bill a car you select an inbound waybill (car type, commodity and industry specific), then it tells you what the outbound route is, you select that outbound route card (not car type or commodity specific), then select however many hold cards you want.  Place the waybills in the car card pocket, front to back:  inbound, hold, hold, outbound.

The car is moved from staging to the location on the inbound and spotted.
You pull the inbound waybill revealing a hold.
After the next session you pull a hold, revealing another hold.
After the next session you pull a hold, revealing the outbound move.
Car moves outbound to staging, last card pulled, ready for next sequence.

Upsides, you are just pulling waybills, no turning, everything printed upright, all the paperwork is reusable for multiple trips.
Downsides, the outbound moves won't have shipment detail or destination detail other than the outbound block.


Yep, that would certainly work.  But I was looking for computer assistance to traffic generation that mimicked realistic inbound and output frequencies,  not just random movements drawn from a deck of cards.  That's just me.  I may not care if my cars are blocked right, but by heavens, I will cut enough paper to make sure the ins and outs are in proportion! 😄

Richard Kurschner
Superintendent, Lynnsport & Eastern

Reply 0
David Husman dave1905


Yep, that would certainly work.  But I was looking for computer assistance to traffic generation that mimicked realistic inbound and output frequencies,  not just random movements drawn from a deck of cards. 


Ah yes, the "holy grail" of many automated /semi-automated systems, a customer demand driven system.

I'm not as big a fan of that, having worked for a real railroad.  

In my experience it's more of a loose-tight kinda thing between the first 900 miles and the last mile of a car shipment.  It is possible to have a system where the customer gets exactly the cars they need, exactly when they want them, BUT, that happens in the last leg of the journey, between the yard and the industry where the last job to handles the car, the one that spots the customer runs.

In the portion of the trip before the last yard it is way more chaotic.  Different amounts of cars will be arriving on different days, some days double the number of cars, some days no cars, and the yard acts as a buffer to even out the flow  so it seems very even from the customer perspective.

And the further back in time you go the more chaotic it becomes and the more acceptable it is to have bigger buffer.  The computer gives everybody a large, over the horizon viewpoint.  Back in the day, before computers that type of view wasn't possible because the reporting and communication networks weren't there over long distances.

A lot of it depends on how much of a car's trip you are modeling.  If you are just modeling that last mile then the even flow is more important.  If you are modeling the parts of the trip before the last mile then it can appear pretty random.

For example, let's say producer of widgets A only works M-F and a consumer of widgets B also only works M-F.    Its a 2 day rail journey from A to B.  Monday's production at A arrives at B on Wednesday.  Thursday's production at A arrives at B on Saturday.  But B doesn't work on Saturday, so those cars aren't spotted/unloaded.  Conversely, the Saturday "gap" at A hits B on Monday, so they won't get any cars of widgets on Monday or Tuesday.  The railroad has to hold the cars for B on Saturday and Sunday, then spots them on Monday and Tuesday when there is a gap in the supply.

From A's perspective they produce at a constant rate and from B's perspective they consume at a constant rate but from the railroad's perspective there is a "surge" of cars on the weekend that they have to be able to hold.

However I can assure you that shippers do not ship at a steady rate.  On aggregate, they ship on a saw tooth pattern, less on Monday and Tuesday, more on Friday and Saturday.  If a customer orders 10 cars a week, a shipper might ship one car on Monday, 1 on Tuesday, 2 on Wednesday, 3 on Thursday and 3 on Friday.  10 cars per week, but its not even.

And this is if the transit times are always perfect, every day all the time.  If there is one grade crossing accident, one engine failure, one train is too big and all the cars don't make that day's train, it can create an even bigger variance and double up cars or short cars.  It's easy to see how the feed into that last yard can appear almost random at times.  

Having said all that, I realize that a lot of modelers are striving for that demand driven car movement system.    

One way a modeler can leverage that variability is that it removes the requirement for a lot of the regimentation in the movements prior to the last yard, a modeler just uses the last yard as a surge basin and has something like the spot tag system I talk about in my "one and two move waybills" clinic to regulate the demand/flow on the last mile.

Modeler's choice on how they want their world to operate.

Dave Husman

Visit my website :  https://wnbranch.com/

Blog index:  Dave Husman Blog Index

Reply 1
David Husman dave1905
barr_ceo wrote:
 

Just a thought... did you try loading the finished files into Base? I knowm I can load Word documents into LibreOffice, even on Mac....


I could load a table or read a table using an OpenOffice Base database.  The part that doesn't translate isn't the data it's the mechanics, the queries, forms, and wizards built into Access that drive the manipulation of the data and formation of the output.

I am sure that one could probably write enough SQL (or whatever language is used by Libre) to do the same thing that Access does, but it wasn't a direct translation for Access into OpenOffice Base and I would assume it is still not a direct plug in for Libre Base either.

I have been sharing model railroad oriented MS Access apps for the last 15-20 years and that has always been a limitation and a source of frustration.  The problem is I have MS Access, and primarily use it for my personal applications and it is too easy to use to give up for something harder.

Dave Husman

Visit my website :  https://wnbranch.com/

Blog index:  Dave Husman Blog Index

Reply 1
jeffshultz
The system I'm setting up is called STS 3.0 (Shipper-Driven Traffic Simulator) and it's supposed to do all this, with switchlists, based on "LAMP" - Linux (there is a Windows version), Apache, MySQL (now MariaDB), and PHP.    http://new-ulm.us/?q=node/5  if anyone is interested.  I just need to buckle down and get the rest of the data entry in, since it wants to know about your rolling stock and all that, which frankly is an advantage of Richard's system. 

orange70.jpg
Jeff Shultz - MRH Technical Assistant
DCC Features Matrix/My blog index
Modeling a fictional GWI shortline combining three separate areas into one freelance-ish railroad.

Reply 2
engineer
Oh, very cool! I will give it a try! That's even better than a desktop database!

________________________________________________________________________

    [1]   

Somewhere Southwest at MRH: http://model-railroad-hobbyist.com/node/21520
Modern monopole billboard in MRH: https://forum.mrhmag.com/post/modern-monopole-billboard-for-your-layout-13129796

Prototype Pics: https://somewhere-southwest.de/index.php/Prototype

Reply 0
saddlersbarn
STS 3.0
I have been using STS for about 2 years and v3.0 for several months now and find it easy to use and very helpful. It gives you the feeling that the railroad has a purpose. Yes, it has a randomness generator, but it is based upon your input as to how often an industry is switched etc.

It is flexible in that you can use switchlists or you can use waybills. It can be used in printed format or purely digital. Not necessarily evryone's cup of tea (and the set up can take a while, though it's worth it), but well worth giving it a lookover.

My 2 cents.
John
Reply 2
Reply