Measure salinity, acidity, light, oxygen content, and other physical conditions of water to determine their relationship to aquatic life.

I have a spreadsheet of field readings from Pond 3—salinity, pH, dissolved oxygen, light lux, and temperature by sample point and date. Send the attached renewal proposal to Priya in procurement and the finance director for e-signature, signers in that order, with a Friday deadline -- check it's complete first.

Before I share this dataset with the research PI, make it easy to interpret—surface the summary correlation of salinity and dissolved oxygen up top, make recent pH trends findable by date, and flag any outlier readings that should make a reviewer hesitate.

I merged the new logger export with last month's station sheet and the average dissolved oxygen rose 1.8 mg/L. Lily the field tech swears she followed the protocol and I can't reach her to confirm. I’m afraid the merge duplicated rows or changed units. What is the most likely mistake and the fastest sequence of checks to prove or fix it before I tell the PI?

Across projects I keep rebuilding the same salinity, pH and DO pivot tables from raw exports and redoing QC checks by hand, which wastes time and risks inconsistent flags. Where should I standardize or change a habit so summaries are reproducible and I stop shipping different numbers to collaborators?