Train games - Moving Freight and Passengers Suggestions?

I’ve developed a fairly simple excel based train operations game to play with my similarly aged son.  

At the beginning of each game, you get a random scenario of commodity freight rates per rail car type, and a random required number of mainline laps to complete in order to generate the revenue.

There are limits to the number of total cars in the train(10 or less), and a requirement to have different types of cars (must have 3 different car types). 

Essentially, the game is to build your train with the highest revenue generating loads and complete the laps under the time limit.

I also built in random costs to operate steam vs diesel so you can choose the lower cost locomotive to maximize net income.

Overall, I think it’s fun because it has an element of luck (random scenarios), but requires some thought behind which loads you would like to deliver, and skill to physically operate the trains.

I had plans to build it out in a web based version so you could keep score against yourself or friends, but haven’t gotten back to it.

If you’re interested, I can email you the excel file to try it out to see if you like it. 

By the way, nice looking layout!

Thanks! @JD2035RR we have a lot of fun with our layout.

That excel file looks pretty close to what I am looking for! Would love to get a copy of it!

@JD2035RR what a great idea, nice job! Would you be willing to send your excel doc to me too? I think this would be fun for my nephews.