Origin 2020 Features

0

APPS-199

2D Peak Analysis

Perform 2d peak fitting and integration for each peak.

Download 2D Peak Analysis app from the page and install the app.

This app can be used to perform 2d peak fitting, and integrate each peak fitted data.
Features include:

• Perform surface/matrix fitting for 2d peak.

• Do integration for each peak's fitted data.

• Show preview by contour plot or colormap surface plot.

• Change each peak's center and width by typing value or resizing peak marker.

• ROI support.

• Multiple peak fit support.

• Baseline support for integration.
  

  
  
  

0

APPS-704

Neural Network Fitting

Fit data with neural network.

Download Neural Network Fitting app from the page and install the app.

This app can be used to fit data with neural network. It trains a neural network to map between a set of inputs and output.

Features include:

• Custom number of layers and number of  hidden neurons in each layer

• Choose algorithm to calculate the neural network weights

• Perform K-fold cross validation

• Predict response of independent variables with trained neural network.

0

ORG-20105

Batch Processing support Analysis Templates that having Data Connector

Batch Processing support Analysis Templates that having Data Connector

Origin support importing data by data connector since Origin2019b, therefore,batch processing also improve to support analysis template which source data is imported by data connector(such as CSV connector,Excel Connector,MATLAB Connector,etc).

note:currently Data Connector will be supported only when Data Source is Import From Files.

0

ORG-18513

Combine all Word files into one file after batch processing

Add an option in batch processing dialog to combine all Word files into one file after batch processing

0

ORG-20122

Support the "Open Books" button in summary report when appending results by column

Add Open Books button in summary report book after batch processing so that user can select the row and open corresponding intermediate workbook

Append by column will also support the "Open Books" button in summary report book like appending result by row when do batch processing, it will be convenient for user to check the intermediate workbook.

0

ORG-20322

Allow double clicking Axis to open Axis dialog in Peak Analysis Preview

In Peak Analysis preview with Peak Analyzer, axis dialog can be opened to adjust axis scale

This feature was turned off in some recent versions but user complains very hard to adjust axis scale. So we bring it back in Origin 2020. 

0

ORG-20377

Change Parameters... context menu when right clicking anywhere in hierarchical result sheet

Change Parameters... context menu is added no matter where you click in the sheet.

In the past, user had to scroll up to the top of the hierarchical sheet and click the green lock to bring up the Change Parameters... context menu. In Origin 2020, Change Parameters... context menu is added no matter where you click in the sheet.

0

ORG-20566

Copy All Open Tables in hierarchical result sheet

Copy All Open Tables context menu is added when you right click the title of hierarchical result sheet

0

ORG-8984

Data filter in analysis template will automatically trigger after importing data

Data filter will be auto triggered after importing data in analysis template

In Origin2020, data filter will be auto triggered after importing data, it will be very convenient when do batch analysis on analysis template which having data filter in source data sheet. you do not need add script to handle data filter anymore.

Note:This support in batch process dialog only when Data Source is Import From Files .

0

ORG-20119

Simple Curve Math supports custom formula

Simple Curve Math supports custom formula, which enable flexible operation between two curves.

In the past, user could only do basic calculation between two curves by choosing +,-, , / and ^ in Operator dropdown list. Custom is added in Origin 2020 to define custom formula by using y1 as input data and y2 as reference data, e.g. y1*5-y2^2.

Custom formula is also added in Simple Column Math tool.

0

ORG-19858

Speed improvements on recalculation

When there are many operations involves report sheet, recalculation if much more faster

Improvement was made on SetReportTree() method, which is used to generate a results worksheet. So when there are many operations involves report sheet, you will get at least 10% time saving on calculation.

Besides, if there are many column formula operations, recalculation was done one by one in previous version and the time maybe a little long. But now in Origin 2020, you will see that all recalculation can be done in the same time and the calculation is very fast.

0

ORG-20684

Better level crossing result for large duration points

Improve level crossing tool to support large duration points

0

ORG-20067

Improvements in Normalization tool

When normalizing multiple datasets, can combine them as a single dataset to normalize.

When normalizing multiple datasets, can combine them as a single dataset to normalize.

0

ORG-20274

Context menu on analysis lock to include hidden rows in analysis

Provide options to ignore hidden rows or not on context menu of analysis lock

By default when there is filter in column and it's input for an analysis, hidden rows will be ignored. But user can click the analysis lock and choose Ignore Hidden Rows: No to include hidden rows in analysis.

Auto means follow the setting in Worksheet Properties → Miscellaneous tab. 

0

ORG-20356

Speed improvements on Quick Peak tool

Speed of Quick Peak Gadget is improved for large data

For large data, it was very slow to use Quick Peak gadget in previous versions.

• Add gadget speed is more than 150 times faster than Origin 2019b – It may take a few minutes to open the gadget in Origin 2019b while it only takes a few seconds in Origin 2020.

• Output result speed is 80 times faster – It may take a few minutes to output result sheet in a region of interest while it only takes a few seconds in Origin 2020.

Note:

• System variable @PPBLN is added, default value is 1000. If number of input data points over this value, baseline data will not be output in the result Notes.

• System variable @PPBMA is added, default value is 100. If number of find peaks over this value, no base markers and integrated areas shown on the ROI.

• If choose the "New Output for Entire Curve" item, the performance is not improved yet.

Besides, pkFind tool is also improved, 7 times faster on calculation.

0

ORG-4366

Allow ANOVA 'Number of Levels' to be > 10

Number of Levels dropbox for Raw data mode of ANOVA tools is increased to 25

In Origin 2020, Allow ANOVA 'Number of Levels' to 25.

0

ORG-20758

Improve box plot in One-Way ANOVA

Box charts generated in ANOVA tools are plotted with grouped box chart

1. For the box charts of One Way ANOVA and Statistic on columns, which has only one group column, Origin 2020 does not set subgroup.

2. One Way ANOVA's box charts and Statistic on columns' box charts default templates follow Grouped Box Charts' setting in Plot Details dialog:
   1. Check Outliers checkbox and Box width=80 in Box tab.
   2. Uncheck 99% and 1%, Max, Min checkboxes in Percentile tab
   3. Border Color=Q13 and width=1.5, Fill Color: Auto in Pattern tab
   4. Caps Length=50 in Lines tab

3. Rename Connect by Subgroup to Connect within Subgroup in Plot Details dialog Connect Lines tab for Grouped Box Charts

0

ORG-20506

Kernel Density Calculation: New (fast) algorithm

Faster  2D Kernel  Density plotting for large datasets

For large datasets to plot 2D Kernel  Density, earlier Origin versions take several hours or more. 

Origin 2020 introduces new Density Method: Binned Approximate Estimation and adds an new option: Interpolate Density Points to improve speed greatly, which takes only several seconds.

Open

A New Labtalk function is supported as below:

ks2d(vx,vy[, int bandwidth=0, int grid=151, int interp=1, int density=1])

0

ORG-20883

Set Cluster Membership column as Categorical and Ascending type

K-Means Cluster Analysis and Hierarchical Cluster Analysis, Cluster Membership column keeps  the order of the original data and is set as Categorical and Ascending type.

In Origin 2019b, K-Means Cluster Analysis and Hierarchical Cluster Analysis, Cluster Membership column was already sorted and without link to the order of the original data.

In Origin 2020, K-Means Cluster Analysis and Hierarchical Cluster Analysis, Cluster Membership column keeps  the order of the original data and is set as Categorical and Ascending type.

0

ORG-20734

Speed improvements on Means Comparison in ANOVA tool

Improved the calculating speed of Means Comparison, and it will be 30% faster than Origin 2019b.

Improved the calculating speed of Means Comparison, and it will be 30% faster than Origin 2019b.

Besides, if choose not output the Means Comparison result, previous version will still do the calculation in background and waste time. Now this is fixed in Origin 2020, and will be 83 times faster than Origin 2019b.

0

APPS-756

Video Data Explorer

Explore video and related measurement data.

Download Video Data Explorer app from the page and install the app.

This app can be used to explore a video and related measurement data.
Features include:

• Play a video.

• Import measurement data related to the video and set sampling rate.

• Display 2d data plot of the measurement data.

• Synchronize the video and data by adjusting for difference in time.

• Explore the video and plotted data.

• Add events with user defined names and build a table of events with time stamps and data values.

• Save video and data at any particular time step as an image.

0

ORG-19827

Multi-threaded ASCII import

Add two system variables  for Multi-threaded ASCII import. 

The following system variables are added:

@IAMT=<auto> /// number of additional threads to use when import, will be auto detected by logical processors. Set to 0 to disable multi-threading. @IAS=10 /// least file size (in Megabytes) to enable multi-threading.

0

ORG-18853

Enhanced Database Import

Database Import images stored inside the database as pictures in worksheet cells.

• Directly import images stored inside the database as pictures in worksheet cells

• Protect imported data from editing, to ensure data integrity, 

• @IPDB(Database Import) and @IPDC(Data Connector) to control the protection mode for imported range.

  • 0 - no protection

  • 1 - protected, except reorder

  • 2 - protected

• @DBSV to control whether to show Views in table list on SQL Editor dialog or not. Default is 0 to not show.

• Support Exclude Imported Data when saving as OPJU/OGWU for Database Import.

• Improved Ease of Use and performance

In previous versions, import database by ODBC is slower than ADO, and cannot import large dataset. Now this has been improved in Origin 2020.

Setting @ODBCA = 0 (Default), then you should be able to import large dataset now.

Also, the performance of ODBC should be faster than ADO method now.

Also, when importing using Microsoft OLE DB Provider for ODBC for database connection, Origin will use ODBC by default now. It used to use ADO by default even for ODBC.

0

ORG-20796

Option to encrypt or leave database credentials in clear text

In SQL Editor dialog, supply option to encrypt or leave database credentials in clear text

When SQL Editor dialog launches, the user is prompted to encrypt their credentials. If the user choose not to, the password is displayed in clear text in the Edit Connection String... dialog. However, it still appears as *** other places in Origin. If credentials are encrypted the password appears as *** everywhere.

Note: This is has late breaking issues which will be addressed.

0

ORG-20107

Origin Connector to allow basic SQL selection and Improve Origin Internal Query SQL Support

Following object notations are supported in internal query SQL. New worksheet command to output SQL query result to workbook.

1. Following object notations are supported in internal query SQL

   • _Type, _SName, _LName, _DatasetType, _Comments, _Visible, Column_Y, Column_Z, Column_P1, Column_D1, Column_[Name], , Sheet_SName, Book_SName, Book_LName

2. New worksheet command to output SQL query result to workbook.

   • worksheet -qn: Output to new book

   • worksheet -qa: Output to active book, this will first delete all existing columns

   • Example:

     • worksheet -qn Select Column From Project Where Book_LName like "*simple*" and Column_LName like "YCO*";

     • worksheet -qn Select Column from Project where (_Type = "X" and _Visible = True);

3. A Query button is added in Origin Connector. Open it to enter query.

0

ORG-20870

Data Connector Exclude saving only for larger files

Added system variables @DNS, @FSE, @FSEW and @FSEB to control if check Exclude Imported When Saving menu item for Data Connector and Database.Data Connector 

Added system variables @DNS, @FSE, @FSEW and @FSEB to control if check Exclude Imported When Saving menu item for Data Connector and Database.

1. @DNS ///exclude imported data or not when saving

   • 0 = (defualt) file check @FSE and web check @FSEW

   • 1 = always don't exclude, all data always save with project

2. @FSE=500(default) //500=500kb, save data if the file size is less than this value, for CSV, Excel and Import Filter connector

3. @FSEW=80(default) //in units of 100, save data if the size(rows x cols) of imported data is less then this value, for any web data and other files not listed above

   • 0 = never save web data