Arkathan
Cosmic 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.
Current Version: v2022.10.27.
October 27 - Mineral detection suites now take up space, as intended.
Ship Designer: Get it here
Edit: Thanks to Another Dilbert and MingtheMirthless 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.
Current Version: v2022.10.27.
October 27 - Mineral detection suites now take up space, as intended.
Ship Designer: Get it here
Edit: Thanks to Another Dilbert and MingtheMirthless for identifying bugs.
Last edited: