This looks great Nickela! I look forward to using this for my game's custom starship building.
Apologies if this has already been mentioned, but as of v1.62 the BP cost of many of the thrusters are off. Specifically, all the thrusters for Medium ships are too costly, and all the thrusters for Large and larger ships are too inexpensive (at least as compared to the chart on pages 296-297 of the CRB). Hopefully this doesn't come off as a complaint, just trying to give you some feedback on something that's easy to miss.
|
| 1 person marked this as a favorite. |
Is there any way to boost the number of expansion bays on the build tab beyond 20 that I can do easily on my end? I ask because I'd like to use the ship frames from LPJ Design's Warp Speed! Expanded Starship Creation. The generation ship from that product has 30 bays.
Hmmm...no?
Each bay has a custom menu that is built based on previous choices (since some items take 2 bays).If you look on the expansion bays sheet, each pair of columns has possible choices....sigh. Let me type up a step sheet here.
...
...
...
Man, screw this. I just updated it...unhide the columns on the build sheet for the extra bays... Adding the rows on the build sheet is the easy part, but having to explain my logic on the expansion bays sheet...you've got to add 20 more columns and then create named ranges for each of the choice columns, make sure the arrays point to the right sections of the select sheet and then change the data validation ranges on the build sheet to reflect your 10 new named ranges. I like to use named ranges because updating the range once changes all the formulas in the entire sheet to reflect the new range. Setting it up is kind of a bear. I just need to learn to say no...:P IN THE FUTURE, take this as an opportunity to learn how to spreadsheet better.
Anyway, make sure you add your new frame to the homebrew section on the frames page and let me know how it turns out.
I was about a third through my own when I thought to look and see if someone had beat me to it.
Great job.
@Nickela:
Hi there, I'm not sure if you are still working on this sheet, but want to add a request. Would it be possible to instead of choosing the Tier of a ship to be able to enter a BP value?
My group is playing with a system where the BPs aren't given by level up, but throughout the adventures in parts.