OrientDig: How to Track QC Progress in the OrientDig Spreadsheet
In archaeological projects, maintaining organized records of artifact quality control (QC) is crucial for both academic integrity and project management. The OrientDig spreadsheet system provides a streamlined approach to tracking photographic documentation, acceptance status, and storage timelines—all in one centralized location.
Understanding the Spreadsheet Layout
The OrientDig QC spreadsheet is structured with the following key columns:
| Column Header | Description | Data Format |
|---|---|---|
| QC Photo Date | Records when photographic documentation was completed for each artifact | DD/MM/YYYY or as per project preference |
| Acceptance Status | Indicates whether artifacts passed QC standards | Approved/Referred/Rejected (with color coding) |
| Storage Time | Tracks duration artifacts have been in storage | Days/Weeks/Months or specific dates |
Effective Progress Tracking Methods
1. Date-Based Monitoring
Use the QC Photo Date
2. Status Filtering
Leverage the Acceptance Status
3. Storage Duration Analysis
Utilize the Storage Time
Best Practices for Optimal Record Keeping
Consistent Data Entry
Establish clear protocols for date formatting and status categorization to maintain data integrity across multiple users.
Regular Audits
Schedule weekly reviews of the spreadsheet to identify discrepancies, missing data, or workflow bottlenecks.
Visual Indicators
Use conditional formatting to highlight overdue items, rejected artifacts, or objects approaching storage limits.
Conclusion
The OrientDig spreadsheet system transforms quality control tracking from a administrative chore into a valuable analytical tool. By consistently utilizing the QC photo dates, acceptance status, and storage time columns, archaeological teams can maintain comprehensive records while gaining actionable insights into their excavation processes. This standardized approach ensures that every artifact's journey—from discovery to storage—is meticulously documented and easily accessible for project analysis and reporting.