Guide

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

The workflow

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