I’ve been interested in Stargrave and while I have plenty of painted miniatures I have zero inspiration to create a crew, even less desire to puzzle over 52 powers, stat mods and what not. I want my friends to be empowered to start playing whenever we gather, not be blocked by record keeping before we even start.
Inspired by online RPG character generators (e.g. save vs total party kill) I’ve built a Google Sheet that randomly generates a Stargrave Captain & First Officer quickly. It produces things like…
There is a good deal of error checking here, but there could be a few bugs lurking especially on the 4th & 3rd powers for the Captain & First Officers respectively. I’ll continue to fine tune that section, but the tool works well enough for the stated objective.
Thank you to the Reddit user u/5eret who compiled the power list, that was my data set for this project. Without your work my task would have been much more difficult.
In my hobby today I use so much tech, it’s like I was born and raised in Silicon Valley or something. Desktop publishing was the boon of the 90s while teetering on the edge of the always connected internet age. Now digital is everywhere, it is everything, it is the tools I use daily – you probably do too.
One of my favorite aspects of RPGs are deeply nested random tables which create a staggering array of combinations while yielding unexpected results. The best of these can take a good deal of dice rolling, note taking, and inspired interpretation. Not really a tool that can be used “in game”, but that all changes when we go digital.
Behold the power of: =index(Lookup!Y3:Y32,match(RANDBETWEEN(1,30),Lookup!$K3:$K32,0))
What is this strange gibberish you say? Simply the logical power of a digital array (spread sheet) that provides instantaneous lookup against random entry (dice rolls) from a given table.
Want to know something special about a city – push a button:
Maybe you need an NPC for that city – push a button:
Or maybe you have favorite tables you’d like to convert to a digital solution, for instant generation from nearly anywhere. Here’s a Google Sheet sample that you can study and build your own thing. Doesn’t make sense? Ping me and I’ll walk you through it, we’ll record a video of that and post it here.