Microsoft Excel Add-in

The Excel Add-in is an integrated tool that connects directly to your operational database, enabling efficient extraction and analysis of laboratory data within Microsoft Excel. It offers a range of data retrieval options and flexible ways to display information for both management and analysts.

Among its most commonly used features are QC results analysis and the automatic generation of control charts, which support effective quality control monitoring. You can also download client sample results, view comprehensive lab statistics, and upload client submittals directly through the add-in.

This functionality streamlines data access and reporting, making it easier to manage laboratory performance and maintain high analytical standards. It also complements the robust AssayNet LIMS by extending its reporting and analysis capabilities into Excel.

The Add-in includes a variety of options designed to support common laboratory workflows. Below is a brief description of each available feature.

Upload Submittal—Upload client submittals (client sample IDs) directly from Excel into the submittal table.

Download Lab Stats—Extract laboratory statistics such as turnaround time or workload summaries. These statistics must be configured in the AssayNet LIMS.

Download Results by Sample—Retrieve results for specific sample IDs or batches.

Control Charts—Extract Quality Control data, failed criteria, and comments entered for failed QC. Automatically generate control charts for monitoring QC performance. This is the most common and comprehensive quality control extraction.

This section describes how to use the most commonly used Excel Add-in options to get the most value from this tool in your daily operations. The help topics do not cover every available option—only the most frequently used ones. If you have questions about any option not discussed here, please contact the AssayNet support team.