LF Total Warfare to Alpha Strike conversion spreadsheet

[deusduce2]

So I have a ton of home brew designs, some cheese and others just modified existing designs, but the conversion rules take a while to process even a single unit through let alone several. I have already seen the one from Xotl at https://bg.battletech.com/forums/alpha-strike-101/bt-gt-alpha-strike-converter/ but I don't think this was updated with the current errata after 2018. I have also used Mech Factory quite a bit, and while it is close, it also has errors and isn't exact.

Anyone have an updated spreadsheet for this?

[Ft_Hood]

Mech Factory?

[Alexander Knight]

Sorry, I just do them by hand.

...of course, by this point I'm pretty quick at doing them by hand.

[Xotl]

If there's any errors in the sheet it would be in the heat modification stage, which is the part that kept changing.  I might have some time today to take a fresh look at it.

[nckestrel]

http://www.mordel.net/index.php

[Xotl]

I tried a couple of units to test the overheating (a Juliano for OV 4, and a Wulfen B for OVL), and both work, so it looks like I already incorporated all the heat errata.  I did however add a small update correcting the heat on rocket launchers and One-Shot weapons.

Let me know if you find anything wrong (or just use whatever nckestrel linked).

[nckestrel]

Unless the spreadsheet has been updated lately, it presumably doesn't do the weak jump and strong jump specials?
That's the only significant change I can think of recently.

[Xotl]

No, but it never did that sort of stuff (almost anything with specials, other than OVL): it's pretty bare bones.  It was just intended to spit out accurate armour, structure and damage values, which I thought was the hardest and most important stuff.

[technick123]

It only has short range ability.

Before you take the shot, roll 1D6, on a 6+ you can take the shot. Otherwise it can’t do any damage that turn unfortunately.

If the shot hits, it only does 2 damage.

Correct me if I'm wrong.