2e ship design spreadsheet?

[bluekieran]

Does anyone have a ship creation spreadsheet they're willing to share? The task clearly calls for one and I don't want to make my own if it's totally unnecessary!

Also, it looks to me like a "close structure" hull over a "standard" one is something of a no-brainer, given reduced cost and extra hull points, unless I'm missing something?

I'm thinking my first project will be a somewhat munchkiny "hard trader" in the 250-ton range, though I doubt I'll let my travellers near it at the outset.

 

[bluekieran]

First attempt gives me a 250-ton "Hard Trader" for 72mil;

Streamlined hull
Crystaliron armor
M-drive 3, J-drive 2
TL12 fusion plant with headroom for a two triple-turrets and 3 beam lasers (not included, but 5Mcr extra with a couple of missile racks and a sandcaster)
Fuel tank for jump + 8 weeks
Computer/5/bis
Military grade (+0) sensors.
Solar panels, fuel processor (40/day) and scoop.
10 staterooms, 6 low berths, 10t common area.
82 tons of cargo space and a crane.

Sadly my spreadsheet skills aren't really up to making something more modular/usable than the linked Gsheet.

Comments welcome; this is only my first ship design

 

[bluekieran]

First attempt gives me a 250-ton "Hard Trader" for 72mil

Admittedly a 200-ton version is actually better - down to 64-70tons (depending on exact build) of cargo space, but costing a little under MCr60.

200-ton version

 

[bluekieran]

Okay, so I have googled some spreadsheet tricks and made a start on a proper, modular spreadsheet. Have got as far as section 7 (sensors) of HG2.

Take a look, and let me know if you spot any errors:
https://docs.google.com/spreadsheets/d/1eD6FzG7a7QnYo21tUWisvPi9OvcpBXxTV6GcBRAJfcU/edit?usp=sharing

 

[Jak Nazryth]

I just got the Core Book this past weekend and I'm still going through the changes between MgT1 and MgT2.
I picked up HG2 a couple days ago and have only had a change to skim through it.
I love the change to Power Plant Output now, and power requirements for the drives, weapons, and other systems... in stead of simply matching "A, B, Z" with the highest drive. Love the battery back up idea, even though I've only glanced at it.
So I can't comment on your design yet, but the spreadsheet looks good!

 

[EldritchFire]

Okay, so I have googled some spreadsheet tricks and made a start on a proper, modular spreadsheet. Have got as far as section 7 (sensors) of HG2.

Take a look, and let me know if you spot any errors:
https://docs.google.com/spreadsheets/d/1eD6FzG7a7QnYo21tUWisvPi9OvcpBXxTV6GcBRAJfcU/edit?usp=sharing

Minor change: hardpoints are 1 per every full 100dT and thus should be rounddown, not roundup.

 

[bluekieran]

Minor change: hardpoints are 1 per every full 100dT and thus should be rounddown, not roundup.

Fixed, thanks.

 

[bluekieran]

Conditional drop-downs (i.e., two hardpoint options if tonnage indicates it's a small ship with a firmpoint, all options otherwise, and later hardpoints may or may not be available) are proving tricky at the moment... I could always just trust the user to know what they're meant to have available, I guess, but I am fussy.

Also would be nice to "hide" rows for unavailable turrets/weapons, I will have to see if that's a thing. More googling is in my future!

 

[steve98052]

I haven't had a chance to look over the spreadsheet yet, but one trick I often use is to have an input and calculation sheet, and a results sheet. I even have a way to skip blank lines on the results sheets, which I can share after I get a chance to look at one of my sheets that use it on a computer.

 

[thintzmann]

Okay, so I have googled some spreadsheet tricks and made a start on a proper, modular spreadsheet. Have got as far as section 7 (sensors) of HG2.

Take a look, and let me know if you spot any errors:
https://docs.google.com/spreadsheets/d/1eD6FzG7a7QnYo21tUWisvPi9OvcpBXxTV6GcBRAJfcU/edit?usp=sharing

Thanks! I had a similar spreadsheet in progress and this helped me find some errors on my side. Kinda wish I had remained blissfully ignorant of the error I had on my armor tonnage.

You might wanna check B78 on the data sheet. I think it should be .025 instead of .25?

 

[bluekieran]

Thanks! I had a similar spreadsheet in progress and this helped me find some errors on my side. Kinda wish I had remained blissfully ignorant of the error I had on my armor tonnage.

If you know how to do conditional drop-downs and/or have a row-hiding script[1] that works, drop me a PM!

You might wanna check B78 on the data sheet. I think it should be .025 instead of .25?

Hmm, right you are - 1 ton per 2.5% of plant size per week rather than 25%! Fixed, thanks.


[1] or better method of not displaying loads of empty hardpoints for a small ship

 

[bluekieran]

Okay, so my spreadsheet is coming along nicely, and (barring the software) can now build a Far Trader. Naturally as soon as I tried to do so, I discovered that my minimum power plant and jump drive size assumptions were off, but I've corrected those.

The cost, though, is showing as MCr58.1405, MCr6 more (with jump software added) than the same ship in HG2; though pleasingly, I get MCr58.2405 just adding up the figures on the Far Trader page! Is there some reason HG2 knocks 6 mil off the price (that it's a standard design, perhaps), or is it an error?

Looking at the other stats, I think they've also transposed the power requirements for basic ship systems and the M-drive, unless I'm somehow misreading the rules! That also means you need to power down some of the Basic Ships Systems to use the Jump Drive, but I guess that's not a problem.

 

[Jeraa]

Okay, so my spreadsheet is coming along nicely, and (barring the software) can now build a Far Trader. Naturally as soon as I tried to do so, I discovered that my minimum power plant and jump drive size assumptions were off, but I've corrected those.

The cost, though, is showing as MCr58.1405, MCr6 more (with jump software added) than the same ship in HG2; though pleasingly, I get MCr58.2405 just adding up the figures on the Far Trader page! Is there some reason HG2 knocks 6 mil off the price, or is it an error?

Looking at the other stats, I think they've also transposed the power requirements for basic ship systems and the M-drive, unless I'm somehow misreading the rules!

Standard designs (High Guard page 8 ) receive a 10% discount. Adding up everything in the price column on page 116 gives me a total of MCr58.648. Subtract 10% and you get MCr52.7832, which is what is listed.

The ships in the book do contain errors, so you might not necessarily get the same results.

Edit: I used the wrong ship. The Far Trader on 118 has a cost of MCr58.145. Applying the standard design discount gives you MCr52.3305. Not what is listed in the book. But if you remove the cost of the jump software before you apply the standard design discount (MCr58.045 total without software), then apply the discount, you get MCr52.2405, which is what is listed in the book.

Software should not be included in the standard design ship discount, but it seems like on some ships it is.

 

[AndrewW]

Software should not be included in the standard design ship discount, but it seems like on some ships it is.

The software gets included in the discount, consider it like a multi use license.

The price for the Far Trader should be: MCr52.4205 (with a 10% discount being a standard design).

 

[bluekieran]

Just finished getting all the basics in: https://docs.google.com/spreadsheets/d/1eD6FzG7a7QnYo21tUWisvPi9OvcpBXxTV6GcBRAJfcU/edit?usp=sharing

You'll need to make a copy to use it as the above link is read-only.

Don't yet have options to harden systems, or use alternative TLs for cost/size/etc improvements, and there are a few other things (such as hiding systems the ship is too small for) that I want to get to, but the sheet does already hide quite a few sub-options that aren't valid (such as incorrect bridge sizes or backup computer specs).

Please let me know if you spot any errors!