Ship Designer Excel Document


General Discussion

Scarab Sages

1 person marked this as a favorite.

Fellow Starfinders!

I created a quick spreadsheet to aid in ship design. Hope it helps. There are a few little idiosyncrasies to the design of start ships (like Array weapons). Feel free to provide feedback on bugs or mistakes.

Go to Starship Designer


Looks cool, but whenever I change the "Tier" I get this error "The data you entered in cell B2 violates the data validation rules set on this cell.", that said I've only run it in GoogleDocs and Open Office, so that may be the problem.


How many crew fit in a single crew quarters?


I haven't encountered any problems. I like it, thank you.


The spread sheet looks pretty awesome! Great job!

I don't think the drift engine BP cost gets factored into the total remaining BP though.

I am also running into an issue when attempting to change the tier, but it looks like it should work. Maybe it's an issue with the fractions being options? -shrug- I'll poke at it later and see if I can figure it out.

Scarab Sages

Umbral Reaver wrote:
How many crew fit in a single crew quarters?

The book just says you pay for Common, Good, or Luxurious. I assume it covers the maximum number needed for the frame of the ship. For example, a Transport can hold six crew. Common crew quarters are free in BP, good 2, luxurious 5. It doesn't change with the frame size. A Dreadnought can have luxurious crew quarters for 5 BP. Seems a little strange but that's how it reads.

Scarab Sages

Amith wrote:

The spread sheet looks pretty awesome! Great job!

I don't think the drift engine BP cost gets factored into the total remaining BP though.

I am also running into an issue when attempting to change the tier, but it looks like it should work. Maybe it's an issue with the fractions being options? -shrug- I'll poke at it later and see if I can figure it out.

I will take a look at it. I may have forgot to add in the cell to the total calculation. Thanks.

Scarab Sages

sunderedhero wrote:
Looks cool, but whenever I change the "Tier" I get this error "The data you entered in cell B2 violates the data validation rules set on this cell.", that said I've only run it in GoogleDocs and Open Office, so that may be the problem.

I saw that too and thought i cleared it up. I made the cell into Text to accommodate the fractions for the tiers below one and I think it doesn't like it. I will look at it tonight.

Scarab Sages

8/15/17 Updates
-Fixed the error thrown by Tier selection
-Updated the Total BP to subtract for the Drift engine

Scarab Sages

I see when using Google sheets there is a validation error. I don't get that in Excel but I am looking at it.

Edit: After testing, it appears that running it in Google Sheet seems to corrupt the data validation. I suggest running it locally in Excel.


I think I figured out how to get it working in GoogleDocs and Open Office, you just have to make the tier box change format to plain text. EXAMPLE


Shaun Kyle Ortego is in the process of making an app to do this as well, just his ALpha testing apparently https://www.facebook.com/DarkbriarGamingStudios/

Will be good to have a free spreadsheet as well thou :) TY


Quick and useful tool.

Thank you for putting it together.

Community / Forums / Starfinder / Starfinder General Discussion / Ship Designer Excel Document All Messageboards

Want to post a reply? Sign in.
Recent threads in Starfinder General Discussion