Google Sheets Robot Designer

[Technetium 98]

Made a robot spreadsheet. It's nightmarishly inefficient, buggy as all hell, and I seriously doubt the cybernetics actually work right, but it's here.

MGT2 Robot Worksheet v1.40

Main Chassis ,TL,Slots,Endurance,Cost Chassis,Maximum Tech Level:,12,12,-,-,- -,Type:,Robot,Size:,None,-,-,-,- -,Locomotion Type:,None,-,-,-,- Synthetics,Chassis Options:,None,-,-,-,- -,Cybernetics:,-,-,-,-,- -,— ,-,-,-,-,- -,— ,-,-,-,-,- -,Interface:,-,-,-,-,- Armour,Base Armour is 0. Set Armo...

docs.google.com

As usual, post any bug reports here.

 

[J. L. Brown]

Is there a newer version of this? I had some trouble with v1.50 posted in the 'Google Sheets' thread.

 

[Geir]

Can't speak to the above link, but I'm still using my ugly v1.44 version which is available from

Free Downloads

Traveller Core Rulebook Update 2022 Title Notes Download link FAQ & Errata Tweaks and changes to Core Rulebook Update 2022 Download (763 KB) Ship Record Sheet The ship record sheet from Core Rulebook Update 2022 Download (288 KB) 2022 Character Sheet A character sheet for Core Rulebook Update...

www.mongoosepublishing.com

as the Excel Worksheets link located under Robot Handbook

 

[Technetium 98]

Is there a newer version of this? I had some trouble with v1.50 posted in the 'Google Sheets' thread.

v1.50 is the current version, yeah - this thread's deprecated. Should be working - what issues are you having, exactly?

 

[J. L. Brown]

It does not seem to track the limited number of zero-slot items by TL & size -- maybe this is just my reading of the interface; and I cannot put an Environmental Processor (or an Olfactory sensor) into the default suite, even at increased cost. Some skills do not seem to be available (Vacc suit, for one). When I select 'basic storage compartment', the next field over comes up as a '1', and there is no drop-down. Manually changing it seems to overwrite & cause trouble when it is changed later.

And exporting it from Google sheets to .ods seems to break it; which means I cannot use it locally without network -- darn you, Google!

Overall, this is really helpful; thanks for putting in the work!

 

[Technetium 98]

• It does, albeit not exactly elegantly - the limit's high enough and options few enough that I figured an imperfect solution would do fine. If you look at the slot readout on K45:121, that's what the IF(COUNTIF($K$24:$K44, "=0")>dataZeroMax, 1, -99) bit is doing.
• The Default Suite was just meant to cover the... well, default kit that any robot's meant to have, hence why I restricted it to Auditory, Comms, Interface, Transceiver, and Visual. There's no significance to what you mount in there, besides eight basic items having no cost. Why do you need to install Environmental Processors or Olfactory Sensors in the Default Suite, anyway? There are options for both of those in the Sensors section.
• It's just Vacc Suit. For some reason, there aren't rules for it in the book, so I didn't include it. Everything else is in there, besides the literally infinite variety of Profession or Science skills. Those, you'll just have to use the next best. I can't cover everything.
• That's a Google Sheets limitation, nothing I can do.
• Yeah, that's Google Sheets for you. I figured making this easy to share took precedence.

 

[Geir]

• It's just Vacc Suit. For some reason, there aren't rules for it in the book, so I didn't include it. Everything else is in there, besides the literally infinite variety of Profession or Science skills. Those, you'll just have to use the next best. I can't cover everything.

'Well, yeah because, it's a robot'... he says. Vacuum protection is a feature, not a skill.

But now look what you made me do: You made me think on deficient (in quantity at least) coffee. I suppose an entirely or mostly biological android would potential need to wear a vacc suit, so it probably shouldn't have been exclude (or active self-accusative tense: I shouldn't have excluded it).

Oh well, can't think of everything all of the time (assuming thought has energy and energy and mass are equivalent, such an act will form a black hole in my brain and... anyway, I'll just get another cup of coffee).

Something to add on a reprint, equivalent to Drive skill (as in Drive(walker), sort of)

 

[J. L. Brown]

I am designing human-sized and -shaped robots to step into the roles of customs agents, soldiers, etc. They will be working alongside (and, when the visors are closed, indistinguishable from) humans, so being able to use the same equipment (and armor) is a plus -- and wearing a set of poly carapace is easier and cheaper than buying extra armor on a robot. Vacc suit skill is required to wear some of these.

But vacc-suit skill is just one particular skill-hole I ran into; robot brains can run any software available to other computers -- and there are a few bits of software missing -- Digital Friend, Intrusion, Translator, Agent, Database, etc. Like zero-slot items in the default suite, it is not a huge deal to just write these in afterwards, but I was surprised.

 

[Technetium 98]

With respect - you're certain those software packages are missing?

 

[J. L. Brown]

After noticing that I could unhide that section, they are there after all -- wonderful!