Excavate historical and archaeological sites

The excavation logs and context register need to be reviewed and then sent to the site director and the archive curator for sign-off by Friday. Check that every context has date, depth, finder, and linked photograph reference, confirm the stratigraphy sheet recalculates total depths when new contexts are added, then email the complete workbook to Tom at field operations and to Dr. Evans in the archive in that order with a Friday deadline.

Before I hand this to the site director, make the context register easy to approve: put the high-level site summary and most likely dating at the top, make the finds count and conservation flags immediately visible, and flag any contexts that lack photo or section drawings that would make a reviewer hesitate.

I merged trench logs from two teams and now context 112 has no photo and the site director suspects it was overwritten. I’m not sure if I misaligned rows, changed the photo ID column header, or swapped which folder we point to. What is the likeliest cause and the quickest set of checks to recover or prove the photograph linkage before Tom asks?

After several seasons I still spend days fixing mismatched context IDs and missing photo links between field packets and the archive. Which file convention or brief pre-upload checklist will stop these recurring errors so the archive curator trusts the dataset and I stop doing last-minute rescues?