Excel Worksheets + Lumetics LINKTM

Lumetics experts provide support and training to our global clients. We provide supplementary downloadable material to help streamline your process. Let LINK do your heavy lifting!

How Can LINK Help With Excel Worksheets?

LINK is the software solution for automated analytical data import, analysis, and reporting.  LINK scans network locations for new measurement files, extracts all useful data, and copies this data directly to a centralized database. The powerful analysis user-interface allows datasets to be aggregated, grouped, and visualized in the form of charts/tables/images. User-customizable analysis templates deliver rapid and error-free data visualization, with the ability to be replicated across many studies and shared within your organization.

LINK supports the ability to import Excel Worksheets as measurement files. These contain header rows and columns that are then transformed into LINKdb fields and values. Once imported, visualization preferences can be structures around the excel data. LINK has been demonstrated to deliver time savings more than 90% and provide a highly affordable fully automated data management and analysis solution.

Common Excel Worksheet Application Areas

LINK may be utilized to assist directly in the following application areas:

  • Any data for instruments currently not supported by LINK

  • Additional/specific measurements

  • Measurements with no raw data

  • Metadata import

Visualize your Excel Worksheet Data with LINK

Tabular Summaries

Excel: MSTT

Critical Quality Attribute vs. Process Variable 

Excel: CQA vs. Process variable

Critical Quality Attribute vs. Process Variable 

Excel: CQA vs. Formulation

Multiple Critical Quality Attribute Visualization

Excel: Radar multiple CQA

Multi-Factor Visualization 

Excel: Multi-layer x-axis
Additional Information for Excel Workbook Instrument Import

LINK has specific requirements for the import of excel workbooks as instrument measurement data, including:

  • LINK requires use of the Lumetics Excel Measurement Import Template to import data from Excel.
  • Currently, no raw curve data may be imported from Excel. Therefore, the dashboards that can be utilized to visualize excel data are: Column chart, Trend chart, XY scatter, 2D Histogram, and Radar Chart.
  • Data from another spreadsheet can be copied directly into the Import tab of the Excel Measurement Import Template worksheet (paste special as values only, is recommended).
  • Each row in the Excel worksheet is considered a measurement in LINKdb.
  • Cells must be formatted as General (other formats, such as number, will not import properly)
  • A value for the Sample Name column is mandatory, otherwise that row is omitted.
  • Measurements are considered unique based on the file name, Excel row number, sample name, and analysis date (if present).
  • For LINK to have a field available as a Y-axis option, all values must be numeric (ie. no text). If a single text value is present, the field will not be available as a Y-axis option but rather as an X-axis option.
  • There can be no blank header columns. LINK will read the empty header column as a trigger to “stop” the import, therefore anything after this column will not be imported. This is rule also applied to the excel rows. If there is a completely empty row, LINK will trigger a ‘stop’ and not read further rows.
  • Special Characters (ie. ‘ + = % $ # μm) are currently not supported.
  • LINK will read header fields as duplicated if when stripping out the special characters, the root name is the same. (i.e >=2 μm [FlowCam] removing > = + [ ] is then the same as <2 μm [FlowCam]). Therefore, unique header names are recommended.

Support for additional data file formats is available free of charge – please contact Lumetics for additional information!

Downloadable Content

Learn more with each downloadable application note that provides a more detailed overview for advanced LINK functions and specific instrument instructions. This includes information on instrument mandatory import file types, raw curves included, and specific import method options. In addition, Lumetics provides an extensive built-in dashboard library within your LINK instance from LINK version and later. For development of custom dashboard/analysis templates, contact Lumetics.

Interested in a live demo?

Contact Us