Register Register

Author Topic: LF Total Warfare to Alpha Strike conversion spreadsheet  (Read 552 times)

deusduce2

  • Recruit
  • *
  • Posts: 2
LF Total Warfare to Alpha Strike conversion spreadsheet
« on: 06 October 2020, 00:46:33 »
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

  • Recruit
  • *
  • Posts: 17
Re: LF Total Warfare to Alpha Strike conversion spreadsheet
« Reply #1 on: 03 December 2020, 05:51:35 »
Mech Factory?

Alexander Knight

  • Peditum Generalis
  • Battletech Volunteer
  • Major
  • *
  • Posts: 4765
  • O-R-E-O
Re: LF Total Warfare to Alpha Strike conversion spreadsheet
« Reply #2 on: 03 December 2020, 06:55:09 »
Sorry, I just do them by hand.

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

Xotl

  • Dominus Erratorum
  • Battletech Volunteer
  • Lieutenant Colonel
  • *
  • Posts: 9739
  • Professor of Errata
Re: LF Total Warfare to Alpha Strike conversion spreadsheet
« Reply #3 on: 03 December 2020, 12:31:29 »
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.
3028-3050 Random Assignment Tables -
Also contains faction deployment & rarity info and Quirk lists.

http://bg.battletech.com/forums/index.php?topic=1219.0

nckestrel

  • Scientia Bellator
  • Freelance Writer
  • Lieutenant Colonel
  • *
  • Posts: 9334
  • All your tulips belong to us.
Left of Center blog - Nashira Campaign for A Game of Armored Combat, TP 3039 Vega Supplemental Record Sheets, Combat Manual Lite series [Steiner, Liao, Marik, Calderon, Invading Clans, Comstar. Also Record Sheets for the CM: Kurita and CM: Mercs unique pilots]

Xotl

  • Dominus Erratorum
  • Battletech Volunteer
  • Lieutenant Colonel
  • *
  • Posts: 9739
  • Professor of Errata
Re: LF Total Warfare to Alpha Strike conversion spreadsheet
« Reply #5 on: 03 December 2020, 13:06:17 »
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).
3028-3050 Random Assignment Tables -
Also contains faction deployment & rarity info and Quirk lists.

http://bg.battletech.com/forums/index.php?topic=1219.0

nckestrel

  • Scientia Bellator
  • Freelance Writer
  • Lieutenant Colonel
  • *
  • Posts: 9334
  • All your tulips belong to us.
Re: LF Total Warfare to Alpha Strike conversion spreadsheet
« Reply #6 on: 03 December 2020, 14:06:50 »
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.
Left of Center blog - Nashira Campaign for A Game of Armored Combat, TP 3039 Vega Supplemental Record Sheets, Combat Manual Lite series [Steiner, Liao, Marik, Calderon, Invading Clans, Comstar. Also Record Sheets for the CM: Kurita and CM: Mercs unique pilots]

Xotl

  • Dominus Erratorum
  • Battletech Volunteer
  • Lieutenant Colonel
  • *
  • Posts: 9739
  • Professor of Errata
Re: LF Total Warfare to Alpha Strike conversion spreadsheet
« Reply #7 on: 03 December 2020, 14:16:11 »
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.
3028-3050 Random Assignment Tables -
Also contains faction deployment & rarity info and Quirk lists.

http://bg.battletech.com/forums/index.php?topic=1219.0

technick123

  • Recruit
  • *
  • Posts: 6
Re: LF Total Warfare to Alpha Strike conversion spreadsheet
« Reply #8 on: 10 January 2021, 08:37:15 »
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.
Always on the battle field.