4.6.1 Creating and Using Analysis Templates


Routine tasks can be simplified by creating an Analysis Template. Such templates can contain multiple analysis results and also custom report sheets. A new instance of the template can then be opened at any time and source data can be changed to update all analysis results and custom reports.

Minimum Origin Version Required: Origin 2015 SR0

What you will learn

  • How to create an analysis template (OGW)
  • How to re-use an analysis template with new data


Importing Data

  1. Start with a new workbook.
  2. Click the Import Single ASCII button Button Import Single ASCII.png on the Standard toolbar to open the ASCII dialog box. Browse to the <Origin EXE folder>\Samples\Curve Fitting\ folder and select the file Sensor01.dat. Make sure that Show Options Dialog is selected and click the Open button. This will open a dialog for specifying import settings.
  3. In the impASC dialog, expand the Rename Sheets and Books node and clear the Rename Sheet with (Partial) Filename box.
  4. Click OK to import the file to Sheet1.
  5. Double-click on the worksheet tab and rename the sheet as Data.

Performing Analysis

  1. Highlight column B and use the Analysis: Fitting: Linear Fit menu item to open the Linear Fit dialog box.
  2. Set Recalculate to Auto, accept other default settings and click OK to perform a linear fit. A hierarchical report sheet will be added to the book, with result tables and embedded graphs.
  3. Answer Yes to the attention message to go to the FitLinear1 report sheet.
  4. Double-click to open the graph under the Fitted Curves Plot tree node. This graph contains the data plot and fitted curve.
  5. Click the menu item View:Show:Frame to show the graph frame.
  6. Double click on the data plot to open the Plot Details dialog box. In the left panel, select FitLine to open the Page Properties dialog box. Go to the Legends/Titles tab and clear the Indicate Active Dataset check box, then press OK to close the dialog.
  7. Select Format: Axes: Y Axis... in the main menu to open the Axis dialog box. Verify that the Type under Major Ticks node is set to By Increment and set the Value to 5. Use Shift/Ctrl key to select both Horizontal and Vertical icons on the left panel and change the Rescale mode to Auto for both X and Y axes. Click Apply to apply settings and choose OK to close the dialog.
  8. Manually move the legend object to a suitable position so all text is visible then delete the result table box on the graph. The final graph should look like the image below:
    Tutorial Analysis Template 01.png
  9. Put this graph back into the result sheet by clicking on the restore button Button Restore Window.png at the top right of the title bar.

Saving an Analysis Template

  1. Activate the workbook and select File:Save Workbook as Analysis Template.
  2. Browse to the desired location and enter a file name, for example MySensorData, and press the Save button.
  3. Now the file MySensorData.OGWU is saved as an Analysis Template. This template can be re-used in the future to carry out similar analyses.

Re-using the Analysis Template

  1. Start a new project, then select the menu item File: Recent Books. From the fly-out menu options, select the Analysis Template MySensorData.ogwu that was saved earlier.
  2. Make the Data worksheet active, and click the Import Single ASCII button Button Import Single ASCII.png. Browse to the file Sensor02.dat under the <Origin EXE Folder>\Samples\Curve Fitting\ path and import the file.
    Note:You can also locate the Sensor02.dat file in your local drive, drag and drop it into this Data sheet to import.
  3. Since the Recalculate mode was set to Auto, the linear analysis will be performed automatically for the new data.
  4. Go to the FitLinear1 worksheet and under the Fitted Curves Plot node, double-click to open the graph and view the updated results.

The Analysis Template can be used in the batch processing of similar data, see this tutorial for details.