Use the Excel Add-in to Download Lab Stats

This activity describes how to download laboratory statistics using the Excel Add-in. Lab statistics are created and managed in the main AssayNet LIMS application and can include a wide range of custom metrics, such as determinations, total samples received, and other performance indicators tailored to your operation’s needs. All filtering options—including client, project, analysis, and sample type—are configured within the main application. The Excel Add-in is used solely to select the statistic and the date range, and to download the results into Excel. You can create as many custom statistics as needed in the main LIMS system to support their reporting and monitoring requirements. For more information, see Create and Configure Laboratory Statistics.

For best results, use a dedicated Excel workbook with clearly labeled tables and cell references for each statistic you want to download. When creating or editing statistics in the main application, assign the appropriate cell reference in Excel so you can easily track which downloaded data corresponds to each statistic. You can assigned the template create for each stats configured. This approach ensures your laboratory metrics are organized and easy to analyze.

This activity presumes you have the Excel Add-in installed. For more information see Install the LIMS Excel Add-in.

Activity Steps

  1. Open a new Microsoft Excel file.

    You may also use an existing Excel file, but any existing data might be overwritten.

  2. Right-click and select LIMS » Lab Stats. Alternatively, click the Add-in tab in the Excel ribbon and then click LIMS » Lab Stats.

    If you have not yet connected to your operational database, a Microsoft Excel information message window displays Lost Connection to LIMS.

  3. Click OK to reconnect. Follow Connect to the Excel Add-in to connect.

    The Statistics screen displays.

  4. Complete the following fields as required:
    • From
      1. Enter the date in the format dd-mmm-yy.
      2. Alternatively, click the calendar icon to the right to select the From date.
      3. Enter the time in the format hh:mm.
    • To
      1. Enter the date in the format dd-mmm-yy.
      2. Alternatively, click the calendar icon to the right to select the To date.
      3. Enter the time in the format hh:mm.
    • New File—If selected, AssayNet will prompt you to choose a location and file name to save the new file, instead of overwriting the existing one.
    • File—Select one file template if more than one is configured during lab stat creation in the main AssayNet LIMS application. For more information, see Create and Configure Laboratory Statistics.
  5. In the Statistics list, select the required statistics.

    Note: By default, when you open the Statistics screen in the Excel Add-in, all configured statistics appear selected in the list. You can select one or multiple statistics as needed.

    1. Drag the mouse while holding the left-click button to select multiple statistics.
  6. Click OK to populate the statistics.

    The Progress screen displays.

    An AssayNet warning message appears if the New File option is not checked, indicating that any existing data will be removed.

  7. Click Yes to continue.