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: After Action Repair Example and revised repair spreadsheet  (Read 1407 times)

Timberwolfd

  • Administrator
  • Major
  • *****
  • Posts: 2953
  • Kibitzing from the sidelines
    • View Profile
After Action Repair Example and revised repair spreadsheet
« on: March 25, 2017, 09:33:41 PM »

(Note to Rob: Lets put after action repairs in their own child board...  Also, your opinion on whether we should track salvaged parts for the +1 difficulty of using salvaged parts (reattaching blown off limbs...))

Here are repair examples based on my after action repairs. This is a combination of StratOps and BMR rules that is as close as possible to MegaMekHQ/AtB so that there are minimal discrepancies. Most of AtB is StartOps for repairs and customization with many prices from BMR.
You can see these repairs in the attached spreadsheet. For Excel 2003 users see https://www.microsoft.com/en-us/download/details.aspx?id=3 for the compatibility pack.


Notes
1. Armor is always a new part, even when salvaged. Weapons, limbs, etc. that are acquired through salvage incur a +1 modifier when used as replacement parts, so track salvaged parts.
2. Quirks that apply to sourcing parts, like Ubiquitous, Non-Standard Parts and Obsolete, only apply to parts based on tonnage (engines, jump jets, sensors, actuators, limbs, etc.). So armor repair/replacement ignores these quirks completely.
3. AtB uses the 5 minutes/point StratOps time for armor replacement instead of 15 minutes/point from BMR (all other values are the same for BMR/StratOps). These repair calculations will use 5 minutes/point to keep everything as close to AtB as possible.
4. Note that repair modifiers from BMR are 1 higher than StratOps across the board because StratOps built in the unit Quality and Tech Level modifiers which net out to +1 to the TN for tech level D and quality level D mechs, which we are using, so the utter majority of the numbers should come out exactly the same. If there is a difference between numbers you get in AtB and here, it is probably due to a component quality level difference in AtB. So if you see a formula that looks like this: "6 (Veteran) - 1 (difficulty) + 0 (transport bay) + 1 (C)" and wonder why the difficulty is one higher, it is because the component in question has been reduced to quality C (+1). This component level maintenance tracking in AtB is INSANE and should be turned off.

Crusader (light armor damage)
  • Armor Damage: 2 points to LT, 5 points to RL
    Regular tech (TN 7+) + location mod (0, DropShip) + repair mod (-2, armor) + Quirks (-1, Easy to maintain) + extra time (0, None)  + parts (0, new) = 4
    Time required: 2x5=10 minutes and 5x5=25 minutes

Centurion (Armor Damage)
  • Armor Damage: LL 5, RL 13, LA 8, RA 12, LT 13, RT 7, CT 5
    Regular tech (TN 7+) + location mod (0, DropShip) + repair mod (-2, armor) + Quirks (0, Normal) + extra time (0, None)  + parts (0, new) = 5
    Times (minutes): 25, 65, 40, 60, 65, 35, 25

Shadow Hawk (Ouch)
  • Armor Damage: RL 5, LL 5, LA 4, RA 2, RT(R) 1, CT(R) 5, CT 12, CT(R) 7
    Regular tech (TN 7+) + location mod (0, DropShip) + repair mod (-2, armor) + Quirks (0, Normal) + extra time (0, None) + parts (0, new) = 5
    Times (minutes): 25, 25, 20, 10, 5, 25, 60, 35
  • Internal Damage: LL <25% internal damage (1 point/13), RL < 25% internal damage (3 points/13), and CT < 25% internal damage (3 points/18)
    Regular tech (TN 7+) + location mod (0, DropShip) + repair mod (-1, <25% internal damage) + Quirks (0, Normal) + extra time (-1, double) + parts (0, NA) = 5
    Base repair time = 90 minutes --> 180 minutes
    Times (minutes): 3x 180 minutes
  • Fix 1 Engine Critical
    Veteran tech (TN 6+) + location mod (0, DropShip) + repair mod (-1, Fix 1 Engine Crit) + Quirks (0, Normal) + extra time (-1, double) + parts (0, NA) = 4
    Base repair time = 100 minutes --> 200 minutes
  • Fix 1 Gyro Crit
    Veteran tech (TN 6+) + location mod (0, DropShip) + repair mod (+1, Fix 1 Gyro Hit) + Quirks (0, Normal) + extra time (-2, quadruple) + parts (0, NA) = 5
    Base repair time = 120 minutes --> 480 minutes

Wyvern ('Tis but a flesh wound!)
  • Armor Damage: RL 7, LA 2, RA 7, LT 11, RT 10, CT 11
    Regular tech (TN 7+) + location mod (0, DropShip) + repair mod (-2, armor) + Quirks (0, Normal) + extra time (0, None) + parts (0, new) = 5
    Times (minutes): 35, 10, 35, 55, 50, 55
  • Reattach Limb (LL blown off by crit and recovered/salvaged) EDIT: This was erroneously entered as RL initially. I would edit it in the subsequent posts, but that would trigger all of the roll flags.
    Veteran tech (TN 6+) + location mod (0, DropShip) + repair mod (+1, <25% internal damage) + Quirks (0, Normal) + extra time (-2, quadruple) + parts (+1, Salvage) = 6
    Base Repair Time: 180 minutes --> 720 minutes


« Last Edit: March 26, 2017, 11:02:19 AM by Timberwolfd »
Logged

Timberwolfd

  • Administrator
  • Major
  • *****
  • Posts: 2953
  • Kibitzing from the sidelines
    • View Profile
Re: After Action Repair Example and revised repair spreadsheet
« Reply #1 on: March 25, 2017, 09:39:59 PM »

Crusader Armor Rolls
LT
Rolled 2d6 : 2, 4, total 6

RL
Rolled 2d6 : 5, 3, total 8


Centurion Armor Rolls
LL
Rolled 2d6 : 6, 5, total 11

RL
Rolled 2d6 : 5, 4, total 9

LA
Rolled 2d6 : 2, 1, total 3

RA
Rolled 2d6 : 4, 2, total 6

LT
Rolled 2d6 : 4, 3, total 7

RT
Rolled 2d6 : 6, 2, total 8

CT
Rolled 2d6 : 3, 5, total 8


Shadow Hawk Armor Rolls
RL
Rolled 2d6 : 6, 1, total 7

LL
Rolled 2d6 : 3, 4, total 7

LA
Rolled 2d6 : 1, 1, total 2

RA
Rolled 2d6 : 3, 3, total 6

RT(R)
Rolled 2d6 : 1, 3, total 4

CT(R)
Rolled 2d6 : 5, 3, total 8

CT
Rolled 2d6 : 3, 6, total 9

CT(R)
Rolled 2d6 : 4, 5, total 9


Shadow Hawk Internal Damage Rolls
LL
Rolled 2d6 : 1, 2, total 3

RL
Rolled 2d6 : 6, 6, total 12

CT
Rolled 2d6 : 2, 4, total 6


Shadow Hawk Engine Critical Repair
Rolled 2d6 : 4, 3, total 7


Shadow Hawk Gryo Critical Repair
Rolled 2d6 : 5, 5, total 10


Wyvern Armor Rolls
RL
Rolled 2d6 : 5, 3, total 8

LA
Rolled 2d6 : 2, 3, total 5

RA
Rolled 2d6 : 4, 2, total 6

LT
Rolled 2d6 : 1, 5, total 6

RT
Rolled 2d6 : 3, 5, total 8

CT
Rolled 2d6 : 2, 3, total 5


Wyvern Reattach Limb (RL)
Rolled 2d6 : 4, 1, total 5


Logged

Timberwolfd

  • Administrator
  • Major
  • *****
  • Posts: 2953
  • Kibitzing from the sidelines
    • View Profile
Re: After Action Repair Example and revised repair spreadsheet
« Reply #2 on: March 25, 2017, 10:03:21 PM »

Repair failures/partial repairs
Shadow Hawk
LL internal fails by 2 (If the margin of failure had been 1, the repair would have succeeded, but there would be a 1 point reduction in the internal structure until the next repair interval/after the next game)
LA armor replacement fails by 3
RT(R) armor replacement fails by 1

Wyvern limb replacement fails by 1 (Limb replacements have no partial repair)

Centurion LA Armor replacement fails by 1.

Next Round of repairs
Shadow Hawk repairs by Veteran team for TN -1
LL Internal
Rolled 2d6 : 6, 2, total 8

LA Armor
Rolled 2d6 : 6, 6, total 12

RT(R) Armor
Rolled 2d6 : 6, 3, total 9


Centurion LA armor repairs by Veteran team for TN -1
LA Armor
Rolled 2d6 : 2, 3, total 5


Wyvern limb replacement/reattachment will be attempted again by the veteran team after a new limb is acquired since they can't attempt to replace the same part twice and I have no Elite techs to attempt it again and lower level techs are prohibited.
Logged

Timberwolfd

  • Administrator
  • Major
  • *****
  • Posts: 2953
  • Kibitzing from the sidelines
    • View Profile
Re: After Action Repair Example and revised repair spreadsheet
« Reply #3 on: March 25, 2017, 10:19:31 PM »

Okay, now to deal with the elapsed time.
My veteran team spent 1400 minutes in the initial round of repairs plus 180+20+5 minutes repairing the Shadow Hawk and 40 minutes on the Centurion armor repairs for 1,645 minutes (27.4 hours --> ~3.5 days)
The veteran team started on the Wyvern leg first because the Wyvern would be combat capable with the least other work. Therefore, they know they failed on the second day of repairs and can order the new leg then (I have arms and legs for the Crusader and Shadow Hawk, but not the Centurion or Wyvern, doh!).
In total my two regular teams worked 1,155 minutes on the Shadow Hawk, 720 minutes on the Wyvern, 105 minutes on the Crusader, and 945 minutes on the Centurion for just over 3 days of work each.

Reloading and Maintenance don't require rolls. I choose not to reload any ammunition
Current ammunition loads
Crusader: NA
Shadow Hawk: 94/100 SRM-2, 21/24 LRM-5, 15/20 AC/5
Centurion: 23/24 LRM-10
Wyvern: 14/15 SRM-6

Kills by mech
Crusader: 3x Vedette
Shadow Hawk: 1x Vedette, 1x Pack Rat
Centurion: 1x Locust 1E
Wyvern: 1x Vedette

Pilot Injuries
Crusader: 0
Shadow Hawk: 1
Centurion: 0
Wyvern: 1

Total Armor consumed: 159 Points
Shadow Hawk Pilot Hit June 7, 3044 Doctor Roll
Rolled 2d6 : 3, 1, total 4

Wyvern Pilot Hit June 7, 3044 Doctor Roll
Rolled 2d6 : 3, 1, total 4
« Last Edit: March 25, 2017, 10:38:36 PM by Timberwolfd »
Logged

Timberwolfd

  • Administrator
  • Major
  • *****
  • Posts: 2953
  • Kibitzing from the sidelines
    • View Profile
Re: After Action Repair Example and revised repair spreadsheet
« Reply #4 on: March 25, 2017, 10:41:30 PM »

Shadow Hawk Pilot Hit June 7, 3044 Doctor Roll This dice roll has been tampered with!
Rolled 2d6 : 3, 1, total 4
Wyvern Pilot Hit June 7, 3044 Doctor Roll This dice roll has been tampered with!
Rolled 2d6 : 3, 1, total 4
So our doctor is all thumbs...

Shadow Hawk Pilot Hit June 8, 3044 Doctor Roll
Rolled 2d6 : 1, 2, total 3

Wyvern Pilot Hit June 8, 3044 Doctor Roll
Rolled 2d6 : 3, 3, total 6


To keep the number of posts down I am going to put in 3 more days of rolls with the intention of stopping when healed

Shadow Hawk Pilot Hit June 9, 3044 Doctor Roll
Rolled 2d6 : 5, 4, total 9

Wyvern Pilot Hit June 9, 3044 Doctor Roll
Rolled 2d6 : 3, 3, total 6


Shadow Hawk Pilot Hit June 10, 3044 Doctor Roll
Rolled 2d6 : 4, 3, total 7

Wyvern Pilot Hit June 10, 3044 Doctor Roll
Rolled 2d6 : 4, 5, total 9


Shadow Hawk Pilot Hit June 11, 3044 Doctor Roll
Rolled 2d6 : 3, 6, total 9

Wyvern Pilot Hit June 11, 3044 Doctor Roll
Rolled 2d6 : 2, 3, total 5
Logged

Timberwolfd

  • Administrator
  • Major
  • *****
  • Posts: 2953
  • Kibitzing from the sidelines
    • View Profile
Re: After Action Repair Example and revised repair spreadsheet
« Reply #5 on: March 25, 2017, 11:29:11 PM »

Okay, Future repair roll for the Wyvern's LEFT Leg when it shows up on June 29, 3044.

Reattach Limb (try it first with the regular team)
Regular tech (TN 7+) + location mod (0, DropShip) + repair mod (+1, <25% internal damage) + Quirks (0, Normal) + extra time (-2, quadruple) + parts (0, New) = 6
Rolled 2d6 : 2, 3, total 5

Logged

Timberwolfd

  • Administrator
  • Major
  • *****
  • Posts: 2953
  • Kibitzing from the sidelines
    • View Profile
Re: After Action Repair Example and revised repair spreadsheet
« Reply #6 on: March 25, 2017, 11:30:23 PM »

And again with the Veteran Team....
Veteran tech (TN 6+) + location mod (0, DropShip) + repair mod (+1, <25% internal damage) + Quirks (0, Normal) + extra time (-2, quadruple) + parts (0, New) = 5
Rolled 2d6 : 6, 5, total 11
Logged

Timberwolfd

  • Administrator
  • Major
  • *****
  • Posts: 2953
  • Kibitzing from the sidelines
    • View Profile
Re: After Action Repair Example and revised repair spreadsheet
« Reply #7 on: March 25, 2017, 11:35:21 PM »

Scrapping actuators from the old limb (this should happen while they are waiting with plenty of time to twiddle their collective thumbs...)

Remove 3 Actuators (Foot, Lower Leg, and Upper Leg)
Regular tech (TN 7+) + location mod (0, DropShip) + repair mod (-3, replace actuator) + Quirks (0, Normal) + extra time (-1, double) + parts (+1, Salvage) = 4
Foot
Rolled 2d6 : 5, 2, total 7

Lower Leg
Rolled 2d6 : 6, 2, total 8

Upper Leg
Rolled 2d6 : 2, 6, total 8


Salvage Armor
Regular tech (TN 7+) + location mod (0, DropShip) + repair mod (-2, replace armor) + Quirks (0, Normal) + extra time (-1, double) + parts (+1, Salvage) = 5
Rolled 2d6 : 3, 2, total 5

Logged

Timberwolfd

  • Administrator
  • Major
  • *****
  • Posts: 2953
  • Kibitzing from the sidelines
    • View Profile
Re: After Action Repair Example and revised repair spreadsheet
« Reply #8 on: March 25, 2017, 11:38:39 PM »

Installing actuators in new leg (there is an argument to be made that these three rolls don't need to be made because  you are considering it as a replacement where one component is removed and one inserted, but these activities took place over weeks during down time, so here are the installation rolls)

Install 3 Actuators (Foot, Lower Leg, and Upper Leg)
Regular tech (TN 7+) + location mod (0, DropShip) + repair mod (-3, replace actuator) + Quirks (0, Normal) + extra time (-1, double) + parts (+1, Salvage) = 4
Foot
Rolled 2d6 : 6, 6, total 12

Lower Leg
Rolled 2d6 : 4, 5, total 9

Upper Leg
Rolled 2d6 : 3, 2, total 5


Install Armor
Rolled 2d6 : 4, 1, total 5
Logged

Timberwolfd

  • Administrator
  • Major
  • *****
  • Posts: 2953
  • Kibitzing from the sidelines
    • View Profile
Re: After Action Repair Example and revised repair spreadsheet
« Reply #9 on: March 25, 2017, 11:43:51 PM »

And, finally, the Wyvern will be operational on July 4, 3044.
The Shadow Hawk, Centurion and Crusader were back to 100% by June 12, 3044
« Last Edit: March 26, 2017, 11:06:23 AM by Timberwolfd »
Logged

Timberwolfd

  • Administrator
  • Major
  • *****
  • Posts: 2953
  • Kibitzing from the sidelines
    • View Profile
Re: After Action Repair Example and revised repair spreadsheet
« Reply #10 on: March 26, 2017, 12:28:31 PM »

Here is a repair flow chart to help people along.
Logged

Black Omega

  • Unrepentant Kell Hound Fanboy
  • Captain
  • ******
  • Posts: 2468
    • View Profile
Re: After Action Repair Example and revised repair spreadsheet
« Reply #11 on: March 26, 2017, 01:20:45 PM »

Beautifully laid out.  Thanks for the example.
Logged
"Slavish adherence to formal ritual is a sign that one has nothing better to think about."