Monthly Squadron Evaluations

Monthly Squadron Evaluations (MSEs) are the most important piece of paperwork that CMDRs must complete. For your pilots to get awarded the shiny medals and get promoted, the MSEs must get done!

Don’t let the spreadsheet intimidate you. All you must do is follow the steps! We’ll first assemble all the tools, then we’ll start plugging in the numbers.

Data Assembly

GONK

GONK is the CMDR’s best friend. Available at https://gonk.vercel.app/, it collates all of the database activity for each of your pilots and displays it in an easily readable way so you don’t have to search!

After navigating to the page, you are prompted to enter the Squadron ID and the start/end dates of the period of interest (your squadron’s ID can be found by navigating to its database page and looking at the end of the URL).

You are then presented with the roster and all database information about their activity that month. Here is a non-exclusive list of what it catalogs:

• LoS/LoC count
• IU courses completed
• Fictions submitted to the database
• Single-player missions flown (see below for more details)
• INPR updates
• Promotions
• All medals received (including SO database medals you need to ignore)
• Website timed-test creation/participation

Website Statistics

Another way to see some of this information is on the website. Select “View MSE statistics” while on your home management page. Select your squadron from the drop-down menu shown.

This is a more concise presentation that focuses on the Legions and SP missions your pilots do. It is good practice to cross-check these numbers with the GONK numbers to make sure things are all being counted for!

Pilot DMs

There are some things that the above two links do not help with, like

• most competition participation
• fiction shared but not posted on site
• WIKI updates
• and more.

It is important that these things still get included in the MSEs, so it is best practice to message each pilot that potentially has these activities and ask!

MSE Completion

Now that you have all that information, let’s actually put it into the MSE spreadsheet. This is the general structure of a pilot's MSE sheet. <image>

• Each month, copy the previous month’s row by clicking on its row number to highlight all of the cells, hitting ctrl+c, and then ctrl+v when clicked on the next row down.
• Update the month and year in the A column.
• Ensure their rank and position is up-to-date in columns B and C.
• Make sure you don’t forget assistant positions like COOA, TOA, ROA, and others.
• Ensure the “Months Since Last Promotion” cell (Y2) is correct.
• Mark in column E if they communicated during the month. MoC validation is done by the CMDR on the website - see below for more information.
• Using the data tools from before, fill in the next six columns as appropriate. Input the number of each activity done, and it will be multiplied with its point value later.
  • Competitions with multiple rounds are only counted by each round if medals are awarded after each round
  • Right click to “Insert Note” and list each competition
• Column S is for Miscellaneous activities. Use the Insert Note function again to describe activities done. Here are some examples of Misc activities and their values:
  • INPR Updated (1)
  • Uniform Created (1 or 2 depending on background/creativity)
  • WIKI article updated (1)
  • Fiction Submitted (1 point per 200 words)
  • IU course passed (4 points)
    • Steam Introduction [STM] is worth 3 points
    • Corps/Flagship/Mission Creation exams (TCCORE, COE/2, and MCBS, for example) are worth 5 points
• The Total column automatically tallies up the entire month.
• The Budget column automatically adds the total to any previous unused points.
• The Medal Recommendation column is where you input what medal, if any, they earned with their Budget points. The thresholds for each medal are:
  • ISM (20)
  • PC (55)
  • BS (100)
  • SS (250)
• The Carryover column automatically shows how many points were used from the previous budget to award the medal.
• The Balance column automatically shows the remaining balance (0 no matter what if an SS was awarded).
• Column Z is for your CMDR comment. Write about that pilot’s month, talking about communication and activity. Make sure to mention any promotions, RSV moves, or other important bits.
• Update the first page of the MSE tracker. This is a list of pilots and your medal recommendations.

After completing these steps, you’ve done the MSE! Repeat for all pilots, then notify your chain of command in the CoC Discord DM group that your MSE is ready for review.

Edits or approvals will be passed to you, and after the SOO approves, you are free to make your medal recommendations.

Important Note: Never delete MSE pages, even if a pilot goes RSV, transfers to another squadron, or disappears off the face of the galaxy. Simply hide the page by right-clicking on the tab and selecting “Hide sheet.”

Medal Recommendations

The website process for MSE medal recommendations is the same as the IAR process. See the IAR Process article for those details.

• If a medal you are awarding for a pilot utilized budget points from a previous month (shown as a negative value in the Carryover column), reference this in the award recommendation. An example of this wording is below.

MoC Validation

• Navigate to the “MoC Eligibility Validation” page through your Management page.
• This will pull up the MoC validation for the current month. To navigate to a previous month, select it from the drop-down menu and hit “Go.”
• On each pilot’s row, toggle the drop-down menu to “Validated” (unless they did not communicate that month).
• Select "Update" at the bottom of the page to submit.