For those interested here's how Claude AI and I built the GSPOS.
The whole system uses an Airtable database as its Reference Source. The Airtable Workspace has tables detailing every part of the layout and its operations. There are tables for Railway Owners (SAR, VR, ANR and Private Owners); Motive Power, Rolling Stock, Towns, Sidings, Sessions, etc etc.
We then built a Python Script to interrogate the Database and place the selected Session (Monday PM, Wednesday AM etc) on the server (the Server is on the PC. . From that server all information for the Session is passed to Operators, Yardmasters and the Dispatcher. Simple?
Well there is still some setup work. To prepare for a session we have setup a few 'Generators' that do the calculations. Generators are simple webpages that interrogate the Database and make produce an outcome for the next stage in the process.
First there is the Waybill Generator, it determines where cars are and where they have to go. It's the bit that turns the waybill over to the next job. There are certain rules in place to prevent the Silos getting Tank cars full of fuel etc, but if the Generator did that (which it wont), but if it sent a car to a place I don't want it to I simply change it in the Generators results or in the Airtable Waybill Table, if I have already pressed the "Write to Airtable" button.
The Waybill Generator outcome screen. this process usually take 1 second.
Next I open the Session Planning Generator. This process works train consists for the session. It looks at the waybills and assigns them to a train. It also allocates Motive Power and Brake Vans. Again if I don't like the allocations I can easily change them.
We are now ready for the Session.
Once the session is completed I open the Post Session Generator, this asks me did everything move as planned, if not I can change what didn't move, then it moves the cars in the Database to their new positions ready for the next Session for Waybill to be written.
All these Generators and the Python script are all run from desktop Shortcuts on the PC screen. At the moment its a little clunky but soon I will wrap it all up into a simple to follow App on the PC.






































