Vehicle Stats Worksheet?

[TyCaine]

A quick question, though I know Paul's site is the goto location for vehicles and I find myself using it all the time, I was however wondering whether there was a worksheet or, perhaps, an excel spreadsheet, for use in converting a vehicle's real-world stats to Twilight:2000 v2.2?

I've searched the intrawebs but my Google-Fu is failing me.

I know I saw one based upon Traveller FFS that had some details, but it was mainly for spaceships as far as I could remember, and was complicated as hell...

Anyone? Thanks in advance!

[EDIT] Perhaps even just the formulas for, say, Travel Move and Combat Move that are used to calculate T2K:2.2 stats? I can probably figure out Fuel Cons once I have Travel Move (since both are figured on a 4hr move period, and basing upon operational range and so on), but right now a vehicle which has, for example, 100kph as max speed, what would that be for a 4hr Travel Move? It wouldn't be 400 (100kph x 4hrs) that much I know, but is it half that? Or are the stats calculated with some more complicated formula? Just wondering what everyone's been using, or did I miss something somewhere...


~Ty

[pmulcahy11b]

Yeah, I have a couple of half-baked-but-very useful Excel spreadsheets done by Antenna, (Even Antenna called the spreadsheets "bastardized".). Email me.

BTW, anybody know how to get in touch with Anttii these days? I'd like to put the spreadsheets on my site for download.

[TyCaine]

Email sent.. :)

[Vespers War]

Using pages 20-21 of FFS, Tr Mov is 2x top speed for pavement^, with off-road varying (it's 0.8x for cross-country wheeled, 0.4x for standard wheeled, 0.2x for restricted wheeled, and varies by power/weight ratio for tracked vehicles). Com Mov is top speed times 0.463 or Tr Mov times 0.926. So, a cross-country wheeled vehicle with a top speed of 100 km/h has Tr Mov 200/80 and Com Mov 46/19 (46.3/18.52, rounded to the nearest).

For my own work, I've added a TL modifier to Tr Mov to account for cruising speeds being relatively lower compared to top speeds, poorer road conditions, and vehicles needing more time for maintenance during use (refilling a radiator with water, cooling the engine/brakes, lubrication, etc). For TL 4 (1910) it's 0.5, increasing to 0.6 at TL 5 (1930), 0.7 at TL 6 (1950), 0.75 at TL 7 (1970), 0.8 at TL 8 (1990), 0.85 at TL 9 (2000), and 0.9 at TL 10 (near-future).

^Officially, Com Mov is calculated first (at 0.463 * maximum speed in km/h), then Tr Mov is calculated as 4.32 * Com Mov. Since 0.463 * 4.32 = 2.00016, Tr Mov is just barely over 2 times the maximum speed and I round for convenience.

[pmulcahy11b]

Email sent.. :)

Send that again. I think it got lost in the works somewhere; I didn't get it or accidentally deleted it. Is TyCaine in the email address?

[TyCaine]

Thanks Vespers!

The general rules you gave help with the quick figuring certainly, though I'm noticing the stats I'm seeing on some don't quite pan out, though it's certainly a good start!

And thanks for letting me know, Paul, I re-sent the email so hopefully that works.


~Ty