// SOLUTIONS

ICP LIMS Integration

Your ICP-OES and ICP-MS exports go straight into the OnWSH worksheet. Each reading lands on its sample and element column, keeps the original instrument value, and passes QC review before the result is published in OnLAB.

What this means for your laboratory: nobody retypes ICP results. OnLIMS supplies the reader for your instrument's export layout, and OnWSH places every reading on its sample row and on the working column for that element, wavelength or isotope. The analyst sees the match before anything is written.

From the instrument export to the worksheet

The import preview lists each element with its unit and the worksheet column it will fill. A green link means the reading has a column waiting for it; a red link means no column matches that element and unit, so nothing is written to the wrong place. Measurement labels such as Cu 324.754, Cu 327.395 or 63 Cu [He] stay distinct, so each line or isotope reaches its own column.

  • Matched by sample Readings are placed by the sample identifier the instrument reports, including blanks, standards, duplicates and repeats, in the run order the worksheet expects.
  • Matched by element and unit A technique suffix joins the element in the file to the column in the template: Zn66 with the suffix orig fills the Zn66orig column, in ppb. The unit in the file and in the column must agree before the link is made.
  • Your choice of line, your dilution When a sample has two lines, two ranges or a repeat, the analyst marks which reading the result uses. Each reading keeps its own dilution factor from the file: applying a factor of 5 turns 2.00 into 10.00, shown in bold italic, and the factor is marked as applied so it is never multiplied twice.

ICP brands and models we connect

The OnLIMS connection catalogue covers 150+ instruments from about 40 brands, including these ICP models. ICP-OES: Agilent 5100, 5110, 5800, 5900; Perkin Elmer Avio 550 max; Spectro Arcos; Teledyne Leeman Labs Prodigy, Prodigy High Dispersion; Thermo Fisher Scientific iCAP PRO X Duo; Thermo Scientific TJA 2000, iCAP 6000, iCAP 6300, iCAP 7000, iCAP 7600; Varian 725-ES, Vista. ICP-AES: Spectro Ciros. ICP-MS: Agilent 7700, 7900, 7900 & 5110, 7900-8800; Perkin Elmer DRC KINECTRICS, ELAN 9000, ELAN DRC II, NEXION 300X, NexION 2000; PerkinElmer NexION 2000x; Thermo Scientific iTEVA; Varian 820, Winmass Galaxy, Winmass UM700. OnLIMS sets up the reader for the model and export software in your laboratory.

Every result traceable to its instrument file

An auditor can start from any published result and walk back to the export it came from. In OnLAB, the result shows which worksheet supplied it; the worksheet cell shows the instrument and the reading exactly as imported, with its precision value; the worksheet's Instrument tab keeps the run, the source file, the number of readings and the analyst who imported them. For example, a Cu result of 10.15 ppb from a Varian WinMass ICP-MS traces back to the Cu65 reading of 10.15 in the run file. If anyone edits a reading by hand, the change is logged with date, time, user, previous and new value.

QC checked when results are locked

Out-of-range control samples are caught before results move on. When results are locked, OnWSH checks standards, blanks and duplicates against the limits of their QC record. An out-of-range value stops the lock and opens the Control Chart window with the observed value, the target, the accepted range and the history of that control. The analyst either cancels and investigates, or accepts with a written reason; an accepted value stays red, bold and underlined so every reviewer sees it.

Frequently asked questions

Which ICP export layouts does OnLIMS read?

OnLIMS has readers for Agilent ICP-OES long-table and worksheet exports, Agilent MassHunter ICP-MS, Thermo horizontal and four-row reports, PerkinElmer NexION spreadsheets and reports, and Varian, Spectro and Prodigy templates. We set up the reader that matches the export your instrument software produces.

Can I still see the original reading after calculation?

Yes. Every imported cell keeps the instrument that supplied it and the reading as imported, and the worksheet keeps the run log with the source file and the number of readings. Calculated results are written to their own result columns; the reading stays as imported.

What does an out-of-range QC review look like?

For example, a standard with a target of 1 and an accepted range of 0.9–1.1 that reads 5.000 shows a 400% error in the Control Chart window. The chart history shows whether it is a single outlier or a trend before the analyst decides.

Related: XRF LIMS integration · Balance LIMS integration · LECO LIMS integration · LIMS vs Excel · Instrument integration · Fire assay LIMS · Mining laboratory LIMS

Related reading

// TALK TO AN ENGINEER

Review your ICP export and worksheet

Bring an original export from your ICP and the elements, units and sample identifiers your laboratory reports. We will show you how it lands in an OnLIMS worksheet.

A person answers you, not a bot. Your details are only used to reply.

Prefer the technical detail first? Read the full technical specification, no call needed.