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:
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
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.
 
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.
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.
 
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.
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.
 
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.
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.
 
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.
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.
 
I guess i am just getting confused. Fabrication chambers are measured in slots, but you are measuring in liters. 1 slot = 1.5 liters.
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?
 
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?
My understanding is that deconstructors use the same slot/liters ratio.
 
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?
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.
 
Back
Top