Excel Data Deidentification
Budget: $30 – $250 AUD
I'm looking for an expert in Excel to help me deidentify some sensitive information in a spreadsheet. The specific task involves:
- Changing the 'email stub' column to remove identifiable information without corrupting the formulas that rely on this data. This is data that mostly has names in it because it is the stub of an email without the domain.
- Ensuring that the deidentified values are unique and the formula on other sheets still work to perform a statistical test.
The original data should be preserved in a separate file.
Ideal candidates for this project should have extensive experience with statistics in Excel (uses a Wilcoxon signed rank test with paired data), data anonymization, and a strong understanding of maintaining formula integrity during data manipulation.
- Changing the 'email stub' column to remove identifiable information without corrupting the formulas that rely on this data. This is data that mostly has names in it because it is the stub of an email without the domain.
- Ensuring that the deidentified values are unique and the formula on other sheets still work to perform a statistical test.
The original data should be preserved in a separate file.
Ideal candidates for this project should have extensive experience with statistics in Excel (uses a Wilcoxon signed rank test with paired data), data anonymization, and a strong understanding of maintaining formula integrity during data manipulation.