4.6.1 Creating and Using Analysis Templates

AnalysisTemplate-Create-Use

Save Workbook as an OGWU vs Analysis Template Creating Batch Reports using Origin Analysis Template and Microsoft Word

How to Trigger a Worksheet Data Filter during Batch Processing Use the Distributed Batch Processing App for Faster Batch Processing Results Creating HTML Reports and Documents in Origin 2019b Batch Processing when Dragging and Dropping Data into Origin

Summary

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 (OGWU)
• How to re-use an analysis template with new data

Steps

Importing Data

1. Start with a new workbook, activate the first empty worksheet. Select Help: Open Folder: Sample Folder... to open the "Samples" folder. In this folder, open the Curve Fitting subfolder and find the file Sensor01.dat. Drag-and-drop this file into the empty worksheet to import it.
2. 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. Under the Fitted Curves Plot tree node, double-click on the graph of plotted data plus fit curve to open the graph in an editable popup window.
5. Click the menu item View:Show:Frame to show the graph frame.
6. Click the Rescale button
7. Select Format: Axes: X Axis... to open the Axis dialog box. In Scale tab, make sure Type is set to By Increment under Major Ticks node and set the Value to 2. Change the Rescale mode to Auto.
8. In the left panel, click the Vertical icon. Set Rescale to Auto and Major Ticks to Type = By Increment and set Value = 5. Click OK to save the setting and close the dialog.
9. Manually move the legend object and the result table to suitable positions on the graph. At this point, you can also do such things as customize the scatter symbol. The final graph should look something like the image below:

   

10. Put this graph back into the result sheet by clicking on the restore button 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 click the OK 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, select Help: Open Folder: Sample Folder... to open the "Samples" folder. In this folder, open the Curve Fitting subfolder and find the file Sensor02.dat. Drag-and-drop this file into the worksheet "Data" to import it.
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.