Meeting Data Audit: New Template Test

# Issue Template Details

Issue name: Meeting Data Audit: [Replace PROJECT NAME]
Labels: feature: calendaring, prep, status: needs Slack audit document, status: needs Slack audit, status: needs Slack channel(s), status: needs audit spreadsheet, status: needs Zoom Setup data, status: needs automation formulas, status: needs calendar event audit, status: needs Zoom accounts audit, status: needs Slack audit, status: needs hackforla.org/VRMS audit, status: needs Slack reconciliation, status: needs post audit messaging, status: waiting on team feedback

------

### Overview
We need to audit all calendar events for a given project to match the Zoom Setup and Zoom Audit Spreadsheet so that we can optimize the availability of the Zoom rooms and have the most current meeting information.

### Prerequisite
#### If you are not the PM on the project this issue is for
- access to the 1Password vault for Google Drive Migration
- know your GitHub username and password so that you can use it in the (Google Drive Migration) hfla-email-all@hackforla.org Chrome profile
#### If you are the PM on the project this issue is for
- access to the 1Password vault for the project
- access to the project's shared drive through the project's email Chrome profile
- [x] add the project's email as a `Content Manager` if the drive is not already shared with the email
- know your GitHub username and password so that you can use it in the project email's Chrome profile

### Action Items

#### Setup Access Through Proper Profile
- Non PMs
- [x] Log into the [hfla-email-all@hackforla.org](mailto:hfla-email-all@hackforla.org) email and open it in a new chrome profile, so that you can access the account's calendar
- [ ] open this issue in the hfla-email-all profile browser and follow steps to Access GitHub
- PMs
- [ ] Log into the project's email and open it in a new chrome profile, so that you can access the account's calendar
- [ ] open this issue in the project's profile browser and follow steps to Access GitHub

#### Access GitHub
- [x] Log into your GitHub account. If you are already logged in you will see either your icon. If you are not, you will see a sign-in button top right in the issue that is open now in the new profile browser.
- [x] Close any other browsers you have open that are not in the new profile browser, so that you don't end up opening links in the wrong browser (this will be particularly important when you are accessing drives)

#### Add Org Level Audits folder to Starred
If you do not see the project's drive in the list of shared drives, see Prerequisite
- [x] access the `Org Level Audits` folder in the project's shared drive
- [x] right click on the folder and select `Add to starred`

#### Prep
For each of the following items, there are instructions in the wiki. Copy the instruction for next item to be checked off (must do them in order), to a comment below, and then complete the tasks in the comment.

During these tasks you will be asked to add link to resources, and that section is at the bottom of this issue (go view it now).

- [x] [Create Slack Audit document](https://github.com/hackforla/admin-calendaring/wiki/Create-Slack-Audit-document) (open in new tab)
- [x] [Add Slack channel(s) to the Slack Audit document](https://github.com/hackforla/admin-calendaring/wiki/Add-Slack-Channel(s)) (open in new tab)
- [x] [Create Meeting Data Audit and Reconciliation Spreadsheet](https://github.com/hackforla/admin-calendaring/wiki/Create-Meeting-Data-Audit-and-Reconciliation-Spreadsheet) (open in new tab)
- [x] After the first 3 Prep items have been checked off and their labels removed,
- [x] remove the `prep` label
- [x] add the `admin prep` label
- [x] move issue to `Prioritized Backlog` on the project board
- [x] unassign yourself
- [x] remove the `Org Level Audits` folder from Starred
- [x] access https://drive.google.com/drive/starred (open in new tab)
- [x] look for the `Org Level Audits` folder that belongs to the project
- [x] right click on the folder and select `Remove from starred`

#### Admin Prep
- [x] [Import project's data from Zoom Setup spreadsheet](https://github.com/hackforla/admin-calendaring/wiki/Import-project's-data-from-Zoom-Setup-spreadsheet)
- [x] [Setup Automation Formulas for the Audit](https://github.com/hackforla/admin-calendaring/wiki/Setup-Automation-Formulas-for-the-Audit)
- [x] After the first 2 Admin Prep items have been checked off and their labels removed,
- [x] remove the `admin prep` label
- [x] add the `audit` label

#### Audit
**NOTE: There is autogenerated data in the spreadsheet you will be using so please do not edit any `Auto Notes`, `Changes Required` or any auto-filled columns**
- [x] [Perform Calendar Event Audit](https://github.com/hackforla/admin-calendaring/wiki/Perform-Calendar-Event-Audit)
- [x] [Perform Zoom Accounts Audit]( https://github.com/hackforla/admin-calendaring/wiki/Perform-Zoom-Accounts-Audit)
- [x] [Perform Slack Audit](https://github.com/hackforla/admin-calendaring/wiki/Perform-Slack-Audit)
- [x] [Perform hackforla.org/VRMS Audit](https://github.com/hackforla/admin-calendaring/wiki/Perform-hackforla.org-VRMS-Audit)
- [ ] After the first 4 Audit items have been checked off and their labels removed,
- [ ] remove the `audit` label
- [ ] add the `reconciliation` label
- [ ] move issue to `Prioritized Backlog` on the project board
- [ ] unassign yourself

#### Reconciliation
- [ ] [Reconcile the Slack Audit document with the Slack Audit Sheet](https://github.com/hackforla/admin-calendaring/wiki/Reconcile-the-Slack-Audit-Document-with-the-Slack-Audit-Sheet)

#### Recommendations and next steps
- [x] [Create and send message to PMs via Slack](https://github.com/hackforla/admin-calendaring/wiki/Create-and-send-message-to-PMs-via-Slack)
- [ ] [Review team feedback and respond](https://github.com/hackforla/admin-calendaring/wiki/Review-team-feedback-and-respond)

#### Resources/Instructions
1.0 [Zoom Setup Spreadsheet](https://docs.google.com/spreadsheets/d/15P3MYyNQ7Xn0pqdrTynDDipjrLl5LCN9xHVLhk9SWa8/edit#gid=1276874845)
2.0 [New Template Test: Slack Audit Document](https://docs.google.com/document/d/1XeJLXIQAGgVhgmKw0jX4JT84K3Pq2z-j1H1ai92hqgQ/edit)
3.0 [New Template Test: Meeting Data Audit and Reconciliation Spreadsheet](https://docs.google.com/spreadsheets/d/16YcLy3RaFw7SZkuYwChPRrlTnHLeou6WXF0Odi1U4jo/edit#gid=528730849)