Excel Ship Designer v2025.05.13

OK, I don't get it and I need help!

I'm rebuilding the 600 tons Rorix-class command vessel from p. 190 of the Drinaxian Companion with the Excel ship designer for my players to modify. Strangely, some of the values are different, and I can't figure out which ones are correct. According to the Drinaxian Companion, the Rorix-class has 4 points of bonded superdense armour, weighing 19.2 tons, but the same amount of armour weighs 23.04 tons according to Excel! Who has it right?

Additionally, the ship carries 120 tons of fuel plus enough surplus to operate for 20 weeks weighing 150 tons according to the Companion. Excel gives me 129 tons, which is quite the difference... Again, who is correct?

Edit: Another difference is the weight of the detachable bridge: 30 tons (Companion) to 24 tons (Excel)!
 
Last edited:
Check your TL, and also you may need to consult the most recent edition of High Guard. POD was written years ago, and I'm not sure anyone would have checked the original ship designs to see if updated High Guard rules changed the design calculations. I would bet on the spreadsheet.
 
OK, I don't get it and I need help!

I'm rebuilding the 600 tons Rorix-class command vessel from p. 190 of the Drinaxian Companion with the Excel ship designer for my players to modify. Strangely, some of the values are different, and I can't figure out which ones are correct. According to the Drinaxian Companion, the Rorix-class has 4 points of bonded superdense armour, weighing 19.2 tons, but the same amount of armour weighs 23.04 tons according to Excel! Who has it right?

Additionally, the ship carries 120 tons of fuel plus enough surplus to operate for 20 weeks weighing 150 tons according to the Companion. Excel gives me 129 tons, which is quite the difference... Again, who is correct?

Edit: Another difference is the weight of the detachable bridge: 30 tons (Companion) to 24 tons (Excel)!
Detachable bridge: Missed the changes from variable to fixed sizes when the new edition came out. Used to be 1.2x with a minimum value. The book is correct and I've fixed it in Excel, but I'll put a correction out after I finish looking into the other differences. Edit: I thought I was wrong, but I was mistaken.

Fuel: 600 tons, Jump 2 = 120 tons. PWR 30 tons x .1 (4 weeks)=3 tons. 20/4=5*3=15.
135 tons for 20 weeks and 2 jumps. Spreadsheet is correct. Check your numbers, as I am not getting 129.
 
Last edited:
Found it! There is a discrepancy between the table in HG2022 p. 51 and the text below: According to the table, the size of a detachable bridge in a 600 tons vessel is 30 tons, but according to the text, its 20 tons +20%, resulting in 24 tons!
 
Found it! There is a discrepancy between the table in HG2022 p. 51 and the text below: According to the table, the size of a detachable bridge in a 600 tons vessel is 30 tons, but according to the text, its 20 tons +20%, resulting in 24 tons!
Right. The table is a holdover from HG16. There is no way to get the formula to get to 30 tons with a standard bridge of that size.
I am going to ignore the table and stick with the text. No correction needed.

Armor: The ship is streamlined. The Companion left off the +20% for armoring a streamlined ship. 19.2 x1.2=23.04

Companion uses old Med Bay capacities. You need three to not quite match the old capacity.

Also, the Companion adds tonnage for the three FREE airlocks it uses.
 
Another difference you'll see is that only the Captain's Stateroom and the brigs are armored, but I did not break out each component. Armoring acts on everything above it in the spreadsheet.
 
Fuel: 600 tons, Jump 2 = 120 tons. PWR 30 tons x .1 (4 weeks)=3 tons. 20/4=5*3=15.
135 tons for 20 weeks and 2 jumps. Spreadsheet is correct. Check your numbers, as I am not getting 129.
My mistake! I had the wrong advantage - "Decreased Jump Fuel" instead of "Energy Efficient". Sorry, sorry, sorry!
 
Decreased Jump Fuel is definitely the best way to go for Jump drives, though.

Is 'Advanced - Energy Efficient' broken for power plants? I could swear there was meant to be an 'Increased Power' option, but I am not seeing it.
 
Decreased Jump Fuel is definitely the best way to go for Jump drives, though.

Is 'Advanced - Energy Efficient' broken for power plants? I could swear there was meant to be an 'Increased Power' option, but I am not seeing it.
Energy Efficient adds power to the total. It is located on the same row as the mod.
Just checked it to make sure it works.
It works.
 
NEW VERSION: 2024.09.30
Hop and Skip drives implemented.
The computer section knows which software to offer you based on your type of jump.
Jump software now recognizes the presence of a Core and is free when you have one.

I don't THINK I broke anything in the process, but if I did, you know where to find me.
 
NEW VERSION: 2024.09.30
Hop and Skip drives implemented.
The computer section knows which software to offer you based on your type of jump.
Jump software now recognizes the presence of a Core and is free when you have one.

I don't THINK I broke anything in the process, but if I did, you know where to find me.
I'll get right to work on it. Thanks!
 
NEW VERSION: 2024.09.30
Hop and Skip drives implemented.
The computer section knows which software to offer you based on your type of jump.
Jump software now recognizes the presence of a Core and is free when you have one.

I don't THINK I broke anything in the process, but if I did, you know where to find me.

I've ran through it and added commas (converted general to number and added commas) to separate all the numbers that get hard to read when they get big. I also corrected the text for the superior sensors as that crept back in. It wasn't reading the last line in that table. I also widened that field to make it all visible.

I'm sure I missed something, but unless you have an objection to some of the conversion to numbers with no decimals, this makes it so much easier to read. If you'd bless this and roll it into your side, it would save me a lot of time doing this every iteration. I hope my minor OCD doesn't offend.
 

Attachments

Last edited:
NEW VERSION: 2024.09.30
Hop and Skip drives implemented.
The computer section knows which software to offer you based on your type of jump.
Jump software now recognizes the presence of a Core and is free when you have one.

I don't THINK I broke anything in the process, but if I did, you know where to find me.

I've ran through it and added commas (converted general to number and added commas) to separate all the numbers that get hard to read when they get big. I also corrected the text for the superior sensors as that crept back in. It wasn't reading the last line in that table. I also widened that field to make it all visible.

I'm sure I missed something, but unless you have an objection to some of the conversion to numbers with no decimals, this makes it so much easier to read. If you'd bless this and roll it into your side, it would save me a lot of time doing this every iteration. I hope my minor OCD doesn't offend.
Jump Drive Parsecs is greyed out on the fuel page when I select hop 1 on the drives page, and I get no fuel tonnage. Ditto skip 1, hyperdrive, space folding drive, and warp drive.
 
Last edited:
Except on Scouts: Smaller drive gets you 1.5 tons(10%), less fuel gets you 1(5%). It's that +5 tons on the jump drive size that makes a different on smaller ships.
There is nothing to stop you taking size reduction three times is there?
 
Back
Top