Closed aecryan closed 2 years ago
Add IDs anonymized from team members and number of applicants.
Concatenate round and ID number from applications. ID numbers can be found in columns A and B for unique ID.
I saved a copy of the sheet with project names + associated IDs in Teams > Applications.
To count number of applicants, names were anonymized using the procedure outlined here: https://www.excel-exercise.com/anonymise-your-data/ and unique values were counted in R.
https://docs.google.com/spreadsheets/d/1pEdWUvcnKMdp0KD5XpEhleFqA7hAbDm6VxagN0yTqMU/edit#gid=1866850440