Updated LIMS Data Query Workbook Now Available

With LIMS’ integrated Excel interface you can quickly export the data from any LIMS report to Excel. When the data you need cannot be easily gathered using an existing report, the LIMS Data Query workbook is the solution. With this general[1]purpose Excel tool, you can add LIMS data from any Structured Query Language (SQL) Select statement directly into Excel.

To retrieve LIMS data simply start LIMS on your workstation, open the workbook, enter a valid SQL Select statement on the Query worksheet then click the Query button to add the data to the LIMSData worksheet. In practice, you will find it simpler to save each SQL Select statement you commonly use to its own renamed copy of the workbook. Save your copy of the workbook as an Excel template file and you can just double-click the template in Windows Explorer to create a new workbook for your queried data without altering the original template.

We recently updated the LIMS Data Query workbook with new settings on the Query worksheet. Use the “Include Field Names” option to enable or disable adding field names for the queried data to the first row of the LIMSData worksheet. With “Clear LIMSData Mode” set to “Contents” you can preserve your own column formatting when queried data is added to the LIMSData worksheet.

The workbook’s ReadMe worksheet now includes examples of SQL Select statements requested by [1]LIMS users. Data returned by these example SQL Select statements include:

· Customer sample count for a collected date range

· Customer sample count by week for a collected date range

· Active customers with no samples for a login date range

· Total amount billed by customer for a completion date range

 · Total number of samples and total amount billed by customer for a completed date range

· Total number of samples, total amount billed, and average amount billed per sample by customer for a completed date range

· Project sample count for a login date range

· Analysis count for a sample login date range

· Analyses by month for a sample login date range

· Number of analyses in each project

· Project analysis specifications that differ from default analysis specifications

See Query Data with the LIMS Data Query Workbook in the Knowledge Base for more information and download file LIMS Data Query.xls from the File Library to get started with this valuable tool.