Railway Performance Society Magazine - Milepost

Downloads and Tools

The society has produced a number of tools suitable for the active train recorder. Currently the following are available

  • Log Template

  • Horsepower Calculation

Log Template

For RPS members, three sample log templates are available to show how logs can be set up in Excel to do automatic calculations of decimal mileages if you alter or add timing point 'miles and chains'. They also automatically calculate the average speed if you insert the times. Play around with the formats to suit yourself. The three templates show examples for up and down trains and demonstrate what happens if mileage sequences change or if the trains make a succession of stops.

Down Run With Stops

Up Run With Stops

Down Run Non-stop

Horsepower Calculation

After recording details of a train journey it is possible to calculate the drawbar horsepower delivered by the locomotive over sections of the route. Traditionally this is done for the approaches to the major summits on the route travelled. It is possible to compare classes of locomotives or indeed locomotives within the same class using this tool.

Download Horsepower Calculation

Latest Forum Posts

Visit Forum