mavikfelna
Emperor Mongoose
Well, I should have been pasting values only rather than straight copy pasting.
Excel Ship Designer v2025.11.12
- Thread starter Arkathan
- Start date
Arkathan
Emperor Mongoose
Credits. Fixed for next update... which will probably not be tomorrow.@Arkathan I'm trying to add powerplant fuel purchases to ships in the Profitability tab but nothing I put into the Buy Additional Fuel cell does anything. Also, is it suppose to be Tons or Credit cost that we enter there? For when it's actually working.
mavikfelna
Emperor Mongoose
Can we get an option for tonnage so it just purchases the kind of fuel being purchased for the jump drives? And able to handle fractional tonnages?
DigrizJB
Cosmic Mongoose
All of them. A3, etc. refers to A3, A4, A5 ad Infinito.
Arkathan
Emperor Mongoose
Need a better description of the request, including tab and nearest field.
mavikfelna
Emperor Mongoose
See if this is better
So instead of putting in 100 Cr to purchase 1 ton of unrefined fuel, just put in 1 and it just adds that to the total of the tons being purchased for jump fuel. And if I'm doing 2 week intervals, I can put in 0.5 for the tons and since it's just adding it to the to the total tons of fuel being purchased then it will get adjusted correctly in the total cost output.
DigrizJB
Cosmic Mongoose
Apologies, I was not clear. The sheet with errors is Vehicle Ship Index, but upon further examination I believe the data is irrelevant, because the correct data populates to the primary list in Traveller Named Ships and Craft. Problem solved.
I emailed you a list of publications.
mavikfelna
Emperor Mongoose
Ah, the Vehicle & Ship Index was a straight copy from the spreadsheet so yea, it was still a copy paste error, I just sent you the wrong sheet.
mavikfelna
Emperor Mongoose
I found a new error that may be fixed in the new sheet from discussions earlier. But I'll post it anyway.
Putting Budget - Increased Size for a Meson Cannon gives you the bonus in cost, but doesn't actually increase the size of the unit.
Putting Budget - Increased Size for a Meson Cannon gives you the bonus in cost, but doesn't actually increase the size of the unit.
Arkathan
Emperor Mongoose
Yes, it is fixed in the next upload. A VLOOKUP that escaped the swap to Index(Match) inexplicably stopped working.
mavikfelna
Emperor Mongoose
I have a discrepancy between the rules and how armor is allocated for all the official planetoid designs and the spreadsheet follows the rules not how all the official designs work.
So what's going on, the rules imply, but do not actually say, you use the entire hull size to calculate armor, and the spreadsheet does it this way. But every official design that uses armor, for planetoid or buffered planetoid, uses only the AVAILABLE hull size to calculate armor. Examples are the Jaellemo Planetoid Monitor in HG22, p247, Neubayern Mobile Base, Great Rifts Book 1, p209 and Megusard Meson Emplacement in Trailing Frontier p233.
Can we get a switch or something so planetoid and buffered planetoid hulls only have to armor the available hull size and not the full hull size?
So what's going on, the rules imply, but do not actually say, you use the entire hull size to calculate armor, and the spreadsheet does it this way. But every official design that uses armor, for planetoid or buffered planetoid, uses only the AVAILABLE hull size to calculate armor. Examples are the Jaellemo Planetoid Monitor in HG22, p247, Neubayern Mobile Base, Great Rifts Book 1, p209 and Megusard Meson Emplacement in Trailing Frontier p233.
Can we get a switch or something so planetoid and buffered planetoid hulls only have to armor the available hull size and not the full hull size?
Condottiere
Emperor Mongoose
Usable space for hull armour and bridge.
Total tonnage for drive performance.
Total tonnage for drive performance.
mavikfelna
Emperor Mongoose
Yes, you are correct. I was only looking at armor but it may make sense to affect bridge as well. Drive performance definitely needs to be the full hull, and that is how it is done in the official designs and the spreadsheet. Other hull options on the official ships seems to only include the available hull as well, though only Radiation Shielding appears on the official ones. But armor, pressure hull and radiation shielding make sense and maybe self maintenance, but reflec, heat shielding, hostile environment, holographic, and stealth all should be the full hull I think. adjustable hull should be disallowed actually, but it's not excluded that I can find in the rules.
Condottiere
Emperor Mongoose
Rock hull configuration would be fractal, presumably.
But, it would appear to me, that the exterior isn't really meant to be movable.
But, it would appear to me, that the exterior isn't really meant to be movable.
ProfGrizzlyJon
Emperor Mongoose
Can't wait to see the Cluster Truck updates!
These are my new favorite quotes:
"Upgrading a vessel to a higher Tech Level is a huge undertaking requiring a major rebuild. If this were to be done for some reason, the vessel’s new baseline Tech Level would be defined by the lowest of its hull, bridge and power plant Tech Level."
"A complete component, say a TL14 jump drive, can be installed in a ‘black box’ configuration providing suitable interface devices can be constructed. Installing a complete component requires an Average (8+) Engineer check (INT) with a negative DM equal to the difference between the component’s Tech Level and that of the vessel it is to be installed into. Failing this check reduces the condition of the component by one level but does not preclude a future attempt."
These are my new favorite quotes:
"Upgrading a vessel to a higher Tech Level is a huge undertaking requiring a major rebuild. If this were to be done for some reason, the vessel’s new baseline Tech Level would be defined by the lowest of its hull, bridge and power plant Tech Level."
"A complete component, say a TL14 jump drive, can be installed in a ‘black box’ configuration providing suitable interface devices can be constructed. Installing a complete component requires an Average (8+) Engineer check (INT) with a negative DM equal to the difference between the component’s Tech Level and that of the vessel it is to be installed into. Failing this check reduces the condition of the component by one level but does not preclude a future attempt."
mavikfelna
Emperor Mongoose
We're going to need the ability to do fractional M and R drives now too. And extending the chart that starts at BC6 to include .1 and .5 G speeds might be nice too.
Arkathan
Emperor Mongoose
That is a question for the High Guard update thread. Let's keep the discussion here on features and whether I can even implement a fraction of what just came out, considering that this has always been based on ships coming out of a shipyard and not cobbled together scrap piles that sometimes fly.
If I manage to shoehorn it in, the stuff that isn't new components will be behind a toggle, so you do not have to see it .
The attached will do it.We're going to need the ability to do fractional M and R drives now too. And extending the chart that starts at BC6 to include .1 and .5 G speeds might be nice too.
