Alternative Traveller Character Sheets

[ross]

So I’ve been working on my own alternative character sheet for my Traveller series. I’m not sure about it. So what I was thinking about is a she’s that doesn’t list every skill, but has space for up to 20 slots. It has room for alternate characteristics, backgrounds, life events, and education. It’s definitely two pages, and it doesn’t waste tons of white space for no utility. Sorry, I really don’t like the official version.
Does anyone else have custom sheets they prefer?
Here’s my take…

 

[rinku]

I've written a spreadsheet one, with drop down selection of skills. Also a section for zero skills, since you save space by not having to list level or speciality. Similar ultility for the gear sections, with some added columns for extras and the TL the equipment was manufactured at.

Also has a character portrait block (very important!) and a checkbox tracker for training. I need to add a speciality field on that part, though.

 

[rinku]

I've just noticed that the version I uploaded isn't working properly for the specialisations, which are done as a dependent data validation thing. Likely some edit mucked up the process, I'll see about getting it fixed. Skill selection is still working properly.

 

[ross]

I've just noticed that the version I uploaded isn't working properly for the specialisations, which are done as a dependent data validation thing.

I did notice that. Here’s wishing you luck!

 

[rinku]

This should be working fully now. I've now added a specialty selection for the skill being trained.
I also have it converted to .ods, but that's at home. Open Office will read the Excel version okay, but the training checkboxes are done differently and needed to be set up manually. Otherwise it all works.

Armour and Weapons are selected by name and a drop down list, with user entered Origin TL, Ammo carried and Notes. Other equipment is all user entry, since that stuff could be almost anything. I haven't locked the sheet to prevent accidentally deleting formulas yet, since it's still a work in progress.

The green characteristics under the red ones are meant to be the current values, which feed the characteristic modifier values. The red ones are the permanent values. I left both rows as user entry so that you can update as required. To reset drop down selections just delete the value in the field. Specialties will need to be blanked separately.

If you need lines for more skills or equipment it should be fairly easy to insert them, and subtract from one of the other sections, especially the diary. I like it all on one page, others may prefer to keep the log elsewhere. Go crazy.

 

[rinku]

And for those who might want to see how it looks but don't have Excel, or just want a preview:


And a character of mine:

 

[ross]

Great job, thanx!

 

[rinku]

I haven't catered for Psi yet. That should probably go in at some point, but I'm still to really look at the MGT2e22 Psi rules.

Any other suggestions? I'm deliberately leaving off vehicles and non-personal equipment.

 

[boggo2300]

And for those who might want to see how it looks but don't have Excel, or just want a preview:


And a character of mine:
View attachment 4101

you know there is a calender in discord with all those missing locations and dates down the bottom of the sheet

 

[rinku]

Yeah, but I may want to make private notes. The copy I work on at work isn't the same as the one I use at home. That has more details recorded.

 

[actionman]

Nice character sheet! I tried it out, the specialization drop down menu doesn't work. I made a character, and generating the character was an exercise in futility. Most terms he suffered injuries.

That got me thinking.

In 1968 during the Vietnam War, there were 543,000 U.S. military personnel in Vietnam. There were about 104,000 casualties, both KIA and WIA. That's about a 19% casualty rate.

In the Citizen Career, you have these survival rolls:
Job Roll Fail Chance Injury Chance Chance of Surviving a 20 Year Career
Corporate SOC 6+ 28% 8% 66%
Worker END 4+ 8% 2% 90%
Colonist INT 7+ 58% 17% 39%

Army Career
Branch Roll Fail Chance Injury Chance Chance of Surviving a 20 Year Career
Support END 5+ 17% 5% 77%
Infantry STR 6+ 42% 12% 53%
Cavalry INT 7+ 58% 17% 39%

Scout Career
Branch Roll Fail Chance Injury Chance Chance of Surviving a 20 Year Career
Courier END 5+ 17% 9% 62%
Surveyor END 6+ 42% 21% 31%
Explorer END 7+ 58% 29% 18%

Drifter Career
Branch Roll Fail Chance Injury Chance Chance of Surviving a 20 Year Career
Barbarian END 7+ 58% 29% 18%
Wanderer END 7+ 58% 29% 18%
Scavenger DEX 7+ 58% 29% 18%

Marine Career
Branch Roll Fail Chance Injury Chance Chance of Surviving a 20 Year Career
Support END 5+ 17% 9% 62%
Star Marine END 6+ 42% 21% 31%
Ground Assault END 7+ 58% 29% 18%

Math (this is off the cuff, I could be wrong):
Chance of failing survival roll as per https://www.gigacalculator.com/calculators/dice-probability-calculator.php. Calculate sum <= target number -1.
Injury chance = Survival fail chance x percent chance of injury on mishap table (it's .3 or .5, 2 results of injury or 3 results on 1D6).
Chance of 20 Year Career Survival = Injury chance ^5

Conclusions:
It's more dangerous to work a corporate job than to be in the Support branch of the Imperial Army.
Being a colonist is just as dangerous as being an Imperial Army Cavalry Trooper
Being a Rogue of any kind is about as dangerous as working a corporate job.
Being a Scout Explorer is as dangerous as being a Ground Assault Imperial Marine.
Being a Drifter Scavenger is as dangerous as being a Ground Assault Imperial Marine.
Being a Drifter Wanderer (pretty much a wandering space loser) is as dangerous as being a Ground Assault Imperial Marine.

The Imperium is rough. No wonder people are willing to go on expeditions to Zhodane and rescue people on Ruie. They're going to die anyway.

 

[rinku]

Make sure you use the sheet I uploaded today. The earlier one has the bug.
I should version them, actually.
If it's still not working, it could be the version of Excel I have at work vs other versions. But there are a couple of ways to do dependent drop down menus and the one I went with may not be best.