Adding a new event type

This page describes the process of adding a new event type to any wing on the database.

This action requires you to be at least familiar with Google Sheets

1 - Head to the settings sheet for the selected wing

2 - Add the event to the list of events

When verified, events have some junk in their names,

Example: Gamenight [Officer/Engagement]

This junk is removed by the database to obtain clean names in the formula in the cell 'Compute sheet'!I3

3 - Head to the members sheet and scroll to the right until you hit the last column

4 - Right-click the last column corresponding letter and click "Insert 1 column to the right"

This will create a blank column to the right

5 - Copy the value from the previously last column into the blank column by: selecting the corresponding letter for the previously last column, Copying, selecting the corresponding letter for the blank column, pasting

What you should get at the end of this step

6 - Select the cell on the header row of that new column and edit the formula: You should increment the row number for the first range in the formula

After this step, you should see your new event name appear

7 - Edit the formula in the "Points" header row cell to add the new column and the new settings

Add at the end, before the first parenthesis:

• [Your new column letter]9:[Your new column letter] * [The first range you’ve just modified in the previous formula]

In our example we would add:

• Y9:Y*'Progression wing settings'!D17

After editing the formula, it looks like this

8 - Merge the cells at the top with the title cell to make it pretty

You're done!

Your event is ready to be used!

You still need to add it to the verification form