Overview
To accurately review, clean, and standardize experimental sample tracking data from lab logs and instrument output files, ensuring all records are complete, consistent, and error-free for reliable tracking and analysis.
Scope of Work
Extract required information from lab logs and instrument output files
Identify and remove duplicate or redundant sample records
Correct formatting inconsistencies for sample codes, dates, storage locations, and technician names
Standardize all entries for uniform structure across the spreadsheet
Verify completeness and flag missing or unclear data
Ensure result summaries are accurate and consistently formatted
Maintain confidentiality and integrity of all laboratory information
Required Data Fields
Sample Code
Collection Date
Storage Location
Analysis Date
Technician Name
Result Summary
Instrument / Equipment Used
Sample Type
Batch / Project Reference
Data Entry Date
Deliverables
Delivery One: A Word document report summarizing the data cleaning process, issues identified, corrections made, and number of samples processed
Delivery Two: The final cleaned, standardized, and verified spreadsheet/database containing all experimental sample records
Client Materials
All lab logs and instrument output files will be provided upon hire.
Deadline
All deliverables must be submitted on or before 17th February 2026 at 10:00 PM.