Excel Ship Designer v2025.03.06b
- Thread starter Arkathan
- Start date
Terry Mixon
Emperor Mongoose
Ah. That could mess someone up.
Arkathan
Emperor Mongoose
New Version: 2025.02.02
Fixed User defined weapons and hardpoint - Thanks for finding that, Terry
Class - Role displays on the Summary
The Summary now indicates if a Computer is the Backup
Weapons in multi-use turrets are now separated by commas in the Summary listing
Fixed User defined weapons and hardpoint - Thanks for finding that, Terry
Class - Role displays on the Summary
The Summary now indicates if a Computer is the Backup
Weapons in multi-use turrets are now separated by commas in the Summary listing
Arkathan
Emperor Mongoose
Fixed
New Version 2025.02.07
Scientific Operations Suites count as laboratories for purposes of Fabricators.
John Hogan
Mongoose
Thank you very much for your time and effort!
Arkathan
Emperor Mongoose
So, in the Modular Cutter discussion, Fluffy Bunny Feet pointed out something I missed:
So I fixed the spreadsheet to work that way. BUT, I added three House Rule toggles to let you ignore various parts of this rule.
New Version: 2025.02.08
Planetoid Hulls more compliant with HG'22
Fixed a power calculation for Hardpoint 1 when Mixed Use is active.
So I fixed the spreadsheet to work that way. BUT, I added three House Rule toggles to let you ignore various parts of this rule.
New Version: 2025.02.08
Planetoid Hulls more compliant with HG'22
Fixed a power calculation for Hardpoint 1 when Mixed Use is active.
Thank you very much for making and upkeeping this awesome spreadsheet. I really like mongooses T2 High Guard 2022 but I just wish someone would use your spreadsheet to check ship designs before books get published. The amount of errors in ship write ups is ludicrous, they give us these great and easy to use ship design rule yet 2/3 of their own ship write ups don’t follow these rules in one way or another. From ignoring crew or other requirements, miss added tonnage, description not matching, to just plain not thinking when converting.
Arkathan
Emperor Mongoose
There has been a suggestion on another thread to include refits in the spreadsheet.
The only way I see to do this is to make a separate tab, or if it gets too big, a tab for major and minor refits, and have the user fill it in on the honor system, with the final design in the old tabs being the newly refit design.
Basically, you'd figure out what the old component was, how much it cost and its volume, and then enter that same data for the new components. That would give you a cost and time of refit by TL/extra yard space, check for using too much tonnage, and add the listing to the Summary tab.
Does any one have any suggestions, or quality of life requests on this matter - keeping in mind that I am NOT going to rewrite the entire spreadsheet to include a remove/add to each line item, but am amenable to including drop downs to select component names on the new tab(s) where applicable, plus some blank fields to fill in as you wish.
The only way I see to do this is to make a separate tab, or if it gets too big, a tab for major and minor refits, and have the user fill it in on the honor system, with the final design in the old tabs being the newly refit design.
Basically, you'd figure out what the old component was, how much it cost and its volume, and then enter that same data for the new components. That would give you a cost and time of refit by TL/extra yard space, check for using too much tonnage, and add the listing to the Summary tab.
Does any one have any suggestions, or quality of life requests on this matter - keeping in mind that I am NOT going to rewrite the entire spreadsheet to include a remove/add to each line item, but am amenable to including drop downs to select component names on the new tab(s) where applicable, plus some blank fields to fill in as you wish.
Terry Mixon
Emperor Mongoose
As I said in the other thread, I was seeing if you wanted to revise the ship, not the spreadsheet.
J. L. Brown
Emperor Mongoose
So the idea is that someone could design a TL 9 'Birdsong' Cargo Hauler, and then immediately see what that hull could be updated to at some higher TL? That seems like an extremely useful bit of functionality for refs who want to do some world-building / history. The appeal might be somewhat limited compared to the incredible and obvious utility of the original sheet; but it seems like something I would certainly use.
Geir
Emperor Mongoose
A refit thing would be cool, but for the specific example, I was trying to envision what it would look like if you got the basic ship - hull, engine, compartment, cockpit etc., and then put in locally made lower TL engines and, well in this case, electronics don't matter, since it was an over-speced TL11 computer.As I said in the other thread, I was seeing if you wanted to revise the ship, not the spreadsheet.
Maybe a way to spit out a lot of variants off a single base design? And no, I can't think of an easy way to do it.
(And even the example that comes to mind, the F35 A, B, and C doesn't have the same airframe, so anyway... too late in the day to think.)
Arkathan
Emperor Mongoose
Perhaps several tabs, then. This would work for recording modular ships as well. Refit would over write the original summary and be limited to the first tab/tab set. Others would report after the main summary with the changes as variants/ different modules.
IF I can get it to work
boggo2300
Mongoose
Hey!
I just noticed that even though High Guard says Cargo Cranes mass 2.5 + 0.5 per 150 tons of cargo, the two ships with cargo cranes in the book (the Far, and Free Traders) only have them massing 2.5 ton however they both have less than 150 tons cargo space, the spreadsheet basically calculates them to 3 tons (so you cannot build a by the book Free Trader for example.)
I just noticed that even though High Guard says Cargo Cranes mass 2.5 + 0.5 per 150 tons of cargo, the two ships with cargo cranes in the book (the Far, and Free Traders) only have them massing 2.5 ton however they both have less than 150 tons cargo space, the spreadsheet basically calculates them to 3 tons (so you cannot build a by the book Free Trader for example.)
