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.
New version is here. 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.
Current Version: v2024.04.10
April 10 - Solar Panels are now supported. Small weapon mounts should comply with HG22.
Edit: Thanks to Another Dilbert, MingtheMirthless and DigrizJB for identifying bugs.
If anyone wants to point out errors - politely - feel free to take a look.
New version is here. 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.
Current Version: v2024.04.10
April 10 - Solar Panels are now supported. Small weapon mounts should comply with HG22.
Edit: Thanks to Another Dilbert, MingtheMirthless and DigrizJB for identifying bugs.
Attachments
Last edited: