Check for Blanks in Members' Info

The steps here are used to check for blank details of members' information. You can use this to audit your OGD for missing details.

Note: The steps here require knowledge of Excel file. You can ask around or google for the steps to use certain functions.

Update the Audit Report Excel file

• Download this Excel file (xlsx). This file has sample data to used to generate the audit report.

  • • In Google Sheet, click File > Download > Microsoft Excel (xlsx).

• Click the Temp sheet/tab.

• Delete all the contents of the Temp sheet/tab.

• Copy the contents of the CSV file and paste them into the Temp sheet.

• Insert 2 columns to the right of CHAPTER column. These will be used when you split the Chapter column into 3.

• Use the "Text to Columns" function for the Chapter name to split it into 3 columns -- Area, Cluster, Chapter.

  • • If you do not know how to do this, check this reference.

    • Here is a video capture of the procedure.

• At the top row

  • Change "CHAPTER" to "AREA".

  • Enter "CLUSTER" and "CHAPTER" to label their respective columns.

• Click the "OGD" sheet and delete all its contents.

• Click the "Temp" sheet and copy all its contents.

• Click the "OGD" sheet. Go to the A1 cell and press Ctrl-V to paste all contents from the "OGD" sheet.

• The Report sheet should auto update.

• Update the date.

Here is a sample report:

We may have some members who do not want to have their personal data in OGD. Please refer to this guide.