Here's a worksheet for calculating powered ground vehicle stats.
It requires the use of the article 'Describing Vehicles' in Pyramid magazine, volume 3, issue 120.
https://docs.google.com/spreadsheets/d/1LFi3xRQV9S2y-R75Exf3Bfap_kfIlUi--i894WoMZ6s/edit?usp=sharing
Instructions:
First, make a copy of the sheet so that you can edit it.
Then enter the necessary data in the input tab.
Each column (B-K) can be used for a different vehicle, if you want to work on several at once.
First select whether you want to use metric or US customary units. You have to stay consistent within each column.
The vehicle name row should be self-explanatory.
Year is the year it was first produced. This will output a TL based on the dates in GURPS High-Tech. Only TL 5-9 is covered.
Loaded weight is in kg (if metric units are used) or lbs. (if using US customary ones). If you don't enter a loaded weight, it should be calculated automatically so long as you provide a curb weight and load.
Curb weight is also in kg or lbs.
Empty weight is in kg or lbs. If you leave it blank, it will be calculated automatically if you have a curb weight and a fuel capacity (the sheet assumes that fuel is 6 lbs. per gallon).
Load is in kg or lbs. If you have a loaded weight and a curb weight, you can leave it blank and the sheet should calculate the correct value.
Fuel is either diesel or gasoline. The only reason this matters is because gasoline-fueled vehicles are flammable and diesel-fueled ones aren't. If your vehicle uses something weird, choose based on flammability. Modern batteries tend to be flammable.
Fuel capacity is in litres or US gallons.
Length is in metres or feet.
Shape is usually 'boxy' but see Describing Vehicles for guidance.
Handling, Stability, and Health are as in Describing Vehicles. Note that the only form of fragile available is 'f', which is added automatically to gasoline-fueled vehicles.
Motive power is in kW or horsepower.
Top speed is in kmph or mph.
Terrain is either 'all-terrain' or 'road-bound'. Generally speaking, anything with all-wheel drive or tracks is the former, while other wheeled vehicles are the latter, but use common sense. Road-bound vehicles add an asterisk to their move.
Acceleration to... is the speed which the vehicle's acceleration time is measured against. This is usually 100 kmph or 60 mph.
...in seconds is how long it takes to achieve the above speed. These two numbers can be left blank so long as you have a motive power figure to estimate acceleration from.
Crew is how many people the vehicle needs to operate all its systems.
Passengers is how many extra seats it has. This can be left blank.
Occupancy code is the letters which appear after Occ. numbers. A for long-term accomadations, F for air-filters, etc.
DR 1 is the vehicle's main DR. This is compulsory.
DR 2 is for a secondary DR score if required. This can be left blank.
Fuel consumption is in kilometres per litre or miles per gallon. This is optional if you have a Range.
Range is in km or miles. This can be left blank if you have numbers for both fuel capacity and fuel consumption, in which case it will calculate automatically.
Price is in GURPS dollars, which are roughly equivalent to US dollars betweeen 2000 and 2010. If you leave this blank the sheet will estimate a cost based on the guidelines in Describing Vehicles.
Locations is just the string of letters and numbers which describe the vehicle's locations.
Notes should be in the form [1][2][3]... you will have to add the actual notes yourself.
After entering all the necessary information, you can go to the Stats tab to see the output. The HTML tab gives the same information, formatted for easy pasting into a HTML table.
