Calscience EDD to Excel Table: Turn a Lab EDD into a Report-Ready Table
What is in a Calscience EDD
A Calscience electronic data deliverable is an Excel file with one row per analyte per sample. Each row carries the sample ID, matrix, collection date, analyte name, CAS number, result, units, reporting limit, method detection limit and lab qualifiers. Every analyte for every sample is present, including non-detects.
Why copy-pasting into a table goes wrong
- Analyte names differ from your previous lab, so the same compound lands in two columns.
- Non-detects need to read ND<RL, with the correct limit per sample, which changes when a sample is diluted.
- Soil vapor and air results appear twice, in ug/m3 and in ppbv or ppmv, and the wrong row is easy to grab.
- A single EDD can contain several matrices, so groundwater, soil and vapor rows have to be separated before tabulating.
The workflow
- Upload the Calscience EDD to a project.
- Each row is matched to a standard analyte name using its CAS number.
- Pick a built-in analyte template, for example petroleum or VOCs, or build a custom list from the CAS catalog.
- Choose the reporting basis (RL by default, MDL if your project requires it).
- Download a formatted Excel table and a Word results summary.
Qualifiers and non-detects
Lab qualifiers such as J (estimated, between the MDL and RL), B (blank contamination), E (above calibration range) and D (diluted) are printed beside detected values, with a footnote for each one used. Non-detects are shown as ND<RL using the limit the lab reported for that sample.
Using more than one lab
If another lab supplies part of the project, results still land in the same standard columns because matching is by CAS number, not by lab-specific spelling.
Eulallia currently reads Calscience and Jones Environmental EDD layouts. If you use a different lab, contact us and we will look at adding it.
Try Eulallia on your next EDD
Your first 5 EDDs are free. After that it is $19.99 per EDD, invoiced monthly.
Sign up