Excel Ship Designer v2025.06.22b

[mavikfelna]

On the profitability tab, or the ship info tab, can you set up a spot for a partial mortgage? I have a ship, a converted Animal Class Safari Yacht, that I purchased used after selling my lab ship and I have something like 1.2MCr on the mortgage left. So for profitability I'd like to add the monthly mortgage amount, 38026 cr, to the expenses. Also, the crew is paid in shares, not salary, so could we get a toggle for setting crew salaries to 0?

Also, how do I account for Fuel/Cargo containers on the Profitability tab? We're currently doing a Jump 1 and 20 tons of mail in a fuel/cargo container as well as 15 tons of cargo filling our cargo bay. The spreadsheet is complaining that it's overweight.

 

[Arkathan]

On the profitability tab, or the ship info tab, can you set up a spot for a partial mortgage? I have a ship, a converted Animal Class Safari Yacht, that I purchased used after selling my lab ship and I have something like 1.2MCr on the mortgage left. So for profitability I'd like to add the monthly mortgage amount, 38026 cr, to the expenses. Also, the crew is paid in shares, not salary, so could we get a toggle for setting crew salaries to 0?

Also, how do I account for Fuel/Cargo containers on the Profitability tab? We're currently doing a Jump 1 and 20 tons of mail in a fuel/cargo container as well as 15 tons of cargo filling our cargo bay. The spreadsheet is complaining that it's overweight.

New Version: 2025.06.21
Crew Tab now toggles between Salary and Shares
Under Quirks on the Ship's Info Tab, there is a purchase price override. On the Summary, Mortgage will show the revised starting principle on the loan.
Cargo/Fuel bays now count on Profitability Tab

 

[mavikfelna]

New Version: 2025.06.21
Crew Tab now toggles between Salary and Shares
Under Quirks on the Ship's Info Tab, there is a purchase price override. On the Summary, Mortgage will show the revised starting principle on the loan.
Cargo/Fuel bays now count on Profitability Tab

Ok, one more ask. Can you put in a toggle on the profitability page to do every 2 weeks instead of monthly?

 

[Arkathan]

Ok, one more ask. Can you put in a toggle on the profitability page to do every 2 weeks instead of monthly?

New Version: 2025.06.21a
Added Variable Report to Profitability Tab that lets you specify any number of days to compare with any number of jumps.

 

[Arkathan]

Minor update

New Version 2025.06.22

Fixed an error with costs of Jump software when using an optional rule reduced price core computer.
Terry suggested adding Cargo and Passenger fields to handle Pods, modules and carried craft that might not show up on the main craft sheet.
Added ability to show additional fuel purchases for calculating expenses

Edit: Stand by. Terry broke it.

 

[Terry Mixon]

Minor update

New Version 2025.06.22

Fixed an error with costs of Jump software when using an optional rule reduced price core computer.
Terry suggested adding Cargo and Passenger fields to handle Pods, modules and carried craft that might not show up on the main craft sheet.
Added ability to show additional fuel purchases for calculating expenses

And I already broke it.

 

[Arkathan]

2025.06.22a
Fixed validation issues

 

[Raekur]

Profitability sheet / Cell E22 should the formula be =G22-B20-B22 so it pulls available from Medium DO instead of Basic?

 

[Arkathan]

Profitability sheet / Cell E22 should the formula be =G22-B20-B22 so it pulls available from Medium DO instead of Basic?

Basic either goes as steerage in a cargo bay, or as a double occupancy Middle Stateroom. (2 tons per person)
As such, in the passenger section a basic passenger takes up a Middle Stateroom. This is why if you have a middle passenger left and only one basic passenger, you should reclassify the stateroom as single occupancy in the stateroom tab so you can maximize profits.

So in a nutshell, Middle DO and Basic draw from the same room pool.


Edit: The outside additions is what is messed up. Both need to go to G20, and G22 needs to just mirror G20

 

[Arkathan]

Error Fix
2025.06.22b

Outside additions from modules/carried ships now properly share the same pools of staterooms as the Stateroom Tab rooms.