CincyBattletech

Please login or register.

Login with username, password and session length
Advanced search  

News:

Reactor: Online.  Sensors: Online.  Weapons: Online.  All systems nominal.

Author Topic: Repair custom spreadsheet update  (Read 10130 times)

deadlyfire2345

  • Playtesting
  • Major General
  • *
  • Posts: 5270
    • View Profile
    • Email
Repair custom spreadsheet update
« on: July 24, 2023, 09:56:06 AM »
New excel sheet that adds TN adjustments for experimental and experimental/clan (if it comes to that)
Gotta fix it entirely, only did for thread in repair sheet.

Added Clan/Experimental for both IS/Clan technicians, all tables now have updated modifier lookups.
« Last Edit: July 24, 2023, 10:03:40 AM by deadlyfire2345 »
Logged

Ad Hoc

  • Lieutenant
  • *****
  • Posts: 1900
    • View Profile
    • Email
Re: Repair custom spreadsheet update
« Reply #1 on: January 11, 2026, 06:06:57 PM »
Here is the updated version of my Repair/Custom Calculator. It is up to date with Have Mech Will Travel v6 ruleset.

Just uploaded the newest version. Jan 17 2026

Removed old version. Newest is post below.
« Last Edit: January 24, 2026, 11:17:04 AM by Ad Hoc »
Logged

ADHDtv

  • Playtesting
  • Master Sergeant
  • *
  • Posts: 689
    • View Profile
    • Email
Re: Repair custom spreadsheet update
« Reply #2 on: January 19, 2026, 09:35:11 PM »
Quote from: Ad Hoc on January 11, 2026, 06:06:57 PM
Here is the updated version of my Repair/Custom Calculator. It is up to date with Have Mech Will Travel v6 ruleset.

Just uploaded the newest version. Jan 17 2026

Minor error in sheet
Change Table Custom cell B14 to =IFERROR(VLOOKUP(A4,'Mech Roster'!C2:N9,12,FALSE),"")
the number here is mistakenly 9 in current and that means mechs with clan tech on IS are flagging as LAMs, instead of using the LAM column, which is now on 12 (was 9)
Logged

Ad Hoc

  • Lieutenant
  • *****
  • Posts: 1900
    • View Profile
    • Email
Re: Repair custom spreadsheet update
« Reply #3 on: January 20, 2026, 08:25:24 PM »
Quote from: ADHDtv on January 19, 2026, 09:35:11 PM
Quote from: Ad Hoc on January 11, 2026, 06:06:57 PM
Here is the updated version of my Repair/Custom Calculator. It is up to date with Have Mech Will Travel v6 ruleset.

Just uploaded the newest version. Jan 17 2026

Minor error in sheet
Change Table Custom cell B14 to =IFERROR(VLOOKUP(A4,'Mech Roster'!C2:N9,12,FALSE),"")
the number here is mistakenly 9 in current and that means mechs with clan tech on IS are flagging as LAMs, instead of using the LAM column, which is now on 12 (was 9)

Thanks for catching that. I really didn’t check the customs sheet. I will try and look at that this weekend. When I get it fixed I will post the update and let you all know.
Logged

Ad Hoc

  • Lieutenant
  • *****
  • Posts: 1900
    • View Profile
    • Email
Re: Repair custom spreadsheet update
« Reply #4 on: January 23, 2026, 08:32:34 PM »
I believe I have fixed and updated the Repair/Custom Calculator. attached is the newest version. Please continue to let me know if you find anymore issues.
Logged