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

Main Chassis 100 Tons Remaining,Tech Level,Tonnage,Power,Cost Basics,Max. Tech Level:,15,Ship Tonnage:,100,-,-,20,5,000,000 -,Configuration:,Standard,Module:,-,-,-,- -,Ship Type (Users):,Default,-,-,-,- -,Hull Options:,-,-,-,-,- Options,Reinforcement:,None,-,-,-,- -,Hull Options:,Gravity,8,-,-,- -

docs.google.com

MGT2 Vehicle Worksheet v1.05

Main Chassis ,Tech Level,Spaces,Cost Basics,Tech Level:,12,Base Vehicle Spaces:,0,-,-,- -,Chassis Type:,None,-,-,- Biotech,Biotech:,— ,-,-,-,- -,— ,-,-,-,- Options,— ,-,-,-,- -,— ,-,-,-,- -,— ,-,-,-,- -,— ,-,-,-,- -,— ,-,-,-,- -,— ,-,-,-,- Armour,Base Armour is 4. Set Armour to:,4,12,-,- -,Fron...

docs.google.com

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

Updates:

• 02/01/23 - High Guard v1.20 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.