Excel Ship Designer v2025.04.18

I've added a warning about that to the Instruction Tab, so hopefully others won't get hit with that. (out with next update)
 
Last edited:
Regnarts said:
Got it. A "," instead of a "." (from the default system settings) in the excel settings used as a decimal separator was causing problems. Yeah, here in Poland we always have to complicate things for ourselves
Click to expand...
Don't be to hard on your country, most of the rest of Europe does as well :D it's really only the English and their former colonies the do it the other way around
 
I do have to say that I am impressed with the spreadsheet. Very nice work and the update are steady.

i do have a question concerning the Fabricators.

Is there a reason that you listed non-standard liter amounts to the for the standalone units? It take 1.5 liters per fabrication slot. and the slot increase exponentially. For instance a fabricator with 128 slot would take 192 liters of material, and would be capable of producing a robot body (or other item of equivalent size) of size 6.
 
Thanks.
That was a collaborative effort with Gier and Terry Mixon. There is a custom section, allowing you to make the chamber size whatever you wish.

IIRC, Gier made suggestions and Terry did the heavy lifting.
 
Hardwire said:
I do have to say that I am impressed with the spreadsheet. Very nice work and the update are steady.

i do have a question concerning the Fabricators.

Is there a reason that you listed non-standard liter amounts to the for the standalone units? It take 1.5 liters per fabrication slot. and the slot increase exponentially. For instance a fabricator with 128 slot would take 192 liters of material, and would be capable of producing a robot body (or other item of equivalent size) of size 6.
Click to expand...
I did the custom selection to give the most freedom of choice. If you are suggesting a different way to do the same thing, I’m a little groggy this morning and need more details.
 
Last edited:
No I was just wondering. The Validation of the liters is easy enough to correct 0,1.5,3,6,12,24,48,96,192,384,768, that would take it from a size below 0 to size 8. Well I assume you are doing it with a validation field. I guess you could be doing power function and then multiplying by 1.5 liters.
 
And the custom section below the standardize one means there is nothing to correct. Just insert the desired volume.
 
And I will use that, just curious why the method in the book is designated as the custom and not the base. I will drop it. But once again nice sheet.
 
Hardwire said:
No I was just wondering. The Validation of the liters is easy enough to correct 0,1.5,3,6,12,24,48,96,192,384,768, that would take it from a size below 0 to size 8. Well I assume you are doing it with a validation field. I guess you could be doing power function and then multiplying by 1.5 liters.
Click to expand...
I’m a little more awake and can tackle this now. The standard sizes get a price break. That’s why they are limited to what they are. The custom ones get no price break (though if someone were to enter a standard size in the custom area, it does discount). That’s why I made two areas. One for quick selection of what is commonly available snd the other for custom jobs that are pricier.
 
Hardwire said:
And I will use that, just curious why the method in the book is designated as the custom and not the base. I will drop it. But once again nice sheet.
Click to expand...
I can’t escape the feeling that I’m not really grasping what you’re saying. Could you spell it out more completely? If I’ve made an error, I’ll fix it. I’m not sure if I have though and that’s why I need a more thorough explanation of what you’re seeing.
 
Hardwire said:
No I was just wondering. The Validation of the liters is easy enough to correct 0,1.5,3,6,12,24,48,96,192,384,768, that would take it from a size below 0 to size 8. Well I assume you are doing it with a validation field. I guess you could be doing power function and then multiplying by 1.5 liters.
Click to expand...
Why validate those numbers? Because of robot sizes?
 
In robots they are slots, but then you have to convert to liters to determine capacity. These are mounted on a table, floor or wall of labs, studios and workshops. Liters are more compatible with dtons.
 
Hardwire said:
I guess i am just getting confused. Fabrication chambers are measured in slots, but you are measuring in liters. 1 slot = 1.5 liters.
Click to expand...
Like Arkathan said, slots don't lend themselves to easy calculation to see if you can fabricate something of a certain volume. Liters do.

"How many slots is this rifle?"

"What?"

See? With liters you can make an educated guess at the volume of something, and a GM can say if it can be fabricated or not. Slots? Not so much as you'd have to go to how many liters a slot was in any case. I just cut out the middle step.
 
If the slot/liter ratio extends to the other units in that section (deconstructors, etc.) it would be pretty easy to add a column after the power to display that. If they others don't convert, could still do the fabricators.
Would that be something useful?
 
Arkathan said:
If the slot/liter ratio extends to the other units in that section (deconstructors, etc.) it would be pretty easy to add a column after the power to display that. If they others don't convert, could still do the fabricators.
Would that be something useful?
Click to expand...
My understanding is that deconstructors use the same slot/liters ratio.
 
Arkathan said:
If the slot/liter ratio extends to the other units in that section (deconstructors, etc.) it would be pretty easy to add a column after the power to display that. If they others don't convert, could still do the fabricators.
Would that be something useful?
Click to expand...
That would be impossible to do; Mongoose has consistently refused to give a meaningful definition of 'liters per slot'. There are contradictory definitions in the same book; I would avoid getting the sheet entangled with 'slots' as much as possible.

dTons and liters per dTon are well defined.
 
You must log in or register to reply here.

Similar threads

Coryphon
Roll20 - Traveller 2e Official Character Sheet - Updates
2
Replies
35
Views
1K
Coryphon
Coryphon
Terry Mixon
Deepnight Endeavour Fuel Shuttle
Replies
14
Views
729
MonsterX
M
S
High Guard Smaller Weapons
5 6 7
Replies
132
Views
3K
Condottiere
C
Terry Mixon
The Riverland Errata
Replies
3
Views
184
chibiko
C
C
vandeets traveller
Replies
0
Views
308
chrisaukcam
C
Back
Top