Jones Environmental EDD to Excel Table
What a Jones EDD looks like
Jones Environmental delivers an Excel EDD with a row for every analyte on every sample, with the sample ID, collection date, matrix, analyte, CAS number, result, units, reporting limit and qualifier. A single file often mixes matrices, for example Water and Soil rows from the same event.
Common problems when tabulating by hand
- Mixed matrices in one file: groundwater and soil rows have to be split before you build the table.
- Vapor results reported twice, in ug/m3 and in ppmv.
- Non-detects at different reporting limits across samples because of dilutions.
- Compound names that do not match your earlier tables.
Getting a clean table
- Upload the Jones EDD. The matrix on each row decides which tab (groundwater, soil, soil vapor, indoor air) it belongs to.
- Analytes are matched by CAS number and renamed to standard names.
- Pick an analyte template or a custom CAS list.
- Download the Excel table and Word summary. Notes, qualifier definitions and acronym definitions are added at the bottom.
Units
Groundwater is reported in ug/L, soil in mg/kg, and soil vapor and indoor air in ug/m3, so tables stay consistent from one event to the next.
Eulallia reads Jones Environmental and Calscience EDD layouts today.
Try Eulallia on your next EDD
Your first 5 EDDs are free. After that it is $19.99 per EDD, invoiced monthly.
Sign up