S1 Operations - AAR Life Cycle

This is the Document Release Information
Article Number:	7CAV-DR-006
Scope:	S1 Operations - Life Cycle of an After action report
Version:	Version 1.0
Effective Date:	21MAR21
Last Modified Date:	21MAR21
Approving Authority:	S1 Officer in Charge
Point of Contact:	S1 Officer in Charge

Introduction

This policy will detail the process to process Operational AARs in the MILPACS System.

Life Cycle Process

This section will detail how to process an AAR.

Step 1

Once an AAR is posted, the first step is to add it to the “Operations” tab. Right click on Row 3 and press “insert 1 above”.

Step 2

Next type the campaign name(if applicable) and Operation name into the C and D column respectively. It is key to note: do not write “Operation” or “campaign” in the C or D column.

Step 3

Add the AAR link into the H column, date of the mission into the F column and the AO into the G column.

Step 4

Bark “awaiting thread lock in the A column. Examples:

Step 5

Once 7 days has passed since the Operation was ran, column E will turn green, this means it’s ready to process, we wait 7 days so that the OIC has enough time to update the master list.

Step 6

Lock the AAR thread.

Step 7

Comment “LOCKED” on the AAR post.

Step 8

Mark column “A” as Awaiting MILPACS.

Step 9

Move to the “Troopers” tab, right click on the “L” column and select “Insert 1 left”.

Step 10

Type the Operation name in row 1, column L and copy/paste the formula from row 4 column M into Row 4 Column L.

The L column should be displayed like this:

• 0

Ensure that you type the name of the Operation in the same way it’s typed on the “Operations” tab or you will get an Error

Step 11

Move to the “Rank Remover Utility” CTRL+C from the AAR post’s master list, then CTRL+SHIFT+V into row 4 column B

• If it shows “format” in the H column, it means the rank is incorrect, the trooper could have been promoted/demoted since then, so try the rank above, if it still shows format, check their MILPACS to see their rank.

Step 12

Ensure that none of the names say “FORMAT” in the H column

Step 13

Transfer the troopers to the Operation builder, there’s a button in the top left of the screen, but sometimes it is not visible:

• If you left click here it will run the script and this will display at the top of your screen:

• This will appear in the bottom right once the script has finished:

Step 14

Move to the Operations builder, and make sure all boxes are green:

1. Check 1: If Check #1 fails that means that the trooper has been entered multiple times on this list. >>Delete<< the rows that are multiples. DO NOT LEAVE ANY GAPS BETWEEN TROOPERS ROWS.

1. Check 2: If Check #2 fails then the trooper's name was not found in MILPACS. Check for correct spelling.

1. Check 3: If Check #3 fails the trooper needs to be added to the 'Troopers' sheet before running the script.

How to Add a Trooper

• Move to the “Troopers” tab
• Locate the alphabetical position (firstname) that the new trooper must go
• Insert a new row where they must go:

• Insert their name into column C, check their MILPACS, if they have any previous Operations attended add the number of Operations into the D column, if they haven't attended any just put ”0”.
• Drag the formula from the E and F column down into the boxes.
• In the “G,H,I and J” column write “0” and ensure all of them are not colored.

• If the person has been awarded a service ribbon in the past, colour one of the sections green relative to the medal they have been awarded.

Step 15

Once all checks are green, select the Operation you are processing from the drop down menu and press the button at the top(this can also appear as invisible but it is located here:

Step 16

Check that troopers were added to the sheet:

• To do this, move to the “Troopers” tab and check that it says “MILPACS” in the L column in at least one row.

Step 17

Move to the “MILPACS Helper” tab and select the Operation you are processing at the Top.

Step 18

Add the Op to MILPACS.

• Copy the verbage
• Press the right hand link of that row
• Paste the verbage
• Change the Roster type to “Operation”
• Change the Record date to the date of the OP
• Press save

Step 19

Once all the troopers are complete, go to the “Troopers tab” in the top where it says “S1 Tools” go to “MILPACS>complete” then “Complete L column”:

Step 20

Go to the “Operations” tab and change the status to “Complete”:

Step 21

Ensure the troops tab is displaying Operation attendance:

Step 22

Comment on the AAR post “S1 Operations Updated”.

Step 23

Add your name into the “processed by” column on the Operations tab. You have successfully processed an operation.