OriginLab Corporation - Scientific Graphing and Data Analysis Software - 2D graphs, 3D graphs, Contour Plots, Statistical Charts, Data Exploration, Statistics, Curve Fitting, Signal Processing, and Peak Analysis

Batch Processing

Contents

Image:UserGuide_Batch_Processing_001.png

The Batch Processing tool allows you to perform repeat analysis on multiple datasets using an existing Analysis Template. Multiple data files from disk can be processed, or the tool can loop over all (or selected) data, already existing in your project.

Image:UserGuide_Batch_Processing_001.png

The Batch Processing tool allows you to perform repeat analysis on multiple datasets using an existing Analysis Template. You can process multiple data files from disk, or loop over data already in your project.

To create an Analysis Template, perform an operation (e.g., curve fitting) and set Recalculate to Auto or Manual. You can optionally add a Result Sheet, which contains paste-linked results (e.g., the file name, or a subset of values from the parameter table generated by a curve fitting) from the analysis operation. You can then use the Batch Processing tool to create a Summary Report compiling Result Sheet data from multiple files or datasets.

When the tool is used to process multiple disk files, the import settings (e.g., custom ASCII settings, or filter settings from the Import Wizard) can be saved as part of the Analysis Template. Variables extracted while importing can be paste-linked into the Result Sheet, and this information will then appear in the Summary report create by the Batch Processing tool.

The Analysis Template can include:

  1. The Raw Data worksheet.
  2. The Analysis Report worksheet. These are report sheets generated by analysis procedures (e.g., nonlinear fitting).
  3. An optional Result Worksheet containing analysis results cell-linked from the analysis report, and import variables, such as the file name or any parameters extracted from the file header.

The Batch Processing Dialog Box

To open, click File, and then click Batch Processing.

Batch Processing Mode Specifies how to perform batch processing.
  • Repeatedly Import into Active Window
    Repeatedly import data into the active workbook window, assuming the workbook has already been set up as an Analysis Template.
  • Load Analysis Template
    Load a specific Analysis Template workbook (.OGW) from disk.
Analysis Template Available when Batch Processing Mode is set to Load Analysis Template. Use this to specify the analysis template for the batch processing.
Data Source Data source can be
  • Import From Files
    Import data from files.
  • Use Existing XY Datasets
    Perform batch processing on XY Range Data in the current project.
Use Import Setting in Workbook Specify whether to use the last data import settings. This is available only when Data Source is Import From Files.
File List Available when Import From Files is used. Select data files for batch processing.
Input Available when Data Source is set to Use Existing Datasets. Specify the XY Range for analysis from anywhere in the project, such as the current sheet, current book, or any selection performed with the Dataset Browser tool. (To access the Dataset Browser tool, click the arrow to the right of Input , and then click Select Columns... )
Dataset Identifier Specify whether to add a column with the long name "Dataset" to the Result Worksheet for identifying each analysis dataset. If None, this column will not be added. Otherwise, when Data Source is Use Existing XY Datasets, Dataset Identifier can be Range, Book Name, Sheet Name, Long name, Units or Comments. When Data Source is Import From Files, only File Name, Long name, Units and Comments are available.
Data Sheet Specify the name of the Raw Data sheet in the Analysis Template into which the data should be imported. Note that you can save import settings, such as custom ASCII import settings or Import Wizard filters, to the data sheet in your Analysis Template. See saving ASCII settings and saving import filter settings for more details.
Result Sheet Specify the optional Result Worksheet in the Analysis Template which contains the information you want to summarize for each dataset or file processed by the tool.
Output Sheet Specify the output worksheet name which will contain the summary information for each file or dataset specified in the Result Sheet.
Delete Intermediate Workbbok Specify whether to delete the intermediate analysis outputs after the process.
Options Including:
  • Starting Row of Output Sheet
    Specify the beginning row in the Output sheet to append results.
  • Clear Output Sheet on Start
    Clear the output sheet when starting batch processing. Clear this check box if you are repeating the analysis on a new set of files or datasets and you want the summary information appended to existing summary information from previous batch analysis.
  • Append Label Rows
    Append the results by Row or Column
Script Including:
  • Script after Each Process
    LabTalk script to run after each file or dataset has been processed.
  • Script at the End
    LabTalk script to run at the end of the process.

Example

Example 1

In this example, we will import three .dat files and perform a nonlinear curve fitting.

  1. On the main menu, click File, and then click Batch Processing... to open the Batch Processing dialog.
  2. Make sure Load Analysis Template is selected. Click the Image:BatchBrowseButton.png button to the right of Analysis Template. Navigate to the Origin installation folder, and then \ Samples\ Curve Fitting to select Linear Regression.ogw.
  3. Make sure Data Source is set to Import From Files. Click the Image:BatchBrowseButton.png button to the right of File List, and then navigate to \ Samples\ Curve Fitting to add Sensor01.dat, Sensor02.dat, and Sensor03.dat. Set the remaining dialog values as in the image below:
    Image:BatchProcessingDialgo.png
  4. Click OK. In the Select Filter dialog, select a filter for Sensor1.dat from the list. This filter will be applied to all files.
    Image:BatchProcessing_filter.png
  5. Click OK to perform batch processing.
    Image:BatchProcessingResults.png

Example 2

This Tutorial illustrates how to analyze multiple data files by batch processing.