12.2.1 Specifying Your Input Data


Origin's analysis tools permit you to specify your input data in several ways -- by pre-selecting data in your worksheet; by typing in a data range; by selecting from a list; or using the tool's interactive range selection control. Where appropriate, data range selection is also flexible, in that you can select data from one or more worksheet columns, parts of worksheet columns or even non-contiguous portions of worksheet columns.

Most users will find it easiest to pre-select input data before opening an analysis tool. In doing so, you will initialize the appropriate data input fields, saving yourself the bother of having to do this once the tool is opened. For example, you can highlight a worksheet Y column or some rows in a Y column, and then open the Linear Fit tool. The input data branch of the tool will be initialized with the pre-selected data and you can then go on to specify other fitting options, click the OK button, and perform your linear fit. If multiple Y columns were selected, each column will be listed under Input Data as a separate range (which you can accept or adjust as needed). Note, that not all analysis tools will work with multiple range selections. For example, the smooth tool (Analysis: Signal Processing: Smoothing) works with only one XY range at a time.

Auto initialization of the Input Data branch of the analysis tools also applies to graphed data. If you open an analysis tool when a graph window is the active window, the active curve in the active layer is pre-selected for analysis. You can also select just a portion of a curve or multiple curves (where appropriate) before opening an analysis tool. This does not prevent you from adding to or removing curves from the analysis after the dialog box has been opened. If no curve is active when an analysis tool is opened, the Input Data branch will be empty. For information on specifying data ranges in the graph, see Selecting Data in the Graph.

The remainder of this topic discusses how to specify a data range in the Input Data branch of Origin's analysis dialog boxes.

Selecting a column of data from a list

The topmost level of the Input Data branch shows all of the input datasets. You can click the + icon to expand this branch and see the Input Data ranges:

Specifying Your Input Data-1.png

If you click the right-pointing triangle button to the right of the range boxes, you will see (a) a list of columns of data from the active window and (b) menu commands which may be used to specify or modify the input range

Specifying Your Input Data-2.png

The particular list you see depends upon the active window type when the dialog was launched and which button was clicked. You can use this list control to do the following:

To do this... Do the following:

Change input data

Select another data column from the list to replace the currently selected column.

Add data ranges

Selecting the Add or All Columns command from the list will add a new range node(s) to the existing list of ranges. This allows you to add data without closing the tool.

Reset input

Clicking the Reset command on the list will clear all Input Data fields so you can re-enter input data ranges.

Restrict input range

Each Range node has a Rows box that, when checked, allows you to specify a subset of data rows to analyze (From and To).

Select data in graphs

If the tool is opened when a graph window is active, a different data list displays. In this case the Input Data branch picks up the active curve, but you can add or substitute other curves from the active layer or page.

You can also choose All Plots, or use Reset to clear all ranges. The Select from Graph option allows you to go out to the graph and then make either single or multiple curve selections using the Data Selector tool.

Using the interactive range selection control

Next to each data range field, there is an Interactive Range Selector button Button Select Data Interactive.png. When you click this button, the dialog box "rolls up." In roll-up mode, you can go outside the dialog box and select a range of data (either in your worksheet or your graph, depending upon which was active when the tool was opened).

When you've completed your range selection, you can click the button on the right side of the rolled up dialog box, restoring the analysis tool and registering the selected data range in the associated Input Data node.

Specifying Your Input Data-3.png

For more information on data range selection, see the following topics:

Entering a data range string under the Input Data branch

If you are familiar with the LabTalk data range notation syntax, you can also specify input ranges by typing directly in the edit boxes under Input Data branch. For example, you could type...

[Book1]Sheet1!Col(B)

... to specify a Y-range.

Or, you can use the "Col" (column) notation when a workbook is active:

(Col(1), Col(2))

For information on the LabTalk data range notation syntax, please see the LabTalk Programming section of the Programming Help file (Help: Programming).

Selecting Objects with Different Browsers

In different analysis dialogs, you can bring up different object browsers from data input nodes. These browsers list valid analysis objects in the specified path, such as in current workbook, current folder, etc. You can select, add, replace, or remove analysis data from these browsers.

Column Browser

In most analysis dialog, you can click the button to the right of the range text boxes, and select Select Columns menu item, or click the Specifying Your Input Data-4.png button in e.g. Nonlinear Curve Fit dialog, to open Column Browser . The Dataset Browser,Column Browser or Range Browser dialog are designed similarly.

You can use this dialog to do the following:

Desired Result: Procedure:

Browse columns in different location

Select the proper location from List Columns drop-down list.

Add multiple columns as one block

Hold Ctrl or Shift key to select multiple columns from upper panel and click Add as One Block button.

Add column

Select column(s) from upper panel and click Add button.

Remove column

Select column(s) from lower panel and click Remove button.

Sort columns

Click the column header on upper panel, like Sheet, Index, and LName, etc to sort datasets. You can do nested sort by holding down SHIFT key before clicking on secondary column headers..

Exclude column(s) in browser

When there are too many datasets in the upper browser panel, select the datasets you don't want to see and click the Exclude button.

Select Data from Graphs Only

When there are both datasets from worksheets and from graphs in the upper browser panel, you can check Datasets from Graphs Only box to hide datasets from worksheets and show datasets from graphs only.

Image Browser

In the image processing tools, you can click the right-pointing triangle button to the right of the range box and select Image Browser menu item to open Image Browser.

You can use this dialog to do the following:

Desired Result: Procedure:

Browse image in different location

Select the proper location from List Images drop-down list.

Remove Image

Select image from lower panel and click Remove button.

Replace Image

Select an image upper and lower panel respectively, and click Replace button.

Sort Images

Click the column titles on upper panel, like Sheet, Index, and LName, etc to sort datasets.

Exclude images in browser

When there are too many images in the upper browser panel, select the images you don't want to see and click Exclude button.

Graph Browser

In the Merge Graph or Export Graph dialogs, you can click the button to open Graph Browser dialog, when using the Specified input or output mode.

You can use this dialog to do the following:

Desired Result: Procedure:

Add or remove graphs

Select graphs on left or right panel and use the Button Expand Panel Right.png or Button Expand Panel Left.png button to add or remove graphs.

Report Tree Browser:

The fit comparison tools (fitcmpdata & fitcmpmodel) use fit results to compare two fits. By clicking the button to bring up the Report Tree Browser, you can specify the fit report worksheets.

You can use this dialog to do the following:

Desired Result: Procedure:

Specify report worksheet

Double-click to select report worksheet.

Sort report worksheets

Click the column titles, such as Worksheet or Class, to sort worksheets.

Sheet Browser

In the As Multipage PDF Files or As Image File dialogs, you can click the button to open Sheet Browser dialog, when using the Specified mode.
Also, you can New a Layout, and select Add Worksheet from the context menu to open the Sheet Browser dialog.

You can use this dialog to do the following:

Desired Result: Procedure:

Add a worksheet

Select the worksheet on right panel and click OK button.

Add a worksheet by the shortcut

Select the checkbox of Include Shortcut Page, then the shortcut of the workbooks will showed in the left panel. You can choose a worksheet to add.
(How to creating a shortcut).