Defining a FlexLogger Project in a Microsoft Excel Spreadsheet

Use a Microsoft Excel spreadsheet (.xlsx) to define and configure a FlexLogger project so you can import it into FlexLogger.

Complete the following steps to define your FlexLogger project in an Excel spreadsheet.

  1. Create an Excel spreadsheet with the following worksheets:
    • Required:
      • Channel Mapping
    • Optional:
      • Strain-Bridge
      • Temperature-Thermocouple
      • Voltage-Voltage
      • Formulas
      • Statistics
      • Variables
    You can find a FlexLogger Importer Spreadsheet template and a reference example spreadsheet in the Importing Structural Test Channel Information from MS Excel into FlexLogger document.
  2. Set up the Strain-Bridge, Temperature-Thermocouple, and Voltage-Voltage worksheets with the appropriate columns. Refer to Strain-Bridge Worksheet, Temperature-Thermocouple Worksheet, and Voltage-Voltage Worksheet to learn about what to name the columns, which columns are required, and what values are allowed for each column.
  3. Set up the Channel Mapping worksheet. Refer to Channel Mapping Worksheet to learn about what to name the columns, which columns are required, and what values are allowed for each column.
  4. (Optional) If needed, set up the Formulas, Statistics, and Variables worksheets with the appropriate columns. Refer to Formulas Worksheet, Statistics Worksheet, and Variables Worksheet to learn about what to name the columns, which columns are required, and what values are allowed for each column.
    Tip The FlexLogger CLI can take several minutes to run on a large spreadsheet.

    NI recommends that you only configure a few channels in each of the worksheets first, then run the importer to ensure that they are properly configured, and only then complete the worksheet with all the required channels.

  5. Save the file in .xlsx format.