Arkathan
Emperor Mongoose
I am testing out a Ship Designer in MS Excel for personal, non-commercial use.
If anyone wants to point out errors - politely - feel free to take a look.
Change log:
July 2021 - July 8 update: Numerous changes up to the Sensors tab. Will be working on the Weapons tab next.
July 26: New Weapons Tab - .1 fixed Record sheet issue; .2 Fixed an issue with HP02 and HP03 Cost calculations
July 28: Bug fixes
July 29: Updated Screens Tab, bug fix
October 8: requested changes to how the crew calculates broke the monthly salary calculation when added a column. That's fixed.
November 18: Fixed an error that caused you to pay for a grav screen whether you bought one or not.
November 25: Fixed an issue with the calculations for cargo cranes and loading ramps.
December 17: Found an issue with single laser turrets and the SSD page.
January 4 2022: Updated Stealth Jump to conform with Highguard Errata. Now uses one Mod slot.
January 8: Corrected an issue with Sensors on the SSD.
January 21: A typo in a drop down list affected mixed weapon turrets
March 14: Fixed maintenance on Ship's Info tab and the Record Sheet. Fix for compatibility on Weapons tab power formula
March 15 - Fix for the fix on Fix for compatibility on Weapons tab power formula
August 6 - Implemented many of the changes from High Guard Update 2022... still a few missing, such as Hop and Skip drives.
August 7 - Fixed new function of Intellect software. Added Battle Network. Corrected drop downs on mixed turrets. Corrected Sick bay for new 3 patient limit. External link removed
August 12 - The new stats for Ion Cannon Barbettes from today's update to HG2/U2022 has been included/ M-Drive TL's match update
August 14 - Pressure Hulls (thanks Spartan159), Common Area Options. A few other fixes, like stealth jump. Concealed Drives replaces stealth for M-Drives. Armor now calculates correctly with sphere and streamlined hull configurations.
August 18 - Implemented Gauss and Laser PBDs. Added Battle Loadout in parentheses for power on the Record Sheet. Hopefully will help when determining if/when you need to shut off systems due to damage. Fixed Mod calculations for drives/power plants so that costs for increased or decreased drive/plant volume is not calculated, only the cost of the mod, per HG examples.
August 20 - Corrected small craft barbettes for the new 3 firm point usage.
August 21 - Form tools removed, since they do not work on free versions of Excel.
August 25 - Fixed PDBs not displaying correctly on SDDs. Fixed Power sometimes not calculating correctly on Record Sheet after adding Battle Load.
August 26 - Big bridges should now work properly. SSD Critical Chart uses Core 2022 chart now. Made the Critical Chart more legible.
September 6 - Added TL 16 Computers and sensor options from Behind the Claw.
September 7 - Fixed issue with the first three hardpoints and power mods.
September 25 - Added Stations, Modules and research facilities.
September 27 - Small Craft barbettes no longer cost three times the listed value.
September 30 - Small modules can hold big weapons without throwing errors.
October 20 - Non-Excel compatibility issue fixed with Grapples and Forced Interlink Apparatus.
October 27 - Mineral detection suites now take up space, as intended.
February 25 - Fixed issues with cargo section. Automated reduced crew requirements on large ships.
March 3 - Fixed Agriculture factories for stations (and big portable industrial ships).
March 14/15 - Implemented Traveller Companion Ship Automation and limited data mining to the ship's main computer level. J7-9 control programs added.
March 18 - Implemented Advanced Repulsor Bays (HG2022-pg34)
July 21 - Cannonades and the GP Mass Driver from the Companion Update 2024 are implemented.
July 29 - Command bridges add 40 tons; Point Defense Batteries do not automatically add gunners to crew requirements.
August 4 - Fixed an issue where small craft firmpoint barbettes use three times as much energy as they should.
August 11 - Corrected tables in the weapons tab returning out of range TL.
August 12 - Fixed an error that crept into some crew calculations.
August 13 - Corrected prices on weapon bays, changed the Aux bridge calculation and clarified the Add Command Bridge fields. Modular hulls now cost less per dTon as intended. All hull option costs are added on Record Sheet.
August 29 - Virtual Gunner in computer tab now subtracts from required gunners in the Crew Tab. Virtual Crew remains manual via the Custom Crew setting.
September 07 - Reminder for Virtual Crew added to crew page. Correction to Officer calculation.
December 12 - Fixed a circular reference in commercial crew calculations. Implemented Fuel/Cargo Containers.
April 10 - Solar Panels are now supported. Small weapon mounts should comply with HG22.
August 6 - SSD now correctly reports the DM for superior sensors from Behind the Claw.
September 30 - Implemented Hop and Skip Drives. Core computers reduce jump software to 0 Cr. Split out munitions types in Cargo Tab. Fixed issues resulting from those changes.
October 5 - Implemented Deep Space Manoeuvering Systems
October 13 - Revised Military Gunnery crew calculations
October 21- Multiple Accumulators allowed. When using adjusted tonnage for drives, the jump section of fuel now uses that same number for its calculations.
October 25- Added Total Fuel Capacity reminder to the Fuel Purification area; New Capital Ship SSD, located after Cargo Tab; Laser Bays and Burst lasers implemented, laser barbettes conform to Traders and Gunboats
-a: Hotfix to fix sandcasters being out of range in mixed turrets
-b: Sensop crew/station calculations
October 28- Fixed a problem with Core110 computers.
Added table listing ratings at given tonnage based on current engines
a- Fixed bug with DSMS on Record Sheet
b- Sensor stations set at 1/7500 instead of crew size. Warning for unofficial builds.
November 11- Computer Brains
Fuel/Cargo Containers can use the main tanks and can have cargo cranes and loading belts. Due to the ability to use main tanks, it will be in the Fuel tab and the Summary's Fuel Section.
Craft are now supported. Because of clamps, I can't do an automatic comparison of craft vs docking capacity. You are on your own there.
I think I finally fixed the add-on Command Bridge... even though I could swear I had that one done a while ago
Thanks to Terry Mixon for the fabricator/deconstructor section on the 9b-Optional Tab
Cargo bays can now be separately armored, as can magazine storage.
The Summary replaces most of the Record Sheet.
November 15- Solomani equipment from Rim Expeditions added
November 18- Fixed the issue with large vehicle bays having the same entry in both slots, thus not having an Hazardous rated version.
Aux Cons can be designated as SCC's.
Designating an an Aux Con as a SCC in a module now deactivates error notification.
Thanks again to Terry Mixon, for adding more craft to the list.
-a: Expanded utility of Miscellaneous crew and allowed for better definition of certain General Crew members with toggles to subtract Misc categories from General Crew so they don't overlap.
November 19- Fixed the Solomani Research Scoop. No longer standard on all ships. (Oops)
Fiddled with crew some. Extra crew can be added, that won't go away with ship size or automation.
Added ship expenses to the Summary and Ship Info page
Added Low Emissions to M-Drive mods
You can select between normal and concealed Docking Spaces and Hangar Bays
-a Fixed error in Summary Total
November 20- Implemented Pods. Use Module on Ship's Info, but say YES for fully spaceworthy pod. That will let you get away with no bridge, get the cost reduction for no gravity and put a power plant inside. It CAN have SCC's.
Modules no longer make you put a scanner in, so you can go to zero without hitting an error
The Record Sheet Tab is gone. The Summary Tab replaces it.
Non-gravitic hulls now properly reduce power requirements.
-a Fixed software remaining when computer removed.
November 22- Summary now includes the Narrative from Ship's Info Tab.
Supply Units now reported, and an internal hold is available to reserve that tonnage in. While ANY cargo hold counts towards the daily supply points, for now only the dedicated hold calculates how many days of supplies are available.
337 vehicles/craft/riders now available. Thanks Terry.
-a Improved the calculation for supply units
Terry suggested calculating supplies based on extended missions, so either 100 days or the weeks your power plant's fuel is designed to last.
In each case, the number of minimum days is reported in the Cargo tab and the number of days you have is displayed in the summary.
November 26- Changed the way Long Range mod reports. Previously it was Rng +1 to avoid tripping over missiles.
Now it bump the weapon's reported range by one step.
Terry supplied more craft! Over 380 supported so far.
December 8 - Modified systems so early prototype jump engines can have software.
Added another batch of vehicles from Terry Mixon
Implemented Short Duration Maneuver Drives
Implemented Gel Heat Management Systems
-a Railgun Barbettes show up again
Small Craft Fuel rule implemented
December 13 - Glorious Empire Slave Quarters added.
Companion 2024 Weapons, except for spinal mounts, implemented.
Over 480 standard carried vehicles and spacecraft available. Thanks, once again Terry.
Gravity Shields from the Companion are also implemented.
No Bridge Drone Ships
December 17 - Fixed the Summary, so small craft do not tell you that the free airlock(s) is/are not actually there.
You can toggle interplanetary seating to be counted for anyone, not just those listed as passengers.
Requested feature to also do page counts for tonnage and power have been implemented... placed where space was available, but highlighted and connected to make them easy to spot.
-b hotfix to make all accommodations count for small craft when toggled
December 25- Added Disintegrator spinal mounts from Companion
Changed damage on spinals to xK instead of x1000 so it will fit better in the space in the SSD's
-a Screens has a custom space so you can define a different type of screen. When filled out, it will appear in the Globe Generator's drop down
-b Fixed bug where burst lasers on small craft had no range.
-c Bays were not displaying all selections
Custom Hardpoint was not selectable
Longer range small craft weapons no longer benefit from the long range mod. A warning will color the mod field yellow to alert you that the mod might not work.
-d Hotfix
December 29- Updated Jump/Hop/Skip in the summary to make range clearer.
Added a toggle on the ship info tab to turn on/off mortgage payments
Implemented suggestions from Prodromoi:
Power plant mod changed to Increased Power, counts as two mods
Cylinder hull spelling corrected
Hull points and amount of radiation shielded show on Summary
Added Notes for airlocks, which appear on summary
2025: Jan 01 - Updated the way Multi-Environmental Spaces report
Fixed more spelling errors
The summary for training was off by one field. Fixed
Added user-defined descriptors for labs, studios and training facilities.
-a hotfix for tonnage calculation on Staterooms tab
-b hotfix for powerplant small mod
Jan 06 - Fixed a fault in the Power Distribution calculations
Added a toggle on the Screens tab to let you determine whether Grav Screens are crewed or not.
Implemented Sword Worlder Integrated Munitions System to Spinal Mounts. When installed, each missile magically becomes the size of a sand cannister.
Eliminated conditional formatting that didn't like armour being greater than hull points.
Pods are now their own type.
Ship and Station now both use their size for crew reduction
Jan 10 - Modules and Pods use the size of the mother ship for their crew reduction
You can now use that toggle for Grav Screens.
Ranges show up on the SSD's again.
35 ton craft show the correct number of firmpoints. Thanks Terry.
Fixed Virtual Gunner
Jan 11 - Small Weapons fix
Jan 17 - Replaced Installed/Not Installed with a notes field for docking bays, hangars and Launch Recovery. This allows you to name the group and eliminates the annoying additional step for these components.
Mod Names are closer to the book value, and weapons mods that are not allowed for a weapon type are removed for that type. (If you wish to implement those mods, they can be created in the custom weapon slots)
Added some alien components for which I either have the rules or was able to deduce stats from official designs.
-a Hotfix to correct summary display of clamps
-b Hotfix. Turrets #2 and #3 were not displaying cost correctly after reworking Mods
-c Hotfix. Turret 3 going exponential on power. Feature request to calculate stewards based on staterooms
Jan 19 - The steward calculation has been changed again. Wholly based on passenger accommodations.
Crew and passenger accommodations have been split. This will allow a (not particularly near) future update to include and evaluate moral/quality for serving crews/passenger contentment and recommendations.
Fixed a problem with Backup FTL mods and excess load calculation
Jan 20 - Installing an Adjustable Hull negates the extra cost of pop-up turrets.
Jan 22 - Terry Mixon submitted a change to get the Summary Page to display numbers in the text fields to show comma separations for large numbers.
Terry also suggested adding a TOTAL CREW line to the summary.
Jan 26 - Optional Section Shading on the Summary Tab
Cost of First-in-Class listed below cost on Ship's Info Tab
Construction Time Calculator added to Ship's Info Tab
Feb 02 - Fixed User defined weapons and hardpoint
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
-a Hotfix for user defined hardpoints
Feb 7 - Scientific Operations Suites count as laboratories for purposes of Fabricators.
Feb 8 - Planetoid Hulls more compliant with HG'22
Fixed a power calculation for Hardpoint 1 when Mixed Use is active.
Feb 21 - Borderland vehicles and small craft included for carried craft - Thanks Terry!
More conversions away from H/V Lookup.
Mar 6 - Adjusted more displays to show decimal fractions
WIP on one box for standard HG'22 Hull Configurations and another for a secondary description.
Mar 17 - Ramscoops implemented
Mar 22 - Fixed a problem with the fuel scoops error showing on the ram scoop, and the fuel scoop error not reporting correctly
Fixed a few fields that Terry found that had no comma separations. Thanks Terry.
Mar 23 - Can replace med bay beds and low berths with autodocs
Corrected calculation of total low berth power
Mar 27 - Added vehicles from Reach Adventure #9. Thanks Terry
Apr 03 - Stealth tonnage now reports correctly on Summary.
Apr 05 - Summary updated to show Sensor TL Errors and improper Free Fuel Scoop Use on Fuel Tab.
-a Corrected error in formula in Fuel tab error checking that drove the Summary nuts if you streamlined your hull.
Apr 08 - Implemented request for Robotics Labs from the Robot handbook.
-a Updated Vaults to HG'22
Apr 11 - Implemented Riverland additions implemented
-a minor adjustment (commas in some numbers), Fabricator prototypes
-b Spheres no longer counted as planetoid, and vice versa, in the Hull Tab.
Apr 14 - Implemented Internal Aquatic and Internal Deepwater Evironments
Apr 18 - Implemented rules for required steward levels in the Crew Tab
Automated adding required passenger storage in the Cargo Tab.
TM5 - Fixed error with entertainment section
change to passenger storage reporting
-a Passenger Storage goes away on Summary when = Zero.
May 01 - Summary, Hull and Drive Tabs updated for Breakaway Hull calculations.
Robotic Crew added to Crew Tab
Induction Plates added to Robotic Facilities on 9-b Options Tab (You do not need a robotics lab for them to work)
Adjusted TL for Fuel Tanks to cover Low TL sources.
A Custom Fuel Storage type was added to the Fuel Tab. You can choose Hull, Internal Cargo or External Cargo as sources of space for your custom fuel tanks.
Custom Accommodations were added to the Stateroom Tab.
-a Fixed interplanetary seating toggle for crew
-b minor text fix
-c minor text fix
-d Toggle Allowing Power Plants on Modules to emulate bad official designs
-e Fixed a #VALUE error caused by other changes
-Drone Ship bridges no longer cause an error, and provide zero seats for small craft
May 03 -If there is no computer, the TL's for non-existent programs goes to zero.
Military gunners no longer calculate to a negative, no matter how many virtual gunners you buy
-a The default basic sensor TL now goes to zero when you set QTY to zero.
Same with the Sol excursion bays on Tab 9b.
-b Eliminated Vlookup from sensors, so they report correctly and don't need "Class I,..." to keep them in alphabetical order
The summary now lists cost of passenger cabin space, and if you toggle Use interplanetary Seating on a small craft, it adds to passenger accommodations
-c Fixed issue with stateroom armored bulkheads
-d Fixed issue with Aux Sensors
-e Fixed more issues with Aux Sensors
May 08 -Various bug fixes associated with changing Vlookup and Hlookup to Index(Match)
Minor feature requests noted above.
May 09 -Toggle on Ship's Info Tab that controls Unused Space message in the Cargo area of the Summary.
Expanded the decimal points on the unused space field on the cargo tab to 3.
-a Rounded Unused space to 2 digits to avoid "Zero Hunting"
May 13 -Robotic Crew triggers Crew tag in Summary
May 31 -Terry added 0-8 Robot sizes for Robotic Labs. also two more user defined slots. I have those duplicated on my sheet and working in the Summary.
Stirling Fission Plants are now supported.
Removed rounding from the power plant fuel calculation as it was giving large numbers on super-small plants with years-long operating times.
June13 -Hardpoint cost no longer affected by weapon modifications.
June 20 -Fixed an error that crept in from changes affecting small craft turret/firmpoint costs
Sheet now checks for more than one small turret again
SSD moved to end of sheet with the Capital SSD
Added Optional CSC proto/retro handling of Ship's Computers, within the limits of HG customization. (2 proto, 3 High tech levels)
Added a profitability tab to (hopefully) help to calculate how much you might expect to make on standard or various runs
-a Fixed Crew Salaries on the Profitability Tab
-b High Passage reflects Core Rulebook
-c Update to Profitability Tab function
Standby Luxury Passengers in High Staterooms
Robot costs added to purchase price with toggle
Robot maintenance added to ship's maintenance
-d Included the calculations for freight that I missed
Quirks now implemented, bottom right on Ship's Info Tab
-e Terry updated Profitability to show a month's profit and added Fuel costs
Terry increased Robot skill max to 8
June 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
-a Added Variable Report to Profitability Tab that lets you specify any number of days to compare with any number of jumps.
June 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
-a Fixed validation issues
-b Outside additions from modules/carried ships now properly share the same pools of staterooms as the Stateroom Tab rooms.
June 29 -Removed minimum fuel for small craft rule due to conflict with newer publication
July 06 - Fixed a typo in quirks (Thanks Terry)
Fixed Railgun stats (Thanks DigrizJB)
-a Fixed an issue with the Full Collapsible Fuel Tank equation on the Cargo tab.
July 07 - House Rule toggle applying the Small Craft Fuel Rule to all ships.
Current Version: v2025.07.06a
July 10 - Power Tab's Power Distribution expanded to include station systems- Good catch Mavikfelna
Revised Retro computers for unlimited reductions instead of only three - Thanks Terry
Thanks to Another Dilbert, MingtheMirthless and DigrizJB for identifying bugs. Thanks to Terry Mixon for the formatting update and sensor correction, fabricators and help on craft tables
If anyone wants to point out errors - politely - feel free to take a look.
Change log:
July 2021 - July 8 update: Numerous changes up to the Sensors tab. Will be working on the Weapons tab next.
July 26: New Weapons Tab - .1 fixed Record sheet issue; .2 Fixed an issue with HP02 and HP03 Cost calculations
July 28: Bug fixes
July 29: Updated Screens Tab, bug fix
October 8: requested changes to how the crew calculates broke the monthly salary calculation when added a column. That's fixed.
November 18: Fixed an error that caused you to pay for a grav screen whether you bought one or not.
November 25: Fixed an issue with the calculations for cargo cranes and loading ramps.
December 17: Found an issue with single laser turrets and the SSD page.
January 4 2022: Updated Stealth Jump to conform with Highguard Errata. Now uses one Mod slot.
January 8: Corrected an issue with Sensors on the SSD.
January 21: A typo in a drop down list affected mixed weapon turrets
March 14: Fixed maintenance on Ship's Info tab and the Record Sheet. Fix for compatibility on Weapons tab power formula
March 15 - Fix for the fix on Fix for compatibility on Weapons tab power formula
August 6 - Implemented many of the changes from High Guard Update 2022... still a few missing, such as Hop and Skip drives.
August 7 - Fixed new function of Intellect software. Added Battle Network. Corrected drop downs on mixed turrets. Corrected Sick bay for new 3 patient limit. External link removed
August 12 - The new stats for Ion Cannon Barbettes from today's update to HG2/U2022 has been included/ M-Drive TL's match update
August 14 - Pressure Hulls (thanks Spartan159), Common Area Options. A few other fixes, like stealth jump. Concealed Drives replaces stealth for M-Drives. Armor now calculates correctly with sphere and streamlined hull configurations.
August 18 - Implemented Gauss and Laser PBDs. Added Battle Loadout in parentheses for power on the Record Sheet. Hopefully will help when determining if/when you need to shut off systems due to damage. Fixed Mod calculations for drives/power plants so that costs for increased or decreased drive/plant volume is not calculated, only the cost of the mod, per HG examples.
August 20 - Corrected small craft barbettes for the new 3 firm point usage.
August 21 - Form tools removed, since they do not work on free versions of Excel.
August 25 - Fixed PDBs not displaying correctly on SDDs. Fixed Power sometimes not calculating correctly on Record Sheet after adding Battle Load.
August 26 - Big bridges should now work properly. SSD Critical Chart uses Core 2022 chart now. Made the Critical Chart more legible.
September 6 - Added TL 16 Computers and sensor options from Behind the Claw.
September 7 - Fixed issue with the first three hardpoints and power mods.
September 25 - Added Stations, Modules and research facilities.
September 27 - Small Craft barbettes no longer cost three times the listed value.
September 30 - Small modules can hold big weapons without throwing errors.
October 20 - Non-Excel compatibility issue fixed with Grapples and Forced Interlink Apparatus.
October 27 - Mineral detection suites now take up space, as intended.
February 25 - Fixed issues with cargo section. Automated reduced crew requirements on large ships.
March 3 - Fixed Agriculture factories for stations (and big portable industrial ships).
March 14/15 - Implemented Traveller Companion Ship Automation and limited data mining to the ship's main computer level. J7-9 control programs added.
March 18 - Implemented Advanced Repulsor Bays (HG2022-pg34)
July 21 - Cannonades and the GP Mass Driver from the Companion Update 2024 are implemented.
July 29 - Command bridges add 40 tons; Point Defense Batteries do not automatically add gunners to crew requirements.
August 4 - Fixed an issue where small craft firmpoint barbettes use three times as much energy as they should.
August 11 - Corrected tables in the weapons tab returning out of range TL.
August 12 - Fixed an error that crept into some crew calculations.
August 13 - Corrected prices on weapon bays, changed the Aux bridge calculation and clarified the Add Command Bridge fields. Modular hulls now cost less per dTon as intended. All hull option costs are added on Record Sheet.
August 29 - Virtual Gunner in computer tab now subtracts from required gunners in the Crew Tab. Virtual Crew remains manual via the Custom Crew setting.
September 07 - Reminder for Virtual Crew added to crew page. Correction to Officer calculation.
December 12 - Fixed a circular reference in commercial crew calculations. Implemented Fuel/Cargo Containers.
April 10 - Solar Panels are now supported. Small weapon mounts should comply with HG22.
August 6 - SSD now correctly reports the DM for superior sensors from Behind the Claw.
September 30 - Implemented Hop and Skip Drives. Core computers reduce jump software to 0 Cr. Split out munitions types in Cargo Tab. Fixed issues resulting from those changes.
October 5 - Implemented Deep Space Manoeuvering Systems
October 13 - Revised Military Gunnery crew calculations
October 21- Multiple Accumulators allowed. When using adjusted tonnage for drives, the jump section of fuel now uses that same number for its calculations.
October 25- Added Total Fuel Capacity reminder to the Fuel Purification area; New Capital Ship SSD, located after Cargo Tab; Laser Bays and Burst lasers implemented, laser barbettes conform to Traders and Gunboats
-a: Hotfix to fix sandcasters being out of range in mixed turrets
-b: Sensop crew/station calculations
October 28- Fixed a problem with Core110 computers.
Added table listing ratings at given tonnage based on current engines
a- Fixed bug with DSMS on Record Sheet
b- Sensor stations set at 1/7500 instead of crew size. Warning for unofficial builds.
November 11- Computer Brains
Fuel/Cargo Containers can use the main tanks and can have cargo cranes and loading belts. Due to the ability to use main tanks, it will be in the Fuel tab and the Summary's Fuel Section.
Craft are now supported. Because of clamps, I can't do an automatic comparison of craft vs docking capacity. You are on your own there.
I think I finally fixed the add-on Command Bridge... even though I could swear I had that one done a while ago
Thanks to Terry Mixon for the fabricator/deconstructor section on the 9b-Optional Tab
Cargo bays can now be separately armored, as can magazine storage.
The Summary replaces most of the Record Sheet.
November 15- Solomani equipment from Rim Expeditions added
November 18- Fixed the issue with large vehicle bays having the same entry in both slots, thus not having an Hazardous rated version.
Aux Cons can be designated as SCC's.
Designating an an Aux Con as a SCC in a module now deactivates error notification.
Thanks again to Terry Mixon, for adding more craft to the list.
-a: Expanded utility of Miscellaneous crew and allowed for better definition of certain General Crew members with toggles to subtract Misc categories from General Crew so they don't overlap.
November 19- Fixed the Solomani Research Scoop. No longer standard on all ships. (Oops)
Fiddled with crew some. Extra crew can be added, that won't go away with ship size or automation.
Added ship expenses to the Summary and Ship Info page
Added Low Emissions to M-Drive mods
You can select between normal and concealed Docking Spaces and Hangar Bays
-a Fixed error in Summary Total
November 20- Implemented Pods. Use Module on Ship's Info, but say YES for fully spaceworthy pod. That will let you get away with no bridge, get the cost reduction for no gravity and put a power plant inside. It CAN have SCC's.
Modules no longer make you put a scanner in, so you can go to zero without hitting an error
The Record Sheet Tab is gone. The Summary Tab replaces it.
Non-gravitic hulls now properly reduce power requirements.
-a Fixed software remaining when computer removed.
November 22- Summary now includes the Narrative from Ship's Info Tab.
Supply Units now reported, and an internal hold is available to reserve that tonnage in. While ANY cargo hold counts towards the daily supply points, for now only the dedicated hold calculates how many days of supplies are available.
337 vehicles/craft/riders now available. Thanks Terry.
-a Improved the calculation for supply units
Terry suggested calculating supplies based on extended missions, so either 100 days or the weeks your power plant's fuel is designed to last.
In each case, the number of minimum days is reported in the Cargo tab and the number of days you have is displayed in the summary.
November 26- Changed the way Long Range mod reports. Previously it was Rng +1 to avoid tripping over missiles.
Now it bump the weapon's reported range by one step.
Terry supplied more craft! Over 380 supported so far.
December 8 - Modified systems so early prototype jump engines can have software.
Added another batch of vehicles from Terry Mixon
Implemented Short Duration Maneuver Drives
Implemented Gel Heat Management Systems
-a Railgun Barbettes show up again
Small Craft Fuel rule implemented
December 13 - Glorious Empire Slave Quarters added.
Companion 2024 Weapons, except for spinal mounts, implemented.
Over 480 standard carried vehicles and spacecraft available. Thanks, once again Terry.
Gravity Shields from the Companion are also implemented.
No Bridge Drone Ships
December 17 - Fixed the Summary, so small craft do not tell you that the free airlock(s) is/are not actually there.
You can toggle interplanetary seating to be counted for anyone, not just those listed as passengers.
Requested feature to also do page counts for tonnage and power have been implemented... placed where space was available, but highlighted and connected to make them easy to spot.
-b hotfix to make all accommodations count for small craft when toggled
December 25- Added Disintegrator spinal mounts from Companion
Changed damage on spinals to xK instead of x1000 so it will fit better in the space in the SSD's
-a Screens has a custom space so you can define a different type of screen. When filled out, it will appear in the Globe Generator's drop down
-b Fixed bug where burst lasers on small craft had no range.
-c Bays were not displaying all selections
Custom Hardpoint was not selectable
Longer range small craft weapons no longer benefit from the long range mod. A warning will color the mod field yellow to alert you that the mod might not work.
-d Hotfix
December 29- Updated Jump/Hop/Skip in the summary to make range clearer.
Added a toggle on the ship info tab to turn on/off mortgage payments
Implemented suggestions from Prodromoi:
Power plant mod changed to Increased Power, counts as two mods
Cylinder hull spelling corrected
Hull points and amount of radiation shielded show on Summary
Added Notes for airlocks, which appear on summary
2025: Jan 01 - Updated the way Multi-Environmental Spaces report
Fixed more spelling errors
The summary for training was off by one field. Fixed
Added user-defined descriptors for labs, studios and training facilities.
-a hotfix for tonnage calculation on Staterooms tab
-b hotfix for powerplant small mod
Jan 06 - Fixed a fault in the Power Distribution calculations
Added a toggle on the Screens tab to let you determine whether Grav Screens are crewed or not.
Implemented Sword Worlder Integrated Munitions System to Spinal Mounts. When installed, each missile magically becomes the size of a sand cannister.
Eliminated conditional formatting that didn't like armour being greater than hull points.
Pods are now their own type.
Ship and Station now both use their size for crew reduction
Jan 10 - Modules and Pods use the size of the mother ship for their crew reduction
You can now use that toggle for Grav Screens.
Ranges show up on the SSD's again.
35 ton craft show the correct number of firmpoints. Thanks Terry.
Fixed Virtual Gunner
Jan 11 - Small Weapons fix
Jan 17 - Replaced Installed/Not Installed with a notes field for docking bays, hangars and Launch Recovery. This allows you to name the group and eliminates the annoying additional step for these components.
Mod Names are closer to the book value, and weapons mods that are not allowed for a weapon type are removed for that type. (If you wish to implement those mods, they can be created in the custom weapon slots)
Added some alien components for which I either have the rules or was able to deduce stats from official designs.
-a Hotfix to correct summary display of clamps
-b Hotfix. Turrets #2 and #3 were not displaying cost correctly after reworking Mods
-c Hotfix. Turret 3 going exponential on power. Feature request to calculate stewards based on staterooms
Jan 19 - The steward calculation has been changed again. Wholly based on passenger accommodations.
Crew and passenger accommodations have been split. This will allow a (not particularly near) future update to include and evaluate moral/quality for serving crews/passenger contentment and recommendations.
Fixed a problem with Backup FTL mods and excess load calculation
Jan 20 - Installing an Adjustable Hull negates the extra cost of pop-up turrets.
Jan 22 - Terry Mixon submitted a change to get the Summary Page to display numbers in the text fields to show comma separations for large numbers.
Terry also suggested adding a TOTAL CREW line to the summary.
Jan 26 - Optional Section Shading on the Summary Tab
Cost of First-in-Class listed below cost on Ship's Info Tab
Construction Time Calculator added to Ship's Info Tab
Feb 02 - Fixed User defined weapons and hardpoint
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
-a Hotfix for user defined hardpoints
Feb 7 - Scientific Operations Suites count as laboratories for purposes of Fabricators.
Feb 8 - Planetoid Hulls more compliant with HG'22
Fixed a power calculation for Hardpoint 1 when Mixed Use is active.
Feb 21 - Borderland vehicles and small craft included for carried craft - Thanks Terry!
More conversions away from H/V Lookup.
Mar 6 - Adjusted more displays to show decimal fractions
WIP on one box for standard HG'22 Hull Configurations and another for a secondary description.
Mar 17 - Ramscoops implemented
Mar 22 - Fixed a problem with the fuel scoops error showing on the ram scoop, and the fuel scoop error not reporting correctly
Fixed a few fields that Terry found that had no comma separations. Thanks Terry.
Mar 23 - Can replace med bay beds and low berths with autodocs
Corrected calculation of total low berth power
Mar 27 - Added vehicles from Reach Adventure #9. Thanks Terry
Apr 03 - Stealth tonnage now reports correctly on Summary.
Apr 05 - Summary updated to show Sensor TL Errors and improper Free Fuel Scoop Use on Fuel Tab.
-a Corrected error in formula in Fuel tab error checking that drove the Summary nuts if you streamlined your hull.
Apr 08 - Implemented request for Robotics Labs from the Robot handbook.
-a Updated Vaults to HG'22
Apr 11 - Implemented Riverland additions implemented
-a minor adjustment (commas in some numbers), Fabricator prototypes
-b Spheres no longer counted as planetoid, and vice versa, in the Hull Tab.
Apr 14 - Implemented Internal Aquatic and Internal Deepwater Evironments
Apr 18 - Implemented rules for required steward levels in the Crew Tab
Automated adding required passenger storage in the Cargo Tab.
TM5 - Fixed error with entertainment section
change to passenger storage reporting
-a Passenger Storage goes away on Summary when = Zero.
May 01 - Summary, Hull and Drive Tabs updated for Breakaway Hull calculations.
Robotic Crew added to Crew Tab
Induction Plates added to Robotic Facilities on 9-b Options Tab (You do not need a robotics lab for them to work)
Adjusted TL for Fuel Tanks to cover Low TL sources.
A Custom Fuel Storage type was added to the Fuel Tab. You can choose Hull, Internal Cargo or External Cargo as sources of space for your custom fuel tanks.
Custom Accommodations were added to the Stateroom Tab.
-a Fixed interplanetary seating toggle for crew
-b minor text fix
-c minor text fix
-d Toggle Allowing Power Plants on Modules to emulate bad official designs
-e Fixed a #VALUE error caused by other changes
-Drone Ship bridges no longer cause an error, and provide zero seats for small craft
May 03 -If there is no computer, the TL's for non-existent programs goes to zero.
Military gunners no longer calculate to a negative, no matter how many virtual gunners you buy
-a The default basic sensor TL now goes to zero when you set QTY to zero.
Same with the Sol excursion bays on Tab 9b.
-b Eliminated Vlookup from sensors, so they report correctly and don't need "Class I,..." to keep them in alphabetical order
The summary now lists cost of passenger cabin space, and if you toggle Use interplanetary Seating on a small craft, it adds to passenger accommodations
-c Fixed issue with stateroom armored bulkheads
-d Fixed issue with Aux Sensors
-e Fixed more issues with Aux Sensors
May 08 -Various bug fixes associated with changing Vlookup and Hlookup to Index(Match)
Minor feature requests noted above.
May 09 -Toggle on Ship's Info Tab that controls Unused Space message in the Cargo area of the Summary.
Expanded the decimal points on the unused space field on the cargo tab to 3.
-a Rounded Unused space to 2 digits to avoid "Zero Hunting"
May 13 -Robotic Crew triggers Crew tag in Summary
May 31 -Terry added 0-8 Robot sizes for Robotic Labs. also two more user defined slots. I have those duplicated on my sheet and working in the Summary.
Stirling Fission Plants are now supported.
Removed rounding from the power plant fuel calculation as it was giving large numbers on super-small plants with years-long operating times.
June13 -Hardpoint cost no longer affected by weapon modifications.
June 20 -Fixed an error that crept in from changes affecting small craft turret/firmpoint costs
Sheet now checks for more than one small turret again
SSD moved to end of sheet with the Capital SSD
Added Optional CSC proto/retro handling of Ship's Computers, within the limits of HG customization. (2 proto, 3 High tech levels)
Added a profitability tab to (hopefully) help to calculate how much you might expect to make on standard or various runs
-a Fixed Crew Salaries on the Profitability Tab
-b High Passage reflects Core Rulebook
-c Update to Profitability Tab function
Standby Luxury Passengers in High Staterooms
Robot costs added to purchase price with toggle
Robot maintenance added to ship's maintenance
-d Included the calculations for freight that I missed
Quirks now implemented, bottom right on Ship's Info Tab
-e Terry updated Profitability to show a month's profit and added Fuel costs
Terry increased Robot skill max to 8
June 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
-a Added Variable Report to Profitability Tab that lets you specify any number of days to compare with any number of jumps.
June 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
-a Fixed validation issues
-b Outside additions from modules/carried ships now properly share the same pools of staterooms as the Stateroom Tab rooms.
June 29 -Removed minimum fuel for small craft rule due to conflict with newer publication
July 06 - Fixed a typo in quirks (Thanks Terry)
Fixed Railgun stats (Thanks DigrizJB)
-a Fixed an issue with the Full Collapsible Fuel Tank equation on the Cargo tab.
July 07 - House Rule toggle applying the Small Craft Fuel Rule to all ships.
Current Version: v2025.07.06a
July 10 - Power Tab's Power Distribution expanded to include station systems- Good catch Mavikfelna
Revised Retro computers for unlimited reductions instead of only three - Thanks Terry
Thanks to Another Dilbert, MingtheMirthless and DigrizJB for identifying bugs. Thanks to Terry Mixon for the formatting update and sensor correction, fabricators and help on craft tables
Last edited:
