Origin 2020b Features

1508

ORG-21336

Reprocess button on Batch Processing summary sheet

Reprocess button on batch processing summary sheet to allow changes to template or Input Data

After doing batch process, use may want to modify template and do the batch process again, or data file has been modified and user wants to batch process again.

In Origin 2020b, a Reprocess button is added on summary book. Use can click it to update the result based on modified template or data.

Open

1509

ORG-21482

Update button on Batch Processing Summary sheet

Update button on batch processing summary sheet to allow changes on input data

User can edit/mask data in Intermediate workbook created by batch process. Then select corresponding row(s) and click Update button on Summary sheet to get recalculated result.

Open

1572

APPS-836

Fit Adsorption Isotherm

Fit Adsorption Isotherm app provides a convenient way to transform your raw data related to adsorption isotherm into a linear dataset with various types of the model provided, and perform linear fitting with the new dataset

• Download Fit Adsorption Isotherm app from the page and install the app.

• This App provides a convenient way to transform your raw data related to adsorption isotherm into a linear dataset with various types of the model provided, and perform linear fitting with the new dataset.

Open

1571

APPS-795

Linear Mixed Effects Model

Linear Mixed Effects Model app fits a linear mixed effects model for data collected in groups

• Download Linear Mixed Effects Model app from the page and install the app.

• Linear Mixed Effects Model App fits a linear mixed effects model for data collected in groups. A mixed effects model consists of fixed effects and random effects. Fixed effects are conventional linear regression. Random effects have linear coefficients that vary with respect to one or more grouping variables.

Open

1569

APPS-810

Linear Regression with Marginal Distribution

Linear Regression with Marginal Distribution app can create a report of linear regression, including a graph with marginal distribution.

• Download Linear Regression with Marginal Distribution app from the page and install the app.

• Linear Regression with Marginal Distribution app can create a report of linear regression, including a graph with marginal distribution.

Open

1570

APPS-841

Standard Curve Analysis

Standard Curve Analysis app fits a standard curve like Concentration vs Absorbance

• Download Standard Curve Analysis app from the page and install the app.

• This app fits a standard curve like Concentration vs Absorbance. Such a curve can be used to determine concentrations in "unknown" samples with their measured absorbance. This method is commonly used to analyze RIA or ELISA Data.

Open

• Support HTML report output.

Open

1517

ORG-21489

Add EC90 and EC10 output for built-in functions and Sigmoidal Gadget

EC80 and EC20 are added as output of Dose Response functions and Sigmoidal Gadget

We only output EC80 and EC20 in built-in Fitting Functions in the past. EC90 and EC10 are added in the following fitting functions and Sigmoidal Gadget.

• Boltzmann

• DoseResp

• Hill

• Hill1

• Logistic

• MichaelisMenten

1518

ORG-19163

Support better way to handle large x in polynomial fit

If X values are large, Mean is subtracted from X before fitting in polynomial fit

Mean is subtracted from X before fitting. Not works if Fix Intercept option is checked.

1519

ORG-12333

System variable for number of iteration of fixed center in fitting

@FCI is added to control the number of iteration in fitting

System variable @FCI is added in Origin 2020b.

When @PFFC is not set as 0, set @FCI to set the the number of iterations of fixed center in fitting.

1506

ORG-21147

Output Gadget results to source data workbook

Support to output Gadget results to source data workbook

In the past, user could only output gadget results to new workbook.

In Origin 2020b, user can specify [<input>]Sheet2 to output results to new sheet Sheet2 in source data book.

Open

1516

ORG-21250

Put more useful information in analysis that output to matrix

If the result of analysis is matrix, source data’s info will be put to result’s matrix.

The source data's info should be putted to  the result matrix object's metadata, such as sheet name, long name, unit, comment and so on

1507

ORG-21274

Support Multiple Dataset Identifier in analysis result

Support identifier from multiple datasets in analysis results

User can specify more than 1 Dataset Identifiers, e.g. In Statistics on Columns, Fitting, Peak Analysis, etc.

Open

1577

APPS-813

Direct Linear Transformation

Direct Linear Transformation app can be used to perform direct linear transformation to do camera calibration and reconstruct 3D coordinates of points by 2D coordinates.

• Download Direct Linear Transformation app from the page and install the app.

• Direct Linear Transformation app can be used to perform direct linear transformation to do camera calibration and reconstruct 3D coordinates of points by 2D coordinates.

Open

1514

ORG-21059

Batch Peak Analysis improvements

Batch Peak Analysis Improvements: Recalculation Support, Sort Output Sheet by Peak Index, Auto Picks All Plots in an Active Graph Window

• Speed improvement of batch peak analysis

• Recalculation support of Batch PA

• All Columns option in Input node

• Sort Output Sheet by Peak Index checkbox to show peaks by peak index. E.g. peak 1 of all spectra show together, then peak2 of all spectra, and so on.

• Further speed up to open Batch Peak Analysis dialog when input has many XY datasets

• Better error message on Messages log so user knows which data failed during batch processing.

• Batch PA picks all plots in page if starting from Graph window

• Put Dataset ID in user-defined parameter row when appending results by Columns

1512

ORG-21218

Customize Peak Filtering Method with script

Peaks can be filtered by script in Peak Analyzer

New Filter Condition box added on Find Peaks page of Peak Analyzer to set some condition of found peaks

E.g. write n<=3 AND hp>=20 so find no more than 3 peaks found peak height must be no less than 20% of maximum height.

Open

1511

ORG-21205

Option to use data in x axis range when doing PA from zoomed in graph window

Peak Analyzer provides option to use data in x axis range when doing PA from zoomed in graph window

1513

ORG-21225

Peak analysis on plot with Y error bars

When there is Y Error bar in plot and open Peak Analyzer, the Y Error will be included in Input data and using weighting method to control peak fitting

When there is Y Error bar in plot and open Peak Analyzer, the Y Error will be included in Input data on first page. Weighting method is still controlled on Fit Peaks page. User can save PA theme with Y error bar and use on new plot with error bar.

1510

ORG-21228

Sort Peaks in Peak Properties sheet

Peaks can be sorted in Peak Properties sheet in Peak Analyzer

Sort worksheet wasn’t supported in Peak Properties sheet before Origin 2020b.

1576

APPS-860

Modified Short-Time Fourier Transform

Modified Short-Time Fourier Transform app can be used to perform short-time Fourier transform with the window size fixed in the frequency domain

• Download Modified Short-Time Fourier Transform app from the page and install the app.

• Modified Short-Time Fourier Transform app can be used to perform short-time Fourier transform with the window size fixed in the frequency domain, that is to use the concept of the short-time Fourier transform, but fix the window size in the frequency domain instead of in the time domain.

Open

1573

APPS-714

Canonical Correlation Analysis

Canonical Correlation Analysis app can be used to measure the correlation between two multidimensional variables.

• Download Canonical Correlation Analysis app from the page and install the app.

• Canonical Correlation Analysis app is used to measure the correlation between two multidimensional variables. It transforms them into two combinations of canonical variates by finding a set of linear coefficients. The coefficients are chosen so that they maximize the correlation between the two combinations of canonical variates. The number of canonical variates equals the smaller dimension of the two source variables.

1574

APPS-822

Nonmetric Multidimensional Scaling

Non-metric multidimensional scaling (nMDS) app can be used to transform multidimensional data into lower dimensional representation. Bray-Curtis matrix is used as dissimilarity matrix

• Download Nonmetric Multidimensional Scaling app from the page and install the app.

• Non-metric multidimensional scaling (nMDS) is used to transform multidimensional data into lower dimensional representation. Bray-Curtis matrix is used as dissimilarity matrix.

1575

APPS-561

SVM Classification

SVM Classification app can be used to perform the support vector machine algorithm for classification.

• Download SVM Classification app from the page and install the app.

• SVM Classification app can be used to perform the support vector machine algorithm for classification.

Open

1523

ORG-21366

ANOVA support ordinary numeric data as Factor

To display the X axis of interaction plot in two way ANOVA to be numeric instead of text, Origin 2020b improved Group designation to support such requirement.

To display the X axis of interaction plot in two way ANOVA to be numeric instead of text, Origin 2020b improved Group designation to support such requirement.

Open

1522

ORG-20798

Easy way to select data for ANOVA

Enable user to select data from worksheet in RAW data mode for ANOVA tools

ANOVA Tools dialog Add a ▶ button next to the Data node for Raw data

Open

1525

ORG-18845

Request for pairwise group comparison in survival analysis

Options to perform Pairwise Comparisons in Kaplan-Merer Estimator tool.

Origin 2020b supports Pairwise Comparisons in survival analysis tools.

Open

1521

ORG-21407

Statsxy X-Function to get statistics by binning

Calculate statistics on Y based on X Binning

Calculate statistics on Y based on X Binning. Multiple quantities can be calculated.

Open

1524

ORG-8509

Support 3D plot in Principal Component Analysis

Support 3D Loading Plot , Score Plot and Biplot for Principal Component Analysis

Origin 2020b add 3D Loading Plot , Score Plot and Biplot for Principal Component Analysis.

Open

1520

ORG-8015

Support Mean Comparison in 3 Nonparametric analysis tools

Support Nonparametirc Mean Comparison in 3 Nonparametric ANOVA tools

Support multiple mean comparison for Kruskal-Wallis ANOVA, Moods Median Test and Friedman ANOVA.

Open

1505

ORG-20943

Database import supports importing images

Database import now supports importing images into images in worksheet cells. Tested with MySQL and SQL Server only.

Database import now supports importing images into images in worksheet cells. Tested with MySQL and SQL Server only.

1504

ORG-20953

Database now supports ODBC-based connection strings.

Can now specify ODBC settings in a connections string.

Can now specify ODBC settings in a connections string. For example:

1503

ORG-19571

Slow database queries can now be aborted.

Slow database queries can now be aborted by clicking Cancel button during import. Includes improved error reporting.

Slow database queries can now be aborted by clicking Cancel button during import. Includes improved error reporting.

1478

ORG-21440

Image slider

When there are multiple images in same matrix sheet, user can drag the image slider to quickly view images.

When there are multiple images in same matrix sheet, user can drag the image slider to quickly view images. User can toggle between image slider or thumbnail with matrix mini toolbar.

Open

1500

ORG-20712

Origin C++ code to import MDF4

Origin C support for MDF4 Connector App for MDF4 files import.

Origin C support for MDF4 Connector App for MDF4 files import.

1493

ORG-21424

Add workbook level properties related to data connector

Add workbook level properties related to data connector on multiple sheets

• wbook.dc.mfiles=0 //if current book support multiple data source 0: not supported, 1: supported. Set it to 1 to have different data source on different sheet

* wbook.dc.nConns= // ready only, number of connected sheets. if it’s bigger than 1, and wbook.dc.mfiles=0, then changing source on one sheet will change the source for all connected sheets

1482

ORG-21338

Connect Multiple Files

Connect to multiple data files at one time. This is only supported for some data types such as CSV, HDF, Excel, Matlab, NetCDF.

Connect to multiple data files at one time. This is only supported for some data types such as CSV, HDF, Excel, Matlab, NetCDF.

Open

1484

ORG-21759

Data Connector related toolbar buttons

3 new buttons for Import toolbar： Import all Connected Data, Connect to data from web and Connect Multiple Files

3 buttons added at the end of Import toolbar

Open

• Import all connected books in project – it will reimport data in all books with data connection

• Connect to data from web…

• Connect Multiple Files…

1488

ORG-21540

Data Connector to support child matrix book

Certain data connectors (NetCDF and HDF5) supports importing matrix data into matrixbooks embedded in workbooks.

Certain data connectors (NetCDF and HDF5) supports importing matrix data into matrixbooks embedded in workbooks.

1485

ORG-21283

Data Navigator

Data Navigator shows on the left side of workbook/matrix book for applicable data connectors, e.g. Excel, Origin Project, Matlab, NetCDF, etc.

Data Navigator shows on the left side of workbook/matrix book for applicable data connectors, e.g. Excel, Origin Project, Matlab, NetCDF, etc.

User click right click sheet(s), datasets there to import into new sheet, same sheet, remove, etc.

Open

1487

ORG-19709

Drag and drop data with Data connector Improvements

Importing data, data connector will be used by default. When dragging and drop a file into an analysis template with data import settings saved, it will use the old import method.

• For data type that can be imported by both data connector and old import method, data connector will be used by default.

• When dragging and drop a file into an analysis template with data import settings saved, it will use the old import method.

You can alter this default behavior with a new 2020b system variable, @DDC, which stands for Disable DC (for drag and drop)

1489

ORG-21494

Support worksheet comments via Origin Connector

Origin DC can now retrieve worksheet comments when using a query.

Origin DC can now retrieve worksheet comments when using a query. for example:

Select Column From Project Where Sheet_Comments like "Sheet1" and Book_Comments like "Book1"

1567

APPS-875

BioLogic Connector

BioLogic Connector app can connect the Origin project to BioLogic MPR (*.mpr) files.

• Download BioLogic Connector app from the page and install the app.

• BioLogic Connector app can connect the Origin project to BioLogic MPR (*.mpr) files.

1566

APPS-838

MetroPro Connector

MetroPro Connector app can connect the Origin project to MetroPro binary data file (*.dat).

• Download MetroPro Connector app from the page and install the app.

• MetroPro Connector app can connect the Origin project to MetroPro binary data file (*.dat).

1565

APPS-845

 Minitab Connector

Minitab Connector app can connect the Origin project to Minitab 19 projects (.mpx) and worksheets (.mwx).

• Download Minitab Connector app from the page and install the app.

• Minitab Connector app can connect the Origin project to Minitab 19 projects (.mpx) and worksheets (.mwx).

1568

APPS-916

MDF4 Connector

MDF4 Connector app can connect the Origin project to MDF4 (*.mf4) files.

• Download MDF4 Connector app from the page and install the app.

• MDF4 Connector app can connect the Origin project to MDF4 (*.mf4) files.

0

APPS-915

NetCDF Connector

NetCDF Connector app can connect the Origin project to NetCDF (*.nc, *.cdf) files.

• Download NetCDF Connector app from the page and install the app.

• NetCDF Connector app can connect the Origin project to NetCDF (*.nc, *.cdf) files.

1486

ORG-21284

CSV Data Connector supports wildcard in defining Data Block Marker.

User keywords to match Start and End for Data Block Marker in CSV data connector. Now it supports wildcard (*, ?).

User keywords to match Start and End for Data Block Marker in CSV data connector. Now it supports wildcard (*, ?).

1494

ORG-21684

HTML DC Improvements

Added new Options item to HTML Connector sub menu, and system variable @DCW to initialize the options in Options dialog.

Added new Options item to HTML Connector sub menu, and system variable @DCW to initialize the options in Options dialog.

@DCW = 0 (default), Cache result of HTTP request and use specified in raw HTML source.

@DCW = 1, Do not cache result of HTTP request.

@DCW = 2, Run javascripts associated with HTML. May provide altered table content.

@DCW = 3, Both above.

1483

ORG-21384

Import multi-sheets with Excel Connector

In Origin 2020b, after connect to an Excel file, all sheets are listed in the Data Navigator on the left of workbook window.

Before Origin 2020b, user could only connect to one sheet of Excel file at a time. In Origin 2020b, after connect to an Excel file, all sheets are listed in the Data Navigator on the left of workbook window. User can select sheet(s) there to import.

1501

ORG-20719

Make Database Consistent with Data Connector

Database Connector supports Auto Import and Graph Import Icon.

• Added Auto Import for Database Connector: Added Auto Import menu item to Database Connector submenu for auto import when open the project with Database Connector.

• Added Graph Import Icon for Database Connector: When make a plot using data from database connector, save the project and reopen, will show an import icon on the Graph page

1496

ORG-21411

MATLAB and HDF Data Connector Improvements

For MATLAB and HDF connector that import into matrix, added system variable @MSS=10.

For MATLAB and HDF connector that import into matrix, added system variable @MSS=10.
If number of matrix > @MSS, then show thumbnail area using slider.

Open

1491

ORG-21176

MATLAB Connector transpose imports 1*N mat data

MATLAB 1 dim matrices shall be transposed in order to fit into a worksheet column.

MATLAB 1 dim matrices shall be transposed in order to fit into a worksheet column.

1492

ORG-20224

NetCDF Connector available from menu

NetCDF Connector app supports importing netCDF 4 dimensions one slice as 3D data into Matrixpage.

Added NetCDF Connector app for netCDF file import, which can be accessed from menu Data: Connect to File: NetCDF

NetCDF Connector supports importing netCDF 4 dimensions one slice as 3D data into Matrixpage, for example:

When a netCDF file have a 4D variable e, give it a selected path: NetCDF/e[x][y][z][1],NetCDF/e[z][1][y][x]etc

1497

ORG-19299

New support for Web Connector

Web Connector supports HTTP Post Requests, Self-signed SSL Certificates and improve auto detect for JSON files

•  Support HTTP Post Requests.

• Improve auto detect for JSON files.

• Support Self-signed SSL Certificates.

1499

ORG-20993

Pipe bar delimited ASCII

CSV Connector supports import pipe bar delimited ASCII file.

CSV Connector supports import pipe bar delimited ASCII file.

1498

ORG-20789

Support Import newer IMC Famos File Format

impFamos supports importing the new imc3 format.

impFamos supports importing the new imc3 format.

1480

ORG-234

Apply same color palette to all matrix objects if image slider is on

When image slider is on, user can use the color palette toolbar button to apply same color palette to all matrix objects in same sheet.

When image slider is on, user can use the color palette toolbar button to apply same color palette to all matrix objects in same sheet.

1404

ORG-21258

Change data type, display, digits, etc. of multiple matrix objects in same matrix sheet together

Apply to matrices to the right checkbox is added to apply same format to all matrix objects in current matrix sheet.

Apply to matrices to the right checkbox is added to apply same format to all matrix objects in current matrix sheet.

Open

1407

ORG-21251

Edit Matrix/Virtual Matrix Z Title in OM

User can right click the plotted matrix data or virtual matrix data in Object Manager to rename Matrix Long Name or Z title of virtual matrix.

User can right click the plotted matrix data or virtual matrix data in Object Manager to rename Matrix Long Name or Z title of virtual matrix.

1481

ORG-20944

More shrink methods in Matrix Shrink dialog

In Origin 2020b, more shrinking methods are provided such as sum, max, min, sd, keep first cell, keep last cell.

Before Origin 2020b, user could only reduce the number of rows and columns in matrix by averaging. In Origin 2020b, more shrinking methods are provided such as sum, max, min, sd, keep first cell, keep last cell.

Open