I had implied that I would share, and never got around to it....
Sample Character Sheet a la Spreadsheet.
The format and artwork is from the original: Twilight2000 PJ1 mod.xls. It was prettier than anything I would do. I got the original off the web. But since it was in a spreadsheet, I could not see why I shouldn't let it do the math.....
I added the calculations for secondary characteristics (Weight, Load, Throw Range, hits by location).
Yes, I know that in V2, you don't add skill and stat. That function was in place - the ONLY function in place, and it did not even grab the stat from the top of the sheet - and it was easier to not dismantle it.
I didn't use the Character creation page much, but it is available for use. (Character creation and background/biography was written up in a doc file; easier to manipulate the text.)
I added in the weapon Statistics by hand, but I have a DC character spreadsheet that includes a tab with items (including weapons) and their stats, cost, and weight. When you enter a weapon in the weapon area, it fills itself in; when you buy an item, you enter item and quantity it totals the cost. For a little extra effort, I could include which skill is to be used.
The last page is my work. As the character was starting out mounted with a bunch of stuff, I made a sheet calculating load by location (uses SUMIF function - sums values in one column if another column holds a matching value):
- Stuff the character wears is listed as self
- Stuff listed as location Pack is in his backpack; the total for Pack includes the weight of the pack itself, and teh item Pack uses the total for it's weight.
- Stuff on the horse (saddle, saddlebags etc) is listed as Horse, and includes the total for Self and the character's weight
- P1 and P2 are pack horses, each with a separate pack saddle.
This way, you can add or subtract items as needed or switch locations, and the spreadsheet just re-totals.
In most cases, you won't need anything quite so elaborate, this will manage "Self", pack, and vehicle just as well - just replace "Horse" with "Vehicle" (or however else you want to ID the location).
Uncle Ted