Graphics Development • Re: [OTTD] 2cc TrainsInNML

I'll see what I can do. The formula in human terms is more or less: (cue Gemini) That Excel formula is a heavy-duty logic tree used to categorize vehicles into specific "Roles" for the purchase menu.

Here is the plain English breakdown of the hierarchy, starting from the top (the first rule that matches "wins"):

1. Special Units & Wagons

• Powered/Unpowered Sundry: If the ID contains _Powered or _Unpowered.
• Wagons & Coaches: If the vehicle is marked as a wagon or coach in the CONTROL sheet:
• Coaches (Passengers): Categorized by speed and loading speed:
• Coach (HS): Speed >= 230 km/h.
• Coach (Express): Speed >= 160 km/h.
• Coach (Commuter): Loading Speed value >= 40.
• Coach (Regional): Everything else carrying passengers.
• Coach (Mail): If it only carries mail.
• Wagon: Any other cargo type.

2. Specialized Transit

• Metro / Rapid Transit: Triggered if the speed is below 120 km/h AND one of the following is true:
• The ID contains MTRO.
• The category in the CONTROL sheet mentions METRO.
• The Loading Speed value is >= 120.

3. High-Speed Rail (Speed >= 230 km/h)

• Ultra-High-Speed (Universal): No passenger capacity in the engine.
• Ultra-High-Speed (Pax): Dedicated passenger/mail engine.
• Ultra-High-Speed (Freight): High speed but carries something else.

4. Express Rail

Triggered if Speed >= 160 km/h (or >= 120 km/h for Steam Engines):

• Express (Universal): No passenger capacity in the engine.
• Express (Passenger): Dedicated passenger/mail engine.
• Express (Freight): Engine carries other cargo.

5. Freight & Shunting Specialists

• Shunter: Slow vehicles (Speed <= 60 km/h) with low power (Total Horsepower < 1200) and no passenger capacity.
• Heavy Freight: Heavy vehicles (Total Weight > 140 t) that aren't particularly fast (Speed < 140 km/h) and have no passenger capacity.

6. Local & Secondary Services

Triggered if the Loading Speed is >= 40 OR if the engine carries passengers but is slower than 120 km/h:

• Commuter / Urban: For passenger services.
• Express Mail / Parcel: For mail services.
• Light Freight: For anything else matching these specs.

7. The Fallbacks (Everything else)

• General Purpose: No passenger capacity.
• Regional Passenger: Standard passenger engines.
• Standard Freight: Standard engines carrying other cargo.

Human-Friendly Tips for the Revamp:

1. Redundancy: You have several checks for passenger capacity (HEAD_CAPACITY vs PASSENGER). It might be cleaner to define a "Is Passenger Vehicle" flag once.
2. Steam Bias: There is a specific "Express" override for Steam at 120 km/h. If you're adding more modern traction (Maglev/Turbine), you might want similar specific speed brackets for them.
3. Weight vs. Power: The "Heavy Freight" and "Shunter" rules use calculations involving DUAL_HEADED. Ensure those math brackets are consistent with how you calculate your total consist stats elsewhere.

I'm happy to revamp this is if you make specific suggestions

Statistics: Posted by nemethv — 28 Apr 2026 22:25