Members | Sign In
Modiphius > STAR TREK: ADVENTURES
avatar

Character Creation Spreadsheet

posted Jul 05, 2017 13:25:28 by hartusa
Hi!

I've been tinkering with a character creation spreadsheet in Open Office. It automatically calculates everything for character creation - stats, disciplines, damage bonuses etc. You just pick choices each step and that's it. It also does starship creation. It doesn't use any external scripts or macros. Just simple table lookups.

EDIT:

Here is the NEW link Google Sheets version 2.0. (the old link does not work anymore):

https://docs.google.com/spreadsheets/d/1Y8YaFKdHhEipEeYXbLrD_bxXA5AGTujaP9yj0dCaWHI/edit?usp=sharing

You don't need to install any additional software to use this. Just print or save to PDF the the Sheet and ShipSheet. Or you can download the entire thing as Excel or other format.
[Last edited Mar 19, 2018 14:53:03]
page   1 2 next last
16 replies
avatar
SteveHanson said Jul 05, 2017 15:28:06
By all means, please post it
Forum Moderator

To his friend a man
a friend shall prove,
To him and the friend of his friend;
But never a man
shall friendship make
With one of his foeman's friends.
--Havamal
avatar
PatricHenson said Jul 05, 2017 15:31:19
That looks nice. I won't claim to know much about legal matters, far too pedantic for my tastes, but I think others have posted homebrew character sheets without issue.

*In the meantime, Steve has spoken! lol

By the way, I really like your example character's values! I might copy some of those at some point! He sounds like a guy I'd like to serve on a starship with.
[Last edited Jul 05, 2017 15:32:15]
"Lease and pong life. Prosp long and liver."
—Varek of Sulkin'
avatar
Aldaron said Jul 05, 2017 18:03:19
That looks great, HTusa - much more professional-looking than mine, and it does the character creation as well? Love to see it! :)
avatar
AllenShock said Jul 06, 2017 02:11:57
Very nice!
avatar
Eric Stearns said Jul 06, 2017 05:21:00
POST! POST! POST! POST!
What? A little sophomoric college-type peer pressure now and again never hurt anyone.
Well, almost never.
Hardly ever?
Usually doesn't?
avatar
TomK said Jul 06, 2017 09:53:45
Hi HTusa.

Within OpenOffice you should be able to save the file as a .xls, which will aid those of us working from mobile devices. I look forward to seeing the sheet!
avatar
hartusa said Jul 06, 2017 10:33:32
Here is the Google Sheets version. You don't need to install Open Office or Excel or whatever for this:

https://docs.google.com/spreadsheets/d/1U9cCqw7rNirMeFa6P2NQNhvPhL2sKZnM2yi9T4gmQ1Y/edit#gid=1730875424

You can download the Excel or Open Office version from that. Just print or PDF export the Sheet and ShipSheet for the end result sheet.
avatar
TomK said Jul 06, 2017 12:34:19
Looks great, HTusa. Any chance you could let us know how to add custom classes, talents and weapons?
avatar
hartusa said Jul 06, 2017 14:36:04
TomK, it's not possible. Opening up the data section for everyone to edit brings the very real chance of someone accidentally nuking the whole thing.

But you can simply download the Open Office or the Excel version and edit it as much as you want.
avatar
Eric Stearns said Jul 07, 2017 02:56:20
Looks good - nice and concise.
avatar
hartusa said Jul 07, 2017 10:10:38
Thanks.

And by the way, as a general note, if you use the sheet, you might want to make a copy (File -> Make a copy) or download (File -> Download as) first. Unless you want everyone to see the characters and ships you make.
avatar
hartusa said Jan 11, 2018 16:11:33
Hi!

I don't know how many of you still use this, but I've been updating my character and ship creator again here and there. Incorporated errata, added some features, and changed the layout so it looks better and prints/exports right for everyone (as Google doesn't allow embedding fonts, for obvious reason). It is pretty feature complete, and I'm mostly awaiting for the Command book.

But I was thinking of adding description of the Talents into the sheet, like they're in all the pregen characters. Would this be okay, since it does use material from the book directly? Want to make sure before I add anything.

Thanks.
avatar
StephenBirks said Jan 11, 2018 16:25:57
I'd seen this sheet elsewhere in its previous state. It's come a long way since then. Looking good

I didn't where I found it when I was first adding stuff to the Resource Wiki, but it is linked now
avatar
StephenBirks said Jan 11, 2018 17:00:15
Looking at your sheet makes me want to update my own. For some reason I was drawing an absolute blank about changing colours for departments, which is on my to-do list. I've looked at yours and realised; Bloody Conditional Formatting!

so err... thanks!
avatar
hartusa said Mar 19, 2018 14:51:10
Hi!

The creator sheet has been updated to 2.0. Lots of changes and additions, including:

* Material from Command Division and Beta Quadrant books (the info I have is second hand as I don't have the books yet, so there are probably errors)
* Section for Character Development
* Section for creating Supporting Characters (and added a second page into the print/export sheet to accommodate them)
* New Custom tab for adding homebrew material into the creator. Species, Talents, weapons, spaceframes etc. etc.
* Smaller stuff like enlisted ranks, rank name variations, reorganization, corrections and such

Unfortunately, Google Sheets really doesn't like it when I try to update the online sheet from the version I worked with offline, so I basically had to upload a new file. That means the old link doesn't work anymore. So please update the links if you have posted this on a wiki or a website or whatever.

The new link:
https://docs.google.com/spreadsheets/d/1Y8YaFKdHhEipEeYXbLrD_bxXA5AGTujaP9yj0dCaWHI/edit?usp=sharing

Enjoy!
Login below to reply: