Excel Ship Designer v2025.11.12

[mavikfelna]

I've had intermittent issues when pulling from another sheet using the newer version of Excel. So, the external reference may be my sheet? Or more specifically, my sheet on your computer.

Well, I should have been pasting values only rather than straight copy pasting.

 

[Arkathan]

@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.

Credits. Fixed for next update... which will probably not be tomorrow.

 

[mavikfelna]

Credits. Fixed for next update... which will probably not be tomorrow.

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]

there shouldn't be any external references on the indexes, those are cut and paste errors cause I was using @Arkathan's sheet to pull the data. Can you tell me what vehicles are getting the errors?

All of them. A3, etc. refers to A3, A4, A5 ad Infinito.

 

[Arkathan]

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?

Need a better description of the request, including tab and nearest field.

 

[mavikfelna]

All of them. A3, etc. refers to A3, A4, A5 ad Infinito.

See if this is better

Need a better description of the request, including tab and nearest field.

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]

All of them. A3, etc. refers to A3, A4, A5 ad Infinito.

See if this is better

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]

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.

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]

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.

 

[Arkathan]

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.

View attachment 6783View attachment 6784

Yes, it is fixed in the next upload. A VLOOKUP that escaped the swap to Index(Match) inexplicably stopped working.