Perform hackforla.org VRMS Audit

Perform hackforla.org/VRMS Audit

Copy the following block of instructions into a new comment on your issue and select the green Comment button to create the comment. Follow the instructions in the comment you just created.

## Perform hackforla.org/VRMS Audit
### Purpose 
In this step, you will determine if the meetings on the project/CoP's page on hackforla.org match with the team calendar. There may be slight differences in the meeting names, meeting start/end times but if the majority of the data matches, consider the meetings a match.

### Task Outline
You will first open resource 1.0 and the page on hackforla.org for your project/CoP. You will copy the URL for the page and add it to the `Details` sheet of resource 1.0. Then you will access the `hackforla.org/VRMS` sheet, which has 3 sections. Only section 1 should have data. You will retrieve data into `Section 3` , copy and add it to `Section 2: Copy and Paste Meeting Details from Section 3 Here`.

### Task Details
#### Project specific steps (scroll down for CoP specific steps)
- [ ] Close the wiki page you just opened
- [ ] Open Resource(s)
   - open resource 1.0
   - access https://www.hackforla.org/projects
   - locate your project card and access the project's page
   - view side by side
   - copy the URL for your project's page
   - on the `Details` sheet in resource 1.0, replace the text that says `https://www.hackforla.org/projects/[Replace PROJECT-NAME]`, in B5 with the URL

_You will now copy and paste meeting data._
- [ ] In resource 1.0, access the `hackforla.org/VRMS` sheet
- [ ] In `Section 1` delete any rows without any data, except the last one
- [ ] Select the menu item `Get Data` and then select `Get Recurring Events`
    - columns D through G in `Section 3` should now have meeting data
      - if there is an error, please review [Errors and How To Resolve Them](https://github.com/hackforla/admin-calendaring/wiki/Errors-and-How-To-Resolve-Them) in a new tab
       - in case the error is unresolved and you have had to reach out to the Admin team
         - [ ] add the `bug` label and do not proceed further
- [ ] If there is data in `Section 3`, add the data to `Section 2: Copy and Paste Meeting Details from Section 3 Here`
_The values in column M, N and O will change as you perform this audit step_
  - start with the first meeting in column D of `Section 1: Meetings on the Team's Calendar` and find it's match in column D of `Section 3:`
     - if you find the match
       - select `YES` in column C of `Section 3` for that meeting
       - copy the `Name of Meeting`, `Week Day`,  `Start Time (PST)` and `End Time (PST)` for the meeting from section 3
       - paste the values into section 2 for the matching meeting starting from column I and ending at column L
    - if you don't find the match
      - leave I through L in `Section 2` empty for that meeting
   - repeat these steps for every meeting in `Section 1`
- [ ] Identify meetings that are on the project's page but not on the team calendar
    - select `NO` in column C of `Section 3` if there isn't already a `YES` selected
- [ ] Close out this task
_You are done with all the steps in this task. Close it out in the main body of the issue_
   - check the box for `Perform hackforla.org/VRMS Audit` in the `Audit` action items of this issue
   - remove the `status: needs hackforla.org/VRMS audit` label
   - close the tabs you just opened (wiki, spreadsheet, website)
   - hide this comment as RESOLVED, you are finished with this step
#### CoP specific steps
- [ ] Close the wiki page you just opened
- [ ] Open Resource(s)
   - open resource 1.0
   - on the Details sheet in resource 1.0, replace the text that says `https://www.hackforla.org/projects/[Replace PROJECT-NAME]`, in B5 with `https://www.hackforla.org/communities-of-practice`

_You will now copy and paste meeting data._
- [ ] In resource 1.0, access the `hackforla.org/VRMS` sheet
- [ ] In `Section 1` delete any rows without any data, except the last one
- [ ] Select the menu item `Get Data` and then select `Get Recurring Events`
    - columns D through G in `Section 3` should now have meeting data
      - if there is an error, please review [Errors and How To Resolve Them](https://github.com/hackforla/admin-calendaring/wiki/Errors-and-How-To-Resolve-Them) in a new tab
       - in case the error is unresolved and you have had to reach out to the Admin team
         - [ ] add the `bug` label and do not proceed further
- [ ] If there is data in `Section 3`, add the data to `Section 2: Copy and Paste Meeting Details from Section 3 Here`
_The values in column M, N and O will change as you perform this audit step_
  - start with the first meeting in column D of `Section 1: Meetings on the Team's Calendar` and find it's match in column D of `Section 3:`
     - if you find the match
       - select `YES` in column C of `Section 3` for that meeting
       - copy the `Name of Meeting`, `Week Day`,  `Start Time (PST)` and `End Time (PST)` for the meeting from section 3
       - paste the values into section 2 for the matching meeting starting from column I and ending at column L
    - if you don't find the match
      - leave I through L in `Section 2` empty in for that meeting
   - repeat these steps for every meeting in `Section 1`
- [ ] Identify meetings that are on the CoP's page but not on the team calendar
    - select `NO` in column C of `Section 3` if there isn't already a `YES` selected
- [ ] Close out this task
_You are done with all the steps in this task. Close it out in the main body of the issue_
   - check the box for `Perform hackforla.org/VRMS Audit` in the `Audit` action items of this issue
   - remove the `status: needs hackforla.org/VRMS audit` label
   - close the tabs you just opened (wiki, spreadsheet, website)
   - hide this comment as RESOLVED, you are finished with this step

TO DELETE
## Perform hackforla.org/VRMS Audit
### Project specific steps (scroll down for CoP specific steps)
- [ ] Open Resource(s)
   - open resource 1.0
   - access https://www.hackforla.org/projects
   - locate your project card and access the project's page
   - view side by side
   - copy the URL for your project's page
   - on the `Details` sheet in resource 1.0, replace the text that says `https://www.hackforla.org/projects/[Replace PROJECT-NAME]`, in B5 with the URL
#### Compare meetings in the Zoom Setup spreadsheet against meetings that appear on the project's page 
_In this step, you will determine if the meetings in the Zoom Setup Spreadsheet match with the project's page. There may be slight differences in the meeting names, meeting start/end times but if the majority of the data matches, consider the meetings a match._

Access the `hackforla.org/VRMS` tab and complete the following
- [ ] in `Section 1`, which is dependent on data in `Section 4`
   - if there is meeting data in `Section 4`, check that columns A and B are hidden (column C is the first column you will see)
   - if there is no meeting data in `Section 4`, check that the value in cell B2 is set to `NO`
- [ ] in `Section 3: Add Meeting Data from Section 4`, find matching meetings in `Section 4` and copy the data into columns H through K of `Section 3`
_The values in column C, M and N will change as you perform this audit step_
   - start with the first meeting in column D of `Section 2` and find it's match in `Section 4`
   - copy the `Meeting Name`, `Week Day`, `Start Time (PST)`, `End Time (PST) and paste (Crtl+Shift+V) the values into columns H through K in `Section 3`
   - if the meeting name is not in `Section 4`, leave the corresponding columns (H through K) empty in `Section 3` for that meeting
- [ ] in `Section 4`, indicate meetings that are on the project's page but not in the Zoom Setup spreadsheet
   - if there are any meetings in this section with no match in `Section 2` (you did not copy the data into columns H through K of `Section 3`), select `No` in column L for that meeting

### CoP specific steps
- [ ] Open Resource(s)
   - open resource 1.0
   - on the Details sheet in resource 1.0, replace the text that says `https://www.hackforla.org/projects/[Replace PROJECT-NAME]`, in B5 with `https://www.hackforla.org/communities-of-practice`
#### Compare meetings in the Zoom Setup spreadsheet against meetings that appear on the CoP's page 
_In this step, you will determine if the meetings in the Zoom Setup Spreadsheet match with the CoP's page. There may be slight differences in the meeting names, meeting start/end times but if the majority of the data matches, consider the meetings a match._

Access the `hackforla.org/VRMS` tab and complete the following
- [ ] in `Section 1`, which is dependent on data in `Section 4`
   - if there is meeting data in `Section 4`, check that columns A and B are hidden (column C is the first column you will see)
   - if there is meeting data in `Section 4`, check that the value in cell B2 is set to `NO`
- [ ] in `Section 3: Add Meeting Data from Section 4`, find matching meetings in `Section 4` and copy the data into columns H through K of `Section 3`
_The values in column C, M and N will change as you perform this audit step_
   - start with the first meeting in column D of `Section 2` and find it's match in `Section 4`
   - copy the `Meeting Name`, `Week Day`, `Start Time (PST)`, `End Time (PST) and paste (Crtl+Shift+V) the values into columns H through K in `Section 3`
   - if the meeting name is not in `Section 4`, leave the corresponding columns (H through K) empty in `Section 3` for that meeting
- [ ] in `Section 4`, indicate meetings that are on the CoP's page but not in the Zoom Setup spreadsheet
   - if there are any meetings in this section with no match in `Section 2` (you did not copy the data into columns H through K of `Section 3`), select `No` in column L for that meeting

### Close out this task
- [ ] You are done with all the steps in this task. Close it out in the main body of the issue
   - check the box for `Perform hackforla.org/VRMS Audit` in the `Audit` action items of this issue
   - remove the `status: needs hackforla.org/VRMS audit` label
   - close the tabs you just opened (wiki, spreadsheet, website)
   - hide this comment as RESOLVED, you are finished with this step