Google Sheets Worksheets

[Technetium 98]

I've been making some worksheets on Google Sheets, figured it was past time to upload 'em here. They'll be receiving updates in the coming weeks, especially the High Guard one; it's the newest. Feel free to post bug reports and questions here.

MGT2 High Guard Worksheet v1.20.09

docs.google.com

MGT2 Vehicle Worksheet v1.05

docs.google.com

MGT2 Robot Worksheet v1.50.00

Main Chassis Tech Level,Slots,Endurance,Cost Basics,Maximum Tech Level:,12,-,-,-,- -,Type:,Robot,Size:,None,-,-,-,- -,Locomotion Type:,-,-,-,-,- -,Chassis Options:,-,-,-,-,- Cybernetics,Cybernetic Interface:,-,-,-,-,- -,Options:,-,-,-,-,- -,— ,-,-,-,-,- -,— ,-,-,-,-,- Armour,Base Armour is 0. S...

docs.google.com

Updates:

• 02/01/23 - High Guard v1.20 released.
• 10/09/23 - Robot Handbook v1.50 released.

 

[paltrysum]

Nice work! Love your sheets, Technetium. Thank you for putting these together and posting them.

 

[Heilemann]

Thank you so much for these. I was working off the Robot PDF worksheet, but when I got to the brain and skills section I failed to brain myself (I found the brain rules to be almost incomprehensible for some reason). Your sheet made it super easy.

 

[BigDogsRunning]

Now we just need a weapon design sheet for the Field Catalogue.

 

[Arkathan]

There is a partial one floating around on this forum. Last I looked at it was before the general release of the Field Catalogue, and it was missing shotguns (and maybe a few other features)

 

[Technetium 98]

Now we just need a weapon design sheet for the Field Catalogue.

Sisyphus - Wikipedia

en.wikipedia.org

Jokes aside, I know of this one, but it ain't being supported no more, so.

Copy of MgT2 Field Cat Gen Preview

Printout Advanced Weapon Design Worksheet Weapon:,bla bla bla some fluff text Type:,bla bla bla some fluff text Component,Cost,Mass,Other Factors Receiver Type: Medium,Cr2,500.00,3.00Kg,Quickdraw 0 Maximum Power: Standard Laser (5D) Base Range: 200m Damage: 5D Power Per Shot: 5 Mechanism: Bu...

docs.google.com

 

[WTF Spaceship Designs]

Q - configuring a 200T ship with a reinforced streamlined hull. Selected Crystaliron armor and then 4 AP. It seems like it ought to be 10T of space consumed but the spreadsheet is showing 12T. That does alter to 3T per AP if adjusted. The Chassis page at line 56 for Crystaliron shows a 3 in Column I for Tonnage vs the 1.25% in column C. So my best guess is that it wants to apply the 3 even though it ought to be 2.5 per AP on a 200T ship. Is there possibly a rounding error? Where would a correction be made?

 

[Geir]

Q - configuring a 200T ship with a reinforced streamlined hull. Selected Crystaliron armor and then 4 AP. It seems like it ought to be 10T of space consumed but the spreadsheet is showing 12T. That does alter to 3T per AP if adjusted. The Chassis page at line 56 for Crystaliron shows a 3 in Column I for Tonnage vs the 1.25% in column C. So my best guess is that it wants to apply the 3 even though it ought to be 2.5 per AP on a 200T ship. Is there possibly a rounding error? Where would a correction be made?

The Highguard 2022 update includes armour volume modifications based on Hull type. For Streamlined, it's 20%, so that's where the 12 tons comes from.

 

[Technetium 98]

Q - configuring a 200T ship with a reinforced streamlined hull. Selected Crystaliron armor and then 4 AP. It seems like it ought to be 10T of space consumed but the spreadsheet is showing 12T. That does alter to 3T per AP if adjusted. The Chassis page at line 56 for Crystaliron shows a 3 in Column I for Tonnage vs the 1.25% in column C. So my best guess is that it wants to apply the 3 even though it ought to be 2.5 per AP on a 200T ship. Is there possibly a rounding error? Where would a correction be made?

Geir has the right of it.

If you want to revert it, you can change the armour volume modifiers in the hull configuration table, on the Chassis sheet.

 

[WTF Spaceship Designs]

As last weekend's question pushed me at the details in the revised High Guard, let me also ask this - Is there a reason Heat Shielding and Radiation Shielding are either/or? I've carefully re-read that section and while reflec and stealth exclude each other, I don't see anything about these two doing the same. [And presumably the radiation coating can be on the inside surface to catch waves that get through the rest of the hull without issue, heat shielding probably ought to be at or near the outside.] An easy fix would be to have "both" in the selector.

 

[Arkathan]

Nothing in the rules prohibits having both.

 

[Technetium 98]

Yeah, that was me deciding that UI was more important than covering every possible ship design. Heat Shielding is rare enough, let alone combining it with Radiation Shielding; only having the one option was easier. I'll work on it.

 

[Technetium 98]

New robot sheet uploaded! I'll be keeping the old one up for a week or two, but it'll be deleted soon enough. Send bug reports here or in the Discord: there'll be no end of them, I'm sure.

Next, updating the Vehicle Handbook, then - god help me - the Field Catalogue.

 

[hrafnkolbrandr]

Does anybody know what the option next to powerplant fuel that says "reduce" is meant to represent?

 

[GabrielGABFonseca]

Does anybody know what the option next to powerplant fuel that says "reduce" is meant to represent?

That'd be the optional rules introduced in Small Craft Catalogue, I believe, which allow power plant fuel usage to be fractional instead of requiring minimum increments of 1 ton of fuel.
When @Technetium 98 is online, he'll be able to confirm it, though.

 

[MasterGwydion]

For ships I just use @Arkathan ship spreadsheet. If it is something I want to share with you guys anyhow. Otherwise, I use My own spreadsheet due to me using a lot of houserules.

 

[Technetium 98]

Does anybody know what the option next to powerplant fuel that says "reduce" is meant to represent?

Yeah, GAB has the right of it. It changes the four weeks per one ton minimum into a flat 2.5% per week - so instead of packing one ton of fuel onto a five ton ultralight fighter, you'd only need 0.05t or so.

 

[hrafnkolbrandr]

Yeah, GAB has the right of it. It changes the four weeks per one ton minimum into a flat 2.5% per week - so instead of packing one ton of fuel onto a five ton ultralight fighter, you'd only need 0.05t or so.

Okay, so it's for small craft then; not for stuff big enough to be jump capable. Thank you.

 

[MasterGwydion]

Okay, so it's for small craft then; not for stuff big enough to be jump capable. Thank you.

It is for every ship where you do not want your fuel tanks to be made up of whole tons and want to be able to use partial tonnage, even for the large ships.

 

[AndrewW]

It is for every ship where you do not want your fuel tanks to be made up of whole tons and want to be able to use partial tonnage, even for the large ships.

It applies only to small craft. (Small Craft Catalogue, page: 4)

However, it makes sense for small craft to be able to use less than a ton of fuel for their tiny power plants and this is what the Small Craft Catalogue does to alter the operational characteristics of each craft.

The same can be done for small craft in the Traveller Core Rulebook and High Guard, using the Operation Times table.