|
| 32 people marked this as a favorite. |
So I posted this on reddit, but my buddy suggested I post it here too. I saw all the rules for ships about build points, PCUs, all the systems and thought, "Oh boy, time to make another spreadsheet!" It's my natural response to all life's problems. DATA. I'm kind of obsessed. My wife and children miss me, but now that I'm done, I can actually use it to PLAY.
ANYWAY, here's a spreadsheet I made that you can use to do all that hard math for you. I'm up for suggestions and constructive criticism, all that.
Hey thanks, that's awesome! I can't wait to use this to help my players design their first starship. Incredible!
Only problem I see is that the second power core line doesn't seem to work.
Ah, I see. Cool thanks!
Thank you for this! Awesome job.
Very nice
Awesome!
Possible bug: Once I decided on an option in a category (for example, Mk I armor), I could not reset that one category to have no option selected. Perhaps include a blank option at the top of all of the lists.
|
Awesome!
Possible bug: Once I decided on an option in a category (for example, Mk I armor), I could not reset that one category to have no option selected. Perhaps include a blank option at the top of all of the lists.
Backspacing the entire entry is an available option and does remove the choice and point cost.
Very nice work. Thank you. I can now construct ships to destroy my PCs'!
|
|
Awesome!
Possible bug: Once I decided on an option in a category (for example, Mk I armor), I could not reset that one category to have no option selected. Perhaps include a blank option at the top of all of the lists.
You're right. Not making a choice is still a choice.
Can't do blanks. The data validation automatically filters out blanks. Would you settle for a '-'.He makes a little 'meh' face. lol.
In the process of adding non choices now. Some (like drift engine) already had an N/A or NONE. Others, like frame, you have to pick, so no weaseling out of choosing one of those, mister.
Really nice! The output is beautiful! I still need more familiarity with the options (as it is, I'm discovering what they do AS I select them), but this is so well organized!
|
|
Again, I like to give options. I started with just the ship sheet like in the back of the book as the default printable output, but then I was looking at the stat blocks for the NPC ships and thought, "what if a game master, sorry, I mean STAR MASTER, wants to generate NPC ships or something?" I tried to emulate the book's style as much as possible without paying $40 for a font.
btw, Jura size 10 looks pretty close to whatever font Paizo uses, for anyone else interested in making their own sheets or tables.
Very cool. Thanks!
|
|
Very cool, but I found a few things:
The sheet won't let you link array weapons
The bonus to piloting checks from "maneuverability" and "thruster speed" are being added to the ships AC and TL in the "pilot bonus" spot.
The "Misc Mods" box isn't being added into the AC/TL calculation.
Any modifiers to "turn", like from the heavier armor, isn't being adjusted.
The "critical threshold" isn't being modified when the ship's HP changes do to higher tiers
If you link two weapons that have a "x10" damage it won't show up once they're linked
Thanks for the feedback. I'll look into it this evening after putting the kids to bed.
|
|
Any modifiers to "turn", like from the heavier armor, isn't being adjusted.
So what do you guys think I should do for this? If your turn goes up, does that change the name of your maneuverability?
For instance, you start at perfect (turn 0). You armor up your ship and it adds to to turn. Which one of these do you have?
average (turn 2)
or
perfect (turn 2)
Or maybe... should I note it by saying
perfect (turn 0 + 2 from armor)
?
|
|
So what do you guys think I should do for this? If your turn goes up, does that change the name of your maneuverability?Honestly I have no idea....
Or maybe... should I note it by saying perfect (turn 0 + 2 from armor)?That how I would do it for now.
Making some changes now. I decided that the build sheet reflects BASE STATS while the stablock and ship sheet reflect AUGMENTED STATS. So a fighter with perfect maneuverability and heavy armor actually has augmented average maneuverability.
Still have a couple of things to fix, but I've worked through much of the list. Keep the bug reports coming!
This could be a very useful spreadsheet, but it doesn't appear to include the BP costs for adding or upgrading weapon mounts. They're on p. 305, under "Upgrading Systems."
Oh, so it does. It doesn't display anything until there's actually a weapon associated with it, which is what threw me off. If it's being accounted for, though, it's a rather lesser issue - unfilled weapon mounts should probably be charged, but it's hardly as critical. And on the note of lesser issues, the word you want for the stat block is "complement," not "compliment." That's a very easy mistake to make, and I've done it too a few times.
Outside those two things, though, I haven't found anything that looks to be unknown. Good work!
|
|
| 1 person marked this as a favorite. |
The maneuverability disappears on the statblock and ship sheet if the "turn" rating goes above 4. (Like a Dreadnought with Mk9+ armor)
The Mk9-10 mono- and duonode computers aren't showing up in the drop down list
Tiny size ships(Racer, Interceptor, and Fighter) are letting you pick a quality level of crew quarters, but according to page 298 tiny size ships don't have them.
If you have 4 of the same weapon in the same arc and you link the top two then try to link the bottom two, the top damage value will disappears. PIC In general having 4 of the same weapon causes issues with the weapon output on the statblock and ship sheet. PIC
Let me know if anything else needs updating.
I think one thing which is missing on the official sheet is, what component need how much PCU.
Would be intressting to see this on the sheet if the players want to make upgrades or have to decide to power down systems because theit main power core is wrecked and they have to switch to a backup system or to see what systems can stay alive when preparing for a drift jump.
Mhhh.. anyone else have problems if you download it and try to open it with Excel?
This is nothing short of amazing
Awesome thanks!
I really should have noticed earlier, but this doesn't display Systems correctly in the statblock. Or more accurately, it doesn't seem like it displays anything at all. The "Systems" part of the stat block should at least say what the computer, sensors, crew quarters, armor, and defenses are, and that's also where security features and computer countermeasures would go. Right now I don't think that part of the statblock is actually doing anything.
|
|
I really should have noticed earlier, but this doesn't display Systems correctly in the statblock. Or more accurately, it doesn't seem like it displays anything at all. The "Systems" part of the stat block should at least say what the computer, sensors, crew quarters, armor, and defenses are, and that's also where security features and computer countermeasures would go. Right now I don't think that part of the statblock is actually doing anything.
Welp, it's because I put the sort inside of the filter instead of outside the filter. OBVIOUSLY. Can't believe I didn't see it. I think I fixed it. Try to break it again. This is how progress is made.
You forgot to increment the version number of the spreadsheet file itself, but I believe that's the only error I can see at the moment. The Systems section appears to be working correctly now.
|
|
| 1 person marked this as a favorite. |
This is brilliant. I just spent a couple hours (admittedly I was also learning the system) building my first starship. I plugged it into your spreadsheet, and found errors that had crept in my accounting for PCU/BP. Helped me clarify my thinking.
Thank you so much!!
You are very welcome. I like to think I'm doing Triune's work.
Currently, I'm working on something now to do the same thing with weapon fusions, augmentations, armor mods, and other item things. Who has time to do all that math? I'll make a post in homebrew when I'm done, but here's what I've got so far.I'm having a bit of trouble wrapping my head around fusions, especially multiple fusions on the same weapon, so it's helpful to work out that confusion with a spreadsheet. My current problem is limiting the dropdowns so you can only select:
Fusions is hard!
Awesome work, excellent job.
Thank you!
|
For the spaceship ship sheet, it would be great if there was a place to track current shield levels.
I play online, and we're thinking of using this as our 'current' starship sheet. It's just so handy! Any thoughts of customization in this direction, or should I munge something together myself for our needs?
|
|
For the spaceship ship sheet, it would be great if there was a place to track current shield levels.
I play online, and we're thinking of using this as our 'current' starship sheet. It's just so handy! Any thoughts of customization in this direction, or should I munge something together myself for our needs?
I live to serve. Done.
|
|
| 2 people marked this as a favorite. |
So I posted this on reddit, but my buddy suggested I post it here too. I saw all the rules for ships about build points, PCUs, all the systems and thought, "Oh boy, time to make another spreadsheet!" It's my natural response to all life's problems. DATA. I'm kind of obsessed. My wife and children miss me, but now that I'm done, I can actually use it to PLAY.
ANYWAY, here's a spreadsheet I made that you can use to do all that hard math for you. I'm up for suggestions and constructive criticism, all that.
Hey Nickela! John from starfinderSRD.com here! Would you mind if I made this available on starfinderSRD.com?
| 1 person marked this as a favorite. |
Hey Nickela this is great. Is there a way of exporting the finished statblocks?
|
|
| 2 people marked this as a favorite. |
Hey Nickela! John from starfinderSRD.com here! Would you mind if I made this available on starfinderSRD.com?So I posted this on reddit, but my buddy suggested I post it here too. I saw all the rules for ships about build points, PCUs, all the systems and thought, "Oh boy, time to make another spreadsheet!" It's my natural response to all life's problems. DATA. I'm kind of obsessed. My wife and children miss me, but now that I'm done, I can actually use it to PLAY.
ANYWAY, here's a spreadsheet I made that you can use to do all that hard math for you. I'm up for suggestions and constructive criticism, all that.
Do it to it. Give proper credit and all that.
|
|
| 1 person marked this as a favorite. |
Hey Nickela this is great. Is there a way of exporting the finished statblocks?
I actually just did some prettifying on the statblock. I'll look into a way to export it. Maybe put a big EXPORT button at the top.
You could always COPY/PASTE into another spreadsheet or onto a new tab. Or onto a Google Doc. It looks like this when you do it.